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.PQH_BGT_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_bgt_shd.api_updating
47: (p_budget_id => p_budget_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_budget_id;
75: --
76: -- ----------------------------------------------------------------------------+

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

115: where a.shared_type_id = p_budget_unit3_id;
116: --
117: Begin
118: --
119: hr_utility.set_location('Entering:'||l_proc,5);
120: --
121: l_api_updating := pqh_bgt_shd.api_updating
122: (p_budget_id => p_budget_id,
123: p_object_version_number => p_object_version_number);

Line 136: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');

132: -- UOM is changed
133: --
134: if NVL(p_status,'X') = 'FROZEN' then
135: --
136: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');
137: hr_utility.raise_error;
138: --
139: end if;
140:

Line 137: hr_utility.raise_error;

133: --
134: if NVL(p_status,'X') = 'FROZEN' then
135: --
136: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');
137: hr_utility.raise_error;
138: --
139: end if;
140:
141: end if;

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

165: close c1;
166: --
167: end if;
168: --
169: hr_utility.set_location('Leaving:'||l_proc,10);
170: --
171: End chk_budget_unit3_id;
172: --
173: -- ----------------------------------------------------------------------------+

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

210: where a.shared_type_id = p_budget_unit2_id;
211: --
212: Begin
213: --
214: hr_utility.set_location('Entering:'||l_proc,5);
215: --
216: l_api_updating := pqh_bgt_shd.api_updating
217: (p_budget_id => p_budget_id,
218: p_object_version_number => p_object_version_number);

Line 233: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');

229: --
230: if NVL(p_status,'X') = 'FROZEN' then
231: --
232: --
233: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');
234: hr_utility.raise_error;
235: --
236: end if;
237:

Line 234: hr_utility.raise_error;

230: if NVL(p_status,'X') = 'FROZEN' then
231: --
232: --
233: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');
234: hr_utility.raise_error;
235: --
236: end if;
237:
238: end if;

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

263: close c1;
264: --
265: end if;
266: --
267: hr_utility.set_location('Leaving:'||l_proc,10);
268: --
269: End chk_budget_unit2_id;
270: --
271: -- ----------------------------------------------------------------------------+

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

308: where a.shared_type_id = p_budget_unit1_id;
309: --
310: Begin
311: --
312: hr_utility.set_location('Entering:'||l_proc,5);
313: --
314: l_api_updating := pqh_bgt_shd.api_updating
315: (p_budget_id => p_budget_id,
316: p_object_version_number => p_object_version_number);

Line 331: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');

327: --
328: if NVL(p_status,'X') = 'FROZEN' then
329: --
330: --
331: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');
332: hr_utility.raise_error;
333: --
334: end if;
335:

Line 332: hr_utility.raise_error;

328: if NVL(p_status,'X') = 'FROZEN' then
329: --
330: --
331: hr_utility.set_message(8302,'PQH_BUDGET_UOM_CHANGED');
332: hr_utility.raise_error;
333: --
334: end if;
335:
336: end if;

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

361: close c1;
362: --
363: end if;
364: --
365: hr_utility.set_location('Leaving:'||l_proc,10);
366: --
367: End chk_budget_unit1_id;
368: --
369: -- ----------------------------------------------------------------------------+

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

424: and budget_id <> nvl(p_budget_id,0);
425: --
426: Begin
427: --
428: hr_utility.set_location('Entering:'||l_proc,5);
429: --
430: if p_budget_unit1_id is not null then
431: l_bgt_unit1_type := pqh_wks_budget.get_unit_type(p_budget_unit1_id);
432: end if;

Line 440: hr_utility.set_message(8302,'PQH_BGT_OPEN_CTRL');

436: if p_budget_unit3_id is not null then
437: l_bgt_unit3_type := pqh_wks_budget.get_unit_type(p_budget_unit3_id);
438: end if;
439: if p_budgeted_entity_cd ='OPEN' then
440: hr_utility.set_message(8302,'PQH_BGT_OPEN_CTRL');
441: hr_utility.raise_error;
442: end if;
443: for i in c1 loop
444: l_units := '' ;

Line 441: hr_utility.raise_error;

437: l_bgt_unit3_type := pqh_wks_budget.get_unit_type(p_budget_unit3_id);
438: end if;
439: if p_budgeted_entity_cd ='OPEN' then
440: hr_utility.set_message(8302,'PQH_BGT_OPEN_CTRL');
441: hr_utility.raise_error;
442: end if;
443: for i in c1 loop
444: l_units := '' ;
445: if i.budget_unit1_id is not null then

Line 469: hr_utility.set_message(8302,'PQH_BGV_POS_CTRL');

465: (nvl(l_unit2_type,'-2') = nvl(l_bgt_unit3_type,'-1')) or
466: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit1_type,'-1')) or
467: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit2_type,'-1')) or
468: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit3_type,'-1')) then
469: hr_utility.set_message(8302,'PQH_BGV_POS_CTRL');
470: hr_utility.set_message_token('BUDGET_NAME',i.budget_name);
471: hr_utility.set_message_token('START_DATE',i.budget_start_date);
472: hr_utility.set_message_token('END_DATE',i.budget_end_date);
473: hr_utility.set_message_token('UNITS',l_units);

Line 470: hr_utility.set_message_token('BUDGET_NAME',i.budget_name);

466: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit1_type,'-1')) or
467: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit2_type,'-1')) or
468: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit3_type,'-1')) then
469: hr_utility.set_message(8302,'PQH_BGV_POS_CTRL');
470: hr_utility.set_message_token('BUDGET_NAME',i.budget_name);
471: hr_utility.set_message_token('START_DATE',i.budget_start_date);
472: hr_utility.set_message_token('END_DATE',i.budget_end_date);
473: hr_utility.set_message_token('UNITS',l_units);
474: hr_utility.raise_error;

Line 471: hr_utility.set_message_token('START_DATE',i.budget_start_date);

467: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit2_type,'-1')) or
468: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit3_type,'-1')) then
469: hr_utility.set_message(8302,'PQH_BGV_POS_CTRL');
470: hr_utility.set_message_token('BUDGET_NAME',i.budget_name);
471: hr_utility.set_message_token('START_DATE',i.budget_start_date);
472: hr_utility.set_message_token('END_DATE',i.budget_end_date);
473: hr_utility.set_message_token('UNITS',l_units);
474: hr_utility.raise_error;
475: end if;

Line 472: hr_utility.set_message_token('END_DATE',i.budget_end_date);

468: (nvl(l_unit3_type,'-2') = nvl(l_bgt_unit3_type,'-1')) then
469: hr_utility.set_message(8302,'PQH_BGV_POS_CTRL');
470: hr_utility.set_message_token('BUDGET_NAME',i.budget_name);
471: hr_utility.set_message_token('START_DATE',i.budget_start_date);
472: hr_utility.set_message_token('END_DATE',i.budget_end_date);
473: hr_utility.set_message_token('UNITS',l_units);
474: hr_utility.raise_error;
475: end if;
476: end loop;

Line 473: hr_utility.set_message_token('UNITS',l_units);

469: hr_utility.set_message(8302,'PQH_BGV_POS_CTRL');
470: hr_utility.set_message_token('BUDGET_NAME',i.budget_name);
471: hr_utility.set_message_token('START_DATE',i.budget_start_date);
472: hr_utility.set_message_token('END_DATE',i.budget_end_date);
473: hr_utility.set_message_token('UNITS',l_units);
474: hr_utility.raise_error;
475: end if;
476: end loop;
477: hr_utility.set_location('Leaving:'||l_proc,10);

Line 474: hr_utility.raise_error;

470: hr_utility.set_message_token('BUDGET_NAME',i.budget_name);
471: hr_utility.set_message_token('START_DATE',i.budget_start_date);
472: hr_utility.set_message_token('END_DATE',i.budget_end_date);
473: hr_utility.set_message_token('UNITS',l_units);
474: hr_utility.raise_error;
475: end if;
476: end loop;
477: hr_utility.set_location('Leaving:'||l_proc,10);
478: --

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

473: hr_utility.set_message_token('UNITS',l_units);
474: hr_utility.raise_error;
475: end if;
476: end loop;
477: hr_utility.set_location('Leaving:'||l_proc,10);
478: --
479: End chk_pos_control_budget;
480: --
481: -- ----------------------------------------------------------------------------+

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

517: where a.period_set_name = p_period_set_name;
518: --
519: Begin
520: --
521: hr_utility.set_location('Entering:'||l_proc,5);
522: --
523: l_api_updating := pqh_bgt_shd.api_updating
524: (p_budget_id => p_budget_id,
525: p_object_version_number => p_object_version_number);

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

548: close c1;
549: --
550: end if;
551: --
552: hr_utility.set_location('Leaving:'||l_proc,10);
553: --
554: End chk_period_set_name;
555: --
556: -- ----------------------------------------------------------------------------+

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

615: WHERE a.set_of_books_id = nvl(p_gl_set_of_books_id,-9999);
616: --
617: Begin
618: --
619: hr_utility.set_location('Entering:'||l_proc, 5);
620: --
621: /* commented out nocopy by kmullapu to remove limitation that controlled budget name should be
622: similar to GL budget name for transfering to GL. A controll Bugdted can be transfered
623: to any GL budget provided that controll budget falls with in GL budget date range.

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

640: p_effective_date => p_effective_date) then
641: --
642: -- raise error as does not exist as lookup
643: --
644: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
645: hr_utility.raise_error;
646: --
647: end if;
648: end if;

Line 645: hr_utility.raise_error;

641: --
642: -- raise error as does not exist as lookup
643: --
644: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
645: hr_utility.raise_error;
646: --
647: end if;
648: end if;
649: */

Line 662: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVLD_DATE_RANGE');

658: p_budget_start_date >= l_gl_bgt_end_date) THEN
659: -- GL budget doest not cover Control Budget range
660: l_gl_budget_range := fnd_date.date_to_displaydate(l_gl_bgt_start_date)||' - '||fnd_date.date_to_displaydate(l_gl_bgt_end_date);
661: l_budget_range := fnd_date.date_to_displaydate(p_budget_start_date)||' - '||fnd_date.date_to_displaydate(p_budget_end_date);
662: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVLD_DATE_RANGE');
663: hr_utility.set_message_token('GL_BUDGET_DATE_RANGE',l_gl_budget_range);
664: hr_utility.set_message_token('BUDGET_DATE_RANGE',l_budget_range);
665: hr_utility.raise_error;
666: END IF;

Line 663: hr_utility.set_message_token('GL_BUDGET_DATE_RANGE',l_gl_budget_range);

659: -- GL budget doest not cover Control Budget range
660: l_gl_budget_range := fnd_date.date_to_displaydate(l_gl_bgt_start_date)||' - '||fnd_date.date_to_displaydate(l_gl_bgt_end_date);
661: l_budget_range := fnd_date.date_to_displaydate(p_budget_start_date)||' - '||fnd_date.date_to_displaydate(p_budget_end_date);
662: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVLD_DATE_RANGE');
663: hr_utility.set_message_token('GL_BUDGET_DATE_RANGE',l_gl_budget_range);
664: hr_utility.set_message_token('BUDGET_DATE_RANGE',l_budget_range);
665: hr_utility.raise_error;
666: END IF;
667: ELSE

Line 664: hr_utility.set_message_token('BUDGET_DATE_RANGE',l_budget_range);

660: l_gl_budget_range := fnd_date.date_to_displaydate(l_gl_bgt_start_date)||' - '||fnd_date.date_to_displaydate(l_gl_bgt_end_date);
661: l_budget_range := fnd_date.date_to_displaydate(p_budget_start_date)||' - '||fnd_date.date_to_displaydate(p_budget_end_date);
662: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVLD_DATE_RANGE');
663: hr_utility.set_message_token('GL_BUDGET_DATE_RANGE',l_gl_budget_range);
664: hr_utility.set_message_token('BUDGET_DATE_RANGE',l_budget_range);
665: hr_utility.raise_error;
666: END IF;
667: ELSE
668: -- budget Not defined in GL

Line 665: hr_utility.raise_error;

661: l_budget_range := fnd_date.date_to_displaydate(p_budget_start_date)||' - '||fnd_date.date_to_displaydate(p_budget_end_date);
662: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVLD_DATE_RANGE');
663: hr_utility.set_message_token('GL_BUDGET_DATE_RANGE',l_gl_budget_range);
664: hr_utility.set_message_token('BUDGET_DATE_RANGE',l_budget_range);
665: hr_utility.raise_error;
666: END IF;
667: ELSE
668: -- budget Not defined in GL
669: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');

Line 669: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');

665: hr_utility.raise_error;
666: END IF;
667: ELSE
668: -- budget Not defined in GL
669: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');
670: hr_utility.raise_error;
671: END IF;
672: OPEN csr_gl_budgets_rec;
673: FETCH csr_gl_budgets_rec INTO l_gl_budget_rec;

Line 670: hr_utility.raise_error;

666: END IF;
667: ELSE
668: -- budget Not defined in GL
669: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');
670: hr_utility.raise_error;
671: END IF;
672: OPEN csr_gl_budgets_rec;
673: FETCH csr_gl_budgets_rec INTO l_gl_budget_rec;
674: CLOSE csr_gl_budgets_rec;

Line 677: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');

673: FETCH csr_gl_budgets_rec INTO l_gl_budget_rec;
674: CLOSE csr_gl_budgets_rec;
675: IF l_gl_budget_rec.budget_name IS NULL THEN
676: -- budget Not defined in GL
677: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');
678: hr_utility.raise_error;
679: ELSIF NVL(l_gl_budget_rec.status,'Z') = 'C' THEN
680: -- GL Budget is already closed
681: -- raise error

Line 678: hr_utility.raise_error;

674: CLOSE csr_gl_budgets_rec;
675: IF l_gl_budget_rec.budget_name IS NULL THEN
676: -- budget Not defined in GL
677: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');
678: hr_utility.raise_error;
679: ELSIF NVL(l_gl_budget_rec.status,'Z') = 'C' THEN
680: -- GL Budget is already closed
681: -- raise error
682: hr_utility.set_message(8302,'PQH_GL_BUDGET_CLOSED');

Line 682: hr_utility.set_message(8302,'PQH_GL_BUDGET_CLOSED');

678: hr_utility.raise_error;
679: ELSIF NVL(l_gl_budget_rec.status,'Z') = 'C' THEN
680: -- GL Budget is already closed
681: -- raise error
682: hr_utility.set_message(8302,'PQH_GL_BUDGET_CLOSED');
683: hr_utility.raise_error;
684: ELSIF l_gl_budget_rec.latest_opened_year IS NULL THEN
685: -- latest open year for the GL budget is null
686: -- raise error

Line 683: hr_utility.raise_error;

679: ELSIF NVL(l_gl_budget_rec.status,'Z') = 'C' THEN
680: -- GL Budget is already closed
681: -- raise error
682: hr_utility.set_message(8302,'PQH_GL_BUDGET_CLOSED');
683: hr_utility.raise_error;
684: ELSIF l_gl_budget_rec.latest_opened_year IS NULL THEN
685: -- latest open year for the GL budget is null
686: -- raise error
687: hr_utility.set_message(8302,'PQH_GL_BUDGET_YEAR');

Line 687: hr_utility.set_message(8302,'PQH_GL_BUDGET_YEAR');

683: hr_utility.raise_error;
684: ELSIF l_gl_budget_rec.latest_opened_year IS NULL THEN
685: -- latest open year for the GL budget is null
686: -- raise error
687: hr_utility.set_message(8302,'PQH_GL_BUDGET_YEAR');
688: hr_utility.raise_error;
689: -- hmehta Changed set_of_books_id to ledger_id for bug4602435
690: ELSIF l_gl_budget_rec.ledger_id <> p_gl_set_of_books_id THEN
691: -- Budget set of books does not match with GL budget set of books

Line 688: hr_utility.raise_error;

684: ELSIF l_gl_budget_rec.latest_opened_year IS NULL THEN
685: -- latest open year for the GL budget is null
686: -- raise error
687: hr_utility.set_message(8302,'PQH_GL_BUDGET_YEAR');
688: hr_utility.raise_error;
689: -- hmehta Changed set_of_books_id to ledger_id for bug4602435
690: ELSIF l_gl_budget_rec.ledger_id <> p_gl_set_of_books_id THEN
691: -- Budget set of books does not match with GL budget set of books
692: -- raise error

Line 693: hr_utility.set_message(8302,'PQH_GL_SOB_DIFFERENT');

689: -- hmehta Changed set_of_books_id to ledger_id for bug4602435
690: ELSIF l_gl_budget_rec.ledger_id <> p_gl_set_of_books_id THEN
691: -- Budget set of books does not match with GL budget set of books
692: -- raise error
693: hr_utility.set_message(8302,'PQH_GL_SOB_DIFFERENT');
694: hr_utility.raise_error;
695: else
696: open csr_set_of_books;
697: fetch csr_set_of_books into l_dummy;

Line 694: hr_utility.raise_error;

690: ELSIF l_gl_budget_rec.ledger_id <> p_gl_set_of_books_id THEN
691: -- Budget set of books does not match with GL budget set of books
692: -- raise error
693: hr_utility.set_message(8302,'PQH_GL_SOB_DIFFERENT');
694: hr_utility.raise_error;
695: else
696: open csr_set_of_books;
697: fetch csr_set_of_books into l_dummy;
698: if csr_set_of_books%notfound then

Line 699: hr_utility.set_message(8302,'PQH_INVALID_SET_OF_BOOKS');

695: else
696: open csr_set_of_books;
697: fetch csr_set_of_books into l_dummy;
698: if csr_set_of_books%notfound then
699: hr_utility.set_message(8302,'PQH_INVALID_SET_OF_BOOKS');
700: hr_utility.raise_error;
701: end if;
702: END IF;
703: else

Line 700: hr_utility.raise_error;

696: open csr_set_of_books;
697: fetch csr_set_of_books into l_dummy;
698: if csr_set_of_books%notfound then
699: hr_utility.set_message(8302,'PQH_INVALID_SET_OF_BOOKS');
700: hr_utility.raise_error;
701: end if;
702: END IF;
703: else
704: -- Budget must be a Controlled budget to be marked transfer to gl

Line 706: hr_utility.set_message(8302,'PQH_TRANSFER_TO_GL');

702: END IF;
703: else
704: -- Budget must be a Controlled budget to be marked transfer to gl
705: -- raise error
706: hr_utility.set_message(8302,'PQH_TRANSFER_TO_GL');
707: hr_utility.raise_error;
708: END IF;
709: END IF;
710: --

Line 707: hr_utility.raise_error;

703: else
704: -- Budget must be a Controlled budget to be marked transfer to gl
705: -- raise error
706: hr_utility.set_message(8302,'PQH_TRANSFER_TO_GL');
707: hr_utility.raise_error;
708: END IF;
709: END IF;
710: --
711: --

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

708: END IF;
709: END IF;
710: --
711: --
712: hr_utility.set_location('Leaving:'||l_proc,10);
713: --
714: end chk_transfer_to_gl;
715: --
716: -- ----------------------------------------------------------------------------+

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

749: l_api_updating boolean;
750: --
751: Begin
752: --
753: hr_utility.set_location('Entering:'||l_proc, 5);
754: --
755: l_api_updating := pqh_bgt_shd.api_updating
756: (p_budget_id => p_budget_id,
757: p_object_version_number => p_object_version_number);

Line 774: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

770: p_effective_date => p_effective_date) then
771: --
772: -- raise error as does not exist as lookup
773: --
774: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
775: hr_utility.raise_error;
776: --
777: end if;
778: --

Line 775: hr_utility.raise_error;

771: --
772: -- raise error as does not exist as lookup
773: --
774: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
775: hr_utility.raise_error;
776: --
777: end if;
778: --
779: end if;

Line 784: hr_utility.set_message(8302,'PQH_TRANSFER_TO_GRANTS');

780: if nvl(p_transfer_to_grants_flag,'N') ='Y' then
781: if nvl(p_position_control_flag,'N') ='N' then
782: -- Budget must be a Controlled budget to be marked transfer to grants
783: -- raise error
784: hr_utility.set_message(8302,'PQH_TRANSFER_TO_GRANTS');
785: hr_utility.raise_error;
786: end if;
787: end if;
788: --

Line 785: hr_utility.raise_error;

781: if nvl(p_position_control_flag,'N') ='N' then
782: -- Budget must be a Controlled budget to be marked transfer to grants
783: -- raise error
784: hr_utility.set_message(8302,'PQH_TRANSFER_TO_GRANTS');
785: hr_utility.raise_error;
786: end if;
787: end if;
788: --
789: hr_utility.set_location('Leaving:'||l_proc,10);

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

785: hr_utility.raise_error;
786: end if;
787: end if;
788: --
789: hr_utility.set_location('Leaving:'||l_proc,10);
790: --
791: end chk_transfer_to_grants_flag;
792: --
793: -- ---------------------------------------------------------------------------+

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

803: l_api_updating boolean;
804: --
805: Begin
806: --
807: hr_utility.set_location('Entering:'||l_proc, 5);
808: --
809: l_api_updating := pqh_bgt_shd.api_updating
810: (p_budget_id => p_budget_id,
811: p_object_version_number => p_object_version_number);

Line 825: hr_utility.set_message(8302,'PQH_INVAILD_BUDGET_STATUS');

821: if p_status <> 'FROZEN' then
822: --
823: -- raise error as does not exist as lookup
824: --
825: hr_utility.set_message(8302,'PQH_INVAILD_BUDGET_STATUS');
826: hr_utility.raise_error;
827: --
828: end if;
829: --

Line 826: hr_utility.raise_error;

822: --
823: -- raise error as does not exist as lookup
824: --
825: hr_utility.set_message(8302,'PQH_INVAILD_BUDGET_STATUS');
826: hr_utility.raise_error;
827: --
828: end if;
829: --
830: end if;

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

828: end if;
829: --
830: end if;
831: --
832: hr_utility.set_location('Leaving:'||l_proc,10);
833: --
834: end chk_status;
835: --
836: -- ----------------------------------------------------------------------------+

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

868: l_api_updating boolean;
869: --
870: Begin
871: --
872: hr_utility.set_location('Entering:'||l_proc, 5);
873: --
874: l_api_updating := pqh_bgt_shd.api_updating
875: (p_budget_id => p_budget_id,
876: p_object_version_number => p_object_version_number);

Line 893: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

889: p_effective_date => p_effective_date) then
890: --
891: -- raise error as does not exist as lookup
892: --
893: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
894: hr_utility.raise_error;
895: --
896: end if;
897: --

Line 894: hr_utility.raise_error;

890: --
891: -- raise error as does not exist as lookup
892: --
893: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
894: hr_utility.raise_error;
895: --
896: end if;
897: --
898: end if;

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

896: end if;
897: --
898: end if;
899: --
900: hr_utility.set_location('Leaving:'||l_proc,10);
901: --
902: end chk_budget_style_cd;
903: --
904: -- ----------------------------------------------------------------------------+

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

936: l_api_updating boolean;
937: --
938: Begin
939: --
940: hr_utility.set_location('Entering:'||l_proc, 5);
941: --
942: l_api_updating := pqh_bgt_shd.api_updating
943: (p_budget_id => p_budget_id,
944: p_object_version_number => p_object_version_number);

Line 961: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

957: p_effective_date => p_effective_date) then
958: --
959: -- raise error as does not exist as lookup
960: --
961: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
962: hr_utility.raise_error;
963: --
964: end if;
965: --

Line 962: hr_utility.raise_error;

958: --
959: -- raise error as does not exist as lookup
960: --
961: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
962: hr_utility.raise_error;
963: --
964: end if;
965: --
966: end if;

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

964: end if;
965: --
966: end if;
967: --
968: hr_utility.set_location('Leaving:'||l_proc,10);
969: --
970: end chk_budgeted_entity_cd;
971: --
972: -- ---------------------------------------------------------------------------+

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

1051: and bvr.budget_id = p_budget_id;
1052:
1053: Begin
1054: --
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: --
1057:
1058: l_api_updating := pqh_bgt_shd.api_updating
1059: (p_budget_id => p_budget_id,

Line 1083: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');

1079: if (p_budget_start_date > l_min_budget_dt) THEN
1080: --
1081: -- raise error as does not exist as lookup
1082: --
1083: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');
1084: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));
1085: hr_utility.raise_error;
1086: --
1087: end if;

Line 1084: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));

1080: --
1081: -- raise error as does not exist as lookup
1082: --
1083: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');
1084: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));
1085: hr_utility.raise_error;
1086: --
1087: end if;
1088: elsif (l_min_wks_dt IS NOT NULL) THEN

Line 1085: hr_utility.raise_error;

1081: -- raise error as does not exist as lookup
1082: --
1083: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');
1084: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));
1085: hr_utility.raise_error;
1086: --
1087: end if;
1088: elsif (l_min_wks_dt IS NOT NULL) THEN
1089: if (p_budget_start_date > l_min_wks_dt) THEN

Line 1093: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');

1089: if (p_budget_start_date > l_min_wks_dt) THEN
1090: --
1091: -- raise error as does not exist as lookup
1092: --
1093: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');
1094: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));
1095: hr_utility.raise_error;
1096: --
1097: end if;

Line 1094: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));

1090: --
1091: -- raise error as does not exist as lookup
1092: --
1093: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');
1094: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));
1095: hr_utility.raise_error;
1096: --
1097: end if;
1098:

Line 1095: hr_utility.raise_error;

1091: -- raise error as does not exist as lookup
1092: --
1093: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_ST_DT');
1094: hr_utility.set_message_token('STARTDATE',to_char(l_min_budget_dt,'DD-MM-RRRR'));
1095: hr_utility.raise_error;
1096: --
1097: end if;
1098:
1099: end if;

Line 1104: hr_utility.set_message(8302,'PQH_INVALID_END_DT');

1100: --
1101: -- check if start_date is less then end date
1102: if p_budget_start_date > p_budget_end_date then
1103: -- raise error as invalid date
1104: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1105: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1106: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1107: hr_utility.raise_error;
1108: end if;

Line 1105: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));

1101: -- check if start_date is less then end date
1102: if p_budget_start_date > p_budget_end_date then
1103: -- raise error as invalid date
1104: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1105: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1106: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1107: hr_utility.raise_error;
1108: end if;
1109: --

Line 1106: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));

1102: if p_budget_start_date > p_budget_end_date then
1103: -- raise error as invalid date
1104: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1105: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1106: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1107: hr_utility.raise_error;
1108: end if;
1109: --
1110: --

Line 1107: hr_utility.raise_error;

1103: -- raise error as invalid date
1104: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1105: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1106: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1107: hr_utility.raise_error;
1108: end if;
1109: --
1110: --
1111: /*

Line 1121: hr_utility.set_message(8302,'PQH_BUDGET_ST_DT_CAL');

1117: CLOSE per_cal_start_dt_cur;
1118:
1119: if p_budget_start_date < l_min_cal_dt then
1120: --
1121: hr_utility.set_message(8302,'PQH_BUDGET_ST_DT_CAL');
1122: hr_utility.set_message_token('CALSTART',to_char(l_min_cal_dt,'DD-MM-RRRR'));
1123: hr_utility.raise_error;
1124: --
1125: end if;

Line 1122: hr_utility.set_message_token('CALSTART',to_char(l_min_cal_dt,'DD-MM-RRRR'));

1118:
1119: if p_budget_start_date < l_min_cal_dt then
1120: --
1121: hr_utility.set_message(8302,'PQH_BUDGET_ST_DT_CAL');
1122: hr_utility.set_message_token('CALSTART',to_char(l_min_cal_dt,'DD-MM-RRRR'));
1123: hr_utility.raise_error;
1124: --
1125: end if;
1126: --

Line 1123: hr_utility.raise_error;

1119: if p_budget_start_date < l_min_cal_dt then
1120: --
1121: hr_utility.set_message(8302,'PQH_BUDGET_ST_DT_CAL');
1122: hr_utility.set_message_token('CALSTART',to_char(l_min_cal_dt,'DD-MM-RRRR'));
1123: hr_utility.raise_error;
1124: --
1125: end if;
1126: --
1127: --

Line 1137: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_DTS');

1133:
1134: IF NVL(l_cnt_periods,0) = 0 THEN
1135: -- error as no periods
1136: --
1137: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_DTS');
1138: hr_utility.raise_error;
1139: --
1140: END IF;
1141: --

Line 1138: hr_utility.raise_error;

1134: IF NVL(l_cnt_periods,0) = 0 THEN
1135: -- error as no periods
1136: --
1137: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_DTS');
1138: hr_utility.raise_error;
1139: --
1140: END IF;
1141: --
1142: --

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

1141: --
1142: --
1143: end if;
1144: --
1145: hr_utility.set_location('Leaving:'||l_proc,10);
1146: --
1147: end chk_budget_start_date;
1148: --
1149: -- ---------------------------------------------------------------------------+

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

1229: and bvr.budget_id = p_budget_id;
1230:
1231: Begin
1232: --
1233: hr_utility.set_location('Entering:'||l_proc, 5);
1234: --
1235:
1236: l_api_updating := pqh_bgt_shd.api_updating
1237: (p_budget_id => p_budget_id,

Line 1261: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');

1257: if (p_budget_end_date < l_max_budget_dt) THEN
1258: --
1259: -- raise error as does not exist as lookup
1260: --
1261: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');
1262: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));
1263: hr_utility.raise_error;
1264: --
1265: end if;

Line 1262: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));

1258: --
1259: -- raise error as does not exist as lookup
1260: --
1261: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');
1262: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));
1263: hr_utility.raise_error;
1264: --
1265: end if;
1266: elsif (l_max_wks_dt IS NOT NULL) THEN

Line 1263: hr_utility.raise_error;

1259: -- raise error as does not exist as lookup
1260: --
1261: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');
1262: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));
1263: hr_utility.raise_error;
1264: --
1265: end if;
1266: elsif (l_max_wks_dt IS NOT NULL) THEN
1267: if (p_budget_end_date < l_max_wks_dt) THEN

Line 1271: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');

1267: if (p_budget_end_date < l_max_wks_dt) THEN
1268: --
1269: -- raise error as does not exist as lookup
1270: --
1271: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');
1272: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));
1273: hr_utility.raise_error;
1274: --
1275: end if;

Line 1272: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));

1268: --
1269: -- raise error as does not exist as lookup
1270: --
1271: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');
1272: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));
1273: hr_utility.raise_error;
1274: --
1275: end if;
1276: end if;

Line 1273: hr_utility.raise_error;

1269: -- raise error as does not exist as lookup
1270: --
1271: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_END_DT');
1272: hr_utility.set_message_token('ENDDATE',to_char(l_max_budget_dt,'DD-MM-RRRR'));
1273: hr_utility.raise_error;
1274: --
1275: end if;
1276: end if;
1277: --

Line 1281: hr_utility.set_message(8302,'PQH_INVALID_END_DT');

1277: --
1278: -- check if start_date is less then end date
1279: if p_budget_start_date > p_budget_end_date then
1280: -- raise error as invalid date
1281: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1282: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1283: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1284: hr_utility.raise_error;
1285: end if;

Line 1282: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));

1278: -- check if start_date is less then end date
1279: if p_budget_start_date > p_budget_end_date then
1280: -- raise error as invalid date
1281: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1282: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1283: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1284: hr_utility.raise_error;
1285: end if;
1286: --

Line 1283: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));

1279: if p_budget_start_date > p_budget_end_date then
1280: -- raise error as invalid date
1281: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1282: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1283: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1284: hr_utility.raise_error;
1285: end if;
1286: --
1287: --

Line 1284: hr_utility.raise_error;

1280: -- raise error as invalid date
1281: hr_utility.set_message(8302,'PQH_INVALID_END_DT');
1282: hr_utility.set_message_token('STARTDATE',to_char(p_budget_start_date,'DD-MM-RRRR'));
1283: hr_utility.set_message_token('ENDDATE',to_char(p_budget_end_date,'DD-MM-RRRR'));
1284: hr_utility.raise_error;
1285: end if;
1286: --
1287: --
1288: /*

Line 1298: hr_utility.set_message(8302,'PQH_BUDGET_END_DT_CAL');

1294: CLOSE per_cal_end_dt_cur;
1295:
1296: if p_budget_end_date > l_max_cal_dt then
1297: --
1298: hr_utility.set_message(8302,'PQH_BUDGET_END_DT_CAL');
1299: hr_utility.set_message_token('CALENDT',to_char(l_max_cal_dt,'DD-MM-RRRR'));
1300: hr_utility.raise_error;
1301: --
1302: end if;

Line 1299: hr_utility.set_message_token('CALENDT',to_char(l_max_cal_dt,'DD-MM-RRRR'));

1295:
1296: if p_budget_end_date > l_max_cal_dt then
1297: --
1298: hr_utility.set_message(8302,'PQH_BUDGET_END_DT_CAL');
1299: hr_utility.set_message_token('CALENDT',to_char(l_max_cal_dt,'DD-MM-RRRR'));
1300: hr_utility.raise_error;
1301: --
1302: end if;
1303: --

Line 1300: hr_utility.raise_error;

1296: if p_budget_end_date > l_max_cal_dt then
1297: --
1298: hr_utility.set_message(8302,'PQH_BUDGET_END_DT_CAL');
1299: hr_utility.set_message_token('CALENDT',to_char(l_max_cal_dt,'DD-MM-RRRR'));
1300: hr_utility.raise_error;
1301: --
1302: end if;
1303: --
1304: --

Line 1313: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_DTS');

1309:
1310: IF NVL(l_cnt_periods,0) = 0 THEN
1311: -- error as no periods
1312: --
1313: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_DTS');
1314: hr_utility.raise_error;
1315: --
1316: END IF;
1317: --

Line 1314: hr_utility.raise_error;

1310: IF NVL(l_cnt_periods,0) = 0 THEN
1311: -- error as no periods
1312: --
1313: hr_utility.set_message(8302,'PQH_INVALID_BUDGET_DTS');
1314: hr_utility.raise_error;
1315: --
1316: END IF;
1317: --
1318: --

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

1317: --
1318: --
1319: end if;
1320: --
1321: hr_utility.set_location('Leaving:'||l_proc,10);
1322: --
1323: end chk_budget_end_date;
1324: --
1325: -- ----------------------------------------------------------------------------+

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

1342: l_system_type_cd3 VARCHAR2(50);
1343: --
1344: Begin
1345: --
1346: hr_utility.set_location('Entering:'||l_proc, 5);
1347: --
1348: -- check for duplicate UOM
1349: -- compare 1 and 2
1350:

Line 1355: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');

1351: if p_budget_unit1_id IS NOT NULL and p_budget_unit2_id IS NOT NULL then
1352: if p_budget_unit1_id = p_budget_unit2_id then
1353: -- we have duplicate so error message
1354: --
1355: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');
1356: hr_utility.raise_error;
1357: --
1358:
1359: end if;

Line 1356: hr_utility.raise_error;

1352: if p_budget_unit1_id = p_budget_unit2_id then
1353: -- we have duplicate so error message
1354: --
1355: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');
1356: hr_utility.raise_error;
1357: --
1358:
1359: end if;
1360:

Line 1375: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');

1371: -- compare the system_type_cd
1372: if l_system_type_cd1 = l_system_type_cd2 then
1373: -- we have duplicate lookup code for PC budget, so error message
1374: --
1375: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1376: hr_utility.set_message_token('UNIT_ONE','Unit1');
1377: hr_utility.set_message_token('UNIT_TWO','Unit2');
1378: hr_utility.raise_error;
1379: --

Line 1376: hr_utility.set_message_token('UNIT_ONE','Unit1');

1372: if l_system_type_cd1 = l_system_type_cd2 then
1373: -- we have duplicate lookup code for PC budget, so error message
1374: --
1375: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1376: hr_utility.set_message_token('UNIT_ONE','Unit1');
1377: hr_utility.set_message_token('UNIT_TWO','Unit2');
1378: hr_utility.raise_error;
1379: --
1380:

Line 1377: hr_utility.set_message_token('UNIT_TWO','Unit2');

1373: -- we have duplicate lookup code for PC budget, so error message
1374: --
1375: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1376: hr_utility.set_message_token('UNIT_ONE','Unit1');
1377: hr_utility.set_message_token('UNIT_TWO','Unit2');
1378: hr_utility.raise_error;
1379: --
1380:
1381: end if; -- end compare the system_type_cd for PC budget

Line 1378: hr_utility.raise_error;

1374: --
1375: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1376: hr_utility.set_message_token('UNIT_ONE','Unit1');
1377: hr_utility.set_message_token('UNIT_TWO','Unit2');
1378: hr_utility.raise_error;
1379: --
1380:
1381: end if; -- end compare the system_type_cd for PC budget
1382: end if; -- p_position_control_flag is Y

Line 1394: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');

1390: if p_budget_unit2_id IS NOT NULL and p_budget_unit3_id IS NOT NULL then
1391: if p_budget_unit2_id = p_budget_unit3_id then
1392: -- we have duplicate so error message
1393: --
1394: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');
1395: hr_utility.raise_error;
1396: --
1397:
1398: end if;

Line 1395: hr_utility.raise_error;

1391: if p_budget_unit2_id = p_budget_unit3_id then
1392: -- we have duplicate so error message
1393: --
1394: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');
1395: hr_utility.raise_error;
1396: --
1397:
1398: end if;
1399:

Line 1414: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');

1410: -- compare the system_type_cd
1411: if l_system_type_cd2 = l_system_type_cd3 then
1412: -- we have duplicate lookup code for PC budget, so error message
1413: --
1414: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1415: hr_utility.set_message_token('UNIT_ONE','Unit2');
1416: hr_utility.set_message_token('UNIT_TWO','Unit3');
1417: hr_utility.raise_error;
1418: --

Line 1415: hr_utility.set_message_token('UNIT_ONE','Unit2');

1411: if l_system_type_cd2 = l_system_type_cd3 then
1412: -- we have duplicate lookup code for PC budget, so error message
1413: --
1414: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1415: hr_utility.set_message_token('UNIT_ONE','Unit2');
1416: hr_utility.set_message_token('UNIT_TWO','Unit3');
1417: hr_utility.raise_error;
1418: --
1419:

Line 1416: hr_utility.set_message_token('UNIT_TWO','Unit3');

1412: -- we have duplicate lookup code for PC budget, so error message
1413: --
1414: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1415: hr_utility.set_message_token('UNIT_ONE','Unit2');
1416: hr_utility.set_message_token('UNIT_TWO','Unit3');
1417: hr_utility.raise_error;
1418: --
1419:
1420: end if; -- end compare the system_type_cd for PC budget

Line 1417: hr_utility.raise_error;

1413: --
1414: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1415: hr_utility.set_message_token('UNIT_ONE','Unit2');
1416: hr_utility.set_message_token('UNIT_TWO','Unit3');
1417: hr_utility.raise_error;
1418: --
1419:
1420: end if; -- end compare the system_type_cd for PC budget
1421: end if; -- p_position_control_flag is Y

Line 1432: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');

1428: if p_budget_unit3_id IS NOT NULL and p_budget_unit1_id IS NOT NULL then
1429: if p_budget_unit3_id = p_budget_unit1_id then
1430: -- we have duplicate so error message
1431: --
1432: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');
1433: hr_utility.raise_error;
1434: --
1435:
1436: end if;

Line 1433: hr_utility.raise_error;

1429: if p_budget_unit3_id = p_budget_unit1_id then
1430: -- we have duplicate so error message
1431: --
1432: hr_utility.set_message(8302,'PQH_DUPLICATE_UOM');
1433: hr_utility.raise_error;
1434: --
1435:
1436: end if;
1437:

Line 1452: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');

1448: -- compare the system_type_cd
1449: if l_system_type_cd3 = l_system_type_cd1 then
1450: -- we have duplicate lookup code for PC budget, so error message
1451: --
1452: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1453: hr_utility.set_message_token('UNIT_ONE','Unit1');
1454: hr_utility.set_message_token('UNIT_TWO','Unit3');
1455: hr_utility.raise_error;
1456: --

Line 1453: hr_utility.set_message_token('UNIT_ONE','Unit1');

1449: if l_system_type_cd3 = l_system_type_cd1 then
1450: -- we have duplicate lookup code for PC budget, so error message
1451: --
1452: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1453: hr_utility.set_message_token('UNIT_ONE','Unit1');
1454: hr_utility.set_message_token('UNIT_TWO','Unit3');
1455: hr_utility.raise_error;
1456: --
1457:

Line 1454: hr_utility.set_message_token('UNIT_TWO','Unit3');

1450: -- we have duplicate lookup code for PC budget, so error message
1451: --
1452: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1453: hr_utility.set_message_token('UNIT_ONE','Unit1');
1454: hr_utility.set_message_token('UNIT_TWO','Unit3');
1455: hr_utility.raise_error;
1456: --
1457:
1458: end if; -- end compare the system_type_cd for PC budget

Line 1455: hr_utility.raise_error;

1451: --
1452: hr_utility.set_message(8302,'PQH_DUP_SYSTEM_TYPE_CD');
1453: hr_utility.set_message_token('UNIT_ONE','Unit1');
1454: hr_utility.set_message_token('UNIT_TWO','Unit3');
1455: hr_utility.raise_error;
1456: --
1457:
1458: end if; -- end compare the system_type_cd for PC budget
1459: end if; -- p_position_control_flag is Y

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

1461:
1462: end if; -- either is null so no compare
1463:
1464: --
1465: hr_utility.set_location('Leaving:'||l_proc,10);
1466: --
1467: end chk_budget_unit_id;
1468:
1469: --

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

1484: and budget_id <> nvl(p_budget_id,0);
1485:
1486: Begin
1487: --
1488: hr_utility.set_location('Entering:'||l_proc, 5);
1489: --
1490: open csr_budget_name;
1491: fetch csr_budget_name into l_dummy;
1492: close csr_budget_name;

Line 1496: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_NAME');

1492: close csr_budget_name;
1493:
1494: if nvl(l_dummy ,'Y') = 'X' then
1495: --
1496: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_NAME');
1497: hr_utility.raise_error;
1498: --
1499: end if;
1500:

Line 1497: hr_utility.raise_error;

1493:
1494: if nvl(l_dummy ,'Y') = 'X' then
1495: --
1496: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_NAME');
1497: hr_utility.raise_error;
1498: --
1499: end if;
1500:
1501: --

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

1498: --
1499: end if;
1500:
1501: --
1502: hr_utility.set_location('Leaving:'||l_proc,10);
1503: --
1504: end chk_budget_name;
1505:
1506: --

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

1527:
1528: --
1529: Begin
1530: --
1531: hr_utility.set_location('Entering:'||l_proc, 5);
1532: --
1533: l_api_updating := pqh_bgt_shd.api_updating
1534: (p_budget_id => p_budget_id,
1535: p_object_version_number => p_object_version_number);

Line 1558: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1554: p_effective_date => p_effective_date) then
1555: --
1556: -- raise error as does not exist as lookup
1557: --
1558: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1559: hr_utility.raise_error;
1560: --
1561: end if; -- invalid lookup
1562: --

Line 1559: hr_utility.raise_error;

1555: --
1556: -- raise error as does not exist as lookup
1557: --
1558: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1559: hr_utility.raise_error;
1560: --
1561: end if; -- invalid lookup
1562: --
1563: -- check if value is valid

Line 1571: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');

1567: (p_budget_unit1_id is null and p_budget_unit1_aggregate is not null )then
1568: --
1569: -- invalid values
1570: --
1571: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');
1572: hr_utility.raise_error;
1573: --
1574:
1575: end if; -- both null or not null

Line 1572: hr_utility.raise_error;

1568: --
1569: -- invalid values
1570: --
1571: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');
1572: hr_utility.raise_error;
1573: --
1574:
1575: end if; -- both null or not null
1576: --

Line 1588: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');

1584: if l_uom_cd = 'MONEY' and p_budget_unit1_aggregate <> 'ACCUMULATE' then
1585: --
1586: -- invalid values
1587: --
1588: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1589: hr_utility.set_message_token('UOM',l_shared_type_name);
1590: hr_utility.raise_error;
1591: --
1592: end if; -- invalid aggregate value for money

Line 1589: hr_utility.set_message_token('UOM',l_shared_type_name);

1585: --
1586: -- invalid values
1587: --
1588: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1589: hr_utility.set_message_token('UOM',l_shared_type_name);
1590: hr_utility.raise_error;
1591: --
1592: end if; -- invalid aggregate value for money
1593: end if; -- p_budget_unit1_id is not null

Line 1590: hr_utility.raise_error;

1586: -- invalid values
1587: --
1588: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1589: hr_utility.set_message_token('UOM',l_shared_type_name);
1590: hr_utility.raise_error;
1591: --
1592: end if; -- invalid aggregate value for money
1593: end if; -- p_budget_unit1_id is not null
1594:

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

1593: end if; -- p_budget_unit1_id is not null
1594:
1595: end if;
1596: --
1597: hr_utility.set_location('Leaving:'||l_proc,10);
1598: --
1599: end chk_budget_unit1_aggregate;
1600: --
1601: --

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

1622:
1623: --
1624: Begin
1625: --
1626: hr_utility.set_location('Entering:'||l_proc, 5);
1627: --
1628: l_api_updating := pqh_bgt_shd.api_updating
1629: (p_budget_id => p_budget_id,
1630: p_object_version_number => p_object_version_number);

Line 1653: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1649: p_effective_date => p_effective_date) then
1650: --
1651: -- raise error as does not exist as lookup
1652: --
1653: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1654: hr_utility.raise_error;
1655: --
1656: end if; -- invalid lookup
1657: --

Line 1654: hr_utility.raise_error;

1650: --
1651: -- raise error as does not exist as lookup
1652: --
1653: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1654: hr_utility.raise_error;
1655: --
1656: end if; -- invalid lookup
1657: --
1658: -- check if value is valid

Line 1666: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');

1662: (p_budget_unit2_id is null and p_budget_unit2_aggregate is not null )then
1663: --
1664: -- invalid values
1665: --
1666: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');
1667: hr_utility.raise_error;
1668: --
1669:
1670: end if; -- both null or not null

Line 1667: hr_utility.raise_error;

1663: --
1664: -- invalid values
1665: --
1666: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');
1667: hr_utility.raise_error;
1668: --
1669:
1670: end if; -- both null or not null
1671: --

Line 1683: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');

1679: if l_uom_cd = 'MONEY' and p_budget_unit2_aggregate <> 'ACCUMULATE' then
1680: --
1681: -- invalid values
1682: --
1683: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1684: hr_utility.set_message_token('UOM',l_shared_type_name);
1685: hr_utility.raise_error;
1686: --
1687: end if; -- invalid aggregate value for money

Line 1684: hr_utility.set_message_token('UOM',l_shared_type_name);

1680: --
1681: -- invalid values
1682: --
1683: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1684: hr_utility.set_message_token('UOM',l_shared_type_name);
1685: hr_utility.raise_error;
1686: --
1687: end if; -- invalid aggregate value for money
1688: end if; -- p_budget_unit2_id is not null

Line 1685: hr_utility.raise_error;

1681: -- invalid values
1682: --
1683: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1684: hr_utility.set_message_token('UOM',l_shared_type_name);
1685: hr_utility.raise_error;
1686: --
1687: end if; -- invalid aggregate value for money
1688: end if; -- p_budget_unit2_id is not null
1689:

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

1692:
1693:
1694: end if;
1695: --
1696: hr_utility.set_location('Leaving:'||l_proc,10);
1697: --
1698: end chk_budget_unit2_aggregate;
1699: --
1700: --

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

1721:
1722: --
1723: Begin
1724: --
1725: hr_utility.set_location('Entering:'||l_proc, 5);
1726: --
1727: l_api_updating := pqh_bgt_shd.api_updating
1728: (p_budget_id => p_budget_id,
1729: p_object_version_number => p_object_version_number);

Line 1752: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1748: p_effective_date => p_effective_date) then
1749: --
1750: -- raise error as does not exist as lookup
1751: --
1752: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1753: hr_utility.raise_error;
1754: --
1755: end if; -- invalid lookup
1756: --

Line 1753: hr_utility.raise_error;

1749: --
1750: -- raise error as does not exist as lookup
1751: --
1752: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1753: hr_utility.raise_error;
1754: --
1755: end if; -- invalid lookup
1756: --
1757: -- check if value is valid

Line 1765: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');

1761: (p_budget_unit3_id is null and p_budget_unit3_aggregate is not null )then
1762: --
1763: -- invalid values
1764: --
1765: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');
1766: hr_utility.raise_error;
1767: --
1768:
1769: end if; -- both null or not null

Line 1766: hr_utility.raise_error;

1762: --
1763: -- invalid values
1764: --
1765: hr_utility.set_message(8302,'PQH_INVALID_UNIT_AGGREGATE');
1766: hr_utility.raise_error;
1767: --
1768:
1769: end if; -- both null or not null
1770: --

Line 1782: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');

1778: if l_uom_cd = 'MONEY' and p_budget_unit3_aggregate <> 'ACCUMULATE' then
1779: --
1780: -- invalid values
1781: --
1782: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1783: hr_utility.set_message_token('UOM',l_shared_type_name);
1784: hr_utility.raise_error;
1785: --
1786: end if; -- invalid aggregate value for money

Line 1783: hr_utility.set_message_token('UOM',l_shared_type_name);

1779: --
1780: -- invalid values
1781: --
1782: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1783: hr_utility.set_message_token('UOM',l_shared_type_name);
1784: hr_utility.raise_error;
1785: --
1786: end if; -- invalid aggregate value for money
1787: end if; -- p_budget_unit3_id is not null

Line 1784: hr_utility.raise_error;

1780: -- invalid values
1781: --
1782: hr_utility.set_message(8302,'PQH_INVALID_AGGREGATE_VAL');
1783: hr_utility.set_message_token('UOM',l_shared_type_name);
1784: hr_utility.raise_error;
1785: --
1786: end if; -- invalid aggregate value for money
1787: end if; -- p_budget_unit3_id is not null
1788:

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

1791:
1792:
1793: end if;
1794: --
1795: hr_utility.set_location('Leaving:'||l_proc,10);
1796: --
1797: end chk_budget_unit3_aggregate;
1798: --
1799: -- ----------------------------------------------------------------------------

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

1810: l_api_updating boolean;
1811: --
1812: Begin
1813: --
1814: hr_utility.set_location('Entering:'||l_proc, 5);
1815: --
1816: l_api_updating := pqh_bgt_shd.api_updating
1817: (p_budget_id => p_budget_id,
1818: p_object_version_number => p_object_version_number);

Line 1835: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1831: p_effective_date => p_effective_date) then
1832: --
1833: -- raise error as does not exist as lookup
1834: --
1835: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1836: hr_utility.raise_error;
1837: --
1838: end if;
1839: --

Line 1836: hr_utility.raise_error;

1832: --
1833: -- raise error as does not exist as lookup
1834: --
1835: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1836: hr_utility.raise_error;
1837: --
1838: end if;
1839: --
1840: --

Line 1853: hr_utility.set_message(8302,'PQH_INVALID_BDGT_ENTITY');

1849: if NVL(p_budgeted_entity_cd,'X') <> 'POSITION' then
1850: --
1851: -- raise error
1852: --
1853: hr_utility.set_message(8302,'PQH_INVALID_BDGT_ENTITY');
1854: hr_utility.raise_error;
1855:
1856: end if;
1857: end if; -- pos ctl flag Y

Line 1854: hr_utility.raise_error;

1850: --
1851: -- raise error
1852: --
1853: hr_utility.set_message(8302,'PQH_INVALID_BDGT_ENTITY');
1854: hr_utility.raise_error;
1855:
1856: end if;
1857: end if; -- pos ctl flag Y
1858: --

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

1860: */
1861:
1862: end if;
1863: --
1864: hr_utility.set_location('Leaving:'||l_proc,10);
1865: --
1866: end chk_position_control_flag;
1867:
1868: --

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

1885: where a.currency_code = p_currency_code;
1886: --
1887: Begin
1888: --
1889: hr_utility.set_location('Entering:'||l_proc,5);
1890: --
1891: l_api_updating := pqh_bgt_shd.api_updating
1892: (p_budget_id => p_budget_id,
1893: p_object_version_number => p_object_version_number);

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

1918: close c1;
1919: --
1920: end if;
1921: --
1922: hr_utility.set_location('Leaving:'||l_proc,10);
1923: --
1924: End chk_currency_code;
1925:
1926: --

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

1961: l_api_updating boolean;
1962: --
1963: Begin
1964: --
1965: hr_utility.set_location('Entering:'||l_proc, 5);
1966: --
1967: l_api_updating := pqh_bgt_shd.api_updating
1968: (p_budget_id => p_budget_id,
1969: p_object_version_number => p_object_version_number);

Line 1976: hr_utility.set_location('check is being fired'||l_proc, 7);

1972: and (p_psb_budget_flag <> nvl(pqh_bgt_shd.g_old_rec.psb_budget_flag,hr_api.g_varchar2)
1973: or p_gl_budget_name <> nvl(pqh_bgt_shd.g_old_rec.gl_budget_name,hr_api.g_varchar2))
1974: or not l_api_updating)
1975: and p_psb_budget_flag is not null then
1976: hr_utility.set_location('check is being fired'||l_proc, 7);
1977: --
1978: -- check if value of lookup falls within lookup type.
1979: --
1980: if hr_api.not_exists_in_hr_lookups

Line 1987: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1983: p_effective_date => p_effective_date) then
1984: --
1985: -- raise error as does not exist as lookup
1986: --
1987: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1988: hr_utility.raise_error;
1989: --
1990: end if;
1991: --

Line 1988: hr_utility.raise_error;

1984: --
1985: -- raise error as does not exist as lookup
1986: --
1987: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1988: hr_utility.raise_error;
1989: --
1990: end if;
1991: --
1992: if NVL(p_psb_budget_flag,'N') = 'Y' AND p_gl_budget_name is NULL then

Line 1996: hr_utility.set_message(8302,'PQH_NOT_A_GL_BUDGET');

1992: if NVL(p_psb_budget_flag,'N') = 'Y' AND p_gl_budget_name is NULL then
1993: --
1994: -- raise error
1995: --
1996: hr_utility.set_message(8302,'PQH_NOT_A_GL_BUDGET');
1997: hr_utility.raise_error;
1998: end if;
1999: end if;
2000: --

Line 1997: hr_utility.raise_error;

1993: --
1994: -- raise error
1995: --
1996: hr_utility.set_message(8302,'PQH_NOT_A_GL_BUDGET');
1997: hr_utility.raise_error;
1998: end if;
1999: end if;
2000: --
2001: hr_utility.set_location('Leaving:'||l_proc,10);

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

1997: hr_utility.raise_error;
1998: end if;
1999: end if;
2000: --
2001: hr_utility.set_location('Leaving:'||l_proc,10);
2002: --
2003: end chk_psb_budget_flag;
2004:
2005: --

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

2012: --
2013: l_proc varchar2(72) := g_package||'insert_validate';
2014: --
2015: Begin
2016: hr_utility.set_location('Entering:'||l_proc, 5);
2017: --
2018: -- Call all supporting business operations
2019: --
2020: chk_budget_id

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

2155:
2156: --
2157: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2158: --
2159: hr_utility.set_location(' Leaving:'||l_proc, 10);
2160: End insert_validate;
2161: --
2162: -- ----------------------------------------------------------------------------
2163: -- |---------------------------< update_validate >----------------------------|

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

2167: --
2168: l_proc varchar2(72) := g_package||'update_validate';
2169: --
2170: Begin
2171: hr_utility.set_location('Entering:'||l_proc, 5);
2172: --
2173: -- Call all supporting business operations
2174: --
2175: chk_budget_id

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

2311: --
2312:
2313: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2314: --
2315: hr_utility.set_location(' Leaving:'||l_proc, 10);
2316: End update_validate;
2317: --
2318: -- ----------------------------------------------------------------------------
2319: -- |---------------------------< delete_validate >----------------------------|

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

2323: --
2324: l_proc varchar2(72) := g_package||'delete_validate';
2325: --
2326: Begin
2327: hr_utility.set_location('Entering:'||l_proc, 5);
2328: --
2329: -- Call all supporting business operations
2330: --
2331: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2327: hr_utility.set_location('Entering:'||l_proc, 5);
2328: --
2329: -- Call all supporting business operations
2330: --
2331: hr_utility.set_location(' Leaving:'||l_proc, 10);
2332: End delete_validate;
2333: --
2334: --
2335: -- ---------------------------------------------------------------------------

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

2354: l_proc varchar2(72) := g_package||'return_legislation_code';
2355: --
2356: begin
2357: --
2358: hr_utility.set_location('Entering:'|| l_proc, 10);
2359: --
2360: -- Ensure that all the mandatory parameter are not null
2361: --
2362: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2372: close csr_leg_code;
2373: --
2374: -- The primary key is invalid therefore we must error
2375: --
2376: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2377: hr_utility.raise_error;
2378: --
2379: end if;
2380: --

Line 2377: hr_utility.raise_error;

2373: --
2374: -- The primary key is invalid therefore we must error
2375: --
2376: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2377: hr_utility.raise_error;
2378: --
2379: end if;
2380: --
2381: close csr_leg_code;

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

2379: end if;
2380: --
2381: close csr_leg_code;
2382: --
2383: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2384: --
2385: return l_legislation_code;
2386: --
2387: end return_legislation_code;