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.OE_CONFIG_TSO_PVT dependencies on OE_CONFIG_TSO_PVT

Line 1: PACKAGE BODY OE_CONFIG_TSO_PVT AS

1: PACKAGE BODY OE_CONFIG_TSO_PVT AS
2: /* $Header: OEXVTSOB.pls 120.17.12020000.2 2012/07/03 10:33:08 amallik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CONFIG_TSO_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CONFIG_TSO_PVT';

1: PACKAGE BODY OE_CONFIG_TSO_PVT AS
2: /* $Header: OEXVTSOB.pls 120.17.12020000.2 2012/07/03 10:33:08 amallik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CONFIG_TSO_PVT';
5:
6:
7: ------------------------------------------------------------------
8: -- Local Procedures and Function Declarations

Line 166: Print_Time('Entering OE_CONFIG_TSO_PVT.Is_Part_of_Container_Model..');

162: l_inventory_item_id NUMBER;
163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
164: BEGIN
165:
166: Print_Time('Entering OE_CONFIG_TSO_PVT.Is_Part_of_Container_Model..');
167:
168: l_top_model_line_id := p_top_model_line_id;
169: l_ato_line_id := p_ato_line_id;
170: l_inventory_item_id := p_inventory_item_id;

Line 259: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model..');

255: OE_DEBUG_PUB.Add('Top Container Model?:'||x_top_container_model,3);
256: OE_DEBUG_PUB.Add('Part of Container Model?:'||x_part_of_container,3);
257: END IF;
258:
259: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model..');
260:
261: RETURN;
262: END IF; -- inv item id is not null;
263:

Line 315: Print_Time('Exiting OE_CONFIG_TSO_PVT.Is_Part_of_Container_Model..');

311: IF l_debug_level > 0 THEN
312: OE_DEBUG_PUB.Add('Top Container Model?:'||x_top_container_model,3);
313: OE_DEBUG_PUB.Add('Part of Container Model?:'||x_part_of_container,3);
314: END IF;
315: Print_Time('Exiting OE_CONFIG_TSO_PVT.Is_Part_of_Container_Model..');
316:
317: RETURN;
318:
319: END IF;

Line 327: Print_Time('Exiting OE_CONFIG_TSO_PVT.Is_Part_of_Container_Model..');

323: IF l_debug_level > 0 THEN
324: OE_DEBUG_PUB.Add('Top Container Model?:'||x_top_container_model,3);
325: OE_DEBUG_PUB.Add('Part of Container Model?:'||x_part_of_container,3);
326: END IF;
327: Print_Time('Exiting OE_CONFIG_TSO_PVT.Is_Part_of_Container_Model..');
328:
329: EXCEPTION
330:
331: WHEN NO_DATA_FOUND THEN

Line 393: Print_Time('Entering OE_CONFIG_TSO_PVT.Validate_Container_model...');

389:
390: l_ib_trackable_flag VARCHAR2(1);
391: BEGIN
392:
393: Print_Time('Entering OE_CONFIG_TSO_PVT.Validate_Container_model...');
394:
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: IF l_debug_level > 0 THEN

Line 401: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model

397: IF l_debug_level > 0 THEN
398: OE_DEBUG_PUB.Add('Before Calling Is_Part_Of_Container_Model...',3);
399: END IF;
400:
401: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model
402: ( p_line_id => p_line_rec.line_id
403: ,p_top_model_line_id => p_line_rec.top_model_line_id
404: ,p_ato_line_id => p_line_rec.ato_line_id
405: ,p_inventory_item_id => p_line_rec.inventory_item_id

Line 451: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Validate_Container_Model...');

447: IF l_part_of_container_model = 'N' THEN
448: IF l_debug_level > 0 THEN
449: OE_DEBUG_PUB.Add('Not a part of container model, hence RETURNing',3);
450: END IF;
451: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Validate_Container_Model...');
452: RETURN;
453: END IF;
454:
455: -- Abghosh

Line 463: OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode

459: p_line_rec.ib_installed_at_location='INSTALL_BASE' OR
460: p_line_rec.ib_current_location='INSTALL_BASE') THEN
461:
462:
463: OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode
464: ( p_line_rec => p_line_rec
465: ,p_check_ibreconfig => 'Y'
466: ,x_config_mode => l_config_mode
467: ,x_return_status => l_x_return_status );

Line 720: Print_Time('Exiting OE_CONFIG_TSO_PVT.Validate_Container_Model...');

716: OE_DEBUG_PUB.Add('ERR:Validations violation for container model',3);
717: END IF;
718: END IF;
719:
720: Print_Time('Exiting OE_CONFIG_TSO_PVT.Validate_Container_Model...');
721:
722: EXCEPTION
723:
724: WHEN FND_API.G_EXC_ERROR THEN

Line 822: Print_Time('Entering OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode..');

818: l_ind VARCHAR2(1);
819: l_schema VARCHAR2(30);
820:
821: BEGIN
822: Print_Time('Entering OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode..');
823:
824: x_config_mode := null;
825:
826: BEGIN

Line 883: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');

879:
880: IF l_debug_level > 0 THEN
881: OE_DEBUG_PUB.Add('top model x_config_mode ' || x_config_mode, 1);
882: END IF;
883: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');
884: RETURN;
885:
886: ELSIF p_line_id is NOT NULL THEN
887:

Line 934: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');

930: IF l_debug_level > 0 THEN
931: OE_DEBUG_PUB.Add('p_line_id x_config_mode ' || x_config_mode, 1);
932: END IF;
933:
934: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');
935: RETURN;
936:
937: ELSIF p_line_rec.line_id is NOT NULL THEN
938:

Line 957: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');

953: OE_DEBUG_PUB.Add('ERR: At least one Config keys not present', 1);
954: END IF;
955: x_return_status := FND_API.G_RET_STS_ERROR;
956: x_config_mode := null;
957: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');
958: RETURN;
959: --RAISE FND_API.G_EXC_ERROR;
960: END IF;
961:

Line 1007: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');

1003: IF l_debug_level > 0 THEN
1004: OE_DEBUG_PUB.Add('p_line_rec x_config_mode ' || x_config_mode, 1);
1005: END IF;
1006:
1007: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');
1008: RETURN;
1009:
1010: END IF;
1011:

Line 1027: Print_Time('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode..');

1023: END IF;
1024: x_config_mode := 1;
1025: END IF;
1026:
1027: Print_Time('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode..');
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF l_debug_level > 0 THEN

Line 1108: Print_Time('Entering OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines...');

1104:
1105:
1106: BEGIN
1107:
1108: Print_Time('Entering OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines...');
1109:
1110: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model
1111: ( p_line_id => p_line_id
1112: ,p_top_model_line_id => p_top_model_line_id

Line 1110: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model

1106: BEGIN
1107:
1108: Print_Time('Entering OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines...');
1109:
1110: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model
1111: ( p_line_id => p_line_id
1112: ,p_top_model_line_id => p_top_model_line_id
1113: ,p_ato_line_id => p_ato_line_id
1114: ,p_inventory_item_id => NULL

Line 1138: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines');

1134: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NOT_CONTAINER');
1135: FND_MESSAGE.SET_TOKEN('ITEM_DESCRIPTION',l_description);
1136: OE_MSG_PUB.Add;
1137:
1138: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines');
1139: RETURN;
1140: END IF;
1141:
1142: --{ bug3611490 starts

Line 1236: Print_Time('Exiting OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines...');

1232: IF l_debug_level > 0 THEN
1233: OE_DEBUG_PUB.Add ('Csr Count 0. Skip OE_CONFIG_PVT.Process_Config',1);
1234: END IF;
1235: END IF;
1236: Print_Time('Exiting OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines...');
1237:
1238: EXCEPTION
1239:
1240: WHEN FND_API.G_EXC_ERROR THEN

Line 1313: Print_Time('Entering OE_CONFIG_TSO_PVT.Remove_Unchanged_Components...');

1309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1310:
1311: BEGIN
1312:
1313: Print_Time('Entering OE_CONFIG_TSO_PVT.Remove_Unchanged_Components...');
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315:
1316: --{ bug3611488 starts
1317: IF p_top_model_line_id IS NOT NULL THEN

Line 1327: OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines

1323: OE_DEBUG_PUB.Add('LineID:'||p_line_id,3);
1324: OE_DEBUG_PUB.Add('TopModel:'||p_top_model_line_id,3);
1325: END IF;
1326:
1327: OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines
1328: ( p_top_model_line_id => p_top_model_line_id
1329: ,p_line_id => p_line_id
1330: ,p_ato_line_id => p_ato_line_id
1331: ,x_msg_count => x_msg_count

Line 1356: OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines

1352: OE_DEBUG_PUB.Add('Line id:'||c_top_model.line_id,3);
1353: OE_DEBUG_PUB.Add('Top Model:'||c_top_model.top_model_line_id,3);
1354: END IF;
1355:
1356: OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines
1357: ( p_top_model_line_id => c_top_model.top_model_line_id
1358: ,p_line_id => c_top_model.line_id
1359: ,p_ato_line_id => c_top_model.ato_line_id
1360: ,x_msg_count => x_msg_count

Line 1374: Print_Time('Exiting OE_CONFIG_TSO_PVT.Remove_Unchanged_Components...');

1370: END LOOP;
1371:
1372: END IF;
1373:
1374: Print_Time('Exiting OE_CONFIG_TSO_PVT.Remove_Unchanged_Components...');
1375:
1376: END Remove_Unchanged_Components;
1377:
1378:

Line 1438: Print_Time ('Entering OE_CONFIG_TSO_PVT.populate_tso_order_lines...');

1434: l_config_effective_date DATE;
1435: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
1436: BEGIN
1437:
1438: Print_Time ('Entering OE_CONFIG_TSO_PVT.populate_tso_order_lines...');
1439: l_debug_level := oe_debug_pub.g_debug_level;
1440:
1441: IF l_debug_level > 0 THEN
1442: OE_DEBUG_PUB.Add('Top Model Line id:'||p_top_model_line_id,3);

Line 1748: Print_Time ('Exiting OE_CONFIG_TSO_PVT.populate_tso_order_lines..');

1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745: END IF;
1746:
1747: END LOOP;
1748: Print_Time ('Exiting OE_CONFIG_TSO_PVT.populate_tso_order_lines..');
1749: RETURN;
1750:
1751: END IF; --ending l_Config_mode = r
1752:

Line 1855: Print_Time ('Exiting OE_CONFIG_TSO_PVT.populate_tso_order_lines...');

1851: OE_MSG_PUB.Count_And_Get
1852: ( p_count => x_msg_count
1853: ,p_data => x_msg_data );
1854:
1855: Print_Time ('Exiting OE_CONFIG_TSO_PVT.populate_tso_order_lines...');
1856:
1857: EXCEPTION
1858:
1859: WHEN FND_API.G_EXC_ERROR THEN

Line 1948: oe_debug_pub.add('Entering oe_config_tso_pvt.Process_MACD_Order',1);

1944:
1945: BEGIN
1946:
1947: IF l_debug_level > 0 THEN
1948: oe_debug_pub.add('Entering oe_config_tso_pvt.Process_MACD_Order',1);
1949: oe_debug_pub.add('p_x_header_id : ' || p_x_header_id,2);
1950: oe_debug_pub.add('p_sold_to_org_id : ' || p_sold_to_org_id,2);
1951: oe_debug_pub.add('p_MACD_Action : ' || p_MACD_Action,2);
1952: oe_debug_pub.add('p_x_line_tbl : ' || p_x_line_tbl.count,2);

Line 2114: oe_config_tso_pvt.populate_tso_order_lines(

2110: END IF;
2111:
2112: IF p_Instance_Tbl.count > 0 THEN
2113:
2114: oe_config_tso_pvt.populate_tso_order_lines(
2115: p_header_id => p_x_header_id,
2116: p_top_model_line_id => null,
2117: p_instance_tbl => p_instance_tbl,
2118: p_mode => 1,

Line 2148: oe_debug_pub.add('Before calling oe_config_tso_pvt.create_tso_order_lines ',2);

2144:
2145: We will create an API named create_TSO_order_lines procedure to add the lines into existing order.*/
2146:
2147: IF l_debug_level > 0 THEN
2148: oe_debug_pub.add('Before calling oe_config_tso_pvt.create_tso_order_lines ',2);
2149: END IF;
2150:
2151: oe_config_tso_pvt.create_tso_order_lines(
2152: p_header_id => p_x_header_id,

Line 2151: oe_config_tso_pvt.create_tso_order_lines(

2147: IF l_debug_level > 0 THEN
2148: oe_debug_pub.add('Before calling oe_config_tso_pvt.create_tso_order_lines ',2);
2149: END IF;
2150:
2151: oe_config_tso_pvt.create_tso_order_lines(
2152: p_header_id => p_x_header_id,
2153: p_top_model_line_id => null,
2154: p_instance_tbl => p_instance_tbl,
2155: x_msg_count => x_msg_count,

Line 2160: oe_debug_pub.add('After calling oe_config_tso_pvt.create_tso_order_lines ' || x_return_status , 2);

2156: x_msg_data => x_msg_data,
2157: x_return_status => x_return_status);
2158:
2159: IF l_debug_level > 0 THEN
2160: oe_debug_pub.add('After calling oe_config_tso_pvt.create_tso_order_lines ' || x_return_status , 2);
2161: END IF;
2162:
2163:
2164: END IF; -- Sold to org.

Line 2240: oe_debug_pub.add('Exiting oe_config_tso_pvt.Process_MACD_Order ' || x_return_status,1);

2236: Oe_debug_pub.add('Return Status : ' || x_return_status,2);
2237: Oe_debug_pub.add('Message count : ' || x_msg_count,2);
2238: Oe_debug_pub.add('Message Data : ' || x_msg_data,2);
2239:
2240: oe_debug_pub.add('Exiting oe_config_tso_pvt.Process_MACD_Order ' || x_return_status,1);
2241: END IF;
2242: EXCEPTION
2243:
2244: WHEN FND_API.G_EXC_ERROR THEN

Line 2471: oe_config_tso_pvt.populate_tso_order_lines(

2467: l_instance_tbl.DELETE(I);
2468:
2469: oe_debug_pub.add('Before calling populate_tso_order_lines to append lines: ' ||
2470: l_parent_exists_instance_tbl.count,3);
2471: oe_config_tso_pvt.populate_tso_order_lines(
2472: p_header_id => p_header_id,
2473: p_top_model_line_id => l_top_model_line_id,
2474: p_instance_tbl => l_parent_exists_instance_tbl,
2475: p_mode => 1,

Line 2516: oe_config_tso_pvt.populate_tso_order_lines(

2512:
2513: -- We will come here only if have instances without parent. Call populate_tso_order_lines to create containers and its chiled lines.
2514: oe_debug_pub.add('Before calling populate_tso_order_line to create lines: ' ||
2515: l_no_parent_instance_tbl.count,2);
2516: oe_config_tso_pvt.populate_tso_order_lines(
2517: p_header_id =>p_header_id,
2518: p_top_model_line_id => null,
2519: p_instance_tbl => l_no_parent_instance_tbl,
2520: p_mode => 1,

Line 3534: END OE_CONFIG_TSO_PVT;

3530: END IF;
3531: END Validate_line_action;
3532:
3533:
3534: END OE_CONFIG_TSO_PVT;