APPS.PER_PPC_BUS dependencies on HR_UTILITY

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

43: l_error exception;
44: l_argument varchar2(30);
45: --
46: Begin
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: -- Only proceed with validation if a row exists for
50: -- the current record in the HR Schema
51: --

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

52: if not per_ppc_shd.api_updating
53: (p_component_id => p_rec.component_id
54: ,p_object_version_number => p_rec.object_version_number
55: ) then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '5');
59: end if;
60: hr_utility.set_location(l_proc, 6);

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

53: (p_component_id => p_rec.component_id
54: ,p_object_version_number => p_rec.object_version_number
55: ) then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '5');
59: end if;
60: hr_utility.set_location(l_proc, 6);
61: --

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

54: ,p_object_version_number => p_rec.object_version_number
55: ) then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '5');
59: end if;
60: hr_utility.set_location(l_proc, 6);
61: --
62: if p_rec.business_group_id <> per_ppc_shd.g_old_rec.business_group_id

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

56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP', '5');
59: end if;
60: hr_utility.set_location(l_proc, 6);
61: --
62: if p_rec.business_group_id <> per_ppc_shd.g_old_rec.business_group_id
63: then
64: l_argument := 'business_group_id';

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

63: then
64: l_argument := 'business_group_id';
65: raise l_error;
66: end if;
67: hr_utility.set_location(l_proc, 7);
68: --
69: if p_rec.pay_proposal_id <> per_ppc_shd.g_old_rec.pay_proposal_id then
70: l_argument := 'pay_proposal_id';
71: raise l_error;

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

69: if p_rec.pay_proposal_id <> per_ppc_shd.g_old_rec.pay_proposal_id then
70: l_argument := 'pay_proposal_id';
71: raise l_error;
72: end if;
73: hr_utility.set_location(l_proc, 8);
74: --
75: if p_rec.component_id <> per_ppc_shd.g_old_rec.component_id then
76: l_argument := 'component_id';
77: raise l_error;

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

75: if p_rec.component_id <> per_ppc_shd.g_old_rec.component_id then
76: l_argument := 'component_id';
77: raise l_error;
78: end if;
79: hr_utility.set_location(l_proc, 9);
80: --
81: exception
82: when l_error then
83: hr_api.argument_changed_error

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

84: (p_api_name => l_proc
85: ,p_argument => l_argument);
86: when others then
87: raise;
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: end check_non_updateable_args;
90: --
91: --
92: -- ----------------------------------------------------------------

Line 135: hr_utility.set_location('Entering:'|| l_proc, 10);

131: and pyp.assignment_id = asg.assignment_id
132: and pyp.change_date between asg.effective_start_date
133: and asg.effective_end_date;
134: begin
135: hr_utility.set_location('Entering:'|| l_proc, 10);
136: --
137: -- Always perform this validation on update and delete
138: -- even although the assignment_id value cannot be changed.
139: --

Line 148: hr_utility.set_location(' Leaving:'|| l_proc, 30);

144: fnd_message.set_name('PER', 'PER_SAL_ASG_NOT_EXIST');
145: fnd_message.raise_error;
146: end if;
147: close csr_asg_sec;
148: hr_utility.set_location(' Leaving:'|| l_proc, 30);
149: end chk_access;
150:
151: --
152: --

Line 223: hr_utility.set_location('Entering:'|| l_proc, 1);

219: where pro.pay_proposal_id = p_pay_proposal_id;
220: --
221: --
222: begin
223: hr_utility.set_location('Entering:'|| l_proc, 1);
224: --
225: -- Check mandatory parameters have been set
226: --
227: hr_api.mandatory_arg_error

Line 243: hr_utility.set_location(l_proc, 2);

239: -- This following checks is done regardless of insert
240: -- or update mode due to master-detail relationship
241: -- between proposal and component .
242: --
243: hr_utility.set_location(l_proc, 2);
244: --
245: -- Check the pay_proposal_id and the value of the approved and
246: -- multiple_components flag.
247: --

Line 253: hr_utility.set_location(l_proc, 3);

249: fetch csr_pay_proposal_details into l_approved,
250: l_multiple_components,l_business_group_id;
251: if csr_pay_proposal_details%notfound then
252: close csr_pay_proposal_details;
253: hr_utility.set_location(l_proc, 3);
254: per_ppc_shd.constraint_error('PER_PAY_PROPOSAL_COMPONENT_FK1');
255: elsif
256: l_business_group_id <> p_business_group_id then
257: --

Line 261: hr_utility.set_location(l_proc, 4);

257: --
258: -- The component exists for a proposal in diferent Business Group.
259: --
260: close csr_pay_proposal_details;
261: hr_utility.set_location(l_proc, 4);
262: per_ppc_shd.constraint_error('PER_PAY_PROPOSAL_COMPONENT_FK2');
263: else
264: close csr_pay_proposal_details;
265: /*

Line 267: hr_utility.set_location(l_proc, 5);

263: else
264: close csr_pay_proposal_details;
265: /*
266: if l_approved = 'Y' and p_validation_strength <>'WEAK' then
267: hr_utility.set_location(l_proc, 5);
268: hr_utility.set_message (801,'HR_51311_PPC_CANT_INS_OR_UPD');
269: hr_utility.raise_error;
270: --
271: els */ -- allow component update.

Line 268: hr_utility.set_message (801,'HR_51311_PPC_CANT_INS_OR_UPD');

264: close csr_pay_proposal_details;
265: /*
266: if l_approved = 'Y' and p_validation_strength <>'WEAK' then
267: hr_utility.set_location(l_proc, 5);
268: hr_utility.set_message (801,'HR_51311_PPC_CANT_INS_OR_UPD');
269: hr_utility.raise_error;
270: --
271: els */ -- allow component update.
272: if l_multiple_components = 'N' and p_validation_strength <>'WEAK' then

Line 269: hr_utility.raise_error;

265: /*
266: if l_approved = 'Y' and p_validation_strength <>'WEAK' then
267: hr_utility.set_location(l_proc, 5);
268: hr_utility.set_message (801,'HR_51311_PPC_CANT_INS_OR_UPD');
269: hr_utility.raise_error;
270: --
271: els */ -- allow component update.
272: if l_multiple_components = 'N' and p_validation_strength <>'WEAK' then
273: hr_utility.set_location(l_proc, 6);

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

269: hr_utility.raise_error;
270: --
271: els */ -- allow component update.
272: if l_multiple_components = 'N' and p_validation_strength <>'WEAK' then
273: hr_utility.set_location(l_proc, 6);
274: hr_utility.set_message (801,'HR_51312_PPC_COMP_NOT_ALLOWED');
275: hr_utility.raise_error;
276: end if;
277: --

Line 274: hr_utility.set_message (801,'HR_51312_PPC_COMP_NOT_ALLOWED');

270: --
271: els */ -- allow component update.
272: if l_multiple_components = 'N' and p_validation_strength <>'WEAK' then
273: hr_utility.set_location(l_proc, 6);
274: hr_utility.set_message (801,'HR_51312_PPC_COMP_NOT_ALLOWED');
275: hr_utility.raise_error;
276: end if;
277: --
278: end if;

Line 275: hr_utility.raise_error;

271: els */ -- allow component update.
272: if l_multiple_components = 'N' and p_validation_strength <>'WEAK' then
273: hr_utility.set_location(l_proc, 6);
274: hr_utility.set_message (801,'HR_51312_PPC_COMP_NOT_ALLOWED');
275: hr_utility.raise_error;
276: end if;
277: --
278: end if;
279: --

Line 280: hr_utility.set_location('Leaving: ' || l_proc, 7);

276: end if;
277: --
278: end if;
279: --
280: hr_utility.set_location('Leaving: ' || l_proc, 7);
281: end chk_pay_proposal_id;
282: --
283: --
284: ----------------------------------------------------------------------

Line 339: hr_utility.set_location('Entering:'|| l_proc, 1);

335: l_api_updating boolean;
336: --
337: --
338: begin
339: hr_utility.set_location('Entering:'|| l_proc, 1);
340: --
341: hr_api.mandatory_arg_error
342: (p_api_name => l_proc
343: ,p_argument => 'approved'

Line 369: hr_utility.set_location(l_proc, 2);

365: --
366: -- check that the value of the approved is either 'Y' or 'N'
367: --
368: if (p_approved <> 'Y' AND p_approved <> 'N') then
369: hr_utility.set_location(l_proc, 2);
370: per_ppc_shd.constraint_error ('PER_PPC_APPROVED_CHK');
371: end if;
372: --
373: -- Check that a component cannot be approved if the

Line 378: hr_utility.set_location(l_proc,3);

374: -- change_amount_n or component_reason is null
375: -- CHANGED to allow change percentage to be null. This would be
376: -- the case if the previously approved salary was 0.00.
377: --
378: hr_utility.set_location(l_proc,3);
379: if (p_approved = 'Y') then
380: if (p_change_amount_n IS NULL)
381: then
382: hr_utility.set_location(l_proc, 4);

Line 382: hr_utility.set_location(l_proc, 4);

378: hr_utility.set_location(l_proc,3);
379: if (p_approved = 'Y') then
380: if (p_change_amount_n IS NULL)
381: then
382: hr_utility.set_location(l_proc, 4);
383: hr_utility.set_message(801,'HR_51269_PYP_CANT_APPR_SAL');
384: hr_utility.raise_error;
385: end if;
386: --

Line 383: hr_utility.set_message(801,'HR_51269_PYP_CANT_APPR_SAL');

379: if (p_approved = 'Y') then
380: if (p_change_amount_n IS NULL)
381: then
382: hr_utility.set_location(l_proc, 4);
383: hr_utility.set_message(801,'HR_51269_PYP_CANT_APPR_SAL');
384: hr_utility.raise_error;
385: end if;
386: --
387: if (p_component_reason IS NULL) then

Line 384: hr_utility.raise_error;

380: if (p_change_amount_n IS NULL)
381: then
382: hr_utility.set_location(l_proc, 4);
383: hr_utility.set_message(801,'HR_51269_PYP_CANT_APPR_SAL');
384: hr_utility.raise_error;
385: end if;
386: --
387: if (p_component_reason IS NULL) then
388: hr_utility.set_location(l_proc, 5);

Line 388: hr_utility.set_location(l_proc, 5);

384: hr_utility.raise_error;
385: end if;
386: --
387: if (p_component_reason IS NULL) then
388: hr_utility.set_location(l_proc, 5);
389: hr_utility.set_message (801, 'HR_51318_PPC_CANT_APP_COMP');
390: hr_utility.raise_error;
391: end if;
392: end if;

Line 389: hr_utility.set_message (801, 'HR_51318_PPC_CANT_APP_COMP');

385: end if;
386: --
387: if (p_component_reason IS NULL) then
388: hr_utility.set_location(l_proc, 5);
389: hr_utility.set_message (801, 'HR_51318_PPC_CANT_APP_COMP');
390: hr_utility.raise_error;
391: end if;
392: end if;
393: --

Line 390: hr_utility.raise_error;

386: --
387: if (p_component_reason IS NULL) then
388: hr_utility.set_location(l_proc, 5);
389: hr_utility.set_message (801, 'HR_51318_PPC_CANT_APP_COMP');
390: hr_utility.raise_error;
391: end if;
392: end if;
393: --
394: end if;

Line 396: hr_utility.set_location('Leaving: ' || l_proc, 4);

392: end if;
393: --
394: end if;
395: --
396: hr_utility.set_location('Leaving: ' || l_proc, 4);
397: --
398: end chk_approved;
399: --
400: --

Line 472: hr_utility.set_location('Entering:'|| l_proc, 1);

468: from per_pay_proposals
469: where pay_proposal_id = p_pay_proposal_id;
470: --
471: begin
472: hr_utility.set_location('Entering:'|| l_proc, 1);
473: open csr_get_date;
474: fetch csr_get_date into l_change_date, l_sal_pro_approved;
475: if csr_get_date%notfound then
476: close csr_get_date;

Line 477: hr_utility.set_message(801,'HR_51310_PPC_INVAL_PRO_ID');

473: open csr_get_date;
474: fetch csr_get_date into l_change_date, l_sal_pro_approved;
475: if csr_get_date%notfound then
476: close csr_get_date;
477: hr_utility.set_message(801,'HR_51310_PPC_INVAL_PRO_ID');
478: hr_utility.raise_error;
479: end if;
480: close csr_get_date;
481: --

Line 478: hr_utility.raise_error;

474: fetch csr_get_date into l_change_date, l_sal_pro_approved;
475: if csr_get_date%notfound then
476: close csr_get_date;
477: hr_utility.set_message(801,'HR_51310_PPC_INVAL_PRO_ID');
478: hr_utility.raise_error;
479: end if;
480: close csr_get_date;
481: --
482: -- Check mandatory parameters have been set

Line 518: -- hr_utility.set_location(l_proc, 2);

514: -- the component is already approved.
515: --
516: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
517: -- per_ppc_shd.g_old_rec.component_reason <> p_component_reason) then
518: -- hr_utility.set_location(l_proc, 2);
519: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
520: -- hr_utility.raise_error;
521: -- end if;
522: -- end if;

Line 519: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');

515: --
516: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
517: -- per_ppc_shd.g_old_rec.component_reason <> p_component_reason) then
518: -- hr_utility.set_location(l_proc, 2);
519: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
520: -- hr_utility.raise_error;
521: -- end if;
522: -- end if;
523: --

Line 520: -- hr_utility.raise_error;

516: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
517: -- per_ppc_shd.g_old_rec.component_reason <> p_component_reason) then
518: -- hr_utility.set_location(l_proc, 2);
519: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
520: -- hr_utility.raise_error;
521: -- end if;
522: -- end if;
523: --
524: -- Check if sal proposal is approved

Line 528: hr_utility.set_location(l_proc, 2);

524: -- Check if sal proposal is approved
525: -- then component should be approved.
526: --
527: if ( l_sal_pro_approved = 'Y' AND p_approved <>'Y' ) then
528: hr_utility.set_location(l_proc, 2);
529: hr_utility.set_message(800,'PER_SAL_APRVD_COMP_NOT_APRVD');
530: hr_utility.raise_error;
531: end if;
532: --

Line 529: hr_utility.set_message(800,'PER_SAL_APRVD_COMP_NOT_APRVD');

525: -- then component should be approved.
526: --
527: if ( l_sal_pro_approved = 'Y' AND p_approved <>'Y' ) then
528: hr_utility.set_location(l_proc, 2);
529: hr_utility.set_message(800,'PER_SAL_APRVD_COMP_NOT_APRVD');
530: hr_utility.raise_error;
531: end if;
532: --
533: if (l_api_updating AND

Line 530: hr_utility.raise_error;

526: --
527: if ( l_sal_pro_approved = 'Y' AND p_approved <>'Y' ) then
528: hr_utility.set_location(l_proc, 2);
529: hr_utility.set_message(800,'PER_SAL_APRVD_COMP_NOT_APRVD');
530: hr_utility.raise_error;
531: end if;
532: --
533: if (l_api_updating AND
534: (per_ppc_shd.g_old_rec.component_reason <> p_component_reason)

Line 542: -- hr_utility.set_location(l_proc, 2);

538: -- the component is already approved.
539: --
540: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y'
541: -- AND l_api_updating) then
542: -- hr_utility.set_location(l_proc, 2);
543: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
544: -- hr_utility.raise_error;
545: -- end if;
546: --

Line 543: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');

539: --
540: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y'
541: -- AND l_api_updating) then
542: -- hr_utility.set_location(l_proc, 2);
543: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
544: -- hr_utility.raise_error;
545: -- end if;
546: --
547: -- check that the p_component_reason exists in hr_lookups.

Line 544: -- hr_utility.raise_error;

540: -- if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y'
541: -- AND l_api_updating) then
542: -- hr_utility.set_location(l_proc, 2);
543: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
544: -- hr_utility.raise_error;
545: -- end if;
546: --
547: -- check that the p_component_reason exists in hr_lookups.
548: --

Line 555: hr_utility.set_location(l_proc, 10);

551: ,p_lookup_type => 'PROPOSAL_REASON'
552: ,p_lookup_code => p_component_reason
553: ) then
554: -- Error: Invalid proposal_reason
555: hr_utility.set_location(l_proc, 10);
556: hr_utility.set_message(801,'HR_51265_INVAL_PRO_REASON');
557: hr_utility.raise_error;
558: end if;
559: --

Line 556: hr_utility.set_message(801,'HR_51265_INVAL_PRO_REASON');

552: ,p_lookup_code => p_component_reason
553: ) then
554: -- Error: Invalid proposal_reason
555: hr_utility.set_location(l_proc, 10);
556: hr_utility.set_message(801,'HR_51265_INVAL_PRO_REASON');
557: hr_utility.raise_error;
558: end if;
559: --
560: -- Check whether the component reason is unique.

Line 557: hr_utility.raise_error;

553: ) then
554: -- Error: Invalid proposal_reason
555: hr_utility.set_location(l_proc, 10);
556: hr_utility.set_message(801,'HR_51265_INVAL_PRO_REASON');
557: hr_utility.raise_error;
558: end if;
559: --
560: -- Check whether the component reason is unique.
561: --

Line 565: hr_utility.set_location(l_proc, 5);

561: --
562: open csr_unique_comp_reason;
563: fetch csr_unique_comp_reason into l_exists;
564: if csr_unique_comp_reason%notfound then
565: hr_utility.set_location(l_proc, 5);
566: close csr_unique_comp_reason;
567: else
568: hr_utility.set_location(l_proc, 6);
569: close csr_unique_comp_reason;

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

564: if csr_unique_comp_reason%notfound then
565: hr_utility.set_location(l_proc, 5);
566: close csr_unique_comp_reason;
567: else
568: hr_utility.set_location(l_proc, 6);
569: close csr_unique_comp_reason;
570: per_ppc_shd.constraint_error ('PER_PAY_PROPOSAL_COMPONENT_UK2');
571: end if;
572: end if;

Line 574: hr_utility.set_location('Leaving: ' || l_proc, 7);

570: per_ppc_shd.constraint_error ('PER_PAY_PROPOSAL_COMPONENT_UK2');
571: end if;
572: end if;
573: --
574: hr_utility.set_location('Leaving: ' || l_proc, 7);
575: --
576: end chk_component_reason;
577: --
578: --

Line 720: hr_utility.set_location('Entering:'|| l_proc, 1);

716: l_currency_rate number := 1;
717: l_annual_rate number := 1;
718: --
719: begin
720: hr_utility.set_location('Entering:'|| l_proc, 1);
721: --
722: -- Check for mandatory arguments
723: --
724: hr_api.mandatory_arg_error

Line 755: hr_utility.set_location(l_proc, 1);

751: if (per_ppc_shd.g_old_rec.approved = 'Y' AND p_approved = 'Y' AND
752: (per_ppc_shd.g_old_rec.change_amount_n <> p_change_amount_n OR
753: per_ppc_shd.g_old_rec.change_percentage <> p_change_percentage))
754: then
755: hr_utility.set_location(l_proc, 1);
756: -- allow Component update.
757: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
758: -- hr_utility.raise_error;
759: end if;

Line 757: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');

753: per_ppc_shd.g_old_rec.change_percentage <> p_change_percentage))
754: then
755: hr_utility.set_location(l_proc, 1);
756: -- allow Component update.
757: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
758: -- hr_utility.raise_error;
759: end if;
760: --
761: -- Check to see which of the two attribue has been updated.

Line 758: -- hr_utility.raise_error;

754: then
755: hr_utility.set_location(l_proc, 1);
756: -- allow Component update.
757: -- hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
758: -- hr_utility.raise_error;
759: end if;
760: --
761: -- Check to see which of the two attribue has been updated.
762: --

Line 781: hr_utility.set_location(l_proc, 2);

777: -- Don't do anything if both are null.
778: --
779: if ( p_change_amount_n IS NULL AND p_change_percentage IS NULL)
780: then
781: hr_utility.set_location(l_proc, 2);
782: else
783: open csr_dates(p_pay_proposal_id);
784: fetch csr_dates into l_assignment_id, l_business_group_id,
785: l_change_date, l_prev_date;

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

851: -- set output parameters
852: --
853: p_change_amount_n := l_change_amount_n;
854: p_change_percentage := l_change_percentage;
855: hr_utility.set_location('Leaving: '|| l_proc, 10);
856: --
857: end chk_change_amount_percentage;
858: --
859: --

Line 909: hr_utility.set_location('Entering:'|| l_proc, 1);

905: where comp.component_id = p_component_id;
906: --
907: --
908: begin
909: hr_utility.set_location('Entering:'|| l_proc, 1);
910: --
911: -- Check mandatory parameters have been set
912: --
913: hr_api.mandatory_arg_error

Line 925: hr_utility.set_location(l_proc, 2);

921: open csr_comp_exists;
922: fetch csr_comp_exists into l_pay_proposal_id;
923: if csr_comp_exists%notfound then
924: close csr_comp_exists;
925: hr_utility.set_location(l_proc, 2);
926: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
927: hr_utility.raise_error;
928: end if;
929: close csr_comp_exists;

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

922: fetch csr_comp_exists into l_pay_proposal_id;
923: if csr_comp_exists%notfound then
924: close csr_comp_exists;
925: hr_utility.set_location(l_proc, 2);
926: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
927: hr_utility.raise_error;
928: end if;
929: close csr_comp_exists;
930: --

Line 927: hr_utility.raise_error;

923: if csr_comp_exists%notfound then
924: close csr_comp_exists;
925: hr_utility.set_location(l_proc, 2);
926: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
927: hr_utility.raise_error;
928: end if;
929: close csr_comp_exists;
930: --
931: -- Check that the proposal is not already approved.

Line 936: hr_utility.set_location(l_proc, 2);

932: --
933: open csr_proposal_status;
934: fetch csr_proposal_status into l_exists;
935: if csr_proposal_status%notfound then
936: hr_utility.set_location(l_proc, 2);
937: close csr_proposal_status;
938: else
939: hr_utility.set_location(l_proc, 3);
940: close csr_proposal_status;

Line 939: hr_utility.set_location(l_proc, 3);

935: if csr_proposal_status%notfound then
936: hr_utility.set_location(l_proc, 2);
937: close csr_proposal_status;
938: else
939: hr_utility.set_location(l_proc, 3);
940: close csr_proposal_status;
941: -- hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
942: -- hr_utility.raise_error;
943: end if;

Line 941: -- hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');

937: close csr_proposal_status;
938: else
939: hr_utility.set_location(l_proc, 3);
940: close csr_proposal_status;
941: -- hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
942: -- hr_utility.raise_error;
943: end if;
944: --
945: hr_utility.set_location ('Leaving: ' || l_proc, 4);

Line 942: -- hr_utility.raise_error;

938: else
939: hr_utility.set_location(l_proc, 3);
940: close csr_proposal_status;
941: -- hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
942: -- hr_utility.raise_error;
943: end if;
944: --
945: hr_utility.set_location ('Leaving: ' || l_proc, 4);
946: --

Line 945: hr_utility.set_location ('Leaving: ' || l_proc, 4);

941: -- hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
942: -- hr_utility.raise_error;
943: end if;
944: --
945: hr_utility.set_location ('Leaving: ' || l_proc, 4);
946: --
947: end chk_delete_component;
948: --
949: -- -----------------------------------------------------------------------

Line 982: hr_utility.set_location('Entering:'||l_proc, 10);

978: --
979: l_proc varchar2(72) := g_package||'chk_df';
980: --
981: begin
982: hr_utility.set_location('Entering:'||l_proc, 10);
983: --
984: if ((p_rec.component_id is not null) and (
985: nvl(per_ppc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
986: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 1082: hr_utility.set_location(' Leaving:'||l_proc, 20);

1078: ,p_attribute20_value => p_rec.attribute20
1079: );
1080: end if;
1081: --
1082: hr_utility.set_location(' Leaving:'||l_proc, 20);
1083: end chk_df;
1084: --
1085: -- ------------------------------------------------------------------
1086: -- |------------------< insert_validate >----------------------------|

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

1090: --
1091: l_proc varchar2(72) := g_package||'insert_validate';
1092: --
1093: Begin
1094: hr_utility.set_location('Entering:'||l_proc, 5);
1095: --
1096: -- Call all supporting business operations. Mapping to the
1097: -- appropriate Business Rules in perpyp.bru is provided (where
1098: -- relevant)

Line 1109: hr_utility.set_location(l_proc, 10);

1105: -- Rule CHK_BUSINESS_GROUP_ID a,c
1106: --
1107: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1108: --
1109: hr_utility.set_location(l_proc, 10);
1110: --
1111: -- Validate pay_proposal_id
1112: --
1113: -- Business Rule Mapping

Line 1128: hr_utility.set_location(l_proc, 15);

1124: --
1125: -- call to chk_access added for fixing bug#3839734
1126: per_ppc_bus.chk_access(p_pay_proposal_id => p_rec.pay_proposal_id);
1127: --
1128: hr_utility.set_location(l_proc, 15);
1129: --
1130: -- Business Rule Mapping
1131: -- =====================
1132: -- Rule CHK_COMPONENT_REASON /a,b,c

Line 1142: hr_utility.set_location(l_proc, 20);

1138: ,p_approved => p_rec.approved
1139: ,p_object_version_number => p_rec.object_version_number
1140: );
1141: --
1142: hr_utility.set_location(l_proc, 20);
1143: --
1144: --
1145: -- Business Rule Mapping
1146: -- =====================

Line 1160: hr_utility.set_location(l_proc, 25);

1156: ,p_approved => p_rec.approved
1157: ,p_object_version_number => p_rec.object_version_number
1158: );
1159: --
1160: hr_utility.set_location(l_proc, 25);
1161: --
1162: --
1163: -- Business Rule Mapping
1164: -- =====================

Line 1176: hr_utility.set_location(l_proc, 30);

1172: ,p_change_percentage => p_rec.change_percentage
1173: ,p_object_version_number => p_rec.object_version_number
1174: );
1175: --
1176: hr_utility.set_location(l_proc, 30);
1177: --
1178: --
1179: -- Call descriptive flexfield validation routines
1180: --

Line 1183: hr_utility.set_location(' Leaving:'||l_proc, 35);

1179: -- Call descriptive flexfield validation routines
1180: --
1181: per_ppc_bus.chk_df(p_rec => p_rec);
1182: --
1183: hr_utility.set_location(' Leaving:'||l_proc, 35);
1184: End insert_validate;
1185: --
1186: -- ----------------------------------------------------------------------------
1187: -- |---------------------------< update_validate >----------------------------|

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

1191: --
1192: l_proc varchar2(72) := g_package||'update_validate';
1193: --
1194: Begin
1195: hr_utility.set_location('Entering:'||l_proc, 5);
1196: --
1197: -- Call all supporting business operations. Mapping to the
1198: -- appropriate Business Rules in perpyp.bru is provided (where
1199: -- relevant)

Line 1205: hr_utility.set_location(l_proc, 12);

1201: -- Validate business_group id
1202: --
1203: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1204: --
1205: hr_utility.set_location(l_proc, 12);
1206: --
1207: -- Check those columns which cannot be updated
1208: -- have not changed
1209: --

Line 1219: hr_utility.set_location(l_proc, 10);

1215: --
1216: per_ppc_bus.check_non_updateable_args
1217: (p_rec =>p_rec);
1218: --
1219: hr_utility.set_location(l_proc, 10);
1220: --
1221: -- Validate pay_proposal_id
1222: --
1223: -- Business Rule Mapping

Line 1240: hr_utility.set_location(l_proc, 15);

1236: per_ppc_bus.chk_access(p_pay_proposal_id => p_rec.pay_proposal_id);
1237: --
1238: --
1239: --
1240: hr_utility.set_location(l_proc, 15);
1241: --
1242: -- Business Rule Mapping
1243: -- =====================
1244: -- Rule CHK_COMPONENT_REASON /a,b,d

Line 1254: hr_utility.set_location(l_proc, 20);

1250: ,p_approved => p_rec.approved
1251: ,p_object_version_number => p_rec.object_version_number
1252: );
1253: --
1254: hr_utility.set_location(l_proc, 20);
1255: --
1256: --
1257: -- Business Rule Mapping
1258: -- =====================

Line 1272: hr_utility.set_location(l_proc, 25);

1268: ,p_approved => p_rec.approved
1269: ,p_object_version_number => p_rec.object_version_number
1270: );
1271: --
1272: hr_utility.set_location(l_proc, 25);
1273: --
1274: --
1275: -- Business Rule Mapping
1276: -- =====================

Line 1288: hr_utility.set_location(l_proc, 30);

1284: ,p_change_percentage => p_rec.change_percentage
1285: ,p_object_version_number => p_rec.object_version_number
1286: );
1287: --
1288: hr_utility.set_location(l_proc, 30);
1289: --
1290: --
1291: -- Call descriptive flexfield validation routines
1292: --

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

1291: -- Call descriptive flexfield validation routines
1292: --
1293: per_ppc_bus.chk_df(p_rec => p_rec);
1294: --
1295: hr_utility.set_location(' Leaving:'||l_proc, 10);
1296: End update_validate;
1297: --
1298: -- ----------------------------------------------------------------------------
1299: -- |---------------------------< delete_validate >----------------------------|

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

1303: --
1304: l_proc varchar2(72) := g_package||'delete_validate';
1305: --
1306: Begin
1307: hr_utility.set_location('Entering:'||l_proc, 5);
1308: --
1309: -- Call all supporting business operations
1310: --
1311: -- Validate delete

Line 1321: hr_utility.set_location(' WEAK:'||l_proc, 7);

1317: -- =====================
1318: -- Rule CHK_DELETE_COMPONENT /a
1319: --
1320: if (p_validation_strength='WEAK') THEN
1321: hr_utility.set_location(' WEAK:'||l_proc, 7);
1322: elsif (p_validation_strength='STRONG') THEN
1323: hr_utility.set_location(' STRONG:'||l_proc, 8);
1324: chk_delete_component
1325: (p_component_id => p_rec.component_id

Line 1323: hr_utility.set_location(' STRONG:'||l_proc, 8);

1319: --
1320: if (p_validation_strength='WEAK') THEN
1321: hr_utility.set_location(' WEAK:'||l_proc, 7);
1322: elsif (p_validation_strength='STRONG') THEN
1323: hr_utility.set_location(' STRONG:'||l_proc, 8);
1324: chk_delete_component
1325: (p_component_id => p_rec.component_id
1326: );
1327: else

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

1324: chk_delete_component
1325: (p_component_id => p_rec.component_id
1326: );
1327: else
1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE', l_proc);
1330: hr_utility.set_message_token('STEP', '1');
1331: end if;
1332:

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

1325: (p_component_id => p_rec.component_id
1326: );
1327: else
1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE', l_proc);
1330: hr_utility.set_message_token('STEP', '1');
1331: end if;
1332:
1333: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1326: );
1327: else
1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE', l_proc);
1330: hr_utility.set_message_token('STEP', '1');
1331: end if;
1332:
1333: hr_utility.set_location(' Leaving:'||l_proc, 10);
1334: End delete_validate;

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

1329: hr_utility.set_message_token('PROCEDURE', l_proc);
1330: hr_utility.set_message_token('STEP', '1');
1331: end if;
1332:
1333: hr_utility.set_location(' Leaving:'||l_proc, 10);
1334: End delete_validate;
1335: --
1336: --
1337: -- ---------------------------------------------------------------------------

Line 1359: hr_utility.set_location('Entering:'|| l_proc, 10);

1355: --
1356: l_legislation_code varchar2(150);
1357: l_proc varchar2(72) := 'return_legislation_code';
1358: begin
1359: hr_utility.set_location('Entering:'|| l_proc, 10);
1360: --
1361: -- Ensure that all the mandatory parameter are not null
1362: --
1363: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1374: hr_utility.set_location(l_proc, 20);

1370: -- call to this function. Just return the value in the global
1371: -- variable.
1372: --
1373: l_legislation_code := g_legislation_code;
1374: hr_utility.set_location(l_proc, 20);
1375: else
1376: --
1377: -- The ID is different to the last call to this function
1378: -- or this is the first call to this function.

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

1383: --
1384: -- The primary key is invalid therefore we must error
1385: --
1386: close csr_leg_code;
1387: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1388: hr_utility.raise_error;
1389: end if;
1390: hr_utility.set_location(l_proc, 30);
1391: --

Line 1388: hr_utility.raise_error;

1384: -- The primary key is invalid therefore we must error
1385: --
1386: close csr_leg_code;
1387: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1388: hr_utility.raise_error;
1389: end if;
1390: hr_utility.set_location(l_proc, 30);
1391: --
1392: -- Set the global variables so the values are

Line 1390: hr_utility.set_location(l_proc, 30);

1386: close csr_leg_code;
1387: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1388: hr_utility.raise_error;
1389: end if;
1390: hr_utility.set_location(l_proc, 30);
1391: --
1392: -- Set the global variables so the values are
1393: -- available for the next call to this function
1394: --

Line 1399: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1395: close csr_leg_code;
1396: g_component_id := p_component_id;
1397: g_legislation_code := l_legislation_code;
1398: end if;
1399: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1400: --
1401: return l_legislation_code;
1402: end return_legislation_code;
1403: --