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 PAY_INPUT_VALUES_PKG

Line 1: package body PAY_INPUT_VALUES_PKG as

1: package body PAY_INPUT_VALUES_PKG as
2: /* $Header: pyipv.pkb 120.5 2007/10/25 12:44:40 ckesanap noship $ */
3: -- Declare global variables and cursors
4:
5: -- Dummy variable for selecting into when not interested in value of result

Line 51: l_package_name VARCHAR2(80) := 'PAY_INPUT_VALUES_PKG.VALIDATE_TRANSLATION';

47: AND inptl.language = p_language
48: AND (inp.input_value_id <> p_input_value_id OR p_input_value_id IS NULL)
49: AND inp.element_type_id = g_element_type_id;
50:
51: l_package_name VARCHAR2(80) := 'PAY_INPUT_VALUES_PKG.VALIDATE_TRANSLATION';
52: l_name pay_balance_types.balance_name%type := input_name;
53: l_dummy varchar2(100);
54:
55: BEGIN

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1273: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',5);

1269:
1270: --
1271: -- ***********************************************************************
1272: --
1273: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.insert_row',5);
1274: --
1275: open csr_input_value_rowid;
1276: fetch csr_input_value_rowid into p_rowid;
1277: --

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

1385: --
1386: ) is
1387: --
1388: begin
1389: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.update_row',1);
1390: --
1391: update pay_input_values_f
1392: set INPUT_VALUE_ID = p_INPUT_VALUE_ID,
1393: EFFECTIVE_START_DATE = p_EFFECTIVE_START_DATE,

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

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

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

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

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

1497: p_validation_end_date,
1498: p_delete_mode,
1499: 'PAY_INPUT_VALUES_F' );
1500: --
1501: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.DELETE_ROW',2);
1502: --
1503: -- delete DB items
1504: hrdyndbi.delete_input_value_dict (p_input_value_id);
1505: --

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

1507: where rowid = p_rowid;
1508: --
1509: if sql%notfound then
1510: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1511: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_ROW');
1512: hr_utility.raise_error;
1513: end if;
1514: --
1515: --

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

1528: where INPUT_VALUE_ID = P_INPUT_VALUE_ID;
1529: --
1530: if sql%notfound then -- trap system errors during deletion
1531: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1532: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.DELETE_TL_ROW');
1533: hr_utility.raise_error;
1534: end if;
1535:
1536: end if;

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

1594: --
1595: -- ****************************************************************
1596: --
1597: begin
1598: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.lock_row',1);
1599: --
1600: open csr_lock_input_value;
1601: fetch csr_lock_input_value into v_locked_row;
1602: if csr_lock_input_value%notfound then

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

1629: --
1630: --
1631: -- if (v_mls_count=0) then -- Trap system errors
1632: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1633: -- hr_utility.set_message_token ('PROCEDURE','PAY_INPUT_VALUES_PKG.LOCK_TL_ROW');
1634: -- end if;
1635: --
1636: -- ************************************************************************
1637: --

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

1756: and I.BUSINESS_GROUP_ID is NULL;
1757: --
1758: IF (result>1) THEN
1759: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1760: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1761: hr_utility.set_message_token('STEP','1');
1762: hr_utility.raise_error;
1763: END IF;
1764: EXCEPTION

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

1763: END IF;
1764: EXCEPTION
1765: when NO_DATA_FOUND then
1766: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1767: hr_utility.set_message_token('PROCEDURE','PAY_INPUT_VALUES_PKG.UNIQUE_CHK');
1768: hr_utility.set_message_token('STEP','1');
1769: hr_utility.raise_error;
1770: end unique_chk;
1771: --------------------------------------------------------------------------------

Line 2147: end PAY_INPUT_VALUES_PKG;

2143: --
2144: c_user_id := fnd_global.user_id;
2145: c_login_id := fnd_global.login_id;
2146: --
2147: end PAY_INPUT_VALUES_PKG;