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 72: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);

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

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

74: END IF;
75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
79: END;
80:
81:
82: PROCEDURE SET_SESSION_CONTEXT(p_itemtype in varchar2,

Line 163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');

159: BEGIN
160:
161: --fnd_global.apps_initialize(1013429, 62494, 206);
162:
163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
164:
165: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemtype: ' || p_itemtype);
166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);
167:

Line 165: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemtype: ' || p_itemtype);

161: --fnd_global.apps_initialize(1013429, 62494, 206);
162:
163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
164:
165: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemtype: ' || p_itemtype);
166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);
167:
168: -- set user from fnd_global first
169: l_user_id := fnd_global.user_id;

Line 166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);

162:
163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
164:
165: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemtype: ' || p_itemtype);
166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);
167:
168: -- set user from fnd_global first
169: l_user_id := fnd_global.user_id;
170: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '1. Trying to get user id from fnd_global.user_id = ' || l_user_id);

Line 170: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '1. Trying to get user id from fnd_global.user_id = ' || l_user_id);

166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'p_itemkey: ' || p_itemkey);
167:
168: -- set user from fnd_global first
169: l_user_id := fnd_global.user_id;
170: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '1. Trying to get user id from fnd_global.user_id = ' || l_user_id);
171:
172: if l_user_id is null or l_user_id = -1 then
173:
174: OPEN csr_notification(p_itemtype, p_itemkey);

Line 178: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_notification_id: ' || l_notification_id);

174: OPEN csr_notification(p_itemtype, p_itemkey);
175: FETCH csr_notification INTO l_notification_id, l_RESPONDER;
176: CLOSE csr_notification;
177:
178: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_notification_id: ' || l_notification_id);
179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_RESPONDER: ' || l_RESPONDER);
180:
181: if l_RESPONDER is not null then
182:

Line 179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_RESPONDER: ' || l_RESPONDER);

175: FETCH csr_notification INTO l_notification_id, l_RESPONDER;
176: CLOSE csr_notification;
177:
178: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_notification_id: ' || l_notification_id);
179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_RESPONDER: ' || l_RESPONDER);
180:
181: if l_RESPONDER is not null then
182:
183: l_index := instr(l_RESPONDER, '@');

Line 184: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_index: ' || l_index);

180:
181: if l_RESPONDER is not null then
182:
183: l_index := instr(l_RESPONDER, '@');
184: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_index: ' || l_index);
185:
186: if l_index = 0 then
187:
188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '2. Trying to get user id from notification responder name...');

Line 188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '2. Trying to get user id from notification responder name...');

184: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_index: ' || l_index);
185:
186: if l_index = 0 then
187:
188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '2. Trying to get user id from notification responder name...');
189: OPEN csr_user_id(l_RESPONDER);
190: FETCH csr_user_id INTO l_user_id;
191: CLOSE csr_user_id;
192: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_id: ' || l_user_id);

Line 192: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_id: ' || l_user_id);

188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '2. Trying to get user id from notification responder name...');
189: OPEN csr_user_id(l_RESPONDER);
190: FETCH csr_user_id INTO l_user_id;
191: CLOSE csr_user_id;
192: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_id: ' || l_user_id);
193:
194: else
195:
196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '2. Trying to get user id from notification responder email...');

Line 196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '2. Trying to get user id from notification responder email...');

192: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_id: ' || l_user_id);
193:
194: else
195:
196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '2. Trying to get user id from notification responder email...');
197: wf_directory.GETINFOFROMMAIL(MAILID => l_RESPONDER,
198: ROLE => l_ROLE,
199: DISPLAY_NAME => l_DISPLAY_NAME,
200: DESCRIPTION => l_DESCRIPTION,

Line 210: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ROLE = ' || l_ROLE);

206: STATUS => l_STATUS,
207: ORIG_SYSTEM => l_ORIG_SYSTEM,
208: ORIG_SYSTEM_ID => l_ORIG_SYSTEM_ID);
209:
210: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ROLE = ' || l_ROLE);
211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DISPLAY_NAME = ' || l_DISPLAY_NAME);
212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);
213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);

Line 211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DISPLAY_NAME = ' || l_DISPLAY_NAME);

207: ORIG_SYSTEM => l_ORIG_SYSTEM,
208: ORIG_SYSTEM_ID => l_ORIG_SYSTEM_ID);
209:
210: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ROLE = ' || l_ROLE);
211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DISPLAY_NAME = ' || l_DISPLAY_NAME);
212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);
213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);
215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_STATUS = ' || l_STATUS);

Line 212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);

208: ORIG_SYSTEM_ID => l_ORIG_SYSTEM_ID);
209:
210: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ROLE = ' || l_ROLE);
211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DISPLAY_NAME = ' || l_DISPLAY_NAME);
212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);
213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);
215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_STATUS = ' || l_STATUS);
216: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ORIG_SYSTEM = ' || l_ORIG_SYSTEM);

Line 213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);

209:
210: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ROLE = ' || l_ROLE);
211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DISPLAY_NAME = ' || l_DISPLAY_NAME);
212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);
213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);
215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_STATUS = ' || l_STATUS);
216: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ORIG_SYSTEM = ' || l_ORIG_SYSTEM);
217:

Line 214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);

210: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ROLE = ' || l_ROLE);
211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DISPLAY_NAME = ' || l_DISPLAY_NAME);
212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);
213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);
215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_STATUS = ' || l_STATUS);
216: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ORIG_SYSTEM = ' || l_ORIG_SYSTEM);
217:
218: if l_ROLE is not null then

Line 215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_STATUS = ' || l_STATUS);

211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DISPLAY_NAME = ' || l_DISPLAY_NAME);
212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);
213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);
215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_STATUS = ' || l_STATUS);
216: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ORIG_SYSTEM = ' || l_ORIG_SYSTEM);
217:
218: if l_ROLE is not null then
219: OPEN csr_user_id(l_ROLE);

Line 216: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ORIG_SYSTEM = ' || l_ORIG_SYSTEM);

212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_DESCRIPTION = ' || l_DESCRIPTION);
213: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_NOTIFICATION_PREFERENCE = ' || l_NOTIFICATION_PREFERENCE);
214: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_EXPIRATION_DATE = ' || l_EXPIRATION_DATE);
215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_STATUS = ' || l_STATUS);
216: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_ORIG_SYSTEM = ' || l_ORIG_SYSTEM);
217:
218: if l_ROLE is not null then
219: OPEN csr_user_id(l_ROLE);
220: FETCH csr_user_id INTO l_user_id;

Line 222: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_id: ' || l_user_id);

218: if l_ROLE is not null then
219: OPEN csr_user_id(l_ROLE);
220: FETCH csr_user_id INTO l_user_id;
221: CLOSE csr_user_id;
222: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_id: ' || l_user_id);
223: end if;
224:
225: end if;
226:

Line 231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '3. Trying to get user id from LNS_CURRENT_USER_ID attribute...');

227: end if;
228:
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,

Line 237: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'From LNS_CURRENT_USER_ID = ' || l_user_id);

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);
238: end if;
239:
240: end if;
241:

Line 244: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot set session context because cannot find user_id');

240: end if;
241:
242: -- could not find user id
243: if l_user_id is null or l_user_id = -1 then
244: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot set session context because cannot find user_id');
245: return;
246: end if;
247:
248: -- set resp from fnd_global first

Line 250: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '4. Trying to get resp_id from fnd_global.resp_id = ' || l_global_resp_id);

246: end if;
247:
248: -- set resp from fnd_global first
249: l_global_resp_id := fnd_global.resp_id;
250: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '4. Trying to get resp_id from fnd_global.resp_id = ' || l_global_resp_id);
251: OPEN csr_get_resp(l_user_id, l_global_resp_id);
252: FETCH csr_get_resp INTO
253: l_user_name,
254: l_resp_id,

Line 260: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);

256: l_request_group_id,
257: l_request_group_name;
258: CLOSE csr_get_resp;
259:
260: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
262: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
264: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);

Line 261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);

257: l_request_group_name;
258: CLOSE csr_get_resp;
259:
260: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
262: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
264: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
265:

Line 262: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);

258: CLOSE csr_get_resp;
259:
260: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
262: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
264: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
265:
266: if l_resp_id is null or l_resp_id = -1 then

Line 263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);

259:
260: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
262: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
264: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
265:
266: if l_resp_id is null or l_resp_id = -1 then
267: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '5. Trying to get resp_id from sql...');

Line 264: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);

260: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
262: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
264: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
265:
266: if l_resp_id is null or l_resp_id = -1 then
267: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '5. Trying to get resp_id from sql...');
268:

Line 267: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '5. Trying to get resp_id from sql...');

263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
264: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
265:
266: if l_resp_id is null or l_resp_id = -1 then
267: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '5. Trying to get resp_id from sql...');
268:
269: OPEN csr_get_resp(l_user_id, null);
270: FETCH csr_get_resp INTO
271: l_user_name,

Line 278: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);

274: l_request_group_id,
275: l_request_group_name;
276: CLOSE csr_get_resp;
277:
278: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
281: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);

Line 279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);

275: l_request_group_name;
276: CLOSE csr_get_resp;
277:
278: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
281: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
283:

Line 280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);

