eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNP_WF_STANDARD dependencies on XNP_WF_STANDARD

Line 1: PACKAGE BODY XNP_WF_STANDARD AS

1: PACKAGE BODY XNP_WF_STANDARD AS
2: /* $Header: XNPWFACB.pls 120.0 2005/05/30 11:48:18 appldev noship $ */
3:
4:
5: -- Copies Item attributes defined in workflow to the equivalant

Line 45: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=

41: --
42: IF (command = 'SET_CTX') THEN
43:
44: -- set the context information
45: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
46: wf_engine.GetItemAttrNumber
47: (itemtype => itemtype
48: ,itemkey => itemkey
49: ,aname => 'WORKITEM_INSTANCE_ID'

Line 52: XNP_WF_STANDARD.g_ORDER_ID :=

48: ,itemkey => itemkey
49: ,aname => 'WORKITEM_INSTANCE_ID'
50: );
51:
52: XNP_WF_STANDARD.g_ORDER_ID :=
53: wf_engine.GetItemAttrNumber
54: (itemtype => itemtype
55: ,itemkey => itemkey
56: ,aname => 'ORDER_ID'

Line 67: XNP_WF_STANDARD.g_ORDER_ID :=

63: ELSIF (command = 'SET_ORD') THEN
64:
65: -- set the context information
66:
67: XNP_WF_STANDARD.g_ORDER_ID :=
68: wf_engine.GetItemAttrNumber
69: (itemtype => itemtype
70: ,itemkey => itemkey
71: ,aname => 'ORDER_ID'

Line 83: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=

79: ELSIF (command = 'SET_WI') THEN
80:
81: -- set the context information
82:
83: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
84: wf_engine.GetItemAttrNumber
85: (itemtype => itemtype
86: ,itemkey => itemkey
87: ,aname => 'WORKITEM_INSTANCE_ID'

Line 98: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=

94: ELSIF (command = 'SET_FA') THEN
95:
96: -- set the context information
97:
98: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
99: wf_engine.GetItemAttrNumber
100: (itemtype => itemtype
101: ,itemkey => itemkey
102: ,aname => 'FA_INSTANCE_ID'

Line 112: XNP_WF_STANDARD.g_ORDER_ID :=

108: ELSIF (command = 'SET_ORD_WI') THEN
109:
110: -- set the context information
111:
112: XNP_WF_STANDARD.g_ORDER_ID :=
113: wf_engine.GetItemAttrNumber
114: (itemtype => itemtype
115: ,itemkey => itemkey
116: ,aname => 'ORDER_ID'

Line 119: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=

115: ,itemkey => itemkey
116: ,aname => 'ORDER_ID'
117: );
118:
119: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
120: wf_engine.GetItemAttrNumber
121: (itemtype => itemtype
122: ,itemkey => itemkey
123: ,aname => 'WORKITEM_INSTANCE_ID'

Line 133: XNP_WF_STANDARD.g_ORDER_ID :=

129: ELSIF (command = 'SET_ORD_FA') THEN
130:
131: -- set the context information
132:
133: XNP_WF_STANDARD.g_ORDER_ID :=
134: wf_engine.GetItemAttrNumber
135: (itemtype => itemtype
136: ,itemkey => itemkey
137: ,aname => 'ORDER_ID'

Line 140: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=

136: ,itemkey => itemkey
137: ,aname => 'ORDER_ID'
138: );
139:
140: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
141: wf_engine.GetItemAttrNumber
142: (itemtype => itemtype
143: ,itemkey => itemkey
144: ,aname => 'FA_INSTANCE_ID'

Line 154: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=

150: ELSIF (command = 'SET_WI_FA') THEN
151:
152: -- set the context information
153:
154: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
155: wf_engine.GetItemAttrNumber
156: (itemtype => itemtype
157: ,itemkey => itemkey
158: ,aname => 'WORKITEM_INSTANCE_ID'

Line 161: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=

157: ,itemkey => itemkey
158: ,aname => 'WORKITEM_INSTANCE_ID'
159: );
160:
161: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
162: wf_engine.GetItemAttrNumber
163: (itemtype => itemtype
164: ,itemkey => itemkey
165: ,aname => 'FA_INSTANCE_ID'

Line 175: XNP_WF_STANDARD.g_ORDER_ID :=

171: ELSIF (command = 'SET_ORD_WI_FA') THEN
172:
173: -- set the context information
174:
175: XNP_WF_STANDARD.g_ORDER_ID :=
176: wf_engine.GetItemAttrNumber
177: (itemtype => itemtype
178: ,itemkey => itemkey
179: ,aname => 'ORDER_ID'

Line 182: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=

178: ,itemkey => itemkey
179: ,aname => 'ORDER_ID'
180: );
181:
182: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
183: wf_engine.GetItemAttrNumber
184: (itemtype => itemtype
185: ,itemkey => itemkey
186: ,aname => 'WORKITEM_INSTANCE_ID'

Line 189: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=

185: ,itemkey => itemkey
186: ,aname => 'WORKITEM_INSTANCE_ID'
187: );
188:
189: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
190: wf_engine.GetItemAttrNumber
191: (itemtype => itemtype
192: ,itemkey => itemkey
193: ,aname => 'FA_INSTANCE_ID'

Line 208: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=

204: IF (command = 'TEST_CTX' ) THEN
205:
206: -- set the context information
207:
208: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
209: wf_engine.GetItemAttrNumber
210: (itemtype => itemtype
211: ,itemkey => itemkey
212: ,aname => 'WORKITEM_INSTANCE_ID'

Line 215: XNP_WF_STANDARD.g_ORDER_ID :=

211: ,itemkey => itemkey
212: ,aname => 'WORKITEM_INSTANCE_ID'
213: );
214:
215: XNP_WF_STANDARD.g_ORDER_ID :=
216: wf_engine.GetItemAttrNumber
217: (itemtype => itemtype
218: ,itemkey => itemkey
219: ,aname => 'ORDER_ID'

Line 239: 'ERROR_LOCN','XNP_WF_STANDARD.SET_SDP_CONTEXT');

235: -- system in case of an exception
236: ------------------------------------------------------------------
237: fnd_message.set_name('XNP','STD_ERROR');
238: fnd_message.set_token(
239: 'ERROR_LOCN','XNP_WF_STANDARD.SET_SDP_CONTEXT');
240: fnd_message.set_token('ERROR_TEXT',
241: ':'||to_char(SQLCODE)||':'||SQLERRM);
242: x_progress := fnd_message.get;
243: wf_core.context(

Line 244: 'XNP_WF_STANDARD'

240: fnd_message.set_token('ERROR_TEXT',
241: ':'||to_char(SQLCODE)||':'||SQLERRM);
242: x_progress := fnd_message.get;
243: wf_core.context(
244: 'XNP_WF_STANDARD'
245: , 'SET_SDP_CONTEXT'
246: , itemtype
247: , itemkey
248: , to_char(actid)

Line 353: (P_PKG_NAME => 'XNP_WF_STANDARD'

349: x_progress := to_char(SQLCODE)||':'||SQLERRM;
350: END IF;
351:
352: XNP_UTILS.NOTIFY_ERROR
353: (P_PKG_NAME => 'XNP_WF_STANDARD'
354: ,P_PROC_NAME => 'SMS_CREATE_PORTED_NUMBER'
355: ,P_MSG_NAME => 'SMS_CREATE_PORTED_NUMBER_ERR'
356: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
357: ,P_TOK1 => 'ERROR_TEXT'

Line 453: (P_PKG_NAME => 'XNP_WF_STANDARD'

449: x_progress := to_char(SQLCODE)||':'||SQLERRM;
450: END IF;
451:
452: XNP_UTILS.NOTIFY_ERROR
453: (P_PKG_NAME => 'XNP_WF_STANDARD'
454: ,P_PROC_NAME => 'SMS_DELETE_PORTED_NUMBER'
455: ,P_MSG_NAME => 'SMS_DELETE_PORTED_NUMBER_ERR'
456: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
457: ,P_TOK1 => 'ERROR_TEXT'

Line 570: (P_PKG_NAME => 'XNP_WF_STANDARD'

566: x_progress := to_char(SQLCODE)||':'||SQLERRM;
567: END IF;
568:
569: XNP_UTILS.NOTIFY_ERROR
570: (P_PKG_NAME => 'XNP_WF_STANDARD'
571: ,P_PROC_NAME => 'SOA_UPDATE_CUTOFF_DATE'
572: ,P_MSG_NAME => 'SOA_UPDATE_CUTOFF_DATE_ERR'
573: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
574: ,P_TOK1 => 'ERROR_TEXT'

Line 691: (P_PKG_NAME => 'XNP_WF_STANDARD'

687: x_progress := to_char(SQLCODE)||':'||SQLERRM;
688: END IF;
689:
690: XNP_UTILS.NOTIFY_ERROR
691: (P_PKG_NAME => 'XNP_WF_STANDARD'
692: ,P_PROC_NAME => 'SOA_CREATE_PORTING_ORDER'
693: ,P_MSG_NAME => 'SOA_CREATE_PORTING_ORDER_ERR'
694: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
695: ,P_TOK1 => 'ERROR_TEXT'

Line 818: (P_PKG_NAME => 'XNP_WF_STANDARD'

814: x_progress := to_char(SQLCODE)||':'||SQLERRM;
815: END IF;
816:
817: XNP_UTILS.NOTIFY_ERROR
818: (P_PKG_NAME => 'XNP_WF_STANDARD'
819: ,P_PROC_NAME => 'SOA_UPDATE_SV_STATUS'
820: ,P_MSG_NAME => 'SOA_UPDATE_SV_STATUS_ERR'
821: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
822: ,P_TOK1 => 'ERROR_TEXT'

Line 925: (P_PKG_NAME => 'XNP_WF_STANDARD'

921: x_progress := to_char(SQLCODE)||':'||SQLERRM;
922: END IF;
923:
924: XNP_UTILS.NOTIFY_ERROR
925: (P_PKG_NAME => 'XNP_WF_STANDARD'
926: ,P_PROC_NAME => 'DETERMINE_SP_ROLE'
927: ,P_MSG_NAME => 'DETERMINE_SP_ROLE_ERR'
928: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
929: ,P_TOK1 => 'ERROR_TEXT'

Line 1098: (P_PKG_NAME => 'XNP_WF_STANDARD'

1094: x_progress := to_char(SQLCODE)||':'||SQLERRM;
1095: END IF;
1096:
1097: XNP_UTILS.NOTIFY_ERROR
1098: (P_PKG_NAME => 'XNP_WF_STANDARD'
1099: ,P_PROC_NAME => 'SUBSCRIBE_FOR_EVENT'
1100: ,P_MSG_NAME => 'SUBSCRIBE_FOR_EVENT_ERR'
1101: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
1102: ,P_TOK1 => 'ERROR_TEXT'

Line 1255: (P_PKG_NAME => 'XNP_WF_STANDARD'

1251: x_progress := to_char(SQLCODE)||':'||SQLERRM;
1252: END IF;
1253:
1254: XNP_UTILS.NOTIFY_ERROR
1255: (P_PKG_NAME => 'XNP_WF_STANDARD'
1256: ,P_PROC_NAME => 'SUBSCRIBE_FOR_ACKS'
1257: ,P_MSG_NAME => 'SUBSCRIBE_FOR_ACKS_ERR'
1258: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
1259: ,P_TOK1 => 'ERROR_TEXT'

Line 1403: (P_PKG_NAME => 'XNP_WF_STANDARD'

1399: x_progress := to_char(SQLCODE)||':'||SQLERRM;
1400: END IF;
1401:
1402: XNP_UTILS.NOTIFY_ERROR
1403: (P_PKG_NAME => 'XNP_WF_STANDARD'
1404: ,P_PROC_NAME => 'PREPARE_NOTIFICATION'
1405: ,P_MSG_NAME => 'PREPARE_NOTIFICATION_ERR'
1406: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
1407: ,P_TOK1 => 'ERROR_TEXT'

Line 1572: (P_PKG_NAME => 'XNP_WF_STANDARD'

1568: x_progress := to_char(SQLCODE)||':'||SQLERRM;
1569: END IF;
1570:
1571: XNP_UTILS.NOTIFY_ERROR
1572: (P_PKG_NAME => 'XNP_WF_STANDARD'
1573: ,P_PROC_NAME => 'EXECUTE_FA'
1574: ,P_MSG_NAME => 'EXECUTE_FA_ERR'
1575: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
1576: ,P_TOK1 => 'ERROR_TEXT'

Line 1732: (P_PKG_NAME => 'XNP_WF_STANDARD'

1728: x_progress := to_char(SQLCODE)||':'||SQLERRM;
1729: END IF;
1730:
1731: XNP_UTILS.NOTIFY_ERROR
1732: (P_PKG_NAME => 'XNP_WF_STANDARD'
1733: ,P_PROC_NAME => 'EXECUTE_FA'
1734: ,P_MSG_NAME => 'EXECUTE_FA_ERR'
1735: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
1736: ,P_TOK1 => 'ERROR_TEXT'

Line 1844: (P_PKG_NAME => 'XNP_WF_STANDARD'

1840: x_progress := to_char(SQLCODE)||':'||SQLERRM;
1841: END IF;
1842:
1843: XNP_UTILS.NOTIFY_ERROR
1844: (P_PKG_NAME => 'XNP_WF_STANDARD'
1845: ,P_PROC_NAME => 'SOA_CHECK_NOTIFY_DIR_SVS'
1846: ,P_MSG_NAME => 'SOA_CHECK_NOTIFY_DIR_SVS_ERR'
1847: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
1848: ,P_TOK1 => 'ERROR_TEXT'

Line 1958: (P_PKG_NAME => 'XNP_WF_STANDARD'

1954: x_progress := to_char(SQLCODE)||':'||SQLERRM;
1955: END IF;
1956:
1957: XNP_UTILS.NOTIFY_ERROR
1958: (P_PKG_NAME => 'XNP_WF_STANDARD'
1959: ,P_PROC_NAME => 'SOA_UPDATE_CHARGING_INFO'
1960: ,P_MSG_NAME => 'SOA_UPDATE_CHARGING_INFO_ERR'
1961: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
1962: ,P_TOK1 => 'ERROR_TEXT'

Line 2187: (P_PKG_NAME => 'XNP_WF_STANDARD'

2183: x_progress := to_char(SQLCODE)||':'||SQLERRM;
2184: END IF;
2185:
2186: XNP_UTILS.NOTIFY_ERROR
2187: (P_PKG_NAME => 'XNP_WF_STANDARD'
2188: ,P_PROC_NAME => 'SMS_PROVISION_NES'
2189: ,P_MSG_NAME => 'SMS_PROVISION_NES_ERR'
2190: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2191: ,P_TOK1 => 'ERROR_TEXT'

Line 2297: (P_PKG_NAME => 'XNP_WF_STANDARD'

2293: x_progress := to_char(SQLCODE)||':'||SQLERRM;
2294: END IF;
2295:
2296: XNP_UTILS.NOTIFY_ERROR
2297: (P_PKG_NAME => 'XNP_WF_STANDARD'
2298: ,P_PROC_NAME => 'SOA_CHECK_ORDER_STATUS'
2299: ,P_MSG_NAME => 'SOA_CHECK_ORDER_STATUS_ERR'
2300: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2301: ,P_TOK1 => 'ERROR_TEXT'

Line 2474: (P_PKG_NAME => 'XNP_WF_STANDARD'

2470: x_progress := to_char(SQLCODE)||':'||SQLERRM;
2471: END IF;
2472:
2473: XNP_UTILS.NOTIFY_ERROR
2474: (P_PKG_NAME => 'XNP_WF_STANDARD'
2475: ,P_PROC_NAME => 'PUBLISH_EVENT'
2476: ,P_MSG_NAME => 'PUBLISH_EVENT_ERR'
2477: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2478: ,P_TOK1 => 'ERROR_TEXT'

Line 2595: (P_PKG_NAME => 'XNP_WF_STANDARD'

2591: x_progress := to_char(SQLCODE)||':'||SQLERRM;
2592: END IF;
2593:
2594: XNP_UTILS.NOTIFY_ERROR
2595: (P_PKG_NAME => 'XNP_WF_STANDARD'
2596: ,P_PROC_NAME => 'CHECK_SOA_STATUS_EXISTS'
2597: ,P_MSG_NAME => 'CHECK_SOA_STATUS_EXISTS_ERR'
2598: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2599: ,P_TOK1 => 'ERROR_TEXT'

Line 2707: (P_PKG_NAME => 'XNP_WF_STANDARD'

2703: x_progress := to_char(SQLCODE)||':'||SQLERRM;
2704: END IF;
2705:
2706: XNP_UTILS.NOTIFY_ERROR
2707: (P_PKG_NAME => 'XNP_WF_STANDARD'
2708: ,P_PROC_NAME => 'SET_ORDER_RESULT'
2709: ,P_MSG_NAME => 'SET_ORDER_RESULT_ERR'
2710: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2711: ,P_TOK1 => 'ERROR_TEXT'

Line 2807: (P_PKG_NAME => 'XNP_WF_STANDARD'

2803: x_progress := to_char(SQLCODE)||':'||SQLERRM;
2804: END IF;
2805:
2806: XNP_UTILS.NOTIFY_ERROR
2807: (P_PKG_NAME => 'XNP_WF_STANDARD'
2808: ,P_PROC_NAME => 'SOA_IS_SUBSEQUENT_PORT'
2809: ,P_MSG_NAME => 'SOA_IS_SUBSEQUENT_PORT_ERR'
2810: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2811: ,P_TOK1 => 'ERROR_TEXT'

Line 3076: (P_PKG_NAME => 'XNP_WF_STANDARD'

3072: x_progress := to_char(SQLCODE)||':'||SQLERRM;
3073: END IF;
3074:
3075: XNP_UTILS.NOTIFY_ERROR
3076: (P_PKG_NAME => 'XNP_WF_STANDARD'
3077: ,P_PROC_NAME => 'SEND_MESSAGE'
3078: ,P_MSG_NAME => 'SEND_MESSAGE_ERR'
3079: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
3080: ,P_TOK1 => 'ERROR_TEXT'

Line 3285: (P_PKG_NAME => 'XNP_WF_STANDARD'

3281: x_progress := to_char(SQLCODE)||':'||SQLERRM;
3282: END IF;
3283:
3284: XNP_UTILS.NOTIFY_ERROR
3285: (P_PKG_NAME => 'XNP_WF_STANDARD'
3286: ,P_PROC_NAME => 'SMS_DEPROVISION_NES'
3287: ,P_MSG_NAME => 'SMS_DEPROVISION_NES_ERR'
3288: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
3289: ,P_TOK1 => 'ERROR_TEXT'

Line 3408: (P_PKG_NAME => 'XNP_WF_STANDARD'

3404: x_progress := to_char(SQLCODE)||':'||SQLERRM;
3405: END IF;
3406:
3407: XNP_UTILS.NOTIFY_ERROR
3408: (P_PKG_NAME => 'XNP_WF_STANDARD'
3409: ,P_PROC_NAME => 'SMS_DELETE_FE_MAP'
3410: ,P_MSG_NAME => 'SMS_DELETE_FE_MAP_ERR'
3411: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
3412: ,P_TOK1 => 'ERROR_TEXT'

Line 3546: (P_PKG_NAME => 'XNP_WF_STANDARD'

3542: x_progress := to_char(SQLCODE)||':'||SQLERRM;
3543: END IF;
3544:
3545: XNP_UTILS.NOTIFY_ERROR
3546: (P_PKG_NAME => 'XNP_WF_STANDARD'
3547: ,P_PROC_NAME => 'CHECK_PHASE_FOR_ROLE'
3548: ,P_MSG_NAME => 'CHECK_PHASE_FOR_ROLE_ERR'
3549: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
3550: ,P_TOK1 => 'ERROR_TEXT'

Line 3681: (P_PKG_NAME => 'XNP_WF_STANDARD'

3677: x_progress := to_char(SQLCODE)||':'||SQLERRM;
3678: END IF;
3679:
3680: XNP_UTILS.NOTIFY_ERROR
3681: (P_PKG_NAME => 'XNP_WF_STANDARD'
3682: ,P_PROC_NAME => 'SMS_UPDATE_FE_MAP_STATUS'
3683: ,P_MSG_NAME => 'SMS_UPDATE_FE_MAP_STATUS_ERR'
3684: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
3685: ,P_TOK1 => 'ERROR_TEXT'

Line 3765: 'ERROR_LOCN','XNP_WF_STANDARD.REJECT_MESSAGE');

3761: ------------------------------------------------------------------
3762:
3763: fnd_message.set_name('XNP','STD_ERROR');
3764: fnd_message.set_token(
3765: 'ERROR_LOCN','XNP_WF_STANDARD.REJECT_MESSAGE');
3766: fnd_message.set_token('ERROR_TEXT',
3767: ':'||to_char(SQLCODE)||':'||SQLERRM);
3768: x_progress := fnd_message.get;
3769: wf_core.context(

Line 3770: 'XNP_WF_STANDARD'

3766: fnd_message.set_token('ERROR_TEXT',
3767: ':'||to_char(SQLCODE)||':'||SQLERRM);
3768: x_progress := fnd_message.get;
3769: wf_core.context(
3770: 'XNP_WF_STANDARD'
3771: , 'REJECT_MESSAGE'
3772: ,itemtype
3773: , itemkey
3774: , to_char(actid)

Line 3846: 'ERROR_LOCN','XNP_WF_STANDARD.RETRY_MESSAGE');

3842: ------------------------------------------------------------------
3843:
3844: fnd_message.set_name('XNP','STD_ERROR');
3845: fnd_message.set_token(
3846: 'ERROR_LOCN','XNP_WF_STANDARD.RETRY_MESSAGE');
3847: fnd_message.set_token('ERROR_TEXT',
3848: ':'||to_char(SQLCODE)||':'||SQLERRM);
3849: x_progress := fnd_message.get;
3850: wf_core.context(

Line 3851: 'XNP_WF_STANDARD'

3847: fnd_message.set_token('ERROR_TEXT',
3848: ':'||to_char(SQLCODE)||':'||SQLERRM);
3849: x_progress := fnd_message.get;
3850: wf_core.context(
3851: 'XNP_WF_STANDARD'
3852: , 'RETRY_MESSAGE'
3853: ,itemtype
3854: , itemkey
3855: , to_char(actid)

Line 3925: wf_core.context('XNP_WF_STANDARD','WAITFORFLOW', itemtype, itemkey, to_char(actid), SUBSTR(SQLERRM,1,1500));

3921: END IF;
3922:
3923: EXCEPTION
3924: WHEN OTHERS THEN
3925: wf_core.context('XNP_WF_STANDARD','WAITFORFLOW', itemtype, itemkey, to_char(actid), SUBSTR(SQLERRM,1,1500));
3926: raise;
3927: END WAITFORFLOW;
3928:
3929:

Line 3972: wf_core.context('XNP_WF_STANDARD','CONTINUEFLOW', itemtype, itemkey, to_char(actid), SUBSTR(SQLERRM,1,1500));

3968: END IF;
3969:
3970: EXCEPTION
3971: WHEN OTHERS THEN
3972: wf_core.context('XNP_WF_STANDARD','CONTINUEFLOW', itemtype, itemkey, to_char(actid), SUBSTR(SQLERRM,1,1500));
3973: raise;
3974: END CONTINUEFLOW;
3975:
3976:

Line 4104: (P_PKG_NAME => 'XNP_WF_STANDARD'

4100: x_progress := to_char(SQLCODE)||':'||SQLERRM;
4101: END IF;
4102:
4103: XNP_UTILS.NOTIFY_ERROR
4104: (P_PKG_NAME => 'XNP_WF_STANDARD'
4105: ,P_PROC_NAME => 'SOA_SET_LOCKED_FLAG'
4106: ,P_MSG_NAME => 'SOA_SET_LOCKED_FLAG_ERR'
4107: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
4108: ,P_TOK1 => 'ERROR_TEXT'

Line 4225: (P_PKG_NAME => 'XNP_WF_STANDARD'

4221: x_progress := to_char(SQLCODE)||':'||SQLERRM;
4222: END IF;
4223:
4224: XNP_UTILS.NOTIFY_ERROR
4225: (P_PKG_NAME => 'XNP_WF_STANDARD'
4226: ,P_PROC_NAME => 'SOA_GET_LOCKED_FLAG'
4227: ,P_MSG_NAME => 'SOA_GET_LOCKED_FLAG_ERR'
4228: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
4229: ,P_TOK1 => 'ERROR_TEXT'

Line 4358: (P_PKG_NAME => 'XNP_WF_STANDARD'

4354: x_progress := to_char(SQLCODE)||':'||SQLERRM;
4355: END IF;
4356:
4357: XNP_UTILS.NOTIFY_ERROR
4358: (P_PKG_NAME => 'XNP_WF_STANDARD'
4359: ,P_PROC_NAME => 'SOA_CHECK_SV_STATUS'
4360: ,P_MSG_NAME => 'SOA_CHECK_SV_STATUS_ERR'
4361: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
4362: ,P_TOK1 => 'ERROR_TEXT'

Line 4477: (P_PKG_NAME => 'XNP_WF_STANDARD'

4473: x_progress := to_char(SQLCODE)||':'||SQLERRM;
4474: END IF;
4475:
4476: XNP_UTILS.NOTIFY_ERROR
4477: (P_PKG_NAME => 'XNP_WF_STANDARD'
4478: ,P_PROC_NAME => 'SOA_GET_SV_STATUS'
4479: ,P_MSG_NAME => 'SOA_GET_SV_STATUS_ERR'
4480: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
4481: ,P_TOK1 => 'ERROR_TEXT'

Line 4681: (P_PKG_NAME => 'XNP_WF_STANDARD'

4677: x_progress := to_char(SQLCODE)||':'||SQLERRM;
4678: END IF;
4679:
4680: XNP_UTILS.NOTIFY_ERROR
4681: (P_PKG_NAME => 'XNP_WF_STANDARD'
4682: ,P_PROC_NAME => 'SMS_MODIFY_NES'
4683: ,P_MSG_NAME => 'SMS_MODIFY_NES_ERR'
4684: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
4685: ,P_TOK1 => 'ERROR_TEXT'

Line 4789: (P_PKG_NAME => 'XNP_WF_STANDARD'

4785: x_progress := to_char(SQLCODE)||':'||SQLERRM;
4786: END IF;
4787:
4788: XNP_UTILS.NOTIFY_ERROR
4789: (P_PKG_NAME => 'XNP_WF_STANDARD'
4790: ,P_PROC_NAME => 'SMS_MODIFY_PORTED_NUMBER'
4791: ,P_MSG_NAME => 'SMS_MODIFY_PORTED_NUMBER_ERR'
4792: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
4793: ,P_TOK1 => 'ERROR_TEXT'

Line 4921: (P_PKG_NAME => 'XNP_WF_STANDARD'

4917: ELSE
4918: x_progress := to_char(SQLCODE)||':'||SQLERRM;
4919: END IF;
4920: XNP_UTILS.NOTIFY_ERROR
4921: (P_PKG_NAME => 'XNP_WF_STANDARD'
4922: ,P_PROC_NAME => 'SOA_UPDATE_NEW_SP_DUE_DATE'
4923: ,P_MSG_NAME => 'SOA_UPDATE_NEW_SP_DUE_DATE_ERR'
4924: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
4925: ,P_TOK1 => 'ERROR_TEXT'

Line 5054: (P_PKG_NAME => 'XNP_WF_STANDARD'

5050: ELSE
5051: x_progress := to_char(SQLCODE)||':'||SQLERRM;
5052: END IF;
5053: XNP_UTILS.NOTIFY_ERROR
5054: (P_PKG_NAME => 'XNP_WF_STANDARD'
5055: ,P_PROC_NAME => 'SOA_UPDATE_OLD_SP_DUE_DATE'
5056: ,P_MSG_NAME => 'SOA_UPDATE_OLD_SP_DUE_DATE_ERR'
5057: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
5058: ,P_TOK1 => 'ERROR_TEXT'

Line 5167: (P_PKG_NAME => 'XNP_WF_STANDARD'

5163: ELSE
5164: x_progress := to_char(SQLCODE)||':'||SQLERRM;
5165: END IF;
5166: XNP_UTILS.NOTIFY_ERROR
5167: (P_PKG_NAME => 'XNP_WF_STANDARD'
5168: ,P_PROC_NAME => 'SOA_CHECK_DON_STATUS_EXISTS'
5169: ,P_MSG_NAME => 'SOA_CHK_DON_STATUS_EXISTS_ERR'
5170: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
5171: ,P_TOK1 => 'ERROR_TEXT'

Line 5278: (P_PKG_NAME => 'XNP_WF_STANDARD'

5274: ELSE
5275: x_progress := to_char(SQLCODE)||':'||SQLERRM;
5276: END IF;
5277: XNP_UTILS.NOTIFY_ERROR
5278: (P_PKG_NAME => 'XNP_WF_STANDARD'
5279: ,P_PROC_NAME => 'SOA_CHECK_REC_STATUS_EXISTS'
5280: ,P_MSG_NAME => 'SOA_CHK_REC_STATUS_EXISTS_ERR'
5281: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
5282: ,P_TOK1 => 'ERROR_TEXT'

Line 5406: (P_PKG_NAME => 'XNP_WF_STANDARD'

5402: x_progress := to_char(SQLCODE)||':'||SQLERRM;
5403: END IF;
5404:
5405: XNP_UTILS.NOTIFY_ERROR
5406: (P_PKG_NAME => 'XNP_WF_STANDARD'
5407: ,P_PROC_NAME => 'SOA_UPD_PORTING_ID_STATUS'
5408: ,P_MSG_NAME => 'SOA_UPD_PORTING_ID_STATUS_ERR'
5409: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
5410: ,P_TOK1 => 'ERROR_TEXT'

Line 5606: (P_PKG_NAME => 'XNP_WF_STANDARD'

5602: x_progress := to_char(SQLCODE)||':'||SQLERRM;
5603: END IF;
5604:
5605: XNP_UTILS.NOTIFY_ERROR
5606: (P_PKG_NAME => 'XNP_WF_STANDARD'
5607: ,P_PROC_NAME => 'SOA_SET_FLAG_VALUE'
5608: ,P_MSG_NAME => 'SOA_SET_FLAG_VALUE_ERR'
5609: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
5610: ,P_TOK1 => 'ERROR_TEXT'

Line 5778: (P_PKG_NAME => 'XNP_WF_STANDARD'

5774: x_progress := to_char(SQLCODE)||':'||SQLERRM;
5775: END IF;
5776:
5777: XNP_UTILS.NOTIFY_ERROR
5778: (P_PKG_NAME => 'XNP_WF_STANDARD'
5779: ,P_PROC_NAME => 'SOA_GET_FLAG_VALUE'
5780: ,P_MSG_NAME => 'SOA_GET_FLAG_VALUE_ERR'
5781: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
5782: ,P_TOK1 => 'ERROR_TEXT'

Line 6023: (P_PKG_NAME => 'XNP_WF_STANDARD'

6019: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6020: END IF;
6021:
6022: XNP_UTILS.NOTIFY_ERROR
6023: (P_PKG_NAME => 'XNP_WF_STANDARD'
6024: ,P_PROC_NAME => 'SOA_UPDATE_DATE'
6025: ,P_MSG_NAME => 'SOA_UPDATE_DATE_ERR'
6026: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6027: ,P_TOK1 => 'ERROR_TEXT'

Line 6169: (P_PKG_NAME => 'XNP_WF_STANDARD'

6165: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6166: END IF;
6167:
6168: XNP_UTILS.NOTIFY_ERROR
6169: (P_PKG_NAME => 'XNP_WF_STANDARD'
6170: ,P_PROC_NAME => 'CHECK_IF_DONOR_CAN_PORT_OUT'
6171: ,P_MSG_NAME => 'CHECK_IF_SP_CAN_PORT_OUT_ERR'
6172: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6173: ,P_TOK1 => 'ERROR_TEXT'

Line 6313: (P_PKG_NAME => 'XNP_WF_STANDARD'

6309: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6310: END IF;
6311:
6312: XNP_UTILS.NOTIFY_ERROR
6313: (P_PKG_NAME => 'XNP_WF_STANDARD'
6314: ,P_PROC_NAME => 'CHECK_IF_DON_IS_INITIAL_DON'
6315: ,P_MSG_NAME => 'CHECK_IF_DON_IS_INIT_DON_ERR'
6316: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6317: ,P_TOK1 => 'ERROR_TEXT'

Line 6414: (P_PKG_NAME => 'XNP_WF_STANDARD'

6410: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6411: END IF;
6412:
6413: XNP_UTILS.NOTIFY_ERROR
6414: (P_PKG_NAME => 'XNP_WF_STANDARD'
6415: ,P_PROC_NAME => 'SOA_UPDATE_NOTES_INFO'
6416: ,P_MSG_NAME => 'SOA_UPDATE_NOTES_INFO_ERR'
6417: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6418: ,P_TOK1 => 'ERROR_TEXT'

Line 6514: (P_PKG_NAME => 'XNP_WF_STANDARD'

6510: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6511: END IF;
6512:
6513: XNP_UTILS.NOTIFY_ERROR
6514: (P_PKG_NAME => 'XNP_WF_STANDARD'
6515: ,P_PROC_NAME => 'SOA_UPDATE_NETWORK_INFO'
6516: ,P_MSG_NAME => 'SOA_UPDATE_NETWORK_INFO_ERR'
6517: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6518: ,P_TOK1 => 'ERROR_TEXT'

Line 6615: (P_PKG_NAME => 'XNP_WF_STANDARD'

6611: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6612: END IF;
6613:
6614: XNP_UTILS.NOTIFY_ERROR
6615: (P_PKG_NAME => 'XNP_WF_STANDARD'
6616: ,P_PROC_NAME => 'SOA_UPDATE_CUSTOMER_INFO'
6617: ,P_MSG_NAME => 'SOA_UPDATE_CUSTOMER_INFO_ERR'
6618: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6619: ,P_TOK1 => 'ERROR_TEXT'

Line 6725: (P_PKG_NAME => 'XNP_WF_STANDARD'

6721: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6722: END IF;
6723:
6724: XNP_UTILS.NOTIFY_ERROR
6725: (P_PKG_NAME => 'XNP_WF_STANDARD'
6726: ,P_PROC_NAME => 'PREPARE_CUSTOM_NOTFN'
6727: ,P_MSG_NAME => 'PREPARE_CUSTOM_NOTFN_ERR'
6728: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6729: ,P_TOK1 => 'ERROR_TEXT'

Line 6860: (P_PKG_NAME => 'XNP_WF_STANDARD'

6856: x_progress := to_char(SQLCODE)||':'||SQLERRM;
6857: END IF;
6858:
6859: XNP_UTILS.NOTIFY_ERROR
6860: (P_PKG_NAME => 'XNP_WF_STANDARD'
6861: ,P_PROC_NAME => 'SOA_UPDATE_CUR_SV_STATUS'
6862: ,P_MSG_NAME => 'SOA_UPDATE_SV_STATUS_ERR'
6863: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6864: ,P_TOK1 => 'ERROR_TEXT'

Line 6971: (P_PKG_NAME => 'XNP_WF_STANDARD'

6967: x_progress := to_char(l_error_code)||':'||l_error_message;
6968:
6969:
6970: XNP_UTILS.NOTIFY_ERROR
6971: (P_PKG_NAME => 'XNP_WF_STANDARD'
6972: ,P_PROC_NAME => 'SMS_UPDATE_PROV_DONE_DATE'
6973: ,P_MSG_NAME => 'SMS_UPDATE_PROV_DONE_DATE_ERR'
6974: ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
6975: ,P_TOK1 => 'ERROR_TEXT'

Line 7066: wf_core.context('XNP_WF_STANDARD', 'RUNTIME_VALIDATION', itemtype,

7062: IF l_ErrCode<>0 THEN
7063: raise e_Add_Item_Attr;
7064: END IF;
7065:
7066: wf_core.context('XNP_WF_STANDARD', 'RUNTIME_VALIDATION', itemtype,
7067: itemkey, null, l_error_message);
7068:
7069: ELSE
7070: -- Completion

Line 7100: wf_core.context('XNP_WF_STANDARD', 'RUNTIME_VALIDATION', itemtype,

7096: x_progress := to_char(SQLCODE)||':'||SQLERRM;
7097: END IF;
7098:
7099:
7100: wf_core.context('XNP_WF_STANDARD', 'RUNTIME_VALIDATION', itemtype,
7101: itemkey,null, x_progress);
7102: raise;
7103:
7104: END RUNTIME_VALIDATION;

Line 7189: wf_core.context('XNP_WF_STANDARD', 'SYNC_LI_PARAMETER_VALUES', itemtype,

7185: -- system in case of an exception
7186: ------------------------------------------------------------------
7187: x_progress := to_char(SQLCODE)||':'||SQLERRM;
7188:
7189: wf_core.context('XNP_WF_STANDARD', 'SYNC_LI_PARAMETER_VALUES', itemtype,
7190: itemkey,null, x_progress);
7191: raise;
7192: END SYNC_LI_PARAMETER_VALUES;
7193:

Line 7289: wf_core.context('XNP_WF_STANDARD', 'GET_ORD_FULFILLMENT_STATUS', itemtype,

7285: -- system in case of an exception
7286: ------------------------------------------------------------------
7287: x_progress := to_char(SQLCODE)||':'||SQLERRM;
7288:
7289: wf_core.context('XNP_WF_STANDARD', 'GET_ORD_FULFILLMENT_STATUS', itemtype,
7290: itemkey,null, x_progress);
7291: raise;
7292: END GET_ORD_FULFILLMENT_STATUS;
7293:

Line 7389: wf_core.context('XNP_WF_STANDARD', 'SET_ORD_FULFILLMENT_STATUS', itemtype,

7385: -- system in case of an exception
7386: ------------------------------------------------------------------
7387: x_progress := to_char(SQLCODE)||':'||SQLERRM;
7388:
7389: wf_core.context('XNP_WF_STANDARD', 'SET_ORD_FULFILLMENT_STATUS', itemtype,
7390: itemkey,null, x_progress);
7391: raise;
7392: END SET_ORD_FULFILLMENT_STATUS;
7393:

Line 7497: wf_core.context('XNP_WF_STANDARD', 'SET_WI_FULFILLMENT_STATUS', itemtype,

7493: ------------------------------------------------------------------
7494: x_progress := to_char(SQLCODE)||':'||SQLERRM;
7495:
7496:
7497: wf_core.context('XNP_WF_STANDARD', 'SET_WI_FULFILLMENT_STATUS', itemtype,
7498: itemkey,null, x_progress);
7499: raise;
7500: END SET_WI_FULFILLMENT_STATUS;
7501:

Line 7591: 'XNP_WF_STANDARD'

7587: ':'||to_char(SQLCODE)||':'||SQLERRM);
7588: end if;
7589: x_progress := fnd_message.get;
7590: wf_core.context(
7591: 'XNP_WF_STANDARD'
7592: , 'DEREGISTERALL'
7593: , itemtype
7594: , itemkey
7595: , to_char(actid)

Line 7650: wf_core.context('XNP_WF_STANDARD', 'downloadWIParams', null, null, null, l_WIInstanceID );

7646:
7647:
7648: EXCEPTION
7649: WHEN others THEN
7650: wf_core.context('XNP_WF_STANDARD', 'downloadWIParams', null, null, null, l_WIInstanceID );
7651: RAISE;
7652:
7653: END downloadWIParams;
7654:

Line 7706: wf_core.context('XNP_WF_STANDARD', 'downloadFAParams', null, null, null, p_FAInstanceID );

7702: END LOOP;
7703:
7704: EXCEPTION
7705: WHEN others THEN
7706: wf_core.context('XNP_WF_STANDARD', 'downloadFAParams', null, null, null, p_FAInstanceID );
7707: RAISE;
7708: END downloadFAParams;
7709:
7710:

Line 7757: wf_core.context('XNP_WF_STANDARD', 'uploadFAParams', null, null, null, p_FAInstanceID );

7753: END LOOP;
7754:
7755: EXCEPTION
7756: WHEN others THEN
7757: wf_core.context('XNP_WF_STANDARD', 'uploadFAParams', null, null, null, p_FAInstanceID );
7758: RAISE;
7759: END uploadFAParams;
7760:
7761:

Line 7762: END XNP_WF_STANDARD;

7758: RAISE;
7759: END uploadFAParams;
7760:
7761:
7762: END XNP_WF_STANDARD;
7763: