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 76: oe_debug_pub.add( '..ENTERING OE_SCHEDULE_UTIL.VALIDATE_GROUP_LINE' , 6 ) ;

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

Line 183: OE_SCHEDULE_UTIL.Get_Scheduling_Level(p_line_rec.header_id,

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

Line 191: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN

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

Line 196: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,

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

Line 197: OE_SCHEDULE_UTIL.sch_cached_order_type));

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

Line 204: ELSIF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_TWO

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

Line 206: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

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

Line 212: OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE));

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

Line 214: nvl(OE_SCHEDULE_UTIL.sch_cached_line_type,

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

Line 215: OE_SCHEDULE_UTIL.sch_cached_order_type));

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

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

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

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

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

Line 599: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR

595:
596: -- Process Included Items if the action is schedule, atp_check
597: -- and reserve.
598:
599: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
600: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
601: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
602:
603: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 600: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR

596: -- Process Included Items if the action is schedule, atp_check
597: -- and reserve.
598:
599: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
600: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
601: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
602:
603: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
604: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

Line 601: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

597: -- and reserve.
598:
599: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
600: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
601: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
602:
603: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
604: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
605:

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

599: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE OR
600: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE OR
601: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
602:
603: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
604: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
605:
606: FOR I IN process_inc LOOP
607:

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

623: END IF;
624:
625: END LOOP;
626:
627: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
628: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
629:
630: END IF;
631:

Line 634: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

630: END IF;
631:
632:
633:
634: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
635: THEN
636:
637: -- If the action is schedule,
638: -- then only query the lines that are not scheduled.

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

684: -- 2766876
685: l_line_rec.reserved_quantity := 0;
686:
687: l_return_status := FND_API.G_RET_STS_SUCCESS;
688: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
689: p_old_line_rec => l_line_rec,
690: p_sch_action => p_sch_action,
691: x_return_status => l_return_status);
692:

Line 729: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

725: END IF; -- schedule status code
726:
727: END LOOP;
728:
729: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
730: THEN
731:
732:
733: --If the line is not scheduled,system should schedule and reserve the line.

Line 781: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);

777: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
778:
779: IF l_sales_order_id is null THEN
780: l_sales_order_id :=
781: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
782: END IF;
783:
784: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
785:

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

827: END IF;
828:
829: -- Check if the line is eligible for reservation.
830: l_return_status := FND_API.G_RET_STS_SUCCESS;
831: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
832: p_old_line_rec => l_line_rec,
833: p_sch_action => p_sch_action,
834: x_return_status => l_return_status);
835:

Line 870: OE_SCHEDULE_UTIL.Reserve_Line

866: --partial reservation exists
867: IF nvl(l_line_rec.reserved_quantity,0) > 0 THEN
868: l_rsv_update := TRUE;
869: END IF;
870: OE_SCHEDULE_UTIL.Reserve_Line
871: (p_line_rec => l_line_rec
872: ,p_quantity_to_reserve => l_quantity_to_reserve --l_line_rec.ordered_quantity
873: ,p_quantity2_to_reserve => l_quantity2_to_reserve --l_line_rec.ordered_quantity2
874: ,p_rsv_update => l_rsv_update

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

922:
923: l_line_rec.reserved_quantity := 0;
924: l_line_rec.reserved_quantity2 := 0; -- INCONV
925: l_return_status := FND_API.G_RET_STS_SUCCESS;
926: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
927: p_old_line_rec => l_line_rec,
928: p_sch_action => p_sch_action,
929: x_return_status => l_return_status);
930:

Line 962: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK

958: END IF; -- return status.
959: END IF; -- scheduled line.
960: END LOOP;
961:
962: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
963: THEN
964:
965: -- Load line table with scheduled and unscheduled lines.
966:

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

970: I := I + 1;
971:
972: IF I = 1 THEN */ -- 2327783
973: IF l_sales_order_id IS NULL THEN
974: l_sales_order_id :=OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
975: END IF;
976:
977: IF l_debug_level > 0 THEN
978: oe_debug_pub.add( 'LINE SELECTED FOR ATP **** : ' || C1.LINE_ID , 1 ) ;

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

1004: l_line_rec.schedule_action_code := p_sch_action;
1005:
1006:
1007: l_return_status := FND_API.G_RET_STS_SUCCESS;
1008: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
1009: p_old_line_rec => l_line_rec,
1010: p_sch_action => p_sch_action,
1011: x_return_status => l_return_status);
1012:

Line 1075: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN

1071: END IF; -- Validation success
1072: END LOOP;
1073:
1074:
1075: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN
1076:
1077: -- Lines are already scheduled. We no need to explode the included items.
1078:
1079: I := 0;

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

1099: -- ignore the line.
1100: IF nvl(c2.shippable_flag,'N') = 'Y' THEN
1101:
1102: IF (nvl(c2.shipping_interfaced_flag,'N') = 'Y'
1103: AND oe_schedule_util.Get_Pick_Status(c2.line_id)) THEN -- 2595661
1104:
1105:
1106: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
1107: OE_MSG_PUB.Add;

Line 1146: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);

1142: l_line_rec.source_document_type_id);
1143:
1144: IF l_sales_order_id is null THEN
1145: l_sales_order_id :=
1146: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
1147: END IF;
1148:
1149:
1150: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 1190: l_sales_order_id :=OE_SCHEDULE_UTIL.

1186:
1187: -- I := I + 1; 2327783
1188: IF l_sales_order_id is null THEN
1189:
1190: l_sales_order_id :=OE_SCHEDULE_UTIL.
1191: Get_mtl_sales_order_id(p_header_id);
1192:
1193: END IF;
1194:

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

1200: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1201: l_line_rec.schedule_action_code := p_sch_action;
1202: l_return_status := FND_API.G_RET_STS_SUCCESS;
1203:
1204: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
1205: p_old_line_rec => l_line_rec,
1206: p_sch_action => p_sch_action,
1207: x_return_status => l_return_status);
1208:

Line 1222: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE

1218: l_line_rec.reserved_quantity := 0;
1219: END IF; -- Line is not shippable line.
1220:
1221: END LOOP;
1222: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE
1223: THEN
1224:
1225: -- Lines are already scheduled. We no need to explode the included items.
1226:

Line 1255: l_sales_order_id :=OE_SCHEDULE_UTIL.

1251: I := I + 1;
1252: IF I = 1 THEN */ -- 2327783
1253:
1254: IF l_sales_order_id IS NULL THEN
1255: l_sales_order_id :=OE_SCHEDULE_UTIL.
1256: Get_mtl_sales_order_id(p_header_id);
1257: END IF;
1258:
1259:

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

1295: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1296: l_line_rec.schedule_action_code := p_sch_action;
1297:
1298: l_return_status := FND_API.G_RET_STS_SUCCESS;
1299: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_rec,
1300: p_old_line_rec => l_line_rec,
1301: p_sch_action => p_sch_action,
1302: x_return_status => l_return_status);
1303:

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

1371: IF l_debug_level > 0 THEN
1372: oe_debug_pub.add( 'EXPECTED ERROR IN QUERY LINES ' , 1 ) ;
1373: END IF;
1374: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1375: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1376: RAISE FND_API.G_EXC_ERROR;
1377:
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379:

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

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

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

1389: IF l_debug_level > 0 THEN
1390: oe_debug_pub.add( 'WHEN OTHERS ERROR IN QUERY LINES ' , 1 ) ;
1391: END IF;
1392: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1393: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1395: THEN
1396: OE_MSG_PUB.Add_Exc_Msg
1397: ( G_PKG_NAME

Line 2058: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2054: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2055:
2056: IF l_sales_order_id is null THEN
2057: l_sales_order_id :=
2058: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2059: (l_line_rec.header_id);
2060: END IF;
2061:
2062:

Line 2287: AND oe_schedule_util.Get_Pick_Status(l_line_id))

2283:
2284: IF l_schedule_status_code IS NULL
2285: OR nvl(l_open_flag,'Y') = 'N'
2286: OR (l_shipping_interfaced_flag = 'Y'
2287: AND oe_schedule_util.Get_Pick_Status(l_line_id))
2288: THEN -- 2595661
2289: -- Go inside only if they are scheduled.
2290: -- and not part of set.
2291: IF l_shipping_interfaced_flag = 'Y' THEN

Line 2385: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2381: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2382:
2383: IF l_sales_order_id is null THEN
2384: l_sales_order_id :=
2385: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2386: (l_line_rec.header_id);
2387: END IF;
2388:
2389: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 2777: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2773: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2774:
2775: IF l_sales_order_id is null THEN
2776: l_sales_order_id :=
2777: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2778: (l_line_rec.header_id);
2779: END IF;
2780:
2781: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

Line 2837: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

2833: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2834:
2835: IF l_sales_order_id is null THEN
2836: l_sales_order_id :=
2837: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2838: (l_line_rec.header_id);
2839: END IF;
2840:
2841: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

2959: END IF;
2960:
2961: -- Check if the line is eligible for reservation.
2962: l_return_status := FND_API.G_RET_STS_SUCCESS;
2963: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_tbl(I),
2964: p_old_line_rec => l_line_tbl(I),
2965: p_sch_action => p_sch_action,
2966: x_return_status => l_return_status);
2967:

Line 3002: OE_SCHEDULE_UTIL.Reserve_Line

2998: IF nvl(l_line_tbl(I).reserved_quantity,0) > 0 THEN
2999: l_rsv_update := TRUE;
3000: END IF;
3001:
3002: OE_SCHEDULE_UTIL.Reserve_Line
3003: (p_line_rec => l_line_tbl(I)
3004: ,p_quantity_to_reserve => l_quantity_to_reserve --l_line_tbl(I).ordered_quantity
3005: ,p_quantity2_to_reserve => l_quantity2_to_reserve --l_line_tbl(I).ordered_quantity2 -- INVCONV
3006: ,p_rsv_update => l_rsv_update

Line 3352: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id

3348: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
3349:
3350: IF l_sales_order_id is null THEN
3351: l_sales_order_id :=
3352: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3353: (l_line_rec.header_id);
3354: END IF;
3355:
3356: l_line_rec.reserved_quantity :=

Line 3507: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3503:
3504: -- Start 2434807 -
3505: -- Added to clear existing records from g_atp_tbl
3506: -- before starting scheduling event
3507: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3508: Oe_Schedule_Util.g_atp_tbl.delete;
3509: END IF;
3510: -- End 2434807 -
3511:

Line 3508: Oe_Schedule_Util.g_atp_tbl.delete;

3504: -- Start 2434807 -
3505: -- Added to clear existing records from g_atp_tbl
3506: -- before starting scheduling event
3507: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3508: Oe_Schedule_Util.g_atp_tbl.delete;
3509: END IF;
3510: -- End 2434807 -
3511:
3512:

Line 3519: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3515: x_line_tbl => l_line_tbl);
3516:
3517: l_old_line_tbl := l_line_tbl;
3518:
3519: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3520: IF l_debug_level > 0 THEN
3521: oe_debug_pub.add( 'BEFORE CALLING MULTI_ATP_CHECK ' ) ;
3522: END IF;
3523: IF l_debug_level > 0 THEN

Line 3529: OE_SCHEDULE_UTIL.Multi_ATP_CHECK

3525: END IF;
3526:
3527: IF l_line_tbl.count > 0 THEN
3528:
3529: OE_SCHEDULE_UTIL.Multi_ATP_CHECK
3530: (p_old_line_tbl => l_old_line_tbl,
3531: p_x_line_tbl => l_line_tbl,
3532: x_atp_tbl => x_atp_tbl,
3533: x_return_status => x_return_status);

Line 3567: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN

3563: ,p_partial => TRUE
3564: ,x_return_status => x_return_status);
3565: ELSE
3566:
3567: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN
3568: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3569: OE_MSG_PUB.Add;
3570: END IF;
3571: END IF;

Line 3675: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3671:
3672: -- Start 2434807 -
3673: -- Added to clear existing records from g_atp_tbl
3674: -- before starting scheduling event
3675: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3676: Oe_Schedule_Util.g_atp_tbl.delete;
3677: END IF;
3678: -- End 2434807 -
3679:

Line 3676: Oe_Schedule_Util.g_atp_tbl.delete;

3672: -- Start 2434807 -
3673: -- Added to clear existing records from g_atp_tbl
3674: -- before starting scheduling event
3675: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3676: Oe_Schedule_Util.g_atp_tbl.delete;
3677: END IF;
3678: -- End 2434807 -
3679:
3680: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3702: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE THEN

3698: nextpos := INSTR(l_record_ids,',',1,j) ;
3699:
3700: END LOOP;
3701: */
3702: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE THEN
3703:
3704: Query_Schedule_lines(p_sch_action => p_sch_action,
3705: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3706: x_line_tbl => l_line_tbl);

Line 3708: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN

3704: Query_Schedule_lines(p_sch_action => p_sch_action,
3705: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3706: x_line_tbl => l_line_tbl);
3707:
3708: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE THEN
3709:
3710: Query_Unschedule_lines(p_sch_action => p_sch_action,
3711: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3712: x_line_tbl => l_line_tbl);

Line 3714: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN

3710: Query_Unschedule_lines(p_sch_action => p_sch_action,
3711: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3712: x_line_tbl => l_line_tbl);
3713:
3714: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE THEN
3715:
3716: Query_Unreserve_lines(p_sch_action => p_sch_action,
3717: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3718: x_line_tbl => l_line_tbl);

Line 3720: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN

3716: Query_Unreserve_lines(p_sch_action => p_sch_action,
3717: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3718: x_line_tbl => l_line_tbl);
3719:
3720: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE THEN
3721:
3722: Query_Reserve_lines(p_sch_action => p_sch_action,
3723: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3724: x_line_tbl => l_line_tbl);

Line 3726: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN

3722: Query_Reserve_lines(p_sch_action => p_sch_action,
3723: p_selected_tbl => p_selected_line_tbl, --R12.MOAC
3724: x_line_tbl => l_line_tbl);
3725:
3726: ELSIF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK THEN
3727: --Bug 5881611
3728: --Creating a savepoint, so that it can be be rolled for ATP Checks.
3729: --This is to rollback updates to database made by Availability window, which
3730: --calls process_included_items to explode included items and oe_order_pvt.lines

Line 3793: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK

3789: END LOOP;
3790:
3791: ------- Action Specific processing -----------------------
3792: -- 3990887
3793: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3794: THEN
3795: --Bug 5881611
3796: --Rolling back
3797: oe_debug_pub.add('Rollback for only atp check');

Line 3809: OE_SCHEDULE_UTIL.Multi_ATP_CHECK

3805: IF l_debug_level > 0 THEN
3806: oe_debug_pub.add( 'LINE COUNT ' || L_LINE_TBL.COUNT , 1 ) ;
3807: END IF;
3808:
3809: OE_SCHEDULE_UTIL.Multi_ATP_CHECK
3810: (p_old_line_tbl => l_old_line_tbl,
3811: p_x_line_tbl => l_line_tbl,
3812: x_atp_tbl => x_atp_tbl,
3813: x_return_status => x_return_status);

Line 3842: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE

3838: -- RAISE FND_API.G_EXC_ERROR;
3839: END IF;
3840:
3841: ELSE
3842: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
3843: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3844: THEN
3845: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3846: OE_MSG_PUB.Add;

Line 3843: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK

3839: END IF;
3840:
3841: ELSE
3842: IF p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
3843: AND p_sch_action <> OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK
3844: THEN
3845: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3846: OE_MSG_PUB.Add;
3847: END IF;

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

4060: END;
4061:
4062: --{bug3885953: If the ship/arrival set has changed, do not use old delayed
4063: --request, but just go to the end of processing
4064: IF (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET AND
4065: l_ship_set_id <> p_sch_set_tbl(I).param1) OR
4066: (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET AND
4067: l_arrival_set_id <> p_sch_set_tbl(I).param1) THEN
4068: IF l_debug_level > 0 THEN

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

4062: --{bug3885953: If the ship/arrival set has changed, do not use old delayed
4063: --request, but just go to the end of processing
4064: IF (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET AND
4065: l_ship_set_id <> p_sch_set_tbl(I).param1) OR
4066: (p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET AND
4067: l_arrival_set_id <> p_sch_set_tbl(I).param1) THEN
4068: IF l_debug_level > 0 THEN
4069: OE_DEBUG_PUB.Add('Sets differs, goto END OF PROCESS',2);
4070: END IF;

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

4182: AND l_line_rec.schedule_status_code is not null THEN
4183:
4184: IF l_sales_order_id is null THEN
4185: l_sales_order_id :=
4186: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.header_id);
4187: END IF;
4188:
4189: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
4190:

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

4252:
4253: /* Commented the above line to fix the bug 2916814 */
4254: --3564302 (#1)
4255: -- Get the order date type code
4256: l_type_code := oe_schedule_util.Get_Date_Type(l_line_tbl(K).header_id);
4257:
4258: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4259: THEN
4260: -- Ship set date.

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

4254: --3564302 (#1)
4255: -- Get the order date type code
4256: l_type_code := oe_schedule_util.Get_Date_Type(l_line_tbl(K).header_id);
4257:
4258: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4259: THEN
4260: -- Ship set date.
4261: l_line_tbl(K).Schedule_ship_date := p_sch_set_tbl(I).date_param4;
4262: -- 3564302

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

4272: l_line_tbl(K).shipping_method_code := p_sch_set_tbl(I).param11;
4273: END IF;
4274: END IF;
4275:
4276: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
4277: THEN
4278: l_line_tbl(K).Schedule_arrival_date := p_sch_set_tbl(I).date_param5;
4279: -- 3564302(issue 1)
4280: IF l_type_code = 'SHIP' THEN

Line 4293: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

4289: l_line_tbl(K).ship_to_org_id := p_sch_set_tbl(I).param9;
4290: END IF;
4291:
4292: l_line_tbl(K).schedule_action_code :=
4293: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
4294:
4295:
4296: IF l_line_tbl(K).arrival_set_id is not null THEN
4297: l_line_tbl(K).arrival_set := l_line_tbl(K).arrival_set_id;

Line 4382: oe_schedule_util.Log_Delete_Set_Request

4378: END IF;
4379: -- 4026758
4380: IF l_iline_tbl(I).ship_set_id IS NOT NULL
4381: OR l_iline_tbl(I).arrival_set_id IS NOT NULL THEN
4382: oe_schedule_util.Log_Delete_Set_Request
4383: (p_header_id => l_iline_tbl(I).header_id,
4384: p_line_id => l_iline_tbl(I).line_id,
4385: p_set_id => nvl(l_iline_tbl(I).ship_set_id,
4386: l_iline_tbl(I).arrival_set_id),

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

4416:
4417: -- Start 2716220 --
4418: -- To check schedule dates with override flag
4419:
4420: l_type_code := oe_schedule_util.Get_Date_Type(l_header_id);
4421:
4422: IF l_arrival_set_id is not null THEN
4423:
4424: l_set_rec := OE_ORDER_CACHE.Load_Set

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

4509: /* End Audit Trail */
4510:
4511: l_line_tbl(K).operation := OE_GLOBALS.G_OPR_UPDATE;
4512:
4513: IF p_sch_set_tbl(I).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4514: THEN
4515: -- Ship set date.
4516: l_line_tbl(K).Schedule_ship_date := p_sch_set_tbl(I).date_param4;
4517: -- 3564302

Line 4532: = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

4528: END IF;
4529: END IF;
4530:
4531: IF p_sch_set_tbl(I).param8
4532: = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
4533: THEN
4534: l_line_tbl(K).Schedule_arrival_date
4535: := p_sch_set_tbl(I).date_param5;
4536: -- 3564302

Line 4550: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;

4546: l_line_tbl(K).ship_to_org_id := p_sch_set_tbl(I).param9;
4547: END IF;
4548:
4549: l_line_tbl(K).schedule_action_code :=
4550: OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
4551:
4552: IF l_line_tbl(K).arrival_set_id is not null THEN
4553: l_line_tbl(K).arrival_set := l_line_tbl(K).arrival_set_id;
4554: ELSE

Line 4590: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE

4586: Oe_Config_Schedule_Pvt.Process_Group
4587: (p_x_line_tbl => l_line_tbl
4588: ,p_old_line_tbl => l_old_line_tbl
4589: ,p_caller => 'SET'
4590: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE
4591: ,p_partial_set => TRUE
4592: ,p_part_of_set => l_part_of_set --4405004
4593: ,x_return_status => x_return_status);
4594:

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

4608: END IF;
4609:
4610: FOR I IN 1..l_line_tbl.count LOOP
4611:
4612: IF p_sch_set_tbl(1).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
4613: AND trunc(l_line_tbl(I).Schedule_ship_date) <> trunc(p_sch_set_tbl(1).date_param4)
4614: THEN
4615: IF l_debug_level > 0 THEN
4616: oe_debug_pub.add('Not received correct values for ship set',1);

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

4616: oe_debug_pub.add('Not received correct values for ship set',1);
4617: END IF;
4618: x_return_status := FND_API.G_RET_STS_ERROR;
4619: EXIT;
4620: ELSIF p_sch_set_tbl(1).param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
4621: AND trunc(l_line_tbl(I).Schedule_arrival_date) <> trunc(p_sch_set_tbl(1).date_param5)
4622: THEN
4623: IF l_debug_level > 0 THEN
4624: oe_debug_pub.add('Not received correct values for arrival set',1);

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

4647: END IF;
4648:
4649: -- Added this stmt to fix big 1899651.
4650: l_request_rec := p_sch_set_tbl(1);
4651: l_request_rec.param3 := OE_SCHEDULE_UTIL.OESCH_ACT_RESCHEDULE;
4652: -- 3384975
4653: l_request_rec.param12 := l_param12;
4654:
4655: IF l_debug_level > 0 THEN

Line 4744: oe_schedule_util.Log_Delete_Set_Request

4740: END IF;
4741: -- 4026758
4742: IF l_line_tbl(I).ship_set_id IS NOT NULL
4743: OR l_line_tbl(I).arrival_set_id IS NOT NULL THEN
4744: oe_schedule_util.Log_Delete_Set_Request
4745: (p_header_id => l_line_tbl(I).header_id,
4746: p_line_id => l_line_tbl(I).line_id,
4747: p_set_id => nvl(l_line_tbl(I).ship_set_id,l_line_tbl(I).arrival_set_id),
4748: x_return_status => x_return_status);

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

4953:
4954: -- 5043206
4955: BEGIN
4956:
4957: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
4958:
4959: Select 1 into l_count from OE_ORDER_LINES_ALL
4960: WHERE header_id = l_header_id and arrival_Set_id = p_request_rec.param1
4961: AND rownum = 1;

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

4959: Select 1 into l_count from OE_ORDER_LINES_ALL
4960: WHERE header_id = l_header_id and arrival_Set_id = p_request_rec.param1
4961: AND rownum = 1;
4962:
4963: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
4964:
4965: Select 1 into l_count from OE_ORDER_LINES_ALL
4966: WHERE header_id = l_header_id and ship_set_id = p_request_rec.param1
4967: AND rownum = 1;

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

5005: oe_debug_pub.add( 'CALLING QUERY_SET_LINES' , 1 ) ;
5006: END IF;
5007: BEGIN
5008:
5009: IF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5010:
5011: Oe_Config_Schedule_Pvt.Query_Set_Lines
5012: (p_header_id => l_header_id,
5013: p_arrival_set_id => l_set_id,

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

5014: p_sch_action => l_action,
5015: x_line_tbl => l_line_tbl,
5016: x_return_status => x_return_status);
5017:
5018: ELSIF p_request_rec.param8 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5019:
5020: Oe_Config_Schedule_Pvt.Query_Set_Lines
5021: (p_header_id => l_header_id,
5022: p_ship_set_id => l_set_id,

Line 5106: IF OE_SCHEDULE_UTIL.Set_Attr_Matched

5102:
5103: END IF;
5104: -- following code commented for bug 3878494
5105: /*
5106: IF OE_SCHEDULE_UTIL.Set_Attr_Matched
5107: (p_set_ship_from_org_id => l_line_tbl(1).ship_from_org_id ,
5108: p_line_ship_from_org_id => l_line_tbl(I).ship_from_org_id,
5109: p_set_ship_to_org_id => l_line_tbl(1).ship_to_org_id ,
5110: p_line_ship_to_org_id => l_line_tbl(I).ship_to_org_id ,

Line 5133: IF OE_SCHEDULE_UTIL.Set_Attr_Matched

5129: IF l_debug_level > 0 THEN
5130: oe_debug_pub.add('New Set is being created, comparing scheduling attributes with first line', 5);
5131: END IF;
5132:
5133: IF OE_SCHEDULE_UTIL.Set_Attr_Matched
5134: (p_set_ship_from_org_id => l_line_tbl(1).ship_from_org_id ,
5135: p_line_ship_from_org_id => l_line_tbl(I).ship_from_org_id,
5136: p_set_ship_to_org_id => l_line_tbl(1).ship_to_org_id ,
5137: p_line_ship_to_org_id => l_line_tbl(I).ship_to_org_id ,

Line 5157: IF OE_SCHEDULE_UTIL.Set_Attr_Matched

5153: oe_debug_pub.add('Set already exists, comparing scheduling attributes with set', 5);
5154: END IF;
5155:
5156: -- following code added for bug 3878494
5157: IF OE_SCHEDULE_UTIL.Set_Attr_Matched
5158: (p_set_ship_from_org_id => l_set_rec.ship_from_org_id ,
5159: p_line_ship_from_org_id => l_line_tbl(I).ship_from_org_id,
5160: p_set_ship_to_org_id => l_set_rec.ship_to_org_id ,
5161: p_line_ship_to_org_id => l_line_tbl(I).ship_to_org_id ,

Line 5290: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN

5286: END IF; -- Ato/included.
5287: END IF; -- Check for pack I
5288: -- END 1282873
5289: END LOOP;
5290: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET THEN
5291:
5292: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);
5293: l_set_name := l_set_rec.set_name;
5294:

Line 5343: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5339: END IF;
5340:
5341: -- Start 2787962
5342: IF l_line_tbl(I).top_model_line_id is not null
5343: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5344: (l_line_tbl(I).top_model_line_id )
5345: AND oe_schedule_util.OE_sch_Attrb_Tbl
5346: (l_line_tbl(I).top_model_line_id).date_attribute1 is not null
5347: THEN

Line 5345: AND oe_schedule_util.OE_sch_Attrb_Tbl

5341: -- Start 2787962
5342: IF l_line_tbl(I).top_model_line_id is not null
5343: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5344: (l_line_tbl(I).top_model_line_id )
5345: AND oe_schedule_util.OE_sch_Attrb_Tbl
5346: (l_line_tbl(I).top_model_line_id).date_attribute1 is not null
5347: THEN
5348: l_line_tbl(I).request_date :=
5349: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5349: oe_schedule_util.OE_sch_Attrb_Tbl

5345: AND oe_schedule_util.OE_sch_Attrb_Tbl
5346: (l_line_tbl(I).top_model_line_id).date_attribute1 is not null
5347: THEN
5348: l_line_tbl(I).request_date :=
5349: oe_schedule_util.OE_sch_Attrb_Tbl
5350: (l_line_tbl(I).top_model_line_id).date_attribute1;
5351: ELSIF l_line_tbl(I).ato_line_id is not null
5352: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5353: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

Line 5355: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5351: ELSIF l_line_tbl(I).ato_line_id is not null
5352: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5353: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5354: OE_GLOBALS.G_ITEM_OPTION))
5355: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5356: (l_line_tbl(I).ato_line_id )
5357: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5358: .date_attribute1 is not null
5359: THEN

Line 5357: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)

5353: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5354: OE_GLOBALS.G_ITEM_OPTION))
5355: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5356: (l_line_tbl(I).ato_line_id )
5357: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5358: .date_attribute1 is not null
5359: THEN
5360: l_line_tbl(I).request_date :=
5361: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5361: oe_schedule_util.OE_sch_Attrb_Tbl

5357: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5358: .date_attribute1 is not null
5359: THEN
5360: l_line_tbl(I).request_date :=
5361: oe_schedule_util.OE_sch_Attrb_Tbl
5362: (l_line_tbl(I).ato_line_id).date_attribute1;
5363: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5364: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5365: (l_line_tbl(I).link_to_line_id )

Line 5364: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5360: l_line_tbl(I).request_date :=
5361: oe_schedule_util.OE_sch_Attrb_Tbl
5362: (l_line_tbl(I).ato_line_id).date_attribute1;
5363: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5364: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5365: (l_line_tbl(I).link_to_line_id )
5366: AND oe_schedule_util.OE_sch_Attrb_Tbl
5367: (l_line_tbl(I).link_to_line_id).date_attribute1 is not null
5368: THEN

Line 5366: AND oe_schedule_util.OE_sch_Attrb_Tbl

5362: (l_line_tbl(I).ato_line_id).date_attribute1;
5363: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5364: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5365: (l_line_tbl(I).link_to_line_id )
5366: AND oe_schedule_util.OE_sch_Attrb_Tbl
5367: (l_line_tbl(I).link_to_line_id).date_attribute1 is not null
5368: THEN
5369: l_line_tbl(I).request_date :=
5370: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5370: oe_schedule_util.OE_sch_Attrb_Tbl

5366: AND oe_schedule_util.OE_sch_Attrb_Tbl
5367: (l_line_tbl(I).link_to_line_id).date_attribute1 is not null
5368: THEN
5369: l_line_tbl(I).request_date :=
5370: oe_schedule_util.OE_sch_Attrb_Tbl
5371: (l_line_tbl(I).link_to_line_id).date_attribute1;
5372:
5373: END IF;
5374: -- End 2787962

Line 5441: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN

5437: END LOOP;
5438: END IF; -- Ship Set
5439:
5440: IF l_entity_type =
5441: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET THEN
5442:
5443: l_set_rec := OE_ORDER_CACHE.Load_Set(l_set_id);
5444: l_set_name := l_set_rec.set_name;
5445:

Line 5480: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5476: END IF;
5477:
5478: -- Start 2787962
5479: IF l_line_tbl(I).top_model_line_id is not null
5480: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5481: (l_line_tbl(I).top_model_line_id )
5482: AND oe_schedule_util.OE_sch_Attrb_Tbl
5483: (l_line_tbl(I).top_model_line_id).date_attribute1 is not null
5484: THEN

Line 5482: AND oe_schedule_util.OE_sch_Attrb_Tbl

5478: -- Start 2787962
5479: IF l_line_tbl(I).top_model_line_id is not null
5480: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5481: (l_line_tbl(I).top_model_line_id )
5482: AND oe_schedule_util.OE_sch_Attrb_Tbl
5483: (l_line_tbl(I).top_model_line_id).date_attribute1 is not null
5484: THEN
5485: l_line_tbl(I).request_date :=
5486: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5486: oe_schedule_util.OE_sch_Attrb_Tbl

5482: AND oe_schedule_util.OE_sch_Attrb_Tbl
5483: (l_line_tbl(I).top_model_line_id).date_attribute1 is not null
5484: THEN
5485: l_line_tbl(I).request_date :=
5486: oe_schedule_util.OE_sch_Attrb_Tbl
5487: (l_line_tbl(I).top_model_line_id).date_attribute1;
5488: ELSIF l_line_tbl(I).ato_line_id is not null
5489: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5490: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

Line 5492: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5488: ELSIF l_line_tbl(I).ato_line_id is not null
5489: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5490: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5491: OE_GLOBALS.G_ITEM_OPTION))
5492: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5493: (l_line_tbl(I).ato_line_id )
5494: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5495: .date_attribute1 is not null
5496: THEN

Line 5494: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)

5490: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5491: OE_GLOBALS.G_ITEM_OPTION))
5492: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5493: (l_line_tbl(I).ato_line_id )
5494: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5495: .date_attribute1 is not null
5496: THEN
5497: l_line_tbl(I).request_date :=
5498: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5498: oe_schedule_util.OE_sch_Attrb_Tbl

5494: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5495: .date_attribute1 is not null
5496: THEN
5497: l_line_tbl(I).request_date :=
5498: oe_schedule_util.OE_sch_Attrb_Tbl
5499: (l_line_tbl(I).ato_line_id).date_attribute1;
5500: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5501: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5502: (l_line_tbl(I).link_to_line_id )

Line 5501: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5497: l_line_tbl(I).request_date :=
5498: oe_schedule_util.OE_sch_Attrb_Tbl
5499: (l_line_tbl(I).ato_line_id).date_attribute1;
5500: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5501: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5502: (l_line_tbl(I).link_to_line_id )
5503: AND oe_schedule_util.OE_sch_Attrb_Tbl
5504: (l_line_tbl(I).link_to_line_id).date_attribute1 is not null
5505: THEN

Line 5503: AND oe_schedule_util.OE_sch_Attrb_Tbl

5499: (l_line_tbl(I).ato_line_id).date_attribute1;
5500: ELSIF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
5501: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5502: (l_line_tbl(I).link_to_line_id )
5503: AND oe_schedule_util.OE_sch_Attrb_Tbl
5504: (l_line_tbl(I).link_to_line_id).date_attribute1 is not null
5505: THEN
5506: l_line_tbl(I).request_date :=
5507: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5507: oe_schedule_util.OE_sch_Attrb_Tbl

5503: AND oe_schedule_util.OE_sch_Attrb_Tbl
5504: (l_line_tbl(I).link_to_line_id).date_attribute1 is not null
5505: THEN
5506: l_line_tbl(I).request_date :=
5507: oe_schedule_util.OE_sch_Attrb_Tbl
5508: (l_line_tbl(I).link_to_line_id).date_attribute1;
5509:
5510: END IF;
5511: -- End 2787962

Line 5515: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5511: -- End 2787962
5512:
5513: -- Start 2391781
5514: IF NVL(l_line_tbl(I).Ship_model_complete_flag,'N') = 'Y'
5515: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5516: (l_line_tbl(I).top_model_line_id )
5517: AND oe_schedule_util.OE_sch_Attrb_Tbl
5518: (l_line_tbl(I).top_model_line_id).attribute1 is not null
5519: THEN

Line 5517: AND oe_schedule_util.OE_sch_Attrb_Tbl

5513: -- Start 2391781
5514: IF NVL(l_line_tbl(I).Ship_model_complete_flag,'N') = 'Y'
5515: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5516: (l_line_tbl(I).top_model_line_id )
5517: AND oe_schedule_util.OE_sch_Attrb_Tbl
5518: (l_line_tbl(I).top_model_line_id).attribute1 is not null
5519: THEN
5520: l_line_tbl(I).Ship_from_org_id :=
5521: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5521: oe_schedule_util.OE_sch_Attrb_Tbl

5517: AND oe_schedule_util.OE_sch_Attrb_Tbl
5518: (l_line_tbl(I).top_model_line_id).attribute1 is not null
5519: THEN
5520: l_line_tbl(I).Ship_from_org_id :=
5521: oe_schedule_util.OE_sch_Attrb_Tbl
5522: (l_line_tbl(I).top_model_line_id).attribute1;
5523: ELSIF l_line_tbl(I).ato_line_id is not null
5524: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5525: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

Line 5527: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS

5523: ELSIF l_line_tbl(I).ato_line_id is not null
5524: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5525: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5526: OE_GLOBALS.G_ITEM_OPTION))
5527: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5528: (l_line_tbl(I).ato_line_id )
5529: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5530: .attribute1 is not null
5531: THEN

Line 5529: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)

5525: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5526: OE_GLOBALS.G_ITEM_OPTION))
5527: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5528: (l_line_tbl(I).ato_line_id )
5529: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5530: .attribute1 is not null
5531: THEN
5532: l_line_tbl(I).Ship_from_org_id :=
5533: oe_schedule_util.OE_sch_Attrb_Tbl

Line 5533: oe_schedule_util.OE_sch_Attrb_Tbl

5529: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)
5530: .attribute1 is not null
5531: THEN
5532: l_line_tbl(I).Ship_from_org_id :=
5533: oe_schedule_util.OE_sch_Attrb_Tbl
5534: (l_line_tbl(I).ato_line_id).attribute1;
5535: END IF;
5536:
5537: -- 2391781

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

5592: END IF;
5593:
5594: -- Start 2391781
5595: --- Deleteing delayed request of type cascade_warehous
5596: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.FIRST;
5597: WHILE l_index is not null
5598: LOOP
5599: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5600: THEN

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

5595: --- Deleteing delayed request of type cascade_warehous
5596: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.FIRST;
5597: WHILE l_index is not null
5598: LOOP
5599: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5600: THEN
5601: oe_schedule_util.OE_sch_Attrb_Tbl.delete(l_index);
5602: END IF;
5603: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.NEXT(l_index);

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

5597: WHILE l_index is not null
5598: LOOP
5599: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5600: THEN
5601: oe_schedule_util.OE_sch_Attrb_Tbl.delete(l_index);
5602: END IF;
5603: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.NEXT(l_index);
5604: END LOOP;
5605:

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

5599: IF oe_schedule_util.OE_sch_Attrb_Tbl(l_index).set_id =l_set_id
5600: THEN
5601: oe_schedule_util.OE_sch_Attrb_Tbl.delete(l_index);
5602: END IF;
5603: l_index := oe_schedule_util.OE_sch_Attrb_Tbl.NEXT(l_index);
5604: END LOOP;
5605:
5606: -- End 2391781
5607:

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

5604: END LOOP;
5605:
5606: -- End 2391781
5607:
5608: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.count > 0 THEN
5609: FOR I IN 1..l_line_tbl.count LOOP
5610:
5611: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS
5612: (l_line_tbl(I).line_id) THEN

Line 5611: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS

5607:
5608: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.count > 0 THEN
5609: FOR I IN 1..l_line_tbl.count LOOP
5610:
5611: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS
5612: (l_line_tbl(I).line_id) THEN
5613:
5614: OE_SCHEDULE_UTIL.OE_Override_Tbl.delete
5615: (l_line_tbl(I).line_id);

Line 5614: OE_SCHEDULE_UTIL.OE_Override_Tbl.delete

5610:
5611: IF OE_SCHEDULE_UTIL.OE_Override_Tbl.EXISTS
5612: (l_line_tbl(I).line_id) THEN
5613:
5614: OE_SCHEDULE_UTIL.OE_Override_Tbl.delete
5615: (l_line_tbl(I).line_id);
5616:
5617: END IF;
5618:

Line 5685: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

5681: FOR I IN 1..l_line_tbl.count LOOP
5682: oe_debug_pub.add('2740480: Entity type : '|| l_entity_type);
5683: oe_debug_pub.add('2740480: line schedule ship date : '|| l_line_tbl(I).Schedule_ship_date);
5684: oe_debug_pub.add('2740480: set schedule ship date : '|| l_set_rec.Schedule_ship_date );
5685: IF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
5686: AND trunc(l_line_tbl(I).Schedule_ship_date) <> trunc(l_set_rec.Schedule_ship_date)
5687: THEN
5688: IF l_debug_level > 0 THEN
5689: oe_debug_pub.add('2740480: Not received correct values for ship set',1);

Line 5693: ELSIF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

5689: oe_debug_pub.add('2740480: Not received correct values for ship set',1);
5690: END IF;
5691: l_date_changed := 'Y' ;
5692: EXIT;
5693: ELSIF l_entity_type = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5694: AND trunc(l_line_tbl(I).Schedule_arrival_date) <> trunc(l_set_rec.Schedule_arrival_date)
5695: THEN
5696: IF l_debug_level > 0 THEN
5697: oe_debug_pub.add('2740480: Not received correct values for arrival set',1);

Line 5795: oe_schedule_util.Log_Delete_Set_Request

5791:
5792: -- 4026758
5793: IF l_line_tbl(I).ship_set_id IS NOT NULL
5794: OR l_line_tbl(I).arrival_set_id IS NOT NULL THEN
5795: oe_schedule_util.Log_Delete_Set_Request
5796: (p_header_id => l_line_tbl(I).header_id,
5797: p_line_id => l_line_tbl(I).line_id,
5798: p_set_id => nvl(l_line_tbl(I).ship_set_id,l_line_tbl(I).arrival_set_id),
5799: x_return_status => x_return_status);

Line 5904: OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET

5900: WHEN FND_API.G_EXC_ERROR THEN
5901: --3543774 If new set show the error message
5902: IF p_request_rec.request_type = OE_GLOBALS.G_GROUP_SCHEDULE
5903: AND ((l_entity_type =
5904: OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
5905: AND NOT OE_GLOBALS.equal(l_ship_set_id,l_old_ship_set_id))
5906: OR (l_entity_type =
5907: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5908: AND NOT OE_GLOBALS.equal(l_arrival_set_id,l_old_arrival_set_id)))

Line 5907: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET

5903: AND ((l_entity_type =
5904: OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
5905: AND NOT OE_GLOBALS.equal(l_ship_set_id,l_old_ship_set_id))
5906: OR (l_entity_type =
5907: OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
5908: AND NOT OE_GLOBALS.equal(l_arrival_set_id,l_old_arrival_set_id)))
5909: THEN
5910: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
5911: OE_MSG_PUB.Add;

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

6017: END IF;
6018: IF l_set_exists = 'N' THEN
6019: GOTO END_PROCESS;
6020: END IF;
6021: IF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_ARRIVAL_SET
6022: THEN
6023: Oe_Config_Schedule_Pvt.Query_Set_Lines
6024: (p_header_id => p_sch_set_tbl(I).param2,
6025: p_arrival_set_id => p_sch_set_tbl(I).entity_id,

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

6027: x_line_tbl => l_line_tbl,
6028: x_return_status => l_return_status);
6029:
6030:
6031: ELSIF p_sch_set_tbl(I).param1 = OE_SCHEDULE_UTIL.OESCH_ENTITY_SHIP_SET
6032: THEN
6033:
6034: Oe_Config_Schedule_Pvt.Query_Set_Lines
6035: (p_header_id => p_sch_set_tbl(I).param2,

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

6054: END IF;
6055:
6056: FOR J IN 1..l_line_tbl.count LOOP
6057:
6058: OE_SCHEDULE_UTIL.Validate_Line(p_line_rec => l_line_tbl(J),
6059: p_old_line_rec => l_line_tbl(J),
6060: p_sch_action => 'SCHEDULE' ,
6061: x_return_status => l_return_status);
6062:

Line 6178: oe_schedule_util.Log_Delete_Set_Request

6174: END IF;
6175: -- 4026758
6176: IF l_sch_line_tbl(I).ship_set_id IS NOT NULL
6177: OR l_sch_line_tbl(I).arrival_set_id IS NOT NULL THEN
6178: oe_schedule_util.Log_Delete_Set_Request
6179: (p_header_id => l_sch_line_tbl(I).header_id,
6180: p_line_id => l_sch_line_tbl(I).line_id,
6181: p_set_id => nvl(l_sch_line_tbl(I).ship_set_id,l_sch_line_tbl(I).arrival_set_id),
6182: x_return_status => x_return_status);

Line 6205: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE

6201: Oe_Config_Schedule_Pvt.Process_Group
6202: (p_x_line_tbl => l_sch_line_tbl
6203: ,p_old_line_tbl => l_old_line_tbl
6204: ,p_caller => 'SET'
6205: ,p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
6206: ,p_partial => TRUE
6207: ,x_return_status => x_return_status);
6208:
6209: IF l_debug_level > 0 THEN

Line 6301: oe_schedule_util.Log_Delete_Set_Request

6297: -- Begin 4026758
6298: IF l_sch_line_tbl(I).ship_set_id IS NOT NULL
6299: OR l_sch_line_tbl(I).arrival_set_id IS NOT NULL THEN
6300:
6301: oe_schedule_util.Log_Delete_Set_Request
6302: (p_header_id => l_sch_line_tbl(I).header_id,
6303: p_line_id => l_sch_line_tbl(I).line_id,
6304: p_set_id => nvl(l_sch_line_tbl(I).ship_set_id,l_sch_line_tbl(I).arrival_set_id),
6305: x_return_status => l_return_status);