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_BAN_STATUS_PUB dependencies on IEX_DEBUG_PUB

Line 83: iex_debug_pub.logmessage('IEX Start Getting Bankrutpcy Status API .......');

79: l_errmsg varchar2(1000);
80:
81: Begin
82:
83: iex_debug_pub.logmessage('IEX Start Getting Bankrutpcy Status API .......');
84:
85:
86: begin
87:

Line 91: iex_debug_pub.logmessage('IEX get_party_status : BankruptcyID = :'||l_bankruptcy_id||' Turn Invoicing Y/N = :'||l_flag);

87:
88: Open c_get_party_status(p_party_id,p_date);
89: Fetch c_get_party_status into l_bankruptcy_id,l_flag;
90:
91: iex_debug_pub.logmessage('IEX get_party_status : BankruptcyID = :'||l_bankruptcy_id||' Turn Invoicing Y/N = :'||l_flag);
92:
93: if c_get_party_status%NOTFOUND then
94: iex_debug_pub.logmessage('No Party level Bankruptcy Exist..');
95: null;

Line 94: iex_debug_pub.logmessage('No Party level Bankruptcy Exist..');

90:
91: iex_debug_pub.logmessage('IEX get_party_status : BankruptcyID = :'||l_bankruptcy_id||' Turn Invoicing Y/N = :'||l_flag);
92:
93: if c_get_party_status%NOTFOUND then
94: iex_debug_pub.logmessage('No Party level Bankruptcy Exist..');
95: null;
96: else
97: if l_flag = 'Y' then
98: l_status := 'PB';

Line 110: iex_debug_pub.LogMessage('IEX get_party_status ..Excetion Error :' || l_errmsg ||' and l_flag = '||l_flag);

106:
107: exception
108: when others then
109: l_errmsg := SQLERRM;
110: iex_debug_pub.LogMessage('IEX get_party_status ..Excetion Error :' || l_errmsg ||' and l_flag = '||l_flag);
111: null;
112: end;
113:
114: begin

Line 119: iex_debug_pub.logmessage('IEX get_acct_status : BankruptcyID = :'||l_bankruptcy_id||' Turn Invoicing Y/N = :'||l_flag);

115:
116: Open c_get_acct_status(p_party_id,p_cust_account_id,p_date);
117: Fetch c_get_acct_status into l_bankruptcy_id,l_flag;
118:
119: iex_debug_pub.logmessage('IEX get_acct_status : BankruptcyID = :'||l_bankruptcy_id||' Turn Invoicing Y/N = :'||l_flag);
120:
121:
122: if c_get_acct_status%NOTFOUND then
123: iex_debug_pub.logmessage('No Account level Bankruptcy Exist..');

Line 123: iex_debug_pub.logmessage('No Account level Bankruptcy Exist..');

119: iex_debug_pub.logmessage('IEX get_acct_status : BankruptcyID = :'||l_bankruptcy_id||' Turn Invoicing Y/N = :'||l_flag);
120:
121:
122: if c_get_acct_status%NOTFOUND then
123: iex_debug_pub.logmessage('No Account level Bankruptcy Exist..');
124: null;
125: else
126: if l_flag = 'Y' then
127: l_status := 'AB';

Line 139: iex_debug_pub.LogMessage('IEX get_TurnInvOff ..Excetion Error :' || l_errmsg ||' and l_flag = '||l_flag);

135:
136: exception
137: When others then
138: l_errmsg := SQLERRM;
139: iex_debug_pub.LogMessage('IEX get_TurnInvOff ..Excetion Error :' || l_errmsg ||' and l_flag = '||l_flag);
140: null;
141: end;
142:
143: l_status := 'NN';

Line 201: iex_debug_pub.logmessage('IEX Start get_TurnInvOff Bankruptcy Workflow..');

197: l_errmsg varchar2(1000);
198:
199:
200: begin
201: iex_debug_pub.logmessage('IEX Start get_TurnInvOff Bankruptcy Workflow..');
202:
203: Open c_get_flag(p_party_id,p_cust_account_id,p_date);
204: Fetch c_get_flag into l_bankruptcy_id,l_flag;
205:

