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

Line 2232: sarakshi 02-Feb-2006 Bug#4960517, replaced the profile IGS_PS_EXP_DIR_PATH to UTL_FILE_OUT

2228:
2229: Change History
2230:
2231: Who When What
2232: sarakshi 02-Feb-2006 Bug#4960517, replaced the profile IGS_PS_EXP_DIR_PATH to UTL_FILE_OUT
2233: jbegum 04-Apr-2003 As per bug#2833850 added code to export preferred region code information
2234: to flat file.
2235: smvk 07-May-2002 Removed Hardcoded filename and filename are choosed from lookup_values to
2236: overcome translation issues as per the Bug # 2401826

Line 2239: whose name is 'utl_file_dir' and Output file names are modified to have

2235: smvk 07-May-2002 Removed Hardcoded filename and filename are choosed from lookup_values to
2236: overcome translation issues as per the Bug # 2401826
2237: smvk 09-May-2002 Created a private procedure prof_value_pres_pvt to check the value of
2238: profile 'IGS_PS_EXP_DIR_PATH' is matches with the value of v$paramtere(table)
2239: whose name is 'utl_file_dir' and Output file names are modified to have
2240: request id with them as per Bug # 2343189
2241: (reverse chronological order - newest change first)
2242: ***************************************************************/
2243:

Line 2251: l_handler_room UTL_FILE.FILE_TYPE ;

2247: invalid EXCEPTION;
2248: valid EXCEPTION;
2249: dirnotfound EXCEPTION;
2250: l_check CHAR;
2251: l_handler_room UTL_FILE.FILE_TYPE ;
2252: l_handler_building UTL_FILE.FILE_TYPE ;
2253: l_handler_location UTL_FILE.FILE_TYPE ;
2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850
2255: l_handler_check BOOLEAN;

Line 2252: l_handler_building UTL_FILE.FILE_TYPE ;

2248: valid EXCEPTION;
2249: dirnotfound EXCEPTION;
2250: l_check CHAR;
2251: l_handler_room UTL_FILE.FILE_TYPE ;
2252: l_handler_building UTL_FILE.FILE_TYPE ;
2253: l_handler_location UTL_FILE.FILE_TYPE ;
2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850
2255: l_handler_check BOOLEAN;
2256: l_path_var VARCHAR2(80);

Line 2253: l_handler_location UTL_FILE.FILE_TYPE ;

2249: dirnotfound EXCEPTION;
2250: l_check CHAR;
2251: l_handler_room UTL_FILE.FILE_TYPE ;
2252: l_handler_building UTL_FILE.FILE_TYPE ;
2253: l_handler_location UTL_FILE.FILE_TYPE ;
2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850
2255: l_handler_check BOOLEAN;
2256: l_path_var VARCHAR2(80);
2257: l_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID(); -- returns the concurrent request id;

Line 2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850

2250: l_check CHAR;
2251: l_handler_room UTL_FILE.FILE_TYPE ;
2252: l_handler_building UTL_FILE.FILE_TYPE ;
2253: l_handler_location UTL_FILE.FILE_TYPE ;
2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850
2255: l_handler_check BOOLEAN;
2256: l_path_var VARCHAR2(80);
2257: l_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID(); -- returns the concurrent request id;
2258: l_prof_val_pres VARCHAR2(1); -- to check profile value is present in utl_file_dir of v$parameter

Line 2258: l_prof_val_pres VARCHAR2(1); -- to check profile value is present in utl_file_dir of v$parameter

2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850
2255: l_handler_check BOOLEAN;
2256: l_path_var VARCHAR2(80);
2257: l_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID(); -- returns the concurrent request id;
2258: l_prof_val_pres VARCHAR2(1); -- to check profile value is present in utl_file_dir of v$parameter
2259:
2260: -- Cursor to get room information to be exported to flat file
2261: CURSOR c_room IS
2262: SELECT room_id,building_id,room_cd,description,primary_use_cd,capacity,closed_ind

Line 2342: for the name utl_file_dir. Called within prgp_write_ref_file procedure only.

2338: Date Created By : 08-MAY-2002
2339:
2340: Purpose : Private procedure to check the value of profile 'IGS_PS_EXP_DIR_PATH'
2341: (output dir for export data file) matches with the value in v$parameter
2342: for the name utl_file_dir. Called within prgp_write_ref_file procedure only.
2343:
2344: Know limitations, enhancements or remarks
2345:
2346: Change History

Line 2363: WHERE NAME='utl_file_dir';

2359:
2360: CURSOR c_value IS
2361: SELECT VALUE
2362: FROM V$PARAMETER
2363: WHERE NAME='utl_file_dir';
2364:
2365: BEGIN
2366: p_isthere := 'N';
2367: l_fndvalue := LTRIM(RTRIM(FND_PROFILE.VALUE('UTL_FILE_OUT')));

Line 2367: l_fndvalue := LTRIM(RTRIM(FND_PROFILE.VALUE('UTL_FILE_OUT')));

2363: WHERE NAME='utl_file_dir';
2364:
2365: BEGIN
2366: p_isthere := 'N';
2367: l_fndvalue := LTRIM(RTRIM(FND_PROFILE.VALUE('UTL_FILE_OUT')));
2368: OPEN c_value ;
2369: FETCH c_value INTO l_dbvalue ;
2370: IF c_value%FOUND AND l_dbvalue IS NOT NULL THEN
2371: l_dbvalue:= LTRIM(RTRIM(l_dbvalue));

Line 2402: l_path_var := FND_PROFILE.VALUE('UTL_FILE_OUT');

2398: END prof_value_pres_pvt;
2399:
2400: BEGIN
2401: --adding the following code to overcome file.sql.35 warning.
2402: l_path_var := FND_PROFILE.VALUE('UTL_FILE_OUT');
2403: l_prof_val_pres := 'N'; -- to check profile value is present in utl_file_dir of v$parameter
2404:
2405: -- set the multi org id
2406: igs_ge_gen_003.set_org_id (p_org_id);

Line 2403: l_prof_val_pres := 'N'; -- to check profile value is present in utl_file_dir of v$parameter

2399:
2400: BEGIN
2401: --adding the following code to overcome file.sql.35 warning.
2402: l_path_var := FND_PROFILE.VALUE('UTL_FILE_OUT');
2403: l_prof_val_pres := 'N'; -- to check profile value is present in utl_file_dir of v$parameter
2404:
2405: -- set the multi org id
2406: igs_ge_gen_003.set_org_id (p_org_id);
2407:

Line 2419: -- to check the value present in profile matches with that value of utl_file_dir in v$parameter

2415: RAISE invalid;
2416: END IF;
2417:
2418: -- calling private procedure
2419: -- to check the value present in profile matches with that value of utl_file_dir in v$parameter
2420: prof_value_pres_pvt(l_prof_val_pres);
2421: IF l_prof_val_pres = 'N' THEN
2422: l_message :='IGS_PS_OUT_DIR_NOT_FOUND';
2423: RAISE dirnotfound;

Line 2450: l_handler_room := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_room_fname.meaning)) || l_req_id, 'w');

2446:
2447: -- WRITING from TABLES
2448:
2449: BEGIN
2450: l_handler_room := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_room_fname.meaning)) || l_req_id, 'w');
2451: l_handler_check := UTL_FILE.IS_OPEN(l_handler_room);
2452: IF (l_handler_check = FALSE ) THEN
2453: RAISE invalid;
2454: END IF;

Line 2451: l_handler_check := UTL_FILE.IS_OPEN(l_handler_room);

2447: -- WRITING from TABLES
2448:
2449: BEGIN
2450: l_handler_room := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_room_fname.meaning)) || l_req_id, 'w');
2451: l_handler_check := UTL_FILE.IS_OPEN(l_handler_room);
2452: IF (l_handler_check = FALSE ) THEN
2453: RAISE invalid;
2454: END IF;
2455: EXCEPTION

Line 2462: UTL_FILE.PUT_LINE(l_handler_room, cur_temp.room_id|| l_column_sep ||

2458: RAISE invalid;
2459: END;
2460:
2461: FOR cur_temp IN c_room LOOP
2462: UTL_FILE.PUT_LINE(l_handler_room, cur_temp.room_id|| l_column_sep ||
2463: cur_temp.building_id|| l_column_sep ||cur_temp.room_cd|| l_column_sep ||
2464: cur_temp.description|| l_column_sep ||cur_temp.primary_use_cd||
2465: l_column_sep ||cur_temp.capacity|| l_column_sep ||cur_temp.closed_ind);
2466: END LOOP;

Line 2467: UTL_FILE.FCLOSE(l_handler_room);

2463: cur_temp.building_id|| l_column_sep ||cur_temp.room_cd|| l_column_sep ||
2464: cur_temp.description|| l_column_sep ||cur_temp.primary_use_cd||
2465: l_column_sep ||cur_temp.capacity|| l_column_sep ||cur_temp.closed_ind);
2466: END LOOP;
2467: UTL_FILE.FCLOSE(l_handler_room);
2468:
2469: BEGIN
2470: l_handler_building := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_building_fname.meaning)) || l_req_id, 'w');
2471: l_handler_check := UTL_FILE.IS_OPEN(l_handler_building);

Line 2470: l_handler_building := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_building_fname.meaning)) || l_req_id, 'w');

2466: END LOOP;
2467: UTL_FILE.FCLOSE(l_handler_room);
2468:
2469: BEGIN
2470: l_handler_building := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_building_fname.meaning)) || l_req_id, 'w');
2471: l_handler_check := UTL_FILE.IS_OPEN(l_handler_building);
2472: IF (l_handler_check = FALSE ) THEN
2473: RAISE invalid;
2474: END IF;

Line 2471: l_handler_check := UTL_FILE.IS_OPEN(l_handler_building);

2467: UTL_FILE.FCLOSE(l_handler_room);
2468:
2469: BEGIN
2470: l_handler_building := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_building_fname.meaning)) || l_req_id, 'w');
2471: l_handler_check := UTL_FILE.IS_OPEN(l_handler_building);
2472: IF (l_handler_check = FALSE ) THEN
2473: RAISE invalid;
2474: END IF;
2475: EXCEPTION

Line 2482: UTL_FILE.PUT_LINE(l_handler_building, cur_temp.building_id|| l_column_sep ||

2478: RAISE invalid;
2479: END;
2480:
2481: FOR cur_temp IN c_building LOOP
2482: UTL_FILE.PUT_LINE(l_handler_building, cur_temp.building_id|| l_column_sep ||
2483: cur_temp.location_cd|| l_column_sep ||cur_temp.building_cd|| l_column_sep ||
2484: cur_temp.description|| l_column_sep ||cur_temp.closed_ind);
2485: END LOOP;
2486: UTL_FILE.FCLOSE(l_handler_building);

Line 2486: UTL_FILE.FCLOSE(l_handler_building);

2482: UTL_FILE.PUT_LINE(l_handler_building, cur_temp.building_id|| l_column_sep ||
2483: cur_temp.location_cd|| l_column_sep ||cur_temp.building_cd|| l_column_sep ||
2484: cur_temp.description|| l_column_sep ||cur_temp.closed_ind);
2485: END LOOP;
2486: UTL_FILE.FCLOSE(l_handler_building);
2487:
2488: BEGIN
2489: l_handler_location := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_location_fname.meaning))|| l_req_id, 'w');
2490: l_handler_check := UTL_FILE.IS_OPEN(l_handler_location);

Line 2489: l_handler_location := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_location_fname.meaning))|| l_req_id, 'w');

2485: END LOOP;
2486: UTL_FILE.FCLOSE(l_handler_building);
2487:
2488: BEGIN
2489: l_handler_location := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_location_fname.meaning))|| l_req_id, 'w');
2490: l_handler_check := UTL_FILE.IS_OPEN(l_handler_location);
2491: IF (l_handler_check = FALSE ) THEN
2492: RAISE invalid;
2493: END IF;

Line 2490: l_handler_check := UTL_FILE.IS_OPEN(l_handler_location);

2486: UTL_FILE.FCLOSE(l_handler_building);
2487:
2488: BEGIN
2489: l_handler_location := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_location_fname.meaning))|| l_req_id, 'w');
2490: l_handler_check := UTL_FILE.IS_OPEN(l_handler_location);
2491: IF (l_handler_check = FALSE ) THEN
2492: RAISE invalid;
2493: END IF;
2494: EXCEPTION

Line 2505: UTL_FILE.PUT(l_handler_location,cur_temp.location_cd|| l_column_sep ||

2501: -- This was done to modify the location flat file structure , so that it would show the region codes
2502: -- attached to a location code
2503:
2504: FOR cur_temp IN c_location LOOP
2505: UTL_FILE.PUT(l_handler_location,cur_temp.location_cd|| l_column_sep ||
2506: cur_temp.description|| l_column_sep ||cur_temp.location_type || l_column_sep ||
2507: cur_temp.mail_dlvry_wrk_days|| l_column_sep ||cur_temp.coord_person_id
2508: || l_column_sep ||cur_temp.closed_ind);
2509: FOR cur_map IN c_loc_reg_map(cur_temp.location_cd) LOOP

Line 2510: UTL_FILE.PUT(l_handler_location,l_column_sep ||cur_map.region_cd);

2506: cur_temp.description|| l_column_sep ||cur_temp.location_type || l_column_sep ||
2507: cur_temp.mail_dlvry_wrk_days|| l_column_sep ||cur_temp.coord_person_id
2508: || l_column_sep ||cur_temp.closed_ind);
2509: FOR cur_map IN c_loc_reg_map(cur_temp.location_cd) LOOP
2510: UTL_FILE.PUT(l_handler_location,l_column_sep ||cur_map.region_cd);
2511: END LOOP;
2512: UTL_FILE.NEW_LINE(l_handler_location,1);
2513: END LOOP;
2514:

Line 2512: UTL_FILE.NEW_LINE(l_handler_location,1);

2508: || l_column_sep ||cur_temp.closed_ind);
2509: FOR cur_map IN c_loc_reg_map(cur_temp.location_cd) LOOP
2510: UTL_FILE.PUT(l_handler_location,l_column_sep ||cur_map.region_cd);
2511: END LOOP;
2512: UTL_FILE.NEW_LINE(l_handler_location,1);
2513: END LOOP;
2514:
2515: UTL_FILE.FCLOSE(l_handler_location);
2516:

Line 2515: UTL_FILE.FCLOSE(l_handler_location);

2511: END LOOP;
2512: UTL_FILE.NEW_LINE(l_handler_location,1);
2513: END LOOP;
2514:
2515: UTL_FILE.FCLOSE(l_handler_location);
2516:
2517:
2518: -- Added following code as part of bug#2833850 to write preferred region information to the flat file
2519:

Line 2521: l_handler_region := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_reg_fname.meaning))|| l_req_id, 'w');

2517:
2518: -- Added following code as part of bug#2833850 to write preferred region information to the flat file
2519:
2520: BEGIN
2521: l_handler_region := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_reg_fname.meaning))|| l_req_id, 'w');
2522: l_handler_check := UTL_FILE.IS_OPEN(l_handler_region);
2523: IF (l_handler_check = FALSE ) THEN
2524: RAISE invalid;
2525: END IF;

Line 2522: l_handler_check := UTL_FILE.IS_OPEN(l_handler_region);

2518: -- Added following code as part of bug#2833850 to write preferred region information to the flat file
2519:
2520: BEGIN
2521: l_handler_region := UTL_FILE.FOPEN(l_path_var, LTRIM(RTRIM(rec_reg_fname.meaning))|| l_req_id, 'w');
2522: l_handler_check := UTL_FILE.IS_OPEN(l_handler_region);
2523: IF (l_handler_check = FALSE ) THEN
2524: RAISE invalid;
2525: END IF;
2526: EXCEPTION

Line 2533: UTL_FILE.PUT_LINE(l_handler_region, cur_temp.lookup_code|| l_column_sep ||

2529: RAISE invalid;
2530: END;
2531:
2532: FOR cur_temp IN c_region LOOP
2533: UTL_FILE.PUT_LINE(l_handler_region, cur_temp.lookup_code|| l_column_sep ||
2534: cur_temp.meaning|| l_column_sep ||cur_temp.description|| l_column_sep ||
2535: cur_temp.tag|| l_column_sep ||cur_temp.start_date_active|| l_column_sep ||
2536: cur_temp.end_date_active|| l_column_sep ||cur_temp.enabled_flag|| l_column_sep ||cur_temp.closed_ind);
2537: END LOOP;

Line 2539: UTL_FILE.FCLOSE(l_handler_region);

2535: cur_temp.tag|| l_column_sep ||cur_temp.start_date_active|| l_column_sep ||
2536: cur_temp.end_date_active|| l_column_sep ||cur_temp.enabled_flag|| l_column_sep ||cur_temp.closed_ind);
2537: END LOOP;
2538:
2539: UTL_FILE.FCLOSE(l_handler_region);
2540:
2541: l_message :='IGS_PS_SCH_EXP_SUCCESS';
2542: RAISE valid;
2543: