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_WORK_FLOW dependencies on LNS_APPROVAL_ACTION_PUB

Line 1619: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;

1615: l_api_version CONSTANT NUMBER := 1.0;
1616: l_object_version_number NUMBER := 1;
1617: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1618: l_loan_approve_note VARCHAR2(2000);
1619: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1620: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1621: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
1622: l_action_id NUMBER;
1623: l_note_id NUMBER;

Line 1715: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );

1711: l_loan_approval_action_rec.attribute18 := null;
1712: l_loan_approval_action_rec.attribute19 := null;
1713: l_loan_approval_action_rec.attribute20 := null;
1714:
1715: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
1716:
1717: -- fix for bug 13785835: set org context before approving loan from notification
1718: MO_GLOBAL.INIT('LNS');
1719: MO_GLOBAL.set_policy_context('S',l_org_id);

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

1717: -- fix for bug 13785835: set org context before approving loan from notification
1718: MO_GLOBAL.INIT('LNS');
1719: MO_GLOBAL.set_policy_context('S',l_org_id);
1720:
1721: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
1722: p_approval_action_rec => l_loan_approval_action_rec,
1723: x_action_id => l_action_id,
1724: X_RETURN_STATUS => l_RETURN_STATUS,
1725: X_MSG_COUNT => l_MSG_COUNT,

Line 1734: LogMessage(FND_LOG.LEVEL_STATEMENT,'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );

1730: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);
1731: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);
1732: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);
1733:
1734: LogMessage(FND_LOG.LEVEL_STATEMENT,'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
1735: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_approve_note : ' || l_loan_approve_note);
1736:
1737:
1738: IF (l_loan_approve_note is not null AND length(trim(l_loan_approve_note)) > 0) THEN

Line 1745: -- fix for bug 13785835: moved calls to MO_GLOBAL before call to LNS_APPROVAL_ACTION_PUB.create_approval_action

1741: -- to correctly pick the loan against given loan_id
1742: -- MO_GLOBAL.GET_CURRENT_ORG_ID() doesnt work here as it returns null when an external user
1743: -- is trying to approve a loan
1744:
1745: -- fix for bug 13785835: moved calls to MO_GLOBAL before call to LNS_APPROVAL_ACTION_PUB.create_approval_action
1746:
1747: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
1748: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1749: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;

Line 1865: l_loan_reject_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;

1861: l_api_version CONSTANT NUMBER := 1.0;
1862: l_object_version_number NUMBER := 1;
1863: l_nid NUMBER;
1864: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1865: l_loan_reject_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1866: l_loan_reject_note VARCHAR2(2000);
1867: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1868: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
1869: l_action_id NUMBER;

Line 1953: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );

1949: l_loan_reject_action_rec.attribute18 := null;
1950: l_loan_reject_action_rec.attribute19 := null;
1951: l_loan_reject_action_rec.attribute20 := null;
1952:
1953: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
1954:
1955: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
1956: p_approval_action_rec => l_loan_reject_action_rec,
1957: x_action_id => l_action_id,

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

1951: l_loan_reject_action_rec.attribute20 := null;
1952:
1953: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
1954:
1955: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
1956: p_approval_action_rec => l_loan_reject_action_rec,
1957: x_action_id => l_action_id,
1958: X_RETURN_STATUS => l_RETURN_STATUS,
1959: X_MSG_COUNT => l_MSG_COUNT,

Line 1968: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );

1964: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
1965: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);
1966: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);
1967:
1968: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
1969: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_REJECTION l_loan_reject_note : ' || l_loan_reject_note);
1970:
1971: IF (l_loan_reject_note is not null AND length(trim(l_loan_reject_note)) > 0) THEN
1972:

Line 2102: l_req_loan_info_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;

2098: l_api_version CONSTANT NUMBER := 1.0;
2099: l_object_version_number NUMBER := 1;
2100: l_nid NUMBER;
2101: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2102: l_req_loan_info_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
2103: l_req_loan_info_note VARCHAR2(2000);
2104: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
2105: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
2106: l_action_id NUMBER;

Line 2188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Calling LNS_APPROVAL_ACTION_PUB.create_approval_action...');

2184: l_req_loan_info_action_rec.attribute18 := null;
2185: l_req_loan_info_action_rec.attribute19 := null;
2186: l_req_loan_info_action_rec.attribute20 := null;
2187:
2188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Calling LNS_APPROVAL_ACTION_PUB.create_approval_action...');
2189: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
2190: p_approval_action_rec => l_req_loan_info_action_rec,
2191: x_action_id => l_action_id,
2192: X_RETURN_STATUS => l_RETURN_STATUS,

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

2185: l_req_loan_info_action_rec.attribute19 := null;
2186: l_req_loan_info_action_rec.attribute20 := null;
2187:
2188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Calling LNS_APPROVAL_ACTION_PUB.create_approval_action...');
2189: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
2190: p_approval_action_rec => l_req_loan_info_action_rec,
2191: x_action_id => l_action_id,
2192: X_RETURN_STATUS => l_RETURN_STATUS,
2193: X_MSG_COUNT => l_MSG_COUNT,

Line 2202: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );

2198: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
2199: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);
2200: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);
2201:
2202: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
2203:
2204: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_req_loan_info_note : ' || l_req_loan_info_note);
2205:
2206: --added by GPARUCHU to make sure that when an Approver requests for information, his status is made

Line 3247: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;

3243: l_api_version CONSTANT NUMBER := 1.0;
3244: l_object_version_number NUMBER := 1;
3245: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
3246: l_loan_approve_note VARCHAR2(2000);
3247: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
3248: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
3249: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
3250: l_action_id NUMBER;
3251: l_note_id NUMBER;

Line 3331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );

3327: l_loan_approval_action_rec.attribute18 := null;
3328: l_loan_approval_action_rec.attribute19 := null;
3329: l_loan_approval_action_rec.attribute20 := null;
3330:
3331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
3332:
3333: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
3334: p_approval_action_rec => l_loan_approval_action_rec,
3335: x_action_id => l_action_id,

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

3329: l_loan_approval_action_rec.attribute20 := null;
3330:
3331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
3332:
3333: LNS_APPROVAL_ACTION_PUB.create_approval_action (p_init_msg_list => FND_API.G_TRUE,
3334: p_approval_action_rec => l_loan_approval_action_rec,
3335: x_action_id => l_action_id,
3336: X_RETURN_STATUS => l_RETURN_STATUS,
3337: X_MSG_COUNT => l_MSG_COUNT,

Line 3346: LogMessage(FND_LOG.LEVEL_STATEMENT,'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );

3342: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);
3343: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);
3344: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);
3345:
3346: LogMessage(FND_LOG.LEVEL_STATEMENT,'END calling LNS_APPROVAL_ACTION_PUB.create_approval_action' );
3347: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_approve_note : ' || l_loan_approve_note);
3348:
3349:
3350: IF (l_loan_approve_note is not null AND length(trim(l_loan_approve_note)) > 0) THEN