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.ARH_ADDR_PKG dependencies on STANDARD

Line 794: arp_standard.debug('EXCEPTION: arh_addr_pkg.delete_customer_alt_names');

790: --
791: --
792: exception
793: when OTHERS then
794: arp_standard.debug('EXCEPTION: arh_addr_pkg.delete_customer_alt_names');
795: end delete_customer_alt_names;
796: --
797: --
798: --

Line 1278: arp_standard.debug('ARHADDRB:Insert Row: After Insert into hz_cust_Acct_sites');

1274:
1275: END IF;
1276: --}
1277:
1278: arp_standard.debug('ARHADDRB:Insert Row: After Insert into hz_cust_Acct_sites');
1279:
1280: IF ( x_address_mode = 'QUICK' ) THEN
1281: IF ( x_su_bill_to_flag = 'Y' ) THEN
1282: insert_site_use (X_Cust_account_id,x_address_id,'BILL_TO',x_msg_count,x_msg_data, x_return_status);

Line 1285: arp_standard.debug('After insert_site_use bill_to call ');

1281: IF ( x_su_bill_to_flag = 'Y' ) THEN
1282: insert_site_use (X_Cust_account_id,x_address_id,'BILL_TO',x_msg_count,x_msg_data, x_return_status);
1283: END IF;
1284: --
1285: arp_standard.debug('After insert_site_use bill_to call ');
1286: --
1287: IF ( x_su_ship_to_flag = 'Y' ) THEN
1288: insert_site_use (X_Cust_account_id,x_address_id,'SHIP_TO',x_msg_count,x_msg_data, x_return_status);
1289: END IF;

Line 1291: arp_standard.debug('After insert_site_use ship_to call ');

1287: IF ( x_su_ship_to_flag = 'Y' ) THEN
1288: insert_site_use (X_Cust_account_id,x_address_id,'SHIP_TO',x_msg_count,x_msg_data, x_return_status);
1289: END IF;
1290: --
1291: arp_standard.debug('After insert_site_use ship_to call ');
1292: --
1293: IF ( x_su_market_flag = 'Y' ) THEN
1294: insert_site_use (X_Cust_account_id,x_address_id,'MARKET',x_msg_count,x_msg_data, x_return_status);
1295: END IF;

Line 1297: arp_standard.debug('After insert_site_use market call ');

1293: IF ( x_su_market_flag = 'Y' ) THEN
1294: insert_site_use (X_Cust_account_id,x_address_id,'MARKET',x_msg_count,x_msg_data, x_return_status);
1295: END IF;
1296: --
1297: arp_standard.debug('After insert_site_use market call ');
1298: --
1299: IF ( x_su_stmt_flag = 'Y' ) THEN
1300: insert_site_use (X_Cust_account_id,x_address_id,'STMTS',x_msg_count,x_msg_data, x_return_status);
1301: END IF;

Line 1303: arp_standard.debug('After insert_site_use stmts call ');

1299: IF ( x_su_stmt_flag = 'Y' ) THEN
1300: insert_site_use (X_Cust_account_id,x_address_id,'STMTS',x_msg_count,x_msg_data, x_return_status);
1301: END IF;
1302: --
1303: arp_standard.debug('After insert_site_use stmts call ');
1304: --
1305: IF ( x_su_dun_flag = 'Y' ) THEN
1306: insert_site_use (X_Cust_account_id,x_address_id,'DUN',x_msg_count,x_msg_data, x_return_status);
1307: END IF;

Line 1309: arp_standard.debug('After insert_site_use dun call ');

1305: IF ( x_su_dun_flag = 'Y' ) THEN
1306: insert_site_use (X_Cust_account_id,x_address_id,'DUN',x_msg_count,x_msg_data, x_return_status);
1307: END IF;
1308: --
1309: arp_standard.debug('After insert_site_use dun call ');
1310: --
1311: IF ( x_su_legal_flag = 'Y' ) THEN
1312: insert_site_use (X_Cust_account_id,x_address_id,'LEGAL',x_msg_count,x_msg_data, x_return_status);
1313: END IF;

Line 1315: arp_standard.debug('After insert_site_use legal call ');

1311: IF ( x_su_legal_flag = 'Y' ) THEN
1312: insert_site_use (X_Cust_account_id,x_address_id,'LEGAL',x_msg_count,x_msg_data, x_return_status);
1313: END IF;
1314: --
1315: arp_standard.debug('After insert_site_use legal call ');
1316: --
1317: ELSIF ( x_address_mode = 'STANDARD' ) then
1318: null;
1319: ELSE

Line 1317: ELSIF ( x_address_mode = 'STANDARD' ) then

1313: END IF;
1314: --
1315: arp_standard.debug('After insert_site_use legal call ');
1316: --
1317: ELSIF ( x_address_mode = 'STANDARD' ) then
1318: null;
1319: ELSE
1320: app_exception.invalid_argument('arp_addr_pkg.Insert_Row', 'x_address_mode', x_address_mode);
1321: END IF;

Line 1324: IF ( arp_standard.sysparm.address_validation = 'WARN' ) THEN

1320: app_exception.invalid_argument('arp_addr_pkg.Insert_Row', 'x_address_mode', x_address_mode);
1321: END IF;
1322: --
1323: --
1324: IF ( arp_standard.sysparm.address_validation = 'WARN' ) THEN
1325: x_address_warning := arp_adds.location_segment_inserted;
1326: END IF;
1327: --
1328: --

Line 1329: arp_standard.debug('AROADDRB:Insert Row: END');

1325: x_address_warning := arp_adds.location_segment_inserted;
1326: END IF;
1327: --
1328: --
1329: arp_standard.debug('AROADDRB:Insert Row: END');
1330: --
1331: END Insert_Row;
1332:
1333:

Line 1730: --Bug #1402584 de-activating a cust_acct_site from the customer standard form also de-activates the corresponding party_site.Hence commenting the psite_rec.status.

1726:
1727: --{HYU evaluation bug#5209119
1728: -- psite_rec.language := INIT_SWITCH(x_language);
1729: --}
1730: --Bug #1402584 de-activating a cust_acct_site from the customer standard form also de-activates the corresponding party_site.Hence commenting the psite_rec.status.
1731: --psite_rec.status := x_status;
1732: --Start bug fix 2910364, Commented the following lines of code
1733: -- psite_rec.Attribute_Category := INIT_SWITCH(X_Attribute_Category);
1734: -- psite_rec.attribute1 := INIT_SWITCH(X_Attribute1);

Line 1955: ELSIF ( x_address_mode = 'STANDARD' ) THEN

1951: x_msg_count => x_msg_count,
1952: x_msg_data => x_msg_data,
1953: x_return_status => x_return_status);
1954:
1955: ELSIF ( x_address_mode = 'STANDARD' ) THEN
1956: null;
1957: ELSE
1958: app_exception.invalid_argument('arp_addr_pkg.Insert_Row', 'x_address_mode',
1959: x_address_mode);

Line 1964: IF ( arp_standard.sysparm.address_validation = 'WARN' ) THEN

1960:
1961: END IF;
1962: --
1963: --
1964: IF ( arp_standard.sysparm.address_validation = 'WARN' ) THEN
1965: x_address_warning := arp_adds.location_segment_inserted;
1966: END IF;
1967: --
1968: --

Line 2584: arp_standard.debug('check_printed_trx +');

2580: l_location_rec hz_location_v2pub.location_rec_type;
2581: tmp_var VARCHAR2(2000);
2582: tmp_var1 VARCHAR2(2000);
2583: BEGIN
2584: arp_standard.debug('check_printed_trx +');
2585: x_return_status := FND_API.G_RET_STS_SUCCESS;
2586: x_printed_trx_loc_modified := 'N';
2587: --Check system option
2588: /* Commented for bug 4605384*/

Line 2619: arp_standard.debug(' check_value:'||check_value);

2615: end if;
2616: END LOOP;
2617: close c_org_for_loc;
2618: /*End bug 4605384*/
2619: arp_standard.debug(' check_value:'||check_value);
2620: -- if check_value = 'Y' no processing required user can update addresses
2621:
2622: IF check_value = 'N' THEN
2623:

Line 2654: arp_standard.debug(' loc_modified:'||loc_modified);

2650: x_Sales_Tax_Inside_City_Limits => x_Sales_Tax_Inside_City_Limits,
2651: x_loc_updated => loc_modified);
2652: --}
2653: --
2654: arp_standard.debug(' loc_modified:'||loc_modified);
2655:
2656: -- any transaction printed with this location
2657: IF loc_modified = 'Y' THEN
2658: --

Line 2680: arp_standard.debug('check_printed_trx -');

2676: CLOSE c_cust_addrs;
2677: END IF;
2678: END IF;
2679: END IF;
2680: arp_standard.debug('check_printed_trx -');
2681: --
2682: EXCEPTION
2683: WHEN AR_NO_ROW_IN_SYSTEM_PARAMETERS THEN
2684: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;

Line 2692: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_printed_trx');

2688: FND_MSG_PUB.Count_And_Get(
2689: p_encoded => FND_API.G_FALSE,
2690: p_count => x_msg_count,
2691: p_data => x_msg_data);
2692: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_printed_trx');
2693: IF x_msg_count > 1 THEN
2694: FOR i IN 1..x_msg_count LOOP
2695: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2696: tmp_var1 := tmp_var1 || ' '|| tmp_var;

Line 2710: arp_standard.debug('EXCEPTION OTHERS in check_printed_trx :'||SQLERRM);

2706: FND_MSG_PUB.Count_And_Get(
2707: p_encoded => FND_API.G_FALSE,
2708: p_count => x_msg_count,
2709: p_data => x_msg_data);
2710: arp_standard.debug('EXCEPTION OTHERS in check_printed_trx :'||SQLERRM);
2711: IF x_msg_count > 1 THEN
2712: FOR i IN 1..x_msg_count LOOP
2713: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2714: tmp_var1 := tmp_var1 || ' '|| tmp_var;

Line 2771: arp_standard.debug('check_addr_modif_allowed +');

2767: l_location_rec hz_location_v2pub.location_rec_type;
2768: tmp_var VARCHAR2(2000);
2769: tmp_var1 VARCHAR2(2000);
2770: BEGIN
2771: arp_standard.debug('check_addr_modif_allowed +');
2772: x_return_status := FND_API.G_RET_STS_SUCCESS;
2773: x_loc_modif_allowed := 'Y';
2774: --Check system option
2775: /*Bug 4605384 as per consistency check for modification of address allowed*/

Line 2807: arp_standard.debug(' check_value:'||check_value);

2803: END LOOP;
2804: close c_org_for_loc;
2805: /*End bug 4605384*/
2806:
2807: arp_standard.debug(' check_value:'||check_value);
2808: -- if check_value = 'Y' no processing required user can update addresses
2809:
2810: IF check_value = 'N' THEN
2811:

Line 2834: arp_standard.debug('check_addr_modif_allowed -');

2830: CLOSE c_cust_addrs;
2831: END IF;
2832:
2833: END IF;
2834: arp_standard.debug('check_addr_modif_allowed -');
2835: --
2836: EXCEPTION
2837: WHEN AR_NO_ROW_IN_SYSTEM_PARAMETERS THEN
2838: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;

Line 2846: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_addr_modif_allowed');

2842: FND_MSG_PUB.Count_And_Get(
2843: p_encoded => FND_API.G_FALSE,
2844: p_count => x_msg_count,
2845: p_data => x_msg_data);
2846: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_addr_modif_allowed');
2847: IF x_msg_count > 1 THEN
2848: FOR i IN 1..x_msg_count LOOP
2849: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2850: tmp_var1 := tmp_var1 || ' '|| tmp_var;

Line 2864: arp_standard.debug('EXCEPTION OTHERS in check_addr_modif_allowed :'||SQLERRM);

2860: FND_MSG_PUB.Count_And_Get(
2861: p_encoded => FND_API.G_FALSE,
2862: p_count => x_msg_count,
2863: p_data => x_msg_data);
2864: arp_standard.debug('EXCEPTION OTHERS in check_addr_modif_allowed :'||SQLERRM);
2865: IF x_msg_count > 1 THEN
2866: FOR i IN 1..x_msg_count LOOP
2867: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2868: tmp_var1 := tmp_var1 || ' '|| tmp_var;

Line 2926: arp_standard.debug('compare_location_existing +');

2922: WHERE location_id = p_location_id;
2923: l_location_rec hz_location_v2pub.location_rec_type;
2924: loc_modified VARCHAR2(1) := 'N';
2925: BEGIN
2926: arp_standard.debug('compare_location_existing +');
2927: arp_standard.debug(' p_location_id :'||p_location_id);
2928: IF p_location_id IS NULL THEN
2929: x_loc_updated := 'X';
2930: ELSE

Line 2927: arp_standard.debug(' p_location_id :'||p_location_id);

2923: l_location_rec hz_location_v2pub.location_rec_type;
2924: loc_modified VARCHAR2(1) := 'N';
2925: BEGIN
2926: arp_standard.debug('compare_location_existing +');
2927: arp_standard.debug(' p_location_id :'||p_location_id);
2928: IF p_location_id IS NULL THEN
2929: x_loc_updated := 'X';
2930: ELSE
2931: OPEN c_exist_loc;

Line 2958: arp_standard.debug(' p_location_rec.country :'||p_location_rec.country);

2954: l_location_rec.suite ,
2955: l_location_rec.Sales_Tax_Inside_City_Limits,
2956: l_location_rec.Sales_Tax_Geocode;
2957: IF c_exist_loc%FOUND THEN
2958: arp_standard.debug(' p_location_rec.country :'||p_location_rec.country);
2959: arp_standard.debug(' l_location_rec.country :'||l_location_rec.country);
2960: IF NVL(p_location_rec.country,fnd_api.g_miss_char) <> NVL(l_location_rec.country,fnd_api.g_miss_char) THEN
2961: loc_modified := 'Y';
2962: ELSE

Line 2959: arp_standard.debug(' l_location_rec.country :'||l_location_rec.country);

2955: l_location_rec.Sales_Tax_Inside_City_Limits,
2956: l_location_rec.Sales_Tax_Geocode;
2957: IF c_exist_loc%FOUND THEN
2958: arp_standard.debug(' p_location_rec.country :'||p_location_rec.country);
2959: arp_standard.debug(' l_location_rec.country :'||l_location_rec.country);
2960: IF NVL(p_location_rec.country,fnd_api.g_miss_char) <> NVL(l_location_rec.country,fnd_api.g_miss_char) THEN
2961: loc_modified := 'Y';
2962: ELSE
2963: l_location_rec.country := ar_miss_char;

Line 2965: arp_standard.debug(' p_location_rec.address1 :'||p_location_rec.address1);

2961: loc_modified := 'Y';
2962: ELSE
2963: l_location_rec.country := ar_miss_char;
2964: END IF;
2965: arp_standard.debug(' p_location_rec.address1 :'||p_location_rec.address1);
2966: arp_standard.debug(' l_location_rec.address1 :'||l_location_rec.address1);
2967: IF NVL(p_location_rec.address1,fnd_api.g_miss_char) <> NVL(l_location_rec.address1,fnd_api.g_miss_char) THEN
2968: loc_modified := 'Y';
2969: ELSE

Line 2966: arp_standard.debug(' l_location_rec.address1 :'||l_location_rec.address1);

2962: ELSE
2963: l_location_rec.country := ar_miss_char;
2964: END IF;
2965: arp_standard.debug(' p_location_rec.address1 :'||p_location_rec.address1);
2966: arp_standard.debug(' l_location_rec.address1 :'||l_location_rec.address1);
2967: IF NVL(p_location_rec.address1,fnd_api.g_miss_char) <> NVL(l_location_rec.address1,fnd_api.g_miss_char) THEN
2968: loc_modified := 'Y';
2969: ELSE
2970: l_location_rec.address1 := ar_miss_char;

Line 2972: arp_standard.debug(' p_location_rec.address2 :'||p_location_rec.address2);

2968: loc_modified := 'Y';
2969: ELSE
2970: l_location_rec.address1 := ar_miss_char;
2971: END IF;
2972: arp_standard.debug(' p_location_rec.address2 :'||p_location_rec.address2);
2973: arp_standard.debug(' l_location_rec.address2 :'||l_location_rec.address2);
2974: IF NVL(p_location_rec.address2,fnd_api.g_miss_char) <> NVL(l_location_rec.address2,fnd_api.g_miss_char) THEN
2975: loc_modified := 'Y';
2976: ELSE

Line 2973: arp_standard.debug(' l_location_rec.address2 :'||l_location_rec.address2);

2969: ELSE
2970: l_location_rec.address1 := ar_miss_char;
2971: END IF;
2972: arp_standard.debug(' p_location_rec.address2 :'||p_location_rec.address2);
2973: arp_standard.debug(' l_location_rec.address2 :'||l_location_rec.address2);
2974: IF NVL(p_location_rec.address2,fnd_api.g_miss_char) <> NVL(l_location_rec.address2,fnd_api.g_miss_char) THEN
2975: loc_modified := 'Y';
2976: ELSE
2977: l_location_rec.address2 := ar_miss_char;

Line 2979: arp_standard.debug(' p_location_rec.address3 :'||p_location_rec.address3);

2975: loc_modified := 'Y';
2976: ELSE
2977: l_location_rec.address2 := ar_miss_char;
2978: END IF;
2979: arp_standard.debug(' p_location_rec.address3 :'||p_location_rec.address3);
2980: arp_standard.debug(' l_location_rec.address3 :'||l_location_rec.address3);
2981: IF NVL(p_location_rec.address3,fnd_api.g_miss_char) <> NVL(l_location_rec.address3,fnd_api.g_miss_char) THEN
2982: loc_modified := 'Y';
2983: ELSE

Line 2980: arp_standard.debug(' l_location_rec.address3 :'||l_location_rec.address3);

2976: ELSE
2977: l_location_rec.address2 := ar_miss_char;
2978: END IF;
2979: arp_standard.debug(' p_location_rec.address3 :'||p_location_rec.address3);
2980: arp_standard.debug(' l_location_rec.address3 :'||l_location_rec.address3);
2981: IF NVL(p_location_rec.address3,fnd_api.g_miss_char) <> NVL(l_location_rec.address3,fnd_api.g_miss_char) THEN
2982: loc_modified := 'Y';
2983: ELSE
2984: l_location_rec.address3 := ar_miss_char;

Line 2986: arp_standard.debug(' p_location_rec.address4 :'||p_location_rec.address4);

2982: loc_modified := 'Y';
2983: ELSE
2984: l_location_rec.address3 := ar_miss_char;
2985: END IF;
2986: arp_standard.debug(' p_location_rec.address4 :'||p_location_rec.address4);
2987: arp_standard.debug(' l_location_rec.address4 :'||l_location_rec.address4);
2988: IF NVL(p_location_rec.address4,fnd_api.g_miss_char) <> NVL(l_location_rec.address4,fnd_api.g_miss_char) THEN
2989: loc_modified := 'Y';
2990: ELSE

Line 2987: arp_standard.debug(' l_location_rec.address4 :'||l_location_rec.address4);

2983: ELSE
2984: l_location_rec.address3 := ar_miss_char;
2985: END IF;
2986: arp_standard.debug(' p_location_rec.address4 :'||p_location_rec.address4);
2987: arp_standard.debug(' l_location_rec.address4 :'||l_location_rec.address4);
2988: IF NVL(p_location_rec.address4,fnd_api.g_miss_char) <> NVL(l_location_rec.address4,fnd_api.g_miss_char) THEN
2989: loc_modified := 'Y';
2990: ELSE
2991: l_location_rec.address4 := ar_miss_char;

Line 2993: arp_standard.debug(' p_location_rec.city :'||p_location_rec.city);

2989: loc_modified := 'Y';
2990: ELSE
2991: l_location_rec.address4 := ar_miss_char;
2992: END IF;
2993: arp_standard.debug(' p_location_rec.city :'||p_location_rec.city);
2994: arp_standard.debug(' l_location_rec.city :'||l_location_rec.city);
2995: IF NVL(p_location_rec.city,fnd_api.g_miss_char) <> NVL(l_location_rec.city,fnd_api.g_miss_char) THEN
2996: loc_modified := 'Y';
2997: ELSE

Line 2994: arp_standard.debug(' l_location_rec.city :'||l_location_rec.city);

2990: ELSE
2991: l_location_rec.address4 := ar_miss_char;
2992: END IF;
2993: arp_standard.debug(' p_location_rec.city :'||p_location_rec.city);
2994: arp_standard.debug(' l_location_rec.city :'||l_location_rec.city);
2995: IF NVL(p_location_rec.city,fnd_api.g_miss_char) <> NVL(l_location_rec.city,fnd_api.g_miss_char) THEN
2996: loc_modified := 'Y';
2997: ELSE
2998: l_location_rec.city := ar_miss_char;

Line 3000: arp_standard.debug(' p_location_rec.postal_code :'||p_location_rec.postal_code);

2996: loc_modified := 'Y';
2997: ELSE
2998: l_location_rec.city := ar_miss_char;
2999: END IF;
3000: arp_standard.debug(' p_location_rec.postal_code :'||p_location_rec.postal_code);
3001: arp_standard.debug(' l_location_rec.postal_code :'||l_location_rec.postal_code);
3002: IF NVL(p_location_rec.postal_code,fnd_api.g_miss_char) <> NVL(l_location_rec.postal_code,fnd_api.g_miss_char) THEN
3003: loc_modified := 'Y';
3004: ELSE

Line 3001: arp_standard.debug(' l_location_rec.postal_code :'||l_location_rec.postal_code);

2997: ELSE
2998: l_location_rec.city := ar_miss_char;
2999: END IF;
3000: arp_standard.debug(' p_location_rec.postal_code :'||p_location_rec.postal_code);
3001: arp_standard.debug(' l_location_rec.postal_code :'||l_location_rec.postal_code);
3002: IF NVL(p_location_rec.postal_code,fnd_api.g_miss_char) <> NVL(l_location_rec.postal_code,fnd_api.g_miss_char) THEN
3003: loc_modified := 'Y';
3004: ELSE
3005: l_location_rec.postal_code := ar_miss_char;

Line 3007: arp_standard.debug(' p_location_rec.state :'||p_location_rec.state);

3003: loc_modified := 'Y';
3004: ELSE
3005: l_location_rec.postal_code := ar_miss_char;
3006: END IF;
3007: arp_standard.debug(' p_location_rec.state :'||p_location_rec.state);
3008: arp_standard.debug(' l_location_rec.state :'||l_location_rec.state);
3009: IF NVL(p_location_rec.state,fnd_api.g_miss_char) <> NVL(l_location_rec.state,fnd_api.g_miss_char) THEN
3010: loc_modified := 'Y';
3011: ELSE

Line 3008: arp_standard.debug(' l_location_rec.state :'||l_location_rec.state);

3004: ELSE
3005: l_location_rec.postal_code := ar_miss_char;
3006: END IF;
3007: arp_standard.debug(' p_location_rec.state :'||p_location_rec.state);
3008: arp_standard.debug(' l_location_rec.state :'||l_location_rec.state);
3009: IF NVL(p_location_rec.state,fnd_api.g_miss_char) <> NVL(l_location_rec.state,fnd_api.g_miss_char) THEN
3010: loc_modified := 'Y';
3011: ELSE
3012: l_location_rec.state := ar_miss_char;

Line 3014: arp_standard.debug(' p_location_rec.province :'||p_location_rec.province);

3010: loc_modified := 'Y';
3011: ELSE
3012: l_location_rec.state := ar_miss_char;
3013: END IF;
3014: arp_standard.debug(' p_location_rec.province :'||p_location_rec.province);
3015: arp_standard.debug(' l_location_rec.province :'||l_location_rec.province);
3016: IF NVL(p_location_rec.province,fnd_api.g_miss_char) <> NVL(l_location_rec.province,fnd_api.g_miss_char) THEN
3017: loc_modified := 'Y';
3018: ELSE

Line 3015: arp_standard.debug(' l_location_rec.province :'||l_location_rec.province);

3011: ELSE
3012: l_location_rec.state := ar_miss_char;
3013: END IF;
3014: arp_standard.debug(' p_location_rec.province :'||p_location_rec.province);
3015: arp_standard.debug(' l_location_rec.province :'||l_location_rec.province);
3016: IF NVL(p_location_rec.province,fnd_api.g_miss_char) <> NVL(l_location_rec.province,fnd_api.g_miss_char) THEN
3017: loc_modified := 'Y';
3018: ELSE
3019: l_location_rec.province := ar_miss_char;

Line 3021: arp_standard.debug(' p_location_rec.county :'||p_location_rec.county);

3017: loc_modified := 'Y';
3018: ELSE
3019: l_location_rec.province := ar_miss_char;
3020: END IF;
3021: arp_standard.debug(' p_location_rec.county :'||p_location_rec.county);
3022: arp_standard.debug(' l_location_rec.county :'||l_location_rec.county);
3023: IF NVL(p_location_rec.county,fnd_api.g_miss_char) <> NVL(l_location_rec.county,fnd_api.g_miss_char) THEN
3024: loc_modified := 'Y';
3025: ELSE

Line 3022: arp_standard.debug(' l_location_rec.county :'||l_location_rec.county);

3018: ELSE
3019: l_location_rec.province := ar_miss_char;
3020: END IF;
3021: arp_standard.debug(' p_location_rec.county :'||p_location_rec.county);
3022: arp_standard.debug(' l_location_rec.county :'||l_location_rec.county);
3023: IF NVL(p_location_rec.county,fnd_api.g_miss_char) <> NVL(l_location_rec.county,fnd_api.g_miss_char) THEN
3024: loc_modified := 'Y';
3025: ELSE
3026: l_location_rec.county := ar_miss_char;

Line 3028: arp_standard.debug(' p_location_rec.language :'||p_location_rec.language);

3024: loc_modified := 'Y';
3025: ELSE
3026: l_location_rec.county := ar_miss_char;
3027: END IF;
3028: arp_standard.debug(' p_location_rec.language :'||p_location_rec.language);
3029: arp_standard.debug(' l_location_rec.language :'||l_location_rec.language);
3030: IF NVL(p_location_rec.language,fnd_api.g_miss_char) <> NVL(l_location_rec.language,fnd_api.g_miss_char) THEN
3031: loc_modified := 'Y';
3032: ELSE

Line 3029: arp_standard.debug(' l_location_rec.language :'||l_location_rec.language);

3025: ELSE
3026: l_location_rec.county := ar_miss_char;
3027: END IF;
3028: arp_standard.debug(' p_location_rec.language :'||p_location_rec.language);
3029: arp_standard.debug(' l_location_rec.language :'||l_location_rec.language);
3030: IF NVL(p_location_rec.language,fnd_api.g_miss_char) <> NVL(l_location_rec.language,fnd_api.g_miss_char) THEN
3031: loc_modified := 'Y';
3032: ELSE
3033: l_location_rec.language := ar_miss_char;

Line 3035: arp_standard.debug(' p_location_rec.address_lines_phonetic :'||p_location_rec.address_lines_phonetic);

3031: loc_modified := 'Y';
3032: ELSE
3033: l_location_rec.language := ar_miss_char;
3034: END IF;
3035: arp_standard.debug(' p_location_rec.address_lines_phonetic :'||p_location_rec.address_lines_phonetic);
3036: arp_standard.debug(' l_location_rec.address_lines_phonetic :'||l_location_rec.address_lines_phonetic);
3037: IF NVL(p_location_rec.address_lines_phonetic,fnd_api.g_miss_char) <> NVL(l_location_rec.address_lines_phonetic,fnd_api.g_miss_char) THEN
3038: loc_modified := 'Y';
3039: ELSE

Line 3036: arp_standard.debug(' l_location_rec.address_lines_phonetic :'||l_location_rec.address_lines_phonetic);

3032: ELSE
3033: l_location_rec.language := ar_miss_char;
3034: END IF;
3035: arp_standard.debug(' p_location_rec.address_lines_phonetic :'||p_location_rec.address_lines_phonetic);
3036: arp_standard.debug(' l_location_rec.address_lines_phonetic :'||l_location_rec.address_lines_phonetic);
3037: IF NVL(p_location_rec.address_lines_phonetic,fnd_api.g_miss_char) <> NVL(l_location_rec.address_lines_phonetic,fnd_api.g_miss_char) THEN
3038: loc_modified := 'Y';
3039: ELSE
3040: l_location_rec.address_lines_phonetic:= ar_miss_char;

Line 3042: arp_standard.debug(' p_location_rec.description :'||p_location_rec.description);

3038: loc_modified := 'Y';
3039: ELSE
3040: l_location_rec.address_lines_phonetic:= ar_miss_char;
3041: END IF;
3042: arp_standard.debug(' p_location_rec.description :'||p_location_rec.description);
3043: arp_standard.debug(' l_location_rec.description :'||l_location_rec.description);
3044: IF NVL(p_location_rec.description,fnd_api.g_miss_char) <> NVL(l_location_rec.description,fnd_api.g_miss_char) THEN
3045: loc_modified := 'Y';
3046: ELSE

Line 3043: arp_standard.debug(' l_location_rec.description :'||l_location_rec.description);

3039: ELSE
3040: l_location_rec.address_lines_phonetic:= ar_miss_char;
3041: END IF;
3042: arp_standard.debug(' p_location_rec.description :'||p_location_rec.description);
3043: arp_standard.debug(' l_location_rec.description :'||l_location_rec.description);
3044: IF NVL(p_location_rec.description,fnd_api.g_miss_char) <> NVL(l_location_rec.description,fnd_api.g_miss_char) THEN
3045: loc_modified := 'Y';
3046: ELSE
3047: l_location_rec.description:= ar_miss_char;

Line 3049: arp_standard.debug(' p_location_rec.short_description :'||p_location_rec.short_description);

3045: loc_modified := 'Y';
3046: ELSE
3047: l_location_rec.description:= ar_miss_char;
3048: END IF;
3049: arp_standard.debug(' p_location_rec.short_description :'||p_location_rec.short_description);
3050: arp_standard.debug(' l_location_rec.short_description :'||l_location_rec.short_description);
3051: IF NVL(p_location_rec.short_description,fnd_api.g_miss_char) <> NVL(l_location_rec.short_description,fnd_api.g_miss_char) THEN
3052: loc_modified := 'Y';
3053: ELSE

Line 3050: arp_standard.debug(' l_location_rec.short_description :'||l_location_rec.short_description);

3046: ELSE
3047: l_location_rec.description:= ar_miss_char;
3048: END IF;
3049: arp_standard.debug(' p_location_rec.short_description :'||p_location_rec.short_description);
3050: arp_standard.debug(' l_location_rec.short_description :'||l_location_rec.short_description);
3051: IF NVL(p_location_rec.short_description,fnd_api.g_miss_char) <> NVL(l_location_rec.short_description,fnd_api.g_miss_char) THEN
3052: loc_modified := 'Y';
3053: ELSE
3054: l_location_rec.short_description:= ar_miss_char;

Line 3056: arp_standard.debug(' p_location_rec.floor :'||p_location_rec.floor);

3052: loc_modified := 'Y';
3053: ELSE
3054: l_location_rec.short_description:= ar_miss_char;
3055: END IF;
3056: arp_standard.debug(' p_location_rec.floor :'||p_location_rec.floor);
3057: arp_standard.debug(' l_location_rec.floor :'||l_location_rec.floor);
3058: IF NVL(p_location_rec.floor,fnd_api.g_miss_char) <> NVL(l_location_rec.floor,fnd_api.g_miss_char) THEN
3059: loc_modified := 'Y';
3060: ELSE

Line 3057: arp_standard.debug(' l_location_rec.floor :'||l_location_rec.floor);

3053: ELSE
3054: l_location_rec.short_description:= ar_miss_char;
3055: END IF;
3056: arp_standard.debug(' p_location_rec.floor :'||p_location_rec.floor);
3057: arp_standard.debug(' l_location_rec.floor :'||l_location_rec.floor);
3058: IF NVL(p_location_rec.floor,fnd_api.g_miss_char) <> NVL(l_location_rec.floor,fnd_api.g_miss_char) THEN
3059: loc_modified := 'Y';
3060: ELSE
3061: l_location_rec.floor:= ar_miss_char;

Line 3063: arp_standard.debug(' p_location_rec.house_number :'||p_location_rec.house_number);

3059: loc_modified := 'Y';
3060: ELSE
3061: l_location_rec.floor:= ar_miss_char;
3062: END IF;
3063: arp_standard.debug(' p_location_rec.house_number :'||p_location_rec.house_number);
3064: arp_standard.debug(' l_location_rec.house_number :'||l_location_rec.house_number);
3065: IF NVL(p_location_rec.house_number,fnd_api.g_miss_char)<> NVL(l_location_rec.house_number,fnd_api.g_miss_char) THEN
3066: loc_modified := 'Y';
3067: ELSE

Line 3064: arp_standard.debug(' l_location_rec.house_number :'||l_location_rec.house_number);

3060: ELSE
3061: l_location_rec.floor:= ar_miss_char;
3062: END IF;
3063: arp_standard.debug(' p_location_rec.house_number :'||p_location_rec.house_number);
3064: arp_standard.debug(' l_location_rec.house_number :'||l_location_rec.house_number);
3065: IF NVL(p_location_rec.house_number,fnd_api.g_miss_char)<> NVL(l_location_rec.house_number,fnd_api.g_miss_char) THEN
3066: loc_modified := 'Y';
3067: ELSE
3068: l_location_rec.house_number:= ar_miss_char;

Line 3070: arp_standard.debug(' p_location_rec.location_directions :'||p_location_rec.location_directions);

3066: loc_modified := 'Y';
3067: ELSE
3068: l_location_rec.house_number:= ar_miss_char;
3069: END IF;
3070: arp_standard.debug(' p_location_rec.location_directions :'||p_location_rec.location_directions);
3071: arp_standard.debug(' l_location_rec.location_directions :'||l_location_rec.location_directions);
3072: IF NVL(p_location_rec.location_directions,fnd_api.g_miss_char) <> NVL(l_location_rec.location_directions,fnd_api.g_miss_char) THEN
3073: loc_modified := 'Y';
3074: ELSE

Line 3071: arp_standard.debug(' l_location_rec.location_directions :'||l_location_rec.location_directions);

3067: ELSE
3068: l_location_rec.house_number:= ar_miss_char;
3069: END IF;
3070: arp_standard.debug(' p_location_rec.location_directions :'||p_location_rec.location_directions);
3071: arp_standard.debug(' l_location_rec.location_directions :'||l_location_rec.location_directions);
3072: IF NVL(p_location_rec.location_directions,fnd_api.g_miss_char) <> NVL(l_location_rec.location_directions,fnd_api.g_miss_char) THEN
3073: loc_modified := 'Y';
3074: ELSE
3075: l_location_rec.location_directions:= ar_miss_char;

Line 3077: arp_standard.debug(' p_location_rec.postal_plus4_code :'||p_location_rec.postal_plus4_code);

3073: loc_modified := 'Y';
3074: ELSE
3075: l_location_rec.location_directions:= ar_miss_char;
3076: END IF;
3077: arp_standard.debug(' p_location_rec.postal_plus4_code :'||p_location_rec.postal_plus4_code);
3078: arp_standard.debug(' l_location_rec.postal_plus4_code :'||l_location_rec.postal_plus4_code);
3079: IF NVL(p_location_rec.postal_plus4_code,fnd_api.g_miss_char) <> NVL(l_location_rec.postal_plus4_code,fnd_api.g_miss_char) THEN
3080: loc_modified := 'Y';
3081: ELSE

Line 3078: arp_standard.debug(' l_location_rec.postal_plus4_code :'||l_location_rec.postal_plus4_code);

3074: ELSE
3075: l_location_rec.location_directions:= ar_miss_char;
3076: END IF;
3077: arp_standard.debug(' p_location_rec.postal_plus4_code :'||p_location_rec.postal_plus4_code);
3078: arp_standard.debug(' l_location_rec.postal_plus4_code :'||l_location_rec.postal_plus4_code);
3079: IF NVL(p_location_rec.postal_plus4_code,fnd_api.g_miss_char) <> NVL(l_location_rec.postal_plus4_code,fnd_api.g_miss_char) THEN
3080: loc_modified := 'Y';
3081: ELSE
3082: l_location_rec.postal_plus4_code:= ar_miss_char;

Line 3084: arp_standard.debug(' p_location_rec.po_box_number :'||p_location_rec.po_box_number);

3080: loc_modified := 'Y';
3081: ELSE
3082: l_location_rec.postal_plus4_code:= ar_miss_char;
3083: END IF;
3084: arp_standard.debug(' p_location_rec.po_box_number :'||p_location_rec.po_box_number);
3085: arp_standard.debug(' l_location_rec.po_box_number :'||l_location_rec.po_box_number);
3086:
3087: IF NVL(p_location_rec.po_box_number,fnd_api.g_miss_char) <> NVL(l_location_rec.po_box_number,fnd_api.g_miss_char) THEN
3088: loc_modified := 'Y';

Line 3085: arp_standard.debug(' l_location_rec.po_box_number :'||l_location_rec.po_box_number);

3081: ELSE
3082: l_location_rec.postal_plus4_code:= ar_miss_char;
3083: END IF;
3084: arp_standard.debug(' p_location_rec.po_box_number :'||p_location_rec.po_box_number);
3085: arp_standard.debug(' l_location_rec.po_box_number :'||l_location_rec.po_box_number);
3086:
3087: IF NVL(p_location_rec.po_box_number,fnd_api.g_miss_char) <> NVL(l_location_rec.po_box_number,fnd_api.g_miss_char) THEN
3088: loc_modified := 'Y';
3089: ELSE

Line 3093: arp_standard.debug(' p_location_rec.street :'||p_location_rec.street);

3089: ELSE
3090: l_location_rec.po_box_number:= ar_miss_char;
3091: END IF;
3092:
3093: arp_standard.debug(' p_location_rec.street :'||p_location_rec.street);
3094: arp_standard.debug(' l_location_rec.street :'||l_location_rec.street);
3095: IF NVL(p_location_rec.street,fnd_api.g_miss_char) <> NVL(l_location_rec.street,fnd_api.g_miss_char) THEN
3096: loc_modified := 'Y';
3097: ELSE

Line 3094: arp_standard.debug(' l_location_rec.street :'||l_location_rec.street);

3090: l_location_rec.po_box_number:= ar_miss_char;
3091: END IF;
3092:
3093: arp_standard.debug(' p_location_rec.street :'||p_location_rec.street);
3094: arp_standard.debug(' l_location_rec.street :'||l_location_rec.street);
3095: IF NVL(p_location_rec.street,fnd_api.g_miss_char) <> NVL(l_location_rec.street,fnd_api.g_miss_char) THEN
3096: loc_modified := 'Y';
3097: ELSE
3098: l_location_rec.street:= ar_miss_char;

Line 3100: arp_standard.debug(' p_location_rec.street_number :'||p_location_rec.street_number);

3096: loc_modified := 'Y';
3097: ELSE
3098: l_location_rec.street:= ar_miss_char;
3099: END IF;
3100: arp_standard.debug(' p_location_rec.street_number :'||p_location_rec.street_number);
3101: arp_standard.debug(' l_location_rec.street_number :'||l_location_rec.street_number);
3102: IF NVL(p_location_rec.street_number,fnd_api.g_miss_char) <> NVL(l_location_rec.street_number,fnd_api.g_miss_char) THEN
3103: loc_modified := 'Y';
3104: ELSE

Line 3101: arp_standard.debug(' l_location_rec.street_number :'||l_location_rec.street_number);

3097: ELSE
3098: l_location_rec.street:= ar_miss_char;
3099: END IF;
3100: arp_standard.debug(' p_location_rec.street_number :'||p_location_rec.street_number);
3101: arp_standard.debug(' l_location_rec.street_number :'||l_location_rec.street_number);
3102: IF NVL(p_location_rec.street_number,fnd_api.g_miss_char) <> NVL(l_location_rec.street_number,fnd_api.g_miss_char) THEN
3103: loc_modified := 'Y';
3104: ELSE
3105: l_location_rec.street_number:= ar_miss_char;

Line 3107: arp_standard.debug(' p_location_rec.street_suffix :'||p_location_rec.street_suffix);

3103: loc_modified := 'Y';
3104: ELSE
3105: l_location_rec.street_number:= ar_miss_char;
3106: END IF;
3107: arp_standard.debug(' p_location_rec.street_suffix :'||p_location_rec.street_suffix);
3108: arp_standard.debug(' l_location_rec.street_suffix :'||l_location_rec.street_suffix);
3109: IF NVL(p_location_rec.street_suffix,fnd_api.g_miss_char) <> NVL(l_location_rec.street_suffix,fnd_api.g_miss_char) THEN
3110: loc_modified := 'Y';
3111: ELSE

Line 3108: arp_standard.debug(' l_location_rec.street_suffix :'||l_location_rec.street_suffix);

3104: ELSE
3105: l_location_rec.street_number:= ar_miss_char;
3106: END IF;
3107: arp_standard.debug(' p_location_rec.street_suffix :'||p_location_rec.street_suffix);
3108: arp_standard.debug(' l_location_rec.street_suffix :'||l_location_rec.street_suffix);
3109: IF NVL(p_location_rec.street_suffix,fnd_api.g_miss_char) <> NVL(l_location_rec.street_suffix,fnd_api.g_miss_char) THEN
3110: loc_modified := 'Y';
3111: ELSE
3112: l_location_rec.street_suffix := ar_miss_char;

Line 3114: arp_standard.debug(' p_location_rec.suite :'||p_location_rec.suite);

3110: loc_modified := 'Y';
3111: ELSE
3112: l_location_rec.street_suffix := ar_miss_char;
3113: END IF;
3114: arp_standard.debug(' p_location_rec.suite :'||p_location_rec.suite);
3115: arp_standard.debug(' l_location_rec.suite :'||l_location_rec.suite);
3116: IF NVL(p_location_rec.suite,fnd_api.g_miss_char) <> NVL(l_location_rec.suite,fnd_api.g_miss_char) THEN
3117: loc_modified := 'Y';
3118: ELSE

Line 3115: arp_standard.debug(' l_location_rec.suite :'||l_location_rec.suite);

3111: ELSE
3112: l_location_rec.street_suffix := ar_miss_char;
3113: END IF;
3114: arp_standard.debug(' p_location_rec.suite :'||p_location_rec.suite);
3115: arp_standard.debug(' l_location_rec.suite :'||l_location_rec.suite);
3116: IF NVL(p_location_rec.suite,fnd_api.g_miss_char) <> NVL(l_location_rec.suite,fnd_api.g_miss_char) THEN
3117: loc_modified := 'Y';
3118: ELSE
3119: l_location_rec.suite:= ar_miss_char;

Line 3127: arp_standard.debug(' x_loc_updated :'||x_loc_updated);

3123: END IF;
3124: CLOSE c_exist_loc;
3125: x_loc_updated := loc_modified;
3126: x_exist_loc_rec := l_location_rec;
3127: arp_standard.debug(' x_loc_updated :'||x_loc_updated);
3128: END IF;
3129: arp_standard.debug('compare_location_existing -');
3130: EXCEPTION
3131: WHEN OTHERS THEN

Line 3129: arp_standard.debug('compare_location_existing -');

3125: x_loc_updated := loc_modified;
3126: x_exist_loc_rec := l_location_rec;
3127: arp_standard.debug(' x_loc_updated :'||x_loc_updated);
3128: END IF;
3129: arp_standard.debug('compare_location_existing -');
3130: EXCEPTION
3131: WHEN OTHERS THEN
3132: IF c_exist_loc%ISOPEN THEN CLOSE c_exist_loc; END IF;
3133: arp_standard.debug('EXCEPTION OTHERS compare_location_existing :'||SQLERRM);

Line 3133: arp_standard.debug('EXCEPTION OTHERS compare_location_existing :'||SQLERRM);

3129: arp_standard.debug('compare_location_existing -');
3130: EXCEPTION
3131: WHEN OTHERS THEN
3132: IF c_exist_loc%ISOPEN THEN CLOSE c_exist_loc; END IF;
3133: arp_standard.debug('EXCEPTION OTHERS compare_location_existing :'||SQLERRM);
3134: RAISE;
3135: END compare_location_existing;
3136:
3137: --

Line 3180: arp_standard.debug('compare_location_existing overload +');

3176: IS
3177: l_location_rec hz_location_v2pub.location_rec_type;
3178: l_exist_loc_rec hz_location_v2pub.location_rec_type;
3179: BEGIN
3180: arp_standard.debug('compare_location_existing overload +');
3181:
3182: arp_standard.debug('IN VALUES + ');
3183: arp_standard.debug(' x_Country :'|| x_country);
3184: arp_standard.debug(' x_Address1 :'|| x_address1);

Line 3182: arp_standard.debug('IN VALUES + ');

3178: l_exist_loc_rec hz_location_v2pub.location_rec_type;
3179: BEGIN
3180: arp_standard.debug('compare_location_existing overload +');
3181:
3182: arp_standard.debug('IN VALUES + ');
3183: arp_standard.debug(' x_Country :'|| x_country);
3184: arp_standard.debug(' x_Address1 :'|| x_address1);
3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);

Line 3183: arp_standard.debug(' x_Country :'|| x_country);

3179: BEGIN
3180: arp_standard.debug('compare_location_existing overload +');
3181:
3182: arp_standard.debug('IN VALUES + ');
3183: arp_standard.debug(' x_Country :'|| x_country);
3184: arp_standard.debug(' x_Address1 :'|| x_address1);
3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);

Line 3184: arp_standard.debug(' x_Address1 :'|| x_address1);

3180: arp_standard.debug('compare_location_existing overload +');
3181:
3182: arp_standard.debug('IN VALUES + ');
3183: arp_standard.debug(' x_Country :'|| x_country);
3184: arp_standard.debug(' x_Address1 :'|| x_address1);
3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);

Line 3185: arp_standard.debug(' x_Address2 :'|| x_address2);

3181:
3182: arp_standard.debug('IN VALUES + ');
3183: arp_standard.debug(' x_Country :'|| x_country);
3184: arp_standard.debug(' x_Address1 :'|| x_address1);
3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);

Line 3186: arp_standard.debug(' x_Address3 :'|| x_address3);

3182: arp_standard.debug('IN VALUES + ');
3183: arp_standard.debug(' x_Country :'|| x_country);
3184: arp_standard.debug(' x_Address1 :'|| x_address1);
3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);

Line 3187: arp_standard.debug(' x_Address4 :'|| x_address4);

3183: arp_standard.debug(' x_Country :'|| x_country);
3184: arp_standard.debug(' x_Address1 :'|| x_address1);
3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);

Line 3188: arp_standard.debug(' x_City :'|| x_city);

3184: arp_standard.debug(' x_Address1 :'|| x_address1);
3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);

Line 3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);

3185: arp_standard.debug(' x_Address2 :'|| x_address2);
3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);

Line 3190: arp_standard.debug(' x_State :'|| x_state);

3186: arp_standard.debug(' x_Address3 :'|| x_address3);
3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);

Line 3191: arp_standard.debug(' x_Province :'|| x_province);

3187: arp_standard.debug(' x_Address4 :'|| x_address4);
3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);

Line 3192: arp_standard.debug(' x_County :'|| x_county);

3188: arp_standard.debug(' x_City :'|| x_city);
3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);

Line 3193: arp_standard.debug(' x_description :'|| x_description);

3189: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);

Line 3194: arp_standard.debug(' x_short_description :'|| x_short_description);

3190: arp_standard.debug(' x_State :'|| x_state);
3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);

Line 3195: arp_standard.debug(' x_floor :'|| x_floor);

3191: arp_standard.debug(' x_Province :'|| x_province);
3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);

Line 3196: arp_standard.debug(' x_house_number :'|| x_house_number);

3192: arp_standard.debug(' x_County :'|| x_county);
3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);

Line 3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);

3193: arp_standard.debug(' x_description :'|| x_description);
3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);

Line 3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);

3194: arp_standard.debug(' x_short_description :'|| x_short_description);
3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);

Line 3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);

3195: arp_standard.debug(' x_floor :'|| x_floor);
3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);

Line 3200: arp_standard.debug(' x_street :'|| x_street);

3196: arp_standard.debug(' x_house_number :'|| x_house_number);
3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);

Line 3201: arp_standard.debug(' x_street_number :'|| x_street_number);

3197: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);

Line 3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);

3198: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);

Line 3203: arp_standard.debug(' x_suite :'|| x_suite);

3199: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3207: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);

Line 3204: arp_standard.debug(' x_Language :'|| x_language);

3200: arp_standard.debug(' x_street :'|| x_street);
3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3207: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3208: arp_standard.debug('IN VALUES - ');

Line 3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);

3201: arp_standard.debug(' x_street_number :'|| x_street_number);
3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3207: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3208: arp_standard.debug('IN VALUES - ');
3209:

Line 3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);

3202: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3207: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3208: arp_standard.debug('IN VALUES - ');
3209:
3210:

Line 3207: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);

3203: arp_standard.debug(' x_suite :'|| x_suite);
3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3207: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3208: arp_standard.debug('IN VALUES - ');
3209:
3210:
3211: l_location_rec.Country := x_country;

Line 3208: arp_standard.debug('IN VALUES - ');

3204: arp_standard.debug(' x_Language :'|| x_language);
3205: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3206: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3207: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3208: arp_standard.debug('IN VALUES - ');
3209:
3210:
3211: l_location_rec.Country := x_country;
3212: l_location_rec.Address1 := x_address1;

Line 3270: arp_standard.debug('OUT VALUES + ');

3266: x_Address_Lines_Phonetic := l_exist_loc_rec.Address_Lines_Phonetic;
3267: x_Sales_Tax_Geocode := l_exist_loc_rec.Sales_Tax_Geocode;
3268: x_Sales_Tax_Inside_City_Limits := l_exist_loc_rec.Sales_Tax_Inside_City_Limits;
3269: END IF;
3270: arp_standard.debug('OUT VALUES + ');
3271: arp_standard.debug(' x_Country :'|| x_country);
3272: arp_standard.debug(' x_Address1 :'|| x_address1);
3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);

Line 3271: arp_standard.debug(' x_Country :'|| x_country);

3267: x_Sales_Tax_Geocode := l_exist_loc_rec.Sales_Tax_Geocode;
3268: x_Sales_Tax_Inside_City_Limits := l_exist_loc_rec.Sales_Tax_Inside_City_Limits;
3269: END IF;
3270: arp_standard.debug('OUT VALUES + ');
3271: arp_standard.debug(' x_Country :'|| x_country);
3272: arp_standard.debug(' x_Address1 :'|| x_address1);
3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);

Line 3272: arp_standard.debug(' x_Address1 :'|| x_address1);

3268: x_Sales_Tax_Inside_City_Limits := l_exist_loc_rec.Sales_Tax_Inside_City_Limits;
3269: END IF;
3270: arp_standard.debug('OUT VALUES + ');
3271: arp_standard.debug(' x_Country :'|| x_country);
3272: arp_standard.debug(' x_Address1 :'|| x_address1);
3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);

Line 3273: arp_standard.debug(' x_Address2 :'|| x_address2);

3269: END IF;
3270: arp_standard.debug('OUT VALUES + ');
3271: arp_standard.debug(' x_Country :'|| x_country);
3272: arp_standard.debug(' x_Address1 :'|| x_address1);
3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);

Line 3274: arp_standard.debug(' x_Address3 :'|| x_address3);

3270: arp_standard.debug('OUT VALUES + ');
3271: arp_standard.debug(' x_Country :'|| x_country);
3272: arp_standard.debug(' x_Address1 :'|| x_address1);
3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);

Line 3275: arp_standard.debug(' x_Address4 :'|| x_address4);

3271: arp_standard.debug(' x_Country :'|| x_country);
3272: arp_standard.debug(' x_Address1 :'|| x_address1);
3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);

Line 3276: arp_standard.debug(' x_City :'|| x_city);

3272: arp_standard.debug(' x_Address1 :'|| x_address1);
3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);

Line 3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);

3273: arp_standard.debug(' x_Address2 :'|| x_address2);
3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);

Line 3278: arp_standard.debug(' x_State :'|| x_state);

3274: arp_standard.debug(' x_Address3 :'|| x_address3);
3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);

Line 3279: arp_standard.debug(' x_Province :'|| x_province);

3275: arp_standard.debug(' x_Address4 :'|| x_address4);
3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);

Line 3280: arp_standard.debug(' x_County :'|| x_county);

3276: arp_standard.debug(' x_City :'|| x_city);
3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);

Line 3281: arp_standard.debug(' x_description :'|| x_description);

3277: arp_standard.debug(' x_Postal_Code :'|| x_postal_code);
3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);

Line 3282: arp_standard.debug(' x_short_description :'|| x_short_description);

3278: arp_standard.debug(' x_State :'|| x_state);
3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);

Line 3283: arp_standard.debug(' x_floor :'|| x_floor);

3279: arp_standard.debug(' x_Province :'|| x_province);
3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);

Line 3284: arp_standard.debug(' x_house_number :'|| x_house_number);

3280: arp_standard.debug(' x_County :'|| x_county);
3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);

Line 3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);

3281: arp_standard.debug(' x_description :'|| x_description);
3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);

Line 3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);

3282: arp_standard.debug(' x_short_description :'|| x_short_description);
3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);

Line 3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);

3283: arp_standard.debug(' x_floor :'|| x_floor);
3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);

Line 3288: arp_standard.debug(' x_street :'|| x_street);

3284: arp_standard.debug(' x_house_number :'|| x_house_number);
3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);

Line 3289: arp_standard.debug(' x_street_number :'|| x_street_number);

3285: arp_standard.debug(' x_location_directions :'|| x_location_directions);
3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);

Line 3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);

3286: arp_standard.debug(' x_postal_plus4_code :'|| x_postal_plus4_code);
3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);

Line 3291: arp_standard.debug(' x_suite :'|| x_suite);

3287: arp_standard.debug(' x_po_box_number :'|| x_po_box_number);
3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);

Line 3292: arp_standard.debug(' x_Language :'|| x_language);

3288: arp_standard.debug(' x_street :'|| x_street);
3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3296: arp_standard.debug('OUT VALUES - ');

Line 3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);

3289: arp_standard.debug(' x_street_number :'|| x_street_number);
3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3296: arp_standard.debug('OUT VALUES - ');
3297:

Line 3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);

3290: arp_standard.debug(' x_street_suffix :'|| x_street_suffix);
3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3296: arp_standard.debug('OUT VALUES - ');
3297:
3298: arp_standard.debug('compare_location_existing overload -');

Line 3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);

3291: arp_standard.debug(' x_suite :'|| x_suite);
3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3296: arp_standard.debug('OUT VALUES - ');
3297:
3298: arp_standard.debug('compare_location_existing overload -');
3299: END compare_location_existing;

Line 3296: arp_standard.debug('OUT VALUES - ');

3292: arp_standard.debug(' x_Language :'|| x_language);
3293: arp_standard.debug(' x_Address_Lines_Phonetic :'|| x_Address_Lines_Phonetic);
3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3296: arp_standard.debug('OUT VALUES - ');
3297:
3298: arp_standard.debug('compare_location_existing overload -');
3299: END compare_location_existing;
3300:

Line 3298: arp_standard.debug('compare_location_existing overload -');

3294: arp_standard.debug(' x_Sales_Tax_Geocode :'|| x_sales_tax_geocode);
3295: arp_standard.debug(' x_Sales_Tax_Inside_City_Limits :'|| x_Sales_Tax_Inside_City_Limits);
3296: arp_standard.debug('OUT VALUES - ');
3297:
3298: arp_standard.debug('compare_location_existing overload -');
3299: END compare_location_existing;
3300:
3301:
3302: PROCEDURE get_location_data