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_PLANCOPY_UTIL_PVT dependencies on FND_API

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31: -- Standard Start of API savepoint
32: SAVEPOINT get_unique_name_for_component;
33:
34: -- Initialize API return status to success
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37:
38: -- ******* All the code needs to be written here *****
39: -- PLAN ELEMENT Name : 80 characters

Line 87: p_encoded => FND_API.G_FALSE );

83: -- Standard call to get message count and if count is 1, get message info.
84: FND_MSG_PUB.Count_And_Get
85: (p_count => x_msg_count ,
86: p_data => x_msg_data ,
87: p_encoded => FND_API.G_FALSE );
88: EXCEPTION
89: WHEN FND_API.G_EXC_ERROR THEN
90: ROLLBACK TO get_unique_name_for_component;
91: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 89: WHEN FND_API.G_EXC_ERROR THEN

85: (p_count => x_msg_count ,
86: p_data => x_msg_data ,
87: p_encoded => FND_API.G_FALSE );
88: EXCEPTION
89: WHEN FND_API.G_EXC_ERROR THEN
90: ROLLBACK TO get_unique_name_for_component;
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.count_and_get
93: (p_count => x_msg_count ,

Line 91: x_return_status := FND_API.G_RET_STS_ERROR ;

87: p_encoded => FND_API.G_FALSE );
88: EXCEPTION
89: WHEN FND_API.G_EXC_ERROR THEN
90: ROLLBACK TO get_unique_name_for_component;
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.count_and_get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data ,
95: p_encoded => FND_API.G_FALSE );

Line 95: p_encoded => FND_API.G_FALSE );

91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.count_and_get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data ,
95: p_encoded => FND_API.G_FALSE );
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: ROLLBACK TO get_unique_name_for_component;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.count_and_get

Line 96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

92: FND_MSG_PUB.count_and_get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data ,
95: p_encoded => FND_API.G_FALSE );
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: ROLLBACK TO get_unique_name_for_component;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.count_and_get
100: (p_count => x_msg_count ,

Line 98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

94: p_data => x_msg_data ,
95: p_encoded => FND_API.G_FALSE );
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: ROLLBACK TO get_unique_name_for_component;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.count_and_get
100: (p_count => x_msg_count ,
101: p_data => x_msg_data ,
102: p_encoded => FND_API.G_FALSE );

Line 102: p_encoded => FND_API.G_FALSE );

98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.count_and_get
100: (p_count => x_msg_count ,
101: p_data => x_msg_data ,
102: p_encoded => FND_API.G_FALSE );
103: WHEN OTHERS THEN
104: ROLLBACK TO get_unique_name_for_component;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.check_msg_level

Line 105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

101: p_data => x_msg_data ,
102: p_encoded => FND_API.G_FALSE );
103: WHEN OTHERS THEN
104: ROLLBACK TO get_unique_name_for_component;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
106: IF FND_MSG_PUB.check_msg_level
107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
108: THEN
109: FND_MSG_PUB.add_exc_msg

Line 116: p_encoded => FND_API.G_FALSE );

112: END IF;
113: FND_MSG_PUB.count_and_get
114: (p_count => x_msg_count ,
115: p_data => x_msg_data ,
116: p_encoded => FND_API.G_FALSE );
117: END get_unique_name_for_component;
118:
119:
120: FUNCTION blob_to_clob (blob_in IN BLOB)

Line 191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

187: END clob_to_xmltype;
188:
189: PROCEDURE convert_blob_to_clob
190: ( p_api_version IN NUMBER ,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,

Line 192: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

188:
189: PROCEDURE convert_blob_to_clob
190: ( p_api_version IN NUMBER ,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,

Line 193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

189: PROCEDURE convert_blob_to_clob
190: ( p_api_version IN NUMBER ,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2

Line 211: IF NOT FND_API.Compatible_API_Call

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

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 220: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

221: FND_MSG_PUB.initialize;
222: END IF;
223:
224: -- Initialize API return status to success
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226:
227: -- ******* API Begins ************
228: -- TODO : Error handling
229:

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

234: l_clob := blob_to_clob(l_blob);
235: --Added to resolve the bug 14598731
236: IF l_clob IS NULL THEN
237:
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239:
240: END IF;
241:
242: --addtion ends 14598731

Line 249: IF FND_API.To_Boolean( p_commit ) THEN

245: update cn_copy_requests_all set file_content_clob = l_clob where EXP_IMP_REQUEST_ID = p_exp_imp_id;
246:
247: -- ******* End of API body. ********
248: -- Standard check of p_commit.
249: IF FND_API.To_Boolean( p_commit ) THEN
250: COMMIT WORK;
251: END IF;
252:
253: -- Standard call to get message count and if count is 1, get message info.

Line 257: p_encoded => FND_API.G_FALSE );

253: -- Standard call to get message count and if count is 1, get message info.
254: FND_MSG_PUB.Count_And_Get
255: (p_count => x_msg_count ,
256: p_data => x_msg_data ,
257: p_encoded => FND_API.G_FALSE );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO convert_blob_to_clob;

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: p_data => x_msg_data ,
257: p_encoded => FND_API.G_FALSE );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO convert_blob_to_clob;
262: x_return_status := FND_API.G_RET_STS_ERROR ;
263: FND_MSG_PUB.count_and_get
264: (p_count => x_msg_count ,

Line 262: x_return_status := FND_API.G_RET_STS_ERROR ;

258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO convert_blob_to_clob;
262: x_return_status := FND_API.G_RET_STS_ERROR ;
263: FND_MSG_PUB.count_and_get
264: (p_count => x_msg_count ,
265: p_data => x_msg_data ,
266: p_encoded => FND_API.G_FALSE );

Line 266: p_encoded => FND_API.G_FALSE );

262: x_return_status := FND_API.G_RET_STS_ERROR ;
263: FND_MSG_PUB.count_and_get
264: (p_count => x_msg_count ,
265: p_data => x_msg_data ,
266: p_encoded => FND_API.G_FALSE );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO convert_blob_to_clob;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.count_and_get

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: FND_MSG_PUB.count_and_get
264: (p_count => x_msg_count ,
265: p_data => x_msg_data ,
266: p_encoded => FND_API.G_FALSE );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO convert_blob_to_clob;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.count_and_get
271: (p_count => x_msg_count ,

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

265: p_data => x_msg_data ,
266: p_encoded => FND_API.G_FALSE );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO convert_blob_to_clob;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.count_and_get
271: (p_count => x_msg_count ,
272: p_data => x_msg_data ,
273: p_encoded => FND_API.G_FALSE );

Line 273: p_encoded => FND_API.G_FALSE );

269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.count_and_get
271: (p_count => x_msg_count ,
272: p_data => x_msg_data ,
273: p_encoded => FND_API.G_FALSE );
274: WHEN OTHERS THEN
275: ROLLBACK TO convert_blob_to_clob;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: IF FND_MSG_PUB.check_msg_level

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

272: p_data => x_msg_data ,
273: p_encoded => FND_API.G_FALSE );
274: WHEN OTHERS THEN
275: ROLLBACK TO convert_blob_to_clob;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: IF FND_MSG_PUB.check_msg_level
278: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
279: THEN
280: FND_MSG_PUB.add_exc_msg

Line 287: p_encoded => FND_API.G_FALSE );

283: END IF;
284: FND_MSG_PUB.count_and_get
285: (p_count => x_msg_count ,
286: p_data => x_msg_data ,
287: p_encoded => FND_API.G_FALSE );
288: END convert_blob_to_clob;
289:
290:
291:

Line 294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

290:
291:
292: PROCEDURE convert_clob_to_xmltype
293: ( p_api_version IN NUMBER ,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
296: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
297: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
298: x_return_status OUT NOCOPY VARCHAR2,

Line 295: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

291:
292: PROCEDURE convert_clob_to_xmltype
293: ( p_api_version IN NUMBER ,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
296: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
297: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
298: x_return_status OUT NOCOPY VARCHAR2,
299: x_msg_count OUT NOCOPY NUMBER,

Line 296: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

292: PROCEDURE convert_clob_to_xmltype
293: ( p_api_version IN NUMBER ,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
296: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
297: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
298: x_return_status OUT NOCOPY VARCHAR2,
299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2

Line 314: IF NOT FND_API.Compatible_API_Call

310: -- Standard Start of API savepoint
311: SAVEPOINT convert_clob_to_xmltype;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call
315: (l_api_version ,
316: p_api_version ,
317: l_api_name ,
318: G_PKG_NAME )

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

316: p_api_version ,
317: l_api_name ,
318: G_PKG_NAME )
319: THEN
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean( p_init_msg_list ) THEN
324: FND_MSG_PUB.initialize;

Line 323: IF FND_API.to_Boolean( p_init_msg_list ) THEN

319: THEN
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean( p_init_msg_list ) THEN
324: FND_MSG_PUB.initialize;
325: END IF;
326:
327: -- Initialize API return status to success

Line 328: x_return_status := FND_API.G_RET_STS_SUCCESS;

324: FND_MSG_PUB.initialize;
325: END IF;
326:
327: -- Initialize API return status to success
328: x_return_status := FND_API.G_RET_STS_SUCCESS;
329:
330: -- ******* API Begins ************
331: -- TODO : Error handling, waiting for xmltype to be added
332:

Line 342: IF FND_API.To_Boolean( p_commit ) THEN

338: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
339:
340: -- ******* End of API body. ********
341: -- Standard check of p_commit.
342: IF FND_API.To_Boolean( p_commit ) THEN
343: COMMIT WORK;
344: END IF;
345:
346: -- Standard call to get message count and if count is 1, get message info.

Line 350: p_encoded => FND_API.G_FALSE );

346: -- Standard call to get message count and if count is 1, get message info.
347: FND_MSG_PUB.Count_And_Get
348: (p_count => x_msg_count ,
349: p_data => x_msg_data ,
350: p_encoded => FND_API.G_FALSE );
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: ROLLBACK TO convert_clob_to_xmltype;

Line 353: WHEN FND_API.G_EXC_ERROR THEN

349: p_data => x_msg_data ,
350: p_encoded => FND_API.G_FALSE );
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: ROLLBACK TO convert_clob_to_xmltype;
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: FND_MSG_PUB.count_and_get
357: (p_count => x_msg_count ,

Line 355: x_return_status := FND_API.G_RET_STS_ERROR ;

351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: ROLLBACK TO convert_clob_to_xmltype;
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: FND_MSG_PUB.count_and_get
357: (p_count => x_msg_count ,
358: p_data => x_msg_data ,
359: p_encoded => FND_API.G_FALSE );

Line 359: p_encoded => FND_API.G_FALSE );

355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: FND_MSG_PUB.count_and_get
357: (p_count => x_msg_count ,
358: p_data => x_msg_data ,
359: p_encoded => FND_API.G_FALSE );
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ROLLBACK TO convert_clob_to_xmltype;
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: FND_MSG_PUB.count_and_get

Line 360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

356: FND_MSG_PUB.count_and_get
357: (p_count => x_msg_count ,
358: p_data => x_msg_data ,
359: p_encoded => FND_API.G_FALSE );
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ROLLBACK TO convert_clob_to_xmltype;
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: FND_MSG_PUB.count_and_get
364: (p_count => x_msg_count ,

Line 362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

358: p_data => x_msg_data ,
359: p_encoded => FND_API.G_FALSE );
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ROLLBACK TO convert_clob_to_xmltype;
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: FND_MSG_PUB.count_and_get
364: (p_count => x_msg_count ,
365: p_data => x_msg_data ,
366: p_encoded => FND_API.G_FALSE );

Line 366: p_encoded => FND_API.G_FALSE );

362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: FND_MSG_PUB.count_and_get
364: (p_count => x_msg_count ,
365: p_data => x_msg_data ,
366: p_encoded => FND_API.G_FALSE );
367: WHEN OTHERS THEN
368: ROLLBACK TO convert_clob_to_xmltype;
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
370: IF FND_MSG_PUB.check_msg_level

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

365: p_data => x_msg_data ,
366: p_encoded => FND_API.G_FALSE );
367: WHEN OTHERS THEN
368: ROLLBACK TO convert_clob_to_xmltype;
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
370: IF FND_MSG_PUB.check_msg_level
371: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
372: THEN
373: FND_MSG_PUB.add_exc_msg

Line 380: p_encoded => FND_API.G_FALSE );

376: END IF;
377: FND_MSG_PUB.count_and_get
378: (p_count => x_msg_count ,
379: p_data => x_msg_data ,
380: p_encoded => FND_API.G_FALSE );
381: END convert_clob_to_xmltype;
382:
383:
384: PROCEDURE convert_blob_to_xmltype

Line 386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

382:
383:
384: PROCEDURE convert_blob_to_xmltype
385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
390: x_return_status OUT NOCOPY VARCHAR2,

Line 387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

383:
384: PROCEDURE convert_blob_to_xmltype
385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,

Line 388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

384: PROCEDURE convert_blob_to_xmltype
385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2

Line 407: IF NOT FND_API.Compatible_API_Call

403: -- Standard Start of API savepoint
404: SAVEPOINT convert_blob_to_xmltype;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call
408: (l_api_version ,
409: p_api_version ,
410: l_api_name ,
411: G_PKG_NAME )

Line 413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

409: p_api_version ,
410: l_api_name ,
411: G_PKG_NAME )
412: THEN
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415: -- Initialize message list if p_init_msg_list is set to TRUE.
416: IF FND_API.to_Boolean( p_init_msg_list ) THEN
417: FND_MSG_PUB.initialize;

Line 416: IF FND_API.to_Boolean( p_init_msg_list ) THEN

412: THEN
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415: -- Initialize message list if p_init_msg_list is set to TRUE.
416: IF FND_API.to_Boolean( p_init_msg_list ) THEN
417: FND_MSG_PUB.initialize;
418: END IF;
419:
420:

Line 422: x_return_status := FND_API.G_RET_STS_SUCCESS;

418: END IF;
419:
420:
421: -- Initialize API return status to success
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: -- ******* API Begins ************
425: -- TODO : Error handling, calling the other two procedures
426: convert_blob_to_clob(p_api_version,

Line 435: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

431: l_return_status,
432: l_msg_count,
433: l_msg_data);
434:
435: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
436: RAISE fnd_api.g_exc_error;
437: END IF;
438:
439: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 436: RAISE fnd_api.g_exc_error;

432: l_msg_count,
433: l_msg_data);
434:
435: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
436: RAISE fnd_api.g_exc_error;
437: END IF;
438:
439: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 439: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

435: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
436: RAISE fnd_api.g_exc_error;
437: END IF;
438:
439: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:
443:

Line 440: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

436: RAISE fnd_api.g_exc_error;
437: END IF;
438:
439: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:
443:
444: convert_clob_to_xmltype(p_api_version,

Line 453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

449: l_return_status,
450: l_msg_count,
451: l_msg_data);
452:
453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
454: RAISE fnd_api.g_exc_error;
455: END IF;
456:
457: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 454: RAISE fnd_api.g_exc_error;

450: l_msg_count,
451: l_msg_data);
452:
453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
454: RAISE fnd_api.g_exc_error;
455: END IF;
456:
457: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
458: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 457: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
454: RAISE fnd_api.g_exc_error;
455: END IF;
456:
457: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
458: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460:
461: -- ******* End of API body. ********

Line 458: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

454: RAISE fnd_api.g_exc_error;
455: END IF;
456:
457: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
458: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460:
461: -- ******* End of API body. ********
462: -- Standard check of p_commit.

Line 463: IF FND_API.To_Boolean(p_commit) THEN

459: END IF;
460:
461: -- ******* End of API body. ********
462: -- Standard check of p_commit.
463: IF FND_API.To_Boolean(p_commit) THEN
464: COMMIT WORK;
465: END IF;
466:
467: -- Standard call to get message count and if count is 1, get message info.

Line 471: p_encoded => FND_API.G_FALSE );

467: -- Standard call to get message count and if count is 1, get message info.
468: FND_MSG_PUB.Count_And_Get
469: (p_count => x_msg_count ,
470: p_data => x_msg_data ,
471: p_encoded => FND_API.G_FALSE );
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO convert_blob_to_xmltype;

Line 474: WHEN FND_API.G_EXC_ERROR THEN

470: p_data => x_msg_data ,
471: p_encoded => FND_API.G_FALSE );
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO convert_blob_to_xmltype;
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: FND_MSG_PUB.count_and_get
478: (p_count => x_msg_count ,

Line 476: x_return_status := FND_API.G_RET_STS_ERROR ;

472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO convert_blob_to_xmltype;
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: FND_MSG_PUB.count_and_get
478: (p_count => x_msg_count ,
479: p_data => x_msg_data ,
480: p_encoded => FND_API.G_FALSE );

Line 480: p_encoded => FND_API.G_FALSE );

476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: FND_MSG_PUB.count_and_get
478: (p_count => x_msg_count ,
479: p_data => x_msg_data ,
480: p_encoded => FND_API.G_FALSE );
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO convert_blob_to_xmltype;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: FND_MSG_PUB.count_and_get

Line 481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

477: FND_MSG_PUB.count_and_get
478: (p_count => x_msg_count ,
479: p_data => x_msg_data ,
480: p_encoded => FND_API.G_FALSE );
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO convert_blob_to_xmltype;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: FND_MSG_PUB.count_and_get
485: (p_count => x_msg_count ,

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

479: p_data => x_msg_data ,
480: p_encoded => FND_API.G_FALSE );
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO convert_blob_to_xmltype;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: FND_MSG_PUB.count_and_get
485: (p_count => x_msg_count ,
486: p_data => x_msg_data ,
487: p_encoded => FND_API.G_FALSE );

Line 487: p_encoded => FND_API.G_FALSE );

483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: FND_MSG_PUB.count_and_get
485: (p_count => x_msg_count ,
486: p_data => x_msg_data ,
487: p_encoded => FND_API.G_FALSE );
488: WHEN OTHERS THEN
489: ROLLBACK TO convert_blob_to_xmltype;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: IF FND_MSG_PUB.check_msg_level

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

486: p_data => x_msg_data ,
487: p_encoded => FND_API.G_FALSE );
488: WHEN OTHERS THEN
489: ROLLBACK TO convert_blob_to_xmltype;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: IF FND_MSG_PUB.check_msg_level
492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN
494: FND_MSG_PUB.add_exc_msg

Line 501: p_encoded => FND_API.G_FALSE );

497: END IF;
498: FND_MSG_PUB.count_and_get
499: (p_count => x_msg_count ,
500: p_data => x_msg_data ,
501: p_encoded => FND_API.G_FALSE );
502: END convert_blob_to_xmltype;
503:
504:
505: FUNCTION check_name_length (p_name VARCHAR2, p_org_id NUMBER,p_type varchar2,p_prefix varchar2)

Line 564: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

560: --Added by Naren to fix BT issue on 10thMARCH,2010
561:
562: PROCEDURE update_existing_expression(
563: p_api_version IN NUMBER
564: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: , p_commit IN VARCHAR2 := fnd_api.g_false
566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE

Line 565: , p_commit IN VARCHAR2 := fnd_api.g_false

561:
562: PROCEDURE update_existing_expression(
563: p_api_version IN NUMBER
564: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: , p_commit IN VARCHAR2 := fnd_api.g_false
566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE

Line 566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

562: PROCEDURE update_existing_expression(
563: p_api_version IN NUMBER
564: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: , p_commit IN VARCHAR2 := fnd_api.g_false
566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
570: , p_name IN cn_calc_sql_exps.NAME%TYPE

Line 567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false

563: p_api_version IN NUMBER
564: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: , p_commit IN VARCHAR2 := fnd_api.g_false
566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
570: , p_name IN cn_calc_sql_exps.NAME%TYPE
571: , p_description IN cn_calc_sql_exps.description%TYPE := NULL

Line 609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

605: -- Standard Start of API savepoint
606: SAVEPOINT update_expression;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 610: RAISE fnd_api.g_exc_unexpected_error;

606: SAVEPOINT update_expression;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 614: IF fnd_api.to_boolean(p_init_msg_list) THEN

610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF fnd_api.to_boolean(p_init_msg_list) THEN
615: fnd_msg_pub.initialize;
616: END IF;
617:
618: -- Initialize API return status to success

Line 619: x_return_status := fnd_api.g_ret_sts_success;

615: fnd_msg_pub.initialize;
616: END IF;
617:
618: -- Initialize API return status to success
619: x_return_status := fnd_api.g_ret_sts_success;
620:
621: -- API body
622: IF (p_name IS NULL) THEN
623: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 630: RAISE fnd_api.g_exc_error;

626: fnd_message.set_token('OBJ_NAME', l_prompt);
627: fnd_msg_pub.ADD;
628: END IF;
629:
630: RAISE fnd_api.g_exc_error;
631: END IF;
632:
633: OPEN exp_exists;
634: FETCH exp_exists INTO l_dummy;

Line 643: RAISE fnd_api.g_exc_error;

639: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
640: fnd_msg_pub.ADD;
641: END IF;
642:
643: RAISE fnd_api.g_exc_error;
644: END IF;
645:
646: -- check ovn
647: cn_calc_sql_exps_pkg.lock_row(p_calc_sql_exp_id, p_ovn);

Line 789: IF (fnd_api.to_boolean(p_update_parent_also)) THEN

785:
786: --END IF;
787:
788: -- update parent expressions and formulas also
789: IF (fnd_api.to_boolean(p_update_parent_also)) THEN
790: NULL;
791: END IF;
792:
793: -- End of API body.

Line 796: IF fnd_api.to_boolean(p_commit) THEN

792:
793: -- End of API body.
794:
795: -- Standard check of p_commit.
796: IF fnd_api.to_boolean(p_commit) THEN
797: COMMIT WORK;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.

Line 802: , p_encoded => fnd_api.g_false);

798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
802: , p_encoded => fnd_api.g_false);
803: EXCEPTION
804: WHEN fnd_api.g_exc_error THEN
805: ROLLBACK TO update_expression;
806: x_return_status := fnd_api.g_ret_sts_error;

Line 804: WHEN fnd_api.g_exc_error THEN

800: -- Standard call to get message count and if count is 1, get message info.
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
802: , p_encoded => fnd_api.g_false);
803: EXCEPTION
804: WHEN fnd_api.g_exc_error THEN
805: ROLLBACK TO update_expression;
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
808: , p_encoded => fnd_api.g_false);

Line 806: x_return_status := fnd_api.g_ret_sts_error;

802: , p_encoded => fnd_api.g_false);
803: EXCEPTION
804: WHEN fnd_api.g_exc_error THEN
805: ROLLBACK TO update_expression;
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
808: , p_encoded => fnd_api.g_false);
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: ROLLBACK TO update_expression;

Line 808: , p_encoded => fnd_api.g_false);

804: WHEN fnd_api.g_exc_error THEN
805: ROLLBACK TO update_expression;
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
808: , p_encoded => fnd_api.g_false);
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: ROLLBACK TO update_expression;
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 809: WHEN fnd_api.g_exc_unexpected_error THEN

805: ROLLBACK TO update_expression;
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
808: , p_encoded => fnd_api.g_false);
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: ROLLBACK TO update_expression;
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
813: , p_encoded => fnd_api.g_false);

Line 811: x_return_status := fnd_api.g_ret_sts_unexp_error;

807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
808: , p_encoded => fnd_api.g_false);
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: ROLLBACK TO update_expression;
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
813: , p_encoded => fnd_api.g_false);
814: WHEN OTHERS THEN
815: ROLLBACK TO update_expression;

Line 813: , p_encoded => fnd_api.g_false);

809: WHEN fnd_api.g_exc_unexpected_error THEN
810: ROLLBACK TO update_expression;
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
813: , p_encoded => fnd_api.g_false);
814: WHEN OTHERS THEN
815: ROLLBACK TO update_expression;
816: x_return_status := fnd_api.g_ret_sts_unexp_error;
817:

Line 816: x_return_status := fnd_api.g_ret_sts_unexp_error;

812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
813: , p_encoded => fnd_api.g_false);
814: WHEN OTHERS THEN
815: ROLLBACK TO update_expression;
816: x_return_status := fnd_api.g_ret_sts_unexp_error;
817:
818: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
819: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
820: END IF;

Line 823: , p_encoded => fnd_api.g_false);

819: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
820: END IF;
821:
822: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
823: , p_encoded => fnd_api.g_false);
824: END update_existing_expression;
825:
826: --addition ends by Naren
827: