487:
488: EXCEPTION
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
492: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
493: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
494: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
488: EXCEPTION
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
492: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
493: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
494: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
496: ,p_count => x_msg_count
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
492: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
493: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
494: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
496: ,p_count => x_msg_count
497: ,p_data => x_msg_data);
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
492: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
493: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
494: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
496: ,p_count => x_msg_count
497: ,p_data => x_msg_data);
498: END Write_Error_into_ConcurrentLog;
784: --For Error Link Display in the Conc. Req Log
785: --Bug# 4540712 (RSOUNDAR)
786: ---------------------------------------------
787: IF NVL(l_request_id, -1) <> -1 THEN
788: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
785: --Bug# 4540712 (RSOUNDAR)
786: ---------------------------------------------
787: IF NVL(l_request_id, -1) <> -1 THEN
788: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
786: ---------------------------------------------
787: IF NVL(l_request_id, -1) <> -1 THEN
788: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
787: IF NVL(l_request_id, -1) <> -1 THEN
788: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
788: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
799: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');