427:
428: EXCEPTION
429: WHEN OTHERS THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
432: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
433: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
434: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
435: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
428: EXCEPTION
429: WHEN OTHERS THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
432: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
433: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
434: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
435: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
436: ,p_count => x_msg_count
429: WHEN OTHERS THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
432: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
433: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
434: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
435: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
436: ,p_count => x_msg_count
437: ,p_data => x_msg_data);
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
432: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_OPEN_INTERFACE_PVT');
433: FND_MESSAGE.Set_Token('API_NAME', 'Write_Error_into_ConcurrentLog');
434: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
435: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
436: ,p_count => x_msg_count
437: ,p_data => x_msg_data);
438: END Write_Error_into_ConcurrentLog;
724: --For Error Link Display in the Conc. Req Log
725: --Bug# 4540712 (RSOUNDAR)
726: ---------------------------------------------
727: IF NVL(l_request_id, -1) <> -1 THEN
728: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
729: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
725: --Bug# 4540712 (RSOUNDAR)
726: ---------------------------------------------
727: IF NVL(l_request_id, -1) <> -1 THEN
728: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
729: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
726: ---------------------------------------------
727: IF NVL(l_request_id, -1) <> -1 THEN
728: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
729: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
727: IF NVL(l_request_id, -1) <> -1 THEN
728: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
729: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
728: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
729: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
729: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');