DBA Data[Home] [Help]

APPS.CSC_PROFILE_VARIABLE_PUB dependencies on FND_MSG_PUB

Line 228: FND_MSG_PUB.initialize ;

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:
232: Convert_pub_to_pvt_Rec (

Line 267: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

263: COMMIT WORK ;
264: END IF ;
265:
266: -- Standard call to get message count and if count is 1 , get message info
267: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
268: p_data => x_msg_data) ;
269:
270: -- Begin Exception Handling
271: EXCEPTION

Line 275: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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 ;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 280: 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 ;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 285: IF FND_MSG_PUB.Check_Msg_Level

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);
289: END IF ;

Line 286: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);
289: END IF ;
290: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 288: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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);
289: END IF ;
290: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
291: p_data => x_msg_data) ;
292:

Line 290: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

286: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN
288: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
289: END IF ;
290: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
291: p_data => x_msg_data) ;
292:
293: END Create_Profile_Variable ;
294:

Line 329: FND_MSG_PUB.initialize;

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:
332:
333: -- Initialize API return status to SUCCESS

Line 376: FND_MSG_PUB.Count_And_Get

372: END IF;
373:
374:
375: -- Standard call to get message count and if count is 1, get message info.
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count,
378: p_data => x_msg_data
379: );
380:

Line 385: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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 ;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 390: 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 ;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 395: IF FND_MSG_PUB.Check_Msg_Level

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);
399: END IF ;

Line 396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);
399: END IF ;
400: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 398: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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);
399: END IF ;
400: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
401: p_data => x_msg_data) ;
402:

Line 400: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
399: END IF ;
400: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
401: p_data => x_msg_data) ;
402:
403:
404: End Create_table_column;

Line 525: FND_MSG_PUB.initialize ;

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:
529: -- Initialize the API Return Success to True

Line 566: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

562: COMMIT WORK ;
563: END IF ;
564:
565: -- Standard call to get message count and if count is 1 , get message info
566: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
567: p_data => x_msg_data) ;
568:
569: -- Begin Exception Handling
570: EXCEPTION

Line 574: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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
578: ROLLBACK TO Update_Profile_Variable_Pub ;

Line 580: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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 ;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 585: IF FND_MSG_PUB.Check_Msg_Level

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);
589: END IF ;

Line 586: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);
589: END IF ;
590: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 588: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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);
589: END IF ;
590: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
591: p_data => x_msg_data) ;
592:

Line 590: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

586: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
589: END IF ;
590: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
591: p_data => x_msg_data) ;
592:
593: END Update_Profile_Variable;
594:

Line 630: FND_MSG_PUB.initialize;

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:
633: -- Initialize API return status to SUCCESS
634: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 671: FND_MSG_PUB.Count_And_Get

667: END IF;
668:
669:
670: -- Standard call to get message count and if count is 1, get message info.
671: FND_MSG_PUB.Count_And_Get
672: ( p_count => x_msg_count,
673: p_data => x_msg_data
674: );
675:

Line 680: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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 ;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 685: 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 ;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 690: IF FND_MSG_PUB.Check_Msg_Level

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);
694: END IF ;

Line 691: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);
694: END IF ;
695: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 693: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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);
694: END IF ;
695: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
696: p_data => x_msg_data) ;
697:

Line 695: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

691: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
692: THEN
693: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
694: END IF ;
695: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
696: p_data => x_msg_data) ;
697:
698:
699: End Update_table_column;