DBA Data[Home] [Help]

APPS.XDPCORE_ERROR dependencies on XDPCORE

Line 1: PACKAGE BODY XDPCORE_ERROR AS

1: PACKAGE BODY XDPCORE_ERROR AS
2: /* $Header: XDPCORRB.pls 120.2 2006/04/10 23:23:04 dputhiye noship $ */
3:
4:
5: /****

Line 74: wf_core.context('XDPCORE_ERROR', 'FE_ERR_NTF', itemtype, itemkey, to_char(actid), funcmode);

70: END IF;
71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: wf_core.context('XDPCORE_ERROR', 'FE_ERR_NTF', itemtype, itemkey, to_char(actid), funcmode);
75: raise;
76: END FE_ERR_NTF;
77:
78:

Line 110: wf_core.context('XDPCORE_ERROR', 'FE_ERROR_PROCESS_OPTIONS', itemtype, itemkey, to_char(actid), funcmode);

106:
107:
108: EXCEPTION
109: WHEN OTHERS THEN
110: wf_core.context('XDPCORE_ERROR', 'FE_ERROR_PROCESS_OPTIONS', itemtype, itemkey, to_char(actid), funcmode);
111: raise;
112: END FE_ERROR_PROCESS_OPTIONS;
113:
114:

Line 144: wf_core.context('XDPCORE_ERROR', 'PREPARE_ERROR_MESSAGE', itemtype, itemkey, to_char(actid), funcmode);

140:
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: wf_core.context('XDPCORE_ERROR', 'PREPARE_ERROR_MESSAGE', itemtype, itemkey, to_char(actid), funcmode);
145: raise;
146: END PREPARE_ERROR_MESSAGE;
147:
148:

Line 178: wf_core.context('XDPCORE_ERROR', 'NOTIFY_OUTSIDE_SYSTEM_OF_ERROR', itemtype, itemkey, to_char(actid), funcmode);

174:
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: wf_core.context('XDPCORE_ERROR', 'NOTIFY_OUTSIDE_SYSTEM_OF_ERROR', itemtype, itemkey, to_char(actid), funcmode);
179: raise;
180: END NOTIFY_OUTSIDE_SYSTEM_OF_ERROR;
181:
182: Procedure SET_ERROR_CONTEXT (itemtype in varchar2,

Line 205: wf_core.context('XDPCORE_ERROR', 'SET_ERROR_CONTEXT', itemtype, itemkey, to_char(actid), funcmode);

201:
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: wf_core.context('XDPCORE_ERROR', 'SET_ERROR_CONTEXT', itemtype, itemkey, to_char(actid), funcmode);
206: raise;
207: END SET_ERROR_CONTEXT;
208:
209: Procedure LOG_SESSION_ERROR( p_errory_type in varchar2)

Line 220: XDP_ERRORS_PKG.set_message( XDPCORE.object_type, XDPCORE.object_key, XDPCORE.error_name, XDPCORE.error_message, p_errory_type );

216: l_error_stack VARCHAR2(32000);
217:
218: BEGIN
219:
220: XDP_ERRORS_PKG.set_message( XDPCORE.object_type, XDPCORE.object_key, XDPCORE.error_name, XDPCORE.error_message, p_errory_type );
221:
222: EXCEPTION
223: WHEN others THEN
224: raise;

Line 314: x_Progress := 'XDPCORE_ERROR.FeErrorProcessOptions. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

310: return (l_ProcessOption);
311:
312: exception
313: when others then
314: x_Progress := 'XDPCORE_ERROR.FeErrorProcessOptions. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
315: wf_core.context('XDPCORE_ERROR', 'FeErrorProcessOptions', itemtype, itemkey, to_char(actid), x_Progress);
316: raise;
317: end FeErrorProcessOptions;
318:

Line 315: wf_core.context('XDPCORE_ERROR', 'FeErrorProcessOptions', itemtype, itemkey, to_char(actid), x_Progress);

311:
312: exception
313: when others then
314: x_Progress := 'XDPCORE_ERROR.FeErrorProcessOptions. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
315: wf_core.context('XDPCORE_ERROR', 'FeErrorProcessOptions', itemtype, itemkey, to_char(actid), x_Progress);
316: raise;
317: end FeErrorProcessOptions;
318:
319:

Line 431: aname => XDPCORE_FA.g_fp_name );

427: else
428: --unhandled exception..
429: lv_fp_name := wf_engine.GetItemAttrText(itemtype => PrepareErrorMessage.itemtype,
430: itemkey => PrepareErrorMessage.itemkey,
431: aname => XDPCORE_FA.g_fp_name );
432:
433: l_status := WF_ENGINE.GetActivityattrtext(itemtype =>PrepareErrorMessage.itemtype,
434: itemkey =>PrepareErrorMessage.itemkey,
435: actid =>PrepareErrorMessage.actid,

Line 472: --l_NtfDesc := l_NtfDesc || chr(10) || XDPCORE.error_stack;

468: FND_MESSAGE.SET_TOKEN('ERROR_DATE', to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
469: FND_MESSAGE.SET_TOKEN('ERROR_DESCRIPTION', substr(l_ErrorDesc,1,1000));
470:
471: l_NtfDesc := FND_MESSAGE.GET;
472: --l_NtfDesc := l_NtfDesc || chr(10) || XDPCORE.error_stack;
473:
474: --Date: 21-Feb-2005 Author:dputhiye Bug#:4112678 (Bug 3998762 on 11.5.9)
475: --l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || XDPCORE.error_stack;
476: --The source line commented above has been replaced with the line below.

Line 475: --l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || XDPCORE.error_stack;

471: l_NtfDesc := FND_MESSAGE.GET;
472: --l_NtfDesc := l_NtfDesc || chr(10) || XDPCORE.error_stack;
473:
474: --Date: 21-Feb-2005 Author:dputhiye Bug#:4112678 (Bug 3998762 on 11.5.9)
475: --l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || XDPCORE.error_stack;
476: --The source line commented above has been replaced with the line below.
477: --error_stack lengths during runtime can get to 32,000+ and must be truncated here to fit in l_NtfDesc.
478: --Length of the variable l_NtfDesc is 4000, and any change in the declaration must be reflected here.
479: l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || substr(XDPCORE.error_stack, 1, 3999 - length(l_NtfDesc));

Line 479: l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || substr(XDPCORE.error_stack, 1, 3999 - length(l_NtfDesc));

475: --l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || XDPCORE.error_stack;
476: --The source line commented above has been replaced with the line below.
477: --error_stack lengths during runtime can get to 32,000+ and must be truncated here to fit in l_NtfDesc.
478: --Length of the variable l_NtfDesc is 4000, and any change in the declaration must be reflected here.
479: l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || substr(XDPCORE.error_stack, 1, 3999 - length(l_NtfDesc));
480: --End of fix for 4112678
481:
482: -- clear the stack..
483: XDPCORE.error_stack := NULL;

Line 483: XDPCORE.error_stack := NULL;

479: l_NtfDesc := l_NtfDesc || fnd_global.local_chr(10) || substr(XDPCORE.error_stack, 1, 3999 - length(l_NtfDesc));
480: --End of fix for 4112678
481:
482: -- clear the stack..
483: XDPCORE.error_stack := NULL;
484:
485: wf_engine.SetItemAttrText(itemtype => PrepareErrorMessage.itemtype,
486: itemkey => PrepareErrorMessage.itemkey,
487: aname => 'NTF_BODY',

Line 491: l_WIResponsiblity := XDPCORE_WI.get_wi_responsibility( PrepareErrorMessage.itemtype,

487: aname => 'NTF_BODY',
488: avalue => substr(l_NtfDesc,1,1999));
489:
490: /* future functionality
491: l_WIResponsiblity := XDPCORE_WI.get_wi_responsibility( PrepareErrorMessage.itemtype,
492: PrepareErrorMessage.itemkey );
493:
494: wf_engine.SetItemAttrText(itemtype => PrepareErrorMessage.itemtype,
495: itemkey => PrepareErrorMessage.itemkey,

Line 502: x_progress := 'XDPCORE.ERROR.PrepareErrorMessage. Error when adding attribute dynamically. Error: ' ||

498: */
499:
500: exception
501: when e_AddAttrException then
502: x_progress := 'XDPCORE.ERROR.PrepareErrorMessage. Error when adding attribute dynamically. Error: ' ||
503: SUBSTR(ErrStr,1,1500);
504: wf_core.context('XDPCORE_ERROR', 'PrepareErrorMessage', itemtype, itemkey, null, x_Progress);
505: raise;
506:

Line 504: wf_core.context('XDPCORE_ERROR', 'PrepareErrorMessage', itemtype, itemkey, null, x_Progress);

500: exception
501: when e_AddAttrException then
502: x_progress := 'XDPCORE.ERROR.PrepareErrorMessage. Error when adding attribute dynamically. Error: ' ||
503: SUBSTR(ErrStr,1,1500);
504: wf_core.context('XDPCORE_ERROR', 'PrepareErrorMessage', itemtype, itemkey, null, x_Progress);
505: raise;
506:
507: when others then
508: x_Progress := 'XDPCORE_ERROR.PrepareErrorMessage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

Line 508: x_Progress := 'XDPCORE_ERROR.PrepareErrorMessage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

504: wf_core.context('XDPCORE_ERROR', 'PrepareErrorMessage', itemtype, itemkey, null, x_Progress);
505: raise;
506:
507: when others then
508: x_Progress := 'XDPCORE_ERROR.PrepareErrorMessage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
509: wf_core.context('XDPCORE_ERROR', 'PrepareErrorMessage', itemtype, itemkey, null, x_Progress);
510: raise;
511: end PrepareErrorMessage;
512:

Line 509: wf_core.context('XDPCORE_ERROR', 'PrepareErrorMessage', itemtype, itemkey, null, x_Progress);

505: raise;
506:
507: when others then
508: x_Progress := 'XDPCORE_ERROR.PrepareErrorMessage. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
509: wf_core.context('XDPCORE_ERROR', 'PrepareErrorMessage', itemtype, itemkey, null, x_Progress);
510: raise;
511: end PrepareErrorMessage;
512:
513:

Line 541: x_Progress := 'XDPCORE_ERROR.NotifyOutsideSystemOfError. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

537: null;
538:
539: exception
540: when others then
541: x_Progress := 'XDPCORE_ERROR.NotifyOutsideSystemOfError. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
542: wf_core.context('XDPCORE_ERROR', 'NotifyOutsideSystemOfError', itemtype, itemkey, to_char(actid), x_Progress);
543: raise;
544: end NotifyOutsideSystemOfError;
545:

Line 542: wf_core.context('XDPCORE_ERROR', 'NotifyOutsideSystemOfError', itemtype, itemkey, to_char(actid), x_Progress);

538:
539: exception
540: when others then
541: x_Progress := 'XDPCORE_ERROR.NotifyOutsideSystemOfError. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
542: wf_core.context('XDPCORE_ERROR', 'NotifyOutsideSystemOfError', itemtype, itemkey, to_char(actid), x_Progress);
543: raise;
544: end NotifyOutsideSystemOfError;
545:
546:

Line 564: x_Progress := 'XDPCORE_ERROR.FeErrorNotif. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

560: null;
561:
562: exception
563: when others then
564: x_Progress := 'XDPCORE_ERROR.FeErrorNotif. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
565: wf_core.context('XDPCORE_ERROR', 'FeErrorNotif', itemtype, itemkey, null, x_Progress);
566: raise;
567: end FeErrorNotif;
568:

Line 565: wf_core.context('XDPCORE_ERROR', 'FeErrorNotif', itemtype, itemkey, null, x_Progress);

