DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on FND_FILE

Line 542: fnd_file.put_line (fnd_file.log, 'Successful Batch Name: '||l_valid_batch_name);

538: p_object_version_number => l_object_version_number,
539: p_batch_name => l_valid_batch_name
540: ); /* For updating the batch_name of the newly created batch */
541:
542: fnd_file.put_line (fnd_file.log, 'Successful Batch Name: '||l_valid_batch_name);
543:
544: IF g_debug THEN
545: hr_utility.set_location('After updating valid batch name: '||l_valid_batch_name, 50);
546: END IF;

Line 586: fnd_file.put_line (fnd_file.log, 'Warning Batch Name: '||l_warning_batch_name);

582: p_object_version_number => l_object_version_number,
583: p_batch_name => l_warning_batch_name
584: ); /* For updating the batch_name of the newly created batch */
585:
586: fnd_file.put_line (fnd_file.log, 'Warning Batch Name: '||l_warning_batch_name);
587:
588: IF g_debug THEN
589: hr_utility.set_location('After updating warning batch name: '||l_warning_batch_name, 90);
590: END IF;

Line 631: fnd_file.put_line (fnd_file.log, 'Error Batch Name: '||l_error_batch_name);

627: p_object_version_number => l_object_version_number,
628: p_batch_name => l_error_batch_name
629: ); /* For updating the batch_name of the newly created batch */
630:
631: fnd_file.put_line (fnd_file.log, 'Error Batch Name: '||l_error_batch_name);
632:
633: IF g_debug THEN
634: hr_utility.set_location('After updating error batch name: '||l_error_batch_name, 130);
635: END IF;

Line 749: fnd_file.put_line (fnd_file.log, 'Assignment# = '|| l_assignment_no||

745: hr_utility.trace(dbms_utility.format_error_backtrace);
746:
747: END;
748:
749: fnd_file.put_line (fnd_file.log, 'Assignment# = '|| l_assignment_no||
750: ' has an '||l_batch_type||' Timecard in the Batch: '||l_parent_batch_name);
751: END IF;
752:
753: END IF;

Line 1188: FND_FILE.put_line(fnd_file.log,'Rollback errored out ');

1184: raise g_lookup_not_found ; --propogate to the next level
1185: WHEN g_rollback_error THEN
1186: -- Bug 10143866
1187: hr_utility.trace(dbms_utility.format_error_backtrace);
1188: FND_FILE.put_line(fnd_file.log,'Rollback errored out ');
1189: -- Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
1190: --commit;
1191: raise g_rollback_error;
1192: WHEN OTHERS THEN

Line 1301: FND_FILE.put_line(fnd_file.log,errbuf);

1297: WHEN g_rollback_error THEN --SIR517 PWM 18FEB00 TESTING
1298: HXT_UTIL.DEBUG('Oops...Rollback Error');
1299: l_errbuf := substr(FND_MESSAGE.GET,1,65);
1300: errbuf := l_errbuf;
1301: FND_FILE.put_line(fnd_file.log,errbuf);
1302: raise;
1303: WHEN OTHERS THEN
1304: -- Bug 10143866
1305: hr_utility.trace(dbms_utility.format_error_backtrace);

Line 2781: FND_FILE.put_line(FND_FILE.log,'Processing Batch id '||p_batch_id);

2777: hr_utility.trace('Time period is null ');
2778: hr_utility.trace('Getting Batch lines for batch id '||p_batch_id);
2779: END IF;
2780:
2781: FND_FILE.put_line(FND_FILE.log,'Processing Batch id '||p_batch_id);
2782:
2783: for l_rec in c_get_batch_lines(p_batch_id)
2784: loop
2785: FND_FILE.put_line(FND_FILE.log,'=> Processing Batch Line id '||l_rec.batch_line_id);

Line 2785: FND_FILE.put_line(FND_FILE.log,'=> Processing Batch Line id '||l_rec.batch_line_id);

2781: FND_FILE.put_line(FND_FILE.log,'Processing Batch id '||p_batch_id);
2782:
2783: for l_rec in c_get_batch_lines(p_batch_id)
2784: loop
2785: FND_FILE.put_line(FND_FILE.log,'=> Processing Batch Line id '||l_rec.batch_line_id);
2786: hr_utility.trace('=>Processing Batch Line id '||l_rec.batch_line_id);
2787: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
2788: (p_batch_line_id => l_rec.batch_line_id
2789: ,p_object_version_number => l_rec.object_version_number

Line 2806: FND_FILE.put_line(FND_FILE.log,'=>Picking Retro batches for '||p_batch_id);

2802: hr_utility.trace( 'updated hxt_batch_states for this batch ');
2803: END IF;
2804: -- step 1 - delete retro_batch lines for any timecards in this (regular) batch.
2805: --Then we loop through the cursor and delete the batch lines and batches as follows.
2806: FND_FILE.put_line(FND_FILE.log,'=>Picking Retro batches for '||p_batch_id);
2807: for l_rec in c_get_retro_batch_ids(p_batch_id) loop
2808:
2809: FND_FILE.put_line(FND_FILE.log,'=> Retro Batch Id: '||l_rec.retro_batch_id);
2810: hr_utility.trace('=> Retro Batch Id: '||l_rec.retro_batch_id);

Line 2809: FND_FILE.put_line(FND_FILE.log,'=> Retro Batch Id: '||l_rec.retro_batch_id);

2805: --Then we loop through the cursor and delete the batch lines and batches as follows.
2806: FND_FILE.put_line(FND_FILE.log,'=>Picking Retro batches for '||p_batch_id);
2807: for l_rec in c_get_retro_batch_ids(p_batch_id) loop
2808:
2809: FND_FILE.put_line(FND_FILE.log,'=> Retro Batch Id: '||l_rec.retro_batch_id);
2810: hr_utility.trace('=> Retro Batch Id: '||l_rec.retro_batch_id);
2811:
2812: IF l_rec.batch_status IN ( 'T','V')
2813: THEN

Line 2815: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' is in status Transferred or Valid');

2811:
2812: IF l_rec.batch_status IN ( 'T','V')
2813: THEN
2814: hr_utility.trace('Retro batch '||l_rec.retro_batch_id||' is in status T');
2815: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' is in status Transferred or Valid');
2816: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' should be Unprocessed to proceed further');
2817: RAISE g_rollback_error;
2818: END IF;
2819:

Line 2816: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' should be Unprocessed to proceed further');

2812: IF l_rec.batch_status IN ( 'T','V')
2813: THEN
2814: hr_utility.trace('Retro batch '||l_rec.retro_batch_id||' is in status T');
2815: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' is in status Transferred or Valid');
2816: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' should be Unprocessed to proceed further');
2817: RAISE g_rollback_error;
2818: END IF;
2819:
2820: -- delete the batch lines

Line 2822: FND_FILE.put_line(FND_FILE.log,'=>------- Retro Line Id: '||l_line_rec.batch_line_id);

2818: END IF;
2819:
2820: -- delete the batch lines
2821: for l_line_rec in c_get_batch_lines(l_rec.retro_batch_id) loop
2822: FND_FILE.put_line(FND_FILE.log,'=>------- Retro Line Id: '||l_line_rec.batch_line_id);
2823: hr_utility.trace('=>------- Retro Line Id: '||l_line_rec.batch_line_id);
2824: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
2825: (p_batch_line_id => l_line_rec.batch_line_id
2826: ,p_object_version_number => l_line_rec.object_version_number

Line 2877: FND_FILE.put_line(FND_FILE.log,'=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);

2873: THEN
2874:
2875: FOR i IN l_retro_tab.FIRST..l_retro_tab.LAST
2876: LOOP
2877: FND_FILE.put_line(FND_FILE.log,'=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);
2878: hr_utility.trace('=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);
2879:
2880: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_header
2881: (p_batch_id => l_retro_tab(i).retro_batch_id

Line 2980: FND_FILE.put_line(fnd_file.log,'Error: '||sqlerrm);

2976: WHEN OTHERS THEN
2977: ROLLBACK;
2978: HXT_UTIL.DEBUG('Error: ' || sqlerrm); --HXT115
2979: l_sql_error := sqlerrm;
2980: FND_FILE.put_line(fnd_file.log,'Error: '||sqlerrm);
2981: p_rollback_retcode := 3;
2982: -- Bug 10143866
2983: hr_utility.trace(dbms_utility.format_error_backtrace);
2984: RAISE g_rollback_error;