DBA Data[Home] [Help]

APPS.PAY_US_ONLINE_W4_XML_PKG dependencies on HR_UTILITY

Line 132: --hr_utility.trace_on (NULL, 'pyw4xmlp');

128: l_last_name_flag VARCHAR2 (1);
129: l_date DATE;
130: l_signature VARCHAR2 (100);
131: BEGIN
132: --hr_utility.trace_on (NULL, 'pyw4xmlp');
133: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 10);
134: hr_utility.TRACE ('p_person_id: ' || p_person_id);
135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);

Line 133: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 10);

129: l_date DATE;
130: l_signature VARCHAR2 (100);
131: BEGIN
132: --hr_utility.trace_on (NULL, 'pyw4xmlp');
133: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 10);
134: hr_utility.TRACE ('p_person_id: ' || p_person_id);
135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);

Line 134: hr_utility.TRACE ('p_person_id: ' || p_person_id);

130: l_signature VARCHAR2 (100);
131: BEGIN
132: --hr_utility.trace_on (NULL, 'pyw4xmlp');
133: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 10);
134: hr_utility.TRACE ('p_person_id: ' || p_person_id);
135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);
138: hr_utility.TRACE ('p_template_code: ' || p_template_code);

Line 135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);

131: BEGIN
132: --hr_utility.trace_on (NULL, 'pyw4xmlp');
133: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 10);
134: hr_utility.TRACE ('p_person_id: ' || p_person_id);
135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);
138: hr_utility.TRACE ('p_template_code: ' || p_template_code);
139: hr_utility.TRACE ('p_default_language: ' || p_default_language);

Line 136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);

132: --hr_utility.trace_on (NULL, 'pyw4xmlp');
133: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 10);
134: hr_utility.TRACE ('p_person_id: ' || p_person_id);
135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);
138: hr_utility.TRACE ('p_template_code: ' || p_template_code);
139: hr_utility.TRACE ('p_default_language: ' || p_default_language);
140: hr_utility.TRACE ('p_default_territory: ' || p_default_territory);

Line 137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);

133: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 10);
134: hr_utility.TRACE ('p_person_id: ' || p_person_id);
135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);
138: hr_utility.TRACE ('p_template_code: ' || p_template_code);
139: hr_utility.TRACE ('p_default_language: ' || p_default_language);
140: hr_utility.TRACE ('p_default_territory: ' || p_default_territory);
141: l_count := 0;

Line 138: hr_utility.TRACE ('p_template_code: ' || p_template_code);

134: hr_utility.TRACE ('p_person_id: ' || p_person_id);
135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);
138: hr_utility.TRACE ('p_template_code: ' || p_template_code);
139: hr_utility.TRACE ('p_default_language: ' || p_default_language);
140: hr_utility.TRACE ('p_default_territory: ' || p_default_territory);
141: l_count := 0;
142:

Line 139: hr_utility.TRACE ('p_default_language: ' || p_default_language);

135: hr_utility.TRACE ('p_transaction_step_id: ' || p_transaction_step_id);
136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);
138: hr_utility.TRACE ('p_template_code: ' || p_template_code);
139: hr_utility.TRACE ('p_default_language: ' || p_default_language);
140: hr_utility.TRACE ('p_default_territory: ' || p_default_territory);
141: l_count := 0;
142:
143: OPEN c_get_personal_details (p_person_id);

Line 140: hr_utility.TRACE ('p_default_territory: ' || p_default_territory);

136: hr_utility.TRACE ('p_temp_dir: ' || p_temp_dir);
137: hr_utility.TRACE ('p_appl_short_name: ' || p_appl_short_name);
138: hr_utility.TRACE ('p_template_code: ' || p_template_code);
139: hr_utility.TRACE ('p_default_language: ' || p_default_language);
140: hr_utility.TRACE ('p_default_territory: ' || p_default_territory);
141: l_count := 0;
142:
143: OPEN c_get_personal_details (p_person_id);
144:

Line 152: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 20);

148: l_address_line3, l_city_state_zip;
149:
150: CLOSE c_get_personal_details;
151:
152: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 20);
153:
154: OPEN c_get_updated_values (p_transaction_step_id);
155:
156: FETCH c_get_updated_values

Line 162: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 30);

158: l_last_name_diff;
159:
160: CLOSE c_get_updated_values;
161:
162: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 30);
163:
164: OPEN c_get_lookup_codes (l_filing_status);
165:
166: FETCH c_get_lookup_codes

Line 171: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 40);

167: INTO l_filing_status_code;
168:
169: CLOSE c_get_lookup_codes;
170:
171: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 40);
172:
173: IF l_filing_status_code = '01'
174: THEN
175: l_fs_single := 'Y';

Line 183: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 50);

179: ELSE
180: l_fs_married_withhold := 'Y';
181: END IF;
182:
183: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 50);
184:
185: SELECT SYSDATE, TO_CHAR (SYSDATE, 'YYYY')
186: INTO l_date, l_year
187: FROM DUAL;

Line 319: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 60);

315: || p_default_territory
316: || '">';
317: l_xml_string := l_xml_string || '';
318: l_xml_string := l_xml_string || '';
319: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 60);
320:
321: FOR counter IN l_xml_data_table.FIRST .. l_xml_data_table.LAST
322: LOOP
323: l_xml_string :=

Line 335: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 70);

331: l_xml_string :=
332: l_xml_string
333: || '';
334: p_xml_string := l_xml_string;
335: hr_utility.set_location ('pay_us_online_w4_xml_pkg.generate_xml', 70);
336: END generate_xml;
337: END pay_us_online_w4_xml_pkg;