DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on FND_MESSAGE

Line 592: fnd_message.set_name('PO', 'PO_CPO_NO_RATE_FOR_DATE');

588: END IF;
589:
590: -- Give error message to user that no rate has been found
591: IF l_rate IS NULL THEN
592: fnd_message.set_name('PO', 'PO_CPO_NO_RATE_FOR_DATE');
593: fnd_msg_pub.add;
594: IF (l_debug = 1) THEN
595: print_debug('insert_txn_interface: No Conversion rate has been defined for the currency : ' || l_rcv_transaction_rec.currency_code || ' for the txn date : ' || l_rcv_transaction_rec.currency_conversion_date , 4);
596: END IF;

Line 1813: fnd_message.set_name('INV', 'INV_RCV_PARAM');

1809: BEGIN
1810: inv_rcv_common_apis.init_startup_values(p_organization_id);
1811: EXCEPTION
1812: WHEN NO_DATA_FOUND THEN
1813: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1814: fnd_msg_pub.ADD;
1815: RAISE fnd_api.g_exc_error;
1816: END;
1817:

Line 1963: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

1959: END IF;
1960:
1961: -- x_status is not successful if there is any execution error in matching.
1962: IF l_return_status = fnd_api.g_ret_sts_error THEN
1963: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1964: fnd_msg_pub.ADD;
1965:
1966: IF (l_debug = 1) THEN
1967: print_debug('create_po_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 1974: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

1970: RAISE fnd_api.g_exc_error;
1971: END IF;
1972:
1973: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1974: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1975: fnd_msg_pub.ADD;
1976:
1977: IF (l_debug = 1) THEN
1978: print_debug('Exiting create_po_rcpt_intf_rec 60.2: Unexpect error calling matching'

Line 1988: fnd_message.set_name('INV', l_err_message);

1984: END IF;
1985:
1986: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
1987: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
1988: fnd_message.set_name('INV', l_err_message);
1989: fnd_msg_pub.ADD;
1990:
1991: IF (l_debug = 1) THEN
1992: print_debug('create_po_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 2027: fnd_message.set_name(l_msg_prod, l_err_message);

2023: END IF;
2024: END LOOP;
2025:
2026: IF l_err_message <> '@@@' THEN
2027: fnd_message.set_name(l_msg_prod, l_err_message);
2028: fnd_msg_pub.ADD;
2029:
2030: IF (l_debug = 1) THEN
2031: print_debug(

Line 2788: fnd_message.set_name('INV', 'INV_RCV_PARAM');

2784:
2785: inv_rcv_common_apis.init_startup_values(p_organization_id);
2786: EXCEPTION
2787: WHEN NO_DATA_FOUND THEN
2788: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2789: fnd_msg_pub.ADD;
2790: RAISE fnd_api.g_exc_error;
2791: END;
2792:

Line 2969: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

2965: END IF;
2966:
2967: -- x_status is not successful if there is any execution error in matching.
2968: IF l_return_status = fnd_api.g_ret_sts_error THEN
2969: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2970: fnd_msg_pub.ADD;
2971:
2972: IF (l_debug = 1) THEN
2973: print_debug('create_intship_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 2980: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

2976: RAISE fnd_api.g_exc_error;
2977: END IF;
2978:
2979: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2980: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2981: fnd_msg_pub.ADD;
2982:
2983: IF (l_debug = 1) THEN
2984: print_debug('create_intship_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 2993: fnd_message.set_name('INV', l_err_message);

2989: END IF;
2990:
2991: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
2992: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
2993: fnd_message.set_name('INV', l_err_message);
2994: fnd_msg_pub.ADD;
2995:
2996: IF (l_debug = 1) THEN
2997: print_debug('create_intship_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3028: fnd_message.set_name(l_msg_prod, l_err_message);

3024: END IF;
3025: END LOOP;
3026:
3027: IF l_err_message <> '@@@' THEN
3028: fnd_message.set_name(l_msg_prod, l_err_message);
3029: fnd_msg_pub.ADD;
3030:
3031: IF (l_debug = 1) THEN
3032: print_debug('create_intship_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3533: fnd_message.set_name('INV', 'INV_RCV_PARAM');

3529: BEGIN
3530: inv_rcv_common_apis.init_startup_values(p_organization_id);
3531: EXCEPTION
3532: WHEN NO_DATA_FOUND THEN
3533: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3534: fnd_msg_pub.ADD;
3535: RAISE fnd_api.g_exc_error;
3536: END;
3537:

Line 3610: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

3606: print_debug('create_rma_rcpt_intf_rec: 40.3 - after matching l_msg_data = ' || l_msg_data, 4);
3607: END IF;
3608:
3609: IF l_return_status = fnd_api.g_ret_sts_error THEN
3610: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3611: fnd_msg_pub.ADD;
3612:
3613: IF (l_debug = 1) THEN
3614: print_debug('create_rma_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3621: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

3617: RAISE fnd_api.g_exc_error;
3618: END IF;
3619:
3620: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3621: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3622: fnd_msg_pub.ADD;
3623:
3624: IF (l_debug = 1) THEN
3625: print_debug('create_rma_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3633: fnd_message.set_name('INV', l_err_message);

3629: END IF;
3630:
3631: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
3632: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
3633: fnd_message.set_name('INV', l_err_message);
3634: fnd_msg_pub.ADD;
3635:
3636: IF (l_debug = 1) THEN
3637: print_debug('create_rma_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3668: fnd_message.set_name(l_msg_prod, l_err_message);

3664: END IF;
3665: END LOOP;
3666:
3667: IF l_err_message <> '@@@' THEN
3668: fnd_message.set_name(l_msg_prod, l_err_message);
3669: fnd_msg_pub.ADD;
3670:
3671: IF (l_debug = 1) THEN
3672: print_debug('create_rma_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4361: fnd_message.set_name('INV', 'INV_RCV_PARAM');

4357:
4358: inv_rcv_common_apis.init_startup_values(p_organization_id);
4359: EXCEPTION
4360: WHEN NO_DATA_FOUND THEN
4361: fnd_message.set_name('INV', 'INV_RCV_PARAM');
4362: fnd_msg_pub.ADD;
4363: RAISE fnd_api.g_exc_error;
4364: END;
4365:

Line 4571: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

4567: print_debug('create_asn_con_rcpt_intf_rec: 40.3 - after matching l_msg_data = ' || l_msg_data, 4);
4568: END IF;
4569:
4570: IF l_return_status = fnd_api.g_ret_sts_error THEN
4571: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
4572: fnd_msg_pub.ADD;
4573:
4574: IF (l_debug = 1) THEN
4575: print_debug('create_asn_con_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4582: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

4578: RAISE fnd_api.g_exc_error;
4579: END IF;
4580:
4581: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4582: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
4583: fnd_msg_pub.ADD;
4584:
4585: IF (l_debug = 1) THEN
4586: print_debug('create_asn_con_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 4595: fnd_message.set_name('INV', l_err_message);

4591: END IF;
4592:
4593: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
4594: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
4595: fnd_message.set_name('INV', l_err_message);
4596: fnd_msg_pub.ADD;
4597:
4598: IF (l_debug = 1) THEN
4599: print_debug('create_asn_con_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4630: fnd_message.set_name(l_msg_prod, l_err_message);

4626: END IF;
4627: END LOOP;
4628:
4629: IF l_err_message <> '@@@' THEN
4630: fnd_message.set_name(l_msg_prod, l_err_message);
4631: fnd_msg_pub.ADD;
4632:
4633: IF (l_debug = 1) THEN
4634: print_debug('create_asn_con_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 5275: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

5271: , x_msg_data => l_msg_data
5272: );
5273:
5274: IF l_return_status = fnd_api.g_ret_sts_error THEN
5275: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5276: fnd_msg_pub.ADD;
5277:
5278: IF (l_debug = 1) THEN
5279: print_debug(

Line 5289: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

5285: RAISE fnd_api.g_exc_error;
5286: END IF;
5287:
5288: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5289: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5290: fnd_msg_pub.ADD;
5291:
5292: IF (l_debug = 1) THEN
5293: print_debug(

Line 5349: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');

5345: ,p_to_uom_code => l_primary_uom_code);
5346:
5347: --Check for failure
5348: IF l_lot_prm_quantity = -99999 THEN
5349: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
5350: fnd_msg_pub.ADD;
5351: IF (l_debug = 1) THEN
5352: print_debug('create_asn_exp_rcpt_intf_rec: 20.2 - txn/primary uom conversion failed', 4);
5353: END IF;

Line 5572: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

5568: print_debug('after create_asn_con_rcpt_intf_rec: l_product_transaction_id: ' || l_product_transaction_id, 4);
5569: END IF;
5570:
5571: IF l_return_status = fnd_api.g_ret_sts_error THEN
5572: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5573: fnd_msg_pub.ADD;
5574:
5575: IF (l_debug = 1) THEN
5576: print_debug(

Line 5587: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

5583: RAISE fnd_api.g_exc_error;
5584: END IF;
5585:
5586: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5587: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5588: fnd_msg_pub.ADD;
5589:
5590: IF (l_debug = 1) THEN
5591: print_debug(

Line 5654: --fnd_message.clear;

5650: IF l_msni_count <> l_quantity THEN
5651: IF (l_debug = 1) THEN
5652: print_debug('create_asn_exp_rcpt_intf_rec: 62 quantity mismatch for serial numbers between RTI and MSNI', 4);
5653: END IF;
5654: --fnd_message.clear;
5655: --fnd_message.retrieve(l_fnd_msg_out);
5656: fnd_message.set_name('WMS', 'WMS_MISSING_SERIALS_EXP_RCPT');
5657: fnd_msg_pub.ADD;
5658:

Line 5655: --fnd_message.retrieve(l_fnd_msg_out);

5651: IF (l_debug = 1) THEN
5652: print_debug('create_asn_exp_rcpt_intf_rec: 62 quantity mismatch for serial numbers between RTI and MSNI', 4);
5653: END IF;
5654: --fnd_message.clear;
5655: --fnd_message.retrieve(l_fnd_msg_out);
5656: fnd_message.set_name('WMS', 'WMS_MISSING_SERIALS_EXP_RCPT');
5657: fnd_msg_pub.ADD;
5658:
5659: IF (l_debug = 1) THEN

Line 5656: fnd_message.set_name('WMS', 'WMS_MISSING_SERIALS_EXP_RCPT');

5652: print_debug('create_asn_exp_rcpt_intf_rec: 62 quantity mismatch for serial numbers between RTI and MSNI', 4);
5653: END IF;
5654: --fnd_message.clear;
5655: --fnd_message.retrieve(l_fnd_msg_out);
5656: fnd_message.set_name('WMS', 'WMS_MISSING_SERIALS_EXP_RCPT');
5657: fnd_msg_pub.ADD;
5658:
5659: IF (l_debug = 1) THEN
5660: print_debug(

Line 5704: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

5700: ,p_parent_lpn_id => NULL
5701: );
5702:
5703: IF l_return_status = fnd_api.g_ret_sts_error THEN
5704: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5705: fnd_msg_pub.ADD;
5706:
5707: IF (l_debug = 1) THEN
5708: print_debug('create_asn_exp_dd_intf_rec 50.2:create_asn_con_dd_intf_rec - RAISE FND_API.G_EXC_ERROR after insert_wlpni;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 5970: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

5966: , p_attribute15 => p_attribute15
5967: );
5968:
5969: IF l_return_status = fnd_api.g_ret_sts_error THEN
5970: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5971: fnd_msg_pub.ADD;
5972:
5973: IF (l_debug = 1) THEN
5974: print_debug(

Line 5985: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

5981: RAISE fnd_api.g_exc_error;
5982: END IF;
5983:
5984: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5985: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5986: fnd_msg_pub.ADD;
5987:
5988: IF (l_debug = 1) THEN
5989: print_debug(

Line 6052: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

6048: , p_attribute15 => p_attribute15
6049: );
6050:
6051: IF l_return_status = fnd_api.g_ret_sts_error THEN
6052: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6053: fnd_msg_pub.ADD;
6054:
6055: IF (l_debug = 1) THEN
6056: print_debug(

Line 6067: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

6063: RAISE fnd_api.g_exc_error;
6064: END IF;
6065:
6066: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6067: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6068: fnd_msg_pub.ADD;
6069:
6070: IF (l_debug = 1) THEN
6071: print_debug(

Line 6132: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

6128: , p_attribute15 => p_attribute15
6129: );
6130:
6131: IF l_return_status = fnd_api.g_ret_sts_error THEN
6132: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
6133: fnd_msg_pub.ADD;
6134:
6135: IF (l_debug = 1) THEN
6136: print_debug(

Line 6147: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

6143: RAISE fnd_api.g_exc_error;
6144: END IF;
6145:
6146: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6147: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
6148: fnd_msg_pub.ADD;
6149:
6150: IF (l_debug = 1) THEN
6151: print_debug(

Line 6208: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD

6204: , p_attribute15 => p_attribute15
6205: );
6206:
6207: IF l_return_status = fnd_api.g_ret_sts_error THEN
6208: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
6209: fnd_msg_pub.ADD;
6210:
6211: IF (l_debug = 1) THEN
6212: print_debug(

Line 6223: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD

6219: RAISE fnd_api.g_exc_error;
6220: END IF;
6221:
6222: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6223: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
6224: fnd_msg_pub.ADD;
6225:
6226: IF (l_debug = 1) THEN
6227: print_debug(

Line 6265: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

6261: , p_rcv_locator_id => p_rcv_locator_id
6262: );
6263:
6264: IF l_return_status = fnd_api.g_ret_sts_error THEN
6265: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6266: fnd_msg_pub.ADD;
6267:
6268: IF (l_debug = 1) THEN
6269: print_debug(

Line 6280: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

6276: RAISE fnd_api.g_exc_error;
6277: END IF;
6278:
6279: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6280: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6281: fnd_msg_pub.ADD;
6282:
6283: IF (l_debug = 1) THEN
6284: print_debug(

Line 6364: fnd_message.set_name('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD

6360: , p_express_transaction => NULL--Bug 5550783
6361: );
6362:
6363: IF l_return_status = fnd_api.g_ret_sts_error THEN
6364: fnd_message.set_name('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD
6365: fnd_msg_pub.ADD;
6366:
6367: IF (l_debug = 1) THEN
6368: print_debug(

Line 6379: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

6375: RAISE fnd_api.g_exc_error;
6376: END IF;
6377:
6378: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6379: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6380: fnd_msg_pub.ADD;
6381:
6382: IF (l_debug = 1) THEN
6383: print_debug(

Line 6448: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD

6444: print_debug('create_std_rcpt_intf_rec: 8.15 after inv_label.print_label ', 4);
6445: END IF;
6446:
6447: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6448: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
6449: fnd_msg_pub.ADD;
6450: x_status := 'W';
6451:
6452: IF (l_debug = 1) THEN

Line 7289: fnd_message.set_name('INV', 'INV_FAILED');

7285: END IF;
7286:
7287: IF (l_process_status = 'ERROR') THEN
7288: x_return_status := fnd_api.g_ret_sts_error;
7289: fnd_message.set_name('INV', 'INV_FAILED');
7290: fnd_msg_pub.ADD;
7291: RAISE fnd_api.g_exc_error;
7292: END IF;
7293: EXCEPTION

Line 7296: fnd_message.set_name('INV', 'INV_FAILED');

7292: END IF;
7293: EXCEPTION
7294: WHEN NO_DATA_FOUND THEN
7295: x_return_status := fnd_api.g_ret_sts_error;
7296: fnd_message.set_name('INV', 'INV_FAILED');
7297: fnd_msg_pub.ADD;
7298: RAISE fnd_api.g_exc_error;
7299: END;
7300:

Line 7796: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');

7792: , x_msg_data => l_msg_data
7793: );
7794:
7795: IF l_return_status = fnd_api.g_ret_sts_error THEN
7796: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');
7797: fnd_msg_pub.ADD;
7798:
7799: IF (l_debug = 1) THEN
7800: print_debug(

Line 7810: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');

7806: RAISE fnd_api.g_exc_error;
7807: END IF;
7808:
7809: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7810: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');
7811: fnd_msg_pub.ADD;
7812:
7813: IF (l_debug = 1) THEN
7814: print_debug(

Line 8006: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');

8002: print_debug('rcv_insert_update_header 20: after calling rcv_insert_header ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
8003: END IF;
8004:
8005: IF l_return_status = fnd_api.g_ret_sts_error THEN
8006: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');
8007: fnd_msg_pub.ADD;
8008:
8009: IF (l_debug = 1) THEN
8010: print_debug(

Line 8020: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');

8016: RAISE fnd_api.g_exc_error;
8017: END IF;
8018:
8019: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8020: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');
8021: fnd_msg_pub.ADD;
8022:
8023: IF (l_debug = 1) THEN
8024: print_debug(

Line 8103: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');

8099: print_debug('rcv_insert_update_header 40: after calling rcv_update_header ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
8100: END IF;
8101:
8102: IF l_return_status = fnd_api.g_ret_sts_error THEN
8103: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');
8104: fnd_msg_pub.ADD;
8105:
8106: IF (l_debug = 1) THEN
8107: print_debug(

Line 8117: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');

8113: RAISE fnd_api.g_exc_error;
8114: END IF;
8115:
8116: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8117: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');
8118: fnd_msg_pub.ADD;
8119:
8120: IF (l_debug = 1) THEN
8121: print_debug(

Line 8242: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');

8238:
8239: g_dummy_lpn_id := l_to_lpn_id;
8240:
8241: IF l_return_status = FND_API.g_ret_sts_error THEN
8242: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
8243: FND_MSG_PUB.ADD;
8244: IF (l_debug = 1) THEN
8245: print_debug('PackUnpack_Container 2.1: generate dummy LPN RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8246: END IF;

Line 8251: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');

8247: RAISE FND_API.G_EXC_ERROR;
8248: END IF;
8249:
8250: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8251: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
8252: FND_MSG_PUB.ADD;
8253: IF (l_debug = 1) THEN
8254: print_debug('PackUnpack_Container 2.2: generate dummy LPN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8255: END IF;

Line 8337: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD

8333: );
8334: l_progress := '40';
8335:
8336: IF l_return_status = fnd_api.g_ret_sts_error THEN
8337: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD
8338: fnd_msg_pub.ADD;
8339:
8340: IF (l_debug = 1) THEN
8341: print_debug(

Line 8352: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL');

8348: RAISE fnd_api.g_exc_error;
8349: END IF;
8350:
8351: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8352: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL');
8353: fnd_msg_pub.ADD;
8354:
8355: IF (l_debug = 1) THEN
8356: print_debug(

Line 8428: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD

8424: print_debug('PackUnpack_Container 8: after calling WMS_Container_PUB.PackUnpack_Container x_msg_data = '|| x_msg_data || ' ' || to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8425: END IF;
8426:
8427: IF l_return_status = FND_API.g_ret_sts_error THEN
8428: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD
8429: FND_MSG_PUB.ADD;
8430: IF (l_debug = 1) THEN
8431: print_debug('PackUnpack_Container 8.1: - Unpack - WMS_Container_PUB.PackUnpack_Container RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8432: END IF;

Line 8438: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL');

8434: END IF;
8435:
8436:
8437: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8438: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL');
8439: FND_MSG_PUB.ADD;
8440: IF (l_debug = 1) THEN
8441: print_debug('PackUnpack_Container 8.2: - Unpack - WMS_Container_PUB.PackUnpack_Container FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8442: END IF;

Line 9570: fnd_message.set_name('INV', 'INV_MAX_QTY');

9566: END;
9567:
9568: IF NVL(p_lot_primary_qty,0) <> 0 AND l_rlsu_primary_quantity <> 0 THEN
9569: IF p_lot_primary_qty > l_rlsu_primary_quantity THEN
9570: fnd_message.set_name('INV', 'INV_MAX_QTY');
9571: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity);
9572: fnd_msg_pub.add;
9573: IF (l_debug = 1) THEN
9574: print_debug('validate_lot_qty: 50 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);

Line 9571: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity);

9567:
9568: IF NVL(p_lot_primary_qty,0) <> 0 AND l_rlsu_primary_quantity <> 0 THEN
9569: IF p_lot_primary_qty > l_rlsu_primary_quantity THEN
9570: fnd_message.set_name('INV', 'INV_MAX_QTY');
9571: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity);
9572: fnd_msg_pub.add;
9573: IF (l_debug = 1) THEN
9574: print_debug('validate_lot_qty: 50 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);
9575: END IF;

Line 9705: fnd_message.set_name('INV', 'INV_MAX_QTY');

9701: print_debug('validate_lot_qty: 34 l_current_grp_prim_qty : ' || l_current_grp_prim_qty,4);
9702: END IF;
9703:
9704: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9705: fnd_message.set_name('INV', 'INV_MAX_QTY');
9706: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9707: fnd_msg_pub.add;
9708: x_return_status := fnd_api.g_ret_sts_error;
9709: IF (l_debug = 1) THEN

Line 9706: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));

9702: END IF;
9703:
9704: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9705: fnd_message.set_name('INV', 'INV_MAX_QTY');
9706: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9707: fnd_msg_pub.add;
9708: x_return_status := fnd_api.g_ret_sts_error;
9709: IF (l_debug = 1) THEN
9710: print_debug('validate_lot_qty: 33 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);

Line 9857: fnd_message.set_name('INV', 'INV_MAX_QTY');

9853: print_debug('validate_lot_qty: 34 l_current_grp_prim_qty : ' || l_current_grp_prim_qty,4);
9854: END IF;
9855:
9856: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9857: fnd_message.set_name('INV', 'INV_MAX_QTY');
9858: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9859: fnd_msg_pub.add;
9860: x_return_status := fnd_api.g_ret_sts_error;
9861: IF (l_debug = 1) THEN

Line 9858: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));

9854: END IF;
9855:
9856: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9857: fnd_message.set_name('INV', 'INV_MAX_QTY');
9858: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9859: fnd_msg_pub.add;
9860: x_return_status := fnd_api.g_ret_sts_error;
9861: IF (l_debug = 1) THEN
9862: print_debug('validate_lot_qty: 33 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);