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_REP_UTILS dependencies on FND_API

Line 2226: RAISE FND_API.G_EXC_ERROR;

2222: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2223: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );
2224: FND_MSG_PUB.Add;
2225: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2226: RAISE FND_API.G_EXC_ERROR;
2227:
2228: end if;
2229:
2230: if P_AGREEMENT_REASON is null then

Line 2236: RAISE FND_API.G_EXC_ERROR;

2232: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2233: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGREEMENT_REASON' );
2234: FND_MSG_PUB.Add;
2235: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2236: RAISE FND_API.G_EXC_ERROR;
2237:
2238: end if;
2239:
2240: /* begin submit request to generate Loan Agreement Report */

Line 2281: RAISE FND_API.G_EXC_ERROR;

2277:
2278: if l_request_id = 0 then
2279: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
2280: FND_MSG_PUB.Add;
2281: RAISE FND_API.G_EXC_ERROR;
2282: end if;
2283: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
2284:
2285: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 2378: RAISE FND_API.G_EXC_ERROR;

2374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_FROM_LOAN_OFFICER');
2375: FND_MESSAGE.SET_TOKEN('VALUE', P_FROM_LOAN_OFFICER);
2376: FND_MSG_PUB.ADD;
2377: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2378: RAISE FND_API.G_EXC_ERROR;
2379: end if;
2380:
2381: if P_TO_LOAN_OFFICER is null then
2382: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 2387: RAISE FND_API.G_EXC_ERROR;

2383: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_TO_LOAN_OFFICER');
2384: FND_MESSAGE.SET_TOKEN('VALUE', P_TO_LOAN_OFFICER);
2385: FND_MSG_PUB.ADD;
2386: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2387: RAISE FND_API.G_EXC_ERROR;
2388: end if;
2389:
2390: /* init variables */
2391: l_count := 0;

Line 2417: P_INIT_MSG_LIST => FND_API.G_FALSE,

2413: l_loan_header_rec.loan_assigned_to := P_TO_LOAN_OFFICER;
2414:
2415: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
2416: P_LOAN_HEADER_REC => l_loan_header_rec,
2417: P_INIT_MSG_LIST => FND_API.G_FALSE,
2418: X_RETURN_STATUS => l_return_status,
2419: X_MSG_COUNT => l_msg_count,
2420: X_MSG_DATA => l_msg_data);
2421:

Line 2428: RAISE FND_API.G_EXC_ERROR;

2424: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_return_status: ' || l_return_status);
2425: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2426: FND_MSG_PUB.Add;
2427: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2428: RAISE FND_API.G_EXC_ERROR;
2429: END IF;
2430:
2431: --Everything successful here then go ahead and commit the updates
2432: COMMIT WORK;

Line 2600: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;

2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2597: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2598:
2599: if BORR_ACCESS_LEVEL = 'GLOBAL' then
2600: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;
2601: else
2602: l_participant_rec.ACCESS_LEVEL := BORR_ACCESS_LEVEL;
2603: end if;
2604:

Line 2607: p_init_msg_list => FND_API.G_TRUE

2603: end if;
2604:
2605: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2606: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2607: p_init_msg_list => FND_API.G_TRUE
2608: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2609: ,p_loan_participant_rec => l_participant_rec
2610: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
2611: ,x_return_status => l_return_status

Line 2608: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2604:
2605: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2606: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2607: p_init_msg_list => FND_API.G_TRUE
2608: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2609: ,p_loan_participant_rec => l_participant_rec
2610: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
2611: ,x_return_status => l_return_status
2612: ,x_msg_count => l_msg_count

Line 2616: RAISE FND_API.G_EXC_ERROR;

2612: ,x_msg_count => l_msg_count
2613: ,x_msg_data => l_msg_data
2614: );
2615: IF l_return_status <> 'S' THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618:
2619: COMMIT WORK;
2620: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');

Line 2676: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;

2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2673: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2674:
2675: if COBORR_ACCESS_LEVEL = 'GLOBAL' then
2676: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;
2677: else
2678: l_participant_rec.ACCESS_LEVEL := COBORR_ACCESS_LEVEL;
2679: end if;
2680:

Line 2683: p_init_msg_list => FND_API.G_TRUE

2679: end if;
2680:
2681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2682: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2683: p_init_msg_list => FND_API.G_TRUE
2684: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2685: ,p_loan_participant_rec => l_participant_rec
2686: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
2687: ,x_return_status => l_return_status

Line 2684: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2680:
2681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2682: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2683: p_init_msg_list => FND_API.G_TRUE
2684: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2685: ,p_loan_participant_rec => l_participant_rec
2686: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
2687: ,x_return_status => l_return_status
2688: ,x_msg_count => l_msg_count

Line 2692: RAISE FND_API.G_EXC_ERROR;

2688: ,x_msg_count => l_msg_count
2689: ,x_msg_data => l_msg_data
2690: );
2691: IF l_return_status <> 'S' THEN
2692: RAISE FND_API.G_EXC_ERROR;
2693: END IF;
2694:
2695: COMMIT WORK;
2696: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');

Line 2751: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;

2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2748: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2749:
2750: if GUAR_ACCESS_LEVEL = 'GLOBAL' then
2751: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;
2752: else
2753: l_participant_rec.ACCESS_LEVEL := GUAR_ACCESS_LEVEL;
2754: end if;
2755:

Line 2758: p_init_msg_list => FND_API.G_TRUE

2754: end if;
2755:
2756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2757: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2758: p_init_msg_list => FND_API.G_TRUE
2759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2760: ,p_loan_participant_rec => l_participant_rec
2761: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
2762: ,x_return_status => l_return_status

Line 2759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2755:
2756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2757: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2758: p_init_msg_list => FND_API.G_TRUE
2759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2760: ,p_loan_participant_rec => l_participant_rec
2761: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
2762: ,x_return_status => l_return_status
2763: ,x_msg_count => l_msg_count

Line 2767: RAISE FND_API.G_EXC_ERROR;

2763: ,x_msg_count => l_msg_count
2764: ,x_msg_data => l_msg_data
2765: );
2766: IF l_return_status <> 'S' THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: END IF;
2769:
2770: COMMIT WORK;
2771: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');

Line 3080: P_INIT_MSG_LIST => FND_API.G_TRUE,

3076: l_amort_tbl.delete;
3077: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ' || l_BASED_ON_TERMS || ' SCHEDULE_TYPE...');
3078: LNS_FINANCIALS.runAmortization(
3079: P_API_VERSION => 1.0,
3080: P_INIT_MSG_LIST => FND_API.G_TRUE,
3081: P_COMMIT => FND_API.G_FALSE,
3082: P_LOAN_ID => l_loan_id,
3083: P_BASED_ON_TERMS => l_BASED_ON_TERMS,
3084: x_amort_tbl => l_amort_tbl,

Line 3081: P_COMMIT => FND_API.G_FALSE,

3077: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ' || l_BASED_ON_TERMS || ' SCHEDULE_TYPE...');
3078: LNS_FINANCIALS.runAmortization(
3079: P_API_VERSION => 1.0,
3080: P_INIT_MSG_LIST => FND_API.G_TRUE,
3081: P_COMMIT => FND_API.G_FALSE,
3082: P_LOAN_ID => l_loan_id,
3083: P_BASED_ON_TERMS => l_BASED_ON_TERMS,
3084: x_amort_tbl => l_amort_tbl,
3085: x_return_status => l_return_status,

Line 3092: RAISE FND_API.G_EXC_ERROR;

3088:
3089: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
3090: IF l_return_status <> 'S' THEN
3091: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3094:
3095: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_BASED_ON_TERMS || ' amortization schedule:');
3096: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');

Line 3215: P_INIT_MSG_LIST => FND_API.G_TRUE,

3211: l_amort_tbl.delete;
3212: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ORIGINAL SCHEDULE_TYPE...');
3213: LNS_FINANCIALS.runAmortization(
3214: P_API_VERSION => 1.0,
3215: P_INIT_MSG_LIST => FND_API.G_TRUE,
3216: P_COMMIT => FND_API.G_FALSE,
3217: P_LOAN_ID => l_loan_id,
3218: P_BASED_ON_TERMS => 'ORIGINAL',
3219: x_amort_tbl => l_amort_tbl,

Line 3216: P_COMMIT => FND_API.G_FALSE,

3212: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ORIGINAL SCHEDULE_TYPE...');
3213: LNS_FINANCIALS.runAmortization(
3214: P_API_VERSION => 1.0,
3215: P_INIT_MSG_LIST => FND_API.G_TRUE,
3216: P_COMMIT => FND_API.G_FALSE,
3217: P_LOAN_ID => l_loan_id,
3218: P_BASED_ON_TERMS => 'ORIGINAL',
3219: x_amort_tbl => l_amort_tbl,
3220: x_return_status => l_return_status,

Line 3227: RAISE FND_API.G_EXC_ERROR;

3223:
3224: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
3225: IF l_return_status <> 'S' THEN
3226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;
3229:
3230: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORIGINAL amortization schedule:');
3231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');