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_STANDARD dependencies on STANDARD

Line 1: PACKAGE BODY XNP_STANDARD AS

1: PACKAGE BODY XNP_STANDARD AS
2: /* $Header: XNPSTACB.pls 120.1.12010000.2 2008/09/25 05:24:11 mpathani ship $ */
3:
4: ------------------------------------------------------------------
5: -- Wrapper function for XDP_ENGINE package

Line 37: (P_PKG_NAME => 'XNP_STANDARD'

33:
34: EXCEPTION
35: WHEN OTHERS THEN
36: XNP_UTILS.NOTIFY_ERROR
37: (P_PKG_NAME => 'XNP_STANDARD'
38: ,P_PROC_NAME => 'GET_MANDATORY_WI_PARAM_VALUE'
39: ,P_MSG_NAME => 'GET_MANDATORY_WI_PARAM_ERR'
40: ,P_WORKITEM_INSTANCE_ID => p_WORKITEM_INSTANCE_ID
41: ,P_TOK1 => 'WIID'

Line 79: (P_PKG_NAME => 'XNP_STANDARD'

75: EXCEPTION
76: WHEN OTHERS THEN
77:
78: XNP_UTILS.NOTIFY_ERROR
79: (P_PKG_NAME => 'XNP_STANDARD'
80: ,P_PROC_NAME => 'SET_MANDATORY_WI_PARAM_VALUE'
81: ,P_MSG_NAME => 'SET_MANDATORY_WI_PARAM_ERR'
82: ,P_WORKITEM_INSTANCE_ID => p_WORKITEM_INSTANCE_ID
83: ,P_TOK1 => 'WIID'

Line 159: -- Called by: XNP_STANDARD.SMS_CREATE_PORTED_NUMBER

155: --------------------------------------------------------------------
156: --
157: -- Called when: there is a Create Ported Number
158: -- request from NRC
159: -- Called by: XNP_STANDARD.SMS_CREATE_PORTED_NUMBER
160: -- Description: Extracts the order information from SFM
161: -- Workitem params
162: -- Mandatory: Gets the PORTING_ID, STARTING_NUMBER, ENDING_NUMBER,
163: -- PORTING_TIME,ROUTING_NUMBER

Line 211: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

207: BEGIN
208: x_error_code := 0;
209:
210: l_porting_id :=
211: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
212: (p_WORKITEM_INSTANCE_ID
213: ,'PORTING_ID'
214: );
215:

Line 217: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

213: ,'PORTING_ID'
214: );
215:
216: l_porting_time :=
217: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
218: (p_WORKITEM_INSTANCE_ID
219: ,'PORTING_TIME'
220: );
221:

Line 223: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

219: ,'PORTING_TIME'
220: );
221:
222: l_starting_number :=
223: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
224: (p_WORKITEM_INSTANCE_ID
225: ,'STARTING_NUMBER'
226: );
227:

Line 229: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

225: ,'STARTING_NUMBER'
226: );
227:
228: l_ending_number :=
229: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
230: (p_WORKITEM_INSTANCE_ID
231: ,'ENDING_NUMBER'
232: );
233:

Line 246: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

242: return;
243: END IF;
244:
245: l_routing_number :=
246: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
247: (p_WORKITEM_INSTANCE_ID
248: ,'ROUTING_NUMBER'
249: );
250:

Line 264: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

260: RETURN;
261: END IF;
262:
263: l_SUBSCRIPTION_TYPE :=
264: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
265: (p_WORKITEM_INSTANCE_ID
266: ,'SUBSCRIPTION_TYPE'
267: );
268: IF (l_SUBSCRIPTION_TYPE IS null) THEN

Line 273: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

269: l_SUBSCRIPTION_TYPE := 'NP';
270: END IF;
271:
272: l_CNAM_ADDRESS :=
273: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
274: (p_WORKITEM_INSTANCE_ID
275: ,'CNAM_ADDRESS'
276: );
277:

Line 279: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

275: ,'CNAM_ADDRESS'
276: );
277:
278: l_CNAM_SUBSYSTEM :=
279: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
280: (p_WORKITEM_INSTANCE_ID
281: ,'CNAM_SUBSYSTEM'
282: );
283:

Line 285: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

281: ,'CNAM_SUBSYSTEM'
282: );
283:
284: l_ISVM_ADDRESS :=
285: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
286: (p_WORKITEM_INSTANCE_ID
287: ,'ISVM_ADDRESS'
288: );
289:

Line 291: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

287: ,'ISVM_ADDRESS'
288: );
289:
290: l_ISVM_SUBSYSTEM :=
291: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
292: (p_WORKITEM_INSTANCE_ID
293: ,'ISVM_SUBSYSTEM'
294: );
295:

Line 297: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

293: ,'ISVM_SUBSYSTEM'
294: );
295:
296: l_LIDB_ADDRESS :=
297: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
298: (p_WORKITEM_INSTANCE_ID
299: ,'LIDB_ADDRESS'
300: );
301:

Line 303: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

299: ,'LIDB_ADDRESS'
300: );
301:
302: l_LIDB_SUBSYSTEM :=
303: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
304: (p_WORKITEM_INSTANCE_ID
305: ,'LIDB_SUBSYSTEM'
306: );
307:

Line 309: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

305: ,'LIDB_SUBSYSTEM'
306: );
307:
308: l_CLASS_ADDRESS :=
309: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
310: (p_WORKITEM_INSTANCE_ID
311: ,'CLASS_ADDRESS'
312: );
313:

Line 315: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

311: ,'CLASS_ADDRESS'
312: );
313:
314: l_CLASS_SUBSYSTEM :=
315: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
316: (p_WORKITEM_INSTANCE_ID
317: ,'CLASS_SUBSYSTEM'
318: );
319:

Line 321: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

317: ,'CLASS_SUBSYSTEM'
318: );
319:
320: l_WSMSC_ADDRESS :=
321: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
322: (p_WORKITEM_INSTANCE_ID
323: ,'WSMSC_ADDRESS'
324: );
325:

Line 327: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

323: ,'WSMSC_ADDRESS'
324: );
325:
326: l_WSMSC_SUBSYSTEM :=
327: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
328: (p_WORKITEM_INSTANCE_ID
329: ,'WSMSC_SUBSYSTEM'
330: );
331:

Line 333: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

329: ,'WSMSC_SUBSYSTEM'
330: );
331:
332: l_RN_ADDRESS :=
333: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
334: (p_WORKITEM_INSTANCE_ID
335: ,'RN_ADDRESS'
336: );
337:

Line 339: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

335: ,'RN_ADDRESS'
336: );
337:
338: l_RN_SUBSYSTEM :=
339: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
340: (p_WORKITEM_INSTANCE_ID
341: ,'RN_SUBSYSTEM'
342: );
343:

Line 377: ,'XNP_STANDARD.SMS_CREATE_PORTED_NUMBER');

373: x_error_code := SQLCODE;
374:
375: fnd_message.set_name('XNP','STD_ERROR');
376: fnd_message.set_token('ERROR_LOCN'
377: ,'XNP_STANDARD.SMS_CREATE_PORTED_NUMBER');
378: fnd_message.set_token('ERROR_TEXT',SQLERRM);
379: x_error_message := fnd_message.get;
380: END SMS_CREATE_PORTED_NUMBER;
381:

Line 387: -- Called by: XNP_STANDARD.SMS_DELETE_PORTED_NUMBER

383: --------------------------------------------------------------------
384: --
385: -- Called when: there is a Delete Ported Number
386: -- request from NRC
387: -- Called by: XNP_STANDARD.SMS_DELETE_PORTED_NUMBER
388: -- Description: Extracts the order information from SFM
389: -- Workitem params table
390: -- Gets the STARTING_NUMBER, ENDING_NUMBER
391: -- and calls XNP_CORE.SMS_DELETE_PORTED_NUMBER

Line 408: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

404:
405: x_error_code := 0;
406:
407: l_starting_number :=
408: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
409: (p_WORKITEM_INSTANCE_ID
410: ,'STARTING_NUMBER'
411: );
412:

Line 414: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

410: ,'STARTING_NUMBER'
411: );
412:
413: l_ending_number :=
414: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
415: (p_WORKITEM_INSTANCE_ID
416: ,'ENDING_NUMBER'
417: );
418:

Line 432: -- Called by: XNP_STANDARD.SOA_PORTING_INQUIRY

428: --------------------------------------------------------------------
429: --
430: -- Called when: there is a Pre-order Peer's Porting
431: -- Inquiry
432: -- Called by: XNP_STANDARD.SOA_PORTING_INQUIRY
433: -- Description:
434: -- Inserts a row in the the SOA table based on the
435: -- SP type (i.e. donor or recipient)
436: -- All necessary values are got from the workitems table

Line 454: -- Called by: XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE

450: END SOA_PORTING_INQUIRY;
451: ************/
452: --------------------------------------------------------------------
453: --
454: -- Called by: XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE
455: -- Description: Extracts the order information from SFM
456: -- Workitem params table namely PORTING_ID, STARTING_NUMBER,
457: -- ENDING_NUMBER, OLD_SP_CUTOFF_DUE_DATE
458: -- Calls XNP_CORE.SOA_UPDATE_CUTOFF_DATE to update the

Line 488: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

484:
485: x_error_code := 0;
486:
487: l_porting_id :=
488: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
489: (p_WORKITEM_INSTANCE_ID
490: ,'PORTING_ID'
491: );
492:

Line 494: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

490: ,'PORTING_ID'
491: );
492:
493: l_starting_number :=
494: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
495: (p_WORKITEM_INSTANCE_ID
496: ,'STARTING_NUMBER'
497: );
498:

Line 500: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

496: ,'STARTING_NUMBER'
497: );
498:
499: l_ending_number :=
500: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
501: (p_WORKITEM_INSTANCE_ID
502: ,'ENDING_NUMBER'
503: );
504:

Line 506: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

502: ,'ENDING_NUMBER'
503: );
504:
505: l_cutoff_date :=
506: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
507: (p_WORKITEM_INSTANCE_ID
508: ,'OLD_SP_CUTOFF_DUE_DATE'
509: );
510:

Line 512: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

508: ,'OLD_SP_CUTOFF_DUE_DATE'
509: );
510:
511: l_SP_NAME :=
512: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
513: (p_WORKITEM_INSTANCE_ID
514: ,'SP_NAME'
515: );
516:

Line 556: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');

552: -- Grab the error message and error no.
553: x_error_code := SQLCODE;
554:
555: fnd_message.set_name('XNP','STD_ERROR');
556: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');
557: fnd_message.set_token('ERROR_TEXT',SQLERRM);
558: x_error_message := fnd_message.get;
559:
560: END SOA_UPDATE_CUTOFF_DATE;

Line 567: -- Called by: XNP_WF_STANDARD.SOA_CREATE_PORTING_ORDER

563: --------------------------------------------------------------------
564: --
565: -- Called when: there is a order Peer's Porting
566: -- Order or OMS porting order
567: -- Called by: XNP_WF_STANDARD.SOA_CREATE_PORTING_ORDER
568: -- Description:
569: -- Updates corresponding rows in the the SOA table based on
570: -- SP type (i.e. donor or recipient)
571: -- All necessary values are got from the workitems table

Line 658: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

654: BEGIN
655: x_error_code := 0;
656:
657: l_PORTING_ID :=
658: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
659: (p_WORKITEM_INSTANCE_ID
660: ,'PORTING_ID'
661: );
662:

Line 664: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

660: ,'PORTING_ID'
661: );
662:
663: l_starting_number :=
664: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
665: (p_WORKITEM_INSTANCE_ID
666: ,'STARTING_NUMBER'
667: );
668:

Line 670: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

666: ,'STARTING_NUMBER'
667: );
668:
669: l_ending_number :=
670: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
671: (p_WORKITEM_INSTANCE_ID
672: ,'ENDING_NUMBER'
673: );
674:

Line 693: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

689: END IF;
690: ******/
691:
692: l_DONOR_SP_CODE :=
693: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
694: (p_WORKITEM_INSTANCE_ID
695: ,'DONOR_SP_ID'
696: );
697:

Line 711: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

707: RETURN;
708: END IF;
709:
710: l_RECIPIENT_SP_CODE :=
711: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
712: (p_WORKITEM_INSTANCE_ID
713: ,'RECIPIENT_SP_ID'
714: );
715:

Line 732: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

728: -- The new sp due date is part of order incase of recipient
729: -- The new sp due date is part of inbound mesg incase of donor
730:
731: l_new_sp_due_date :=
732: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
733: (p_WORKITEM_INSTANCE_ID
734: ,'NEW_SP_DUE_DATE'
735: );
736: l_SP_DUE_DATE := l_new_sp_due_date;

Line 740: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

736: l_SP_DUE_DATE := l_new_sp_due_date;
737:
738:
739: l_OLD_SP_CUTOFF_DUE_DATE :=
740: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
741: (p_WORKITEM_INSTANCE_ID
742: ,'OLD_SP_CUTOFF_DUE_DATE'
743: );
744:

Line 746: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

742: ,'OLD_SP_CUTOFF_DUE_DATE'
743: );
744:
745: l_CUSTOMER_ID :=
746: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
747: (p_WORKITEM_INSTANCE_ID
748: ,'CUSTOMER_ID'
749: );
750:

Line 752: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

748: ,'CUSTOMER_ID'
749: );
750:
751: l_CUSTOMER_NAME :=
752: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
753: (p_WORKITEM_INSTANCE_ID
754: ,'CUSTOMER_NAME'
755: );
756:

Line 758: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

754: ,'CUSTOMER_NAME'
755: );
756:
757: l_CUSTOMER_TYPE :=
758: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
759: (p_WORKITEM_INSTANCE_ID
760: ,'CUSTOMER_TYPE'
761: );
762:

Line 764: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

760: ,'CUSTOMER_TYPE'
761: );
762:
763: l_ADDRESS_LINE1 :=
764: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
765: (p_WORKITEM_INSTANCE_ID
766: ,'ADDRESS_LINE1'
767: );
768:

Line 770: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

766: ,'ADDRESS_LINE1'
767: );
768:
769: l_ADDRESS_LINE2 :=
770: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
771: (p_WORKITEM_INSTANCE_ID
772: ,'ADDRESS_LINE2'
773: );
774:

Line 776: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

772: ,'ADDRESS_LINE2'
773: );
774:
775: l_CITY :=
776: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
777: (p_WORKITEM_INSTANCE_ID
778: ,'CITY'
779: );
780:

Line 782: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

778: ,'CITY'
779: );
780:
781: l_PHONE :=
782: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
783: (p_WORKITEM_INSTANCE_ID
784: ,'PHONE'
785: );
786:

Line 788: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

784: ,'PHONE'
785: );
786:
787: l_FAX :=
788: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
789: (p_WORKITEM_INSTANCE_ID
790: ,'FAX'
791: );
792:

Line 794: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

790: ,'FAX'
791: );
792:
793: l_EMAIL :=
794: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
795: (p_WORKITEM_INSTANCE_ID
796: ,'EMAIL'
797: );
798:

Line 800: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

796: ,'EMAIL'
797: );
798:
799: l_ZIP_CODE :=
800: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
801: (p_WORKITEM_INSTANCE_ID
802: ,'ZIP_CODE'
803: );
804:

Line 806: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

802: ,'ZIP_CODE'
803: );
804:
805: l_COUNTRY :=
806: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
807: (p_WORKITEM_INSTANCE_ID
808: ,'COUNTRY'
809: );
810:

Line 812: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

808: ,'COUNTRY'
809: );
810:
811: l_RETAIN_TN_FLAG :=
812: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
813: (p_WORKITEM_INSTANCE_ID
814: ,'RETAIN_TN_FLAG'
815: );
816:

Line 818: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

814: ,'RETAIN_TN_FLAG'
815: );
816:
817: l_CUSTOMER_CONTACT_REQ_FLAG :=
818: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
819: (p_WORKITEM_INSTANCE_ID
820: ,'CUSTOMER_CONTACT_REQ_FLAG'
821: );
822:

Line 824: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

820: ,'CUSTOMER_CONTACT_REQ_FLAG'
821: );
822:
823: l_CONTACT_NAME :=
824: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
825: (p_WORKITEM_INSTANCE_ID
826: ,'CONTACT_NAME'
827: );
828:

Line 830: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

826: ,'CONTACT_NAME'
827: );
828:
829: l_CNAM_ADDRESS :=
830: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
831: (p_WORKITEM_INSTANCE_ID
832: ,'CNAM_ADDRESS'
833: );
834:

Line 836: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

832: ,'CNAM_ADDRESS'
833: );
834:
835: l_CNAM_SUBSYSTEM :=
836: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
837: (p_WORKITEM_INSTANCE_ID
838: ,'CNAM_SUBSYSTEM'
839: );
840:

Line 842: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

838: ,'CNAM_SUBSYSTEM'
839: );
840:
841: l_ISVM_ADDRESS :=
842: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
843: (p_WORKITEM_INSTANCE_ID
844: ,'ISVM_ADDRESS'
845: );
846:

Line 848: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

844: ,'ISVM_ADDRESS'
845: );
846:
847: l_ISVM_SUBSYSTEM :=
848: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
849: (p_WORKITEM_INSTANCE_ID
850: ,'ISVM_SUBSYSTEM'
851: );
852:

Line 854: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

850: ,'ISVM_SUBSYSTEM'
851: );
852:
853: l_LIDB_ADDRESS :=
854: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
855: (p_WORKITEM_INSTANCE_ID
856: ,'LIDB_ADDRESS'
857: );
858:

Line 860: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

856: ,'LIDB_ADDRESS'
857: );
858:
859: l_LIDB_SUBSYSTEM :=
860: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
861: (p_WORKITEM_INSTANCE_ID
862: ,'LIDB_SUBSYSTEM'
863: );
864:

Line 866: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

862: ,'LIDB_SUBSYSTEM'
863: );
864:
865: l_CLASS_ADDRESS :=
866: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
867: (p_WORKITEM_INSTANCE_ID
868: ,'CLASS_ADDRESS'
869: );
870:

Line 872: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

868: ,'CLASS_ADDRESS'
869: );
870:
871: l_CLASS_SUBSYSTEM :=
872: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
873: (p_WORKITEM_INSTANCE_ID
874: ,'CLASS_SUBSYSTEM'
875: );
876:

Line 878: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

874: ,'CLASS_SUBSYSTEM'
875: );
876:
877: l_WSMSC_ADDRESS :=
878: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
879: (p_WORKITEM_INSTANCE_ID
880: ,'WSMSC_ADDRESS'
881: );
882:

Line 884: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

880: ,'WSMSC_ADDRESS'
881: );
882:
883: l_WSMSC_SUBSYSTEM :=
884: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
885: (p_WORKITEM_INSTANCE_ID
886: ,'WSMSC_SUBSYSTEM'
887: );
888:

Line 890: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

886: ,'WSMSC_SUBSYSTEM'
887: );
888:
889: l_RN_ADDRESS :=
890: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
891: (p_WORKITEM_INSTANCE_ID
892: ,'RN_ADDRESS'
893: );
894:

Line 896: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

892: ,'RN_ADDRESS'
893: );
894:
895: l_RN_SUBSYSTEM :=
896: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
897: (p_WORKITEM_INSTANCE_ID
898: ,'RN_SUBSYSTEM'
899: );
900:

Line 902: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

898: ,'RN_SUBSYSTEM'
899: );
900:
901: l_PAGER :=
902: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
903: (p_WORKITEM_INSTANCE_ID
904: ,'PAGER'
905: );
906:

Line 908: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

904: ,'PAGER'
905: );
906:
907: l_PAGER_PIN :=
908: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
909: (p_WORKITEM_INSTANCE_ID
910: ,'PAGER_PIN'
911: );
912:

Line 914: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

910: ,'PAGER_PIN'
911: );
912:
913: l_INTERNET_ADDRESS :=
914: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
915: (p_WORKITEM_INSTANCE_ID
916: ,'INTERNET_ADDRESS'
917: );
918:

Line 920: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

916: ,'INTERNET_ADDRESS'
917: );
918:
919: l_RETAIN_DIR_INFO_FLAG :=
920: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
921: (p_WORKITEM_INSTANCE_ID
922: ,'RETAIN_DIR_INFO_FLAG'
923: );
924:

Line 926: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

922: ,'RETAIN_DIR_INFO_FLAG'
923: );
924:
925: l_PREORDER_AUTHORIZATION_CODE :=
926: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
927: (p_WORKITEM_INSTANCE_ID
928: ,'PREORDER_AUTHORIZATION_CODE'
929: );
930:

Line 932: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

928: ,'PREORDER_AUTHORIZATION_CODE'
929: );
930:
931: l_ACTIVATION_DUE_DATE :=
932: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
933: (p_WORKITEM_INSTANCE_ID
934: ,'ACTIVATION_DUE_DATE'
935: );
936:

Line 938: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

934: ,'ACTIVATION_DUE_DATE'
935: );
936:
937: l_ORDER_PRIORITY :=
938: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
939: (p_WORKITEM_INSTANCE_ID
940: ,'ORDER_PRIORITY'
941: );
942:

Line 944: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

940: ,'ORDER_PRIORITY'
941: );
942:
943: l_COMMENTS :=
944: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
945: (p_WORKITEM_INSTANCE_ID
946: ,'COMMENTS'
947: );
948:

Line 950: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

946: ,'COMMENTS'
947: );
948:
949: l_NOTES :=
950: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
951: (p_WORKITEM_INSTANCE_ID
952: ,'NOTES'
953: );
954:

Line 956: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

952: ,'NOTES'
953: );
954:
955: l_SUBSCRIPTION_TYPE :=
956: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
957: (p_WORKITEM_INSTANCE_ID
958: ,'SUBSCRIPTION_TYPE'
959: );
960: IF (l_SUBSCRIPTION_TYPE IS null) THEN

Line 974: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

970:
971: -- Get the routing number id
972:
973: l_ROUTING_NUMBER :=
974: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
975: (p_WORKITEM_INSTANCE_ID
976: ,'ROUTING_NUMBER'
977: );
978:

Line 984: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

980: -- Bug 2239283. Set the Subsequent Porting Flag regardless of the
981: -- SP Role
982:
983: l_SUBSEQUENT_PORT_FLAG :=
984: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
985: (p_WORKITEM_INSTANCE_ID
986: ,'SUBSEQUENT_PORT'
987: );
988:

Line 1025: -- XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1021: --
1022: -- Bug 2239283. Set the Subsequent Porting Flag regardless of the
1023: -- SP Role. Moved the code above. Commented this code
1024: -- l_SUBSEQUENT_PORT_FLAG :=
1025: -- XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1026: -- (p_WORKITEM_INSTANCE_ID
1027: -- ,'SUBSEQUENT_PORT'
1028: -- );
1029:

Line 1220: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CREATE_PORTING_ORDER');

1216: -- Grab the error message and error no.
1217: x_error_code := SQLCODE;
1218:
1219: fnd_message.set_name('XNP','STD_ERROR');
1220: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CREATE_PORTING_ORDER');
1221: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1222: x_error_message := fnd_message.get;
1223:
1224: END SOA_CREATE_PORTING_ORDER;

Line 1227: -- Called by:Donor's XNP_WF_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS

1223:
1224: END SOA_CREATE_PORTING_ORDER;
1225:
1226: --------------------------------------------------------------------
1227: -- Called by:Donor's XNP_WF_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS
1228: -- Description: Gets the WI param PORTING_ID and calls
1229: -- XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS
1230: -- Returns: 'Y' if true
1231: ------------------------------------------------------------------

Line 1250: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1246: x_error_code := 0;
1247:
1248: -- Get the porting id and check the corr.
1249: l_porting_id :=
1250: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1251: (p_WORKITEM_INSTANCE_ID
1252: ,'PORTING_ID'
1253: );
1254:

Line 1257: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1253: );
1254:
1255:
1256: l_SP_NAME :=
1257: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1258: (p_WORKITEM_INSTANCE_ID
1259: ,'SP_NAME'
1260: );
1261:

Line 1275: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS');

