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_API

Line 244: RAISE FND_API.G_EXC_ERROR;

240:
241: IF Cur_loan_details%NOTFOUND THEN
242: LogErrors(p_message_name=>'LNS_LCREATE_INVALID_ATTRIBUTE'
243: ,p_token1=> 'Loan ID = '||l_loan_id);
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246: CLOSE Cur_loan_details;
247:
248: IF l_loan_status = 'INCOMPLETE' THEN

Line 276: RAISE FND_API.G_EXC_ERROR;

272:
273: IF g_error_count = 0 THEN
274: l_apply_submit_for_approval := 'Y';
275: ELSE
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;
278:
279: IF (l_ready_for_submit_approval = 'Y') THEN
280: l_apply_submit_for_approval := 'N';

Line 317: P_INIT_MSG_LIST => FND_API.G_TRUE,

313: ,p_token1=>' for loan ID '||l_loan_id);
314: ELSIF l_loan_class = 'DIRECT' THEN
315: lns_funding_pub.validate_disb_for_appr(
316: P_API_VERSION => 1.0,
317: P_INIT_MSG_LIST => FND_API.G_TRUE,
318: P_COMMIT => FND_API.G_FALSE,
319: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
320: P_LOAN_ID => l_loan_id,
321: X_RETURN_STATUS => l_return_status,

Line 318: P_COMMIT => FND_API.G_FALSE,

314: ELSIF l_loan_class = 'DIRECT' THEN
315: lns_funding_pub.validate_disb_for_appr(
316: P_API_VERSION => 1.0,
317: P_INIT_MSG_LIST => FND_API.G_TRUE,
318: P_COMMIT => FND_API.G_FALSE,
319: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
320: P_LOAN_ID => l_loan_id,
321: X_RETURN_STATUS => l_return_status,
322: X_MSG_COUNT => l_msg_count,

Line 319: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

315: lns_funding_pub.validate_disb_for_appr(
316: P_API_VERSION => 1.0,
317: P_INIT_MSG_LIST => FND_API.G_TRUE,
318: P_COMMIT => FND_API.G_FALSE,
319: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
320: P_LOAN_ID => l_loan_id,
321: X_RETURN_STATUS => l_return_status,
322: X_MSG_COUNT => l_msg_count,
323: X_MSG_DATA => l_msg_data

Line 329: RAISE FND_API.G_EXC_ERROR;

325: IF l_return_status <> 'S' THEN
326: LogErrors(p_message_name=>'LNS_PLSQL_API_ERROR'
327: ,p_api_name => 'lns_funding_pub.validate_disb_for_app()'
328: ,p_err_msg => l_msg_data);
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331: END IF;
332:
333: IF g_error_count = 0 THEN

Line 336: RAISE FND_API.G_EXC_ERROR;

332:
333: IF g_error_count = 0 THEN
334: l_apply_submit_for_approval := 'Y';
335: ELSE
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: END IF;
339:
340: IF l_apply_submit_for_approval = 'Y' THEN

Line 345: P_INIT_MSG_LIST => FND_API.G_TRUE,

341:
342: IF (l_loan_class = 'DIRECT') THEN
343: lns_funding_pub.set_autofunding(
344: P_API_VERSION => 1.0,
345: P_INIT_MSG_LIST => FND_API.G_TRUE,
346: P_COMMIT => FND_API.G_FALSE,
347: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
348: P_LOAN_ID => l_loan_id,
349: P_AUTOFUNDING_FLAG => p_auto_funding_flag,

Line 346: P_COMMIT => FND_API.G_FALSE,

342: IF (l_loan_class = 'DIRECT') THEN
343: lns_funding_pub.set_autofunding(
344: P_API_VERSION => 1.0,
345: P_INIT_MSG_LIST => FND_API.G_TRUE,
346: P_COMMIT => FND_API.G_FALSE,
347: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
348: P_LOAN_ID => l_loan_id,
349: P_AUTOFUNDING_FLAG => p_auto_funding_flag,
350: X_RETURN_STATUS => l_return_status,

Line 347: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

343: lns_funding_pub.set_autofunding(
344: P_API_VERSION => 1.0,
345: P_INIT_MSG_LIST => FND_API.G_TRUE,
346: P_COMMIT => FND_API.G_FALSE,
347: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
348: P_LOAN_ID => l_loan_id,
349: P_AUTOFUNDING_FLAG => p_auto_funding_flag,
350: X_RETURN_STATUS => l_return_status,
351: X_MSG_COUNT => l_msg_count,

Line 360: RAISE FND_API.G_EXC_ERROR;

356: IF l_return_status <> 'S' THEN
357: LogErrors(p_message_name=>'LNS_PLSQL_API_ERROR'
358: ,p_api_name => 'lns_funding_pub.set_autofunding()'
359: ,p_err_msg => l_msg_data);
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363:
364: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,

Line 364: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,

360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363:
364: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
365: p_approval_action_rec => p_approval_action_rec,
366: x_action_id => l_action_id,
367: X_RETURN_STATUS => l_return_status,
368: X_MSG_COUNT => l_msg_count,

Line 376: RAISE FND_API.G_EXC_ERROR;

372: IF l_return_status <> 'S' THEN
373: LogErrors(p_message_name=>'LNS_PLSQL_API_ERROR'
374: ,p_api_name => 'LNS_APPROVAL_ACTION_PUB.create_approval_action()'
375: ,p_err_msg => l_msg_data);
376: RAISE FND_API.G_EXC_ERROR;
377: END IF;
378: END IF;
379:
380: IF g_error_count > 0 THEN

Line 382: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

378: END IF;
379:
380: IF g_error_count > 0 THEN
381: InsertErrors;
382: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
383: X_MSG_COUNT := g_error_count;
384: ELSE
385: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
386: X_MSG_COUNT := 0;

Line 385: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

381: InsertErrors;
382: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
383: X_MSG_COUNT := g_error_count;
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

Line 390: WHEN FND_API.G_EXC_ERROR THEN

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;
393: X_MSG_COUNT := g_error_count;
394:

Line 392: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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;
393: X_MSG_COUNT := g_error_count;
394:
395: WHEN OTHERS THEN
396: InsertErrors;

Line 397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

393: X_MSG_COUNT := g_error_count;
394:
395: WHEN OTHERS THEN
396: InsertErrors;
397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
398: X_MSG_COUNT := g_error_count;
399: -- raise;
400:
401: END SUBMIT_FOR_APPROVAL;