107: NULL;
108: END;
109: END IF;
110:
111: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Insert_Row');
112:
113: -- call table-handler.
114: LNS_APPROVAL_ACTIONS_PKG.Insert_Row(X_ACTION_ID => p_approval_action_rec.action_id
115: ,P_OBJECT_VERSION_NUMBER => 1
110:
111: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Insert_Row');
112:
113: -- call table-handler.
114: LNS_APPROVAL_ACTIONS_PKG.Insert_Row(X_ACTION_ID => p_approval_action_rec.action_id
115: ,P_OBJECT_VERSION_NUMBER => 1
116: ,P_LOAN_ID => p_approval_action_rec.loan_id
117: ,P_ACTION_TYPE => p_approval_action_rec.action_type
118: ,P_AMOUNT => p_approval_action_rec.amount
220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;
222: END;
223:
224: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');
225:
226: -- log history
227: LNS_LOAN_HISTORY_PUB.log_record_pre(p_approval_action_rec.action_id,
228: 'ACTION_ID',
228: 'ACTION_ID',
229: 'LNS_APPROVAL_ACTIONS');
230:
231: --Call to table-handler
232: LNS_APPROVAL_ACTIONS_PKG.Update_Row (X_ACTION_ID => p_approval_action_rec.action_id
233: ,P_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER
234: ,P_LOAN_ID => p_approval_action_rec.LOAN_ID
235: ,P_ACTION_TYPE => p_approval_action_rec.ACTION_TYPE
236: ,P_AMOUNT => p_approval_action_rec.AMOUNT
263: 'ACTION_ID',
264: 'LNS_APPROVAL_ACTIONS',
265: p_approval_action_rec.loan_id);
266:
267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');
268:
269: END do_update_approval_action;
270:
271: /*===========================================================================+
324: RAISE FND_API.G_EXC_ERROR;
325: END;
326: END IF;
327:
328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
329:
330: --Call to table-handler
331: LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID => p_action_id);
332:
327:
328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
329:
330: --Call to table-handler
331: LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID => p_action_id);
332:
333: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
334:
335: END do_delete_approval_action;
329:
330: --Call to table-handler
331: LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID => p_action_id);
332:
333: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
334:
335: END do_delete_approval_action;
336:
337: PROCEDURE validate_loan (