APPS.OKI_ALERT_UTIL_PVT dependencies on UTL_FILE

Line 154: -- UTL_FILE.PUT_LINE(g_output_stream,p_str);

150:
151: PROCEDURE myprint(p_str IN VARCHAR2)
152: IS
153: BEGIN
154: -- UTL_FILE.PUT_LINE(g_output_stream,p_str);
155: fnd_file.put_line( which => fnd_file.output
156: , buff => p_str);
157:
158: END; -- myprint

Line 333: -- g_output_stream := UTL_FILE.FOPEN(g_utl_file_dest,

329: FUNCTION set_output_stream(p_file_name IN VARCHAR2)
330: RETURN BOOLEAN
331: IS
332: BEGIN
333: -- g_output_stream := UTL_FILE.FOPEN(g_utl_file_dest,
334: -- p_file_name,'W');
335: fnd_file.put_line( which => fnd_file.output
336: , buff => 'FILEOKI: '||p_file_name);
337:

Line 340: WHEN UTL_FILE.INVALID_PATH THEN

336: , buff => 'FILEOKI: '||p_file_name);
337:
338: RETURN TRUE;
339: EXCEPTION
340: WHEN UTL_FILE.INVALID_PATH THEN
341: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
342: RETURN FALSE;
343:
344: WHEN UTL_FILE.INVALID_MODE THEN

Line 344: WHEN UTL_FILE.INVALID_MODE THEN

340: WHEN UTL_FILE.INVALID_PATH THEN
341: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
342: RETURN FALSE;
343:
344: WHEN UTL_FILE.INVALID_MODE THEN
345: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
346: RETURN FALSE;
347:
348: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 348: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

344: WHEN UTL_FILE.INVALID_MODE THEN
345: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
346: RETURN FALSE;
347:
348: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
349: RAISE_APPLICATION_ERROR(-20102,'Invalid Filehandle');
350: RETURN FALSE;
351:
352: WHEN UTL_FILE.INVALID_OPERATION THEN

Line 352: WHEN UTL_FILE.INVALID_OPERATION THEN

348: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
349: RAISE_APPLICATION_ERROR(-20102,'Invalid Filehandle');
350: RETURN FALSE;
351:
352: WHEN UTL_FILE.INVALID_OPERATION THEN
353: RAISE_APPLICATION_ERROR(-20103,'Invalid Operation -- May signal a file locked by the OS');
354: RETURN FALSE;
355:
356: WHEN UTL_FILE.WRITE_ERROR THEN

Line 356: WHEN UTL_FILE.WRITE_ERROR THEN

352: WHEN UTL_FILE.INVALID_OPERATION THEN
353: RAISE_APPLICATION_ERROR(-20103,'Invalid Operation -- May signal a file locked by the OS');
354: RETURN FALSE;
355:
356: WHEN UTL_FILE.WRITE_ERROR THEN
357: RAISE_APPLICATION_ERROR(-20105,'Write Error');
358: RETURN FALSE;
359:
360: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 360: WHEN UTL_FILE.INTERNAL_ERROR THEN

356: WHEN UTL_FILE.WRITE_ERROR THEN
357: RAISE_APPLICATION_ERROR(-20105,'Write Error');
358: RETURN FALSE;
359:
360: WHEN UTL_FILE.INTERNAL_ERROR THEN
361: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
362: RETURN FALSE;
363:
364: WHEN OTHERS THEN

Line 365: RAISE_APPLICATION_ERROR(-20109,'Unknown UTL_FILE Error');

361: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
362: RETURN FALSE;
363:
364: WHEN OTHERS THEN
365: RAISE_APPLICATION_ERROR(-20109,'Unknown UTL_FILE Error');
366: RETURN FALSE;
367: END;
368: -- 1. Success
369: -- 0. Failure

Line 373: -- UTL_FILE.FCLOSE(g_output_stream);

369: -- 0. Failure
370: PROCEDURE end_output_stream
371: IS
372: BEGIN
373: -- UTL_FILE.FCLOSE(g_output_stream);
374: NULL;
375: END;
376:
377: PROCEDURE print_error(p_string IN VARCHAR2)

Line 463: g_utl_file_dest := fnd_profile.value('OKI_UTL_FILE_DEST');

459: BEGIN
460: -- Initialization Block
461: g_alert_dist_list := fnd_profile.value('OKI_ALERT_DIST_LIST');
462: g_alert_publish_dir := fnd_profile.value('OKI_ALERT_PUBLISH_DIR');
463: g_utl_file_dest := fnd_profile.value('OKI_UTL_FILE_DEST');
464: g_oki_parent_url := fnd_profile.value('OKI_ALERT_URL');
465:
466: fnd_file.put_line( which => fnd_file.log
467: , buff => 'Alert Dist List :'||g_alert_dist_list);

Line 471: , buff => 'Utl File Dest :'||g_utl_file_dest);

467: , buff => 'Alert Dist List :'||g_alert_dist_list);
468: fnd_file.put_line( which => fnd_file.log
469: , buff => 'Alert Publish Dir :'||g_alert_publish_dir);
470: fnd_file.put_line( which => fnd_file.log
471: , buff => 'Utl File Dest :'||g_utl_file_dest);
472: fnd_file.put_line( which => fnd_file.log
473: , buff => 'Alert URL :'||g_oki_parent_url);
474:
475: END; -- Package Body OKI_ALERT_UTIL_PVT