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

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

31: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.SUBMIT_CONC_REQUEST';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering ' || l_proc, 5);
36:
37: l_batch_status := batch_overall_status(p_batch_id);
38:
39: if not check_operation_allowed (p_batch_status => l_batch_status, p_process_mode => p_mode) then

Line 72: hr_utility.set_location('Leaving ' || l_proc, 5);

68: commit;
69: end if;
70: --
71:
72: hr_utility.set_location('Leaving ' || l_proc, 5);
73: return (l_request_id);
74: --
75: End submit_conc_request;
76: --

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

113: order by 1 desc;
114: --
115: begin
116: --
117: hr_utility.set_location('Entering ' || l_proc, 5);
118:
119: hr_utility.trace('Batch status for batch ' || p_batch_id);
120:
121: for distinct_status in csr_status LOOP

Line 119: hr_utility.trace('Batch status for batch ' || p_batch_id);

115: begin
116: --
117: hr_utility.set_location('Entering ' || l_proc, 5);
118:
119: hr_utility.trace('Batch status for batch ' || p_batch_id);
120:
121: for distinct_status in csr_status LOOP
122: --
123: if distinct_status.status = 'E' then

Line 124: hr_utility.trace('Errored batch groups exist');

120:
121: for distinct_status in csr_status LOOP
122: --
123: if distinct_status.status = 'E' then
124: hr_utility.trace('Errored batch groups exist');
125: error_groups_exist := TRUE;
126: exit; -- we do not need to know the rest
127: --
128: elsif distinct_status.status = 'U' then

Line 129: hr_utility.trace('Unprocessed batch groups exist');

125: error_groups_exist := TRUE;
126: exit; -- we do not need to know the rest
127: --
128: elsif distinct_status.status = 'U' then
129: hr_utility.trace('Unprocessed batch groups exist');
130: unprocessed_groups_exist := TRUE;
131: --
132: elsif distinct_status.status = 'T' then
133: hr_utility.trace('Transferred batch groups exist');

Line 133: hr_utility.trace('Transferred batch groups exist');

129: hr_utility.trace('Unprocessed batch groups exist');
130: unprocessed_groups_exist := TRUE;
131: --
132: elsif distinct_status.status = 'T' then
133: hr_utility.trace('Transferred batch groups exist');
134: transferred_groups_exist := TRUE;
135: --
136: elsif distinct_status.status = 'V' then
137: hr_utility.trace('Valid batch groups exist');

Line 137: hr_utility.trace('Valid batch groups exist');

133: hr_utility.trace('Transferred batch groups exist');
134: transferred_groups_exist := TRUE;
135: --
136: elsif distinct_status.status = 'V' then
137: hr_utility.trace('Valid batch groups exist');
138: valid_groups_exist := TRUE;
139: --
140: elsif distinct_status.status = 'Y' then
141: hr_utility.trace('Batch header is transferred');

Line 141: hr_utility.trace('Batch header is transferred');

137: hr_utility.trace('Valid batch groups exist');
138: valid_groups_exist := TRUE;
139: --
140: elsif distinct_status.status = 'Y' then
141: hr_utility.trace('Batch header is transferred');
142: header_transferred := TRUE;
143: --
144: elsif distinct_status.status in ('L','P') then
145: hr_utility.trace('Batch in Processing state');

Line 145: hr_utility.trace('Batch in Processing state');

141: hr_utility.trace('Batch header is transferred');
142: header_transferred := TRUE;
143: --
144: elsif distinct_status.status in ('L','P') then
145: hr_utility.trace('Batch in Processing state');
146: header_processing := TRUE;
147: --
148: end if;
149: --

Line 184: hr_utility.set_location('Leaving ' || l_proc, 5);

180: else
181: return 'SM'; -- mismatch of statuses
182: end if;
183:
184: hr_utility.set_location('Leaving ' || l_proc, 5);
185: --
186: end batch_overall_status;
187: --
188: --

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

229: order by 1 desc;
230: --
231: begin
232: --
233: hr_utility.set_location('Entering ' || l_proc, 5);
234: hr_utility.trace('Status for batch group ' || p_batch_group_id);
235:
236: for distinct_status in csr_status LOOP
237: --

Line 234: hr_utility.trace('Status for batch group ' || p_batch_group_id);

230: --
231: begin
232: --
233: hr_utility.set_location('Entering ' || l_proc, 5);
234: hr_utility.trace('Status for batch group ' || p_batch_group_id);
235:
236: for distinct_status in csr_status LOOP
237: --
238: if distinct_status.status = 'E' then

Line 239: hr_utility.trace('Error lines exist');

235:
236: for distinct_status in csr_status LOOP
237: --
238: if distinct_status.status = 'E' then
239: hr_utility.trace('Error lines exist');
240: error_lines_exist := TRUE;
241: exit; -- we do not need to know the rest
242: --
243: elsif distinct_status.status = 'U' then

Line 244: hr_utility.trace('Unprocessed lines exist');

240: error_lines_exist := TRUE;
241: exit; -- we do not need to know the rest
242: --
243: elsif distinct_status.status = 'U' then
244: hr_utility.trace('Unprocessed lines exist');
245: unprocessed_lines_exist := TRUE;
246: --
247: elsif distinct_status.status = 'T' then
248: hr_utility.trace('Transferred lines exist');

Line 248: hr_utility.trace('Transferred lines exist');

244: hr_utility.trace('Unprocessed lines exist');
245: unprocessed_lines_exist := TRUE;
246: --
247: elsif distinct_status.status = 'T' then
248: hr_utility.trace('Transferred lines exist');
249: transferred_lines_exist := TRUE;
250: --
251: elsif distinct_status.status = 'V' then
252: hr_utility.trace('Valid lines exist');

Line 252: hr_utility.trace('Valid lines exist');

248: hr_utility.trace('Transferred lines exist');
249: transferred_lines_exist := TRUE;
250: --
251: elsif distinct_status.status = 'V' then
252: hr_utility.trace('Valid lines exist');
253: valid_lines_exist := TRUE;
254: --
255: elsif distinct_status.status = 'Y' then
256: hr_utility.trace('Batch group is transferred');

Line 256: hr_utility.trace('Batch group is transferred');

252: hr_utility.trace('Valid lines exist');
253: valid_lines_exist := TRUE;
254: --
255: elsif distinct_status.status = 'Y' then
256: hr_utility.trace('Batch group is transferred');
257: group_transferred := TRUE;
258: --
259: elsif distinct_status.status in ('L','P') then
260: hr_utility.trace('Batch group is currently loaded');

Line 260: hr_utility.trace('Batch group is currently loaded');

256: hr_utility.trace('Batch group is transferred');
257: group_transferred := TRUE;
258: --
259: elsif distinct_status.status in ('L','P') then
260: hr_utility.trace('Batch group is currently loaded');
261: group_processing := TRUE;
262: --
263: end if;
264: --

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

294: else
295: return 'SM'; -- mismatch of statuses
296: end if;
297: --
298: hr_utility.set_location('Leaving ' || l_proc, 100);
299: --
300: end batch_group_overall_status;
301: --
302: -- ----------------------------------------------------------------------------

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

330:
331: --
332: begin
333: --
334: hr_utility.set_location('Entering: '||l_proc, 5);
335:
336: hr_utility.trace('Purging batch '||p_batch_id);
337:
338: hr_utility.trace('Purging batch lines of the batch');

Line 336: hr_utility.trace('Purging batch '||p_batch_id);

332: begin
333: --
334: hr_utility.set_location('Entering: '||l_proc, 5);
335:
336: hr_utility.trace('Purging batch '||p_batch_id);
337:
338: hr_utility.trace('Purging batch lines of the batch');
339:
340:

Line 338: hr_utility.trace('Purging batch lines of the batch');

334: hr_utility.set_location('Entering: '||l_proc, 5);
335:
336: hr_utility.trace('Purging batch '||p_batch_id);
337:
338: hr_utility.trace('Purging batch lines of the batch');
339:
340:
341: for cssr in csr_batch_lines loop
342:

Line 362: hr_utility.trace('Purging batch groups of the batch');

358: where batch_line_id = cssr.batch_line_id;
359:
360: end loop;
361:
362: hr_utility.trace('Purging batch groups of the batch');
363:
364: for cssr in csr_batch_groups loop
365:
366: --

Line 386: hr_utility.trace('Purging the batch header');

382:
383: end loop;
384:
385:
386: hr_utility.trace('Purging the batch header');
387:
388: if p_batch_group_id is null then
389:
390: --

Line 409: hr_utility.set_location('Leaving: '||l_proc, 5);

405: where batch_id = p_batch_id;
406:
407: end if;
408:
409: hr_utility.set_location('Leaving: '||l_proc, 5);
410: commit;
411: --
412: end purge;
413: --

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

429: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.CHECK_OPERATION_ALLOWED';
430: --
431: begin
432: --
433: hr_utility.set_location('Entering: '||l_proc, 5);
434:
435: -- 'L' stands for Loading (Processing)
436: if (p_batch_status = 'T' and p_process_mode in ('TRANSFER')) or
437: (p_batch_status = 'P') or

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

440: else
441: return true;
442: end if;
443:
444: hr_utility.set_location('Leaving: '||l_proc, 5);
445: --
446: end check_operation_allowed;
447: -- ----------------------------------------------------------------------------
448: -- |--------------------------------< rollback_batch >-------------------------|

Line 488: hr_utility.set_location('Entering: '||l_proc, 10);

484: --and pact.batch_process_mode = 'TRANSFER';
485: --
486: begin
487: --
488: hr_utility.set_location('Entering: '||l_proc, 10);
489:
490: l_count := 0;
491:
492: for lcsr in csr_batch_groups loop

Line 501: hr_utility.trace('Rollback batch group ' || lcsr.batch_group_id);

497:
498: if l_payroll_action_id is not null then
499:
500: begin
501: hr_utility.trace('Rollback batch group ' || lcsr.batch_group_id);
502: hr_utility.trace('Rollback payroll action ' || l_payroll_action_id);
503:
504: savepoint RG;
505: py_rollback_pkg.rollback_payroll_action(l_payroll_action_id,'ROLLBACK',FALSE);

Line 502: hr_utility.trace('Rollback payroll action ' || l_payroll_action_id);

498: if l_payroll_action_id is not null then
499:
500: begin
501: hr_utility.trace('Rollback batch group ' || lcsr.batch_group_id);
502: hr_utility.trace('Rollback payroll action ' || l_payroll_action_id);
503:
504: savepoint RG;
505: py_rollback_pkg.rollback_payroll_action(l_payroll_action_id,'ROLLBACK',FALSE);
506: commit;

Line 523: hr_utility.set_message(801,'PAY_34293_BBABP_BTCHGRP_RB');

519: l_message_level_tbl(l_count) := 'I';
520: l_message_source_type_tbl(l_count) := 'G';
521: l_message_source_id_tbl(l_count) := lcsr.batch_group_id;
522:
523: hr_utility.set_message(801,'PAY_34293_BBABP_BTCHGRP_RB');
524: l_error_text := substrb(hr_utility.get_message, 1, 240);
525:
526: l_message_text_tbl(l_count) := l_error_text;
527:

Line 524: l_error_text := substrb(hr_utility.get_message, 1, 240);

520: l_message_source_type_tbl(l_count) := 'G';
521: l_message_source_id_tbl(l_count) := lcsr.batch_group_id;
522:
523: hr_utility.set_message(801,'PAY_34293_BBABP_BTCHGRP_RB');
524: l_error_text := substrb(hr_utility.get_message, 1, 240);
525:
526: l_message_text_tbl(l_count) := l_error_text;
527:
528:

Line 540: hr_utility.set_message(801,'PAY_34294_BBABP_ERR_IN_PROC');

536: l_message_level_tbl(l_count) := 'W';
537: l_message_source_type_tbl(l_count) := 'G';
538: l_message_source_id_tbl(l_count) := lcsr.batch_group_id;
539:
540: hr_utility.set_message(801,'PAY_34294_BBABP_ERR_IN_PROC');
541: hr_utility.set_message_token('PROC', l_proc);
542: l_error_text := substrb(hr_utility.get_message || ' ' || sqlerrm, 1, 240);
543: l_message_text_tbl(l_count) := l_error_text;
544:

Line 541: hr_utility.set_message_token('PROC', l_proc);

537: l_message_source_type_tbl(l_count) := 'G';
538: l_message_source_id_tbl(l_count) := lcsr.batch_group_id;
539:
540: hr_utility.set_message(801,'PAY_34294_BBABP_ERR_IN_PROC');
541: hr_utility.set_message_token('PROC', l_proc);
542: l_error_text := substrb(hr_utility.get_message || ' ' || sqlerrm, 1, 240);
543: l_message_text_tbl(l_count) := l_error_text;
544:
545: end;

Line 542: l_error_text := substrb(hr_utility.get_message || ' ' || sqlerrm, 1, 240);

538: l_message_source_id_tbl(l_count) := lcsr.batch_group_id;
539:
540: hr_utility.set_message(801,'PAY_34294_BBABP_ERR_IN_PROC');
541: hr_utility.set_message_token('PROC', l_proc);
542: l_error_text := substrb(hr_utility.get_message || ' ' || sqlerrm, 1, 240);
543: l_message_text_tbl(l_count) := l_error_text;
544:
545: end;
546:

Line 551: hr_utility.set_location(l_proc, 30);

547: end if;
548:
549: end loop;
550:
551: hr_utility.set_location(l_proc, 30);
552:
553: begin
554:
555: for i in 1..l_count loop

Line 579: hr_utility.set_location(l_proc, 40);

575: end if;
576:
577: end loop;
578:
579: hr_utility.set_location(l_proc, 40);
580:
581: --
582: exception
583: when no_data_found then

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

585: end;
586:
587: commit;
588:
589: hr_utility.set_location('Leaving : ' || l_proc, 100);
590: --
591: end rollback_batch;
592: --
593:

Line 744: hr_utility.set_message(801,'HR_6614_PAY_NO_TIME_PERIOD');

740: group_csr.prepay_flag
741: );
742: exception
743: when others then
744: hr_utility.set_message(801,'HR_6614_PAY_NO_TIME_PERIOD');
745: l_error_text := substrb(hr_utility.get_message, 1, 240);
746: insert into pay_message_lines
747: (line_sequence,
748: payroll_id,

Line 745: l_error_text := substrb(hr_utility.get_message, 1, 240);

741: );
742: exception
743: when others then
744: hr_utility.set_message(801,'HR_6614_PAY_NO_TIME_PERIOD');
745: l_error_text := substrb(hr_utility.get_message, 1, 240);
746: insert into pay_message_lines
747: (line_sequence,
748: payroll_id,
749: message_level,

Line 863: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');

859: l_count := l_count + 1;
860: l_message_level_tbl(l_count) := 'F';
861: l_message_source_type_tbl(l_count) := 'I';
862: l_message_source_id_tbl(l_count) := line_csr.batch_line_id;
863: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
864: -- message is "Error in test"
865: --l_proc := 'PAY_BAL_ADJUST.adjust_balance';
866: --hr_utility.set_message_token('PROC', l_proc);
867: l_error_text := substrb(hr_utility.get_message || ' ' ||

Line 866: --hr_utility.set_message_token('PROC', l_proc);

862: l_message_source_id_tbl(l_count) := line_csr.batch_line_id;
863: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
864: -- message is "Error in test"
865: --l_proc := 'PAY_BAL_ADJUST.adjust_balance';
866: --hr_utility.set_message_token('PROC', l_proc);
867: l_error_text := substrb(hr_utility.get_message || ' ' ||
868: sqlerrm, 1, 240);
869: l_message_text_tbl(l_count) := l_error_text;
870: --

Line 867: l_error_text := substrb(hr_utility.get_message || ' ' ||

863: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
864: -- message is "Error in test"
865: --l_proc := 'PAY_BAL_ADJUST.adjust_balance';
866: --hr_utility.set_message_token('PROC', l_proc);
867: l_error_text := substrb(hr_utility.get_message || ' ' ||
868: sqlerrm, 1, 240);
869: l_message_text_tbl(l_count) := l_error_text;
870: --
871: l_line_error := TRUE;

Line 888: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');

884: l_message_level_tbl(l_count) := 'F';
885: l_message_source_type_tbl(l_count) := 'G';
886: l_message_source_id_tbl(l_count) := group_csr.batch_group_id;
887:
888: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
889: -- message is "Error in test"
890: --l_proc := 'PAY_BAL_ADJUST.process_batch';
891: --hr_utility.set_message_token('PROC', l_proc);
892: l_error_text := substrb(hr_utility.get_message || ' ' ||

Line 891: --hr_utility.set_message_token('PROC', l_proc);

887:
888: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
889: -- message is "Error in test"
890: --l_proc := 'PAY_BAL_ADJUST.process_batch';
891: --hr_utility.set_message_token('PROC', l_proc);
892: l_error_text := substrb(hr_utility.get_message || ' ' ||
893: sqlerrm, 1, 240);
894:
895: l_message_text_tbl(l_count) := l_error_text;

Line 892: l_error_text := substrb(hr_utility.get_message || ' ' ||

888: --hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
889: -- message is "Error in test"
890: --l_proc := 'PAY_BAL_ADJUST.process_batch';
891: --hr_utility.set_message_token('PROC', l_proc);
892: l_error_text := substrb(hr_utility.get_message || ' ' ||
893: sqlerrm, 1, 240);
894:
895: l_message_text_tbl(l_count) := l_error_text;
896: raise process_batch_failed;

Line 994: hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');

990: where pml.source_id = group_csr.batch_group_id
991: and source_type = 'G';
992: exception
993: when no_data_found then
994: hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
995: l_proc := 'validating the batch group';
996: hr_utility.set_message_token('PROC', l_proc);
997: l_error_text := substrb(hr_utility.get_message || ' ' ||
998: sqlerrm, 1, 240);

Line 996: hr_utility.set_message_token('PROC', l_proc);

992: exception
993: when no_data_found then
994: hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
995: l_proc := 'validating the batch group';
996: hr_utility.set_message_token('PROC', l_proc);
997: l_error_text := substrb(hr_utility.get_message || ' ' ||
998: sqlerrm, 1, 240);
999: insert into pay_message_lines
1000: (line_sequence,

Line 997: l_error_text := substrb(hr_utility.get_message || ' ' ||

993: when no_data_found then
994: hr_utility.set_message(801, 'PAY_34294_BBABP_ERR_IN_PROC');
995: l_proc := 'validating the batch group';
996: hr_utility.set_message_token('PROC', l_proc);
997: l_error_text := substrb(hr_utility.get_message || ' ' ||
998: sqlerrm, 1, 240);
999: insert into pay_message_lines
1000: (line_sequence,
1001: payroll_id,

Line 1114: hr_utility.set_location('Entering ' || l_proc, 10);

1110: l_batch_status pay_balance_batch_headers.batch_status%type;
1111: --
1112: begin
1113: --
1114: hr_utility.set_location('Entering ' || l_proc, 10);
1115:
1116: savepoint rprc;
1117:
1118: l_batch_status := batch_overall_status(p_batch_id => p_batch_id);

Line 1122: hr_utility.set_location('Leaving: '||l_proc, 10);

1118: l_batch_status := batch_overall_status(p_batch_id => p_batch_id);
1119:
1120: if not check_operation_allowed (p_batch_status => l_batch_status, p_process_mode => p_batch_operation) then
1121:
1122: hr_utility.set_location('Leaving: '||l_proc, 10);
1123: fnd_message.set_name('PAY','PAY_34292_BBABP_INV_OPERATION');
1124: fnd_message.set_token('BATCHOP', p_batch_operation);
1125: fnd_message.set_token('STATUS', l_batch_status);
1126: fnd_message.raise_error;

Line 1130: hr_utility.set_location(l_proc,20);

1126: fnd_message.raise_error;
1127:
1128: end if;
1129:
1130: hr_utility.set_location(l_proc,20);
1131:
1132: if p_batch_operation = 'ROLLBACK' then
1133:
1134: hr_utility.set_location(l_proc,30);

Line 1134: hr_utility.set_location(l_proc,30);

1130: hr_utility.set_location(l_proc,20);
1131:
1132: if p_batch_operation = 'ROLLBACK' then
1133:
1134: hr_utility.set_location(l_proc,30);
1135:
1136: pay_batch_balance_adj_pkg.rollback_batch
1137: ( p_batch_id => p_batch_id,
1138: p_batch_group_id => p_batch_group_id );

Line 1139: hr_utility.set_location(l_proc,40);

1135:
1136: pay_batch_balance_adj_pkg.rollback_batch
1137: ( p_batch_id => p_batch_id,
1138: p_batch_group_id => p_batch_group_id );
1139: hr_utility.set_location(l_proc,40);
1140:
1141: elsif p_batch_operation = 'PURGE' then
1142:
1143: hr_utility.set_location(l_proc,50);

Line 1143: hr_utility.set_location(l_proc,50);

1139: hr_utility.set_location(l_proc,40);
1140:
1141: elsif p_batch_operation = 'PURGE' then
1142:
1143: hr_utility.set_location(l_proc,50);
1144:
1145: pay_batch_balance_adj_pkg.purge
1146: ( p_batch_id => p_batch_id,
1147: p_batch_group_id => p_batch_group_id );

Line 1149: hr_utility.set_location(l_proc,60);

1145: pay_batch_balance_adj_pkg.purge
1146: ( p_batch_id => p_batch_id,
1147: p_batch_group_id => p_batch_group_id );
1148:
1149: hr_utility.set_location(l_proc,60);
1150:
1151: elsif p_batch_operation = 'VALIDATE' then
1152:
1153: hr_utility.set_location(l_proc,70);

Line 1153: hr_utility.set_location(l_proc,70);

1149: hr_utility.set_location(l_proc,60);
1150:
1151: elsif p_batch_operation = 'VALIDATE' then
1152:
1153: hr_utility.set_location(l_proc,70);
1154:
1155: pay_batch_balance_adj_pkg.validate_batch
1156: ( p_batch_id => p_batch_id,
1157: p_batch_group_id => p_batch_group_id );

Line 1158: hr_utility.set_location(l_proc,80);

1154:
1155: pay_batch_balance_adj_pkg.validate_batch
1156: ( p_batch_id => p_batch_id,
1157: p_batch_group_id => p_batch_group_id );
1158: hr_utility.set_location(l_proc,80);
1159:
1160: elsif p_batch_operation = 'TRANSFER' then
1161:
1162: hr_utility.set_location(l_proc,90);

Line 1162: hr_utility.set_location(l_proc,90);

1158: hr_utility.set_location(l_proc,80);
1159:
1160: elsif p_batch_operation = 'TRANSFER' then
1161:
1162: hr_utility.set_location(l_proc,90);
1163:
1164: pay_batch_balance_adj_pkg.transfer_batch
1165: ( p_batch_id => p_batch_id,
1166: p_batch_group_id => p_batch_group_id );

Line 1167: hr_utility.set_location(l_proc,100);

1163:
1164: pay_batch_balance_adj_pkg.transfer_batch
1165: ( p_batch_id => p_batch_id,
1166: p_batch_group_id => p_batch_group_id );
1167: hr_utility.set_location(l_proc,100);
1168: end if;
1169:
1170: hr_utility.set_location(l_proc,110);
1171:

Line 1170: hr_utility.set_location(l_proc,110);

1166: p_batch_group_id => p_batch_group_id );
1167: hr_utility.set_location(l_proc,100);
1168: end if;
1169:
1170: hr_utility.set_location(l_proc,110);
1171:
1172: errbuf := null;
1173: retcode := 0;
1174:

Line 1175: hr_utility.set_location('Leaving ' || l_proc, 120);

1171:
1172: errbuf := null;
1173: retcode := 0;
1174:
1175: hr_utility.set_location('Leaving ' || l_proc, 120);
1176: --
1177: exception
1178: when others then
1179: rollback to rprc;

Line 1182: hr_utility.set_location(l_proc,130);

1178: when others then
1179: rollback to rprc;
1180: errbuf := sqlerrm;
1181: retcode := 2;
1182: hr_utility.set_location(l_proc,130);
1183: raise;
1184: --
1185: end run_process;
1186: --