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.GME_UPDATE_STEP_QTY_PVT dependencies on FND_API

Line 76: x_return_status := fnd_api.g_ret_sts_success;

72:
73: /* Set the savepoint before proceeding */
74: SAVEPOINT update_step_qty;
75: /* Set the return status to success initially */
76: x_return_status := fnd_api.g_ret_sts_success;
77: IF g_debug <= gme_debug.g_log_statement THEN
78: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
79: || l_api_name||'p_routing_scale_factor ' || p_routing_scale_factor);
80: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 109: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

105: (p_batch_row => l_batch_header
106: ,x_rsc_row_count => l_rec
107: ,x_return_status => l_return_status);
108:
109: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
110: RAISE fnd_api.g_exc_error;
111: END IF;
112: IF g_debug <= gme_debug.g_log_statement THEN
113: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 110: RAISE fnd_api.g_exc_error;

106: ,x_rsc_row_count => l_rec
107: ,x_return_status => l_return_status);
108:
109: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
110: RAISE fnd_api.g_exc_error;
111: END IF;
112: IF g_debug <= gme_debug.g_log_statement THEN
113: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
114: || l_api_name||': Resource transactions loaded '||l_rec);

Line 322: x_return_status := fnd_api.g_ret_sts_error;

318: END IF;
319: EXCEPTION
320: WHEN batch_step_fetch_error THEN
321: ROLLBACK TO SAVEPOINT update_step_qty;
322: x_return_status := fnd_api.g_ret_sts_error;
323: fnd_msg_pub.count_and_get (p_count => x_message_count
324: ,p_data => x_message_list);
325: WHEN invalid_step_status THEN
326: ROLLBACK TO SAVEPOINT update_step_qty;

Line 327: x_return_status := fnd_api.g_ret_sts_error;

323: fnd_msg_pub.count_and_get (p_count => x_message_count
324: ,p_data => x_message_list);
325: WHEN invalid_step_status THEN
326: ROLLBACK TO SAVEPOINT update_step_qty;
327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_EDIT');
329: fnd_msg_pub.count_and_get (p_count => x_message_count
330: ,p_data => x_message_list);
331: WHEN batch_header_fetch_error THEN

Line 333: x_return_status := fnd_api.g_ret_sts_error;

329: fnd_msg_pub.count_and_get (p_count => x_message_count
330: ,p_data => x_message_list);
331: WHEN batch_header_fetch_error THEN
332: ROLLBACK TO SAVEPOINT update_step_qty;
333: x_return_status := fnd_api.g_ret_sts_error;
334: fnd_msg_pub.count_and_get (p_count => x_message_count
335: ,p_data => x_message_list);
336: WHEN invalid_batch_status THEN
337: ROLLBACK TO SAVEPOINT update_step_qty;

Line 338: x_return_status := fnd_api.g_ret_sts_error;

334: fnd_msg_pub.count_and_get (p_count => x_message_count
335: ,p_data => x_message_list);
336: WHEN invalid_batch_status THEN
337: ROLLBACK TO SAVEPOINT update_step_qty;
338: x_return_status := fnd_api.g_ret_sts_error;
339: gme_common_pvt.log_message ('GME_API_INV_BATCH_EDIT_STEP');
340: fnd_msg_pub.count_and_get (p_count => x_message_count
341: ,p_data => x_message_list);
342: WHEN auto_step_calc_error THEN

Line 363: x_return_status := fnd_api.g_ret_sts_unexp_error;

359: || SQLERRM);
360: END IF;
361:
362: ROLLBACK TO SAVEPOINT edit_step_qty;
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
365: fnd_msg_pub.count_and_get (p_count => x_message_count
366: ,p_data => x_message_list);
367: END update_step_qty;

Line 486: x_return_status := fnd_api.g_ret_sts_success;

482: || l_api_name);
483: END IF;
484:
485: /* Set the return status to success initially */
486: x_return_status := fnd_api.g_ret_sts_success;
487:
488: -- Note the charge_diff value is only used on actuals in update activities.
489: -- If someday it is required for pending steps this value will need to be inside the if condition.
490: /* Bug 3545726 store original charges */

Line 558: x_return_status := fnd_api.g_ret_sts_error;

554: EXCEPTION
555: WHEN compute_resource_error THEN
556: x_return_status := l_return_status;
557: WHEN batch_step_upd_err OR error_calc_charge OR batch_step_fetch_err THEN
558: x_return_status := fnd_api.g_ret_sts_error;
559: WHEN OTHERS THEN
560: IF g_debug <= gme_debug.g_log_unexpected THEN
561: gme_debug.put_line ( 'When others exception in '
562: || g_pkg_name

Line 569: x_return_status := fnd_api.g_ret_sts_unexp_error;

565: || ' Error is '
566: || SQLERRM);
567: END IF;
568:
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
571: END calculate_quantities;
572:
573: /*===========================================================================================

Line 684: x_return_status := fnd_api.g_ret_sts_success;

680: || l_api_name);
681: END IF;
682:
683: /* Initialize the return status to success */
684: x_return_status := fnd_api.g_ret_sts_success;
685: x_charge := 0;
686: l_remaining_quantity := -1;
687:
688: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

Line 937: IF l_return_status <> fnd_api.g_ret_sts_success THEN

933: ,p_no_of_charges => l_charge
934: ,p_remaining_quantity => l_remaining_quantity
935: ,x_return_status => l_return_status);
936:
937: IF l_return_status <> fnd_api.g_ret_sts_success THEN
938: RAISE error_charge_insert;
939: END IF;
940: END IF; /*if l_scale_type = 1*/
941: END IF; /*if p_resource is not null*/

Line 948: x_return_status := fnd_api.g_ret_sts_error;

944: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
945: END IF;
946: EXCEPTION
947: WHEN error_step_not_found THEN
948: x_return_status := fnd_api.g_ret_sts_error;
949: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'
950: ,'STEP_ID'
951: ,p_step_id);
952: WHEN error_calc_charge_conv THEN

Line 953: -- x_return_status := FND_API.G_RET_STS_ERROR;

949: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'
950: ,'STEP_ID'
951: ,p_step_id);
952: WHEN error_calc_charge_conv THEN
953: -- x_return_status := FND_API.G_RET_STS_ERROR;
954: gme_common_pvt.log_message ('GME_CALC_CHARGE_CONV_ERROR'
955: ,'STEP_NO'
956: ,x_step_no);
957: WHEN error_max_cap_not_mass_vol THEN

Line 980: x_return_status := fnd_api.g_ret_sts_unexp_error;

976: || ' Error is '
977: || SQLERRM);
978: END IF;
979:
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
982: END calc_charge;
983:
984: /*===========================================================================================

Line 1034: x_return_status := fnd_api.g_ret_sts_success;

1030: || l_api_name);
1031: END IF;
1032:
1033: /* Initialize the return status to success */
1034: x_return_status := fnd_api.g_ret_sts_success;
1035:
1036: /* Fetch all the activities associated with the batch step */
1037: OPEN cur_step_activity_ids;
1038:

Line 1113: x_return_status := fnd_api.g_ret_sts_error;

1109: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1110: END IF;
1111: EXCEPTION
1112: WHEN step_activity_fetch_error THEN
1113: x_return_status := fnd_api.g_ret_sts_error;
1114: WHEN step_resource_upd_err THEN
1115: x_return_status := l_return_status;
1116: WHEN step_activity_upd_err THEN
1117: x_return_status := fnd_api.g_ret_sts_error;

Line 1117: x_return_status := fnd_api.g_ret_sts_error;

1113: x_return_status := fnd_api.g_ret_sts_error;
1114: WHEN step_resource_upd_err THEN
1115: x_return_status := l_return_status;
1116: WHEN step_activity_upd_err THEN
1117: x_return_status := fnd_api.g_ret_sts_error;
1118: WHEN VALUE_ERROR THEN
1119: x_return_status := fnd_api.g_ret_sts_error;
1120:
1121: IF l_gme_calc_int_rsrc_usage_char IS NOT NULL THEN

Line 1119: x_return_status := fnd_api.g_ret_sts_error;

1115: x_return_status := l_return_status;
1116: WHEN step_activity_upd_err THEN
1117: x_return_status := fnd_api.g_ret_sts_error;
1118: WHEN VALUE_ERROR THEN
1119: x_return_status := fnd_api.g_ret_sts_error;
1120:
1121: IF l_gme_calc_int_rsrc_usage_char IS NOT NULL THEN
1122: l_user_profile_option_name := gme_common_pvt.g_calc_interim_rsrc_usg_ind;
1123: /* SELECT user_profile_option_name

Line 1148: x_return_status := fnd_api.g_ret_sts_unexp_error;

1144: || ' Error is '
1145: || SQLERRM);
1146: END IF;
1147:
1148: x_return_status := fnd_api.g_ret_sts_unexp_error;
1149: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1150: END update_activities;
1151:
1152: /*===========================================================================================

Line 1247: x_return_status := fnd_api.g_ret_sts_success;

1243: || l_api_name);
1244: END IF;
1245:
1246: /* Initialize the return status to success */
1247: x_return_status := fnd_api.g_ret_sts_success;
1248:
1249: IF (p_batch_hdr_rec.batch_type = 0) THEN
1250: l_doc_type := 'PROD';
1251: ELSE

Line 1832: x_return_status := fnd_api.g_ret_sts_error;

1828: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1829: END IF;
1830: EXCEPTION
1831: WHEN activity_resource_fetch_error THEN
1832: x_return_status := fnd_api.g_ret_sts_error;
1833: WHEN resource_trans_ins_err THEN
1834: x_return_status := fnd_api.g_ret_sts_error;
1835: WHEN step_resource_upd_err THEN
1836: x_return_status := fnd_api.g_ret_sts_error;

Line 1834: x_return_status := fnd_api.g_ret_sts_error;

1830: EXCEPTION
1831: WHEN activity_resource_fetch_error THEN
1832: x_return_status := fnd_api.g_ret_sts_error;
1833: WHEN resource_trans_ins_err THEN
1834: x_return_status := fnd_api.g_ret_sts_error;
1835: WHEN step_resource_upd_err THEN
1836: x_return_status := fnd_api.g_ret_sts_error;
1837: WHEN error_fetch_rsrc_tran THEN
1838: x_return_status := l_return_status;

Line 1836: x_return_status := fnd_api.g_ret_sts_error;

1832: x_return_status := fnd_api.g_ret_sts_error;
1833: WHEN resource_trans_ins_err THEN
1834: x_return_status := fnd_api.g_ret_sts_error;
1835: WHEN step_resource_upd_err THEN
1836: x_return_status := fnd_api.g_ret_sts_error;
1837: WHEN error_fetch_rsrc_tran THEN
1838: x_return_status := l_return_status;
1839: WHEN error_txns_update THEN
1840: x_return_status := fnd_api.g_ret_sts_error;

Line 1840: x_return_status := fnd_api.g_ret_sts_error;

1836: x_return_status := fnd_api.g_ret_sts_error;
1837: WHEN error_fetch_rsrc_tran THEN
1838: x_return_status := l_return_status;
1839: WHEN error_txns_update THEN
1840: x_return_status := fnd_api.g_ret_sts_error;
1841: WHEN qty_below_cap_error THEN
1842: x_return_status := fnd_api.g_ret_sts_error;
1843: gme_common_pvt.log_message ('GME_API_RSRC_QTY_BELOW_CAP'
1844: ,'RESOURCES'

Line 1842: x_return_status := fnd_api.g_ret_sts_error;

1838: x_return_status := l_return_status;
1839: WHEN error_txns_update THEN
1840: x_return_status := fnd_api.g_ret_sts_error;
1841: WHEN qty_below_cap_error THEN
1842: x_return_status := fnd_api.g_ret_sts_error;
1843: gme_common_pvt.log_message ('GME_API_RSRC_QTY_BELOW_CAP'
1844: ,'RESOURCES'
1845: ,l_gme_batchstep_resources.resources);
1846: WHEN OTHERS THEN

Line 1856: x_return_status := fnd_api.g_ret_sts_unexp_error;

1852: || ' Error is '
1853: || SQLERRM);
1854: END IF;
1855:
1856: x_return_status := fnd_api.g_ret_sts_unexp_error;
1857: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1858: END update_resources;
1859:
1860: /*===========================================================================================

Line 1911: x_return_status := fnd_api.g_ret_sts_success;

1907: || l_api_name);
1908: END IF;
1909:
1910: /* Initialize the return status to success */
1911: x_return_status := fnd_api.g_ret_sts_success;
1912:
1913: /* Generate the surrogate key */
1914: OPEN cur_get_poc_trans_id;
1915:

Line 1998: RAISE FND_API.g_exc_error;

1994: IF NOT gme_api_grp.close_period_check_flexible
1995: (p_tran_rec => p_tran_rec,
1996: x_tran_rec => l_tran_rec_out)
1997: THEN
1998: RAISE FND_API.g_exc_error;
1999: END IF;
2000: l_ins_resource_row.trans_date := l_tran_rec_out.trans_date;
2001: */
2002:

Line 2019: x_return_status := fnd_api.g_ret_sts_error;

2015: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2016: END IF;
2017: EXCEPTION
2018: WHEN resource_trans_ins_err THEN
2019: x_return_status := fnd_api.g_ret_sts_error;
2020: WHEN fnd_api.g_exc_error THEN
2021: x_return_status := fnd_api.g_ret_sts_error;
2022: WHEN OTHERS THEN
2023: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2020: WHEN fnd_api.g_exc_error THEN

2016: END IF;
2017: EXCEPTION
2018: WHEN resource_trans_ins_err THEN
2019: x_return_status := fnd_api.g_ret_sts_error;
2020: WHEN fnd_api.g_exc_error THEN
2021: x_return_status := fnd_api.g_ret_sts_error;
2022: WHEN OTHERS THEN
2023: IF g_debug <= gme_debug.g_log_unexpected THEN
2024: gme_debug.put_line ( 'When others exception in '

Line 2021: x_return_status := fnd_api.g_ret_sts_error;

2017: EXCEPTION
2018: WHEN resource_trans_ins_err THEN
2019: x_return_status := fnd_api.g_ret_sts_error;
2020: WHEN fnd_api.g_exc_error THEN
2021: x_return_status := fnd_api.g_ret_sts_error;
2022: WHEN OTHERS THEN
2023: IF g_debug <= gme_debug.g_log_unexpected THEN
2024: gme_debug.put_line ( 'When others exception in '
2025: || g_pkg_name

Line 2032: x_return_status := fnd_api.g_ret_sts_unexp_error;

2028: || ' Error is '
2029: || SQLERRM);
2030: END IF;
2031:
2032: x_return_status := fnd_api.g_ret_sts_unexp_error;
2033: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2034: END build_insert_resource_txn;
2035:
2036: /*===========================================================================================

Line 2074: x_return_status := fnd_api.g_ret_sts_success;

2070: || l_api_name);
2071: END IF;
2072:
2073: /* Initialize return status to success */
2074: x_return_status := fnd_api.g_ret_sts_success;
2075:
2076: /* Lets get the sum of pending usages to determine if their is a change */
2077: OPEN cur_sum_usage (p_batch_step_resources_rec.batchstep_resource_id);
2078:

Line 2107: RAISE fnd_api.g_exc_error;

2103: (p_batch_step_resources_rec => p_batch_step_resources_rec
2104: ,x_return_status => l_return_status);
2105:
2106: IF l_return_status <> x_return_status THEN
2107: RAISE fnd_api.g_exc_error;
2108: END IF;
2109:
2110: l_alloc_usage :=
2111: p_batch_step_resources_rec.plan_rsrc_usage

Line 2122: RAISE fnd_api.g_exc_error;

2118: l_batch_hdr.batch_id := p_batch_step_resources_rec.batch_id;
2119:
2120: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_hdr
2121: ,x_batch_header => l_batch_hdr) THEN
2122: RAISE fnd_api.g_exc_error;
2123: END IF;
2124:
2125: FOR i IN 1 .. p_batch_step_resources_rec.plan_rsrc_count LOOP
2126: build_insert_resource_txn

Line 2134: RAISE fnd_api.g_exc_error;

2130: ,p_completed => 0
2131: ,x_return_status => l_return_status);
2132:
2133: IF l_return_status <> x_return_status THEN
2134: RAISE fnd_api.g_exc_error;
2135: END IF;
2136: END LOOP; /* FOR i IN 1..l_gme_batchstep_resources.plan_rsrc_count */
2137: END IF;
2138: /* IF (l_tot_usage <> p_batch_step_resources_rec.plan_rsrc_usage) */

Line 2140: WHEN fnd_api.g_exc_error THEN

2136: END LOOP; /* FOR i IN 1..l_gme_batchstep_resources.plan_rsrc_count */
2137: END IF;
2138: /* IF (l_tot_usage <> p_batch_step_resources_rec.plan_rsrc_usage) */
2139: EXCEPTION
2140: WHEN fnd_api.g_exc_error THEN
2141: x_return_status := fnd_api.g_ret_sts_error;
2142: WHEN OTHERS THEN
2143: IF g_debug <= gme_debug.g_log_unexpected THEN
2144: gme_debug.put_line ( 'When others exception in '

Line 2141: x_return_status := fnd_api.g_ret_sts_error;

2137: END IF;
2138: /* IF (l_tot_usage <> p_batch_step_resources_rec.plan_rsrc_usage) */
2139: EXCEPTION
2140: WHEN fnd_api.g_exc_error THEN
2141: x_return_status := fnd_api.g_ret_sts_error;
2142: WHEN OTHERS THEN
2143: IF g_debug <= gme_debug.g_log_unexpected THEN
2144: gme_debug.put_line ( 'When others exception in '
2145: || g_pkg_name

Line 2152: x_return_status := fnd_api.g_ret_sts_unexp_error;

2148: || ' Error is '
2149: || SQLERRM);
2150: END IF;
2151:
2152: x_return_status := fnd_api.g_ret_sts_unexp_error;
2153: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2154: END adjust_pending_usage;
2155:
2156: /*===========================================================================================

Line 2241: x_return_status := fnd_api.g_ret_sts_success;

2237: || l_api_name);
2238: END IF;
2239:
2240: /* Initialize return status to success */
2241: x_return_status := fnd_api.g_ret_sts_success;
2242:
2243: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2244: gme_debug.put_line ( ' Adjusting actual usage :'
2245: || p_batch_step_resources_rec.actual_rsrc_usage);

Line 2263: RAISE fnd_api.g_exc_error;

2259: ,p_calling_mode => 'ACTUAL_USAGE'
2260: ,x_return_status => l_return_status);
2261:
2262: IF l_return_status <> x_return_status THEN
2263: RAISE fnd_api.g_exc_error;
2264: END IF;
2265:
2266: /* Step 1 : */
2267: gme_update_step_qty_pvt.reduce_pending_usage

Line 2272: RAISE fnd_api.g_exc_error;

2268: (p_batch_step_resources_rec => p_batch_step_resources_rec
2269: ,x_return_status => l_return_status);
2270:
2271: IF l_return_status <> x_return_status THEN
2272: RAISE fnd_api.g_exc_error;
2273: END IF;
2274:
2275: /* Calculate the sum of the Completed Transactions */
2276: /* for this Operation detail line. */

Line 2319: RAISE fnd_api.g_exc_error;

2315:
2316: IF NOT gme_batch_header_dbl.fetch_row
2317: (p_batch_header => l_batch_hdr
2318: ,x_batch_header => l_batch_hdr) THEN
2319: RAISE fnd_api.g_exc_error;
2320: END IF;
2321:
2322: /* Step 3 : */
2323: IF (l_sum_comp_usage < p_batch_step_resources_rec.actual_rsrc_usage) THEN

Line 2340: RAISE fnd_api.g_exc_error;

2336: ,p_completed => 1
2337: ,x_return_status => l_return_status);
2338:
2339: IF l_return_status <> x_return_status THEN
2340: RAISE fnd_api.g_exc_error;
2341: END IF;
2342: END LOOP;
2343: /* FOR i IN 1..p_batch_step_resources_rec.actual_rsrc_count */
2344: ELSE

Line 2365: RAISE fnd_api.g_exc_error;

2361: (p_tran_rec => l_resource_txns
2362: ,x_return_status => l_return_status);
2363:
2364: IF l_return_status <> x_return_status THEN
2365: RAISE fnd_api.g_exc_error;
2366: END IF;
2367:
2368: -- Bug 8751983 - Let's subtract out the usage from the trans we just reversed.
2369: l_sum_comp_usage_loop := l_sum_comp_usage_loop - l_resource_txns.resource_usage;

Line 2405: RAISE fnd_api.g_exc_error;

2401: ,p_completed => 1
2402: ,p_trans_date => l_resource_tab(l_hold_trans_index).trans_date
2403: ,x_return_status => l_return_status);
2404: IF l_return_status <> x_return_status THEN
2405: RAISE fnd_api.g_exc_error;
2406: END IF;
2407: END LOOP;
2408: /* FOR i IN 1..p_batch_step_resources_rec.actual_rsrc_count */
2409: END IF;

Line 2419: WHEN fnd_api.g_exc_error THEN

2415: IF g_debug <= gme_debug.g_log_procedure THEN
2416: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2417: END IF;
2418: EXCEPTION
2419: WHEN fnd_api.g_exc_error THEN
2420: x_return_status := fnd_api.g_ret_sts_error;
2421: WHEN OTHERS THEN
2422: IF g_debug <= gme_debug.g_log_unexpected THEN
2423: gme_debug.put_line ( 'When others exception in '

Line 2420: x_return_status := fnd_api.g_ret_sts_error;

2416: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2417: END IF;
2418: EXCEPTION
2419: WHEN fnd_api.g_exc_error THEN
2420: x_return_status := fnd_api.g_ret_sts_error;
2421: WHEN OTHERS THEN
2422: IF g_debug <= gme_debug.g_log_unexpected THEN
2423: gme_debug.put_line ( 'When others exception in '
2424: || g_pkg_name

Line 2431: x_return_status := fnd_api.g_ret_sts_unexp_error;

2427: || ' Error is '
2428: || SQLERRM);
2429: END IF;
2430:
2431: x_return_status := fnd_api.g_ret_sts_unexp_error;
2432: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2433: END adjust_actual_usage;
2434:
2435: /*===========================================================================================

Line 2507: x_return_status := fnd_api.g_ret_sts_success;

2503: || l_api_name);
2504: END IF;
2505:
2506: /* Initialize return status to success */
2507: x_return_status := fnd_api.g_ret_sts_success;
2508:
2509: /* Let us check the status of the step */
2510: OPEN cur_get_step_status (p_batch_step_resources_rec.batchstep_id);
2511:

Line 2533: RAISE fnd_api.g_exc_error;

2529: ,x_resource_tbl => l_resource_tab
2530: ,x_return_status => l_return_status);
2531:
2532: IF l_return_status <> x_return_status THEN
2533: RAISE fnd_api.g_exc_error;
2534: END IF;
2535:
2536: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2537: gme_debug.put_line(g_pkg_name||'.'||l_api_name||': Line ID '||l_resource_txns.line_id);

Line 2707: RAISE fnd_api.g_exc_error;

2703: (p_tran_rec => l_resource_txns
2704: ,x_return_status => l_return_status);
2705:
2706: IF l_return_status <> x_return_status THEN
2707: RAISE fnd_api.g_exc_error;
2708: END IF;
2709: ELSIF l_step_status > gme_common_pvt.g_step_wip THEN
2710: /* If the step is certified then their shouldn't be any further pending transactions */
2711: gme_resource_engine_pvt.delete_resource_trans

Line 2716: RAISE fnd_api.g_exc_error;

2712: (p_tran_rec => l_resource_txns
2713: ,x_return_status => l_return_status);
2714:
2715: IF l_return_status <> x_return_status THEN
2716: RAISE fnd_api.g_exc_error;
2717: END IF;
2718: END IF; /* IF l_step_status = 2 */
2719: END IF; /* IF l_resource_tab(i).completed_ind = 0 */
2720: END LOOP; /* FOR i IN 1..l_resource_tab.COUNT */

Line 2726: WHEN fnd_api.g_exc_error THEN

2722: IF g_debug <= gme_debug.g_log_procedure THEN
2723: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2724: END IF;
2725: EXCEPTION
2726: WHEN fnd_api.g_exc_error THEN
2727: x_return_status := l_return_status;
2728: WHEN OTHERS THEN
2729: IF g_debug <= gme_debug.g_log_unexpected THEN
2730: gme_debug.put_line ( 'When others exception in '

Line 2738: x_return_status := fnd_api.g_ret_sts_unexp_error;

2734: || ' Error is '
2735: || SQLERRM);
2736: END IF;
2737:
2738: x_return_status := fnd_api.g_ret_sts_unexp_error;
2739: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2740: END reduce_pending_usage;
2741:
2742:

Line 2807: x_return_status := fnd_api.g_ret_sts_success;

2803: IF g_debug <= gme_debug.g_log_procedure THEN
2804: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2805: END IF;
2806:
2807: x_return_status := fnd_api.g_ret_sts_success;
2808: x_batchstep_rec := p_batchstep_rec;
2809:
2810: IF p_batchstep_rec.batchstep_id IS NULL THEN
2811: /* give error over here */

Line 2880: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2876: ,p_max_capacity => x_batchstep_rec.max_step_capacity
2877: ,x_resource => l_resource
2878: ,x_return_status => l_return_status);
2879:
2880: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2881: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2882: gme_debug.put_line('Error in calculating the max capacity');
2883: END IF;
2884: RAISE error_in_calc_capacity;

Line 2900: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2896: p_batch_id => x_batchstep_rec.batch_id
2897: ,p_batchstep_id => x_batchstep_rec.batchstep_id
2898: ,x_return_status => l_return_status);
2899:
2900: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2901: RAISE error_in_clear_charges;
2902: END IF;
2903:
2904: /*calculate mass qty and vol qty by calling routine */

Line 2932: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2928: ,p_max_capacity => x_batchstep_rec.max_step_capacity
2929: ,x_charge => l_charge
2930: ,x_return_status => l_return_status);
2931:
2932: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2933: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2934: gme_debug.put_line('error in calc_charge');
2935: END IF;
2936: RAISE error_calc_charge;

Line 2955: x_return_status := fnd_api.g_ret_sts_error;

2951: gme_debug.put_line ('Existing api ' || g_pkg_name || '.'|| l_api_name);
2952: END IF;
2953: EXCEPTION
2954: WHEN error_batchstep_id OR error_in_calc_capacity OR error_in_clear_charges THEN
2955: x_return_status := fnd_api.g_ret_sts_error;
2956: WHEN OTHERS THEN
2957: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2958: gme_debug.put_line(g_pkg_name || '.'|| l_api_name --> when others '
2959: || SQLERRM);

Line 2961: x_return_status := fnd_api.g_ret_sts_unexp_error;

2957: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2958: gme_debug.put_line(g_pkg_name || '.'|| l_api_name --> when others '
2959: || SQLERRM);
2960: END IF;
2961: x_return_status := fnd_api.g_ret_sts_unexp_error;
2962: END recalculate_charges;
2963:
2964: END gme_update_step_qty_pvt;