DBA Data[Home] [Help]

APPS.FND_DICTIONARY_PKG dependencies on FND_LOG

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

3832: end if;
3833:
3834: end if;
3835:
3836: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3837: if (x_primary_key_col_value_new(0) is null) then
3838: -- Bug 1496010: This is the case for checking so print out selbuf.
3839: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.',
3840: selbuf);

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

3835:
3836: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3837: if (x_primary_key_col_value_new(0) is null) then
3838: -- Bug 1496010: This is the case for checking so print out selbuf.
3839: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.',
3840: selbuf);
3841: else
3842: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.',
3843: updbuf);

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

3838: -- Bug 1496010: This is the case for checking so print out selbuf.
3839: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.',
3840: selbuf);
3841: else
3842: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.',
3843: updbuf);
3844: end if;
3845: end if;
3846:

Line 3891: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3887: when unique_constraint then
3888: fnd_message.set_name('FND', 'FK_COLUMN_VALUE_DUPLICATE');
3889: fnd_message.set_token('FK_TABLE', fk.table_name);
3890: fnd_message.set_token('UPDATE_STATEMENT', updbuf);
3891: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3892: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3893: c_log_head || l_api_name || '.update_failed', FALSE);
3894: end if;
3895: checking_log := TRUE;

Line 3892: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3888: fnd_message.set_name('FND', 'FK_COLUMN_VALUE_DUPLICATE');
3889: fnd_message.set_token('FK_TABLE', fk.table_name);
3890: fnd_message.set_token('UPDATE_STATEMENT', updbuf);
3891: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3892: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3893: c_log_head || l_api_name || '.update_failed', FALSE);
3894: end if;
3895: checking_log := TRUE;
3896: -- Probably no need to raise error

Line 3904: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3900: when table_doesnot_exist then
3901: -- ORA 942
3902: fnd_message.set_name('FND', 'FK_TABLE_NOT_FOUND');
3903: fnd_message.set_token('FK_TABLE', fk.table_name);
3904: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3905: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3906: c_log_head || l_api_name || '.update_failed', FALSE);
3907: end if;
3908: checking_log := TRUE;

Line 3905: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3901: -- ORA 942
3902: fnd_message.set_name('FND', 'FK_TABLE_NOT_FOUND');
3903: fnd_message.set_token('FK_TABLE', fk.table_name);
3904: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3905: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3906: c_log_head || l_api_name || '.update_failed', FALSE);
3907: end if;
3908: checking_log := TRUE;
3909: -- Probably no need to raise error

Line 3925: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3921: end loop;
3922: fnd_message.set_token('FK_COLUMN',
3923: tmpbuf||' or LAST_UPDATED_BY or LAST_UPDATE_DATE' );
3924: fnd_message.set_token('FK_TABLE', fk.table_name);
3925: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3926: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3927: c_log_head || l_api_name || '.update_failed', FALSE);
3928: end if;
3929: checking_log := TRUE;

Line 3926: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3922: fnd_message.set_token('FK_COLUMN',
3923: tmpbuf||' or LAST_UPDATED_BY or LAST_UPDATE_DATE' );
3924: fnd_message.set_token('FK_TABLE', fk.table_name);
3925: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3926: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3927: c_log_head || l_api_name || '.update_failed', FALSE);
3928: end if;
3929: checking_log := TRUE;
3930: -- Probably no need to raise error

Line 3937: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3933: when duplicate_column_name then
3934: -- ORA 957
3935: fnd_message.set_name('FND', 'FK_DUPLICATE_COLUMN_UPDATE');
3936: fnd_message.set_token('SQL_STATEMENT', updbuf);
3937: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3938: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3939: c_log_head || l_api_name || '.update_failed', FALSE);
3940: end if;
3941: checking_log := TRUE;

Line 3938: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3934: -- ORA 957
3935: fnd_message.set_name('FND', 'FK_DUPLICATE_COLUMN_UPDATE');
3936: fnd_message.set_token('SQL_STATEMENT', updbuf);
3937: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3938: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3939: c_log_head || l_api_name || '.update_failed', FALSE);
3940: end if;
3941: checking_log := TRUE;
3942: -- Probably no need to raise error

Line 3948: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

3944: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3945: fnd_message.set_token('ROUTINE', 'UpdateChildren');
3946: fnd_message.set_token('ERRNO', to_char(sqlcode));
3947: fnd_message.set_token('REASON', sqlerrm);
3948: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3949: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3950: c_log_head || l_api_name || '.update_failed', FALSE);
3951: end if;
3952: checking_log := TRUE;

Line 3949: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3945: fnd_message.set_token('ROUTINE', 'UpdateChildren');
3946: fnd_message.set_token('ERRNO', to_char(sqlcode));
3947: fnd_message.set_token('REASON', sqlerrm);
3948: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3949: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3950: c_log_head || l_api_name || '.update_failed', FALSE);
3951: end if;
3952: checking_log := TRUE;
3953: end; -- end execute updbuf and selbuf;

Line 4076: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

4072: when no_data_found then
4073: fnd_message.set_name('FND', 'FK_INVALID_TABLE');
4074: fnd_message.set_token('APPS', x_application_short_name);
4075: fnd_message.set_token('TABLE', x_primary_table_name);
4076: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4077: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4078: c_log_head || l_api_name || '.fetch_info', FALSE);
4079: end if;
4080: return(FALSE);

Line 4077: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4073: fnd_message.set_name('FND', 'FK_INVALID_TABLE');
4074: fnd_message.set_token('APPS', x_application_short_name);
4075: fnd_message.set_token('TABLE', x_primary_table_name);
4076: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4077: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4078: c_log_head || l_api_name || '.fetch_info', FALSE);
4079: end if;
4080: return(FALSE);
4081: when others then

Line 4086: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

4082: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4083: fnd_message.set_token('ROUTINE', 'UpdatePKColumns');
4084: fnd_message.set_token('ERRNO', to_char(sqlcode));
4085: fnd_message.set_token('REASON', sqlerrm);
4086: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4087: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4088: c_log_head || l_api_name || '.fetch_info', FALSE);
4089: end if;
4090: return(FALSE);

Line 4087: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4083: fnd_message.set_token('ROUTINE', 'UpdatePKColumns');
4084: fnd_message.set_token('ERRNO', to_char(sqlcode));
4085: fnd_message.set_token('REASON', sqlerrm);
4086: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4087: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4088: c_log_head || l_api_name || '.fetch_info', FALSE);
4089: end if;
4090: return(FALSE);
4091: end;

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

4099: i := i + 1;
4100: end loop;
4101:
4102: tmpbuf := 'Checking table '||x_primary_table_name;
4103: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4104: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name, tmpbuf);
4105: end if;
4106:
4107:

Line 4104: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name, tmpbuf);

4100: end loop;
4101:
4102: tmpbuf := 'Checking table '||x_primary_table_name;
4103: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4104: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name, tmpbuf);
4105: end if;
4106:
4107:
4108: for pk in pks(appl_id, tab_id) loop

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

4106:
4107:
4108: for pk in pks(appl_id, tab_id) loop
4109: tmpbuf := 'Checking '||pk.primary_key_name;
4110: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4111: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name, tmpbuf);
4112: end if;
4113:
4114: -- Figure out which columns are the one user wants to update.

Line 4111: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name, tmpbuf);

4107:
4108: for pk in pks(appl_id, tab_id) loop
4109: tmpbuf := 'Checking '||pk.primary_key_name;
4110: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4111: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head||l_api_name, tmpbuf);
4112: end if;
4113:
4114: -- Figure out which columns are the one user wants to update.
4115: -- UpdatePKColumns allows you to pass all pk columns or partial columns.