DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on FND_FILE

Line 2419: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));

2415: l_line := 7;
2416: --
2417: if fnd_global.conc_request_id <> -1 then
2418: fnd_message.set_name('BEN', 'BEN_92190_THREAD_LABEL');
2419: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));
2420: fnd_file.put_line(fnd_file.log, ' ');
2421: if p_master_process_flag <> 'Y' then
2422: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
2423: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2420: fnd_file.put_line(fnd_file.log, ' ');

2416: --
2417: if fnd_global.conc_request_id <> -1 then
2418: fnd_message.set_name('BEN', 'BEN_92190_THREAD_LABEL');
2419: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));
2420: fnd_file.put_line(fnd_file.log, ' ');
2421: if p_master_process_flag <> 'Y' then
2422: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
2423: fnd_file.put_line(fnd_file.log, fnd_message.get);
2424: fnd_file.put_line(fnd_file.log, ' ');

Line 2423: fnd_file.put_line(fnd_file.log, fnd_message.get);

2419: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));
2420: fnd_file.put_line(fnd_file.log, ' ');
2421: if p_master_process_flag <> 'Y' then
2422: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
2423: fnd_file.put_line(fnd_file.log, fnd_message.get);
2424: fnd_file.put_line(fnd_file.log, ' ');
2425: end if;
2426: end if;
2427: --

Line 2424: fnd_file.put_line(fnd_file.log, ' ');

2420: fnd_file.put_line(fnd_file.log, ' ');
2421: if p_master_process_flag <> 'Y' then
2422: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
2423: fnd_file.put_line(fnd_file.log, fnd_message.get);
2424: fnd_file.put_line(fnd_file.log, ' ');
2425: end if;
2426: end if;
2427: --
2428: if g_debug then

Line 2460: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));

2456: --
2457: -- write end of thread statistics which shows totals of what was
2458: -- processed
2459: fnd_message.set_name('BEN', 'BEN_92190_THREAD_LABEL');
2460: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));
2461: --
2462: -- write the error message to the log file.
2463: --
2464: if ben_ext_thread.g_err_num <> 92184 then

Line 2466: fnd_file.put_line(fnd_file.log, fnd_message.get);

2462: -- write the error message to the log file.
2463: --
2464: if ben_ext_thread.g_err_num <> 92184 then
2465: fnd_message.set_name('BEN', 'BEN_92186_THREAD_FAILURE');
2466: fnd_file.put_line(fnd_file.log, fnd_message.get);
2467: fnd_file.put_line(fnd_file.log, ' ');
2468: end if;
2469: fnd_message.set_name('BEN', ben_ext_thread.g_err_name);
2470: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2467: fnd_file.put_line(fnd_file.log, ' ');

2463: --
2464: if ben_ext_thread.g_err_num <> 92184 then
2465: fnd_message.set_name('BEN', 'BEN_92186_THREAD_FAILURE');
2466: fnd_file.put_line(fnd_file.log, fnd_message.get);
2467: fnd_file.put_line(fnd_file.log, ' ');
2468: end if;
2469: fnd_message.set_name('BEN', ben_ext_thread.g_err_name);
2470: fnd_file.put_line(fnd_file.log, fnd_message.get);
2471: --

Line 2470: fnd_file.put_line(fnd_file.log, fnd_message.get);

2466: fnd_file.put_line(fnd_file.log, fnd_message.get);
2467: fnd_file.put_line(fnd_file.log, ' ');
2468: end if;
2469: fnd_message.set_name('BEN', ben_ext_thread.g_err_name);
2470: fnd_file.put_line(fnd_file.log, fnd_message.get);
2471: --
2472: -- if slave process, we are done. If master process, raise job failure in
2473: -- calling program (ben_ext_thread.process)
2474: --

Line 2493: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));

2489: set range_status_cd = 'E'
2490: where range_id = l_range_id;
2491: --
2492: fnd_message.set_name('BEN', 'BEN_92190_THREAD_LABEL');
2493: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));
2494: -- if slave process, we are done. If master process, raise job failure in
2495: -- calling program (ben_ext_thread.process)
2496: --
2497: if p_master_process_flag = 'Y' then

Line 2513: fnd_file.put_line(fnd_file.log, fnd_message.get);

2509: commit;
2510: --
2511: if fnd_global.conc_request_id <> -1 then
2512: fnd_message.set_name('BEN', 'BEN_92186_THREAD_FAILURE');
2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: fnd_file.put_line(fnd_file.log, ' ');
2515: fnd_message.set_name('PER', 'FFU10_GENERAL_ORACLE_ERROR');
2516: fnd_message.set_token('2', substr(sqlerrm, 1, 200));
2517: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2514: fnd_file.put_line(fnd_file.log, ' ');

2510: --
2511: if fnd_global.conc_request_id <> -1 then
2512: fnd_message.set_name('BEN', 'BEN_92186_THREAD_FAILURE');
2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: fnd_file.put_line(fnd_file.log, ' ');
2515: fnd_message.set_name('PER', 'FFU10_GENERAL_ORACLE_ERROR');
2516: fnd_message.set_token('2', substr(sqlerrm, 1, 200));
2517: fnd_file.put_line(fnd_file.log, fnd_message.get);
2518: fnd_message.raise_error;

Line 2517: fnd_file.put_line(fnd_file.log, fnd_message.get);

2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: fnd_file.put_line(fnd_file.log, ' ');
2515: fnd_message.set_name('PER', 'FFU10_GENERAL_ORACLE_ERROR');
2516: fnd_message.set_token('2', substr(sqlerrm, 1, 200));
2517: fnd_file.put_line(fnd_file.log, fnd_message.get);
2518: fnd_message.raise_error;
2519: end if;
2520: --
2521: end if;

Line 2591: fnd_file.put_line(fnd_file.log, ' ');

2587: l_proc := g_package||'.thread_summary';
2588: hr_utility.set_location ('Entering '||l_proc,5);
2589: end if;
2590: --
2591: fnd_file.put_line(fnd_file.log, ' ');
2592: fnd_message.set_name('BEN', 'BEN_92191_ALL_THREAD_LABEL');
2593: fnd_file.put_line(fnd_file.log, fnd_message.get);
2594: fnd_file.put_line(fnd_file.log, ' ');
2595: fnd_message.set_name('BEN', 'BEN_92192_EXT_STATS_LABEL');

Line 2593: fnd_file.put_line(fnd_file.log, fnd_message.get);

2589: end if;
2590: --
2591: fnd_file.put_line(fnd_file.log, ' ');
2592: fnd_message.set_name('BEN', 'BEN_92191_ALL_THREAD_LABEL');
2593: fnd_file.put_line(fnd_file.log, fnd_message.get);
2594: fnd_file.put_line(fnd_file.log, ' ');
2595: fnd_message.set_name('BEN', 'BEN_92192_EXT_STATS_LABEL');
2596: fnd_file.put_line(fnd_file.log, fnd_message.get);
2597: fnd_message.set_name('BEN', 'BEN_91956_EXT_TOT_REC');

Line 2594: fnd_file.put_line(fnd_file.log, ' ');

2590: --
2591: fnd_file.put_line(fnd_file.log, ' ');
2592: fnd_message.set_name('BEN', 'BEN_92191_ALL_THREAD_LABEL');
2593: fnd_file.put_line(fnd_file.log, fnd_message.get);
2594: fnd_file.put_line(fnd_file.log, ' ');
2595: fnd_message.set_name('BEN', 'BEN_92192_EXT_STATS_LABEL');
2596: fnd_file.put_line(fnd_file.log, fnd_message.get);
2597: fnd_message.set_name('BEN', 'BEN_91956_EXT_TOT_REC');
2598: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_rec_cnt));

Line 2596: fnd_file.put_line(fnd_file.log, fnd_message.get);

2592: fnd_message.set_name('BEN', 'BEN_92191_ALL_THREAD_LABEL');
2593: fnd_file.put_line(fnd_file.log, fnd_message.get);
2594: fnd_file.put_line(fnd_file.log, ' ');
2595: fnd_message.set_name('BEN', 'BEN_92192_EXT_STATS_LABEL');
2596: fnd_file.put_line(fnd_file.log, fnd_message.get);
2597: fnd_message.set_name('BEN', 'BEN_91956_EXT_TOT_REC');
2598: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_rec_cnt));
2599: --
2600: fnd_message.set_name('BEN', 'BEN_91957_EXT_TOT_PER');

Line 2598: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_rec_cnt));

2594: fnd_file.put_line(fnd_file.log, ' ');
2595: fnd_message.set_name('BEN', 'BEN_92192_EXT_STATS_LABEL');
2596: fnd_file.put_line(fnd_file.log, fnd_message.get);
2597: fnd_message.set_name('BEN', 'BEN_91956_EXT_TOT_REC');
2598: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_rec_cnt));
2599: --
2600: fnd_message.set_name('BEN', 'BEN_91957_EXT_TOT_PER');
2601: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_per_cnt));
2602: --

Line 2601: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_per_cnt));

2597: fnd_message.set_name('BEN', 'BEN_91956_EXT_TOT_REC');
2598: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_rec_cnt));
2599: --
2600: fnd_message.set_name('BEN', 'BEN_91957_EXT_TOT_PER');
2601: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_per_cnt));
2602: --
2603: fnd_message.set_name('BEN', 'BEN_91958_EXT_TOT_ERR');
2604: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_err_cnt));
2605: --

Line 2604: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_err_cnt));

2600: fnd_message.set_name('BEN', 'BEN_91957_EXT_TOT_PER');
2601: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_per_cnt));
2602: --
2603: fnd_message.set_name('BEN', 'BEN_91958_EXT_TOT_ERR');
2604: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_err_cnt));
2605: --
2606: fnd_file.put_line(fnd_file.log, ' ');
2607: --
2608: if g_debug then

Line 2606: fnd_file.put_line(fnd_file.log, ' ');

2602: --
2603: fnd_message.set_name('BEN', 'BEN_91958_EXT_TOT_ERR');
2604: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get || ' ' || to_char(g_err_cnt));
2605: --
2606: fnd_file.put_line(fnd_file.log, ' ');
2607: --
2608: if g_debug then
2609: hr_utility.set_location ('Exiting '||l_proc,15);
2610: end if;

Line 2991: fnd_file.put_line(fnd_file.log,'Error executing this dynamically build payroll event SQL Statement:');

2987: exception
2988: --
2989: when others then
2990: --
2991: fnd_file.put_line(fnd_file.log,'Error executing this dynamically build payroll event SQL Statement:');
2992: end;
2993: --
2994: fetch c_nonasgevt into l_dummy ;
2995: if c_nonasgevt%found then

Line 5965: fnd_file.put_line(fnd_file.log,'Error executing this dynamically build SQL Statement: ');

5961: exception
5962: --
5963: when others then
5964: --
5965: fnd_file.put_line(fnd_file.log,'Error executing this dynamically build SQL Statement: ');
5966: -- Update by RChase, 01-MAR-2000
5967: -- fnd_file.put_line(fnd_file.log, ' ' ||l_select_statement);
5968: FOR i in 1..LENGTH(l_select_statement) LOOP
5969: --

Line 5967: -- fnd_file.put_line(fnd_file.log, ' ' ||l_select_statement);

5963: when others then
5964: --
5965: fnd_file.put_line(fnd_file.log,'Error executing this dynamically build SQL Statement: ');
5966: -- Update by RChase, 01-MAR-2000
5967: -- fnd_file.put_line(fnd_file.log, ' ' ||l_select_statement);
5968: FOR i in 1..LENGTH(l_select_statement) LOOP
5969: --
5970: IF mod(i,80)=0 OR i=LENGTH(l_select_statement) THEN
5971: --

Line 5972: fnd_file.put_line(fnd_file.log,' ' ||substr(l_select_statement,l_current_loc+1,i-l_current_loc));

5968: FOR i in 1..LENGTH(l_select_statement) LOOP
5969: --
5970: IF mod(i,80)=0 OR i=LENGTH(l_select_statement) THEN
5971: --
5972: fnd_file.put_line(fnd_file.log,' ' ||substr(l_select_statement,l_current_loc+1,i-l_current_loc));
5973: l_current_loc:=i;
5974: --
5975: END IF;
5976: --

Line 6176: fnd_file.put_line(fnd_file.log, 'Total People Scanned: ' || l_person_cnt);

6172: l_line := 15;
6173: --
6174: commit;
6175: --
6176: fnd_file.put_line(fnd_file.log, 'Total People Scanned: ' || l_person_cnt);
6177: fnd_file.put_line(fnd_file.log, 'l_num_range: ' || l_num_range);
6178: fnd_file.put_line(fnd_file.log, 'l_threads: ' || l_threads);
6179: --
6180: l_count := 0;

Line 6177: fnd_file.put_line(fnd_file.log, 'l_num_range: ' || l_num_range);

6173: --
6174: commit;
6175: --
6176: fnd_file.put_line(fnd_file.log, 'Total People Scanned: ' || l_person_cnt);
6177: fnd_file.put_line(fnd_file.log, 'l_num_range: ' || l_num_range);
6178: fnd_file.put_line(fnd_file.log, 'l_threads: ' || l_threads);
6179: --
6180: l_count := 0;
6181: --

Line 6178: fnd_file.put_line(fnd_file.log, 'l_threads: ' || l_threads);

6174: commit;
6175: --
6176: fnd_file.put_line(fnd_file.log, 'Total People Scanned: ' || l_person_cnt);
6177: fnd_file.put_line(fnd_file.log, 'l_num_range: ' || l_num_range);
6178: fnd_file.put_line(fnd_file.log, 'l_threads: ' || l_threads);
6179: --
6180: l_count := 0;
6181: --
6182: If l_person_cnt > 0 and l_conc_request_id <> -1 then

Line 6402: fnd_file.put_line(fnd_file.log, fnd_message.get);

6398: --
6399: if l_conc_request_id <> -1 then
6400: --
6401: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
6402: fnd_file.put_line(fnd_file.log, fnd_message.get);
6403: fnd_file.put_line(fnd_file.log, ' ');
6404: --
6405: l_line := 127;
6406: --

Line 6403: fnd_file.put_line(fnd_file.log, ' ');

6399: if l_conc_request_id <> -1 then
6400: --
6401: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
6402: fnd_file.put_line(fnd_file.log, fnd_message.get);
6403: fnd_file.put_line(fnd_file.log, ' ');
6404: --
6405: l_line := 127;
6406: --
6407: thread_summary;

Line 6557: fnd_file.put_line(fnd_file.log, fnd_message.get);

6553: argument1 => l_conc_request_id);
6554: --
6555: thread_summary;
6556: fnd_message.set_name('BEN',g_err_name);
6557: fnd_file.put_line(fnd_file.log, fnd_message.get);
6558: fnd_message.raise_error;
6559: --
6560: end if;
6561: --

Line 6625: fnd_file.put_line(fnd_file.log, fnd_message.get);

6621: --
6622: thread_summary;
6623: fnd_message.set_name('PER', 'FFU10_GENERAL_ORACLE_ERROR');
6624: fnd_message.set_token('2', substr(sqlerrm, 1, 200));
6625: fnd_file.put_line(fnd_file.log, fnd_message.get);
6626: fnd_message.raise_error;
6627: --
6628: end if;
6629: --