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

Line 649: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

645: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
646: IF (is_debug) THEN
647: print_debug('return error from query reservation: '||l_api_return_status,'INV_Pick_Release_PVT.Process_Reservations');
648: END IF;
649: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
650: fnd_msg_pub.ADD;
651: RAISE fnd_api.g_exc_unexpected_error;
652: END IF;
653:

Line 786: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

782: IF (l_quantity_to_detail = -99999) THEN
783: IF (is_debug) THEN
784: print_debug('Cannot convert uom to primary uom', 'Inv_Pick_release_pvt.process_reservations');
785: END IF;
786: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
787: fnd_message.set_token('UOM', l_primary_uom);
788: fnd_message.set_token('ROUTINE', 'Pick Release process');
789: fnd_msg_pub.ADD;
790: RAISE fnd_api.g_exc_unexpected_error;

Line 787: fnd_message.set_token('UOM', l_primary_uom);

783: IF (is_debug) THEN
784: print_debug('Cannot convert uom to primary uom', 'Inv_Pick_release_pvt.process_reservations');
785: END IF;
786: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
787: fnd_message.set_token('UOM', l_primary_uom);
788: fnd_message.set_token('ROUTINE', 'Pick Release process');
789: fnd_msg_pub.ADD;
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;

Line 788: fnd_message.set_token('ROUTINE', 'Pick Release process');

784: print_debug('Cannot convert uom to primary uom', 'Inv_Pick_release_pvt.process_reservations');
785: END IF;
786: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
787: fnd_message.set_token('UOM', l_primary_uom);
788: fnd_message.set_token('ROUTINE', 'Pick Release process');
789: fnd_msg_pub.ADD;
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792: ELSE

Line 865: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

861: IF (l_order_line_qty = -99999) THEN
862: IF (is_debug) THEN
863: print_debug('Cannot convert order quantity to primary uom', 'Inv_Pick_release_pvt.process_reservations');
864: END IF;
865: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
866: fnd_message.set_token('UOM', l_primary_uom);
867: fnd_message.set_token('ROUTINE', 'Pick Release process');
868: fnd_msg_pub.ADD;
869: RAISE fnd_api.g_exc_unexpected_error;

Line 866: fnd_message.set_token('UOM', l_primary_uom);

862: IF (is_debug) THEN
863: print_debug('Cannot convert order quantity to primary uom', 'Inv_Pick_release_pvt.process_reservations');
864: END IF;
865: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
866: fnd_message.set_token('UOM', l_primary_uom);
867: fnd_message.set_token('ROUTINE', 'Pick Release process');
868: fnd_msg_pub.ADD;
869: RAISE fnd_api.g_exc_unexpected_error;
870: END IF;

Line 867: fnd_message.set_token('ROUTINE', 'Pick Release process');

863: print_debug('Cannot convert order quantity to primary uom', 'Inv_Pick_release_pvt.process_reservations');
864: END IF;
865: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
866: fnd_message.set_token('UOM', l_primary_uom);
867: fnd_message.set_token('ROUTINE', 'Pick Release process');
868: fnd_msg_pub.ADD;
869: RAISE fnd_api.g_exc_unexpected_error;
870: END IF;
871: ELSE

Line 962: fnd_message.set_name('INV', 'INV_QRY_QTY_FAILED');

958: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
959: IF (is_debug) THEN
960: print_debug('Error from query quantity tree', 'Inv_Pick_Release_PVT.Process_Reservations');
961: END IF;
962: fnd_message.set_name('INV', 'INV_QRY_QTY_FAILED');
963: fnd_msg_pub.ADD;
964: RAISE fnd_api.g_exc_unexpected_error;
965: END IF;
966:

Line 1014: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');

1010: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1011: IF (is_debug) THEN
1012: print_debug('error in update reservation', 'Inv_Pick_Release_PVT.Process_Reservations');
1013: END IF;
1014: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
1015: fnd_msg_pub.ADD;
1016: RAISE fnd_api.g_exc_unexpected_error;
1017: ELSE
1018: --Requery the reservation record and update it in the local table.

Line 1038: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

1034: );
1035:
1036: -- Return an error if the query reservations call failed
1037: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1038: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1039: fnd_msg_pub.ADD;
1040: RAISE fnd_api.g_exc_unexpected_error;
1041: END IF;
1042:

Line 1098: fnd_message.set_name('INV', 'INV_QRY_QTY_FAILED');

1094: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1095: IF (is_debug) THEN
1096: print_debug('Error from query quantity tree', 'Inv_Pick_Release_PVT.Process_Reservations');
1097: END IF;
1098: fnd_message.set_name('INV', 'INV_QRY_QTY_FAILED');
1099: fnd_msg_pub.ADD;
1100: RAISE fnd_api.g_exc_unexpected_error;
1101: END IF;
1102:

Line 1135: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

1131: IF (l_new_rsv_quantity = -99999) THEN
1132: IF (is_debug) THEN
1133: print_debug('Cannot convert primary uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1134: END IF;
1135: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1136: fnd_message.set_token('UOM', l_primary_uom);
1137: fnd_message.set_token('ROUTINE', 'Pick Release process');
1138: fnd_msg_pub.ADD;
1139: RAISE fnd_api.g_exc_unexpected_error;

Line 1136: fnd_message.set_token('UOM', l_primary_uom);

1132: IF (is_debug) THEN
1133: print_debug('Cannot convert primary uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1134: END IF;
1135: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1136: fnd_message.set_token('UOM', l_primary_uom);
1137: fnd_message.set_token('ROUTINE', 'Pick Release process');
1138: fnd_msg_pub.ADD;
1139: RAISE fnd_api.g_exc_unexpected_error;
1140: END IF;

Line 1137: fnd_message.set_token('ROUTINE', 'Pick Release process');

1133: print_debug('Cannot convert primary uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1134: END IF;
1135: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1136: fnd_message.set_token('UOM', l_primary_uom);
1137: fnd_message.set_token('ROUTINE', 'Pick Release process');
1138: fnd_msg_pub.ADD;
1139: RAISE fnd_api.g_exc_unexpected_error;
1140: END IF;
1141: END IF;

Line 1264: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

1260: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1261: IF (is_debug) THEN
1262: print_debug('error in create reservation', 'Inv_Pick_Release_PVT.Process_Reservations');
1263: END IF;
1264: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1265: fnd_msg_pub.ADD;
1266: RAISE fnd_api.g_exc_unexpected_error;
1267: END IF;
1268:

Line 1277: fnd_message.set_name('INV', 'INV_COULD_NOT_PICK_FULL');

1273: IF (is_debug) THEN
1274: print_debug('p_allow_partial_pick is false and could not reserve the quantity requested'
1275: , 'Inv-Pick_Release_PVT.Process_Reservations');
1276: END IF;
1277: fnd_message.set_name('INV', 'INV_COULD_NOT_PICK_FULL');
1278: fnd_msg_pub.ADD;
1279: RAISE fnd_api.g_exc_unexpected_error;
1280: END IF;
1281:

Line 1299: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

1295: );
1296:
1297: -- Return an error if the query reservations call failed
1298: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1299: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1300: fnd_msg_pub.ADD;
1301: RAISE fnd_api.g_exc_unexpected_error;
1302: END IF;
1303:

Line 1597: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');

1593: IF (is_debug) THEN
1594: print_debug('return error from get_pick_slip_number',
1595: 'Inv_Pick_Release_Pvt.Process_Unreservable_Items');
1596: END IF;
1597: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');
1598: fnd_msg_pub.ADD;
1599: RAISE fnd_api.g_exc_unexpected_error;
1600: END IF;
1601:

Line 1847: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');

1843: print_debug(l_message);
1844: END IF;
1845: end loop;
1846: end if;*/
1847: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1848: fnd_msg_pub.ADD;
1849: RAISE fnd_api.g_exc_unexpected_error;
1850: END IF; --success
1851: ELSE --no task/project

Line 1855: fnd_message.set_name('INV', 'INV_INT_LOCCODE');

1851: ELSE --no task/project
1852: IF (NVL(TO_NUMBER(l_locator.segment19), -1) <> NVL(p_mo_line_rec.project_id, -1)
1853: AND NVL(TO_NUMBER(l_locator.segment20), -1) <> NVL(p_mo_line_rec.task_id, -1)
1854: ) THEN
1855: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
1856: fnd_msg_pub.ADD;
1857: RAISE fnd_api.g_exc_error;
1858: END IF;
1859: END IF; --task project

Line 2168: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');

2164: print_debug('No data found-Delivery Info', 'Inv_Pick_Release_PVT.Process_Line');
2165: gmi_reservation_util.println('Process_LineNo data found-Delivery Info');
2166: END IF;
2167: ROLLBACK TO process_line_pvt;
2168: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
2169: fnd_msg_pub.ADD;
2170: RAISE fnd_api.g_exc_unexpected_error;
2171: END;
2172: IF (is_debug) THEN

Line 2215: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');

2211: IF (is_debug) THEN
2212: print_debug('No Mtl_Sales_Order ID found for oe header', 'Inv_Pick_Release_PVT.Process_Line');
2213: gmi_reservation_util.println('No Mtl_Sales_Order ID found for oe header');
2214: END IF;
2215: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
2216: fnd_msg_pub.ADD;
2217: RAISE fnd_api.g_exc_unexpected_error;
2218: END IF;
2219:

Line 2332: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');

2328: IF (is_debug) THEN
2329: print_debug('Error in Print Pick Slip', 'Inv_Pick_Release_PVT.Process_Line');
2330: END IF;
2331: ROLLBACK TO process_line_pvt;
2332: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
2333: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
2334: fnd_msg_pub.ADD;
2335: RAISE fnd_api.g_exc_unexpected_error;
2336: END IF;

Line 2333: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));

2329: print_debug('Error in Print Pick Slip', 'Inv_Pick_Release_PVT.Process_Line');
2330: END IF;
2331: ROLLBACK TO process_line_pvt;
2332: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
2333: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
2334: fnd_msg_pub.ADD;
2335: RAISE fnd_api.g_exc_unexpected_error;
2336: END IF;
2337: END IF; -- ready to print

Line 2448: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');

2444: raise fnd_api.g_exc_unexpected_error;
2445: END IF;
2446: l_request_number := INV_CACHE.mtrh_rec.request_number;
2447:
2448: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2449: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2450: fnd_message.set_token('MO_NUMBER', l_request_number);
2451: fnd_msg_pub.ADD;
2452: RAISE fnd_api.g_exc_unexpected_error;

Line 2449: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));

2445: END IF;
2446: l_request_number := INV_CACHE.mtrh_rec.request_number;
2447:
2448: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2449: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2450: fnd_message.set_token('MO_NUMBER', l_request_number);
2451: fnd_msg_pub.ADD;
2452: RAISE fnd_api.g_exc_unexpected_error;
2453: END IF;

Line 2450: fnd_message.set_token('MO_NUMBER', l_request_number);

2446: l_request_number := INV_CACHE.mtrh_rec.request_number;
2447:
2448: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2449: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2450: fnd_message.set_token('MO_NUMBER', l_request_number);
2451: fnd_msg_pub.ADD;
2452: RAISE fnd_api.g_exc_unexpected_error;
2453: END IF;
2454:

Line 2522: fnd_message.set_name('INV', 'INV_COULD_NOT_PICK_FULL');

2518: IF (is_debug) THEN
2519: print_debug('Error - could not pick full', 'Inv_Pick_Release_PVT.Process_Line');
2520: END IF;
2521: ROLLBACK TO process_line_pvt;
2522: fnd_message.set_name('INV', 'INV_COULD_NOT_PICK_FULL');
2523: fnd_msg_pub.ADD;
2524: RAISE fnd_api.g_exc_unexpected_error;
2525: ELSE
2526: -- Set a flag to later set the return status for success,

Line 2704: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

2700: IF (l_new_rsv_quantity = -99999) THEN
2701: IF (is_debug) THEN
2702: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
2703: END IF;
2704: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2705: fnd_message.set_token('UOM', l_primary_uom);
2706: fnd_message.set_token('ROUTINE', 'Pick Release process');
2707: fnd_msg_pub.ADD;
2708: RAISE fnd_api.g_exc_unexpected_error;

Line 2705: fnd_message.set_token('UOM', l_primary_uom);

2701: IF (is_debug) THEN
2702: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
2703: END IF;
2704: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2705: fnd_message.set_token('UOM', l_primary_uom);
2706: fnd_message.set_token('ROUTINE', 'Pick Release process');
2707: fnd_msg_pub.ADD;
2708: RAISE fnd_api.g_exc_unexpected_error;
2709: END IF;

Line 2706: fnd_message.set_token('ROUTINE', 'Pick Release process');

2702: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
2703: END IF;
2704: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2705: fnd_message.set_token('UOM', l_primary_uom);
2706: fnd_message.set_token('ROUTINE', 'Pick Release process');
2707: fnd_msg_pub.ADD;
2708: RAISE fnd_api.g_exc_unexpected_error;
2709: END IF;
2710: END IF;

Line 2810: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

2806: IF (l_new_rsv_quantity = -99999) THEN
2807: IF (is_debug) THEN
2808: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
2809: END IF;
2810: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2811: fnd_message.set_token('UOM', l_primary_uom);
2812: fnd_message.set_token('ROUTINE', 'Pick Release process');
2813: fnd_msg_pub.ADD;
2814: RAISE fnd_api.g_exc_unexpected_error;

Line 2811: fnd_message.set_token('UOM', l_primary_uom);

2807: IF (is_debug) THEN
2808: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
2809: END IF;
2810: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2811: fnd_message.set_token('UOM', l_primary_uom);
2812: fnd_message.set_token('ROUTINE', 'Pick Release process');
2813: fnd_msg_pub.ADD;
2814: RAISE fnd_api.g_exc_unexpected_error;
2815: END IF;

Line 2812: fnd_message.set_token('ROUTINE', 'Pick Release process');

2808: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
2809: END IF;
2810: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2811: fnd_message.set_token('UOM', l_primary_uom);
2812: fnd_message.set_token('ROUTINE', 'Pick Release process');
2813: fnd_msg_pub.ADD;
2814: RAISE fnd_api.g_exc_unexpected_error;
2815: END IF;
2816: END IF;

Line 2852: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');

2848: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2849: IF (is_debug) THEN
2850: print_debug('error in update reservation', 'Inv_Pick_Release_PVT.Process_Reservations');
2851: END IF;
2852: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
2853: fnd_msg_pub.ADD;
2854: RAISE fnd_api.g_exc_unexpected_error;
2855: END IF;
2856:

Line 3036: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

3032: IF (l_rsv_detailed_qty_conv = -99999) THEN
3033: IF (is_debug) THEN
3034: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_reservations');
3035: END IF;
3036: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3037: fnd_message.set_token('UOM', l_primary_uom);
3038: fnd_message.set_token('ROUTINE', 'Pick Release process');
3039: fnd_msg_pub.ADD;
3040: RAISE fnd_api.g_exc_unexpected_error;

Line 3037: fnd_message.set_token('UOM', l_primary_uom);

3033: IF (is_debug) THEN
3034: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_reservations');
3035: END IF;
3036: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3037: fnd_message.set_token('UOM', l_primary_uom);
3038: fnd_message.set_token('ROUTINE', 'Pick Release process');
3039: fnd_msg_pub.ADD;
3040: RAISE fnd_api.g_exc_unexpected_error;
3041: END IF;

Line 3038: fnd_message.set_token('ROUTINE', 'Pick Release process');

3034: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_reservations');
3035: END IF;
3036: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3037: fnd_message.set_token('UOM', l_primary_uom);
3038: fnd_message.set_token('ROUTINE', 'Pick Release process');
3039: fnd_msg_pub.ADD;
3040: RAISE fnd_api.g_exc_unexpected_error;
3041: END IF;
3042: END IF;

Line 3162: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');

3158: END IF;
3159:
3160: IF l_api_return_status <> fnd_api.g_ret_sts_success OR l_pick_slip_number = -1 THEN
3161: ROLLBACK TO process_line_pvt;
3162: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');
3163: fnd_msg_pub.ADD;
3164: RAISE fnd_api.g_exc_unexpected_error;
3165: END IF;
3166: IF ( l_pick_slip_mode <> 'I' ) THEN

Line 3243: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');

3239: , x_error_message => l_api_error_msg
3240: );
3241: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3242: ROLLBACK TO process_line_pvt;
3243: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
3244: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
3245: fnd_msg_pub.ADD;
3246: RAISE fnd_api.g_exc_unexpected_error;
3247: END IF;

Line 3244: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));

3240: );
3241: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3242: ROLLBACK TO process_line_pvt;
3243: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
3244: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
3245: fnd_msg_pub.ADD;
3246: RAISE fnd_api.g_exc_unexpected_error;
3247: END IF;
3248: END IF;