315: EXCEPTION
316: WHEN OTHERS THEN
317: p_return_code := fnd_api.g_ret_sts_unexp_error;
318: restore_context(l_orig_acc_mode, l_orig_org_id);
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
322: END IF;
323: FND_MSG_PUB.count_and_get
317: p_return_code := fnd_api.g_ret_sts_unexp_error;
318: restore_context(l_orig_acc_mode, l_orig_org_id);
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
322: END IF;
323: FND_MSG_PUB.count_and_get
324: (
325: p_count => p_count ,
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
322: END IF;
323: FND_MSG_PUB.count_and_get
324: (
325: p_count => p_count ,
326: p_data => p_data ,
327: p_encoded => FND_API.g_false
538: EXCEPTION
539: WHEN OTHERS THEN
540: p_return_code := fnd_api.g_ret_sts_unexp_error;
541: restore_context(l_orig_acc_mode, l_orig_org_id);
542: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
543: THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;
546: FND_MSG_PUB.count_and_get
540: p_return_code := fnd_api.g_ret_sts_unexp_error;
541: restore_context(l_orig_acc_mode, l_orig_org_id);
542: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
543: THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;
546: FND_MSG_PUB.count_and_get
547: (
548: p_count => p_count ,
542: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
543: THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;
546: FND_MSG_PUB.count_and_get
547: (
548: p_count => p_count ,
549: p_data => p_data ,
550: p_encoded => FND_API.g_false
763: EXCEPTION
764: WHEN OTHERS THEN
765: p_return_code := fnd_api.g_ret_sts_unexp_error;
766: restore_context(l_orig_acc_mode, l_orig_org_id);
767: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
768: THEN
769: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
770: END IF;
771: FND_MSG_PUB.count_and_get
765: p_return_code := fnd_api.g_ret_sts_unexp_error;
766: restore_context(l_orig_acc_mode, l_orig_org_id);
767: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
768: THEN
769: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
770: END IF;
771: FND_MSG_PUB.count_and_get
772: (
773: p_count => p_count ,
767: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
768: THEN
769: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
770: END IF;
771: FND_MSG_PUB.count_and_get
772: (
773: p_count => p_count ,
774: p_data => p_data ,
775: p_encoded => FND_API.g_false
999: EXCEPTION
1000: WHEN OTHERS THEN
1001: p_return_code := fnd_api.g_ret_sts_unexp_error;
1002: restore_context(l_orig_acc_mode, l_orig_org_id);
1003: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN
1005: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1006: END IF;
1007: FND_MSG_PUB.count_and_get
1001: p_return_code := fnd_api.g_ret_sts_unexp_error;
1002: restore_context(l_orig_acc_mode, l_orig_org_id);
1003: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN
1005: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1006: END IF;
1007: FND_MSG_PUB.count_and_get
1008: (
1009: p_count => p_count ,
1003: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN
1005: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1006: END IF;
1007: FND_MSG_PUB.count_and_get
1008: (
1009: p_count => p_count ,
1010: p_data => p_data ,
1011: p_encoded => FND_API.g_false