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 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 261: -- Calls XNP_STANDARD.SMS_CREATE_PORTED_NUMBER

257: -- Called when: there is a Create Ported Number
258: -- request from NRC
259: -- Description:
260: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
261: -- Calls XNP_STANDARD.SMS_CREATE_PORTED_NUMBER
262: ------------------------------------------------------------------
263: PROCEDURE SMS_CREATE_PORTED_NUMBER
264: (ITEMTYPE IN VARCHAR2
265: ,ITEMKEY IN VARCHAR2

Line 304: XNP_STANDARD.SMS_CREATE_PORTED_NUMBER

300:
301: l_ORDER_ID := g_ORDER_ID;
302: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
303:
304: XNP_STANDARD.SMS_CREATE_PORTED_NUMBER
305: (l_ORDER_ID ,
306: l_LINEITEM_ID ,
307: l_WORKITEM_INSTANCE_ID,
308: l_FA_INSTANCE_ID,

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 370: -- Calls XNP_STANDARD.SMS_DELETE_PORTED_NUMBER

366: -- Called when: there is a Delete Ported Number request
367: -- from NRC
368: -- Description:
369: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
370: -- Calls XNP_STANDARD.SMS_DELETE_PORTED_NUMBER
371: ------------------------------------------------------------------
372: PROCEDURE SMS_DELETE_PORTED_NUMBER
373: (ITEMTYPE IN VARCHAR2
374: ,ITEMKEY IN VARCHAR2

Line 408: XNP_STANDARD.SMS_DELETE_PORTED_NUMBER

404: -- The run code
405:
406: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
407:
408: XNP_STANDARD.SMS_DELETE_PORTED_NUMBER
409: (l_WORKITEM_INSTANCE_ID
410: ,l_error_code
411: ,l_error_message
412: );

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 469: -- Calls XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE

465: --------------------------------------------------------------------
466: -- Called when: response to OMS's portin req to peer +B1
467: -- Description:
468: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
469: -- Calls XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE
470: ------------------------------------------------------------------
471: PROCEDURE SOA_UPDATE_CUTOFF_DATE
472: (ITEMTYPE IN VARCHAR2
473: ,ITEMKEY IN VARCHAR2

Line 520: XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE

516: itemkey => itemkey,
517: actid => actid,
518: aname => 'CUR_STATUS_TYPE_CODE');
519:
520: XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE
521: (l_ORDER_ID ,
522: L_LINEITEM_ID,
523: l_WORKITEM_INSTANCE_ID,
524: l_FA_INSTANCE_ID,

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 587: -- Calls XNP_STANDARD.SOA_CREATE_PORTING_ORDER

583: -- Called when: When there is a Porting Order from OMS
584: -- and the
585: -- Description:
586: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
587: -- Calls XNP_STANDARD.SOA_CREATE_PORTING_ORDER
588: ------------------------------------------------------------------
589: PROCEDURE SOA_CREATE_PORTING_ORDER
590: (ITEMTYPE IN VARCHAR2
591: ,ITEMKEY IN VARCHAR2

Line 640: XNP_STANDARD.SOA_CREATE_PORTING_ORDER

636: IF (l_sp_role IS NULL) THEN
637: raise e_SOA_CREATE_PORTING_ORDER;
638: END IF;
639:
640: XNP_STANDARD.SOA_CREATE_PORTING_ORDER
641: (l_ORDER_ID,
642: l_LINEITEM_ID,
643: l_WORKITEM_INSTANCE_ID,
644: l_FA_INSTANCE_ID,

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 708: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS

704: -- Called when: need to update the SV status according
705: -- to the activity parameter SV_STATUS
706: -- Description:
707: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
708: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS
709: ------------------------------------------------------------------
710: PROCEDURE SOA_UPDATE_SV_STATUS
711: (ITEMTYPE IN VARCHAR2
712: ,ITEMKEY IN VARCHAR2

Line 766: XNP_STANDARD.SOA_UPDATE_SV_STATUS

762: itemkey => itemkey,
763: actid => actid,
764: aname => 'STATUS_CHANGE_CAUSE_CODE');
765:
766: XNP_STANDARD.SOA_UPDATE_SV_STATUS
767: (p_ORDER_ID => l_ORDER_ID ,
768: p_LINEITEM_ID => l_LINEITEM_ID,
769: p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID,
770: p_FA_INSTANCE_ID => l_FA_INSTANCE_ID,

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 835: -- Calls XNP_STANDARD.SOA_CHECK_IF_INITIAL_DONOR

831: -- Called when: donor needs to check if initial donor
832: -- for the TN range
833: -- Description:
834: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
835: -- Calls XNP_STANDARD.SOA_CHECK_IF_INITIAL_DONOR
836: -- Sets the RESULTOUT based on the result
837: ------------------------------------------------------------------
838: PROCEDURE DETERMINE_SP_ROLE
839: (ITEMTYPE IN VARCHAR2

Line 874: XNP_STANDARD.DETERMINE_SP_ROLE

870: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
871:
872: -- Check to see if initial donor
873:
874: XNP_STANDARD.DETERMINE_SP_ROLE
875: (l_WORKITEM_INSTANCE_ID
876: ,l_SP_ROLE
877: ,l_error_code
878: ,l_error_message

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 1044: XNP_STANDARD.SUBSCRIBE_FOR_EVENT

1040:
1041: ------------------------------------------------------------------
1042: -- Subscribe for this event
1043: ------------------------------------------------------------------
1044: XNP_STANDARD.SUBSCRIBE_FOR_EVENT
1045: (p_MESSAGE_TYPE=>l_MESSAGE_TYPE
1046: ,p_WORKITEM_INSTANCE_ID=>l_WORKITEM_INSTANCE_ID
1047: ,p_CALLBACK_REF_ID=>l_CALLBACK_REF_ID
1048: ,p_PROCESS_REFERENCE=>l_PROCESS_REFERENCE

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 1112: -- Calls XNP_STANDARD SUBSCRIBE_FOR_ACKS

1108:
1109:
1110: ------------------------------------------------------------------
1111: -- Registers for Acks corr to sent message
1112: -- Calls XNP_STANDARD SUBSCRIBE_FOR_ACKS
1113: ------------------------------------------------------------------
1114: PROCEDURE SUBSCRIBE_FOR_ACKS
1115: (ITEMTYPE IN VARCHAR2
1116: ,ITEMKEY IN VARCHAR2

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 1749: -- calls XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS

1745:
1746: --------------------------------------------------------------------
1747: -- Description:
1748: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
1749: -- calls XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS
1750: -- Completes the path based on the result
1751: ------------------------------------------------------------------
1752: PROCEDURE SOA_CHECK_NOTIFY_DIR_SVS
1753: (ITEMTYPE IN VARCHAR2

Line 1788: XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS

1784: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
1785:
1786: -- Get the value of to flag
1787:
1788: XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS
1789: (l_WORKITEM_INSTANCE_ID
1790: ,l_check_status
1791: ,l_error_code
1792: ,l_error_message

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 1862: -- calls XNP_STANDARD.UPDATE_CHARGING_INFO

1858: --------------------------------------------------------------------
1859: -- Called at: Recipient side when charging info is recd
1860: -- Description:
1861: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
1862: -- calls XNP_STANDARD.UPDATE_CHARGING_INFO
1863: ------------------------------------------------------------------
1864: PROCEDURE SOA_UPDATE_CHARGING_INFO
1865: (ITEMTYPE IN VARCHAR2
1866: ,ITEMKEY IN VARCHAR2

Line 1906: XNP_STANDARD.SOA_UPDATE_CHARGING_INFO

1902: l_ORDER_ID := g_ORDER_ID;
1903: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
1904:
1905: -- Update the charging info
1906: XNP_STANDARD.SOA_UPDATE_CHARGING_INFO
1907: (l_ORDER_ID ,
1908: l_LINEITEM_ID,
1909: l_WORKITEM_INSTANCE_ID,
1910: l_FA_INSTANCE_ID,

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 2038: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2034: actid => actid,
2035: aname => 'FEATURE_TYPE');
2036:
2037: l_STARTING_NUMBER :=
2038: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2039: (l_WORKITEM_INSTANCE_ID
2040: ,'STARTING_NUMBER'
2041: );
2042:

Line 2044: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2040: ,'STARTING_NUMBER'
2041: );
2042:
2043: l_ENDING_NUMBER :=
2044: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2045: (l_WORKITEM_INSTANCE_ID
2046: ,'ENDING_NUMBER'
2047: );
2048:

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 2203: -- calls XNP_STANDARD.SOA_CHECK_ORDER_STATUS

2199:
2200: --------------------------------------------------------------------
2201: -- Called when: Checks the order/inquiry response
2202: -- Description:
2203: -- calls XNP_STANDARD.SOA_CHECK_ORDER_STATUS
2204: -- and completes the activityn based on the result
2205: ------------------------------------------------------------------
2206:
2207: PROCEDURE SOA_CHECK_ORDER_STATUS

Line 2242: XNP_STANDARD.SOA_CHECK_ORDER_STATUS

2238:
2239: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
2240:
2241: -- Get the order status value
2242: XNP_STANDARD.SOA_CHECK_ORDER_STATUS
2243: (l_WORKITEM_INSTANCE_ID
2244: ,l_ORDER_STATUS
2245: ,l_error_code
2246: ,l_error_message

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 2419: XNP_STANDARD.PUBLISH_EVENT

2415: end if;
2416:
2417: -- Invoke publish event
2418:
2419: XNP_STANDARD.PUBLISH_EVENT
2420: (p_ORDER_ID => l_ORDER_ID
2421: ,p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2422: ,p_FA_INSTANCE_ID => l_FA_INSTANCE_ID
2423: ,p_EVENT_TYPE => l_EVENT_TYPE

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 2537: XNP_STANDARD.CHECK_SOA_STATUS_EXISTS

2533: actid => actid,
2534: aname => 'STATUS_TYPE_CODE');
2535:
2536: -- Get the order status value
2537: XNP_STANDARD.CHECK_SOA_STATUS_EXISTS
2538: (l_WORKITEM_INSTANCE_ID
2539: ,l_STATUS_TYPE_CODE
2540: ,l_CHECK_STATUS
2541: ,l_error_code

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 2656: XNP_STANDARD.SET_ORDER_RESULT

2652: l_ORDER_STATUS := g_ORDER_ID;
2653:
2654:
2655: -- Set the order result value
2656: XNP_STANDARD.SET_ORDER_RESULT
2657: (l_WORKITEM_INSTANCE_ID
2658: ,l_ORDER_STATUS
2659: ,l_ORDER_REJECT_CODE
2660: ,l_ORDER_REJECT_EXPLN

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 2758: XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT

2754: -- The run code
2755:
2756: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
2757:
2758: XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT
2759: (l_WORKITEM_INSTANCE_ID
2760: ,l_CHECK_STATUS
2761: ,l_error_code
2762: ,l_error_message

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 3008: XNP_STANDARD.SEND_MESSAGE

3004:
3005: ------------------------------------------------------------------
3006: -- If send succeedes then increment version number
3007: ------------------------------------------------------------------
3008: XNP_STANDARD.SEND_MESSAGE
3009: (l_ORDER_ID
3010: ,l_WORKITEM_INSTANCE_ID
3011: ,l_FA_INSTANCE_ID
3012: ,l_EVENT_TYPE

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 3166: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3162: ,aname => 'FEATURE_TYPE'
3163: );
3164:
3165: l_STARTING_NUMBER :=
3166: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3167: (l_WORKITEM_INSTANCE_ID
3168: ,'STARTING_NUMBER'
3169: );
3170:

Line 3172: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3168: ,'STARTING_NUMBER'
3169: );
3170:
3171: l_ENDING_NUMBER :=
3172: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3173: (l_WORKITEM_INSTANCE_ID
3174: ,'ENDING_NUMBER'
3175: );
3176:

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 3304: -- and fe id and calls XNP_STANDARD.SMS_DELETE_FE_MAP

3300: -- Description:
3301: -- Deletes mapping rows from the SMS sv id and the fe id
3302: -- for the feature type
3303: -- Gets values of the item attributes workitem instance id
3304: -- and fe id and calls XNP_STANDARD.SMS_DELETE_FE_MAP
3305: ------------------------------------------------------------------
3306: PROCEDURE SMS_DELETE_FE_MAP
3307: (ITEMTYPE IN VARCHAR2
3308: ,ITEMKEY IN VARCHAR2

Line 3357: XNP_STANDARD.SMS_DELETE_FE_MAP

3353: actid => actid,
3354: aname => 'FEATURE_TYPE');
3355:
3356: -- Delete the fe map
3357: XNP_STANDARD.SMS_DELETE_FE_MAP
3358: (l_WORKITEM_INSTANCE_ID
3359: ,l_FE_ID
3360: ,l_FEATURE_TYPE
3361: ,l_error_code

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 3425: -- calls XNP_STANDARD.CHECK_PHASE_FOR_ROLE

3421: -- Description: Checks if there exists a
3422: -- SV for the given TN range in that phase
3423: -- and in for the given SP Role i.e. as donor
3424: -- or recipient
3425: -- calls XNP_STANDARD.CHECK_PHASE_FOR_ROLE
3426: -- Completes activity with 'Y' or 'N'
3427: ------------------------------------------------------------------
3428: PROCEDURE CHECK_PHASE_FOR_ROLE
3429: (ITEMTYPE IN VARCHAR2

Line 3485: XNP_STANDARD.CHECK_PHASE_FOR_ROLE

3481: ,aname => 'PHASE'
3482: );
3483:
3484: -- Check if an SV exists in that phase
3485: XNP_STANDARD.CHECK_PHASE_FOR_ROLE
3486: (l_WORKITEM_INSTANCE_ID
3487: ,l_SP_ROLE
3488: ,l_PHASE_INDICATOR
3489: ,l_CHECK_STATUS

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 3627: XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS

3623: itemkey => itemkey,
3624: actid => actid,
3625: aname => 'PROV_STATUS');
3626:
3627: XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS
3628: (l_ORDER_ID ,
3629: l_LINEITEM_ID,
3630: l_WORKITEM_INSTANCE_ID,
3631: l_FA_INSTANCE_ID,

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 4031: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4027: l_ORDER_ID := g_WORKITEM_INSTANCE_ID;
4028: l_WORKITEM_INSTANCE_ID := g_ORDER_ID;
4029:
4030: l_PORTING_ID :=
4031: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4032: (l_WORKITEM_INSTANCE_ID
4033: ,'PORTING_ID'
4034: );
4035:

Line 4037: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4033: ,'PORTING_ID'
4034: );
4035:
4036: l_sp_name :=
4037: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4038: (l_WORKITEM_INSTANCE_ID
4039: ,'SP_NAME'
4040: );
4041:

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 4163: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4159:
4160: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4161:
4162: l_PORTING_ID :=
4163: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4164: (l_WORKITEM_INSTANCE_ID
4165: ,'PORTING_ID'
4166: );
4167:

Line 4169: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4165: ,'PORTING_ID'
4166: );
4167:
4168: l_sp_name :=
4169: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4170: (l_WORKITEM_INSTANCE_ID
4171: ,'SP_NAME'
4172: );
4173:

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 4285: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4281:
4282: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4283:
4284: l_PORTING_ID :=
4285: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4286: (l_WORKITEM_INSTANCE_ID
4287: ,'PORTING_ID'
4288: );
4289:

Line 4300: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4296: );
4297:
4298:
4299: l_sp_name :=
4300: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4301: (l_WORKITEM_INSTANCE_ID
4302: ,'SP_NAME'
4303: );
4304:

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 4415: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4411:
4412: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4413:
4414: l_PORTING_ID :=
4415: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4416: (l_WORKITEM_INSTANCE_ID
4417: ,'PORTING_ID'
4418: );
4419:

Line 4422: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4418: );
4419:
4420:
4421: l_sp_name :=
4422: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4423: (l_WORKITEM_INSTANCE_ID
4424: ,'SP_NAME'
4425: );
4426:

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 4565: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4561: ,aname => 'FEATURE_TYPE'
4562: );
4563:
4564: l_STARTING_NUMBER :=
4565: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4566: (l_WORKITEM_INSTANCE_ID
4567: ,'STARTING_NUMBER'
4568: );
4569:

Line 4571: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4567: ,'STARTING_NUMBER'
4568: );
4569:
4570: l_ENDING_NUMBER :=
4571: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4572: (l_WORKITEM_INSTANCE_ID
4573: ,'ENDING_NUMBER'
4574: );
4575:

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 4698: -- Calls XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER

4694: -- Called when: there is a Modify Ported Number
4695: -- request from NRC
4696: -- Description:
4697: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
4698: -- Calls XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER
4699: ------------------------------------------------------------------
4700: PROCEDURE SMS_MODIFY_PORTED_NUMBER
4701: (ITEMTYPE IN VARCHAR2
4702: ,ITEMKEY IN VARCHAR2

Line 4740: XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER

4736: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
4737:
4738: -- The run code
4739:
4740: XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER
4741: (l_ORDER_ID ,
4742: l_LINEITEM_ID,
4743: l_WORKITEM_INSTANCE_ID,
4744: l_FA_INSTANCE_ID,

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 4851: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4847: l_ORDER_ID := g_ORDER_ID;
4848: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
4849:
4850: l_PORTING_ID :=
4851: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4852: (l_WORKITEM_INSTANCE_ID
4853: ,'PORTING_ID'
4854: );
4855:

Line 4857: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4853: ,'PORTING_ID'
4854: );
4855:
4856: l_NEW_SP_DUE_DATE :=
4857: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4858: (l_WORKITEM_INSTANCE_ID
4859: ,'NEW_SP_DUE_DATE'
4860: );
4861:

Line 4863: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4859: ,'NEW_SP_DUE_DATE'
4860: );
4861:
4862: l_sp_name :=
4863: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4864: (l_WORKITEM_INSTANCE_ID
4865: ,'SP_NAME'
4866: );
4867:

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 4983: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4979: l_ORDER_ID := g_ORDER_ID;
4980: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4981:
4982: l_PORTING_ID :=
4983: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4984: (l_WORKITEM_INSTANCE_ID
4985: ,'PORTING_ID'
4986: );
4987:

Line 4989: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4985: ,'PORTING_ID'
4986: );
4987:
4988: l_OLD_SP_DUE_DATE :=
4989: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4990: (l_WORKITEM_INSTANCE_ID
4991: ,'OLD_SP_DUE_DATE'
4992: );
4993:

Line 4996: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4992: );
4993:
4994:
4995: l_sp_name :=
4996: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4997: (l_WORKITEM_INSTANCE_ID
4998: ,'SP_NAME'
4999: );
5000:

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 5114: XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS

5110: ,actid => actid
5111: ,aname => 'STATUS_TO_COMPARE_WITH'
5112: );
5113:
5114: XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS
5115: (p_WORKITEM_INSTANCE_ID =>l_workitem_instance_id
5116: ,p_status_to_check_with =>l_status_to_compare_with
5117: ,x_CHECK_STATUS =>x_check_status
5118: ,x_ERROR_CODE =>l_error_code

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 5225: XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS

5221: ,actid => actid
5222: ,aname => 'STATUS_TO_COMPARE_WITH'
5223: );
5224:
5225: XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS
5226: (p_WORKITEM_INSTANCE_ID =>l_workitem_instance_id
5227: ,p_status_to_check_with =>l_status_to_compare_with
5228: ,x_CHECK_STATUS =>x_check_status
5229: ,x_ERROR_CODE =>l_error_code

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 5354: XNP_STANDARD.SOA_UPDATE_SV_STATUS

5350: itemkey => itemkey,
5351: actid => actid,
5352: aname => 'STATUS_CHANGE_CAUSE_CODE');
5353:
5354: XNP_STANDARD.SOA_UPDATE_SV_STATUS
5355: (p_ORDER_ID => l_ORDER_ID ,
5356: p_LINEITEM_ID => l_LINEITEM_ID ,
5357: p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID,
5358: p_FA_INSTANCE_ID => l_FA_INSTANCE_ID ,

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 5472: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5468: l_ORDER_ID := g_ORDER_ID;
5469: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5470:
5471: l_PORTING_ID :=
5472: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5473: (l_WORKITEM_INSTANCE_ID
5474: ,'PORTING_ID'
5475: );
5476:

Line 5478: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5474: ,'PORTING_ID'
5475: );
5476:
5477: l_sp_name :=
5478: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5479: (l_WORKITEM_INSTANCE_ID
5480: ,'SP_NAME'
5481: );
5482:

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 5667: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5663:
5664: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5665:
5666: l_PORTING_ID :=
5667: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5668: (l_WORKITEM_INSTANCE_ID
5669: ,'PORTING_ID'
5670: );
5671:

Line 5673: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5669: ,'PORTING_ID'
5670: );
5671:
5672: l_sp_name :=
5673: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5674: (l_WORKITEM_INSTANCE_ID
5675: ,'SP_NAME'
5676: );
5677:

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 5844: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5840: l_ORDER_ID := g_ORDER_ID;
5841: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5842:
5843: l_PORTING_ID :=
5844: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5845: (l_WORKITEM_INSTANCE_ID
5846: ,'PORTING_ID'
5847: );
5848:

Line 5850: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5846: ,'PORTING_ID'
5847: );
5848:
5849: l_sp_name :=
5850: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5851: (l_WORKITEM_INSTANCE_ID
5852: ,'SP_NAME'
5853: );
5854:

Line 5866: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5862:
5863: if (l_date_name = 'NEW_SP_DUE_DATE') then
5864:
5865: l_date_value :=
5866: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5867: (l_WORKITEM_INSTANCE_ID
5868: ,'NEW_SP_DUE_DATE'
5869: );
5870:

Line 5886: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5882:
5883: elsif (l_date_name = 'OLD_SP_DUE_DATE') then
5884:
5885: l_date_value :=
5886: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5887: (l_WORKITEM_INSTANCE_ID
5888: ,'OLD_SP_DUE_DATE'
5889: );
5890:

Line 5906: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5902:
5903: elsif (l_date_name = 'ACTIVATION_DUE_DATE') then
5904:
5905: l_date_value :=
5906: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5907: (l_WORKITEM_INSTANCE_ID
5908: ,'ACTIVATION_DUE_DATE'
5909: );
5910:

Line 5926: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5922:
5923: elsif (l_date_name = 'DISCONNECT_DUE_DATE') then
5924:
5925: l_date_value :=
5926: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5927: (l_WORKITEM_INSTANCE_ID
5928: ,'DISCONNECT_DUE_DATE'
5929: );
5930:

Line 5945: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5941:
5942: elsif (l_date_name = 'EFFECTIVE_RELEASE_DUE_DATE') then
5943:
5944: l_date_value :=
5945: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5946: (l_WORKITEM_INSTANCE_ID
5947: ,'EFFECTIVE_RELEASE_DUE_DATE'
5948: );
5949:

Line 5964: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5960:
5961: elsif (l_date_name = 'NUMBER_RETURNED_DUE_DATE') then
5962:
5963: l_date_value :=
5964: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5965: (l_WORKITEM_INSTANCE_ID
5966: ,'NUMBER_RETURNED_DUE_DATE'
5967: );
5968:

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 6082: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6078:
6079: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6080:
6081: l_STARTING_NUMBER :=
6082: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6083: (l_WORKITEM_INSTANCE_ID
6084: ,'STARTING_NUMBER'
6085: );
6086:

Line 6088: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6084: ,'STARTING_NUMBER'
6085: );
6086:
6087: l_ENDING_NUMBER :=
6088: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6089: (l_WORKITEM_INSTANCE_ID
6090: ,'ENDING_NUMBER'
6091: );
6092:

Line 6094: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6090: ,'ENDING_NUMBER'
6091: );
6092:
6093: l_DONOR_SP_NAME :=
6094: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6095: (l_WORKITEM_INSTANCE_ID
6096: ,'DONOR_SP_ID'
6097: );
6098:

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 6227: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6223:
6224: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6225:
6226: l_STARTING_NUMBER :=
6227: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6228: (l_WORKITEM_INSTANCE_ID
6229: ,'STARTING_NUMBER'
6230: );
6231:

Line 6233: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6229: ,'STARTING_NUMBER'
6230: );
6231:
6232: l_ENDING_NUMBER :=
6233: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6234: (l_WORKITEM_INSTANCE_ID
6235: ,'ENDING_NUMBER'
6236: );
6237:

Line 6239: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6235: ,'ENDING_NUMBER'
6236: );
6237:
6238: l_DONOR_SP_NAME :=
6239: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6240: (l_WORKITEM_INSTANCE_ID
6241: ,'DONOR_SP_ID'
6242: );
6243:

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 6364: XNP_STANDARD.SOA_UPDATE_NOTES_INFO

6360:
6361: l_ORDER_ID := g_ORDER_ID;
6362: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6363:
6364: XNP_STANDARD.SOA_UPDATE_NOTES_INFO
6365: (l_order_id,
6366: l_lineitem_id,
6367: l_WORKITEM_INSTANCE_ID,
6368: l_fa_instance_id,

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 6464: XNP_STANDARD.SOA_UPDATE_NETWORK_INFO

6460:
6461: l_ORDER_ID := g_ORDER_ID;
6462: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6463:
6464: XNP_STANDARD.SOA_UPDATE_NETWORK_INFO
6465: (l_order_id,
6466: l_lineitem_id,
6467: l_WORKITEM_INSTANCE_ID,
6468: l_fa_instance_id,

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 6565: XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO

6561:
6562: l_ORDER_ID := g_ORDER_ID;
6563: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6564:
6565: XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO
6566: (l_order_id,
6567: l_lineitem_id,
6568: l_workitem_instance_id,
6569: l_fa_instance_id,

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 6745: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS

6741: -- Called when: need to update the SV status according
6742: -- to the activity parameter SV_STATUS
6743: -- Description:
6744: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
6745: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS
6746: ------------------------------------------------------------------
6747: PROCEDURE SOA_UPDATE_CUR_SV_STATUS
6748: (ITEMTYPE IN VARCHAR2
6749: ,ITEMKEY IN VARCHAR2

Line 6807: XNP_STANDARD.SOA_UPDATE_SV_STATUS

6803: itemkey => itemkey,
6804: actid => actid,
6805: aname => 'STATUS_CHANGE_CAUSE_CODE');
6806:
6807: XNP_STANDARD.SOA_UPDATE_SV_STATUS
6808: (p_ORDER_ID => L_ORDER_ID,
6809: p_LINEITEM_ID =>l_LINEITEM_ID,
6810: p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID,
6811: p_FA_INSTANCE_ID => l_FA_INSTANCE_ID,

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 6910: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6906: l_ORDER_ID := g_ORDER_ID;
6907: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6908:
6909: l_STARTING_NUMBER :=
6910: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6911: (l_WORKITEM_INSTANCE_ID
6912: ,'STARTING_NUMBER'
6913: );
6914:

Line 6916: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6912: ,'STARTING_NUMBER'
6913: );
6914:
6915: l_ENDING_NUMBER :=
6916: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6917: (l_WORKITEM_INSTANCE_ID
6918: ,'ENDING_NUMBER'
6919: );
6920:

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 7032: XNP_STANDARD.RUNTIME_VALIDATION

7028: wf_engine.GetItemAttrNumber (itemtype => itemtype,
7029: itemkey => itemkey,
7030: aname => 'LINE_ITEM_ID');
7031:
7032: XNP_STANDARD.RUNTIME_VALIDATION
7033: (p_ORDER_ID => l_ORDER_ID
7034: ,p_LINE_ITEM_ID => l_lIne_Item_ID
7035: ,p_WORKITEM_INSTANCE_ID =>l_WORKITEM_INSTANCE_ID
7036: ,x_ERROR_CODE => l_error_code

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 7538: XNP_STANDARD.DEREGISTER_ALL

7534: -- The run code
7535:
7536: -- Get the event type to publish
7537:
7538: XNP_STANDARD.DEREGISTER_ALL
7539: (
7540: p_order_id => l_order_id
7541: ,x_error_code => l_error_code
7542: ,x_error_message => l_error_message

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: