3764: EXCEPTION WHEN OTHERS THEN
3765: l_prod_timestamp := NULL;
3766: END;
3767:
3768: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_PROD');
3769: FND_MESSAGE.SET_TOKEN('TIMESTAMP', l_prod_timestamp);
3770: ELSE
3771: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3772: END IF;
3765: l_prod_timestamp := NULL;
3766: END;
3767:
3768: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_PROD');
3769: FND_MESSAGE.SET_TOKEN('TIMESTAMP', l_prod_timestamp);
3770: ELSE
3771: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3772: END IF;
3773:
3767:
3768: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_PROD');
3769: FND_MESSAGE.SET_TOKEN('TIMESTAMP', l_prod_timestamp);
3770: ELSE
3771: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3772: END IF;
3773:
3774: FND_MESSAGE.SET_TOKEN('SS_REF', p_item_detail_tbl(i).SOURCE_SYSTEM_REFERENCE);
3775: l_msg_text := FND_MESSAGE.GET;
3770: ELSE
3771: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3772: END IF;
3773:
3774: FND_MESSAGE.SET_TOKEN('SS_REF', p_item_detail_tbl(i).SOURCE_SYSTEM_REFERENCE);
3775: l_msg_text := FND_MESSAGE.GET;
3776:
3777: INSERT INTO MTL_INTERFACE_ERRORS
3778: (
3771: FND_MESSAGE.SET_NAME('EGO', 'EGO_TIMESTAMP_GREATER_IN_BATCH');
3772: END IF;
3773:
3774: FND_MESSAGE.SET_TOKEN('SS_REF', p_item_detail_tbl(i).SOURCE_SYSTEM_REFERENCE);
3775: l_msg_text := FND_MESSAGE.GET;
3776:
3777: INSERT INTO MTL_INTERFACE_ERRORS
3778: (
3779: TRANSACTION_ID,