APPS.ASP_ALERTS_PUB dependencies on FND_LOG

Line 94: l_debug_level :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

90:
91:
92: BEGIN
93: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.Begin';
94: l_debug_level :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: l_debug_proc_level := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
97: if(l_debug_proc_level >= l_debug_level) then
98: fnd_log.string(l_debug_proc_level, l_debug_module, 'Entering Get_Matching_Subscriptions' );

Line 95: l_debug_proc_level := FND_LOG.LEVEL_PROCEDURE;

91:
92: BEGIN
93: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.Begin';
94: l_debug_level :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: l_debug_proc_level := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
97: if(l_debug_proc_level >= l_debug_level) then
98: fnd_log.string(l_debug_proc_level, l_debug_module, 'Entering Get_Matching_Subscriptions' );
99: end if;

Line 96: l_debug_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

92: BEGIN
93: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.Begin';
94: l_debug_level :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: l_debug_proc_level := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
97: if(l_debug_proc_level >= l_debug_level) then
98: fnd_log.string(l_debug_proc_level, l_debug_module, 'Entering Get_Matching_Subscriptions' );
99: end if;
100:

Line 98: fnd_log.string(l_debug_proc_level, l_debug_module, 'Entering Get_Matching_Subscriptions' );

94: l_debug_level :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
95: l_debug_proc_level := FND_LOG.LEVEL_PROCEDURE;
96: l_debug_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
97: if(l_debug_proc_level >= l_debug_level) then
98: fnd_log.string(l_debug_proc_level, l_debug_module, 'Entering Get_Matching_Subscriptions' );
99: end if;
100:
101:
102: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 118: fnd_log.string(l_debug_proc_level, l_debug_module, 'After opening Cursor get_subs_secured' );

114: LIMIT G_MAX_FETCHES;
115: CLOSE get_subs_secured;
116:
117: if(l_debug_proc_level >= l_debug_level) then
118: fnd_log.string(l_debug_proc_level, l_debug_module, 'After opening Cursor get_subs_secured' );
119: end if;
120:
121: -- Standard call to get message count and IF count is 1, get message info.
122: FND_MSG_PUB.Count_And_Get(

Line 128: fnd_log.string(l_debug_proc_level, l_debug_module, 'End Get_Matching_Subscriptions' );

124: p_data => x_msg_data );
125:
126: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.End';
127: if(l_debug_proc_level >= l_debug_level) then
128: fnd_log.string(l_debug_proc_level, l_debug_module, 'End Get_Matching_Subscriptions' );
129: end if;
130:
131:
132: EXCEPTION

Line 136: fnd_log.string(l_debug_proc_level, l_debug_module, 'Exception: NO_DATA_FOUND' );

132: EXCEPTION
133: WHEN NO_DATA_FOUND THEN
134: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.NO_DATA_FOUND';
135: if(l_debug_proc_level >= l_debug_level) then
136: fnd_log.string(l_debug_proc_level, l_debug_module, 'Exception: NO_DATA_FOUND' );
137: end if;
138: if get_subs_secured%ISOPEN then CLOSE get_subs_secured; end if;
139: FND_MSG_PUB.Count_And_Get(
140: p_count => x_msg_count,

Line 151: fnd_log.string(l_debug_unexp_level, l_debug_module, 'Exception: OTHERS - '||

147: l_errcode := to_char(SQLCODE);
148:
149: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.OTHERS';
150: if(l_debug_unexp_level >= l_debug_level) then
151: fnd_log.string(l_debug_unexp_level, l_debug_module, 'Exception: OTHERS - '||
152: 'SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM
153: );
154: end if;
155: