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

Line 57: hr_utility.set_location (l_package_name,1);

53: l_dummy varchar2(100);
54:
55: BEGIN
56:
57: hr_utility.set_location (l_package_name,1);
58:
59: BEGIN
60: hr_chkfmt.checkformat (l_name,
61: 'PAY_NAME',

Line 63: hr_utility.set_location (l_package_name,2);

59: BEGIN
60: hr_chkfmt.checkformat (l_name,
61: 'PAY_NAME',
62: l_dummy, null, null, 'N', l_dummy, null);
63: hr_utility.set_location (l_package_name,2);
64:
65: EXCEPTION
66: when app_exception.application_exception then
67: hr_utility.set_location (l_package_name,3);

Line 67: hr_utility.set_location (l_package_name,3);

63: hr_utility.set_location (l_package_name,2);
64:
65: EXCEPTION
66: when app_exception.application_exception then
67: hr_utility.set_location (l_package_name,3);
68: fnd_message.set_name ('PAY','PAY_6365_ELEMENT_NO_DB_NAME'); -- checkformat failure
69: fnd_message.raise_error;
70: END;
71:

Line 72: hr_utility.set_location (l_package_name,10);

68: fnd_message.set_name ('PAY','PAY_6365_ELEMENT_NO_DB_NAME'); -- checkformat failure
69: fnd_message.raise_error;
70: END;
71:
72: hr_utility.set_location (l_package_name,10);
73: OPEN c_translation(language, input_name, input_value_id);
74: hr_utility.set_location (l_package_name,20);
75: FETCH c_translation INTO g_dummy;
76:

Line 74: hr_utility.set_location (l_package_name,20);

70: END;
71:
72: hr_utility.set_location (l_package_name,10);
73: OPEN c_translation(language, input_name, input_value_id);
74: hr_utility.set_location (l_package_name,20);
75: FETCH c_translation INTO g_dummy;
76:
77: IF c_translation%NOTFOUND THEN
78: hr_utility.set_location (l_package_name,30);

Line 78: hr_utility.set_location (l_package_name,30);

74: hr_utility.set_location (l_package_name,20);
75: FETCH c_translation INTO g_dummy;
76:
77: IF c_translation%NOTFOUND THEN
78: hr_utility.set_location (l_package_name,30);
79: CLOSE c_translation;
80: ELSE
81: hr_utility.set_location (l_package_name,40);
82: CLOSE c_translation;

Line 81: hr_utility.set_location (l_package_name,40);

77: IF c_translation%NOTFOUND THEN
78: hr_utility.set_location (l_package_name,30);
79: CLOSE c_translation;
80: ELSE
81: hr_utility.set_location (l_package_name,40);
82: CLOSE c_translation;
83: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
84: fnd_message.raise_error;
85: END IF;

Line 86: hr_utility.set_location ('Leaving: '||l_package_name,60);

82: CLOSE c_translation;
83: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
84: fnd_message.raise_error;
85: END IF;
86: hr_utility.set_location ('Leaving: '||l_package_name,60);
87:
88: END validate_translation;
89:
90:

Line 124: hr_utility.set_message (801, 'PAY_INPVAL_MUST_HAVE_DEFAULT');

120: v_no_default := csr_link%found;
121: close csr_link;
122:
123: if p_error_if_true and v_no_default then
124: hr_utility.set_message (801, 'PAY_INPVAL_MUST_HAVE_DEFAULT');
125: hr_utility.raise_error;
126: end if;
127:
128: return v_no_default;

Line 125: hr_utility.raise_error;

121: close csr_link;
122:
123: if p_error_if_true and v_no_default then
124: hr_utility.set_message (801, 'PAY_INPVAL_MUST_HAVE_DEFAULT');
125: hr_utility.raise_error;
126: end if;
127:
128: return v_no_default;
129:

Line 162: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ELEMENT_ENTRY_NEEDS_DEFAULT',1);

158: v_hot_default_required boolean := FALSE;
159: --
160: begin
161: --
162: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ELEMENT_ENTRY_NEEDS_DEFAULT',1);
163: --
164: open csr_hot_defaulted_entry;
165: fetch csr_hot_defaulted_entry into g_dummy;
166: v_hot_default_required := csr_hot_defaulted_entry%found;

Line 170: hr_utility.set_message (801,'PAY_6191_INPVAL_NO_ENTRY_DEFS');

166: v_hot_default_required := csr_hot_defaulted_entry%found;
167: close csr_hot_defaulted_entry;
168: --
169: if p_error_if_true and v_hot_default_required then
170: hr_utility.set_message (801,'PAY_6191_INPVAL_NO_ENTRY_DEFS');
171: hr_utility.raise_error;
172: end if;
173: --
174: return v_hot_default_required;

Line 171: hr_utility.raise_error;

167: close csr_hot_defaulted_entry;
168: --
169: if p_error_if_true and v_hot_default_required then
170: hr_utility.set_message (801,'PAY_6191_INPVAL_NO_ENTRY_DEFS');
171: hr_utility.raise_error;
172: end if;
173: --
174: return v_hot_default_required;
175: --

Line 205: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.cant_delete_all_input_values',1);

201: v_protected_row_exists boolean := FALSE;
202: --
203: begin
204: --
205: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.cant_delete_all_input_values',1);
206: --
207: <>
208: for fetched_input_value in csr_input_values LOOP
209: --

Line 261: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.RUN_RESULT_VALUE_EXISTS',1);

257: and p_validation_end_date);
258: --
259: begin
260: --
261: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.RUN_RESULT_VALUE_EXISTS',1);
262: open csr_value;
263: fetch csr_value into g_dummy;
264: v_value_exists := csr_value%found;
265: close csr_value;

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

264: v_value_exists := csr_value%found;
265: close csr_value;
266: --
267: if v_value_exists and p_error_if_true then
268: hr_utility.set_message (801,'PAY_6212_INPVAL_NO_RR_DEL');
269: hr_utility.raise_error;
270: end if;
271: --
272: return v_value_exists;

Line 269: hr_utility.raise_error;

265: close csr_value;
266: --
267: if v_value_exists and p_error_if_true then
268: hr_utility.set_message (801,'PAY_6212_INPVAL_NO_RR_DEL');
269: hr_utility.raise_error;
270: end if;
271: --
272: return v_value_exists;
273: --

Line 296: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.BACKPAY_RULE_EXISTS',1);

292: where input_value_id = p_input_value_id;
293: --
294: begin
295: --
296: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.BACKPAY_RULE_EXISTS',1);
297: open csr_backpay_rules;
298: fetch csr_backpay_rules into g_dummy;
299: v_backpay_rules_exist := csr_backpay_rules%found;
300: close csr_backpay_rules;

Line 303: hr_utility.set_message (801,'PAY_6215_INPVAL_NO_DEL_BP');

299: v_backpay_rules_exist := csr_backpay_rules%found;
300: close csr_backpay_rules;
301: --
302: if v_backpay_rules_exist and p_error_if_true then
303: hr_utility.set_message (801,'PAY_6215_INPVAL_NO_DEL_BP');
304: hr_utility.raise_error;
305: end if;
306: --
307: return v_backpay_rules_exist;

Line 304: hr_utility.raise_error;

300: close csr_backpay_rules;
301: --
302: if v_backpay_rules_exist and p_error_if_true then
303: hr_utility.set_message (801,'PAY_6215_INPVAL_NO_DEL_BP');
304: hr_utility.raise_error;
305: end if;
306: --
307: return v_backpay_rules_exist;
308: --

Line 338: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ABSENCE_EXISTS',1);

334: and p_validation_end_date;
335: --
336: begin
337: --
338: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ABSENCE_EXISTS',1);
339: open csr_orphans;
340: fetch csr_orphans into g_dummy;
341: v_orphans_exist := csr_orphans%found;
342: close csr_orphans;

Line 345: hr_utility.set_message (801,'PAY_6214_INPVAL_NO_ABS_DEL');

341: v_orphans_exist := csr_orphans%found;
342: close csr_orphans;
343: --
344: if v_orphans_exist and p_error_if_true then
345: hr_utility.set_message (801,'PAY_6214_INPVAL_NO_ABS_DEL');
346: hr_utility.raise_error;
347: end if;
348: --
349: return v_orphans_exist;

Line 346: hr_utility.raise_error;

342: close csr_orphans;
343: --
344: if v_orphans_exist and p_error_if_true then
345: hr_utility.set_message (801,'PAY_6214_INPVAL_NO_ABS_DEL');
346: hr_utility.raise_error;
347: end if;
348: --
349: return v_orphans_exist;
350: --

Line 378: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ELEMENT_ENTRY_VALUE_EXISTS',1);

374: and effective_start_date <= p_validation_end_date
375: and effective_end_date >= p_validation_start_date;
376: --
377: begin
378: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ELEMENT_ENTRY_VALUE_EXISTS',1);
379: hr_utility.trace ('p_input_value_id = '||to_char(p_input_value_id));
380: hr_utility.trace ('p_val_start = '||p_validation_start_date);
381: hr_utility.trace ('p_val_end = '||p_validation_end_date);
382: --

Line 379: hr_utility.trace ('p_input_value_id = '||to_char(p_input_value_id));

375: and effective_end_date >= p_validation_start_date;
376: --
377: begin
378: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ELEMENT_ENTRY_VALUE_EXISTS',1);
379: hr_utility.trace ('p_input_value_id = '||to_char(p_input_value_id));
380: hr_utility.trace ('p_val_start = '||p_validation_start_date);
381: hr_utility.trace ('p_val_end = '||p_validation_end_date);
382: --
383: open csr_entries;

Line 380: hr_utility.trace ('p_val_start = '||p_validation_start_date);

376: --
377: begin
378: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ELEMENT_ENTRY_VALUE_EXISTS',1);
379: hr_utility.trace ('p_input_value_id = '||to_char(p_input_value_id));
380: hr_utility.trace ('p_val_start = '||p_validation_start_date);
381: hr_utility.trace ('p_val_end = '||p_validation_end_date);
382: --
383: open csr_entries;
384: fetch csr_entries into g_dummy;

Line 381: hr_utility.trace ('p_val_end = '||p_validation_end_date);

377: begin
378: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ELEMENT_ENTRY_VALUE_EXISTS',1);
379: hr_utility.trace ('p_input_value_id = '||to_char(p_input_value_id));
380: hr_utility.trace ('p_val_start = '||p_validation_start_date);
381: hr_utility.trace ('p_val_end = '||p_validation_end_date);
382: --
383: open csr_entries;
384: fetch csr_entries into g_dummy;
385: v_entries_exist := csr_entries%found;

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

385: v_entries_exist := csr_entries%found;
386: close csr_entries;
387: --
388: if v_entries_exist and p_error_if_true then
389: hr_utility.set_message (801,'PAY_6211_INPVAL_NO_DEL_ENTRY');
390: hr_utility.raise_error;
391: end if;
392: --
393: return v_entries_exist;

Line 390: hr_utility.raise_error;

386: close csr_entries;
387: --
388: if v_entries_exist and p_error_if_true then
389: hr_utility.set_message (801,'PAY_6211_INPVAL_NO_DEL_ENTRY');
390: hr_utility.raise_error;
391: end if;
392: --
393: return v_entries_exist;
394: --

Line 423: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.RESULT_RULE_EXISTS',1);

419: and effective_start_date <= p_validation_end_date
420: and effective_end_date >= p_validation_start_date;
421: --
422: begin
423: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.RESULT_RULE_EXISTS',1);
424: --
425: open csr_orphans;
426: fetch csr_orphans into g_dummy;
427: v_orphans_exist := csr_orphans%found;

Line 431: hr_utility.set_message (801,'PAY_6213_INPVAL_NO_FRR_DEL');

427: v_orphans_exist := csr_orphans%found;
428: close csr_orphans;
429: --
430: if v_orphans_exist and p_error_if_true then
431: hr_utility.set_message (801,'PAY_6213_INPVAL_NO_FRR_DEL');
432: hr_utility.raise_error;
433: end if;
434: --
435: return v_orphans_exist;

Line 432: hr_utility.raise_error;

428: close csr_orphans;
429: --
430: if v_orphans_exist and p_error_if_true then
431: hr_utility.set_message (801,'PAY_6213_INPVAL_NO_FRR_DEL');
432: hr_utility.raise_error;
433: end if;
434: --
435: return v_orphans_exist;
436: --

Line 465: hr_utility.set_message(801,'PAY_6965_INPVAL_NO_DEL_SB');

461: close csr_pay_basis;
462: --
463: if v_pay_basis_input_value and p_error_if_true then
464: --
465: hr_utility.set_message(801,'PAY_6965_INPVAL_NO_DEL_SB');
466: hr_utility.raise_error;
467: --
468: end if;
469: --

Line 466: hr_utility.raise_error;

462: --
463: if v_pay_basis_input_value and p_error_if_true then
464: --
465: hr_utility.set_message(801,'PAY_6965_INPVAL_NO_DEL_SB');
466: hr_utility.raise_error;
467: --
468: end if;
469: --
470: return v_pay_basis_input_value;

Line 502: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DISTRIBUTED_COST_LINK_EXISTS',1);

498: and link.element_type_id = input.element_type_id
499: and link.costable_type = 'D';
500: --
501: begin
502: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DISTRIBUTED_COST_LINK_EXISTS',1);
503: --
504: open csr_links;
505: fetch csr_links into g_dummy;
506: v_links_exist := csr_links%found;

Line 510: hr_utility.set_message (801,'PAY_6210_INPVAL_NO_LINKS_DEL');

506: v_links_exist := csr_links%found;
507: close csr_links;
508: --
509: if v_links_exist and p_error_if_true then
510: hr_utility.set_message (801,'PAY_6210_INPVAL_NO_LINKS_DEL');
511: hr_utility.raise_error;
512: end if;
513: --
514: return v_links_exist;

Line 511: hr_utility.raise_error;

507: close csr_links;
508: --
509: if v_links_exist and p_error_if_true then
510: hr_utility.set_message (801,'PAY_6210_INPVAL_NO_LINKS_DEL');
511: hr_utility.raise_error;
512: end if;
513: --
514: return v_links_exist;
515: --

Line 540: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ASSIGNED_SALARY_BASE_EXISTS',1);

536: from per_pay_bases BASE
537: where base.input_value_id = p_input_value_id;
538: --
539: begin
540: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ASSIGNED_SALARY_BASE_EXISTS',1);
541: --
542: open csr_salary_base;
543: fetch csr_salary_base into g_dummy;
544: v_base_exists := csr_salary_base%found;

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

544: v_base_exists := csr_salary_base%found;
545: close csr_salary_base;
546: --
547: if v_base_exists and p_error_if_true then
548: hr_utility.set_message (801,'PAY_6965_INPVAL_NO_DEL_SB');
549: hr_utility.raise_error;
550: end if;
551: --
552: return v_base_exists;

Line 549: hr_utility.raise_error;

545: close csr_salary_base;
546: --
547: if v_base_exists and p_error_if_true then
548: hr_utility.set_message (801,'PAY_6965_INPVAL_NO_DEL_SB');
549: hr_utility.raise_error;
550: end if;
551: --
552: return v_base_exists;
553: --

Line 577: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.NET_CALCULATION_RULES_EXIST',1);

573: where input_value_id = p_input_value_id;
574: --
575: begin
576: --
577: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.NET_CALCULATION_RULES_EXIST',1);
578: --
579: open csr_calc_rule;
580: fetch csr_calc_rule into g_dummy;
581: v_calculation_exists := csr_calc_rule%found;

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

581: v_calculation_exists := csr_calc_rule%found;
582: close csr_calc_rule;
583: --
584: if v_calculation_exists and p_error_if_true then
585: hr_utility.set_message (801, 'PAY_35559_INPVAL_NO_DEL_CALC');
586: hr_utility.raise_error;
587: end if;
588: --
589: return v_calculation_exists;

Line 586: hr_utility.raise_error;

582: close csr_calc_rule;
583: --
584: if v_calculation_exists and p_error_if_true then
585: hr_utility.set_message (801, 'PAY_35559_INPVAL_NO_DEL_CALC');
586: hr_utility.raise_error;
587: end if;
588: --
589: return v_calculation_exists;
590: --

Line 616: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ACCRUAL_PLAN_EXISTS',1);

612: residual_input_value_id );
613: --
614: begin
615: --
616: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ACCRUAL_PLAN_EXISTS',1);
617: --
618: open csr_accrual_plan;
619: fetch csr_accrual_plan into g_dummy;
620: v_accrual_plan_exists := csr_accrual_plan%found;

Line 624: hr_utility.set_message (801,'PAY_35558_INPVAL_NO_DEL_ACCRUA');

620: v_accrual_plan_exists := csr_accrual_plan%found;
621: close csr_accrual_plan;
622: --
623: if v_accrual_plan_exists and p_error_if_true then
624: hr_utility.set_message (801,'PAY_35558_INPVAL_NO_DEL_ACCRUA');
625: hr_utility.raise_error;
626: end if;
627: --
628: return v_accrual_plan_exists;

Line 625: hr_utility.raise_error;

621: close csr_accrual_plan;
622: --
623: if v_accrual_plan_exists and p_error_if_true then
624: hr_utility.set_message (801,'PAY_35558_INPVAL_NO_DEL_ACCRUA');
625: hr_utility.raise_error;
626: end if;
627: --
628: return v_accrual_plan_exists;
629: --

Line 662: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.PARENT_DELETED',1);

658: where element_type_id = p_element_type_id
659: for update;
660: --
661: begin
662: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.PARENT_DELETED',1);
663: --
664: <>
665: FOR fetched_input_value in csr_all_inputs_for_element LOOP
666: --

Line 711: hr_utility.trace ('***** in DELETE_NEXT_CHANGE');

707: --
708: -- bugfix 1507600
709: -- only update peices date effective as of session date
710: --
711: hr_utility.trace ('***** in DELETE_NEXT_CHANGE');
712: hr_utility.trace ('***** ESD>' ||
713: fetched_input_value.effective_start_date || '<');
714: hr_utility.trace ('***** EED>' ||
715: fetched_input_value.effective_end_date || '<');

Line 712: hr_utility.trace ('***** ESD>' ||

708: -- bugfix 1507600
709: -- only update peices date effective as of session date
710: --
711: hr_utility.trace ('***** in DELETE_NEXT_CHANGE');
712: hr_utility.trace ('***** ESD>' ||
713: fetched_input_value.effective_start_date || '<');
714: hr_utility.trace ('***** EED>' ||
715: fetched_input_value.effective_end_date || '<');
716:

Line 714: hr_utility.trace ('***** EED>' ||

710: --
711: hr_utility.trace ('***** in DELETE_NEXT_CHANGE');
712: hr_utility.trace ('***** ESD>' ||
713: fetched_input_value.effective_start_date || '<');
714: hr_utility.trace ('***** EED>' ||
715: fetched_input_value.effective_end_date || '<');
716:
717: -- if p_session_date >= fetched_input_value.effective_start_date and
718: -- p_session_date <= fetched_input_value.effective_end_date then

Line 719: hr_utility.trace ('***** peice within ESD and EED');

715: fetched_input_value.effective_end_date || '<');
716:
717: -- if p_session_date >= fetched_input_value.effective_start_date and
718: -- p_session_date <= fetched_input_value.effective_end_date then
719: hr_utility.trace ('***** peice within ESD and EED');
720: hr_utility.trace ('***** ESD>' ||
721: fetched_input_value.effective_start_date || '<');
722: hr_utility.trace ('***** EED>' ||
723: fetched_input_value.effective_end_date || '<');

Line 720: hr_utility.trace ('***** ESD>' ||

716:
717: -- if p_session_date >= fetched_input_value.effective_start_date and
718: -- p_session_date <= fetched_input_value.effective_end_date then
719: hr_utility.trace ('***** peice within ESD and EED');
720: hr_utility.trace ('***** ESD>' ||
721: fetched_input_value.effective_start_date || '<');
722: hr_utility.trace ('***** EED>' ||
723: fetched_input_value.effective_end_date || '<');
724: --

Line 722: hr_utility.trace ('***** EED>' ||

718: -- p_session_date <= fetched_input_value.effective_end_date then
719: hr_utility.trace ('***** peice within ESD and EED');
720: hr_utility.trace ('***** ESD>' ||
721: fetched_input_value.effective_start_date || '<');
722: hr_utility.trace ('***** EED>' ||
723: fetched_input_value.effective_end_date || '<');
724: --
725: update pay_input_values_f
726: set effective_end_date = c_end_of_time

Line 761: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.RECREATE_DB_ITEMS',1);

757: where element_type_id = p_element_type_id
758: and generate_db_items_flag = 'Y'; -- Bug 6432304
759: --
760: begin
761: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.RECREATE_DB_ITEMS',1);
762: --
763: FOR fetched_input_value in csr_input_values LOOP
764: --
765: hrdyndbi.delete_input_value_dict (fetched_input_value.input_value_id);

Line 794: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETION_ALLOWED',1);

790:
791: v_deletion_allowed boolean := TRUE;
792:
793: begin
794: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETION_ALLOWED',1);
795:
796: if (p_delete_mode = 'ZAP'
797:
798: and (element_entry_value_exists ( p_input_value_id,

Line 881: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.NO_OF_INPUT_VALUES',1);

877: from pay_input_values_f
878: where element_type_id = p_element_type_id;
879: --
880: begin
881: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.NO_OF_INPUT_VALUES',1);
882: --
883: open csr_count_input_values;
884: fetch csr_count_input_values into v_no_of_input_values;
885: close csr_count_input_values;

Line 913: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DATE_EFFECTIVELY_UPDATED',1);

909: --
910: v_date_effectively_updated boolean := FALSE;
911: --
912: begin
913: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DATE_EFFECTIVELY_UPDATED',1);
914: --
915: open csr_dated_updates;
916: fetch csr_dated_updates into g_dummy;
917: v_date_effectively_updated := csr_dated_updates%found;

Line 951: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.NAME_NOT_UNIQUE',1);

947: and iv_tl.language = userenv('LANG')
948: and upper(iv_tl.name) = upper(p_name);
949: --
950: begin
951: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.NAME_NOT_UNIQUE',1);
952: --
953: if p_rowid is not null then
954: select input_value_id
955: into l_ivid

Line 968: hr_utility.set_message (801,'PAY_6168_INPVAL_DUP_NAME');

964: v_duplicate := csr_duplicate_name%found;
965: close csr_duplicate_name;
966: --
967: if v_duplicate and p_error_if_true then
968: hr_utility.set_message (801,'PAY_6168_INPVAL_DUP_NAME');
969: hr_utility.raise_error;
970: end if;
971: --
972: return v_duplicate;

Line 969: hr_utility.raise_error;

965: close csr_duplicate_name;
966: --
967: if v_duplicate and p_error_if_true then
968: hr_utility.set_message (801,'PAY_6168_INPVAL_DUP_NAME');
969: hr_utility.raise_error;
970: end if;
971: --
972: return v_duplicate;
973: --

Line 1001: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.MANDATORY_IN_FUTURE',1);

997: and mandatory_flag = 'Y'
998: and effective_start_date > p_session_date;
999: --
1000: begin
1001: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.MANDATORY_IN_FUTURE',1);
1002: open csr_mandatory_flag;
1003: fetch csr_mandatory_flag into g_dummy;
1004: v_mandatory_in_future := csr_mandatory_flag%found;
1005: close csr_mandatory_flag;

Line 1008: hr_utility.set_message(801,'PAY_6179_INPVAL_MAND_NO_CHANGE');

1004: v_mandatory_in_future := csr_mandatory_flag%found;
1005: close csr_mandatory_flag;
1006: --
1007: if p_error_if_true and v_mandatory_in_future then
1008: hr_utility.set_message(801,'PAY_6179_INPVAL_MAND_NO_CHANGE');
1009: hr_utility.raise_error;
1010: end if;
1011: --
1012: return v_mandatory_in_future;

Line 1009: hr_utility.raise_error;

1005: close csr_mandatory_flag;
1006: --
1007: if p_error_if_true and v_mandatory_in_future then
1008: hr_utility.set_message(801,'PAY_6179_INPVAL_MAND_NO_CHANGE');
1009: hr_utility.raise_error;
1010: end if;
1011: --
1012: return v_mandatory_in_future;
1013: --

Line 1102: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',1);

1098: --
1099: l_check_latest_balances boolean;
1100: --
1101: begin
1102: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',1);
1103: --
1104:
1105: -- change 115.12 - if p_name has not been specified then default it to
1106: -- p_base_name

Line 1116: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',2);

1112: open csr_next_id;
1113: fetch csr_next_id into p_input_value_id;
1114: close csr_next_id;
1115: --
1116: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',2);
1117: --
1118: if no_of_input_values (p_element_type_id) >= 15 then
1119:
1120: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',3);

Line 1120: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',3);

1116: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',2);
1117: --
1118: if no_of_input_values (p_element_type_id) >= 15 then
1119:
1120: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',3);
1121:
1122: hr_utility.set_message (801, 'HR_7124_INPVAL_MAX_ENTRIES');
1123: hr_utility.raise_error;
1124:

Line 1122: hr_utility.set_message (801, 'HR_7124_INPVAL_MAX_ENTRIES');

1118: if no_of_input_values (p_element_type_id) >= 15 then
1119:
1120: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',3);
1121:
1122: hr_utility.set_message (801, 'HR_7124_INPVAL_MAX_ENTRIES');
1123: hr_utility.raise_error;
1124:
1125: end if;
1126:

Line 1123: hr_utility.raise_error;

1119:
1120: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',3);
1121:
1122: hr_utility.set_message (801, 'HR_7124_INPVAL_MAX_ENTRIES');
1123: hr_utility.raise_error;
1124:
1125: end if;
1126:
1127: insert into pay_input_values_f (

Line 1195: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',4);

1191: c_login_id,
1192: sysdate,
1193: c_user_id);
1194: --
1195: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',4);
1196: --
1197: -- ***********************************************************************
1198: -- Insert into MLS table (TL)
1199: --

Line 1258: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',5);

1254:
1255: --
1256: -- ***********************************************************************
1257: --
1258: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',5);
1259: --
1260: open csr_input_value_rowid;
1261: fetch csr_input_value_rowid into p_rowid;
1262: --

Line 1375: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.update_row',1);

1371: ) is
1372: l_tl_name varchar2(255);
1373: --
1374: begin
1375: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.update_row',1);
1376: --
1377: update pay_input_values_f
1378: set INPUT_VALUE_ID = p_INPUT_VALUE_ID,
1379: EFFECTIVE_START_DATE = p_EFFECTIVE_START_DATE,

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

1437: where INPUT_VALUE_ID = P_INPUT_VALUE_ID
1438: and userenv('LANG') = LANGUAGE ; -- bug 6125295
1439: --
1440: if sql%notfound then -- trap system errors during update
1441: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1442: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UPDATE_TL_ROW');
1443: hr_utility.raise_error;
1444: end if;
1445: --

Line 1442: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UPDATE_TL_ROW');

1438: and userenv('LANG') = LANGUAGE ; -- bug 6125295
1439: --
1440: if sql%notfound then -- trap system errors during update
1441: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1442: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UPDATE_TL_ROW');
1443: hr_utility.raise_error;
1444: end if;
1445: --
1446: -- ************************************************************************

Line 1443: hr_utility.raise_error;

1439: --
1440: if sql%notfound then -- trap system errors during update
1441: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1442: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UPDATE_TL_ROW');
1443: hr_utility.raise_error;
1444: end if;
1445: --
1446: -- ************************************************************************
1447: --

Line 1483: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETE_ROW',1);

1479: default to_date ('31/12/4712','DD/MM/YYYY')
1480: ) is
1481: --
1482: begin
1483: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETE_ROW',1);
1484: --
1485: if deletion_allowed ( p_input_value_id,
1486: p_delete_mode,
1487: p_validation_start_date,

Line 1495: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETE_ROW',2);

1491: p_delete_mode,
1492: p_validation_start_date,
1493: p_validation_end_date );
1494: --
1495: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETE_ROW',2);
1496: --
1497: -- delete DB items
1498: hrdyndbi.delete_input_value_dict (p_input_value_id);
1499: --

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

1500: delete from pay_input_values_f
1501: where rowid = p_rowid;
1502: --
1503: if sql%notfound then
1504: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1505: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_ROW');
1506: hr_utility.raise_error;
1507: end if;
1508: --

Line 1505: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_ROW');

1501: where rowid = p_rowid;
1502: --
1503: if sql%notfound then
1504: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1505: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_ROW');
1506: hr_utility.raise_error;
1507: end if;
1508: --
1509: --

Line 1506: hr_utility.raise_error;

1502: --
1503: if sql%notfound then
1504: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1505: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_ROW');
1506: hr_utility.raise_error;
1507: end if;
1508: --
1509: --
1510: -- ****************************************************************************

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

1521: delete from PAY_INPUT_VALUES_F_TL
1522: where INPUT_VALUE_ID = P_INPUT_VALUE_ID;
1523: --
1524: if sql%notfound then -- trap system errors during deletion
1525: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1526: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_TL_ROW');
1527: hr_utility.raise_error;
1528: end if;
1529:

Line 1526: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_TL_ROW');

1522: where INPUT_VALUE_ID = P_INPUT_VALUE_ID;
1523: --
1524: if sql%notfound then -- trap system errors during deletion
1525: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1526: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_TL_ROW');
1527: hr_utility.raise_error;
1528: end if;
1529:
1530: end if;

Line 1527: hr_utility.raise_error;

1523: --
1524: if sql%notfound then -- trap system errors during deletion
1525: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1526: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_TL_ROW');
1527: hr_utility.raise_error;
1528: end if;
1529:
1530: end if;
1531: --

Line 1592: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.lock_row',1);

1588: --
1589: -- ****************************************************************
1590: --
1591: begin
1592: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.lock_row',1);
1593: --
1594: open csr_lock_input_value;
1595: fetch csr_lock_input_value into v_locked_row;
1596: if csr_lock_input_value%notfound then

Line 1618: -- hr_utility.set_message ('FND','FORM_RECORD_CHANGED');

1614: -- if ( (tlinfo.NAME = P_NAME)
1615: -- ) then
1616: -- null;
1617: -- else
1618: -- hr_utility.set_message ('FND','FORM_RECORD_CHANGED');
1619: -- hr_utility.raise_error;
1620: -- end if;
1621: -- end if;
1622: -- end loop;

Line 1619: -- hr_utility.raise_error;

1615: -- ) then
1616: -- null;
1617: -- else
1618: -- hr_utility.set_message ('FND','FORM_RECORD_CHANGED');
1619: -- hr_utility.raise_error;
1620: -- end if;
1621: -- end if;
1622: -- end loop;
1623: --

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

1622: -- end loop;
1623: --
1624: --
1625: -- if (v_mls_count=0) then -- Trap system errors
1626: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1627: -- hr_utility.set_message_token ('PROCEDURE','PAY_INPUT_VALUES_PKG.LOCK_TL_ROW');
1628: -- end if;
1629: --
1630: -- ************************************************************************

Line 1627: -- hr_utility.set_message_token ('PROCEDURE','PAY_INPUT_VALUES_PKG.LOCK_TL_ROW');

1623: --
1624: --
1625: -- if (v_mls_count=0) then -- Trap system errors
1626: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1627: -- hr_utility.set_message_token ('PROCEDURE','PAY_INPUT_VALUES_PKG.LOCK_TL_ROW');
1628: -- end if;
1629: --
1630: -- ************************************************************************
1631: --

Line 1657: hr_utility.set_message ('FND','FORM_RECORD_CHANGED');

1653: and ((V_LOCKED_ROW.MIN_VALUE = p_MIN_VALUE) OR (V_LOCKED_ROW.MIN_VALUE is null and p_MIN_VALUE is null))
1654: and ((V_LOCKED_ROW.WARNING_OR_ERROR = p_WARNING_OR_ERROR) OR (V_LOCKED_ROW.WARNING_OR_ERROR is null and p_WARNING_OR_ERROR is null)) then
1655: return;
1656: else
1657: hr_utility.set_message ('FND','FORM_RECORD_CHANGED');
1658: hr_utility.raise_error;
1659: end if;
1660: --
1661: end lock_row;

Line 1658: hr_utility.raise_error;

1654: and ((V_LOCKED_ROW.WARNING_OR_ERROR = p_WARNING_OR_ERROR) OR (V_LOCKED_ROW.WARNING_OR_ERROR is null and p_WARNING_OR_ERROR is null)) then
1655: return;
1656: else
1657: hr_utility.set_message ('FND','FORM_RECORD_CHANGED');
1658: hr_utility.raise_error;
1659: end if;
1660: --
1661: end lock_row;
1662: ---------------------------------------------------------------------------

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

1749: and X_I_EFFECTIVE_END_DATE is not NULL
1750: and I.BUSINESS_GROUP_ID is NULL;
1751: --
1752: IF (result>1) THEN
1753: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1754: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1755: hr_utility.set_message_token('STEP','1');
1756: hr_utility.raise_error;
1757: END IF;

Line 1754: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');

1750: and I.BUSINESS_GROUP_ID is NULL;
1751: --
1752: IF (result>1) THEN
1753: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1754: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1755: hr_utility.set_message_token('STEP','1');
1756: hr_utility.raise_error;
1757: END IF;
1758: EXCEPTION

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

1751: --
1752: IF (result>1) THEN
1753: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1754: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1755: hr_utility.set_message_token('STEP','1');
1756: hr_utility.raise_error;
1757: END IF;
1758: EXCEPTION
1759: when NO_DATA_FOUND then

Line 1756: hr_utility.raise_error;

1752: IF (result>1) THEN
1753: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1754: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1755: hr_utility.set_message_token('STEP','1');
1756: hr_utility.raise_error;
1757: END IF;
1758: EXCEPTION
1759: when NO_DATA_FOUND then
1760: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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

1756: hr_utility.raise_error;
1757: END IF;
1758: EXCEPTION
1759: when NO_DATA_FOUND then
1760: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1762: hr_utility.set_message_token('STEP','1');
1763: hr_utility.raise_error;
1764: end unique_chk;

Line 1761: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');

1757: END IF;
1758: EXCEPTION
1759: when NO_DATA_FOUND then
1760: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1762: hr_utility.set_message_token('STEP','1');
1763: hr_utility.raise_error;
1764: end unique_chk;
1765: --------------------------------------------------------------------------------

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

1758: EXCEPTION
1759: when NO_DATA_FOUND then
1760: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1762: hr_utility.set_message_token('STEP','1');
1763: hr_utility.raise_error;
1764: end unique_chk;
1765: --------------------------------------------------------------------------------
1766: procedure TRANSLATE_ROW (

Line 1763: hr_utility.raise_error;

1759: when NO_DATA_FOUND then
1760: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1762: hr_utility.set_message_token('STEP','1');
1763: hr_utility.raise_error;
1764: end unique_chk;
1765: --------------------------------------------------------------------------------
1766: procedure TRANSLATE_ROW (
1767: X_I_NAME in varchar2,