DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on FND_MESSAGE

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

690: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
691: IF (is_debug) THEN
692: print_debug('return error from query reservation: '||l_api_return_status,'INV_Pick_Release_PVT.Process_Reservations');
693: END IF;
694: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
695: fnd_msg_pub.ADD;
696: RAISE fnd_api.g_exc_unexpected_error;
697: END IF;
698:

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

836: IF (l_quantity_to_detail = -99999) THEN
837: IF (is_debug) THEN
838: print_debug('Cannot convert uom to primary uom', 'Inv_Pick_release_pvt.process_reservations');
839: END IF;
840: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
841: fnd_message.set_token('UOM', l_primary_uom);
842: fnd_message.set_token('ROUTINE', 'Pick Release process');
843: fnd_msg_pub.ADD;
844: RAISE fnd_api.g_exc_unexpected_error;

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

837: IF (is_debug) THEN
838: print_debug('Cannot convert uom to primary uom', 'Inv_Pick_release_pvt.process_reservations');
839: END IF;
840: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
841: fnd_message.set_token('UOM', l_primary_uom);
842: fnd_message.set_token('ROUTINE', 'Pick Release process');
843: fnd_msg_pub.ADD;
844: RAISE fnd_api.g_exc_unexpected_error;
845: END IF;

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

838: print_debug('Cannot convert uom to primary uom', 'Inv_Pick_release_pvt.process_reservations');
839: END IF;
840: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
841: fnd_message.set_token('UOM', l_primary_uom);
842: fnd_message.set_token('ROUTINE', 'Pick Release process');
843: fnd_msg_pub.ADD;
844: RAISE fnd_api.g_exc_unexpected_error;
845: END IF;
846: ELSE

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

915: IF (l_order_line_qty = -99999) THEN
916: IF (is_debug) THEN
917: print_debug('Cannot convert order quantity to primary uom', 'Inv_Pick_release_pvt.process_reservations');
918: END IF;
919: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
920: fnd_message.set_token('UOM', l_primary_uom);
921: fnd_message.set_token('ROUTINE', 'Pick Release process');
922: fnd_msg_pub.ADD;
923: RAISE fnd_api.g_exc_unexpected_error;

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

916: IF (is_debug) THEN
917: print_debug('Cannot convert order quantity to primary uom', 'Inv_Pick_release_pvt.process_reservations');
918: END IF;
919: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
920: fnd_message.set_token('UOM', l_primary_uom);
921: fnd_message.set_token('ROUTINE', 'Pick Release process');
922: fnd_msg_pub.ADD;
923: RAISE fnd_api.g_exc_unexpected_error;
924: END IF;

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

917: print_debug('Cannot convert order quantity to primary uom', 'Inv_Pick_release_pvt.process_reservations');
918: END IF;
919: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
920: fnd_message.set_token('UOM', l_primary_uom);
921: fnd_message.set_token('ROUTINE', 'Pick Release process');
922: fnd_msg_pub.ADD;
923: RAISE fnd_api.g_exc_unexpected_error;
924: END IF;
925: ELSE

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

1049: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1050: IF (is_debug) THEN
1051: print_debug('Error from query quantity tree', 'Inv_Pick_Release_PVT.Process_Reservations');
1052: END IF;
1053: fnd_message.set_name('INV', 'INV_QRY_QTY_FAILED');
1054: fnd_msg_pub.ADD;
1055: RAISE fnd_api.g_exc_unexpected_error;
1056: END IF;
1057:

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

1132: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1133: IF (is_debug) THEN
1134: print_debug('error in update reservation', 'Inv_Pick_Release_PVT.Process_Reservations');
1135: END IF;
1136: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
1137: fnd_msg_pub.ADD;
1138: RAISE fnd_api.g_exc_unexpected_error;
1139: ELSE
1140: --Requery the reservation record and update it in the local table.

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

1156: );
1157:
1158: -- Return an error if the query reservations call failed
1159: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1160: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1161: fnd_msg_pub.ADD;
1162: RAISE fnd_api.g_exc_unexpected_error;
1163: END IF;
1164:

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

