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.PER_EEO_MAG_REPORT dependencies on FND_FILE

Line 332: /* fnd_file.put_line

328: ELSE
329: l_org_rec.c1_over_100_13 := '2';
330: END IF;
331:
332: /* fnd_file.put_line
333: (which => fnd_file.log,
334: buff => 'p_start_date '||p_start_date);
335: --
336: fnd_file.put_line

Line 333: (which => fnd_file.log,

329: l_org_rec.c1_over_100_13 := '2';
330: END IF;
331:
332: /* fnd_file.put_line
333: (which => fnd_file.log,
334: buff => 'p_start_date '||p_start_date);
335: --
336: fnd_file.put_line
337: (which => fnd_file.log,

Line 336: fnd_file.put_line

332: /* fnd_file.put_line
333: (which => fnd_file.log,
334: buff => 'p_start_date '||p_start_date);
335: --
336: fnd_file.put_line
337: (which => fnd_file.log,
338: buff => 'p_end_date '||p_end_date);
339: --
340: fnd_file.put_line

Line 337: (which => fnd_file.log,

333: (which => fnd_file.log,
334: buff => 'p_start_date '||p_start_date);
335: --
336: fnd_file.put_line
337: (which => fnd_file.log,
338: buff => 'p_end_date '||p_end_date);
339: --
340: fnd_file.put_line
341: (which => fnd_file.log,

Line 340: fnd_file.put_line

336: fnd_file.put_line
337: (which => fnd_file.log,
338: buff => 'p_end_date '||p_end_date);
339: --
340: fnd_file.put_line
341: (which => fnd_file.log,
342: buff => 'l_org_rec.l_d1_payroll_period_18 before '
343: ||l_org_rec.l_d1_payroll_period_18); */
344:

Line 341: (which => fnd_file.log,

337: (which => fnd_file.log,
338: buff => 'p_end_date '||p_end_date);
339: --
340: fnd_file.put_line
341: (which => fnd_file.log,
342: buff => 'l_org_rec.l_d1_payroll_period_18 before '
343: ||l_org_rec.l_d1_payroll_period_18); */
344:
345: l_org_rec.l_d1_payroll_period_18 :=

Line 354: /*fnd_file.put_line

350: -- for selection FROM location eit
351: --
352: l_report_year := SUBSTR(l_org_rec.l_d1_payroll_period_18,1,4);
353: l_prev_year_filed := TO_CHAR(TO_NUMBER(l_report_year - 1));
354: /*fnd_file.put_line
355: (which => fnd_file.log,
356: buff => 'l_org_rec.name_cert_off_23 '
357: ||l_org_rec.name_cert_off_23);
358: fnd_file.put_line

Line 355: (which => fnd_file.log,

351: --
352: l_report_year := SUBSTR(l_org_rec.l_d1_payroll_period_18,1,4);
353: l_prev_year_filed := TO_CHAR(TO_NUMBER(l_report_year - 1));
354: /*fnd_file.put_line
355: (which => fnd_file.log,
356: buff => 'l_org_rec.name_cert_off_23 '
357: ||l_org_rec.name_cert_off_23);
358: fnd_file.put_line
359: (which => fnd_file.log,

Line 358: fnd_file.put_line

354: /*fnd_file.put_line
355: (which => fnd_file.log,
356: buff => 'l_org_rec.name_cert_off_23 '
357: ||l_org_rec.name_cert_off_23);
358: fnd_file.put_line
359: (which => fnd_file.log,
360: buff => 'sustr of l_org_rec.name_cert_off_23 '
361: ||substr(l_org_rec.name_cert_off_23,1,3)); */
362:

Line 359: (which => fnd_file.log,

355: (which => fnd_file.log,
356: buff => 'l_org_rec.name_cert_off_23 '
357: ||l_org_rec.name_cert_off_23);
358: fnd_file.put_line
359: (which => fnd_file.log,
360: buff => 'sustr of l_org_rec.name_cert_off_23 '
361: ||substr(l_org_rec.name_cert_off_23,1,3)); */
362:
363: BEGIN --Local1

Line 366: fnd_file.put_line

362:
363: BEGIN --Local1
364: -- error IF required fields not present.
365: IF l_org_rec.company_number_1 IS NULL THEN
366: fnd_file.put_line
367: (which => fnd_file.log,
368: buff => '==================================');
369: fnd_file.put_line
370: (which => fnd_file.log,

Line 367: (which => fnd_file.log,

363: BEGIN --Local1
364: -- error IF required fields not present.
365: IF l_org_rec.company_number_1 IS NULL THEN
366: fnd_file.put_line
367: (which => fnd_file.log,
368: buff => '==================================');
369: fnd_file.put_line
370: (which => fnd_file.log,
371: buff => '*** Field 1 - company NUMBER is blank, '

Line 369: fnd_file.put_line

365: IF l_org_rec.company_number_1 IS NULL THEN
366: fnd_file.put_line
367: (which => fnd_file.log,
368: buff => '==================================');
369: fnd_file.put_line
370: (which => fnd_file.log,
371: buff => '*** Field 1 - company NUMBER is blank, '
372: ||'but this is a required field - Please enter. '
373: ||'This is entered IN the GRE parent Entity Data '

Line 370: (which => fnd_file.log,

366: fnd_file.put_line
367: (which => fnd_file.log,
368: buff => '==================================');
369: fnd_file.put_line
370: (which => fnd_file.log,
371: buff => '*** Field 1 - company NUMBER is blank, '
372: ||'but this is a required field - Please enter. '
373: ||'This is entered IN the GRE parent Entity Data '
374: ||'nav=Organization/Description/Parent Entity/Others ***');

Line 375: fnd_file.put_line

371: buff => '*** Field 1 - company NUMBER is blank, '
372: ||'but this is a required field - Please enter. '
373: ||'This is entered IN the GRE parent Entity Data '
374: ||'nav=Organization/Description/Parent Entity/Others ***');
375: fnd_file.put_line
376: (which => fnd_file.log,
377: buff => '==================================');
378: fnd_file.put_line
379: (which => fnd_file.log,

Line 376: (which => fnd_file.log,

372: ||'but this is a required field - Please enter. '
373: ||'This is entered IN the GRE parent Entity Data '
374: ||'nav=Organization/Description/Parent Entity/Others ***');
375: fnd_file.put_line
376: (which => fnd_file.log,
377: buff => '==================================');
378: fnd_file.put_line
379: (which => fnd_file.log,
380: buff => 'Field 14 - Question C2 may also be blank '

Line 378: fnd_file.put_line

374: ||'nav=Organization/Description/Parent Entity/Others ***');
375: fnd_file.put_line
376: (which => fnd_file.log,
377: buff => '==================================');
378: fnd_file.put_line
379: (which => fnd_file.log,
380: buff => 'Field 14 - Question C2 may also be blank '
381: ||'(is company affiliated with Companies of at least 100 emps?) '
382: ||'This is also a required field - which the app will force you to '

Line 379: (which => fnd_file.log,

375: fnd_file.put_line
376: (which => fnd_file.log,
377: buff => '==================================');
378: fnd_file.put_line
379: (which => fnd_file.log,
380: buff => 'Field 14 - Question C2 may also be blank '
381: ||'(is company affiliated with Companies of at least 100 emps?) '
382: ||'This is also a required field - which the app will force you to '
383: ||'enter at organization level for the GRE parent Entity Data. '

Line 385: fnd_file.put_line

381: ||'(is company affiliated with Companies of at least 100 emps?) '
382: ||'This is also a required field - which the app will force you to '
383: ||'enter at organization level for the GRE parent Entity Data. '
384: ||'nav=Organization/Description/Parent Entity/Others ');
385: fnd_file.put_line
386: (which => fnd_file.log,
387: buff => '==================================');
388: RAISE hr_utility.hr_error;
389: END IF;

Line 386: (which => fnd_file.log,

382: ||'This is also a required field - which the app will force you to '
383: ||'enter at organization level for the GRE parent Entity Data. '
384: ||'nav=Organization/Description/Parent Entity/Others ');
385: fnd_file.put_line
386: (which => fnd_file.log,
387: buff => '==================================');
388: RAISE hr_utility.hr_error;
389: END IF;
390: END; --Local1

Line 402: -- fnd_file.put_line

398:
399: IF UPPER(SUBSTR(l_org_rec.name_cert_off_23,1,3)) = UPPER('THE') THEN
400: l_org_rec.name_cert_off_23 :=
401: ltrim(l_org_rec.name_cert_off_23,'THEthe');
402: -- fnd_file.put_line
403: --(which => fnd_file.log,
404: -- buff => 'l_org_rec.name_cert_off_23 '
405: -- ||l_org_rec.name_cert_off_23);
406: l_org_rec.name_cert_off_23 :=

Line 403: --(which => fnd_file.log,

399: IF UPPER(SUBSTR(l_org_rec.name_cert_off_23,1,3)) = UPPER('THE') THEN
400: l_org_rec.name_cert_off_23 :=
401: ltrim(l_org_rec.name_cert_off_23,'THEthe');
402: -- fnd_file.put_line
403: --(which => fnd_file.log,
404: -- buff => 'l_org_rec.name_cert_off_23 '
405: -- ||l_org_rec.name_cert_off_23);
406: l_org_rec.name_cert_off_23 :=
407: l_org_rec.name_cert_off_23||' The';

Line 408: -- fnd_file.put_line

404: -- buff => 'l_org_rec.name_cert_off_23 '
405: -- ||l_org_rec.name_cert_off_23);
406: l_org_rec.name_cert_off_23 :=
407: l_org_rec.name_cert_off_23||' The';
408: -- fnd_file.put_line
409: --(which => fnd_file.log,
410: -- buff => 'l_org_rec.name_cert_off_23 '
411: -- ||l_org_rec.name_cert_off_23);
412: END IF;

Line 409: --(which => fnd_file.log,

405: -- ||l_org_rec.name_cert_off_23);
406: l_org_rec.name_cert_off_23 :=
407: l_org_rec.name_cert_off_23||' The';
408: -- fnd_file.put_line
409: --(which => fnd_file.log,
410: -- buff => 'l_org_rec.name_cert_off_23 '
411: -- ||l_org_rec.name_cert_off_23);
412: END IF;
413:

Line 415: /* fnd_file.put_line

411: -- ||l_org_rec.name_cert_off_23);
412: END IF;
413:
414: --
415: /* fnd_file.put_line
416: (which => fnd_file.log,
417: buff => 'l_org_rec.l_d1_payroll_period_18 after '
418: ||l_org_rec.l_d1_payroll_period_18);
419: --

Line 416: (which => fnd_file.log,

412: END IF;
413:
414: --
415: /* fnd_file.put_line
416: (which => fnd_file.log,
417: buff => 'l_org_rec.l_d1_payroll_period_18 after '
418: ||l_org_rec.l_d1_payroll_period_18);
419: --
420: fnd_file.put_line

Line 420: fnd_file.put_line

416: (which => fnd_file.log,
417: buff => 'l_org_rec.l_d1_payroll_period_18 after '
418: ||l_org_rec.l_d1_payroll_period_18);
419: --
420: fnd_file.put_line
421: (which => fnd_file.log,
422: buff => 'l_report_year '||l_report_year);
423: --
424: fnd_file.put_line

Line 421: (which => fnd_file.log,

417: buff => 'l_org_rec.l_d1_payroll_period_18 after '
418: ||l_org_rec.l_d1_payroll_period_18);
419: --
420: fnd_file.put_line
421: (which => fnd_file.log,
422: buff => 'l_report_year '||l_report_year);
423: --
424: fnd_file.put_line
425: (which => fnd_file.log,

Line 424: fnd_file.put_line

420: fnd_file.put_line
421: (which => fnd_file.log,
422: buff => 'l_report_year '||l_report_year);
423: --
424: fnd_file.put_line
425: (which => fnd_file.log,
426: buff => 'l_prev_year_filed '||l_prev_year_filed); */
427:
428: END set_org_details;

Line 425: (which => fnd_file.log,

421: (which => fnd_file.log,
422: buff => 'l_report_year '||l_report_year);
423: --
424: fnd_file.put_line
425: (which => fnd_file.log,
426: buff => 'l_prev_year_filed '||l_prev_year_filed); */
427:
428: END set_org_details;
429:

Line 447: fnd_file.put_line

443: IF l_org_rec.form_type = 'M' THEN
444:
445: IF l_consol_rec.unit_name_4 IS NULL THEN
446:
447: fnd_file.put_line
448: (which => fnd_file.log,
449: buff => ' ');
450:
451: fnd_file.put_line

Line 448: (which => fnd_file.log,

444:
445: IF l_consol_rec.unit_name_4 IS NULL THEN
446:
447: fnd_file.put_line
448: (which => fnd_file.log,
449: buff => ' ');
450:
451: fnd_file.put_line
452: (which => fnd_file.log,

Line 451: fnd_file.put_line

447: fnd_file.put_line
448: (which => fnd_file.log,
449: buff => ' ');
450:
451: fnd_file.put_line
452: (which => fnd_file.log,
453: buff => ' UNIT NAME OR NUMBER SHOULD NOT BE NULL FOR CONSOLIDATED REPORT.'
454: ||'THIS INFORMATION COMES FROM HEADQUARTERS ESTABLISHMENT.'
455: ||'The unit NUMBER IS ' || l_consol_rec.unit_number_3

Line 452: (which => fnd_file.log,

448: (which => fnd_file.log,
449: buff => ' ');
450:
451: fnd_file.put_line
452: (which => fnd_file.log,
453: buff => ' UNIT NAME OR NUMBER SHOULD NOT BE NULL FOR CONSOLIDATED REPORT.'
454: ||'THIS INFORMATION COMES FROM HEADQUARTERS ESTABLISHMENT.'
455: ||'The unit NUMBER IS ' || l_consol_rec.unit_number_3
456: ||'The unit name IS ' || l_consol_rec.unit_name_4

Line 459: fnd_file.put_line

455: ||'The unit NUMBER IS ' || l_consol_rec.unit_number_3
456: ||'The unit name IS ' || l_consol_rec.unit_name_4
457: ||'The unit address IS ' || l_consol_rec.unit_address_req_5);
458:
459: fnd_file.put_line
460: (which => fnd_file.log,
461: buff => 'Reported field IN the EEO1 Specific Data Extra '
462: ||'Information Type ');
463:

Line 460: (which => fnd_file.log,

456: ||'The unit name IS ' || l_consol_rec.unit_name_4
457: ||'The unit address IS ' || l_consol_rec.unit_address_req_5);
458:
459: fnd_file.put_line
460: (which => fnd_file.log,
461: buff => 'Reported field IN the EEO1 Specific Data Extra '
462: ||'Information Type ');
463:
464: fnd_file.put_line

Line 464: fnd_file.put_line

460: (which => fnd_file.log,
461: buff => 'Reported field IN the EEO1 Specific Data Extra '
462: ||'Information Type ');
463:
464: fnd_file.put_line
465: (which => fnd_file.log,
466: buff => ' ');
467:
468: END IF; --l_consol_rec.unit_name_4 IS NULL

Line 465: (which => fnd_file.log,

461: buff => 'Reported field IN the EEO1 Specific Data Extra '
462: ||'Information Type ');
463:
464: fnd_file.put_line
465: (which => fnd_file.log,
466: buff => ' ');
467:
468: END IF; --l_consol_rec.unit_name_4 IS NULL
469:

Line 874: fnd_file.put_line

870: lpad(l_consol_rec.o_10_grand_total,7,0);
871: --
872: /* g_message_text := 'd1) l_consol_rec.a_1_total_mf IN string '
873: ||l_consol_rec.a_1_total_mf;
874: fnd_file.put_line
875: (which => fnd_file.log,
876: buff => g_message_text);
877: g_message_text := ' ';
878: fnd_file.put_line

Line 875: (which => fnd_file.log,

871: --
872: /* g_message_text := 'd1) l_consol_rec.a_1_total_mf IN string '
873: ||l_consol_rec.a_1_total_mf;
874: fnd_file.put_line
875: (which => fnd_file.log,
876: buff => g_message_text);
877: g_message_text := ' ';
878: fnd_file.put_line
879: (which => fnd_file.log,

Line 878: fnd_file.put_line

874: fnd_file.put_line
875: (which => fnd_file.log,
876: buff => g_message_text);
877: g_message_text := ' ';
878: fnd_file.put_line
879: (which => fnd_file.log,
880: buff => g_message_text);
881: g_message_text := 'e1) put line for l_string for consolidated RECORD ';
882: fnd_file.put_line

Line 879: (which => fnd_file.log,

875: (which => fnd_file.log,
876: buff => g_message_text);
877: g_message_text := ' ';
878: fnd_file.put_line
879: (which => fnd_file.log,
880: buff => g_message_text);
881: g_message_text := 'e1) put line for l_string for consolidated RECORD ';
882: fnd_file.put_line
883: (which => fnd_file.log,

Line 882: fnd_file.put_line

878: fnd_file.put_line
879: (which => fnd_file.log,
880: buff => g_message_text);
881: g_message_text := 'e1) put line for l_string for consolidated RECORD ';
882: fnd_file.put_line
883: (which => fnd_file.log,
884: buff => g_message_text);
885: g_message_text := ' ';
886: fnd_file.put_line

Line 883: (which => fnd_file.log,

879: (which => fnd_file.log,
880: buff => g_message_text);
881: g_message_text := 'e1) put line for l_string for consolidated RECORD ';
882: fnd_file.put_line
883: (which => fnd_file.log,
884: buff => g_message_text);
885: g_message_text := ' ';
886: fnd_file.put_line
887: (which => fnd_file.log,

Line 886: fnd_file.put_line

882: fnd_file.put_line
883: (which => fnd_file.log,
884: buff => g_message_text);
885: g_message_text := ' ';
886: fnd_file.put_line
887: (which => fnd_file.log,
888: buff => g_message_text); */
889: fnd_file.put_line
890: (which => fnd_file.output,

Line 887: (which => fnd_file.log,

883: (which => fnd_file.log,
884: buff => g_message_text);
885: g_message_text := ' ';
886: fnd_file.put_line
887: (which => fnd_file.log,
888: buff => g_message_text); */
889: fnd_file.put_line
890: (which => fnd_file.output,
891: buff => l_string);

Line 889: fnd_file.put_line

885: g_message_text := ' ';
886: fnd_file.put_line
887: (which => fnd_file.log,
888: buff => g_message_text); */
889: fnd_file.put_line
890: (which => fnd_file.output,
891: buff => l_string);
892:
893: END IF; -- l_org_rec.form_type = 'M'

Line 890: (which => fnd_file.output,

886: fnd_file.put_line
887: (which => fnd_file.log,
888: buff => g_message_text); */
889: fnd_file.put_line
890: (which => fnd_file.output,
891: buff => l_string);
892:
893: END IF; -- l_org_rec.form_type = 'M'
894: hr_utility.set_location('Leaving..' || l_proc,100);

Line 911: /* fnd_file.put_line

907: hr_utility.trace('l_estab_rec.unit_number_3 : '||l_estab_rec.unit_number_3);
908: hr_utility.trace('l_estab_rec.unit_name_4 : '||l_estab_rec.unit_name_4);
909: hr_utility.trace('l_estab_rec.unit_address_5: '||l_estab_rec.unit_address_req_5);
910:
911: /* fnd_file.put_line
912: (which => fnd_file.log,
913: buff => ' ');
914: fnd_file.put_line
915: (which => fnd_file.log,

Line 912: (which => fnd_file.log,

908: hr_utility.trace('l_estab_rec.unit_name_4 : '||l_estab_rec.unit_name_4);
909: hr_utility.trace('l_estab_rec.unit_address_5: '||l_estab_rec.unit_address_req_5);
910:
911: /* fnd_file.put_line
912: (which => fnd_file.log,
913: buff => ' ');
914: fnd_file.put_line
915: (which => fnd_file.log,
916: buff => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

Line 914: fnd_file.put_line

910:
911: /* fnd_file.put_line
912: (which => fnd_file.log,
913: buff => ' ');
914: fnd_file.put_line
915: (which => fnd_file.log,
916: buff => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
917: fnd_file.put_line
918: (which => fnd_file.log,

Line 915: (which => fnd_file.log,

911: /* fnd_file.put_line
912: (which => fnd_file.log,
913: buff => ' ');
914: fnd_file.put_line
915: (which => fnd_file.log,
916: buff => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
917: fnd_file.put_line
918: (which => fnd_file.log,
919: buff => ' PROCEDURE write_establishment_record ');

Line 917: fnd_file.put_line

913: buff => ' ');
914: fnd_file.put_line
915: (which => fnd_file.log,
916: buff => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
917: fnd_file.put_line
918: (which => fnd_file.log,
919: buff => ' PROCEDURE write_establishment_record ');
920: fnd_file.put_line
921: (which => fnd_file.log,

Line 918: (which => fnd_file.log,

914: fnd_file.put_line
915: (which => fnd_file.log,
916: buff => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
917: fnd_file.put_line
918: (which => fnd_file.log,
919: buff => ' PROCEDURE write_establishment_record ');
920: fnd_file.put_line
921: (which => fnd_file.log,
922: buff => '-------------------------------------------------------------');

Line 920: fnd_file.put_line

916: buff => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');
917: fnd_file.put_line
918: (which => fnd_file.log,
919: buff => ' PROCEDURE write_establishment_record ');
920: fnd_file.put_line
921: (which => fnd_file.log,
922: buff => '-------------------------------------------------------------');
923: */
924: --

Line 921: (which => fnd_file.log,

917: fnd_file.put_line
918: (which => fnd_file.log,
919: buff => ' PROCEDURE write_establishment_record ');
920: fnd_file.put_line
921: (which => fnd_file.log,
922: buff => '-------------------------------------------------------------');
923: */
924: --
925: -- Set Status

Line 1009: fnd_file.put_line

1005: l_org_rec.l_status_code_2 := '8';
1006: --
1007: -- not HQ AND under 50 emps at location
1008: /*
1009: fnd_file.put_line
1010: (which => fnd_file.log,
1011: buff => 'l_estab_rec.unit_number_3: '||l_estab_rec.unit_number_3);
1012: */
1013: -- END IF;

Line 1010: (which => fnd_file.log,

1006: --
1007: -- not HQ AND under 50 emps at location
1008: /*
1009: fnd_file.put_line
1010: (which => fnd_file.log,
1011: buff => 'l_estab_rec.unit_number_3: '||l_estab_rec.unit_number_3);
1012: */
1013: -- END IF;
1014:

Line 1026: fnd_file.put_line

1022:
1023: IF l_estab_rec.unit_number_3 IS NOT NULL
1024: AND l_org_rec.l_status_code_2 IN ('8','9') THEN
1025:
1026: fnd_file.put_line
1027: (which => fnd_file.log,
1028: buff => ' ');
1029: fnd_file.put_line
1030: (which => fnd_file.log,

Line 1027: (which => fnd_file.log,

1023: IF l_estab_rec.unit_number_3 IS NOT NULL
1024: AND l_org_rec.l_status_code_2 IN ('8','9') THEN
1025:
1026: fnd_file.put_line
1027: (which => fnd_file.log,
1028: buff => ' ');
1029: fnd_file.put_line
1030: (which => fnd_file.log,
1031: buff => ' UNIT NUMBER SHOULD BE NULL AS THIS LOCATION('

Line 1029: fnd_file.put_line

1025:
1026: fnd_file.put_line
1027: (which => fnd_file.log,
1028: buff => ' ');
1029: fnd_file.put_line
1030: (which => fnd_file.log,
1031: buff => ' UNIT NUMBER SHOULD BE NULL AS THIS LOCATION('
1032: || l_estab_rec.unit_name_4 || ') HAS EITHER '
1033: ||'NOT YET BEEN REPORTED OR IS UNDER 50 EMPS');

Line 1030: (which => fnd_file.log,

1026: fnd_file.put_line
1027: (which => fnd_file.log,
1028: buff => ' ');
1029: fnd_file.put_line
1030: (which => fnd_file.log,
1031: buff => ' UNIT NUMBER SHOULD BE NULL AS THIS LOCATION('
1032: || l_estab_rec.unit_name_4 || ') HAS EITHER '
1033: ||'NOT YET BEEN REPORTED OR IS UNDER 50 EMPS');
1034: fnd_file.put_line

Line 1034: fnd_file.put_line

1030: (which => fnd_file.log,
1031: buff => ' UNIT NUMBER SHOULD BE NULL AS THIS LOCATION('
1032: || l_estab_rec.unit_name_4 || ') HAS EITHER '
1033: ||'NOT YET BEEN REPORTED OR IS UNDER 50 EMPS');
1034: fnd_file.put_line
1035: (which => fnd_file.log,
1036: buff => ' ');
1037:
1038: ELSIF l_estab_rec.unit_number_3 IS NULL

Line 1035: (which => fnd_file.log,

1031: buff => ' UNIT NUMBER SHOULD BE NULL AS THIS LOCATION('
1032: || l_estab_rec.unit_name_4 || ') HAS EITHER '
1033: ||'NOT YET BEEN REPORTED OR IS UNDER 50 EMPS');
1034: fnd_file.put_line
1035: (which => fnd_file.log,
1036: buff => ' ');
1037:
1038: ELSIF l_estab_rec.unit_number_3 IS NULL
1039: AND l_org_rec.l_status_code_2 IN ('1','3','4','5') THEN

Line 1041: fnd_file.put_line

1037:
1038: ELSIF l_estab_rec.unit_number_3 IS NULL
1039: AND l_org_rec.l_status_code_2 IN ('1','3','4','5') THEN
1040:
1041: fnd_file.put_line
1042: (which => fnd_file.log,
1043: buff => ' ');
1044: fnd_file.put_line
1045: (which => fnd_file.log,

Line 1042: (which => fnd_file.log,

1038: ELSIF l_estab_rec.unit_number_3 IS NULL
1039: AND l_org_rec.l_status_code_2 IN ('1','3','4','5') THEN
1040:
1041: fnd_file.put_line
1042: (which => fnd_file.log,
1043: buff => ' ');
1044: fnd_file.put_line
1045: (which => fnd_file.log,
1046: buff => '********** UNIT NAME AND NUMBER SHOULD NOT BE NULL AS '

Line 1044: fnd_file.put_line

1040:
1041: fnd_file.put_line
1042: (which => fnd_file.log,
1043: buff => ' ');
1044: fnd_file.put_line
1045: (which => fnd_file.log,
1046: buff => '********** UNIT NAME AND NUMBER SHOULD NOT BE NULL AS '
1047: ||'THIS LOCATION HAS BEEN REPORTED ACCORDING TO THE Previously ');
1048: fnd_file.put_line

Line 1045: (which => fnd_file.log,

1041: fnd_file.put_line
1042: (which => fnd_file.log,
1043: buff => ' ');
1044: fnd_file.put_line
1045: (which => fnd_file.log,
1046: buff => '********** UNIT NAME AND NUMBER SHOULD NOT BE NULL AS '
1047: ||'THIS LOCATION HAS BEEN REPORTED ACCORDING TO THE Previously ');
1048: fnd_file.put_line
1049: (which => fnd_file.log,

Line 1048: fnd_file.put_line

1044: fnd_file.put_line
1045: (which => fnd_file.log,
1046: buff => '********** UNIT NAME AND NUMBER SHOULD NOT BE NULL AS '
1047: ||'THIS LOCATION HAS BEEN REPORTED ACCORDING TO THE Previously ');
1048: fnd_file.put_line
1049: (which => fnd_file.log,
1050: buff => 'Reported field IN the EEO1 Specific Data Extra '
1051: ||'Information Type. '
1052: ||' The unit NUMBER IS ' || l_estab_rec.unit_number_3

Line 1049: (which => fnd_file.log,

1045: (which => fnd_file.log,
1046: buff => '********** UNIT NAME AND NUMBER SHOULD NOT BE NULL AS '
1047: ||'THIS LOCATION HAS BEEN REPORTED ACCORDING TO THE Previously ');
1048: fnd_file.put_line
1049: (which => fnd_file.log,
1050: buff => 'Reported field IN the EEO1 Specific Data Extra '
1051: ||'Information Type. '
1052: ||' The unit NUMBER IS ' || l_estab_rec.unit_number_3
1053: ||' The unit name IS ' || l_estab_rec.unit_name_4

Line 1056: fnd_file.put_line

1052: ||' The unit NUMBER IS ' || l_estab_rec.unit_number_3
1053: ||' The unit name IS ' || l_estab_rec.unit_name_4
1054: ||' The unit address IS ' || l_estab_rec.unit_address_req_5
1055: || ' **********');
1056: fnd_file.put_line
1057: (which => fnd_file.log,
1058: buff => ' ');
1059:
1060: END IF; --l_estab_rec.unit_number_3 IS NOT NULL

Line 1057: (which => fnd_file.log,

1053: ||' The unit name IS ' || l_estab_rec.unit_name_4
1054: ||' The unit address IS ' || l_estab_rec.unit_address_req_5
1055: || ' **********');
1056: fnd_file.put_line
1057: (which => fnd_file.log,
1058: buff => ' ');
1059:
1060: END IF; --l_estab_rec.unit_number_3 IS NOT NULL
1061:

Line 1064: fnd_file.put_line

1060: END IF; --l_estab_rec.unit_number_3 IS NOT NULL
1061:
1062:
1063: g_message_text := '*2-for estab rec write form TYPE IS* '||l_org_rec.form_type;
1064: fnd_file.put_line
1065: (which => fnd_file.log,
1066: buff => g_message_text);
1067: g_message_text := '*2-l_estab_rec.reported_last_year_11 IS* '||l_estab_rec.reported_last_year_11;
1068: fnd_file.put_line

Line 1065: (which => fnd_file.log,

1061:
1062:
1063: g_message_text := '*2-for estab rec write form TYPE IS* '||l_org_rec.form_type;
1064: fnd_file.put_line
1065: (which => fnd_file.log,
1066: buff => g_message_text);
1067: g_message_text := '*2-l_estab_rec.reported_last_year_11 IS* '||l_estab_rec.reported_last_year_11;
1068: fnd_file.put_line
1069: (which => fnd_file.log,

Line 1068: fnd_file.put_line

1064: fnd_file.put_line
1065: (which => fnd_file.log,
1066: buff => g_message_text);
1067: g_message_text := '*2-l_estab_rec.reported_last_year_11 IS* '||l_estab_rec.reported_last_year_11;
1068: fnd_file.put_line
1069: (which => fnd_file.log,
1070: buff => g_message_text);
1071: g_message_text := '*2-l_estab_rec.hq IS* '||l_estab_rec.hq ;
1072: fnd_file.put_line

Line 1069: (which => fnd_file.log,

1065: (which => fnd_file.log,
1066: buff => g_message_text);
1067: g_message_text := '*2-l_estab_rec.reported_last_year_11 IS* '||l_estab_rec.reported_last_year_11;
1068: fnd_file.put_line
1069: (which => fnd_file.log,
1070: buff => g_message_text);
1071: g_message_text := '*2-l_estab_rec.hq IS* '||l_estab_rec.hq ;
1072: fnd_file.put_line
1073: (which => fnd_file.log,

Line 1072: fnd_file.put_line

1068: fnd_file.put_line
1069: (which => fnd_file.log,
1070: buff => g_message_text);
1071: g_message_text := '*2-l_estab_rec.hq IS* '||l_estab_rec.hq ;
1072: fnd_file.put_line
1073: (which => fnd_file.log,
1074: buff => g_message_text);
1075: g_message_text := '*2-status code IS* '||l_org_rec.l_status_code_2;
1076: fnd_file.put_line

Line 1073: (which => fnd_file.log,

1069: (which => fnd_file.log,
1070: buff => g_message_text);
1071: g_message_text := '*2-l_estab_rec.hq IS* '||l_estab_rec.hq ;
1072: fnd_file.put_line
1073: (which => fnd_file.log,
1074: buff => g_message_text);
1075: g_message_text := '*2-status code IS* '||l_org_rec.l_status_code_2;
1076: fnd_file.put_line
1077: (which => fnd_file.log,

Line 1076: fnd_file.put_line

1072: fnd_file.put_line
1073: (which => fnd_file.log,
1074: buff => g_message_text);
1075: g_message_text := '*2-status code IS* '||l_org_rec.l_status_code_2;
1076: fnd_file.put_line
1077: (which => fnd_file.log,
1078: buff => g_message_text);
1079: g_message_text := ' '||l_org_rec.l_status_code_2;
1080: fnd_file.put_line

Line 1077: (which => fnd_file.log,

1073: (which => fnd_file.log,
1074: buff => g_message_text);
1075: g_message_text := '*2-status code IS* '||l_org_rec.l_status_code_2;
1076: fnd_file.put_line
1077: (which => fnd_file.log,
1078: buff => g_message_text);
1079: g_message_text := ' '||l_org_rec.l_status_code_2;
1080: fnd_file.put_line
1081: (which => fnd_file.log,

Line 1080: fnd_file.put_line

1076: fnd_file.put_line
1077: (which => fnd_file.log,
1078: buff => g_message_text);
1079: g_message_text := ' '||l_org_rec.l_status_code_2;
1080: fnd_file.put_line
1081: (which => fnd_file.log,
1082: buff => g_message_text);
1083: END IF; ----l_org_rec.form_type = 'S'
1084: --

Line 1081: (which => fnd_file.log,

1077: (which => fnd_file.log,
1078: buff => g_message_text);
1079: g_message_text := ' '||l_org_rec.l_status_code_2;
1080: fnd_file.put_line
1081: (which => fnd_file.log,
1082: buff => g_message_text);
1083: END IF; ----l_org_rec.form_type = 'S'
1084: --
1085: -- include hawaii IN main processing

Line 1111: fnd_file.put_line

1107: hr_utility.trace('l_consol_rec.a_10_grand_total : '||l_consol_rec.a_10_grand_total);
1108: /*
1109: g_message_text := 'grand total for estab rep column a '
1110: ||'(total males AND females) ';
1111: fnd_file.put_line
1112: (which => fnd_file.log,
1113: buff => g_message_text);
1114: g_message_text := 'l_estab_rec.a_10_grand_total *'
1115: ||l_estab_rec.a_10_grand_total;

Line 1112: (which => fnd_file.log,

1108: /*
1109: g_message_text := 'grand total for estab rep column a '
1110: ||'(total males AND females) ';
1111: fnd_file.put_line
1112: (which => fnd_file.log,
1113: buff => g_message_text);
1114: g_message_text := 'l_estab_rec.a_10_grand_total *'
1115: ||l_estab_rec.a_10_grand_total;
1116: fnd_file.put_line

Line 1116: fnd_file.put_line

1112: (which => fnd_file.log,
1113: buff => g_message_text);
1114: g_message_text := 'l_estab_rec.a_10_grand_total *'
1115: ||l_estab_rec.a_10_grand_total;
1116: fnd_file.put_line
1117: (which => fnd_file.log,
1118: buff => g_message_text);
1119: fnd_file.put_line
1120: (which => fnd_file.log,

Line 1117: (which => fnd_file.log,

1113: buff => g_message_text);
1114: g_message_text := 'l_estab_rec.a_10_grand_total *'
1115: ||l_estab_rec.a_10_grand_total;
1116: fnd_file.put_line
1117: (which => fnd_file.log,
1118: buff => g_message_text);
1119: fnd_file.put_line
1120: (which => fnd_file.log,
1121: buff => ' '); */

Line 1119: fnd_file.put_line

1115: ||l_estab_rec.a_10_grand_total;
1116: fnd_file.put_line
1117: (which => fnd_file.log,
1118: buff => g_message_text);
1119: fnd_file.put_line
1120: (which => fnd_file.log,
1121: buff => ' '); */
1122: --
1123: -- grand total for column b (Hispanic or Latino Female)

Line 1120: (which => fnd_file.log,

1116: fnd_file.put_line
1117: (which => fnd_file.log,
1118: buff => g_message_text);
1119: fnd_file.put_line
1120: (which => fnd_file.log,
1121: buff => ' '); */
1122: --
1123: -- grand total for column b (Hispanic or Latino Female)
1124: --

Line 1805: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1801: lpad(l_estab_rec.j_11_last_year_grand_total,6,0) ||
1802: lpad(l_estab_rec.k_11_last_year_grand_total,6,0); */
1803:
1804: /*g_message_text := 'l_estab_rec.a_1_total_mf -> '|| l_estab_rec.a_1_total_mf;
1805: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1806:
1807: g_message_text := 'l_estab_rec.a_2_total_mf -> '|| l_estab_rec.a_2_total_mf;
1808: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1809:

Line 1808: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1804: /*g_message_text := 'l_estab_rec.a_1_total_mf -> '|| l_estab_rec.a_1_total_mf;
1805: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1806:
1807: g_message_text := 'l_estab_rec.a_2_total_mf -> '|| l_estab_rec.a_2_total_mf;
1808: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1809:
1810: g_message_text := 'l_estab_rec.a_3_total_mf -> '|| l_estab_rec.a_3_total_mf;
1811: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1812:

Line 1811: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1807: g_message_text := 'l_estab_rec.a_2_total_mf -> '|| l_estab_rec.a_2_total_mf;
1808: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1809:
1810: g_message_text := 'l_estab_rec.a_3_total_mf -> '|| l_estab_rec.a_3_total_mf;
1811: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1812:
1813: g_message_text := 'l_estab_rec.a_4_total_mf -> '|| l_estab_rec.a_4_total_mf;
1814: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1815:

Line 1814: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1810: g_message_text := 'l_estab_rec.a_3_total_mf -> '|| l_estab_rec.a_3_total_mf;
1811: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1812:
1813: g_message_text := 'l_estab_rec.a_4_total_mf -> '|| l_estab_rec.a_4_total_mf;
1814: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1815:
1816: g_message_text := 'l_estab_rec.a_5_total_mf -> '|| l_estab_rec.a_5_total_mf;
1817: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1818:

Line 1817: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1813: g_message_text := 'l_estab_rec.a_4_total_mf -> '|| l_estab_rec.a_4_total_mf;
1814: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1815:
1816: g_message_text := 'l_estab_rec.a_5_total_mf -> '|| l_estab_rec.a_5_total_mf;
1817: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1818:
1819: g_message_text := 'l_estab_rec.a_6_total_mf -> '|| l_estab_rec.a_6_total_mf;
1820: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1821:

Line 1820: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1816: g_message_text := 'l_estab_rec.a_5_total_mf -> '|| l_estab_rec.a_5_total_mf;
1817: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1818:
1819: g_message_text := 'l_estab_rec.a_6_total_mf -> '|| l_estab_rec.a_6_total_mf;
1820: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1821:
1822: g_message_text := 'l_estab_rec.a_7_total_mf -> '|| l_estab_rec.a_7_total_mf;
1823: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1824:

Line 1823: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1819: g_message_text := 'l_estab_rec.a_6_total_mf -> '|| l_estab_rec.a_6_total_mf;
1820: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1821:
1822: g_message_text := 'l_estab_rec.a_7_total_mf -> '|| l_estab_rec.a_7_total_mf;
1823: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1824:
1825: g_message_text := 'l_estab_rec.a_8_total_mf -> '|| l_estab_rec.a_8_total_mf;
1826: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1827:

Line 1826: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1822: g_message_text := 'l_estab_rec.a_7_total_mf -> '|| l_estab_rec.a_7_total_mf;
1823: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1824:
1825: g_message_text := 'l_estab_rec.a_8_total_mf -> '|| l_estab_rec.a_8_total_mf;
1826: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1827:
1828:
1829: g_message_text := 'l_estab_rec.a_9_total_mf -> '|| l_estab_rec.a_9_total_mf;
1830: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);*/

Line 1830: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);*/

1826: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1827:
1828:
1829: g_message_text := 'l_estab_rec.a_9_total_mf -> '|| l_estab_rec.a_9_total_mf;
1830: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);*/
1831:
1832:
1833: g_message_text := 'l_estab_rec.a_10_grand_total -> '||l_estab_rec.a_10_grand_total;
1834: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

Line 1834: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

1830: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);*/
1831:
1832:
1833: g_message_text := 'l_estab_rec.a_10_grand_total -> '||l_estab_rec.a_10_grand_total;
1834: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1835:
1836:
1837: --
1838: fnd_file.put_line

Line 1838: fnd_file.put_line

1834: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
1835:
1836:
1837: --
1838: fnd_file.put_line
1839: (which => fnd_file.output,
1840: buff => l_string);
1841: hr_utility.set_location('Leaving..' || l_proc,100);
1842:

Line 1839: (which => fnd_file.output,

1835:
1836:
1837: --
1838: fnd_file.put_line
1839: (which => fnd_file.output,
1840: buff => l_string);
1841: hr_utility.set_location('Leaving..' || l_proc,100);
1842:
1843: END write_establishment_record;

Line 2233: fnd_file.put_line(which => fnd_file.log,buff =>'insert INTO location eit ');

2229: l_min_year VARCHAR2(4) := NULL;
2230:
2231: BEGIN --insert_location_eit
2232:
2233: fnd_file.put_line(which => fnd_file.log,buff =>'insert INTO location eit ');
2234:
2235: BEGIN --Local1
2236: SELECT eloc.location_id,
2237: eloc.location_code

Line 2248: fnd_file.put_line

2244: AND hierarchy_version_id = p_hierarchy_version_id
2245: AND pgn.node_type = 'EST'
2246: AND eloc.location_id = pgn.entity_id;
2247: END; --Local1
2248: fnd_file.put_line
2249: (which => fnd_file.log,
2250: buff => 'location code IS '||l_location_code);
2251: --
2252: BEGIN --Local2

Line 2249: (which => fnd_file.log,

2245: AND pgn.node_type = 'EST'
2246: AND eloc.location_id = pgn.entity_id;
2247: END; --Local1
2248: fnd_file.put_line
2249: (which => fnd_file.log,
2250: buff => 'location code IS '||l_location_code);
2251: --
2252: BEGIN --Local2
2253: SELECT 'U',

Line 2264: fnd_file.put_line

2260: AND location_id = l_location_id;
2261: EXCEPTION
2262: WHEN no_data_found THEN
2263: p_update := 'C';
2264: fnd_file.put_line
2265: (which => fnd_file.log,
2266: buff => ' ');
2267: fnd_file.put_line
2268: (which => fnd_file.log,

Line 2265: (which => fnd_file.log,

2261: EXCEPTION
2262: WHEN no_data_found THEN
2263: p_update := 'C';
2264: fnd_file.put_line
2265: (which => fnd_file.log,
2266: buff => ' ');
2267: fnd_file.put_line
2268: (which => fnd_file.log,
2269: buff => 'Need to create new eit for location '

Line 2267: fnd_file.put_line

2263: p_update := 'C';
2264: fnd_file.put_line
2265: (which => fnd_file.log,
2266: buff => ' ');
2267: fnd_file.put_line
2268: (which => fnd_file.log,
2269: buff => 'Need to create new eit for location '
2270: ||l_location_id ||' '|| l_location_code);
2271:

Line 2268: (which => fnd_file.log,

2264: fnd_file.put_line
2265: (which => fnd_file.log,
2266: buff => ' ');
2267: fnd_file.put_line
2268: (which => fnd_file.log,
2269: buff => 'Need to create new eit for location '
2270: ||l_location_id ||' '|| l_location_code);
2271:
2272: WHEN OTHERS THEN

Line 2277: fnd_file.put_line

2273: NULL;
2274: END;--Local2
2275:
2276: IF p_update = 'U' THEN
2277: fnd_file.put_line
2278: (which => fnd_file.log,
2279: buff => ' ');
2280: fnd_file.put_line
2281: (which => fnd_file.log,

Line 2278: (which => fnd_file.log,

2274: END;--Local2
2275:
2276: IF p_update = 'U' THEN
2277: fnd_file.put_line
2278: (which => fnd_file.log,
2279: buff => ' ');
2280: fnd_file.put_line
2281: (which => fnd_file.log,
2282: buff => 'p_update '||p_update||' location_id to update IS '

Line 2280: fnd_file.put_line

2276: IF p_update = 'U' THEN
2277: fnd_file.put_line
2278: (which => fnd_file.log,
2279: buff => ' ');
2280: fnd_file.put_line
2281: (which => fnd_file.log,
2282: buff => 'p_update '||p_update||' location_id to update IS '
2283: ||l_location_id ||' '|| l_location_code);
2284:

Line 2281: (which => fnd_file.log,

2277: fnd_file.put_line
2278: (which => fnd_file.log,
2279: buff => ' ');
2280: fnd_file.put_line
2281: (which => fnd_file.log,
2282: buff => 'p_update '||p_update||' location_id to update IS '
2283: ||l_location_id ||' '|| l_location_code);
2284:
2285: BEGIN--Local3

Line 2306: fnd_file.put_line

2302:
2303: END IF; --p_update = 'U'
2304:
2305: IF p_update = 'C' THEN
2306: fnd_file.put_line
2307: (which => fnd_file.log,
2308: buff => 'p_update '||p_update||' location_id '||l_location_id);
2309: fnd_file.put_line
2310: (which => fnd_file.log,

Line 2307: (which => fnd_file.log,

2303: END IF; --p_update = 'U'
2304:
2305: IF p_update = 'C' THEN
2306: fnd_file.put_line
2307: (which => fnd_file.log,
2308: buff => 'p_update '||p_update||' location_id '||l_location_id);
2309: fnd_file.put_line
2310: (which => fnd_file.log,
2311: buff => 'need to create new eit');

Line 2309: fnd_file.put_line

2305: IF p_update = 'C' THEN
2306: fnd_file.put_line
2307: (which => fnd_file.log,
2308: buff => 'p_update '||p_update||' location_id '||l_location_id);
2309: fnd_file.put_line
2310: (which => fnd_file.log,
2311: buff => 'need to create new eit');
2312:
2313: BEGIN--Local5

Line 2310: (which => fnd_file.log,

2306: fnd_file.put_line
2307: (which => fnd_file.log,
2308: buff => 'p_update '||p_update||' location_id '||l_location_id);
2309: fnd_file.put_line
2310: (which => fnd_file.log,
2311: buff => 'need to create new eit');
2312:
2313: BEGIN--Local5
2314: hr_location_extra_info_api.create_location_extra_info

Line 2342: fnd_file.put_line

2338: ,p_object_version_number => l_object_version_number
2339: );
2340: END;--Local5
2341: COMMIT;
2342: fnd_file.put_line
2343: (which => fnd_file.log,
2344: buff => ' ');
2345: fnd_file.put_line
2346: (which => fnd_file.log,

Line 2343: (which => fnd_file.log,

2339: );
2340: END;--Local5
2341: COMMIT;
2342: fnd_file.put_line
2343: (which => fnd_file.log,
2344: buff => ' ');
2345: fnd_file.put_line
2346: (which => fnd_file.log,
2347: buff => 'eit created for location_id '||l_location_id ||' year '

Line 2345: fnd_file.put_line

2341: COMMIT;
2342: fnd_file.put_line
2343: (which => fnd_file.log,
2344: buff => ' ');
2345: fnd_file.put_line
2346: (which => fnd_file.log,
2347: buff => 'eit created for location_id '||l_location_id ||' year '
2348: ||p_report_year);
2349: /*fnd_file.put_line

Line 2346: (which => fnd_file.log,

2342: fnd_file.put_line
2343: (which => fnd_file.log,
2344: buff => ' ');
2345: fnd_file.put_line
2346: (which => fnd_file.log,
2347: buff => 'eit created for location_id '||l_location_id ||' year '
2348: ||p_report_year);
2349: /*fnd_file.put_line
2350: (which => fnd_file.log,

Line 2349: /*fnd_file.put_line

2345: fnd_file.put_line
2346: (which => fnd_file.log,
2347: buff => 'eit created for location_id '||l_location_id ||' year '
2348: ||p_report_year);
2349: /*fnd_file.put_line
2350: (which => fnd_file.log,
2351: buff => 'grand total IS '||l_estab_rec.a_11_last_year_grand_total); */
2352: fnd_file.put_line
2353: (which => fnd_file.log,

Line 2350: (which => fnd_file.log,

2346: (which => fnd_file.log,
2347: buff => 'eit created for location_id '||l_location_id ||' year '
2348: ||p_report_year);
2349: /*fnd_file.put_line
2350: (which => fnd_file.log,
2351: buff => 'grand total IS '||l_estab_rec.a_11_last_year_grand_total); */
2352: fnd_file.put_line
2353: (which => fnd_file.log,
2354: buff => ' ');

Line 2352: fnd_file.put_line

2348: ||p_report_year);
2349: /*fnd_file.put_line
2350: (which => fnd_file.log,
2351: buff => 'grand total IS '||l_estab_rec.a_11_last_year_grand_total); */
2352: fnd_file.put_line
2353: (which => fnd_file.log,
2354: buff => ' ');
2355: END IF; -- IF p_update = 'C'
2356: --

Line 2353: (which => fnd_file.log,

2349: /*fnd_file.put_line
2350: (which => fnd_file.log,
2351: buff => 'grand total IS '||l_estab_rec.a_11_last_year_grand_total); */
2352: fnd_file.put_line
2353: (which => fnd_file.log,
2354: buff => ' ');
2355: END IF; -- IF p_update = 'C'
2356: --
2357: -- IF over 4 eits delete the earliest

Line 2399: fnd_file.put_line

2395: ,p_location_extra_info_id => l_location_extra_info_id
2396: ,p_object_version_number => l_object_version_number
2397: );
2398: END;--Local10
2399: fnd_file.put_line
2400: (which => fnd_file.log,
2401: buff => '* there are over 4 Archive EITs for location id '
2402: ||l_location_id||' so deleting for year '||l_min_year);
2403: END IF;--l_eit_count > 4

Line 2400: (which => fnd_file.log,

2396: ,p_object_version_number => l_object_version_number
2397: );
2398: END;--Local10
2399: fnd_file.put_line
2400: (which => fnd_file.log,
2401: buff => '* there are over 4 Archive EITs for location id '
2402: ||l_location_id||' so deleting for year '||l_min_year);
2403: END IF;--l_eit_count > 4
2404:

Line 2443: fnd_file.put_line

2439: WHEN NO_DATA_FOUND THEN
2440: p_update := 'C';
2441: l_organization_id := l_org_rec.par_ent_org_id;
2442: --
2443: fnd_file.put_line
2444: (which => fnd_file.log,
2445: buff => ' ');
2446: fnd_file.put_line
2447: (which => fnd_file.log,

Line 2444: (which => fnd_file.log,

2440: p_update := 'C';
2441: l_organization_id := l_org_rec.par_ent_org_id;
2442: --
2443: fnd_file.put_line
2444: (which => fnd_file.log,
2445: buff => ' ');
2446: fnd_file.put_line
2447: (which => fnd_file.log,
2448: buff => 'need to create new eit for '||l_organization_id);

Line 2446: fnd_file.put_line

2442: --
2443: fnd_file.put_line
2444: (which => fnd_file.log,
2445: buff => ' ');
2446: fnd_file.put_line
2447: (which => fnd_file.log,
2448: buff => 'need to create new eit for '||l_organization_id);
2449: fnd_file.put_line
2450: (which => fnd_file.log,

Line 2447: (which => fnd_file.log,

2443: fnd_file.put_line
2444: (which => fnd_file.log,
2445: buff => ' ');
2446: fnd_file.put_line
2447: (which => fnd_file.log,
2448: buff => 'need to create new eit for '||l_organization_id);
2449: fnd_file.put_line
2450: (which => fnd_file.log,
2451: buff => ' ');

Line 2449: fnd_file.put_line

2445: buff => ' ');
2446: fnd_file.put_line
2447: (which => fnd_file.log,
2448: buff => 'need to create new eit for '||l_organization_id);
2449: fnd_file.put_line
2450: (which => fnd_file.log,
2451: buff => ' ');
2452: fnd_file.put_line
2453: (which => fnd_file.log,

Line 2450: (which => fnd_file.log,

2446: fnd_file.put_line
2447: (which => fnd_file.log,
2448: buff => 'need to create new eit for '||l_organization_id);
2449: fnd_file.put_line
2450: (which => fnd_file.log,
2451: buff => ' ');
2452: fnd_file.put_line
2453: (which => fnd_file.log,
2454: buff => 'IMPORTANT. IF YOU FILED LAST YEAR BUT LAST YEARS DATES');

Line 2452: fnd_file.put_line

2448: buff => 'need to create new eit for '||l_organization_id);
2449: fnd_file.put_line
2450: (which => fnd_file.log,
2451: buff => ' ');
2452: fnd_file.put_line
2453: (which => fnd_file.log,
2454: buff => 'IMPORTANT. IF YOU FILED LAST YEAR BUT LAST YEARS DATES');
2455: fnd_file.put_line
2456: (which => fnd_file.log,

Line 2453: (which => fnd_file.log,

2449: fnd_file.put_line
2450: (which => fnd_file.log,
2451: buff => ' ');
2452: fnd_file.put_line
2453: (which => fnd_file.log,
2454: buff => 'IMPORTANT. IF YOU FILED LAST YEAR BUT LAST YEARS DATES');
2455: fnd_file.put_line
2456: (which => fnd_file.log,
2457: buff => 'ARE NOT BEING PRINTED, PLEASE EITHER MANUALLY ENTER DATA');

Line 2455: fnd_file.put_line

2451: buff => ' ');
2452: fnd_file.put_line
2453: (which => fnd_file.log,
2454: buff => 'IMPORTANT. IF YOU FILED LAST YEAR BUT LAST YEARS DATES');
2455: fnd_file.put_line
2456: (which => fnd_file.log,
2457: buff => 'ARE NOT BEING PRINTED, PLEASE EITHER MANUALLY ENTER DATA');
2458: fnd_file.put_line
2459: (which => fnd_file.log,

Line 2456: (which => fnd_file.log,

2452: fnd_file.put_line
2453: (which => fnd_file.log,
2454: buff => 'IMPORTANT. IF YOU FILED LAST YEAR BUT LAST YEARS DATES');
2455: fnd_file.put_line
2456: (which => fnd_file.log,
2457: buff => 'ARE NOT BEING PRINTED, PLEASE EITHER MANUALLY ENTER DATA');
2458: fnd_file.put_line
2459: (which => fnd_file.log,
2460: buff => 'IN THE ORGANIZATION EIT, OR RE-RUN THIS REPORT IN FINAL ');

Line 2458: fnd_file.put_line

2454: buff => 'IMPORTANT. IF YOU FILED LAST YEAR BUT LAST YEARS DATES');
2455: fnd_file.put_line
2456: (which => fnd_file.log,
2457: buff => 'ARE NOT BEING PRINTED, PLEASE EITHER MANUALLY ENTER DATA');
2458: fnd_file.put_line
2459: (which => fnd_file.log,
2460: buff => 'IN THE ORGANIZATION EIT, OR RE-RUN THIS REPORT IN FINAL ');
2461: fnd_file.put_line
2462: (which => fnd_file.log,

Line 2459: (which => fnd_file.log,

2455: fnd_file.put_line
2456: (which => fnd_file.log,
2457: buff => 'ARE NOT BEING PRINTED, PLEASE EITHER MANUALLY ENTER DATA');
2458: fnd_file.put_line
2459: (which => fnd_file.log,
2460: buff => 'IN THE ORGANIZATION EIT, OR RE-RUN THIS REPORT IN FINAL ');
2461: fnd_file.put_line
2462: (which => fnd_file.log,
2463: buff => 'MODE FOR LAST YEARS DATES. ');

Line 2461: fnd_file.put_line

2457: buff => 'ARE NOT BEING PRINTED, PLEASE EITHER MANUALLY ENTER DATA');
2458: fnd_file.put_line
2459: (which => fnd_file.log,
2460: buff => 'IN THE ORGANIZATION EIT, OR RE-RUN THIS REPORT IN FINAL ');
2461: fnd_file.put_line
2462: (which => fnd_file.log,
2463: buff => 'MODE FOR LAST YEARS DATES. ');
2464: fnd_file.put_line
2465: (which => fnd_file.log,

Line 2462: (which => fnd_file.log,

2458: fnd_file.put_line
2459: (which => fnd_file.log,
2460: buff => 'IN THE ORGANIZATION EIT, OR RE-RUN THIS REPORT IN FINAL ');
2461: fnd_file.put_line
2462: (which => fnd_file.log,
2463: buff => 'MODE FOR LAST YEARS DATES. ');
2464: fnd_file.put_line
2465: (which => fnd_file.log,
2466: buff => ' ');

Line 2464: fnd_file.put_line

2460: buff => 'IN THE ORGANIZATION EIT, OR RE-RUN THIS REPORT IN FINAL ');
2461: fnd_file.put_line
2462: (which => fnd_file.log,
2463: buff => 'MODE FOR LAST YEARS DATES. ');
2464: fnd_file.put_line
2465: (which => fnd_file.log,
2466: buff => ' ');
2467: WHEN OTHERS THEN
2468: NULL;

Line 2465: (which => fnd_file.log,

2461: fnd_file.put_line
2462: (which => fnd_file.log,
2463: buff => 'MODE FOR LAST YEARS DATES. ');
2464: fnd_file.put_line
2465: (which => fnd_file.log,
2466: buff => ' ');
2467: WHEN OTHERS THEN
2468: NULL;
2469: END;--Local1

Line 2472: fnd_file.put_line

2468: NULL;
2469: END;--Local1
2470:
2471: IF p_update = 'U' THEN
2472: fnd_file.put_line
2473: (which => fnd_file.log,
2474: buff => 'p_update '||p_update||' org_id to update IS '
2475: ||l_organization_id||' IN bus grp '
2476: ||p_business_group_id);

Line 2473: (which => fnd_file.log,

2469: END;--Local1
2470:
2471: IF p_update = 'U' THEN
2472: fnd_file.put_line
2473: (which => fnd_file.log,
2474: buff => 'p_update '||p_update||' org_id to update IS '
2475: ||l_organization_id||' IN bus grp '
2476: ||p_business_group_id);
2477:

Line 2502: fnd_file.put_line

2498: --
2499: END IF; --p_update = 'U'
2500:
2501: IF p_update = 'C' THEN
2502: fnd_file.put_line
2503: (which => fnd_file.log,
2504: buff => ' ');
2505: fnd_file.put_line
2506: (which => fnd_file.log,

Line 2503: (which => fnd_file.log,

2499: END IF; --p_update = 'U'
2500:
2501: IF p_update = 'C' THEN
2502: fnd_file.put_line
2503: (which => fnd_file.log,
2504: buff => ' ');
2505: fnd_file.put_line
2506: (which => fnd_file.log,
2507: buff => 'p_update '||p_update||' org id '||l_organization_id);

Line 2505: fnd_file.put_line

2501: IF p_update = 'C' THEN
2502: fnd_file.put_line
2503: (which => fnd_file.log,
2504: buff => ' ');
2505: fnd_file.put_line
2506: (which => fnd_file.log,
2507: buff => 'p_update '||p_update||' org id '||l_organization_id);
2508: fnd_file.put_line
2509: (which => fnd_file.log,

Line 2506: (which => fnd_file.log,

2502: fnd_file.put_line
2503: (which => fnd_file.log,
2504: buff => ' ');
2505: fnd_file.put_line
2506: (which => fnd_file.log,
2507: buff => 'p_update '||p_update||' org id '||l_organization_id);
2508: fnd_file.put_line
2509: (which => fnd_file.log,
2510: buff => 'need to create new eit');

Line 2508: fnd_file.put_line

2504: buff => ' ');
2505: fnd_file.put_line
2506: (which => fnd_file.log,
2507: buff => 'p_update '||p_update||' org id '||l_organization_id);
2508: fnd_file.put_line
2509: (which => fnd_file.log,
2510: buff => 'need to create new eit');
2511:
2512: BEGIN --Local4

Line 2509: (which => fnd_file.log,

2505: fnd_file.put_line
2506: (which => fnd_file.log,
2507: buff => 'p_update '||p_update||' org id '||l_organization_id);
2508: fnd_file.put_line
2509: (which => fnd_file.log,
2510: buff => 'need to create new eit');
2511:
2512: BEGIN --Local4
2513: hr_organization_api.create_org_information

Line 2542: fnd_file.put_line

2538: );
2539: END;--Local4
2540: COMMIT;
2541:
2542: fnd_file.put_line
2543: (which => fnd_file.log,
2544: buff => ' ');
2545: fnd_file.put_line
2546: (which => fnd_file.log,

Line 2543: (which => fnd_file.log,

2539: END;--Local4
2540: COMMIT;
2541:
2542: fnd_file.put_line
2543: (which => fnd_file.log,
2544: buff => ' ');
2545: fnd_file.put_line
2546: (which => fnd_file.log,
2547: buff => 'eit created for org id '||l_organization_id

Line 2545: fnd_file.put_line

2541:
2542: fnd_file.put_line
2543: (which => fnd_file.log,
2544: buff => ' ');
2545: fnd_file.put_line
2546: (which => fnd_file.log,
2547: buff => 'eit created for org id '||l_organization_id
2548: ||' year '||p_report_year);
2549: END IF; --p_update = 'C'

Line 2546: (which => fnd_file.log,

2542: fnd_file.put_line
2543: (which => fnd_file.log,
2544: buff => ' ');
2545: fnd_file.put_line
2546: (which => fnd_file.log,
2547: buff => 'eit created for org id '||l_organization_id
2548: ||' year '||p_report_year);
2549: END IF; --p_update = 'C'
2550:

Line 2596: fnd_file.put_line

2592: ,p_org_information_id => l_org_information_id
2593: ,p_object_version_number => l_object_version_number
2594: );
2595: END;--Local9
2596: fnd_file.put_line
2597: (which => fnd_file.log,
2598: buff => ' there are over 4 Archive EITs for organization id '
2599: ||p_business_group_id||' so deleting for year '||l_min_year);
2600: END IF;--l_eit_count > 4

Line 2597: (which => fnd_file.log,

2593: ,p_object_version_number => l_object_version_number
2594: );
2595: END;--Local9
2596: fnd_file.put_line
2597: (which => fnd_file.log,
2598: buff => ' there are over 4 Archive EITs for organization id '
2599: ||p_business_group_id||' so deleting for year '||l_min_year);
2600: END IF;--l_eit_count > 4
2601: END; --Local5

Line 2616: fnd_file.put_line

2612: BEGIN -- unit name AND address are required.
2613: IF (l_c_estab_details.unit_name_4 IS NULL OR
2614: l_c_estab_details.unit_address_req_5 IS NULL)
2615: THEN
2616: fnd_file.put_line
2617: (which => fnd_file.log,
2618: buff => '======================================================');
2619: fnd_file.put_line
2620: (which => fnd_file.log,

Line 2617: (which => fnd_file.log,

2613: IF (l_c_estab_details.unit_name_4 IS NULL OR
2614: l_c_estab_details.unit_address_req_5 IS NULL)
2615: THEN
2616: fnd_file.put_line
2617: (which => fnd_file.log,
2618: buff => '======================================================');
2619: fnd_file.put_line
2620: (which => fnd_file.log,
2621: buff => ' ');

Line 2619: fnd_file.put_line

2615: THEN
2616: fnd_file.put_line
2617: (which => fnd_file.log,
2618: buff => '======================================================');
2619: fnd_file.put_line
2620: (which => fnd_file.log,
2621: buff => ' ');
2622: fnd_file.put_line
2623: (which => fnd_file.log,

Line 2620: (which => fnd_file.log,

2616: fnd_file.put_line
2617: (which => fnd_file.log,
2618: buff => '======================================================');
2619: fnd_file.put_line
2620: (which => fnd_file.log,
2621: buff => ' ');
2622: fnd_file.put_line
2623: (which => fnd_file.log,
2624: buff => 'Unit name AND address are '

Line 2622: fnd_file.put_line

2618: buff => '======================================================');
2619: fnd_file.put_line
2620: (which => fnd_file.log,
2621: buff => ' ');
2622: fnd_file.put_line
2623: (which => fnd_file.log,
2624: buff => 'Unit name AND address are '
2625: ||'required fields - ');
2626: fnd_file.put_line

Line 2623: (which => fnd_file.log,

2619: fnd_file.put_line
2620: (which => fnd_file.log,
2621: buff => ' ');
2622: fnd_file.put_line
2623: (which => fnd_file.log,
2624: buff => 'Unit name AND address are '
2625: ||'required fields - ');
2626: fnd_file.put_line
2627: (which => fnd_file.log,

Line 2626: fnd_file.put_line

2622: fnd_file.put_line
2623: (which => fnd_file.log,
2624: buff => 'Unit name AND address are '
2625: ||'required fields - ');
2626: fnd_file.put_line
2627: (which => fnd_file.log,
2628: buff => 'Please enter ''Reporting Name'' IN location/extra '
2629: ||'info/eeo1 specific information for unit/establishment '
2630: ||l_c_estab_details.unit_name_4||' '

Line 2627: (which => fnd_file.log,

2623: (which => fnd_file.log,
2624: buff => 'Unit name AND address are '
2625: ||'required fields - ');
2626: fnd_file.put_line
2627: (which => fnd_file.log,
2628: buff => 'Please enter ''Reporting Name'' IN location/extra '
2629: ||'info/eeo1 specific information for unit/establishment '
2630: ||l_c_estab_details.unit_name_4||' '
2631: ||l_c_estab_details.unit_address_req_5);

Line 2632: fnd_file.put_line

2628: buff => 'Please enter ''Reporting Name'' IN location/extra '
2629: ||'info/eeo1 specific information for unit/establishment '
2630: ||l_c_estab_details.unit_name_4||' '
2631: ||l_c_estab_details.unit_address_req_5);
2632: fnd_file.put_line
2633: (which => fnd_file.log,
2634: buff => ' ');
2635: fnd_file.put_line
2636: (which => fnd_file.log,

Line 2633: (which => fnd_file.log,

2629: ||'info/eeo1 specific information for unit/establishment '
2630: ||l_c_estab_details.unit_name_4||' '
2631: ||l_c_estab_details.unit_address_req_5);
2632: fnd_file.put_line
2633: (which => fnd_file.log,
2634: buff => ' ');
2635: fnd_file.put_line
2636: (which => fnd_file.log,
2637: buff => 'Nav path = location/extra info/EEO1 Specific Data');

Line 2635: fnd_file.put_line

2631: ||l_c_estab_details.unit_address_req_5);
2632: fnd_file.put_line
2633: (which => fnd_file.log,
2634: buff => ' ');
2635: fnd_file.put_line
2636: (which => fnd_file.log,
2637: buff => 'Nav path = location/extra info/EEO1 Specific Data');
2638: fnd_file.put_line
2639: (which => fnd_file.log,

Line 2636: (which => fnd_file.log,

2632: fnd_file.put_line
2633: (which => fnd_file.log,
2634: buff => ' ');
2635: fnd_file.put_line
2636: (which => fnd_file.log,
2637: buff => 'Nav path = location/extra info/EEO1 Specific Data');
2638: fnd_file.put_line
2639: (which => fnd_file.log,
2640: buff => ' ');

Line 2638: fnd_file.put_line

2634: buff => ' ');
2635: fnd_file.put_line
2636: (which => fnd_file.log,
2637: buff => 'Nav path = location/extra info/EEO1 Specific Data');
2638: fnd_file.put_line
2639: (which => fnd_file.log,
2640: buff => ' ');
2641: fnd_file.put_line
2642: (which => fnd_file.log,

Line 2639: (which => fnd_file.log,

2635: fnd_file.put_line
2636: (which => fnd_file.log,
2637: buff => 'Nav path = location/extra info/EEO1 Specific Data');
2638: fnd_file.put_line
2639: (which => fnd_file.log,
2640: buff => ' ');
2641: fnd_file.put_line
2642: (which => fnd_file.log,
2643: buff => '======================================================');

Line 2641: fnd_file.put_line

2637: buff => 'Nav path = location/extra info/EEO1 Specific Data');
2638: fnd_file.put_line
2639: (which => fnd_file.log,
2640: buff => ' ');
2641: fnd_file.put_line
2642: (which => fnd_file.log,
2643: buff => '======================================================');
2644: RAISE hr_utility.hr_error;
2645: ELSIF

Line 2642: (which => fnd_file.log,

2638: fnd_file.put_line
2639: (which => fnd_file.log,
2640: buff => ' ');
2641: fnd_file.put_line
2642: (which => fnd_file.log,
2643: buff => '======================================================');
2644: RAISE hr_utility.hr_error;
2645: ELSIF
2646: (l_c_estab_details.city_7 IS NULL OR

Line 2651: fnd_file.put_line

2647: l_c_estab_details.state_8 IS NULL OR
2648: l_c_estab_details.zip_code_9 IS NULL OR
2649: l_c_estab_details.county_17 IS NULL)
2650: THEN
2651: fnd_file.put_line
2652: (which => fnd_file.log,
2653: buff => '==================================');
2654: fnd_file.put_line
2655: (which => fnd_file.log,

Line 2652: (which => fnd_file.log,

2648: l_c_estab_details.zip_code_9 IS NULL OR
2649: l_c_estab_details.county_17 IS NULL)
2650: THEN
2651: fnd_file.put_line
2652: (which => fnd_file.log,
2653: buff => '==================================');
2654: fnd_file.put_line
2655: (which => fnd_file.log,
2656: buff => ' ');

Line 2654: fnd_file.put_line

2650: THEN
2651: fnd_file.put_line
2652: (which => fnd_file.log,
2653: buff => '==================================');
2654: fnd_file.put_line
2655: (which => fnd_file.log,
2656: buff => ' ');
2657: fnd_file.put_line
2658: (which => fnd_file.log,

Line 2655: (which => fnd_file.log,

2651: fnd_file.put_line
2652: (which => fnd_file.log,
2653: buff => '==================================');
2654: fnd_file.put_line
2655: (which => fnd_file.log,
2656: buff => ' ');
2657: fnd_file.put_line
2658: (which => fnd_file.log,
2659: buff => 'The Location/Establishment City, State, County AND '

Line 2657: fnd_file.put_line

2653: buff => '==================================');
2654: fnd_file.put_line
2655: (which => fnd_file.log,
2656: buff => ' ');
2657: fnd_file.put_line
2658: (which => fnd_file.log,
2659: buff => 'The Location/Establishment City, State, County AND '
2660: ||'Zip Code are required fields ');
2661: fnd_file.put_line

Line 2658: (which => fnd_file.log,

2654: fnd_file.put_line
2655: (which => fnd_file.log,
2656: buff => ' ');
2657: fnd_file.put_line
2658: (which => fnd_file.log,
2659: buff => 'The Location/Establishment City, State, County AND '
2660: ||'Zip Code are required fields ');
2661: fnd_file.put_line
2662: (which => fnd_file.log,

Line 2661: fnd_file.put_line

2657: fnd_file.put_line
2658: (which => fnd_file.log,
2659: buff => 'The Location/Establishment City, State, County AND '
2660: ||'Zip Code are required fields ');
2661: fnd_file.put_line
2662: (which => fnd_file.log,
2663: buff => ' ');
2664: fnd_file.put_line
2665: (which => fnd_file.log,

Line 2662: (which => fnd_file.log,

2658: (which => fnd_file.log,
2659: buff => 'The Location/Establishment City, State, County AND '
2660: ||'Zip Code are required fields ');
2661: fnd_file.put_line
2662: (which => fnd_file.log,
2663: buff => ' ');
2664: fnd_file.put_line
2665: (which => fnd_file.log,
2666: buff => 'Please enter IN location form for unit '

Line 2664: fnd_file.put_line

2660: ||'Zip Code are required fields ');
2661: fnd_file.put_line
2662: (which => fnd_file.log,
2663: buff => ' ');
2664: fnd_file.put_line
2665: (which => fnd_file.log,
2666: buff => 'Please enter IN location form for unit '
2667: ||l_c_estab_details.unit_name_4);
2668: fnd_file.put_line

Line 2665: (which => fnd_file.log,

2661: fnd_file.put_line
2662: (which => fnd_file.log,
2663: buff => ' ');
2664: fnd_file.put_line
2665: (which => fnd_file.log,
2666: buff => 'Please enter IN location form for unit '
2667: ||l_c_estab_details.unit_name_4);
2668: fnd_file.put_line
2669: (which => fnd_file.log,

Line 2668: fnd_file.put_line

2664: fnd_file.put_line
2665: (which => fnd_file.log,
2666: buff => 'Please enter IN location form for unit '
2667: ||l_c_estab_details.unit_name_4);
2668: fnd_file.put_line
2669: (which => fnd_file.log,
2670: buff => '==================================');
2671: RAISE hr_utility.hr_error;
2672: END IF;

Line 2669: (which => fnd_file.log,

2665: (which => fnd_file.log,
2666: buff => 'Please enter IN location form for unit '
2667: ||l_c_estab_details.unit_name_4);
2668: fnd_file.put_line
2669: (which => fnd_file.log,
2670: buff => '==================================');
2671: RAISE hr_utility.hr_error;
2672: END IF;
2673: END; -- unit name AND address are required.

Line 2694: fnd_file.put_line

2690: OR l_c_estab_details.gov_contract_15 = 1) THEN
2691:
2692:
2693: IF (l_c_estab_details.naics_21 IS NULL AND l_org_rec.naics_21 IS NULL) THEN
2694: fnd_file.put_line
2695: (which => fnd_file.log,
2696: buff => '*==================================================*');
2697: fnd_file.put_line
2698: (which => fnd_file.log,

Line 2695: (which => fnd_file.log,

2691:
2692:
2693: IF (l_c_estab_details.naics_21 IS NULL AND l_org_rec.naics_21 IS NULL) THEN
2694: fnd_file.put_line
2695: (which => fnd_file.log,
2696: buff => '*==================================================*');
2697: fnd_file.put_line
2698: (which => fnd_file.log,
2699: buff => ' ');

Line 2697: fnd_file.put_line

2693: IF (l_c_estab_details.naics_21 IS NULL AND l_org_rec.naics_21 IS NULL) THEN
2694: fnd_file.put_line
2695: (which => fnd_file.log,
2696: buff => '*==================================================*');
2697: fnd_file.put_line
2698: (which => fnd_file.log,
2699: buff => ' ');
2700: fnd_file.put_line
2701: (which => fnd_file.log,

Line 2698: (which => fnd_file.log,

2694: fnd_file.put_line
2695: (which => fnd_file.log,
2696: buff => '*==================================================*');
2697: fnd_file.put_line
2698: (which => fnd_file.log,
2699: buff => ' ');
2700: fnd_file.put_line
2701: (which => fnd_file.log,
2702: buff => 'The Location/Establishment NAICS NUMBER '

Line 2700: fnd_file.put_line

2696: buff => '*==================================================*');
2697: fnd_file.put_line
2698: (which => fnd_file.log,
2699: buff => ' ');
2700: fnd_file.put_line
2701: (which => fnd_file.log,
2702: buff => 'The Location/Establishment NAICS NUMBER '
2703: ||'IS a required field ');
2704: fnd_file.put_line

Line 2701: (which => fnd_file.log,

2697: fnd_file.put_line
2698: (which => fnd_file.log,
2699: buff => ' ');
2700: fnd_file.put_line
2701: (which => fnd_file.log,
2702: buff => 'The Location/Establishment NAICS NUMBER '
2703: ||'IS a required field ');
2704: fnd_file.put_line
2705: (which => fnd_file.log,

Line 2704: fnd_file.put_line

2700: fnd_file.put_line
2701: (which => fnd_file.log,
2702: buff => 'The Location/Establishment NAICS NUMBER '
2703: ||'IS a required field ');
2704: fnd_file.put_line
2705: (which => fnd_file.log,
2706: buff => 'Please enter IN either location/extra info'
2707: ||'/eeo1 specific information ');
2708: fnd_file.put_line

Line 2705: (which => fnd_file.log,

2701: (which => fnd_file.log,
2702: buff => 'The Location/Establishment NAICS NUMBER '
2703: ||'IS a required field ');
2704: fnd_file.put_line
2705: (which => fnd_file.log,
2706: buff => 'Please enter IN either location/extra info'
2707: ||'/eeo1 specific information ');
2708: fnd_file.put_line
2709: (which => fnd_file.log,

Line 2708: fnd_file.put_line

2704: fnd_file.put_line
2705: (which => fnd_file.log,
2706: buff => 'Please enter IN either location/extra info'
2707: ||'/eeo1 specific information ');
2708: fnd_file.put_line
2709: (which => fnd_file.log,
2710: buff => 'for unit/establishment: ');
2711: fnd_file.put_line
2712: (which => fnd_file.log,

Line 2709: (which => fnd_file.log,

2705: (which => fnd_file.log,
2706: buff => 'Please enter IN either location/extra info'
2707: ||'/eeo1 specific information ');
2708: fnd_file.put_line
2709: (which => fnd_file.log,
2710: buff => 'for unit/establishment: ');
2711: fnd_file.put_line
2712: (which => fnd_file.log,
2713: buff => '<<'||l_c_estab_details.unit_name_4||'>>');

Line 2711: fnd_file.put_line

2707: ||'/eeo1 specific information ');
2708: fnd_file.put_line
2709: (which => fnd_file.log,
2710: buff => 'for unit/establishment: ');
2711: fnd_file.put_line
2712: (which => fnd_file.log,
2713: buff => '<<'||l_c_estab_details.unit_name_4||'>>');
2714: fnd_file.put_line
2715: (which => fnd_file.log,

Line 2712: (which => fnd_file.log,

2708: fnd_file.put_line
2709: (which => fnd_file.log,
2710: buff => 'for unit/establishment: ');
2711: fnd_file.put_line
2712: (which => fnd_file.log,
2713: buff => '<<'||l_c_estab_details.unit_name_4||'>>');
2714: fnd_file.put_line
2715: (which => fnd_file.log,
2716: buff => 'address: ');

Line 2714: fnd_file.put_line

2710: buff => 'for unit/establishment: ');
2711: fnd_file.put_line
2712: (which => fnd_file.log,
2713: buff => '<<'||l_c_estab_details.unit_name_4||'>>');
2714: fnd_file.put_line
2715: (which => fnd_file.log,
2716: buff => 'address: ');
2717: fnd_file.put_line
2718: (which => fnd_file.log,

Line 2715: (which => fnd_file.log,

2711: fnd_file.put_line
2712: (which => fnd_file.log,
2713: buff => '<<'||l_c_estab_details.unit_name_4||'>>');
2714: fnd_file.put_line
2715: (which => fnd_file.log,
2716: buff => 'address: ');
2717: fnd_file.put_line
2718: (which => fnd_file.log,
2719: buff => '<<'||l_c_estab_details.unit_address_req_5||' '

Line 2717: fnd_file.put_line

2713: buff => '<<'||l_c_estab_details.unit_name_4||'>>');
2714: fnd_file.put_line
2715: (which => fnd_file.log,
2716: buff => 'address: ');
2717: fnd_file.put_line
2718: (which => fnd_file.log,
2719: buff => '<<'||l_c_estab_details.unit_address_req_5||' '
2720: ||l_c_estab_details.unit_address_6||' '
2721: ||l_c_estab_details.city_7||' '

Line 2718: (which => fnd_file.log,

2714: fnd_file.put_line
2715: (which => fnd_file.log,
2716: buff => 'address: ');
2717: fnd_file.put_line
2718: (which => fnd_file.log,
2719: buff => '<<'||l_c_estab_details.unit_address_req_5||' '
2720: ||l_c_estab_details.unit_address_6||' '
2721: ||l_c_estab_details.city_7||' '
2722: ||l_c_estab_details.state_8||' '

Line 2724: fnd_file.put_line

2720: ||l_c_estab_details.unit_address_6||' '
2721: ||l_c_estab_details.city_7||' '
2722: ||l_c_estab_details.state_8||' '
2723: ||l_c_estab_details.zip_code_9||'>>');
2724: fnd_file.put_line
2725: (which => fnd_file.log,
2726: buff => '*Nav path = location/extra info/EEO1/VETS Generic Data*');
2727: fnd_file.put_line
2728: (which => fnd_file.log,

Line 2725: (which => fnd_file.log,

2721: ||l_c_estab_details.city_7||' '
2722: ||l_c_estab_details.state_8||' '
2723: ||l_c_estab_details.zip_code_9||'>>');
2724: fnd_file.put_line
2725: (which => fnd_file.log,
2726: buff => '*Nav path = location/extra info/EEO1/VETS Generic Data*');
2727: fnd_file.put_line
2728: (which => fnd_file.log,
2729: buff => ' ');

Line 2727: fnd_file.put_line

2723: ||l_c_estab_details.zip_code_9||'>>');
2724: fnd_file.put_line
2725: (which => fnd_file.log,
2726: buff => '*Nav path = location/extra info/EEO1/VETS Generic Data*');
2727: fnd_file.put_line
2728: (which => fnd_file.log,
2729: buff => ' ');
2730: fnd_file.put_line
2731: (which => fnd_file.log,

Line 2728: (which => fnd_file.log,

2724: fnd_file.put_line
2725: (which => fnd_file.log,
2726: buff => '*Nav path = location/extra info/EEO1/VETS Generic Data*');
2727: fnd_file.put_line
2728: (which => fnd_file.log,
2729: buff => ' ');
2730: fnd_file.put_line
2731: (which => fnd_file.log,
2732: buff => '~OR~');

Line 2730: fnd_file.put_line

2726: buff => '*Nav path = location/extra info/EEO1/VETS Generic Data*');
2727: fnd_file.put_line
2728: (which => fnd_file.log,
2729: buff => ' ');
2730: fnd_file.put_line
2731: (which => fnd_file.log,
2732: buff => '~OR~');
2733: fnd_file.put_line
2734: (which => fnd_file.log,

Line 2731: (which => fnd_file.log,

2727: fnd_file.put_line
2728: (which => fnd_file.log,
2729: buff => ' ');
2730: fnd_file.put_line
2731: (which => fnd_file.log,
2732: buff => '~OR~');
2733: fnd_file.put_line
2734: (which => fnd_file.log,
2735: buff => ' ');

Line 2733: fnd_file.put_line

2729: buff => ' ');
2730: fnd_file.put_line
2731: (which => fnd_file.log,
2732: buff => '~OR~');
2733: fnd_file.put_line
2734: (which => fnd_file.log,
2735: buff => ' ');
2736: fnd_file.put_line
2737: (which => fnd_file.log,

Line 2734: (which => fnd_file.log,

2730: fnd_file.put_line
2731: (which => fnd_file.log,
2732: buff => '~OR~');
2733: fnd_file.put_line
2734: (which => fnd_file.log,
2735: buff => ' ');
2736: fnd_file.put_line
2737: (which => fnd_file.log,
2738: buff => 'enter at organization level - for the '

Line 2736: fnd_file.put_line

2732: buff => '~OR~');
2733: fnd_file.put_line
2734: (which => fnd_file.log,
2735: buff => ' ');
2736: fnd_file.put_line
2737: (which => fnd_file.log,
2738: buff => 'enter at organization level - for the '
2739: ||'top organization IN this hierarchy (ie.GRE/Parent Entity)');
2740: fnd_file.put_line

Line 2737: (which => fnd_file.log,

2733: fnd_file.put_line
2734: (which => fnd_file.log,
2735: buff => ' ');
2736: fnd_file.put_line
2737: (which => fnd_file.log,
2738: buff => 'enter at organization level - for the '
2739: ||'top organization IN this hierarchy (ie.GRE/Parent Entity)');
2740: fnd_file.put_line
2741: (which => fnd_file.log,

Line 2740: fnd_file.put_line

2736: fnd_file.put_line
2737: (which => fnd_file.log,
2738: buff => 'enter at organization level - for the '
2739: ||'top organization IN this hierarchy (ie.GRE/Parent Entity)');
2740: fnd_file.put_line
2741: (which => fnd_file.log,
2742: buff => 'IN parent entity EEO1/VETS Establishment Data');
2743: fnd_file.put_line
2744: (which => fnd_file.log,

Line 2741: (which => fnd_file.log,

2737: (which => fnd_file.log,
2738: buff => 'enter at organization level - for the '
2739: ||'top organization IN this hierarchy (ie.GRE/Parent Entity)');
2740: fnd_file.put_line
2741: (which => fnd_file.log,
2742: buff => 'IN parent entity EEO1/VETS Establishment Data');
2743: fnd_file.put_line
2744: (which => fnd_file.log,
2745: buff => '*Nav path = Organization/Description/Parent Entity/'||

Line 2743: fnd_file.put_line

2739: ||'top organization IN this hierarchy (ie.GRE/Parent Entity)');
2740: fnd_file.put_line
2741: (which => fnd_file.log,
2742: buff => 'IN parent entity EEO1/VETS Establishment Data');
2743: fnd_file.put_line
2744: (which => fnd_file.log,
2745: buff => '*Nav path = Organization/Description/Parent Entity/'||
2746: 'Others/EEO1/VETS Establishment Data*');
2747: fnd_file.put_line

Line 2744: (which => fnd_file.log,

2740: fnd_file.put_line
2741: (which => fnd_file.log,
2742: buff => 'IN parent entity EEO1/VETS Establishment Data');
2743: fnd_file.put_line
2744: (which => fnd_file.log,
2745: buff => '*Nav path = Organization/Description/Parent Entity/'||
2746: 'Others/EEO1/VETS Establishment Data*');
2747: fnd_file.put_line
2748: (which => fnd_file.log,

Line 2747: fnd_file.put_line

2743: fnd_file.put_line
2744: (which => fnd_file.log,
2745: buff => '*Nav path = Organization/Description/Parent Entity/'||
2746: 'Others/EEO1/VETS Establishment Data*');
2747: fnd_file.put_line
2748: (which => fnd_file.log,
2749: buff => ' ');
2750: fnd_file.put_line
2751: (which => fnd_file.log,

Line 2748: (which => fnd_file.log,

2744: (which => fnd_file.log,
2745: buff => '*Nav path = Organization/Description/Parent Entity/'||
2746: 'Others/EEO1/VETS Establishment Data*');
2747: fnd_file.put_line
2748: (which => fnd_file.log,
2749: buff => ' ');
2750: fnd_file.put_line
2751: (which => fnd_file.log,
2752: buff => '*==================================================*');

Line 2750: fnd_file.put_line

2746: 'Others/EEO1/VETS Establishment Data*');
2747: fnd_file.put_line
2748: (which => fnd_file.log,
2749: buff => ' ');
2750: fnd_file.put_line
2751: (which => fnd_file.log,
2752: buff => '*==================================================*');
2753: RAISE hr_utility.hr_error;
2754: END IF; --(l_c_estab_details.naics_21 IS NULL AND l_org_rec.naics_21 IS NULL)

Line 2751: (which => fnd_file.log,

2747: fnd_file.put_line
2748: (which => fnd_file.log,
2749: buff => ' ');
2750: fnd_file.put_line
2751: (which => fnd_file.log,
2752: buff => '*==================================================*');
2753: RAISE hr_utility.hr_error;
2754: END IF; --(l_c_estab_details.naics_21 IS NULL AND l_org_rec.naics_21 IS NULL)
2755:

Line 2759: fnd_file.put_line

2755:
2756: IF (l_org_rec.title_cert_off_22 IS NULL OR
2757: l_org_rec.name_cert_off_23 IS NULL OR
2758: l_org_rec.tel_num_24 IS NULL) THEN
2759: fnd_file.put_line
2760: (which => fnd_file.log,
2761: buff => '==================================');
2762: fnd_file.put_line
2763: (which => fnd_file.log,

Line 2760: (which => fnd_file.log,

2756: IF (l_org_rec.title_cert_off_22 IS NULL OR
2757: l_org_rec.name_cert_off_23 IS NULL OR
2758: l_org_rec.tel_num_24 IS NULL) THEN
2759: fnd_file.put_line
2760: (which => fnd_file.log,
2761: buff => '==================================');
2762: fnd_file.put_line
2763: (which => fnd_file.log,
2764: buff => ' ');

Line 2762: fnd_file.put_line

2758: l_org_rec.tel_num_24 IS NULL) THEN
2759: fnd_file.put_line
2760: (which => fnd_file.log,
2761: buff => '==================================');
2762: fnd_file.put_line
2763: (which => fnd_file.log,
2764: buff => ' ');
2765: fnd_file.put_line
2766: (which => fnd_file.log,

Line 2763: (which => fnd_file.log,

2759: fnd_file.put_line
2760: (which => fnd_file.log,
2761: buff => '==================================');
2762: fnd_file.put_line
2763: (which => fnd_file.log,
2764: buff => ' ');
2765: fnd_file.put_line
2766: (which => fnd_file.log,
2767: buff => 'Fields 22/23/24 - Title of certifying official AND'

Line 2765: fnd_file.put_line

2761: buff => '==================================');
2762: fnd_file.put_line
2763: (which => fnd_file.log,
2764: buff => ' ');
2765: fnd_file.put_line
2766: (which => fnd_file.log,
2767: buff => 'Fields 22/23/24 - Title of certifying official AND'
2768: ||'/or their name AND phone NUMBER IS blank. ');
2769: fnd_file.put_line

Line 2766: (which => fnd_file.log,

2762: fnd_file.put_line
2763: (which => fnd_file.log,
2764: buff => ' ');
2765: fnd_file.put_line
2766: (which => fnd_file.log,
2767: buff => 'Fields 22/23/24 - Title of certifying official AND'
2768: ||'/or their name AND phone NUMBER IS blank. ');
2769: fnd_file.put_line
2770: (which => fnd_file.log,

Line 2769: fnd_file.put_line

2765: fnd_file.put_line
2766: (which => fnd_file.log,
2767: buff => 'Fields 22/23/24 - Title of certifying official AND'
2768: ||'/or their name AND phone NUMBER IS blank. ');
2769: fnd_file.put_line
2770: (which => fnd_file.log,
2771: buff => 'These are required fields. Please enter '
2772: ||'at organization level for the Business Group ');
2773: fnd_file.put_line

Line 2770: (which => fnd_file.log,

2766: (which => fnd_file.log,
2767: buff => 'Fields 22/23/24 - Title of certifying official AND'
2768: ||'/or their name AND phone NUMBER IS blank. ');
2769: fnd_file.put_line
2770: (which => fnd_file.log,
2771: buff => 'These are required fields. Please enter '
2772: ||'at organization level for the Business Group ');
2773: fnd_file.put_line
2774: (which => fnd_file.log,

Line 2773: fnd_file.put_line

2769: fnd_file.put_line
2770: (which => fnd_file.log,
2771: buff => 'These are required fields. Please enter '
2772: ||'at organization level for the Business Group ');
2773: fnd_file.put_line
2774: (which => fnd_file.log,
2775: buff => ' ');
2776: fnd_file.put_line
2777: (which => fnd_file.log,

Line 2774: (which => fnd_file.log,

2770: (which => fnd_file.log,
2771: buff => 'These are required fields. Please enter '
2772: ||'at organization level for the Business Group ');
2773: fnd_file.put_line
2774: (which => fnd_file.log,
2775: buff => ' ');
2776: fnd_file.put_line
2777: (which => fnd_file.log,
2778: buff => '<<'||l_org_rec.org_name||'>>');

Line 2776: fnd_file.put_line

2772: ||'at organization level for the Business Group ');
2773: fnd_file.put_line
2774: (which => fnd_file.log,
2775: buff => ' ');
2776: fnd_file.put_line
2777: (which => fnd_file.log,
2778: buff => '<<'||l_org_rec.org_name||'>>');
2779: fnd_file.put_line
2780: (which => fnd_file.log,

Line 2777: (which => fnd_file.log,

2773: fnd_file.put_line
2774: (which => fnd_file.log,
2775: buff => ' ');
2776: fnd_file.put_line
2777: (which => fnd_file.log,
2778: buff => '<<'||l_org_rec.org_name||'>>');
2779: fnd_file.put_line
2780: (which => fnd_file.log,
2781: buff => ' ');

Line 2779: fnd_file.put_line

2775: buff => ' ');
2776: fnd_file.put_line
2777: (which => fnd_file.log,
2778: buff => '<<'||l_org_rec.org_name||'>>');
2779: fnd_file.put_line
2780: (which => fnd_file.log,
2781: buff => ' ');
2782: fnd_file.put_line
2783: (which => fnd_file.log,

Line 2780: (which => fnd_file.log,

2776: fnd_file.put_line
2777: (which => fnd_file.log,
2778: buff => '<<'||l_org_rec.org_name||'>>');
2779: fnd_file.put_line
2780: (which => fnd_file.log,
2781: buff => ' ');
2782: fnd_file.put_line
2783: (which => fnd_file.log,
2784: buff => 'nav path = '

Line 2782: fnd_file.put_line

2778: buff => '<<'||l_org_rec.org_name||'>>');
2779: fnd_file.put_line
2780: (which => fnd_file.log,
2781: buff => ' ');
2782: fnd_file.put_line
2783: (which => fnd_file.log,
2784: buff => 'nav path = '
2785: ||'Business Group Organization/Description/Business Group'
2786: ||'/Others/EEO Report Details');

Line 2783: (which => fnd_file.log,

2779: fnd_file.put_line
2780: (which => fnd_file.log,
2781: buff => ' ');
2782: fnd_file.put_line
2783: (which => fnd_file.log,
2784: buff => 'nav path = '
2785: ||'Business Group Organization/Description/Business Group'
2786: ||'/Others/EEO Report Details');
2787: fnd_file.put_line

Line 2787: fnd_file.put_line

2783: (which => fnd_file.log,
2784: buff => 'nav path = '
2785: ||'Business Group Organization/Description/Business Group'
2786: ||'/Others/EEO Report Details');
2787: fnd_file.put_line
2788: (which => fnd_file.log,
2789: buff => '(unit name: '
2790: ||l_c_estab_details.unit_name_4||' address: '
2791: ||l_c_estab_details.unit_address_req_5||' '

Line 2788: (which => fnd_file.log,

2784: buff => 'nav path = '
2785: ||'Business Group Organization/Description/Business Group'
2786: ||'/Others/EEO Report Details');
2787: fnd_file.put_line
2788: (which => fnd_file.log,
2789: buff => '(unit name: '
2790: ||l_c_estab_details.unit_name_4||' address: '
2791: ||l_c_estab_details.unit_address_req_5||' '
2792: ||l_c_estab_details.zip_code_9||')');

Line 2793: fnd_file.put_line

2789: buff => '(unit name: '
2790: ||l_c_estab_details.unit_name_4||' address: '
2791: ||l_c_estab_details.unit_address_req_5||' '
2792: ||l_c_estab_details.zip_code_9||')');
2793: fnd_file.put_line
2794: (which => fnd_file.log,
2795: buff => ' ');
2796: fnd_file.put_line
2797: (which => fnd_file.log,

Line 2794: (which => fnd_file.log,

2790: ||l_c_estab_details.unit_name_4||' address: '
2791: ||l_c_estab_details.unit_address_req_5||' '
2792: ||l_c_estab_details.zip_code_9||')');
2793: fnd_file.put_line
2794: (which => fnd_file.log,
2795: buff => ' ');
2796: fnd_file.put_line
2797: (which => fnd_file.log,
2798: buff => '==================================');

Line 2796: fnd_file.put_line

2792: ||l_c_estab_details.zip_code_9||')');
2793: fnd_file.put_line
2794: (which => fnd_file.log,
2795: buff => ' ');
2796: fnd_file.put_line
2797: (which => fnd_file.log,
2798: buff => '==================================');
2799: RAISE hr_utility.hr_error;
2800: END IF;--l_org_rec.title_cert_off_22 IS NULL

Line 2797: (which => fnd_file.log,

2793: fnd_file.put_line
2794: (which => fnd_file.log,
2795: buff => ' ');
2796: fnd_file.put_line
2797: (which => fnd_file.log,
2798: buff => '==================================');
2799: RAISE hr_utility.hr_error;
2800: END IF;--l_org_rec.title_cert_off_22 IS NULL
2801:

Line 4201: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

4197: := nvl(l_consol_rec.a_11_last_year_grand_total,0) +
4198: nvl(l_estab_rec.a_11_last_year_grand_total,0);
4199:
4200: g_message_text := 'l_c_lastyears_details.p_total_a -> '|| l_c_lastyears_details.p_total_a;
4201: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
4202:
4203: g_message_text := 'l_consol_rec.a_11_last_year_grand_total -> '|| l_consol_rec.a_11_last_year_grand_total;
4204: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
4205:

Line 4204: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);

4200: g_message_text := 'l_c_lastyears_details.p_total_a -> '|| l_c_lastyears_details.p_total_a;
4201: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
4202:
4203: g_message_text := 'l_consol_rec.a_11_last_year_grand_total -> '|| l_consol_rec.a_11_last_year_grand_total;
4204: fnd_file.put_line(which => fnd_file.log, buff => g_message_text);
4205:
4206: l_estab_rec.b_11_last_year_grand_total := l_c_lastyears_details.p_wmale_b;
4207: l_consol_rec.b_11_last_year_grand_total
4208: := nvl(l_consol_rec.b_11_last_year_grand_total,0) +

Line 4327: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

4323: --hr_utility.trace_on(NULL,'ORACLE');
4324: hr_utility.set_location('Entering..'||l_proc,10);
4325:
4326: g_message_text := 'EEO1 Entering...'||l_proc||' 10';
4327: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4328:
4329:
4330:
4331: set_org_details(p_hierarchy_version_id => p_hierarchy_version_id,

Line 4348: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

4344: END IF;
4345: CLOSE c_nodes;
4346:
4347: g_message_text := 'EEO1 l_org_rec.form_type -> '||l_org_rec.form_type;
4348: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4349:
4350: g_message_text := 'EEO1 p_hierarchy_version_id -> '||p_hierarchy_version_id;
4351: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4352:

Line 4351: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

4347: g_message_text := 'EEO1 l_org_rec.form_type -> '||l_org_rec.form_type;
4348: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4349:
4350: g_message_text := 'EEO1 p_hierarchy_version_id -> '||p_hierarchy_version_id;
4351: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4352:
4353: g_message_text := 'EEO1 p_business_group_id -> '|| p_business_group_id;
4354: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4355:

Line 4354: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

4350: g_message_text := 'EEO1 p_hierarchy_version_id -> '||p_hierarchy_version_id;
4351: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4352:
4353: g_message_text := 'EEO1 p_business_group_id -> '|| p_business_group_id;
4354: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4355:
4356: g_message_text := 'EEO1 l_start_date -> '|| l_start_date;
4357: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4358:

Line 4357: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

4353: g_message_text := 'EEO1 p_business_group_id -> '|| p_business_group_id;
4354: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4355:
4356: g_message_text := 'EEO1 l_start_date -> '|| l_start_date;
4357: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4358:
4359: g_message_text := 'EEO1 l_end_date -> '|| l_end_date;
4360: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4361:

Line 4360: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

4356: g_message_text := 'EEO1 l_start_date -> '|| l_start_date;
4357: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4358:
4359: g_message_text := 'EEO1 l_end_date -> '|| l_end_date;
4360: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4361:
4362: g_message_text := 'EEO1 p_report_mode -> '|| p_report_mode;
4363: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4364:

Line 4363: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

4359: g_message_text := 'EEO1 l_end_date -> '|| l_end_date;
4360: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4361:
4362: g_message_text := 'EEO1 p_report_mode -> '|| p_report_mode;
4363: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4364:
4365:
4366: loop_through_establishments(p_hierarchy_version_id => p_hierarchy_version_id,
4367: p_business_group_id => p_business_group_id,