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_COND_ASSIGNMENT_PUB dependencies on FND_LOG

Line 49: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);

45: IS
46: BEGIN
47: if (p_msg_level >= G_MSG_LEVEL) then
48:
49: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
50: if FND_GLOBAL.Conc_Request_Id is not null then
51: fnd_file.put_line(FND_FILE.LOG, p_msg);
52: end if;
53:

Line 58: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

54: end if;
55:
56: EXCEPTION
57: WHEN OTHERS THEN
58: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
59: END;
60:
61:
62:

Line 138: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

134:
135: BEGIN
136:
137: l_COND_ASSIGNMENT_id := p_COND_ASSIGNMENT_rec.cond_assignment_id;
138: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
139: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_COND_ASSIGNMENT procedure');
140: END IF;
141:
142: -- if primary key value is passed, check for uniqueness.

Line 139: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_COND_ASSIGNMENT procedure');

135: BEGIN
136:
137: l_COND_ASSIGNMENT_id := p_COND_ASSIGNMENT_rec.cond_assignment_id;
138: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
139: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_COND_ASSIGNMENT procedure');
140: END IF;
141:
142: -- if primary key value is passed, check for uniqueness.
143: IF l_COND_ASSIGNMENT_id IS NOT NULL AND

Line 165: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

161: END IF;
162:
163: Set_Defaults(p_COND_ASSIGNMENT_rec);
164:
165: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Insert_Row');
167: END IF;
168:
169: -- call table-handler.

Line 166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Insert_Row');

162:
163: Set_Defaults(p_COND_ASSIGNMENT_rec);
164:
165: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Insert_Row');
167: END IF;
168:
169: -- call table-handler.
170: LNS_COND_ASSIGNMENTS_PKG.Insert_Row (

Line 197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

193:
194: x_COND_ASSIGNMENT_id := p_COND_ASSIGNMENT_rec.cond_assignment_id;
195: x_return_status := 'S';
196:
197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENT.Insert_Row');
199: END IF;
200:
201: END do_create_COND_ASSIGNMENT;

Line 198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENT.Insert_Row');

194: x_COND_ASSIGNMENT_id := p_COND_ASSIGNMENT_rec.cond_assignment_id;
195: x_return_status := 'S';
196:
197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENT.Insert_Row');
199: END IF;
200:
201: END do_create_COND_ASSIGNMENT;
202:

Line 243: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

239: ldup_rowid ROWID;
240:
241: BEGIN
242:
243: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_update_COND_ASSIGNMENT procedure');
245: END IF;
246:
247: -- check whether record has been updated by another user. If not, lock it.

Line 244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_update_COND_ASSIGNMENT procedure');

240:
241: BEGIN
242:
243: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_update_COND_ASSIGNMENT procedure');
245: END IF;
246:
247: -- check whether record has been updated by another user. If not, lock it.
248: BEGIN

Line 283: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

279: END;
280:
281: Set_Defaults(p_COND_ASSIGNMENT_rec);
282:
283: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');
285: END IF;
286:
287: -- log history

Line 284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');

280:
281: Set_Defaults(p_COND_ASSIGNMENT_rec);
282:
283: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');
285: END IF;
286:
287: -- log history
288: LNS_LOAN_HISTORY_PUB.log_record_pre(p_COND_ASSIGNMENT_rec.cond_assignment_id,

Line 320: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

316: 'COND_ASSIGNMENT_ID',
317: 'LNS_COND_ASSIGNMENTS',
318: p_COND_ASSIGNMENT_rec.loan_id);
319:
320: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');
322: END IF;
323:
324: END do_update_COND_ASSIGNMENT;

Line 321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');

317: 'LNS_COND_ASSIGNMENTS',
318: p_COND_ASSIGNMENT_rec.loan_id);
319:
320: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');
322: END IF;
323:
324: END do_update_COND_ASSIGNMENT;
325:

Line 364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

360: l_cond_assign_rec COND_ASSIGNMENT_REC_TYPE;
361:
362: BEGIN
363:
364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_COND_ASSIGNMENT procedure');
366: END IF;
367:
368: IF p_COND_ASSIGNMENT_id IS NOT NULL AND

Line 365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_COND_ASSIGNMENT procedure');

361:
362: BEGIN
363:
364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_COND_ASSIGNMENT procedure');
366: END IF;
367:
368: IF p_COND_ASSIGNMENT_id IS NOT NULL AND
369: p_COND_ASSIGNMENT_id <> FND_API.G_MISS_NUM

Line 390: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

386: END;
387: END IF;
388:
389:
390: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');
392: END IF;
393:
394: -- log history

Line 391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');

387: END IF;
388:
389:
390: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');
392: END IF;
393:
394: -- log history
395: LNS_LOAN_HISTORY_PUB.log_record_pre(p_cond_assignment_id,

Line 440: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

436: 'COND_ASSIGNMENT_ID',
437: 'LNS_COND_ASSIGNMENTS',
438: l_loan_id);
439:
440: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');
442: END IF;
443:
444: END do_delete_COND_ASSIGNMENT;

Line 441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');

437: 'LNS_COND_ASSIGNMENTS',
438: l_loan_id);
439:
440: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');
442: END IF;
443:
444: END do_delete_COND_ASSIGNMENT;
445:

Line 494: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

490:
491: BEGIN
492:
493: l_COND_ASSIGNMENT_rec := p_COND_ASSIGNMENT_rec;
494: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Create_COND_ASSIGNMENT procedure');
496: END IF;
497:
498: -- standard start of API savepoint

Line 495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Create_COND_ASSIGNMENT procedure');

491: BEGIN
492:
493: l_COND_ASSIGNMENT_rec := p_COND_ASSIGNMENT_rec;
494: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Create_COND_ASSIGNMENT procedure');
496: END IF;
497:
498: -- standard start of API savepoint
499: SAVEPOINT create_COND_ASSIGNMENT;

Line 509: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

505:
506: -- initialize API return status to success.
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc');
511: END IF;
512:
513: -- call to business logic.

Line 510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc');

506: -- initialize API return status to success.
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc');
511: END IF;
512:
513: -- call to business logic.
514: do_create_COND_ASSIGNMENT(

Line 520: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

516: x_COND_ASSIGNMENT_id,
517: x_return_status
518: );
519:
520: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc');
522: END IF;
523:
524: EXCEPTION

Line 521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc');

517: x_return_status
518: );
519:
520: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc');
522: END IF;
523:
524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN

Line 552: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data);
551:
552: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Create_COND_ASSIGNMENT procedure');
554: END IF;
555:
556: END create_COND_ASSIGNMENT;

Line 553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Create_COND_ASSIGNMENT procedure');

549: p_count => x_msg_count,
550: p_data => x_msg_data);
551:
552: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Create_COND_ASSIGNMENT procedure');
554: END IF;
555:
556: END create_COND_ASSIGNMENT;
557:

Line 603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

599:
600: BEGIN
601:
602: l_COND_ASSIGNMENT_rec := p_COND_ASSIGNMENT_rec;
603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_COND_ASSIGNMENT procedure');
605: END IF;
606:
607: -- standard start of API savepoint

Line 604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_COND_ASSIGNMENT procedure');

600: BEGIN
601:
602: l_COND_ASSIGNMENT_rec := p_COND_ASSIGNMENT_rec;
603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_COND_ASSIGNMENT procedure');
605: END IF;
606:
607: -- standard start of API savepoint
608: SAVEPOINT update_COND_ASSIGNMENT;

Line 632: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

628: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: Before call to do_update_COND_ASSIGNMENT proc');
634: END IF;
635:
636: -- call to business logic.

Line 633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: Before call to do_update_COND_ASSIGNMENT proc');

629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: Before call to do_update_COND_ASSIGNMENT proc');
634: END IF;
635:
636: -- call to business logic.
637: do_update_COND_ASSIGNMENT(

Line 643: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

639: p_object_version_number,
640: x_return_status
641: );
642:
643: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
644: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: After call to do_update_COND_ASSIGNMENT proc');
645: END IF;
646:
647: EXCEPTION

Line 644: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: After call to do_update_COND_ASSIGNMENT proc');

640: x_return_status
641: );
642:
643: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
644: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: After call to do_update_COND_ASSIGNMENT proc');
645: END IF;
646:
647: EXCEPTION
648: WHEN FND_API.G_EXC_ERROR THEN

Line 675: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data);
674:
675: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_COND_ASSIGNMENT procedure');
677: END IF;
678:
679: END update_COND_ASSIGNMENT;

Line 676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_COND_ASSIGNMENT procedure');

672: p_count => x_msg_count,
673: p_data => x_msg_data);
674:
675: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_COND_ASSIGNMENT procedure');
677: END IF;
678:
679: END update_COND_ASSIGNMENT;
680:

Line 723: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

719:
720: BEGIN
721:
722: l_COND_ASSIGNMENT_id := p_COND_ASSIGNMENT_id;
723: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Delete_COND_ASSIGNMENT procedure');
725: END IF;
726:
727: -- standard start of API savepoint

Line 724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Delete_COND_ASSIGNMENT procedure');

720: BEGIN
721:
722: l_COND_ASSIGNMENT_id := p_COND_ASSIGNMENT_id;
723: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Delete_COND_ASSIGNMENT procedure');
725: END IF;
726:
727: -- standard start of API savepoint
728: SAVEPOINT delete_COND_ASSIGNMENT;

Line 738: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

734:
735: -- initialize API return status to success.
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737:
738: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
739: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc');
740: END IF;
741:
742: -- call to business logic.

Line 739: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc');

735: -- initialize API return status to success.
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737:
738: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
739: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc');
740: END IF;
741:
742: -- call to business logic.
743: do_delete_COND_ASSIGNMENT(

Line 748: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

744: l_COND_ASSIGNMENT_id,
745: x_return_status
746: );
747:
748: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc');
750: END IF;
751:
752: EXCEPTION

Line 749: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc');

745: x_return_status
746: );
747:
748: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc');
750: END IF;
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN

Line 780: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data);
779:
780: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_COND_ASSIGNMENT procedure');
782: END IF;
783:
784: END delete_COND_ASSIGNMENT;

Line 781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_COND_ASSIGNMENT procedure');

777: p_count => x_msg_count,
778: p_data => x_msg_data);
779:
780: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_COND_ASSIGNMENT procedure');
782: END IF;
783:
784: END delete_COND_ASSIGNMENT;
785:

Line 836: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

832: --Initialize this variable to false. Change to true when a record is
833: --inserted into the table in this procedure
834: is_commit_needed := FALSE;
835:
836: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin create_LP_COND_ASSIGNMENT procedure');
838: END IF;
839:
840: -- standard start of API savepoint

Line 837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin create_LP_COND_ASSIGNMENT procedure');

833: --inserted into the table in this procedure
834: is_commit_needed := FALSE;
835:
836: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin create_LP_COND_ASSIGNMENT procedure');
838: END IF;
839:
840: -- standard start of API savepoint
841: SAVEPOINT create_LP_COND_ASSIGNMENT;

Line 844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

840: -- standard start of API savepoint
841: SAVEPOINT create_LP_COND_ASSIGNMENT;
842:
843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before opening cursor current_loan_status ');
846: END IF;
847:
848: OPEN current_loan_status(P_LOAN_ID) ;

Line 845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before opening cursor current_loan_status ');

841: SAVEPOINT create_LP_COND_ASSIGNMENT;
842:
843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before opening cursor current_loan_status ');
846: END IF;
847:
848: OPEN current_loan_status(P_LOAN_ID) ;
849:

Line 852: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

848: OPEN current_loan_status(P_LOAN_ID) ;
849:
850: FETCH current_loan_status INTO l_loan_status ,l_loan_Current_phase ;
851:
852: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor current_loan_status , loan status is '||l_loan_status ||' loan current phase is '||l_loan_Current_phase);
854: END IF;
855:
856: /* If the loan current phase is not open or loan status is not Incomplete for Term loan , no conditions assignment required */

Line 853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor current_loan_status , loan status is '||l_loan_status ||' loan current phase is '||l_loan_Current_phase);

849:
850: FETCH current_loan_status INTO l_loan_status ,l_loan_Current_phase ;
851:
852: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor current_loan_status , loan status is '||l_loan_status ||' loan current phase is '||l_loan_Current_phase);
854: END IF;
855:
856: /* If the loan current phase is not open or loan status is not Incomplete for Term loan , no conditions assignment required */
857: IF( NOT ( ( l_loan_status='INCOMPLETE' AND l_loan_current_phase = 'TERM' ) OR ( l_loan_current_phase = 'OPEN' ) ) ) THEN

Line 864: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

860:
861:
862:
863:
864: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'create_LP_COND_ASSIGNMENT procedure: Before opening cursor loan_cond_count ');
866: END IF;
867:
868: OPEN loan_cond_count(P_LOAN_ID) ;

Line 865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'create_LP_COND_ASSIGNMENT procedure: Before opening cursor loan_cond_count ');

861:
862:
863:
864: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'create_LP_COND_ASSIGNMENT procedure: Before opening cursor loan_cond_count ');
866: END IF;
867:
868: OPEN loan_cond_count(P_LOAN_ID) ;
869:

Line 872: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

868: OPEN loan_cond_count(P_LOAN_ID) ;
869:
870: FETCH loan_cond_count INTO l_loan_cond_count ;
871:
872: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor loan_fee_count , loan condition count is '||l_loan_cond_count );
874: END IF;
875:
876: /* If the loan condition count is not zero and there are already conditions assigned to loan, no conditions assignment required */

Line 873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor loan_fee_count , loan condition count is '||l_loan_cond_count );

869:
870: FETCH loan_cond_count INTO l_loan_cond_count ;
871:
872: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor loan_fee_count , loan condition count is '||l_loan_cond_count );
874: END IF;
875:
876: /* If the loan condition count is not zero and there are already conditions assigned to loan, no conditions assignment required */
877: IF( l_loan_cond_count <> 0 ) THEN

Line 883: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

879: END IF ;
880:
881:
882:
883: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before opening cursor loan_prod_cond ');
885: END IF;
886:
887: OPEN loan_prod_cond(P_LOAN_ID) ;

Line 884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before opening cursor loan_prod_cond ');

880:
881:
882:
883: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before opening cursor loan_prod_cond ');
885: END IF;
886:
887: OPEN loan_prod_cond(P_LOAN_ID) ;
888:

Line 889: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

885: END IF;
886:
887: OPEN loan_prod_cond(P_LOAN_ID) ;
888:
889: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
890: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor loan_prod_cond , no of conditions found is '||loan_prod_cond%ROWCOUNT);
891: END IF;
892:
893:

Line 890: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor loan_prod_cond , no of conditions found is '||loan_prod_cond%ROWCOUNT);

886:
887: OPEN loan_prod_cond(P_LOAN_ID) ;
888:
889: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
890: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After opening cursor loan_prod_cond , no of conditions found is '||loan_prod_cond%ROWCOUNT);
891: END IF;
892:
893:
894:

Line 920: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

916: l_cond_assignment_rec.OWNER_OBJECT_ID := NULL ;
917: l_cond_assignment_rec.OWNER_TABLE := NULL ;
918:
919:
920: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc for condition'|| l_condition_id);
922: END IF;
923:
924: -- call to business logic.

Line 921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc for condition'|| l_condition_id);

917: l_cond_assignment_rec.OWNER_TABLE := NULL ;
918:
919:
920: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc for condition'|| l_condition_id);
922: END IF;
923:
924: -- call to business logic.
925: do_create_COND_ASSIGNMENT( l_cond_assignment_rec ,

Line 931: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

927: x_return_status ) ;
928:
929: is_commit_needed := true;
930:
931: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
932: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc for condition'|| l_condition_id ||' , return status is' || x_return_status);
933: END IF;
934:
935:

Line 932: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc for condition'|| l_condition_id ||' , return status is' || x_return_status);

928:
929: is_commit_needed := true;
930:
931: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
932: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In create_LP_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc for condition'|| l_condition_id ||' , return status is' || x_return_status);
933: END IF;
934:
935:
936:

Line 991: logMessage(FND_LOG.LEVEL_STATEMENT, 'Begin create_LP_DISB_COND_ASSIGNMENT procedure');

987: x_return_status VARCHAR2(1) ;
988:
989: BEGIN
990:
991: logMessage(FND_LOG.LEVEL_STATEMENT, 'Begin create_LP_DISB_COND_ASSIGNMENT procedure');
992:
993: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
994: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_DISB_HEADER_ID = ' || P_DISB_HEADER_ID);
995: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_PRODUCT_LINE_ID = ' || P_LOAN_PRODUCT_LINE_ID);

Line 993: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);

989: BEGIN
990:
991: logMessage(FND_LOG.LEVEL_STATEMENT, 'Begin create_LP_DISB_COND_ASSIGNMENT procedure');
992:
993: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
994: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_DISB_HEADER_ID = ' || P_DISB_HEADER_ID);
995: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_PRODUCT_LINE_ID = ' || P_LOAN_PRODUCT_LINE_ID);
996:
997: -- standard start of API savepoint

Line 994: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_DISB_HEADER_ID = ' || P_DISB_HEADER_ID);

990:
991: logMessage(FND_LOG.LEVEL_STATEMENT, 'Begin create_LP_DISB_COND_ASSIGNMENT procedure');
992:
993: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
994: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_DISB_HEADER_ID = ' || P_DISB_HEADER_ID);
995: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_PRODUCT_LINE_ID = ' || P_LOAN_PRODUCT_LINE_ID);
996:
997: -- standard start of API savepoint
998: SAVEPOINT create_LP_DISB_COND_ASSIGNMENT;

Line 995: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_PRODUCT_LINE_ID = ' || P_LOAN_PRODUCT_LINE_ID);

991: logMessage(FND_LOG.LEVEL_STATEMENT, 'Begin create_LP_DISB_COND_ASSIGNMENT procedure');
992:
993: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
994: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_DISB_HEADER_ID = ' || P_DISB_HEADER_ID);
995: logMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_PRODUCT_LINE_ID = ' || P_LOAN_PRODUCT_LINE_ID);
996:
997: -- standard start of API savepoint
998: SAVEPOINT create_LP_DISB_COND_ASSIGNMENT;
999:

Line 1000: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: Before opening cursor loan_prod_disb_cond ');

996:
997: -- standard start of API savepoint
998: SAVEPOINT create_LP_DISB_COND_ASSIGNMENT;
999:
1000: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: Before opening cursor loan_prod_disb_cond ');
1001:
1002: OPEN loan_prod_disb_cond(P_LOAN_PRODUCT_LINE_ID) ;
1003:
1004: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: After opening cursor loan_prod_disb_cond , no of conditions found is '||loan_prod_disb_cond%ROWCOUNT);

Line 1004: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: After opening cursor loan_prod_disb_cond , no of conditions found is '||loan_prod_disb_cond%ROWCOUNT);

1000: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: Before opening cursor loan_prod_disb_cond ');
1001:
1002: OPEN loan_prod_disb_cond(P_LOAN_PRODUCT_LINE_ID) ;
1003:
1004: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: After opening cursor loan_prod_disb_cond , no of conditions found is '||loan_prod_disb_cond%ROWCOUNT);
1005: LOOP
1006:
1007: FETCH loan_prod_disb_cond INTO l_condition_id,l_cond_desc,l_mandatory_flag ;
1008: EXIT WHEN loan_prod_disb_cond%NOTFOUND ;

Line 1034: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc for condition '|| l_condition_id);

1030: l_cond_assignment_rec.DELETE_DISABLED_FLAG := l_mandatory_flag ;
1031: l_cond_assignment_rec.OWNER_OBJECT_ID := NULL ;
1032: l_cond_assignment_rec.OWNER_TABLE := 'LNS_DISB_HEADERS' ;
1033:
1034: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc for condition '|| l_condition_id);
1035:
1036: -- call to business logic.
1037: do_create_COND_ASSIGNMENT( l_cond_assignment_rec ,
1038: l_cond_assignment_id ,

Line 1041: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc for condition '|| l_condition_id ||' , return status is ' || x_return_status);

1037: do_create_COND_ASSIGNMENT( l_cond_assignment_rec ,
1038: l_cond_assignment_id ,
1039: x_return_status ) ;
1040:
1041: logMessage(FND_LOG.LEVEL_STATEMENT, 'In create_LP_DISB_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc for condition '|| l_condition_id ||' , return status is ' || x_return_status);
1042:
1043: END LOOP ;
1044:
1045: EXCEPTION

Line 1068: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1064:
1065: BEGIN
1066:
1067:
1068: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin delete_DISB_COND_ASSIGNMENT procedure');
1070: END IF;
1071:
1072: -- standard start of API savepoint

Line 1069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin delete_DISB_COND_ASSIGNMENT procedure');

1065: BEGIN
1066:
1067:
1068: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin delete_DISB_COND_ASSIGNMENT procedure');
1070: END IF;
1071:
1072: -- standard start of API savepoint
1073: SAVEPOINT delete_DISB_COND_ASSIGNMENT;

Line 1076: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1072: -- standard start of API savepoint
1073: SAVEPOINT delete_DISB_COND_ASSIGNMENT;
1074:
1075:
1076: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before opening cursor loan_disb_cond ');
1078: END IF;
1079:
1080: OPEN loan_disb_cond(P_DISB_HEADER_ID ) ;

Line 1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before opening cursor loan_disb_cond ');

1073: SAVEPOINT delete_DISB_COND_ASSIGNMENT;
1074:
1075:
1076: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before opening cursor loan_disb_cond ');
1078: END IF;
1079:
1080: OPEN loan_disb_cond(P_DISB_HEADER_ID ) ;
1081:

Line 1082: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1078: END IF;
1079:
1080: OPEN loan_disb_cond(P_DISB_HEADER_ID ) ;
1081:
1082: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After opening cursor loan_disb_cond , no of conditions found is '||loan_disb_cond%ROWCOUNT);
1084: END IF;
1085:
1086:

Line 1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After opening cursor loan_disb_cond , no of conditions found is '||loan_disb_cond%ROWCOUNT);

1079:
1080: OPEN loan_disb_cond(P_DISB_HEADER_ID ) ;
1081:
1082: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After opening cursor loan_disb_cond , no of conditions found is '||loan_disb_cond%ROWCOUNT);
1084: END IF;
1085:
1086:
1087:

Line 1094: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1090: FETCH loan_disb_cond INTO l_cond_assignment_id ;
1091: EXIT WHEN loan_disb_cond%NOTFOUND ;
1092:
1093:
1094: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id);
1096: END IF;
1097:
1098: -- call to business logic.

Line 1095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id);

1091: EXIT WHEN loan_disb_cond%NOTFOUND ;
1092:
1093:
1094: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id);
1096: END IF;
1097:
1098: -- call to business logic.
1099: do_delete_COND_ASSIGNMENT(l_cond_assignment_id ,

Line 1102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1098: -- call to business logic.
1099: do_delete_COND_ASSIGNMENT(l_cond_assignment_id ,
1100: x_return_status ) ;
1101:
1102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1103: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id ||' , return status is' || x_return_status);
1104: END IF;
1105:
1106:

Line 1103: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id ||' , return status is' || x_return_status);

1099: do_delete_COND_ASSIGNMENT(l_cond_assignment_id ,
1100: x_return_status ) ;
1101:
1102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1103: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id ||' , return status is' || x_return_status);
1104: END IF;
1105:
1106:
1107:

Line 1213: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1209: and cond_ass.END_DATE_ACTIVE is null;
1210:
1211: BEGIN
1212:
1213: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1214:
1215: -- Standard start of API savepoint
1216: SAVEPOINT VALIDATE_CUSTOM_CONDITIONS;
1217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');

Line 1217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');

1213: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1214:
1215: -- Standard start of API savepoint
1216: SAVEPOINT VALIDATE_CUSTOM_CONDITIONS;
1217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
1218:
1219: -- Standard call to check for call compatibility
1220: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1232: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');

1228:
1229: -- Initialize API return status to success
1230: l_return_status := FND_API.G_RET_STS_SUCCESS;
1231:
1232: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1233: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1234: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1235: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COMPLETE_FLAG = ' || P_COMPLETE_FLAG);
1236:

Line 1233: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);

1229: -- Initialize API return status to success
1230: l_return_status := FND_API.G_RET_STS_SUCCESS;
1231:
1232: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1233: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1234: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1235: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COMPLETE_FLAG = ' || P_COMPLETE_FLAG);
1236:
1237: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for custom conditions...');

Line 1234: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);

1230: l_return_status := FND_API.G_RET_STS_SUCCESS;
1231:
1232: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1233: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1234: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1235: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COMPLETE_FLAG = ' || P_COMPLETE_FLAG);
1236:
1237: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for custom conditions...');
1238: l_success_count := 0;

Line 1235: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COMPLETE_FLAG = ' || P_COMPLETE_FLAG);

1231:
1232: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1233: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1234: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1235: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COMPLETE_FLAG = ' || P_COMPLETE_FLAG);
1236:
1237: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for custom conditions...');
1238: l_success_count := 0;
1239: l_failed_count := 0;

Line 1237: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for custom conditions...');

1233: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1234: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1235: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COMPLETE_FLAG = ' || P_COMPLETE_FLAG);
1236:
1237: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for custom conditions...');
1238: l_success_count := 0;
1239: l_failed_count := 0;
1240: i := 0;
1241: open custom_conditions_cur(P_OWNER_OBJECT_ID, P_CONDITION_TYPE);

Line 1255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Custom condition ' || i);

1251: l_CUSTOM_PROCEDURE;
1252: exit when custom_conditions_cur%NOTFOUND;
1253:
1254: i := i + 1;
1255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Custom condition ' || i);
1256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_COND_ASSIGNMENT_ID = ' || l_COND_ASSIGNMENT_ID);
1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);

Line 1256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_COND_ASSIGNMENT_ID = ' || l_COND_ASSIGNMENT_ID);

1252: exit when custom_conditions_cur%NOTFOUND;
1253:
1254: i := i + 1;
1255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Custom condition ' || i);
1256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_COND_ASSIGNMENT_ID = ' || l_COND_ASSIGNMENT_ID);
1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);

Line 1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);

1253:
1254: i := i + 1;
1255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Custom condition ' || i);
1256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_COND_ASSIGNMENT_ID = ' || l_COND_ASSIGNMENT_ID);
1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);

Line 1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);

1254: i := i + 1;
1255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Custom condition ' || i);
1256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_COND_ASSIGNMENT_ID = ' || l_COND_ASSIGNMENT_ID);
1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);

Line 1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);

1255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Custom condition ' || i);
1256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_COND_ASSIGNMENT_ID = ' || l_COND_ASSIGNMENT_ID);
1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1263:

Line 1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);

1256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_COND_ASSIGNMENT_ID = ' || l_COND_ASSIGNMENT_ID);
1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1263:
1264: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Validating custom condition ' || l_CONDITION_NAME || '...');

Line 1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);

1257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1263:
1264: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Validating custom condition ' || l_CONDITION_NAME || '...');
1265: VALIDATE_CUSTOM_CONDITION(

Line 1262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);

1258: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1263:
1264: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Validating custom condition ' || l_CONDITION_NAME || '...');
1265: VALIDATE_CUSTOM_CONDITION(
1266: P_API_VERSION => 1.0,

Line 1264: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Validating custom condition ' || l_CONDITION_NAME || '...');

1260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1263:
1264: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Validating custom condition ' || l_CONDITION_NAME || '...');
1265: VALIDATE_CUSTOM_CONDITION(
1266: P_API_VERSION => 1.0,
1267: P_INIT_MSG_LIST => FND_API.G_FALSE,
1268: P_COMMIT => FND_API.G_FALSE,

Line 1291: LogMessage(FND_LOG.LEVEL_STATEMENT, '-------------');

1287:
1288: END LOOP;
1289: close custom_conditions_cur;
1290:
1291: LogMessage(FND_LOG.LEVEL_STATEMENT, '-------------');
1292: if i = 0 then
1293: LogMessage(FND_LOG.LEVEL_STATEMENT, 'No custom conditions found. Exiting.');
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295: return;

Line 1293: LogMessage(FND_LOG.LEVEL_STATEMENT, 'No custom conditions found. Exiting.');

1289: close custom_conditions_cur;
1290:
1291: LogMessage(FND_LOG.LEVEL_STATEMENT, '-------------');
1292: if i = 0 then
1293: LogMessage(FND_LOG.LEVEL_STATEMENT, 'No custom conditions found. Exiting.');
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295: return;
1296: end if;
1297:

Line 1298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully validated custom conditions: ' || l_success_count);

1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295: return;
1296: end if;
1297:
1298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully validated custom conditions: ' || l_success_count);
1299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Failed custom conditions: ' || l_failed_count);
1300: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Total validated custom conditions: ' || i);
1301:
1302: if l_failed_count > 0 then

Line 1299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Failed custom conditions: ' || l_failed_count);

1295: return;
1296: end if;
1297:
1298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully validated custom conditions: ' || l_success_count);
1299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Failed custom conditions: ' || l_failed_count);
1300: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Total validated custom conditions: ' || i);
1301:
1302: if l_failed_count > 0 then
1303: RAISE FND_API.G_EXC_ERROR;

Line 1300: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Total validated custom conditions: ' || i);

1296: end if;
1297:
1298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully validated custom conditions: ' || l_success_count);
1299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Failed custom conditions: ' || l_failed_count);
1300: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Total validated custom conditions: ' || i);
1301:
1302: if l_failed_count > 0 then
1303: RAISE FND_API.G_EXC_ERROR;
1304: end if;

Line 1331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');

1327: end if;
1328:
1329: if P_COMMIT = FND_API.G_TRUE then
1330: COMMIT WORK;
1331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1332: end if;
1333:
1334: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated all custom conditions for object ' || P_OWNER_OBJECT_ID || '; type ' || P_CONDITION_TYPE);
1335:

Line 1334: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated all custom conditions for object ' || P_OWNER_OBJECT_ID || '; type ' || P_CONDITION_TYPE);

1330: COMMIT WORK;
1331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1332: end if;
1333:
1334: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated all custom conditions for object ' || P_OWNER_OBJECT_ID || '; type ' || P_CONDITION_TYPE);
1335:
1336: -- END OF BODY OF API
1337: x_return_status := FND_API.G_RET_STS_SUCCESS;
1338:

Line 1345: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1341: p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data);
1344:
1345: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1346:
1347: EXCEPTION
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;

Line 1352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1354: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1357: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

1353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1354: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1357: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1358: WHEN OTHERS THEN
1359: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

Line 1365: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1363: END IF;
1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1365: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1366: END;
1367:
1368:
1369:

Line 1422: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1418: and cond_ass.END_DATE_ACTIVE is null;
1419:
1420: BEGIN
1421:
1422: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1423:
1424: -- Standard call to check for call compatibility
1425: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1437: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');

1433:
1434: -- Initialize API return status to success
1435: l_return_status := FND_API.G_RET_STS_SUCCESS;
1436:
1437: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1438: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COND_ASSIGNMENT_ID = ' || P_COND_ASSIGNMENT_ID);
1439:
1440: /* querying condition info */
1441: open cond_info_cur(P_COND_ASSIGNMENT_ID);

Line 1438: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COND_ASSIGNMENT_ID = ' || P_COND_ASSIGNMENT_ID);

1434: -- Initialize API return status to success
1435: l_return_status := FND_API.G_RET_STS_SUCCESS;
1436:
1437: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1438: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_COND_ASSIGNMENT_ID = ' || P_COND_ASSIGNMENT_ID);
1439:
1440: /* querying condition info */
1441: open cond_info_cur(P_COND_ASSIGNMENT_ID);
1442: fetch cond_info_cur into

Line 1451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Condition info:');

1447: l_MANDATORY_FLAG,
1448: l_CUSTOM_PROCEDURE;
1449: close cond_info_cur;
1450:
1451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Condition info:');
1452: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);

Line 1452: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);

1448: l_CUSTOM_PROCEDURE;
1449: close cond_info_cur;
1450:
1451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Condition info:');
1452: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);

Line 1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);

1449: close cond_info_cur;
1450:
1451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Condition info:');
1452: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1457: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);

Line 1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);

1450:
1451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Condition info:');
1452: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1457: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1458:

Line 1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);

1451: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Condition info:');
1452: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1457: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1458:
1459: if l_CUSTOM_PROCEDURE is null then

Line 1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);

1452: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_ID = ' || l_CONDITION_ID);
1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1457: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1458:
1459: if l_CUSTOM_PROCEDURE is null then
1460: LogMessage(FND_LOG.LEVEL_STATEMENT, 'This is not custom condition. Exiting.');

Line 1457: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);

1453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_NAME = ' || l_CONDITION_NAME);
1454: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_DESCRIPTION = ' || l_CONDITION_DESCRIPTION);
1455: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CONDITION_TYPE = ' || l_CONDITION_TYPE);
1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1457: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1458:
1459: if l_CUSTOM_PROCEDURE is null then
1460: LogMessage(FND_LOG.LEVEL_STATEMENT, 'This is not custom condition. Exiting.');
1461: return;

Line 1460: LogMessage(FND_LOG.LEVEL_STATEMENT, 'This is not custom condition. Exiting.');

1456: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MANDATORY_FLAG = ' || l_MANDATORY_FLAG);
1457: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_CUSTOM_PROCEDURE = ' || l_CUSTOM_PROCEDURE);
1458:
1459: if l_CUSTOM_PROCEDURE is null then
1460: LogMessage(FND_LOG.LEVEL_STATEMENT, 'This is not custom condition. Exiting.');
1461: return;
1462: end if;
1463:
1464: l_plsql_block := 'BEGIN ' || l_CUSTOM_PROCEDURE || '(:1, :2, :3); END;';

Line 1468: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_plsql_block = ' || l_plsql_block);

1464: l_plsql_block := 'BEGIN ' || l_CUSTOM_PROCEDURE || '(:1, :2, :3); END;';
1465:
1466: BEGIN
1467:
1468: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_plsql_block = ' || l_plsql_block);
1469: logMessage(FND_LOG.LEVEL_STATEMENT, 'Calling...');
1470:
1471: EXECUTE IMMEDIATE l_plsql_block
1472: USING

Line 1469: logMessage(FND_LOG.LEVEL_STATEMENT, 'Calling...');

1465:
1466: BEGIN
1467:
1468: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_plsql_block = ' || l_plsql_block);
1469: logMessage(FND_LOG.LEVEL_STATEMENT, 'Calling...');
1470:
1471: EXECUTE IMMEDIATE l_plsql_block
1472: USING
1473: IN P_COND_ASSIGNMENT_ID,

Line 1477: logMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

1473: IN P_COND_ASSIGNMENT_ID,
1474: OUT l_result,
1475: OUT l_error;
1476:
1477: logMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');

Line 1485: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');
1482: FND_MESSAGE.SET_TOKEN('COND_NAME' ,l_CONDITION_NAME);
1483: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,SQLERRM);
1484: FND_MSG_PUB.ADD;
1485: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1486: RAISE FND_API.G_EXC_ERROR;
1487: END;
1488:
1489: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_result = ' || l_result);

Line 1489: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_result = ' || l_result);

1485: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1486: RAISE FND_API.G_EXC_ERROR;
1487: END;
1488:
1489: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_result = ' || l_result);
1490: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_error = ' || l_error);
1491:
1492: if l_result = 'N' then
1493: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');

Line 1490: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_error = ' || l_error);

1486: RAISE FND_API.G_EXC_ERROR;
1487: END;
1488:
1489: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_result = ' || l_result);
1490: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_error = ' || l_error);
1491:
1492: if l_result = 'N' then
1493: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');
1494: FND_MESSAGE.SET_TOKEN('COND_NAME' ,l_CONDITION_NAME);

Line 1497: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1493: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');
1494: FND_MESSAGE.SET_TOKEN('COND_NAME' ,l_CONDITION_NAME);
1495: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,l_error);
1496: FND_MSG_PUB.ADD;
1497: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1498: RAISE FND_API.G_EXC_ERROR;
1499: end if;
1500:
1501: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated custom condition ' || l_CONDITION_NAME);

Line 1501: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated custom condition ' || l_CONDITION_NAME);

1497: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1498: RAISE FND_API.G_EXC_ERROR;
1499: end if;
1500:
1501: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated custom condition ' || l_CONDITION_NAME);
1502:
1503: -- END OF BODY OF API
1504: x_return_status := FND_API.G_RET_STS_SUCCESS;
1505:

Line 1512: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1508: p_encoded => FND_API.G_FALSE,
1509: p_count => x_msg_count,
1510: p_data => x_msg_data);
1511:
1512: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1513:
1514: EXCEPTION
1515: WHEN FND_API.G_EXC_ERROR THEN
1516: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1580: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1576: and cond_ass.END_DATE_ACTIVE is null;
1577:
1578: BEGIN
1579:
1580: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1581:
1582: -- Standard start of API savepoint
1583: SAVEPOINT DEFAULT_COND_ASSIGNMENTS;
1584: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');

Line 1584: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');

1580: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1581:
1582: -- Standard start of API savepoint
1583: SAVEPOINT DEFAULT_COND_ASSIGNMENTS;
1584: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
1585:
1586: -- Standard call to check for call compatibility
1587: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1599: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');

1595:
1596: -- Initialize API return status to success
1597: l_return_status := FND_API.G_RET_STS_SUCCESS;
1598:
1599: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1600: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
1601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1602: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1603:

Line 1600: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);

1596: -- Initialize API return status to success
1597: l_return_status := FND_API.G_RET_STS_SUCCESS;
1598:
1599: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1600: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
1601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1602: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1603:
1604: if P_LOAN_ID is null then

Line 1601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);

1597: l_return_status := FND_API.G_RET_STS_SUCCESS;
1598:
1599: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1600: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
1601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1602: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1603:
1604: if P_LOAN_ID is null then
1605: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

Line 1602: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);

1598:
1599: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1600: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
1601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1602: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1603:
1604: if P_LOAN_ID is null then
1605: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1606: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );

Line 1608: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1604: if P_LOAN_ID is null then
1605: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1606: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );
1607: FND_MSG_PUB.ADD;
1608: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1609: RAISE FND_API.G_EXC_ERROR;
1610: end if;
1611:
1612: if P_OWNER_OBJECT_ID is null then

Line 1616: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1612: if P_OWNER_OBJECT_ID is null then
1613: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1614: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_OWNER_OBJECT_ID' );
1615: FND_MSG_PUB.ADD;
1616: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1617: RAISE FND_API.G_EXC_ERROR;
1618: end if;
1619:
1620: if P_CONDITION_TYPE is null then

Line 1624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1620: if P_CONDITION_TYPE is null then
1621: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1622: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_CONDITION_TYPE' );
1623: FND_MSG_PUB.ADD;
1624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1625: RAISE FND_API.G_EXC_ERROR;
1626: end if;
1627:
1628: if P_CONDITION_TYPE <> 'LOAN_AMOUNT_ADJUSTMENT' and

Line 1636: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1632: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_INVALID_VALUE' );
1633: FND_MESSAGE.SET_TOKEN( 'PARAMETER', 'P_CONDITION_TYPE' );
1634: FND_MESSAGE.SET_TOKEN( 'VALUE', P_CONDITION_TYPE );
1635: FND_MSG_PUB.ADD;
1636: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1637: RAISE FND_API.G_EXC_ERROR;
1638: end if;
1639:
1640: i := 0;

Line 1679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Creating cond_ass ' || i);

1675: l_cond_assignment_rec.DISB_HEADER_ID := P_OWNER_OBJECT_ID;
1676: end if;
1677:
1678: i := i + 1;
1679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Creating cond_ass ' || i);
1680: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_ID = ' || l_cond_assignment_rec.CONDITION_ID);
1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);
1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);

Line 1680: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_ID = ' || l_cond_assignment_rec.CONDITION_ID);

1676: end if;
1677:
1678: i := i + 1;
1679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Creating cond_ass ' || i);
1680: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_ID = ' || l_cond_assignment_rec.CONDITION_ID);
1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);
1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);

Line 1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);

1677:
1678: i := i + 1;
1679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Creating cond_ass ' || i);
1680: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_ID = ' || l_cond_assignment_rec.CONDITION_ID);
1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);
1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);
1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);

Line 1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);

1678: i := i + 1;
1679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Creating cond_ass ' || i);
1680: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_ID = ' || l_cond_assignment_rec.CONDITION_ID);
1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);
1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);
1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);
1686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_TABLE = ' || l_cond_assignment_rec.OWNER_TABLE);

Line 1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);

1679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Creating cond_ass ' || i);
1680: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_ID = ' || l_cond_assignment_rec.CONDITION_ID);
1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);
1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);
1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);
1686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_TABLE = ' || l_cond_assignment_rec.OWNER_TABLE);
1687: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DISB_HEADER_ID = ' || l_cond_assignment_rec.DISB_HEADER_ID);

Line 1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);

1680: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_ID = ' || l_cond_assignment_rec.CONDITION_ID);
1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);
1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);
1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);
1686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_TABLE = ' || l_cond_assignment_rec.OWNER_TABLE);
1687: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DISB_HEADER_ID = ' || l_cond_assignment_rec.DISB_HEADER_ID);
1688:

Line 1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);

1681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_NAME = ' || l_cond_name);
1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);
1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);
1686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_TABLE = ' || l_cond_assignment_rec.OWNER_TABLE);
1687: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DISB_HEADER_ID = ' || l_cond_assignment_rec.DISB_HEADER_ID);
1688:
1689: -- call to business logic.

Line 1686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_TABLE = ' || l_cond_assignment_rec.OWNER_TABLE);

1682: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CONDITION_DESCRIPTION = ' || l_cond_assignment_rec.CONDITION_DESCRIPTION);
1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);
1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);
1686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_TABLE = ' || l_cond_assignment_rec.OWNER_TABLE);
1687: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DISB_HEADER_ID = ' || l_cond_assignment_rec.DISB_HEADER_ID);
1688:
1689: -- call to business logic.
1690: do_create_COND_ASSIGNMENT(l_cond_assignment_rec,

Line 1687: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DISB_HEADER_ID = ' || l_cond_assignment_rec.DISB_HEADER_ID);

1683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MANDATORY_FLAG = ' || l_cond_assignment_rec.MANDATORY_FLAG);
1684: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);
1685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_OBJECT_ID = ' || l_cond_assignment_rec.OWNER_OBJECT_ID);
1686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OWNER_TABLE = ' || l_cond_assignment_rec.OWNER_TABLE);
1687: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DISB_HEADER_ID = ' || l_cond_assignment_rec.DISB_HEADER_ID);
1688:
1689: -- call to business logic.
1690: do_create_COND_ASSIGNMENT(l_cond_assignment_rec,
1691: l_cond_assignment_id,

Line 1693: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COND_ASSIGNMENT_ID = ' || l_cond_assignment_id);

1689: -- call to business logic.
1690: do_create_COND_ASSIGNMENT(l_cond_assignment_rec,
1691: l_cond_assignment_id,
1692: x_return_status) ;
1693: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COND_ASSIGNMENT_ID = ' || l_cond_assignment_id);
1694:
1695: END LOOP;
1696: close cond_info_cur;
1697:

Line 1700: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');

1696: close cond_info_cur;
1697:
1698: if P_COMMIT = FND_API.G_TRUE then
1699: COMMIT WORK;
1700: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1701: end if;
1702:
1703: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully created ' || i || ' condition assignments');
1704:

Line 1703: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully created ' || i || ' condition assignments');

1699: COMMIT WORK;
1700: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1701: end if;
1702:
1703: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully created ' || i || ' condition assignments');
1704:
1705: -- END OF BODY OF API
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707:

Line 1714: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1710: p_encoded => FND_API.G_FALSE,
1711: p_count => x_msg_count,
1712: p_data => x_msg_data);
1713:
1714: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1715:
1716: EXCEPTION
1717: WHEN FND_API.G_EXC_ERROR THEN
1718: ROLLBACK TO DEFAULT_COND_ASSIGNMENTS;

Line 1782: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1778: and (cond_ass.CONDITION_MET_FLAG is null or cond_ass.CONDITION_MET_FLAG = 'N');
1779:
1780: BEGIN
1781:
1782: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1783:
1784: -- Standard call to check for call compatibility
1785: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1797: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');

1793:
1794: -- Initialize API return status to success
1795: l_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1798: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1799: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1800:
1801: -- checking for number of not met non-custom conditions

Line 1798: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);

1794: -- Initialize API return status to success
1795: l_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1798: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1799: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1800:
1801: -- checking for number of not met non-custom conditions
1802: open conditions_cur(P_OWNER_OBJECT_ID, P_CONDITION_TYPE);

Line 1799: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);

1795: l_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input:');
1798: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_OWNER_OBJECT_ID = ' || P_OWNER_OBJECT_ID);
1799: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_CONDITION_TYPE = ' || P_CONDITION_TYPE);
1800:
1801: -- checking for number of not met non-custom conditions
1802: open conditions_cur(P_OWNER_OBJECT_ID, P_CONDITION_TYPE);
1803: fetch conditions_cur into l_cond_count;

Line 1805: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_cond_count = ' || l_cond_count);

1801: -- checking for number of not met non-custom conditions
1802: open conditions_cur(P_OWNER_OBJECT_ID, P_CONDITION_TYPE);
1803: fetch conditions_cur into l_cond_count;
1804: close conditions_cur;
1805: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_cond_count = ' || l_cond_count);
1806:
1807: if l_cond_count > 0 then
1808: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_ALL_COND_MET');
1809: FND_MSG_PUB.Add;

Line 1813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated all non-custom conditions for object ' || P_OWNER_OBJECT_ID || '; type ' || P_CONDITION_TYPE);

1809: FND_MSG_PUB.Add;
1810: RAISE FND_API.G_EXC_ERROR;
1811: end if;
1812:
1813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated all non-custom conditions for object ' || P_OWNER_OBJECT_ID || '; type ' || P_CONDITION_TYPE);
1814:
1815: -- END OF BODY OF API
1816: x_return_status := FND_API.G_RET_STS_SUCCESS;
1817:

Line 1824: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1820: p_encoded => FND_API.G_FALSE,
1821: p_count => x_msg_count,
1822: p_data => x_msg_data);
1823:
1824: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1846: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1842:
1843:
1844: BEGIN
1845: G_LOG_ENABLED := 'N';
1846: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1847:
1848: /* getting msg logging info */
1849: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1850: if (G_LOG_ENABLED = 'N') then

Line 1851: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1847:
1848: /* getting msg logging info */
1849: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1850: if (G_LOG_ENABLED = 'N') then
1851: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1852: else
1853: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1854: end if;
1855:

Line 1853: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

1849: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1850: if (G_LOG_ENABLED = 'N') then
1851: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1852: else
1853: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1854: end if;
1855:
1856: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1857: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);

Line 1856: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

1852: else
1853: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1854: end if;
1855:
1856: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1857: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);
1858:
1859: END LNS_COND_ASSIGNMENT_PUB;

Line 1857: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);

1853: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1854: end if;
1855:
1856: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1857: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);
1858:
1859: END LNS_COND_ASSIGNMENT_PUB;