1271: -- Grab the error message and error no.
1272: x_error_code := SQLCODE;
1273:
1274: fnd_message.set_name('XNP','STD_ERROR');
1275: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS');
1276: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1277: x_error_message := fnd_message.get;
1278:
1279: END SOA_CHECK_NOTIFY_DIR_SVS;

Line 1285: -- Called by:Donor XNP_WF_STANDARD.DETERMINE_SP_ROLE

1281:
1282: --------------------------------------------------------------------
1283: -- Called at: donor sp when need to check if its the
1284: -- initial donor
1285: -- Called by:Donor XNP_WF_STANDARD.DETERMINE_SP_ROLE
1286: -- Description:
1287: -- Extracts the (LOCAL)SP_NAME and compares it to donor,
1288: -- recipient. If either of them don't match checks
1289: -- if its INITIAL DONOR.

Line 1315: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1311: x_error_code := 0;
1312:
1313:
1314: l_starting_number :=
1315: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1316: (p_WORKITEM_INSTANCE_ID
1317: ,'STARTING_NUMBER'
1318: );
1319:

Line 1321: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1317: ,'STARTING_NUMBER'
1318: );
1319:
1320: l_ending_number :=
1321: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1322: (p_WORKITEM_INSTANCE_ID
1323: ,'ENDING_NUMBER'
1324: );
1325:

Line 1327: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1323: ,'ENDING_NUMBER'
1324: );
1325:
1326: l_donor_sp_id :=
1327: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1328: (p_WORKITEM_INSTANCE_ID
1329: ,'DONOR_SP_ID'
1330: );
1331:

Line 1333: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1329: ,'DONOR_SP_ID'
1330: );
1331:
1332: l_recipient_sp_id :=
1333: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1334: (p_WORKITEM_INSTANCE_ID
1335: ,'RECIPIENT_SP_ID'
1336: );
1337:

Line 1339: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1335: ,'RECIPIENT_SP_ID'
1336: );
1337:
1338: l_SP_NAME :=
1339: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1340: (p_WORKITEM_INSTANCE_ID
1341: ,'SP_NAME'
1342: );
1343:

Line 1373: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.DETERMINE_SP_ROLE');

1369: -- Grab the error message and error no.
1370: x_error_code := SQLCODE;
1371:
1372: fnd_message.set_name('XNP','STD_ERROR');
1373: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.DETERMINE_SP_ROLE');
1374: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1375: x_error_message := fnd_message.get;
1376:
1377: END DETERMINE_SP_ROLE;

Line 1413: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1409:
1410: x_error_code := 0;
1411:
1412: l_starting_number :=
1413: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1414: (p_WORKITEM_INSTANCE_ID
1415: ,'STARTING_NUMBER'
1416: );
1417:

Line 1419: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1415: ,'STARTING_NUMBER'
1416: );
1417:
1418: l_ENDING_NUMBER :=
1419: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1420: (p_WORKITEM_INSTANCE_ID
1421: ,'ENDING_NUMBER'
1422: );
1423:

Line 1425: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1421: ,'ENDING_NUMBER'
1422: );
1423:
1424: l_SP_NAME :=
1425: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1426: (p_WORKITEM_INSTANCE_ID
1427: ,'SP_NAME'
1428: );
1429:

Line 1487: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');

1483: -- Grab the error message and error no.
1484: x_error_code := SQLCODE;
1485:
1486: fnd_message.set_name('XNP','STD_ERROR');
1487: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
1488: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1489: x_error_message := fnd_message.get;
1490:
1491: END SOA_UPDATE_SV_STATUS;

Line 1531: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1527:
1528: x_error_code := 0;
1529:
1530: l_porting_id :=
1531: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1532: (p_WORKITEM_INSTANCE_ID
1533: ,'PORTING_ID'
1534: );
1535:

Line 1537: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1533: ,'PORTING_ID'
1534: );
1535:
1536: l_invoice_due_date :=
1537: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1538: (p_WORKITEM_INSTANCE_ID
1539: ,'INVOICE_DUE_DATE'
1540: );
1541:

Line 1543: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1539: ,'INVOICE_DUE_DATE'
1540: );
1541:
1542: l_charging_info :=
1543: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1544: (p_WORKITEM_INSTANCE_ID
1545: ,'CHARGING_INFO'
1546: );
1547:

Line 1549: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1545: ,'CHARGING_INFO'
1546: );
1547:
1548: l_BILLING_ID :=
1549: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1550: (p_WORKITEM_INSTANCE_ID
1551: ,'BILLING_ID'
1552: );
1553:

Line 1555: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1551: ,'BILLING_ID'
1552: );
1553:
1554: l_USER_LOCTN_VALUE :=
1555: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1556: (p_WORKITEM_INSTANCE_ID
1557: ,'USER_LOCTN_VALUE'
1558: );
1559:

Line 1561: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1557: ,'USER_LOCTN_VALUE'
1558: );
1559:
1560: l_USER_LOCTN_TYPE :=
1561: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1562: (p_WORKITEM_INSTANCE_ID
1563: ,'USER_LOCTN_TYPE'
1564: );
1565:

Line 1567: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1563: ,'USER_LOCTN_TYPE'
1564: );
1565:
1566: l_PRICE_CODE :=
1567: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1568: (p_WORKITEM_INSTANCE_ID
1569: ,'PRICE_CODE'
1570: );
1571:

Line 1573: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1569: ,'PRICE_CODE'
1570: );
1571:
1572: l_PRICE_PER_CALL :=
1573: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1574: (p_WORKITEM_INSTANCE_ID
1575: ,'PRICE_PER_CALL'
1576: );
1577:

Line 1579: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1575: ,'PRICE_PER_CALL'
1576: );
1577:
1578: l_PRICE_PER_MINUTE :=
1579: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1580: (p_WORKITEM_INSTANCE_ID
1581: ,'PRICE_PER_MINUTE'
1582: );
1583:

Line 1585: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1581: ,'PRICE_PER_MINUTE'
1582: );
1583:
1584: l_SP_NAME :=
1585: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1586: (p_WORKITEM_INSTANCE_ID
1587: ,'SP_NAME'
1588: );
1589:

Line 1617: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');

1613: -- Grab the error message and error no.
1614: x_error_code := SQLCODE;
1615:
1616: fnd_message.set_name('XNP','STD_ERROR');
1617: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');
1618: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1619: x_error_message := fnd_message.get;
1620:
1621: END SOA_UPDATE_CHARGING_INFO;

Line 1645: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1641: x_error_code := 0;
1642:
1643: -- Get the starting and ending TN for this workitem
1644: x_ORDER_STATUS :=
1645: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1646: (p_WORKITEM_INSTANCE_ID
1647: ,'ORDER_RESULT'
1648: );
1649:

Line 1656: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_ORDER_STATUS');

1652: -- Grab the error message and error no.
1653: x_error_code := SQLCODE;
1654:
1655: fnd_message.set_name('XNP','STD_ERROR');
1656: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_ORDER_STATUS');
1657: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1658: x_error_message := fnd_message.get;
1659:
1660: END SOA_CHECK_ORDER_STATUS;

Line 1688: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1684: x_error_code := 0;
1685:
1686:
1687: l_starting_number :=
1688: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1689: (p_WORKITEM_INSTANCE_ID
1690: ,'STARTING_NUMBER'
1691: );
1692:

Line 1694: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1690: ,'STARTING_NUMBER'
1691: );
1692:
1693: l_ending_number :=
1694: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1695: (p_WORKITEM_INSTANCE_ID
1696: ,'ENDING_NUMBER'
1697: );
1698:

Line 1700: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1696: ,'ENDING_NUMBER'
1697: );
1698:
1699: l_SP_NAME :=
1700: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1701: (p_WORKITEM_INSTANCE_ID
1702: ,'SP_NAME'
1703: );
1704:

Line 1721: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_SOA_STATUS_EXISTS');

1717: -- Grab the error message and error no.
1718: x_error_code := SQLCODE;
1719:
1720: fnd_message.set_name('XNP','STD_ERROR');
1721: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_SOA_STATUS_EXISTS');
1722: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1723: x_error_message := fnd_message.get;
1724:
1725: END CHECK_SOA_STATUS_EXISTS;

Line 1749: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE

1745:
1746: IF p_ORDER_RESULT = 'SUCCESS' THEN
1747:
1748: -- Set the order result to 'Y'
1749: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE
1750: (p_WORKITEM_INSTANCE_ID
1751: ,'ORDER_RESULT'
1752: ,'Y'
1753: ,NULL

Line 1756: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE

1752: ,'Y'
1753: ,NULL
1754: );
1755:
1756: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE
1757: (p_WORKITEM_INSTANCE_ID
1758: ,'ORDER_REJECT_CODE'
1759: ,'SUCCESS'
1760: ,NULL

Line 1763: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE

1759: ,'SUCCESS'
1760: ,NULL
1761: );
1762:
1763: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE
1764: (p_WORKITEM_INSTANCE_ID
1765: ,'ORDER_REJECT_EXPLN'
1766: ,'SUCCESS'
1767: ,NULL

Line 1773: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE

1769:
1770: ELSE
1771:
1772: -- Set the order result to 'N'
1773: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE
1774: (p_WORKITEM_INSTANCE_ID
1775: ,'ORDER_RESULT'
1776: ,'N'
1777: ,NULL

Line 1780: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE

1776: ,'N'
1777: ,NULL
1778: );
1779:
1780: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE
1781: (p_WORKITEM_INSTANCE_ID
1782: ,'ORDER_REJECT_CODE'
1783: ,'FAILURE'
1784: ,NULL

Line 1787: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE

1783: ,'FAILURE'
1784: ,NULL
1785: );
1786:
1787: XNP_STANDARD.SET_WORKITEM_PARAM_VALUE
1788: (p_WORKITEM_INSTANCE_ID
1789: ,'ORDER_REJECT_EXPLN'
1790: ,'FAILURE'
1791: ,NULL

Line 1802: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SET_ORDER_RESULT');

1798: -- Grab the error message and error no.
1799: x_error_code := SQLCODE;
1800:
1801: fnd_message.set_name('XNP','STD_ERROR');
1802: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SET_ORDER_RESULT');
1803: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1804: x_error_message := fnd_message.get;
1805:
1806: END SET_ORDER_RESULT;

Line 1914: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

1910: );
1911:
1912: -- Get the value from the WI Parameters
1913: l_wf_value :=
1914: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
1915: (p_WORKITEM_INSTANCE_ID
1916: ,l_value
1917: );
1918:

Line 1937: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1933: END IF; -- param list is not null
1934:
1935: -- Get the SENDER NAME
1936: l_sender_name :=
1937: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1938: (p_WORKITEM_INSTANCE_ID
1939: ,'SP_NAME'
1940: );
1941:

Line 2019: ,'XNP_STANDARD.PUBLISH_EVENT');

2015: x_error_code := SQLCODE;
2016:
2017: fnd_message.set_name('XNP','STD_ERROR');
2018: fnd_message.set_token('ERROR_LOCN'
2019: ,'XNP_STANDARD.PUBLISH_EVENT');
2020: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2021: x_error_message := fnd_message.get;
2022: END;
2023:

Line 2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');

2125: IF x_error_code <> 0
2126: THEN
2127: fnd_message.set_name('XNP','STD_GET_FAILED');
2128: fnd_message.set_token
2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2132: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2133: x_error_message := fnd_message.get||':'||x_error_message;

Line 2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');

2153: IF x_error_code <> 0
2154: THEN
2155: fnd_message.set_name('XNP','STD_GET_FAILED');
2156: fnd_message.set_token
2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2160: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2161: x_error_message := fnd_message.get||':'||x_error_message;

Line 2172: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');

2168: -- Grab the error message and error no.
2169: x_error_code := SQLCODE;
2170: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2171: fnd_message.set_token
2172: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);
2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2175: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2176: x_error_message :=

Line 2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');

2214: THEN
2215: fnd_message.set_name('XNP','STD_GET_FAILED');
2216: fnd_message.set_token('ATTRNAME',p_RECEIVER);
2217: fnd_message.set_token
2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2221: x_error_message := fnd_message.get;
2222: x_error_message := fnd_message.get||':'||x_error_message;

Line 2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');

2231:
2232: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2233: fnd_message.set_token('DYNA_PROC',p_RECEIVER);
2234: fnd_message.set_token
2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2237: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2238: x_error_message := fnd_message.get||':'||x_error_message;
2239: END;

Line 2294: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2290:
2291:
2292: -- Get the value from the WI Parameters
2293: l_wf_value :=
2294: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2295: (p_WORKITEM_INSTANCE_ID
2296: ,l_value
2297: );
2298:

Line 2318: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2314: END IF; -- p_PARAM_LIST not null
2315:
2316: -- Get the SENDER NAME
2317: l_sender_name :=
2318: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2319: (p_WORKITEM_INSTANCE_ID
2320: ,'SP_NAME'
2321: );
2322:

Line 2325: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2321: );
2322:
2323: -- Get the opposite party's reference id
2324: l_OPP_REFERENCE_ID :=
2325: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2326: (p_WORKITEM_INSTANCE_ID
2327: ,'OPP_REFERENCE_ID'
2328: );
2329:

Line 2380: XNP_STANDARD.FE_NAME := l_fe_name;

2376: -- BUG # 1500177
2377: -- This FE_NAME is used by the publish() called within the send()
2378: -- while doing push() to the queue to populate correct FE_NAME
2379:
2380: XNP_STANDARD.FE_NAME := l_fe_name;
2381:
2382:
2383: BEGIN
2384: EXECUTE IMMEDIATE l_proc_call USING

Line 2401: XNP_STANDARD.FE_NAME := null;

2397:
2398: EXCEPTION
2399: WHEN OTHERS THEN
2400:
2401: XNP_STANDARD.FE_NAME := null;
2402:
2403: -- Grab the error message and error no.
2404: x_error_code := SQLCODE;
2405:

Line 2407: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SEND_MESSAGE');

2403: -- Grab the error message and error no.
2404: x_error_code := SQLCODE;
2405:
2406: fnd_message.set_name('XNP','STD_ERROR');
2407: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SEND_MESSAGE');
2408: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2409: x_error_message := fnd_message.get;
2410: END;
2411:

Line 2412: XNP_STANDARD.FE_NAME := null;

2408: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2409: x_error_message := fnd_message.get;
2410: END;
2411:
2412: XNP_STANDARD.FE_NAME := null;
2413:
2414: END SEND_MESSAGE;
2415:
2416:

Line 2442: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2438: x_error_code := 0;
2439: -- Get the starting and ending TN for this workitem
2440:
2441: l_starting_number :=
2442: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2443: (p_WORKITEM_INSTANCE_ID
2444: ,'STARTING_NUMBER'
2445: );
2446:

Line 2448: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2444: ,'STARTING_NUMBER'
2445: );
2446:
2447: l_ending_number :=
2448: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2449: (p_WORKITEM_INSTANCE_ID
2450: ,'ENDING_NUMBER'
2451: );
2452:

Line 2470: ,'XNP_STANDARD.SMS_DELETE_FE_MAP');

2466: x_error_code := SQLCODE;
2467:
2468: fnd_message.set_name('XNP','STD_ERROR');
2469: fnd_message.set_token('ERROR_LOCN'
2470: ,'XNP_STANDARD.SMS_DELETE_FE_MAP');
2471: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2472: x_error_message := fnd_message.get;
2473:
2474: END SMS_DELETE_FE_MAP;

Line 2510: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2506: x_error_code := 0;
2507: x_CHECK_STATUS := 'N';
2508:
2509: l_starting_number :=
2510: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2511: (p_WORKITEM_INSTANCE_ID
2512: ,'STARTING_NUMBER'
2513: );
2514:

Line 2516: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2512: ,'STARTING_NUMBER'
2513: );
2514:
2515: l_ending_number :=
2516: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2517: (p_WORKITEM_INSTANCE_ID
2518: ,'ENDING_NUMBER'
2519: );
2520:

Line 2522: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2518: ,'ENDING_NUMBER'
2519: );
2520:
2521: l_SP_NAME :=
2522: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2523: (p_WORKITEM_INSTANCE_ID
2524: ,'SP_NAME'
2525: );
2526:

Line 2571: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_PHASE_FOR_ROLE');

2567: -- Grab the error message and error no.
2568: x_error_code := SQLCODE;
2569:
2570: fnd_message.set_name('XNP','STD_ERROR');
2571: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_PHASE_FOR_ROLE');
2572: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2573: x_error_message := fnd_message.get;
2574: END CHECK_PHASE_FOR_ROLE;
2575:

Line 2625: ,'XNP_STANDARD.SUBSCRIBE_FOR_EVENT');

2621: x_error_code := SQLCODE;
2622:
2623: fnd_message.set_name('XNP','STD_ERROR');
2624: fnd_message.set_token('ERROR_LOCN'
2625: ,'XNP_STANDARD.SUBSCRIBE_FOR_EVENT');
2626: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2627: x_error_message := fnd_message.get;
2628: END SUBSCRIBE_FOR_EVENT;
2629:

Line 2646: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2642: BEGIN
2643:
2644: -- Get the work item parameter 'SUBSEQUENT_PORT'
2645: x_CHECK_STATUS :=
2646: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2647: (p_WORKITEM_INSTANCE_ID
2648: ,'SUBSEQUENT_PORT'
2649: );
2650:

Line 2662: ,'XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT');

2658: x_error_code := SQLCODE;
2659:
2660: fnd_message.set_name('XNP','STD_ERROR');
2661: fnd_message.set_token('ERROR_LOCN'
2662: ,'XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT');
2663: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2664: x_error_message := fnd_message.get;
2665: END SOA_IS_SUBSEQUENT_PORT;
2666:

Line 2692: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2688:
2689: x_error_code := 0;
2690:
2691: l_starting_number :=
2692: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2693: (p_WORKITEM_INSTANCE_ID
2694: ,'STARTING_NUMBER'
2695: );
2696:

Line 2698: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2694: ,'STARTING_NUMBER'
2695: );
2696:
2697: l_ending_number :=
2698: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2699: (p_WORKITEM_INSTANCE_ID
2700: ,'ENDING_NUMBER'
2701: );
2702:

Line 2727: ,'XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS');

2723: x_error_code := SQLCODE;
2724:
2725: fnd_message.set_name('XNP','STD_ERROR');
2726: fnd_message.set_token('ERROR_LOCN'
2727: ,'XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS');
2728: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2729: x_error_message := fnd_message.get;
2730:
2731: END SMS_UPDATE_FE_MAP_STATUS;

Line 2788: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2784:
2785: x_error_code := 0;
2786:
2787: l_porting_id :=
2788: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2789: (p_WORKITEM_INSTANCE_ID
2790: ,'PORTING_ID'
2791: );
2792:

Line 2794: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2790: ,'PORTING_ID'
2791: );
2792:
2793: l_porting_time :=
2794: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2795: (p_WORKITEM_INSTANCE_ID
2796: ,'PORTING_TIME'
2797: );
2798:

Line 2800: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2796: ,'PORTING_TIME'
2797: );
2798:
2799: l_starting_number :=
2800: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2801: (p_WORKITEM_INSTANCE_ID
2802: ,'STARTING_NUMBER'
2803: );
2804:

Line 2806: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2802: ,'STARTING_NUMBER'
2803: );
2804:
2805: l_ending_number :=
2806: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2807: (p_WORKITEM_INSTANCE_ID
2808: ,'ENDING_NUMBER'
2809: );
2810:

Line 2812: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2808: ,'ENDING_NUMBER'
2809: );
2810:
2811: l_routing_number :=
2812: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2813: (p_WORKITEM_INSTANCE_ID
2814: ,'ROUTING_NUMBER'
2815: );
2816:

Line 2831: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2827: RETURN;
2828: END IF;
2829:
2830: l_SUBSCRIPTION_TYPE :=
2831: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2832: (p_WORKITEM_INSTANCE_ID
2833: ,'SUBSCRIPTION_TYPE'
2834: );
2835: if (l_SUBSCRIPTION_TYPE IS null) then

Line 2840: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2836: l_SUBSCRIPTION_TYPE := 'NP';
2837: end if;
2838:
2839: l_CNAM_ADDRESS :=
2840: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2841: (p_WORKITEM_INSTANCE_ID
2842: ,'CNAM_ADDRESS'
2843: );
2844:

Line 2846: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2842: ,'CNAM_ADDRESS'
2843: );
2844:
2845: l_CNAM_SUBSYSTEM :=
2846: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2847: (p_WORKITEM_INSTANCE_ID
2848: ,'CNAM_SUBSYSTEM'
2849: );
2850:

Line 2852: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2848: ,'CNAM_SUBSYSTEM'
2849: );
2850:
2851: l_ISVM_ADDRESS :=
2852: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2853: (p_WORKITEM_INSTANCE_ID
2854: ,'ISVM_ADDRESS'
2855: );
2856:

Line 2858: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2854: ,'ISVM_ADDRESS'
2855: );
2856:
2857: l_ISVM_SUBSYSTEM :=
2858: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2859: (p_WORKITEM_INSTANCE_ID
2860: ,'ISVM_SUBSYSTEM'
2861: );
2862:

Line 2864: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2860: ,'ISVM_SUBSYSTEM'
2861: );
2862:
2863: l_LIDB_ADDRESS :=
2864: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2865: (p_WORKITEM_INSTANCE_ID
2866: ,'LIDB_ADDRESS'
2867: );
2868:

Line 2870: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2866: ,'LIDB_ADDRESS'
2867: );
2868:
2869: l_LIDB_SUBSYSTEM :=
2870: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2871: (p_WORKITEM_INSTANCE_ID
2872: ,'LIDB_SUBSYSTEM'
2873: );
2874:

Line 2876: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2872: ,'LIDB_SUBSYSTEM'
2873: );
2874:
2875: l_CLASS_ADDRESS :=
2876: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2877: (p_WORKITEM_INSTANCE_ID
2878: ,'CLASS_ADDRESS'
2879: );
2880:

Line 2882: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2878: ,'CLASS_ADDRESS'
2879: );
2880:
2881: l_CLASS_SUBSYSTEM :=
2882: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2883: (p_WORKITEM_INSTANCE_ID
2884: ,'CLASS_SUBSYSTEM'
2885: );
2886:

Line 2888: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2884: ,'CLASS_SUBSYSTEM'
2885: );
2886:
2887: l_WSMSC_ADDRESS :=
2888: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2889: (p_WORKITEM_INSTANCE_ID
2890: ,'WSMSC_ADDRESS'
2891: );
2892:

Line 2894: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2890: ,'WSMSC_ADDRESS'
2891: );
2892:
2893: l_WSMSC_SUBSYSTEM :=
2894: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2895: (p_WORKITEM_INSTANCE_ID
2896: ,'WSMSC_SUBSYSTEM'
2897: );
2898:

Line 2900: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2896: ,'WSMSC_SUBSYSTEM'
2897: );
2898:
2899: l_RN_ADDRESS :=
2900: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2901: (p_WORKITEM_INSTANCE_ID
2902: ,'RN_ADDRESS'
2903: );
2904:

Line 2906: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

2902: ,'RN_ADDRESS'
2903: );
2904:
2905: l_RN_SUBSYSTEM :=
2906: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
2907: (p_WORKITEM_INSTANCE_ID
2908: ,'RN_SUBSYSTEM'
2909: );
2910:

Line 2943: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER');

2939: -- Grab the error message and error no.
2940: x_error_code := SQLCODE;
2941:
2942: fnd_message.set_name('XNP','STD_ERROR');
2943: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER');
2944: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2945: x_error_message := fnd_message.get;
2946: END SMS_MODIFY_PORTED_NUMBER;
2947:

Line 2971: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2967:
2968: BEGIN
2969:
2970: l_STARTING_NUMBER :=
2971: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2972: (p_WORKITEM_INSTANCE_ID
2973: ,'STARTING_NUMBER'
2974: );
2975:

Line 2977: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2973: ,'STARTING_NUMBER'
2974: );
2975:
2976: l_ENDING_NUMBER :=
2977: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2978: (p_WORKITEM_INSTANCE_ID
2979: ,'ENDING_NUMBER'
2980: );
2981:

Line 2983: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2979: ,'ENDING_NUMBER'
2980: );
2981:
2982: l_DONOR_SP_CODE :=
2983: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2984: (p_WORKITEM_INSTANCE_ID
2985: ,'DONOR_SP_ID'
2986: );
2987:

Line 3018: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS');

3014: -- Grab the error message and error no.
3015: x_error_code := SQLCODE;
3016:
3017: fnd_message.set_name('XNP','STD_ERROR');
3018: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS');
3019: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3020: x_error_message := fnd_message.get;
3021: END SOA_CHECK_DON_STATUS_EXISTS;
3022:

Line 3046: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3042:
3043: BEGIN
3044:
3045: l_STARTING_NUMBER :=
3046: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3047: (p_WORKITEM_INSTANCE_ID
3048: ,'STARTING_NUMBER'
3049: );
3050:

Line 3052: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3048: ,'STARTING_NUMBER'
3049: );
3050:
3051: l_ENDING_NUMBER :=
3052: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3053: (p_WORKITEM_INSTANCE_ID
3054: ,'ENDING_NUMBER'
3055: );
3056:

Line 3058: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3054: ,'ENDING_NUMBER'
3055: );
3056:
3057: l_RECIPIENT_SP_CODE :=
3058: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3059: (p_WORKITEM_INSTANCE_ID
3060: ,'RECIPIENT_SP_ID'
3061: );
3062:

Line 3092: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS');

3088: -- Grab the error message and error no.
3089: x_error_code := SQLCODE;
3090:
3091: fnd_message.set_name('XNP','STD_ERROR');
3092: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS');
3093: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3094: x_error_message := fnd_message.get;
3095: END SOA_CHECK_REC_STATUS_EXISTS;
3096:

Line 3137: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3133: BEGIN
3134: x_error_code := 0;
3135:
3136: l_porting_id :=
3137: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3138: (p_WORKITEM_INSTANCE_ID
3139: ,'PORTING_ID'
3140: );
3141:

Line 3143: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3139: ,'PORTING_ID'
3140: );
3141:
3142: l_starting_number :=
3143: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3144: (p_WORKITEM_INSTANCE_ID
3145: ,'STARTING_NUMBER'
3146: );
3147:

Line 3149: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3145: ,'STARTING_NUMBER'
3146: );
3147:
3148: l_ENDING_NUMBER :=
3149: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3150: (p_WORKITEM_INSTANCE_ID
3151: ,'ENDING_NUMBER'
3152: );
3153:

Line 3155: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3151: ,'ENDING_NUMBER'
3152: );
3153:
3154: l_SP_NAME :=
3155: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3156: (p_WORKITEM_INSTANCE_ID
3157: ,'SP_NAME'
3158: );
3159:

Line 3224: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');

3220: -- Grab the error message and error no.
3221: x_error_code := SQLCODE;
3222:
3223: fnd_message.set_name('XNP','STD_ERROR');
3224: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
3225: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3226: x_error_message := fnd_message.get;
3227:
3228: END SOA_UPDATE_SV_STATUS;

Line 3256: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3252:
3253: x_error_code := 0;
3254:
3255: l_PORTING_ID :=
3256: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3257: (p_WORKITEM_INSTANCE_ID
3258: ,'PORTING_ID'
3259: );
3260:

Line 3262: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3258: ,'PORTING_ID'
3259: );
3260:
3261: l_COMMENTS :=
3262: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3263: (p_WORKITEM_INSTANCE_ID
3264: ,'COMMENTS'
3265: );
3266:

Line 3268: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3264: ,'COMMENTS'
3265: );
3266:
3267: l_NOTES :=
3268: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3269: (p_WORKITEM_INSTANCE_ID
3270: ,'NOTES'
3271: );
3272:

Line 3274: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3270: ,'NOTES'
3271: );
3272:
3273: l_PREORDER_AUTHORIZATION_CODE :=
3274: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3275: (p_WORKITEM_INSTANCE_ID
3276: ,'PREORDER_AUTHORIZATION_CODE'
3277: );
3278:

Line 3281: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3277: );
3278:
3279:
3280: l_SP_NAME :=
3281: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3282: (p_WORKITEM_INSTANCE_ID
3283: ,'SP_NAME'
3284: );
3285:

Line 3310: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');

3306: -- Grab the error message and error no.
3307: x_error_code := SQLCODE;
3308:
3309: fnd_message.set_name('XNP','STD_ERROR');
3310: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');
3311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3312: x_error_message := fnd_message.get;
3313:
3314: END SOA_UPDATE_NOTES_INFO;

Line 3359: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3355:
3356: x_error_code := 0;
3357:
3358: l_PORTING_ID :=
3359: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3360: (p_WORKITEM_INSTANCE_ID
3361: ,'PORTING_ID'
3362: );
3363:

Line 3365: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3361: ,'PORTING_ID'
3362: );
3363:
3364: l_CNAM_ADDRESS :=
3365: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3366: (p_WORKITEM_INSTANCE_ID
3367: ,'CNAM_ADDRESS'
3368: );
3369:

Line 3371: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3367: ,'CNAM_ADDRESS'
3368: );
3369:
3370: l_CNAM_SUBSYSTEM :=
3371: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3372: (p_WORKITEM_INSTANCE_ID
3373: ,'CNAM_SUBSYSTEM'
3374: );
3375:

Line 3377: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3373: ,'CNAM_SUBSYSTEM'
3374: );
3375:
3376: l_ISVM_ADDRESS :=
3377: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3378: (p_WORKITEM_INSTANCE_ID
3379: ,'ISVM_ADDRESS'
3380: );
3381:

Line 3383: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3379: ,'ISVM_ADDRESS'
3380: );
3381:
3382: l_ISVM_SUBSYSTEM :=
3383: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3384: (p_WORKITEM_INSTANCE_ID
3385: ,'ISVM_SUBSYSTEM'
3386: );
3387:

Line 3389: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3385: ,'ISVM_SUBSYSTEM'
3386: );
3387:
3388: l_LIDB_ADDRESS :=
3389: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3390: (p_WORKITEM_INSTANCE_ID
3391: ,'LIDB_ADDRESS'
3392: );
3393:

Line 3395: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3391: ,'LIDB_ADDRESS'
3392: );
3393:
3394: l_LIDB_SUBSYSTEM :=
3395: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3396: (p_WORKITEM_INSTANCE_ID
3397: ,'LIDB_SUBSYSTEM'
3398: );
3399:

Line 3401: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3397: ,'LIDB_SUBSYSTEM'
3398: );
3399:
3400: l_CLASS_ADDRESS :=
3401: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3402: (p_WORKITEM_INSTANCE_ID
3403: ,'CLASS_ADDRESS'
3404: );
3405:

Line 3407: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3403: ,'CLASS_ADDRESS'
3404: );
3405:
3406: l_CLASS_SUBSYSTEM :=
3407: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3408: (p_WORKITEM_INSTANCE_ID
3409: ,'CLASS_SUBSYSTEM'
3410: );
3411:

Line 3413: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3409: ,'CLASS_SUBSYSTEM'
3410: );
3411:
3412: l_WSMSC_ADDRESS :=
3413: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3414: (p_WORKITEM_INSTANCE_ID
3415: ,'WSMSC_ADDRESS'
3416: );
3417:

Line 3419: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3415: ,'WSMSC_ADDRESS'
3416: );
3417:
3418: l_WSMSC_SUBSYSTEM :=
3419: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3420: (p_WORKITEM_INSTANCE_ID
3421: ,'WSMSC_SUBSYSTEM'
3422: );
3423:

Line 3425: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3421: ,'WSMSC_SUBSYSTEM'
3422: );
3423:
3424: l_RN_ADDRESS :=
3425: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3426: (p_WORKITEM_INSTANCE_ID
3427: ,'RN_ADDRESS'
3428: );
3429:

Line 3431: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3427: ,'RN_ADDRESS'
3428: );
3429:
3430: l_RN_SUBSYSTEM :=
3431: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3432: (p_WORKITEM_INSTANCE_ID
3433: ,'RN_SUBSYSTEM'
3434: );
3435:

Line 3438: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3434: );
3435:
3436: -- Get the routing number id
3437: l_ROUTING_NUMBER :=
3438: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3439: (p_WORKITEM_INSTANCE_ID
3440: ,'ROUTING_NUMBER'
3441: );
3442:

Line 3458: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3454: END IF;
3455:
3456:
3457: l_SP_NAME :=
3458: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3459: (p_WORKITEM_INSTANCE_ID
3460: ,'SP_NAME'
3461: );
3462:

Line 3496: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');

3492: WHEN OTHERS THEN
3493: -- Grab the error message and error no.
3494: x_error_code := SQLCODE;
3495: fnd_message.set_name('XNP','STD_ERROR');
3496: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');
3497: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3498: x_error_message := fnd_message.get;
3499:
3500: END SOA_UPDATE_NETWORK_INFO;

Line 3544: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3540:
3541: x_error_code := 0;
3542:
3543: l_PORTING_ID :=
3544: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3545: (p_WORKITEM_INSTANCE_ID
3546: ,'PORTING_ID'
3547: );
3548:

Line 3550: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3546: ,'PORTING_ID'
3547: );
3548:
3549: l_CUSTOMER_ID :=
3550: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3551: (p_WORKITEM_INSTANCE_ID
3552: ,'CUSTOMER_ID'
3553: );
3554:

Line 3556: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3552: ,'CUSTOMER_ID'
3553: );
3554:
3555: l_CUSTOMER_NAME :=
3556: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3557: (p_WORKITEM_INSTANCE_ID
3558: ,'CUSTOMER_NAME'
3559: );
3560:

Line 3562: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3558: ,'CUSTOMER_NAME'
3559: );
3560:
3561: l_CUSTOMER_TYPE :=
3562: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3563: (p_WORKITEM_INSTANCE_ID
3564: ,'CUSTOMER_TYPE'
3565: );
3566:

Line 3568: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3564: ,'CUSTOMER_TYPE'
3565: );
3566:
3567: l_ADDRESS_LINE1 :=
3568: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3569: (p_WORKITEM_INSTANCE_ID
3570: ,'ADDRESS_LINE1'
3571: );
3572:

Line 3574: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3570: ,'ADDRESS_LINE1'
3571: );
3572:
3573: l_ADDRESS_LINE2 :=
3574: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3575: (p_WORKITEM_INSTANCE_ID
3576: ,'ADDRESS_LINE2'
3577: );
3578:

Line 3580: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3576: ,'ADDRESS_LINE2'
3577: );
3578:
3579: l_CITY :=
3580: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3581: (p_WORKITEM_INSTANCE_ID
3582: ,'CITY'
3583: );
3584:

Line 3586: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3582: ,'CITY'
3583: );
3584:
3585: l_PHONE :=
3586: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3587: (p_WORKITEM_INSTANCE_ID
3588: ,'PHONE'
3589: );
3590:

Line 3592: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3588: ,'PHONE'
3589: );
3590:
3591: l_FAX :=
3592: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3593: (p_WORKITEM_INSTANCE_ID
3594: ,'FAX'
3595: );
3596:

Line 3598: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3594: ,'FAX'
3595: );
3596:
3597: l_EMAIL :=
3598: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3599: (p_WORKITEM_INSTANCE_ID
3600: ,'EMAIL'
3601: );
3602:

Line 3604: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3600: ,'EMAIL'
3601: );
3602:
3603: l_ZIP_CODE :=
3604: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3605: (p_WORKITEM_INSTANCE_ID
3606: ,'ZIP_CODE'
3607: );
3608:

Line 3610: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3606: ,'ZIP_CODE'
3607: );
3608:
3609: l_COUNTRY :=
3610: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3611: (p_WORKITEM_INSTANCE_ID
3612: ,'COUNTRY'
3613: );
3614:

Line 3616: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3612: ,'COUNTRY'
3613: );
3614:
3615: l_CUSTOMER_CONTACT_REQ_FLAG :=
3616: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3617: (p_WORKITEM_INSTANCE_ID
3618: ,'CUSTOMER_CONTACT_REQ_FLAG'
3619: );
3620:

Line 3622: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3618: ,'CUSTOMER_CONTACT_REQ_FLAG'
3619: );
3620:
3621: l_CONTACT_NAME :=
3622: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3623: (p_WORKITEM_INSTANCE_ID
3624: ,'CONTACT_NAME'
3625: );
3626:

Line 3629: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3625: );
3626:
3627:
3628: l_PAGER :=
3629: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3630: (p_WORKITEM_INSTANCE_ID
3631: ,'PAGER'
3632: );
3633:

Line 3635: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3631: ,'PAGER'
3632: );
3633:
3634: l_PAGER_PIN :=
3635: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3636: (p_WORKITEM_INSTANCE_ID
3637: ,'PAGER_PIN'
3638: );
3639:

Line 3641: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3637: ,'PAGER_PIN'
3638: );
3639:
3640: l_INTERNET_ADDRESS :=
3641: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3642: (p_WORKITEM_INSTANCE_ID
3643: ,'INTERNET_ADDRESS'
3644: );
3645:

Line 3648: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3644: );
3645:
3646:
3647: l_SP_NAME :=
3648: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3649: (p_WORKITEM_INSTANCE_ID
3650: ,'SP_NAME'
3651: );
3652:

Line 3689: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');

3685: WHEN OTHERS THEN
3686: -- Grab the error message and error no.
3687: x_error_code := SQLCODE;
3688: fnd_message.set_name('XNP','STD_ERROR');
3689: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');
3690: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3691: x_error_message := fnd_message.get;
3692:
3693: END SOA_UPDATE_CUSTOMER_INFO;

Line 3720: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3716:
3717: x_ERROR_CODE:=0;
3718:
3719: l_starting_number :=
3720: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3721: (p_WORKITEM_INSTANCE_ID
3722: ,'STARTING_NUMBER'
3723: );
3724:

Line 3726: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3722: ,'STARTING_NUMBER'
3723: );
3724:
3725: l_ending_number :=
3726: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3727: (p_WORKITEM_INSTANCE_ID
3728: ,'ENDING_NUMBER'
3729: );
3730:

Line 3732: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3728: ,'ENDING_NUMBER'
3729: );
3730:
3731: l_donor_sp_code :=
3732: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3733: (p_WORKITEM_INSTANCE_ID
3734: ,'DONOR_SP_ID'
3735: );
3736:

Line 3738: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3734: ,'DONOR_SP_ID'
3735: );
3736:
3737: l_recipient_sp_code :=
3738: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3739: (p_WORKITEM_INSTANCE_ID
3740: ,'RECIPIENT_SP_ID'
3741: );
3742:

Line 3744: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

3740: ,'RECIPIENT_SP_ID'
3741: );
3742:
3743: l_routing_number :=
3744: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
3745: (p_WORKITEM_INSTANCE_ID
3746: ,'ROUTING_NUMBER'
3747: );
3748:

Line 3768: fnd_message.set_token('ERROR_LOCN' ,'XNP_STANDARD.RUNTIME_VALIDATION');

3764: -- Grab the error message and error no.
3765: x_error_code := SQLCODE;
3766:
3767: fnd_message.set_name('XNP','STD_ERROR');
3768: fnd_message.set_token('ERROR_LOCN' ,'XNP_STANDARD.RUNTIME_VALIDATION');
3769: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3770: x_error_message := fnd_message.get;
3771:
3772:

Line 3787: xnp_timer_standard.deregister(p_order_id => DEREGISTER_ALL.p_order_id,

3783:
3784: BEGIN
3785:
3786: x_error_code := 0;
3787: xnp_timer_standard.deregister(p_order_id => DEREGISTER_ALL.p_order_id,
3788: x_error_code => DEREGISTER_ALL.x_error_code,
3789: x_error_message => DEREGISTER_ALL.x_error_message);
3790:
3791: if (x_error_code <> 0 ) then

Line 3806: END XNP_STANDARD;

3802: end if;
3803:
3804: END DEREGISTER_ALL;
3805:
3806: END XNP_STANDARD;