DBA Data[Home] [Help]

APPS.ASP_SVCCONTRACT_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 141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');

137: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_event_entity '||l_event_entity);
138: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
139: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_contract_header_id '||l_contract_header_id);
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
142: end if;
143:
144: If l_event_entity = 'SERVICE_CONTRACT' Then
145: ASP_ALERTS_PUB.Get_Matching_Subscriptions(

Line 145: ASP_ALERTS_PUB.Get_Matching_Subscriptions(

141: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
142: end if;
143:
144: If l_event_entity = 'SERVICE_CONTRACT' Then
145: ASP_ALERTS_PUB.Get_Matching_Subscriptions(
146: p_api_version_number => 1.0,
147: p_init_msg_list => FND_API.G_FALSE,
148: p_alert_code => l_alert_code,
149: p_customer_id => l_customer_id,