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

Line 64: hr_utility.set_location('Entering:'|| v_proc, 5);

60: where pya.action_type = 'Q'
61: and pya.payroll_action_id = asa.payroll_action_id
62: and asa.assignment_action_id = p_assignment_action_id;
63: begin
64: hr_utility.set_location('Entering:'|| v_proc, 5);
65: --
66: -- Check mandatory parameters have been set
67: --
68: hr_api.mandatory_arg_error

Line 83: hr_utility.set_message(801, 'PAY_33738_QPAY_NO_ASG_ACT');

79: close sel_exists;
80: -- Error: You have tried to exclude an element entry in QuickPay for an
81: -- assignment process that does not exist. The p_rec.assignment_action_id
82: -- (or p_assignment_action_id) argument has been set to an incorrect value.
83: hr_utility.set_message(801, 'PAY_33738_QPAY_NO_ASG_ACT');
84: hr_utility.raise_error;
85: end if;
86: close sel_exists;
87: hr_utility.set_location(v_proc, 6);

Line 84: hr_utility.raise_error;

80: -- Error: You have tried to exclude an element entry in QuickPay for an
81: -- assignment process that does not exist. The p_rec.assignment_action_id
82: -- (or p_assignment_action_id) argument has been set to an incorrect value.
83: hr_utility.set_message(801, 'PAY_33738_QPAY_NO_ASG_ACT');
84: hr_utility.raise_error;
85: end if;
86: close sel_exists;
87: hr_utility.set_location(v_proc, 6);
88: --

Line 87: hr_utility.set_location(v_proc, 6);

83: hr_utility.set_message(801, 'PAY_33738_QPAY_NO_ASG_ACT');
84: hr_utility.raise_error;
85: end if;
86: close sel_exists;
87: hr_utility.set_location(v_proc, 6);
88: --
89: -- Check the assignment action is for a 'QuickPay Run' payroll action
90: --
91: Open sel_for_qpr;

Line 99: hr_utility.set_message(801, 'PAY_33696_QPAY_NOT_ACT_QP');

95: -- Error: You have tried to exclude an element entry in QuickPay for an
96: -- invalid type of payroll process. The payroll process corresponding to
97: -- the assignment process (p_rec.assignment_action_id) must be of the type
98: -- QuickPay Run.
99: hr_utility.set_message(801, 'PAY_33696_QPAY_NOT_ACT_QP');
100: hr_utility.raise_error;
101: end if;
102: close sel_for_qpr;
103: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 100: hr_utility.raise_error;

96: -- invalid type of payroll process. The payroll process corresponding to
97: -- the assignment process (p_rec.assignment_action_id) must be of the type
98: -- QuickPay Run.
99: hr_utility.set_message(801, 'PAY_33696_QPAY_NOT_ACT_QP');
100: hr_utility.raise_error;
101: end if;
102: close sel_for_qpr;
103: hr_utility.set_location(' Leaving:'|| v_proc, 10);
104: end validate_asg_act_id;

Line 103: hr_utility.set_location(' Leaving:'|| v_proc, 10);

99: hr_utility.set_message(801, 'PAY_33696_QPAY_NOT_ACT_QP');
100: hr_utility.raise_error;
101: end if;
102: close sel_for_qpr;
103: hr_utility.set_location(' Leaving:'|| v_proc, 10);
104: end validate_asg_act_id;
105: --
106: -- ----------------------------------------------------------------------------
107: -- |-------------------------< validate_ele_ent_id >--------------------------|

Line 216: hr_utility.set_location('Entering:'|| v_proc, 5);

212: and (asgt_act.assignment_action_id = p_assignment_action_id
213: or asgt_act.source_action_id = p_assignment_action_id);
214: --
215: begin
216: hr_utility.set_location('Entering:'|| v_proc, 5);
217: --
218: -- Check that the element entry exists with id p_element_entry_id
219: --
220: open cur_exists;

Line 227: hr_utility.set_message(801, 'PAY_34808_QPAY_NO_ELE_ENT');

223: close cur_exists;
224: -- Error: You have tried to exclude a non-existent element entry for
225: -- QuickPay. The p_rec.element_entry_id (or element_entry_id) argument has
226: -- been set to an incorrect value.
227: hr_utility.set_message(801, 'PAY_34808_QPAY_NO_ELE_ENT');
228: hr_utility.raise_error;
229: end if;
230: close cur_exists;
231: hr_utility.set_location(v_proc, 6);

Line 228: hr_utility.raise_error;

224: -- Error: You have tried to exclude a non-existent element entry for
225: -- QuickPay. The p_rec.element_entry_id (or element_entry_id) argument has
226: -- been set to an incorrect value.
227: hr_utility.set_message(801, 'PAY_34808_QPAY_NO_ELE_ENT');
228: hr_utility.raise_error;
229: end if;
230: close cur_exists;
231: hr_utility.set_location(v_proc, 6);
232: --

Line 231: hr_utility.set_location(v_proc, 6);

227: hr_utility.set_message(801, 'PAY_34808_QPAY_NO_ELE_ENT');
228: hr_utility.raise_error;
229: end if;
230: close cur_exists;
231: hr_utility.set_location(v_proc, 6);
232: --
233: -- Check the element entry exists as of the QuickPay Run
234: -- date_earned.
235: --

Line 243: hr_utility.set_message(801, 'PAY_34637_QPAY_NO_ELE_D_EARN');

239: close cur_date;
240: -- Error: You have tried to exclude an element entry for QuickPay that
241: -- does not exist at Date Earned. You can only exclude element entries
242: -- that are date effective at this date.
243: hr_utility.set_message(801, 'PAY_34637_QPAY_NO_ELE_D_EARN');
244: hr_utility.raise_error;
245: end if;
246: close cur_date;
247: hr_utility.set_location(v_proc, 7);

Line 244: hr_utility.raise_error;

240: -- Error: You have tried to exclude an element entry for QuickPay that
241: -- does not exist at Date Earned. You can only exclude element entries
242: -- that are date effective at this date.
243: hr_utility.set_message(801, 'PAY_34637_QPAY_NO_ELE_D_EARN');
244: hr_utility.raise_error;
245: end if;
246: close cur_date;
247: hr_utility.set_location(v_proc, 7);
248: --

Line 247: hr_utility.set_location(v_proc, 7);

243: hr_utility.set_message(801, 'PAY_34637_QPAY_NO_ELE_D_EARN');
244: hr_utility.raise_error;
245: end if;
246: close cur_date;
247: hr_utility.set_location(v_proc, 7);
248: --
249: -- Check element entry must be for the same
250: -- assignment as the assignment action
251: --

Line 258: hr_utility.set_message(801, 'PAY_34517_QPAY_ELE_NOT_ASG');

254: if cur_same%notfound then
255: close cur_same;
256: -- Error: You have tried to exclude an element entry for QuickPay that is
257: -- not for the same assignment as defined for the QuickPay run.
258: hr_utility.set_message(801, 'PAY_34517_QPAY_ELE_NOT_ASG');
259: hr_utility.raise_error;
260: end if;
261: close cur_same;
262: hr_utility.set_location(v_proc, 8);

Line 259: hr_utility.raise_error;

255: close cur_same;
256: -- Error: You have tried to exclude an element entry for QuickPay that is
257: -- not for the same assignment as defined for the QuickPay run.
258: hr_utility.set_message(801, 'PAY_34517_QPAY_ELE_NOT_ASG');
259: hr_utility.raise_error;
260: end if;
261: close cur_same;
262: hr_utility.set_location(v_proc, 8);
263: hr_utility.set_location(v_proc, 9);

Line 262: hr_utility.set_location(v_proc, 8);

258: hr_utility.set_message(801, 'PAY_34517_QPAY_ELE_NOT_ASG');
259: hr_utility.raise_error;
260: end if;
261: close cur_same;
262: hr_utility.set_location(v_proc, 8);
263: hr_utility.set_location(v_proc, 9);
264: hr_utility.set_location(v_proc, 10);
265: --
266: -- Do not allow an entry to be excluded from a QP if the QP has been

Line 263: hr_utility.set_location(v_proc, 9);

259: hr_utility.raise_error;
260: end if;
261: close cur_same;
262: hr_utility.set_location(v_proc, 8);
263: hr_utility.set_location(v_proc, 9);
264: hr_utility.set_location(v_proc, 10);
265: --
266: -- Do not allow an entry to be excluded from a QP if the QP has been
267: -- processed and a run result exists for that assignment action/element entry

Line 264: hr_utility.set_location(v_proc, 10);

260: end if;
261: close cur_same;
262: hr_utility.set_location(v_proc, 8);
263: hr_utility.set_location(v_proc, 9);
264: hr_utility.set_location(v_proc, 10);
265: --
266: -- Do not allow an entry to be excluded from a QP if the QP has been
267: -- processed and a run result exists for that assignment action/element entry
268: -- id

Line 278: hr_utility.set_message(801, 'PAY_33922_QPAY_EXCL_RR_EXISTS');

274: fetch cur_rr_exists into v_exists;
275: if cur_rr_exists%found then
276: -- A run result exists for this element entry/assignment action
277: -- Therefore, this element entry cannot be excluded for the QuickPay
278: hr_utility.set_message(801, 'PAY_33922_QPAY_EXCL_RR_EXISTS');
279: hr_utility.raise_error;
280: end if;
281: close cur_rr_exists;
282: --

Line 279: hr_utility.raise_error;

275: if cur_rr_exists%found then
276: -- A run result exists for this element entry/assignment action
277: -- Therefore, this element entry cannot be excluded for the QuickPay
278: hr_utility.set_message(801, 'PAY_33922_QPAY_EXCL_RR_EXISTS');
279: hr_utility.raise_error;
280: end if;
281: close cur_rr_exists;
282: --
283: hr_utility.set_location(' Leaving:'|| v_proc, 11);

Line 283: hr_utility.set_location(' Leaving:'|| v_proc, 11);

279: hr_utility.raise_error;
280: end if;
281: close cur_rr_exists;
282: --
283: hr_utility.set_location(' Leaving:'|| v_proc, 11);
284: --
285: end validate_ele_ent_id;
286: --
287: -- ----------------------------------------------------------------------------

Line 328: hr_utility.set_location('Entering:'|| v_proc, 5);

324: from pay_quickpay_exclusions
325: where element_entry_id = p_rec.element_entry_id
326: and assignment_action_id = p_rec.assignment_action_id;
327: begin
328: hr_utility.set_location('Entering:'|| v_proc, 5);
329: --
330: -- Check that quickpay exclusion does not exist.
331: --
332: open cur_exists;

Line 338: hr_utility.set_message(801, 'PAY_33373_QPAY_ELE_EXCLUDED');

334: if cur_exists%found then
335: close cur_exists;
336: -- Error: You have tried to exclude the same element entry more than once
337: -- from the QuickPay run.
338: hr_utility.set_message(801, 'PAY_33373_QPAY_ELE_EXCLUDED');
339: hr_utility.raise_error;
340: end if;
341: close cur_exists;
342: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 339: hr_utility.raise_error;

335: close cur_exists;
336: -- Error: You have tried to exclude the same element entry more than once
337: -- from the QuickPay run.
338: hr_utility.set_message(801, 'PAY_33373_QPAY_ELE_EXCLUDED');
339: hr_utility.raise_error;
340: end if;
341: close cur_exists;
342: hr_utility.set_location(' Leaving:'|| v_proc, 10);
343: end validate_row_exists;

Line 342: hr_utility.set_location(' Leaving:'|| v_proc, 10);

338: hr_utility.set_message(801, 'PAY_33373_QPAY_ELE_EXCLUDED');
339: hr_utility.raise_error;
340: end if;
341: close cur_exists;
342: hr_utility.set_location(' Leaving:'|| v_proc, 10);
343: end validate_row_exists;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |--------------------------< validate_act_cmp >----------------------------|

Line 399: hr_utility.set_location('Entering:'|| v_proc, 5);

395: where aga.assignment_action_id = p_assignment_action_id
396: and pya.payroll_action_id = aga.payroll_action_id
397: and pya.current_task is not null;
398: begin
399: hr_utility.set_location('Entering:'|| v_proc, 5);
400: --
401: -- Check that assignment_action does not have a status of Complete.
402: --
403: -- Enhancement 3368211

Line 413: hr_utility.set_message(801, 'HR_7239_QPAY_ELE_MARK');

409: close cur_aga_act;
410: -- Error: You have tried to include or exclude an element entry for a
411: -- QuickPay run that has completed successfully. To do this you must
412: -- change the assignment process status to Marked for Retry.
413: hr_utility.set_message(801, 'HR_7239_QPAY_ELE_MARK');
414: hr_utility.raise_error;
415: end if;
416: close cur_aga_act;
417: --

Line 414: hr_utility.raise_error;

410: -- Error: You have tried to include or exclude an element entry for a
411: -- QuickPay run that has completed successfully. To do this you must
412: -- change the assignment process status to Marked for Retry.
413: hr_utility.set_message(801, 'HR_7239_QPAY_ELE_MARK');
414: hr_utility.raise_error;
415: end if;
416: close cur_aga_act;
417: --
418: */

Line 419: hr_utility.set_location(v_proc, 6);

415: end if;
416: close cur_aga_act;
417: --
418: */
419: hr_utility.set_location(v_proc, 6);
420: --
421: -- Check that payroll_action does not have
422: -- current_task set to a not null value.
423: --

Line 430: hr_utility.set_message(801, 'HR_7240_QPAY_ELE_RUNNING');

426: if cur_pya_act%found then
427: close cur_pya_act;
428: -- Error: You have tried to include or exclude an element entry from a
429: -- QuickPay run while the run is processing.
430: hr_utility.set_message(801, 'HR_7240_QPAY_ELE_RUNNING');
431: hr_utility.raise_error;
432: end if;
433: close cur_pya_act;
434: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 431: hr_utility.raise_error;

427: close cur_pya_act;
428: -- Error: You have tried to include or exclude an element entry from a
429: -- QuickPay run while the run is processing.
430: hr_utility.set_message(801, 'HR_7240_QPAY_ELE_RUNNING');
431: hr_utility.raise_error;
432: end if;
433: close cur_pya_act;
434: hr_utility.set_location(' Leaving:'|| v_proc, 10);
435: end validate_act_cmp;

Line 434: hr_utility.set_location(' Leaving:'|| v_proc, 10);

430: hr_utility.set_message(801, 'HR_7240_QPAY_ELE_RUNNING');
431: hr_utility.raise_error;
432: end if;
433: close cur_pya_act;
434: hr_utility.set_location(' Leaving:'|| v_proc, 10);
435: end validate_act_cmp;
436: --
437: -- ----------------------------------------------------------------------------
438: -- |------------------------------< insert_dml >------------------------------|

Line 473: hr_utility.set_location('Entering:'||v_proc, 5);

469: --
470: v_proc varchar2(72) := g_package||'insert_dml';
471: --
472: begin
473: hr_utility.set_location('Entering:'||v_proc, 5);
474: --
475: -- Insert the row into: pay_quickpay_exclusions
476: --
477: insert into pay_quickpay_exclusions

Line 496: hr_utility.set_location(' Leaving:'||v_proc, 10);

492: ,fnd_global.user_id
493: ,fnd_global.login_id
494: );
495: --
496: hr_utility.set_location(' Leaving:'||v_proc, 10);
497: end insert_dml;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |------------------------------< delete_dml >------------------------------|

Line 535: hr_utility.set_location('Entering:'|| v_proc, 5);

531: --
532: v_proc varchar2(72) := g_package||'delete_dml';
533: --
534: Begin
535: hr_utility.set_location('Entering:'|| v_proc, 5);
536: --
537: -- Delete the pay_quickpay_exclusions row.
538: --
539: delete from pay_quickpay_exclusions

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

544: --
545: -- The row to be deleted was NOT found therefore a serious
546: -- error has occurred which MUST be reported.
547: --
548: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
549: hr_utility.set_message_token('PROCEDURE', v_proc);
550: hr_utility.set_message_token('STEP','5');
551: hr_utility.raise_error;
552: End If;

Line 549: hr_utility.set_message_token('PROCEDURE', v_proc);

545: -- The row to be deleted was NOT found therefore a serious
546: -- error has occurred which MUST be reported.
547: --
548: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
549: hr_utility.set_message_token('PROCEDURE', v_proc);
550: hr_utility.set_message_token('STEP','5');
551: hr_utility.raise_error;
552: End If;
553: --

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

546: -- error has occurred which MUST be reported.
547: --
548: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
549: hr_utility.set_message_token('PROCEDURE', v_proc);
550: hr_utility.set_message_token('STEP','5');
551: hr_utility.raise_error;
552: End If;
553: --
554: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 551: hr_utility.raise_error;

547: --
548: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
549: hr_utility.set_message_token('PROCEDURE', v_proc);
550: hr_utility.set_message_token('STEP','5');
551: hr_utility.raise_error;
552: End If;
553: --
554: hr_utility.set_location(' Leaving:'|| v_proc, 10);
555: End delete_dml;

Line 554: hr_utility.set_location(' Leaving:'|| v_proc, 10);

550: hr_utility.set_message_token('STEP','5');
551: hr_utility.raise_error;
552: End If;
553: --
554: hr_utility.set_location(' Leaving:'|| v_proc, 10);
555: End delete_dml;
556: --
557: -- ----------------------------------------------------------------------------
558: -- |---------------------------------< lck >----------------------------------|

Line 578: hr_utility.set_location('Entering:'|| v_proc, 5);

574: --
575: v_proc varchar2(72) := g_package||'lck';
576: --
577: Begin
578: hr_utility.set_location('Entering:'|| v_proc, 5);
579: --
580: -- The primary key exists therefore we must now attempt to lock the
581: -- row and check the object version numbers.
582: --

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

586: Close C_Sel1;
587: --
588: -- The primary key is invalid therefore we must error
589: --
590: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
591: hr_utility.raise_error;
592: End If;
593: Close C_Sel1;
594: --

Line 591: hr_utility.raise_error;

587: --
588: -- The primary key is invalid therefore we must error
589: --
590: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
591: hr_utility.raise_error;
592: End If;
593: Close C_Sel1;
594: --
595: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 595: hr_utility.set_location(' Leaving:'|| v_proc, 10);

591: hr_utility.raise_error;
592: End If;
593: Close C_Sel1;
594: --
595: hr_utility.set_location(' Leaving:'|| v_proc, 10);
596: --
597: -- We need to trap the ORA LOCK exception
598: --
599: Exception

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

601: --
602: -- The object is locked therefore we need to supply a meaningful
603: -- error message.
604: --
605: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
606: hr_utility.set_message_token('TABLE_NAME', 'PAY_QUICKPAY_EXCLUSIONS');
607: hr_utility.raise_error;
608: End lck;
609: --

Line 606: hr_utility.set_message_token('TABLE_NAME', 'PAY_QUICKPAY_EXCLUSIONS');

602: -- The object is locked therefore we need to supply a meaningful
603: -- error message.
604: --
605: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
606: hr_utility.set_message_token('TABLE_NAME', 'PAY_QUICKPAY_EXCLUSIONS');
607: hr_utility.raise_error;
608: End lck;
609: --
610: -- ----------------------------------------------------------------------------

Line 607: hr_utility.raise_error;

603: -- error message.
604: --
605: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
606: hr_utility.set_message_token('TABLE_NAME', 'PAY_QUICKPAY_EXCLUSIONS');
607: hr_utility.raise_error;
608: End lck;
609: --
610: -- ----------------------------------------------------------------------------
611: -- |-----------------------------< convert_args >-----------------------------|

Line 654: hr_utility.set_location('Entering:'|| v_proc, 5);

650: v_proc varchar2(72) := g_package||'convert_args';
651: --
652: Begin
653: --
654: hr_utility.set_location('Entering:'|| v_proc, 5);
655: --
656: -- Convert arguments into local l_rec structure.
657: --
658: v_rec.element_entry_id := p_element_entry_id;

Line 663: hr_utility.set_location(' Leaving:'|| v_proc, 10);

659: v_rec.assignment_action_id := p_assignment_action_id;
660: --
661: -- Return the plsql record structure.
662: --
663: hr_utility.set_location(' Leaving:'|| v_proc, 10);
664: Return(v_rec);
665: --
666: End convert_args;
667: --

Line 700: hr_utility.set_location('Entering:'|| v_proc, 5);

696: --
697: v_proc varchar2(72) := g_package||'insert_validate';
698: --
699: begin
700: hr_utility.set_location('Entering:'|| v_proc, 5);
701: --
702: -- Call all supporting business operations
703: --
704: -- Validate that the assignment action actually exists and it

Line 708: hr_utility.set_location(v_proc, 6);

704: -- Validate that the assignment action actually exists and it
705: -- is for a 'QuickPay Run' Payroll Process.
706: --
707: validate_asg_act_id(p_assignment_action_id => p_rec.assignment_action_id);
708: hr_utility.set_location(v_proc, 6);
709: --
710: -- Validate that corresponding assignment action's Payroll Process is not
711: -- being processed.
712: --

Line 714: hr_utility.set_location(v_proc, 7);

710: -- Validate that corresponding assignment action's Payroll Process is not
711: -- being processed.
712: --
713: validate_act_cmp(p_assignment_action_id => p_rec.assignment_action_id);
714: hr_utility.set_location(v_proc, 7);
715: --
716: -- Validate the element entry.
717: --
718: validate_ele_ent_id(p_rec => p_rec);

Line 719: hr_utility.set_location(v_proc, 8);

715: --
716: -- Validate the element entry.
717: --
718: validate_ele_ent_id(p_rec => p_rec);
719: hr_utility.set_location(v_proc, 8);
720: --
721: -- Validate that this quickpay exclusion does not already exist.
722: --
723: validate_row_exists(p_rec => p_rec);

Line 724: hr_utility.set_location(v_proc, 9);

720: --
721: -- Validate that this quickpay exclusion does not already exist.
722: --
723: validate_row_exists(p_rec => p_rec);
724: hr_utility.set_location(v_proc, 9);
725: --
726: hr_utility.set_location(' Leaving:'|| v_proc, 10);
727: end insert_validate;
728: --

Line 726: hr_utility.set_location(' Leaving:'|| v_proc, 10);

722: --
723: validate_row_exists(p_rec => p_rec);
724: hr_utility.set_location(v_proc, 9);
725: --
726: hr_utility.set_location(' Leaving:'|| v_proc, 10);
727: end insert_validate;
728: --
729: -- ----------------------------------------------------------------------------
730: -- |---------------------------< delete_validate >----------------------------|

Line 761: hr_utility.set_location('Entering:'|| v_proc, 5);

757: --
758: v_proc varchar2(72) := g_package||'delete_validate';
759: --
760: begin
761: hr_utility.set_location('Entering:'|| v_proc, 5);
762: --
763: -- Validate that the corresponding assignment action's payroll action does
764: -- not have a status of Processing.
765: --

Line 768: hr_utility.set_location(' Leaving:'|| v_proc, 10);

764: -- not have a status of Processing.
765: --
766: validate_act_cmp(p_assignment_action_id => p_rec.assignment_action_id);
767: --
768: hr_utility.set_location(' Leaving:'|| v_proc, 10);
769: end delete_validate;
770: --
771: -- ----------------------------------------------------------------------------
772: -- |---------------------------------< ins >----------------------------------|

Line 784: hr_utility.set_location('Entering:'|| v_proc, 5);

780: --
781: v_proc varchar2(72) := g_package||'ins';
782: --
783: Begin
784: hr_utility.set_location('Entering:'|| v_proc, 5);
785: --
786: -- Determine if the business process is to be validated.
787: --
788: If p_validate then

Line 809: hr_utility.set_location(' Leaving:'||v_proc, 10);

805: if p_validate then
806: raise hr_api.validate_enabled;
807: end if;
808: --
809: hr_utility.set_location(' Leaving:'||v_proc, 10);
810: exception
811: when hr_api.validate_enabled then
812: --
813: -- As the Validate_Enabled exception has been raised

Line 833: hr_utility.set_location('Entering:'|| v_proc, 5);

829: v_rec pay_quickpay_exclusions%ROWTYPE;
830: v_proc varchar2(72) := g_package||'ins';
831: --
832: Begin
833: hr_utility.set_location('Entering:'|| v_proc, 5);
834: --
835: -- Call conversion function to turn arguments into the
836: -- pl/sql record structure.
837: --

Line 849: hr_utility.set_location(' Leaving:'|| v_proc, 10);

845: -- call the entity version of ins.
846: --
847: ins(v_rec, p_validate);
848: --
849: hr_utility.set_location(' Leaving:'|| v_proc, 10);
850: End ins;
851: --
852: -- ----------------------------------------------------------------------------
853: -- |---------------------------------< del >----------------------------------|

Line 864: hr_utility.set_location('Entering:'|| v_proc, 5);

860: --
861: v_proc varchar2(30) := g_package||'del';
862: --
863: Begin
864: hr_utility.set_location('Entering:'|| v_proc, 5);
865: --
866: -- We are deleting using the primary key therefore
867: -- we must ensure that the argument value is NOT null.
868: --

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

868: --
869: if (p_rec.element_entry_id is null or
870: p_rec.assignment_action_id is null
871: ) then
872: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
873: hr_utility.set_message_token('PROCEDURE', v_proc);
874: hr_utility.set_message_token('STEP','5');
875: hr_utility.raise_error;
876: else

Line 873: hr_utility.set_message_token('PROCEDURE', v_proc);

869: if (p_rec.element_entry_id is null or
870: p_rec.assignment_action_id is null
871: ) then
872: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
873: hr_utility.set_message_token('PROCEDURE', v_proc);
874: hr_utility.set_message_token('STEP','5');
875: hr_utility.raise_error;
876: else
877: --

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

870: p_rec.assignment_action_id is null
871: ) then
872: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
873: hr_utility.set_message_token('PROCEDURE', v_proc);
874: hr_utility.set_message_token('STEP','5');
875: hr_utility.raise_error;
876: else
877: --
878: -- Determine if the business process is to be validated.

Line 875: hr_utility.raise_error;

871: ) then
872: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
873: hr_utility.set_message_token('PROCEDURE', v_proc);
874: hr_utility.set_message_token('STEP','5');
875: hr_utility.raise_error;
876: else
877: --
878: -- Determine if the business process is to be validated.
879: --

Line 910: hr_utility.set_location(' Leaving:'||v_proc, 10);

906: raise hr_api.validate_enabled;
907: end if;
908: end if;
909: --
910: hr_utility.set_location(' Leaving:'||v_proc, 10);
911: exception
912: when hr_api.validate_enabled Then
913: --
914: -- As the Validate_Enabled exception has been raised

Line 934: hr_utility.set_location('Entering:'|| v_proc, 5);

930: v_rec pay_quickpay_exclusions%ROWTYPE;
931: v_proc varchar2(72) := g_package||'del';
932: --
933: begin
934: hr_utility.set_location('Entering:'|| v_proc, 5);
935: --
936: -- As the delete procedure accepts a plsql record structure we do need to
937: -- convert the arguments into the record structure.
938: -- We don't need to call the supplied conversion argument routine as we

Line 949: hr_utility.set_location(' Leaving:'|| v_proc, 10);

945: -- structure we must call the entity version of del.
946: --
947: del(v_rec, p_validate);
948: --
949: hr_utility.set_location(' Leaving:'|| v_proc, 10);
950: end del;
951: --
952: end pay_qpe_api;