DBA Data[Home] [Help]

APPS.PSB_ENTITY_SET_PVT dependencies on FND_MSG_PUB

Line 94: FND_MSG_PUB.initialize ;

90: END IF;
91: --
92:
93: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
94: FND_MSG_PUB.initialize ;
95: END IF;
96: --
97: p_return_status := FND_API.G_RET_STS_SUCCESS ;
98: --

Line 176: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

172: IF FND_API.To_Boolean ( p_commit ) THEN
173: COMMIT WORK;
174: END iF;
175: --
176: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
177: p_data => p_msg_data );
178: --
179: EXCEPTION
180: --

Line 185: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

181: WHEN FND_API.G_EXC_ERROR THEN
182: --
183: ROLLBACK TO Insert_Row_Pvt ;
184: p_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
186: p_data => p_msg_data );
187: --
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: --

Line 192: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: --
190: ROLLBACK TO Insert_Row_Pvt ;
191: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
193: p_data => p_msg_data );
194: --
195: WHEN OTHERS THEN
196: --

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

196: --
197: ROLLBACK TO Insert_Row_Pvt ;
198: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: --
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
201: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
202: l_api_name);
203: END if;
204: --

Line 201: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

197: ROLLBACK TO Insert_Row_Pvt ;
198: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: --
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
201: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
202: l_api_name);
203: END if;
204: --
205: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 205: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

201: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
202: l_api_name);
203: END if;
204: --
205: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
206: p_data => p_msg_data );
207: --
208: END Insert_Row;
209:

Line 294: FND_MSG_PUB.initialize ;

290: END IF;
291: --
292:
293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
294: FND_MSG_PUB.initialize ;
295: END IF;
296: --
297: p_return_status := FND_API.G_RET_STS_SUCCESS ;
298: --

Line 374: FND_MSG_PUB.Add;

370: ) then
371: p_lock_row := FND_API.G_TRUE;
372: ELSE
373: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
374: FND_MSG_PUB.Add;
375: RAISE FND_API.G_EXC_ERROR ;
376: END IF;
377:
378: --

Line 383: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

379: IF FND_API.To_Boolean ( p_commit ) THEN
380: COMMIT WORK;
381: END iF;
382: --
383: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
384: p_data => p_msg_data );
385: --
386: EXCEPTION
387: --

Line 393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

389: --
390: ROLLBACK TO Lock_Row_Pvt ;
391: p_lock_row := FND_API.G_FALSE;
392: p_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
394: p_data => p_msg_data );
395: --
396: WHEN FND_API.G_EXC_ERROR THEN
397: --

Line 401: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

397: --
398: ROLLBACK TO Lock_Row_Pvt ;
399: p_lock_row := FND_API.G_FALSE;
400: p_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
402: p_data => p_msg_data );
403: --
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: --

Line 408: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: --
406: ROLLBACK TO Lock_Row_Pvt ;
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
409: p_data => p_msg_data );
410: --
411: WHEN OTHERS THEN
412: --

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

412: --
413: ROLLBACK TO Lock_Row_Pvt ;
414: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: --
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
417: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
418: l_api_name);
419: END if;
420: --

Line 417: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

413: ROLLBACK TO Lock_Row_Pvt ;
414: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: --
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
417: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
418: l_api_name);
419: END if;
420: --
421: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 421: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

417: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
418: l_api_name);
419: END if;
420: --
421: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
422: p_data => p_msg_data );
423: --
424: END Lock_Row;
425:

Line 482: FND_MSG_PUB.initialize ;

478: END IF;
479: --
480:
481: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
482: FND_MSG_PUB.initialize ;
483: END IF;
484: --
485: p_return_status := FND_API.G_RET_STS_SUCCESS ;
486: --

Line 527: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

523: IF FND_API.To_Boolean ( p_commit ) THEN
524: COMMIT WORK;
525: END iF;
526: --
527: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
528: p_data => p_msg_data );
529: --
530: EXCEPTION
531: --

Line 536: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

532: WHEN FND_API.G_EXC_ERROR THEN
533: --
534: ROLLBACK TO Update_Row_Pvt ;
535: p_return_status := FND_API.G_RET_STS_ERROR;
536: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
537: p_data => p_msg_data );
538: --
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: --

Line 543: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: --
541: ROLLBACK TO Update_Row_Pvt ;
542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
544: p_data => p_msg_data );
545: --
546: WHEN OTHERS THEN
547: --

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

547: --
548: ROLLBACK TO Update_Row_Pvt ;
549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: --
551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
553: l_api_name);
554: END if;
555: --

Line 552: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

548: ROLLBACK TO Update_Row_Pvt ;
549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: --
551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
553: l_api_name);
554: END if;
555: --
556: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 556: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

552: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
553: l_api_name);
554: END if;
555: --
556: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
557: p_data => p_msg_data );
558: --
559: END Update_Row;
560:

Line 590: FND_MSG_PUB.initialize ;

586: END IF;
587: --
588:
589: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
590: FND_MSG_PUB.initialize ;
591: END IF;
592: --
593: p_return_status := FND_API.G_RET_STS_SUCCESS ;
594: --

Line 607: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

603: IF FND_API.To_Boolean ( p_commit ) THEN
604: COMMIT WORK;
605: END iF;
606: --
607: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
608: p_data => p_msg_data );
609:
610: EXCEPTION
611: --

Line 616: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

612: WHEN FND_API.G_EXC_ERROR THEN
613: --
614: ROLLBACK TO Delete_Row_Pvt ;
615: p_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
617: p_data => p_msg_data );
618: --
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: --

Line 623: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: --
621: ROLLBACK TO Delete_Row_Pvt ;
622: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
624: p_data => p_msg_data );
625: --
626: WHEN OTHERS THEN
627: --

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

627: --
628: ROLLBACK TO Delete_Row_Pvt ;
629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: --
631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
632: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
633: l_api_name);
634: END if;
635: --

Line 632: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

628: ROLLBACK TO Delete_Row_Pvt ;
629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: --
631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
632: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
633: l_api_name);
634: END if;
635: --
636: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 636: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

632: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
633: l_api_name);
634: END if;
635: --
636: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
637: p_data => p_msg_data );
638: --
639: END Delete_Row;
640:

Line 801: FND_MSG_PUB.initialize ;

797:
798: -- Initialize message list if p_init_msg_list is set to TRUE.
799:
800: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
801: FND_MSG_PUB.initialize ;
802: END IF;
803:
804: -- Initialize API return status to success
805:

Line 828: FND_MSG_PUB.Add;

824: IF l_source_data_extract_id IS NULL THEN
825:
826: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_DATA_EXTRACT') ;
827: Fnd_Message.Set_Token('DATA_EXTRACT_ID', l_source_data_extract_id ) ;
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR ;
830:
831: ELSE
832:

Line 1700: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1696: END IF;
1697:
1698: -- Standard call to get message count and if count is 1, get message info.
1699:
1700: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1701: p_data => p_msg_data);
1702:
1703: EXCEPTION
1704:

Line 1711: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1707: ROLLBACK TO Copy_Parameter_Set_Pvt;
1708:
1709: p_return_status := FND_API.G_RET_STS_ERROR;
1710:
1711: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1712: p_data => p_msg_data);
1713:
1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1721: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1717: ROLLBACK TO Copy_Parameter_Set_Pvt;
1718:
1719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720:
1721: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1722: p_data => p_msg_data);
1723:
1724: WHEN OTHERS THEN
1725:

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

1726: ROLLBACK TO Copy_Parameter_Set_Pvt;
1727:
1728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1729:
1730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1731:
1732: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1733: l_api_name);
1734: END IF;

Line 1732: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1729:
1730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1731:
1732: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1733: l_api_name);
1734: END IF;
1735:
1736: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1736: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1732: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1733: l_api_name);
1734: END IF;
1735:
1736: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1737: p_data => p_msg_data);
1738:
1739: END Copy_Entity_Set;
1740:

Line 1856: FND_MSG_PUB.initialize;

1852:
1853: -- Initialize message list if p_init_msg_list is set to TRUE.
1854:
1855: IF FND_API.to_Boolean (p_init_msg_list) THEN
1856: FND_MSG_PUB.initialize;
1857: END IF;
1858:
1859: -- Initialize API return status to success
1860:

Line 1981: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1977: END IF;
1978:
1979: -- Standard call to get message count and if count is 1, get message info.
1980:
1981: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1982: p_data => p_msg_data);
1983:
1984: EXCEPTION
1985:

Line 1992: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1988: ROLLBACK TO Copy_Attributes_Pvt;
1989:
1990: p_return_status := FND_API.G_RET_STS_ERROR;
1991:
1992: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1993: p_data => p_msg_data);
1994:
1995:
1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2002: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1998: ROLLBACK TO Copy_Attributes_Pvt;
1999:
2000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001:
2002: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2003: p_data => p_msg_data);
2004:
2005: WHEN OTHERS THEN
2006:

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

2007: ROLLBACK TO Copy_Attributes_Pvt;
2008:
2009: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010:
2011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2012:
2013: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2014: l_api_name);
2015: END IF;

Line 2013: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

2009: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010:
2011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2012:
2013: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2014: l_api_name);
2015: END IF;
2016:
2017: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 2017: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2013: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2014: l_api_name);
2015: END IF;
2016:
2017: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2018: p_data => p_msg_data);
2019: END Copy_Attributes;
2020:
2021: /*---------------------------------------------------------------------------*/

Line 2081: FND_MSG_PUB.initialize ;

2077: END IF;
2078: --
2079:
2080: IF ( FND_API.To_Boolean(p_init_msg_list)) THEN
2081: FND_MSG_PUB.initialize ;
2082: END IF;
2083:
2084: FOR c_check_references_ws_rec IN c_check_references_ws LOOP
2085: l_return_value := 'TRUE' ;

Line 2100: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

2096: IF ( FND_API.To_Boolean(p_commit)) THEN
2097: COMMIT WORK;
2098: END IF;
2099: --
2100: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2101: p_data => p_msg_data );
2102:
2103: p_return_value := l_return_value;
2104: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2113: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

2109: --
2110: ROLLBACK TO Check_References_Pvt ;
2111: p_return_status := FND_API.G_RET_STS_ERROR;
2112: p_return_value := l_return_value;
2113: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2114: p_data => p_msg_data );
2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2116: --
2117: ROLLBACK TO Check_References_Pvt ;

Line 2120: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

2116: --
2117: ROLLBACK TO Check_References_Pvt ;
2118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: p_return_value := l_return_value;
2120: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2121: p_data => p_msg_data );
2122: WHEN OTHERS THEN
2123: --
2124: ROLLBACK TO Check_References_Pvt ;

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

2123: --
2124: ROLLBACK TO Check_References_Pvt ;
2125: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126: p_return_value := l_return_value;
2127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2128: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2129: l_api_name);
2130: END IF;
2131: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 2128: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2124: ROLLBACK TO Check_References_Pvt ;
2125: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126: p_return_value := l_return_value;
2127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2128: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2129: l_api_name);
2130: END IF;
2131: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2132: p_data => p_msg_data );

Line 2131: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

2127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2128: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2129: l_api_name);
2130: END IF;
2131: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2132: p_data => p_msg_data );
2133: --
2134: END Check_References;
2135: