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 249: fnd_msg_pub.ADD;

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

Line 457: FND_MSG_PUB.Add;

453: x_request_context.txn_header_id :=
454: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
455: IF x_request_context.txn_header_id IS NULL THEN
456: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
457: FND_MSG_PUB.Add;
458: RAISE fnd_api.g_exc_unexpected_error;
459: END IF;
460: --
461: --bug 1248138

Line 502: FND_MSG_PUB.Add;

498: x_request_context.txn_header_id :=
499: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
500: IF x_request_context.txn_header_id IS NULL THEN
501: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
502: FND_MSG_PUB.Add;
503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
505: END IF;
506:

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

715: --
716: -- debugging section
717: -- can be commented ut for final code
718: IF inv_pp_debug.is_debug_mode THEN
719: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
720: -- the message retrieved here since it is no longer on the stack
721: inv_pp_debug.set_last_error_message(Sqlerrm);
722: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
723: inv_pp_debug.send_last_error_message;

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

739: --
740: -- debugging section
741: -- can be commented ut for final code
742: IF inv_pp_debug.is_debug_mode THEN
743: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
744: -- the message retrieved here since it is no longer on the stack
745: inv_pp_debug.set_last_error_message(Sqlerrm);
746: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
747: inv_pp_debug.send_last_error_message;

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 785: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

781: END IF; */
782: IF l_ship_info_csr%isopen THEN
783: CLOSE l_ship_info_csr;
784: END IF;
785: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
786: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
787: END IF;
788: END get_request_context;
789: --

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

782: IF l_ship_info_csr%isopen THEN
783: CLOSE l_ship_info_csr;
784: END IF;
785: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
786: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
787: END IF;
788: END get_request_context;
789: --
790: -- compute picking detailing levels based on the move order line and

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

1002: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1003: --
1004: when others then
1005: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1006: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1007: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1008: end if;
1009: --
1010: END compute_pick_detail_level;

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

1003: --
1004: when others then
1005: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1006: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1007: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1008: end if;
1009: --
1010: END compute_pick_detail_level;
1011: --

Line 1032: fnd_msg_pub.add;

1028: --
1029: print_debug('in inv validate and init');
1030: IF p_request_line_id IS NULL THEN
1031: fnd_message.set_name('INV','INV_PP_TRX_REQ_LINE_ID_MISS');
1032: fnd_msg_pub.add;
1033: RAISE fnd_api.g_exc_error;
1034: END IF;
1035: --
1036: -- get request context

Line 1099: if (fnd_msg_pub.check_msg_level(

1095: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1096: --
1097: when others then
1098: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1099: if (fnd_msg_pub.check_msg_level(
1100: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1101: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1102: end if;
1103: --

Line 1100: fnd_msg_pub.g_msg_lvl_unexp_error)) then

1096: --
1097: when others then
1098: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1099: if (fnd_msg_pub.check_msg_level(
1100: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1101: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1102: end if;
1103: --
1104: END validate_and_init;

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

1097: when others then
1098: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1099: if (fnd_msg_pub.check_msg_level(
1100: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1101: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1102: end if;
1103: --
1104: END validate_and_init;
1105: --

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

1299: return 'N';
1300: END IF;
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1304: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: fnd_msg_pub.count_and_get( p_count => l_msg_count
1307: ,p_data => l_msg_data );

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

1300: END IF;
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1304: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: fnd_msg_pub.count_and_get( p_count => l_msg_count
1307: ,p_data => l_msg_data );
1308: return 'N';

Line 1306: fnd_msg_pub.count_and_get( p_count => l_msg_count

1302: WHEN OTHERS THEN
1303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1304: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: fnd_msg_pub.count_and_get( p_count => l_msg_count
1307: ,p_data => l_msg_data );
1308: return 'N';
1309:
1310: END is_sub_loc_lot_trx_allowed;

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

1396: return 'N';
1397: END IF;
1398: EXCEPTION
1399: WHEN OTHERS THEN
1400: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1401: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1402: END IF;
1403: fnd_msg_pub.count_and_get( p_count => l_msg_count
1404: ,p_data => l_msg_data );

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

1397: END IF;
1398: EXCEPTION
1399: WHEN OTHERS THEN
1400: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1401: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1402: END IF;
1403: fnd_msg_pub.count_and_get( p_count => l_msg_count
1404: ,p_data => l_msg_data );
1405: return 'N';

Line 1403: fnd_msg_pub.count_and_get( p_count => l_msg_count

1399: WHEN OTHERS THEN
1400: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1401: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1402: END IF;
1403: fnd_msg_pub.count_and_get( p_count => l_msg_count
1404: ,p_data => l_msg_data );
1405: return 'N';
1406:
1407: END is_serial_trx_allowed;

Line 1528: if (fnd_msg_pub.check_msg_level(

1524: when others then
1525: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1526: x_found := TRUE;
1527:
1528: if (fnd_msg_pub.check_msg_level(
1529: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1530: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1531: end if;
1532:

Line 1529: fnd_msg_pub.g_msg_lvl_unexp_error)) then

1525: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1526: x_found := TRUE;
1527:
1528: if (fnd_msg_pub.check_msg_level(
1529: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1530: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1531: end if;
1532:
1533: end search_serial_numbers;

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

1526: x_found := TRUE;
1527:
1528: if (fnd_msg_pub.check_msg_level(
1529: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1530: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1531: end if;
1532:
1533: end search_serial_numbers;
1534: --

Line 1758: fnd_msg_pub.ADD;

1754: IF ( l_debug = 1 ) THEN
1755: print_debug('Get_User_Serial_Numbers returned duplicate serials', 1);
1756: END IF;
1757: fnd_message.set_name('INV', 'INV_DUPLICATE_SERIAL');
1758: fnd_msg_pub.ADD;
1759: RAISE fnd_api.g_exc_error;
1760: END;
1761:
1762: --Retrieve only valid rows returned from api

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

1872: IF (l_debug = 1) THEN
1873: print_debug(l_api_name ||' Others err progress='||l_progress||' SQL err: '||SQLERRM(SQLCODE), 1);
1874: END IF;
1875:
1876: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1877: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1878: END IF;
1879: END Get_Serial_Numbers;
1880: --

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

1873: print_debug(l_api_name ||' Others err progress='||l_progress||' SQL err: '||SQLERRM(SQLCODE), 1);
1874: END IF;
1875:
1876: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1877: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1878: END IF;
1879: END Get_Serial_Numbers;
1880: --
1881: -- insert record into mtl_material_transactions_temp

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

2323: --
2324: -- debugging portion
2325: -- can be commented ut for final code
2326: IF inv_pp_debug.is_debug_mode THEN
2327: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2328: -- the message retrieved here since it is no longer on the stack
2329: inv_pp_debug.set_last_error_message(Sqlerrm);
2330: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2331: inv_pp_debug.send_last_error_message;

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

2338: --
2339: -- debugging portion
2340: -- can be commented ut for final code
2341: IF inv_pp_debug.is_debug_mode THEN
2342: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2343: -- the message retrieved here since it is no longer on the stack
2344: inv_pp_debug.set_last_error_message(Sqlerrm);
2345: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2346: inv_pp_debug.send_last_error_message;

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

2353: --
2354: -- debugging portion
2355: -- can be commented ut for final code
2356: IF inv_pp_debug.is_debug_mode THEN
2357: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2358: -- the message retrieved here since it is no longer on the stack
2359: inv_pp_debug.set_last_error_message(Sqlerrm);
2360: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2361: inv_pp_debug.send_last_error_message;

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

2362: END IF;
2363: -- end of debugging section
2364: --
2365: x_return_status := fnd_api.g_ret_sts_unexp_error;
2366: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2367: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2368: end if;
2369: --
2370: END insert_mmtt;

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

2363: -- end of debugging section
2364: --
2365: x_return_status := fnd_api.g_ret_sts_unexp_error;
2366: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2367: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2368: end if;
2369: --
2370: END insert_mmtt;
2371: --

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

2639: --
2640: -- debugging portion
2641: -- can be commented ut for final code
2642: IF inv_pp_debug.is_debug_mode THEN
2643: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2644: -- the message retrieved here since it is no longer on the stack
2645: inv_pp_debug.set_last_error_message(Sqlerrm);
2646: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2647: inv_pp_debug.send_last_error_message;

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

2654: --
2655: -- debugging portion
2656: -- can be commented ut for final code
2657: IF inv_pp_debug.is_debug_mode THEN
2658: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2659: -- the message retrieved here since it is no longer on the stack
2660: inv_pp_debug.set_last_error_message(Sqlerrm);
2661: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2662: inv_pp_debug.send_last_error_message;

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

2669: --
2670: -- debugging portion
2671: -- can be commented ut for final code
2672: IF inv_pp_debug.is_debug_mode THEN
2673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2674: -- the message retrieved here since it is no longer on the stack
2675: inv_pp_debug.set_last_error_message(Sqlerrm);
2676: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2677: inv_pp_debug.send_last_error_message;

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

2678: END IF;
2679: -- end of debugging section
2680: --
2681: x_return_status := fnd_api.g_ret_sts_unexp_error;
2682: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2683: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2684: end if;
2685: --
2686: END insert_mtlt;

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

2679: -- end of debugging section
2680: --
2681: x_return_status := fnd_api.g_ret_sts_unexp_error;
2682: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2683: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2684: end if;
2685: --
2686: END insert_mtlt;
2687: --

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_msnt;

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_msnt;
2824: --

Line 3067: FND_MSG_PUB.Add;

3063: x_return_status := fnd_api.g_ret_sts_success;
3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
3067: FND_MSG_PUB.Add;
3068: x_return_status := fnd_api.g_ret_sts_unexp_error;
3069: END update_detailed_quantities;
3070: --
3071: -- create suggestion records.

Line 3419: FND_MSG_PUB.add;

3415: l_today);
3416: END IF;
3417: IF l_mmtt_tbl(l_mmtt_tbl_size).acct_period_id = -1 THEN
3418: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
3419: FND_MSG_PUB.add;
3420: x_return_status := FND_API.G_RET_STS_ERROR;
3421: raise FND_API.G_EXC_ERROR;
3422: END IF;
3423: l_mmtt_tbl(l_mmtt_tbl_size).transaction_reference :=

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

3647: --
3648: -- debugging section
3649: -- can be commented ut for final code
3650: IF inv_pp_debug.is_debug_mode THEN
3651: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3652: -- the message retrieved here since it is no longer on the stack
3653: inv_pp_debug.set_last_error_message(Sqlerrm);
3654: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3655: inv_pp_debug.send_last_error_message;

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

3662: --
3663: -- debugging section
3664: -- can be commented ut for final code
3665: IF inv_pp_debug.is_debug_mode THEN
3666: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3667: -- the message retrieved here since it is no longer on the stack
3668: inv_pp_debug.set_last_error_message(Sqlerrm);
3669: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3670: inv_pp_debug.send_last_error_message;

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

3677: --
3678: -- debugging section
3679: -- can be commented ut for final code
3680: IF inv_pp_debug.is_debug_mode THEN
3681: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3682: -- the message retrieved here since it is no longer on the stack
3683: inv_pp_debug.set_last_error_message(Sqlerrm);
3684: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3685: inv_pp_debug.send_last_error_message;

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

3686: END IF;
3687: -- end of debugging section
3688: --
3689: x_return_status := fnd_api.g_ret_sts_unexp_error;
3690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3691: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3692: END IF;
3693: --
3694: END process_output;

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

3687: -- end of debugging section
3688: --
3689: x_return_status := fnd_api.g_ret_sts_unexp_error;
3690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3691: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3692: END IF;
3693: --
3694: END process_output;
3695: FUNCTION is_sub_loc_lot_reservable(

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

3787: return FALSE; -- anything with 0 is a 'N'
3788: END IF;
3789: EXCEPTION
3790: WHEN OTHERS THEN
3791: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3792: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3793: END IF;
3794: fnd_msg_pub.count_and_get( p_count => l_msg_count
3795: ,p_data => l_msg_data );

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

3788: END IF;
3789: EXCEPTION
3790: WHEN OTHERS THEN
3791: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3792: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3793: END IF;
3794: fnd_msg_pub.count_and_get( p_count => l_msg_count
3795: ,p_data => l_msg_data );
3796: print_debug('check sub_lot_loc_reservable exception false ');

Line 3794: fnd_msg_pub.count_and_get( p_count => l_msg_count

3790: WHEN OTHERS THEN
3791: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3792: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3793: END IF;
3794: fnd_msg_pub.count_and_get( p_count => l_msg_count
3795: ,p_data => l_msg_data );
3796: print_debug('check sub_lot_loc_reservable exception false ');
3797: return FALSE;
3798: