eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_SEP_FORM_PKG dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Global Variables.
5: --
6: g_package varchar2(33) := 'pay_kr_sep_form_pkg.'; -- Global package name
7: g_debug boolean := hr_utility.debug_enabled;
8: g_old_rec pay_element_entries_f%ROWTYPE; -- Global record definition
9: g_run_type_id number;
10: g_run_type_name pay_run_types_f_tl.run_type_name%type;
11: g_entry_type varchar2(1) := 'E';

Line 165: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

161: argument12 => l_payout_date); -- Bug # 5559330
162: if p_req_id = 0 then
163: p_success := false;
164: fnd_message.retrieve(l_errbuf);
165: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
166: raise zero_req_id;
167: else
168: --
169: commit;

Line 193: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

189: when others then
190: p_success := false;
191: l_errbuf := sqlerrm;
192: errbuf := l_errbuf;
193: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
194: --
195: end process_run;
196: --------------------------------------------------------------------------------
197: procedure archive_run(p_business_group_id in number,

Line 241: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

237: argument11 => p_payroll_id_hd);
238: if p_req_id = 0 then
239: p_success := false;
240: fnd_message.retrieve(l_errbuf);
241: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
242: raise zero_req_id;
243: else
244: --
245: commit;

Line 269: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

265: when others then
266: p_success := false;
267: l_errbuf := sqlerrm;
268: errbuf := l_errbuf;
269: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
270: --
271: end archive_run;
272: --------------------------------------------------------------------------------
273: procedure delete_action(p_source_action_id in number,

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

304: open csr_assact;
305: fetch csr_assact into l_csr_assact;
306: if csr_assact%notfound then
307: close csr_assact;
308: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
309: hr_utility.raise_error;
310: end if;
311: close csr_assact;
312: --exception

Line 309: hr_utility.raise_error;

305: fetch csr_assact into l_csr_assact;
306: if csr_assact%notfound then
307: close csr_assact;
308: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
309: hr_utility.raise_error;
310: end if;
311: close csr_assact;
312: --exception
313: -- when others then

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

346: between pet.effective_start_date and pet.effective_end_date;
347: --
348: begin
349: if g_debug then
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: end if;
352:
353: open C_Sel1;
354: fetch C_Sel1 into l_entry_type,

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

354: fetch C_Sel1 into l_entry_type,
355: l_processing_type;
356: if C_Sel1%notfound then
357: Close C_Sel1;
358: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE', l_proc);
360: hr_utility.set_message_token('STEP','10');
361: hr_utility.raise_error;
362: end if;

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

355: l_processing_type;
356: if C_Sel1%notfound then
357: Close C_Sel1;
358: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE', l_proc);
360: hr_utility.set_message_token('STEP','10');
361: hr_utility.raise_error;
362: end if;
363: close C_Sel1;

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

356: if C_Sel1%notfound then
357: Close C_Sel1;
358: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE', l_proc);
360: hr_utility.set_message_token('STEP','10');
361: hr_utility.raise_error;
362: end if;
363: close C_Sel1;
364: --

Line 361: hr_utility.raise_error;

357: Close C_Sel1;
358: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE', l_proc);
360: hr_utility.set_message_token('STEP','10');
361: hr_utility.raise_error;
362: end if;
363: close C_Sel1;
364: --
365: if l_processing_type = 'N' or

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

383: p_update_change_insert => p_update_change_insert);
384: end if;
385: --
386: if g_debug then
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: end if;
389: end find_dt_upd_modes;
390: --------------------------------------------------------------------------------
391: procedure find_dt_del_modes(

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

424: between pet.effective_start_date and pet.effective_end_date;
425: --
426: begin
427: if g_debug then
428: hr_utility.set_location('Entering:'||l_proc, 5);
429: end if;
430:
431: open C_Sel1;
432: fetch C_Sel1 into l_parent_key_value1,

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

434: l_entry_type,
435: l_processing_type;
436: if C_Sel1%notfound then
437: close C_Sel1;
438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE', l_proc);
440: hr_utility.set_message_token('STEP','10');
441: hr_utility.raise_error;
442: end if;

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

435: l_processing_type;
436: if C_Sel1%notfound then
437: close C_Sel1;
438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE', l_proc);
440: hr_utility.set_message_token('STEP','10');
441: hr_utility.raise_error;
442: end if;
443: close C_Sel1;

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

436: if C_Sel1%notfound then
437: close C_Sel1;
438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE', l_proc);
440: hr_utility.set_message_token('STEP','10');
441: hr_utility.raise_error;
442: end if;
443: close C_Sel1;
444: --

Line 441: hr_utility.raise_error;

437: close C_Sel1;
438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE', l_proc);
440: hr_utility.set_message_token('STEP','10');
441: hr_utility.raise_error;
442: end if;
443: close C_Sel1;
444: --
445: if l_processing_type = 'N' or

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

469: p_delete_next_change => p_delete_next_change);
470: end if;
471: --
472: if g_debug then
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: end if;
475: end find_dt_del_modes;
476: --------------------------------------------------------------------------------
477: procedure lock_element_entry(

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

511: -- where hc.comment_id = g_old_rec.comment_id;
512: --
513: begin
514: if g_debug then
515: hr_utility.set_location('Entering:'||l_proc, 5);
516: end if;
517: --
518: -- Ensure that all the mandatory arguments are not null
519: --

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

545: close C_Sel1;
546: --
547: -- The primary key is invalid therefore we must error
548: --
549: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
550: hr_utility.raise_error;
551: --
552: end if;
553: close C_Sel1;

Line 550: hr_utility.raise_error;

546: --
547: -- The primary key is invalid therefore we must error
548: --
549: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
550: hr_utility.raise_error;
551: --
552: end if;
553: close C_Sel1;
554: --

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

555: -- Check if the set object version number is the same as the existing
556: -- object version number
557: --
558: if (p_object_version_number <> g_old_rec.object_version_number) Then
559: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
560: hr_utility.raise_error;
561: end if;
562: --
563: if g_debug then

Line 560: hr_utility.raise_error;

556: -- object version number
557: --
558: if (p_object_version_number <> g_old_rec.object_version_number) Then
559: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
560: hr_utility.raise_error;
561: end if;
562: --
563: if g_debug then
564: hr_utility.set_location(l_proc, 15);

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

560: hr_utility.raise_error;
561: end if;
562: --
563: if g_debug then
564: hr_utility.set_location(l_proc, 15);
565: end if;
566: --
567: -- Providing we are doing an update and a comment_id exists then
568: -- we select the comment text.

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

581: -- -- The comment_text for the specified comment_id does not exist.
582: -- -- We must error due to data integrity problems.
583: -- --
584: -- close C_Sel3;
585: -- hr_utility.set_message(801, 'HR_7202_COMMENT_TEXT_NOT_EXIST');
586: -- hr_utility.raise_error;
587: -- end if;
588: -- close C_Sel3;
589: -- end if;

Line 586: -- hr_utility.raise_error;

582: -- -- We must error due to data integrity problems.
583: -- --
584: -- close C_Sel3;
585: -- hr_utility.set_message(801, 'HR_7202_COMMENT_TEXT_NOT_EXIST');
586: -- hr_utility.raise_error;
587: -- end if;
588: -- close C_Sel3;
589: -- end if;
590: --

Line 595: hr_utility.set_location('Entering validation_dt_mode', 15);

591: -- Validate the datetrack mode mode getting the validation start
592: -- and end dates for the specified datetrack operation.
593: --
594: if g_debug then
595: hr_utility.set_location('Entering validation_dt_mode', 15);
596: end if;
597:
598: dt_api.validate_dt_mode(
599: p_effective_date => p_effective_date,

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

615: -- We are doing a datetrack 'INSERT' which is illegal within this
616: -- procedure therefore we must error (note: to lck on insert the
617: -- private procedure ins_lck should be called).
618: --
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','20');
622: hr_utility.raise_error;
623: --

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

616: -- procedure therefore we must error (note: to lck on insert the
617: -- private procedure ins_lck should be called).
618: --
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','20');
622: hr_utility.raise_error;
623: --
624: end If;

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

617: -- private procedure ins_lck should be called).
618: --
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','20');
622: hr_utility.raise_error;
623: --
624: end If;
625: --

Line 622: hr_utility.raise_error;

618: --
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE', l_proc);
621: hr_utility.set_message_token('STEP','20');
622: hr_utility.raise_error;
623: --
624: end If;
625: --
626: -- Set the validation start and end date OUT arguments

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

628: p_validation_start_date := l_validation_start_date;
629: p_validation_end_date := l_validation_end_date;
630: --
631: if g_debug then
632: hr_utility.set_location(' Leaving:'||l_proc, 30);
633: end if;
634: --
635: -- We need to trap the ORA LOCK exception
636: --

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

639: --
640: -- The object is locked therefore we need to supply a meaningful
641: -- error message.
642: --
643: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
644: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
645: hr_utility.raise_error;
646: when l_object_invalid then
647: --

Line 644: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');

640: -- The object is locked therefore we need to supply a meaningful
641: -- error message.
642: --
643: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
644: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
645: hr_utility.raise_error;
646: when l_object_invalid then
647: --
648: -- The object doesn't exist or is invalid

Line 645: hr_utility.raise_error;

641: -- error message.
642: --
643: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
644: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
645: hr_utility.raise_error;
646: when l_object_invalid then
647: --
648: -- The object doesn't exist or is invalid
649: --

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

646: when l_object_invalid then
647: --
648: -- The object doesn't exist or is invalid
649: --
650: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
651: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
652: hr_utility.raise_error;
653: end lock_element_entry;
654: --------------------------------------------------------------------------------

Line 651: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');

647: --
648: -- The object doesn't exist or is invalid
649: --
650: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
651: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
652: hr_utility.raise_error;
653: end lock_element_entry;
654: --------------------------------------------------------------------------------
655: procedure insert_element_entry(

Line 652: hr_utility.raise_error;

648: -- The object doesn't exist or is invalid
649: --
650: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
651: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
652: hr_utility.raise_error;
653: end lock_element_entry;
654: --------------------------------------------------------------------------------
655: procedure insert_element_entry(
656: p_validate in boolean,

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

1055: open csr_iv;
1056: fetch csr_iv into l_rec;
1057: if csr_iv%NOTFOUND then
1058: close csr_iv;
1059: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1060: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
1061: hr_utility.set_message_token('STEP','1');
1062: hr_utility.raise_error;
1063: end If;

Line 1060: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');

1056: fetch csr_iv into l_rec;
1057: if csr_iv%NOTFOUND then
1058: close csr_iv;
1059: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1060: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
1061: hr_utility.set_message_token('STEP','1');
1062: hr_utility.raise_error;
1063: end If;
1064: close csr_iv;

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

1057: if csr_iv%NOTFOUND then
1058: close csr_iv;
1059: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1060: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
1061: hr_utility.set_message_token('STEP','1');
1062: hr_utility.raise_error;
1063: end If;
1064: close csr_iv;
1065: --

Line 1062: hr_utility.raise_error;

1058: close csr_iv;
1059: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1060: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
1061: hr_utility.set_message_token('STEP','1');
1062: hr_utility.raise_error;
1063: end If;
1064: close csr_iv;
1065: --
1066: -- When user entered value is NULL.

Line 1077: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');

1073: --
1074: -- When not hot defaulted.
1075: --
1076: if l_rec.hot_default_flag = 'N' then
1077: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');
1078: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
1079: hr_utility.raise_error;
1080: --
1081: -- When hot defaulted.

Line 1078: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);

1074: -- When not hot defaulted.
1075: --
1076: if l_rec.hot_default_flag = 'N' then
1077: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');
1078: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
1079: hr_utility.raise_error;
1080: --
1081: -- When hot defaulted.
1082: --

Line 1079: hr_utility.raise_error;

1075: --
1076: if l_rec.hot_default_flag = 'N' then
1077: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');
1078: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
1079: hr_utility.raise_error;
1080: --
1081: -- When hot defaulted.
1082: --
1083: else

Line 1085: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');

1081: -- When hot defaulted.
1082: --
1083: else
1084: if l_rec.default_value is NULL then
1085: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');
1086: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
1087: hr_utility.raise_error;
1088: else
1089: p_canonical_value := l_rec.default_value;

Line 1086: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);

1082: --
1083: else
1084: if l_rec.default_value is NULL then
1085: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');
1086: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
1087: hr_utility.raise_error;
1088: else
1089: p_canonical_value := l_rec.default_value;
1090: hr_chkfmt.changeformat(

Line 1087: hr_utility.raise_error;

1083: else
1084: if l_rec.default_value is NULL then
1085: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');
1086: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
1087: hr_utility.raise_error;
1088: else
1089: p_canonical_value := l_rec.default_value;
1090: hr_chkfmt.changeformat(
1091: input => p_canonical_value,

Line 1124: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');

1120: -- In case the value input is incorrect format.
1121: --
1122: when others then
1123: l_d_uom := hr_general.decode_lookup('UNITS',l_rec.uom);
1124: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');
1125: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);
1126: hr_utility.raise_error;
1127: end;
1128: --

Line 1125: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);

1121: --
1122: when others then
1123: l_d_uom := hr_general.decode_lookup('UNITS',l_rec.uom);
1124: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');
1125: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);
1126: hr_utility.raise_error;
1127: end;
1128: --
1129: -- Format min_value and max_value for output parameters.

Line 1126: hr_utility.raise_error;

1122: when others then
1123: l_d_uom := hr_general.decode_lookup('UNITS',l_rec.uom);
1124: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');
1125: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);
1126: hr_utility.raise_error;
1127: end;
1128: --
1129: -- Format min_value and max_value for output parameters.
1130: -- These parameters should be used for message only.

Line 1152: hr_utility.set_message(801,'PAY_6303_INPUT_VALUE_OUT_RANGE');

1148: -- then raise error. In case of 'W'(Warning), Forms should warn to user
1149: -- with fnd_message.warn procedure.
1150: --
1151: if l_min_max_status = 'F' and l_rec.warning_or_error = 'E' then
1152: hr_utility.set_message(801,'PAY_6303_INPUT_VALUE_OUT_RANGE');
1153: hr_utility.raise_error;
1154: end If;
1155: --
1156: -- Execute formula validation.

Line 1153: hr_utility.raise_error;

1149: -- with fnd_message.warn procedure.
1150: --
1151: if l_min_max_status = 'F' and l_rec.warning_or_error = 'E' then
1152: hr_utility.set_message(801,'PAY_6303_INPUT_VALUE_OUT_RANGE');
1153: hr_utility.raise_error;
1154: end If;
1155: --
1156: -- Execute formula validation.
1157: --

Line 1174: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1170: -- then raise error. In case of 'W'(Warning), Forms should warn to user
1171: -- with fnd_message.warn procedure.
1172: --
1173: if l_formula_status = 'E' and l_rec.warning_or_error = 'E' then
1174: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1175: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);
1176: hr_utility.raise_error;
1177: end If;
1178: --

Line 1175: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);

1171: -- with fnd_message.warn procedure.
1172: --
1173: if l_formula_status = 'E' and l_rec.warning_or_error = 'E' then
1174: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1175: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);
1176: hr_utility.raise_error;
1177: end If;
1178: --
1179: -- In case lookup_type validation is applied.

Line 1176: hr_utility.raise_error;

1172: --
1173: if l_formula_status = 'E' and l_rec.warning_or_error = 'E' then
1174: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1175: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);
1176: hr_utility.raise_error;
1177: end If;
1178: --
1179: -- In case lookup_type validation is applied.
1180: --

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

1185: if hr_api.not_exists_in_hr_lookups(
1186: p_effective_date => p_effective_date,
1187: p_lookup_type => l_rec.lookup_type,
1188: p_lookup_code => p_canonical_value) then
1189: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');
1190: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);
1191: hr_utility.raise_error;
1192: end if;
1193: end if;

Line 1190: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);

1186: p_effective_date => p_effective_date,
1187: p_lookup_type => l_rec.lookup_type,
1188: p_lookup_code => p_canonical_value) then
1189: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');
1190: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);
1191: hr_utility.raise_error;
1192: end if;
1193: end if;
1194: end if;

Line 1191: hr_utility.raise_error;

1187: p_lookup_type => l_rec.lookup_type,
1188: p_lookup_code => p_canonical_value) then
1189: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');
1190: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);
1191: hr_utility.raise_error;
1192: end if;
1193: end if;
1194: end if;
1195: --

Line 1888: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');

1884: p_element_type_id => p_element_type_id,
1885: p_session_date => p_effective_date);
1886: --
1887: if p_element_link_id is null then
1888: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');
1889: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(p_effective_date));
1890: hr_utility.raise_error;
1891: end if;
1892: --

Line 1889: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(p_effective_date));

1885: p_session_date => p_effective_date);
1886: --
1887: if p_element_link_id is null then
1888: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');
1889: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(p_effective_date));
1890: hr_utility.raise_error;
1891: end if;
1892: --
1893: chk_entry(

Line 1890: hr_utility.raise_error;

1886: --
1887: if p_element_link_id is null then
1888: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');
1889: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(p_effective_date));
1890: hr_utility.raise_error;
1891: end if;
1892: --
1893: chk_entry(
1894: p_element_entry_id => NULL,