[Home] [Help]
1290: CLOSE rej_reason;
1291:
1292: END IF;
1293:
1294: INSERT INTO PA_DISTRIBUTION_WARNINGS
1295: (
1296: PROJECT_ID, AGREEMENT_ID, TASK_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1297: CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID,
1298: PROGRAM_ID, PROGRAM_UPDATE_DATE, WARNING_MESSAGE_CODE, WARNING_MESSAGE
1618: error code /messages defined specifically for it. Also dependent
1619: on budget model */
1620: /*Bug 3986205 : Replaced p_project_id with G_ProjLvlGlobRec.project_id in the following INSERT statement */
1621:
1622: INSERT INTO PA_DISTRIBUTION_WARNINGS
1623: (
1624: PROJECT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1625: CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID,
1626: PROGRAM_ID, PROGRAM_UPDATE_DATE, WARNING_MESSAGE_CODE, WARNING_MESSAGE
9934: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9935:
9936: END IF;
9937:
9938: DELETE from pa_distribution_warnings
9939: WHERE request_id = p_request_id;
9940:
9941: COMMIT;
9942: