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_CREATE_STEP_PVT dependencies on FND_API

Line 18: DEFAULT fnd_api.g_true

14: ,p_use_workday_cal IN VARCHAR2
15: ,p_contiguity_override IN VARCHAR2
16: ,x_return_status OUT NOCOPY VARCHAR2
17: ,p_ignore_qty_below_cap IN VARCHAR2
18: DEFAULT fnd_api.g_true
19: ,p_step_start_date IN DATE := NULL
20: ,p_step_cmplt_date IN DATE := NULL
21: ,p_step_due_date IN DATE := NULL)
22: IS

Line 192: x_return_status := fnd_api.g_ret_sts_success;

188: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
189: gme_debug.put_line ('BEGIN Create_step');
190: END IF;
191:
192: x_return_status := fnd_api.g_ret_sts_success;
193: l_batch_id := p_gme_batch_header_rec.batch_id;
194:
195: IF (p_gme_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN
196: l_doc_type := 'PROD';

Line 330: IF l_return_status <> FND_API.g_ret_sts_success THEN

326: gme_validate_flex_fld_pvt.create_flex_batch_step (
327: l_gme_batch_steps (j),
328: l_gme_batch_steps (j),
329: l_return_status);
330: IF l_return_status <> FND_API.g_ret_sts_success THEN
331: RAISE create_flex_failure;
332: END IF;
333: --FPBug#4395561 End
334:

Line 463: IF l_return_status <> FND_API.g_ret_sts_success THEN

459: gme_validate_flex_fld_pvt.create_flex_step_activities (
460: l_gme_batch_step_activities (j),
461: l_gme_batch_step_activities (j),
462: l_return_status);
463: IF l_return_status <> FND_API.g_ret_sts_success THEN
464: RAISE create_flex_failure;
465: END IF;
466: --FPBug#4395561 End
467:

Line 650: IF l_return_status <> FND_API.g_ret_sts_success THEN

646: gme_validate_flex_fld_pvt.create_flex_step_resources (
647: l_gme_batch_step_resources (j),
648: l_gme_batch_step_resources (j),
649: l_return_status);
650: IF l_return_status <> FND_API.g_ret_sts_success THEN
651: RAISE create_flex_failure;
652: END IF;
653: --FPBug#4395561 End
654:

Line 734: IF l_return_status <> FND_API.g_ret_sts_success THEN

730: gme_validate_flex_fld_pvt.create_flex_process_param (
731: l_gme_rsrc_parameters (m),
732: l_gme_rsrc_parameters (m),
733: l_return_status);
734: IF l_return_status <> FND_API.g_ret_sts_success THEN
735: RAISE create_flex_failure;
736: END IF;
737: --FPBug#4395561 End
738:

Line 998: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );

994:
995: IF l_return_status <> x_return_status THEN
996: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
997: gme_debug.put_line
998: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
999: END IF;
1000:
1001: RAISE error_calc_step_qty;
1002: END IF;

Line 1296: IF (p_ignore_qty_below_cap = fnd_api.g_false) THEN

1292: CLOSE cur_get_activities;
1293: END IF;
1294:
1295: /* Lets check if any of the resource quantities are falling below the min capacity */
1296: IF (p_ignore_qty_below_cap = fnd_api.g_false) THEN
1297: IF gme_common_pvt.resource_qty_below_capacity
1298: (p_batch_id => l_batch_id) THEN
1299: RAISE process_qty_below_cap;
1300: END IF;

Line 1530: x_return_status := fnd_api.g_ret_sts_error;

1526: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1527: gme_debug.put_line ('insert batch step error');
1528: END IF;
1529:
1530: x_return_status := fnd_api.g_ret_sts_error;
1531: WHEN error_insert_b_step_act THEN
1532: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1533: gme_debug.put_line ('insert batch step activity error');
1534: END IF;

Line 1536: x_return_status := fnd_api.g_ret_sts_error;

1532: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1533: gme_debug.put_line ('insert batch step activity error');
1534: END IF;
1535:
1536: x_return_status := fnd_api.g_ret_sts_error;
1537: WHEN error_insert_b_step_res THEN
1538: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1539: gme_debug.put_line ('insert batch step resource error');
1540: END IF;

Line 1542: x_return_status := fnd_api.g_ret_sts_error;

1538: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1539: gme_debug.put_line ('insert batch step resource error');
1540: END IF;
1541:
1542: x_return_status := fnd_api.g_ret_sts_error;
1543: WHEN error_insert_res_txns THEN
1544: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1545: gme_debug.put_line ('insert resource txns error');
1546: END IF;

Line 1548: x_return_status := fnd_api.g_ret_sts_error;

1544: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1545: gme_debug.put_line ('insert resource txns error');
1546: END IF;
1547:
1548: x_return_status := fnd_api.g_ret_sts_error;
1549: WHEN error_insert_b_res_param THEN
1550: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1551: gme_debug.put_line ('insert resource param error');
1552: END IF;

Line 1554: x_return_status := fnd_api.g_ret_sts_error;

1550: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1551: gme_debug.put_line ('insert resource param error');
1552: END IF;
1553:
1554: x_return_status := fnd_api.g_ret_sts_error;
1555: WHEN error_insert_b_step_items THEN
1556: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1557: gme_debug.put_line ('insert batch step items error');
1558: END IF;

Line 1560: x_return_status := fnd_api.g_ret_sts_error;

1556: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1557: gme_debug.put_line ('insert batch step items error');
1558: END IF;
1559:
1560: x_return_status := fnd_api.g_ret_sts_error;
1561: WHEN error_insert_b_step_depend THEN
1562: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1563: gme_debug.put_line ('insert batch step depend error');
1564: END IF;

Line 1566: x_return_status := fnd_api.g_ret_sts_error;

1562: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1563: gme_debug.put_line ('insert batch step depend error');
1564: END IF;
1565:
1566: x_return_status := fnd_api.g_ret_sts_error;
1567: WHEN error_calc_step_qty THEN
1568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1569: gme_debug.put_line ('calc step qty error');
1570: END IF;

Line 1572: x_return_status := fnd_api.g_ret_sts_error;

1568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1569: gme_debug.put_line ('calc step qty error');
1570: END IF;
1571:
1572: x_return_status := fnd_api.g_ret_sts_error;
1573: WHEN error_calc_dates THEN
1574: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1575: gme_debug.put_line ('calc dates error');
1576: END IF;

Line 1584: x_return_status := fnd_api.g_ret_sts_error;

1580: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1581: gme_debug.put_line ('calc charge error');
1582: END IF;
1583:
1584: x_return_status := fnd_api.g_ret_sts_error;
1585: WHEN error_create_text THEN
1586: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1587: gme_debug.put_line ('create text error');
1588: END IF;

Line 1596: x_return_status := fnd_api.g_ret_sts_error;

1592: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1593: gme_debug.put_line ('process qty below capacity');
1594: END IF;
1595:
1596: x_return_status := fnd_api.g_ret_sts_error;
1597: WHEN invalid_resource_qty_usage THEN
1598: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1599: gme_debug.put_line
1600: ('invalild resource process quantity and usage');

Line 1602: x_return_status := fnd_api.g_ret_sts_error;

1598: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1599: gme_debug.put_line
1600: ('invalild resource process quantity and usage');
1601: END IF;
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: WHEN error_truncate_date THEN
1604: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1605: gme_debug.put_line ('truncate date procedure error');
1606: END IF;

Line 1608: x_return_status := fnd_api.g_ret_sts_error;

1604: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1605: gme_debug.put_line ('truncate date procedure error');
1606: END IF;
1607:
1608: x_return_status := fnd_api.g_ret_sts_error;
1609: --FPBug#4395561
1610: WHEN create_flex_failure THEN
1611: x_return_status := l_return_status;
1612: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

Line 1626: x_return_status := fnd_api.g_ret_sts_unexp_error;

1622: || SQLERRM);
1623: END IF;
1624:
1625: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1626: x_return_status := fnd_api.g_ret_sts_unexp_error;
1627: END create_batch_steps;
1628:
1629: PROCEDURE update_charges (
1630: p_batch_id IN NUMBER

Line 1656: x_return_status := fnd_api.g_ret_sts_success;

1652: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1653: || l_api_name);
1654: END IF;
1655:
1656: x_return_status := fnd_api.g_ret_sts_success;
1657: x_num_steps := 0;
1658:
1659: OPEN cur_get_steps (p_batch_id);
1660:

Line 1692: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1688: ( ' update charges >calc charges >batchstep_id '
1689: || TO_CHAR (x_cur_step_rec.batchstep_id) );
1690: END IF;
1691:
1692: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1693: RAISE error_calc_charge;
1694: END IF;
1695:
1696: x_num_steps := x_num_steps + 1;

Line 1727: x_return_status := fnd_api.g_ret_sts_unexp_error;

1723: || SQLERRM);
1724: END IF;
1725:
1726: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1727: x_return_status := fnd_api.g_ret_sts_unexp_error;
1728: END update_charges;
1729:
1730: /*======================================================================
1731: -- FUNCTION :

Line 1784: IF p_use_workday_cal = fnd_api.g_true THEN

1780: END IF;
1781:
1782: l_max_date := NULL;
1783:
1784: IF p_use_workday_cal = fnd_api.g_true THEN
1785: FOR rec IN cur_get_step_date_4_cal (p_batchstep_id, p_batch_id) LOOP
1786: IF rec.dep_type = 1 THEN
1787: l_date := rec.plan_start_date;
1788: ELSE

Line 1805: ELSE /* p_use_workday_cal = FND_API.G_TRUE */

1801: IF l_max_date IS NULL OR l_max_date < l_plan_start_date THEN
1802: l_max_date := l_plan_start_date;
1803: END IF;
1804: END LOOP;
1805: ELSE /* p_use_workday_cal = FND_API.G_TRUE */
1806: OPEN cur_get_step_date (p_batchstep_id, p_batch_id);
1807:
1808: FETCH cur_get_step_date
1809: INTO l_date;

Line 1826: END IF; /* p_use_workday_cal = FND_API.G_TRUE */

1822: END IF;
1823: END IF;
1824:
1825: CLOSE cur_get_step_date;
1826: END IF; /* p_use_workday_cal = FND_API.G_TRUE */
1827:
1828: IF l_max_date IS NULL THEN
1829: l_max_date := p_batch_start_date;
1830: END IF;

Line 2159: p_return_status := fnd_api.g_ret_sts_success;

2155: gme_debug.put_line ('p_use_workday_cal is '||p_use_workday_cal); -- Bug 13582990
2156: gme_debug.put_line ('p_contiguity_override is '||p_contiguity_override); -- Bug 13582990
2157: END IF;
2158:
2159: p_return_status := fnd_api.g_ret_sts_success;
2160: l_batch_id := p_gme_batch_header_rec.batch_id;
2161:
2162: IF (p_gme_batch_header_rec.batch_type = 0) THEN
2163: l_doc_type := 'PROD';

Line 2177: l_use_workday_cal := fnd_api.g_false;

2173:
2174: l_calendar_code := gme_common_pvt.g_calendar_code;
2175:
2176: IF l_calendar_code IS NULL THEN
2177: l_use_workday_cal := fnd_api.g_false;
2178: ELSE
2179: OPEN cur_recipe_validity_rule
2180: (p_gme_batch_header_rec.recipe_validity_rule_id);
2181:

Line 2259: IF l_use_workday_cal = fnd_api.g_true THEN

2255: INTO x_step_no
2256: FROM gme_batch_steps
2257: WHERE batchstep_id = p_step_id;
2258:
2259: IF l_use_workday_cal = fnd_api.g_true THEN
2260: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2261: gme_debug.put_line ('calling get_contiguous_periods from point 1 calc_dates'); -- Bug 13582990
2262: gme_debug.put_line ('plan_cmplt date is not null used for END DATE parm is '||
2263: TO_CHAR(p_plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

Line 2288: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

2284: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2285: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2286: END IF;
2287:
2288: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2289: IF l_cal_count > 1 THEN
2290: RAISE error_non_contiguious;
2291: END IF;
2292: END IF;

Line 2315: IF l_use_workday_cal = fnd_api.g_true THEN

2311: ,l_step_duration_tab
2312: ,x_batch_duration
2313: ,l_return_status);
2314:
2315: IF l_use_workday_cal = fnd_api.g_true THEN
2316: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2317: gme_debug.put_line ('calling get_contiguous_periods from point 2 calc_dates'); -- Bug 13582990
2318: gme_debug.put_line ('start date is not null used for START DATE parm is '||
2319: TO_CHAR(p_gme_batch_header_rec.plan_start_date,'DD-MON-YYYY HH24:MI:SS'));

Line 2344: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

2340: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2341: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2342: END IF;
2343:
2344: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2345: IF l_cal_count > 1 THEN
2346: RAISE error_non_contiguious;
2347: END IF;
2348: END IF;

Line 2369: IF l_use_workday_cal = fnd_api.g_true THEN

2365: (p_gme_batch_header_rec.plan_cmplt_date
2366: ,'DD-MON-YYYY HH24:MI:SS') );
2367: END IF;
2368:
2369: IF l_use_workday_cal = fnd_api.g_true THEN
2370: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2371: gme_debug.put_line ('calling get_contiguous_periods from point 3 calc_dates'); -- Bug 13582990
2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);
2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||

Line 2399: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

2395: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2396: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2397: END IF;
2398:
2399: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2400: IF l_cal_count > 1 THEN
2401: RAISE error_non_contiguious;
2402: END IF;
2403: END IF;

Line 2425: IF l_use_workday_cal = fnd_api.g_true THEN

2421: ,l_step_duration_tab
2422: ,x_batch_duration
2423: ,l_return_status);
2424:
2425: IF l_use_workday_cal = fnd_api.g_true THEN
2426: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2427: gme_debug.put_line ('calling get_contiguous_periods from point 4 calc_dates'); -- Bug 13582990
2428: gme_debug.put_line ('Both dates null. p_contiguity_override is '|| p_contiguity_override); -- Bug 13582990
2429: gme_debug.put_line ('batch completion is '||

Line 2457: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

2453: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2454: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2455: END IF;
2456:
2457: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2458: IF l_cal_count > 1 THEN
2459: RAISE error_non_contiguious;
2460: END IF;
2461: END IF;

Line 2522: IF l_use_workday_cal = fnd_api.g_true THEN

2518: RAISE no_activities;
2519: END IF;
2520:
2521: FOR j IN x_act_tab.FIRST .. x_act_tab.LAST LOOP
2522: IF l_use_workday_cal = fnd_api.g_true THEN
2523: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2524: gme_debug.put_line (' activity is '|| x_act_tab(j).activity);
2525: gme_debug.put_line (' step start date '
2526: || TO_CHAR (x_step_row.plan_start_date

Line 2583: IF l_use_workday_cal = fnd_api.g_true THEN

2579: END IF;
2580: /* IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN */
2581:
2582: FOR k IN x_rsrc_tab.FIRST .. x_rsrc_tab.LAST LOOP
2583: IF l_use_workday_cal = fnd_api.g_true THEN
2584: x_rsrc_tab (k).plan_start_date :=
2585: get_working_start_time
2586: (p_start_date => x_act_tab (j).plan_start_date
2587: ,p_offset => x_rsrc_tab (k).offset_interval

Line 2613: IF l_use_workday_cal = fnd_api.g_true

2609: ,l_usage_hrs
2610: ,l_return_status);
2611: l_duration := l_usage_hrs / x_rsrc_tab (k).plan_rsrc_count;
2612:
2613: IF l_use_workday_cal = fnd_api.g_true
2614: AND l_calendar_code IS NOT NULL THEN
2615: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2616: gme_debug.put_line ('calling get_contiguous_periods from point 5 calc_dates'); -- Bug 13582990
2617: gme_debug.put_line ('start date passed in is '||

Line 2804: p_return_status := fnd_api.g_ret_sts_error;

2800: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2801: gme_debug.put_line ('calc_dates... load_steps_failed');
2802: END IF;
2803:
2804: p_return_status := fnd_api.g_ret_sts_error;
2805: WHEN error_cont_period THEN
2806: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2807: gme_debug.put_line ('Contiguity period ... _failed');
2808: END IF;

Line 2819: p_return_status := fnd_api.g_ret_sts_error;

2815:
2816: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
2817: p_return_status := 'C';
2818: WHEN no_activities THEN
2819: p_return_status := fnd_api.g_ret_sts_error;
2820:
2821: OPEN cur_get_step (l_batchstep_id);
2822:
2823: FETCH cur_get_step

Line 2831: p_return_status := fnd_api.g_ret_sts_error;

2827:
2828: gme_common_pvt.log_message ('GME_NO_ACTIVITIES', 'STEPNO'
2829: ,x_step_no);
2830: WHEN no_resources THEN
2831: p_return_status := fnd_api.g_ret_sts_error;
2832:
2833: OPEN cur_get_activity (l_batchstep_activity_id);
2834:
2835: FETCH cur_get_activity

Line 2854: p_return_status := fnd_api.g_ret_sts_unexp_error;

2850: || SQLERRM);
2851: END IF;
2852:
2853: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2854: p_return_status := fnd_api.g_ret_sts_unexp_error;
2855: END calc_dates;
2856:
2857: /*======================================================================
2858: -- PROCEDURE :

Line 2928: x_return_status := fnd_api.g_ret_sts_success;

2924: BEGIN
2925: IF g_debug <= gme_debug.g_log_procedure THEN
2926: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2927: END IF;
2928: x_return_status := fnd_api.g_ret_sts_success;
2929: x_batch_duration := 0;
2930: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2931: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' calculate duration');
2932: END IF;

Line 3005: x_return_status := fnd_api.g_ret_sts_unexp_error;

3001: IF g_debug <= gme_debug.g_log_unexpected THEN
3002: gme_debug.put_line('When others exception in '|| g_pkg_name|| '.'|| l_api_name|| ' Error is '|| SQLERRM);
3003: END IF;
3004: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3005: x_return_status := fnd_api.g_ret_sts_unexp_error;
3006: END calc_longest_time_orig;
3007:
3008: /*======================================================================
3009: -- PROCEDURE :

Line 3070: x_return_status := FND_API.G_RET_STS_SUCCESS;

3066: l_brch_leaf_cnt NUMBER := 0;
3067: l_leaf_nodeid NUMBER := 0;
3068:
3069: BEGIN
3070: x_return_status := FND_API.G_RET_STS_SUCCESS;
3071: x_batch_duration := 0;
3072: i := 1;
3073:
3074: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

Line 3107: x_return_status := FND_API.g_ret_sts_unexp_error;

3103: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3104: gme_debug.put_line ('ERROR - when others - sqlerrm = ' || SQLERRM);
3105: END IF;
3106:
3107: x_return_status := FND_API.g_ret_sts_unexp_error;
3108: END calc_longest_time;
3109:
3110: /*======================================================================
3111: -- FUNCTION :

Line 3378: p_return_status := fnd_api.g_ret_sts_success;

3374: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3375: || l_api_name);
3376: END IF;
3377:
3378: p_return_status := fnd_api.g_ret_sts_success;
3379: /* Load the steps based into the PL/SQL table P_step_tbl based on the dependencies */
3380: gmd_auto_step_calc.load_steps (p_parent_id
3381: ,p_called_from_batch
3382: ,NULL

Line 3449: p_return_status := fnd_api.g_ret_sts_error;

3445: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3446: gme_debug.put_line ('GME auto step calc -- load steps failed');
3447: END IF;
3448:
3449: p_return_status := fnd_api.g_ret_sts_error;
3450: WHEN error_calculating_scale_factor THEN
3451: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3452: gme_debug.put_line
3453: ('GME_auto step calc -- error calc scale factor');

Line 3456: p_return_status := fnd_api.g_ret_sts_error;

3452: gme_debug.put_line
3453: ('GME_auto step calc -- error calc scale factor');
3454: END IF;
3455:
3456: p_return_status := fnd_api.g_ret_sts_error;
3457: WHEN OTHERS THEN
3458: IF g_debug <= gme_debug.g_log_unexpected THEN
3459: gme_debug.put_line ( 'When others exception in '
3460: || g_pkg_name

Line 3468: x_return_status := fnd_api.g_ret_sts_unexp_error;

3464: || SQLERRM);
3465: END IF;
3466:
3467: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3468: x_return_status := fnd_api.g_ret_sts_unexp_error;
3469: END calc_step_qty;
3470:
3471: PROCEDURE copy_and_create_text (
3472: p_gmd_text_code IN NUMBER

Line 3501: x_return_status := fnd_api.g_ret_sts_success;

3497: gme_debug.put_line ('BEGIN copy and create text for '
3498: || p_text_string);
3499: END IF;
3500:
3501: x_return_status := fnd_api.g_ret_sts_success;
3502: l_text_table.DELETE;
3503: l_number_of_text_lines := 0;
3504: l_return :=
3505: gme_text_dbl.insert_header_row (l_text_header, l_text_header);

Line 3576: x_return_status := fnd_api.g_ret_sts_unexp_error;

3572: gme_debug.put_line
3573: ('ERROR - unexpected error in copy and create text while inserting header or dtl');
3574: END IF;
3575:
3576: x_return_status := fnd_api.g_ret_sts_unexp_error;
3577: WHEN OTHERS THEN
3578: IF g_debug <= gme_debug.g_log_unexpected THEN
3579: gme_debug.put_line ( 'When others exception in '
3580: || g_pkg_name

Line 3588: x_return_status := fnd_api.g_ret_sts_unexp_error;

3584: || SQLERRM);
3585: END IF;
3586:
3587: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3588: x_return_status := fnd_api.g_ret_sts_unexp_error;
3589: END copy_and_create_text;
3590:
3591: PROCEDURE get_usage_in_hours (
3592: p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE

Line 3618: x_return_status := fnd_api.g_ret_sts_success;

3614: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3615: || l_api_name);
3616: END IF;
3617:
3618: x_return_status := fnd_api.g_ret_sts_success;
3619:
3620: -- Bug 14769220 - Initialize uom global for this code to work correctly.
3621: IF NOT gme_common_pvt.g_setup_done THEN
3622: gme_common_pvt.g_hour_uom_code := fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');

Line 3637: x_return_status := fnd_api.g_ret_sts_error;

3633: FETCH get_um_type_and_factor
3634: INTO l_hour_uom_class, l_hour_std_factor;
3635:
3636: IF get_um_type_and_factor%NOTFOUND THEN
3637: x_return_status := fnd_api.g_ret_sts_error;
3638: END IF;
3639:
3640: CLOSE get_um_type_and_factor;
3641:

Line 3642: IF x_return_status = fnd_api.g_ret_sts_success THEN

3638: END IF;
3639:
3640: CLOSE get_um_type_and_factor;
3641:
3642: IF x_return_status = fnd_api.g_ret_sts_success THEN
3643: OPEN get_um_type_and_factor (p_usage_um);
3644:
3645: FETCH get_um_type_and_factor
3646: INTO l_usage_uom_class, l_usage_std_factor;

Line 3649: x_return_status := fnd_api.g_ret_sts_error;

3645: FETCH get_um_type_and_factor
3646: INTO l_usage_uom_class, l_usage_std_factor;
3647:
3648: IF get_um_type_and_factor%NOTFOUND THEN
3649: x_return_status := fnd_api.g_ret_sts_error;
3650: END IF;
3651:
3652: CLOSE get_um_type_and_factor;
3653:

Line 3654: IF x_return_status = fnd_api.g_ret_sts_success THEN

3650: END IF;
3651:
3652: CLOSE get_um_type_and_factor;
3653:
3654: IF x_return_status = fnd_api.g_ret_sts_success THEN
3655: IF l_usage_uom_class <> l_hour_uom_class THEN
3656: x_return_status := fnd_api.g_ret_sts_error;
3657: END IF;
3658: END IF;

Line 3656: x_return_status := fnd_api.g_ret_sts_error;

3652: CLOSE get_um_type_and_factor;
3653:
3654: IF x_return_status = fnd_api.g_ret_sts_success THEN
3655: IF l_usage_uom_class <> l_hour_uom_class THEN
3656: x_return_status := fnd_api.g_ret_sts_error;
3657: END IF;
3658: END IF;
3659: END IF;
3660:

Line 3661: IF x_return_status = fnd_api.g_ret_sts_success THEN

3657: END IF;
3658: END IF;
3659: END IF;
3660:
3661: IF x_return_status = fnd_api.g_ret_sts_success THEN
3662: x_usage_hrs :=
3663: p_plan_rsrc_usage * l_usage_std_factor / l_hour_std_factor;
3664: END IF;
3665: END IF;

Line 3682: x_return_status := fnd_api.g_ret_sts_unexp_error;

3678: || SQLERRM);
3679: END IF;
3680:
3681: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3682: x_return_status := fnd_api.g_ret_sts_unexp_error;
3683: END get_usage_in_hours;
3684:
3685: FUNCTION get_max_duration (v_step_id IN NUMBER, v_batch_id IN NUMBER)
3686: RETURN NUMBER

Line 3740: IF l_return_status = fnd_api.g_ret_sts_success THEN

3736: ,step_resource.usage_um
3737: ,l_usage_hrs
3738: ,l_return_status);
3739:
3740: IF l_return_status = fnd_api.g_ret_sts_success THEN
3741: x_usage_hour := l_usage_hrs;
3742: ELSE
3743: x_usage_hour := 0;
3744: END IF;

Line 3880: RAISE FND_API.g_exc_error;

3876:
3877: /* once api is known will add this GMF_PeriodClose_PUB.Verify_PeriodClose
3878: IF NOT gme_api_grp.close_period_check_flexible(p_tran_rec => p_tran_rec,
3879: x_tran_rec => l_tran_rec_out) THEN
3880: RAISE FND_API.g_exc_error;
3881: END IF;
3882:
3883: l_gme_resource_txns.trans_date := l_tran_rec_out.trans_date;
3884: */

Line 3894: IF l_return_status <> FND_API.g_ret_sts_success THEN

3890: gme_validate_flex_fld_pvt.create_flex_resource_txns (
3891: l_gme_resource_txns,
3892: l_gme_resource_txns,
3893: l_return_status);
3894: IF l_return_status <> FND_API.g_ret_sts_success THEN
3895: RAISE create_flex_failure;
3896: END IF;
3897: --FPBug#4395561 End
3898:

Line 3918: x_return_status := fnd_api.g_ret_sts_error;

3914: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3915: gme_debug.put_line ('insert resource txns error');
3916: END IF;
3917:
3918: x_return_status := fnd_api.g_ret_sts_error;
3919: WHEN missing_profile_option THEN
3920: x_return_status := fnd_api.g_ret_sts_error;
3921: WHEN fnd_api.g_exc_error THEN
3922: x_return_status := fnd_api.g_ret_sts_error;

Line 3920: x_return_status := fnd_api.g_ret_sts_error;

3916: END IF;
3917:
3918: x_return_status := fnd_api.g_ret_sts_error;
3919: WHEN missing_profile_option THEN
3920: x_return_status := fnd_api.g_ret_sts_error;
3921: WHEN fnd_api.g_exc_error THEN
3922: x_return_status := fnd_api.g_ret_sts_error;
3923: --FPBug#4395561
3924: WHEN create_flex_failure THEN

Line 3921: WHEN fnd_api.g_exc_error THEN

3917:
3918: x_return_status := fnd_api.g_ret_sts_error;
3919: WHEN missing_profile_option THEN
3920: x_return_status := fnd_api.g_ret_sts_error;
3921: WHEN fnd_api.g_exc_error THEN
3922: x_return_status := fnd_api.g_ret_sts_error;
3923: --FPBug#4395561
3924: WHEN create_flex_failure THEN
3925: x_return_status := l_return_status;

Line 3922: x_return_status := fnd_api.g_ret_sts_error;

3918: x_return_status := fnd_api.g_ret_sts_error;
3919: WHEN missing_profile_option THEN
3920: x_return_status := fnd_api.g_ret_sts_error;
3921: WHEN fnd_api.g_exc_error THEN
3922: x_return_status := fnd_api.g_ret_sts_error;
3923: --FPBug#4395561
3924: WHEN create_flex_failure THEN
3925: x_return_status := l_return_status;
3926: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN