eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CONFIG_SCHEDULE_PVT dependencies on OE_DEBUG_PUB

Line 95: oe_debug_pub.add('Entering Procedure Check_for_Request in Package OE_Delayed_

91: IS
92: K NUMBER;
93: BEGIN
94:
95: oe_debug_pub.add('Entering Procedure Check_for_Request in Package OE_Delayed_
96: Requests_Pvt');
97:
98:
99: K := OE_Delayed_Requests_PVT.G_Delayed_Requests.FIRST;

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

234: l_model_ship_date DATE;
235: l_model_arrival_date DATE;
236: l_model_request_date DATE;
237: --
238: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
239: --
240: BEGIN
241:
242: IF l_debug_level > 0 THEN

Line 243: oe_debug_pub.add( 'ENTERING LOG_CONFIG_SCH_REQUEST' , 3 ) ;

239: --
240: BEGIN
241:
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add( 'ENTERING LOG_CONFIG_SCH_REQUEST' , 3 ) ;
244: END IF;
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:

Line 258: oe_debug_pub.add( 'INC ITEM: CASCADE/MODIFY_INC_ITEMS CALL ' , 3 ) ;

254: OE_CONFIG_UTIL.G_CONFIG_UI_USED = 'N'
255: THEN
256: IF p_line_rec.item_type_code = 'INCLUDED' THEN
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add( 'INC ITEM: CASCADE/MODIFY_INC_ITEMS CALL ' , 3 ) ;
259: END IF;
260: RETURN;
261: END IF;
262:

Line 265: oe_debug_pub.add( 'SMC VALIDATE CFG CHANGES' , 3 ) ;

261: END IF;
262:
263: IF p_line_rec.ship_model_complete_flag = 'Y' THEN
264: IF l_debug_level > 0 THEN
265: oe_debug_pub.add( 'SMC VALIDATE CFG CHANGES' , 3 ) ;
266: END IF;
267: RETURN;
268: END IF;
269:

Line 273: oe_debug_pub.add( 'PURE ATO VALIDATE CFG CHANGES' , 3 ) ;

269:
270: IF p_line_rec.ato_line_id is not NULL AND
271: p_line_rec.ato_line_id = p_line_rec.top_model_line_id THEN
272: IF l_debug_level > 0 THEN
273: oe_debug_pub.add( 'PURE ATO VALIDATE CFG CHANGES' , 3 ) ;
274: END IF;
275: RETURN;
276: END IF;
277: END IF;

Line 329: oe_debug_pub.add( 'SETTING PTO_ATO_NONUI TO Y' , 3 ) ;

325: THEN
326: IF p_line_rec.item_type_code = 'CLASS' OR
327: p_line_rec.top_model_line_id <> p_line_rec.ato_line_id THEN
328: IF l_debug_level > 0 THEN
329: oe_debug_pub.add( 'SETTING PTO_ATO_NONUI TO Y' , 3 ) ;
330: END IF;
331: l_pto_ato_nonui := 'Y';
332: END IF;
333: END IF;

Line 341: oe_debug_pub.add( 'LOGGING REQ TO SCHEDULE_SMC' , 3 ) ;

337:
338: IF p_line_rec.ship_model_complete_flag = 'Y' THEN
339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add( 'LOGGING REQ TO SCHEDULE_SMC' , 3 ) ;
342: END IF;
343:
344: -- 4052648 : Parameters p_param14 - 17 are added
345: OE_Delayed_Requests_Pvt.Log_Request

Line 386: oe_debug_pub.add( 'LOGGING REQ TO SCHEDULE_ATO' , 3 ) ;

382: NOT (p_line_rec.ato_line_id = p_line_rec.line_id AND
383: p_line_rec.item_type_code = 'OPTION') THEN
384:
385: IF l_debug_level > 0 THEN
386: oe_debug_pub.add( 'LOGGING REQ TO SCHEDULE_ATO' , 3 ) ;
387: END IF;
388:
389: -- 4052648 : Parameters p_param14 - 17 are added
390: OE_Delayed_Requests_Pvt.Log_Request

Line 429: oe_debug_pub.add( 'LOGGING REQ TO SCHEDULE_NONSMC' , 3 ) ;

425: -------------------- NON SMC log req -----------------------
426:
427: ELSE
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'LOGGING REQ TO SCHEDULE_NONSMC' , 3 ) ;
430: END IF;
431:
432: -- 4052648 : Parameters p_param14 - 17 are added
433: OE_Delayed_Requests_Pvt.Log_Request

Line 470: oe_debug_pub.add( 'CALLER IS EXTERNAL' , 1 ) ;

466:
467: IF p_caller = OE_SCHEDULE_UTIL.SCH_EXTERNAL THEN
468:
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'CALLER IS EXTERNAL' , 1 ) ;
471: END IF;
472:
473: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
474: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

Line 480: oe_debug_pub.add( 'After calling request for entity ' || X_RETURN_STATUS , 1 ) ;

476: ,x_return_status => x_return_status );
477:
478:
479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( 'After calling request for entity ' || X_RETURN_STATUS , 1 ) ;
481: END IF;
482:
483: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 493: oe_debug_pub.add( '1 RETURN_STATUS IS ' || X_RETURN_STATUS , 1 ) ;

489: OE_Order_PVT.Process_Requests_And_Notify
490: ( x_return_status => x_return_status);
491:
492: IF l_debug_level > 0 THEN
493: oe_debug_pub.add( '1 RETURN_STATUS IS ' || X_RETURN_STATUS , 1 ) ;
494: END IF;
495:
496: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 505: oe_debug_pub.add( 'LEAVING LOG_CONFIG_SCH_REQUEST '|| X_RETURN_STATUS , 3 ) ;

501:
502: END IF;
503:
504: IF l_debug_level > 0 THEN
505: oe_debug_pub.add( 'LEAVING LOG_CONFIG_SCH_REQUEST '|| X_RETURN_STATUS , 3 ) ;
506: END IF;
507:
508: EXCEPTION
509: WHEN OTHERS THEN

Line 512: oe_debug_pub.add( 'LOG_CONFIG_SCH_REQUEST ERROR '|| SQLERRM , 1 ) ;

508: EXCEPTION
509: WHEN OTHERS THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: IF l_debug_level > 0 THEN
512: oe_debug_pub.add( 'LOG_CONFIG_SCH_REQUEST ERROR '|| SQLERRM , 1 ) ;
513: END IF;
514:
515: Delete_Attribute_Changes
516: (p_entity_id => p_line_rec.top_model_line_id);

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

542: l_qty_to_unreserve NUMBER;
543: l_index NUMBER;
544: I NUMBER;
545: --
546: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
547: --
548: BEGIN
549: IF l_debug_level > 0 THEN
550: oe_debug_pub.add( 'ENTERING LOG_ATTRIBUTE_CHANGES' , 3 ) ;

Line 550: oe_debug_pub.add( 'ENTERING LOG_ATTRIBUTE_CHANGES' , 3 ) ;

546: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
547: --
548: BEGIN
549: IF l_debug_level > 0 THEN
550: oe_debug_pub.add( 'ENTERING LOG_ATTRIBUTE_CHANGES' , 3 ) ;
551: END IF;
552:
553: x_unreserve_flag := 'N';
554: l_index := p_line_rec.line_id;

Line 561: oe_debug_pub.add( 'NEW ORD QTY '|| P_LINE_REC.ORDERED_QUANTITY , 4 ) ;

557: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,
558: p_old_line_rec.ordered_quantity)
559: THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add( 'NEW ORD QTY '|| P_LINE_REC.ORDERED_QUANTITY , 4 ) ;
562: END IF;
563:
564: IF nvl(p_old_line_rec.reserved_quantity, 0) >
565: p_line_rec.ordered_quantity

Line 568: oe_debug_pub.add( 'MAY NEED TO UNRESERVE' , 4 ) ;

564: IF nvl(p_old_line_rec.reserved_quantity, 0) >
565: p_line_rec.ordered_quantity
566: THEN
567: IF l_debug_level > 0 THEN
568: oe_debug_pub.add( 'MAY NEED TO UNRESERVE' , 4 ) ;
569: END IF;
570: l_qty_to_unreserve
571: := p_old_line_rec.reserved_quantity - p_line_rec.ordered_quantity;
572: END IF;

Line 584: oe_debug_pub.add( 'RES QTY DIFF '|| L_DIFF_RES_QTY , 1 ) ;

580: l_diff_res_qty := nvl(p_line_rec.reserved_quantity, 0) -
581: nvl(p_old_line_rec.reserved_quantity, 0);
582:
583: IF l_debug_level > 0 THEN
584: oe_debug_pub.add( 'RES QTY DIFF '|| L_DIFF_RES_QTY , 1 ) ;
585: END IF;
586:
587: IF l_diff_res_qty > 0 THEN
588: l_qty_to_reserve := l_diff_res_qty;

Line 603: oe_debug_pub.add( 'OLD SFROM '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 4 ) ;

599:
600: IF p_old_line_rec.ship_from_org_id is NOT NULL THEN
601: x_unreserve_flag := 'Y';
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'OLD SFROM '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 4 ) ;
604: END IF;
605: END IF;
606:
607: l_qty_to_reserve

Line 615: oe_debug_pub.add( P_LINE_REC.LINE_ID || '.'|| L_QTY_TO_RESERVE , 3 ) ;

611: END IF;
612:
613:
614: IF l_debug_level > 0 THEN
615: oe_debug_pub.add( P_LINE_REC.LINE_ID || '.'|| L_QTY_TO_RESERVE , 3 ) ;
616: END IF;
617:
618: IF l_qty_to_reserve is not NULL OR
619: l_qty_to_unreserve is not NULL THEN

Line 631: oe_debug_pub.add( 'RES ' || OE_RESERVATIONS_TBL ( L_INDEX ) .QTY_TO_RESERVE , 3 ) ;

627: OE_Reservations_Tbl(l_index).qty_to_unreserve
628: := l_qty_to_unreserve;
629:
630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add( 'RES ' || OE_RESERVATIONS_TBL ( L_INDEX ) .QTY_TO_RESERVE , 3 ) ;
632: END IF;
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add( 'ENTITY_ID '|| OE_RESERVATIONS_TBL ( L_INDEX ) .ENTITY_ID , 3 ) ;
635: END IF;

Line 634: oe_debug_pub.add( 'ENTITY_ID '|| OE_RESERVATIONS_TBL ( L_INDEX ) .ENTITY_ID , 3 ) ;

630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add( 'RES ' || OE_RESERVATIONS_TBL ( L_INDEX ) .QTY_TO_RESERVE , 3 ) ;
632: END IF;
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add( 'ENTITY_ID '|| OE_RESERVATIONS_TBL ( L_INDEX ) .ENTITY_ID , 3 ) ;
635: END IF;
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add( 'LINE_ID ' || OE_RESERVATIONS_TBL ( L_INDEX ) .LINE_ID , 3 ) ;
638: END IF;

Line 637: oe_debug_pub.add( 'LINE_ID ' || OE_RESERVATIONS_TBL ( L_INDEX ) .LINE_ID , 3 ) ;

633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add( 'ENTITY_ID '|| OE_RESERVATIONS_TBL ( L_INDEX ) .ENTITY_ID , 3 ) ;
635: END IF;
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add( 'LINE_ID ' || OE_RESERVATIONS_TBL ( L_INDEX ) .LINE_ID , 3 ) ;
638: END IF;
639:
640: IF l_qty_to_unreserve is NOT NULL THEN
641: IF l_debug_level > 0 THEN

Line 642: oe_debug_pub.add( 'UNRES '||OE_RESERVATIONS_TBL ( L_INDEX ) .QTY_TO_UNRESERVE , 3 ) ;

638: END IF;
639:
640: IF l_qty_to_unreserve is NOT NULL THEN
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add( 'UNRES '||OE_RESERVATIONS_TBL ( L_INDEX ) .QTY_TO_UNRESERVE , 3 ) ;
643: END IF;
644: x_unreserve_flag := 'Y';
645: END IF;
646:

Line 650: oe_debug_pub.add( 'LEAVING LOG_ATTRIBUTE_CHANGES '||X_UNRESERVE_FLAG , 3 ) ;

646:
647: END IF;
648:
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add( 'LEAVING LOG_ATTRIBUTE_CHANGES '||X_UNRESERVE_FLAG , 3 ) ;
651: END IF;
652:
653: EXCEPTION
654: WHEN OTHERS THEN

Line 656: oe_debug_pub.add( 'LOG_ATTRIBUTE_CHANGES ERROR '|| SQLERRM , 1 ) ;

652:
653: EXCEPTION
654: WHEN OTHERS THEN
655: IF l_debug_level > 0 THEN
656: oe_debug_pub.add( 'LOG_ATTRIBUTE_CHANGES ERROR '|| SQLERRM , 1 ) ;
657: END IF;
658: RAISE;
659: END Log_Attribute_Changes;
660:

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

672: (p_entity_id NUMBER := -1)
673: IS
674: I NUMBER;
675: --
676: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
677: --
678: BEGIN
679:
680: IF l_debug_level > 0 THEN

Line 681: oe_debug_pub.add( 'ENTERING DELETE_ATTRIBUTE_CHANGES '|| P_ENTITY_ID , 3 ) ;

677: --
678: BEGIN
679:
680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( 'ENTERING DELETE_ATTRIBUTE_CHANGES '|| P_ENTITY_ID , 3 ) ;
682: END IF;
683:
684: IF p_entity_id = -1 THEN
685: OE_Reservations_Tbl.DELETE;

Line 694: oe_debug_pub.add( '---- LINE '|| OE_RESERVATIONS_TBL ( I ) .LINE_ID ) ;

690:
691: WHILE I is not NULL
692: LOOP
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( '---- LINE '|| OE_RESERVATIONS_TBL ( I ) .LINE_ID ) ;
695: END IF;
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'QTY_TO_RES '|| OE_RESERVATIONS_TBL ( I ) .QTY_TO_RESERVE ) ;
698: END IF;

Line 697: oe_debug_pub.add( 'QTY_TO_RES '|| OE_RESERVATIONS_TBL ( I ) .QTY_TO_RESERVE ) ;

693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( '---- LINE '|| OE_RESERVATIONS_TBL ( I ) .LINE_ID ) ;
695: END IF;
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'QTY_TO_RES '|| OE_RESERVATIONS_TBL ( I ) .QTY_TO_RESERVE ) ;
698: END IF;
699:
700: IF OE_Reservations_Tbl(I).entity_id = p_entity_id THEN
701: IF l_debug_level > 0 THEN

Line 702: oe_debug_pub.add( 'DELETING '|| I , 3 ) ;

698: END IF;
699:
700: IF OE_Reservations_Tbl(I).entity_id = p_entity_id THEN
701: IF l_debug_level > 0 THEN
702: oe_debug_pub.add( 'DELETING '|| I , 3 ) ;
703: END IF;
704: OE_Reservations_Tbl.DELETE(I);
705: END IF;
706:

Line 711: oe_debug_pub.add( 'LEAVING LOG_ATTRIBUTE_CHANGES' , 3 ) ;

707: I := OE_Reservations_Tbl.NEXT(I);
708: END LOOP;
709:
710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add( 'LEAVING LOG_ATTRIBUTE_CHANGES' , 3 ) ;
712: END IF;
713:
714: EXCEPTION
715: WHEN OTHERS THEN

Line 717: oe_debug_pub.add( 'DELETE_ATTRIBUTE_CHANGES ERROR '|| SQLERRM , 1 ) ;

713:
714: EXCEPTION
715: WHEN OTHERS THEN
716: IF l_debug_level > 0 THEN
717: oe_debug_pub.add( 'DELETE_ATTRIBUTE_CHANGES ERROR '|| SQLERRM , 1 ) ;
718: END IF;
719: RAISE;
720: END Delete_Attribute_Changes;
721:

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

778: l_control_rec OE_GLOBALS.control_rec_type;
779: I NUMBER;
780: l_send_cancel_lines VARCHAR2(1); -- 2882255
781: --
782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
783: --
784: BEGIN
785: Print_Time('entering Schedule_SMC ' || p_request_rec.entity_id);
786:

Line 828: oe_debug_pub.add( 'CALLING PROCESS_GROUP IN SMC' , 3 ) ;

824:
825: ------------- setting attributes done -------------------
826:
827: IF l_debug_level > 0 THEN
828: oe_debug_pub.add( 'CALLING PROCESS_GROUP IN SMC' , 3 ) ;
829: END IF;
830:
831: Process_Group
832: (p_x_line_tbl => l_line_tbl

Line 850: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_SMC' , 1 ) ;

846: Print_Time('leaving Schedule_SMC ' || p_request_rec.entity_id);
847: EXCEPTION
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF l_debug_level > 0 THEN
850: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_SMC' , 1 ) ;
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854:

Line 857: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_SMC' , 1 ) ;

853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_SMC' , 1 ) ;
858: END IF;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: RAISE FND_API.G_EXC_ERROR;
861:

Line 864: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_SMC '|| SQLERRM , 1 ) ;

860: RAISE FND_API.G_EXC_ERROR;
861:
862: WHEN OTHERS THEN
863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_SMC '|| SQLERRM , 1 ) ;
865: END IF;
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
868: THEN

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

926: l_send_cancel_lines VARCHAR2(1); -- 2882255
927: l_request VARCHAR2(8) := 'ATO';
928: l_request_search_rslt BOOLEAN;
929: --
930: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
931: --
932: BEGIN
933:
934: Print_Time('Entering Schedule_ATO ' || p_request_rec.entity_id);

Line 1048: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_ATO' , 1 ) ;

1044:
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_ATO' , 1 ) ;
1049: END IF;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052:

Line 1055: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_ATO' , 1 ) ;

1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_ATO' , 1 ) ;
1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: RAISE FND_API.G_EXC_ERROR;
1059:

Line 1062: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_ATO '|| SQLERRM , 1 ) ;

1058: RAISE FND_API.G_EXC_ERROR;
1059:
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_ATO '|| SQLERRM , 1 ) ;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN

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

1103: L NUMBER := 0;
1104: I NUMBER;
1105: l_sales_order_id NUMBER;
1106: --
1107: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1108: --
1109: BEGIN
1110: Print_Time('entering schedule_nonsmc ' || p_request_tbl.COUNT);
1111:

Line 1121: oe_debug_pub.add( 'LINE ' || P_REQUEST_TBL ( I ) .ENTITY_ID , 3 ) ;

1117: IF p_request_tbl(I).param10 = 'Y' THEN
1118:
1119: J := J + 1;
1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add( 'LINE ' || P_REQUEST_TBL ( I ) .ENTITY_ID , 3 ) ;
1122: END IF;
1123:
1124: l_line_tbl(J).line_id := 0;
1125:

Line 1152: oe_debug_pub.add( 'CALLING VALIDATE_AND_ASSIGN_SCH_PARAMS' , 3 ) ;

1148:
1149: l_old_line_tbl(J) := l_line_tbl(J);
1150:
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( 'CALLING VALIDATE_AND_ASSIGN_SCH_PARAMS' , 3 ) ;
1153: END IF;
1154:
1155: Validate_And_Assign_Sch_Params
1156: ( p_request_rec => p_request_tbl(I)

Line 1164: oe_debug_pub.add( 'CALLING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;

1160:
1161: IF l_line_tbl(J).item_type_code in ('MODEL', 'CLASS', 'KIT')
1162: THEN
1163: IF l_debug_level > 0 THEN
1164: oe_debug_pub.add( 'CALLING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;
1165: END IF;
1166:
1167: Get_Included_Items_To_Sch
1168: ( p_x_line_tbl => l_line_tbl

Line 1178: oe_debug_pub.add( 'ALREADY PROCESSED INC ITEM' , 3 ) ;

1174: END IF;
1175:
1176: ELSE
1177: IF l_debug_level > 0 THEN
1178: oe_debug_pub.add( 'ALREADY PROCESSED INC ITEM' , 3 ) ;
1179: END IF;
1180: END IF;
1181:
1182: I := p_request_tbl.NEXT(I);

Line 1187: oe_debug_pub.add( P_REQUEST_TBL ( 1 ) .PARAM1||' '||P_REQUEST_TBL ( 1 ) .PARAM24 , 3 ) ;

1183:
1184: END LOOP;
1185:
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( P_REQUEST_TBL ( 1 ) .PARAM1||' '||P_REQUEST_TBL ( 1 ) .PARAM24 , 3 ) ;
1188: END IF;
1189:
1190: Process_Group
1191: (p_x_line_tbl => l_line_tbl

Line 1209: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_NONSMC' , 1 ) ;

1205: Print_Time('leaving schedule_nonsmc');
1206: EXCEPTION
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1210: END IF;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213:

Line 1216: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_NONSMC' , 1 ) ;

1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: IF l_debug_level > 0 THEN
1216: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1217: END IF;
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: RAISE FND_API.G_EXC_ERROR;
1220:

Line 1223: oe_debug_pub.add( 'OTHERS IN SCHEDULE_NONSMC '|| SQLERRM , 1 ) ;

1219: RAISE FND_API.G_EXC_ERROR;
1220:
1221: WHEN OTHERS THEN
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'OTHERS IN SCHEDULE_NONSMC '|| SQLERRM , 1 ) ;
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1227: THEN

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

1255: l_unreserve_flag VARCHAR2(1);
1256: l_send_cancel_lines VARCHAR2(1); -- 2882255
1257: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1258: --
1259: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1260: --
1261: BEGIN
1262: IF l_debug_level > 0 THEN
1263: oe_debug_pub.add( 'ENTERING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;

Line 1263: oe_debug_pub.add( 'ENTERING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;

1259: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1260: --
1261: BEGIN
1262: IF l_debug_level > 0 THEN
1263: oe_debug_pub.add( 'ENTERING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;
1264: END IF;
1265:
1266: -- 2882255
1267: IF p_request_tbl(p_req_index).param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE

Line 1298: oe_debug_pub.add( K||'INC ITEM '||P_X_LINE_TBL ( P_IN_INDEX ) .LINE_ID , 4 ) ;

1294: p_in_index := p_in_index + 1;
1295: p_x_line_tbl(p_in_index) := l_inc_items_tbl(K);
1296: p_x_old_line_tbl(p_in_index) := l_inc_items_tbl(K);
1297: IF l_debug_level > 0 THEN
1298: oe_debug_pub.add( K||'INC ITEM '||P_X_LINE_TBL ( P_IN_INDEX ) .LINE_ID , 4 ) ;
1299: END IF;
1300:
1301: l_done := FALSE;
1302:

Line 1309: oe_debug_pub.add( L || ' USER CHANGED INC ITEM '|| P_IN_INDEX , 5 ) ;

1305: LOOP
1306: IF p_request_tbl(L).entity_id = l_inc_items_tbl(K).line_id
1307: THEN
1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add( L || ' USER CHANGED INC ITEM '|| P_IN_INDEX , 5 ) ;
1310: END IF;
1311:
1312: Validate_And_Assign_Sch_Params
1313: ( p_request_rec => p_request_tbl(L) -- imp use L

Line 1325: oe_debug_pub.add( 'LOOPED THRU REQ TBL '|| L , 3 ) ;

1321: L := p_request_tbl.NEXT(L);
1322: END LOOP;
1323:
1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add( 'LOOPED THRU REQ TBL '|| L , 3 ) ;
1326: END IF;
1327:
1328: IF NOT l_done THEN
1329: IF l_debug_level > 0 THEN

Line 1330: oe_debug_pub.add( P_REQ_INDEX||' USER CHANGED PARENT '||P_IN_INDEX , 5 ) ;

1326: END IF;
1327:
1328: IF NOT l_done THEN
1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add( P_REQ_INDEX||' USER CHANGED PARENT '||P_IN_INDEX , 5 ) ;
1331: END IF;
1332:
1333: Validate_And_Assign_Sch_Params
1334: ( p_request_rec => p_request_tbl(p_req_index) -- imp req_index

Line 1353: oe_debug_pub.add( 'LEAVING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;

1349:
1350: END IF; -- if inc tbl count > 0
1351:
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'LEAVING GET_INCLUDED_ITEMS_TO_SCH' , 3 ) ;
1354: END IF;
1355:
1356: EXCEPTION
1357: WHEN OTHERS THEN

Line 1359: oe_debug_pub.add( 'GET_INCLUDED_ITEMS_TO_SCH '|| SQLERRM , 1 ) ;

1355:
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'GET_INCLUDED_ITEMS_TO_SCH '|| SQLERRM , 1 ) ;
1360: END IF;
1361: RAISE;
1362: END Get_Included_Items_To_Sch;
1363:

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

1411: l_msg_data VARCHAR2(2000);
1412: l_control_rec OE_GLOBALS.control_rec_type;
1413: l_sch_action VARCHAR2(30);
1414: --
1415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1416: --
1417: BEGIN
1418: Print_Time('entering Process_Group');
1419:

Line 1426: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;

1422: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE OR
1423: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE
1424: THEN
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;
1427: END IF;
1428:
1429: Unreserve_group(p_line_tbl => p_x_line_tbl
1430: ,p_sch_action => p_sch_action); -- 2595661

Line 1435: oe_debug_pub.add( 'NOW UNSCHEDULING...' , 3 ) ;

1431:
1432: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_UNSCHEDULE
1433: THEN
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add( 'NOW UNSCHEDULING...' , 3 ) ;
1436: END IF;
1437:
1438: Call_Mrp
1439: ( p_x_line_tbl => p_x_line_tbl

Line 1448: oe_debug_pub.add( 'SCH ACTION IS '|| P_SCH_ACTION , 3 ) ;

1444:
1445: ELSE ---------- action is sch or resch or reserve.-----
1446:
1447: IF l_debug_level > 0 THEN
1448: oe_debug_pub.add( 'SCH ACTION IS '|| P_SCH_ACTION , 3 ) ;
1449: END IF;
1450:
1451: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESERVE THEN
1452: l_sch_action := OE_Schedule_Util.OESCH_ACT_SCHEDULE;

Line 1462: oe_debug_pub.add( '1 CALLING HANDLE_UNRESERVE' , 4 ) ;

1458: (p_handle_unreserve = 'Y' OR
1459: p_caller = 'SET')
1460: THEN
1461: IF l_debug_level > 0 THEN
1462: oe_debug_pub.add( '1 CALLING HANDLE_UNRESERVE' , 4 ) ;
1463: END IF;
1464:
1465: Handle_Unreserve
1466: (p_x_line_tbl => p_x_line_tbl

Line 1490: oe_debug_pub.add( '2 CALLING HANDLE_UNRESERVE' , 4 ) ;

1486: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE AND
1487: p_caller = 'SET'
1488: THEN
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( '2 CALLING HANDLE_UNRESERVE' , 4 ) ;
1491: END IF;
1492:
1493: Handle_Unreserve
1494: (p_x_line_tbl => p_x_line_tbl

Line 1520: oe_debug_pub.add( 'NO NEED TO CALL LINES' , 3 ) ;

1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518: ELSE
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'NO NEED TO CALL LINES' , 3 ) ;
1521: END IF;
1522: END IF;
1523:
1524:

Line 1530: oe_debug_pub.add( 'CALLING RESERVE_GROUP NOW ' , 3 ) ;

1526: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE AND
1527: p_sch_action <> OE_Schedule_Util.OESCH_ACT_UNRESERVE
1528: THEN
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add( 'CALLING RESERVE_GROUP NOW ' , 3 ) ;
1531: END IF;
1532:
1533: Reserve_Group
1534: ( p_x_line_tbl => p_x_line_tbl

Line 1557: oe_debug_pub.add( 'EXC ERROR IN PROCESS_GROUP' , 1 ) ;

1553: p_x_line_tbl(1).ship_set_id),
1554: p_x_line_tbl(1).top_model_line_id));
1555:
1556: IF l_debug_level > 0 THEN
1557: oe_debug_pub.add( 'EXC ERROR IN PROCESS_GROUP' , 1 ) ;
1558: END IF;
1559: END IF;
1560:
1561: -- do not raise, caller wants to handle: sets

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

1608: l_msg_count NUMBER;
1609: l_mrp_called BOOLEAN := FALSE;
1610:
1611: --
1612: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1613: --
1614: BEGIN
1615:
1616: Print_Time('entering Call_Mrp');

Line 1633: oe_debug_pub.add( 'NEED TO CALL MRP , > 0 COUNT' , 1 ) ;

1629: -- 1955004 modified statement below from = to >
1630: -- removed return and end if to encompass code to add an else clause
1631: IF l_mrp_atp_rec.error_code.count > 0 THEN
1632: IF l_debug_level > 0 THEN
1633: oe_debug_pub.add( 'NEED TO CALL MRP , > 0 COUNT' , 1 ) ;
1634: END IF;
1635:
1636:
1637: l_session_id := OE_SCHEDULE_UTIL.Get_Session_Id;

Line 1640: oe_debug_pub.add( 'SESSION ID IN CALL_MRP ' || L_SESSION_ID , 2 ) ;

1636:
1637: l_session_id := OE_SCHEDULE_UTIL.Get_Session_Id;
1638:
1639: IF l_debug_level > 0 THEN
1640: oe_debug_pub.add( 'SESSION ID IN CALL_MRP ' || L_SESSION_ID , 2 ) ;
1641: END IF;
1642:
1643: Print_Time('calling mrps atp api');
1644:

Line 1674: oe_debug_pub.add( 'CALLING LOAD_RESULTS' , 1 ) ;

1670: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1671: -- the call to MRP was successful, so load the results
1672:
1673: IF l_debug_level > 0 THEN
1674: oe_debug_pub.add( 'CALLING LOAD_RESULTS' , 1 ) ;
1675: END IF;
1676:
1677: OE_Schedule_Util.Load_Results_from_tbl
1678: ( p_atp_rec => l_out_mtp_atp_rec

Line 1687: oe_debug_pub.add( 'AFTER LOAD_RESULTS: ' || X_RETURN_STATUS , 1 ) ;

1683: , p_partial_set => p_partial_set
1684: , x_return_status => x_return_status);
1685:
1686: IF l_debug_level > 0 THEN
1687: oe_debug_pub.add( 'AFTER LOAD_RESULTS: ' || X_RETURN_STATUS , 1 ) ;
1688: END IF;
1689:
1690: ELSE
1691: IF l_out_mtp_atp_rec.error_code.count = 0 AND

Line 1696: oe_debug_pub.add( 'MRP HAS NOT RETURNED ANY DATA' , 1 ) ;

1692: l_mrp_called THEN
1693: -- we were expecting some date from MRP, but did not get any
1694:
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'MRP HAS NOT RETURNED ANY DATA' , 1 ) ;
1697: END IF;
1698:
1699: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
1700: OE_MSG_PUB.Add;

Line 1716: oe_debug_pub.add( 'CALLING INACTIVE_DEMAND_SCHEDULING FROM ELSE IN CALL_MRP' , 1 ) ;

1712: (p_x_line_tbl(I).line_id) THEN
1713: -- we know this line has an inactive demand scheduling level
1714:
1715: IF l_debug_level > 0 THEN
1716: oe_debug_pub.add( 'CALLING INACTIVE_DEMAND_SCHEDULING FROM ELSE IN CALL_MRP' , 1 ) ;
1717: END IF;
1718:
1719: OE_SCHEDULE_UTIL.Inactive_demand_scheduling
1720: (p_x_old_line_rec => p_old_line_tbl(I)

Line 1756: oe_debug_pub.add( 'CALL_MRP ERROR' || SQLERRM , 1 ) ;

1752:
1753: EXCEPTION
1754: WHEN OTHERS THEN
1755: IF l_debug_level > 0 THEN
1756: oe_debug_pub.add( 'CALL_MRP ERROR' || SQLERRM , 1 ) ;
1757: END IF;
1758: RAISE;
1759: END Call_Mrp;
1760:

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

1778: IS
1779: l_return_status VARCHAR2(1);
1780: I NUMBER;
1781: --
1782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1783: --
1784: BEGIN
1785:
1786: Print_Time('entering Unreserve_group');

Line 1796: oe_debug_pub.add( P_LINE_TBL ( I ) .LINE_ID||'UNRESERVE ' ||P_LINE_TBL ( I ) .RESERVED_QUANTITY , 3 ) ;

1792: IF p_line_tbl(I).reserved_quantity > 0 AND
1793: p_line_tbl(I).reserved_quantity is NOT NULL THEN
1794:
1795: IF l_debug_level > 0 THEN
1796: oe_debug_pub.add( P_LINE_TBL ( I ) .LINE_ID||'UNRESERVE ' ||P_LINE_TBL ( I ) .RESERVED_QUANTITY , 3 ) ;
1797: END IF;
1798: -- Start 2595661
1799: IF nvl(p_line_tbl(I).shipping_interfaced_flag,'N') = 'Y' THEN
1800: IF ( (p_sch_action = OE_Schedule_Util.OESCH_ACT_UNRESERVE

Line 1833: oe_debug_pub.add( 'ADDING REC TO RES TBL' , 2 ) ;

1829: OE_Reservations_Tbl(p_line_tbl(I).line_id).qty_to_reserve
1830: is NULL
1831: THEN
1832: IF l_debug_level > 0 THEN
1833: oe_debug_pub.add( 'ADDING REC TO RES TBL' , 2 ) ;
1834: END IF;
1835:
1836: IF p_line_tbl(I).arrival_set_id is NOT NULL THEN
1837: OE_Reservations_Tbl(p_line_tbl(I).line_id).entity_id

Line 1868: oe_debug_pub.add( 'RES ' || OE_RESERVATIONS_TBL ( P_LINE_TBL ( I ) .LINE_ID ) .QTY_TO_RESERVE , 3 ) ;

1864: := p_line_tbl(I).ordered_quantity;
1865: END IF;
1866:
1867: IF l_debug_level > 0 THEN
1868: oe_debug_pub.add( 'RES ' || OE_RESERVATIONS_TBL ( P_LINE_TBL ( I ) .LINE_ID ) .QTY_TO_RESERVE , 3 ) ;
1869: END IF;
1870: END IF;
1871:
1872: END IF; -- action = reschedule

Line 1885: oe_debug_pub.add( 'UNRESERVE_GROUP ERROR' || SQLERRM , 1 ) ;

1881:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: IF l_debug_level > 0 THEN
1885: oe_debug_pub.add( 'UNRESERVE_GROUP ERROR' || SQLERRM , 1 ) ;
1886: END IF;
1887: RAISE;
1888: END Unreserve_group;
1889:

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

1927: l_reservation_qty2 NUMBER; -- INVCONV
1928: I NUMBER;
1929: l_rsv_update BOOLEAN := FALSE;
1930: --
1931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1932: --
1933: BEGIN
1934:
1935: Print_Time('entering Reserve_Group ' || p_sch_action);

Line 1965: oe_debug_pub.add( 'WORKING ON LINE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

1961: nvl(p_x_line_tbl(I).schedule_status_code, 'X') =
1962: OE_SCHEDULE_UTIL.OESCH_STATUS_SCHEDULED
1963: THEN
1964: IF l_debug_level > 0 THEN
1965: oe_debug_pub.add( 'WORKING ON LINE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
1966: END IF;
1967:
1968: l_sch_level := OE_SCHEDULE_UTIL.Get_Scheduling_Level
1969: (p_x_line_tbl(I).header_id,

Line 1978: oe_debug_pub.add( 'SCH LEVEL ALLOWS FOR RESERVATION' , 3 ) ;

1974: OE_Schedule_Util.SCH_LEVEL_THREE
1975: OR l_sch_level = OE_Schedule_Util.SCH_LEVEL_FOUR
1976: THEN
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add( 'SCH LEVEL ALLOWS FOR RESERVATION' , 3 ) ;
1979: END IF;
1980:
1981: Get_Reservations( p_line_rec => p_x_line_tbl(I)
1982: ,x_reservation_qty => l_reservation_qty

Line 1996: oe_debug_pub.add( 'RESERVE '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY , 3 ) ;

1992: OE_SCHEDULE_UTIL.Within_Rsv_Time_Fence
1993: (p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
1994:
1995: IF l_debug_level > 0 THEN
1996: oe_debug_pub.add( 'RESERVE '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY , 3 ) ;
1997: oe_debug_pub.add( 'RESERVE 2 '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY2 , 3 ) ; -- INVCONV
1998: END IF;
1999: l_reservation_qty := p_x_line_tbl(I).ordered_quantity;
2000: l_reservation_qty2 := p_x_line_tbl(I).ordered_quantity2; -- INVCONV

Line 1997: oe_debug_pub.add( 'RESERVE 2 '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY2 , 3 ) ; -- INVCONV

1993: (p_x_line_tbl(I).schedule_ship_date, p_x_line_tbl(I).org_id) THEN --4689197
1994:
1995: IF l_debug_level > 0 THEN
1996: oe_debug_pub.add( 'RESERVE '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY , 3 ) ;
1997: oe_debug_pub.add( 'RESERVE 2 '||P_X_LINE_TBL ( I ) .ORDERED_QUANTITY2 , 3 ) ; -- INVCONV
1998: END IF;
1999: l_reservation_qty := p_x_line_tbl(I).ordered_quantity;
2000: l_reservation_qty2 := p_x_line_tbl(I).ordered_quantity2; -- INVCONV
2001:

Line 2019: oe_debug_pub.add( 'RESERVE QUANTITY'||P_X_LINE_TBL(I).RESERVED_QUANTITY , 3 ) ;

2015:
2016:
2017: l_rsv_update := TRUE;
2018: IF l_debug_level > 0 THEN
2019: oe_debug_pub.add( 'RESERVE QUANTITY'||P_X_LINE_TBL(I).RESERVED_QUANTITY , 3 ) ;
2020: oe_debug_pub.add('Qunatity to reserve :'||l_reservation_qty,3);
2021: oe_debug_pub.add( 'RESERVE QUANTITY2'||P_X_LINE_TBL(I).RESERVED_QUANTITY2 , 3 ) ; -- INVCONV
2022: oe_debug_pub.add('Quantity to reserve :'||l_reservation_qty2,3);
2023:

Line 2020: oe_debug_pub.add('Qunatity to reserve :'||l_reservation_qty,3);

2016:
2017: l_rsv_update := TRUE;
2018: IF l_debug_level > 0 THEN
2019: oe_debug_pub.add( 'RESERVE QUANTITY'||P_X_LINE_TBL(I).RESERVED_QUANTITY , 3 ) ;
2020: oe_debug_pub.add('Qunatity to reserve :'||l_reservation_qty,3);
2021: oe_debug_pub.add( 'RESERVE QUANTITY2'||P_X_LINE_TBL(I).RESERVED_QUANTITY2 , 3 ) ; -- INVCONV
2022: oe_debug_pub.add('Quantity to reserve :'||l_reservation_qty2,3);
2023:
2024: END IF;

Line 2021: oe_debug_pub.add( 'RESERVE QUANTITY2'||P_X_LINE_TBL(I).RESERVED_QUANTITY2 , 3 ) ; -- INVCONV

2017: l_rsv_update := TRUE;
2018: IF l_debug_level > 0 THEN
2019: oe_debug_pub.add( 'RESERVE QUANTITY'||P_X_LINE_TBL(I).RESERVED_QUANTITY , 3 ) ;
2020: oe_debug_pub.add('Qunatity to reserve :'||l_reservation_qty,3);
2021: oe_debug_pub.add( 'RESERVE QUANTITY2'||P_X_LINE_TBL(I).RESERVED_QUANTITY2 , 3 ) ; -- INVCONV
2022: oe_debug_pub.add('Quantity to reserve :'||l_reservation_qty2,3);
2023:
2024: END IF;
2025:

Line 2022: oe_debug_pub.add('Quantity to reserve :'||l_reservation_qty2,3);

2018: IF l_debug_level > 0 THEN
2019: oe_debug_pub.add( 'RESERVE QUANTITY'||P_X_LINE_TBL(I).RESERVED_QUANTITY , 3 ) ;
2020: oe_debug_pub.add('Qunatity to reserve :'||l_reservation_qty,3);
2021: oe_debug_pub.add( 'RESERVE QUANTITY2'||P_X_LINE_TBL(I).RESERVED_QUANTITY2 , 3 ) ; -- INVCONV
2022: oe_debug_pub.add('Quantity to reserve :'||l_reservation_qty2,3);
2023:
2024: END IF;
2025:
2026:

Line 2031: oe_debug_pub.add( 'ALREADY RESERVED '||P_X_LINE_TBL ( I ) .RESERVED_QUANTITY , 3 ) ;

2027:
2028: ELSE
2029: -- you do not want to overwrite previously supplied value,
2030: IF l_debug_level > 0 THEN
2031: oe_debug_pub.add( 'ALREADY RESERVED '||P_X_LINE_TBL ( I ) .RESERVED_QUANTITY , 3 ) ;
2032: END IF;
2033: END IF;
2034:
2035: -- Post Pack J

Line 2046: oe_debug_pub.add( 'SCH LEVEL DOES NOT ALLOW RESERVATION' , 3 ) ;

2042: END IF; -- reservation_aty = 0
2043:
2044: ELSE
2045: IF l_debug_level > 0 THEN
2046: oe_debug_pub.add( 'SCH LEVEL DOES NOT ALLOW RESERVATION' , 3 ) ;
2047: END IF;
2048: END IF; -- level check
2049:
2050: IF l_reservation_qty > 0 THEN

Line 2065: oe_debug_pub.add( 'RESERVE LINE EXPECTED ERROR , IGNORE' , 1 ) ;

2061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'RESERVE LINE EXPECTED ERROR , IGNORE' , 1 ) ;
2066: END IF;
2067: END IF;
2068:
2069: END IF; -- do reserve

Line 2079: oe_debug_pub.add( 'RESERVE_GROUP ERROR ' || SQLERRM , 1 ) ;

2075: Print_Time('leaving Reserve_Group ' ||l_return_status);
2076: EXCEPTION
2077: WHEN OTHERS THEN
2078: IF l_debug_level > 0 THEN
2079: oe_debug_pub.add( 'RESERVE_GROUP ERROR ' || SQLERRM , 1 ) ;
2080: END IF;
2081: RAISE;
2082: END Reserve_Group;
2083:

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

2106: ,x_reservation_qty2 OUT NOCOPY /* file.sql.39 change */ NUMBER -- INVCONV
2107: )
2108: IS
2109: --
2110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2111: --
2112: BEGIN
2113: IF l_debug_level > 0 THEN
2114: oe_debug_pub.add( 'ENTERING GET_RESERVATIONS ' , 3 ) ;

Line 2114: oe_debug_pub.add( 'ENTERING GET_RESERVATIONS ' , 3 ) ;

2110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2111: --
2112: BEGIN
2113: IF l_debug_level > 0 THEN
2114: oe_debug_pub.add( 'ENTERING GET_RESERVATIONS ' , 3 ) ;
2115: END IF;
2116:
2117: IF OE_Reservations_Tbl.EXISTS(p_line_rec.line_id)
2118: THEN

Line 2128: oe_debug_pub.add( 'RES VALUE '|| X_RESERVATION_QTY , 3 ) ;

2124: x_reservation_qty := p_line_rec.ordered_quantity;
2125: END IF;
2126:
2127: IF l_debug_level > 0 THEN
2128: oe_debug_pub.add( 'RES VALUE '|| X_RESERVATION_QTY , 3 ) ;
2129: END IF;
2130:
2131: /* Commented the below for bug 6335352
2132: IF p_line_rec.shipping_interfaced_flag = 'Y' AND

Line 2147: oe_debug_pub.add( P_LINE_REC.LINE_ID || ' LEAVING..'|| X_RESERVATION_QTY , 3 ) ;

2143: x_reservation_qty := 0;
2144: END IF; -- if entry exists in res tbl
2145:
2146: IF l_debug_level > 0 THEN
2147: oe_debug_pub.add( P_LINE_REC.LINE_ID || ' LEAVING..'|| X_RESERVATION_QTY , 3 ) ;
2148: END IF;
2149:
2150: EXCEPTION
2151: WHEN OTHERS THEN

Line 2153: oe_debug_pub.add( 'ERROR IN GET_RESERVATIONS '|| SQLERRM , 1 ) ;

2149:
2150: EXCEPTION
2151: WHEN OTHERS THEN
2152: IF l_debug_level > 0 THEN
2153: oe_debug_pub.add( 'ERROR IN GET_RESERVATIONS '|| SQLERRM , 1 ) ;
2154: END IF;
2155: RAISE;
2156: END Get_Reservations;
2157:

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

2194: l_qty NUMBER;
2195: l_qty2 NUMBER; -- INVCONV
2196: I NUMBER;
2197: --
2198: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2199: --
2200: BEGIN
2201:
2202: Print_Time('entering Handle_Unreserve');

Line 2207: oe_debug_pub.add( 'ENTERING POST PROCESS' , 1 ) ;

2203:
2204: IF p_post_process = FND_API.G_TRUE THEN
2205:
2206: IF l_debug_level > 0 THEN
2207: oe_debug_pub.add( 'ENTERING POST PROCESS' , 1 ) ;
2208: END IF;
2209: I := p_x_line_tbl.FIRST;
2210: WHILE I is NOT NULL
2211: LOOP

Line 2238: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;

2234: p_x_line_tbl(1).arrival_set_id is not NULL) AND
2235: p_x_line_tbl(1).ship_from_org_id <> p_old_line_tbl(1).ship_from_org_id
2236: THEN
2237: IF l_debug_level > 0 THEN
2238: oe_debug_pub.add( 'UNRESERVING...' , 3 ) ;
2239: END IF;
2240: Unreserve_group
2241: ( p_line_tbl => p_old_line_tbl
2242: ,p_sch_action => OE_Schedule_Util.OESCH_ACT_RESCHEDULE);

Line 2250: oe_debug_pub.add( 'ORDERED QTY ETC. CHANGES ' , 1 ) ;

2246:
2247:
2248: --------- handle the ordered qty etc. change -----------------
2249: IF l_debug_level > 0 THEN
2250: oe_debug_pub.add( 'ORDERED QTY ETC. CHANGES ' , 1 ) ;
2251: END IF;
2252:
2253: I := p_x_line_tbl.FIRST;
2254: WHILE I is NOT NULL

Line 2273: oe_debug_pub.add( 'ELSIF CHANGE'|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2269: --OE_Reservations_Tbl.DELETE(p_x_line_tbl(I).line_id);
2270: ELSIF p_x_line_tbl(I).ordered_quantity 2271: THEN
2272: IF l_debug_level > 0 THEN
2273: oe_debug_pub.add( 'ELSIF CHANGE'|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2274: END IF;
2275:
2276: l_qty := p_x_line_tbl(I).reserved_quantity -
2277: p_x_line_tbl(I).ordered_quantity;

Line 2284: oe_debug_pub.add( L_QTY||' UNRESERVE '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2280:
2281: END IF;
2282:
2283: IF l_debug_level > 0 THEN
2284: oe_debug_pub.add( L_QTY||' UNRESERVE '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2285: oe_debug_pub.add( L_QTY2||' UNRESERVE 2'||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2286: END IF;
2287:
2288: IF l_qty > 0 THEN

Line 2285: oe_debug_pub.add( L_QTY2||' UNRESERVE 2'||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2281: END IF;
2282:
2283: IF l_debug_level > 0 THEN
2284: oe_debug_pub.add( L_QTY||' UNRESERVE '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2285: oe_debug_pub.add( L_QTY2||' UNRESERVE 2'||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2286: END IF;
2287:
2288: IF l_qty > 0 THEN
2289: OE_SCHEDULE_UTIL.Unreserve_Line

Line 2304: oe_debug_pub.add( 'HANDLE_UNRESERVE ERROR' || SQLERRM , 1 ) ;

2300: Print_Time('leaving Handle_Unreserve');
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add( 'HANDLE_UNRESERVE ERROR' || SQLERRM , 1 ) ;
2305: END IF;
2306: RAISE;
2307:
2308: END Handle_Unreserve;

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

2323: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
2324: IS
2325: l_return_status VARCHAR2(1);
2326: --
2327: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2328: --
2329: BEGIN
2330: IF l_debug_level > 0 THEN
2331: oe_debug_pub.add( '--------ENTERING VALIDATE_AND_ASSIGN' , 1 ) ;

Line 2331: oe_debug_pub.add( '--------ENTERING VALIDATE_AND_ASSIGN' , 1 ) ;

2327: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2328: --
2329: BEGIN
2330: IF l_debug_level > 0 THEN
2331: oe_debug_pub.add( '--------ENTERING VALIDATE_AND_ASSIGN' , 1 ) ;
2332: END IF;
2333:
2334: /* 3533565 Validation will be done after cascading
2335: OE_Schedule_Util.Validate_Line

Line 2349: oe_debug_pub.add( '-------ENTITY ' || P_REQUEST_REC.ENTITY_ID , 4 ) ;

2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;
2347: */
2348: IF l_debug_level > 0 THEN
2349: oe_debug_pub.add( '-------ENTITY ' || P_REQUEST_REC.ENTITY_ID , 4 ) ;
2350: END IF;
2351: IF l_debug_level > 0 THEN
2352: oe_debug_pub.add( '-------LINE ' || P_X_LINE_REC.LINE_ID , 4 ) ;
2353: END IF;

Line 2352: oe_debug_pub.add( '-------LINE ' || P_X_LINE_REC.LINE_ID , 4 ) ;

2348: IF l_debug_level > 0 THEN
2349: oe_debug_pub.add( '-------ENTITY ' || P_REQUEST_REC.ENTITY_ID , 4 ) ;
2350: END IF;
2351: IF l_debug_level > 0 THEN
2352: oe_debug_pub.add( '-------LINE ' || P_X_LINE_REC.LINE_ID , 4 ) ;
2353: END IF;
2354: IF l_debug_level > 0 THEN
2355: oe_debug_pub.add( '-------ACTION ' || P_REQUEST_REC.PARAM1 , 4 ) ;
2356: END IF;

Line 2355: oe_debug_pub.add( '-------ACTION ' || P_REQUEST_REC.PARAM1 , 4 ) ;

2351: IF l_debug_level > 0 THEN
2352: oe_debug_pub.add( '-------LINE ' || P_X_LINE_REC.LINE_ID , 4 ) ;
2353: END IF;
2354: IF l_debug_level > 0 THEN
2355: oe_debug_pub.add( '-------ACTION ' || P_REQUEST_REC.PARAM1 , 4 ) ;
2356: END IF;
2357:
2358: p_x_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2359: p_x_line_rec.change_reason := 'SYSTEM';

Line 2405: oe_debug_pub.add( 'ASSIGN OLD VALUES '|| P_REQUEST_REC.PARAM7 , 3 ) ;

2401: AND p_x_line_rec.ato_line_id IS NOT NULL)
2402: -- bug 2427280 AND p_x_old_line_rec.schedule_status_code is NOT NULL
2403: THEN
2404: IF l_debug_level > 0 THEN
2405: oe_debug_pub.add( 'ASSIGN OLD VALUES '|| P_REQUEST_REC.PARAM7 , 3 ) ;
2406: END IF;
2407: p_x_old_line_rec.ship_from_org_id := p_request_rec.param7;
2408: p_x_old_line_rec.demand_class_code := p_request_rec.param8;
2409: p_x_old_line_rec.request_date := p_request_rec.date_param4;

Line 2423: oe_debug_pub.add( 'ASSIGN OVERRIDE FLAG' , 3 ) ;

2419: -- BUG 1282873
2420: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
2421:
2422: IF l_debug_level > 0 THEN
2423: oe_debug_pub.add( 'ASSIGN OVERRIDE FLAG' , 3 ) ;
2424: END IF;
2425: IF (p_x_line_rec.ato_line_id is not null AND
2426: NOT (p_x_line_rec.ato_line_id = p_x_line_rec.line_id AND
2427: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)) THEN

Line 2449: oe_debug_pub.add( 'OVERRIDE_ATP_DATE_CODE :' || P_X_LINE_REC.OVERRIDE_ATP_DATE_CODE || P_X_LINE_REC.LINE_ID , 3 ) ;

2445: Null;
2446:
2447: END;
2448: IF l_debug_level > 0 THEN
2449: oe_debug_pub.add( 'OVERRIDE_ATP_DATE_CODE :' || P_X_LINE_REC.OVERRIDE_ATP_DATE_CODE || P_X_LINE_REC.LINE_ID , 3 ) ;
2450: END IF;
2451:
2452: ELSIF NVL(p_request_rec.param11,'N') = 'Y' THEN
2453:

Line 2481: oe_debug_pub.add( '2 OVERRIDE_ATP_DATE_CODE :' || P_X_LINE_REC.OVERRIDE_ATP_DATE_CODE , 3 ) ;

2477:
2478: END;
2479:
2480: IF l_debug_level > 0 THEN
2481: oe_debug_pub.add( '2 OVERRIDE_ATP_DATE_CODE :' || P_X_LINE_REC.OVERRIDE_ATP_DATE_CODE , 3 ) ;
2482: END IF;
2483:
2484: ELSIF p_x_line_rec.link_to_line_id = p_request_rec.entity_id
2485: AND nvl(p_request_rec.param11,'N') = 'Y' THEN

Line 2496: oe_debug_pub.add( 'LEAVING VALIDATE_AND_ASSIGN_SCH_PARAMS' , 3 ) ;

2492: END IF; -- Check for Pack I
2493: -- END 1282873
2494:
2495: IF l_debug_level > 0 THEN
2496: oe_debug_pub.add( 'LEAVING VALIDATE_AND_ASSIGN_SCH_PARAMS' , 3 ) ;
2497: END IF;
2498:
2499: EXCEPTION
2500: WHEN OTHERS THEN

Line 2502: oe_debug_pub.add( 'ERROR VALIDATE_AND_ASSIGN_SCH_PARAMS '|| SQLERRM , 1 ) ;

2498:
2499: EXCEPTION
2500: WHEN OTHERS THEN
2501: IF l_debug_level > 0 THEN
2502: oe_debug_pub.add( 'ERROR VALIDATE_AND_ASSIGN_SCH_PARAMS '|| SQLERRM , 1 ) ;
2503: END IF;
2504: RAISE;
2505: END Validate_And_Assign_Sch_Params;
2506:

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

2540: l_po_NeedByDate_Update VARCHAR2(10); -- Added for IR ISO CMS project
2541: l_return_status VARCHAR2(1); -- Added for IR ISO CMS project
2542:
2543: --
2544: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2545: --
2546: BEGIN
2547: IF l_debug_level > 0 THEN
2548: oe_debug_pub.add( 'ENTERING SAVE_SCH '|| P_X_LINE_TBL.COUNT , 1 ) ;

Line 2548: oe_debug_pub.add( 'ENTERING SAVE_SCH '|| P_X_LINE_TBL.COUNT , 1 ) ;

2544: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2545: --
2546: BEGIN
2547: IF l_debug_level > 0 THEN
2548: oe_debug_pub.add( 'ENTERING SAVE_SCH '|| P_X_LINE_TBL.COUNT , 1 ) ;
2549: END IF;
2550:
2551: x_return_status := FND_API.G_RET_STS_SUCCESS;
2552:

Line 2564: oe_debug_pub.add( 'OPERATION IS NONE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2560: LOOP
2561:
2562: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_NONE THEN
2563: IF l_debug_level > 0 THEN
2564: oe_debug_pub.add( 'OPERATION IS NONE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2565: END IF;
2566: goto end_of_loop;
2567: END IF;
2568:

Line 2580: oe_debug_pub.add( 'GET THE OLD DATA' , 3 ) ;

2576: END IF;
2577:
2578:
2579: IF l_debug_level > 0 THEN
2580: oe_debug_pub.add( 'GET THE OLD DATA' , 3 ) ;
2581: END IF;
2582:
2583: l_orig_old_line_rec := p_old_line_tbl(I) ; --3144917
2584:

Line 2616: oe_debug_pub.add( 'LINE IS CLOSED '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2612:
2613: IF p_x_line_tbl(I).open_flag = 'N' THEN
2614:
2615: IF l_debug_level > 0 THEN
2616: oe_debug_pub.add( 'LINE IS CLOSED '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2617: END IF;
2618: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;

Line 2620: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;

2616: oe_debug_pub.add( 'LINE IS CLOSED '||P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2617: END IF;
2618: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2621: END IF;
2622: IF l_debug_level > 0 THEN
2623: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2624: END IF;

Line 2623: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;

2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2621: END IF;
2622: IF l_debug_level > 0 THEN
2623: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2624: END IF;
2625: goto direct_update;
2626: END IF;
2627:

Line 2630: oe_debug_pub.add( P_X_LINE_TBL ( I ) .REQUEST_DATE , 3 ) ;

2626: END IF;
2627:
2628:
2629: IF l_debug_level > 0 THEN
2630: oe_debug_pub.add( P_X_LINE_TBL ( I ) .REQUEST_DATE , 3 ) ;
2631: END IF;
2632: IF l_debug_level > 0 THEN
2633: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .REQUEST_DATE , 3 ) ;
2634: END IF;

Line 2633: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .REQUEST_DATE , 3 ) ;

2629: IF l_debug_level > 0 THEN
2630: oe_debug_pub.add( P_X_LINE_TBL ( I ) .REQUEST_DATE , 3 ) ;
2631: END IF;
2632: IF l_debug_level > 0 THEN
2633: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .REQUEST_DATE , 3 ) ;
2634: END IF;
2635: IF l_debug_level > 0 THEN
2636: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;
2637: END IF;

Line 2636: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;

2632: IF l_debug_level > 0 THEN
2633: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .REQUEST_DATE , 3 ) ;
2634: END IF;
2635: IF l_debug_level > 0 THEN
2636: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;
2637: END IF;
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;
2640: END IF;

Line 2639: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;

2635: IF l_debug_level > 0 THEN
2636: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;
2637: END IF;
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;
2640: END IF;
2641: IF l_debug_level > 0 THEN
2642: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;
2643: END IF;

Line 2642: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;

2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 3 ) ;
2640: END IF;
2641: IF l_debug_level > 0 THEN
2642: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;
2643: END IF;
2644: IF l_debug_level > 0 THEN
2645: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;
2646: END IF;

Line 2645: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;

2641: IF l_debug_level > 0 THEN
2642: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;
2643: END IF;
2644: IF l_debug_level > 0 THEN
2645: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;
2646: END IF;
2647: IF l_debug_level > 0 THEN
2648: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;
2649: END IF;

Line 2648: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;

2644: IF l_debug_level > 0 THEN
2645: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SCHEDULE_ARRIVAL_DATE , 3 ) ;
2646: END IF;
2647: IF l_debug_level > 0 THEN
2648: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;
2649: END IF;
2650: IF l_debug_level > 0 THEN
2651: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;
2652: END IF;

Line 2651: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;

2647: IF l_debug_level > 0 THEN
2648: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;
2649: END IF;
2650: IF l_debug_level > 0 THEN
2651: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;
2652: END IF;
2653: IF l_debug_level > 0 THEN
2654: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;
2655: END IF;

Line 2654: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;

2650: IF l_debug_level > 0 THEN
2651: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_FROM_ORG_ID , 3 ) ;
2652: END IF;
2653: IF l_debug_level > 0 THEN
2654: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;
2655: END IF;
2656: IF l_debug_level > 0 THEN
2657: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;
2658: END IF;

Line 2657: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;

2653: IF l_debug_level > 0 THEN
2654: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;
2655: END IF;
2656: IF l_debug_level > 0 THEN
2657: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;
2658: END IF;
2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2661: END IF;

Line 2660: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;

2656: IF l_debug_level > 0 THEN
2657: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIP_TO_ORG_ID , 3 ) ;
2658: END IF;
2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2661: END IF;
2662: IF l_debug_level > 0 THEN
2663: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2664: END IF;

Line 2663: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;

2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add( P_X_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2661: END IF;
2662: IF l_debug_level > 0 THEN
2663: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2664: END IF;
2665: IF l_debug_level > 0 THEN
2666: oe_debug_pub.add( P_X_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;
2667: END IF;

Line 2666: oe_debug_pub.add( P_X_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;

2662: IF l_debug_level > 0 THEN
2663: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .SHIPPING_METHOD_CODE , 3 ) ;
2664: END IF;
2665: IF l_debug_level > 0 THEN
2666: oe_debug_pub.add( P_X_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;
2667: END IF;
2668: IF l_debug_level > 0 THEN
2669: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;
2670: END IF;

Line 2669: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;

2665: IF l_debug_level > 0 THEN
2666: oe_debug_pub.add( P_X_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;
2667: END IF;
2668: IF l_debug_level > 0 THEN
2669: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;
2670: END IF;
2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add(P_X_LINE_TBL( I ).Earliest_Ship_Date , 3 ) ;
2673: END IF;

Line 2672: oe_debug_pub.add(P_X_LINE_TBL( I ).Earliest_Ship_Date , 3 ) ;

2668: IF l_debug_level > 0 THEN
2669: oe_debug_pub.add( P_OLD_LINE_TBL ( I ) .DEMAND_CLASS_CODE , 3 ) ;
2670: END IF;
2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add(P_X_LINE_TBL( I ).Earliest_Ship_Date , 3 ) ;
2673: END IF;
2674: IF l_debug_level > 0 THEN
2675: oe_debug_pub.add(P_X_LINE_TBL( I ).Firm_Demand_Flag , 3 ) ;
2676: END IF;

Line 2675: oe_debug_pub.add(P_X_LINE_TBL( I ).Firm_Demand_Flag , 3 ) ;

2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add(P_X_LINE_TBL( I ).Earliest_Ship_Date , 3 ) ;
2673: END IF;
2674: IF l_debug_level > 0 THEN
2675: oe_debug_pub.add(P_X_LINE_TBL( I ).Firm_Demand_Flag , 3 ) ;
2676: END IF;
2677:
2678:
2679: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

Line 2711: oe_debug_pub.add( 'THERE IS A CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2707: NOT OE_GLOBALS.Equal(p_x_line_tbl(I).inventory_item_id,
2708: p_old_line_tbl(I).inventory_item_id)
2709: THEN
2710: IF l_debug_level > 0 THEN
2711: oe_debug_pub.add( 'THERE IS A CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2712: END IF;
2713: ELSE
2714: IF l_debug_level > 0 THEN
2715: oe_debug_pub.add( 'NO CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

Line 2715: oe_debug_pub.add( 'NO CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2711: oe_debug_pub.add( 'THERE IS A CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2712: END IF;
2713: ELSE
2714: IF l_debug_level > 0 THEN
2715: oe_debug_pub.add( 'NO CHANGE '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2716: END IF;
2717: p_x_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
2718: goto direct_update;
2719: END IF;

Line 2731: oe_debug_pub.add( 'operation action ' || oe_line_security.g_operation_action , 1 ) ;

2727: ,p_old_line_rec => p_old_line_tbl(I)
2728: ,x_direct_update => l_direct_update);
2729:
2730: IF l_debug_level > 0 THEN
2731: oe_debug_pub.add( 'operation action ' || oe_line_security.g_operation_action , 1 ) ;
2732: END IF;
2733:
2734: IF oe_line_security.g_operation_action is not null THEN
2735: l_call_po := 'Y';

Line 2754: oe_debug_pub.add( 'CLEAR MODEL CACHE: '||P_X_LINE_TBL ( I ) .LINE_ID , 1 ) ;

2750:
2751: IF p_x_line_tbl(I).top_model_line_id = p_x_line_tbl(I).line_id
2752: THEN
2753: IF l_debug_level > 0 THEN
2754: oe_debug_pub.add( 'CLEAR MODEL CACHE: '||P_X_LINE_TBL ( I ) .LINE_ID , 1 ) ;
2755: END IF;
2756: OE_Order_Cache.Clear_Top_Model_Line
2757: (p_key => p_x_line_tbl(I).line_id);
2758: END IF;

Line 2767: oe_debug_pub.add( 'MAY UPDATE RESERN '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;

2763:
2764: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
2765:
2766: IF l_debug_level > 0 THEN
2767: oe_debug_pub.add( 'MAY UPDATE RESERN '|| P_X_LINE_TBL ( I ) .LINE_ID , 3 ) ;
2768: END IF;
2769: Update_Reservation
2770: ( p_line_rec => p_x_line_tbl(I)
2771: ,p_old_line_rec => l_orig_old_line_rec --3144917

Line 2786: oe_debug_pub.add( 'PASSING SCHEDULE_ARRIVAL_DATE TO PO ' , 3 ) ;

2782: p_old_line_tbl(I).schedule_arrival_date)
2783:
2784: THEN
2785: IF l_debug_level > 0 THEN
2786: oe_debug_pub.add( 'PASSING SCHEDULE_ARRIVAL_DATE TO PO ' , 3 ) ;
2787: END IF;
2788:
2789: -- Bug ##7576948: For IR ISO CMS Project
2790: -- The below code is commented for IR ISO project because we no more

Line 2885: oe_debug_pub.add(' Need By Date update is allowed ? '||l_po_NeedByDate_Update);

2881:
2882: l_po_NeedByDate_Update := NVL(FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM'),'NO');
2883:
2884: IF l_debug_level > 0 THEN
2885: oe_debug_pub.add(' Need By Date update is allowed ? '||l_po_NeedByDate_Update);
2886: END IF;
2887:
2888: IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req
2889: AND NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL THEN -- AND

Line 2922: oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);

2918:
2919:
2920: ELSE -- Added for IR ISO Tracking bug 7667702
2921: IF l_debug_level > 0 THEN
2922: oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);
2923: END IF;
2924:
2925: OE_SCHEDULE_UTIL.Update_PO(p_x_line_tbl(I).schedule_arrival_date,
2926: p_x_line_tbl(I).source_document_id,

Line 2936: oe_debug_pub.add( 'AFTER PO CALL BACK' , 3 ) ;

2932: /* ============================= */
2933: /* IR ISO Change Management Ends */
2934:
2935: IF l_debug_level > 0 THEN
2936: oe_debug_pub.add( 'AFTER PO CALL BACK' , 3 ) ;
2937: END IF;
2938: END IF;
2939:
2940: I := p_x_line_tbl.NEXT(I);

Line 2945: oe_debug_pub.add( '------- DONE WITH DIRECT UPDATES IF ANY' , 1 ) ;

2941:
2942: END LOOP;
2943:
2944: IF l_debug_level > 0 THEN
2945: oe_debug_pub.add( '------- DONE WITH DIRECT UPDATES IF ANY' , 1 ) ;
2946: END IF;
2947:
2948: ------------------- call process order -------------------
2949:

Line 2999: oe_debug_pub.add( 'PRN RETURN_STATUS ' || X_RETURN_STATUS , 1 ) ;

2995: ,p_old_line_tbl => p_old_line_tbl
2996: ,x_return_status => x_return_status);
2997:
2998: IF l_debug_level > 0 THEN
2999: oe_debug_pub.add( 'PRN RETURN_STATUS ' || X_RETURN_STATUS , 1 ) ;
3000: END IF;
3001:
3002: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3011: oe_debug_pub.add( 'LEAVING SAVE_SCH_ATTRIBURES' , 1 ) ;

3007:
3008: END IF;
3009:
3010: IF l_debug_level > 0 THEN
3011: oe_debug_pub.add( 'LEAVING SAVE_SCH_ATTRIBURES' , 1 ) ;
3012: END IF;
3013: EXCEPTION
3014: WHEN OTHERS THEN
3015: IF l_debug_level > 0 THEN

Line 3016: oe_debug_pub.add( 'ERROR SAVE_SCH_ATTRIBUTES '|| SQLERRM , 1 ) ;

3012: END IF;
3013: EXCEPTION
3014: WHEN OTHERS THEN
3015: IF l_debug_level > 0 THEN
3016: oe_debug_pub.add( 'ERROR SAVE_SCH_ATTRIBUTES '|| SQLERRM , 1 ) ;
3017: END IF;
3018: RAISE;
3019: END Save_Sch_Attributes;
3020:

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

3034: l_sec_result NUMBER;
3035: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
3036: l_return_status VARCHAR2(1);
3037: --
3038: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3039: --
3040: BEGIN
3041:
3042: IF l_debug_level > 0 THEN

Line 3043: oe_debug_pub.add( 'ENTERING SECURITY_AND_DEFAULTING ' , 2 ) ;

3039: --
3040: BEGIN
3041:
3042: IF l_debug_level > 0 THEN
3043: oe_debug_pub.add( 'ENTERING SECURITY_AND_DEFAULTING ' , 2 ) ;
3044: END IF;
3045:
3046: x_direct_update := 'N';
3047:

Line 3063: oe_debug_pub.add( 'AFTER SECURITY CALL' || L_RETURN_STATUS , 1 ) ;

3059: END IF;
3060:
3061: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3062: IF l_debug_level > 0 THEN
3063: oe_debug_pub.add( 'AFTER SECURITY CALL' || L_RETURN_STATUS , 1 ) ;
3064: END IF;
3065:
3066: -- if operation on any attribute is constrained
3067: IF l_sec_result = OE_PC_GLOBALS.YES THEN

Line 3069: oe_debug_pub.add( 'CONSTRAINT FOUND' , 4 ) ;

3065:
3066: -- if operation on any attribute is constrained
3067: IF l_sec_result = OE_PC_GLOBALS.YES THEN
3068: IF l_debug_level > 0 THEN
3069: oe_debug_pub.add( 'CONSTRAINT FOUND' , 4 ) ;
3070: END IF;
3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF;
3073:

Line 3084: oe_debug_pub.add( 'SHIP FROM/TO/ITEM CHANGED ON LINE CALL PO' , 1 ) ;

3080: p_old_line_rec.inventory_item_id)
3081:
3082: THEN
3083: IF l_debug_level > 0 THEN
3084: oe_debug_pub.add( 'SHIP FROM/TO/ITEM CHANGED ON LINE CALL PO' , 1 ) ;
3085: END IF;
3086: ELSE
3087: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
3088:

Line 3090: oe_debug_pub.add( 'OLD SHIP :' || P_OLD_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;

3086: ELSE
3087: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
3088:
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'OLD SHIP :' || P_OLD_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3091: END IF;
3092: IF l_debug_level > 0 THEN
3093: oe_debug_pub.add( 'NEW SHIP :' || P_X_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3094: END IF;

Line 3093: oe_debug_pub.add( 'NEW SHIP :' || P_X_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;

3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'OLD SHIP :' || P_OLD_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3091: END IF;
3092: IF l_debug_level > 0 THEN
3093: oe_debug_pub.add( 'NEW SHIP :' || P_X_LINE_REC.SCHEDULE_SHIP_DATE , 1 ) ;
3094: END IF;
3095:
3096: IF NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_ship_date,
3097: p_old_line_rec.schedule_ship_date)

Line 3101: oe_debug_pub.add( 'SHIP_DATE HAS CHANGED ON THE LINE' , 1 ) ;

3097: p_old_line_rec.schedule_ship_date)
3098: THEN
3099:
3100: IF l_debug_level > 0 THEN
3101: oe_debug_pub.add( 'SHIP_DATE HAS CHANGED ON THE LINE' , 1 ) ;
3102: END IF;
3103:
3104: l_src_attr_tbl(1) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
3105:

Line 3112: oe_debug_pub.add( 'DEFAULT ' || OE_GLOBALS.G_ATTR_UPDATED_BY_DEF , 1 ) ;

3108: p_x_line_rec => p_x_line_rec,
3109: p_old_line_rec => p_old_line_rec);
3110:
3111: IF l_debug_level > 0 THEN
3112: oe_debug_pub.add( 'DEFAULT ' || OE_GLOBALS.G_ATTR_UPDATED_BY_DEF , 1 ) ;
3113: END IF;
3114:
3115: IF OE_GLOBALS.G_ATTR_UPDATED_BY_DEF = 'N' THEN
3116: x_direct_update := 'Y';

Line 3123: oe_debug_pub.add( '------LEAVING SECURITY/DEF '|| X_DIRECT_UPDATE , 1 ) ;

3119: END IF;
3120: END IF; -- ship from/ship to change
3121:
3122: IF l_debug_level > 0 THEN
3123: oe_debug_pub.add( '------LEAVING SECURITY/DEF '|| X_DIRECT_UPDATE , 1 ) ;
3124: END IF;
3125: EXCEPTION
3126: WHEN OTHERS THEN
3127: IF l_debug_level > 0 THEN

Line 3128: oe_debug_pub.add( 'CALL_SECURITY_AND_DEFAULTING '|| SQLERRM , 1 ) ;

3124: END IF;
3125: EXCEPTION
3126: WHEN OTHERS THEN
3127: IF l_debug_level > 0 THEN
3128: oe_debug_pub.add( 'CALL_SECURITY_AND_DEFAULTING '|| SQLERRM , 1 ) ;
3129: END IF;
3130: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3131: RAISE;
3132: END Call_Security_And_Defaulting;

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

3143: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
3144: l_return_status VARCHAR2(1);
3145: l_index NUMBER;
3146: --
3147: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3148: --
3149: BEGIN
3150:
3151: IF l_debug_level > 0 THEN

Line 3152: oe_debug_pub.add( 'ENTERING HANDLE_DIRECT_UPDATE' , 1 ) ;

3148: --
3149: BEGIN
3150:
3151: IF l_debug_level > 0 THEN
3152: oe_debug_pub.add( 'ENTERING HANDLE_DIRECT_UPDATE' , 1 ) ;
3153: END IF;
3154:
3155: OE_MSG_PUB.set_msg_context
3156: ( p_entity_code => 'LINE'

Line 3177: oe_debug_pub.add( 'AFTER LOG_SCHEDULING REQS' || L_RETURN_STATUS , 1 ) ;

3173: ,p_order_type_id => l_order_type_id
3174: ,x_return_status => l_return_status);
3175:
3176: IF l_debug_level > 0 THEN
3177: oe_debug_pub.add( 'AFTER LOG_SCHEDULING REQS' || L_RETURN_STATUS , 1 ) ;
3178: END IF;
3179:
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3187: oe_debug_pub.add( 'BEFORE DOING DIRECT UPDATE' , 1 ) ;

3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;
3185:
3186: IF l_debug_level > 0 THEN
3187: oe_debug_pub.add( 'BEFORE DOING DIRECT UPDATE' , 1 ) ;
3188: END IF;
3189:
3190: IF NOT OE_SCHEDULE_UTIL.validate_ship_method
3191: (p_x_line_rec.shipping_method_code,

Line 3252: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || L_RETURN_STATUS ) ;

3248: p_line_id => p_x_line_rec.line_id,
3249: x_index => l_index,
3250: x_return_status => l_return_status);
3251: IF l_debug_level > 0 THEN
3252: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || L_RETURN_STATUS ) ;
3253: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
3254: END IF;
3255:
3256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3253: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;

3249: x_index => l_index,
3250: x_return_status => l_return_status);
3251: IF l_debug_level > 0 THEN
3252: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || L_RETURN_STATUS ) ;
3253: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
3254: END IF;
3255:
3256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3257: IF l_debug_level > 0 THEN

Line 3258: oe_debug_pub.add( 'RR: UNEXP ERRORED OUT' , 1 ) ;

3254: END IF;
3255:
3256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3257: IF l_debug_level > 0 THEN
3258: oe_debug_pub.add( 'RR: UNEXP ERRORED OUT' , 1 ) ;
3259: END IF;
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: IF l_debug_level > 0 THEN

Line 3263: oe_debug_pub.add( 'RR: ERRORED OUT' , 1 ) ;

3259: END IF;
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'RR: ERRORED OUT' , 1 ) ;
3264: END IF;
3265: RAISE FND_API.G_EXC_ERROR;
3266: END IF;
3267: IF l_index is not NULL THEN

Line 3283: oe_debug_pub.add( 'GLOBAL SHIP_FROM_ORG_ID IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .SHIP_FROM_ORG_ID , 1 ) ;

3279: OE_ORDER_UTIL.g_line_tbl(l_index).last_updated_by := p_x_line_rec.last_updated_by;
3280: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_login := p_x_line_rec.last_update_login;
3281: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control := p_x_line_rec.lock_control;
3282: IF l_debug_level > 0 THEN
3283: oe_debug_pub.add( 'GLOBAL SHIP_FROM_ORG_ID IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .SHIP_FROM_ORG_ID , 1 ) ;
3284: END IF;
3285: END IF; /*l_index is not null check*/
3286: END IF; /*code_release_level*/
3287:

Line 3289: oe_debug_pub.add( 'LEAVING HANDLE DIRECT UPDATE' , 1 ) ;

3285: END IF; /*l_index is not null check*/
3286: END IF; /*code_release_level*/
3287:
3288: IF l_debug_level > 0 THEN
3289: oe_debug_pub.add( 'LEAVING HANDLE DIRECT UPDATE' , 1 ) ;
3290: END IF;
3291:
3292: EXCEPTION
3293: WHEN OTHERS THEN

Line 3295: oe_debug_pub.add( 'HANDLE_DIRECT_UPDATE ERROR '|| SQLERRM , 1 ) ;

3291:
3292: EXCEPTION
3293: WHEN OTHERS THEN
3294: IF l_debug_level > 0 THEN
3295: oe_debug_pub.add( 'HANDLE_DIRECT_UPDATE ERROR '|| SQLERRM , 1 ) ;
3296: END IF;
3297: RAISE;
3298: END Handle_Direct_Update;
3299:

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

3321: l_error_code NUMBER;
3322: l_count NUMBER;
3323: I NUMBER;
3324: --
3325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3326: --
3327: BEGIN
3328: Print_Time('entering Update_Reservation');
3329:

Line 3339: oe_debug_pub.add( 'NO NEED TO UPDATE OR NO RESERVN' , 3 ) ;

3335: p_line_rec.reserved_quantity <= 0 OR
3336: p_line_rec.ordered_quantity = 0
3337: THEN
3338: IF l_debug_level > 0 THEN
3339: oe_debug_pub.add( 'NO NEED TO UPDATE OR NO RESERVN' , 3 ) ;
3340: END IF;
3341: RETURN;
3342: END IF;
3343:

Line 3354: oe_debug_pub.add( 'RSCH: CALLING INVS QUERY_RESERVATION ' , 1 ) ;

3350: l_rsv_rec.demand_source_line_id := p_line_rec.line_id;
3351: l_rsv_rec.organization_id := p_line_rec.ship_from_org_id;
3352:
3353: IF l_debug_level > 0 THEN
3354: oe_debug_pub.add( 'RSCH: CALLING INVS QUERY_RESERVATION ' , 1 ) ;
3355: END IF;
3356:
3357: Inv_Reservation_Pub.Query_Reservation
3358: ( p_api_version_number => 1.0

Line 3371: oe_debug_pub.add( 'AFTER INVS QUERY_RESERVATION: ' || X_RETURN_STATUS , 1 ) ;

3367: , p_lock_records => l_lock_records
3368: , p_sort_by_req_date => l_sort_by_req_date );
3369:
3370: IF l_debug_level > 0 THEN
3371: oe_debug_pub.add( 'AFTER INVS QUERY_RESERVATION: ' || X_RETURN_STATUS , 1 ) ;
3372: END IF;
3373:
3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3381: oe_debug_pub.add( 'RESERVATION REC COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;

3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;
3379:
3380: IF l_debug_level > 0 THEN
3381: oe_debug_pub.add( 'RESERVATION REC COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
3382: END IF;
3383:
3384: I := l_rsv_tbl.FIRST;
3385: WHILE I is not NULL

Line 3392: oe_debug_pub.add( 'RSCH: CALLING UPDATE RESERVATION '|| I , 1 ) ;

3388: l_rsv_rec := l_rsv_tbl(I);
3389: l_rsv_rec.requirement_date := p_line_rec.schedule_ship_date;
3390:
3391: IF l_debug_level > 0 THEN
3392: oe_debug_pub.add( 'RSCH: CALLING UPDATE RESERVATION '|| I , 1 ) ;
3393: END IF;
3394:
3395: Inv_Reservation_Pub.Update_Reservation
3396: ( p_api_version_number => 1.0

Line 3409: oe_debug_pub.add( 'AFTER UPDATE_RESERVATION: '||X_RETURN_STATUS , 1 ) ;

3405: , p_validation_flag => fnd_api.g_true
3406: , p_over_reservation_flag => 2 ); -- Added this for 4715544
3407:
3408: IF l_debug_level > 0 THEN
3409: oe_debug_pub.add( 'AFTER UPDATE_RESERVATION: '||X_RETURN_STATUS , 1 ) ;
3410: END IF;
3411:
3412: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3436: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;

3432: fnd_message.set_encoded(l_msg_data);
3433: l_buffer := fnd_message.get;
3434: oe_msg_pub.add_text(p_message_text => l_buffer);
3435: IF l_debug_level > 0 THEN
3436: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;
3437: END IF;
3438: END IF;
3439: RAISE FND_API.G_EXC_ERROR;
3440: END IF;

Line 3448: oe_debug_pub.add( 'UPDATE_RESERVATION ERROR '|| SQLERRM , 1 ) ;

3444:
3445: EXCEPTION
3446: WHEN OTHERS THEN
3447: IF l_debug_level > 0 THEN
3448: oe_debug_pub.add( 'UPDATE_RESERVATION ERROR '|| SQLERRM , 1 ) ;
3449: END IF;
3450: RAISE;
3451: END Update_Reservation;
3452:

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

3500: OR (arrival_set_id = p_arrival_set_id)
3501: OR (line_id = p_link_to_line_id));
3502:
3503: --
3504: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3505: --
3506: BEGIN
3507: Print_Time('Entering Query_Set_Lines '|| p_sch_action);
3508:

Line 3517: oe_debug_pub.add( 'INCORRECT IN PARAMETERS' , 1 ) ;

3513: p_arrival_set_id <> FND_API.G_MISS_NUM OR
3514: p_model_line_id <> FND_API.G_MISS_NUM )
3515: THEN
3516: IF l_debug_level > 0 THEN
3517: oe_debug_pub.add( 'INCORRECT IN PARAMETERS' , 1 ) ;
3518: END IF;
3519: RAISE FND_API.G_EXC_ERROR;
3520: END IF;
3521:

Line 3533: oe_debug_pub.add( 'CHECK IF II ITEMS REQ.' , 3 ) ;

3529: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3530: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
3531:
3532: IF l_debug_level > 0 THEN
3533: oe_debug_pub.add( 'CHECK IF II ITEMS REQ.' , 3 ) ;
3534: END IF;
3535:
3536: FOR parentrec in inc_parents
3537: LOOP

Line 3539: oe_debug_pub.add( 'CALL II_ITEMS'|| PARENTREC.LINE_ID , 3 ) ;

3535:
3536: FOR parentrec in inc_parents
3537: LOOP
3538: IF l_debug_level > 0 THEN
3539: oe_debug_pub.add( 'CALL II_ITEMS'|| PARENTREC.LINE_ID , 3 ) ;
3540: END IF;
3541: l_return_status := OE_CONFIG_UTIL.Process_Included_Items
3542: (p_line_id => parentrec.line_id,
3543: p_freeze => FALSE);

Line 3560: oe_debug_pub.add( 'ARRIVAL SET ID '|| P_ARRIVAL_SET_ID , 3 ) ;

3556:
3557:
3558: IF p_arrival_set_id <> FND_API.G_MISS_NUM THEN
3559: IF l_debug_level > 0 THEN
3560: oe_debug_pub.add( 'ARRIVAL SET ID '|| P_ARRIVAL_SET_ID , 3 ) ;
3561: END IF;
3562:
3563: OE_Set_Util.Query_Set_Rows
3564: (p_set_id => p_arrival_set_id,

Line 3569: oe_debug_pub.add( 'SHIP SET ID '|| P_SHIP_SET_ID , 3 ) ;

3565: x_line_tbl => x_line_tbl);
3566:
3567: ELSIF p_ship_set_id <> FND_API.G_MISS_NUM THEN
3568: IF l_debug_level > 0 THEN
3569: oe_debug_pub.add( 'SHIP SET ID '|| P_SHIP_SET_ID , 3 ) ;
3570: END IF;
3571:
3572: OE_Set_Util.Query_Set_Rows
3573: (p_set_id => p_ship_set_id,

Line 3578: oe_debug_pub.add( 'P_TOP_MODEL_LINE_ID '|| P_MODEL_LINE_ID , 3 ) ;

3574: x_line_tbl => x_line_tbl);
3575:
3576: ELSIF p_model_line_id <> FND_API.G_MISS_NUM THEN
3577: IF l_debug_level > 0 THEN
3578: oe_debug_pub.add( 'P_TOP_MODEL_LINE_ID '|| P_MODEL_LINE_ID , 3 ) ;
3579: END IF;
3580:
3581: OE_Config_Util.Query_Options
3582: (p_top_model_line_id => p_model_line_id,

Line 3589: oe_debug_pub.add( 'P_LINK_TO_LINE_ID '|| P_LINK_TO_LINE_ID , 3 ) ;

3585: x_line_tbl => x_line_tbl);
3586:
3587: ELSIF p_link_to_line_id <> FND_API.G_MISS_NUM THEN
3588: IF l_debug_level > 0 THEN
3589: oe_debug_pub.add( 'P_LINK_TO_LINE_ID '|| P_LINK_TO_LINE_ID , 3 ) ;
3590: END IF;
3591:
3592: OE_Config_Util.Query_Included_Items
3593: (p_line_id => p_link_to_line_id,

Line 3602: oe_debug_pub.add( 'NO. OF LINES '|| X_LINE_TBL.COUNT , 3 ) ;

3598: END IF;
3599:
3600: IF x_line_tbl.count > 0 THEN
3601: IF l_debug_level > 0 THEN
3602: oe_debug_pub.add( 'NO. OF LINES '|| X_LINE_TBL.COUNT , 3 ) ;
3603: END IF;
3604: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3605: (p_header_id);
3606: END IF;

Line 3642: oe_debug_pub.add( 'LINE '|| X_LINE_TBL ( I ) .LINE_ID , 4 ) ;

3638: THEN
3639: x_line_tbl(I).reserved_quantity := 0;
3640: ELSE
3641: IF l_debug_level > 0 THEN
3642: oe_debug_pub.add( 'LINE '|| X_LINE_TBL ( I ) .LINE_ID , 4 ) ;
3643: END IF;
3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add( 'RES QTY '|| X_LINE_TBL ( I ) .RESERVED_QUANTITY , 4 ) ;
3646: END IF;

Line 3645: oe_debug_pub.add( 'RES QTY '|| X_LINE_TBL ( I ) .RESERVED_QUANTITY , 4 ) ;

3641: IF l_debug_level > 0 THEN
3642: oe_debug_pub.add( 'LINE '|| X_LINE_TBL ( I ) .LINE_ID , 4 ) ;
3643: END IF;
3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add( 'RES QTY '|| X_LINE_TBL ( I ) .RESERVED_QUANTITY , 4 ) ;
3646: END IF;
3647: END IF;
3648:
3649: IF x_line_tbl(I).reserved_quantity2 is NULL OR -- INVCONV

Line 3655: oe_debug_pub.add( 'LINE '|| X_LINE_TBL ( I ) .LINE_ID , 4 ) ;

3651: THEN
3652: x_line_tbl(I).reserved_quantity2 := 0;
3653: ELSE
3654: IF l_debug_level > 0 THEN
3655: oe_debug_pub.add( 'LINE '|| X_LINE_TBL ( I ) .LINE_ID , 4 ) ;
3656: END IF;
3657: IF l_debug_level > 0 THEN
3658: oe_debug_pub.add( 'RES QTY2 '|| X_LINE_TBL ( I ) .RESERVED_QUANTITY2 , 4 ) ;
3659: END IF;

Line 3658: oe_debug_pub.add( 'RES QTY2 '|| X_LINE_TBL ( I ) .RESERVED_QUANTITY2 , 4 ) ;

3654: IF l_debug_level > 0 THEN
3655: oe_debug_pub.add( 'LINE '|| X_LINE_TBL ( I ) .LINE_ID , 4 ) ;
3656: END IF;
3657: IF l_debug_level > 0 THEN
3658: oe_debug_pub.add( 'RES QTY2 '|| X_LINE_TBL ( I ) .RESERVED_QUANTITY2 , 4 ) ;
3659: END IF;
3660: END IF;
3661:
3662: I := x_line_tbl.NEXT(I);

Line 3673: oe_debug_pub.add( 'EXC ERROR IN Query_Set_Lines' , 1 ) ;

3669: WHEN FND_API.G_EXC_ERROR THEN
3670: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3671: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3672: IF l_debug_level > 0 THEN
3673: oe_debug_pub.add( 'EXC ERROR IN Query_Set_Lines' , 1 ) ;
3674: END IF;
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676:
3677: WHEN OTHERS THEN

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

3701: ,p_sch_attibs IN VARCHAR2 := 'N'
3702: ,x_line_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Rec_Type)
3703: IS
3704: --
3705: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3706: --
3707: BEGIN
3708: IF l_debug_level > 0 THEN
3709: oe_debug_pub.add( 'QUERY CA LINE_ID '|| P_LINE_ID , 1 ) ;

Line 3709: oe_debug_pub.add( 'QUERY CA LINE_ID '|| P_LINE_ID , 1 ) ;

3705: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3706: --
3707: BEGIN
3708: IF l_debug_level > 0 THEN
3709: oe_debug_pub.add( 'QUERY CA LINE_ID '|| P_LINE_ID , 1 ) ;
3710: END IF;
3711: SELECT ATO_LINE_ID
3712: ,BOOKED_FLAG
3713: ,COMPONENT_CODE

Line 3771: oe_debug_pub.add( 'ERROR IN QUERY_CONFIG_ATTRIBUTES '|| SQLERRM , 2 ) ;

3767: WHERE LINE_ID = P_LINE_ID;
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: IF l_debug_level > 0 THEN
3771: oe_debug_pub.add( 'ERROR IN QUERY_CONFIG_ATTRIBUTES '|| SQLERRM , 2 ) ;
3772: END IF;
3773: RAISE;
3774: END Query_Config_Attributes;
3775:

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

3806: IS
3807: l_return_status VARCHAR2(1);
3808: l_num_id NUMBER;
3809: --
3810: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3811: --
3812: BEGIN
3813: IF l_debug_level > 0 THEN
3814: oe_debug_pub.add( 'ENTERING VALIDATE_GROUP_REQUEST' , 1 ) ;

Line 3814: oe_debug_pub.add( 'ENTERING VALIDATE_GROUP_REQUEST' , 1 ) ;

3810: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3811: --
3812: BEGIN
3813: IF l_debug_level > 0 THEN
3814: oe_debug_pub.add( 'ENTERING VALIDATE_GROUP_REQUEST' , 1 ) ;
3815: END IF;
3816:
3817: OE_MSG_PUB.set_msg_context
3818: ( p_entity_code => 'LINE'

Line 3867: oe_debug_pub.add( 'LEAVING VALIDATE_GROUP_REQUEST' , 1 ) ;

3863: END IF;
3864:
3865:
3866: IF l_debug_level > 0 THEN
3867: oe_debug_pub.add( 'LEAVING VALIDATE_GROUP_REQUEST' , 1 ) ;
3868: END IF;
3869: END Validate_Group_Request;
3870:
3871:

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

3877: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
3878: ,x_atp_rec OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
3879: IS
3880: --
3881: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3882: --
3883: BEGIN
3884: IF l_debug_level > 0 THEN
3885: oe_debug_pub.add( 'ENTERING CALL_ATP' , 1 ) ;

Line 3885: oe_debug_pub.add( 'ENTERING CALL_ATP' , 1 ) ;

3881: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3882: --
3883: BEGIN
3884: IF l_debug_level > 0 THEN
3885: oe_debug_pub.add( 'ENTERING CALL_ATP' , 1 ) ;
3886: END IF;
3887:
3888: x_atp_rec := p_atp_rec;
3889:

Line 3899: oe_debug_pub.add( 'LEAVING CALL_ATP' , 1 ) ;

3895: x_atp_rec.Source_Organization_ID(I) := 204;
3896: END LOOP;
3897:
3898: IF l_debug_level > 0 THEN
3899: oe_debug_pub.add( 'LEAVING CALL_ATP' , 1 ) ;
3900: END IF;
3901: EXCEPTION
3902: WHEN OTHERS THEN
3903: IF l_debug_level > 0 THEN

Line 3904: oe_debug_pub.add( 'ERROR IN CALL ATP '|| SQLERRM , 1 ) ;

3900: END IF;
3901: EXCEPTION
3902: WHEN OTHERS THEN
3903: IF l_debug_level > 0 THEN
3904: oe_debug_pub.add( 'ERROR IN CALL ATP '|| SQLERRM , 1 ) ;
3905: END IF;
3906: RAISE;
3907: END;
3908:

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

3923: ,x_result OUT NOCOPY /* file.sql.39 change */ NUMBER)
3924: IS
3925: l_unscheduled_line VARCHAR2(1) := 'N';
3926: --
3927: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3928: --
3929: BEGIN
3930:
3931: IF p_caller = 'UI_ACTION' THEN

Line 3949: oe_debug_pub.add( 'MULTI GRP '|| X_RESULT , 3 ) ;

3945: x_result := 1;
3946: END IF;
3947:
3948: IF l_debug_level > 0 THEN
3949: oe_debug_pub.add( 'MULTI GRP '|| X_RESULT , 3 ) ;
3950: END IF;
3951:
3952: ELSE
3953: IF p_line_tbl(p_line_tbl.FIRST).schedule_status_code is NULL

Line 3956: oe_debug_pub.add( 'NOT SCHEDULED SINGLE GRP' , 3 ) ;

3952: ELSE
3953: IF p_line_tbl(p_line_tbl.FIRST).schedule_status_code is NULL
3954: THEN
3955: IF l_debug_level > 0 THEN
3956: oe_debug_pub.add( 'NOT SCHEDULED SINGLE GRP' , 3 ) ;
3957: END IF;
3958: x_result := 0;
3959: ELSE
3960: IF l_debug_level > 0 THEN

Line 3961: oe_debug_pub.add( 'SCHEDULED SINGLE GRP' , 3 ) ;

3957: END IF;
3958: x_result := 0;
3959: ELSE
3960: IF l_debug_level > 0 THEN
3961: oe_debug_pub.add( 'SCHEDULED SINGLE GRP' , 3 ) ;
3962: END IF;
3963: x_result := 2;
3964: END IF;
3965: END IF;

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

3975: PROCEDURE Print_Time(p_msg IN VARCHAR2)
3976: IS
3977: l_time VARCHAR2(100);
3978: --
3979: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3980: --
3981: BEGIN
3982: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
3983: 'DD-MON-YY HH24:MI:SS');

Line 3985: oe_debug_pub.add( P_MSG || ': '|| L_TIME , 1 ) ;

3981: BEGIN
3982: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
3983: 'DD-MON-YY HH24:MI:SS');
3984: IF l_debug_level > 0 THEN
3985: oe_debug_pub.add( P_MSG || ': '|| L_TIME , 1 ) ;
3986: END IF;
3987: END Print_Time;
3988:
3989: