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_MSG_PUB

Line 42: FND_MSG_PUB.initialize;

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
46: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 54: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

50: P_EVENT_KEY => p_event_key,
51: P_STATUS => x_psig_status );
52:
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 ;

Line 59: 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 );
63: WHEN OTHERS THEN

Line 62: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
66: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 65: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
69: END Get_PsigStatus;

Line 66: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
69: END Get_PsigStatus;
70:

Line 68: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
69: END Get_PsigStatus;
70:
71:
72: -- --------------------------------------

Line 105: FND_MSG_PUB.initialize;

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
109: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 122: fnd_msg_pub.Add;

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
126: -- would only add the last one message in the above api call

Line 128: FND_MSG_PUB.Add;

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
128: FND_MSG_PUB.Add;
129:
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:

Line 131: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

127: -- need to do this in the above api after each fnd_message.set_name/set_token
128: FND_MSG_PUB.Add;
129:
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 ;

Line 136: 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 );
140: WHEN OTHERS THEN

Line 139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
143: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 142: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
146: END Is_eSig_Required;

Line 143: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
146: END Is_eSig_Required;
147:

Line 145: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
146: END Is_eSig_Required;
147:
148:
149: -- --------------------------------------

Line 182: FND_MSG_PUB.initialize;

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
186: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 199: fnd_msg_pub.Add;

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
203: -- would only add the last one message in the above api call

Line 205: FND_MSG_PUB.Add;

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
205: FND_MSG_PUB.Add;
206:
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:

Line 208: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

204: -- need to do this in the above api after each fnd_message.set_name/set_token
205: FND_MSG_PUB.Add;
206:
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 ;

Line 213: 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 );
217: WHEN OTHERS THEN

Line 216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
220: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 219: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
223: END Is_eRec_Required;

Line 220: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
223: END Is_eRec_Required;
224:

Line 222: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
223: END Is_eRec_Required;
224:
225:
226: -- --------------------------------------

Line 260: FND_MSG_PUB.initialize;

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
264: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 275: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 280: 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 );
284: WHEN OTHERS THEN

Line 283: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
287: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 286: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
290: END Get_QueryId_OnEvents;

Line 287: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
290: END Get_QueryId_OnEvents;
291:

Line 289: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
290: END Get_QueryId_OnEvents;
291:
292:
293: -- --------------------------------------

Line 326: FND_MSG_PUB.initialize;

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;
330:

Line 333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
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 );

Line 337: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
341: WHEN OTHERS THEN

Line 340: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
344: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 343: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
347: END Display_Date;

Line 344: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
347: END Display_Date;
348:

Line 346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
347: END Display_Date;
348:
349: -- BUG: 3075771 New Procedure added to return date only
350: -- --------------------------------------

Line 383: FND_MSG_PUB.initialize;

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;
387:

Line 390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
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 );

Line 394: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
398: WHEN OTHERS THEN

Line 397: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
401: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 400: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
404: END Display_Date_Only;

Line 401: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
404: END Display_Date_Only;
405:

Line 403: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
404: END Display_Date_Only;
405:
406: -- BUG: 3075771 New Procedure added to return time only
407: -- --------------------------------------

Line 440: FND_MSG_PUB.initialize;

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;
444:

Line 447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
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 );

Line 451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
455: WHEN OTHERS THEN

Line 454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
458: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
461: END Display_Time_Only;

Line 458: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
461: END Display_Time_Only;
462:

Line 460: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
461: END Display_Time_Only;
462:
463:
464: -- --------------------------------------

Line 502: FND_MSG_PUB.initialize;

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;
506:

Line 516: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

512: FOR lth IN 1..l_ruleVar_values.COUNT LOOP
513: x_inputVar_values_tbl(lth) := l_ruleVar_values(lth);
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 );

Line 520: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
524: WHEN OTHERS THEN

Line 523: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
527: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 526: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
530: END Get_AmeRule_VarValues;

Line 527: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
530: END Get_AmeRule_VarValues;
531:

Line 529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
530: END Get_AmeRule_VarValues;
531:
532:
533: /* New API that takes Transaction Type Id as the Input parameter instead of Transaction Name */

Line 570: FND_MSG_PUB.initialize;

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;
574:

Line 584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

580: FOR lth IN 1..l_ruleVar_values.COUNT LOOP
581: x_inputVar_values_tbl(lth) := l_ruleVar_values(lth);
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 );

Line 588: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
592: WHEN OTHERS THEN

Line 591: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
595: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 594: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
598:

Line 595: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
598:
599: END Get_AmeRule_VariableValues;

Line 597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
598:
599: END Get_AmeRule_VariableValues;
600:
601: -- Bug 3214495 : End

Line 641: FND_MSG_PUB.initialize;

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
645: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 657: fnd_msg_pub.Add;

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;
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

Line 663: FND_MSG_PUB.Add;

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
663: FND_MSG_PUB.Add;
664:
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:

Line 666: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

662: -- need to do this in the above api after each fnd_message.set_name/set_token
663: FND_MSG_PUB.Add;
664:
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 ;

Line 671: 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 );
675: WHEN OTHERS THEN

Line 674: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
678: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
681: END Is_AuditValue_Old;

Line 678: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
681: END Is_AuditValue_Old;
682:

Line 680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
681: END Is_AuditValue_Old;
682:
683:
684: -- --------------------------------------

Line 721: FND_MSG_PUB.initialize;

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;
725:

Line 741: fnd_msg_pub.Add;

737: IF l_error_code > 0 THEN
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 );

Line 747: fnd_msg_pub.Add;

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 );
747: fnd_msg_pub.Add;
748: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750: END;
751:

Line 752: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
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 );

Line 756: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
760: WHEN OTHERS THEN

Line 759: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
763: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 762: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
766: END Get_Notif_Routing_Info;

Line 763: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
766: END Get_Notif_Routing_Info;
767:

Line 765: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
766: END Get_Notif_Routing_Info;
767:
768:
769:

Line 810: FND_MSG_PUB.initialize;

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
814: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 830: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

826: P_PROMPT_TYPE => l_prompt_type ,
827: P_COLUMN_PROMPT => x_column_prompt );
828:
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 ;

Line 835: 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 );
839: WHEN OTHERS THEN

Line 838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
842: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 841: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
845: END Get_DescFlex_OnePrompt;

Line 842: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
845: END Get_DescFlex_OnePrompt;
846:

Line 844: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
845: END Get_DescFlex_OnePrompt;
846:
847:
848: -- --------------------------------------

Line 890: FND_MSG_PUB.initialize;

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
894: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 968: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

964: P_COLUMN29_PROMPT => x_colnPrompts_rec.P_COLUMN29_PROMPT,
965: P_COLUMN30_PROMPT => x_colnPrompts_rec.P_COLUMN30_PROMPT );
966:
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 ;

Line 973: 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 );
977: WHEN OTHERS THEN

Line 976: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
980: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 979: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
983: END Get_DescFlex_AllPrompts;

Line 980: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
983: END Get_DescFlex_AllPrompts;
984:

Line 982: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
983: END Get_DescFlex_AllPrompts;
984:
985:
986: -- --------------------------------------

Line 1016: FND_MSG_PUB.initialize;

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;
1020:

Line 1025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

1021: edr_standard.Get_Meaning ( P_LOOKUP_TYPE => p_lookup_type,
1022: P_LOOKUP_CODE => p_lookup_code,
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 );

Line 1029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
1033: WHEN OTHERS THEN

Line 1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
1036: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 1035: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
1039: END Get_Lookup_Meaning;

Line 1036: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
1039: END Get_Lookup_Meaning;
1040:

Line 1038: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
1039: END Get_Lookup_Meaning;
1040:
1041:
1042: /**** It is a simplied version wrapped over PSIG_QUERY for Java api ***/

Line 1076: FND_MSG_PUB.initialize;

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
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1091: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1096: 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 );
1100: WHEN OTHERS THEN

Line 1099: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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
1103: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 1102: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_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 );
1106: END Get_QueryId_OnParams;

Line 1103: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

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 );
1106: END Get_QueryId_OnParams;
1107:

Line 1105: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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 );
1106: END Get_QueryId_OnParams;
1107:
1108:
1109: -- Following procedure returns current eRecord ID for

Line 1144: FND_MSG_PUB.initialize;

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
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1162: FND_MSG_PUB.Count_And_Get

1158: edr_ctx_pkg.unset_secure_attr;
1159: --Bug 3935913: End
1160: -- Standard call to get message count and if count is 1,
1161: --get message info.
1162: FND_MSG_PUB.Count_And_Get
1163: ( p_count => x_msg_count ,
1164: p_data => x_msg_data
1165: );
1166:

Line 1171: FND_MSG_PUB.Count_And_Get

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
1174: );
1175:

Line 1179: IF FND_MSG_PUB.Check_Msg_Level

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
1182: FND_MSG_PUB.Add_Exc_Msg
1183: ( G_PKG_NAME ,

Line 1180: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1182: FND_MSG_PUB.Add_Exc_Msg
1183: ( G_PKG_NAME ,
1184: l_api_name

Line 1182: FND_MSG_PUB.Add_Exc_Msg

1178:
1179: IF FND_MSG_PUB.Check_Msg_Level
1180: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1181: THEN
1182: FND_MSG_PUB.Add_Exc_Msg
1183: ( G_PKG_NAME ,
1184: l_api_name
1185: );
1186: END IF;

Line 1188: FND_MSG_PUB.Count_And_Get

1184: l_api_name
1185: );
1186: END IF;
1187:
1188: FND_MSG_PUB.Count_And_Get
1189: (p_count => x_msg_count ,
1190: p_data => x_msg_data
1191: );
1192: END GET_ERECORD_ID;