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

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

398:
399: l_rowid := NULL;
400: l_sequence_no := NULL;
401:
402: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
403:
404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_flag =>' || 'A');
405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);

Line 404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_flag =>' || 'A');

400: l_sequence_no := NULL;
401:
402: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
403:
404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_flag =>' || 'A');
405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));

Line 405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);

401:
402: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
403:
404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_flag =>' || 'A');
405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);

Line 406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);

402: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
403:
404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_flag =>' || 'A');
405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);

Line 407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);

403:
404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_flag =>' || 'A');
405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);

Line 408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));

404: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_flag =>' || 'A');
405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);

Line 409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);

405: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_person_id =>' || l_person_id);
406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);

Line 410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);

406: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_first_name =>' || hzp_rec.person_first_name);
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);

Line 411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);

407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_last_name =>' || hzp_rec.person_last_name);
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);

Line 412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);

408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address1 =>' || NVL(hzp_rec.address1,'NA'));
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);

Line 413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);

409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address2 =>' || hzp_rec.address2);
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);

Line 414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);

410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address3 =>' || hzp_rec.address3);
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));

Line 415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);

411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_address4 =>' || hzp_rec.address4);
412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);

Line 416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);

412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_city =>' || hzp_rec.city);
413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));

Line 417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);

413: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_state =>' || hzp_rec.state);
414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);

Line 418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));

414: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_province =>' || hzp_rec.province);
415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);

Line 419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);

415: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_county =>' || hzp_rec.county);
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);

Line 420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));

416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_country =>' || hzp_rec.country);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);

Line 421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);

417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_sex =>' || pe_rec.sex);
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);

Line 422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);

418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_birth_dt =>' || NVL(pe_rec.birth_dt,SYSDATE));
419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);

Line 423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);

419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_ssn_no =>' || awd_rec.ssn);
420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);

Line 424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);

420: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_marital_status =>' || NVL(stat_rec.marital_status,'NA'));
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);

Line 425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);

421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_type =>' || l_visa_type);
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);

Line 426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);

422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_category =>' || l_visa_category);
423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);
430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);

Line 427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);

423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_number =>' || l_visa_number);
424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);
430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_sequence_number =>' || awd_rec.ci_sequence_number);

Line 428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);

424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_visa_expiry_dt =>' || l_visa_expiry_dt);
425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);
430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_sequence_number =>' || awd_rec.ci_sequence_number);
432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_award_id =>' || awd_rec.award_id);

Line 429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);

425: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_entry_date =>' || l_entry_date);
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);
430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_sequence_number =>' || awd_rec.ci_sequence_number);
432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_award_id =>' || awd_rec.award_id);
433: END IF;

Line 430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);

426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_fund_id =>' || l_fund_id);
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);
430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_sequence_number =>' || awd_rec.ci_sequence_number);
432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_award_id =>' || awd_rec.award_id);
433: END IF;
434:

Line 431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_sequence_number =>' || awd_rec.ci_sequence_number);

427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_perct =>' || fund_mast_rec.threshold_perct);
428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);
430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_sequence_number =>' || awd_rec.ci_sequence_number);
432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_award_id =>' || awd_rec.award_id);
433: END IF;
434:
435:

Line 432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_award_id =>' || awd_rec.award_id);

428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_threshold_value =>' || fund_mast_rec.threshold_value);
429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_accepted_amnt =>' || accept_amnt_rec.accepted_amt);
430: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_cal_type =>' || awd_rec.ci_cal_type);
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_aw_sequence_number =>' || awd_rec.ci_sequence_number);
432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_award_id =>' || awd_rec.award_id);
433: END IF;
434:
435:
436: igf_se_auth_pkg.insert_row(

Line 475: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

471: );
472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth',' Unhandled Exception ->' || SQLERRM);
477: END IF;
478:
479: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth',' Unhandled Exception ->' || SQLERRM);

472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth',' Unhandled Exception ->' || SQLERRM);
477: END IF;
478:
479: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
480: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.insert') ;

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

489: END insert_auth;
490:
491: -- begin the main procedure.
492: BEGIN
493: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',
495: 'Parameters p_base_id->'|| TO_CHAR(p_base_id) ||
496: ' p_person_id'|| TO_CHAR(p_person_id) ||
497: ' p_fund_id'|| TO_CHAR(p_fund_id) ||

Line 494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',

490:
491: -- begin the main procedure.
492: BEGIN
493: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',
495: 'Parameters p_base_id->'|| TO_CHAR(p_base_id) ||
496: ' p_person_id'|| TO_CHAR(p_person_id) ||
497: ' p_fund_id'|| TO_CHAR(p_fund_id) ||
498: ' p_award_id'|| TO_CHAR(p_award_id) ||

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

505: -- check all the parameters are NOT NULL
506: IF (l_person_id IS NULL)
507: OR (l_fund_id IS NULL) THEN
508:
509: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Parameter Error');
511: END IF;
512:
513: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');

Line 510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Parameter Error');

506: IF (l_person_id IS NULL)
507: OR (l_fund_id IS NULL) THEN
508:
509: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Parameter Error');
511: END IF;
512:
513: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');
514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

558: CLOSE c_pe;
559:
560: IF hzp_rec.person_first_name IS NULL THEN
561: l_place :='F_NAME';
562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' First Name is null');
564: END IF;
565: RAISE no_data_found;
566: END IF;

Line 563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' First Name is null');

559:
560: IF hzp_rec.person_first_name IS NULL THEN
561: l_place :='F_NAME';
562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' First Name is null');
564: END IF;
565: RAISE no_data_found;
566: END IF;
567:

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

566: END IF;
567:
568: IF hzp_rec.person_last_name IS NULL THEN
569: l_place :='L_NAME';
570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Last Name is null');
572: END IF;
573: RAISE no_data_found;
574: END IF;

Line 571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Last Name is null');

567:
568: IF hzp_rec.person_last_name IS NULL THEN
569: l_place :='L_NAME';
570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Last Name is null');
572: END IF;
573: RAISE no_data_found;
574: END IF;
575:

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

574: END IF;
575:
576: IF hzp_rec.country IS NULL THEN
577: l_place :='COUNTRY';
578: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Country is null');
580: END IF;
581: RAISE no_data_found;
582: END IF;

Line 579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Country is null');

575:
576: IF hzp_rec.country IS NULL THEN
577: l_place :='COUNTRY';
578: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Country is null');
580: END IF;
581: RAISE no_data_found;
582: END IF;
583: