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

Line 258: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

254: x_return_status,
255: x_msg_count,
256: x_msg_data);
257:
258: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
259: IF PG_DEBUG <> 0 THEN
260: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
261: END IF;
262: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 262: raise FND_API.G_EXC_UNEXPECTED_ERROR;

258: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
259: IF PG_DEBUG <> 0 THEN
260: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
261: END IF;
262: raise FND_API.G_EXC_UNEXPECTED_ERROR;
263:
264: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
265: IF PG_DEBUG <> 0 THEN
266: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);

Line 264: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN

260: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
261: END IF;
262: raise FND_API.G_EXC_UNEXPECTED_ERROR;
263:
264: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
265: IF PG_DEBUG <> 0 THEN
266: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
267: END IF;
268: raise FND_API.G_EXC_ERROR;

Line 268: raise FND_API.G_EXC_ERROR;

264: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
265: IF PG_DEBUG <> 0 THEN
266: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
267: END IF;
268: raise FND_API.G_EXC_ERROR;
269: END IF;
270: IF PG_DEBUG <> 0 THEN
271: oe_debug_pub.add('populate_plan_level: ' || 'after calling GAIO::lStatus::'||to_char(lStatus),2);
272: END IF;

Line 302: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

298: x_return_status,
299: x_msg_count,
300: x_msg_data);
301:
302: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
303: IF PG_DEBUG <> 0 THEN
304: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
305: END IF;
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 306: raise FND_API.G_EXC_UNEXPECTED_ERROR;

302: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
303: IF PG_DEBUG <> 0 THEN
304: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
305: END IF;
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307:
308: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: IF PG_DEBUG <> 0 THEN
310: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);

Line 308: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN

304: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
305: END IF;
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307:
308: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: IF PG_DEBUG <> 0 THEN
310: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
311: END IF;
312: raise FND_API.G_EXC_ERROR;

Line 312: raise FND_API.G_EXC_ERROR;

308: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: IF PG_DEBUG <> 0 THEN
310: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
311: END IF;
312: raise FND_API.G_EXC_ERROR;
313: END IF;
314:
315: END LOOP;
316: END IF;

Line 390: if x_return_status = FND_API.G_RET_STS_ERROR then

386:
387:
388:
389:
390: if x_return_status = FND_API.G_RET_STS_ERROR then
391:
392: IF PG_DEBUG <> 0 THEN
393: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
394: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);

Line 397: raise FND_API.G_EXC_ERROR;

393: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
394: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);
395: END IF;
396:
397: raise FND_API.G_EXC_ERROR;
398:
399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
400:
401: IF PG_DEBUG <> 0 THEN

Line 399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

395: END IF;
396:
397: raise FND_API.G_EXC_ERROR;
398:
399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
400:
401: IF PG_DEBUG <> 0 THEN
402: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
403: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with unexpected error.', 1);

Line 406: raise FND_API.G_EXC_UNEXPECTED_ERROR;

402: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
403: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with unexpected error.', 1);
404: END IF;
405:
406: raise FND_API.G_EXC_UNEXPECTED_ERROR;
407:
408: end if;
409:
410: IF PG_DEBUG <> 0 THEN

Line 550: if x_return_status = FND_API.G_RET_STS_ERROR then

546: x_msg_count => x_msg_count ,
547: x_msg_data => x_msg_data );
548:
549: /* bugfix 4227127 fp for bug 4162642 :added return status check */
550: if x_return_status = FND_API.G_RET_STS_ERROR then
551:
552: if PG_DEBUG <> 0 then
553: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
554: end if;

Line 556: Raise FND_API.G_EXC_ERROR;

552: if PG_DEBUG <> 0 then
553: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
554: end if;
555:
556: Raise FND_API.G_EXC_ERROR;
557:
558: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
559:
560: if PG_DEBUG <> 0 then

Line 558: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

554: end if;
555:
556: Raise FND_API.G_EXC_ERROR;
557:
558: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
559:
560: if PG_DEBUG <> 0 then
561: oe_debug_pub.add( 'ERROR: get_other_orgs api return unexpected error' , 1 ) ;
562: end if;

Line 564: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

560: if PG_DEBUG <> 0 then
561: oe_debug_pub.add( 'ERROR: get_other_orgs api return unexpected error' , 1 ) ;
562: end if;
563:
564: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
565:
566: end if;
567:
568:

Line 588: if x_return_status = FND_API.G_RET_STS_ERROR then

584: x_return_status => x_return_status,
585: x_msg_count => x_msg_count,
586: x_msg_data => x_msg_data);
587:
588: if x_return_status = FND_API.G_RET_STS_ERROR then
589:
590: if PG_DEBUG <> 0 then
591: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
592: end if;

Line 594: Raise FND_API.G_EXC_ERROR;

590: if PG_DEBUG <> 0 then
591: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
592: end if;
593:
594: Raise FND_API.G_EXC_ERROR;
595:
596: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
597:
598: if PG_DEBUG <> 0 then

Line 596: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

592: end if;
593:
594: Raise FND_API.G_EXC_ERROR;
595:
596: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
597:
598: if PG_DEBUG <> 0 then
599: oe_debug_pub.add( 'ERROR: get_Master_orgs api return unexpected error' , 1 ) ;
600: end if;

Line 602: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

598: if PG_DEBUG <> 0 then
599: oe_debug_pub.add( 'ERROR: get_Master_orgs api return unexpected error' , 1 ) ;
600: end if;
601:
602: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
603:
604: end if;
605: If x_orgs_list.count <> 0 then
606: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId,

Line 674: when FND_API.G_EXC_UNEXPECTED_ERROR then

670: return(1);
671:
672: EXCEPTION
673:
674: when FND_API.G_EXC_UNEXPECTED_ERROR then
675: IF PG_DEBUG <> 0 THEN
676: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
677: END IF;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

674: when FND_API.G_EXC_UNEXPECTED_ERROR then
675: IF PG_DEBUG <> 0 THEN
676: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
677: END IF;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: CTO_MSG_PUB.Count_And_Get
680: (p_msg_count => x_msg_count
681: ,p_msg_data => x_msg_data
682: );

Line 685: when FND_API.G_EXC_ERROR then

681: ,p_msg_data => x_msg_data
682: );
683: return(0);
684:
685: when FND_API.G_EXC_ERROR then
686: IF PG_DEBUG <> 0 THEN
687: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
688: END IF;
689: x_return_status := FND_API.G_RET_STS_ERROR;

Line 689: x_return_status := FND_API.G_RET_STS_ERROR;

685: when FND_API.G_EXC_ERROR then
686: IF PG_DEBUG <> 0 THEN
687: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
688: END IF;
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: CTO_MSG_PUB.Count_And_Get
691: (p_msg_count => x_msg_count
692: ,p_msg_data => x_msg_data);
693: return(0);

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695: when others then
696: IF PG_DEBUG <> 0 THEN
697: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
698: END IF;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
701: FND_MSG_PUB.Add_Exc_Msg
702: (G_PKG_NAME
703: ,'populate_src_orgs'

Line 792: x_return_status := FND_API.G_RET_STS_SUCCESS;

788: x_orgs_list CTO_MSUTIL_PUB.org_list;
789:
790: BEGIN
791: --Bugfix 13362916
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: IF PG_DEBUG <> 0 THEN
795: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::pTopAtoLineId::'||to_char(pTopAtoLineId),1);
796: END IF;

Line 850: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

846: x_msg_data,
847: 'UPGRADE',
848: v_model_lines.config_item_id);
849:
850: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
851: IF PG_DEBUG <> 0 THEN
852: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
853: END IF;
854: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 854: raise FND_API.G_EXC_UNEXPECTED_ERROR;

850: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
851: IF PG_DEBUG <> 0 THEN
852: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
853: END IF;
854: raise FND_API.G_EXC_UNEXPECTED_ERROR;
855:
856: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
857: IF PG_DEBUG <> 0 THEN
858: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);

Line 856: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN

852: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
853: END IF;
854: raise FND_API.G_EXC_UNEXPECTED_ERROR;
855:
856: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
857: IF PG_DEBUG <> 0 THEN
858: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
859: END IF;
860: raise FND_API.G_EXC_ERROR;

Line 860: raise FND_API.G_EXC_ERROR;

856: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
857: IF PG_DEBUG <> 0 THEN
858: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
859: END IF;
860: raise FND_API.G_EXC_ERROR;
861: END IF;
862: IF PG_DEBUG <> 0 THEN
863: oe_debug_pub.add('populate_plan_level: ' || 'after calling GAIO::lStatus::'||to_char(lStatus),2);
864: END IF;

Line 896: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

892: x_msg_data,
893: 'UPGRADE',
894: v_model_lines.config_item_id);
895:
896: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
897: IF PG_DEBUG <> 0 THEN
898: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
899: END IF;
900: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 900: raise FND_API.G_EXC_UNEXPECTED_ERROR;

896: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
897: IF PG_DEBUG <> 0 THEN
898: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
899: END IF;
900: raise FND_API.G_EXC_UNEXPECTED_ERROR;
901:
902: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
903: IF PG_DEBUG <> 0 THEN
904: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);

Line 902: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN

898: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
899: END IF;
900: raise FND_API.G_EXC_UNEXPECTED_ERROR;
901:
902: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
903: IF PG_DEBUG <> 0 THEN
904: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
905: END IF;
906: raise FND_API.G_EXC_ERROR;

Line 906: raise FND_API.G_EXC_ERROR;

902: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
903: IF PG_DEBUG <> 0 THEN
904: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
905: END IF;
906: raise FND_API.G_EXC_ERROR;
907: END IF;
908:
909: END LOOP;
910: END IF;

Line 962: if x_return_status = FND_API.G_RET_STS_ERROR then

958:
959:
960:
961:
962: if x_return_status = FND_API.G_RET_STS_ERROR then
963:
964: IF PG_DEBUG <> 0 THEN
965: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
966: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);

Line 969: raise FND_API.G_EXC_ERROR;

965: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
966: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);
967: END IF;
968:
969: raise FND_API.G_EXC_ERROR;
970:
971: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
972:
973: IF PG_DEBUG <> 0 THEN

Line 971: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

967: END IF;
968:
969: raise FND_API.G_EXC_ERROR;
970:
971: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
972:
973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
975: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with unexpected error.', 1);

Line 978: raise FND_API.G_EXC_UNEXPECTED_ERROR;

974: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
975: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with unexpected error.', 1);
976: END IF;
977:
978: raise FND_API.G_EXC_UNEXPECTED_ERROR;
979:
980: end if;
981:
982: IF PG_DEBUG <> 0 THEN

Line 1161: if x_return_status = FND_API.G_RET_STS_ERROR then

1157: x_msg_data => x_msg_data );
1158:
1159:
1160: /* bugfix 4162642 :added return status check */
1161: if x_return_status = FND_API.G_RET_STS_ERROR then
1162:
1163: if PG_DEBUG <> 0 then
1164: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
1165: end if;

Line 1167: Raise FND_API.G_EXC_ERROR;

1163: if PG_DEBUG <> 0 then
1164: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
1165: end if;
1166:
1167: Raise FND_API.G_EXC_ERROR;
1168:
1169: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1170:
1171: if PG_DEBUG <> 0 then

Line 1169: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1165: end if;
1166:
1167: Raise FND_API.G_EXC_ERROR;
1168:
1169: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1170:
1171: if PG_DEBUG <> 0 then
1172: oe_debug_pub.add( 'ERROR: get_other_orgs api return unexpected error' , 1 ) ;
1173: end if;

Line 1175: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1171: if PG_DEBUG <> 0 then
1172: oe_debug_pub.add( 'ERROR: get_other_orgs api return unexpected error' , 1 ) ;
1173: end if;
1174:
1175: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1176:
1177: end if;
1178:
1179:

Line 1197: if x_return_status = FND_API.G_RET_STS_ERROR then

1193: x_return_status => x_return_status,
1194: x_msg_count => x_msg_count,
1195: x_msg_data => x_msg_data);
1196:
1197: if x_return_status = FND_API.G_RET_STS_ERROR then
1198:
1199: if PG_DEBUG <> 0 then
1200: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
1201: end if;

Line 1203: Raise FND_API.G_EXC_ERROR;

1199: if PG_DEBUG <> 0 then
1200: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
1201: end if;
1202:
1203: Raise FND_API.G_EXC_ERROR;
1204:
1205: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1206:
1207: if PG_DEBUG <> 0 then

Line 1205: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1201: end if;
1202:
1203: Raise FND_API.G_EXC_ERROR;
1204:
1205: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1206:
1207: if PG_DEBUG <> 0 then
1208: oe_debug_pub.add( 'ERROR: get_Master_orgs api return unexpected error' , 1 ) ;
1209: end if;

Line 1211: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1207: if PG_DEBUG <> 0 then
1208: oe_debug_pub.add( 'ERROR: get_Master_orgs api return unexpected error' , 1 ) ;
1209: end if;
1210:
1211: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1212:
1213: end if;
1214: If x_orgs_list.count <> 0 then
1215: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId,

Line 1239: when FND_API.G_EXC_UNEXPECTED_ERROR then

1235: return(1);
1236:
1237: EXCEPTION
1238:
1239: when FND_API.G_EXC_UNEXPECTED_ERROR then
1240: IF PG_DEBUG <> 0 THEN
1241: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1239: when FND_API.G_EXC_UNEXPECTED_ERROR then
1240: IF PG_DEBUG <> 0 THEN
1241: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: CTO_MSG_PUB.Count_And_Get
1245: (p_msg_count => x_msg_count
1246: ,p_msg_data => x_msg_data
1247: );

Line 1250: when FND_API.G_EXC_ERROR then

1246: ,p_msg_data => x_msg_data
1247: );
1248: return(0);
1249:
1250: when FND_API.G_EXC_ERROR then
1251: IF PG_DEBUG <> 0 THEN
1252: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
1253: END IF;
1254: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1254: x_return_status := FND_API.G_RET_STS_ERROR;

1250: when FND_API.G_EXC_ERROR then
1251: IF PG_DEBUG <> 0 THEN
1252: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
1253: END IF;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: CTO_MSG_PUB.Count_And_Get
1256: (p_msg_count => x_msg_count
1257: ,p_msg_data => x_msg_data);
1258: return(0);

Line 1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1260: when others then
1261: IF PG_DEBUG <> 0 THEN
1262: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
1263: END IF;
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1266: FND_MSG_PUB.Add_Exc_Msg
1267: (G_PKG_NAME
1268: ,'populate_src_orgs'

Line 1369: x_return_status := FND_API.G_RET_STS_SUCCESS;

1365: v_100_procured varchar2(1) := 'N' ;
1366:
1367: BEGIN
1368: --Bugfix 13362916
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;
1370:
1371: --
1372: -- pLineId is the line_id of the model line
1373: --

Line 1701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1697: , x_return_status
1698: , x_msg_count
1699: , x_msg_data );
1700:
1701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1702: IF PG_DEBUG <> 0 THEN
1703: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with unexp error',1);
1704: END IF;
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1701: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1702: IF PG_DEBUG <> 0 THEN
1703: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with unexp error',1);
1704: END IF;
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706:
1707: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1708: IF PG_DEBUG <> 0 THEN
1709: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with exp error',1);

Line 1707: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1703: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with unexp error',1);
1704: END IF;
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706:
1707: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1708: IF PG_DEBUG <> 0 THEN
1709: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with exp error',1);
1710: END IF;
1711: raise FND_API.G_EXC_ERROR;

Line 1711: raise FND_API.G_EXC_ERROR;

1707: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1708: IF PG_DEBUG <> 0 THEN
1709: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with exp error',1);
1710: END IF;
1711: raise FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: IF PG_DEBUG <> 0 THEN
1715: oe_debug_pub.add('get_all_item_orgs: ' || 'after calling process_sourcing_chain::x_return_status::'||x_return_status,2);

Line 1841: when FND_API.G_EXC_ERROR then

1837:
1838: return(1);
1839:
1840: EXCEPTION
1841: when FND_API.G_EXC_ERROR then
1842: IF PG_DEBUG <> 0 THEN
1843: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1844: END IF;
1845: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1845: x_return_status := FND_API.G_RET_STS_ERROR;

1841: when FND_API.G_EXC_ERROR then
1842: IF PG_DEBUG <> 0 THEN
1843: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1844: END IF;
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846: CTO_MSG_PUB.Count_And_Get
1847: (p_msg_count => x_msg_count
1848: ,p_msg_data => x_msg_data
1849: );

Line 1852: when FND_API.G_EXC_UNEXPECTED_ERROR then

1848: ,p_msg_data => x_msg_data
1849: );
1850: return(0);
1851:
1852: when FND_API.G_EXC_UNEXPECTED_ERROR then
1853: IF PG_DEBUG <> 0 THEN
1854: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1855: END IF;
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1852: when FND_API.G_EXC_UNEXPECTED_ERROR then
1853: IF PG_DEBUG <> 0 THEN
1854: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1855: END IF;
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1857: CTO_MSG_PUB.Count_And_Get (
1858: p_msg_count => x_msg_count
1859: ,p_msg_data => x_msg_data
1860: );

Line 1867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1863: when OTHERS then
1864: IF PG_DEBUG <> 0 THEN
1865: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::others::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1866: END IF;
1867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1869: FND_MSG_PUB.Add_Exc_Msg
1870: (G_PKG_NAME
1871: ,'Get_All_Item_Orgs'

Line 1939: x_return_status := FND_API.G_RET_STS_SUCCESS;

1935:
1936:
1937:
1938:
1939: x_return_status := FND_API.G_RET_STS_SUCCESS;
1940:
1941:
1942:
1943:

Line 2201: raise FND_API.G_EXC_ERROR;

2197:
2198: END IF;
2199:
2200: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2201: raise FND_API.G_EXC_ERROR;
2202:
2203:
2204:
2205: end if;

Line 2408: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2404:
2405:
2406:
2407:
2408: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2409: IF PG_DEBUG <> 0 THEN
2410: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with unexp error',1);
2411: END IF;
2412: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2412: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2408: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2409: IF PG_DEBUG <> 0 THEN
2410: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with unexp error',1);
2411: END IF;
2412: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2413:
2414: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2415: IF PG_DEBUG <> 0 THEN
2416: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with exp error',1);

Line 2414: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2410: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with unexp error',1);
2411: END IF;
2412: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2413:
2414: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2415: IF PG_DEBUG <> 0 THEN
2416: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with exp error',1);
2417: END IF;
2418: raise FND_API.G_EXC_ERROR;

Line 2418: raise FND_API.G_EXC_ERROR;

2414: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2415: IF PG_DEBUG <> 0 THEN
2416: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with exp error',1);
2417: END IF;
2418: raise FND_API.G_EXC_ERROR;
2419: END IF;
2420:
2421:
2422: IF PG_DEBUG <> 0 THEN

Line 2479: raise FND_API.G_EXC_ERROR;

2475: -- This is because if we not set the token once again the
2476: -- second add will not get the message.
2477:
2478: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2479: raise FND_API.G_EXC_ERROR;
2480:
2481: END;
2482:
2483:

Line 2596: WHEN fnd_api.g_exc_error THEN

2592:
2593:
2594:
2595: EXCEPTION
2596: WHEN fnd_api.g_exc_error THEN
2597: IF PG_DEBUG <> 0 THEN
2598: oe_debug_pub.add('process_sourcing_chain: ' || 'Exception in stmt num: '
2599: || to_char(lStmtNum), 1);
2600: END IF;

Line 2601: x_return_status := FND_API.G_RET_STS_ERROR;

2597: IF PG_DEBUG <> 0 THEN
2598: oe_debug_pub.add('process_sourcing_chain: ' || 'Exception in stmt num: '
2599: || to_char(lStmtNum), 1);
2600: END IF;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: -- Get message count and data
2603: cto_msg_pub.count_and_get
2604: ( p_msg_count => x_msg_count
2605: , p_msg_data => x_msg_data

Line 2607: WHEN fnd_api.g_exc_unexpected_error THEN

2603: cto_msg_pub.count_and_get
2604: ( p_msg_count => x_msg_count
2605: , p_msg_data => x_msg_data
2606: );
2607: WHEN fnd_api.g_exc_unexpected_error THEN
2608: IF PG_DEBUG <> 0 THEN
2609: oe_debug_pub.add('process_sourcing_chain: ' || ' Unexpected Exception in stmt num: '
2610: || to_char(lStmtNum), 1);
2611: END IF;

Line 2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2608: IF PG_DEBUG <> 0 THEN
2609: oe_debug_pub.add('process_sourcing_chain: ' || ' Unexpected Exception in stmt num: '
2610: || to_char(lStmtNum), 1);
2611: END IF;
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2613: -- Get message count and data
2614: cto_msg_pub.count_and_get
2615: ( p_msg_count => x_msg_count
2616: , p_msg_data => x_msg_data

Line 2625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2621: oe_debug_pub.add('process_sourcing_chain: ' || 'Others Exception in stmt num: '
2622: || to_char(lStmtNum), 1);
2623: oe_debug_pub.add('process_sourcing_chain: ' || 'errormsg='||sqlerrm, 1);
2624: END IF;
2625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626: -- Get message count and data
2627: cto_msg_pub.count_and_get
2628: ( p_msg_count => x_msg_count
2629: , p_msg_data => x_msg_data

Line 2694: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2690: IF PG_DEBUG <> 0 THEN
2691: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Initializing the assignment set',5);
2692: END IF;
2693: initialize_assignment_set(x_return_status);
2694: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2695: IF PG_DEBUG <> 0 THEN
2696: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Error in initializing assignment set',5);
2697: END IF;
2698: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2698: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2694: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2695: IF PG_DEBUG <> 0 THEN
2696: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Error in initializing assignment set',5);
2697: END IF;
2698: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2699: end if;
2700: End IF;
2701:
2702:

Line 2703: p_sourcing_rule_exists := FND_API.G_FALSE ;

2699: end if;
2700: End IF;
2701:
2702:
2703: p_sourcing_rule_exists := FND_API.G_FALSE ;
2704: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2705:
2706:
2707: -- Added by Renga Kannan on 08/27/01

Line 2704: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2700: End IF;
2701:
2702:
2703: p_sourcing_rule_exists := FND_API.G_FALSE ;
2704: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2705:
2706:
2707: -- Added by Renga Kannan on 08/27/01
2708: -- If the default assignment set is not defined then it needs to

Line 2722: p_sourcing_rule_exists := FND_API.G_TRUE;

2718: IF l_make_buy_code = 2 THEN
2719: p_source_type := 3;
2720: -- Renga Kannan added on 09/13/01 to set the sourcin_rule_exists
2721: -- Output value to Y even in the case of Buy attribute
2722: p_sourcing_rule_exists := FND_API.G_TRUE;
2723:
2724: ELSE
2725: p_source_type := 2;
2726:

Line 2801: p_sourcing_rule_exists := FND_API.G_TRUE ;

2797: --- to pass back the source type value as parameter
2798:
2799:
2800: if( p_t_sourcing_info.sourcing_rule_id.count > 0 ) then
2801: p_sourcing_rule_exists := FND_API.G_TRUE ;
2802:
2803: end if ;
2804:
2805:

Line 2831: p_sourcing_rule_exists := FND_API.G_TRUE ;

2827: AND organization_id = p_organization_id;
2828:
2829: IF l_make_buy_code = 2 THEN
2830: p_source_type := 3;
2831: p_sourcing_rule_exists := FND_API.G_TRUE ;
2832: ELSE
2833: p_source_type := 2;
2834: END IF;
2835:

Line 2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2849:
2850: oe_debug_pub.add('query_sourcing_org_ms: ' || ' came into others when finding source ' , 1 );
2851: END IF;
2852:
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854:
2855:
2856:
2857: end query_sourcing_org_ms ;

Line 2904: x_return_status := FND_API.G_RET_STS_SUCCESS;

2900:
2901: lUPGAssignmentSet number;
2902: BEGIN
2903:
2904: x_return_status := FND_API.G_RET_STS_SUCCESS;
2905: lAssignmentExists := 0;
2906:
2907: lStmtNum := 10;
2908: /* get MRP's default assignment set */

Line 3452: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3448: -- confirm with raghu, confirmed with stupe
3449:
3450: MRP_Src_Assignment_PUB.Process_Assignment
3451: ( p_api_version_number => 1.0
3452: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3453: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3454: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3455: , x_return_status => l_return_status
3456: , x_msg_count => l_msg_count

Line 3453: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE

3449:
3450: MRP_Src_Assignment_PUB.Process_Assignment
3451: ( p_api_version_number => 1.0
3452: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3453: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3454: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3455: , x_return_status => l_return_status
3456: , x_msg_count => l_msg_count
3457: , x_msg_data => l_msg_data

Line 3454: --, p_commit IN VARCHAR2 := FND_API.G_FALSE

3450: MRP_Src_Assignment_PUB.Process_Assignment
3451: ( p_api_version_number => 1.0
3452: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3453: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3454: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3455: , x_return_status => l_return_status
3456: , x_msg_count => l_msg_count
3457: , x_msg_data => l_msg_data
3458: , p_Assignment_Set_rec => lAssignmentSetRec

Line 3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3464: , x_Assignment_tbl => xAssignmentTbl
3465: , x_Assignment_val_tbl => xAssignmentValTbl
3466: );
3467:
3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: IF PG_DEBUG <> 0 THEN
3470: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3471: END IF;
3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: IF PG_DEBUG <> 0 THEN
3470: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3471: END IF;
3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3473:
3474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3475: IF PG_DEBUG <> 0 THEN
3476: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);

Line 3474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3470: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3471: END IF;
3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3473:
3474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3475: IF PG_DEBUG <> 0 THEN
3476: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
3477: END IF;
3478:

Line 3485: p_encoded => FND_API.G_FALSE);

3481: IF l_msg_count > 0 THEN
3482: FOR l_index IN 1..l_msg_count LOOP
3483: l_msg_data := fnd_msg_pub.get(
3484: p_msg_index => l_index,
3485: p_encoded => FND_API.G_FALSE);
3486:
3487: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
3488: END LOOP;
3489:

Line 3496: raise FND_API.G_EXC_ERROR;

3492:
3493: oe_debug_pub.add('Failure!' , 1 );
3494:
3495:
3496: raise FND_API.G_EXC_ERROR;
3497:
3498: END IF;
3499: IF PG_DEBUG <> 0 THEN
3500: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'success in process_assignment',2);

Line 3507: when FND_API.G_EXC_ERROR then

3503: EXCEPTION
3504: When NO_sourcing_defined THEN
3505: null;
3506:
3507: when FND_API.G_EXC_ERROR then
3508: IF PG_DEBUG <> 0 THEN
3509: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3511: x_return_status := FND_API.G_RET_STS_ERROR;

3507: when FND_API.G_EXC_ERROR then
3508: IF PG_DEBUG <> 0 THEN
3509: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512: CTO_MSG_PUB.Count_And_Get
3513: (p_msg_count => x_msg_count
3514: ,p_msg_data => x_msg_data
3515: );

Line 3517: when FND_API.G_EXC_UNEXPECTED_ERROR then

3513: (p_msg_count => x_msg_count
3514: ,p_msg_data => x_msg_data
3515: );
3516:
3517: when FND_API.G_EXC_UNEXPECTED_ERROR then
3518: IF PG_DEBUG <> 0 THEN
3519: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3520: END IF;
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3517: when FND_API.G_EXC_UNEXPECTED_ERROR then
3518: IF PG_DEBUG <> 0 THEN
3519: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3520: END IF;
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: CTO_MSG_PUB.Count_And_Get
3523: (p_msg_count => x_msg_count
3524: ,p_msg_data => x_msg_data
3525: );

Line 3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3527: when OTHERS then
3528: IF PG_DEBUG <> 0 THEN
3529: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3530: END IF;
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3532: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3533: FND_MSG_PUB.Add_Exc_Msg
3534: (G_PKG_NAME
3535: ,'Create_Sourcing_Rules'

Line 3638: x_return_status := FND_API.G_RET_STS_SUCCESS;

3634: where assignment_set_id = c_def_assg_set
3635: and inventory_item_id = c_item_id;
3636: BEGIN
3637:
3638: x_return_status := FND_API.G_RET_STS_SUCCESS;
3639: lAssignmentExists := 0;
3640:
3641: lStmtNum := 10;
3642: /* get MRP's default assignment set */

Line 4296: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

4292: -- confirm with raghu, confirmed with stupe
4293:
4294: MRP_Src_Assignment_PUB.Process_Assignment
4295: ( p_api_version_number => 1.0
4296: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4297: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
4298: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
4299: , x_return_status => l_return_status
4300: , x_msg_count => l_msg_count

Line 4297: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE

4293:
4294: MRP_Src_Assignment_PUB.Process_Assignment
4295: ( p_api_version_number => 1.0
4296: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4297: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
4298: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
4299: , x_return_status => l_return_status
4300: , x_msg_count => l_msg_count
4301: , x_msg_data => l_msg_data

Line 4298: --, p_commit IN VARCHAR2 := FND_API.G_FALSE

4294: MRP_Src_Assignment_PUB.Process_Assignment
4295: ( p_api_version_number => 1.0
4296: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4297: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
4298: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
4299: , x_return_status => l_return_status
4300: , x_msg_count => l_msg_count
4301: , x_msg_data => l_msg_data
4302: , p_Assignment_Set_rec => lAssignmentSetRec

Line 4312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4308: , x_Assignment_tbl => xAssignmentTbl
4309: , x_Assignment_val_tbl => xAssignmentValTbl
4310: );
4311:
4312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4313: IF PG_DEBUG <> 0 THEN
4314: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);
4316: END IF;

Line 4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4313: IF PG_DEBUG <> 0 THEN
4314: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);
4316: END IF;
4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:
4319: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4320: IF PG_DEBUG <> 0 THEN
4321: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);

Line 4319: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);
4316: END IF;
4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:
4319: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4320: IF PG_DEBUG <> 0 THEN
4321: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
4322: END IF;
4323:

Line 4331: p_encoded => FND_API.G_FALSE);

4327: IF l_msg_count > 0 THEN
4328: FOR l_index IN 1..l_msg_count LOOP
4329: l_msg_data := fnd_msg_pub.get(
4330: p_msg_index => l_index,
4331: p_encoded => FND_API.G_FALSE);
4332:
4333: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
4334: END LOOP;
4335:

Line 4342: raise FND_API.G_EXC_ERROR;

4338:
4339: oe_debug_pub.add('Failure!' , 1 );
4340:
4341:
4342: raise FND_API.G_EXC_ERROR;
4343:
4344: END IF;
4345: IF PG_DEBUG <> 0 THEN
4346: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'success in process_assignment',2);

