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 FND_API

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: order by wda.delivery_id, wdd.load_seq_number;
132:
133: BEGIN
134:
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: l_stmt_num := 100;
138:
139: select nvl(oel.dep_plan_required_flag, 'N')

Line 221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

217: l_error_message,
218: l_message_name
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;

Line 226: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR 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
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;

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
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);

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
355: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
356: raise INSERT_ERROR ;

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

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;
355: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
356: raise INSERT_ERROR ;
357: end if;
358:

Line 436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

432: l_error_message,
433: l_message_name
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;

Line 441: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR 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
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;

Line 447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
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);

Line 588: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
592: raise INSERT_ERROR ;

Line 590: x_return_status := FND_API.G_RET_STS_ERROR;

586: to_char(SQL%ROWCOUNT),1);
587: END IF;
588: x_return_status := FND_API.G_RET_STS_SUCCESS;
589: else
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
592: raise INSERT_ERROR ;
593: end if;
594:

Line 615: when FND_API.G_EXC_ERROR then

611:
612: EXCEPTION
613:
614:
615: when FND_API.G_EXC_ERROR then
616:
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: x_error_message := 'CTOWIPUB.insert wip interface expected excpn: ';
619:

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613:
614:
615: when FND_API.G_EXC_ERROR then
616:
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: x_error_message := 'CTOWIPUB.insert wip interface expected excpn: ';
619:
620:
621: IF PG_DEBUG <> 0 THEN

Line 627: when FND_API.G_EXC_UNEXPECTED_ERROR then

623: END IF;
624:
625:
626:
627: when FND_API.G_EXC_UNEXPECTED_ERROR then
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: x_error_message := 'CTOWIPUB.insert wip interface N expected excpn: '|| ':' ||
630: substrb(sqlerrm,1,100) ;
631:

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624:
625:
626:
627: when FND_API.G_EXC_UNEXPECTED_ERROR then
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: x_error_message := 'CTOWIPUB.insert wip interface N expected excpn: '|| ':' ||
630: substrb(sqlerrm,1,100) ;
631:
632:

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638:
639: when NO_DATA_FOUND then
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');

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: END IF;
646: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
647:
648: when INSERT_ERROR then
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);

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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

Line 878: x_return_status := FND_API.G_RET_STS_SUCCESS;

874: --
875: -- Deliveries have been assigned and planned
876: --
877:
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879: x_result_out := FND_API.G_TRUE;
880:
881: EXCEPTION
882: when DELIVERY_NOT_PLANNED then

Line 879: x_result_out := FND_API.G_TRUE;

875: -- Deliveries have been assigned and planned
876: --
877:
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879: x_result_out := FND_API.G_TRUE;
880:
881: EXCEPTION
882: when DELIVERY_NOT_PLANNED then
883: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 883: x_return_status := FND_API.G_RET_STS_SUCCESS;

879: x_result_out := FND_API.G_TRUE;
880:
881: EXCEPTION
882: when DELIVERY_NOT_PLANNED then
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
884: x_result_out := FND_API.G_FALSE;
885:
886: when FND_API.G_EXC_ERROR then
887: IF PG_DEBUG <> 0 THEN

Line 884: x_result_out := FND_API.G_FALSE;

880:
881: EXCEPTION
882: when DELIVERY_NOT_PLANNED then
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 886: when FND_API.G_EXC_ERROR then

882: when DELIVERY_NOT_PLANNED then
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 890: x_return_status := FND_API.G_RET_STS_ERROR;

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
893: ,p_msg_data => x_msg_data
894: );

Line 896: when FND_API.G_EXC_UNEXPECTED_ERROR then

892: (p_msg_count => x_msg_count
893: ,p_msg_data => x_msg_data
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;

Line 900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
903: ,p_msg_data => x_msg_data
904: );

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
913: FND_MSG_PUB.Add_Exc_Msg
914: ( 'CTO_WIP_UTIL'