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 FND_LOG

Line 71: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);

67: IS
68: BEGIN
69: IF (p_msg_level >= G_MSG_LEVEL) then
70:
71: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
72:
73: END IF;
74:
75: EXCEPTION

Line 77: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

73: END IF;
74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
78: END;
79:
80:
81: /*========================================================================

Line 127: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

123: /*-----------------------------------------------------------------------+
124: | Cursor Declarations |
125: +-----------------------------------------------------------------------*/
126: BEGIN
127: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
128: IF p_to_status = 'PENDING' then
129: l_event_name := 'LOAN_APPROVAL_PENDING';
130: ELSIF p_to_status = 'APPROVED' then
131: l_event_name := 'LOAN_APPROVAL_APPROVED';

Line 168: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

164: THEN
165: LNS_REP_UTILS.store_loan_agreement(p_loan_id => p_loan_id);
166: END IF;
167: */
168: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
169: EXCEPTION
170: WHEN OTHERS THEN
171: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
172: || ' -');

Line 171: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

167: */
168: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
169: EXCEPTION
170: WHEN OTHERS THEN
171: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
172: || ' -');
173: RAISE;
174: END PROCESS_LOAN_STATUS_CHANGE;
175: PROCEDURE PROCESS_STATUS_CHANGE( p_loan_id IN NUMBER

Line 192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

188: /*-----------------------------------------------------------------------+
189: | Cursor Declarations |
190: +-----------------------------------------------------------------------*/
191: BEGIN
192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
193: IF p_column_name = 'LOAN_STATUS' then
194: process_loan_status_change(p_loan_id => p_loan_id
195: ,p_from_status => p_from_status
196: ,p_to_status => p_to_status);

Line 204: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

200: ,p_from_status => p_from_status
201: ,p_to_status => p_to_status);
202: ELSE null;
203: END IF;
204: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
205: EXCEPTION
206: WHEN OTHERS THEN
207: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
208: || ' -');

Line 207: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

203: END IF;
204: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
205: EXCEPTION
206: WHEN OTHERS THEN
207: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
208: || ' -');
209: RAISE;
210: END PROCESS_STATUS_CHANGE;
211: PROCEDURE PROCESS_SEC_STATUS_CHANGE( p_loan_id IN NUMBER

Line 235: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

231: FROM lns_loan_headers_all
232: WHERE loan_id = p_loan_id;
233:
234: BEGIN
235: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
236: OPEN csr_loan_details;
237: FETCH csr_loan_details
238: INTO l_open_to_term_flag
239: ,l_open_to_term_event;

Line 281: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

277: raise_event(p_event_name => l_event_name
278: ,p_loan_id => p_loan_id
279: ,p_from_status=> p_from_status);
280: END IF;
281: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
282: EXCEPTION
283: WHEN OTHERS THEN
284: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
285: || ' -');

Line 284: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

280: END IF;
281: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
282: EXCEPTION
283: WHEN OTHERS THEN
284: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
285: || ' -');
286: RAISE;
287: END PROCESS_SEC_STATUS_CHANGE;
288: /*========================================================================

Line 370: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

366: AND le.event_name = p_event_name
367: AND lt.loan_type_id = lh.loan_type_id
368: AND lh.loan_id = p_loan_id;
369: BEGIN
370: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
371:
372: ItemType := 'LNSWF';
373:
374: SELECT lns_workflow_itemkey_s.nextval

Line 443: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

439: p_parameterlist => l_list);
440: wf_event.raise (p_event_name => l_wf_event_name,
441: p_event_key => itemkey,
442: p_parameters => l_list);
443: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
444: EXCEPTION
445: WHEN OTHERS
446: THEN
447: WF_CORE.CONTEXT('LNSWF',l_wf_event_name, itemkey);

Line 500: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +'); IF (funcmode <> wf_engine.eng_run) THEN

496: /*-----------------------------------------------------------------------+
497: | Cursor Declarations |
498: +-----------------------------------------------------------------------*/
499: BEGIN
500: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +'); IF (funcmode <> wf_engine.eng_run) THEN
501:
502: resultout := wf_engine.eng_null;
503: return;
504: END IF;

Line 520: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

516: ,P_LOAN_ID => l_loan_id
517: ,P_WF_ITEMKEY => itemkey
518: ,P_WF_ITEMTYPE => itemtype
519: ,P_ACTIVITY_DATE => sysdate);
520: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
521: EXCEPTION
522: WHEN OTHERS THEN
523: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
524: || ' -');

Line 523: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

519: ,P_ACTIVITY_DATE => sysdate);
520: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
521: EXCEPTION
522: WHEN OTHERS THEN
523: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
524: || ' -');
525: wf_core.context('LNSWF', 'LOG_EVENT_HISTORY', itemtype, itemkey,
526: to_char(actid), funcmode); RAISE;
527: END LOG_EVENT_HISTORY;

Line 789: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

785: WHERE llh.loan_id = p_loan_id
786: AND ps.loan_id = llh.loan_id;
787:
788: BEGIN
789: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
790: OPEN csr_notification_details;
791: FETCH csr_notification_details
792: INTO l_primary_recipient_type
793: , l_primary_recipient_name

Line 963: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

959: itemkey => itemkey,
960: aname => 'LNS_LOAN_PURPOSE',
961: avalue => l_loan_purpose);
962: return 'Y';
963: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
964: EXCEPTION
965: WHEN OTHERS THEN
966: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
967: || ' -');

Line 966: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

962: return 'Y';
963: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
964: EXCEPTION
965: WHEN OTHERS THEN
966: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
967: || ' -');
968: RAISE;
969: END CREATE_NOTIFICATION_DETAILS;
970: /*========================================================================

Line 1023: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +'); IF (funcmode <> wf_engine.eng_run) THEN

1019: /*-----------------------------------------------------------------------+
1020: | Cursor Declarations |
1021: +-----------------------------------------------------------------------*/
1022: BEGIN
1023: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +'); IF (funcmode <> wf_engine.eng_run) THEN
1024:
1025: resultout := wf_engine.eng_null;
1026: return;
1027: END IF;

Line 1061: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

1057: ,p_loan_type => l_loan_type
1058: ,p_loan_type_id => l_loan_type_id
1059: ,p_current_user_id => l_current_user_id
1060: );
1061: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1065: || ' -');

Line 1064: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

1060: );
1061: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1065: || ' -');
1066: wf_core.context('LNSWF', 'PROCESS_EVENT', itemtype, itemkey,
1067: to_char(actid), funcmode); RAISE;
1068: END PROCESS_EVENT;

Line 1098: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1094:
1095: l_api_name CONSTANT VARCHAR2(30) := 'SYNCH_EVENT_ACTIONS';
1096: l_api_version CONSTANT NUMBER := 1.0;
1097: BEGIN
1098: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1099: insert into lns_event_actions (
1100: EVENT_ACTION_ID
1101: , EVENT_ID
1102: , EVENT_ACTION_NAME

Line 1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1156: where ev.loan_class_code = missingvalues.loan_class_code
1157: and ea.event_id = ev.event_id
1158: and ea.loan_type = decode(ev.loan_class_code,'ERS','ERS','BUSINESS')
1159: and ea.event_action_name = 'NOTIFICATION';
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in synch event actions: ' || sqlerrm);
1164: /* This error message needs to be seeded in the future */

Line 1163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in synch event actions: ' || sqlerrm);

1159: and ea.event_action_name = 'NOTIFICATION';
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in synch event actions: ' || sqlerrm);
1164: /* This error message needs to be seeded in the future */
1165: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERROR_SYNCH_EVTS');
1166: FND_MSG_PUB.ADD;
1167: raise;

Line 1171: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1167: raise;
1168: END;
1169: BEGIN
1170: G_LOG_ENABLED := 'N';
1171: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1172:
1173: /* getting msg logging info */
1174: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1175: IF (G_LOG_ENABLED = 'N') then

Line 1176: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

1172:
1173: /* getting msg logging info */
1174: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1175: IF (G_LOG_ENABLED = 'N') then
1176: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1177: ELSE
1178: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1179: END IF;
1180: END LNS_WORK_FLOW;

Line 1178: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

1174: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1175: IF (G_LOG_ENABLED = 'N') then
1176: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
1177: ELSE
1178: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1179: END IF;
1180: END LNS_WORK_FLOW;