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

Line 46: raise FND_API.G_EXC_ERROR;

42:
43: -- If there is an error in conversion precessing, raise an error.
44: IF l_any_errors
45: THEN
46: raise FND_API.G_EXC_ERROR;
47: END IF;
48:
49: END Convert_pub_to_pvt_Rec;
50:

Line 128: --p_form_function_id IN NUMBER := FND_API.G_MISS_NUM,

124: p_seeded_flag IN VARCHAR2,
125: p_start_date_active IN DATE ,
126: p_end_date_active IN DATE ,
127: p_currency_code IN VARCHAR2,
128: --p_form_function_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_object_code IN VARCHAR2,
130: p_select_clause IN VARCHAR2,
131: p_from_clause IN VARCHAR2,
132: p_where_clause IN VARCHAR2,

Line 218: IF NOT FND_API.Compatible_API_Call( l_api_version,

214: -- Standard Start of API Savepoint
215: SAVEPOINT Create_Profile_Variable_Pub ;
216:
217: -- Standard Call to check API compatibility
218: IF NOT FND_API.Compatible_API_Call( l_api_version,
219: p_api_version_number,
220: l_api_name,
221: G_PKG_NAME )
222: THEN

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

219: p_api_version_number,
220: l_api_name,
221: G_PKG_NAME )
222: THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
224: END IF ;
225:
226: -- Initialize the message list if p_msg_list is set to TRUE
227: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 227: IF FND_API.To_Boolean(p_init_msg_list) THEN

223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
224: END IF ;
225:
226: -- Initialize the message list if p_msg_list is set to TRUE
227: IF FND_API.To_Boolean(p_init_msg_list) THEN
228: FND_MSG_PUB.initialize ;
229: END IF ;
230:
231:

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS ;

235: );
236:
237:
238: -- Initialize the API Return Success to True
239: x_return_status := FND_API.G_RET_STS_SUCCESS ;
240:
241: CSC_Profile_Variable_PVT.Create_Profile_Variable(
242: p_api_version_number => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,

Line 243: p_init_msg_list => FND_API.G_FALSE,

239: x_return_status := FND_API.G_RET_STS_SUCCESS ;
240:
241: CSC_Profile_Variable_PVT.Create_Profile_Variable(
242: p_api_version_number => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
246: x_return_status => x_return_status,
247: x_msg_count => x_msg_count,

Line 244: p_commit => FND_API.G_FALSE,

240:
241: CSC_Profile_Variable_PVT.Create_Profile_Variable(
242: p_api_version_number => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
246: x_return_status => x_return_status,
247: x_msg_count => x_msg_count,
248: x_msg_data => x_msg_data,

Line 245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

241: CSC_Profile_Variable_PVT.Create_Profile_Variable(
242: p_api_version_number => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
246: x_return_status => x_return_status,
247: x_msg_count => x_msg_count,
248: x_msg_data => x_msg_data,
249: p_prof_var_rec => l_pvt_Prof_Var_Rec,

Line 253: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

249: p_prof_var_rec => l_pvt_Prof_Var_Rec,
250: x_block_id => x_block_id ,
251: x_object_version_number => x_object_version_number );
252:
253: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;

Line 254: RAISE FND_API.G_EXC_ERROR;

250: x_block_id => x_block_id ,
251: x_object_version_number => x_object_version_number );
252:
253: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:

Line 255: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

251: x_object_version_number => x_object_version_number );
252:
253: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259:

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252:
253: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
254: RAISE FND_API.G_EXC_ERROR;
255: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259:
260: -- End of API Body

Line 262: IF FND_API.To_Boolean( p_commit ) THEN

258:
259:
260: -- End of API Body
261: -- Standard Check of p_commit
262: IF FND_API.To_Boolean( p_commit ) THEN
263: COMMIT WORK ;
264: END IF ;
265:
266: -- Standard call to get message count and if count is 1 , get message info

Line 272: WHEN FND_API.G_EXC_ERROR THEN

268: p_data => x_msg_data) ;
269:
270: -- Begin Exception Handling
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO Create_Profile_Variable_Pub ;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
276: p_data => x_msg_data) ;

Line 274: x_return_status := FND_API.G_RET_STS_ERROR ;

270: -- Begin Exception Handling
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO Create_Profile_Variable_Pub ;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
276: p_data => x_msg_data) ;
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO Create_Profile_Variable_Pub ;

Line 277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

273: ROLLBACK TO Create_Profile_Variable_Pub ;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
276: p_data => x_msg_data) ;
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO Create_Profile_Variable_Pub ;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
281: p_data => x_msg_data) ;

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

280: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
281: p_data => x_msg_data) ;
282: WHEN OTHERS THEN
283: ROLLBACK TO Create_Profile_Variable_Pub ;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
285: IF FND_MSG_PUB.Check_Msg_Level
286: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN
288: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 301: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,

297: P_Init_Msg_List IN VARCHAR2,
298: P_Commit IN VARCHAR2,
299: P_Validation_level IN NUMBER,
300: p_Table_Column_Tbl IN CSC_Profile_Variable_pvt.Table_Column_Tbl_Type,
301: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: --p_BLOCK_ID IN NUMBER,
303: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
304: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
305: X_Return_Status OUT NOCOPY VARCHAR2,

Line 317: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

313: -- Standard Start of API savepoint
314: SAVEPOINT CREATE_Table_Column_PUB;
315:
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
318: p_api_version_number,
319: l_api_name,
320: G_PKG_NAME)
321: THEN

Line 322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318: p_api_version_number,
319: l_api_name,
320: G_PKG_NAME)
321: THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 327: IF FND_API.to_Boolean( p_init_msg_list )

323: END IF;
324:
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list )
328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330: END IF;
331:
332:
333: -- Initialize API return status to SUCCESS
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: --
337: -- API body
338: --

Line 345: P_Init_Msg_List => FND_API.G_FALSE,

341: -- Hint: Primary key needs to be returned
342:
343: CSC_Profile_Variable_PVT.Create_table_column(
344: P_Api_Version_Number => l_api_version_number,
345: P_Init_Msg_List => FND_API.G_FALSE,
346: P_Commit => FND_API.G_FALSE,
347: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
348: p_Table_Column_Tbl => p_table_column_tbl,
349: --p_Sql_Stmnt_For_Drilldown => p_sql_stmnt_for_drilldown,

Line 346: P_Commit => FND_API.G_FALSE,

342:
343: CSC_Profile_Variable_PVT.Create_table_column(
344: P_Api_Version_Number => l_api_version_number,
345: P_Init_Msg_List => FND_API.G_FALSE,
346: P_Commit => FND_API.G_FALSE,
347: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
348: p_Table_Column_Tbl => p_table_column_tbl,
349: --p_Sql_Stmnt_For_Drilldown => p_sql_stmnt_for_drilldown,
350: --p_BLOCK_ID => p_block_id,

Line 347: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

343: CSC_Profile_Variable_PVT.Create_table_column(
344: P_Api_Version_Number => l_api_version_number,
345: P_Init_Msg_List => FND_API.G_FALSE,
346: P_Commit => FND_API.G_FALSE,
347: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
348: p_Table_Column_Tbl => p_table_column_tbl,
349: --p_Sql_Stmnt_For_Drilldown => p_sql_stmnt_for_drilldown,
350: --p_BLOCK_ID => p_block_id,
351: X_TABLE_COLUMN_ID => x_TABLE_COLUMN_ID,

Line 358: IF x_return_status = FND_API.G_RET_STS_ERROR then

354: X_Msg_Count => x_msg_count,
355: X_Msg_Data => x_msg_data );
356:
357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;

Line 359: raise FND_API.G_EXC_ERROR;

355: X_Msg_Data => x_msg_data );
356:
357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:

Line 360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

356:
357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364: --

Line 361: raise FND_API.G_EXC_UNEXPECTED_ERROR;

357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364: --
365: -- End of API body.

Line 369: IF FND_API.to_Boolean( p_commit )

365: -- End of API body.
366: --
367:
368: -- Standard check for p_commit
369: IF FND_API.to_Boolean( p_commit )
370: THEN
371: COMMIT WORK;
372: END IF;
373:

Line 382: WHEN FND_API.G_EXC_ERROR THEN

378: p_data => x_msg_data
379: );
380:
381: EXCEPTION
382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO CREATE_Table_Column_PUB ;
384: x_return_status := FND_API.G_RET_STS_ERROR ;
385: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
386: p_data => x_msg_data) ;

Line 384: x_return_status := FND_API.G_RET_STS_ERROR ;

380:
381: EXCEPTION
382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO CREATE_Table_Column_PUB ;
384: x_return_status := FND_API.G_RET_STS_ERROR ;
385: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
386: p_data => x_msg_data) ;
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO CREATE_Table_Column_PUB ;

Line 387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

383: ROLLBACK TO CREATE_Table_Column_PUB ;
384: x_return_status := FND_API.G_RET_STS_ERROR ;
385: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
386: p_data => x_msg_data) ;
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO CREATE_Table_Column_PUB ;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
391: p_data => x_msg_data) ;

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

385: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
386: p_data => x_msg_data) ;
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO CREATE_Table_Column_PUB ;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
391: p_data => x_msg_data) ;
392: WHEN OTHERS THEN
393: ROLLBACK TO CREATE_Table_Column_PUB ;

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

390: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
391: p_data => x_msg_data) ;
392: WHEN OTHERS THEN
393: ROLLBACK TO CREATE_Table_Column_PUB ;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395: IF FND_MSG_PUB.Check_Msg_Level
396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 428: --p_form_function_id IN NUMBER := FND_API.G_MISS_NUM,

424: p_description IN VARCHAR2,
425: p_currency_code IN VARCHAR2,
426: p_sql_stmnt IN VARCHAR2,
427: p_seeded_flag IN VARCHAR2,
428: --p_form_function_id IN NUMBER := FND_API.G_MISS_NUM,
429: p_object_code IN VARCHAR2,
430: p_start_date_active IN DATE,
431: p_end_date_active IN DATE,
432: p_select_clause IN VARCHAR2,

Line 515: IF NOT FND_API.Compatible_API_Call( l_api_version,

511: -- Standard Start of API Savepoint
512: SAVEPOINT Update_Profile_Variable_Pub ;
513:
514: -- Standard Call to check API compatibility
515: IF NOT FND_API.Compatible_API_Call( l_api_version,
516: p_api_version_number,
517: l_api_name,
518: G_PKG_NAME )
519: THEN

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

516: p_api_version_number,
517: l_api_name,
518: G_PKG_NAME )
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
521: END IF ;
522:
523: -- Initialize the message list if p_msg_list is set to TRUE
524: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 524: IF FND_API.To_Boolean(p_init_msg_list) THEN

520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
521: END IF ;
522:
523: -- Initialize the message list if p_msg_list is set to TRUE
524: IF FND_API.To_Boolean(p_init_msg_list) THEN
525: FND_MSG_PUB.initialize ;
526: END IF ;
527:
528:

Line 530: x_return_status := FND_API.G_RET_STS_SUCCESS ;

526: END IF ;
527:
528:
529: -- Initialize the API Return Success to True
530: x_return_status := FND_API.G_RET_STS_SUCCESS ;
531:
532: Convert_pub_to_pvt_Rec (
533: P_Profile_Variables_Rec => p_prof_var_Rec,
534: x_pvt_Profile_Variables_rec => l_pvt_prof_var_Rec

Line 543: p_init_msg_list => FND_API.G_FALSE,

539: -- Call Private API to Update
540:
541: CSC_Profile_Variable_PVT.Update_Profile_Variable(
542: p_api_version_number => 1.0,
543: p_init_msg_list => FND_API.G_FALSE,
544: p_commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
546: p_prof_var_rec => l_pvt_prof_var_rec,
547: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,

Line 544: p_commit => FND_API.G_FALSE,

540:
541: CSC_Profile_Variable_PVT.Update_Profile_Variable(
542: p_api_version_number => 1.0,
543: p_init_msg_list => FND_API.G_FALSE,
544: p_commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
546: p_prof_var_rec => l_pvt_prof_var_rec,
547: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
548: x_return_status => x_return_status,

Line 545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

541: CSC_Profile_Variable_PVT.Update_Profile_Variable(
542: p_api_version_number => 1.0,
543: p_init_msg_list => FND_API.G_FALSE,
544: p_commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
546: p_prof_var_rec => l_pvt_prof_var_rec,
547: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
548: x_return_status => x_return_status,
549: x_msg_count => x_msg_count,

Line 553: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

549: x_msg_count => x_msg_count,
550: x_msg_data => x_msg_data
551: );
552:
553: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;

Line 554: RAISE FND_API.G_EXC_ERROR;

550: x_msg_data => x_msg_data
551: );
552:
553: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:

Line 555: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

551: );
552:
553: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: -- End of API Body

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552:
553: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: -- End of API Body
560: -- Standard Check of p_commit

Line 561: IF FND_API.To_Boolean( p_commit ) THEN

557: END IF;
558:
559: -- End of API Body
560: -- Standard Check of p_commit
561: IF FND_API.To_Boolean( p_commit ) THEN
562: COMMIT WORK ;
563: END IF ;
564:
565: -- Standard call to get message count and if count is 1 , get message info

Line 571: WHEN FND_API.G_EXC_ERROR THEN

567: p_data => x_msg_data) ;
568:
569: -- Begin Exception Handling
570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Update_Profile_Variable_Pub ;
573: x_return_status := FND_API.G_RET_STS_ERROR ;
574: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
575: p_data => x_msg_data) ;

Line 573: x_return_status := FND_API.G_RET_STS_ERROR ;

569: -- Begin Exception Handling
570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Update_Profile_Variable_Pub ;
573: x_return_status := FND_API.G_RET_STS_ERROR ;
574: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
575: p_data => x_msg_data) ;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

573: x_return_status := FND_API.G_RET_STS_ERROR ;
574: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
575: p_data => x_msg_data) ;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO Update_Profile_Variable_Pub ;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
581: p_data => x_msg_data) ;

Line 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

575: p_data => x_msg_data) ;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO Update_Profile_Variable_Pub ;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
581: p_data => x_msg_data) ;
582: WHEN OTHERS THEN
583: ROLLBACK TO Update_Profile_Variable_Pub ;

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

580: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
581: p_data => x_msg_data) ;
582: WHEN OTHERS THEN
583: ROLLBACK TO Update_Profile_Variable_Pub ;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585: IF FND_MSG_PUB.Check_Msg_Level
586: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 602: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,

598: P_Init_Msg_List IN VARCHAR2,
599: P_Commit IN VARCHAR2,
600: P_Validation_Level IN NUMBER,
601: p_Table_Column_Rec IN CSC_Profile_Variable_PVT.Table_Column_Rec_Type,
602: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: --p_BLOCK_ID IN NUMBER := FND_API.G_MISS_NUM,
604: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
605: X_Return_Status OUT NOCOPY VARCHAR2,
606: X_Msg_Count OUT NOCOPY NUMBER,

Line 603: --p_BLOCK_ID IN NUMBER := FND_API.G_MISS_NUM,

599: P_Commit IN VARCHAR2,
600: P_Validation_Level IN NUMBER,
601: p_Table_Column_Rec IN CSC_Profile_Variable_PVT.Table_Column_Rec_Type,
602: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: --p_BLOCK_ID IN NUMBER := FND_API.G_MISS_NUM,
604: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
605: X_Return_Status OUT NOCOPY VARCHAR2,
606: X_Msg_Count OUT NOCOPY NUMBER,
607: X_Msg_Data OUT NOCOPY VARCHAR2

Line 618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

614: -- Standard Start of API savepoint
615: SAVEPOINT UPDATE_Table_Column_PUB;
616:
617: -- Standard call to check for call compatibility.
618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
619: p_api_version_number,
620: l_api_name,
621: G_PKG_NAME)
622: THEN

Line 623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

619: p_api_version_number,
620: l_api_name,
621: G_PKG_NAME)
622: THEN
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: END IF;
625:
626:
627: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 628: IF FND_API.to_Boolean( p_init_msg_list )

624: END IF;
625:
626:
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.to_Boolean( p_init_msg_list )
629: THEN
630: FND_MSG_PUB.initialize;
631: END IF;
632:

Line 634: x_return_status := FND_API.G_RET_STS_SUCCESS;

630: FND_MSG_PUB.initialize;
631: END IF;
632:
633: -- Initialize API return status to SUCCESS
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: --
637: -- API body
638: --

Line 642: P_Init_Msg_List => FND_API.G_FALSE,

638: --
639:
640: CSC_profile_variable_PVT.Update_table_column(
641: P_Api_Version_Number => l_api_version_number,
642: P_Init_Msg_List => FND_API.G_FALSE,
643: P_Commit => p_commit,
644: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
645: p_Table_Column_REC => p_table_Column_REC,
646: --p_Sql_Stmnt_for_drilldown => p_sql_stmnt_for_drilldown,

Line 644: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

640: CSC_profile_variable_PVT.Update_table_column(
641: P_Api_Version_Number => l_api_version_number,
642: P_Init_Msg_List => FND_API.G_FALSE,
643: P_Commit => p_commit,
644: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
645: p_Table_Column_REC => p_table_Column_REC,
646: --p_Sql_Stmnt_for_drilldown => p_sql_stmnt_for_drilldown,
647: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
648: X_Return_Status => x_return_status,

Line 653: IF x_return_status = FND_API.G_RET_STS_ERROR then

649: X_Msg_Count => x_msg_count,
650: X_Msg_Data => x_msg_data);
651:
652: -- Check return status from the above procedure call
653: IF x_return_status = FND_API.G_RET_STS_ERROR then
654: raise FND_API.G_EXC_ERROR;
655: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;

Line 654: raise FND_API.G_EXC_ERROR;

650: X_Msg_Data => x_msg_data);
651:
652: -- Check return status from the above procedure call
653: IF x_return_status = FND_API.G_RET_STS_ERROR then
654: raise FND_API.G_EXC_ERROR;
655: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:

Line 655: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

651:
652: -- Check return status from the above procedure call
653: IF x_return_status = FND_API.G_RET_STS_ERROR then
654: raise FND_API.G_EXC_ERROR;
655: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659: --

Line 656: raise FND_API.G_EXC_UNEXPECTED_ERROR;

652: -- Check return status from the above procedure call
653: IF x_return_status = FND_API.G_RET_STS_ERROR then
654: raise FND_API.G_EXC_ERROR;
655: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659: --
660: -- End of API body

Line 664: IF FND_API.to_Boolean( p_commit )

660: -- End of API body
661: --
662:
663: -- Standard check for p_commit
664: IF FND_API.to_Boolean( p_commit )
665: THEN
666: COMMIT WORK;
667: END IF;
668:

Line 677: WHEN FND_API.G_EXC_ERROR THEN

673: p_data => x_msg_data
674: );
675:
676: EXCEPTION
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO UPDATE_Table_Column_PUB ;
679: x_return_status := FND_API.G_RET_STS_ERROR ;
680: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
681: p_data => x_msg_data) ;

Line 679: x_return_status := FND_API.G_RET_STS_ERROR ;

675:
676: EXCEPTION
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO UPDATE_Table_Column_PUB ;
679: x_return_status := FND_API.G_RET_STS_ERROR ;
680: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
681: p_data => x_msg_data) ;
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683: ROLLBACK TO UPDATE_Table_Column_PUB ;

Line 682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

678: ROLLBACK TO UPDATE_Table_Column_PUB ;
679: x_return_status := FND_API.G_RET_STS_ERROR ;
680: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
681: p_data => x_msg_data) ;
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683: ROLLBACK TO UPDATE_Table_Column_PUB ;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
686: p_data => x_msg_data) ;

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

680: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
681: p_data => x_msg_data) ;
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683: ROLLBACK TO UPDATE_Table_Column_PUB ;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
686: p_data => x_msg_data) ;
687: WHEN OTHERS THEN
688: ROLLBACK TO UPDATE_Table_Column_PUB ;

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

685: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
686: p_data => x_msg_data) ;
687: WHEN OTHERS THEN
688: ROLLBACK TO UPDATE_Table_Column_PUB ;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.Check_Msg_Level
691: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);