APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on GL_PERIOD_STATUSES

Line 144: debug(l_module_name,'SELECT gl_period_statuses');

140:
141: IF (p_retcode = g_SUCCESS) THEN
142: BEGIN
143: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
144: debug(l_module_name,'SELECT gl_period_statuses');
145: END IF;
146: SELECT 1
147: INTO l_ar_period_count
148: FROM gl_period_statuses

Line 148: FROM gl_period_statuses

144: debug(l_module_name,'SELECT gl_period_statuses');
145: END IF;
146: SELECT 1
147: INTO l_ar_period_count
148: FROM gl_period_statuses
149: WHERE closing_status ='O'
150: AND set_of_books_id = g_set_of_books_id
151: AND application_id = 222
152: AND p_gl_date between start_date and end_date;

Line 155: l_location := l_module_name||'.select_gl_period_statuses1';

151: AND application_id = 222
152: AND p_gl_date between start_date and end_date;
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
155: l_location := l_module_name||'.select_gl_period_statuses1';
156: log (l_location, 'GL Date should be in an open period. ');
157: log (l_location, 'Please Enter a GL Date which is in an open period ') ;
158: p_retcode := g_FAILURE;
159: WHEN OTHERS THEN

Line 162: l_location := l_module_name||'.select_gl_period_statuses2';

158: p_retcode := g_FAILURE;
159: WHEN OTHERS THEN
160: p_retcode := g_FAILURE;
161: p_errbuf := SQLERRM;
162: l_location := l_module_name||'.select_gl_period_statuses2';
163: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
164: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
165: END;
166: END IF;