APPS.PAY_VOID_PAYMENTS dependencies on HR_UTILITY

Line 100: hr_utility.set_location ('void_run',1);

96: pid pay_payroll_actions.payroll_id%TYPE;
97: ovn pay_payroll_actions.object_version_number%TYPE;
98: action_type pay_payroll_actions.action_type%TYPE;
99: BEGIN
100: hr_utility.set_location ('void_run',1);
101: --------------------------------------------------------------------------------
102: -- Convert date. NB: This will have to change to generic data format in 10.7
103: --------------------------------------------------------------------------------
104: l_effective_date := trunc(fnd_date.canonical_to_date (p_effective_date));

Line 118: hr_utility.set_location ('void_run',2);

114: l_start_cheque := p_start_cheque;
115: l_end_cheque := p_end_cheque;
116: end if;
117: --
118: hr_utility.set_location ('void_run',2);
119: --------------------------------------------------------------------------------
120: -- Get template information from source payroll action
121: --------------------------------------------------------------------------------
122: SELECT business_group_id,

Line 136: hr_utility.set_location ('void_run',3);

132: --------------------------------------------------------------------------------
133: OPEN overlap_csr;
134: FETCH overlap_csr INTO overlap_row;
135: --
136: hr_utility.set_location ('void_run',3);
137: --
138: IF overlap_csr%FOUND THEN
139: hr_utility.set_location ('void_run',31);
140: IF action_type = 'H' THEN

Line 139: hr_utility.set_location ('void_run',31);

135: --
136: hr_utility.set_location ('void_run',3);
137: --
138: IF overlap_csr%FOUND THEN
139: hr_utility.set_location ('void_run',31);
140: IF action_type = 'H' THEN
141: p_errmsg := 'Overlap detected. Cheque #' || overlap_row.cheque_number ||
142: ' already voided in run performed on ' ||
143: fnd_date.date_to_canonical(overlap_row.effective_date);

Line 157: hr_utility.set_location ('void_run',4);

153: fnd_file.put_line( fnd_file.log,' Number of Cheques Successfully Voided : '||l_no_of_chq_processed);
154: RETURN;
155: END IF;
156: --
157: hr_utility.set_location ('void_run',4);
158: CLOSE overlap_csr;
159: --
160: hr_utility.set_location ('void_run',5);
161: --------------------------------------------------------------------------------

Line 160: hr_utility.set_location ('void_run',5);

156: --
157: hr_utility.set_location ('void_run',4);
158: CLOSE overlap_csr;
159: --
160: hr_utility.set_location ('void_run',5);
161: --------------------------------------------------------------------------------
162: -- Create new payroll action for void run
163: --------------------------------------------------------------------------------
164: INSERT INTO pay_payroll_actions

Line 194: hr_utility.set_location ('void_run',6);

190: l_end_cheque, -- end_cheque_number
191: fnd_profile.value('REQUEST_ID'),-- request_id
192: ovn ); -- object_version_number
193: --
194: hr_utility.set_location ('void_run',6);
195: --------------------------------------------------------------------------------
196: -- Loop through assignment actions
197: --------------------------------------------------------------------------------
198: FOR void_row IN void_csr LOOP

Line 199: hr_utility.set_location ('void_run',61);

195: --------------------------------------------------------------------------------
196: -- Loop through assignment actions
197: --------------------------------------------------------------------------------
198: FOR void_row IN void_csr LOOP
199: hr_utility.set_location ('void_run',61);
200: IF action_type = 'H' THEN
201: --------------------------------------------------------------------------------
202: -- Check the cheque is complete
203: --------------------------------------------------------------------------------

Line 213: hr_utility.set_location ('void_run',62);

209: fnd_file.put_line( fnd_file.log,' Number of Cheques Successfully Voided : '||l_no_of_chq_processed);
210: RETURN;
211: END IF;
212: --
213: hr_utility.set_location ('void_run',62);
214: --------------------------------------------------------------------------------
215: -- Check whether the cheque is reconcilled.
216: --------------------------------------------------------------------------------
217: open csr_payment_reconciled(void_row.assignment_action_id);

Line 230: hr_utility.set_location ('void_run',63);

226: END IF;
227: close csr_payment_reconciled;
228: --
229: END IF;
230: hr_utility.set_location ('void_run',63);
231: --------------------------------------------------------------------------------
232: -- Create new assignment action for void
233: --------------------------------------------------------------------------------
234: INSERT INTO pay_assignment_actions

Line 255: hr_utility.set_location ('void_run',63);

251:
252: -- bug 9960968
253: l_no_of_chq_processed := l_no_of_chq_processed + 1;
254: --
255: hr_utility.set_location ('void_run',63);
256: --------------------------------------------------------------------------------
257: -- Create interlock from void aa to cheque aa
258: --------------------------------------------------------------------------------
259: INSERT INTO pay_action_interlocks

Line 264: hr_utility.set_location ('void_run',64);

260: ( locking_action_id, locked_action_id )
261: VALUES
262: ( pay_assignment_actions_s.currval,void_row.assignment_action_id );
263: --
264: hr_utility.set_location ('void_run',64);
265: END LOOP;
266: --
267: hr_utility.set_location ('void_run',7);
268: COMMIT;

Line 267: hr_utility.set_location ('void_run',7);

263: --
264: hr_utility.set_location ('void_run',64);
265: END LOOP;
266: --
267: hr_utility.set_location ('void_run',7);
268: COMMIT;
269: -- bug 9960968
270: fnd_file.put_line( fnd_file.log,' Number of Cheques Successfully Voided : '||l_no_of_chq_processed);
271: END void_run;