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

Line 278: FND_MESSAGE.set_name('INV','INV_QTYBTWN_ISSREC');

274:
275: -- Check the Input variable receipt_issue is either Issue or Receipt
276: -- Otherwise return error message
277: IF p_receipt_issue_flag NOT IN ('I','R') then
278: FND_MESSAGE.set_name('INV','INV_QTYBTWN_ISSREC');
279: FND_MSG_PUB.Add;
280: x_errorcode := 116;
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;

Line 672: FND_MESSAGE.set_name('INV','INV_SER_UNIQ1');

668: WHERE SERIAL_NUMBER = P_serial_number
669: AND CURRENT_ORGANIZATION_ID + 0 = P_org_id;
670: --
671: if L_nothing is not NULL then
672: FND_MESSAGE.set_name('INV','INV_SER_UNIQ1');
673: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
674: FND_MSG_PUB.Add;
675: x_errorcode := 113;
676: RAISE FND_API.G_EXC_ERROR;

Line 673: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

669: AND CURRENT_ORGANIZATION_ID + 0 = P_org_id;
670: --
671: if L_nothing is not NULL then
672: FND_MESSAGE.set_name('INV','INV_SER_UNIQ1');
673: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
674: FND_MSG_PUB.Add;
675: x_errorcode := 113;
676: RAISE FND_API.G_EXC_ERROR;
677: end if;

Line 680: FND_MESSAGE.set_name('INV','INV_SER_UNIQ1');

676: RAISE FND_API.G_EXC_ERROR;
677: end if;
678: EXCEPTION
679: WHEN TOO_MANY_ROWS THEN
680: FND_MESSAGE.set_name('INV','INV_SER_UNIQ1');
681: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
682: FND_MSG_PUB.Add;
683: x_errorcode := 113;
684: RAISE FND_API.G_EXC_ERROR;

Line 681: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

677: end if;
678: EXCEPTION
679: WHEN TOO_MANY_ROWS THEN
680: FND_MESSAGE.set_name('INV','INV_SER_UNIQ1');
681: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
682: FND_MSG_PUB.Add;
683: x_errorcode := 113;
684: RAISE FND_API.G_EXC_ERROR;
685:

Line 700: FND_MESSAGE.set_name('INV','INV_SER_UNIACR');

696: AND S.SERIAL_NUMBER = P_serial_number
697: AND P.SERIAL_NUMBER_TYPE = 3;
698:
699: if L_nothing is not NULL then
700: FND_MESSAGE.set_name('INV','INV_SER_UNIACR');
701: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
702: FND_MSG_PUB.Add;
703: x_errorcode := 114;
704: raise FND_API.G_EXC_ERROR;

Line 701: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

697: AND P.SERIAL_NUMBER_TYPE = 3;
698:
699: if L_nothing is not NULL then
700: FND_MESSAGE.set_name('INV','INV_SER_UNIACR');
701: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
702: FND_MSG_PUB.Add;
703: x_errorcode := 114;
704: raise FND_API.G_EXC_ERROR;
705: end if;

Line 709: FND_MESSAGE.set_name('INV','INV_SER_UNIACR');

705: end if;
706:
707: EXCEPTION
708: WHEN TOO_MANY_ROWS THEN
709: FND_MESSAGE.set_name('INV','INV_SER_UNIACR');
710: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
711: FND_MSG_PUB.Add;
712: x_errorcode := 114;
713: RAISE FND_API.G_EXC_ERROR;

Line 710: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

706:
707: EXCEPTION
708: WHEN TOO_MANY_ROWS THEN
709: FND_MESSAGE.set_name('INV','INV_SER_UNIACR');
710: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
711: FND_MSG_PUB.Add;
712: x_errorcode := 114;
713: RAISE FND_API.G_EXC_ERROR;
714: WHEN NO_DATA_FOUND THEN

Line 725: FND_MESSAGE.set_name('INV','INV_INLTIS_SER1');

721: INTO L_nothing
722: FROM MTL_SERIAL_NUMBERS
723: WHERE SERIAL_NUMBER = P_serial_number;
724: if L_nothing is not NULL then
725: FND_MESSAGE.set_name('INV','INV_INLTIS_SER1');
726: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
727: FND_MSG_PUB.Add;
728: x_errorcode := 115;
729: RAISE FND_API.G_EXC_ERROR;

Line 726: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

722: FROM MTL_SERIAL_NUMBERS
723: WHERE SERIAL_NUMBER = P_serial_number;
724: if L_nothing is not NULL then
725: FND_MESSAGE.set_name('INV','INV_INLTIS_SER1');
726: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
727: FND_MSG_PUB.Add;
728: x_errorcode := 115;
729: RAISE FND_API.G_EXC_ERROR;
730: end if;

Line 733: FND_MESSAGE.set_name('INV','INV_INLTIS_SER1');

729: RAISE FND_API.G_EXC_ERROR;
730: end if;
731: EXCEPTION
732: WHEN TOO_MANY_ROWS THEN
733: FND_MESSAGE.set_name('INV','INV_INLTIS_SER1');
734: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
735: FND_MSG_PUB.Add;
736: x_errorcode := 115;
737: RAISE FND_API.G_EXC_ERROR;

Line 734: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

730: end if;
731: EXCEPTION
732: WHEN TOO_MANY_ROWS THEN
733: FND_MESSAGE.set_name('INV','INV_INLTIS_SER1');
734: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
735: FND_MSG_PUB.Add;
736: x_errorcode := 115;
737: RAISE FND_API.G_EXC_ERROR;
738: WHEN NO_DATA_FOUND THEN

Line 883: FND_MESSAGE.SET_NAME('INV', 'INV_INLTIS_SNGET_MASK');

879: x_mask := L_sn_mask(L_group);
880: END LOOP;
881:
882: IF x_to_status = 0 then
883: FND_MESSAGE.SET_NAME('INV', 'INV_INLTIS_SNGET_MASK');
884: FND_MSG_PUB.Add;
885: x_errorcode := 123;
886: return(FALSE);
887: ELSE

Line 1013: FND_MESSAGE.set_name('INV','INV_SER_INVALID_STATUS');

1009: IF L_current_status is NULL or
1010: L_current_status = 2 or
1011: L_current_status < 1 or
1012: L_current_status > 5 then
1013: FND_MESSAGE.set_name('INV','INV_SER_INVALID_STATUS');
1014: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1015: FND_MSG_PUB.Add;
1016: x_errorcode := 105;
1017: raise FND_API.G_EXC_ERROR;

Line 1014: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);

1010: L_current_status = 2 or
1011: L_current_status < 1 or
1012: L_current_status > 5 then
1013: FND_MESSAGE.set_name('INV','INV_SER_INVALID_STATUS');
1014: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1015: FND_MSG_PUB.Add;
1016: x_errorcode := 105;
1017: raise FND_API.G_EXC_ERROR;
1018: END IF;

Line 1031: FND_MESSAGE.set_name('INV','INV_SER_STATUS_NA');

1027: mdebug ('SNValidate : current status '||to_char(L_current_status));
1028: mdebug ('SNValidate : Mask '||P_mask);
1029: END IF;
1030: IF substr(P_mask,L_current_status+7,1)='0' then
1031: FND_MESSAGE.set_name('INV','INV_SER_STATUS_NA');
1032: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1033: FND_MSG_PUB.Add;
1034: x_errorcode := 106;
1035: raise FND_API.G_EXC_ERROR;

Line 1032: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);

1028: mdebug ('SNValidate : Mask '||P_mask);
1029: END IF;
1030: IF substr(P_mask,L_current_status+7,1)='0' then
1031: FND_MESSAGE.set_name('INV','INV_SER_STATUS_NA');
1032: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1033: FND_MSG_PUB.Add;
1034: x_errorcode := 106;
1035: raise FND_API.G_EXC_ERROR;
1036: END IF;

Line 1058: FND_MESSAGE.set_name('INV','INV_SER_ORG_INVALID');

1054:
1055: IF (L_current_status = 3 or
1056: L_current_status = 1) AND
1057: L_current_organization_id <> p_org_id then
1058: FND_MESSAGE.set_name('INV','INV_SER_ORG_INVALID');
1059: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1060: FND_MSG_PUB.Add;
1061: x_errorcode := 107;
1062: RAISE FND_API.G_EXC_ERROR;

Line 1059: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);

1055: IF (L_current_status = 3 or
1056: L_current_status = 1) AND
1057: L_current_organization_id <> p_org_id then
1058: FND_MESSAGE.set_name('INV','INV_SER_ORG_INVALID');
1059: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1060: FND_MSG_PUB.Add;
1061: x_errorcode := 107;
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;

Line 1071: FND_MESSAGE.set_name('INV','INV_SER_REV_INVALID');

1067: END IF;
1068:
1069: IF L_current_status = 3 then
1070: IF L_current_revision <> P_revision then
1071: FND_MESSAGE.set_name('INV','INV_SER_REV_INVALID');
1072: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1073: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_revision);
1074: FND_MSG_PUB.Add;
1075: x_errorcode := 108;

Line 1072: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

1068:
1069: IF L_current_status = 3 then
1070: IF L_current_revision <> P_revision then
1071: FND_MESSAGE.set_name('INV','INV_SER_REV_INVALID');
1072: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1073: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_revision);
1074: FND_MSG_PUB.Add;
1075: x_errorcode := 108;
1076: raise FND_API.G_EXC_ERROR;

Line 1073: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_revision);

1069: IF L_current_status = 3 then
1070: IF L_current_revision <> P_revision then
1071: FND_MESSAGE.set_name('INV','INV_SER_REV_INVALID');
1072: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1073: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_revision);
1074: FND_MSG_PUB.Add;
1075: x_errorcode := 108;
1076: raise FND_API.G_EXC_ERROR;
1077: ELSIF L_current_lot_number <> P_lot_number then

Line 1078: FND_MESSAGE.set_name('INV','INV_SER_LOT_INVALID');

1074: FND_MSG_PUB.Add;
1075: x_errorcode := 108;
1076: raise FND_API.G_EXC_ERROR;
1077: ELSIF L_current_lot_number <> P_lot_number then
1078: FND_MESSAGE.set_name('INV','INV_SER_LOT_INVALID');
1079: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1080: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_lot_number);
1081: FND_MSG_PUB.Add;
1082: x_errorcode := 109;

Line 1079: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

1075: x_errorcode := 108;
1076: raise FND_API.G_EXC_ERROR;
1077: ELSIF L_current_lot_number <> P_lot_number then
1078: FND_MESSAGE.set_name('INV','INV_SER_LOT_INVALID');
1079: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1080: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_lot_number);
1081: FND_MSG_PUB.Add;
1082: x_errorcode := 109;
1083: raise FND_API.G_EXC_ERROR;

Line 1080: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_lot_number);

1076: raise FND_API.G_EXC_ERROR;
1077: ELSIF L_current_lot_number <> P_lot_number then
1078: FND_MESSAGE.set_name('INV','INV_SER_LOT_INVALID');
1079: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1080: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_lot_number);
1081: FND_MSG_PUB.Add;
1082: x_errorcode := 109;
1083: raise FND_API.G_EXC_ERROR;
1084: END IF;

Line 1096: FND_MESSAGE.set_name('INV','INV_SER_SUB_INVALID');

1092: mdebug ('SNValidate : Before mask check 0 - 3 ');
1093: END IF;
1094: IF substr(P_mask,1,1)='I' and L_current_status = 3 then
1095: IF L_current_subinventory <> P_subinventory then
1096: FND_MESSAGE.set_name('INV','INV_SER_SUB_INVALID');
1097: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1098: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_subinventory);
1099: FND_MSG_PUB.Add;
1100: x_errorcode := 110;

Line 1097: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

1093: END IF;
1094: IF substr(P_mask,1,1)='I' and L_current_status = 3 then
1095: IF L_current_subinventory <> P_subinventory then
1096: FND_MESSAGE.set_name('INV','INV_SER_SUB_INVALID');
1097: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1098: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_subinventory);
1099: FND_MSG_PUB.Add;
1100: x_errorcode := 110;
1101: RAISE FND_API.G_EXC_ERROR;

Line 1098: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_subinventory);

1094: IF substr(P_mask,1,1)='I' and L_current_status = 3 then
1095: IF L_current_subinventory <> P_subinventory then
1096: FND_MESSAGE.set_name('INV','INV_SER_SUB_INVALID');
1097: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1098: FND_MESSAGE.SET_TOKEN('TOKEN2',L_current_subinventory);
1099: FND_MSG_PUB.Add;
1100: x_errorcode := 110;
1101: RAISE FND_API.G_EXC_ERROR;
1102: ELSIF L_current_locator_id <> P_locator_id then

Line 1103: FND_MESSAGE.set_name('INV','INV_SER_LOC_INVALID');

1099: FND_MSG_PUB.Add;
1100: x_errorcode := 110;
1101: RAISE FND_API.G_EXC_ERROR;
1102: ELSIF L_current_locator_id <> P_locator_id then
1103: FND_MESSAGE.set_name('INV','INV_SER_LOC_INVALID');
1104: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1105: FND_MSG_PUB.Add;
1106: x_errorcode := 111;
1107: RAISE FND_API.G_EXC_ERROR;

Line 1104: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);

1100: x_errorcode := 110;
1101: RAISE FND_API.G_EXC_ERROR;
1102: ELSIF L_current_locator_id <> P_locator_id then
1103: FND_MESSAGE.set_name('INV','INV_SER_LOC_INVALID');
1104: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
1105: FND_MSG_PUB.Add;
1106: x_errorcode := 111;
1107: RAISE FND_API.G_EXC_ERROR;
1108: END IF;

Line 1118: FND_MESSAGE.set_name('INV','INV_SER_NOTEXIST');

1114: mdebug('Exception :whennodatafound dynamic '||to_char(nvl(P_dynamic_ok,0)));
1115: END IF;
1116:
1117: IF nvl(P_dynamic_ok,0)= 0 then
1118: FND_MESSAGE.set_name('INV','INV_SER_NOTEXIST');
1119: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1120: FND_MSG_PUB.Add;
1121: x_errorcode := 118;
1122: RAISE FND_API.G_EXC_ERROR;

Line 1119: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);

1115: END IF;
1116:
1117: IF nvl(P_dynamic_ok,0)= 0 then
1118: FND_MESSAGE.set_name('INV','INV_SER_NOTEXIST');
1119: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1120: FND_MSG_PUB.Add;
1121: x_errorcode := 118;
1122: RAISE FND_API.G_EXC_ERROR;
1123: ELSE

Line 1134: FND_MESSAGE.set_name('INV','INV_SER_STATUS_NA');

1130: (( P_txn_action_id = 31 and L_current_status <> 1) OR
1131: ( P_txn_action_id = 32 ) OR
1132: ( P_txn_action_id = 27 ) ) AND
1133: L_wip_entity_id is NULL then
1134: FND_MESSAGE.set_name('INV','INV_SER_STATUS_NA');
1135: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1136: FND_MSG_PUB.Add;
1137: x_errorcode := 106;
1138: raise FND_API.G_EXC_ERROR;

Line 1135: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);

1131: ( P_txn_action_id = 32 ) OR
1132: ( P_txn_action_id = 27 ) ) AND
1133: L_wip_entity_id is NULL then
1134: FND_MESSAGE.set_name('INV','INV_SER_STATUS_NA');
1135: FND_MESSAGE.SET_TOKEN('TOKEN',P_serial_number);
1136: FND_MSG_PUB.Add;
1137: x_errorcode := 106;
1138: raise FND_API.G_EXC_ERROR;
1139: END IF;

Line 1268: FND_MESSAGE.SET_NAME('INV', 'INV_QTYBTWN_NO_SERIAL');

1264: END IF;
1265:
1266: --
1267: IF L_from_length = 0 then
1268: FND_MESSAGE.SET_NAME('INV', 'INV_QTYBTWN_NO_SERIAL');
1269: FND_MSG_PUB.Add;
1270: x_errorcode := 124;
1271: return (FALSE);
1272: END IF;

Line 1320: FND_MESSAGE.set_name('INV','INV_QTYBTWN_PFX');

1316: if (L_f_alp_part <> L_t_alp_part) or
1317: (l_f_alp_part is null and l_t_alp_part is not null) or
1318: (l_f_alp_part is not null and l_t_alp_part is null)
1319: then
1320: FND_MESSAGE.set_name('INV','INV_QTYBTWN_PFX');
1321: FND_MSG_PUB.Add;
1322: x_errorcode := 119;
1323: RETURN(FALSE);
1324:

Line 1332: FND_MESSAGE.set_name('INV','INV_QTYBTWN_LGTH');

1328: | match.
1329: +---------------------------------------------------------------*/
1330: if (L_from_length <> L_to_length) then
1331: -- Message Name : INV_QTYBTWN_LGTH
1332: FND_MESSAGE.set_name('INV','INV_QTYBTWN_LGTH');
1333: FND_MSG_PUB.Add;
1334: x_errorcode := 120;
1335: RETURN(FALSE);
1336: end if;

Line 1346: FND_MESSAGE.set_name('INV','INV_QTYBTWN_LAST');

1342: -- XXX checks only one
1343: if L_f_ser_num <> L_t_ser_num then
1344: if ascii(substr(L_f_ser_num,LENGTH(L_f_ser_num),1)) < 48 and
1345: ascii(substr(L_f_ser_num,LENGTH(L_f_ser_num),1)) > 57 then
1346: FND_MESSAGE.set_name('INV','INV_QTYBTWN_LAST');
1347: FND_MSG_PUB.Add;
1348: x_errorcode := 121;
1349: RETURN (FALSE);
1350: end if;

Line 1366: FND_MESSAGE.set_name('INV','INV_QTYBTWN_NUM');

1362: nvl(to_number(L_t_num_part),0) - nvl(to_number(L_f_num_part),0) + 1;
1363:
1364: if (X_Quantity <= 0) then
1365: -- Message Name : INV_QTYBTWN_NUM
1366: FND_MESSAGE.set_name('INV','INV_QTYBTWN_NUM');
1367: FND_MSG_PUB.Add;
1368: x_errorcode := 122;
1369: RETURN (FALSE);
1370: end if;