DBA Data[Home] [Help]

APPS.INV_LOT_EO_PVT dependencies on FND_MSG_PUB

Line 398: fnd_msg_pub.ADD;

394: mydebug('Program Create_Inv_lot has failed with a Unexpected exception');
395: END IF;
396: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
397: FND_MESSAGE.SET_TOKEN('PROG_NAME','Create_Inv_lot');
398: fnd_msg_pub.ADD;
399: RAISE g_exc_unexpected_error;
400: END IF;
401:
402: mydebug('End of the program create_inv_lot. Program has completed successfully ');

Line 409: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

405: EXCEPTION
406: WHEN NO_DATA_FOUND THEN
407: x_return_status := fnd_api.g_ret_sts_error;
408: ROLLBACK TO inv_new_lot;
409: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
410: if( x_msg_count > 1 ) then
411: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
412: end if;
413: mydebug('In No data found ' || SQLERRM);

Line 411: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

407: x_return_status := fnd_api.g_ret_sts_error;
408: ROLLBACK TO inv_new_lot;
409: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
410: if( x_msg_count > 1 ) then
411: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
412: end if;
413: mydebug('In No data found ' || SQLERRM);
414: WHEN g_exc_error THEN
415: x_return_status := fnd_api.g_ret_sts_error;

Line 417: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

413: mydebug('In No data found ' || SQLERRM);
414: WHEN g_exc_error THEN
415: x_return_status := fnd_api.g_ret_sts_error;
416: ROLLBACK TO inv_new_lot;
417: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
418: if( x_msg_count > 1 ) then
419: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
420: end if;
421: mydebug('In g_exc_error ' || SQLERRM);

Line 419: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

415: x_return_status := fnd_api.g_ret_sts_error;
416: ROLLBACK TO inv_new_lot;
417: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
418: if( x_msg_count > 1 ) then
419: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
420: end if;
421: mydebug('In g_exc_error ' || SQLERRM);
422: WHEN g_exc_unexpected_error THEN
423: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

421: mydebug('In g_exc_error ' || SQLERRM);
422: WHEN g_exc_unexpected_error THEN
423: x_return_status := fnd_api.g_ret_sts_unexp_error;
424: ROLLBACK TO inv_new_lot;
425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
426: if( x_msg_count > 1 ) then
427: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
428: end if;
429: mydebug('In g_exc_unexpected_error ' || SQLERRM);

Line 427: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

423: x_return_status := fnd_api.g_ret_sts_unexp_error;
424: ROLLBACK TO inv_new_lot;
425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
426: if( x_msg_count > 1 ) then
427: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
428: end if;
429: mydebug('In g_exc_unexpected_error ' || SQLERRM);
430: WHEN OTHERS THEN
431: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 433: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

429: mydebug('In g_exc_unexpected_error ' || SQLERRM);
430: WHEN OTHERS THEN
431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432: ROLLBACK TO inv_new_lot;
433: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
434: if( x_msg_count > 1 ) then
435: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
436: end if;
437: mydebug('In others ' || SQLERRM);

Line 435: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432: ROLLBACK TO inv_new_lot;
433: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
434: if( x_msg_count > 1 ) then
435: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
436: end if;
437: mydebug('In others ' || SQLERRM);
438:
439: END preprocess_lot;