DBA Data[Home] [Help]

APPS.INV_CALCULATE_EXP_DATE dependencies on FND_MSG_PUB

Line 807: fnd_msg_pub.ADD;

803: mydebug('Program Update_Inv_lot has failed with a Unexpected exception', 9);
804: END IF;
805: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
806: FND_MESSAGE.SET_TOKEN('PROG_NAME','Update_Inv_lot');
807: fnd_msg_pub.ADD;
808: RAISE l_exc_unexpected_error;
809: END IF;
810:
811: EXCEPTION

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

810:
811: EXCEPTION
812: WHEN NO_DATA_FOUND THEN
813: x_return_status := fnd_api.g_ret_sts_error;
814: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
815: if( x_msg_count > 1 ) then
816: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
817: end if;
818: mydebug('Upd Inv Lot Attr: In No data found ' || SQLERRM, 9);

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

812: WHEN NO_DATA_FOUND THEN
813: x_return_status := fnd_api.g_ret_sts_error;
814: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
815: if( x_msg_count > 1 ) then
816: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
817: end if;
818: mydebug('Upd Inv Lot Attr: In No data found ' || SQLERRM, 9);
819: WHEN l_exc_error THEN
820: x_return_status := fnd_api.g_ret_sts_error;

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

817: end if;
818: mydebug('Upd Inv Lot Attr: In No data found ' || SQLERRM, 9);
819: WHEN l_exc_error THEN
820: x_return_status := fnd_api.g_ret_sts_error;
821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
822: if( x_msg_count > 1 ) then
823: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
824: end if;
825: mydebug('Upd Inv Lot Attr: In l_exc_error ' || SQLERRM, 9);

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

819: WHEN l_exc_error THEN
820: x_return_status := fnd_api.g_ret_sts_error;
821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
822: if( x_msg_count > 1 ) then
823: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
824: end if;
825: mydebug('Upd Inv Lot Attr: In l_exc_error ' || SQLERRM, 9);
826: WHEN l_exc_unexpected_error THEN
827: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

824: end if;
825: mydebug('Upd Inv Lot Attr: In l_exc_error ' || SQLERRM, 9);
826: WHEN l_exc_unexpected_error THEN
827: x_return_status := fnd_api.g_ret_sts_unexp_error;
828: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
829: if ( x_msg_count > 1 ) then
830: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
831: end if;
832: mydebug('In l_exc_unexpected_error ' || SQLERRM, 9);

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

826: WHEN l_exc_unexpected_error THEN
827: x_return_status := fnd_api.g_ret_sts_unexp_error;
828: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
829: if ( x_msg_count > 1 ) then
830: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
831: end if;
832: mydebug('In l_exc_unexpected_error ' || SQLERRM, 9);
833: WHEN OTHERS THEN
834: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

831: end if;
832: mydebug('In l_exc_unexpected_error ' || SQLERRM, 9);
833: WHEN OTHERS THEN
834: x_return_status := fnd_api.g_ret_sts_unexp_error;
835: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
836: if( x_msg_count > 1 ) then
837: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
838: end if;
839: mydebug('Upd Inv Lot Attr: In others ' || SQLERRM, 9);

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

833: WHEN OTHERS THEN
834: x_return_status := fnd_api.g_ret_sts_unexp_error;
835: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
836: if( x_msg_count > 1 ) then
837: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
838: end if;
839: mydebug('Upd Inv Lot Attr: In others ' || SQLERRM, 9);
840: END;
841: