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

APPS.XNP_WF_STANDARD dependencies on XNP_UTILS

Line 352: XNP_UTILS.NOTIFY_ERROR

348: ELSE
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

Line 452: XNP_UTILS.NOTIFY_ERROR

448: ELSE
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

Line 569: XNP_UTILS.NOTIFY_ERROR

565: ELSE
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

Line 690: XNP_UTILS.NOTIFY_ERROR

686: ELSE
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

Line 817: XNP_UTILS.NOTIFY_ERROR

813: ELSE
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

Line 924: XNP_UTILS.NOTIFY_ERROR

920: ELSE
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

Line 1015: XNP_UTILS.CHECK_TO_GET_REF_ID

1011: END;
1012:
1013: -- Get the callback reference id
1014:
1015: XNP_UTILS.CHECK_TO_GET_REF_ID
1016: (p_itemtype => itemtype
1017: ,p_itemkey => itemkey
1018: ,p_actid => actid
1019: ,p_workitem_instance_id => l_workitem_instance_id

Line 1097: XNP_UTILS.NOTIFY_ERROR

1093: ELSE
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

Line 1176: XNP_UTILS.CHECK_TO_GET_REF_ID

1172: wf_core.clear;
1173: END;
1174:
1175: -- Get the callback reference id
1176: XNP_UTILS.CHECK_TO_GET_REF_ID
1177: (p_itemtype => itemtype
1178: ,p_itemkey => itemkey
1179: ,p_actid => actid
1180: ,p_workitem_instance_id => l_workitem_instance_id

Line 1254: XNP_UTILS.NOTIFY_ERROR

1250: ELSE
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

Line 1402: XNP_UTILS.NOTIFY_ERROR

1398: ELSE
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

Line 1571: XNP_UTILS.NOTIFY_ERROR

1567: ELSE
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

Line 1731: XNP_UTILS.NOTIFY_ERROR

1727: ELSE
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

Line 1843: XNP_UTILS.NOTIFY_ERROR

1839: ELSE
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

Line 1957: XNP_UTILS.NOTIFY_ERROR

1953: ELSE
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

Line 2186: XNP_UTILS.NOTIFY_ERROR

2182: ELSE
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

Line 2296: XNP_UTILS.NOTIFY_ERROR

2292: ELSE
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

Line 2403: XNP_UTILS.CHECK_TO_GET_REF_ID

2399:
2400:
2401: -- Get the callback reference id
2402:
2403: XNP_UTILS.CHECK_TO_GET_REF_ID
2404: (p_itemtype => itemtype
2405: ,p_itemkey => itemkey
2406: ,p_actid => actid
2407: ,p_workitem_instance_id => l_workitem_instance_id

Line 2473: XNP_UTILS.NOTIFY_ERROR

2469: ELSE
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

Line 2594: XNP_UTILS.NOTIFY_ERROR

2590: ELSE
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

Line 2706: XNP_UTILS.NOTIFY_ERROR

2702: ELSE
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

Line 2806: XNP_UTILS.NOTIFY_ERROR

2802: ELSE
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

Line 2991: XNP_UTILS.CHECK_TO_GET_REF_ID

2987: END IF;
2988: END;
2989:
2990: -- Get the callback reference id
2991: XNP_UTILS.CHECK_TO_GET_REF_ID
2992: (p_itemtype => itemtype
2993: ,p_itemkey => itemkey
2994: ,p_actid => actid
2995: ,p_workitem_instance_id => l_workitem_instance_id

Line 3075: XNP_UTILS.NOTIFY_ERROR

3071: ELSE
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

Line 3186: XNP_UTILS.GET_FE_NAME

3182:
3183: FOR l_tmp_fe IN c_ALL_FEs LOOP
3184:
3185: /*****
3186: XNP_UTILS.GET_FE_NAME
3187: (p_FE_ID=>l_TMP_FE.FE_ID
3188: ,x_FE_NAME=>l_FE_NAME
3189: ,x_ERROR_CODE=>l_ERROR_CODE
3190: ,x_ERROR_MESSAGE=>l_ERROR_MESSAGE

Line 3284: XNP_UTILS.NOTIFY_ERROR

3280: ELSE
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

Line 3407: XNP_UTILS.NOTIFY_ERROR

3403: ELSE
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

Line 3545: XNP_UTILS.NOTIFY_ERROR

3541: ELSE
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

Line 3680: XNP_UTILS.NOTIFY_ERROR

3676: ELSE
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

Line 4103: XNP_UTILS.NOTIFY_ERROR

4099: ELSE
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

Line 4224: XNP_UTILS.NOTIFY_ERROR

4220: ELSE
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

Line 4357: XNP_UTILS.NOTIFY_ERROR

4353: ELSE
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

Line 4476: XNP_UTILS.NOTIFY_ERROR

4472: ELSE
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

Line 4584: XNP_UTILS.GET_FE_NAME

4580: ------------------------------------------------------------------
4581:
4582: FOR l_tmp_fe IN c_ALL_FEs LOOP
4583: /***** Marked out to use overloaded xdp_eng_util.ad_fa_towi with fe_id itself.
4584: XNP_UTILS.GET_FE_NAME
4585: (p_FE_ID=>l_TMP_FE.FE_ID
4586: ,x_FE_NAME=>l_FE_NAME
4587: ,x_ERROR_CODE=>l_ERROR_CODE
4588: ,x_ERROR_MESSAGE=>l_ERROR_MESSAGE

Line 4680: XNP_UTILS.NOTIFY_ERROR

4676: ELSE
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

Line 4788: XNP_UTILS.NOTIFY_ERROR

4784: ELSE
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

Line 4876: p_NEW_SP_DUE_DATE => xnp_utils.canonical_to_date(l_NEW_SP_DUE_DATE),

4872: p_workitem_instance_id => l_workitem_instance_id,
4873: p_fa_instance_id => l_fa_instance_id,
4874: p_porting_id => l_porting_id,
4875: p_local_sp_id => l_local_sp_id,
4876: p_NEW_SP_DUE_DATE => xnp_utils.canonical_to_date(l_NEW_SP_DUE_DATE),
4877: x_error_code => l_error_code,
4878: x_error_message => l_error_message
4879: );
4880:

Line 4920: XNP_UTILS.NOTIFY_ERROR

4916: x_progress := to_char(l_error_code)||':'||l_error_message;
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

Line 5009: p_OLD_SP_DUE_DATE => xnp_utils.canonical_to_date(l_OLD_SP_DUE_DATE),

5005: p_workitem_instance_id => l_workitem_instance_id ,
5006: p_fa_instance_id => l_fa_instance_id ,
5007: p_porting_id => l_porting_id,
5008: p_local_sp_id => l_local_sp_id,
5009: p_OLD_SP_DUE_DATE => xnp_utils.canonical_to_date(l_OLD_SP_DUE_DATE),
5010: x_error_code => l_error_code,
5011: x_error_message => l_error_message
5012: );
5013:

Line 5053: XNP_UTILS.NOTIFY_ERROR

5049: x_progress := to_char(l_error_code)||':'||l_error_message;
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

Line 5166: XNP_UTILS.NOTIFY_ERROR

5162: x_progress := to_char(l_error_code)||':'||l_error_message;
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

Line 5277: XNP_UTILS.NOTIFY_ERROR

5273: x_progress := to_char(l_error_code)||':'||l_error_message;
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

Line 5405: XNP_UTILS.NOTIFY_ERROR

5401: ELSE
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

Line 5605: XNP_UTILS.NOTIFY_ERROR

5601: ELSE
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

Line 5777: XNP_UTILS.NOTIFY_ERROR

5773: ELSE
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

Line 5878: p_new_sp_due_date =>xnp_utils.canonical_to_date(l_date_value),

5874: p_workitem_instance_id =>l_workitem_instance_id ,
5875: p_fa_instance_id =>l_fa_instance_id,
5876: p_porting_id =>l_porting_id,
5877: p_local_sp_id =>l_local_sp_id,
5878: p_new_sp_due_date =>xnp_utils.canonical_to_date(l_date_value),
5879: x_error_code =>l_error_code,
5880: x_error_message =>l_error_message
5881: );
5882:

Line 5898: p_OLD_SP_DUE_DATE =>xnp_utils.canonical_to_date(l_date_value),

5894: p_workitem_instance_id =>l_workitem_instance_id ,
5895: p_fa_instance_id =>l_fa_instance_id,
5896: p_porting_id =>l_porting_id,
5897: p_local_sp_id =>l_local_sp_id,
5898: p_OLD_SP_DUE_DATE =>xnp_utils.canonical_to_date(l_date_value),
5899: x_error_code =>l_error_code,
5900: x_error_message =>l_error_message
5901: );
5902:

Line 5918: p_ACTIVATION_DUE_DATE =>xnp_utils.canonical_to_date(l_date_value),

5914: p_workitem_instance_id =>l_workitem_instance_id ,
5915: p_fa_instance_id =>l_fa_instance_id,
5916: p_porting_id =>l_porting_id,
5917: p_local_sp_id =>l_local_sp_id,
5918: p_ACTIVATION_DUE_DATE =>xnp_utils.canonical_to_date(l_date_value),
5919: x_error_code =>l_error_code,
5920: x_error_message =>l_error_message
5921: );
5922:

Line 5937: p_disconnect_due_date =>xnp_utils.canonical_to_date(l_date_value),

5933: p_lineitem_id =>l_lineitem_id,
5934: p_workitem_instance_id =>l_workitem_instance_id ,
5935: p_fa_instance_id =>l_fa_instance_id,
5936: p_porting_id =>l_porting_id,
5937: p_disconnect_due_date =>xnp_utils.canonical_to_date(l_date_value),
5938: x_error_code =>l_error_code,
5939: x_error_message =>l_error_message
5940: );
5941:

Line 5956: p_effective_release_due_date =>xnp_utils.canonical_to_date(l_date_value),

5952: p_lineitem_id =>l_lineitem_id,
5953: p_workitem_instance_id =>l_workitem_instance_id ,
5954: p_fa_instance_id =>l_fa_instance_id,
5955: p_porting_id =>l_porting_id,
5956: p_effective_release_due_date =>xnp_utils.canonical_to_date(l_date_value),
5957: x_error_code =>l_error_code,
5958: x_error_message =>l_error_message
5959: );
5960:

Line 5975: p_number_returned_due_date =>xnp_utils.canonical_to_date(l_date_value),

5971: p_lineitem_id =>l_lineitem_id,
5972: p_workitem_instance_id =>l_workitem_instance_id ,
5973: p_fa_instance_id =>l_fa_instance_id,
5974: p_porting_id =>l_porting_id,
5975: p_number_returned_due_date =>xnp_utils.canonical_to_date(l_date_value),
5976: x_error_code =>l_error_code,
5977: x_error_message =>l_error_message
5978: );
5979: else

Line 6022: XNP_UTILS.NOTIFY_ERROR

6018: ELSE
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

Line 6168: XNP_UTILS.NOTIFY_ERROR

6164: ELSE
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

Line 6312: XNP_UTILS.NOTIFY_ERROR

6308: ELSE
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

Line 6413: XNP_UTILS.NOTIFY_ERROR

6409: ELSE
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

Line 6513: XNP_UTILS.NOTIFY_ERROR

6509: ELSE
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

Line 6614: XNP_UTILS.NOTIFY_ERROR

6610: ELSE
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

Line 6674: xnp_utils.get_interpreted_notification

6670: actid => actid,
6671: aname => 'NOTIFN_MSG_NAME'
6672: );
6673:
6674: xnp_utils.get_interpreted_notification
6675: (p_workitem_instance_id => l_workitem_instance_id
6676: ,p_mls_message_name => l_notfn_msg_name
6677: ,x_subject => l_subject
6678: ,x_body => l_body

Line 6724: XNP_UTILS.NOTIFY_ERROR

6720: ELSE
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

Line 6859: XNP_UTILS.NOTIFY_ERROR

6855: ELSE
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

Line 6970: XNP_UTILS.NOTIFY_ERROR

6966:
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