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 2153: fnd_message.set_name('INV','INV_LOCK_MISSING_ARGS');

2149:
2150: --validate organization and inventory item
2151: IF (p_organization_id IS NULL OR p_inventory_item_id IS NULL) THEN
2152: --raise error condition
2153: fnd_message.set_name('INV','INV_LOCK_MISSING_ARGS');
2154: fnd_msg_pub.ADD;
2155: RAISE fnd_api.g_exc_error;
2156: END IF;
2157:

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

2172:
2173: --check for error cases
2174: IF (l_status NOT IN (0,4)) THEN
2175: if (l_status = 1) then -- timeout
2176: fnd_message.set_name('INV','INV_LOCK_TREE_TIMEOUT');
2177: fnd_msg_pub.ADD;
2178: RAISE fnd_api.g_exc_error;
2179: elsif (l_status = 2) then -- deadlock
2180: fnd_message.set_name('INV','INV_LOCK_TREE_DEADLOCK');

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

2176: fnd_message.set_name('INV','INV_LOCK_TREE_TIMEOUT');
2177: fnd_msg_pub.ADD;
2178: RAISE fnd_api.g_exc_error;
2179: elsif (l_status = 2) then -- deadlock
2180: fnd_message.set_name('INV','INV_LOCK_TREE_DEADLOCK');
2181: fnd_msg_pub.ADD;
2182: RAISE fnd_api.g_exc_error;
2183: else -- internal error - not fault of user
2184: fnd_message.set_name('INV','INV_LOCK_TREE_ERROR');

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

2180: fnd_message.set_name('INV','INV_LOCK_TREE_DEADLOCK');
2181: fnd_msg_pub.ADD;
2182: RAISE fnd_api.g_exc_error;
2183: else -- internal error - not fault of user
2184: fnd_message.set_name('INV','INV_LOCK_TREE_ERROR');
2185: fnd_msg_pub.ADD;
2186: RAISE fnd_api.g_exc_error;
2187: end if;
2188: END IF;

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

2254: --validate organization and inventory item
2255: IF (p_organization_id IS NULL OR
2256: p_inventory_item_id IS NULL) THEN
2257: --raise error condition
2258: fnd_message.set_name('INV','INV_LOCK_RELEASE_MISSING_ARGS');
2259: fnd_msg_pub.ADD;
2260: RAISE fnd_api.g_exc_error;
2261: END IF;
2262:

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

2271:
2272: --if success (status = 0) or session does not own lock (status=4), do nothing
2273: --if parameter error or illegal lock handle (internal error)
2274: if l_status IN (3,5) THEN
2275: fnd_message.set_name('INV','INV_LOCK_RELEASE_ERROR');
2276: fnd_msg_pub.ADD;
2277: RAISE fnd_api.g_exc_error;
2278: end if;
2279:

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

3136: AND p_locator_id IS NULL
3137: AND p_lpn_id IS NULL
3138: AND p_cost_group_id IS NULL
3139: THEN
3140: fnd_message.set_name('INV','INV-Cannot find node');
3141: fnd_message.set_token('ROUTINE', 'Find_Child_Node');
3142: fnd_msg_pub.ADD;
3143: RAISE fnd_api.g_exc_error;
3144: END IF;

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

3137: AND p_lpn_id IS NULL
3138: AND p_cost_group_id IS NULL
3139: THEN
3140: fnd_message.set_name('INV','INV-Cannot find node');
3141: fnd_message.set_token('ROUTINE', 'Find_Child_Node');
3142: fnd_msg_pub.ADD;
3143: RAISE fnd_api.g_exc_error;
3144: END IF;
3145:

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

3280: * RAISE fnd_api.g_exc_unexpected_error;
3281: * End IF;
3282: *
3283: * IF l_found = FALSE THEN
3284: * fnd_message.set_name('INV','INV-Cannot find node');
3285: * fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3286: * fnd_msg_pub.ADD;
3287: * RAISE fnd_api.g_exc_unexpected_error;
3288: * End IF;

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

3281: * End IF;
3282: *
3283: * IF l_found = FALSE THEN
3284: * fnd_message.set_name('INV','INV-Cannot find node');
3285: * fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3286: * fnd_msg_pub.ADD;
3287: * RAISE fnd_api.g_exc_unexpected_error;
3288: * End IF;
3289: *

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

3320: RAISE fnd_api.g_exc_unexpected_error;
3321: End IF;
3322:
3323: IF l_found = FALSE THEN
3324: fnd_message.set_name('INV','INV-Cannot find node');
3325: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3326: fnd_msg_pub.ADD;
3327: RAISE fnd_api.g_exc_unexpected_error;
3328: End IF;

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

3321: End IF;
3322:
3323: IF l_found = FALSE THEN
3324: fnd_message.set_name('INV','INV-Cannot find node');
3325: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3326: fnd_msg_pub.ADD;
3327: RAISE fnd_api.g_exc_unexpected_error;
3328: End IF;
3329:

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

3374: RAISE fnd_api.g_exc_unexpected_error;
3375: End IF;
3376:
3377: IF l_found = FALSE THEN
3378: fnd_message.set_name('INV','INV-Cannot find node');
3379: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3380: fnd_msg_pub.ADD;
3381: RAISE fnd_api.g_exc_unexpected_error;
3382: End IF;

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

3375: End IF;
3376:
3377: IF l_found = FALSE THEN
3378: fnd_message.set_name('INV','INV-Cannot find node');
3379: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3380: fnd_msg_pub.ADD;
3381: RAISE fnd_api.g_exc_unexpected_error;
3382: End IF;
3383:

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

3427: RAISE fnd_api.g_exc_unexpected_error;
3428: End IF;
3429:
3430: IF l_found = FALSE THEN
3431: fnd_message.set_name('INV','INV-Cannot find node');
3432: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3433: fnd_msg_pub.ADD;
3434: RAISE fnd_api.g_exc_unexpected_error;
3435: End IF;

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

3428: End IF;
3429:
3430: IF l_found = FALSE THEN
3431: fnd_message.set_name('INV','INV-Cannot find node');
3432: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3433: fnd_msg_pub.ADD;
3434: RAISE fnd_api.g_exc_unexpected_error;
3435: End IF;
3436:

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

3480: RAISE fnd_api.g_exc_unexpected_error;
3481: End IF;
3482:
3483: IF l_found = FALSE THEN
3484: fnd_message.set_name('INV','INV-Cannot find node');
3485: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3486: fnd_msg_pub.ADD;
3487: RAISE fnd_api.g_exc_unexpected_error;
3488: End IF;

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

3481: End IF;
3482:
3483: IF l_found = FALSE THEN
3484: fnd_message.set_name('INV','INV-Cannot find node');
3485: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3486: fnd_msg_pub.ADD;
3487: RAISE fnd_api.g_exc_unexpected_error;
3488: End IF;
3489:

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

3533: RAISE fnd_api.g_exc_unexpected_error;
3534: End IF;
3535:
3536: IF l_found = FALSE THEN
3537: fnd_message.set_name('INV','INV-Cannot find node');
3538: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3539: fnd_msg_pub.ADD;
3540: RAISE fnd_api.g_exc_unexpected_error;
3541: End IF;

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

3534: End IF;
3535:
3536: IF l_found = FALSE THEN
3537: fnd_message.set_name('INV','INV-Cannot find node');
3538: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
3539: fnd_msg_pub.ADD;
3540: RAISE fnd_api.g_exc_unexpected_error;
3541: End IF;
3542:

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

3887: AND p_quantity_type <> g_qr_other_demand
3888: AND p_quantity_type <> g_qs_txn THEN
3889: -- invalid p_quantity_type. the caller's fault
3890: print_debug('... error=INVALID_QUANTITY_TYPE');
3891: fnd_message.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');
3892: fnd_msg_pub.ADD;
3893: RAISE fnd_api.g_exc_error;
3894: END IF;
3895:

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

3933: RAISE fnd_api.g_exc_unexpected_error;
3934: END IF;
3935:
3936: IF l_found = FALSE THEN
3937: fnd_message.set_name('INV','INV-Cannot find node');
3938: fnd_message.set_token('ROUTINE', 'Add_Quantities');
3939: fnd_msg_pub.ADD;
3940: RAISE fnd_api.g_exc_unexpected_error;
3941: End IF;

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

3934: END IF;
3935:
3936: IF l_found = FALSE THEN
3937: fnd_message.set_name('INV','INV-Cannot find node');
3938: fnd_message.set_token('ROUTINE', 'Add_Quantities');
3939: fnd_msg_pub.ADD;
3940: RAISE fnd_api.g_exc_unexpected_error;
3941: End IF;
3942:

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

3960: AND g_nodes(l_node_index).node_level <> g_sub_level
3961: AND g_nodes(l_node_index).node_level <> g_lpn_level
3962: THEN
3963: print_debug('... error=INV-WRONG_LEVEL');
3964: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');
3965: fnd_msg_pub.ADD;
3966: RAISE fnd_api.g_exc_error;
3967: End IF;
3968:

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

4425: AND g_nodes(l_node_index).node_level <> g_cost_group_level
4426: AND g_nodes(l_node_index).node_level <> g_sub_level
4427: AND g_nodes(l_node_index).node_level <> g_lpn_level
4428: THEN
4429: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');
4430: fnd_msg_pub.ADD;
4431: RAISE fnd_api.g_exc_error;
4432: End IF;
4433:

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

9493:
9494: l_root_id := g_demand_info(p_tree_id).root_id;
9495: -- check if tree id is valid
9496: IF is_tree_valid(l_root_id) = FALSE THEN
9497: fnd_message.set_name('INV', 'INV-Qtyroot not found');
9498: fnd_message.set_token('ROUTINE', 'Query_Tree');
9499: fnd_msg_pub.ADD;
9500: RAISE fnd_api.g_exc_error;
9501: END IF;

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

9494: l_root_id := g_demand_info(p_tree_id).root_id;
9495: -- check if tree id is valid
9496: IF is_tree_valid(l_root_id) = FALSE THEN
9497: fnd_message.set_name('INV', 'INV-Qtyroot not found');
9498: fnd_message.set_token('ROUTINE', 'Query_Tree');
9499: fnd_msg_pub.ADD;
9500: RAISE fnd_api.g_exc_error;
9501: END IF;
9502:

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

9595: RAISE fnd_api.g_exc_unexpected_error;
9596: End IF;
9597:
9598: IF l_found = FALSE THEN
9599: fnd_message.set_name('INV','INV-Cannot find node');
9600: fnd_message.set_token('ROUTINE', 'Query_Tree');
9601: fnd_msg_pub.ADD;
9602: RAISE fnd_api.g_exc_unexpected_error;
9603: End IF;

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

9596: End IF;
9597:
9598: IF l_found = FALSE THEN
9599: fnd_message.set_name('INV','INV-Cannot find node');
9600: fnd_message.set_token('ROUTINE', 'Query_Tree');
9601: fnd_msg_pub.ADD;
9602: RAISE fnd_api.g_exc_unexpected_error;
9603: End IF;
9604:

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

10396: print_debug('In create_tree. p_demand_source_type_id='||p_demand_source_type_id||', p_demand_source_header_id='||p_demand_source_header_id
10397: ||', p_demand_source_line_id='||p_demand_source_line_id);
10398: IF p_tree_mode IN (g_transaction_mode, g_loose_only_mode) THEN
10399: IF p_demand_source_type_id IS NULL THEN
10400: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
10401: fnd_msg_pub.ADD;
10402: RAISE fnd_api.g_exc_error;
10403: END IF;
10404:

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

10403: END IF;
10404:
10405: IF p_demand_source_header_id IS NULL THEN
10406: IF p_demand_source_name IS NULL THEN
10407: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
10408: fnd_msg_pub.ADD;
10409: RAISE fnd_api.g_exc_error;
10410: END IF;
10411: END IF;

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

10411: END IF;
10412:
10413: IF p_demand_source_header_id IS NULL
10414: AND p_demand_source_line_id IS NOT NULL THEN
10415: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
10416: fnd_msg_pub.ADD;
10417: RAISE fnd_api.g_exc_error;
10418: END IF;
10419: END IF;

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

10433: THEN
10434: print_debug(' get_item_details NOTFOUND for org='||p_organization_id||', item='||p_inventory_item_id);
10435: CLOSE get_item_details;
10436: -- The item doesn't exist under this organization.
10437: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
10438: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
10439: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
10440: FND_MSG_PUB.ADD;
10441: RAISE FND_API.G_EXC_ERROR;

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

10434: print_debug(' get_item_details NOTFOUND for org='||p_organization_id||', item='||p_inventory_item_id);
10435: CLOSE get_item_details;
10436: -- The item doesn't exist under this organization.
10437: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
10438: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
10439: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
10440: FND_MSG_PUB.ADD;
10441: RAISE FND_API.G_EXC_ERROR;
10442: END IF;

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

10435: CLOSE get_item_details;
10436: -- The item doesn't exist under this organization.
10437: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
10438: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
10439: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
10440: FND_MSG_PUB.ADD;
10441: RAISE FND_API.G_EXC_ERROR;
10442: END IF;
10443: -- invConv comment : g_is_mat_status_used = 1 == Material Status is USED

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

10975: End IF;
10976:
10977:
10978: IF l_found = FALSE THEN
10979: fnd_message.set_name('INV','INV-Cannot find node');
10980: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
10981: fnd_msg_pub.ADD;
10982: RAISE fnd_api.g_exc_unexpected_error;
10983: End IF;

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

10976:
10977:
10978: IF l_found = FALSE THEN
10979: fnd_message.set_name('INV','INV-Cannot find node');
10980: fnd_message.set_token('ROUTINE', 'Find_Tree_Node');
10981: fnd_msg_pub.ADD;
10982: RAISE fnd_api.g_exc_unexpected_error;
10983: End IF;
10984:

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

11150: END IF;
11151:
11152: -- check if tree id is valid
11153: IF is_tree_valid(p_tree_id) = FALSE THEN
11154: fnd_message.set_name('INV', 'INV-Qtyroot not found');
11155: fnd_message.set_token('ROUTINE', 'Do_Check');
11156: fnd_msg_pub.ADD;
11157: RAISE fnd_api.g_exc_unexpected_error;
11158: END IF;

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

11151:
11152: -- check if tree id is valid
11153: IF is_tree_valid(p_tree_id) = FALSE THEN
11154: fnd_message.set_name('INV', 'INV-Qtyroot not found');
11155: fnd_message.set_token('ROUTINE', 'Do_Check');
11156: fnd_msg_pub.ADD;
11157: RAISE fnd_api.g_exc_unexpected_error;
11158: END IF;
11159:

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

11650: * Invalidate_tree checks this condition, but doesn't return error.
11651: * There's no need for error. So, commenting out code
11652: *-- check if tree id is valid
11653: *IF is_tree_valid(p_tree_id) = FALSE THEN
11654: * fnd_message.set_name('INV', 'INV-Qtyroot not found');
11655: * fnd_message.set_token('ROUTINE', 'Free_Tree');
11656: * fnd_msg_pub.ADD;
11657: * RAISE fnd_api.g_exc_unexpected_error;
11658: *END IF;

Line 11655: * fnd_message.set_token('ROUTINE', 'Free_Tree');

11651: * There's no need for error. So, commenting out code
11652: *-- check if tree id is valid
11653: *IF is_tree_valid(p_tree_id) = FALSE THEN
11654: * fnd_message.set_name('INV', 'INV-Qtyroot not found');
11655: * fnd_message.set_token('ROUTINE', 'Free_Tree');
11656: * fnd_msg_pub.ADD;
11657: * RAISE fnd_api.g_exc_unexpected_error;
11658: *END IF;
11659: */

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

12196:
12197: l_root_id := g_demand_info(p_tree_id).root_id;
12198: -- check if tree id is valid
12199: IF is_tree_valid(l_root_id) = FALSE THEN
12200: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12201: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12202: fnd_msg_pub.ADD;
12203: RAISE fnd_api.g_exc_unexpected_error;
12204: END IF;

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

12197: l_root_id := g_demand_info(p_tree_id).root_id;
12198: -- check if tree id is valid
12199: IF is_tree_valid(l_root_id) = FALSE THEN
12200: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12201: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12202: fnd_msg_pub.ADD;
12203: RAISE fnd_api.g_exc_unexpected_error;
12204: END IF;
12205:

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

12482: l_root_id := g_demand_info(p_tree_id).root_id;
12483:
12484: -- check if tree id is valid
12485: IF is_tree_valid(l_root_id) = FALSE THEN
12486: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12487: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12488: fnd_msg_pub.ADD;
12489: RAISE fnd_api.g_exc_unexpected_error;
12490: END IF;

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

12483:
12484: -- check if tree id is valid
12485: IF is_tree_valid(l_root_id) = FALSE THEN
12486: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12487: fnd_message.set_token('ROUTINE', 'Update_Quantities');
12488: fnd_msg_pub.ADD;
12489: RAISE fnd_api.g_exc_unexpected_error;
12490: END IF;
12491:

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

12651: print_debug(l_api_name || ' Entered',9);
12652: END IF;
12653: l_root_id := g_demand_info(p_tree_id).root_id;
12654: IF is_tree_valid(l_root_id) = FALSE THEN
12655: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12656: fnd_message.set_token('ROUTINE', 'Backup_Tree');
12657: fnd_msg_pub.ADD;
12658: RAISE fnd_api.g_exc_error;
12659: END IF;

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

12652: END IF;
12653: l_root_id := g_demand_info(p_tree_id).root_id;
12654: IF is_tree_valid(l_root_id) = FALSE THEN
12655: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12656: fnd_message.set_token('ROUTINE', 'Backup_Tree');
12657: fnd_msg_pub.ADD;
12658: RAISE fnd_api.g_exc_error;
12659: END IF;
12660:

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

12742: END IF;
12743:
12744: l_root_id := g_demand_info(p_tree_id).root_id;
12745: IF is_saved_tree_valid(l_root_id) = FALSE THEN
12746: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12747: fnd_message.set_token('ROUTINE', 'Restore_Tree');
12748: fnd_msg_pub.ADD;
12749: RAISE fnd_api.g_exc_error;
12750: END IF;

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

12743:
12744: l_root_id := g_demand_info(p_tree_id).root_id;
12745: IF is_saved_tree_valid(l_root_id) = FALSE THEN
12746: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12747: fnd_message.set_token('ROUTINE', 'Restore_Tree');
12748: fnd_msg_pub.ADD;
12749: RAISE fnd_api.g_exc_error;
12750: END IF;
12751:

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

12834: END IF;
12835:
12836: l_root_id := g_demand_info(p_tree_id).root_id;
12837: IF is_tree_valid(l_root_id) = FALSE THEN
12838: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12839: fnd_message.set_token('ROUTINE', 'Backup_Tree');
12840: fnd_msg_pub.ADD;
12841: RAISE fnd_api.g_exc_error;
12842: END IF;

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

12835:
12836: l_root_id := g_demand_info(p_tree_id).root_id;
12837: IF is_tree_valid(l_root_id) = FALSE THEN
12838: fnd_message.set_name('INV', 'INV-Qtyroot not found');
12839: fnd_message.set_token('ROUTINE', 'Backup_Tree');
12840: fnd_msg_pub.ADD;
12841: RAISE fnd_api.g_exc_error;
12842: END IF;
12843:

Line 13140: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13136: , p_message => l_buf
13137: );
13138:
13139: IF l_rval <> 0 THEN
13140: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13141: fnd_msg_pub.add;
13142: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13143: -- || 'Error code is '||To_char(l_rval));
13144: RAISE fnd_api.g_exc_error;

Line 13175: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13171: , p_message => l_buf
13172: );
13173:
13174: IF l_rval <> 0 THEN
13175: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13176: fnd_msg_pub.add;
13177: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13178: -- || 'Error code is '||To_char(l_rval));
13179: RAISE fnd_api.g_exc_error;

Line 13289: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13285: , p_message => l_buf
13286: );
13287:
13288: IF l_rval <> 0 THEN
13289: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13290: fnd_msg_pub.add;
13291: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13292: -- || 'Error code is '||To_char(l_rval));
13293: RAISE fnd_api.g_exc_error;

Line 13318: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13314: , p_message => l_buf
13315: );
13316:
13317: IF l_rval <> 0 THEN
13318: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13319: fnd_msg_pub.add;
13320: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13321: -- || 'Error code is '||To_char(l_rval));
13322: RAISE fnd_api.g_exc_error;

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

13349: BEGIN
13350: -- dbm_output.put_line('Dumping Tree: '||To_char(p_tree_id));
13351: -- check if tree id is valid
13352: IF is_tree_valid(p_tree_id) = FALSE THEN
13353: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13354: fnd_message.set_token('ROUTINE', 'Dump_Tree_To_DB_Pipe');
13355: fnd_msg_pub.ADD;
13356: RAISE fnd_api.g_exc_error;
13357: END IF;

Line 13354: fnd_message.set_token('ROUTINE', 'Dump_Tree_To_DB_Pipe');

13350: -- dbm_output.put_line('Dumping Tree: '||To_char(p_tree_id));
13351: -- check if tree id is valid
13352: IF is_tree_valid(p_tree_id) = FALSE THEN
13353: fnd_message.set_name('INV', 'INV-Qtyroot not found');
13354: fnd_message.set_token('ROUTINE', 'Dump_Tree_To_DB_Pipe');
13355: fnd_msg_pub.ADD;
13356: RAISE fnd_api.g_exc_error;
13357: END IF;
13358:

Line 13381: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13377: , p_message => '.' -- no more to come, used as a separator
13378: );
13379:
13380: IF l_rval <> 0 THEN
13381: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13382: fnd_msg_pub.add;
13383: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13384: -- || 'Error code is '||To_char(l_rval));
13385: RAISE fnd_api.g_exc_error;

Line 13434: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13430: , p_message => l_buf
13431: );
13432:
13433: IF l_rval <> 0 THEN
13434: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13435: fnd_msg_pub.add;
13436: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13437: -- || 'Error code is '||To_char(l_rval));
13438: RAISE fnd_api.g_exc_error;

Line 13462: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13458: , p_message => l_buf
13459: );
13460:
13461: IF l_rval <> 0 THEN
13462: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13463: fnd_msg_pub.add;
13464: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13465: -- || 'Error code is '||To_char(l_rval));
13466: RAISE fnd_api.g_exc_error;

Line 13476: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');

13472: , p_message => '.' -- no more to come, used as a separator
13473: );
13474:
13475: IF l_rval <> 0 THEN
13476: fnd_message.set_name('INV', 'INV-FAILED_TO_SEND_MESSAGE');
13477: fnd_msg_pub.add;
13478: -- dbm_output.put_line('Error: failed to send message to the pipe.'
13479: -- || 'Error code is '||To_char(l_rval));
13480: RAISE fnd_api.g_exc_error;