Line 4391: when FND_API.G_EXC_ERROR then

4387: EXCEPTION
4388: When NO_sourcing_defined THEN
4389: null;
4390:
4391: when FND_API.G_EXC_ERROR then
4392: IF PG_DEBUG <> 0 THEN
4393: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4394: END IF;
4395: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4395: x_return_status := FND_API.G_RET_STS_ERROR;

4391: when FND_API.G_EXC_ERROR then
4392: IF PG_DEBUG <> 0 THEN
4393: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4394: END IF;
4395: x_return_status := FND_API.G_RET_STS_ERROR;
4396: CTO_MSG_PUB.Count_And_Get
4397: (p_msg_count => x_msg_count
4398: ,p_msg_data => x_msg_data
4399: );

Line 4401: when FND_API.G_EXC_UNEXPECTED_ERROR then

4397: (p_msg_count => x_msg_count
4398: ,p_msg_data => x_msg_data
4399: );
4400:
4401: when FND_API.G_EXC_UNEXPECTED_ERROR then
4402: IF PG_DEBUG <> 0 THEN
4403: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4404: END IF;
4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4401: when FND_API.G_EXC_UNEXPECTED_ERROR then
4402: IF PG_DEBUG <> 0 THEN
4403: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4404: END IF;
4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406: CTO_MSG_PUB.Count_And_Get
4407: (p_msg_count => x_msg_count
4408: ,p_msg_data => x_msg_data
4409: );

Line 4415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4411: when OTHERS then
4412: IF PG_DEBUG <> 0 THEN
4413: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4414: END IF;
4415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4417: FND_MSG_PUB.Add_Exc_Msg
4418: (G_PKG_NAME
4419: ,'Create_Sourcing_Rules'

Line 4441: x_return_status := FND_API.G_RET_STS_SUCCESS ;

4437: INVALID_MRP_ASSIGNMENT_SET exception ;
4438:
4439: BEGIN
4440: /* begin for static block */
4441: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4442:
4443: /*
4444: ** get MRP's default assignment set
4445: */

Line 4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4487: RAISE INVALID_MRP_ASSIGNMENT_SET ;
4488:
4489: when others then
4490:
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4492: end ;
4493:
4494: IF PG_DEBUG <> 0 THEN
4495: oe_debug_pub.add('initialize_assignment_set: ' || 'Default assignment set name is '||

Line 4504: x_return_status := FND_API.G_RET_STS_ERROR;

4500:
4501: END IF;
4502: exception
4503: when INVALID_MRP_ASSIGNMENT_SET then
4504: x_return_status := FND_API.G_RET_STS_ERROR;
4505:
4506: IF PG_DEBUG <> 0 THEN
4507: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4508: END IF;

Line 4511: when FND_API.G_EXC_UNEXPECTED_ERROR then

4507: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4508: END IF;
4509:
4510:
4511: when FND_API.G_EXC_UNEXPECTED_ERROR then
4512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4513: IF PG_DEBUG <> 0 THEN
4514: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4515: END IF;

Line 4512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4508: END IF;
4509:
4510:
4511: when FND_API.G_EXC_UNEXPECTED_ERROR then
4512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4513: IF PG_DEBUG <> 0 THEN
4514: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4515: END IF;
4516:

Line 4519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4515: END IF;
4516:
4517:
4518: when OTHERS then
4519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4520: IF PG_DEBUG <> 0 THEN
4521: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4522: END IF;
4523:

Line 5160: x_return_status := FND_API.G_RET_STS_SUCCESS ;

5156:
5157:
5158: xOrgLst.DELETE;
5159:
5160: x_return_status := FND_API.G_RET_STS_SUCCESS ;
5161:
5162:
5163: IF p_mode = 'UPG' THEN
5164: select inventory_item_id,

Line 5552: when FND_API.G_EXC_UNEXPECTED_ERROR then

5548: end if;
5549:
5550:
5551: exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5552: when FND_API.G_EXC_UNEXPECTED_ERROR then
5553: IF PG_DEBUG <> 0 THEN
5554: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5555: END IF;
5556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5552: when FND_API.G_EXC_UNEXPECTED_ERROR then
5553: IF PG_DEBUG <> 0 THEN
5554: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5555: END IF;
5556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5557: CTO_MSG_PUB.Count_And_Get
5558: (p_msg_count => x_msg_count
5559: ,p_msg_data => x_msg_data
5560: );

Line 5562: when FND_API.G_EXC_ERROR then

5558: (p_msg_count => x_msg_count
5559: ,p_msg_data => x_msg_data
5560: );
5561:
5562: when FND_API.G_EXC_ERROR then
5563: IF PG_DEBUG <> 0 THEN
5564: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5565: END IF;
5566: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5566: x_return_status := FND_API.G_RET_STS_ERROR;

5562: when FND_API.G_EXC_ERROR then
5563: IF PG_DEBUG <> 0 THEN
5564: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5565: END IF;
5566: x_return_status := FND_API.G_RET_STS_ERROR;
5567: CTO_MSG_PUB.Count_And_Get
5568: (p_msg_count => x_msg_count
5569: ,p_msg_data => x_msg_data);
5570:

Line 5577: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

5573: IF PG_DEBUG <> 0 THEN
5574: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error:: '||to_char(lstmt_num)||'::'||sqlerrm,5);
5575: END IF;
5576:
5577: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5578:
5579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5580:
5581: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);

Line 5579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5575: END IF;
5576:
5577: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5578:
5579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5580:
5581: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5582:
5583:

Line 5793: x_return_status := FND_API.G_RET_STS_SUCCESS;

5789: oe_debug_pub.add('Get_Master_Orgs: No new Masters orgs are added.... ',1);
5790: End if;
5791: End;
5792:
5793: x_return_status := FND_API.G_RET_STS_SUCCESS;
5794:
5795: Exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5796: when FND_API.G_EXC_UNEXPECTED_ERROR then
5797: IF PG_DEBUG <> 0 THEN

Line 5796: when FND_API.G_EXC_UNEXPECTED_ERROR then

5792:
5793: x_return_status := FND_API.G_RET_STS_SUCCESS;
5794:
5795: Exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5796: when FND_API.G_EXC_UNEXPECTED_ERROR then
5797: IF PG_DEBUG <> 0 THEN
5798: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5799: END IF;
5800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5796: when FND_API.G_EXC_UNEXPECTED_ERROR then
5797: IF PG_DEBUG <> 0 THEN
5798: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5799: END IF;
5800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5801: CTO_MSG_PUB.Count_And_Get
5802: (p_msg_count => x_msg_count
5803: ,p_msg_data => x_msg_data
5804: );

Line 5806: when FND_API.G_EXC_ERROR then

5802: (p_msg_count => x_msg_count
5803: ,p_msg_data => x_msg_data
5804: );
5805:
5806: when FND_API.G_EXC_ERROR then
5807: IF PG_DEBUG <> 0 THEN
5808: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5809: END IF;
5810: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5810: x_return_status := FND_API.G_RET_STS_ERROR;

5806: when FND_API.G_EXC_ERROR then
5807: IF PG_DEBUG <> 0 THEN
5808: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5809: END IF;
5810: x_return_status := FND_API.G_RET_STS_ERROR;
5811: CTO_MSG_PUB.Count_And_Get
5812: (p_msg_count => x_msg_count
5813: ,p_msg_data => x_msg_data);
5814:

Line 5821: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

5817: IF PG_DEBUG <> 0 THEN
5818: oe_debug_pub.add('get_other_orgs: ' || 'Get_Master_Orgs::unexp error:: '||to_char(lstmt_num)||'::'||sqlerrm,5);
5819: END IF;
5820:
5821: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5822:
5823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5824:
5825: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);

Line 5823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5819: END IF;
5820:
5821: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5822:
5823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5824:
5825: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5826:
5827: End Get_Master_orgs;

Line 5836: x_return_status := FND_API.G_RET_STS_SUCCESS;

5832: Procedure set_bom_batch_id(x_return_status OUT NOCOPY varchar2) IS
5833:
5834: Begin
5835:
5836: x_return_status := FND_API.G_RET_STS_SUCCESS;
5837:
5838: bom_batch_id := Bom_Import_Pub.Get_BatchId;
5839:
5840: if bom_batch_id = 0 then

Line 5842: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5838: bom_batch_id := Bom_Import_Pub.Get_BatchId;
5839:
5840: if bom_batch_id = 0 then
5841: oe_debug_pub.add('Get_bom_batch_id: batch_id is 0', 1);
5842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5843: end if;
5844:
5845: IF PG_DEBUG <> 0 THEN
5846: oe_debug_pub.add('Get_bom_batch_id: Batch_id = ' || bom_batch_id, 1);

Line 5851: When FND_API.G_EXC_UNEXPECTED_ERROR then

5847: END IF;
5848:
5849: Exception
5850:
5851: When FND_API.G_EXC_UNEXPECTED_ERROR then
5852: IF PG_DEBUG <> 0 THEN
5853: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5854: END IF;
5855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5851: When FND_API.G_EXC_UNEXPECTED_ERROR then
5852: IF PG_DEBUG <> 0 THEN
5853: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5854: END IF;
5855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5856:
5857: When others then
5858: IF PG_DEBUG <> 0 THEN
5859: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);

Line 5861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5857: When others then
5858: IF PG_DEBUG <> 0 THEN
5859: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5860: END IF;
5861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5862:
5863: End set_bom_batch_id;
5864:
5865:

Line 5876: raise fnd_api.g_exc_unexpected_error;

5872: Begin
5873: -- Calling PLM API to sync up item media index
5874: EGO_ITEM_PUB.SYNC_IM_INDEX ;
5875: Exception When others then
5876: raise fnd_api.g_exc_unexpected_error;
5877: End Syncup_item_media_index;
5878:
5879:
5880: