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 54: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..');

50: AND a.user_id = p_user_id;
51:
52: BEGIN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..');
55: end if;
56:
57: -- Standard Start of API savepoint
58: SAVEPOINT START_WORKFLOW;

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

82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: --Start bug 3659342 by gnramasa
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..p_bankruptcy_id=' ||p_bankruptcy_id);
87: end if;
88:
89: /*
90: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

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

96: itemtype := 'IEXBANST';
97: workflowprocess := 'BANKRUPT_STATUS';
98:
99: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
100: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_user_id=' ||p_user_id);
101: end if;
102:
103: begin
104: -- Get manager

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

105: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
106: WHERE user_id = p_user_id;
107: exception
108: when others then
109: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow usernme exception');
110: end;
111:
112: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
113: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Party_id=' ||p_party_id);

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

109: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow usernme exception');
110: end;
111:
112: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
113: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Party_id=' ||p_party_id);
114: end if;
115:
116: begin
117: SELECT party_name INTO l_party_name from hz_parties

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

117: SELECT party_name INTO l_party_name from hz_parties
118: where party_id = p_party_id;
119: exception
120: when others then
121: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow party_name exception');
122: end;
123:
124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
125: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Useerid=' ||p_user_id);

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

121: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow party_name exception');
122: end;
123:
124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
125: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Useerid=' ||p_user_id);
126: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..username=' ||l_user_name);
127: end if;
128:
129: begin

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

122: end;
123:
124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
125: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..P_Useerid=' ||p_user_id);
126: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..username=' ||l_user_name);
127: end if;
128:
129: begin
130: OPEN C_MANAGER(p_user_id);

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

137: exception
138: when others then
139: l_manager_id := p_user_id;
140: l_manager_name := l_user_name;
141: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow manager exception');
142: end;
143: /*
144: select b.bankruptcy_id bankruptcy_id
145: into l_bankruptcy_id

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

147: where d.delinquency_id = b.delinquency_id
148: and d.delinquency_id = p_delinquency_id;
149: */
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..getting bankruptcy id=' ||l_user_name);
152: end if;
153:
154: /*
155: select bankruptcy_id bankruptcy_id

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

159: and DISPOSITION_CODE is NULL;
160: */
161:
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
164: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
165: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);

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

160: */
161:
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
164: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
165: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);

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

161:
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
164: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
165: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);

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

162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
164: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
165: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);

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

163: --iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||l_bankruptcy_id);
164: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
165: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);

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

164: iex_debug_pub.logmessage('IEX-4 Start Invoking BK Id..'||p_bankruptcy_id);
165: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
172: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);

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

165: iex_debug_pub.logmessage('IEX-4 Start Invoking Manager Name..'||l_manager_name);
166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
172: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
173: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);

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

166: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterID ..'||p_user_id);
167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
172: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
173: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
174: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);

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

167: iex_debug_pub.logmessage('IEX-4 Start Invoking requesterName ..'||l_user_name);
168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
172: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
173: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
174: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
175: end if;

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

168: iex_debug_pub.logmessage('IEX-4 Start Invoking DelinquencyID ..'||p_delinquency_id);
169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
172: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
173: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
174: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
175: end if;
176:

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

169: iex_debug_pub.logmessage('IEX-4 Start Invoking approverId ..'||l_manager_id);
170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
172: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
173: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
174: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
175: end if;
176:
177: wf_engine.createprocess ( itemtype => itemtype,

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

170: iex_debug_pub.logmessage('IEX-4 Start Invoking approverName ..'||l_manager_name);
171: iex_debug_pub.logmessage('IEX-4 Start Invoking partyid ..'||p_party_id);
172: iex_debug_pub.logmessage('IEX-4 Start Invoking partyName ..'||l_party_name);
173: iex_debug_pub.logmessage('IEX-4 Start Invoking ItemType ..'||itemtype);
174: iex_debug_pub.logmessage('IEX-4 Start Invoking Itemkey ..'||itemkey);
175: end if;
176:
177: wf_engine.createprocess ( itemtype => itemtype,
178: itemkey => itemkey,

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

239: itemkey => ItemKey,
240: status => l_return_status,
241: result => l_result);
242:
243: iex_debug_pub.logmessage('IEX-7 Return Status ='||l_return_status);
244:
245: if (l_return_status in ('COMPLETE', 'ACTIVE')) THEN
246: x_return_status := 'S';
247: commit;

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

325:
326: l_profile := NVL(fnd_profile.value('IEX_STRY_CREATE_BANKRUPTCY'), 'Y');
327:
328: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
329: iex_debug_pub.logmessage ('update_approval_status start');
330: iex_debug_pub.logmessage ('Profile IEX_STRY_CREATE_BANKRUPTCY == '||l_profile);
331: END IF;
332:
333: if l_profile = 'Y' then

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

326: l_profile := NVL(fnd_profile.value('IEX_STRY_CREATE_BANKRUPTCY'), 'Y');
327:
328: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
329: iex_debug_pub.logmessage ('update_approval_status start');
330: iex_debug_pub.logmessage ('Profile IEX_STRY_CREATE_BANKRUPTCY == '||l_profile);
331: END IF;
332:
333: if l_profile = 'Y' then
334:

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

353: itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'PARTY_NAME');
356: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
357: iex_debug_pub.logmessage ('update_approval_status start, before getting the bankruptcy id');
358: END IF;
359:
360: --Start bug 6359342 gnramasa 23-Aug-07
361: l_bankruptcy_id := wf_engine.GetItemAttrNumber(

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

363: itemkey => itemkey,
364: aname => 'BANKRUPTCY_ID');
365:
366: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
367: iex_debug_pub.logmessage ('update_approval_status start, after getting the bankruptcy id');
368: END IF;
369:
370: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
371: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);

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

367: iex_debug_pub.logmessage ('update_approval_status start, after getting the bankruptcy id');
368: END IF;
369:
370: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
371: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);
372: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);
373: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);
374: END IF;
375:

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

368: END IF;
369:
370: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
371: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);
372: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);
373: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);
374: END IF;
375:
376:

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

369:
370: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
371: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_delinquency_id : '||l_delinquency_id);
372: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_bankruptcy_id : '||l_bankruptcy_id);
373: iex_debug_pub.logmessage ('update_approval_status: ' || 'l_party_id : '||l_party_id);
374: END IF;
375:
376:
377: Create_strategy(

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

386: p_party_id => l_party_id
387: );
388:
389: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
390: iex_debug_pub.logmessage ('update_approval_status:'||l_return_status);
391: END IF;
392: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: RAISE L_API_ERROR;
394: END IF;

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

444: L_API_ERROR EXCEPTION;
445:
446: BEGIN
447:
448: iex_debug_pub.logmessage('IEX-Reject Bankruptcy Start ..');
449: l_api_name := 'update_rejection_status';
450: l_manager_name := wf_engine.GetItemAttrText(
451: itemtype => itemtype,
452: itemkey => itemkey,

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

466: itemtype => itemtype,
467: itemkey => itemkey,
468: aname => 'PARTY_NAME');
469:
470: iex_debug_pub.logmessage('IEX-Reject Bankruptcy partyid ..'||l_party_id);
471: -- fixed a bug 5261811
472: begin
473: update IEX_BANKRUPTCIES
474: set DISPOSITION_CODE = 'WITHDRAWN'

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

476: --and delinquency_id = l_delinquency_id
477: and disposition_code is null;
478: exception
479: when others then
480: iex_debug_pub.logmessage('IEX-Rejct Exception....');
481: null;
482: end;
483:
484: result := 'COMPLETE';

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

636: END IF;
637:
638: -- IF PG_DEBUG < 10 THEN
639: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
640: iex_debug_pub.logmessage ('set_no_contact_in_tca: ' || 'Update Contact Preference:'||l_return_status);
641: END IF;
642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
643: RAISE L_API_ERROR;
644: END IF;

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

679: x_msg_data => l_msg_data);
680:
681: -- IF PG_DEBUG < 10 THEN
682: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
683: iex_debug_pub.logmessage ('set_no_contact_in_tca: ' || 'Create Contact Preference:'||l_return_status);
684: END IF;
685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
686: RAISE L_API_ERROR;
687: END IF;

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

770: -- result := 'COMPLETE:N';
771: END IF;
772: -- IF PG_DEBUG < 10 THEN
773: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
774: iex_debug_pub.logmessage ('turnoff_collection_profile: ' || 'result =>'||result);
775: END IF;
776:
777: EXCEPTION
778: WHEN l_API_ERROR then

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

902: x_del_id_tbl => DelIdTab -- Table of Deliquencies that got created (Index correspoding to the case_id table);
903: );
904: -- IF PG_DEBUG < 10 THEN
905: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
906: iex_debug_pub.logMessage('In turnoff_collections.Create Ind Delinquency: ' ||l_return_status);
907: END IF;
908:
909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: RAISE L_API_ERROR;

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

930: X_Msg_Data => l_msg_data
931: );
932: -- IF PG_DEBUG < 10 THEN
933: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
934: iex_debug_pub.logMessage('In turnoff_collections.Create bankruptcy: ' ||l_return_status);
935: END IF;
936: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
937: RAISE L_API_ERROR;
938: END IF;

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

950: p_ObjectID => P_ObjectID);
951:
952: -- IF PG_DEBUG < 10 THEN
953: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
954: iex_debug_pub.logMessage('In turnoff_collections.Create strategy: ' ||l_return_status);
955: END IF;
956: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
957: RAISE L_API_ERROR;
958: END IF;

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

1094: x_del_id_tbl => DelIdTab -- Table of Deliquencies that got created (Index correspoding to the case_id table);
1095: );
1096: -- IF PG_DEBUG < 10 THEN
1097: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1098: iex_debug_pub.logMessage('In no_turnoff_collections.Create Ind Delinquency: ' ||l_return_status);
1099: END IF;
1100: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1101: RAISE L_API_ERROR;
1102: END IF;

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

1119: X_Msg_Data => l_msg_data
1120: );
1121: -- IF PG_DEBUG < 10 THEN
1122: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1123: iex_debug_pub.logMessage('In no_turnoff_collections.Create bankruptcy: ' ||l_return_status);
1124: END IF;
1125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1126: RAISE L_API_ERROR;
1127: END IF;

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

1138: p_ObjectType => P_ObjectType,
1139: p_ObjectID => P_ObjectID);
1140: -- IF PG_DEBUG < 10 THEN
1141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1142: iex_debug_pub.logMessage('In no_turnoff_collections.Create strategy: ' ||l_return_status);
1143: END IF;
1144: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1145: RAISE L_API_ERROR;
1146: END IF;

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

1234: from iex_bankruptcies
1235: where bankruptcy_id = p_bankruptcy_id;
1236:
1237: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1238: IEX_DEBUG_PUB.logMessage('Create_Strategy : l_disposition_code := ' ||l_disposition_code);
1239: END IF;
1240:
1241: if l_disposition_code is NULL then
1242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1239: END IF;
1240:
1241: if l_disposition_code is NULL then
1242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1243: IEX_DEBUG_PUB.logMessage('Create_Strategy : Calling IEX_STRATEGY_PUB.create_strategy');
1244: END IF;
1245: IEX_STRATEGY_PUB.create_strategy(
1246: P_Api_Version_Number => l_api_version_number,
1247: P_Init_Msg_List => l_init_msg_list,

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

1254: p_ObjectType => P_ObjectType,
1255: p_ObjectID => P_ObjectID);
1256: else
1257: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1258: IEX_DEBUG_PUB.logMessage('Start cancel_strategy_and_workflow');
1259: END IF;
1260: end if;
1261:
1262: -- Standard call to get message count and if count is 1, get message info.

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

1316: -- End bug 7703313
1317:
1318: begin
1319: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1320: IEX_DEBUG_PUB.logMessage('Start cancel_strategy_and_workflow');
1321: END IF;
1322: SAVEPOINT cancel_strategy_and_workflow;
1323:
1324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1321: END IF;
1322: SAVEPOINT cancel_strategy_and_workflow;
1323:
1324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1325: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_party_id =>' || p_party_id);
1326: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_bankruptcy_id =>' || p_bankruptcy_id);
1327: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_disposition_code =>' || p_disposition_code);
1328: END IF;
1329:

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

1322: SAVEPOINT cancel_strategy_and_workflow;
1323:
1324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1325: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_party_id =>' || p_party_id);
1326: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_bankruptcy_id =>' || p_bankruptcy_id);
1327: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_disposition_code =>' || p_disposition_code);
1328: END IF;
1329:
1330: begin

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

1323:
1324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1325: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_party_id =>' || p_party_id);
1326: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_bankruptcy_id =>' || p_bankruptcy_id);
1327: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: p_disposition_code =>' || p_disposition_code);
1328: END IF;
1329:
1330: begin
1331: open c_get_strategy_id (p_bankruptcy_id);

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

1332: fetch c_get_strategy_id into l_startegy_id;
1333: close c_get_strategy_id;
1334:
1335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1336: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: l_startegy_id =>' || l_startegy_id);
1337: END IF;
1338:
1339: exception
1340: when others then IEX_DEBUG_PUB.logMessage('exception to get strategy ID'); null;

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

1336: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: l_startegy_id =>' || l_startegy_id);
1337: END IF;
1338:
1339: exception
1340: when others then IEX_DEBUG_PUB.logMessage('exception to get strategy ID'); null;
1341: end;
1342:
1343: if l_startegy_id is not null then
1344: begin

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

1342:
1343: if l_startegy_id is not null then
1344: begin
1345: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1346: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Before calling IEX_STRATEGY_WF.SEND_SIGNAL');
1347: END IF;
1348: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',
1349: strategy_id => l_startegy_id,
1350: status => 'CANCELLED' ) ;

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

1349: strategy_id => l_startegy_id,
1350: status => 'CANCELLED' ) ;
1351:
1352: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1353: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: After calling IEX_STRATEGY_WF.SEND_SIGNAL');
1354: END IF;
1355: exception
1356: when others then
1357: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1354: END IF;
1355: exception
1356: when others then
1357: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1358: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: In others exception');
1359: END IF;
1360: Update iex_strategies set status_code = 'CANCELLED'
1361: where strategy_id = l_startegy_id;
1362:

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

1365: where strategy_id = l_startegy_id
1366: and status_code in ('PRE-WAIT','OPEN');
1367:
1368: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1369: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: End of others exception');
1370: END IF;
1371: end;
1372: end if;
1373:

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

1374: if (p_disposition_code = 'WITHDRAWN') or (p_disposition_code = 'DISMISSED') then
1375: begin
1376: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_bankruptcy_id, status => l_status, result => l_result);
1377: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1378: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Workflow status =>' || l_status);
1379: END IF;
1380:
1381: IF l_status <> wf_engine.eng_completed THEN
1382: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_bankruptcy_id);

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

1381: IF l_status <> wf_engine.eng_completed THEN
1382: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_bankruptcy_id);
1383: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_bankruptcy_id, status => l_status, result => l_result);
1384: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1385: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: Abort process has completed and status =>' || l_status);
1386: END IF;
1387:
1388: END IF;
1389: EXCEPTION

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

1386: END IF;
1387:
1388: END IF;
1389: EXCEPTION
1390: when others then IEX_DEBUG_PUB.logMessage('exception to disposition code step 1 '); null;
1391:
1392: END;
1393:
1394: -- Begin bug 7703313

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

1398: fetch get_cs_itemkey into l_itemkey;
1399: exit when get_cs_itemkey%NOTFOUND;
1400:
1401: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1402: IEX_DEBUG_PUB.logMessage('IEXDELCS Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
1403: end if;
1404:
1405: wf_engine.itemstatus(itemtype => 'IEXDELCS', itemkey => l_itemkey, status => l_status, result => l_result);
1406: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1403: end if;
1404:
1405: wf_engine.itemstatus(itemtype => 'IEXDELCS', itemkey => l_itemkey, status => l_status, result => l_result);
1406: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1407: IEX_DEBUG_PUB.logMessage('IEXDELCS Workflow Status = :: =>' || l_status||'and itemkey is...'||l_itemkey);
1408: end if;
1409:
1410: if l_status <> wf_engine.eng_completed THEN
1411: wf_engine.abortprocess(itemtype => 'IEXDELCS', itemkey => l_itemkey);

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

1410: if l_status <> wf_engine.eng_completed THEN
1411: wf_engine.abortprocess(itemtype => 'IEXDELCS', itemkey => l_itemkey);
1412: wf_engine.itemstatus(itemtype => 'IEXDELCS', itemkey => l_itemkey, status => l_status, result => l_result);
1413: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1414: IEX_DEBUG_PUB.logMessage('cancel serviceHold_workflow: Abort process has completed and status =>' || l_status);
1415: END IF;
1416: end if;
1417: End Loop;
1418: close get_cs_itemkey;

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

1418: close get_cs_itemkey;
1419:
1420: exception
1421: when others then
1422: IEX_DEBUG_PUB.logMessage('ServiceHold Workflow does not exist '||p_bankruptcy_id);
1423: null;
1424: end;
1425:
1426: begin

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

1429: fetch get_cr_itemkey into l_itemkey;
1430: exit when get_cr_itemkey%NOTFOUND;
1431:
1432: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1433: IEX_DEBUG_PUB.logMessage('IEXDELCR Workflow Status = :: =>' || l_status||'and itemkwy is ...'||l_itemkey);
1434: end if;
1435:
1436: wf_engine.itemstatus(itemtype => 'IEXDELCR', itemkey => l_itemkey, status => l_status, result => l_result);
1437: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1434: end if;
1435:
1436: wf_engine.itemstatus(itemtype => 'IEXDELCR', itemkey => l_itemkey, status => l_status, result => l_result);
1437: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1438: IEX_DEBUG_PUB.logMessage('IEXDELCR Workflow Status = :: =>' || l_status||'and itemkwy is ...'||l_itemkey);
1439: end if;
1440:
1441: if l_status <> wf_engine.eng_completed THEN
1442: wf_engine.abortprocess(itemtype => 'IEXDELCR', itemkey => l_itemkey);

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

1441: if l_status <> wf_engine.eng_completed THEN
1442: wf_engine.abortprocess(itemtype => 'IEXDELCR', itemkey => l_itemkey);
1443: wf_engine.itemstatus(itemtype => 'IEXDELCR', itemkey => l_itemkey, status => l_status, result => l_result);
1444: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1445: IEX_DEBUG_PUB.logMessage('cancel_creditHold_request_workflow: Abort process has completed and status =>' || l_status);
1446: END IF;
1447: end if;
1448: End Loop;
1449: close get_cr_itemkey;

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

1449: close get_cr_itemkey;
1450:
1451: exception
1452: when others then
1453: IEX_DEBUG_PUB.logMessage('Credit Hold Request Workflow does not exist '||p_bankruptcy_id);
1454: null;
1455: end;
1456: -- End bug 7703313
1457:

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

1457:
1458: end if;
1459: commit;
1460: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1461: IEX_DEBUG_PUB.logMessage('End cancel_strategy_and_workflow');
1462: END IF;
1463: end cancel_strategy_and_workflow;
1464: --End bug 7661724 gnramasa 8th Jan 09
1465: