DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on FND_MSG_PUB

Line 227: fnd_msg_pub.initialize;

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

Line 548: fnd_msg_pub.count_and_get(

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

Line 556: fnd_msg_pub.count_and_get(

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

Line 564: fnd_msg_pub.count_and_get(

560: WHEN fnd_api.g_exc_unexpected_error THEN
561: ROLLBACK TO get_resource_validate_pvt;
562: x_return_status := fnd_api.g_ret_sts_unexp_error;
563:
564: fnd_msg_pub.count_and_get(
565: p_count => x_msg_count
566: ,p_data => x_msg_data);
567: WHEN OTHERS THEN
568: ROLLBACK TO get_resource_validate_pvt;

Line 570: IF fnd_msg_pub.check_msg_level(

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

Line 571: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

567: WHEN OTHERS THEN
568: ROLLBACK TO get_resource_validate_pvt;
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570: IF fnd_msg_pub.check_msg_level(
571: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
572: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
573: END IF;
574:
575: fnd_msg_pub.count_and_get(

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

568: ROLLBACK TO get_resource_validate_pvt;
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570: IF fnd_msg_pub.check_msg_level(
571: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
572: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
573: END IF;
574:
575: fnd_msg_pub.count_and_get(
576: p_count => x_msg_count

Line 575: fnd_msg_pub.count_and_get(

571: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
572: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
573: END IF;
574:
575: fnd_msg_pub.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578:
579: END resource_validate;

Line 678: fnd_msg_pub.initialize;

674:
675: l_stmt_num := 30;
676: -- Initialize message list if p_init_msg_list is set to TRUE.
677: IF fnd_api.to_boolean(p_init_msg_list) THEN
678: fnd_msg_pub.initialize;
679: END IF;
680:
681: l_stmt_num := 40;
682: -- Initialize API return status to success

Line 1216: fnd_msg_pub.count_and_get(

1212: END IF;
1213:
1214: l_stmt_num := 999;
1215: -- Standard call to get message count and if count is 1, get message info.
1216: fnd_msg_pub.count_and_get(
1217: p_count => x_msg_count
1218: ,p_data => x_msg_data);
1219: EXCEPTION
1220: WHEN fnd_api.g_exc_error THEN

Line 1223: fnd_msg_pub.count_and_get(

1219: EXCEPTION
1220: WHEN fnd_api.g_exc_error THEN
1221: ROLLBACK TO get_insert_into_wcti_pvt;
1222: x_return_status := fnd_api.g_ret_sts_error;
1223: fnd_msg_pub.count_and_get(
1224: -- p_encoded => FND_API.g_false
1225: p_count => x_msg_count
1226: ,p_data => x_msg_data);
1227: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1231: fnd_msg_pub.count_and_get(

1227: WHEN fnd_api.g_exc_unexpected_error THEN
1228: ROLLBACK TO get_insert_into_wcti_pvt;
1229: x_return_status := fnd_api.g_ret_sts_unexp_error;
1230:
1231: fnd_msg_pub.count_and_get(
1232: p_count => x_msg_count
1233: ,p_data => x_msg_data);
1234: WHEN OTHERS THEN
1235: ROLLBACK TO get_insert_into_wcti_pvt;

Line 1237: IF fnd_msg_pub.check_msg_level(

1233: ,p_data => x_msg_data);
1234: WHEN OTHERS THEN
1235: ROLLBACK TO get_insert_into_wcti_pvt;
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;
1237: IF fnd_msg_pub.check_msg_level(
1238: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1240: END IF;
1241:

Line 1238: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1234: WHEN OTHERS THEN
1235: ROLLBACK TO get_insert_into_wcti_pvt;
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;
1237: IF fnd_msg_pub.check_msg_level(
1238: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1240: END IF;
1241:
1242: fnd_msg_pub.count_and_get(

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

1235: ROLLBACK TO get_insert_into_wcti_pvt;
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;
1237: IF fnd_msg_pub.check_msg_level(
1238: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1240: END IF;
1241:
1242: fnd_msg_pub.count_and_get(
1243: p_count => x_msg_count

Line 1242: fnd_msg_pub.count_and_get(

1238: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1240: END IF;
1241:
1242: fnd_msg_pub.count_and_get(
1243: p_count => x_msg_count
1244: ,p_data => x_msg_data);
1245: END insert_into_wcti;
1246:

Line 1303: fnd_msg_pub.initialize;

1299:
1300: l_stmt_num := 30;
1301: -- Initialize message list if p_init_msg_list is set to TRUE.
1302: IF fnd_api.to_boolean(p_init_msg_list) THEN
1303: fnd_msg_pub.initialize;
1304: END IF;
1305:
1306: l_stmt_num := 40;
1307: -- Initialize API return status to success

Line 1391: fnd_msg_pub.count_and_get(

1387: END IF;
1388:
1389: l_stmt_num := 999;
1390: -- Standard call to get message count and if count is 1, get message info.
1391: fnd_msg_pub.count_and_get(
1392: p_count => x_msg_count
1393: ,p_data => x_msg_data);
1394: EXCEPTION
1395: WHEN fnd_api.g_exc_error THEN

Line 1398: fnd_msg_pub.count_and_get(

1394: EXCEPTION
1395: WHEN fnd_api.g_exc_error THEN
1396: ROLLBACK TO get_insert_into_wori_pvt;
1397: x_return_status := fnd_api.g_ret_sts_error;
1398: fnd_msg_pub.count_and_get(
1399: -- p_encoded => FND_API.g_false
1400: p_count => x_msg_count
1401: ,p_data => x_msg_data);
1402: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1406: fnd_msg_pub.count_and_get(

1402: WHEN fnd_api.g_exc_unexpected_error THEN
1403: ROLLBACK TO get_insert_into_wori_pvt;
1404: x_return_status := fnd_api.g_ret_sts_unexp_error;
1405:
1406: fnd_msg_pub.count_and_get(
1407: p_count => x_msg_count
1408: ,p_data => x_msg_data);
1409: WHEN OTHERS THEN
1410: ROLLBACK TO get_insert_into_wori_pvt;

Line 1412: IF fnd_msg_pub.check_msg_level(

1408: ,p_data => x_msg_data);
1409: WHEN OTHERS THEN
1410: ROLLBACK TO get_insert_into_wori_pvt;
1411: x_return_status := fnd_api.g_ret_sts_unexp_error;
1412: IF fnd_msg_pub.check_msg_level(
1413: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1414: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1415: END IF;
1416:

Line 1413: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1409: WHEN OTHERS THEN
1410: ROLLBACK TO get_insert_into_wori_pvt;
1411: x_return_status := fnd_api.g_ret_sts_unexp_error;
1412: IF fnd_msg_pub.check_msg_level(
1413: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1414: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1415: END IF;
1416:
1417: fnd_msg_pub.count_and_get(

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

1410: ROLLBACK TO get_insert_into_wori_pvt;
1411: x_return_status := fnd_api.g_ret_sts_unexp_error;
1412: IF fnd_msg_pub.check_msg_level(
1413: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1414: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1415: END IF;
1416:
1417: fnd_msg_pub.count_and_get(
1418: p_count => x_msg_count

Line 1417: fnd_msg_pub.count_and_get(

1413: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1414: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1415: END IF;
1416:
1417: fnd_msg_pub.count_and_get(
1418: p_count => x_msg_count
1419: ,p_data => x_msg_data);
1420: END insert_into_wori;
1421:

Line 1486: fnd_msg_pub.initialize;

1482:
1483: l_stmt_num := 30;
1484: -- Initialize message list if p_init_msg_list is set to TRUE.
1485: IF fnd_api.to_boolean(p_init_msg_list) THEN
1486: fnd_msg_pub.initialize;
1487: END IF;
1488:
1489: l_stmt_num := 40;
1490: -- Initialize API return status to success

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

1797: exception
1798:
1799: when NO_DATA_FOUND then
1800:
1801: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'OSP item received');
1802:
1803: end;
1804:
1805: end if; -- end of p_rcv_txn_id not null

Line 1816: fnd_msg_pub.count_and_get(

1812: END IF;
1813:
1814: l_stmt_num := 999;
1815: -- Standard call to get message count and if count is 1, get message info.
1816: fnd_msg_pub.count_and_get(
1817: p_encoded => fnd_api.g_false
1818: ,p_count => x_msg_count
1819: ,p_data => x_msg_data);
1820:

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

1821: EXCEPTION
1822: WHEN fnd_api.g_exc_error THEN
1823: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1824: x_return_status := fnd_api.g_ret_sts_error;
1825: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1826: fnd_msg_pub.count_and_get(
1827: p_encoded => fnd_api.g_false
1828: ,p_count => x_msg_count
1829: ,p_data => x_msg_data);

Line 1826: fnd_msg_pub.count_and_get(

1822: WHEN fnd_api.g_exc_error THEN
1823: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1824: x_return_status := fnd_api.g_ret_sts_error;
1825: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1826: fnd_msg_pub.count_and_get(
1827: p_encoded => fnd_api.g_false
1828: ,p_count => x_msg_count
1829: ,p_data => x_msg_data);
1830: WHEN fnd_api.g_exc_unexpected_error THEN

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

1829: ,p_data => x_msg_data);
1830: WHEN fnd_api.g_exc_unexpected_error THEN
1831: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1832: x_return_status := fnd_api.g_ret_sts_unexp_error;
1833: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1834: fnd_msg_pub.count_and_get(
1835: p_encoded => fnd_api.g_false
1836: ,p_count => x_msg_count
1837: ,p_data => x_msg_data);

Line 1834: fnd_msg_pub.count_and_get(

1830: WHEN fnd_api.g_exc_unexpected_error THEN
1831: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1832: x_return_status := fnd_api.g_ret_sts_unexp_error;
1833: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1834: fnd_msg_pub.count_and_get(
1835: p_encoded => fnd_api.g_false
1836: ,p_count => x_msg_count
1837: ,p_data => x_msg_data);
1838: WHEN OTHERS THEN

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

1837: ,p_data => x_msg_data);
1838: WHEN OTHERS THEN
1839: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1840: x_return_status := fnd_api.g_ret_sts_unexp_error;
1841: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1842: IF fnd_msg_pub.check_msg_level(
1843: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1844: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1845: END IF;

Line 1842: IF fnd_msg_pub.check_msg_level(

1838: WHEN OTHERS THEN
1839: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1840: x_return_status := fnd_api.g_ret_sts_unexp_error;
1841: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1842: IF fnd_msg_pub.check_msg_level(
1843: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1844: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1845: END IF;
1846:

Line 1843: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1839: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1840: x_return_status := fnd_api.g_ret_sts_unexp_error;
1841: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1842: IF fnd_msg_pub.check_msg_level(
1843: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1844: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1845: END IF;
1846:
1847: fnd_msg_pub.count_and_get(

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

1840: x_return_status := fnd_api.g_ret_sts_unexp_error;
1841: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1842: IF fnd_msg_pub.check_msg_level(
1843: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1844: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1845: END IF;
1846:
1847: fnd_msg_pub.count_and_get(
1848: p_encoded => fnd_api.g_false

Line 1847: fnd_msg_pub.count_and_get(

1843: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1844: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1845: END IF;
1846:
1847: fnd_msg_pub.count_and_get(
1848: p_encoded => fnd_api.g_false
1849: ,p_count => x_msg_count
1850: ,p_data => x_msg_data);
1851: