726:
727: JTF_TAE_CONTROL_PVT.Write_Log(2, ERRBUF);
728:
729:
730: WHEN utl_file.invalid_path OR
731: utl_file.invalid_mode OR
732: utl_file.invalid_filehandle OR
733: utl_file.invalid_operation OR
734: utl_file.write_error THEN
727: JTF_TAE_CONTROL_PVT.Write_Log(2, ERRBUF);
728:
729:
730: WHEN utl_file.invalid_path OR
731: utl_file.invalid_mode OR
732: utl_file.invalid_filehandle OR
733: utl_file.invalid_operation OR
734: utl_file.write_error THEN
735:
728:
729:
730: WHEN utl_file.invalid_path OR
731: utl_file.invalid_mode OR
732: utl_file.invalid_filehandle OR
733: utl_file.invalid_operation OR
734: utl_file.write_error THEN
735:
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
729:
730: WHEN utl_file.invalid_path OR
731: utl_file.invalid_mode OR
732: utl_file.invalid_filehandle OR
733: utl_file.invalid_operation OR
734: utl_file.write_error THEN
735:
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
737: RETCODE := 2;
730: WHEN utl_file.invalid_path OR
731: utl_file.invalid_mode OR
732: utl_file.invalid_filehandle OR
733: utl_file.invalid_operation OR
734: utl_file.write_error THEN
735:
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
737: RETCODE := 2;
738: ERRBUF := 'JTF_TAE_CONTROL.Classify_Territories: [END] UTL_FILE: ' ||
734: utl_file.write_error THEN
735:
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
737: RETCODE := 2;
738: ERRBUF := 'JTF_TAE_CONTROL.Classify_Territories: [END] UTL_FILE: ' ||
739: SQLERRM;
740:
741: JTF_TAE_CONTROL_PVT.Write_Log(2, ERRBUF);
742:
1024: IF G_Debug THEN
1025: Write_Log(2, ERRBUF);
1026: END IF;
1027:
1028: WHEN utl_file.invalid_path OR
1029: utl_file.invalid_mode OR
1030: utl_file.invalid_filehandle OR
1031: utl_file.invalid_operation OR
1032: utl_file.write_error THEN
1025: Write_Log(2, ERRBUF);
1026: END IF;
1027:
1028: WHEN utl_file.invalid_path OR
1029: utl_file.invalid_mode OR
1030: utl_file.invalid_filehandle OR
1031: utl_file.invalid_operation OR
1032: utl_file.write_error THEN
1033:
1026: END IF;
1027:
1028: WHEN utl_file.invalid_path OR
1029: utl_file.invalid_mode OR
1030: utl_file.invalid_filehandle OR
1031: utl_file.invalid_operation OR
1032: utl_file.write_error THEN
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1027:
1028: WHEN utl_file.invalid_path OR
1029: utl_file.invalid_mode OR
1030: utl_file.invalid_filehandle OR
1031: utl_file.invalid_operation OR
1032: utl_file.write_error THEN
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: RETCODE := 2;
1028: WHEN utl_file.invalid_path OR
1029: utl_file.invalid_mode OR
1030: utl_file.invalid_filehandle OR
1031: utl_file.invalid_operation OR
1032: utl_file.write_error THEN
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: RETCODE := 2;
1036: ERRBUF := 'JTF_TAE_CONTROL.Reduce_TX_OIN_Index_Set: [END] UTL_FILE: ' ||
1032: utl_file.write_error THEN
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: RETCODE := 2;
1036: ERRBUF := 'JTF_TAE_CONTROL.Reduce_TX_OIN_Index_Set: [END] UTL_FILE: ' ||
1037: SQLERRM;
1038:
1039: If G_Debug Then
1040: Write_Log(2, ERRBUF);
1302: IF G_Debug THEN
1303: Write_Log(2, ERRBUF);
1304: END IF;
1305:
1306: WHEN utl_file.invalid_path OR
1307: utl_file.invalid_mode OR
1308: utl_file.invalid_filehandle OR
1309: utl_file.invalid_operation OR
1310: utl_file.write_error THEN
1303: Write_Log(2, ERRBUF);
1304: END IF;
1305:
1306: WHEN utl_file.invalid_path OR
1307: utl_file.invalid_mode OR
1308: utl_file.invalid_filehandle OR
1309: utl_file.invalid_operation OR
1310: utl_file.write_error THEN
1311:
1304: END IF;
1305:
1306: WHEN utl_file.invalid_path OR
1307: utl_file.invalid_mode OR
1308: utl_file.invalid_filehandle OR
1309: utl_file.invalid_operation OR
1310: utl_file.write_error THEN
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305:
1306: WHEN utl_file.invalid_path OR
1307: utl_file.invalid_mode OR
1308: utl_file.invalid_filehandle OR
1309: utl_file.invalid_operation OR
1310: utl_file.write_error THEN
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313: RETCODE := 2;
1306: WHEN utl_file.invalid_path OR
1307: utl_file.invalid_mode OR
1308: utl_file.invalid_filehandle OR
1309: utl_file.invalid_operation OR
1310: utl_file.write_error THEN
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313: RETCODE := 2;
1314: ERRBUF := 'JTF_TAE_CONTROL.Decompose_Terr_Defns: [END] UTL_FILE: ' ||
1310: utl_file.write_error THEN
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313: RETCODE := 2;
1314: ERRBUF := 'JTF_TAE_CONTROL.Decompose_Terr_Defns: [END] UTL_FILE: ' ||
1315: SQLERRM;
1316:
1317: If G_Debug Then
1318: Write_Log(2, ERRBUF);
1387: NULL;
1388:
1389: EXCEPTION
1390:
1391: WHEN utl_file.invalid_path OR
1392: utl_file.invalid_mode OR
1393: utl_file.invalid_filehandle OR
1394: utl_file.invalid_operation OR
1395: utl_file.write_error THEN
1388:
1389: EXCEPTION
1390:
1391: WHEN utl_file.invalid_path OR
1392: utl_file.invalid_mode OR
1393: utl_file.invalid_filehandle OR
1394: utl_file.invalid_operation OR
1395: utl_file.write_error THEN
1396:
1389: EXCEPTION
1390:
1391: WHEN utl_file.invalid_path OR
1392: utl_file.invalid_mode OR
1393: utl_file.invalid_filehandle OR
1394: utl_file.invalid_operation OR
1395: utl_file.write_error THEN
1396:
1397: RETCODE := 2;
1390:
1391: WHEN utl_file.invalid_path OR
1392: utl_file.invalid_mode OR
1393: utl_file.invalid_filehandle OR
1394: utl_file.invalid_operation OR
1395: utl_file.write_error THEN
1396:
1397: RETCODE := 2;
1398: ERRBUF := 'JTF_TAE_CONTROL_PVT.set_session_parameters: [END] UTL_FILE: ' ||
1391: WHEN utl_file.invalid_path OR
1392: utl_file.invalid_mode OR
1393: utl_file.invalid_filehandle OR
1394: utl_file.invalid_operation OR
1395: utl_file.write_error THEN
1396:
1397: RETCODE := 2;
1398: ERRBUF := 'JTF_TAE_CONTROL_PVT.set_session_parameters: [END] UTL_FILE: ' ||
1399: SQLERRM;
1394: utl_file.invalid_operation OR
1395: utl_file.write_error THEN
1396:
1397: RETCODE := 2;
1398: ERRBUF := 'JTF_TAE_CONTROL_PVT.set_session_parameters: [END] UTL_FILE: ' ||
1399: SQLERRM;
1400:
1401: If G_Debug Then
1402: Write_Log(2, ERRBUF);
1452: dbms_sql.close_cursor(l_dyn_csr);
1453:
1454: EXCEPTION
1455:
1456: WHEN utl_file.invalid_path OR
1457: utl_file.invalid_mode OR
1458: utl_file.invalid_filehandle OR
1459: utl_file.invalid_operation OR
1460: utl_file.write_error THEN
1453:
1454: EXCEPTION
1455:
1456: WHEN utl_file.invalid_path OR
1457: utl_file.invalid_mode OR
1458: utl_file.invalid_filehandle OR
1459: utl_file.invalid_operation OR
1460: utl_file.write_error THEN
1461:
1454: EXCEPTION
1455:
1456: WHEN utl_file.invalid_path OR
1457: utl_file.invalid_mode OR
1458: utl_file.invalid_filehandle OR
1459: utl_file.invalid_operation OR
1460: utl_file.write_error THEN
1461:
1462: RETCODE := 2;
1455:
1456: WHEN utl_file.invalid_path OR
1457: utl_file.invalid_mode OR
1458: utl_file.invalid_filehandle OR
1459: utl_file.invalid_operation OR
1460: utl_file.write_error THEN
1461:
1462: RETCODE := 2;
1463: ERRBUF := 'JTF_TAE_CONTROL_PVT.set_table_nologging: [END] UTL_FILE: ' ||
1456: WHEN utl_file.invalid_path OR
1457: utl_file.invalid_mode OR
1458: utl_file.invalid_filehandle OR
1459: utl_file.invalid_operation OR
1460: utl_file.write_error THEN
1461:
1462: RETCODE := 2;
1463: ERRBUF := 'JTF_TAE_CONTROL_PVT.set_table_nologging: [END] UTL_FILE: ' ||
1464: SQLERRM;
1459: utl_file.invalid_operation OR
1460: utl_file.write_error THEN
1461:
1462: RETCODE := 2;
1463: ERRBUF := 'JTF_TAE_CONTROL_PVT.set_table_nologging: [END] UTL_FILE: ' ||
1464: SQLERRM;
1465:
1466: If G_Debug Then
1467: Write_Log(2, ERRBUF);