DBA Data[Home] [Help]

APPS.RCV_CREATEACCOUNTING_PVT dependencies on FND_MSG_PUB

Line 92: FND_MSG_PUB.initialize;

88: -- Initialize message list
89: l_stmt_num := 10;
90:
91: IF FND_API.to_boolean( p_init_msg_list ) THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94:
95: -- Initialize API return status to success
96: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 183: FND_MSG_PUB.Count_And_Get

179:
180: -- Get Message count and if 1, return message data
181: l_stmt_num := 80;
182:
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data
186: );
187: IF G_DEBUG = 'Y' THEN

Line 202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

198: FND_LOG.string(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
199: ,'Get_GLInformation : '||l_stmt_num||' : '||l_api_message);
200: END IF;
201: END IF;
202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
203: FND_MSG_PUB.Add_Exc_Msg(
204: p_pkg_name => G_PKG_NAME,
205: p_procedure_name => l_api_name,
206: p_error_text => 'Error at: '||

Line 203: FND_MSG_PUB.Add_Exc_Msg(

199: ,'Get_GLInformation : '||l_stmt_num||' : '||l_api_message);
200: END IF;
201: END IF;
202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
203: FND_MSG_PUB.Add_Exc_Msg(
204: p_pkg_name => G_PKG_NAME,
205: p_procedure_name => l_api_name,
206: p_error_text => 'Error at: '||
207: to_char(l_stmt_num) || ' '||

Line 213: FND_MSG_PUB.count_and_get

209: SQLERRM
210: );
211:
212: END IF;
213: FND_MSG_PUB.count_and_get
214: ( p_count => x_msg_count
215: , p_data => x_msg_data
216: );
217: x_return_status := FND_API.G_RET_STS_ERROR;

Line 228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

224: ,'Get_GLInformation : '||l_stmt_num||' : '||l_api_message);
225: END IF;
226: END IF;
227:
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: FND_MSG_PUB.Add_Exc_Msg(
230: p_pkg_name => G_PKG_NAME,
231: p_procedure_name => l_api_name,
232: p_error_text => 'Error at: '||

Line 229: FND_MSG_PUB.Add_Exc_Msg(

225: END IF;
226: END IF;
227:
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: FND_MSG_PUB.Add_Exc_Msg(
230: p_pkg_name => G_PKG_NAME,
231: p_procedure_name => l_api_name,
232: p_error_text => 'Error at: '||
233: to_char(l_stmt_num) || ' '||

Line 239: FND_MSG_PUB.count_and_get

235: SQLERRM
236: );
237:
238: END IF;
239: FND_MSG_PUB.count_and_get
240: ( p_count => x_msg_count
241: , p_data => x_msg_data
242: );
243: x_return_status := FND_API.G_RET_STS_ERROR;

Line 254: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

250: ,'Get_GLInformation : '||l_stmt_num||' : '||l_api_message);
251: END IF;
252: END IF;
253:
254: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
255: FND_MSG_PUB.Add_Exc_Msg(
256: p_pkg_name => G_PKG_NAME,
257: p_procedure_name => l_api_name,
258: p_error_text => 'Error at: '||

Line 255: FND_MSG_PUB.Add_Exc_Msg(

251: END IF;
252: END IF;
253:
254: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
255: FND_MSG_PUB.Add_Exc_Msg(
256: p_pkg_name => G_PKG_NAME,
257: p_procedure_name => l_api_name,
258: p_error_text => 'Error at: '||
259: to_char(l_stmt_num) || ' '||

Line 264: FND_MSG_PUB.count_and_get

260: SQLERRM
261: );
262:
263: END IF;
264: FND_MSG_PUB.count_and_get
265: ( p_count => x_msg_count
266: , p_data => x_msg_data
267: );
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 329: FND_MSG_PUB.initialize;

325: -- Initialize message list
326: l_stmt_num := 10;
327:
328: IF FND_API.to_boolean( p_init_msg_list ) THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: -- Initialize API return status to success
333: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 697: FND_MSG_PUB.Count_And_Get

693:
694: -- Get Message count and if 1, return message data
695: l_stmt_num := 70;
696:
697: FND_MSG_PUB.Count_And_Get
698: ( p_count => x_msg_count,
699: p_data => x_msg_data
700: );
701:

Line 713: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

709: END IF;
710: END IF;
711:
712:
713: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
714: FND_MSG_PUB.Add_Exc_Msg(
715: p_pkg_name => G_PKG_NAME,
716: p_procedure_name => l_api_name,
717: p_error_text => 'Error at: '||

Line 714: FND_MSG_PUB.Add_Exc_Msg(

710: END IF;
711:
712:
713: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
714: FND_MSG_PUB.Add_Exc_Msg(
715: p_pkg_name => G_PKG_NAME,
716: p_procedure_name => l_api_name,
717: p_error_text => 'Error at: '||
718: to_char(l_stmt_num) || ' '||

Line 725: FND_MSG_PUB.Count_And_Get

721: );
722:
723: END IF;
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count,
727: p_data => x_msg_data
728: );
729:

Line 738: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

734: ,'Insert_SubLedgerLines : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
735: END IF;
736: END IF;
737:
738: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
739: FND_MSG_PUB.Add_Exc_Msg(
740: p_pkg_name => G_PKG_NAME,
741: p_procedure_name => l_api_name,
742: p_error_text => 'Error at: '||

Line 739: FND_MSG_PUB.Add_Exc_Msg(

735: END IF;
736: END IF;
737:
738: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
739: FND_MSG_PUB.Add_Exc_Msg(
740: p_pkg_name => G_PKG_NAME,
741: p_procedure_name => l_api_name,
742: p_error_text => 'Error at: '||
743: to_char(l_stmt_num) || ' '||

Line 749: FND_MSG_PUB.Count_And_Get

745: );
746:
747: END IF;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: FND_MSG_PUB.Count_And_Get
750: ( p_count => x_msg_count,
751: p_data => x_msg_data
752: );
753:

Line 808: FND_MSG_PUB.initialize;

804: BEGIN
805: -- Initialize message list
806: l_stmt_num := 10;
807: IF FND_API.to_boolean( p_init_msg_list ) THEN
808: FND_MSG_PUB.initialize;
809: END IF;
810:
811: -- Initialize API return status to success
812: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 971: FND_MSG_PUB.Count_And_Get

967: END IF;
968:
969:
970: -- Get Message count and if 1, return message data
971: FND_MSG_PUB.Count_And_Get
972: ( p_count => x_msg_count,
973: p_data => x_msg_data
974: );
975: EXCEPTION

Line 985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

981: ,'Get_AccountingLineType : '||l_stmt_num||' : '||l_api_message);
982: END IF;
983: END IF;
984:
985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
986: FND_MSG_PUB.Add_Exc_Msg(
987: p_pkg_name => G_PKG_NAME,
988: p_procedure_name => l_api_name,
989: p_error_text => 'Error at: '||

Line 986: FND_MSG_PUB.Add_Exc_Msg(

982: END IF;
983: END IF;
984:
985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
986: FND_MSG_PUB.Add_Exc_Msg(
987: p_pkg_name => G_PKG_NAME,
988: p_procedure_name => l_api_name,
989: p_error_text => 'Error at: '||
990: to_char(l_stmt_num) || ' '||

Line 997: FND_MSG_PUB.Count_And_Get

993: );
994:
995: END IF;
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: FND_MSG_PUB.Count_And_Get
998: ( p_count => x_msg_count,
999: p_data => x_msg_data
1000: );
1001:

Line 1010: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1006: ,'Get_AccountingLineType : '||l_stmt_num||' : '||SUBSTR(sqlerrm,1,200));
1007: END IF;
1008: END IF;
1009:
1010: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1011: FND_MSG_PUB.Add_Exc_Msg(
1012: p_pkg_name => G_PKG_NAME,
1013: p_procedure_name => l_api_name,
1014: p_error_text => 'Error at: '||

Line 1011: FND_MSG_PUB.Add_Exc_Msg(

1007: END IF;
1008: END IF;
1009:
1010: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1011: FND_MSG_PUB.Add_Exc_Msg(
1012: p_pkg_name => G_PKG_NAME,
1013: p_procedure_name => l_api_name,
1014: p_error_text => 'Error at: '||
1015: to_char(l_stmt_num) || ' '||

Line 1021: FND_MSG_PUB.Count_And_Get

1017: );
1018:
1019: END IF;
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021: FND_MSG_PUB.Count_And_Get
1022: ( p_count => x_msg_count,
1023: p_data => x_msg_data
1024: );
1025:

Line 1154: FND_MSG_PUB.initialize;

1150:
1151: -- Initialize message list if p_init_msg_list is set to TRUE
1152: l_stmt_num := 20;
1153: IF FND_API.to_Boolean(p_init_msg_list) THEN
1154: FND_MSG_PUB.initialize;
1155: END IF;
1156:
1157: -- Initialize API return status to success
1158:

Line 1828: FND_MSG_PUB.count_and_get

1824: EXCEPTION
1825: WHEN FND_API.g_exc_error THEN
1826: ROLLBACK TO RCV_CreateAccounting_PVT;
1827: x_return_status := FND_API.g_ret_sts_error;
1828: FND_MSG_PUB.count_and_get
1829: ( p_count => x_msg_count
1830: , p_data => x_msg_data
1831: );
1832: WHEN FND_API.g_exc_unexpected_error THEN

Line 1835: FND_MSG_PUB.count_and_get

1831: );
1832: WHEN FND_API.g_exc_unexpected_error THEN
1833: ROLLBACK TO RCV_CreateAccounting_PVT;
1834: x_return_status := FND_API.g_ret_sts_unexp_error ;
1835: FND_MSG_PUB.count_and_get
1836: ( p_count => x_msg_count
1837: , p_data => x_msg_data
1838: );
1839: WHEN NO_RAE_DATA THEN

Line 1848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1844: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num, 'Create_AccountingEntry : '||l_stmt_num||' : '||SUBSTR(sqlerrm,1,200));
1845: END IF;
1846: END IF;
1847:
1848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1849: FND_MSG_PUB.Add_Exc_Msg(
1850: p_pkg_name => G_PKG_NAME,
1851: p_procedure_name => l_api_name,
1852: p_error_text => 'Error at: '||

Line 1849: FND_MSG_PUB.Add_Exc_Msg(

1845: END IF;
1846: END IF;
1847:
1848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1849: FND_MSG_PUB.Add_Exc_Msg(
1850: p_pkg_name => G_PKG_NAME,
1851: p_procedure_name => l_api_name,
1852: p_error_text => 'Error at: '||
1853: to_char(l_stmt_num) || ' '||

Line 1860: FND_MSG_PUB.count_and_get

1856: );
1857:
1858: END IF;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: FND_MSG_PUB.count_and_get
1861: ( p_count => x_msg_count
1862: , p_data => x_msg_data
1863: );
1864: WHEN NO_CURRENCY_INFORMATION THEN

Line 1872: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1868: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num, 'No Data in FND_CURRENCIES for Currency Specified : '||l_stmt_num||' : '||SUBSTR(sqlerrm,1,200));
1869: END IF;
1870: END IF;
1871:
1872: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1873: FND_MSG_PUB.Add_Exc_Msg(
1874: p_pkg_name => G_PKG_NAME,
1875: p_procedure_name => l_api_name,
1876: p_error_text => 'Error at: '||

Line 1873: FND_MSG_PUB.Add_Exc_Msg(

1869: END IF;
1870: END IF;
1871:
1872: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1873: FND_MSG_PUB.Add_Exc_Msg(
1874: p_pkg_name => G_PKG_NAME,
1875: p_procedure_name => l_api_name,
1876: p_error_text => 'Error at: '||
1877: to_char(l_stmt_num) || ' '||

Line 1884: FND_MSG_PUB.count_and_get

1880: );
1881:
1882: END IF;
1883: x_return_status := FND_API.G_RET_STS_ERROR;
1884: FND_MSG_PUB.count_and_get
1885: ( p_count => x_msg_count
1886: , p_data => x_msg_data
1887: );
1888:

Line 1897: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1893: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num, 'No Data in PO Tables for the Transaction : '||l_stmt_num||' : '||SUBSTR(sqlerrm,1,200));
1894: END IF;
1895: END IF;
1896:
1897: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(
1899: p_pkg_name => G_PKG_NAME,
1900: p_procedure_name => l_api_name,
1901: p_error_text => 'Error at: '||

Line 1898: FND_MSG_PUB.Add_Exc_Msg(

1894: END IF;
1895: END IF;
1896:
1897: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(
1899: p_pkg_name => G_PKG_NAME,
1900: p_procedure_name => l_api_name,
1901: p_error_text => 'Error at: '||
1902: to_char(l_stmt_num) || ' '||

Line 1909: FND_MSG_PUB.count_and_get

1905: );
1906:
1907: END IF;
1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909: FND_MSG_PUB.count_and_get
1910: ( p_count => x_msg_count
1911: , p_data => x_msg_data
1912: );
1913:

Line 1923: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1919: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num, 'Create_AccountingEntry : '||l_stmt_num||' : '||SUBSTR(sqlerrm,1,200));
1920: END IF;
1921: END IF;
1922:
1923: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1924: FND_MSG_PUB.Add_Exc_Msg(
1925: p_pkg_name => G_PKG_NAME,
1926: p_procedure_name => l_api_name,
1927: p_error_text => 'Error at: '||

Line 1924: FND_MSG_PUB.Add_Exc_Msg(

1920: END IF;
1921: END IF;
1922:
1923: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1924: FND_MSG_PUB.Add_Exc_Msg(
1925: p_pkg_name => G_PKG_NAME,
1926: p_procedure_name => l_api_name,
1927: p_error_text => 'Error at: '||
1928: to_char(l_stmt_num) || ' '||

Line 1934: FND_MSG_PUB.count_and_get

1930: );
1931:
1932: END IF;
1933: x_return_status := FND_API.G_RET_STS_ERROR;
1934: FND_MSG_PUB.count_and_get
1935: ( p_count => x_msg_count
1936: , p_data => x_msg_data
1937: );
1938: