869:
870:
871: -- Initialize message list.
872: IF fnd_api.to_boolean(p_init_msg_lst) THEN
873: fnd_msg_pub.initialize;
874: END IF;
875:
876: INV_QUANTITY_TREE_PVT.create_tree
877: ( p_api_version_number => 1.0
1017: WHEN fnd_api.g_exc_error THEN
1018: x_return_status := fnd_api.g_ret_sts_error;
1019:
1020: -- Get message count and data
1021: fnd_msg_pub.count_and_get
1022: ( p_count => x_msg_count
1023: , p_data => x_msg_data
1024: );
1025:
1026: WHEN fnd_api.g_exc_unexpected_error THEN
1027: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1028:
1029: -- Get message count and data
1030: fnd_msg_pub.count_and_get
1031: ( p_count => x_msg_count
1032: , p_data => x_msg_data
1033: );
1034:
1034:
1035: WHEN OTHERS THEN
1036: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1037:
1038: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1039: THEN
1040:
1041: fnd_msg_pub.add_exc_msg
1042: ( g_pkg_name
1037:
1038: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1039: THEN
1040:
1041: fnd_msg_pub.add_exc_msg
1042: ( g_pkg_name
1043: , l_api_name
1044: );
1045: END IF;
1044: );
1045: END IF;
1046:
1047: -- Get message count and data
1048: fnd_msg_pub.count_and_get
1049: ( p_count => x_msg_count
1050: , p_data => x_msg_data
1051: );
1052:
1212:
1213:
1214: -- Initialize message list.
1215: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1216: fnd_msg_pub.initialize;
1217: END IF;
1218:
1219: INV_QUANTITY_TREE_PVT.create_tree
1220: ( p_api_version_number => 1.0
1360: WHEN fnd_api.g_exc_error THEN
1361: x_return_status := fnd_api.g_ret_sts_error;
1362:
1363: -- Get message count and data
1364: fnd_msg_pub.count_and_get
1365: ( p_count => x_msg_count
1366: , p_data => x_msg_data
1367: );
1368:
1369: WHEN fnd_api.g_exc_unexpected_error THEN
1370: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1371:
1372: -- Get message count and data
1373: fnd_msg_pub.count_and_get
1374: ( p_count => x_msg_count
1375: , p_data => x_msg_data
1376: );
1377:
1377:
1378: WHEN OTHERS THEN
1379: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1380:
1381: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1382: THEN
1383:
1384: fnd_msg_pub.add_exc_msg
1385: ( g_pkg_name
1380:
1381: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1382: THEN
1383:
1384: fnd_msg_pub.add_exc_msg
1385: ( g_pkg_name
1386: , l_api_name
1387: );
1388: END IF;
1387: );
1388: END IF;
1389:
1390: -- Get message count and data
1391: fnd_msg_pub.count_and_get
1392: ( p_count => x_msg_count
1393: , p_data => x_msg_data
1394: );
1395:
1620: END IF;
1621:
1622: -- Initialize message list.
1623: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1624: fnd_msg_pub.initialize;
1625: END IF;
1626:
1627: p_ok_to_process := 'false';
1628:
1863: WHEN fnd_api.g_exc_error THEN
1864: x_return_status := fnd_api.g_ret_sts_error;
1865:
1866: -- Get message count and data
1867: fnd_msg_pub.count_and_get
1868: ( p_count => x_msg_count
1869: , p_data => x_msg_data
1870: );
1871: IF (l_debug = 1) THEN
1875: WHEN fnd_api.g_exc_unexpected_error THEN
1876: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1877:
1878: -- Get message count and data
1879: fnd_msg_pub.count_and_get
1880: ( p_count => x_msg_count
1881: , p_data => x_msg_data
1882: );
1883: IF (l_debug = 1) THEN
1886:
1887: WHEN OTHERS THEN
1888: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1889:
1890: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1891: THEN
1892: fnd_msg_pub.add_exc_msg
1893: ( g_pkg_name
1894: , l_api_name
1888: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1889:
1890: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1891: THEN
1892: fnd_msg_pub.add_exc_msg
1893: ( g_pkg_name
1894: , l_api_name
1895: );
1896: END IF;
1895: );
1896: END IF;
1897:
1898: -- Get message count and data
1899: fnd_msg_pub.count_and_get
1900: ( p_count => x_msg_count
1901: , p_data => x_msg_data
1902: );
1903: IF (l_debug = 1) THEN
4438: END IF;
4439:
4440: -- Initialize message list.
4441: IF fnd_api.to_boolean(p_init_msg_lst) THEN
4442: fnd_msg_pub.initialize;
4443: END IF;
4444:
4445: p_ok_to_process := 'false';
4446:
4715: END IF;
4716:
4717: -- Initialize message list.
4718: IF fnd_api.to_boolean(p_init_msg_lst) THEN
4719: fnd_msg_pub.initialize;
4720: END IF;
4721:
4722: -- Clearing any cache if existent
4723: inv_quantity_tree_grp.clear_quantity_cache ;
4774: WHEN fnd_api.g_exc_error THEN
4775: x_return_status := fnd_api.g_ret_sts_error;
4776:
4777: -- Get message count and data
4778: fnd_msg_pub.count_and_get
4779: ( p_count => l_msg_count
4780: , p_data => l_msg_data
4781: );
4782:
4783: WHEN fnd_api.g_exc_unexpected_error THEN
4784: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4785:
4786: -- Get message count and data
4787: fnd_msg_pub.count_and_get
4788: ( p_count => l_msg_count
4789: , p_data => l_msg_data
4790: );
4791:
4791:
4792: WHEN OTHERS THEN
4793: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4794:
4795: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4796: THEN
4797:
4798: fnd_msg_pub.add_exc_msg
4799: ( g_pkg_name
4794:
4795: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4796: THEN
4797:
4798: fnd_msg_pub.add_exc_msg
4799: ( g_pkg_name
4800: , l_api_name
4801: );
4802: END IF;
4801: );
4802: END IF;
4803:
4804: -- Get message count and data
4805: fnd_msg_pub.count_and_get
4806: ( p_count => l_msg_count
4807: , p_data => l_msg_data
4808: );
4809: