APPS.PAY_ZA_BANK_DDF_UPD dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering qualify_bnk_update',10);

20: l_exists number;
21:
22: begin
23:
24: hr_utility.set_location('Entering qualify_bnk_update',10);
25: p_qualifier :='N';
26: open csr_assignments;
27: fetch csr_assignments into l_exists;
28: if csr_assignments%found then

Line 32: hr_utility.set_location('Exiting qualify_bnk_update',10);

28: if csr_assignments%found then
29: p_qualifier := 'Y';
30: end if;
31: close csr_assignments;
32: hr_utility.set_location('Exiting qualify_bnk_update',10);
33:
34: END qualify_bnk_update;
35:
36: PROCEDURE update_bnk(p_assignment_id number) IS

Line 68: hr_utility.set_location('Entering update_bnk',10);

64:
65: BEGIN
66:
67: -- call the procedure for each of the assignment_action_id's fetched
68: hr_utility.set_location('Entering update_bnk',10);
69: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,30);
70:
71: l_assignment_id := p_assignment_id;
72: hr_utility.set_location('Assignment_id = '||l_assignment_id,33);

Line 69: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,30);

65: BEGIN
66:
67: -- call the procedure for each of the assignment_action_id's fetched
68: hr_utility.set_location('Entering update_bnk',10);
69: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,30);
70:
71: l_assignment_id := p_assignment_id;
72: hr_utility.set_location('Assignment_id = '||l_assignment_id,33);
73: FOR rec_ppm_category in csr_ppm_category

Line 72: hr_utility.set_location('Assignment_id = '||l_assignment_id,33);

68: hr_utility.set_location('Entering update_bnk',10);
69: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,30);
70:
71: l_assignment_id := p_assignment_id;
72: hr_utility.set_location('Assignment_id = '||l_assignment_id,33);
73: FOR rec_ppm_category in csr_ppm_category
74: LOOP
75: begin
76: hr_utility.set_location('Updating PER_PAY_METH_ID:'||rec_ppm_category.personal_payment_method_id,34);

Line 76: hr_utility.set_location('Updating PER_PAY_METH_ID:'||rec_ppm_category.personal_payment_method_id,34);

72: hr_utility.set_location('Assignment_id = '||l_assignment_id,33);
73: FOR rec_ppm_category in csr_ppm_category
74: LOOP
75: begin
76: hr_utility.set_location('Updating PER_PAY_METH_ID:'||rec_ppm_category.personal_payment_method_id,34);
77: l_object_version_number := rec_ppm_category.object_version_number;
78: /*
79: hr_personal_pay_method_api.update_personal_pay_method
80: (

Line 97: hr_utility.set_location('Updated PER_PAY_METH_ID:'||rec_ppm_category.personal_payment_method_id,34);

93: update pay_personal_payment_methods_f
94: set ppm_information_category = l_legislation_code||'_'||upper(rec_ppm_category.payment_type_name)
95: where personal_payment_method_id = rec_ppm_category.personal_payment_method_id;
96:
97: hr_utility.set_location('Updated PER_PAY_METH_ID:'||rec_ppm_category.personal_payment_method_id,34);
98:
99: exception
100: WHEN others then
101: hr_utility.set_location('Inside exception for PER_PAY_METH_ID :'||rec_ppm_category.personal_payment_method_id,34);

Line 101: hr_utility.set_location('Inside exception for PER_PAY_METH_ID :'||rec_ppm_category.personal_payment_method_id,34);

97: hr_utility.set_location('Updated PER_PAY_METH_ID:'||rec_ppm_category.personal_payment_method_id,34);
98:
99: exception
100: WHEN others then
101: hr_utility.set_location('Inside exception for PER_PAY_METH_ID :'||rec_ppm_category.personal_payment_method_id,34);
102:
103: end;
104:
105: END LOOP;

Line 107: hr_utility.set_location('Exiting update_bnk',50);

103: end;
104:
105: END LOOP;
106:
107: hr_utility.set_location('Exiting update_bnk',50);
108: END update_bnk;
109:
110: END PAY_ZA_BANK_DDF_UPD ;