[Home] [Help]
231: ,'ENDING_NUMBER'
232: );
233:
234: -- verify if its a valid number range
235: xnp_core.get_number_range_id( p_starting_number => l_starting_number,
236: p_ending_number => l_ending_number,
237: x_number_range_id => l_number_range_id,
238: x_error_code => x_error_code,
239: x_error_message => x_error_message
249: );
250:
251: -- Get the routing_number_id corresponding to the code
252:
253: XNP_CORE.GET_ROUTING_NUMBER_ID
254: (l_ROUTING_NUMBER
255: ,l_ROUTING_NUMBER_ID
256: ,x_ERROR_CODE
257: ,x_ERROR_MESSAGE
340: (p_WORKITEM_INSTANCE_ID
341: ,'RN_SUBSYSTEM'
342: );
343:
344: XNP_CORE.SMS_CREATE_PORTED_NUMBER
345: (p_PORTING_ID =>l_porting_id
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
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
392: --
393: ------------------------------------------------------------------
394: PROCEDURE SMS_DELETE_PORTED_NUMBER
395: (p_WORKITEM_INSTANCE_ID IN NUMBER
415: (p_WORKITEM_INSTANCE_ID
416: ,'ENDING_NUMBER'
417: );
418:
419: XNP_CORE.SMS_DELETE_PORTED_NUMBER
420: (p_STARTING_NUMBER=>l_starting_number
421: ,p_ENDING_NUMBER=>l_ending_number
422: ,x_ERROR_CODE=>x_ERROR_CODE
423: ,x_ERROR_MESSAGE=>x_ERROR_MESSAGE
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
459: -- cutoff date of each TN in the range
460: ------------------------------------------------------------------
461: PROCEDURE SOA_UPDATE_CUTOFF_DATE
462: ( p_ORDER_ID IN NUMBER,
517: IF( l_porting_id is not null) THEN
518:
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
531: );
532: ELSE
533: -- call updation procedure to update the status
534:
535: XNP_CORE.SOA_UPDATE_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
672: ,'ENDING_NUMBER'
673: );
674:
675: /**** Moved this code to validate the number range to individual
676: create_port_order APIs in XNP_CORE package on 04/11/2001 -- spusegao
677: in order to accomodate NRC_NOVALIDATION SP Role
678:
679: -- verify if its a valid number range
680:
677: in order to accomodate NRC_NOVALIDATION SP Role
678:
679: -- verify if its a valid number range
680:
681: xnp_core.get_number_range_id( p_starting_number => l_starting_number,
682: p_ending_number => l_ending_number,
683: x_number_range_id => l_number_range_id,
684: x_error_code => x_error_code,
685: x_error_message => x_error_message
695: ,'DONOR_SP_ID'
696: );
697:
698: -- Get the SP id for this SP code
699: XNP_CORE.GET_SP_ID
700: (l_DONOR_SP_CODE
701: ,l_DONOR_SP_ID
702: ,x_ERROR_CODE
703: ,x_ERROR_MESSAGE
713: ,'RECIPIENT_SP_ID'
714: );
715:
716: -- Get the SP id for this recipient code
717: XNP_CORE.GET_SP_ID
718: (l_RECIPIENT_SP_CODE
719: ,l_RECIPIENT_SP_ID
720: ,x_ERROR_CODE
721: ,x_ERROR_MESSAGE
998: -- Get the routing_number_id corresponding to the code
999:
1000: IF (l_ROUTING_NUMBER IS NOT NULL) THEN
1001:
1002: XNP_CORE.GET_ROUTING_NUMBER_ID
1003: (l_routing_number
1004: ,l_ROUTING_NUMBER_ID
1005: ,x_ERROR_CODE
1006: ,x_ERROR_MESSAGE
1033:
1034: IF (p_SP_ROLE = 'RECIPIENT') THEN
1035: --{ Create porting order for the recipient SP
1036:
1037: XNP_CORE.SOA_CREATE_REC_PORT_ORDER
1038: (p_PORTING_ID =>l_PORTING_ID
1039: ,p_STARTING_NUMBER =>to_number(l_STARTING_NUMBER)
1040: ,p_ENDING_NUMBER =>to_number(l_ENDING_NUMBER)
1041: ,p_SUBSCRIPTION_TYPE =>l_SUBSCRIPTION_TYPE
1095: l_validation_flag := 'N';
1096: END IF;
1097:
1098:
1099: XNP_CORE.SOA_CREATE_NRC_PORT_ORDER
1100: (p_PORTING_ID =>l_PORTING_ID
1101: ,p_STARTING_NUMBER =>to_number(l_STARTING_NUMBER)
1102: ,p_ENDING_NUMBER =>to_number(l_ENDING_NUMBER)
1103: ,p_SUBSCRIPTION_TYPE =>l_SUBSCRIPTION_TYPE
1154: END IF;
1155: --}
1156: ELSE --{ if DONOR
1157: -- create porting order from DONOR
1158: XNP_CORE.SOA_CREATE_DON_PORT_ORDER
1159: (p_PORTING_ID =>l_PORTING_ID
1160: ,p_STARTING_NUMBER =>to_number(l_STARTING_NUMBER)
1161: ,p_ENDING_NUMBER =>to_number(l_ENDING_NUMBER)
1162: ,p_SUBSCRIPTION_TYPE =>l_SUBSCRIPTION_TYPE
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: ------------------------------------------------------------------
1232: PROCEDURE SOA_CHECK_NOTIFY_DIR_SVS
1233: (
1258: (p_WORKITEM_INSTANCE_ID
1259: ,'SP_NAME'
1260: );
1261:
1262: XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS
1263: (p_porting_id =>l_PORTING_ID
1264: ,p_local_sp_id =>l_local_sp_id
1265: ,x_check_status =>x_CHECK_STATUS
1266: ,x_error_code =>x_ERROR_CODE
1347: ELSIF l_recipient_sp_id = l_SP_NAME THEN
1348: x_SP_ROLE := 'RECIPIENT';
1349: RETURN;
1350: ELSE
1351: XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR
1352: (p_DONOR_SP_ID =>l_DONOR_SP_ID
1353: ,p_STARTING_NUMBER =>l_STARTING_NUMBER
1354: ,p_ENDING_NUMBER =>l_ENDING_NUMBER
1355: ,x_CHECK_STATUS =>l_CHECK_STATUS
1427: ,'SP_NAME'
1428: );
1429:
1430: -- Get the phase of new status being set
1431: XNP_CORE.GET_PHASE_FOR_STATUS
1432: (p_CUR_STATUS_TYPE_CODE =>p_NEW_STATUS_TYPE_CODE
1433: ,x_PHASE_INDICATOR =>l_NEW_PHASE_INDICATOR
1434: ,x_ERROR_CODE =>x_ERROR_CODE
1435: ,x_ERROR_MESSAGE =>x_ERROR_MESSAGE
1443: -- Ensure that no other SV exists in Active state
1444: ------------------------------------------------------------------
1445: IF l_NEW_PHASE_INDICATOR = 'ACTIVE' THEN
1446:
1447: XNP_CORE.SOA_RESET_SV_STATUS
1448: (p_STARTING_NUMBER => l_starting_number
1449: ,p_ENDING_NUMBER => l_ending_number
1450: ,p_LOCAL_SP_ID => l_LOCAL_SP_ID
1451: ,p_CUR_PHASE_INDICATOR => l_NEW_PHASE_INDICATOR
1462: END IF;
1463:
1464: -- call updation procedure to update the status
1465:
1466: XNP_CORE.SOA_UPDATE_SV_STATUS
1467: (p_STARTING_NUMBER => l_starting_number
1468: ,p_ENDING_NUMBER => l_ending_number
1469: ,p_CUR_STATUS_TYPE_CODE => p_cur_status_type_code
1470: ,p_LOCAL_SP_ID => l_LOCAL_SP_ID
1588: );
1589:
1590: -- call updation procedure to update the charging info
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
1624: --
1625: -- Called when: Inquiry or Order response is awaited
1626: -- Description:
1627: -- Gets the TN range and calls
1628: -- and calls XNP_CORE.SOA_CHECK_ORDER_STATUS
1629: -- References the following WI parameter
1630: -- ORDER_STATUS
1631: ------------------------------------------------------------------
1632: PROCEDURE SOA_CHECK_ORDER_STATUS
1701: (p_WORKITEM_INSTANCE_ID
1702: ,'SP_NAME'
1703: );
1704:
1705: XNP_CORE.CHECK_SOA_STATUS_EXISTS
1706: (l_STARTING_NUMBER
1707: ,l_ENDING_NUMBER
1708: ,p_STATUS_TYPE_CODE
1709: ,l_LOCAL_SP_ID
2418: --
2419: -- Called when: During provisioning phase of the order
2420: -- Called by:
2421: -- Description:
2422: -- Calls XNP_CORE.SMS_DELETE_FE_MAP
2423: -- References WI params STARTING_NUMBER, ENDING_NUMBER
2424: --
2425: ------------------------------------------------------------------
2426: PROCEDURE SMS_DELETE_FE_MAP
2449: (p_WORKITEM_INSTANCE_ID
2450: ,'ENDING_NUMBER'
2451: );
2452:
2453: -- Call XNP_CORE.SMS_DELETE_FE_MAP
2454: XNP_CORE.SMS_DELETE_FE_MAP
2455: (l_STARTING_NUMBER
2456: ,l_ENDING_NUMBER
2457: ,p_FE_ID
2450: ,'ENDING_NUMBER'
2451: );
2452:
2453: -- Call XNP_CORE.SMS_DELETE_FE_MAP
2454: XNP_CORE.SMS_DELETE_FE_MAP
2455: (l_STARTING_NUMBER
2456: ,l_ENDING_NUMBER
2457: ,p_FE_ID
2458: ,p_FEATURE_TYPE
2524: ,'SP_NAME'
2525: );
2526:
2527: -- Get the SP id for this SP code
2528: XNP_CORE.GET_SP_ID
2529: (l_SP_NAME
2530: ,l_SP_ID
2531: ,x_ERROR_CODE
2532: ,x_ERROR_MESSAGE
2539:
2540: IF p_SP_ROLE = 'DONOR'
2541: THEN
2542: -- check for TN in given phase with SP as donor
2543: XNP_CORE.CHECK_DONOR_PHASE
2544: (p_STARTING_NUMBER =>l_STARTING_NUMBER
2545: ,p_ENDING_NUMBER =>l_ENDING_NUMBER
2546: ,p_SP_ID =>l_SP_ID
2547: ,p_PHASE_INDICATOR =>p_PHASE_INDICATOR
2550: ,x_ERROR_MESSAGE =>x_ERROR_MESSAGE
2551: );
2552: ELSE
2553: -- check for TN in given phase with SP as recipient
2554: XNP_CORE.CHECK_RECIPIENT_PHASE
2555: (p_STARTING_NUMBER =>l_STARTING_NUMBER
2556: ,p_ENDING_NUMBER =>l_ENDING_NUMBER
2557: ,p_SP_ID =>l_SP_ID
2558: ,p_PHASE_INDICATOR =>p_PHASE_INDICATOR
2701: );
2702:
2703: -- call updation procedure to get the fe list
2704:
2705: XNP_CORE.SMS_UPDATE_FE_MAP_STATUS
2706: (p_STARTING_NUMBER => l_STARTING_NUMBER
2707: ,p_ENDING_NUMBER => l_ENDING_NUMBER
2708: ,p_FE_ID => p_FE_ID
2709: ,p_PROV_STATUS => p_PROV_STATUS
2815: );
2816:
2817: -- Get the routing_number_id corresponding to the code
2818:
2819: XNP_CORE.GET_ROUTING_NUMBER_ID
2820: (l_ROUTING_NUMBER
2821: ,l_ROUTING_NUMBER_ID
2822: ,x_ERROR_CODE
2823: ,x_ERROR_MESSAGE
2907: (p_WORKITEM_INSTANCE_ID
2908: ,'RN_SUBSYSTEM'
2909: );
2910:
2911: XNP_CORE.SMS_MODIFY_PORTED_NUMBER
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
2945: x_error_message := fnd_message.get;
2946: END SMS_MODIFY_PORTED_NUMBER;
2947:
2948: ------------------------------------------------------------------
2949: -- Calls xnp_core.check_donor_status_exists
2950: -- to check if there exists a porting record
2951: -- for the number range and created by the donor
2952: -- with the given status type code
2953: -- Mandatory WI Parameters: STARTING_NUMBER,ENDING_NUMBER,DONOR_SP_ID
2985: ,'DONOR_SP_ID'
2986: );
2987:
2988: -- Get the SP id for this SP code
2989: XNP_CORE.GET_SP_ID
2990: (l_DONOR_SP_CODE
2991: ,l_DONOR_SP_ID
2992: ,x_ERROR_CODE
2993: ,x_ERROR_MESSAGE
2993: ,x_ERROR_MESSAGE
2994: );
2995:
2996: -- check the status as donor for this number range
2997: XNP_CORE.CHECK_DONOR_STATUS_EXISTS
2998: (p_STARTING_NUMBER =>l_starting_number
2999: ,p_ENDING_NUMBER =>l_ending_number
3000: ,p_STATUS_TYPE_CODE => p_status_to_check_with
3001: ,p_DONOR_SP_ID => l_donor_sp_id
3020: x_error_message := fnd_message.get;
3021: END SOA_CHECK_DON_STATUS_EXISTS;
3022:
3023: ------------------------------------------------------------------
3024: -- Calls xnp_core.check_recipient_status_exists
3025: -- to check if there exists a porting record
3026: -- for the number range and created by the donor
3027: -- with the given status type code
3028: -- Mandatory WI Parameters: STARTING_NUMBER,ENDING_NUMBER,RECIPIENT_SP_ID
3060: ,'RECIPIENT_SP_ID'
3061: );
3062:
3063: -- Get the SP id for this SP code
3064: XNP_CORE.GET_SP_ID
3065: (l_RECIPIENT_SP_CODE
3066: ,l_RECIPIENT_SP_ID
3067: ,x_ERROR_CODE
3068: ,x_ERROR_MESSAGE
3068: ,x_ERROR_MESSAGE
3069: );
3070:
3071: -- check the status as donor for this number range
3072: XNP_CORE.CHECK_RECIPIENT_STATUS_EXISTS
3073: (p_STARTING_NUMBER =>l_starting_number
3074: ,p_ENDING_NUMBER =>l_ending_number
3075: ,p_STATUS_TYPE_CODE => p_status_to_check_with
3076: ,p_RECIPIENT_SP_ID => l_recipient_sp_id
3097: ------------------------------------------------------------------
3098: -- Called when: need to update the SV status according
3099: -- to the activity parameter SV_STATUS
3100: -- Gets the Item Attributes WORKITEM_INSTANCE
3101: -- Calls XNP_CORE.SOA_UPDATE_SV_STATUS
3102: -- Description: Procedure to update the status of
3103: -- the Porting Order Records to the new status
3104: -- for the given PORTING_ID
3105: -- (a.k.a OBJECT_REFERENCE) and
3157: ,'SP_NAME'
3158: );
3159:
3160: -- Get the phase of new status being set
3161: XNP_CORE.GET_PHASE_FOR_STATUS
3162: (p_NEW_STATUS_TYPE_CODE
3163: ,l_NEW_PHASE_INDICATOR
3164: ,x_ERROR_CODE
3165: ,x_ERROR_MESSAGE
3180: FETCH c_CUR_STATUS INTO l_cur_status_type_code;
3181:
3182: IF c_CUR_STATUS%FOUND THEN
3183:
3184: XNP_CORE.SOA_RESET_SV_STATUS
3185: (p_STARTING_NUMBER => l_starting_number
3186: ,p_ENDING_NUMBER => l_ending_number
3187: ,p_LOCAL_SP_ID => l_LOCAL_SP_ID
3188: ,p_CUR_PHASE_INDICATOR => l_NEW_PHASE_INDICATOR
3201: END IF;
3202:
3203: -- call updation procedure to update the status
3204:
3205: XNP_CORE.SOA_UPDATE_SV_STATUS
3206: (p_PORTING_ID => l_porting_id
3207: ,p_LOCAL_SP_ID => l_LOCAL_SP_ID
3208: ,P_NEW_STATUS_TYPE_CODE => p_new_status_type_code
3209: ,P_STATUS_CHANGE_CAUSE_CODE => p_status_change_cause_code
3282: (p_WORKITEM_INSTANCE_ID
3283: ,'SP_NAME'
3284: );
3285:
3286: XNP_CORE.SOA_UPDATE_NOTES_INFO
3287: (p_PORTING_ID => l_PORTING_ID
3288: ,p_LOCAL_SP_ID => l_LOCAL_SP_ID
3289: ,p_PREORDER_AUTHORIZATION_CODE=> l_PREORDER_AUTHORIZATION_CODE
3290: ,p_COMMENTS => l_COMMENTS
3440: ,'ROUTING_NUMBER'
3441: );
3442:
3443: -- Get the routing_number_id corresponding to the code
3444: XNP_CORE.GET_ROUTING_NUMBER_ID
3445: (l_routing_number
3446: ,l_ROUTING_NUMBER_ID
3447: ,x_ERROR_CODE
3448: ,x_ERROR_MESSAGE
3459: (p_WORKITEM_INSTANCE_ID
3460: ,'SP_NAME'
3461: );
3462:
3463: XNP_CORE.SOA_UPDATE_NETWORK_INFO
3464: (p_porting_id => l_porting_id
3465: ,p_LOCAL_SP_ID => l_LOCAL_SP_ID
3466: ,p_ROUTING_NUMBER_ID => l_ROUTING_NUMBER_ID
3467: ,p_CNAM_ADDRESS => l_CNAM_ADDRESS
3649: (p_WORKITEM_INSTANCE_ID
3650: ,'SP_NAME'
3651: );
3652:
3653: XNP_CORE.SOA_UPDATE_CUSTOMER_INFO
3654: (p_PORTING_ID => l_PORTING_ID
3655: ,p_LOCAL_SP_ID => l_LOCAL_SP_ID
3656: ,p_CUSTOMER_ID => l_CUSTOMER_ID
3657: ,p_CUSTOMER_NAME => l_CUSTOMER_NAME
3693: END SOA_UPDATE_CUSTOMER_INFO;
3694:
3695: ----------------------------------------------------------------------
3696: -- Runtime Validation check for NP workitem.
3697: -- Calls XNP_CORE.RUNTIME_VALIDATION
3698: -- Optional WI Params: STARTING_NUMBER,ENDING_NUMBER,ROUTING_NUMBER,
3699: -- DONOR_SP_CODE,RECIPIENT_SP_CODE
3700: ---------------------------------------------------------------------
3701: PROCEDURE RUNTIME_VALIDATION
3745: (p_WORKITEM_INSTANCE_ID
3746: ,'ROUTING_NUMBER'
3747: );
3748:
3749: XNP_CORE.RUNTIME_VALIDATION
3750: (p_ORDER_ID =>p_ORDER_ID
3751: ,p_LINE_ITEM_ID =>p_LINE_ITEM_ID
3752: ,p_WORKITEM_INSTANCE_ID=>p_WORKITEM_INSTANCE_ID
3753: ,p_STARTING_NUMBER=>l_starting_number