DBA Data[Home] [Help]

APPS.AZ_R12_UPD_DET_LOG dependencies on FND_LOG

Line 46: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

42: WHEN no_data_found THEN
43: v_last_commit_marker_id := v_current_id;
44: END;
45:
46: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
47: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name
48: || to_char(systimestamp), 'Getting Max Commit marker id for p_request_id: ' || p_request_id
49: || ' p_source: ' || p_source || ' v_last_commit_marker_id: ' || v_last_commit_marker_id);
50: end if;

Line 47: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name

43: v_last_commit_marker_id := v_current_id;
44: END;
45:
46: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
47: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name
48: || to_char(systimestamp), 'Getting Max Commit marker id for p_request_id: ' || p_request_id
49: || ' p_source: ' || p_source || ' v_last_commit_marker_id: ' || v_last_commit_marker_id);
50: end if;
51:

Line 134: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

130: WHERE (k.detail_log_status ' || p_status_check_clause || '))
131: AND g.request_id = ' || p_request_id || '
132: AND g.source = ''' || p_source || '''';
133:
134: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
135: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
136: || to_char(systimestamp), 'Executing update master status query: ' || l_log_query);
137: END IF;
138:

Line 135: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

131: AND g.request_id = ' || p_request_id || '
132: AND g.source = ''' || p_source || '''';
133:
134: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
135: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
136: || to_char(systimestamp), 'Executing update master status query: ' || l_log_query);
137: END IF;
138:
139: EXECUTE IMMEDIATE l_log_query;

Line 152: if( FND_LOG.LEVEL_UNEXPECTED >=

148: v_message VARCHAR2(2048);
149:
150: BEGIN
151:
152: if( FND_LOG.LEVEL_UNEXPECTED >=
153: FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
154: FND_MESSAGE.SET_NAME('AZ', 'AZ_R12_PLSQL_EXCEPTION'); -- Seeded Message
155: -- Runtime Information
156: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ErrCode);

Line 153: FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

149:
150: BEGIN
151:
152: if( FND_LOG.LEVEL_UNEXPECTED >=
153: FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
154: FND_MESSAGE.SET_NAME('AZ', 'AZ_R12_PLSQL_EXCEPTION'); -- Seeded Message
155: -- Runtime Information
156: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ErrCode);
157: FND_MESSAGE.SET_TOKEN('ERROR_MESG', ErrMsg);

Line 273: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

269: v_update_xsl := v_update_xsl || ' ';
270:
271: p_update_xsl := v_update_xsl;
272:
273: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
274: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
275: || to_char(systimestamp) , 'Generated v_update_xsl: ' || v_update_xsl);
276: end if;
277:

Line 274: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name

270:
271: p_update_xsl := v_update_xsl;
272:
273: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
274: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name
275: || to_char(systimestamp) , 'Generated v_update_xsl: ' || v_update_xsl);
276: end if;
277:
278: EXCEPTION