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.

[Home] [Help]

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 2030: p_x_options_tbl(l_index).operation := OE_GLOBALS.G_OPR_DELETE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2595: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

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

Line 2699: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

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

Line 2802: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

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

Line 4037: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED

4033: FROM OE_ORDER_LINES_ALL
4034: WHERE HEADER_ID = l_header_id AND
4035: TOP_MODEL_LINE_ID = l_top_model_line_id AND
4036: LINK_TO_LINE_ID = p_line_id AND
4037: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED
4038: ORDER BY line_number,shipment_number,nvl(option_number,-1);
4039:
4040: --
4041: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4171: l_control_rec OE_GLOBALS.Control_Rec_Type;

4167: RETURN VARCHAR2
4168: IS
4169:
4170: -- process_order in variables
4171: l_control_rec OE_GLOBALS.Control_Rec_Type;
4172: l_header_rec OE_Order_PUB.Header_Rec_Type;
4173: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4174: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4175: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4292: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

4288:
4289: l_parent_line_rec := p_line_rec;
4290:
4291: IF p_line_rec.line_id <> FND_API.G_MISS_NUM AND
4292: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4293: IF l_debug_level > 0 THEN
4294: oe_debug_pub.add('DO NOT LOCK' , 3 );
4295: END IF;
4296: ELSE

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

4378: IF l_debug_level > 0 THEN
4379: oe_debug_pub.add('METHOD: '|| L_FREEZE_METHOD , 4 );
4380: END IF;
4381: -- 4359339
4382: l_freeze_method := nvl(l_freeze_method, OE_GLOBALS.G_IIFM_ENTRY);
4383:
4384: IF l_parent_line_rec.creation_date is null OR
4385: l_freeze_method <> OE_GLOBALS.G_IIFM_ENTRY
4386: THEN

Line 4385: l_freeze_method <> OE_GLOBALS.G_IIFM_ENTRY

4381: -- 4359339
4382: l_freeze_method := nvl(l_freeze_method, OE_GLOBALS.G_IIFM_ENTRY);
4383:
4384: IF l_parent_line_rec.creation_date is null OR
4385: l_freeze_method <> OE_GLOBALS.G_IIFM_ENTRY
4386: THEN
4387: l_explosion_date := sysdate;
4388: ELSE
4389: l_explosion_date := l_parent_line_rec.creation_date;

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

4475: IF l_default_child_line THEN
4476:
4477: ------ 1. Insert new included items
4478: l_component_number := nvl(l_component_number, 0);
4479: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
4480: l_line_rec.item_identifier_type := 'INT';
4481: l_line_rec.option_number := l_parent_line_rec.option_number;
4482: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_INCLUDED;
4483: l_line_rec.top_model_line_id := l_parent_line_rec.top_model_line_id;

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

4478: l_component_number := nvl(l_component_number, 0);
4479: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
4480: l_line_rec.item_identifier_type := 'INT';
4481: l_line_rec.option_number := l_parent_line_rec.option_number;
4482: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_INCLUDED;
4483: l_line_rec.top_model_line_id := l_parent_line_rec.top_model_line_id;
4484: l_line_rec.link_to_line_id := l_parent_line_rec.line_id;
4485: l_line_rec.model_remnant_flag:= l_parent_line_rec.model_remnant_flag;
4486: l_line_rec.header_id := l_parent_line_rec.header_id;

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

4621: || L_TOP_MODEL_QUANTITY , 2 );
4622: END IF;
4623:
4624: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4625: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4626: l_line_rec.header_id := l_parent_line_rec.header_id;
4627:
4628: OPEN update_included_items
4629: (p_top_bill_sequence_id => l_parent_component_sequence_id,

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

4655: oe_debug_pub.add('TOP MODEL LINE:' || L_PARENT_LINE_REC.LINE_ID , 2 );
4656: END IF;
4657:
4658: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4659: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4660: l_line_rec.header_id := l_parent_line_rec.header_id;
4661:
4662: OPEN outdated_included_items
4663: (p_top_bill_sequence_id => l_parent_component_sequence_id,

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

4686: oe_debug_pub.add('NO. OF LINES ' || TO_CHAR ( L_LINE_COUNT ) , 2 );
4687: END IF;
4688:
4689: IF l_line_count > 0 THEN
4690: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;
4691: l_header_rec.header_id := l_parent_line_rec.header_id;
4692:
4693: IF l_debug_level > 0 THEN
4694: oe_debug_pub.add('CALLING PROCESS_ORDER' , 2 );

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

4922: ELSE
4923: l_line_rec := p_line_rec;
4924: END IF;
4925:
4926: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
4927: l_line_rec.ato_line_id = l_line_rec.line_id AND
4928: l_line_rec.top_model_line_id = l_line_rec.line_id -- redundent
4929: THEN
4930: IF l_debug_level > 0 THEN

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

4988: ELSE
4989: l_line_rec := p_line_rec;
4990: END IF;
4991:
4992: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
4993: l_line_rec.ato_line_id IS NULL AND
4994: l_line_rec.top_model_line_id = l_line_rec.line_id -- redundent
4995: THEN
4996: IF l_debug_level > 0 THEN

Line 5057: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

5053: ELSE
5054: l_line_rec := p_line_rec;
5055: END IF;
5056:
5057: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5058: THEN
5059: IF l_debug_level > 0 THEN
5060: oe_debug_pub.add('LEAVING IS_INCLUDED_OPTION FUNCTION ' , 1);
5061: END IF;

Line 5121: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG

5117: l_line_rec := p_line_rec;
5118: END IF;
5119:
5120:
5121: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
5122: THEN
5123: IF l_debug_level > 0 THEN
5124: oe_debug_pub.add('LEAVING IS_CONFIG_ITEM FUNCTION ' , 1);
5125: END IF;

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

5180: l_line_rec := p_line_rec;
5181: END IF;
5182:
5183:
5184: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
5185: l_line_rec.ato_line_id is not null AND
5186: l_line_rec.top_model_line_id = l_line_rec.ato_line_id
5187: -- not an ato under pto
5188: THEN

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

5246: ELSE
5247: l_line_rec := p_line_rec;
5248: END IF;
5249:
5250: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
5251: l_line_rec.ato_line_id is null
5252: THEN
5253: IF l_debug_level > 0 THEN
5254: oe_debug_pub.add('LEAVING IS_PTO_OPTION FUNCTION ' , 1);

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

5309: ELSE
5310: l_line_rec := p_line_rec;
5311: END IF;
5312:
5313: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
5314: l_line_rec.ato_line_id is not null AND
5315: l_line_rec.top_model_line_id = l_line_rec.ato_line_id
5316: -- not an ato under pto
5317: THEN

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

5375: ELSE
5376: l_line_rec := p_line_rec;
5377: END IF;
5378:
5379: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
5380: l_line_rec.ato_line_id is not null
5381: THEN
5382: IF l_debug_level > 0 THEN
5383: oe_debug_pub.add('LEAVING IS_PTO_CLASS FUNCTION ' , 1);

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

5440: l_line_rec := p_line_rec;
5441: END IF;
5442:
5443: -- what about subconfig options
5444: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
5445: l_line_rec.ato_line_id is not null AND
5446: l_line_rec.top_model_line_id <> l_line_rec.ato_line_id
5447: -- ato under pto
5448: THEN

Line 5509: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT

5505: ELSE
5506: l_line_rec := p_line_rec;
5507: END IF;
5508:
5509: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
5510: THEN
5511: IF l_debug_level > 0 THEN
5512: oe_debug_pub.add('LEAVING IS_KIT FUNCTION ' , 1);
5513: END IF;

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

5567: ELSE
5568: l_line_rec := p_line_rec;
5569: END IF;
5570:
5571: IF (l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
5572: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) AND
5573: l_line_rec.ato_line_id = l_line_rec.line_id
5574: THEN
5575: IF l_debug_level > 0 THEN

Line 5572: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) AND

5568: l_line_rec := p_line_rec;
5569: END IF;
5570:
5571: IF (l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
5572: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) AND
5573: l_line_rec.ato_line_id = l_line_rec.line_id
5574: THEN
5575: IF l_debug_level > 0 THEN
5576: oe_debug_pub.add('LEAVING IS_ATO_ITEM FUNCTION ' , 1);

Line 5626: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED AND

5622: FROM OE_ORDER_LINES_ALL
5623: WHERE HEADER_ID = l_header_id
5624: AND (TOP_MODEL_LINE_ID = l_top_model_line_id OR
5625: ( LINK_TO_LINE_ID = p_link_to_line_id AND
5626: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED AND
5627: TOP_MODEL_LINE_ID = p_top_model_line_id) OR
5628: ( ATO_LINE_ID = p_ato_line_id AND
5629: TOP_MODEL_LINE_ID = p_top_model_line_id))
5630: ORDER BY line_number,shipment_number,nvl(option_number,-1);

Line 5790: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

5786: CURSOR comp_code_upd IS
5787: SELECT line_id, inventory_item_id, ordered_item, component_code
5788: FROM oe_order_lines
5789: WHERE top_model_line_id = p_top_model_line_id
5790: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
5791: AND open_flag = 'Y'
5792: AND (component_code is null OR
5793: component_sequence_id is null OR
5794: sort_order is null OR

Line 6171: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

6167: END IF;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END;
6170:
6171: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6172: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6173: l_ato_line_id = p_line_id THEN
6174:
6175: SELECT inventory_item_id,line_id,header_id,

Line 6172: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND

6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END;
6170:
6171: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6172: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6173: l_ato_line_id = p_line_id THEN
6174:
6175: SELECT inventory_item_id,line_id,header_id,
6176: RTRIM(line_number||'.'||shipment_number||'.'||

Line 6347: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

6343: INTO l_item_type_code,l_header_id, l_top_model_line_id, l_line_id
6344: FROM oe_order_lines
6345: WHERE line_id = oe_line_security.g_record.line_id;
6346:
6347: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6348: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6349: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
6350: THEN
6351: x_result := 0;

Line 6348: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR

6344: FROM oe_order_lines
6345: WHERE line_id = oe_line_security.g_record.line_id;
6346:
6347: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6348: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6349: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
6350: THEN
6351: x_result := 0;
6352: RETURN;

Line 6349: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

6345: WHERE line_id = oe_line_security.g_record.line_id;
6346:
6347: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6348: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6349: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
6350: THEN
6351: x_result := 0;
6352: RETURN;
6353: END IF;

Line 6355: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

6351: x_result := 0;
6352: RETURN;
6353: END IF;
6354:
6355: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6357: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6358: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6359: l_top_model_line_id <> l_line_id)

Line 6356: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

6352: RETURN;
6353: END IF;
6354:
6355: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6357: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6358: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6359: l_top_model_line_id <> l_line_id)
6360: THEN

Line 6357: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

6353: END IF;
6354:
6355: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6357: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6358: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6359: l_top_model_line_id <> l_line_id)
6360: THEN
6361: x_result := 1;

Line 6358: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

6354:
6355: IF l_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
6357: l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
6358: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6359: l_top_model_line_id <> l_line_id)
6360: THEN
6361: x_result := 1;
6362: RETURN;

Line 6367: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

6363: END IF;
6364:
6365: l_count := 0;
6366:
6367: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6368: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6369: l_top_model_line_id = l_line_id)
6370: THEN
6371: SELECT count(*)

Line 6368: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

6364:
6365: l_count := 0;
6366:
6367: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6368: ( l_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
6369: l_top_model_line_id = l_line_id)
6370: THEN
6371: SELECT count(*)
6372: INTO l_count

Line 6439: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

6435: l_valid := 1;
6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6437: END;
6438:
6439: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6440: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6441: l_ato_line_id = p_line_id THEN
6442:
6443: l_valid := 0;

Line 6440: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND

6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6437: END;
6438:
6439: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6440: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND
6441: l_ato_line_id = p_line_id THEN
6442:
6443: l_valid := 0;
6444:

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

7547: ---------------- for direct save only ------------------------
7548:
7549: IF p_direct_save THEN
7550:
7551: p_x_child_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
7552: p_x_child_line_rec.header_id := p_parent_line_rec.header_id;
7553: p_x_child_line_rec.top_model_line_id := p_parent_line_rec.line_id;
7554: p_x_child_line_rec.item_identifier_type := 'INT';
7555: p_x_child_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;

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

7551: p_x_child_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
7552: p_x_child_line_rec.header_id := p_parent_line_rec.header_id;
7553: p_x_child_line_rec.top_model_line_id := p_parent_line_rec.line_id;
7554: p_x_child_line_rec.item_identifier_type := 'INT';
7555: p_x_child_line_rec.item_type_code := OE_GLOBALS.G_ITEM_CLASS;
7556: p_x_child_line_rec.line_category_code
7557: := p_parent_line_rec.line_category_code;
7558: p_x_child_line_rec.creation_date := sysdate;
7559: p_x_child_line_rec.created_by := p_parent_line_rec.created_by;

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

7696:
7697:
7698: --Begin- code to get user_item_description from the parent for the child
7699:
7700: IF p_x_child_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG AND
7701: p_x_child_line_rec.ato_line_id is not NULL AND
7702: p_x_child_line_rec.line_id <> p_x_child_line_rec.ato_line_id THEN
7703:
7704: IF l_debug_level > 0 THEN

Line 7923: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

7919:
7920: --Added the if clause for bug 6892989/6903859
7921: IF ( nvl(p_booked_flag,'N') = 'Y' ) THEN
7922: OE_delayed_requests_Pvt.log_request
7923: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7924: p_entity_id => p_line_tbl(I).header_id,
7925: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7926: p_requesting_entity_id => p_line_tbl(I).header_id,
7927: p_request_unique_key1 => 'BATCH,BOOK',

Line 7925: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

7921: IF ( nvl(p_booked_flag,'N') = 'Y' ) THEN
7922: OE_delayed_requests_Pvt.log_request
7923: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7924: p_entity_id => p_line_tbl(I).header_id,
7925: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7926: p_requesting_entity_id => p_line_tbl(I).header_id,
7927: p_request_unique_key1 => 'BATCH,BOOK',
7928: p_param1 => p_line_tbl(I).header_id,
7929: p_param2 => 'BATCH,BOOK',

Line 7930: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,

7926: p_requesting_entity_id => p_line_tbl(I).header_id,
7927: p_request_unique_key1 => 'BATCH,BOOK',
7928: p_param1 => p_line_tbl(I).header_id,
7929: p_param2 => 'BATCH,BOOK',
7930: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,
7931: x_return_status => l_return_status);
7932: ELSE
7933: OE_delayed_requests_Pvt.log_request
7934: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 7934: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

7930: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,
7931: x_return_status => l_return_status);
7932: ELSE
7933: OE_delayed_requests_Pvt.log_request
7934: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7935: p_entity_id => p_line_tbl(I).header_id,
7936: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7937: p_requesting_entity_id => p_line_tbl(I).header_id,
7938: p_request_unique_key1 => 'BATCH',

Line 7936: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

7932: ELSE
7933: OE_delayed_requests_Pvt.log_request
7934: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7935: p_entity_id => p_line_tbl(I).header_id,
7936: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7937: p_requesting_entity_id => p_line_tbl(I).header_id,
7938: p_request_unique_key1 => 'BATCH',
7939: p_param1 => p_line_tbl(I).header_id,
7940: p_param2 => 'BATCH',

Line 7941: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,

7937: p_requesting_entity_id => p_line_tbl(I).header_id,
7938: p_request_unique_key1 => 'BATCH',
7939: p_param1 => p_line_tbl(I).header_id,
7940: p_param2 => 'BATCH',
7941: p_request_type => OE_GLOBALS.G_FREIGHT_FOR_INCLUDED,
7942: x_return_status => l_return_status);
7943: END IF;
7944:
7945:

Line 7966: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7962: oe_debug_pub.add('REN: ITEM TYPE CODE IS NOT INCLUDED OR CONFIG' , 1);
7963: END IF;
7964:
7965: OE_delayed_requests_Pvt.log_request
7966: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7967: p_entity_id => p_line_tbl(I).line_id,
7968: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7969: p_requesting_entity_id => p_line_tbl(I).line_id,
7970: p_request_type => OE_GLOBALS.g_tax_line,

Line 7968: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7964:
7965: OE_delayed_requests_Pvt.log_request
7966: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7967: p_entity_id => p_line_tbl(I).line_id,
7968: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7969: p_requesting_entity_id => p_line_tbl(I).line_id,
7970: p_request_type => OE_GLOBALS.g_tax_line,
7971: x_return_status => l_return_status);
7972:

Line 7970: p_request_type => OE_GLOBALS.g_tax_line,

7966: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7967: p_entity_id => p_line_tbl(I).line_id,
7968: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7969: p_requesting_entity_id => p_line_tbl(I).line_id,
7970: p_request_type => OE_GLOBALS.g_tax_line,
7971: x_return_status => l_return_status);
7972:
7973: END IF;
7974:

Line 7983: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7979: oe_debug_pub.add('LOGGING REQ TO CALC COMMITMENT' , 3 );
7980: END IF;
7981:
7982: OE_Delayed_Requests_Pvt.Log_Request
7983: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7984: p_entity_id => p_line_tbl(I).line_id,
7985: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7986: p_requesting_entity_id => p_line_tbl(I).line_id,
7987: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

Line 7985: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7981:
7982: OE_Delayed_Requests_Pvt.Log_Request
7983: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7984: p_entity_id => p_line_tbl(I).line_id,
7985: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7986: p_requesting_entity_id => p_line_tbl(I).line_id,
7987: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
7988: x_return_status => l_return_status);
7989: END IF;

Line 7987: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

7983: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7984: p_entity_id => p_line_tbl(I).line_id,
7985: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7986: p_requesting_entity_id => p_line_tbl(I).line_id,
7987: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
7988: x_return_status => l_return_status);
7989: END IF;
7990:
7991: IF p_booked_flag = 'Y' AND

Line 7998: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

7994: IF l_debug_level > 0 THEN
7995: oe_debug_pub.add('LOGGING REQ TO VERIFY_PAYMENT' , 3 );
7996: END IF;
7997: OE_delayed_requests_Pvt.log_request
7998: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7999: p_entity_id => p_line_tbl(I).header_id,
8000: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8001: p_requesting_entity_id => p_line_tbl(I).line_id,
8002: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 8000: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7996: END IF;
7997: OE_delayed_requests_Pvt.log_request
7998: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7999: p_entity_id => p_line_tbl(I).header_id,
8000: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8001: p_requesting_entity_id => p_line_tbl(I).line_id,
8002: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
8003: x_return_status => l_return_status);
8004:

Line 8002: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

7998: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
7999: p_entity_id => p_line_tbl(I).header_id,
8000: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8001: p_requesting_entity_id => p_line_tbl(I).line_id,
8002: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
8003: x_return_status => l_return_status);
8004:
8005: END IF;
8006:

Line 8019: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8015: ||P_LINE_TBL (I).HEADER_ID , 2 );
8016: END IF;
8017:
8018: OE_delayed_requests_Pvt.log_request
8019: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8020: p_entity_id => p_line_tbl(I).header_id,
8021: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8022: p_requesting_entity_id => p_line_tbl(I).line_id,
8023: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,

Line 8021: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8017:
8018: OE_delayed_requests_Pvt.log_request
8019: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8020: p_entity_id => p_line_tbl(I).header_id,
8021: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8022: p_requesting_entity_id => p_line_tbl(I).line_id,
8023: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,
8024: p_param1 => 'Y',
8025: x_return_status => l_return_status);

Line 8023: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,

8019: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8020: p_entity_id => p_line_tbl(I).header_id,
8021: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8022: p_requesting_entity_id => p_line_tbl(I).line_id,
8023: p_request_type => OE_GLOBALS.G_FREIGHT_RATING,
8024: p_param1 => 'Y',
8025: x_return_status => l_return_status);
8026: END IF;
8027:

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

8025: x_return_status => l_return_status);
8026: END IF;
8027:
8028: /* Below code has been added for bug 5925600 */
8029: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
8030:
8031: if l_debug_level > 0 then
8032: oe_debug_pub.add('Before checking if we need to log delayed request for G_CASCADE_OPTIONS_SERVICE', 5);
8033: oe_debug_pub.ADD('operation : '|| p_line_tbl(I).operation);

Line 8084: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8080: end if;
8081:
8082: OE_Delayed_Requests_Pvt.log_request
8083: (
8084: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8085: p_entity_id => p_line_tbl(I).line_id,
8086: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8087: p_requesting_entity_id => p_line_tbl(I).line_id,
8088: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,

Line 8086: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8082: OE_Delayed_Requests_Pvt.log_request
8083: (
8084: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8085: p_entity_id => p_line_tbl(I).line_id,
8086: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8087: p_requesting_entity_id => p_line_tbl(I).line_id,
8088: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,
8089: x_return_status => l_return_status
8090: );

Line 8088: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,

8084: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8085: p_entity_id => p_line_tbl(I).line_id,
8086: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8087: p_requesting_entity_id => p_line_tbl(I).line_id,
8088: p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE,
8089: x_return_status => l_return_status
8090: );
8091:
8092: END IF; /* l_serviced_model = 'Y' */

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

8448: END IF;
8449:
8450: ELSE
8451:
8452: IF p_model_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
8453:
8454: l_creation_date := sysdate;
8455: IF l_debug_level > 0 THEN
8456: OE_Debug_Pub.Add('model is getting created today', 3);