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

Line 266: fnd_file.put_line(FND_FILE.LOG,' ');

262: p_end_date
263: ) LOOP
264:
265: IF l_asg_found = 'N' THEN
266: fnd_file.put_line(FND_FILE.LOG,' ');
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,'Assignment Action Migartion Details');
269: fnd_file.put_line(FND_FILE.LOG,' ');
270: fnd_file.put_line(FND_FILE.LOG,rpad(lpad('Assignment ID',14),16)||' '||'Action Type'||' '||'Effective Date'||' '||'Report Type');

Line 267: fnd_file.put_line(FND_FILE.LOG,' ');

263: ) LOOP
264:
265: IF l_asg_found = 'N' THEN
266: fnd_file.put_line(FND_FILE.LOG,' ');
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,'Assignment Action Migartion Details');
269: fnd_file.put_line(FND_FILE.LOG,' ');
270: fnd_file.put_line(FND_FILE.LOG,rpad(lpad('Assignment ID',14),16)||' '||'Action Type'||' '||'Effective Date'||' '||'Report Type');
271: l_asg_found := 'Y';

Line 268: fnd_file.put_line(FND_FILE.LOG,'Assignment Action Migartion Details');

264:
265: IF l_asg_found = 'N' THEN
266: fnd_file.put_line(FND_FILE.LOG,' ');
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,'Assignment Action Migartion Details');
269: fnd_file.put_line(FND_FILE.LOG,' ');
270: fnd_file.put_line(FND_FILE.LOG,rpad(lpad('Assignment ID',14),16)||' '||'Action Type'||' '||'Effective Date'||' '||'Report Type');
271: l_asg_found := 'Y';
272: END IF;

Line 269: fnd_file.put_line(FND_FILE.LOG,' ');

265: IF l_asg_found = 'N' THEN
266: fnd_file.put_line(FND_FILE.LOG,' ');
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,'Assignment Action Migartion Details');
269: fnd_file.put_line(FND_FILE.LOG,' ');
270: fnd_file.put_line(FND_FILE.LOG,rpad(lpad('Assignment ID',14),16)||' '||'Action Type'||' '||'Effective Date'||' '||'Report Type');
271: l_asg_found := 'Y';
272: END IF;
273:

Line 270: fnd_file.put_line(FND_FILE.LOG,rpad(lpad('Assignment ID',14),16)||' '||'Action Type'||' '||'Effective Date'||' '||'Report Type');

266: fnd_file.put_line(FND_FILE.LOG,' ');
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,'Assignment Action Migartion Details');
269: fnd_file.put_line(FND_FILE.LOG,' ');
270: fnd_file.put_line(FND_FILE.LOG,rpad(lpad('Assignment ID',14),16)||' '||'Action Type'||' '||'Effective Date'||' '||'Report Type');
271: l_asg_found := 'Y';
272: END IF;
273:
274: l_stage := 'Update Asg Action' || v_assact.assignment_action_id;

Line 275: fnd_file.put_line(FND_FILE.LOG,rpad(lpad(v_assact.assignment_id,11),16)||' '||rpad(lpad(v_assact.action_type,6),11)||' '||rpad(lpad(v_assact.effective_date,11),14)||' '||rpad(lpad(v_assact.report_type,8),11));

271: l_asg_found := 'Y';
272: END IF;
273:
274: l_stage := 'Update Asg Action' || v_assact.assignment_action_id;
275: fnd_file.put_line(FND_FILE.LOG,rpad(lpad(v_assact.assignment_id,11),16)||' '||rpad(lpad(v_assact.action_type,6),11)||' '||rpad(lpad(v_assact.effective_date,11),14)||' '||rpad(lpad(v_assact.report_type,8),11));
276: -- Update the assignment actions
277: UPDATE pay_assignment_actions paa
278: SET tax_unit_id = p_org_id
279: WHERE paa.assignment_action_id = v_assact.assignment_action_id;

Line 294: fnd_file.put_line(FND_FILE.LOG,'Updating Commencement Date to '||l_comm_date);

290:
291: IF l_comm_date IS NOT NULL THEN
292:
293: l_stage := 'Update Employee Details' || v_assact.assignment_action_id || ' date '|| l_comm_date;
294: fnd_file.put_line(FND_FILE.LOG,'Updating Commencement Date to '||l_comm_date);
295: pay_action_information_api.update_action_information
296: (p_action_information_id => l_act_info_id
297: ,p_object_version_number => l_object_version_number
298: ,p_action_information30 => l_comm_date

Line 308: fnd_file.put_line(FND_FILE.LOG,'Updating Person ID to '||v_assact.person_id);

304: l_object_version_number := v_get_act_info.object_version_number;
305: l_act_info_id := v_get_act_info.action_information_id;
306:
307: l_stage := 'Update P45 Information' || v_assact.assignment_action_id || ' person '|| v_assact.person_id;
308: fnd_file.put_line(FND_FILE.LOG,'Updating Person ID to '||v_assact.person_id);
309: pay_action_information_api.update_action_information
310: (p_action_information_id => l_act_info_id
311: ,p_object_version_number => l_object_version_number
312: ,p_action_information8 => v_assact.person_id

Line 344: fnd_file.put_line(FND_FILE.LOG,'Updating Balance '|| g_statutory_balance_table(l_index).balance_name || ' with value ='|| fnd_number.number_to_canonical(l_value) || ' from Old Value '|| l_old_value ||' Asg action = '|| v_assact.assignment_action_id);

340: ,p_object_version_number => l_ovn
341: ,p_action_information1 => g_statutory_balance_table(l_index).new_defined_balance_id
342: ,p_action_information4 => fnd_number.number_to_canonical(l_value)
343: );
344: fnd_file.put_line(FND_FILE.LOG,'Updating Balance '|| g_statutory_balance_table(l_index).balance_name || ' with value ='|| fnd_number.number_to_canonical(l_value) || ' from Old Value '|| l_old_value ||' Asg action = '|| v_assact.assignment_action_id);
345:
346: END IF;
347:
348: END IF;

Line 479: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');

475:
476: retcode := 0;
477: l_p45_migrated := 0;
478:
479: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
480: fnd_file.put_line(FND_FILE.OUTPUT,' Migration Details ');
481: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
482: fnd_file.put_line(FND_FILE.OUTPUT,' ');
483: fnd_file.put_line(FND_FILE.OUTPUT,' ');

Line 480: fnd_file.put_line(FND_FILE.OUTPUT,' Migration Details ');

476: retcode := 0;
477: l_p45_migrated := 0;
478:
479: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
480: fnd_file.put_line(FND_FILE.OUTPUT,' Migration Details ');
481: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
482: fnd_file.put_line(FND_FILE.OUTPUT,' ');
483: fnd_file.put_line(FND_FILE.OUTPUT,' ');
484:

Line 481: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');

477: l_p45_migrated := 0;
478:
479: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
480: fnd_file.put_line(FND_FILE.OUTPUT,' Migration Details ');
481: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
482: fnd_file.put_line(FND_FILE.OUTPUT,' ');
483: fnd_file.put_line(FND_FILE.OUTPUT,' ');
484:
485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');

Line 482: fnd_file.put_line(FND_FILE.OUTPUT,' ');

478:
479: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
480: fnd_file.put_line(FND_FILE.OUTPUT,' Migration Details ');
481: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
482: fnd_file.put_line(FND_FILE.OUTPUT,' ');
483: fnd_file.put_line(FND_FILE.OUTPUT,' ');
484:
485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');

Line 483: fnd_file.put_line(FND_FILE.OUTPUT,' ');

479: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
480: fnd_file.put_line(FND_FILE.OUTPUT,' Migration Details ');
481: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
482: fnd_file.put_line(FND_FILE.OUTPUT,' ');
483: fnd_file.put_line(FND_FILE.OUTPUT,' ');
484:
485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');
487: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');

Line 485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');

481: fnd_file.put_line(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------');
482: fnd_file.put_line(FND_FILE.OUTPUT,' ');
483: fnd_file.put_line(FND_FILE.OUTPUT,' ');
484:
485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');
487: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
488: fnd_file.put_line(FND_FILE.LOG,' ');
489: fnd_file.put_line(FND_FILE.LOG,' ');

Line 486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');

482: fnd_file.put_line(FND_FILE.OUTPUT,' ');
483: fnd_file.put_line(FND_FILE.OUTPUT,' ');
484:
485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');
487: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
488: fnd_file.put_line(FND_FILE.LOG,' ');
489: fnd_file.put_line(FND_FILE.LOG,' ');
490:

Line 487: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');

483: fnd_file.put_line(FND_FILE.OUTPUT,' ');
484:
485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');
487: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
488: fnd_file.put_line(FND_FILE.LOG,' ');
489: fnd_file.put_line(FND_FILE.LOG,' ');
490:
491: l_no_data_found := 'Y';

Line 488: fnd_file.put_line(FND_FILE.LOG,' ');

484:
485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');
487: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
488: fnd_file.put_line(FND_FILE.LOG,' ');
489: fnd_file.put_line(FND_FILE.LOG,' ');
490:
491: l_no_data_found := 'Y';
492:

Line 489: fnd_file.put_line(FND_FILE.LOG,' ');

485: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
486: fnd_file.put_line(FND_FILE.LOG,' Migration Details ');
487: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
488: fnd_file.put_line(FND_FILE.LOG,' ');
489: fnd_file.put_line(FND_FILE.LOG,' ');
490:
491: l_no_data_found := 'Y';
492:
493: -- Setup the balance Table

Line 525: fnd_file.put_line(FND_FILE.LOG,' ');

521: FOR v_org IN c_get_org_details(p_bg_id,l_p45_migrated) LOOP
522: BEGIN
523:
524:
525: fnd_file.put_line(FND_FILE.LOG,' ');
526: fnd_file.put_line(FND_FILE.LOG,' ');
527: fnd_file.put_line(FND_FILE.LOG,' Migration Details for Org '||v_org.org_information8);
528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
529:

Line 526: fnd_file.put_line(FND_FILE.LOG,' ');

522: BEGIN
523:
524:
525: fnd_file.put_line(FND_FILE.LOG,' ');
526: fnd_file.put_line(FND_FILE.LOG,' ');
527: fnd_file.put_line(FND_FILE.LOG,' Migration Details for Org '||v_org.org_information8);
528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
529:
530: fnd_file.put_line(FND_FILE.LOG,' ');

Line 527: fnd_file.put_line(FND_FILE.LOG,' Migration Details for Org '||v_org.org_information8);

523:
524:
525: fnd_file.put_line(FND_FILE.LOG,' ');
526: fnd_file.put_line(FND_FILE.LOG,' ');
527: fnd_file.put_line(FND_FILE.LOG,' Migration Details for Org '||v_org.org_information8);
528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
529:
530: fnd_file.put_line(FND_FILE.LOG,' ');
531: fnd_file.put_line(FND_FILE.LOG,'Organization Level Migartion Details');

Line 528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');

524:
525: fnd_file.put_line(FND_FILE.LOG,' ');
526: fnd_file.put_line(FND_FILE.LOG,' ');
527: fnd_file.put_line(FND_FILE.LOG,' Migration Details for Org '||v_org.org_information8);
528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
529:
530: fnd_file.put_line(FND_FILE.LOG,' ');
531: fnd_file.put_line(FND_FILE.LOG,'Organization Level Migartion Details');
532: fnd_file.put_line(FND_FILE.LOG,' ');

Line 530: fnd_file.put_line(FND_FILE.LOG,' ');

526: fnd_file.put_line(FND_FILE.LOG,' ');
527: fnd_file.put_line(FND_FILE.LOG,' Migration Details for Org '||v_org.org_information8);
528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
529:
530: fnd_file.put_line(FND_FILE.LOG,' ');
531: fnd_file.put_line(FND_FILE.LOG,'Organization Level Migartion Details');
532: fnd_file.put_line(FND_FILE.LOG,' ');
533:
534: IF l_no_data_found = 'Y' THEN

Line 531: fnd_file.put_line(FND_FILE.LOG,'Organization Level Migartion Details');

527: fnd_file.put_line(FND_FILE.LOG,' Migration Details for Org '||v_org.org_information8);
528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
529:
530: fnd_file.put_line(FND_FILE.LOG,' ');
531: fnd_file.put_line(FND_FILE.LOG,'Organization Level Migartion Details');
532: fnd_file.put_line(FND_FILE.LOG,' ');
533:
534: IF l_no_data_found = 'Y' THEN
535: l_no_data_found := 'N';

Line 532: fnd_file.put_line(FND_FILE.LOG,' ');

528: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------------------------------------------');
529:
530: fnd_file.put_line(FND_FILE.LOG,' ');
531: fnd_file.put_line(FND_FILE.LOG,'Organization Level Migartion Details');
532: fnd_file.put_line(FND_FILE.LOG,' ');
533:
534: IF l_no_data_found = 'Y' THEN
535: l_no_data_found := 'N';
536: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad('Org Id',7),20)||' '||rpad('Name',40)||' '||rpad('Paye Ref Number',15)||' '||rpad('Migrated',10));

Line 536: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad('Org Id',7),20)||' '||rpad('Name',40)||' '||rpad('Paye Ref Number',15)||' '||rpad('Migrated',10));

532: fnd_file.put_line(FND_FILE.LOG,' ');
533:
534: IF l_no_data_found = 'Y' THEN
535: l_no_data_found := 'N';
536: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad('Org Id',7),20)||' '||rpad('Name',40)||' '||rpad('Paye Ref Number',15)||' '||rpad('Migrated',10));
537: fnd_file.put_line(FND_FILE.OUTPUT,' ');
538: END IF;
539:
540: -- If Employer is not migrated Call this 'NN'

Line 537: fnd_file.put_line(FND_FILE.OUTPUT,' ');

533:
534: IF l_no_data_found = 'Y' THEN
535: l_no_data_found := 'N';
536: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad('Org Id',7),20)||' '||rpad('Name',40)||' '||rpad('Paye Ref Number',15)||' '||rpad('Migrated',10));
537: fnd_file.put_line(FND_FILE.OUTPUT,' ');
538: END IF;
539:
540: -- If Employer is not migrated Call this 'NN'
541:

Line 545: fnd_file.put_line(FND_FILE.LOG,'Organization Name => '|| v_org.org_information8);

541:
542: IF v_org.migrated_flag = 'NN' THEN
543:
544: l_stage := 'Create Organization ' ||v_org.org_information8 ;
545: fnd_file.put_line(FND_FILE.LOG,'Organization Name => '|| v_org.org_information8);
546: fnd_file.put_line(FND_FILE.LOG,'Date From => '|| v_org.date_from);
547: fnd_file.put_line(FND_FILE.LOG,'Date To => '|| v_org.date_to);
548: fnd_file.put_line(FND_FILE.LOG,'Int Or Ext Flag => '|| v_org.internal_external_flag);
549:

Line 546: fnd_file.put_line(FND_FILE.LOG,'Date From => '|| v_org.date_from);

542: IF v_org.migrated_flag = 'NN' THEN
543:
544: l_stage := 'Create Organization ' ||v_org.org_information8 ;
545: fnd_file.put_line(FND_FILE.LOG,'Organization Name => '|| v_org.org_information8);
546: fnd_file.put_line(FND_FILE.LOG,'Date From => '|| v_org.date_from);
547: fnd_file.put_line(FND_FILE.LOG,'Date To => '|| v_org.date_to);
548: fnd_file.put_line(FND_FILE.LOG,'Int Or Ext Flag => '|| v_org.internal_external_flag);
549:
550: -- Create new Organization

Line 547: fnd_file.put_line(FND_FILE.LOG,'Date To => '|| v_org.date_to);

543:
544: l_stage := 'Create Organization ' ||v_org.org_information8 ;
545: fnd_file.put_line(FND_FILE.LOG,'Organization Name => '|| v_org.org_information8);
546: fnd_file.put_line(FND_FILE.LOG,'Date From => '|| v_org.date_from);
547: fnd_file.put_line(FND_FILE.LOG,'Date To => '|| v_org.date_to);
548: fnd_file.put_line(FND_FILE.LOG,'Int Or Ext Flag => '|| v_org.internal_external_flag);
549:
550: -- Create new Organization
551: HR_ORGANIZATION_API.create_organization(

Line 548: fnd_file.put_line(FND_FILE.LOG,'Int Or Ext Flag => '|| v_org.internal_external_flag);

544: l_stage := 'Create Organization ' ||v_org.org_information8 ;
545: fnd_file.put_line(FND_FILE.LOG,'Organization Name => '|| v_org.org_information8);
546: fnd_file.put_line(FND_FILE.LOG,'Date From => '|| v_org.date_from);
547: fnd_file.put_line(FND_FILE.LOG,'Date To => '|| v_org.date_to);
548: fnd_file.put_line(FND_FILE.LOG,'Int Or Ext Flag => '|| v_org.internal_external_flag);
549:
550: -- Create new Organization
551: HR_ORGANIZATION_API.create_organization(
552: p_validate => FALSE

Line 564: fnd_file.put_line(FND_FILE.LOG,'Organization Id => '|| p_org_id);

560: ,p_object_version_number => l_object_version_number
561: ,p_duplicate_org_warning => l_duplicate_org_warning
562: );
563:
564: fnd_file.put_line(FND_FILE.LOG,'Organization Id => '|| p_org_id);
565:
566: -- Attach classification Legal Employer
567: l_stage := 'Create Classification ' || v_org.org_information8;
568: HR_ORGANIZATION_API.create_org_class_internal(

Line 577: fnd_file.put_line(FND_FILE.LOG,'Classification => Legal Employer');

573: ,p_classification_enabled => 'Y'
574: ,p_org_information_id => l_org_information_id
575: ,p_object_version_number => l_object_version_number
576: );
577: fnd_file.put_line(FND_FILE.LOG,'Classification => Legal Employer');
578:
579: l_stage := 'Create Org Information ' || v_org.org_information8;
580: fnd_file.put_line(FND_FILE.LOG,'Information Type => IE_EMPLOYER_INFO');
581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);

Line 580: fnd_file.put_line(FND_FILE.LOG,'Information Type => IE_EMPLOYER_INFO');

576: );
577: fnd_file.put_line(FND_FILE.LOG,'Classification => Legal Employer');
578:
579: l_stage := 'Create Org Information ' || v_org.org_information8;
580: fnd_file.put_line(FND_FILE.LOG,'Information Type => IE_EMPLOYER_INFO');
581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);
582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);
583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);
584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);

Line 581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);

577: fnd_file.put_line(FND_FILE.LOG,'Classification => Legal Employer');
578:
579: l_stage := 'Create Org Information ' || v_org.org_information8;
580: fnd_file.put_line(FND_FILE.LOG,'Information Type => IE_EMPLOYER_INFO');
581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);
582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);
583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);
584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);
585: fnd_file.put_line(FND_FILE.LOG,' ');

Line 582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);

578:
579: l_stage := 'Create Org Information ' || v_org.org_information8;
580: fnd_file.put_line(FND_FILE.LOG,'Information Type => IE_EMPLOYER_INFO');
581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);
582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);
583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);
584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,' ');

Line 583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);

579: l_stage := 'Create Org Information ' || v_org.org_information8;
580: fnd_file.put_line(FND_FILE.LOG,'Information Type => IE_EMPLOYER_INFO');
581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);
582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);
583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);
584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,' ');
587:

Line 584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);

580: fnd_file.put_line(FND_FILE.LOG,'Information Type => IE_EMPLOYER_INFO');
581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);
582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);
583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);
584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,' ');
587:
588: -- Create new extra Information for the Legal Employer

Line 585: fnd_file.put_line(FND_FILE.LOG,' ');

581: fnd_file.put_line(FND_FILE.LOG,'Tax District Number => '|| v_org.Org_Information1);
582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);
583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);
584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,' ');
587:
588: -- Create new extra Information for the Legal Employer
589: HR_ORGanization_api.create_org_information(

Line 586: fnd_file.put_line(FND_FILE.LOG,' ');

582: fnd_file.put_line(FND_FILE.LOG,'PAYE Ref Number => '|| v_org.Org_Information2);
583: fnd_file.put_line(FND_FILE.LOG,'Employer Trade Name => '|| v_org.Org_Information9);
584: fnd_file.put_line(FND_FILE.LOG,'ER Tax Ref Contact => '|| v_org.Org_Information6);
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,' ');
587:
588: -- Create new extra Information for the Legal Employer
589: HR_ORGanization_api.create_org_information(
590: p_validate => FALSE,

Line 610: fnd_file.put_line(FND_FILE.LOG,'Payroll Level Migartion Details');

606: for v_payroll in c_get_payroll_details(p_bg_id,v_org.Org_Information1,v_org.Org_Information2) LOOP
607:
608: IF l_pay_found = 'N' THEN
609: l_pay_found := 'Y';
610: fnd_file.put_line(FND_FILE.LOG,'Payroll Level Migartion Details');
611: fnd_file.put_line(FND_FILE.LOG,' ');
612: END IF;
613: l_stage := 'Create Soft Coding Keyflex' || v_payroll.payroll_name;
614:

Line 611: fnd_file.put_line(FND_FILE.LOG,' ');

607:
608: IF l_pay_found = 'N' THEN
609: l_pay_found := 'Y';
610: fnd_file.put_line(FND_FILE.LOG,'Payroll Level Migartion Details');
611: fnd_file.put_line(FND_FILE.LOG,' ');
612: END IF;
613: l_stage := 'Create Soft Coding Keyflex' || v_payroll.payroll_name;
614:
615: fnd_file.put_line(FND_FILE.LOG,'Payroll Name => '|| v_payroll.payroll_name);

Line 615: fnd_file.put_line(FND_FILE.LOG,'Payroll Name => '|| v_payroll.payroll_name);

611: fnd_file.put_line(FND_FILE.LOG,' ');
612: END IF;
613: l_stage := 'Create Soft Coding Keyflex' || v_payroll.payroll_name;
614:
615: fnd_file.put_line(FND_FILE.LOG,'Payroll Name => '|| v_payroll.payroll_name);
616: fnd_file.put_line(FND_FILE.LOG,'Start Date => '|| v_payroll.effective_start_date);
617: fnd_file.put_line(FND_FILE.LOG,'End Date => '|| v_payroll.effective_end_date);
618:
619: hr_kflex_utility.ins_or_sel_keyflex_comb

Line 616: fnd_file.put_line(FND_FILE.LOG,'Start Date => '|| v_payroll.effective_start_date);

612: END IF;
613: l_stage := 'Create Soft Coding Keyflex' || v_payroll.payroll_name;
614:
615: fnd_file.put_line(FND_FILE.LOG,'Payroll Name => '|| v_payroll.payroll_name);
616: fnd_file.put_line(FND_FILE.LOG,'Start Date => '|| v_payroll.effective_start_date);
617: fnd_file.put_line(FND_FILE.LOG,'End Date => '|| v_payroll.effective_end_date);
618:
619: hr_kflex_utility.ins_or_sel_keyflex_comb
620: (p_appl_short_name => 'PER'

Line 617: fnd_file.put_line(FND_FILE.LOG,'End Date => '|| v_payroll.effective_end_date);

613: l_stage := 'Create Soft Coding Keyflex' || v_payroll.payroll_name;
614:
615: fnd_file.put_line(FND_FILE.LOG,'Payroll Name => '|| v_payroll.payroll_name);
616: fnd_file.put_line(FND_FILE.LOG,'Start Date => '|| v_payroll.effective_start_date);
617: fnd_file.put_line(FND_FILE.LOG,'End Date => '|| v_payroll.effective_end_date);
618:
619: hr_kflex_utility.ins_or_sel_keyflex_comb
620: (p_appl_short_name => 'PER'
621: ,p_flex_code => 'SCL'

Line 647: fnd_file.put_line(FND_FILE.LOG,'New Employer => '|| v_org.org_information8);

643: p_prl_effective_end_date => l_end_date,
644: p_comment_id => l_comment_id
645: );
646:
647: fnd_file.put_line(FND_FILE.LOG,'New Employer => '|| v_org.org_information8);
648:
649: l_asg_found := 'N';
650:
651: /* Assignment migration starts here */

Line 703: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad(p_org_id,7),20)||' '||rpad(v_org.org_information8,40)||' '|| rpad(v_org.Org_Information2,15)||' '||rpad('Yes',10));

699: -- If Employer is not migrated Ends here
700:
701: -- Migrate P35 for this Employer
702:
703: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad(p_org_id,7),20)||' '||rpad(v_org.org_information8,40)||' '|| rpad(v_org.Org_Information2,15)||' '||rpad('Yes',10));
704:
705: COMMIT;
706: -- ROLLBACK;
707:

Line 710: fnd_file.put_line(FND_FILE.LOG,' ');

706: -- ROLLBACK;
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: fnd_file.put_line(FND_FILE.LOG,' ');
711: fnd_file.put_line(FND_FILE.LOG,'Error in '||l_stage);
712: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
713: ROLLBACK;
714:

Line 711: fnd_file.put_line(FND_FILE.LOG,'Error in '||l_stage);

707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: fnd_file.put_line(FND_FILE.LOG,' ');
711: fnd_file.put_line(FND_FILE.LOG,'Error in '||l_stage);
712: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
713: ROLLBACK;
714:
715:

Line 712: fnd_file.put_line(FND_FILE.LOG,sqlerrm);

708: EXCEPTION
709: WHEN OTHERS THEN
710: fnd_file.put_line(FND_FILE.LOG,' ');
711: fnd_file.put_line(FND_FILE.LOG,'Error in '||l_stage);
712: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
713: ROLLBACK;
714:
715:
716: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad('*****',7),20)||' '||rpad(v_org.org_information8,40)||' '|| rpad(v_org.Org_Information2,15)||' '||rpad('No',10));

Line 716: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad('*****',7),20)||' '||rpad(v_org.org_information8,40)||' '|| rpad(v_org.Org_Information2,15)||' '||rpad('No',10));

712: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
713: ROLLBACK;
714:
715:
716: fnd_file.put_line(FND_FILE.OUTPUT,rpad(lpad('*****',7),20)||' '||rpad(v_org.org_information8,40)||' '|| rpad(v_org.Org_Information2,15)||' '||rpad('No',10));
717:
718: /* Set the program completion status to Warning */
719: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS
720: (

Line 732: fnd_file.put_line(FND_FILE.OUTPUT,'The data has been successfully migrated. There is no data to migrate.');

728: END LOOP;
729: /* Organization Migration Ends here */
730:
731: if l_no_data_found = 'Y' THEN
732: fnd_file.put_line(FND_FILE.OUTPUT,'The data has been successfully migrated. There is no data to migrate.');
733: end if;
734:
735:
736: END migrate_data;