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.CN_REASONS_PUB dependencies on FND_API

Line 46: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

42: END; */
43: --
44: PROCEDURE show_analyst_notes(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
47: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
48: p_commit IN VARCHAR2 := CN_API.G_FALSE,
49: p_first IN NUMBER,
50: p_last IN NUMBER,

Line 47: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

43: --
44: PROCEDURE show_analyst_notes(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
47: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
48: p_commit IN VARCHAR2 := CN_API.G_FALSE,
49: p_first IN NUMBER,
50: p_last IN NUMBER,
51: p_payment_worksheet_id IN NUMBER,

Line 101: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT show_analyst_notes;
100: -- Standard call to check for call compatibility.
101: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
102: p_api_version ,
103: l_api_name,
104: G_PKG_NAME ) THEN
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

101: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
102: p_api_version ,
103: l_api_name,
104: G_PKG_NAME ) THEN
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
109: FND_MSG_PUB.initialize;

Line 108: IF FND_API.to_Boolean( p_init_msg_list ) THEN

104: G_PKG_NAME ) THEN
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111: -- Initialize API return status to success
112: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111: -- Initialize API return status to success
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113: x_loading_status := 'CN_INSERTED';
114: -- API body
115: -- Populate the worksheet information using this cursor and pass it to
116: -- JSP

Line 163: WHEN FND_API.G_EXC_ERROR THEN

159: END IF;
160: END LOOP;
161: x_notes_count := l_total_rows;
162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO show_analyst_notes;
165: x_return_status := FND_API.G_RET_STS_ERROR ;
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count ,

Line 165: x_return_status := FND_API.G_RET_STS_ERROR ;

161: x_notes_count := l_total_rows;
162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO show_analyst_notes;
165: x_return_status := FND_API.G_RET_STS_ERROR ;
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count ,
168: p_data => x_msg_data ,
169: p_encoded => FND_API.G_FALSE);

Line 169: p_encoded => FND_API.G_FALSE);

165: x_return_status := FND_API.G_RET_STS_ERROR ;
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count ,
168: p_data => x_msg_data ,
169: p_encoded => FND_API.G_FALSE);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO show_analyst_notes;
172: x_loading_status := 'UNEXPECTED_ERR';
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count ,
168: p_data => x_msg_data ,
169: p_encoded => FND_API.G_FALSE);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO show_analyst_notes;
172: x_loading_status := 'UNEXPECTED_ERR';
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: FND_MSG_PUB.Count_And_Get(

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

169: p_encoded => FND_API.G_FALSE);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO show_analyst_notes;
172: x_loading_status := 'UNEXPECTED_ERR';
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: FND_MSG_PUB.Count_And_Get(
175: p_count => x_msg_count ,
176: p_data => x_msg_data ,
177: p_encoded => FND_API.G_FALSE);

Line 177: p_encoded => FND_API.G_FALSE);

173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: FND_MSG_PUB.Count_And_Get(
175: p_count => x_msg_count ,
176: p_data => x_msg_data ,
177: p_encoded => FND_API.G_FALSE);
178: WHEN OTHERS THEN
179: ROLLBACK TO show_analyst_notes;
180: x_loading_status := 'UNEXPECTED_ERR';
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

177: p_encoded => FND_API.G_FALSE);
178: WHEN OTHERS THEN
179: ROLLBACK TO show_analyst_notes;
180: x_loading_status := 'UNEXPECTED_ERR';
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
182: IF FND_MSG_PUB.Check_Msg_Level(
183: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
185: END IF;

Line 189: p_encoded => FND_API.G_FALSE);

185: END IF;
186: FND_MSG_PUB.Count_And_Get(
187: p_count => x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => FND_API.G_FALSE);
190: END;
191: --
192: PROCEDURE manage_analyst_notes(
193: p_api_version IN NUMBER,

Line 194: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

190: END;
191: --
192: PROCEDURE manage_analyst_notes(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
195: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
196: p_commit IN VARCHAR2 := CN_API.G_FALSE,
197: p_notes_tbl IN cn_reasons_pub.notes_tbl,
198: x_return_status OUT NOCOPY VARCHAR2,

Line 195: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

191: --
192: PROCEDURE manage_analyst_notes(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
195: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
196: p_commit IN VARCHAR2 := CN_API.G_FALSE,
197: p_notes_tbl IN cn_reasons_pub.notes_tbl,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,

Line 211: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

207: BEGIN
208: -- Standard Start of API savepoint
209: SAVEPOINT manage_analyst_notes;
210: -- Standard call to check for call compatibility.
211: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
212: p_api_version ,
213: l_api_name,
214: G_PKG_NAME ) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
212: p_api_version ,
213: l_api_name,
214: G_PKG_NAME ) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
219: FND_MSG_PUB.initialize;

Line 218: IF FND_API.to_Boolean( p_init_msg_list ) THEN

214: G_PKG_NAME ) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221: -- Initialize API return status to success
222: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221: -- Initialize API return status to success
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223: x_loading_status := 'CN_INSERTED';
224: -- API body
225: IF (p_notes_tbl.COUNT > 0) THEN
226: FOR i IN p_notes_tbl.FIRST..p_notes_tbl.LAST

Line 283: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

279: x_msg_data => x_msg_data,
280: x_loading_status => x_loading_status);
281: END IF;
282: --
283: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286: --
287: --END IF;

Line 284: RAISE FND_API.G_EXC_ERROR;

280: x_loading_status => x_loading_status);
281: END IF;
282: --
283: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286: --
287: --END IF;
288: END LOOP;

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287: --END IF;
288: END LOOP;
289: END IF;
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: ROLLBACK TO manage_analyst_notes;
293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(
295: p_count => x_msg_count ,

Line 293: x_return_status := FND_API.G_RET_STS_ERROR ;

289: END IF;
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: ROLLBACK TO manage_analyst_notes;
293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(
295: p_count => x_msg_count ,
296: p_data => x_msg_data ,
297: p_encoded => FND_API.G_FALSE);

Line 297: p_encoded => FND_API.G_FALSE);

293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(
295: p_count => x_msg_count ,
296: p_data => x_msg_data ,
297: p_encoded => FND_API.G_FALSE);
298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
299: ROLLBACK TO manage_analyst_notes;
300: x_loading_status := 'UNEXPECTED_ERR';
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

294: FND_MSG_PUB.Count_And_Get(
295: p_count => x_msg_count ,
296: p_data => x_msg_data ,
297: p_encoded => FND_API.G_FALSE);
298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
299: ROLLBACK TO manage_analyst_notes;
300: x_loading_status := 'UNEXPECTED_ERR';
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: FND_MSG_PUB.Count_And_Get(

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

297: p_encoded => FND_API.G_FALSE);
298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
299: ROLLBACK TO manage_analyst_notes;
300: x_loading_status := 'UNEXPECTED_ERR';
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: FND_MSG_PUB.Count_And_Get(
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE);

Line 305: p_encoded => FND_API.G_FALSE);

301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: FND_MSG_PUB.Count_And_Get(
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE);
306: WHEN OTHERS THEN
307: ROLLBACK TO manage_analyst_notes;
308: x_loading_status := 'UNEXPECTED_ERR';
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

305: p_encoded => FND_API.G_FALSE);
306: WHEN OTHERS THEN
307: ROLLBACK TO manage_analyst_notes;
308: x_loading_status := 'UNEXPECTED_ERR';
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level(
311: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
313: END IF;

Line 317: p_encoded => FND_API.G_FALSE);

313: END IF;
314: FND_MSG_PUB.Count_And_Get(
315: p_count => x_msg_count ,
316: p_data => x_msg_data ,
317: p_encoded => FND_API.G_FALSE);
318: END;
319: --
320: PROCEDURE remove_analyst_notes(
321: p_api_version IN NUMBER,

Line 322: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

318: END;
319: --
320: PROCEDURE remove_analyst_notes(
321: p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
323: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
324: p_commit IN VARCHAR2 := CN_API.G_FALSE,
325: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

Line 323: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

319: --
320: PROCEDURE remove_analyst_notes(
321: p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
323: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
324: p_commit IN VARCHAR2 := CN_API.G_FALSE,
325: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
327: x_return_status OUT NOCOPY VARCHAR2,

Line 325: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

321: p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
323: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
324: p_commit IN VARCHAR2 := CN_API.G_FALSE,
325: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,

Line 326: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

322: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
323: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
324: p_commit IN VARCHAR2 := CN_API.G_FALSE,
325: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
330: x_loading_status OUT NOCOPY VARCHAR2) IS

Line 340: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

336: BEGIN
337: -- Standard Start of API savepoint
338: SAVEPOINT remove_analyst_notes;
339: -- Standard call to check for call compatibility.
340: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
341: p_api_version ,
342: l_api_name,
343: G_PKG_NAME ) THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

340: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
341: p_api_version ,
342: l_api_name,
343: G_PKG_NAME ) THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
348: FND_MSG_PUB.initialize;

Line 347: IF FND_API.to_Boolean( p_init_msg_list ) THEN

343: G_PKG_NAME ) THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: -- Initialize API return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: -- Initialize API return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352: x_loading_status := 'CN_INSERTED';
353: -- API body
354: cn_reasons_pvt.delete_notes(
355: p_api_version => l_api_version,

Line 365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

361: x_msg_count => x_msg_count,
362: x_msg_data => x_msg_data,
363: x_loading_status => x_loading_status);
364: --
365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368: --
369: EXCEPTION

Line 366: RAISE FND_API.G_EXC_ERROR;

362: x_msg_data => x_msg_data,
363: x_loading_status => x_loading_status);
364: --
365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368: --
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN

Line 370: WHEN FND_API.G_EXC_ERROR THEN

366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368: --
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO remove_analyst_notes;
372: x_return_status := FND_API.G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get(
374: p_count => x_msg_count ,

Line 372: x_return_status := FND_API.G_RET_STS_ERROR ;

368: --
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO remove_analyst_notes;
372: x_return_status := FND_API.G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get(
374: p_count => x_msg_count ,
375: p_data => x_msg_data ,
376: p_encoded => FND_API.G_FALSE);

Line 376: p_encoded => FND_API.G_FALSE);

372: x_return_status := FND_API.G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get(
374: p_count => x_msg_count ,
375: p_data => x_msg_data ,
376: p_encoded => FND_API.G_FALSE);
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: ROLLBACK TO remove_analyst_notes;
379: x_loading_status := 'UNEXPECTED_ERR';
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

373: FND_MSG_PUB.Count_And_Get(
374: p_count => x_msg_count ,
375: p_data => x_msg_data ,
376: p_encoded => FND_API.G_FALSE);
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: ROLLBACK TO remove_analyst_notes;
379: x_loading_status := 'UNEXPECTED_ERR';
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get(

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

376: p_encoded => FND_API.G_FALSE);
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: ROLLBACK TO remove_analyst_notes;
379: x_loading_status := 'UNEXPECTED_ERR';
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get(
382: p_count => x_msg_count ,
383: p_data => x_msg_data ,
384: p_encoded => FND_API.G_FALSE);

Line 384: p_encoded => FND_API.G_FALSE);

380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get(
382: p_count => x_msg_count ,
383: p_data => x_msg_data ,
384: p_encoded => FND_API.G_FALSE);
385: WHEN OTHERS THEN
386: ROLLBACK TO remove_analyst_notes;
387: x_loading_status := 'UNEXPECTED_ERR';
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

384: p_encoded => FND_API.G_FALSE);
385: WHEN OTHERS THEN
386: ROLLBACK TO remove_analyst_notes;
387: x_loading_status := 'UNEXPECTED_ERR';
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level(
390: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
392: END IF;

Line 396: p_encoded => FND_API.G_FALSE);

392: END IF;
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count ,
395: p_data => x_msg_data ,
396: p_encoded => FND_API.G_FALSE);
397: END;
398: --
399: --=====================================================================
400: --Procedure Name:show_last_analyst_note

Line 406: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