561:
562: exception
563: when others then
564: x_Progress := 'XDPCORE_ERROR.FeErrorNotif. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
565: wf_core.context('XDPCORE_ERROR', 'FeErrorNotif', itemtype, itemkey, null, x_Progress);
566: raise;
567: end FeErrorNotif;
568:
569: Procedure SetErrorContext (itemtype in varchar2,

Line 624: l_wi_disp_name := XDPCORE_WI.get_display_name( l_WIInstaceID );

620: l_WIInstaceID := wf_engine.GetItemAttrNumber(itemtype => SetErrorContext.itemtype,
621: itemkey => SetErrorContext.itemkey,
622: aname => 'WORKITEM_INSTANCE_ID');
623:
624: l_wi_disp_name := XDPCORE_WI.get_display_name( l_WIInstaceID );
625:
626: FND_MESSAGE.SET_NAME('XDP','XDP_WI_DISP_NAME');
627: FND_MESSAGE.SET_TOKEN('WI', l_wi_disp_name);
628: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);

Line 656: l_fa_disp_name := XDPCORE_FA.get_display_name( l_FAInstanceID );

652: l_FAInstanceID := wf_engine.GetItemAttrNumber(itemtype => SetErrorContext.itemtype,
653: itemkey => SetErrorContext.itemkey,
654: aname => 'FA_INSTANCE_ID');
655:
656: l_fa_disp_name := XDPCORE_FA.get_display_name( l_FAInstanceID );
657:
658: FND_MESSAGE.SET_NAME('XDP','XDP_FA_DISP_NAME');
659: FND_MESSAGE.SET_TOKEN('FA', l_fa_disp_name);
660: --l_NtfBody := l_NtfBody || FND_MESSAGE.GET ||CHR(10);

Line 676: XDPCORE.get_error(l_object_type, l_object_key,

672: l_NtfBody := l_NtfBody || FND_MESSAGE.GET || fnd_global.local_CHR(10);
673:
674: l_NtfSubject := l_order_number||' ( '||l_order_version||' ):';
675: -- get error set in the context..
676: XDPCORE.get_error(l_object_type, l_object_key,
677: l_error_name, l_error_message, l_error_stack);
678:
679: -- get the translated message....
680: l_NtfSubject := l_NtfSubject || XDP_ERRORS_PKG.get_message( l_error_name, l_error_message );

Line 698: l_WIResponsiblity := XDPCORE_WI.get_wi_responsibility( SetErrorContext.itemtype,

694:
695: /*
696: -- In future we may want to send the notifications to the data entry folks registered while
697: -- creating the workitems...
698: l_WIResponsiblity := XDPCORE_WI.get_wi_responsibility( SetErrorContext.itemtype,
699: SetErrorContext.itemkey );
700:
701: IF l_WIResponsiblity is not null THEN
702: wf_engine.SetItemAttrText(itemtype => SetErrorContext.itemtype,

Line 712: x_Progress := 'XDPCORE_ERROR.SetErrorContext. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);

708:
709:
710: exception
711: when others then
712: x_Progress := 'XDPCORE_ERROR.SetErrorContext. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
713: wf_core.context('XDPCORE_ERROR', 'SetErrorContext', itemtype, itemkey, null, x_Progress);
714: raise;
715: end SetErrorContext;
716:

Line 713: wf_core.context('XDPCORE_ERROR', 'SetErrorContext', itemtype, itemkey, null, x_Progress);

709:
710: exception
711: when others then
712: x_Progress := 'XDPCORE_ERROR.SetErrorContext. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 1500);
713: wf_core.context('XDPCORE_ERROR', 'SetErrorContext', itemtype, itemkey, null, x_Progress);
714: raise;
715: end SetErrorContext;
716:
717:

Line 718: End XDPCORE_ERROR;

714: raise;
715: end SetErrorContext;
716:
717:
718: End XDPCORE_ERROR;