DBA Data[Home] [Help]

APPS.BOM_REVISIONS dependencies on FND_MESSAGE

Line 26: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');

22: IS
23: err_text VARCHAR2(2000);
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

Line 27: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);

23: err_text VARCHAR2(2000);
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

Line 69: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV');

65: ** EFF_DATE: rev_date
66: ** ITEM_NUMBER: select from mtl_item_flexfields
67: */
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:

Line 70: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', part_number);

66: ** ITEM_NUMBER: select from mtl_item_flexfields
67: */
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

Line 71: FND_MESSAGE.SET_TOKEN('EFF_DATE', fnd_date.date_to_displaydt(rev_date));

67: */
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

Line 816: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REVDATE');

812: OPEN ITEM_REV;
813: FETCH ITEM_REV INTO rev_date;
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;

Line 817: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);

813: FETCH ITEM_REV INTO rev_date;
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 */

Line 826: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REVDATE');

822: OPEN RTG_REV;
823: FETCH RTG_REV INTO rev_date;
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;

Line 827: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);

823: FETCH RTG_REV INTO rev_date;
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;

Line 992: FND_MESSAGE.SET_NAME('INV', 'INV_NOT_VALID');

988: /*
989: ** display message to say item rev not valid
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.

Line 993: FND_MESSAGE.SET_TOKEN('ENTITY', itm_rev);

989: ** display message to say item rev not valid
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

Line 1004: FND_MESSAGE.SET_NAME('BOM', 'BOM_REVISION_DOESNOT_EXIST');

1000: FROM MTL_SYSTEM_ITEMS_VL msivl
1001: WHERE msivl.INVENTORY_ITEM_ID = item_id
1002: AND msivl.ORGANIZATION_ID = org_id;
1003:
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;

Line 1005: FND_MESSAGE.SET_TOKEN('REVISION', itm_rev);

1001: WHERE msivl.INVENTORY_ITEM_ID = item_id
1002: AND msivl.ORGANIZATION_ID = org_id;
1003:
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:

Line 1006: FND_MESSAGE.SET_TOKEN('ASSEMBLY_ITEM_NAME', l_item_name);

1002: AND msivl.ORGANIZATION_ID = org_id;
1003:
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

Line 1090: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV_DATE');

1086: OPEN ITEM_REV;
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

Line 1099: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV_DATE');

1095: OPEN RTG_REV;
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: