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 74: APP_EXCEPTION.RAISE_EXCEPTION;

70: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', part_number);
71: --line below changed for calendar internationalization project
72: --value 2 for calendar_aware parameter means FND_DATE.calendar_aware_alt
73: FND_MESSAGE.SET_TOKEN('EFF_DATE', fnd_date.date_to_displaydt(rev_date, 2));
74: APP_EXCEPTION.RAISE_EXCEPTION;
75:
76: EXCEPTION
77: WHEN NO_DATA_FOUND THEN
78: RAISE_REVISION_ERROR (func_name => 'RAISE_NO_REV_ERROR',

Line 827: APP_EXCEPTION.RAISE_EXCEPTION;

823: IF (ITEM_REV%NOTFOUND) THEN
824: CLOSE ITEM_REV;
825: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REVDATE');
826: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);
827: APP_EXCEPTION.RAISE_EXCEPTION;
828: END IF;
829: CLOSE ITEM_REV;
830: ELSE /* IF (type = PROCESS) THEN */
831: OPEN RTG_REV;

Line 837: APP_EXCEPTION.RAISE_EXCEPTION;

833: IF (ITEM_REV%NOTFOUND) THEN
834: CLOSE RTG_REV;
835: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REVDATE');
836: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);
837: APP_EXCEPTION.RAISE_EXCEPTION;
838: END IF;
839: CLOSE RTG_REV;
840: END IF;
841:

Line 1003: APP_EXCEPTION.RAISE_EXCEPTION;

999: ** Name: MFG_NOT_VALID
1000: ** ENTITY: itm_rev
1001: FND_MESSAGE.SET_NAME('INV', 'INV_NOT_VALID');
1002: FND_MESSAGE.SET_TOKEN('ENTITY', itm_rev);
1003: APP_EXCEPTION.RAISE_EXCEPTION;
1004: */
1005: -- bug:2120090 Raise meaningful error as Revision does not exist.
1006: -- Get the Item Name from Id
1007: SELECT msivl.CONCATENATED_SEGMENTS

Line 1017: APP_EXCEPTION.RAISE_EXCEPTION;

1013: FND_MESSAGE.SET_NAME('BOM', 'BOM_REVISION_DOESNOT_EXIST');
1014: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);
1015: FND_MESSAGE.SET_TOKEN('ASSEMBLY_ITEM_NAME', l_item_name);
1016:
1017: APP_EXCEPTION.RAISE_EXCEPTION;
1018:
1019: WHEN OTHERS THEN
1020: RAISE_REVISION_ERROR (
1021: func_name => 'GET_HIGH_DATE',

Line 1100: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1109: APP_EXCEPTION.RAISE_EXCEPTION;

1105: FETCH RTG_REV INTO l_rev;
1106: IF RTG_REV%NOTFOUND THEN
1107: CLOSE RTG_REV;
1108: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV_DATE');
1109: APP_EXCEPTION.RAISE_EXCEPTION;
1110: END IF;
1111: CLOSE RTG_REV;
1112:
1113: END IF;