APPS.ASP_ALERTS_PUB dependencies on FND_API

Line 49: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

45: --------------------------------------------------------------------------------
46:
47: PROCEDURE Get_Matching_Subscriptions (
48: p_api_version_number IN NUMBER,
49: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50: p_alert_code IN VARCHAR2,
51: p_customer_id IN NUMBER,
52: x_subscriber_list OUT NOCOPY SUBSCRIBER_TBL_TYPE,
53: x_return_status OUT NOCOPY VARCHAR2,

Line 103: IF FND_API.to_Boolean(p_init_msg_list)

99: end if;
100:
101:
102: -- Initialize message list IF p_init_msg_list is set to TRUE.
103: IF FND_API.to_Boolean(p_init_msg_list)
104: THEN
105: FND_MSG_PUB.initialize;
106: END IF;
107:

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: -- Initialize API return status to SUCCESS
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: OPEN get_subs_secured(p_alert_code, p_customer_id);
112: FETCH get_subs_secured BULK COLLECT INTO
113: x_subscriber_list

Line 156: x_return_status := FND_API.G_RET_STS_ERROR;

152: 'SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM
153: );
154: end if;
155:
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: if get_subs_secured%ISOPEN then CLOSE get_subs_secured; end if;
158: FND_MSG_PUB.Count_And_Get(
159: p_count => x_msg_count,
160: p_data => x_msg_data );