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

130: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_alert_code '||l_alert_code);
131: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanket_header_id '||l_blanket_header_id);
132: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_customer_id '||l_customer_id);
133:
134: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Calling ASP_ALERTS_PUB.Get_Matching_Subscriptions');
135: end if;
136:
137:
138: If l_event_entity = 'ORDER' Then

Line 139: ASP_ALERTS_PUB.Get_Matching_Subscriptions(

135: end if;
136:
137:
138: If l_event_entity = 'ORDER' Then
139: ASP_ALERTS_PUB.Get_Matching_Subscriptions(
140: p_api_version_number => 1.0,
141: p_init_msg_list => FND_API.G_FALSE,
142: p_alert_code => l_alert_code,
143: p_customer_id => l_customer_id,