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 JTF_NOTES_PUB

Line 1621: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

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;
1624: l_MSG_DATA VARCHAR2(32767);
1625: l_MSG_COUNT NUMBER;

Line 1740: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method

1736:
1737:
1738: IF (l_loan_approve_note is not null AND length(trim(l_loan_approve_note)) > 0) THEN
1739:
1740: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method
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:

Line 1756: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );

1752: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1755:
1756: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1757: JTF_NOTES_PUB.CREATE_NOTE(
1758: P_API_VERSION => 1.0,
1759: P_INIT_MSG_LIST => FND_API.G_TRUE,
1760: P_COMMIT => FND_API.G_TRUE,

Line 1757: JTF_NOTES_PUB.CREATE_NOTE(

1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1755:
1756: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1757: JTF_NOTES_PUB.CREATE_NOTE(
1758: P_API_VERSION => 1.0,
1759: P_INIT_MSG_LIST => FND_API.G_TRUE,
1760: P_COMMIT => FND_API.G_TRUE,
1761: P_JTF_NOTE_ID => FND_API.G_MISS_NUM,

Line 1804: LogMessage(FND_LOG.LEVEL_STATEMENT,'End calling JTF_NOTES_PUB.CREATE_NOTE' );

1800: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_note_id : ' || l_note_id);
1801: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);
1802: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);
1803: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);
1804: LogMessage(FND_LOG.LEVEL_STATEMENT,'End calling JTF_NOTES_PUB.CREATE_NOTE' );
1805:
1806: END IF;
1807:
1808: resultout := 'COMPLETE:' || 'Y';

Line 1868: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

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;
1870: l_note_id NUMBER;
1871: l_MSG_DATA VARCHAR2(32767);
1872: l_MSG_COUNT NUMBER;

Line 1973: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method

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:
1973: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method
1974: -- to correctly pick the loan against given loan_id
1975: -- MO_GLOBAL.GET_CURRENT_ORG_ID() doesnt work here as it returns null when an external user
1976: -- is trying to approve a loan
1977:

Line 1990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling JTF_NOTES_PUB.CREATE_NOTE' );

1986: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1987: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1989:
1990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1991:
1992: JTF_NOTES_PUB.CREATE_NOTE(
1993: P_API_VERSION => 1.0,
1994: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 1992: JTF_NOTES_PUB.CREATE_NOTE(

1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1989:
1990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1991:
1992: JTF_NOTES_PUB.CREATE_NOTE(
1993: P_API_VERSION => 1.0,
1994: P_INIT_MSG_LIST => FND_API.G_TRUE,
1995: P_COMMIT => FND_API.G_TRUE,
1996: P_JTF_NOTE_ID => FND_API.G_MISS_NUM,

Line 2040: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling JTF_NOTES_PUB.CREATE_NOTE' );

2036: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
2037: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);
2038: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);
2039:
2040: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling JTF_NOTES_PUB.CREATE_NOTE' );
2041:
2042: END IF;
2043:
2044: resultout := 'COMPLETE:' || 'Y';

Line 2105: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

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;
2107: l_note_id NUMBER;
2108: l_MSG_DATA VARCHAR2(32767);
2109: l_MSG_COUNT NUMBER;

Line 2237: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method

2233: END IF;
2234:
2235: IF (l_req_loan_info_note is not null AND length(trim(l_req_loan_info_note)) > 0) THEN
2236:
2237: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method
2238: -- to correctly pick the loan against given loan_id
2239: -- MO_GLOBAL.GET_CURRENT_ORG_ID() doesnt work here as it returns null when an external user
2240: -- is trying to approve a loan
2241:

Line 2254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before calling JTF_NOTES_PUB.CREATE_NOTE' );

2250: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
2251: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
2253:
2254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before calling JTF_NOTES_PUB.CREATE_NOTE' );
2255:
2256: JTF_NOTES_PUB.CREATE_NOTE(
2257: P_API_VERSION => 1.0,
2258: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 2256: JTF_NOTES_PUB.CREATE_NOTE(

2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
2253:
2254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before calling JTF_NOTES_PUB.CREATE_NOTE' );
2255:
2256: JTF_NOTES_PUB.CREATE_NOTE(
2257: P_API_VERSION => 1.0,
2258: P_INIT_MSG_LIST => FND_API.G_TRUE,
2259: P_COMMIT => FND_API.G_TRUE,
2260: P_JTF_NOTE_ID => FND_API.G_MISS_NUM,

Line 2304: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling JTF_NOTES_PUB.CREATE_NOTE' );

2300: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);
2301: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);
2302:
2303:
2304: LogMessage(FND_LOG.LEVEL_STATEMENT, 'END calling JTF_NOTES_PUB.CREATE_NOTE' );
2305:
2306: END IF;
2307:
2308: resultout := 'COMPLETE:' || 'Y';

Line 3249: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

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;
3252: l_MSG_DATA VARCHAR2(32767);
3253: l_MSG_COUNT NUMBER;

Line 3352: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method

3348:
3349:
3350: IF (l_loan_approve_note is not null AND length(trim(l_loan_approve_note)) > 0) THEN
3351:
3352: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method
3353: -- to correctly pick the loan against given loan_id
3354: -- MO_GLOBAL.GET_CURRENT_ORG_ID() doesnt work here as it returns null when an external user
3355: -- is trying to approve a loan
3356:

Line 3370: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );

3366: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
3369:
3370: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
3371: JTF_NOTES_PUB.CREATE_NOTE(
3372: P_API_VERSION => 1.0,
3373: P_INIT_MSG_LIST => FND_API.G_TRUE,
3374: P_COMMIT => FND_API.G_TRUE,

Line 3371: JTF_NOTES_PUB.CREATE_NOTE(

3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
3369:
3370: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
3371: JTF_NOTES_PUB.CREATE_NOTE(
3372: P_API_VERSION => 1.0,
3373: P_INIT_MSG_LIST => FND_API.G_TRUE,
3374: P_COMMIT => FND_API.G_TRUE,
3375: P_JTF_NOTE_ID => FND_API.G_MISS_NUM,

Line 3419: LogMessage(FND_LOG.LEVEL_STATEMENT,'End calling JTF_NOTES_PUB.CREATE_NOTE' );

3415: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_note_id : ' || l_note_id);
3416: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);
3417: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);
3418: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);
3419: LogMessage(FND_LOG.LEVEL_STATEMENT,'End calling JTF_NOTES_PUB.CREATE_NOTE' );
3420:
3421:
3422: END IF;
3423: