DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pyppmwrs.pkb 120.13.12020000.2 2012/07/11 07:14:22 vmaripal ship $ */
3: g_package constant varchar(2000) default 'pay_ppmv4_ss.';
4: g_item_type varchar2(2000);
5: g_item_key varchar2(2000);
6: g_debug boolean := hr_utility.debug_enabled;
7: --
8: -- Constants for payments list mode profile option.
9: --
10: C_OPM_LIST_MODE constant varchar2(127) default 'PAY_PSS_PAYMENTS_LIST';

Line 48: hr_utility.set_message

44: --
45: --
46: exception
47: when no_data_found then
48: hr_utility.set_message
49: (applid => 800
50: ,l_message_name => 'PAY_449775_FOREIGN_ACCOUNT'
51: );
52: hr_utility.raise_error;

Line 52: hr_utility.raise_error;

48: hr_utility.set_message
49: (applid => 800
50: ,l_message_name => 'PAY_449775_FOREIGN_ACCOUNT'
51: );
52: hr_utility.raise_error;
53: when others then
54: null;
55: end;
56: end;

Line 304: hr_utility.trace

300: begin
301: l_value :=
302: wf_engine.getitemattrtext(p_item_type, p_item_key, p_attr_name, p_ignore);
303: if g_debug then
304: hr_utility.trace
305: (g_package || 'getwfattr(' || p_attr_name || ')=' || l_value || ')');
306: end if;
307: return l_value;
308: end getwfattr;

Line 318: hr_utility.trace

314: ,p_value in varchar2
315: ) is
316: begin
317: if g_debug then
318: hr_utility.trace
319: (g_package || 'add2wf(' || p_attr_name || ',' || p_value || ')');
320: end if;
321: wf_engine.additemattr
322: (itemtype => p_item_type

Line 2766: hr_utility.trace('Creating record : context => '||p_ppm_information_category);

2762: fnd_msg_pub.initialize;
2763: --
2764: -- Write to a t_ppmv4 structure.
2765: --
2766: hr_utility.trace('Creating record : context => '||p_ppm_information_category);
2767: hr_utility.trace('information 1 => '||p_ppm_information1);
2768: hr_utility.trace('information 2 => '||p_ppm_information2);
2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);

Line 2767: hr_utility.trace('information 1 => '||p_ppm_information1);

2763: --
2764: -- Write to a t_ppmv4 structure.
2765: --
2766: hr_utility.trace('Creating record : context => '||p_ppm_information_category);
2767: hr_utility.trace('information 1 => '||p_ppm_information1);
2768: hr_utility.trace('information 2 => '||p_ppm_information2);
2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);

Line 2768: hr_utility.trace('information 2 => '||p_ppm_information2);

2764: -- Write to a t_ppmv4 structure.
2765: --
2766: hr_utility.trace('Creating record : context => '||p_ppm_information_category);
2767: hr_utility.trace('information 1 => '||p_ppm_information1);
2768: hr_utility.trace('information 2 => '||p_ppm_information2);
2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);

Line 2769: hr_utility.trace('information 3 => '||p_ppm_information3);

2765: --
2766: hr_utility.trace('Creating record : context => '||p_ppm_information_category);
2767: hr_utility.trace('information 1 => '||p_ppm_information1);
2768: hr_utility.trace('information 2 => '||p_ppm_information2);
2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);

Line 2770: hr_utility.trace('information 4 => '||p_ppm_information4);

2766: hr_utility.trace('Creating record : context => '||p_ppm_information_category);
2767: hr_utility.trace('information 1 => '||p_ppm_information1);
2768: hr_utility.trace('information 2 => '||p_ppm_information2);
2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);
2774: hr_utility.trace('p_org_payment_method_id => '||p_org_payment_method_id);

Line 2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);

2767: hr_utility.trace('information 1 => '||p_ppm_information1);
2768: hr_utility.trace('information 2 => '||p_ppm_information2);
2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);
2774: hr_utility.trace('p_org_payment_method_id => '||p_org_payment_method_id);
2775: hr_utility.trace('p_payment_type => '||p_payment_type);

Line 2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);

2768: hr_utility.trace('information 2 => '||p_ppm_information2);
2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);
2774: hr_utility.trace('p_org_payment_method_id => '||p_org_payment_method_id);
2775: hr_utility.trace('p_payment_type => '||p_payment_type);
2776:

Line 2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);

2769: hr_utility.trace('information 3 => '||p_ppm_information3);
2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);
2774: hr_utility.trace('p_org_payment_method_id => '||p_org_payment_method_id);
2775: hr_utility.trace('p_payment_type => '||p_payment_type);
2776:
2777: l_new_ppm.transaction_id := p_transaction_id;

Line 2774: hr_utility.trace('p_org_payment_method_id => '||p_org_payment_method_id);

2770: hr_utility.trace('information 4 => '||p_ppm_information4);
2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);
2774: hr_utility.trace('p_org_payment_method_id => '||p_org_payment_method_id);
2775: hr_utility.trace('p_payment_type => '||p_payment_type);
2776:
2777: l_new_ppm.transaction_id := p_transaction_id;
2778: l_new_ppm.transaction_step_id := p_transaction_step_id;

Line 2775: hr_utility.trace('p_payment_type => '||p_payment_type);

2771: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2772: hr_utility.trace('p_transaction_id => '||p_transaction_id);
2773: hr_utility.trace('p_assignment_id => '||p_assignment_id);
2774: hr_utility.trace('p_org_payment_method_id => '||p_org_payment_method_id);
2775: hr_utility.trace('p_payment_type => '||p_payment_type);
2776:
2777: l_new_ppm.transaction_id := p_transaction_id;
2778: l_new_ppm.transaction_step_id := p_transaction_step_id;
2779: l_new_ppm.assignment_id := p_assignment_id;

Line 3463: hr_utility.trace('Entering resequence_priorities....');

3459: begin
3460: --
3461: -- Fix up the priorities.
3462: --
3463: hr_utility.trace('Entering resequence_priorities....');
3464: l_priority := pay_ppmv4_utils_ss.C_MIN_PRIORITY;
3465: for ppm in c_ppms(p_assignment_id, p_effective_date) loop
3466: hr_utility.trace('ppm.priority => '||ppm.priority);
3467: hr_utility.trace('l_priority => '||l_priority);

Line 3466: hr_utility.trace('ppm.priority => '||ppm.priority);

3462: --
3463: hr_utility.trace('Entering resequence_priorities....');
3464: l_priority := pay_ppmv4_utils_ss.C_MIN_PRIORITY;
3465: for ppm in c_ppms(p_assignment_id, p_effective_date) loop
3466: hr_utility.trace('ppm.priority => '||ppm.priority);
3467: hr_utility.trace('l_priority => '||l_priority);
3468: if ppm.priority <> l_priority then
3469: pay_ppmv4_utils_ss.tt2ppm
3470: (p_transaction_step_id => p_transaction_step_id

Line 3467: hr_utility.trace('l_priority => '||l_priority);

3463: hr_utility.trace('Entering resequence_priorities....');
3464: l_priority := pay_ppmv4_utils_ss.C_MIN_PRIORITY;
3465: for ppm in c_ppms(p_assignment_id, p_effective_date) loop
3466: hr_utility.trace('ppm.priority => '||ppm.priority);
3467: hr_utility.trace('l_priority => '||l_priority);
3468: if ppm.priority <> l_priority then
3469: pay_ppmv4_utils_ss.tt2ppm
3470: (p_transaction_step_id => p_transaction_step_id
3471: ,p_ppm => l_ppm

Line 3480: hr_utility.trace('Calling UPDATE from resequence_priorities');

3476: l_dt_mode := hr_api.g_correction;
3477: if ppm.esd < p_effective_date then
3478: l_dt_mode := hr_api.g_update;
3479: end if;
3480: hr_utility.trace('Calling UPDATE from resequence_priorities');
3481: hr_personal_pay_method_api.update_personal_pay_method
3482: (p_validate => false
3483: ,p_personal_payment_method_id => ppm.ppmid
3484: ,p_object_version_number => ppm.ovn

Line 3524: hr_utility.trace('Came out from UPDATE in resequence_priorities');

3520: ,p_effective_start_date => l_esd
3521: ,p_effective_end_date => l_eed
3522: ,p_comment_id => l_comment_id
3523: );
3524: hr_utility.trace('Came out from UPDATE in resequence_priorities');
3525: end if;
3526: l_priority := l_priority + 1;
3527: end loop;
3528: exception

Line 3575: --HR_UTILITY.TRACE_ON(NULL,'PPM');

3571: l_hr_txpersonid number;
3572: l_hr_txid number;
3573: l_unprocessed number;
3574: begin
3575: --HR_UTILITY.TRACE_ON(NULL,'PPM');
3576: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'ENTER', 0);
3577: l_pss_txstepid := hr_transaction_api.get_number_value
3578: (p_transaction_step_id => p_transaction_step_id
3579: ,p_name => pay_ppmv4_utils_ss.C_TX_STEP_ID_ARG

Line 3630: hr_utility.trace('l_ppm.ppm_information_category => '||l_ppm.ppm_information_category);

3626: --
3627: -- Make the API call.
3628: --
3629: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'PROCESS_API', 10);
3630: hr_utility.trace('l_ppm.ppm_information_category => '||l_ppm.ppm_information_category);
3631: hr_utility.trace('l_pss_txstepid => '||l_pss_txstepid);
3632: pay_ppmv4_utils_ss.process_api
3633: (p_state => l_ppm.state
3634: ,p_personal_payment_method_id => l_ppm.personal_payment_method_id

Line 3631: hr_utility.trace('l_pss_txstepid => '||l_pss_txstepid);

3627: -- Make the API call.
3628: --
3629: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'PROCESS_API', 10);
3630: hr_utility.trace('l_ppm.ppm_information_category => '||l_ppm.ppm_information_category);
3631: hr_utility.trace('l_pss_txstepid => '||l_pss_txstepid);
3632: pay_ppmv4_utils_ss.process_api
3633: (p_state => l_ppm.state
3634: ,p_personal_payment_method_id => l_ppm.personal_payment_method_id
3635: ,p_object_version_number => l_ppm.update_ovn

Line 4069: hr_utility.set_location('Entering: '|| l_proc,5);

4065: --local variable
4066: l_eff_date date;
4067: l_proc constant varchar2(100) := g_package || ' setEffectiveDate';
4068: BEGIN
4069: hr_utility.set_location('Entering: '|| l_proc,5);
4070: hr_utility.set_location('Effective Date => '||p_effective_date,6);
4071: hr_utility.set_location('Session Date => '||userenv('sessionid'),7);
4072: --
4073: l_eff_date := trunc(p_effective_date);

Line 4070: hr_utility.set_location('Effective Date => '||p_effective_date,6);

4066: l_eff_date date;
4067: l_proc constant varchar2(100) := g_package || ' setEffectiveDate';
4068: BEGIN
4069: hr_utility.set_location('Entering: '|| l_proc,5);
4070: hr_utility.set_location('Effective Date => '||p_effective_date,6);
4071: hr_utility.set_location('Session Date => '||userenv('sessionid'),7);
4072: --
4073: l_eff_date := trunc(p_effective_date);
4074: begin

Line 4071: hr_utility.set_location('Session Date => '||userenv('sessionid'),7);

4067: l_proc constant varchar2(100) := g_package || ' setEffectiveDate';
4068: BEGIN
4069: hr_utility.set_location('Entering: '|| l_proc,5);
4070: hr_utility.set_location('Effective Date => '||p_effective_date,6);
4071: hr_utility.set_location('Session Date => '||userenv('sessionid'),7);
4072: --
4073: l_eff_date := trunc(p_effective_date);
4074: begin
4075: dt_fndate.set_effective_date(l_eff_date);

Line 4078: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);

4074: begin
4075: dt_fndate.set_effective_date(l_eff_date);
4076: exception
4077: when DUP_VAL_ON_INDEX then
4078: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);
4079: when others then
4080: hr_utility.set_location('change for others : ' || l_proc ,998);
4081: end;
4082: --

Line 4080: hr_utility.set_location('change for others : ' || l_proc ,998);

4076: exception
4077: when DUP_VAL_ON_INDEX then
4078: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);
4079: when others then
4080: hr_utility.set_location('change for others : ' || l_proc ,998);
4081: end;
4082: --
4083: --
4084: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 4084: hr_utility.set_location('Leaving: '|| l_proc,10);

4080: hr_utility.set_location('change for others : ' || l_proc ,998);
4081: end;
4082: --
4083: --
4084: hr_utility.set_location('Leaving: '|| l_proc,10);
4085: EXCEPTION
4086: WHEN others THEN
4087: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
4088: rollback;

Line 4087: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

4083: --
4084: hr_utility.set_location('Leaving: '|| l_proc,10);
4085: EXCEPTION
4086: WHEN others THEN
4087: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
4088: rollback;
4089: raise;
4090: END STORE_SESSION;
4091: