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 FND_LOG

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

49: WHERE b.source_id = a.source_mgr_id
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

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

81: -- Initialize API return status to SUCCESS
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: /*

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

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

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

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);
114: end if;
115:
116: begin

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

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);
126: iex_debug_pub.logmessage('IEX Start Bankruptcy Workflow..username=' ||l_user_name);
127: end if;
128:

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

146: from iex_delinquencies d, iex_bankruptcies b
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: /*

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

158: where party_id= p_party_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);

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

324: end if;
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:

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

352: l_party_name := wf_engine.GetItemAttrNumber(
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

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

362: itemtype => itemtype,
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

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

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);
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;

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

385: p_bankruptcy_id => l_bankruptcy_id,
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;

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

635: x_msg_data => l_msg_data);
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;

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

678: x_msg_count => l_msg_count,
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;

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

769: result := wf_engine.eng_completed ||':N';
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

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

901: p_object_id_tbl => CaseIdTab, -- Table of Case Ids.
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

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

929: X_Msg_Count => l_msg_count,
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;

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

949: p_ObjectType => P_ObjectType,
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;

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

1093: p_object_id_tbl => CaseIdTab, -- Table of Case Ids.
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;

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

1118: X_Msg_Count => l_msg_count,
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;

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

1137: p_DelinquencyID => l_del_id,
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;

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

1233: into 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

Line 1242: 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
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,

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

1253: p_DelinquencyID => p_delinquency_id,
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:

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

1315: where name = 'BANKRUPTCY_ID' and number_value = c_id and item_type = 'IEXDELCS';
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:

Line 1324: 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
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;

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

1331: open c_get_strategy_id (p_bankruptcy_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

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

1341: end;
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,

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

1348: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',
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

Line 1357: 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
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;

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

1364: set status_code = 'CANCELLED'
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;

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

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

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

1380:
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;

Line 1401: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1397: Loop
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);

Line 1406: 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
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

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

1409:
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;

Line 1432: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1428: Loop
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);

Line 1437: 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
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

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

1440:
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;

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

1456: -- End bug 7703313
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

Line 1469: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1465:
1466: BEGIN
1467:
1468: G_PKG_NAME := 'IEX_WF_BAN_STATUS_PUB';
1469: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1470:
1471: END IEX_WF_BAN_STATUS_PUB;