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.PV_CONTACT_USER_BATCH_PUB dependencies on UTL_FILE

Line 10: L_LOG_FILE utl_file.file_type;

6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8:
9:
10: L_LOG_FILE utl_file.file_type;
11:
12:
13:
14:

Line 27: utl_file.put_line(L_LOG_FILE, rpad(' ',160) || l_errors_tbl(i));

23: -- dbms_output.put_line('Error Count: ' || l_errors_tbl.count);
24: if l_errors_tbl.count > 0 then
25: for i in 1..l_errors_tbl.count
26: loop
27: utl_file.put_line(L_LOG_FILE, rpad(' ',160) || l_errors_tbl(i));
28: -- dbms_output.put_line('Error: ' || l_errors_tbl(i));
29: end loop;
30: l_errors_tbl.delete;
31: end if;

Line 2478: from v$parameter where name = 'utl_file_dir';

2474: CURSOR l_get_file_dir IS
2475: select
2476: trim(substr(value,0,(instr(value,',') - 1))),
2477: trim(substr(value,(instr(value,',') + 1)))
2478: from v$parameter where name = 'utl_file_dir';
2479:
2480: BEGIN
2481:
2482: -- dbms_output.put_line ('Entered Load_contacts method' );

Line 2502: l_log_file := utl_file.fopen(trim(l_out_dir), l_file_name, 'w');

2498: open l_get_file_dir;
2499: fetch l_get_file_dir into l_out_dir, l_log_dir;
2500: close l_get_file_dir;
2501:
2502: l_log_file := utl_file.fopen(trim(l_out_dir), l_file_name, 'w');
2503:
2504:
2505:
2506: /************** End of file data ************************************************************/

Line 2512: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));

2508:
2509: if l_contact_details_tbl.count = 0 then
2510:
2511: fnd_message.set_name('PV', 'PV_IMP_NO_CONTACT');
2512: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));
2513: x_return_status:='S';
2514:
2515:
2516:

Line 2520: utl_file.fclose(L_LOG_FILE);

2516:
2517: /************************************ CLOSING FILE ********************************/
2518: x_file_name := l_out_dir || '/' || l_file_name;
2519: -- dbms_output.put_line('output file name ' || x_file_name);
2520: utl_file.fclose(L_LOG_FILE);
2521: /**********************************************************************************/
2522:
2523: else
2524:

Line 2557: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));

2553: l_last_rec := l_contact_details_tbl.LAST;
2554: end if ;
2555:
2556: fnd_message.set_name('PV', 'PV_CONTACT_IMPORT_LOG');
2557: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));
2558:
2559: utl_file.put_line(L_LOG_FILE, '-----------------------------------------------------------------------------------------------------'
2560: || '-----------------------------------------------------------------------------------------------------------------------------------------------');
2561: -- dbms_output.put_line('just after writing to file');

Line 2559: utl_file.put_line(L_LOG_FILE, '-----------------------------------------------------------------------------------------------------'

2555:
2556: fnd_message.set_name('PV', 'PV_CONTACT_IMPORT_LOG');
2557: utl_file.put_line(L_LOG_FILE, substrb(fnd_message.get, 1, 1000));
2558:
2559: utl_file.put_line(L_LOG_FILE, '-----------------------------------------------------------------------------------------------------'
2560: || '-----------------------------------------------------------------------------------------------------------------------------------------------');
2561: -- dbms_output.put_line('just after writing to file');
2562:
2563:

Line 2622: utl_file.put_line(L_LOG_FILE, rpad(nvl(l_contact_details_rec.contact_name,'N/A'),20) || rpad(nvl(l_contact_output_rec.Prtnr_orig_system,'N/A'),20)

2618:
2619:
2620:
2621: -- dbms_output.put_line('just before writing to file');
2622: utl_file.put_line(L_LOG_FILE, rpad(nvl(l_contact_details_rec.contact_name,'N/A'),20) || rpad(nvl(l_contact_output_rec.Prtnr_orig_system,'N/A'),20)
2623: || rpad(nvl(l_contact_output_rec.Prtnr_orig_system_reference,'N/A'),20) || rpad(nvl(l_contact_output_rec.Partner_party_id,0),20)
2624: || rpad(nvl(l_contact_output_rec.Cnt_orig_system,'N/A'),20) || rpad(nvl(l_contact_output_rec.Cnt_orig_system_reference,'N/A'),20)
2625: || rpad(nvl(l_contact_output_rec.Person_party_id,0),20) || rpad(nvl(l_contact_output_rec.Contact_rel_party_id,0),20)
2626: || rpad(nvl(log_return_status,'N/A'),20));

Line 2628: utl_file.put_line(L_LOG_FILE, '-----------------------------------------------------------------------------------------------------'

2624: || rpad(nvl(l_contact_output_rec.Cnt_orig_system,'N/A'),20) || rpad(nvl(l_contact_output_rec.Cnt_orig_system_reference,'N/A'),20)
2625: || rpad(nvl(l_contact_output_rec.Person_party_id,0),20) || rpad(nvl(l_contact_output_rec.Contact_rel_party_id,0),20)
2626: || rpad(nvl(log_return_status,'N/A'),20));
2627: Write_Error(l_log_msg);
2628: utl_file.put_line(L_LOG_FILE, '-----------------------------------------------------------------------------------------------------'
2629: || '-----------------------------------------------------------------------------------------------------------------------------------------------');
2630: -- dbms_output.put_line('just after writing to file');
2631:
2632:

Line 2671: utl_file.fclose(L_LOG_FILE);

2667:
2668: /************************************ CLOSING FILE ********************************/
2669: x_file_name := l_out_dir || '/' || l_file_name;
2670: -- dbms_output.put_line('output file name ' || x_file_name);
2671: utl_file.fclose(L_LOG_FILE);
2672: /**********************************************************************************/
2673: -- dbms_output.put_line('just after closing file');
2674:
2675:

Line 2684: when utl_file.invalid_path then

2680: end if;
2681:
2682:
2683: EXCEPTION
2684: when utl_file.invalid_path then
2685: raise_application_error(-20100,'Invalid Path');
2686: when utl_file.invalid_mode then
2687: raise_application_error(-20101,'Invalid Mode');
2688: when utl_file.invalid_operation then

Line 2686: when utl_file.invalid_mode then

2682:
2683: EXCEPTION
2684: when utl_file.invalid_path then
2685: raise_application_error(-20100,'Invalid Path');
2686: when utl_file.invalid_mode then
2687: raise_application_error(-20101,'Invalid Mode');
2688: when utl_file.invalid_operation then
2689: raise_application_error(-20102,'Invalid Operation');
2690: when utl_file.invalid_filehandle then

Line 2688: when utl_file.invalid_operation then

2684: when utl_file.invalid_path then
2685: raise_application_error(-20100,'Invalid Path');
2686: when utl_file.invalid_mode then
2687: raise_application_error(-20101,'Invalid Mode');
2688: when utl_file.invalid_operation then
2689: raise_application_error(-20102,'Invalid Operation');
2690: when utl_file.invalid_filehandle then
2691: raise_application_error(-20103,'Invalid FileHandle');
2692: when utl_file.write_error then

Line 2690: when utl_file.invalid_filehandle then

2686: when utl_file.invalid_mode then
2687: raise_application_error(-20101,'Invalid Mode');
2688: when utl_file.invalid_operation then
2689: raise_application_error(-20102,'Invalid Operation');
2690: when utl_file.invalid_filehandle then
2691: raise_application_error(-20103,'Invalid FileHandle');
2692: when utl_file.write_error then
2693: utl_file.fclose(l_log_file);
2694: raise_application_error(-20104,'Write Error');

Line 2692: when utl_file.write_error then

2688: when utl_file.invalid_operation then
2689: raise_application_error(-20102,'Invalid Operation');
2690: when utl_file.invalid_filehandle then
2691: raise_application_error(-20103,'Invalid FileHandle');
2692: when utl_file.write_error then
2693: utl_file.fclose(l_log_file);
2694: raise_application_error(-20104,'Write Error');
2695: when utl_file.read_error then
2696: raise_application_error(-20105,'Read Error');

Line 2693: utl_file.fclose(l_log_file);

2689: raise_application_error(-20102,'Invalid Operation');
2690: when utl_file.invalid_filehandle then
2691: raise_application_error(-20103,'Invalid FileHandle');
2692: when utl_file.write_error then
2693: utl_file.fclose(l_log_file);
2694: raise_application_error(-20104,'Write Error');
2695: when utl_file.read_error then
2696: raise_application_error(-20105,'Read Error');
2697: when utl_file.internal_error then

Line 2695: when utl_file.read_error then

2691: raise_application_error(-20103,'Invalid FileHandle');
2692: when utl_file.write_error then
2693: utl_file.fclose(l_log_file);
2694: raise_application_error(-20104,'Write Error');
2695: when utl_file.read_error then
2696: raise_application_error(-20105,'Read Error');
2697: when utl_file.internal_error then
2698: raise_application_error(-20106,'Internal Error');
2699:

Line 2697: when utl_file.internal_error then

2693: utl_file.fclose(l_log_file);
2694: raise_application_error(-20104,'Write Error');
2695: when utl_file.read_error then
2696: raise_application_error(-20105,'Read Error');
2697: when utl_file.internal_error then
2698: raise_application_error(-20106,'Internal Error');
2699:
2700: WHEN OTHERS THEN
2701:

Line 2704: /* utl_file.put_line(L_LOG_FILE,SQLERRM);

2700: WHEN OTHERS THEN
2701:
2702:
2703: ROLLBACK;
2704: /* utl_file.put_line(L_LOG_FILE,SQLERRM);
2705: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2706: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));
2707: END LOOP;
2708: utl_file.fclose(l_log_file);

Line 2706: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));

2702:
2703: ROLLBACK;
2704: /* utl_file.put_line(L_LOG_FILE,SQLERRM);
2705: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2706: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));
2707: END LOOP;
2708: utl_file.fclose(l_log_file);
2709: */
2710:

Line 2708: utl_file.fclose(l_log_file);

2704: /* utl_file.put_line(L_LOG_FILE,SQLERRM);
2705: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2706: utl_file.put_line(L_LOG_FILE,Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,1000));
2707: END LOOP;
2708: utl_file.fclose(l_log_file);
2709: */
2710:
2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN