DBA Data[Home] [Help]

APPS.JA_CN_CFS_CONC_PROG dependencies on FND_LOG

Line 146: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

142: p_destination_filename IN VARCHAR2) IS
143: l_error_flag VARCHAR2(1) := 'N';
144: l_error_status BOOLEAN;
145:
146: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
147: l_proc_level NUMBER := FND_LOG.Level_Procedure;
148: l_proc_name VARCHAR2(100) := 'Cfs_Generate';
149:
150: BEGIN

Line 147: l_proc_level NUMBER := FND_LOG.Level_Procedure;

143: l_error_flag VARCHAR2(1) := 'N';
144: l_error_status BOOLEAN;
145:
146: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
147: l_proc_level NUMBER := FND_LOG.Level_Procedure;
148: l_proc_name VARCHAR2(100) := 'Cfs_Generate';
149:
150: BEGIN
151:

Line 154: FND_LOG.String(l_proc_level,

150: BEGIN
151:
152: --log for debug
153: IF (l_proc_level >= l_dbg_level) THEN
154: FND_LOG.String(l_proc_level,
155: l_module_prefix || '.' || l_proc_name || '.begin',
156: 'Enter procedure');
157:
158: FND_LOG.String(l_proc_level,

Line 158: FND_LOG.String(l_proc_level,

154: FND_LOG.String(l_proc_level,
155: l_module_prefix || '.' || l_proc_name || '.begin',
156: 'Enter procedure');
157:
158: FND_LOG.String(l_proc_level,
159: l_module_prefix || '.' || l_proc_name || '.parameters',
160: 'p_legal_entity_id ' || p_legal_entity_id);
161:
162: FND_LOG.String(l_proc_level,

Line 162: FND_LOG.String(l_proc_level,

158: FND_LOG.String(l_proc_level,
159: l_module_prefix || '.' || l_proc_name || '.parameters',
160: 'p_legal_entity_id ' || p_legal_entity_id);
161:
162: FND_LOG.String(l_proc_level,
163: l_module_prefix || '.' || l_proc_name || '.parameters',
164: 'p_ledger_id ' || p_ledger_id);
165:
166: FND_LOG.String(l_proc_level,

Line 166: FND_LOG.String(l_proc_level,

162: FND_LOG.String(l_proc_level,
163: l_module_prefix || '.' || l_proc_name || '.parameters',
164: 'p_ledger_id ' || p_ledger_id);
165:
166: FND_LOG.String(l_proc_level,
167: l_module_prefix || '.' || l_proc_name || '.parameters',
168: 'p_coa_id ' || p_coa_id);
169:
170: FND_LOG.String(l_proc_level,

Line 170: FND_LOG.String(l_proc_level,

166: FND_LOG.String(l_proc_level,
167: l_module_prefix || '.' || l_proc_name || '.parameters',
168: 'p_coa_id ' || p_coa_id);
169:
170: FND_LOG.String(l_proc_level,
171: l_module_prefix || '.' || l_proc_name || '.parameters',
172: 'p_adhoc_prefix ' || p_adhoc_prefix);
173:
174: FND_LOG.String(l_proc_level,

Line 174: FND_LOG.String(l_proc_level,

170: FND_LOG.String(l_proc_level,
171: l_module_prefix || '.' || l_proc_name || '.parameters',
172: 'p_adhoc_prefix ' || p_adhoc_prefix);
173:
174: FND_LOG.String(l_proc_level,
175: l_module_prefix || '.' || l_proc_name || '.parameters',
176: 'p_industry ' || p_industry);
177:
178: FND_LOG.String(l_proc_level,

Line 178: FND_LOG.String(l_proc_level,

174: FND_LOG.String(l_proc_level,
175: l_module_prefix || '.' || l_proc_name || '.parameters',
176: 'p_industry ' || p_industry);
177:
178: FND_LOG.String(l_proc_level,
179: l_module_prefix || '.' || l_proc_name || '.parameters',
180: 'p_id_flex_code ' || p_id_flex_code);
181:
182: FND_LOG.String(l_proc_level,

Line 182: FND_LOG.String(l_proc_level,

178: FND_LOG.String(l_proc_level,
179: l_module_prefix || '.' || l_proc_name || '.parameters',
180: 'p_id_flex_code ' || p_id_flex_code);
181:
182: FND_LOG.String(l_proc_level,
183: l_module_prefix || '.' || l_proc_name || '.parameters',
184: 'p_report_id ' || p_report_id);
185:
186: FND_LOG.String(l_proc_level,

Line 186: FND_LOG.String(l_proc_level,

182: FND_LOG.String(l_proc_level,
183: l_module_prefix || '.' || l_proc_name || '.parameters',
184: 'p_report_id ' || p_report_id);
185:
186: FND_LOG.String(l_proc_level,
187: l_module_prefix || '.' || l_proc_name || '.parameters',
188: 'p_period_name ' || p_period_name);
189:
190: FND_LOG.String(l_proc_level,

Line 190: FND_LOG.String(l_proc_level,

186: FND_LOG.String(l_proc_level,
187: l_module_prefix || '.' || l_proc_name || '.parameters',
188: 'p_period_name ' || p_period_name);
189:
190: FND_LOG.String(l_proc_level,
191: l_module_prefix || '.' || l_proc_name || '.parameters',
192: 'p_axis_set_id ' || p_axis_set_id);
193:
194: FND_LOG.String(l_proc_level,

Line 194: FND_LOG.String(l_proc_level,

190: FND_LOG.String(l_proc_level,
191: l_module_prefix || '.' || l_proc_name || '.parameters',
192: 'p_axis_set_id ' || p_axis_set_id);
193:
194: FND_LOG.String(l_proc_level,
195: l_module_prefix || '.' || l_proc_name || '.parameters',
196: 'p_colset_id ' || p_colset_id);
197:
198: FND_LOG.String(l_proc_level,

Line 198: FND_LOG.String(l_proc_level,

194: FND_LOG.String(l_proc_level,
195: l_module_prefix || '.' || l_proc_name || '.parameters',
196: 'p_colset_id ' || p_colset_id);
197:
198: FND_LOG.String(l_proc_level,
199: l_module_prefix || '.' || l_proc_name || '.parameters',
200: 'p_rounding_option ' || p_rounding_option);
201:
202: FND_LOG.String(l_proc_level,

Line 202: FND_LOG.String(l_proc_level,

198: FND_LOG.String(l_proc_level,
199: l_module_prefix || '.' || l_proc_name || '.parameters',
200: 'p_rounding_option ' || p_rounding_option);
201:
202: FND_LOG.String(l_proc_level,
203: l_module_prefix || '.' || l_proc_name || '.parameters',
204: 'p_segment_override ' || p_segment_override);
205:
206: FND_LOG.String(l_proc_level,

Line 206: FND_LOG.String(l_proc_level,

202: FND_LOG.String(l_proc_level,
203: l_module_prefix || '.' || l_proc_name || '.parameters',
204: 'p_segment_override ' || p_segment_override);
205:
206: FND_LOG.String(l_proc_level,
207: l_module_prefix || '.' || l_proc_name || '.parameters',
208: 'p_accounting_date ' || p_accounting_date);
209:
210: FND_LOG.String(l_proc_level,

Line 210: FND_LOG.String(l_proc_level,

206: FND_LOG.String(l_proc_level,
207: l_module_prefix || '.' || l_proc_name || '.parameters',
208: 'p_accounting_date ' || p_accounting_date);
209:
210: FND_LOG.String(l_proc_level,
211: l_module_prefix || '.' || l_proc_name || '.parameters',
212: 'p_parameter_set_id ' || p_parameter_set_id);
213:
214: FND_LOG.String(l_proc_level,

Line 214: FND_LOG.String(l_proc_level,

210: FND_LOG.String(l_proc_level,
211: l_module_prefix || '.' || l_proc_name || '.parameters',
212: 'p_parameter_set_id ' || p_parameter_set_id);
213:
214: FND_LOG.String(l_proc_level,
215: l_module_prefix || '.' || l_proc_name || '.parameters',
216: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
217:
218: FND_LOG.String(l_proc_level,

Line 218: FND_LOG.String(l_proc_level,

214: FND_LOG.String(l_proc_level,
215: l_module_prefix || '.' || l_proc_name || '.parameters',
216: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
217:
218: FND_LOG.String(l_proc_level,
219: l_module_prefix || '.' || l_proc_name || '.parameters',
220: 'p_balance_type ' || p_balance_type);
221:
222: /* FND_LOG.String(l_proc_level

Line 222: /* FND_LOG.String(l_proc_level

218: FND_LOG.String(l_proc_level,
219: l_module_prefix || '.' || l_proc_name || '.parameters',
220: 'p_balance_type ' || p_balance_type);
221:
222: /* FND_LOG.String(l_proc_level
223: ,l_module_prefix||'.'||l_proc_name||'.parameters'
224: ,'p_internal_trx_flag '||p_internal_trx_flag
225: );*/
226:

Line 227: FND_LOG.String(l_proc_level,

223: ,l_module_prefix||'.'||l_proc_name||'.parameters'
224: ,'p_internal_trx_flag '||p_internal_trx_flag
225: );*/
226:
227: FND_LOG.String(l_proc_level,
228: l_module_prefix || '.' || l_proc_name || '.parameters',
229: 'p_xml_template_language ' || p_xml_template_language);
230:
231: FND_LOG.String(l_proc_level,

Line 231: FND_LOG.String(l_proc_level,

227: FND_LOG.String(l_proc_level,
228: l_module_prefix || '.' || l_proc_name || '.parameters',
229: 'p_xml_template_language ' || p_xml_template_language);
230:
231: FND_LOG.String(l_proc_level,
232: l_module_prefix || '.' || l_proc_name || '.parameters',
233: 'p_xml_template_territory ' ||
234: p_xml_template_territory);
235:

Line 236: FND_LOG.String(l_proc_level,

232: l_module_prefix || '.' || l_proc_name || '.parameters',
233: 'p_xml_template_territory ' ||
234: p_xml_template_territory);
235:
236: FND_LOG.String(l_proc_level,
237: l_module_prefix || '.' || l_proc_name || '.parameters',
238: 'p_xml_output_format ' || p_xml_output_format);
239:
240: FND_LOG.String(l_proc_level,

Line 240: FND_LOG.String(l_proc_level,

236: FND_LOG.String(l_proc_level,
237: l_module_prefix || '.' || l_proc_name || '.parameters',
238: 'p_xml_output_format ' || p_xml_output_format);
239:
240: FND_LOG.String(l_proc_level,
241: l_module_prefix || '.' || l_proc_name || '.parameters',
242: 'p_source_charset ' || p_source_charset);
243:
244: FND_LOG.String(l_proc_level,

Line 244: FND_LOG.String(l_proc_level,

240: FND_LOG.String(l_proc_level,
241: l_module_prefix || '.' || l_proc_name || '.parameters',
242: 'p_source_charset ' || p_source_charset);
243:
244: FND_LOG.String(l_proc_level,
245: l_module_prefix || '.' || l_proc_name || '.parameters',
246: 'p_destination_charset ' || p_destination_charset);
247:
248: FND_LOG.String(l_proc_level,

Line 248: FND_LOG.String(l_proc_level,

244: FND_LOG.String(l_proc_level,
245: l_module_prefix || '.' || l_proc_name || '.parameters',
246: 'p_destination_charset ' || p_destination_charset);
247:
248: FND_LOG.String(l_proc_level,
249: l_module_prefix || '.' || l_proc_name || '.parameters',
250: 'p_source_separator ' || p_source_separator);
251:
252: FND_LOG.String(l_proc_level,

Line 252: FND_LOG.String(l_proc_level,

248: FND_LOG.String(l_proc_level,
249: l_module_prefix || '.' || l_proc_name || '.parameters',
250: 'p_source_separator ' || p_source_separator);
251:
252: FND_LOG.String(l_proc_level,
253: l_module_prefix || '.' || l_proc_name || '.parameters',
254: 'p_destination_filename ' || p_destination_filename);
255: END IF; --(l_proc_level >= l_dbg_level)
256:

Line 317: FND_LOG.STRING(l_proc_level,

313:
314: END IF; --JA_CN_UTILITY.Check_Profile
315: --log for debug
316: IF (l_proc_level >= l_dbg_level) THEN
317: FND_LOG.STRING(l_proc_level,
318: l_module_prefix || '.' || l_proc_name || '.end',
319: 'Exit procedure');
320: END IF; --( l_proc_level >= l_dbg_level )
321:

Line 325: FND_LOG.String(l_proc_level,

321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: IF (l_proc_level >= l_dbg_level) THEN
325: FND_LOG.String(l_proc_level,
326: l_module_prefix || '.' || l_proc_name ||
327: '. Other_Exception ',
328: SQLCODE || ':' || SQLERRM);
329: END IF; --(l_proc_level >= l_dbg_level)

Line 384: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

380: ,p_coa IN NUMBER
381: ,p_segment_override IN VARCHAR2 -- Added for CNAO Enhancement
382: ) IS
383: l_error_status BOOLEAN;
384: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
385: l_proc_level NUMBER := FND_LOG.Level_Procedure;
386: l_proc_name VARCHAR2(100) := 'Cfs_Calculate';
387:
388: BEGIN

Line 385: l_proc_level NUMBER := FND_LOG.Level_Procedure;

381: ,p_segment_override IN VARCHAR2 -- Added for CNAO Enhancement
382: ) IS
383: l_error_status BOOLEAN;
384: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
385: l_proc_level NUMBER := FND_LOG.Level_Procedure;
386: l_proc_name VARCHAR2(100) := 'Cfs_Calculate';
387:
388: BEGIN
389:

Line 392: FND_LOG.String(l_proc_level,

388: BEGIN
389:
390: --log for debug
391: IF (l_proc_level >= l_dbg_level) THEN
392: FND_LOG.String(l_proc_level,
393: l_module_prefix || '.' || l_proc_name || '.begin',
394: 'Enter procedure');
395:
396: FND_LOG.String(l_proc_level,

Line 396: FND_LOG.String(l_proc_level,

392: FND_LOG.String(l_proc_level,
393: l_module_prefix || '.' || l_proc_name || '.begin',
394: 'Enter procedure');
395:
396: FND_LOG.String(l_proc_level,
397: l_module_prefix || '.' || l_proc_name || '.parameters',
398: 'p_legal_entity_id ' || p_legal_entity_id);
399:
400: FND_LOG.String(l_proc_level,

Line 400: FND_LOG.String(l_proc_level,

396: FND_LOG.String(l_proc_level,
397: l_module_prefix || '.' || l_proc_name || '.parameters',
398: 'p_legal_entity_id ' || p_legal_entity_id);
399:
400: FND_LOG.String(l_proc_level,
401: l_module_prefix || '.' || l_proc_name || '.parameters',
402: 'p_ledger_id ' || p_ledger_id);
403:
404: FND_LOG.String(l_proc_level,

Line 404: FND_LOG.String(l_proc_level,

400: FND_LOG.String(l_proc_level,
401: l_module_prefix || '.' || l_proc_name || '.parameters',
402: 'p_ledger_id ' || p_ledger_id);
403:
404: FND_LOG.String(l_proc_level,
405: l_module_prefix || '.' || l_proc_name || '.parameters',
406: 'p_period_name ' || p_period_name);
407:
408: FND_LOG.String(l_proc_level,

Line 408: FND_LOG.String(l_proc_level,

404: FND_LOG.String(l_proc_level,
405: l_module_prefix || '.' || l_proc_name || '.parameters',
406: 'p_period_name ' || p_period_name);
407:
408: FND_LOG.String(l_proc_level,
409: l_module_prefix || '.' || l_proc_name || '.parameters',
410: 'p_axis_set_id ' || p_axis_set_id);
411:
412: FND_LOG.String(l_proc_level,

Line 412: FND_LOG.String(l_proc_level,

408: FND_LOG.String(l_proc_level,
409: l_module_prefix || '.' || l_proc_name || '.parameters',
410: 'p_axis_set_id ' || p_axis_set_id);
411:
412: FND_LOG.String(l_proc_level,
413: l_module_prefix || '.' || l_proc_name || '.parameters',
414: 'p_rounding_option ' || p_rounding_option);
415:
416: FND_LOG.String(l_proc_level,

Line 416: FND_LOG.String(l_proc_level,

412: FND_LOG.String(l_proc_level,
413: l_module_prefix || '.' || l_proc_name || '.parameters',
414: 'p_rounding_option ' || p_rounding_option);
415:
416: FND_LOG.String(l_proc_level,
417: l_module_prefix || '.' || l_proc_name || '.parameters',
418: 'p_balance_type ' || p_balance_type);
419:
420: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

Line 420: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

416: FND_LOG.String(l_proc_level,
417: l_module_prefix || '.' || l_proc_name || '.parameters',
418: 'p_balance_type ' || p_balance_type);
419:
420: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
421: l_module_prefix || '.' || l_proc_name || '.parameters',
422: 'p_segmment_override ' || p_segment_override);
423:
424: /* FND_LOG.String(l_proc_level

Line 424: /* FND_LOG.String(l_proc_level

420: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
421: l_module_prefix || '.' || l_proc_name || '.parameters',
422: 'p_segmment_override ' || p_segment_override);
423:
424: /* FND_LOG.String(l_proc_level
425: ,l_module_prefix||'.'||l_proc_name||'.parameters'
426: ,'p_internal_trx_flag '||p_internal_trx_flag
427: );*/
428:

Line 456: FND_LOG.STRING(l_proc_level,

452: END IF; --JA_CN_UTILITY.Check_Profile
453:
454: --log for debug
455: IF (l_proc_level >= l_dbg_level) THEN
456: FND_LOG.STRING(l_proc_level,
457: l_module_prefix || '.' || l_proc_name || '.end',
458: 'Exit procedure');
459: END IF; --( l_proc_level >= l_dbg_level )
460:

Line 464: FND_LOG.String(l_proc_level,

460:
461: EXCEPTION
462: WHEN OTHERS THEN
463: IF (l_proc_level >= l_dbg_level) THEN
464: FND_LOG.String(l_proc_level,
465: l_module_prefix || '.' || l_proc_name ||
466: '. Other_Exception ',
467: SQLCODE || ':' || SQLERRM);
468: END IF; --(l_proc_level >= l_dbg_level)

Line 562: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

558: l_flag NUMBER;
559: l_error_flag VARCHAR2(1) := 'N';
560: l_error_status BOOLEAN;
561:
562: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
563: l_proc_level NUMBER := FND_LOG.Level_Procedure;
564: l_proc_name VARCHAR2(100) := 'Cfsse_Generate';
565:
566: BEGIN

Line 563: l_proc_level NUMBER := FND_LOG.Level_Procedure;

559: l_error_flag VARCHAR2(1) := 'N';
560: l_error_status BOOLEAN;
561:
562: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
563: l_proc_level NUMBER := FND_LOG.Level_Procedure;
564: l_proc_name VARCHAR2(100) := 'Cfsse_Generate';
565:
566: BEGIN
567: --log for debug

Line 570: FND_LOG.String(l_proc_level,

566: BEGIN
567: --log for debug
568: IF (l_proc_level >= l_dbg_level)
569: THEN
570: FND_LOG.String(l_proc_level,
571: l_module_prefix || '.' || l_proc_name || '.begin',
572: 'Enter procedure');
573:
574: FND_LOG.String(l_proc_level,

Line 574: FND_LOG.String(l_proc_level,

570: FND_LOG.String(l_proc_level,
571: l_module_prefix || '.' || l_proc_name || '.begin',
572: 'Enter procedure');
573:
574: FND_LOG.String(l_proc_level,
575: l_module_prefix || '.' || l_proc_name || '.parameters',
576: 'p_legal_entity_id ' || p_legal_entity_id);
577:
578: FND_LOG.String(l_proc_level,

Line 578: FND_LOG.String(l_proc_level,

574: FND_LOG.String(l_proc_level,
575: l_module_prefix || '.' || l_proc_name || '.parameters',
576: 'p_legal_entity_id ' || p_legal_entity_id);
577:
578: FND_LOG.String(l_proc_level,
579: l_module_prefix || '.' || l_proc_name || '.parameters',
580: 'p_ledger_id ' || p_ledger_id);
581:
582: FND_LOG.String(l_proc_level,

Line 582: FND_LOG.String(l_proc_level,

578: FND_LOG.String(l_proc_level,
579: l_module_prefix || '.' || l_proc_name || '.parameters',
580: 'p_ledger_id ' || p_ledger_id);
581:
582: FND_LOG.String(l_proc_level,
583: l_module_prefix || '.' || l_proc_name || '.parameters',
584: 'p_coa_id ' || p_coa_id);
585:
586: FND_LOG.String(l_proc_level,

Line 586: FND_LOG.String(l_proc_level,

582: FND_LOG.String(l_proc_level,
583: l_module_prefix || '.' || l_proc_name || '.parameters',
584: 'p_coa_id ' || p_coa_id);
585:
586: FND_LOG.String(l_proc_level,
587: l_module_prefix || '.' || l_proc_name || '.parameters',
588: 'p_adhoc_prefix ' || p_adhoc_prefix);
589:
590: FND_LOG.String(l_proc_level,

Line 590: FND_LOG.String(l_proc_level,

586: FND_LOG.String(l_proc_level,
587: l_module_prefix || '.' || l_proc_name || '.parameters',
588: 'p_adhoc_prefix ' || p_adhoc_prefix);
589:
590: FND_LOG.String(l_proc_level,
591: l_module_prefix || '.' || l_proc_name || '.parameters',
592: 'p_industry ' || p_industry);
593:
594: FND_LOG.String(l_proc_level,

Line 594: FND_LOG.String(l_proc_level,

590: FND_LOG.String(l_proc_level,
591: l_module_prefix || '.' || l_proc_name || '.parameters',
592: 'p_industry ' || p_industry);
593:
594: FND_LOG.String(l_proc_level,
595: l_module_prefix || '.' || l_proc_name || '.parameters',
596: 'p_id_flex_code ' || p_id_flex_code);
597:
598: FND_LOG.String(l_proc_level,

Line 598: FND_LOG.String(l_proc_level,

594: FND_LOG.String(l_proc_level,
595: l_module_prefix || '.' || l_proc_name || '.parameters',
596: 'p_id_flex_code ' || p_id_flex_code);
597:
598: FND_LOG.String(l_proc_level,
599: l_module_prefix || '.' || l_proc_name || '.parameters',
600: 'p_report_id ' || p_report_id);
601:
602: FND_LOG.String(l_proc_level,

Line 602: FND_LOG.String(l_proc_level,

598: FND_LOG.String(l_proc_level,
599: l_module_prefix || '.' || l_proc_name || '.parameters',
600: 'p_report_id ' || p_report_id);
601:
602: FND_LOG.String(l_proc_level,
603: l_module_prefix || '.' || l_proc_name || '.parameters',
604: 'p_period_name ' || p_period_name);
605:
606: FND_LOG.String(l_proc_level,

Line 606: FND_LOG.String(l_proc_level,

602: FND_LOG.String(l_proc_level,
603: l_module_prefix || '.' || l_proc_name || '.parameters',
604: 'p_period_name ' || p_period_name);
605:
606: FND_LOG.String(l_proc_level,
607: l_module_prefix || '.' || l_proc_name || '.parameters',
608: 'p_axis_set_id ' || p_axis_set_id);
609:
610: FND_LOG.String(l_proc_level,

Line 610: FND_LOG.String(l_proc_level,

606: FND_LOG.String(l_proc_level,
607: l_module_prefix || '.' || l_proc_name || '.parameters',
608: 'p_axis_set_id ' || p_axis_set_id);
609:
610: FND_LOG.String(l_proc_level,
611: l_module_prefix || '.' || l_proc_name || '.parameters',
612: 'p_colset_id ' || p_colset_id);
613:
614: FND_LOG.String(l_proc_level,

Line 614: FND_LOG.String(l_proc_level,

610: FND_LOG.String(l_proc_level,
611: l_module_prefix || '.' || l_proc_name || '.parameters',
612: 'p_colset_id ' || p_colset_id);
613:
614: FND_LOG.String(l_proc_level,
615: l_module_prefix || '.' || l_proc_name || '.parameters',
616: 'p_rounding_option ' || p_rounding_option);
617:
618: FND_LOG.String(l_proc_level,

Line 618: FND_LOG.String(l_proc_level,

614: FND_LOG.String(l_proc_level,
615: l_module_prefix || '.' || l_proc_name || '.parameters',
616: 'p_rounding_option ' || p_rounding_option);
617:
618: FND_LOG.String(l_proc_level,
619: l_module_prefix || '.' || l_proc_name || '.parameters',
620: 'p_segment_override ' || p_segment_override);
621:
622: FND_LOG.String(l_proc_level,

Line 622: FND_LOG.String(l_proc_level,

618: FND_LOG.String(l_proc_level,
619: l_module_prefix || '.' || l_proc_name || '.parameters',
620: 'p_segment_override ' || p_segment_override);
621:
622: FND_LOG.String(l_proc_level,
623: l_module_prefix || '.' || l_proc_name || '.parameters',
624: 'p_accounting_date ' || p_accounting_date);
625:
626: FND_LOG.String(l_proc_level,

Line 626: FND_LOG.String(l_proc_level,

622: FND_LOG.String(l_proc_level,
623: l_module_prefix || '.' || l_proc_name || '.parameters',
624: 'p_accounting_date ' || p_accounting_date);
625:
626: FND_LOG.String(l_proc_level,
627: l_module_prefix || '.' || l_proc_name || '.parameters',
628: 'p_parameter_set_id ' || p_parameter_set_id);
629:
630: FND_LOG.String(l_proc_level,

Line 630: FND_LOG.String(l_proc_level,

626: FND_LOG.String(l_proc_level,
627: l_module_prefix || '.' || l_proc_name || '.parameters',
628: 'p_parameter_set_id ' || p_parameter_set_id);
629:
630: FND_LOG.String(l_proc_level,
631: l_module_prefix || '.' || l_proc_name || '.parameters',
632: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
633:
634: FND_LOG.String(l_proc_level,

Line 634: FND_LOG.String(l_proc_level,

630: FND_LOG.String(l_proc_level,
631: l_module_prefix || '.' || l_proc_name || '.parameters',
632: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
633:
634: FND_LOG.String(l_proc_level,
635: l_module_prefix || '.' || l_proc_name || '.parameters',
636: 'p_balance_type ' || p_balance_type);
637:
638: /* FND_LOG.String(l_proc_level

Line 638: /* FND_LOG.String(l_proc_level

634: FND_LOG.String(l_proc_level,
635: l_module_prefix || '.' || l_proc_name || '.parameters',
636: 'p_balance_type ' || p_balance_type);
637:
638: /* FND_LOG.String(l_proc_level
639: ,l_module_prefix||'.'||l_proc_name||'.parameters'
640: ,'p_internal_trx_flag '||p_internal_trx_flag
641: );*/
642:

Line 643: FND_LOG.String(l_proc_level,

639: ,l_module_prefix||'.'||l_proc_name||'.parameters'
640: ,'p_internal_trx_flag '||p_internal_trx_flag
641: );*/
642:
643: FND_LOG.String(l_proc_level,
644: l_module_prefix || '.' || l_proc_name || '.parameters',
645: 'p_xml_template_language ' || p_xml_template_language);
646:
647: FND_LOG.String(l_proc_level,

Line 647: FND_LOG.String(l_proc_level,

643: FND_LOG.String(l_proc_level,
644: l_module_prefix || '.' || l_proc_name || '.parameters',
645: 'p_xml_template_language ' || p_xml_template_language);
646:
647: FND_LOG.String(l_proc_level,
648: l_module_prefix || '.' || l_proc_name || '.parameters',
649: 'p_xml_template_territory ' ||
650: p_xml_template_territory);
651:

Line 652: FND_LOG.String(l_proc_level,

648: l_module_prefix || '.' || l_proc_name || '.parameters',
649: 'p_xml_template_territory ' ||
650: p_xml_template_territory);
651:
652: FND_LOG.String(l_proc_level,
653: l_module_prefix || '.' || l_proc_name || '.parameters',
654: 'p_xml_output_format ' || p_xml_output_format);
655:
656: FND_LOG.String(l_proc_level,

Line 656: FND_LOG.String(l_proc_level,

652: FND_LOG.String(l_proc_level,
653: l_module_prefix || '.' || l_proc_name || '.parameters',
654: 'p_xml_output_format ' || p_xml_output_format);
655:
656: FND_LOG.String(l_proc_level,
657: l_module_prefix || '.' || l_proc_name || '.parameters',
658: 'p_source_charset ' || p_source_charset);
659:
660: FND_LOG.String(l_proc_level,

Line 660: FND_LOG.String(l_proc_level,

656: FND_LOG.String(l_proc_level,
657: l_module_prefix || '.' || l_proc_name || '.parameters',
658: 'p_source_charset ' || p_source_charset);
659:
660: FND_LOG.String(l_proc_level,
661: l_module_prefix || '.' || l_proc_name || '.parameters',
662: 'p_destination_charset ' || p_destination_charset);
663:
664: FND_LOG.String(l_proc_level,

Line 664: FND_LOG.String(l_proc_level,

660: FND_LOG.String(l_proc_level,
661: l_module_prefix || '.' || l_proc_name || '.parameters',
662: 'p_destination_charset ' || p_destination_charset);
663:
664: FND_LOG.String(l_proc_level,
665: l_module_prefix || '.' || l_proc_name || '.parameters',
666: 'p_source_separator ' || p_source_separator);
667:
668: FND_LOG.String(l_proc_level,

Line 668: FND_LOG.String(l_proc_level,

664: FND_LOG.String(l_proc_level,
665: l_module_prefix || '.' || l_proc_name || '.parameters',
666: 'p_source_separator ' || p_source_separator);
667:
668: FND_LOG.String(l_proc_level,
669: l_module_prefix || '.' || l_proc_name || '.parameters',
670: 'p_destination_filename ' || p_destination_filename);
671: END IF; --(l_proc_level >= l_dbg_level)
672:

Line 753: FND_LOG.STRING(l_proc_level,

749:
750: --log for debug
751: IF (l_proc_level >= l_dbg_level)
752: THEN
753: FND_LOG.STRING(l_proc_level,
754: l_module_prefix || '.' || l_proc_name || '.end',
755: 'Exit procedure');
756: END IF; --( l_proc_level >= l_dbg_level )
757:

Line 762: FND_LOG.STRING(l_proc_level,

758: EXCEPTION
759: WHEN OTHERS THEN
760: IF (l_proc_level >= l_dbg_level)
761: THEN
762: FND_LOG.STRING(l_proc_level,
763: l_module_prefix || '.' || l_proc_name ||
764: '. Other_Exception ',
765: SQLCODE || ':' || SQLERRM);
766: END IF; --(l_proc_level >= l_dbg_level)

Line 815: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

811: l_flag NUMBER;
812: l_error_flag VARCHAR2(1) := 'N';
813: l_error_status BOOLEAN;
814:
815: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
816: l_proc_level NUMBER := FND_LOG.Level_Procedure;
817: l_proc_name VARCHAR2(100) := 'Cfsse_Calculate';
818:
819: BEGIN

Line 816: l_proc_level NUMBER := FND_LOG.Level_Procedure;

812: l_error_flag VARCHAR2(1) := 'N';
813: l_error_status BOOLEAN;
814:
815: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
816: l_proc_level NUMBER := FND_LOG.Level_Procedure;
817: l_proc_name VARCHAR2(100) := 'Cfsse_Calculate';
818:
819: BEGIN
820: --log for debug

Line 823: FND_LOG.STRING(l_proc_level,

819: BEGIN
820: --log for debug
821: IF (l_proc_level >= l_dbg_level)
822: THEN
823: FND_LOG.STRING(l_proc_level,
824: l_module_prefix || '.' || l_proc_name || '.begin',
825: 'Enter procedure');
826:
827: FND_LOG.STRING(l_proc_level,

Line 827: FND_LOG.STRING(l_proc_level,

823: FND_LOG.STRING(l_proc_level,
824: l_module_prefix || '.' || l_proc_name || '.begin',
825: 'Enter procedure');
826:
827: FND_LOG.STRING(l_proc_level,
828: l_module_prefix || '.' || l_proc_name || '.parameters',
829: 'p_legal_entity_id ' || p_legal_entity_id);
830: FND_LOG.STRING(l_proc_level,
831: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 830: FND_LOG.STRING(l_proc_level,

826:
827: FND_LOG.STRING(l_proc_level,
828: l_module_prefix || '.' || l_proc_name || '.parameters',
829: 'p_legal_entity_id ' || p_legal_entity_id);
830: FND_LOG.STRING(l_proc_level,
831: l_module_prefix || '.' || l_proc_name || '.parameters',
832: 'p_period_name ' || p_period_name);
833:
834: FND_LOG.STRING(l_proc_level,

Line 834: FND_LOG.STRING(l_proc_level,

830: FND_LOG.STRING(l_proc_level,
831: l_module_prefix || '.' || l_proc_name || '.parameters',
832: 'p_period_name ' || p_period_name);
833:
834: FND_LOG.STRING(l_proc_level,
835: l_module_prefix || '.' || l_proc_name || '.parameters',
836: 'p_axis_set_id ' || p_axis_set_id);
837:
838: FND_LOG.STRING(l_proc_level,

Line 838: FND_LOG.STRING(l_proc_level,

834: FND_LOG.STRING(l_proc_level,
835: l_module_prefix || '.' || l_proc_name || '.parameters',
836: 'p_axis_set_id ' || p_axis_set_id);
837:
838: FND_LOG.STRING(l_proc_level,
839: l_module_prefix || '.' || l_proc_name || '.parameters',
840: 'p_rounding_option ' || p_rounding_option);
841:
842: FND_LOG.STRING(l_proc_level,

Line 842: FND_LOG.STRING(l_proc_level,

838: FND_LOG.STRING(l_proc_level,
839: l_module_prefix || '.' || l_proc_name || '.parameters',
840: 'p_rounding_option ' || p_rounding_option);
841:
842: FND_LOG.STRING(l_proc_level,
843: l_module_prefix || '.' || l_proc_name || '.parameters',
844: 'p_balance_type ' || p_balance_type);
845:
846: /* FND_LOG.STRING(l_proc_level,

Line 846: /* FND_LOG.STRING(l_proc_level,

842: FND_LOG.STRING(l_proc_level,
843: l_module_prefix || '.' || l_proc_name || '.parameters',
844: 'p_balance_type ' || p_balance_type);
845:
846: /* FND_LOG.STRING(l_proc_level,
847: l_module_prefix || '.' || l_proc_name || '.parameters',
848: 'p_internal_trx_flag ' || p_internal_trx_flag) ;*/
849: END IF; --(l_proc_level >= l_dbg_level)
850:

Line 904: FND_LOG.STRING(l_proc_level,

900:
901: --log for debug
902: IF (l_proc_level >= l_dbg_level)
903: THEN
904: FND_LOG.STRING(l_proc_level,
905: l_module_prefix || '.' || l_proc_name || '.end',
906: 'Exit procedure');
907: END IF; --( l_proc_level >= l_dbg_level )
908:

Line 913: FND_LOG.STRING(l_proc_level,

909: EXCEPTION
910: WHEN OTHERS THEN
911: IF (l_proc_level >= l_dbg_level)
912: THEN
913: FND_LOG.STRING(l_proc_level,
914: l_module_prefix || '.' || l_proc_name ||
915: '. Other_Exception ',
916: SQLCODE || ':' || SQLERRM);
917: END IF; --(l_proc_level >= l_dbg_level)

Line 954: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

950: p_LEDGER_ID IN NUMBER,
951: P_GL_PERIOD_FROM IN VARCHAR2,
952: P_GL_PERIOD_TO IN VARCHAR2,
953: P_SOURCE IN VARCHAR2) IS
954: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
955: l_proc_level NUMBER := FND_LOG.Level_Procedure;
956: l_proc_name VARCHAR2(100) := 'Collect_Cfs_Data';
957: l_flag VARCHAR2(15); --populate the ledger and the legal entity flag
958:

Line 955: l_proc_level NUMBER := FND_LOG.Level_Procedure;

951: P_GL_PERIOD_FROM IN VARCHAR2,
952: P_GL_PERIOD_TO IN VARCHAR2,
953: P_SOURCE IN VARCHAR2) IS
954: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
955: l_proc_level NUMBER := FND_LOG.Level_Procedure;
956: l_proc_name VARCHAR2(100) := 'Collect_Cfs_Data';
957: l_flag VARCHAR2(15); --populate the ledger and the legal entity flag
958:
959: JA_CN_INVALID_GLPERIOD exception;

Line 971: FND_LOG.String(l_proc_level,

967: l_year_to NUMBER;
968: BEGIN
969: --log for debug
970: IF (l_proc_level >= l_dbg_level) THEN
971: FND_LOG.String(l_proc_level,
972: l_module_prefix || '.' || l_proc_name || '.begin',
973: 'Enter procedure');
974: FND_LOG.String(l_proc_level,
975: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 974: FND_LOG.String(l_proc_level,

970: IF (l_proc_level >= l_dbg_level) THEN
971: FND_LOG.String(l_proc_level,
972: l_module_prefix || '.' || l_proc_name || '.begin',
973: 'Enter procedure');
974: FND_LOG.String(l_proc_level,
975: l_module_prefix || '.' || l_proc_name || '.parameters',
976: 'P_LE_ID ' || P_LE_ID);
977: FND_LOG.String(l_proc_level,
978: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 977: FND_LOG.String(l_proc_level,

973: 'Enter procedure');
974: FND_LOG.String(l_proc_level,
975: l_module_prefix || '.' || l_proc_name || '.parameters',
976: 'P_LE_ID ' || P_LE_ID);
977: FND_LOG.String(l_proc_level,
978: l_module_prefix || '.' || l_proc_name || '.parameters',
979: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
980: FND_LOG.String(l_proc_level,
981: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 980: FND_LOG.String(l_proc_level,

976: 'P_LE_ID ' || P_LE_ID);
977: FND_LOG.String(l_proc_level,
978: l_module_prefix || '.' || l_proc_name || '.parameters',
979: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
980: FND_LOG.String(l_proc_level,
981: l_module_prefix || '.' || l_proc_name || '.parameters',
982: 'P_GL_PERIOD_TO ' || P_GL_PERIOD_TO);
983: FND_LOG.String(l_proc_level,
984: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 983: FND_LOG.String(l_proc_level,

979: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
980: FND_LOG.String(l_proc_level,
981: l_module_prefix || '.' || l_proc_name || '.parameters',
982: 'P_GL_PERIOD_TO ' || P_GL_PERIOD_TO);
983: FND_LOG.String(l_proc_level,
984: l_module_prefix || '.' || l_proc_name || '.parameters',
985: 'P_SOURCE ' || P_SOURCE);
986: END IF; --(l_proc_level >= l_dbg_level)
987:

Line 1029: FND_LOG.String(l_proc_level,

1025: END IF;
1026:
1027: --log for debug
1028: IF (l_proc_level >= l_dbg_level) THEN
1029: FND_LOG.String(l_proc_level,
1030: l_module_prefix || '.' || l_proc_name || '.end',
1031: 'Exit procedure');
1032: END IF; --(l_proc_level >= l_dbg_level)
1033: ELSE

Line 1042: FND_LOG.String(l_proc_level,

1038: FND_MESSAGE.Set_Name(APPLICATION => 'JA',
1039: NAME => 'JA_CN_INVALID_GLPERIOD');
1040: l_msg_invalid_glperiod := FND_MESSAGE.Get;
1041: IF (l_proc_level >= l_dbg_level) THEN
1042: FND_LOG.String(l_proc_level,
1043: l_module_prefix || '.' || l_proc_name ||
1044: '.JA_CN_INVALID_GLPERIOD ',
1045: l_msg_invalid_glperiod);
1046: END IF; --(l_proc_level >= l_dbg_level)

Line 1051: FND_LOG.String(l_proc_level,

1047: retcode := 1;
1048: errbuf := l_msg_invalid_glperiod;
1049: WHEN OTHERS THEN
1050: IF (l_proc_level >= l_dbg_level) THEN
1051: FND_LOG.String(l_proc_level,
1052: l_module_prefix || '.' || l_proc_name ||
1053: '.Other_Exception ',
1054: SQLCODE || ':' || SQLERRM);
1055: END IF; --(l_proc_level >= l_dbg_level)

Line 1102: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

1098: P_SOURCE IN VARCHAR2,
1099: P_JOURNAL_CTG IN VARCHAR2,
1100: P_STATUS IN VARCHAR2,
1101: P_COM_SEG IN VARCHAR2) IS --Added for CNAO Enhancement
1102: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1103: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1104: l_proc_name VARCHAR2(100) := 'GL_Validation';
1105:
1106: BEGIN

Line 1103: l_proc_level NUMBER := FND_LOG.Level_Procedure;

1099: P_JOURNAL_CTG IN VARCHAR2,
1100: P_STATUS IN VARCHAR2,
1101: P_COM_SEG IN VARCHAR2) IS --Added for CNAO Enhancement
1102: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1103: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1104: l_proc_name VARCHAR2(100) := 'GL_Validation';
1105:
1106: BEGIN
1107: --log for debug

Line 1109: FND_LOG.String(l_proc_level,

1105:
1106: BEGIN
1107: --log for debug
1108: IF (l_proc_level >= l_dbg_level) THEN
1109: FND_LOG.String(l_proc_level,
1110: l_module_prefix || '.' || l_proc_name || '.begin',
1111: 'Enter procedure');
1112: FND_LOG.String(l_proc_level,
1113: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1112: FND_LOG.String(l_proc_level,

1108: IF (l_proc_level >= l_dbg_level) THEN
1109: FND_LOG.String(l_proc_level,
1110: l_module_prefix || '.' || l_proc_name || '.begin',
1111: 'Enter procedure');
1112: FND_LOG.String(l_proc_level,
1113: l_module_prefix || '.' || l_proc_name || '.parameters',
1114: 'P_COA_ID ' || P_COA_ID);
1115: FND_LOG.String(l_proc_level,
1116: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1115: FND_LOG.String(l_proc_level,

1111: 'Enter procedure');
1112: FND_LOG.String(l_proc_level,
1113: l_module_prefix || '.' || l_proc_name || '.parameters',
1114: 'P_COA_ID ' || P_COA_ID);
1115: FND_LOG.String(l_proc_level,
1116: l_module_prefix || '.' || l_proc_name || '.parameters',
1117: 'P_LE_ID ' || P_LE_ID);
1118: FND_LOG.String(l_proc_level,
1119: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1118: FND_LOG.String(l_proc_level,

1114: 'P_COA_ID ' || P_COA_ID);
1115: FND_LOG.String(l_proc_level,
1116: l_module_prefix || '.' || l_proc_name || '.parameters',
1117: 'P_LE_ID ' || P_LE_ID);
1118: FND_LOG.String(l_proc_level,
1119: l_module_prefix || '.' || l_proc_name || '.parameters',
1120: 'P_LEDGER_ID ' || P_LEDGER_ID);
1121: FND_LOG.String(l_proc_level,
1122: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1121: FND_LOG.String(l_proc_level,

1117: 'P_LE_ID ' || P_LE_ID);
1118: FND_LOG.String(l_proc_level,
1119: l_module_prefix || '.' || l_proc_name || '.parameters',
1120: 'P_LEDGER_ID ' || P_LEDGER_ID);
1121: FND_LOG.String(l_proc_level,
1122: l_module_prefix || '.' || l_proc_name || '.parameters',
1123: 'P_START_PERIOD ' || P_START_PERIOD);
1124: FND_LOG.String(l_proc_level,
1125: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1124: FND_LOG.String(l_proc_level,

1120: 'P_LEDGER_ID ' || P_LEDGER_ID);
1121: FND_LOG.String(l_proc_level,
1122: l_module_prefix || '.' || l_proc_name || '.parameters',
1123: 'P_START_PERIOD ' || P_START_PERIOD);
1124: FND_LOG.String(l_proc_level,
1125: l_module_prefix || '.' || l_proc_name || '.parameters',
1126: 'P_END_PERIOD ' || P_END_PERIOD);
1127: FND_LOG.String(l_proc_level,
1128: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1127: FND_LOG.String(l_proc_level,

1123: 'P_START_PERIOD ' || P_START_PERIOD);
1124: FND_LOG.String(l_proc_level,
1125: l_module_prefix || '.' || l_proc_name || '.parameters',
1126: 'P_END_PERIOD ' || P_END_PERIOD);
1127: FND_LOG.String(l_proc_level,
1128: l_module_prefix || '.' || l_proc_name || '.parameters',
1129: 'P_SOURCE ' || P_SOURCE);
1130: FND_LOG.String(l_proc_level,
1131: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1130: FND_LOG.String(l_proc_level,

1126: 'P_END_PERIOD ' || P_END_PERIOD);
1127: FND_LOG.String(l_proc_level,
1128: l_module_prefix || '.' || l_proc_name || '.parameters',
1129: 'P_SOURCE ' || P_SOURCE);
1130: FND_LOG.String(l_proc_level,
1131: l_module_prefix || '.' || l_proc_name || '.parameters',
1132: 'P_JOURNAL_CTG ' || P_JOURNAL_CTG);
1133: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1134: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1133: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

1129: 'P_SOURCE ' || P_SOURCE);
1130: FND_LOG.String(l_proc_level,
1131: l_module_prefix || '.' || l_proc_name || '.parameters',
1132: 'P_JOURNAL_CTG ' || P_JOURNAL_CTG);
1133: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1134: l_module_prefix || '.' || l_proc_name || '.parameters',
1135: 'P_COM_SEG ' || P_COM_SEG);
1136: FND_LOG.String(l_proc_level,
1137: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1136: FND_LOG.String(l_proc_level,

1132: 'P_JOURNAL_CTG ' || P_JOURNAL_CTG);
1133: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1134: l_module_prefix || '.' || l_proc_name || '.parameters',
1135: 'P_COM_SEG ' || P_COM_SEG);
1136: FND_LOG.String(l_proc_level,
1137: l_module_prefix || '.' || l_proc_name || '.parameters',
1138: 'P_STATUS ' || P_STATUS);
1139: END IF; --(l_proc_level >= l_dbg_level)
1140:

Line 1163: FND_LOG.String(l_proc_level,

1159: P_COM_SEG => P_COM_SEG); --Added for CNAO Enhancement
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: IF (l_proc_level >= l_dbg_level) THEN
1163: FND_LOG.String(l_proc_level,
1164: l_module_prefix || '.' || l_proc_name ||
1165: '.Other_Exception ',
1166: SQLCODE || ':' || SQLERRM);
1167: END IF; --(l_proc_level >= l_dbg_level)

Line 1211: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

1207: P_END_PERIOD IN VARCHAR2,
1208: P_STATUS IN VARCHAR2,
1209: P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
1210: ) IS
1211: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1212: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1213: l_proc_name VARCHAR2(100) := 'GL_Validation';
1214:
1215: BEGIN

Line 1212: l_proc_level NUMBER := FND_LOG.Level_Procedure;

1208: P_STATUS IN VARCHAR2,
1209: P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
1210: ) IS
1211: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1212: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1213: l_proc_name VARCHAR2(100) := 'GL_Validation';
1214:
1215: BEGIN
1216: --log for debug

Line 1218: FND_LOG.String(l_proc_level,

1214:
1215: BEGIN
1216: --log for debug
1217: IF (l_proc_level >= l_dbg_level) THEN
1218: FND_LOG.String(l_proc_level,
1219: l_module_prefix || '.' || l_proc_name || '.begin',
1220: 'Enter procedure');
1221: FND_LOG.String(l_proc_level,
1222: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1221: FND_LOG.String(l_proc_level,

1217: IF (l_proc_level >= l_dbg_level) THEN
1218: FND_LOG.String(l_proc_level,
1219: l_module_prefix || '.' || l_proc_name || '.begin',
1220: 'Enter procedure');
1221: FND_LOG.String(l_proc_level,
1222: l_module_prefix || '.' || l_proc_name || '.parameters',
1223: 'P_COA_ID ' || P_COA_ID);
1224: FND_LOG.String(l_proc_level,
1225: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1224: FND_LOG.String(l_proc_level,

1220: 'Enter procedure');
1221: FND_LOG.String(l_proc_level,
1222: l_module_prefix || '.' || l_proc_name || '.parameters',
1223: 'P_COA_ID ' || P_COA_ID);
1224: FND_LOG.String(l_proc_level,
1225: l_module_prefix || '.' || l_proc_name || '.parameters',
1226: 'P_LE_ID ' || P_LE_ID);
1227: FND_LOG.String(l_proc_level,
1228: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1227: FND_LOG.String(l_proc_level,

1223: 'P_COA_ID ' || P_COA_ID);
1224: FND_LOG.String(l_proc_level,
1225: l_module_prefix || '.' || l_proc_name || '.parameters',
1226: 'P_LE_ID ' || P_LE_ID);
1227: FND_LOG.String(l_proc_level,
1228: l_module_prefix || '.' || l_proc_name || '.parameters',
1229: 'P_LEDGER_ID ' || P_LEDGER_ID);
1230: FND_LOG.String(l_proc_level,
1231: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1230: FND_LOG.String(l_proc_level,

1226: 'P_LE_ID ' || P_LE_ID);
1227: FND_LOG.String(l_proc_level,
1228: l_module_prefix || '.' || l_proc_name || '.parameters',
1229: 'P_LEDGER_ID ' || P_LEDGER_ID);
1230: FND_LOG.String(l_proc_level,
1231: l_module_prefix || '.' || l_proc_name || '.parameters',
1232: 'P_START_PERIOD ' || P_START_PERIOD);
1233: FND_LOG.String(l_proc_level,
1234: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1233: FND_LOG.String(l_proc_level,

1229: 'P_LEDGER_ID ' || P_LEDGER_ID);
1230: FND_LOG.String(l_proc_level,
1231: l_module_prefix || '.' || l_proc_name || '.parameters',
1232: 'P_START_PERIOD ' || P_START_PERIOD);
1233: FND_LOG.String(l_proc_level,
1234: l_module_prefix || '.' || l_proc_name || '.parameters',
1235: 'P_END_PERIOD ' || P_END_PERIOD);
1236: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1237: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1236: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

1232: 'P_START_PERIOD ' || P_START_PERIOD);
1233: FND_LOG.String(l_proc_level,
1234: l_module_prefix || '.' || l_proc_name || '.parameters',
1235: 'P_END_PERIOD ' || P_END_PERIOD);
1236: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1237: l_module_prefix || '.' || l_proc_name || '.parameters',
1238: 'P_COM_SEG ' || P_COM_SEG);
1239: FND_LOG.String(l_proc_level,
1240: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1239: FND_LOG.String(l_proc_level,

1235: 'P_END_PERIOD ' || P_END_PERIOD);
1236: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1237: l_module_prefix || '.' || l_proc_name || '.parameters',
1238: 'P_COM_SEG ' || P_COM_SEG);
1239: FND_LOG.String(l_proc_level,
1240: l_module_prefix || '.' || l_proc_name || '.parameters',
1241: 'P_STATUS ' || P_STATUS);
1242: END IF; --(l_proc_level >= l_dbg_level)
1243:

Line 1265: FND_LOG.String(l_proc_level,

1261: );
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: IF (l_proc_level >= l_dbg_level) THEN
1265: FND_LOG.String(l_proc_level,
1266: l_module_prefix || '.' || l_proc_name ||
1267: '.Other_Exception ',
1268: SQLCODE || ':' || SQLERRM);
1269: END IF; --(l_proc_level >= l_dbg_level)

Line 1371: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

1367: P_SOURCE IN VARCHAR2,
1368: P_BSV IN VARCHAR2) is--Fix Bug#7334017 add
1369:
1370: l_error_status BOOLEAN;
1371: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1372: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1373: l_proc_name VARCHAR2(100) := 'Cfs_Detail_Report';
1374: begin
1375: --log for debug

Line 1372: l_proc_level NUMBER := FND_LOG.Level_Procedure;

1368: P_BSV IN VARCHAR2) is--Fix Bug#7334017 add
1369:
1370: l_error_status BOOLEAN;
1371: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1372: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1373: l_proc_name VARCHAR2(100) := 'Cfs_Detail_Report';
1374: begin
1375: --log for debug
1376: IF (l_proc_level >= l_dbg_level) THEN

Line 1377: FND_LOG.String(l_proc_level,

1373: l_proc_name VARCHAR2(100) := 'Cfs_Detail_Report';
1374: begin
1375: --log for debug
1376: IF (l_proc_level >= l_dbg_level) THEN
1377: FND_LOG.String(l_proc_level,
1378: l_module_prefix || '.' || l_proc_name || '.begin',
1379: 'Enter procedure');
1380: FND_LOG.String(l_proc_level,
1381: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1380: FND_LOG.String(l_proc_level,

1376: IF (l_proc_level >= l_dbg_level) THEN
1377: FND_LOG.String(l_proc_level,
1378: l_module_prefix || '.' || l_proc_name || '.begin',
1379: 'Enter procedure');
1380: FND_LOG.String(l_proc_level,
1381: l_module_prefix || '.' || l_proc_name || '.parameters',
1382: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
1383: FND_LOG.String(l_proc_level,
1384: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1383: FND_LOG.String(l_proc_level,

1379: 'Enter procedure');
1380: FND_LOG.String(l_proc_level,
1381: l_module_prefix || '.' || l_proc_name || '.parameters',
1382: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
1383: FND_LOG.String(l_proc_level,
1384: l_module_prefix || '.' || l_proc_name || '.parameters',
1385: 'P_LEDGER_ID ' || P_LEDGER_ID);
1386: FND_LOG.String(l_proc_level,
1387: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1386: FND_LOG.String(l_proc_level,

1382: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
1383: FND_LOG.String(l_proc_level,
1384: l_module_prefix || '.' || l_proc_name || '.parameters',
1385: 'P_LEDGER_ID ' || P_LEDGER_ID);
1386: FND_LOG.String(l_proc_level,
1387: l_module_prefix || '.' || l_proc_name || '.parameters',
1388: 'P_chart_of_accounts_ID ' || P_chart_of_accounts_ID);
1389:
1390: FND_LOG.String(l_proc_level,

Line 1390: FND_LOG.String(l_proc_level,

1386: FND_LOG.String(l_proc_level,
1387: l_module_prefix || '.' || l_proc_name || '.parameters',
1388: 'P_chart_of_accounts_ID ' || P_chart_of_accounts_ID);
1389:
1390: FND_LOG.String(l_proc_level,
1391: l_module_prefix || '.' || l_proc_name || '.parameters',
1392: 'P_ADHOC_PREFIX ' || p_adhoc_prefix);
1393:
1394: FND_LOG.String(l_proc_level,

Line 1394: FND_LOG.String(l_proc_level,

1390: FND_LOG.String(l_proc_level,
1391: l_module_prefix || '.' || l_proc_name || '.parameters',
1392: 'P_ADHOC_PREFIX ' || p_adhoc_prefix);
1393:
1394: FND_LOG.String(l_proc_level,
1395: l_module_prefix || '.' || l_proc_name || '.parameters',
1396: 'P_INDUSTRY ' || p_industry);
1397:
1398: FND_LOG.String(l_proc_level,

Line 1398: FND_LOG.String(l_proc_level,

1394: FND_LOG.String(l_proc_level,
1395: l_module_prefix || '.' || l_proc_name || '.parameters',
1396: 'P_INDUSTRY ' || p_industry);
1397:
1398: FND_LOG.String(l_proc_level,
1399: l_module_prefix || '.' || l_proc_name || '.parameters',
1400: 'P_ID_FLEX_CODE ' || p_id_flex_code);
1401: FND_LOG.String(l_proc_level,
1402: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1401: FND_LOG.String(l_proc_level,

1397:
1398: FND_LOG.String(l_proc_level,
1399: l_module_prefix || '.' || l_proc_name || '.parameters',
1400: 'P_ID_FLEX_CODE ' || p_id_flex_code);
1401: FND_LOG.String(l_proc_level,
1402: l_module_prefix || '.' || l_proc_name || '.parameters',
1403: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
1404: FND_LOG.String(l_proc_level,
1405: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1404: FND_LOG.String(l_proc_level,

1400: 'P_ID_FLEX_CODE ' || p_id_flex_code);
1401: FND_LOG.String(l_proc_level,
1402: l_module_prefix || '.' || l_proc_name || '.parameters',
1403: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
1404: FND_LOG.String(l_proc_level,
1405: l_module_prefix || '.' || l_proc_name || '.parameters',
1406: 'P_GL_PERIOD_TO' || P_GL_PERIOD_TO);
1407: FND_LOG.String(l_proc_level,
1408: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1407: FND_LOG.String(l_proc_level,

1403: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
1404: FND_LOG.String(l_proc_level,
1405: l_module_prefix || '.' || l_proc_name || '.parameters',
1406: 'P_GL_PERIOD_TO' || P_GL_PERIOD_TO);
1407: FND_LOG.String(l_proc_level,
1408: l_module_prefix || '.' || l_proc_name || '.parameters',
1409: 'P_SOURCE ' || P_SOURCE);
1410: FND_LOG.String(l_proc_level,
1411: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1410: FND_LOG.String(l_proc_level,

1406: 'P_GL_PERIOD_TO' || P_GL_PERIOD_TO);
1407: FND_LOG.String(l_proc_level,
1408: l_module_prefix || '.' || l_proc_name || '.parameters',
1409: 'P_SOURCE ' || P_SOURCE);
1410: FND_LOG.String(l_proc_level,
1411: l_module_prefix || '.' || l_proc_name || '.parameters',
1412: 'P_REPORT_ID ' || P_REPORT_ID);
1413:
1414: END IF; --(l_proc_level >= l_dbg_level)

Line 1446: FND_LOG.STRING(l_proc_level,

1442: END IF; --JA_CN_UTILITY.Check_Profile
1443:
1444: --log for debug
1445: IF (l_proc_level >= l_dbg_level) THEN
1446: FND_LOG.STRING(l_proc_level,
1447: l_module_prefix || '.' || l_proc_name || '.end',
1448: 'Exit procedure');
1449: END IF; --( l_proc_level >= l_dbg_level )
1450:

Line 1454: FND_LOG.String(l_proc_level,

1450:
1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: IF (l_proc_level >= l_dbg_level) THEN
1454: FND_LOG.String(l_proc_level,
1455: l_module_prefix || '.' || l_proc_name ||
1456: '. Other_Exception ',
1457: SQLCODE || ':' || SQLERRM);
1458: END IF; --(l_proc_level >= l_dbg_level)