APPS.ASP_ALERTS_PUB dependencies on ASP_ALERTS_PUB

Line 1: PACKAGE BODY ASP_ALERTS_PUB as

1: PACKAGE BODY ASP_ALERTS_PUB as
2: /* $Header: asppaltb.pls 120.6 2005/10/10 17:17 axavier noship $ */
3: ---------------------------------------------------------------------------
4: -- Package Name: ASP_ALERTS_PUB
5: ---------------------------------------------------------------------------

Line 4: -- Package Name: ASP_ALERTS_PUB

1: PACKAGE BODY ASP_ALERTS_PUB as
2: /* $Header: asppaltb.pls 120.6 2005/10/10 17:17 axavier noship $ */
3: ---------------------------------------------------------------------------
4: -- Package Name: ASP_ALERTS_PUB
5: ---------------------------------------------------------------------------
6: -- Description:
7: -- Public package for Sales Alerts Related Business logic.
8: --

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASP_ALERTS_PUB';

15:
16: /*-------------------------------------------------------------------------*
17: | Private Constants
18: *-------------------------------------------------------------------------*/
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASP_ALERTS_PUB';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asppaltb.pls';
21:
22: G_MAX_FETCHES CONSTANT NUMBER := 10000;
23:

Line 93: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.Begin';

89: and sub.resource_id = acc.salesforce_id;
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

Line 126: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.End';

122: FND_MSG_PUB.Count_And_Get(
123: p_count => x_msg_count,
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:

Line 134: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.NO_DATA_FOUND';

130:
131:
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;

Line 143: --Print_Debug('Exception: others in ASP_ALERTS_PUB::Get_Matching_Subscriptions');

139: FND_MSG_PUB.Count_And_Get(
140: p_count => x_msg_count,
141: p_data => x_msg_data );
142: WHEN OTHERS THEN
143: --Print_Debug('Exception: others in ASP_ALERTS_PUB::Get_Matching_Subscriptions');
144: --Print_Debug();
145:
146: l_errbuf := SQLERRM;
147: l_errcode := to_char(SQLCODE);

Line 149: l_debug_module := 'asp.plsql.ASP_ALERTS_PUB.Get_Matching_Subscriptions.OTHERS';

145:
146: l_errbuf := SQLERRM;
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: );

Line 165: End ASP_ALERTS_PUB;

161:
162: END Get_Matching_Subscriptions;
163:
164:
165: End ASP_ALERTS_PUB;