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

Line 252: fnd_msg_pub.ADD;

248: END IF;
249: fnd_message.set_name('INV','INV_PP_INPUT_LINE_NOTFOUND');
250: fnd_message.set_token
251: ('LINE_ID',fnd_number.number_to_canonical(p_move_order_line_id));
252: fnd_msg_pub.ADD;
253: CLOSE l_req_csr;
254: RAISE fnd_api.g_exc_error;
255: END IF;
256: CLOSE l_req_csr;

Line 505: FND_MSG_PUB.Add;

501: x_request_context.txn_header_id :=
502: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
503: IF x_request_context.txn_header_id IS NULL THEN
504: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
505: FND_MSG_PUB.Add;
506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;
508: --
509: --bug 1248138

Line 550: FND_MSG_PUB.Add;

546: x_request_context.txn_header_id :=
547: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
548: IF x_request_context.txn_header_id IS NULL THEN
549: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
550: FND_MSG_PUB.Add;
551: RAISE fnd_api.g_exc_unexpected_error;
552: END IF;
553: END IF;
554:

Line 767: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

763: --
764: -- debugging section
765: -- can be commented ut for final code
766: IF inv_pp_debug.is_debug_mode THEN
767: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
768: -- the message retrieved here since it is no longer on the stack
769: inv_pp_debug.set_last_error_message(Sqlerrm);
770: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
771: inv_pp_debug.send_last_error_message;

Line 791: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

787: --
788: -- debugging section
789: -- can be commented ut for final code
790: IF inv_pp_debug.is_debug_mode THEN
791: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
792: -- the message retrieved here since it is no longer on the stack
793: inv_pp_debug.set_last_error_message(Sqlerrm);
794: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
795: inv_pp_debug.send_last_error_message;

Line 815: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

811: --
812: -- debugging section
813: -- can be commented ut for final code
814: IF inv_pp_debug.is_debug_mode THEN
815: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
816: -- the message retrieved here since it is no longer on the stack
817: inv_pp_debug.set_last_error_message(Sqlerrm);
818: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
819: inv_pp_debug.send_last_error_message;

Line 833: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

829: END IF; */
830: IF l_ship_info_csr%isopen THEN
831: CLOSE l_ship_info_csr;
832: END IF;
833: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
834: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
835: END IF;
836: END get_request_context;
837: --

Line 834: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);

830: IF l_ship_info_csr%isopen THEN
831: CLOSE l_ship_info_csr;
832: END IF;
833: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
834: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
835: END IF;
836: END get_request_context;
837: --
838: -- compute picking detailing levels based on the move order line and

Line 1113: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

1109: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1110: --
1111: when others then
1112: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1113: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1114: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1115: end if;
1116: --
1117: END compute_pick_detail_level;

Line 1114: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1110: --
1111: when others then
1112: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1113: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1114: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1115: end if;
1116: --
1117: END compute_pick_detail_level;
1118: --

Line 1164: fnd_msg_pub.add;

1160: --
1161: print_debug('in inv validate and init');
1162: IF p_request_line_id IS NULL THEN
1163: fnd_message.set_name('INV','INV_PP_TRX_REQ_LINE_ID_MISS');
1164: fnd_msg_pub.add;
1165: RAISE fnd_api.g_exc_error;
1166: END IF;
1167: --
1168: -- get request context

Line 1232: if (fnd_msg_pub.check_msg_level(

1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1229: --
1230: when others then
1231: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1232: if (fnd_msg_pub.check_msg_level(
1233: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1234: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1235: end if;
1236: --

Line 1233: fnd_msg_pub.g_msg_lvl_unexp_error)) then

1229: --
1230: when others then
1231: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1232: if (fnd_msg_pub.check_msg_level(
1233: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1234: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1235: end if;
1236: --
1237: END validate_and_init;

Line 1234: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1230: when others then
1231: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1232: if (fnd_msg_pub.check_msg_level(
1233: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1234: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1235: end if;
1236: --
1237: END validate_and_init;
1238: --

Line 1436: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1432: return 'N';
1433: END IF;
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1438: END IF;
1439: fnd_msg_pub.count_and_get( p_count => l_msg_count
1440: ,p_data => l_msg_data );

Line 1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1433: END IF;
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1438: END IF;
1439: fnd_msg_pub.count_and_get( p_count => l_msg_count
1440: ,p_data => l_msg_data );
1441: return 'N';

Line 1439: fnd_msg_pub.count_and_get( p_count => l_msg_count

1435: WHEN OTHERS THEN
1436: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1438: END IF;
1439: fnd_msg_pub.count_and_get( p_count => l_msg_count
1440: ,p_data => l_msg_data );
1441: return 'N';
1442:
1443: END is_sub_loc_lot_trx_allowed;

Line 1533: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1529: return 'N';
1530: END IF;
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1535: END IF;
1536: fnd_msg_pub.count_and_get( p_count => l_msg_count
1537: ,p_data => l_msg_data );

Line 1534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1530: END IF;
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1535: END IF;
1536: fnd_msg_pub.count_and_get( p_count => l_msg_count
1537: ,p_data => l_msg_data );
1538: return 'N';

Line 1536: fnd_msg_pub.count_and_get( p_count => l_msg_count

1532: WHEN OTHERS THEN
1533: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1535: END IF;
1536: fnd_msg_pub.count_and_get( p_count => l_msg_count
1537: ,p_data => l_msg_data );
1538: return 'N';
1539:
1540: END is_serial_trx_allowed;

Line 1661: if (fnd_msg_pub.check_msg_level(

1657: when others then
1658: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1659: x_found := TRUE;
1660:
1661: if (fnd_msg_pub.check_msg_level(
1662: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1664: end if;
1665:

Line 1662: fnd_msg_pub.g_msg_lvl_unexp_error)) then

1658: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1659: x_found := TRUE;
1660:
1661: if (fnd_msg_pub.check_msg_level(
1662: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1664: end if;
1665:
1666: end search_serial_numbers;

Line 1663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1659: x_found := TRUE;
1660:
1661: if (fnd_msg_pub.check_msg_level(
1662: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1664: end if;
1665:
1666: end search_serial_numbers;
1667: --

Line 1891: fnd_msg_pub.ADD;

1887: IF ( l_debug = 1 ) THEN
1888: print_debug('Get_User_Serial_Numbers returned duplicate serials', 1);
1889: END IF;
1890: fnd_message.set_name('INV', 'INV_DUPLICATE_SERIAL');
1891: fnd_msg_pub.ADD;
1892: RAISE fnd_api.g_exc_error;
1893: END;
1894:
1895: --Retrieve only valid rows returned from api

Line 2009: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

2005: IF (l_debug = 1) THEN
2006: print_debug(l_api_name ||' Others err progress='||l_progress||' SQL err: '||SQLERRM(SQLCODE), 1);
2007: END IF;
2008:
2009: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
2010: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2011: END IF;
2012: END Get_Serial_Numbers;
2013: --

Line 2010: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2006: print_debug(l_api_name ||' Others err progress='||l_progress||' SQL err: '||SQLERRM(SQLCODE), 1);
2007: END IF;
2008:
2009: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
2010: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2011: END IF;
2012: END Get_Serial_Numbers;
2013: --
2014: -- insert record into mtl_material_transactions_temp

Line 2462: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2458: --
2459: -- debugging portion
2460: -- can be commented ut for final code
2461: IF inv_pp_debug.is_debug_mode THEN
2462: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2463: -- the message retrieved here since it is no longer on the stack
2464: inv_pp_debug.set_last_error_message(Sqlerrm);
2465: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2466: inv_pp_debug.send_last_error_message;

Line 2477: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2473: --
2474: -- debugging portion
2475: -- can be commented ut for final code
2476: IF inv_pp_debug.is_debug_mode THEN
2477: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2478: -- the message retrieved here since it is no longer on the stack
2479: inv_pp_debug.set_last_error_message(Sqlerrm);
2480: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2481: inv_pp_debug.send_last_error_message;

Line 2492: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2488: --
2489: -- debugging portion
2490: -- can be commented ut for final code
2491: IF inv_pp_debug.is_debug_mode THEN
2492: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2493: -- the message retrieved here since it is no longer on the stack
2494: inv_pp_debug.set_last_error_message(Sqlerrm);
2495: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2496: inv_pp_debug.send_last_error_message;

Line 2501: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then

2497: END IF;
2498: -- end of debugging section
2499: --
2500: x_return_status := fnd_api.g_ret_sts_unexp_error;
2501: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2502: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2503: end if;
2504: --
2505: END insert_mmtt;

Line 2502: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2498: -- end of debugging section
2499: --
2500: x_return_status := fnd_api.g_ret_sts_unexp_error;
2501: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2502: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2503: end if;
2504: --
2505: END insert_mmtt;
2506: --

Line 2780: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2776: --
2777: -- debugging portion
2778: -- can be commented ut for final code
2779: IF inv_pp_debug.is_debug_mode THEN
2780: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2781: -- the message retrieved here since it is no longer on the stack
2782: inv_pp_debug.set_last_error_message(Sqlerrm);
2783: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2784: inv_pp_debug.send_last_error_message;

Line 2795: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2791: --
2792: -- debugging portion
2793: -- can be commented ut for final code
2794: IF inv_pp_debug.is_debug_mode THEN
2795: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2796: -- the message retrieved here since it is no longer on the stack
2797: inv_pp_debug.set_last_error_message(Sqlerrm);
2798: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2799: inv_pp_debug.send_last_error_message;

Line 2810: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2806: --
2807: -- debugging portion
2808: -- can be commented ut for final code
2809: IF inv_pp_debug.is_debug_mode THEN
2810: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2811: -- the message retrieved here since it is no longer on the stack
2812: inv_pp_debug.set_last_error_message(Sqlerrm);
2813: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2814: inv_pp_debug.send_last_error_message;

Line 2819: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then

2815: END IF;
2816: -- end of debugging section
2817: --
2818: x_return_status := fnd_api.g_ret_sts_unexp_error;
2819: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2820: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2821: end if;
2822: --
2823: END insert_mtlt;

Line 2820: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);

2816: -- end of debugging section
2817: --
2818: x_return_status := fnd_api.g_ret_sts_unexp_error;
2819: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2820: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2821: end if;
2822: --
2823: END insert_mtlt;
2824: --

Line 2917: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2913: --
2914: -- debugging portion
2915: -- can be commented ut for final code
2916: IF inv_pp_debug.is_debug_mode THEN
2917: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2918: -- the message retrieved here since it is no longer on the stack
2919: inv_pp_debug.set_last_error_message(Sqlerrm);
2920: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2921: inv_pp_debug.send_last_error_message;

Line 2932: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2928: --
2929: -- debugging portion
2930: -- can be commented ut for final code
2931: IF inv_pp_debug.is_debug_mode THEN
2932: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2933: -- the message retrieved here since it is no longer on the stack
2934: inv_pp_debug.set_last_error_message(Sqlerrm);
2935: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2936: inv_pp_debug.send_last_error_message;

Line 2947: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2943: --
2944: -- debugging portion
2945: -- can be commented ut for final code
2946: IF inv_pp_debug.is_debug_mode THEN
2947: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2948: -- the message retrieved here since it is no longer on the stack
2949: inv_pp_debug.set_last_error_message(Sqlerrm);
2950: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2951: inv_pp_debug.send_last_error_message;

Line 2956: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then

2952: END IF;
2953: -- end of debugging section
2954: --
2955: x_return_status := fnd_api.g_ret_sts_unexp_error;
2956: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2957: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2958: end if;
2959: --
2960: END insert_msnt;

Line 2957: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);

2953: -- end of debugging section
2954: --
2955: x_return_status := fnd_api.g_ret_sts_unexp_error;
2956: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2957: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2958: end if;
2959: --
2960: END insert_msnt;
2961: --

Line 3204: FND_MSG_PUB.Add;

3200: x_return_status := fnd_api.g_ret_sts_success;
3201: EXCEPTION
3202: WHEN OTHERS THEN
3203: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
3204: FND_MSG_PUB.Add;
3205: x_return_status := fnd_api.g_ret_sts_unexp_error;
3206: END update_detailed_quantities;
3207: --
3208: -- create suggestion records.

Line 3838: FND_MSG_PUB.add;

3834: l_today);
3835: END IF;
3836: IF l_mmtt_tbl(l_mmtt_tbl_size).acct_period_id = -1 THEN
3837: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
3838: FND_MSG_PUB.add;
3839: x_return_status := FND_API.G_RET_STS_ERROR;
3840: raise FND_API.G_EXC_ERROR;
3841: END IF;
3842: l_mmtt_tbl(l_mmtt_tbl_size).transaction_reference :=

Line 4070: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

4066: --
4067: -- debugging section
4068: -- can be commented ut for final code
4069: IF inv_pp_debug.is_debug_mode THEN
4070: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4071: -- the message retrieved here since it is no longer on the stack
4072: inv_pp_debug.set_last_error_message(Sqlerrm);
4073: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4074: inv_pp_debug.send_last_error_message;

Line 4085: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

4081: --
4082: -- debugging section
4083: -- can be commented ut for final code
4084: IF inv_pp_debug.is_debug_mode THEN
4085: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4086: -- the message retrieved here since it is no longer on the stack
4087: inv_pp_debug.set_last_error_message(Sqlerrm);
4088: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4089: inv_pp_debug.send_last_error_message;

Line 4100: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

4096: --
4097: -- debugging section
4098: -- can be commented ut for final code
4099: IF inv_pp_debug.is_debug_mode THEN
4100: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4101: -- the message retrieved here since it is no longer on the stack
4102: inv_pp_debug.set_last_error_message(Sqlerrm);
4103: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4104: inv_pp_debug.send_last_error_message;

Line 4109: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4105: END IF;
4106: -- end of debugging section
4107: --
4108: x_return_status := fnd_api.g_ret_sts_unexp_error;
4109: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4110: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4111: END IF;
4112: --
4113: END process_output;

Line 4110: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

4106: -- end of debugging section
4107: --
4108: x_return_status := fnd_api.g_ret_sts_unexp_error;
4109: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4110: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4111: END IF;
4112: --
4113: END process_output;
4114: FUNCTION is_sub_loc_lot_reservable(

Line 4210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4206: return FALSE; -- anything with 0 is a 'N'
4207: END IF;
4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4212: END IF;
4213: fnd_msg_pub.count_and_get( p_count => l_msg_count
4214: ,p_data => l_msg_data );

Line 4211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

4207: END IF;
4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4212: END IF;
4213: fnd_msg_pub.count_and_get( p_count => l_msg_count
4214: ,p_data => l_msg_data );
4215: print_debug('check sub_lot_loc_reservable exception false ');

Line 4213: fnd_msg_pub.count_and_get( p_count => l_msg_count

4209: WHEN OTHERS THEN
4210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4211: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4212: END IF;
4213: fnd_msg_pub.count_and_get( p_count => l_msg_count
4214: ,p_data => l_msg_data );
4215: print_debug('check sub_lot_loc_reservable exception false ');
4216: return FALSE;
4217: