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_WORKFLOW_API_PK dependencies on FND_API

Line 165: x_return_status := FND_API.G_RET_STS_SUCCESS;

161:
162:
163: BEGIN
164:
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: select item_type_code, ato_line_id
168: into v_item_type_code, v_ato_line_id
169: from oe_order_lines_all

Line 200: raise FND_API.G_EXC_ERROR;

196: query_wf_activity_status(G_ITEM_TYPE_NAME, TO_CHAR(order_line_id),
197: 'SHIP_LINE', 'SHIP_LINE', v_activity_status_code);
198: if upper(v_activity_status_code) <> 'NOTIFIED' then
199: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
200: raise FND_API.G_EXC_ERROR;
201: end if;
202: end if;
203:
204: -- display proper status to OM form

Line 217: raise FND_API.G_EXC_ERROR;

213: 'Return value from display_wf_status = '||to_char(return_value));
214:
215: if return_value <> 1 then
216: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
217: raise FND_API.G_EXC_ERROR;
218: end if;
219:
220: end if;
221:

Line 225: when FND_API.G_EXC_ERROR then

221:
222:
223: EXCEPTION
224:
225: when FND_API.G_EXC_ERROR then
226: IF PG_DEBUG <> 0 THEN
227: oe_debug_pub.add ('first_wo_reservation_created: ' || 'first_wo_reservation_created raised expected error.',1);
228: END IF;
229: x_return_status := FND_API.G_RET_STS_ERROR;

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: when FND_API.G_EXC_ERROR then
226: IF PG_DEBUG <> 0 THEN
227: oe_debug_pub.add ('first_wo_reservation_created: ' || 'first_wo_reservation_created raised expected error.',1);
228: END IF;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: CTO_MSG_PUB.Count_And_Get(
231: p_msg_count => x_msg_count,
232: p_msg_data => x_msg_data
233: );

Line 235: when FND_API.G_EXC_UNEXPECTED_ERROR then

231: p_msg_count => x_msg_count,
232: p_msg_data => x_msg_data
233: );
234:
235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: IF PG_DEBUG <> 0 THEN
237: oe_debug_pub.add ('first_wo_reservation_created: ' || 'first_wo_reservation_created raised unexpected error.',1);
238: END IF;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: IF PG_DEBUG <> 0 THEN
237: oe_debug_pub.add ('first_wo_reservation_created: ' || 'first_wo_reservation_created raised unexpected error.',1);
238: END IF;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: CTO_MSG_PUB.Count_And_Get(
241: p_msg_count => x_msg_count,
242: p_msg_data => x_msg_data
243: );

Line 249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

245: when others then
246: IF PG_DEBUG <> 0 THEN
247: oe_debug_pub.add ('first_wo_reservation_created: ' || 'first_wo_reservation_created others exception: '||sqlerrm,1);
248: END IF;
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
252: END IF;
253: CTO_MSG_PUB.Count_And_Get(

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

294:
295:
296: BEGIN
297:
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: select item_type_code, ato_line_id
301: into v_item_type_code, v_ato_line_id
302: from oe_order_lines_all

Line 366: raise FND_API.G_EXC_ERROR;

362: end if;
363:
364: else
365: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
366: raise FND_API.G_EXC_ERROR;
367: end if;
368:
369: -- display proper status to OM form
370:

Line 382: raise FND_API.G_EXC_ERROR;

378: 'Return value from display_wf_status = '||to_char(order_line_id));
379:
380: if return_value <> 1 then
381: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
382: raise FND_API.G_EXC_ERROR;
383: end if;
384:
385: end if;
386:

Line 390: when FND_API.G_EXC_ERROR then

386:
387:
388: EXCEPTION
389:
390: when FND_API.G_EXC_ERROR then
391: IF PG_DEBUG <> 0 THEN
392: oe_debug_pub.add ('last_wo_reservation_deleted: ' || 'last_wo_reservation_deleted raised expected error.',1);
393: END IF;
394: x_return_status := FND_API.G_RET_STS_ERROR;

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

390: when FND_API.G_EXC_ERROR then
391: IF PG_DEBUG <> 0 THEN
392: oe_debug_pub.add ('last_wo_reservation_deleted: ' || 'last_wo_reservation_deleted raised expected error.',1);
393: END IF;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: CTO_MSG_PUB.Count_And_Get(
396: p_msg_count => x_msg_count,
397: p_msg_data => x_msg_data
398: );

Line 401: when FND_API.G_EXC_UNEXPECTED_ERROR then

397: p_msg_data => x_msg_data
398: );
399:
400:
401: when FND_API.G_EXC_UNEXPECTED_ERROR then
402: IF PG_DEBUG <> 0 THEN
403: oe_debug_pub.add ('last_wo_reservation_deleted: ' || 'last_wo_reservation_deleted raised unexpected error.',1);
404: END IF;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

401: when FND_API.G_EXC_UNEXPECTED_ERROR then
402: IF PG_DEBUG <> 0 THEN
403: oe_debug_pub.add ('last_wo_reservation_deleted: ' || 'last_wo_reservation_deleted raised unexpected error.',1);
404: END IF;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: CTO_MSG_PUB.Count_And_Get(
407: p_msg_count => x_msg_count,
408: p_msg_data => x_msg_data
409: );

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411: when others then
412: IF PG_DEBUG <> 0 THEN
413: oe_debug_pub.add ('last_wo_reservation_deleted: ' || 'last_wo_reservation_deleted raised others exception: '||sqlerrm,1);
414: END IF;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
417: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
418: END IF;
419: CTO_MSG_PUB.Count_And_Get(

Line 460: x_return_status := FND_API.G_RET_STS_SUCCESS;

456:
457:
458: BEGIN
459:
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: select item_type_code, ato_line_id
463: into v_item_type_code, v_ato_line_id
464: from oe_order_lines_all

Line 489: raise FND_API.G_EXC_ERROR;

485: query_wf_activity_status(G_ITEM_TYPE_NAME, TO_CHAR(order_line_id),
486: 'SHIP_LINE', 'SHIP_LINE', v_activity_status_code);
487: if upper(v_activity_status_code) <> 'NOTIFIED' then
488: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
489: raise FND_API.G_EXC_ERROR;
490: end if;
491: end if;
492:
493: -- display proper status to OM form

Line 505: raise FND_API.G_EXC_ERROR;

501: ' The return value from display_wf_status = '||to_char(return_value));
502:
503: if return_value <> 1 then
504: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
505: raise FND_API.G_EXC_ERROR;
506: end if;
507:
508: end if;
509:

Line 513: when FND_API.G_EXC_ERROR then

509:
510:
511: EXCEPTION
512:
513: when FND_API.G_EXC_ERROR then
514: IF PG_DEBUG <> 0 THEN
515: oe_debug_pub.add ('flow_creation: ' || 'flow_creation raised expected error.',1);
516: END IF;
517: x_return_status := FND_API.G_RET_STS_ERROR;

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: when FND_API.G_EXC_ERROR then
514: IF PG_DEBUG <> 0 THEN
515: oe_debug_pub.add ('flow_creation: ' || 'flow_creation raised expected error.',1);
516: END IF;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: CTO_MSG_PUB.Count_And_Get(
519: p_msg_count => x_msg_count,
520: p_msg_data => x_msg_data
521: );

Line 524: when FND_API.G_EXC_UNEXPECTED_ERROR then

520: p_msg_data => x_msg_data
521: );
522:
523:
524: when FND_API.G_EXC_UNEXPECTED_ERROR then
525: IF PG_DEBUG <> 0 THEN
526: oe_debug_pub.add ('flow_creation: ' || 'flow_creation raised unexpected error.',1);
527: END IF;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: when FND_API.G_EXC_UNEXPECTED_ERROR then
525: IF PG_DEBUG <> 0 THEN
526: oe_debug_pub.add ('flow_creation: ' || 'flow_creation raised unexpected error.',1);
527: END IF;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: CTO_MSG_PUB.Count_And_Get(
530: p_msg_count => x_msg_count,
531: p_msg_data => x_msg_data
532: );

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534: when others then
535: IF PG_DEBUG <> 0 THEN
536: oe_debug_pub.add ('flow_creation: ' || 'flow_creation raised others exception: '||sqlerrm,1);
537: END IF;
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
540: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
541: END IF;
542: CTO_MSG_PUB.Count_And_Get(

Line 586: x_return_status := FND_API.G_RET_STS_SUCCESS;

582:
583:
584: BEGIN
585:
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: select item_type_code, ato_line_id
589: into v_item_type_code, v_ato_line_id
590: from oe_order_lines_all

Line 649: raise FND_API.G_EXC_ERROR;

645: end if;
646:
647: else
648: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
649: raise FND_API.G_EXC_ERROR;
650: end if;
651:
652: -- display proper status to OM form
653:

Line 664: raise FND_API.G_EXC_ERROR;

660: ' Display_wf_status return value = '||to_char(return_value));
661:
662: if return_value <> 1 then
663: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
664: raise FND_API.G_EXC_ERROR;
665: end if;
666:
667: end if;
668:

Line 672: when FND_API.G_EXC_ERROR then

668:
669:
670: EXCEPTION
671:
672: when FND_API.G_EXC_ERROR then
673: IF PG_DEBUG <> 0 THEN
674: oe_debug_pub.add ('flow_deletion: ' || 'flow_deletion raised expected error.',1);
675: END IF;
676: x_return_status := FND_API.G_RET_STS_ERROR;

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672: when FND_API.G_EXC_ERROR then
673: IF PG_DEBUG <> 0 THEN
674: oe_debug_pub.add ('flow_deletion: ' || 'flow_deletion raised expected error.',1);
675: END IF;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: CTO_MSG_PUB.Count_And_Get(
678: p_msg_count => x_msg_count,
679: p_msg_data => x_msg_data
680: );

Line 683: when FND_API.G_EXC_UNEXPECTED_ERROR then

679: p_msg_data => x_msg_data
680: );
681:
682:
683: when FND_API.G_EXC_UNEXPECTED_ERROR then
684: IF PG_DEBUG <> 0 THEN
685: oe_debug_pub.add ('flow_deletion: ' || 'flow_deletion raised expected error.',1);
686: END IF;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

683: when FND_API.G_EXC_UNEXPECTED_ERROR then
684: IF PG_DEBUG <> 0 THEN
685: oe_debug_pub.add ('flow_deletion: ' || 'flow_deletion raised expected error.',1);
686: END IF;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: CTO_MSG_PUB.Count_And_Get(
689: p_msg_count => x_msg_count,
690: p_msg_data => x_msg_data
691: );

Line 697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

693: when others then
694: IF PG_DEBUG <> 0 THEN
695: oe_debug_pub.add ('flow_deletion: ' || 'flow_deletion raised others exception:'||sqlerrm,1);
696: END IF;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
699: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
700: END IF;
701: CTO_MSG_PUB.Count_And_Get(