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

Line 142: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

138: EXCEPTION
139: WHEN e_insert_bill THEN
140: x_error_code := 1;
141: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_bill';
142: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
143: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_bill');
144: x_error_msg := fnd_message.get;
145:
146: WHEN OTHERS THEN

Line 143: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_bill');

139: WHEN e_insert_bill THEN
140: x_error_code := 1;
141: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_bill';
142: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
143: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_bill');
144: x_error_msg := fnd_message.get;
145:
146: WHEN OTHERS THEN
147: x_error_code := sqlcode;

Line 144: x_error_msg := fnd_message.get;

140: x_error_code := 1;
141: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_bill';
142: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
143: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_bill');
144: x_error_msg := fnd_message.get;
145:
146: WHEN OTHERS THEN
147: x_error_code := sqlcode;
148: x_error_msg := 'WSMPPCPD.insert_bill(' || x_progress || ')' || ' - ' || substr(sqlerrm, 1, 200);

Line 362: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

358: EXCEPTION
359: WHEN e_insert_component THEN
360: x_error_code := 1;
361: --x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_component';
362: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
363: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_component');
364: x_error_msg := fnd_message.get;
365:
366: WHEN OTHERS THEN

Line 363: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_component');

359: WHEN e_insert_component THEN
360: x_error_code := 1;
361: --x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_component';
362: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
363: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_component');
364: x_error_msg := fnd_message.get;
365:
366: WHEN OTHERS THEN
367: x_error_code := sqlcode;

Line 364: x_error_msg := fnd_message.get;

360: x_error_code := 1;
361: --x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_component';
362: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
363: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_component');
364: x_error_msg := fnd_message.get;
365:
366: WHEN OTHERS THEN
367: x_error_code := sqlcode;
368: x_error_msg := 'WSMPPCPD.insert_component(' || x_progress || ')' || ' - ' || substr(sqlerrm, 1, 200);

Line 549: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

545: EXCEPTION
546: WHEN e_insert_substitute THEN
547: x_error_code := 1;
548: --x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_substitute_component';
549: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
550: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_substitute_component');
551: x_error_msg := fnd_message.get;
552:
553: WHEN e_proc_exception THEN

Line 550: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_substitute_component');

546: WHEN e_insert_substitute THEN
547: x_error_code := 1;
548: --x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_substitute_component';
549: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
550: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_substitute_component');
551: x_error_msg := fnd_message.get;
552:
553: WHEN e_proc_exception THEN
554: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.insert_substitute_component('||x_progress||')';

Line 551: x_error_msg := fnd_message.get;

547: x_error_code := 1;
548: --x_error_msg := 'Insufficient arguments to WSMPPCPD.insert_substitute_component';
549: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
550: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.insert_substitute_component');
551: x_error_msg := fnd_message.get;
552:
553: WHEN e_proc_exception THEN
554: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.insert_substitute_component('||x_progress||')';
555:

Line 851: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

847:
848: EXCEPTION
849:
850: WHEN bom_dupl_comp_err THEN
851: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
852: raise e_check_unique_exception;
853:
854: WHEN NO_DATA_FOUND THEN
855: NULL;

Line 858: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

854: WHEN NO_DATA_FOUND THEN
855: NULL;
856:
857: WHEN TOO_MANY_ROWS THEN
858: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
859: raise e_check_unique_exception;
860: -- modification end for perf. tuning.. abedajna 10/12/00
861:
862: END;

Line 883: fnd_message.set_name('INV','INV_NOT_VALID');

879: AND ((bbom.assembly_type = 1
880: AND msi.eng_item_flag = 'N')
881: OR (bbom.assembly_type = 2)));
882:
883: fnd_message.set_name('INV','INV_NOT_VALID');
884: fnd_message.set_token('ENTITY','Substitute item', TRUE);
885: raise e_check_common;
886:
887: EXCEPTION

Line 884: fnd_message.set_token('ENTITY','Substitute item', TRUE);

880: AND msi.eng_item_flag = 'N')
881: OR (bbom.assembly_type = 2)));
882:
883: fnd_message.set_name('INV','INV_NOT_VALID');
884: fnd_message.set_token('ENTITY','Substitute item', TRUE);
885: raise e_check_common;
886:
887: EXCEPTION
888: WHEN NO_DATA_FOUND THEN

Line 983: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

979:
980: EXCEPTION
981:
982: WHEN bom_dupl_comp_err THEN
983: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
984: raise e_check_unique_exception;
985:
986: WHEN NO_DATA_FOUND THEN
987: NULL;

Line 990: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

986: WHEN NO_DATA_FOUND THEN
987: NULL;
988:
989: WHEN TOO_MANY_ROWS THEN
990: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
991: raise e_check_unique_exception;
992:
993: -- modification end for perf. tuning.. abedajna 10/12/00
994: END;

Line 1015: fnd_message.set_name('INV','INV_NOT_VALID');

1011: AND ((bbom.assembly_type = 1
1012: AND msi.eng_item_flag = 'N')
1013: OR (bbom.assembly_type = 2)));
1014:
1015: fnd_message.set_name('INV','INV_NOT_VALID');
1016: fnd_message.set_token('ENTITY','Substitute item', TRUE);
1017: raise e_check_common;
1018:
1019: EXCEPTION

Line 1016: fnd_message.set_token('ENTITY','Substitute item', TRUE);

1012: AND msi.eng_item_flag = 'N')
1013: OR (bbom.assembly_type = 2)));
1014:
1015: fnd_message.set_name('INV','INV_NOT_VALID');
1016: fnd_message.set_token('ENTITY','Substitute item', TRUE);
1017: raise e_check_common;
1018:
1019: EXCEPTION
1020: WHEN NO_DATA_FOUND THEN

Line 1118: fnd_message.set_name('WSM','WSM_MISSING_BOM_COMP');

1114: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.insert_sub_comps('||x_progress||')';
1115:
1116: WHEN e_comp_exception THEN
1117: x_error_code := 1;
1118: fnd_message.set_name('WSM','WSM_MISSING_BOM_COMP');
1119: x_error_msg := fnd_message.get;
1120:
1121: WHEN e_check_unique_exception THEN
1122: x_error_code := 2;

Line 1119: x_error_msg := fnd_message.get;

1115:
1116: WHEN e_comp_exception THEN
1117: x_error_code := 1;
1118: fnd_message.set_name('WSM','WSM_MISSING_BOM_COMP');
1119: x_error_msg := fnd_message.get;
1120:
1121: WHEN e_check_unique_exception THEN
1122: x_error_code := 2;
1123: x_error_msg := fnd_message.get;

Line 1123: x_error_msg := fnd_message.get;

1119: x_error_msg := fnd_message.get;
1120:
1121: WHEN e_check_unique_exception THEN
1122: x_error_code := 2;
1123: x_error_msg := fnd_message.get;
1124:
1125: WHEN e_check_common THEN
1126: x_error_code := 3;
1127: x_error_msg := fnd_message.get;

Line 1127: x_error_msg := fnd_message.get;

1123: x_error_msg := fnd_message.get;
1124:
1125: WHEN e_check_common THEN
1126: x_error_code := 3;
1127: x_error_msg := fnd_message.get;
1128:
1129: WHEN e_sub_comp_not_exists THEN
1130: x_error_code := 4;
1131: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');

Line 1131: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');

1127: x_error_msg := fnd_message.get;
1128:
1129: WHEN e_sub_comp_not_exists THEN
1130: x_error_code := 4;
1131: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');
1132: x_error_msg := fnd_message.get;
1133:
1134: WHEN app_exceptions.record_lock_exception THEN
1135: x_error_code := 5;

Line 1132: x_error_msg := fnd_message.get;

1128:
1129: WHEN e_sub_comp_not_exists THEN
1130: x_error_code := 4;
1131: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');
1132: x_error_msg := fnd_message.get;
1133:
1134: WHEN app_exceptions.record_lock_exception THEN
1135: x_error_code := 5;
1136: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');

Line 1136: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');

1132: x_error_msg := fnd_message.get;
1133:
1134: WHEN app_exceptions.record_lock_exception THEN
1135: x_error_code := 5;
1136: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');
1137: x_error_msg := fnd_message.get;
1138:
1139: WHEN OTHERS THEN
1140: x_error_code := sqlcode;

Line 1137: x_error_msg := fnd_message.get;

1133:
1134: WHEN app_exceptions.record_lock_exception THEN
1135: x_error_code := 5;
1136: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');
1137: x_error_msg := fnd_message.get;
1138:
1139: WHEN OTHERS THEN
1140: x_error_code := sqlcode;
1141: x_error_msg := 'WSMPPCPD.process_bom_sub_comp(' || x_progress || ')' || ' - ' || substr(sqlerrm, 1, 200);

Line 1345: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

1341:
1342: EXCEPTION
1343:
1344: WHEN bom_dupl_comp_err THEN
1345: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
1346: raise e_check_unique_exception;
1347:
1348: WHEN NO_DATA_FOUND THEN
1349: NULL;

Line 1352: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

1348: WHEN NO_DATA_FOUND THEN
1349: NULL;
1350:
1351: WHEN TOO_MANY_ROWS THEN
1352: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
1353: raise e_check_unique_exception;
1354: -- modification end for perf. tuning.. abedajna 10/12/00
1355:
1356: END;

Line 1378: fnd_message.set_name('INV','INV_NOT_VALID');

1374: AND ((bbom.assembly_type = 1
1375: AND msi.eng_item_flag = 'N')
1376: OR (bbom.assembly_type = 2)));
1377:
1378: fnd_message.set_name('INV','INV_NOT_VALID');
1379: fnd_message.set_token('ENTITY','Substitute item', TRUE);
1380: raise e_check_common;
1381:
1382: EXCEPTION

Line 1379: fnd_message.set_token('ENTITY','Substitute item', TRUE);

1375: AND msi.eng_item_flag = 'N')
1376: OR (bbom.assembly_type = 2)));
1377:
1378: fnd_message.set_name('INV','INV_NOT_VALID');
1379: fnd_message.set_token('ENTITY','Substitute item', TRUE);
1380: raise e_check_common;
1381:
1382: EXCEPTION
1383: WHEN NO_DATA_FOUND THEN

Line 1450: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

1446:
1447: EXCEPTION
1448:
1449: WHEN bom_dupl_comp_err THEN
1450: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
1451: raise e_check_unique_exception;
1452:
1453: WHEN NO_DATA_FOUND THEN
1454: NULL;

Line 1457: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');

1453: WHEN NO_DATA_FOUND THEN
1454: NULL;
1455:
1456: WHEN TOO_MANY_ROWS THEN
1457: fnd_message.set_name('BOM','BOM_DUPLICATE_SUB_COMP');
1458: raise e_check_unique_exception;
1459:
1460: -- modification end for perf. tuning.. abedajna 10/12/00
1461: END;

Line 1483: fnd_message.set_name('INV','INV_NOT_VALID');

1479: AND ((bbom.assembly_type = 1
1480: AND msi.eng_item_flag = 'N')
1481: OR (bbom.assembly_type = 2)));
1482:
1483: fnd_message.set_name('INV','INV_NOT_VALID');
1484: fnd_message.set_token('ENTITY','Substitute item', TRUE);
1485: raise e_check_common;
1486:
1487: EXCEPTION

Line 1484: fnd_message.set_token('ENTITY','Substitute item', TRUE);

1480: AND msi.eng_item_flag = 'N')
1481: OR (bbom.assembly_type = 2)));
1482:
1483: fnd_message.set_name('INV','INV_NOT_VALID');
1484: fnd_message.set_token('ENTITY','Substitute item', TRUE);
1485: raise e_check_common;
1486:
1487: EXCEPTION
1488: WHEN NO_DATA_FOUND THEN

Line 1632: fnd_message.set_name('WSM','WSM_MISSING_BOM_COMP');

1628: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.insert_sub_comps('||x_progress||')';
1629:
1630: WHEN e_comp_exception THEN
1631: x_error_code := 1;
1632: fnd_message.set_name('WSM','WSM_MISSING_BOM_COMP');
1633: x_error_msg := fnd_message.get;
1634:
1635: WHEN e_check_unique_exception THEN
1636: x_error_code := 2;

Line 1633: x_error_msg := fnd_message.get;

1629:
1630: WHEN e_comp_exception THEN
1631: x_error_code := 1;
1632: fnd_message.set_name('WSM','WSM_MISSING_BOM_COMP');
1633: x_error_msg := fnd_message.get;
1634:
1635: WHEN e_check_unique_exception THEN
1636: x_error_code := 2;
1637: x_error_msg := fnd_message.get;

Line 1637: x_error_msg := fnd_message.get;

1633: x_error_msg := fnd_message.get;
1634:
1635: WHEN e_check_unique_exception THEN
1636: x_error_code := 2;
1637: x_error_msg := fnd_message.get;
1638:
1639: WHEN e_check_common THEN
1640: x_error_code := 3;
1641: x_error_msg := fnd_message.get;

Line 1641: x_error_msg := fnd_message.get;

1637: x_error_msg := fnd_message.get;
1638:
1639: WHEN e_check_common THEN
1640: x_error_code := 3;
1641: x_error_msg := fnd_message.get;
1642:
1643: WHEN e_sub_comp_not_exists THEN
1644: x_error_code := 4;
1645: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');

Line 1645: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');

1641: x_error_msg := fnd_message.get;
1642:
1643: WHEN e_sub_comp_not_exists THEN
1644: x_error_code := 4;
1645: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');
1646: x_error_msg := fnd_message.get;
1647:
1648: WHEN app_exceptions.record_lock_exception THEN
1649: x_error_code := 5;

Line 1646: x_error_msg := fnd_message.get;

1642:
1643: WHEN e_sub_comp_not_exists THEN
1644: x_error_code := 4;
1645: fnd_message.set_name('WSM','WSM_MISSING_SUBS_COMP');
1646: x_error_msg := fnd_message.get;
1647:
1648: WHEN app_exceptions.record_lock_exception THEN
1649: x_error_code := 5;
1650: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');

Line 1650: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');

1646: x_error_msg := fnd_message.get;
1647:
1648: WHEN app_exceptions.record_lock_exception THEN
1649: x_error_code := 5;
1650: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');
1651: x_error_msg := fnd_message.get;
1652:
1653: WHEN OTHERS THEN
1654: x_error_code := sqlcode;

Line 1651: x_error_msg := fnd_message.get;

1647:
1648: WHEN app_exceptions.record_lock_exception THEN
1649: x_error_code := 5;
1650: fnd_message.set_name('WSM','WSM_SUBS_COMP_LOCK_ERR');
1651: x_error_msg := fnd_message.get;
1652:
1653: WHEN OTHERS THEN
1654: x_error_code := sqlcode;
1655: x_error_msg := 'WSMPPCPD.process_bom_sub_comp(' || x_progress || ')' || ' - ' || substr(sqlerrm, 1, 200);

Line 2405: fnd_message.set_name('WSM', 'WSM_NO_BILL_SEQ_ID');

2401: x_err_text => l_err_text );
2402:
2403: IF x_bill_sequence_id is NULL THEN
2404: -- x_error_msg := 'Unable to obtain Bill_Sequence_Id';
2405: fnd_message.set_name('WSM', 'WSM_NO_BILL_SEQ_ID');
2406: raise e_no_bill_seq_exception;
2407: END IF;
2408:
2409: x_progress := '126';

Line 2464: fnd_message.set_name('WSM', 'WSM_NO_COMP_SEQ_ID');

2460: '; - Unable to obtain Component_Sequence_Id';
2461: raise e_proc_exception;
2462: */
2463:
2464: fnd_message.set_name('WSM', 'WSM_NO_COMP_SEQ_ID');
2465: raise e_no_comp_seq_exception;
2466: END IF;
2467:
2468: End If; -- End of getCompseqId if x_comp_insert is True.

Line 2609: x_error_msg := fnd_message.get;

2605: EXCEPTION
2606:
2607: WHEN e_no_bill_seq_exception THEN
2608: x_error_code := -901;
2609: x_error_msg := fnd_message.get;
2610:
2611: WHEN e_no_comp_seq_exception THEN
2612: x_error_code := -902;
2613: x_error_msg := fnd_message.get;

Line 2613: x_error_msg := fnd_message.get;

2609: x_error_msg := fnd_message.get;
2610:
2611: WHEN e_no_comp_seq_exception THEN
2612: x_error_code := -902;
2613: x_error_msg := fnd_message.get;
2614:
2615: WHEN e_proc_exception THEN
2616: --x_error_code := -900; -- removed by raghu since we need the
2617: -- error code from call_bom_bo_api

Line 2859: fnd_message.set_name('WSM', 'WSM_NO_BILL_UPDATE');

2855:
2856: WHEN e_c_bill_exists THEN
2857: x_error_code := 3;
2858: -- x_error_msg := 'Cannot update bill. It currently points to another common bill.';
2859: fnd_message.set_name('WSM', 'WSM_NO_BILL_UPDATE');
2860: x_error_msg := fnd_message.get;
2861:
2862: WHEN e_components_exist THEN
2863: x_error_code := 2;

Line 2860: x_error_msg := fnd_message.get;

2856: WHEN e_c_bill_exists THEN
2857: x_error_code := 3;
2858: -- x_error_msg := 'Cannot update bill. It currently points to another common bill.';
2859: fnd_message.set_name('WSM', 'WSM_NO_BILL_UPDATE');
2860: x_error_msg := fnd_message.get;
2861:
2862: WHEN e_components_exist THEN
2863: x_error_code := 2;
2864: -- x_error_msg := 'Components exist on this bill. Cannot set common bill.';

Line 2865: fnd_message.set_name('WSM', 'WSM_BILL_COMPONENT_EXIST');

2861:
2862: WHEN e_components_exist THEN
2863: x_error_code := 2;
2864: -- x_error_msg := 'Components exist on this bill. Cannot set common bill.';
2865: fnd_message.set_name('WSM', 'WSM_BILL_COMPONENT_EXIST');
2866: x_error_msg := fnd_message.get;
2867:
2868: WHEN e_set_common_bill THEN
2869: x_error_code := 1;

Line 2866: x_error_msg := fnd_message.get;

2862: WHEN e_components_exist THEN
2863: x_error_code := 2;
2864: -- x_error_msg := 'Components exist on this bill. Cannot set common bill.';
2865: fnd_message.set_name('WSM', 'WSM_BILL_COMPONENT_EXIST');
2866: x_error_msg := fnd_message.get;
2867:
2868: WHEN e_set_common_bill THEN
2869: x_error_code := 1;
2870: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.set_common_bill';

Line 2871: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

2867:
2868: WHEN e_set_common_bill THEN
2869: x_error_code := 1;
2870: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.set_common_bill';
2871: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
2872: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.set_common_bill');
2873: x_error_msg := fnd_message.get;
2874:
2875: WHEN OTHERS THEN

Line 2872: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.set_common_bill');

2868: WHEN e_set_common_bill THEN
2869: x_error_code := 1;
2870: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.set_common_bill';
2871: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
2872: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.set_common_bill');
2873: x_error_msg := fnd_message.get;
2874:
2875: WHEN OTHERS THEN
2876: x_error_code := sqlcode;

Line 2873: x_error_msg := fnd_message.get;

2869: x_error_code := 1;
2870: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.set_common_bill';
2871: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
2872: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.set_common_bill');
2873: x_error_msg := fnd_message.get;
2874:
2875: WHEN OTHERS THEN
2876: x_error_code := sqlcode;
2877: x_error_msg := 'WSMPPCPD.set_common_bill(' || x_progress || ')' || ' - ' || substr(sqlerrm, 1, 200);

Line 2951: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

2947: EXCEPTION
2948: WHEN e_delete_component THEN
2949: x_error_code := 1;
2950: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.delete_component';
2951: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
2952: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_component');
2953: x_error_msg := fnd_message.get;
2954:
2955: WHEN e_proc_exception THEN

Line 2952: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_component');

2948: WHEN e_delete_component THEN
2949: x_error_code := 1;
2950: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.delete_component';
2951: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
2952: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_component');
2953: x_error_msg := fnd_message.get;
2954:
2955: WHEN e_proc_exception THEN
2956: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.delete_component('||x_progress||')';

Line 2953: x_error_msg := fnd_message.get;

2949: x_error_code := 1;
2950: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.delete_component';
2951: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
2952: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_component');
2953: x_error_msg := fnd_message.get;
2954:
2955: WHEN e_proc_exception THEN
2956: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.delete_component('||x_progress||')';
2957:

Line 3175: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

3171: EXCEPTION
3172: WHEN e_delete_co_product THEN
3173: x_error_code := 1;
3174: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.delete_co_product';
3175: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3176: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_co_product');
3177: x_error_msg := fnd_message.get;
3178:
3179: WHEN e_proc_exception THEN

Line 3176: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_co_product');

3172: WHEN e_delete_co_product THEN
3173: x_error_code := 1;
3174: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.delete_co_product';
3175: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3176: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_co_product');
3177: x_error_msg := fnd_message.get;
3178:
3179: WHEN e_proc_exception THEN
3180: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.delete_co_product('||x_progress||')';

Line 3177: x_error_msg := fnd_message.get;

3173: x_error_code := 1;
3174: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.delete_co_product';
3175: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3176: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.delete_co_product');
3177: x_error_msg := fnd_message.get;
3178:
3179: WHEN e_proc_exception THEN
3180: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.delete_co_product('||x_progress||')';
3181:

Line 3304: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

3300: EXCEPTION
3301: WHEN e_update_co_prod_details THEN
3302: x_error_code := 1;
3303: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.update_co_prod_details';
3304: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3305: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.update_co_prod_details');
3306: x_error_msg := fnd_message.get;
3307:
3308: WHEN e_proc_exception THEN

Line 3305: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.update_co_prod_details');

3301: WHEN e_update_co_prod_details THEN
3302: x_error_code := 1;
3303: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.update_co_prod_details';
3304: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3305: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.update_co_prod_details');
3306: x_error_msg := fnd_message.get;
3307:
3308: WHEN e_proc_exception THEN
3309: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.update_co_prod_details('||x_progress||')';

Line 3306: x_error_msg := fnd_message.get;

3302: x_error_code := 1;
3303: -- x_error_msg := 'Insufficient arguments to WSMPPCPD.update_co_prod_details';
3304: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3305: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.update_co_prod_details');
3306: x_error_msg := fnd_message.get;
3307:
3308: WHEN e_proc_exception THEN
3309: x_error_msg := x_error_msg || ' - ' || 'WSMPPCPD.update_co_prod_details('||x_progress||')';
3310:

Line 3345: fnd_message.set_name('WSM','WSM_ASSY_LOCK_ERR');

3341:
3342: EXCEPTION
3343: WHEN app_exceptions.record_lock_exception THEN
3344: x_error_code := 1;
3345: fnd_message.set_name('WSM','WSM_ASSY_LOCK_ERR');
3346: x_error_msg := fnd_message.get;
3347:
3348: WHEN OTHERS THEN
3349: x_error_code := sqlcode;

Line 3346: x_error_msg := fnd_message.get;

3342: EXCEPTION
3343: WHEN app_exceptions.record_lock_exception THEN
3344: x_error_code := 1;
3345: fnd_message.set_name('WSM','WSM_ASSY_LOCK_ERR');
3346: x_error_msg := fnd_message.get;
3347:
3348: WHEN OTHERS THEN
3349: x_error_code := sqlcode;
3350: x_error_msg := 'WSMPPCPD.lock_bill(' || x_progress || ')' || ' - ' || substr(sqlerrm, 1, 200);

Line 3382: fnd_message.set_name('WSM','WSM_COMP_LOCK_ERR');

3378:
3379: EXCEPTION
3380: WHEN app_exceptions.record_lock_exception THEN
3381: x_error_code := 1;
3382: fnd_message.set_name('WSM','WSM_COMP_LOCK_ERR');
3383: x_error_msg := fnd_message.get;
3384:
3385: WHEN OTHERS THEN
3386: x_error_code := sqlcode;

Line 3383: x_error_msg := fnd_message.get;

3379: EXCEPTION
3380: WHEN app_exceptions.record_lock_exception THEN
3381: x_error_code := 1;
3382: fnd_message.set_name('WSM','WSM_COMP_LOCK_ERR');
3383: x_error_msg := fnd_message.get;
3384:
3385: WHEN OTHERS THEN
3386: x_error_code := sqlcode;
3387: x_error_msg := 'WSMPPCPD.lock_component(' || x_progress || ')' || ' - ' || substr(sqlerrm, 1, 200);

Line 3529: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');

3525:
3526: WHEN e_null_param_exception THEN
3527: x_error_code := -900;
3528: -- x_error_msg := 'Assembly Item Name or Org Code is NULL in header_rec';
3529: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3530: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.call_bom_bo_api');
3531: x_error_msg := fnd_message.get;
3532:
3533: WHEN OTHERS THEN

Line 3530: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.call_bom_bo_api');

3526: WHEN e_null_param_exception THEN
3527: x_error_code := -900;
3528: -- x_error_msg := 'Assembly Item Name or Org Code is NULL in header_rec';
3529: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3530: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.call_bom_bo_api');
3531: x_error_msg := fnd_message.get;
3532:
3533: WHEN OTHERS THEN
3534: x_error_code := sqlcode;

Line 3531: x_error_msg := fnd_message.get;

3527: x_error_code := -900;
3528: -- x_error_msg := 'Assembly Item Name or Org Code is NULL in header_rec';
3529: fnd_message.set_name('WSM', 'WSM_INSUFFICIENT_ARGUMENTS');
3530: fnd_message.set_token('OBJECT_NAME', 'WSMPPCPD.call_bom_bo_api');
3531: x_error_msg := fnd_message.get;
3532:
3533: WHEN OTHERS THEN
3534: x_error_code := sqlcode;
3535: x_error_msg := 'WSMPPCPD.call_bom_bo_api - ' || substr(sqlerrm, 1, 200);

Line 3615: fnd_message.set_name('WSM', 'WSM_NO_PRIMARY_COPRODUCT');

3611:
3612:
3613: EXCEPTION
3614: When TOO_MANY_ROWS Then
3615: fnd_message.set_name('WSM', 'WSM_NO_PRIMARY_COPRODUCT');
3616: x_error_code := sqlcode;
3617: /* Bug# 1790690. Added the following statement so that
3618: it raises the exception where there are more than
3619: one primary flag is checked */

Line 3623: fnd_message.set_name('WSM', 'WSM_NO_PRIMARY_COPRODUCT');

3619: one primary flag is checked */
3620: raise e_primary_coprod_exception;
3621:
3622: When NO_DATA_FOUND Then
3623: fnd_message.set_name('WSM', 'WSM_NO_PRIMARY_COPRODUCT');
3624: x_error_code := sqlcode;
3625: /* Bug# 1790690. Added the following statement so that
3626: it raises the exception when the primary flag
3627: is not checked at all*/

Line 3644: fnd_message.set_name('WSM', 'WSM_NO_PRIMARY_COPRODUCT');

3640: WHERE inventory_item_id = l_prim_co_prod_id
3641: AND organization_id = p_organization_id;
3642:
3643: Else
3644: fnd_message.set_name('WSM', 'WSM_NO_PRIMARY_COPRODUCT');
3645: raise e_primary_coprod_exception;
3646: End If;
3647:
3648: x_progress := '030';

Line 3694: x_error_msg := fnd_message.get;

3690: EXCEPTION
3691:
3692: WHEN e_primary_coprod_exception Then
3693: x_error_code := -900;
3694: x_error_msg := fnd_message.get;
3695:
3696: WHEN OTHERS THEN
3697: x_error_code := sqlcode;
3698: x_error_msg := 'WSMPPCPD.set_common_bill_new('||x_progress ||') ' || substr(sqlerrm, 1, 200);