DBA Data[Home] [Help]

APPS.JTF_TAE_ASSIGN_PUB dependencies on UTL_FILE

Line 1213: WHEN utl_file.invalid_path OR

1209: SQLERRM;
1210:
1211: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1212:
1213: WHEN utl_file.invalid_path OR
1214: utl_file.invalid_mode OR
1215: utl_file.invalid_filehandle OR
1216: utl_file.invalid_operation OR
1217: utl_file.write_error THEN

Line 1214: utl_file.invalid_mode OR

1210:
1211: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1212:
1213: WHEN utl_file.invalid_path OR
1214: utl_file.invalid_mode OR
1215: utl_file.invalid_filehandle OR
1216: utl_file.invalid_operation OR
1217: utl_file.write_error THEN
1218:

Line 1215: utl_file.invalid_filehandle OR

1211: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1212:
1213: WHEN utl_file.invalid_path OR
1214: utl_file.invalid_mode OR
1215: utl_file.invalid_filehandle OR
1216: utl_file.invalid_operation OR
1217: utl_file.write_error THEN
1218:
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1216: utl_file.invalid_operation OR

1212:
1213: WHEN utl_file.invalid_path OR
1214: utl_file.invalid_mode OR
1215: utl_file.invalid_filehandle OR
1216: utl_file.invalid_operation OR
1217: utl_file.write_error THEN
1218:
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: RETCODE := 2;

Line 1217: utl_file.write_error THEN

1213: WHEN utl_file.invalid_path OR
1214: utl_file.invalid_mode OR
1215: utl_file.invalid_filehandle OR
1216: utl_file.invalid_operation OR
1217: utl_file.write_error THEN
1218:
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: RETCODE := 2;
1221: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||

Line 1221: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||

1217: utl_file.write_error THEN
1218:
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: RETCODE := 2;
1221: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||
1222: SQLERRM;
1223:
1224: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1225:

Line 1360: WHEN utl_file.invalid_path OR

1356: 'FND_API.G_EXC_UNEXPECTED_ERROR: ' ||
1357: SQLERRM;
1358: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1359:
1360: WHEN utl_file.invalid_path OR
1361: utl_file.invalid_mode OR
1362: utl_file.invalid_filehandle OR
1363: Utl_file.invalid_operation OR
1364: utl_file.write_error THEN

Line 1361: utl_file.invalid_mode OR

1357: SQLERRM;
1358: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1359:
1360: WHEN utl_file.invalid_path OR
1361: utl_file.invalid_mode OR
1362: utl_file.invalid_filehandle OR
1363: Utl_file.invalid_operation OR
1364: utl_file.write_error THEN
1365:

Line 1362: utl_file.invalid_filehandle OR

1358: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1359:
1360: WHEN utl_file.invalid_path OR
1361: utl_file.invalid_mode OR
1362: utl_file.invalid_filehandle OR
1363: Utl_file.invalid_operation OR
1364: utl_file.write_error THEN
1365:
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1363: Utl_file.invalid_operation OR

1359:
1360: WHEN utl_file.invalid_path OR
1361: utl_file.invalid_mode OR
1362: utl_file.invalid_filehandle OR
1363: Utl_file.invalid_operation OR
1364: utl_file.write_error THEN
1365:
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: RETCODE := 2;

Line 1364: utl_file.write_error THEN

1360: WHEN utl_file.invalid_path OR
1361: utl_file.invalid_mode OR
1362: utl_file.invalid_filehandle OR
1363: Utl_file.invalid_operation OR
1364: utl_file.write_error THEN
1365:
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: RETCODE := 2;
1368: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] UTL_FILE: ' ||

Line 1368: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] UTL_FILE: ' ||

1364: utl_file.write_error THEN
1365:
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: RETCODE := 2;
1368: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] UTL_FILE: ' ||
1369: SQLERRM;
1370:
1371: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1372:

Line 1734: WHEN utl_file.invalid_path OR

1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: RETCODE := 2;
1732: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1733:
1734: WHEN utl_file.invalid_path OR
1735: utl_file.invalid_mode OR
1736: utl_file.invalid_filehandle OR
1737: Utl_file.invalid_operation OR
1738: utl_file.write_error THEN

Line 1735: utl_file.invalid_mode OR

1731: RETCODE := 2;
1732: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1733:
1734: WHEN utl_file.invalid_path OR
1735: utl_file.invalid_mode OR
1736: utl_file.invalid_filehandle OR
1737: Utl_file.invalid_operation OR
1738: utl_file.write_error THEN
1739:

Line 1736: utl_file.invalid_filehandle OR

1732: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1733:
1734: WHEN utl_file.invalid_path OR
1735: utl_file.invalid_mode OR
1736: utl_file.invalid_filehandle OR
1737: Utl_file.invalid_operation OR
1738: utl_file.write_error THEN
1739:
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1737: Utl_file.invalid_operation OR

1733:
1734: WHEN utl_file.invalid_path OR
1735: utl_file.invalid_mode OR
1736: utl_file.invalid_filehandle OR
1737: Utl_file.invalid_operation OR
1738: utl_file.write_error THEN
1739:
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: RETCODE := 2;

Line 1738: utl_file.write_error THEN

1734: WHEN utl_file.invalid_path OR
1735: utl_file.invalid_mode OR
1736: utl_file.invalid_filehandle OR
1737: Utl_file.invalid_operation OR
1738: utl_file.write_error THEN
1739:
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: RETCODE := 2;
1742: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] UTL_FILE: ' ||

Line 1742: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] UTL_FILE: ' ||

1738: utl_file.write_error THEN
1739:
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: RETCODE := 2;
1742: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] UTL_FILE: ' ||
1743: SQLERRM;
1744: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1745:
1746: WHEN OTHERS THEN

Line 2278: WHEN utl_file.invalid_path OR

2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: RETCODE := 2;
2276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2277:
2278: WHEN utl_file.invalid_path OR
2279: utl_file.invalid_mode OR
2280: utl_file.invalid_filehandle OR
2281: utl_file.invalid_operation OR
2282: utl_file.write_error THEN

Line 2279: utl_file.invalid_mode OR

2275: RETCODE := 2;
2276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2277:
2278: WHEN utl_file.invalid_path OR
2279: utl_file.invalid_mode OR
2280: utl_file.invalid_filehandle OR
2281: utl_file.invalid_operation OR
2282: utl_file.write_error THEN
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2280: utl_file.invalid_filehandle OR

2276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2277:
2278: WHEN utl_file.invalid_path OR
2279: utl_file.invalid_mode OR
2280: utl_file.invalid_filehandle OR
2281: utl_file.invalid_operation OR
2282: utl_file.write_error THEN
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2284: RETCODE := 2;

Line 2281: utl_file.invalid_operation OR

2277:
2278: WHEN utl_file.invalid_path OR
2279: utl_file.invalid_mode OR
2280: utl_file.invalid_filehandle OR
2281: utl_file.invalid_operation OR
2282: utl_file.write_error THEN
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2284: RETCODE := 2;
2285: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] UTL_FILE: ' ||

Line 2282: utl_file.write_error THEN

2278: WHEN utl_file.invalid_path OR
2279: utl_file.invalid_mode OR
2280: utl_file.invalid_filehandle OR
2281: utl_file.invalid_operation OR
2282: utl_file.write_error THEN
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2284: RETCODE := 2;
2285: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] UTL_FILE: ' ||
2286: SQLERRM;

Line 2285: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] UTL_FILE: ' ||

2281: utl_file.invalid_operation OR
2282: utl_file.write_error THEN
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2284: RETCODE := 2;
2285: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] UTL_FILE: ' ||
2286: SQLERRM;
2287: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2288: WHEN OTHERS THEN
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3119: WHEN utl_file.invalid_path OR

3115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3116: RETCODE := 2;
3117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3118:
3119: WHEN utl_file.invalid_path OR
3120: utl_file.invalid_mode OR
3121: utl_file.invalid_filehandle OR
3122: utl_file.invalid_operation OR
3123: utl_file.write_error THEN

Line 3120: utl_file.invalid_mode OR

3116: RETCODE := 2;
3117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3118:
3119: WHEN utl_file.invalid_path OR
3120: utl_file.invalid_mode OR
3121: utl_file.invalid_filehandle OR
3122: utl_file.invalid_operation OR
3123: utl_file.write_error THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3121: utl_file.invalid_filehandle OR

3117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3118:
3119: WHEN utl_file.invalid_path OR
3120: utl_file.invalid_mode OR
3121: utl_file.invalid_filehandle OR
3122: utl_file.invalid_operation OR
3123: utl_file.write_error THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: RETCODE := 2;

Line 3122: utl_file.invalid_operation OR

3118:
3119: WHEN utl_file.invalid_path OR
3120: utl_file.invalid_mode OR
3121: utl_file.invalid_filehandle OR
3122: utl_file.invalid_operation OR
3123: utl_file.write_error THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: RETCODE := 2;
3126: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] UTL_FILE: ' ||

Line 3123: utl_file.write_error THEN

3119: WHEN utl_file.invalid_path OR
3120: utl_file.invalid_mode OR
3121: utl_file.invalid_filehandle OR
3122: utl_file.invalid_operation OR
3123: utl_file.write_error THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: RETCODE := 2;
3126: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] UTL_FILE: ' ||
3127: SQLERRM;

Line 3126: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] UTL_FILE: ' ||

3122: utl_file.invalid_operation OR
3123: utl_file.write_error THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: RETCODE := 2;
3126: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] UTL_FILE: ' ||
3127: SQLERRM;
3128: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3129:
3130: WHEN OTHERS THEN

Line 3639: WHEN utl_file.invalid_path OR

3635: 'LOWER LEVEL = ' || p_LOWER_LEVEL_FROM_ROOT || ' :' ||
3636: SQLERRM;
3637: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3638:
3639: WHEN utl_file.invalid_path OR
3640: utl_file.invalid_mode OR
3641: utl_file.invalid_filehandle OR
3642: utl_file.invalid_operation OR
3643: utl_file.write_error THEN

Line 3640: utl_file.invalid_mode OR

3636: SQLERRM;
3637: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3638:
3639: WHEN utl_file.invalid_path OR
3640: utl_file.invalid_mode OR
3641: utl_file.invalid_filehandle OR
3642: utl_file.invalid_operation OR
3643: utl_file.write_error THEN
3644:

Line 3641: utl_file.invalid_filehandle OR

3637: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3638:
3639: WHEN utl_file.invalid_path OR
3640: utl_file.invalid_mode OR
3641: utl_file.invalid_filehandle OR
3642: utl_file.invalid_operation OR
3643: utl_file.write_error THEN
3644:
3645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3642: utl_file.invalid_operation OR

3638:
3639: WHEN utl_file.invalid_path OR
3640: utl_file.invalid_mode OR
3641: utl_file.invalid_filehandle OR
3642: utl_file.invalid_operation OR
3643: utl_file.write_error THEN
3644:
3645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3646: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||

Line 3643: utl_file.write_error THEN

3639: WHEN utl_file.invalid_path OR
3640: utl_file.invalid_mode OR
3641: utl_file.invalid_filehandle OR
3642: utl_file.invalid_operation OR
3643: utl_file.write_error THEN
3644:
3645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3646: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||
3647: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||

Line 3646: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||

3642: utl_file.invalid_operation OR
3643: utl_file.write_error THEN
3644:
3645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3646: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||
3647: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||
3648: 'LOWER LEVEL = ' || p_LOWER_LEVEL_FROM_ROOT || ' :' ||
3649: SQLERRM;
3650: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 3819: WHEN utl_file.invalid_path OR

3815: '[END] FND_API.G_EXC_UNEXPECTED_ERROR: ' ||
3816: SQLERRM;
3817: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3818:
3819: WHEN utl_file.invalid_path OR
3820: utl_file.invalid_mode OR
3821: utl_file.invalid_filehandle OR
3822: utl_file.invalid_operation OR
3823: utl_file.write_error THEN

Line 3820: utl_file.invalid_mode OR

3816: SQLERRM;
3817: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3818:
3819: WHEN utl_file.invalid_path OR
3820: utl_file.invalid_mode OR
3821: utl_file.invalid_filehandle OR
3822: utl_file.invalid_operation OR
3823: utl_file.write_error THEN
3824:

Line 3821: utl_file.invalid_filehandle OR

3817: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3818:
3819: WHEN utl_file.invalid_path OR
3820: utl_file.invalid_mode OR
3821: utl_file.invalid_filehandle OR
3822: utl_file.invalid_operation OR
3823: utl_file.write_error THEN
3824:
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3822: utl_file.invalid_operation OR

3818:
3819: WHEN utl_file.invalid_path OR
3820: utl_file.invalid_mode OR
3821: utl_file.invalid_filehandle OR
3822: utl_file.invalid_operation OR
3823: utl_file.write_error THEN
3824:
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3826: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] UTL_FILE: ' ||

Line 3823: utl_file.write_error THEN

3819: WHEN utl_file.invalid_path OR
3820: utl_file.invalid_mode OR
3821: utl_file.invalid_filehandle OR
3822: utl_file.invalid_operation OR
3823: utl_file.write_error THEN
3824:
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3826: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] UTL_FILE: ' ||
3827: SQLERRM;

Line 3826: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] UTL_FILE: ' ||

3822: utl_file.invalid_operation OR
3823: utl_file.write_error THEN
3824:
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3826: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] UTL_FILE: ' ||
3827: SQLERRM;
3828: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3829:
3830: WHEN OTHERS THEN