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_GROUP_SCH_UTIL dependencies on OE_SCHEDULE_UTIL

Line 77: oe_debug_pub.add( '..ENTERING OE_SCHEDULE_UTIL.VALIDATE_GROUP_LINE' , 6 ) ;

73: BEGIN
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( '..ENTERING OE_SCHEDULE_UTIL.VALIDATE_GROUP_LINE' , 6 ) ;
78: END IF;
79:
80: -- If the line is shipped, scheduling is not allowed.
81:

Line 184: OE_SCHEDULE_UTIL.Get_Scheduling_Level(p_line_rec.header_id,

180: IF l_debug_level > 0 THEN
181: oe_debug_pub.add( 'CHECKING SCHEDULING LEVEL...' , 1 ) ;
182: END IF;
183: l_scheduling_level_code :=
184: OE_SCHEDULE_UTIL.Get_Scheduling_Level(p_line_rec.header_id,
185: p_line_rec.line_type_id);
186:
187: IF l_debug_level > 0 THEN
188: oe_debug_pub.add( 'L_SCHEDULING_LEVEL_CODE : ' || L_SCHEDULING_LEVEL_CODE , 1 ) ;

Line 192: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN

188: oe_debug_pub.add( 'L_SCHEDULING_LEVEL_CODE : ' || L_SCHEDULING_LEVEL_CODE , 1 ) ;
189: END IF;
190:
191: IF l_scheduling_level_code is not null THEN
192: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN
193:
194: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
195: FND_MESSAGE.SET_TOKEN('ACTION', p_line_rec.schedule_action_code);
196: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

Line 197: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,

193:
194: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
195: FND_MESSAGE.SET_TOKEN('ACTION', p_line_rec.schedule_action_code);
196: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
197: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
198: OE_SCHEDULE_UTIL.sch_cached_order_type));
199: OE_MSG_PUB.Add;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: IF l_debug_level > 0 THEN

Line 198: OE_SCHEDULE_UTIL.sch_cached_order_type));

194: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
195: FND_MESSAGE.SET_TOKEN('ACTION', p_line_rec.schedule_action_code);
196: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
197: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
198: OE_SCHEDULE_UTIL.sch_cached_order_type));
199: OE_MSG_PUB.Add;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( 'LINE TYPE IS ATP ONLY' , 4 ) ;

Line 205: ELSIF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_TWO

201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( 'LINE TYPE IS ATP ONLY' , 4 ) ;
203: END IF;
204:
205: ELSIF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_TWO
206: AND p_line_rec.schedule_action_code =
207: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
208: THEN
209:

Line 207: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

203: END IF;
204:
205: ELSIF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_TWO
206: AND p_line_rec.schedule_action_code =
207: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
208: THEN
209:
210: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
211: FND_MESSAGE.SET_TOKEN('ACTION',

Line 213: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE));

209:
210: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
211: FND_MESSAGE.SET_TOKEN('ACTION',
212: nvl(p_line_rec.schedule_action_code,
213: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE));
214: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
215: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
216: OE_SCHEDULE_UTIL.sch_cached_order_type));
217: OE_MSG_PUB.Add;

Line 215: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,

211: FND_MESSAGE.SET_TOKEN('ACTION',
212: nvl(p_line_rec.schedule_action_code,
213: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE));
214: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
215: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
216: OE_SCHEDULE_UTIL.sch_cached_order_type));
217: OE_MSG_PUB.Add;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: IF l_debug_level > 0 THEN

Line 216: OE_SCHEDULE_UTIL.sch_cached_order_type));

212: nvl(p_line_rec.schedule_action_code,
213: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE));
214: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
215: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,
216: OE_SCHEDULE_UTIL.sch_cached_order_type));
217: OE_MSG_PUB.Add;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: IF l_debug_level > 0 THEN
220: oe_debug_pub.add( 'LINE TYPE IS NOT ELIGIBLE FOR RESERVATION ' , 4 ) ;

Line 227: oe_debug_pub.add( '..EXITING OE_SCHEDULE_UTIL.VALIDATE_GROUP_LINE WITH ' || X_RETURN_STATUS , 1 ) ;

223: END IF;
224: END IF;
225:
226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add( '..EXITING OE_SCHEDULE_UTIL.VALIDATE_GROUP_LINE WITH ' || X_RETURN_STATUS , 1 ) ;
228: END IF;
229:
230:
231: EXCEPTION

Line 302: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => p_x_line_tbl(I),

298: (p_inventory_item_id => p_x_line_tbl(I).inventory_item_id,
299: p_ship_from_org_id => p_x_line_tbl(I).ship_from_org_id,
300: x_return_status => l_return_status);
301: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
302: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => p_x_line_tbl(I),
303: p_old_line_rec => p_x_line_tbl(I),
304: p_sch_action => p_sch_action ,
305: x_return_status => l_return_status);
306:

Line 606: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR

602:
603: -- Process Included Items if the action is schedule, atp_check
604: -- and reserve.
605:
606: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
607: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
608: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
609:
610: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 607: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR

603: -- Process Included Items if the action is schedule, atp_check
604: -- and reserve.
605:
606: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
607: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
608: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
609:
610: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
611: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 608: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

604: -- and reserve.
605:
606: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
607: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
608: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
609:
610: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
611: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
612:

Line 610: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

606: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
607: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
608: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
609:
610: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
611: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
612:
613: FOR I IN process_inc LOOP
614:

Line 634: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

630: END IF;
631:
632: END LOOP;
633:
634: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
635: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
636:
637: END IF;
638:

Line 641: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

637: END IF;
638:
639:
640:
641: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
642: THEN
643:
644: -- If the action is schedule,
645: -- then only query the lines that are not scheduled.

Line 695: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,

691: -- 2766876
692: l_line_rec.reserved_quantity := 0;
693:
694: l_return_status := FND_API.G_RET_STS_SUCCESS;
695: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
696: p_old_line_rec => l_line_rec,
697: p_sch_action => p_sch_action,
698: x_return_status => l_return_status);
699:

Line 736: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

732: END IF; -- schedule status code
733:
734: END LOOP;
735:
736: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
737: THEN
738:
739:
740: --If the line is not scheduled,system should schedule and reserve the line.

Line 788: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);

784: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
785:
786: IF l_sales_order_id is null THEN
787: l_sales_order_id :=
788: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
789: END IF;
790:
791: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
792:

Line 838: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,

834: END IF;
835:
836: -- Check if the line is eligible for reservation.
837: l_return_status := FND_API.G_RET_STS_SUCCESS;
838: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
839: p_old_line_rec => l_line_rec,
840: p_sch_action => p_sch_action,
841: x_return_status => l_return_status);
842:

Line 877: OE_SCHEDULE_UTIL.Reserve_Line

873: --partial reservation exists
874: IF nvl(l_line_rec.reserved_quantity,0) > 0 THEN
875: l_rsv_update := TRUE;
876: END IF;
877: OE_SCHEDULE_UTIL.Reserve_Line
878: (p_line_rec => l_line_rec
879: ,p_quantity_to_reserve => l_quantity_to_reserve --l_line_rec.ordered_quantity
880: ,p_quantity2_to_reserve => l_quantity2_to_reserve --l_line_rec.ordered_quantity2
881: ,p_rsv_update => l_rsv_update

Line 933: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,

929:
930: l_line_rec.reserved_quantity := 0;
931: l_line_rec.reserved_quantity2 := 0; -- INCONV
932: l_return_status := FND_API.G_RET_STS_SUCCESS;
933: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
934: p_old_line_rec => l_line_rec,
935: p_sch_action => p_sch_action,
936: x_return_status => l_return_status);
937:

Line 969: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK

965: END IF; -- return status.
966: END IF; -- scheduled line.
967: END LOOP;
968:
969: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
970: THEN
971:
972: -- Load line table with scheduled and unscheduled lines.
973:

Line 981: l_sales_order_id :=OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);

977: I := I + 1;
978:
979: IF I = 1 THEN */ -- 2327783
980: IF l_sales_order_id IS NULL THEN
981: l_sales_order_id :=OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
982: END IF;
983:
984: IF l_debug_level > 0 THEN
985: oe_debug_pub.add( 'LINE SELECTED FOR ATP **** : ' || C1.LINE_ID , 1 ) ;

Line 1015: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,

1011: l_line_rec.schedule_action_code := p_sch_action;
1012:
1013:
1014: l_return_status := FND_API.G_RET_STS_SUCCESS;
1015: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
1016: p_old_line_rec => l_line_rec,
1017: p_sch_action => p_sch_action,
1018: x_return_status => l_return_status);
1019:

Line 1082: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN

1078: END IF; -- Validation success
1079: END LOOP;
1080:
1081:
1082: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN
1083:
1084: -- Lines are already scheduled. We no need to explode the included items.
1085:
1086: I := 0;

Line 1110: AND oe_schedule_util.Get_Pick_Status(c2.line_id)) THEN -- 2595661

1106: -- ignore the line.
1107: IF nvl(c2.shippable_flag,'N') = 'Y' THEN
1108:
1109: IF (nvl(c2.shipping_interfaced_flag,'N') = 'Y'
1110: AND oe_schedule_util.Get_Pick_Status(c2.line_id)) THEN -- 2595661
1111:
1112:
1113: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
1114: OE_MSG_PUB.Add;

Line 1153: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);

1149: l_line_rec.source_document_type_id);
1150:
1151: IF l_sales_order_id is null THEN
1152: l_sales_order_id :=
1153: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
1154: END IF;
1155:
1156:
1157: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 1197: l_sales_order_id :=OE_SCHEDULE_UTIL.

1193:
1194: -- I := I + 1; 2327783
1195: IF l_sales_order_id is null THEN
1196:
1197: l_sales_order_id :=OE_SCHEDULE_UTIL.
1198: Get_mtl_sales_order_id(p_header_id);
1199:
1200: END IF;
1201:

Line 1211: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,

1207: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1208: l_line_rec.schedule_action_code := p_sch_action;
1209: l_return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
1212: p_old_line_rec => l_line_rec,
1213: p_sch_action => p_sch_action,
1214: x_return_status => l_return_status);
1215:

Line 1229: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE

1225: l_line_rec.reserved_quantity := 0;
1226: END IF; -- Line is not shippable line.
1227:
1228: END LOOP;
1229: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE
1230: THEN
1231:
1232: -- Lines are already scheduled. We no need to explode the included items.
1233:

Line 1262: l_sales_order_id :=OE_SCHEDULE_UTIL.

1258: I := I + 1;
1259: IF I = 1 THEN */ -- 2327783
1260:
1261: IF l_sales_order_id IS NULL THEN
1262: l_sales_order_id :=OE_SCHEDULE_UTIL.
1263: Get_mtl_sales_order_id(p_header_id);
1264: END IF;
1265:
1266:

Line 1306: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,

1302: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1303: l_line_rec.schedule_action_code := p_sch_action;
1304:
1305: l_return_status := FND_API.G_RET_STS_SUCCESS;
1306: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
1307: p_old_line_rec => l_line_rec,
1308: p_sch_action => p_sch_action,
1309: x_return_status => l_return_status);
1310:

Line 1382: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

1378: IF l_debug_level > 0 THEN
1379: oe_debug_pub.add( 'EXPECTED ERROR IN QUERY LINES ' , 1 ) ;
1380: END IF;
1381: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1382: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1383: RAISE FND_API.G_EXC_ERROR;
1384:
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1386:

Line 1391: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

1387: IF l_debug_level > 0 THEN
1388: oe_debug_pub.add( 'UNEXPECTED ERROR IN QUERY LINES ' , 1 ) ;
1389: END IF;
1390: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1391: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393:
1394: WHEN OTHERS THEN
1395:

Line 1400: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

1396: IF l_debug_level > 0 THEN
1397: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY LINES ' , 1 ) ;
1398: END IF;
1399: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1400: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN
1403: OE_MSG_PUB.Add_Exc_Msg
1404: ( G_PKG_NAME

Line 1564: oe_schedule_util.Log_Set_Request

1560: OE_Line_Util.Query_Row
1561: (p_line_id => l_line_id,
1562: x_line_rec => l_set_line_rec);
1563:
1564: oe_schedule_util.Log_Set_Request
1565: ( l_set_line_rec,
1566: l_set_line_rec,
1567: 'SCHEDULE',
1568: 'SCH_INTERNAL',

Line 2106: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2102: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2103:
2104: IF l_sales_order_id is null THEN
2105: l_sales_order_id :=
2106: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2107: (l_line_rec.header_id);
2108: END IF;
2109:
2110:

Line 2335: AND oe_schedule_util.Get_Pick_Status(l_line_id))

2331:
2332: IF l_schedule_status_code IS NULL
2333: OR nvl(l_open_flag,'Y') = 'N'
2334: OR (l_shipping_interfaced_flag = 'Y'
2335: AND oe_schedule_util.Get_Pick_Status(l_line_id))
2336: THEN -- 2595661
2337: -- Go inside only if they are scheduled.
2338: -- and not part of set.
2339: IF l_shipping_interfaced_flag = 'Y' THEN

Line 2433: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2429: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2430:
2431: IF l_sales_order_id is null THEN
2432: l_sales_order_id :=
2433: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2434: (l_line_rec.header_id);
2435: END IF;
2436:
2437: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 2698: oe_schedule_util.Log_Set_Request

2694: OE_Line_Util.Query_Row
2695: (p_line_id => l_line_id,
2696: x_line_rec => l_set_line_rec);
2697:
2698: oe_schedule_util.Log_Set_Request
2699: ( l_set_line_rec,
2700: l_set_line_rec,
2701: 'SCHEDULE',
2702: 'SCH_INTERNAL',

Line 2856: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2852: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2853:
2854: IF l_sales_order_id is null THEN
2855: l_sales_order_id :=
2856: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2857: (l_line_rec.header_id);
2858: END IF;
2859:
2860: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 2916: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2912: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2913:
2914: IF l_sales_order_id is null THEN
2915: l_sales_order_id :=
2916: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2917: (l_line_rec.header_id);
2918: END IF;
2919:
2920: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 3042: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_tbl(I),

3038: END IF;
3039:
3040: -- Check if the line is eligible for reservation.
3041: l_return_status := FND_API.G_RET_STS_SUCCESS;
3042: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_tbl(I),
3043: p_old_line_rec => l_line_tbl(I),
3044: p_sch_action => p_sch_action,
3045: x_return_status => l_return_status);
3046:

Line 3081: OE_SCHEDULE_UTIL.Reserve_Line

3077: IF nvl(l_line_tbl(I).reserved_quantity,0) > 0 THEN
3078: l_rsv_update := TRUE;
3079: END IF;
3080:
3081: OE_SCHEDULE_UTIL.Reserve_Line
3082: (p_line_rec => l_line_tbl(I)
3083: ,p_quantity_to_reserve => l_quantity_to_reserve --l_line_tbl(I).ordered_quantity
3084: ,p_quantity2_to_reserve => l_quantity2_to_reserve --l_line_tbl(I).ordered_quantity2 -- INVCONV
3085: ,p_rsv_update => l_rsv_update

Line 3436: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

3432: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
3433:
3434: IF l_sales_order_id is null THEN
3435: l_sales_order_id :=
3436: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3437: (l_line_rec.header_id);
3438: END IF;
3439:
3440: l_line_rec.reserved_quantity :=

Line 3591: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3587:
3588: -- Start 2434807 -
3589: -- Added to clear existing records from g_atp_tbl
3590: -- before starting scheduling event
3591: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3592: Oe_Schedule_Util.g_atp_tbl.delete;
3593: END IF;
3594: -- End 2434807 -
3595:

Line 3592: Oe_Schedule_Util.g_atp_tbl.delete;

3588: -- Start 2434807 -
3589: -- Added to clear existing records from g_atp_tbl
3590: -- before starting scheduling event
3591: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3592: Oe_Schedule_Util.g_atp_tbl.delete;
3593: END IF;
3594: -- End 2434807 -
3595:
3596:

Line 3603: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3599: x_line_tbl => l_line_tbl);
3600:
3601: l_old_line_tbl := l_line_tbl;
3602:
3603: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3604: IF l_debug_level > 0 THEN
3605: oe_debug_pub.add( 'BEFORE CALLING MULTI_ATP_CHECK ' ) ;
3606: END IF;
3607: IF l_debug_level > 0 THEN

Line 3613: OE_SCHEDULE_UTIL.Multi_ATP_CHECK

3609: END IF;
3610:
3611: IF l_line_tbl.count > 0 THEN
3612:
3613: OE_SCHEDULE_UTIL.Multi_ATP_CHECK
3614: (p_old_line_tbl => l_old_line_tbl,
3615: p_x_line_tbl => l_line_tbl,
3616: x_atp_tbl => x_atp_tbl,
3617: x_return_status => x_return_status);

Line 3651: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN

3647: ,p_partial => TRUE
3648: ,x_return_status => x_return_status);
3649: ELSE
3650:
3651: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN
3652: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3653: OE_MSG_PUB.Add;
3654: END IF;
3655: END IF;

Line 3759: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3755:
3756: -- Start 2434807 -
3757: -- Added to clear existing records from g_atp_tbl
3758: -- before starting scheduling event
3759: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3760: Oe_Schedule_Util.g_atp_tbl.delete;
3761: END IF;
3762: -- End 2434807 -
3763:

Line 3760: Oe_Schedule_Util.g_atp_tbl.delete;

3756: -- Start 2434807 -
3757: -- Added to clear existing records from g_atp_tbl
3758: -- before starting scheduling event
3759: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3760: Oe_Schedule_Util.g_atp_tbl.delete;
3761: END IF;
3762: -- End 2434807 -
3763:
3764: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3786: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE THEN

3782: nextpos := INSTR(l_record_ids,',',1,j) ;
3783:
3784: END LOOP;
3785: */
3786: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE THEN
3787:
3788: Query_Schedule_lines(p_sch_action => p_sch_action,
3789: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3790: x_line_tbl => l_line_tbl);

Line 3792: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN

3788: Query_Schedule_lines(p_sch_action => p_sch_action,
3789: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3790: x_line_tbl => l_line_tbl);
3791:
3792: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN
3793:
3794: Query_Unschedule_lines(p_sch_action => p_sch_action,
3795: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3796: x_line_tbl => l_line_tbl);

Line 3798: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN

3794: Query_Unschedule_lines(p_sch_action => p_sch_action,
3795: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3796: x_line_tbl => l_line_tbl);
3797:
3798: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN
3799:
3800: Query_Unreserve_lines(p_sch_action => p_sch_action,
3801: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3802: x_line_tbl => l_line_tbl);

Line 3804: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN

3800: Query_Unreserve_lines(p_sch_action => p_sch_action,
3801: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3802: x_line_tbl => l_line_tbl);
3803:
3804: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN
3805:
3806: Query_Reserve_lines(p_sch_action => p_sch_action,
3807: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3808: x_line_tbl => l_line_tbl);

Line 3810: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3806: Query_Reserve_lines(p_sch_action => p_sch_action,
3807: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3808: x_line_tbl => l_line_tbl);
3809:
3810: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3811: --Bug 5881611
3812: --Creating a savepoint, so that it can be be rolled for ATP Checks.
3813: --This is to rollback updates to database made by Availability window, which
3814: --calls process_included_items to explode included items and oe_order_pvt.lines

Line 3877: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK

3873: END LOOP;
3874:
3875: ------- Action Specific processing -----------------------
3876: -- 3990887
3877: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3878: THEN
3879: --Bug 5881611
3880: --Rolling back
3881: oe_debug_pub.add('Rollback for only atp check');

Line 3893: OE_SCHEDULE_UTIL.Multi_ATP_CHECK

3889: IF l_debug_level > 0 THEN
3890: oe_debug_pub.add( 'LINE COUNT ' || L_LINE_TBL.COUNT , 1 ) ;
3891: END IF;
3892:
3893: OE_SCHEDULE_UTIL.Multi_ATP_CHECK
3894: (p_old_line_tbl => l_old_line_tbl,
3895: p_x_line_tbl => l_line_tbl,
3896: x_atp_tbl => x_atp_tbl,
3897: x_return_status => x_return_status);

Line 3926: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

3922: -- RAISE FND_API.G_EXC_ERROR;
3923: END IF;
3924:
3925: ELSE
3926: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
3927: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3928: THEN
3929: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3930: OE_MSG_PUB.Add;

Line 3927: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK

3923: END IF;
3924:
3925: ELSE
3926: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
3927: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3928: THEN
3929: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3930: OE_MSG_PUB.Add;
3931: END IF;

Line 4148: IF (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET AND

4144: END;
4145:
4146: --{bug3885953: If the ship/arrival set has changed, do not use old delayed
4147: --request, but just go to the end of processing
4148: IF (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET AND
4149: l_ship_set_id <> p_sch_set_tbl(I).param1) OR
4150: (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET AND
4151: l_arrival_set_id <> p_sch_set_tbl(I).param1) THEN
4152: IF l_debug_level > 0 THEN

Line 4150: (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET AND

4146: --{bug3885953: If the ship/arrival set has changed, do not use old delayed
4147: --request, but just go to the end of processing
4148: IF (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET AND
4149: l_ship_set_id <> p_sch_set_tbl(I).param1) OR
4150: (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET AND
4151: l_arrival_set_id <> p_sch_set_tbl(I).param1) THEN
4152: IF l_debug_level > 0 THEN
4153: OE_DEBUG_PUB.Add('Sets differs, goto END OF PROCESS',2);
4154: END IF;

Line 4270: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.header_id);

4266: AND l_line_rec.schedule_status_code is not null THEN
4267:
4268: IF l_sales_order_id is null THEN
4269: l_sales_order_id :=
4270: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.header_id);
4271: END IF;
4272:
4273: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
4274:

Line 4340: l_type_code := oe_schedule_util.Get_Date_Type(l_line_tbl(K).header_id);

4336:
4337: /* Commented the above line to fix the bug 2916814 */
4338: --3564302 (#1)
4339: -- Get the order date type code
4340: l_type_code := oe_schedule_util.Get_Date_Type(l_line_tbl(K).header_id);
4341:
4342: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4343: THEN
4344: -- Ship set date.

Line 4342: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

4338: --3564302 (#1)
4339: -- Get the order date type code
4340: l_type_code := oe_schedule_util.Get_Date_Type(l_line_tbl(K).header_id);
4341:
4342: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4343: THEN
4344: -- Ship set date.
4345: l_line_tbl(K).Schedule_ship_date := p_sch_set_tbl(I).date_param4;
4346: -- 3564302

Line 4360: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

4356: l_line_tbl(K).shipping_method_code := p_sch_set_tbl(I).param11;
4357: END IF;
4358: END IF;
4359:
4360: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
4361: THEN
4362: l_line_tbl(K).Schedule_arrival_date := p_sch_set_tbl(I).date_param5;
4363: -- 3564302(issue 1)
4364: IF l_type_code = 'SHIP' THEN

Line 4377: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

4373: l_line_tbl(K).ship_to_org_id := p_sch_set_tbl(I).param9;
4374: END IF;
4375:
4376: l_line_tbl(K).schedule_action_code :=
4377: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
4378:
4379:
4380: IF l_line_tbl(K).arrival_set_id is not null THEN
4381: l_line_tbl(K).arrival_set := l_line_tbl(K).arrival_set_id;

Line 4467: oe_schedule_util.Log_Delete_Set_Request

4463: END IF;
4464: -- 4026758
4465: IF l_iline_tbl(I).ship_set_id IS NOT NULL
4466: OR l_iline_tbl(I).arrival_set_id IS NOT NULL THEN
4467: oe_schedule_util.Log_Delete_Set_Request
4468: (p_header_id => l_iline_tbl(I).header_id,
4469: p_line_id => l_iline_tbl(I).line_id,
4470: p_set_id => nvl(l_iline_tbl(I).ship_set_id,
4471: l_iline_tbl(I).arrival_set_id),

Line 4505: l_type_code := oe_schedule_util.Get_Date_Type(l_header_id);

4501:
4502: -- Start 2716220 --
4503: -- To check schedule dates with override flag
4504:
4505: l_type_code := oe_schedule_util.Get_Date_Type(l_header_id);
4506:
4507: IF l_arrival_set_id is not null THEN
4508:
4509: l_set_rec := OE_ORDER_CACHE.Load_Set

Line 4598: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

4594: /* End Audit Trail */
4595:
4596: l_line_tbl(K).operation := OE_GLOBALS.G_OPR_UPDATE;
4597:
4598: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4599: THEN
4600: -- Ship set date.
4601: l_line_tbl(K).Schedule_ship_date := p_sch_set_tbl(I).date_param4;
4602: -- 3564302

Line 4617: = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

4613: END IF;
4614: END IF;
4615:
4616: IF p_sch_set_tbl(I).param8
4617: = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
4618: THEN
4619: l_line_tbl(K).Schedule_arrival_date
4620: := p_sch_set_tbl(I).date_param5;
4621: -- 3564302

Line 4635: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

4631: l_line_tbl(K).ship_to_org_id := p_sch_set_tbl(I).param9;
4632: END IF;
4633:
4634: l_line_tbl(K).schedule_action_code :=
4635: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
4636:
4637: IF l_line_tbl(K).arrival_set_id is not null THEN
4638: l_line_tbl(K).arrival_set := l_line_tbl(K).arrival_set_id;
4639: ELSE

Line 4675: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE

4671: Oe_Config_Schedule_Pvt.Process_Group
4672: (p_x_line_tbl => l_line_tbl
4673: ,p_old_line_tbl => l_old_line_tbl
4674: ,p_caller => 'SET'
4675: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
4676: ,p_partial_set => TRUE
4677: ,p_part_of_set => l_part_of_set --4405004
4678: ,x_return_status => x_return_status);
4679:

Line 4697: IF p_sch_set_tbl(1).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

4693: END IF;
4694:
4695: FOR I IN 1..l_line_tbl.count LOOP
4696:
4697: IF p_sch_set_tbl(1).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4698: AND trunc(l_line_tbl(I).Schedule_ship_date) <> trunc(p_sch_set_tbl(1).date_param4)
4699: THEN
4700: IF l_debug_level > 0 THEN
4701: oe_debug_pub.add('Not received correct values for ship set',1);

Line 4705: ELSIF p_sch_set_tbl(1).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

4701: oe_debug_pub.add('Not received correct values for ship set',1);
4702: END IF;
4703: x_return_status := FND_API.G_RET_STS_ERROR;
4704: EXIT;
4705: ELSIF p_sch_set_tbl(1).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
4706: AND trunc(l_line_tbl(I).Schedule_arrival_date) <> trunc(p_sch_set_tbl(1).date_param5)
4707: THEN
4708: IF l_debug_level > 0 THEN
4709: oe_debug_pub.add('Not received correct values for arrival set',1);

Line 4736: l_request_rec.param3 := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

4732: END IF;
4733:
4734: -- Added this stmt to fix big 1899651.
4735: l_request_rec := p_sch_set_tbl(1);
4736: l_request_rec.param3 := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
4737: -- 3384975
4738: l_request_rec.param12 := l_param12;
4739:
4740: IF l_debug_level > 0 THEN

Line 4829: oe_schedule_util.Log_Delete_Set_Request

4825: END IF;
4826: -- 4026758
4827: IF l_line_tbl(I).ship_set_id IS NOT NULL
4828: OR l_line_tbl(I).arrival_set_id IS NOT NULL THEN
4829: oe_schedule_util.Log_Delete_Set_Request
4830: (p_header_id => l_line_tbl(I).header_id,
4831: p_line_id => l_line_tbl(I).line_id,
4832: p_set_id => nvl(l_line_tbl(I).ship_set_id,l_line_tbl(I).arrival_set_id),
4833: x_return_status => x_return_status);

Line 5043: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN

5039:
5040: -- 5043206
5041: BEGIN
5042:
5043: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5044:
5045: Select 1 into l_count from OE_ORDER_LINES_ALL
5046: WHERE header_id = l_header_id and arrival_Set_id = p_request_rec.param1
5047: AND rownum = 1;

Line 5049: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN

5045: Select 1 into l_count from OE_ORDER_LINES_ALL
5046: WHERE header_id = l_header_id and arrival_Set_id = p_request_rec.param1
5047: AND rownum = 1;
5048:
5049: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5050:
5051: Select 1 into l_count from OE_ORDER_LINES_ALL
5052: WHERE header_id = l_header_id and ship_set_id = p_request_rec.param1
5053: AND rownum = 1;

Line 5097: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN

5093: oe_debug_pub.add( 'CALLING QUERY_SET_LINES' , 1 ) ;
5094: END IF;
5095: BEGIN
5096:
5097: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5098:
5099: Oe_Config_Schedule_Pvt.Query_Set_Lines
5100: (p_header_id => l_header_id,
5101: p_arrival_set_id => l_set_id,

Line 5106: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN

5102: p_sch_action => l_action,
5103: x_line_tbl => l_line_tbl,
5104: x_return_status => x_return_status);
5105:
5106: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5107:
5108: Oe_Config_Schedule_Pvt.Query_Set_Lines
5109: (p_header_id => l_header_id,
5110: p_ship_set_id => l_set_id,

Line 5194: IF OE_SCHEDULE_UTIL.Set_Attr_Matched

5190:
5191: END IF;
5192: -- following code commented for bug 3878494
5193: /*
5194: IF OE_SCHEDULE_UTIL.Set_Attr_Matched
5195: (p_set_ship_from_org_id => l_line_tbl(1).ship_from_org_id ,
5196: p_line_ship_from_org_id => l_line_tbl(I).ship_from_org_id,
5197: p_set_ship_to_org_id => l_line_tbl(1).ship_to_org_id ,
5198: p_line_ship_to_org_id => l_line_tbl(I).ship_to_org_id ,

Line 5221: IF OE_SCHEDULE_UTIL.Set_Attr_Matched

5217: IF l_debug_level > 0 THEN
5218: oe_debug_pub.add('New Set is being created, comparing scheduling attributes with first line', 5);
5219: END IF;
5220:
5221: IF OE_SCHEDULE_UTIL.Set_Attr_Matched
5222: (p_set_ship_from_org_id => l_line_tbl(1).ship_from_org_id ,
5223: p_line_ship_from_org_id => l_line_tbl(I).ship_from_org_id,
5224: p_set_ship_to_org_id => l_line_tbl(1).ship_to_org_id ,
5225: p_line_ship_to_org_id => l_line_tbl(I).ship_to_org_id ,

Line 5245: IF OE_SCHEDULE_UTIL.Set_Attr_Matched

5241: oe_debug_pub.add('Set already exists, comparing scheduling attributes with set', 5);
5242: END IF;
5243:
5244: -- following code added for bug 3878494
5245: IF OE_SCHEDULE_UTIL.Set_Attr_Matched
5246: (p_set_ship_from_org_id => l_set_rec.ship_from_org_id ,
5247: p_line_ship_from_org_id => l_line_tbl(I).ship_from_org_id,
5248: p_set_ship_to_org_id => l_set_rec.ship_to_org_id ,
5249: p_line_ship_to_org_id => l_line_tbl(I).ship_to_org_id ,

Line 5379: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN

5375: END IF; -- Ato/included.
5376: END IF; -- Check for pack I
5377: -- END 1282873
5378: END LOOP;
5379: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5380:
5381: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);
5382: l_set_name := l_set_rec.set_name;
5383:

Line 5435: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )

5431: END IF;
5432:
5433: -- Start 2787962
5434: IF l_line_tbl(I).top_model_line_id is not null
5435: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5436: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5437: THEN
5438: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5439: ELSIF l_line_tbl(I).ato_line_id is not null

Line 5436: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null

5432:
5433: -- Start 2787962
5434: IF l_line_tbl(I).top_model_line_id is not null
5435: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5436: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5437: THEN
5438: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5439: ELSIF l_line_tbl(I).ato_line_id is not null
5440: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id

Line 5438: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;

5434: IF l_line_tbl(I).top_model_line_id is not null
5435: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5436: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5437: THEN
5438: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5439: ELSIF l_line_tbl(I).ato_line_id is not null
5440: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5441: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5442: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )

Line 5442: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )

5438: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5439: ELSIF l_line_tbl(I).ato_line_id is not null
5440: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5441: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5442: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5443: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5444: THEN
5445: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5446: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

Line 5443: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null

5439: ELSIF l_line_tbl(I).ato_line_id is not null
5440: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5441: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5442: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5443: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5444: THEN
5445: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5446: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5447: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )

Line 5445: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;

5441: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5442: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5443: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5444: THEN
5445: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5446: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5447: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5448: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5449: THEN

Line 5447: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )

5443: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5444: THEN
5445: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5446: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5447: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5448: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5449: THEN
5450: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;
5451:

Line 5448: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null

5444: THEN
5445: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5446: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5447: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5448: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5449: THEN
5450: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;
5451:
5452: END IF;

Line 5450: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;

5446: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5447: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5448: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5449: THEN
5450: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;
5451:
5452: END IF;
5453: -- End 2787962
5454:

Line 5521: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN

5517: END LOOP;
5518: END IF; -- Ship Set
5519:
5520: IF l_entity_type =
5521: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5522:
5523: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);
5524: l_set_name := l_set_rec.set_name;
5525:

Line 5560: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )

5556: END IF;
5557:
5558: -- Start 2787962
5559: IF l_line_tbl(I).top_model_line_id is not null
5560: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5561: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5562: THEN
5563: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5564: ELSIF l_line_tbl(I).ato_line_id is not null

Line 5561: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null

5557:
5558: -- Start 2787962
5559: IF l_line_tbl(I).top_model_line_id is not null
5560: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5561: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5562: THEN
5563: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5564: ELSIF l_line_tbl(I).ato_line_id is not null
5565: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id

Line 5563: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;

5559: IF l_line_tbl(I).top_model_line_id is not null
5560: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5561: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5562: THEN
5563: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5564: ELSIF l_line_tbl(I).ato_line_id is not null
5565: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5566: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION, OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5567: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )

Line 5567: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )

5563: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5564: ELSIF l_line_tbl(I).ato_line_id is not null
5565: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5566: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION, OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5567: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5568: AND oe_schedule_util.OE_sch_Attrb_Tbl (mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5569: THEN
5570: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5571: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

Line 5568: AND oe_schedule_util.OE_sch_Attrb_Tbl (mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null

5564: ELSIF l_line_tbl(I).ato_line_id is not null
5565: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5566: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION, OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5567: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5568: AND oe_schedule_util.OE_sch_Attrb_Tbl (mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5569: THEN
5570: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5571: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5572: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )

Line 5570: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;

5566: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION, OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5567: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5568: AND oe_schedule_util.OE_sch_Attrb_Tbl (mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5569: THEN
5570: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5571: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5572: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5573: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5574: THEN

Line 5572: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )

5568: AND oe_schedule_util.OE_sch_Attrb_Tbl (mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5569: THEN
5570: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5571: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5572: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5573: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5574: THEN
5575: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;
5576:

Line 5573: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null

5569: THEN
5570: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;
5571: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5572: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5573: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5574: THEN
5575: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;
5576:
5577: END IF;

Line 5575: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;

5571: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5572: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT) )
5573: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5574: THEN
5575: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).link_to_line_id, G_BINARY_LIMIT)).date_attribute1;
5576:
5577: END IF;
5578: -- End 2787962
5579:

Line 5582: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )

5578: -- End 2787962
5579:
5580: -- Start 2391781
5581: IF NVL(l_line_tbl(I).Ship_model_complete_flag,'N') = 'Y'
5582: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5583: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1 is not null
5584: THEN
5585: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1;
5586: ELSIF l_line_tbl(I).ato_line_id is not null

Line 5583: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1 is not null

5579:
5580: -- Start 2391781
5581: IF NVL(l_line_tbl(I).Ship_model_complete_flag,'N') = 'Y'
5582: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5583: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1 is not null
5584: THEN
5585: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1;
5586: ELSIF l_line_tbl(I).ato_line_id is not null
5587: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id

Line 5585: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1;

5581: IF NVL(l_line_tbl(I).Ship_model_complete_flag,'N') = 'Y'
5582: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT) )
5583: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1 is not null
5584: THEN
5585: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1;
5586: ELSIF l_line_tbl(I).ato_line_id is not null
5587: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5588: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5589: OE_GLOBALS.G_ITEM_OPTION,

Line 5591: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )

5587: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5588: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5589: OE_GLOBALS.G_ITEM_OPTION,
5590: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5591: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5592: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1 is not null
5593: THEN
5594: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1;
5595: END IF;

Line 5592: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1 is not null

5588: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5589: OE_GLOBALS.G_ITEM_OPTION,
5590: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5591: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5592: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1 is not null
5593: THEN
5594: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1;
5595: END IF;
5596:

Line 5594: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1;

5590: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5591: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5592: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1 is not null
5593: THEN
5594: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1;
5595: END IF;
5596:
5597: -- 2391781
5598:

Line 5657: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.FIRST;

5653: END IF;
5654:
5655: -- Start 2391781
5656: --- Deleteing delayed request of type cascade_warehous
5657: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.FIRST;
5658: WHILE l_index is not null
5659: LOOP
5660: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5661: THEN

Line 5660: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id

5656: --- Deleteing delayed request of type cascade_warehous
5657: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.FIRST;
5658: WHILE l_index is not null
5659: LOOP
5660: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5661: THEN
5662: oe_schedule_util.OE_sch_Attrb_Tbl.delete(l_index);
5663: END IF;
5664: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.NEXT(l_index);

Line 5662: oe_schedule_util.OE_sch_Attrb_Tbl.delete(l_index);

5658: WHILE l_index is not null
5659: LOOP
5660: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5661: THEN
5662: oe_schedule_util.OE_sch_Attrb_Tbl.delete(l_index);
5663: END IF;
5664: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.NEXT(l_index);
5665: END LOOP;
5666:

Line 5664: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.NEXT(l_index);

5660: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5661: THEN
5662: oe_schedule_util.OE_sch_Attrb_Tbl.delete(l_index);
5663: END IF;
5664: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.NEXT(l_index);
5665: END LOOP;
5666:
5667: -- End 2391781
5668:

Line 5669: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.count > 0 THEN

5665: END LOOP;
5666:
5667: -- End 2391781
5668:
5669: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.count > 0 THEN
5670: FOR I IN 1..l_line_tbl.count LOOP
5671:
5672: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS
5673: (l_line_tbl(I).line_id) THEN

Line 5672: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS

5668:
5669: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.count > 0 THEN
5670: FOR I IN 1..l_line_tbl.count LOOP
5671:
5672: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS
5673: (l_line_tbl(I).line_id) THEN
5674:
5675: OE_SCHEDULE_UTIL.OE_Override_Tbl.delete
5676: (l_line_tbl(I).line_id);

Line 5675: OE_SCHEDULE_UTIL.OE_Override_Tbl.delete

5671:
5672: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS
5673: (l_line_tbl(I).line_id) THEN
5674:
5675: OE_SCHEDULE_UTIL.OE_Override_Tbl.delete
5676: (l_line_tbl(I).line_id);
5677:
5678: END IF;
5679:

Line 5746: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

5742: FOR I IN 1..l_line_tbl.count LOOP
5743: oe_debug_pub.add('2740480: Entity type : '|| l_entity_type);
5744: oe_debug_pub.add('2740480: line schedule ship date : '|| l_line_tbl(I).Schedule_ship_date);
5745: oe_debug_pub.add('2740480: set schedule ship date : '|| l_set_rec.Schedule_ship_date );
5746: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
5747: AND trunc(l_line_tbl(I).Schedule_ship_date) <> trunc(l_set_rec.Schedule_ship_date)
5748: THEN
5749: IF l_debug_level > 0 THEN
5750: oe_debug_pub.add('2740480: Not received correct values for ship set',1);

Line 5754: ELSIF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

5750: oe_debug_pub.add('2740480: Not received correct values for ship set',1);
5751: END IF;
5752: l_date_changed := 'Y' ;
5753: EXIT;
5754: ELSIF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5755: AND trunc(l_line_tbl(I).Schedule_arrival_date) <> trunc(l_set_rec.Schedule_arrival_date)
5756: THEN
5757: IF l_debug_level > 0 THEN
5758: oe_debug_pub.add('2740480: Not received correct values for arrival set',1);

Line 5858: oe_schedule_util.Log_Delete_Set_Request

5854:
5855: -- 4026758
5856: IF l_line_tbl(I).ship_set_id IS NOT NULL
5857: OR l_line_tbl(I).arrival_set_id IS NOT NULL THEN
5858: oe_schedule_util.Log_Delete_Set_Request
5859: (p_header_id => l_line_tbl(I).header_id,
5860: p_line_id => l_line_tbl(I).line_id,
5861: p_set_id => nvl(l_line_tbl(I).ship_set_id,l_line_tbl(I).arrival_set_id),
5862: x_return_status => x_return_status);

Line 5970: OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

5966: WHEN FND_API.G_EXC_ERROR THEN
5967: --3543774 If new set show the error message
5968: IF p_request_rec.request_type = OE_GLOBALS.G_GROUP_SCHEDULE
5969: AND ((l_entity_type =
5970: OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
5971: AND NOT OE_GLOBALS.equal(l_ship_set_id,l_old_ship_set_id))
5972: OR (l_entity_type =
5973: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5974: AND NOT OE_GLOBALS.equal(l_arrival_set_id,l_old_arrival_set_id)))

Line 5973: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

5969: AND ((l_entity_type =
5970: OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
5971: AND NOT OE_GLOBALS.equal(l_ship_set_id,l_old_ship_set_id))
5972: OR (l_entity_type =
5973: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5974: AND NOT OE_GLOBALS.equal(l_arrival_set_id,l_old_arrival_set_id)))
5975: THEN
5976: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5977: OE_MSG_PUB.Add;

Line 6087: IF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

6083: END IF;
6084: IF l_set_exists = 'N' THEN
6085: GOTO END_PROCESS;
6086: END IF;
6087: IF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
6088: THEN
6089: Oe_Config_Schedule_Pvt.Query_Set_Lines
6090: (p_header_id => p_sch_set_tbl(I).param2,
6091: p_arrival_set_id => p_sch_set_tbl(I).entity_id,

Line 6097: ELSIF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

6093: x_line_tbl => l_line_tbl,
6094: x_return_status => l_return_status);
6095:
6096:
6097: ELSIF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
6098: THEN
6099:
6100: Oe_Config_Schedule_Pvt.Query_Set_Lines
6101: (p_header_id => p_sch_set_tbl(I).param2,

Line 6124: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_tbl(J),

6120: END IF;
6121:
6122: FOR J IN 1..l_line_tbl.count LOOP
6123:
6124: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_tbl(J),
6125: p_old_line_rec => l_line_tbl(J),
6126: p_sch_action => 'SCHEDULE' ,
6127: x_return_status => l_return_status);
6128:

Line 6245: oe_schedule_util.Log_Delete_Set_Request

6241: END IF;
6242: -- 4026758
6243: IF l_sch_line_tbl(I).ship_set_id IS NOT NULL
6244: OR l_sch_line_tbl(I).arrival_set_id IS NOT NULL THEN
6245: oe_schedule_util.Log_Delete_Set_Request
6246: (p_header_id => l_sch_line_tbl(I).header_id,
6247: p_line_id => l_sch_line_tbl(I).line_id,
6248: p_set_id => nvl(l_sch_line_tbl(I).ship_set_id,l_sch_line_tbl(I).arrival_set_id),
6249: x_return_status => x_return_status);

Line 6272: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

6268: Oe_Config_Schedule_Pvt.Process_Group
6269: (p_x_line_tbl => l_sch_line_tbl
6270: ,p_old_line_tbl => l_old_line_tbl
6271: ,p_caller => 'SET'
6272: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
6273: ,p_partial => TRUE
6274: ,x_return_status => x_return_status);
6275:
6276: IF l_debug_level > 0 THEN

Line 6368: oe_schedule_util.Log_Delete_Set_Request

6364: -- Begin 4026758
6365: IF l_sch_line_tbl(I).ship_set_id IS NOT NULL
6366: OR l_sch_line_tbl(I).arrival_set_id IS NOT NULL THEN
6367:
6368: oe_schedule_util.Log_Delete_Set_Request
6369: (p_header_id => l_sch_line_tbl(I).header_id,
6370: p_line_id => l_sch_line_tbl(I).line_id,
6371: p_set_id => nvl(l_sch_line_tbl(I).ship_set_id,l_sch_line_tbl(I).arrival_set_id),
6372: x_return_status => l_return_status);