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_UTILITIES

Line 2674: p_inc_inv_curr IN IEX_UTILITIES.INC_INV_CURR_TBL,

2670: p_running_level IN VARCHAR2,
2671: p_grace_days IN NUMBER,
2672: p_include_dispute_items IN VARCHAR2,
2673: p_dunning_mode IN VARCHAR2,
2674: p_inc_inv_curr IN IEX_UTILITIES.INC_INV_CURR_TBL,
2675: x_return_status OUT NOCOPY VARCHAR2,
2676: x_msg_count OUT NOCOPY NUMBER,
2677: x_msg_data OUT NOCOPY VARCHAR2)
2678: IS

Line 2788: t_id := iex_utilities.get_BR_DrweeSiteID(l_object_id);

2784: begin
2785: t_id := l_object_id;
2786: select site_use_code into t_code from hz_cust_site_uses_all where site_use_id = l_object_id;
2787: if t_code = 'BILL_TO' then
2788: t_id := iex_utilities.get_BR_DrweeSiteID(l_object_id);
2789: end if;
2790: exception
2791: when others then t_id := l_object_id;
2792: end;

Line 4192: l_resource_tab iex_utilities.resource_tab_type;

4188: l_allow_send varchar2(1) := 'Y'; -- bug#8408162
4189: l_status varchar2(10);
4190: --Start adding for bug 9156833 gnramasa 27th Nov 09
4191: l_validation_level NUMBER ;
4192: l_resource_tab iex_utilities.resource_tab_type;
4193: l_resource_id NUMBER;
4194: --End adding for bug 9156833 gnramasa 27th Nov 09
4195: l_turnoff_coll_on_bankru varchar2(10);
4196: l_no_of_bankruptcy number;

Line 4228: -- l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;

4224: l_amt_due_remaining number;
4225: l_transaction_id number;
4226: l_payment_schedule_id number;
4227: l_rowid Varchar2(50);
4228: -- l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;
4229: l_dunn_letters varchar2(10);
4230: l_include_current varchar2(1);
4231: l_total_amount_due_remaining number;
4232: l_cust_acct_cm_tot_amt_rem number;

Line 4558: iex_utilities.get_grace_days(p_api_version => p_api_version,

4554: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_use_grace_days :'|| l_use_grace_days);
4555: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dun_disputed_items :'|| l_dun_disputed_items);
4556:
4557: if l_use_grace_days = 'Y' then
4558: iex_utilities.get_grace_days(p_api_version => p_api_version,
4559: p_init_msg_list => FND_API.G_TRUE,
4560: p_commit => FND_API.G_FALSE,
4561: p_validation_level => l_validation_level,
4562: p_level => p_running_level,

Line 4607: if ( iex_utilities.DunningProfileCheck (

4603: elsif (p_running_level = 'BILL_TO') then
4604: l_delinquency_id_check := null;
4605: end if;
4606:
4607: if ( iex_utilities.DunningProfileCheck (
4608: p_party_id => l_party_cust_id_check
4609: , p_cust_account_id => l_account_id_check
4610: , p_site_use_id => l_customer_site_use_id_check
4611: , p_delinquency_id => l_delinquency_id_check ) = 'N'

Line 4622: if ( iex_utilities.DunningMinAmountCheck (

4618: GOTO end_api;
4619: end if;
4620: /* if (p_running_level <> 'CUSTOMER') then
4621: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
4622: if ( iex_utilities.DunningMinAmountCheck (
4623: p_cust_account_id => l_account_id_check
4624: , p_site_use_id => l_customer_site_use_id_check
4625: , p_org_id => l_org_id
4626: , p_dun_disputed_items => l_dun_disputed_items

Line 4631: l_dun_yn := iex_utilities.DunningMinAmountCheck (

4627: , p_correspondence_date => p_correspondence_date
4628: ) = 'N' then --Added for Bug 10401991 20-Jan-2011 barathsr
4629: */
4630: if (p_running_level <> 'CUSTOMER') then
4631: l_dun_yn := iex_utilities.DunningMinAmountCheck (
4632: p_cust_account_id => l_account_id
4633: , p_site_use_id => l_customer_site_use_id
4634: , p_delinquency_id => l_delinquency_id
4635: , p_org_id => l_org_id

Line 4996: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

4992: --Start adding for bug 9156833 gnramasa 27th Nov 09
4993: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
4994:
4995: if (p_running_level = 'BILL_TO') then
4996: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
4997: p_init_msg_list => FND_API.G_TRUE,
4998: p_commit => FND_API.G_FALSE,
4999: p_validation_level => l_validation_level,
5000: p_level => 'DUNNING_BILLTO',

Line 5014: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

5010: END IF;
5011: end if;
5012:
5013: if l_resource_tab.count<1 and (p_running_level = 'ACCOUNT') then
5014: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
5015: p_init_msg_list => FND_API.G_TRUE,
5016: p_commit => FND_API.G_FALSE,
5017: p_validation_level => l_validation_level,
5018: p_level => 'DUNNING_ACCOUNT',

Line 5032: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

5028: END IF;
5029: end if;
5030:
5031: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
5032: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
5033: p_init_msg_list => FND_API.G_TRUE,
5034: p_commit => FND_API.G_FALSE,
5035: p_validation_level => l_validation_level,
5036: p_level => 'DUNNING_PARTY',

Line 5049: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

5045: GOTO end_get_resource;
5046: END IF;
5047:
5048: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
5049: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
5050: p_init_msg_list => FND_API.G_TRUE,
5051: p_commit => FND_API.G_FALSE,
5052: p_validation_level => l_validation_level,
5053: p_level => 'DUNNING_PARTY_ACCOUNT',

Line 5424: l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;

5420: l_first_satified_dunnplanid number;
5421: l_grace_days number := 0;
5422: l_use_grace_days varchar2(10);
5423: l_dun_disputed_items varchar2(10);
5424: l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;
5425: l_dunn_letters varchar2(10);
5426:
5427: --Start adding for bug 9156833 gnramasa 27th Nov 09
5428: l_validation_level NUMBER ;

Line 5429: l_resource_tab iex_utilities.resource_tab_type;

5425: l_dunn_letters varchar2(10);
5426:
5427: --Start adding for bug 9156833 gnramasa 27th Nov 09
5428: l_validation_level NUMBER ;
5429: l_resource_tab iex_utilities.resource_tab_type;
5430: l_resource_id NUMBER;
5431: --End adding for bug 9156833 gnramasa 27th Nov 09
5432: l_turnoff_coll_on_bankru varchar2(10);
5433: l_no_of_bankruptcy number;

Line 5557: t_id := iex_utilities.get_BR_DrweeSiteID(l_object_id);

5553: begin
5554: t_id := l_object_id;
5555: select site_use_code into t_code from hz_cust_site_uses_all where site_use_id = l_object_id;
5556: if t_code = 'BILL_TO' then
5557: t_id := iex_utilities.get_BR_DrweeSiteID(l_object_id);
5558: end if;
5559: exception
5560: when others then t_id := l_object_id;
5561: end;

Line 5634: iex_utilities.get_grace_days(p_api_version => p_api_version,

5630: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_use_grace_days :'|| l_use_grace_days);
5631: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dun_disputed_items :'|| l_dun_disputed_items);
5632:
5633: if l_use_grace_days = 'Y' then
5634: iex_utilities.get_grace_days(p_api_version => p_api_version,
5635: p_init_msg_list => FND_API.G_TRUE,
5636: p_commit => FND_API.G_FALSE,
5637: p_validation_level => l_validation_level,
5638: p_level => p_running_level,

Line 5657: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

5653: --Start adding for bug 9156833 gnramasa 27th Nov 09
5654: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
5655:
5656: if (p_running_level = 'BILL_TO') then
5657: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
5658: p_init_msg_list => FND_API.G_TRUE,
5659: p_commit => FND_API.G_FALSE,
5660: p_validation_level => l_validation_level,
5661: p_level => 'DUNNING_BILLTO',

Line 5675: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

5671: END IF;
5672: end if;
5673:
5674: if l_resource_tab.count<1 and (p_running_level = 'ACCOUNT') then
5675: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
5676: p_init_msg_list => FND_API.G_TRUE,
5677: p_commit => FND_API.G_FALSE,
5678: p_validation_level => l_validation_level,
5679: p_level => 'DUNNING_ACCOUNT',

Line 5693: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

5689: END IF;
5690: end if;
5691:
5692: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
5693: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
5694: p_init_msg_list => FND_API.G_TRUE,
5695: p_commit => FND_API.G_FALSE,
5696: p_validation_level => l_validation_level,
5697: p_level => 'DUNNING_PARTY',

Line 5710: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

5706: GOTO end_get_resource;
5707: END IF;
5708:
5709: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
5710: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
5711: p_init_msg_list => FND_API.G_TRUE,
5712: p_commit => FND_API.G_FALSE,
5713: p_validation_level => l_validation_level,
5714: p_level => 'DUNNING_PARTY_ACCOUNT',

Line 5834: iex_utilities.StagedDunningMinAmountCheck (

5830: l_customer_site_use_id_check := null;
5831: end if;
5832: -- check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
5833:
5834: iex_utilities.StagedDunningMinAmountCheck (
5835: p_cust_account_id => l_account_id_check
5836: , p_site_use_id => l_customer_site_use_id_check
5837: , p_party_id => l_party_cust_id
5838: , p_dunning_plan_id => p_dunning_plan_id

Line 5977: if ( iex_utilities.DunningProfileCheck (

5973: l_delinquency_id_check := null;
5974: elsif (p_running_level = 'BILL_TO') then
5975: l_delinquency_id_check := null;
5976: end if;
5977: if ( iex_utilities.DunningProfileCheck (
5978: p_party_id => l_party_cust_id_check
5979: , p_cust_account_id => l_account_id_check
5980: , p_site_use_id => l_customer_site_use_id_check
5981: , p_delinquency_id => l_delinquency_id_check ) = 'N'

Line 7060: l_resource_tab iex_utilities.resource_tab_type;

7056: l_allow_send varchar2(1) :='Y'; -- Added for bug#8408162
7057: l_status varchar2(10);
7058: --Start adding for bug 9156833 gnramasa 27th Nov 09
7059: l_validation_level NUMBER ;
7060: l_resource_tab iex_utilities.resource_tab_type;
7061: l_resource_id NUMBER;
7062: --End adding for bug 9156833 gnramasa 27th Nov 09
7063: l_turnoff_coll_on_bankru varchar2(10);
7064: l_no_of_bankruptcy number;

Line 7391: iex_utilities.get_grace_days(p_api_version => p_api_version,

7387: GOTO end_loop;
7388: end if;
7389:
7390: if l_use_grace_days = 'Y' then
7391: iex_utilities.get_grace_days(p_api_version => p_api_version,
7392: p_init_msg_list => FND_API.G_TRUE,
7393: p_commit => FND_API.G_FALSE,
7394: p_validation_level => l_validation_level,
7395: p_level => l_running_level,

Line 7416: if ( iex_utilities.DunningProfileCheck (

7412: *===========================================*/
7413:
7414: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
7415: -- ctlee - check the hz_customer_profiles.dunning_letter
7416: if ( iex_utilities.DunningProfileCheck (
7417: p_party_id => l_party_cust_id
7418: , p_cust_account_id => l_account_id
7419: , p_site_use_id => l_customer_site_use_id
7420: , p_delinquency_id => l_delinquency_id ) = 'N'

Line 7429: if ( iex_utilities.DunningMinAmountCheck (

7425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
7426: GOTO end_loop;
7427: end if;
7428: /* -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
7429: if ( iex_utilities.DunningMinAmountCheck (
7430: p_cust_account_id => l_account_id
7431: , p_site_use_id => l_customer_site_use_id
7432: , p_org_id => l_org_id) = 'N' --Added for Bug 10401991 20-Jan-2011 barathsr
7433: ) then

Line 7514: l_dun_yn := IEX_UTILITIES.DunningMinAmountCheck (

7510: elsif (l_running_level = 'BILL_TO') then
7511: l_delinquency_id_check := null;
7512: end if; */
7513: -- start code for bug 15933013
7514: l_dun_yn := IEX_UTILITIES.DunningMinAmountCheck (
7515: p_cust_account_id => l_account_id
7516: , p_site_use_id => l_customer_site_use_id
7517: , p_delinquency_id => l_delinquency_id
7518: , p_org_id => l_org_id

Line 7755: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

7751:
7752: --Start adding for bug 9156833 gnramasa 27th Nov 09
7753: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
7754:
7755: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
7756: p_init_msg_list => FND_API.G_TRUE,
7757: p_commit => FND_API.G_FALSE,
7758: p_validation_level => l_validation_level,
7759: p_level => 'DUNNING_BILLTO',

Line 8104: --l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;

8100: l_first_satified_dunnplanid number;
8101: l_grace_days number := 0;
8102: l_use_grace_days varchar2(10);
8103: l_dun_disputed_items varchar2(10);
8104: --l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;
8105: l_dunn_letters varchar2(10);
8106: l_inv_curr varchar2(20);
8107: l_amt_due_remaining number;
8108: l_profile_dunn_amt number;

Line 8259: l_resource_tab iex_utilities.resource_tab_type;

8255: l_dunningplan_lines c_dunningplan_lines%rowtype;
8256:
8257: --Start adding for bug 9156833 gnramasa 27th Nov 09
8258: l_validation_level NUMBER ;
8259: l_resource_tab iex_utilities.resource_tab_type;
8260: l_resource_id NUMBER;
8261: --End adding for bug 9156833 gnramasa 27th Nov 09
8262: l_turnoff_coll_on_bankru varchar2(10);
8263: l_no_of_bankruptcy number;

Line 8408: iex_utilities.get_grace_days(p_api_version => p_api_version,

8404: goto end_loop; -- restored from bug 14797201
8405: END IF;
8406:
8407: if l_use_grace_days = 'Y' then
8408: iex_utilities.get_grace_days(p_api_version => p_api_version,
8409: p_init_msg_list => FND_API.G_TRUE,
8410: p_commit => FND_API.G_FALSE,
8411: p_validation_level => l_validation_level,
8412: p_level => 'BILL_TO', --get the grace days from the site level profile

Line 8634: if ( iex_utilities.DunningProfileCheck (

8630: *===========================================*/
8631:
8632: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
8633: -- ctlee - check the hz_customer_profiles.dunning_letter
8634: if ( iex_utilities.DunningProfileCheck (
8635: p_party_id => l_party_cust_id
8636: , p_cust_account_id => l_account_id
8637: , p_site_use_id => l_customer_site_use_id
8638: , p_delinquency_id => l_delinquency_id ) = 'N'

Line 8912: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

8908:
8909: --Start adding for bug 9156833 gnramasa 27th Nov 09
8910: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
8911:
8912: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
8913: p_init_msg_list => FND_API.G_TRUE,
8914: p_commit => FND_API.G_FALSE,
8915: p_validation_level => l_validation_level,
8916: p_level => 'DUNNING_BILLTO',

Line 9280: l_resource_tab iex_utilities.resource_tab_type;

9276: l_contact_destination varchar2(240); -- bug 3955222
9277: l_contact_party_id number; -- bug 3955222
9278: --Start adding for bug 9156833 gnramasa 27th Nov 09
9279: l_validation_level NUMBER ;
9280: l_resource_tab iex_utilities.resource_tab_type;
9281: l_resource_id NUMBER;
9282: --End adding for bug 9156833 gnramasa 27th Nov 09
9283: l_grace_days number := 0;
9284: l_use_grace_days varchar2(10);

Line 9582: iex_utilities.get_grace_days(p_api_version => p_api_version,

9578: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_use_grace_days :'|| l_use_grace_days);
9579: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dun_disputed_items :'|| l_dun_disputed_items);
9580:
9581: if l_use_grace_days = 'Y' then
9582: iex_utilities.get_grace_days(p_api_version => p_api_version,
9583: p_init_msg_list => FND_API.G_TRUE,
9584: p_commit => FND_API.G_FALSE,
9585: p_validation_level => l_validation_level,
9586: p_level => p_running_level,

Line 9631: if ( iex_utilities.DunningProfileCheck (

9627: open c_as_of_date (p_dunning_id);
9628: fetch c_as_of_date into l_as_of_date;
9629: close c_as_of_date;
9630: WriteLog('iexvdunb:ResendLevelDunn: l_as_of_date : '||l_as_of_date);
9631: if ( iex_utilities.DunningProfileCheck (
9632: p_party_id => l_party_cust_id_check
9633: , p_cust_account_id => l_account_id_check
9634: , p_site_use_id => l_customer_site_use_id_check
9635: , p_delinquency_id => l_delinquency_id_check ) = 'N'

Line 9646: if ( iex_utilities.DunningMinAmountCheck (

9642: end if;
9643:
9644: /*if (p_running_level <> 'CUSTOMER') then
9645: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
9646: if ( iex_utilities.DunningMinAmountCheck (
9647: p_cust_account_id => l_account_id_check
9648: , p_site_use_id => l_customer_site_use_id_check
9649: , p_delinquency_id => l_delinquency_id_check
9650: ) = 'N' --Added for Bug 10401991 20-Jan-2011 barathsr

Line 9654: if ( iex_utilities.DunningMinAmountCheck (

9650: ) = 'N' --Added for Bug 10401991 20-Jan-2011 barathsr
9651: ) then*/
9652: -- start bug 15933013
9653: if (p_running_level <> 'CUSTOMER') then
9654: if ( iex_utilities.DunningMinAmountCheck (
9655: p_cust_account_id => l_account_id
9656: , p_site_use_id => l_customer_site_use_id
9657: , p_delinquency_id => l_delinquency_id
9658: , p_org_id => l_org_id

Line 9836: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

9832: --Start adding for bug 9156833 gnramasa 27th Nov 09
9833: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
9834:
9835: if (p_running_level = 'BILL_TO') then
9836: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
9837: p_init_msg_list => FND_API.G_TRUE,
9838: p_commit => FND_API.G_FALSE,
9839: p_validation_level => l_validation_level,
9840: p_level => 'DUNNING_BILLTO',

Line 9854: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

9850: END IF;
9851: end if;
9852:
9853: if l_resource_tab.count<1 and (p_running_level = 'ACCOUNT') then
9854: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
9855: p_init_msg_list => FND_API.G_TRUE,
9856: p_commit => FND_API.G_FALSE,
9857: p_validation_level => l_validation_level,
9858: p_level => 'DUNNING_ACCOUNT',

Line 9872: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

9868: END IF;
9869: end if;
9870:
9871: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
9872: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
9873: p_init_msg_list => FND_API.G_TRUE,
9874: p_commit => FND_API.G_FALSE,
9875: p_validation_level => l_validation_level,
9876: p_level => 'DUNNING_PARTY',

Line 9889: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

9885: GOTO end_get_resource;
9886: END IF;
9887:
9888: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
9889: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
9890: p_init_msg_list => FND_API.G_TRUE,
9891: p_commit => FND_API.G_FALSE,
9892: p_validation_level => l_validation_level,
9893: p_level => 'DUNNING_PARTY_ACCOUNT',

Line 10357: l_resource_tab iex_utilities.resource_tab_type;

10353: l_xml_request_id number;
10354:
10355: --Start adding for bug 9156833 gnramasa 27th Nov 09
10356: l_validation_level NUMBER ;
10357: l_resource_tab iex_utilities.resource_tab_type;
10358: l_resource_id NUMBER;
10359: --End adding for bug 9156833 gnramasa 27th Nov 09
10360: l_inv_xdo_template_id number;
10361: l_as_of_date date;

Line 10718: if ( iex_utilities.DunningProfileCheck (

10714: open c_as_of_date (p_dunning_id);
10715: fetch c_as_of_date into l_as_of_date;
10716: close c_as_of_date;
10717:
10718: if ( iex_utilities.DunningProfileCheck (
10719: p_party_id => l_party_cust_id_check
10720: , p_cust_account_id => l_account_id_check
10721: , p_site_use_id => l_customer_site_use_id_check
10722: , p_delinquency_id => l_delinquency_id_check ) = 'N'

Line 10733: if ( iex_utilities.DunningMinAmountCheck (

10729: end if;
10730:
10731: /*
10732: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
10733: if ( iex_utilities.DunningMinAmountCheck (
10734: p_cust_account_id => l_account_id_check
10735: , p_site_use_id => l_customer_site_use_id_check) = 'N'
10736: ) then
10737: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

Line 10785: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

10781: --Start adding for bug 9156833 gnramasa 27th Nov 09
10782: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
10783:
10784: if (p_running_level = 'BILL_TO') then
10785: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
10786: p_init_msg_list => FND_API.G_TRUE,
10787: p_commit => FND_API.G_FALSE,
10788: p_validation_level => l_validation_level,
10789: p_level => 'DUNNING_BILLTO',

Line 10803: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

10799: END IF;
10800: end if;
10801:
10802: if l_resource_tab.count<1 and (p_running_level = 'ACCOUNT') then
10803: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
10804: p_init_msg_list => FND_API.G_TRUE,
10805: p_commit => FND_API.G_FALSE,
10806: p_validation_level => l_validation_level,
10807: p_level => 'DUNNING_ACCOUNT',

Line 10821: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

10817: END IF;
10818: end if;
10819:
10820: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
10821: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
10822: p_init_msg_list => FND_API.G_TRUE,
10823: p_commit => FND_API.G_FALSE,
10824: p_validation_level => l_validation_level,
10825: p_level => 'DUNNING_PARTY',

Line 10838: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

10834: GOTO end_get_resource;
10835: END IF;
10836:
10837: if l_resource_tab.count<1 and (p_running_level = 'CUSTOMER') then
10838: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
10839: p_init_msg_list => FND_API.G_TRUE,
10840: p_commit => FND_API.G_FALSE,
10841: p_validation_level => l_validation_level,
10842: p_level => 'DUNNING_PARTY_ACCOUNT',

Line 11287: l_resource_tab iex_utilities.resource_tab_type;

11283: l_contact_destination varchar2(240); -- bug 3955222
11284: l_contact_party_id number; -- bug 3955222
11285: --Start adding for bug 9156833 gnramasa 27th Nov 09
11286: l_validation_level NUMBER ;
11287: l_resource_tab iex_utilities.resource_tab_type;
11288: l_resource_id NUMBER;
11289: --End adding for bug 9156833 gnramasa 27th Nov 09
11290:
11291: l_grace_days number := 0;

Line 11512: iex_utilities.get_grace_days(p_api_version => p_api_version,

11508: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_use_grace_days :'|| l_use_grace_days);
11509: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dun_disputed_items :'|| l_dun_disputed_items);
11510:
11511: if l_use_grace_days = 'Y' then
11512: iex_utilities.get_grace_days(p_api_version => p_api_version,
11513: p_init_msg_list => FND_API.G_TRUE,
11514: p_commit => FND_API.G_FALSE,
11515: p_validation_level => l_validation_level,
11516: p_level => l_running_level,

Line 11541: if ( iex_utilities.DunningProfileCheck (

11537: *===========================================*/
11538:
11539: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
11540: -- ctlee - check the hz_customer_profiles.dunning_letter
11541: if ( iex_utilities.DunningProfileCheck (
11542: p_party_id => l_party_cust_id
11543: , p_cust_account_id => l_account_id
11544: , p_site_use_id => l_customer_site_use_id
11545: , p_delinquency_id => l_delinquency_id ) = 'N'

Line 11554: /* if ( iex_utilities.DunningMinAmountCheck (

11550: GOTO end_loop;
11551: end if;
11552:
11553: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
11554: /* if ( iex_utilities.DunningMinAmountCheck (
11555: p_cust_account_id => l_account_id
11556: , p_site_use_id => l_customer_site_use_id
11557: , p_org_id => l_org_id, p_grace_days => l_grace_days
11558: , p_dun_disputed_items => l_dun_disputed_items) = 'N' --Added for Bug 10401991 20-Jan-2011 barathsr

Line 11562: if ( iex_utilities.DunningMinAmountCheck (

11558: , p_dun_disputed_items => l_dun_disputed_items) = 'N' --Added for Bug 10401991 20-Jan-2011 barathsr
11559: ) then
11560: */
11561: -- start bug 15933013
11562: if ( iex_utilities.DunningMinAmountCheck (
11563: p_cust_account_id => l_account_id
11564: , p_site_use_id => l_customer_site_use_id
11565: , p_delinquency_id => l_delinquency_id
11566: , p_org_id => l_org_id

Line 11625: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

11621:
11622: --Start adding for bug 9156833 gnramasa 27th Nov 09
11623: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
11624:
11625: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
11626: p_init_msg_list => FND_API.G_TRUE,
11627: p_commit => FND_API.G_FALSE,
11628: p_validation_level => l_validation_level,
11629: p_level => 'DUNNING_BILLTO',

Line 12100: l_resource_tab iex_utilities.resource_tab_type;

12096: l_xml_request_id number;
12097:
12098: --Start adding for bug 9156833 gnramasa 27th Nov 09
12099: l_validation_level NUMBER ;
12100: l_resource_tab iex_utilities.resource_tab_type;
12101: l_resource_id NUMBER;
12102: --End adding for bug 9156833 gnramasa 27th Nov 09
12103: l_inv_xdo_template_id number;
12104: l_as_of_date date;

Line 12357: if ( iex_utilities.DunningProfileCheck (

12353: *===========================================*/
12354:
12355: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
12356: -- ctlee - check the hz_customer_profiles.dunning_letter
12357: if ( iex_utilities.DunningProfileCheck (
12358: p_party_id => l_party_cust_id
12359: , p_cust_account_id => l_account_id
12360: , p_site_use_id => l_customer_site_use_id
12361: , p_delinquency_id => l_delinquency_id ) = 'N'

Line 12371: if ( iex_utilities.DunningMinAmountCheck (

12367: end if;
12368:
12369: /*
12370: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
12371: if ( iex_utilities.DunningMinAmountCheck (
12372: p_cust_account_id => l_account_id
12373: , p_site_use_id => l_customer_site_use_id) = 'N'
12374: ) then
12375: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

Line 12432: iex_utilities.get_dunning_resource(p_api_version => p_api_version,

12428:
12429: --Start adding for bug 9156833 gnramasa 27th Nov 09
12430: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
12431:
12432: iex_utilities.get_dunning_resource(p_api_version => p_api_version,
12433: p_init_msg_list => FND_API.G_TRUE,
12434: p_commit => FND_API.G_FALSE,
12435: p_validation_level => l_validation_level,
12436: p_level => 'DUNNING_BILLTO',

Line 16781: l_resource_tab iex_utilities.resource_tab_type;

16777: --
16778: errmsg varchar2(30000);
16779:
16780: --Added for bug#5229763 schekuri 27-Jul-2006
16781: l_resource_tab iex_utilities.resource_tab_type;
16782: l_return_status VARCHAR2(1);
16783: l_msg_count NUMBER;
16784: l_msg_data VARCHAR2(32767);
16785: l_validation_level NUMBER ;

Line 16897: --Called iex_utilities.get_assigned_collector to get the resource from hz_customer_profiles table

16893: -- clchang updated 09/20/2002 for bug 2242346
16894: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Call GET_RESOURCE');
16895: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - partyid='||l_party_cust_id);
16896: --Begin Bug#5229763 schekuri 27-Jul-2006
16897: --Called iex_utilities.get_assigned_collector to get the resource from hz_customer_profiles table
16898: --instead of as_accesses. Removed the call to "get_resource".
16899: if l_customer_site_use_id is not null then
16900: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
16901: p_init_msg_list => FND_API.G_TRUE,

Line 16900: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

16896: --Begin Bug#5229763 schekuri 27-Jul-2006
16897: --Called iex_utilities.get_assigned_collector to get the resource from hz_customer_profiles table
16898: --instead of as_accesses. Removed the call to "get_resource".
16899: if l_customer_site_use_id is not null then
16900: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
16901: p_init_msg_list => FND_API.G_TRUE,
16902: p_commit => FND_API.G_FALSE,
16903: p_validation_level => l_validation_level,
16904: p_level => 'DUNNING_BILLTO',

Line 16918: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

16914: END IF;
16915: end if;
16916:
16917: if l_resource_tab.count<1 and l_account_id is not null then
16918: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
16919: p_init_msg_list => FND_API.G_TRUE,
16920: p_commit => FND_API.G_FALSE,
16921: p_validation_level => l_validation_level,
16922: p_level => 'DUNNING_ACCOUNT',

Line 16936: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

16932: END IF;
16933: end if;
16934:
16935: if l_resource_tab.count<1 and l_party_cust_id is not null then
16936: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
16937: p_init_msg_list => FND_API.G_TRUE,
16938: p_commit => FND_API.G_FALSE,
16939: p_validation_level => l_validation_level,
16940: p_level => 'DUNNING_PARTY',

Line 16953: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

16949: GOTO end_new_task;
16950: END IF;
16951:
16952: if l_resource_tab.count<1 and p_dunning_level = 'CUSTOMER' then
16953: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
16954: p_init_msg_list => FND_API.G_TRUE,
16955: p_commit => FND_API.G_FALSE,
16956: p_validation_level => l_validation_level,
16957: p_level => 'DUNNING_PARTY_ACCOUNT',

Line 17202: --Removed all the code to replace the usage of this procedure with iex_utilities.get_assigned_collector

17198: * 4. if taskcount > 0,
17199: * get the resource_id which has the least tasks;
17200: *
17201: *========================================================================*/
17202: --Removed all the code to replace the usage of this procedure with iex_utilities.get_assigned_collector
17203: --for bug#5229763 schekuri 27-Jul-2006
17204: --iex_utilities.get_assigned_collector uses hz_customer_profiles to get resource instead of as_accesses
17205: PROCEDURE Get_Resource(p_api_version IN NUMBER,
17206: p_commit IN VARCHAR2,

Line 17204: --iex_utilities.get_assigned_collector uses hz_customer_profiles to get resource instead of as_accesses

17200: *
17201: *========================================================================*/
17202: --Removed all the code to replace the usage of this procedure with iex_utilities.get_assigned_collector
17203: --for bug#5229763 schekuri 27-Jul-2006
17204: --iex_utilities.get_assigned_collector uses hz_customer_profiles to get resource instead of as_accesses
17205: PROCEDURE Get_Resource(p_api_version IN NUMBER,
17206: p_commit IN VARCHAR2,
17207: p_init_msg_list IN VARCHAR2 ,
17208: p_party_id IN NUMBER,

Line 17868: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||

17864: 'id.xml_template_id TEMPLATE_ID, ' ||
17865: 'xtvl.template_name TEMPLATE_NAME, ' ||
17866: 'id.delivery_status ERROR, ' ||
17867: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17868: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17869: 'ixr.destination DESTINATION, ' ||
17870: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17871: --'ixr.xml_request_id REQUEST_ID ' ||
17872: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||

Line 17870: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||

17866: 'id.delivery_status ERROR, ' ||
17867: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17868: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17869: 'ixr.destination DESTINATION, ' ||
17870: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17871: --'ixr.xml_request_id REQUEST_ID ' ||
17872: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17873: 'from iex_xml_request_histories ixr, ' ||
17874: 'hz_parties p, ' ||

Line 17900: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||

17896: 'id.xml_template_id TEMPLATE_ID, ' ||
17897: 'xtvl.template_name TEMPLATE_NAME, ' ||
17898: 'id.delivery_status ERROR, ' ||
17899: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17900: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17901: 'ixr.destination DESTINATION, ' ||
17902: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17903: --'ixr.xml_request_id REQUEST_ID ' ||
17904: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||

Line 17902: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||

17898: 'id.delivery_status ERROR, ' ||
17899: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17900: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17901: 'ixr.destination DESTINATION, ' ||
17902: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17903: --'ixr.xml_request_id REQUEST_ID ' ||
17904: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17905: 'from iex_xml_request_histories ixr, ' ||
17906: 'hz_parties p, ' ||

Line 17935: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||

17931: 'id.xml_template_id TEMPLATE_ID, ' ||
17932: 'xtvl.template_name TEMPLATE_NAME, ' ||
17933: 'id.delivery_status ERROR, ' ||
17934: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17935: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17936: 'ixr.destination DESTINATION, ' ||
17937: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17938: --'ixr.xml_request_id REQUEST_ID ' ||
17939: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||

Line 17937: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||

17933: 'id.delivery_status ERROR, ' ||
17934: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17935: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17936: 'ixr.destination DESTINATION, ' ||
17937: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17938: --'ixr.xml_request_id REQUEST_ID ' ||
17939: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17940: 'from iex_xml_request_histories ixr, ' ||
17941: 'hz_parties p, ' ||

Line 17974: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||

17970: 'id.xml_template_id TEMPLATE_ID, ' ||
17971: 'xtvl.template_name TEMPLATE_NAME, ' ||
17972: 'id.delivery_status ERROR, ' ||
17973: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17974: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17975: 'ixr.destination DESTINATION, ' ||
17976: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17977: --'ixr.xml_request_id REQUEST_ID ' ||
17978: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||

Line 17976: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||

17972: 'id.delivery_status ERROR, ' ||
17973: 'fnd_message.get_string(''IEX'',id.delivery_status) ERROR_DESC, ' ||
17974: 'iex_utilities.get_lookup_meaning(''IEX_FULFILLMENT_SEND_METHOD'',id.dunning_method) DUNNING_METHOD, '||
17975: 'ixr.destination DESTINATION, ' ||
17976: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17977: --'ixr.xml_request_id REQUEST_ID ' ||
17978: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17979: 'from iex_xml_request_histories ixr, ' ||
17980: 'hz_parties p, ' ||

Line 18084: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_DUNNING_MODE',p_dunning_mode) ||'';

18080: l_xml_header := l_xml_header ||l_new_line||'';
18081: l_xml_header := l_xml_header ||l_new_line||' '||l_report_date||'';
18082: l_xml_header := l_xml_header ||l_new_line||' '||p_running_level||'';
18083: l_xml_header := l_xml_header ||l_new_line||' ' ||l_dunning_plan ||'';
18084: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_DUNNING_MODE',p_dunning_mode) ||'';
18085: l_xml_header := l_xml_header ||l_new_line||' ' || p_request_id ||'';
18086: l_xml_header := l_xml_header ||l_new_line||' ' || l_no_of_rec_prc ||'';
18087: l_xml_header := l_xml_header ||l_new_line||' ' || l_no_of_succ_rec ||'';
18088: l_xml_header := l_xml_header ||l_new_line||' ' || l_no_of_fail_rec ||'';