DBA Data[Home] [Help]

APPS.PAY_US_FS_UPD_PKG dependencies on PAY_US_FS_UPD_PKG

Line 1: PACKAGE BODY pay_us_fs_upd_pkg as

1: PACKAGE BODY pay_us_fs_upd_pkg as
2: /* $Header: pyusfsup.pkb 120.0 2005/05/29 09:30 appldev noship $ */
3:
4:
5:

Line 86: hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');

82: BEGIN
83:
84: l_bug_no := 2735805 ;
85:
86: hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');
87:
88: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_start));
89: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_end));
90:

Line 101: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',1);

97: LOOP
98: FETCH filing_status_cur into filing_status_rec;
99: EXIT WHEN filing_status_cur%NOTFOUND;
100:
101: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',1);
102:
103:
104: IF filing_status_rec.state_code = '03' and
105: filing_status_rec.filing_status_code in ( '04', '03', '02' )

Line 735: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',40);

731:
732: END IF;
733: commit;
734:
735: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',40);
736:
737: END LOOP ;
738: CLOSE filing_status_cur ;
739:

Line 740: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',45);

736:
737: END LOOP ;
738: CLOSE filing_status_cur ;
739:
740: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',45);
741:
742: EXCEPTION
743: WHEN OTHERS THEN
744: l_error_message_text := to_char(SQLCODE)||SQLERRM||

Line 748: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',50);

744: l_error_message_text := to_char(SQLCODE)||SQLERRM||
745: ' Program error contact support';
746: rollback;
747:
748: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',50);
749: raise_application_error(-20001,l_error_message_text);
750:
751: --
752: --

Line 761: END pay_us_fs_upd_pkg;

757: --
758: --
759: --
760:
761: END pay_us_fs_upd_pkg;
762: