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_SUB_CLASS_RULES_PKG dependencies on PAY_SUB_CLASS_RULES_PKG

Line 1: package body PAY_SUB_CLASS_RULES_PKG as

1: package body PAY_SUB_CLASS_RULES_PKG as
2: /* $Header: pysbr.pkb 120.0 2005/05/29 01:50:52 appldev noship $ */
3: --
4: -- Declare global variables and cursors
5: --

Line 40: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',1);

36: select pay_sub_classification_rules_s.nextval
37: from sys.dual;
38: BEGIN
39:
40: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',1);
41:
42: if p_sub_classification_rule_id is null then
43: open csr_next_id;
44: fetch csr_next_id into p_sub_classification_rule_id;

Line 48: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',2);

44: fetch csr_next_id into p_sub_classification_rule_id;
45: close csr_next_id;
46: end if;
47:
48: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',2);
49: insert into pay_sub_classification_rules_f(
50:
51: sub_classification_rule_id,
52: effective_start_date,

Line 78: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',3);

74: c_user_id,
75: sysdate
76:
77: );
78: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',3);
79:
80: open csr_new_rowid;
81: fetch csr_new_rowid into p_rowid;
82: if csr_new_rowid%notfound then

Line 85: hr_utility.set_message_token('PROCEDURE','PAY_SUB_CLASS_RULES_PKG.INSERT_ROW');

81: fetch csr_new_rowid into p_rowid;
82: if csr_new_rowid%notfound then
83: close csr_new_rowid;
84: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE','PAY_SUB_CLASS_RULES_PKG.INSERT_ROW');
86: hr_utility.set_message_token('STEP','1');
87: hr_utility.raise_error;
88: end if;
89: close csr_new_rowid;

Line 99: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',4);

95: -- entered. This could arise because the forms startup code also handles
96: -- application ownerships where a user enters a value on the form, but
97: -- this code is intended to handle third party insertion from the element
98: --
99: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',4);
100: insert into hr_application_ownerships
101: (key_name,
102: key_value,
103: product_name)

Line 119: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',5);

115: and ao.key_value = p_element_type_id);
116: --
117: end if;
118: --
119: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',5);
120: hr_balance_feeds.ins_bf_sub_class_rule (p_Sub_Classification_Rule_Id);
121:
122: end insert_row;
123:

Line 153: hr_utility.set_message_token('PROCEDURE','PAY_SUB_CLASS_RULES_PKG.LOCK_ROW');

149: fetch csr_existing_row into fetched_record;
150: if csr_existing_row%notfound then
151: close csr_existing_row;
152: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('PROCEDURE','PAY_SUB_CLASS_RULES_PKG.LOCK_ROW');
154: hr_utility.set_message_token('STEP','1');
155: hr_utility.raise_error;
156: end if;
157: close csr_existing_row;

Line 217: hr_utility.set_message_token('PROCEDURE','PAY_SUB_CLASS_RULES_PKG.UPDATE_ROW');

213: WHERE rowid = p_rowid;
214:
215: if (SQL%NOTFOUND) then
216: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
217: hr_utility.set_message_token('PROCEDURE','PAY_SUB_CLASS_RULES_PKG.UPDATE_ROW');
218: hr_utility.set_message_token('STEP','1');
219: hr_utility.raise_error;
220: end if;
221:

Line 264: hr_utility.set_location ('pay_sub_class_rules_pkg.insert_defaults',1);

260: ));
261: --
262: begin
263: --
264: hr_utility.set_location ('pay_sub_class_rules_pkg.insert_defaults',1);
265: --
266: for default_insertion in csr_next_default LOOP
267: --
268: insert_row (

Line 312: hr_utility.set_location ('pay_sub_class_rules_pkg.allowable_end_date',1);

308: and classification_id = p_classification_id
309: and effective_end_date > p_session_date;
310: --
311: begin
312: hr_utility.set_location ('pay_sub_class_rules_pkg.allowable_end_date',1);
313: --
314: open csr_end_date;
315: fetch csr_end_date into v_end_date;
316: close csr_end_date;

Line 365: hr_utility.set_location ('pay_sub_class_rules_pkg.MAINTAIN_DELETION_INTEGRITY',1);

361: p_validation_end_date date ) is
362: --
363: begin
364: --
365: hr_utility.set_location ('pay_sub_class_rules_pkg.MAINTAIN_DELETION_INTEGRITY',1);
366: --
367: -- Delete balance feeds for this sub classification rule
368: hr_balance_feeds.del_bf_sub_class_rule (
369: --

Line 395: hr_utility.set_location ('pay_sub_class_rules_pkg.DELETE_ROW',1);

391: p_validation_end_date date ) is
392: --
393: begin
394: --
395: hr_utility.set_location ('pay_sub_class_rules_pkg.DELETE_ROW',1);
396: --
397: pay_sub_class_rules_pkg.maintain_deletion_integrity (
398: --
399: p_sub_classification_rule_id,

Line 397: pay_sub_class_rules_pkg.maintain_deletion_integrity (

393: begin
394: --
395: hr_utility.set_location ('pay_sub_class_rules_pkg.DELETE_ROW',1);
396: --
397: pay_sub_class_rules_pkg.maintain_deletion_integrity (
398: --
399: p_sub_classification_rule_id,
400: p_delete_mode,
401: p_validation_start_date,

Line 412: 'PAY_SUB_CLASS_RULES_PKG.DELETE_ROW');

408: --
409: if sql%notfound then -- system error trap
410: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE',
412: 'PAY_SUB_CLASS_RULES_PKG.DELETE_ROW');
413: hr_utility.set_message_token('STEP','2');
414: hr_utility.raise_error;
415: end if;
416: --

Line 455: hr_utility.set_location ('pay_sub_class_rules_pkg.parent_deleted',1);

451: classification_id)
452: for update;
453: --
454: begin
455: hr_utility.set_location ('pay_sub_class_rules_pkg.parent_deleted',1);
456: --
457: <>
458: for fetched_rule in csr_rows_owned_by_parent LOOP
459: --

Line 506: end PAY_SUB_CLASS_RULES_PKG;

502: --
503: c_user_id := fnd_global.user_id;
504: c_login_id := fnd_global.login_id;
505: --
506: end PAY_SUB_CLASS_RULES_PKG;