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_UTIL dependencies on OE_GLOBALS

Line 120: l_control_rec OE_GLOBALS.Control_Rec_Type;

116: l_header_id NUMBER := 0;
117:
118:
119: -- process_order in variables
120: l_control_rec OE_GLOBALS.Control_Rec_Type;
121: l_header_rec OE_Order_PUB.Header_Rec_Type;
122: l_line_rec OE_ORDER_PUB.Line_Rec_Type
123: := OE_ORDER_PUB.G_MISS_LINE_REC;
124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 139: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS

135: AND open_flag = 'Y'
136: AND ((top_model_line_id = p_parent_line_id
137: and line_id <> p_parent_line_id)
138: OR
139: (l_item_type_code = OE_GLOBALS.G_ITEM_CLASS
140: and ato_line_id = p_parent_line_id
141: and line_id <> p_parent_line_id ));
142:
143: -- parent_line_id is either top_model_line_id for models and kits

Line 179: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN

175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178:
179: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN
180: l_model_actual_ship_date := l_parent_line_rec.actual_shipment_date;
181: l_model_qty := l_parent_line_rec.ordered_quantity;
182: END IF;
183:

Line 238: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

234: oe_debug_pub.add(L_NEW_QUANTITY || ' ' || L_ITEM_TYPE_CODE , 1);
235: END IF;
236:
237: IF l_new_quantity = 0 AND
238: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
239: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
240: THEN
241: IF l_debug_level > 0 THEN
242: oe_debug_pub.add('DO NOT SUPRESS SCHEDULING' , 3 );

Line 239: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)

235: END IF;
236:
237: IF l_new_quantity = 0 AND
238: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
239: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
240: THEN
241: IF l_debug_level > 0 THEN
242: oe_debug_pub.add('DO NOT SUPRESS SCHEDULING' , 3 );
243: END IF;

Line 253: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

249: -- 1. ordered quantity
250:
251: IF l_new_quantity = 0 AND
252: p_request_rec.param13 = 'N' AND
253: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
254: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
255: THEN
256: IF l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
257: IF l_debug_level > 0 THEN

Line 254: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)

250:
251: IF l_new_quantity = 0 AND
252: p_request_rec.param13 = 'N' AND
253: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
254: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
255: THEN
256: IF l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add('NEW QTY 0 ,NOT CANCELLATION ,SO DELETE',1);

Line 256: IF l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN

252: p_request_rec.param13 = 'N' AND
253: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
254: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
255: THEN
256: IF l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add('NEW QTY 0 ,NOT CANCELLATION ,SO DELETE',1);
259: END IF;
260: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;

Line 260: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;

256: IF l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add('NEW QTY 0 ,NOT CANCELLATION ,SO DELETE',1);
259: END IF;
260: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;
261: ELSE
262: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
263: END IF;
264:

Line 262: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

258: oe_debug_pub.add('NEW QTY 0 ,NOT CANCELLATION ,SO DELETE',1);
259: END IF;
260: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;
261: ELSE
262: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
263: END IF;
264:
265: ELSE -- cancellation
266:

Line 267: l_line_tbl(I).OPERATION := OE_GLOBALS.G_OPR_UPDATE;

263: END IF;
264:
265: ELSE -- cancellation
266:
267: l_line_tbl(I).OPERATION := OE_GLOBALS.G_OPR_UPDATE;
268:
269: -- if qty becomes 0, the options will get cancelled eventually.
270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add('REGULAR CODE , BIG ELSE' , 1);

Line 274: IF (l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CONFIG AND

270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add('REGULAR CODE , BIG ELSE' , 1);
272: END IF;
273:
274: IF (l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CONFIG AND
275: l_new_quantity = 0)
276: THEN
277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add('DO NOT CASCADE' , 3 );

Line 280: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

276: THEN
277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add('DO NOT CASCADE' , 3 );
279: END IF;
280: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
281: ELSE
282:
283: IF l_old_quantity <> l_new_quantity AND
284: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

Line 284: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

280: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
281: ELSE
282:
283: IF l_old_quantity <> l_new_quantity AND
284: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
285: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
286: THEN
287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add('CASCADE_CHANGES , OLD_ORD_QTY: '

Line 285: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)

281: ELSE
282:
283: IF l_old_quantity <> l_new_quantity AND
284: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
285: l_item_type_code = OE_GLOBALS.G_ITEM_KIT)
286: THEN
287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add('CASCADE_CHANGES , OLD_ORD_QTY: '
289: ||L_LINE_TBL (I).ORDERED_QUANTITY , 2 );

Line 432: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;

428:
429: l_control_rec.clear_api_cache := FALSE;
430: l_control_rec.clear_api_requests := FALSE;
431:
432: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
433:
434: -- Set the Recursive Call Constant to 'Y' to avoid the recursive
435: -- call to cascading while making this call to process order
436:

Line 537: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

533: ,x_return_status => l_return_status);
534:
535: END IF;
536:
537: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
538:
539: /* added for 2653505 */
540: IF OE_CODE_CONTROL.get_code_release_level < '110508' THEN
541: OE_ORDER_PVT.Process_Requests_And_notify

Line 623: l_control_rec OE_GLOBALS.Control_Rec_Type;

619: l_count NUMBER:=0;
620: l_header_id NUMBER := 0;
621:
622: -- Process Order Variables
623: l_control_rec OE_GLOBALS.Control_Rec_Type;
624: l_header_rec OE_Order_PUB.Header_Rec_Type;
625: l_line_rec OE_ORDER_PUB.Line_Rec_Type
626: := OE_ORDER_PUB.G_MISS_LINE_REC;
627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 706: l_line_rec.OPERATION := OE_GLOBALS.G_OPR_UPDATE;

702: -- Start Audit Trail
703: l_line_rec.change_reason := 'SYSTEM';
704: -- End Audit Trail
705:
706: l_line_rec.OPERATION := OE_GLOBALS.G_OPR_UPDATE;
707: l_count := l_count + 1;
708: l_line_tbl(l_count) := l_line_rec;
709: END LOOP;
710:

Line 738: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;

734:
735: l_control_rec.clear_api_cache := FALSE;
736: l_control_rec.clear_api_requests := FALSE;
737:
738: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
739:
740: -- Set the Change Configuration flag 'N' to avoid the recursive
741: -- call to changin configuration while making this call to process order
742: OE_GLOBALS.G_CHANGE_CFG_FLAG := 'N';

Line 742: OE_GLOBALS.G_CHANGE_CFG_FLAG := 'N';

738: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
739:
740: -- Set the Change Configuration flag 'N' to avoid the recursive
741: -- call to changin configuration while making this call to process order
742: OE_GLOBALS.G_CHANGE_CFG_FLAG := 'N';
743:
744: -- Set recursion mode.
745: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
746:

Line 745: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

741: -- call to changin configuration while making this call to process order
742: OE_GLOBALS.G_CHANGE_CFG_FLAG := 'N';
743:
744: -- Set recursion mode.
745: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
746:
747: -- Set the scheduling flag to 'N', do not schedule in a recursive call.
748: -- 4504362
749: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 771: OE_GLOBALS.G_CHANGE_CFG_FLAG := 'Y';

767: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
768: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
769:
770: -- Resetting the Change Configuration flag 'Y'
771: OE_GLOBALS.G_CHANGE_CFG_FLAG := 'Y';
772:
773: -- Resetting the Recursive Call Constant to 'N'
774: OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
775:

Line 777: --OE_GLOBALS.G_RECURSION_MODE := 'N';

773: -- Resetting the Recursive Call Constant to 'N'
774: OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG := 'N';
775:
776: -- ReSet recursion mode.
777: --OE_GLOBALS.G_RECURSION_MODE := 'N';
778:
779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 803: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

799: END IF;
800:
801: -- Setting G_CASCADING_REQUEST_LOGGED to requery the lines in the form
802: -- not reqd, done in vreqb.
803: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
804:
805: x_return_status := l_return_status;
806:
807: IF l_debug_level > 0 THEN

Line 823: l_control_rec OE_GLOBALS.Control_Rec_Type;

819: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
820: IS
821:
822: -- process_order in variables
823: l_control_rec OE_GLOBALS.Control_Rec_Type;
824: l_header_rec OE_Order_PUB.Header_Rec_Type;
825: l_line_rec OE_ORDER_PUB.Line_Rec_Type
826: := OE_ORDER_PUB.G_MISS_LINE_REC;
827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 930: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

926: END IF; */
927:
928: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
929: l_line_rec.line_id := p_line_id;
930: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
931: l_line_tbl(1) := l_line_rec;
932:
933: -- check_security is made false so that
934: -- we can delete the config line overriding the constraint.

Line 950: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;

946:
947: l_control_rec.clear_api_cache := FALSE;
948: l_control_rec.clear_api_requests := FALSE;
949:
950: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
951:
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add(' ' , 3 );
954: oe_debug_pub.add('IN DELINK_CONFIG CALLING PROCESS ORDER' , 3 );

Line 1083: WHERE item_type_code = OE_GLOBALS.G_ITEM_MODEL

1079: CURSOR models is
1080: SELECT line_id,config_header_id,config_rev_nbr,
1081: configuration_id,booked_flag
1082: FROM oe_order_lines
1083: WHERE item_type_code = OE_GLOBALS.G_ITEM_MODEL
1084: AND header_id = p_header_id
1085: AND open_flag = 'Y';
1086:
1087: --

Line 1229: WHERE item_type_code in (OE_GLOBALS.G_ITEM_MODEL,

1225:
1226: CURSOR order_lines is
1227: SELECT line_id
1228: FROM oe_order_lines
1229: WHERE item_type_code in (OE_GLOBALS.G_ITEM_MODEL,
1230: OE_GLOBALS.G_ITEM_CLASS,
1231: OE_GLOBALS.G_ITEM_KIT)
1232: AND open_flag = 'Y'
1233: AND header_id = p_header_id;

Line 1230: OE_GLOBALS.G_ITEM_CLASS,

1226: CURSOR order_lines is
1227: SELECT line_id
1228: FROM oe_order_lines
1229: WHERE item_type_code in (OE_GLOBALS.G_ITEM_MODEL,
1230: OE_GLOBALS.G_ITEM_CLASS,
1231: OE_GLOBALS.G_ITEM_KIT)
1232: AND open_flag = 'Y'
1233: AND header_id = p_header_id;
1234:

Line 1231: OE_GLOBALS.G_ITEM_KIT)

1227: SELECT line_id
1228: FROM oe_order_lines
1229: WHERE item_type_code in (OE_GLOBALS.G_ITEM_MODEL,
1230: OE_GLOBALS.G_ITEM_CLASS,
1231: OE_GLOBALS.G_ITEM_KIT)
1232: AND open_flag = 'Y'
1233: AND header_id = p_header_id;
1234:
1235: --

Line 2032: p_x_options_tbl(l_index).operation := OE_GLOBALS.G_OPR_DELETE;

2028:
2029: IF l_debug_level > 0 THEN
2030: oe_debug_pub.add('INDEX: '|| L_INDEX , 2 );
2031: END IF;
2032: p_x_options_tbl(l_index).operation := OE_GLOBALS.G_OPR_DELETE;
2033:
2034: EXCEPTION
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: IF l_debug_level > 0 THEN

Line 2050: IF l_req_rec.param3 = OE_GLOBALS.G_ITEM_CLASS THEN

2046: IF l_debug_level > 0 THEN
2047: oe_debug_pub.add('REGULAR CODE OF UPDATES'|| L_REQ_REC.PARAM3 , 1);
2048: END IF;
2049:
2050: IF l_req_rec.param3 = OE_GLOBALS.G_ITEM_CLASS THEN
2051:
2052: IF l_req_rec.param5 = 0 THEN
2053: l_ratio := 0;
2054: ELSE

Line 2108: IF l_req_rec.param3 = OE_GLOBALS.G_ITEM_CLASS THEN

2104: END IF;
2105:
2106: l_req_rec := l_deleted_options_tbl(I);
2107:
2108: IF l_req_rec.param3 = OE_GLOBALS.G_ITEM_CLASS THEN
2109: IF l_debug_level > 0 THEN
2110: oe_debug_pub.add('CLASS IS DELETED'|| L_REQ_REC.PARAM2 , 1);
2111: END IF;
2112:

Line 2190: AND p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_DELETE

2186: LOOP
2187: IF SUBSTR(p_x_options_tbl(I).component_code, 1, l_length )
2188: = p_component_code
2189: AND p_x_options_tbl(I).component_code <> p_component_code
2190: AND p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_DELETE
2191: THEN
2192: IF l_debug_level > 0 THEN
2193: oe_debug_pub.add('OPTION TO BE UPDATED '
2194: || P_X_OPTIONS_TBL (I).COMPONENT_CODE , 3 );

Line 2209: IF p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT THEN

2205: p_x_options_tbl(I).change_reason := p_change_reason;
2206: p_x_options_tbl(I).change_comments := p_change_comments;
2207:
2208: --added IF condition for bug# 4116813
2209: IF p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT THEN
2210: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
2211: END IF;
2212:
2213:

Line 2210: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;

2206: p_x_options_tbl(I).change_comments := p_change_comments;
2207:
2208: --added IF condition for bug# 4116813
2209: IF p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT THEN
2210: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
2211: END IF;
2212:
2213:
2214: END IF;

Line 2265: IF p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT

2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add('OPTION TO BE DELETED '
2263: || P_X_OPTIONS_TBL (I).COMPONENT_CODE , 3 );
2264: END IF;
2265: IF p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT
2266: THEN
2267: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;
2268: ELSE
2269: FND_MESSAGE.SET_NAME('ONT','ONT_CONFIG_INSERT_DELETE');

Line 2267: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;

2263: || P_X_OPTIONS_TBL (I).COMPONENT_CODE , 3 );
2264: END IF;
2265: IF p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_INSERT
2266: THEN
2267: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;
2268: ELSE
2269: FND_MESSAGE.SET_NAME('ONT','ONT_CONFIG_INSERT_DELETE');
2270: FND_MESSAGE.Set_Token('CLASS',p_parent_item);
2271: FND_MESSAGE.Set_Token('ITEM',p_x_options_tbl(I).ordered_item);

Line 2366: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;

2362: oe_debug_pub.add('PARENT TO BE DELETED '
2363: || P_X_OPTIONS_TBL (I).COMPONENT_CODE , 3 );
2364: END IF;
2365:
2366: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_DELETE;
2367:
2368: -- recursive call.
2369:
2370: IF l_debug_level > 0 THEN

Line 2477: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;

2473: || P_X_OPTIONS_TBL (I).COMPONENT_CODE , 3 );
2474: END IF;
2475:
2476:
2477: p_x_options_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
2478: p_x_options_tbl(I).ordered_quantity := 0;
2479: p_x_options_tbl(I).change_reason := 'SYSTEM';
2480:
2481: -- recursive call.

Line 2572: AND p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_DELETE

2568: = SUBSTR(p_component_code, 1,
2569: INSTR(p_component_code, '-', -1) - 1) -- same parent
2570: AND p_x_options_tbl(I).component_code <> l_parent
2571: AND p_x_options_tbl(I).component_code <> p_component_code
2572: AND p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_DELETE
2573: AND NOT(p_x_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE AND
2574: p_x_options_tbl(I).ordered_quantity = 0) -- cancel
2575:
2576: THEN

Line 2573: AND NOT(p_x_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE AND

2569: INSTR(p_component_code, '-', -1) - 1) -- same parent
2570: AND p_x_options_tbl(I).component_code <> l_parent
2571: AND p_x_options_tbl(I).component_code <> p_component_code
2572: AND p_x_options_tbl(I).operation <> OE_GLOBALS.G_OPR_DELETE
2573: AND NOT(p_x_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE AND
2574: p_x_options_tbl(I).ordered_quantity = 0) -- cancel
2575:
2576: THEN
2577: IF l_debug_level > 0 THEN

Line 2597: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

2593: SELECT /* MOAC_SQL_CHANGE */ count(*)
2594: INTO l_count
2595: FROM oe_order_lines_all
2596: WHERE top_model_line_id = p_top_model_line_id
2597: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
2598: AND open_flag = 'Y'
2599: AND link_to_line_id =
2600: (SELECT line_id
2601: FROM oe_order_lines_all

Line 2701: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END;
2699:
2700: OE_Msg_Pub.Set_Msg_Context
2701: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
2702: ,p_entity_id => p_model_line_id
2703: ,p_header_id => l_header_id
2704: ,p_line_id => p_model_line_id
2705: ,p_order_source_id => l_order_source_id

Line 2804: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

2800: ( p_count => l_msg_count
2801: , p_data => l_msg_data );
2802:
2803:
2804: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
2805:
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.VALIDATE_CONFIGURATION' , 1);
2808: END IF;

Line 4043: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED

4039: FROM OE_ORDER_LINES_ALL
4040: WHERE HEADER_ID = l_header_id AND
4041: TOP_MODEL_LINE_ID = l_top_model_line_id AND
4042: LINK_TO_LINE_ID = p_line_id AND
4043: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED
4044: ORDER BY line_number,shipment_number,nvl(option_number,-1);
4045:
4046: --
4047: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4177: l_control_rec OE_GLOBALS.Control_Rec_Type;

4173: RETURN VARCHAR2
4174: IS
4175:
4176: -- process_order in variables
4177: l_control_rec OE_GLOBALS.Control_Rec_Type;
4178: l_header_rec OE_Order_PUB.Header_Rec_Type;
4179: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4180: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4181: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4298: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

4294:
4295: l_parent_line_rec := p_line_rec;
4296:
4297: IF p_line_rec.line_id <> FND_API.G_MISS_NUM AND
4298: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4299: IF l_debug_level > 0 THEN
4300: oe_debug_pub.add('DO NOT LOCK' , 3 );
4301: END IF;
4302: ELSE

Line 4388: l_freeze_method := nvl(l_freeze_method, OE_GLOBALS.G_IIFM_ENTRY);

4384: IF l_debug_level > 0 THEN
4385: oe_debug_pub.add('METHOD: '|| L_FREEZE_METHOD , 4 );
4386: END IF;
4387: -- 4359339
4388: l_freeze_method := nvl(l_freeze_method, OE_GLOBALS.G_IIFM_ENTRY);
4389:
4390: IF l_parent_line_rec.creation_date is null OR
4391: l_freeze_method <> OE_GLOBALS.G_IIFM_ENTRY
4392: THEN

Line 4391: l_freeze_method <> OE_GLOBALS.G_IIFM_ENTRY

4387: -- 4359339
4388: l_freeze_method := nvl(l_freeze_method, OE_GLOBALS.G_IIFM_ENTRY);
4389:
4390: IF l_parent_line_rec.creation_date is null OR
4391: l_freeze_method <> OE_GLOBALS.G_IIFM_ENTRY
4392: THEN
4393: l_explosion_date := sysdate;
4394: ELSE
4395: l_explosion_date := l_parent_line_rec.creation_date;

Line 4485: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

4481: IF l_default_child_line THEN
4482:
4483: ------ 1. Insert new included items
4484: l_component_number := nvl(l_component_number, 0);
4485: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
4486: l_line_rec.item_identifier_type := 'INT';
4487: l_line_rec.option_number := l_parent_line_rec.option_number;
4488: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_INCLUDED;
4489: l_line_rec.top_model_line_id := l_parent_line_rec.top_model_line_id;

Line 4488: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_INCLUDED;

4484: l_component_number := nvl(l_component_number, 0);
4485: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
4486: l_line_rec.item_identifier_type := 'INT';
4487: l_line_rec.option_number := l_parent_line_rec.option_number;
4488: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_INCLUDED;
4489: l_line_rec.top_model_line_id := l_parent_line_rec.top_model_line_id;
4490: l_line_rec.link_to_line_id := l_parent_line_rec.line_id;
4491: l_line_rec.model_remnant_flag:= l_parent_line_rec.model_remnant_flag;
4492: l_line_rec.header_id := l_parent_line_rec.header_id;

Line 4631: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

4627: || L_TOP_MODEL_QUANTITY , 2 );
4628: END IF;
4629:
4630: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4631: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4632: l_line_rec.header_id := l_parent_line_rec.header_id;
4633:
4634: OPEN update_included_items
4635: (p_top_bill_sequence_id => l_parent_component_sequence_id,

Line 4665: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

4661: oe_debug_pub.add('TOP MODEL LINE:' || L_PARENT_LINE_REC.LINE_ID , 2 );
4662: END IF;
4663:
4664: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4665: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4666: l_line_rec.header_id := l_parent_line_rec.header_id;
4667:
4668: OPEN outdated_included_items
4669: (p_top_bill_sequence_id => l_parent_component_sequence_id,

Line 4696: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;

4692: oe_debug_pub.add('NO. OF LINES ' || TO_CHAR ( L_LINE_COUNT ) , 2 );
4693: END IF;
4694:
4695: IF l_line_count > 0 THEN
4696: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
4697: l_header_rec.header_id := l_parent_line_rec.header_id;
4698:
4699: IF l_debug_level > 0 THEN
4700: oe_debug_pub.add('CALLING PROCESS_ORDER' , 2 );

Line 4932: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

4928: ELSE
4929: l_line_rec := p_line_rec;
4930: END IF;
4931:
4932: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
4933: l_line_rec.ato_line_id = l_line_rec.line_id AND
4934: l_line_rec.top_model_line_id = l_line_rec.line_id -- redundent
4935: THEN
4936: IF l_debug_level > 0 THEN

Line 4998: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

4994: ELSE
4995: l_line_rec := p_line_rec;
4996: END IF;
4997:
4998: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
4999: l_line_rec.ato_line_id IS NULL AND
5000: l_line_rec.top_model_line_id = l_line_rec.line_id -- redundent
5001: THEN
5002: IF l_debug_level > 0 THEN

Line 5063: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

5059: ELSE
5060: l_line_rec := p_line_rec;
5061: END IF;
5062:
5063: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5064: THEN
5065: IF l_debug_level > 0 THEN
5066: oe_debug_pub.add('LEAVING IS_INCLUDED_OPTION FUNCTION ' , 1);
5067: END IF;

Line 5127: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG

5123: l_line_rec := p_line_rec;
5124: END IF;
5125:
5126:
5127: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
5128: THEN
5129: IF l_debug_level > 0 THEN
5130: oe_debug_pub.add('LEAVING IS_CONFIG_ITEM FUNCTION ' , 1);
5131: END IF;

Line 5190: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

5186: l_line_rec := p_line_rec;
5187: END IF;
5188:
5189:
5190: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
5191: l_line_rec.ato_line_id is not null AND
5192: l_line_rec.top_model_line_id = l_line_rec.ato_line_id
5193: -- not an ato under pto
5194: THEN

Line 5256: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

5252: ELSE
5253: l_line_rec := p_line_rec;
5254: END IF;
5255:
5256: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
5257: l_line_rec.ato_line_id is null
5258: THEN
5259: IF l_debug_level > 0 THEN
5260: oe_debug_pub.add('LEAVING IS_PTO_OPTION FUNCTION ' , 1);

Line 5319: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

5315: ELSE
5316: l_line_rec := p_line_rec;
5317: END IF;
5318:
5319: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
5320: l_line_rec.ato_line_id is not null AND
5321: l_line_rec.top_model_line_id = l_line_rec.ato_line_id
5322: -- not an ato under pto
5323: THEN

Line 5385: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

5381: ELSE
5382: l_line_rec := p_line_rec;
5383: END IF;
5384:
5385: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
5386: l_line_rec.ato_line_id is not null
5387: THEN
5388: IF l_debug_level > 0 THEN
5389: oe_debug_pub.add('LEAVING IS_PTO_CLASS FUNCTION ' , 1);

Line 5450: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

5446: l_line_rec := p_line_rec;
5447: END IF;
5448:
5449: -- what about subconfig options
5450: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
5451: l_line_rec.ato_line_id is not null AND
5452: l_line_rec.top_model_line_id <> l_line_rec.ato_line_id
5453: -- ato under pto
5454: THEN

Line 5515: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT

5511: ELSE
5512: l_line_rec := p_line_rec;
5513: END IF;
5514:
5515: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
5516: THEN
5517: IF l_debug_level > 0 THEN
5518: oe_debug_pub.add('LEAVING IS_KIT FUNCTION ' , 1);
5519: END IF;

Line 5577: IF (l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

5573: ELSE
5574: l_line_rec := p_line_rec;
5575: END IF;
5576:
5577: IF (l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
5578: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
5579: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED ) AND -- 9775352
5580: l_line_rec.ato_line_id = l_line_rec.line_id
5581: THEN

Line 5578: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

5574: l_line_rec := p_line_rec;
5575: END IF;
5576:
5577: IF (l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
5578: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
5579: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED ) AND -- 9775352
5580: l_line_rec.ato_line_id = l_line_rec.line_id
5581: THEN
5582: IF l_debug_level > 0 THEN

Line 5579: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED ) AND -- 9775352

5575: END IF;
5576:
5577: IF (l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
5578: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
5579: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED ) AND -- 9775352
5580: l_line_rec.ato_line_id = l_line_rec.line_id
5581: THEN
5582: IF l_debug_level > 0 THEN
5583: oe_debug_pub.add('LEAVING IS_ATO_ITEM FUNCTION ' , 1);

Line 5633: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED AND

5629: FROM OE_ORDER_LINES_ALL
5630: WHERE HEADER_ID = l_header_id
5631: AND (TOP_MODEL_LINE_ID = l_top_model_line_id OR
5632: ( LINK_TO_LINE_ID = p_link_to_line_id AND
5633: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED AND
5634: TOP_MODEL_LINE_ID = p_top_model_line_id) OR
5635: ( ATO_LINE_ID = p_ato_line_id AND
5636: TOP_MODEL_LINE_ID = p_top_model_line_id))
5637: ORDER BY line_number,shipment_number,nvl(option_number,-1);

Line 5797: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

5793: CURSOR comp_code_upd IS
5794: SELECT line_id, inventory_item_id, ordered_item, component_code
5795: FROM oe_order_lines
5796: WHERE top_model_line_id = p_top_model_line_id
5797: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
5798: AND open_flag = 'Y'
5799: AND (component_code is null OR
5800: component_sequence_id is null OR
5801: sort_order is null OR

Line 6178: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

6174: END IF;
6175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6176: END;
6177:
6178: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6179: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6180: l_ato_line_id = p_line_id THEN
6181:
6182: SELECT inventory_item_id,line_id,header_id,

Line 6179: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND

6175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6176: END;
6177:
6178: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6179: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6180: l_ato_line_id = p_line_id THEN
6181:
6182: SELECT inventory_item_id,line_id,header_id,
6183: RTRIM(line_number||'.'||shipment_number||'.'||

Line 6354: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

6350: INTO l_item_type_code,l_header_id, l_top_model_line_id, l_line_id
6351: FROM oe_order_lines
6352: WHERE line_id = oe_line_security.g_record.line_id;
6353:
6354: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6355: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
6357: THEN
6358: x_result := 0;

Line 6355: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR

6351: FROM oe_order_lines
6352: WHERE line_id = oe_line_security.g_record.line_id;
6353:
6354: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6355: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
6357: THEN
6358: x_result := 0;
6359: RETURN;

Line 6356: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

6352: WHERE line_id = oe_line_security.g_record.line_id;
6353:
6354: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6355: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
6357: THEN
6358: x_result := 0;
6359: RETURN;
6360: END IF;

Line 6362: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

6358: x_result := 0;
6359: RETURN;
6360: END IF;
6361:
6362: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6363: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6364: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6365: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6366: l_top_model_line_id <> l_line_id)

Line 6363: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

6359: RETURN;
6360: END IF;
6361:
6362: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6363: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6364: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6365: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6366: l_top_model_line_id <> l_line_id)
6367: THEN

Line 6364: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

6360: END IF;
6361:
6362: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6363: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6364: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6365: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6366: l_top_model_line_id <> l_line_id)
6367: THEN
6368: x_result := 1;

Line 6365: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

6361:
6362: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6363: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6364: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6365: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6366: l_top_model_line_id <> l_line_id)
6367: THEN
6368: x_result := 1;
6369: RETURN;

Line 6374: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

6370: END IF;
6371:
6372: l_count := 0;
6373:
6374: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6375: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6376: l_top_model_line_id = l_line_id)
6377: THEN
6378: SELECT count(*)

Line 6375: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

6371:
6372: l_count := 0;
6373:
6374: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6375: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6376: l_top_model_line_id = l_line_id)
6377: THEN
6378: SELECT count(*)
6379: INTO l_count

Line 6446: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

6442: l_valid := 1;
6443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6444: END;
6445:
6446: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6447: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6448: l_ato_line_id = p_line_id THEN
6449:
6450: l_valid := 0;

Line 6447: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND

6443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6444: END;
6445:
6446: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6447: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6448: l_ato_line_id = p_line_id THEN
6449:
6450: l_valid := 0;
6451:

Line 7657: p_x_child_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

7653: ---------------- for direct save only ------------------------
7654:
7655: IF p_direct_save THEN
7656:
7657: p_x_child_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
7658: p_x_child_line_rec.header_id := p_parent_line_rec.header_id;
7659: p_x_child_line_rec.top_model_line_id := p_parent_line_rec.line_id;
7660: p_x_child_line_rec.item_identifier_type := 'INT';
7661: p_x_child_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;

Line 7661: p_x_child_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;

7657: p_x_child_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
7658: p_x_child_line_rec.header_id := p_parent_line_rec.header_id;
7659: p_x_child_line_rec.top_model_line_id := p_parent_line_rec.line_id;
7660: p_x_child_line_rec.item_identifier_type := 'INT';
7661: p_x_child_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;
7662: p_x_child_line_rec.line_category_code
7663: := p_parent_line_rec.line_category_code;
7664: p_x_child_line_rec.creation_date := sysdate;
7665: p_x_child_line_rec.created_by := p_parent_line_rec.created_by;

Line 7806: IF p_x_child_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG AND

7802:
7803:
7804: --Begin- code to get user_item_description from the parent for the child
7805:
7806: IF p_x_child_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG AND
7807: p_x_child_line_rec.ato_line_id is not NULL AND
7808: p_x_child_line_rec.line_id <> p_x_child_line_rec.ato_line_id THEN
7809:
7810: IF l_debug_level > 0 THEN

Line 8037: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8033:
8034: --Added the if clause for bug 6892989/6903859
8035: IF ( nvl(p_booked_flag,'N') = 'Y' ) THEN
8036: OE_delayed_requests_Pvt.log_request
8037: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8038: p_entity_id => p_line_tbl(I).header_id,
8039: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8040: p_requesting_entity_id => p_line_tbl(I).header_id,
8041: p_request_unique_key1 => 'BATCH,BOOK',

Line 8039: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8035: IF ( nvl(p_booked_flag,'N') = 'Y' ) THEN
8036: OE_delayed_requests_Pvt.log_request
8037: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8038: p_entity_id => p_line_tbl(I).header_id,
8039: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8040: p_requesting_entity_id => p_line_tbl(I).header_id,
8041: p_request_unique_key1 => 'BATCH,BOOK',
8042: p_param1 => p_line_tbl(I).header_id,
8043: p_param2 => 'BATCH,BOOK',

Line 8044: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,

8040: p_requesting_entity_id => p_line_tbl(I).header_id,
8041: p_request_unique_key1 => 'BATCH,BOOK',
8042: p_param1 => p_line_tbl(I).header_id,
8043: p_param2 => 'BATCH,BOOK',
8044: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,
8045: x_return_status => l_return_status);
8046: ELSE
8047: OE_delayed_requests_Pvt.log_request
8048: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 8048: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8044: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,
8045: x_return_status => l_return_status);
8046: ELSE
8047: OE_delayed_requests_Pvt.log_request
8048: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8049: p_entity_id => p_line_tbl(I).header_id,
8050: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8051: p_requesting_entity_id => p_line_tbl(I).header_id,
8052: p_request_unique_key1 => 'BATCH',

Line 8050: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8046: ELSE
8047: OE_delayed_requests_Pvt.log_request
8048: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8049: p_entity_id => p_line_tbl(I).header_id,
8050: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8051: p_requesting_entity_id => p_line_tbl(I).header_id,
8052: p_request_unique_key1 => 'BATCH',
8053: p_param1 => p_line_tbl(I).header_id,
8054: p_param2 => 'BATCH',

Line 8055: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,

8051: p_requesting_entity_id => p_line_tbl(I).header_id,
8052: p_request_unique_key1 => 'BATCH',
8053: p_param1 => p_line_tbl(I).header_id,
8054: p_param2 => 'BATCH',
8055: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,
8056: x_return_status => l_return_status);
8057: END IF;
8058:
8059:

Line 8079: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER

8075: IF l_debug_level > 0 THEN
8076: oe_debug_pub.add('REN: ITEM TYPE CODE IS NOT INCLUDED OR CONFIG' , 1);
8077: END IF;
8078:
8079: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
8080: OE_delayed_requests_Pvt.log_request
8081: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8082: p_entity_id => p_line_tbl(I).line_id,
8083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 8081: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8077: END IF;
8078:
8079: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
8080: OE_delayed_requests_Pvt.log_request
8081: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8082: p_entity_id => p_line_tbl(I).line_id,
8083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8084: p_requesting_entity_id => p_line_tbl(I).line_id,
8085: p_request_type => OE_GLOBALS.g_tax_line,

Line 8083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8079: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
8080: OE_delayed_requests_Pvt.log_request
8081: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8082: p_entity_id => p_line_tbl(I).line_id,
8083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8084: p_requesting_entity_id => p_line_tbl(I).line_id,
8085: p_request_type => OE_GLOBALS.g_tax_line,
8086: x_return_status => l_return_status);
8087: --TaxER Start

Line 8085: p_request_type => OE_GLOBALS.g_tax_line,

8081: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8082: p_entity_id => p_line_tbl(I).line_id,
8083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8084: p_requesting_entity_id => p_line_tbl(I).line_id,
8085: p_request_type => OE_GLOBALS.g_tax_line,
8086: x_return_status => l_return_status);
8087: --TaxER Start
8088: ELSE
8089: OE_delayed_requests_Pvt.log_request

Line 8090: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8086: x_return_status => l_return_status);
8087: --TaxER Start
8088: ELSE
8089: OE_delayed_requests_Pvt.log_request
8090: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8091: p_entity_id => p_line_tbl(I).line_id,
8092: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8093: p_requesting_entity_id => p_line_tbl(I).line_id,
8094: p_request_type => OE_GLOBALS.g_tax_line,

Line 8092: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8088: ELSE
8089: OE_delayed_requests_Pvt.log_request
8090: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8091: p_entity_id => p_line_tbl(I).line_id,
8092: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8093: p_requesting_entity_id => p_line_tbl(I).line_id,
8094: p_request_type => OE_GLOBALS.g_tax_line,
8095: x_return_status => l_return_status);
8096: END IF;

Line 8094: p_request_type => OE_GLOBALS.g_tax_line,

8090: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8091: p_entity_id => p_line_tbl(I).line_id,
8092: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8093: p_requesting_entity_id => p_line_tbl(I).line_id,
8094: p_request_type => OE_GLOBALS.g_tax_line,
8095: x_return_status => l_return_status);
8096: END IF;
8097: --TaxER End
8098:

Line 8109: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8105: oe_debug_pub.add('LOGGING REQ TO CALC COMMITMENT' , 3 );
8106: END IF;
8107:
8108: OE_Delayed_Requests_Pvt.Log_Request
8109: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8110: p_entity_id => p_line_tbl(I).line_id,
8111: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8112: p_requesting_entity_id => p_line_tbl(I).line_id,
8113: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

Line 8111: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8107:
8108: OE_Delayed_Requests_Pvt.Log_Request
8109: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8110: p_entity_id => p_line_tbl(I).line_id,
8111: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8112: p_requesting_entity_id => p_line_tbl(I).line_id,
8113: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
8114: x_return_status => l_return_status);
8115: END IF;

Line 8113: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

8109: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8110: p_entity_id => p_line_tbl(I).line_id,
8111: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8112: p_requesting_entity_id => p_line_tbl(I).line_id,
8113: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
8114: x_return_status => l_return_status);
8115: END IF;
8116:
8117: IF p_booked_flag = 'Y' AND

Line 8124: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8120: IF l_debug_level > 0 THEN
8121: oe_debug_pub.add('LOGGING REQ TO VERIFY_PAYMENT' , 3 );
8122: END IF;
8123: OE_delayed_requests_Pvt.log_request
8124: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8125: p_entity_id => p_line_tbl(I).header_id,
8126: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8127: p_requesting_entity_id => p_line_tbl(I).line_id,
8128: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 8126: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8122: END IF;
8123: OE_delayed_requests_Pvt.log_request
8124: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8125: p_entity_id => p_line_tbl(I).header_id,
8126: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8127: p_requesting_entity_id => p_line_tbl(I).line_id,
8128: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
8129: x_return_status => l_return_status);
8130:

Line 8128: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

8124: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8125: p_entity_id => p_line_tbl(I).header_id,
8126: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8127: p_requesting_entity_id => p_line_tbl(I).line_id,
8128: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
8129: x_return_status => l_return_status);
8130:
8131: END IF;
8132:

Line 8145: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8141: ||P_LINE_TBL (I).HEADER_ID , 2 );
8142: END IF;
8143:
8144: OE_delayed_requests_Pvt.log_request
8145: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8146: p_entity_id => p_line_tbl(I).header_id,
8147: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8148: p_requesting_entity_id => p_line_tbl(I).line_id,
8149: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,

Line 8147: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8143:
8144: OE_delayed_requests_Pvt.log_request
8145: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8146: p_entity_id => p_line_tbl(I).header_id,
8147: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8148: p_requesting_entity_id => p_line_tbl(I).line_id,
8149: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,
8150: p_param1 => 'Y',
8151: x_return_status => l_return_status);

Line 8149: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,

8145: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8146: p_entity_id => p_line_tbl(I).header_id,
8147: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8148: p_requesting_entity_id => p_line_tbl(I).line_id,
8149: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,
8150: p_param1 => 'Y',
8151: x_return_status => l_return_status);
8152: END IF;
8153:

Line 8155: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN

8151: x_return_status => l_return_status);
8152: END IF;
8153:
8154: /* Below code has been added for bug 5925600 */
8155: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
8156:
8157: if l_debug_level > 0 then
8158: oe_debug_pub.add('Before checking if we need to log delayed request for G_CASCADE_OPTIONS_SERVICE', 5);
8159: oe_debug_pub.ADD('operation : '|| p_line_tbl(I).operation);

Line 8210: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8206: end if;
8207:
8208: OE_Delayed_Requests_Pvt.log_request
8209: (
8210: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8211: p_entity_id => p_line_tbl(I).line_id,
8212: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8213: p_requesting_entity_id => p_line_tbl(I).line_id,
8214: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,

Line 8212: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8208: OE_Delayed_Requests_Pvt.log_request
8209: (
8210: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8211: p_entity_id => p_line_tbl(I).line_id,
8212: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8213: p_requesting_entity_id => p_line_tbl(I).line_id,
8214: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,
8215: x_return_status => l_return_status
8216: );

Line 8214: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,

8210: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8211: p_entity_id => p_line_tbl(I).line_id,
8212: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8213: p_requesting_entity_id => p_line_tbl(I).line_id,
8214: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,
8215: x_return_status => l_return_status
8216: );
8217:
8218: END IF; /* l_serviced_model = 'Y' */

Line 8600: IF p_model_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

8596: END IF;
8597:
8598: ELSE
8599:
8600: IF p_model_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
8601:
8602: l_creation_date := sysdate;
8603: IF l_debug_level > 0 THEN
8604: OE_Debug_Pub.Add('model is getting created today', 3);

Line 8953: WHERE item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

8949:
8950:
8951: CURSOR C_PreExploded_Kit (c_top_model_line_id IN NUMBER) IS
8952: SELECT line_id FROM oe_order_lines_all
8953: WHERE item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
8954: AND top_model_line_id = c_top_model_line_id
8955: AND top_model_line_id <> line_id;
8956:
8957: CURSOR C_Bom_Explosion_Info (p_top_bill_sequence_id IN NUMBER,

Line 8972: be.explosion_type = OE_GLOBALS.G_ITEM_INCLUDED --'INCLUDED'

8968: null OM_Parent_Inventory_Item_id
8969: -- To OM fields, setting the NULL values so as to complete the record structure
8970: FROM bom_explosions be
8971: WHERE
8972: be.explosion_type = OE_GLOBALS.G_ITEM_INCLUDED --'INCLUDED'
8973: AND be.plan_level >= 0
8974: AND be.extended_quantity > 0
8975: AND be.TOP_BILL_SEQUENCE_ID = p_top_bill_sequence_id
8976: AND be.EFFECTIVITY_DATE <= p_std_comp_freeze_date

Line 8998: AND oel.item_type_code in (OE_GLOBALS.G_ITEM_CLASS,OE_GLOBALS.G_ITEM_KIT,OE_GLOBALS.G_ITEM_MODEL)

8994: FROM bom_bill_of_materials bom, oe_order_lines_all oel
8995: WHERE bom.ASSEMBLY_ITEM_ID = oel.inventory_item_id
8996: AND oel.top_model_line_id = p_top_model_line_id
8997: AND oel.header_id = p_header_id
8998: AND oel.item_type_code in (OE_GLOBALS.G_ITEM_CLASS,OE_GLOBALS.G_ITEM_KIT,OE_GLOBALS.G_ITEM_MODEL)
8999: AND bom.ORGANIZATION_ID = p_validation_org
9000: AND bom.ALTERNATE_BOM_DESIGNATOR IS NULL;
9001:
9002: -- comp_number is used to set the Component_Number column on OE_Order_Lines_All

Line 9010: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED;

9006: FROM oe_order_lines_all
9007: WHERE link_to_line_id = c_parent_line_id
9008: AND top_model_line_id = c_top_model_line_id
9009: AND header_id = c_header_id
9010: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED;
9011: --
9012: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9013: --
9014: BEGIN

Line 9036: IF l_parent_line_rec.item_type_code Not IN (OE_GLOBALS.G_ITEM_MODEL,OE_GLOBALS.G_ITEM_KIT)

9032:
9033: -- A top model parent line can either be a MODEL in a case of PTO or KIT
9034: -- in case of Kits. It cannot have any other values. If it is then no
9035: -- processing is required. RETURN from the code.
9036: IF l_parent_line_rec.item_type_code Not IN (OE_GLOBALS.G_ITEM_MODEL,OE_GLOBALS.G_ITEM_KIT)
9037: OR l_parent_line_rec.ordered_quantity = 0
9038: -- OR l_parent_line_rec.explosion_date is null
9039: THEN
9040: if l_debug_level > 0 then