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 WF_ENGINE

Line 233: l_user_id := wf_engine.GetItemAttrNumber

229: if l_user_id is null or l_user_id = -1 then
230:
231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '3. Trying to get user id from LNS_CURRENT_USER_ID attribute...');
232: -- trying to get user id form LNS_CURRENT_USER_ID attribute
233: l_user_id := wf_engine.GetItemAttrNumber
234: ( itemtype => p_itemtype,
235: itemkey => p_itemkey,
236: aname => 'LNS_CURRENT_USER_ID');
237: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'From LNS_CURRENT_USER_ID = ' || l_user_id);

Line 789: IF (funcmode <> wf_engine.eng_run) THEN

785: +-----------------------------------------------------------------------*/
786: BEGIN
787: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
788:
789: IF (funcmode <> wf_engine.eng_run) THEN
790: resultout := wf_engine.eng_null;
791: return;
792: END IF;
793: l_loan_id := wf_engine.GetItemAttrNumber

Line 790: resultout := wf_engine.eng_null;

786: BEGIN
787: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
788:
789: IF (funcmode <> wf_engine.eng_run) THEN
790: resultout := wf_engine.eng_null;
791: return;
792: END IF;
793: l_loan_id := wf_engine.GetItemAttrNumber
794: ( itemtype => itemtype,

Line 793: l_loan_id := wf_engine.GetItemAttrNumber

789: IF (funcmode <> wf_engine.eng_run) THEN
790: resultout := wf_engine.eng_null;
791: return;
792: END IF;
793: l_loan_id := wf_engine.GetItemAttrNumber
794: ( itemtype => itemtype,
795: itemkey => itemkey,
796: aname => 'LNS_LOAN_ID');
797: l_event_action_id := wf_engine.GetItemAttrNumber

Line 797: l_event_action_id := wf_engine.GetItemAttrNumber

793: l_loan_id := wf_engine.GetItemAttrNumber
794: ( itemtype => itemtype,
795: itemkey => itemkey,
796: aname => 'LNS_LOAN_ID');
797: l_event_action_id := wf_engine.GetItemAttrNumber
798: ( itemtype => itemtype,
799: itemkey => itemkey,
800: aname => 'LNS_EVENT_ACTION_ID');
801: LNS_EVT_ACTION_HISTORY_H_PKG.Insert_Row (

Line 1203: l_loan_number := wf_engine.GetItemAttrText

1199: CLOSE get_agent_approval_comment;
1200:
1201: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_approval_agent_note = ' || l_loan_approval_agent_note);
1202:
1203: l_loan_number := wf_engine.GetItemAttrText
1204: ( itemtype => itemtype,
1205: itemkey => itemkey,
1206: aname => 'LNS_LOAN_NUMBER');
1207: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_number from GetItemAttrText = ' || l_current_user);

Line 1261: wf_engine.SetItemAttrText (itemtype => itemtype,

1257: );
1258: wf_directory.AddUsersToAdhocRole(role_name => l_role_name,
1259: role_users => l_user_roles);
1260:
1261: wf_engine.SetItemAttrText (itemtype => itemtype,
1262: itemkey => itemkey,
1263: aname => 'LNS_PRIMARY_ROLE',
1264: avalue => l_role_name);
1265: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Set LNS_PRIMARY_ROLE = '||l_role_name);

Line 1276: wf_engine.SetItemAttrText (itemtype => itemtype,

1272: -- Bug#8709307 - Instead of creating Adhoc Role, directly sending notification
1273: -- to the user (FND_USER)
1274: l_role_name := l_loan_assigned_user;
1275:
1276: wf_engine.SetItemAttrText (itemtype => itemtype,
1277: itemkey => itemkey,
1278: aname => 'LNS_PRIMARY_ROLE',
1279: avalue => l_role_name);
1280: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Set LNS_PRIMARY_ROLE = '||l_role_name);

Line 1287: wf_engine.SetItemAttrText (itemtype => itemtype,

1283:
1284: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'At last, l_user_roles is '||l_user_roles);
1285: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'At last, l_role_name is '||l_role_name);
1286:
1287: wf_engine.SetItemAttrText (itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'LNS_BORROWER_NAME',
1290: avalue => l_borrower_name);
1291:

Line 1292: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1288: itemkey => itemkey,
1289: aname => 'LNS_BORROWER_NAME',
1290: avalue => l_borrower_name);
1291:
1292: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'LNS_PRIORITY',
1295: avalue => l_priority_num);
1296: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 1296: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1292: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'LNS_PRIORITY',
1295: avalue => l_priority_num);
1296: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'LNS_EVENT_ACTION_ID',
1299: avalue => l_event_action_id);
1300: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 1300: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1296: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'LNS_EVENT_ACTION_ID',
1299: avalue => l_event_action_id);
1300: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1301: itemkey => itemkey,
1302: aname => 'LNS_TIMEOUT',
1303: avalue => l_active_for_num);
1304: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1304: wf_engine.SetItemAttrText (itemtype => itemtype,

1300: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1301: itemkey => itemkey,
1302: aname => 'LNS_TIMEOUT',
1303: avalue => l_active_for_num);
1304: wf_engine.SetItemAttrText (itemtype => itemtype,
1305: itemkey => itemkey,
1306: aname => 'LNS_LOAN_ASSIGNED_USER',
1307: avalue => l_loan_assigned_user);
1308: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1308: wf_engine.SetItemAttrText (itemtype => itemtype,

1304: wf_engine.SetItemAttrText (itemtype => itemtype,
1305: itemkey => itemkey,
1306: aname => 'LNS_LOAN_ASSIGNED_USER',
1307: avalue => l_loan_assigned_user);
1308: wf_engine.SetItemAttrText (itemtype => itemtype,
1309: itemkey => itemkey,
1310: aname => 'LNS_LOAN_ASSIGNED_NAME',
1311: avalue => l_loan_assigned_name);
1312: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1312: wf_engine.SetItemAttrText (itemtype => itemtype,

1308: wf_engine.SetItemAttrText (itemtype => itemtype,
1309: itemkey => itemkey,
1310: aname => 'LNS_LOAN_ASSIGNED_NAME',
1311: avalue => l_loan_assigned_name);
1312: wf_engine.SetItemAttrText (itemtype => itemtype,
1313: itemkey => itemkey,
1314: aname => 'LNS_CURRENT_USER',
1315: avalue => l_current_user);
1316: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1316: wf_engine.SetItemAttrText (itemtype => itemtype,

1312: wf_engine.SetItemAttrText (itemtype => itemtype,
1313: itemkey => itemkey,
1314: aname => 'LNS_CURRENT_USER',
1315: avalue => l_current_user);
1316: wf_engine.SetItemAttrText (itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => 'LNS_LOAN_CLASS',
1319: avalue => l_loan_class);
1320: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1320: wf_engine.SetItemAttrText (itemtype => itemtype,

1316: wf_engine.SetItemAttrText (itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => 'LNS_LOAN_CLASS',
1319: avalue => l_loan_class);
1320: wf_engine.SetItemAttrText (itemtype => itemtype,
1321: itemkey => itemkey,
1322: aname => 'LNS_LOAN_TYPE',
1323: avalue => l_loan_type);
1324: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1324: wf_engine.SetItemAttrText (itemtype => itemtype,

1320: wf_engine.SetItemAttrText (itemtype => itemtype,
1321: itemkey => itemkey,
1322: aname => 'LNS_LOAN_TYPE',
1323: avalue => l_loan_type);
1324: wf_engine.SetItemAttrText (itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => 'LNS_LOAN_SUBTYPE',
1327: avalue => l_loan_subtype);
1328: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1328: wf_engine.SetItemAttrText (itemtype => itemtype,

1324: wf_engine.SetItemAttrText (itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => 'LNS_LOAN_SUBTYPE',
1327: avalue => l_loan_subtype);
1328: wf_engine.SetItemAttrText (itemtype => itemtype,
1329: itemkey => itemkey,
1330: aname => 'LNS_COLLATERAL_PERCENT',
1331: avalue => l_collateral_percent);
1332: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 1332: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1328: wf_engine.SetItemAttrText (itemtype => itemtype,
1329: itemkey => itemkey,
1330: aname => 'LNS_COLLATERAL_PERCENT',
1331: avalue => l_collateral_percent);
1332: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1333: itemkey => itemkey,
1334: aname => 'LNS_LOAN_AMOUNT',
1335: avalue => l_loan_amount);
1336: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1336: wf_engine.SetItemAttrText (itemtype => itemtype,

1332: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1333: itemkey => itemkey,
1334: aname => 'LNS_LOAN_AMOUNT',
1335: avalue => l_loan_amount);
1336: wf_engine.SetItemAttrText (itemtype => itemtype,
1337: itemkey => itemkey,
1338: aname => 'LNS_FORMATTED_AMOUNT',
1339: avalue => l_loan_formatted_amount);
1340: wf_engine.SetItemAttrDate (itemtype => itemtype,

Line 1340: wf_engine.SetItemAttrDate (itemtype => itemtype,

1336: wf_engine.SetItemAttrText (itemtype => itemtype,
1337: itemkey => itemkey,
1338: aname => 'LNS_FORMATTED_AMOUNT',
1339: avalue => l_loan_formatted_amount);
1340: wf_engine.SetItemAttrDate (itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'LNS_LOAN_START_DATE',
1343: avalue => l_loan_start_date);
1344: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1344: wf_engine.SetItemAttrText (itemtype => itemtype,

1340: wf_engine.SetItemAttrDate (itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'LNS_LOAN_START_DATE',
1343: avalue => l_loan_start_date);
1344: wf_engine.SetItemAttrText (itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => 'LNS_TERM',
1347: avalue => l_term);
1348: wf_engine.SetItemAttrDate (itemtype => itemtype,

Line 1348: wf_engine.SetItemAttrDate (itemtype => itemtype,

1344: wf_engine.SetItemAttrText (itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => 'LNS_TERM',
1347: avalue => l_term);
1348: wf_engine.SetItemAttrDate (itemtype => itemtype,
1349: itemkey => itemkey,
1350: aname => 'LNS_LOAN_MATURITY_DATE',
1351: avalue => l_loan_maturity_date);
1352: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 1352: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1348: wf_engine.SetItemAttrDate (itemtype => itemtype,
1349: itemkey => itemkey,
1350: aname => 'LNS_LOAN_MATURITY_DATE',
1351: avalue => l_loan_maturity_date);
1352: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1353: itemkey => itemkey,
1354: aname => 'LNS_INTEREST_RATE',
1355: avalue => l_interest_rate);
1356: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1356: wf_engine.SetItemAttrText(itemtype => itemtype,

1352: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1353: itemkey => itemkey,
1354: aname => 'LNS_INTEREST_RATE',
1355: avalue => l_interest_rate);
1356: wf_engine.SetItemAttrText(itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'LNS_OVERDUE_AMOUNT',
1359: avalue => l_overdue_amount);
1360: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 1360: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1356: wf_engine.SetItemAttrText(itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'LNS_OVERDUE_AMOUNT',
1359: avalue => l_overdue_amount);
1360: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'LNS_OVERDUE_NUM',
1363: avalue => l_overdue_num);
1364: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1364: wf_engine.SetItemAttrText(itemtype => itemtype,

1360: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'LNS_OVERDUE_NUM',
1363: avalue => l_overdue_num);
1364: wf_engine.SetItemAttrText(itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => 'LNS_LOAN_PURPOSE',
1367: avalue => l_loan_purpose);
1368: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1368: wf_engine.SetItemAttrText(itemtype => itemtype,

1364: wf_engine.SetItemAttrText(itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => 'LNS_LOAN_PURPOSE',
1367: avalue => l_loan_purpose);
1368: wf_engine.SetItemAttrText(itemtype => itemtype,
1369: itemkey => itemkey,
1370: aname => 'LNS_LOAN_PRODUCT_NAME',
1371: avalue => l_product_name);
1372:

Line 1374: wf_engine.SetItemAttrText(itemtype => itemtype,

1370: aname => 'LNS_LOAN_PRODUCT_NAME',
1371: avalue => l_product_name);
1372:
1373: --l_loan_approval_agent_note := 'Test Initial Loan Agent Request Approval Note';
1374: wf_engine.SetItemAttrText(itemtype => itemtype,
1375: itemkey => itemkey,
1376: aname => 'LNS_LOAN_APPROVAL_AGENT_NOTE',
1377: avalue => l_loan_approval_agent_note);
1378: return 'Y';

Line 1467: IF (funcmode <> wf_engine.eng_run) THEN

1463: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1464:
1465: SET_SESSION_CONTEXT(itemtype, itemkey);
1466:
1467: IF (funcmode <> wf_engine.eng_run) THEN
1468: resultout := wf_engine.eng_null;
1469: return;
1470: END IF;
1471:

Line 1468: resultout := wf_engine.eng_null;

1464:
1465: SET_SESSION_CONTEXT(itemtype, itemkey);
1466:
1467: IF (funcmode <> wf_engine.eng_run) THEN
1468: resultout := wf_engine.eng_null;
1469: return;
1470: END IF;
1471:
1472: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting attributes:');

Line 1474: l_loan_id := wf_engine.GetItemAttrNumber

1470: END IF;
1471:
1472: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting attributes:');
1473:
1474: l_loan_id := wf_engine.GetItemAttrNumber
1475: ( itemtype => itemtype,
1476: itemkey => itemkey,
1477: aname => 'LNS_LOAN_ID');
1478:

Line 1479: l_loan_number := wf_engine.GetItemAttrText

1475: ( itemtype => itemtype,
1476: itemkey => itemkey,
1477: aname => 'LNS_LOAN_ID');
1478:
1479: l_loan_number := wf_engine.GetItemAttrText
1480: ( itemtype => itemtype,
1481: itemkey => itemkey,
1482: aname => 'LNS_LOAN_NUMBER');
1483:

Line 1484: l_loan_class_code := wf_engine.GetItemAttrText

1480: ( itemtype => itemtype,
1481: itemkey => itemkey,
1482: aname => 'LNS_LOAN_NUMBER');
1483:
1484: l_loan_class_code := wf_engine.GetItemAttrText
1485: ( itemtype => itemtype,
1486: itemkey => itemkey,
1487: aname => 'LNS_LOAN_CLASS_CODE');
1488: l_loan_type := wf_engine.GetItemAttrText

Line 1488: l_loan_type := wf_engine.GetItemAttrText

1484: l_loan_class_code := wf_engine.GetItemAttrText
1485: ( itemtype => itemtype,
1486: itemkey => itemkey,
1487: aname => 'LNS_LOAN_CLASS_CODE');
1488: l_loan_type := wf_engine.GetItemAttrText
1489: ( itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'LNS_LOAN_TYPE');
1492: l_loan_type_id := wf_engine.GetItemAttrNumber

Line 1492: l_loan_type_id := wf_engine.GetItemAttrNumber

1488: l_loan_type := wf_engine.GetItemAttrText
1489: ( itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'LNS_LOAN_TYPE');
1492: l_loan_type_id := wf_engine.GetItemAttrNumber
1493: ( itemtype => itemtype,
1494: itemkey => itemkey,
1495: aname => 'LNS_LOAN_TYPE_ID');
1496: l_current_user_id := wf_engine.GetItemAttrNumber

Line 1496: l_current_user_id := wf_engine.GetItemAttrNumber

1492: l_loan_type_id := wf_engine.GetItemAttrNumber
1493: ( itemtype => itemtype,
1494: itemkey => itemkey,
1495: aname => 'LNS_LOAN_TYPE_ID');
1496: l_current_user_id := wf_engine.GetItemAttrNumber
1497: ( itemtype => itemtype,
1498: itemkey => itemkey,
1499: aname => 'LNS_CURRENT_USER_ID');
1500: l_event_name := wf_engine.GetItemAttrText

Line 1500: l_event_name := wf_engine.GetItemAttrText

1496: l_current_user_id := wf_engine.GetItemAttrNumber
1497: ( itemtype => itemtype,
1498: itemkey => itemkey,
1499: aname => 'LNS_CURRENT_USER_ID');
1500: l_event_name := wf_engine.GetItemAttrText
1501: ( itemtype => itemtype,
1502: itemkey => itemkey,
1503: aname => 'LNS_EVENT_NAME');
1504:

Line 1644: IF (funcmode <> wf_engine.eng_run) THEN

1640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1641:
1642: SET_SESSION_CONTEXT(itemtype, itemkey);
1643:
1644: IF (funcmode <> wf_engine.eng_run) THEN
1645: resultout := 'COMPLETE:' || 'N';
1646: return;
1647: END IF;
1648:

Line 1649: l_loan_id := wf_engine.GetItemAttrNumber

1645: resultout := 'COMPLETE:' || 'N';
1646: return;
1647: END IF;
1648:
1649: l_loan_id := wf_engine.GetItemAttrNumber
1650: ( itemtype => itemtype,
1651: itemkey => itemkey,
1652: aname => 'LNS_LOAN_ID');
1653:

Line 1664: l_loan_approve_note := wf_engine.GetItemAttrText

1660: END IF;
1661:
1662: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_id : ' || l_loan_id);
1663:
1664: l_loan_approve_note := wf_engine.GetItemAttrText
1665: ( itemtype => itemtype,
1666: itemkey => itemkey,
1667: aname => 'WF_NOTE');
1668:

Line 1673: /* wf_engine.SetItemAttrText (itemtype => itemtype,

1669: G_LAST_ENTERED_NOTE := l_loan_approve_note;
1670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_APPROVAL setting G_LAST_ENTERED_NOTE : ' || G_LAST_ENTERED_NOTE);
1671:
1672:
1673: /* wf_engine.SetItemAttrText (itemtype => itemtype,
1674: itemkey => itemkey,
1675: aname => 'LNS_LAST_ENTERED_NOTE',
1676: avalue => l_loan_approve_note);
1677: */

Line 1886: IF (funcmode <> wf_engine.eng_run) THEN

1882: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1883:
1884: SET_SESSION_CONTEXT(itemtype, itemkey);
1885:
1886: IF (funcmode <> wf_engine.eng_run) THEN
1887: resultout := 'COMPLETE:' || 'N';
1888: return;
1889: END IF;
1890:

Line 1891: l_loan_id := wf_engine.GetItemAttrNumber

1887: resultout := 'COMPLETE:' || 'N';
1888: return;
1889: END IF;
1890:
1891: l_loan_id := wf_engine.GetItemAttrNumber
1892: ( itemtype => itemtype,
1893: itemkey => itemkey,
1894: aname => 'LNS_LOAN_ID');
1895:

Line 1907: l_loan_reject_note := wf_engine.GetItemAttrText

1903: from lns_loan_headers_all loan
1904: where loan.loan_id = l_loan_id;
1905: END IF;
1906:
1907: l_loan_reject_note := wf_engine.GetItemAttrText
1908: ( itemtype => itemtype,
1909: itemkey => itemkey,
1910: aname => 'WF_NOTE');
1911:

Line 1915: /* wf_engine.SetItemAttrText (itemtype => itemtype,

1911:
1912: G_LAST_ENTERED_NOTE := l_loan_reject_note;
1913: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_REJECTION setting G_LAST_ENTERED_NOTE : ' || G_LAST_ENTERED_NOTE);
1914: --GK Test. Remove this later
1915: /* wf_engine.SetItemAttrText (itemtype => itemtype,
1916: itemkey => itemkey,
1917: aname => 'LNS_LAST_ENTERED_NOTE',
1918: avalue => l_loan_reject_note);
1919: */

Line 2127: IF (funcmode <> wf_engine.eng_run) THEN

2123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
2124:
2125: SET_SESSION_CONTEXT(itemtype, itemkey);
2126:
2127: IF (funcmode <> wf_engine.eng_run) THEN
2128: resultout := 'COMPLETE:' || 'N';
2129: return;
2130: END IF;
2131:

Line 2132: l_loan_id := wf_engine.GetItemAttrNumber

2128: resultout := 'COMPLETE:' || 'N';
2129: return;
2130: END IF;
2131:
2132: l_loan_id := wf_engine.GetItemAttrNumber
2133: ( itemtype => itemtype,
2134: itemkey => itemkey,
2135: aname => 'LNS_LOAN_ID');
2136: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_loan_id from GetItemAttrNumber = ' || l_loan_id);

Line 2146: l_req_loan_info_note := wf_engine.GetItemAttrText

2142: from lns_loan_headers_all loan
2143: where loan.loan_id = l_loan_id;
2144: END IF;
2145:
2146: l_req_loan_info_note := wf_engine.GetItemAttrText
2147: ( itemtype => itemtype,
2148: itemkey => itemkey,
2149: aname => 'WF_NOTE');
2150:

Line 2208: l_approver_user_name := wf_engine.GetItemAttrText ( itemtype => itemtype,

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
2207: --null in AME Engine so that next time AME tries to get the Approver the same Approver is picked up.
2208: l_approver_user_name := wf_engine.GetItemAttrText ( itemtype => itemtype,
2209: itemkey => itemkey,
2210: aname => 'LNS_PRIMARY_ROLE');
2211: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Approver User Name : ' || l_approver_user_name);
2212:

Line 2356: IF (funcmode <> wf_engine.eng_run) THEN

2352: l_loan_approval_from_ntf fnd_profile_option_values.profile_option_value%TYPE;
2353: BEGIN
2354: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.APPROVE_LOAN_FROM_NTF' || ' +');
2355:
2356: IF (funcmode <> wf_engine.eng_run) THEN
2357: resultout := wf_engine.eng_null;
2358: return;
2359: END IF;
2360:

Line 2357: resultout := wf_engine.eng_null;

2353: BEGIN
2354: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.APPROVE_LOAN_FROM_NTF' || ' +');
2355:
2356: IF (funcmode <> wf_engine.eng_run) THEN
2357: resultout := wf_engine.eng_null;
2358: return;
2359: END IF;
2360:
2361: l_loan_approval_from_ntf := FND_PROFILE.value('LNS_APPROVE_LOAN_FROM_NTF');

Line 2562: l_loan_id := wf_engine.GetItemAttrNumber

2558: l_api_name CONSTANT VARCHAR2(30) := 'FindNextApprover';
2559:
2560: BEGIN
2561: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2562: l_loan_id := wf_engine.GetItemAttrNumber
2563: ( itemtype => p_item_type,
2564: itemkey => p_item_key,
2565: aname => 'LNS_LOAN_ID');
2566: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);

Line 2665: wf_engine.SetItemAttrText(

2661:
2662:
2663:
2664: IF (l_approver_user_name IS NOT NULL) THEN
2665: wf_engine.SetItemAttrText(
2666: itemtype => p_item_type,
2667: itemkey => p_item_key,
2668: aname => 'LNS_PRIMARY_ROLE',
2669: avalue => l_approver_user_name);

Line 2680: wf_engine.SetItemAttrText(

2676:
2677:
2678: IF l_approver_user_name IS NULL THEN
2679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || 'IS NULL');
2680: wf_engine.SetItemAttrText(
2681: itemtype => p_item_type,
2682: itemkey => p_item_key,
2683: aname => 'LNS_PRIMARY_ROLE',
2684: avalue => null);

Line 2756: l_approver_user_name := wf_engine.GetItemAttrText

2752: BEGIN
2753:
2754: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2755: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || p_funcmode);
2756: l_approver_user_name := wf_engine.GetItemAttrText
2757: ( itemtype => p_item_type,
2758: itemkey => p_item_key,
2759: aname => 'LNS_PRIMARY_ROLE');
2760:

Line 2763: wf_engine.SetItemAttrText (itemtype => p_item_type,

2759: aname => 'LNS_PRIMARY_ROLE');
2760:
2761: --Need to set l_approver_user_name into the LNS_INTERMEDIATE_APPROVER attribute
2762: -- for correctly having From value in the intermediate Approval Notification being send to loan agent
2763: wf_engine.SetItemAttrText (itemtype => p_item_type,
2764: itemkey => p_item_key,
2765: aname => 'LNS_INTERMEDIATE_APPROVER',
2766: avalue => l_approver_user_name);
2767:

Line 2769: l_loan_id := wf_engine.GetItemAttrNumber

2765: aname => 'LNS_INTERMEDIATE_APPROVER',
2766: avalue => l_approver_user_name);
2767:
2768: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Approver User Name : ' || l_approver_user_name);
2769: l_loan_id := wf_engine.GetItemAttrNumber
2770: ( itemtype => p_item_type,
2771: itemkey => p_item_key,
2772: aname => 'LNS_LOAN_ID');
2773:

Line 2775: l_loan_approve_note := wf_engine.GetItemAttrText

2771: itemkey => p_item_key,
2772: aname => 'LNS_LOAN_ID');
2773:
2774: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);
2775: l_loan_approve_note := wf_engine.GetItemAttrText
2776: ( itemtype => p_item_type,
2777: itemkey => p_item_key,
2778: aname => 'WF_NOTE');
2779:

Line 2780: wf_engine.SetItemAttrText (itemtype => p_item_type,

2776: ( itemtype => p_item_type,
2777: itemkey => p_item_key,
2778: aname => 'WF_NOTE');
2779:
2780: wf_engine.SetItemAttrText (itemtype => p_item_type,
2781: itemkey => p_item_key,
2782: aname => 'LNS_LAST_ENTERED_NOTE',
2783: avalue => l_loan_approve_note);
2784:

Line 2862: l_approver_user_name := wf_engine.GetItemAttrText

2858:
2859: BEGIN
2860:
2861: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2862: l_approver_user_name := wf_engine.GetItemAttrText
2863: ( itemtype => p_item_type,
2864: itemkey => p_item_key,
2865: aname => 'LNS_PRIMARY_ROLE');
2866:

Line 2869: l_loan_id := wf_engine.GetItemAttrNumber

2865: aname => 'LNS_PRIMARY_ROLE');
2866:
2867: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || l_approver_user_name);
2868:
2869: l_loan_id := wf_engine.GetItemAttrNumber
2870: ( itemtype => p_item_type,
2871: itemkey => p_item_key,
2872: aname => 'LNS_LOAN_ID');
2873: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);

Line 2946: IF (funcmode <> wf_engine.eng_run) THEN

2942: l_api_name CONSTANT VARCHAR2(30) := 'APPROVE_LOAN_USING_AME';
2943: BEGIN
2944: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2945:
2946: IF (funcmode <> wf_engine.eng_run) THEN
2947: resultout := wf_engine.eng_null;
2948: return;
2949: END IF;
2950:

Line 2947: resultout := wf_engine.eng_null;

2943: BEGIN
2944: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2945:
2946: IF (funcmode <> wf_engine.eng_run) THEN
2947: resultout := wf_engine.eng_null;
2948: return;
2949: END IF;
2950:
2951: l_loan_approval_using_ame := FND_PROFILE.value('AME:Installed');

Line 3037: /* l_approver_user_name := wf_engine.GetItemAttrNumber

3033: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || funcmode);
3035: resultout := 'COMPLETE:Y';
3036:
3037: /* l_approver_user_name := wf_engine.GetItemAttrNumber
3038: ( itemtype => itemtype,
3039: itemkey => itemkey,
3040: aname => 'LNS_PRIMARY_ROLE');
3041:

Line 3149: l_nRespId := WF_ENGINE.GetItemAttrNumber(p_item_type,

3145: BEGIN
3146: ------------------------------------------------------------
3147: l_debug_info := 'Get responsibility id';
3148: ------------------------------------------------------------
3149: l_nRespId := WF_ENGINE.GetItemAttrNumber(p_item_type,
3150: p_item_key,
3151: 'RESPONSIBILITY_ID');
3152: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_nRespId : ' || l_nRespId);
3153: EXCEPTION

Line 3265: IF (funcmode <> wf_engine.eng_run) THEN

3261:
3262: BEGIN
3263: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3264: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || funcmode);
3265: IF (funcmode <> wf_engine.eng_run) THEN
3266: resultout := 'COMPLETE:' || 'N';
3267: return;
3268: END IF;
3269: l_loan_id := wf_engine.GetItemAttrNumber

Line 3269: l_loan_id := wf_engine.GetItemAttrNumber

3265: IF (funcmode <> wf_engine.eng_run) THEN
3266: resultout := 'COMPLETE:' || 'N';
3267: return;
3268: END IF;
3269: l_loan_id := wf_engine.GetItemAttrNumber
3270: ( itemtype => itemtype,
3271: itemkey => itemkey,
3272: aname => 'LNS_LOAN_ID');
3273:

Line 3284: l_loan_approve_note := wf_engine.GetItemAttrText

3280: END IF;
3281:
3282: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_id : ' || l_loan_id);
3283:
3284: l_loan_approve_note := wf_engine.GetItemAttrText
3285: ( itemtype => itemtype,
3286: itemkey => itemkey,
3287: aname => 'WF_NOTE');
3288:

Line 3290: wf_engine.SetItemAttrText (itemtype => itemtype,

3286: itemkey => itemkey,
3287: aname => 'WF_NOTE');
3288:
3289:
3290: wf_engine.SetItemAttrText (itemtype => itemtype,
3291: itemkey => itemkey,
3292: aname => 'LNS_LAST_ENTERED_NOTE',
3293: avalue => l_loan_approve_note);
3294: