忙里偷闲

很多事情很多心情写了也就记下了; 不写,以后可能就忘了.
个人资料
正文

A good way to set the concurrent program status

(2014-10-08 08:56:07) 下一个
A good way to set the concurrent program status:
fnd_concurrent.set_completion_status
Example:
 IF (g_import_request_id = 0) THEN
                 fnd_file.put_line(FND_FILE.Log, fnd_message.get);
                      GL_MESSAGE.WRITE_LOG('LEZS0001');
                      IF (fnd_concurrent.set_completion_status('ERROR', fnd_message.get)) THEN
                           null;
                      END IF;
 ELSE
                   IF P_status = 'W' THEN
                       fnd_file.put_line(FND_FILE.Log, 'Journal Import program completed with Warning. Please fix error in interface and manually submit the journal import program!');
                      GL_MESSAGE.WRITE_LOG('LEZS0002');
                      IF (fnd_concurrent.set_completion_status('WARNING', 'Journal Import program completed with Warning. Please fix error in interface and manually submit the journal import program!')) THEN
                           null;
                      END IF;
                    ELSE
                      fnd_file.put_line(FND_FILE.output,' REQ_ID=' || TO_CHAR(g_import_request_id) || ' Job completed with status ' || s_dev_status || '. Message: ' || s_message);
                      GL_MESSAGE.WRITE_LOG('LEZS0000', 1, 'REQ_ID', TO_CHAR(g_import_request_id));
                      IF (fnd_concurrent.set_completion_status('NORMAL', NULL)) THEN
                           null;
                      END IF;
                    END IF;
   END IF;
[ 打印 ]
阅读 ()评论 (1)
评论
五弟五哥 回复 悄悄话 这丫头,弄这么难的东东给俺瞧,看不懂啊。
登录后才可评论.