276: CLOSE csr_get_resp;
277:
278: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
281: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
283:
284: end if;

Line 281: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);

277:
278: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
281: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
283:
284: end if;
285:

Line 282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);

278: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_user_name = ' || l_user_name);
279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_id = ' || l_resp_id);
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_resp_key = ' || l_resp_key);
281: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_id = ' || l_request_group_id);
282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_request_group_name = ' || l_request_group_name);
283:
284: end if;
285:
286: if l_resp_id is null or l_resp_id = -1 then

Line 287: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot set session context because cannot find resp_id');

283:
284: end if;
285:
286: if l_resp_id is null or l_resp_id = -1 then
287: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot set session context because cannot find resp_id');
288: return;
289: end if;
290:
291: if l_user_id is not null and l_user_id > -1 and l_resp_id is not null and l_resp_id > -1 then

Line 292: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting session context with user_id = ' || l_user_id || ' and resp_id = ' || l_resp_id);

288: return;
289: end if;
290:
291: if l_user_id is not null and l_user_id > -1 and l_resp_id is not null and l_resp_id > -1 then
292: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting session context with user_id = ' || l_user_id || ' and resp_id = ' || l_resp_id);
293: fnd_global.apps_initialize(l_user_id, l_resp_id, 206);
294: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Session context is set successfully!');
295: end if;
296:

Line 294: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Session context is set successfully!');

290:
291: if l_user_id is not null and l_user_id > -1 and l_resp_id is not null and l_resp_id > -1 then
292: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting session context with user_id = ' || l_user_id || ' and resp_id = ' || l_resp_id);
293: fnd_global.apps_initialize(l_user_id, l_resp_id, 206);
294: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Session context is set successfully!');
295: end if;
296:
297: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');
298:

Line 297: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');

293: fnd_global.apps_initialize(l_user_id, l_resp_id, 206);
294: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Session context is set successfully!');
295: end if;
296:
297: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');
298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' ERROR: ' || sqlerrm);

Line 301: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' ERROR: ' || sqlerrm);

297: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');
298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' ERROR: ' || sqlerrm);
302: END;
303:
304:
305:

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

348: /*-----------------------------------------------------------------------+
349: | Cursor Declarations |
350: +-----------------------------------------------------------------------*/
351: BEGIN
352: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
353:
354: IF p_to_status = 'PENDING' then
355: l_event_name := 'LOAN_APPROVAL_PENDING';
356: ELSIF p_to_status = 'APPROVED' then

Line 383: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_event_name: ' || l_event_name);

379: ELSIF p_to_status = 'PENDING_CANCELLATION' then
380: l_event_name := 'LOAN_DISB_CANCEL_PENDING';
381: END IF;
382:
383: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_event_name: ' || l_event_name);
384:
385:
386: IF l_event_name is NOT NULL THEN
387: raise_event(p_event_name => l_event_name

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

395: LNS_REP_UTILS.store_loan_agreement(p_loan_id => p_loan_id);
396: END IF;
397: */
398:
399: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
400: EXCEPTION
401: WHEN OTHERS THEN
402: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
403: || ' Exception -');

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

398:
399: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
400: EXCEPTION
401: WHEN OTHERS THEN
402: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
403: || ' Exception -');
404: RAISE;
405: END PROCESS_LOAN_STATUS_CHANGE;
406: PROCEDURE PROCESS_STATUS_CHANGE( p_loan_id IN NUMBER

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

419: /*-----------------------------------------------------------------------+
420: | Cursor Declarations |
421: +-----------------------------------------------------------------------*/
422: BEGIN
423: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
424: IF p_column_name = 'LOAN_STATUS' then
425: process_loan_status_change(p_loan_id => p_loan_id
426: ,p_from_status => p_from_status
427: ,p_to_status => p_to_status);

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

431: ,p_from_status => p_from_status
432: ,p_to_status => p_to_status);
433: ELSE null;
434: END IF;
435: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
436: EXCEPTION
437: WHEN OTHERS THEN
438: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
439: || ' Exception -');

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

434: END IF;
435: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
436: EXCEPTION
437: WHEN OTHERS THEN
438: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
439: || ' Exception -');
440: RAISE;
441: END PROCESS_STATUS_CHANGE;
442: PROCEDURE PROCESS_SEC_STATUS_CHANGE( p_loan_id IN NUMBER

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

462: FROM lns_loan_headers_all
463: WHERE loan_id = p_loan_id;
464:
465: BEGIN
466: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
467: OPEN csr_loan_details;
468: FETCH csr_loan_details
469: INTO l_open_to_term_flag
470: ,l_open_to_term_event;

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

508: raise_event(p_event_name => l_event_name
509: ,p_loan_id => p_loan_id
510: ,p_from_status=> p_from_status);
511: END IF;
512: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
513: EXCEPTION
514: WHEN OTHERS THEN
515: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
516: || ' Exception -');

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

511: END IF;
512: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
513: EXCEPTION
514: WHEN OTHERS THEN
515: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
516: || ' Exception -');
517: RAISE;
518: END PROCESS_SEC_STATUS_CHANGE;
519: /*========================================================================

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

610: )
611: AND notes.language = USERENV('LANG');
612:
613: BEGIN
614: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
615:
616: ItemType := 'LNSWF';
617:
618: SELECT lns_workflow_itemkey_s.nextval

Line 704: LogMessage(FND_LOG.LEVEL_STATEMENT,'Adding parameters:');

700: wf_event.AddParameterToList(p_name => 'LNS_LAST_ENTERED_NOTE',
701: p_value => G_LAST_ENTERED_NOTE,
702: p_parameterlist => l_list);
703:
704: LogMessage(FND_LOG.LEVEL_STATEMENT,'Adding parameters:');
705: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_ID = ' || p_loan_id);
706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);
707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);

Line 705: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_ID = ' || p_loan_id);

701: p_value => G_LAST_ENTERED_NOTE,
702: p_parameterlist => l_list);
703:
704: LogMessage(FND_LOG.LEVEL_STATEMENT,'Adding parameters:');
705: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_ID = ' || p_loan_id);
706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);
707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);

Line 706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);

702: p_parameterlist => l_list);
703:
704: LogMessage(FND_LOG.LEVEL_STATEMENT,'Adding parameters:');
705: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_ID = ' || p_loan_id);
706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);
707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);

Line 707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);

703:
704: LogMessage(FND_LOG.LEVEL_STATEMENT,'Adding parameters:');
705: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_ID = ' || p_loan_id);
706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);
707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);

Line 708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);

704: LogMessage(FND_LOG.LEVEL_STATEMENT,'Adding parameters:');
705: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_ID = ' || p_loan_id);
706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);
707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);

Line 709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);

705: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_ID = ' || p_loan_id);
706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);
707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);

Line 710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);

706: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_NUMBER = ' || l_loan_number);
707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);

Line 711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);

707: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_DESCRIPTION = ' || l_loan_description);
708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);

Line 712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);

708: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_REQUESTED_AMOUNT = ' || l_requested_amount);
709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);

Line 713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);

709: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_FORMATTED_AMOUNT = ' || l_loan_formatted_amount);
710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);
717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);

Line 714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);

710: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_UNDISBURSED_AMOUNT = ' || l_loan_undisbursed_amount);
711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);
717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);
718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);

Line 715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);

711: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_WF_INIT_DATE = ' || l_sysdate);
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);
717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);
718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);
719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);

Line 716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);

712: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_OLD_LOAN_STATUS = ' || p_from_status);
713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);
717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);
718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);
719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
720:

Line 717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);

713: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code);
714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);
717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);
718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);
719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
720:
721: G_LAST_ENTERED_NOTE := '';

Line 718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);

714: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE_ID = ' || l_loan_type_id);
715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);
717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);
718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);
719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
720:
721: G_LAST_ENTERED_NOTE := '';
722: LogMessage(FND_LOG.LEVEL_STATEMENT,'Setting G_LAST_ENTERED_NOTE to NULL');

Line 719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);

715: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_CURRENT_USER_ID = ' || l_current_user_id);
716: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LOAN_TYPE = ' || l_loan_type);
717: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_EVENT_NAME = ' || p_event_name);
718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);
719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
720:
721: G_LAST_ENTERED_NOTE := '';
722: LogMessage(FND_LOG.LEVEL_STATEMENT,'Setting G_LAST_ENTERED_NOTE to NULL');
723: LogMessage(FND_LOG.LEVEL_STATEMENT,'itemkey = ' || itemkey);

Line 722: LogMessage(FND_LOG.LEVEL_STATEMENT,'Setting G_LAST_ENTERED_NOTE to NULL');

718: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_ERS_FUNCTION_NAME = ' || l_function_name);
719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
720:
721: G_LAST_ENTERED_NOTE := '';
722: LogMessage(FND_LOG.LEVEL_STATEMENT,'Setting G_LAST_ENTERED_NOTE to NULL');
723: LogMessage(FND_LOG.LEVEL_STATEMENT,'itemkey = ' || itemkey);
724: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_wf_event_name = ' || l_wf_event_name);
725:
726: wf_event.raise (p_event_name => l_wf_event_name,

Line 723: LogMessage(FND_LOG.LEVEL_STATEMENT,'itemkey = ' || itemkey);

719: LogMessage(FND_LOG.LEVEL_STATEMENT,'LNS_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
720:
721: G_LAST_ENTERED_NOTE := '';
722: LogMessage(FND_LOG.LEVEL_STATEMENT,'Setting G_LAST_ENTERED_NOTE to NULL');
723: LogMessage(FND_LOG.LEVEL_STATEMENT,'itemkey = ' || itemkey);
724: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_wf_event_name = ' || l_wf_event_name);
725:
726: wf_event.raise (p_event_name => l_wf_event_name,
727: p_event_key => itemkey,

Line 724: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_wf_event_name = ' || l_wf_event_name);

720:
721: G_LAST_ENTERED_NOTE := '';
722: LogMessage(FND_LOG.LEVEL_STATEMENT,'Setting G_LAST_ENTERED_NOTE to NULL');
723: LogMessage(FND_LOG.LEVEL_STATEMENT,'itemkey = ' || itemkey);
724: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_wf_event_name = ' || l_wf_event_name);
725:
726: wf_event.raise (p_event_name => l_wf_event_name,
727: p_event_key => itemkey,
728: p_parameters => l_list);

Line 729: LogMessage(FND_LOG.LEVEL_STATEMENT,'Event is raised');

725:
726: wf_event.raise (p_event_name => l_wf_event_name,
727: p_event_key => itemkey,
728: p_parameters => l_list);
729: LogMessage(FND_LOG.LEVEL_STATEMENT,'Event is raised');
730: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
731: EXCEPTION
732: WHEN OTHERS
733: THEN

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

726: wf_event.raise (p_event_name => l_wf_event_name,
727: p_event_key => itemkey,
728: p_parameters => l_list);
729: LogMessage(FND_LOG.LEVEL_STATEMENT,'Event is raised');
730: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
731: EXCEPTION
732: WHEN OTHERS
733: THEN
734: WF_CORE.CONTEXT('LNSWF',l_wf_event_name, itemkey);

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

783: /*-----------------------------------------------------------------------+
784: | Cursor Declarations |
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;

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

804: ,P_LOAN_ID => l_loan_id
805: ,P_WF_ITEMKEY => itemkey
806: ,P_WF_ITEMTYPE => itemtype
807: ,P_ACTIVITY_DATE => sysdate);
808: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
809: EXCEPTION
810: WHEN OTHERS THEN
811: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
812: || ' Exception -');

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

807: ,P_ACTIVITY_DATE => sysdate);
808: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
809: EXCEPTION
810: WHEN OTHERS THEN
811: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
812: || ' Exception -');
813: wf_core.context('LNSWF', 'LOG_EVENT_HISTORY', itemtype, itemkey,
814: to_char(actid), funcmode); RAISE;
815: END LOG_EVENT_HISTORY;

Line 870: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_user_id is '||l_user_id);

866:
867: if (l_user_id is null OR l_org_id is null) then
868: RETURN l_has_org_access;
869: end if;
870: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_user_id is '||l_user_id);
871: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_appl_id is '||l_appl_id);
872: OPEN c_get_user_resps(l_user_id,l_appl_id);
873: <> LOOP
874: FETCH c_get_user_resps

Line 871: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_appl_id is '||l_appl_id);

867: if (l_user_id is null OR l_org_id is null) then
868: RETURN l_has_org_access;
869: end if;
870: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_user_id is '||l_user_id);
871: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_appl_id is '||l_appl_id);
872: OPEN c_get_user_resps(l_user_id,l_appl_id);
873: <> LOOP
874: FETCH c_get_user_resps
875: INTO l_resp_id;

Line 881: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_org_id is '||l_org_id);

877: --initialize the session context with the user and resp info
878: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_appl_id);
879: --begin R12 specific
880: MO_GLOBAL.INIT('LNS');
881: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'In has_user_org_acc, the l_org_id is '||l_org_id);
882: if (mo_global.check_access(l_org_id) = 'Y') then
883: --end R12 specific
884: --begin 11i specific
885: --if (fnd_profile.value('ORG_ID') = to_char(l_org_id)) then

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

1109: AND notes.language = USERENV('LANG');
1110:
1111:
1112: BEGIN
1113: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1114: OPEN csr_notification_details;
1115: FETCH csr_notification_details
1116: INTO l_primary_recipient_type
1117: , l_primary_recipient_name

Line 1123: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification is not found. Returning');

1119: , l_active_for_num
1120: , l_delivery_method
1121: , l_event_action_id;
1122: IF csr_notification_details%NOTFOUND THEN
1123: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification is not found. Returning');
1124: RETURN 'N';
1125: END IF;
1126:
1127: CLOSE csr_notification_details;

Line 1129: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification details:');

1125: END IF;
1126:
1127: CLOSE csr_notification_details;
1128:
1129: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification details:');
1130: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_type = ' || l_primary_recipient_type);
1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);
1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);
1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);

Line 1130: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_type = ' || l_primary_recipient_type);

1126:
1127: CLOSE csr_notification_details;
1128:
1129: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification details:');
1130: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_type = ' || l_primary_recipient_type);
1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);
1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);
1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);
1134: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_delivery_method = ' || l_delivery_method);

Line 1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);

1127: CLOSE csr_notification_details;
1128:
1129: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification details:');
1130: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_type = ' || l_primary_recipient_type);
1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);
1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);
1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);
1134: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_delivery_method = ' || l_delivery_method);
1135: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_event_action_id = ' || l_event_action_id);

Line 1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);

1128:
1129: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification details:');
1130: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_type = ' || l_primary_recipient_type);
1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);
1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);
1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);
1134: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_delivery_method = ' || l_delivery_method);
1135: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_event_action_id = ' || l_event_action_id);
1136:

Line 1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);

1129: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Notification details:');
1130: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_type = ' || l_primary_recipient_type);
1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);
1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);
1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);
1134: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_delivery_method = ' || l_delivery_method);
1135: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_event_action_id = ' || l_event_action_id);
1136:
1137: OPEN csr_loan_details;

Line 1134: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_delivery_method = ' || l_delivery_method);

1130: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_type = ' || l_primary_recipient_type);
1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);
1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);
1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);
1134: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_delivery_method = ' || l_delivery_method);
1135: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_event_action_id = ' || l_event_action_id);
1136:
1137: OPEN csr_loan_details;
1138: FETCH csr_loan_details

Line 1135: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_event_action_id = ' || l_event_action_id);

1131: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_primary_recipient_name = ' || l_primary_recipient_name);
1132: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_priority_num = ' || l_priority_num);
1133: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_active_for_num = ' || l_active_for_num);
1134: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_delivery_method = ' || l_delivery_method);
1135: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_event_action_id = ' || l_event_action_id);
1136:
1137: OPEN csr_loan_details;
1138: FETCH csr_loan_details
1139: INTO l_borrower_name

Line 1155: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Loan details:');

1151: , l_org_id
1152: , l_product_name;
1153: CLOSE csr_loan_details;
1154:
1155: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Loan details:');
1156: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_borrower_name = ' || l_borrower_name);
1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);
1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);

Line 1156: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_borrower_name = ' || l_borrower_name);

1152: , l_product_name;
1153: CLOSE csr_loan_details;
1154:
1155: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Loan details:');
1156: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_borrower_name = ' || l_borrower_name);
1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);
1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);

Line 1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);

1153: CLOSE csr_loan_details;
1154:
1155: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Loan details:');
1156: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_borrower_name = ' || l_borrower_name);
1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);
1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);

Line 1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);

1154:
1155: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Loan details:');
1156: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_borrower_name = ' || l_borrower_name);
1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);
1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);

Line 1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);

1155: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Loan details:');
1156: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_borrower_name = ' || l_borrower_name);
1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);
1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);

Line 1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);

1156: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_borrower_name = ' || l_borrower_name);
1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);
1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);

Line 1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);

1157: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_user = ' || l_loan_assigned_user);
1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);

Line 1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);

1158: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_assigned_name = ' || l_loan_assigned_name);
1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);

Line 1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);

1159: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_class = ' || l_loan_class);
1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);
1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);

Line 1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);

1160: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_type = ' || l_loan_type);
1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);
1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);
1168: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_org_id = ' || l_org_id);

Line 1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);

1161: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_subtype = ' || l_loan_subtype);
1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);
1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);
1168: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_org_id = ' || l_org_id);
1169: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_product_name = ' || l_product_name);

Line 1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);

1162: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_collateral_percent = ' || l_collateral_percent);
1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);
1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);
1168: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_org_id = ' || l_org_id);
1169: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_product_name = ' || l_product_name);
1170:

Line 1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);

1163: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_start_date = ' || l_loan_start_date);
1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);
1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);
1168: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_org_id = ' || l_org_id);
1169: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_product_name = ' || l_product_name);
1170:
1171: OPEN csr_loan_details1;

Line 1168: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_org_id = ' || l_org_id);

1164: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_term = ' || l_term);
1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);
1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);
1168: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_org_id = ' || l_org_id);
1169: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_product_name = ' || l_product_name);
1170:
1171: OPEN csr_loan_details1;
1172: FETCH csr_loan_details1

Line 1169: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_product_name = ' || l_product_name);

1165: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_maturity_date = ' || l_loan_maturity_date);
1166: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_interest_rate = ' || l_interest_rate);
1167: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_purpose = ' || l_loan_purpose);
1168: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_org_id = ' || l_org_id);
1169: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_product_name = ' || l_product_name);
1170:
1171: OPEN csr_loan_details1;
1172: FETCH csr_loan_details1
1173: INTO l_loan_amount

Line 1177: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_amount = ' || l_loan_amount);

1173: INTO l_loan_amount
1174: , l_loan_formatted_amount;
1175: CLOSE csr_loan_details1;
1176:
1177: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_amount = ' || l_loan_amount);
1178: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_formatted_amount = ' || l_loan_formatted_amount);
1179:
1180: OPEN csr_loan_details2;
1181: FETCH csr_loan_details2

Line 1178: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_formatted_amount = ' || l_loan_formatted_amount);

1174: , l_loan_formatted_amount;
1175: CLOSE csr_loan_details1;
1176:
1177: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_amount = ' || l_loan_amount);
1178: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_formatted_amount = ' || l_loan_formatted_amount);
1179:
1180: OPEN csr_loan_details2;
1181: FETCH csr_loan_details2
1182: INTO l_overdue_amount

Line 1186: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_overdue_amount = ' || l_overdue_amount);

1182: INTO l_overdue_amount
1183: , l_overdue_num;
1184: CLOSE csr_loan_details2;
1185:
1186: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_overdue_amount = ' || l_overdue_amount);
1187: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_overdue_num = ' || l_overdue_num);
1188:
1189: OPEN csr_current_user;
1190: FETCH csr_current_user

Line 1187: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_overdue_num = ' || l_overdue_num);

1183: , l_overdue_num;
1184: CLOSE csr_loan_details2;
1185:
1186: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_overdue_amount = ' || l_overdue_amount);
1187: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_overdue_num = ' || l_overdue_num);
1188:
1189: OPEN csr_current_user;
1190: FETCH csr_current_user
1191: INTO l_current_user;

Line 1194: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_current_user = ' || l_current_user);

1190: FETCH csr_current_user
1191: INTO l_current_user;
1192: CLOSE csr_current_user;
1193:
1194: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_current_user = ' || l_current_user);
1195:
1196: OPEN get_agent_approval_comment;
1197: FETCH get_agent_approval_comment
1198: INTO l_loan_approval_agent_note;

Line 1201: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_approval_agent_note = ' || l_loan_approval_agent_note);

1197: FETCH get_agent_approval_comment
1198: INTO l_loan_approval_agent_note;
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,

Line 1207: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_loan_number from GetItemAttrText = ' || l_current_user);

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);
1208:
1209: IF l_primary_recipient_type = 'ROLE' THEN
1210:
1211: OPEN csr_loan_role_users;

Line 1215: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'cursor csr_loan_role_users returns 0 rows');

1211: OPEN csr_loan_role_users;
1212: FETCH csr_loan_role_users
1213: INTO l_user_name,l_user_id;
1214: IF csr_loan_role_users%NOTFOUND THEN
1215: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'cursor csr_loan_role_users returns 0 rows');
1216: RETURN 'N';
1217: END IF;
1218:
1219: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_name = ' || l_user_name);

Line 1219: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_name = ' || l_user_name);

1215: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'cursor csr_loan_role_users returns 0 rows');
1216: RETURN 'N';
1217: END IF;
1218:
1219: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_name = ' || l_user_name);
1220: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_id = ' || l_user_id);
1221:
1222: if (has_user_org_access(l_user_id,l_org_id)) then
1223: l_user_roles := l_user_roles||','||l_user_name;

Line 1220: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_id = ' || l_user_id);

1216: RETURN 'N';
1217: END IF;
1218:
1219: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_name = ' || l_user_name);
1220: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_id = ' || l_user_id);
1221:
1222: if (has_user_org_access(l_user_id,l_org_id)) then
1223: l_user_roles := l_user_roles||','||l_user_name;
1224: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_roles is '||l_user_roles);

Line 1224: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_roles is '||l_user_roles);

1220: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_user_id = ' || l_user_id);
1221:
1222: if (has_user_org_access(l_user_id,l_org_id)) then
1223: l_user_roles := l_user_roles||','||l_user_name;
1224: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_roles is '||l_user_roles);
1225: end if;
1226: LOOP
1227: FETCH csr_loan_role_users
1228: INTO l_user_name,l_user_id;

Line 1230: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_name is '||l_user_name);

1226: LOOP
1227: FETCH csr_loan_role_users
1228: INTO l_user_name,l_user_id;
1229: EXIT WHEN csr_loan_role_users%NOTFOUND;
1230: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_name is '||l_user_name);
1231: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_id is '||l_user_id);
1232: if (has_user_org_access(l_user_id,l_org_id)) then
1233: l_user_roles := l_user_roles||','||l_user_name;
1234: end if;

Line 1231: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_id is '||l_user_id);

1227: FETCH csr_loan_role_users
1228: INTO l_user_name,l_user_id;
1229: EXIT WHEN csr_loan_role_users%NOTFOUND;
1230: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_name is '||l_user_name);
1231: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The l_user_id is '||l_user_id);
1232: if (has_user_org_access(l_user_id,l_org_id)) then
1233: l_user_roles := l_user_roles||','||l_user_name;
1234: end if;
1235: END LOOP;

Line 1242: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'For the Role, l_user_roles is '||l_user_roles);

1238: THEN
1239: l_user_roles := substr(l_user_roles, 2, (length(l_user_roles) - 1));
1240: END IF;
1241:
1242: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'For the Role, l_user_roles is '||l_user_roles);
1243:
1244: if (nvl(length(l_user_roles),0) < 3) then
1245: RETURN 'N';
1246: end if;

Line 1249: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_role_name = '||l_role_name);

1245: RETURN 'N';
1246: end if;
1247: l_role_name := 'Loan Managers'|| '(' ||l_loan_number || '-' || ItemKey
1248: || ')';
1249: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_role_name = '||l_role_name);
1250:
1251: -- Bug#8709307 - Added Expiration Date to the new adhoc role
1252: wf_directory.CreateAdhocRole(
1253: role_name => l_role_name,

Line 1265: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Set LNS_PRIMARY_ROLE = '||l_role_name);

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);
1266:
1267: ELSIF l_primary_recipient_type = 'INDIVIDUAL' AND l_primary_recipient_name = 'LOAN_ASSIGNED_TO' THEN
1268:
1269: -- l_user_roles := l_loan_assigned_user;

Line 1280: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Set LNS_PRIMARY_ROLE = '||l_role_name);

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);
1281:
1282: END IF;
1283:
1284: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'At last, l_user_roles is '||l_user_roles);

Line 1284: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'At last, l_user_roles is '||l_user_roles);

1280: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Set LNS_PRIMARY_ROLE = '||l_role_name);
1281:
1282: END IF;
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,

Line 1285: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, 'At last, l_role_name is '||l_role_name);

1281:
1282: END IF;
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',

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

1375: itemkey => itemkey,
1376: aname => 'LNS_LOAN_APPROVAL_AGENT_NOTE',
1377: avalue => l_loan_approval_agent_note);
1378: return 'Y';
1379: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1380: EXCEPTION
1381: WHEN OTHERS THEN
1382: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1383: || ' Exception -');

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

1378: return 'Y';
1379: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1380: EXCEPTION
1381: WHEN OTHERS THEN
1382: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1383: || ' Exception -');
1384: RAISE;
1385: END CREATE_NOTIFICATION_DETAILS;
1386: /*========================================================================

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

1453: AND message_name = 'MSG_LOAN_TO_BE_APPROVED'
1454: AND status = 'OPEN';
1455:
1456: BEGIN
1457: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1458: --test_proc('Inside PROCESS_EVENT');
1459:
1460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1461: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);

Line 1460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);

1456: BEGIN
1457: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1458: --test_proc('Inside PROCESS_EVENT');
1459:
1460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1461: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1462: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1463: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1464:

Line 1461: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);

1457: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1458: --test_proc('Inside PROCESS_EVENT');
1459:
1460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1461: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1462: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1463: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1464:
1465: SET_SESSION_CONTEXT(itemtype, itemkey);

Line 1462: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);

1458: --test_proc('Inside PROCESS_EVENT');
1459:
1460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1461: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1462: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1463: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1464:
1465: SET_SESSION_CONTEXT(itemtype, itemkey);
1466:

Line 1463: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);

1459:
1460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1461: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1462: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1463: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1464:
1465: SET_SESSION_CONTEXT(itemtype, itemkey);
1466:
1467: IF (funcmode <> wf_engine.eng_run) THEN

Line 1472: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting attributes:');

1468: resultout := wf_engine.eng_null;
1469: return;
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,

Line 1505: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_ID = ' || l_loan_id );

1501: ( itemtype => itemtype,
1502: itemkey => itemkey,
1503: aname => 'LNS_EVENT_NAME');
1504:
1505: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_ID = ' || l_loan_id );
1506: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_NUMBER = ' || l_loan_number );
1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );
1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );
1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );

Line 1506: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_NUMBER = ' || l_loan_number );

1502: itemkey => itemkey,
1503: aname => 'LNS_EVENT_NAME');
1504:
1505: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_ID = ' || l_loan_id );
1506: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_NUMBER = ' || l_loan_number );
1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );
1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );
1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );
1510: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CURRENT_USER_ID = ' || l_current_user_id );

Line 1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );

1503: aname => 'LNS_EVENT_NAME');
1504:
1505: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_ID = ' || l_loan_id );
1506: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_NUMBER = ' || l_loan_number );
1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );
1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );
1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );
1510: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CURRENT_USER_ID = ' || l_current_user_id );
1511: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_EVENT_NAME = ' || l_event_name );

Line 1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );

1504:
1505: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_ID = ' || l_loan_id );
1506: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_NUMBER = ' || l_loan_number );
1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );
1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );
1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );
1510: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CURRENT_USER_ID = ' || l_current_user_id );
1511: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_EVENT_NAME = ' || l_event_name );
1512:

Line 1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );

1505: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_ID = ' || l_loan_id );
1506: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_NUMBER = ' || l_loan_number );
1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );
1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );
1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );
1510: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CURRENT_USER_ID = ' || l_current_user_id );
1511: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_EVENT_NAME = ' || l_event_name );
1512:
1513: l_return_status := create_notification_details(itemkey => itemkey

Line 1510: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CURRENT_USER_ID = ' || l_current_user_id );

1506: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_NUMBER = ' || l_loan_number );
1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );
1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );
1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );
1510: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CURRENT_USER_ID = ' || l_current_user_id );
1511: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_EVENT_NAME = ' || l_event_name );
1512:
1513: l_return_status := create_notification_details(itemkey => itemkey
1514: ,itemtype => itemtype

Line 1511: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_EVENT_NAME = ' || l_event_name );

1507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_CLASS_CODE = ' || l_loan_class_code );
1508: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE = ' || l_loan_type );
1509: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_LOAN_TYPE_ID = ' || l_loan_type_id );
1510: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CURRENT_USER_ID = ' || l_current_user_id );
1511: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_EVENT_NAME = ' || l_event_name );
1512:
1513: l_return_status := create_notification_details(itemkey => itemkey
1514: ,itemtype => itemtype
1515: ,p_event_name => l_event_name

Line 1524: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status = ' || l_return_status );

1520: ,p_current_user_id => l_current_user_id
1521: );
1522:
1523: --test_proc('l_event_name - ' || l_event_name );
1524: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status = ' || l_return_status );
1525: --test_proc('l_return_status_crt_ntf - ' || l_return_status);
1526: IF(l_event_name = 'LOAN_APPROVAL_APPROVED' AND l_return_status = 'Y') THEN
1527:
1528: l_search_criteria := l_loan_number || '%';

Line 1529: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_search_criteria = ' || l_search_criteria );

1525: --test_proc('l_return_status_crt_ntf - ' || l_return_status);
1526: IF(l_event_name = 'LOAN_APPROVAL_APPROVED' AND l_return_status = 'Y') THEN
1527:
1528: l_search_criteria := l_loan_number || '%';
1529: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_search_criteria = ' || l_search_criteria );
1530:
1531: OPEN get_notifications_for_close(l_search_criteria);
1532:
1533: <>LOOP

Line 1537: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_notification_id = ' || l_notification_id );

1533: <>LOOP
1534: FETCH get_notifications_for_close INTO l_notification_id;
1535: EXIT PENDING_NOTIFICATIONS_LOOP WHEN get_notifications_for_close%NOTFOUND;
1536:
1537: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_notification_id = ' || l_notification_id );
1538: --test_proc('l_notification_id - ' || l_notification_id);
1539:
1540: if(l_notification_id is not null) then
1541: OPEN csr_current_user(l_current_user_id);

Line 1544: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_current_user_name = ' || l_current_user_name );

1540: if(l_notification_id is not null) then
1541: OPEN csr_current_user(l_current_user_id);
1542: FETCH csr_current_user INTO l_current_user_name;
1543: CLOSE csr_current_user;
1544: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_current_user_name = ' || l_current_user_name );
1545:
1546: --wf_notification.close(l_notification_id,l_current_user_name);
1547: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before setting Approve programmatically');
1548: --test_proc('Before setting Approve programmatically');

Line 1547: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before setting Approve programmatically');

1543: CLOSE csr_current_user;
1544: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_current_user_name = ' || l_current_user_name );
1545:
1546: --wf_notification.close(l_notification_id,l_current_user_name);
1547: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before setting Approve programmatically');
1548: --test_proc('Before setting Approve programmatically');
1549: wf_notification.setattrtext ( nid => l_notification_id
1550: , aname => 'RESULT'
1551: , avalue => 'APPROVE' );

Line 1555: LogMessage(FND_LOG.LEVEL_STATEMENT, 'After responding programmatically');

1551: , avalue => 'APPROVE' );
1552: wf_notification.respond ( nid => l_notification_id
1553: , respond_comment => null
1554: , responder => l_current_user_name );
1555: LogMessage(FND_LOG.LEVEL_STATEMENT, 'After responding programmatically');
1556: --test_proc('After responding programmatically');
1557: end if;
1558:
1559: END LOOP PENDING_NOTIFICATIONS_LOOP;

Line 1564: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'PROCESS_EVENT - resultOut is '||resultout);

1560:
1561: END IF;
1562:
1563: resultout := 'COMPLETE:' || l_return_status;
1564: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'PROCESS_EVENT - resultOut is '||resultout);
1565: EXCEPTION
1566: WHEN OTHERS THEN
1567: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1568: || ' Exception -');

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

1563: resultout := 'COMPLETE:' || l_return_status;
1564: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'PROCESS_EVENT - resultOut is '||resultout);
1565: EXCEPTION
1566: WHEN OTHERS THEN
1567: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1568: || ' Exception -');
1569: wf_core.context('LNSWF', 'PROCESS_EVENT', itemtype, itemkey,
1570: to_char(actid), funcmode); RAISE;
1571: END PROCESS_EVENT;

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

1631: | Cursor Declarations |
1632: +-----------------------------------------------------------------------*/
1633:
1634: BEGIN
1635: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1636:
1637: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1638: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);

Line 1637: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);

1633:
1634: BEGIN
1635: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1636:
1637: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1638: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1641:

Line 1638: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);

1634: BEGIN
1635: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1636:
1637: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1638: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1641:
1642: SET_SESSION_CONTEXT(itemtype, itemkey);

Line 1639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);

1635: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1636:
1637: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1638: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1641:
1642: SET_SESSION_CONTEXT(itemtype, itemkey);
1643:

Line 1640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);

1636:
1637: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1638: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1641:
1642: SET_SESSION_CONTEXT(itemtype, itemkey);
1643:
1644: IF (funcmode <> wf_engine.eng_run) THEN

Line 1662: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_id : ' || l_loan_id);

1658: from lns_loan_headers_all loan
1659: where loan.loan_id = l_loan_id;
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,

Line 1670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_APPROVAL setting G_LAST_ENTERED_NOTE : ' || G_LAST_ENTERED_NOTE);

1666: itemkey => itemkey,
1667: aname => 'WF_NOTE');
1668:
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,

Line 1678: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_approve_note : ' || l_loan_approve_note);

1674: itemkey => itemkey,
1675: aname => 'LNS_LAST_ENTERED_NOTE',
1676: avalue => l_loan_approve_note);
1677: */
1678: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_approve_note : ' || l_loan_approve_note);
1679:
1680: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_approval_action_rec.action_id from dual;
1681:
1682:

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 1728: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);

1724: X_RETURN_STATUS => l_RETURN_STATUS,
1725: X_MSG_COUNT => l_MSG_COUNT,
1726: X_MSG_DATA => l_MSG_DATA );
1727:
1728: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1729: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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);

Line 1729: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);

1725: X_MSG_COUNT => l_MSG_COUNT,
1726: X_MSG_DATA => l_MSG_DATA );
1727:
1728: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1729: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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:

Line 1730: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);

1726: X_MSG_DATA => l_MSG_DATA );
1727:
1728: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1729: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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' );

Line 1731: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);

1727:
1728: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1729: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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);

Line 1732: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);

1728: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1729: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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:

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 1735: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_approve_note : ' || l_loan_approve_note);

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
1739:

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 1796: LogMessage(FND_LOG.LEVEL_STATEMENT,'Created note : ' || to_char(l_note_id));

1792: p_msg_index_out => l_msg_index_out
1793: );
1794: END LOOP;
1795: ELSE
1796: LogMessage(FND_LOG.LEVEL_STATEMENT,'Created note : ' || to_char(l_note_id));
1797: END IF;
1798:
1799: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1800: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_note_id : ' || l_note_id);

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

1795: ELSE
1796: LogMessage(FND_LOG.LEVEL_STATEMENT,'Created note : ' || to_char(l_note_id));
1797: END IF;
1798:
1799: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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);

Line 1800: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_note_id : ' || l_note_id);

1796: LogMessage(FND_LOG.LEVEL_STATEMENT,'Created note : ' || to_char(l_note_id));
1797: END IF;
1798:
1799: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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' );

Line 1801: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);

1797: END IF;
1798:
1799: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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:

Line 1802: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);

1798:
1799: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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;

Line 1803: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);

1799: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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:

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 1813: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

1809:
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: resultout := 'COMPLETE:' || 'N';
1813: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1814: || ' Exception -');
1815: wf_core.context('LNSWF', 'PROCESS_LOAN_APPROVAL', itemtype, itemkey,
1816: to_char(actid), funcmode); RAISE;
1817: END PROCESS_LOAN_APPROVAL;

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

1873: l_msg_index_out NUMBER;
1874: l_org_id NUMBER;
1875:
1876: BEGIN
1877: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1878:
1879: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1880: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1881: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);

Line 1879: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);

1875:
1876: BEGIN
1877: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1878:
1879: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1880: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1881: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1882: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1883:

Line 1880: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);

1876: BEGIN
1877: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1878:
1879: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1880: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1881: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1882: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1883:
1884: SET_SESSION_CONTEXT(itemtype, itemkey);

Line 1881: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);

1877: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1878:
1879: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1880: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1881: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1882: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1883:
1884: SET_SESSION_CONTEXT(itemtype, itemkey);
1885:

Line 1882: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);

1878:
1879: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
1880: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
1881: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
1882: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
1883:
1884: SET_SESSION_CONTEXT(itemtype, itemkey);
1885:
1886: IF (funcmode <> wf_engine.eng_run) THEN

Line 1896: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_REJECTION l_loan_id : ' || l_loan_id);

1892: ( itemtype => itemtype,
1893: itemkey => itemkey,
1894: aname => 'LNS_LOAN_ID');
1895:
1896: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_REJECTION l_loan_id : ' || l_loan_id);
1897:
1898: --gparuchu - Code added to make sure correct object_version_number is passed
1899: --inorder to make sure the header table gets updated correctly upon Rejection process.
1900:

Line 1913: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_REJECTION setting G_LAST_ENTERED_NOTE : ' || G_LAST_ENTERED_NOTE);

1909: itemkey => itemkey,
1910: aname => 'WF_NOTE');
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',

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 1962: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

1958: X_RETURN_STATUS => l_RETURN_STATUS,
1959: X_MSG_COUNT => l_MSG_COUNT,
1960: X_MSG_DATA => l_MSG_DATA );
1961:
1962: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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);

Line 1963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);

1959: X_MSG_COUNT => l_MSG_COUNT,
1960: X_MSG_DATA => l_MSG_DATA );
1961:
1962: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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:

Line 1964: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);

1960: X_MSG_DATA => l_MSG_DATA );
1961:
1962: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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' );

Line 1965: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);

1961:
1962: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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);

Line 1966: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);

1962: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
1963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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:

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 1969: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In PROCESS_LOAN_REJECTION l_loan_reject_note : ' || l_loan_reject_note);

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:
1973: --added by GPARUCHU to set org correctly for JTF_NOTES_PUB.validate_object method

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 2031: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));

2027: );
2028:
2029: END LOOP;
2030: ELSE
2031: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));
2032: END IF;
2033:
2034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);

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

2030: ELSE
2031: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));
2032: END IF;
2033:
2034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
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);

Line 2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);

2031: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));
2032: END IF;
2033:
2034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
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:

Line 2036: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);

2032: END IF;
2033:
2034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
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' );

Line 2037: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);

2033:
2034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
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:

Line 2038: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);

2034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
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;

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 2049: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: resultout := 'COMPLETE:' || 'N';
2049: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
2050: || ' Exception -');
2051: wf_core.context('LNSWF', 'PROCESS_LOAN_REJECTION', itemtype, itemkey,
2052: to_char(actid), funcmode); RAISE;
2053: END PROCESS_LOAN_REJECTION;

Line 2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');

2114: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2115: l_IS_AME_INSTALLED fnd_profile_option_values.profile_option_value%TYPE;
2116:
2117: BEGIN
2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
2119:
2120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
2121: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
2122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);

Line 2120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);

2116:
2117: BEGIN
2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
2119:
2120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
2121: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
2122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
2123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
2124:

Line 2121: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);

2117: BEGIN
2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
2119:
2120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
2121: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
2122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
2123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
2124:
2125: SET_SESSION_CONTEXT(itemtype, itemkey);

Line 2122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);

2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
2119:
2120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
2121: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
2122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
2123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
2124:
2125: SET_SESSION_CONTEXT(itemtype, itemkey);
2126:

Line 2123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);

2119:
2120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemtype = ' || itemtype);
2121: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'itemkey = ' || itemkey);
2122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'actid = ' || actid);
2123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'funcmode = ' || funcmode);
2124:
2125: SET_SESSION_CONTEXT(itemtype, itemkey);
2126:
2127: IF (funcmode <> wf_engine.eng_run) THEN

Line 2136: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_loan_id from GetItemAttrNumber = ' || l_loan_id);

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);
2137:
2138: --gparuchu - Code added to make sure correct object_version_number is passed
2139: --inorder to make sure the header table gets updated correctly upon Approval process.
2140: IF (l_loan_id IS NOT NULL) THEN

Line 2152: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'G_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);

2148: itemkey => itemkey,
2149: aname => 'WF_NOTE');
2150:
2151: G_LAST_ENTERED_NOTE := l_req_loan_info_note;
2152: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'G_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
2153:
2154: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting l_req_loan_info_action_rec...');
2155: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_req_loan_info_action_rec.action_id from dual;
2156: l_req_loan_info_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;

Line 2154: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting l_req_loan_info_action_rec...');

2150:
2151: G_LAST_ENTERED_NOTE := l_req_loan_info_note;
2152: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'G_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
2153:
2154: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting l_req_loan_info_action_rec...');
2155: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_req_loan_info_action_rec.action_id from dual;
2156: l_req_loan_info_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;
2157: l_req_loan_info_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;
2158: l_req_loan_info_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;

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 2196: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

2192: X_RETURN_STATUS => l_RETURN_STATUS,
2193: X_MSG_COUNT => l_MSG_COUNT,
2194: X_MSG_DATA => l_MSG_DATA );
2195:
2196: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2197: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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);

Line 2197: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);

2193: X_MSG_COUNT => l_MSG_COUNT,
2194: X_MSG_DATA => l_MSG_DATA );
2195:
2196: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2197: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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:

Line 2198: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);

2194: X_MSG_DATA => l_MSG_DATA );
2195:
2196: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2197: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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' );

Line 2199: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);

2195:
2196: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2197: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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:

Line 2200: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);

2196: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2197: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_action_id : ' || l_action_id);
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);

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 2204: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_req_loan_info_note : ' || l_req_loan_info_note);

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
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,

Line 2211: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Approver User Name : ' || l_approver_user_name);

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:
2213: --added to get the profile name correctly
2214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION fnd_global.user_id : ' || fnd_global.user_id);
2215: --FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);

Line 2214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION fnd_global.user_id : ' || fnd_global.user_id);

2210: aname => 'LNS_PRIMARY_ROLE');
2211: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Approver User Name : ' || l_approver_user_name);
2212:
2213: --added to get the profile name correctly
2214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION fnd_global.user_id : ' || fnd_global.user_id);
2215: --FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2216: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2217: l_IS_AME_INSTALLED := FND_PROFILE.value('AME_INSTALLED_FLAG');
2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_IS_AME_INSTALLED : ' || l_IS_AME_INSTALLED);

Line 2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_IS_AME_INSTALLED : ' || l_IS_AME_INSTALLED);

2214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION fnd_global.user_id : ' || fnd_global.user_id);
2215: --FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2216: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2217: l_IS_AME_INSTALLED := FND_PROFILE.value('AME_INSTALLED_FLAG');
2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_IS_AME_INSTALLED : ' || l_IS_AME_INSTALLED);
2219: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_transaction_type : ' || l_transaction_type);
2220:
2221: --Only when AME:Installed and LNS_AME_TRANSACTION_TYPE profile is setup, need to perform following action
2222:

Line 2219: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_transaction_type : ' || l_transaction_type);

2215: --FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2216: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2217: l_IS_AME_INSTALLED := FND_PROFILE.value('AME_INSTALLED_FLAG');
2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_IS_AME_INSTALLED : ' || l_IS_AME_INSTALLED);
2219: LogMessage(FND_LOG.LEVEL_STATEMENT, 'In REQUEST_LOAN_INFORMATION l_transaction_type : ' || l_transaction_type);
2220:
2221: --Only when AME:Installed and LNS_AME_TRANSACTION_TYPE profile is setup, need to perform following action
2222:
2223: IF(l_transaction_type IS NOT NULL AND l_IS_AME_INSTALLED IS NOT NULL) THEN

Line 2226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AME Engine with Null Status for Approver - ' || l_approver_user_name);

2222:
2223: IF(l_transaction_type IS NOT NULL AND l_IS_AME_INSTALLED IS NOT NULL) THEN
2224: approverRecord.name := l_approver_user_name;
2225: approverRecord.approval_status := ame_util.nullStatus;
2226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AME Engine with Null Status for Approver - ' || l_approver_user_name);
2227:
2228: AME_API2.updateApprovalStatus(applicationIdIn => 206,
2229: transactionTypeIn => l_transaction_type,
2230: transactionIdIn => l_loan_id,

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 2294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));

2290: p_msg_index_out => l_msg_index_out
2291: );
2292: END LOOP;
2293: ELSE
2294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));
2295: END IF;
2296:
2297: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);

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

2293: ELSE
2294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));
2295: END IF;
2296:
2297: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
2299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
2300: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);
2301: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);

Line 2298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);

2294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Created note : ' || to_char(l_note_id));
2295: END IF;
2296:
2297: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
2299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
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:

Line 2299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);

2295: END IF;
2296:
2297: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
2299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
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:

Line 2300: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_COUNT : ' || l_MSG_COUNT);

2296:
2297: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
2299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
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' );

Line 2301: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_MSG_DATA : ' || l_MSG_DATA);

2297: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
2298: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_note_id : ' || l_note_id);
2299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_RETURN_STATUS : ' || l_RETURN_STATUS);
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:

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 2313: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

2309:
2310: EXCEPTION
2311: WHEN OTHERS THEN
2312: resultout := 'COMPLETE:' || 'N';
2313: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
2314: || ' Exception -');
2315: wf_core.context('LNSWF', 'REQUEST_LOAN_INFORMATION', itemtype, itemkey,
2316: to_char(actid), funcmode); RAISE;
2317: END REQUEST_LOAN_INFORMATION;

Line 2354: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.APPROVE_LOAN_FROM_NTF' || ' +');

2350: resultout out NOCOPY varchar2 ) IS
2351:
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;

Line 2363: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_approval_from_ntf : ' || l_loan_approval_from_ntf);

2359: END IF;
2360:
2361: l_loan_approval_from_ntf := FND_PROFILE.value('LNS_APPROVE_LOAN_FROM_NTF');
2362:
2363: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_approval_from_ntf : ' || l_loan_approval_from_ntf);
2364:
2365: IF NVL(l_loan_approval_from_ntf,'N') = 'N' THEN
2366: resultout := 'COMPLETE:' || 'N';
2367: ELSE

Line 2373: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.APPROVE_LOAN_FROM_NTF'

2369: END IF;
2370:
2371: EXCEPTION
2372: WHEN OTHERS THEN
2373: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.APPROVE_LOAN_FROM_NTF'
2374: || ' Exception -');
2375: wf_core.context('LNSWF', 'APPROVE_LOAN_FROM_NTF', itemtype, itemkey,
2376: to_char(actid), funcmode); RAISE;
2377:

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

2405:
2406: l_api_name CONSTANT VARCHAR2(30) := 'SYNCH_EVENT_ACTIONS';
2407: l_api_version CONSTANT NUMBER := 1.0;
2408: BEGIN
2409: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2410: insert into lns_event_actions (
2411: EVENT_ACTION_ID
2412: , EVENT_ID
2413: , EVENT_ACTION_NAME

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

2467: where ev.loan_class_code = missingvalues.loan_class_code
2468: and ea.event_id = ev.event_id
2469: and ea.loan_type = decode(ev.loan_class_code,'ERS','ERS','BUSINESS')
2470: and ea.event_action_name = 'NOTIFICATION';
2471: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in synch event actions: ' || sqlerrm);
2475: /* This error message needs to be seeded in the future */

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

2470: and ea.event_action_name = 'NOTIFICATION';
2471: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in synch event actions: ' || sqlerrm);
2475: /* This error message needs to be seeded in the future */
2476: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERROR_SYNCH_EVTS');
2477: FND_MSG_PUB.ADD;
2478: raise;

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

2507:
2508: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_LNS_EVENT_ACTIONS';
2509: l_api_version CONSTANT NUMBER := 1.0;
2510: BEGIN
2511: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2512:
2513: DELETE FROM lns_event_actions
2514: WHERE loan_type_id = p_loan_type_id;
2515:

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

2512:
2513: DELETE FROM lns_event_actions
2514: WHERE loan_type_id = p_loan_type_id;
2515:
2516: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2517: EXCEPTION
2518: WHEN OTHERS THEN
2519: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in delete_lns_event_actions: ' || sqlerrm);
2520: /* This error message needs to be seeded in the future */

Line 2519: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in delete_lns_event_actions: ' || sqlerrm);

2515:
2516: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2517: EXCEPTION
2518: WHEN OTHERS THEN
2519: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in delete_lns_event_actions: ' || sqlerrm);
2520: /* This error message needs to be seeded in the future */
2521: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERR_DEL_EVNT_ACTION');
2522: FND_MSG_PUB.ADD;
2523: raise;

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

2557: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
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');

Line 2566: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);

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);
2567:
2568: ame_api2.getNextApprovers4(applicationIdIn => 206 ,
2569: transactionTypeIn => p_ame_trx_type,
2570: transactionIdIn => l_loan_id,

Line 2574: LogMessage(FND_LOG.LEVEL_STATEMENT, 'After calling ame_api2.getNextApprovers4');

2570: transactionIdIn => l_loan_id,
2571: approvalProcessCompleteYNOut => approvalComplete,
2572: nextApproversOut => l_next_approver) ;
2573:
2574: LogMessage(FND_LOG.LEVEL_STATEMENT, 'After calling ame_api2.getNextApprovers4');
2575:
2576: IF (l_next_approver.count < 1) THEN
2577: -- no more approvers left
2578: x_approver_user_name := null;

Line 2582: LogMessage(FND_LOG.LEVEL_STATEMENT, 'x_approver_user_name : ' || x_approver_user_name);

2578: x_approver_user_name := null;
2579: RETURN;
2580: else
2581: x_approver_user_name := l_next_approver(i).name;
2582: LogMessage(FND_LOG.LEVEL_STATEMENT, 'x_approver_user_name : ' || x_approver_user_name);
2583: end if;
2584:
2585: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2586: EXCEPTION

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

2581: x_approver_user_name := l_next_approver(i).name;
2582: LogMessage(FND_LOG.LEVEL_STATEMENT, 'x_approver_user_name : ' || x_approver_user_name);
2583: end if;
2584:
2585: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2586: EXCEPTION
2587: WHEN OTHERS THEN
2588:
2589: wf_core.context(

Line 2644: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' +');

2640: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2641:
2642:
2643: BEGIN
2644: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' +');
2645: --
2646: -- RUN mode - normal process execution
2647: --
2648: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || p_funcmode);

Line 2648: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || p_funcmode);

2644: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' +');
2645: --
2646: -- RUN mode - normal process execution
2647: --
2648: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || p_funcmode);
2649: IF (p_funcmode = 'RUN') THEN
2650:
2651:
2652: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

Line 2653: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);

2649: IF (p_funcmode = 'RUN') THEN
2650:
2651:
2652: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2653: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2654: FindNextApprover(
2655: p_item_type => p_item_type,
2656: p_item_key => p_item_key,
2657: p_ame_trx_type => l_transaction_type, --G_TRANSACTION_TYPE,

Line 2660: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || l_approver_user_name);

2656: p_item_key => p_item_key,
2657: p_ame_trx_type => l_transaction_type, --G_TRANSACTION_TYPE,
2658: x_approver_user_name => l_approver_user_name);
2659:
2660: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || l_approver_user_name);
2661:
2662:
2663:
2664: IF (l_approver_user_name IS NOT NULL) THEN

Line 2679: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || 'IS NULL');

2675: END IF;
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',

Line 2696: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' -');

2692:
2693:
2694: END IF; -- END of run mode
2695:
2696: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' -');
2697: EXCEPTION
2698: WHEN OTHERS THEN
2699: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER'
2700: || ' Exception -');

Line 2699: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER'

2695:
2696: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' -');
2697: EXCEPTION
2698: WHEN OTHERS THEN
2699: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER'
2700: || ' Exception -');
2701:
2702: wf_core.context(
2703: pkg_name => 'LNS_WORK_FLOW',

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

2750: l_loan_approve_note VARCHAR2(2000);
2751:
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,

Line 2755: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || p_funcmode);

2751:
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');

Line 2768: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Approver User Name : ' || l_approver_user_name);

2764: itemkey => p_item_key,
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');

Line 2774: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);

2770: ( itemtype => p_item_type,
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');

Line 2786: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);

2782: aname => 'LNS_LAST_ENTERED_NOTE',
2783: avalue => l_loan_approve_note);
2784:
2785:
2786: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2787: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.resp_id : ' || fnd_global.resp_id);
2788: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2789: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);

Line 2787: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.resp_id : ' || fnd_global.resp_id);

2783: avalue => l_loan_approve_note);
2784:
2785:
2786: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2787: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.resp_id : ' || fnd_global.resp_id);
2788: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2789: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2791:

Line 2790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);

2786: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2787: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.resp_id : ' || fnd_global.resp_id);
2788: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2789: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2791:
2792:
2793: approverRecord.name := l_approver_user_name;
2794: approverRecord.approval_status := ame_util.approvedStatus;

Line 2801: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AME Engine with Status Approved for user - '|| l_approver_user_name);

2797: transactionTypeIn => l_transaction_type,
2798: transactionIdIn => l_loan_id,
2799: approverIn => approverRecord,
2800: updateItemIn => TRUE);
2801: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AME Engine with Status Approved for user - '|| l_approver_user_name);
2802:
2803:
2804:
2805: p_result := 'COMPLETE:'||'';

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

2802:
2803:
2804:
2805: p_result := 'COMPLETE:'||'';
2806: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2807:
2808: EXCEPTION
2809: WHEN OTHERS THEN
2810:

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

2857: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
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');

Line 2867: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || l_approver_user_name);

2863: ( itemtype => p_item_type,
2864: itemkey => p_item_key,
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,

Line 2873: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);

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);
2874:
2875: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2876: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2877: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');

Line 2875: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);

2871: itemkey => p_item_key,
2872: aname => 'LNS_LOAN_ID');
2873: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_id : ' || l_loan_id);
2874:
2875: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2876: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2877: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2878: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2879:

Line 2878: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);

2874:
2875: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fnd_global.user_id : ' || fnd_global.user_id);
2876: FND_GLOBAL.APPS_INITIALIZE(fnd_global.user_id,fnd_global.resp_id,206);
2877: l_transaction_type := FND_PROFILE.value('LNS_AME_TRANSACTION_TYPE');
2878: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_transaction_type : ' || l_transaction_type);
2879:
2880:
2881: approverRecord.name := l_approver_user_name;
2882: approverRecord.approval_status := ame_util.rejectStatus;

Line 2891: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AME Engine with Status Rejected');

2887: approverIn => approverRecord,
2888: updateItemIn => TRUE);
2889:
2890:
2891: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AME Engine with Status Rejected');
2892: p_result := 'COMPLETE:'||'';
2893: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2894:
2895: EXCEPTION

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

2889:
2890:
2891: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating AME Engine with Status Rejected');
2892: p_result := 'COMPLETE:'||'';
2893: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2894:
2895: EXCEPTION
2896: WHEN OTHERS THEN
2897:

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

2940:
2941: l_loan_approval_using_ame fnd_profile_option_values.profile_option_value%TYPE;
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;

Line 2953: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AME:Installed : ' || l_loan_approval_using_ame);

2949: END IF;
2950:
2951: l_loan_approval_using_ame := FND_PROFILE.value('AME:Installed');
2952:
2953: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AME:Installed : ' || l_loan_approval_using_ame);
2954:
2955: IF NVL(l_loan_approval_using_ame,'N') = 'N' THEN
2956: resultout := 'COMPLETE:' || 'N';
2957: ELSE

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

2956: resultout := 'COMPLETE:' || 'N';
2957: ELSE
2958: resultout := 'COMPLETE:' || 'Y';
2959: END IF;
2960: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2961:
2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' Exception -');

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

2960: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2961:
2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' Exception -');
2965: wf_core.context('LNSWF', 'APPROVE_LOAN_USING_AME', itemtype, itemkey,
2966: to_char(actid), funcmode); RAISE;
2967:
2968: END APPROVE_LOAN_USING_AME;

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

3029: select user_id from fnd_user where user_name = p_approver_user_name;
3030:
3031: BEGIN
3032:
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

Line 3034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || funcmode);

3030:
3031: BEGIN
3032:
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,

Line 3042: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || l_approver_user_name);

3038: ( itemtype => itemtype,
3039: itemkey => itemkey,
3040: aname => 'LNS_PRIMARY_ROLE');
3041:
3042: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_approver_user_name : ' || l_approver_user_name);
3043: if (l_approver_user_name is not null) then
3044: OPEN find_userId_from_user_name(l_approver_user_name);
3045: FETCH find_userId_from_user_name INTO l_user_id;
3046:

Line 3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_user_id : ' || l_user_id);

3050:
3051: CLOSE find_userId_from_user_name;
3052:
3053: end if;
3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_user_id : ' || l_user_id);
3055: if(l_user_id is not null ) then
3056:
3057: OPEN verify_lns_mgr_role(l_user_id);
3058: FETCH verify_lns_mgr_role INTO l_manager_flag;

Line 3067: LogMessage(FND_LOG.LEVEL_STATEMENT, 'manager_flag : ' || l_manager_flag);

3063:
3064: CLOSE verify_lns_mgr_role;
3065:
3066: end if;
3067: LogMessage(FND_LOG.LEVEL_STATEMENT, 'manager_flag : ' || l_manager_flag);
3068: */
3069: EXCEPTION
3070: WHEN OTHERS THEN
3071:

Line 3072: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Exception in AME_VERIFY_LOANS_MGR_ROLE');

3068: */
3069: EXCEPTION
3070: WHEN OTHERS THEN
3071:
3072: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Exception in AME_VERIFY_LOANS_MGR_ROLE');
3073: wf_core.context(
3074: pkg_name => 'LOANS_WORK_FLOW',
3075: proc_name => 'APPROVE_LOAN_USING_AME',
3076: arg1 => itemtype,

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

3080: arg5 => null);
3081:
3082: RAISE;
3083:
3084: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3085: --resultout := 'COMPLETE:Y';
3086: END AME_VERIFY_LOANS_MGR_ROLE;
3087:
3088: /*========================================================================

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

3137: l_api_version CONSTANT NUMBER := 1.0;
3138:
3139: BEGIN
3140:
3141: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3142:
3143: IF (p_funmode = 'RUN') THEN
3144:
3145: BEGIN

Line 3152: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_nRespId : ' || l_nRespId);

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
3154: WHEN OTHERS THEN
3155: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
3156: null;

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

3185: p_result := 'COMPLETE';
3186:
3187: END IF;
3188:
3189: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3190:
3191: EXCEPTION
3192: WHEN OTHERS THEN
3193: wf_core.context('LNSWF', 'AMEEnabled', p_item_type, p_item_key,

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

3259: | Cursor Declarations |
3260: +-----------------------------------------------------------------------*/
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;

Line 3264: LogMessage(FND_LOG.LEVEL_STATEMENT, 'p_funcmode : ' || funcmode);

3260: +-----------------------------------------------------------------------*/
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;

Line 3282: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_id : ' || l_loan_id);

3278: from lns_loan_headers_all loan
3279: where loan.loan_id = l_loan_id;
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,

Line 3295: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_approve_note : ' || l_loan_approve_note);

3291: itemkey => itemkey,
3292: aname => 'LNS_LAST_ENTERED_NOTE',
3293: avalue => l_loan_approve_note);
3294:
3295: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_approve_note : ' || l_loan_approve_note);
3296:
3297: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_approval_action_rec.action_id from dual;
3298:
3299: l_loan_approval_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;

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 3340: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);

3336: X_RETURN_STATUS => l_RETURN_STATUS,
3337: X_MSG_COUNT => l_MSG_COUNT,
3338: X_MSG_DATA => l_MSG_DATA );
3339:
3340: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3341: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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);

Line 3341: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);

3337: X_MSG_COUNT => l_MSG_COUNT,
3338: X_MSG_DATA => l_MSG_DATA );
3339:
3340: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3341: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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:

Line 3342: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);

3338: X_MSG_DATA => l_MSG_DATA );
3339:
3340: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3341: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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' );

Line 3343: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);

3339:
3340: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3341: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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);

Line 3344: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);

3340: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3341: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_action_id : ' || l_action_id);
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:

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

Line 3347: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_approve_note : ' || l_loan_approve_note);

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
3351:

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 3410: LogMessage(FND_LOG.LEVEL_STATEMENT,'Created note : ' || to_char(l_note_id));

3406: p_msg_index_out => l_msg_index_out
3407: );
3408: END LOOP;
3409: ELSE
3410: LogMessage(FND_LOG.LEVEL_STATEMENT,'Created note : ' || to_char(l_note_id));
3411: END IF;
3412:
3413:
3414: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);

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

3410: LogMessage(FND_LOG.LEVEL_STATEMENT,'Created note : ' || to_char(l_note_id));
3411: END IF;
3412:
3413:
3414: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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);

Line 3415: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_note_id : ' || l_note_id);

3411: END IF;
3412:
3413:
3414: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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' );

Line 3416: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_RETURN_STATUS : ' || l_RETURN_STATUS);

3412:
3413:
3414: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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:

Line 3417: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_COUNT : ' || l_MSG_COUNT);

3413:
3414: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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:

Line 3418: LogMessage(FND_LOG.LEVEL_STATEMENT,'l_MSG_DATA : ' || l_MSG_DATA);

3414: LogMessage(FND_LOG.LEVEL_STATEMENT,'G_LOG_ENABLED: ' || G_LOG_ENABLED);
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;

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:

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

3425:
3426: EXCEPTION
3427: WHEN OTHERS THEN
3428: resultout := 'COMPLETE:' || 'N';
3429: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
3430: || ' Exception -');
3431: wf_core.context('LNSWF', 'PROCESS_AME_APPROVAL_ACTION', itemtype, itemkey,
3432: to_char(actid), funcmode);
3433: RAISE;

Line 3440: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

3436:
3437:
3438: BEGIN
3439: G_LOG_ENABLED := 'N';
3440: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3441:
3442: /* getting msg logging info */
3443: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3444: IF (G_LOG_ENABLED = 'N') then

Line 3445: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

3441:
3442: /* getting msg logging info */
3443: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3444: IF (G_LOG_ENABLED = 'N') then
3445: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3446: ELSE
3447: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
3448: END IF;
3449: END LNS_WORK_FLOW;

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

3443: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3444: IF (G_LOG_ENABLED = 'N') then
3445: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3446: ELSE
3447: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
3448: END IF;
3449: END LNS_WORK_FLOW;