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.PV_USER_MGMT_PVT dependencies on FND_LOG

Line 2102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2098: BEGIN
2099:
2100: FND_MSG_PUB.initialize;
2101:
2102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2104: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2105: ,'Entered Post Approval procedure');
2106: END IF;

Line 2103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2099:
2100: FND_MSG_PUB.initialize;
2101:
2102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2104: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2105: ,'Entered Post Approval procedure');
2106: END IF;
2107:

Line 2112: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2108: l_userreg_id := p_event.getValueForParameter('USERTYPEREG_ID');
2109: l_usertype_key := p_event.getValueForParameter('USER_TYPE_KEY');
2110: l_usertype_appId := p_event.getValueForParameter('APPID');
2111:
2112: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2113: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2114: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2115: ,'l_userreg_id=' || l_userreg_id || ',l_usertype_key=' || l_usertype_key || ',l_usertype_appId=' || l_usertype_appId);
2116: END IF;

Line 2113: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2109: l_usertype_key := p_event.getValueForParameter('USER_TYPE_KEY');
2110: l_usertype_appId := p_event.getValueForParameter('APPID');
2111:
2112: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2113: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2114: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2115: ,'l_userreg_id=' || l_userreg_id || ',l_usertype_key=' || l_usertype_key || ',l_usertype_appId=' || l_usertype_appId);
2116: END IF;
2117:

Line 2122: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2118: OPEN c_get_user_info(l_userreg_id, l_usertype_key);
2119: FETCH c_get_user_info into l_user_id, l_user_name, l_customer_id, l_user_type_id;
2120: CLOSE c_get_user_info;
2121:
2122: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2124: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2125: ,'After c_get_user_info: l_user_id' || l_user_id || ',l_user_name=' || l_user_name || ',l_customer_id=' || l_customer_id || ',l_user_type_id=' || l_user_type_id);
2126: END IF;

Line 2123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2119: FETCH c_get_user_info into l_user_id, l_user_name, l_customer_id, l_user_type_id;
2120: CLOSE c_get_user_info;
2121:
2122: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2124: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2125: ,'After c_get_user_info: l_user_id' || l_user_id || ',l_user_name=' || l_user_name || ',l_customer_id=' || l_customer_id || ',l_user_type_id=' || l_user_type_id);
2126: END IF;
2127:

Line 2130: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2126: END IF;
2127:
2128: OPEN c_is_partner_user(l_user_type_id);
2129: FETCH c_is_partner_user into is_partner;
2130: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2131: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2132: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2133: ,'is_partner='|| to_char(is_partner) || ';');
2134: END IF;

Line 2131: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2127:
2128: OPEN c_is_partner_user(l_user_type_id);
2129: FETCH c_is_partner_user into is_partner;
2130: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2131: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2132: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2133: ,'is_partner='|| to_char(is_partner) || ';');
2134: END IF;
2135: if (c_is_partner_user%NOTFOUND or is_partner <> 1 ) then

Line 2136: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2132: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2133: ,'is_partner='|| to_char(is_partner) || ';');
2134: END IF;
2135: if (c_is_partner_user%NOTFOUND or is_partner <> 1 ) then
2136: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2138: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2139: ,'l_user_name:' || l_user_name || '-- This user is not a partner user; no action; returning SUCCESS');
2140: END IF;

Line 2137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2133: ,'is_partner='|| to_char(is_partner) || ';');
2134: END IF;
2135: if (c_is_partner_user%NOTFOUND or is_partner <> 1 ) then
2136: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2138: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2139: ,'l_user_name:' || l_user_name || '-- This user is not a partner user; no action; returning SUCCESS');
2140: END IF;
2141: RETURN 'SUCCESS';

Line 2151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2147: partner_user_rec.person_rel_party_id := l_customer_id;
2148: partner_user_rec.user_id := l_user_id;
2149: partner_user_rec.user_type_id := l_user_type_id;
2150:
2151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2153: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2154: ,'this is a partner user; created partner user rec and going to call pv_user_mgmt_pvt.register_partner_user');
2155: END IF;

Line 2152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2148: partner_user_rec.user_id := l_user_id;
2149: partner_user_rec.user_type_id := l_user_type_id;
2150:
2151: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2153: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2154: ,'this is a partner user; created partner user rec and going to call pv_user_mgmt_pvt.register_partner_user');
2155: END IF;
2156:

Line 2169: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2165: ,x_msg_count => x_msg_count
2166: ,x_msg_data => x_msg_data
2167: );
2168:
2169: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2171: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2172: ,'after call pv_user_mgmt_pvt.register_partner_user: x_return_status='|| x_return_status || ',x_msg_count=' || to_char(x_msg_count));
2173: END IF;

Line 2170: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2166: ,x_msg_data => x_msg_data
2167: );
2168:
2169: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2171: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2172: ,'after call pv_user_mgmt_pvt.register_partner_user: x_return_status='|| x_return_status || ',x_msg_count=' || to_char(x_msg_count));
2173: END IF;
2174:

Line 2182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2178: p_data => x_msg_data
2179: );
2180:
2181: if (x_return_status = 'S') then
2182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2184: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2185: ,'returning SUCCESS to the function');
2186: END IF;

Line 2183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2179: );
2180:
2181: if (x_return_status = 'S') then
2182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2184: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2185: ,'returning SUCCESS to the function');
2186: END IF;
2187: RETURN 'SUCCESS';

Line 2190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2186: END IF;
2187: RETURN 'SUCCESS';
2188: else
2189:
2190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2192: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2193: ,'x_return_status is not returning S');
2194: END IF;

Line 2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2187: RETURN 'SUCCESS';
2188: else
2189:
2190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2192: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2193: ,'x_return_status is not returning S');
2194: END IF;
2195: FOR k IN 1 .. x_msg_count LOOP

Line 2203: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2199: ,p_data => x_msg_data
2200: ,p_msg_index_out => x_msg_index);
2201:
2202:
2203: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2205: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2206: ,'in the error msg loop: k=' || to_char(k)|| ',x_msg_data=' || x_msg_data);
2207: END IF;

Line 2204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

2200: ,p_msg_index_out => x_msg_index);
2201:
2202:
2203: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2205: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2206: ,'in the error msg loop: k=' || to_char(k)|| ',x_msg_data=' || x_msg_data);
2207: END IF;
2208: END LOOP;