DBA Data[Home] [Help]

APPS.INV_CALCULATE_EXP_DATE dependencies on FND_MSG_PUB

Line 852: fnd_msg_pub.ADD;

848: mydebug('Program Update_Inv_lot has failed with a Unexpected exception', 9);
849: END IF;
850: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
851: FND_MESSAGE.SET_TOKEN('PROG_NAME','Update_Inv_lot');
852: fnd_msg_pub.ADD;
853: RAISE l_exc_unexpected_error;
854: END IF;
855:
856: EXCEPTION

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

855:
856: EXCEPTION
857: WHEN NO_DATA_FOUND THEN
858: x_return_status := fnd_api.g_ret_sts_error;
859: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
860: if( x_msg_count > 1 ) then
861: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
862: end if;
863: mydebug('Upd Inv Lot Attr: In No data found ' || SQLERRM, 9);

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

857: WHEN NO_DATA_FOUND THEN
858: x_return_status := fnd_api.g_ret_sts_error;
859: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
860: if( x_msg_count > 1 ) then
861: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
862: end if;
863: mydebug('Upd Inv Lot Attr: In No data found ' || SQLERRM, 9);
864: WHEN l_exc_error THEN
865: x_return_status := fnd_api.g_ret_sts_error;

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

862: end if;
863: mydebug('Upd Inv Lot Attr: In No data found ' || SQLERRM, 9);
864: WHEN l_exc_error THEN
865: x_return_status := fnd_api.g_ret_sts_error;
866: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
867: if( x_msg_count > 1 ) then
868: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
869: end if;
870: mydebug('Upd Inv Lot Attr: In l_exc_error ' || SQLERRM, 9);

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

864: WHEN l_exc_error THEN
865: x_return_status := fnd_api.g_ret_sts_error;
866: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
867: if( x_msg_count > 1 ) then
868: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
869: end if;
870: mydebug('Upd Inv Lot Attr: In l_exc_error ' || SQLERRM, 9);
871: WHEN l_exc_unexpected_error THEN
872: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

869: end if;
870: mydebug('Upd Inv Lot Attr: In l_exc_error ' || SQLERRM, 9);
871: WHEN l_exc_unexpected_error THEN
872: x_return_status := fnd_api.g_ret_sts_unexp_error;
873: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
874: if ( x_msg_count > 1 ) then
875: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
876: end if;
877: mydebug('In l_exc_unexpected_error ' || SQLERRM, 9);

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

871: WHEN l_exc_unexpected_error THEN
872: x_return_status := fnd_api.g_ret_sts_unexp_error;
873: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
874: if ( x_msg_count > 1 ) then
875: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
876: end if;
877: mydebug('In l_exc_unexpected_error ' || SQLERRM, 9);
878: WHEN OTHERS THEN
879: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

876: end if;
877: mydebug('In l_exc_unexpected_error ' || SQLERRM, 9);
878: WHEN OTHERS THEN
879: x_return_status := fnd_api.g_ret_sts_unexp_error;
880: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
881: if( x_msg_count > 1 ) then
882: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
883: end if;
884: mydebug('Upd Inv Lot Attr: In others ' || SQLERRM, 9);

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

878: WHEN OTHERS THEN
879: x_return_status := fnd_api.g_ret_sts_unexp_error;
880: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
881: if( x_msg_count > 1 ) then
882: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
883: end if;
884: mydebug('Upd Inv Lot Attr: In others ' || SQLERRM, 9);
885: END;
886: