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.WSH_REGIONS_PKG dependencies on WSH_REGIONS_SEARCH_PKG

Line 408: x_parent_region_info OUT NOCOPY wsh_regions_search_pkg.region_rec,

404: p_lang_code IN VARCHAR2,
405: p_interface_flag IN VARCHAR2,
406: p_user_id IN NUMBER,
407: p_insert_parent_flag IN VARCHAR2,
408: x_parent_region_info OUT NOCOPY wsh_regions_search_pkg.region_rec,
409: p_conc_request_flag IN VARCHAR2 DEFAULT 'N')
410: IS
411: l_parent_region_id_non_tl number;
412: l_parent_region_id_tl number;

Line 418: l_region_info wsh_regions_search_pkg.region_rec;

414: l_existing_parent_region_id number;
415: l_tl_only_flag varchar2(1);
416: l_status varchar2(1);
417: l_error_msg varchar2(200);
418: l_region_info wsh_regions_search_pkg.region_rec;
419: l_return_status varchar2(1);
420: --
421: l_debug_on BOOLEAN;
422: --

Line 466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO_CODE', WSH_DEBUG_SV.C_PROC_LEVEL);

462: --
463: -- Debug Statements
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO_CODE', WSH_DEBUG_SV.C_PROC_LEVEL);
467: END IF;
468: --
469: WSH_REGIONS_SEARCH_PKG.Check_Region_Info_Code(
470: p_country => p_country,

Line 469: WSH_REGIONS_SEARCH_PKG.Check_Region_Info_Code(

465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO_CODE', WSH_DEBUG_SV.C_PROC_LEVEL);
467: END IF;
468: --
469: WSH_REGIONS_SEARCH_PKG.Check_Region_Info_Code(
470: p_country => p_country,
471: p_state => p_state,
472: p_city => p_city,
473: p_country_code => p_country_code,

Line 483: fnd_file.put_line(fnd_file.log,'Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Info_Code');

479: x_return_status => l_return_status,
480: x_region_info => l_region_info);
481:
482: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
483: fnd_file.put_line(fnd_file.log,'Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Info_Code');
484: fnd_file.put_line(fnd_file.log,'Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );
485: l_region_info.region_id := -1;
486: return;
487: END IF;

Line 493: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

489: --
490: -- Debug Statements
491: --
492: IF l_debug_on THEN
493: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
494: END IF;
495: --
496: Wsh_Regions_Search_Pkg.Get_Region_Info(
497: p_country => p_country,

Line 496: Wsh_Regions_Search_Pkg.Get_Region_Info(

492: IF l_debug_on THEN
493: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
494: END IF;
495: --
496: Wsh_Regions_Search_Pkg.Get_Region_Info(
497: p_country => p_country,
498: p_country_region => p_country_region,
499: p_state => p_state,
500: p_city => p_city,

Line 531: fnd_file.put_line(fnd_file.log,'1. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');

527: (p_state_code IS NULL OR p_state IS NOT NULL) AND
528: (p_country_code IS NULL OR p_country IS NOT NULL)) THEN
529:
530: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
531: fnd_file.put_line(fnd_file.log,'1. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');
532: fnd_file.put_line(fnd_file.log,'1. Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );
533: l_region_info.region_id := -1;
534: return;
535: END IF;

Line 542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);

538: --
539: -- Debug Statements
540: --
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);
543: END IF;
544: --
545: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
546: p_country_code => p_country_code,

Line 545: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(

541: IF l_debug_on THEN
542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);
543: END IF;
544: --
545: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
546: p_country_code => p_country_code,
547: p_state_code => p_state_code,
548: p_city_code => p_city_code,
549: p_postal_code_from => null,

Line 557: fnd_file.put_line(fnd_file.log,'2. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');

553: x_return_status => l_return_status,
554: x_region_id => l_check_tl_id);
555:
556: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
557: fnd_file.put_line(fnd_file.log,'2. Error Occured in WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only');
558: fnd_file.put_line(fnd_file.log,'2. Error Message : '|| fnd_message.get_string('WSH', 'WSH_UTIL_MESSAGE_U') );
559: l_region_info.region_id := -1;
560: return;
561: END IF;

Line 568: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);

564: --
565: -- Debug Statements
566: --
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
569: END IF;
570: --
571: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
572: p_country_code => p_country_code,

Line 571: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(

567: IF l_debug_on THEN
568: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
569: END IF;
570: --
571: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
572: p_country_code => p_country_code,
573: p_country_region_code => p_country_region_code,
574: p_state_code => p_state_code,
575: p_city_code => p_city_code,

Line 741: l_parent_region_info wsh_regions_search_pkg.region_rec;

737: IS
738: l_region_type NUMBER := 0;
739: l_parent_offset NUMBER := 1;
740: l_parent_region_type NUMBER := 0;
741: l_parent_region_info wsh_regions_search_pkg.region_rec;
742: l_region_id NUMBER;
743: l_return_status VARCHAR2(1);
744:
745: --

Line 1145: l_region_info wsh_regions_search_pkg.region_rec;

1141: l_existing_region_id number;
1142: l_tl_only_flag varchar2(1);
1143: l_status number;
1144: l_error_msg varchar2(200);
1145: l_region_info wsh_regions_search_pkg.region_rec;
1146: l_parent_zone_level number;
1147: l_update_state_code wsh_regions.state_code%type;
1148: l_update_city_code wsh_regions.city_code%type;
1149: l_return_status VARCHAR2(1);

Line 1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

1274: --
1275: -- Debug Statements
1276: --
1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: --
1281: WSH_REGIONS_SEARCH_PKG.Check_Region_Info(
1282: p_country => p_country,

Line 1281: WSH_REGIONS_SEARCH_PKG.Check_Region_Info(

1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: --
1281: WSH_REGIONS_SEARCH_PKG.Check_Region_Info(
1282: p_country => p_country,
1283: p_state => null,
1284: p_city => null,
1285: p_postal_code_from => null,

Line 1304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY', WSH_DEBUG_SV.C_PROC_LEVEL);

1300: --
1301: -- Debug Statements
1302: --
1303: IF l_debug_on THEN
1304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY', WSH_DEBUG_SV.C_PROC_LEVEL);
1305: END IF;
1306: --
1307: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1308: p_country_code => p_country_code,

Line 1307: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(

1303: IF l_debug_on THEN
1304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY', WSH_DEBUG_SV.C_PROC_LEVEL);
1305: END IF;
1306: --
1307: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1308: p_country_code => p_country_code,
1309: p_state_code => null,
1310: p_city_code => null,
1311: p_postal_code_from => null,

Line 1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);

1326: --
1327: -- Debug Statements
1328: --
1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);
1331: END IF;
1332: --
1333: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1334: p_country_code => p_country_code,

Line 1333: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(

1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);
1331: END IF;
1332: --
1333: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1334: p_country_code => p_country_code,
1335: p_state_code => null,
1336: p_city_code => null,
1337: p_postal_code_from => null,

Line 1360: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

1356: --
1357: -- Debug Statements
1358: --
1359: IF l_debug_on THEN
1360: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1361: END IF;
1362: --
1363: Wsh_Regions_Search_Pkg.Get_Region_Info(
1364: p_country => p_country,

Line 1363: Wsh_Regions_Search_Pkg.Get_Region_Info(

1359: IF l_debug_on THEN
1360: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1361: END IF;
1362: --
1363: Wsh_Regions_Search_Pkg.Get_Region_Info(
1364: p_country => p_country,
1365: p_country_region => null,
1366: p_state => null,
1367: p_city => null,

Line 1384: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);

1380: --
1381: -- Debug Statements
1382: --
1383: IF l_debug_on THEN
1384: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
1385: END IF;
1386: --
1387: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
1388: p_country_code => p_country_code,

Line 1387: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(

1383: IF l_debug_on THEN
1384: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
1385: END IF;
1386: --
1387: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
1388: p_country_code => p_country_code,
1389: p_country_region_code => null,
1390: p_state_code => null,
1391: p_city_code => null,

Line 1434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

1430: --
1431: -- Debug Statements
1432: --
1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1435: END IF;
1436: --
1437: Wsh_Regions_Search_Pkg.Get_Region_Info(
1438: p_country => p_country,

Line 1437: Wsh_Regions_Search_Pkg.Get_Region_Info(

1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1435: END IF;
1436: --
1437: Wsh_Regions_Search_Pkg.Get_Region_Info(
1438: p_country => p_country,
1439: p_country_region => p_country_region,
1440: p_state => p_state,
1441: p_city => p_city,

Line 1467: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);

1463: --
1464: -- Debug Statements
1465: --
1466: IF l_debug_on THEN
1467: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
1468: END IF;
1469: --
1470: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
1471: p_country_code => p_country_code,

Line 1470: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(

1466: IF l_debug_on THEN
1467: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
1468: END IF;
1469: --
1470: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
1471: p_country_code => p_country_code,
1472: p_country_region_code => p_country_region_code,
1473: p_state_code => p_state_code,
1474: p_city_code => p_city_code,

Line 1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

1571: --
1572: -- Debug Statements
1573: --
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1576: END IF;
1577: --
1578: WSH_REGIONS_SEARCH_PKG.Check_Region_Info(
1579: p_country => p_country,

Line 1578: WSH_REGIONS_SEARCH_PKG.Check_Region_Info(

1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1576: END IF;
1577: --
1578: WSH_REGIONS_SEARCH_PKG.Check_Region_Info(
1579: p_country => p_country,
1580: p_state => p_state,
1581: p_city => p_city,
1582: p_postal_code_from => p_postal_code_from,

Line 1601: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

1597: --
1598: -- Debug Statements
1599: --
1600: IF l_debug_on THEN
1601: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1602: END IF;
1603: --
1604: Wsh_Regions_Search_Pkg.Get_Region_Info(
1605: p_country => p_country,

Line 1604: Wsh_Regions_Search_Pkg.Get_Region_Info(

1600: IF l_debug_on THEN
1601: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1602: END IF;
1603: --
1604: Wsh_Regions_Search_Pkg.Get_Region_Info(
1605: p_country => p_country,
1606: p_country_region => p_country_region,
1607: p_state => p_state,
1608: p_city => p_city,

Line 1635: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY', WSH_DEBUG_SV.C_PROC_LEVEL);

1631: --
1632: -- Debug Statements
1633: --
1634: IF l_debug_on THEN
1635: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY', WSH_DEBUG_SV.C_PROC_LEVEL);
1636: END IF;
1637: --
1638: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1639: p_country_code => p_country_code,

Line 1638: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(

1634: IF l_debug_on THEN
1635: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY', WSH_DEBUG_SV.C_PROC_LEVEL);
1636: END IF;
1637: --
1638: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1639: p_country_code => p_country_code,
1640: p_state_code => p_state_code,
1641: p_city_code => p_city_code,
1642: p_postal_code_from => p_postal_code_from,

Line 1661: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);

1657: --
1658: -- Debug Statements
1659: --
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);
1662: END IF;
1663: --
1664: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1665: p_country_code => p_country_code,

Line 1664: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(

1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.CHECK_REGION_ID_CODES_ONLY WITH LANGUAGE', WSH_DEBUG_SV.C_PROC_LEVEL);
1662: END IF;
1663: --
1664: WSH_REGIONS_SEARCH_PKG.Check_Region_Id_Codes_Only(
1665: p_country_code => p_country_code,
1666: p_state_code => p_state_code,
1667: p_city_code => p_city_code,
1668: p_postal_code_from => p_postal_code_from,

Line 1687: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);

1683: --
1684: -- Debug Statements
1685: --
1686: IF l_debug_on THEN
1687: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
1688: END IF;
1689: --
1690: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
1691: p_country_code => p_country_code,

Line 1690: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(

1686: IF l_debug_on THEN
1687: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_ID_CODES_ONLY',WSH_DEBUG_SV.C_PROC_LEVEL);
1688: END IF;
1689: --
1690: Wsh_Regions_Search_Pkg.Get_Region_Id_Codes_Only(
1691: p_country_code => p_country_code,
1692: p_country_region_code => p_country_region_code,
1693: p_state_code => p_state_code,
1694: p_city_code => p_city_code,

Line 3128: l_region_info wsh_regions_search_pkg.region_rec;

3124: SELECT region_type
3125: FROM wsh_regions
3126: WHERE region_id = p_region_id;
3127:
3128: l_region_info wsh_regions_search_pkg.region_rec;
3129: l_existing_region_id NUMBER;
3130: l_zone_level NUMBER;
3131: l_region_count NUMBER;
3132:

Line 3182: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

3178: --
3179: -- Debug Statements
3180: --
3181: IF l_debug_on THEN
3182: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
3183: END IF;
3184: --
3185: Wsh_Regions_Search_Pkg.Get_Region_Info(
3186: p_country => p_country,

Line 3185: Wsh_Regions_Search_Pkg.Get_Region_Info(

3181: IF l_debug_on THEN
3182: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
3183: END IF;
3184: --
3185: Wsh_Regions_Search_Pkg.Get_Region_Info(
3186: p_country => p_country,
3187: p_country_region => null,
3188: p_state => p_state,
3189: p_city => p_city,

Line 3228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

3224: --
3225: -- Debug Statements
3226: --
3227: IF l_debug_on THEN
3228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
3229: END IF;
3230: --
3231: Wsh_Regions_Search_Pkg.Get_Region_Info(
3232: p_country => p_country,

Line 3231: Wsh_Regions_Search_Pkg.Get_Region_Info(

3227: IF l_debug_on THEN
3228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_REGION_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
3229: END IF;
3230: --
3231: Wsh_Regions_Search_Pkg.Get_Region_Info(
3232: p_country => p_country,
3233: p_country_region => null,
3234: p_state => null,
3235: p_city => null,