1309: close csr_get_org_info;
1310: select name into l_gre_name
1311: from hr_organization_units
1312: where organization_id = p_tax_unit_id;
1313: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1314: fnd_message.set_token('GRE',l_gre_name);
1315: fnd_message.raise_error;
1316: else
1317: close csr_get_org_info;
1310: select name into l_gre_name
1311: from hr_organization_units
1312: where organization_id = p_tax_unit_id;
1313: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1314: fnd_message.set_token('GRE',l_gre_name);
1315: fnd_message.raise_error;
1316: else
1317: close csr_get_org_info;
1318: end if;
1311: from hr_organization_units
1312: where organization_id = p_tax_unit_id;
1313: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1314: fnd_message.set_token('GRE',l_gre_name);
1315: fnd_message.raise_error;
1316: else
1317: close csr_get_org_info;
1318: end if;
1319:
1387: g_file_id := utl_file.fopen(l_path,g_file_name,'w');
1388:
1389: FOR gre_record IN csr_get_gre LOOP
1390: if gre_record.requester_id_code is NULL then
1391: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1392: fnd_message.set_token('GRE',gre_record.name);
1393: fnd_message.raise_error;
1394: end if;
1395:
1388:
1389: FOR gre_record IN csr_get_gre LOOP
1390: if gre_record.requester_id_code is NULL then
1391: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1392: fnd_message.set_token('GRE',gre_record.name);
1393: fnd_message.raise_error;
1394: end if;
1395:
1396: evs_mag_report
1389: FOR gre_record IN csr_get_gre LOOP
1390: if gre_record.requester_id_code is NULL then
1391: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1392: fnd_message.set_token('GRE',gre_record.name);
1393: fnd_message.raise_error;
1394: end if;
1395:
1396: evs_mag_report
1397: (p_path => l_path