eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_PF_ARCHIVE dependencies on PAY_IN_UTILS

Line 58: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);

54:
55: g_debug := hr_utility.debug_enabled;
56: l_procedure := g_package || '.range_code';
57:
58: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
59:
60: -- Call core package to return SQL string to SELECT a range
61: -- of assignments eligible for archival
62: --

Line 66: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,20);

62: --
63: pay_core_payslip_utils.range_cursor(p_payroll_action_id
64: ,p_sql);
65:
66: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,20);
67:
68:
69: --
70: EXCEPTION

Line 72: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

68:
69: --
70: EXCEPTION
71: WHEN OTHERS THEN
72: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
73: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
74: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
75: RAISE ;
76: --

Line 74: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);

70: EXCEPTION
71: WHEN OTHERS THEN
72: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
73: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
74: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
75: RAISE ;
76: --
77: END range_code;
78:

Line 122: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

118: BEGIN
119:
120: l_procedure := g_package || 'get_parameters';
121:
122: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
123:
124:
125: OPEN csr_parameter_info(p_payroll_action_id,
126: p_token_name);

Line 139: pay_in_utils.trace('Token Name ',p_token_name);

135: p_token_value := l_token_value;
136: END IF;
137:
138: IF g_debug THEN
139: pay_in_utils.trace('Token Name ',p_token_name);
140: pay_in_utils.trace('Token Value ',p_token_value);
141: END IF;
142:
143: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 140: pay_in_utils.trace('Token Value ',p_token_value);

136: END IF;
137:
138: IF g_debug THEN
139: pay_in_utils.trace('Token Name ',p_token_name);
140: pay_in_utils.trace('Token Value ',p_token_value);
141: END IF;
142:
143: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
144:

Line 143: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

139: pay_in_utils.trace('Token Name ',p_token_name);
140: pay_in_utils.trace('Token Value ',p_token_value);
141: END IF;
142:
143: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
144:
145:
146: END get_parameters;
147:

Line 190: l_token_name pay_in_utils.char_tab_type;

186: AND ppa.action_status = 'C'
187: AND ppa.payroll_action_id <> p_payroll_action_id
188: AND ppa.report_type ='IN_PF_ARCHIVE';
189:
190: l_token_name pay_in_utils.char_tab_type;
191: l_token_value pay_in_utils.char_tab_type;
192: l_arch_ref_no_check NUMBER ;
193: E_NON_UNIQUE_ARCH_REF_NO EXCEPTION;
194: --

Line 191: l_token_value pay_in_utils.char_tab_type;

187: AND ppa.payroll_action_id <> p_payroll_action_id
188: AND ppa.report_type ='IN_PF_ARCHIVE';
189:
190: l_token_name pay_in_utils.char_tab_type;
191: l_token_value pay_in_utils.char_tab_type;
192: l_arch_ref_no_check NUMBER ;
193: E_NON_UNIQUE_ARCH_REF_NO EXCEPTION;
194: --
195: BEGIN

Line 200: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

196: --
197: l_procedure := g_package || 'initialization_code';
198:
199: g_debug := hr_utility.debug_enabled;
200: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
201:
202: g_archive_pact := p_payroll_action_id;
203:
204: get_parameters(p_payroll_action_id,'YR',g_year);

Line 251: pay_in_utils.set_location(g_debug,'g_year : '||g_year, 5);

247: l_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','ARCH_REF_NUM');--'Archive Reference Number';
248: RAISE E_NON_UNIQUE_ARCH_REF_NO;
249: END IF;
250:
251: pay_in_utils.set_location(g_debug,'g_year : '||g_year, 5);
252: pay_in_utils.set_location(g_debug,'g_month : '||g_month, 5);
253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);
254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);

Line 252: pay_in_utils.set_location(g_debug,'g_month : '||g_month, 5);

248: RAISE E_NON_UNIQUE_ARCH_REF_NO;
249: END IF;
250:
251: pay_in_utils.set_location(g_debug,'g_year : '||g_year, 5);
252: pay_in_utils.set_location(g_debug,'g_month : '||g_month, 5);
253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);
254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);

Line 253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);

249: END IF;
250:
251: pay_in_utils.set_location(g_debug,'g_year : '||g_year, 5);
252: pay_in_utils.set_location(g_debug,'g_month : '||g_month, 5);
253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);
254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);

Line 254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);

250:
251: pay_in_utils.set_location(g_debug,'g_year : '||g_year, 5);
252: pay_in_utils.set_location(g_debug,'g_month : '||g_month, 5);
253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);
254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);

Line 255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);

251: pay_in_utils.set_location(g_debug,'g_year : '||g_year, 5);
252: pay_in_utils.set_location(g_debug,'g_month : '||g_month, 5);
253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);
254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);
259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);

Line 256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);

252: pay_in_utils.set_location(g_debug,'g_month : '||g_month, 5);
253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);
254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);
259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);
260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);

Line 257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);

253: pay_in_utils.set_location(g_debug,'g_challan_year : '||g_challan_year, 5);
254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);
259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);
260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);
261: pay_in_utils.set_location(g_debug,'p_payroll_action_id : '||p_payroll_action_id, 5);

Line 258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);

254: pay_in_utils.set_location(g_debug,'g_challan_mth : '||g_challan_mth, 5);
255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);
259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);
260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);
261: pay_in_utils.set_location(g_debug,'p_payroll_action_id : '||p_payroll_action_id, 5);
262:

Line 259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);

255: pay_in_utils.set_location(g_debug,'g_return_type : '||g_return_type, 5);
256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);
259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);
260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);
261: pay_in_utils.set_location(g_debug,'p_payroll_action_id : '||p_payroll_action_id, 5);
262:
263:

Line 260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);

256: pay_in_utils.set_location(g_debug,'g_arc_ref_no : '||g_arc_ref_no, 5);
257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);
259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);
260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);
261: pay_in_utils.set_location(g_debug,'p_payroll_action_id : '||p_payroll_action_id, 5);
262:
263:
264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 261: pay_in_utils.set_location(g_debug,'p_payroll_action_id : '||p_payroll_action_id, 5);

257: pay_in_utils.set_location(g_debug,'g_bg_id : '||g_bg_id, 5);
258: pay_in_utils.set_location(g_debug,'g_start_date : '||g_start_date, 5);
259: pay_in_utils.set_location(g_debug,'g_end_date : '||g_end_date, 5);
260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);
261: pay_in_utils.set_location(g_debug,'p_payroll_action_id : '||p_payroll_action_id, 5);
262:
263:
264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
265: --

Line 264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

260: pay_in_utils.set_location(g_debug,'g_business_no : '||g_business_no, 5);
261: pay_in_utils.set_location(g_debug,'p_payroll_action_id : '||p_payroll_action_id, 5);
262:
263:
264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
265: --
266: EXCEPTION
267: WHEN E_NON_UNIQUE_ARCH_REF_NO THEN
268: pay_in_utils.raise_message(800, 'PER_IN_NON_UNIQUE_VALUE', l_token_name, l_token_value);

Line 268: pay_in_utils.raise_message(800, 'PER_IN_NON_UNIQUE_VALUE', l_token_name, l_token_value);

264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
265: --
266: EXCEPTION
267: WHEN E_NON_UNIQUE_ARCH_REF_NO THEN
268: pay_in_utils.raise_message(800, 'PER_IN_NON_UNIQUE_VALUE', l_token_name, l_token_value);
269: fnd_file.put_line(fnd_file.log,'Archive Reference Number '|| g_arc_ref_no || 'is non-unique.');
270: RAISE;
271: WHEN OTHERS THEN
272: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

Line 272: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

268: pay_in_utils.raise_message(800, 'PER_IN_NON_UNIQUE_VALUE', l_token_name, l_token_value);
269: fnd_file.put_line(fnd_file.log,'Archive Reference Number '|| g_arc_ref_no || 'is non-unique.');
270: RAISE;
271: WHEN OTHERS THEN
272: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
273: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
274: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
275: pay_in_utils.trace(l_message,l_procedure);
276: RAISE;

Line 274: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

270: RAISE;
271: WHEN OTHERS THEN
272: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
273: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
274: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
275: pay_in_utils.trace(l_message,l_procedure);
276: RAISE;
277: --
278: END initialization_code;

Line 275: pay_in_utils.trace(l_message,l_procedure);

271: WHEN OTHERS THEN
272: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
273: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
274: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
275: pay_in_utils.trace(l_message,l_procedure);
276: RAISE;
277: --
278: END initialization_code;
279:

Line 368: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

364:
365: BEGIN
366: g_debug := hr_utility.debug_enabled;
367: l_procedure := g_package || 'archive_pf_emp_dtls';
368: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
369:
370: OPEN csr_pf_classification ;
371: FETCH csr_pf_classification INTO l_classification ;
372: CLOSE csr_pf_classification ;

Line 379: pay_in_utils.set_location(g_debug,'Assignment Id : '||p_assignment_id,15);

375: OPEN csr_pf_people;
376: FETCH csr_pf_people INTO l_pf_no,l_nssn,l_hire_date,l_emp_type,l_term_date,l_report,l_efile,l_eps;
377: CLOSE csr_pf_people;
378:
379: pay_in_utils.set_location(g_debug,'Assignment Id : '||p_assignment_id,15);
380:
381: pay_action_information_api.create_action_information
382: (p_action_context_id => p_arc_asg_action_id
383: ,p_action_context_type => 'AAP'

Line 403: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

399: ,p_action_information_id => l_action_info_id
400: ,p_object_version_number => l_ovn
401: );
402:
403: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

Line 407: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

403: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
408: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
409: pay_in_utils.trace(l_message,l_procedure);
410: RAISE;
411: --

Line 408: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
408: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
409: pay_in_utils.trace(l_message,l_procedure);
410: RAISE;
411: --
412: END archive_pf_emp_dtls;

Line 409: pay_in_utils.trace(l_message,l_procedure);

405: EXCEPTION
406: WHEN OTHERS THEN
407: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
408: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
409: pay_in_utils.trace(l_message,l_procedure);
410: RAISE;
411: --
412: END archive_pf_emp_dtls;
413:

Line 572: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

568:
569: BEGIN
570: g_debug := hr_utility.debug_enabled;
571: l_procedure := g_package || 'archive_pf_balances';
572: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
573:
574: OPEN csr_pf_classification ;
575: FETCH csr_pf_classification INTO l_classification ;
576: CLOSE csr_pf_classification ;

Line 589: pay_in_utils.set_location(g_debug,'balance_name: '||c_rec.balance_name,20);

585: p_source_id => p_pf_org,
586: p_tax_group => NULL ,
587: p_date_earned => NULL );
588:
589: pay_in_utils.set_location(g_debug,'balance_name: '||c_rec.balance_name,20);
590: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
591:
592: IF result_val <> 0 THEN
593: pay_action_information_api.create_action_information

Line 590: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);

586: p_tax_group => NULL ,
587: p_date_earned => NULL );
588:
589: pay_in_utils.set_location(g_debug,'balance_name: '||c_rec.balance_name,20);
590: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
591:
592: IF result_val <> 0 THEN
593: pay_action_information_api.create_action_information
594: (p_action_context_id => p_arc_asg_action_id

Line 620: pay_in_utils.set_location(g_debug,'balance_name: '||rec_pf_balances_ptd.balance_name,20);

616: p_source_id => NULL ,
617: p_tax_group => NULL ,
618: p_date_earned => NULL );
619:
620: pay_in_utils.set_location(g_debug,'balance_name: '||rec_pf_balances_ptd.balance_name,20);
621: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
622:
623: IF result_val <> 0 THEN
624: pay_action_information_api.create_action_information

Line 621: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);

617: p_tax_group => NULL ,
618: p_date_earned => NULL );
619:
620: pay_in_utils.set_location(g_debug,'balance_name: '||rec_pf_balances_ptd.balance_name,20);
621: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
622:
623: IF result_val <> 0 THEN
624: pay_action_information_api.create_action_information
625: (p_action_context_id => p_arc_asg_action_id

Line 668: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

664: );
665:
666: END IF ;
667:
668: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
669: EXCEPTION
670: WHEN OTHERS THEN
671: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 671: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

667:
668: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
669: EXCEPTION
670: WHEN OTHERS THEN
671: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
673: pay_in_utils.trace(l_message,l_procedure);
674: RAISE;
675: --

Line 672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

668: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
669: EXCEPTION
670: WHEN OTHERS THEN
671: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
673: pay_in_utils.trace(l_message,l_procedure);
674: RAISE;
675: --
676: END archive_pf_balances;

Line 673: pay_in_utils.trace(l_message,l_procedure);

669: EXCEPTION
670: WHEN OTHERS THEN
671: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
673: pay_in_utils.trace(l_message,l_procedure);
674: RAISE;
675: --
676: END archive_pf_balances;
677:

Line 779: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

775:
776: BEGIN
777: g_debug := hr_utility.debug_enabled;
778: l_procedure := g_package || 'archive_pf_org_dtls';
779: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
780:
781:
782: FOR rec_pf_org IN csr_pf_org
783: LOOP

Line 785: pay_in_utils.set_location(g_debug,'Org Id : '||rec_pf_org.org_id,5);

781:
782: FOR rec_pf_org IN csr_pf_org
783: LOOP
784:
785: pay_in_utils.set_location(g_debug,'Org Id : '||rec_pf_org.org_id,5);
786:
787: l_representative := NULL ;
788: l_representative_desig := NULL ;
789: l_representative_name := NULL ;

Line 827: pay_in_utils.set_location(g_debug,'Business Number : '||p_business_number,15);

823: SELECT business_group_id INTO l_bus_group_id --Business Group Id
824: FROM pay_payroll_actions
825: WHERE payroll_action_id =p_arc_pay_action_id;
826:
827: pay_in_utils.set_location(g_debug,'Business Number : '||p_business_number,15);
828:
829: pay_action_information_api.create_action_information
830: (p_action_context_id => p_arc_pay_action_id
831: ,p_action_context_type => 'PA'

Line 856: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

852: ,p_object_version_number => l_ovn
853: );
854:
855:
856: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
857: EXCEPTION
858: WHEN OTHERS THEN
859: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
860: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 859: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

855:
856: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
857: EXCEPTION
858: WHEN OTHERS THEN
859: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
860: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
861: pay_in_utils.trace(l_message,l_procedure);
862: RAISE;
863: --

Line 860: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

856: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
857: EXCEPTION
858: WHEN OTHERS THEN
859: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
860: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
861: pay_in_utils.trace(l_message,l_procedure);
862: RAISE;
863: --
864: END archive_pf_org_dtls;

Line 861: pay_in_utils.trace(l_message,l_procedure);

857: EXCEPTION
858: WHEN OTHERS THEN
859: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
860: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
861: pay_in_utils.trace(l_message,l_procedure);
862: RAISE;
863: --
864: END archive_pf_org_dtls;
865:

Line 1062: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

1058:
1059: BEGIN
1060: g_debug := hr_utility.debug_enabled;
1061: l_procedure := g_package || 'archive_pf_challan_dtls';
1062: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1063:
1064:
1065:
1066: OPEN csr_challans;

Line 1177: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_CHALLAN'||l_Challan_Ref,5);

1173:
1174:
1175: IF l_Challan_Ref IS NOT NULL
1176: THEN
1177: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_CHALLAN'||l_Challan_Ref,5);
1178: pay_action_information_api.create_action_information
1179: (p_action_context_id => p_arc_pay_action_id
1180: ,p_action_context_type => 'PA'
1181: ,p_action_information_category => 'IN_PF_CHALLAN'

Line 1211: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_14B'||l_14B_Challan_Ref,6);

1207:
1208: IF l_14B_Challan_Ref IS NOT NULL
1209: THEN
1210:
1211: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_14B'||l_14B_Challan_Ref,6);
1212: pay_action_information_api.create_action_information
1213: (p_action_context_id => p_arc_pay_action_id
1214: ,p_action_context_type => 'PA'
1215: ,p_action_information_category => 'IN_PF_14B'

Line 1231: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_7Q'||l_7Q_Challan_Ref,7);

1227: END IF ;
1228:
1229: IF l_7Q_Challan_Ref IS NOT NULL
1230: THEN
1231: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_7Q'||l_7Q_Challan_Ref,7);
1232: pay_action_information_api.create_action_information
1233: (p_action_context_id => p_arc_pay_action_id
1234: ,p_action_context_type => 'PA'
1235: ,p_action_information_category => 'IN_PF_7Q'

Line 1251: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_MISC'||l_Misc_Challan_Ref,8);

1247: END IF ;
1248:
1249: IF l_Misc_Challan_Ref IS NOT NULL
1250: THEN
1251: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_MISC'||l_Misc_Challan_Ref,8);
1252: pay_action_information_api.create_action_information
1253: (p_action_context_id => p_arc_pay_action_id
1254: ,p_action_context_type => 'PA'
1255: ,p_action_information_category => 'IN_PF_MISC'

Line 1273: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

1269: );
1270: END IF ;
1271:
1272:
1273: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1274:
1275:
1276: EXCEPTION
1277: WHEN OTHERS THEN

Line 1278: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

1274:
1275:
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1279: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1280: pay_in_utils.trace(l_message,l_procedure);
1281: RAISE;
1282: --

Line 1279: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

1275:
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1279: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1280: pay_in_utils.trace(l_message,l_procedure);
1281: RAISE;
1282: --
1283: END archive_pf_challan_dtls;

Line 1280: pay_in_utils.trace(l_message,l_procedure);

1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1279: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1280: pay_in_utils.trace(l_message,l_procedure);
1281: RAISE;
1282: --
1283: END archive_pf_challan_dtls;
1284:

Line 1658: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

1654: BEGIN
1655: --
1656: g_debug := hr_utility.debug_enabled;
1657: l_procedure := g_package || 'assignment_action_code';
1658: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1659: pay_in_utils.set_location(g_debug,'p_start_person: '||p_start_person,10);
1660: pay_in_utils.set_location(g_debug,'p_end_person: '||p_end_person,10);
1661:
1662: initialization_code (p_payroll_action_id);

Line 1659: pay_in_utils.set_location(g_debug,'p_start_person: '||p_start_person,10);

1655: --
1656: g_debug := hr_utility.debug_enabled;
1657: l_procedure := g_package || 'assignment_action_code';
1658: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1659: pay_in_utils.set_location(g_debug,'p_start_person: '||p_start_person,10);
1660: pay_in_utils.set_location(g_debug,'p_end_person: '||p_end_person,10);
1661:
1662: initialization_code (p_payroll_action_id);
1663:

Line 1660: pay_in_utils.set_location(g_debug,'p_end_person: '||p_end_person,10);

1656: g_debug := hr_utility.debug_enabled;
1657: l_procedure := g_package || 'assignment_action_code';
1658: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1659: pay_in_utils.set_location(g_debug,'p_start_person: '||p_start_person,10);
1660: pay_in_utils.set_location(g_debug,'p_end_person: '||p_end_person,10);
1661:
1662: initialization_code (p_payroll_action_id);
1663:
1664:

Line 1667: pay_in_utils.set_location(g_debug,'Entering: Supplementary',5);

1663:
1664:
1665: IF g_return_type = 'S' --Archive for Supplementary Return Starts.
1666: THEN
1667: pay_in_utils.set_location(g_debug,'Entering: Supplementary',5);
1668: FOR rec_reg_return IN csr_reg_return
1669: LOOP
1670: pay_in_utils.set_location(g_debug,'Business Number:'||rec_reg_return.bus_no,15);
1671: FOR rec_pf_org_id IN csr_pf_org_id(rec_reg_return.bus_no)

Line 1670: pay_in_utils.set_location(g_debug,'Business Number:'||rec_reg_return.bus_no,15);

1666: THEN
1667: pay_in_utils.set_location(g_debug,'Entering: Supplementary',5);
1668: FOR rec_reg_return IN csr_reg_return
1669: LOOP
1670: pay_in_utils.set_location(g_debug,'Business Number:'||rec_reg_return.bus_no,15);
1671: FOR rec_pf_org_id IN csr_pf_org_id(rec_reg_return.bus_no)
1672: LOOP
1673: l_pf_check := NULL ;
1674:

Line 1695: pay_in_utils.trace('l_action_id : ',l_action_id);

1691: INTO l_action_id
1692: FROM dual;
1693:
1694: IF g_debug THEN
1695: pay_in_utils.trace('l_action_id : ',l_action_id);
1696: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1697: END IF ;
1698:
1699: hr_nonrun_asact.insact(lockingactid => l_action_id

Line 1696: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);

1692: FROM dual;
1693:
1694: IF g_debug THEN
1695: pay_in_utils.trace('l_action_id : ',l_action_id);
1696: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1697: END IF ;
1698:
1699: hr_nonrun_asact.insact(lockingactid => l_action_id
1700: ,assignid => csr_rec.assignment_id

Line 1737: pay_in_utils.set_location(g_debug,'Entering: Revised',5);

1733: --Archive for Supplementary Return Ends.
1734:
1735: ELSIF g_return_type = 'V' --Archive for Revised Return Starts.
1736: THEN
1737: pay_in_utils.set_location(g_debug,'Entering: Revised',5);
1738: FOR rec_reg_return IN csr_reg_return
1739: LOOP
1740: pay_in_utils.set_location(g_debug,'Business Number:'||rec_reg_return.bus_no,15);
1741: FOR rec_pf_org_id IN csr_pf_org_id(rec_reg_return.bus_no)

Line 1740: pay_in_utils.set_location(g_debug,'Business Number:'||rec_reg_return.bus_no,15);

1736: THEN
1737: pay_in_utils.set_location(g_debug,'Entering: Revised',5);
1738: FOR rec_reg_return IN csr_reg_return
1739: LOOP
1740: pay_in_utils.set_location(g_debug,'Business Number:'||rec_reg_return.bus_no,15);
1741: FOR rec_pf_org_id IN csr_pf_org_id(rec_reg_return.bus_no)
1742: LOOP
1743:
1744: l_pf_check := NULL ;

Line 1768: pay_in_utils.trace('l_action_id : ',l_action_id);

1764: INTO l_action_id
1765: FROM dual;
1766:
1767: IF g_debug THEN
1768: pay_in_utils.trace('l_action_id : ',l_action_id);
1769: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1770: END IF ;
1771:
1772: hr_nonrun_asact.insact(lockingactid => l_action_id

Line 1769: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);

1765: FROM dual;
1766:
1767: IF g_debug THEN
1768: pay_in_utils.trace('l_action_id : ',l_action_id);
1769: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1770: END IF ;
1771:
1772: hr_nonrun_asact.insact(lockingactid => l_action_id
1773: ,assignid => csr_rec.assignment_id

Line 1809: pay_in_utils.set_location(g_debug,'Entering: Regular',5);

1805: END LOOP ;
1806: --Archive for Revised Return Ends.
1807:
1808: ELSE --Archive for Regular Return Starts.
1809: pay_in_utils.set_location(g_debug,'Entering: Regular',5);
1810: FOR csr_rec IN csr_process_assignments
1811: LOOP
1812:
1813: SELECT pay_assignment_actions_s.NEXTVAL

Line 1818: pay_in_utils.trace('l_action_id : ',l_action_id);

1814: INTO l_action_id
1815: FROM dual;
1816:
1817: IF g_debug THEN
1818: pay_in_utils.trace('l_action_id : ',l_action_id);
1819: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1820: END IF ;
1821:
1822: hr_nonrun_asact.insact(lockingactid => l_action_id

Line 1819: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);

1815: FROM dual;
1816:
1817: IF g_debug THEN
1818: pay_in_utils.trace('l_action_id : ',l_action_id);
1819: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1820: END IF ;
1821:
1822: hr_nonrun_asact.insact(lockingactid => l_action_id
1823: ,assignid => csr_rec.assignment_id

Line 1832: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);

1828: END LOOP ;
1829: --Archive for Regular Return Ends.
1830: END IF ;
1831:
1832: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1833: --
1834: EXCEPTION
1835: --
1836: WHEN OTHERS THEN

Line 1837: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

1833: --
1834: EXCEPTION
1835: --
1836: WHEN OTHERS THEN
1837: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
1838: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1839: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
1840: pay_in_utils.trace(l_message,l_procedure);
1841: RAISE;

Line 1839: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

1835: --
1836: WHEN OTHERS THEN
1837: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
1838: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1839: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
1840: pay_in_utils.trace(l_message,l_procedure);
1841: RAISE;
1842: --
1843: END assignment_action_code;

Line 1840: pay_in_utils.trace(l_message,l_procedure);

1836: WHEN OTHERS THEN
1837: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
1838: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1839: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
1840: pay_in_utils.trace(l_message,l_procedure);
1841: RAISE;
1842: --
1843: END assignment_action_code;
1844:

Line 2007: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

2003: BEGIN
2004: --
2005: g_debug := hr_utility.debug_enabled;
2006: l_procedure := g_package || 'archive_code';
2007: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2008:
2009: OPEN csr_get_assignment_pact_id;
2010: FETCH csr_get_assignment_pact_id INTO l_assignment_id ,l_arc_pay_action_id,l_person_id;
2011: CLOSE csr_get_assignment_pact_id;

Line 2030: pay_in_utils.set_location(g_debug,'Archiving Employee Dtls ',5);

2026: CLOSE csr_chk_pf_org ;
2027:
2028: IF l_pf_chk =1
2029: THEN
2030: pay_in_utils.set_location(g_debug,'Archiving Employee Dtls ',5);
2031: archive_pf_emp_dtls(l_run_asg_action_id,p_assignment_action_id,l_assignment_id,rec_pf_org.pf_org,rec_pf_org.business_number);
2032: archive_pf_balances(l_run_asg_action_id,p_assignment_action_id,l_assignment_id,rec_pf_org.pf_org,rec_pf_org.business_number);
2033: END IF ;
2034:

Line 2043: pay_in_utils.set_location(g_debug,'Archiving Org Dtls ',15);

2039:
2040: /*Org Level Data is archived in Procedure assignment_action_code for Revised/Supplementary Return.*/
2041: IF l_check IS NULL AND g_return_type = 'R'
2042: THEN
2043: pay_in_utils.set_location(g_debug,'Archiving Org Dtls ',15);
2044: archive_pf_org_dtls(l_arc_pay_action_id,rec_pf_org.business_number);
2045: END IF ;
2046: l_check := NULL ;
2047:

Line 2057: pay_in_utils.set_location(g_debug,'Archiving Challan Dtls ',25);

2053: IF l_pf_check IS NULL AND g_return_type = 'R'
2054: THEN
2055: FOR rec_challans IN csr_challans(rec_pf_org.pf_org)
2056: LOOP
2057: pay_in_utils.set_location(g_debug,'Archiving Challan Dtls ',25);
2058: archive_pf_challan_dtls(l_arc_pay_action_id,rec_pf_org.pf_org,rec_challans.Challan_Ref,rec_pf_org.business_number);
2059: END LOOP ;
2060: END IF ;
2061: l_pf_check := NULL ;

Line 2067: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,20);

2063:
2064: END LOOP ;
2065: END IF ;
2066:
2067: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,20);
2068:
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071:

Line 2072: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

2068:
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071:
2072: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
2073: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2074: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 280);
2075: pay_in_utils.trace(l_message,l_procedure);
2076:

Line 2074: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 280);

2070: WHEN OTHERS THEN
2071:
2072: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
2073: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2074: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 280);
2075: pay_in_utils.trace(l_message,l_procedure);
2076:
2077: RAISE;
2078: --

Line 2075: pay_in_utils.trace(l_message,l_procedure);

2071:
2072: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
2073: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2074: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 280);
2075: pay_in_utils.trace(l_message,l_procedure);
2076:
2077: RAISE;
2078: --
2079: END archive_code;