DBA Data[Home] [Help]

APPS.ASP_SERVICE_ALERT_AGENT dependencies on ASP_ALERTS_PUB

Line 58: l_subscriber_list ASP_ALERTS_PUB.SUBSCRIBER_TBL_TYPE;

54: l_api_name varchar2(100);
55: l_qualified_api_name varchar2(200);
56: l_debug_msg varchar2(1000);
57: l_alert_code varchar2(30);
58: l_subscriber_list ASP_ALERTS_PUB.SUBSCRIBER_TBL_TYPE;
59: l_return_status VARCHAR2(30);
60: l_msg_count NUMBER ;
61: l_msg_data VARCHAR2(2000) ;
62: l_sms_users varchar2(32767);

Line 127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');

123: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
124: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_incident_id '||l_incident_id);
126: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
128: end if;
129:
130: If l_event_entity = 'SERVICE_REQUEST' Then
131: ASP_ALERTS_PUB.Get_Matching_Subscriptions(

Line 131: ASP_ALERTS_PUB.Get_Matching_Subscriptions(

127: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
128: end if;
129:
130: If l_event_entity = 'SERVICE_REQUEST' Then
131: ASP_ALERTS_PUB.Get_Matching_Subscriptions(
132: p_api_version_number => 1.0,
133: p_init_msg_list => FND_API.G_FALSE,
134: p_alert_code => l_alert_code,
135: p_customer_id => l_customer_id,