1: PACKAGE BODY igf_se_gen_001 AS
2: /* $Header: IGFSE01B.pls 120.7 2006/02/01 02:56:25 ridas ship $ */
3:
4: PROCEDURE display_auth_params(p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
5: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
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'));
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);
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);
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);
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);
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);
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);
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);
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);
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);
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));
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);
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'));
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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;
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:
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:
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(
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') ;
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') ;
481: IGS_GE_MSG_STACK.ADD;
482:
483: IF p_call = 'JOB' THEN -- continue for next student dont stop
484: RAISE NEXT_RECORD; -- user defined exception
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) ||
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);
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:
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:
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:
698: CLOSE c_auth_check;
699: END IF;
700:
701: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.update');
703: IGS_GE_MSG_STACK.ADD;
704:
705: IF p_call = 'JOB' THEN -- continue for next student dont stop
706: RAISE next_record; -- user defined exception
774:
775: WHEN OTHERS THEN
776: fnd_file.put_line(fnd_file.log,SQLERRM);
777: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
778: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth' || SQLERRM);
779: IGS_GE_MSG_STACK.ADD;
780:
781: APP_EXCEPTION.RAISE_EXCEPTION;
782: END send_work_auth;
914: --log a message
915: fnd_message.set_name('IGF','IGF_SE_AUTH_GENERATED');
916: fnd_file.put_line(fnd_file.log,fnd_message.get);
917: ELSE
918: igf_se_gen_001.send_work_auth(
919: auth_rec.base_id,
920: auth_rec.person_id,
921: auth_rec.fund_id,
922: auth_rec.award_id,
927: END IF;
928: ELSE
929: CLOSE c_auth_exists;
930: --authorization not exists
931: igf_se_gen_001.send_work_auth(
932: auth_rec.base_id,
933: auth_rec.person_id,
934: auth_rec.fund_id,
935: auth_rec.award_id,
955: EXCEPTION
956: WHEN OTHERS THEN
957: ROLLBACK;
958: retcode:=2;
959: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth_job');
960: IGS_GE_MSG_STACK.ADD;
961: errbuf := FND_MESSAGE.GET ;
962: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
963: END send_work_auth_job;
1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1076: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload:igf_se_payment_int.update');
1077: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1078: IGS_GE_MSG_STACK.ADD;
1079: -- app_exception.raise_exception;
1080:
1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1183: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload: delete record');
1184: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1185: IGS_GE_MSG_STACK.ADD;
1186: END;
1187:
1204: EXCEPTION -- main exception handling
1205: WHEN OTHERS THEN
1206: ROLLBACK ;
1207: retcode:=2;
1208: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload');
1209: IGS_GE_MSG_STACK.ADD;
1210: errbuf := FND_MESSAGE.GET ;
1211: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1212:
1492: FETCH c_award_det INTO l_sys_awd_status;
1493: CLOSE c_award_det;
1494:
1495: IF l_sys_awd_status = 'O' THEN
1496: igf_se_gen_001.se_notify (l_person_id, l_fund_id,NULL,NULL,auth_rec.award_id);
1497: igf_se_auth_pkg.update_row(
1498: x_rowid => auth_rec.row_id,
1499: x_sequence_no => auth_rec.sequence_no,
1500: x_auth_id => auth_rec.auth_id,
1699:
1700: EXCEPTION
1701: WHEN OTHERS THEN
1702: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1703: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.se_notify');
1704: IGS_GE_MSG_STACK.ADD;
1705: APP_EXCEPTION.RAISE_EXCEPTION;
1706: END se_notify;
1707:
1704: IGS_GE_MSG_STACK.ADD;
1705: APP_EXCEPTION.RAISE_EXCEPTION;
1706: END se_notify;
1707:
1708: END igf_se_gen_001;