100:
101: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_update);
102:
103: -- here the input parameters are to be logged to the log file
104: fnd_file.put_line(fnd_file.log,l_param_passed);
105: fnd_file.put_line(fnd_file.log,RPAD(l_pergrp_id,30) || ' : ' || p_pergrp_id);
106: fnd_file.put_line(fnd_file.log,RPAD(l_rel_code,30) || ' : ' || p_rel_code);
107: fnd_file.put_line(fnd_file.log,RPAD(l_start_dt,30) || ' : ' || p_start_date);
108:
101: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_update);
102:
103: -- here the input parameters are to be logged to the log file
104: fnd_file.put_line(fnd_file.log,l_param_passed);
105: fnd_file.put_line(fnd_file.log,RPAD(l_pergrp_id,30) || ' : ' || p_pergrp_id);
106: fnd_file.put_line(fnd_file.log,RPAD(l_rel_code,30) || ' : ' || p_rel_code);
107: fnd_file.put_line(fnd_file.log,RPAD(l_start_dt,30) || ' : ' || p_start_date);
108:
109: fnd_file.put_line(fnd_file.log,RPAD(l_update,30) || ' : ' || l_yes_no);
102:
103: -- here the input parameters are to be logged to the log file
104: fnd_file.put_line(fnd_file.log,l_param_passed);
105: fnd_file.put_line(fnd_file.log,RPAD(l_pergrp_id,30) || ' : ' || p_pergrp_id);
106: fnd_file.put_line(fnd_file.log,RPAD(l_rel_code,30) || ' : ' || p_rel_code);
107: fnd_file.put_line(fnd_file.log,RPAD(l_start_dt,30) || ' : ' || p_start_date);
108:
109: fnd_file.put_line(fnd_file.log,RPAD(l_update,30) || ' : ' || l_yes_no);
110:
103: -- here the input parameters are to be logged to the log file
104: fnd_file.put_line(fnd_file.log,l_param_passed);
105: fnd_file.put_line(fnd_file.log,RPAD(l_pergrp_id,30) || ' : ' || p_pergrp_id);
106: fnd_file.put_line(fnd_file.log,RPAD(l_rel_code,30) || ' : ' || p_rel_code);
107: fnd_file.put_line(fnd_file.log,RPAD(l_start_dt,30) || ' : ' || p_start_date);
108:
109: fnd_file.put_line(fnd_file.log,RPAD(l_update,30) || ' : ' || l_yes_no);
110:
111: -- loop through the log table to display the message after proper formatiing
105: fnd_file.put_line(fnd_file.log,RPAD(l_pergrp_id,30) || ' : ' || p_pergrp_id);
106: fnd_file.put_line(fnd_file.log,RPAD(l_rel_code,30) || ' : ' || p_rel_code);
107: fnd_file.put_line(fnd_file.log,RPAD(l_start_dt,30) || ' : ' || p_start_date);
108:
109: fnd_file.put_line(fnd_file.log,RPAD(l_update,30) || ' : ' || l_yes_no);
110:
111: -- loop through the log table to display the message after proper formatiing
112: FOR i IN 1..l_count LOOP
113: IF g_log_tab(i).person_number IS NOT NULL THEN
110:
111: -- loop through the log table to display the message after proper formatiing
112: FOR i IN 1..l_count LOOP
113: IF g_log_tab(i).person_number IS NOT NULL THEN
114: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
115: fnd_file.put_line(fnd_file.log,'');
116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
111: -- loop through the log table to display the message after proper formatiing
112: FOR i IN 1..l_count LOOP
113: IF g_log_tab(i).person_number IS NOT NULL THEN
114: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
115: fnd_file.put_line(fnd_file.log,'');
116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: fnd_file.put_line(fnd_file.log,'');
114: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
115: fnd_file.put_line(fnd_file.log,'');
116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: fnd_file.put_line(fnd_file.log,'');
120: END IF;
121: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
122: END LOOP;
115: fnd_file.put_line(fnd_file.log,'');
116: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: fnd_file.put_line(fnd_file.log,'');
120: END IF;
121: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
122: END LOOP;
123:
117: fnd_message.set_token('PERSON_NUM',g_log_tab(i).person_number);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: fnd_file.put_line(fnd_file.log,'');
120: END IF;
121: fnd_file.put_line(fnd_file.log,g_log_tab(i).message_text);
122: END LOOP;
123:
124: EXCEPTION
125: WHEN others THEN