APPS.IEM_UTILITY_PVT dependencies on FND_API

Line 18: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

14: order by from_name;
15: i number:=0;
16: BEGIN
17: -- Standard call to check for call compatibility.
18: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
19: p_api_version_number,
20: l_api_name,
21: G_PKG_NAME)
22: THEN

Line 23: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

19: p_api_version_number,
20: l_api_name,
21: G_PKG_NAME)
22: THEN
23: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
24: END IF;
25: SAVEPOINT select_mail_count_pvt;
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: i:=0;

Line 26: x_return_status := FND_API.G_RET_STS_SUCCESS;

22: THEN
23: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
24: END IF;
25: SAVEPOINT select_mail_count_pvt;
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: i:=0;
28: for v1 in c1 loop
29: i:=i+1;
30: x_account_tbl(i).email_account_id:=v1.email_account_id;

Line 44: WHEN FND_API.G_EXC_ERROR THEN

40: p_data => x_msg_data
41: );
42: EXCEPTION
43:
44: WHEN FND_API.G_EXC_ERROR THEN
45: ROLLBACK TO select_mail_count_PVT;
46: x_return_status := FND_API.G_RET_STS_ERROR ;
47: FND_MSG_PUB.Count_And_Get
48: ( p_count => x_msg_count,

Line 46: x_return_status := FND_API.G_RET_STS_ERROR ;

42: EXCEPTION
43:
44: WHEN FND_API.G_EXC_ERROR THEN
45: ROLLBACK TO select_mail_count_PVT;
46: x_return_status := FND_API.G_RET_STS_ERROR ;
47: FND_MSG_PUB.Count_And_Get
48: ( p_count => x_msg_count,
49: p_data => x_msg_data
50: );

Line 51: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

47: FND_MSG_PUB.Count_And_Get
48: ( p_count => x_msg_count,
49: p_data => x_msg_data
50: );
51: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
52: ROLLBACK TO select_mail_count_PVT;
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
54: FND_MSG_PUB.Count_And_Get
55: ( p_count => x_msg_count,

Line 53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

49: p_data => x_msg_data
50: );
51: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
52: ROLLBACK TO select_mail_count_PVT;
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
54: FND_MSG_PUB.Count_And_Get
55: ( p_count => x_msg_count,
56: p_data => x_msg_data
57: );

Line 60: x_return_status := FND_API.G_RET_STS_ERROR;

56: p_data => x_msg_data
57: );
58: WHEN OTHERS THEN
59: ROLLBACK TO select_mail_count_PVT;
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: IF FND_MSG_PUB.Check_Msg_Level
62: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
63: THEN
64: FND_MSG_PUB.Add_Exc_Msg

Line 95: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

91:
92: i number:=0;
93: BEGIN
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
96: p_api_version_number,
97: l_api_name,
98: G_PKG_NAME)
99: THEN

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: p_api_version_number,
97: l_api_name,
98: G_PKG_NAME)
99: THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102: SAVEPOINT select_mail_count_pvt;
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: i:=0;

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102: SAVEPOINT select_mail_count_pvt;
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: i:=0;
105: for v1 in c1 loop
106: i:=i+1;
107: x_class_tbl(i).rt_classification_id:=v1.route_classification_id;

Line 121: WHEN FND_API.G_EXC_ERROR THEN

117: p_data => x_msg_data
118: );
119: EXCEPTION
120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO select_mail_count_PVT;
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,

Line 123: x_return_status := FND_API.G_RET_STS_ERROR ;

119: EXCEPTION
120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO select_mail_count_PVT;
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );

Line 128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO select_mail_count_PVT;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131: FND_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count,

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

126: p_data => x_msg_data
127: );
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO select_mail_count_PVT;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131: FND_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count,
133: p_data => x_msg_data
134: );

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133: p_data => x_msg_data
134: );
135: WHEN OTHERS THEN
136: ROLLBACK TO select_mail_count_PVT;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: IF FND_MSG_PUB.Check_Msg_Level
139: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
140: THEN
141: FND_MSG_PUB.Add_Exc_Msg