402: --11.5.10
403: --=====================================================================
404: PROCEDURE show_last_analyst_note(
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
407: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
408: p_commit IN VARCHAR2 := CN_API.G_FALSE,
409: p_payment_worksheet_id IN NUMBER,
410: p_table_name IN VARCHAR2,

Line 407: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

403: --=====================================================================
404: PROCEDURE show_last_analyst_note(
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
407: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
408: p_commit IN VARCHAR2 := CN_API.G_FALSE,
409: p_payment_worksheet_id IN NUMBER,
410: p_table_name IN VARCHAR2,
411: p_lookup_type IN VARCHAR2,

Line 460: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

456: BEGIN
457: -- Standard Start of API savepoint
458: SAVEPOINT show_last_analyst_note;
459: -- Standard call to check for call compatibility.
460: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
461: p_api_version ,
462: l_api_name,
463: G_PKG_NAME ) THEN
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

460: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
461: p_api_version ,
462: l_api_name,
463: G_PKG_NAME ) THEN
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: END IF;
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list ) THEN
468: FND_MSG_PUB.initialize;

Line 467: IF FND_API.to_Boolean( p_init_msg_list ) THEN

463: G_PKG_NAME ) THEN
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: END IF;
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list ) THEN
468: FND_MSG_PUB.initialize;
469: END IF;
470: -- Initialize API return status to success
471: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

467: IF FND_API.to_Boolean( p_init_msg_list ) THEN
468: FND_MSG_PUB.initialize;
469: END IF;
470: -- Initialize API return status to success
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: x_loading_status := 'CN_INSERTED';
473: -- API body
474:
475: --

Line 523: WHEN FND_API.G_EXC_ERROR THEN

519: l_tbl_count := l_tbl_count + 1;
520: END LOOP;
521:
522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: ROLLBACK TO show_last_analyst_note;
525: x_return_status := FND_API.G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get(
527: p_count => x_msg_count ,

Line 525: x_return_status := FND_API.G_RET_STS_ERROR ;

521:
522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: ROLLBACK TO show_last_analyst_note;
525: x_return_status := FND_API.G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get(
527: p_count => x_msg_count ,
528: p_data => x_msg_data ,
529: p_encoded => FND_API.G_FALSE);

Line 529: p_encoded => FND_API.G_FALSE);

525: x_return_status := FND_API.G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get(
527: p_count => x_msg_count ,
528: p_data => x_msg_data ,
529: p_encoded => FND_API.G_FALSE);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: ROLLBACK TO show_last_analyst_note;
532: x_loading_status := 'UNEXPECTED_ERR';
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

526: FND_MSG_PUB.Count_And_Get(
527: p_count => x_msg_count ,
528: p_data => x_msg_data ,
529: p_encoded => FND_API.G_FALSE);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: ROLLBACK TO show_last_analyst_note;
532: x_loading_status := 'UNEXPECTED_ERR';
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
534: FND_MSG_PUB.Count_And_Get(

Line 533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

529: p_encoded => FND_API.G_FALSE);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: ROLLBACK TO show_last_analyst_note;
532: x_loading_status := 'UNEXPECTED_ERR';
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
534: FND_MSG_PUB.Count_And_Get(
535: p_count => x_msg_count ,
536: p_data => x_msg_data ,
537: p_encoded => FND_API.G_FALSE);

Line 537: p_encoded => FND_API.G_FALSE);

533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
534: FND_MSG_PUB.Count_And_Get(
535: p_count => x_msg_count ,
536: p_data => x_msg_data ,
537: p_encoded => FND_API.G_FALSE);
538: WHEN OTHERS THEN
539: ROLLBACK TO show_last_analyst_note;
540: x_loading_status := 'UNEXPECTED_ERR';
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

537: p_encoded => FND_API.G_FALSE);
538: WHEN OTHERS THEN
539: ROLLBACK TO show_last_analyst_note;
540: x_loading_status := 'UNEXPECTED_ERR';
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542: IF FND_MSG_PUB.Check_Msg_Level(
543: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
545: END IF;

Line 549: p_encoded => FND_API.G_FALSE);

545: END IF;
546: FND_MSG_PUB.Count_And_Get(
547: p_count => x_msg_count ,
548: p_data => x_msg_data ,
549: p_encoded => FND_API.G_FALSE);
550:
551: END show_last_analyst_note;
552:
553: END;