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_RCV_STD_DELIVER_APIS dependencies on FND_MSG_PUB

Line 1404: fnd_msg_pub.ADD;

1400: IF (l_debug = 1) THEN
1401: print_debug('populate_default_values 141 - trying to do transfer IN storage sub_type : ', 4);
1402: END IF;
1403: fnd_message.set_name('INV', 'INV_INVALID_SUB_TXN_COMBO');
1404: fnd_msg_pub.ADD;
1405: RAISE fnd_api.g_exc_error;
1406: END IF;
1407: END IF;
1408:

Line 1653: fnd_msg_pub.ADD;

1649: inv_rcv_common_apis.init_startup_values(p_organization_id);
1650: EXCEPTION
1651: WHEN NO_DATA_FOUND THEN
1652: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1653: fnd_msg_pub.ADD;
1654: RAISE;
1655: END;
1656:
1657: l_progress := '20';

Line 1717: fnd_msg_pub.ADD;

1713:
1714: -- x_status is not successful if there is any execution error in matching.
1715: IF x_status <> fnd_api.g_ret_sts_success THEN
1716: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1717: fnd_msg_pub.ADD;
1718:
1719: IF (l_debug = 1) THEN
1720: print_debug('Exiting create_osp_po_rcvtxn_intf_rec 20:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1721: END IF;

Line 1730: fnd_msg_pub.ADD;

1726: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
1727: x_status := fnd_api.g_ret_sts_error;
1728: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
1729: fnd_message.set_name('INV', l_err_message);
1730: fnd_msg_pub.ADD;
1731:
1732: IF (l_debug = 1) THEN
1733: print_debug('exiting create_osp_po_rcvtxn_intf_rec 30:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1734: END IF;

Line 1765: fnd_msg_pub.ADD;

1761: END LOOP;
1762:
1763: IF l_err_message <> '@@@' THEN
1764: fnd_message.set_name(l_msg_prod, l_err_message);
1765: fnd_msg_pub.ADD;
1766:
1767: IF (l_debug = 1) THEN
1768: print_debug('adding tolerance message create_osp_po_rcvtxn_intf_rec 40:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1769: END IF;

Line 1858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

1854: IF SQLCODE IS NOT NULL THEN
1855: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_po_rcvtxn_intf_rec', l_progress, SQLCODE);
1856: END IF;
1857:
1858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1859: END create_osp_po_rcvtxn_intf_rec;
1860:
1861: PROCEDURE create_po_rcvtxn_intf_rec(
1862: p_organization_id IN NUMBER

Line 2149: fnd_msg_pub.ADD;

2145: inv_rcv_common_apis.init_startup_values(p_organization_id);
2146: EXCEPTION
2147: WHEN NO_DATA_FOUND THEN
2148: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2149: fnd_msg_pub.ADD;
2150: RAISE;
2151: END;
2152:
2153: l_progress := '20';

Line 2252: fnd_msg_pub.ADD;

2248:
2249: -- x_status is not successful if there is any execution error in matching.
2250: IF x_status <> fnd_api.g_ret_sts_success THEN
2251: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2252: fnd_msg_pub.ADD;
2253:
2254: IF (l_debug = 1) THEN
2255: print_debug('Exiting create_po_rcvtxn_intf_rec 20:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2256: END IF;

Line 2265: fnd_msg_pub.ADD;

2261: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
2262: x_status := fnd_api.g_ret_sts_error;
2263: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
2264: fnd_message.set_name('INV', l_err_message);
2265: fnd_msg_pub.ADD;
2266:
2267: IF (l_debug = 1) THEN
2268: print_debug('exiting create_po_rcvtxn_intf_rec 30:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2269: END IF;

Line 2300: fnd_msg_pub.ADD;

2296: END LOOP;
2297:
2298: IF l_err_message <> '@@@' THEN
2299: fnd_message.set_name(l_msg_prod, l_err_message);
2300: fnd_msg_pub.ADD;
2301:
2302: IF (l_debug = 1) THEN
2303: print_debug('adding tolerance message create_po_rcvtxn_intf_rec 40:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2304: END IF;

Line 2643: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

2639: IF SQLCODE IS NOT NULL THEN
2640: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_po_rcvtxn_intf_rec', l_progress, SQLCODE);
2641: END IF;
2642:
2643: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2644: END create_po_rcvtxn_intf_rec;
2645:
2646: PROCEDURE create_int_shp_rcvtxn_intf_rec(
2647: p_organization_id IN NUMBER

Line 2830: fnd_msg_pub.ADD;

2826: /*End bug 4158984*/
2827: EXCEPTION
2828: WHEN NO_DATA_FOUND THEN
2829: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2830: fnd_msg_pub.ADD;
2831: RAISE;
2832: END;
2833:
2834: l_progress := '20';

Line 2947: fnd_msg_pub.ADD;

2943:
2944: -- x_status is not successful if there is any execution error in matching.
2945: IF x_status <> fnd_api.g_ret_sts_success THEN
2946: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2947: fnd_msg_pub.ADD;
2948:
2949: IF (l_debug = 1) THEN
2950: print_debug('Exiting create_int_shp_rcvtxn_intf_rec 20:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2951: END IF;

Line 2962: fnd_msg_pub.ADD;

2958: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
2959: x_status := fnd_api.g_ret_sts_error;
2960: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
2961: fnd_message.set_name('INV', l_err_message);
2962: fnd_msg_pub.ADD;
2963:
2964: IF (l_debug = 1) THEN
2965: print_debug('exiting create_int_shp_rcvtxn_intf_rec 30:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2966: END IF;

Line 2997: fnd_msg_pub.ADD;

2993: END LOOP;
2994:
2995: IF l_err_message <> '@@@' THEN
2996: fnd_message.set_name(l_msg_prod, l_err_message);
2997: fnd_msg_pub.ADD;
2998:
2999: IF (l_debug = 1) THEN
3000: print_debug('adding tolerance message create_int_shp_rcvtxn_intf_rec 40:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3001: END IF;

Line 3312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

3308: IF SQLCODE IS NOT NULL THEN
3309: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_int_shp_rcvtxn_intf_rec', l_progress, SQLCODE);
3310: END IF;
3311:
3312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3313: END create_int_shp_rcvtxn_intf_rec;
3314:
3315: PROCEDURE create_rma_rcvtxn_intf_rec(
3316: p_organization_id IN NUMBER

Line 3489: fnd_msg_pub.ADD;

3485: inv_rcv_common_apis.init_startup_values(p_organization_id);
3486: EXCEPTION
3487: WHEN NO_DATA_FOUND THEN
3488: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3489: fnd_msg_pub.ADD;
3490: RAISE;
3491: END;
3492:
3493: l_progress := '20';

Line 3578: fnd_msg_pub.ADD;

3574:
3575: -- x_status is not successful if there is any execution error in matching.
3576: IF x_status <> fnd_api.g_ret_sts_success THEN
3577: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3578: fnd_msg_pub.ADD;
3579:
3580: IF (l_debug = 1) THEN
3581: print_debug('Exiting create_rma_rcvtxn_intf_rec 20:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3582: END IF;

Line 3591: fnd_msg_pub.ADD;

3587: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
3588: x_status := fnd_api.g_ret_sts_error;
3589: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
3590: fnd_message.set_name('INV', l_err_message);
3591: fnd_msg_pub.ADD;
3592:
3593: IF (l_debug = 1) THEN
3594: print_debug('exiting create_rma_rcvtxn_intf_rec 30:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3595: END IF;

Line 3626: fnd_msg_pub.ADD;

3622: END LOOP;
3623:
3624: IF l_err_message <> '@@@' THEN
3625: fnd_message.set_name(l_msg_prod, l_err_message);
3626: fnd_msg_pub.ADD;
3627:
3628: IF (l_debug = 1) THEN
3629: print_debug('adding tolerance message create_rma_rcvtxn_intf_rec 40:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3630: END IF;

Line 3877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

3873: IF SQLCODE IS NOT NULL THEN
3874: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rma_rcvtxn_intf_rec', l_progress, SQLCODE);
3875: END IF;
3876:
3877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3878: END create_rma_rcvtxn_intf_rec;
3879:
3880: PROCEDURE create_rpt_num_rcvtxn_intf_rec(
3881: p_organization_id IN NUMBER

Line 3967: fnd_msg_pub.ADD;

3963: );
3964:
3965: IF x_status = fnd_api.g_ret_sts_error THEN
3966: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3967: fnd_msg_pub.ADD;
3968:
3969: IF (l_debug = 1) THEN
3970: print_debug('create_rpt_num_rcvtxn_intf_rec 20.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3971: END IF;

Line 3978: fnd_msg_pub.ADD;

3974: END IF;
3975:
3976: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
3977: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3978: fnd_msg_pub.ADD;
3979:
3980: IF (l_debug = 1) THEN
3981: print_debug('create_rpt_num_rcvtxn_intf_rec 20.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3982: END IF;

Line 4018: fnd_msg_pub.ADD;

4014: );
4015:
4016: IF x_status = fnd_api.g_ret_sts_error THEN
4017: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4018: fnd_msg_pub.ADD;
4019:
4020: IF (l_debug = 1) THEN
4021: print_debug('create_rpt_num_rcvtxn_intf_rec 30.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4022: END IF;

Line 4029: fnd_msg_pub.ADD;

4025: END IF;
4026:
4027: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4028: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4029: fnd_msg_pub.ADD;
4030:
4031: IF (l_debug = 1) THEN
4032: print_debug('create_rpt_num_rcvtxn_intf_rec 30.2: FND_API.G_EXC_UNEXPECTED_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4033: END IF;

Line 4069: fnd_msg_pub.ADD;

4065: );
4066:
4067: IF x_status = fnd_api.g_ret_sts_error THEN
4068: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4069: fnd_msg_pub.ADD;
4070:
4071: IF (l_debug = 1) THEN
4072: print_debug('create_rpt_num_rcvtxn_intf_rec 40.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4073: END IF;

Line 4080: fnd_msg_pub.ADD;

4076: END IF;
4077:
4078: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4079: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4080: fnd_msg_pub.ADD;
4081:
4082: IF (l_debug = 1) THEN
4083: print_debug('create_rpt_num_rcvtxn_intf_rec 40.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4084: END IF;

Line 4103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4099: IF l_curs_rcvtxn_detail%ISOPEN THEN
4100: CLOSE l_curs_rcvtxn_detail;
4101: END IF;
4102:
4103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4104: WHEN fnd_api.g_exc_unexpected_error THEN
4105: x_status := fnd_api.g_ret_sts_unexp_error;
4106:
4107: IF l_curs_rcvtxn_detail%ISOPEN THEN

Line 4111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4107: IF l_curs_rcvtxn_detail%ISOPEN THEN
4108: CLOSE l_curs_rcvtxn_detail;
4109: END IF;
4110:
4111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4112: WHEN OTHERS THEN
4113: x_status := fnd_api.g_ret_sts_unexp_error;
4114:
4115: IF l_curs_rcvtxn_detail%ISOPEN THEN

Line 4123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4119: IF SQLCODE IS NOT NULL THEN
4120: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rpt_num_rcvtxn_intf_rec', l_progress, SQLCODE);
4121: END IF;
4122:
4123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4124: END;
4125:
4126: PROCEDURE create_osp_std_rcvtxn_intf_rec(
4127: p_organization_id IN NUMBER

Line 4219: fnd_msg_pub.ADD;

4215: );
4216:
4217: IF x_status = fnd_api.g_ret_sts_error THEN
4218: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4219: fnd_msg_pub.ADD;
4220:
4221: IF (l_debug = 1) THEN
4222: print_debug('create_osp_std_rcvtxn_intf_rec 20.1: create_osp_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4223: END IF;

Line 4230: fnd_msg_pub.ADD;

4226: END IF;
4227:
4228: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4229: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4230: fnd_msg_pub.ADD;
4231:
4232: IF (l_debug = 1) THEN
4233: print_debug('create_osp_std_rcvtxn_intf_rec 20.2: create_osp_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4234: END IF;

Line 4280: fnd_msg_pub.ADD;

4276: );
4277:
4278: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4279: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4280: fnd_msg_pub.ADD;
4281: x_status := 'W';
4282:
4283: IF (l_debug = 1) THEN
4284: print_debug('create_osp_std_rcpt_intf_rec 8.2: inv_label.print_label FAILED;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4293: END IF; --END IF check ret status
4294: EXCEPTION
4295: WHEN fnd_api.g_exc_error THEN
4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4301: WHEN OTHERS THEN

Line 4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4301: WHEN OTHERS THEN
4302: x_status := fnd_api.g_ret_sts_unexp_error;
4303:
4304: IF SQLCODE IS NOT NULL THEN

Line 4308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4304: IF SQLCODE IS NOT NULL THEN
4305: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4306: END IF;
4307:
4308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4309: END create_osp_std_rcvtxn_intf_rec;
4310:
4311: PROCEDURE create_std_rcvtxn_intf_rec(
4312: p_organization_id IN NUMBER

Line 4442: fnd_msg_pub.ADD;

4438: );
4439:
4440: IF x_status = fnd_api.g_ret_sts_error THEN
4441: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4442: fnd_msg_pub.ADD;
4443:
4444: IF (l_debug = 1) THEN
4445: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4446: END IF;

Line 4453: fnd_msg_pub.ADD;

4449: END IF;
4450:
4451: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4452: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4453: fnd_msg_pub.ADD;
4454:
4455: IF (l_debug = 1) THEN
4456: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4457: END IF;

Line 4539: fnd_msg_pub.ADD;

4535: );
4536:
4537: IF x_status = fnd_api.g_ret_sts_error THEN
4538: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4539: fnd_msg_pub.ADD;
4540:
4541: IF (l_debug = 1) THEN
4542: print_debug('create_std_rcvtxn_intf_rec 40.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4543: END IF;

Line 4550: fnd_msg_pub.ADD;

4546: END IF;
4547:
4548: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4549: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4550: fnd_msg_pub.ADD;
4551:
4552: IF (l_debug = 1) THEN
4553: print_debug('create_std_rcvtxn_intf_rec 40.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4554: END IF;

Line 4592: fnd_msg_pub.ADD;

4588: );
4589:
4590: IF x_status = fnd_api.g_ret_sts_error THEN
4591: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4592: fnd_msg_pub.ADD;
4593:
4594: IF (l_debug = 1) THEN
4595: print_debug('create_std_rcvtxn_intf_rec 50.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4596: END IF;

Line 4603: fnd_msg_pub.ADD;

4599: END IF;
4600:
4601: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4602: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4603: fnd_msg_pub.ADD;
4604:
4605: IF (l_debug = 1) THEN
4606: print_debug('create_std_rcvtxn_intf_rec 50.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4607: END IF;

Line 4653: fnd_msg_pub.ADD;

4649: );
4650:
4651: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4652: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4653: fnd_msg_pub.ADD;
4654: x_status := 'W';
4655:
4656: IF (l_debug = 1) THEN
4657: print_debug('create_std_rcpt_intf_rec 8.2: inv_label.print_label FAILED;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4665: END IF; --END IF check ret status
4666: EXCEPTION
4667: WHEN fnd_api.g_exc_error THEN
4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4673: WHEN OTHERS THEN

Line 4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4673: WHEN OTHERS THEN
4674: x_status := fnd_api.g_ret_sts_unexp_error;
4675:
4676: IF SQLCODE IS NOT NULL THEN

Line 4680: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4676: IF SQLCODE IS NOT NULL THEN
4677: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4678: END IF;
4679:
4680: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4681: END create_std_rcvtxn_intf_rec;
4682:
4683: /* FP-J Lot/Serial Support Enhancement
4684: * Added two new parameters p_transfer_lpn_id and p_lot_number

Line 4870: fnd_msg_pub.ADD;

4866: );
4867:
4868: IF x_return_status = fnd_api.g_ret_sts_error THEN
4869: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4870: fnd_msg_pub.ADD;
4871:
4872: IF (l_debug = 1) THEN
4873: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4874: END IF;

Line 4881: fnd_msg_pub.ADD;

4877: END IF;
4878:
4879: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4880: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4881: fnd_msg_pub.ADD;
4882:
4883: IF (l_debug = 1) THEN
4884: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4885: END IF;

Line 4926: fnd_msg_pub.ADD;

4922: );
4923:
4924: IF x_return_status = fnd_api.g_ret_sts_error THEN
4925: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4926: fnd_msg_pub.ADD;
4927:
4928: IF (l_debug = 1) THEN
4929: print_debug('create_std_rcvtxn_intf_rec 30.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4930: END IF;

Line 4937: fnd_msg_pub.ADD;

4933: END IF;
4934:
4935: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4936: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4937: fnd_msg_pub.ADD;
4938:
4939: IF (l_debug = 1) THEN
4940: print_debug('create_std_rcvtxn_intf_rec 30.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4941: END IF;

Line 4982: fnd_msg_pub.ADD;

4978: );
4979:
4980: IF x_return_status = fnd_api.g_ret_sts_error THEN
4981: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4982: fnd_msg_pub.ADD;
4983:
4984: IF (l_debug = 1) THEN
4985: print_debug('create_std_rcvtxn_intf_rec 40.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4986: END IF;

Line 4993: fnd_msg_pub.ADD;

4989: END IF;
4990:
4991: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4992: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4993: fnd_msg_pub.ADD;
4994:
4995: IF (l_debug = 1) THEN
4996: print_debug('create_std_rcvtxn_intf_rec 40.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4997: END IF;

Line 5047: fnd_msg_pub.ADD;

5043:
5044: /* End of Change */
5045: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5046: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
5047: fnd_msg_pub.ADD;
5048: x_return_status := 'W';
5049: IF (l_debug = 1) THEN
5050: print_debug('create_std_rcpt_intf_rec 8.2: inv_label.print_label FAILED;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5051: END IF;

Line 5062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5058: END IF; --END IF check ret status
5059: EXCEPTION
5060: WHEN fnd_api.g_exc_error THEN
5061: x_return_status := fnd_api.g_ret_sts_error;
5062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5063: IF (l_debug = 1) THEN
5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5065: END IF;
5066: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5065: END IF;
5066: WHEN fnd_api.g_exc_unexpected_error THEN
5067: x_return_status := fnd_api.g_ret_sts_unexp_error;
5068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5069: IF (l_debug = 1) THEN
5070: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);
5071: END IF;
5072: WHEN OTHERS THEN

Line 5082: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5078: IF SQLCODE IS NOT NULL THEN
5079: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
5080: END IF;
5081:
5082: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5083: END create_putaway_rcvtxn_intf_rec;
5084:
5085: PROCEDURE rcvtxn_clear_global IS
5086: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5155: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5151: IF SQLCODE IS NOT NULL THEN
5152: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);
5153: END IF;
5154:
5155: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5156:
5157: IF (l_debug = 1) THEN
5158: print_debug('Exception in update_rcv_serials_supply 50' || SQLCODE || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5159: END IF;

Line 5231: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

5227: ,p_sec_qty => p_secondary_quantity
5228: );
5229:
5230: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5231: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
5232: IF (l_debug = 1) THEN
5233: print_debug('insert_mtli_helper: Error occurred while creating interface lots: ' || l_msg_data,1);
5234: END IF;
5235: RETURN FALSE;

Line 5297: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

5293: , p_att_exist => l_yes
5294: , p_update_msn => l_no);
5295:
5296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5297: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
5298: IF (l_debug = 1) THEN
5299: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
5300: END IF;
5301: RETURN FALSE;

Line 5859: fnd_msg_pub.ADD;

5855: IF (l_debug = 1) THEN
5856: print_debug('REFERENCE INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
5857: END IF;
5858: fnd_message.set_name('INV', 'INV_FAILED');
5859: fnd_msg_pub.ADD;
5860: RAISE fnd_api.g_exc_error;
5861: END IF;
5862:
5863: IF (l_debug = 1) THEN

Line 5923: fnd_msg_pub.ADD;

5919: END IF;
5920:
5921: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5922: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5923: fnd_msg_pub.ADD;
5924: RAISE fnd_api.g_exc_unexpected_error;
5925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5926: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5927: fnd_msg_pub.ADD;

Line 5927: fnd_msg_pub.ADD;

5923: fnd_msg_pub.ADD;
5924: RAISE fnd_api.g_exc_unexpected_error;
5925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5926: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5927: fnd_msg_pub.ADD;
5928: RAISE fnd_api.g_exc_error;
5929: END IF;
5930:
5931: <>

Line 5949: fnd_msg_pub.ADD;

5945: END IF;
5946:
5947: -- Unable to match RS with quantity.
5948: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5949: fnd_msg_pub.ADD;
5950: RAISE FND_API.g_exc_error;
5951:
5952: END IF;
5953:

Line 6048: fnd_msg_pub.ADD;

6044: IF (l_debug = 1) THEN
6045: print_debug('REF INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
6046: END IF;
6047: fnd_message.set_name('INV', 'INV_FAILED');
6048: fnd_msg_pub.ADD;
6049: RAISE fnd_api.g_exc_error;
6050: END IF;
6051:
6052: IF (l_debug = 1) THEN

Line 6077: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

6073: RAISE fnd_api.g_exc_unexpected_error;
6074: END IF; -- END IF check l_result
6075:
6076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6077: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
6078: IF (l_debug = 1) THEN
6079: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
6080: END IF;
6081: RAISE fnd_api.g_exc_error;

Line 6172: fnd_msg_pub.ADD;

6168: print_debug('l_avail_qty: ' || l_avail_qty, 1);
6169: print_debug('Avaiable Qty is less than Txn Qty ' , 1);
6170: END IF;
6171: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6172: fnd_msg_pub.ADD;
6173: RAISE fnd_api.g_exc_error;
6174: END IF;
6175:
6176: IF (l_rti_tb(k)(l).quantity < l_remaining_prim_qty) THEN

Line 6325: fnd_msg_pub.ADD;

6321: END IF;
6322:
6323: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6324: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6325: fnd_msg_pub.ADD;
6326: RAISE fnd_api.g_exc_unexpected_error;
6327: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6328: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6329: fnd_msg_pub.ADD;

Line 6329: fnd_msg_pub.ADD;

6325: fnd_msg_pub.ADD;
6326: RAISE fnd_api.g_exc_unexpected_error;
6327: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6328: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6329: fnd_msg_pub.ADD;
6330: RAISE fnd_api.g_exc_error;
6331: END IF;
6332:
6333: l := l_rti_tb(k).next(l);

Line 6349: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6345: EXCEPTION
6346: WHEN fnd_api.g_exc_error THEN
6347: rollback to create_rti_ss;
6348: x_return_status := fnd_api.g_ret_sts_error;
6349: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6350: IF (l_debug = 1) THEN
6351: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6352: END IF;
6353:

Line 6357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6353:
6354: WHEN fnd_api.g_exc_unexpected_error THEN
6355: rollback to create_rti_ss;
6356: x_return_status := fnd_api.g_ret_sts_unexp_error;
6357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6358: IF (l_debug = 1) THEN
6359: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6360: END IF;
6361:

Line 6370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6366: IF SQLCODE IS NOT NULL THEN
6367: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
6368: END IF;
6369:
6370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6371: END Match_putaway_rcvtxn_intf_rec ;
6372:
6373: END inv_rcv_std_deliver_apis;