DBA Data[Home] [Help]

APPS.PAY_FI_MTRR dependencies on HR_UTILITY

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

110: FETCH csr_get_data_source_name INTO l_data_source_code;
111: close csr_get_data_source_name;
112:
113:
114: hr_utility.set_location('Entered Procedure GETDATA',10);
115:
116: /* Pick up the details belonging to Local Unit */
117:
118: OPEN csr_mtrr_rpt( l_payroll_action_id);

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

190: l_subsidy_withhold_tax_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30)),'D99'))),2,2);
191:
192:
193:
194: hr_utility.set_location('Before populating pl/sql table',20);
195:
196: gtagdata(l_counter).TagName := 'TAX_PAYER_NAME';
197: gtagdata(l_counter).TagValue :=pay_fi_general.xml_parser(rg_mtrr_rpt.action_information5);
198: l_counter := l_counter + 1;

Line 705: hr_utility.set_location('After populating pl/sql table',30);

701: gtagdata(l_counter).TagName := 'SUM';
702: gtagdata(l_counter).TagValue := l_sum;
703: l_counter := l_counter + 1;
704:
705: hr_utility.set_location('After populating pl/sql table',30);
706: ELSIF l_data_source_code = 'PYFIMTRREFT' then
707:
708: SELECT trim(rg_mtrr_rpt.action_information4)||' '||trim(rg_mtrr_rpt.action_information4)
709: INTO l_Wage_payment_month

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

817:
818: BEGIN
819: l_IANA_charset :=hr_fi_utility.get_IANA_charset ;
820:
821: hr_utility.set_location('Entering WritetoCLOB ',70);
822:
823: l_str1 := ' ' ;
824: l_str2 := '<';
825: l_str3 := '>';

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

873: END IF;
874:
875: p_xfdf_clob := l_xfdf_string;
876:
877: hr_utility.set_location('Leaving WritetoCLOB ',40);
878:
879: EXCEPTION
880: WHEN OTHERS then
881: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

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

877: hr_utility.set_location('Leaving WritetoCLOB ',40);
878:
879: EXCEPTION
880: WHEN OTHERS then
881: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
882: HR_UTILITY.RAISE_ERROR;
883: END WritetoCLOB;
884: -------------------------------------------------------------------------------------------------------------------------
885:

Line 882: HR_UTILITY.RAISE_ERROR;

878:
879: EXCEPTION
880: WHEN OTHERS then
881: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
882: HR_UTILITY.RAISE_ERROR;
883: END WritetoCLOB;
884: -------------------------------------------------------------------------------------------------------------------------
885:
886: END PAY_FI_MTRR;