28: --| supported for version 8i. |
29: --| 14/06/2004 shpandey Modified the If condition used before inserting the|
30: --| Qualitative data into MTL_COPY_ORG_REPORT table. |
31: --| for bug# 3678706. |
32: --| 18/08/2004 aujain Modified size of variables retreiving FND Messages |
33: --| for Bug 3838706. |
34: --| 12/04/2004 shpandey Added a function Get_Err_Wip_Acc_Classes for |
35: --| supporting Wip Accounting Classes entity for R12 |
36: --| also modified procedure Validate_Locs for |
384: -- );
385: -- END IF;
386: --EXCEPTION
387: -- WHEN OTHERS THEN
388: -- FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
389: -- FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
390: -- FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
391: -- FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
392: -- FND_MSG_PUB.Add;
385: -- END IF;
386: --EXCEPTION
387: -- WHEN OTHERS THEN
388: -- FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
389: -- FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
390: -- FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
391: -- FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
392: -- FND_MSG_PUB.Add;
393: -- RAISE;
386: --EXCEPTION
387: -- WHEN OTHERS THEN
388: -- FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
389: -- FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
390: -- FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
391: -- FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
392: -- FND_MSG_PUB.Add;
393: -- RAISE;
394: --
387: -- WHEN OTHERS THEN
388: -- FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
389: -- FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
390: -- FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
391: -- FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
392: -- FND_MSG_PUB.Add;
393: -- RAISE;
394: --
395: --END initialize;
455: END IF;
456:
457: EXCEPTION
458: WHEN OTHERS THEN
459: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
460: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
461: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
462: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
463: FND_MSG_PUB.Add;
456:
457: EXCEPTION
458: WHEN OTHERS THEN
459: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
460: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
461: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
462: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
463: FND_MSG_PUB.Add;
464: RAISE;
457: EXCEPTION
458: WHEN OTHERS THEN
459: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
460: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
461: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
462: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
463: FND_MSG_PUB.Add;
464: RAISE;
465:
458: WHEN OTHERS THEN
459: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
460: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
461: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
462: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
463: FND_MSG_PUB.Add;
464: RAISE;
465:
466: END Validate_Orgs;
578: WHEN OTHERS THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END;
581:
582: FND_MESSAGE.SET_NAME (application=>'INV', name=>'PRE_EXIST_ERROR');
583: FND_MESSAGE.SET_TOKEN ('CREATION_DATE' , l_creation_date );
584: FND_MESSAGE.SET_TOKEN ('TIMESTAMP', null);
585: l_message := FND_MESSAGE.GET();
586:
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END;
581:
582: FND_MESSAGE.SET_NAME (application=>'INV', name=>'PRE_EXIST_ERROR');
583: FND_MESSAGE.SET_TOKEN ('CREATION_DATE' , l_creation_date );
584: FND_MESSAGE.SET_TOKEN ('TIMESTAMP', null);
585: l_message := FND_MESSAGE.GET();
586:
587: ELSIF l_status = 'SUCCESS' THEN
580: END;
581:
582: FND_MESSAGE.SET_NAME (application=>'INV', name=>'PRE_EXIST_ERROR');
583: FND_MESSAGE.SET_TOKEN ('CREATION_DATE' , l_creation_date );
584: FND_MESSAGE.SET_TOKEN ('TIMESTAMP', null);
585: l_message := FND_MESSAGE.GET();
586:
587: ELSIF l_status = 'SUCCESS' THEN
588: l_message := '';
581:
582: FND_MESSAGE.SET_NAME (application=>'INV', name=>'PRE_EXIST_ERROR');
583: FND_MESSAGE.SET_TOKEN ('CREATION_DATE' , l_creation_date );
584: FND_MESSAGE.SET_TOKEN ('TIMESTAMP', null);
585: l_message := FND_MESSAGE.GET();
586:
587: ELSIF l_status = 'SUCCESS' THEN
588: l_message := '';
589: END IF;
614: END IF;
615:
616: EXCEPTION
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
619: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
620: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
621: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
622: FND_MSG_PUB.Add;
615:
616: EXCEPTION
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
619: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
620: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
621: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
622: FND_MSG_PUB.Add;
623: RAISE;
616: EXCEPTION
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
619: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
620: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
621: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
622: FND_MSG_PUB.Add;
623: RAISE;
624:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
619: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
620: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
621: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
622: FND_MSG_PUB.Add;
623: RAISE;
624:
625: WHEN OTHERS THEN
622: FND_MSG_PUB.Add;
623: RAISE;
624:
625: WHEN OTHERS THEN
626: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
627: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
628: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
629: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
630: FND_MSG_PUB.Add;
623: RAISE;
624:
625: WHEN OTHERS THEN
626: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
627: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
628: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
629: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
630: FND_MSG_PUB.Add;
631: RAISE;
624:
625: WHEN OTHERS THEN
626: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
627: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
628: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
629: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
630: FND_MSG_PUB.Add;
631: RAISE;
632:
625: WHEN OTHERS THEN
626: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
627: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
628: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
629: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
630: FND_MSG_PUB.Add;
631: RAISE;
632:
633: END Validate_Locs;
697: --------------------------------------------------------------------
698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
702: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
703: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
704: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
705: FND_MSG_PUB.Add;
698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
702: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
703: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
704: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
705: FND_MSG_PUB.Add;
706: RAISE;
699: EXCEPTION
700: WHEN OTHERS THEN
701: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
702: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
703: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
704: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
705: FND_MSG_PUB.Add;
706: RAISE;
707:
700: WHEN OTHERS THEN
701: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
702: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
703: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
704: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
705: FND_MSG_PUB.Add;
706: RAISE;
707:
708: END Init_Vars;
1036: RETURN 'SUCCESS';
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1041: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1042: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1043: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1044: FND_MSG_PUB.Add;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1041: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1042: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1043: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1044: FND_MSG_PUB.Add;
1045: RAISE;
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1041: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1042: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1043: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1044: FND_MSG_PUB.Add;
1045: RAISE;
1046:
1039: WHEN OTHERS THEN
1040: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1041: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1042: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1043: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1044: FND_MSG_PUB.Add;
1045: RAISE;
1046:
1047: END Validate_Entities;
1126:
1127: RETURN l_entity_names;
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1131: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1132: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1133: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1134: FND_MSG_PUB.Add;
1127: RETURN l_entity_names;
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1131: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1132: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1133: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1134: FND_MSG_PUB.Add;
1135: RAISE;
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1131: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1132: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1133: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1134: FND_MSG_PUB.Add;
1135: RAISE;
1136:
1129: WHEN OTHERS THEN
1130: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1131: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1132: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1133: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1134: FND_MSG_PUB.Add;
1135: RAISE;
1136:
1137: END Get_Err_Hierarchy;
1210:
1211: RETURN l_entity_names;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1215: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1216: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1217: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1218: FND_MSG_PUB.Add;
1211: RETURN l_entity_names;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1215: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1216: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1217: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1218: FND_MSG_PUB.Add;
1219: RAISE;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1215: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1216: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1217: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1218: FND_MSG_PUB.Add;
1219: RAISE;
1220:
1213: WHEN OTHERS THEN
1214: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1215: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1216: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1217: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1218: FND_MSG_PUB.Add;
1219: RAISE;
1220:
1221: END Get_Err_Subinv_Names;
1298:
1299: RETURN l_entity_names;
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1304: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1305: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1306: FND_MSG_PUB.Add;
1299: RETURN l_entity_names;
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1304: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1305: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1306: FND_MSG_PUB.Add;
1307: RAISE;
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1304: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1305: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1306: FND_MSG_PUB.Add;
1307: RAISE;
1308:
1301: WHEN OTHERS THEN
1302: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1304: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1305: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1306: FND_MSG_PUB.Add;
1307: RAISE;
1308:
1309: END Get_Err_Bom_Resources;
1382: l_entity_names(l_entity_arr_idx):=l_model_org_count;
1383: RETURN l_entity_names;
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1387: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1388: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1389: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1390: FND_MSG_PUB.Add;
1383: RETURN l_entity_names;
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1387: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1388: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1389: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1390: FND_MSG_PUB.Add;
1391: RAISE;
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1387: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1388: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1389: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1390: FND_MSG_PUB.Add;
1391: RAISE;
1392:
1385: WHEN OTHERS THEN
1386: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1387: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1388: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1389: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1390: FND_MSG_PUB.Add;
1391: RAISE;
1392:
1393: END Get_Err_Bom_Departments;
1468:
1469: RETURN l_entity_names;
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1473: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1474: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1475: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1476: FND_MSG_PUB.Add;
1469: RETURN l_entity_names;
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1473: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1474: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1475: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1476: FND_MSG_PUB.Add;
1477: RAISE;
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1473: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1474: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1475: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1476: FND_MSG_PUB.Add;
1477: RAISE;
1478:
1471: WHEN OTHERS THEN
1472: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1473: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1474: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1475: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1476: FND_MSG_PUB.Add;
1477: RAISE;
1478:
1479: END Get_Err_Bom_Dept_Classes;
1555:
1556: RETURN l_entity_names;
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1560: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1561: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1562: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1563: FND_MSG_PUB.Add;
1556: RETURN l_entity_names;
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1560: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1561: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1562: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1563: FND_MSG_PUB.Add;
1564: RAISE;
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1560: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1561: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1562: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1563: FND_MSG_PUB.Add;
1564: RAISE;
1565:
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1560: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1561: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1562: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1563: FND_MSG_PUB.Add;
1564: RAISE;
1565:
1566: END Get_Err_Bom_Alt_Desig;
1691: l_entity_names(l_entity_arr_idx):=l_model_org_count;
1692: RETURN l_entity_names;
1693: EXCEPTION
1694: WHEN OTHERS THEN
1695: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1696: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1697: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1698: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1699: FND_MSG_PUB.Add;
1692: RETURN l_entity_names;
1693: EXCEPTION
1694: WHEN OTHERS THEN
1695: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1696: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1697: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1698: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1699: FND_MSG_PUB.Add;
1700: RAISE;
1693: EXCEPTION
1694: WHEN OTHERS THEN
1695: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1696: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1697: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1698: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1699: FND_MSG_PUB.Add;
1700: RAISE;
1701:
1694: WHEN OTHERS THEN
1695: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1696: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1697: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1698: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1699: FND_MSG_PUB.Add;
1700: RAISE;
1701:
1702: END Get_Err_Ship_Net;
2077:
2078: RETURN l_entity_names;
2079: EXCEPTION
2080: WHEN OTHERS THEN
2081: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2082: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2083: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2084: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2085: FND_MSG_PUB.Add;
2078: RETURN l_entity_names;
2079: EXCEPTION
2080: WHEN OTHERS THEN
2081: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2082: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2083: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2084: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2085: FND_MSG_PUB.Add;
2086: RAISE;
2079: EXCEPTION
2080: WHEN OTHERS THEN
2081: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2082: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2083: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2084: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2085: FND_MSG_PUB.Add;
2086: RAISE;
2087:
2080: WHEN OTHERS THEN
2081: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2082: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2083: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2084: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2085: FND_MSG_PUB.Add;
2086: RAISE;
2087:
2088: END Get_Err_Bom_Bom;
2206:
2207: RETURN l_entity_names;
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2211: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2212: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2213: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2214: FND_MSG_PUB.Add;
2207: RETURN l_entity_names;
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2211: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2212: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2213: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2214: FND_MSG_PUB.Add;
2215: RAISE;
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2211: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2212: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2213: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2214: FND_MSG_PUB.Add;
2215: RAISE;
2216:
2209: WHEN OTHERS THEN
2210: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2211: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2212: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2213: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2214: FND_MSG_PUB.Add;
2215: RAISE;
2216:
2217: END Get_Err_Org_Information;
2299:
2300: RETURN l_entity_names;
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2304: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2305: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2306: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2307: FND_MSG_PUB.Add;
2300: RETURN l_entity_names;
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2304: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2305: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2306: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2307: FND_MSG_PUB.Add;
2308: RAISE;
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2304: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2305: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2306: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2307: FND_MSG_PUB.Add;
2308: RAISE;
2309:
2302: WHEN OTHERS THEN
2303: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2304: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2305: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2306: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2307: FND_MSG_PUB.Add;
2308: RAISE;
2309:
2310: END Get_Err_Mtl_Items;
2392:
2393: RETURN l_entity_names;
2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2397: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2398: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2399: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2400: FND_MSG_PUB.Add;
2393: RETURN l_entity_names;
2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2397: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2398: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2399: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2400: FND_MSG_PUB.Add;
2401: RAISE;
2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2397: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2398: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2399: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2400: FND_MSG_PUB.Add;
2401: RAISE;
2402:
2395: WHEN OTHERS THEN
2396: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2397: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2398: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2399: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2400: FND_MSG_PUB.Add;
2401: RAISE;
2402:
2403: END Get_Err_Mtl_Item_Cat;
2488:
2489: RETURN l_entity_names;
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2493: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2494: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2495: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2496: FND_MSG_PUB.Add;
2489: RETURN l_entity_names;
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2493: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2494: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2495: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2496: FND_MSG_PUB.Add;
2497: RAISE;
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2493: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2494: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2495: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2496: FND_MSG_PUB.Add;
2497: RAISE;
2498:
2491: WHEN OTHERS THEN
2492: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2493: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2494: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2495: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2496: FND_MSG_PUB.Add;
2497: RAISE;
2498:
2499: END Get_Err_Mtl_Item_Rev;
2581:
2582: RETURN l_entity_names;
2583: EXCEPTION
2584: WHEN OTHERS THEN
2585: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2586: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2587: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2588: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2589: FND_MSG_PUB.Add;
2582: RETURN l_entity_names;
2583: EXCEPTION
2584: WHEN OTHERS THEN
2585: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2586: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2587: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2588: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2589: FND_MSG_PUB.Add;
2590: RAISE;
2583: EXCEPTION
2584: WHEN OTHERS THEN
2585: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2586: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2587: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2588: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2589: FND_MSG_PUB.Add;
2590: RAISE;
2591:
2584: WHEN OTHERS THEN
2585: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2586: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2587: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2588: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2589: FND_MSG_PUB.Add;
2590: RAISE;
2591:
2592: END Get_Err_Mtl_Items_Subinv;
2675:
2676: RETURN l_entity_names;
2677: EXCEPTION
2678: WHEN OTHERS THEN
2679: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2680: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2681: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2682: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2683: FND_MSG_PUB.Add;
2676: RETURN l_entity_names;
2677: EXCEPTION
2678: WHEN OTHERS THEN
2679: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2680: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2681: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2682: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2683: FND_MSG_PUB.Add;
2684: RAISE;
2677: EXCEPTION
2678: WHEN OTHERS THEN
2679: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2680: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2681: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2682: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2683: FND_MSG_PUB.Add;
2684: RAISE;
2685:
2678: WHEN OTHERS THEN
2679: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2680: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2681: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2682: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2683: FND_MSG_PUB.Add;
2684: RAISE;
2685:
2686: END Get_Err_Mtl_Item_Locations;
2970:
2971: RETURN l_entity_names;
2972: EXCEPTION
2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2975: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2976: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2977: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2978: FND_MSG_PUB.Add;
2971: RETURN l_entity_names;
2972: EXCEPTION
2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2975: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2976: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2977: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2978: FND_MSG_PUB.Add;
2979: RAISE;
2972: EXCEPTION
2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2975: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2976: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2977: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2978: FND_MSG_PUB.Add;
2979: RAISE;
2980:
2973: WHEN OTHERS THEN
2974: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2975: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2976: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2977: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2978: FND_MSG_PUB.Add;
2979: RAISE;
2980:
2981: END Get_Err_StdOperations;
3497:
3498: RETURN l_entity_names;
3499: EXCEPTION
3500: WHEN OTHERS THEN
3501: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3502: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3503: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3504: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3505: FND_MSG_PUB.Add;
3498: RETURN l_entity_names;
3499: EXCEPTION
3500: WHEN OTHERS THEN
3501: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3502: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3503: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3504: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3505: FND_MSG_PUB.Add;
3506: RAISE;
3499: EXCEPTION
3500: WHEN OTHERS THEN
3501: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3502: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3503: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3504: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3505: FND_MSG_PUB.Add;
3506: RAISE;
3507:
3500: WHEN OTHERS THEN
3501: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3502: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3503: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3504: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3505: FND_MSG_PUB.Add;
3506: RAISE;
3507:
3508: END Get_Err_Routings;
3619:
3620: RETURN l_entity_names;
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3624: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3625: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3626: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3627: FND_MSG_PUB.Add;
3620: RETURN l_entity_names;
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3624: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3625: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3626: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3627: FND_MSG_PUB.Add;
3628: RAISE;
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3624: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3625: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3626: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3627: FND_MSG_PUB.Add;
3628: RAISE;
3629:
3622: WHEN OTHERS THEN
3623: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3624: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3625: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3626: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3627: FND_MSG_PUB.Add;
3628: RAISE;
3629:
3630: END Get_Err_Bom_Dept_Res;
3716:
3717: RETURN l_entity_names;
3718: EXCEPTION
3719: WHEN OTHERS THEN
3720: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3721: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3722: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3723: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3724: FND_MSG_PUB.Add;
3717: RETURN l_entity_names;
3718: EXCEPTION
3719: WHEN OTHERS THEN
3720: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3721: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3722: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3723: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3724: FND_MSG_PUB.Add;
3725: RAISE;
3718: EXCEPTION
3719: WHEN OTHERS THEN
3720: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3721: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3722: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3723: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3724: FND_MSG_PUB.Add;
3725: RAISE;
3726:
3719: WHEN OTHERS THEN
3720: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3721: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3722: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3723: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3724: FND_MSG_PUB.Add;
3725: RAISE;
3726:
3727: END Get_Err_Cst_Res_Costs;
3828: RETURN l_entity_names;
3829:
3830: EXCEPTION
3831: WHEN OTHERS THEN
3832: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3833: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3834: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3835: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3836: FND_MSG_PUB.Add;
3829:
3830: EXCEPTION
3831: WHEN OTHERS THEN
3832: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3833: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3834: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3835: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3836: FND_MSG_PUB.Add;
3837: RAISE;
3830: EXCEPTION
3831: WHEN OTHERS THEN
3832: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3833: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3834: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3835: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3836: FND_MSG_PUB.Add;
3837: RAISE;
3838:
3831: WHEN OTHERS THEN
3832: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3833: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3834: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3835: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3836: FND_MSG_PUB.Add;
3837: RAISE;
3838:
3839: END Get_Err_Cst_Res_Ovhds;
3941: --If Location already exists then Receiving Subinventories are not migrated, in such scenario
3942: --add proper message to Report.
3943: IF (g_location_status = 'PRE_EXIST') AND (g_entity_type = 'SUBINVENTORIES') THEN
3944: IF (Receiving_Subinv_Exist(g_model_org_id) = 'TRUE') THEN
3945: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_REC_SUB_INV_NOT_MIGRATED');
3946: l_message := FND_MESSAGE.GET();
3947: END IF;
3948: END IF;
3949: -------------------------------------------------------------------------
3942: --add proper message to Report.
3943: IF (g_location_status = 'PRE_EXIST') AND (g_entity_type = 'SUBINVENTORIES') THEN
3944: IF (Receiving_Subinv_Exist(g_model_org_id) = 'TRUE') THEN
3945: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_REC_SUB_INV_NOT_MIGRATED');
3946: l_message := FND_MESSAGE.GET();
3947: END IF;
3948: END IF;
3949: -------------------------------------------------------------------------
3950: -- Insert record counts for new / model org into report table.
3971: -- Get Threshold message if error records > G_THRESHOLD
3972: -------------------------------------------------------------------------
3973: IF g_entity_names.COUNT >= G_THRESHOLD
3974: THEN
3975: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_CO_THRESHOLD_MSG');
3976: FND_MESSAGE.SET_TOKEN('entity_type', g_entity_type);
3977: FND_MESSAGE.SET_TOKEN('threshold' , G_THRESHOLD);
3978: g_entity_names.EXTEND;
3979: g_entity_names(G_THRESHOLD) := '> '||FND_MESSAGE.GET();
3972: -------------------------------------------------------------------------
3973: IF g_entity_names.COUNT >= G_THRESHOLD
3974: THEN
3975: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_CO_THRESHOLD_MSG');
3976: FND_MESSAGE.SET_TOKEN('entity_type', g_entity_type);
3977: FND_MESSAGE.SET_TOKEN('threshold' , G_THRESHOLD);
3978: g_entity_names.EXTEND;
3979: g_entity_names(G_THRESHOLD) := '> '||FND_MESSAGE.GET();
3980: l_entity_count := G_THRESHOLD - 1;
3973: IF g_entity_names.COUNT >= G_THRESHOLD
3974: THEN
3975: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_CO_THRESHOLD_MSG');
3976: FND_MESSAGE.SET_TOKEN('entity_type', g_entity_type);
3977: FND_MESSAGE.SET_TOKEN('threshold' , G_THRESHOLD);
3978: g_entity_names.EXTEND;
3979: g_entity_names(G_THRESHOLD) := '> '||FND_MESSAGE.GET();
3980: l_entity_count := G_THRESHOLD - 1;
3981: l_message := g_entity_names(G_THRESHOLD);
3975: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_CO_THRESHOLD_MSG');
3976: FND_MESSAGE.SET_TOKEN('entity_type', g_entity_type);
3977: FND_MESSAGE.SET_TOKEN('threshold' , G_THRESHOLD);
3978: g_entity_names.EXTEND;
3979: g_entity_names(G_THRESHOLD) := '> '||FND_MESSAGE.GET();
3980: l_entity_count := G_THRESHOLD - 1;
3981: l_message := g_entity_names(G_THRESHOLD);
3982: Insert_Row ( p_location_code => ''
3983: , p_business_group_name => ''
4004: --for bug# 3678706
4005: IF l_entity_count >= 1
4006: -- end of fix for bug# 3678706
4007: THEN
4008: FND_MESSAGE.SET_NAME ( application=>'INV', name=>l_mesg_name );
4009: FND_MESSAGE.SET_TOKEN ( 'entity_type', g_entity_type );
4010: l_message := FND_MESSAGE.GET();
4011: --dbms_output.put_line(l_message);
4012: FORALL i IN 1..l_entity_count
4005: IF l_entity_count >= 1
4006: -- end of fix for bug# 3678706
4007: THEN
4008: FND_MESSAGE.SET_NAME ( application=>'INV', name=>l_mesg_name );
4009: FND_MESSAGE.SET_TOKEN ( 'entity_type', g_entity_type );
4010: l_message := FND_MESSAGE.GET();
4011: --dbms_output.put_line(l_message);
4012: FORALL i IN 1..l_entity_count
4013: INSERT INTO mtl_copy_org_report
4006: -- end of fix for bug# 3678706
4007: THEN
4008: FND_MESSAGE.SET_NAME ( application=>'INV', name=>l_mesg_name );
4009: FND_MESSAGE.SET_TOKEN ( 'entity_type', g_entity_type );
4010: l_message := FND_MESSAGE.GET();
4011: --dbms_output.put_line(l_message);
4012: FORALL i IN 1..l_entity_count
4013: INSERT INTO mtl_copy_org_report
4014: ( GROUP_CODE
4043: END IF;
4044:
4045: EXCEPTION
4046: WHEN OTHERS THEN
4047: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4048: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4049: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4050: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4051: FND_MSG_PUB.Add;
4044:
4045: EXCEPTION
4046: WHEN OTHERS THEN
4047: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4048: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4049: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4050: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4051: FND_MSG_PUB.Add;
4052: RAISE;
4045: EXCEPTION
4046: WHEN OTHERS THEN
4047: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4048: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4049: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4050: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4051: FND_MSG_PUB.Add;
4052: RAISE;
4053:
4046: WHEN OTHERS THEN
4047: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4048: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4049: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4050: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4051: FND_MSG_PUB.Add;
4052: RAISE;
4053:
4054: END Put_Report_Data;
4055:
4056: --=============================================================================
4057: -- PROC NAME : Insert_Row
4058: -- PRE-CONDITIONS: None.
4059: -- DESCRIPTION : Get the translated message from FND MESSAGES table.
4060: -- PARAMETERS :
4061: -- p_msg_name REQUIRED. Name of the error message.
4062: -- p_token_array REQUIRED. List of token name/values in error message.
4063: --
4143: END IF;
4144:
4145: EXCEPTION
4146: WHEN OTHERS THEN
4147: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4148: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4149: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4150: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4151: FND_MSG_PUB.Add;
4144:
4145: EXCEPTION
4146: WHEN OTHERS THEN
4147: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4148: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4149: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4150: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4151: FND_MSG_PUB.Add;
4152: RAISE;
4145: EXCEPTION
4146: WHEN OTHERS THEN
4147: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4148: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4149: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4150: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4151: FND_MSG_PUB.Add;
4152: RAISE;
4153:
4146: WHEN OTHERS THEN
4147: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4148: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4149: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4150: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4151: FND_MSG_PUB.Add;
4152: RAISE;
4153:
4154: END Insert_Row;
4207:
4208: RETURN l_org_id;
4209: EXCEPTION
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4212: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4213: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4214: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4215: FND_MSG_PUB.Add;
4208: RETURN l_org_id;
4209: EXCEPTION
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4212: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4213: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4214: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4215: FND_MSG_PUB.Add;
4216: RAISE;
4209: EXCEPTION
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4212: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4213: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4214: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4215: FND_MSG_PUB.Add;
4216: RAISE;
4217:
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4212: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4213: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4214: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4215: FND_MSG_PUB.Add;
4216: RAISE;
4217:
4218: END Get_Organization_Id;
4216: RAISE;
4217:
4218: END Get_Organization_Id;
4219: --=============================================================================
4220: -- FUNCTION NAME : Get_Fnd_Message
4221: -- PRE-CONDITIONS: None.
4222: -- DESCRIPTION : Get the translated message from FND MESSAGES table.
4223: -- PARAMETERS :
4224: -- p_msg_name REQUIRED. Name of the error message.
4218: END Get_Organization_Id;
4219: --=============================================================================
4220: -- FUNCTION NAME : Get_Fnd_Message
4221: -- PRE-CONDITIONS: None.
4222: -- DESCRIPTION : Get the translated message from FND MESSAGES table.
4223: -- PARAMETERS :
4224: -- p_msg_name REQUIRED. Name of the error message.
4225: -- p_token_array REQUIRED. List of token name/values in error message.
4226: --
4226: --
4227: -- EXCEPTIONS : None.
4228: --
4229: --=============================================================================
4230: FUNCTION Get_Fnd_Message
4231: ( p_msg_name IN VARCHAR2
4232: , p_token_array IN Token_Hash
4233: ) RETURN VARCHAR2
4234: IS
4235: -- Modified for bug 3838706
4236: -- l_message VARCHAR2(1000);
4237: l_message VARCHAR2(2000);
4238: l_app VARCHAR2(10):='INV';
4239: l_api_name VARCHAR2(100):=' Get_Fnd_Message ';
4240: BEGIN
4241:
4242: IF G_DEBUG = 'Y' THEN
4243: FND_MSG_PUB.ADD_EXC_MSG
4242: IF G_DEBUG = 'Y' THEN
4243: FND_MSG_PUB.ADD_EXC_MSG
4244: ( G_PKG_NAME
4245: , l_api_name
4246: , '> Get_Fnd_Message '
4247: );
4248: END IF;
4249:
4250: FND_MESSAGE.SET_NAME( application => l_app, name => p_msg_name );
4246: , '> Get_Fnd_Message '
4247: );
4248: END IF;
4249:
4250: FND_MESSAGE.SET_NAME( application => l_app, name => p_msg_name );
4251: FOR i IN 1..p_token_array.COUNT
4252: LOOP
4253: FND_MESSAGE.SET_TOKEN
4254: ( p_token_array(i).token_name
4249:
4250: FND_MESSAGE.SET_NAME( application => l_app, name => p_msg_name );
4251: FOR i IN 1..p_token_array.COUNT
4252: LOOP
4253: FND_MESSAGE.SET_TOKEN
4254: ( p_token_array(i).token_name
4255: , p_token_array(i).token_value
4256: );
4257: END LOOP;
4255: , p_token_array(i).token_value
4256: );
4257: END LOOP;
4258:
4259: SELECT FND_MESSAGE.GET()
4260: INTO l_message
4261: FROM dual;
4262:
4263: IF G_DEBUG = 'Y' THEN
4263: IF G_DEBUG = 'Y' THEN
4264: FND_MSG_PUB.ADD_EXC_MSG
4265: ( G_PKG_NAME
4266: , l_api_name
4267: , '< Get_Fnd_Message '
4268: );
4269: END IF;
4270:
4271: RETURN l_message;
4269: END IF;
4270:
4271: RETURN l_message;
4272:
4273: END Get_Fnd_Message;
4274: --=============================================================================
4275: -- FUNCTION NAME : Purge_Copy_Org_Report
4276: -- PRE-CONDITIONS: None.
4277: -- DESCRIPTION : Purge records from the Copy Org Report table for the
4314: RETURN true;
4315:
4316: EXCEPTION
4317: WHEN OTHERS THEN
4318: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4319: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4320: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4321: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4322: FND_MSG_PUB.Add;
4315:
4316: EXCEPTION
4317: WHEN OTHERS THEN
4318: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4319: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4320: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4321: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4322: FND_MSG_PUB.Add;
4323: RAISE;
4316: EXCEPTION
4317: WHEN OTHERS THEN
4318: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4319: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4320: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4321: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4322: FND_MSG_PUB.Add;
4323: RAISE;
4324:
4317: WHEN OTHERS THEN
4318: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4319: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4320: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4321: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4322: FND_MSG_PUB.Add;
4323: RAISE;
4324:
4325: END Purge_Copy_Org_Report;
4376: EXCEPTION
4377: WHEN NO_DATA_FOUND THEN
4378: RETURN 'FALSE';
4379: WHEN OTHERS THEN
4380: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4381: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4382: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4383: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4384: FND_MSG_PUB.Add;
4377: WHEN NO_DATA_FOUND THEN
4378: RETURN 'FALSE';
4379: WHEN OTHERS THEN
4380: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4381: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4382: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4383: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4384: FND_MSG_PUB.Add;
4385: RAISE;
4378: RETURN 'FALSE';
4379: WHEN OTHERS THEN
4380: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4381: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4382: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4383: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4384: FND_MSG_PUB.Add;
4385: RAISE;
4386:
4379: WHEN OTHERS THEN
4380: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4381: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4382: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4383: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4384: FND_MSG_PUB.Add;
4385: RAISE;
4386:
4387: END Receiving_Subinv_Exist;
4501:
4502: RETURN l_entity_names;
4503: EXCEPTION
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4506: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4507: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4508: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4509: FND_MSG_PUB.Add;
4502: RETURN l_entity_names;
4503: EXCEPTION
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4506: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4507: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4508: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4509: FND_MSG_PUB.Add;
4510: RAISE;
4503: EXCEPTION
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4506: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4507: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4508: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4509: FND_MSG_PUB.Add;
4510: RAISE;
4511:
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4506: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4507: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4508: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4509: FND_MSG_PUB.Add;
4510: RAISE;
4511:
4512: END Get_Err_Wip_Acc_Classes;