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 192: l_token_name pay_in_utils.char_tab_type;

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

Line 193: l_token_value pay_in_utils.char_tab_type;

189: AND ppa.report_type ='IN_PF_ARCHIVE'
190: AND ppa.business_group_id = g_bg_id;
191:
192: l_token_name pay_in_utils.char_tab_type;
193: l_token_value pay_in_utils.char_tab_type;
194: l_arch_ref_no_check NUMBER ;
195: E_NON_UNIQUE_ARCH_REF_NO EXCEPTION;
196: --
197: BEGIN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

368:
369: BEGIN
370: g_debug := hr_utility.debug_enabled;
371: l_procedure := g_package || 'archive_pf_emp_dtls';
372: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
373:
374: OPEN csr_pf_classification ;
375: FETCH csr_pf_classification INTO l_classification ;
376: CLOSE csr_pf_classification ;

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

379: OPEN csr_pf_people;
380: 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;
381: CLOSE csr_pf_people;
382:
383: pay_in_utils.set_location(g_debug,'Assignment Id : '||p_assignment_id,15);
384:
385: pay_action_information_api.create_action_information
386: (p_action_context_id => p_arc_asg_action_id
387: ,p_action_context_type => 'AAP'

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

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

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

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

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

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

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

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

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

572:
573: BEGIN
574: g_debug := hr_utility.debug_enabled;
575: l_procedure := g_package || 'archive_pf_balances';
576: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
577:
578: OPEN csr_pf_classification ;
579: FETCH csr_pf_classification INTO l_classification ;
580: CLOSE csr_pf_classification ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

779:
780: BEGIN
781: g_debug := hr_utility.debug_enabled;
782: l_procedure := g_package || 'archive_pf_org_dtls';
783: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
784:
785:
786: FOR rec_pf_org IN csr_pf_org
787: LOOP

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

785:
786: FOR rec_pf_org IN csr_pf_org
787: LOOP
788:
789: pay_in_utils.set_location(g_debug,'Org Id : '||rec_pf_org.org_id,5);
790:
791: l_representative := NULL ;
792: l_representative_desig := NULL ;
793: l_representative_name := NULL ;

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

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

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

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

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

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

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

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

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

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

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

1062:
1063: BEGIN
1064: g_debug := hr_utility.debug_enabled;
1065: l_procedure := g_package || 'archive_pf_challan_dtls';
1066: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1067:
1068:
1069:
1070: OPEN csr_challans;

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

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

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

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

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

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

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

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

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

1273: );
1274: END IF ;
1275:
1276:
1277: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1278:
1279:
1280: EXCEPTION
1281: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

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

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

1660: g_debug := hr_utility.debug_enabled;
1661: l_procedure := g_package || 'assignment_action_code';
1662: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1663: pay_in_utils.set_location(g_debug,'p_start_person: '||p_start_person,10);
1664: pay_in_utils.set_location(g_debug,'p_end_person: '||p_end_person,10);
1665:
1666: initialization_code (p_payroll_action_id);
1667:
1668:

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

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

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

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

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

1695: INTO l_action_id
1696: FROM dual;
1697:
1698: IF g_debug THEN
1699: pay_in_utils.trace('l_action_id : ',l_action_id);
1700: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1701: END IF ;
1702:
1703: hr_nonrun_asact.insact(lockingactid => l_action_id

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

1696: FROM dual;
1697:
1698: IF g_debug THEN
1699: pay_in_utils.trace('l_action_id : ',l_action_id);
1700: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1701: END IF ;
1702:
1703: hr_nonrun_asact.insact(lockingactid => l_action_id
1704: ,assignid => csr_rec.assignment_id

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

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

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

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

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

1768: INTO l_action_id
1769: FROM dual;
1770:
1771: IF g_debug THEN
1772: pay_in_utils.trace('l_action_id : ',l_action_id);
1773: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1774: END IF ;
1775:
1776: hr_nonrun_asact.insact(lockingactid => l_action_id

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

1769: FROM dual;
1770:
1771: IF g_debug THEN
1772: pay_in_utils.trace('l_action_id : ',l_action_id);
1773: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1774: END IF ;
1775:
1776: hr_nonrun_asact.insact(lockingactid => l_action_id
1777: ,assignid => csr_rec.assignment_id

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

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

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

1818: INTO l_action_id
1819: FROM dual;
1820:
1821: IF g_debug THEN
1822: pay_in_utils.trace('l_action_id : ',l_action_id);
1823: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1824: END IF ;
1825:
1826: hr_nonrun_asact.insact(lockingactid => l_action_id

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

1819: FROM dual;
1820:
1821: IF g_debug THEN
1822: pay_in_utils.trace('l_action_id : ',l_action_id);
1823: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
1824: END IF ;
1825:
1826: hr_nonrun_asact.insact(lockingactid => l_action_id
1827: ,assignid => csr_rec.assignment_id

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

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

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

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

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

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

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

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

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

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

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

2030: CLOSE csr_chk_pf_org ;
2031:
2032: IF l_pf_chk =1
2033: THEN
2034: pay_in_utils.set_location(g_debug,'Archiving Employee Dtls ',5);
2035: 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);
2036: 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);
2037: END IF ;
2038:

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

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

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

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

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

2067:
2068: END LOOP ;
2069: END IF ;
2070:
2071: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,20);
2072:
2073: EXCEPTION
2074: WHEN OTHERS THEN
2075:

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

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

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

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

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

2075:
2076: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
2077: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2078: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 280);
2079: pay_in_utils.trace(l_message,l_procedure);
2080:
2081: RAISE;
2082: --
2083: END archive_code;