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 696: FROM IEX_PROMISE_DETAILS

692: SELECT COUNT(CUST_ACCOUNT_ID) NUMB,
693: sum(AMOUNT_DUE_REMAINING) broken_amount,
694: sum(PROMISE_AMOUNT) promise_amount,
695: CUST_ACCOUNT_ID
696: FROM IEX_PROMISE_DETAILS
697: WHERE STATE = 'BROKEN_PROMISE'
698: AND STATUS = 'COLLECTABLE'
699: AND NVL(AMOUNT_DUE_REMAINING,0) > 0
700: GROUP BY CUST_ACCOUNT_ID;

Line 704: FROM iex_promise_details pd

700: GROUP BY CUST_ACCOUNT_ID;
701:
702: CURSOR UPDATE_IEX_ACTIVE_PRO IS
703: SELECT count(cust_account_id)active_promises,cust_account_id
704: FROM iex_promise_details pd
705: WHERE pd.state = 'BROKEN_PROMISE'
706: AND(pd.uwq_status IS NULL OR pd.uwq_status = 'ACTIVE'
707: OR(TRUNC(pd.uwq_active_date) <= TRUNC(sysdate)
708: AND pd.uwq_status = 'PENDING'))

Line 713: FROM iex_promise_details pd

709: GROUP BY CUST_ACCOUNT_ID;
710:
711: CURSOR UPDATE_IEX_COMP_PRO IS
712: SELECT count(cust_account_id)complete_promises,cust_account_id
713: FROM iex_promise_details pd
714: WHERE pd.state = 'BROKEN_PROMISE'
715: AND(pd.uwq_status = 'COMPLETE'
716: AND(TRUNC(pd.uwq_complete_date) +
717: fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate)))

Line 722: FROM iex_promise_details pd

718: GROUP BY CUST_ACCOUNT_ID;
719:
720: CURSOR UPDATE_IEX_PEND_PRO IS
721: SELECT count(cust_account_id)pending_promises,cust_account_id
722: FROM iex_promise_details pd
723: WHERE pd.state = 'BROKEN_PROMISE' AND(pd.uwq_status = 'PENDING'
724: AND(TRUNC(pd.uwq_active_date) > TRUNC(sysdate)))
725: GROUP BY CUST_ACCOUNT_ID;
726:

Line 1094: 'iex_promise_details prd ' ||

1090: 'raa.receivable_application_id ' ||
1091: 'FROM ' ||
1092: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
1093: 'IEX_prd_appl_xref pax, ' ||
1094: 'iex_promise_details prd ' ||
1095: 'WHERE ' ||
1096: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1097: 'raa.status in (''APP'', ''ACC'') and ' ||
1098: 'raa.amount_applied > 0 and ' ||

Line 1125: 'iex_promise_details prd ' ||

1121: 'raa.receivable_application_id ' ||
1122: 'FROM ' ||
1123: 'IEX_OKL_PAYMENTS_V raa, ' ||
1124: 'IEX_prd_appl_xref pax, ' ||
1125: 'iex_promise_details prd ' ||
1126: 'WHERE ' ||
1127: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1128: 'raa.amount_applied > 0 and ' ||
1129: 'raa.reversal_gl_date is not null and ' ||

Line 1147: 'iex_promise_details prd, ' ||

1143: 'pax.amount_applied, ' ||
1144: 'pax.receivable_application_id ' ||
1145: 'FROM ' ||
1146: 'IEX_prd_appl_xref pax, ' ||
1147: 'iex_promise_details prd, ' ||
1148: 'AR_SYSTEM_PARAMETERS asp ' ||--Added for bug 73237026 barathsr 31-Dec-2008
1149: 'WHERE ' ||
1150: 'pax.receivable_application_id IN (select receivable_application_id from IEX_OKL_PAYMENTS_V where ' ||
1151: 'amount_applied > 0 and ' ||

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

1256: end if;
1257:
1258: l_new_remaining_amount := l_appl_tbl(i).amount_due_remaining + l_appl_tbl(i).amount_applied;
1259: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1260: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating record in IEX_PROMISE_DETAILS with:');
1261: LogMessage(G_PKG_NAME || '.' || l_api_name || ':amount_due_remaining = ' || l_new_remaining_amount);
1262: END IF;
1263:
1264: if l_new_status is not null then

Line 1268: update IEX_PROMISE_DETAILS

1264: if l_new_status is not null then
1265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1266: LogMessage(G_PKG_NAME || '.' || l_api_name || ':status = ' || l_new_status);
1267: END IF;
1268: update IEX_PROMISE_DETAILS
1269: set status = l_new_status,
1270: amount_due_remaining = l_new_remaining_amount,
1271: last_update_date = sysdate,
1272: last_updated_by = G_USER_ID

Line 1275: update IEX_PROMISE_DETAILS

1271: last_update_date = sysdate,
1272: last_updated_by = G_USER_ID
1273: where promise_detail_id = l_appl_tbl(i).promise_detail_id;
1274: else
1275: update IEX_PROMISE_DETAILS
1276: set amount_due_remaining = l_new_remaining_amount,
1277: last_update_date = sysdate,
1278: last_updated_by = G_USER_ID
1279: where promise_detail_id = l_appl_tbl(i).promise_detail_id;

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

1287: /*
1288: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
1289: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
1290: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
1291: P_MESSAGE => 'Failed to update record in IEX_PROMISE_DETAILS for promise_detail_id = ' || l_appl_tbl(i).promise_detail_id);
1292: */
1293: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1294: else
1295: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1462: 'iex_promise_details prd, ' ||

1458: 'PRD.amount_due_remaining, ' ||
1459: 'PRD.delinquency_id, ' ||
1460: 'DEL.payment_schedule_id ' ||
1461: 'FROM ' ||
1462: 'iex_promise_details prd, ' ||
1463: 'iex_delinquencies del ' ||
1464: 'WHERE ' ||
1465: 'prd.delinquency_id is not null and ' ||
1466: 'del.delinquency_id = prd.delinquency_id and ' ||

Line 1534: UPDATE iex_promise_details

1530: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1531: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Updating all COLLECTABLE and PENDING promises for delinquencies that have status CURRENT to status FULFILLED ...');
1532: END IF;
1533:
1534: UPDATE iex_promise_details
1535: SET STATUS = 'FULFILLED',
1536: last_update_date = sysdate,
1537: last_updated_by = G_USER_ID
1538: WHERE

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

1537: last_updated_by = G_USER_ID
1538: WHERE
1539: promise_detail_id in
1540: (select prd.promise_detail_id
1541: from iex_promise_details prd, iex_delinquencies del, ar_payment_schedules aps --added for Bug 6446848 08-Dec-2008 barathsr
1542: where prd.delinquency_id is not null and
1543: prd.delinquency_id = del.delinquency_id and
1544: prd.org_id = del.org_id and --Added for bug 7237026 barathsr 31-Dec-2008
1545: del.payment_schedule_id=aps.payment_schedule_id and --added for Bug 6446848 08-Dec-2008 barathsr

Line 1567: 'iex_promise_details prd,' ||

1563: 'PRD.promise_amount, ' ||
1564: 'PRD.amount_due_remaining, ' ||
1565: 'PRD.cust_account_id ' ||
1566: 'FROM ' ||
1567: 'iex_promise_details prd,' ||
1568: 'AR_SYSTEM_PARAMETERS asp ' || --Added for bug 7237026 barathsr 31-Dec-2008
1569: 'WHERE ' ||
1570: 'prd.delinquency_id is null and ' ||
1571: 'prd.CNSLD_INVOICE_ID is null and ' ||

Line 1646: 'iex_promise_details prd, ' ||

1642: 'PRD.promise_amount, ' ||
1643: 'PRD.amount_due_remaining, ' ||
1644: 'PRD.contract_id ' ||
1645: 'FROM ' ||
1646: 'iex_promise_details prd, ' ||
1647: 'AR_SYSTEM_PARAMETERS asp ' || --Added for bug 7237026 barathsr 31-Dec-2008
1648: 'WHERE ' ||
1649: 'prd.contract_id is not null and ' ||
1650: 'prd.status = ''COLLECTABLE'' and ' ||

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

2284: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2285: LogMessage(G_PKG_NAME || '.' || l_api_name || '......................');
2286: LogMessage(G_PKG_NAME || '.' || l_api_name || ':will set promise status to ' || l_status);
2287: LogMessage(G_PKG_NAME || '.' || l_api_name || ':will set promise state to ' || l_state);
2288: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Updating iex_promise_details with promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID || ' set:');
2289: LogMessage(G_PKG_NAME || '.' || l_api_name || ':amount_due_remaining ' || P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING);
2290: END IF;
2291:
2292: if l_callback_date is not null then

Line 2293: UPDATE iex_promise_details

2289: LogMessage(G_PKG_NAME || '.' || l_api_name || ':amount_due_remaining ' || P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING);
2290: END IF;
2291:
2292: if l_callback_date is not null then
2293: UPDATE iex_promise_details
2294: SET amount_due_remaining = P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING,
2295: STATUS = l_status,
2296: STATE = l_state,
2297: CALLBACK_CREATED_YN = 'N',

Line 2303: UPDATE iex_promise_details

2299: last_update_date = sysdate,
2300: last_updated_by = G_USER_ID
2301: WHERE promise_detail_id = P_PROMISES_TBL(i).PROMISE_DETAIL_ID;
2302: else
2303: UPDATE iex_promise_details
2304: SET amount_due_remaining = P_PROMISES_TBL(i).AMOUNT_DUE_REMAINING,
2305: STATUS = l_status,
2306: STATE = l_state,
2307: last_update_date = sysdate,

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

2310: end if;
2311:
2312: if (sql%notfound) then
2313: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2314: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Failed to update iex_promise_details');
2315: END IF;
2316: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2317: /*
2318: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

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

2317: /*
2318: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
2319: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
2320: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
2321: P_MESSAGE => 'Failed to update iex_promise_details');
2322: */
2323: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2324: else
2325: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2412: UPDATE iex_promise_details

2408: l_state := 'BROKEN_PROMISE';
2409: Get_Callback_Date(p_promise_date => P_PROMISES_TBL(i).PROMISE_DATE, x_callback_date => l_callback_date);
2410:
2411: if l_callback_date is not null then
2412: UPDATE iex_promise_details
2413: SET state = l_state,
2414: CALLBACK_CREATED_YN = 'N',
2415: CALLBACK_DATE = l_callback_date,
2416: last_update_date = sysdate,

Line 2420: UPDATE iex_promise_details

2416: last_update_date = sysdate,
2417: last_updated_by = G_USER_ID
2418: WHERE promise_detail_id = P_PROMISES_TBL(i).PROMISE_DETAIL_ID;
2419: else
2420: UPDATE iex_promise_details
2421: SET state = l_state,
2422: last_update_date = sysdate,
2423: last_updated_by = G_USER_ID
2424: WHERE promise_detail_id = P_PROMISES_TBL(i).PROMISE_DETAIL_ID;

Line 2429: 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);

2425: end if;
2426:
2427: if (sql%notfound) then
2428: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2429: 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);
2430: END IF;
2431: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2432: /*
2433: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

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

2432: /*
2433: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
2434: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
2435: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
2436: P_MESSAGE => 'Failed to update iex_promise_details with STATUS = BROKEN for promise_detail_id = ' || P_PROMISES_TBL(i).PROMISE_DETAIL_ID);
2437: */
2438: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2439: else
2440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2655: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies_all idel

2651: pro.resource_id,
2652: pro.cust_account_id,
2653: idel.customer_site_use_id,
2654: idel.delinquency_id
2655: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies_all idel
2656: WHERE
2657: pro.cust_account_id = hca.cust_account_id
2658: AND idel.delinquency_id(+) = pro.delinquency_id
2659: AND pro.state = 'BROKEN_PROMISE'

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

2708: and tsk.task_status_id=st.task_status_id
2709: and nvl(st.closed_flag, 'N') <>'Y'
2710: and nvl(st.cancelled_flag, 'N')<>'Y'
2711: and nvl(st.completed_flag, 'N')<>'Y'
2712: and exists(select 1 from iex_promise_details prd where tsk.source_object_id = prd.promise_detail_id
2713: and prd.status<>'COLLECTABLE');
2714: l_obj_version_number number;
2715: --End bug 7317666 21-Nov-2008 barathsr
2716:

Line 2862: -- update iex_promise_details table

2858: END IF;
2859:
2860: END IF;
2861:
2862: -- update iex_promise_details table
2863: UPDATE iex_promise_details
2864: SET CALLBACK_CREATED_YN = 'Y',
2865: last_update_date = sysdate,
2866: last_updated_by = G_USER_ID

Line 2863: UPDATE iex_promise_details

2859:
2860: END IF;
2861:
2862: -- update iex_promise_details table
2863: UPDATE iex_promise_details
2864: SET CALLBACK_CREATED_YN = 'Y',
2865: last_update_date = sysdate,
2866: last_updated_by = G_USER_ID
2867: WHERE promise_detail_id = l_promise_detail_id;

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

2874: /*
2875: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
2876: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
2877: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
2878: P_MESSAGE => 'Failed to update iex_promise_details for promise_detail_id = ' || l_promise_detail_id);
2879: */
2880: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2881: else
2882: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3062: 'IEX_PROMISE_DETAILS ' ||

3058:
3059: vSQL := 'SELECT ' ||
3060: 'PROMISE_DETAIL_ID, PROMISE_DATE ' ||
3061: 'FROM ' ||
3062: 'IEX_PROMISE_DETAILS ' ||
3063: 'WHERE ' ||
3064: 'DELINQUENCY_ID is not null and ' ||
3065: 'DELINQUENCY_ID = :del and ' ||
3066: 'STATUS = ''CLOSED'' ' ||

Line 3092: UPDATE iex_promise_details

3088: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3089: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: updating promise ' || l_promise_id || ' with status BROKEN');
3090: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: callback date ' || l_callback_date);
3091: END IF;
3092: UPDATE iex_promise_details
3093: SET STATUS = 'BROKEN',
3094: CALLBACK_CREATED_YN = 'N',
3095: CALLBACK_DATE = l_callback_date,
3096: last_update_date = sysdate,

Line 3103: UPDATE iex_promise_details

3099: else
3100: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3101: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: updating promise ' || l_promise_id || ' with status OPEN');
3102: END IF;
3103: UPDATE iex_promise_details
3104: SET STATUS = 'OPEN',
3105: last_update_date = sysdate,
3106: last_updated_by = G_USER_ID
3107: WHERE promise_detail_id = l_promise_id;

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

3114: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3115: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3116: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3117: -- P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
3118: -- P_MESSAGE => 'Failed to update iex_promise_details for promise_detail_id = ' || l_promise_id);
3119: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3120: else
3121: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3122: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: update of promise ' || l_promise_id || ' succeeded');