95: RETURN FALSE;
96:
97: WHEN OTHERS THEN
98: --
99: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
100: THEN
101: fnd_msg_pub.add_exc_msg
102: ( g_pkg_name
103: , 'BRANCHING LOGIC'
97: WHEN OTHERS THEN
98: --
99: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
100: THEN
101: fnd_msg_pub.add_exc_msg
102: ( g_pkg_name
103: , 'BRANCHING LOGIC'
104: );
105: END IF;
206: --
207: WHEN OTHERS THEN
208: x_return_status := fnd_api.g_ret_sts_unexp_error ;
209: --
210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
211: THEN
212: fnd_msg_pub.add_exc_msg
213: ( g_pkg_name
214: , 'GET PROCESS ORG'
208: x_return_status := fnd_api.g_ret_sts_unexp_error ;
209: --
210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
211: THEN
212: fnd_msg_pub.add_exc_msg
213: ( g_pkg_name
214: , 'GET PROCESS ORG'
215: );
216: END IF;
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: RETURN FALSE;
280:
281: WHEN OTHERS THEN
282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
283: , 'Search_process_org_cache'
284: );
285: RETURN FALSE;
286:
332:
333: EXCEPTION
334:
335: WHEN OTHERS THEN
336: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
337: , 'SET INSTALLED'
338: );
339:
340: END set_installed;
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: RETURN FALSE;
399:
400: WHEN OTHERS THEN
401: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
402: , 'SEARCH_PROCESS_ORG_DB'
403: );
404: RETURN FALSE;
405:
449: l_process_rec_tbl(tbl_index) := l_process_rec;
450:
451: EXCEPTION
452: WHEN OTHERS THEN
453: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
454: , 'ADD_PROCESS_ORG_TO_CACHE'
455: );
456:
457:
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: RETURN FALSE;
578:
579: WHEN OTHERS THEN
580: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
581: , 'IS_ORG_PROCESS_ORG'
582: );
583: RETURN FALSE;
584:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: RETURN FALSE;
646:
647: WHEN OTHERS THEN
648: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
649: , 'Search_discrete_org_cache'
650: );
651: RETURN FALSE;
652:
697: l_discrete_rec_tbl(tbl_index).organization_id := P_ORGANIZATION_ID;
698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
702: , 'ADD_DISCRETE_ORG_TO_CACHE'
703: );
704:
705: