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.CTO_WIP_WRAPPER dependencies on OE_DEBUG_PUB

Line 27: | Replaced fnd_file calls with oe_debug_pub |

23: | August 14, 99 Angela Makalintal Initial version |
24: | February 26, 01 Shashi Bhaskaran bugfix 1642355 |
25: | May 7, 01 Sajani Sheth Support for partial FAS |
26: | June 16, 01 Shashi Bhaskaran bugfix 1835357 |
27: | Replaced fnd_file calls with oe_debug_pub |
28: | August 16,2001 Kiran Konada, fix for bug#1874380 |
29: | to support ATO item under a PTO. |
30: | item_type_code for an ato item under PTO |
31: | is 'OPTION' and top_model_line_id will NOT be|

Line 183: oe_debug_pub.add ('unlock_line_id: ' || 'unlocked line_id '||p_line_id);

179: AND oel.program_id = -99;
180:
181: IF (sql%rowcount > 0) THEN
182: IF (PG_DEBUG <> 0) THEN
183: oe_debug_pub.add ('unlock_line_id: ' || 'unlocked line_id '||p_line_id);
184: END IF;
185: END IF;
186:
187: EXCEPTION

Line 191: OE_DEBUG_PUB.add ('unlock_line_id: error: ' || sqlerrm);

187: EXCEPTION
188:
189: when others then
190: IF PG_DEBUG <> 0 THEN
191: OE_DEBUG_PUB.add ('unlock_line_id: error: ' || sqlerrm);
192:
193: END IF;
194:
195: END UnLock_Line_Id;

Line 336: oe_debug_pub.add('get_order_lines: ' || 'Begin Get Order Lines.', 1);

332: Select Eligible Records based on parameters and workflow status.
333: ****************************************************************/
334:
335: IF PG_DEBUG <> 0 THEN
336: oe_debug_pub.add('get_order_lines: ' || 'Begin Get Order Lines.', 1);
337:
338: oe_debug_pub.add('get_order_lines: ' || 'Organization ID: '||to_char(p_org_id), 1);
339:
340: oe_debug_pub.add('get_order_lines: ' || 'Offset: '||to_char(p_offset_days), 1);

Line 338: oe_debug_pub.add('get_order_lines: ' || 'Organization ID: '||to_char(p_org_id), 1);

334:
335: IF PG_DEBUG <> 0 THEN
336: oe_debug_pub.add('get_order_lines: ' || 'Begin Get Order Lines.', 1);
337:
338: oe_debug_pub.add('get_order_lines: ' || 'Organization ID: '||to_char(p_org_id), 1);
339:
340: oe_debug_pub.add('get_order_lines: ' || 'Offset: '||to_char(p_offset_days), 1);
341:
342: oe_debug_pub.add('get_order_lines: ' || 'Load Type: '||to_char(p_load_type), 1);

Line 340: oe_debug_pub.add('get_order_lines: ' || 'Offset: '||to_char(p_offset_days), 1);

336: oe_debug_pub.add('get_order_lines: ' || 'Begin Get Order Lines.', 1);
337:
338: oe_debug_pub.add('get_order_lines: ' || 'Organization ID: '||to_char(p_org_id), 1);
339:
340: oe_debug_pub.add('get_order_lines: ' || 'Offset: '||to_char(p_offset_days), 1);
341:
342: oe_debug_pub.add('get_order_lines: ' || 'Load Type: '||to_char(p_load_type), 1);
343:
344: oe_debug_pub.add('get_order_lines: ' || 'Class Code: '||p_class_code, 1);

Line 342: oe_debug_pub.add('get_order_lines: ' || 'Load Type: '||to_char(p_load_type), 1);

338: oe_debug_pub.add('get_order_lines: ' || 'Organization ID: '||to_char(p_org_id), 1);
339:
340: oe_debug_pub.add('get_order_lines: ' || 'Offset: '||to_char(p_offset_days), 1);
341:
342: oe_debug_pub.add('get_order_lines: ' || 'Load Type: '||to_char(p_load_type), 1);
343:
344: oe_debug_pub.add('get_order_lines: ' || 'Class Code: '||p_class_code, 1);
345:
346: oe_debug_pub.add('get_order_lines: ' || 'Status Type: '||to_char(p_status_type), 1);

Line 344: oe_debug_pub.add('get_order_lines: ' || 'Class Code: '||p_class_code, 1);

340: oe_debug_pub.add('get_order_lines: ' || 'Offset: '||to_char(p_offset_days), 1);
341:
342: oe_debug_pub.add('get_order_lines: ' || 'Load Type: '||to_char(p_load_type), 1);
343:
344: oe_debug_pub.add('get_order_lines: ' || 'Class Code: '||p_class_code, 1);
345:
346: oe_debug_pub.add('get_order_lines: ' || 'Status Type: '||to_char(p_status_type), 1);
347:
348: oe_debug_pub.add('get_order_lines: ' || 'Order Number: '||to_char(p_order_number), 1);

Line 346: oe_debug_pub.add('get_order_lines: ' || 'Status Type: '||to_char(p_status_type), 1);

342: oe_debug_pub.add('get_order_lines: ' || 'Load Type: '||to_char(p_load_type), 1);
343:
344: oe_debug_pub.add('get_order_lines: ' || 'Class Code: '||p_class_code, 1);
345:
346: oe_debug_pub.add('get_order_lines: ' || 'Status Type: '||to_char(p_status_type), 1);
347:
348: oe_debug_pub.add('get_order_lines: ' || 'Order Number: '||to_char(p_order_number), 1);
349:
350: oe_debug_pub.add('get_order_lines: ' || 'Line ID: ' ||to_char(p_line_id), 1);

Line 348: oe_debug_pub.add('get_order_lines: ' || 'Order Number: '||to_char(p_order_number), 1);

344: oe_debug_pub.add('get_order_lines: ' || 'Class Code: '||p_class_code, 1);
345:
346: oe_debug_pub.add('get_order_lines: ' || 'Status Type: '||to_char(p_status_type), 1);
347:
348: oe_debug_pub.add('get_order_lines: ' || 'Order Number: '||to_char(p_order_number), 1);
349:
350: oe_debug_pub.add('get_order_lines: ' || 'Line ID: ' ||to_char(p_line_id), 1);
351: END IF;
352:

Line 350: oe_debug_pub.add('get_order_lines: ' || 'Line ID: ' ||to_char(p_line_id), 1);

346: oe_debug_pub.add('get_order_lines: ' || 'Status Type: '||to_char(p_status_type), 1);
347:
348: oe_debug_pub.add('get_order_lines: ' || 'Order Number: '||to_char(p_order_number), 1);
349:
350: oe_debug_pub.add('get_order_lines: ' || 'Line ID: ' ||to_char(p_line_id), 1);
351: END IF;
352:
353: x_wip_seq := -1;
354: x_orders_loaded := 0;

Line 377: oe_debug_pub.add('get_order_lines: ' || 'initialized Offset to null : '||to_char(l_offset_days), 1);

373: if p_offset_days = -10000 then
374: l_offset_days := null ;
375:
376: IF PG_DEBUG <> 0 THEN
377: oe_debug_pub.add('get_order_lines: ' || 'initialized Offset to null : '||to_char(l_offset_days), 1);
378: END IF;
379:
380: else
381: l_offset_days := p_offset_days ;

Line 581: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));

577: sql_stmt := sql_stmt ||
578: 'order by oel.org_id, oel.line_id';
579:
580: IF PG_DEBUG <> 0 THEN
581: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));
582: oe_debug_pub.add (substr(sql_stmt,1501,3000));
583: oe_debug_pub.add ('drive_mark = '||drive_mark );
584: END IF;
585:

Line 582: oe_debug_pub.add (substr(sql_stmt,1501,3000));

578: 'order by oel.org_id, oel.line_id';
579:
580: IF PG_DEBUG <> 0 THEN
581: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));
582: oe_debug_pub.add (substr(sql_stmt,1501,3000));
583: oe_debug_pub.add ('drive_mark = '||drive_mark );
584: END IF;
585:
586: /*

Line 583: oe_debug_pub.add ('drive_mark = '||drive_mark );

579:
580: IF PG_DEBUG <> 0 THEN
581: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));
582: oe_debug_pub.add (substr(sql_stmt,1501,3000));
583: oe_debug_pub.add ('drive_mark = '||drive_mark );
584: END IF;
585:
586: /*
587: Below, we execute the sql statement according to which parameters

Line 658: oe_debug_pub.add ('INCORRECT COMBINATION of parameters');

654: Open WorkOrder FOR sql_stmt USING l_order_number, l_line_id, l_line_id, l_line_id, l_org_id, p_offset_days;
655:
656: else
657: IF PG_DEBUG <> 0 THEN
658: oe_debug_pub.add ('INCORRECT COMBINATION of parameters');
659: END IF;
660:
661: end if;
662:

Line 666: oe_debug_pub.add ('Opened. System Time : '||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

662:
663: -- End Bugfix 4056151: End of Dynamic SQL creation
664:
665: IF PG_DEBUG <> 0 THEN
666: oe_debug_pub.add ('Opened. System Time : '||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
667: END IF;
668:
669:
670: -- begin bugfix 3014000

Line 676: oe_debug_pub.add('get_order_lines: '|| 'MO:operating Unit :' || lOperUnit, 2);

672: -- Deriving the current org using MO GLOBAL API
673: lOperUnit := nvl(MO_GLOBAL.get_current_org_id,-99);
674:
675: IF PG_DEBUG <> 0 THEN
676: oe_debug_pub.add('get_order_lines: '|| 'MO:operating Unit :' || lOperUnit, 2);
677: END IF;
678: -- end bugfix 3014000
679:
680: --

Line 697: oe_debug_pub.add ('Fetched. System Time : '||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

693: LOOP
694: FETCH WorkOrder INTO WorkOrder_Rec;
695: EXIT WHEN WorkOrder%NOTFOUND;
696: IF PG_DEBUG <> 0 THEN
697: oe_debug_pub.add ('Fetched. System Time : '||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
698: END IF;
699: -- begin bugfix 3014000: Moved the debug stmt here
700:
701: IF PG_DEBUG <> 0 THEN

Line 702: oe_debug_pub.add('----------------------------------------', 5);

698: END IF;
699: -- begin bugfix 3014000: Moved the debug stmt here
700:
701: IF PG_DEBUG <> 0 THEN
702: oe_debug_pub.add('----------------------------------------', 5);
703: oe_debug_pub.add('Processing line_id: '||WorkOrder_Rec.line_id, 5);
704: oe_debug_pub.add('----------------------------------------', 5);
705: END IF;
706:

Line 703: oe_debug_pub.add('Processing line_id: '||WorkOrder_Rec.line_id, 5);

699: -- begin bugfix 3014000: Moved the debug stmt here
700:
701: IF PG_DEBUG <> 0 THEN
702: oe_debug_pub.add('----------------------------------------', 5);
703: oe_debug_pub.add('Processing line_id: '||WorkOrder_Rec.line_id, 5);
704: oe_debug_pub.add('----------------------------------------', 5);
705: END IF;
706:
707:

Line 704: oe_debug_pub.add('----------------------------------------', 5);

700:
701: IF PG_DEBUG <> 0 THEN
702: oe_debug_pub.add('----------------------------------------', 5);
703: oe_debug_pub.add('Processing line_id: '||WorkOrder_Rec.line_id, 5);
704: oe_debug_pub.add('----------------------------------------', 5);
705: END IF;
706:
707:
708: --

Line 736: oe_debug_pub.add('get_order_lines: '|| 'Setting the Org Context to '||WorkOrder_Rec.org_id ||

732: -- begin bugfix 3014000
733: -- commenting out... : FND_CLIENT_INFO.Set_Org_Context ( WorkOrder_Rec.org_id );
734:
735: IF PG_DEBUG <> 0 THEN
736: oe_debug_pub.add('get_order_lines: '|| 'Setting the Org Context to '||WorkOrder_Rec.org_id ||
737: ' by calling OE_Order_Context_GRP.Set_Created_By_Context.', 5);
738: END IF;
739:
740: OE_Order_Context_GRP.Set_Created_By_Context (

Line 752: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');

748: ,x_msg_data => l_x_msg_data );
749:
750: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
751: IF PG_DEBUG <> 0 THEN
752: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');
753: END IF;
754: raise FND_API.G_EXC_ERROR;
755:
756: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 758: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');

754: raise FND_API.G_EXC_ERROR;
755:
756: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: IF PG_DEBUG <> 0 THEN
758: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');
759: END IF;
760: raise FND_API.G_EXC_UNEXPECTED_ERROR;
761:
762: end if;

Line 765: oe_debug_pub.add('get_order_lines: '|| 'NOT Setting the Org Context since MO:Operating Unit = OEL.org_id.', 5);

761:
762: end if;
763: else
764: IF PG_DEBUG <> 0 THEN
765: oe_debug_pub.add('get_order_lines: '|| 'NOT Setting the Org Context since MO:Operating Unit = OEL.org_id.', 5);
766: END IF;
767: end if;
768: -- end bugfix 3014000
769:

Line 811: oe_debug_pub.add('get_order_lines: ' || 'get_notinv_qty() - get_reserved_qty() <= 0.',2);

807: -- line has to be atomic. So commenting out the following part.
808: /*if ( GET_NOTINV_QTY(WorkOrder_Rec.line_id) - GET_RESERVED_QTY(WorkOrder_Rec.line_id) <= 0 )
809: then
810: IF PG_DEBUG <> 0 THEN
811: oe_debug_pub.add('get_order_lines: ' || 'get_notinv_qty() - get_reserved_qty() <= 0.',2);
812:
813: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||
814: ') is not eligible for creation of workorder.',2);
815: END IF;

Line 813: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||

809: then
810: IF PG_DEBUG <> 0 THEN
811: oe_debug_pub.add('get_order_lines: ' || 'get_notinv_qty() - get_reserved_qty() <= 0.',2);
812:
813: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||
814: ') is not eligible for creation of workorder.',2);
815: END IF;
816: goto end_of_loop;
817: end if;

Line 827: oe_debug_pub.add('get_order_lines: ' || 'check_wip_supply_type() returned a value not in (0,1). ',2);

823: p_so_delivery => NULL,
824: p_org_id => WorkOrder_Rec.ship_from_org_id) not in (0,1)
825: then
826: IF PG_DEBUG <> 0 THEN
827: oe_debug_pub.add('get_order_lines: ' || 'check_wip_supply_type() returned a value not in (0,1). ',2);
828:
829: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||
830: ') is not eligible for creation of workorder.', 2);
831: END IF;

Line 829: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||

825: then
826: IF PG_DEBUG <> 0 THEN
827: oe_debug_pub.add('get_order_lines: ' || 'check_wip_supply_type() returned a value not in (0,1). ',2);
828:
829: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||
830: ') is not eligible for creation of workorder.', 2);
831: END IF;
832: goto end_of_loop;
833: end if;

Line 842: oe_debug_pub.add('get_order_lines: ' || 'Looking the sourcing information...',1);

838: -- bug 6146803: Move this line to after obtaining the lock.
839: --l_rows_selected := l_rows_selected + 1;
840:
841: IF PG_DEBUG <> 0 THEN
842: oe_debug_pub.add('get_order_lines: ' || 'Looking the sourcing information...',1);
843: END IF;
844:
845: l_stmt_num := 2;
846:

Line 861: OE_DEBUG_PUB.add ('get_order_lines: ' || 'Could not lock line id '|| to_char(WorkOrder_Rec.line_id) ||' for update.');

857: l_inventory_item_id := WorkOrder_Rec.inventory_item_id;
858: exception
859: WHEN record_locked THEN
860: IF PG_DEBUG <> 0 THEN
861: OE_DEBUG_PUB.add ('get_order_lines: ' || 'Could not lock line id '|| to_char(WorkOrder_Rec.line_id) ||' for update.');
862:
863: OE_DEBUG_PUB.add ('get_order_lines: ' || 'This line is being processed by another process.',1);
864: END IF;
865: goto end_of_loop;

Line 863: OE_DEBUG_PUB.add ('get_order_lines: ' || 'This line is being processed by another process.',1);

859: WHEN record_locked THEN
860: IF PG_DEBUG <> 0 THEN
861: OE_DEBUG_PUB.add ('get_order_lines: ' || 'Could not lock line id '|| to_char(WorkOrder_Rec.line_id) ||' for update.');
862:
863: OE_DEBUG_PUB.add ('get_order_lines: ' || 'This line is being processed by another process.',1);
864: END IF;
865: goto end_of_loop;
866: -- bugfix 2420381: added the excpn for better handling of error.
867:

Line 871: oe_debug_pub.add('get_order_lines: ' || 'get_notinv_qty() - get_reserved_qty() <= 0.',2);

867:
868: -- Bug 6146803: No data found shall happen if GET_NOTINV_QTY - GET_RESERVED_QTY <= 0
869: WHEN NO_DATA_FOUND THEN
870: IF PG_DEBUG <> 0 THEN
871: oe_debug_pub.add('get_order_lines: ' || 'get_notinv_qty() - get_reserved_qty() <= 0.',2);
872:
873: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||
874: ') is not eligible for creation of workorder.',2);
875: END IF;

Line 873: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||

869: WHEN NO_DATA_FOUND THEN
870: IF PG_DEBUG <> 0 THEN
871: oe_debug_pub.add('get_order_lines: ' || 'get_notinv_qty() - get_reserved_qty() <= 0.',2);
872:
873: oe_debug_pub.add('get_order_lines: ' || 'This line ('||WorkOrder_Rec.line_id||
874: ') is not eligible for creation of workorder.',2);
875: END IF;
876: goto end_of_loop;
877:

Line 880: oe_debug_pub.add('get_order_lines: ' || 'others exception while locking line '||WorkOrder_Rec.line_id||':'||sqlerrm,1);

876: goto end_of_loop;
877:
878: WHEN others THEN
879: IF PG_DEBUG <> 0 THEN
880: oe_debug_pub.add('get_order_lines: ' || 'others exception while locking line '||WorkOrder_Rec.line_id||':'||sqlerrm,1);
881: END IF;
882: goto end_of_loop;
883: end;
884:

Line 889: oe_debug_pub.add('get_order_lines: ' || 'successfully locked line '|| WorkOrder_Rec.line_id);

885: l_rows_selected := l_rows_selected + 1; --Bugfix 6146803
886:
887: /* bugfix 3136206: added the following debug stmt */
888: IF PG_DEBUG <> 0 THEN
889: oe_debug_pub.add('get_order_lines: ' || 'successfully locked line '|| WorkOrder_Rec.line_id);
890: END IF;
891:
892: l_stmt_num := 3;
893:

Line 913: oe_debug_pub.add('get_order_lines: ' || 'Return status from Query_sourcing_org = '||l_x_return_status,1);

909: X_message =>l_message --declare
910: );
911:
912: IF PG_DEBUG <> 0 THEN
913: oe_debug_pub.add('get_order_lines: ' || 'Return status from Query_sourcing_org = '||l_x_return_status,1);
914: END IF;
915:
916: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
917:

Line 921: oe_debug_pub.add('get_order_lines: ' ||l_message,1);

917:
918: IF l_can_create_supply = 'N' THEN --opm
919: IF PG_DEBUG <> 0 THEN
920: --would identify if line is skipped becuase of custom hook
921: oe_debug_pub.add('get_order_lines: ' ||l_message,1);
922: END IF;
923:
924: IF nvl(l_source_type,1) = 66 THEN --Kiran Konada
925: IF PG_DEBUG <> 0 THEN

Line 926: oe_debug_pub.add('get_order_lines: ' || 'Multiple sourcing defined for this item in this org...Supply will be created by planning. ',1);

922: END IF;
923:
924: IF nvl(l_source_type,1) = 66 THEN --Kiran Konada
925: IF PG_DEBUG <> 0 THEN
926: oe_debug_pub.add('get_order_lines: ' || 'Multiple sourcing defined for this item in this org...Supply will be created by planning. ',1);
927: END IF;
928: l_rows_errored := l_rows_errored + 1;
929: goto end_of_loop;
930: END IF;

Line 936: oe_debug_pub.add('get_order_lines: ' || 'Expected error occurred in Query_sourcing_org...',1);

932: END IF; --l_can_create_supply
933:
934: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
935: IF PG_DEBUG <> 0 THEN
936: oe_debug_pub.add('get_order_lines: ' || 'Expected error occurred in Query_sourcing_org...',1);
937: END IF;
938: l_rows_errored := l_rows_errored + 1;
939: -- we do not want to raise error here, since we want to process remaining lines
940: goto end_of_loop;

Line 944: oe_debug_pub.add('get_order_lines: ' || 'Unexpected error occurred in Query_sourcing_org procedure...',1);

940: goto end_of_loop;
941:
942: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: IF PG_DEBUG <> 0 THEN
944: oe_debug_pub.add('get_order_lines: ' || 'Unexpected error occurred in Query_sourcing_org procedure...',1);
945: END IF;
946: l_rows_errored := l_rows_errored + 1;
947: -- we do not want to raise error here, since we want to process remaining lines
948: goto end_of_loop;

Line 955: oe_debug_pub.add('get_order_lines: ' || 'It is a BUY configuration Need not process this...',1);

951: IF l_can_create_supply = 'Y' THEN --as part of OPM enhancement
952: if nvl(l_source_type,1) = 3
953: then
954: IF PG_DEBUG <> 0 THEN
955: oe_debug_pub.add('get_order_lines: ' || 'It is a BUY configuration Need not process this...',1);
956: END IF;
957: l_rows_selected := l_rows_selected - 1;
958:
959: -- Start 2681321: if the source type is TRANSFER FROM, we should not create a workorder

Line 963: oe_debug_pub.add('TRANSFER FROM sourcing rule exists. Work order need not be created.',1);

959: -- Start 2681321: if the source type is TRANSFER FROM, we should not create a workorder
960:
961: elsif nvl(l_source_type,2) = 1 then
962: IF PG_DEBUG <> 0 THEN
963: oe_debug_pub.add('TRANSFER FROM sourcing rule exists. Work order need not be created.',1);
964: END IF;
965: l_rows_selected := l_rows_selected - 1;
966:
967: -- End 2681321

Line 978: OE_DEBUG_PUB.add('get_order_lines: ' || 'Get_Order_lines: ' ||

974: from dual;
975: end if;
976:
977: IF PG_DEBUG <> 0 THEN
978: OE_DEBUG_PUB.add('get_order_lines: ' || 'Get_Order_lines: ' ||
979: ' Procesing Order Line ' ||
980: to_char(WorkOrder_Rec.line_id), 2);
981: END IF;
982:

Line 999: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Hold Check: ' || l_x_return_status ||

995:
996: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then
997:
998: IF PG_DEBUG <> 0 THEN
999: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Hold Check: ' || l_x_return_status ||
1000: ' For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1001:
1002: OE_DEBUG_PUB.add('get_order_lines: ' || 'Continuing with next line..',3);
1003: END IF;

Line 1002: OE_DEBUG_PUB.add('get_order_lines: ' || 'Continuing with next line..',3);

998: IF PG_DEBUG <> 0 THEN
999: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Hold Check: ' || l_x_return_status ||
1000: ' For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1001:
1002: OE_DEBUG_PUB.add('get_order_lines: ' || 'Continuing with next line..',3);
1003: END IF;
1004: else
1005:
1006: IF PG_DEBUG <> 0 THEN

Line 1007: OE_DEBUG_PUB.add('get_order_lines: ' || 'Success in Hold Check: ' || l_x_return_status ||

1003: END IF;
1004: else
1005:
1006: IF PG_DEBUG <> 0 THEN
1007: OE_DEBUG_PUB.add('get_order_lines: ' || 'Success in Hold Check: ' || l_x_return_status ||
1008: ' For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1009: END IF;
1010:
1011: if (l_x_hold_result_out = FND_API.G_TRUE) then

Line 1014: OE_DEBUG_PUB.add('get_order_lines: ' || 'Hold Found on order line ' || to_char(WorkOrder_Rec.line_id), 1);

1010:
1011: if (l_x_hold_result_out = FND_API.G_TRUE) then
1012:
1013: IF PG_DEBUG <> 0 THEN
1014: OE_DEBUG_PUB.add('get_order_lines: ' || 'Hold Found on order line ' || to_char(WorkOrder_Rec.line_id), 1);
1015:
1016: OE_DEBUG_PUB.add('get_order_lines: ' || 'Continuing with next line..',3);
1017: END IF;
1018:

Line 1016: OE_DEBUG_PUB.add('get_order_lines: ' || 'Continuing with next line..',3);

1012:
1013: IF PG_DEBUG <> 0 THEN
1014: OE_DEBUG_PUB.add('get_order_lines: ' || 'Hold Found on order line ' || to_char(WorkOrder_Rec.line_id), 1);
1015:
1016: OE_DEBUG_PUB.add('get_order_lines: ' || 'Continuing with next line..',3);
1017: END IF;
1018:
1019: l_rows_on_hold := l_rows_on_hold + 1;
1020:

Line 1027: OE_DEBUG_PUB.add('get_order_lines: ' || 'before dep plan',1);

1023: /* If Departure Planning is required, check if deliveries have been assigned and planned */
1024:
1025: BEGIN
1026: IF PG_DEBUG <> 0 THEN
1027: OE_DEBUG_PUB.add('get_order_lines: ' || 'before dep plan',1);
1028: END IF;
1029:
1030: l_stmt_num := 6;
1031:

Line 1038: OE_DEBUG_PUB.add('get_order_lines: ' || 'l_dep_plan_flag::'||l_dep_plan_flag, 2);

1034: from oe_order_lines_all oel
1035: where oel.line_id = WorkOrder_Rec.line_id;
1036:
1037: IF PG_DEBUG <> 0 THEN
1038: OE_DEBUG_PUB.add('get_order_lines: ' || 'l_dep_plan_flag::'||l_dep_plan_flag, 2);
1039: END IF;
1040:
1041: if l_dep_plan_flag = 'Y' then
1042:

Line 1059: OE_DEBUG_PUB.add('get_order_lines: ' ||

1055: x_msg_data => l_x_msg_data);
1056:
1057: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then
1058: IF PG_DEBUG <> 0 THEN
1059: OE_DEBUG_PUB.add('get_order_lines: ' ||
1060: 'Expected error in Delivery_Planned: '
1061: || l_x_return_status
1062: || ' For Order Line '
1063: ||to_char(WorkOrder_Rec.line_id), 1);

Line 1069: OE_DEBUG_PUB.add('get_order_lines: ' ||

1065: raise FND_API.G_EXC_ERROR;
1066:
1067: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1068: IF PG_DEBUG <> 0 THEN
1069: OE_DEBUG_PUB.add('get_order_lines: ' ||
1070: 'UnExpected error in Delivery_Planned: '
1071: || l_x_return_status
1072: || ' For Order Line '
1073: ||to_char(WorkOrder_Rec.line_id), 1);

Line 1079: OE_DEBUG_PUB.add('get_order_lines: ' ||

1075: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1076:
1077: else
1078: IF PG_DEBUG <> 0 THEN
1079: OE_DEBUG_PUB.add('get_order_lines: ' ||
1080: 'Success in Delivery_Planned: '
1081: || l_x_return_status
1082: || ' For Order Line '
1083: ||to_char(WorkOrder_Rec.line_id), 1);

Line 1088: OE_DEBUG_PUB.add('get_order_lines: ' ||

1084: END IF;
1085:
1086: if (l_x_result_out = FND_API.G_FALSE) then
1087: IF PG_DEBUG <> 0 THEN
1088: OE_DEBUG_PUB.add('get_order_lines: ' ||
1089: 'Order line not delivery planned'
1090: ||to_char(WorkOrder_Rec.line_id), 1);
1091: END IF;
1092:

Line 1119: oe_debug_pub.add('get_order_lines: ' || 'Insert Error Message: ' || l_x_error_message,1);

1115: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1116: -- We dont want to raise error here, since we want to process other lines.
1117:
1118: IF PG_DEBUG <> 0 THEN
1119: oe_debug_pub.add('get_order_lines: ' || 'Insert Error Message: ' || l_x_error_message,1);
1120:
1121: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Insert WIP Interface: ' || l_x_return_status ||
1122: 'For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1123: END IF;

Line 1121: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Insert WIP Interface: ' || l_x_return_status ||

1117:
1118: IF PG_DEBUG <> 0 THEN
1119: oe_debug_pub.add('get_order_lines: ' || 'Insert Error Message: ' || l_x_error_message,1);
1120:
1121: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Insert WIP Interface: ' || l_x_return_status ||
1122: 'For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1123: END IF;
1124:
1125: else

Line 1128: OE_DEBUG_PUB.add('get_order_lines: ' || 'Success in Insert WIP Interface: ' || l_x_return_status ||

1124:
1125: else
1126:
1127: IF PG_DEBUG <> 0 THEN
1128: OE_DEBUG_PUB.add('get_order_lines: ' || 'Success in Insert WIP Interface: ' || l_x_return_status ||
1129: 'For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1130: END IF;
1131:
1132: l_rows_inserted := l_rows_inserted + 1;

Line 1139: OE_DEBUG_PUB.add('get_order_lines: ' || 'Deliveries not planned, not inserting into wjsi', 2);

1135:
1136: EXCEPTION
1137: when NOT_PLANNED then
1138: IF PG_DEBUG <> 0 THEN
1139: OE_DEBUG_PUB.add('get_order_lines: ' || 'Deliveries not planned, not inserting into wjsi', 2);
1140: END IF;
1141:
1142: END; /*sub-block for delivery planned lines*/
1143:

Line 1157: oe_debug_pub.add('get_order_lines: ' || '****************************************', 5);

1153: null;
1154: end loop;
1155:
1156: IF PG_DEBUG <> 0 THEN
1157: oe_debug_pub.add('get_order_lines: ' || '****************************************', 5);
1158:
1159: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Selected: ' ||
1160: to_char(l_rows_selected), 1);
1161:

Line 1159: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Selected: ' ||

1155:
1156: IF PG_DEBUG <> 0 THEN
1157: oe_debug_pub.add('get_order_lines: ' || '****************************************', 5);
1158:
1159: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Selected: ' ||
1160: to_char(l_rows_selected), 1);
1161:
1162: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows on Hold: ' ||
1163: to_char(l_rows_on_hold), 1);

Line 1162: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows on Hold: ' ||

1158:
1159: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Selected: ' ||
1160: to_char(l_rows_selected), 1);
1161:
1162: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows on Hold: ' ||
1163: to_char(l_rows_on_hold), 1);
1164:
1165: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows not Departure Planned: ' ||
1166: to_char(l_rows_dep_plan), 1);

Line 1165: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows not Departure Planned: ' ||

1161:
1162: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows on Hold: ' ||
1163: to_char(l_rows_on_hold), 1);
1164:
1165: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows not Departure Planned: ' ||
1166: to_char(l_rows_dep_plan), 1);
1167:
1168: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows in error: ' ||
1169: to_char(l_rows_errored), 1);

Line 1168: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows in error: ' ||

1164:
1165: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows not Departure Planned: ' ||
1166: to_char(l_rows_dep_plan), 1);
1167:
1168: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows in error: ' ||
1169: to_char(l_rows_errored), 1);
1170:
1171: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Inserted: ' ||
1172: to_char(l_rows_inserted), 1);

Line 1171: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Inserted: ' ||

1167:
1168: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Rows in error: ' ||
1169: to_char(l_rows_errored), 1);
1170:
1171: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Inserted: ' ||
1172: to_char(l_rows_inserted), 1);
1173:
1174: OE_DEBUG_PUB.add('get_order_lines: ' || 'WIP Group ID: ' ||
1175: to_char(x_wip_seq), 1);

Line 1174: OE_DEBUG_PUB.add('get_order_lines: ' || 'WIP Group ID: ' ||

1170:
1171: OE_DEBUG_PUB.add('get_order_lines: ' || 'Number of Order Lines Inserted: ' ||
1172: to_char(l_rows_inserted), 1);
1173:
1174: OE_DEBUG_PUB.add('get_order_lines: ' || 'WIP Group ID: ' ||
1175: to_char(x_wip_seq), 1);
1176:
1177: oe_debug_pub.add('get_order_lines: ' || '****************************************', 5);
1178: END IF;

Line 1177: oe_debug_pub.add('get_order_lines: ' || '****************************************', 5);

1173:
1174: OE_DEBUG_PUB.add('get_order_lines: ' || 'WIP Group ID: ' ||
1175: to_char(x_wip_seq), 1);
1176:
1177: oe_debug_pub.add('get_order_lines: ' || '****************************************', 5);
1178: END IF;
1179:
1180: x_orders_loaded := l_rows_inserted;
1181:

Line 1194: oe_debug_pub.add ('get_order_lines: ' || 'CTOWIPWB.get_order_lines: Line '||l_line_id||

1190:
1191: if (l_line_id is not null AND x_orders_loaded = 0) then
1192:
1193: IF PG_DEBUG <> 0 THEN
1194: oe_debug_pub.add ('get_order_lines: ' || 'CTOWIPWB.get_order_lines: Line '||l_line_id||
1195: ' is NOT eligible for Autocreate FAS anymore.',1);
1196: END IF;
1197:
1198: -- Try to get the job info if it was created..

Line 1221: oe_debug_pub.add ('get_order_lines: ' || 'Info: A WIP job ( '||l_job_name||' ) was created for this line already.',1);

1217: and oel.ship_from_org_id = dj.organization_id ;--for using index wdj_u1
1218: --end bugfix 2885568
1219:
1220: IF PG_DEBUG <> 0 THEN
1221: oe_debug_pub.add ('get_order_lines: ' || 'Info: A WIP job ( '||l_job_name||' ) was created for this line already.',1);
1222: END IF;
1223:
1224: exception
1225: when no_data_found then

Line 1227: oe_debug_pub.add ('get_order_lines: ' || 'Could not find a WIP job. Records probably stuck in wip job schedule interface.',1);

1223:
1224: exception
1225: when no_data_found then
1226: IF PG_DEBUG <> 0 THEN
1227: oe_debug_pub.add ('get_order_lines: ' || 'Could not find a WIP job. Records probably stuck in wip job schedule interface.',1);
1228: END IF;
1229:
1230: when others then
1231: IF PG_DEBUG <> 0 THEN

Line 1232: oe_debug_pub.add ('get_order_lines: ' || 'Error while fetching the WIP job. : '||substr(sqlerrm,1,200),1);

1228: END IF;
1229:
1230: when others then
1231: IF PG_DEBUG <> 0 THEN
1232: oe_debug_pub.add ('get_order_lines: ' || 'Error while fetching the WIP job. : '||substr(sqlerrm,1,200),1);
1233:
1234: oe_debug_pub.add ('get_order_lines: ' || 'Continuing..',1);
1235: END IF;
1236: end;

Line 1234: oe_debug_pub.add ('get_order_lines: ' || 'Continuing..',1);

1230: when others then
1231: IF PG_DEBUG <> 0 THEN
1232: oe_debug_pub.add ('get_order_lines: ' || 'Error while fetching the WIP job. : '||substr(sqlerrm,1,200),1);
1233:
1234: oe_debug_pub.add ('get_order_lines: ' || 'Continuing..',1);
1235: END IF;
1236: end;
1237: --return 0; -- bugfix 2105156: no need to return an error
1238: end if;

Line 1247: OE_DEBUG_PUB.add ('get_order_lines: ' || 'Could not lock line id '|| to_char(p_line_id) ||' for update.',1);

1243: -- bugfix 2053360 : handle the record_locked exception.
1244:
1245: WHEN record_locked THEN
1246: IF PG_DEBUG <> 0 THEN
1247: OE_DEBUG_PUB.add ('get_order_lines: ' || 'Could not lock line id '|| to_char(p_line_id) ||' for update.',1);
1248:
1249: OE_DEBUG_PUB.add ('get_order_lines: ' || 'This line is being processed by another process.',1);
1250: END IF;
1251: unlock_line_id (p_line_id); -- bugfix 3136206

Line 1249: OE_DEBUG_PUB.add ('get_order_lines: ' || 'This line is being processed by another process.',1);

1245: WHEN record_locked THEN
1246: IF PG_DEBUG <> 0 THEN
1247: OE_DEBUG_PUB.add ('get_order_lines: ' || 'Could not lock line id '|| to_char(p_line_id) ||' for update.',1);
1248:
1249: OE_DEBUG_PUB.add ('get_order_lines: ' || 'This line is being processed by another process.',1);
1250: END IF;
1251: unlock_line_id (p_line_id); -- bugfix 3136206
1252: return 1; -- return success otherwise, w/f will be in retry mode ! --bugfix 2105156
1253:

Line 1257: OE_DEBUG_PUB.add('get_order_lines: ' || 'Expected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);

1253:
1254:
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: IF PG_DEBUG <> 0 THEN
1257: OE_DEBUG_PUB.add('get_order_lines: ' || 'Expected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);
1258: END IF;
1259: unlock_line_id (p_line_id); -- bugfix 3136206
1260: return 1; -- should not error out in case of excpected error
1261:

Line 1264: OE_DEBUG_PUB.add('get_order_lines: ' || 'Unxpected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);

1260: return 1; -- should not error out in case of excpected error
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: IF PG_DEBUG <> 0 THEN
1264: OE_DEBUG_PUB.add('get_order_lines: ' || 'Unxpected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);
1265: END IF;
1266: unlock_line_id (p_line_id); -- bugfix 3136206
1267: return 0;
1268:

Line 1271: OE_DEBUG_PUB.add('get_order_lines: ' || 'CTOWIPWB.get_order_lines :: No Rows Found.',1);

1267: return 0;
1268:
1269: WHEN NO_DATA_FOUND THEN
1270: IF PG_DEBUG <> 0 THEN
1271: OE_DEBUG_PUB.add('get_order_lines: ' || 'CTOWIPWB.get_order_lines :: No Rows Found.',1);
1272: END IF;
1273: -- bugfix 2420381: commented out the re-initialization of x_orders_loaded.
1274: -- x_orders_loaded := 0;
1275: unlock_line_id (p_line_id); -- bugfix 3136206

Line 1281: OE_DEBUG_PUB.add('get_order_lines: ' || 'Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||'):'||

1277:
1278:
1279: WHEN OTHERS THEN
1280: IF PG_DEBUG <> 0 THEN
1281: OE_DEBUG_PUB.add('get_order_lines: ' || 'Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||'):'||
1282: substrb(sqlerrm, 1, 150),1);
1283: END IF;
1284: unlock_line_id (p_line_id); -- bugfix 3136206
1285: return 0;

Line 1407: oe_debug_pub.add('reserve_wo_to_so: ' || 'Beginning Reservation Loop.',1);

1403: and msi.organization_id = oel.ship_from_org_id;
1404:
1405: BEGIN
1406: IF PG_DEBUG <> 0 THEN
1407: oe_debug_pub.add('reserve_wo_to_so: ' || 'Beginning Reservation Loop.',1);
1408: END IF;
1409: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');
1410: IF PG_DEBUG <> 0 THEN
1411: oe_debug_pub.add('reserve_wo_to_so: ' || 'lSourceCode: ' ||lSourceCode,2);

Line 1411: oe_debug_pub.add('reserve_wo_to_so: ' || 'lSourceCode: ' ||lSourceCode,2);

1407: oe_debug_pub.add('reserve_wo_to_so: ' || 'Beginning Reservation Loop.',1);
1408: END IF;
1409: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');
1410: IF PG_DEBUG <> 0 THEN
1411: oe_debug_pub.add('reserve_wo_to_so: ' || 'lSourceCode: ' ||lSourceCode,2);
1412: END IF;
1413:
1414: -- begin bugfix 3014000
1415:

Line 1420: oe_debug_pub.add('reserve_wo_to_so: '|| 'MO:operating Unit :' || lOperUnit, 2);

1416: -- Change for MOAC
1417: lOperUnit := nvl(MO_GLOBAL.get_current_org_id,-99);
1418: -- End of MOAC change
1419: IF PG_DEBUG <> 0 THEN
1420: oe_debug_pub.add('reserve_wo_to_so: '|| 'MO:operating Unit :' || lOperUnit, 2);
1421: END IF;
1422:
1423: -- end bugfix 3014000
1424:

Line 1441: oe_debug_pub.add('reserve_wo_to_so: '|| 'Setting the Org Context again to '||WorkOrder_Rec.org_id ||

1437: -- Caveat: Single org customers should NOT set the MO:Operating unit for the resp
1438: -- which is used to run autocreate FAS. If so, OM will defer the activity.
1439:
1440: IF PG_DEBUG <> 0 THEN
1441: oe_debug_pub.add('reserve_wo_to_so: '|| 'Setting the Org Context again to '||WorkOrder_Rec.org_id ||
1442: ' by calling OE_Order_Context_GRP.Set_Created_By_Context.', 5);
1443: END IF;
1444:
1445: OE_Order_Context_GRP.Set_Created_By_Context (

Line 1456: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');

1452: ,x_msg_count => l_x_msg_count
1453: ,x_msg_data => l_x_msg_data );
1454:
1455: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1456: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1457: raise FND_API.G_EXC_ERROR;
1458:
1459: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');

Line 1460: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');

1456: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1457: raise FND_API.G_EXC_ERROR;
1458:
1459: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');
1461: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1462:
1463: end if;
1464:

Line 1467: oe_debug_pub.add('reserve_wo_to_so: '|| 'NOT Setting the Org Context since MO:Operating Unit = OEL.org_id.', 5);

1463: end if;
1464:
1465: else
1466: IF PG_DEBUG <> 0 THEN
1467: oe_debug_pub.add('reserve_wo_to_so: '|| 'NOT Setting the Org Context since MO:Operating Unit = OEL.org_id.', 5);
1468: END IF;
1469: end if;
1470:
1471: lOperUnit := WorkOrder_Rec.org_id; -- OE api will set the mo oper unit in cache.

Line 1477: oe_debug_pub.add('reserve_wo_to_so: ' || 'ss::in loop::qty::'||WorkOrder_Rec.start_quantity,2);

1473:
1474: -- end bugfix 3014000
1475:
1476: IF PG_DEBUG <> 0 THEN
1477: oe_debug_pub.add('reserve_wo_to_so: ' || 'ss::in loop::qty::'||WorkOrder_Rec.start_quantity,2);
1478: END IF;
1479:
1480: l_rec_reserve.f_header_id := WorkOrder_Rec.sales_order_id;
1481: l_rec_reserve.f_line_id := WorkOrder_Rec.line_id;

Line 1499: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reserving Line ID ' ||

1495: If reservation is unsuccessful, purge discrete jobs created.
1496: +----------------------------------------------------------*/
1497:
1498: IF PG_DEBUG <> 0 THEN
1499: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reserving Line ID ' ||
1500: to_char(WorkOrder_Rec.line_id) ||
1501: 'to WIP Entitiy ID ' ||
1502: to_char(WorkOrder_Rec.wip_entity_id),2);
1503: END IF;

Line 1515: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Result: ' || l_status,1);

1511: x_msg_txt => l_msg_txt,
1512: x_msg_name => l_msg_name );
1513:
1514: IF PG_DEBUG <> 0 THEN
1515: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Result: ' || l_status,1);
1516:
1517: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Msg: ' || l_msg_txt,1);
1518: END IF;
1519:

Line 1517: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Msg: ' || l_msg_txt,1);

1513:
1514: IF PG_DEBUG <> 0 THEN
1515: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Result: ' || l_status,1);
1516:
1517: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Msg: ' || l_msg_txt,1);
1518: END IF;
1519:
1520: if (l_status <> FND_API.G_RET_STS_SUCCESS) then
1521: /*---------------------------------------------------+

Line 1530: oe_debug_pub.add('reserve_wo_to_so: ' ||

1526: made the process too complicated. Instead, we will
1527: cancel the work order created.
1528: +---------------------------------------------------*/
1529: IF PG_DEBUG <> 0 THEN
1530: oe_debug_pub.add('reserve_wo_to_so: ' ||
1531: 'Reservation FAILED for line id ' ||
1532: to_char(WorkOrder_Rec.line_id) ||
1533: ' and WIP Entity ID: ' ||
1534: to_char(WorkOrder_Rec.wip_entity_id) ||

Line 1537: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Text = '||l_msg_txt,1);

1533: ' and WIP Entity ID: ' ||
1534: to_char(WorkOrder_Rec.wip_entity_id) ||
1535: '.',1);
1536:
1537: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Text = '||l_msg_txt,1);
1538: END IF;
1539:
1540: l_stmt_num := 100;
1541: update wip_discrete_jobs

Line 1559: oe_debug_pub.add('reserve_wo_to_so: ' ||

1555: If the order is placed on hold during AutoCreate FAS,
1556: WIP will put the corresponding work order on hold.
1557: +--------------------------------------------------*/
1558: IF PG_DEBUG <> 0 THEN
1559: oe_debug_pub.add('reserve_wo_to_so: ' ||
1560: 'Reservation Success for line id ' ||
1561: to_char(WorkOrder_Rec.line_id) ||
1562: ' and WIP Entity ID: ' ||
1563: to_char(WorkOrder_Rec.wip_entity_id) ||

Line 1588: oe_debug_pub.add('reserve_wo_to_so: ' || 'Return Status from respond to change order ' || l_status,1);

1584: x_msg_count => l_msg_count,
1585: x_msg_data => l_msg_txt);
1586:
1587: IF PG_DEBUG <> 0 THEN
1588: oe_debug_pub.add('reserve_wo_to_so: ' || 'Return Status from respond to change order ' || l_status,1);
1589:
1590: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Txt from respond to change order: ' || l_msg_txt,2);
1591: END IF;
1592:

Line 1590: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Txt from respond to change order: ' || l_msg_txt,2);

1586:
1587: IF PG_DEBUG <> 0 THEN
1588: oe_debug_pub.add('reserve_wo_to_so: ' || 'Return Status from respond to change order ' || l_status,1);
1589:
1590: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Txt from respond to change order: ' || l_msg_txt,2);
1591: END IF;
1592:
1593: if (l_status <> FND_API.G_RET_STS_SUCCESS) then
1594:

Line 1596: oe_debug_pub.add('reserve_wo_to_so: ' ||

1592:
1593: if (l_status <> FND_API.G_RET_STS_SUCCESS) then
1594:
1595: IF PG_DEBUG <> 0 THEN
1596: oe_debug_pub.add('reserve_wo_to_so: ' ||
1597: 'Deleting Reservation for ' ||
1598: 'line ID: ' ||
1599: to_char(WorkOrder_Rec.line_id) ||
1600: 'to WIP Entity ID ' ||

Line 1618: oe_debug_pub.add('reserve_wo_to_so: ' || 'Return Status from delete reservation: ' || l_status,1);

1614: , p_serial_number => l_dummy_sn
1615: );
1616:
1617: IF PG_DEBUG <> 0 THEN
1618: oe_debug_pub.add('reserve_wo_to_so: ' || 'Return Status from delete reservation: ' || l_status,1);
1619:
1620: oe_debug_pub.add('reserve_wo_to_so: ' || 'Msg Txt from delete reservation: ' || l_msg_txt,1);
1621: END IF;
1622:

Line 1620: oe_debug_pub.add('reserve_wo_to_so: ' || 'Msg Txt from delete reservation: ' || l_msg_txt,1);

1616:
1617: IF PG_DEBUG <> 0 THEN
1618: oe_debug_pub.add('reserve_wo_to_so: ' || 'Return Status from delete reservation: ' || l_status,1);
1619:
1620: oe_debug_pub.add('reserve_wo_to_so: ' || 'Msg Txt from delete reservation: ' || l_msg_txt,1);
1621: END IF;
1622:
1623: l_stmt_num := 130;
1624: update wip_discrete_jobs

Line 1645: oe_debug_pub.add('reserve_wo_to_so: ' ||

1641: when NO_DATA_FOUND then
1642:
1643: if (l_stmt_num <> 115) then
1644: IF PG_DEBUG <> 0 THEN
1645: oe_debug_pub.add('reserve_wo_to_so: ' ||
1646: 'No data found in feedback loop. '
1647: || 'Statement: ' || to_char(l_stmt_num)
1648: || substrb(sqlerrm, 1, 150),1);
1649: END IF;

Line 1667: oe_debug_pub.add('Warning: No reservations made. Check for errors in WJSI');

1663: end loop; /* loop through wip job schedules for order line */
1664:
1665: -- begin bugfix 3136206
1666: if resv_counter = 0 then
1667: oe_debug_pub.add('Warning: No reservations made. Check for errors in WJSI');
1668: -- unlock the lines. Update the program_id to null.
1669: update oe_order_lines_all
1670: set program_id = null
1671: where program_id = -99

Line 1679: oe_debug_pub.add('reserve_wo_to_so: ' || 'End of Reservation',1);

1675: end if;
1676: -- end bugfix 3136206
1677:
1678: IF PG_DEBUG <> 0 THEN
1679: oe_debug_pub.add('reserve_wo_to_so: ' || 'End of Reservation',1);
1680: END IF;
1681:
1682: return 1;
1683:

Line 1688: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Expected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );

1684: EXCEPTION
1685:
1686: --begin bugfix 3014000
1687: WHEN FND_API.G_EXC_ERROR THEN
1688: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Expected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1689: unlock_line_id (lLineId); -- bugfix 3136206
1690: return 1; -- should not error out in case of excpected error
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1693: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Unxpected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );

1689: unlock_line_id (lLineId); -- bugfix 3136206
1690: return 1; -- should not error out in case of excpected error
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Unxpected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1694: unlock_line_id (lLineId); -- bugfix 3136206
1695: return 0;
1696:
1697: -- end bugfix 3014000

Line 1700: OE_DEBUG_PUB.ADD('reserve_wo_to_so: ' || 'Error in CTOWIPWB.reserve_wo_to_so: '

1696:
1697: -- end bugfix 3014000
1698:
1699: when NO_DATA_FOUND then
1700: OE_DEBUG_PUB.ADD('reserve_wo_to_so: ' || 'Error in CTOWIPWB.reserve_wo_to_so: '
1701: || 'Statement: ' || to_char(l_stmt_num)
1702: || substrb(sqlerrm, 1, 150),1);
1703: unlock_line_id (lLineId); -- bugfix 3136206
1704: return 0;

Line 1707: OE_DEBUG_PUB.add('reserve_wo_to_so: ' || 'Error in CTOWIPWB.reserve_wo_to_so: '

1703: unlock_line_id (lLineId); -- bugfix 3136206
1704: return 0;
1705:
1706: when OTHERS then
1707: OE_DEBUG_PUB.add('reserve_wo_to_so: ' || 'Error in CTOWIPWB.reserve_wo_to_so: '
1708: || substrb(sqlerrm, 1, 150),1);
1709:
1710: unlock_line_id (lLineId); -- bugfix 3136206
1711: return 0;

Line 1801: --oe_debug_pub.add('Entering Get_Reserved_Qty', 6);

1797: lStmtNum number := 0;
1798:
1799: BEGIN
1800:
1801: --oe_debug_pub.add('Entering Get_Reserved_Qty', 6);
1802:
1803: lStmtNum := 10;
1804: OPEN c_mtl_rsv_qty;
1805: FETCH c_mtl_rsv_qty INTO l_mtl_rsv_qty;

Line 1847: oe_debug_pub.add('Get_Reserved_Qty: ' || 'Others exception in Get_Reserved_Qty::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

1843:
1844: EXCEPTION
1845: WHEN others THEN
1846: IF PG_DEBUG <> 0 THEN
1847: oe_debug_pub.add('Get_Reserved_Qty: ' || 'Others exception in Get_Reserved_Qty::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1848: END IF;
1849: unlock_line_id (pLineId); -- bugfix 3136206
1850: return(0);
1851:

Line 1914: oe_debug_pub.add('Get_NotInv_Qty: ' || 'Others exception in Get_NotInv_Qty::'||sqlerrm, 1);

1910:
1911: EXCEPTION
1912: when OTHERS then
1913: IF PG_DEBUG <> 0 THEN
1914: oe_debug_pub.add('Get_NotInv_Qty: ' || 'Others exception in Get_NotInv_Qty::'||sqlerrm, 1);
1915: END IF;
1916: unlock_line_id (pLineId); -- bugfix 3136206
1917: return(0);
1918: END Get_NotInv_Qty;