DBA Data[Home] [Help]

APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on FND_LOG

Line 102: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

98:
99: begin
100: g_objecttype := upper(p_objecttype);
101:
102: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
103: wf_log_pkg.string(wf_log_pkg.level_procedure,
104: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATESYNCCLOB.Begin',
105: 'Entered Create Sync Clob');
106: end if;

Line 206: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

202: l_clobsize integer := 0;
203: l_isExactNum integer := 1;
204:
205: begin
206: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
207: wf_log_pkg.string(wf_log_pkg.level_procedure,
208: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATEFILE.Begin',
209: 'Entered Create File');
210: end if;

Line 223: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

219:
220: wf_event_synchronize_pkg.CreateSyncClob(p_ObjectType, p_ObjectKey, l_isExactNum, null, l_clob);
221:
222: if (dbms_lob.getlength(l_clob) = 0) then
223: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
224: wf_log_pkg.string(wf_log_pkg.level_statement,
225: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATEFILE.Clob_Size',
226: 'l_clob null');
227: end if;

Line 230: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

226: 'l_clob null');
227: end if;
228: end if;
229:
230: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
231: wf_log_pkg.string(wf_log_pkg.level_statement,
232: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATEFILE.Create',
233: 'Calling to CreateClob File');
234: end if;

Line 269: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

265: l_begin_position integer := 0;
266: l_end_position integer := 0;
267:
268: begin
269: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
270: wf_log_pkg.string(wf_log_pkg.level_procedure,
271: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATECLOBFILE.Begin',
272: 'Entered Create Clob File: '||p_Directory||'-'||p_Filename);
273: end if;

Line 277: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

273: end if;
274:
275: l_filehandle := UTL_FILE.FOPEN(p_Directory, p_Filename,'w');
276:
277: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
278: wf_log_pkg.string(wf_log_pkg.level_statement,
279: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATECLOBFILE.file_handle',
280: 'Got file handle');
281: end if;

Line 408: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

404:
405: --
406: -- We have the Clob
407: --
408: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
409: wf_log_pkg.string(wf_log_pkg.level_statement,
410: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.UPLOADFILE.file_size',
411: 'Clob Size is:'||l_clobsize);
412: wf_log_pkg.string(wf_log_pkg.level_statement,

Line 484: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

480:
481: l_begin_position := dbms_lob.instr(p_eventdata, g_begin_string,
482: 1, l_counter);
483:
484: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
485: -- This is for logging only
486: -- BINDVAR_SCAN_IGNORE[3]
487: wf_log_pkg.string(wf_log_pkg.level_statement,
488: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.UPLOADSYNCCLOB.pos',

Line 507: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

503:
504: l_messagedata := dbms_lob.substr(p_eventdata, l_amount_to_read,
505: l_begin_position);
506:
507: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
508: wf_log_pkg.string(wf_log_pkg.level_statement,
509: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.UPLOADSYNCCLOB.data',
510: 'Message Data: '||substr(l_messagedata,1,100));
511: end if;

Line 518: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

514: -- Get Object Type, and then call to UploadObject
515: --
516: l_objecttype := wf_event_synchronize_pkg.GetObjectType(l_messagedata);
517:
518: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
519: wf_log_pkg.string(wf_log_pkg.level_statement,
520: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.UPLOADSYNCCLOB.object',
521: 'Object Type: '||l_objecttype);
522: end if;

Line 614: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

610: ELSE
611: l_guid := hextoraw(null);
612: END IF;
613:
614: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
615: wf_log_pkg.string(wf_log_pkg.level_procedure,
616: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETAGENTS.Begin',
617: 'Entered GetAgents');
618: end if;

Line 630: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

626: -- Get our XML document
627: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.agent.update', g.guid);
628:
629: if (p_isexact = false) then
630: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
631: wf_log_pkg.string(wf_log_pkg.level_statement,
632: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETAGENTS.set_pound',
633: 'Substitute with pounds.');
634: end if;

Line 1011: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1007: ELSE
1008: l_guid := hextoraw(null);
1009: END IF;
1010:
1011: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1012: wf_log_pkg.string(wf_log_pkg.level_procedure,
1013: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETSUBSCRIPTIONS.Begin',
1014: 'Entered GetSubscriptions');
1015: end if;

Line 1027: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1023: -- Get our XML document
1024: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.subscription.update', g.guid);
1025:
1026: if (p_isexact = false) then
1027: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1028: wf_log_pkg.string(wf_log_pkg.level_statement,
1029: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETSUBSCRIPTIONS.set_pound',
1030: 'Substitute with pounds.');
1031: end if;

Line 1584: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1580: beg_pos number default 0;
1581: end_pos number default 0;
1582:
1583: begin
1584: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1585: wf_log_pkg.string(wf_log_pkg.level_procedure,
1586: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.SETPOUND.Begin',
1587: 'Entered SetPound.');
1588: end if;

Line 1650: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1646: end_pos number default 0;
1647: endTagLen number default 3; -- ''
1648:
1649: begin
1650: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1651: wf_log_pkg.string(wf_log_pkg.level_procedure,
1652: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.SETNULL.Begin',
1653: 'Entered SetNull.');
1654: end if;

Line 1691: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1687: P_OUTCLOB out nocopy clob
1688: ) is
1689: begin
1690:
1691: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1692: wf_log_pkg.string(wf_log_pkg.level_procedure,
1693: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATEEMPTYCLOB.Begin',
1694: 'Entered Create Empty Clob');
1695: end if;