DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on FND_MSG_PUB

Line 223: fnd_msg_pub.initialize;

219:
220: l_stmt_num := 30;
221: -- Initialize message list if p_init_msg_list is set to TRUE.
222: IF fnd_api.to_boolean(p_init_msg_list) THEN
223: fnd_msg_pub.initialize;
224: END IF;
225:
226: l_stmt_num := 40;
227: -- Initialize API return status to success

Line 544: fnd_msg_pub.count_and_get(

540: END IF;
541:
542: l_stmt_num := 999;
543: -- Standard call to get message count and if count is 1, get message info.
544: fnd_msg_pub.count_and_get(
545: p_count => x_msg_count
546: ,p_data => x_msg_data);
547: EXCEPTION
548: WHEN fnd_api.g_exc_error THEN

Line 552: fnd_msg_pub.count_and_get(

548: WHEN fnd_api.g_exc_error THEN
549: ROLLBACK TO get_resource_validate_pvt
550: ;
551: x_return_status := fnd_api.g_ret_sts_error;
552: fnd_msg_pub.count_and_get(
553: -- p_encoded => FND_API.g_false
554: p_count => x_msg_count
555: ,p_data => x_msg_data);
556: WHEN fnd_api.g_exc_unexpected_error THEN

Line 560: fnd_msg_pub.count_and_get(

556: WHEN fnd_api.g_exc_unexpected_error THEN
557: ROLLBACK TO get_resource_validate_pvt;
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559:
560: fnd_msg_pub.count_and_get(
561: p_count => x_msg_count
562: ,p_data => x_msg_data);
563: WHEN OTHERS THEN
564: ROLLBACK TO get_resource_validate_pvt;

Line 566: IF fnd_msg_pub.check_msg_level(

562: ,p_data => x_msg_data);
563: WHEN OTHERS THEN
564: ROLLBACK TO get_resource_validate_pvt;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: IF fnd_msg_pub.check_msg_level(
567: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570:

Line 567: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

563: WHEN OTHERS THEN
564: ROLLBACK TO get_resource_validate_pvt;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: IF fnd_msg_pub.check_msg_level(
567: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570:
571: fnd_msg_pub.count_and_get(

Line 568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

564: ROLLBACK TO get_resource_validate_pvt;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: IF fnd_msg_pub.check_msg_level(
567: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570:
571: fnd_msg_pub.count_and_get(
572: p_count => x_msg_count

Line 571: fnd_msg_pub.count_and_get(

567: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570:
571: fnd_msg_pub.count_and_get(
572: p_count => x_msg_count
573: ,p_data => x_msg_data);
574:
575: END resource_validate;

Line 710: fnd_msg_pub.initialize;

706:
707: l_stmt_num := 30;
708: -- Initialize message list if p_init_msg_list is set to TRUE.
709: IF fnd_api.to_boolean(p_init_msg_list) THEN
710: fnd_msg_pub.initialize;
711: END IF;
712:
713: l_stmt_num := 40;
714: -- Initialize API return status to success

Line 775: FND_MSG_PUB.Add;

771:
772: IF l_project_task_chargeable <> 'Y' THEN
773:
774: FND_MESSAGE.SET_NAME('EAM','EAM_RES_TXN_PJM_TASK_N_CHARGE');
775: FND_MSG_PUB.Add;
776: RAISE FND_API.G_EXC_ERROR;
777:
778: END IF ;
779:

Line 1285: fnd_msg_pub.count_and_get(

1281: END IF;
1282:
1283: l_stmt_num := 999;
1284: -- Standard call to get message count and if count is 1, get message info.
1285: fnd_msg_pub.count_and_get(
1286: p_count => x_msg_count
1287: ,p_data => x_msg_data);
1288: EXCEPTION
1289: WHEN fnd_api.g_exc_error THEN

Line 1292: fnd_msg_pub.count_and_get(

1288: EXCEPTION
1289: WHEN fnd_api.g_exc_error THEN
1290: ROLLBACK TO get_insert_into_wcti_pvt;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_msg_pub.count_and_get(
1293: -- p_encoded => FND_API.g_false
1294: p_count => x_msg_count
1295: ,p_data => x_msg_data);
1296: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1300: fnd_msg_pub.count_and_get(

1296: WHEN fnd_api.g_exc_unexpected_error THEN
1297: ROLLBACK TO get_insert_into_wcti_pvt;
1298: x_return_status := fnd_api.g_ret_sts_unexp_error;
1299:
1300: fnd_msg_pub.count_and_get(
1301: p_count => x_msg_count
1302: ,p_data => x_msg_data);
1303: WHEN OTHERS THEN
1304: ROLLBACK TO get_insert_into_wcti_pvt;

Line 1306: IF fnd_msg_pub.check_msg_level(

1302: ,p_data => x_msg_data);
1303: WHEN OTHERS THEN
1304: ROLLBACK TO get_insert_into_wcti_pvt;
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306: IF fnd_msg_pub.check_msg_level(
1307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1309: END IF;
1310:

Line 1307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1303: WHEN OTHERS THEN
1304: ROLLBACK TO get_insert_into_wcti_pvt;
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306: IF fnd_msg_pub.check_msg_level(
1307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1309: END IF;
1310:
1311: fnd_msg_pub.count_and_get(

Line 1308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1304: ROLLBACK TO get_insert_into_wcti_pvt;
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306: IF fnd_msg_pub.check_msg_level(
1307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1309: END IF;
1310:
1311: fnd_msg_pub.count_and_get(
1312: p_count => x_msg_count

Line 1311: fnd_msg_pub.count_and_get(

1307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1309: END IF;
1310:
1311: fnd_msg_pub.count_and_get(
1312: p_count => x_msg_count
1313: ,p_data => x_msg_data);
1314: END insert_into_wcti;
1315:

Line 1372: fnd_msg_pub.initialize;

1368:
1369: l_stmt_num := 30;
1370: -- Initialize message list if p_init_msg_list is set to TRUE.
1371: IF fnd_api.to_boolean(p_init_msg_list) THEN
1372: fnd_msg_pub.initialize;
1373: END IF;
1374:
1375: l_stmt_num := 40;
1376: -- Initialize API return status to success

Line 1460: fnd_msg_pub.count_and_get(

1456: END IF;
1457:
1458: l_stmt_num := 999;
1459: -- Standard call to get message count and if count is 1, get message info.
1460: fnd_msg_pub.count_and_get(
1461: p_count => x_msg_count
1462: ,p_data => x_msg_data);
1463: EXCEPTION
1464: WHEN fnd_api.g_exc_error THEN

Line 1467: fnd_msg_pub.count_and_get(

1463: EXCEPTION
1464: WHEN fnd_api.g_exc_error THEN
1465: ROLLBACK TO get_insert_into_wori_pvt;
1466: x_return_status := fnd_api.g_ret_sts_error;
1467: fnd_msg_pub.count_and_get(
1468: -- p_encoded => FND_API.g_false
1469: p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1475: fnd_msg_pub.count_and_get(

1471: WHEN fnd_api.g_exc_unexpected_error THEN
1472: ROLLBACK TO get_insert_into_wori_pvt;
1473: x_return_status := fnd_api.g_ret_sts_unexp_error;
1474:
1475: fnd_msg_pub.count_and_get(
1476: p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: WHEN OTHERS THEN
1479: ROLLBACK TO get_insert_into_wori_pvt;

Line 1481: IF fnd_msg_pub.check_msg_level(

1477: ,p_data => x_msg_data);
1478: WHEN OTHERS THEN
1479: ROLLBACK TO get_insert_into_wori_pvt;
1480: x_return_status := fnd_api.g_ret_sts_unexp_error;
1481: IF fnd_msg_pub.check_msg_level(
1482: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1483: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1484: END IF;
1485:

Line 1482: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1478: WHEN OTHERS THEN
1479: ROLLBACK TO get_insert_into_wori_pvt;
1480: x_return_status := fnd_api.g_ret_sts_unexp_error;
1481: IF fnd_msg_pub.check_msg_level(
1482: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1483: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1484: END IF;
1485:
1486: fnd_msg_pub.count_and_get(

Line 1483: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1479: ROLLBACK TO get_insert_into_wori_pvt;
1480: x_return_status := fnd_api.g_ret_sts_unexp_error;
1481: IF fnd_msg_pub.check_msg_level(
1482: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1483: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1484: END IF;
1485:
1486: fnd_msg_pub.count_and_get(
1487: p_count => x_msg_count

Line 1486: fnd_msg_pub.count_and_get(

1482: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1483: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1484: END IF;
1485:
1486: fnd_msg_pub.count_and_get(
1487: p_count => x_msg_count
1488: ,p_data => x_msg_data);
1489: END insert_into_wori;
1490:

Line 1555: fnd_msg_pub.initialize;

1551:
1552: l_stmt_num := 30;
1553: -- Initialize message list if p_init_msg_list is set to TRUE.
1554: IF fnd_api.to_boolean(p_init_msg_list) THEN
1555: fnd_msg_pub.initialize;
1556: END IF;
1557:
1558: l_stmt_num := 40;
1559: -- Initialize API return status to success

Line 1869: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'OSP item received');

1865: exception
1866:
1867: when NO_DATA_FOUND then
1868:
1869: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'OSP item received');
1870:
1871: end;
1872:
1873: end if; -- end of p_rcv_txn_id not null

Line 1884: fnd_msg_pub.count_and_get(

1880: END IF;
1881:
1882: l_stmt_num := 999;
1883: -- Standard call to get message count and if count is 1, get message info.
1884: fnd_msg_pub.count_and_get(
1885: p_encoded => fnd_api.g_false
1886: ,p_count => x_msg_count
1887: ,p_data => x_msg_data);
1888:

Line 1893: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

1889: EXCEPTION
1890: WHEN fnd_api.g_exc_error THEN
1891: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1892: x_return_status := fnd_api.g_ret_sts_error;
1893: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1894: fnd_msg_pub.count_and_get(
1895: p_encoded => fnd_api.g_false
1896: ,p_count => x_msg_count
1897: ,p_data => x_msg_data);

Line 1894: fnd_msg_pub.count_and_get(

1890: WHEN fnd_api.g_exc_error THEN
1891: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1892: x_return_status := fnd_api.g_ret_sts_error;
1893: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1894: fnd_msg_pub.count_and_get(
1895: p_encoded => fnd_api.g_false
1896: ,p_count => x_msg_count
1897: ,p_data => x_msg_data);
1898: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

1897: ,p_data => x_msg_data);
1898: WHEN fnd_api.g_exc_unexpected_error THEN
1899: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1900: x_return_status := fnd_api.g_ret_sts_unexp_error;
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1902: fnd_msg_pub.count_and_get(
1903: p_encoded => fnd_api.g_false
1904: ,p_count => x_msg_count
1905: ,p_data => x_msg_data);

Line 1902: fnd_msg_pub.count_and_get(

1898: WHEN fnd_api.g_exc_unexpected_error THEN
1899: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1900: x_return_status := fnd_api.g_ret_sts_unexp_error;
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1902: fnd_msg_pub.count_and_get(
1903: p_encoded => fnd_api.g_false
1904: ,p_count => x_msg_count
1905: ,p_data => x_msg_data);
1906: WHEN OTHERS THEN

Line 1909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

1905: ,p_data => x_msg_data);
1906: WHEN OTHERS THEN
1907: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1910: IF fnd_msg_pub.check_msg_level(
1911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1913: END IF;

Line 1910: IF fnd_msg_pub.check_msg_level(

1906: WHEN OTHERS THEN
1907: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1910: IF fnd_msg_pub.check_msg_level(
1911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1913: END IF;
1914:

Line 1911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1907: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1910: IF fnd_msg_pub.check_msg_level(
1911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1913: END IF;
1914:
1915: fnd_msg_pub.count_and_get(

Line 1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1910: IF fnd_msg_pub.check_msg_level(
1911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1913: END IF;
1914:
1915: fnd_msg_pub.count_and_get(
1916: p_encoded => fnd_api.g_false

Line 1915: fnd_msg_pub.count_and_get(

1911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1913: END IF;
1914:
1915: fnd_msg_pub.count_and_get(
1916: p_encoded => fnd_api.g_false
1917: ,p_count => x_msg_count
1918: ,p_data => x_msg_data);
1919: