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 992: x_return_status := FND_API.G_RET_STS_SUCCESS ;

988: l_recurred_item_flag number;
989:
990: BEGIN
991:
992: x_return_status := FND_API.G_RET_STS_SUCCESS ;
993:
994: IF pLower_Supplytype = 2 THEN
995:
996: IF PG_DEBUG <> 0 THEN

Line 1068: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1064: X_exp_error_code => v_exp_error_code,
1065: X_return_status =>x_return_status
1066: );
1067:
1068: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1069: IF PG_DEBUG <> 0 THEN
1070: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1071: END IF;
1072: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1073: RAISE FND_API.G_EXC_ERROR;

1069: IF PG_DEBUG <> 0 THEN
1070: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1071: END IF;
1072: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1075: IF PG_DEBUG <> 0 THEN
1076: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1077: END IF;

Line 1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1070: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1071: END IF;
1072: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1075: IF PG_DEBUG <> 0 THEN
1076: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1077: END IF;
1078: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1075: IF PG_DEBUG <> 0 THEN
1076: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1077: END IF;
1078: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: ELSE
1081:
1082: IF PG_DEBUG <> 0 THEN
1083: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

Line 1269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1265: X_return_status =>x_return_status
1266: );
1267:
1268:
1269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1270: IF PG_DEBUG <> 0 THEN
1271: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1272: END IF;
1273: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1274: RAISE FND_API.G_EXC_ERROR;

1270: IF PG_DEBUG <> 0 THEN
1271: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1272: END IF;
1273: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1274: RAISE FND_API.G_EXC_ERROR;
1275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1276: IF PG_DEBUG <> 0 THEN
1277: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1278: END IF;

Line 1275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1271: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1272: END IF;
1273: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1274: RAISE FND_API.G_EXC_ERROR;
1275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1276: IF PG_DEBUG <> 0 THEN
1277: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1278: END IF;
1279: --oe_debug_pub.add ('error message' || l_error_msg ,1);

Line 1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1276: IF PG_DEBUG <> 0 THEN
1277: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1278: END IF;
1279: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: ELSE
1282:
1283: IF PG_DEBUG <> 0 THEN
1284: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

Line 1392: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

1388: x_message_name => l_msg_name
1389:
1390: );
1391:
1392: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
1393: IF PG_DEBUG <> 0 THEN
1394: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to get_child_configurations with status ' || l_ret_status ,1);
1395:
1396: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);

Line 1398: RAISE FND_API.G_EXC_ERROR;

1394: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to get_child_configurations with status ' || l_ret_status ,1);
1395:
1396: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);
1397: END IF;
1398: RAISE FND_API.G_EXC_ERROR;
1399: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1400: IF PG_DEBUG <> 0 THEN
1401: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to get_child_configurations ' || l_ret_status ,1);
1402:

Line 1399: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1395:
1396: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);
1397: END IF;
1398: RAISE FND_API.G_EXC_ERROR;
1399: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1400: IF PG_DEBUG <> 0 THEN
1401: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to get_child_configurations ' || l_ret_status ,1);
1402:
1403: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);

Line 1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1401: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to get_child_configurations ' || l_ret_status ,1);
1402:
1403: oe_debug_pub.add ('get_child_configurations: ' || 'error message' || l_error_message ,1);
1404: END IF;
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: ELSE
1407:
1408: IF PG_DEBUG <> 0 THEN
1409: oe_debug_pub.add('get_child_configurations: ' || 'success from get_child_configurations ' ,1);

Line 1429: when FND_API.G_EXC_ERROR then

1425: END IF;
1426:
1427: EXCEPTION
1428:
1429: when FND_API.G_EXC_ERROR then
1430:
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432: x_error_message := 'CTOSUBSB.get_child_configurations expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1433: substrb(sqlerrm,1,100);

Line 1431: x_return_status := FND_API.G_RET_STS_ERROR;

1427: EXCEPTION
1428:
1429: when FND_API.G_EXC_ERROR then
1430:
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432: x_error_message := 'CTOSUBSB.get_child_configurations expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1433: substrb(sqlerrm,1,100);
1434:
1435:

Line 1443: when FND_API.G_EXC_UNEXPECTED_ERROR then

1439: END IF;
1440:
1441:
1442:
1443: when FND_API.G_EXC_UNEXPECTED_ERROR then
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: x_error_message := 'CTOSUBSB.get_child_configurations UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1446: substrb(sqlerrm,1,100);
1447:

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1440:
1441:
1442:
1443: when FND_API.G_EXC_UNEXPECTED_ERROR then
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: x_error_message := 'CTOSUBSB.get_child_configurations UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1446: substrb(sqlerrm,1,100);
1447:
1448:

Line 1459: x_return_status := FND_API.G_RET_STS_ERROR;

1455:
1456:
1457:
1458: when OTHERS then
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: x_error_message := 'CTOSUBSB.get_start_date OTHERS excpn: ' || to_char(l_stmt_num)|| ':' ||
1461: substrb(sqlerrm,1,100);
1462:
1463:

Line 1512: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1508: l_x_value varchar2(1);
1509:
1510: BEGIN
1511:
1512: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1513:
1514: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_CREATE;
1515: l_flow_schedule_rec.scheduled_flag := 1;
1516:

Line 1532: p_init_msg_list => FND_API.G_TRUE,

1528:
1529: l_stmt_num := 90;
1530: MRP_Flow_Schedule_PUB.Process_Flow_Schedule(
1531: p_api_version_number => 1.0,
1532: p_init_msg_list => FND_API.G_TRUE,
1533: x_return_status => l_return_status,
1534: x_msg_count => l_msg_count,
1535: x_msg_data => l_msg_data,
1536: p_flow_schedule_rec => l_flow_schedule_rec,

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

1540:
1541:
1542:
1543:
1544: if (l_return_status = FND_API.G_RET_STS_ERROR) then --flow return status
1545: IF PG_DEBUG <> 0 THEN
1546: oe_debug_pub.add('create_flow_subassembly: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);
1547: END IF;
1548: raise FND_API.G_EXC_ERROR;

Line 1548: raise FND_API.G_EXC_ERROR;

1544: if (l_return_status = FND_API.G_RET_STS_ERROR) then --flow return status
1545: IF PG_DEBUG <> 0 THEN
1546: oe_debug_pub.add('create_flow_subassembly: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);
1547: END IF;
1548: raise FND_API.G_EXC_ERROR;
1549:
1550: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then --flow returns tatus
1551: IF PG_DEBUG <> 0 THEN
1552: oe_debug_pub.add('create_flow_subassembly: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);

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

1546: oe_debug_pub.add('create_flow_subassembly: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);
1547: END IF;
1548: raise FND_API.G_EXC_ERROR;
1549:
1550: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then --flow returns tatus
1551: IF PG_DEBUG <> 0 THEN
1552: oe_debug_pub.add('create_flow_subassembly: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);
1553: END IF;
1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1550: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then --flow returns tatus
1551: IF PG_DEBUG <> 0 THEN
1552: oe_debug_pub.add('create_flow_subassembly: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);
1553: END IF;
1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1555:
1556: else --flow return status
1557: IF PG_DEBUG <> 0 THEN
1558: oe_debug_pub.add('create_flow_subassembly: ' || 'Success in Process Flow Schedule.');

Line 1697: when FND_API.G_EXC_ERROR then

1693: end if; --flow return status
1694:
1695: EXCEPTION
1696:
1697: when FND_API.G_EXC_ERROR then
1698:
1699: x_return_status := FND_API.G_RET_STS_ERROR;
1700: x_error_message := 'CTOSUBSB.create_flow_subassembly expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1701: substrb(sqlerrm,1,100);

Line 1699: x_return_status := FND_API.G_RET_STS_ERROR;

1695: EXCEPTION
1696:
1697: when FND_API.G_EXC_ERROR then
1698:
1699: x_return_status := FND_API.G_RET_STS_ERROR;
1700: x_error_message := 'CTOSUBSB.create_flow_subassembly expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1701: substrb(sqlerrm,1,100);
1702:
1703:

Line 1711: when FND_API.G_EXC_UNEXPECTED_ERROR then

1707: END IF;
1708: END IF;
1709:
1710:
1711: when FND_API.G_EXC_UNEXPECTED_ERROR then
1712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1713: x_error_message := 'CTOSUBSB.create_flow_subassembly UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1714: substrb(sqlerrm,1,100);
1715:

Line 1712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1708: END IF;
1709:
1710:
1711: when FND_API.G_EXC_UNEXPECTED_ERROR then
1712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1713: x_error_message := 'CTOSUBSB.create_flow_subassembly UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
1714: substrb(sqlerrm,1,100);
1715:
1716:

Line 1726: x_return_status := FND_API.G_RET_STS_ERROR;

1722:
1723:
1724:
1725: when OTHERS then
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: x_error_message := 'CTOSUBSB.create_flow_subassembly OTHERS excpn: ' || to_char(l_stmt_num)|| ':' ||
1728: substrb(sqlerrm,1,100);
1729:
1730: IF PG_DEBUG <> 0 THEN

Line 2115: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2111: l_phantom varchar2(1);
2112:
2113: BEGIN
2114:
2115: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2116:
2117:
2118: If PG_DEBUG <> 0 Then
2119: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Inside create sub-assembly jobs');

Line 2340: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2336: x_message_name => l_msg_name
2337:
2338: );
2339:
2340: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2341: IF PG_DEBUG <> 0 THEN
2342: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_child_configurations with status ' || l_return_status ,1);
2343:
2344: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2346: RAISE FND_API.G_EXC_ERROR;

2342: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_child_configurations with status ' || l_return_status ,1);
2343:
2344: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2345: END IF;
2346: RAISE FND_API.G_EXC_ERROR;
2347: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2348: IF PG_DEBUG <> 0 THEN
2349: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_child_configurations ' || l_return_status ,1);
2350:

Line 2347: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2343:
2344: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2345: END IF;
2346: RAISE FND_API.G_EXC_ERROR;
2347: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2348: IF PG_DEBUG <> 0 THEN
2349: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_child_configurations ' || l_return_status ,1);
2350:
2351: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2349: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_child_configurations ' || l_return_status ,1);
2350:
2351: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2352: END IF;
2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2354: ELSE
2355: IF PG_DEBUG <> 0 THEN
2356: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_child_configurations ' ,1);
2357: END IF;

Line 2516: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2512: x_message_name => l_msg_name
2513: );
2514:
2515:
2516: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2517: IF PG_DEBUG <> 0 THEN
2518: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2519:
2520: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2522: RAISE FND_API.G_EXC_ERROR;

2518: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2519:
2520: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2521: END IF;
2522: RAISE FND_API.G_EXC_ERROR;
2523: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2524: IF PG_DEBUG <> 0 THEN
2525: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2526:

Line 2523: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2519:
2520: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2521: END IF;
2522: RAISE FND_API.G_EXC_ERROR;
2523: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2524: IF PG_DEBUG <> 0 THEN
2525: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2526:
2527: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);

Line 2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2525: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2526:
2527: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);
2528: END IF;
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: ELSE
2531: IF PG_DEBUG <> 0 THEN
2532: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_start_date ' ,1);
2533: END IF;

Line 2592: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2588:
2589:
2590:
2591:
2592: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2593: IF PG_DEBUG <> 0 THEN
2594: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get-completion_date with status ' || l_return_status ,1);
2595:
2596: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2598: RAISE FND_API.G_EXC_ERROR;

2594: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get-completion_date with status ' || l_return_status ,1);
2595:
2596: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;
2599: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2600: IF PG_DEBUG <> 0 THEN
2601: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_completion_date ' || l_return_status ,1);
2602:

Line 2599: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2595:
2596: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;
2599: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2600: IF PG_DEBUG <> 0 THEN
2601: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_completion_date ' || l_return_status ,1);
2602:
2603: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2601: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_completion_date ' || l_return_status ,1);
2602:
2603: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2604: END IF;
2605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2606: ELSE
2607: IF PG_DEBUG <> 0 THEN
2608: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_completion_date ' ,1);
2609: 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 2658: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2654: x_error_message => l_error_messsage,
2655: x_message_name => l_msg_name
2656: );
2657:
2658: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2659: IF PG_DEBUG <> 0 THEN
2660: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2661:
2662: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2664: RAISE FND_API.G_EXC_ERROR;

2660: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
2661:
2662: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2663: END IF;
2664: RAISE FND_API.G_EXC_ERROR;
2665: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2666: IF PG_DEBUG <> 0 THEN
2667: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2668:

Line 2665: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2661:
2662: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2663: END IF;
2664: RAISE FND_API.G_EXC_ERROR;
2665: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2666: IF PG_DEBUG <> 0 THEN
2667: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2668:
2669: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);

Line 2671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2667: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
2668:
2669: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);
2670: END IF;
2671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2672: ELSE
2673: IF PG_DEBUG <> 0 THEN
2674: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_start_date ' ,1);
2675: END IF;

Line 2760: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2756: x_message_name => l_msg_name
2757:
2758: );
2759:
2760: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2761: IF PG_DEBUG <> 0 THEN
2762: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to create_flow_subassembly with status ' || l_return_status ,1);
2763:
2764: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2766: RAISE FND_API.G_EXC_ERROR;

2762: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to create_flow_subassembly with status ' || l_return_status ,1);
2763:
2764: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2765: END IF;
2766: RAISE FND_API.G_EXC_ERROR;
2767: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2768: IF PG_DEBUG <> 0 THEN
2769: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to create_flow_subassembly ' || l_return_status ,1);
2770:

Line 2767: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2763:
2764: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2765: END IF;
2766: RAISE FND_API.G_EXC_ERROR;
2767: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2768: IF PG_DEBUG <> 0 THEN
2769: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to create_flow_subassembly ' || l_return_status ,1);
2770:
2771: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2769: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to create_flow_subassembly ' || l_return_status ,1);
2770:
2771: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2772: END IF;
2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2774: ELSE
2775:
2776: IF PG_DEBUG <> 0 THEN
2777: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from create_flow_subassembly ' ,1);

Line 2979: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

2975: );
2976:
2977: end if;
2978:
2979: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2980: IF PG_DEBUG <> 0 THEN
2981: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after get_wroking_day' || l_return_status ,1);
2982:
2983: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2985: RAISE FND_API.G_EXC_ERROR;

2981: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after get_wroking_day' || l_return_status ,1);
2982:
2983: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2984: END IF;
2985: RAISE FND_API.G_EXC_ERROR;
2986: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2987: IF PG_DEBUG <> 0 THEN
2988: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_working_day' || l_return_status ,1);
2989:

Line 2986: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2982:
2983: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2984: END IF;
2985: RAISE FND_API.G_EXC_ERROR;
2986: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2987: IF PG_DEBUG <> 0 THEN
2988: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_working_day' || l_return_status ,1);
2989:
2990: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2988: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_working_day' || l_return_status ,1);
2989:
2990: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
2991: END IF;
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2993: ELSE
2994:
2995: IF PG_DEBUG <> 0 THEN
2996: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_working_day ' ,1);

Line 3083: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

3079: x_error_message => l_error_messsage,
3080: x_message_name => l_msg_name
3081: );
3082:
3083: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3084: IF PG_DEBUG <> 0 THEN
3085: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
3086:
3087: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);

Line 3089: RAISE FND_API.G_EXC_ERROR;

3085: oe_debug_pub.add ('create_subassembly_jobs: ' || 'failed after call to get_start_date with status ' || l_return_status ,1);
3086:
3087: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
3088: END IF;
3089: RAISE FND_API.G_EXC_ERROR;
3090: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3091: IF PG_DEBUG <> 0 THEN
3092: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
3093:

Line 3090: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3086:
3087: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage ,1);
3088: END IF;
3089: RAISE FND_API.G_EXC_ERROR;
3090: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3091: IF PG_DEBUG <> 0 THEN
3092: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
3093:
3094: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);

Line 3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3092: oe_debug_pub.add ('create_subassembly_jobs: ' || ' failed after call to get_start_date ' || l_return_status ,1);
3093:
3094: oe_debug_pub.add ('create_subassembly_jobs: ' || 'error message' || l_error_messsage,1);
3095: END IF;
3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3097: ELSE
3098: IF PG_DEBUG <> 0 THEN
3099: oe_debug_pub.add('create_subassembly_jobs: ' || 'success from get_start_date ' ,1);
3100: END IF;

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

3332: p_req_interface_input_data => l_req_input_data,
3333: x_return_status =>x_return_status );
3334:
3335: --change this varname from x_reaturn status to somethinelse
3336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3337: RAISE FND_API.G_EXC_ERROR;
3338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: ELSE

Line 3337: RAISE FND_API.G_EXC_ERROR;

3333: x_return_status =>x_return_status );
3334:
3335: --change this varname from x_reaturn status to somethinelse
3336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3337: RAISE FND_API.G_EXC_ERROR;
3338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: ELSE
3341:

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

3334:
3335: --change this varname from x_reaturn status to somethinelse
3336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3337: RAISE FND_API.G_EXC_ERROR;
3338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: ELSE
3341:
3342: IF PG_DEBUG <> 0 THEN

Line 3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3335: --change this varname from x_reaturn status to somethinelse
3336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN --po return status
3337: RAISE FND_API.G_EXC_ERROR;
3338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --po return status
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: ELSE
3341:
3342: IF PG_DEBUG <> 0 THEN
3343: oe_debug_pub.add('create_subassembly_jobs: ' || 'Req Insert successful for '|| l_mlsupply_items(l_index).item_id ,1);

Line 3481: x_return_status := FND_API.G_RET_STS_SUCCESS;

3477: oe_debug_pub.add('create_subassembly_jobs: ' || 'Number of Rows Inserted in WJSI for children : ' || to_char(SQL%ROWCOUNT));
3478:
3479: oe_debug_pub.add('create_subassembly_jobs: ' || 'GROUP ID Inserted in WJSI for children : ' || x_groupID);
3480: END IF;
3481: x_return_status := FND_API.G_RET_STS_SUCCESS;
3482: else
3483: x_return_status := FND_API.G_RET_STS_ERROR;
3484: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
3485:

Line 3483: x_return_status := FND_API.G_RET_STS_ERROR;

3479: oe_debug_pub.add('create_subassembly_jobs: ' || 'GROUP ID Inserted in WJSI for children : ' || x_groupID);
3480: END IF;
3481: x_return_status := FND_API.G_RET_STS_SUCCESS;
3482: else
3483: x_return_status := FND_API.G_RET_STS_ERROR;
3484: cto_msg_pub.cto_message('BOM', 'BOM_ATO_PROCESS_ERROR');
3485:
3486: end if;
3487:

Line 3697: x_retVal := FND_API.G_RET_STS_ERROR;

3693:
3694:
3695:
3696: if(l_requestId = 0) then --conc. req not spawned
3697: x_retVal := FND_API.G_RET_STS_ERROR;
3698: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
3699: fnd_message.set_token('ERROR_TEXT', 'WICMLP');
3700: x_errMsg := fnd_message.get;
3701: ROLLBACK TO REBUILD;

Line 3734: when FND_API.G_EXC_ERROR then

3730:
3731:
3732:
3733: EXCEPTION
3734: when FND_API.G_EXC_ERROR then
3735:
3736: x_return_status := FND_API.G_RET_STS_ERROR;
3737: x_error_message := 'CTOSUBSB.create_sub_assembly_jobs expected excpn: ' || to_char(l_stmt_num)|| ':' ||
3738: substrb(sqlerrm,1,100) ;

Line 3736: x_return_status := FND_API.G_RET_STS_ERROR;

3732:
3733: EXCEPTION
3734: when FND_API.G_EXC_ERROR then
3735:
3736: x_return_status := FND_API.G_RET_STS_ERROR;
3737: x_error_message := 'CTOSUBSB.create_sub_assembly_jobs expected excpn: ' || to_char(l_stmt_num)|| ':' ||
3738: substrb(sqlerrm,1,100) ;
3739:
3740:

Line 3747: when FND_API.G_EXC_UNEXPECTED_ERROR then

3743: END IF;
3744:
3745:
3746:
3747: when FND_API.G_EXC_UNEXPECTED_ERROR then
3748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3749: x_error_message := 'CTOSUBSB.create_sub_assembly_jobs UN expected excpn: ' || ':' ||
3750: substrb(sqlerrm,1,100);
3751:

Line 3748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3744:
3745:
3746:
3747: when FND_API.G_EXC_UNEXPECTED_ERROR then
3748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3749: x_error_message := 'CTOSUBSB.create_sub_assembly_jobs UN expected excpn: ' || ':' ||
3750: substrb(sqlerrm,1,100);
3751:
3752:

Line 3761: x_return_status := FND_API.G_RET_STS_ERROR;

3757:
3758:
3759:
3760: when OTHERS then
3761: x_return_status := FND_API.G_RET_STS_ERROR;
3762: x_error_message := 'CTOSUBSB.create_sub_assembly_jobs OTHERS excpn: ' || to_char(l_stmt_num) || ':' ||
3763: substrb(sqlerrm,1,100);
3764:
3765:

Line 4021: when FND_API.G_EXC_ERROR then

4017: END IF;
4018:
4019:
4020: EXCEPTION
4021: when FND_API.G_EXC_ERROR then
4022:
4023: x_return_status := FND_API.G_RET_STS_ERROR;
4024: x_error_message := 'CTOSUBSB.process_phantoms expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4025: substrb(sqlerrm,1,100);

Line 4023: x_return_status := FND_API.G_RET_STS_ERROR;

4019:
4020: EXCEPTION
4021: when FND_API.G_EXC_ERROR then
4022:
4023: x_return_status := FND_API.G_RET_STS_ERROR;
4024: x_error_message := 'CTOSUBSB.process_phantoms expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4025: substrb(sqlerrm,1,100);
4026:
4027:

Line 4035: when FND_API.G_EXC_UNEXPECTED_ERROR then

4031: END IF;
4032: END IF;
4033:
4034:
4035: when FND_API.G_EXC_UNEXPECTED_ERROR then
4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4037: x_error_message := 'CTOSUBSB.process_phantoms UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4038: substrb(sqlerrm,1,100);
4039:

Line 4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4032: END IF;
4033:
4034:
4035: when FND_API.G_EXC_UNEXPECTED_ERROR then
4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4037: x_error_message := 'CTOSUBSB.process_phantoms UN expected excpn: ' || to_char(l_stmt_num)|| ':' ||
4038: substrb(sqlerrm,1,100);
4039:
4040:

Line 4050: x_return_status := FND_API.G_RET_STS_ERROR;

4046:
4047:
4048:
4049: when OTHERS then
4050: x_return_status := FND_API.G_RET_STS_ERROR;
4051: x_error_message := 'CTOSUBSB.process_phantoms OTHERS excpn: ' || to_char(l_stmt_num)|| ':' ||
4052: substrb(sqlerrm,1,100);
4053:
4054: IF PG_DEBUG <> 0 THEN