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_NL_ABP_ARCHIVE dependencies on FND_FILE

Line 576: fnd_file.put_line(fnd_file.log,'...Termination Date found : ');

572: CLOSE csr_get_term_date;
573: RETURN FALSE;
574: ELSE
575: CLOSE csr_get_term_date;
576: fnd_file.put_line(fnd_file.log,'...Termination Date found : ');
577: IF to_number(to_char(nvl(l_asg_term_dt,p_ext_st),'YYYY')) <
578: to_number(to_char(p_ext_st,'YYYY')) THEN
579: hr_utility.trace('...Condition met return TRUE : ');
580: RETURN TRUE;

Line 2154: fnd_file.put_line(fnd_file.log,'l_beg_new_st is '||l_beg_new_st);

2150: --
2151: WHILE trunc(l_beg_new_st) < l_loop_end_date
2152: LOOP
2153:
2154: fnd_file.put_line(fnd_file.log,'l_beg_new_st is '||l_beg_new_st);
2155: fnd_file.put_line(fnd_file.log,'l_end_new_st is '||l_end_new_st);
2156: --
2157: -- First fetch the maximum assignment action id
2158: --

Line 2155: fnd_file.put_line(fnd_file.log,'l_end_new_st is '||l_end_new_st);

2151: WHILE trunc(l_beg_new_st) < l_loop_end_date
2152: LOOP
2153:
2154: fnd_file.put_line(fnd_file.log,'l_beg_new_st is '||l_beg_new_st);
2155: fnd_file.put_line(fnd_file.log,'l_end_new_st is '||l_end_new_st);
2156: --
2157: -- First fetch the maximum assignment action id
2158: --
2159: OPEN csr_asg_act1 (

Line 4652: fnd_file.put_line(fnd_file.log,'+====deinitialization_code====+ '|| p_payroll_action_id);

4648: empe_flag VARCHAR2(1);
4649: l_exception_flag VARCHAR2(1);
4650:
4651: BEGIN
4652: fnd_file.put_line(fnd_file.log,'+====deinitialization_code====+ '|| p_payroll_action_id);
4653: --
4654: empr_flag := 'N';
4655: empe_flag := 'N';
4656: l_exception_flag := 'N';

Line 4796: fnd_file.put_line(fnd_file.log,'....No value found at HR org level,searching up the tree');

4792: --
4793: CLOSE csr_get_er_details;
4794: -- Value not found at this org level,traverse up the
4795: -- org hierarchy to find a value at the parent level
4796: fnd_file.put_line(fnd_file.log,'....No value found at HR org level,searching up the tree');
4797:
4798: l_version_id := pqp_pension_functions.get_version_id(l_bg_id,l_end_date);
4799:
4800: fnd_file.put_line(fnd_file.log,' l_version_id '||l_version_id);

Line 4800: fnd_file.put_line(fnd_file.log,' l_version_id '||l_version_id);

4796: fnd_file.put_line(fnd_file.log,'....No value found at HR org level,searching up the tree');
4797:
4798: l_version_id := pqp_pension_functions.get_version_id(l_bg_id,l_end_date);
4799:
4800: fnd_file.put_line(fnd_file.log,' l_version_id '||l_version_id);
4801:
4802: IF l_version_id = -99 THEN
4803: l_er_num := '000000000';
4804: END IF;

Line 4814: fnd_file.put_line(fnd_file.log,'searching at parent : '||l_org_id);

4810: -- Find the parent of this org
4811: OPEN csr_find_parent_id(l_org_id,l_version_id,l_bg_id);
4812: FETCH csr_find_parent_id INTO l_org_id;
4813: IF csr_find_parent_id%FOUND THEN
4814: fnd_file.put_line(fnd_file.log,'searching at parent : '||l_org_id);
4815: CLOSE csr_find_parent_id;
4816: OPEN csr_get_er_details(l_org_id);
4817: FETCH csr_get_er_details INTO l_er_num,l_freq,l_ref_er;
4818: IF csr_get_er_details%FOUND THEN

Line 4898: fnd_file.put_line (fnd_file.output, csr_exception_rec.message);

4894:
4895: -- Bug 14793405
4896: FOR csr_exception_rec IN csr_get_tech_exception_info (p_payroll_action_id) LOOP
4897:
4898: fnd_file.put_line (fnd_file.output, csr_exception_rec.message);
4899:
4900: END LOOP;
4901: -- 14793405
4902:

Line 4903: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));

4899:
4900: END LOOP;
4901: -- 14793405
4902:
4903: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));
4904: FND_FILE.PUT_LINE(fnd_file.output,rpad(' ',180,' '));
4905: --
4906: FOR csr_exception_rec IN csr_get_PA_exception_info(p_payroll_action_id) LOOP
4907: --

Line 4904: FND_FILE.PUT_LINE(fnd_file.output,rpad(' ',180,' '));

4900: END LOOP;
4901: -- 14793405
4902:
4903: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));
4904: FND_FILE.PUT_LINE(fnd_file.output,rpad(' ',180,' '));
4905: --
4906: FOR csr_exception_rec IN csr_get_PA_exception_info(p_payroll_action_id) LOOP
4907: --
4908: l_exception_flag := 'Y' ;

Line 4911: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

4907: --
4908: l_exception_flag := 'Y' ;
4909: IF empr_flag = 'N' THEN
4910: --
4911: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4912: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
4913: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
4914: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4915: empr_flag :='Y';

Line 4912: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||

4908: l_exception_flag := 'Y' ;
4909: IF empr_flag = 'N' THEN
4910: --
4911: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4912: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
4913: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
4914: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4915: empr_flag :='Y';
4916: --

Line 4914: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

4910: --
4911: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4912: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EMPLOYER_NAME'),32,' ') ||
4913: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),148,' '));
4914: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4915: empr_flag :='Y';
4916: --
4917: END IF;
4918: --

Line 4919: FND_FILE.PUT_LINE(fnd_file.output,rpad(csr_exception_rec.E_Name,32,' ') || csr_exception_rec.Message);

4915: empr_flag :='Y';
4916: --
4917: END IF;
4918: --
4919: FND_FILE.PUT_LINE(fnd_file.output,rpad(csr_exception_rec.E_Name,32,' ') || csr_exception_rec.Message);
4920: --
4921:
4922: END LOOP;
4923: --

Line 4930: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

4926: l_exception_flag := 'Y' ;
4927: --
4928: IF empe_flag = 'N' THEN
4929: --
4930: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4932: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),45,' ') ||
4933: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

Line 4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||

4927: --
4928: IF empe_flag = 'N' THEN
4929: --
4930: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4932: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),45,' ') ||
4933: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4935: empe_flag := 'Y';

Line 4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

4930: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4931: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
4932: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_NAME'),45,' ') ||
4933: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),113,' '));
4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4935: empe_flag := 'Y';
4936: END IF;
4937: --
4938: FND_FILE.PUT_LINE(fnd_file.output,rpad(substr(csr_exception_rec.E_Number,1,20),22,' ') || rpad(csr_exception_rec.E_name,45,' ') || csr_exception_rec.Message);

Line 4938: FND_FILE.PUT_LINE(fnd_file.output,rpad(substr(csr_exception_rec.E_Number,1,20),22,' ') || rpad(csr_exception_rec.E_name,45,' ') || csr_exception_rec.Message);

4934: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
4935: empe_flag := 'Y';
4936: END IF;
4937: --
4938: FND_FILE.PUT_LINE(fnd_file.output,rpad(substr(csr_exception_rec.E_Number,1,20),22,' ') || rpad(csr_exception_rec.E_name,45,' ') || csr_exception_rec.Message);
4939: --
4940: END LOOP;
4941: --
4942: IF l_exception_flag = 'N' THEN

Line 4943: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));

4939: --
4940: END LOOP;
4941: --
4942: IF l_exception_flag = 'N' THEN
4943: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));
4944: END IF;
4945:
4946: fnd_file.put_line(fnd_file.log,'X====deinitialization_code============X '||p_payroll_action_id);
4947:

Line 4946: fnd_file.put_line(fnd_file.log,'X====deinitialization_code============X '||p_payroll_action_id);

4942: IF l_exception_flag = 'N' THEN
4943: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','WR_NO_VALIDATION_ERRORS'));
4944: END IF;
4945:
4946: fnd_file.put_line(fnd_file.log,'X====deinitialization_code============X '||p_payroll_action_id);
4947:
4948: EXCEPTION
4949: WHEN OTHERS THEN
4950: fnd_file.put_line(fnd_file.log,'deinitialization_code :'||SQLERRM);

Line 4950: fnd_file.put_line(fnd_file.log,'deinitialization_code :'||SQLERRM);

4946: fnd_file.put_line(fnd_file.log,'X====deinitialization_code============X '||p_payroll_action_id);
4947:
4948: EXCEPTION
4949: WHEN OTHERS THEN
4950: fnd_file.put_line(fnd_file.log,'deinitialization_code :'||SQLERRM);
4951: log_tech_exception(p_action_context_id => p_payroll_action_id,
4952: p_err_msg => 'deinitialization_code : '|| substr (sqlerrm, 1, 180)); --14793405
4953:
4954: END deinitialization_code;