APPS.BOM_REVISIONS dependencies on APP_EXCEPTION

Line 28: APP_EXCEPTION.RAISE_EXCEPTION;

24: BEGIN
25: err_text := func_name || '(' || stmt_num || ')' || SQLERRM;
26: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
27: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
28: APP_EXCEPTION.RAISE_EXCEPTION;
29: /*EXCEPTION
30: WHEN OTHERS THEN
31: NULL;*/ -- BUG 4919190
32: END RAISE_REVISION_ERROR;

Line 72: APP_EXCEPTION.RAISE_EXCEPTION;

68:
69: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV');
70: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', part_number);
71: FND_MESSAGE.SET_TOKEN('EFF_DATE', fnd_date.date_to_displaydt(rev_date));
72: APP_EXCEPTION.RAISE_EXCEPTION;
73:
74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN
76: RAISE_REVISION_ERROR (func_name => 'RAISE_NO_REV_ERROR',

Line 818: APP_EXCEPTION.RAISE_EXCEPTION;

814: IF (ITEM_REV%NOTFOUND) THEN
815: CLOSE ITEM_REV;
816: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REVDATE');
817: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);
818: APP_EXCEPTION.RAISE_EXCEPTION;
819: END IF;
820: CLOSE ITEM_REV;
821: ELSE /* IF (type = PROCESS) THEN */
822: OPEN RTG_REV;

Line 828: APP_EXCEPTION.RAISE_EXCEPTION;

824: IF (ITEM_REV%NOTFOUND) THEN
825: CLOSE RTG_REV;
826: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REVDATE');
827: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);
828: APP_EXCEPTION.RAISE_EXCEPTION;
829: END IF;
830: CLOSE RTG_REV;
831: END IF;
832:

Line 994: APP_EXCEPTION.RAISE_EXCEPTION;

990: ** Name: MFG_NOT_VALID
991: ** ENTITY: itm_rev
992: FND_MESSAGE.SET_NAME('INV', 'INV_NOT_VALID');
993: FND_MESSAGE.SET_TOKEN('ENTITY', itm_rev);
994: APP_EXCEPTION.RAISE_EXCEPTION;
995: */
996: -- bug:2120090 Raise meaningful error as Revision does not exist.
997: -- Get the Item Name from Id
998: SELECT msivl.CONCATENATED_SEGMENTS

Line 1008: APP_EXCEPTION.RAISE_EXCEPTION;

1004: FND_MESSAGE.SET_NAME('BOM', 'BOM_REVISION_DOESNOT_EXIST');
1005: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);
1006: FND_MESSAGE.SET_TOKEN('ASSEMBLY_ITEM_NAME', l_item_name);
1007:
1008: APP_EXCEPTION.RAISE_EXCEPTION;
1009:
1010: WHEN OTHERS THEN
1011: RAISE_REVISION_ERROR (
1012: func_name => 'GET_HIGH_DATE',

Line 1091: APP_EXCEPTION.RAISE_EXCEPTION;

1087: FETCH ITEM_REV INTO l_rev;
1088: IF ITEM_REV%NOTFOUND THEN
1089: CLOSE ITEM_REV;
1090: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV_DATE');
1091: APP_EXCEPTION.RAISE_EXCEPTION;
1092: END IF;
1093: CLOSE ITEM_REV;
1094: ELSE
1095: OPEN RTG_REV;

Line 1100: APP_EXCEPTION.RAISE_EXCEPTION;

1096: FETCH RTG_REV INTO l_rev;
1097: IF RTG_REV%NOTFOUND THEN
1098: CLOSE RTG_REV;
1099: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV_DATE');
1100: APP_EXCEPTION.RAISE_EXCEPTION;
1101: END IF;
1102: CLOSE RTG_REV;
1103:
1104: END IF;