DBA Data[Home] [Help]

APPS.PAY_VOID_PAYMENTS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

150: END IF;
151: RETURN;
152: END IF;
153: --
154: hr_utility.set_location ('void_run',4);
155: CLOSE overlap_csr;
156: --
157: hr_utility.set_location ('void_run',5);
158: --------------------------------------------------------------------------------

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

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

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

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

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

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

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

204: p_errcode := 2; -- Error
205: RETURN;
206: END IF;
207: --
208: hr_utility.set_location ('void_run',62);
209: --------------------------------------------------------------------------------
210: -- Check whether the cheque is reconcilled.
211: --------------------------------------------------------------------------------
212: open csr_payment_reconciled(void_row.assignment_action_id);

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

219: END IF;
220: close csr_payment_reconciled;
221: --
222: END IF;
223: hr_utility.set_location ('void_run',63);
224: --------------------------------------------------------------------------------
225: -- Create new assignment action for void
226: --------------------------------------------------------------------------------
227: INSERT INTO pay_assignment_actions

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

241: void_row.object_version_number, -- object_version_number
242: pay_assignment_actions_s.nextval,
243: void_row.tax_unit_id ); -- action_sequence
244: --
245: hr_utility.set_location ('void_run',63);
246: --------------------------------------------------------------------------------
247: -- Create interlock from void aa to cheque aa
248: --------------------------------------------------------------------------------
249: INSERT INTO pay_action_interlocks

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

250: ( locking_action_id, locked_action_id )
251: VALUES
252: ( pay_assignment_actions_s.currval,void_row.assignment_action_id );
253: --
254: hr_utility.set_location ('void_run',64);
255: END LOOP;
256: --
257: hr_utility.set_location ('void_run',7);
258: COMMIT;

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

253: --
254: hr_utility.set_location ('void_run',64);
255: END LOOP;
256: --
257: hr_utility.set_location ('void_run',7);
258: COMMIT;
259: END void_run;
260: --
261: END pay_void_payments;