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.HZ_GNR_PVT dependencies on HZ_GNR_PVT

Line 1: PACKAGE BODY HZ_GNR_PVT AS

1: PACKAGE BODY HZ_GNR_PVT AS
2: /* $Header: ARHGNRVB.pls 120.20 2011/04/07 19:17:24 nsinghai ship $ */
3:
4: -----------------------------------------------------------------------------+
5: -- Package variables

Line 7: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRVB:HZ_GNR_PVT';

3:
4: -----------------------------------------------------------------------------+
5: -- Package variables
6: -----------------------------------------------------------------------------+
7: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRVB:HZ_GNR_PVT';
8: l_module CONSTANT VARCHAR2(30) := 'SEARCH_GEOGRAPHIES';
9: l_debug_prefix VARCHAR2(30) ;
10:
11: -----------------------------------------------------------------------------+

Line 16: FUNCTION get_geo_type_list (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type,

12: -- Private function to get geo type list based on postion of geo type.
13: -- If for US structure, 2 is passed, it will give STATE, COUNTY, CITY, POSTAL_CODE
14: -- Created By Nishant Singhai (for Bug 4600030 on 27-Sep-2005)
15: -----------------------------------------------------------------------------+
16: FUNCTION get_geo_type_list (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type,
17: l_index IN NUMBER, l_for_map_or_usg IN VARCHAR2 DEFAULT 'USAGE' ) RETURN VARCHAR2 IS
18: v_not_validated_geo_type VARCHAR(200);
19: BEGIN
20: IF (L_GEO_STRUCT_TBL.COUNT > 0) THEN -- Fix for handling eBTax migrated bad data (Bug 09903372)

Line 54: FUNCTION get_missing_input_fields (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type

50: -- Private Function to get list of geography types which are mandatory but
51: -- user has not entered value
52: -- Created By Nishant Singhai (for Bug 4600030 on 27-Sep-2005)
53: ----------------------------------------------------------------------------+
54: FUNCTION get_missing_input_fields (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type
55: ) RETURN VARCHAR2 IS
56: v_missing_fields VARCHAR(200);
57: BEGIN
58: IF (L_GEO_STRUCT_TBL.COUNT > 0) THEN -- Fix for handling eBTax migrated bad data (Bug 09903372)

Line 78: FUNCTION is_all_geo_usage_param_passed (ll_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type)

74: --------------------------------------------------------------------------+
75: -- FUNCTION TO CHECK IF user passed values for all components for which
76: -- geo usage is checked for validation
77: --------------------------------------------------------------------------+
78: FUNCTION is_all_geo_usage_param_passed (ll_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type)
79: RETURN BOOLEAN IS
80: BEGIN
81: IF (ll_geo_struct_tbl.COUNT > 0) THEN
82: FOR i IN ll_geo_struct_tbl.FIRST..ll_geo_struct_tbl.LAST LOOP

Line 100: PROCEDURE validate_input_values_proc (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type,

96: -----------------------------------------------------------------------------+
97: -- Procedure to return geography types in a string that could not be validated
98: -- Created By Nishant Singhai (for Bug 4600030 on 27-Sep-2005)
99: -----------------------------------------------------------------------------+
100: PROCEDURE validate_input_values_proc (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type,
101: x_not_validated_geo_type OUT NOCOPY VARCHAR2,
102: x_rec_count_flag OUT NOCOPY VARCHAR2,
103: x_success_geo_level OUT NOCOPY NUMBER) IS
104:

Line 671: p_list IN OUT NOCOPY hz_gnr_pvt.geo_suggest_tbl_type

667: PROCEDURE quick_sort_suggestion_list
668: (
669: p_left INTEGER,
670: p_right INTEGER,
671: p_list IN OUT NOCOPY hz_gnr_pvt.geo_suggest_tbl_type
672: )
673: IS
674:
675: i INTEGER;

Line 679: l_current_node hz_gnr_pvt.geo_suggest_rec;

675: i INTEGER;
676: j INTEGER;
677: l_left INTEGER := p_left;
678: l_right INTEGER := p_right;
679: l_current_node hz_gnr_pvt.geo_suggest_rec;
680: l_dummy_node hz_gnr_pvt.geo_suggest_rec;
681:
682: BEGIN
683:

Line 680: l_dummy_node hz_gnr_pvt.geo_suggest_rec;

676: j INTEGER;
677: l_left INTEGER := p_left;
678: l_right INTEGER := p_right;
679: l_current_node hz_gnr_pvt.geo_suggest_rec;
680: l_dummy_node hz_gnr_pvt.geo_suggest_rec;
681:
682: BEGIN
683:
684: IF (l_right > l_left) THEN

Line 831: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,

827: x_mapped_struct_count OUT NOCOPY NUMBER,
828: x_records_count OUT NOCOPY NUMBER,
829: x_return_code OUT NOCOPY NUMBER,
830: x_validation_level OUT NOCOPY VARCHAR2,
831: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,
832: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,
833: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,

Line 832: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,

828: x_records_count OUT NOCOPY NUMBER,
829: x_return_code OUT NOCOPY NUMBER,
830: x_validation_level OUT NOCOPY VARCHAR2,
831: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,
832: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,
833: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2

Line 833: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,

829: x_return_code OUT NOCOPY NUMBER,
830: x_validation_level OUT NOCOPY VARCHAR2,
831: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,
832: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,
833: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2
837: ) IS

Line 1001: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;

997:
998: geo_rec geo_rec_type;
999: geo_rec_tbl geo_rec_tbl_type;
1000:
1001: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
1002: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
1003:
1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;

Line 1002: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;

998: geo_rec geo_rec_type;
999: geo_rec_tbl geo_rec_tbl_type;
1000:
1001: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
1002: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
1003:
1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;

Line 3746: l_geo_suggest_tbl_temp hz_gnr_pvt.geo_suggest_tbl_type;

3742: l_element_matched VARCHAR2(10);
3743: l_check_next_row VARCHAR2(10);
3744: l_exact_row_match_found VARCHAR2(10);
3745:
3746: l_geo_suggest_tbl_temp hz_gnr_pvt.geo_suggest_tbl_type;
3747:
3748: PROCEDURE priv_match_proc(ll_index number, ll_tbl_value IN VARCHAR2) IS
3749: BEGIN
3750: IF ((REPLACE(geo_struct_tbl(ll_index).v_param_value,'%','') =

Line 4858: IF ((HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NOT NULL) AND -- this is 2nd attempt

4854: );
4855: END IF;
4856:
4857: -- If it is 2nd pass and geo validation success, then return ADDRESS_COMPLETE
4858: IF ((HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NOT NULL) AND -- this is 2nd attempt
4859: (l_success = 'Y')) THEN
4860: -- FND Logging for debug purpose
4861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4862: hz_utility_v2pub.debug

Line 4875: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;

4871: -- set return code and return message
4872: setup_msg_and_ret_code_proc(p_return_code => 0); /* ADDRESS_COMPLETE */
4873: -- reset the global variable (session) to null so that next time
4874: -- address suggestion kickes in initially
4875: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;
4876:
4877: ELSE -- do further processing to verify if record is success
4878:
4879: IF (geo_suggest_tbl.COUNT = 0) THEN

Line 4913: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := '1';

4909: p_msg_token_name => l_msg_token_name);
4910:
4911: -- set the global variable (session) to '1' (some value) to identify that
4912: -- next time we can directly go to geo validation i.e.
4913: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := '1';
4914:
4915: ELSE -- geo_suggest_tbl count is not 0
4916:
4917: -- set the global variable (session) to '1' (some value) to identify that

Line 4919: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := '1';

4915: ELSE -- geo_suggest_tbl count is not 0
4916:
4917: -- set the global variable (session) to '1' (some value) to identify that
4918: -- next time we can directly go to geo validation i.e.
4919: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := '1';
4920:
4921: IF (geo_suggest_tbl.COUNT =1) THEN
4922: -- check if all input values match all fetched values
4923: IF (do_input_output_match_check) THEN

Line 4940: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;

4936: -- set return code and return message
4937: setup_msg_and_ret_code_proc(p_return_code => 0); /* ADDRESS_COMPLETE */
4938: -- reset the global variable (session) to null so that next time
4939: -- address suggestion kickes in initially
4940: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;
4941:
4942: ELSE
4943: -- FND Logging for debug purpose
4944: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 5872: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT because CPUI bypasses suggestion API if

5868: success, return success else go in suggestion logic of deriving helpful
5869: suggestions for user
5870:
5871: NOTE: In case of WARNING, we are not setting global varibale
5872: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT because CPUI bypasses suggestion API if
5873: user decides to save the record without changing any value in any field.
5874: In that case, there will not be any 2nd attempt. When user changes anything
5875: in any field, the cpui treats it as field modification and will again
5876: call address suggestion. For address suggestion, it is similar to 1st attempt

Line 5940: IF (HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NULL) THEN

5936: END IF;
5937:
5938: ELSE
5939: -- check if it is 1st attempt for ERROR condition.
5940: IF (HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NULL) THEN
5941: l_success := 'N'; -- so that we can suggest more if there is anything during 1st attempt
5942: l_geo_validation_passed := 'Y'; -- This will be used while setting message for validation level ERROR
5943:
5944: -- FND Logging for debug purpose

Line 6569: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL; -- reset the global variable

6565: p_module => l_module
6566: );
6567: END IF;
6568:
6569: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL; -- reset the global variable
6570: x_return_status := FND_API.G_RET_STS_ERROR ;
6571:
6572: -- set return code and return message
6573: setup_msg_and_ret_code_proc(p_return_code => 200); /* SYSTEM_ERROR (System Error) */

Line 6590: END HZ_GNR_PVT;

6586: -- ns_debug.put_line(l_sql_stmt);
6587:
6588: END search_geographies;
6589:
6590: END HZ_GNR_PVT;