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_PROMISES_BATCH_PUB dependencies on IEX_PROMISE_DETAILS

Line 146: IEX_PROMISE_DETAILS PRD,

142: IS
143: SELECT
144: PRD.PROMISE_DETAIL_ID
145: FROM
146: IEX_PROMISE_DETAILS PRD,
147: IEX_DELINQUENCIES_ALL DEL
148: WHERE
149: DEL.DELINQUENCY_ID = PRD.DELINQUENCY_ID AND
150: DEL.CUST_ACCOUNT_ID = PRD.CUST_ACCOUNT_ID AND

Line 225: UPDATE iex_promise_details

221:
222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
223: LogMessage(G_PKG_NAME || '.' || l_api_name || ':going to update promise ' || l_promise_detail_id || ' with status CLOSED');
224: END IF;
225: UPDATE iex_promise_details
226: SET STATUS = 'CLOSED',
227: last_update_date = sysdate,
228: last_updated_by = G_USER_ID
229: WHERE promise_detail_id = l_promise_detail_id;

Line 240: -- P_MESSAGE => 'Failed to update iex_promise_details with STATUS = CLOSED for promise_detail_id = ' || l_promise_detail_id);

236: /*
237: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
238: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
239: -- P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
240: -- P_MESSAGE => 'Failed to update iex_promise_details with STATUS = CLOSED for promise_detail_id = ' || l_promise_detail_id);
241:
242: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
243: else
244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 405: 'IEX_PROMISE_DETAILS ' ||

401:
402: vSQL := 'SELECT ' ||
403: 'PROMISE_DETAIL_ID, status, ''Invoice'' ' ||
404: 'FROM ' ||
405: 'IEX_PROMISE_DETAILS ' ||
406: 'WHERE ' ||
407: 'DELINQUENCY_ID = :del and ' ||
408: 'STATUS in (''OPEN'', ''PENDING'', ''BROKEN'') ' ||
409: 'union ' ||

Line 414: 'IEX_PROMISE_DETAILS PRD, ' ||

410: 'SELECT ' ||
411: 'PRD.PROMISE_DETAIL_ID, prd.status, ''Case'' ' ||
412: 'FROM ' ||
413: 'IEX_CASE_OBJECTS CAO, ' ||
414: 'IEX_PROMISE_DETAILS PRD, ' ||
415: 'IEX_DELINQUENCIES DEL ' ||
416: 'WHERE ' ||
417: 'DEL.DELINQUENCY_ID = :del AND ' ||
418: 'DEL.CASE_ID IS NOT NULL AND ' ||

Line 470: UPDATE iex_promise_details

466: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
467: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: updating open/pending promises...');
468: END IF;
469: FORALL n in 1..l_cl_prd_count
470: UPDATE iex_promise_details
471: SET STATUS = 'CLOSED',
472: last_update_date = sysdate,
473: last_updated_by = G_USER_ID
474: WHERE promise_detail_id = l_promise_ids_tbl(n);

Line 483: UPDATE iex_promise_details

479: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
480: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: updating broken promises...');
481: END IF;
482: FORALL n in 1..l_cl_prd_count
483: UPDATE iex_promise_details
484: SET UWQ_STATUS = 'COMPLETE',
485: UWQ_COMPLETE_DATE = sysdate,
486: last_update_date = sysdate,
487: last_updated_by = G_USER_ID

Line 615: FROM iex_promise_details a,

611: sum(decode(a.status, 'COLLECTABLE', a.promise_amount, 0)) promise_amount,
612: d.party_cust_id party_cust_id,
613: a.cust_account_id cust_account_id,
614: d.customer_site_use_id customer_site_use_id
615: FROM iex_promise_details a,
616: iex_delinquencies d--_all d --Changed for bug 7237026 20-Jan-2009 barathsr
617: WHERE a.delinquency_id=d.delinquency_id
618: AND a.state = 'BROKEN_PROMISE'
619: AND a.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')

Line 621: AND EXISTS (SELECT 1 FROM iex_promise_details b

617: WHERE a.delinquency_id=d.delinquency_id
618: AND a.state = 'BROKEN_PROMISE'
619: AND a.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')
620: AND a.org_id = d.org_id --Added for bug 7237026 31-Dec-2008 barathsr
621: AND EXISTS (SELECT 1 FROM iex_promise_details b
622: where TRUNC(b.last_update_date)=TRUNC(SYSDATE) AND a.cust_account_id = b.cust_account_id)
623: GROUP BY d.party_cust_id,
624: a.cust_account_id,
625: d.customer_site_use_id;

Line 633: FROM iex_promise_details pd,

629: SELECT sum(decode(pd.status, 'COLLECTABLE', 1, 0)) active_promises,
630: d.party_cust_id party_cust_id,
631: pd.cust_account_id cust_account_id,
632: d.customer_site_use_id customer_site_use_id
633: FROM iex_promise_details pd,
634: iex_delinquencies d--_all d --Changed for bug 7237026 20-Jan-2009 barathsr
635: WHERE pd.delinquency_id=d.delinquency_id
636: AND pd.state = 'BROKEN_PROMISE'
637: AND pd.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')

Line 639: AND EXISTS (SELECT 1 FROM iex_promise_details b

635: WHERE pd.delinquency_id=d.delinquency_id
636: AND pd.state = 'BROKEN_PROMISE'
637: AND pd.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')
638: AND pd.org_id =d.org_id --Added for bug 7237026 31-Dec-2008 barathsr
639: AND EXISTS (SELECT 1 FROM iex_promise_details b
640: where TRUNC(b.last_update_date)=TRUNC(SYSDATE) AND pd.cust_account_id = b.cust_account_id)
641: AND(pd.uwq_status IS NULL OR pd.uwq_status = 'ACTIVE'
642: OR(TRUNC(pd.uwq_active_date) <= TRUNC(sysdate)
643: AND pd.uwq_status = 'PENDING'))

Line 654: FROM iex_promise_details pd,

650: SELECT sum(decode(pd.status, 'COLLECTABLE', 1, 0)) complete_promises,
651: d.party_cust_id party_cust_id,
652: pd.cust_account_id cust_account_id,
653: d.customer_site_use_id customer_site_use_id
654: FROM iex_promise_details pd,
655: iex_delinquencies d--_all d --Changed for bug 7237026 20-Jan-2009 barathsr
656: WHERE pd.delinquency_id=d.delinquency_id
657: AND pd.state = 'BROKEN_PROMISE'
658: AND pd.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')

Line 660: AND EXISTS (SELECT 1 FROM iex_promise_details b

656: WHERE pd.delinquency_id=d.delinquency_id
657: AND pd.state = 'BROKEN_PROMISE'
658: AND pd.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')
659: AND pd.org_id = d.org_id --Added for bug 7237026 31-Dec-2008 barathsr
660: AND EXISTS (SELECT 1 FROM iex_promise_details b
661: where TRUNC(b.last_update_date)=TRUNC(SYSDATE) AND pd.cust_account_id = b.cust_account_id)
662: AND(pd.uwq_status = 'COMPLETE'
663: AND(TRUNC(pd.uwq_complete_date) +
664: fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate)))

Line 675: FROM iex_promise_details pd,

671: SELECT sum(decode(pd.status, 'COLLECTABLE', 1, 0)) pending_promises,
672: d.party_cust_id party_cust_id,
673: pd.cust_account_id cust_account_id,
674: d.customer_site_use_id customer_site_use_id
675: FROM iex_promise_details pd,
676: iex_delinquencies d--_all d --Changed for bug 7237026 20-Jan-2009 barathsr
677: WHERE pd.delinquency_id=d.delinquency_id
678: AND pd.state = 'BROKEN_PROMISE'
679: AND pd.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')

Line 681: AND EXISTS (SELECT 1 FROM iex_promise_details b

677: WHERE pd.delinquency_id=d.delinquency_id
678: AND pd.state = 'BROKEN_PROMISE'
679: AND pd.status in ('COLLECTABLE','FULFILLED', 'CANCELLED')
680: AND pd.org_id = d.org_id --Added for bug 7237026 31-Dec-2008 barathsr
681: AND EXISTS (SELECT 1 FROM iex_promise_details b
682: where TRUNC(b.last_update_date)=TRUNC(SYSDATE) AND pd.cust_account_id = b.cust_account_id)
683: AND (pd.uwq_status = 'PENDING'
684: AND(TRUNC(pd.uwq_active_date) > TRUNC(sysdate)))
685: GROUP BY d.party_cust_id,

Line 694: from iex_promise_details pd,

690: /*
691: CURSOR UPDATE_NOT_FULLY_PRO_DEL
692: IS
693: SELECT pd.delinquency_id delinquency_id
694: from iex_promise_details pd,
695: iex_delinquencies d
696: where pd.delinquency_id = d.delinquency_id
697: AND pd.status = 'COLLECTABLE'
698: AND pd.state = 'PROMISE'

Line 709: from iex_promise_details pd,

705:
706: CURSOR UPDATE_FULLY_PRO_DEL
707: IS
708: SELECT pd.delinquency_id delinquency_id
709: from iex_promise_details pd,
710: iex_delinquencies d
711: where pd.delinquency_id = d.delinquency_id
712: AND pd.status = 'COLLECTABLE'
713: AND pd.state = 'PROMISE'

Line 724: from iex_promise_details pd

720: */
721: CURSOR UPDATE_PRO_DEL
722: IS
723: SELECT promise_detail_id
724: from iex_promise_details pd
725: where status = 'COLLECTABLE';
726: /*
727: -- Start bug#5874874 gnramasa 25-Apr-07
728:

Line 734: FROM IEX_PROMISE_DETAILS

730: SELECT COUNT(CUST_ACCOUNT_ID) NUMB,
731: sum(AMOUNT_DUE_REMAINING) broken_amount,
732: sum(PROMISE_AMOUNT) promise_amount,
733: CUST_ACCOUNT_ID
734: FROM IEX_PROMISE_DETAILS
735: WHERE STATE = 'BROKEN_PROMISE'
736: AND STATUS = 'COLLECTABLE'
737: AND NVL(AMOUNT_DUE_REMAINING,0) > 0
738: GROUP BY CUST_ACCOUNT_ID;

Line 742: FROM iex_promise_details pd

738: GROUP BY CUST_ACCOUNT_ID;
739:
740: CURSOR UPDATE_IEX_ACTIVE_PRO IS
741: SELECT count(cust_account_id)active_promises,cust_account_id
742: FROM iex_promise_details pd
743: WHERE pd.state = 'BROKEN_PROMISE'
744: AND(pd.uwq_status IS NULL OR pd.uwq_status = 'ACTIVE'
745: OR(TRUNC(pd.uwq_active_date) <= TRUNC(sysdate)
746: AND pd.uwq_status = 'PENDING'))

Line 751: FROM iex_promise_details pd

747: GROUP BY CUST_ACCOUNT_ID;
748:
749: CURSOR UPDATE_IEX_COMP_PRO IS
750: SELECT count(cust_account_id)complete_promises,cust_account_id
751: FROM iex_promise_details pd
752: WHERE pd.state = 'BROKEN_PROMISE'
753: AND(pd.uwq_status = 'COMPLETE'
754: AND(TRUNC(pd.uwq_complete_date) +
755: fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate)))

Line 760: FROM iex_promise_details pd

756: GROUP BY CUST_ACCOUNT_ID;
757:
758: CURSOR UPDATE_IEX_PEND_PRO IS
759: SELECT count(cust_account_id)pending_promises,cust_account_id
760: FROM iex_promise_details pd
761: WHERE pd.state = 'BROKEN_PROMISE' AND(pd.uwq_status = 'PENDING'
762: AND(TRUNC(pd.uwq_active_date) > TRUNC(sysdate)))
763: GROUP BY CUST_ACCOUNT_ID;
764:

Line 1208: 'iex_promise_details prd ' ||

1204: 'raa.receivable_application_id ' ||
1205: 'FROM ' ||
1206: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
1207: 'IEX_prd_appl_xref pax, ' ||
1208: 'iex_promise_details prd ' ||
1209: 'WHERE ' ||
1210: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1211: 'raa.status in (''APP'', ''ACC'') and ' ||
1212: 'raa.amount_applied > 0 and ' ||

Line 1239: 'iex_promise_details prd ' ||

1235: 'raa.receivable_application_id ' ||
1236: 'FROM ' ||
1237: 'IEX_OKL_PAYMENTS_V raa, ' ||
1238: 'IEX_prd_appl_xref pax, ' ||
1239: 'iex_promise_details prd ' ||
1240: 'WHERE ' ||
1241: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1242: 'raa.amount_applied > 0 and ' ||
1243: 'raa.reversal_gl_date is not null and ' ||

Line 1261: 'iex_promise_details prd, ' ||

1257: 'pax.amount_applied, ' ||
1258: 'pax.receivable_application_id ' ||
1259: 'FROM ' ||
1260: 'IEX_prd_appl_xref pax, ' ||
1261: 'iex_promise_details prd, ' ||
1262: 'AR_SYSTEM_PARAMETERS asp ' ||--Added for bug 73237026 barathsr 31-Dec-2008
1263: 'WHERE ' ||
1264: 'pax.receivable_application_id IN (select receivable_application_id from IEX_OKL_PAYMENTS_V where ' ||
1265: 'amount_applied > 0 and ' ||

Line 1374: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating record in IEX_PROMISE_DETAILS with:');

1370: end if;
1371:
1372: l_new_remaining_amount := l_appl_tbl(i).amount_due_remaining + l_appl_tbl(i).amount_applied;
1373: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1374: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating record in IEX_PROMISE_DETAILS with:');
1375: LogMessage(G_PKG_NAME || '.' || l_api_name || ':amount_due_remaining = ' || l_new_remaining_amount);
1376: END IF;
1377:
1378: if l_new_status is not null then

Line 1382: update IEX_PROMISE_DETAILS

1378: if l_new_status is not null then
1379: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1380: LogMessage(G_PKG_NAME || '.' || l_api_name || ':status = ' || l_new_status);
1381: END IF;
1382: update IEX_PROMISE_DETAILS
1383: set status = l_new_status,
1384: amount_due_remaining = l_new_remaining_amount,
1385: last_update_date = sysdate,
1386: last_updated_by = G_USER_ID

Line 1389: update IEX_PROMISE_DETAILS

1385: last_update_date = sysdate,
1386: last_updated_by = G_USER_ID
1387: where promise_detail_id = l_appl_tbl(i).promise_detail_id;
1388: else
1389: update IEX_PROMISE_DETAILS
1390: set amount_due_remaining = l_new_remaining_amount,
1391: last_update_date = sysdate,
1392: last_updated_by = G_USER_ID
1393: where promise_detail_id = l_appl_tbl(i).promise_detail_id;

Line 1405: P_MESSAGE => 'Failed to update record in IEX_PROMISE_DETAILS for promise_detail_id = ' || l_appl_tbl(i).promise_detail_id);

1401: /*
1402: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
1403: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
1404: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
1405: P_MESSAGE => 'Failed to update record in IEX_PROMISE_DETAILS for promise_detail_id = ' || l_appl_tbl(i).promise_detail_id);
1406: */
1407: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1408: else
1409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1602: 'iex_promise_details prd, ' ||

1598: 'PRD.amount_due_remaining, ' ||
1599: 'PRD.delinquency_id, ' ||
1600: 'DEL.payment_schedule_id ' ||
1601: 'FROM ' ||
1602: 'iex_promise_details prd, ' ||
1603: 'iex_delinquencies del ' ||
1604: 'WHERE ' ||
1605: 'prd.delinquency_id is not null and ' ||
1606: 'del.delinquency_id = prd.delinquency_id and ' ||

Line 1674: UPDATE iex_promise_details

1670: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1671: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Updating all COLLECTABLE and PENDING promises for delinquencies that have status CURRENT to status FULFILLED ...');
1672: END IF;
1673:
1674: UPDATE iex_promise_details
1675: SET STATUS = 'FULFILLED',
1676: last_update_date = sysdate,
1677: last_updated_by = G_USER_ID
1678: WHERE

Line 1681: from iex_promise_details prd, iex_delinquencies del, ar_payment_schedules aps --added for Bug 6446848 08-Dec-2008 barathsr

1677: last_updated_by = G_USER_ID
1678: WHERE
1679: promise_detail_id in
1680: (select prd.promise_detail_id
1681: from iex_promise_details prd, iex_delinquencies del, ar_payment_schedules aps --added for Bug 6446848 08-Dec-2008 barathsr
1682: where prd.delinquency_id is not null and
1683: prd.delinquency_id = del.delinquency_id and
1684: prd.org_id = del.org_id and --Added for bug 7237026 barathsr 31-Dec-2008
1685: del.payment_schedule_id=aps.payment_schedule_id and --added for Bug 6446848 08-Dec-2008 barathsr

Line 1707: 'iex_promise_details prd,' ||

1703: 'PRD.promise_amount, ' ||
1704: 'PRD.amount_due_remaining, ' ||
1705: 'PRD.cust_account_id ' ||
1706: 'FROM ' ||
1707: 'iex_promise_details prd,' ||
1708: 'AR_SYSTEM_PARAMETERS asp ' || --Added for bug 7237026 barathsr 31-Dec-2008
1709: 'WHERE ' ||
1710: 'prd.delinquency_id is null and ' ||
1711: 'prd.CNSLD_INVOICE_ID is null and ' ||

Line 1786: 'iex_promise_details prd, ' ||

1782: 'PRD.promise_amount, ' ||
1783: 'PRD.amount_due_remaining, ' ||
1784: 'PRD.contract_id ' ||
1785: 'FROM ' ||
1786: 'iex_promise_details prd, ' ||
1787: 'AR_SYSTEM_PARAMETERS asp ' || --Added for bug 7237026 barathsr 31-Dec-2008
1788: 'WHERE ' ||
1789: 'prd.contract_id is not null and ' ||
1790: 'prd.status = ''COLLECTABLE'' and ' ||

Line 2428: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Updating iex_promise_details with promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID || ' set:');

2424: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2425: LogMessage(G_PKG_NAME || '.' || l_api_name || '......................');
2426: LogMessage(G_PKG_NAME || '.' || l_api_name || ':will set promise status to ' || l_status);
2427: LogMessage(G_PKG_NAME || '.' || l_api_name || ':will set promise state to ' || l_state);
2428: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Updating iex_promise_details with promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID || ' set:');
2429: LogMessage(G_PKG_NAME || '.' || l_api_name || ':amount_due_remaining ' || P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING);
2430: END IF;
2431:
2432: if l_callback_date is not null then

Line 2433: UPDATE iex_promise_details

2429: LogMessage(G_PKG_NAME || '.' || l_api_name || ':amount_due_remaining ' || P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING);
2430: END IF;
2431:
2432: if l_callback_date is not null then
2433: UPDATE iex_promise_details
2434: SET amount_due_remaining = P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING,
2435: STATUS = l_status,
2436: STATE = l_state,
2437: CALLBACK_CREATED_YN = 'N',

Line 2443: UPDATE iex_promise_details

2439: last_update_date = sysdate,
2440: last_updated_by = G_USER_ID
2441: WHERE promise_detail_id = P_PROMISES_TBL(i).PROMISE_DETAIL_ID;
2442: else
2443: UPDATE iex_promise_details
2444: SET amount_due_remaining = P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING,
2445: STATUS = l_status,
2446: STATE = l_state,
2447: last_update_date = sysdate,

Line 2454: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Failed to update iex_promise_details');

2450: end if;
2451:
2452: if (sql%notfound) then
2453: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2454: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Failed to update iex_promise_details');
2455: END IF;
2456: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2457: /*
2458: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2461: P_MESSAGE => 'Failed to update iex_promise_details');

2457: /*
2458: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
2459: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
2460: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
2461: P_MESSAGE => 'Failed to update iex_promise_details');
2462: */
2463: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2464: else
2465: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2552: UPDATE iex_promise_details

2548: l_state := 'BROKEN_PROMISE';
2549: Get_Callback_Date(p_promise_date => P_PROMISES_TBL(i).PROMISE_DATE, x_callback_date => l_callback_date);
2550:
2551: if l_callback_date is not null then
2552: UPDATE iex_promise_details
2553: SET state = l_state,
2554: CALLBACK_CREATED_YN = 'N',
2555: CALLBACK_DATE = l_callback_date,
2556: last_update_date = sysdate,

Line 2560: UPDATE iex_promise_details

2556: last_update_date = sysdate,
2557: last_updated_by = G_USER_ID
2558: WHERE promise_detail_id = P_PROMISES_TBL(i).PROMISE_DETAIL_ID;
2559: else
2560: UPDATE iex_promise_details
2561: SET state = l_state,
2562: last_update_date = sysdate,
2563: last_updated_by = G_USER_ID
2564: WHERE promise_detail_id = P_PROMISES_TBL(i).PROMISE_DETAIL_ID;

Line 2569: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Failed to update iex_promise_details with STATUS = BROKEN for promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID);

2565: end if;
2566:
2567: if (sql%notfound) then
2568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2569: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Failed to update iex_promise_details with STATUS = BROKEN for promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID);
2570: END IF;
2571: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2572: /*
2573: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2576: P_MESSAGE => 'Failed to update iex_promise_details with STATUS = BROKEN for promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID);

2572: /*
2573: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
2574: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
2575: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
2576: P_MESSAGE => 'Failed to update iex_promise_details with STATUS = BROKEN for promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID);
2577: */
2578: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2579: else
2580: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2801: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies idel

2797: pro.resource_id,
2798: pro.cust_account_id,
2799: idel.customer_site_use_id,
2800: idel.delinquency_id
2801: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies idel
2802: WHERE
2803: pro.cust_account_id = hca.cust_account_id
2804: AND idel.delinquency_id(+) = pro.delinquency_id
2805: AND pro.status = 'COLLECTABLE'

Line 2859: and exists(select 1 from iex_promise_details prd where tsk.source_object_id = prd.promise_detail_id

2855: and tsk.task_status_id=st.task_status_id
2856: and nvl(st.closed_flag, 'N') <>'Y'
2857: and nvl(st.cancelled_flag, 'N')<>'Y'
2858: and nvl(st.completed_flag, 'N')<>'Y'
2859: and exists(select 1 from iex_promise_details prd where tsk.source_object_id = prd.promise_detail_id
2860: and prd.status<>'COLLECTABLE');
2861: l_obj_version_number number;
2862: --End bug 7317666 21-Nov-2008 barathsr
2863: --fix start for bug 14036760 by sunagesh on 08-05-12

Line 3039: -- update iex_promise_details table

3035: END IF;
3036:
3037: END IF;
3038:
3039: -- update iex_promise_details table
3040: UPDATE iex_promise_details
3041: SET CALLBACK_CREATED_YN = 'Y',
3042: last_update_date = sysdate,
3043: last_updated_by = G_USER_ID

Line 3040: UPDATE iex_promise_details

3036:
3037: END IF;
3038:
3039: -- update iex_promise_details table
3040: UPDATE iex_promise_details
3041: SET CALLBACK_CREATED_YN = 'Y',
3042: last_update_date = sysdate,
3043: last_updated_by = G_USER_ID
3044: WHERE promise_detail_id = l_promise_detail_id;

Line 3055: P_MESSAGE => 'Failed to update iex_promise_details for promise_detail_id = ' || l_promise_detail_id);

3051: /*
3052: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3053: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3054: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
3055: P_MESSAGE => 'Failed to update iex_promise_details for promise_detail_id = ' || l_promise_detail_id);
3056: */
3057: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3058: else
3059: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3239: 'IEX_PROMISE_DETAILS ' ||

3235:
3236: vSQL := 'SELECT ' ||
3237: 'PROMISE_DETAIL_ID, PROMISE_DATE ' ||
3238: 'FROM ' ||
3239: 'IEX_PROMISE_DETAILS ' ||
3240: 'WHERE ' ||
3241: 'DELINQUENCY_ID is not null and ' ||
3242: 'DELINQUENCY_ID = :del and ' ||
3243: 'STATUS = ''CLOSED'' ' ||

Line 3269: UPDATE iex_promise_details

3265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3266: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: updating promise ' || l_promise_id || ' with status BROKEN');
3267: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: callback date ' || l_callback_date);
3268: END IF;
3269: UPDATE iex_promise_details
3270: SET STATUS = 'BROKEN',
3271: CALLBACK_CREATED_YN = 'N',
3272: CALLBACK_DATE = l_callback_date,
3273: last_update_date = sysdate,

Line 3280: UPDATE iex_promise_details

3276: else
3277: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3278: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: updating promise ' || l_promise_id || ' with status OPEN');
3279: END IF;
3280: UPDATE iex_promise_details
3281: SET STATUS = 'OPEN',
3282: last_update_date = sysdate,
3283: last_updated_by = G_USER_ID
3284: WHERE promise_detail_id = l_promise_id;

Line 3295: -- P_MESSAGE => 'Failed to update iex_promise_details for promise_detail_id = ' || l_promise_id);

3291: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3292: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3293: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3294: -- P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
3295: -- P_MESSAGE => 'Failed to update iex_promise_details for promise_detail_id = ' || l_promise_id);
3296: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3297: else
3298: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3299: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: update of promise ' || l_promise_id || ' succeeded');