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 255: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

Line 259: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 265: raise FND_API.G_EXC_ERROR;

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

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

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

Line 303: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 309: raise FND_API.G_EXC_ERROR;

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

Line 387: if x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 394: raise FND_API.G_EXC_ERROR;

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

Line 396: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 403: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 547: if x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 553: Raise FND_API.G_EXC_ERROR;

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

Line 555: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 561: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 585: if x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 591: Raise FND_API.G_EXC_ERROR;

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

Line 593: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 599: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 671: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 682: when FND_API.G_EXC_ERROR then

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

Line 686: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 849: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 855: raise FND_API.G_EXC_ERROR;

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

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

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

Line 895: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 901: raise FND_API.G_EXC_ERROR;

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

Line 957: if x_return_status = FND_API.G_RET_STS_ERROR then

953:
954:
955:
956:
957: if x_return_status = FND_API.G_RET_STS_ERROR then
958:
959: IF PG_DEBUG <> 0 THEN
960: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
961: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);

Line 964: raise FND_API.G_EXC_ERROR;

960: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
961: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with expected error.', 1);
962: END IF;
963:
964: raise FND_API.G_EXC_ERROR;
965:
966: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
967:
968: IF PG_DEBUG <> 0 THEN

Line 966: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 973: raise FND_API.G_EXC_UNEXPECTED_ERROR;

969: oe_debug_pub.add ('GET_ALL_ITEM_ORGS: ' ||
970: 'Failed in cto_oss_source_pk.get_oss_bom_orgs with unexpected error.', 1);
971: END IF;
972:
973: raise FND_API.G_EXC_UNEXPECTED_ERROR;
974:
975: end if;
976:
977: IF PG_DEBUG <> 0 THEN

Line 1156: if x_return_status = FND_API.G_RET_STS_ERROR then

1152: x_msg_data => x_msg_data );
1153:
1154:
1155: /* bugfix 4162642 :added return status check */
1156: if x_return_status = FND_API.G_RET_STS_ERROR then
1157:
1158: if PG_DEBUG <> 0 then
1159: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
1160: end if;

Line 1162: Raise FND_API.G_EXC_ERROR;

1158: if PG_DEBUG <> 0 then
1159: oe_debug_pub.add( 'ERROR: get_other_orgs api return expected error' , 1 ) ;
1160: end if;
1161:
1162: Raise FND_API.G_EXC_ERROR;
1163:
1164: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1165:
1166: if PG_DEBUG <> 0 then

Line 1164: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 1170: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1192: if x_return_status = FND_API.G_RET_STS_ERROR then

1188: x_return_status => x_return_status,
1189: x_msg_count => x_msg_count,
1190: x_msg_data => x_msg_data);
1191:
1192: if x_return_status = FND_API.G_RET_STS_ERROR then
1193:
1194: if PG_DEBUG <> 0 then
1195: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
1196: end if;

Line 1198: Raise FND_API.G_EXC_ERROR;

1194: if PG_DEBUG <> 0 then
1195: oe_debug_pub.add( 'ERROR: get_Master_orgs api return expected error' , 1 ) ;
1196: end if;
1197:
1198: Raise FND_API.G_EXC_ERROR;
1199:
1200: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1201:
1202: if PG_DEBUG <> 0 then

Line 1200: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 1206: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1202: if PG_DEBUG <> 0 then
1203: oe_debug_pub.add( 'ERROR: get_Master_orgs api return unexpected error' , 1 ) ;
1204: end if;
1205:
1206: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1207:
1208: end if;
1209: If x_orgs_list.count <> 0 then
1210: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId,

Line 1234: when FND_API.G_EXC_UNEXPECTED_ERROR then

1230: return(1);
1231:
1232: EXCEPTION
1233:
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: IF PG_DEBUG <> 0 THEN
1236: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
1237: END IF;
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1245: when FND_API.G_EXC_ERROR then

1241: ,p_msg_data => x_msg_data
1242: );
1243: return(0);
1244:
1245: when FND_API.G_EXC_ERROR then
1246: IF PG_DEBUG <> 0 THEN
1247: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
1248: END IF;
1249: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1249: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1255: when others then
1256: IF PG_DEBUG <> 0 THEN
1257: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
1258: END IF;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1261: FND_MSG_PUB.Add_Exc_Msg
1262: (G_PKG_NAME
1263: ,'populate_src_orgs'

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

1734:
1735:
1736:
1737:
1738: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1739: IF PG_DEBUG <> 0 THEN
1740: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with unexp error',1);
1741: END IF;
1742: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1742: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1738: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1739: IF PG_DEBUG <> 0 THEN
1740: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with unexp error',1);
1741: END IF;
1742: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1743:
1744: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1745: IF PG_DEBUG <> 0 THEN
1746: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with exp error',1);

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

1740: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with unexp error',1);
1741: END IF;
1742: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1743:
1744: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1745: IF PG_DEBUG <> 0 THEN
1746: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with exp error',1);
1747: END IF;
1748: raise FND_API.G_EXC_ERROR;

Line 1748: raise FND_API.G_EXC_ERROR;

1744: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1745: IF PG_DEBUG <> 0 THEN
1746: oe_debug_pub.add('get_all_item_orgs: ' || 'process_sourcing_chain returned with exp error',1);
1747: END IF;
1748: raise FND_API.G_EXC_ERROR;
1749: END IF;
1750:
1751:
1752: IF PG_DEBUG <> 0 THEN

Line 1891: when FND_API.G_EXC_ERROR then

1887:
1888: return(1);
1889:
1890: EXCEPTION
1891: when FND_API.G_EXC_ERROR then
1892: IF PG_DEBUG <> 0 THEN
1893: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1894: END IF;
1895: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1895: x_return_status := FND_API.G_RET_STS_ERROR;

1891: when FND_API.G_EXC_ERROR then
1892: IF PG_DEBUG <> 0 THEN
1893: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1894: END IF;
1895: x_return_status := FND_API.G_RET_STS_ERROR;
1896: CTO_MSG_PUB.Count_And_Get
1897: (p_msg_count => x_msg_count
1898: ,p_msg_data => x_msg_data
1899: );

Line 1902: when FND_API.G_EXC_UNEXPECTED_ERROR then

1898: ,p_msg_data => x_msg_data
1899: );
1900: return(0);
1901:
1902: when FND_API.G_EXC_UNEXPECTED_ERROR then
1903: IF PG_DEBUG <> 0 THEN
1904: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1905: END IF;
1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1902: when FND_API.G_EXC_UNEXPECTED_ERROR then
1903: IF PG_DEBUG <> 0 THEN
1904: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1905: END IF;
1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1907: CTO_MSG_PUB.Count_And_Get (
1908: p_msg_count => x_msg_count
1909: ,p_msg_data => x_msg_data
1910: );

Line 1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1913: when OTHERS then
1914: IF PG_DEBUG <> 0 THEN
1915: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::others::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1916: END IF;
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1918: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1919: FND_MSG_PUB.Add_Exc_Msg
1920: (G_PKG_NAME
1921: ,'Get_All_Item_Orgs'

Line 1986: x_return_status := FND_API.G_RET_STS_SUCCESS;

1982:
1983:
1984:
1985:
1986: x_return_status := FND_API.G_RET_STS_SUCCESS;
1987:
1988:
1989:
1990:

Line 2214: raise FND_API.G_EXC_ERROR;

2210:
2211: END IF;
2212:
2213: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2214: raise FND_API.G_EXC_ERROR;
2215:
2216:
2217:
2218: end if;

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

2417:
2418:
2419:
2420:
2421: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2422: IF PG_DEBUG <> 0 THEN
2423: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with unexp error',1);
2424: END IF;
2425: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2425: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2421: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2422: IF PG_DEBUG <> 0 THEN
2423: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with unexp error',1);
2424: END IF;
2425: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2426:
2427: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2428: IF PG_DEBUG <> 0 THEN
2429: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with exp error',1);

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

2423: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with unexp error',1);
2424: END IF;
2425: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2426:
2427: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2428: IF PG_DEBUG <> 0 THEN
2429: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with exp error',1);
2430: END IF;
2431: raise FND_API.G_EXC_ERROR;

Line 2431: raise FND_API.G_EXC_ERROR;

2427: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2428: IF PG_DEBUG <> 0 THEN
2429: oe_debug_pub.add('process_sourcing_chain: ' || 'process_sourcing_chain returned with exp error',1);
2430: END IF;
2431: raise FND_API.G_EXC_ERROR;
2432: END IF;
2433:
2434:
2435: IF PG_DEBUG <> 0 THEN

Line 2492: raise FND_API.G_EXC_ERROR;

2488: -- This is because if we not set the token once again the
2489: -- second add will not get the message.
2490:
2491: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2492: raise FND_API.G_EXC_ERROR;
2493:
2494: END;
2495:
2496:

Line 2606: WHEN fnd_api.g_exc_error THEN

2602:
2603:
2604:
2605: EXCEPTION
2606: WHEN fnd_api.g_exc_error THEN
2607: IF PG_DEBUG <> 0 THEN
2608: oe_debug_pub.add('process_sourcing_chain: ' || 'Exception in stmt num: '
2609: || to_char(lStmtNum), 1);
2610: END IF;

Line 2611: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2617: WHEN fnd_api.g_exc_unexpected_error THEN

2613: cto_msg_pub.count_and_get
2614: ( p_msg_count => x_msg_count
2615: , p_msg_data => x_msg_data
2616: );
2617: WHEN fnd_api.g_exc_unexpected_error THEN
2618: IF PG_DEBUG <> 0 THEN
2619: oe_debug_pub.add('process_sourcing_chain: ' || ' Unexpected Exception in stmt num: '
2620: || to_char(lStmtNum), 1);
2621: END IF;

Line 2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2618: IF PG_DEBUG <> 0 THEN
2619: oe_debug_pub.add('process_sourcing_chain: ' || ' Unexpected Exception in stmt num: '
2620: || to_char(lStmtNum), 1);
2621: END IF;
2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2623: -- Get message count and data
2624: cto_msg_pub.count_and_get
2625: ( p_msg_count => x_msg_count
2626: , p_msg_data => x_msg_data

Line 2635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2631: oe_debug_pub.add('process_sourcing_chain: ' || 'Others Exception in stmt num: '
2632: || to_char(lStmtNum), 1);
2633: oe_debug_pub.add('process_sourcing_chain: ' || 'errormsg='||sqlerrm, 1);
2634: END IF;
2635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2636: -- Get message count and data
2637: cto_msg_pub.count_and_get
2638: ( p_msg_count => x_msg_count
2639: , p_msg_data => x_msg_data

Line 2704: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2700: IF PG_DEBUG <> 0 THEN
2701: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Initializing the assignment set',5);
2702: END IF;
2703: initialize_assignment_set(x_return_status);
2704: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Error in initializing assignment set',5);
2707: END IF;
2708: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2708: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2704: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add('query_sourcing_org_ms: ' || 'Error in initializing assignment set',5);
2707: END IF;
2708: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2709: end if;
2710: End IF;
2711:
2712:

Line 2713: p_sourcing_rule_exists := FND_API.G_FALSE ;

2709: end if;
2710: End IF;
2711:
2712:
2713: p_sourcing_rule_exists := FND_API.G_FALSE ;
2714: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2715:
2716:
2717: -- Added by Renga Kannan on 08/27/01

Line 2714: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2710: End IF;
2711:
2712:
2713: p_sourcing_rule_exists := FND_API.G_FALSE ;
2714: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2715:
2716:
2717: -- Added by Renga Kannan on 08/27/01
2718: -- If the default assignment set is not defined then it needs to

Line 2732: p_sourcing_rule_exists := FND_API.G_TRUE;

2728: IF l_make_buy_code = 2 THEN
2729: p_source_type := 3;
2730: -- Renga Kannan added on 09/13/01 to set the sourcin_rule_exists
2731: -- Output value to Y even in the case of Buy attribute
2732: p_sourcing_rule_exists := FND_API.G_TRUE;
2733:
2734: ELSE
2735: p_source_type := 2;
2736:

Line 2811: p_sourcing_rule_exists := FND_API.G_TRUE ;

2807: --- to pass back the source type value as parameter
2808:
2809:
2810: if( p_t_sourcing_info.sourcing_rule_id.count > 0 ) then
2811: p_sourcing_rule_exists := FND_API.G_TRUE ;
2812:
2813: end if ;
2814:
2815:

Line 2841: p_sourcing_rule_exists := FND_API.G_TRUE ;

2837: AND organization_id = p_organization_id;
2838:
2839: IF l_make_buy_code = 2 THEN
2840: p_source_type := 3;
2841: p_sourcing_rule_exists := FND_API.G_TRUE ;
2842: ELSE
2843: p_source_type := 2;
2844: END IF;
2845:

Line 2863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2859:
2860: oe_debug_pub.add('query_sourcing_org_ms: ' || ' came into others when finding source ' , 1 );
2861: END IF;
2862:
2863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2864:
2865:
2866:
2867: end query_sourcing_org_ms ;

Line 2914: x_return_status := FND_API.G_RET_STS_SUCCESS;

2910:
2911: lUPGAssignmentSet number;
2912: BEGIN
2913:
2914: x_return_status := FND_API.G_RET_STS_SUCCESS;
2915: lAssignmentExists := 0;
2916:
2917: lStmtNum := 10;
2918: /* get MRP's default assignment set */

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

3252: -- confirm with raghu, confirmed with stupe
3253:
3254: MRP_Src_Assignment_PUB.Process_Assignment
3255: ( p_api_version_number => 1.0
3256: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3257: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3258: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3259: , x_return_status => l_return_status
3260: , x_msg_count => l_msg_count

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

3253:
3254: MRP_Src_Assignment_PUB.Process_Assignment
3255: ( p_api_version_number => 1.0
3256: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3257: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3258: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3259: , x_return_status => l_return_status
3260: , x_msg_count => l_msg_count
3261: , x_msg_data => l_msg_data

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

3254: MRP_Src_Assignment_PUB.Process_Assignment
3255: ( p_api_version_number => 1.0
3256: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3257: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3258: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3259: , x_return_status => l_return_status
3260: , x_msg_count => l_msg_count
3261: , x_msg_data => l_msg_data
3262: , p_Assignment_Set_rec => lAssignmentSetRec

Line 3272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3268: , x_Assignment_tbl => xAssignmentTbl
3269: , x_Assignment_val_tbl => xAssignmentValTbl
3270: );
3271:
3272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3273: IF PG_DEBUG <> 0 THEN
3274: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3275: END IF;
3276: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3276: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3273: IF PG_DEBUG <> 0 THEN
3274: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3275: END IF;
3276: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3277:
3278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3279: IF PG_DEBUG <> 0 THEN
3280: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);

Line 3278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3274: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3275: END IF;
3276: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3277:
3278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3279: IF PG_DEBUG <> 0 THEN
3280: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
3281: END IF;
3282:

Line 3289: p_encoded => FND_API.G_FALSE);

3285: IF l_msg_count > 0 THEN
3286: FOR l_index IN 1..l_msg_count LOOP
3287: l_msg_data := fnd_msg_pub.get(
3288: p_msg_index => l_index,
3289: p_encoded => FND_API.G_FALSE);
3290:
3291: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
3292: END LOOP;
3293:

Line 3300: raise FND_API.G_EXC_ERROR;

3296:
3297: oe_debug_pub.add('Failure!' , 1 );
3298:
3299:
3300: raise FND_API.G_EXC_ERROR;
3301:
3302: END IF;
3303: IF PG_DEBUG <> 0 THEN
3304: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'success in process_assignment',2);

Line 3311: when FND_API.G_EXC_ERROR then

3307: EXCEPTION
3308: When NO_sourcing_defined THEN
3309: null;
3310:
3311: when FND_API.G_EXC_ERROR then
3312: IF PG_DEBUG <> 0 THEN
3313: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3314: END IF;
3315: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3315: x_return_status := FND_API.G_RET_STS_ERROR;

3311: when FND_API.G_EXC_ERROR then
3312: IF PG_DEBUG <> 0 THEN
3313: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3314: END IF;
3315: x_return_status := FND_API.G_RET_STS_ERROR;
3316: CTO_MSG_PUB.Count_And_Get
3317: (p_msg_count => x_msg_count
3318: ,p_msg_data => x_msg_data
3319: );

Line 3321: when FND_API.G_EXC_UNEXPECTED_ERROR then

3317: (p_msg_count => x_msg_count
3318: ,p_msg_data => x_msg_data
3319: );
3320:
3321: when FND_API.G_EXC_UNEXPECTED_ERROR then
3322: IF PG_DEBUG <> 0 THEN
3323: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3324: END IF;
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3321: when FND_API.G_EXC_UNEXPECTED_ERROR then
3322: IF PG_DEBUG <> 0 THEN
3323: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3324: END IF;
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3326: CTO_MSG_PUB.Count_And_Get
3327: (p_msg_count => x_msg_count
3328: ,p_msg_data => x_msg_data
3329: );

Line 3335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3331: when OTHERS then
3332: IF PG_DEBUG <> 0 THEN
3333: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3334: END IF;
3335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3337: FND_MSG_PUB.Add_Exc_Msg
3338: (G_PKG_NAME
3339: ,'Create_Sourcing_Rules'

Line 3421: x_return_status := FND_API.G_RET_STS_SUCCESS;

3417:
3418:
3419: BEGIN
3420:
3421: x_return_status := FND_API.G_RET_STS_SUCCESS;
3422: lAssignmentExists := 0;
3423:
3424: lStmtNum := 10;
3425: /* get MRP's default assignment set */

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

3785: -- confirm with raghu, confirmed with stupe
3786:
3787: MRP_Src_Assignment_PUB.Process_Assignment
3788: ( p_api_version_number => 1.0
3789: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3790: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3791: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3792: , x_return_status => l_return_status
3793: , x_msg_count => l_msg_count

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

3786:
3787: MRP_Src_Assignment_PUB.Process_Assignment
3788: ( p_api_version_number => 1.0
3789: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3790: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3791: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3792: , x_return_status => l_return_status
3793: , x_msg_count => l_msg_count
3794: , x_msg_data => l_msg_data

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

3787: MRP_Src_Assignment_PUB.Process_Assignment
3788: ( p_api_version_number => 1.0
3789: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3790: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
3791: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
3792: , x_return_status => l_return_status
3793: , x_msg_count => l_msg_count
3794: , x_msg_data => l_msg_data
3795: , p_Assignment_Set_rec => lAssignmentSetRec

Line 3805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3801: , x_Assignment_tbl => xAssignmentTbl
3802: , x_Assignment_val_tbl => xAssignmentValTbl
3803: );
3804:
3805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3806: IF PG_DEBUG <> 0 THEN
3807: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3808: END IF;
3809: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3809: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3806: IF PG_DEBUG <> 0 THEN
3807: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3808: END IF;
3809: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3810:
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: IF PG_DEBUG <> 0 THEN
3813: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);

Line 3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3807: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3808: END IF;
3809: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3810:
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: IF PG_DEBUG <> 0 THEN
3813: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
3814: END IF;
3815:

Line 3823: p_encoded => FND_API.G_FALSE);

3819: IF l_msg_count > 0 THEN
3820: FOR l_index IN 1..l_msg_count LOOP
3821: l_msg_data := fnd_msg_pub.get(
3822: p_msg_index => l_index,
3823: p_encoded => FND_API.G_FALSE);
3824:
3825: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
3826: END LOOP;
3827:

Line 3834: raise FND_API.G_EXC_ERROR;

3830:
3831: oe_debug_pub.add('Failure!' , 1 );
3832:
3833:
3834: raise FND_API.G_EXC_ERROR;
3835:
3836: END IF;
3837: IF PG_DEBUG <> 0 THEN
3838: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'success in process_assignment',2);

Line 3874: when FND_API.G_EXC_ERROR then

3870: EXCEPTION
3871: When NO_sourcing_defined THEN
3872: null;
3873:
3874: when FND_API.G_EXC_ERROR then
3875: IF PG_DEBUG <> 0 THEN
3876: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3877: END IF;
3878: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3878: x_return_status := FND_API.G_RET_STS_ERROR;

3874: when FND_API.G_EXC_ERROR then
3875: IF PG_DEBUG <> 0 THEN
3876: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3877: END IF;
3878: x_return_status := FND_API.G_RET_STS_ERROR;
3879: CTO_MSG_PUB.Count_And_Get
3880: (p_msg_count => x_msg_count
3881: ,p_msg_data => x_msg_data
3882: );

Line 3884: when FND_API.G_EXC_UNEXPECTED_ERROR then

3880: (p_msg_count => x_msg_count
3881: ,p_msg_data => x_msg_data
3882: );
3883:
3884: when FND_API.G_EXC_UNEXPECTED_ERROR then
3885: IF PG_DEBUG <> 0 THEN
3886: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3887: END IF;
3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3884: when FND_API.G_EXC_UNEXPECTED_ERROR then
3885: IF PG_DEBUG <> 0 THEN
3886: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3887: END IF;
3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3889: CTO_MSG_PUB.Count_And_Get
3890: (p_msg_count => x_msg_count
3891: ,p_msg_data => x_msg_data
3892: );

Line 3898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3894: when OTHERS then
3895: IF PG_DEBUG <> 0 THEN
3896: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3897: END IF;
3898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3900: FND_MSG_PUB.Add_Exc_Msg
3901: (G_PKG_NAME
3902: ,'Create_Sourcing_Rules'

Line 3924: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3920: INVALID_MRP_ASSIGNMENT_SET exception ;
3921:
3922: BEGIN
3923: /* begin for static block */
3924: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3925:
3926: /*
3927: ** get MRP's default assignment set
3928: */

Line 3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3970: RAISE INVALID_MRP_ASSIGNMENT_SET ;
3971:
3972: when others then
3973:
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3975: end ;
3976:
3977: IF PG_DEBUG <> 0 THEN
3978: oe_debug_pub.add('initialize_assignment_set: ' || 'Default assignment set name is '||

Line 3987: x_return_status := FND_API.G_RET_STS_ERROR;

3983:
3984: END IF;
3985: exception
3986: when INVALID_MRP_ASSIGNMENT_SET then
3987: x_return_status := FND_API.G_RET_STS_ERROR;
3988:
3989: IF PG_DEBUG <> 0 THEN
3990: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3991: END IF;

Line 3994: when FND_API.G_EXC_UNEXPECTED_ERROR then

3990: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3991: END IF;
3992:
3993:
3994: when FND_API.G_EXC_UNEXPECTED_ERROR then
3995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3996: IF PG_DEBUG <> 0 THEN
3997: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3998: END IF;

Line 3995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3991: END IF;
3992:
3993:
3994: when FND_API.G_EXC_UNEXPECTED_ERROR then
3995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3996: IF PG_DEBUG <> 0 THEN
3997: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3998: END IF;
3999:

Line 4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3998: END IF;
3999:
4000:
4001: when OTHERS then
4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4003: IF PG_DEBUG <> 0 THEN
4004: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
4005: END IF;
4006:

Line 4630: x_return_status := FND_API.G_RET_STS_SUCCESS ;

4626:
4627:
4628: xOrgLst.DELETE;
4629:
4630: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4631:
4632:
4633: IF p_mode = 'UPG' THEN
4634: select inventory_item_id,

Line 5022: when FND_API.G_EXC_UNEXPECTED_ERROR then

5018: end if;
5019:
5020:
5021: exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5022: when FND_API.G_EXC_UNEXPECTED_ERROR then
5023: IF PG_DEBUG <> 0 THEN
5024: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5025: END IF;
5026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5022: when FND_API.G_EXC_UNEXPECTED_ERROR then
5023: IF PG_DEBUG <> 0 THEN
5024: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5025: END IF;
5026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5027: CTO_MSG_PUB.Count_And_Get
5028: (p_msg_count => x_msg_count
5029: ,p_msg_data => x_msg_data
5030: );

Line 5032: when FND_API.G_EXC_ERROR then

5028: (p_msg_count => x_msg_count
5029: ,p_msg_data => x_msg_data
5030: );
5031:
5032: when FND_API.G_EXC_ERROR then
5033: IF PG_DEBUG <> 0 THEN
5034: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5035: END IF;
5036: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5036: x_return_status := FND_API.G_RET_STS_ERROR;

5032: when FND_API.G_EXC_ERROR then
5033: IF PG_DEBUG <> 0 THEN
5034: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5035: END IF;
5036: x_return_status := FND_API.G_RET_STS_ERROR;
5037: CTO_MSG_PUB.Count_And_Get
5038: (p_msg_count => x_msg_count
5039: ,p_msg_data => x_msg_data);
5040:

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

5043: IF PG_DEBUG <> 0 THEN
5044: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error:: '||to_char(lstmt_num)||'::'||sqlerrm,5);
5045: END IF;
5046:
5047: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5048:
5049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5050:
5051: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);

Line 5049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5045: END IF;
5046:
5047: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5048:
5049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5050:
5051: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5052:
5053:

Line 5263: x_return_status := FND_API.G_RET_STS_SUCCESS;

5259: oe_debug_pub.add('Get_Master_Orgs: No new Masters orgs are added.... ',1);
5260: End if;
5261: End;
5262:
5263: x_return_status := FND_API.G_RET_STS_SUCCESS;
5264:
5265: Exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5266: when FND_API.G_EXC_UNEXPECTED_ERROR then
5267: IF PG_DEBUG <> 0 THEN

Line 5266: when FND_API.G_EXC_UNEXPECTED_ERROR then

5262:
5263: x_return_status := FND_API.G_RET_STS_SUCCESS;
5264:
5265: Exception /* added exception handling for expected and unexpected error as part of bug 4227127 (fp for bug 4162642) */
5266: when FND_API.G_EXC_UNEXPECTED_ERROR then
5267: IF PG_DEBUG <> 0 THEN
5268: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5269: END IF;
5270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5266: when FND_API.G_EXC_UNEXPECTED_ERROR then
5267: IF PG_DEBUG <> 0 THEN
5268: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5269: END IF;
5270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5271: CTO_MSG_PUB.Count_And_Get
5272: (p_msg_count => x_msg_count
5273: ,p_msg_data => x_msg_data
5274: );

Line 5276: when FND_API.G_EXC_ERROR then

5272: (p_msg_count => x_msg_count
5273: ,p_msg_data => x_msg_data
5274: );
5275:
5276: when FND_API.G_EXC_ERROR then
5277: IF PG_DEBUG <> 0 THEN
5278: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5279: END IF;
5280: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5280: x_return_status := FND_API.G_RET_STS_ERROR;

5276: when FND_API.G_EXC_ERROR then
5277: IF PG_DEBUG <> 0 THEN
5278: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5279: END IF;
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: CTO_MSG_PUB.Count_And_Get
5282: (p_msg_count => x_msg_count
5283: ,p_msg_data => x_msg_data);
5284:

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

5287: IF PG_DEBUG <> 0 THEN
5288: oe_debug_pub.add('get_other_orgs: ' || 'Get_Master_Orgs::unexp error:: '||to_char(lstmt_num)||'::'||sqlerrm,5);
5289: END IF;
5290:
5291: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5292:
5293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5294:
5295: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);

Line 5293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5289: END IF;
5290:
5291: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5292:
5293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5294:
5295: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5296:
5297: End Get_Master_orgs;

Line 5306: x_return_status := FND_API.G_RET_STS_SUCCESS;

5302: Procedure set_bom_batch_id(x_return_status OUT NOCOPY varchar2) IS
5303:
5304: Begin
5305:
5306: x_return_status := FND_API.G_RET_STS_SUCCESS;
5307:
5308: bom_batch_id := Bom_Import_Pub.Get_BatchId;
5309:
5310: if bom_batch_id = 0 then

Line 5312: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5308: bom_batch_id := Bom_Import_Pub.Get_BatchId;
5309:
5310: if bom_batch_id = 0 then
5311: oe_debug_pub.add('Get_bom_batch_id: batch_id is 0', 1);
5312: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5313: end if;
5314:
5315: IF PG_DEBUG <> 0 THEN
5316: oe_debug_pub.add('Get_bom_batch_id: Batch_id = ' || bom_batch_id, 1);

Line 5321: When FND_API.G_EXC_UNEXPECTED_ERROR then

5317: END IF;
5318:
5319: Exception
5320:
5321: When FND_API.G_EXC_UNEXPECTED_ERROR then
5322: IF PG_DEBUG <> 0 THEN
5323: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5324: END IF;
5325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5321: When FND_API.G_EXC_UNEXPECTED_ERROR then
5322: IF PG_DEBUG <> 0 THEN
5323: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5324: END IF;
5325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5326:
5327: When others then
5328: IF PG_DEBUG <> 0 THEN
5329: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);

Line 5331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5327: When others then
5328: IF PG_DEBUG <> 0 THEN
5329: oe_debug_pub.add('Get_bom_batch_id: unexpected error: ' || sqlerrm, 1);
5330: END IF;
5331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5332:
5333: End set_bom_batch_id;
5334:
5335:

Line 5346: raise fnd_api.g_exc_unexpected_error;

5342: Begin
5343: -- Calling PLM API to sync up item media index
5344: EGO_ITEM_PUB.SYNC_IM_INDEX ;
5345: Exception When others then
5346: raise fnd_api.g_exc_unexpected_error;
5347: End Syncup_item_media_index;
5348:
5349:
5350: