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 XNP_UTILS

Line 36: XNP_UTILS.NOTIFY_ERROR

32: RETURN l_VALUE;
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

Line 78: XNP_UTILS.NOTIFY_ERROR

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

Line 350: ,p_PORTING_TIME =>XNP_UTILS.CANONICAL_TO_DATE(l_porting_time)

346: ,p_STARTING_NUMBER =>to_number(l_STARTING_NUMBER)
347: ,p_ENDING_NUMBER =>to_number(l_ENDING_NUMBER)
348: ,p_SUBSCRIPTION_TYPE =>l_SUBSCRIPTION_TYPE
349: ,p_ROUTING_NUMBER_ID =>l_ROUTING_NUMBER_ID
350: ,p_PORTING_TIME =>XNP_UTILS.CANONICAL_TO_DATE(l_porting_time)
351: ,p_CNAM_ADDRESS =>l_CNAM_ADDRESS
352: ,p_CNAM_SUBSYSTEM =>l_CNAM_SUBSYSTEM
353: ,p_ISVM_ADDRESS =>l_ISVM_ADDRESS
354: ,p_ISVM_SUBSYSTEM =>l_ISVM_SUBSYSTEM

Line 523: ,p_old_sp_cutoff_due_date=> xnp_utils.canonical_to_date(l_cutoff_date)

519: -- call updation procedure to update the status
520:
521: XNP_CORE.SOA_UPDATE_CUTOFF_DATE
522: (p_porting_id => l_porting_id
523: ,p_old_sp_cutoff_due_date=> xnp_utils.canonical_to_date(l_cutoff_date)
524: ,p_local_sp_id => l_LOCAL_SP_ID
525: ,p_order_id => p_order_id
526: ,p_lineitem_id => p_lineitem_id
527: ,p_workitem_instance_id => p_workitem_instance_id

Line 540: ,p_old_sp_cutoff_due_date=> xnp_utils.canonical_to_date(l_cutoff_date)

536: (p_starting_number => l_starting_number
537: ,p_ending_number => l_ending_number
538: ,p_CUR_STATUS_TYPE_CODE => p_CUR_STATUS_TYPE_CODE
539: ,p_local_sp_id => l_LOCAL_SP_ID
540: ,p_old_sp_cutoff_due_date=> xnp_utils.canonical_to_date(l_cutoff_date)
541: ,p_order_id => p_order_id
542: ,p_lineitem_id => p_lineitem_id
543: ,p_workitem_instance_id => p_workitem_instance_id
544: ,p_fa_instance_id => p_fa_instance_id

Line 1045: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)

1041: ,p_SUBSCRIPTION_TYPE =>l_SUBSCRIPTION_TYPE
1042: ,p_DONOR_SP_ID =>l_DONOR_SP_ID
1043: ,p_RECIPIENT_SP_ID =>l_RECIPIENT_SP_ID
1044: ,p_ROUTING_NUMBER =>l_ROUTING_NUMBER
1045: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)
1046: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)
1047: ,p_CUSTOMER_ID =>l_CUSTOMER_ID
1048: ,p_CUSTOMER_NAME =>l_CUSTOMER_NAME
1049: ,p_CUSTOMER_TYPE =>l_CUSTOMER_TYPE

Line 1046: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)

1042: ,p_DONOR_SP_ID =>l_DONOR_SP_ID
1043: ,p_RECIPIENT_SP_ID =>l_RECIPIENT_SP_ID
1044: ,p_ROUTING_NUMBER =>l_ROUTING_NUMBER
1045: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)
1046: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)
1047: ,p_CUSTOMER_ID =>l_CUSTOMER_ID
1048: ,p_CUSTOMER_NAME =>l_CUSTOMER_NAME
1049: ,p_CUSTOMER_TYPE =>l_CUSTOMER_TYPE
1050: ,p_ADDRESS_LINE1 =>l_ADDRESS_LINE1

Line 1078: ,p_ACTIVATION_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_ACTIVATION_DUE_DATE)

1074: ,p_WSMSC_SUBSYSTEM =>l_WSMSC_SUBSYSTEM
1075: ,p_RN_ADDRESS =>l_RN_ADDRESS
1076: ,p_RN_SUBSYSTEM =>l_RN_SUBSYSTEM
1077: ,p_PREORDER_AUTHORIZATION_CODE=>l_PREORDER_AUTHORIZATION_CODE
1078: ,p_ACTIVATION_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_ACTIVATION_DUE_DATE)
1079: ,p_ORDER_PRIORITY =>l_ORDER_PRIORITY
1080: ,p_SUBSEQUENT_PORT_FLAG => l_SUBSEQUENT_PORT_FLAG
1081: ,p_COMMENTS => l_COMMENTS
1082: ,p_NOTES => l_NOTES

Line 1107: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)

1103: ,p_SUBSCRIPTION_TYPE =>l_SUBSCRIPTION_TYPE
1104: ,p_DONOR_SP_ID =>l_DONOR_SP_ID
1105: ,p_RECIPIENT_SP_ID =>l_RECIPIENT_SP_ID
1106: ,p_ROUTING_NUMBER =>l_ROUTING_NUMBER
1107: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)
1108: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)
1109: ,p_CUSTOMER_ID =>l_CUSTOMER_ID
1110: ,p_CUSTOMER_NAME =>l_CUSTOMER_NAME
1111: ,p_CUSTOMER_TYPE =>l_CUSTOMER_TYPE

Line 1108: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)

1104: ,p_DONOR_SP_ID =>l_DONOR_SP_ID
1105: ,p_RECIPIENT_SP_ID =>l_RECIPIENT_SP_ID
1106: ,p_ROUTING_NUMBER =>l_ROUTING_NUMBER
1107: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)
1108: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)
1109: ,p_CUSTOMER_ID =>l_CUSTOMER_ID
1110: ,p_CUSTOMER_NAME =>l_CUSTOMER_NAME
1111: ,p_CUSTOMER_TYPE =>l_CUSTOMER_TYPE
1112: ,p_ADDRESS_LINE1 =>l_ADDRESS_LINE1

Line 1140: ,p_ACTIVATION_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_ACTIVATION_DUE_DATE)

1136: ,p_WSMSC_SUBSYSTEM =>l_WSMSC_SUBSYSTEM
1137: ,p_RN_ADDRESS =>l_RN_ADDRESS
1138: ,p_RN_SUBSYSTEM =>l_RN_SUBSYSTEM
1139: ,p_PREORDER_AUTHORIZATION_CODE=>l_PREORDER_AUTHORIZATION_CODE
1140: ,p_ACTIVATION_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_ACTIVATION_DUE_DATE)
1141: ,p_ORDER_PRIORITY =>l_ORDER_PRIORITY
1142: ,p_SUBSEQUENT_PORT_FLAG => l_SUBSEQUENT_PORT_FLAG
1143: ,p_COMMENTS => l_COMMENTS
1144: ,p_NOTES => l_NOTES

Line 1166: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)

1162: ,p_SUBSCRIPTION_TYPE =>l_SUBSCRIPTION_TYPE
1163: ,p_DONOR_SP_ID =>l_DONOR_SP_ID
1164: ,p_RECIPIENT_SP_ID =>l_RECIPIENT_SP_ID
1165: ,p_ROUTING_NUMBER =>l_ROUTING_NUMBER
1166: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)
1167: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)
1168: ,p_CUSTOMER_ID =>l_CUSTOMER_ID
1169: ,p_CUSTOMER_NAME =>l_CUSTOMER_NAME
1170: ,p_CUSTOMER_TYPE =>l_CUSTOMER_TYPE

Line 1167: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)

1163: ,p_DONOR_SP_ID =>l_DONOR_SP_ID
1164: ,p_RECIPIENT_SP_ID =>l_RECIPIENT_SP_ID
1165: ,p_ROUTING_NUMBER =>l_ROUTING_NUMBER
1166: ,p_NEW_SP_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_SP_DUE_DATE)
1167: ,p_OLD_SP_CUTOFF_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_OLD_SP_CUTOFF_DUE_DATE)
1168: ,p_CUSTOMER_ID =>l_CUSTOMER_ID
1169: ,p_CUSTOMER_NAME =>l_CUSTOMER_NAME
1170: ,p_CUSTOMER_TYPE =>l_CUSTOMER_TYPE
1171: ,p_ADDRESS_LINE1 =>l_ADDRESS_LINE1

Line 1199: ,p_ACTIVATION_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_ACTIVATION_DUE_DATE)

1195: ,p_WSMSC_SUBSYSTEM =>l_WSMSC_SUBSYSTEM
1196: ,p_RN_ADDRESS =>l_RN_ADDRESS
1197: ,p_RN_SUBSYSTEM =>l_RN_SUBSYSTEM
1198: ,p_PREORDER_AUTHORIZATION_CODE=>l_PREORDER_AUTHORIZATION_CODE
1199: ,p_ACTIVATION_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_ACTIVATION_DUE_DATE)
1200: ,p_ORDER_PRIORITY =>l_ORDER_PRIORITY
1201: ,p_SUBSEQUENT_PORT_FLAG => l_SUBSEQUENT_PORT_FLAG
1202: ,p_COMMENTS => l_COMMENTS
1203: ,p_NOTES => l_NOTES

Line 1595: ,p_INVOICE_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_invoice_due_date)

1591:
1592: XNP_CORE.SOA_UPDATE_CHARGING_INFO
1593: (p_porting_id =>l_porting_id
1594: ,p_LOCAL_SP_ID =>l_LOCAL_SP_ID
1595: ,p_INVOICE_DUE_DATE =>XNP_UTILS.CANONICAL_TO_DATE(l_invoice_due_date)
1596: ,p_CHARGING_INFO =>l_charging_info
1597: ,p_BILLING_ID =>l_BILLING_ID
1598: ,p_USER_LOCTN_VALUE =>l_USER_LOCTN_VALUE
1599: ,p_USER_LOCTN_TYPE =>l_USER_LOCTN_TYPE

Line 2916: ,p_PORTING_TIME =>XNP_UTILS.CANONICAL_TO_DATE(l_porting_time)

2912: (p_PORTING_ID =>l_porting_id
2913: ,p_STARTING_NUMBER =>to_number(l_STARTING_NUMBER)
2914: ,p_ENDING_NUMBER =>to_number(l_ENDING_NUMBER)
2915: ,p_ROUTING_NUMBER_ID =>l_ROUTING_NUMBER_ID
2916: ,p_PORTING_TIME =>XNP_UTILS.CANONICAL_TO_DATE(l_porting_time)
2917: ,p_CNAM_ADDRESS =>l_CNAM_ADDRESS
2918: ,p_CNAM_SUBSYSTEM =>l_CNAM_SUBSYSTEM
2919: ,p_ISVM_ADDRESS =>l_ISVM_ADDRESS
2920: ,p_ISVM_SUBSYSTEM =>l_ISVM_SUBSYSTEM