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_QPU_API dependencies on HR_UTILITY

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

100: and pya.business_group_id = p_business_group_id
101: and pya.effective_date = p_effective_date;
102: --
103: begin
104: hr_utility.set_location('Entering:'|| l_proc, 5);
105: --
106: -- Check mandatory parameters have been set
107: --
108: hr_api.mandatory_arg_error

Line 123: hr_utility.set_location(l_proc, 6);

119: (p_api_name => l_proc
120: ,p_argument => 'effective_date'
121: ,p_argument_value => p_effective_date
122: );
123: hr_utility.set_location(l_proc, 6);
124: --
125: -- Check the target_payroll_action_id exists in pay_payroll_actions
126: -- and it is for a completed QuickPay Run assignment action.
127: --

Line 135: hr_utility.set_message(801, 'HR_7257_QPAY_U_QRUN_NOT_EXIST');

131: close csr_pay_act;
132: -- Error: You have tried to create a QuickPay Pre-payment for a
133: -- target_payroll_action_id that does not exist, or for a QuickPay run
134: -- that does not have the status Complete.
135: hr_utility.set_message(801, 'HR_7257_QPAY_U_QRUN_NOT_EXIST');
136: hr_utility.raise_error;
137: end if;
138: close csr_pay_act;
139: hr_utility.set_location(l_proc, 7);

Line 136: hr_utility.raise_error;

132: -- Error: You have tried to create a QuickPay Pre-payment for a
133: -- target_payroll_action_id that does not exist, or for a QuickPay run
134: -- that does not have the status Complete.
135: hr_utility.set_message(801, 'HR_7257_QPAY_U_QRUN_NOT_EXIST');
136: hr_utility.raise_error;
137: end if;
138: close csr_pay_act;
139: hr_utility.set_location(l_proc, 7);
140: --

Line 139: hr_utility.set_location(l_proc, 7);

135: hr_utility.set_message(801, 'HR_7257_QPAY_U_QRUN_NOT_EXIST');
136: hr_utility.raise_error;
137: end if;
138: close csr_pay_act;
139: hr_utility.set_location(l_proc, 7);
140: --
141: -- There should be no more than one QuickPay Pre-payment for any
142: -- QuickPay Run. So check a QuickPay Pre-Payment has not already
143: -- been defined for the target payroll action.

Line 151: hr_utility.set_message(801, 'HR_7258_QPAY_U_ALREAY_EXIST');

147: if csr_other_qpu%found then
148: close csr_other_qpu;
149: -- Error: You cannot create more than one QuickPay Pre-payment for the
150: -- same run.
151: hr_utility.set_message(801, 'HR_7258_QPAY_U_ALREAY_EXIST');
152: hr_utility.raise_error;
153: end if;
154: close csr_other_qpu;
155: hr_utility.set_location(l_proc, 8);

Line 152: hr_utility.raise_error;

148: close csr_other_qpu;
149: -- Error: You cannot create more than one QuickPay Pre-payment for the
150: -- same run.
151: hr_utility.set_message(801, 'HR_7258_QPAY_U_ALREAY_EXIST');
152: hr_utility.raise_error;
153: end if;
154: close csr_other_qpu;
155: hr_utility.set_location(l_proc, 8);
156: --

Line 155: hr_utility.set_location(l_proc, 8);

151: hr_utility.set_message(801, 'HR_7258_QPAY_U_ALREAY_EXIST');
152: hr_utility.raise_error;
153: end if;
154: close csr_other_qpu;
155: hr_utility.set_location(l_proc, 8);
156: --
157: -- Check that the QuickPay Run has not already been
158: -- locked by a QuickPay Pre-payment.
159: --

Line 166: hr_utility.set_message(801, 'HR_7259_QPAY_U_BATCH_EXIST');

162: if csr_no_lck%found then
163: close csr_no_lck;
164: -- Error: You cannot create a QuickPay Pre-payment if the QuickPay run has
165: -- been or will be processed by the batch Pre-payments process.
166: hr_utility.set_message(801, 'HR_7259_QPAY_U_BATCH_EXIST');
167: hr_utility.raise_error;
168: end if;
169: close csr_no_lck;
170: hr_utility.set_location(l_proc, 9);

Line 167: hr_utility.raise_error;

163: close csr_no_lck;
164: -- Error: You cannot create a QuickPay Pre-payment if the QuickPay run has
165: -- been or will be processed by the batch Pre-payments process.
166: hr_utility.set_message(801, 'HR_7259_QPAY_U_BATCH_EXIST');
167: hr_utility.raise_error;
168: end if;
169: close csr_no_lck;
170: hr_utility.set_location(l_proc, 9);
171: --

Line 170: hr_utility.set_location(l_proc, 9);

166: hr_utility.set_message(801, 'HR_7259_QPAY_U_BATCH_EXIST');
167: hr_utility.raise_error;
168: end if;
169: close csr_no_lck;
170: hr_utility.set_location(l_proc, 9);
171: --
172: -- Check the QuickPay Pre-payment business group and effective_date are the
173: -- same as the QuickPay Run business group and effective_date (date_paid).
174: --

Line 182: hr_utility.set_message(801, 'HR_7260_QPAY_U_SAME_AS_Q');

178: close csr_bus_grp;
179: -- Error: The business_group and date_paid attributes for the QuickPay
180: -- Pre-payment must have the same values as the business_group and
181: -- date_paid for the QuickPay run.
182: hr_utility.set_message(801, 'HR_7260_QPAY_U_SAME_AS_Q');
183: hr_utility.raise_error;
184: end if;
185: close csr_bus_grp;
186: --

Line 183: hr_utility.raise_error;

179: -- Error: The business_group and date_paid attributes for the QuickPay
180: -- Pre-payment must have the same values as the business_group and
181: -- date_paid for the QuickPay run.
182: hr_utility.set_message(801, 'HR_7260_QPAY_U_SAME_AS_Q');
183: hr_utility.raise_error;
184: end if;
185: close csr_bus_grp;
186: --
187: hr_utility.set_location(' Leaving:'|| l_proc, 10);

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

183: hr_utility.raise_error;
184: end if;
185: close csr_bus_grp;
186: --
187: hr_utility.set_location(' Leaving:'|| l_proc, 10);
188: end chk_target_payroll_action_id;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |----------------------< chk_org_payment_method_id >-----------------------|

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

253: and p_effective_date between org.effective_start_date
254: and org.effective_end_date;
255: --
256: begin
257: hr_utility.set_location('Entering:'|| l_proc, 5);
258: if p_org_payment_method_id is not null then
259: hr_utility.set_location(l_proc, 6);
260: --
261: -- Check that org_payment_method_id exists in pay_org_payment_methods_f

Line 259: hr_utility.set_location(l_proc, 6);

255: --
256: begin
257: hr_utility.set_location('Entering:'|| l_proc, 5);
258: if p_org_payment_method_id is not null then
259: hr_utility.set_location(l_proc, 6);
260: --
261: -- Check that org_payment_method_id exists in pay_org_payment_methods_f
262: -- as of the effective_date (date paid). Also it must be in the same
263: -- business group as the QuickPay Pre-payment.

Line 272: hr_utility.set_message(801, 'HR_7261_QPAY_OVERRIDE_EXIST');

268: close csr_org_met;
269: -- Error: The Override Payment Method you have tried to enter does not
270: -- exist as at Date Paid, or is not in the same Business Group as the
271: -- QuickPay Pre-payment.
272: hr_utility.set_message(801, 'HR_7261_QPAY_OVERRIDE_EXIST');
273: hr_utility.raise_error;
274: end if;
275: close csr_org_met;
276: hr_utility.set_location(l_proc, 7);

Line 273: hr_utility.raise_error;

269: -- Error: The Override Payment Method you have tried to enter does not
270: -- exist as at Date Paid, or is not in the same Business Group as the
271: -- QuickPay Pre-payment.
272: hr_utility.set_message(801, 'HR_7261_QPAY_OVERRIDE_EXIST');
273: hr_utility.raise_error;
274: end if;
275: close csr_org_met;
276: hr_utility.set_location(l_proc, 7);
277: --

Line 276: hr_utility.set_location(l_proc, 7);

272: hr_utility.set_message(801, 'HR_7261_QPAY_OVERRIDE_EXIST');
273: hr_utility.raise_error;
274: end if;
275: close csr_org_met;
276: hr_utility.set_location(l_proc, 7);
277: --
278: -- Check that the org_payment_method does not have
279: -- a payment category of magnetic transfer.
280: --

Line 287: hr_utility.set_message(801, 'HR_7262_QPAY_U_PMENT_CATGY');

283: if csr_pay_type%found then
284: close csr_pay_type;
285: -- Error: You cannot enter the payment category Magnetic Transfer for
286: -- the QuickPay Pre-payment org_payment_method_id.
287: hr_utility.set_message(801, 'HR_7262_QPAY_U_PMENT_CATGY');
288: hr_utility.raise_error;
289: end if;
290: close csr_pay_type;
291: end if;

Line 288: hr_utility.raise_error;

284: close csr_pay_type;
285: -- Error: You cannot enter the payment category Magnetic Transfer for
286: -- the QuickPay Pre-payment org_payment_method_id.
287: hr_utility.set_message(801, 'HR_7262_QPAY_U_PMENT_CATGY');
288: hr_utility.raise_error;
289: end if;
290: close csr_pay_type;
291: end if;
292: --

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

289: end if;
290: close csr_pay_type;
291: end if;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: end chk_org_payment_method_id;
295: --
296: -- ----------------------------------------------------------------------------
297: -- |-------------------------< chk_action_status >----------------------------|

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

334: --
335: l_proc varchar2(72) := g_package||'chk_action_status';
336: --
337: begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: -- Check the updated status is from 'C'omplete to 'M'ark for Retry
341: --
342: if (p_old_action_status not in ('C', 'S')) and (p_new_action_status <> 'M') then

Line 346: hr_utility.set_message(801, 'HR_7252_QPAY_ONLY_MARK_RETRY');

342: if (p_old_action_status not in ('C', 'S')) and (p_new_action_status <> 'M') then
343: -- Error: You have tried to enter an invalid status for a completed
344: -- QuickPay run. You can only update a completed assignment process
345: -- status to Marked for Retry.
346: hr_utility.set_message(801, 'HR_7252_QPAY_ONLY_MARK_RETRY');
347: hr_utility.raise_error;
348: end if;
349: hr_utility.set_location(l_proc, 6);
350: --

Line 347: hr_utility.raise_error;

343: -- Error: You have tried to enter an invalid status for a completed
344: -- QuickPay run. You can only update a completed assignment process
345: -- status to Marked for Retry.
346: hr_utility.set_message(801, 'HR_7252_QPAY_ONLY_MARK_RETRY');
347: hr_utility.raise_error;
348: end if;
349: hr_utility.set_location(l_proc, 6);
350: --
351: -- Check that this QuickPay Pre-payment can have

Line 349: hr_utility.set_location(l_proc, 6);

345: -- status to Marked for Retry.
346: hr_utility.set_message(801, 'HR_7252_QPAY_ONLY_MARK_RETRY');
347: hr_utility.raise_error;
348: end if;
349: hr_utility.set_location(l_proc, 6);
350: --
351: -- Check that this QuickPay Pre-payment can have
352: -- a status of Mark for Retry
353: --

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

355: p_payroll_action_id => p_payroll_action_id,
356: p_rollback_mode => 'RETRY',
357: p_leave_base_table_row => TRUE);
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: end chk_action_status;
361: --
362: -- ----------------------------------------------------------------------------
363: -- |-----------------------------< chk_cur_task >-----------------------------|

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

402: from pay_payroll_actions
403: where payroll_action_id = p_payroll_action_id
404: and current_task is not null;
405: begin
406: hr_utility.set_location('Entering:'|| l_proc, 5);
407: --
408: open sel_task;
409: fetch sel_task into v_exists;
410: if sel_task%found then

Line 414: hr_utility.set_message(801, 'HR_7256_QPAY_U_PROCESSING');

410: if sel_task%found then
411: close sel_task;
412: -- Error: You have tried to update or delete a QuickPay Pre-payment while
413: -- the corresponding payroll process has a status of Processing.
414: hr_utility.set_message(801, 'HR_7256_QPAY_U_PROCESSING');
415: hr_utility.raise_error;
416: end if;
417: close sel_task;
418: --

Line 415: hr_utility.raise_error;

411: close sel_task;
412: -- Error: You have tried to update or delete a QuickPay Pre-payment while
413: -- the corresponding payroll process has a status of Processing.
414: hr_utility.set_message(801, 'HR_7256_QPAY_U_PROCESSING');
415: hr_utility.raise_error;
416: end if;
417: close sel_task;
418: --
419: hr_utility.set_location(' Leaving:'|| l_proc, 10);

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

415: hr_utility.raise_error;
416: end if;
417: close sel_task;
418: --
419: hr_utility.set_location(' Leaving:'|| l_proc, 10);
420: end chk_cur_task;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |----------------------------< paid_payments >-----------------------------|

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

441: and pac.payroll_action_id = aac.payroll_action_id
442: and pac.action_type in ('E', 'H', 'A', 'M');
443: --
444: begin
445: hr_utility.set_location('Entering:'|| l_proc, 5);
446: --
447: -- Check mandatory arguments have been set
448: --
449: hr_api.mandatory_arg_error

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

461: -- There are no pre-payments or none have been paid
462: l_paid := false;
463: end if;
464: close csr_paid;
465: hr_utility.set_location(' Leaving:'|| l_proc, 10);
466: return l_paid;
467: end paid_payments;
468: --
469: -- ----------------------------------------------------------------------------

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

501: --
502: l_proc varchar2(72) := g_package||'check_non_updateable_args';
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: if nvl(p_rec.business_group_id, hr_api.g_number) <>
508: nvl(g_old_rec.business_group_id, hr_api.g_number) then
509: hr_api.argument_changed_error

Line 514: hr_utility.set_location(l_proc, 6);

510: (p_api_name => l_proc
511: ,p_argument => 'business_group_id'
512: );
513: end if;
514: hr_utility.set_location(l_proc, 6);
515: --
516: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
517: nvl(g_old_rec.org_payment_method_id, hr_api.g_number) then
518: hr_api.argument_changed_error

Line 523: hr_utility.set_location(l_proc, 7);

519: (p_api_name => l_proc
520: ,p_argument => 'org_payment_method_id'
521: );
522: end if;
523: hr_utility.set_location(l_proc, 7);
524: --
525: if nvl(p_rec.target_payroll_action_id, hr_api.g_number) <>
526: nvl(g_old_rec.target_payroll_action_id, hr_api.g_number) then
527: hr_api.argument_changed_error

Line 532: hr_utility.set_location(l_proc, 8);

528: (p_api_name => l_proc
529: ,p_argument => 'target_payroll_action_id'
530: );
531: end if;
532: hr_utility.set_location(l_proc, 8);
533: --
534: if nvl(p_rec.effective_date, hr_api.g_date) <>
535: nvl(g_old_rec.effective_date, hr_api.g_date) then
536: hr_api.argument_changed_error

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

538: ,p_argument => 'effective_date'
539: );
540: end if;
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);
543: end check_non_updateable_args;
544: --
545: -- ----------------------------------------------------------------------------
546: -- |------------------------< return_api_dml_status >-------------------------|

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

550: --
551: l_proc varchar2(72) := g_package||'return_api_dml_status';
552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: Return (nvl(g_api_dml, false));
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: Return (nvl(g_api_dml, false));
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End return_api_dml_status;
560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------< constraint_error >---------------------------|

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

612: --
613: l_proc varchar2(72) := g_package||'constraint_error';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','5');
622: hr_utility.raise_error;
623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then

Line 620: hr_utility.set_message_token('PROCEDURE', l_proc);

616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','5');
622: hr_utility.raise_error;
623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 621: hr_utility.set_message_token('STEP','5');

617: --
618: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','5');
622: hr_utility.raise_error;
623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
625: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 622: hr_utility.raise_error;

618: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','5');
622: hr_utility.raise_error;
623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
625: hr_utility.set_message_token('PROCEDURE', l_proc);
626: hr_utility.set_message_token('STEP','10');

Line 624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','5');
622: hr_utility.raise_error;
623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
625: hr_utility.set_message_token('PROCEDURE', l_proc);
626: hr_utility.set_message_token('STEP','10');
627: hr_utility.raise_error;
628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then

Line 625: hr_utility.set_message_token('PROCEDURE', l_proc);

621: hr_utility.set_message_token('STEP','5');
622: hr_utility.raise_error;
623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
625: hr_utility.set_message_token('PROCEDURE', l_proc);
626: hr_utility.set_message_token('STEP','10');
627: hr_utility.raise_error;
628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 626: hr_utility.set_message_token('STEP','10');

622: hr_utility.raise_error;
623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
625: hr_utility.set_message_token('PROCEDURE', l_proc);
626: hr_utility.set_message_token('STEP','10');
627: hr_utility.raise_error;
628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
630: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 627: hr_utility.raise_error;

623: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
624: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
625: hr_utility.set_message_token('PROCEDURE', l_proc);
626: hr_utility.set_message_token('STEP','10');
627: hr_utility.raise_error;
628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
630: hr_utility.set_message_token('PROCEDURE', l_proc);
631: hr_utility.set_message_token('STEP','15');

Line 629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

625: hr_utility.set_message_token('PROCEDURE', l_proc);
626: hr_utility.set_message_token('STEP','10');
627: hr_utility.raise_error;
628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
630: hr_utility.set_message_token('PROCEDURE', l_proc);
631: hr_utility.set_message_token('STEP','15');
632: hr_utility.raise_error;
633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then

Line 630: hr_utility.set_message_token('PROCEDURE', l_proc);

626: hr_utility.set_message_token('STEP','10');
627: hr_utility.raise_error;
628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
630: hr_utility.set_message_token('PROCEDURE', l_proc);
631: hr_utility.set_message_token('STEP','15');
632: hr_utility.raise_error;
633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 631: hr_utility.set_message_token('STEP','15');

627: hr_utility.raise_error;
628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
630: hr_utility.set_message_token('PROCEDURE', l_proc);
631: hr_utility.set_message_token('STEP','15');
632: hr_utility.raise_error;
633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
635: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 632: hr_utility.raise_error;

628: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
629: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
630: hr_utility.set_message_token('PROCEDURE', l_proc);
631: hr_utility.set_message_token('STEP','15');
632: hr_utility.raise_error;
633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
635: hr_utility.set_message_token('PROCEDURE', l_proc);
636: hr_utility.set_message_token('STEP','20');

Line 634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

630: hr_utility.set_message_token('PROCEDURE', l_proc);
631: hr_utility.set_message_token('STEP','15');
632: hr_utility.raise_error;
633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
635: hr_utility.set_message_token('PROCEDURE', l_proc);
636: hr_utility.set_message_token('STEP','20');
637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then

Line 635: hr_utility.set_message_token('PROCEDURE', l_proc);

631: hr_utility.set_message_token('STEP','15');
632: hr_utility.raise_error;
633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
635: hr_utility.set_message_token('PROCEDURE', l_proc);
636: hr_utility.set_message_token('STEP','20');
637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 636: hr_utility.set_message_token('STEP','20');

632: hr_utility.raise_error;
633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
635: hr_utility.set_message_token('PROCEDURE', l_proc);
636: hr_utility.set_message_token('STEP','20');
637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 637: hr_utility.raise_error;

633: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
635: hr_utility.set_message_token('PROCEDURE', l_proc);
636: hr_utility.set_message_token('STEP','20');
637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');

Line 639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

635: hr_utility.set_message_token('PROCEDURE', l_proc);
636: hr_utility.set_message_token('STEP','20');
637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then

Line 640: hr_utility.set_message_token('PROCEDURE', l_proc);

636: hr_utility.set_message_token('STEP','20');
637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 641: hr_utility.set_message_token('STEP','25');

637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 642: hr_utility.raise_error;

638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');

Line 644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then

Line 645: hr_utility.set_message_token('PROCEDURE', l_proc);

641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 646: hr_utility.set_message_token('STEP','30');

642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 647: hr_utility.raise_error;

643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');

Line 649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then

Line 650: hr_utility.set_message_token('PROCEDURE', l_proc);

646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 651: hr_utility.set_message_token('STEP','35');

647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 652: hr_utility.raise_error;

648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');

Line 654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then

Line 655: hr_utility.set_message_token('PROCEDURE', l_proc);

651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 656: hr_utility.set_message_token('STEP','40');

652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 657: hr_utility.raise_error;

653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');

Line 659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then

Line 660: hr_utility.set_message_token('PROCEDURE', l_proc);

656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 661: hr_utility.set_message_token('STEP','45');

657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 662: hr_utility.raise_error;

658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','50');

Line 664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','50');
667: hr_utility.raise_error;
668: Else

Line 665: hr_utility.set_message_token('PROCEDURE', l_proc);

661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','50');
667: hr_utility.raise_error;
668: Else
669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 666: hr_utility.set_message_token('STEP','50');

662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','50');
667: hr_utility.raise_error;
668: Else
669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
670: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 667: hr_utility.raise_error;

663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','50');
667: hr_utility.raise_error;
668: Else
669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
670: hr_utility.set_message_token('PROCEDURE', l_proc);
671: hr_utility.set_message_token('STEP','55');

Line 669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','50');
667: hr_utility.raise_error;
668: Else
669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
670: hr_utility.set_message_token('PROCEDURE', l_proc);
671: hr_utility.set_message_token('STEP','55');
672: hr_utility.raise_error;
673: End If;

Line 670: hr_utility.set_message_token('PROCEDURE', l_proc);

666: hr_utility.set_message_token('STEP','50');
667: hr_utility.raise_error;
668: Else
669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
670: hr_utility.set_message_token('PROCEDURE', l_proc);
671: hr_utility.set_message_token('STEP','55');
672: hr_utility.raise_error;
673: End If;
674: --

Line 671: hr_utility.set_message_token('STEP','55');

667: hr_utility.raise_error;
668: Else
669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
670: hr_utility.set_message_token('PROCEDURE', l_proc);
671: hr_utility.set_message_token('STEP','55');
672: hr_utility.raise_error;
673: End If;
674: --
675: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 672: hr_utility.raise_error;

668: Else
669: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
670: hr_utility.set_message_token('PROCEDURE', l_proc);
671: hr_utility.set_message_token('STEP','55');
672: hr_utility.raise_error;
673: End If;
674: --
675: hr_utility.set_location(' Leaving:'||l_proc, 10);
676: End constraint_error;

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

671: hr_utility.set_message_token('STEP','55');
672: hr_utility.raise_error;
673: End If;
674: --
675: hr_utility.set_location(' Leaving:'||l_proc, 10);
676: End constraint_error;
677: --
678: -- ----------------------------------------------------------------------------
679: -- |------------------------------< insert_dml >------------------------------|

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

738: --
739: l_proc varchar2(72) := g_package||'insert_dml';
740: --
741: Begin
742: hr_utility.set_location('Entering:'||l_proc, 5);
743: --
744: -- Initialise the object version
745: --
746: p_rec.object_version_number := 1;

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

781: -- Unset the api dml status
782: --
783: g_api_dml := false;
784: --
785: hr_utility.set_location(' Leaving:'||l_proc, 10);
786: Exception
787: When hr_api.check_integrity_violated Then
788: -- A check constraint has been violated
789: g_api_dml := false; -- Unset the api dml status

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

847: --
848: l_proc varchar2(72) := g_package||'update_dml';
849: --
850: Begin
851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: -- Increment the object version
854: --
855: p_rec.object_version_number := p_rec.object_version_number + 1;

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

868: -- Unset the api dml status
869: --
870: g_api_dml := false;
871: --
872: hr_utility.set_location(' Leaving:'||l_proc, 10);
873: --
874: Exception
875: When hr_api.check_integrity_violated Then
876: -- A check constraint has been violated

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

935: --
936: l_proc varchar2(72) := g_package||'delete_dml';
937: --
938: Begin
939: hr_utility.set_location('Entering:'||l_proc, 5);
940: --
941: g_api_dml := true; -- Set the api dml status
942: --
943: -- Delete the pay_payroll_actions row.

Line 955: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

951: --
952: -- The row to be deleted was NOT found therefore a serious
953: -- error has occurred which MUST be reported.
954: --
955: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
956: hr_utility.set_message_token('PROCEDURE', l_proc);
957: hr_utility.set_message_token('STEP','5');
958: hr_utility.raise_error;
959: End If;

Line 956: hr_utility.set_message_token('PROCEDURE', l_proc);

952: -- The row to be deleted was NOT found therefore a serious
953: -- error has occurred which MUST be reported.
954: --
955: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
956: hr_utility.set_message_token('PROCEDURE', l_proc);
957: hr_utility.set_message_token('STEP','5');
958: hr_utility.raise_error;
959: End If;
960: --

Line 957: hr_utility.set_message_token('STEP','5');

953: -- error has occurred which MUST be reported.
954: --
955: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
956: hr_utility.set_message_token('PROCEDURE', l_proc);
957: hr_utility.set_message_token('STEP','5');
958: hr_utility.raise_error;
959: End If;
960: --
961: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 958: hr_utility.raise_error;

954: --
955: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
956: hr_utility.set_message_token('PROCEDURE', l_proc);
957: hr_utility.set_message_token('STEP','5');
958: hr_utility.raise_error;
959: End If;
960: --
961: hr_utility.set_location(' Leaving:'||l_proc, 10);
962: --

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

957: hr_utility.set_message_token('STEP','5');
958: hr_utility.raise_error;
959: End If;
960: --
961: hr_utility.set_location(' Leaving:'||l_proc, 10);
962: --
963: Exception
964: When hr_api.child_integrity_violated then
965: -- Child integrity has been violated

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

1030: , pya.consolidation_set_id
1031: from pay_payroll_actions pya
1032: where pya.payroll_action_id = v_target_payroll_action_id;
1033: Begin
1034: hr_utility.set_location('Entering:'||l_proc, 5);
1035: --
1036: -- Select the next sequence number
1037: --
1038: Open C_Sel1;

Line 1041: hr_utility.set_location(l_proc, 6);

1037: --
1038: Open C_Sel1;
1039: Fetch C_Sel1 Into p_rec.payroll_action_id;
1040: Close C_Sel1;
1041: hr_utility.set_location(l_proc, 6);
1042: --
1043: -- Set the initial action_status to unprocessed
1044: --
1045: p_rec.action_status := 'U';

Line 1068: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1064: close csr_qpq_details;
1065: -- Internal error
1066: -- The corresponding QuickPay Run payroll action has been deleted
1067: -- between validating it exists in insert_validate and pre_insert.
1068: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1069: hr_utility.set_message_token('PROCEDURE', l_proc);
1070: hr_utility.set_message_token('STEP', '1');
1071: hr_utility.raise_error;
1072: end if;

Line 1069: hr_utility.set_message_token('PROCEDURE', l_proc);

1065: -- Internal error
1066: -- The corresponding QuickPay Run payroll action has been deleted
1067: -- between validating it exists in insert_validate and pre_insert.
1068: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1069: hr_utility.set_message_token('PROCEDURE', l_proc);
1070: hr_utility.set_message_token('STEP', '1');
1071: hr_utility.raise_error;
1072: end if;
1073: close csr_qpq_details;

Line 1070: hr_utility.set_message_token('STEP', '1');

1066: -- The corresponding QuickPay Run payroll action has been deleted
1067: -- between validating it exists in insert_validate and pre_insert.
1068: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1069: hr_utility.set_message_token('PROCEDURE', l_proc);
1070: hr_utility.set_message_token('STEP', '1');
1071: hr_utility.raise_error;
1072: end if;
1073: close csr_qpq_details;
1074: --

Line 1071: hr_utility.raise_error;

1067: -- between validating it exists in insert_validate and pre_insert.
1068: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1069: hr_utility.set_message_token('PROCEDURE', l_proc);
1070: hr_utility.set_message_token('STEP', '1');
1071: hr_utility.raise_error;
1072: end if;
1073: close csr_qpq_details;
1074: --
1075: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1071: hr_utility.raise_error;
1072: end if;
1073: close csr_qpq_details;
1074: --
1075: hr_utility.set_location(' Leaving:'||l_proc, 10);
1076: End pre_insert;
1077: --
1078: -- ----------------------------------------------------------------------------
1079: -- |------------------------------< pre_update >------------------------------|

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

1106: --
1107: l_proc varchar2(72) := g_package||'pre_update';
1108: --
1109: Begin
1110: hr_utility.set_location('Entering:'||l_proc, 5);
1111: --
1112: hr_utility.set_location(' Leaving:'||l_proc, 10);
1113: End pre_update;
1114: --

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

1108: --
1109: Begin
1110: hr_utility.set_location('Entering:'||l_proc, 5);
1111: --
1112: hr_utility.set_location(' Leaving:'||l_proc, 10);
1113: End pre_update;
1114: --
1115: -- ----------------------------------------------------------------------------
1116: -- |------------------------------< pre_delete >------------------------------|

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

1143: --
1144: l_proc varchar2(72) := g_package||'pre_delete';
1145: --
1146: Begin
1147: hr_utility.set_location('Entering:'||l_proc, 5);
1148: --
1149: hr_utility.set_location(' Leaving:'||l_proc, 10);
1150: End pre_delete;
1151: --

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

1145: --
1146: Begin
1147: hr_utility.set_location('Entering:'||l_proc, 5);
1148: --
1149: hr_utility.set_location(' Leaving:'||l_proc, 10);
1150: End pre_delete;
1151: --
1152: -- ----------------------------------------------------------------------------
1153: -- |-----------------------------< post_insert >------------------------------|

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

1190: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1191: l_object_version_number pay_assignment_actions.object_version_number%TYPE;
1192: --
1193: Begin
1194: hr_utility.set_location('Entering:'||l_proc, 5);
1195: --
1196: -- Insert the QuickPay Pre-payment assignment action and the action interlock
1197: --
1198: hrassact.qpppassact

Line 1203: hr_utility.set_location(l_proc, 6);

1199: (p_payroll_action_id => p_rec.payroll_action_id
1200: ,p_assignment_action_id => l_assignment_action_id
1201: ,p_object_version_number => l_object_version_number
1202: );
1203: hr_utility.set_location(l_proc, 6);
1204: --
1205: p_assignment_action_id := l_assignment_action_id;
1206: p_a_object_version_number := l_object_version_number;
1207: --

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

1204: --
1205: p_assignment_action_id := l_assignment_action_id;
1206: p_a_object_version_number := l_object_version_number;
1207: --
1208: hr_utility.set_location(' Leaving:'||l_proc, 10);
1209: End post_insert;
1210: --
1211: -- ----------------------------------------------------------------------------
1212: -- |-----------------------------< post_update >------------------------------|

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

1239: --
1240: l_proc varchar2(72) := g_package||'post_update';
1241: --
1242: Begin
1243: hr_utility.set_location('Entering:'||l_proc, 5);
1244: --
1245: hr_utility.set_location(' Leaving:'||l_proc, 10);
1246: End post_update;
1247: --

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

1241: --
1242: Begin
1243: hr_utility.set_location('Entering:'||l_proc, 5);
1244: --
1245: hr_utility.set_location(' Leaving:'||l_proc, 10);
1246: End post_update;
1247: --
1248: -- ----------------------------------------------------------------------------
1249: -- |-----------------------------< post_delete >------------------------------|

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

1276: --
1277: l_proc varchar2(72) := g_package||'post_delete';
1278: --
1279: Begin
1280: hr_utility.set_location('Entering:'||l_proc, 5);
1281: --
1282: hr_utility.set_location(' Leaving:'||l_proc, 10);
1283: End post_delete;
1284: --

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

1278: --
1279: Begin
1280: hr_utility.set_location('Entering:'||l_proc, 5);
1281: --
1282: hr_utility.set_location(' Leaving:'||l_proc, 10);
1283: End post_delete;
1284: --
1285: -- ----------------------------------------------------------------------------
1286: -- |---------------------------------< lck >----------------------------------|

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

1315: --
1316: l_proc varchar2(72) := g_package||'lck';
1317: --
1318: Begin
1319: hr_utility.set_location('Entering:'||l_proc, 5);
1320: --
1321: -- Check the mandatory args have been set
1322: --
1323: hr_api.mandatory_arg_error

Line 1338: hr_utility.set_location(l_proc, 6);

1334: (p_api_name => l_proc
1335: ,p_argument => 'a_object_version_number'
1336: ,p_argument_value => p_a_object_version_number
1337: );
1338: hr_utility.set_location(l_proc, 6);
1339: --
1340: -- Additional logic specific to this entity:
1341: -- Do not allow the lock to be taken out if there is an AOL concurrent
1342: -- request waiting to run or still running on a concurrent manager.

Line 1346: hr_utility.set_location(l_proc, 7);

1342: -- request waiting to run or still running on a concurrent manager.
1343: --
1344: pay_qpq_api.chk_for_con_request
1345: (p_payroll_action_id => p_payroll_action_id);
1346: hr_utility.set_location(l_proc, 7);
1347: --
1348: open C_Sel1;
1349: Fetch C_Sel1 Into g_old_rec.payroll_action_id
1350: , g_old_rec.business_group_id

Line 1362: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1358: Close C_Sel1;
1359: --
1360: -- The primary key is invalid therefore we must error
1361: --
1362: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1363: hr_utility.raise_error;
1364: End If;
1365: Close C_Sel1;
1366: If (p_a_object_version_number <> g_old_rec.object_version_number) or

Line 1363: hr_utility.raise_error;

1359: --
1360: -- The primary key is invalid therefore we must error
1361: --
1362: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1363: hr_utility.raise_error;
1364: End If;
1365: Close C_Sel1;
1366: If (p_a_object_version_number <> g_old_rec.object_version_number) or
1367: (p_p_object_version_number <> l_p_object_version_number) Then

Line 1368: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

1364: End If;
1365: Close C_Sel1;
1366: If (p_a_object_version_number <> g_old_rec.object_version_number) or
1367: (p_p_object_version_number <> l_p_object_version_number) Then
1368: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1369: hr_utility.raise_error;
1370: End If;
1371: --
1372: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1369: hr_utility.raise_error;

1365: Close C_Sel1;
1366: If (p_a_object_version_number <> g_old_rec.object_version_number) or
1367: (p_p_object_version_number <> l_p_object_version_number) Then
1368: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1369: hr_utility.raise_error;
1370: End If;
1371: --
1372: hr_utility.set_location(' Leaving:'||l_proc, 10);
1373: --

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

1368: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1369: hr_utility.raise_error;
1370: End If;
1371: --
1372: hr_utility.set_location(' Leaving:'||l_proc, 10);
1373: --
1374: -- We need to trap the ORA LOCK exception
1375: --
1376: Exception

Line 1382: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

1378: --
1379: -- The object is locked therefore we need to supply a meaningful
1380: -- error message.
1381: --
1382: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1383: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
1384: hr_utility.raise_error;
1385: End lck;
1386: --

Line 1383: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');

1379: -- The object is locked therefore we need to supply a meaningful
1380: -- error message.
1381: --
1382: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1383: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
1384: hr_utility.raise_error;
1385: End lck;
1386: --
1387: -- ----------------------------------------------------------------------------

Line 1384: hr_utility.raise_error;

1380: -- error message.
1381: --
1382: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1383: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
1384: hr_utility.raise_error;
1385: End lck;
1386: --
1387: -- ----------------------------------------------------------------------------
1388: -- |-----------------------------< convert_args >-----------------------------|

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

1427: l_proc varchar2(72) := g_package||'convert_args';
1428: --
1429: Begin
1430: --
1431: hr_utility.set_location('Entering:'||l_proc, 5);
1432: --
1433: -- Convert arguments into local l_rec structure.
1434: --
1435: l_rec.payroll_action_id := p_payroll_action_id;

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

1441: l_rec.object_version_number := p_object_version_number;
1442: --
1443: -- Return the plsql record structure.
1444: --
1445: hr_utility.set_location(' Leaving:'||l_proc, 10);
1446: Return(l_rec);
1447: --
1448: End convert_args;
1449: --

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

1493: l_proc varchar2(72) := g_package||'convert_defs';
1494: --
1495: Begin
1496: --
1497: hr_utility.set_location('Entering:'||l_proc, 5);
1498: --
1499: -- We must now examine each argument value in the
1500: -- p_rec plsql record structure
1501: -- to see if a system default is being used. If a system default

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

1518: End If;
1519: --
1520: -- Return the plsql record structure.
1521: --
1522: hr_utility.set_location(' Leaving:'||l_proc, 10);
1523: Return(p_rec);
1524: --
1525: End convert_defs;
1526: --

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

1555: --
1556: l_proc varchar2(72) := g_package||'insert_validate';
1557: --
1558: Begin
1559: hr_utility.set_location('Entering:'||l_proc, 5);
1560: --
1561: -- Call all supporting business operations
1562: --
1563: --

Line 1571: hr_utility.set_location(l_proc, 6);

1567: (p_target_payroll_action_id => p_rec.target_payroll_action_id
1568: ,p_business_group_id => p_rec.business_group_id
1569: ,p_effective_date => p_rec.effective_date
1570: );
1571: hr_utility.set_location(l_proc, 6);
1572: --
1573: -- Validate org_payment_method_id
1574: --
1575: chk_org_payment_method_id

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

1577: ,p_business_group_id => p_rec.business_group_id
1578: ,p_effective_date => p_rec.effective_date
1579: );
1580: --
1581: hr_utility.set_location(' Leaving:'||l_proc, 10);
1582: End insert_validate;
1583: --
1584: -- ----------------------------------------------------------------------------
1585: -- |---------------------------< update_validate >----------------------------|

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

1612: --
1613: l_proc varchar2(72) := g_package||'update_validate';
1614: --
1615: Begin
1616: hr_utility.set_location('Entering:'||l_proc, 5);
1617: --
1618: -- Call all supporting business operations
1619: --
1620: -- Check that the columns which cannot be

Line 1624: hr_utility.set_location(l_proc, 6);

1620: -- Check that the columns which cannot be
1621: -- updated have not be changed.
1622: --
1623: check_non_updateable_args(p_rec => p_rec);
1624: hr_utility.set_location(l_proc, 6);
1625: --
1626: -- Check that the payroll_action has a null current_task.
1627: --
1628: chk_cur_task

Line 1631: hr_utility.set_location(l_proc, 7);

1627: --
1628: chk_cur_task
1629: (p_payroll_action_id => p_rec.payroll_action_id
1630: );
1631: hr_utility.set_location(l_proc, 7);
1632: --
1633: -- If the action_status has changed, validate it has only been
1634: -- changed to 'M'ark for Retry and that action is allowed to have
1635: -- a 'M'ark for Retry status. (Ensure this is always the last validation

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

1642: ,p_new_action_status => p_rec.action_status
1643: );
1644: end if;
1645: --
1646: hr_utility.set_location(' Leaving:'||l_proc, 10);
1647: End update_validate;
1648: --
1649: -- ----------------------------------------------------------------------------
1650: -- |---------------------------< delete_validate >----------------------------|

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

1677: --
1678: l_proc varchar2(72) := g_package||'delete_validate';
1679: --
1680: Begin
1681: hr_utility.set_location('Entering:'||l_proc, 5);
1682: --
1683: -- Check that the payroll_action has a null current_task.
1684: --
1685: chk_cur_task

Line 1688: hr_utility.set_location(l_proc, 7);

1684: --
1685: chk_cur_task
1686: (p_payroll_action_id => p_rec.payroll_action_id
1687: );
1688: hr_utility.set_location(l_proc, 7);
1689: --
1690: -- The following call checks the delete is valid. If this QuickPay
1691: -- Pre-payment can be removed any child rows such as pay_pre_payments will
1692: -- be deleted.

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

1694: py_rollback_pkg.rollback_payroll_action(
1695: p_payroll_action_id => p_rec.payroll_action_id,
1696: p_rollback_mode => 'ROLLBACK',
1697: p_leave_base_table_row => TRUE);
1698: hr_utility.set_location(' Leaving:'||l_proc, 10);
1699: End delete_validate;
1700: --
1701: -- ----------------------------------------------------------------------------
1702: -- |---------------------------------< ins >----------------------------------|

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

1723: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1724: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
1725: --
1726: Begin
1727: hr_utility.set_location('Entering:'||l_proc, 5);
1728: --
1729: -- Determine if the business process is to be validated.
1730: --
1731: If p_validate then

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

1777: If p_validate then
1778: Raise HR_Api.Validate_Enabled;
1779: End If;
1780: --
1781: hr_utility.set_location(' Leaving:'||l_proc, 10);
1782: Exception
1783: When HR_Api.Validate_Enabled Then
1784: --
1785: -- As the Validate_Enabled exception has been raised

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

1808: l_rec g_rec_type;
1809: l_proc varchar2(72) := g_package||'ins';
1810: --
1811: Begin
1812: hr_utility.set_location('Entering:'||l_proc, 5);
1813: --
1814: -- Call conversion function to turn arguments into the
1815: -- p_rec structure.
1816: --

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

1841: p_payroll_action_id := l_rec.payroll_action_id;
1842: p_action_status := l_rec.action_status;
1843: p_p_object_version_number := l_rec.object_version_number;
1844: --
1845: hr_utility.set_location(' Leaving:'||l_proc, 10);
1846: End ins;
1847: --
1848: -- ----------------------------------------------------------------------------
1849: -- |---------------------------------< upd >----------------------------------|

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

1858: --
1859: l_proc varchar2(72) := g_package||'upd';
1860: --
1861: Begin
1862: hr_utility.set_location('Entering:'||l_proc, 5);
1863: --
1864: -- Determine if the business process is to be validated.
1865: --
1866: If p_validate then

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

1903: If p_validate then
1904: Raise HR_Api.Validate_Enabled;
1905: End If;
1906: --
1907: hr_utility.set_location(' Leaving:'||l_proc, 10);
1908: Exception
1909: When HR_Api.Validate_Enabled Then
1910: --
1911: -- As the Validate_Enabled exception has been raised

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

1930: l_rec g_rec_type;
1931: l_proc varchar2(72) := g_package||'upd';
1932: --
1933: Begin
1934: hr_utility.set_location('Entering:'||l_proc, 5);
1935: --
1936: -- Call conversion function to turn arguments into the
1937: -- l_rec structure.
1938: --

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

1958: ,p_validate => p_validate
1959: );
1960: p_p_object_version_number := l_rec.object_version_number;
1961: --
1962: hr_utility.set_location(' Leaving:'||l_proc, 10);
1963: End upd;
1964: --
1965: -- ----------------------------------------------------------------------------
1966: -- |---------------------------------< del >----------------------------------|

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

1974: --
1975: l_proc varchar2(72) := g_package||'del';
1976: --
1977: Begin
1978: hr_utility.set_location('Entering:'||l_proc, 5);
1979: --
1980: -- Determine if the business process is to be validated.
1981: --
1982: If p_validate then

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

2015: If p_validate then
2016: Raise HR_Api.Validate_Enabled;
2017: End If;
2018: --
2019: hr_utility.set_location(' Leaving:'||l_proc, 10);
2020: Exception
2021: When HR_Api.Validate_Enabled Then
2022: --
2023: -- As the Validate_Enabled exception has been raised

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

2040: l_rec g_rec_type;
2041: l_proc varchar2(72) := g_package||'del';
2042: --
2043: Begin
2044: hr_utility.set_location('Entering:'||l_proc, 5);
2045: --
2046: -- As the delete procedure accepts a plsql record structure we do need to
2047: -- convert the arguments into the record structure.
2048: -- We don't need to call the supplied conversion argument routine as we

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

2059: (p_rec => l_rec
2060: ,p_a_object_version_number => p_a_object_version_number
2061: ,p_validate => p_validate
2062: );
2063: hr_utility.set_location(' Leaving:'||l_proc, 10);
2064: End del;
2065: --
2066: -- ----------------------------------------------------------------------------
2067: -- |--------------------------< get_latest_status >---------------------------|

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

2080: , pay_assignment_actions aga
2081: where pya.payroll_action_id = p_payroll_action_id
2082: and aga.payroll_action_id = pya.payroll_action_id;
2083: begin
2084: hr_utility.set_location('Entering:'|| l_proc, 5);
2085: --
2086: -- Check mandatory parameters have been set
2087: --
2088: hr_api.mandatory_arg_error

Line 2102: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2098: if cur_stat%notfound then
2099: close cur_stat;
2100: -- This procedure has been called with a payroll_action_id
2101: -- which does not exist in the database.
2102: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2103: hr_utility.set_message_token('PROCEDURE', l_proc);
2104: hr_utility.set_message_token('STEP', '5');
2105: hr_utility.raise_error;
2106: end if;

Line 2103: hr_utility.set_message_token('PROCEDURE', l_proc);

2099: close cur_stat;
2100: -- This procedure has been called with a payroll_action_id
2101: -- which does not exist in the database.
2102: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2103: hr_utility.set_message_token('PROCEDURE', l_proc);
2104: hr_utility.set_message_token('STEP', '5');
2105: hr_utility.raise_error;
2106: end if;
2107: close cur_stat;

Line 2104: hr_utility.set_message_token('STEP', '5');

2100: -- This procedure has been called with a payroll_action_id
2101: -- which does not exist in the database.
2102: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2103: hr_utility.set_message_token('PROCEDURE', l_proc);
2104: hr_utility.set_message_token('STEP', '5');
2105: hr_utility.raise_error;
2106: end if;
2107: close cur_stat;
2108: --

Line 2105: hr_utility.raise_error;

2101: -- which does not exist in the database.
2102: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2103: hr_utility.set_message_token('PROCEDURE', l_proc);
2104: hr_utility.set_message_token('STEP', '5');
2105: hr_utility.raise_error;
2106: end if;
2107: close cur_stat;
2108: --
2109: hr_utility.set_location(' Leaving:'|| l_proc, 10);

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

2105: hr_utility.raise_error;
2106: end if;
2107: close cur_stat;
2108: --
2109: hr_utility.set_location(' Leaving:'|| l_proc, 10);
2110: end get_latest_status;
2111: --
2112: end pay_qpu_api;