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_SCHEDULE_GRP dependencies on OE_DEBUG_PUB

Line 40: oe_debug_pub.add('Entering oe_schedule_grp.update_scheduling_results' || p_x_sch_tbl.count ,1);

36: l_orig_resp_appl_id NUMBER;
37: J NUMBER;
38: BEGIN
39:
40: oe_debug_pub.add('Entering oe_schedule_grp.update_scheduling_results' || p_x_sch_tbl.count ,1);
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
44: l_count := p_x_sch_tbl.count;

Line 51: oe_debug_pub.add('Set the Org ',1);

47:
48: IF l_old_org_id <> p_x_sch_tbl(I).org_id THEN
49: l_old_org_id := p_x_sch_tbl(I).org_id;
50:
51: oe_debug_pub.add('Set the Org ',1);
52: -- dbms_application_info.set_client_info(p_x_sch_tbl(I).org_id);
53:
54: OE_Order_Context_Grp.Set_Created_By_Context
55: (p_header_id => p_x_sch_tbl(I).header_id

Line 92: oe_debug_pub.add('J : ' || J);

88: J := g_sch_tbl.FIRST;
89: WHILE J IS NOT NULL
90: LOOP
91:
92: oe_debug_pub.add('J : ' || J);
93: oe_debug_pub.add('J Return Status :' || g_sch_tbl(J).x_return_status,1);
94: p_x_sch_tbl(J).x_return_status
95: := g_sch_tbl(J).x_return_status;
96: IF g_sch_tbl(J).x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 93: oe_debug_pub.add('J Return Status :' || g_sch_tbl(J).x_return_status,1);

89: WHILE J IS NOT NULL
90: LOOP
91:
92: oe_debug_pub.add('J : ' || J);
93: oe_debug_pub.add('J Return Status :' || g_sch_tbl(J).x_return_status,1);
94: p_x_sch_tbl(J).x_return_status
95: := g_sch_tbl(J).x_return_status;
96: IF g_sch_tbl(J).x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97:

Line 98: oe_debug_pub.add('Setting the status to W to indicate partial processing',1);

94: p_x_sch_tbl(J).x_return_status
95: := g_sch_tbl(J).x_return_status;
96: IF g_sch_tbl(J).x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97:
98: oe_debug_pub.add('Setting the status to W to indicate partial processing',1);
99: x_return_status := 'W';
100:
101: END IF;
102:

Line 105: oe_debug_pub.add('J+ Return Status :' || p_x_sch_tbl(J).x_return_status,1);

101: END IF;
102:
103: p_x_sch_tbl(J).x_override_atp_date_code :=
104: g_sch_tbl(I).x_override_atp_date_code;
105: oe_debug_pub.add('J+ Return Status :' || p_x_sch_tbl(J).x_return_status,1);
106: oe_debug_pub.add('J+ line_id :' || p_x_sch_tbl(J).line_id,1);
107: J := g_sch_tbl.next(J);
108: END LOOP;
109:

Line 106: oe_debug_pub.add('J+ line_id :' || p_x_sch_tbl(J).line_id,1);

102:
103: p_x_sch_tbl(J).x_override_atp_date_code :=
104: g_sch_tbl(I).x_override_atp_date_code;
105: oe_debug_pub.add('J+ Return Status :' || p_x_sch_tbl(J).x_return_status,1);
106: oe_debug_pub.add('J+ line_id :' || p_x_sch_tbl(J).line_id,1);
107: J := g_sch_tbl.next(J);
108: END LOOP;
109:
110: g_sch_tbl.delete;

Line 120: oe_debug_pub.add('Exiting oe_schedule_grp.update_scheduling_results' ||

116: END IF; -- Code release.
117:
118: oe_msg_pub.save_messages(p_request_id => p_request_id);
119:
120: oe_debug_pub.add('Exiting oe_schedule_grp.update_scheduling_results' ||
121: x_return_status,1);
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN

Line 162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

158: l_opm_enabled BOOLEAN; -- Added for ER 6110708
159: l_sales_order_id Number;
160: I Number;
161: l_index Number;
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: BEGIN
164:
165: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
166: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 165: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);

161: l_index Number;
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: BEGIN
164:
165: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- This variable is to track that the Item is being Substituted by Planning Loop Back and not being changed manully by user.
169: -- Initializing to 'N' for current set of Lines. Will set it to Y if any item substitutions are happening.

Line 316: oe_debug_pub.add('E4',2);

312: IF l_line_rec.ato_line_id is not null
313: AND l_line_rec.ato_line_id <> l_line_rec.line_id
314: AND NOT l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
315:
316: oe_debug_pub.add('E4',2);
317: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
318: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
319: OE_MSG_PUB.ADD;
320: END IF;

Line 326: oe_debug_pub.add('Doing validations for Item Substitutions for Line Id : ' || g_sch_tbl(I).line_id, 5);

322: /* Added for ER 6110708 to support Item Substitutions from Planning Loop Back */
323: IF g_sch_tbl(I).inventory_item_id IS NOT NULL
324: AND g_sch_tbl(I).inventory_item_id <> g_sch_tbl(I).orig_inventory_item_id THEN
325:
326: oe_debug_pub.add('Doing validations for Item Substitutions for Line Id : ' || g_sch_tbl(I).line_id, 5);
327: oe_debug_pub.add(' Original Item on Line : ' || g_sch_tbl(I).orig_inventory_item_id, 5);
328: oe_debug_pub.add(' Substitute Item : ' || g_sch_tbl(I).inventory_item_id, 5);
329: oe_debug_pub.add(' Current Item on Line : ' || l_line_rec.inventory_item_id, 5);
330:

Line 327: oe_debug_pub.add(' Original Item on Line : ' || g_sch_tbl(I).orig_inventory_item_id, 5);

323: IF g_sch_tbl(I).inventory_item_id IS NOT NULL
324: AND g_sch_tbl(I).inventory_item_id <> g_sch_tbl(I).orig_inventory_item_id THEN
325:
326: oe_debug_pub.add('Doing validations for Item Substitutions for Line Id : ' || g_sch_tbl(I).line_id, 5);
327: oe_debug_pub.add(' Original Item on Line : ' || g_sch_tbl(I).orig_inventory_item_id, 5);
328: oe_debug_pub.add(' Substitute Item : ' || g_sch_tbl(I).inventory_item_id, 5);
329: oe_debug_pub.add(' Current Item on Line : ' || l_line_rec.inventory_item_id, 5);
330:
331: -- If Item on the Sales Order Line has changed after running the plan and

Line 328: oe_debug_pub.add(' Substitute Item : ' || g_sch_tbl(I).inventory_item_id, 5);

324: AND g_sch_tbl(I).inventory_item_id <> g_sch_tbl(I).orig_inventory_item_id THEN
325:
326: oe_debug_pub.add('Doing validations for Item Substitutions for Line Id : ' || g_sch_tbl(I).line_id, 5);
327: oe_debug_pub.add(' Original Item on Line : ' || g_sch_tbl(I).orig_inventory_item_id, 5);
328: oe_debug_pub.add(' Substitute Item : ' || g_sch_tbl(I).inventory_item_id, 5);
329: oe_debug_pub.add(' Current Item on Line : ' || l_line_rec.inventory_item_id, 5);
330:
331: -- If Item on the Sales Order Line has changed after running the plan and
332: -- before Planning releases the recommendations, then we should not accept the Item

Line 329: oe_debug_pub.add(' Current Item on Line : ' || l_line_rec.inventory_item_id, 5);

325:
326: oe_debug_pub.add('Doing validations for Item Substitutions for Line Id : ' || g_sch_tbl(I).line_id, 5);
327: oe_debug_pub.add(' Original Item on Line : ' || g_sch_tbl(I).orig_inventory_item_id, 5);
328: oe_debug_pub.add(' Substitute Item : ' || g_sch_tbl(I).inventory_item_id, 5);
329: oe_debug_pub.add(' Current Item on Line : ' || l_line_rec.inventory_item_id, 5);
330:
331: -- If Item on the Sales Order Line has changed after running the plan and
332: -- before Planning releases the recommendations, then we should not accept the Item
333: -- Substitution. This means that planning has recommended item substitution based on old data.

Line 353: oe_debug_pub.add(' Item Type : ' || l_line_rec.item_type_code, 5);

349: );
350:
351:
352: -- Do not allow Item Substitutions in below cases.
353: oe_debug_pub.add(' Item Type : ' || l_line_rec.item_type_code, 5);
354: oe_debug_pub.add(' Line Set Id : ' || l_line_rec.line_set_id, 5);
355: oe_debug_pub.add(' Split From Line Id : ' || l_line_rec.split_from_line_id, 5);
356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);
357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);

Line 354: oe_debug_pub.add(' Line Set Id : ' || l_line_rec.line_set_id, 5);

350:
351:
352: -- Do not allow Item Substitutions in below cases.
353: oe_debug_pub.add(' Item Type : ' || l_line_rec.item_type_code, 5);
354: oe_debug_pub.add(' Line Set Id : ' || l_line_rec.line_set_id, 5);
355: oe_debug_pub.add(' Split From Line Id : ' || l_line_rec.split_from_line_id, 5);
356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);
357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);
358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);

Line 355: oe_debug_pub.add(' Split From Line Id : ' || l_line_rec.split_from_line_id, 5);

351:
352: -- Do not allow Item Substitutions in below cases.
353: oe_debug_pub.add(' Item Type : ' || l_line_rec.item_type_code, 5);
354: oe_debug_pub.add(' Line Set Id : ' || l_line_rec.line_set_id, 5);
355: oe_debug_pub.add(' Split From Line Id : ' || l_line_rec.split_from_line_id, 5);
356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);
357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);
358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);
359: IF l_opm_enabled THEN

Line 356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);

352: -- Do not allow Item Substitutions in below cases.
353: oe_debug_pub.add(' Item Type : ' || l_line_rec.item_type_code, 5);
354: oe_debug_pub.add(' Line Set Id : ' || l_line_rec.line_set_id, 5);
355: oe_debug_pub.add(' Split From Line Id : ' || l_line_rec.split_from_line_id, 5);
356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);
357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);
358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);
359: IF l_opm_enabled THEN
360: oe_debug_pub.add(' OPM Enabled Org : Yes', 5);

Line 357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);

353: oe_debug_pub.add(' Item Type : ' || l_line_rec.item_type_code, 5);
354: oe_debug_pub.add(' Line Set Id : ' || l_line_rec.line_set_id, 5);
355: oe_debug_pub.add(' Split From Line Id : ' || l_line_rec.split_from_line_id, 5);
356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);
357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);
358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);
359: IF l_opm_enabled THEN
360: oe_debug_pub.add(' OPM Enabled Org : Yes', 5);
361: ELSE

Line 358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);

354: oe_debug_pub.add(' Line Set Id : ' || l_line_rec.line_set_id, 5);
355: oe_debug_pub.add(' Split From Line Id : ' || l_line_rec.split_from_line_id, 5);
356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);
357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);
358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);
359: IF l_opm_enabled THEN
360: oe_debug_pub.add(' OPM Enabled Org : Yes', 5);
361: ELSE
362: oe_debug_pub.add(' OPM Enabled Org : No', 5);

Line 360: oe_debug_pub.add(' OPM Enabled Org : Yes', 5);

356: oe_debug_pub.add(' Source Document Type Id : ' || nvl(l_line_rec.source_document_type_id, -99), 5);
357: oe_debug_pub.add(' Source Type : ' || l_line_rec.source_type_code, 5);
358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);
359: IF l_opm_enabled THEN
360: oe_debug_pub.add(' OPM Enabled Org : Yes', 5);
361: ELSE
362: oe_debug_pub.add(' OPM Enabled Org : No', 5);
363: END IF;
364: oe_debug_pub.add(' Reserved Qty : ' || nvl(l_line_rec.reserved_quantity, 0), 5);

Line 362: oe_debug_pub.add(' OPM Enabled Org : No', 5);

358: oe_debug_pub.add(' Booked Flag : ' || nvl(l_line_rec.booked_flag, 'N'), 5);
359: IF l_opm_enabled THEN
360: oe_debug_pub.add(' OPM Enabled Org : Yes', 5);
361: ELSE
362: oe_debug_pub.add(' OPM Enabled Org : No', 5);
363: END IF;
364: oe_debug_pub.add(' Reserved Qty : ' || nvl(l_line_rec.reserved_quantity, 0), 5);
365:
366: IF ( l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD OR -- Not a Standard Item

Line 364: oe_debug_pub.add(' Reserved Qty : ' || nvl(l_line_rec.reserved_quantity, 0), 5);

360: oe_debug_pub.add(' OPM Enabled Org : Yes', 5);
361: ELSE
362: oe_debug_pub.add(' OPM Enabled Org : No', 5);
363: END IF;
364: oe_debug_pub.add(' Reserved Qty : ' || nvl(l_line_rec.reserved_quantity, 0), 5);
365:
366: IF ( l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD OR -- Not a Standard Item
367: l_line_rec.line_set_id IS NOT NULL OR -- Line is Split
368: l_line_rec.split_from_line_id IS NOT NULL OR -- Split Line

Line 398: oe_debug_pub.add('Finished with validations for Item Substitutions', 5);

394: END IF;
395: END;
396: END IF;
397:
398: oe_debug_pub.add('Finished with validations for Item Substitutions', 5);
399:
400: END IF;
401: /* End of ER 6110708 */
402:

Line 405: oe_debug_pub.add('After Special Validation ',2);

401: /* End of ER 6110708 */
402:
403: -- Special Validation.
404:
405: oe_debug_pub.add('After Special Validation ',2);
406: IF g_sch_tbl(I).x_return_status = FND_API.G_RET_STS_SUCCESS THEN
407:
408: IF nvl(l_line_rec.override_atp_date_code,'N') = 'Y' THEN
409: g_sch_tbl(I).x_override_atp_date_code := 'Y';

Line 418: oe_debug_pub.add('ATO Model',2);

414: OE_GLOBALS.G_ITEM_CLASS))
415: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
416:
417: THEN
418: oe_debug_pub.add('ATO Model',2);
419:
420: OE_Config_Util.Query_ATO_Options
421: (p_ato_line_id => l_line_rec.ato_line_id,
422: x_line_tbl => l_local_line_tbl);

Line 444: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');

440: IF g_sch_tbl(I).schedule_ship_date is NOT NULL THEN
441: /*
442: IF trunc(g_sch_tbl(I).schedule_ship_date) < trunc(l_local_line_tbl(J).request_date) THEN
443:
444: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
445: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
446: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
447: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
448: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

Line 461: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');

457: IF g_sch_tbl(I).schedule_arrival_date IS NOT NULL THEN
458:
459: /* IF trunc(g_sch_tbl(I).schedule_arrival_date) < trunc(l_local_line_tbl(J).request_date) THEN
460:
461: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
462: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
463: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
464: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

Line 488: oe_debug_pub.add('Local shipping Method ' || l_local_line_tbl(J).Shipping_Method_Code,2);

484: AND nvl(l_local_line_tbl(J).Shipping_Method_Code,'-X') <> g_sch_tbl(I).Shipping_Method_Code THEN
485: l_ship_method_is_changed := TRUE;
486: l_local_line_tbl(J).Shipping_Method_Code := g_sch_tbl(I).Shipping_Method_Code;
487: END IF;
488: oe_debug_pub.add('Local shipping Method ' || l_local_line_tbl(J).Shipping_Method_Code,2);
489:
490: IF nvl(g_sch_tbl(I).Firm_Demand_Flag,'N') = 'Y'
491: AND nvl(l_local_line_tbl(J).Firm_demand_Flag,'N') = 'N' THEN
492: l_local_line_tbl(J).Firm_Demand_Flag := 'Y';

Line 507: oe_debug_pub.add('Before assigning' || l_local_line_tbl(J).line_id,2);

503: l_ord_qty_is_changed := TRUE;
504: l_local_line_tbl(J).Ordered_Quantity := g_sch_tbl(I).Ordered_Quantity;
505: END IF;
506:
507: oe_debug_pub.add('Before assigning' || l_local_line_tbl(J).line_id,2);
508: g_line_tbl(l_count) := l_local_line_tbl(J);
509: g_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;
510: g_line_tbl(l_count).return_status := Null;
511: l_count := l_count + 1;

Line 558: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');

554:
555: IF g_sch_tbl(I).schedule_ship_date is NOT NULL THEN
556: /* IF trunc(g_sch_tbl(I).schedule_ship_date) < trunc(l_line_rec.request_date) THEN
557:
558: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
559: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
560: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
561: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

Line 571: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');

567: END IF;
568: IF g_sch_tbl(I).schedule_arrival_date is NOT NULL THEN
569: /* IF trunc(g_sch_tbl(I).schedule_arrival_date) < trunc(l_line_rec.request_date) THEN
570:
571: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
572: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
573: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
574: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
575: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

Line 597: oe_debug_pub.add('Shipping Method on line rec ' || l_line_rec.Shipping_Method_Code,2);

593: AND g_sch_tbl(I).Shipping_Method_Code <> nvl(l_line_rec.Shipping_Method_Code,'-X') THEN
594: l_ship_method_is_changed := TRUE;
595: l_line_rec.Shipping_Method_Code := g_sch_tbl(I).Shipping_Method_Code;
596: END IF;
597: oe_debug_pub.add('Shipping Method on line rec ' || l_line_rec.Shipping_Method_Code,2);
598:
599: IF nvl(g_sch_tbl(I).Firm_Demand_Flag,'N') = 'Y'
600: AND nvl(l_line_rec.Firm_demand_Flag,'N') = 'N' THEN
601: l_line_rec.Firm_Demand_Flag := 'Y';

Line 638: oe_debug_pub.add('Operation ' || g_line_tbl(J).operation ,2);

634:
635:
636: FOR J IN 1..g_line_tbl.count LOOP
637:
638: oe_debug_pub.add('Operation ' || g_line_tbl(J).operation ,2);
639:
640: IF g_line_tbl(J).return_status <> FND_API.G_RET_STS_SUCCESS THEN
641:
642: oe_debug_pub.add('None ' || g_line_tbl(J).return_status,2);

Line 642: oe_debug_pub.add('None ' || g_line_tbl(J).return_status,2);

638: oe_debug_pub.add('Operation ' || g_line_tbl(J).operation ,2);
639:
640: IF g_line_tbl(J).return_status <> FND_API.G_RET_STS_SUCCESS THEN
641:
642: oe_debug_pub.add('None ' || g_line_tbl(J).return_status,2);
643: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
644:
645: ELSE
646:

Line 684: oe_debug_pub.add('Operation1 ' || g_line_tbl(J).operation ,2);

680:
681: END IF;
682:
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add('Operation1 ' || g_line_tbl(J).operation ,2);
685: oe_debug_pub.add('Line_id ' || g_line_tbl(J).line_id,2);
686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);
687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);

Line 685: oe_debug_pub.add('Line_id ' || g_line_tbl(J).line_id,2);

681: END IF;
682:
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add('Operation1 ' || g_line_tbl(J).operation ,2);
685: oe_debug_pub.add('Line_id ' || g_line_tbl(J).line_id,2);
686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);
687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);
689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);

Line 686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);

682:
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add('Operation1 ' || g_line_tbl(J).operation ,2);
685: oe_debug_pub.add('Line_id ' || g_line_tbl(J).line_id,2);
686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);
687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);
689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);
690: Oe_debug_pub.add('Shipping Method ' || g_line_tbl(J).shipping_method_code,2);

Line 687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);

683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add('Operation1 ' || g_line_tbl(J).operation ,2);
685: oe_debug_pub.add('Line_id ' || g_line_tbl(J).line_id,2);
686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);
687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);
689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);
690: Oe_debug_pub.add('Shipping Method ' || g_line_tbl(J).shipping_method_code,2);
691: oe_debug_pub.add('Ordered Quantity ' || g_line_tbl(J).Ordered_Quantity,2);

Line 688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);

684: oe_debug_pub.add('Operation1 ' || g_line_tbl(J).operation ,2);
685: oe_debug_pub.add('Line_id ' || g_line_tbl(J).line_id,2);
686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);
687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);
689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);
690: Oe_debug_pub.add('Shipping Method ' || g_line_tbl(J).shipping_method_code,2);
691: oe_debug_pub.add('Ordered Quantity ' || g_line_tbl(J).Ordered_Quantity,2);
692: END IF;

Line 689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);

685: oe_debug_pub.add('Line_id ' || g_line_tbl(J).line_id,2);
686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);
687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);
689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);
690: Oe_debug_pub.add('Shipping Method ' || g_line_tbl(J).shipping_method_code,2);
691: oe_debug_pub.add('Ordered Quantity ' || g_line_tbl(J).Ordered_Quantity,2);
692: END IF;
693:

Line 690: Oe_debug_pub.add('Shipping Method ' || g_line_tbl(J).shipping_method_code,2);

686: oe_debug_pub.add('Schedule_ship_date ' || g_line_tbl(J).Schedule_ship_date,2);
687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);
689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);
690: Oe_debug_pub.add('Shipping Method ' || g_line_tbl(J).shipping_method_code,2);
691: oe_debug_pub.add('Ordered Quantity ' || g_line_tbl(J).Ordered_Quantity,2);
692: END IF;
693:
694: END LOOP;

Line 691: oe_debug_pub.add('Ordered Quantity ' || g_line_tbl(J).Ordered_Quantity,2);

687: oe_debug_pub.add('Schedule_arrival_date ' || g_line_tbl(J).Schedule_arrival_date,2);
688: oe_debug_pub.add('Schedule_status_code ' || g_line_tbl(J).Schedule_status_code,2);
689: oe_debug_pub.add('Ship_from_org ' || g_line_tbl(J).Ship_from_org_id,2);
690: Oe_debug_pub.add('Shipping Method ' || g_line_tbl(J).shipping_method_code,2);
691: oe_debug_pub.add('Ordered Quantity ' || g_line_tbl(J).Ordered_Quantity,2);
692: END IF;
693:
694: END LOOP;
695:

Line 708: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to TRUE',5);

704: -- changes are from Planning user
705: --
706: OE_Schedule_GRP.G_ISO_Planning_Update := TRUE;
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to TRUE',5);
709: END IF;
710: --
711:
712: IF l_ship_from_is_changed

Line 736: oe_debug_pub.add('OP ' || g_line_tbl(J).operation ,2);

732: l_control_rec.clear_api_requests := FALSE;
733:
734: FOR J IN 1..g_line_tbl.count LOOP
735:
736: oe_debug_pub.add('OP ' || g_line_tbl(J).operation ,2);
737: oe_debug_pub.add('OP ' || g_line_tbl(J).line_id ,2);
738: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).operation ,2);
739: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).line_id ,2);
740:

Line 737: oe_debug_pub.add('OP ' || g_line_tbl(J).line_id ,2);

733:
734: FOR J IN 1..g_line_tbl.count LOOP
735:
736: oe_debug_pub.add('OP ' || g_line_tbl(J).operation ,2);
737: oe_debug_pub.add('OP ' || g_line_tbl(J).line_id ,2);
738: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).operation ,2);
739: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).line_id ,2);
740:
741: END LOOP;

Line 738: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).operation ,2);

734: FOR J IN 1..g_line_tbl.count LOOP
735:
736: oe_debug_pub.add('OP ' || g_line_tbl(J).operation ,2);
737: oe_debug_pub.add('OP ' || g_line_tbl(J).line_id ,2);
738: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).operation ,2);
739: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).line_id ,2);
740:
741: END LOOP;
742:

Line 739: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).line_id ,2);

735:
736: oe_debug_pub.add('OP ' || g_line_tbl(J).operation ,2);
737: oe_debug_pub.add('OP ' || g_line_tbl(J).line_id ,2);
738: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).operation ,2);
739: oe_debug_pub.add('Ol OP ' || g_old_line_tbl(J).line_id ,2);
740:
741: END LOOP;
742:
743: OE_Schedule_Util.Call_Process_Order

Line 799: oe_debug_pub.add('Before clearing all requests',2);

795: l_index := find_index(g_line_tbl(I).line_id);
796: g_sch_tbl(l_index).x_return_status := x_return_status;
797: END LOOP;
798:
799: oe_debug_pub.add('Before clearing all requests',2);
800:
801: oe_delayed_requests_pvt.Clear_Request(x_return_status=> l_return_status);
802: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
803: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN

Line 815: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to FALSE',5);

811: -- Ressting the global to FALSE
812: --
813: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to FALSE',5);
816: END IF;
817: --
818:
819:

Line 843: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);

839:
840: g_line_tbl.delete;
841: g_old_line_tbl.delete;
842:
843: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846:
847: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

Line 901: oe_debug_pub.add('ONT_SCH_LOOP_DATE_NULL',1);

897: ,p_entity_id => g_sch_tbl(I).line_id
898: ,p_header_id => g_sch_tbl(I).header_id
899: ,p_line_id => g_sch_tbl(I).line_id);
900:
901: oe_debug_pub.add('ONT_SCH_LOOP_DATE_NULL',1);
902: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_DATE_NULL');
904: OE_MSG_PUB.ADD;
905:

Line 940: oe_debug_pub.add('Entering Validate_Lines',1);

936: l_index NUMBER;
937:
938: BEGIN
939:
940: oe_debug_pub.add('Entering Validate_Lines',1);
941:
942: FOR I IN 1..G_LINE_TBL.COUNT LOOP
943:
944: oe_debug_pub.add('Validate_Lines' || g_line_tbl(I).line_id,1);

Line 944: oe_debug_pub.add('Validate_Lines' || g_line_tbl(I).line_id,1);

940: oe_debug_pub.add('Entering Validate_Lines',1);
941:
942: FOR I IN 1..G_LINE_TBL.COUNT LOOP
943:
944: oe_debug_pub.add('Validate_Lines' || g_line_tbl(I).line_id,1);
945:
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947: OE_MSG_PUB.set_msg_context
948: ( p_entity_code => 'LINE'

Line 971: oe_debug_pub.add('E1',2);

967:
968: /*
969: IF g_line_tbl(I).schedule_status_code is null THEN
970:
971: oe_debug_pub.add('E1',2);
972: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
973: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_CANT_UPDATE');
974: OE_MSG_PUB.ADD;
975: x_return_status := FND_API.G_RET_STS_ERROR;

Line 980: oe_debug_pub.add('E1-1',2);

976: END IF;
977: */
978: IF g_line_tbl(I).cancelled_flag = 'Y' THEN
979:
980: oe_debug_pub.add('E1-1',2);
981: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
982: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_FULLY_CANCELLED');
983: OE_MSG_PUB.ADD;
984: x_return_status := FND_API.G_RET_STS_ERROR;

Line 989: oe_debug_pub.add('E1-2',2);

985: END IF;
986:
987: IF g_line_tbl(I).shipped_quantity is not null THEN
988:
989: oe_debug_pub.add('E1-2',2);
990: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
991: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_SHIPPED');
992: OE_MSG_PUB.ADD;
993: x_return_status := FND_API.G_RET_STS_ERROR;

Line 996: oe_debug_pub.add('Firm_demand_flag :' || g_line_tbl(I).firm_demand_flag,1);

992: OE_MSG_PUB.ADD;
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: END IF;
995:
996: oe_debug_pub.add('Firm_demand_flag :' || g_line_tbl(I).firm_demand_flag,1);
997:
998: -- Commenting this code as ASCP is doing this already.
999: /* IF NVL(g_old_line_tbl(I).firm_demand_flag,'N') = 'Y'
1000: AND not oe_globals.equal(g_line_tbl(I).ship_from_org_id,

Line 1003: oe_debug_pub.add('E2',2);

999: /* IF NVL(g_old_line_tbl(I).firm_demand_flag,'N') = 'Y'
1000: AND not oe_globals.equal(g_line_tbl(I).ship_from_org_id,
1001: g_old_line_tbl(I).ship_from_org_id) THEN
1002:
1003: oe_debug_pub.add('E2',2);
1004: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1005: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_FRMD');
1006: OE_MSG_PUB.ADD;
1007: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1012: oe_debug_pub.add('E3',2);

1008: END IF; */
1009:
1010: IF g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
1011:
1012: oe_debug_pub.add('E3',2);
1013: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1014: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_SRV');
1015: OE_MSG_PUB.ADD;
1016: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1023: oe_debug_pub.add('E4',2);

1019: IF g_line_tbl(I).ato_line_id IS NOT NULL THEN
1020: /* IF NOT (g_line_tbl(I).ato_line_id = g_line_tbl(I).line_id OR
1021: g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN
1022:
1023: oe_debug_pub.add('E4',2);
1024: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1025: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1026: OE_MSG_PUB.ADD;
1027: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1031: oe_debug_pub.add('E5',2);

1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029: */
1030: IF nvl(g_line_tbl(I).model_remnant_flag,'N') = 'Y' THEN
1031: oe_debug_pub.add('E5',2);
1032: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1033: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1034: OE_MSG_PUB.ADD;
1035: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1042: oe_debug_pub.add('E6',2);

1038: END IF;
1039:
1040: IF g_line_tbl(I).line_category_code = 'RETURN' THEN
1041:
1042: oe_debug_pub.add('E6',2);
1043: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1044: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_RET');
1045: OE_MSG_PUB.ADD;
1046: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1051: oe_debug_pub.add('E7',2);

1047: END IF;
1048:
1049: IF OE_OTA_UTIL.Is_OTA_Line(g_line_tbl(I).order_quantity_uom) THEN
1050:
1051: oe_debug_pub.add('E7',2);
1052: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1053: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1054: OE_MSG_PUB.ADD;
1055: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1060: oe_debug_pub.add('E8',2);

1056: END IF;
1057:
1058: IF g_line_tbl(I).source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN
1059:
1060: oe_debug_pub.add('E8',2);
1061: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1062: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_EXT');
1063: OE_MSG_PUB.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1075: oe_debug_pub.add('E9',2);

1071: IF l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR OR
1072: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE OR
1073: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN
1074:
1075: oe_debug_pub.add('E9',2);
1076: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1077: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_LVL');
1078: OE_MSG_PUB.ADD;
1079: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1102: oe_debug_pub.add('E10',2);

1098: IF NVL(g_line_tbl(I).re_source_flag,'Y') = 'N' AND
1099: g_line_tbl(I).ship_from_org_id <>
1100: NVL(g_sch_tbl(I).ship_from_org_id,g_line_tbl(I).ship_from_org_id)
1101: THEN
1102: oe_debug_pub.add('E10',2);
1103: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1104: FND_MESSAGE.SET_NAMe('ONT', 'OE_SCH_LOOP_WSH_UPD');
1105: OE_MSG_PUB.ADD;
1106: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1136: oe_debug_pub.add('E11',2);

1132: END IF;
1133: END IF;
1134:
1135: IF (l_result = FND_API.G_TRUE) THEN
1136: oe_debug_pub.add('E11',2);
1137: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1138: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
1139: OE_MSG_PUB.Add;
1140: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1153: oe_debug_pub.add('Existing Validate_Lines',1);

1149: g_sch_tbl(l_index).x_return_status := x_return_status;
1150: END IF;
1151: END LOOP;
1152:
1153: oe_debug_pub.add('Existing Validate_Lines',1);
1154:
1155: EXCEPTION
1156: WHEN FND_API.G_EXC_ERROR THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1199: Oe_debug_pub.add('Entering Procedure Validate_set'|| p_ship_set_id,1);

1195: l_index Number;
1196:
1197: BEGIN
1198:
1199: Oe_debug_pub.add('Entering Procedure Validate_set'|| p_ship_set_id,1);
1200: IF p_Ship_set_id is not null THEN
1201:
1202: FOR C1 IN line_ship_set LOOP
1203: IF NOT Find_line(C1.line_id) THEN

Line 1243: oe_debug_pub.add('E10',2);

1239: END IF;
1240:
1241: IF NOT l_result THEN
1242:
1243: oe_debug_pub.add('E10',2);
1244: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1245: OE_MSG_PUB.ADD;
1246: IF p_ship_set_id IS NOT NULL THEN
1247:

Line 1309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1305: FUNCTION Find_line(p_line_id IN NUMBER)
1306: Return BOOLEAN
1307: IS
1308: --
1309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1310: --
1311: BEGIN
1312:
1313: IF l_debug_level > 0 THEN

Line 1314: oe_debug_pub.add( 'ENTERING FIND_LINE: ' || P_LINE_ID , 1 ) ;

1310: --
1311: BEGIN
1312:
1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add( 'ENTERING FIND_LINE: ' || P_LINE_ID , 1 ) ;
1315: END IF;
1316:
1317: FOR J IN 1..g_line_tbl.count LOOP
1318:

Line 1322: oe_debug_pub.add( ' LINE EXISTS IN THE TABLE' , 1 ) ;

1318:
1319: IF p_line_id = g_line_tbl(J).line_id THEN
1320:
1321: IF l_debug_level > 0 THEN
1322: oe_debug_pub.add( ' LINE EXISTS IN THE TABLE' , 1 ) ;
1323: END IF;
1324: RETURN TRUE;
1325: END IF;
1326: END LOOP;

Line 1355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1351: FUNCTION Find_index(p_line_id IN NUMBER)
1352: Return NUMBER
1353: IS
1354: --
1355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1356: J NUMBER;
1357: --
1358: BEGIN
1359:

Line 1361: oe_debug_pub.add( 'ENTERING FIND_Index: ' || P_LINE_ID , 1 ) ;

1357: --
1358: BEGIN
1359:
1360: IF l_debug_level > 0 THEN
1361: oe_debug_pub.add( 'ENTERING FIND_Index: ' || P_LINE_ID , 1 ) ;
1362: END IF;
1363:
1364: J := g_sch_tbl.FIRST;
1365: WHILE J IS NOT NULL

Line 1371: oe_debug_pub.add( ' J : ' || J, 1 ) ;

1367:
1368: IF p_line_id = g_sch_tbl(J).line_id THEN
1369:
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( ' J : ' || J, 1 ) ;
1372: END IF;
1373: RETURN J;
1374: END IF;
1375: J := g_sch_tbl.NEXT(J);