APPS.DPP_TRANSACTION_PVT dependencies on OZF_PROCESS_SETUP_ALL

Line 417: FROM OZF_PROCESS_SETUP_ALL

413:
414: CURSOR get_process_setup_cnt_csr (p_supp_trade_profile_id NUMBER, p_org_id NUMBER)
415: IS
416: SELECT COUNT(1)
417: FROM OZF_PROCESS_SETUP_ALL
418: WHERE nvl(supp_trade_profile_id,0) = nvl(p_supp_trade_profile_id,0)
419: AND enabled_flag = 'Y'
420: AND org_id = p_org_id;
421:

Line 443: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: '||SQLERRM);

439: CLOSE get_process_setup_cnt_csr;
440: END IF;
441: EXCEPTION
442: WHEN OTHERS THEN
443: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: '||SQLERRM);
444: FND_FILE.NEW_LINE(FND_FILE.LOG);
445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
446: END;
447: