DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on FND_MSG_PUB

Line 307: FND_MSG_PUB.Count_And_Get

303: END IF;
304: IF (l_debug = 1) THEN
305: INV_TRX_UTIL_PUB.trace('mmtt over ' ,g_pkg_name,9);
306: END IF;
307: FND_MSG_PUB.Count_And_Get
308: ( p_count => x_msg_count ,
309: p_data => x_msg_data
310: );
311:

Line 316: FND_MSG_PUB.Count_And_Get

312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK ;
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: FND_MSG_PUB.Count_And_Get
317: (p_encoded => FND_API.G_FALSE,
318: p_count => x_msg_count,
319: p_data => x_msg_data);
320: IF (l_debug = 1) THEN

Line 326: FND_MSG_PUB.Count_And_Get

322: END IF;
323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
324: ROLLBACK ;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
326: FND_MSG_PUB.Count_And_Get
327: (p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: IF (l_debug = 1) THEN

Line 337: FND_MSG_PUB.Count_And_Get

333: WHEN OTHERS
334: THEN
335: ROLLBACK ;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: FND_MSG_PUB.Count_And_Get
338: (p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data);
341: IF (l_debug = 1) THEN

Line 672: FND_MSG_PUB.ADD;

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);
675: END IF;
676: END ;

Line 738: FND_MSG_PUB.ADD;

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 '
742: || ':' || sqlerrm,g_pkg_name,9);

Line 781: FND_MSG_PUB.ADD;

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;
785: x_return_status := FND_API.G_RET_STS_ERROR;

Line 792: FND_MSG_PUB.ADD;

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;
796: x_return_status := FND_API.G_RET_STS_ERROR;

Line 801: FND_MSG_PUB.ADD;

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;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 893: FND_MSG_PUB.ADD;

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)
897: THEN

Line 899: FND_MSG_PUB.ADD;

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;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 916: FND_MSG_PUB.ADD;

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

Line 1200: FND_MSG_PUB.ADD;

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 ;
1202:
1203: END;
1204:

Line 1236: FND_MSG_PUB.ADD;

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');
1240: FND_MSG_PUB.ADD;

Line 1240: FND_MSG_PUB.ADD;

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:
1244: -- Check if the WMS is installed ?

Line 1256: FND_MSG_PUB.ADD;

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;
1259:
1260: -- Check if the organization is a WMS organization ?

Line 1272: FND_MSG_PUB.ADD;

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;
1275:
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1277: FND_MSG_PUB.Count_And_Get

1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1274: END;
1275:
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277: FND_MSG_PUB.Count_And_Get
1278: ( p_count => x_msg_count ,
1279: p_data => x_msg_data
1280: );
1281: EXCEPTION

Line 1284: FND_MSG_PUB.Count_And_Get

1280: );
1281: EXCEPTION
1282: WHEN FND_API.G_EXC_ERROR THEN
1283: x_return_status := FND_API.G_RET_STS_ERROR ;
1284: FND_MSG_PUB.Count_And_Get
1285: (p_encoded => FND_API.G_FALSE,
1286: p_count => x_msg_count,
1287: p_data => x_msg_data);
1288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1290: FND_MSG_PUB.Count_And_Get

1286: p_count => x_msg_count,
1287: p_data => x_msg_data);
1288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290: FND_MSG_PUB.Count_And_Get
1291: (p_encoded => FND_API.G_FALSE,
1292: p_count => x_msg_count,
1293: p_data => x_msg_data);
1294: WHEN OTHERS THEN

Line 1296: FND_MSG_PUB.Count_And_Get

1292: p_count => x_msg_count,
1293: p_data => x_msg_data);
1294: WHEN OTHERS THEN
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: FND_MSG_PUB.Count_And_Get
1297: (p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300: