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_CORE dependencies on XNP_CORE

Line 1: PACKAGE BODY XNP_CORE AS

1: PACKAGE BODY XNP_CORE AS
2: /* $Header: XNPCOREB.pls 120.2 2006/02/13 07:42:29 dputhiye ship $ */
3:
4:
5: PROCEDURE GET_ASSIGNED_SP_ID

Line 41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');

37: WHEN NO_DATA_FOUND THEN
38: x_error_code := SQLCODE;
39:
40: fnd_message.set_name('XNP','STD_GET_FAILED');
41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');
42: fnd_message.set_token('ATTRNAME','ASSIGNED_SP_ID');
43: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
45: x_error_message := fnd_message.get;

Line 60: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ASSIGNED_SP_ID');

56: WHEN OTHERS THEN
57: x_error_code := SQLCODE;
58:
59: fnd_message.set_name('XNP','STD_ERROR');
60: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ASSIGNED_SP_ID');
61: fnd_message.set_token('ERROR_TEXT',SQLERRM);
62: x_error_message := fnd_message.get;
63:
64: IF c_assigned_sp_id%ISOPEN THEN

Line 105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');

101: WHEN NO_DATA_FOUND THEN
102: x_error_code := SQLCODE;
103:
104: fnd_message.set_name('XNP','STD_GET_FAILED');
105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');
106: fnd_message.set_token('ATTRNAME','SP_ID');
107: fnd_message.set_token('KEY','CODE');
108: fnd_message.set_token('VALUE',p_SP_NAME);
109: x_error_message := fnd_message.get;

Line 124: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_ID');

120: WHEN OTHERS THEN
121: x_error_code := SQLCODE;
122:
123: fnd_message.set_name('XNP','STD_ERROR');
124: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_ID');
125: fnd_message.set_token('ERROR_TEXT',SQLERRM);
126: x_error_message := fnd_message.get;
127:
128: IF c_SP_ID%ISOPEN THEN

Line 167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');

163: WHEN NO_DATA_FOUND THEN
164: x_error_code := SQLCODE;
165:
166: fnd_message.set_name('XNP','STD_GET_FAILED');
167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');
168: fnd_message.set_token('ATTRNAME','CODE');
169: fnd_message.set_token('KEY','SP_ID');
170: fnd_message.set_token('VALUE',to_char(p_SP_ID));
171: x_error_message := fnd_message.get;

Line 187: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_NAME');

183: WHEN OTHERS THEN
184: x_error_code := SQLCODE;
185:
186: fnd_message.set_name('XNP','STD_ERROR');
187: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_NAME');
188: fnd_message.set_token('ERROR_TEXT',SQLERRM);
189: x_error_message := fnd_message.get;
190:
191: IF c_sp_name%ISOPEN THEN

Line 229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');

225: WHEN NO_DATA_FOUND THEN
226: x_error_code := SQLCODE;
227:
228: fnd_message.set_name('XNP','STD_GET_FAILED');
229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');
230: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
231: fnd_message.set_token('KEY','ROUTING_NUMBER');
232: fnd_message.set_token('VALUE',p_ROUTING_NUMBER);
233: x_error_message := fnd_message.get;

Line 249: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ROUTING_NUMBER_ID');

245: WHEN OTHERS THEN
246: x_error_code := SQLCODE;
247:
248: fnd_message.set_name('XNP','STD_ERROR');
249: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ROUTING_NUMBER_ID');
250: fnd_message.set_token('ERROR_TEXT',SQLERRM);
251: x_error_message := fnd_message.get;
252:
253: IF c_routing_number_id%ISOPEN THEN

Line 377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');

373: WHEN NO_DATA_FOUND THEN
374: x_error_code := SQLCODE;
375:
376: fnd_message.set_name('XNP','STD_GET_FAILED');
377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');
378: fnd_message.set_token('ATTRNAME','NRC_ID');
379: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
381: x_error_message := fnd_message.get;

Line 404: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NRC_ID');

400: WHEN OTHERS THEN
401: x_error_code := SQLCODE;
402:
403: fnd_message.set_name('XNP','STD_ERROR');
404: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NRC_ID');
405: fnd_message.set_token('ERROR_TEXT',SQLERRM);
406: x_error_message := fnd_message.get;
407:
408: IF c_geo_id%ISOPEN THEN

Line 458: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SOA_SV_ID');

454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: x_error_code := SQLCODE;
457: fnd_message.set_name('XNP','STD_GET_FAILED');
458: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SOA_SV_ID');
459: fnd_message.set_token('ATTRNAME','SV');
460: fnd_message.set_token('KEY','TN:SPID:PHASE');
461: fnd_message.set_token
462: ('VALUE'

Line 482: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SOA_SV_ID');

478:
479: WHEN OTHERS THEN
480: x_error_code := SQLCODE;
481: fnd_message.set_name('XNP','STD_ERROR');
482: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SOA_SV_ID');
483: fnd_message.set_token('ERROR_TEXT',SQLERRM);
484: x_error_message := fnd_message.get;
485:
486: IF c_sv_id%ISOPEN THEN

Line 525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');

521: WHEN NO_DATA_FOUND THEN
522: x_error_code := SQLCODE;
523:
524: fnd_message.set_name('XNP','STD_GET_FAILED');
525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');
526: fnd_message.set_token('ATTRNAME','PHASE_INDICATOR');
527: fnd_message.set_token('KEY','STATUS_TYPE_CODE');
528: fnd_message.set_token('VALUE',p_CUR_STATUS_TYPE_CODE);
529: x_error_message := fnd_message.get;

Line 545: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_PHASE_FOR_STATUS');

541: WHEN OTHERS THEN
542: x_error_code := SQLCODE;
543:
544: fnd_message.set_name('XNP','STD_ERROR');
545: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_PHASE_FOR_STATUS');
546: fnd_message.set_token('ERROR_TEXT',SQLERRM);
547: x_error_message := fnd_message.get;
548:
549: IF c_phase_indicator%ISOPEN THEN

Line 587: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NUMBER_RANGE_ID');

583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: x_error_code := SQLCODE;
586: fnd_message.set_name('XNP','STD_GET_FAILED');
587: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NUMBER_RANGE_ID');
588: fnd_message.set_token('ATTRNAME','NUMBER_RANGE_ID');
589: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
590: fnd_message.set_token
591: ('VALUE'

Line 607: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NUMBER_RANGE_ID');

603: END IF;
604: WHEN OTHERS THEN
605: x_error_code := SQLCODE;
606: fnd_message.set_name('XNP','STD_ERROR');
607: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NUMBER_RANGE_ID');
608: fnd_message.set_token('ERROR_TEXT',SQLERRM);
609: x_error_message := fnd_message.get;
610: IF c_number_range_id%ISOPEN THEN
611: CLOSE c_number_range_id;

Line 648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');

644: EXCEPTION
645: WHEN NO_DATA_FOUND THEN
646: x_error_code := SQLCODE;
647: fnd_message.set_name('XNP','STD_GET_FAILED');
648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');
649: fnd_message.set_token('ATTRNAME','SMS SV');
650: fnd_message.set_token('KEY','SUBSCRIPTION_TN');
651: fnd_message.set_token('VALUE',p_SUBSCRIPTION_TN);
652: x_error_message := fnd_message.get;

Line 668: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SMS_SV_ID');

664: WHEN OTHERS THEN
665: x_error_code := SQLCODE;
666:
667: fnd_message.set_name('XNP','STD_ERROR');
668: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SMS_SV_ID');
669: fnd_message.set_token('ERROR_TEXT',SQLERRM);
670: x_error_message := fnd_message.get;
671:
672: IF c_sms_id%ISOPEN THEN

Line 724: xnp_core.get_nrc_id

720: x_error_code := 0;
721:
722: -- Get the NRC for the given GEO id
723:
724: xnp_core.get_nrc_id
725: (p_starting_number
726: ,p_ending_number
727: ,l_nrc_id
728: ,x_error_code

Line 849: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SMS_CREATE_PORTED_NUMBER');

845: EXCEPTION
846: WHEN OTHERS THEN
847: x_error_code := SQLCODE;
848: fnd_message.set_name('XNP','STD_ERROR');
849: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SMS_CREATE_PORTED_NUMBER');
850: fnd_message.set_token('ERROR_TEXT',SQLERRM);
851: x_error_message := fnd_message.get;
852:
853: IF c_check_sms_sv_exists%ISOPEN THEN

Line 892: xnp_core.get_phase_for_status

888: l_ending_number := to_char(to_number(p_ending_number));
889:
890: -- Get the phase corresponding to this 'p_cur_status_type_code'
891:
892: xnp_core.get_phase_for_status
893: (p_cur_status_type_code
894: ,l_phase_indicator
895: ,x_error_code
896: ,x_error_message

Line 958: ,'XNP_CORE.SOA_UPDATE_CUTOFF_DATE');

954: WHEN OTHERS THEN
955: x_error_code := SQLCODE;
956: fnd_message.set_name('XNP','STD_ERROR');
957: fnd_message.set_token('ERROR_LOCN'
958: ,'XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
959: fnd_message.set_token('ERROR_TEXT',SQLERRM);
960: x_error_message := fnd_message.get;
961:
962: END SOA_UPDATE_CUTOFF_DATE;

Line 1000: xnp_core.get_phase_for_status

996: l_ending_number := to_char(to_number(p_ending_number));
997:
998: -- Get the phase corresponding to this 'p_cur_status_type_code'
999:
1000: xnp_core.get_phase_for_status
1001: (p_cur_status_type_code
1002: ,l_phase_indicator
1003: ,x_error_code
1004: ,x_error_message

Line 1098: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');

1094: null;
1095: WHEN OTHERS THEN
1096: x_error_code := SQLCODE;
1097: fnd_message.set_name('XNP','STD_ERROR');
1098: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
1099: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1100: x_error_message := fnd_message.get;
1101:
1102: END SOA_UPDATE_SV_STATUS;

Line 1216: xnp_core.get_assigned_sp_id

1212: -- the recipient
1213: --
1214: l_pto_flag := 'N'; -- Default is 'not PTO'
1215:
1216: xnp_core.get_assigned_sp_id
1217: (to_char(p_starting_number)
1218: ,to_char(p_ending_number)
1219: ,l_assigned_sp_id
1220: ,x_error_code

Line 1234: xnp_core.get_nrc_id

1230: END IF;
1231:
1232: -- Get the NRC id
1233:
1234: xnp_core.get_nrc_id
1235: (to_char(p_starting_number)
1236: ,to_char(p_ending_number)
1237: ,l_mediator_sp_id
1238: ,x_error_code

Line 1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');

1246: IF (p_subsequent_port_flag = 'N') AND (l_pto_flag = 'N') THEN
1247: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1248: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1249: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1251: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1252: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1253: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1254: x_error_message := fnd_message.get;

Line 1420: ,'XNP_CORE.SOA_CREATE_REC_PORT_ORDER');

1416: WHEN OTHERS THEN
1417: x_error_code := SQLCODE;
1418: fnd_message.set_name('XNP','STD_ERROR');
1419: fnd_message.set_token('ERROR_LOCN'
1420: ,'XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1421: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1422: x_error_message := fnd_message.get;
1423:
1424: END SOA_CREATE_REC_PORT_ORDER;

Line 1552: xnp_core.get_assigned_sp_id

1548: -- the recipient
1549: --
1550: l_pto_flag := 'N'; -- Default is 'not PTO'
1551:
1552: xnp_core.get_assigned_sp_id
1553: (to_char(p_starting_number)
1554: ,to_char(p_ending_number)
1555: ,l_assigned_sp_id
1556: ,x_error_code

Line 1570: xnp_core.get_nrc_id

1566: END IF;
1567:
1568: -- Get the NRC id
1569:
1570: xnp_core.get_nrc_id
1571: (to_char(p_starting_number)
1572: ,to_char(p_ending_number)
1573: ,l_mediator_sp_id
1574: ,x_error_code

Line 1589: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');

1585:
1586: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1587: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1588: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1589: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1590: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1591: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1592: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1593:

Line 1812: ,'XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');

1808: WHEN OTHERS THEN
1809: x_error_code := SQLCODE;
1810: fnd_message.set_name('XNP','STD_ERROR');
1811: fnd_message.set_token('ERROR_LOCN'
1812: ,'XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1813: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1814: x_error_message := fnd_message.get;
1815:
1816: END SOA_CREATE_NRC_PORT_ORDER;

Line 1950: XNP_CORE.GET_ASSIGNED_SP_ID

1946: -- the recipient
1947: --
1948: l_PTO_FLAG := 'N'; -- Default is 'not PTO'
1949:
1950: XNP_CORE.GET_ASSIGNED_SP_ID
1951: (to_char(p_starting_number)
1952: ,to_char(p_ending_number)
1953: ,l_ASSIGNED_SP_ID
1954: ,x_ERROR_CODE

Line 1969: XNP_CORE.GET_NRC_ID

1965: END IF;
1966:
1967: -- Get the NRC id
1968:
1969: XNP_CORE.GET_NRC_ID
1970: (to_char(p_STARTING_NUMBER)
1971: ,to_char(p_ENDING_NUMBER)
1972: ,l_MEDIATOR_SP_ID
1973: ,x_ERROR_CODE

Line 1988: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');

1984: x_ERROR_CODE := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1985:
1986: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1987: fnd_message.set_token('ERROR_LOCN'
1988: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
1989: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1990: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1991: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1992:

Line 2148: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');

2144: WHEN OTHERS THEN
2145: x_ERROR_CODE := SQLCODE;
2146: fnd_message.set_name('XNP','STD_ERROR');
2147: fnd_message.set_token('ERROR_LOCN'
2148: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
2149: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2150: x_error_message := fnd_message.get;
2151:
2152: END SOA_CREATE_DON_PORT_ORDER;

Line 2186: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');

2182: EXCEPTION
2183: WHEN NO_DATA_FOUND THEN
2184: x_ERROR_CODE := SQLCODE;
2185: fnd_message.set_name('XNP','STD_GET_FAILED');
2186: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2187: fnd_message.set_token('ATTRNAME','RETAIN_DIR_INFO_FLAG');
2188: fnd_message.set_token('KEY','PORTING_ID');
2189: fnd_message.set_token('VALUE',p_PORTING_ID);
2190: x_error_message :=

Line 2206: ,'XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');

2202: WHEN OTHERS THEN
2203: x_ERROR_CODE := SQLCODE;
2204: fnd_message.set_name('XNP','STD_ERROR');
2205: fnd_message.set_token('ERROR_LOCN'
2206: ,'XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2207: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2208: x_error_message := fnd_message.get;
2209:
2210: IF c_CHECK_STATUS%ISOPEN THEN

Line 2233: XNP_CORE.GET_ASSIGNED_SP_ID

2229: x_ERROR_MESSAGE := NULL;
2230: x_CHECK_STATUS := 'N';
2231:
2232:
2233: XNP_CORE.GET_ASSIGNED_SP_ID
2234: (p_STARTING_NUMBER
2235: ,p_ENDING_NUMBER
2236: ,l_SERVING_SP_ID
2237: ,x_ERROR_CODE

Line 2254: ,'XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR');

2250: WHEN OTHERS THEN
2251: x_ERROR_CODE := SQLCODE;
2252: fnd_message.set_name('XNP','STD_ERROR');
2253: fnd_message.set_token('ERROR_LOCN'
2254: ,'XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR');
2255: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2256: x_error_message := fnd_message.get;
2257:
2258: END SOA_CHECK_IF_INITIAL_DONOR;

Line 2298: XNP_CORE.GET_PHASE_FOR_STATUS

2294: l_ending_number := to_char(to_number(p_ending_number));
2295:
2296: -- Get the phase corresponding to this 'p_CUR_STATUS_TYPE_CODE'
2297:
2298: XNP_CORE.GET_PHASE_FOR_STATUS
2299: (p_CUR_STATUS_TYPE_CODE
2300: ,l_PHASE_INDICATOR
2301: ,x_ERROR_CODE
2302: ,x_ERROR_MESSAGE

Line 2367: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');

2363: null;
2364: WHEN OTHERS THEN
2365: x_ERROR_CODE := SQLCODE;
2366: fnd_message.set_name('XNP','STD_ERROR');
2367: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
2368: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2369: x_error_message := fnd_message.get;
2370:
2371: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');

Line 2412: XNP_CORE.GET_SMS_SV_ID

2408: FOR l_counter IN
2409: 0..l_diff
2410: LOOP
2411:
2412: XNP_CORE.GET_SMS_SV_ID
2413: (to_char(l_init+l_counter)
2414: ,l_SV_ID
2415: ,x_ERROR_CODE
2416: ,x_ERROR_MESSAGE

Line 2494: ,'XNP_CORE.SMS_INSERT_FE_MAP');

2490: WHEN OTHERS THEN
2491: x_ERROR_CODE := SQLCODE;
2492: fnd_message.set_name('XNP','STD_ERROR');
2493: fnd_message.set_token('ERROR_LOCN'
2494: ,'XNP_CORE.SMS_INSERT_FE_MAP');
2495: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2496: x_error_message := fnd_message.get;
2497:
2498: IF c_CHECK_IF_MAP_EXISTS%ISOPEN THEN

Line 2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');

2606: null;
2607: WHEN NO_DATA_FOUND THEN
2608: x_ERROR_CODE := SQLCODE;
2609: fnd_message.set_name('XNP','STD_GET_FAILED');
2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');
2611: fnd_message.set_token('KEY','OBJECT_REFERENCE');
2612: fnd_message.set_token('VALUE',p_PORTING_ID);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2614: x_error_message := fnd_message.get;

Line 2626: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');

2622:
2623: WHEN OTHERS THEN
2624: x_ERROR_CODE := SQLCODE;
2625: fnd_message.set_name('XNP','STD_ERROR');
2626: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
2627: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2628: x_error_message := fnd_message.get;
2629:
2630: END SOA_UPDATE_SV_STATUS;

Line 2674: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');

2670: WHEN OTHERS THEN
2671: x_ERROR_CODE := SQLCODE;
2672: fnd_message.set_name('XNP','STD_ERROR');
2673: fnd_message.set_token('ERROR_LOCN'
2674: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
2675: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2676: x_error_message := fnd_message.get;
2677: IF c_SOA_SV_ID%ISOPEN THEN
2678: CLOSE c_SOA_SV_ID;

Line 2719: ,'XNP_CORE.SMS_DELETE_FE_MAP');

2715: WHEN OTHERS THEN
2716: x_ERROR_CODE := SQLCODE;
2717: fnd_message.set_name('XNP','STD_ERROR');
2718: fnd_message.set_token('ERROR_LOCN'
2719: ,'XNP_CORE.SMS_DELETE_FE_MAP');
2720: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2721: x_error_message := fnd_message.get;
2722:
2723:

Line 2774: ,'XNP_CORE.CHECK_DONOR_PHASE');

2770: WHEN OTHERS THEN
2771: x_ERROR_CODE := SQLCODE;
2772: fnd_message.set_name('XNP','STD_ERROR');
2773: fnd_message.set_token('ERROR_LOCN'
2774: ,'XNP_CORE.CHECK_DONOR_PHASE');
2775: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2776: x_error_message := fnd_message.get;
2777:
2778: IF c_SOA_SV_ID%ISOPEN THEN

Line 2832: ,'XNP_CORE.CHECK_RECIPIENT_PHASE');

2828: WHEN OTHERS THEN
2829: x_ERROR_CODE := SQLCODE;
2830: fnd_message.set_name('XNP','STD_ERROR');
2831: fnd_message.set_token('ERROR_LOCN'
2832: ,'XNP_CORE.CHECK_RECIPIENT_PHASE');
2833: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2834: x_error_message := fnd_message.get;
2835:
2836: IF c_SOA_SV_ID%ISOPEN THEN

Line 2971: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_RESET_SV_STATUS');

2967: null;
2968: WHEN OTHERS THEN
2969: x_ERROR_CODE := SQLCODE;
2970: fnd_message.set_name('XNP','STD_ERROR');
2971: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_RESET_SV_STATUS');
2972: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2973: x_error_message := fnd_message.get;
2974:
2975: fnd_message.set_name('XNP','RESET_SV_STATUS');

Line 3016: XNP_CORE.GET_PHASE_FOR_STATUS

3012: l_ending_number := p_ending_number;
3013:
3014: -- Get the phase corresponding to this 'p_CUR_STATUS_TYPE_CODE'
3015:
3016: XNP_CORE.GET_PHASE_FOR_STATUS
3017: (p_CUR_STATUS_TYPE_CODE
3018: ,l_PHASE_INDICATOR
3019: ,x_ERROR_CODE
3020: ,x_ERROR_MESSAGE

Line 3085: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');

3081:
3082: WHEN OTHERS THEN
3083: x_ERROR_CODE := SQLCODE;
3084: fnd_message.set_name('XNP','STD_ERROR');
3085: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3086: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3087: x_error_message := fnd_message.get;
3088:
3089: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');

Line 3154: ,'XNP_CORE.SMS_DELETE_PORTED_NUMBER');

3150: x_ERROR_CODE := SQLCODE;
3151: x_ERROR_MESSAGE := SQLERRM;
3152: fnd_message.set_name('XNP','STD_ERROR');
3153: fnd_message.set_token('ERROR_LOCN'
3154: ,'XNP_CORE.SMS_DELETE_PORTED_NUMBER');
3155: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3156: x_error_message := fnd_message.get;
3157:
3158: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');

Line 3247: ,'XNP_CORE.SMS_UPDATE_FE_MAP_STATUS');

3243: WHEN OTHERS THEN
3244: x_ERROR_CODE := SQLCODE;
3245: fnd_message.set_name('XNP','STD_ERROR');
3246: fnd_message.set_token('ERROR_LOCN'
3247: ,'XNP_CORE.SMS_UPDATE_FE_MAP_STATUS');
3248: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3249: x_error_message := fnd_message.get;
3250:
3251: fnd_message.set_name('XNP','UPD_FE_MAP_STATUS_ERR');

Line 3394: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_REC_PORT_ORDER');

3390: null;
3391: WHEN OTHERS THEN
3392: x_ERROR_CODE := SQLCODE;
3393: fnd_message.set_name('XNP','STD_ERROR');
3394: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_REC_PORT_ORDER');
3395: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3396: x_error_message := fnd_message.get;
3397:
3398: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');

Line 3539: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DON_PORT_ORDER');

3535: null;
3536: WHEN OTHERS THEN
3537: x_ERROR_CODE := SQLCODE;
3538: fnd_message.set_name('XNP','STD_ERROR');
3539: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DON_PORT_ORDER');
3540: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3541: x_error_message := fnd_message.get;
3542:
3543: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');

Line 3641: fnd_message.set_token('ERROR_LOCN' ,'XNP_CORE.SMS_MODIFY_PORTED_NUMBER');

3637: null;
3638: WHEN OTHERS THEN
3639: x_ERROR_CODE := SQLCODE;
3640: fnd_message.set_name('XNP','STD_ERROR');
3641: fnd_message.set_token('ERROR_LOCN' ,'XNP_CORE.SMS_MODIFY_PORTED_NUMBER');
3642: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3643: x_error_message := fnd_message.get;
3644:
3645: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');

Line 3693: ('FAILED_PROC','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');

3689: WHEN NO_DATA_FOUND THEN
3690: x_ERROR_CODE := SQLCODE;
3691: fnd_message.set_name('XNP','STD_GET_FAILED');
3692: fnd_message.set_token
3693: ('FAILED_PROC','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3694: fnd_message.set_token('ATTRNAME','PORTED_INDICATOR');
3695: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
3696: fnd_message.set_token
3697: ('VALUE'

Line 3716: ('ERROR_LOCN','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');

3712: WHEN OTHERS THEN
3713: x_ERROR_CODE := SQLCODE;
3714: fnd_message.set_name('XNP','STD_ERROR');
3715: fnd_message.set_token
3716: ('ERROR_LOCN','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3717: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3718: x_error_message := fnd_message.get;
3719: IF c_PORTED_INDICATOR%ISOPEN THEN
3720: CLOSE c_PORTED_INDICATOR;

Line 3803: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');

3799:
3800: WHEN OTHERS THEN
3801: x_ERROR_CODE := SQLCODE;
3802: fnd_message.set_name('XNP','STD_ERROR');
3803: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3804: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3805: x_error_message := fnd_message.get;
3806:
3807: END SOA_UPDATE_OLD_SP_DUE_DATE;

Line 3884: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE');

3880: fnd_message.set_token('PORTING_ID',p_porting_id);
3881: WHEN OTHERS THEN
3882: x_ERROR_CODE := SQLCODE;
3883: fnd_message.set_name('XNP','STD_ERROR');
3884: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE');
3885: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3886: x_error_message := fnd_message.get;
3887:
3888: END SOA_UPDATE_NEW_SP_DUE_DATE;

Line 3934: ,'XNP_CORE.CHECK_DONOR_STATUS_EXISTS');

3930: WHEN OTHERS THEN
3931: x_ERROR_CODE := SQLCODE;
3932: fnd_message.set_name('XNP','STD_ERROR');
3933: fnd_message.set_token('ERROR_LOCN'
3934: ,'XNP_CORE.CHECK_DONOR_STATUS_EXISTS');
3935: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3936: x_error_message := fnd_message.get;
3937: IF c_SOA_SV_ID%ISOPEN THEN
3938: CLOSE c_SOA_SV_ID;

Line 3988: ,'XNP_CORE.CHECK_RECIPIENT_STATUS_EXISTS');

3984: WHEN OTHERS THEN
3985: x_ERROR_CODE := SQLCODE;
3986: fnd_message.set_name('XNP','STD_ERROR');
3987: fnd_message.set_token('ERROR_LOCN'
3988: ,'XNP_CORE.CHECK_RECIPIENT_STATUS_EXISTS');
3989: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3990: x_error_message := fnd_message.get;
3991: IF c_SOA_SV_ID%ISOPEN THEN
3992: CLOSE c_SOA_SV_ID;

Line 4065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CUTOFF_DATE');

4061: null;
4062: WHEN OTHERS THEN
4063: x_ERROR_CODE := SQLCODE;
4064: fnd_message.set_name('XNP','STD_ERROR');
4065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
4066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4067: x_error_message := fnd_message.get;
4068:
4069: END SOA_UPDATE_CUTOFF_DATE;

Line 4151: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');

4147: null;
4148: WHEN OTHERS THEN
4149: x_ERROR_CODE := SQLCODE;
4150: fnd_message.set_name('XNP','STD_ERROR');
4151: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
4152: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4153: x_error_message := fnd_message.get;
4154:
4155: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');

Line 4202: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');

4198: WHEN OTHERS THEN
4199: x_ERROR_CODE := SQLCODE;
4200: fnd_message.set_name('XNP','STD_ERROR');
4201: fnd_message.set_token('ERROR_LOCN'
4202: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
4203: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4204: x_error_message := fnd_message.get;
4205: IF c_SOA_SV_ID%ISOPEN THEN
4206: CLOSE c_SOA_SV_ID;

Line 4277: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG');

4273: null;
4274: WHEN OTHERS THEN
4275: x_ERROR_CODE := SQLCODE;
4276: fnd_message.set_name('XNP','STD_ERROR');
4277: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG');
4278: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4279: x_error_message := fnd_message.get;
4280:
4281: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');

Line 4356: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG');

4352: null;
4353: WHEN OTHERS THEN
4354: x_ERROR_CODE := SQLCODE;
4355: fnd_message.set_name('XNP','STD_ERROR');
4356: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG');
4357: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4358: x_error_message := fnd_message.get;
4359:
4360: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');

Line 4393: XNP_CORE.GET_NUMBER_RANGE_ID

4389: x_error_code := 0;
4390:
4391: -- Determine the number range id
4392:
4393: XNP_CORE.GET_NUMBER_RANGE_ID
4394: (p_STARTING_NUMBER
4395: ,p_ENDING_NUMBER
4396: ,l_NUMBER_RANGE_ID
4397: ,x_ERROR_CODE

Line 4409: XNP_CORE.SMS_INSERT_FE_MAP

4405: -- get the fe list to provision
4406: FOR l_tmp_fe IN c_ALL_FEs LOOP
4407:
4408: -- Insert the FE MAP for the FE to be provisioned
4409: XNP_CORE.SMS_INSERT_FE_MAP
4410: (p_ORDER_ID,
4411: p_LINEITEM_ID,
4412: p_WORKITEM_INSTANCE_ID,
4413: p_FA_INSTANCE_ID,

Line 4435: ,'XNP_CORE.SMS_MARK_FES_TO_PROVISION');

4431: WHEN OTHERS THEN
4432: x_ERROR_CODE := SQLCODE;
4433: fnd_message.set_name('XNP','STD_ERROR');
4434: fnd_message.set_token('ERROR_LOCN'
4435: ,'XNP_CORE.SMS_MARK_FES_TO_PROVISION');
4436: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4437: x_error_message := fnd_message.get;
4438:
4439: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');

Line 4520: ,'XNP_CORE.SMS_MARK_FES_TO_DEPROVISION');

4516: WHEN OTHERS THEN
4517: x_ERROR_CODE := SQLCODE;
4518: fnd_message.set_name('XNP','STD_ERROR');
4519: fnd_message.set_token('ERROR_LOCN'
4520: ,'XNP_CORE.SMS_MARK_FES_TO_DEPROVISION');
4521: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4522: x_error_message := fnd_message.get;
4523:
4524: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');

Line 4595: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');

4591: null;
4592: WHEN NO_DATA_FOUND THEN
4593: x_error_code := SQLCODE;
4594: fnd_message.set_name('XNP','STD_ERROR');
4595: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4596: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4597: x_error_message := fnd_message.get;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 4608: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');

4604: WHEN OTHERS THEN
4605: x_error_code := SQLCODE;
4606:
4607: fnd_message.set_name('XNP','STD_ERROR');
4608: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4609: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4610: x_error_message := fnd_message.get;
4611:
4612:

Line 4650: ,'xnp_core.soa_get_locked_flag');

4646: WHEN NO_DATA_FOUND THEN
4647: x_error_code := SQLCODE;
4648: fnd_message.set_name('XNP','STD_ERROR');
4649: fnd_message.set_token('ERROR_LOCN'
4650: ,'xnp_core.soa_get_locked_flag');
4651: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4652: x_error_message := fnd_message.get;
4653:
4654: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 4667: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_locked_flag');

4663: WHEN OTHERS THEN
4664: x_error_code := SQLCODE;
4665:
4666: fnd_message.set_name('XNP','STD_ERROR');
4667: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_locked_flag');
4668: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4669: x_error_message := fnd_message.get;
4670:
4671: IF c_locked_flag%ISOPEN THEN

Line 4712: ,'xnp_core.soa_get_sv_status');

4708: x_error_code := SQLCODE;
4709: x_sv_status := NULL;
4710: fnd_message.set_name('XNP','STD_ERROR');
4711: fnd_message.set_token('ERROR_LOCN'
4712: ,'xnp_core.soa_get_sv_status');
4713: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4714: x_error_message := fnd_message.get;
4715:
4716: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 4730: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_sv_status');

4726: x_error_code := SQLCODE;
4727: x_sv_status := NULL;
4728:
4729: fnd_message.set_name('XNP','STD_ERROR');
4730: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_sv_status');
4731: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4732: x_error_message := fnd_message.get;
4733:
4734: IF c_sv_status%ISOPEN THEN

Line 4756: xnp_core.soa_get_sv_status

4752: BEGIN
4753:
4754: x_status_matched_flag := 'F'; -- default flag
4755:
4756: xnp_core.soa_get_sv_status
4757: (p_porting_id => p_porting_id
4758: ,p_local_sp_id => p_local_sp_id
4759: ,x_sv_status => l_sv_status
4760: ,x_error_code => x_error_code

Line 4840: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');

4836: null;
4837: WHEN NO_DATA_FOUND THEN
4838: x_error_code := SQLCODE;
4839: fnd_message.set_name('XNP','STD_ERROR');
4840: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4841: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4842: x_error_message := fnd_message.get;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 4853: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');

4849: WHEN OTHERS THEN
4850: x_error_code := SQLCODE;
4851:
4852: fnd_message.set_name('XNP','STD_ERROR');
4853: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4854: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4855: x_error_message := fnd_message.get;
4856:
4857: END SOA_SET_BLOCKED_FLAG;

Line 4893: ,'xnp_core.soa_get_blocked_flag');

4889: WHEN NO_DATA_FOUND THEN
4890: x_error_code := SQLCODE;
4891: fnd_message.set_name('XNP','STD_ERROR');
4892: fnd_message.set_token('ERROR_LOCN'
4893: ,'xnp_core.soa_get_blocked_flag');
4894: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4895: x_error_message := fnd_message.get;
4896:
4897: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 4910: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_blocked_flag');

4906: WHEN OTHERS THEN
4907: x_error_code := SQLCODE;
4908:
4909: fnd_message.set_name('XNP','STD_ERROR');
4910: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_blocked_flag');
4911: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4912: x_error_message := fnd_message.get;
4913:
4914: IF c_blocked_flag%ISOPEN THEN

Line 4955: ,'xnp_core.soa_get_new_sp_auth_flag');

4951: WHEN NO_DATA_FOUND THEN
4952: x_error_code := SQLCODE;
4953: fnd_message.set_name('XNP','STD_ERROR');
4954: fnd_message.set_token('ERROR_LOCN'
4955: ,'xnp_core.soa_get_new_sp_auth_flag');
4956: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4957: x_error_message := fnd_message.get;
4958:
4959: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 4972: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_new_sp_auth_flag');

4968: WHEN OTHERS THEN
4969: x_error_code := SQLCODE;
4970:
4971: fnd_message.set_name('XNP','STD_ERROR');
4972: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_new_sp_auth_flag');
4973: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4974: x_error_message := fnd_message.get;
4975:
4976: IF c_new_sp_auth_flag%ISOPEN THEN

Line 5016: ,'xnp_core.soa_get_old_sp_auth_flag');

5012: WHEN NO_DATA_FOUND THEN
5013: x_error_code := SQLCODE;
5014: fnd_message.set_name('XNP','STD_ERROR');
5015: fnd_message.set_token('ERROR_LOCN'
5016: ,'xnp_core.soa_get_old_sp_auth_flag');
5017: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5018: x_error_message := fnd_message.get;
5019:
5020: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 5033: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_old_sp_auth_flag');

5029: WHEN OTHERS THEN
5030: x_error_code := SQLCODE;
5031:
5032: fnd_message.set_name('XNP','STD_ERROR');
5033: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_old_sp_auth_flag');
5034: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5035: x_error_message := fnd_message.get;
5036:
5037: IF c_old_sp_auth_flag%ISOPEN THEN

Line 5120: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE');

5116:
5117: WHEN OTHERS THEN
5118: x_ERROR_CODE := SQLCODE;
5119: fnd_message.set_name('XNP','STD_ERROR');
5120: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE');
5121: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5122: x_error_message := fnd_message.get;
5123:
5124: END SOA_UPDATE_ACTIVATION_DUE_DATE;

Line 5169: XNP_CORE.GET_ASSIGNED_SP_ID

5165:
5166: -- If no entries in SV_SMS table
5167: -- The check if the local sp is the assigned sp
5168:
5169: XNP_CORE.GET_ASSIGNED_SP_ID
5170: (l_starting_number
5171: ,l_ending_number
5172: ,l_assigned_sp_id
5173: ,x_error_code

Line 5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');

5216: WHEN NO_DATA_FOUND THEN
5217: x_ERROR_CODE := SQLCODE;
5218:
5219: fnd_message.set_name('XNP','STD_GET_FAILED');
5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5221: fnd_message.set_token('ATTRNAME','SP_ID');
5222: fnd_message.set_token('KEY','SP_ID');
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5224: x_error_message := fnd_message.get;

Line 5239: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_IF_SP_ASSIGNED');

5235: WHEN OTHERS THEN
5236: x_ERROR_CODE := SQLCODE;
5237:
5238: fnd_message.set_name('XNP','STD_ERROR');
5239: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5240: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5241: x_error_message := fnd_message.get;
5242:
5243: IF c_rn_owner%ISOPEN THEN

Line 5318: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');

5314: null;
5315: WHEN NO_DATA_FOUND THEN
5316: x_error_code := SQLCODE;
5317: fnd_message.set_name('XNP','STD_ERROR');
5318: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5319: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5320: x_error_message := fnd_message.get;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 5331: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');

5327: WHEN OTHERS THEN
5328: x_error_code := SQLCODE;
5329:
5330: fnd_message.set_name('XNP','STD_ERROR');
5331: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5332: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5333: x_error_message := fnd_message.get ;
5334:
5335: END SOA_UPDATE_NOTES_INFO;

Line 5426: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');

5422: null;
5423: WHEN NO_DATA_FOUND THEN
5424: x_error_code := SQLCODE;
5425: fnd_message.set_name('XNP','STD_ERROR');
5426: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5427: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5428: x_error_message := fnd_message.get;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 5439: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');

5435: WHEN OTHERS THEN
5436: x_error_code := SQLCODE;
5437:
5438: fnd_message.set_name('XNP','STD_ERROR');
5439: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5440: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5441: x_error_message := fnd_message.get;
5442:
5443: END SOA_UPDATE_NETWORK_INFO;

Line 5542: ,'xnp_core.soa_update_customer_info');

5538: WHEN NO_DATA_FOUND THEN
5539: x_error_code := SQLCODE;
5540: fnd_message.set_name('XNP','STD_ERROR');
5541: fnd_message.set_token('ERROR_LOCN'
5542: ,'xnp_core.soa_update_customer_info');
5543: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5544: x_error_message := fnd_message.get;
5545:
5546: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 5555: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_customer_info');

5551: WHEN OTHERS THEN
5552: x_error_code := SQLCODE;
5553:
5554: fnd_message.set_name('XNP','STD_ERROR');
5555: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_customer_info');
5556: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5557: x_error_message := fnd_message.get;
5558:
5559: END SOA_UPDATE_CUSTOMER_INFO;

Line 5595: XNP_CORE.GET_PHASE_FOR_STATUS

5591: l_ending_number := p_ending_number;
5592:
5593: -- Get the phase corresponding to this 'p_CUR_STATUS_TYPE_CODE'
5594:
5595: XNP_CORE.GET_PHASE_FOR_STATUS
5596: (p_CUR_STATUS_TYPE_CODE
5597: ,l_PHASE_INDICATOR
5598: ,x_ERROR_CODE
5599: ,x_ERROR_MESSAGE

Line 5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');

5670: null;
5671: WHEN NO_DATA_FOUND THEN
5672: x_ERROR_CODE := SQLCODE;
5673: fnd_message.set_name('XNP','STD_GET_FAILED');
5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');
5675: fnd_message.set_token('ATTRNAME','PORTING_ID:ORDER_ID');
5676: fnd_message.set_token('KEY','ORDER_ID:PORTING_ID');
5677: fnd_message.set_token('VALUE',to_char(p_order_id)||':'||p_porting_id);
5678: x_error_message := fnd_message.get;

Line 5685: ,'XNP_CORE.SOA_UPDATE_PORTING_ID');

5681: WHEN OTHERS THEN
5682: x_ERROR_CODE := SQLCODE;
5683: fnd_message.set_name('XNP','STD_ERROR');
5684: fnd_message.set_token('ERROR_LOCN'
5685: ,'XNP_CORE.SOA_UPDATE_PORTING_ID');
5686: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5687: x_error_message := fnd_message.get;
5688:
5689: END SOA_UPDATE_PORTING_ID;

Line 5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');

5791: WHEN NO_DATA_FOUND THEN
5792: x_error_code := SQLCODE;
5793:
5794: fnd_message.set_name('XNP','STD_GET_FAILED');
5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5796: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
5797: fnd_message.set_token('KEY','ROUTING_NUMBER_ID');
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5799: x_error_message := fnd_message.get;

Line 5814: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_RN_FOR_RECIPIENT');

5810:
5811: WHEN OTHERS THEN
5812: x_error_code := SQLCODE;
5813: fnd_message.set_name('XNP','STD_ERROR');
5814: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5815: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5816: x_error_message := fnd_message.get;
5817:
5818: IF c_rn_for_recipient%ISOPEN THEN

Line 5931: fnd_message.set_token('ERROR_LOCN','XNP_CORE.RUNTIME_VALIDATION');

5927: WHEN OTHERS THEN
5928: x_error_code := SQLCODE;
5929:
5930: fnd_message.set_name('XNP','STD_ERROR');
5931: fnd_message.set_token('ERROR_LOCN','XNP_CORE.RUNTIME_VALIDATION');
5932: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5933: x_error_message := fnd_message.get;
5934:
5935:

Line 5985: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CREATE_ORDER_MAPPING');

5981: null;
5982: WHEN others THEN
5983: x_error_code := sqlcode;
5984: fnd_message.set_name('XNP','STD ERROR');
5985: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CREATE_ORDER_MAPPING');
5986: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5987: x_error_message := fnd_message.get;
5988:
5989: END CREATE_ORDER_MAPPING;

Line 6065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DISCONNECT_DUE_DATE');

6061: fnd_message.set_token('PORTING_ID',p_porting_id);
6062: WHEN OTHERS THEN
6063: x_ERROR_CODE := SQLCODE;
6064: fnd_message.set_name('XNP','STD_ERROR');
6065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DISCONNECT_DUE_DATE');
6066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6067: x_error_message := fnd_message.get;
6068:
6069: END SOA_UPDATE_DISCONN_DUE_DATE;

Line 6146: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE');

6142: fnd_message.set_token('PORTING_ID',p_porting_id);
6143: WHEN OTHERS THEN
6144: x_ERROR_CODE := SQLCODE;
6145: fnd_message.set_name('XNP','STD_ERROR');
6146: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE');
6147: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6148: x_error_message := fnd_message.get;
6149:
6150: END SOA_UPDATE_EFFECT_REL_DUE_DATE;

Line 6226: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_NUM_RETURN_DUE_DATE');

6222: fnd_message.set_token('PORTING_ID',p_porting_id);
6223: WHEN OTHERS THEN
6224: x_ERROR_CODE := SQLCODE;
6225: fnd_message.set_name('XNP','STD_ERROR');
6226: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_NUM_RETURN_DUE_DATE');
6227: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6228: x_error_message := fnd_message.get;
6229:
6230: END SOA_UPDATE_NUM_RETURN_DUE_DATE;

Line 6297: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');

6293: null;
6294: WHEN NO_DATA_FOUND THEN
6295: x_error_code := SQLCODE;
6296: fnd_message.set_name('XNP','STD_ERROR');
6297: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6298: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6299: x_error_message := fnd_message.get;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 6310: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');

6306: WHEN OTHERS THEN
6307: x_error_code := SQLCODE;
6308:
6309: fnd_message.set_name('XNP','STD_ERROR');
6310: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6312: x_error_message := fnd_message.get;
6313:
6314: END SOA_SET_CONCURRENCE_FLAG;

Line 6351: ,'xnp_core.soa_get_concurrence_flag');

6347: WHEN NO_DATA_FOUND THEN
6348: x_error_code := SQLCODE;
6349: fnd_message.set_name('XNP','STD_ERROR');
6350: fnd_message.set_token('ERROR_LOCN'
6351: ,'xnp_core.soa_get_concurrence_flag');
6352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6353: x_error_message := fnd_message.get;
6354:
6355: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');

Line 6368: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_concurrence_flag');

6364: WHEN OTHERS THEN
6365: x_error_code := SQLCODE;
6366:
6367: fnd_message.set_name('XNP','STD_ERROR');
6368: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_concurrence_flag');
6369: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6370: x_error_message := fnd_message.get;
6371:
6372: IF c_concurrence_flag%ISOPEN THEN

Line 6389: END XNP_CORE;

6385: val => g_default_porting_status);
6386:
6387: END;
6388:
6389: END XNP_CORE;