DBA Data[Home] [Help]

APPS.ITG_WF_UTILS dependencies on ITG_DEBUG_PUB

Line 29: itg_debug_pub.Add('--- Entering create_outbound_collaboration ---' ,2);

25: l_xml_event_key VARCHAR2(100);
26: l_buff VARCHAR2(2000);
27: BEGIN
28: IF (l_Debug_Level <= 2) THEN
29: itg_debug_pub.Add('--- Entering create_outbound_collaboration ---' ,2);
30: END IF;
31:
32: IF funcmode = 'RUN' THEN
33: IF NOT itg_x_utils.g_initialized THEN

Line 108: itg_debug_pub.Add('--- Exting create_outbound_collaboration ---' ,2);

104: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
105: END IF;
106:
107: IF (l_Debug_Level <= 2) THEN
108: itg_debug_pub.Add('--- Exting create_outbound_collaboration ---' ,2);
109: END IF;
110: RETURN;
111: END IF;
112: EXCEPTION

Line 118: itg_debug_pub.Add('--- Exting create_outbound_collaboration : ERROR---' ,6);

114: WF_CORE.CONTEXT('itg_wf_utils', 'create_outbound_collaboration',
115: itemtype, itemkey, to_char(actid), funcmode
116: );
117: IF (l_Debug_Level <= 6) THEN
118: itg_debug_pub.Add('--- Exting create_outbound_collaboration : ERROR---' ,6);
119: END IF;
120: RAISE;
121: END create_outbound_collaboration;
122:

Line 150: itg_debug_pub.Add('--- Entering update_outbound_collaboration ---' ,2);

146: l_xmlg_msg_id VARCHAR2(100);
147:
148: BEGIN
149: IF (l_Debug_Level <= 2) THEN
150: itg_debug_pub.Add('--- Entering update_outbound_collaboration ---' ,2);
151: END IF;
152:
153: IF funcmode = 'RUN' THEN
154: IF NOT itg_x_utils.g_initialized THEN

Line 218: itg_debug_pub.Add('--- Exting update_outbound_collaboration ---' ,2);

214: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
215: END IF;
216:
217: IF (l_Debug_Level <= 2) THEN
218: itg_debug_pub.Add('--- Exting update_outbound_collaboration ---' ,2);
219: END IF;
220: RETURN;
221: END IF;
222: EXCEPTION

Line 228: itg_debug_pub.Add('--- Exting update_outbound_collaboration :ERROR---' ,6);

224: WF_CORE.CONTEXT('itg_wf_utils', 'update_outbound_collaboration',
225: itemtype, itemkey, to_char(actid), funcmode);
226:
227: IF (l_Debug_Level <= 6) THEN
228: itg_debug_pub.Add('--- Exting update_outbound_collaboration :ERROR---' ,6);
229: END IF;
230:
231: RAISE;
232: END update_outbound_collaboration;

Line 265: itg_debug_pub.Add('--- Entering update_outbound_collab_cbod ---' ,2);

261: l_return_status VARCHAR2(1);
262: l_buff VARCHAR2(2000);
263: BEGIN
264: IF (l_Debug_Level <= 2) THEN
265: itg_debug_pub.Add('--- Entering update_outbound_collab_cbod ---' ,2);
266: END IF;
267:
268: IF funcmode = 'RUN' THEN
269: l_lang := wf_engine.GetItemAttrText(itemtype,itemkey,'SESSION_LANGUAGE',TRUE);

Line 279: itg_debug_pub.Add('NLS langauage '||l_nls_lang ,1);

275: from fnd_languages
276: where language_code = l_lang;
277:
278: IF (l_Debug_Level <= 1) THEN
279: itg_debug_pub.Add('NLS langauage '||l_nls_lang ,1);
280: END IF;
281:
282: FND_GLOBAL.set_nls_context(p_nls_language => l_nls_lang);
283:

Line 285: itg_debug_pub.Add('NLS context is switched' ,1);

281:
282: FND_GLOBAL.set_nls_context(p_nls_language => l_nls_lang);
283:
284: IF (l_Debug_Level <= 1) THEN
285: itg_debug_pub.Add('NLS context is switched' ,1);
286: END IF;
287: EXCEPTION
288: WHEN OTHERS THEN
289: IF (l_Debug_Level <= 5) THEN

Line 290: itg_debug_pub.Add('Error changing session language to '|| l_lang ,5);

286: END IF;
287: EXCEPTION
288: WHEN OTHERS THEN
289: IF (l_Debug_Level <= 5) THEN
290: itg_debug_pub.Add('Error changing session language to '|| l_lang ,5);
291: itg_debug_pub.Add(SQLCODE || ' - ' || SQLERRM ,5);
292: END IF;
293: END;
294: END IF;

Line 291: itg_debug_pub.Add(SQLCODE || ' - ' || SQLERRM ,5);

287: EXCEPTION
288: WHEN OTHERS THEN
289: IF (l_Debug_Level <= 5) THEN
290: itg_debug_pub.Add('Error changing session language to '|| l_lang ,5);
291: itg_debug_pub.Add(SQLCODE || ' - ' || SQLERRM ,5);
292: END IF;
293: END;
294: END IF;
295:

Line 367: itg_debug_pub.Add('--- Exiting update_outbound_collab_cbod ---' ,2);

363: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
364: END IF;
365:
366: IF (l_Debug_Level <= 2) THEN
367: itg_debug_pub.Add('--- Exiting update_outbound_collab_cbod ---' ,2);
368: END IF;
369: RETURN;
370: END IF;
371: EXCEPTION

Line 376: itg_debug_pub.Add('--- Exting update_outbound_collab_cbod :ERROR---' ,6);

372: WHEN OTHERS THEN
373: WF_CORE.CONTEXT('itg_wf_utils', 'update_outbound_collaboration cbod',
374: itemtype, itemkey, to_char(actid), funcmode);
375: IF (l_Debug_Level <= 6) THEN
376: itg_debug_pub.Add('--- Exting update_outbound_collab_cbod :ERROR---' ,6);
377: END IF;
378: RAISE;
379: END update_outbound_collab_cbod;
380:

Line 406: itg_debug_pub.Add('--- Entering update_set_cbod_description ---' ,2);

402: parameter5 varchar2(1000);
403: l_cbod_message varchar2(2000);
404: BEGIN
405: IF (l_Debug_Level <= 2) THEN
406: itg_debug_pub.Add('--- Entering update_set_cbod_description ---' ,2);
407: END IF;
408:
409: parameter5 := wf_engine.GetItemAttrText(itemtype,itemkey,'PARAMETER5',TRUE);
410: parameter7 := wf_engine.GetItemAttrText(itemtype,itemkey,'PARAMETER7',TRUE);

Line 413: itg_debug_pub.Add('Parameter5 - ' || parameter5 ,1);

409: parameter5 := wf_engine.GetItemAttrText(itemtype,itemkey,'PARAMETER5',TRUE);
410: parameter7 := wf_engine.GetItemAttrText(itemtype,itemkey,'PARAMETER7',TRUE);
411:
412: IF (l_Debug_Level <= 1) THEN
413: itg_debug_pub.Add('Parameter5 - ' || parameter5 ,1);
414: itg_debug_pub.Add('Parameter7 - ' || parameter7 ,1);
415: END IF;
416:
417: BEGIN

Line 414: itg_debug_pub.Add('Parameter7 - ' || parameter7 ,1);

410: parameter7 := wf_engine.GetItemAttrText(itemtype,itemkey,'PARAMETER7',TRUE);
411:
412: IF (l_Debug_Level <= 1) THEN
413: itg_debug_pub.Add('Parameter5 - ' || parameter5 ,1);
414: itg_debug_pub.Add('Parameter7 - ' || parameter7 ,1);
415: END IF;
416:
417: BEGIN
418: SELECT NLS_LANGUAGE

Line 425: itg_debug_pub.Add('l_nls_language - ' || l_nls_language ,1);

421: WHERE LANGUAGE_CODE = parameter5
422: AND installed_flag in ('B','I') ;
423:
424: IF (l_Debug_Level <= 1) THEN
425: itg_debug_pub.Add('l_nls_language - ' || l_nls_language ,1);
426: END IF;
427:
428: l_lang := FND_GLOBAL.CURRENT_LANGUAGE;
429:

Line 431: itg_debug_pub.Add('l_lang - ' || l_lang ,1);

427:
428: l_lang := FND_GLOBAL.CURRENT_LANGUAGE;
429:
430: IF (l_Debug_Level <= 1) THEN
431: itg_debug_pub.Add('l_lang - ' || l_lang ,1);
432: END IF;
433:
434: FND_GLOBAL.set_nls_context(p_nls_language => l_nls_language);
435:

Line 437: itg_debug_pub.Add('set_nls_context SET' ,1);

433:
434: FND_GLOBAL.set_nls_context(p_nls_language => l_nls_language);
435:
436: IF (l_Debug_Level <= 1) THEN
437: itg_debug_pub.Add('set_nls_context SET' ,1);
438: END IF;
439:
440: wf_engine.SetItemAttrText(itemtype,itemkey,'SESSION_LANGUAGE',l_lang);
441:

Line 443: itg_debug_pub.Add('SetItemAttrText - SESSION_LANGUAGE SET ');

439:
440: wf_engine.SetItemAttrText(itemtype,itemkey,'SESSION_LANGUAGE',l_lang);
441:
442: IF (l_Debug_Level <= 1) THEN
443: itg_debug_pub.Add('SetItemAttrText - SESSION_LANGUAGE SET ');
444: END IF;
445:
446: EXCEPTION
447: WHEN OTHERS THEN

Line 449: itg_debug_pub.Add('Exception lang - '|| parameter5 || SQLCODE || '-' ||SQLERRM, 1);

445:
446: EXCEPTION
447: WHEN OTHERS THEN
448: IF (l_Debug_Level <= 1) THEN
449: itg_debug_pub.Add('Exception lang - '|| parameter5 || SQLCODE || '-' ||SQLERRM, 1);
450: END IF;
451: null; -- if any error, continue to use current session langauge.
452: END;
453:

Line 457: itg_debug_pub.Add('l_cbod_message' || l_cbod_message ,1);

453:
454: l_cbod_message := itg_x_utils.translateCBODDescMsg(p_msg_list=> parameter7);
455:
456: IF (l_Debug_Level <= 1) THEN
457: itg_debug_pub.Add('l_cbod_message' || l_cbod_message ,1);
458: END IF;
459:
460: wf_engine.SetItemAttrText(itemtype,itemkey,'PARAMETER7',l_cbod_message);
461: resultout := 'COMPLETED';

Line 464: itg_debug_pub.Add('--- Exiting update_set_cbod_description ---' ,2);

460: wf_engine.SetItemAttrText(itemtype,itemkey,'PARAMETER7',l_cbod_message);
461: resultout := 'COMPLETED';
462:
463: IF (l_Debug_Level <= 2) THEN
464: itg_debug_pub.Add('--- Exiting update_set_cbod_description ---' ,2);
465: END IF;
466: EXCEPTION
467: WHEN OTHERS THEN
468: WF_CORE.CONTEXT('itg_wf_utils', 'set_cbod_description',

Line 471: itg_debug_pub.Add('--- Exting set_cbod_description :ERROR---' ,6);

467: WHEN OTHERS THEN
468: WF_CORE.CONTEXT('itg_wf_utils', 'set_cbod_description',
469: itemtype, itemkey, to_char(actid), funcmode);
470: IF (l_Debug_Level <= 6) THEN
471: itg_debug_pub.Add('--- Exting set_cbod_description :ERROR---' ,6);
472: END IF;
473:
474: RAISE;
475: END;