DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE dependencies on HR_UTILITY

Line 140: hr_utility.set_location(l_proc_name || ' Start of assignment_action_code',30);

136: l_proc_name := l_package || 'assignment_action_code';
137: pay_sg_cpfline.initialization_code(p_payroll_action_id) ;
138: --
139: if g_debug then
140: hr_utility.set_location(l_proc_name || ' Start of assignment_action_code',30);
141: end if;
142: --
143: for i in c_assact
144: loop

Line 150: hr_utility.set_location(l_proc_name|| ' Before calling hr_nonrun_asact.insact',30);

146: fetch next_action_id into l_next_action_id;
147: close next_action_id;
148: --
149: if g_debug then
150: hr_utility.set_location(l_proc_name|| ' Before calling hr_nonrun_asact.insact',30);
151: end if;
152: --
153: hr_nonrun_asact.insact( l_next_action_id,
154: i.assignment_id,

Line 160: hr_utility.set_location(l_proc_name||' After calling hr_nonrun_asact.insact',30);

156: p_chunk,
157: g_pact.legal_entity_id );
158: --
159: if g_debug then
160: hr_utility.set_location(l_proc_name||' After calling hr_nonrun_asact.insact',30);
161: end if;
162: --
163: end loop;
164: --

Line 166: hr_utility.set_location(l_proc_name|| ' End of assignment_action_code',30);

162: --
163: end loop;
164: --
165: if g_debug then
166: hr_utility.set_location(l_proc_name|| ' End of assignment_action_code',30);
167: end if;
168: exception
169: when others then
170: if g_debug then

Line 171: hr_utility.set_location(l_proc_name||' Error raised in assignment_action_code procedure',30);

167: end if;
168: exception
169: when others then
170: if g_debug then
171: hr_utility.set_location(l_proc_name||' Error raised in assignment_action_code procedure',30);
172: end if;
173: raise;
174: end assignment_action_code ;
175: ------------------------------------------------------------

Line 185: g_debug := hr_utility.debug_enabled;

181:
182: begin
183: l_package := ' pay_sg_cpfline.';
184: l_proc_name := l_package || 'initialization_code';
185: g_debug := hr_utility.debug_enabled;
186: --
187: if g_debug then
188: hr_utility.set_location(l_proc_name||' Start of initialization_code',20);
189: end if;

Line 188: hr_utility.set_location(l_proc_name||' Start of initialization_code',20);

184: l_proc_name := l_package || 'initialization_code';
185: g_debug := hr_utility.debug_enabled;
186: --
187: if g_debug then
188: hr_utility.set_location(l_proc_name||' Start of initialization_code',20);
189: end if;
190: --
191: if g_pact.report_type is null then
192: select ppa.report_type,

Line 208: hr_utility.set_location(l_proc_name||' End of initialization_code',20);

204: where ppa.payroll_action_id = p_payroll_action_id;
205: end if ;
206: --
207: if g_debug then
208: hr_utility.set_location(l_proc_name||' End of initialization_code',20);
209: end if;
210: exception
211: when others then
212: if g_debug then

Line 213: hr_utility.set_location(l_proc_name||' Error in initialization code ',20);

209: end if;
210: exception
211: when others then
212: if g_debug then
213: hr_utility.set_location(l_proc_name||' Error in initialization code ',20);
214: end if;
215: raise;
216: end initialization_code;
217: ------------------------------------------------------------

Line 319: hr_utility.set_location(l_proc_name||' Start of archive_code',40);

315: --------------------------------
316: -- Populating rec_action_info with Employee Details
317: --------------------------------
318: if g_debug then
319: hr_utility.set_location(l_proc_name||' Start of archive_code',40);
320: end if;
321: --
322: open csr_employee_details( p_assignment_action_id ) ;
323: fetch csr_employee_details

Line 424: hr_utility.set_location(l_proc_name||' Before Insert into pay_action_information',40);

420: ------------------------------------------------
421: -- Insert data into pay_action_information
422: ------------------------------------------------
423: if g_debug then
424: hr_utility.set_location(l_proc_name||' Before Insert into pay_action_information',40);
425: end if;
426: insert into pay_action_information (
427: action_information_id,
428: action_context_id,

Line 493: hr_utility.set_location(l_proc_name||' After Insert into pay_action_information',40);

489: rec_action_info.action_information23,
490: rec_action_info.action_information24,
491: rec_action_info.action_information25) ;
492: if g_debug then
493: hr_utility.set_location(l_proc_name||' After Insert into pay_action_information',40);
494: end if;
495: --
496: if g_debug then
497: hr_utility.set_location(l_proc_name||' End of archive_code',40);

Line 497: hr_utility.set_location(l_proc_name||' End of archive_code',40);

493: hr_utility.set_location(l_proc_name||' After Insert into pay_action_information',40);
494: end if;
495: --
496: if g_debug then
497: hr_utility.set_location(l_proc_name||' End of archive_code',40);
498: end if;
499: end archive_code ;
500: ---------------------------------
501: -- Deinitialization_code

Line 545: hr_utility.set_location('pay_sg_cpfline: Start of check_cpf_number',10);

541: l_year number;
542: begin
543:
544: if g_debug then
545: hr_utility.set_location('pay_sg_cpfline: Start of check_cpf_number',10);
546: end if;
547:
548: l_cpf_num_uen := substr(p_er_cpf_number,1,10);
549: l_cpf_num_pc := substr(p_er_cpf_number,11,3);

Line 628: hr_utility.set_location('pay_sg_cpfline: End of check_cpf_number',20);

624: end if;
625: end if;
626:
627: if g_debug then
628: hr_utility.set_location('pay_sg_cpfline: End of check_cpf_number',20);
629: end if;
630:
631: return l_return;
632: end check_cpf_number;