APPS.IEX_UTILITIES dependencies on IEX_DEBUG_PUB

Line 102: iex_debug_pub.logmessage ('Exception from Get_Manage_Role = ' ||SQLERRM||SQLCODE);

98: Close get_manager_role_c;
99:
100: exception
101: when others then
102: iex_debug_pub.logmessage ('Exception from Get_Manage_Role = ' ||SQLERRM||SQLCODE);
103: return l_manager;
104:
105: End Get_Manager_role;
106: -- end bug 7269278

Line 120: iex_debug_pub.logmessage ('Exception from Get_Manage_Role = ' ||SQLERRM||SQLCODE);

116: return delete_flag;
117:
118: exception
119: when others then
120: iex_debug_pub.logmessage ('Exception from Get_Manage_Role = ' ||SQLERRM||SQLCODE);
121: return delete_flag;
122:
123: End Delete_delinquncies;
124:

Line 645: iex_debug_pub.logmessage ('**** BEGIN get_access_resources ************');

641: idx NUMBER := 0;
642: BEGIN
643:
644: IF PG_DEBUG < 10 THEN
645: iex_debug_pub.logmessage ('**** BEGIN get_access_resources ************');
646: iex_debug_pub.logmessage ('get_person cursor = ' ||
647: 'SELECT DISTINCT hp.employee_id
648: FROM hz_customer_profiles hp,ar_collectors ac
649: WHERE m.person_id = ac.employee_id

Line 646: iex_debug_pub.logmessage ('get_person cursor = ' ||

642: BEGIN
643:
644: IF PG_DEBUG < 10 THEN
645: iex_debug_pub.logmessage ('**** BEGIN get_access_resources ************');
646: iex_debug_pub.logmessage ('get_person cursor = ' ||
647: 'SELECT DISTINCT hp.employee_id
648: FROM hz_customer_profiles hp,ar_collectors ac
649: WHERE m.person_id = ac.employee_id
650: AND hp.collector_id = ac.collector_id

Line 676: iex_debug_pub.logmessage ('employee_id = ' || r_person.employee_id);

672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673:
674: FOR r_person IN c_get_person LOOP
675: IF PG_DEBUG < 10 THEN
676: iex_debug_pub.logmessage ('employee_id = ' || r_person.employee_id);
677: END IF;
678: OPEN c_get_resource(r_person.employee_id);
679: FETCH c_get_resource INTO l_resource_row;
680: IF c_get_resource%FOUND THEN

Line 683: iex_debug_pub.logmessage ('idx= ' || idx);

679: FETCH c_get_resource INTO l_resource_row;
680: IF c_get_resource%FOUND THEN
681: idx := idx + 1;
682: IF PG_DEBUG < 10 THEN
683: iex_debug_pub.logmessage ('idx= ' || idx);
684: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
685: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
686: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
687: END IF;

Line 684: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);

680: IF c_get_resource%FOUND THEN
681: idx := idx + 1;
682: IF PG_DEBUG < 10 THEN
683: iex_debug_pub.logmessage ('idx= ' || idx);
684: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
685: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
686: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
687: END IF;
688: x_resource_tab(idx).resource_id := l_resource_row.resource_id;

Line 685: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);

681: idx := idx + 1;
682: IF PG_DEBUG < 10 THEN
683: iex_debug_pub.logmessage ('idx= ' || idx);
684: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
685: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
686: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
687: END IF;
688: x_resource_tab(idx).resource_id := l_resource_row.resource_id;
689: x_resource_tab(idx).user_id := l_resource_row.user_id;

Line 686: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);

682: IF PG_DEBUG < 10 THEN
683: iex_debug_pub.logmessage ('idx= ' || idx);
684: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
685: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
686: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
687: END IF;
688: x_resource_tab(idx).resource_id := l_resource_row.resource_id;
689: x_resource_tab(idx).user_id := l_resource_row.user_id;
690: x_resource_tab(idx).person_id := l_resource_row.source_id;

Line 706: iex_debug_pub.logmessage ('**** END get_access_resources ************');

702: -- Standard call to get message count and if count is 1, get message info
703: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
704:
705: IF PG_DEBUG < 10 THEN
706: iex_debug_pub.logmessage ('**** END get_access_resources ************');
707: END IF;
708:
709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN

Line 846: iex_debug_pub.logmessage ('**** BEGIN on all

842: l_msg_data VARCHAR2(32767);
843: idx NUMBER := 0;
844: BEGIN
845:
846: iex_debug_pub.logmessage ('**** BEGIN on all
847: get_access_resources ************');
848: l_init_msg_list := p_init_msg_list;
849: iex_debug_pub.logmessage ('get_person cursor = ' ||
850: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||

Line 849: iex_debug_pub.logmessage ('get_person cursor = ' ||

845:
846: iex_debug_pub.logmessage ('**** BEGIN on all
847: get_access_resources ************');
848: l_init_msg_list := p_init_msg_list;
849: iex_debug_pub.logmessage ('get_person cursor = ' ||
850: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||
851: ' FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi, '||
852: ' ar_collectors ac ' ||
853: ' WHERE hp.party_id = p_party_id ' ||

Line 880: iex_debug_pub.logmessage ('idx= ' || idx);

876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877:
878: FOR r_person IN c_get_person LOOP
879: idx := idx + 1;
880: iex_debug_pub.logmessage ('idx= ' || idx);
881: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
882: x_resource_tab(idx).resource_id := r_person.resource_id;
883: x_resource_tab(idx).person_id := r_person.employee_id;
884: End LOOP;*/

Line 881: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);

877:
878: FOR r_person IN c_get_person LOOP
879: idx := idx + 1;
880: iex_debug_pub.logmessage ('idx= ' || idx);
881: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
882: x_resource_tab(idx).resource_id := r_person.resource_id;
883: x_resource_tab(idx).person_id := r_person.employee_id;
884: End LOOP;*/
885:

Line 903: iex_debug_pub.logmessage ('**** END get_access_resources ************');

899:
900: -- Standard call to get message count and if count is 1, get message info
901: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
902:
903: iex_debug_pub.logmessage ('**** END get_access_resources ************');
904:
905: EXCEPTION
906: WHEN FND_API.G_EXC_ERROR THEN
907: ROLLBACK TO get_assign_resources;

Line 1019: iex_debug_pub.logmessage ('**** BEGIN on all

1015: l_msg_data VARCHAR2(32767);
1016: idx NUMBER := 0;
1017: BEGIN
1018:
1019: iex_debug_pub.logmessage ('**** BEGIN on all
1020: get_access_resources ************');
1021: l_init_msg_list := p_init_msg_list;
1022: iex_debug_pub.logmessage ('get_person cursor = ' ||
1023: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||

Line 1022: iex_debug_pub.logmessage ('get_person cursor = ' ||

1018:
1019: iex_debug_pub.logmessage ('**** BEGIN on all
1020: get_access_resources ************');
1021: l_init_msg_list := p_init_msg_list;
1022: iex_debug_pub.logmessage ('get_person cursor = ' ||
1023: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||
1024: ' FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi, '||
1025: ' ar_collectors ac ' ||
1026: ' WHERE hp.party_id = p_party_id ' ||

Line 1053: iex_debug_pub.logmessage ('idx= ' || idx);

1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: FOR r_person IN c_get_person LOOP
1052: idx := idx + 1;
1053: iex_debug_pub.logmessage ('idx= ' || idx);
1054: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1055: x_resource_tab(idx).resource_id := r_person.resource_id;
1056: x_resource_tab(idx).person_id := r_person.employee_id;
1057: End LOOP;*/

Line 1054: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);

1050:
1051: FOR r_person IN c_get_person LOOP
1052: idx := idx + 1;
1053: iex_debug_pub.logmessage ('idx= ' || idx);
1054: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1055: x_resource_tab(idx).resource_id := r_person.resource_id;
1056: x_resource_tab(idx).person_id := r_person.employee_id;
1057: End LOOP;*/
1058:

Line 1076: iex_debug_pub.logmessage ('**** END get_access_resources ************');

1072:
1073: -- Standard call to get message count and if count is 1, get message info
1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1075:
1076: iex_debug_pub.logmessage ('**** END get_access_resources ************');
1077:
1078: EXCEPTION
1079: WHEN FND_API.G_EXC_ERROR THEN
1080: ROLLBACK TO get_assign_account_resources;

Line 1136: iex_debug_pub.logmessage ('**** BEGIN get_case_resources ************');

1132: l_msg_data VARCHAR2(32767);
1133: idx NUMBER := 0;
1134: BEGIN
1135:
1136: iex_debug_pub.logmessage ('**** BEGIN get_case_resources ************');
1137: iex_debug_pub.logmessage ('get_person cursor = ' ||
1138: 'SELECT ac.employee_id, ac.resource_id, count(cas_id)
1139: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_cases_vl wi,ar_collectors ac
1140: WHERE hp.party_id = p_party_id

Line 1137: iex_debug_pub.logmessage ('get_person cursor = ' ||

1133: idx NUMBER := 0;
1134: BEGIN
1135:
1136: iex_debug_pub.logmessage ('**** BEGIN get_case_resources ************');
1137: iex_debug_pub.logmessage ('get_person cursor = ' ||
1138: 'SELECT ac.employee_id, ac.resource_id, count(cas_id)
1139: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_cases_vl wi,ar_collectors ac
1140: WHERE hp.party_id = p_party_id
1141: and rs.resource_id = ac.resource_id

Line 1166: iex_debug_pub.logmessage ('idx= ' || idx);

1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164: FOR r_person IN c_get_person LOOP
1165: idx := idx + 1;
1166: iex_debug_pub.logmessage ('idx= ' || idx);
1167: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1168: x_resource_tab(idx).resource_id := r_person.resource_id;
1169: x_resource_tab(idx).person_id := r_person.employee_id;
1170: End LOOP;

Line 1167: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);

1163:
1164: FOR r_person IN c_get_person LOOP
1165: idx := idx + 1;
1166: iex_debug_pub.logmessage ('idx= ' || idx);
1167: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1168: x_resource_tab(idx).resource_id := r_person.resource_id;
1169: x_resource_tab(idx).person_id := r_person.employee_id;
1170: End LOOP;
1171:

Line 1180: iex_debug_pub.logmessage ('**** END get_case_resources ************');

1176:
1177: -- Standard call to get message count and if count is 1, get message info
1178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1179:
1180: iex_debug_pub.logmessage ('**** END get_case_resources ************');
1181:
1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR THEN
1184: ROLLBACK TO get_case_resources;

Line 1345: iex_debug_pub.logmessage ('**** BEGIN on all

1341: l_msg_data VARCHAR2(32767);
1342: idx NUMBER := 0;
1343: BEGIN
1344:
1345: iex_debug_pub.logmessage ('**** BEGIN on all
1346: get_billto_resources ************');
1347: iex_debug_pub.logmessage ('get_person cursor = ' ||
1348: ' SELECT ac.employee_id, ac.resource_id, count(work_item_id)
1349: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi,ar_collectors ac

Line 1347: iex_debug_pub.logmessage ('get_person cursor = ' ||

1343: BEGIN
1344:
1345: iex_debug_pub.logmessage ('**** BEGIN on all
1346: get_billto_resources ************');
1347: iex_debug_pub.logmessage ('get_person cursor = ' ||
1348: ' SELECT ac.employee_id, ac.resource_id, count(work_item_id)
1349: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi,ar_collectors ac
1350: WHERE hp.site_use_id = p_site_use_id
1351: and rs.resource_id = ac.resource_id

Line 1378: iex_debug_pub.logmessage ('idx= ' || idx);

1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375:
1376: FOR r_person IN c_get_person LOOP
1377: idx := idx + 1;
1378: iex_debug_pub.logmessage ('idx= ' || idx);
1379: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1380: x_resource_tab(idx).resource_id := r_person.resource_id;
1381: x_resource_tab(idx).person_id := r_person.employee_id;
1382: End LOOP;

Line 1379: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);

1375:
1376: FOR r_person IN c_get_person LOOP
1377: idx := idx + 1;
1378: iex_debug_pub.logmessage ('idx= ' || idx);
1379: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1380: x_resource_tab(idx).resource_id := r_person.resource_id;
1381: x_resource_tab(idx).person_id := r_person.employee_id;
1382: End LOOP;
1383:

Line 1392: iex_debug_pub.logmessage ('**** END get_billto_resources ************');

1388:
1389: -- Standard call to get message count and if count is 1, get message info
1390: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1391:
1392: iex_debug_pub.logmessage ('**** END get_billto_resources ************');
1393:
1394: EXCEPTION
1395: WHEN FND_API.G_EXC_ERROR THEN
1396: ROLLBACK TO get_assign_resources;

Line 4076: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - Start');

4072: tt_code varchar2(30); -- Bills Receivables
4073:
4074: BEGIN
4075:
4076: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - Start');
4077: -- default to no dunning letter to send
4078: l_dunning_letters := 'Y';
4079: l_amount := 0 ;
4080: l_invoice_amount := 0 ;

Line 4248: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_stage :'||l_stage);

4244:
4245: for i in l_dunningplan_lines.range_of_dunning_level_from..l_dunningplan_lines.range_of_dunning_level_to
4246: loop
4247: l_stage := i-1;
4248: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_stage :'||l_stage);
4249:
4250: if i = 1 then
4251: open c_bill_dunning_trx_null_dun_ct (l_site_use_id,
4252: l_dunningplan_lines.min_days_between_dunning,

Line 4360: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - p_running_level :'||p_running_level);

4356: close c_billto_dist_inv_cur;
4357:
4358: elsif (l_cust_account_id is not null ) Then -- account level calculation
4359: --l_dunning_letters := 'N'; --initially set it no
4360: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - p_running_level :'||p_running_level);
4361: if p_running_level = 'ACCOUNT' then
4362: open c_acc_dist_inv_cur(l_cust_account_id,l_org_id);
4363: loop
4364: fetch c_acc_dist_inv_cur into l_invoice_currency_code;

Line 4368: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_invoice_currency_code :'||l_invoice_currency_code);

4364: fetch c_acc_dist_inv_cur into l_invoice_currency_code;
4365: if c_acc_dist_inv_cur%notfound then
4366: exit;
4367: end if;
4368: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_invoice_currency_code :'||l_invoice_currency_code);
4369:
4370: open c_acc_min_dunn_amt (l_cust_account_id, l_invoice_currency_code);
4371: fetch c_acc_min_dunn_amt into l_min_dunning_amount, l_min_dunning_invoice_amount;
4372: /*

Line 4379: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount :'||l_min_dunning_amount);

4375: l_inc_inv_curr (i) := l_invoice_currency_code;
4376: end if;
4377: */
4378: close c_acc_min_dunn_amt;
4379: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount :'||l_min_dunning_amount);
4380: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_invoice_amount :'||l_min_dunning_invoice_amount);
4381:
4382: if l_min_dunning_amount is null then
4383: l_min_dunning_amount := 0;

Line 4380: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_invoice_amount :'||l_min_dunning_invoice_amount);

4376: end if;
4377: */
4378: close c_acc_min_dunn_amt;
4379: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount :'||l_min_dunning_amount);
4380: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_invoice_amount :'||l_min_dunning_invoice_amount);
4381:
4382: if l_min_dunning_amount is null then
4383: l_min_dunning_amount := 0;
4384: end if;

Line 4409: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_stage :'||l_stage);

4405: for i in l_dunningplan_lines.range_of_dunning_level_from..l_dunningplan_lines.range_of_dunning_level_to
4406: loop
4407: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - i: ' || i);
4408: l_stage := i-1;
4409: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_stage :'||l_stage);
4410:
4411: if i = 1 then
4412: open c_acc_dunning_trx_null_dun_ct (l_cust_account_id,
4413: l_dunningplan_lines.min_days_between_dunning,

Line 4422: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);

4418: l_min_dunning_invoice_amount,
4419: l_org_id);
4420: fetch c_acc_dunning_trx_null_dun_ct into l_amount;
4421: close c_acc_dunning_trx_null_dun_ct;
4422: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);
4423: else
4424:
4425: open c_acc_dunning_trx_ct (l_cust_account_id,
4426: l_stage,

Line 4435: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);

4431: l_min_dunning_invoice_amount,
4432: l_org_id);
4433: fetch c_acc_dunning_trx_ct into l_amount;
4434: close c_acc_dunning_trx_ct;
4435: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);
4436: end if;
4437: l_tot_amt_due_rem := nvl(l_tot_amt_due_rem,0) + nvl(l_amount,0);
4438: end loop;
4439: end loop;

Line 4458: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_tot_amt_due_rem: ' || l_tot_amt_due_rem);

4454: close c_cm_ar_amount_account_curr;
4455: l_tot_amt_due_rem := nvl(l_tot_amt_due_rem,0) + nvl(l_cm_ar_total_amount,0);
4456: --If any currency group satisfies the condition then we have to send the dunning letter,
4457: --so no need to check for other currencies.
4458: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_tot_amt_due_rem: ' || l_tot_amt_due_rem);
4459: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount: ' || l_min_dunning_amount);
4460: if l_tot_amt_due_rem >= l_min_dunning_amount then
4461: --l_dunning_letters := 'Y';
4462: i := i +1;

Line 4459: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount: ' || l_min_dunning_amount);

4455: l_tot_amt_due_rem := nvl(l_tot_amt_due_rem,0) + nvl(l_cm_ar_total_amount,0);
4456: --If any currency group satisfies the condition then we have to send the dunning letter,
4457: --so no need to check for other currencies.
4458: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_tot_amt_due_rem: ' || l_tot_amt_due_rem);
4459: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount: ' || l_min_dunning_amount);
4460: if l_tot_amt_due_rem >= l_min_dunning_amount then
4461: --l_dunning_letters := 'Y';
4462: i := i +1;
4463: l_inc_inv_curr (i) := l_invoice_currency_code;

Line 4475: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_invoice_currency_code :'||l_invoice_currency_code);

4471: fetch c_cus_dist_inv_cur into l_invoice_currency_code;
4472: if c_cus_dist_inv_cur%notfound then
4473: exit;
4474: end if;
4475: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_invoice_currency_code :'||l_invoice_currency_code);
4476:
4477: open c_acc_min_dunn_amt (l_cust_account_id, l_invoice_currency_code);
4478: fetch c_acc_min_dunn_amt into l_min_dunning_amount, l_min_dunning_invoice_amount;
4479: /*

Line 4486: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount :'||l_min_dunning_amount);

4482: l_inc_inv_curr (i) := l_invoice_currency_code;
4483: end if;
4484: */
4485: close c_acc_min_dunn_amt;
4486: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount :'||l_min_dunning_amount);
4487: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_invoice_amount :'||l_min_dunning_invoice_amount);
4488:
4489: if l_min_dunning_amount is null then
4490: l_min_dunning_amount := 0;

Line 4487: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_invoice_amount :'||l_min_dunning_invoice_amount);

4483: end if;
4484: */
4485: close c_acc_min_dunn_amt;
4486: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount :'||l_min_dunning_amount);
4487: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_invoice_amount :'||l_min_dunning_invoice_amount);
4488:
4489: if l_min_dunning_amount is null then
4490: l_min_dunning_amount := 0;
4491: end if;

Line 4516: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_stage :'||l_stage);

4512: for i in l_dunningplan_lines.range_of_dunning_level_from..l_dunningplan_lines.range_of_dunning_level_to
4513: loop
4514: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - i: ' || i);
4515: l_stage := i-1;
4516: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_stage :'||l_stage);
4517:
4518: if i = 1 then
4519: open c_cus_dunning_trx_null_dun_ct (l_party_id,
4520: l_dunningplan_lines.min_days_between_dunning,

Line 4529: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);

4525: l_min_dunning_invoice_amount,
4526: l_org_id);
4527: fetch c_cus_dunning_trx_null_dun_ct into l_amount;
4528: close c_cus_dunning_trx_null_dun_ct;
4529: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);
4530: else
4531:
4532: open c_cus_dunning_trx_ct (l_party_id,
4533: l_stage,

Line 4542: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);

4538: l_min_dunning_invoice_amount,
4539: l_org_id);
4540: fetch c_cus_dunning_trx_ct into l_amount;
4541: close c_cus_dunning_trx_ct;
4542: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_amount: ' || l_amount);
4543: end if;
4544: l_tot_amt_due_rem := nvl(l_tot_amt_due_rem,0) + nvl(l_amount,0);
4545: end loop;
4546: end loop;

Line 4565: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_tot_amt_due_rem: ' || l_tot_amt_due_rem);

4561: l_tot_amt_due_rem := nvl(l_tot_amt_due_rem,0) + nvl(l_cm_ar_total_amount,0);
4562:
4563: --If any currency group satisfies the condition then we have to send the dunning letter,
4564: --so no need to check for other currencies.
4565: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_tot_amt_due_rem: ' || l_tot_amt_due_rem);
4566: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount: ' || l_min_dunning_amount);
4567: if l_tot_amt_due_rem >= l_min_dunning_amount then
4568: --l_dunning_letters := 'Y';
4569: i := i +1;

Line 4566: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount: ' || l_min_dunning_amount);

4562:
4563: --If any currency group satisfies the condition then we have to send the dunning letter,
4564: --so no need to check for other currencies.
4565: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_tot_amt_due_rem: ' || l_tot_amt_due_rem);
4566: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_min_dunning_amount: ' || l_min_dunning_amount);
4567: if l_tot_amt_due_rem >= l_min_dunning_amount then
4568: --l_dunning_letters := 'Y';
4569: i := i +1;
4570: l_inc_inv_curr (i) := l_invoice_currency_code;

Line 4577: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_inc_inv_curr.count: '|| l_inc_inv_curr.count);

4573: close c_cus_dist_inv_cur;
4574: end if;
4575: end if;
4576:
4577: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - l_inc_inv_curr.count: '|| l_inc_inv_curr.count);
4578: if l_inc_inv_curr.count = 0 then
4579: l_dunning_letters := 'N';
4580: else
4581: l_dunning_letters := 'Y';

Line 4587: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - End');

4583:
4584: p_inc_inv_curr := l_inc_inv_curr;
4585: p_dunning_letters := l_dunning_letters;
4586:
4587: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - End');
4588:
4589: EXCEPTION
4590: WHEN OTHERS THEN
4591: raise;

Line 4622: iex_debug_pub.LogMessage (p_msg);

4618: Procedure WriteLog ( p_msg IN VARCHAR2)
4619: IS
4620: BEGIN
4621: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4622: iex_debug_pub.LogMessage (p_msg);
4623: END IF;
4624:
4625: END WriteLog;
4626:

Line 4923: iex_debug_pub.logmessage ('**** BEGIN get_assigned_collector ************');

4919: c_collector c_cur_type;
4920:
4921: BEGIN
4922:
4923: iex_debug_pub.logmessage ('**** BEGIN get_assigned_collector ************');
4924:
4925:
4926: SAVEPOINT get_assigned_collector;
4927:

Line 5143: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');

5139: --End Bug#5229763 schekuri 27-Jul-2006
5140:
5141: -- End SQL statements
5142:
5143: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5144: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5145: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5146: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5147:

Line 5144: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);

5140:
5141: -- End SQL statements
5142:
5143: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5144: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5145: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5146: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5147:
5148: --if p_level = 'PARTY' or p_level = 'ACCOUNT' or p_level = 'BILLTO' then

Line 5145: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);

5141: -- End SQL statements
5142:
5143: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5144: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5145: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5146: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5147:
5148: --if p_level = 'PARTY' or p_level = 'ACCOUNT' or p_level = 'BILLTO' then
5149: if p_level <> 'CASE' then --Modified for Bug#5229763 schekuri 27-Jul-2006

Line 5146: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);

5142:
5143: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5144: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5145: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5146: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5147:
5148: --if p_level = 'PARTY' or p_level = 'ACCOUNT' or p_level = 'BILLTO' then
5149: if p_level <> 'CASE' then --Modified for Bug#5229763 schekuri 27-Jul-2006
5150: OPEN c_collector FOR l_query USING p_level_id, p_level_id, p_level_id;

Line 5169: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);

5165: if c_collector%notfound then
5166: exit;
5167: end if;
5168:
5169: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);
5170: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);
5171: End LOOP;
5172:
5173: CLOSE c_collector;

Line 5170: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);

5166: exit;
5167: end if;
5168:
5169: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);
5170: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);
5171: End LOOP;
5172:
5173: CLOSE c_collector;
5174:

Line 5183: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');

5179:
5180: -- Standard call to get message count and if count is 1, get message info
5181: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5182:
5183: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');
5184:
5185: EXCEPTION
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: ROLLBACK TO get_assigned_collector;

Line 5244: iex_debug_pub.logmessage ('**** BEGIN get_dunning_resource ************');

5240: c_collector c_cur_type;
5241:
5242: BEGIN
5243:
5244: iex_debug_pub.logmessage ('**** BEGIN get_dunning_resource ************');
5245:
5246:
5247: SAVEPOINT get_dunning_resource;
5248:

Line 5304: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');

5300: l_query := l_select1 || l_where1 || ' and hp.party_id = :1 and hp.cust_account_id <> -1 and hp.site_use_id is null ' ;
5301: l_query := l_query || l_union || l_select2 || l_where2 || ' and hp.party_id = :1 and hp.cust_account_id <> -1 and hp.site_use_id is null ' ;
5302: end if;
5303:
5304: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5306: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5307: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5308:

Line 5305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);

5301: l_query := l_query || l_union || l_select2 || l_where2 || ' and hp.party_id = :1 and hp.cust_account_id <> -1 and hp.site_use_id is null ' ;
5302: end if;
5303:
5304: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5306: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5307: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5308:
5309: OPEN c_collector FOR l_query USING p_level_id, p_level_id;

Line 5306: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);

5302: end if;
5303:
5304: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5306: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5307: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5308:
5309: OPEN c_collector FOR l_query USING p_level_id, p_level_id;
5310:

Line 5307: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);

5303:
5304: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5306: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
5307: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
5308:
5309: OPEN c_collector FOR l_query USING p_level_id, p_level_id;
5310:
5311: LOOP

Line 5319: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);

5315: if c_collector%notfound then
5316: exit;
5317: end if;
5318:
5319: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);
5320: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);
5321: End LOOP;
5322:
5323: CLOSE c_collector;

Line 5320: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);

5316: exit;
5317: end if;
5318:
5319: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);
5320: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);
5321: End LOOP;
5322:
5323: CLOSE c_collector;
5324:

Line 5333: iex_debug_pub.logmessage ('**** END get_dunning_resource ************');

5329:
5330: -- Standard call to get message count and if count is 1, get message info
5331: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5332:
5333: iex_debug_pub.logmessage ('**** END get_dunning_resource ************');
5334:
5335: EXCEPTION
5336: WHEN FND_API.G_EXC_ERROR THEN
5337: ROLLBACK TO get_dunning_resource;

Line 5403: iex_debug_pub.logmessage ('**** BEGIN get_grace_days ************');

5399: l_grace_days number := 0;
5400:
5401: BEGIN
5402:
5403: iex_debug_pub.logmessage ('**** BEGIN get_grace_days ************');
5404:
5405:
5406: SAVEPOINT get_grace_days;
5407:

Line 5423: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');

5419: END IF;
5420:
5421: x_return_status := FND_API.G_RET_STS_SUCCESS;
5422:
5423: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5424: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id: ' || p_party_id);
5426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_account_id: ' || p_account_id);
5427: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_site_use_id: ' || p_site_use_id);

Line 5424: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);

5420:
5421: x_return_status := FND_API.G_RET_STS_SUCCESS;
5422:
5423: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5424: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id: ' || p_party_id);
5426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_account_id: ' || p_account_id);
5427: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_site_use_id: ' || p_site_use_id);
5428:

Line 5425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id: ' || p_party_id);

5421: x_return_status := FND_API.G_RET_STS_SUCCESS;
5422:
5423: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5424: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id: ' || p_party_id);
5426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_account_id: ' || p_account_id);
5427: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_site_use_id: ' || p_site_use_id);
5428:
5429: if p_level = 'PARTY' then

Line 5426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_account_id: ' || p_account_id);

5422:
5423: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5424: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id: ' || p_party_id);
5426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_account_id: ' || p_account_id);
5427: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_site_use_id: ' || p_site_use_id);
5428:
5429: if p_level = 'PARTY' then
5430: open c_gracedays_party_level (p_party_id);

Line 5427: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_site_use_id: ' || p_site_use_id);

5423: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
5424: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
5425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id: ' || p_party_id);
5426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_account_id: ' || p_account_id);
5427: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_site_use_id: ' || p_site_use_id);
5428:
5429: if p_level = 'PARTY' then
5430: open c_gracedays_party_level (p_party_id);
5431: fetch c_gracedays_party_level into l_grace_days;

Line 5444: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_grace_days: ' || l_grace_days);

5440: open c_gracedays_billto_level (p_party_id, p_account_id, p_site_use_id);
5441: fetch c_gracedays_billto_level into l_grace_days;
5442: close c_gracedays_billto_level;
5443: end if;
5444: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_grace_days: ' || l_grace_days);
5445:
5446: x_grace_days := l_grace_days;
5447:
5448: -- Standard check of p_commit

Line 5456: iex_debug_pub.logmessage ('**** END get_grace_days ************');

5452:
5453: -- Standard call to get message count and if count is 1, get message info
5454: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5455:
5456: iex_debug_pub.logmessage ('**** END get_grace_days ************');
5457:
5458: EXCEPTION
5459: WHEN FND_API.G_EXC_ERROR THEN
5460: ROLLBACK TO get_grace_days;

Line 5492: iex_debug_pub.logmessage ('Start CheckContractStatus');

5488: return varchar2 is
5489: l_contract_status VARCHAR2(10) := 'CURRENT';
5490: l_count NUMBER := 0;
5491: BEGIN
5492: iex_debug_pub.logmessage ('Start CheckContractStatus');
5493: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
5494:
5495: IF p_contract_number IS NOT NULL then
5496: select count(1) into l_count

Line 5493: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);

5489: l_contract_status VARCHAR2(10) := 'CURRENT';
5490: l_count NUMBER := 0;
5491: BEGIN
5492: iex_debug_pub.logmessage ('Start CheckContractStatus');
5493: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
5494:
5495: IF p_contract_number IS NOT NULL then
5496: select count(1) into l_count
5497: from iex_delinquencies_all del,ra_customer_trx_lines_all trl

Line 5509: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);

5505: else
5506: l_contract_status := 'CURRENT';
5507: end if;
5508: END IF;
5509: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
5510: iex_debug_pub.logmessage ('End CheckContractStatus');
5511: return l_contract_status;
5512: EXCEPTION
5513: WHEN OTHERS THEN

Line 5510: iex_debug_pub.logmessage ('End CheckContractStatus');

5506: l_contract_status := 'CURRENT';
5507: end if;
5508: END IF;
5509: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
5510: iex_debug_pub.logmessage ('End CheckContractStatus');
5511: return l_contract_status;
5512: EXCEPTION
5513: WHEN OTHERS THEN
5514: iex_debug_pub.logmessage ('CheckContractStatus: In other exception');

Line 5514: iex_debug_pub.logmessage ('CheckContractStatus: In other exception');

5510: iex_debug_pub.logmessage ('End CheckContractStatus');
5511: return l_contract_status;
5512: EXCEPTION
5513: WHEN OTHERS THEN
5514: iex_debug_pub.logmessage ('CheckContractStatus: In other exception');
5515: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
5516: return l_contract_status;
5517: END;
5518: --End bug 6723556 gnramasa 11th Jan 08

Line 5515: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);

5511: return l_contract_status;
5512: EXCEPTION
5513: WHEN OTHERS THEN
5514: iex_debug_pub.logmessage ('CheckContractStatus: In other exception');
5515: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
5516: return l_contract_status;
5517: END;
5518: --End bug 6723556 gnramasa 11th Jan 08
5519:

Line 5551: iex_debug_pub.logmessage ('Begin copy_cust_acct_value');

5547: p_fe_cust_acct_rec IN DBMS_SQL.NUMBER_TABLE
5548: ) is
5549: l_count number;
5550: begin
5551: iex_debug_pub.logmessage ('Begin copy_cust_acct_value');
5552: l_count := p_fe_cust_acct_rec.count;
5553: iex_debug_pub.logmessage ('copy_cust_acct_value, l_count: ' || l_count);
5554: p_be_cust_acct_rec.delete;
5555: for i in 1..l_count loop

Line 5553: iex_debug_pub.logmessage ('copy_cust_acct_value, l_count: ' || l_count);

5549: l_count number;
5550: begin
5551: iex_debug_pub.logmessage ('Begin copy_cust_acct_value');
5552: l_count := p_fe_cust_acct_rec.count;
5553: iex_debug_pub.logmessage ('copy_cust_acct_value, l_count: ' || l_count);
5554: p_be_cust_acct_rec.delete;
5555: for i in 1..l_count loop
5556: p_be_cust_acct_rec(i) := p_fe_cust_acct_rec(i);
5557: iex_debug_pub.logmessage ('p_be_cust_acct_rec('||i||') : ' || p_be_cust_acct_rec(i));

Line 5557: iex_debug_pub.logmessage ('p_be_cust_acct_rec('||i||') : ' || p_be_cust_acct_rec(i));

5553: iex_debug_pub.logmessage ('copy_cust_acct_value, l_count: ' || l_count);
5554: p_be_cust_acct_rec.delete;
5555: for i in 1..l_count loop
5556: p_be_cust_acct_rec(i) := p_fe_cust_acct_rec(i);
5557: iex_debug_pub.logmessage ('p_be_cust_acct_rec('||i||') : ' || p_be_cust_acct_rec(i));
5558: end loop;
5559: iex_debug_pub.logmessage ('End copy_cust_acct_value');
5560: End copy_cust_acct_value;
5561:

Line 5559: iex_debug_pub.logmessage ('End copy_cust_acct_value');

5555: for i in 1..l_count loop
5556: p_be_cust_acct_rec(i) := p_fe_cust_acct_rec(i);
5557: iex_debug_pub.logmessage ('p_be_cust_acct_rec('||i||') : ' || p_be_cust_acct_rec(i));
5558: end loop;
5559: iex_debug_pub.logmessage ('End copy_cust_acct_value');
5560: End copy_cust_acct_value;
5561:
5562: --this function accepts cust_account_id. If this value exists in the pl/sql table
5563: --then it will return 'Y', else 'N'

Line 5571: iex_debug_pub.logmessage ('Begin cust_acct_id_check');

5567: )
5568: return varchar is
5569: l_count number;
5570: begin
5571: iex_debug_pub.logmessage ('Begin cust_acct_id_check');
5572: iex_debug_pub.logmessage ('cust_acct_id_check, p_cust_acct_id: ' || p_cust_acct_id);
5573: l_count := p_be_cust_acct_rec.count;
5574: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
5575: for i in 1..l_count loop

Line 5572: iex_debug_pub.logmessage ('cust_acct_id_check, p_cust_acct_id: ' || p_cust_acct_id);

5568: return varchar is
5569: l_count number;
5570: begin
5571: iex_debug_pub.logmessage ('Begin cust_acct_id_check');
5572: iex_debug_pub.logmessage ('cust_acct_id_check, p_cust_acct_id: ' || p_cust_acct_id);
5573: l_count := p_be_cust_acct_rec.count;
5574: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
5575: for i in 1..l_count loop
5576: if p_be_cust_acct_rec(i) = p_cust_acct_id then

Line 5574: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);

5570: begin
5571: iex_debug_pub.logmessage ('Begin cust_acct_id_check');
5572: iex_debug_pub.logmessage ('cust_acct_id_check, p_cust_acct_id: ' || p_cust_acct_id);
5573: l_count := p_be_cust_acct_rec.count;
5574: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
5575: for i in 1..l_count loop
5576: if p_be_cust_acct_rec(i) = p_cust_acct_id then
5577: iex_debug_pub.logmessage ('cust_acct_id_check, value exists in pl/sql table, so returning Y');
5578: return 'Y'; -- value exists in pl/sql table, so return 'Y'

Line 5577: iex_debug_pub.logmessage ('cust_acct_id_check, value exists in pl/sql table, so returning Y');

5573: l_count := p_be_cust_acct_rec.count;
5574: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
5575: for i in 1..l_count loop
5576: if p_be_cust_acct_rec(i) = p_cust_acct_id then
5577: iex_debug_pub.logmessage ('cust_acct_id_check, value exists in pl/sql table, so returning Y');
5578: return 'Y'; -- value exists in pl/sql table, so return 'Y'
5579: end if;
5580: end loop;
5581: iex_debug_pub.logmessage ('End cust_acct_id_check');

Line 5581: iex_debug_pub.logmessage ('End cust_acct_id_check');

5577: iex_debug_pub.logmessage ('cust_acct_id_check, value exists in pl/sql table, so returning Y');
5578: return 'Y'; -- value exists in pl/sql table, so return 'Y'
5579: end if;
5580: end loop;
5581: iex_debug_pub.logmessage ('End cust_acct_id_check');
5582: iex_debug_pub.logmessage ('cust_acct_id_check, value doesn''t exists in pl/sql table, so returning N');
5583: return 'N'; -- value doesn't exists in pl/sql table, so return 'N'
5584: End cust_acct_id_check;
5585: --End bug 6717279 by gnramasa 25th Aug 08

Line 5582: iex_debug_pub.logmessage ('cust_acct_id_check, value doesn''t exists in pl/sql table, so returning N');

5578: return 'Y'; -- value exists in pl/sql table, so return 'Y'
5579: end if;
5580: end loop;
5581: iex_debug_pub.logmessage ('End cust_acct_id_check');
5582: iex_debug_pub.logmessage ('cust_acct_id_check, value doesn''t exists in pl/sql table, so returning N');
5583: return 'N'; -- value doesn't exists in pl/sql table, so return 'N'
5584: End cust_acct_id_check;
5585: --End bug 6717279 by gnramasa 25th Aug 08
5586:

Line 5731: iex_debug_pub.logmessage('Started '||G_PKG_NAME || '.' || l_api_name || ' +');

5727: l_api_name CONSTANT VARCHAR2(30) := 'REPLACE_SPECIAL_CHARS';
5728: l_xml VARCHAR2(32767);
5729:
5730: BEGIN
5731: iex_debug_pub.logmessage('Started '||G_PKG_NAME || '.' || l_api_name || ' +');
5732: l_xml := REPLACE(P_XML_DATA,'&','&');
5733: l_xml := REPLACE(l_xml,'&amp;','&');
5734: RETURN l_xml;
5735:

Line 5738: iex_debug_pub.logmessage('Eror in '||G_PKG_NAME || '.' || l_api_name|| ' -');

5734: RETURN l_xml;
5735:
5736: EXCEPTION
5737: WHEN OTHERS THEN
5738: iex_debug_pub.logmessage('Eror in '||G_PKG_NAME || '.' || l_api_name|| ' -');
5739: RAISE;
5740: END REPLACE_SPECIAL_CHARS;
5741: -- end bug 13594457 by sunagesh on 23-jan-2012
5742: