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.16 2006/07/22 00:33:28 nsinghai noship $ */
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: FOR i IN l_geo_struct_tbl.FIRST..l_geo_struct_tbl.LAST LOOP

Line 52: FUNCTION get_missing_input_fields (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type

48: -- Private Function to get list of geography types which are mandatory but
49: -- user has not entered value
50: -- Created By Nishant Singhai (for Bug 4600030 on 27-Sep-2005)
51: ----------------------------------------------------------------------------+
52: FUNCTION get_missing_input_fields (l_geo_struct_tbl IN hz_gnr_pvt.geo_struct_tbl_type
53: ) RETURN VARCHAR2 IS
54: v_missing_fields VARCHAR(200);
55: BEGIN
56: FOR i IN l_geo_struct_tbl.FIRST..l_geo_struct_tbl.LAST LOOP

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

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

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

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

Line 667: p_list IN OUT NOCOPY hz_gnr_pvt.geo_suggest_tbl_type

663: PROCEDURE quick_sort_suggestion_list
664: (
665: p_left INTEGER,
666: p_right INTEGER,
667: p_list IN OUT NOCOPY hz_gnr_pvt.geo_suggest_tbl_type
668: )
669: IS
670:
671: i INTEGER;

Line 675: l_current_node hz_gnr_pvt.geo_suggest_rec;

671: i INTEGER;
672: j INTEGER;
673: l_left INTEGER := p_left;
674: l_right INTEGER := p_right;
675: l_current_node hz_gnr_pvt.geo_suggest_rec;
676: l_dummy_node hz_gnr_pvt.geo_suggest_rec;
677:
678: BEGIN
679:

Line 676: l_dummy_node hz_gnr_pvt.geo_suggest_rec;

672: j INTEGER;
673: l_left INTEGER := p_left;
674: l_right INTEGER := p_right;
675: l_current_node hz_gnr_pvt.geo_suggest_rec;
676: l_dummy_node hz_gnr_pvt.geo_suggest_rec;
677:
678: BEGIN
679:
680: IF (l_right > l_left) THEN

Line 827: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,

823: x_mapped_struct_count OUT NOCOPY NUMBER,
824: x_records_count OUT NOCOPY NUMBER,
825: x_return_code OUT NOCOPY NUMBER,
826: x_validation_level OUT NOCOPY VARCHAR2,
827: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,
828: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,
829: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,
830: x_return_status OUT NOCOPY VARCHAR2,
831: x_msg_count OUT NOCOPY NUMBER,

Line 828: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,

824: x_records_count OUT NOCOPY NUMBER,
825: x_return_code OUT NOCOPY NUMBER,
826: x_validation_level OUT NOCOPY VARCHAR2,
827: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,
828: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,
829: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,
830: x_return_status OUT NOCOPY VARCHAR2,
831: x_msg_count OUT NOCOPY NUMBER,
832: x_msg_data OUT NOCOPY VARCHAR2

Line 829: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,

825: x_return_code OUT NOCOPY NUMBER,
826: x_validation_level OUT NOCOPY VARCHAR2,
827: x_geo_suggest_tbl OUT NOCOPY HZ_GNR_PVT.geo_suggest_tbl_type,
828: x_geo_struct_tbl OUT NOCOPY HZ_GNR_PVT.geo_struct_tbl_type,
829: x_geo_suggest_misc_rec OUT NOCOPY HZ_GNR_PVT.geo_suggest_misc_rec,
830: x_return_status OUT NOCOPY VARCHAR2,
831: x_msg_count OUT NOCOPY NUMBER,
832: x_msg_data OUT NOCOPY VARCHAR2
833: ) IS

Line 997: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;

993:
994: geo_rec geo_rec_type;
995: geo_rec_tbl geo_rec_tbl_type;
996:
997: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
998: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
999:
1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;

Line 998: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;

994: geo_rec geo_rec_type;
995: geo_rec_tbl geo_rec_tbl_type;
996:
997: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
998: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
999:
1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;

Line 3652: l_geo_suggest_tbl_temp hz_gnr_pvt.geo_suggest_tbl_type;

3648: l_element_matched VARCHAR2(10);
3649: l_check_next_row VARCHAR2(10);
3650: l_exact_row_match_found VARCHAR2(10);
3651:
3652: l_geo_suggest_tbl_temp hz_gnr_pvt.geo_suggest_tbl_type;
3653:
3654: PROCEDURE priv_match_proc(ll_index number, ll_tbl_value IN VARCHAR2) IS
3655: BEGIN
3656: IF ((REPLACE(geo_struct_tbl(ll_index).v_param_value,'%','') =

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

4723: );
4724: END IF;
4725:
4726: -- If it is 2nd pass and geo validation success, then return ADDRESS_COMPLETE
4727: IF ((HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NOT NULL) AND -- this is 2nd attempt
4728: (l_success = 'Y')) THEN
4729: -- FND Logging for debug purpose
4730: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4731: hz_utility_v2pub.debug

Line 4744: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;

4740: -- set return code and return message
4741: setup_msg_and_ret_code_proc(p_return_code => 0); /* ADDRESS_COMPLETE */
4742: -- reset the global variable (session) to null so that next time
4743: -- address suggestion kickes in initially
4744: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;
4745:
4746: ELSE -- do further processing to verify if record is success
4747:
4748: IF (geo_suggest_tbl.COUNT = 0) THEN

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

4778: p_msg_token_name => l_msg_token_name);
4779:
4780: -- set the global variable (session) to '1' (some value) to identify that
4781: -- next time we can directly go to geo validation i.e.
4782: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := '1';
4783:
4784: ELSE -- geo_suggest_tbl count is not 0
4785:
4786: -- set the global variable (session) to '1' (some value) to identify that

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

4784: ELSE -- geo_suggest_tbl count is not 0
4785:
4786: -- set the global variable (session) to '1' (some value) to identify that
4787: -- next time we can directly go to geo validation i.e.
4788: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := '1';
4789:
4790: IF (geo_suggest_tbl.COUNT =1) THEN
4791: -- check if all input values match all fetched values
4792: IF (do_input_output_match_check) THEN

Line 4809: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;

4805: -- set return code and return message
4806: setup_msg_and_ret_code_proc(p_return_code => 0); /* ADDRESS_COMPLETE */
4807: -- reset the global variable (session) to null so that next time
4808: -- address suggestion kickes in initially
4809: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;
4810:
4811: ELSE
4812: -- FND Logging for debug purpose
4813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

5737: success, return success else go in suggestion logic of deriving helpful
5738: suggestions for user
5739:
5740: NOTE: In case of WARNING, we are not setting global varibale
5741: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT because CPUI bypasses suggestion API if
5742: user decides to save the record without changing any value in any field.
5743: In that case, there will not be any 2nd attempt. When user changes anything
5744: in any field, the cpui treats it as field modification and will again
5745: call address suggestion. For address suggestion, it is similar to 1st attempt

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

5805: END IF;
5806:
5807: ELSE
5808: -- check if it is 1st attempt for ERROR condition.
5809: IF (HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NULL) THEN
5810: l_success := 'N'; -- so that we can suggest more if there is anything during 1st attempt
5811: l_geo_validation_passed := 'Y'; -- This will be used while setting message for validation level ERROR
5812:
5813: -- FND Logging for debug purpose

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

6415: p_module => l_module
6416: );
6417: END IF;
6418:
6419: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL; -- reset the global variable
6420: x_return_status := FND_API.G_RET_STS_ERROR ;
6421:
6422: -- set return code and return message
6423: setup_msg_and_ret_code_proc(p_return_code => 200); /* SYSTEM_ERROR (System Error) */

Line 6440: END HZ_GNR_PVT;

6436: -- ns_debug.put_line(l_sql_stmt);
6437:
6438: END search_geographies;
6439:
6440: END HZ_GNR_PVT;