eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_APPROVAL_ACTION_PUB dependencies on FND_LOG

Line 24: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

20: is
21:
22: begin
23:
24: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
25: FND_LOG.STRING(log_level, module, message);
26: END IF;
27:
28: end;

Line 25: FND_LOG.STRING(log_level, module, message);

21:
22: begin
23:
24: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
25: FND_LOG.STRING(log_level, module, message);
26: END IF;
27:
28: end;
29:

Line 88: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_approval_action procedure');

84: l_msg_data VARCHAR2(2000);
85:
86: BEGIN
87: l_action_id := p_approval_action_rec.action_id;
88: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_approval_action procedure');
89:
90: -- if primary key value is passed, check for uniqueness.
91: IF l_action_id IS NOT NULL AND
92: l_action_id <> FND_API.G_MISS_NUM

Line 111: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Insert_Row');

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

Line 144: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: After call to LNS_APPROVAL_ACTION.Insert_Row');

140: ,P_ATTRIBUTE20 => p_approval_action_rec.attribute20);
141:
142: x_action_id := p_approval_action_rec.action_id;
143:
144: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: After call to LNS_APPROVAL_ACTION.Insert_Row');
145:
146: END do_create_approval_action;
147:
148: /*===========================================================================+

Line 186: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_update_approval_action procedure');

182: ldup_rowid ROWID;
183:
184: BEGIN
185:
186: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_update_approval_action procedure');
187:
188: -- check whether record has been updated by another user. If not, lock it.
189: BEGIN
190: SELECT OBJECT_VERSION_NUMBER,

Line 224: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');

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',

Line 267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');

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: /*===========================================================================+

Line 306: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_approval_action procedure');

302:
303: l_dummy VARCHAR2(1);
304: BEGIN
305:
306: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_approval_action procedure');
307:
308: IF p_action_id IS NOT NULL AND
309: p_action_id <> FND_API.G_MISS_NUM
310: THEN

Line 328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');

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:

Line 333: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: After 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;
336:
337: PROCEDURE validate_loan (

Line 533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Begin');

529:
530: BEGIN
531: l_last_api_called := '';
532: l_approval_action_rec := p_approval_action_rec;
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Begin');
534:
535: -- standard start of API savepoint
536: SAVEPOINT create_approval_action;
537:

Line 546: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to do_create_approval_action proc');

542:
543: -- initialize API return status to success.
544: x_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to do_create_approval_action proc');
547:
548: -- call to business logic.
549: do_create_approval_action(l_approval_action_rec
550: ,x_action_id

Line 553: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to do_create_approval_action proc');

549: do_create_approval_action(l_approval_action_rec
550: ,x_action_id
551: ,x_return_status);
552:
553: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to do_create_approval_action proc');
554: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');
555:
556: OPEN C_Get_Loan_Info(l_approval_action_rec.loan_id);
557: FETCH C_Get_Loan_Info

Line 554: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');

550: ,x_action_id
551: ,x_return_status);
552:
553: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to do_create_approval_action proc');
554: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');
555:
556: OPEN C_Get_Loan_Info(l_approval_action_rec.loan_id);
557: FETCH C_Get_Loan_Info
558: INTO l_object_version_number

Line 616: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE');

612: END IF;
613:
614: ELSIF (l_approval_action_rec.action_type = 'SUBMIT_FOR_CNCL') THEN
615: IF (l_loan_class_code = 'DIRECT') THEN
616: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE');
617:
618: LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE(P_API_VERSION => 1.0
619: ,P_INIT_MSG_LIST => FND_API.G_TRUE
620: ,P_COMMIT => FND_API.G_FALSE

Line 627: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE');

623: ,X_RETURN_STATUS => x_return_status
624: ,X_MSG_COUNT => x_msg_count
625: ,X_MSG_DATA => x_msg_data);
626:
627: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE');
628:
629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
630: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE failed with status ' || x_return_status);
631: l_last_api_called := 'LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE';

Line 630: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE failed with status ' || x_return_status);

626:
627: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE');
628:
629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
630: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE failed with status ' || x_return_status);
631: l_last_api_called := 'LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE';
632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634: ELSE

Line 673: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB');

669: end if;
670:
671: -- approval action type = 'APPROVE'
672: ELSIF l_status = 'PENDING_CANCELLATION' THEN
673: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB');
674:
675: LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB(P_API_VERSION => 1.0
676: ,P_INIT_MSG_LIST => FND_API.G_TRUE
677: ,P_COMMIT => FND_API.G_FALSE

Line 684: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB');

680: ,X_RETURN_STATUS => x_return_status
681: ,X_MSG_COUNT => x_msg_count
682: ,X_MSG_DATA => x_msg_data);
683:
684: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB');
685:
686: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
687: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB failed with status ' || x_return_status);
688: l_last_api_called := 'LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB';

Line 687: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB failed with status ' || x_return_status);

683:
684: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB');
685:
686: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
687: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB failed with status ' || x_return_status);
688: l_last_api_called := 'LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB';
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;
691:

Line 696: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_FINANCIALS.shiftLoanDates');

692: -- approval action type = 'APPROVE'
693: ELSIF (l_status = 'ACTIVE' AND l_current_phase = 'OPEN' AND l_multiple_funding_flag = 'Y' AND l_open_to_term_flag = 'Y') THEN
694:
695: /**********************Begin Permanent Conversion to Term Phase*************/
696: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_FINANCIALS.shiftLoanDates');
697:
698: -- we are moving the loan to the TERM PHASE -- first shift the dates based on conversion date
699: -- Bug#6169438 Added new parameter to the shiftLoanDates API Invocation
700: LNS_FINANCIALS.shiftLoanDates(p_loan_id => l_loan_header_rec.loan_id

Line 710: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_FINANCIALS.shiftLoanDates failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

706: ,x_msg_count => x_msg_count
707: ,x_msg_data => x_msg_data);
708:
709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
710: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_FINANCIALS.shiftLoanDates failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
711: l_last_api_called := 'LNS_FINANCIALS.shiftLoanDates';
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:

Line 715: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New loan start date: ' || l_loan_details.loan_start_date);

711: l_last_api_called := 'LNS_FINANCIALS.shiftLoanDates';
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New loan start date: ' || l_loan_details.loan_start_date);
716: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New first payment date: ' || l_loan_details.first_payment_Date);
717: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New maturity date: ' || l_loan_details.maturity_date);
718:
719: /* query term version */

Line 716: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New first payment date: ' || l_loan_details.first_payment_Date);

712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New loan start date: ' || l_loan_details.loan_start_date);
716: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New first payment date: ' || l_loan_details.first_payment_Date);
717: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New maturity date: ' || l_loan_details.maturity_date);
718:
719: /* query term version */
720: open term_version_cur(l_loan_header_rec.loan_id);

Line 717: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New maturity date: ' || l_loan_details.maturity_date);

713: END IF;
714:
715: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New loan start date: ' || l_loan_details.loan_start_date);
716: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New first payment date: ' || l_loan_details.first_payment_Date);
717: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'New maturity date: ' || l_loan_details.maturity_date);
718:
719: /* query term version */
720: open term_version_cur(l_loan_header_rec.loan_id);
721: fetch term_version_cur into l_TERM_ID, l_TERM_VERSION_NUMBER;

Line 730: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');

726: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;
727: l_term_rec.FIRST_PAYMENT_DATE := l_loan_details.first_payment_Date;
728: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
729:
730: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');
731: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);
732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);

Line 731: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);

727: l_term_rec.FIRST_PAYMENT_DATE := l_loan_details.first_payment_Date;
728: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
729:
730: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');
731: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);
732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
735:

Line 732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);

728: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
729:
730: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');
731: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);
732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
735:
736: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER

Line 733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);

729:
730: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');
731: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);
732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
735:
736: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER
737: ,p_init_msg_list => FND_API.G_FALSE

Line 734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);

730: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');
731: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);
732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
735:
736: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER
737: ,p_init_msg_list => FND_API.G_FALSE
738: ,p_loan_term_rec => l_term_rec

Line 743: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'x_return_status: ' || x_return_status);

739: ,X_RETURN_STATUS => x_return_status
740: ,X_MSG_COUNT => x_msg_count
741: ,X_MSG_DATA => x_msg_data);
742:
743: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'x_return_status: ' || x_return_status);
744:
745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE

Line 746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');

742:
743: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'x_return_status: ' || x_return_status);
744:
745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

Line 750: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
751: l_last_api_called := 'LNS_TERMS_PUB.update_term';
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754:

Line 763: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Data to Update loan header with during conversion...');

759: l_loan_header_rec.secondary_status := 'CONVERTED_TO_TERM_PHASE';
760: l_loan_header_rec.LAST_PAYMENT_NUMBER := FND_API.G_MISS_NUM;
761: l_loan_header_rec.LAST_AMORTIZATION_ID := FND_API.G_MISS_NUM;
762:
763: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Data to Update loan header with during conversion...');
764: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'loan_id: ' || l_loan_header_rec.loan_id);
765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);

Line 764: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'loan_id: ' || l_loan_header_rec.loan_id);

760: l_loan_header_rec.LAST_PAYMENT_NUMBER := FND_API.G_MISS_NUM;
761: l_loan_header_rec.LAST_AMORTIZATION_ID := FND_API.G_MISS_NUM;
762:
763: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Data to Update loan header with during conversion...');
764: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'loan_id: ' || l_loan_header_rec.loan_id);
765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);

Line 765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);

761: l_loan_header_rec.LAST_AMORTIZATION_ID := FND_API.G_MISS_NUM;
762:
763: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Data to Update loan header with during conversion...');
764: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'loan_id: ' || l_loan_header_rec.loan_id);
765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);
769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);

Line 766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);

762:
763: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Data to Update loan header with during conversion...');
764: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'loan_id: ' || l_loan_header_rec.loan_id);
765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);
769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);
770: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_AMORTIZATION_ID: ' || l_loan_header_rec.LAST_AMORTIZATION_ID);

Line 767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);

763: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Data to Update loan header with during conversion...');
764: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'loan_id: ' || l_loan_header_rec.loan_id);
765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);
769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);
770: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_AMORTIZATION_ID: ' || l_loan_header_rec.LAST_AMORTIZATION_ID);
771:

Line 768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);

764: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'loan_id: ' || l_loan_header_rec.loan_id);
765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);
769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);
770: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_AMORTIZATION_ID: ' || l_loan_header_rec.LAST_AMORTIZATION_ID);
771:
772: --Process Conversion Fees

Line 769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);

765: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_START_DATE: ' || l_loan_header_rec.LOAN_START_DATE);
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);
769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);
770: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_AMORTIZATION_ID: ' || l_loan_header_rec.LAST_AMORTIZATION_ID);
771:
772: --Process Conversion Fees
773: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before calling lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');

Line 770: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_AMORTIZATION_ID: ' || l_loan_header_rec.LAST_AMORTIZATION_ID);

766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_MATURITY_DATE: ' || l_loan_header_rec.LOAN_MATURITY_DATE);
767: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'current_phase: ' || l_loan_header_rec.current_phase);
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'secondary_status: ' || l_loan_header_rec.secondary_status);
769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);
770: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_AMORTIZATION_ID: ' || l_loan_header_rec.LAST_AMORTIZATION_ID);
771:
772: --Process Conversion Fees
773: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before calling lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
774: lns_fee_engine.processDisbursementFees(p_init_msg_list => FND_API.G_TRUE

Line 773: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before calling lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');

769: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_PAYMENT_NUMBER: ' || l_loan_header_rec.LAST_PAYMENT_NUMBER);
770: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LAST_AMORTIZATION_ID: ' || l_loan_header_rec.LAST_AMORTIZATION_ID);
771:
772: --Process Conversion Fees
773: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before calling lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
774: lns_fee_engine.processDisbursementFees(p_init_msg_list => FND_API.G_TRUE
775: ,p_commit => FND_API.G_FALSE
776: ,p_phase => 'TERM'
777: ,p_loan_id => l_loan_header_rec.loan_id

Line 783: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');

779: ,x_return_status => x_return_status
780: ,x_msg_count => x_msg_count
781: ,x_msg_data => x_msg_data);
782:
783: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
784:
785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
786: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
787: l_last_api_called := 'lns_fee_engine.processDisbursementFees';

Line 786: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

782:
783: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
784:
785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
786: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
787: l_last_api_called := 'lns_fee_engine.processDisbursementFees';
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790: /**********************End Permanent Conversion to Term Phase*************/

Line 804: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');

800: IF ( l_status = 'PENDING' OR (l_status = 'INCOMPLETE' AND l_loan_needs_approval = 'N') ) THEN
801: l_loan_header_rec.loan_status := 'REJECTED';
802: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
803: ELSIF (l_status = 'PENDING_CANCELLATION') THEN
804: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');
805:
806: LNS_FUNDING_PUB.REJECT_CANCEL_DISB(P_API_VERSION => 1.0
807: ,P_INIT_MSG_LIST => FND_API.G_TRUE
808: ,P_COMMIT => FND_API.G_FALSE

Line 815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');

811: ,X_RETURN_STATUS => x_return_status
812: ,X_MSG_COUNT => x_msg_count
813: ,X_MSG_DATA => x_msg_data);
814:
815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');
816:
817: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
818: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_FUNDING_PUB.REJECT_CANCEL_DISB failed with status ' || x_return_status);
819: l_last_api_called := 'LNS_FUNDING_PUB.REJECT_CANCEL_DISB';

Line 818: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_FUNDING_PUB.REJECT_CANCEL_DISB failed with status ' || x_return_status);

814:
815: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');
816:
817: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
818: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_FUNDING_PUB.REJECT_CANCEL_DISB failed with status ' || x_return_status);
819: l_last_api_called := 'LNS_FUNDING_PUB.REJECT_CANCEL_DISB';
820: RAISE FND_API.G_EXC_ERROR;
821: END IF;
822: ELSIF (l_status = 'ACTIVE' and l_secondary_status = 'PENDING_CONVERSION') THEN

Line 842: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');

838: null;
839: ELSIF l_status = 'PENDING' THEN
840: l_loan_header_rec.loan_status := 'INCOMPLETE';
841: ELSIF (l_status = 'PENDING_CANCELLATION') THEN
842: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');
843:
844: LNS_FUNDING_PUB.REJECT_CANCEL_DISB(P_API_VERSION => 1.0
845: ,P_INIT_MSG_LIST => FND_API.G_TRUE
846: ,P_COMMIT => FND_API.G_FALSE

Line 853: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');

849: ,X_RETURN_STATUS => x_return_status
850: ,X_MSG_COUNT => x_msg_count
851: ,X_MSG_DATA => x_msg_data);
852:
853: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');
854:
855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
856: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB failed with status ' || x_return_status);
857: l_last_api_called := 'LNS_FUNDING_PUB.REJECT_CANCEL_DISB';

Line 856: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB failed with status ' || x_return_status);

852:
853: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - AFTER call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB');
854:
855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
856: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_FUNDING_PUB.REJECT_CANCEL_DISB failed with status ' || x_return_status);
857: l_last_api_called := 'LNS_FUNDING_PUB.REJECT_CANCEL_DISB';
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:

Line 879: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - before default distributions');

875: --Question for Raj:
876: --Do we need to check for l_prev_loan_status = 'PENDING' to call code below on initial loan approval only?
877: IF (l_approval_action_rec.action_type = 'APPROVE' and (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED') and l_loan_class_code = 'DIRECT') THEN
878:
879: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - before default distributions');
880: Lns_distributions_pub.defaultDistributions(p_api_version => 1.0
881: ,p_init_msg_list => FND_API.G_TRUE
882: ,p_commit => FND_API.G_FALSE
883: ,p_loan_id => l_loan_header_rec.loan_id

Line 888: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after default distributions ' || x_return_status);

884: ,p_loan_class_code => l_loan_class_code
885: ,x_return_status => x_return_status
886: ,x_msg_count => x_msg_count
887: ,x_msg_data => x_msg_data);
888: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after default distributions ' || x_return_status);
889:
890: begin
891: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'calling lns_distributions_pub.budgetary_control');
892: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE

Line 891: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'calling lns_distributions_pub.budgetary_control');

887: ,x_msg_data => x_msg_data);
888: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after default distributions ' || x_return_status);
889:
890: begin
891: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'calling lns_distributions_pub.budgetary_control');
892: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE
893: ,p_commit => FND_API.G_FALSE
894: ,p_loan_id => l_approval_action_rec.loan_id
895: ,p_budgetary_control_mode => 'R'

Line 900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to Lns_distributions_pub.budgetary_control return status ' || x_return_status);

896: ,x_budgetary_status_code => l_budgetary_status
897: ,x_return_status => x_return_status
898: ,x_msg_count => x_msg_count
899: ,x_msg_data => x_msg_data);
900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to Lns_distributions_pub.budgetary_control return status ' || x_return_status);
901: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_budgetary_status' || l_budgetary_status);
902: --FND_MSG_PUB.initialize;
903: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
904:

Line 901: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_budgetary_status' || l_budgetary_status);

897: ,x_return_status => x_return_status
898: ,x_msg_count => x_msg_count
899: ,x_msg_data => x_msg_data);
900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to Lns_distributions_pub.budgetary_control return status ' || x_return_status);
901: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_budgetary_status' || l_budgetary_status);
902: --FND_MSG_PUB.initialize;
903: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
904:
905: RAISE FND_API.G_EXC_ERROR;

Line 909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'budget reserved');

905: RAISE FND_API.G_EXC_ERROR;
906:
907: else -- BC Call Returned 'S'
908: if l_budgetary_status = 'ADVISORY' or l_budgetary_status = 'SUCCESS' then
909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'budget reserved');
910: l_loan_header_rec.secondary_status := 'BUDGET_RESERVED';
911:
912: elsif l_budgetary_status = 'FAIL' or l_budgetary_status = 'PARTIAL' or l_budgetary_status = 'XLA_ERROR' then
913: if l_budget_req_approval = 'Y' then

Line 915: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'budget required: NO BUDGET');

911:
912: elsif l_budgetary_status = 'FAIL' or l_budgetary_status = 'PARTIAL' or l_budgetary_status = 'XLA_ERROR' then
913: if l_budget_req_approval = 'Y' then
914: -- continue as if nothing happen
915: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'budget required: NO BUDGET');
916: RAISE FND_API.G_EXC_ERROR;
917: else
918: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NO BUDGET');
919: FND_MSG_PUB.initialize;

Line 918: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NO BUDGET');

914: -- continue as if nothing happen
915: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'budget required: NO BUDGET');
916: RAISE FND_API.G_EXC_ERROR;
917: else
918: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NO BUDGET');
919: FND_MSG_PUB.initialize;
920: l_loan_header_rec.secondary_status := 'NO_BUDGET';
921: end if;
922:

Line 942: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

938: from lns_terms
939: where loan_id = l_loan_header_rec.loan_id;
940:
941: -- Updating terms
942: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_terms...');
944: END IF;
945:
946: l_term_rec.TERM_ID := l_term_id;

Line 943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_terms...');

939: where loan_id = l_loan_header_rec.loan_id;
940:
941: -- Updating terms
942: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_terms...');
944: END IF;
945:
946: l_term_rec.TERM_ID := l_term_id;
947: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;

Line 958: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || x_return_status);

954: X_MSG_COUNT => x_msg_count,
955: X_MSG_DATA => x_msg_data);
956:
957:
958: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || x_return_status);
959: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: ELSE
962: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');

Line 962: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');

958: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || x_return_status);
959: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: ELSE
962: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');
963: END IF;
964:
965: end if;
966:

Line 967: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit adjustment request');

963: END IF;
964:
965: end if;
966:
967: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit adjustment request');
968: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
969:
970: LNS_BILLING_BATCH_PUB.ADJUST_ORIGINAL_RECEIVABLE(P_API_VERSION => 1.0
971: ,P_INIT_MSG_LIST => FND_API.G_TRUE

Line 980: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_BILLING_BATCH_PUB.ADJUST_ORIGINAL_RECEIVABLE failed with status ' || x_return_status);

976: ,X_MSG_COUNT => x_msg_count
977: ,X_MSG_DATA => x_msg_data);
978:
979: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
980: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to LNS_BILLING_BATCH_PUB.ADJUST_ORIGINAL_RECEIVABLE failed with status ' || x_return_status);
981: l_last_api_called := 'LNS_BILLING_BATCH_PUB.ADJUST_ORIGINAL_RECEIVABLE';
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984:

Line 990: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');

986:
987: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
988:
989: -- moved the defaultDistributions call to Concurrent Process
990: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to submit gen distributions request');
991: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
992: --call fnd_request_api....
993: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
994: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'

Line 998: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after call to submit gen distributions request ' || l_request_id);

994: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
995: ,'LNS_GEN_DIST'
996: ,'', '', FALSE
997: ,l_loan_header_rec.loan_id);
998: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after call to submit gen distributions request ' || l_request_id);
999:
1000: end if; --END if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1001:
1002: END IF; -- END IF (l_approval_action_rec.action_type = 'APPROVE' and l_loan_header_rec.loan_status = 'ACTIVE' and l_loan_class_code = 'ERS') THEN

Line 1010: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');

1006: open loan_version_cur(l_loan_header_rec.loan_id);
1007: fetch loan_version_cur into l_object_version_number;
1008: close loan_version_cur;
1009:
1010: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');
1011: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
1012: ,p_loan_header_rec => l_loan_header_rec
1013: ,p_object_version_number => l_object_version_number
1014: ,x_return_status => x_return_status

Line 1017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');

1013: ,p_object_version_number => l_object_version_number
1014: ,x_return_status => x_return_status
1015: ,x_msg_count => x_msg_count
1016: ,x_msg_data => x_msg_data);
1017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');
1018:
1019: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';

Line 1020: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

1016: ,x_msg_data => x_msg_data);
1017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');
1018:
1019: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');

Line 1024: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');

1020: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');
1025:
1026: END IF;
1027:
1028: if (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_approval_action_rec.action_type = 'APPROVE' and (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED')) then

Line 1031: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1027:
1028: if (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_approval_action_rec.action_type = 'APPROVE' and (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED')) then
1029:
1030: /* begin submit request to generate Loan Agreement Report */
1031: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1032: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1033: FND_REQUEST.SET_ORG_ID(MO_GLOBAL.GET_CURRENT_ORG_ID());
1034: -- Bug#5936252 : Invoke the function add_layout to specify the template type,code etc., before submitting request
1035: SELECT

Line 1045: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1041: WHERE
1042: language_code = USERENV('LANG');
1043:
1044:
1045: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1046:
1047: l_xml_output:= fnd_request.add_layout(
1048: template_appl_name => 'LNS',
1049: template_code => 'LNSRPTAG',

Line 1054: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1050: template_language => l_iso_language,
1051: template_territory => l_iso_territory,
1052: output_format => 'PDF'
1053: );
1054: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.ADD_LAYOUT for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1055:
1056:
1057: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
1058: ,'LNS_AGREEMENT'

Line 1069: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);

1065: FND_MSG_PUB.Add;
1066: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
1067: RAISE FND_API.G_EXC_ERROR;
1068: else
1069: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
1070: end if;
1071:
1072: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1073: /* end submit request to generate Loan Agreement Report */

Line 1072: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);

1068: else
1069: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
1070: end if;
1071:
1072: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' After calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1073: /* end submit request to generate Loan Agreement Report */
1074:
1075: end if;
1076:

Line 1077: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - End ');

1073: /* end submit request to generate Loan Agreement Report */
1074:
1075: end if;
1076:
1077: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - End ');
1078:
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'before rollback');

Line 1081: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'before rollback');

1077: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - End ');
1078:
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'before rollback');
1082: ROLLBACK TO create_approval_action;
1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

Line 1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');

1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'before rollback');
1082: ROLLBACK TO create_approval_action;
1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1086: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1087: FND_MSG_PUB.ADD;

Line 1157: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_approval_action procedure');

1153: l_approval_action_rec APPROVAL_ACTION_REC_TYPE;
1154: l_old_approval_action_rec APPROVAL_ACTION_REC_TYPE;
1155: BEGIN
1156: l_approval_action_rec := p_approval_action_rec;
1157: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_approval_action procedure');
1158:
1159: -- standard start of API savepoint
1160: SAVEPOINT update_approval_action;
1161:

Line 1184: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_approval_action procedure: Before call to do_update_approval_action proc');

1180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183:
1184: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_approval_action procedure: Before call to do_update_approval_action proc');
1185:
1186: -- call to business logic.
1187: do_update_approval_action(
1188: l_approval_action_rec,

Line 1192: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_approval_action procedure: After call to do_update_approval_action proc');

1188: l_approval_action_rec,
1189: p_object_version_number,
1190: x_return_status);
1191:
1192: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_approval_action procedure: After call to do_update_approval_action proc');
1193:
1194: EXCEPTION
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO update_approval_action;

Line 1219: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_approval_action procedure');

1215: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data);
1218:
1219: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_approval_action procedure');
1220:
1221: END update_approval_action;
1222:
1223: /*===========================================================================+

Line 1264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Delete_approval_action procedure');

1260: l_action_id NUMBER;
1261:
1262: BEGIN
1263: l_action_id := p_action_id;
1264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Delete_approval_action procedure');
1265:
1266: -- standard start of API savepoint
1267: SAVEPOINT delete_approval_action;
1268:

Line 1277: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_approval_action procedure: Before call to do_delete_approval_action proc');

1273:
1274: -- initialize API return status to success.
1275: x_return_status := FND_API.G_RET_STS_SUCCESS;
1276:
1277: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_approval_action procedure: Before call to do_delete_approval_action proc');
1278:
1279: -- call to business logic.
1280: do_delete_approval_action(
1281: l_action_id,

Line 1284: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_approval_action procedure: After call to do_delete_approval_action proc');

1280: do_delete_approval_action(
1281: l_action_id,
1282: x_return_status);
1283:
1284: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_approval_action procedure: After call to do_delete_approval_action proc');
1285:
1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: ROLLBACK TO delete_approval_action;

Line 1311: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_approval_action procedure');

1307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data);
1310:
1311: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_approval_action procedure');
1312:
1313: END delete_approval_action;
1314:
1315: END LNS_APPROVAL_ACTION_PUB;