1215: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1216: IF (is_debug) THEN
1217: print_debug('Error from query quantity tree', 'Inv_Pick_Release_PVT.Process_Reservations');
1218: END IF;
1219: fnd_message.set_name('INV', 'INV_QRY_QTY_FAILED');
1220: fnd_msg_pub.ADD;
1221: RAISE fnd_api.g_exc_unexpected_error;
1222: END IF;
1223:

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

1254: IF (l_new_rsv_quantity = -99999) THEN
1255: IF (is_debug) THEN
1256: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1257: END IF;
1258: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1259: fnd_message.set_token('UOM', l_secondary_uom);
1260: fnd_message.set_token('ROUTINE', 'Pick Release process');
1261: fnd_msg_pub.ADD;
1262: RAISE fnd_api.g_exc_unexpected_error;

Line 1259: fnd_message.set_token('UOM', l_secondary_uom);

1255: IF (is_debug) THEN
1256: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1257: END IF;
1258: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1259: fnd_message.set_token('UOM', l_secondary_uom);
1260: fnd_message.set_token('ROUTINE', 'Pick Release process');
1261: fnd_msg_pub.ADD;
1262: RAISE fnd_api.g_exc_unexpected_error;
1263: END IF;

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

1256: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1257: END IF;
1258: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1259: fnd_message.set_token('UOM', l_secondary_uom);
1260: fnd_message.set_token('ROUTINE', 'Pick Release process');
1261: fnd_msg_pub.ADD;
1262: RAISE fnd_api.g_exc_unexpected_error;
1263: END IF;
1264: ELSE

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

1275: IF (l_new_rsv_quantity = -99999) THEN
1276: IF (is_debug) THEN
1277: print_debug('Cannot convert primary uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1278: END IF;
1279: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1280: fnd_message.set_token('UOM', l_primary_uom);
1281: fnd_message.set_token('ROUTINE', 'Pick Release process');
1282: fnd_msg_pub.ADD;
1283: RAISE fnd_api.g_exc_unexpected_error;

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

1276: IF (is_debug) THEN
1277: print_debug('Cannot convert primary uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1278: END IF;
1279: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1280: fnd_message.set_token('UOM', l_primary_uom);
1281: fnd_message.set_token('ROUTINE', 'Pick Release process');
1282: fnd_msg_pub.ADD;
1283: RAISE fnd_api.g_exc_unexpected_error;
1284: END IF;

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

1277: print_debug('Cannot convert primary uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
1278: END IF;
1279: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1280: fnd_message.set_token('UOM', l_primary_uom);
1281: fnd_message.set_token('ROUTINE', 'Pick Release process');
1282: fnd_msg_pub.ADD;
1283: RAISE fnd_api.g_exc_unexpected_error;
1284: END IF;
1285: END IF;

Line 1418: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-PRIMARY-UOM');

1414: );
1415:
1416: IF l_update_rsv_rec.reservation_quantity = -99999 THEN
1417: -- conversion failed
1418: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-PRIMARY-UOM');
1419: fnd_msg_pub.ADD;
1420: RAISE fnd_api.g_exc_error;
1421: END IF;
1422: END IF;

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

1448: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1449: IF (is_debug) THEN
1450: print_debug('error in create reservation', 'Inv_Pick_Release_PVT.Process_Reservations');
1451: END IF;
1452: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1453: fnd_msg_pub.ADD;
1454: RAISE fnd_api.g_exc_unexpected_error;
1455: END IF;
1456:

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

1461: IF (is_debug) THEN
1462: print_debug('p_allow_partial_pick is false and could not reserve the quantity requested'
1463: , 'Inv-Pick_Release_PVT.Process_Reservations');
1464: END IF;
1465: fnd_message.set_name('INV', 'INV_COULD_NOT_PICK_FULL');
1466: fnd_msg_pub.ADD;
1467: RAISE fnd_api.g_exc_unexpected_error;
1468: END IF;
1469:

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

1483: );
1484:
1485: -- Return an error if the query reservations call failed
1486: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1487: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
1488: fnd_msg_pub.ADD;
1489: RAISE fnd_api.g_exc_unexpected_error;
1490: END IF;
1491:

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

1880: IF (is_debug) THEN
1881: print_debug('return error from get_pick_slip_number',
1882: 'Inv_Pick_Release_Pvt.Process_Unreservable_Items');
1883: END IF;
1884: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');
1885: fnd_msg_pub.ADD;
1886: RAISE fnd_api.g_exc_unexpected_error;
1887: END IF;
1888:

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

2137: print_debug(l_message);
2138: END IF;
2139: end loop;
2140: end if;*/
2141: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
2142: fnd_msg_pub.ADD;
2143: RAISE fnd_api.g_exc_unexpected_error;
2144: END IF; --success
2145: ELSE --no task/project

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

2145: ELSE --no task/project
2146: IF (NVL(TO_NUMBER(l_locator.segment19), -1) <> NVL(p_mo_line_rec.project_id, -1)
2147: AND NVL(TO_NUMBER(l_locator.segment20), -1) <> NVL(p_mo_line_rec.task_id, -1)
2148: ) THEN
2149: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
2150: fnd_msg_pub.ADD;
2151: RAISE fnd_api.g_exc_error;
2152: END IF;
2153: END IF; --task project

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

2482: print_debug('No data found-Delivery Info', 'Inv_Pick_Release_PVT.Process_Line');
2483: gmi_reservation_util.println('Process_LineNo data found-Delivery Info');
2484: END IF;
2485: ROLLBACK TO process_line_pvt;
2486: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
2487: fnd_msg_pub.ADD;
2488: RAISE fnd_api.g_exc_unexpected_error;
2489: END;
2490: IF (is_debug) THEN

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

2529: IF (is_debug) THEN
2530: print_debug('No Mtl_Sales_Order ID found for oe header', 'Inv_Pick_Release_PVT.Process_Line');
2531: gmi_reservation_util.println('No Mtl_Sales_Order ID found for oe header');
2532: END IF;
2533: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
2534: fnd_msg_pub.ADD;
2535: RAISE fnd_api.g_exc_unexpected_error;
2536: END IF;
2537:

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

2646: IF (is_debug) THEN
2647: print_debug('Error in Print Pick Slip', 'Inv_Pick_Release_PVT.Process_Line');
2648: END IF;
2649: ROLLBACK TO process_line_pvt;
2650: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
2651: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
2652: fnd_msg_pub.ADD;
2653: RAISE fnd_api.g_exc_unexpected_error;
2654: END IF;

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

2647: print_debug('Error in Print Pick Slip', 'Inv_Pick_Release_PVT.Process_Line');
2648: END IF;
2649: ROLLBACK TO process_line_pvt;
2650: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
2651: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
2652: fnd_msg_pub.ADD;
2653: RAISE fnd_api.g_exc_unexpected_error;
2654: END IF;
2655: END IF; -- ready to print

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

2774: raise fnd_api.g_exc_unexpected_error;
2775: END IF;
2776: l_request_number := INV_CACHE.mtrh_rec.request_number;
2777:
2778: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2779: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2780: fnd_message.set_token('MO_NUMBER', l_request_number);
2781: fnd_msg_pub.ADD;
2782: RAISE fnd_api.g_exc_unexpected_error;

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

2775: END IF;
2776: l_request_number := INV_CACHE.mtrh_rec.request_number;
2777:
2778: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2779: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2780: fnd_message.set_token('MO_NUMBER', l_request_number);
2781: fnd_msg_pub.ADD;
2782: RAISE fnd_api.g_exc_unexpected_error;
2783: END IF;

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

2776: l_request_number := INV_CACHE.mtrh_rec.request_number;
2777:
2778: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
2779: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
2780: fnd_message.set_token('MO_NUMBER', l_request_number);
2781: fnd_msg_pub.ADD;
2782: RAISE fnd_api.g_exc_unexpected_error;
2783: END IF;
2784:

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

2848: IF (is_debug) THEN
2849: print_debug('Error - could not pick full', 'Inv_Pick_Release_PVT.Process_Line');
2850: END IF;
2851: ROLLBACK TO process_line_pvt;
2852: fnd_message.set_name('INV', 'INV_COULD_NOT_PICK_FULL');
2853: fnd_msg_pub.ADD;
2854: RAISE fnd_api.g_exc_unexpected_error;
2855: ELSE
2856: -- Set a flag to later set the return status for success,

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

2892: IF (is_debug) THEN
2893: print_debug('Error - could not pick full', 'Inv_Pick_Release_PVT.Process_Line');
2894: END IF;
2895: ROLLBACK TO process_line_pvt;
2896: fnd_message.set_name('INV', 'INV_COULD_NOT_PICK_FULL');
2897: fnd_msg_pub.ADD;
2898: RAISE fnd_api.g_exc_unexpected_error;
2899: ELSE
2900: -- Set a flag to later set the return status for success,

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

3089: IF (l_new_rsv_quantity = -99999) THEN
3090: IF (is_debug) THEN
3091: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3092: END IF;
3093: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3094: fnd_message.set_token('UOM', l_secondary_uom);
3095: fnd_message.set_token('ROUTINE', 'Pick Release process');
3096: fnd_msg_pub.ADD;
3097: RAISE fnd_api.g_exc_unexpected_error;

Line 3094: fnd_message.set_token('UOM', l_secondary_uom);

3090: IF (is_debug) THEN
3091: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3092: END IF;
3093: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3094: fnd_message.set_token('UOM', l_secondary_uom);
3095: fnd_message.set_token('ROUTINE', 'Pick Release process');
3096: fnd_msg_pub.ADD;
3097: RAISE fnd_api.g_exc_unexpected_error;
3098: END IF;

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

3091: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3092: END IF;
3093: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3094: fnd_message.set_token('UOM', l_secondary_uom);
3095: fnd_message.set_token('ROUTINE', 'Pick Release process');
3096: fnd_msg_pub.ADD;
3097: RAISE fnd_api.g_exc_unexpected_error;
3098: END IF;
3099: ELSE

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

3111: IF (l_new_rsv_quantity = -99999) THEN
3112: IF (is_debug) THEN
3113: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
3114: END IF;
3115: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3116: fnd_message.set_token('UOM', l_primary_uom);
3117: fnd_message.set_token('ROUTINE', 'Pick Release process');
3118: fnd_msg_pub.ADD;
3119: RAISE fnd_api.g_exc_unexpected_error;

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

3112: IF (is_debug) THEN
3113: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
3114: END IF;
3115: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3116: fnd_message.set_token('UOM', l_primary_uom);
3117: fnd_message.set_token('ROUTINE', 'Pick Release process');
3118: fnd_msg_pub.ADD;
3119: RAISE fnd_api.g_exc_unexpected_error;
3120: END IF;

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

3113: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
3114: END IF;
3115: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3116: fnd_message.set_token('UOM', l_primary_uom);
3117: fnd_message.set_token('ROUTINE', 'Pick Release process');
3118: fnd_msg_pub.ADD;
3119: RAISE fnd_api.g_exc_unexpected_error;
3120: END IF;
3121: END IF;

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

3230: IF (l_new_rsv_quantity = -99999) THEN
3231: IF (is_debug) THEN
3232: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3233: END IF;
3234: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3235: fnd_message.set_token('UOM', l_secondary_uom);
3236: fnd_message.set_token('ROUTINE', 'Pick Release process');
3237: fnd_msg_pub.ADD;
3238: RAISE fnd_api.g_exc_unexpected_error;

Line 3235: fnd_message.set_token('UOM', l_secondary_uom);

3231: IF (is_debug) THEN
3232: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3233: END IF;
3234: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3235: fnd_message.set_token('UOM', l_secondary_uom);
3236: fnd_message.set_token('ROUTINE', 'Pick Release process');
3237: fnd_msg_pub.ADD;
3238: RAISE fnd_api.g_exc_unexpected_error;
3239: END IF;

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

3232: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3233: END IF;
3234: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3235: fnd_message.set_token('UOM', l_secondary_uom);
3236: fnd_message.set_token('ROUTINE', 'Pick Release process');
3237: fnd_msg_pub.ADD;
3238: RAISE fnd_api.g_exc_unexpected_error;
3239: END IF;
3240: ELSE

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

3251: IF (l_new_rsv_quantity = -99999) THEN
3252: IF (is_debug) THEN
3253: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
3254: END IF;
3255: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3256: fnd_message.set_token('UOM', l_primary_uom);
3257: fnd_message.set_token('ROUTINE', 'Pick Release process');
3258: fnd_msg_pub.ADD;
3259: RAISE fnd_api.g_exc_unexpected_error;

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

3252: IF (is_debug) THEN
3253: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
3254: END IF;
3255: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3256: fnd_message.set_token('UOM', l_primary_uom);
3257: fnd_message.set_token('ROUTINE', 'Pick Release process');
3258: fnd_msg_pub.ADD;
3259: RAISE fnd_api.g_exc_unexpected_error;
3260: END IF;

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

3253: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_line');
3254: END IF;
3255: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3256: fnd_message.set_token('UOM', l_primary_uom);
3257: fnd_message.set_token('ROUTINE', 'Pick Release process');
3258: fnd_msg_pub.ADD;
3259: RAISE fnd_api.g_exc_unexpected_error;
3260: END IF;
3261: END IF;

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

3295: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3296: IF (is_debug) THEN
3297: print_debug('error in update reservation', 'Inv_Pick_Release_PVT.Process_Reservations');
3298: END IF;
3299: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
3300: fnd_msg_pub.ADD;
3301: RAISE fnd_api.g_exc_unexpected_error;
3302: END IF;
3303:

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

3486: IF (l_new_rsv_quantity = -99999) THEN
3487: IF (is_debug) THEN
3488: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3489: END IF;
3490: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3491: fnd_message.set_token('UOM', l_secondary_uom);
3492: fnd_message.set_token('ROUTINE', 'Pick Release process');
3493: fnd_msg_pub.ADD;
3494: RAISE fnd_api.g_exc_unexpected_error;

Line 3491: fnd_message.set_token('UOM', l_secondary_uom);

3487: IF (is_debug) THEN
3488: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3489: END IF;
3490: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3491: fnd_message.set_token('UOM', l_secondary_uom);
3492: fnd_message.set_token('ROUTINE', 'Pick Release process');
3493: fnd_msg_pub.ADD;
3494: RAISE fnd_api.g_exc_unexpected_error;
3495: END IF;

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

3488: print_debug('Cannot convert Seconday uom to rsv uom', 'Inv_Pick_release_pvt.process_reservations');
3489: END IF;
3490: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3491: fnd_message.set_token('UOM', l_secondary_uom);
3492: fnd_message.set_token('ROUTINE', 'Pick Release process');
3493: fnd_msg_pub.ADD;
3494: RAISE fnd_api.g_exc_unexpected_error;
3495: END IF;
3496: ELSE

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

3506: IF (l_rsv_detailed_qty_conv = -99999) THEN
3507: IF (is_debug) THEN
3508: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_reservations');
3509: END IF;
3510: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3511: fnd_message.set_token('UOM', l_primary_uom);
3512: fnd_message.set_token('ROUTINE', 'Pick Release process');
3513: fnd_msg_pub.ADD;
3514: RAISE fnd_api.g_exc_unexpected_error;

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

3507: IF (is_debug) THEN
3508: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_reservations');
3509: END IF;
3510: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3511: fnd_message.set_token('UOM', l_primary_uom);
3512: fnd_message.set_token('ROUTINE', 'Pick Release process');
3513: fnd_msg_pub.ADD;
3514: RAISE fnd_api.g_exc_unexpected_error;
3515: END IF;

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

3508: print_debug('Cannot convert primary uom to rsv uom','Inv_Pick_release_pvt.process_reservations');
3509: END IF;
3510: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3511: fnd_message.set_token('UOM', l_primary_uom);
3512: fnd_message.set_token('ROUTINE', 'Pick Release process');
3513: fnd_msg_pub.ADD;
3514: RAISE fnd_api.g_exc_unexpected_error;
3515: END IF;
3516: END IF;

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

3644: END IF;
3645:
3646: IF l_api_return_status <> fnd_api.g_ret_sts_success OR l_pick_slip_number = -1 THEN
3647: ROLLBACK TO process_line_pvt;
3648: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');
3649: fnd_msg_pub.ADD;
3650: RAISE fnd_api.g_exc_unexpected_error;
3651: END IF;
3652: IF ( l_pick_slip_mode <> 'I' ) THEN

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

3725: , x_error_message => l_api_error_msg
3726: );
3727: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3728: ROLLBACK TO process_line_pvt;
3729: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
3730: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
3731: fnd_msg_pub.ADD;
3732: RAISE fnd_api.g_exc_unexpected_error;
3733: END IF;

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

3726: );
3727: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3728: ROLLBACK TO process_line_pvt;
3729: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
3730: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
3731: fnd_msg_pub.ADD;
3732: RAISE fnd_api.g_exc_unexpected_error;
3733: END IF;
3734: END IF;