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.IGF_AW_GEN_004 dependencies on FND_LOG

Line 230: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

226: --Change History:
227: --Who When What
228: ------------------------------------------------------------------
229: BEGIN
230: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
231: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_gen_004.'||p_v_module||'.'||p_v_log_category, p_v_string);
232: END IF;
233: END log_to_fnd;
234:

Line 231: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_gen_004.'||p_v_module||'.'||p_v_log_category, p_v_string);

227: --Who When What
228: ------------------------------------------------------------------
229: BEGIN
230: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
231: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_gen_004.'||p_v_module||'.'||p_v_log_category, p_v_string);
232: END IF;
233: END log_to_fnd;
234:
235:

Line 786: -- IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

782:
783: l_header_rec := l_header_rec || 'Award Total';
784: -- Award Types is there in the select query hence not required here.
785:
786: -- IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
787: -- fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.get_headings.debug.Header',l_header_rec);
788: -- END IF;
789:
790: RETURN l_header_rec;

Line 787: -- fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.get_headings.debug.Header',l_header_rec);

783: l_header_rec := l_header_rec || 'Award Total';
784: -- Award Types is there in the select query hence not required here.
785:
786: -- IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
787: -- fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.get_headings.debug.Header',l_header_rec);
788: -- END IF;
789:
790: RETURN l_header_rec;
791:

Line 1356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1352: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1353:
1354: BEGIN
1355:
1356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Document Name '|| NVL(p_document_id , -99));
1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));
1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));

Line 1357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Document Name '|| NVL(p_document_id , -99));

1353:
1354: BEGIN
1355:
1356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Document Name '|| NVL(p_document_id , -99));
1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));
1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));

Line 1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));

1354: BEGIN
1355:
1356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Document Name '|| NVL(p_document_id , -99));
1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));
1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));

Line 1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));

1355:
1356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Document Name '|| NVL(p_document_id , -99));
1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));
1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));

Line 1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));

1356: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Document Name '|| NVL(p_document_id , -99));
1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));
1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));

Line 1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));

1357: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Document Name '|| NVL(p_document_id , -99));
1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));
1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));

Line 1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));

1358: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Selection Criteria '|| NVL(p_select_type , 'NULL'));
1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));

Line 1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));

1359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_sys_ltr_code, 'NULL'));
1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));

Line 1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));

1360: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Person ID '|| NVL(p_person_id , -99));
1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));

Line 1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));

1361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','List Name -> Person ID Group '|| NVL(p_list_id , -99));
1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));

Line 1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));

1362: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','derived Letter Code -> FAAWARD/FAMISTM/FADISBT '|| NVL(p_letter_type , 'NULL'));
1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));
1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));

Line 1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));

1363: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Award Year '|| NVL(p_parameter_1 , 'NULL'));
1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));
1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));
1371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_9 , 'NULL'));

Line 1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));

1364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Awarding period '|| NVL(p_parameter_2 , 'NULL'));
1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));
1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));
1371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_9 , 'NULL'));
1372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Override Flag '|| NVL(p_flag , 'NULL'));

Line 1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));

1365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_3 , 'NULL'));
1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));
1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));
1371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_9 , 'NULL'));
1372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Override Flag '|| NVL(p_flag , 'NULL'));
1373: END IF;

Line 1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));

1366: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_4 , 'NULL'));
1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));
1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));
1371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_9 , 'NULL'));
1372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Override Flag '|| NVL(p_flag , 'NULL'));
1373: END IF;
1374:

Line 1371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_9 , 'NULL'));

1367: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_5 , 'NULL'));
1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));
1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));
1371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_9 , 'NULL'));
1372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Override Flag '|| NVL(p_flag , 'NULL'));
1373: END IF;
1374:
1375: l_static_group := 'Y';

Line 1372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Override Flag '|| NVL(p_flag , 'NULL'));

1368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_6 , 'NULL'));
1369: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','p_parameter_3 '|| NVL(p_parameter_7 , 'NULL'));
1370: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_8 , 'NULL'));
1371: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Not Used '|| NVL(p_parameter_9 , 'NULL'));
1372: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.corp_pre_process.debug','Override Flag '|| NVL(p_flag , 'NULL'));
1373: END IF;
1374:
1375: l_static_group := 'Y';
1376:

Line 1814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1810: BEGIN
1811:
1812: -- Get the Baseid for the person in an award year
1813:
1814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_person_id:'||p_person_id);
1816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_param1:'||p_param1);
1817: END IF;
1818:

Line 1815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_person_id:'||p_person_id);

1811:
1812: -- Get the Baseid for the person in an award year
1813:
1814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_person_id:'||p_person_id);
1816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_param1:'||p_param1);
1817: END IF;
1818:
1819: OPEN c_base;

Line 1816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_param1:'||p_param1);

1812: -- Get the Baseid for the person in an award year
1813:
1814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_person_id:'||p_person_id);
1816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_param1:'||p_param1);
1817: END IF;
1818:
1819: OPEN c_base;
1820: FETCH c_base INTO l_base;

Line 1834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1830: FETCH c_tdcur INTO l_tdrec;
1831: EXIT WHEN c_tdcur%NOTFOUND;
1832: IF l_tdrec.corsp_date IS NULL THEN
1833: p_return_status := 'S';
1834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status(1):'||p_return_status);
1836: END IF;
1837: EXIT;
1838: ELSE

Line 1835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status(1):'||p_return_status);

1831: EXIT WHEN c_tdcur%NOTFOUND;
1832: IF l_tdrec.corsp_date IS NULL THEN
1833: p_return_status := 'S';
1834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status(1):'||p_return_status);
1836: END IF;
1837: EXIT;
1838: ELSE
1839: l_newcorsp_dt := l_tdrec.corsp_date + NVL (l_tdrec.freq_attempt, 0);

Line 1844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1840: l_new_cnt := NVL(l_tdrec.corsp_count, 0) + 1;
1841:
1842: IF (l_tdrec.max_attempt IS NOT NULL AND l_new_cnt <= l_tdrec.max_attempt AND l_newcorsp_dt <= SYSDATE) OR (l_tdrec.max_attempt IS NULL AND l_newcorsp_dt <= SYSDATE) THEN
1843: p_return_status := 'S';
1844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status(2):'||p_return_status);
1846: END IF;
1847: EXIT;
1848: ELSE

Line 1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status(2):'||p_return_status);

1841:
1842: IF (l_tdrec.max_attempt IS NOT NULL AND l_new_cnt <= l_tdrec.max_attempt AND l_newcorsp_dt <= SYSDATE) OR (l_tdrec.max_attempt IS NULL AND l_newcorsp_dt <= SYSDATE) THEN
1843: p_return_status := 'S';
1844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1845: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status(2):'||p_return_status);
1846: END IF;
1847: EXIT;
1848: ELSE
1849: p_return_status := 'F';

Line 1856: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1852: END IF;
1853: END LOOP;
1854:
1855: CLOSE c_tdcur;
1856: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1857: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status:'||p_return_status);
1858: END IF;
1859: EXCEPTION
1860: WHEN OTHERS THEN

Line 1857: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status:'||p_return_status);

1853: END LOOP;
1854:
1855: CLOSE c_tdcur;
1856: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1857: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status:'||p_return_status);
1858: END IF;
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 2148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2144:
2145: BEGIN
2146:
2147: -- Update award notification status to s = Sent.
2148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_person_id - ' || p_person_id);
2150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_year - ' || p_award_year);
2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_prd_cd - ' || p_award_prd_cd);
2152: END IF;

Line 2149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_person_id - ' || p_person_id);

2145: BEGIN
2146:
2147: -- Update award notification status to s = Sent.
2148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_person_id - ' || p_person_id);
2150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_year - ' || p_award_year);
2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_prd_cd - ' || p_award_prd_cd);
2152: END IF;
2153:

Line 2150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_year - ' || p_award_year);

2146:
2147: -- Update award notification status to s = Sent.
2148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_person_id - ' || p_person_id);
2150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_year - ' || p_award_year);
2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_prd_cd - ' || p_award_prd_cd);
2152: END IF;
2153:
2154: igf_aw_gen.update_notification_status (

Line 2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_prd_cd - ' || p_award_prd_cd);

2147: -- Update award notification status to s = Sent.
2148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_person_id - ' || p_person_id);
2150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_year - ' || p_award_year);
2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.award_letter_update.debug', 'p_award_prd_cd - ' || p_award_prd_cd);
2152: END IF;
2153:
2154: igf_aw_gen.update_notification_status (
2155: p_cal_type => RTRIM (SUBSTR (p_award_year,1,10)),