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 390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

386: EXCEPTION
387: WHEN NO_DATA_FOUND THEN
388: RAISE NO_DATA_FOUND;
389: WHEN TOO_MANY_ROWS THEN
390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
391: THEN
392: FND_MESSAGE.SET_NAME('INV','HR_51340_EMP_EMP_NUM_REQ');
393: FND_MSG_PUB.Add;
394: END IF;

Line 393: FND_MSG_PUB.Add;

389: WHEN TOO_MANY_ROWS THEN
390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
391: THEN
392: FND_MESSAGE.SET_NAME('INV','HR_51340_EMP_EMP_NUM_REQ');
393: FND_MSG_PUB.Add;
394: END IF;
395: RETURN F;
396: END;
397: END IF;

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

401: EXCEPTION
402:
403: WHEN NO_DATA_FOUND THEN
404:
405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
406: THEN
407: FND_MESSAGE.SET_NAME('INV','HR_7676_BOOKING_FLAG_CHANGE');
408: FND_MSG_PUB.Add;
409: END IF;

Line 408: FND_MSG_PUB.Add;

404:
405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
406: THEN
407: FND_MESSAGE.SET_NAME('INV','HR_7676_BOOKING_FLAG_CHANGE');
408: FND_MSG_PUB.Add;
409: END IF;
410:
411: RETURN F;
412:

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

411: RETURN F;
412:
413: WHEN OTHERS THEN
414:
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
416: THEN
417: FND_MSG_PUB.Add_Exc_Msg
418: ( G_PKG_NAME
419: , 'Employee'

Line 417: FND_MSG_PUB.Add_Exc_Msg

413: WHEN OTHERS THEN
414:
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
416: THEN
417: FND_MSG_PUB.Add_Exc_Msg
418: ( G_PKG_NAME
419: , 'Employee'
420: );
421: END IF;

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

527: EXCEPTION
528:
529: WHEN NO_DATA_FOUND THEN
530:
531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
532: THEN
533: FND_MESSAGE.SET_NAME('INV','INV_INT_SUBCODE');
534: FND_MSG_PUB.Add;
535: END IF;

Line 534: FND_MSG_PUB.Add;

530:
531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
532: THEN
533: FND_MESSAGE.SET_NAME('INV','INV_INT_SUBCODE');
534: FND_MSG_PUB.Add;
535: END IF;
536:
537: RETURN F;
538:

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

537: RETURN F;
538:
539: WHEN OTHERS THEN
540:
541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
542: THEN
543: FND_MSG_PUB.Add_Exc_Msg
544: ( G_PKG_NAME
545: , 'From_Subinventory'

Line 543: FND_MSG_PUB.Add_Exc_Msg

539: WHEN OTHERS THEN
540:
541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
542: THEN
543: FND_MSG_PUB.Add_Exc_Msg
544: ( G_PKG_NAME
545: , 'From_Subinventory'
546: );
547: END IF;

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

660: EXCEPTION
661:
662: WHEN NO_DATA_FOUND THEN
663:
664: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
665: THEN
666:
667: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
668: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');

Line 669: FND_MSG_PUB.Add;

665: THEN
666:
667: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
668: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');
669: FND_MSG_PUB.Add;
670:
671: END IF;
672:
673: RETURN F;

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

673: RETURN F;
674:
675: WHEN OTHERS THEN
676:
677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
678: THEN
679: FND_MSG_PUB.Add_Exc_Msg
680: ( G_PKG_NAME
681: , 'Last_Update_Login'

Line 679: FND_MSG_PUB.Add_Exc_Msg

675: WHEN OTHERS THEN
676:
677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
678: THEN
679: FND_MSG_PUB.Add_Exc_Msg
680: ( G_PKG_NAME
681: , 'Last_Update_Login'
682: );
683: END IF;

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

719: EXCEPTION
720:
721: WHEN NO_DATA_FOUND THEN
722:
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
724: THEN
725:
726: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');
727: FND_MSG_PUB.Add;

Line 727: FND_MSG_PUB.Add;

723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
724: THEN
725:
726: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');
727: FND_MSG_PUB.Add;
728:
729: END IF;
730:
731: RETURN F;

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

731: RETURN F;
732:
733: WHEN OTHERS THEN
734:
735: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
736: THEN
737: FND_MSG_PUB.Add_Exc_Msg
738: ( G_PKG_NAME
739: , 'Organization'

Line 737: FND_MSG_PUB.Add_Exc_Msg

733: WHEN OTHERS THEN
734:
735: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
736: THEN
737: FND_MSG_PUB.Add_Exc_Msg
738: ( G_PKG_NAME
739: , 'Organization'
740: );
741: END IF;

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

801: EXCEPTION
802:
803: WHEN NO_DATA_FOUND THEN
804:
805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
806: THEN
807:
808: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','ACCOUNT'),FALSE);

Line 810: FND_MSG_PUB.Add;

806: THEN
807:
808: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','ACCOUNT'),FALSE);
810: FND_MSG_PUB.Add;
811:
812: END IF;
813:
814: RETURN F;

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

814: RETURN F;
815:
816: WHEN OTHERS THEN
817:
818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg
821: ( G_PKG_NAME
822: , 'To_Account'

Line 820: FND_MSG_PUB.Add_Exc_Msg

816: WHEN OTHERS THEN
817:
818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg
821: ( G_PKG_NAME
822: , 'To_Account'
823: );
824: END IF;

Line 894: FND_MSG_PUB.Add;

890: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
891: EXCEPTION
892: WHEN NO_DATA_FOUND THEN
893: FND_MESSAGE.SET_NAME('INV','INV_EXP_ACCT_REQ');
894: FND_MSG_PUB.Add;
895: return F;
896: END;
897: end if;
898: else

Line 926: FND_MSG_PUB.Add;

922: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN
925: FND_MESSAGE.SET_NAME('INV','INV_EXP_ACCT_REQ');
926: FND_MSG_PUB.Add;
927: return F;
928: END;
929: end if;
930: else

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

946: RETURN T;
947:
948: EXCEPTION
949: WHEN NO_DATA_FOUND THEN
950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
951: FND_MESSAGE.SET_NAME('INV','INV_INT_XSUBCODE');
952: FND_MSG_PUB.Add;
953: END IF;
954: RETURN F;

Line 952: FND_MSG_PUB.Add;

948: EXCEPTION
949: WHEN NO_DATA_FOUND THEN
950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
951: FND_MESSAGE.SET_NAME('INV','INV_INT_XSUBCODE');
952: FND_MSG_PUB.Add;
953: END IF;
954: RETURN F;
955:
956: WHEN OTHERS THEN

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

953: END IF;
954: RETURN F;
955:
956: WHEN OTHERS THEN
957: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
958: FND_MSG_PUB.Add_Exc_Msg
959: ( G_PKG_NAME
960: , 'To_Subinventory'
961: );

Line 958: FND_MSG_PUB.Add_Exc_Msg

954: RETURN F;
955:
956: WHEN OTHERS THEN
957: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
958: FND_MSG_PUB.Add_Exc_Msg
959: ( G_PKG_NAME
960: , 'To_Subinventory'
961: );
962: END IF;

Line 1048: FND_MSG_PUB.Add;

1044: IF p_transaction_type_id IS NULL OR
1045: p_transaction_type_id = FND_API.G_MISS_NUM
1046: THEN
1047: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1048: FND_MSG_PUB.Add;
1049: RETURN F;
1050: END IF;
1051:
1052: SELECT transaction_action_id,transaction_source_type_id

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

1060: EXCEPTION
1061:
1062: WHEN NO_DATA_FOUND THEN
1063:
1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1065: THEN
1066:
1067: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1068:

Line 1070: FND_MSG_PUB.Add;

1066:
1067: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1068:
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','TRANSACTION'),FALSE);
1070: FND_MSG_PUB.Add;
1071:
1072: END IF;
1073:
1074: RETURN F;

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

1074: RETURN F;
1075:
1076: WHEN OTHERS THEN
1077:
1078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1079: THEN
1080: FND_MSG_PUB.Add_Exc_Msg
1081: ( G_PKG_NAME
1082: , 'Transaction_Type'

Line 1080: FND_MSG_PUB.Add_Exc_Msg

1076: WHEN OTHERS THEN
1077:
1078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1079: THEN
1080: FND_MSG_PUB.Add_Exc_Msg
1081: ( G_PKG_NAME
1082: , 'Transaction_Type'
1083: );
1084: END IF;

Line 1110: FND_MSG_PUB.Add;

1106: IF x_transaction.transaction_type_id IS NULL OR
1107: x_transaction.transaction_type_id = FND_API.G_MISS_NUM
1108: THEN
1109: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1110: FND_MSG_PUB.Add;
1111: RETURN F;
1112: END IF;
1113:
1114: SELECT *

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

1122: EXCEPTION
1123:
1124: WHEN NO_DATA_FOUND THEN
1125:
1126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1127: THEN
1128:
1129: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1130:

Line 1132: FND_MSG_PUB.Add;

1128:
1129: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1130:
1131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','TRANSACTION'),FALSE);
1132: FND_MSG_PUB.Add;
1133:
1134: END IF;
1135:
1136: RETURN F;

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

1136: RETURN F;
1137:
1138: WHEN OTHERS THEN
1139:
1140: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: FND_MSG_PUB.Add_Exc_Msg
1143: ( G_PKG_NAME
1144: , 'Transaction_Type'

Line 1142: FND_MSG_PUB.Add_Exc_Msg

1138: WHEN OTHERS THEN
1139:
1140: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: FND_MSG_PUB.Add_Exc_Msg
1143: ( G_PKG_NAME
1144: , 'Transaction_Type'
1145: );
1146: END IF;

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

1238: if v_locator_control = 3 and p_dynamic_ok THEN
1239: l_number := validateLocator(p_locator,p_org,p_sub,EXISTS_OR_CREATE);
1240: RETURN l_number;
1241: end if;
1242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1243: THEN
1244:
1245: FND_MESSAGE.SET_NAME('INV','INV_INT_LOCCODE');
1246: FND_MSG_PUB.Add;

Line 1246: FND_MSG_PUB.Add;

1242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1243: THEN
1244:
1245: FND_MESSAGE.SET_NAME('INV','INV_INT_LOCCODE');
1246: FND_MSG_PUB.Add;
1247:
1248: END IF;
1249:
1250: RETURN F;

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

1250: RETURN F;
1251:
1252: WHEN OTHERS THEN
1253:
1254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1255: then
1256: if (p_is_from_locator = 1)
1257: then
1258: FND_MSG_PUB.Add_Exc_Msg

Line 1258: FND_MSG_PUB.Add_Exc_Msg

1254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1255: then
1256: if (p_is_from_locator = 1)
1257: then
1258: FND_MSG_PUB.Add_Exc_Msg
1259: ( G_PKG_NAME
1260: , 'From_Locator'
1261: );
1262: else

Line 1263: FND_MSG_PUB.Add_Exc_Msg

1259: ( G_PKG_NAME
1260: , 'From_Locator'
1261: );
1262: else
1263: FND_MSG_PUB.Add_Exc_Msg
1264: ( G_PKG_NAME
1265: , 'To_Locator'
1266: );
1267: end if;

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

1432: IF p_item.mtl_transactions_enabled_flag = 'Y'
1433: THEN
1434: RETURN T;
1435: ELSE
1436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1437: THEN
1438: FND_MESSAGE.SET_NAME('INV','INV_ITEM_TXNS_NOT_ENABLED');
1439: FND_MSG_PUB.Add;
1440: END IF;

Line 1439: FND_MSG_PUB.Add;

1435: ELSE
1436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1437: THEN
1438: FND_MESSAGE.SET_NAME('INV','INV_ITEM_TXNS_NOT_ENABLED');
1439: FND_MSG_PUB.Add;
1440: END IF;
1441: RETURN F;
1442: END IF;
1443:

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

1444: EXCEPTION
1445:
1446: WHEN NO_DATA_FOUND THEN
1447:
1448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1449: THEN
1450:
1451: FND_MESSAGE.SET_NAME('INV','INV_INT_ITMCODE');
1452: FND_MSG_PUB.Add;

Line 1452: FND_MSG_PUB.Add;

1448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1449: THEN
1450:
1451: FND_MESSAGE.SET_NAME('INV','INV_INT_ITMCODE');
1452: FND_MSG_PUB.Add;
1453:
1454: END IF;
1455:
1456: RETURN F;

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

1456: RETURN F;
1457:
1458: WHEN OTHERS THEN
1459:
1460: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1461: THEN
1462: FND_MSG_PUB.Add_Exc_Msg
1463: ( G_PKG_NAME
1464: , 'Inventory_Item'

Line 1462: FND_MSG_PUB.Add_Exc_Msg

1458: WHEN OTHERS THEN
1459:
1460: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1461: THEN
1462: FND_MSG_PUB.Add_Exc_Msg
1463: ( G_PKG_NAME
1464: , 'Inventory_Item'
1465: );
1466: END IF;

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

1569: EXCEPTION
1570:
1571: WHEN no_data_found THEN
1572: --inv_debug.message('no data found');
1573: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1574: fnd_message.set_name('INV','INV_INT_LOCCODE');
1575: fnd_msg_pub.Add;
1576: END IF;
1577:

Line 1575: fnd_msg_pub.Add;

1571: WHEN no_data_found THEN
1572: --inv_debug.message('no data found');
1573: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1574: fnd_message.set_name('INV','INV_INT_LOCCODE');
1575: fnd_msg_pub.Add;
1576: END IF;
1577:
1578: RETURN F;
1579:

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

1578: RETURN F;
1579:
1580: WHEN OTHERS THEN
1581:
1582: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1583: THEN
1584: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub');
1585: END IF;
1586: -- RETURN f;

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

1580: WHEN OTHERS THEN
1581:
1582: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1583: THEN
1584: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub');
1585: END IF;
1586: -- RETURN f;
1587: RAISE fnd_api.g_exc_unexpected_error;
1588:

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

1625: EXCEPTION
1626:
1627: WHEN no_data_found THEN
1628:
1629: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1630: fnd_message.set_name('INV','INV_CCEOI_LOC_NOT_IN_LIST');
1631: fnd_msg_pub.Add;
1632: END IF;
1633:

Line 1631: fnd_msg_pub.Add;

1627: WHEN no_data_found THEN
1628:
1629: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1630: fnd_message.set_name('INV','INV_CCEOI_LOC_NOT_IN_LIST');
1631: fnd_msg_pub.Add;
1632: END IF;
1633:
1634: RETURN F;
1635:

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

1634: RETURN F;
1635:
1636: WHEN OTHERS THEN
1637:
1638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1639: THEN
1640: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub,item');
1641: END IF;
1642:

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

1636: WHEN OTHERS THEN
1637:
1638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1639: THEN
1640: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub,item');
1641: END IF;
1642:
1643: RAISE fnd_api.g_exc_unexpected_error;
1644:

Line 1735: FND_MSG_PUB.Add;

1731: END IF;
1732:
1733: IF p_item.lot_control_code = 1 THEN
1734: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
1735: FND_MSG_PUB.Add;
1736: RETURN F;
1737: END IF;
1738:
1739: SELECT mln.*

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

1758: EXCEPTION
1759:
1760: WHEN NO_DATA_FOUND THEN
1761:
1762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1763: THEN
1764:
1765: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);

Line 1767: FND_MSG_PUB.Add;

1763: THEN
1764:
1765: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
1766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);
1767: FND_MSG_PUB.Add;
1768:
1769: END IF;
1770: RETURN F;
1771:

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

1770: RETURN F;
1771:
1772: WHEN OTHERS THEN
1773:
1774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1775: THEN
1776: FND_MSG_PUB.Add_Exc_Msg
1777: ( G_PKG_NAME
1778: , 'Lot_Number'

Line 1776: FND_MSG_PUB.Add_Exc_Msg

1772: WHEN OTHERS THEN
1773:
1774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1775: THEN
1776: FND_MSG_PUB.Add_Exc_Msg
1777: ( G_PKG_NAME
1778: , 'Lot_Number'
1779: );
1780: END IF;

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

1878: EXCEPTION
1879:
1880: WHEN NO_DATA_FOUND THEN
1881:
1882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1883: THEN
1884:
1885: FND_MESSAGE.SET_NAME('INV','INV_PRJ_ERR');
1886: FND_MSG_PUB.Add;

Line 1886: FND_MSG_PUB.Add;

1882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1883: THEN
1884:
1885: FND_MESSAGE.SET_NAME('INV','INV_PRJ_ERR');
1886: FND_MSG_PUB.Add;
1887:
1888: END IF;
1889:
1890: RETURN F;

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

1890: RETURN F;
1891:
1892: WHEN OTHERS THEN
1893:
1894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg
1897: ( G_PKG_NAME
1898: , 'Project'

Line 1896: FND_MSG_PUB.Add_Exc_Msg

1892: WHEN OTHERS THEN
1893:
1894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg
1897: ( G_PKG_NAME
1898: , 'Project'
1899: );
1900: END IF;

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

1912: BEGIN
1913: IF p_quantity IS NULL OR
1914: p_quantity = FND_API.G_MISS_NUM
1915: THEN
1916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1917: THEN
1918: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
1919: FND_MSG_PUB.Add;
1920: END IF;

Line 1919: FND_MSG_PUB.Add;

1915: THEN
1916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1917: THEN
1918: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
1919: FND_MSG_PUB.Add;
1920: END IF;
1921: return F;
1922: END IF;
1923: RETURN T;

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

1949: EXCEPTION
1950:
1951: WHEN NO_DATA_FOUND THEN
1952:
1953: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1954: THEN
1955:
1956: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
1957: FND_MSG_PUB.Add;

Line 1957: FND_MSG_PUB.Add;

1953: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1954: THEN
1955:
1956: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
1957: FND_MSG_PUB.Add;
1958:
1959: END IF;
1960:
1961: RETURN F;

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

1961: RETURN F;
1962:
1963: WHEN OTHERS THEN
1964:
1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1966: THEN
1967: FND_MSG_PUB.Add_Exc_Msg
1968: ( G_PKG_NAME
1969: , 'Reason'

Line 1967: FND_MSG_PUB.Add_Exc_Msg

1963: WHEN OTHERS THEN
1964:
1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1966: THEN
1967: FND_MSG_PUB.Add_Exc_Msg
1968: ( G_PKG_NAME
1969: , 'Reason'
1970: );
1971: END IF;

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

2016: EXCEPTION
2017:
2018: WHEN NO_DATA_FOUND THEN
2019:
2020: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2021: THEN
2022:
2023: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2024: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_ID'),FALSE); -- ND

Line 2025: FND_MSG_PUB.Add;

2021: THEN
2022:
2023: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2024: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_ID'),FALSE); -- ND
2025: FND_MSG_PUB.Add;
2026:
2027: END IF;
2028:
2029: RETURN F;

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

2029: RETURN F;
2030:
2031: WHEN OTHERS THEN
2032:
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2034: THEN
2035: FND_MSG_PUB.Add_Exc_Msg
2036: ( G_PKG_NAME
2037: , 'Reference'

Line 2035: FND_MSG_PUB.Add_Exc_Msg

2031: WHEN OTHERS THEN
2032:
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2034: THEN
2035: FND_MSG_PUB.Add_Exc_Msg
2036: ( G_PKG_NAME
2037: , 'Reference'
2038: );
2039: END IF;

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

2068: EXCEPTION
2069:
2070: WHEN NO_DATA_FOUND THEN
2071:
2072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2073: THEN
2074:
2075: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2076: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_TYPE'),FALSE); -- ND;

Line 2077: FND_MSG_PUB.Add;

2073: THEN
2074:
2075: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2076: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_REFERENCE_TYPE'),FALSE); -- ND;
2077: FND_MSG_PUB.Add;
2078:
2079: END IF;
2080:
2081: RETURN F;

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

2081: RETURN F;
2082:
2083: WHEN OTHERS THEN
2084:
2085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2086: THEN
2087: FND_MSG_PUB.Add_Exc_Msg
2088: ( G_PKG_NAME
2089: , 'Reference_Type'

Line 2087: FND_MSG_PUB.Add_Exc_Msg

2083: WHEN OTHERS THEN
2084:
2085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2086: THEN
2087: FND_MSG_PUB.Add_Exc_Msg
2088: ( G_PKG_NAME
2089: , 'Reference_Type'
2090: );
2091: END IF;

Line 2113: FND_MSG_PUB.Add;

2109: END IF;
2110:
2111: IF p_item.revision_qty_control_code = 1 THEN
2112: FND_MESSAGE.SET_NAME('INV','INV_NO_REVISION_CONTROL'); -- ND
2113: FND_MSG_PUB.Add;
2114: RETURN F;
2115: END IF;
2116:
2117: SELECT 'VALID'

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

2126: EXCEPTION
2127:
2128: WHEN NO_DATA_FOUND THEN
2129:
2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2131: THEN
2132:
2133: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
2134: FND_MSG_PUB.Add;

Line 2134: FND_MSG_PUB.Add;

2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2131: THEN
2132:
2133: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
2134: FND_MSG_PUB.Add;
2135:
2136: END IF;
2137: RETURN F;
2138:

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

2137: RETURN F;
2138:
2139: WHEN OTHERS THEN
2140:
2141: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2142: THEN
2143: FND_MSG_PUB.Add_Exc_Msg
2144:
2145: ( G_PKG_NAME

Line 2143: FND_MSG_PUB.Add_Exc_Msg

2139: WHEN OTHERS THEN
2140:
2141: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2142: THEN
2143: FND_MSG_PUB.Add_Exc_Msg
2144:
2145: ( G_PKG_NAME
2146: , 'Revision'
2147: );

Line 2179: FND_MSG_PUB.Add;

2175: END IF;
2176:
2177: IF p_item.serial_number_control_code = 1 THEN
2178: FND_MESSAGE.SET_NAME('INV','INV_ITEM_NOT_SERIAL_CONTROLLED');
2179: FND_MSG_PUB.Add;
2180: RETURN F;
2181: END IF;
2182:
2183: IF p_item.serial_number_control_code = 2 THEN

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

2227: EXCEPTION
2228:
2229: WHEN NO_DATA_FOUND THEN
2230:
2231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2232: THEN
2233:
2234: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2235: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV',p_msg),FALSE); -- ND

Line 2237: FND_MSG_PUB.Add;

2233:
2234: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
2235: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV',p_msg),FALSE); -- ND
2236:
2237: FND_MSG_PUB.Add;
2238:
2239: END IF;
2240:
2241: RETURN F;

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

2241: RETURN F;
2242:
2243: WHEN OTHERS THEN
2244:
2245: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2246: THEN
2247: FND_MSG_PUB.Add_Exc_Msg
2248: ( G_PKG_NAME
2249: , 'Check_serial_number'

Line 2247: FND_MSG_PUB.Add_Exc_Msg

2243: WHEN OTHERS THEN
2244:
2245: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2246: THEN
2247: FND_MSG_PUB.Add_Exc_Msg
2248: ( G_PKG_NAME
2249: , 'Check_serial_number'
2250: );
2251: END IF;

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

2619: EXCEPTION
2620:
2621: WHEN no_data_found THEN
2622:
2623: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2624: THEN
2625: fnd_message.set_name('INV','INV_INVALID_SUBINV');
2626: fnd_msg_pub.ADD;
2627: END IF;

Line 2626: fnd_msg_pub.ADD;

2622:
2623: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2624: THEN
2625: fnd_message.set_name('INV','INV_INVALID_SUBINV');
2626: fnd_msg_pub.ADD;
2627: END IF;
2628:
2629: RETURN F;
2630:

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

2629: RETURN F;
2630:
2631: WHEN OTHERS THEN
2632:
2633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2634: THEN
2635: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2636: END IF;
2637:

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

2631: WHEN OTHERS THEN
2632:
2633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2634: THEN
2635: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2636: END IF;
2637:
2638: RAISE fnd_api.g_exc_unexpected_error;
2639:

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

2670: EXCEPTION
2671:
2672: WHEN no_data_found THEN
2673:
2674: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2675: THEN
2676: fnd_message.set_name('INV','INV_INT_RESSUBEXP');
2677: fnd_msg_pub.ADD;
2678: END IF;

Line 2677: fnd_msg_pub.ADD;

2673:
2674: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2675: THEN
2676: fnd_message.set_name('INV','INV_INT_RESSUBEXP');
2677: fnd_msg_pub.ADD;
2678: END IF;
2679:
2680: RETURN F;
2681:

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

2680: RETURN F;
2681:
2682: WHEN OTHERS THEN
2683:
2684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2685: THEN
2686: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2687: END IF;
2688:

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

2682: WHEN OTHERS THEN
2683:
2684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2685: THEN
2686: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2687: END IF;
2688:
2689: RAISE fnd_api.g_exc_unexpected_error;
2690:

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

2717: EXCEPTION
2718:
2719: WHEN NO_DATA_FOUND THEN
2720:
2721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2722: THEN
2723:
2724: FND_MESSAGE.SET_NAME('INV','INV_TASK_ERR');
2725: FND_MSG_PUB.Add;

Line 2725: FND_MSG_PUB.Add;

2721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2722: THEN
2723:
2724: FND_MESSAGE.SET_NAME('INV','INV_TASK_ERR');
2725: FND_MSG_PUB.Add;
2726:
2727: END IF;
2728:
2729: RETURN F;

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

2729: RETURN F;
2730:
2731: WHEN OTHERS THEN
2732:
2733: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2734: THEN
2735: FND_MSG_PUB.Add_Exc_Msg
2736: ( G_PKG_NAME
2737: , 'Task'

Line 2735: FND_MSG_PUB.Add_Exc_Msg

2731: WHEN OTHERS THEN
2732:
2733: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2734: THEN
2735: FND_MSG_PUB.Add_Exc_Msg
2736: ( G_PKG_NAME
2737: , 'Task'
2738: );
2739: END IF;

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

2812:
2813: EXCEPTION
2814: WHEN NO_DATA_FOUND THEN
2815:
2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LOCATION');
2820: FND_MSG_PUB.Add;

Line 2820: FND_MSG_PUB.Add;

2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LOCATION');
2820: FND_MSG_PUB.Add;
2821:
2822: END IF;
2823:
2824: RETURN F;

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

2824: RETURN F;
2825:
2826: WHEN OTHERS THEN
2827:
2828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2829: THEN
2830: FND_MSG_PUB.Add_Exc_Msg
2831: ( G_PKG_NAME
2832: , 'Task'

Line 2830: FND_MSG_PUB.Add_Exc_Msg

2826: WHEN OTHERS THEN
2827:
2828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2829: THEN
2830: FND_MSG_PUB.Add_Exc_Msg
2831: ( G_PKG_NAME
2832: , 'Task'
2833: );
2834: END IF;

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

2871: EXCEPTION
2872:
2873: WHEN NO_DATA_FOUND THEN
2874:
2875: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2876: THEN
2877:
2878: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');
2879: FND_MSG_PUB.Add;

Line 2879: FND_MSG_PUB.Add;

2875: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2876: THEN
2877:
2878: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');
2879: FND_MSG_PUB.Add;
2880:
2881: END IF;
2882:
2883: RETURN F;

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

2883: RETURN F;
2884:
2885: WHEN OTHERS THEN
2886:
2887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2888: THEN
2889: FND_MSG_PUB.Add_Exc_Msg
2890: ( G_PKG_NAME
2891: , 'Uom'

Line 2889: FND_MSG_PUB.Add_Exc_Msg

2885: WHEN OTHERS THEN
2886:
2887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2888: THEN
2889: FND_MSG_PUB.Add_Exc_Msg
2890: ( G_PKG_NAME
2891: , 'Uom'
2892: );
2893: END IF;

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

2947: where cost_group_id = p_cost_group_id;
2948: return T;
2949: Exception
2950: when no_data_found then
2951: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2952: FND_MESSAGE.SET_NAME('INV','INV_CST_GRP');
2953: FND_MSG_PUB.Add;
2954: END IF;
2955: return F;

Line 2953: FND_MSG_PUB.Add;

2949: Exception
2950: when no_data_found then
2951: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2952: FND_MESSAGE.SET_NAME('INV','INV_CST_GRP');
2953: FND_MSG_PUB.Add;
2954: END IF;
2955: return F;
2956:
2957: WHEN OTHERS THEN

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

2954: END IF;
2955: return F;
2956:
2957: WHEN OTHERS THEN
2958: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2959: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cost Group');
2960: END IF;
2961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2962: return F;

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

2955: return F;
2956:
2957: WHEN OTHERS THEN
2958: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2959: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cost Group');
2960: END IF;
2961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2962: return F;
2963: END;

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

2974: RETURN t;
2975:
2976: Exception
2977: when no_data_found then
2978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2979: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LPN');
2980: FND_MSG_PUB.Add;
2981: END IF;
2982: return F;

Line 2980: FND_MSG_PUB.Add;

2976: Exception
2977: when no_data_found then
2978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2979: FND_MESSAGE.SET_NAME('INV','INV_INVALID_LPN');
2980: FND_MSG_PUB.Add;
2981: END IF;
2982: return F;
2983:
2984: WHEN OTHERS THEN

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

2981: END IF;
2982: return F;
2983:
2984: WHEN OTHERS THEN
2985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2986: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'LPN');
2987: END IF;
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2989: return F;

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

2982: return F;
2983:
2984: WHEN OTHERS THEN
2985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2986: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'LPN');
2987: END IF;
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2989: return F;
2990: END;

Line 3015: FND_MSG_PUB.Add;

3011: END IF;
3012:
3013: IF p_item.lot_control_code = 1 THEN
3014: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
3015: FND_MSG_PUB.Add;
3016: RETURN F;
3017: END IF;
3018:
3019:

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

3029: EXCEPTION
3030:
3031: WHEN NO_DATA_FOUND THEN
3032:
3033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3034: THEN
3035:
3036: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
3037: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);

Line 3038: FND_MSG_PUB.Add;

3034: THEN
3035:
3036: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
3037: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','CAPS_LOT_NUMBER'),FALSE);
3038: FND_MSG_PUB.Add;
3039:
3040: END IF;
3041: RETURN F;
3042:

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

3041: RETURN F;
3042:
3043: WHEN OTHERS THEN
3044:
3045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME
3049: , 'Lot_Number'

Line 3047: FND_MSG_PUB.Add_Exc_Msg

3043: WHEN OTHERS THEN
3044:
3045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME
3049: , 'Lot_Number'
3050: );
3051: END IF;

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

3062: BEGIN
3063: IF p_secondary_quantity IS NULL OR
3064: p_secondary_quantity = FND_API.G_MISS_NUM
3065: THEN
3066: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3067: THEN
3068: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
3069: FND_MSG_PUB.Add;
3070: END IF;

Line 3069: FND_MSG_PUB.Add;

3065: THEN
3066: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3067: THEN
3068: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
3069: FND_MSG_PUB.Add;
3070: END IF;
3071: return F;
3072: END IF;
3073: RETURN T;