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_EVIDENCESTORE_PUB dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

58: END IF;
59:
60: -- Initialize message list if the caller asks me to do so
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- Initialize API return status to success
66: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 83: fnd_msg_pub.Add;

79: IF l_error_code > 0 THEN -- l_error_code = 21000 refers to TIMEZONE
80: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
81: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
82: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
83: fnd_msg_pub.Add;
84: raise fnd_api.G_EXC_ERROR;
85: END IF;
86: -- fetch the message off the dictionary stack and add to API message list
87: -- would only add the last one message in the above api call

Line 89: FND_MSG_PUB.Add;

85: END IF;
86: -- fetch the message off the dictionary stack and add to API message list
87: -- would only add the last one message in the above api call
88: -- need to do this in the above api after each fnd_message.set_name/set_token
89: FND_MSG_PUB.Add;
90:
91: IF FND_API.To_Boolean( p_commit ) THEN
92: COMMIT WORK;
93: END IF;

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

91: IF FND_API.To_Boolean( p_commit ) THEN
92: COMMIT WORK;
93: END IF;
94: -- Standard call to get message count, and if count is 1, get message info
95: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
96:
97: EXCEPTION
98: WHEN FND_API.G_EXC_ERROR THEN
99: x_return_status := FND_API.G_RET_STS_ERROR ;

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

96:
97: EXCEPTION
98: WHEN FND_API.G_EXC_ERROR THEN
99: x_return_status := FND_API.G_RET_STS_ERROR ;
100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
104: WHEN OTHERS THEN

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

99: x_return_status := FND_API.G_RET_STS_ERROR ;
100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
107: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 106: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
107: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
108: END IF;
109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
110: END Open_Document;

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

103: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
107: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
108: END IF;
109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
110: END Open_Document;
111:

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

105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
107: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
108: END IF;
109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
110: END Open_Document;
111:
112:
113: -- --------------------------------------

Line 146: FND_MSG_PUB.initialize;

142: END IF;
143:
144: -- Initialize message list if the caller asks me to do so
145: IF FND_API.to_Boolean( p_init_msg_list ) THEN
146: FND_MSG_PUB.initialize;
147: END IF;
148:
149: -- Initialize API return status to success
150: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 162: fnd_msg_pub.Add;

158: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist
159: fnd_message.Set_Name('EDR', 'EDR_PLS_STDMSG_GENERATED' );
160: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
161: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
162: fnd_msg_pub.Add;
163: raise fnd_api.G_EXC_ERROR;
164: END IF;
165:
166: IF FND_API.To_Boolean( p_commit ) THEN

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

165:
166: IF FND_API.To_Boolean( p_commit ) THEN
167: COMMIT WORK;
168: END IF;
169: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
170:
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173: x_return_status := FND_API.G_RET_STS_ERROR ;

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

170:
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
178: WHEN OTHERS THEN

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

173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
178: WHEN OTHERS THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
181: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 180: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
178: WHEN OTHERS THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
181: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
182: END IF;
183: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
184: END Change_DocumentStatus;

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

177: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
178: WHEN OTHERS THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
181: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
182: END IF;
183: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
184: END Change_DocumentStatus;
185:

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

179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
181: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
182: END IF;
183: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
184: END Change_DocumentStatus;
185:
186:
187: -- --------------------------------------

Line 233: FND_MSG_PUB.initialize;

229: END IF;
230:
231: -- Initialize message list if the caller asks me to do so
232: IF FND_API.to_Boolean( p_init_msg_list ) THEN
233: FND_MSG_PUB.initialize;
234: END IF;
235:
236: -- Initialize API return status to success
237: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 254: fnd_msg_pub.Add;

250: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist
251: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
252: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
253: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
254: fnd_msg_pub.Add;
255: raise fnd_api.G_EXC_ERROR;
256: END IF;
257: FND_MSG_PUB.Add;
258:

Line 257: FND_MSG_PUB.Add;

253: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
254: fnd_msg_pub.Add;
255: raise fnd_api.G_EXC_ERROR;
256: END IF;
257: FND_MSG_PUB.Add;
258:
259: IF FND_API.To_Boolean( p_commit ) THEN
260: COMMIT WORK;
261: END IF;

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

258:
259: IF FND_API.To_Boolean( p_commit ) THEN
260: COMMIT WORK;
261: END IF;
262: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: x_return_status := FND_API.G_RET_STS_ERROR ;

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

263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: x_return_status := FND_API.G_RET_STS_ERROR ;
267: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
271: WHEN OTHERS THEN

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

266: x_return_status := FND_API.G_RET_STS_ERROR ;
267: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
271: WHEN OTHERS THEN
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
274: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 273: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
271: WHEN OTHERS THEN
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
274: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
275: END IF;
276: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
277: END Update_Document;

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

270: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
271: WHEN OTHERS THEN
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
274: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
275: END IF;
276: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
277: END Update_Document;
278:

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

272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
274: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
275: END IF;
276: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
277: END Update_Document;
278:
279:
280: -- --------------------------------------

Line 314: FND_MSG_PUB.initialize;

310: END IF;
311:
312: -- Initialize message list if the caller asks me to do so
313: IF FND_API.to_Boolean( p_init_msg_list ) THEN
314: FND_MSG_PUB.initialize;
315: END IF;
316:
317: -- Initialize API return status to success
318: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 332: fnd_msg_pub.Add;

328: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist
329: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
330: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
331: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
332: fnd_msg_pub.Add;
333: raise fnd_api.G_EXC_ERROR;
334: END IF;
335: IF FND_API.To_Boolean( p_commit ) THEN
336: COMMIT WORK;

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

334: END IF;
335: IF FND_API.To_Boolean( p_commit ) THEN
336: COMMIT WORK;
337: END IF;
338: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
339:
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: x_return_status := FND_API.G_RET_STS_ERROR ;

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

339:
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: x_return_status := FND_API.G_RET_STS_ERROR ;
343: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
347: WHEN OTHERS THEN

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_ERROR ;
343: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
347: WHEN OTHERS THEN
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
350: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 349: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
347: WHEN OTHERS THEN
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
350: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
351: END IF;
352: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
353: END Post_DocumentParameters;

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

346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
347: WHEN OTHERS THEN
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
350: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
351: END IF;
352: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
353: END Post_DocumentParameters;
354:

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

348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
350: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
351: END IF;
352: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
353: END Post_DocumentParameters;
354:
355:
356: -- --------------------------------------

Line 389: FND_MSG_PUB.initialize;

385: END IF;
386:
387: -- Initialize message list if the caller asks me to do so
388: IF FND_API.to_Boolean( p_init_msg_list ) THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: -- Initialize API return status to success
393: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 402: fnd_msg_pub.Add;

398: IF l_error_code > 0 THEN
399: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
400: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
401: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
402: fnd_msg_pub.Add;
403: raise fnd_api.G_EXC_ERROR;
404: END IF;
405:
406: IF FND_API.To_Boolean( p_commit ) THEN

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

405:
406: IF FND_API.To_Boolean( p_commit ) THEN
407: COMMIT WORK;
408: END IF;
409: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
410:
411: EXCEPTION
412: WHEN FND_API.G_EXC_ERROR THEN
413: x_return_status := FND_API.G_RET_STS_ERROR ;

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

410:
411: EXCEPTION
412: WHEN FND_API.G_EXC_ERROR THEN
413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
418: WHEN OTHERS THEN

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

413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
418: WHEN OTHERS THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
421: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 420: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
418: WHEN OTHERS THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
421: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
422: END IF;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
424: END Close_Document;

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

417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
418: WHEN OTHERS THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
421: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
422: END IF;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
424: END Close_Document;
425:

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

419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
421: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
422: END IF;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
424: END Close_Document;
425:
426:
427: -- --------------------------------------

Line 458: FND_MSG_PUB.initialize;

454: END IF;
455:
456: -- Initialize message list if the caller asks me to do so
457: IF FND_API.to_Boolean( p_init_msg_list ) THEN
458: FND_MSG_PUB.initialize;
459: END IF;
460:
461: -- Initialize API return status to success
462: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 473: fnd_msg_pub.Add;

469: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist
470: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
471: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
472: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
473: fnd_msg_pub.Add;
474: raise fnd_api.G_EXC_ERROR;
475: END IF;
476:
477: IF FND_API.To_Boolean( p_commit ) THEN

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

476:
477: IF FND_API.To_Boolean( p_commit ) THEN
478: COMMIT WORK;
479: END IF;
480: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: x_return_status := FND_API.G_RET_STS_ERROR ;

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

481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
488: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
489: WHEN OTHERS THEN

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

484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
488: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
492: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 491: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
488: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
492: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
493: END IF;
494: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
495: END Cancel_Document;

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

488: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
492: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
493: END IF;
494: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
495: END Cancel_Document;
496:

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

490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
492: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
493: END IF;
494: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
495: END Cancel_Document;
496:
497:
498: -- --------------------------------------

Line 537: FND_MSG_PUB.initialize;

533: END IF;
534:
535: -- Initialize message list if the caller asks me to do so
536: IF FND_API.to_Boolean( p_init_msg_list ) THEN
537: FND_MSG_PUB.initialize;
538: END IF;
539:
540: -- Initialize API return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 555: fnd_msg_pub.Add;

551: IF l_error_code > 0 THEN
552: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
553: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
554: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
555: fnd_msg_pub.Add;
556: raise fnd_api.G_EXC_ERROR;
557: END IF;
558:
559:

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

559:
560: IF FND_API.To_Boolean( p_commit ) THEN
561: COMMIT WORK;
562: END IF;
563: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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

563: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
568: x_return_status := FND_API.G_RET_STS_ERROR ;
569: --FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
568: x_return_status := FND_API.G_RET_STS_ERROR ;
569: --FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
573: WHEN OTHERS THEN

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

568: x_return_status := FND_API.G_RET_STS_ERROR ;
569: --FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
573: WHEN OTHERS THEN
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
576: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 575: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
573: WHEN OTHERS THEN
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
576: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
577: END IF;
578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
579: END Request_Signature;

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

572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
573: WHEN OTHERS THEN
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
576: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
577: END IF;
578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
579: END Request_Signature;
580:

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

574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
576: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
577: END IF;
578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
579: END Request_Signature;
580:
581:
582: -- --------------------------------------

Line 625: FND_MSG_PUB.initialize;

621: END IF;
622:
623: -- Initialize message list if the caller asks me to do so
624: IF FND_API.to_Boolean( p_init_msg_list ) THEN
625: FND_MSG_PUB.initialize;
626: END IF;
627:
628: -- Initialize API return status to success
629: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 645: fnd_msg_pub.Add;

641: IF l_error_code > 0 THEN
642: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
643: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
644: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
645: fnd_msg_pub.Add;
646: raise fnd_api.G_EXC_ERROR;
647: END IF;
648:
649: IF FND_API.To_Boolean( p_commit ) THEN

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

648:
649: IF FND_API.To_Boolean( p_commit ) THEN
650: COMMIT WORK;
651: END IF;
652: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
653:
654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: x_return_status := FND_API.G_RET_STS_ERROR ;

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

653:
654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: x_return_status := FND_API.G_RET_STS_ERROR ;
657: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
660: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
661: WHEN OTHERS THEN

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

656: x_return_status := FND_API.G_RET_STS_ERROR ;
657: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
660: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
664: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 663: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
660: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
664: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
665: END IF;
666: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
667: END Post_Signature;

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

660: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
664: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
665: END IF;
666: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
667: END Post_Signature;
668:

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

662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
664: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
665: END IF;
666: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
667: END Post_Signature;
668:
669:
670: -- --------------------------------------

Line 704: FND_MSG_PUB.initialize;

700: END IF;
701:
702: -- Initialize message list if the caller asks me to do so
703: IF FND_API.to_Boolean( p_init_msg_list ) THEN
704: FND_MSG_PUB.initialize;
705: END IF;
706:
707: -- Initialize API return status to success
708: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 724: fnd_msg_pub.Add;

720: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist
721: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
722: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
723: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
724: fnd_msg_pub.Add;
725: raise fnd_api.G_EXC_ERROR;
726: END IF;
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;

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

726: END IF;
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
731:
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: x_return_status := FND_API.G_RET_STS_ERROR ;

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

731:
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
738: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
739: WHEN OTHERS THEN

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

734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
738: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
739: WHEN OTHERS THEN
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
742: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 741: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
738: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
739: WHEN OTHERS THEN
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
742: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
743: END IF;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
745: END Post_SignatureParameters;

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

738: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
739: WHEN OTHERS THEN
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
742: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
743: END IF;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
745: END Post_SignatureParameters;
746:

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

740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
742: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
743: END IF;
744: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
745: END Post_SignatureParameters;
746:
747:
748:

Line 788: FND_MSG_PUB.initialize;

784: END IF;
785:
786: -- Initialize message list if the caller asks me to do so
787: IF FND_API.to_Boolean( p_init_msg_list ) THEN
788: FND_MSG_PUB.initialize;
789: END IF;
790:
791: -- Initialize API return status to success
792: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 828: fnd_msg_pub.Add;

824: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist
825: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
826: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
827: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
828: fnd_msg_pub.Add;
829: raise fnd_api.G_EXC_ERROR;
830: END IF;
831: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
832:

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

827: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
828: fnd_msg_pub.Add;
829: raise fnd_api.G_EXC_ERROR;
830: END IF;
831: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
832:
833: EXCEPTION
834: WHEN FND_API.G_EXC_ERROR THEN
835: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

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

Line 842: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

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

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

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

841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
842: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
843: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
844: END IF;
845: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
846: END Get_DocumentDetails;
847:
848:
849:

Line 892: FND_MSG_PUB.initialize;

888: END IF;
889:
890: -- Initialize message list if the caller asks me to do so
891: IF FND_API.to_Boolean( p_init_msg_list ) THEN
892: FND_MSG_PUB.initialize;
893: END IF;
894:
895: -- Initialize API return status to success
896: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 929: fnd_msg_pub.Add;

925: IF l_error_code > 0 THEN -- l_error_code = 21001 document closed or not exist
926: fnd_message.Set_Name( 'EDR', 'EDR_PLS_STDMSG_GENERATED' );
927: fnd_message.Set_Token( 'ERR_CODE', l_error_code );
928: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
929: fnd_msg_pub.Add;
930: raise fnd_api.G_EXC_ERROR;
931: END IF;
932: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
933:

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

928: fnd_message.Set_Token( 'ERR_MESG', l_error_mesg );
929: fnd_msg_pub.Add;
930: raise fnd_api.G_EXC_ERROR;
931: END IF;
932: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
933:
934: EXCEPTION
935: WHEN FND_API.G_EXC_ERROR THEN
936: x_return_status := FND_API.G_RET_STS_ERROR ;

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

933:
934: EXCEPTION
935: WHEN FND_API.G_EXC_ERROR THEN
936: x_return_status := FND_API.G_RET_STS_ERROR ;
937: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
941: WHEN OTHERS THEN

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

936: x_return_status := FND_API.G_RET_STS_ERROR ;
937: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
941: WHEN OTHERS THEN
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
944: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 943: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
941: WHEN OTHERS THEN
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
944: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
945: END IF;
946: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
947:

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

940: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
941: WHEN OTHERS THEN
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
944: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
945: END IF;
946: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
947:
948: END Get_SignatureDetails;

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

942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
944: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
945: END IF;
946: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
947:
948: END Get_SignatureDetails;
949:
950:

Line 1019: FND_MSG_PUB.initialize;

1015: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1016: END IF;
1017:
1018: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1019: FND_MSG_PUB.initialize;
1020: END IF;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:

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

1045:
1046: Close_Document( p_api_version, p_init_msg_list, p_commit, x_return_status,
1047: x_msg_count, x_msg_data, l_document_id );
1048:
1049: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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

1049: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1057: WHEN OTHERS THEN

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

1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1057: WHEN OTHERS THEN
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1060: THEN FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

Line 1059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1057: WHEN OTHERS THEN
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1060: THEN FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
1061: END IF;
1062: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1063: END Capture_Signature;

Line 1060: THEN FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

1056: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1057: WHEN OTHERS THEN
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1060: THEN FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
1061: END IF;
1062: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1063: END Capture_Signature;
1064:

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

1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1060: THEN FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
1061: END IF;
1062: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1063: END Capture_Signature;
1064:
1065:
1066: END EDR_EvidenceStore_PUB;