APPS.CSD_MIGRATE_FROM_12X_PKG7 dependencies on FND_LOG

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

18:
19: -- end bug#6993441 subhat
20:
21: begin
22: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
24: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
25: 'Before fetching the party for user_id');
26: end if;

Line 23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

19: -- end bug#6993441 subhat
20:
21: begin
22: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
24: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
25: 'Before fetching the party for user_id');
26: end if;
27:

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

48: end if;
49: end;
50: -- update all the null party_id's
51:
52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
54: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
55: 'Before bulk update of CSD_RO_SAVEDSEARCHES table');
56: end if;

Line 53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

49: end;
50: -- update all the null party_id's
51:
52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
54: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
55: 'Before bulk update of CSD_RO_SAVEDSEARCHES table');
56: end if;
57:

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

60: update csd_ro_savedsearches set party_id = l_party_id_tbl(i) --usr_party_tbl(i).party_id
61: where user_id = l_user_id_tbl(i) --usr_party_tbl(i).user_id
62: and party_id is null;
63:
64: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
66: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
67: 'After bulk update of CSD_RO_SAVEDSEARCHES table');
68: end if;

Line 65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

61: where user_id = l_user_id_tbl(i) --usr_party_tbl(i).user_id
62: and party_id is null;
63:
64: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
66: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
67: 'After bulk update of CSD_RO_SAVEDSEARCHES table');
68: end if;
69: