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_UTILITIES dependencies on IEX_DEBUG_PUB

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

532: idx NUMBER := 0;
533: BEGIN
534:
535: IF PG_DEBUG < 10 THEN
536: iex_debug_pub.logmessage ('**** BEGIN get_access_resources ************');
537: iex_debug_pub.logmessage ('get_person cursor = ' ||
538: 'SELECT DISTINCT hp.employee_id
539: FROM hz_customer_profiles hp,ar_collectors ac
540: WHERE m.person_id = ac.employee_id

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

533: BEGIN
534:
535: IF PG_DEBUG < 10 THEN
536: iex_debug_pub.logmessage ('**** BEGIN get_access_resources ************');
537: iex_debug_pub.logmessage ('get_person cursor = ' ||
538: 'SELECT DISTINCT hp.employee_id
539: FROM hz_customer_profiles hp,ar_collectors ac
540: WHERE m.person_id = ac.employee_id
541: AND hp.collector_id = ac.collector_id

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

563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564:
565: FOR r_person IN c_get_person LOOP
566: IF PG_DEBUG < 10 THEN
567: iex_debug_pub.logmessage ('employee_id = ' || r_person.employee_id);
568: END IF;
569: OPEN c_get_resource(r_person.employee_id);
570: FETCH c_get_resource INTO l_resource_row;
571: IF c_get_resource%FOUND THEN

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

570: FETCH c_get_resource INTO l_resource_row;
571: IF c_get_resource%FOUND THEN
572: idx := idx + 1;
573: IF PG_DEBUG < 10 THEN
574: iex_debug_pub.logmessage ('idx= ' || idx);
575: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
576: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
577: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
578: END IF;

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

571: IF c_get_resource%FOUND THEN
572: idx := idx + 1;
573: IF PG_DEBUG < 10 THEN
574: iex_debug_pub.logmessage ('idx= ' || idx);
575: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
576: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
577: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
578: END IF;
579: x_resource_tab(idx).resource_id := l_resource_row.resource_id;

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

572: idx := idx + 1;
573: IF PG_DEBUG < 10 THEN
574: iex_debug_pub.logmessage ('idx= ' || idx);
575: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
576: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
577: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
578: END IF;
579: x_resource_tab(idx).resource_id := l_resource_row.resource_id;
580: x_resource_tab(idx).user_id := l_resource_row.user_id;

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

573: IF PG_DEBUG < 10 THEN
574: iex_debug_pub.logmessage ('idx= ' || idx);
575: iex_debug_pub.logmessage ('l_resource_row.resource_id = ' || l_resource_row.resource_id);
576: iex_debug_pub.logmessage ('l_resource_row.user_name = ' || l_resource_row.user_name);
577: iex_debug_pub.logmessage ('l_resource_row.source_name = ' || l_resource_row.source_name);
578: END IF;
579: x_resource_tab(idx).resource_id := l_resource_row.resource_id;
580: x_resource_tab(idx).user_id := l_resource_row.user_id;
581: x_resource_tab(idx).person_id := l_resource_row.source_id;

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

593: -- Standard call to get message count and if count is 1, get message info
594: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
595:
596: IF PG_DEBUG < 10 THEN
597: iex_debug_pub.logmessage ('**** END get_access_resources ************');
598: END IF;
599:
600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN

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

733: l_msg_data VARCHAR2(32767);
734: idx NUMBER := 0;
735: BEGIN
736:
737: iex_debug_pub.logmessage ('**** BEGIN on all
738: get_access_resources ************');
739: l_init_msg_list := p_init_msg_list;
740: iex_debug_pub.logmessage ('get_person cursor = ' ||
741: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||

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

736:
737: iex_debug_pub.logmessage ('**** BEGIN on all
738: get_access_resources ************');
739: l_init_msg_list := p_init_msg_list;
740: iex_debug_pub.logmessage ('get_person cursor = ' ||
741: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||
742: ' FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi, '||
743: ' ar_collectors ac ' ||
744: ' WHERE hp.party_id = p_party_id ' ||

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

767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:
769: FOR r_person IN c_get_person LOOP
770: idx := idx + 1;
771: iex_debug_pub.logmessage ('idx= ' || idx);
772: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
773: x_resource_tab(idx).resource_id := r_person.resource_id;
774: x_resource_tab(idx).person_id := r_person.employee_id;
775: End LOOP;*/

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

768:
769: FOR r_person IN c_get_person LOOP
770: idx := idx + 1;
771: iex_debug_pub.logmessage ('idx= ' || idx);
772: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
773: x_resource_tab(idx).resource_id := r_person.resource_id;
774: x_resource_tab(idx).person_id := r_person.employee_id;
775: End LOOP;*/
776:

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

790:
791: -- Standard call to get message count and if count is 1, get message info
792: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
793:
794: iex_debug_pub.logmessage ('**** END get_access_resources ************');
795:
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO get_assign_resources;

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

906: l_msg_data VARCHAR2(32767);
907: idx NUMBER := 0;
908: BEGIN
909:
910: iex_debug_pub.logmessage ('**** BEGIN on all
911: get_access_resources ************');
912: l_init_msg_list := p_init_msg_list;
913: iex_debug_pub.logmessage ('get_person cursor = ' ||
914: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||

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

909:
910: iex_debug_pub.logmessage ('**** BEGIN on all
911: get_access_resources ************');
912: l_init_msg_list := p_init_msg_list;
913: iex_debug_pub.logmessage ('get_person cursor = ' ||
914: 'SELECT ac.employee_id, ac.resource_id, count(work_item_id) ' ||
915: ' FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi, '||
916: ' ar_collectors ac ' ||
917: ' WHERE hp.party_id = p_party_id ' ||

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

940: x_return_status := FND_API.G_RET_STS_SUCCESS;
941:
942: FOR r_person IN c_get_person LOOP
943: idx := idx + 1;
944: iex_debug_pub.logmessage ('idx= ' || idx);
945: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
946: x_resource_tab(idx).resource_id := r_person.resource_id;
947: x_resource_tab(idx).person_id := r_person.employee_id;
948: End LOOP;*/

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

941:
942: FOR r_person IN c_get_person LOOP
943: idx := idx + 1;
944: iex_debug_pub.logmessage ('idx= ' || idx);
945: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
946: x_resource_tab(idx).resource_id := r_person.resource_id;
947: x_resource_tab(idx).person_id := r_person.employee_id;
948: End LOOP;*/
949:

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

963:
964: -- Standard call to get message count and if count is 1, get message info
965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
966:
967: iex_debug_pub.logmessage ('**** END get_access_resources ************');
968:
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO get_assign_account_resources;

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

1023: l_msg_data VARCHAR2(32767);
1024: idx NUMBER := 0;
1025: BEGIN
1026:
1027: iex_debug_pub.logmessage ('**** BEGIN get_case_resources ************');
1028: iex_debug_pub.logmessage ('get_person cursor = ' ||
1029: 'SELECT ac.employee_id, ac.resource_id, count(cas_id)
1030: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_cases_vl wi,ar_collectors ac
1031: WHERE hp.party_id = p_party_id

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

1024: idx NUMBER := 0;
1025: BEGIN
1026:
1027: iex_debug_pub.logmessage ('**** BEGIN get_case_resources ************');
1028: iex_debug_pub.logmessage ('get_person cursor = ' ||
1029: 'SELECT ac.employee_id, ac.resource_id, count(cas_id)
1030: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_cases_vl wi,ar_collectors ac
1031: WHERE hp.party_id = p_party_id
1032: and rs.resource_id = ac.resource_id

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

1053: x_return_status := FND_API.G_RET_STS_SUCCESS;
1054:
1055: FOR r_person IN c_get_person LOOP
1056: idx := idx + 1;
1057: iex_debug_pub.logmessage ('idx= ' || idx);
1058: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1059: x_resource_tab(idx).resource_id := r_person.resource_id;
1060: x_resource_tab(idx).person_id := r_person.employee_id;
1061: End LOOP;

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

1054:
1055: FOR r_person IN c_get_person LOOP
1056: idx := idx + 1;
1057: iex_debug_pub.logmessage ('idx= ' || idx);
1058: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1059: x_resource_tab(idx).resource_id := r_person.resource_id;
1060: x_resource_tab(idx).person_id := r_person.employee_id;
1061: End LOOP;
1062:

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

1067:
1068: -- Standard call to get message count and if count is 1, get message info
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070:
1071: iex_debug_pub.logmessage ('**** END get_case_resources ************');
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO get_case_resources;

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

1232: l_msg_data VARCHAR2(32767);
1233: idx NUMBER := 0;
1234: BEGIN
1235:
1236: iex_debug_pub.logmessage ('**** BEGIN on all
1237: get_billto_resources ************');
1238: iex_debug_pub.logmessage ('get_person cursor = ' ||
1239: ' SELECT ac.employee_id, ac.resource_id, count(work_item_id)
1240: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi,ar_collectors ac

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

1234: BEGIN
1235:
1236: iex_debug_pub.logmessage ('**** BEGIN on all
1237: get_billto_resources ************');
1238: iex_debug_pub.logmessage ('get_person cursor = ' ||
1239: ' SELECT ac.employee_id, ac.resource_id, count(work_item_id)
1240: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs, iex_strategy_work_items wi,ar_collectors ac
1241: WHERE hp.site_use_id = p_site_use_id
1242: and rs.resource_id = ac.resource_id

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

1265: x_return_status := FND_API.G_RET_STS_SUCCESS;
1266:
1267: FOR r_person IN c_get_person LOOP
1268: idx := idx + 1;
1269: iex_debug_pub.logmessage ('idx= ' || idx);
1270: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1271: x_resource_tab(idx).resource_id := r_person.resource_id;
1272: x_resource_tab(idx).person_id := r_person.employee_id;
1273: End LOOP;

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

1266:
1267: FOR r_person IN c_get_person LOOP
1268: idx := idx + 1;
1269: iex_debug_pub.logmessage ('idx= ' || idx);
1270: iex_debug_pub.logmessage ('r_person.salesforce_id = ' || r_person.resource_id);
1271: x_resource_tab(idx).resource_id := r_person.resource_id;
1272: x_resource_tab(idx).person_id := r_person.employee_id;
1273: End LOOP;
1274:

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

1279:
1280: -- Standard call to get message count and if count is 1, get message info
1281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1282:
1283: iex_debug_pub.logmessage ('**** END get_billto_resources ************');
1284:
1285: EXCEPTION
1286: WHEN FND_API.G_EXC_ERROR THEN
1287: ROLLBACK TO get_assign_resources;

Line 1857: iex_debug_pub.LogMessage (p_msg);

1853: Procedure WriteLog ( p_msg IN VARCHAR2)
1854: IS
1855: BEGIN
1856: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1857: iex_debug_pub.LogMessage (p_msg);
1858: END IF;
1859:
1860: END WriteLog;
1861:

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

2154: c_collector c_cur_type;
2155:
2156: BEGIN
2157:
2158: iex_debug_pub.logmessage ('**** BEGIN get_assigned_collector ************');
2159:
2160:
2161: SAVEPOINT get_assigned_collector;
2162:

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

2351: --End Bug#5229763 schekuri 27-Jul-2006
2352:
2353: -- End SQL statements
2354:
2355: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
2356: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
2357: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
2358: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
2359:

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

2352:
2353: -- End SQL statements
2354:
2355: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
2356: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
2357: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
2358: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
2359:
2360: --if p_level = 'PARTY' or p_level = 'ACCOUNT' or p_level = 'BILLTO' then

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

2353: -- End SQL statements
2354:
2355: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
2356: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
2357: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
2358: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
2359:
2360: --if p_level = 'PARTY' or p_level = 'ACCOUNT' or p_level = 'BILLTO' then
2361: if p_level <> 'CASE' then --Modified for Bug#5229763 schekuri 27-Jul-2006

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

2354:
2355: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Parameters: ');
2356: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level: ' || p_level);
2357: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_level_id: ' || p_level_id);
2358: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data query is: ' || l_query);
2359:
2360: --if p_level = 'PARTY' or p_level = 'ACCOUNT' or p_level = 'BILLTO' then
2361: if p_level <> 'CASE' then --Modified for Bug#5229763 schekuri 27-Jul-2006
2362: OPEN c_collector FOR l_query USING p_level_id, p_level_id, p_level_id;

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

2377: if c_collector%notfound then
2378: exit;
2379: end if;
2380:
2381: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);
2382: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);
2383: End LOOP;
2384:
2385: CLOSE c_collector;

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

2378: exit;
2379: end if;
2380:
2381: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'idx= ' || idx);
2382: iex_debug_pub.logmessage (G_PKG_NAME || '.' || l_api_name || 'collector_resource_id = ' || x_resource_tab(idx).person_id);
2383: End LOOP;
2384:
2385: CLOSE c_collector;
2386:

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

2391:
2392: -- Standard call to get message count and if count is 1, get message info
2393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2394:
2395: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');
2396:
2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO get_assigned_collector;

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

2427: return varchar2 is
2428: l_contract_status VARCHAR2(10) := 'CURRENT';
2429: l_count NUMBER := 0;
2430: BEGIN
2431: iex_debug_pub.logmessage ('Start CheckContractStatus');
2432: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
2433:
2434: IF p_contract_number IS NOT NULL then
2435: select count(1) into l_count

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

2428: l_contract_status VARCHAR2(10) := 'CURRENT';
2429: l_count NUMBER := 0;
2430: BEGIN
2431: iex_debug_pub.logmessage ('Start CheckContractStatus');
2432: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
2433:
2434: IF p_contract_number IS NOT NULL then
2435: select count(1) into l_count
2436: from iex_delinquencies_all del,ra_customer_trx_lines_all trl

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

2444: else
2445: l_contract_status := 'CURRENT';
2446: end if;
2447: END IF;
2448: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
2449: iex_debug_pub.logmessage ('End CheckContractStatus');
2450: return l_contract_status;
2451: EXCEPTION
2452: WHEN OTHERS THEN

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

2445: l_contract_status := 'CURRENT';
2446: end if;
2447: END IF;
2448: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
2449: iex_debug_pub.logmessage ('End CheckContractStatus');
2450: return l_contract_status;
2451: EXCEPTION
2452: WHEN OTHERS THEN
2453: iex_debug_pub.logmessage ('CheckContractStatus: In other exception');

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

2449: iex_debug_pub.logmessage ('End CheckContractStatus');
2450: return l_contract_status;
2451: EXCEPTION
2452: WHEN OTHERS THEN
2453: iex_debug_pub.logmessage ('CheckContractStatus: In other exception');
2454: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
2455: return l_contract_status;
2456: END;
2457: --End bug 6723556 gnramasa 11th Jan 08

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

2450: return l_contract_status;
2451: EXCEPTION
2452: WHEN OTHERS THEN
2453: iex_debug_pub.logmessage ('CheckContractStatus: In other exception');
2454: iex_debug_pub.logmessage ('CheckContractStatus : l_contract_status :' || l_contract_status);
2455: return l_contract_status;
2456: END;
2457: --End bug 6723556 gnramasa 11th Jan 08
2458:

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

2486: p_fe_cust_acct_rec IN DBMS_SQL.NUMBER_TABLE
2487: ) is
2488: l_count number;
2489: begin
2490: iex_debug_pub.logmessage ('Begin copy_cust_acct_value');
2491: l_count := p_fe_cust_acct_rec.count;
2492: iex_debug_pub.logmessage ('copy_cust_acct_value, l_count: ' || l_count);
2493: p_be_cust_acct_rec.delete;
2494: for i in 1..l_count loop

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

2488: l_count number;
2489: begin
2490: iex_debug_pub.logmessage ('Begin copy_cust_acct_value');
2491: l_count := p_fe_cust_acct_rec.count;
2492: iex_debug_pub.logmessage ('copy_cust_acct_value, l_count: ' || l_count);
2493: p_be_cust_acct_rec.delete;
2494: for i in 1..l_count loop
2495: p_be_cust_acct_rec(i) := p_fe_cust_acct_rec(i);
2496: iex_debug_pub.logmessage ('p_be_cust_acct_rec('||i||') : ' || p_be_cust_acct_rec(i));

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

2492: iex_debug_pub.logmessage ('copy_cust_acct_value, l_count: ' || l_count);
2493: p_be_cust_acct_rec.delete;
2494: for i in 1..l_count loop
2495: p_be_cust_acct_rec(i) := p_fe_cust_acct_rec(i);
2496: iex_debug_pub.logmessage ('p_be_cust_acct_rec('||i||') : ' || p_be_cust_acct_rec(i));
2497: end loop;
2498: iex_debug_pub.logmessage ('End copy_cust_acct_value');
2499: End copy_cust_acct_value;
2500:

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

2494: for i in 1..l_count loop
2495: p_be_cust_acct_rec(i) := p_fe_cust_acct_rec(i);
2496: iex_debug_pub.logmessage ('p_be_cust_acct_rec('||i||') : ' || p_be_cust_acct_rec(i));
2497: end loop;
2498: iex_debug_pub.logmessage ('End copy_cust_acct_value');
2499: End copy_cust_acct_value;
2500:
2501: --this function accepts cust_account_id. If this value exists in the pl/sql table
2502: --then it will return 'Y', else 'N'

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

2506: )
2507: return varchar is
2508: l_count number;
2509: begin
2510: iex_debug_pub.logmessage ('Begin cust_acct_id_check');
2511: iex_debug_pub.logmessage ('cust_acct_id_check, p_cust_acct_id: ' || p_cust_acct_id);
2512: l_count := p_be_cust_acct_rec.count;
2513: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
2514: for i in 1..l_count loop

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

2507: return varchar is
2508: l_count number;
2509: begin
2510: iex_debug_pub.logmessage ('Begin cust_acct_id_check');
2511: iex_debug_pub.logmessage ('cust_acct_id_check, p_cust_acct_id: ' || p_cust_acct_id);
2512: l_count := p_be_cust_acct_rec.count;
2513: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
2514: for i in 1..l_count loop
2515: if p_be_cust_acct_rec(i) = p_cust_acct_id then

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

2509: begin
2510: iex_debug_pub.logmessage ('Begin cust_acct_id_check');
2511: iex_debug_pub.logmessage ('cust_acct_id_check, p_cust_acct_id: ' || p_cust_acct_id);
2512: l_count := p_be_cust_acct_rec.count;
2513: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
2514: for i in 1..l_count loop
2515: if p_be_cust_acct_rec(i) = p_cust_acct_id then
2516: iex_debug_pub.logmessage ('cust_acct_id_check, value exists in pl/sql table, so returning Y');
2517: return 'Y'; -- value exists in pl/sql table, so return 'Y'

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

2512: l_count := p_be_cust_acct_rec.count;
2513: iex_debug_pub.logmessage ('cust_acct_id_check, l_count: ' || l_count);
2514: for i in 1..l_count loop
2515: if p_be_cust_acct_rec(i) = p_cust_acct_id then
2516: iex_debug_pub.logmessage ('cust_acct_id_check, value exists in pl/sql table, so returning Y');
2517: return 'Y'; -- value exists in pl/sql table, so return 'Y'
2518: end if;
2519: end loop;
2520: iex_debug_pub.logmessage ('End cust_acct_id_check');

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

2516: iex_debug_pub.logmessage ('cust_acct_id_check, value exists in pl/sql table, so returning Y');
2517: return 'Y'; -- value exists in pl/sql table, so return 'Y'
2518: end if;
2519: end loop;
2520: iex_debug_pub.logmessage ('End cust_acct_id_check');
2521: iex_debug_pub.logmessage ('cust_acct_id_check, value doesn''t exists in pl/sql table, so returning N');
2522: return 'N'; -- value doesn't exists in pl/sql table, so return 'N'
2523: End cust_acct_id_check;
2524: --End bug 6717279 by gnramasa 25th Aug 08

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

2517: return 'Y'; -- value exists in pl/sql table, so return 'Y'
2518: end if;
2519: end loop;
2520: iex_debug_pub.logmessage ('End cust_acct_id_check');
2521: iex_debug_pub.logmessage ('cust_acct_id_check, value doesn''t exists in pl/sql table, so returning N');
2522: return 'N'; -- value doesn't exists in pl/sql table, so return 'N'
2523: End cust_acct_id_check;
2524: --End bug 6717279 by gnramasa 25th Aug 08
2525: