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.CST_SUBELEMENTS_PVT dependencies on FND_MSG_PUB

Line 80: FND_MSG_PUB.initialize;

76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.to_Boolean(p_init_msg_list) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: -- Initialize API return status to success
84: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 120: fnd_msg_pub.add;

116: fnd_file.put_line(fnd_file.log,x_msg_data);
117: l_api_message := 'Compatible_API_Call returned Error';
118: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
119: FND_MESSAGE.set_token('TEXT', l_api_message);
120: fnd_msg_pub.add;
121: RAISE fnd_api.g_exc_error ;
122: END IF;
123:
124:

Line 155: fnd_msg_pub.add;

151: fnd_file.put_line(fnd_file.log,x_msg_data);
152: l_api_message := 'createSubElements returned Error';
153: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
154: FND_MESSAGE.set_token('TEXT', l_api_message);
155: fnd_msg_pub.add;
156: RAISE fnd_api.g_exc_error ;
157: END IF;
158:
159: end if;

Line 193: fnd_msg_pub.add;

189: fnd_file.put_line(fnd_file.log,x_msg_data);
190: l_api_message := 'summarizeSubElements returned Error';
191: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
192: FND_MESSAGE.set_token('TEXT', l_api_message);
193: fnd_msg_pub.add;
194: RAISE fnd_api.g_exc_error ;
195: END IF;
196:
197: end if;

Line 205: FND_MSG_PUB.Count_And_Get (

201: COMMIT WORK;
202: END IF;
203:
204: -- Standard Call to get message count and if count = 1, get message info
205: FND_MSG_PUB.Count_And_Get (
206: p_count => x_msg_count,
207: p_data => x_msg_data );
208:
209:

Line 215: fnd_msg_pub.count_and_get

211: WHEN fnd_api.g_exc_error THEN
212: x_return_status := fnd_api.g_ret_sts_error;
213:
214: -- Get message count and data
215: fnd_msg_pub.count_and_get
216: ( p_count => x_msg_count
217: , p_data => x_msg_data
218: );
219:

Line 224: fnd_msg_pub.count_and_get

220: WHEN fnd_api.g_exc_unexpected_error THEN
221: x_return_status := fnd_api.g_ret_sts_unexp_error ;
222:
223: -- Get message count and data
224: fnd_msg_pub.count_and_get
225: ( p_count => x_msg_count
226: , p_data => x_msg_data
227: );
228: --

Line 232: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

228: --
229: WHEN OTHERS THEN
230: x_return_status := fnd_api.g_ret_sts_unexp_error ;
231: --
232: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
233: THEN
234: fnd_msg_pub.add_exc_msg
235: ( 'CST_SubElements_PVT'
236: , 'processInterface : Statement -'||to_char(l_statement)

Line 234: fnd_msg_pub.add_exc_msg

230: x_return_status := fnd_api.g_ret_sts_unexp_error ;
231: --
232: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
233: THEN
234: fnd_msg_pub.add_exc_msg
235: ( 'CST_SubElements_PVT'
236: , 'processInterface : Statement -'||to_char(l_statement)
237: );
238:

Line 242: fnd_msg_pub.count_and_get

238:
239: END IF;
240:
241: -- Get message count and data
242: fnd_msg_pub.count_and_get
243: ( p_count => x_msg_count
244: , p_data => x_msg_data
245: );
246: END processInterface;

Line 339: FND_MSG_PUB.initialize;

335: END IF;
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE
338: IF FND_API.to_Boolean(p_init_msg_list) THEN
339: FND_MSG_PUB.initialize;
340: END IF;
341:
342: -- Initiliaze API return status to success
343: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 353: FND_MSG_PUB.ADD;

349: FND_FILE.PUT_LINE(FND_FILE.LOG,'From Org, To Org or Cost Group Info is missing');
350: l_api_message := 'From Org, To Org or Cost Group Info is missing';
351: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
352: FND_MESSAGE.set_token('TEXT', l_api_message);
353: FND_MSG_PUB.ADD;
354:
355: RAISE fnd_api.g_exc_error;
356: END IF;
357:

Line 377: FND_MSG_PUB.ADD;

373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many resource with the same code');
374: l_api_message := 'Too many resource with the same code';
375: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
376: FND_MESSAGE.set_token('TEXT', l_api_message);
377: FND_MSG_PUB.ADD;
378:
379: RAISE fnd_api.g_exc_error;
380: elsif (l_exists = 0) then
381: l_statement := 30;

Line 420: FND_MSG_PUB.ADD;

416: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many Dept with the same code');
417: l_api_message := 'Too many Dept with the same code';
418: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
419: FND_MESSAGE.set_token('TEXT', l_api_message);
420: FND_MSG_PUB.ADD;
421:
422: RAISE fnd_api.g_exc_error;
423: elsif (l_exists = 0) then
424: l_statement := 80;

Line 461: FND_MSG_PUB.ADD;

457: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many Activities with the same code');
458: l_api_message := 'Too many Activities with the same code';
459: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
460: FND_MESSAGE.set_token('TEXT', l_api_message);
461: FND_MSG_PUB.ADD;
462:
463:
464: RAISE fnd_api.g_exc_error;
465: elsif (l_exists = 0) then

Line 491: FND_MSG_PUB.Count_And_Get (

487: COMMIT WORK;
488: END IF;
489:
490: -- Standard Call to get message count and if count = 1, get message info
491: FND_MSG_PUB.Count_And_Get (
492: p_count => x_msg_count,
493: p_data => x_msg_data );
494:
495:

Line 501: fnd_msg_pub.count_and_get

497: WHEN fnd_api.g_exc_error THEN
498: x_return_status := fnd_api.g_ret_sts_error;
499:
500: -- Get message count and data
501: fnd_msg_pub.count_and_get
502: ( p_count => x_msg_count
503: , p_data => x_msg_data
504: );
505: --

Line 510: fnd_msg_pub.count_and_get

506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error ;
508:
509: -- Get message count and data
510: fnd_msg_pub.count_and_get
511: ( p_count => x_msg_count
512: , p_data => x_msg_data
513: );
514: --

Line 518: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

514: --
515: WHEN OTHERS THEN
516: x_return_status := fnd_api.g_ret_sts_unexp_error ;
517: --
518: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
519: THEN
520: fnd_msg_pub.add_exc_msg
521: ( 'CST_SubElements_PVT'
522: , 'getNonMatchingSubElements : Statement -'||to_char(l_statement)

Line 520: fnd_msg_pub.add_exc_msg

516: x_return_status := fnd_api.g_ret_sts_unexp_error ;
517: --
518: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
519: THEN
520: fnd_msg_pub.add_exc_msg
521: ( 'CST_SubElements_PVT'
522: , 'getNonMatchingSubElements : Statement -'||to_char(l_statement)
523: );
524:

Line 528: fnd_msg_pub.count_and_get

524:
525: END IF;
526:
527: -- Get message count and data
528: fnd_msg_pub.count_and_get
529: ( p_count => x_msg_count
530: , p_data => x_msg_data
531: );
532: END getNonMatchingSubElements;

Line 638: FND_MSG_PUB.initialize;

634: -- Initialize message list if p_init_msg_list is set to TRUE
635: -------------------------------------------------------------------------
636:
637: IF FND_API.to_Boolean(p_init_msg_list) THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641: -------------------------------------------------------------------------
642: -- Set WHO columns

Line 857: fnd_msg_pub.add;

853:
854: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
855: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');
856: fnd_message.set_token('DEPT_CODE',p_department_tbl( l_counter).CODE,TRUE);
857: fnd_msg_pub.add;
858: RAISE fnd_api.g_exc_error ;
859: END IF;
860:
861: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 864: fnd_msg_pub.add;

860:
861: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
862: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');
863: fnd_message.set_token('DEPT_CODE',p_department_tbl( l_counter).CODE,TRUE);
864: fnd_msg_pub.add;
865: RAISE fnd_api.g_exc_unexpected_error ;
866: END IF;
867:
868: END IF; --check for wsm flag

Line 1197: fnd_msg_pub.add;

1193: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1194:
1195: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1196: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');
1197: fnd_msg_pub.add;
1198: RAISE fnd_api.g_exc_error ;
1199: END IF;
1200:
1201: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 1203: fnd_msg_pub.add;

1199: END IF;
1200:
1201: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1202: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');
1203: fnd_msg_pub.add;
1204: RAISE fnd_api.g_exc_unexpected_error ;
1205: END IF;
1206:
1207:

Line 1219: fnd_msg_pub.add;

1215:
1216: IF l_purchase_item_id IS NULL THEN
1217: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_NULL');
1218: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1219: fnd_msg_pub.add;
1220:
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,
1222: 'WARNING: OSP Item is missing for Res_id: '
1223: ||TO_CHAR(l_source_resource_id));

Line 1271: fnd_msg_pub.add;

1267:
1268: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1269: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');
1270: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1271: fnd_msg_pub.add;
1272: RAISE fnd_api.g_exc_error ;
1273: END IF;
1274:
1275: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 1278: fnd_msg_pub.add;

1274:
1275: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1276: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');
1277: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1278: fnd_msg_pub.add;
1279: RAISE fnd_api.g_exc_unexpected_error ;
1280: END IF;
1281: ELSE
1282: l_default_activity_id := l_dummy;

Line 1318: fnd_msg_pub.add;

1314:
1315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1316: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');
1317: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1318: fnd_msg_pub.add;
1319: RAISE fnd_api.g_exc_error ;
1320: END IF;
1321:
1322: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 1325: fnd_msg_pub.add;

1321:
1322: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1323: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');
1324: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1325: fnd_msg_pub.add;
1326: RAISE fnd_api.g_exc_unexpected_error ;
1327: END IF;
1328:
1329: IF (l_expenditure_type IS NULL) THEN

Line 1366: fnd_msg_pub.add;

1362:
1363: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1364: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');
1365: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1366: fnd_msg_pub.add;
1367: RAISE fnd_api.g_exc_error ;
1368: END IF;
1369:
1370: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 1373: fnd_msg_pub.add;

1369:
1370: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1371: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');
1372: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1373: fnd_msg_pub.add;
1374: RAISE fnd_api.g_exc_unexpected_error ;
1375: END IF;
1376:
1377: END IF; -- check for exact copy

Line 1523: FND_MSG_PUB.Count_And_Get (

1519: ---------------------------------------------------------------------------
1520: -- Standard Call to get message count and if count = 1, get message info
1521: ---------------------------------------------------------------------------
1522:
1523: FND_MSG_PUB.Count_And_Get (
1524: p_count => x_msg_count,
1525: p_data => x_msg_data );
1526:
1527:

Line 1533: fnd_msg_pub.count_and_get

1529: WHEN fnd_api.g_exc_error THEN
1530: x_return_status := fnd_api.g_ret_sts_error;
1531:
1532: -- Get message count and data
1533: fnd_msg_pub.count_and_get
1534: ( p_count => x_msg_count
1535: , p_data => x_msg_data
1536: );
1537: --

Line 1542: fnd_msg_pub.count_and_get

1538: WHEN fnd_api.g_exc_unexpected_error THEN
1539: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1540:
1541: -- Get message count and data
1542: fnd_msg_pub.count_and_get
1543: ( p_count => x_msg_count
1544: , p_data => x_msg_data
1545: );
1546: --

Line 1550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1546: --
1547: WHEN OTHERS THEN
1548: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1549: --
1550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1551: THEN
1552: fnd_msg_pub.add_exc_msg
1553: ( 'CST_SubElements_PVT'
1554: , 'createSubElements : Statement -'||to_char(l_statement)

Line 1552: fnd_msg_pub.add_exc_msg

1548: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1549: --
1550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1551: THEN
1552: fnd_msg_pub.add_exc_msg
1553: ( 'CST_SubElements_PVT'
1554: , 'createSubElements : Statement -'||to_char(l_statement)
1555: );
1556:

Line 1560: fnd_msg_pub.count_and_get

1556:
1557: END IF;
1558:
1559: -- Get message count and data
1560: fnd_msg_pub.count_and_get
1561: ( p_count => x_msg_count
1562: , p_data => x_msg_data
1563: );
1564: END createSubElements;

Line 1624: FND_MSG_PUB.initialize;

1620: -- Initialize message list if p_init_msg_list is set to TRUE
1621: -------------------------------------------------------------------------
1622:
1623: IF FND_API.to_Boolean(p_init_msg_list) THEN
1624: FND_MSG_PUB.initialize;
1625: END IF;
1626:
1627: -------------------------------------------------------------------------
1628: -- Initiliaze API return status to success

Line 1661: FND_MSG_PUB.Count_And_Get (

1657: --------------------------------------------------------------------------
1658: -- Standard Call to get message count and if count = 1, get message info
1659: --------------------------------------------------------------------------
1660:
1661: FND_MSG_PUB.Count_And_Get (
1662: p_count => x_msg_count,
1663: p_data => x_msg_data );
1664:
1665:

Line 1671: fnd_msg_pub.count_and_get

1667: WHEN fnd_api.g_exc_error THEN
1668: x_return_status := fnd_api.g_ret_sts_error;
1669:
1670: -- Get message count and data
1671: fnd_msg_pub.count_and_get
1672: ( p_count => x_msg_count
1673: , p_data => x_msg_data
1674: );
1675: --

Line 1680: fnd_msg_pub.count_and_get

1676: WHEN fnd_api.g_exc_unexpected_error THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1678:
1679: -- Get message count and data
1680: fnd_msg_pub.count_and_get
1681: ( p_count => x_msg_count
1682: , p_data => x_msg_data
1683: );
1684: --

Line 1688: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1684: --
1685: WHEN OTHERS THEN
1686: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1687: --
1688: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1689: THEN
1690: fnd_msg_pub.add_exc_msg
1691: ( 'CST_SubElements_PVT'
1692: , 'getDeptAccounts : Statement -'||to_char(l_statement)

Line 1690: fnd_msg_pub.add_exc_msg

1686: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1687: --
1688: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1689: THEN
1690: fnd_msg_pub.add_exc_msg
1691: ( 'CST_SubElements_PVT'
1692: , 'getDeptAccounts : Statement -'||to_char(l_statement)
1693: );
1694:

Line 1698: fnd_msg_pub.count_and_get

1694:
1695: END IF;
1696:
1697: -- Get message count and data
1698: fnd_msg_pub.count_and_get
1699: ( p_count => x_msg_count
1700: , p_data => x_msg_data
1701: );
1702: END getDeptAccounts;

Line 1761: FND_MSG_PUB.initialize;

1757: -- Initialize message list if p_init_msg_list is set to TRUE
1758: -------------------------------------------------------------------------
1759:
1760: IF FND_API.to_Boolean(p_init_msg_list) THEN
1761: FND_MSG_PUB.initialize;
1762: END IF;
1763:
1764: -------------------------------------------------------------------------
1765: -- Initiliaze API return status to success

Line 1786: FND_MSG_PUB.Count_And_Get (

1782: -------------------------------------------------------------------------
1783: -- Standard Call to get message count and if count = 1, get message info
1784: -------------------------------------------------------------------------
1785:
1786: FND_MSG_PUB.Count_And_Get (
1787: p_count => x_msg_count,
1788: p_data => x_msg_data );
1789:
1790:

Line 1796: fnd_msg_pub.count_and_get

1792: WHEN fnd_api.g_exc_error THEN
1793: x_return_status := fnd_api.g_ret_sts_error;
1794:
1795: -- Get message count and data
1796: fnd_msg_pub.count_and_get
1797: ( p_count => x_msg_count
1798: , p_data => x_msg_data
1799: );
1800: --

Line 1805: fnd_msg_pub.count_and_get

1801: WHEN fnd_api.g_exc_unexpected_error THEN
1802: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1803:
1804: -- Get message count and data
1805: fnd_msg_pub.count_and_get
1806: ( p_count => x_msg_count
1807: , p_data => x_msg_data
1808: );
1809: --

Line 1813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1809: --
1810: WHEN OTHERS THEN
1811: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1812: --
1813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1814: THEN
1815: fnd_msg_pub.add_exc_msg
1816: ( 'CST_SubElements_PVT'
1817: , 'getOSPItem : Statement -'||to_char(l_statement)

Line 1815: fnd_msg_pub.add_exc_msg

1811: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1812: --
1813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1814: THEN
1815: fnd_msg_pub.add_exc_msg
1816: ( 'CST_SubElements_PVT'
1817: , 'getOSPItem : Statement -'||to_char(l_statement)
1818: );
1819:

Line 1823: fnd_msg_pub.count_and_get

1819:
1820: END IF;
1821:
1822: -- Get message count and data
1823: fnd_msg_pub.count_and_get
1824: ( p_count => x_msg_count
1825: , p_data => x_msg_data
1826: );
1827: END getOSPItem;

Line 1887: FND_MSG_PUB.initialize;

1883: -- Initialize message list if p_init_msg_list is set to TRUE
1884: -------------------------------------------------------------------------
1885:
1886: IF FND_API.to_Boolean(p_init_msg_list) THEN
1887: FND_MSG_PUB.initialize;
1888: END IF;
1889:
1890: -------------------------------------------------------------------------
1891: -- Initiliaze API return status to success

Line 1912: FND_MSG_PUB.Count_And_Get (

1908: -------------------------------------------------------------------------
1909: -- Standard Call to get message count and if count = 1, get message info
1910: -------------------------------------------------------------------------
1911:
1912: FND_MSG_PUB.Count_And_Get (
1913: p_count => x_msg_count,
1914: p_data => x_msg_data );
1915:
1916:

Line 1922: fnd_msg_pub.count_and_get

1918: WHEN fnd_api.g_exc_error THEN
1919: x_return_status := fnd_api.g_ret_sts_error;
1920:
1921: -- Get message count and data
1922: fnd_msg_pub.count_and_get
1923: ( p_count => x_msg_count
1924: , p_data => x_msg_data
1925: );
1926: --

Line 1931: fnd_msg_pub.count_and_get

1927: WHEN fnd_api.g_exc_unexpected_error THEN
1928: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1929:
1930: -- Get message count and data
1931: fnd_msg_pub.count_and_get
1932: ( p_count => x_msg_count
1933: , p_data => x_msg_data
1934: );
1935: --

Line 1939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1935: --
1936: WHEN OTHERS THEN
1937: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1938: --
1939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1940: THEN
1941: fnd_msg_pub.add_exc_msg
1942: ( 'CST_SubElements_PVT'
1943: , 'getDefaultActivity : Statement -'||to_char(l_statement)

Line 1941: fnd_msg_pub.add_exc_msg

1937: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1938: --
1939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1940: THEN
1941: fnd_msg_pub.add_exc_msg
1942: ( 'CST_SubElements_PVT'
1943: , 'getDefaultActivity : Statement -'||to_char(l_statement)
1944: );
1945:

Line 1949: fnd_msg_pub.count_and_get

1945:
1946: END IF;
1947:
1948: -- Get message count and data
1949: fnd_msg_pub.count_and_get
1950: ( p_count => x_msg_count
1951: , p_data => x_msg_data
1952: );
1953: END getDefaultActivity;

Line 2013: FND_MSG_PUB.initialize;

2009: -- Initialize message list if p_init_msg_list is set to TRUE
2010: -------------------------------------------------------------------------
2011:
2012: IF FND_API.to_Boolean(p_init_msg_list) THEN
2013: FND_MSG_PUB.initialize;
2014: END IF;
2015:
2016: -------------------------------------------------------------------------
2017: -- Initiliaze API return status to success

Line 2051: FND_MSG_PUB.Count_And_Get (

2047: -------------------------------------------------------------------------
2048: -- Standard Call to get message count and if count = 1, get message info
2049: -------------------------------------------------------------------------
2050:
2051: FND_MSG_PUB.Count_And_Get (
2052: p_count => x_msg_count,
2053: p_data => x_msg_data );
2054:
2055:

Line 2061: fnd_msg_pub.count_and_get

2057: WHEN fnd_api.g_exc_error THEN
2058: x_return_status := fnd_api.g_ret_sts_error;
2059:
2060: -- Get message count and data
2061: fnd_msg_pub.count_and_get
2062: ( p_count => x_msg_count
2063: , p_data => x_msg_data
2064: );
2065: --

Line 2070: fnd_msg_pub.count_and_get

2066: WHEN fnd_api.g_exc_unexpected_error THEN
2067: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2068:
2069: -- Get message count and data
2070: fnd_msg_pub.count_and_get
2071: ( p_count => x_msg_count
2072: , p_data => x_msg_data
2073: );
2074: --

Line 2078: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2074: --
2075: WHEN OTHERS THEN
2076: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2077: --
2078: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2079: THEN
2080: fnd_msg_pub.add_exc_msg
2081: ( 'CST_SubElements_PVT'
2082: , 'getExpenditureType : Statement -'||to_char(l_statement)

Line 2080: fnd_msg_pub.add_exc_msg

2076: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2077: --
2078: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2079: THEN
2080: fnd_msg_pub.add_exc_msg
2081: ( 'CST_SubElements_PVT'
2082: , 'getExpenditureType : Statement -'||to_char(l_statement)
2083: );
2084:

Line 2088: fnd_msg_pub.count_and_get

2084:
2085: END IF;
2086:
2087: -- Get message count and data
2088: fnd_msg_pub.count_and_get
2089: ( p_count => x_msg_count
2090: , p_data => x_msg_data
2091: );
2092: END getExpenditureType;

Line 2156: FND_MSG_PUB.initialize;

2152: -- Initialize message list if p_init_msg_list is set to TRUE
2153: -------------------------------------------------------------------------
2154:
2155: IF FND_API.to_Boolean(p_init_msg_list) THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158:
2159: -------------------------------------------------------------------------
2160: -- Initiliaze API return status to success

Line 2200: FND_MSG_PUB.Count_And_Get (

2196: -------------------------------------------------------------------------
2197: -- Standard Call to get message count and if count = 1, get message info
2198: -------------------------------------------------------------------------
2199:
2200: FND_MSG_PUB.Count_And_Get (
2201: p_count => x_msg_count,
2202: p_data => x_msg_data );
2203:
2204:

Line 2210: fnd_msg_pub.count_and_get

2206: WHEN fnd_api.g_exc_error THEN
2207: x_return_status := fnd_api.g_ret_sts_error;
2208:
2209: -- Get message count and data
2210: fnd_msg_pub.count_and_get
2211: ( p_count => x_msg_count
2212: , p_data => x_msg_data
2213: );
2214: --

Line 2219: fnd_msg_pub.count_and_get

2215: WHEN fnd_api.g_exc_unexpected_error THEN
2216: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2217:
2218: -- Get message count and data
2219: fnd_msg_pub.count_and_get
2220: ( p_count => x_msg_count
2221: , p_data => x_msg_data
2222: );
2223: --

Line 2227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2223: --
2224: WHEN OTHERS THEN
2225: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2226: --
2227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2228: THEN
2229: fnd_msg_pub.add_exc_msg
2230: ( 'CST_SubElements_PVT'
2231: , 'getSubelementAcct : Statement -'||to_char(l_statement)

Line 2229: fnd_msg_pub.add_exc_msg

2225: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2226: --
2227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2228: THEN
2229: fnd_msg_pub.add_exc_msg
2230: ( 'CST_SubElements_PVT'
2231: , 'getSubelementAcct : Statement -'||to_char(l_statement)
2232: );
2233:

Line 2237: fnd_msg_pub.count_and_get

2233:
2234: END IF;
2235:
2236: -- Get message count and data
2237: fnd_msg_pub.count_and_get
2238: ( p_count => x_msg_count
2239: , p_data => x_msg_data
2240: );
2241: END getSubelementAcct;

Line 2334: FND_MSG_PUB.initialize;

2330: END IF;
2331:
2332: -- Initialize message list if p_init_msg_list is set to TRUE
2333: IF FND_API.to_Boolean(p_init_msg_list) THEN
2334: FND_MSG_PUB.initialize;
2335: END IF;
2336:
2337: -- Initiliaze API return status to success
2338: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2809: fnd_msg_pub.add;

2805: IF (l_miss_def_subelem > 0) THEN
2806: l_api_message := 'At Least One required Default Subelement is missing';
2807: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
2808: FND_MESSAGE.set_token('TEXT', l_api_message);
2809: fnd_msg_pub.add;
2810: RAISE fnd_api.g_exc_error ;
2811: END IF;
2812:
2813:

Line 2829: FND_MSG_PUB.Count_And_Get (

2825:
2826: l_statement := 150;
2827:
2828: -- Standard Call to get message count and if count = 1, get message info
2829: FND_MSG_PUB.Count_And_Get (
2830: p_count => x_msg_count,
2831: p_data => x_msg_data );
2832:
2833:

Line 2840: fnd_msg_pub.count_and_get

2836: WHEN fnd_api.g_exc_error THEN
2837: x_return_status := fnd_api.g_ret_sts_error;
2838:
2839: -- Get message count and data
2840: fnd_msg_pub.count_and_get
2841: ( p_count => x_msg_count
2842: , p_data => x_msg_data
2843: );
2844: --

Line 2849: fnd_msg_pub.count_and_get

2845: WHEN fnd_api.g_exc_unexpected_error THEN
2846: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2847:
2848: -- Get message count and data
2849: fnd_msg_pub.count_and_get
2850: ( p_count => x_msg_count
2851: , p_data => x_msg_data
2852: );
2853: --

Line 2857: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2853: --
2854: WHEN OTHERS THEN
2855: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2856: --
2857: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2858: THEN
2859: fnd_msg_pub.add_exc_msg
2860: ( 'CST_SubElements_PVT'
2861: , 'summarizeSubElements : Statement -'||to_char(l_statement)

Line 2859: fnd_msg_pub.add_exc_msg

2855: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2856: --
2857: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2858: THEN
2859: fnd_msg_pub.add_exc_msg
2860: ( 'CST_SubElements_PVT'
2861: , 'summarizeSubElements : Statement -'||to_char(l_statement)
2862: );
2863:

Line 2867: fnd_msg_pub.count_and_get

2863:
2864: END IF;
2865:
2866: -- Get message count and data
2867: fnd_msg_pub.count_and_get
2868: ( p_count => x_msg_count
2869: , p_data => x_msg_data
2870: );
2871: END summarizeSubElements;