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
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:
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;
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;
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: ' ||
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:
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
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:
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;
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;
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: ' ||
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:
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
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:
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;
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;
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: ' ||
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
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
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;
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;
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: ' ||
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;
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 ;
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
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;
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;
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: ' ||
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;
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
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
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:
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;
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: ' ||
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 || ' ' ||
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);
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
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:
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;
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: ' ||
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;
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