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

Line 84: hr_utility.set_location('Entering :qppsassact',10);

80: -- We have to get the assignment_id
81: -- of the assignment that is going
82: -- to be archived, so it may be passed on.
83: --
84: hr_utility.set_location('Entering :qppsassact',10);
85:
86:
87: open c_asgid;
88: fetch c_asgid into l_assignment_id;

Line 90: hr_utility.set_location('qppsassact',30);

86:
87: open c_asgid;
88: fetch c_asgid into l_assignment_id;
89: if l_assignment_id is not null then
90: hr_utility.set_location('qppsassact',30);
91: --First find the tax unit id of the pre-payment process
92: open c_qppaction;
93: fetch c_qppaction into l_qpp_locked_action_id,l_tax_unit_id;
94: open c_next_assact;

Line 113: hr_utility.set_location(' qppsassact :',40);

109:
110: if c_qparcassact%found then
111:
112: --Then insert the quick-pay action rows into pay_action_interlocks
113: hr_utility.set_location(' qppsassact :',40);
114: open c_qpaction;
115: fetch c_qpaction into l_qp_locked_action_id;
116: if c_qpaction%found then
117: -- We can now insert interlock row.

Line 118: hr_utility.set_location('qppsassact',50);

114: open c_qpaction;
115: fetch c_qpaction into l_qp_locked_action_id;
116: if c_qpaction%found then
117: -- We can now insert interlock row.
118: hr_utility.set_location('qppsassact',50);
119: hr_nonrun_asact.insint(l_locking_action_id,l_qp_locked_action_id);
120: end if;
121: close c_qpaction;
122:

Line 124: hr_utility.set_location(' qppsassact ',55);

120: end if;
121: close c_qpaction;
122:
123: --Then insert the quick-pay pre-payment action rows
124: hr_utility.set_location(' qppsassact ',55);
125: hr_nonrun_asact.insint(l_locking_action_id,l_qpp_locked_action_id);
126: end if;
127:
128:

Line 129: hr_utility.set_location(' qppsassact :',60);

125: hr_nonrun_asact.insint(l_locking_action_id,l_qpp_locked_action_id);
126: end if;
127:
128:
129: hr_utility.set_location(' qppsassact :',60);
130: -- Update the payroll actions table with the
131: -- appropriate date_earned value.
132: hr_utility.set_location('qppsassact',70);
133: update pay_payroll_actions pac

Line 132: hr_utility.set_location('qppsassact',70);

128:
129: hr_utility.set_location(' qppsassact :',60);
130: -- Update the payroll actions table with the
131: -- appropriate date_earned value.
132: hr_utility.set_location('qppsassact',70);
133: update pay_payroll_actions pac
134: set pac.date_earned = (
135: select pa2.date_earned
136: from pay_payroll_actions pa2,

Line 155: hr_utility.set_location('qppsassact',75);

151:
152: --
153: -- update the action_population_status to indicate
154: -- an action has been successfully inserted.
155: hr_utility.set_location('qppsassact',75);
156: update pay_payroll_actions pac
157: set pac.action_population_status = 'C'
158: where pac.payroll_action_id = p_payroll_action_id;
159:

Line 160: hr_utility.set_location('Leaving : qppsassact',80);

156: update pay_payroll_actions pac
157: set pac.action_population_status = 'C'
158: where pac.payroll_action_id = p_payroll_action_id;
159:
160: hr_utility.set_location('Leaving : qppsassact',80);
161:
162: end qppsassact;
163: --
164:

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

202: --
203: l_proc varchar2(72) := g_package||'chk_action_status';
204: --
205: begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- Check the updated status is from 'C'omplete to 'M'ark for Retry
209: --
210: if (p_old_action_status not in ('C', 'S')) and (p_new_action_status <> 'M') then

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

210: if (p_old_action_status not in ('C', 'S')) and (p_new_action_status <> 'M') then
211: -- Error: You have tried to enter an invalid status for a completed
212: -- QuickPay run. You can only update a completed assignment process
213: -- status to Marked for Retry.
214: hr_utility.set_message(801, 'HR_7252_QPAY_ONLY_MARK_RETRY');
215: hr_utility.raise_error;
216: end if;
217: hr_utility.set_location(l_proc, 6);
218: --

Line 215: hr_utility.raise_error;

211: -- Error: You have tried to enter an invalid status for a completed
212: -- QuickPay run. You can only update a completed assignment process
213: -- status to Marked for Retry.
214: hr_utility.set_message(801, 'HR_7252_QPAY_ONLY_MARK_RETRY');
215: hr_utility.raise_error;
216: end if;
217: hr_utility.set_location(l_proc, 6);
218: --
219: -- Check that this QuickPay Archival can have

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

213: -- status to Marked for Retry.
214: hr_utility.set_message(801, 'HR_7252_QPAY_ONLY_MARK_RETRY');
215: hr_utility.raise_error;
216: end if;
217: hr_utility.set_location(l_proc, 6);
218: --
219: -- Check that this QuickPay Archival can have
220: -- a status of Mark for Retry
221: --

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

223: p_payroll_action_id => p_payroll_action_id,
224: p_rollback_mode => 'RETRY',
225: p_leave_base_table_row => TRUE);
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: end chk_action_status;
229: --
230: -- ----------------------------------------------------------------------------
231: -- |-----------------------------< chk_cur_task >-----------------------------|

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

270: from pay_payroll_actions
271: where payroll_action_id = p_payroll_action_id
272: and current_task is not null;
273: begin
274: hr_utility.set_location('Entering:'|| l_proc, 5);
275: --
276: open sel_task;
277: fetch sel_task into v_exists;
278: if sel_task%found then

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

278: if sel_task%found then
279: close sel_task;
280: -- Error: You have tried to update or delete a QuickPay Archival while
281: -- the corresponding payroll process has a status of Processing.
282: hr_utility.set_message(801, 'HR_7256_QPAY_U_PROCESSING');
283: hr_utility.raise_error;
284: end if;
285: close sel_task;
286: --

Line 283: hr_utility.raise_error;

279: close sel_task;
280: -- Error: You have tried to update or delete a QuickPay Archival while
281: -- the corresponding payroll process has a status of Processing.
282: hr_utility.set_message(801, 'HR_7256_QPAY_U_PROCESSING');
283: hr_utility.raise_error;
284: end if;
285: close sel_task;
286: --
287: hr_utility.set_location(' Leaving:'|| l_proc, 10);

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

283: hr_utility.raise_error;
284: end if;
285: close sel_task;
286: --
287: hr_utility.set_location(' Leaving:'|| l_proc, 10);
288: end chk_cur_task;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |----------------------< check_non_updateable_args >-----------------------|

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

322: --
323: l_proc varchar2(72) := g_package||'check_non_updateable_args';
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: if nvl(p_rec.business_group_id, hr_api.g_number) <>
329: nvl(g_old_rec.business_group_id, hr_api.g_number) then
330: hr_api.argument_changed_error

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

331: (p_api_name => l_proc
332: ,p_argument => 'business_group_id'
333: );
334: end if;
335: hr_utility.set_location(l_proc, 6);
336: --
337: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
338: nvl(g_old_rec.org_payment_method_id, hr_api.g_number) then
339: hr_api.argument_changed_error

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

340: (p_api_name => l_proc
341: ,p_argument => 'org_payment_method_id'
342: );
343: end if;
344: hr_utility.set_location(l_proc, 7);
345: --
346: if nvl(p_rec.target_payroll_action_id, hr_api.g_number) <>
347: nvl(g_old_rec.target_payroll_action_id, hr_api.g_number) then
348: hr_api.argument_changed_error

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

349: (p_api_name => l_proc
350: ,p_argument => 'target_payroll_action_id'
351: );
352: end if;
353: hr_utility.set_location(l_proc, 8);
354: --
355: if nvl(p_rec.effective_date, hr_api.g_date) <>
356: nvl(g_old_rec.effective_date, hr_api.g_date) then
357: hr_api.argument_changed_error

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

359: ,p_argument => 'effective_date'
360: );
361: end if;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: end check_non_updateable_args;
365: --
366:
367: -- ----------------------------------------------------------------------------

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

435: and pya.business_group_id = p_business_group_id
436: and pya.effective_date = p_effective_date;
437: --
438: begin
439: hr_utility.set_location('Entering:'|| l_proc, 5);
440: --
441: -- Check mandatory parameters have been set
442: --
443: hr_api.mandatory_arg_error

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

456: ,p_argument => 'effective_date'
457: ,p_argument_value => p_effective_date
458:
459: );
460: hr_utility.set_location(l_proc, 6);
461: --
462: -- Check the target_payroll_action_id exists in pay_payroll_actions
463: -- and it is for a completed QuickPay Run assignment action.
464: --

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

469: -- Error: You have tried to create a QuickPay Archival for a
470: -- target_payroll_action_id that does not exist, or for a QuickPay run
471: -- that does not have the status Complete.
472:
473: hr_utility.set_message(801, 'HR_7257_QPAY_U_QRUN_NOT_EXIST');
474: hr_utility.raise_error;
475: end if;
476: close csr_pay_act;
477: hr_utility.set_location(l_proc, 7);

Line 474: hr_utility.raise_error;

470: -- target_payroll_action_id that does not exist, or for a QuickPay run
471: -- that does not have the status Complete.
472:
473: hr_utility.set_message(801, 'HR_7257_QPAY_U_QRUN_NOT_EXIST');
474: hr_utility.raise_error;
475: end if;
476: close csr_pay_act;
477: hr_utility.set_location(l_proc, 7);
478: --

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

473: hr_utility.set_message(801, 'HR_7257_QPAY_U_QRUN_NOT_EXIST');
474: hr_utility.raise_error;
475: end if;
476: close csr_pay_act;
477: hr_utility.set_location(l_proc, 7);
478: --
479: --
480: -- Check the QuickPay Archival run business group and effective_date are the
481: -- same as the QuickPay Run business group and effective_date (date_paid).

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

487: close csr_bus_grp;
488: -- Error: The business_group and date_paid attributes for the QuickPay
489: -- Archival must have the same values as the business_group and
490: -- date_paid for the QuickPay run.
491: hr_utility.set_message(801, 'HR_7260_QPAY_U_SAME_AS_Q');
492: hr_utility.raise_error;
493: end if;
494: close csr_bus_grp;
495: --

Line 492: hr_utility.raise_error;

488: -- Error: The business_group and date_paid attributes for the QuickPay
489: -- Archival must have the same values as the business_group and
490: -- date_paid for the QuickPay run.
491: hr_utility.set_message(801, 'HR_7260_QPAY_U_SAME_AS_Q');
492: hr_utility.raise_error;
493: end if;
494: close csr_bus_grp;
495: --
496:

Line 497: hr_utility.set_location(' Leaving:'|| l_proc, 9);

493: end if;
494: close csr_bus_grp;
495: --
496:
497: hr_utility.set_location(' Leaving:'|| l_proc, 9);
498: end chk_target_payroll_action_id;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |------------------------< return_api_dml_status >-------------------------|

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

506: --
507: l_proc varchar2(72) := g_package||'return_api_dml_status';
508: --
509: Begin
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: Return (nvl(g_api_dml, false));
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: Return (nvl(g_api_dml, false));
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: End return_api_dml_status;
516: --
517: -- ----------------------------------------------------------------------------
518:

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

573: l_proc varchar2(72) := g_package||'constraint_error';
574:
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
580: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
581: hr_utility.set_message_token('PROCEDURE', l_proc);

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

576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
580: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
581: hr_utility.set_message_token('PROCEDURE', l_proc);
582: hr_utility.set_message_token('STEP','5');
583: hr_utility.raise_error;
584: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then

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

577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
580: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
581: hr_utility.set_message_token('PROCEDURE', l_proc);
582: hr_utility.set_message_token('STEP','5');
583: hr_utility.raise_error;
584: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
585: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

578: --
579: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
580: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
581: hr_utility.set_message_token('PROCEDURE', l_proc);
582: hr_utility.set_message_token('STEP','5');
583: hr_utility.raise_error;
584: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
585: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
586: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 583: hr_utility.raise_error;

579: If (p_constraint_name = 'PAY_PAYRACT_ACTION_POPULAT_CHK') Then
580: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
581: hr_utility.set_message_token('PROCEDURE', l_proc);
582: hr_utility.set_message_token('STEP','5');
583: hr_utility.raise_error;
584: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
585: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
586: hr_utility.set_message_token('PROCEDURE', l_proc);
587: hr_utility.set_message_token('STEP','10');

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

581: hr_utility.set_message_token('PROCEDURE', l_proc);
582: hr_utility.set_message_token('STEP','5');
583: hr_utility.raise_error;
584: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
585: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
586: hr_utility.set_message_token('PROCEDURE', l_proc);
587: hr_utility.set_message_token('STEP','10');
588:
589: hr_utility.raise_error;

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

582: hr_utility.set_message_token('STEP','5');
583: hr_utility.raise_error;
584: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
585: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
586: hr_utility.set_message_token('PROCEDURE', l_proc);
587: hr_utility.set_message_token('STEP','10');
588:
589: hr_utility.raise_error;
590: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then

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

583: hr_utility.raise_error;
584: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_STATUS_CHK') Then
585: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
586: hr_utility.set_message_token('PROCEDURE', l_proc);
587: hr_utility.set_message_token('STEP','10');
588:
589: hr_utility.raise_error;
590: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
591: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 589: hr_utility.raise_error;

585: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
586: hr_utility.set_message_token('PROCEDURE', l_proc);
587: hr_utility.set_message_token('STEP','10');
588:
589: hr_utility.raise_error;
590: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
591: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
592: hr_utility.set_message_token('PROCEDURE', l_proc);
593: hr_utility.set_message_token('STEP','15');

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

587: hr_utility.set_message_token('STEP','10');
588:
589: hr_utility.raise_error;
590: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
591: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
592: hr_utility.set_message_token('PROCEDURE', l_proc);
593: hr_utility.set_message_token('STEP','15');
594: hr_utility.raise_error;
595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then

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

588:
589: hr_utility.raise_error;
590: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
591: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
592: hr_utility.set_message_token('PROCEDURE', l_proc);
593: hr_utility.set_message_token('STEP','15');
594: hr_utility.raise_error;
595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

589: hr_utility.raise_error;
590: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
591: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
592: hr_utility.set_message_token('PROCEDURE', l_proc);
593: hr_utility.set_message_token('STEP','15');
594: hr_utility.raise_error;
595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 594: hr_utility.raise_error;

590: ElsIf (p_constraint_name = 'PAY_PAYRACT_ACTION_TYPE_CHK') Then
591: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
592: hr_utility.set_message_token('PROCEDURE', l_proc);
593: hr_utility.set_message_token('STEP','15');
594: hr_utility.raise_error;
595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE', l_proc);
598: hr_utility.set_message_token('STEP','20');

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

592: hr_utility.set_message_token('PROCEDURE', l_proc);
593: hr_utility.set_message_token('STEP','15');
594: hr_utility.raise_error;
595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE', l_proc);
598: hr_utility.set_message_token('STEP','20');
599: hr_utility.raise_error;
600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then

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

593: hr_utility.set_message_token('STEP','15');
594: hr_utility.raise_error;
595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE', l_proc);
598: hr_utility.set_message_token('STEP','20');
599: hr_utility.raise_error;
600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

594: hr_utility.raise_error;
595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE', l_proc);
598: hr_utility.set_message_token('STEP','20');
599: hr_utility.raise_error;
600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
602:

Line 599: hr_utility.raise_error;

595: ElsIf (p_constraint_name = 'PAY_PAYRACT_CURRENT_TASK_CHK') Then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE', l_proc);
598: hr_utility.set_message_token('STEP','20');
599: hr_utility.raise_error;
600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
602:
603: hr_utility.set_message_token('PROCEDURE', l_proc);

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

597: hr_utility.set_message_token('PROCEDURE', l_proc);
598: hr_utility.set_message_token('STEP','20');
599: hr_utility.raise_error;
600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
602:
603: hr_utility.set_message_token('PROCEDURE', l_proc);
604: hr_utility.set_message_token('STEP','25');
605: hr_utility.raise_error;

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

599: hr_utility.raise_error;
600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
602:
603: hr_utility.set_message_token('PROCEDURE', l_proc);
604: hr_utility.set_message_token('STEP','25');
605: hr_utility.raise_error;
606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
602:
603: hr_utility.set_message_token('PROCEDURE', l_proc);
604: hr_utility.set_message_token('STEP','25');
605: hr_utility.raise_error;
606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 605: hr_utility.raise_error;

601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
602:
603: hr_utility.set_message_token('PROCEDURE', l_proc);
604: hr_utility.set_message_token('STEP','25');
605: hr_utility.raise_error;
606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');

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

603: hr_utility.set_message_token('PROCEDURE', l_proc);
604: hr_utility.set_message_token('STEP','25');
605: hr_utility.raise_error;
606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then

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

604: hr_utility.set_message_token('STEP','25');
605: hr_utility.raise_error;
606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

605: hr_utility.raise_error;
606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 610: hr_utility.raise_error;

606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE', l_proc);
614: hr_utility.set_message_token('STEP','35');

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

608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE', l_proc);
614: hr_utility.set_message_token('STEP','35');
615: hr_utility.raise_error;
616:

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

609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE', l_proc);
614: hr_utility.set_message_token('STEP','35');
615: hr_utility.raise_error;
616:
617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then

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

610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE', l_proc);
614: hr_utility.set_message_token('STEP','35');
615: hr_utility.raise_error;
616:
617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 615: hr_utility.raise_error;

611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE', l_proc);
614: hr_utility.set_message_token('STEP','35');
615: hr_utility.raise_error;
616:
617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
619: hr_utility.set_message_token('PROCEDURE', l_proc);

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

614: hr_utility.set_message_token('STEP','35');
615: hr_utility.raise_error;
616:
617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
619: hr_utility.set_message_token('PROCEDURE', l_proc);
620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;
622: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then

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

615: hr_utility.raise_error;
616:
617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
619: hr_utility.set_message_token('PROCEDURE', l_proc);
620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;
622: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

616:
617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
619: hr_utility.set_message_token('PROCEDURE', l_proc);
620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;
622: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 621: hr_utility.raise_error;

617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
619: hr_utility.set_message_token('PROCEDURE', l_proc);
620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;
622: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE', l_proc);
625: hr_utility.set_message_token('STEP','45');

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

619: hr_utility.set_message_token('PROCEDURE', l_proc);
620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;
622: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE', l_proc);
625: hr_utility.set_message_token('STEP','45');
626: hr_utility.raise_error;
627: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then

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

620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;
622: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE', l_proc);
625: hr_utility.set_message_token('STEP','45');
626: hr_utility.raise_error;
627: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
628: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

Line 626: hr_utility.raise_error;

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

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

624: hr_utility.set_message_token('PROCEDURE', l_proc);
625: hr_utility.set_message_token('STEP','45');
626: hr_utility.raise_error;
627: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
628: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
629: hr_utility.set_message_token('PROCEDURE', l_proc);
630:
631: hr_utility.set_message_token('STEP','50');
632: hr_utility.raise_error;

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

625: hr_utility.set_message_token('STEP','45');
626: hr_utility.raise_error;
627: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
628: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
629: hr_utility.set_message_token('PROCEDURE', l_proc);
630:
631: hr_utility.set_message_token('STEP','50');
632: hr_utility.raise_error;
633: Else

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

627: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
628: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
629: hr_utility.set_message_token('PROCEDURE', l_proc);
630:
631: hr_utility.set_message_token('STEP','50');
632: hr_utility.raise_error;
633: Else
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: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
629: hr_utility.set_message_token('PROCEDURE', l_proc);
630:
631: hr_utility.set_message_token('STEP','50');
632: hr_utility.raise_error;
633: Else
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','55');

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

630:
631: hr_utility.set_message_token('STEP','50');
632: hr_utility.raise_error;
633: Else
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','55');
637: hr_utility.raise_error;
638: End If;

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

631: hr_utility.set_message_token('STEP','50');
632: hr_utility.raise_error;
633: Else
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','55');
637: hr_utility.raise_error;
638: End If;
639: --

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

632: hr_utility.raise_error;
633: Else
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','55');
637: hr_utility.raise_error;
638: End If;
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 637: hr_utility.raise_error;

633: Else
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','55');
637: hr_utility.raise_error;
638: End If;
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: End constraint_error;

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

636: hr_utility.set_message_token('STEP','55');
637: hr_utility.raise_error;
638: End If;
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: End constraint_error;
642: --
643: -- ----------------------------------------------------------------------------
644: -- |---------------------------------< lck >----------------------------------|

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

673: --
674: l_proc varchar2(72) := g_package||'lck';
675: --
676: Begin
677: hr_utility.set_location('Entering:'||l_proc, 5);
678: --
679: -- Check the mandatory args have been set
680: --
681: hr_api.mandatory_arg_error

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

692: (p_api_name => l_proc
693: ,p_argument => 'a_object_version_number'
694: ,p_argument_value => p_a_object_version_number
695: );
696: hr_utility.set_location(l_proc, 6);
697: --
698: -- Additional logic specific to this entity:
699: -- Do not allow the lock to be taken out if there is an AOL concurrent
700: -- request waiting to run or still running on a concurrent manager.

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

700: -- request waiting to run or still running on a concurrent manager.
701: --
702: pay_qpq_api.chk_for_con_request
703: (p_payroll_action_id => p_payroll_action_id);
704: hr_utility.set_location(l_proc, 7);
705: --
706: open C_lock;
707: Fetch C_lock Into g_old_rec.payroll_action_id
708: , g_old_rec.business_group_id

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

716: Close C_lock;
717: --
718: -- The primary key is invalid therefore we must error
719: --
720: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
721: hr_utility.raise_error;
722: End If;
723: Close C_lock;
724: If (p_a_object_version_number <> g_old_rec.object_version_number) or

Line 721: hr_utility.raise_error;

717: --
718: -- The primary key is invalid therefore we must error
719: --
720: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
721: hr_utility.raise_error;
722: End If;
723: Close C_lock;
724: If (p_a_object_version_number <> g_old_rec.object_version_number) or
725: (p_p_object_version_number <> l_p_object_version_number) Then

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

722: End If;
723: Close C_lock;
724: If (p_a_object_version_number <> g_old_rec.object_version_number) or
725: (p_p_object_version_number <> l_p_object_version_number) Then
726: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
727: hr_utility.raise_error;
728: End If;
729: --
730: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 727: hr_utility.raise_error;

723: Close C_lock;
724: If (p_a_object_version_number <> g_old_rec.object_version_number) or
725: (p_p_object_version_number <> l_p_object_version_number) Then
726: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
727: hr_utility.raise_error;
728: End If;
729: --
730: hr_utility.set_location(' Leaving:'||l_proc, 10);
731: --

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

726: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
727: hr_utility.raise_error;
728: End If;
729: --
730: hr_utility.set_location(' Leaving:'||l_proc, 10);
731: --
732: -- We need to trap the ORA LOCK exception
733: --
734: Exception

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

736: --
737: -- The object is locked therefore we need to supply a meaningful
738: -- error message.
739: --
740: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
741: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
742: hr_utility.raise_error;
743: End lck;
744: --

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

737: -- The object is locked therefore we need to supply a meaningful
738: -- error message.
739: --
740: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
741: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
742: hr_utility.raise_error;
743: End lck;
744: --
745: -- ----------------------------------------------------------------------------

Line 742: hr_utility.raise_error;

738: -- error message.
739: --
740: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
741: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
742: hr_utility.raise_error;
743: End lck;
744: --
745: -- ----------------------------------------------------------------------------
746: -- |-----------------------------< convert_defs >-----------------------------|

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

788: l_proc varchar2(72) := g_package||'convert_defs';
789: --
790: Begin
791: --
792: hr_utility.set_location('Entering:'||l_proc, 5);
793: --
794: -- We must now examine each argument value in the
795: -- p_rec plsql record structure
796: -- to see if a system default is being used. If a system default

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

813: End If;
814: --
815: -- Return the plsql record structure.
816: --
817: hr_utility.set_location(' Leaving:'||l_proc, 10);
818: Return(p_rec);
819: --
820: End convert_defs;
821: --

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

862: --
863: l_proc varchar2(72) := g_package||'update_dml';
864: --
865: Begin
866: hr_utility.set_location('Entering:'||l_proc, 5);
867: --
868: -- Increment the object version
869: --
870: p_rec.object_version_number := p_rec.object_version_number + 1;

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

883: -- Unset the api dml status
884: --
885: g_api_dml := false;
886: --
887: hr_utility.set_location(' Leaving:'||l_proc, 10);
888: --
889: Exception
890: When hr_api.check_integrity_violated Then
891: -- A check constraint has been violated

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

973: --
974: l_proc varchar2(72) := g_package||'insert_dml';
975: --
976: Begin
977: hr_utility.set_location('Entering:'||l_proc, 5);
978: --
979:
980: -- Initialise the object version
981: --

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

1026: --
1027:
1028: g_api_dml := false;
1029: --
1030: hr_utility.set_location(' Leaving:'||l_proc, 10);
1031: Exception
1032: When hr_api.check_integrity_violated Then
1033: -- A check constraint has been violated
1034: g_api_dml := false; -- Unset the api dml status

Line 1050: hr_utility.set_location('Others exception '||l_proc,-999);

1046: constraint_error
1047: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1048: When Others Then
1049: g_api_dml := false; -- Unset the api dml status
1050: hr_utility.set_location('Others exception '||l_proc,-999);
1051: Raise;
1052: End insert_dml;
1053: --
1054: -- ----------------------------------------------------------------------------

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

1082: --
1083: l_proc varchar2(72) := g_package||'pre_update';
1084: --
1085: Begin
1086: hr_utility.set_location('Entering:'||l_proc, 5);
1087: --
1088: hr_utility.set_location(' Leaving:'||l_proc, 10);
1089: End pre_update;
1090: --

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

1084: --
1085: Begin
1086: hr_utility.set_location('Entering:'||l_proc, 5);
1087: --
1088: hr_utility.set_location(' Leaving:'||l_proc, 10);
1089: End pre_update;
1090: --
1091:
1092: -- ----------------------------------------------------------------------------

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

1150: , pya.consolidation_set_id
1151: from pay_payroll_actions pya
1152: where pya.payroll_action_id = v_target_payroll_action_id;
1153: Begin
1154: hr_utility.set_location('Entering:'||l_proc, 5);
1155: --
1156: -- Select the next sequence number
1157: --
1158: Open C_next_id;

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

1157: --
1158: Open C_next_id;
1159: Fetch C_next_id Into p_rec.payroll_action_id;
1160: Close C_next_id;
1161: hr_utility.set_location(l_proc, 6);
1162: --
1163: -- Set the action_status to Mark for Retry
1164: --
1165: p_rec.action_status := 'M';

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

1185: close csr_qpq_details;
1186: -- Internal error
1187: -- The corresponding QuickPay Run payroll action has been deleted
1188: -- between validating it exists in insert_validate and pre_insert.
1189: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1190: hr_utility.set_message_token('PROCEDURE', l_proc);
1191:
1192: hr_utility.set_message_token('STEP', '1');
1193: hr_utility.raise_error;

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

1186: -- Internal error
1187: -- The corresponding QuickPay Run payroll action has been deleted
1188: -- between validating it exists in insert_validate and pre_insert.
1189: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1190: hr_utility.set_message_token('PROCEDURE', l_proc);
1191:
1192: hr_utility.set_message_token('STEP', '1');
1193: hr_utility.raise_error;
1194: end if;

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

1188: -- between validating it exists in insert_validate and pre_insert.
1189: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1190: hr_utility.set_message_token('PROCEDURE', l_proc);
1191:
1192: hr_utility.set_message_token('STEP', '1');
1193: hr_utility.raise_error;
1194: end if;
1195: close csr_qpq_details;
1196: --

Line 1193: hr_utility.raise_error;

1189: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1190: hr_utility.set_message_token('PROCEDURE', l_proc);
1191:
1192: hr_utility.set_message_token('STEP', '1');
1193: hr_utility.raise_error;
1194: end if;
1195: close csr_qpq_details;
1196: --
1197: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1193: hr_utility.raise_error;
1194: end if;
1195: close csr_qpq_details;
1196: --
1197: hr_utility.set_location(' Leaving:'||l_proc, 10);
1198: End pre_insert;
1199: --
1200: -- ----------------------------------------------------------------------------
1201: -- |-----------------------------< post_update >------------------------------|

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

1228: --
1229: l_proc varchar2(72) := g_package||'post_update';
1230: --
1231: Begin
1232: hr_utility.set_location('Entering:'||l_proc, 5);
1233: --
1234: hr_utility.set_location(' Leaving:'||l_proc, 10);
1235: End post_update;
1236: --

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

1230: --
1231: Begin
1232: hr_utility.set_location('Entering:'||l_proc, 5);
1233: --
1234: hr_utility.set_location(' Leaving:'||l_proc, 10);
1235: End post_update;
1236: --
1237: -- ----------------------------------------------------------------------------
1238: -- |-----------------------------< post_insert >------------------------------|

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

1278: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1279: l_object_version_number pay_assignment_actions.object_version_number%TYPE;
1280: --
1281: Begin
1282: hr_utility.set_location('Entering:'||l_proc, 5);
1283: --
1284: -- Insert the QuickPay Archival Run assignment action and the action interlock
1285: --
1286: qppsassact

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

1288: ,p_assignment_action_id => l_assignment_action_id
1289: ,p_object_version_number => l_object_version_number
1290: );
1291:
1292: hr_utility.set_location(l_proc, 6);
1293: --
1294: p_assignment_action_id := l_assignment_action_id;
1295: p_a_object_version_number := l_object_version_number;
1296: --

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

1293: --
1294: p_assignment_action_id := l_assignment_action_id;
1295: p_a_object_version_number := l_object_version_number;
1296: --
1297: hr_utility.set_location(' Leaving:'||l_proc, 10);
1298: End post_insert;
1299: --
1300: -- ----------------------------------------------------------------------------
1301: -- |-----------------------------< convert_args >-----------------------------|

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

1344: l_proc varchar2(72) := g_package||'convert_args';
1345: --
1346: Begin
1347: --
1348: hr_utility.set_location('Entering:'||l_proc, 5);
1349: --
1350: -- Convert arguments into local l_rec structure.
1351:
1352: --

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

1363: l_rec.report_category := p_report_category;
1364: --
1365: -- Return the plsql record structure.
1366: --
1367: hr_utility.set_location(' Leaving:'||l_proc, 10);
1368: Return(l_rec);
1369:
1370: --
1371: End convert_args;

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

1402: --
1403: l_proc varchar2(72) := g_package||'update_validate';
1404: --
1405: Begin
1406: hr_utility.set_location('Entering:'||l_proc, 5);
1407: --
1408: -- Call all supporting business operations
1409: --
1410: -- Check that the columns which cannot be

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

1410: -- Check that the columns which cannot be
1411: -- updated have not be changed.
1412: --
1413: check_non_updateable_args(p_rec => p_rec);
1414: hr_utility.set_location(l_proc, 6);
1415: --
1416: -- Check that the payroll_action has a null current_task.
1417: --
1418: chk_cur_task

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

1417: --
1418: chk_cur_task
1419: (p_payroll_action_id => p_rec.payroll_action_id
1420: );
1421: hr_utility.set_location(l_proc, 7);
1422: --
1423: -- If the action_status has changed, validate it has only been
1424: -- changed to 'M'ark for Retry and that action is allowed to have
1425: -- a 'M'ark for Retry status. (Ensure this is always the last validation

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

1433: ,p_new_action_status => p_rec.action_status
1434: );
1435: end if;
1436: --
1437: hr_utility.set_location(' Leaving:'||l_proc, 10);
1438: End update_validate;
1439: --
1440: -- ----------------------------------------------------------------------------
1441: -- |---------------------------< insert_validate >----------------------------|

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

1470: --
1471: l_proc varchar2(72) := g_package||'insert_validate';
1472: --
1473: Begin
1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: --
1476: -- Call all supporting business operations
1477: --
1478: --

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

1483: ,p_business_group_id => p_rec.business_group_id
1484: ,p_effective_date => p_rec.effective_date
1485: );
1486: --
1487: hr_utility.set_location(' Leaving:'||l_proc, 10);
1488: End insert_validate;
1489: --
1490: -- ----------------------------------------------------------------------------
1491: -- |---------------------------------< upd >----------------------------------|

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

1500: --
1501: l_proc varchar2(72) := g_package||'upd';
1502: --
1503: Begin
1504: hr_utility.set_location('Entering:'||l_proc, 5);
1505: --
1506: -- Determine if the business process is to be validated.
1507: --
1508: If p_validate then

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

1545: If p_validate then
1546: Raise HR_Api.Validate_Enabled;
1547: End If;
1548: --
1549: hr_utility.set_location(' Leaving:'||l_proc, 10);
1550: Exception
1551: When HR_Api.Validate_Enabled Then
1552: --
1553: -- As the Validate_Enabled exception has been raised

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

1582: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1583: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
1584: --
1585: Begin
1586: hr_utility.set_location('Entering:'||l_proc, 5);
1587: --
1588: -- Determine if the business process is to be validated.
1589: --
1590: If p_validate then

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

1638:
1639: Raise HR_Api.Validate_Enabled;
1640: End If;
1641: --
1642: hr_utility.set_location(' Leaving:'||l_proc, 10);
1643: Exception
1644: When HR_Api.Validate_Enabled Then
1645: --
1646:

Line 1650: hr_utility.set_location(' Calling Rollback now'||l_proc, 99);

1646:
1647: -- As the Validate_Enabled exception has been raised
1648: -- we must rollback to the savepoint
1649: --
1650: hr_utility.set_location(' Calling Rollback now'||l_proc, 99);
1651: ROLLBACK TO ins_pay_qpu;
1652: end ins;
1653: --
1654: -- ----------------------------------------------------------------------------

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

1668: l_proc varchar2(72) := g_package||'upd';
1669: --
1670: Begin
1671:
1672: hr_utility.set_location('Entering:'||l_proc, 5);
1673: --
1674: -- Call conversion function to turn arguments into the
1675: -- l_rec structure.
1676: --

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

1700: ,p_validate => p_validate
1701: );
1702: p_p_object_version_number := l_rec.object_version_number;
1703: --
1704: hr_utility.set_location(' Leaving:'||l_proc, 10);
1705: End upd;
1706: --
1707: -- ----------------------------------------------------------------------------
1708: -- |---------------------------------< ins >----------------------------------|

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

1729: l_proc varchar2(72) := g_package||'ins';
1730: --
1731:
1732: Begin
1733: hr_utility.set_location('Entering:'||l_proc, 5);
1734: --
1735: -- Call conversion function to turn arguments into the
1736: -- p_rec structure.
1737: --

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

1767: p_payroll_action_id := l_rec.payroll_action_id;
1768: p_action_status := l_rec.action_status;
1769: p_p_object_version_number := l_rec.object_version_number;
1770: --
1771: hr_utility.set_location(' Leaving:'||l_proc, 10);
1772: End ins;
1773: --
1774:
1775: --