3561: EXCEPTION WHEN OTHERS THEN
3562: l_prod_timestamp := NULL;
3563: END;
3564:
3565: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_PROD');
3566: FND_MESSAGE.SET_TOKEN('TIMESTAMP', l_prod_timestamp);
3567: ELSE
3568: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3569: END IF;
3562: l_prod_timestamp := NULL;
3563: END;
3564:
3565: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_PROD');
3566: FND_MESSAGE.SET_TOKEN('TIMESTAMP', l_prod_timestamp);
3567: ELSE
3568: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3569: END IF;
3570:
3564:
3565: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_PROD');
3566: FND_MESSAGE.SET_TOKEN('TIMESTAMP', l_prod_timestamp);
3567: ELSE
3568: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3569: END IF;
3570:
3571: FND_MESSAGE.SET_TOKEN('SS_REF', p_item_detail_tbl(i).SOURCE_SYSTEM_REFERENCE);
3572: l_msg_text := FND_MESSAGE.GET;
3567: ELSE
3568: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3569: END IF;
3570:
3571: FND_MESSAGE.SET_TOKEN('SS_REF', p_item_detail_tbl(i).SOURCE_SYSTEM_REFERENCE);
3572: l_msg_text := FND_MESSAGE.GET;
3573:
3574: INSERT INTO MTL_INTERFACE_ERRORS
3575: (
3568: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3569: END IF;
3570:
3571: FND_MESSAGE.SET_TOKEN('SS_REF', p_item_detail_tbl(i).SOURCE_SYSTEM_REFERENCE);
3572: l_msg_text := FND_MESSAGE.GET;
3573:
3574: INSERT INTO MTL_INTERFACE_ERRORS
3575: (
3576: TRANSACTION_ID,