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

Line 162: oe_debug_pub.add('insert_wip_interface: ' || 'Partial qty for WO creation (in primary UOM) : '||to_char(l_partial_qty), 2);

158: l_partial_qty := CTO_WIP_WRAPPER.Get_NotInv_Qty(p_line_id) - CTO_WIP_WRAPPER.Get_Reserved_Qty(p_line_id);
159:
160:
161: IF PG_DEBUG <> 0 THEN
162: oe_debug_pub.add('insert_wip_interface: ' || 'Partial qty for WO creation (in primary UOM) : '||to_char(l_partial_qty), 2);
163:
164: oe_debug_pub.add('insert_wip_interface: ' || 'Dep Plan Flag for line_id '||to_char(p_line_id)||' is '||lDepPlanFlag, 2);
165: END IF;
166:

Line 164: oe_debug_pub.add('insert_wip_interface: ' || 'Dep Plan Flag for line_id '||to_char(p_line_id)||' is '||lDepPlanFlag, 2);

160:
161: IF PG_DEBUG <> 0 THEN
162: oe_debug_pub.add('insert_wip_interface: ' || 'Partial qty for WO creation (in primary UOM) : '||to_char(l_partial_qty), 2);
163:
164: oe_debug_pub.add('insert_wip_interface: ' || 'Dep Plan Flag for line_id '||to_char(p_line_id)||' is '||lDepPlanFlag, 2);
165: END IF;
166:
167:
168: IF lDepPlanFlag = 'N' THEN

Line 186: oe_debug_pub.add('insert_wip_interface: ' || 'enavle lower level supply value is '|| l_mlsupply_parameter , 4);

182: WHERE oel.line_id = p_line_id
183: AND oel.ship_from_org_id = bp.organization_id;
184:
185: IF PG_DEBUG <> 0 THEN
186: oe_debug_pub.add('insert_wip_interface: ' || 'enavle lower level supply value is '|| l_mlsupply_parameter , 4);
187:
188:
189: END IF;
190:

Line 197: oe_debug_pub.add('insert_wip_interface: ' || 'Before call to create_subassembly_jobs with enable lower supply param '|| l_mlsupply_parameter , 4);

193:
194:
195:
196: IF PG_DEBUG <> 0 THEN
197: oe_debug_pub.add('insert_wip_interface: ' || 'Before call to create_subassembly_jobs with enable lower supply param '|| l_mlsupply_parameter , 4);
198:
199:
200: END IF;
201:

Line 223: oe_debug_pub.add ('insert_wip_interface: ' || 'failed after get_wroking_day' || l_return_status ,1);

219: );
220:
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: IF PG_DEBUG <> 0 THEN
223: oe_debug_pub.add ('insert_wip_interface: ' || 'failed after get_wroking_day' || l_return_status ,1);
224: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
225: END IF;
226: RAISE FND_API.G_EXC_ERROR;
227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 224: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);

220:
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: IF PG_DEBUG <> 0 THEN
223: oe_debug_pub.add ('insert_wip_interface: ' || 'failed after get_wroking_day' || l_return_status ,1);
224: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
225: END IF;
226: RAISE FND_API.G_EXC_ERROR;
227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
228: IF PG_DEBUG <> 0 THEN

Line 229: oe_debug_pub.add ('insert_wip_interface: ' || ' failed after call to get_working_day' || l_return_status ,1);

225: END IF;
226: RAISE FND_API.G_EXC_ERROR;
227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
228: IF PG_DEBUG <> 0 THEN
229: oe_debug_pub.add ('insert_wip_interface: ' || ' failed after call to get_working_day' || l_return_status ,1);
230: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
231: END IF;
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: ELSE

Line 230: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);

226: RAISE FND_API.G_EXC_ERROR;
227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
228: IF PG_DEBUG <> 0 THEN
229: oe_debug_pub.add ('insert_wip_interface: ' || ' failed after call to get_working_day' || l_return_status ,1);
230: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
231: END IF;
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: ELSE
234: IF PG_DEBUG <> 0 THEN

Line 235: oe_debug_pub.add('insert_wip_interface: ' || 'success from create_Subassembly_jobs ' ,1);

231: END IF;
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: ELSE
234: IF PG_DEBUG <> 0 THEN
235: oe_debug_pub.add('insert_wip_interface: ' || 'success from create_Subassembly_jobs ' ,1);
236: oe_debug_pub.add('insert_wip_interface: ' || l_error_message ,1);
237: END IF;
238: END IF;
239:

Line 236: oe_debug_pub.add('insert_wip_interface: ' || l_error_message ,1);

232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: ELSE
234: IF PG_DEBUG <> 0 THEN
235: oe_debug_pub.add('insert_wip_interface: ' || 'success from create_Subassembly_jobs ' ,1);
236: oe_debug_pub.add('insert_wip_interface: ' || l_error_message ,1);
237: END IF;
238: END IF;
239:
240:

Line 350: oe_debug_pub.add('insert_wip_interface: ' || 'Number of Rows Inserted in WJSI: ' || to_char(SQL%ROWCOUNT));

346: );
347:
348: if (SQL%ROWCOUNT > 0) then
349: IF PG_DEBUG <> 0 THEN
350: oe_debug_pub.add('insert_wip_interface: ' || 'Number of Rows Inserted in WJSI: ' || to_char(SQL%ROWCOUNT));
351: END IF;
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: else
354: x_return_status := FND_API.G_RET_STS_ERROR;

Line 382: oe_debug_pub.add('insert_wip_interface: ' || 'line_id = '||to_char(p_line_id), 2);

378:
379: for lNextRec IN c_delivery_lines LOOP
380:
381: IF PG_DEBUG <> 0 THEN
382: oe_debug_pub.add('insert_wip_interface: ' || 'line_id = '||to_char(p_line_id), 2);
383:
384: oe_debug_pub.add('insert_wip_interface: ' || 'delivery_id = '||to_char(lNextRec.delivery_id), 2);
385:
386: oe_debug_pub.add('insert_wip_interface: ' || 'lsn = '||to_char(lNextRec.lsn), 2);

Line 384: oe_debug_pub.add('insert_wip_interface: ' || 'delivery_id = '||to_char(lNextRec.delivery_id), 2);

380:
381: IF PG_DEBUG <> 0 THEN
382: oe_debug_pub.add('insert_wip_interface: ' || 'line_id = '||to_char(p_line_id), 2);
383:
384: oe_debug_pub.add('insert_wip_interface: ' || 'delivery_id = '||to_char(lNextRec.delivery_id), 2);
385:
386: oe_debug_pub.add('insert_wip_interface: ' || 'lsn = '||to_char(lNextRec.lsn), 2);
387:
388: oe_debug_pub.add('insert_wip_interface: ' || 'Qty = '||to_char(lNextRec.pQuantity), 2);

Line 386: oe_debug_pub.add('insert_wip_interface: ' || 'lsn = '||to_char(lNextRec.lsn), 2);

382: oe_debug_pub.add('insert_wip_interface: ' || 'line_id = '||to_char(p_line_id), 2);
383:
384: oe_debug_pub.add('insert_wip_interface: ' || 'delivery_id = '||to_char(lNextRec.delivery_id), 2);
385:
386: oe_debug_pub.add('insert_wip_interface: ' || 'lsn = '||to_char(lNextRec.lsn), 2);
387:
388: oe_debug_pub.add('insert_wip_interface: ' || 'Qty = '||to_char(lNextRec.pQuantity), 2);
389: END IF;
390:

Line 388: oe_debug_pub.add('insert_wip_interface: ' || 'Qty = '||to_char(lNextRec.pQuantity), 2);

384: oe_debug_pub.add('insert_wip_interface: ' || 'delivery_id = '||to_char(lNextRec.delivery_id), 2);
385:
386: oe_debug_pub.add('insert_wip_interface: ' || 'lsn = '||to_char(lNextRec.lsn), 2);
387:
388: oe_debug_pub.add('insert_wip_interface: ' || 'Qty = '||to_char(lNextRec.pQuantity), 2);
389: END IF;
390:
391: l_current_qty := lNextRec.pQuantity;
392: IF PG_DEBUG <> 0 THEN

Line 393: oe_debug_pub.add('insert_wip_interface: ' || 'l_current_qty::'||to_char(l_current_qty), 2);

389: END IF;
390:
391: l_current_qty := lNextRec.pQuantity;
392: IF PG_DEBUG <> 0 THEN
393: oe_debug_pub.add('insert_wip_interface: ' || 'l_current_qty::'||to_char(l_current_qty), 2);
394: END IF;
395:
396: IF l_current_qty > l_partial_qty - l_wo_created_qty THEN
397: l_current_qty := l_partial_qty - l_wo_created_qty;

Line 400: oe_debug_pub.add('insert_wip_interface: ' || 'New l_current_qty::'||to_char(l_current_qty), 2);

396: IF l_current_qty > l_partial_qty - l_wo_created_qty THEN
397: l_current_qty := l_partial_qty - l_wo_created_qty;
398: END IF;
399: IF PG_DEBUG <> 0 THEN
400: oe_debug_pub.add('insert_wip_interface: ' || 'New l_current_qty::'||to_char(l_current_qty), 2);
401: END IF;
402:
403:
404: --looking for ML supply org parameter value

Line 438: oe_debug_pub.add ('insert_wip_interface: ' || 'failed after get_wroking_day' || l_return_status ,1);

434: );
435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437: IF PG_DEBUG <> 0 THEN
438: oe_debug_pub.add ('insert_wip_interface: ' || 'failed after get_wroking_day' || l_return_status ,1);
439: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
440: END IF;
441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 439: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);

435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437: IF PG_DEBUG <> 0 THEN
438: oe_debug_pub.add ('insert_wip_interface: ' || 'failed after get_wroking_day' || l_return_status ,1);
439: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
440: END IF;
441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
443: IF PG_DEBUG <> 0 THEN

Line 444: oe_debug_pub.add ('insert_wip_interface: ' || ' failed after call to get_working_day' || l_return_status ,1);

440: END IF;
441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
443: IF PG_DEBUG <> 0 THEN
444: oe_debug_pub.add ('insert_wip_interface: ' || ' failed after call to get_working_day' || l_return_status ,1);
445: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
446: END IF;
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: ELSE

Line 445: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);

441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
443: IF PG_DEBUG <> 0 THEN
444: oe_debug_pub.add ('insert_wip_interface: ' || ' failed after call to get_working_day' || l_return_status ,1);
445: oe_debug_pub.add ('insert_wip_interface: ' || 'error message' || l_error_message ,1);
446: END IF;
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: ELSE
449: IF PG_DEBUG <> 0 THEN

Line 450: oe_debug_pub.add('insert_wip_interface: ' || 'success from get_working_day ' ,1);

446: END IF;
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: ELSE
449: IF PG_DEBUG <> 0 THEN
450: oe_debug_pub.add('insert_wip_interface: ' || 'success from get_working_day ' ,1);
451: oe_debug_pub.add('insert_wip_interface: ' || l_error_message ,1);
452: END IF;
453: END IF;
454:

Line 451: oe_debug_pub.add('insert_wip_interface: ' || l_error_message ,1);

447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: ELSE
449: IF PG_DEBUG <> 0 THEN
450: oe_debug_pub.add('insert_wip_interface: ' || 'success from get_working_day ' ,1);
451: oe_debug_pub.add('insert_wip_interface: ' || l_error_message ,1);
452: END IF;
453: END IF;
454:
455:

Line 585: oe_debug_pub.add('insert_wip_interface: ' || 'Number of Rows Inserted in WJSI for departure planned : ' ||

581:
582:
583: if (SQL%ROWCOUNT > 0) then
584: IF PG_DEBUG <> 0 THEN
585: oe_debug_pub.add('insert_wip_interface: ' || 'Number of Rows Inserted in WJSI for departure planned : ' ||
586: to_char(SQL%ROWCOUNT),1);
587: END IF;
588: x_return_status := FND_API.G_RET_STS_SUCCESS;
589: else

Line 599: oe_debug_pub.add('insert_wip_interface: ' || 'Qty of wo created::'||to_char(l_wo_created_qty),2);

595: l_stmt_num := 180;
596: l_wo_created_qty := l_wo_created_qty + l_current_qty;
597:
598: IF PG_DEBUG <> 0 THEN
599: oe_debug_pub.add('insert_wip_interface: ' || 'Qty of wo created::'||to_char(l_wo_created_qty),2);
600: END IF;
601:
602: IF (l_wo_created_qty >= l_partial_qty) THEN
603: IF PG_DEBUG <> 0 THEN

Line 604: oe_debug_pub.add('insert_wip_interface: ' || 'Exiting out of partial qty loop',2);

600: END IF;
601:
602: IF (l_wo_created_qty >= l_partial_qty) THEN
603: IF PG_DEBUG <> 0 THEN
604: oe_debug_pub.add('insert_wip_interface: ' || 'Exiting out of partial qty loop',2);
605: END IF;
606: EXIT;
607: END IF;
608:

Line 622: oe_debug_pub.add('insert_wip_interface: ' || ' expected excpn: ' || x_error_message,1);

618: x_error_message := 'CTOWIPUB.insert wip interface expected excpn: ';
619:
620:
621: IF PG_DEBUG <> 0 THEN
622: oe_debug_pub.add('insert_wip_interface: ' || ' expected excpn: ' || x_error_message,1);
623: END IF;
624:
625:
626:

Line 634: oe_debug_pub.add('insert_wip_inetrface: ' || ' UN expected excpn: ' || x_error_message,1);

630: substrb(sqlerrm,1,100) ;
631:
632:
633: IF PG_DEBUG <> 0 THEN
634: oe_debug_pub.add('insert_wip_inetrface: ' || ' UN expected excpn: ' || x_error_message,1);
635: END IF;
636:
637:
638:

Line 644: oe_debug_pub.add('insert_wip_interface: ' || x_error_message,1);

640: x_error_message := 'CTOWIPUB.insert_wip_interface raised no-data-found: '|| ':' ||
641: substrb(sqlerrm,1,100);
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: IF PG_DEBUG <> 0 THEN
644: oe_debug_pub.add('insert_wip_interface: ' || x_error_message,1);
645: END IF;
646: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
647:
648: when INSERT_ERROR then

Line 653: oe_debug_pub.add('insert_wip_interface: ' || x_error_message,1);

649: x_return_status := FND_API.G_RET_STS_ERROR;
650: x_error_message := 'CTOWIPUB.insert_wip_interface raised INSERT_ERROR:' || to_char(l_stmt_num)|| ':' ||
651: substrb(sqlerrm,1,100);
652: IF PG_DEBUG <> 0 THEN
653: oe_debug_pub.add('insert_wip_interface: ' || x_error_message,1);
654: END IF;
655:
656: when OTHERS then
657: x_return_status := FND_API.G_RET_STS_ERROR;

Line 662: oe_debug_pub.add('insert_wip_interface: ' || x_error_message,1);

658: x_error_message := 'CTOWIPUB.insert_wip_interface raised OTHERS excpn: ' || to_char(l_stmt_num)|| ':' ||
659: substrb(sqlerrm,1,100) ;
660:
661: IF PG_DEBUG <> 0 THEN
662: oe_debug_pub.add('insert_wip_interface: ' || x_error_message,1);
663: END IF;
664: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
665: OE_MSG_PUB.Add_Exc_Msg
666: ( G_PKG_NAME

Line 795: oe_debug_pub.add('Delivery_Planned: ' || 'Delivery lines HAVE NOT BEEN IMPORTED for order line '||to_char(p_line_id), 2);

791:
792: EXCEPTION
793: when NO_DATA_FOUND then
794: IF PG_DEBUG <> 0 THEN
795: oe_debug_pub.add('Delivery_Planned: ' || 'Delivery lines HAVE NOT BEEN IMPORTED for order line '||to_char(p_line_id), 2);
796: END IF;
797: RAISE Delivery_Not_Planned;
798:
799: END; /* Block checking if delivery lines are imported*/

Line 825: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries have NOT BEEN ASSIGNED for line '||to_char(p_line_id), 1);

821: and rownum = 1;
822:
823: IF l_assigned = 'NOTASSIGNED' THEN
824: IF PG_DEBUG <> 0 THEN
825: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries have NOT BEEN ASSIGNED for line '||to_char(p_line_id), 1);
826: END IF;
827: RAISE Delivery_Not_Planned;
828: END IF; /* if delivery not assigned for any delivery line*/
829:

Line 833: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries HAVE BEEN ASSIGNED for all delivery lines for order line '||to_char(p_line_id), 2);

829:
830: EXCEPTION
831: when no_data_found then
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries HAVE BEEN ASSIGNED for all delivery lines for order line '||to_char(p_line_id), 2);
834: END IF;
835:
836: END; /* Block checking for delivery assignments*/
837:

Line 861: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries have been assigned, but NOT PLANNED yet for line '||to_char(p_line_id), 1);

857: and rownum=1;
858:
859: IF l_planned = 'NOTPLANNED' THEN
860: IF PG_DEBUG <> 0 THEN
861: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries have been assigned, but NOT PLANNED yet for line '||to_char(p_line_id), 1);
862: END IF;
863: RAISE Delivery_Not_Planned;
864: END IF; /* if delivery not planned*/
865:

Line 869: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries HAVE BEEN PLANNED for order line '||to_char(p_line_id), 2);

865:
866: EXCEPTION
867: when NO_DATA_FOUND then
868: IF PG_DEBUG <> 0 THEN
869: oe_debug_pub.add('Delivery_Planned: ' || 'Deliveries HAVE BEEN PLANNED for order line '||to_char(p_line_id), 2);
870: END IF;
871:
872: END; /* Block checking if deliveries planned */
873:

Line 888: oe_debug_pub.add('Delivery_Planned: ' || 'CTO_WIP_UTIL.Delivery_Planned::exp error', 1);

884: x_result_out := FND_API.G_FALSE;
885:
886: when FND_API.G_EXC_ERROR then
887: IF PG_DEBUG <> 0 THEN
888: oe_debug_pub.add('Delivery_Planned: ' || 'CTO_WIP_UTIL.Delivery_Planned::exp error', 1);
889: END IF;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: CTO_MSG_PUB.Count_And_Get
892: (p_msg_count => x_msg_count

Line 898: oe_debug_pub.add('Delivery_Planned: ' || 'CTO_WIP_UTIL.Delivery_Planned::unexp error', 1);

894: );
895:
896: when FND_API.G_EXC_UNEXPECTED_ERROR then
897: IF PG_DEBUG <> 0 THEN
898: oe_debug_pub.add('Delivery_Planned: ' || 'CTO_WIP_UTIL.Delivery_Planned::unexp error', 1);
899: END IF;
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
901: CTO_MSG_PUB.Count_And_Get
902: (p_msg_count => x_msg_count

Line 908: oe_debug_pub.add('Delivery_Planned: ' || 'CTO_WIP_UTIL.Delivery_Planned::others', 1);

904: );
905:
906: when OTHERS then
907: IF PG_DEBUG <> 0 THEN
908: oe_debug_pub.add('Delivery_Planned: ' || 'CTO_WIP_UTIL.Delivery_Planned::others', 1);
909: END IF;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
912: then