DBA Data[Home] [Help]

APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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