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.INV_COPY_ORGANIZATION_REPORT dependencies on FND_MESSAGE

Line 32: --| 18/08/2004 aujain Modified size of variables retreiving FND Messages |

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 |

Line 388: -- FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 389: -- FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 390: -- FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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: --

Line 391: -- FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 459: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 460: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 461: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 462: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 582: FND_MESSAGE.SET_NAME (application=>'INV', name=>'PRE_EXIST_ERROR');

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:

Line 583: FND_MESSAGE.SET_TOKEN ('CREATION_DATE' , l_creation_date );

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

Line 584: FND_MESSAGE.SET_TOKEN ('TIMESTAMP', null);

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 := '';

Line 585: l_message := FND_MESSAGE.GET();

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;

Line 618: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 619: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 620: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 621: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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

Line 626: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 627: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 628: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 629: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 701: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 702: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 703: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 704: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1040: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1041: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1042: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1043: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1130: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1131: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1132: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1133: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1214: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1215: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1216: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1217: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1302: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1303: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1304: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1305: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1386: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1387: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1388: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1389: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1472: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1473: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1474: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1475: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1559: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1560: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1561: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1562: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 1695: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 1696: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 1697: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 1698: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2081: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2082: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2083: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2084: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2210: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2211: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2212: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2213: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2303: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2304: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2305: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2306: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2396: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2397: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2398: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2399: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2492: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2493: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2494: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2495: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2585: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2586: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2587: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2588: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2679: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2680: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2681: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2682: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 2974: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 2975: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 2976: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 2977: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 3501: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 3502: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 3503: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 3504: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 3623: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 3624: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 3625: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 3626: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 3720: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 3721: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 3722: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 3723: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 3832: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 3833: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 3834: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 3835: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 3945: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_REC_SUB_INV_NOT_MIGRATED');

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: -------------------------------------------------------------------------

Line 3946: l_message := FND_MESSAGE.GET();

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.

Line 3975: FND_MESSAGE.SET_NAME (application=>'INV', name=>'INV_CO_THRESHOLD_MSG');

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();

Line 3976: FND_MESSAGE.SET_TOKEN('entity_type', g_entity_type);

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;

Line 3977: FND_MESSAGE.SET_TOKEN('threshold' , G_THRESHOLD);

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);

Line 3979: g_entity_names(G_THRESHOLD) := '> '||FND_MESSAGE.GET();

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 => ''

Line 4008: FND_MESSAGE.SET_NAME ( application=>'INV', name=>l_mesg_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

Line 4009: FND_MESSAGE.SET_TOKEN ( 'entity_type', g_entity_type );

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

Line 4010: l_message := FND_MESSAGE.GET();

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

Line 4047: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 4048: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 4049: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 4050: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 4059: -- DESCRIPTION : Get the translated message from FND MESSAGES table.

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: --

Line 4147: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 4148: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 4149: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 4150: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 4211: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 4212: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 4213: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 4214: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 4220: -- FUNCTION NAME : Get_Fnd_Message

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.

Line 4222: -- DESCRIPTION : Get the translated message from FND MESSAGES table.

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: --

Line 4230: FUNCTION Get_Fnd_Message

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

Line 4239: l_api_name VARCHAR2(100):=' Get_Fnd_Message ';

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

Line 4246: , '> Get_Fnd_Message '

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 );

Line 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

Line 4253: FND_MESSAGE.SET_TOKEN

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;

Line 4259: SELECT FND_MESSAGE.GET()

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

Line 4267: , '< Get_Fnd_Message '

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;

Line 4273: END Get_Fnd_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

Line 4318: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 4319: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 4320: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 4321: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 4380: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 4381: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 4382: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 4383: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;

Line 4505: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

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;

Line 4506: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));

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;

Line 4507: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);

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:

Line 4508: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );

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;