DBA Data[Home] [Help]

APPS.PAY_NZ_EDF dependencies on HR_UTILITY

Line 54: g_debug := hr_utility.debug_enabled;

50: l_proc_name VARCHAR2(100) := g_proc_name ||'range_code';
51:
52: BEGIN
53:
54: g_debug := hr_utility.debug_enabled;
55:
56: IF g_debug THEN
57: hr_utility.set_location('Entering : '||l_proc_name, 10);
58: END if;

Line 57: hr_utility.set_location('Entering : '||l_proc_name, 10);

53:
54: g_debug := hr_utility.debug_enabled;
55:
56: IF g_debug THEN
57: hr_utility.set_location('Entering : '||l_proc_name, 10);
58: END if;
59:
60: p_sql := ' select distinct p.person_id' ||
61: ' from per_people_f p,' ||

Line 67: hr_utility.set_location('Leaving : '||l_proc_name, 20);

63: ' where pa.payroll_action_id = :payroll_action_id' ||
64: ' and p.business_group_id = pa.business_group_id' ||
65: ' order by p.person_id';
66:
67: hr_utility.set_location('Leaving : '||l_proc_name, 20);
68:
69: END range_code;
70:
71: /*

Line 97: g_debug := hr_utility.debug_enabled;

93:
94: l_proc_name VARCHAR2(100) := g_proc_name ||'assignment_action_code';
95:
96: BEGIN
97: g_debug := hr_utility.debug_enabled;
98:
99: IF g_debug THEN
100: hr_utility.set_location('Entering : '||l_proc_name, 10);
101: END IF;

Line 100: hr_utility.set_location('Entering : '||l_proc_name, 10);

96: BEGIN
97: g_debug := hr_utility.debug_enabled;
98:
99: IF g_debug THEN
100: hr_utility.set_location('Entering : '||l_proc_name, 10);
101: END IF;
102:
103: IF g_debug THEN
104: hr_utility.set_location('Leaving : '||l_proc_name, 20);

Line 104: hr_utility.set_location('Leaving : '||l_proc_name, 20);

100: hr_utility.set_location('Entering : '||l_proc_name, 10);
101: END IF;
102:
103: IF g_debug THEN
104: hr_utility.set_location('Leaving : '||l_proc_name, 20);
105: END IF;
106:
107: END assignment_action_code;
108:

Line 127: g_debug := hr_utility.debug_enabled;

123: l_proc_name varchar2(100) := g_proc_name ||'load_xml';
124: l_data varchar2(500);
125: BEGIN
126:
127: g_debug := hr_utility.debug_enabled;
128:
129: IF g_debug THEN
130: hr_utility.set_location('Entering : '||l_proc_name, 10);
131: END IF;

Line 130: hr_utility.set_location('Entering : '||l_proc_name, 10);

126:
127: g_debug := hr_utility.debug_enabled;
128:
129: IF g_debug THEN
130: hr_utility.set_location('Entering : '||l_proc_name, 10);
131: END IF;
132:
133: IF p_node_type = 'CS' THEN
134: pay_core_files.write_to_magtape_lob('<'||p_node||'>');

Line 147: hr_utility.set_location('Leaving : '||l_proc_name, 20);

143: pay_core_files.write_to_magtape_lob('<'||p_node||'>'||l_data||'');
144: END IF;
145:
146: IF g_debug THEN
147: hr_utility.set_location('Leaving : '||l_proc_name, 20);
148: END IF;
149:
150: END load_xml;
151:

Line 166: g_debug := hr_utility.debug_enabled;

162: PROCEDURE generate_header_xml
163: IS
164: l_proc_name varchar2(100) := g_proc_name ||'generate_header_xml';
165: BEGIN
166: g_debug := hr_utility.debug_enabled;
167:
168: IF g_debug THEN
169: hr_utility.set_location('Entering : '||l_proc_name, 10);
170: END IF;

Line 169: hr_utility.set_location('Entering : '||l_proc_name, 10);

165: BEGIN
166: g_debug := hr_utility.debug_enabled;
167:
168: IF g_debug THEN
169: hr_utility.set_location('Entering : '||l_proc_name, 10);
170: END IF;
171:
172: load_xml('CS','PYNZEDF','');
173:

Line 175: hr_utility.set_location('Leaving : '||l_proc_name, 20);

171:
172: load_xml('CS','PYNZEDF','');
173:
174: IF g_debug THEN
175: hr_utility.set_location('Leaving : '||l_proc_name, 20);
176: END IF;
177:
178: END generate_header_xml;
179:

Line 194: g_debug := hr_utility.debug_enabled;

190: PROCEDURE generate_footer_xml
191: IS
192: l_proc_name varchar2(100) := g_proc_name ||'generate_footer_xml';
193: BEGIN
194: g_debug := hr_utility.debug_enabled;
195:
196: IF g_debug THEN
197: hr_utility.set_location('Entering : '||l_proc_name, 10);
198: END IF;

Line 197: hr_utility.set_location('Entering : '||l_proc_name, 10);

193: BEGIN
194: g_debug := hr_utility.debug_enabled;
195:
196: IF g_debug THEN
197: hr_utility.set_location('Entering : '||l_proc_name, 10);
198: END IF;
199:
200: load_xml('CE','PYNZEDF','');
201:

Line 203: hr_utility.set_location('Leaving : '||l_proc_name, 20);

199:
200: load_xml('CE','PYNZEDF','');
201:
202: IF g_debug THEN
203: hr_utility.set_location('Leaving : '||l_proc_name, 20);
204: END IF;
205:
206: END generate_footer_xml;
207:

Line 371: g_debug := hr_utility.debug_enabled;

367: i.org_information1;
368:
369: BEGIN
370:
371: g_debug := hr_utility.debug_enabled;
372:
373: IF g_debug THEN
374: hr_utility.set_location('Entering : '||l_proc_name, 10);
375: END IF;

Line 374: hr_utility.set_location('Entering : '||l_proc_name, 10);

370:
371: g_debug := hr_utility.debug_enabled;
372:
373: IF g_debug THEN
374: hr_utility.set_location('Entering : '||l_proc_name, 10);
375: END IF;
376:
377: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
378:

Line 455: hr_utility.set_location('Leaving : '||l_proc_name, 20);

451: load_xml('D','KS_ER_DED',l_ks_employer_ded - l_esct_ded);
452: load_xml('CE','G_ER_DATA','');
453:
454: IF g_debug THEN
455: hr_utility.set_location('Leaving : '||l_proc_name, 20);
456: END IF;
457:
458: EXCEPTION
459: WHEN OTHERS THEN

Line 461: hr_utility.set_location('Error in '||l_proc_name||' : '||SQLERRM,100);

457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: IF g_debug THEN
461: hr_utility.set_location('Error in '||l_proc_name||' : '||SQLERRM,100);
462: hr_utility.set_location('Leaving : '||l_proc_name, 100);
463: END IF;
464: RAISE;
465:

Line 462: hr_utility.set_location('Leaving : '||l_proc_name, 100);

458: EXCEPTION
459: WHEN OTHERS THEN
460: IF g_debug THEN
461: hr_utility.set_location('Error in '||l_proc_name||' : '||SQLERRM,100);
462: hr_utility.set_location('Leaving : '||l_proc_name, 100);
463: END IF;
464: RAISE;
465:
466: END generate_detail_xml;