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.IEX_WF_DEL_CUR_STATUS_NOTE_PUB dependencies on FND_LOG

Line 30: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

26: PROCEDURE clear_table_values ;
27:
28:
29: -- PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
30: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31:
32: PROCEDURE start_workflow
33: (
34: p_api_version IN NUMBER := 1.0,

Line 115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

111: v_rep_sql := v_rep_sql || 'NVL(r.SOURCE_MGR_ID, l.created_by), NVL(r.SOURCE_MGR_NAME, r.SOURCE_NAME)' ;
112: v_rep_sql := v_rep_sql || ' from IEX_REPOSSESSIONS l ';
113:
114: -- IF PG_DEBUG < 10 THEN
115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
116: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Litigation SQL');
117: END IF;
118: -- IF PG_DEBUG < 10 THEN
119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
116: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Litigation SQL');
117: END IF;
118: -- IF PG_DEBUG < 10 THEN
119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
120: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
121: END IF;
122: -- IF PG_DEBUG < 10 THEN
123: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 123: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
120: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
121: END IF;
122: -- IF PG_DEBUG < 10 THEN
123: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
124: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_lit_sql || v_end_sql);
125: END IF;
126: -- IF PG_DEBUG < 10 THEN
127: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 127: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

123: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
124: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_lit_sql || v_end_sql);
125: END IF;
126: -- IF PG_DEBUG < 10 THEN
127: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
128: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
129: END IF;
130:
131: -- IF PG_DEBUG < 10 THEN

Line 132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

128: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
129: END IF;
130:
131: -- IF PG_DEBUG < 10 THEN
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Repo SQL');
134: END IF;
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Repo SQL');
134: END IF;
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
138: END IF;
139: -- IF PG_DEBUG < 10 THEN
140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
138: END IF;
139: -- IF PG_DEBUG < 10 THEN
140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
141: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_rep_sql || v_end_sql);
142: END IF;
143: -- IF PG_DEBUG < 10 THEN
144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
141: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_rep_sql || v_end_sql);
142: END IF;
143: -- IF PG_DEBUG < 10 THEN
144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
145: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
146: END IF;
147:
148: -- IF PG_DEBUG < 10 THEN

Line 149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

145: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
146: END IF;
147:
148: -- IF PG_DEBUG < 10 THEN
149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
150: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Bank SQL');
151: END IF;
152: -- IF PG_DEBUG < 10 THEN
153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
150: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Bank SQL');
151: END IF;
152: -- IF PG_DEBUG < 10 THEN
153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
154: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
155: END IF;
156: -- IF PG_DEBUG < 10 THEN
157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
154: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
155: END IF;
156: -- IF PG_DEBUG < 10 THEN
157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
158: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_ban_sql || v_end_sql);
159: END IF;
160: -- IF PG_DEBUG < 10 THEN
161: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 161: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
158: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_ban_sql || v_end_sql);
159: END IF;
160: -- IF PG_DEBUG < 10 THEN
161: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
162: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
163: END IF;
164:
165: -- IF PG_DEBUG < 10 THEN

Line 166: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

162: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
163: END IF;
164:
165: -- IF PG_DEBUG < 10 THEN
166: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
167: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Woff SQL');
168: END IF;
169: -- IF PG_DEBUG < 10 THEN
170: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 170: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

166: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
167: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Woff SQL');
168: END IF;
169: -- IF PG_DEBUG < 10 THEN
170: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
171: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
172: END IF;
173: -- IF PG_DEBUG < 10 THEN
174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

170: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
171: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
172: END IF;
173: -- IF PG_DEBUG < 10 THEN
174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
175: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_wof_sql || v_end_sql);
176: END IF;
177: -- IF PG_DEBUG < 10 THEN
178: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 178: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
175: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || v_wof_sql || v_end_sql);
176: END IF;
177: -- IF PG_DEBUG < 10 THEN
178: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
179: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '--------------');
180: END IF;
181:
182: -- INITIALIZING PL/SQL TABLES

Line 194: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

190: p_wf_item_text_name(p_wf_item_text_name.LAST + 1) := 'OWNER_NAME' ;
191: p_wf_item_text_name(p_wf_item_text_name.LAST + 1) := 'MANAGER_NAME' ;
192:
193: -- IF PG_DEBUG < 10 THEN
194: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
195: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Delinquency Table Size ' || to_char(p_delinquency_ids.COUNT));
196: END IF;
197:
198: -- Starting the WorkFlow

Line 204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

200: FOR cnt in p_delinquency_ids.FIRST..p_delinquency_ids.LAST
201: LOOP
202: p_wf_item_number_value(1) := p_delinquency_ids(cnt) ;
203: -- IF PG_DEBUG < 10 THEN
204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
205: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' ---------------------------------------------------');
206: END IF;
207: -- IF PG_DEBUG < 10 THEN
208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
205: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' ---------------------------------------------------');
206: END IF;
207: -- IF PG_DEBUG < 10 THEN
208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
209: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Delinquency Id >> ' || to_char(p_delinquency_ids(cnt)));
210: END IF;
211:
212: /* ___________________ LITIGATIONS WORKFLOW _____________________*/

Line 224: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

220: l_owner_name,
221: l_mgr_id,
222: l_mgr_name ;
223: -- IF PG_DEBUG < 10 THEN
224: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
225: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Lit Data>> ' || to_char(l_owner_id) || ' >> ' || to_char(l_type_id) || ' >> '|| l_owner_name || ' >> ' || to_char(l_mgr_id) || ' >> ' || l_mgr_name );
226: END IF;
227:
228: EXCEPTION

Line 231: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: -- IF PG_DEBUG < 10 THEN
231: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
232: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Liti >> ' || SQLCODE || ' >> ' || SQLERRM);
233: END IF;
234: END MAIN ;
235:

Line 238: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

234: END MAIN ;
235:
236: IF v_del_notification_cur%FOUND THEN
237: -- IF PG_DEBUG < 10 THEN
238: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
239: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START LIT PROCESS Owner id '||l_owner_id);
240: END IF;
241: -- IF PG_DEBUG < 10 THEN
242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

238: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
239: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START LIT PROCESS Owner id '||l_owner_id);
240: END IF;
241: -- IF PG_DEBUG < 10 THEN
242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
243: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START LIT PROCESS Type id '||l_type_id);
244: END IF;
245:
246: select 'LIT_' || to_char(IEX_DEL_WF_S.Nextval)

Line 262: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

258: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_owner_name ;
259: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_mgr_name ;
260:
261: -- IF PG_DEBUG < 10 THEN
262: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
263: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ LITIGATION ***************');
264: END IF;
265: -- IF PG_DEBUG < 10 THEN
266: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 266: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

262: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
263: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ LITIGATION ***************');
264: END IF;
265: -- IF PG_DEBUG < 10 THEN
266: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
267: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
268: END IF;
269: -- IF PG_DEBUG < 10 THEN
270: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 270: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

266: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
267: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
268: END IF;
269: -- IF PG_DEBUG < 10 THEN
270: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
271: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Text Name count >> ' || to_char(p_wf_item_text_name.count) || 'Text Value count >> ' || to_char(p_wf_item_text_value.count));
272: END IF;
273:
274:

Line 287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

283: l_return_status ,
284: l_result ) ;
285:
286: -- IF PG_DEBUG < 10 THEN
287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
288: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Lit Return Status '||v_ItemKey||' '||l_return_status);
289: END IF;
290:
291:

Line 309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

305: l_owner_name,
306: l_mgr_id,
307: l_mgr_name ;
308: -- IF PG_DEBUG < 10 THEN
309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
310: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' BAN Data>> ' || to_char(l_owner_id) || ' >> ' || to_char(l_type_id) || ' >> '|| l_owner_name || ' >> ' || to_char(l_mgr_id) || ' >> ' || l_mgr_name );
311: END IF;
312:
313: EXCEPTION

Line 316: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

312:
313: EXCEPTION
314: WHEN OTHERS THEN
315: -- IF PG_DEBUG < 10 THEN
316: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
317: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Bank >> ' || SQLCODE || ' >> ' || SQLERRM);
318: END IF;
319: END MAIN ;
320:

Line 324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

320:
321: IF v_del_notification_cur%FOUND THEN
322:
323: -- IF PG_DEBUG < 10 THEN
324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
325: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START BANK PROCESS Owner id '||l_owner_id);
326: END IF;
327: -- IF PG_DEBUG < 10 THEN
328: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 328: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
325: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START BANK PROCESS Owner id '||l_owner_id);
326: END IF;
327: -- IF PG_DEBUG < 10 THEN
328: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
329: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START BANK PROCESS Type id '||l_type_id);
330: END IF;
331:
332: select 'BAN_' || to_char(IEX_DEL_WF_S.Nextval)

Line 347: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

343: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_owner_name ;
344: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_mgr_name ;
345:
346: -- IF PG_DEBUG < 10 THEN
347: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
348: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ BANKRUPTCY ***************');
349: END IF;
350: -- IF PG_DEBUG < 10 THEN
351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

347: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
348: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ BANKRUPTCY ***************');
349: END IF;
350: -- IF PG_DEBUG < 10 THEN
351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
352: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
353: END IF;
354: -- IF PG_DEBUG < 10 THEN
355: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 355: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
352: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
353: END IF;
354: -- IF PG_DEBUG < 10 THEN
355: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
356: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Text Name count >> ' || to_char(p_wf_item_text_name.count) || 'Text Value count >> ' || to_char(p_wf_item_text_value.count));
357: END IF;
358:
359: SEND_NOTIFICATION(

Line 369: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

365: p_wf_item_TEXT_VALUE ,
366: l_return_status ,
367: l_result ) ;
368:
369: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
370: --IEX_DEBUG_PUB.LOGMESSAGE('Bank Ret Status '||ItemKey||' '||l_return_status);
371: --END IF;
372:
373: Clear_Table_Values ;

Line 390: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

386: l_owner_name,
387: l_mgr_id,
388: l_mgr_name ;
389: -- IF PG_DEBUG < 10 THEN
390: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
391: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Data>> ' || to_char(l_owner_id) || ' >> ' || to_char(l_type_id) || ' >> '|| l_owner_name || ' >> ' || to_char(l_mgr_id) || ' >> ' || l_mgr_name );
392: END IF;
393:
394: EXCEPTION

Line 397: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

393:
394: EXCEPTION
395: WHEN OTHERS THEN
396: -- IF PG_DEBUG < 10 THEN
397: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
398: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Write Off >>' || SQLCODE || ' >> ' || SQLERRM);
399: END IF;
400: END MAIN ;
401:

Line 405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

401:
402: IF v_del_notification_cur%FOUND THEN
403:
404: -- IF PG_DEBUG < 10 THEN
405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
406: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START wof PROCESS Owner id '||l_owner_id);
407: END IF;
408: -- IF PG_DEBUG < 10 THEN
409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
406: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START wof PROCESS Owner id '||l_owner_id);
407: END IF;
408: -- IF PG_DEBUG < 10 THEN
409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
410: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START WOF PROCESS Type id '||l_type_id);
411: END IF;
412:
413: select 'WRI_' || to_char(IEX_DEL_WF_S.Nextval)

Line 428: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

424: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_owner_name ;
425: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_mgr_name ;
426:
427: -- IF PG_DEBUG < 10 THEN
428: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
429: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ WRITE OFF ***************');
430: END IF;
431: -- IF PG_DEBUG < 10 THEN
432: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 432: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

428: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
429: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ WRITE OFF ***************');
430: END IF;
431: -- IF PG_DEBUG < 10 THEN
432: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
433: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
434: END IF;
435: -- IF PG_DEBUG < 10 THEN
436: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 436: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

432: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
433: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
434: END IF;
435: -- IF PG_DEBUG < 10 THEN
436: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
437: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Text Name count >> ' || to_char(p_wf_item_text_name.count) || 'Text Value count >> ' || to_char(p_wf_item_text_value.count));
438: END IF;
439:
440: SEND_NOTIFICATION(

Line 450: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

446: p_wf_item_TEXT_VALUE ,
447: l_return_status ,
448: l_result ) ;
449:
450: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
451: --IEX_DEBUG_PUB.LOGMESSAGE('WRI Return Status '||ItemKey||' '||l_return_status);
452: --END IF;
453:
454: Clear_Table_Values ;

Line 470: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

466: l_owner_name,
467: l_mgr_id,
468: l_mgr_name ;
469: -- IF PG_DEBUG < 10 THEN
470: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
471: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Repo Data>> ' || to_char(l_owner_id) || ' >> ' || to_char(l_type_id) || ' >> '|| l_owner_name || ' >> ' || to_char(l_mgr_id) || ' >> ' || l_mgr_name );
472: END IF;
473:
474: EXCEPTION

Line 477: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: -- IF PG_DEBUG < 10 THEN
477: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
478: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || ' Repo >>' || SQLCODE || ' >> ' || SQLERRM);
479: END IF;
480: END MAIN ;
481:

Line 485: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

481:
482: IF v_del_notification_cur%FOUND THEN
483:
484: -- IF PG_DEBUG < 10 THEN
485: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
486: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START Repo PROCESS Owner id '||l_owner_id);
487: END IF;
488: -- IF PG_DEBUG < 10 THEN
489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

485: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
486: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START Repo PROCESS Owner id '||l_owner_id);
487: END IF;
488: -- IF PG_DEBUG < 10 THEN
489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
490: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'START REPO PROCESS Type id '||l_type_id);
491: END IF;
492:
493: select 'REP_' || to_char(IEX_DEL_WF_S.Nextval)

Line 508: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

504: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_owner_name ;
505: p_wf_item_text_value(p_wf_item_text_value.LAST + 1) := l_mgr_name ;
506:
507: -- IF PG_DEBUG < 10 THEN
508: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
509: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ REPOSSESSION ***************');
510: END IF;
511: -- IF PG_DEBUG < 10 THEN
512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

508: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
509: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || '************ REPOSSESSION ***************');
510: END IF;
511: -- IF PG_DEBUG < 10 THEN
512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
513: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
514: END IF;
515: -- IF PG_DEBUG < 10 THEN
516: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 516: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
513: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Num Name count >> ' || to_char(p_wf_item_number_name.count) || 'Num Value count >> ' || to_char(p_wf_item_number_value.count));
514: END IF;
515: -- IF PG_DEBUG < 10 THEN
516: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
517: IEX_DEBUG_PUB.LOGMESSAGE('start_workflow: ' || 'Text Name count >> ' || to_char(p_wf_item_text_name.count) || 'Text Value count >> ' || to_char(p_wf_item_text_value.count));
518: END IF;
519:
520: SEND_NOTIFICATION(

Line 653: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

649: l_result OUT NOCOPY varchar2 )
650: IS
651: BEGIN
652:
653: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
654: IEX_DEBUG_PUB.LOGMESSAGE('Item Type >> ' || p_itemtype || ' Item Key >> ' || p_itemkey || ' Process >> ' || workflowprocess) ;
655: END IF;
656:
657: wf_engine.createprocess (

Line 677: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

673: avalue => p_wf_item_text_value);
674:
675: wf_engine.startprocess( itemtype => p_itemtype,
676: itemkey => p_itemkey);
677: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
678: IEX_DEBUG_PUB.LOGMESSAGE('Send Notification Before Item Status');
679: END IF;
680:
681: wf_engine.ItemStatus( itemtype => p_ItemType,

Line 685: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

681: wf_engine.ItemStatus( itemtype => p_ItemType,
682: itemkey => p_ItemKey,
683: status => l_return_status,
684: result => l_result);
685: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
686: IEX_DEBUG_PUB.LOGMESSAGE('Send Notification Status >> ' || l_return_status);
687: IEX_DEBUG_PUB.LOGMESSAGE('Result Status >> ' || l_result);
688: END IF;
689:

Line 694: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

690: EXCEPTION
691: WHEN OTHERS then
692: -- Raise the Error and Return Error Status Back.
693: -- Null for now
694: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
695: IEX_DEBUG_PUB.LOGMESSAGE(SQLCODE || ' >> ' || SQLERRM) ;
696: END IF;
697: END ;
698:

Line 750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

746: ld_msg_data ) ;
747:
748: EXCEPTION
749: WHEN OTHERS THEN
750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
751: IEX_DEBUG_PUB.LOGMESSAGE(SQLCODE || ' >> ' || SQLERRM) ;
752: END IF;
753: END MAIN ;
754: __________________________________________________________________________*/