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

Line 395: WHEN FND_API.G_EXC_ERROR THEN

391: END IF;
392: END IF;
393:
394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
398: END IF;
399: RAISE FND_API.G_EXC_ERROR;

Line 399: RAISE FND_API.G_EXC_ERROR;

395: WHEN FND_API.G_EXC_ERROR THEN
396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
398: END IF;
399: RAISE FND_API.G_EXC_ERROR;
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: IF PG_DEBUG <> 0 THEN
402: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
403: END IF;

Line 400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
398: END IF;
399: RAISE FND_API.G_EXC_ERROR;
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: IF PG_DEBUG <> 0 THEN
402: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
403: END IF;
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: IF PG_DEBUG <> 0 THEN
402: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
403: END IF;
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: WHEN OTHERS THEN
406: IF PG_DEBUG <> 0 THEN
407: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::other error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
408: END IF;

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: WHEN OTHERS THEN
406: IF PG_DEBUG <> 0 THEN
407: oe_debug_pub.add('CTO_SUBASSEMBLY_SUP_PK: ' || 'check_recurring_item::other error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
408: END IF;
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410:
411:
412: END check_recurring_item;
413:

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS ;

427: l_stmt_num number := 0;
428:
429: BEGIN
430:
431: x_return_status := FND_API.G_RET_STS_SUCCESS ;
432: IF PG_DEBUG <> 0 THEN
433: oe_debug_pub.add ('get_working_day: ' || 'Pdate=>' ||to_char(Pdate,'mm/dd/yyyy hh24:mi:ss'),5);
434: oe_debug_pub.add ('get_working_day: ' || 'trunc_Pdate=>' ||to_char(TRUNC(Pdate),'mm/dd/yyyy hh24:mi:ss'),5);
435: oe_debug_pub.add ('get_working_day: ' || 'pleadtime =>' ||pleadtime ,5);

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478:
479: EXCEPTION
480:
481: when OTHERS then
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: x_error_message := 'CTOSUBSB.get_working_day OTHERS excpn: ' || to_char(l_stmt_num)||':' ||
484: substrb(sqlerrm,1,100);
485: IF PG_DEBUG <> 0 THEN
486:

Line 534: x_return_status := FND_API.G_RET_STS_SUCCESS ;

530:
531:
532:
533: BEGIN
534: x_return_status := FND_API.G_RET_STS_SUCCESS ;
535:
536:
537:
538: l_total_lead_time := CEIL( nvl(pfixed_leadtime,0) +( pQty * nvl(pvariable_leadtime,0) ) ); --bugfix 2827357

Line 564: /* if ( l_return_status <> FND_API.G_RET_STS_SUCCESS) then

560: x_message_name => l_msg_name
561:
562: );
563:
564: /* if ( l_return_status <> FND_API.G_RET_STS_SUCCESS) then
565: IF PG_DEBUG <> 0 THEN
566: oe_debug_pub.add ('get_start_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
567:
568: oe_debug_pub.add ('get_start_date: ' || 'error message' || l_error_msg ,1);

Line 574: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

570: RAISE subprogram_exp ;
571:
572: end if; */
573:
574: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
575: IF PG_DEBUG <> 0 THEN
576: oe_debug_pub.add ('get_start_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
577:
578: oe_debug_pub.add ('get_start_date: ' || 'error message' || l_error_msg ,1);

Line 580: RAISE FND_API.G_EXC_ERROR;

576: oe_debug_pub.add ('get_start_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
577:
578: oe_debug_pub.add ('get_start_date: ' || 'error message' || l_error_msg ,1);
579: END IF;
580: RAISE FND_API.G_EXC_ERROR;
581: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
582: IF PG_DEBUG <> 0 THEN
583: oe_debug_pub.add ('get_start_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
584:

Line 581: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

577:
578: oe_debug_pub.add ('get_start_date: ' || 'error message' || l_error_msg ,1);
579: END IF;
580: RAISE FND_API.G_EXC_ERROR;
581: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
582: IF PG_DEBUG <> 0 THEN
583: oe_debug_pub.add ('get_start_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
584:
585: oe_debug_pub.add ('get_start_date: ' || 'error message' || l_error_msg ,1);

Line 587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

583: oe_debug_pub.add ('get_start_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
584:
585: oe_debug_pub.add ('get_start_date: ' || 'error message' || l_error_msg ,1);
586: END IF;
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: ELSE
589:
590: IF PG_DEBUG <> 0 THEN
591: oe_debug_pub.add('get_start_date: ' || 'success from get_working_day ' ,1);

Line 609: when FND_API.G_EXC_ERROR then

605:
606: EXCEPTION
607:
608:
609: when FND_API.G_EXC_ERROR then
610:
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: x_error_message := 'CTOSUBSB.get_start_date expected excpn: '|| ':' ||
613: substrb(sqlerrm,1,100) ;

Line 611: x_return_status := FND_API.G_RET_STS_ERROR;

607:
608:
609: when FND_API.G_EXC_ERROR then
610:
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: x_error_message := 'CTOSUBSB.get_start_date expected excpn: '|| ':' ||
613: substrb(sqlerrm,1,100) ;
614:
615:

Line 622: when FND_API.G_EXC_UNEXPECTED_ERROR then

618: END IF;
619:
620:
621:
622: when FND_API.G_EXC_UNEXPECTED_ERROR then
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: x_error_message := 'CTOSUBSB.get_start_date UN expected excpn: '|| ':' ||
625: substrb(sqlerrm,1,100) ;
626:

Line 623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619:
620:
621:
622: when FND_API.G_EXC_UNEXPECTED_ERROR then
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: x_error_message := 'CTOSUBSB.get_start_date UN expected excpn: '|| ':' ||
625: substrb(sqlerrm,1,100) ;
626:
627:

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632:
633:
634:
635: when OTHERS then
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: x_error_message := 'CTOSUBSB.get_start_date OTHERS excpn: '|| ':' ||
638: substrb(sqlerrm,1,100) ;
639:
640:

Line 694: x_return_status := FND_API.G_RET_STS_SUCCESS ;

690:
691:
692: BEGIN
693:
694: x_return_status := FND_API.G_RET_STS_SUCCESS ;
695:
696: IF ( pSource_type = 2) THEN -- make item
697:
698: l_total_lead_time := (plead_time_offset_percent/100)*pParent_processing_lead_time;

Line 725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

721: x_message_name => l_msg_name
722:
723: );
724:
725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
726: IF PG_DEBUG <> 0 THEN
727: oe_debug_pub.add ('get_completion_date: ' || ' failed in call to get_working_day with status ' || l_return_status ,1);
728:
729: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);

Line 731: RAISE FND_API.G_EXC_ERROR;

727: oe_debug_pub.add ('get_completion_date: ' || ' failed in call to get_working_day with status ' || l_return_status ,1);
728:
729: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);
730: END IF;
731: RAISE FND_API.G_EXC_ERROR;
732: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
733: IF PG_DEBUG <> 0 THEN
734: oe_debug_pub.add ('get_completion_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
735:

Line 732: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

728:
729: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);
730: END IF;
731: RAISE FND_API.G_EXC_ERROR;
732: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
733: IF PG_DEBUG <> 0 THEN
734: oe_debug_pub.add ('get_completion_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
735:
736: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);

Line 738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

734: oe_debug_pub.add ('get_completion_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
735:
736: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);
737: END IF;
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: ELSE
740:
741: IF PG_DEBUG <> 0 THEN
742: oe_debug_pub.add('get_completion_date: ' || 'success from get_working_day ' ,1);

Line 763: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

759: x_message_name => l_msg_name
760:
761: );
762:
763: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
764: IF PG_DEBUG <> 0 THEN
765: oe_debug_pub.add ('get_completion_date: ' || ' failed in call to get_working_day with status ' || l_return_status ,1);
766:
767: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);

Line 769: RAISE FND_API.G_EXC_ERROR;

765: oe_debug_pub.add ('get_completion_date: ' || ' failed in call to get_working_day with status ' || l_return_status ,1);
766:
767: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);
768: END IF;
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
771: IF PG_DEBUG <> 0 THEN
772: oe_debug_pub.add ('get_completion_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
773:

Line 770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

766:
767: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);
768: END IF;
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
771: IF PG_DEBUG <> 0 THEN
772: oe_debug_pub.add ('get_completion_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
773:
774: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);

Line 776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

772: oe_debug_pub.add ('get_completion_date: ' || 'get_start_date: failed after call to get_working_day with status ' || l_return_status ,1);
773:
774: oe_debug_pub.add ('get_completion_date: ' || 'error message' || l_error_msg ,1);
775: END IF;
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: ELSE
778:
779: IF PG_DEBUG <> 0 THEN
780: oe_debug_pub.add('get_completion_date: ' || 'success from get_working_day ' ,1);

Line 795: when FND_API.G_EXC_ERROR then

791:
792:
793: EXCEPTION
794:
795: when FND_API.G_EXC_ERROR then
796:
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: x_error_message := 'CTOSUBSB.get_completion_date expected excpn: ' || to_char(l_stmt_num)|| ':' ||
799: substrb(sqlerrm,1,100);

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

793: EXCEPTION
794:
795: when FND_API.G_EXC_ERROR then
796:
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: x_error_message := 'CTOSUBSB.get_completion_date expected excpn: ' || to_char(l_stmt_num)|| ':' ||
799: substrb(sqlerrm,1,100);
800:
801:

Line 809: when FND_API.G_EXC_UNEXPECTED_ERROR then

805: END IF;
806:
807:
808:
809: when FND_API.G_EXC_UNEXPECTED_ERROR then
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811: x_error_message := 'CTOSUBSB.get_completion_date UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
812: substrb(sqlerrm,1,100);
813:

Line 810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

806:
807:
808:
809: when FND_API.G_EXC_UNEXPECTED_ERROR then
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811: x_error_message := 'CTOSUBSB.get_completion_date UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
812: substrb(sqlerrm,1,100);
813:
814:

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821:
822:
823:
824: when OTHERS then
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: x_error_message := 'CTOSUBSB.get_start_date OTHERS excpn: ' || to_char(l_stmt_num)|| ':' ||
827: substrb(sqlerrm,1,100);
828:
829:

Line 1000: x_return_status := FND_API.G_RET_STS_SUCCESS ;

996: l_recurred_item_flag number;
997:
998: BEGIN
999:
1000: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1001:
1002: IF pLower_Supplytype = 2 THEN
1003:
1004: IF PG_DEBUG <> 0 THEN

Line 1087: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1083: X_exp_error_code => v_exp_error_code,
1084: X_return_status =>x_return_status
1085: );
1086:
1087: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1088: IF PG_DEBUG <> 0 THEN
1089: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1090: END IF;
1091: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1092: RAISE FND_API.G_EXC_ERROR;

1088: IF PG_DEBUG <> 0 THEN
1089: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1090: END IF;
1091: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094: IF PG_DEBUG <> 0 THEN
1095: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1096: END IF;

Line 1093: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1089: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1090: END IF;
1091: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094: IF PG_DEBUG <> 0 THEN
1095: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1096: END IF;
1097: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1094: IF PG_DEBUG <> 0 THEN
1095: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1096: END IF;
1097: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSE
1100:
1101: IF PG_DEBUG <> 0 THEN
1102: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

Line 1315: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1311: X_exp_error_code => v_exp_error_code,
1312: X_return_status =>x_return_status
1313: );
1314:
1315: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1316: IF PG_DEBUG <> 0 THEN
1317: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1318: END IF;
1319: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1320: RAISE FND_API.G_EXC_ERROR;

1316: IF PG_DEBUG <> 0 THEN
1317: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1318: END IF;
1319: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: IF PG_DEBUG <> 0 THEN
1323: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1324: END IF;

Line 1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1317: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1318: END IF;
1319: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: IF PG_DEBUG <> 0 THEN
1323: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1324: END IF;
1325: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1322: IF PG_DEBUG <> 0 THEN
1323: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1324: END IF;
1325: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSE
1328:
1329: IF PG_DEBUG <> 0 THEN
1330: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

Line 1439: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

1435: x_message_name => l_msg_name
1436:
1437: );
1438:
1439: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
1440: IF PG_DEBUG <> 0 THEN
1441: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to get_child_configurations with status ' || l_ret_status ,1);
1442:
1443: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);

Line 1445: RAISE FND_API.G_EXC_ERROR;

1441: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to get_child_configurations with status ' || l_ret_status ,1);
1442:
1443: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);
1444: END IF;
1445: RAISE FND_API.G_EXC_ERROR;
1446: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1447: IF PG_DEBUG <> 0 THEN
1448: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to get_child_configurations ' || l_ret_status ,1);
1449:

Line 1446: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1442:
1443: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);
1444: END IF;
1445: RAISE FND_API.G_EXC_ERROR;
1446: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1447: IF PG_DEBUG <> 0 THEN
1448: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to get_child_configurations ' || l_ret_status ,1);
1449:
1450: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);

Line 1452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1448: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to get_child_configurations ' || l_ret_status ,1);
1449:
1450: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);
1451: END IF;
1452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1453: ELSE
1454:
1455: IF PG_DEBUG <> 0 THEN
1456: oe_debug_pub.add('get_child_configurations: ' || 'success from get_child_configurations ' ,1);

Line 1476: when FND_API.G_EXC_ERROR then

1472: END IF;
1473:
1474: EXCEPTION
1475:
1476: when FND_API.G_EXC_ERROR then
1477:
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: --Bugfix 8913125
1480: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);

Line 1478: x_return_status := FND_API.G_RET_STS_ERROR;

1474: EXCEPTION
1475:
1476: when FND_API.G_EXC_ERROR then
1477:
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: --Bugfix 8913125
1480: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
1481:
1482: IF PG_DEBUG <> 0 THEN

Line 1487: when FND_API.G_EXC_UNEXPECTED_ERROR then

1483: oe_debug_pub.add('get_child_configurations: ' || 'CTOSUBSB.get_child_configurations expected excpn: ' || x_error_message,1);
1484: END IF;
1485:
1486:
1487: when FND_API.G_EXC_UNEXPECTED_ERROR then
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489: --Bugfix 8913125
1490: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
1491:

Line 1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1484: END IF;
1485:
1486:
1487: when FND_API.G_EXC_UNEXPECTED_ERROR then
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489: --Bugfix 8913125
1490: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
1491:
1492: IF PG_DEBUG <> 0 THEN

Line 1498: x_return_status := FND_API.G_RET_STS_ERROR;

1494: END IF;
1495:
1496:
1497: when OTHERS then
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: --Bugfix 8913125
1500: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
1501:
1502: IF PG_DEBUG <> 0 THEN

Line 1550: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1546: l_x_value varchar2(1);
1547:
1548: BEGIN
1549:
1550: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1551:
1552: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_CREATE;
1553: l_flow_schedule_rec.scheduled_flag := 1;
1554:

Line 1570: p_init_msg_list => FND_API.G_TRUE,

