eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_STANDARD_PUB dependencies on FND_API

Line 36: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

32: l_api_version CONSTANT NUMBER := 1.0;
33: l_api_name CONSTANT VARCHAR2(50) := 'Get_PsigStatus';
34: BEGIN
35: -- Standard call to check for call compatibility
36: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
37: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: -- Initialize message list if the caller asks me to do so

Line 37: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

33: l_api_name CONSTANT VARCHAR2(50) := 'Get_PsigStatus';
34: BEGIN
35: -- Standard call to check for call compatibility
36: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
37: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: -- Initialize message list if the caller asks me to do so
41: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 41: IF FND_API.to_Boolean( p_init_msg_list ) THEN

37: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: -- Initialize message list if the caller asks me to do so
41: IF FND_API.to_Boolean( p_init_msg_list ) THEN
42: FND_MSG_PUB.initialize;
43: END IF;
44:
45: -- Initialize API return status to success

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: FND_MSG_PUB.initialize;
43: END IF;
44:
45: -- Initialize API return status to success
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: edr_standard.Psig_Status(
49: P_EVENT => p_event_name,
50: P_EVENT_KEY => p_event_key,

Line 57: WHEN FND_API.G_EXC_ERROR THEN

53: -- Standard call to get message count, and if count is 1, get message info
54: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR ;
59: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 58: x_return_status := FND_API.G_RET_STS_ERROR ;

54: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR ;
59: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
62: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR ;
59: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
62: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
63: WHEN OTHERS THEN
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR ;
59: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
62: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
63: WHEN OTHERS THEN
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
65: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
62: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
63: WHEN OTHERS THEN
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
65: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
66: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
67: END IF;
68: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 99: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

95: l_api_name CONSTANT VARCHAR2(50) := 'Is_Psig_Required';
96: l_isRequired BOOLEAN;
97: BEGIN
98: -- Standard call to check for call compatibility
99: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
100: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if the caller asks me to do so

Line 100: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

96: l_isRequired BOOLEAN;
97: BEGIN
98: -- Standard call to check for call compatibility
99: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
100: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if the caller asks me to do so
104: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 104: IF FND_API.to_Boolean( p_init_msg_list ) THEN

100: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if the caller asks me to do so
104: IF FND_API.to_Boolean( p_init_msg_list ) THEN
105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: -- Initialize API return status to success

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: BEGIN
112: edr_standard.Psig_Required(
113: P_EVENT => p_event_name,

Line 116: IF l_isRequired THEN x_isRequired_eSig := FND_API.G_TRUE;

112: edr_standard.Psig_Required(
113: P_EVENT => p_event_name,
114: P_EVENT_KEY => p_event_key,
115: P_STATUS => l_isRequired );
116: IF l_isRequired THEN x_isRequired_eSig := FND_API.G_TRUE;
117: ELSE x_isRequired_eSig := FND_API.G_FALSE;
118: END IF;
119: EXCEPTION
120: WHEN OTHERS THEN

Line 117: ELSE x_isRequired_eSig := FND_API.G_FALSE;

113: P_EVENT => p_event_name,
114: P_EVENT_KEY => p_event_key,
115: P_STATUS => l_isRequired );
116: IF l_isRequired THEN x_isRequired_eSig := FND_API.G_TRUE;
117: ELSE x_isRequired_eSig := FND_API.G_FALSE;
118: END IF;
119: EXCEPTION
120: WHEN OTHERS THEN
121: x_isRequired_eSig := FND_API.G_FALSE;

Line 121: x_isRequired_eSig := FND_API.G_FALSE;

117: ELSE x_isRequired_eSig := FND_API.G_FALSE;
118: END IF;
119: EXCEPTION
120: WHEN OTHERS THEN
121: x_isRequired_eSig := FND_API.G_FALSE;
122: fnd_msg_pub.Add;
123: raise fnd_api.G_EXC_ERROR;
124: END;
125: -- fetch the message off the dictionary stack and add to API message list

Line 123: raise fnd_api.G_EXC_ERROR;

119: EXCEPTION
120: WHEN OTHERS THEN
121: x_isRequired_eSig := FND_API.G_FALSE;
122: fnd_msg_pub.Add;
123: raise fnd_api.G_EXC_ERROR;
124: END;
125: -- fetch the message off the dictionary stack and add to API message list
126: -- would only add the last one message in the above api call
127: -- need to do this in the above api after each fnd_message.set_name/set_token

Line 134: WHEN FND_API.G_EXC_ERROR THEN

130: -- Standard call to get message count, and if count is 1, get message info
131: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_ERROR ;
136: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 135: x_return_status := FND_API.G_RET_STS_ERROR ;

131: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_ERROR ;
136: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_ERROR ;
136: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

134: WHEN FND_API.G_EXC_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_ERROR ;
136: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
143: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
144: END IF;
145: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 176: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

172: l_api_name CONSTANT VARCHAR2(50) := 'Is_Erec_Required';
173: l_isRequired BOOLEAN;
174: BEGIN
175: -- Standard call to check for call compatibility
176: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
177: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if the caller asks me to do so

Line 177: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

173: l_isRequired BOOLEAN;
174: BEGIN
175: -- Standard call to check for call compatibility
176: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
177: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if the caller asks me to do so
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 181: IF FND_API.to_Boolean( p_init_msg_list ) THEN

177: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if the caller asks me to do so
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: BEGIN
189: edr_standard.Erec_Required(
190: P_EVENT => p_event_name,

Line 193: IF l_isRequired THEN x_isRequired_eRec := FND_API.G_TRUE;

189: edr_standard.Erec_Required(
190: P_EVENT => p_event_name,
191: P_EVENT_KEY => p_event_key,
192: P_STATUS => l_isRequired );
193: IF l_isRequired THEN x_isRequired_eRec := FND_API.G_TRUE;
194: ELSE x_isRequired_eRec := FND_API.G_FALSE;
195: END IF;
196: EXCEPTION
197: WHEN OTHERS THEN

Line 194: ELSE x_isRequired_eRec := FND_API.G_FALSE;

190: P_EVENT => p_event_name,
191: P_EVENT_KEY => p_event_key,
192: P_STATUS => l_isRequired );
193: IF l_isRequired THEN x_isRequired_eRec := FND_API.G_TRUE;
194: ELSE x_isRequired_eRec := FND_API.G_FALSE;
195: END IF;
196: EXCEPTION
197: WHEN OTHERS THEN
198: x_isRequired_eRec := FND_API.G_FALSE;

Line 198: x_isRequired_eRec := FND_API.G_FALSE;

194: ELSE x_isRequired_eRec := FND_API.G_FALSE;
195: END IF;
196: EXCEPTION
197: WHEN OTHERS THEN
198: x_isRequired_eRec := FND_API.G_FALSE;
199: fnd_msg_pub.Add;
200: raise fnd_api.G_EXC_ERROR;
201: END;
202: -- fetch the message off the dictionary stack and add to API message list

Line 200: raise fnd_api.G_EXC_ERROR;

196: EXCEPTION
197: WHEN OTHERS THEN
198: x_isRequired_eRec := FND_API.G_FALSE;
199: fnd_msg_pub.Add;
200: raise fnd_api.G_EXC_ERROR;
201: END;
202: -- fetch the message off the dictionary stack and add to API message list
203: -- would only add the last one message in the above api call
204: -- need to do this in the above api after each fnd_message.set_name/set_token

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207: -- Standard call to get message count, and if count is 1, get message info
208: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 212: x_return_status := FND_API.G_RET_STS_ERROR ;

208: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
217: WHEN OTHERS THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
217: WHEN OTHERS THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
219: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
217: WHEN OTHERS THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
219: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
220: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
221: END IF;
222: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 254: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

250: l_eventDetl_tbl edr_standard.eventQuery;
251: lth NUMBER;
252: BEGIN
253: -- Standard call to check for call compatibility
254: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
255: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258: -- Initialize message list if the caller asks me to do so

Line 255: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

251: lth NUMBER;
252: BEGIN
253: -- Standard call to check for call compatibility
254: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
255: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258: -- Initialize message list if the caller asks me to do so
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 259: IF FND_API.to_Boolean( p_init_msg_list ) THEN

255: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258: -- Initialize message list if the caller asks me to do so
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: -- Initialize API return status to success

Line 264: x_return_status := FND_API.G_RET_STS_SUCCESS;

260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: -- Initialize API return status to success
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:
266: FOR lth in 1..p_eventQuery_recTbl.COUNT LOOP
267: l_eventDetl_tbl(lth) := p_eventQuery_recTbl(lth);
268: END LOOP;

Line 271: IF FND_API.To_Boolean( p_commit ) THEN

267: l_eventDetl_tbl(lth) := p_eventQuery_recTbl(lth);
268: END LOOP;
269: x_query_id := edr_standard.Psig_Query ( l_eventDetl_tbl );
270:
271: IF FND_API.To_Boolean( p_commit ) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard call to get message count, and if count is 1, get message info
275: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 278: WHEN FND_API.G_EXC_ERROR THEN

274: -- Standard call to get message count, and if count is 1, get message info
275: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR ;
280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 279: x_return_status := FND_API.G_RET_STS_ERROR ;

275: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR ;
280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR ;
280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR ;
280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
287: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
288: END IF;
289: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 321: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

317: IS
318: l_api_name CONSTANT VARCHAR2(50) := 'Display_Date';
319: l_api_version CONSTANT NUMBER := 1.0;
320: BEGIN
321: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
322: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 322: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

318: l_api_name CONSTANT VARCHAR2(50) := 'Display_Date';
319: l_api_version CONSTANT NUMBER := 1.0;
320: BEGIN
321: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
322: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: IF FND_API.to_Boolean( p_init_msg_list ) THEN
326: FND_MSG_PUB.initialize;

Line 325: IF FND_API.to_Boolean( p_init_msg_list ) THEN

321: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
322: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: IF FND_API.to_Boolean( p_init_msg_list ) THEN
326: FND_MSG_PUB.initialize;
327: END IF;
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 329: x_return_status := FND_API.G_RET_STS_SUCCESS;

325: IF FND_API.to_Boolean( p_init_msg_list ) THEN
326: FND_MSG_PUB.initialize;
327: END IF;
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: edr_standard.Display_Date ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
332:
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 335: WHEN FND_API.G_EXC_ERROR THEN

331: edr_standard.Display_Date ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
332:
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR ;
337: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 336: x_return_status := FND_API.G_RET_STS_ERROR ;

332:
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR ;
337: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR ;
337: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR ;
337: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
343: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
343: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
344: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
345: END IF;
346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 378: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

374: IS
375: l_api_name CONSTANT VARCHAR2(50) := 'Display_Date_Only';
376: l_api_version CONSTANT NUMBER := 1.0;
377: BEGIN
378: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
379: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381:
382: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 379: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

375: l_api_name CONSTANT VARCHAR2(50) := 'Display_Date_Only';
376: l_api_version CONSTANT NUMBER := 1.0;
377: BEGIN
378: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
379: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381:
382: IF FND_API.to_Boolean( p_init_msg_list ) THEN
383: FND_MSG_PUB.initialize;

Line 382: IF FND_API.to_Boolean( p_init_msg_list ) THEN

378: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
379: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381:
382: IF FND_API.to_Boolean( p_init_msg_list ) THEN
383: FND_MSG_PUB.initialize;
384: END IF;
385:
386: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 386: x_return_status := FND_API.G_RET_STS_SUCCESS;

382: IF FND_API.to_Boolean( p_init_msg_list ) THEN
383: FND_MSG_PUB.initialize;
384: END IF;
385:
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: edr_standard.Display_Date_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
389:
390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 392: WHEN FND_API.G_EXC_ERROR THEN

388: edr_standard.Display_Date_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
389:
390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR ;
394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 393: x_return_status := FND_API.G_RET_STS_ERROR ;

389:
390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR ;
394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR ;
394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR ;
394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
401: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
402: END IF;
403: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 435: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

431: IS
432: l_api_name CONSTANT VARCHAR2(50) := 'Display_Time_Only';
433: l_api_version CONSTANT NUMBER := 1.0;
434: BEGIN
435: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
436: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 436: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

432: l_api_name CONSTANT VARCHAR2(50) := 'Display_Time_Only';
433: l_api_version CONSTANT NUMBER := 1.0;
434: BEGIN
435: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
436: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
440: FND_MSG_PUB.initialize;

Line 439: IF FND_API.to_Boolean( p_init_msg_list ) THEN

435: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
436: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
440: FND_MSG_PUB.initialize;
441: END IF;
442:
443: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 443: x_return_status := FND_API.G_RET_STS_SUCCESS;

439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
440: FND_MSG_PUB.initialize;
441: END IF;
442:
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: edr_standard.Display_Time_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
446:
447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 449: WHEN FND_API.G_EXC_ERROR THEN

445: edr_standard.Display_Time_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
446:
447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_ERROR ;
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 450: x_return_status := FND_API.G_RET_STS_ERROR ;

446:
447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_ERROR ;
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_ERROR ;
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

449: WHEN FND_API.G_EXC_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_ERROR ;
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
458: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
459: END IF;
460: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 497: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

493: l_api_version CONSTANT NUMBER := 1.0;
494: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;
495: lth NUMBER;
496: BEGIN
497: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
498: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
499: END IF;
500:
501: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 498: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

494: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;
495: lth NUMBER;
496: BEGIN
497: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
498: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
499: END IF;
500:
501: IF FND_API.to_Boolean( p_init_msg_list ) THEN
502: FND_MSG_PUB.initialize;

Line 501: IF FND_API.to_Boolean( p_init_msg_list ) THEN

497: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
498: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
499: END IF;
500:
501: IF FND_API.to_Boolean( p_init_msg_list ) THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

501: IF FND_API.to_Boolean( p_init_msg_list ) THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: edr_standard.GET_AMERULE_INPUT_VALUES (
508: ameapplication => p_transaction_name,
509: ameruleid => p_ameRule_id,

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514: END LOOP;
515:
516: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
517: EXCEPTION
518: WHEN FND_API.G_EXC_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_ERROR ;
520: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 519: x_return_status := FND_API.G_RET_STS_ERROR ;

515:
516: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
517: EXCEPTION
518: WHEN FND_API.G_EXC_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_ERROR ;
520: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
523: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

517: EXCEPTION
518: WHEN FND_API.G_EXC_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_ERROR ;
520: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
523: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

518: WHEN FND_API.G_EXC_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_ERROR ;
520: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
523: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
523: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
527: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
528: END IF;
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 565: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

561: l_api_version CONSTANT NUMBER := 1.0;
562: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;
563: lth NUMBER;
564: BEGIN
565: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
566: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 566: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

562: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;
563: lth NUMBER;
564: BEGIN
565: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
566: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569: IF FND_API.to_Boolean( p_init_msg_list ) THEN
570: FND_MSG_PUB.initialize;

Line 569: IF FND_API.to_Boolean( p_init_msg_list ) THEN

565: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
566: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569: IF FND_API.to_Boolean( p_init_msg_list ) THEN
570: FND_MSG_PUB.initialize;
571: END IF;
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569: IF FND_API.to_Boolean( p_init_msg_list ) THEN
570: FND_MSG_PUB.initialize;
571: END IF;
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575: edr_standard.GET_AMERULE_INPUT_VARIABLES (
576: transactiontypeid => p_transaction_id,
577: ameruleid => p_ameRule_id,

Line 586: WHEN FND_API.G_EXC_ERROR THEN

582: END LOOP;
583:
584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
585: EXCEPTION
586: WHEN FND_API.G_EXC_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_ERROR ;
588: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 587: x_return_status := FND_API.G_RET_STS_ERROR ;

583:
584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
585: EXCEPTION
586: WHEN FND_API.G_EXC_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_ERROR ;
588: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
591: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

585: EXCEPTION
586: WHEN FND_API.G_EXC_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_ERROR ;
588: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
591: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

586: WHEN FND_API.G_EXC_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_ERROR ;
588: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
591: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
591: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
595: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
596: END IF;
597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 635: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

631: l_api_name CONSTANT VARCHAR2(50) := 'Is_AuditValue_Old';
632: l_isAudited VARCHAR2(10);
633: BEGIN
634: -- Standard call to check for call compatibility
635: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
636: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:
639: -- Initialize message list if the caller asks me to do so

Line 636: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

632: l_isAudited VARCHAR2(10);
633: BEGIN
634: -- Standard call to check for call compatibility
635: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
636: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:
639: -- Initialize message list if the caller asks me to do so
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 640: IF FND_API.to_Boolean( p_init_msg_list ) THEN

636: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:
639: -- Initialize message list if the caller asks me to do so
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:
644: -- Initialize API return status to success

Line 645: x_return_status := FND_API.G_RET_STS_SUCCESS;

641: FND_MSG_PUB.initialize;
642: END IF;
643:
644: -- Initialize API return status to success
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: BEGIN
648: l_isAudited := edr_standard.Compare_AuditValues ( p_table_name,
649: p_column_name, p_primKey_name, p_primKey_value );

Line 650: IF l_isAudited = 'true' THEN x_isOld_auditValue := FND_API.G_TRUE;

646:
647: BEGIN
648: l_isAudited := edr_standard.Compare_AuditValues ( p_table_name,
649: p_column_name, p_primKey_name, p_primKey_value );
650: IF l_isAudited = 'true' THEN x_isOld_auditValue := FND_API.G_TRUE;
651: ELSE x_isOld_auditValue := FND_API.G_FALSE;
652: END IF;
653: EXCEPTION
654: WHEN OTHERS THEN

Line 651: ELSE x_isOld_auditValue := FND_API.G_FALSE;

647: BEGIN
648: l_isAudited := edr_standard.Compare_AuditValues ( p_table_name,
649: p_column_name, p_primKey_name, p_primKey_value );
650: IF l_isAudited = 'true' THEN x_isOld_auditValue := FND_API.G_TRUE;
651: ELSE x_isOld_auditValue := FND_API.G_FALSE;
652: END IF;
653: EXCEPTION
654: WHEN OTHERS THEN
655: x_isOld_auditValue := FND_API.G_FALSE;

Line 655: x_isOld_auditValue := FND_API.G_FALSE;

651: ELSE x_isOld_auditValue := FND_API.G_FALSE;
652: END IF;
653: EXCEPTION
654: WHEN OTHERS THEN
655: x_isOld_auditValue := FND_API.G_FALSE;
656: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_AUDIT_DISABLED' );
657: fnd_msg_pub.Add;
658: raise fnd_api.G_EXC_ERROR;
659: END;

Line 658: raise fnd_api.G_EXC_ERROR;

654: WHEN OTHERS THEN
655: x_isOld_auditValue := FND_API.G_FALSE;
656: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_AUDIT_DISABLED' );
657: fnd_msg_pub.Add;
658: raise fnd_api.G_EXC_ERROR;
659: END;
660: -- fetch the message off the dictionary stack and add to API message list
661: -- would only add the last one message in the above api call
662: -- need to do this in the above api after each fnd_message.set_name/set_token

Line 669: WHEN FND_API.G_EXC_ERROR THEN

665: -- Standard call to get message count, and if count is 1, get message info
666: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
667:
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR ;
671: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 670: x_return_status := FND_API.G_RET_STS_ERROR ;

666: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
667:
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR ;
671: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
674: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR ;
671: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
674: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
675: WHEN OTHERS THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR ;
671: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
674: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
675: WHEN OTHERS THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
674: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
675: WHEN OTHERS THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
678: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
679: END IF;
680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 715: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

711: l_api_version CONSTANT NUMBER := 1.0;
712: l_error_code NUMBER;
713: l_error_mesg VARCHAR2(1000);
714: BEGIN
715: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
716: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: -- Initialize message list if the caller asks me to do so

Line 716: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

712: l_error_code NUMBER;
713: l_error_mesg VARCHAR2(1000);
714: BEGIN
715: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
716: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: -- Initialize message list if the caller asks me to do so
720: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 720: IF FND_API.to_Boolean( p_init_msg_list ) THEN

716: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: -- Initialize message list if the caller asks me to do so
720: IF FND_API.to_Boolean( p_init_msg_list ) THEN
721: FND_MSG_PUB.initialize;
722: END IF;
723:
724: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 724: x_return_status := FND_API.G_RET_STS_SUCCESS;

720: IF FND_API.to_Boolean( p_init_msg_list ) THEN
721: FND_MSG_PUB.initialize;
722: END IF;
723:
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: BEGIN
727: edr_standard.FIND_WF_NTF_RECIPIENT(
728: P_ORIGINAL_RECIPIENT => p_original_recipient,

Line 742: raise fnd_api.G_EXC_ERROR;

738: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
739: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
740: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
741: fnd_msg_pub.Add;
742: raise fnd_api.G_EXC_ERROR;
743: ELSE
744: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_UNEXPECTED' );
745: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
746: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );

Line 748: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

744: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_UNEXPECTED' );
745: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
746: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
747: fnd_msg_pub.Add;
748: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750: END;
751:
752: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 754: WHEN FND_API.G_EXC_ERROR THEN

750: END;
751:
752: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 755: x_return_status := FND_API.G_RET_STS_ERROR ;

751:
752: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
760: WHEN OTHERS THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

754: WHEN FND_API.G_EXC_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
760: WHEN OTHERS THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
760: WHEN OTHERS THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
763: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
764: END IF;
765: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 804: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

800: l_api_name CONSTANT VARCHAR2(50) := 'Get_DescFlex_OnePrompt';
801: l_prompt_type VARCHAR2(20);
802: BEGIN
803: -- Standard call to check for call compatibility
804: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
805: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: -- Initialize message list if the caller asks me to do so

Line 805: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

801: l_prompt_type VARCHAR2(20);
802: BEGIN
803: -- Standard call to check for call compatibility
804: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
805: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: -- Initialize message list if the caller asks me to do so
809: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 809: IF FND_API.to_Boolean( p_init_msg_list ) THEN

805: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: -- Initialize message list if the caller asks me to do so
809: IF FND_API.to_Boolean( p_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812:
813: -- Initialize API return status to success

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

810: FND_MSG_PUB.initialize;
811: END IF;
812:
813: -- Initialize API return status to success
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: IF p_prompt_type is NULL OR p_prompt_type = fnd_api.g_miss_char THEN
817: l_prompt_type := 'LEFT';
818: ELSE l_prompt_type := p_prompt_type;

Line 816: IF p_prompt_type is NULL OR p_prompt_type = fnd_api.g_miss_char THEN

812:
813: -- Initialize API return status to success
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: IF p_prompt_type is NULL OR p_prompt_type = fnd_api.g_miss_char THEN
817: l_prompt_type := 'LEFT';
818: ELSE l_prompt_type := p_prompt_type;
819: END IF;
820:

Line 833: WHEN FND_API.G_EXC_ERROR THEN

829: -- Standard call to get message count, and if count is 1, get message info
830: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
831:
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := FND_API.G_RET_STS_ERROR ;
835: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 834: x_return_status := FND_API.G_RET_STS_ERROR ;

830: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
831:
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := FND_API.G_RET_STS_ERROR ;
835: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := FND_API.G_RET_STS_ERROR ;
835: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
839: WHEN OTHERS THEN
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := FND_API.G_RET_STS_ERROR ;
835: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
839: WHEN OTHERS THEN
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
839: WHEN OTHERS THEN
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
842: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
843: END IF;
844: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 884: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

880: l_api_name CONSTANT VARCHAR2(50) := 'Get_DescFlex_AllPrompts';
881: l_prompt_type VARCHAR2(20);
882: BEGIN
883: -- Standard call to check for call compatibility
884: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
885: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887:
888: -- Initialize message list if the caller asks me to do so

Line 885: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

881: l_prompt_type VARCHAR2(20);
882: BEGIN
883: -- Standard call to check for call compatibility
884: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
885: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887:
888: -- Initialize message list if the caller asks me to do so
889: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 889: IF FND_API.to_Boolean( p_init_msg_list ) THEN

885: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887:
888: -- Initialize message list if the caller asks me to do so
889: IF FND_API.to_Boolean( p_init_msg_list ) THEN
890: FND_MSG_PUB.initialize;
891: END IF;
892:
893: -- Initialize API return status to success

Line 894: x_return_status := FND_API.G_RET_STS_SUCCESS;

890: FND_MSG_PUB.initialize;
891: END IF;
892:
893: -- Initialize API return status to success
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895:
896: IF p_prompt_type is NULL OR p_prompt_type = fnd_api.g_miss_char THEN
897: l_prompt_type := 'LEFT';
898: ELSE l_prompt_type := p_prompt_type;

Line 896: IF p_prompt_type is NULL OR p_prompt_type = fnd_api.g_miss_char THEN

892:
893: -- Initialize API return status to success
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895:
896: IF p_prompt_type is NULL OR p_prompt_type = fnd_api.g_miss_char THEN
897: l_prompt_type := 'LEFT';
898: ELSE l_prompt_type := p_prompt_type;
899: END IF;
900:

Line 971: WHEN FND_API.G_EXC_ERROR THEN

967: -- Standard call to get message count, and if count is 1, get message info
968: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
969:
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 972: x_return_status := FND_API.G_RET_STS_ERROR ;

968: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
969:
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
976: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
976: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
977: WHEN OTHERS THEN
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

971: WHEN FND_API.G_EXC_ERROR THEN
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
976: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
977: WHEN OTHERS THEN
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
976: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
977: WHEN OTHERS THEN
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
980: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
981: END IF;
982: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1011: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

1007: IS
1008: l_api_name CONSTANT VARCHAR2(50) := 'Get_Lookup_Meaning';
1009: l_api_version CONSTANT NUMBER := 1.0;
1010: BEGIN
1011: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
1012: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014:
1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1012: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

1008: l_api_name CONSTANT VARCHAR2(50) := 'Get_Lookup_Meaning';
1009: l_api_version CONSTANT NUMBER := 1.0;
1010: BEGIN
1011: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
1012: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014:
1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1016: FND_MSG_PUB.initialize;

Line 1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1011: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
1012: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014:
1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1016: FND_MSG_PUB.initialize;
1017: END IF;
1018:
1019: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1019: x_return_status := FND_API.G_RET_STS_SUCCESS;

1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1016: FND_MSG_PUB.initialize;
1017: END IF;
1018:
1019: x_return_status := FND_API.G_RET_STS_SUCCESS;
1020:
1021: edr_standard.Get_Meaning ( P_LOOKUP_TYPE => p_lookup_type,
1022: P_LOOKUP_CODE => p_lookup_code,
1023: P_MEANING => x_lkup_meaning );

Line 1027: WHEN FND_API.G_EXC_ERROR THEN

1023: P_MEANING => x_lkup_meaning );
1024:
1025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1026: EXCEPTION
1027: WHEN FND_API.G_EXC_ERROR THEN
1028: x_return_status := FND_API.G_RET_STS_ERROR ;
1029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1028: x_return_status := FND_API.G_RET_STS_ERROR ;

1024:
1025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1026: EXCEPTION
1027: WHEN FND_API.G_EXC_ERROR THEN
1028: x_return_status := FND_API.G_RET_STS_ERROR ;
1029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1026: EXCEPTION
1027: WHEN FND_API.G_EXC_ERROR THEN
1028: x_return_status := FND_API.G_RET_STS_ERROR ;
1029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1027: WHEN FND_API.G_EXC_ERROR THEN
1028: x_return_status := FND_API.G_RET_STS_ERROR ;
1029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1036: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
1037: END IF;
1038: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1070: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

1066: l_api_version CONSTANT NUMBER := 1.0;
1067: l_api_name CONSTANT VARCHAR2(50) := 'Get_QueryId_OnParams';
1068: BEGIN
1069: -- Standard call to check for call compatibility
1070: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
1071: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073:
1074: -- Initialize message list if the caller asks me to do so

Line 1071: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

1067: l_api_name CONSTANT VARCHAR2(50) := 'Get_QueryId_OnParams';
1068: BEGIN
1069: -- Standard call to check for call compatibility
1070: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
1071: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073:
1074: -- Initialize message list if the caller asks me to do so
1075: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1075: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1071: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073:
1074: -- Initialize message list if the caller asks me to do so
1075: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1076: FND_MSG_PUB.initialize;
1077: END IF;
1078:
1079: -- Initialize API return status to success

Line 1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

1076: FND_MSG_PUB.initialize;
1077: END IF;
1078:
1079: -- Initialize API return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:
1082: edr_standard.Psig_Query_One(
1083: P_EVENT_NAME => p_eventNames_tbl,
1084: P_EVENT_KEY => p_eventKeys_tbl,

Line 1087: IF FND_API.To_Boolean( p_commit ) THEN

1083: P_EVENT_NAME => p_eventNames_tbl,
1084: P_EVENT_KEY => p_eventKeys_tbl,
1085: O_QUERY_ID => x_query_id );
1086:
1087: IF FND_API.To_Boolean( p_commit ) THEN
1088: COMMIT WORK;
1089: END IF;
1090: -- Standard call to get message count, and if count is 1, get message info
1091: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1094: WHEN FND_API.G_EXC_ERROR THEN

1090: -- Standard call to get message count, and if count is 1, get message info
1091: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_ERROR ;
1096: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1095: x_return_status := FND_API.G_RET_STS_ERROR ;

1091: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_ERROR ;
1096: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_ERROR ;
1096: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1100: WHEN OTHERS THEN
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1094: WHEN FND_API.G_EXC_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_ERROR ;
1096: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1100: WHEN OTHERS THEN
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1102: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1100: WHEN OTHERS THEN
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1102: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1103: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
1104: END IF;
1105: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1133: IF NOT FND_API.Compatible_API_Call (l_api_version ,

1129:
1130: BEGIN
1131: -- Standard call to check for call compatibility.
1132:
1133: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1134: p_api_version ,
1135: l_api_name ,
1136: G_PKG_NAME )
1137: THEN

Line 1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1134: p_api_version ,
1135: l_api_name ,
1136: G_PKG_NAME )
1137: THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140:
1141: -- Initialize message list if p_init_msg_list is set to TRUE.
1142:

Line 1143: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1139: END IF;
1140:
1141: -- Initialize message list if p_init_msg_list is set to TRUE.
1142:
1143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1144: FND_MSG_PUB.initialize;
1145: END IF;
1146:
1147: -- Initialize API return status to success

Line 1148: x_return_status := FND_API.G_RET_STS_SUCCESS;

1144: FND_MSG_PUB.initialize;
1145: END IF;
1146:
1147: -- Initialize API return status to success
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149:
1150: -- Following code gets the current eRecord Id into out variable
1151:
1152: --Bug 3935913: Start

Line 1168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1164: p_data => x_msg_data
1165: );
1166:
1167: EXCEPTION
1168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1170:
1171: FND_MSG_PUB.Count_And_Get
1172: ( p_count => x_msg_count ,

Line 1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1165: );
1166:
1167: EXCEPTION
1168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1170:
1171: FND_MSG_PUB.Count_And_Get
1172: ( p_count => x_msg_count ,
1173: p_data => x_msg_data

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1173: p_data => x_msg_data
1174: );
1175:
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178:
1179: IF FND_MSG_PUB.Check_Msg_Level
1180: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1181: THEN