APPS.INV_VALIDATE dependencies on FND_MSG_PUB

Line 181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

177: EXCEPTION
178:
179: WHEN NO_DATA_FOUND THEN
180:
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
182: THEN
183:
184: FND_MESSAGE.SET_NAME('INV','INV_INT_USERCODE');
185: FND_MSG_PUB.Add;

Line 185: FND_MSG_PUB.Add;

181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
182: THEN
183:
184: FND_MESSAGE.SET_NAME('INV','INV_INT_USERCODE');
185: FND_MSG_PUB.Add;
186:
187: END IF;
188:
189: RETURN F;

Line 194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

190:
191:
192: WHEN OTHERS THEN
193:
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
195: THEN
196: if (p_is_creation = T)
197: then
198: FND_MSG_PUB.Add_Exc_Msg

Line 198: FND_MSG_PUB.Add_Exc_Msg

194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
195: THEN
196: if (p_is_creation = T)
197: then
198: FND_MSG_PUB.Add_Exc_Msg
199: ( G_PKG_NAME
200: , 'Created_By'
201: );
202: else

Line 203: FND_MSG_PUB.Add_Exc_Msg

199: ( G_PKG_NAME
200: , 'Created_By'
201: );
202: else
203: FND_MSG_PUB.Add_Exc_Msg
204: ( G_PKG_NAME
205: , 'Last_Updated_By'
206: );
207: END IF;

Line 237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

233: begin
234: IF p_date IS NULL OR
235: p_date = FND_API.G_MISS_DATE
236: THEN
237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
238: THEN
239: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV',p_msg),FALSE);
241: FND_MSG_PUB.Add;

Line 241: FND_MSG_PUB.Add;

237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
238: THEN
239: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV',p_msg),FALSE);
241: FND_MSG_PUB.Add;
242: END IF;
243: RETURN F;
244: END IF;
245: return T;

Line 396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

392: EXCEPTION
393: WHEN NO_DATA_FOUND THEN
394: RAISE NO_DATA_FOUND;
395: WHEN TOO_MANY_ROWS THEN
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
397: THEN
398: FND_MESSAGE.SET_NAME('INV','HR_51340_EMP_EMP_NUM_REQ');
399: FND_MSG_PUB.Add;
400: END IF;

Line 399: FND_MSG_PUB.Add;

395: WHEN TOO_MANY_ROWS THEN
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
397: THEN
398: FND_MESSAGE.SET_NAME('INV','HR_51340_EMP_EMP_NUM_REQ');
399: FND_MSG_PUB.Add;
400: END IF;
401: RETURN F;
402: END;
403: END IF;

Line 411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

407: EXCEPTION
408:
409: WHEN NO_DATA_FOUND THEN
410:
411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
412: THEN
413: FND_MESSAGE.SET_NAME('INV','HR_7676_BOOKING_FLAG_CHANGE');
414: FND_MSG_PUB.Add;
415: END IF;

Line 414: FND_MSG_PUB.Add;

410:
411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
412: THEN
413: FND_MESSAGE.SET_NAME('INV','HR_7676_BOOKING_FLAG_CHANGE');
414: FND_MSG_PUB.Add;
415: END IF;
416:
417: RETURN F;
418:

Line 421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

417: RETURN F;
418:
419: WHEN OTHERS THEN
420:
421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
422: THEN
423: FND_MSG_PUB.Add_Exc_Msg
424: ( G_PKG_NAME
425: , 'Employee'

Line 423: FND_MSG_PUB.Add_Exc_Msg

419: WHEN OTHERS THEN
420:
421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
422: THEN
423: FND_MSG_PUB.Add_Exc_Msg
424: ( G_PKG_NAME
425: , 'Employee'
426: );
427: END IF;

Line 537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

533: EXCEPTION
534:
535: WHEN NO_DATA_FOUND THEN
536:
537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
538: THEN
539: FND_MESSAGE.SET_NAME('INV','INV_INT_SUBCODE');
540: FND_MSG_PUB.Add;
541: END IF;

Line 540: FND_MSG_PUB.Add;

536:
537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
538: THEN
539: FND_MESSAGE.SET_NAME('INV','INV_INT_SUBCODE');
540: FND_MSG_PUB.Add;
541: END IF;
542:
543: RETURN F;
544:

Line 547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

543: RETURN F;
544:
545: WHEN OTHERS THEN
546:
547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME
551: , 'From_Subinventory'

Line 549: FND_MSG_PUB.Add_Exc_Msg

545: WHEN OTHERS THEN
546:
547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME
551: , 'From_Subinventory'
552: );
553: END IF;

Line 670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

666: EXCEPTION
667:
668: WHEN NO_DATA_FOUND THEN
669:
670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
671: THEN
672:
673: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');

Line 675: FND_MSG_PUB.Add;

671: THEN
672:
673: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');
675: FND_MSG_PUB.Add;
676:
677: END IF;
678:
679: RETURN F;

Line 683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

679: RETURN F;
680:
681: WHEN OTHERS THEN
682:
683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
684: THEN
685: FND_MSG_PUB.Add_Exc_Msg
686: ( G_PKG_NAME
687: , 'Last_Update_Login'

Line 685: FND_MSG_PUB.Add_Exc_Msg

681: WHEN OTHERS THEN
682:
683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
684: THEN
685: FND_MSG_PUB.Add_Exc_Msg
686: ( G_PKG_NAME
687: , 'Last_Update_Login'
688: );
689: END IF;

Line 729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

725: EXCEPTION
726:
727: WHEN NO_DATA_FOUND THEN
728:
729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
730: THEN
731:
732: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');
733: FND_MSG_PUB.Add;

Line 733: FND_MSG_PUB.Add;

729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
730: THEN
731:
732: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');
733: FND_MSG_PUB.Add;
734:
735: END IF;
736:
737: RETURN F;

Line 741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

737: RETURN F;
738:
739: WHEN OTHERS THEN
740:
741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
742: THEN
743: FND_MSG_PUB.Add_Exc_Msg
744: ( G_PKG_NAME
745: , 'Organization'

Line 743: FND_MSG_PUB.Add_Exc_Msg

739: WHEN OTHERS THEN
740:
741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
742: THEN
743: FND_MSG_PUB.Add_Exc_Msg
744: ( G_PKG_NAME
745: , 'Organization'
746: );
747: END IF;

Line 811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

807: EXCEPTION
808:
809: WHEN NO_DATA_FOUND THEN
810:
811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
812: THEN
813:
814: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','ACCOUNT'),FALSE);

Line 816: FND_MSG_PUB.Add;

812: THEN
813:
814: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','ACCOUNT'),FALSE);
816: FND_MSG_PUB.Add;
817:
818: END IF;
819:
820: RETURN F;

Line 824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

820: RETURN F;
821:
822: WHEN OTHERS THEN
823:
824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg
827: ( G_PKG_NAME
828: , 'To_Account'

Line 826: FND_MSG_PUB.Add_Exc_Msg

822: WHEN OTHERS THEN
823:
824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg
827: ( G_PKG_NAME
828: , 'To_Account'
829: );
830: END IF;

Line 900: FND_MSG_PUB.Add;

896: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
897: EXCEPTION
898: WHEN NO_DATA_FOUND THEN
899: FND_MESSAGE.SET_NAME('INV','INV_EXP_ACCT_REQ');
900: FND_MSG_PUB.Add;
901: return F;
902: END;
903: end if;
904: else

Line 932: FND_MSG_PUB.Add;

928: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
929: EXCEPTION
930: WHEN NO_DATA_FOUND THEN
931: FND_MESSAGE.SET_NAME('INV','INV_EXP_ACCT_REQ');
932: FND_MSG_PUB.Add;
933: return F;
934: END;
935: end if;
936: else

Line 956: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

952: RETURN T;
953:
954: EXCEPTION
955: WHEN NO_DATA_FOUND THEN
956: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
957: FND_MESSAGE.SET_NAME('INV','INV_INT_XSUBCODE');
958: FND_MSG_PUB.Add;
959: END IF;
960: RETURN F;

Line 958: FND_MSG_PUB.Add;

954: EXCEPTION
955: WHEN NO_DATA_FOUND THEN
956: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
957: FND_MESSAGE.SET_NAME('INV','INV_INT_XSUBCODE');
958: FND_MSG_PUB.Add;
959: END IF;
960: RETURN F;
961:
962: WHEN OTHERS THEN

Line 963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

959: END IF;
960: RETURN F;
961:
962: WHEN OTHERS THEN
963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: ( G_PKG_NAME
966: , 'To_Subinventory'
967: );

Line 964: FND_MSG_PUB.Add_Exc_Msg

960: RETURN F;
961:
962: WHEN OTHERS THEN
963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: ( G_PKG_NAME
966: , 'To_Subinventory'
967: );
968: END IF;

Line 1054: FND_MSG_PUB.Add;

1050: IF p_transaction_type_id IS NULL OR
1051: p_transaction_type_id = FND_API.G_MISS_NUM
1052: THEN
1053: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1054: FND_MSG_PUB.Add;
1055: RETURN F;
1056: END IF;
1057:
1058: SELECT transaction_action_id,transaction_source_type_id

Line 1070: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1066: EXCEPTION
1067:
1068: WHEN NO_DATA_FOUND THEN
1069:
1070: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1071: THEN
1072:
1073: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1074:

Line 1076: FND_MSG_PUB.Add;

1072:
1073: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1074:
1075: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','TRANSACTION'),FALSE);
1076: FND_MSG_PUB.Add;
1077:
1078: END IF;
1079:
1080: RETURN F;

Line 1084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1080: RETURN F;
1081:
1082: WHEN OTHERS THEN
1083:
1084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1085: THEN
1086: FND_MSG_PUB.Add_Exc_Msg
1087: ( G_PKG_NAME
1088: , 'Transaction_Type'

Line 1086: FND_MSG_PUB.Add_Exc_Msg

1082: WHEN OTHERS THEN
1083:
1084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1085: THEN
1086: FND_MSG_PUB.Add_Exc_Msg
1087: ( G_PKG_NAME
1088: , 'Transaction_Type'
1089: );
1090: END IF;

Line 1116: FND_MSG_PUB.Add;

1112: IF x_transaction.transaction_type_id IS NULL OR
1113: x_transaction.transaction_type_id = FND_API.G_MISS_NUM
1114: THEN
1115: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1116: FND_MSG_PUB.Add;
1117: RETURN F;
1118: END IF;
1119:
1120: SELECT *

Line 1132: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1128: EXCEPTION
1129:
1130: WHEN NO_DATA_FOUND THEN
1131:
1132: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1133: THEN
1134:
1135: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1136:

Line 1138: FND_MSG_PUB.Add;

1134:
1135: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1136:
1137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','TRANSACTION'),FALSE);
1138: FND_MSG_PUB.Add;
1139:
1140: END IF;
1141:
1142: RETURN F;

Line 1146: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1142: RETURN F;
1143:
1144: WHEN OTHERS THEN
1145:
1146: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1147: THEN
1148: FND_MSG_PUB.Add_Exc_Msg
1149: ( G_PKG_NAME
1150: , 'Transaction_Type'

Line 1148: FND_MSG_PUB.Add_Exc_Msg

1144: WHEN OTHERS THEN
1145:
1146: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1147: THEN
1148: FND_MSG_PUB.Add_Exc_Msg
1149: ( G_PKG_NAME
1150: , 'Transaction_Type'
1151: );
1152: END IF;

Line 1248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1244: if v_locator_control = 3 and p_dynamic_ok THEN
1245: l_number := validateLocator(p_locator,p_org,p_sub,EXISTS_OR_CREATE);
1246: RETURN l_number;
1247: end if;
1248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1249: THEN
1250:
1251: FND_MESSAGE.SET_NAME('INV','INV_INT_LOCCODE');
1252: FND_MSG_PUB.Add;

Line 1252: FND_MSG_PUB.Add;

1248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1249: THEN
1250:
1251: FND_MESSAGE.SET_NAME('INV','INV_INT_LOCCODE');
1252: FND_MSG_PUB.Add;
1253:
1254: END IF;
1255:
1256: RETURN F;

Line 1260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1256: RETURN F;
1257:
1258: WHEN OTHERS THEN
1259:
1260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1261: then
1262: if (p_is_from_locator = 1)
1263: then
1264: FND_MSG_PUB.Add_Exc_Msg

Line 1264: FND_MSG_PUB.Add_Exc_Msg

1260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1261: then
1262: if (p_is_from_locator = 1)
1263: then
1264: FND_MSG_PUB.Add_Exc_Msg
1265: ( G_PKG_NAME
1266: , 'From_Locator'
1267: );
1268: else

Line 1269: FND_MSG_PUB.Add_Exc_Msg

1265: ( G_PKG_NAME
1266: , 'From_Locator'
1267: );
1268: else
1269: FND_MSG_PUB.Add_Exc_Msg
1270: ( G_PKG_NAME
1271: , 'To_Locator'
1272: );
1273: end if;

Line 1442: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1438: IF p_item.mtl_transactions_enabled_flag = 'Y'
1439: THEN
1440: RETURN T;
1441: ELSE
1442: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1443: THEN
1444: FND_MESSAGE.SET_NAME('INV','INV_ITEM_TXNS_NOT_ENABLED');
1445: FND_MSG_PUB.Add;
1446: END IF;

Line 1445: FND_MSG_PUB.Add;

1441: ELSE
1442: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1443: THEN
1444: FND_MESSAGE.SET_NAME('INV','INV_ITEM_TXNS_NOT_ENABLED');
1445: FND_MSG_PUB.Add;
1446: END IF;
1447: RETURN F;
1448: END IF;
1449:

Line 1454: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1450: EXCEPTION
1451:
1452: WHEN NO_DATA_FOUND THEN
1453:
1454: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456:
1457: FND_MESSAGE.SET_NAME('INV','INV_INT_ITMCODE');
1458: FND_MSG_PUB.Add;

Line 1458: FND_MSG_PUB.Add;

1454: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456:
1457: FND_MESSAGE.SET_NAME('INV','INV_INT_ITMCODE');
1458: FND_MSG_PUB.Add;
1459:
1460: END IF;
1461:
1462: RETURN F;

Line 1466: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1462: RETURN F;
1463:
1464: WHEN OTHERS THEN
1465:
1466: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1467: THEN
1468: FND_MSG_PUB.Add_Exc_Msg
1469: ( G_PKG_NAME
1470: , 'Inventory_Item'

Line 1468: FND_MSG_PUB.Add_Exc_Msg

1464: WHEN OTHERS THEN
1465:
1466: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1467: THEN
1468: FND_MSG_PUB.Add_Exc_Msg
1469: ( G_PKG_NAME
1470: , 'Inventory_Item'
1471: );
1472: END IF;

Line 1561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1557: ELSIF p_transaction_type=18 THEN
1558: RETURN T;
1559: /* bug9267446 */
1560: ELSE
1561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1562: THEN
1563: FND_MESSAGE.SET_NAME('INV','INV_ITEM_TXNS_NOT_ENABLED');
1564: FND_MSG_PUB.Add;
1565: END IF;

Line 1564: FND_MSG_PUB.Add;

1560: ELSE
1561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1562: THEN
1563: FND_MESSAGE.SET_NAME('INV','INV_ITEM_TXNS_NOT_ENABLED');
1564: FND_MSG_PUB.Add;
1565: END IF;
1566: RETURN F;
1567: END IF;
1568:

Line 1574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1570: EXCEPTION
1571:
1572: WHEN NO_DATA_FOUND THEN
1573:
1574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1575: THEN
1576:
1577: FND_MESSAGE.SET_NAME('INV','INV_INT_ITMCODE');
1578: FND_MSG_PUB.Add;

Line 1578: FND_MSG_PUB.Add;

1574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1575: THEN
1576:
1577: FND_MESSAGE.SET_NAME('INV','INV_INT_ITMCODE');
1578: FND_MSG_PUB.Add;
1579:
1580: END IF;
1581:
1582: RETURN F;

Line 1586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1582: RETURN F;
1583:
1584: WHEN OTHERS THEN
1585:
1586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1587: THEN
1588: FND_MSG_PUB.Add_Exc_Msg
1589: ( G_PKG_NAME
1590: , 'Inventory_Item'

Line 1588: FND_MSG_PUB.Add_Exc_Msg

1584: WHEN OTHERS THEN
1585:
1586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1587: THEN
1588: FND_MSG_PUB.Add_Exc_Msg
1589: ( G_PKG_NAME
1590: , 'Inventory_Item'
1591: );
1592: END IF;

Line 1698: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1694: EXCEPTION
1695:
1696: WHEN no_data_found THEN
1697: --inv_debug.message('no data found');
1698: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1699: fnd_message.set_name('INV','INV_INT_LOCCODE');
1700: fnd_msg_pub.Add;
1701: END IF;
1702:

Line 1700: fnd_msg_pub.Add;

1696: WHEN no_data_found THEN
1697: --inv_debug.message('no data found');
1698: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1699: fnd_message.set_name('INV','INV_INT_LOCCODE');
1700: fnd_msg_pub.Add;
1701: END IF;
1702:
1703: RETURN F;
1704:

Line 1707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1703: RETURN F;
1704:
1705: WHEN OTHERS THEN
1706:
1707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub');
1710: END IF;
1711: -- RETURN f;

Line 1709: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub');

1705: WHEN OTHERS THEN
1706:
1707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub');
1710: END IF;
1711: -- RETURN f;
1712: RAISE fnd_api.g_exc_unexpected_error;
1713:

Line 1754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1750: EXCEPTION
1751:
1752: WHEN no_data_found THEN
1753:
1754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1755: fnd_message.set_name('INV','INV_CCEOI_LOC_NOT_IN_LIST');
1756: fnd_msg_pub.Add;
1757: END IF;
1758:

Line 1756: fnd_msg_pub.Add;

1752: WHEN no_data_found THEN
1753:
1754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1755: fnd_message.set_name('INV','INV_CCEOI_LOC_NOT_IN_LIST');
1756: fnd_msg_pub.Add;
1757: END IF;
1758:
1759: RETURN F;
1760:

Line 1763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1759: RETURN F;
1760:
1761: WHEN OTHERS THEN
1762:
1763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1764: THEN
1765: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub,item');
1766: END IF;
1767:

Line 1765: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub,item');

1761: WHEN OTHERS THEN
1762:
1763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1764: THEN
1765: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub,item');
1766: END IF;
1767:
1768: RAISE fnd_api.g_exc_unexpected_error;
1769:

Line 1860: FND_MSG_PUB.Add;

1856: END IF;
1857:
1858: IF p_item.lot_control_code = 1 THEN
1859: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
1860: FND_MSG_PUB.Add;
1861: RETURN F;
1862: END IF;
1863:
1864: SELECT mln.*

Line 1887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1883: EXCEPTION
1884:
1885: WHEN NO_DATA_FOUND THEN
1886:
1887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1888: THEN
1889:
1890: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);

Line 1892: FND_MSG_PUB.Add;

1888: THEN
1889:
1890: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);
1892: FND_MSG_PUB.Add;
1893:
1894: END IF;
1895: RETURN F;
1896:

Line 1899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1895: RETURN F;
1896:
1897: WHEN OTHERS THEN
1898:
1899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1900: THEN
1901: FND_MSG_PUB.Add_Exc_Msg
1902: ( G_PKG_NAME
1903: , 'Lot_Number'

Line 1901: FND_MSG_PUB.Add_Exc_Msg

1897: WHEN OTHERS THEN
1898:
1899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1900: THEN
1901: FND_MSG_PUB.Add_Exc_Msg
1902: ( G_PKG_NAME
1903: , 'Lot_Number'
1904: );
1905: END IF;

Line 2009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2005: EXCEPTION
2006:
2007: WHEN NO_DATA_FOUND THEN
2008:
2009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2010: THEN
2011:
2012: FND_MESSAGE.SET_NAME('INV','INV_PRJ_ERR');
2013: FND_MSG_PUB.Add;

Line 2013: FND_MSG_PUB.Add;

2009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2010: THEN
2011:
2012: FND_MESSAGE.SET_NAME('INV','INV_PRJ_ERR');
2013: FND_MSG_PUB.Add;
2014:
2015: END IF;
2016:
2017: RETURN F;

Line 2021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2017: RETURN F;
2018:
2019: WHEN OTHERS THEN
2020:
2021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2022: THEN
2023: FND_MSG_PUB.Add_Exc_Msg
2024: ( G_PKG_NAME
2025: , 'Project'

Line 2023: FND_MSG_PUB.Add_Exc_Msg

2019: WHEN OTHERS THEN
2020:
2021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2022: THEN
2023: FND_MSG_PUB.Add_Exc_Msg
2024: ( G_PKG_NAME
2025: , 'Project'
2026: );
2027: END IF;

Line 2043: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2039: BEGIN
2040: IF p_quantity IS NULL OR
2041: p_quantity = FND_API.G_MISS_NUM
2042: THEN
2043: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2044: THEN
2045: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
2046: FND_MSG_PUB.Add;
2047: END IF;

Line 2046: FND_MSG_PUB.Add;

2042: THEN
2043: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2044: THEN
2045: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
2046: FND_MSG_PUB.Add;
2047: END IF;
2048: return F;
2049: END IF;
2050: RETURN T;

Line 2080: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2076: EXCEPTION
2077:
2078: WHEN NO_DATA_FOUND THEN
2079:
2080: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2081: THEN
2082:
2083: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
2084: FND_MSG_PUB.Add;

Line 2084: FND_MSG_PUB.Add;

2080: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2081: THEN
2082:
2083: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
2084: FND_MSG_PUB.Add;
2085:
2086: END IF;
2087:
2088: RETURN F;

Line 2092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2088: RETURN F;
2089:
2090: WHEN OTHERS THEN
2091:
2092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2093: THEN
2094: FND_MSG_PUB.Add_Exc_Msg
2095: ( G_PKG_NAME
2096: , 'Reason'

Line 2094: FND_MSG_PUB.Add_Exc_Msg

2090: WHEN OTHERS THEN
2091:
2092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2093: THEN
2094: FND_MSG_PUB.Add_Exc_Msg
2095: ( G_PKG_NAME
2096: , 'Reason'
2097: );
2098: END IF;

Line 2147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2143: EXCEPTION
2144:
2145: WHEN NO_DATA_FOUND THEN
2146:
2147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2148: THEN
2149:
2150: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_ID'),FALSE); -- ND

Line 2152: FND_MSG_PUB.Add;

2148: THEN
2149:
2150: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_ID'),FALSE); -- ND
2152: FND_MSG_PUB.Add;
2153:
2154: END IF;
2155:
2156: RETURN F;

Line 2160: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2156: RETURN F;
2157:
2158: WHEN OTHERS THEN
2159:
2160: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2161: THEN
2162: FND_MSG_PUB.Add_Exc_Msg
2163: ( G_PKG_NAME
2164: , 'Reference'

Line 2162: FND_MSG_PUB.Add_Exc_Msg

2158: WHEN OTHERS THEN
2159:
2160: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2161: THEN
2162: FND_MSG_PUB.Add_Exc_Msg
2163: ( G_PKG_NAME
2164: , 'Reference'
2165: );
2166: END IF;

Line 2199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2195: EXCEPTION
2196:
2197: WHEN NO_DATA_FOUND THEN
2198:
2199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2200: THEN
2201:
2202: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_TYPE'),FALSE); -- ND;

Line 2204: FND_MSG_PUB.Add;

2200: THEN
2201:
2202: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_TYPE'),FALSE); -- ND;
2204: FND_MSG_PUB.Add;
2205:
2206: END IF;
2207:
2208: RETURN F;

Line 2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2208: RETURN F;
2209:
2210: WHEN OTHERS THEN
2211:
2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg
2215: ( G_PKG_NAME
2216: , 'Reference_Type'

Line 2214: FND_MSG_PUB.Add_Exc_Msg

2210: WHEN OTHERS THEN
2211:
2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg
2215: ( G_PKG_NAME
2216: , 'Reference_Type'
2217: );
2218: END IF;

Line 2240: FND_MSG_PUB.Add;

2236: END IF;
2237:
2238: IF p_item.revision_qty_control_code = 1 THEN
2239: FND_MESSAGE.SET_NAME('INV','INV_NO_REVISION_CONTROL'); -- ND
2240: FND_MSG_PUB.Add;
2241: RETURN F;
2242: END IF;
2243:
2244: SELECT 'VALID'

Line 2257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2253: EXCEPTION
2254:
2255: WHEN NO_DATA_FOUND THEN
2256:
2257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2258: THEN
2259:
2260: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
2261: FND_MSG_PUB.Add;

Line 2261: FND_MSG_PUB.Add;

2257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2258: THEN
2259:
2260: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
2261: FND_MSG_PUB.Add;
2262:
2263: END IF;
2264: RETURN F;
2265:

Line 2268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2264: RETURN F;
2265:
2266: WHEN OTHERS THEN
2267:
2268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2269: THEN
2270: FND_MSG_PUB.Add_Exc_Msg
2271:
2272: ( G_PKG_NAME

Line 2270: FND_MSG_PUB.Add_Exc_Msg

2266: WHEN OTHERS THEN
2267:
2268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2269: THEN
2270: FND_MSG_PUB.Add_Exc_Msg
2271:
2272: ( G_PKG_NAME
2273: , 'Revision'
2274: );

Line 2311: FND_MSG_PUB.Add;

2307: , p_item.inventory_item_id
2308: , p_txn_type_id) = 1
2309: THEN
2310: FND_MESSAGE.SET_NAME('INV','INV_ITEM_NOT_SERIAL_CONTROLLED');
2311: FND_MSG_PUB.Add;
2312: RETURN F;
2313: END IF;
2314:
2315: IF p_item.serial_number_control_code = 2 THEN

Line 2363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2359: EXCEPTION
2360:
2361: WHEN NO_DATA_FOUND THEN
2362:
2363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2364: THEN
2365:
2366: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2367: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV',p_msg),FALSE); -- ND

Line 2369: FND_MSG_PUB.Add;

2365:
2366: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2367: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV',p_msg),FALSE); -- ND
2368:
2369: FND_MSG_PUB.Add;
2370:
2371: END IF;
2372:
2373: RETURN F;

Line 2377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2373: RETURN F;
2374:
2375: WHEN OTHERS THEN
2376:
2377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2378: THEN
2379: FND_MSG_PUB.Add_Exc_Msg
2380: ( G_PKG_NAME
2381: , 'Check_serial_number'

Line 2379: FND_MSG_PUB.Add_Exc_Msg

2375: WHEN OTHERS THEN
2376:
2377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2378: THEN
2379: FND_MSG_PUB.Add_Exc_Msg
2380: ( G_PKG_NAME
2381: , 'Check_serial_number'
2382: );
2383: END IF;

Line 2757: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

2753: EXCEPTION
2754:
2755: WHEN no_data_found THEN
2756:
2757: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2758: THEN
2759: fnd_message.set_name('INV','INV_INVALID_SUBINV');
2760: fnd_msg_pub.ADD;
2761: END IF;

Line 2760: fnd_msg_pub.ADD;

2756:
2757: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2758: THEN
2759: fnd_message.set_name('INV','INV_INVALID_SUBINV');
2760: fnd_msg_pub.ADD;
2761: END IF;
2762:
2763: RETURN F;
2764:

Line 2767: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2763: RETURN F;
2764:
2765: WHEN OTHERS THEN
2766:
2767: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2768: THEN
2769: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2770: END IF;
2771:

Line 2769: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');

2765: WHEN OTHERS THEN
2766:
2767: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2768: THEN
2769: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2770: END IF;
2771:
2772: RAISE fnd_api.g_exc_unexpected_error;
2773:

Line 2808: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

2804: EXCEPTION
2805:
2806: WHEN no_data_found THEN
2807:
2808: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2809: THEN
2810: fnd_message.set_name('INV','INV_INT_RESSUBEXP');
2811: fnd_msg_pub.ADD;
2812: END IF;

Line 2811: fnd_msg_pub.ADD;

2807:
2808: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2809: THEN
2810: fnd_message.set_name('INV','INV_INT_RESSUBEXP');
2811: fnd_msg_pub.ADD;
2812: END IF;
2813:
2814: RETURN F;
2815:

Line 2818: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2814: RETURN F;
2815:
2816: WHEN OTHERS THEN
2817:
2818: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2819: THEN
2820: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2821: END IF;
2822:

Line 2820: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');

2816: WHEN OTHERS THEN
2817:
2818: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2819: THEN
2820: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2821: END IF;
2822:
2823: RAISE fnd_api.g_exc_unexpected_error;
2824:

Line 2855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2851: EXCEPTION
2852:
2853: WHEN NO_DATA_FOUND THEN
2854:
2855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2856: THEN
2857:
2858: FND_MESSAGE.SET_NAME('INV','INV_TASK_ERR');
2859: FND_MSG_PUB.Add;

Line 2859: FND_MSG_PUB.Add;

2855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2856: THEN
2857:
2858: FND_MESSAGE.SET_NAME('INV','INV_TASK_ERR');
2859: FND_MSG_PUB.Add;
2860:
2861: END IF;
2862:
2863: RETURN F;

Line 2867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2863: RETURN F;
2864:
2865: WHEN OTHERS THEN
2866:
2867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2868: THEN
2869: FND_MSG_PUB.Add_Exc_Msg
2870: ( G_PKG_NAME
2871: , 'Task'

Line 2869: FND_MSG_PUB.Add_Exc_Msg

2865: WHEN OTHERS THEN
2866:
2867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2868: THEN
2869: FND_MSG_PUB.Add_Exc_Msg
2870: ( G_PKG_NAME
2871: , 'Task'
2872: );
2873: END IF;

Line 2950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2946:
2947: EXCEPTION
2948: WHEN NO_DATA_FOUND THEN
2949:
2950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2951: THEN
2952:
2953: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LOCATION');
2954: FND_MSG_PUB.Add;

Line 2954: FND_MSG_PUB.Add;

2950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2951: THEN
2952:
2953: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LOCATION');
2954: FND_MSG_PUB.Add;
2955:
2956: END IF;
2957:
2958: RETURN F;

Line 2962: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2958: RETURN F;
2959:
2960: WHEN OTHERS THEN
2961:
2962: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2963: THEN
2964: FND_MSG_PUB.Add_Exc_Msg
2965: ( G_PKG_NAME
2966: , 'Task'

Line 2964: FND_MSG_PUB.Add_Exc_Msg

2960: WHEN OTHERS THEN
2961:
2962: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2963: THEN
2964: FND_MSG_PUB.Add_Exc_Msg
2965: ( G_PKG_NAME
2966: , 'Task'
2967: );
2968: END IF;

Line 3009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3005: EXCEPTION
3006:
3007: WHEN NO_DATA_FOUND THEN
3008:
3009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3010: THEN
3011:
3012: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');
3013: FND_MSG_PUB.Add;

Line 3013: FND_MSG_PUB.Add;

3009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3010: THEN
3011:
3012: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');
3013: FND_MSG_PUB.Add;
3014:
3015: END IF;
3016:
3017: RETURN F;

Line 3021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3017: RETURN F;
3018:
3019: WHEN OTHERS THEN
3020:
3021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3022: THEN
3023: FND_MSG_PUB.Add_Exc_Msg
3024: ( G_PKG_NAME
3025: , 'Uom'

Line 3023: FND_MSG_PUB.Add_Exc_Msg

3019: WHEN OTHERS THEN
3020:
3021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3022: THEN
3023: FND_MSG_PUB.Add_Exc_Msg
3024: ( G_PKG_NAME
3025: , 'Uom'
3026: );
3027: END IF;

Line 3085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3081: where cost_group_id = p_cost_group_id;
3082: return T;
3083: Exception
3084: when no_data_found then
3085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3086: FND_MESSAGE.SET_NAME('INV','INV_CST_GRP');
3087: FND_MSG_PUB.Add;
3088: END IF;
3089: return F;

Line 3087: FND_MSG_PUB.Add;

3083: Exception
3084: when no_data_found then
3085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3086: FND_MESSAGE.SET_NAME('INV','INV_CST_GRP');
3087: FND_MSG_PUB.Add;
3088: END IF;
3089: return F;
3090:
3091: WHEN OTHERS THEN

Line 3092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3088: END IF;
3089: return F;
3090:
3091: WHEN OTHERS THEN
3092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3093: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cost Group');
3094: END IF;
3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3096: return F;

Line 3093: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cost Group');

3089: return F;
3090:
3091: WHEN OTHERS THEN
3092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3093: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cost Group');
3094: END IF;
3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3096: return F;
3097: END;

Line 3112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3108: RETURN t;
3109:
3110: Exception
3111: when no_data_found then
3112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3113: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LPN');
3114: FND_MSG_PUB.Add;
3115: END IF;
3116: return F;

Line 3114: FND_MSG_PUB.Add;

3110: Exception
3111: when no_data_found then
3112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3113: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LPN');
3114: FND_MSG_PUB.Add;
3115: END IF;
3116: return F;
3117:
3118: WHEN OTHERS THEN

Line 3119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3115: END IF;
3116: return F;
3117:
3118: WHEN OTHERS THEN
3119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'LPN');
3121: END IF;
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: return F;

Line 3120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'LPN');

3116: return F;
3117:
3118: WHEN OTHERS THEN
3119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'LPN');
3121: END IF;
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: return F;
3124: END;

Line 3149: FND_MSG_PUB.Add;

3145: END IF;
3146:
3147: IF p_item.lot_control_code = 1 THEN
3148: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
3149: FND_MSG_PUB.Add;
3150: RETURN F;
3151: END IF;
3152:
3153:

Line 3167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3163: EXCEPTION
3164:
3165: WHEN NO_DATA_FOUND THEN
3166:
3167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3168: THEN
3169:
3170: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
3171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);

Line 3172: FND_MSG_PUB.Add;

3168: THEN
3169:
3170: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
3171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);
3172: FND_MSG_PUB.Add;
3173:
3174: END IF;
3175: RETURN F;
3176:

Line 3179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3175: RETURN F;
3176:
3177: WHEN OTHERS THEN
3178:
3179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3180: THEN
3181: FND_MSG_PUB.Add_Exc_Msg
3182: ( G_PKG_NAME
3183: , 'Lot_Number'

Line 3181: FND_MSG_PUB.Add_Exc_Msg

3177: WHEN OTHERS THEN
3178:
3179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3180: THEN
3181: FND_MSG_PUB.Add_Exc_Msg
3182: ( G_PKG_NAME
3183: , 'Lot_Number'
3184: );
3185: END IF;

Line 3200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3196: BEGIN
3197: IF p_secondary_quantity IS NULL OR
3198: p_secondary_quantity = FND_API.G_MISS_NUM
3199: THEN
3200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3202: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
3203: FND_MSG_PUB.Add;
3204: END IF;

Line 3203: FND_MSG_PUB.Add;

3199: THEN
3200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3202: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
3203: FND_MSG_PUB.Add;
3204: END IF;
3205: return F;
3206: END IF;
3207: RETURN T;