APPS.PAY_FI_PAYLIST dependencies on HR_UTILITY

Line 127: hr_utility.set_location ('Entered Procedure GETDATA', 10);

123: csr_total_REC csr_total%ROWTYPE;
124:
125: payl_rep csr_payl_data%ROWTYPE;
126: BEGIN
127: hr_utility.set_location ('Entered Procedure GETDATA', 10);
128: fnd_file.put_line (
129: fnd_file.LOG,
130: 'payroll_action_id '
131: || l_payroll_action_id

Line 144: hr_utility.set_location('Before populating pl/sql table',20);

140: OPEN CSR_HEADER( l_payroll_action_id);
141: FETCH CSR_HEADER INTO CSR_HEADER_REC;
142: CLOSE CSR_HEADER;
143:
144: hr_utility.set_location('Before populating pl/sql table',20);
145:
146: gplsqltable(l_counter).TagName := 'HEADER_START';
147: gplsqltable(l_counter).TagValue := 'HEADER_START';
148: l_counter := l_counter + 1;

Line 396: hr_utility.set_location ('Entering WritetoCLOB ', 70);

392: current_index pls_integer;
393: l_IANA_charset VARCHAR2 (50);
394: BEGIN
395: l_IANA_charset :=hr_fi_utility.get_IANA_charset ;
396: hr_utility.set_location ('Entering WritetoCLOB ', 70);
397: l_str1 := ' ';
398: l_str2 := '<';
399: l_str3 := '>';
400: l_str4 := '

Line 410: hr_utility.set_location('Entering WritetoCLOB ',70);

406:
407:
408: /*
409:
410: hr_utility.set_location('Entering WritetoCLOB ',70);
411: l_str1 := ' ' ;
412: l_str2 := '<';
413: l_str3 := '>';
414: l_str4 := '

Line 484: hr_utility.set_location('Leaving WritetoCLOB ',40);

480: END IF;
481:
482: p_xfdf_clob := l_xfdf_string;
483:
484: hr_utility.set_location('Leaving WritetoCLOB ',40);
485:
486: EXCEPTION
487: WHEN OTHERS then
488: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

Line 488: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

484: hr_utility.set_location('Leaving WritetoCLOB ',40);
485:
486: EXCEPTION
487: WHEN OTHERS then
488: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
489: HR_UTILITY.RAISE_ERROR;
490: END WritetoCLOB;
491:
492:

Line 489: HR_UTILITY.RAISE_ERROR;

485:
486: EXCEPTION
487: WHEN OTHERS then
488: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
489: HR_UTILITY.RAISE_ERROR;
490: END WritetoCLOB;
491:
492:
493: /* PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB)

Line 510: hr_utility.set_location ('Entering WritetoCLOB ', 70);

506: l_str11 VARCHAR2 (20);
507: current_index PLS_INTEGER;
508: l_counter PLS_INTEGER;
509: BEGIN
510: hr_utility.set_location ('Entering WritetoCLOB ', 70);
511: l_str1 := ' ';
512: l_str2 := '<';
513: l_str3 := '>';
514: l_str4 := '

Line 590: hr_utility.set_location ('Leaving WritetoCLOB ', 70);

586: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
587: END IF;
588:
589: p_xfdf_clob := l_xfdf_string;
590: hr_utility.set_location ('Leaving WritetoCLOB ', 70);
591: hr_utility.set_location ('Leaving WritetoCLOB ', 70);
592: --INSERT INTO CLOBTABLE VALUES(p_xfdf_clob,'PAYL');
593: --COMMIT;
594: EXCEPTION

Line 591: hr_utility.set_location ('Leaving WritetoCLOB ', 70);

587: END IF;
588:
589: p_xfdf_clob := l_xfdf_string;
590: hr_utility.set_location ('Leaving WritetoCLOB ', 70);
591: hr_utility.set_location ('Leaving WritetoCLOB ', 70);
592: --INSERT INTO CLOBTABLE VALUES(p_xfdf_clob,'PAYL');
593: --COMMIT;
594: EXCEPTION
595: WHEN OTHERS

Line 597: hr_utility.TRACE ( 'sqlerrm '

593: --COMMIT;
594: EXCEPTION
595: WHEN OTHERS
596: THEN
597: hr_utility.TRACE ( 'sqlerrm '
598: || SQLERRM);
599: hr_utility.raise_error;
600: END writetoclob;
601: */

Line 599: hr_utility.raise_error;

595: WHEN OTHERS
596: THEN
597: hr_utility.TRACE ( 'sqlerrm '
598: || SQLERRM);
599: hr_utility.raise_error;
600: END writetoclob;
601: */
602: -------------------------------------------------------------------------------------------------------------------------
603: END PAY_FI_PAYLIST;