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.XDP_ORDER dependencies on FND_MESSAGE

Line 247: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_UNIQUE_MATCH');--Done

243: RAISE e_wi_no_config ;
244: END IF;
245: EXCEPTION
246: WHEN e_wi_no_unique_match THEN
247: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_UNIQUE_MATCH');--Done
248: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
249: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
250: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
251: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');

Line 248: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

244: END IF;
245: EXCEPTION
246: WHEN e_wi_no_unique_match THEN
247: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_UNIQUE_MATCH');--Done
248: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
249: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
250: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
251: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
252:

Line 249: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);

245: EXCEPTION
246: WHEN e_wi_no_unique_match THEN
247: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_UNIQUE_MATCH');--Done
248: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
249: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
250: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
251: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
252:
253: WHEN e_wi_no_config THEN

Line 250: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);

246: WHEN e_wi_no_unique_match THEN
247: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_UNIQUE_MATCH');--Done
248: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
249: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
250: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
251: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
252:
253: WHEN e_wi_no_config THEN
254: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_CONFIG'); -- Done

Line 254: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_CONFIG'); -- Done

250: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
251: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
252:
253: WHEN e_wi_no_config THEN
254: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_CONFIG'); -- Done
255: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
256: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
257: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
258: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');

Line 255: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

251: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
252:
253: WHEN e_wi_no_config THEN
254: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_CONFIG'); -- Done
255: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
256: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
257: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
258: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
259:

Line 256: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);

252:
253: WHEN e_wi_no_config THEN
254: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_CONFIG'); -- Done
255: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
256: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
257: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
258: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
259:
260: WHEN others THEN

Line 257: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);

253: WHEN e_wi_no_config THEN
254: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_NO_CONFIG'); -- Done
255: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
256: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', lv_wi_name);
257: FND_MESSAGE.SET_TOKEN('VERSION', lv_wi_version);
258: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.GET_WORKITEM_ID');
259:
260: WHEN others THEN
261: XDP_UTILITIES.GENERIC_ERROR('XDP_ORDER.GET_WORKITEM_ID'

Line 413: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION'); -- Created -191370

409: END IF;
410:
411: EXCEPTION
412: WHEN e_invalid_organization THEN
413: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION'); -- Created -191370
414: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
415: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
416:
417: WHEN e_invalid_organization_id THEN

Line 414: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

410:
411: EXCEPTION
412: WHEN e_invalid_organization THEN
413: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION'); -- Created -191370
414: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
415: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
416:
417: WHEN e_invalid_organization_id THEN
418: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_ID'); -- Created -191370

Line 418: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_ID'); -- Created -191370

414: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
415: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
416:
417: WHEN e_invalid_organization_id THEN
418: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_ID'); -- Created -191370
419: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
420: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
421: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
422:

Line 419: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

415: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
416:
417: WHEN e_invalid_organization_id THEN
418: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_ID'); -- Created -191370
419: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
420: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
421: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
422:
423: WHEN e_invalid_organization_code THEN

Line 420: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);

416:
417: WHEN e_invalid_organization_id THEN
418: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_ID'); -- Created -191370
419: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
420: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
421: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
422:
423: WHEN e_invalid_organization_code THEN
424: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_CODE'); -- Created -191370

Line 424: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_CODE'); -- Created -191370

420: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
421: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
422:
423: WHEN e_invalid_organization_code THEN
424: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_CODE'); -- Created -191370
425: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_organization_code);
427: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
428:

Line 425: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

421: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
422:
423: WHEN e_invalid_organization_code THEN
424: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_CODE'); -- Created -191370
425: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_organization_code);
427: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
428:
429: WHEN others THEN

Line 426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_organization_code);

422:
423: WHEN e_invalid_organization_code THEN
424: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ORGANIZATION_CODE'); -- Created -191370
425: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_organization_code);
427: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORGANIZATION');
428:
429: WHEN others THEN
430: XDP_UTILITIES.GENERIC_ERROR('XDP_ORDER.VALIDATE_ORGANIZATION'

Line 557: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ACTION_PACKAGE');--Done 191271

553: END IF;
554:
555: EXCEPTION
556: WHEN e_invalid_action_package THEN
557: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ACTION_PACKAGE');--Done 191271
558: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
560: FND_MESSAGE.SET_TOKEN('SERVICE_NAME', l_item_number);
561: FND_MESSAGE.SET_TOKEN('ACTION', p_action);

Line 558: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

554:
555: EXCEPTION
556: WHEN e_invalid_action_package THEN
557: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ACTION_PACKAGE');--Done 191271
558: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
560: FND_MESSAGE.SET_TOKEN('SERVICE_NAME', l_item_number);
561: FND_MESSAGE.SET_TOKEN('ACTION', p_action);
562: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IS_PACKAGE_ACTION_VALID');

Line 559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);

555: EXCEPTION
556: WHEN e_invalid_action_package THEN
557: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ACTION_PACKAGE');--Done 191271
558: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
560: FND_MESSAGE.SET_TOKEN('SERVICE_NAME', l_item_number);
561: FND_MESSAGE.SET_TOKEN('ACTION', p_action);
562: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IS_PACKAGE_ACTION_VALID');
563:

Line 560: FND_MESSAGE.SET_TOKEN('SERVICE_NAME', l_item_number);

556: WHEN e_invalid_action_package THEN
557: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ACTION_PACKAGE');--Done 191271
558: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
560: FND_MESSAGE.SET_TOKEN('SERVICE_NAME', l_item_number);
561: FND_MESSAGE.SET_TOKEN('ACTION', p_action);
562: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IS_PACKAGE_ACTION_VALID');
563:
564: WHEN others THEN

Line 561: FND_MESSAGE.SET_TOKEN('ACTION', p_action);

557: FND_MESSAGE.SET_NAME('XDP', 'XDP_INVALID_ACTION_PACKAGE');--Done 191271
558: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
559: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
560: FND_MESSAGE.SET_TOKEN('SERVICE_NAME', l_item_number);
561: FND_MESSAGE.SET_TOKEN('ACTION', p_action);
562: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IS_PACKAGE_ACTION_VALID');
563:
564: WHEN others THEN
565: XDP_UTILITIES.GENERIC_ERROR('XDP_ORDER.IS_PACKAGE_ACTION_VALID'

Line 997: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDERNUM_NOT_NULL'); -- Done 191251

993: END IF;
994:
995: EXCEPTION
996: WHEN e_order_number_null THEN
997: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDERNUM_NOT_NULL'); -- Done 191251
998: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
999:
1000: WHEN e_execution_mode_invalid THEN
1001: FND_MESSAGE.SET_NAME('XDP','XDP_ORD_EXECUTION_MODE_INVALID');

Line 1001: FND_MESSAGE.SET_NAME('XDP','XDP_ORD_EXECUTION_MODE_INVALID');

997: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDERNUM_NOT_NULL'); -- Done 191251
998: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
999:
1000: WHEN e_execution_mode_invalid THEN
1001: FND_MESSAGE.SET_NAME('XDP','XDP_ORD_EXECUTION_MODE_INVALID');
1002: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1003: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1004:
1005: WHEN e_order_line_list_null THEN

Line 1002: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);

998: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
999:
1000: WHEN e_execution_mode_invalid THEN
1001: FND_MESSAGE.SET_NAME('XDP','XDP_ORD_EXECUTION_MODE_INVALID');
1002: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1003: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1004:
1005: WHEN e_order_line_list_null THEN
1006: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOTNULL'); -- Done 191253

Line 1006: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOTNULL'); -- Done 191253

1002: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1003: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1004:
1005: WHEN e_order_line_list_null THEN
1006: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOTNULL'); -- Done 191253
1007: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1008: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER');
1009:
1010: WHEN e_order_line_list_count THEN

Line 1007: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);

1003: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1004:
1005: WHEN e_order_line_list_null THEN
1006: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOTNULL'); -- Done 191253
1007: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1008: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER');
1009:
1010: WHEN e_order_line_list_count THEN
1011: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOT_EMPTY'); -- Done 191254

Line 1011: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOT_EMPTY'); -- Done 191254

1007: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1008: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER');
1009:
1010: WHEN e_order_line_list_count THEN
1011: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOT_EMPTY'); -- Done 191254
1012: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1013: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1014:
1015: WHEN e_line_parameter_list_null THEN

Line 1012: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);

1008: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER');
1009:
1010: WHEN e_order_line_list_count THEN
1011: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDLINELIST_NOT_EMPTY'); -- Done 191254
1012: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1013: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1014:
1015: WHEN e_line_parameter_list_null THEN
1016: FND_MESSAGE.SET_NAME('XDP', 'XDP_PARAMLIST_NOTNULL'); -- Done -191255

Line 1016: FND_MESSAGE.SET_NAME('XDP', 'XDP_PARAMLIST_NOTNULL'); -- Done -191255

1012: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1013: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1014:
1015: WHEN e_line_parameter_list_null THEN
1016: FND_MESSAGE.SET_NAME('XDP', 'XDP_PARAMLIST_NOTNULL'); -- Done -191255
1017: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1018: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1019:
1020: WHEN e_cust_acc_id_invalid THEN

Line 1017: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);

1013: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1014:
1015: WHEN e_line_parameter_list_null THEN
1016: FND_MESSAGE.SET_NAME('XDP', 'XDP_PARAMLIST_NOTNULL'); -- Done -191255
1017: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1018: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1019:
1020: WHEN e_cust_acc_id_invalid THEN
1021: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACCOUNTID_INVALID'); --Done -191371

Line 1021: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACCOUNTID_INVALID'); --Done -191371

1017: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1018: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1019:
1020: WHEN e_cust_acc_id_invalid THEN
1021: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACCOUNTID_INVALID'); --Done -191371
1022: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1023: FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_order_header.cust_account_id);
1024: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1025:

Line 1022: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);

1018: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1019:
1020: WHEN e_cust_acc_id_invalid THEN
1021: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACCOUNTID_INVALID'); --Done -191371
1022: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1023: FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_order_header.cust_account_id);
1024: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1025:
1026: WHEN e_cust_acc_num_invalid THEN

Line 1023: FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_order_header.cust_account_id);

1019:
1020: WHEN e_cust_acc_id_invalid THEN
1021: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACCOUNTID_INVALID'); --Done -191371
1022: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1023: FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_order_header.cust_account_id);
1024: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1025:
1026: WHEN e_cust_acc_num_invalid THEN
1027: FND_MESSAGE.SET_NAME('XDP','XDP_ACCOUNTNUM_INVALID');-- Done -191372

Line 1027: FND_MESSAGE.SET_NAME('XDP','XDP_ACCOUNTNUM_INVALID');-- Done -191372

1023: FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_order_header.cust_account_id);
1024: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1025:
1026: WHEN e_cust_acc_num_invalid THEN
1027: FND_MESSAGE.SET_NAME('XDP','XDP_ACCOUNTNUM_INVALID');-- Done -191372
1028: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1029: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER',p_order_header.account_number);
1030: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1031:

Line 1028: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);

1024: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1025:
1026: WHEN e_cust_acc_num_invalid THEN
1027: FND_MESSAGE.SET_NAME('XDP','XDP_ACCOUNTNUM_INVALID');-- Done -191372
1028: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1029: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER',p_order_header.account_number);
1030: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1031:
1032: WHEN e_due_date_null THEN

Line 1029: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER',p_order_header.account_number);

1025:
1026: WHEN e_cust_acc_num_invalid THEN
1027: FND_MESSAGE.SET_NAME('XDP','XDP_ACCOUNTNUM_INVALID');-- Done -191372
1028: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1029: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER',p_order_header.account_number);
1030: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1031:
1032: WHEN e_due_date_null THEN
1033: FND_MESSAGE.SET_NAME('XDP', 'XDP_DUE_DATE_NULL');

Line 1033: FND_MESSAGE.SET_NAME('XDP', 'XDP_DUE_DATE_NULL');

1029: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER',p_order_header.account_number);
1030: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1031:
1032: WHEN e_due_date_null THEN
1033: FND_MESSAGE.SET_NAME('XDP', 'XDP_DUE_DATE_NULL');
1034: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1035: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1036:
1037: WHEN e_order_type_not_reg THEN

Line 1034: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);

1030: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1031:
1032: WHEN e_due_date_null THEN
1033: FND_MESSAGE.SET_NAME('XDP', 'XDP_DUE_DATE_NULL');
1034: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1035: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1036:
1037: WHEN e_order_type_not_reg THEN
1038: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');

Line 1038: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');

1034: FND_MESSAGE.SET_TOKEN('ORDNUM',G_external_order_reference);
1035: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1036:
1037: WHEN e_order_type_not_reg THEN
1038: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');
1039: FND_MESSAGE.SET_TOKEN('ORDNUM', G_external_order_reference);
1040: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1041:
1042: WHEN OTHERS THEN

Line 1039: FND_MESSAGE.SET_TOKEN('ORDNUM', G_external_order_reference);

1035: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1036:
1037: WHEN e_order_type_not_reg THEN
1038: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_TYPE_NOT_AVAILABLE');
1039: FND_MESSAGE.SET_TOKEN('ORDNUM', G_external_order_reference);
1040: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_HEADER');
1041:
1042: WHEN OTHERS THEN
1043: XDP_UTILITIES.generic_error('XDP_ORDER.VALIDATE_ORDER_HEADER'

Line 1470: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINENUM_NOTNULL'); --Done -191257

1466: END LOOP ;
1467:
1468: EXCEPTION
1469: WHEN e_line_number_null THEN
1470: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINENUM_NOTNULL'); --Done -191257
1471: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1472: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1473:
1474: WHEN e_lineitem_name_null THEN

Line 1471: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1467:
1468: EXCEPTION
1469: WHEN e_line_number_null THEN
1470: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINENUM_NOTNULL'); --Done -191257
1471: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1472: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1473:
1474: WHEN e_lineitem_name_null THEN
1475: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINEITEM_NAME_NOTNULL'); --Done 191258

Line 1475: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINEITEM_NAME_NOTNULL'); --Done 191258

1471: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1472: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1473:
1474: WHEN e_lineitem_name_null THEN
1475: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINEITEM_NAME_NOTNULL'); --Done 191258
1476: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1477: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1478:
1479: WHEN e_act_invalid_service_li THEN

Line 1476: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1472: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1473:
1474: WHEN e_lineitem_name_null THEN
1475: FND_MESSAGE.SET_NAME('XDP', 'XDP_LINEITEM_NAME_NOTNULL'); --Done 191258
1476: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1477: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1478:
1479: WHEN e_act_invalid_service_li THEN
1480: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACTION_INVALID_SERVICE_LI'); -- Done

Line 1480: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACTION_INVALID_SERVICE_LI'); -- Done

1476: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1477: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1478:
1479: WHEN e_act_invalid_service_li THEN
1480: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACTION_INVALID_SERVICE_LI'); -- Done
1481: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1482: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1483: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1484: FND_MESSAGE.SET_TOKEN('ACTION', l_action_code);

Line 1481: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1477: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1478:
1479: WHEN e_act_invalid_service_li THEN
1480: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACTION_INVALID_SERVICE_LI'); -- Done
1481: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1482: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1483: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1484: FND_MESSAGE.SET_TOKEN('ACTION', l_action_code);
1485: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');

Line 1482: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1478:
1479: WHEN e_act_invalid_service_li THEN
1480: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACTION_INVALID_SERVICE_LI'); -- Done
1481: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1482: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1483: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1484: FND_MESSAGE.SET_TOKEN('ACTION', l_action_code);
1485: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1486:

Line 1483: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);

1479: WHEN e_act_invalid_service_li THEN
1480: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACTION_INVALID_SERVICE_LI'); -- Done
1481: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1482: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1483: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1484: FND_MESSAGE.SET_TOKEN('ACTION', l_action_code);
1485: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1486:
1487: WHEN e_unknown_package_name THEN

Line 1484: FND_MESSAGE.SET_TOKEN('ACTION', l_action_code);

1480: FND_MESSAGE.SET_NAME('XDP', 'XDP_ACTION_INVALID_SERVICE_LI'); -- Done
1481: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1482: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1483: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1484: FND_MESSAGE.SET_TOKEN('ACTION', l_action_code);
1485: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1486:
1487: WHEN e_unknown_package_name THEN
1488: FND_MESSAGE.SET_NAME('XDP', 'XDP_UNKNOWN_PACKAGE_NAME'); --Done -191387

Line 1488: FND_MESSAGE.SET_NAME('XDP', 'XDP_UNKNOWN_PACKAGE_NAME'); --Done -191387

1484: FND_MESSAGE.SET_TOKEN('ACTION', l_action_code);
1485: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1486:
1487: WHEN e_unknown_package_name THEN
1488: FND_MESSAGE.SET_NAME('XDP', 'XDP_UNKNOWN_PACKAGE_NAME'); --Done -191387
1489: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1490: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1491: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1492: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');

Line 1489: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1485: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1486:
1487: WHEN e_unknown_package_name THEN
1488: FND_MESSAGE.SET_NAME('XDP', 'XDP_UNKNOWN_PACKAGE_NAME'); --Done -191387
1489: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1490: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1491: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1492: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1493:

Line 1490: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1486:
1487: WHEN e_unknown_package_name THEN
1488: FND_MESSAGE.SET_NAME('XDP', 'XDP_UNKNOWN_PACKAGE_NAME'); --Done -191387
1489: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1490: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1491: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1492: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1493:
1494: WHEN e_pkg_no_unique_match THEN

Line 1491: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);

1487: WHEN e_unknown_package_name THEN
1488: FND_MESSAGE.SET_NAME('XDP', 'XDP_UNKNOWN_PACKAGE_NAME'); --Done -191387
1489: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1490: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1491: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1492: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1493:
1494: WHEN e_pkg_no_unique_match THEN
1495: FND_MESSAGE.SET_NAME('XDP', 'XDP_PKG_NO_UNIQUE_MATCH');--Done 191264

Line 1495: FND_MESSAGE.SET_NAME('XDP', 'XDP_PKG_NO_UNIQUE_MATCH');--Done 191264

1491: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1492: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1493:
1494: WHEN e_pkg_no_unique_match THEN
1495: FND_MESSAGE.SET_NAME('XDP', 'XDP_PKG_NO_UNIQUE_MATCH');--Done 191264
1496: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1498: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1499: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');

Line 1496: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1492: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1493:
1494: WHEN e_pkg_no_unique_match THEN
1495: FND_MESSAGE.SET_NAME('XDP', 'XDP_PKG_NO_UNIQUE_MATCH');--Done 191264
1496: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1498: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1499: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1500:

Line 1497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1493:
1494: WHEN e_pkg_no_unique_match THEN
1495: FND_MESSAGE.SET_NAME('XDP', 'XDP_PKG_NO_UNIQUE_MATCH');--Done 191264
1496: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1498: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1499: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1500:
1501: WHEN e_svc_no_unique_match THEN

Line 1498: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);

1494: WHEN e_pkg_no_unique_match THEN
1495: FND_MESSAGE.SET_NAME('XDP', 'XDP_PKG_NO_UNIQUE_MATCH');--Done 191264
1496: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1498: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1499: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1500:
1501: WHEN e_svc_no_unique_match THEN
1502: FND_MESSAGE.SET_NAME('XDP', 'XDP_SVC_NO_UNIQUE_MATCH');--Done 191265

Line 1502: FND_MESSAGE.SET_NAME('XDP', 'XDP_SVC_NO_UNIQUE_MATCH');--Done 191265

1498: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1499: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1500:
1501: WHEN e_svc_no_unique_match THEN
1502: FND_MESSAGE.SET_NAME('XDP', 'XDP_SVC_NO_UNIQUE_MATCH');--Done 191265
1503: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1504: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1505: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1506: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');

Line 1503: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1499: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1500:
1501: WHEN e_svc_no_unique_match THEN
1502: FND_MESSAGE.SET_NAME('XDP', 'XDP_SVC_NO_UNIQUE_MATCH');--Done 191265
1503: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1504: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1505: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1506: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1507:

Line 1504: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1500:
1501: WHEN e_svc_no_unique_match THEN
1502: FND_MESSAGE.SET_NAME('XDP', 'XDP_SVC_NO_UNIQUE_MATCH');--Done 191265
1503: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1504: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1505: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1506: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1507:
1508: WHEN e_ibsource_null THEN

Line 1505: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);

1501: WHEN e_svc_no_unique_match THEN
1502: FND_MESSAGE.SET_NAME('XDP', 'XDP_SVC_NO_UNIQUE_MATCH');--Done 191265
1503: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1504: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1505: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1506: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1507:
1508: WHEN e_ibsource_null THEN
1509: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_NOTNULL'); --Done 191373

Line 1509: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_NOTNULL'); --Done 191373

1505: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME', l_service_item_name);
1506: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1507:
1508: WHEN e_ibsource_null THEN
1509: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_NOTNULL'); --Done 191373
1510: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1511: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1512: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1513:

Line 1510: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1506: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1507:
1508: WHEN e_ibsource_null THEN
1509: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_NOTNULL'); --Done 191373
1510: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1511: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1512: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1513:
1514: WHEN e_ibsource_invalid THEN

Line 1511: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1507:
1508: WHEN e_ibsource_null THEN
1509: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_NOTNULL'); --Done 191373
1510: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1511: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1512: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1513:
1514: WHEN e_ibsource_invalid THEN
1515: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_INVALID');--Done 191374

Line 1515: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_INVALID');--Done 191374

1511: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1512: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1513:
1514: WHEN e_ibsource_invalid THEN
1515: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_INVALID');--Done 191374
1516: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1517: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1518: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1519:

Line 1516: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1512: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1513:
1514: WHEN e_ibsource_invalid THEN
1515: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_INVALID');--Done 191374
1516: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1517: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1518: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1519:
1520: WHEN e_ordsource_notnull THEN

Line 1517: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1513:
1514: WHEN e_ibsource_invalid THEN
1515: FND_MESSAGE.SET_NAME('XDP', 'XDP_IBSOURCE_INVALID');--Done 191374
1516: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1517: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1518: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1519:
1520: WHEN e_ordsource_notnull THEN
1521: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDSOURCE_NOTNULL');--Done 191375

Line 1521: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDSOURCE_NOTNULL');--Done 191375

1517: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1518: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1519:
1520: WHEN e_ordsource_notnull THEN
1521: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDSOURCE_NOTNULL');--Done 191375
1522: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1523: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1524: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1525:

Line 1522: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1518: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1519:
1520: WHEN e_ordsource_notnull THEN
1521: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDSOURCE_NOTNULL');--Done 191375
1522: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1523: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1524: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1525:
1526: WHEN e_site_use_id_invalid THEN

Line 1523: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1519:
1520: WHEN e_ordsource_notnull THEN
1521: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDSOURCE_NOTNULL');--Done 191375
1522: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1523: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1524: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1525:
1526: WHEN e_site_use_id_invalid THEN
1527: FND_MESSAGE.SET_NAME('XDP','XDP_SITE_USE_ID_INVALID');--Done 191376

Line 1527: FND_MESSAGE.SET_NAME('XDP','XDP_SITE_USE_ID_INVALID');--Done 191376

1523: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1524: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1525:
1526: WHEN e_site_use_id_invalid THEN
1527: FND_MESSAGE.SET_NAME('XDP','XDP_SITE_USE_ID_INVALID');--Done 191376
1528: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1529: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1530: FND_MESSAGE.SET_TOKEN('SITE_USE_ID',l_site_use_id);
1531: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_LINES');

Line 1528: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1524: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_ORDER_LINE');
1525:
1526: WHEN e_site_use_id_invalid THEN
1527: FND_MESSAGE.SET_NAME('XDP','XDP_SITE_USE_ID_INVALID');--Done 191376
1528: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1529: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1530: FND_MESSAGE.SET_TOKEN('SITE_USE_ID',l_site_use_id);
1531: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_LINES');
1532:

Line 1529: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

1525:
1526: WHEN e_site_use_id_invalid THEN
1527: FND_MESSAGE.SET_NAME('XDP','XDP_SITE_USE_ID_INVALID');--Done 191376
1528: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1529: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1530: FND_MESSAGE.SET_TOKEN('SITE_USE_ID',l_site_use_id);
1531: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_LINES');
1532:
1533: WHEN OTHERS THEN

Line 1530: FND_MESSAGE.SET_TOKEN('SITE_USE_ID',l_site_use_id);

1526: WHEN e_site_use_id_invalid THEN
1527: FND_MESSAGE.SET_NAME('XDP','XDP_SITE_USE_ID_INVALID');--Done 191376
1528: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1529: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
1530: FND_MESSAGE.SET_TOKEN('SITE_USE_ID',l_site_use_id);
1531: XDP_UTILITIES.raise_exception('XDP_ORDER.VALIDATE_ORDER_LINES');
1532:
1533: WHEN OTHERS THEN
1534: XDP_UTILITIES.GENERIC_ERROR('XDP_PROCESS_ORDER.VALIDATE_ORDER_LINE'

Line 1633: FND_MESSAGE.SET_NAME('XDP','XDP_UNKNOWN_SERVICE_NAME');--191263

1629: END ;
1630: END IF;
1631: EXCEPTION
1632: WHEN e_unknown_service_name THEN
1633: FND_MESSAGE.SET_NAME('XDP','XDP_UNKNOWN_SERVICE_NAME');--191263
1634: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1635: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1636:
1637: --Fixed Bug # 2110849 - mviswana 11/19/2001

Line 1634: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1630: END IF;
1631: EXCEPTION
1632: WHEN e_unknown_service_name THEN
1633: FND_MESSAGE.SET_NAME('XDP','XDP_UNKNOWN_SERVICE_NAME');--191263
1634: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1635: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1636:
1637: --Fixed Bug # 2110849 - mviswana 11/19/2001
1638: WHEN e_invalid_service_item_name THEN

Line 1639: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_SERVICE_ITEM_NAME');--191388

1635: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1636:
1637: --Fixed Bug # 2110849 - mviswana 11/19/2001
1638: WHEN e_invalid_service_item_name THEN
1639: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_SERVICE_ITEM_NAME');--191388
1640: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1641: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME',p_item_number);
1642: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
1643: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');

Line 1640: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1636:
1637: --Fixed Bug # 2110849 - mviswana 11/19/2001
1638: WHEN e_invalid_service_item_name THEN
1639: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_SERVICE_ITEM_NAME');--191388
1640: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1641: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME',p_item_number);
1642: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
1643: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1644:

Line 1641: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME',p_item_number);

1637: --Fixed Bug # 2110849 - mviswana 11/19/2001
1638: WHEN e_invalid_service_item_name THEN
1639: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_SERVICE_ITEM_NAME');--191388
1640: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1641: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME',p_item_number);
1642: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
1643: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1644:
1645: WHEN e_invalid_inventory_item_id THEN

Line 1642: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);

1638: WHEN e_invalid_service_item_name THEN
1639: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_SERVICE_ITEM_NAME');--191388
1640: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1641: FND_MESSAGE.SET_TOKEN('SERVICE_ITEM_NAME',p_item_number);
1642: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
1643: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1644:
1645: WHEN e_invalid_inventory_item_id THEN
1646: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_INVENTORY_ITEM_ID');--191389

Line 1646: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_INVENTORY_ITEM_ID');--191389

1642: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_organization_id);
1643: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1644:
1645: WHEN e_invalid_inventory_item_id THEN
1646: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_INVENTORY_ITEM_ID');--191389
1647: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id );
1648: FND_MESSAGE.SET_TOKEN('ORGANIZATION',p_organization_id);
1649: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1650: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');

Line 1647: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id );

1643: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1644:
1645: WHEN e_invalid_inventory_item_id THEN
1646: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_INVENTORY_ITEM_ID');--191389
1647: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id );
1648: FND_MESSAGE.SET_TOKEN('ORGANIZATION',p_organization_id);
1649: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1650: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1651:

Line 1648: FND_MESSAGE.SET_TOKEN('ORGANIZATION',p_organization_id);

1644:
1645: WHEN e_invalid_inventory_item_id THEN
1646: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_INVENTORY_ITEM_ID');--191389
1647: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id );
1648: FND_MESSAGE.SET_TOKEN('ORGANIZATION',p_organization_id);
1649: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1650: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1651:
1652: WHEN others THEN

Line 1649: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

1645: WHEN e_invalid_inventory_item_id THEN
1646: FND_MESSAGE.SET_NAME('XDP','XDP_INVALID_INVENTORY_ITEM_ID');--191389
1647: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id );
1648: FND_MESSAGE.SET_TOKEN('ORGANIZATION',p_organization_id);
1649: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
1650: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.VALIDATE_LINE_ITEM');
1651:
1652: WHEN others THEN
1653: XDP_UTILITIES.GENERIC_ERROR('XDP_ORDER.VALIDATE_LINE_ITEM'

Line 2120: FND_MESSAGE.SET_NAME('XDP','XDP_ORDERNUM_EXISTS'); --191252

2116: lv_name_tab.DELETE;
2117: lv_val_tab.DELETE;
2118: EXCEPTION
2119: WHEN e_order_num_duplicate THEN
2120: FND_MESSAGE.SET_NAME('XDP','XDP_ORDERNUM_EXISTS'); --191252
2121: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
2122: XDP_UTILITIES.raise_exception('XDP_ORDER.POPULATE_ORDER_HEADER');
2123:
2124: WHEN OTHERS THEN

Line 2121: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

2117: lv_val_tab.DELETE;
2118: EXCEPTION
2119: WHEN e_order_num_duplicate THEN
2120: FND_MESSAGE.SET_NAME('XDP','XDP_ORDERNUM_EXISTS'); --191252
2121: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
2122: XDP_UTILITIES.raise_exception('XDP_ORDER.POPULATE_ORDER_HEADER');
2123:
2124: WHEN OTHERS THEN
2125: XDP_UTILITIES.generic_error('XDP_ORDER.POPULATE_ORDER_HEADER'

Line 2259: FND_MESSAGE.SET_NAME('XDP','XDP_ORDLIST_NO_LINENUM');

2255: END IF;
2256: END IF;
2257: EXCEPTION
2258: WHEN e_xdp_ordlist_no_linenum THEN
2259: FND_MESSAGE.SET_NAME('XDP','XDP_ORDLIST_NO_LINENUM');
2260: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
2261: FND_MESSAGE.SET_TOKEN('PARAM_NAME',l_parameter_name);
2262: XDP_UTILITIES.raise_exception('XDP_ORDER.POPULATE_ORDER_LINES');
2263:

Line 2260: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);

2256: END IF;
2257: EXCEPTION
2258: WHEN e_xdp_ordlist_no_linenum THEN
2259: FND_MESSAGE.SET_NAME('XDP','XDP_ORDLIST_NO_LINENUM');
2260: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
2261: FND_MESSAGE.SET_TOKEN('PARAM_NAME',l_parameter_name);
2262: XDP_UTILITIES.raise_exception('XDP_ORDER.POPULATE_ORDER_LINES');
2263:
2264: WHEN others THEN

Line 2261: FND_MESSAGE.SET_TOKEN('PARAM_NAME',l_parameter_name);

2257: EXCEPTION
2258: WHEN e_xdp_ordlist_no_linenum THEN
2259: FND_MESSAGE.SET_NAME('XDP','XDP_ORDLIST_NO_LINENUM');
2260: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
2261: FND_MESSAGE.SET_TOKEN('PARAM_NAME',l_parameter_name);
2262: XDP_UTILITIES.raise_exception('XDP_ORDER.POPULATE_ORDER_LINES');
2263:
2264: WHEN others THEN
2265:

Line 3297: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_NOTEMPTY');-- Done 191377

3293:
3294: EXCEPTION
3295:
3296: WHEN e_txn_det_zero_count THEN
3297: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_NOTEMPTY');-- Done 191377
3298: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3299: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3300: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3301: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');

Line 3298: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

3294: EXCEPTION
3295:
3296: WHEN e_txn_det_zero_count THEN
3297: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_NOTEMPTY');-- Done 191377
3298: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3299: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3300: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3301: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3302:

Line 3299: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);

3295:
3296: WHEN e_txn_det_zero_count THEN
3297: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_NOTEMPTY');-- Done 191377
3298: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3299: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3300: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3301: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3302:
3303: WHEN e_txn_det_error_status THEN

Line 3300: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);

3296: WHEN e_txn_det_zero_count THEN
3297: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_NOTEMPTY');-- Done 191377
3298: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3299: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3300: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3301: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3302:
3303: WHEN e_txn_det_error_status THEN
3304: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_ERROR_STATUS'); --Done 191380

Line 3304: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_ERROR_STATUS'); --Done 191380

3300: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3301: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3302:
3303: WHEN e_txn_det_error_status THEN
3304: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_ERROR_STATUS'); --Done 191380
3305: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3306: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3307: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3308: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');

Line 3305: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

3301: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3302:
3303: WHEN e_txn_det_error_status THEN
3304: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_ERROR_STATUS'); --Done 191380
3305: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3306: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3307: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3308: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3309:

Line 3306: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);

3302:
3303: WHEN e_txn_det_error_status THEN
3304: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_ERROR_STATUS'); --Done 191380
3305: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3306: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3307: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3308: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3309:
3310: WHEN OTHERS THEN

Line 3307: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);

3303: WHEN e_txn_det_error_status THEN
3304: FND_MESSAGE.SET_NAME('XDP', 'XDP_TXNDET_ERROR_STATUS'); --Done 191380
3305: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3306: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_order_line.line_number);
3307: FND_MESSAGE.SET_TOKEN('LINE_SOURCE',p_service_order_line.line_source);
3308: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.EXPLODE_TXN_IB');
3309:
3310: WHEN OTHERS THEN
3311: xdp_utilities.generic_error('XDP_ORDER.EXPLODE_TXN_IB'

Line 3728: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ATTRIBVAL_NOTEMPTY');--Done 191381

3724:
3725: EXCEPTION
3726:
3727: WHEN e_csi_zero_count THEN
3728: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ATTRIBVAL_NOTEMPTY');--Done 191381
3729: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3730: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_line.line_number);
3731: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3732: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');

Line 3729: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

3725: EXCEPTION
3726:
3727: WHEN e_csi_zero_count THEN
3728: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ATTRIBVAL_NOTEMPTY');--Done 191381
3729: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3730: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_line.line_number);
3731: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3732: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3733:

Line 3730: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_line.line_number);

3726:
3727: WHEN e_csi_zero_count THEN
3728: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ATTRIBVAL_NOTEMPTY');--Done 191381
3729: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3730: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_line.line_number);
3731: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3732: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3733:
3734: WHEN e_csi_error_status THEN

Line 3731: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);

3727: WHEN e_csi_zero_count THEN
3728: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ATTRIBVAL_NOTEMPTY');--Done 191381
3729: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3730: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_service_line.line_number);
3731: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3732: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3733:
3734: WHEN e_csi_error_status THEN
3735: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ERROR_STATUS'); --done 191382

Line 3735: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ERROR_STATUS'); --done 191382

3731: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3732: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3733:
3734: WHEN e_csi_error_status THEN
3735: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ERROR_STATUS'); --done 191382
3736: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3737: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_service_line.line_number);
3738: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3739: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');

Line 3736: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

3732: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3733:
3734: WHEN e_csi_error_status THEN
3735: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ERROR_STATUS'); --done 191382
3736: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3737: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_service_line.line_number);
3738: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3739: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3740:

Line 3737: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_service_line.line_number);

3733:
3734: WHEN e_csi_error_status THEN
3735: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ERROR_STATUS'); --done 191382
3736: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3737: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_service_line.line_number);
3738: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3739: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3740:
3741: WHEN OTHERS THEN

Line 3738: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);

3734: WHEN e_csi_error_status THEN
3735: FND_MESSAGE.SET_NAME('XDP', 'XDP_CSI_ERROR_STATUS'); --done 191382
3736: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
3737: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_service_line.line_number);
3738: FND_MESSAGE.SET_TOKEN('IB_SOURCE_ID', p_service_line.ib_source_id);
3739: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.IB_CSI_LINE');
3740:
3741: WHEN OTHERS THEN
3742:

Line 4666: -- Change: The FND message thrown by this exception has been replaced with a new message

4662: EXCEPTION
4663:
4664: WHEN e_fulfill_worklist_error THEN
4665: -- Date: 20 Jan 2005 Author: DPUTHIYE Bug#: 4083708
4666: -- Change: The FND message thrown by this exception has been replaced with a new message
4667: -- The new message also contains the error text (ERROR_TEXT) returned by the WI mapping proc.
4668: -- Impacted modules: None.
4669: -- FND_MESSAGE.SET_NAME('XDP', 'XDP_RETURN_STATUS_ERROR');
4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');

Line 4669: -- FND_MESSAGE.SET_NAME('XDP', 'XDP_RETURN_STATUS_ERROR');

4665: -- Date: 20 Jan 2005 Author: DPUTHIYE Bug#: 4083708
4666: -- Change: The FND message thrown by this exception has been replaced with a new message
4667: -- The new message also contains the error text (ERROR_TEXT) returned by the WI mapping proc.
4668: -- Impacted modules: None.
4669: -- FND_MESSAGE.SET_NAME('XDP', 'XDP_RETURN_STATUS_ERROR');
4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');
4671: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4672: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4673: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);

Line 4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');

4666: -- Change: The FND message thrown by this exception has been replaced with a new message
4667: -- The new message also contains the error text (ERROR_TEXT) returned by the WI mapping proc.
4668: -- Impacted modules: None.
4669: -- FND_MESSAGE.SET_NAME('XDP', 'XDP_RETURN_STATUS_ERROR');
4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');
4671: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4672: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4673: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4674: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', LV_ERROR_DESCRIPTION);

Line 4671: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

4667: -- The new message also contains the error text (ERROR_TEXT) returned by the WI mapping proc.
4668: -- Impacted modules: None.
4669: -- FND_MESSAGE.SET_NAME('XDP', 'XDP_RETURN_STATUS_ERROR');
4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');
4671: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4672: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4673: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4674: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', LV_ERROR_DESCRIPTION);
4675: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');

Line 4672: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

4668: -- Impacted modules: None.
4669: -- FND_MESSAGE.SET_NAME('XDP', 'XDP_RETURN_STATUS_ERROR');
4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');
4671: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4672: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4673: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4674: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', LV_ERROR_DESCRIPTION);
4675: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4676:

Line 4673: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);

4669: -- FND_MESSAGE.SET_NAME('XDP', 'XDP_RETURN_STATUS_ERROR');
4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');
4671: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4672: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4673: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4674: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', LV_ERROR_DESCRIPTION);
4675: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4676:
4677: WHEN e_srv_config_error THEN

Line 4674: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', LV_ERROR_DESCRIPTION);

4670: FND_MESSAGE.SET_NAME('XDP', 'XDP_WI_MAP_PROC_ERROR');
4671: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4672: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4673: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4674: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', LV_ERROR_DESCRIPTION);
4675: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4676:
4677: WHEN e_srv_config_error THEN
4678: FND_MESSAGE.SET_NAME('XDP', 'XDP_SERVICE_WI_MAP_ERROR');

Line 4678: FND_MESSAGE.SET_NAME('XDP', 'XDP_SERVICE_WI_MAP_ERROR');

4674: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', LV_ERROR_DESCRIPTION);
4675: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4676:
4677: WHEN e_srv_config_error THEN
4678: FND_MESSAGE.SET_NAME('XDP', 'XDP_SERVICE_WI_MAP_ERROR');
4679: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4680: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4681: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4682: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');

Line 4679: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);

4675: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4676:
4677: WHEN e_srv_config_error THEN
4678: FND_MESSAGE.SET_NAME('XDP', 'XDP_SERVICE_WI_MAP_ERROR');
4679: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4680: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4681: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4682: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4683:

Line 4680: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);

4676:
4677: WHEN e_srv_config_error THEN
4678: FND_MESSAGE.SET_NAME('XDP', 'XDP_SERVICE_WI_MAP_ERROR');
4679: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4680: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4681: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4682: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4683:
4684: WHEN OTHERS THEN

Line 4681: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);

4677: WHEN e_srv_config_error THEN
4678: FND_MESSAGE.SET_NAME('XDP', 'XDP_SERVICE_WI_MAP_ERROR');
4679: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',G_external_order_reference);
4680: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line_number);
4681: FND_MESSAGE.SET_TOKEN('LINE_ITEM_NAME', l_service_item_name);
4682: XDP_UTILITIES.RAISE_EXCEPTION('XDP_ORDER.CREATE_FULFILL_WORKLIST');
4683:
4684: WHEN OTHERS THEN
4685: xdp_utilities.generic_error('XDP_PROCESS_ORDER.CREATE_FULFILL_WORKLIST'

Line 5264: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL'); -- Done 191384

5260: END IF;
5261: END IF;
5262: EXCEPTION
5263: WHEN e_no_evalproc_specified THEN
5264: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL'); -- Done 191384
5265: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5266: fnd_message.set_token('LINE_NUMBER',l_line_number);
5267: fnd_message.set_token('WORKITEM',l_workitem);
5268: fnd_message.set_token('PARAMETER',l_parameter);

Line 5265: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);

5261: END IF;
5262: EXCEPTION
5263: WHEN e_no_evalproc_specified THEN
5264: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL'); -- Done 191384
5265: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5266: fnd_message.set_token('LINE_NUMBER',l_line_number);
5267: fnd_message.set_token('WORKITEM',l_workitem);
5268: fnd_message.set_token('PARAMETER',l_parameter);
5269: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');

Line 5266: fnd_message.set_token('LINE_NUMBER',l_line_number);

5262: EXCEPTION
5263: WHEN e_no_evalproc_specified THEN
5264: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL'); -- Done 191384
5265: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5266: fnd_message.set_token('LINE_NUMBER',l_line_number);
5267: fnd_message.set_token('WORKITEM',l_workitem);
5268: fnd_message.set_token('PARAMETER',l_parameter);
5269: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5270:

Line 5267: fnd_message.set_token('WORKITEM',l_workitem);

5263: WHEN e_no_evalproc_specified THEN
5264: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL'); -- Done 191384
5265: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5266: fnd_message.set_token('LINE_NUMBER',l_line_number);
5267: fnd_message.set_token('WORKITEM',l_workitem);
5268: fnd_message.set_token('PARAMETER',l_parameter);
5269: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5270:
5271: WHEN e_req_param_null THEN

Line 5268: fnd_message.set_token('PARAMETER',l_parameter);

5264: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL'); -- Done 191384
5265: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5266: fnd_message.set_token('LINE_NUMBER',l_line_number);
5267: fnd_message.set_token('WORKITEM',l_workitem);
5268: fnd_message.set_token('PARAMETER',l_parameter);
5269: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5270:
5271: WHEN e_req_param_null THEN
5272: fnd_message.set_name('XDP','XDP_REQ_WI_PARAM_NULL'); -- Done 191385

Line 5272: fnd_message.set_name('XDP','XDP_REQ_WI_PARAM_NULL'); -- Done 191385

5268: fnd_message.set_token('PARAMETER',l_parameter);
5269: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5270:
5271: WHEN e_req_param_null THEN
5272: fnd_message.set_name('XDP','XDP_REQ_WI_PARAM_NULL'); -- Done 191385
5273: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5274: fnd_message.set_token('LINE_NUMBER',l_line_number);
5275: fnd_message.set_token('WORKITEM',l_workitem);
5276: fnd_message.set_token('PARAMETER',l_parameter);

Line 5273: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);

5269: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5270:
5271: WHEN e_req_param_null THEN
5272: fnd_message.set_name('XDP','XDP_REQ_WI_PARAM_NULL'); -- Done 191385
5273: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5274: fnd_message.set_token('LINE_NUMBER',l_line_number);
5275: fnd_message.set_token('WORKITEM',l_workitem);
5276: fnd_message.set_token('PARAMETER',l_parameter);
5277: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');

Line 5274: fnd_message.set_token('LINE_NUMBER',l_line_number);

5270:
5271: WHEN e_req_param_null THEN
5272: fnd_message.set_name('XDP','XDP_REQ_WI_PARAM_NULL'); -- Done 191385
5273: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5274: fnd_message.set_token('LINE_NUMBER',l_line_number);
5275: fnd_message.set_token('WORKITEM',l_workitem);
5276: fnd_message.set_token('PARAMETER',l_parameter);
5277: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5278:

Line 5275: fnd_message.set_token('WORKITEM',l_workitem);

5271: WHEN e_req_param_null THEN
5272: fnd_message.set_name('XDP','XDP_REQ_WI_PARAM_NULL'); -- Done 191385
5273: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5274: fnd_message.set_token('LINE_NUMBER',l_line_number);
5275: fnd_message.set_token('WORKITEM',l_workitem);
5276: fnd_message.set_token('PARAMETER',l_parameter);
5277: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5278:
5279: WHEN e_wi_param_evalproc_failed THEN

Line 5276: fnd_message.set_token('PARAMETER',l_parameter);

5272: fnd_message.set_name('XDP','XDP_REQ_WI_PARAM_NULL'); -- Done 191385
5273: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5274: fnd_message.set_token('LINE_NUMBER',l_line_number);
5275: fnd_message.set_token('WORKITEM',l_workitem);
5276: fnd_message.set_token('PARAMETER',l_parameter);
5277: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5278:
5279: WHEN e_wi_param_evalproc_failed THEN
5280: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED'); -- Done 191386

Line 5280: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED'); -- Done 191386

5276: fnd_message.set_token('PARAMETER',l_parameter);
5277: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5278:
5279: WHEN e_wi_param_evalproc_failed THEN
5280: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED'); -- Done 191386
5281: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5282: fnd_message.set_token('LINE_NUMBER',l_line_number);
5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);

Line 5281: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);

5277: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5278:
5279: WHEN e_wi_param_evalproc_failed THEN
5280: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED'); -- Done 191386
5281: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5282: fnd_message.set_token('LINE_NUMBER',l_line_number);
5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);
5285: fnd_message.set_token('EVALPROC',l_evalproc);

Line 5282: fnd_message.set_token('LINE_NUMBER',l_line_number);

5278:
5279: WHEN e_wi_param_evalproc_failed THEN
5280: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED'); -- Done 191386
5281: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5282: fnd_message.set_token('LINE_NUMBER',l_line_number);
5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);
5285: fnd_message.set_token('EVALPROC',l_evalproc);
5286: fnd_message.set_token('ERRCODE',l_error_code);

Line 5283: fnd_message.set_token('WORKITEM',l_workitem);

5279: WHEN e_wi_param_evalproc_failed THEN
5280: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED'); -- Done 191386
5281: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5282: fnd_message.set_token('LINE_NUMBER',l_line_number);
5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);
5285: fnd_message.set_token('EVALPROC',l_evalproc);
5286: fnd_message.set_token('ERRCODE',l_error_code);
5287: fnd_message.set_token('ERRMSG',l_error_message);

Line 5284: fnd_message.set_token('PARAMETER',l_parameter);

5280: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED'); -- Done 191386
5281: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5282: fnd_message.set_token('LINE_NUMBER',l_line_number);
5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);
5285: fnd_message.set_token('EVALPROC',l_evalproc);
5286: fnd_message.set_token('ERRCODE',l_error_code);
5287: fnd_message.set_token('ERRMSG',l_error_message);
5288: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');

Line 5285: fnd_message.set_token('EVALPROC',l_evalproc);

5281: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5282: fnd_message.set_token('LINE_NUMBER',l_line_number);
5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);
5285: fnd_message.set_token('EVALPROC',l_evalproc);
5286: fnd_message.set_token('ERRCODE',l_error_code);
5287: fnd_message.set_token('ERRMSG',l_error_message);
5288: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5289:

Line 5286: fnd_message.set_token('ERRCODE',l_error_code);

5282: fnd_message.set_token('LINE_NUMBER',l_line_number);
5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);
5285: fnd_message.set_token('EVALPROC',l_evalproc);
5286: fnd_message.set_token('ERRCODE',l_error_code);
5287: fnd_message.set_token('ERRMSG',l_error_message);
5288: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5289:
5290: WHEN e_parameter_not_defined THEN

Line 5287: fnd_message.set_token('ERRMSG',l_error_message);

5283: fnd_message.set_token('WORKITEM',l_workitem);
5284: fnd_message.set_token('PARAMETER',l_parameter);
5285: fnd_message.set_token('EVALPROC',l_evalproc);
5286: fnd_message.set_token('ERRCODE',l_error_code);
5287: fnd_message.set_token('ERRMSG',l_error_message);
5288: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5289:
5290: WHEN e_parameter_not_defined THEN
5291: fnd_message.set_name('XDP','XDP_PARAM_NOT_DEFINED');

Line 5291: fnd_message.set_name('XDP','XDP_PARAM_NOT_DEFINED');

5287: fnd_message.set_token('ERRMSG',l_error_message);
5288: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5289:
5290: WHEN e_parameter_not_defined THEN
5291: fnd_message.set_name('XDP','XDP_PARAM_NOT_DEFINED');
5292: fnd_message.set_token('LINE_NUMBER',l_line_number);
5293: fnd_message.set_token('PARAMETER',l_parameter);
5294:
5295: WHEN OTHERS THEN

Line 5292: fnd_message.set_token('LINE_NUMBER',l_line_number);

5288: xdp_utilities.raise_exception('XDP_ORDER.APPEND_WI_PARAM_CONFIG');
5289:
5290: WHEN e_parameter_not_defined THEN
5291: fnd_message.set_name('XDP','XDP_PARAM_NOT_DEFINED');
5292: fnd_message.set_token('LINE_NUMBER',l_line_number);
5293: fnd_message.set_token('PARAMETER',l_parameter);
5294:
5295: WHEN OTHERS THEN
5296: xdp_utilities.generic_error('XDP_PROCESS_ORDER.APPEND_WI_PARAM_CONFIG'

Line 5293: fnd_message.set_token('PARAMETER',l_parameter);

5289:
5290: WHEN e_parameter_not_defined THEN
5291: fnd_message.set_name('XDP','XDP_PARAM_NOT_DEFINED');
5292: fnd_message.set_token('LINE_NUMBER',l_line_number);
5293: fnd_message.set_token('PARAMETER',l_parameter);
5294:
5295: WHEN OTHERS THEN
5296: xdp_utilities.generic_error('XDP_PROCESS_ORDER.APPEND_WI_PARAM_CONFIG'
5297: , G_external_order_reference

Line 5533: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL');

5529: END LOOP;
5530:
5531: EXCEPTION
5532: WHEN e_no_evalproc_specified THEN
5533: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL');
5534: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5535: fnd_message.set_token('LINE_NUMBER',l_line_number);
5536: fnd_message.set_token('WORKITEM',l_workitem);
5537: fnd_message.set_token('PARAMETER',l_parameter);

Line 5534: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);

5530:
5531: EXCEPTION
5532: WHEN e_no_evalproc_specified THEN
5533: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL');
5534: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5535: fnd_message.set_token('LINE_NUMBER',l_line_number);
5536: fnd_message.set_token('WORKITEM',l_workitem);
5537: fnd_message.set_token('PARAMETER',l_parameter);
5538: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');

Line 5535: fnd_message.set_token('LINE_NUMBER',l_line_number);

5531: EXCEPTION
5532: WHEN e_no_evalproc_specified THEN
5533: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL');
5534: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5535: fnd_message.set_token('LINE_NUMBER',l_line_number);
5536: fnd_message.set_token('WORKITEM',l_workitem);
5537: fnd_message.set_token('PARAMETER',l_parameter);
5538: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5539:

Line 5536: fnd_message.set_token('WORKITEM',l_workitem);

5532: WHEN e_no_evalproc_specified THEN
5533: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL');
5534: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5535: fnd_message.set_token('LINE_NUMBER',l_line_number);
5536: fnd_message.set_token('WORKITEM',l_workitem);
5537: fnd_message.set_token('PARAMETER',l_parameter);
5538: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5539:
5540: WHEN e_wi_param_evalproc_failed THEN

Line 5537: fnd_message.set_token('PARAMETER',l_parameter);

5533: fnd_message.set_name('XDP','XDP_WI_EVAL_PROC_NULL');
5534: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5535: fnd_message.set_token('LINE_NUMBER',l_line_number);
5536: fnd_message.set_token('WORKITEM',l_workitem);
5537: fnd_message.set_token('PARAMETER',l_parameter);
5538: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5539:
5540: WHEN e_wi_param_evalproc_failed THEN
5541: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED');

Line 5541: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED');

5537: fnd_message.set_token('PARAMETER',l_parameter);
5538: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5539:
5540: WHEN e_wi_param_evalproc_failed THEN
5541: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED');
5542: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5543: fnd_message.set_token('LINE_NUMBER',l_line_number);
5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);

Line 5542: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);

5538: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5539:
5540: WHEN e_wi_param_evalproc_failed THEN
5541: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED');
5542: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5543: fnd_message.set_token('LINE_NUMBER',l_line_number);
5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);
5546: fnd_message.set_token('EVALPROC',l_evalproc);

Line 5543: fnd_message.set_token('LINE_NUMBER',l_line_number);

5539:
5540: WHEN e_wi_param_evalproc_failed THEN
5541: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED');
5542: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5543: fnd_message.set_token('LINE_NUMBER',l_line_number);
5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);
5546: fnd_message.set_token('EVALPROC',l_evalproc);
5547: fnd_message.set_token('ERRCODE',l_error_code);

Line 5544: fnd_message.set_token('WORKITEM',l_workitem);

5540: WHEN e_wi_param_evalproc_failed THEN
5541: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED');
5542: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5543: fnd_message.set_token('LINE_NUMBER',l_line_number);
5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);
5546: fnd_message.set_token('EVALPROC',l_evalproc);
5547: fnd_message.set_token('ERRCODE',l_error_code);
5548: fnd_message.set_token('ERRMSG',l_error_message);

Line 5545: fnd_message.set_token('PARAMETER',l_parameter);

5541: fnd_message.set_name('XDP','XDP_WI_PARAM_EVALPROC_FAILED');
5542: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5543: fnd_message.set_token('LINE_NUMBER',l_line_number);
5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);
5546: fnd_message.set_token('EVALPROC',l_evalproc);
5547: fnd_message.set_token('ERRCODE',l_error_code);
5548: fnd_message.set_token('ERRMSG',l_error_message);
5549: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');

Line 5546: fnd_message.set_token('EVALPROC',l_evalproc);

5542: fnd_message.set_token('ORDER_NUMBER',G_external_order_reference);
5543: fnd_message.set_token('LINE_NUMBER',l_line_number);
5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);
5546: fnd_message.set_token('EVALPROC',l_evalproc);
5547: fnd_message.set_token('ERRCODE',l_error_code);
5548: fnd_message.set_token('ERRMSG',l_error_message);
5549: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5550:

Line 5547: fnd_message.set_token('ERRCODE',l_error_code);

5543: fnd_message.set_token('LINE_NUMBER',l_line_number);
5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);
5546: fnd_message.set_token('EVALPROC',l_evalproc);
5547: fnd_message.set_token('ERRCODE',l_error_code);
5548: fnd_message.set_token('ERRMSG',l_error_message);
5549: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5550:
5551: WHEN OTHERS THEN

Line 5548: fnd_message.set_token('ERRMSG',l_error_message);

5544: fnd_message.set_token('WORKITEM',l_workitem);
5545: fnd_message.set_token('PARAMETER',l_parameter);
5546: fnd_message.set_token('EVALPROC',l_evalproc);
5547: fnd_message.set_token('ERRCODE',l_error_code);
5548: fnd_message.set_token('ERRMSG',l_error_message);
5549: xdp_utilities.raise_exception('XDP_ORDER.EVALUATE_WORKITEM_PARAMS');
5550:
5551: WHEN OTHERS THEN
5552: xdp_utilities.generic_error('XDP_PROCESS_ORDER.EVALUATE_WORKITEM_PARAMS'

Line 5596: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');

5592: ,x_error_message => x_error_message);
5593:
5594:
5595: IF x_error_code <> 0 THEN
5596: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5597: FND_MESSAGE.SET_TOKEN('ORDER_ID', G_external_order_reference);
5598: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',p_fulfill_worklist_list(lv_index).WORKITEM_NAME);
5599: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',x_error_message);
5600: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5597: FND_MESSAGE.SET_TOKEN('ORDER_ID', G_external_order_reference);

5593:
5594:
5595: IF x_error_code <> 0 THEN
5596: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5597: FND_MESSAGE.SET_TOKEN('ORDER_ID', G_external_order_reference);
5598: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',p_fulfill_worklist_list(lv_index).WORKITEM_NAME);
5599: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',x_error_message);
5600: APP_EXCEPTION.RAISE_EXCEPTION;
5601: END IF;

Line 5598: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',p_fulfill_worklist_list(lv_index).WORKITEM_NAME);

5594:
5595: IF x_error_code <> 0 THEN
5596: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5597: FND_MESSAGE.SET_TOKEN('ORDER_ID', G_external_order_reference);
5598: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',p_fulfill_worklist_list(lv_index).WORKITEM_NAME);
5599: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',x_error_message);
5600: APP_EXCEPTION.RAISE_EXCEPTION;
5601: END IF;
5602: END IF;

Line 5599: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',x_error_message);

5595: IF x_error_code <> 0 THEN
5596: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5597: FND_MESSAGE.SET_TOKEN('ORDER_ID', G_external_order_reference);
5598: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',p_fulfill_worklist_list(lv_index).WORKITEM_NAME);
5599: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',x_error_message);
5600: APP_EXCEPTION.RAISE_EXCEPTION;
5601: END IF;
5602: END IF;
5603: END LOOP;