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

Line 101: IF (fnd_msg_pub.check_msg_level

97: --
98: WHEN OTHERS THEN
99: x_return_status := fnd_api.g_ret_sts_unexp_error ;
100: --
101: IF (fnd_msg_pub.check_msg_level
102: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
104: END IF;
105: --

Line 102: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

98: WHEN OTHERS THEN
99: x_return_status := fnd_api.g_ret_sts_unexp_error ;
100: --
101: IF (fnd_msg_pub.check_msg_level
102: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
104: END IF;
105: --
106: END get_pick_rule ;

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

99: x_return_status := fnd_api.g_ret_sts_unexp_error ;
100: --
101: IF (fnd_msg_pub.check_msg_level
102: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
104: END IF;
105: --
106: END get_pick_rule ;
107: --

Line 172: fnd_msg_pub.ADD;

168: RETURN l_locator_control;
169: EXCEPTION
170: WHEN invalid_loc_control_exception THEN
171: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');
172: fnd_msg_pub.ADD;
173: --
174: x_return_status := fnd_api.g_ret_sts_error ;
175: l_locator_control := -1 ;
176: RETURN l_locator_control ;

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

187: --
188: WHEN OTHERS THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error ;
190: --
191: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
192: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
193: END IF;
194: --
195: l_locator_control := -1 ;

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

188: WHEN OTHERS THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error ;
190: --
191: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
192: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
193: END IF;
194: --
195: l_locator_control := -1 ;
196: RETURN l_locator_control ;

Line 304: fnd_msg_pub.ADD;

300: IF l_subinventory_code_csr%notfound OR
301: l_putaway_sub IS NULL THEN
302: CLOSE l_subinventory_code_csr;
303: fnd_message.set_name('INV','INV_NO_DEFAULT_SUB');
304: fnd_msg_pub.ADD;
305: RAISE fnd_api.g_exc_error;
306: END IF;
307: CLOSE l_subinventory_code_csr;
308:

Line 339: fnd_msg_pub.add;

335: END IF;
336:
337: IF l_allowed <> 'Y' THEN
338: fnd_message.set_name('INV', 'INV_DETAIL_SUB_STATUS');
339: fnd_msg_pub.add;
340: raise fnd_api.g_exc_error;
341: END IF;
342: END IF;
343: END IF;

Line 350: fnd_msg_pub.ADD;

346: -- default locator needs to be selected from item defaults
347: --
348: IF NOT l_sub_found THEN
349: fnd_message.set_name('INV','INV_NO_SUB_LOC_CONTROL');
350: fnd_msg_pub.ADD;
351: RAISE fnd_api.g_exc_error;
352: END if;
353:
354: l_sub_loc_control := INV_CACHE.tosub_rec.locator_type;

Line 378: fnd_msg_pub.ADD;

374: FETCH l_locator_csr INTO l_putaway_loc;
375: IF l_locator_csr%notfound OR l_putaway_loc IS NULL THEN
376: CLOSE l_locator_csr;
377: fnd_message.set_name('INV','INV_NO_DEFAULT_LOC');
378: fnd_msg_pub.ADD;
379: RAISE fnd_api.g_exc_error;
380: END IF;
381: ELSE
382: l_putaway_loc := p_to_locator_id ;

Line 412: fnd_msg_pub.add;

408: END IF;
409:
410: IF l_allowed <> 'Y' THEN
411: fnd_message.set_name('INV', 'INV_DETAIL_LOC_STATUS');
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;
414: END IF;
415: END IF;
416:

Line 446: fnd_msg_pub.ADD;

442: If l_putaway_cg IS NULL Then
443: l_putaway_cg := l_putaway_cg_org;
444: if l_putaway_cg IS NULL then
445: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');
446: fnd_msg_pub.ADD;
447: RAISE fnd_api.g_exc_error;
448: end if;
449: End If;
450: ELSE

Line 480: IF (fnd_msg_pub.check_msg_level

476: x_putaway_loc := NULL;
477: x_putaway_sub := NULL;
478: x_putaway_cost_group_id := NULL;
479: --
480: IF (fnd_msg_pub.check_msg_level
481: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
482: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
483: END IF;
484: --

Line 481: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

477: x_putaway_sub := NULL;
478: x_putaway_cost_group_id := NULL;
479: --
480: IF (fnd_msg_pub.check_msg_level
481: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
482: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
483: END IF;
484: --
485: END get_putaway_defaults ;

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

478: x_putaway_cost_group_id := NULL;
479: --
480: IF (fnd_msg_pub.check_msg_level
481: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
482: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
483: END IF;
484: --
485: END get_putaway_defaults ;
486: --

Line 610: IF (fnd_msg_pub.check_msg_level

606: WHEN OTHERS THEN
607: x_return_status := fnd_api.g_ret_sts_unexp_error ;
608: x_where_clause := NULL;
609: --
610: IF (fnd_msg_pub.check_msg_level
611: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
612: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
613: END IF;
614: --

Line 611: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

607: x_return_status := fnd_api.g_ret_sts_unexp_error ;
608: x_where_clause := NULL;
609: --
610: IF (fnd_msg_pub.check_msg_level
611: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
612: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
613: END IF;
614: --
615: END project_where;

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

608: x_where_clause := NULL;
609: --
610: IF (fnd_msg_pub.check_msg_level
611: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
612: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
613: END IF;
614: --
615: END project_where;
616: --

Line 700: fnd_msg_pub.ADD;

696: FETCH l_rule_csr INTO l_rev_rule, l_lot_rule, l_sub_rule, l_loc_rule;
697: IF l_rule_csr%notfound THEN
698: CLOSE l_rule_csr;
699: fnd_message.set_name('INV','INV_INVALID_PICKING_RULE');
700: fnd_msg_pub.ADD;
701: RAISE fnd_api.g_exc_error;
702: END IF;
703: CLOSE l_rule_csr;
704: --

Line 708: fnd_msg_pub.ADD;

704: --
705: IF l_rev_rule IS NULL OR l_lot_rule IS NULL OR
706: l_sub_rule IS NULL OR l_loc_rule IS NULL THEN
707: fnd_message.set_name('INV','INV_RULE_DEFINITION_ERROR');
708: fnd_msg_pub.ADD;
709: RAISE fnd_api.g_exc_error;
710: END IF;
711: ELSE
712: l_rev_rule := 0;

Line 1046: IF (fnd_msg_pub.check_msg_level

1042: --
1043: WHEN OTHERS THEN
1044: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1045: --
1046: IF (fnd_msg_pub.check_msg_level
1047: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1048: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1049: END IF;
1050: --

Line 1047: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

1043: WHEN OTHERS THEN
1044: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1045: --
1046: IF (fnd_msg_pub.check_msg_level
1047: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1048: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1049: END IF;
1050: --
1051: END get_sql_for_rule ;

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

1044: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1045: --
1046: IF (fnd_msg_pub.check_msg_level
1047: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1048: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1049: END IF;
1050: --
1051: END get_sql_for_rule ;
1052: --

Line 1369: fnd_msg_pub.add;

1365:
1366: -- First, get the line for from sub and to sub
1367: IF NOT (inv_cache.set_fromsub_rec(p_request_line_rec.organization_id, l_from_subinventory)) THEN
1368: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1369: fnd_msg_pub.add;
1370: RAISE fnd_api.g_exc_unexpected_error;
1371: END IF;
1372:
1373: IF NOT (inv_cache.set_tosub_rec(p_request_line_rec.organization_id, l_to_subinventory)) THEN

Line 1375: fnd_msg_pub.add;

1371: END IF;
1372:
1373: IF NOT (inv_cache.set_tosub_rec(p_request_line_rec.organization_id, l_to_subinventory)) THEN
1374: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1375: fnd_msg_pub.add;
1376: RAISE fnd_api.g_exc_unexpected_error;
1377: END IF;
1378:
1379: IF NOT (inv_cache.set_org_rec(p_request_line_rec.organization_id)) THEN

Line 1381: fnd_msg_pub.add;

1377: END IF;
1378:
1379: IF NOT (inv_cache.set_org_rec(p_request_line_rec.organization_id)) THEN
1380: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1381: fnd_msg_pub.add;
1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END IF;
1384: IF NOT (inv_cache.set_item_rec(p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id)) THEN
1385: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');

Line 1386: fnd_msg_pub.add;

1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END IF;
1384: IF NOT (inv_cache.set_item_rec(p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id)) THEN
1385: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1386: fnd_msg_pub.add;
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: END IF;
1389:
1390: -- then, call api

Line 1603: IF (fnd_msg_pub.check_msg_level

1599: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1600: --
1601: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1602: --
1603: IF (fnd_msg_pub.check_msg_level
1604: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1605: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1606: END IF;
1607: --

Line 1604: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

1600: --
1601: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1602: --
1603: IF (fnd_msg_pub.check_msg_level
1604: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1605: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1606: END IF;
1607: --
1608: END detail_xfer_or_pick;

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

1601: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1602: --
1603: IF (fnd_msg_pub.check_msg_level
1604: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1605: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1606: END IF;
1607: --
1608: END detail_xfer_or_pick;
1609: --

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

1675: --
1676: WHEN OTHERS THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1678: --
1679: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1680: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1681: END IF;
1682: --
1683: END detail_putaway_only;

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

1676: WHEN OTHERS THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1678: --
1679: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1680: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1681: END IF;
1682: --
1683: END detail_putaway_only;
1684:

Line 1852: --fnd_msg_pub.add;

1848: IF inv_detail_util_pvt.g_output_process_tbl.COUNT = 0 THEN
1849: --edited out called to fnd_message by jcearley, 12/2/99
1850: --fnd_message.set_name('INV','INV_SUGGESTION_FAILED');
1851: -- Suggestions not or only partially created through applying strategy
1852: --fnd_msg_pub.add;
1853: --RAISE fnd_api.g_exc_error;
1854: RETURN; -- do not raise exeception since it is not an error if can't find qty
1855: END IF;
1856: -- now we can generate records into transactions temp tables

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

1873: --
1874: WHEN OTHERS THEN
1875: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1876: --
1877: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1878: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1879: END IF;
1880: --
1881: END detail_request;

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

1874: WHEN OTHERS THEN
1875: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1876: --
1877: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1878: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1879: END IF;
1880: --
1881: END detail_request;
1882: --

Line 1966: fnd_msg_pub.initialize;

1962: END IF;
1963: --
1964: -- Initialize message list
1965: IF fnd_api.to_boolean(p_init_msg_list) THEN
1966: fnd_msg_pub.initialize;
1967: END IF;
1968: --
1969: x_return_status := fnd_api.g_ret_sts_success ;
1970: --

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

2015: --
2016: -- debugging section
2017: -- can be commented ut for final code
2018: IF inv_pp_debug.is_debug_mode THEN
2019: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2020: -- the message retrieved here since it is no longer on the stack
2021: inv_pp_debug.set_last_error_message(Sqlerrm);
2022: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2023: inv_pp_debug.send_last_error_message;

Line 2029: fnd_msg_pub.Count_And_Get

2025: -- end of debugging section
2026: --
2027: ROLLBACK TO create_suggestions_sa;
2028: x_return_status := fnd_api.g_ret_sts_error;
2029: fnd_msg_pub.Count_And_Get
2030: ( p_count => x_msg_count
2031: ,p_data => x_msg_data);
2032: --
2033: WHEN fnd_api.g_exc_unexpected_error THEN

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

2034: --
2035: -- debugging section
2036: -- can be commented ut for final code
2037: IF inv_pp_debug.is_debug_mode THEN
2038: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2039: -- the message retrieved here since it is no longer on the stack
2040: inv_pp_debug.set_last_error_message(Sqlerrm);
2041: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2042: inv_pp_debug.send_last_error_message;

Line 2048: fnd_msg_pub.Count_And_Get

2044: -- end of debugging section
2045: --
2046: ROLLBACK TO create_suggestions_sa;
2047: x_return_status := fnd_api.g_ret_sts_unexp_error;
2048: fnd_msg_pub.Count_And_Get
2049: ( p_count => x_msg_count
2050: ,p_data => x_msg_data);
2051: --
2052: WHEN OTHERS THEN

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

2053: --
2054: -- debugging section
2055: -- can be commented ut for final code
2056: IF inv_pp_debug.is_debug_mode THEN
2057: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2058: -- the message retrieved here since it is no longer on the stack
2059: inv_pp_debug.set_last_error_message(Sqlerrm);
2060: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2061: inv_pp_debug.send_last_error_message;

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

2063: -- end of debugging section
2064: --
2065: ROLLBACK TO create_suggestions_sa;
2066: x_return_status := fnd_api.g_ret_sts_unexp_error;
2067: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2069: END IF;
2070: fnd_msg_pub.count_and_get
2071: ( p_count => x_msg_count

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

2064: --
2065: ROLLBACK TO create_suggestions_sa;
2066: x_return_status := fnd_api.g_ret_sts_unexp_error;
2067: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2069: END IF;
2070: fnd_msg_pub.count_and_get
2071: ( p_count => x_msg_count
2072: ,p_data => x_msg_data);

Line 2070: fnd_msg_pub.count_and_get

2066: x_return_status := fnd_api.g_ret_sts_unexp_error;
2067: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2068: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2069: END IF;
2070: fnd_msg_pub.count_and_get
2071: ( p_count => x_msg_count
2072: ,p_data => x_msg_data);
2073: END create_suggestions;
2074: END INV_AUTODETAIL;