DBA Data[Home] [Help]

APPS.PA_REP_UTIL_SETUP dependencies on FND_PROFILE

Line 22: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

18: l_total_records NUMBER :=0;
19: l_cut_off_date DATE;
20: l_commit_size PLS_INTEGER;
21: l_fnd_msg VARCHAR2 (2000);
22: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
23:
24: CURSOR discarded_records(p_cut_off_date IN DATE) IS
25: select cdl.rowid
26: from pa_expenditure_items_all ei

Line 80: l_cut_off_date :=FND_PROFILE.VALUE('PA_UTL_START_DATE');

76: PA_DEBUG.g_err_stage := '150 : before geting the value of profile PA_UTL_START_DATE';
77: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
78: END IF;
79:
80: l_cut_off_date :=FND_PROFILE.VALUE('PA_UTL_START_DATE');
81:
82: IF l_cut_off_date IS NULL THEN
83: retcode := 2;
84: errbuf := 'The profile PA_UTL_START_DATE is not defined and its value is null';