APPS.PAY_US_CUSTOM_SQWL_FORMAT_REC dependencies on HR_UTILITY

Line 162: hr_utility.trace('Custom Employer Record Formatting started ');

158: r_input_39 varchar2(300);
159:
160: p_end_of_rec varchar2(20) := fnd_global.local_chr(13)||fnd_global.local_chr(10);
161: BEGIN
162: hr_utility.trace('Custom Employer Record Formatting started ');
163: -- Initializing local variables with parameter value
164: --{
165: r_input_2 := p_input_2;
166: r_input_3 := p_input_3;

Line 317: hr_utility.trace('Length of return value = '||to_char(length(return_value)));

313: END IF;-- p_report_qualifier
314: END IF;
315: p_error := l_exclude_from_output_chk;
316: ret_str_len:=length(return_value);
317: hr_utility.trace('Length of return value = '||to_char(length(return_value)));
318: return return_value;
319: END format_SQWL_CUSTOM_EMPLOYER; -- End of Function Formatting Custom Employer record
320:
321: /* ------------ Parameter mapping for SQWL Custom Employee Record -------------

Line 520: hr_utility.trace('Formatting Custom Employee record for SQWL ');

516: r_input_38 varchar2(300);
517: r_input_39 varchar2(300);
518:
519: BEGIN
520: hr_utility.trace('Formatting Custom Employee record for SQWL ');
521: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
522: -- Initializing local variables with parameter value
523: --{
524: r_input_2 := p_input_2;

Line 521: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);

517: r_input_39 varchar2(300);
518:
519: BEGIN
520: hr_utility.trace('Formatting Custom Employee record for SQWL ');
521: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
522: -- Initializing local variables with parameter value
523: --{
524: r_input_2 := p_input_2;
525: r_input_3 := p_input_3;

Line 617: hr_utility.trace('SSN after Validation and Formatting = '||l_ssn);

613: ELSE
614: l_ssn := replace(replace(r_input_5,'-'),',');
615: END IF;
616:
617: hr_utility.trace('SSN after Validation and Formatting = '||l_ssn);
618:
619: /*Pos:24 - 48 Last name
620: Pos:49 - 63 First name
621: Pos:64 - 64 Middle name

Line 703: hr_utility.trace('Length of return value = '||to_char(length(return_value)));

699: ||r_input_14
700: ||r_input_15
701: |l_end_of_rec;
702:
703: hr_utility.trace('Length of return value = '||to_char(length(return_value)));
704: --} End of formatting FLAT Type RS Record
705: ELS
706: */
707: /* end of Bug # 4554387*/

Line 781: hr_utility.trace('Length of return value = '||to_char(length(return_value)));

777: END IF;-- p_report_qualifier
778: END IF; -- p_record_name
779: p_error := l_exclude_from_output_chk;
780: ret_str_len:=length(return_value);
781: hr_utility.trace('Length of return value = '||to_char(length(return_value)));
782: return return_value;
783: END format_SQWL_CUSTOM_EMPLOYEE;
784: -- End of Formatting Custom Employee Record for SQWL Reporting
785: