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

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

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

69: FND_MESSAGE.SET_NAME('BOM', 'BOM_GET_REV');
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

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

821: OPEN ITEM_REV;
822: FETCH ITEM_REV INTO rev_date;
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;

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

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

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

831: OPEN RTG_REV;
832: FETCH RTG_REV INTO rev_date;
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;

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

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

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

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

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

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

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

1009: FROM MTL_SYSTEM_ITEMS_VL msivl
1010: WHERE msivl.INVENTORY_ITEM_ID = item_id
1011: AND msivl.ORGANIZATION_ID = org_id;
1012:
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;

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

1010: WHERE msivl.INVENTORY_ITEM_ID = item_id
1011: AND msivl.ORGANIZATION_ID = org_id;
1012:
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:

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

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

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

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

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

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