Line 206: iex_debug_pub.logmessage('IEX get_TurnInvOff : BankruptcyID = :'||l_bankruptcy_id||' Y/N = :'||l_flag);

202:
203: Open c_get_flag(p_party_id,p_cust_account_id,p_date);
204: Fetch c_get_flag into l_bankruptcy_id,l_flag;
205:
206: iex_debug_pub.logmessage('IEX get_TurnInvOff : BankruptcyID = :'||l_bankruptcy_id||' Y/N = :'||l_flag);
207:
208: if c_get_flag%NOTFOUND then
209: iex_debug_pub.logmessage('IEX get_TurnInvOff : c_getflag%NOTFOUND..');
210: null;

Line 209: iex_debug_pub.logmessage('IEX get_TurnInvOff : c_getflag%NOTFOUND..');

205:
206: iex_debug_pub.logmessage('IEX get_TurnInvOff : BankruptcyID = :'||l_bankruptcy_id||' Y/N = :'||l_flag);
207:
208: if c_get_flag%NOTFOUND then
209: iex_debug_pub.logmessage('IEX get_TurnInvOff : c_getflag%NOTFOUND..');
210: null;
211: end if;
212:
213: Close c_get_flag;

Line 215: iex_debug_pub.logmessage('IEX get_TurnInvOff : Returning Y/N = :'||l_flag);

211: end if;
212:
213: Close c_get_flag;
214:
215: iex_debug_pub.logmessage('IEX get_TurnInvOff : Returning Y/N = :'||l_flag);
216: return l_flag;
217:
218: exception
219: When others then

Line 221: iex_debug_pub.LogMessage('IEX get_TurnInvOff ..Excetion Error :' || l_errmsg ||' and l_flag = '||l_flag);

217:
218: exception
219: When others then
220: l_errmsg := SQLERRM;
221: iex_debug_pub.LogMessage('IEX get_TurnInvOff ..Excetion Error :' || l_errmsg ||' and l_flag = '||l_flag);
222: return l_flag;
223: end;
224:
225:

Line 269: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..');

265: AND a.user_id = p_user_id;
266:
267: BEGIN
268: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
269: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..');
270: end if;
271:
272: -- Standard Start of API savepoint
273: SAVEPOINT START_WORKFLOW;

Line 301: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..p_bankruptcy_id=' ||p_bankruptcy_id);

297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: --Start bug 3659342 by gnramasa
300: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
301: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..p_bankruptcy_id=' ||p_bankruptcy_id);
302: end if;
303:
304: /*
305: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

Line 315: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_user_id=' ||p_user_id);

311: itemtype := 'IEXBANST';
312: workflowprocess := 'BANKRUPT_STATUS';
313:
314: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
315: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_user_id=' ||p_user_id);
316: end if;
317:
318: begin
319: -- Get manager

Line 324: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow usernme exception');

320: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
321: WHERE user_id = p_user_id;
322: exception
323: when others then
324: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow usernme exception');
325: end;
326:
327: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
328: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Party_id=' ||p_party_id);

Line 328: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Party_id=' ||p_party_id);

324: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow usernme exception');
325: end;
326:
327: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
328: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Party_id=' ||p_party_id);
329: end if;
330:
331: begin
332: SELECT party_name INTO l_party_name from hz_parties

Line 336: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow party_name exception');

332: SELECT party_name INTO l_party_name from hz_parties
333: where party_id = p_party_id;
334: exception
335: when others then
336: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow party_name exception');
337: end;
338:
339: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
340: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Useerid=' ||p_user_id);

Line 340: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Useerid=' ||p_user_id);

336: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow party_name exception');
337: end;
338:
339: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
340: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Useerid=' ||p_user_id);
341: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..username=' ||l_user_name);
342: end if;
343:
344: begin

Line 341: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..username=' ||l_user_name);

337: end;
338:
339: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
340: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Useerid=' ||p_user_id);
341: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..username=' ||l_user_name);
342: end if;
343:
344: begin
345: OPEN C_MANAGER(p_user_id);

Line 356: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow manager exception');

352: exception
353: when others then
354: l_manager_id := p_user_id;
355: l_manager_name := l_user_name;
356: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow manager exception');
357: end;
358: /*
359: select b.bankruptcy_id bankruptcy_id
360: into l_bankruptcy_id

Line 366: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..getting bankruptcy id=' ||l_user_name);

362: where d.delinquency_id = b.delinquency_id
363: and d.delinquency_id = p_delinquency_id;
364: */
365: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
366: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..getting bankruptcy id=' ||l_user_name);
367: end if;
368:
369: /*
370: select bankruptcy_id bankruptcy_id

Line 388: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);

384: end;
385: -- bug 15935804 end ...
386:
387: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
388: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
389: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);

Line 389: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);

385: -- bug 15935804 end ...
386:
387: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
388: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
389: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);

Line 390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);

386:
387: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
388: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
389: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);

Line 391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);

387: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
388: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
389: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);

Line 392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);

388: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
389: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);

Line 393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);

389: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);

Line 394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);

390: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
398: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);

Line 395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);

391: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
398: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
399: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);

Line 396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);

392: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
398: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
399: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
400: end if;

Line 397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);

393: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
398: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
399: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
400: end if;
401:

Line 398: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);

394: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
398: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
399: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
400: end if;
401:
402: wf_engine.createprocess ( itemtype => itemtype,

Line 399: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);

395: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
396: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
397: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
398: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
399: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
400: end if;
401:
402: wf_engine.createprocess ( itemtype => itemtype,
403: itemkey => itemkey,

Line 473: iex_debug_pub.logmessage('IEX-7 Return Status ='||l_return_status);

469: itemkey => ItemKey,
470: status => l_return_status,
471: result => l_result);
472:
473: iex_debug_pub.logmessage('IEX-7 Return Status ='||l_return_status);
474:
475: if (l_return_status in ('COMPLETE', 'ACTIVE')) THEN
476: x_return_status := 'S';
477: commit;

Line 560: iex_debug_pub.logmessage ('update_approval_status start');

556:
557: l_profile := NVL(fnd_profile.value('IEX_STRY_CREATE_BANKRUPTCY'), 'Y');
558:
559: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
560: iex_debug_pub.logmessage ('update_approval_status start');
561: iex_debug_pub.logmessage ('Profile IEX_STRY_CREATE_BANKRUPTCY == '||l_profile);
562: END IF;
563:
564: -- bug 15990736 ... begin

Line 561: iex_debug_pub.logmessage ('Profile IEX_STRY_CREATE_BANKRUPTCY == '||l_profile);

557: l_profile := NVL(fnd_profile.value('IEX_STRY_CREATE_BANKRUPTCY'), 'Y');
558:
559: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
560: iex_debug_pub.logmessage ('update_approval_status start');
561: iex_debug_pub.logmessage ('Profile IEX_STRY_CREATE_BANKRUPTCY == '||l_profile);
562: END IF;
563:
564: -- bug 15990736 ... begin
565: begin

Line 570: iex_debug_pub.logmessage ('Collections Methods ==> '||l_collections_methods);

566: select collections_methods into l_collections_methods from iex_questionnaire_items;
567: exception
568: when others then null;
569: end;
570: iex_debug_pub.logmessage ('Collections Methods ==> '||l_collections_methods);
571: -- bug 15990736 ... end
572:
573: -- if l_profile = 'Y' then -- bug 15990736
574: if (l_profile = 'Y') and (l_collections_methods <> 'DUNNING') then -- bug 15990736

Line 598: iex_debug_pub.logmessage ('update_approval_status start, before getting the bankruptcy id');

594: itemtype => itemtype,
595: itemkey => itemkey,
596: aname => 'PARTY_NAME');
597: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
598: iex_debug_pub.logmessage ('update_approval_status start, before getting the bankruptcy id');
599: END IF;
600:
601: --Start bug 6359342 gnramasa 23-Aug-07
602: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

Line 608: iex_debug_pub.logmessage ('update_approval_status start, after getting the bankruptcy id');

604: itemkey => itemkey,
605: aname => 'BANKRUPTCY_ID');
606:
607: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
608: iex_debug_pub.logmessage ('update_approval_status start, after getting the bankruptcy id');
609: END IF;
610:
611: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
612: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);

Line 612: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);

608: iex_debug_pub.logmessage ('update_approval_status start, after getting the bankruptcy id');
609: END IF;
610:
611: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
612: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);
613: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);
614: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);
615: END IF;
616:

Line 613: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);

609: END IF;
610:
611: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
612: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);
613: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);
614: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);
615: END IF;
616:
617:

Line 614: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);

610:
611: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
612: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);
613: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);
614: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);
615: END IF;
616:
617:
618: Create_strategy(

Line 631: iex_debug_pub.logmessage ('update_approval_status:'||l_return_status);

627: p_party_id => l_party_id
628: );
629:
630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
631: iex_debug_pub.logmessage ('update_approval_status:'||l_return_status);
632: END IF;
633: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
634: RAISE L_API_ERROR;
635: END IF;

Line 667: iex_debug_pub.logmessage('IEX- approval date updating Exception....');

663:
664: commit;
665: exception
666: when others then
667: iex_debug_pub.logmessage('IEX- approval date updating Exception....');
668: end;
669:
670: EXCEPTION
671: WHEN L_API_ERROR then

Line 703: iex_debug_pub.logmessage('IEX-Reject Bankruptcy Start ..');

699: l_bankruptcy_id number;
700:
701: BEGIN
702:
703: iex_debug_pub.logmessage('IEX-Reject Bankruptcy Start ..');
704: l_api_name := 'update_rejection_status';
705: l_manager_name := wf_engine.GetItemAttrText(
706: itemtype => itemtype,
707: itemkey => itemkey,

Line 736: iex_debug_pub.logmessage('IEX-Rejct Attribute15 Exception....');

732: begin
733: select attribute15,cust_account_id into l_att15,l_cust_account_id from iex_bankruptcies where bankruptcy_id = l_bankruptcy_id;
734: exception
735: when others then
736: iex_debug_pub.logmessage('IEX-Rejct Attribute15 Exception....');
737: end;
738: -- fixed a bug 5261811
739: begin
740: iex_debug_pub.logmessage('IEX-Reject Bankruptcy partyid ..'||l_party_id);

Line 740: iex_debug_pub.logmessage('IEX-Reject Bankruptcy partyid ..'||l_party_id);

736: iex_debug_pub.logmessage('IEX-Rejct Attribute15 Exception....');
737: end;
738: -- fixed a bug 5261811
739: begin
740: iex_debug_pub.logmessage('IEX-Reject Bankruptcy partyid ..'||l_party_id);
741: -- bug 14637604
742: if (l_att15 is not null and l_cust_account_id is not null) then
743: update IEX_BANKRUPTCIES set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate
744: where bankruptcy_id = l_bankruptcy_id;

Line 755: iex_debug_pub.logmessage('IEX-Rejct Exception....');

751: commit;
752:
753: exception
754: when others then
755: iex_debug_pub.logmessage('IEX-Rejct Exception....');
756: end;
757:
758: result := 'COMPLETE';
759:

Line 914: iex_debug_pub.logmessage ('set_no_contact_in_tca: ' || 'Update Contact Preference:'||l_return_status);

910: END IF;
911:
912: -- IF PG_DEBUG < 10 THEN
913: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
914: iex_debug_pub.logmessage ('set_no_contact_in_tca: ' || 'Update Contact Preference:'||l_return_status);
915: END IF;
916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
917: RAISE L_API_ERROR;
918: END IF;

Line 957: iex_debug_pub.logmessage ('set_no_contact_in_tca: ' || 'Create Contact Preference:'||l_return_status);

953: x_msg_data => l_msg_data);
954:
955: -- IF PG_DEBUG < 10 THEN
956: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
957: iex_debug_pub.logmessage ('set_no_contact_in_tca: ' || 'Create Contact Preference:'||l_return_status);
958: END IF;
959: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
960: RAISE L_API_ERROR;
961: END IF;

Line 1048: iex_debug_pub.logmessage ('turnoff_collection_profile: ' || 'result =>'||result);

1044: -- result := 'COMPLETE:N';
1045: END IF;
1046: -- IF PG_DEBUG < 10 THEN
1047: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1048: iex_debug_pub.logmessage ('turnoff_collection_profile: ' || 'result =>'||result);
1049: END IF;
1050:
1051: EXCEPTION
1052: WHEN l_API_ERROR then

Line 1180: iex_debug_pub.logMessage('In turnoff_collections.Create Ind Delinquency: ' ||l_return_status);

1176: x_del_id_tbl => DelIdTab -- Table of Deliquencies that got created (Index correspoding to the case_id table);
1177: );
1178: -- IF PG_DEBUG < 10 THEN
1179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1180: iex_debug_pub.logMessage('In turnoff_collections.Create Ind Delinquency: ' ||l_return_status);
1181: END IF;
1182:
1183: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1184: RAISE L_API_ERROR;

Line 1208: iex_debug_pub.logMessage('In turnoff_collections.Create bankruptcy: ' ||l_return_status);

1204: X_Msg_Data => l_msg_data
1205: );
1206: -- IF PG_DEBUG < 10 THEN
1207: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1208: iex_debug_pub.logMessage('In turnoff_collections.Create bankruptcy: ' ||l_return_status);
1209: END IF;
1210: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1211: RAISE L_API_ERROR;
1212: END IF;

Line 1228: iex_debug_pub.logMessage('In turnoff_collections.Create strategy: ' ||l_return_status);

1224: p_ObjectID => P_ObjectID);
1225:
1226: -- IF PG_DEBUG < 10 THEN
1227: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1228: iex_debug_pub.logMessage('In turnoff_collections.Create strategy: ' ||l_return_status);
1229: END IF;
1230: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1231: RAISE L_API_ERROR;
1232: END IF;

Line 1372: iex_debug_pub.logMessage('In no_turnoff_collections.Create Ind Delinquency: ' ||l_return_status);

1368: x_del_id_tbl => DelIdTab -- Table of Deliquencies that got created (Index correspoding to the case_id table);
1369: );
1370: -- IF PG_DEBUG < 10 THEN
1371: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1372: iex_debug_pub.logMessage('In no_turnoff_collections.Create Ind Delinquency: ' ||l_return_status);
1373: END IF;
1374: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1375: RAISE L_API_ERROR;
1376: END IF;

Line 1397: iex_debug_pub.logMessage('In no_turnoff_collections.Create bankruptcy: ' ||l_return_status);

1393: X_Msg_Data => l_msg_data
1394: );
1395: -- IF PG_DEBUG < 10 THEN
1396: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1397: iex_debug_pub.logMessage('In no_turnoff_collections.Create bankruptcy: ' ||l_return_status);
1398: END IF;
1399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1400: RAISE L_API_ERROR;
1401: END IF;

Line 1416: iex_debug_pub.logMessage('In no_turnoff_collections.Create strategy: ' ||l_return_status);

1412: p_ObjectType => P_ObjectType,
1413: p_ObjectID => P_ObjectID);
1414: -- IF PG_DEBUG < 10 THEN
1415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1416: iex_debug_pub.logMessage('In no_turnoff_collections.Create strategy: ' ||l_return_status);
1417: END IF;
1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: RAISE L_API_ERROR;
1420: END IF;

Line 1512: IEX_DEBUG_PUB.logMessage('Create_Strategy : l_disposition_code := ' ||l_disposition_code);

1508: from iex_bankruptcies
1509: where bankruptcy_id = p_bankruptcy_id;
1510:
1511: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1512: IEX_DEBUG_PUB.logMessage('Create_Strategy : l_disposition_code := ' ||l_disposition_code);
1513: END IF;
1514:
1515: if l_disposition_code is NULL then
1516: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1517: IEX_DEBUG_PUB.logMessage('Create_Strategy : Calling IEX_STRATEGY_PUB.create_strategy');

1513: END IF;
1514:
1515: if l_disposition_code is NULL then
1516: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1517: IEX_DEBUG_PUB.logMessage('Create_Strategy : Calling IEX_STRATEGY_PUB.create_strategy');
1518: END IF;
1519: IEX_STRATEGY_PUB.create_strategy(
1520: P_Api_Version_Number => l_api_version_number,
1521: P_Init_Msg_List => l_init_msg_list,

Line 1532: IEX_DEBUG_PUB.logMessage('Start cancel_strategy_and_workflow');

1528: p_ObjectType => P_ObjectType,
1529: p_ObjectID => P_ObjectID);
1530: else
1531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1532: IEX_DEBUG_PUB.logMessage('Start cancel_strategy_and_workflow');
1533: END IF;
1534: end if;
1535:
1536: -- Standard call to get message count and if count is 1, get message info.

Line 1594: IEX_DEBUG_PUB.logMessage('Start cancel_strategy_and_workflow');

1590: -- End bug 7703313
1591:
1592: begin
1593: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1594: IEX_DEBUG_PUB.logMessage('Start cancel_strategy_and_workflow');
1595: END IF;
1596: SAVEPOINT cancel_strategy_and_workflow;
1597:
1598: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1599: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_party_id =>' || p_party_id);

1595: END IF;
1596: SAVEPOINT cancel_strategy_and_workflow;
1597:
1598: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1599: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_party_id =>' || p_party_id);
1600: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_bankruptcy_id =>' || p_bankruptcy_id);
1601: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_disposition_code =>' || p_disposition_code);
1602: END IF;
1603:

Line 1600: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_bankruptcy_id =>' || p_bankruptcy_id);

1596: SAVEPOINT cancel_strategy_and_workflow;
1597:
1598: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1599: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_party_id =>' || p_party_id);
1600: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_bankruptcy_id =>' || p_bankruptcy_id);
1601: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_disposition_code =>' || p_disposition_code);
1602: END IF;
1603:
1604: begin

Line 1601: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_disposition_code =>' || p_disposition_code);

1597:
1598: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1599: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_party_id =>' || p_party_id);
1600: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_bankruptcy_id =>' || p_bankruptcy_id);
1601: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_disposition_code =>' || p_disposition_code);
1602: END IF;
1603:
1604: begin
1605: open c_get_strategy_id (p_bankruptcy_id);

Line 1610: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: l_startegy_id =>' || l_startegy_id);

1606: fetch c_get_strategy_id into l_startegy_id;
1607: close c_get_strategy_id;
1608:
1609: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1610: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: l_startegy_id =>' || l_startegy_id);
1611: END IF;
1612:
1613: exception
1614: when others then IEX_DEBUG_PUB.logMessage('exception to get strategy ID'); null;

Line 1614: when others then IEX_DEBUG_PUB.logMessage('exception to get strategy ID'); null;

1610: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: l_startegy_id =>' || l_startegy_id);
1611: END IF;
1612:
1613: exception
1614: when others then IEX_DEBUG_PUB.logMessage('exception to get strategy ID'); null;
1615: end;
1616:
1617: if l_startegy_id is not null then
1618: begin

Line 1620: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Before calling IEX_STRATEGY_WF.SEND_SIGNAL');

1616:
1617: if l_startegy_id is not null then
1618: begin
1619: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1620: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Before calling IEX_STRATEGY_WF.SEND_SIGNAL');
1621: END IF;
1622: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',
1623: strategy_id => l_startegy_id,
1624: status => 'CANCELLED' ) ;

Line 1627: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: After calling IEX_STRATEGY_WF.SEND_SIGNAL');

1623: strategy_id => l_startegy_id,
1624: status => 'CANCELLED' ) ;
1625:
1626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1627: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: After calling IEX_STRATEGY_WF.SEND_SIGNAL');
1628: END IF;
1629: exception
1630: when others then
1631: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1632: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: In others exception');

1628: END IF;
1629: exception
1630: when others then
1631: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1632: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: In others exception');
1633: END IF;
1634: Update iex_strategies set status_code = 'CANCELLED'
1635: where strategy_id = l_startegy_id;
1636:

Line 1643: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: End of others exception');

1639: where strategy_id = l_startegy_id
1640: and status_code in ('PRE-WAIT','OPEN');
1641:
1642: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1643: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: End of others exception');
1644: END IF;
1645: end;
1646: end if;
1647:

Line 1652: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Workflow status =>' || l_status);

1648: if (p_disposition_code = 'WITHDRAWN') or (p_disposition_code = 'DISMISSED') then
1649: begin
1650: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_bankruptcy_id, status => l_status, result => l_result);
1651: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1652: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Workflow status =>' || l_status);
1653: END IF;
1654:
1655: IF l_status <> wf_engine.eng_completed THEN
1656: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_bankruptcy_id);

Line 1659: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Abort process has completed and status =>' || l_status);

1655: IF l_status <> wf_engine.eng_completed THEN
1656: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_bankruptcy_id);
1657: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_bankruptcy_id, status => l_status, result => l_result);
1658: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1659: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Abort process has completed and status =>' || l_status);
1660: END IF;
1661:
1662: END IF;
1663: EXCEPTION

Line 1664: when others then IEX_DEBUG_PUB.logMessage('exception to disposition code step 1 '); null;

1660: END IF;
1661:
1662: END IF;
1663: EXCEPTION
1664: when others then IEX_DEBUG_PUB.logMessage('exception to disposition code step 1 '); null;
1665:
1666: END;
1667:
1668: -- Begin bug 7703313

Line 1676: IEX_DEBUG_PUB.logMessage('IEXDELCS Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);

1672: fetch get_cs_itemkey into l_itemkey;
1673: exit when get_cs_itemkey%NOTFOUND;
1674:
1675: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1676: IEX_DEBUG_PUB.logMessage('IEXDELCS Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
1677: end if;
1678:
1679: wf_engine.itemstatus(itemtype => 'IEXDELCS', itemkey => l_itemkey, status => l_status, result => l_result);
1680: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1681: IEX_DEBUG_PUB.logMessage('IEXDELCS Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);

1677: end if;
1678:
1679: wf_engine.itemstatus(itemtype => 'IEXDELCS', itemkey => l_itemkey, status => l_status, result => l_result);
1680: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1681: IEX_DEBUG_PUB.logMessage('IEXDELCS Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
1682: end if;
1683:
1684: if l_status <> wf_engine.eng_completed THEN
1685: wf_engine.abortprocess(itemtype => 'IEXDELCS', itemkey => l_itemkey);

Line 1688: IEX_DEBUG_PUB.logMessage('cancel serviceHold_workflow: Abort process has completed and status =>' || l_status);

1684: if l_status <> wf_engine.eng_completed THEN
1685: wf_engine.abortprocess(itemtype => 'IEXDELCS', itemkey => l_itemkey);
1686: wf_engine.itemstatus(itemtype => 'IEXDELCS', itemkey => l_itemkey, status => l_status, result => l_result);
1687: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1688: IEX_DEBUG_PUB.logMessage('cancel serviceHold_workflow: Abort process has completed and status =>' || l_status);
1689: END IF;
1690: end if;
1691: End Loop;
1692: close get_cs_itemkey;

Line 1696: IEX_DEBUG_PUB.logMessage('ServiceHold Workflow does not exist '||p_bankruptcy_id);

1692: close get_cs_itemkey;
1693:
1694: exception
1695: when others then
1696: IEX_DEBUG_PUB.logMessage('ServiceHold Workflow does not exist '||p_bankruptcy_id);
1697: null;
1698: end;
1699:
1700: begin

Line 1707: IEX_DEBUG_PUB.logMessage('IEXDELCR Workflow Status = :: =>' || l_status||'and itemkwy is ...'||l_itemkey);

1703: fetch get_cr_itemkey into l_itemkey;
1704: exit when get_cr_itemkey%NOTFOUND;
1705:
1706: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1707: IEX_DEBUG_PUB.logMessage('IEXDELCR Workflow Status = :: =>' || l_status||'and itemkwy is ...'||l_itemkey);
1708: end if;
1709:
1710: wf_engine.itemstatus(itemtype => 'IEXDELCR', itemkey => l_itemkey, status => l_status, result => l_result);
1711: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1712: IEX_DEBUG_PUB.logMessage('IEXDELCR Workflow Status = :: =>' || l_status||'and itemkwy is ...'||l_itemkey);

1708: end if;
1709:
1710: wf_engine.itemstatus(itemtype => 'IEXDELCR', itemkey => l_itemkey, status => l_status, result => l_result);
1711: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1712: IEX_DEBUG_PUB.logMessage('IEXDELCR Workflow Status = :: =>' || l_status||'and itemkwy is ...'||l_itemkey);
1713: end if;
1714:
1715: if l_status <> wf_engine.eng_completed THEN
1716: wf_engine.abortprocess(itemtype => 'IEXDELCR', itemkey => l_itemkey);

Line 1719: IEX_DEBUG_PUB.logMessage('cancel_creditHold_request_workflow: Abort process has completed and status =>' || l_status);

1715: if l_status <> wf_engine.eng_completed THEN
1716: wf_engine.abortprocess(itemtype => 'IEXDELCR', itemkey => l_itemkey);
1717: wf_engine.itemstatus(itemtype => 'IEXDELCR', itemkey => l_itemkey, status => l_status, result => l_result);
1718: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1719: IEX_DEBUG_PUB.logMessage('cancel_creditHold_request_workflow: Abort process has completed and status =>' || l_status);
1720: END IF;
1721: end if;
1722: End Loop;
1723: close get_cr_itemkey;

Line 1727: IEX_DEBUG_PUB.logMessage('Credit Hold Request Workflow does not exist '||p_bankruptcy_id);

1723: close get_cr_itemkey;
1724:
1725: exception
1726: when others then
1727: IEX_DEBUG_PUB.logMessage('Credit Hold Request Workflow does not exist '||p_bankruptcy_id);
1728: null;
1729: end;
1730: -- End bug 7703313
1731:

Line 1735: IEX_DEBUG_PUB.logMessage('End cancel_strategy_and_workflow');

1731:
1732: end if;
1733: commit;
1734: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1735: IEX_DEBUG_PUB.logMessage('End cancel_strategy_and_workflow');
1736: END IF;
1737: end cancel_strategy_and_workflow;
1738: --End bug 7661724 gnramasa 8th Jan 09
1739:

Line 1762: iex_debug_pub.logmessage (' START NOTIFY_CHECK ********');

1758:
1759: BEGIN
1760:
1761: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1762: iex_debug_pub.logmessage ('**** START NOTIFY_CHECK ************');
1763: end if;
1764:
1765: if funcmode <> 'RUN' then
1766: result := wf_engine.eng_null;

Line 1775: iex_debug_pub.logmessage ('**** Bankruptcy ID ==> '||l_bankruptcy_id);

1771: itemtype => itemtype,
1772: itemkey => itemkey,
1773: aname => 'BANKRUPTCY_ID');
1774:
1775: iex_debug_pub.logmessage ('**** Bankruptcy ID ==> '||l_bankruptcy_id);
1776:
1777: OPEN c_notify(l_bankruptcy_id);
1778: FETCH c_notify INTO l_notify;
1779: CLOSE c_notify;

Line 1786: iex_debug_pub.logmessage ('**** Result ==> '||l_notify);

1782: l_result := l_notify;
1783: END IF;
1784:
1785: result := wf_engine.eng_completed ||':'||l_result;
1786: iex_debug_pub.logmessage ('**** Result ==> '||l_notify);
1787:
1788: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1789: iex_debug_pub.logmessage ('**** END NOTIFY_CHECK ************');
1790: END IF;

Line 1789: iex_debug_pub.logmessage (' END NOTIFY_CHECK ********');

1785: result := wf_engine.eng_completed ||':'||l_result;
1786: iex_debug_pub.logmessage ('**** Result ==> '||l_notify);
1787:
1788: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1789: iex_debug_pub.logmessage ('**** END NOTIFY_CHECK ************');
1790: END IF;
1791:
1792: exception
1793: when others then

Line 1794: iex_debug_pub.logmessage ('====> Exception from NOTIFY_CHECK <======');

1790: END IF;
1791:
1792: exception
1793: when others then
1794: iex_debug_pub.logmessage ('====> Exception from NOTIFY_CHECK <======');
1795: result := wf_engine.eng_completed ||':'||l_result;
1796: wf_core.context('IEX_WF_BAN_STATUS_PUB','NOTIFY_CHECK',itemtype,itemkey,to_char(actid),funcmode);
1797: raise;
1798: