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_DUNNING_PVT dependencies on IEX_DUNNINGS_PKG

Line 2571: IEX_Dunnings_PKG.insert_row(

2567: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.dunning_mode :'||l_dunning_rec.dunning_mode);
2568: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.confirmation_mode : '||l_dunning_rec.confirmation_mode);
2569: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.parent_dunning_id : '||l_dunning_rec.parent_dunning_id);
2570: -- Create Dunning
2571: IEX_Dunnings_PKG.insert_row(
2572: px_rowid => l_rowid
2573: , px_dunning_id => x_dunning_id
2574: , p_last_update_date => sysdate
2575: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 2870: IEX_Dunnings_PKG.insert_staged_dunning_row(

2866: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
2867: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
2868: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
2869:
2870: IEX_Dunnings_PKG.insert_staged_dunning_row(
2871: px_rowid => l_rowid
2872: , px_dunning_trx_id => x_dunning_trx_id
2873: , p_dunning_id => p_dunning_id
2874: , p_cust_trx_id => l_transaction_id

Line 2942: IEX_Dunnings_PKG.insert_staged_dunning_row(

2938: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_delinquency_id :'||l_delinquency_id);
2939: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_transaction_id :'||l_transaction_id);
2940: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_payment_schedule_id : '||l_payment_schedule_id);
2941:
2942: IEX_Dunnings_PKG.insert_staged_dunning_row(
2943: px_rowid => l_rowid
2944: , px_dunning_trx_id => x_dunning_trx_id
2945: , p_dunning_id => p_dunning_id
2946: , p_cust_trx_id => l_transaction_id

Line 3055: IEX_Dunnings_PKG.insert_staged_dunning_row(

3051: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
3052: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
3053: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
3054:
3055: IEX_Dunnings_PKG.insert_staged_dunning_row(
3056: px_rowid => l_rowid
3057: , px_dunning_trx_id => x_dunning_trx_id
3058: , p_dunning_id => p_dunning_id
3059: , p_cust_trx_id => l_transaction_id

Line 3142: IEX_Dunnings_PKG.insert_staged_dunning_row(

3138: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_delinquency_id :'||l_delinquency_id);
3139: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_transaction_id :'||l_transaction_id);
3140: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_payment_schedule_id : '||l_payment_schedule_id);
3141:
3142: IEX_Dunnings_PKG.insert_staged_dunning_row(
3143: px_rowid => l_rowid
3144: , px_dunning_trx_id => x_dunning_trx_id
3145: , p_dunning_id => p_dunning_id
3146: , p_cust_trx_id => l_transaction_id

Line 3248: IEX_Dunnings_PKG.insert_staged_dunning_row(

3244:
3245: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
3246: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
3247:
3248: IEX_Dunnings_PKG.insert_staged_dunning_row(
3249: px_rowid => l_rowid
3250: , px_dunning_trx_id => x_dunning_trx_id
3251: , p_dunning_id => p_dunning_id
3252: , p_cust_trx_id => l_customer_trx_id

Line 3348: IEX_Dunnings_PKG.insert_staged_dunning_row(

3344: select count(*) into iex_dunn_trx_counter from iex_dunning_transactions where dunning_id = p_dunning_id and PAYMENT_SCHEDULE_ID = l_payment_schedule_id;
3345:
3346: if iex_dunn_trx_counter = 0 then
3347:
3348: IEX_Dunnings_PKG.insert_staged_dunning_row(
3349: px_rowid => l_rowid
3350: , px_dunning_trx_id => x_dunning_trx_id
3351: , p_dunning_id => p_dunning_id
3352: , p_cust_trx_id => l_transaction_id

Line 3428: IEX_Dunnings_PKG.insert_staged_dunning_row(

3424: exit when sql_cur2%notfound;
3425:
3426: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
3427:
3428: IEX_Dunnings_PKG.insert_staged_dunning_row(
3429: px_rowid => l_rowid
3430: , px_dunning_trx_id => x_dunning_trx_id
3431: , p_dunning_id => p_dunning_id
3432: --, p_cust_trx_id => l_customer_trx_id

Line 3499: IEX_Dunnings_PKG.insert_staged_dunning_row(

3495:
3496: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
3497: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
3498:
3499: IEX_Dunnings_PKG.insert_staged_dunning_row(
3500: px_rowid => l_rowid
3501: , px_dunning_trx_id => x_dunning_trx_id
3502: , p_dunning_id => p_dunning_id
3503: , p_cust_trx_id => l_customer_trx_id

Line 3876: IEX_DUNNINGS_PKG.Update_Row(

3872: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.dunning_mode= ' || l_dunning_rec.dunning_mode);
3873: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.confirmation_mode= ' || l_dunning_rec.confirmation_mode);
3874:
3875: -- Invoke table handler
3876: IEX_DUNNINGS_PKG.Update_Row(
3877: p_rowid => l_rowid
3878: , p_dunning_id => l_dunning_rec.dunning_id
3879: , p_last_update_date => sysdate
3880: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 8837: IEX_Dunnings_PKG.insert_staged_dunning_row(

8833: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_delinquency_id :'||l_delinquency_id);
8834: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id :'||l_transaction_id);
8835: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id : '||l_payment_schedule_id);
8836:
8837: IEX_Dunnings_PKG.insert_staged_dunning_row(
8838: px_rowid => l_rowid
8839: , px_dunning_trx_id => x_dunning_trx_id
8840: , p_dunning_id => l_dunning_id
8841: , p_cust_trx_id => l_transaction_id

Line 14415: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');

14411:
14412: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14413: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14414: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14415: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14416: IEX_Dunnings_PKG.insert_staged_dunning_row(
14417: px_rowid => l_rowid
14418: , px_dunning_trx_id => x_dunning_trx_id
14419: , p_dunning_id => l_dunning_id

Line 14416: IEX_Dunnings_PKG.insert_staged_dunning_row(

14412: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14413: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14414: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14415: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14416: IEX_Dunnings_PKG.insert_staged_dunning_row(
14417: px_rowid => l_rowid
14418: , px_dunning_trx_id => x_dunning_trx_id
14419: , p_dunning_id => l_dunning_id
14420: , p_cust_trx_id => l_transaction_id

Line 14795: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');

14791:
14792: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14793: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14794: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14795: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14796: IEX_Dunnings_PKG.insert_staged_dunning_row(
14797: px_rowid => l_rowid
14798: , px_dunning_trx_id => x_dunning_trx_id
14799: , p_dunning_id => l_dunning_id

Line 14796: IEX_Dunnings_PKG.insert_staged_dunning_row(

14792: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14793: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14794: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14795: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14796: IEX_Dunnings_PKG.insert_staged_dunning_row(
14797: px_rowid => l_rowid
14798: , px_dunning_trx_id => x_dunning_trx_id
14799: , p_dunning_id => l_dunning_id
14800: , p_cust_trx_id => l_transaction_id

Line 18567: IEX_Dunnings_PKG.insert_staged_dunning_row(

18563: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
18564: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
18565: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
18566:
18567: IEX_Dunnings_PKG.insert_staged_dunning_row(
18568: px_rowid => l_rowid
18569: , px_dunning_trx_id => x_dunning_trx_id
18570: , p_dunning_id => p_dunning_id
18571: , p_cust_trx_id => l_transaction_id

Line 18658: IEX_Dunnings_PKG.insert_staged_dunning_row(

18654: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
18655: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
18656: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
18657:
18658: IEX_Dunnings_PKG.insert_staged_dunning_row(
18659: px_rowid => l_rowid
18660: , px_dunning_trx_id => x_dunning_trx_id
18661: , p_dunning_id => p_dunning_id
18662: , p_cust_trx_id => l_transaction_id

Line 18732: IEX_Dunnings_PKG.insert_staged_dunning_row(

18728: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_delinquency_id :'||l_delinquency_id);
18729: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_transaction_id :'||l_transaction_id);
18730: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_payment_schedule_id : '||l_payment_schedule_id);
18731:
18732: IEX_Dunnings_PKG.insert_staged_dunning_row(
18733: px_rowid => l_rowid
18734: , px_dunning_trx_id => x_dunning_trx_id
18735: , p_dunning_id => p_dunning_id
18736: , p_cust_trx_id => l_transaction_id

Line 18832: IEX_Dunnings_PKG.insert_staged_dunning_row(

18828:
18829: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
18830: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
18831:
18832: IEX_Dunnings_PKG.insert_staged_dunning_row(
18833: px_rowid => l_rowid
18834: , px_dunning_trx_id => x_dunning_trx_id
18835: , p_dunning_id => p_dunning_id
18836: , p_cust_trx_id => l_customer_trx_id

Line 18912: IEX_Dunnings_PKG.insert_staged_dunning_row(

18908: exit when sql_cur2%notfound;
18909:
18910: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
18911:
18912: IEX_Dunnings_PKG.insert_staged_dunning_row(
18913: px_rowid => l_rowid
18914: , px_dunning_trx_id => x_dunning_trx_id
18915: , p_dunning_id => p_dunning_id
18916: --, p_cust_trx_id => l_customer_trx_id

Line 18984: IEX_Dunnings_PKG.insert_staged_dunning_row(

18980:
18981: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
18982: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
18983:
18984: IEX_Dunnings_PKG.insert_staged_dunning_row(
18985: px_rowid => l_rowid
18986: , px_dunning_trx_id => x_dunning_trx_id
18987: , p_dunning_id => p_dunning_id
18988: , p_cust_trx_id => l_customer_trx_id