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

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

51: IS
52: BEGIN
53: if (p_msg_level >= G_MSG_LEVEL) then
54:
55: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
56:
57: end if;
58:
59: EXCEPTION

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

57: end if;
58:
59: EXCEPTION
60: WHEN OTHERS THEN
61: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
62: END;
63: /*========================================================================
64: | PRIVATE PROCEDURE LogErrors
65: |

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

128: g_errors_rec(g_error_count).LINE_NUMBER := p_line_number;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
133: END;
134: /*========================================================================
135: | PRIVATE PROCEDURE InsertErrors
136: |

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

167: VALUES
168: g_errors_rec(i);
169: EXCEPTION
170: WHEN OTHERS THEN
171: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
172: END;
173:
174:
175:

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

222: WHERE
223: loan_id = p_loan_id;
224:
225: BEGIN
226: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
227:
228: l_loan_id := P_APPROVAL_ACTION_REC.loan_id;
229:
230: IF ((l_loan_id IS NULL) OR (trim(l_loan_id) = '')) THEN

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

384: ELSE
385: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
386: X_MSG_COUNT := 0;
387: END IF;
388: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
389: EXCEPTION
390: WHEN FND_API.G_EXC_ERROR THEN
391: InsertErrors;
392: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

438: l_count NUMBER := -1;
439:
440: BEGIN
441:
442: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
443:
444: SELECT
445: count(1) into l_count
446: FROM

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

454: ELSE
455: p_valid := 'Y';
456: END IF;
457:
458: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
459:
460: END VALIDATE_LOAN;
461:
462:

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

518: BEGIN
519:
520: p_status := 'N';
521: l_count := -1;
522: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
523:
524:
525: IF (NOT((p_loan_id IS NULL) OR (trim(p_loan_id) = ''))) THEN
526: OPEN Cur_Loan_Value_Met(p_loan_id);

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

531: p_status := 'Y';
532: END IF;
533: END IF;
534:
535: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
536:
537: END IS_LOAN_TO_VALUE_MET;
538:
539:

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

592: )
593: );
594: BEGIN
595:
596: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
597:
598: p_exist := 'N';
599: l_count := -1;
600: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

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

596: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
597:
598: p_exist := 'N';
599: l_count := -1;
600: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
601:
602: IF (NOT ((p_loan_id IS NULL) OR (trim(p_loan_id) = ''))) THEN
603: OPEN Cur_Collateral_Exist(p_loan_id);
604: FETCH Cur_Collateral_Exist into l_count;

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

608: p_exist := 'Y';
609: END IF;
610: END IF;
611:
612: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
613:
614: END IS_COLLATERAL_EXIST;
615:
616: /*========================================================================

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

658: | Cursor Declarations |
659: +-----------------------------------------------------------------------*/
660:
661: BEGIN
662: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
663:
664: p_cond_met := 'Y';
665: l_condition_type := '-';
666: l_count := -1;

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

693: IF l_count > 0 THEN
694: p_cond_met := 'N';
695: END IF;
696:
697: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
698: END ARE_CONDITIONS_MET;
699:
700: /*========================================================================
701: | PROCEDURE GET_LOAN_APPROVAL_ACCESS

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

734: | Cursor Declarations |
735: +-----------------------------------------------------------------------*/
736:
737: BEGIN
738: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
739:
740: SELECT
741: NVL(LOAN_APPR_REQ_FLAG,'Y') into l_appr_req_flag
742: FROM

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

750: ELSE
751: p_access := 'y';
752: END IF;
753:
754: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
755:
756:
757: END GET_LOAN_APPROVAL_ACCESS;
758:

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

808: and lines.end_date is null
809: and lines.reference_type = 'RECEIVABLE';
810:
811: BEGIN
812: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
813: p_status := 'INVALID';
814: IF( NOT((p_loan_id IS NULL) OR (trim(p_loan_id) = ''))) THEN
815: p_status := 'INVALID';
816: OPEN Csr_Loan_Amounts(p_loan_id);

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

820: p_status := 'VALID';
821: END IF;
822: END IF;
823:
824: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
825: END IS_LOAN_AMOUNT_VALID;
826:
827: BEGIN
828: G_LOG_ENABLED := 'N';

Line 829: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

825: END IS_LOAN_AMOUNT_VALID;
826:
827: BEGIN
828: G_LOG_ENABLED := 'N';
829: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
830:
831: /* getting msg logging info */
832: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
833: if (G_LOG_ENABLED = 'N') then

Line 834: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

830:
831: /* getting msg logging info */
832: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
833: if (G_LOG_ENABLED = 'N') then
834: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
835: else
836: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
837: end if;
838:

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

832: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
833: if (G_LOG_ENABLED = 'N') then
834: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
835: else
836: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
837: end if;
838:
839: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
840: END LNS_SUBMIT_FOR_APPROVAL_PUB;

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

835: else
836: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
837: end if;
838:
839: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
840: END LNS_SUBMIT_FOR_APPROVAL_PUB;