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.12020000.2 2012/07/05 02:37:15 amnaraya ship $ */
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 362: hr_utility.set_location ('pay_sub_class_rules_pkg.allowable_end_date',1);

358: and nvl(business_group_id,nvl(p_business_group_id,-1)) = nvl(p_business_group_id,-1);
359:
360: --
361: begin
362: hr_utility.set_location ('pay_sub_class_rules_pkg.allowable_end_date',1);
363: --
364: open csr_end_date;
365: fetch csr_end_date into v_end_date;
366: close csr_end_date;

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

412: p_validation_end_date date ) is
413: --
414: begin
415: --
416: hr_utility.set_location ('pay_sub_class_rules_pkg.MAINTAIN_DELETION_INTEGRITY',1);
417: --
418: -- Delete balance feeds for this sub classification rule
419: hr_balance_feeds.del_bf_sub_class_rule (
420: --

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

442: p_validation_end_date date ) is
443: --
444: begin
445: --
446: hr_utility.set_location ('pay_sub_class_rules_pkg.DELETE_ROW',1);
447: --
448: pay_sub_class_rules_pkg.maintain_deletion_integrity (
449: --
450: p_sub_classification_rule_id,

Line 448: pay_sub_class_rules_pkg.maintain_deletion_integrity (

444: begin
445: --
446: hr_utility.set_location ('pay_sub_class_rules_pkg.DELETE_ROW',1);
447: --
448: pay_sub_class_rules_pkg.maintain_deletion_integrity (
449: --
450: p_sub_classification_rule_id,
451: p_delete_mode,
452: p_validation_start_date,

Line 463: 'PAY_SUB_CLASS_RULES_PKG.DELETE_ROW');

459: --
460: if sql%notfound then -- system error trap
461: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
462: hr_utility.set_message_token('PROCEDURE',
463: 'PAY_SUB_CLASS_RULES_PKG.DELETE_ROW');
464: hr_utility.set_message_token('STEP','2');
465: hr_utility.raise_error;
466: end if;
467: --

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

502: classification_id)
503: for update;
504: --
505: begin
506: hr_utility.set_location ('pay_sub_class_rules_pkg.parent_deleted',1);
507: --
508: <>
509: for fetched_rule in csr_rows_owned_by_parent LOOP
510: --

Line 557: end PAY_SUB_CLASS_RULES_PKG;

553: --
554: c_user_id := fnd_global.user_id;
555: c_login_id := fnd_global.login_id;
556: --
557: end PAY_SUB_CLASS_RULES_PKG;