DBA Data[Home] [Help]

APPS.HZ_UTILITY_V2PUB dependencies on UTL_FILE

Line 14: G_FILE UTL_FILE.FILE_TYPE;

10:
11: TYPE VAL_TAB_TYPE IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
12:
13: -- file handler we will use for log file.
14: G_FILE UTL_FILE.FILE_TYPE;
15:
16: -- running in file debug mode.
17: G_FILE_DEBUG BOOLEAN := FALSE;
18: G_FILE_NAME VARCHAR2(100);

Line 498: IF NOT UTL_FILE.is_open( G_FILE ) THEN

494:
495: BEGIN
496:
497: -- Open log file in 'append' mode.
498: IF NOT UTL_FILE.is_open( G_FILE ) THEN
499: G_FILE := UTL_FILE.fopen( G_FILE_PATH, G_FILE_NAME, 'a' );
500: END IF;
501:
502: G_FILE_DEBUG := TRUE;

Line 499: G_FILE := UTL_FILE.fopen( G_FILE_PATH, G_FILE_NAME, 'a' );

495: BEGIN
496:
497: -- Open log file in 'append' mode.
498: IF NOT UTL_FILE.is_open( G_FILE ) THEN
499: G_FILE := UTL_FILE.fopen( G_FILE_PATH, G_FILE_NAME, 'a' );
500: END IF;
501:
502: G_FILE_DEBUG := TRUE;
503:

Line 505: WHEN UTL_FILE.INVALID_PATH THEN

501:
502: G_FILE_DEBUG := TRUE;
503:
504: EXCEPTION
505: WHEN UTL_FILE.INVALID_PATH THEN
506: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_INVALID_PATH' );
507: FND_MESSAGE.SET_TOKEN( 'FILE_DIR', G_FILE_PATH );
508: FND_MSG_PUB.ADD;
509: G_FILE_DEBUG := FALSE;

Line 513: WHEN UTL_FILE.INVALID_MODE THEN

509: G_FILE_DEBUG := FALSE;
510: G_COUNT := 0;
511: RAISE FND_API.G_EXC_ERROR;
512:
513: WHEN UTL_FILE.INVALID_MODE THEN
514: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_INVALID_MODE' );
515: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );
516: FND_MESSAGE.SET_TOKEN( 'FILE_MODE', 'w' );
517: FND_MSG_PUB.ADD;

Line 522: WHEN UTL_FILE.INVALID_OPERATION THEN

518: G_FILE_DEBUG := FALSE;
519: G_COUNT := 0;
520: RAISE FND_API.G_EXC_ERROR;
521:
522: WHEN UTL_FILE.INVALID_OPERATION THEN
523: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_INVALID_OPERATN' );
524: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );
525: FND_MESSAGE.SET_TOKEN( 'TEMP_DIR', G_FILE_PATH );
526: FND_MSG_PUB.ADD;

Line 1153: IF UTL_FILE.is_open( G_FILE ) THEN

1149: RETURN;
1150: END IF;
1151:
1152: IF G_FILE_DEBUG THEN
1153: IF UTL_FILE.is_open( G_FILE ) THEN
1154: BEGIN
1155: UTL_FILE.fclose( G_FILE );
1156: G_FILE_DEBUG := FALSE;
1157: EXCEPTION

Line 1155: UTL_FILE.fclose( G_FILE );

1151:
1152: IF G_FILE_DEBUG THEN
1153: IF UTL_FILE.is_open( G_FILE ) THEN
1154: BEGIN
1155: UTL_FILE.fclose( G_FILE );
1156: G_FILE_DEBUG := FALSE;
1157: EXCEPTION
1158: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1159: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_INVALID_HANDLE' );

Line 1158: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

1154: BEGIN
1155: UTL_FILE.fclose( G_FILE );
1156: G_FILE_DEBUG := FALSE;
1157: EXCEPTION
1158: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1159: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_INVALID_HANDLE' );
1160: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );
1161: FND_MSG_PUB.ADD;
1162: G_FILE_DEBUG := FALSE;

Line 1166: WHEN UTL_FILE.WRITE_ERROR THEN

1162: G_FILE_DEBUG := FALSE;
1163: G_COUNT := 0;
1164: RAISE FND_API.G_EXC_ERROR;
1165:
1166: WHEN UTL_FILE.WRITE_ERROR THEN
1167: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_WRITE_ERROR' );
1168: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );
1169: FND_MSG_PUB.ADD;
1170: G_FILE_DEBUG := FALSE;