1289: close csr_get_org_info;
1290: select name into l_gre_name
1291: from hr_organization_units
1292: where organization_id = p_tax_unit_id;
1293: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1294: fnd_message.set_token('GRE',l_gre_name);
1295: fnd_message.raise_error;
1296: else
1297: close csr_get_org_info;
1290: select name into l_gre_name
1291: from hr_organization_units
1292: where organization_id = p_tax_unit_id;
1293: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1294: fnd_message.set_token('GRE',l_gre_name);
1295: fnd_message.raise_error;
1296: else
1297: close csr_get_org_info;
1298: end if;
1291: from hr_organization_units
1292: where organization_id = p_tax_unit_id;
1293: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1294: fnd_message.set_token('GRE',l_gre_name);
1295: fnd_message.raise_error;
1296: else
1297: close csr_get_org_info;
1298: end if;
1299:
1367: g_file_id := utl_file.fopen(l_path,g_file_name,'w');
1368:
1369: FOR gre_record IN csr_get_gre LOOP
1370: if gre_record.requester_id_code is NULL then
1371: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1372: fnd_message.set_token('GRE',gre_record.name);
1373: fnd_message.raise_error;
1374: end if;
1375:
1368:
1369: FOR gre_record IN csr_get_gre LOOP
1370: if gre_record.requester_id_code is NULL then
1371: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1372: fnd_message.set_token('GRE',gre_record.name);
1373: fnd_message.raise_error;
1374: end if;
1375:
1376: evs_mag_report
1369: FOR gre_record IN csr_get_gre LOOP
1370: if gre_record.requester_id_code is NULL then
1371: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');
1372: fnd_message.set_token('GRE',gre_record.name);
1373: fnd_message.raise_error;
1374: end if;
1375:
1376: evs_mag_report
1377: (p_path => l_path