DBA Data[Home] [Help]

APPS.AME_DYNAMIC_APPROVAL_PKG dependencies on HR_UTILITY

Line 48: hr_utility.set_location('Entering: insert_ame_approver', 1);

44: c_insertion_record2 ame_util.insertionRecord2;
45: lv_parameter varchar2(650);
46: BEGIN
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);

Line 49: hr_utility.trace('p_application_id=' || p_application_id);

45: lv_parameter varchar2(650);
46: BEGIN
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);

Line 50: hr_utility.trace('p_transaction_type=' || p_transaction_type);

46: BEGIN
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:

Line 51: hr_utility.trace('p_transaction_id=' || p_transaction_id);

47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:
55: --Copy details from p_approverIn/p_insertionIn to c_approver_rec2

Line 52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);

48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:
55: --Copy details from p_approverIn/p_insertionIn to c_approver_rec2
56: c_approver_rec2.name := p_approverIn(1).name;

Line 53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);

49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:
55: --Copy details from p_approverIn/p_insertionIn to c_approver_rec2
56: c_approver_rec2.name := p_approverIn(1).name;
57: c_approver_rec2.orig_system := p_approverIn(1).orig_system ;

Line 115: hr_utility.set_location('Leaving: insert_ame_approver', 2);

111: transactionTypeIn=>p_transaction_type );
112: end;
113: end if;
114:
115: hr_utility.set_location('Leaving: insert_ame_approver', 2);
116: commit;
117: EXCEPTION
118: WHEN OTHERS THEN
119: rollback;

Line 142: hr_utility.set_location('Entering: delete_ame_approver', 1);

138: l_proc constant varchar2(100) := 'delete_ame_approver';
139: c_approver_rec2 ame_util.approverRecord2;
140: BEGIN
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);

Line 143: hr_utility.trace('p_application_id=' || p_application_id);

139: c_approver_rec2 ame_util.approverRecord2;
140: BEGIN
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:

Line 144: hr_utility.trace('p_transaction_type=' || p_transaction_type);

140: BEGIN
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:
148: -- copy details from p_approverIn to c_approver_rec2

Line 145: hr_utility.trace('p_transaction_id=' || p_transaction_id);

141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:
148: -- copy details from p_approverIn to c_approver_rec2
149: c_approver_rec2.name := p_approverIn(1).name;

Line 146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);

142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:
148: -- copy details from p_approverIn to c_approver_rec2
149: c_approver_rec2.name := p_approverIn(1).name;
150: c_approver_rec2.item_class := p_approverIn(1).item_class;

Line 179: hr_utility.set_location('Leaving: delete_ame_approver', 2);

175: );
176:
177: end;
178: end if;
179: hr_utility.set_location('Leaving: delete_ame_approver', 2);
180: commit;
181: EXCEPTION
182: WHEN OTHERS THEN
183: rollback;

Line 271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);

267:
268:
269: BEGIN
270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:

Line 272: hr_utility.trace('p_application_id=' || p_application_id);

268:
269: BEGIN
270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:
276: -- set flag based on user selection for Active or All Approvers

Line 273: hr_utility.trace('p_transaction_type=' || p_transaction_type);

269: BEGIN
270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:
276: -- set flag based on user selection for Active or All Approvers
277: -- zero means active approver

Line 274: hr_utility.trace('p_transaction_id=' || p_transaction_id);

270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:
276: -- set flag based on user selection for Active or All Approvers
277: -- zero means active approver
278: if(p_apprs_view_type = '0' or p_apprs_view_type is null) then

Line 497: hr_utility.trace('end of insertion records for loop');

493: end if;
494:
495: <>
496: -- this statement included just for above End_of_Insertions_Loop label
497: hr_utility.trace('end of insertion records for loop');
498: END LOOP; -- insertions loop
499: -- end of the reading insertion records
500:
501: -- set out parameters for approvers and insertion records

Line 505: hr_utility.set_location('Leaving: get_ame_apprs_and_ins_list', 2);

501: -- set out parameters for approvers and insertion records
502: p_ame_order_type_list := l_default_insertions_list;
503: p_ame_approvers_list := l_default_approvers_list;
504:
505: hr_utility.set_location('Leaving: get_ame_apprs_and_ins_list', 2);
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: ame_util.runtimeException(packageNameIn => 'ame_dynamic_approval_pkg',