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_QUANTITY_TREE_PVT dependencies on FND_MESSAGE

Line 1898: fnd_message.set_name('INV','INV_LOCK_MISSING_ARGS');

1894:
1895: --validate organization and inventory item
1896: IF (p_organization_id IS NULL OR p_inventory_item_id IS NULL) THEN
1897: --raise error condition
1898: fnd_message.set_name('INV','INV_LOCK_MISSING_ARGS');
1899: fnd_msg_pub.ADD;
1900: RAISE fnd_api.g_exc_error;
1901: END IF;
1902:

Line 1921: fnd_message.set_name('INV','INV_LOCK_TREE_TIMEOUT');

1917:
1918: --check for error cases
1919: IF (l_status NOT IN (0,4)) THEN
1920: if (l_status = 1) then -- timeout
1921: fnd_message.set_name('INV','INV_LOCK_TREE_TIMEOUT');
1922: fnd_msg_pub.ADD;
1923: RAISE fnd_api.g_exc_error;
1924: elsif (l_status = 2) then -- deadlock
1925: fnd_message.set_name('INV','INV_LOCK_TREE_DEADLOCK');

Line 1925: fnd_message.set_name('INV','INV_LOCK_TREE_DEADLOCK');

1921: fnd_message.set_name('INV','INV_LOCK_TREE_TIMEOUT');
1922: fnd_msg_pub.ADD;
1923: RAISE fnd_api.g_exc_error;
1924: elsif (l_status = 2) then -- deadlock
1925: fnd_message.set_name('INV','INV_LOCK_TREE_DEADLOCK');
1926: fnd_msg_pub.ADD;
1927: RAISE fnd_api.g_exc_error;
1928: else -- internal error - not fault of user
1929: fnd_message.set_name('INV','INV_LOCK_TREE_ERROR');

Line 1929: fnd_message.set_name('INV','INV_LOCK_TREE_ERROR');

1925: fnd_message.set_name('INV','INV_LOCK_TREE_DEADLOCK');
1926: fnd_msg_pub.ADD;
1927: RAISE fnd_api.g_exc_error;
1928: else -- internal error - not fault of user
1929: fnd_message.set_name('INV','INV_LOCK_TREE_ERROR');
1930: fnd_msg_pub.ADD;
1931: RAISE fnd_api.g_exc_error;
1932: end if;
1933: END IF;

Line 2003: fnd_message.set_name('INV','INV_LOCK_RELEASE_MISSING_ARGS');

1999: --validate organization and inventory item
2000: IF (p_organization_id IS NULL OR
2001: p_inventory_item_id IS NULL) THEN
2002: --raise error condition
2003: fnd_message.set_name('INV','INV_LOCK_RELEASE_MISSING_ARGS');
2004: fnd_msg_pub.ADD;
2005: RAISE fnd_api.g_exc_error;
2006: END IF;
2007:

Line 2020: fnd_message.set_name('INV','INV_LOCK_RELEASE_ERROR');

2016:
2017: --if success (status = 0) or session does not own lock (status=4), do nothing
2018: --if parameter error or illegal lock handle (internal error)
2019: if l_status IN (3,5) THEN
2020: fnd_message.set_name('INV','INV_LOCK_RELEASE_ERROR');
2021: fnd_msg_pub.ADD;
2022: RAISE fnd_api.g_exc_error;
2023: end if;
2024:

Line 2314: fnd_message.set_name('INV','INV-Cannot find node');

2310: AND p_locator_id IS NULL
2311: AND p_lpn_id IS NULL
2312: AND p_cost_group_id IS NULL
2313: THEN
2314: fnd_message.set_name('INV','INV-Cannot find node');
2315: fnd_message.set_token('ROUTINE', 'Find_Child_Node');
2316: fnd_msg_pub.ADD;
2317: RAISE fnd_api.g_exc_error;
2318: END IF;

Line 2315: fnd_message.set_token('ROUTINE', 'Find_Child_Node');

2311: AND p_lpn_id IS NULL
2312: AND p_cost_group_id IS NULL
2313: THEN
2314: fnd_message.set_name('INV','INV-Cannot find node');
2315: fnd_message.set_token('ROUTINE', 'Find_Child_Node');
2316: fnd_msg_pub.ADD;
2317: RAISE fnd_api.g_exc_error;
2318: END IF;
2319:

Line 2453: fnd_message.set_name('INV','INV-Cannot find node');

2449: RAISE fnd_api.g_exc_unexpected_error;
2450: End IF;
2451:
2452: IF l_found = FALSE THEN
2453: fnd_message.set_name('INV','INV-Cannot find node');
2454: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2455: fnd_msg_pub.ADD;
2456: RAISE fnd_api.g_exc_unexpected_error;
2457: End IF;

Line 2454: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');

2450: End IF;
2451:
2452: IF l_found = FALSE THEN
2453: fnd_message.set_name('INV','INV-Cannot find node');
2454: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2455: fnd_msg_pub.ADD;
2456: RAISE fnd_api.g_exc_unexpected_error;
2457: End IF;
2458:

Line 2507: fnd_message.set_name('INV','INV-Cannot find node');

2503: RAISE fnd_api.g_exc_unexpected_error;
2504: End IF;
2505:
2506: IF l_found = FALSE THEN
2507: fnd_message.set_name('INV','INV-Cannot find node');
2508: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2509: fnd_msg_pub.ADD;
2510: RAISE fnd_api.g_exc_unexpected_error;
2511: End IF;

Line 2508: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');

2504: End IF;
2505:
2506: IF l_found = FALSE THEN
2507: fnd_message.set_name('INV','INV-Cannot find node');
2508: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2509: fnd_msg_pub.ADD;
2510: RAISE fnd_api.g_exc_unexpected_error;
2511: End IF;
2512:

Line 2560: fnd_message.set_name('INV','INV-Cannot find node');

2556: RAISE fnd_api.g_exc_unexpected_error;
2557: End IF;
2558:
2559: IF l_found = FALSE THEN
2560: fnd_message.set_name('INV','INV-Cannot find node');
2561: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2562: fnd_msg_pub.ADD;
2563: RAISE fnd_api.g_exc_unexpected_error;
2564: End IF;

Line 2561: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');

2557: End IF;
2558:
2559: IF l_found = FALSE THEN
2560: fnd_message.set_name('INV','INV-Cannot find node');
2561: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2562: fnd_msg_pub.ADD;
2563: RAISE fnd_api.g_exc_unexpected_error;
2564: End IF;
2565:

Line 2613: fnd_message.set_name('INV','INV-Cannot find node');

2609: RAISE fnd_api.g_exc_unexpected_error;
2610: End IF;
2611:
2612: IF l_found = FALSE THEN
2613: fnd_message.set_name('INV','INV-Cannot find node');
2614: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2615: fnd_msg_pub.ADD;
2616: RAISE fnd_api.g_exc_unexpected_error;
2617: End IF;

Line 2614: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');

2610: End IF;
2611:
2612: IF l_found = FALSE THEN
2613: fnd_message.set_name('INV','INV-Cannot find node');
2614: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2615: fnd_msg_pub.ADD;
2616: RAISE fnd_api.g_exc_unexpected_error;
2617: End IF;
2618:

Line 2666: fnd_message.set_name('INV','INV-Cannot find node');

2662: RAISE fnd_api.g_exc_unexpected_error;
2663: End IF;
2664:
2665: IF l_found = FALSE THEN
2666: fnd_message.set_name('INV','INV-Cannot find node');
2667: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2668: fnd_msg_pub.ADD;
2669: RAISE fnd_api.g_exc_unexpected_error;
2670: End IF;

Line 2667: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');

2663: End IF;
2664:
2665: IF l_found = FALSE THEN
2666: fnd_message.set_name('INV','INV-Cannot find node');
2667: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
2668: fnd_msg_pub.ADD;
2669: RAISE fnd_api.g_exc_unexpected_error;
2670: End IF;
2671:

Line 2849: fnd_message.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');

2845: AND p_quantity_type <> g_qr_other_demand
2846: AND p_quantity_type <> g_qs_txn THEN
2847: -- invalid p_quantity_type. the caller's fault
2848: print_debug('... error=INVALID_QUANTITY_TYPE');
2849: fnd_message.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');
2850: fnd_msg_pub.ADD;
2851: RAISE fnd_api.g_exc_error;
2852: END IF;
2853:

Line 2879: fnd_message.set_name('INV','INV-Cannot find node');

2875: RAISE fnd_api.g_exc_unexpected_error;
2876: END IF;
2877:
2878: IF l_found = FALSE THEN
2879: fnd_message.set_name('INV','INV-Cannot find node');
2880: fnd_message.set_token('ROUTINE', 'Add_Quantities');
2881: fnd_msg_pub.ADD;
2882: RAISE fnd_api.g_exc_unexpected_error;
2883: End IF;

Line 2880: fnd_message.set_token('ROUTINE', 'Add_Quantities');

2876: END IF;
2877:
2878: IF l_found = FALSE THEN
2879: fnd_message.set_name('INV','INV-Cannot find node');
2880: fnd_message.set_token('ROUTINE', 'Add_Quantities');
2881: fnd_msg_pub.ADD;
2882: RAISE fnd_api.g_exc_unexpected_error;
2883: End IF;
2884:

Line 2906: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');

2902: AND g_nodes(l_node_index).node_level <> g_sub_level
2903: AND g_nodes(l_node_index).node_level <> g_lpn_level
2904: THEN
2905: print_debug('... error=INV-WRONG_LEVEL');
2906: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');
2907: fnd_msg_pub.ADD;
2908: RAISE fnd_api.g_exc_error;
2909: End IF;
2910:

Line 3489: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');

3485: AND g_nodes(l_node_index).node_level <> g_cost_group_level
3486: AND g_nodes(l_node_index).node_level <> g_sub_level
3487: AND g_nodes(l_node_index).node_level <> g_lpn_level
3488: THEN
3489: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');
3490: fnd_msg_pub.ADD;
3491: RAISE fnd_api.g_exc_error;
3492: End IF;
3493:

Line 9855: fnd_message.set_name('INV', 'INV-Qtyroot not found');

9851:
9852: l_root_id := g_demand_info(p_tree_id).root_id;
9853: -- check if tree id is valid
9854: IF is_tree_valid(l_root_id) = FALSE THEN
9855: fnd_message.set_name('INV', 'INV-Qtyroot not found');
9856: fnd_message.set_token('ROUTINE', 'Query_Tree');
9857: fnd_msg_pub.ADD;
9858: RAISE fnd_api.g_exc_error;
9859: END IF;

Line 9856: fnd_message.set_token('ROUTINE', 'Query_Tree');

9852: l_root_id := g_demand_info(p_tree_id).root_id;
9853: -- check if tree id is valid
9854: IF is_tree_valid(l_root_id) = FALSE THEN
9855: fnd_message.set_name('INV', 'INV-Qtyroot not found');
9856: fnd_message.set_token('ROUTINE', 'Query_Tree');
9857: fnd_msg_pub.ADD;
9858: RAISE fnd_api.g_exc_error;
9859: END IF;
9860:

Line 9947: fnd_message.set_name('INV','INV-Cannot find node');

9943: RAISE fnd_api.g_exc_unexpected_error;
9944: End IF;
9945:
9946: IF l_found = FALSE THEN
9947: fnd_message.set_name('INV','INV-Cannot find node');
9948: fnd_message.set_token('ROUTINE', 'Query_Tree');
9949: fnd_msg_pub.ADD;
9950: RAISE fnd_api.g_exc_unexpected_error;
9951: End IF;

Line 9948: fnd_message.set_token('ROUTINE', 'Query_Tree');

9944: End IF;
9945:
9946: IF l_found = FALSE THEN
9947: fnd_message.set_name('INV','INV-Cannot find node');
9948: fnd_message.set_token('ROUTINE', 'Query_Tree');
9949: fnd_msg_pub.ADD;
9950: RAISE fnd_api.g_exc_unexpected_error;
9951: End IF;
9952:

Line 10910: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');

10906:
10907: -- validate demand source info
10908: IF p_tree_mode IN (g_transaction_mode, g_loose_only_mode) THEN
10909: IF p_demand_source_type_id IS NULL THEN
10910: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
10911: fnd_msg_pub.ADD;
10912: RAISE fnd_api.g_exc_error;
10913: END IF;
10914:

Line 10917: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');

10913: END IF;
10914:
10915: IF p_demand_source_header_id IS NULL THEN
10916: IF p_demand_source_name IS NULL THEN
10917: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
10918: fnd_msg_pub.ADD;
10919: RAISE fnd_api.g_exc_error;
10920: END IF;
10921: END IF;

Line 10925: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');

10921: END IF;
10922:
10923: IF p_demand_source_header_id IS NULL
10924: AND p_demand_source_line_id IS NOT NULL THEN
10925: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
10926: fnd_msg_pub.ADD;
10927: RAISE fnd_api.g_exc_error;
10928: END IF;
10929: END IF;

Line 10946: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');

10942: THEN
10943: print_debug(' get_item_details NOTFOUND for org='||p_organization_id||', item='||p_inventory_item_id);
10944: CLOSE get_item_details;
10945: -- The item doesn't exist under this organization.
10946: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
10947: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
10948: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
10949: FND_MSG_PUB.ADD;
10950: RAISE FND_API.G_EXC_ERROR;

Line 10947: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);

10943: print_debug(' get_item_details NOTFOUND for org='||p_organization_id||', item='||p_inventory_item_id);
10944: CLOSE get_item_details;
10945: -- The item doesn't exist under this organization.
10946: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
10947: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
10948: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
10949: FND_MSG_PUB.ADD;
10950: RAISE FND_API.G_EXC_ERROR;
10951: END IF;

Line 10948: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);

10944: CLOSE get_item_details;
10945: -- The item doesn't exist under this organization.
10946: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
10947: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
10948: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
10949: FND_MSG_PUB.ADD;
10950: RAISE FND_API.G_EXC_ERROR;
10951: END IF;
10952: -- invConv comment : g_is_mat_status_used = 1 == Material Status is USED

Line 11499: fnd_message.set_name('INV','INV-Cannot find node');

11495: End IF;
11496:
11497:
11498: IF l_found = FALSE THEN
11499: fnd_message.set_name('INV','INV-Cannot find node');
11500: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
11501: fnd_msg_pub.ADD;
11502: RAISE fnd_api.g_exc_unexpected_error;
11503: End IF;

Line 11500: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');

11496:
11497:
11498: IF l_found = FALSE THEN
11499: fnd_message.set_name('INV','INV-Cannot find node');
11500: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
11501: fnd_msg_pub.ADD;
11502: RAISE fnd_api.g_exc_unexpected_error;
11503: End IF;
11504:

Line 11672: fnd_message.set_name('INV', 'INV-Qtyroot not found');

11668: END IF;
11669:
11670: -- check if tree id is valid
11671: IF is_tree_valid(p_tree_id) = FALSE THEN
11672: fnd_message.set_name('INV', 'INV-Qtyroot not found');
11673: fnd_message.set_token('ROUTINE', 'Do_Check');
11674: fnd_msg_pub.ADD;
11675: RAISE fnd_api.g_exc_unexpected_error;
11676: END IF;

Line 11673: fnd_message.set_token('ROUTINE', 'Do_Check');

11669:
11670: -- check if tree id is valid
11671: IF is_tree_valid(p_tree_id) = FALSE THEN
11672: fnd_message.set_name('INV', 'INV-Qtyroot not found');
11673: fnd_message.set_token('ROUTINE', 'Do_Check');
11674: fnd_msg_pub.ADD;
11675: RAISE fnd_api.g_exc_unexpected_error;
11676: END IF;
11677:

Line 12671: fnd_message.set_name('INV', 'INV-Qtyroot not found');

12667:
12668: l_root_id := g_demand_info(p_tree_id).root_id;
12669: -- check if tree id is valid
12670: IF is_tree_valid(l_root_id) = FALSE THEN
12671: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12672: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12673: fnd_msg_pub.ADD;
12674: RAISE fnd_api.g_exc_unexpected_error;
12675: END IF;

Line 12672: fnd_message.set_token('ROUTINE', 'Update_Quantities');

12668: l_root_id := g_demand_info(p_tree_id).root_id;
12669: -- check if tree id is valid
12670: IF is_tree_valid(l_root_id) = FALSE THEN
12671: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12672: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12673: fnd_msg_pub.ADD;
12674: RAISE fnd_api.g_exc_unexpected_error;
12675: END IF;
12676:

Line 12958: fnd_message.set_name('INV', 'INV-Qtyroot not found');

12954: l_root_id := g_demand_info(p_tree_id).root_id;
12955:
12956: -- check if tree id is valid
12957: IF is_tree_valid(l_root_id) = FALSE THEN
12958: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12959: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12960: fnd_msg_pub.ADD;
12961: RAISE fnd_api.g_exc_unexpected_error;
12962: END IF;

Line 12959: fnd_message.set_token('ROUTINE', 'Update_Quantities');

12955:
12956: -- check if tree id is valid
12957: IF is_tree_valid(l_root_id) = FALSE THEN
12958: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12959: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12960: fnd_msg_pub.ADD;
12961: RAISE fnd_api.g_exc_unexpected_error;
12962: END IF;
12963:

Line 13128: fnd_message.set_name('INV', 'INV-Qtyroot not found');

13124: print_debug(l_api_name || ' Entered',9);
13125: END IF;
13126: l_root_id := g_demand_info(p_tree_id).root_id;
13127: IF is_tree_valid(l_root_id) = FALSE THEN
13128: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13129: fnd_message.set_token('ROUTINE', 'Backup_Tree');
13130: fnd_msg_pub.ADD;
13131: RAISE fnd_api.g_exc_error;
13132: END IF;

Line 13129: fnd_message.set_token('ROUTINE', 'Backup_Tree');

13125: END IF;
13126: l_root_id := g_demand_info(p_tree_id).root_id;
13127: IF is_tree_valid(l_root_id) = FALSE THEN
13128: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13129: fnd_message.set_token('ROUTINE', 'Backup_Tree');
13130: fnd_msg_pub.ADD;
13131: RAISE fnd_api.g_exc_error;
13132: END IF;
13133:

Line 13219: fnd_message.set_name('INV', 'INV-Qtyroot not found');

13215: END IF;
13216:
13217: l_root_id := g_demand_info(p_tree_id).root_id;
13218: IF is_saved_tree_valid(l_root_id) = FALSE THEN
13219: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13220: fnd_message.set_token('ROUTINE', 'Restore_Tree');
13221: fnd_msg_pub.ADD;
13222: RAISE fnd_api.g_exc_error;
13223: END IF;

Line 13220: fnd_message.set_token('ROUTINE', 'Restore_Tree');

13216:
13217: l_root_id := g_demand_info(p_tree_id).root_id;
13218: IF is_saved_tree_valid(l_root_id) = FALSE THEN
13219: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13220: fnd_message.set_token('ROUTINE', 'Restore_Tree');
13221: fnd_msg_pub.ADD;
13222: RAISE fnd_api.g_exc_error;
13223: END IF;
13224:

Line 13311: fnd_message.set_name('INV', 'INV-Qtyroot not found');

13307: END IF;
13308:
13309: l_root_id := g_demand_info(p_tree_id).root_id;
13310: IF is_tree_valid(l_root_id) = FALSE THEN
13311: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13312: fnd_message.set_token('ROUTINE', 'Backup_Tree');
13313: fnd_msg_pub.ADD;
13314: RAISE fnd_api.g_exc_error;
13315: END IF;

Line 13312: fnd_message.set_token('ROUTINE', 'Backup_Tree');

13308:
13309: l_root_id := g_demand_info(p_tree_id).root_id;
13310: IF is_tree_valid(l_root_id) = FALSE THEN
13311: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13312: fnd_message.set_token('ROUTINE', 'Backup_Tree');
13313: fnd_msg_pub.ADD;
13314: RAISE fnd_api.g_exc_error;
13315: END IF;
13316: