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_MAP10000 dependencies on STANDARD

Line 300: -- check if there is another row with same STANDARD_NAME, in that case it is error case

296: --hk_debugt(L_MAP_DTLS_TBL);
297: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
298: ,L_MAP_DTLS_TBL(2).GEOGRAPHY_ID,L_MAP_DTLS_TBL(3).GEOGRAPHY_ID,L_MAP_DTLS_TBL(4).GEOGRAPHY_ID,L_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
299: IF c_getGeo1%FOUND THEN
300: -- check if there is another row with same STANDARD_NAME, in that case it is error case
301: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
302: ,L_MAP_DTLS_TBL(2).GEOGRAPHY_ID,L_MAP_DTLS_TBL(3).GEOGRAPHY_ID,L_MAP_DTLS_TBL(4).GEOGRAPHY_ID,L_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
303: IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)
304:

Line 320: ' More than 1 rec exists with same STANDARD NAME',

316:
317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
318: hz_utility_v2pub.debug
319: (p_message => 'MAP-Not able to find a record with with identifier type as NAME. '||
320: ' More than 1 rec exists with same STANDARD NAME',
321: p_prefix => l_debug_prefix,
322: p_msg_level => fnd_log.level_statement,
323: p_module_prefix => l_module_prefix,
324: p_module => l_module

Line 885: -- check if there is another row with same STANDARD_NAME, in that case it is error case

881: --hk_debugt(LL_MAP_DTLS_TBL);
882: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,LL_MAP_DTLS_TBL(1).GEOGRAPHY_ID
883: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
884: IF c_getGeo1%FOUND THEN
885: -- check if there is another row with same STANDARD_NAME, in that case it is error case
886: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
887: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
888: IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)
889:

Line 905: ' More than 1 rec exists with same STANDARD NAME',

901:
902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
903: hz_utility_v2pub.debug
904: (p_message => 'GEO-Not able to find a record with with identifier type as NAME. '||
905: ' More than 1 rec exists with same STANDARD NAME',
906: p_prefix => l_debug_prefix,
907: p_msg_level => fnd_log.level_statement,
908: p_module_prefix => l_module_prefix,
909: p_module => l_module

Line 1515: -- check if there is another row with same STANDARD_NAME, in that case it is error case

1511: --hk_debugt(LL_MAP_DTLS_TBL);
1512: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,LL_MAP_DTLS_TBL(1).GEOGRAPHY_ID
1513: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
1514: IF c_getGeo1%FOUND THEN
1515: -- check if there is another row with same STANDARD_NAME, in that case it is error case
1516: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
1517: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
1518: IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)
1519:

Line 1535: ' More than 1 rec exists with same STANDARD NAME',

1531:
1532: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1533: hz_utility_v2pub.debug
1534: (p_message => 'GEO-Not able to find a record with with identifier type as NAME. '||
1535: ' More than 1 rec exists with same STANDARD NAME',
1536: p_prefix => l_debug_prefix,
1537: p_msg_level => fnd_log.level_statement,
1538: p_module_prefix => l_module_prefix,
1539: p_module => l_module