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

Line 74: hr_utility.set_location('Entering: '||l_proc, 5);

70: --
71: l_proc varchar2(72):= g_package||'lock_wait';
72: begin
73: --
74: hr_utility.set_location('Entering: '||l_proc, 5);
75: --
76: l_lock_timeout := nvl(p_lock_timeout, g_lock_timeout);
77: --
78: -- Continue only when valid timeout is set.

Line 81: hr_utility.trace('Lock timeout is not set.');

77: --
78: -- Continue only when valid timeout is set.
79: --
80: if nvl(l_lock_timeout, 0) <= 0 then
81: hr_utility.trace('Lock timeout is not set.');
82: return false;
83: end if;
84: --
85: -- Increment the count.

Line 90: hr_utility.trace('Lock count exceeded the max count.');

86: --
87: p_count := nvl(p_count, 0)+1;
88: --
89: if p_count > g_max_lock_count then
90: hr_utility.trace('Lock count exceeded the max count.');
91: return false;
92: end if;
93: --
94: select sysdate into l_current_time

Line 100: hr_utility.trace('Setting the lock start time: '

96: --
97: if p_start_time is null then
98: --
99: p_start_time := l_current_time;
100: hr_utility.trace('Setting the lock start time: '
101: ||to_char(p_start_time,'yyyy/mm/dd hh24:mi:ss'));
102: end if;
103:
104: if ((l_current_time - p_start_time)*86400 < l_lock_timeout) then

Line 129: hr_utility.set_location('Entering: '||l_proc, 5);

125: --
126: l_proc varchar2(72):= g_package||'lock_sleep';
127: begin
128: --
129: hr_utility.set_location('Entering: '||l_proc, 5);
130: --
131: l_seconds := nvl(p_seconds, g_lock_interval);
132:
133: if l_seconds > 0 then

Line 134: hr_utility.trace('Sleep '||to_char(l_seconds));

130: --
131: l_seconds := nvl(p_seconds, g_lock_interval);
132:
133: if l_seconds > 0 then
134: hr_utility.trace('Sleep '||to_char(l_seconds));
135: dbms_lock.sleep(l_seconds);
136: end if;
137: end lock_sleep;
138: --

Line 167: hr_utility.set_location('Entering: '||l_proc, 5);

163: l_proc varchar2(72):= g_package||'load_element_link';
164: --
165: begin
166: --
167: hr_utility.set_location('Entering: '||l_proc, 5);
168: --
169: open csr_bat;
170: fetch csr_bat into l_bat_rec;
171: close csr_bat;

Line 288: hr_utility.set_location('Leaving: '||l_proc, 100);

284: -- Set out variable
285: --
286: p_element_link_id := l_link_rec.element_link_id;
287: --
288: hr_utility.set_location('Leaving: '||l_proc, 100);
289: --
290: exception
291: when others then
292: --

Line 340: hr_utility.set_location('Entering: '||l_proc, 5);

336: --
337: l_proc varchar2(72):= g_package||'init_ppa';
338: begin
339: --
340: hr_utility.set_location('Entering: '||l_proc, 5);
341: --
342: -- Check to see if the payroll action has been initialized.
343: --
344: if g_pact_rec.payroll_action_id = p_payroll_action_id then

Line 391: hr_utility.set_location('Leaving: '||l_proc, 100);

387: else
388: g_lock_interval := 0;
389: end if;
390:
391: hr_utility.set_location('Leaving: '||l_proc, 100);
392: --
393: end init_ppa;
394: --
395: -- ---------------------------------------------------------------------------

Line 444: hr_utility.set_location('Entering: '||l_proc, 5);

440: l_link_id_out number;
441: l_proc varchar2(72):= g_package||'transfer_batch_links';
442: begin
443: --
444: hr_utility.set_location('Entering: '||l_proc, 5);
445: --
446: g_err_batch_link_id := null;
447: g_batch_links.delete;
448: --

Line 468: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

464: when hr_api.object_locked then
465: --
466: -- Failed to lock the batch link.
467: --
468: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
469: hr_utility.set_message_token('TABLE_NAME', 'pay_batch_element_links');
470: hr_utility.raise_error;
471: end;
472: --

Line 469: hr_utility.set_message_token('TABLE_NAME', 'pay_batch_element_links');

465: --
466: -- Failed to lock the batch link.
467: --
468: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
469: hr_utility.set_message_token('TABLE_NAME', 'pay_batch_element_links');
470: hr_utility.raise_error;
471: end;
472: --
473: -- Load batch element links

Line 470: hr_utility.raise_error;

466: -- Failed to lock the batch link.
467: --
468: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
469: hr_utility.set_message_token('TABLE_NAME', 'pay_batch_element_links');
470: hr_utility.raise_error;
471: end;
472: --
473: -- Load batch element links
474: --

Line 488: hr_utility.set_location('Leaving: '||l_proc, 100);

484: end loop;
485: --
486: end if;
487: --
488: hr_utility.set_location('Leaving: '||l_proc, 100);
489: --
490: end transfer_batch_links;
491: --
492: -- ---------------------------------------------------------------------------

Line 661: hr_utility.set_location('Entering: '||l_proc, 5);

657: end set_processing_status;
658: --
659: begin
660: --
661: hr_utility.set_location('Entering: '||l_proc, 5);
662: --
663: -- Check to see if the link info has been initialized.
664: --
665: if g_link_initialized then

Line 750: hr_utility.set_location('Leaving: '||l_proc, 100);

746: end loop;
747: --
748: g_link_initialized := true;
749: --
750: hr_utility.set_location('Leaving: '||l_proc, 100);
751: --
752: exception
753: when hr_api.object_locked then
754: --

Line 757: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

753: when hr_api.object_locked then
754: --
755: -- Failed to lock element link.
756: --
757: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
758: hr_utility.set_message_token('TABLE_NAME', 'pay_element_links_f');
759: hr_utility.raise_error;
760: end init_links;
761: --

Line 758: hr_utility.set_message_token('TABLE_NAME', 'pay_element_links_f');

754: --
755: -- Failed to lock element link.
756: --
757: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
758: hr_utility.set_message_token('TABLE_NAME', 'pay_element_links_f');
759: hr_utility.raise_error;
760: end init_links;
761: --
762: -- ---------------------------------------------------------------------------

Line 759: hr_utility.raise_error;

755: -- Failed to lock element link.
756: --
757: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
758: hr_utility.set_message_token('TABLE_NAME', 'pay_element_links_f');
759: hr_utility.raise_error;
760: end init_links;
761: --
762: -- ---------------------------------------------------------------------------
763: -- action_archinit

Line 776: hr_utility.set_location('Entering: '||l_proc, 5);

772: l_lock_count number:= 0;
773: l_proc varchar2(72):= g_package||'action_archinit';
774: begin
775: --
776: hr_utility.set_location('Entering: '||l_proc, 5);
777: --
778: -- Initialize payroll action info.
779: --
780: init_ppa(p_payroll_action_id);

Line 825: hr_utility.set_location('Leaving: '||l_proc, 100);

821: end;
822: --
823: end loop;
824:
825: hr_utility.set_location('Leaving: '||l_proc, 100);
826: --
827: end action_archinit;
828: --
829: -- ---------------------------------------------------------------------------

Line 849: hr_utility.set_location('Entering: '||l_proc, 5);

845: l_link_id number;
846: l_proc varchar2(72):= g_package||'action_range_cursor';
847: begin
848: --
849: hr_utility.set_location('Entering: '||l_proc, 5);
850: --
851: --
852: -- Initialize payroll action info.
853: --

Line 947: hr_utility.set_location('Leaving: '||l_proc, 100);

943:
944: p_sqlstr := l_sql;
945:
946: --
947: hr_utility.set_location('Leaving: '||l_proc, 100);
948: --
949: end action_range_cursor;
950:
951: -- ---------------------------------------------------------------------------

Line 1008: hr_utility.set_location('Entering: '||l_proc, 5);

1004: l_proc varchar2(72):= g_package||'action_action_creation';
1005: --
1006: begin
1007: --
1008: hr_utility.set_location('Entering: '||l_proc, 5);
1009: --
1010: -- Initialize payroll action info.
1011: --
1012: init_ppa(p_payroll_action_id);

Line 1052: hr_utility.set_location('Leaving: '||l_proc, 100);

1048:
1049: --
1050: end loop;
1051: --
1052: hr_utility.set_location('Leaving: '||l_proc, 100);
1053: --
1054: end action_action_creation;
1055: --
1056: -- ---------------------------------------------------------------------------

Line 1071: hr_utility.set_location('Entering: '||l_proc, 5);

1067: l_link t_element_link_rec;
1068: l_proc varchar2(72):= g_package||'asg_action_main';
1069: begin
1070: --
1071: hr_utility.set_location('Entering: '||l_proc, 5);
1072: --
1073: -- Populate ALUs
1074: --
1075: if g_pg_links.count > 0 then

Line 1083: hr_utility.set_location(l_proc, 10);

1079: ,p_pg_link_tab => g_pg_links
1080: );
1081: end if;
1082: --
1083: hr_utility.set_location(l_proc, 10);
1084: --
1085: -- Populate element entries
1086: --
1087: for i in 1..g_standard_links.count loop

Line 1112: hr_utility.set_location('Leaving: '||l_proc, 100);

1108: );
1109:
1110: end loop;
1111: --
1112: hr_utility.set_location('Leaving: '||l_proc, 100);
1113: --
1114: end asg_action_main;
1115: --
1116: -- ---------------------------------------------------------------------------

Line 1134: hr_utility.set_location('Entering: '||l_proc, 5);

1130: l_lock_count number:= 0;
1131: l_proc varchar2(72):= g_package||'action_archive_data';
1132: begin
1133: --
1134: hr_utility.set_location('Entering: '||l_proc, 5);
1135: --
1136: select assignment_id into l_asgid
1137: from pay_assignment_actions
1138: where assignment_action_id = p_assactid;

Line 1183: hr_utility.set_location('Leaving: '||l_proc, 100);

1179: end;
1180: --
1181: end loop;
1182: --
1183: hr_utility.set_location('Leaving: '||l_proc, 100);
1184: --
1185: end action_archive_data;
1186: --
1187: -- ---------------------------------------------------------------------------

Line 1221: hr_utility.set_location('Entering: '||l_proc, 5);

1217: --
1218: l_proc varchar2(72):= g_package||'action_deinit';
1219: begin
1220: --
1221: hr_utility.set_location('Entering: '||l_proc, 5);
1222: --
1223: select
1224: pay_core_utils.get_parameter
1225: ('REMOVE_ACT', legislative_parameters) remove_act

Line 1322: hr_utility.set_location('Leaving: '||l_proc, 100);

1318: );
1319: end if;
1320:
1321: --
1322: hr_utility.set_location('Leaving: '||l_proc, 100);
1323: --
1324: end action_deinit;
1325: --
1326: