APPS.OZF_REQUEST_STATUS_PVT dependencies on FND_LOG

Line 343: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

339: select function_id from fnd_form_functions where function_name = pc_func_name ;
340:
341: BEGIN
342:
343: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
345: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.start',
346: 'Item type:' || p_itemtype || 'Item key:' || p_itemkey || '. Entity id: ' ||
347: p_entity_id || '. Status:' || p_status || '. User type: ' || p_user_type);

Line 344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

340:
341: BEGIN
342:
343: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
345: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.start',
346: 'Item type:' || p_itemtype || 'Item key:' || p_itemkey || '. Entity id: ' ||
347: p_entity_id || '. Status:' || p_status || '. User type: ' || p_user_type);
348: end if;

Line 761: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

757: END IF;
758:
759: end if; --if p_itemtype = 'OZFSPBEN' then
760:
761: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
763: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');
764: end if;
765:

Line 762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

758:
759: end if; --if p_itemtype = 'OZFSPBEN' then
760:
761: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
763: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');
764: end if;
765:
766: END;

Line 864: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

860: and jtf.user_id = fnd.user_id
861: and ref.request_header_id = pc_entity_id;
862:
863: begin
864: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
866: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.start',
867: 'Benefit type:' || p_benefit_type || '. Entity id: ' || p_entity_id ||
868: '. Status:' || p_status || '. User type: ' || p_user_role);

Line 865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

861: and ref.request_header_id = pc_entity_id;
862:
863: begin
864: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
866: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.start',
867: 'Benefit type:' || p_benefit_type || '. Entity id: ' || p_entity_id ||
868: '. Status:' || p_status || '. User type: ' || p_user_role);
869: end if;

Line 913: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

909: end loop;
910: l_role_list := substr(l_role_list,2);
911:
912: else
913: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
915: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.info',
916: 'Unrecognized user role:' || p_user_role);
917: END IF;

Line 914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

910: l_role_list := substr(l_role_list,2);
911:
912: else
913: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
915: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.info',
916: 'Unrecognized user role:' || p_user_role);
917: END IF;
918: end if;

Line 920: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

916: 'Unrecognized user role:' || p_user_role);
917: END IF;
918: end if;
919:
920: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
922: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.end', 'Exiting');
923: end if;
924:

Line 921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

917: END IF;
918: end if;
919:
920: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
922: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.end', 'Exiting');
923: end if;
924:
925: return l_role_list;