APPS.JA_CN_COA_EXPORT_PKG dependencies on FND_LOG

Line 198: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

194: ,pv_xml_template_territory IN VARCHAR2
195: ,pv_xml_output_format IN VARCHAR2
196: )
197: IS
198: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
199: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
200: l_proc_name VARCHAR2(100) :='Add_COA';
201:
202: l_coa_id NUMBER := pn_coa_id;

Line 199: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

195: ,pv_xml_output_format IN VARCHAR2
196: )
197: IS
198: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
199: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
200: l_proc_name VARCHAR2(100) :='Add_COA';
201:
202: l_coa_id NUMBER := pn_coa_id;
203: l_ledger_id NUMBER := pn_ledger_id;

Line 265: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

261: l_exceptions_count NUMBER; --count of invalid account rows
262: l_row_count NUMBER; --count of correct account rows
263:
264: lv_procedure_name VARCHAR2(40) := 'Add_COA';
265: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
266: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
267: NO_DATA EXCEPTION;
268: l_msg_no_data_found VARCHAR2(2000);
269:

Line 266: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

262: l_row_count NUMBER; --count of correct account rows
263:
264: lv_procedure_name VARCHAR2(40) := 'Add_COA';
265: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
266: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
267: NO_DATA EXCEPTION;
268: l_msg_no_data_found VARCHAR2(2000);
269:
270: --Cursor to get DFF assignment status of Account Level, Project, Third Party,

Line 340: FND_LOG.STRING(ln_proc_level,

336: BEGIN
337: --logging for debug
338: IF (ln_proc_level >= ln_dbg_level)
339: THEN
340: FND_LOG.STRING(ln_proc_level,
341: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
342: '.begin',
343: 'Enter procedure');
344: -- logging the parameters

Line 345: FND_LOG.STRING(ln_proc_level,

341: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
342: '.begin',
343: 'Enter procedure');
344: -- logging the parameters
345: FND_LOG.STRING(ln_proc_level,
346: lv_procedure_name ||
347: '.parameters',
348: 'pn_coa_id=' || pn_coa_id || ',' ||
349: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 690: FND_LOG.STRING(ln_proc_level,

686:
687: --logging for debug
688: IF (ln_proc_level >= ln_dbg_level)
689: THEN
690: FND_LOG.STRING(ln_proc_level,
691: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
692: 'Exit procedure');
693: END IF; -- (ln_proc_level>=ln_dbg_level)
694:

Line 706: FND_LOG.String( l_proc_level

702:
703: FND_FILE.put_line(FND_FILE.output, l_msg_incomplete_dff_assign);
704: IF (l_proc_level >= l_dbg_level)
705: THEN
706: FND_LOG.String( l_proc_level
707: ,GV_MODULE_PREFIX||'.'||l_proc_name||'.JA_CN_INCOMPLETE_DFF_ASSIGN '
708: ,l_msg_incomplete_dff_assign);
709: END IF;
710: RAISE;

Line 723: FND_LOG.String( l_proc_level

719:
720: FND_FILE.put_line(FND_FILE.output, l_msg_invalid_account_stru);
721: IF (l_proc_level >= l_dbg_level)
722: THEN
723: FND_LOG.String( l_proc_level
724: ,GV_MODULE_PREFIX||'.'||l_proc_name||'.JA_CN_INVALID_ACCOUNT_STRU '
725: ,l_msg_invalid_account_stru);
726: END IF;
727: RAISE;

Line 733: FND_LOG.String( l_proc_level

729: WHEN OTHERS
730: THEN
731: IF (l_proc_level >= l_dbg_level)
732: THEN
733: FND_LOG.String( l_proc_level
734: ,GV_MODULE_PREFIX||'.'||l_proc_name||'.Other_Exception '
735: ,SQLCODE||':'||SQLERRM);
736: END IF; --(l_proc_level >= l_dbg_level)
737: RAISE;