242: rollback;
243: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
244: x_return_status := fnd_api.g_ret_sts_error ;
245: -- Get message count and data
246: fnd_msg_pub.count_and_get
247: ( p_count => l_msg_count
248: , p_data => l_msg_data
249: );
250:
265: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
266: x_return_status := fnd_api.g_ret_sts_error ;
267:
268: -- Get message count and data
269: fnd_msg_pub.count_and_get
270: ( p_count => l_msg_count
271: , p_data => l_msg_data
272: );
273:
634: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
635: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
636: x_return_status := fnd_api.g_ret_sts_error ;
637: -- Get message count and data
638: fnd_msg_pub.count_and_get
639: ( p_count => l_msg_count
640: , p_data => l_msg_data
641: );
642:
661: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
662:
663: x_return_status := fnd_api.g_ret_sts_error ;
664: -- Get message count and data
665: fnd_msg_pub.count_and_get
666: ( p_count => l_msg_count
667: , p_data => l_msg_data
668: );
669:
937:
938: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
939: x_return_status := fnd_api.g_ret_sts_error ;
940: -- Get message count and data
941: fnd_msg_pub.count_and_get
942: ( p_count => l_msg_count
943: , p_data => l_msg_data
944: );
945:
964: x_return_status := fnd_api.g_ret_sts_error ;
965:
966:
967: -- Get message count and data
968: fnd_msg_pub.count_and_get
969: ( p_count => l_msg_count
970: , p_data => l_msg_data
971: );
972:
1225: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1226:
1227: x_return_status := fnd_api.g_ret_sts_error ;
1228: -- Get message count and data
1229: fnd_msg_pub.count_and_get
1230: ( p_count => l_msg_count
1231: , p_data => l_msg_data
1232: );
1233:
1250:
1251: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1252: x_return_status := fnd_api.g_ret_sts_error ;
1253: -- Get message count and data
1254: fnd_msg_pub.count_and_get
1255: ( p_count => l_msg_count
1256: , p_data => l_msg_data
1257: );
1258:
1767: if(acct_cursor%isopen) then CLOSE acct_cursor; end if;
1768: x_return_status := fnd_api.g_ret_sts_error ;
1769:
1770: -- Get message count and data
1771: fnd_msg_pub.count_and_get
1772: ( p_count => l_msg_count
1773: , p_data => l_msg_data
1774: );
1775:
1794: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;
1795: if(acct_cursor%isopen) then CLOSE acct_cursor; end if;
1796: x_return_status := fnd_api.g_ret_sts_error ;
1797: -- Get message count and data
1798: fnd_msg_pub.count_and_get
1799: ( p_count => l_msg_count
1800: , p_data => l_msg_data
1801: );
1802:
2193: IF(mcce_cursor%isopen) THEN CLOSE mcce_cursor; END IF;
2194:
2195: x_return_status := fnd_api.g_ret_sts_error ;
2196: -- Get message count and data
2197: fnd_msg_pub.count_and_get
2198: ( p_count => l_msg_count
2199: , p_data => l_msg_data
2200: );
2201:
2218:
2219: IF(mcce_cursor%isopen) THEN CLOSE mcce_cursor; END IF;
2220: x_return_status := fnd_api.g_ret_sts_error ;
2221: -- Get message count and data
2222: fnd_msg_pub.count_and_get
2223: ( p_count => l_msg_count
2224: , p_data => l_msg_data
2225: );
2226:
2482: IF(mpa_cursor%isopen) THEN CLOSE mpa_cursor; END IF;
2483:
2484: x_return_status := fnd_api.g_ret_sts_error ;
2485: -- Get message count and data
2486: fnd_msg_pub.count_and_get
2487: ( p_count => l_msg_count
2488: , p_data => l_msg_data
2489: );
2490:
2507:
2508: IF(mpa_cursor%isopen) THEN CLOSE mpa_cursor; END IF;
2509: x_return_status := fnd_api.g_ret_sts_error ;
2510: -- Get message count and data
2511: fnd_msg_pub.count_and_get
2512: ( p_count => l_msg_count
2513: , p_data => l_msg_data
2514: );
2515:
2769: IF(mpit_cursor%isopen) THEN CLOSE mpit_cursor; END IF;
2770:
2771: x_return_status := fnd_api.g_ret_sts_error ;
2772: -- Get message count and data
2773: fnd_msg_pub.count_and_get
2774: ( p_count => l_msg_count
2775: , p_data => l_msg_data
2776: );
2777:
2794:
2795: IF(mpit_cursor%isopen) THEN CLOSE mpit_cursor; END IF;
2796: x_return_status := fnd_api.g_ret_sts_error ;
2797: -- Get message count and data
2798: fnd_msg_pub.count_and_get
2799: ( p_count => l_msg_count
2800: , p_data => l_msg_data
2801: );
2802: