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_PS_HRMS_EXPORT_PKG dependencies on FND_LOG

Line 481: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

477: , pv_accounting_year IN VARCHAR2
478: )
479: AS
480: lv_procedure_name VARCHAR2(40) := 'Add_Department_Records';
481: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
482: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
483: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
484: lv_error_msg VARCHAR2(2000) := NULL;
485: ln_rec_count NUMBER := 0;

Line 482: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

478: )
479: AS
480: lv_procedure_name VARCHAR2(40) := 'Add_Department_Records';
481: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
482: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
483: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
484: lv_error_msg VARCHAR2(2000) := NULL;
485: ln_rec_count NUMBER := 0;
486: ld_acc_start_date DATE := NULL;

Line 483: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

479: AS
480: lv_procedure_name VARCHAR2(40) := 'Add_Department_Records';
481: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
482: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
483: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
484: lv_error_msg VARCHAR2(2000) := NULL;
485: ln_rec_count NUMBER := 0;
486: ld_acc_start_date DATE := NULL;
487: ld_acc_end_date DATE := NULL;

Line 530: FND_LOG.STRING( ln_proc_level

526: BEGIN
527: --logging for debug
528: IF (ln_proc_level >= ln_dbg_level)
529: THEN
530: FND_LOG.STRING( ln_proc_level
531: , GV_MODULE_PREFIX || '.' || lv_procedure_name
532: || '.begin'
533: , 'Enter procedure');
534: -- logging the parameters

Line 535: FND_LOG.STRING( ln_proc_level

531: , GV_MODULE_PREFIX || '.' || lv_procedure_name
532: || '.begin'
533: , 'Enter procedure');
534: -- logging the parameters
535: FND_LOG.STRING( ln_proc_level
536: , lv_procedure_name || '.parameters'
537: , 'pn_legal_entity_id=' || pn_legal_entity_id || ','
538: || 'pn_ledger_id=' || pn_ledger_id || ','
539: || 'pv_accounting_year=' || pv_accounting_year);

Line 583: FND_LOG.STRING( ln_statement_level

579:
580: --logging the variables
581: IF (ln_statement_level >= ln_dbg_level)
582: THEN
583: FND_LOG.STRING( ln_statement_level
584: , lv_procedure_name
585: , 'ln_rec_count:' || ln_rec_count);
586: END IF; --(ln_statement_level >= ln_dbg_level)
587: FND_FILE.put_line( FND_FILE.log

Line 615: FND_LOG.STRING( ln_proc_level

611: END IF; -- (ln_rec_count = 0)
612: --logging for debug
613: IF (ln_proc_level >= ln_dbg_level)
614: THEN
615: FND_LOG.STRING( ln_proc_level
616: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
617: , 'Exit procedure');
618: END IF; -- (ln_proc_level>=ln_dbg_level)
619:

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

618: END IF; -- (ln_proc_level>=ln_dbg_level)
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
623: THEN
624: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
625: , GV_MODULE_PREFIX || '.' || lv_procedure_name
626: || '.Other_Exception '

Line 624: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
623: THEN
624: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
625: , GV_MODULE_PREFIX || '.' || lv_procedure_name
626: || '.Other_Exception '
627: , SQLCODE || SQLERRM);
628: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

624: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
625: , GV_MODULE_PREFIX || '.' || lv_procedure_name
626: || '.Other_Exception '
627: , SQLCODE || SQLERRM);
628: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
629: FND_FILE.put_line( FND_FILE.log
630: , lv_procedure_name || SQLCODE || SQLERRM);
631: RAISE;
632: END Add_Department_Records;

Line 663: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

659: , pv_accounting_year IN VARCHAR2
660: )
661: AS
662: lv_procedure_name VARCHAR2(40) := 'Add_Employee_Records';
663: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
664: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
665: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
666: lv_error_msg VARCHAR2(2000) := NULL;
667: pd_acc_start_date DATE := NULL;

Line 664: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

660: )
661: AS
662: lv_procedure_name VARCHAR2(40) := 'Add_Employee_Records';
663: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
664: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
665: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
666: lv_error_msg VARCHAR2(2000) := NULL;
667: pd_acc_start_date DATE := NULL;
668: pd_acc_end_date DATE := NULL;

Line 665: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

661: AS
662: lv_procedure_name VARCHAR2(40) := 'Add_Employee_Records';
663: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
664: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
665: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
666: lv_error_msg VARCHAR2(2000) := NULL;
667: pd_acc_start_date DATE := NULL;
668: pd_acc_end_date DATE := NULL;
669: ln_rec_count NUMBER := 0;

Line 743: FND_LOG.STRING( ln_proc_level

739: BEGIN
740: --logging for debug
741: IF (ln_proc_level >= ln_dbg_level)
742: THEN
743: FND_LOG.STRING( ln_proc_level
744: , GV_MODULE_PREFIX || '.' || lv_procedure_name
745: || '.begin'
746: , 'Enter procedure');
747: -- logging the parameters

Line 748: FND_LOG.STRING( ln_proc_level

744: , GV_MODULE_PREFIX || '.' || lv_procedure_name
745: || '.begin'
746: , 'Enter procedure');
747: -- logging the parameters
748: FND_LOG.STRING( ln_proc_level
749: , lv_procedure_name || '.parameters'
750: , 'pn_legal_entity_id=' || pn_legal_entity_id || ','
751: || 'pn_ledger_id=' || pn_ledger_id || ','
752: || 'pv_accounting_year=' || pv_accounting_year);

Line 856: FND_LOG.STRING( ln_statement_level

852:
853: --logging the variables
854: IF (ln_statement_level >= ln_dbg_level)
855: THEN
856: FND_LOG.STRING( ln_statement_level
857: , lv_procedure_name
858: , 'ln_rec_count:' || ln_rec_count);
859: END IF; --(ln_statement_level >= ln_dbg_level)
860: FND_FILE.put_line( FND_FILE.log

Line 926: FND_LOG.STRING( ln_proc_level

922:
923: --logging for debug
924: IF (ln_proc_level >= ln_dbg_level)
925: THEN
926: FND_LOG.STRING( ln_proc_level
927: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
928: , 'Exit procedure');
929: END IF; -- (ln_proc_level>=ln_dbg_level)
930:

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

929: END IF; -- (ln_proc_level>=ln_dbg_level)
930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
934: THEN
935: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
936: , GV_MODULE_PREFIX || '.' || lv_procedure_name
937: || '.Other_Exception '

Line 935: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

931: EXCEPTION
932: WHEN OTHERS THEN
933: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
934: THEN
935: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
936: , GV_MODULE_PREFIX || '.' || lv_procedure_name
937: || '.Other_Exception '
938: , SQLCODE || SQLERRM);
939: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

935: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
936: , GV_MODULE_PREFIX || '.' || lv_procedure_name
937: || '.Other_Exception '
938: , SQLCODE || SQLERRM);
939: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
940: FND_FILE.put_line( FND_FILE.log
941: , lv_procedure_name || SQLCODE || SQLERRM);
942: RAISE;
943:

Line 974: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

970: , pv_accounting_year IN VARCHAR2
971: )
972: IS
973: lv_procedure_name VARCHAR2(30) := 'Add_Employee_Category';
974: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
975: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
976: ln_row_count NUMBER := 0;
977: ld_acc_start_date DATE;
978: ld_acc_end_date DATE;

Line 975: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

971: )
972: IS
973: lv_procedure_name VARCHAR2(30) := 'Add_Employee_Category';
974: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
975: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
976: ln_row_count NUMBER := 0;
977: ld_acc_start_date DATE;
978: ld_acc_end_date DATE;
979:

Line 1015: FND_LOG.STRING( ln_proc_level

1011: BEGIN
1012: --logging for debug
1013: IF (ln_proc_level >= ln_dbg_level)
1014: THEN
1015: FND_LOG.STRING( ln_proc_level
1016: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
1017: , 'Enter procedure');
1018: FND_LOG.STRING( ln_proc_level
1019: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.parameters'

Line 1018: FND_LOG.STRING( ln_proc_level

1014: THEN
1015: FND_LOG.STRING( ln_proc_level
1016: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
1017: , 'Enter procedure');
1018: FND_LOG.STRING( ln_proc_level
1019: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.parameters'
1020: , 'pn_ledger_id=' || pn_ledger_id || ','
1021: || 'pn_legal_entity_id=' || pn_legal_entity_id || ','
1022: || 'pv_accounting_year=' || pv_accounting_year);

Line 1075: FND_LOG.STRING( ln_proc_level

1071: END IF; -- (ln_row_count=0)
1072: --logging for debug
1073: IF (ln_proc_level >= ln_dbg_level)
1074: THEN
1075: FND_LOG.STRING( ln_proc_level
1076: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
1077: , 'Exit procedure');
1078: END IF; -- (ln_proc_level>=ln_dbg_level)
1079: EXCEPTION

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

1077: , 'Exit procedure');
1078: END IF; -- (ln_proc_level>=ln_dbg_level)
1079: EXCEPTION
1080: WHEN OTHERS THEN
1081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1082: THEN
1083: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1084: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1085: || '.Other_Exception '

Line 1083: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1079: EXCEPTION
1080: WHEN OTHERS THEN
1081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1082: THEN
1083: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1084: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1085: || '.Other_Exception '
1086: , SQLCODE || SQLERRM);
1087: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

1083: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1084: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1085: || '.Other_Exception '
1086: , SQLCODE || SQLERRM);
1087: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1088: FND_FILE.put_line( FND_FILE.log
1089: , lv_procedure_name || SQLCODE || SQLERRM );
1090: RAISE;
1091: END Add_Employee_Category;