DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on FND_FILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5955: exception
5956: --
5957: when others then
5958: --
5959: fnd_file.put_line(fnd_file.log,'Error executing this dynamically build SQL Statement: ');
5960: -- Update by RChase, 01-MAR-2000
5961: -- fnd_file.put_line(fnd_file.log, ' ' ||l_select_statement);
5962: FOR i in 1..LENGTH(l_select_statement) LOOP
5963: --

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

5957: when others then
5958: --
5959: fnd_file.put_line(fnd_file.log,'Error executing this dynamically build SQL Statement: ');
5960: -- Update by RChase, 01-MAR-2000
5961: -- fnd_file.put_line(fnd_file.log, ' ' ||l_select_statement);
5962: FOR i in 1..LENGTH(l_select_statement) LOOP
5963: --
5964: IF mod(i,80)=0 OR i=LENGTH(l_select_statement) THEN
5965: --

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

5962: FOR i in 1..LENGTH(l_select_statement) LOOP
5963: --
5964: IF mod(i,80)=0 OR i=LENGTH(l_select_statement) THEN
5965: --
5966: fnd_file.put_line(fnd_file.log,' ' ||substr(l_select_statement,l_current_loc+1,i-l_current_loc));
5967: l_current_loc:=i;
5968: --
5969: END IF;
5970: --

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

6133: l_line := 15;
6134: --
6135: commit;
6136: --
6137: fnd_file.put_line(fnd_file.log, 'Total People Scanned: ' || l_person_cnt);
6138: --
6139: l_count := 0;
6140: --
6141: If l_person_cnt > 0 and l_conc_request_id <> -1 then

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

6357: --
6358: if l_conc_request_id <> -1 then
6359: --
6360: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
6361: fnd_file.put_line(fnd_file.log, fnd_message.get);
6362: fnd_file.put_line(fnd_file.log, ' ');
6363: --
6364: l_line := 127;
6365: --

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

6358: if l_conc_request_id <> -1 then
6359: --
6360: fnd_message.set_name('BEN', 'BEN_92185_THREAD_SUCCESS');
6361: fnd_file.put_line(fnd_file.log, fnd_message.get);
6362: fnd_file.put_line(fnd_file.log, ' ');
6363: --
6364: l_line := 127;
6365: --
6366: thread_summary;

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

6512: argument1 => l_conc_request_id);
6513: --
6514: thread_summary;
6515: fnd_message.set_name('BEN',g_err_name);
6516: fnd_file.put_line(fnd_file.log, fnd_message.get);
6517: fnd_message.raise_error;
6518: --
6519: end if;
6520: --

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

6580: --
6581: thread_summary;
6582: fnd_message.set_name('PER', 'FFU10_GENERAL_ORACLE_ERROR');
6583: fnd_message.set_token('2', substr(sqlerrm, 1, 200));
6584: fnd_file.put_line(fnd_file.log, fnd_message.get);
6585: fnd_message.raise_error;
6586: --
6587: end if;
6588: --