616: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'Insert Warning ');
617: END IF;
618:
619:
620: INSERT INTO PA_DISTRIBUTION_WARNINGS (
621: DRAFT_INVOICE_NUM, PROJECT_ID,
622: LAST_UPDATE_DATE, LAST_UPDATED_BY,
623: CREATION_DATE, CREATED_BY,
624: REQUEST_ID, PROGRAM_APPLICATION_ID,
634: -- This insert is for project level rejection reason. This will be shown
635: -- in the invoice exception report
636: IF NVL(TmpRetnBillInvFmtID,0) = 0 THEN
637:
638: INSERT INTO PA_DISTRIBUTION_WARNINGS (
639: DRAFT_INVOICE_NUM, PROJECT_ID,
640: LAST_UPDATE_DATE, LAST_UPDATED_BY,
641: CREATION_DATE, CREATED_BY,
642: REQUEST_ID, PROGRAM_APPLICATION_ID,
2060: pa_retention_util.write_log('Invoice_Generation_Exceptions: ' || 'Insert Warning ');
2061: END IF;
2062:
2063:
2064: INSERT INTO PA_DISTRIBUTION_WARNINGS (
2065: DRAFT_INVOICE_NUM, PROJECT_ID,
2066: LAST_UPDATE_DATE, LAST_UPDATED_BY,
2067: CREATION_DATE, CREATED_BY,
2068: REQUEST_ID, PROGRAM_APPLICATION_ID,