1566:
1567: l_stmt_num := 90;
1568: MRP_Flow_Schedule_PUB.Process_Flow_Schedule(
1569: p_api_version_number => 1.0,
1570: p_init_msg_list => FND_API.G_TRUE,
1571: x_return_status => l_return_status,
1572: x_msg_count => l_msg_count,
1573: x_msg_data => l_msg_data,
1574: p_flow_schedule_rec => l_flow_schedule_rec,

Line 1582: if (l_return_status = FND_API.G_RET_STS_ERROR) then --flow return status

1578:
1579:
1580:
1581:
1582: if (l_return_status = FND_API.G_RET_STS_ERROR) then --flow return status
1583: IF PG_DEBUG <> 0 THEN
1584: oe_debug_pub.add('create_flow_subassembly: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);
1585: END IF;
1586: raise FND_API.G_EXC_ERROR;

Line 1586: raise FND_API.G_EXC_ERROR;

1582: if (l_return_status = FND_API.G_RET_STS_ERROR) then --flow return status
1583: IF PG_DEBUG <> 0 THEN
1584: oe_debug_pub.add('create_flow_subassembly: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);
1585: END IF;
1586: raise FND_API.G_EXC_ERROR;
1587:
1588: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then --flow returns tatus
1589: IF PG_DEBUG <> 0 THEN
1590: oe_debug_pub.add('create_flow_subassembly: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);

Line 1588: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then --flow returns tatus

1584: oe_debug_pub.add('create_flow_subassembly: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);
1585: END IF;
1586: raise FND_API.G_EXC_ERROR;
1587:
1588: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then --flow returns tatus
1589: IF PG_DEBUG <> 0 THEN
1590: oe_debug_pub.add('create_flow_subassembly: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);
1591: END IF;
1592: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1592: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1588: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then --flow returns tatus
1589: IF PG_DEBUG <> 0 THEN
1590: oe_debug_pub.add('create_flow_subassembly: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);
1591: END IF;
1592: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1593:
1594: else --flow return status
1595: IF PG_DEBUG <> 0 THEN
1596: oe_debug_pub.add('create_flow_subassembly: ' || 'Success in Process Flow Schedule.');

Line 1735: when FND_API.G_EXC_ERROR then

1731: end if; --flow return status
1732:
1733: EXCEPTION
1734:
1735: when FND_API.G_EXC_ERROR then
1736:
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738: x_error_message := 'CTOSUBSB.create_flow_subassembly expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1739: substrb(sqlerrm,1,100);

Line 1737: x_return_status := FND_API.G_RET_STS_ERROR;

1733: EXCEPTION
1734:
1735: when FND_API.G_EXC_ERROR then
1736:
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738: x_error_message := 'CTOSUBSB.create_flow_subassembly expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1739: substrb(sqlerrm,1,100);
1740:
1741:

Line 1749: when FND_API.G_EXC_UNEXPECTED_ERROR then

1745: END IF;
1746: END IF;
1747:
1748:
1749: when FND_API.G_EXC_UNEXPECTED_ERROR then
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: x_error_message := 'CTOSUBSB.create_flow_subassembly UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1752: substrb(sqlerrm,1,100);
1753:

Line 1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1746: END IF;
1747:
1748:
1749: when FND_API.G_EXC_UNEXPECTED_ERROR then
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: x_error_message := 'CTOSUBSB.create_flow_subassembly UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1752: substrb(sqlerrm,1,100);
1753:
1754:

Line 1764: x_return_status := FND_API.G_RET_STS_ERROR;

1760:
1761:
1762:
1763: when OTHERS then
1764: x_return_status := FND_API.G_RET_STS_ERROR;
1765: x_error_message := 'CTOSUBSB.create_flow_subassembly OTHERS excpn: ' || to_char(l_stmt_num)|| ':' ||
1766: substrb(sqlerrm,1,100);
1767:
1768: IF PG_DEBUG <> 0 THEN

Line 2123: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2119: l_routing_count_sa number := 0; --Bugfix 14157494
2120:
2121: BEGIN
2122:
2123: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2124:
2125:
2126: If PG_DEBUG <> 0 Then
2127: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Inside create sub-assembly jobs');

Line 2350: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2346:
2347: );
2348: l_stmt_num := 19100;
2349:
2350: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2351: IF PG_DEBUG <> 0 THEN
2352: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_child_configurations with status ' || l_return_status ,1);
2353:
2354: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2356: RAISE FND_API.G_EXC_ERROR;

2352: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_child_configurations with status ' || l_return_status ,1);
2353:
2354: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2355: END IF;
2356: RAISE FND_API.G_EXC_ERROR;
2357: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2358: IF PG_DEBUG <> 0 THEN
2359: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_child_configurations ' || l_return_status ,1);
2360:

Line 2357: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2353:
2354: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2355: END IF;
2356: RAISE FND_API.G_EXC_ERROR;
2357: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2358: IF PG_DEBUG <> 0 THEN
2359: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_child_configurations ' || l_return_status ,1);
2360:
2361: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2359: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_child_configurations ' || l_return_status ,1);
2360:
2361: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2362: END IF;
2363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2364: ELSE
2365: IF PG_DEBUG <> 0 THEN
2366: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_child_configurations ' ,1);
2367: END IF;

Line 2529: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2525: x_message_name => l_msg_name
2526: );
2527:
2528:
2529: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2530: IF PG_DEBUG <> 0 THEN
2531: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2532:
2533: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2535: RAISE FND_API.G_EXC_ERROR;

2531: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2532:
2533: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2534: END IF;
2535: RAISE FND_API.G_EXC_ERROR;
2536: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2537: IF PG_DEBUG <> 0 THEN
2538: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2539:

Line 2536: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2532:
2533: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2534: END IF;
2535: RAISE FND_API.G_EXC_ERROR;
2536: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2537: IF PG_DEBUG <> 0 THEN
2538: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2539:
2540: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);

Line 2542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2538: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2539:
2540: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);
2541: END IF;
2542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2543: ELSE
2544: IF PG_DEBUG <> 0 THEN
2545: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_start_date ' ,1);
2546: END IF;

Line 2605: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2601:
2602:
2603:
2604:
2605: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2606: IF PG_DEBUG <> 0 THEN
2607: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get-completion_date with status ' || l_return_status ,1);
2608:
2609: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2611: RAISE FND_API.G_EXC_ERROR;

2607: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get-completion_date with status ' || l_return_status ,1);
2608:
2609: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2610: END IF;
2611: RAISE FND_API.G_EXC_ERROR;
2612: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2613: IF PG_DEBUG <> 0 THEN
2614: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_completion_date ' || l_return_status ,1);
2615:

Line 2612: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2608:
2609: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2610: END IF;
2611: RAISE FND_API.G_EXC_ERROR;
2612: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2613: IF PG_DEBUG <> 0 THEN
2614: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_completion_date ' || l_return_status ,1);
2615:
2616: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2614: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_completion_date ' || l_return_status ,1);
2615:
2616: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2617: END IF;
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2619: ELSE
2620: IF PG_DEBUG <> 0 THEN
2621: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_completion_date ' ,1);
2622: oe_debug_pub.add('create_subassembly_jobs: ' || 'parent_start_date '|| to_char(x_parent_job_start_date,'mm/dd/yy hh:mi:ss') ,1);

Line 2671: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2667: x_error_message => l_error_messsage,
2668: x_message_name => l_msg_name
2669: );
2670:
2671: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2672: IF PG_DEBUG <> 0 THEN
2673: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2674:
2675: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2677: RAISE FND_API.G_EXC_ERROR;

2673: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2674:
2675: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2676: END IF;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2679: IF PG_DEBUG <> 0 THEN
2680: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2681:

Line 2678: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2674:
2675: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2676: END IF;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2679: IF PG_DEBUG <> 0 THEN
2680: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2681:
2682: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);

Line 2684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2680: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2681:
2682: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);
2683: END IF;
2684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2685: ELSE
2686: IF PG_DEBUG <> 0 THEN
2687: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_start_date ' ,1);
2688: END IF;

Line 2773: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2769: x_message_name => l_msg_name
2770:
2771: );
2772:
2773: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2774: IF PG_DEBUG <> 0 THEN
2775: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to create_flow_subassembly with status ' || l_return_status ,1);
2776:
2777: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2779: RAISE FND_API.G_EXC_ERROR;

2775: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to create_flow_subassembly with status ' || l_return_status ,1);
2776:
2777: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2778: END IF;
2779: RAISE FND_API.G_EXC_ERROR;
2780: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2781: IF PG_DEBUG <> 0 THEN
2782: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to create_flow_subassembly ' || l_return_status ,1);
2783:

Line 2780: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2776:
2777: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2778: END IF;
2779: RAISE FND_API.G_EXC_ERROR;
2780: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2781: IF PG_DEBUG <> 0 THEN
2782: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to create_flow_subassembly ' || l_return_status ,1);
2783:
2784: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2782: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to create_flow_subassembly ' || l_return_status ,1);
2783:
2784: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2785: END IF;
2786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2787: ELSE
2788:
2789: IF PG_DEBUG <> 0 THEN
2790: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from create_flow_subassembly ' ,1);

Line 2992: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2988: );
2989:
2990: end if;
2991:
2992: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2993: IF PG_DEBUG <> 0 THEN
2994: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after get_wroking_day' || l_return_status ,1);
2995:
2996: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2998: RAISE FND_API.G_EXC_ERROR;

2994: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after get_wroking_day' || l_return_status ,1);
2995:
2996: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2997: END IF;
2998: RAISE FND_API.G_EXC_ERROR;
2999: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3000: IF PG_DEBUG <> 0 THEN
3001: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_working_day' || l_return_status ,1);
3002:

Line 2999: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2995:
2996: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2997: END IF;
2998: RAISE FND_API.G_EXC_ERROR;
2999: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3000: IF PG_DEBUG <> 0 THEN
3001: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_working_day' || l_return_status ,1);
3002:
3003: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3001: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_working_day' || l_return_status ,1);
3002:
3003: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
3004: END IF;
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: ELSE
3007:
3008: IF PG_DEBUG <> 0 THEN
3009: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_working_day ' ,1);

Line 3096: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

3092: x_error_message => l_error_messsage,
3093: x_message_name => l_msg_name
3094: );
3095:
3096: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3097: IF PG_DEBUG <> 0 THEN
3098: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
3099:
3100: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 3102: RAISE FND_API.G_EXC_ERROR;

3098: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
3099:
3100: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
3101: END IF;
3102: RAISE FND_API.G_EXC_ERROR;
3103: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3104: IF PG_DEBUG <> 0 THEN
3105: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
3106:

Line 3103: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3099:
3100: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
3101: END IF;
3102: RAISE FND_API.G_EXC_ERROR;
3103: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3104: IF PG_DEBUG <> 0 THEN
3105: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
3106:
3107: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);

Line 3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3105: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
3106:
3107: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);
3108: END IF;
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: ELSE
3111: IF PG_DEBUG <> 0 THEN
3112: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_start_date ' ,1);
3113: END IF;

Line 3349: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status

3345: p_req_interface_input_data => l_req_input_data,
3346: x_return_status =>x_return_status );
3347:
3348: --change this varname from x_reaturn status to somethinelse
3349: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3350: RAISE FND_API.G_EXC_ERROR;
3351: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3353: ELSE

Line 3350: RAISE FND_API.G_EXC_ERROR;

3346: x_return_status =>x_return_status );
3347:
3348: --change this varname from x_reaturn status to somethinelse
3349: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3350: RAISE FND_API.G_EXC_ERROR;
3351: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3353: ELSE
3354:

Line 3351: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status

3347:
3348: --change this varname from x_reaturn status to somethinelse
3349: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3350: RAISE FND_API.G_EXC_ERROR;
3351: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3353: ELSE
3354:
3355: IF PG_DEBUG <> 0 THEN

Line 3352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3348: --change this varname from x_reaturn status to somethinelse
3349: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3350: RAISE FND_API.G_EXC_ERROR;
3351: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3353: ELSE
3354:
3355: IF PG_DEBUG <> 0 THEN
3356: oe_debug_pub.add('create_subassembly_jobs: ' || 'Req Insert successful for '|| l_mlsupply_items(l_index).item_id ,1);

Line 3515: x_return_status := FND_API.G_RET_STS_SUCCESS;

3511: oe_debug_pub.add('create_subassembly_jobs: ' || 'Number of Rows Inserted in WJSI for children : ' || to_char(cnt_wjsi));
3512:
3513: oe_debug_pub.add('create_subassembly_jobs: ' || 'GROUP ID Inserted in WJSI for children : ' || x_groupID);
3514: END IF;
3515: x_return_status := FND_API.G_RET_STS_SUCCESS;
3516: else
3517: x_return_status := FND_API.G_RET_STS_ERROR;
3518: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
3519:

Line 3517: x_return_status := FND_API.G_RET_STS_ERROR;

3513: oe_debug_pub.add('create_subassembly_jobs: ' || 'GROUP ID Inserted in WJSI for children : ' || x_groupID);
3514: END IF;
3515: x_return_status := FND_API.G_RET_STS_SUCCESS;
3516: else
3517: x_return_status := FND_API.G_RET_STS_ERROR;
3518: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
3519:
3520: end if;
3521:

Line 3733: x_retVal := FND_API.G_RET_STS_ERROR;

3729:
3730:
3731:
3732: if(l_requestId = 0) then --conc. req not spawned
3733: x_retVal := FND_API.G_RET_STS_ERROR;
3734: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
3735: fnd_message.set_token('ERROR_TEXT', 'WICMLP');
3736: x_errMsg := fnd_message.get;
3737: ROLLBACK TO REBUILD;

Line 3772: when FND_API.G_EXC_ERROR then

3768:
3769:
3770:
3771: EXCEPTION
3772: when FND_API.G_EXC_ERROR then
3773:
3774: x_return_status := FND_API.G_RET_STS_ERROR;
3775: --Bugfix 8913125
3776: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);

Line 3774: x_return_status := FND_API.G_RET_STS_ERROR;

3770:
3771: EXCEPTION
3772: when FND_API.G_EXC_ERROR then
3773:
3774: x_return_status := FND_API.G_RET_STS_ERROR;
3775: --Bugfix 8913125
3776: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
3777:
3778: IF PG_DEBUG <> 0 THEN

Line 3783: when FND_API.G_EXC_UNEXPECTED_ERROR then

3779: oe_debug_pub.add('create_subassembly_jobs: ' || 'CTOSUBSB.create_sub_assembly_jobs expected excpn: ' || x_error_message,1);
3780: END IF;
3781:
3782:
3783: when FND_API.G_EXC_UNEXPECTED_ERROR then
3784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3785: --Bugfix 8913125
3786: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
3787:

Line 3784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3780: END IF;
3781:
3782:
3783: when FND_API.G_EXC_UNEXPECTED_ERROR then
3784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3785: --Bugfix 8913125
3786: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
3787:
3788: IF PG_DEBUG <> 0 THEN

Line 3794: x_return_status := FND_API.G_RET_STS_ERROR;

3790: END IF;
3791:
3792:
3793: when OTHERS then
3794: x_return_status := FND_API.G_RET_STS_ERROR;
3795: --Bugfix 8913125
3796: x_error_message := to_char(l_stmt_num)|| ': ' || substrb(sqlerrm,1,50);
3797:
3798: IF PG_DEBUG <> 0 THEN

Line 4061: when FND_API.G_EXC_ERROR then

4057: END IF;
4058:
4059:
4060: EXCEPTION
4061: when FND_API.G_EXC_ERROR then
4062:
4063: x_return_status := FND_API.G_RET_STS_ERROR;
4064: x_error_message := 'CTOSUBSB.process_phantoms expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4065: substrb(sqlerrm,1,100);

Line 4063: x_return_status := FND_API.G_RET_STS_ERROR;

4059:
4060: EXCEPTION
4061: when FND_API.G_EXC_ERROR then
4062:
4063: x_return_status := FND_API.G_RET_STS_ERROR;
4064: x_error_message := 'CTOSUBSB.process_phantoms expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4065: substrb(sqlerrm,1,100);
4066:
4067:

Line 4075: when FND_API.G_EXC_UNEXPECTED_ERROR then

4071: END IF;
4072: END IF;
4073:
4074:
4075: when FND_API.G_EXC_UNEXPECTED_ERROR then
4076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4077: x_error_message := 'CTOSUBSB.process_phantoms UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4078: substrb(sqlerrm,1,100);
4079:

Line 4076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4072: END IF;
4073:
4074:
4075: when FND_API.G_EXC_UNEXPECTED_ERROR then
4076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4077: x_error_message := 'CTOSUBSB.process_phantoms UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4078: substrb(sqlerrm,1,100);
4079:
4080:

Line 4090: x_return_status := FND_API.G_RET_STS_ERROR;

4086:
4087:
4088:
4089: when OTHERS then
4090: x_return_status := FND_API.G_RET_STS_ERROR;
4091: x_error_message := 'CTOSUBSB.process_phantoms OTHERS excpn: ' || to_char(l_stmt_num)|| ':' ||
4092: substrb(sqlerrm,1,100);
4093:
4094: IF PG_DEBUG <> 0 THEN