eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_HRMS_EXPORT_PKG dependencies on FND_LOG

Line 253: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

249: ,pv_accounting_year IN VARCHAR2
250: )
251: IS
252: lv_procedure_name VARCHAR2(40) := 'Add_Department_Records';
253: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
254: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
255: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
256: lv_error_msg VARCHAR2(2000) := NULL;
257: ln_rec_count NUMBER := 0;

Line 254: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

250: )
251: IS
252: lv_procedure_name VARCHAR2(40) := 'Add_Department_Records';
253: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
254: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
255: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
256: lv_error_msg VARCHAR2(2000) := NULL;
257: ln_rec_count NUMBER := 0;
258: pd_acc_start_date DATE := NULL;

Line 255: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

251: IS
252: lv_procedure_name VARCHAR2(40) := 'Add_Department_Records';
253: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
254: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
255: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
256: lv_error_msg VARCHAR2(2000) := NULL;
257: ln_rec_count NUMBER := 0;
258: pd_acc_start_date DATE := NULL;
259: pd_acc_end_date DATE := NULL;

Line 299: FND_LOG.STRING(ln_proc_level,

295: BEGIN
296: --logging for debug
297: IF (ln_proc_level >= ln_dbg_level)
298: THEN
299: FND_LOG.STRING(ln_proc_level,
300: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
301: '.begin',
302: 'Enter procedure');
303: -- logging the parameters

Line 304: FND_LOG.STRING(ln_proc_level,

300: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
301: '.begin',
302: 'Enter procedure');
303: -- logging the parameters
304: FND_LOG.STRING(ln_proc_level,
305: lv_procedure_name ||
306: '.parameters',
307: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
308: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 346: FND_LOG.STRING(ln_statement_level,

342:
343: --logging the variables
344: IF (ln_statement_level >= ln_dbg_level)
345: THEN
346: FND_LOG.STRING(ln_statement_level,
347: lv_procedure_name,
348: 'ln_rec_count:' || ln_rec_count);
349: END IF; --(ln_statement_level >= ln_dbg_level)
350: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 384: FND_LOG.STRING(ln_proc_level,

380: --logging for debug
381:
382: IF (ln_proc_level >= ln_dbg_level)
383: THEN
384: FND_LOG.STRING(ln_proc_level,
385: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
386: 'Exit procedure');
387: END IF; -- (ln_proc_level>=ln_dbg_level)
388:

Line 395: FND_LOG.STRING(ln_proc_level,

391: /* WHEN NO_DATA THEN
392: --logging for debug
393: IF (ln_proc_level >= ln_dbg_level)
394: THEN
395: FND_LOG.STRING(ln_proc_level,
396: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
397: 'exception',
398: 'No data for Department Records');
399: END IF; --ln_proc_level>=ln_dbg_level

Line 404: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

400: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');
401: RAISE;*/
402: --End: Deleted for bug# 9722570
403: WHEN OTHERS THEN
404: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
405: THEN
406: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
407: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
408: '.Other_Exception ',

Line 406: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

402: --End: Deleted for bug# 9722570
403: WHEN OTHERS THEN
404: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
405: THEN
406: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
407: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
408: '.Other_Exception ',
409: SQLCODE || SQLERRM);
410: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 410: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

406: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
407: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
408: '.Other_Exception ',
409: SQLCODE || SQLERRM);
410: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
411: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
412: RAISE;
413:
414: END Add_Department_Records;

Line 447: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

443: ,pv_accounting_year IN VARCHAR2
444: )
445: IS
446: lv_procedure_name VARCHAR2(40) := 'Add_Employee_Records';
447: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
448: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
449: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
450: lv_error_msg VARCHAR2(2000) := NULL;
451: pd_acc_start_date DATE := NULL;

Line 448: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

444: )
445: IS
446: lv_procedure_name VARCHAR2(40) := 'Add_Employee_Records';
447: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
448: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
449: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
450: lv_error_msg VARCHAR2(2000) := NULL;
451: pd_acc_start_date DATE := NULL;
452: pd_acc_end_date DATE := NULL;

Line 449: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

445: IS
446: lv_procedure_name VARCHAR2(40) := 'Add_Employee_Records';
447: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
448: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
449: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
450: lv_error_msg VARCHAR2(2000) := NULL;
451: pd_acc_start_date DATE := NULL;
452: pd_acc_end_date DATE := NULL;
453: ln_rec_count NUMBER := 0;

Line 522: FND_LOG.STRING(ln_proc_level,

518: BEGIN
519: --logging for debug
520: IF (ln_proc_level >= ln_dbg_level)
521: THEN
522: FND_LOG.STRING(ln_proc_level,
523: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
524: '.begin',
525: 'Enter procedure');
526: -- logging the parameters

Line 527: FND_LOG.STRING(ln_proc_level,

523: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
524: '.begin',
525: 'Enter procedure');
526: -- logging the parameters
527: FND_LOG.STRING(ln_proc_level,
528: lv_procedure_name ||
529: '.parameters',
530: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
531: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 596: FND_LOG.STRING(ln_statement_level,

592:
593: --logging the variables
594: IF (ln_statement_level >= ln_dbg_level)
595: THEN
596: FND_LOG.STRING(ln_statement_level,
597: lv_procedure_name,
598: 'ln_rec_count:' || ln_rec_count);
599: END IF; --(ln_statement_level >= ln_dbg_level)
600: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 653: FND_LOG.STRING(ln_proc_level,

649:
650: --logging for debug
651: IF (ln_proc_level >= ln_dbg_level)
652: THEN
653: FND_LOG.STRING(ln_proc_level,
654: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
655: 'Exit procedure');
656: END IF; -- (ln_proc_level>=ln_dbg_level)
657:

Line 664: FND_LOG.STRING(ln_proc_level,

660: /* WHEN NO_DATA THEN
661: --logging for debug
662: IF (ln_proc_level >= ln_dbg_level)
663: THEN
664: FND_LOG.STRING(ln_proc_level,
665: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
666: 'exception',
667: 'No data for Employee Records');
668: END IF; --ln_proc_level>=ln_dbg_level

Line 673: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

669: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');
670: RAISE;*/
671: --End: Deleted for bug# 9722570
672: WHEN OTHERS THEN
673: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
674: THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
676: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
677: '.Other_Exception ',

Line 675: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

671: --End: Deleted for bug# 9722570
672: WHEN OTHERS THEN
673: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
674: THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
676: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
677: '.Other_Exception ',
678: SQLCODE || SQLERRM);
679: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 679: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

675: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
676: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
677: '.Other_Exception ',
678: SQLCODE || SQLERRM);
679: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
680: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
681: RAISE;
682:
683: END Add_Employee_Records;