DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on FND_MESSAGE

Line 670: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_COMMIT_FAILURE');

666: INV_TRX_UTIL_PUB.trace( 'G_EXC_UNEXPECTED_ERROR:INV_LOT_COMMIT_FAILURE ' || l_msg_data || ':' || sqlerrm,g_pkg_name,9);
667: END IF;
668: WHEN OTHERS THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_COMMIT_FAILURE');
671: -- INV_LOT_COMMIT_FAILURE: There has been a database insert error, please contact your dba or Oracle Support'
672: FND_MSG_PUB.ADD;
673: IF (l_debug = 1) THEN
674: INV_TRX_UTIL_PUB.trace( 'Other INV_LOT_COMMIT_FAILURE ' || l_msg_data || ':' || sqlerrm,g_pkg_name,9);

Line 736: FND_MESSAGE.SET_NAME('INV', 'INV_NOOPEN_PERIOD_FOR_DATE');

732:
733:
734: EXCEPTION
735: WHEN NO_DATA_FOUND THEN
736: FND_MESSAGE.SET_NAME('INV', 'INV_NOOPEN_PERIOD_FOR_DATE');
737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE1', SYSDATE);
738: FND_MSG_PUB.ADD;
739: x_return_status := FND_API.G_RET_STS_ERROR ;
740: IF (l_debug = 1) THEN

Line 737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE1', SYSDATE);

733:
734: EXCEPTION
735: WHEN NO_DATA_FOUND THEN
736: FND_MESSAGE.SET_NAME('INV', 'INV_NOOPEN_PERIOD_FOR_DATE');
737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE1', SYSDATE);
738: FND_MSG_PUB.ADD;
739: x_return_status := FND_API.G_RET_STS_ERROR ;
740: IF (l_debug = 1) THEN
741: INV_TRX_UTIL_PUB.trace( 'INV_NOOPEN_PERIOD_FOR_DATE '

Line 780: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');

776: WHERE organization_id = tab_input(1).organization_id;
777: END IF;
778:
779: IF (l_dist_account_id IS NULL) THEN
780: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');
781: FND_MSG_PUB.ADD;
782: IF (l_debug = 1) THEN
783: INV_TRX_UTIL_PUB.trace('INV_NO_DIST_ACCOUNT_ID' || ':' || sqlerrm, g_pkg_name, 9);
784: END IF;

Line 791: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');

787: END IF;
788:
789: EXCEPTION
790: WHEN NO_DATA_FOUND THEN
791: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');
792: FND_MSG_PUB.ADD;
793: IF (l_debug = 1) THEN
794: INV_TRX_UTIL_PUB.trace('INV_NO_DIST_ACCOUNT_ID' || ':' || sqlerrm, g_pkg_name, 9);
795: END IF;

Line 800: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');

796: x_return_status := FND_API.G_RET_STS_ERROR;
797: RAISE FND_API.G_EXC_ERROR;
798: WHEN OTHERS THEN
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');
801: FND_MSG_PUB.ADD;
802: IF (l_debug = 1) THEN
803: INV_TRX_UTIL_PUB.trace('INV_NO_DIST_ACCOUNT_ID' || ':' || sqlerrm, g_pkg_name, 9);
804: END IF;

Line 892: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');

888: THEN
889: IF (l_debug = 1) THEN
890: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_ERROR',g_pkg_name,9);
891: END IF;
892: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
893: FND_MSG_PUB.ADD;
894: RAISE FND_API.G_EXC_ERROR ;
895: END IF;
896: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

Line 898: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');

894: RAISE FND_API.G_EXC_ERROR ;
895: END IF;
896: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
897: THEN
898: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
899: FND_MSG_PUB.ADD;
900: IF (l_debug = 1) THEN
901: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_UNEXPERROR',g_pkg_name,9);
902: END IF;

Line 914: FND_MESSAGE.SET_NAME('INV', 'INV_FIELD_INVALID');

910: l_msg_data := 'LPN not found: ' || sqlerrm;
911: IF (l_debug = 1) THEN
912: INV_TRX_UTIL_PUB.trace(l_msg_data,g_pkg_name,9);
913: END IF;
914: FND_MESSAGE.SET_NAME('INV', 'INV_FIELD_INVALID');
915: FND_MESSAGE.SET_TOKEN('ENTITY1', tab_input(ind).lpn_number);
916: FND_MSG_PUB.ADD;
917: RAISE FND_API.G_EXC_ERROR ;
918: EXIT;

Line 915: FND_MESSAGE.SET_TOKEN('ENTITY1', tab_input(ind).lpn_number);

911: IF (l_debug = 1) THEN
912: INV_TRX_UTIL_PUB.trace(l_msg_data,g_pkg_name,9);
913: END IF;
914: FND_MESSAGE.SET_NAME('INV', 'INV_FIELD_INVALID');
915: FND_MESSAGE.SET_TOKEN('ENTITY1', tab_input(ind).lpn_number);
916: FND_MSG_PUB.ADD;
917: RAISE FND_API.G_EXC_ERROR ;
918: EXIT;
919: END ;

Line 1196: FND_MESSAGE.SET_NAME('INV', 'INV_TRANSACTION_TYPE_ERROR');

1192: END IF;
1193: END LOOP;
1194: EXCEPTION
1195: WHEN NO_DATA_FOUND THEN
1196: FND_MESSAGE.SET_NAME('INV', 'INV_TRANSACTION_TYPE_ERROR');
1197: FND_MESSAGE.SET_TOKEN('ENTITY1', INV_Globals.G_type_inv_lot_split || ',' ||
1198: INV_Globals.G_type_inv_lot_merge || ',' ||
1199: INV_Globals.G_type_inv_lot_translate);
1200: FND_MSG_PUB.ADD;

Line 1197: FND_MESSAGE.SET_TOKEN('ENTITY1', INV_Globals.G_type_inv_lot_split || ',' ||

1193: END LOOP;
1194: EXCEPTION
1195: WHEN NO_DATA_FOUND THEN
1196: FND_MESSAGE.SET_NAME('INV', 'INV_TRANSACTION_TYPE_ERROR');
1197: FND_MESSAGE.SET_TOKEN('ENTITY1', INV_Globals.G_type_inv_lot_split || ',' ||
1198: INV_Globals.G_type_inv_lot_merge || ',' ||
1199: INV_Globals.G_type_inv_lot_translate);
1200: FND_MSG_PUB.ADD;
1201: RAISE FND_API.G_EXC_ERROR ;

Line 1235: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LOCATOR_CONTROL_ORG');

1231: END IF;
1232:
1233: EXCEPTION
1234: WHEN NO_DATA_FOUND THEN
1235: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LOCATOR_CONTROL_ORG');
1236: FND_MSG_PUB.ADD;
1237: RAISE FND_API.G_EXC_ERROR ;
1238: WHEN OTHERS THEN
1239: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LOCATOR_CONTROL_ORG');

Line 1239: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LOCATOR_CONTROL_ORG');

1235: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LOCATOR_CONTROL_ORG');
1236: FND_MSG_PUB.ADD;
1237: RAISE FND_API.G_EXC_ERROR ;
1238: WHEN OTHERS THEN
1239: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LOCATOR_CONTROL_ORG');
1240: FND_MSG_PUB.ADD;
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1242: END;
1243:

Line 1254: FND_MESSAGE.SET_NAME('WMS', 'WMS_INSTALL_CHK_ERROR');

1250: p_org => NULL) ;
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: FND_MESSAGE.SET_NAME('WMS', 'WMS_INSTALL_CHK_ERROR');
1255: -- WMS_INSTALL_CHK_ERROR : Error determining if WMS is Installed
1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1258: END;

Line 1270: FND_MESSAGE.SET_NAME('INV', 'INV_WMS_ORG');

1266: p_org => p_organization_id);
1267:
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: FND_MESSAGE.SET_NAME('INV', 'INV_WMS_ORG');
1271: -- INV_WMS_ORG: Error Determining if Organization is WMS enabled
1272: FND_MSG_PUB.ADD;
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1274: END;