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

Line 1493: l(' -- check if there is another row with same STANDARD_NAME, in that case it is error case ');

1489: l(' FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID');
1490: l(' '||l_fetch_cur);
1491: l(' IF c_getGeo1%FOUND THEN ');
1492: ------
1493: l(' -- check if there is another row with same STANDARD_NAME, in that case it is error case ');
1494: l(' FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID ');
1495: l(' '||l_fetch_cur);
1496: l(' IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)' );
1497: l(' ');

Line 1513: l(' '' More than 1 rec exists with same STANDARD NAME'', ');

1509: l(' ');
1510: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1511: l(' hz_utility_v2pub.debug ');
1512: l(' (p_message => ''MAP-Not able to find a record with with identifier type as NAME. ''|| ');
1513: l(' '' More than 1 rec exists with same STANDARD NAME'', ');
1514: l(' p_prefix => l_debug_prefix, ');
1515: l(' p_msg_level => fnd_log.level_statement, ');
1516: l(' p_module_prefix => l_module_prefix, ');
1517: l(' p_module => l_module ');

Line 2127: l(' -- check if there is another row with same STANDARD_NAME, in that case it is error case ');

2123: l(' FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,LL_MAP_DTLS_TBL(1).GEOGRAPHY_ID');
2124: l(' '||l_fetch_cur);
2125: l(' IF c_getGeo1%FOUND THEN ');
2126: ---- Fix for Bug 5011366 (Nishant)
2127: l(' -- check if there is another row with same STANDARD_NAME, in that case it is error case ');
2128: l(' FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID ');
2129: l(' '||l_fetch_cur);
2130: l(' IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)' );
2131: l(' ');

Line 2147: l(' '' More than 1 rec exists with same STANDARD NAME'', ');

2143: l(' ');
2144: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
2145: l(' hz_utility_v2pub.debug ');
2146: l(' (p_message => ''GEO-Not able to find a record with with identifier type as NAME. ''|| ');
2147: l(' '' More than 1 rec exists with same STANDARD NAME'', ');
2148: l(' p_prefix => l_debug_prefix, ');
2149: l(' p_msg_level => fnd_log.level_statement, ');
2150: l(' p_module_prefix => l_module_prefix, ');
2151: l(' p_module => l_module ');