[Home] [Help]
102: * Write immediate validation messages to the common
103: * application logs. Write deferred validation messages
104: * to the concurrent manager log file.
105: *
106: * If FND_GLOBAL.conc_request_id is -1, it implies that
107: * this method has not been invoked via the concurrent
108: * manager (online validation case; write to apps log).
109: */
110: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
108: * manager (online validation case; write to apps log).
109: */
110: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111:
112: IF (FND_GLOBAL.conc_request_id = -1) THEN
113:
114: /*
115: * OPTION I:
116: * Write debug text to the common application log file.
229: /*
230: * Do not attempt to print XML clob unless it contains
231: * CR-LFs.
232: */
233: IF (DBMS_LOB.INSTR(p_xml_clob, fnd_global.local_chr(10)) = 0) THEN
234:
235: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
236: print_debuginfo(l_module_name, 'Clob does not contain '
237: || 'CR-LFs; cannot print entire XML Clob, '
255:
256: EXIT WHEN l_xmlstr IS NULL;
257:
258: l_line := SUBSTR(l_xmlstr,1,INSTR(l_xmlstr,
259: fnd_global.local_chr(10))-1);
260:
261: IF (l_line IS NOT NULL) THEN
262:
263: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
264: print_debuginfo('', l_line);
265:
266: END IF;
267: l_xmlstr := SUBSTR(l_xmlstr,INSTR(l_xmlstr,
268: fnd_global.local_chr(10))+1);
269:
270: ELSE
271:
272: /*
1599: IBY_TRANSACTION_ERRORS err
1600: SET
1601: err.error_status = 'INACTIVE',
1602: err.last_update_date = sysdate,
1603: err.last_updated_by = fnd_global.user_id
1604: WHERE
1605: err.transaction_id = p_trxn_id AND
1606: err.transaction_type = p_trxn_type
1607: ;
1626: IBY_TRANSACTION_ERRORS err
1627: SET
1628: err.error_status = 'INACTIVE',
1629: err.last_update_date = sysdate,
1630: err.last_updated_by = fnd_global.user_id
1631: WHERE
1632: err.transaction_id IN
1633: (
1634: SELECT