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 188: x_return_status := fnd_api.g_ret_sts_success;

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

Line 318: IF l_return_status <> FND_API.g_ret_sts_success THEN

314: gme_validate_flex_fld_pvt.create_flex_batch_step (
315: l_gme_batch_steps (j),
316: l_gme_batch_steps (j),
317: l_return_status);
318: IF l_return_status <> FND_API.g_ret_sts_success THEN
319: RAISE create_flex_failure;
320: END IF;
321: --FPBug#4395561 End
322:

Line 451: IF l_return_status <> FND_API.g_ret_sts_success THEN

447: gme_validate_flex_fld_pvt.create_flex_step_activities (
448: l_gme_batch_step_activities (j),
449: l_gme_batch_step_activities (j),
450: l_return_status);
451: IF l_return_status <> FND_API.g_ret_sts_success THEN
452: RAISE create_flex_failure;
453: END IF;
454: --FPBug#4395561 End
455:

Line 638: IF l_return_status <> FND_API.g_ret_sts_success THEN

634: gme_validate_flex_fld_pvt.create_flex_step_resources (
635: l_gme_batch_step_resources (j),
636: l_gme_batch_step_resources (j),
637: l_return_status);
638: IF l_return_status <> FND_API.g_ret_sts_success THEN
639: RAISE create_flex_failure;
640: END IF;
641: --FPBug#4395561 End
642:

Line 722: IF l_return_status <> FND_API.g_ret_sts_success THEN

718: gme_validate_flex_fld_pvt.create_flex_process_param (
719: l_gme_rsrc_parameters (m),
720: l_gme_rsrc_parameters (m),
721: l_return_status);
722: IF l_return_status <> FND_API.g_ret_sts_success THEN
723: RAISE create_flex_failure;
724: END IF;
725: --FPBug#4395561 End
726:

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

917:
918: IF l_return_status <> x_return_status THEN
919: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
920: gme_debug.put_line
921: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
922: END IF;
923:
924: RAISE error_calc_step_qty;
925: END IF;

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

1207: CLOSE cur_get_activities;
1208: END IF;
1209:
1210: /* Lets check if any of the resource quantities are falling below the min capacity */
1211: IF (p_ignore_qty_below_cap = fnd_api.g_false) THEN
1212: IF gme_common_pvt.resource_qty_below_capacity
1213: (p_batch_id => l_batch_id) THEN
1214: RAISE process_qty_below_cap;
1215: END IF;

Line 1445: x_return_status := fnd_api.g_ret_sts_error;

1441: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1442: gme_debug.put_line ('insert batch step error');
1443: END IF;
1444:
1445: x_return_status := fnd_api.g_ret_sts_error;
1446: WHEN error_insert_b_step_act THEN
1447: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1448: gme_debug.put_line ('insert batch step activity error');
1449: END IF;

Line 1451: x_return_status := fnd_api.g_ret_sts_error;

1447: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1448: gme_debug.put_line ('insert batch step activity error');
1449: END IF;
1450:
1451: x_return_status := fnd_api.g_ret_sts_error;
1452: WHEN error_insert_b_step_res THEN
1453: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1454: gme_debug.put_line ('insert batch step resource error');
1455: END IF;

Line 1457: x_return_status := fnd_api.g_ret_sts_error;

1453: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1454: gme_debug.put_line ('insert batch step resource error');
1455: END IF;
1456:
1457: x_return_status := fnd_api.g_ret_sts_error;
1458: WHEN error_insert_res_txns THEN
1459: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ('insert resource txns error');
1461: END IF;

Line 1463: x_return_status := fnd_api.g_ret_sts_error;

1459: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ('insert resource txns error');
1461: END IF;
1462:
1463: x_return_status := fnd_api.g_ret_sts_error;
1464: WHEN error_insert_b_res_param THEN
1465: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1466: gme_debug.put_line ('insert resource param error');
1467: END IF;

Line 1469: x_return_status := fnd_api.g_ret_sts_error;

1465: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1466: gme_debug.put_line ('insert resource param error');
1467: END IF;
1468:
1469: x_return_status := fnd_api.g_ret_sts_error;
1470: WHEN error_insert_b_step_items THEN
1471: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1472: gme_debug.put_line ('insert batch step items error');
1473: END IF;

Line 1475: x_return_status := fnd_api.g_ret_sts_error;

1471: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1472: gme_debug.put_line ('insert batch step items error');
1473: END IF;
1474:
1475: x_return_status := fnd_api.g_ret_sts_error;
1476: WHEN error_insert_b_step_depend THEN
1477: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1478: gme_debug.put_line ('insert batch step depend error');
1479: END IF;

Line 1481: x_return_status := fnd_api.g_ret_sts_error;

1477: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1478: gme_debug.put_line ('insert batch step depend error');
1479: END IF;
1480:
1481: x_return_status := fnd_api.g_ret_sts_error;
1482: WHEN error_calc_step_qty THEN
1483: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1484: gme_debug.put_line ('calc step qty error');
1485: END IF;

Line 1487: x_return_status := fnd_api.g_ret_sts_error;

1483: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1484: gme_debug.put_line ('calc step qty error');
1485: END IF;
1486:
1487: x_return_status := fnd_api.g_ret_sts_error;
1488: WHEN error_calc_dates THEN
1489: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1490: gme_debug.put_line ('calc dates error');
1491: END IF;

Line 1499: x_return_status := fnd_api.g_ret_sts_error;

1495: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1496: gme_debug.put_line ('calc charge error');
1497: END IF;
1498:
1499: x_return_status := fnd_api.g_ret_sts_error;
1500: WHEN error_create_text THEN
1501: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1502: gme_debug.put_line ('create text error');
1503: END IF;

Line 1511: x_return_status := fnd_api.g_ret_sts_error;

1507: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1508: gme_debug.put_line ('process qty below capacity');
1509: END IF;
1510:
1511: x_return_status := fnd_api.g_ret_sts_error;
1512: WHEN invalid_resource_qty_usage THEN
1513: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1514: gme_debug.put_line
1515: ('invalild resource process quantity and usage');

Line 1517: x_return_status := fnd_api.g_ret_sts_error;

1513: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1514: gme_debug.put_line
1515: ('invalild resource process quantity and usage');
1516: END IF;
1517: x_return_status := fnd_api.g_ret_sts_error;
1518: WHEN error_truncate_date THEN
1519: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1520: gme_debug.put_line ('truncate date procedure error');
1521: END IF;

Line 1523: x_return_status := fnd_api.g_ret_sts_error;

1519: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1520: gme_debug.put_line ('truncate date procedure error');
1521: END IF;
1522:
1523: x_return_status := fnd_api.g_ret_sts_error;
1524: --FPBug#4395561
1525: WHEN create_flex_failure THEN
1526: x_return_status := l_return_status;
1527: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

Line 1541: x_return_status := fnd_api.g_ret_sts_unexp_error;

1537: || SQLERRM);
1538: END IF;
1539:
1540: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1541: x_return_status := fnd_api.g_ret_sts_unexp_error;
1542: END create_batch_steps;
1543:
1544: PROCEDURE update_charges (
1545: p_batch_id IN NUMBER

Line 1571: x_return_status := fnd_api.g_ret_sts_success;

1567: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1568: || l_api_name);
1569: END IF;
1570:
1571: x_return_status := fnd_api.g_ret_sts_success;
1572: x_num_steps := 0;
1573:
1574: OPEN cur_get_steps (p_batch_id);
1575:

Line 1607: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1603: ( ' update charges >calc charges >batchstep_id '
1604: || TO_CHAR (x_cur_step_rec.batchstep_id) );
1605: END IF;
1606:
1607: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1608: RAISE error_calc_charge;
1609: END IF;
1610:
1611: x_num_steps := x_num_steps + 1;

Line 1642: x_return_status := fnd_api.g_ret_sts_unexp_error;

1638: || SQLERRM);
1639: END IF;
1640:
1641: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1642: x_return_status := fnd_api.g_ret_sts_unexp_error;
1643: END update_charges;
1644:
1645: /*======================================================================
1646: -- FUNCTION :

Line 1699: IF p_use_workday_cal = fnd_api.g_true THEN

1695: END IF;
1696:
1697: l_max_date := NULL;
1698:
1699: IF p_use_workday_cal = fnd_api.g_true THEN
1700: FOR rec IN cur_get_step_date_4_cal (p_batchstep_id, p_batch_id) LOOP
1701: IF rec.dep_type = 1 THEN
1702: l_date := rec.plan_start_date;
1703: ELSE

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

1716: IF l_max_date IS NULL OR l_max_date < l_plan_start_date THEN
1717: l_max_date := l_plan_start_date;
1718: END IF;
1719: END LOOP;
1720: ELSE /* p_use_workday_cal = FND_API.G_TRUE */
1721: OPEN cur_get_step_date (p_batchstep_id, p_batch_id);
1722:
1723: FETCH cur_get_step_date
1724: INTO l_date;

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

1737: END IF;
1738: END IF;
1739:
1740: CLOSE cur_get_step_date;
1741: END IF; /* p_use_workday_cal = FND_API.G_TRUE */
1742:
1743: IF l_max_date IS NULL THEN
1744: l_max_date := p_batch_start_date;
1745: END IF;

Line 2031: p_return_status := fnd_api.g_ret_sts_success;

2027: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2028: gme_debug.put_line ('start calc_dates');
2029: END IF;
2030:
2031: p_return_status := fnd_api.g_ret_sts_success;
2032: l_batch_id := p_gme_batch_header_rec.batch_id;
2033:
2034: IF (p_gme_batch_header_rec.batch_type = 0) THEN
2035: l_doc_type := 'PROD';

Line 2049: l_use_workday_cal := fnd_api.g_false;

2045:
2046: l_calendar_code := gme_common_pvt.g_calendar_code;
2047:
2048: IF l_calendar_code IS NULL THEN
2049: l_use_workday_cal := fnd_api.g_false;
2050: ELSE
2051: OPEN cur_recipe_validity_rule
2052: (p_gme_batch_header_rec.recipe_validity_rule_id);
2053:

Line 2127: IF l_use_workday_cal = fnd_api.g_true THEN

2123: INTO x_step_no
2124: FROM gme_batch_steps
2125: WHERE batchstep_id = p_step_id;
2126:
2127: IF l_use_workday_cal = fnd_api.g_true THEN
2128: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2129: gme_debug.put_line ( 'plan_cmplt date is not null'
2130: || TO_CHAR (p_plan_cmplt_date
2131: ,'DD-MON-YYYY HH24:MI:SS') );

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

2147: END IF;
2148:
2149: l_cal_count := l_contig_period_tbl.COUNT;
2150:
2151: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2152: IF l_cal_count > 1 THEN
2153: RAISE error_non_contiguious;
2154: END IF;
2155: END IF;

Line 2178: IF l_use_workday_cal = fnd_api.g_true THEN

2174: ,l_step_duration_tab
2175: ,x_batch_duration
2176: ,l_return_status);
2177:
2178: IF l_use_workday_cal = fnd_api.g_true THEN
2179: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2180: gme_debug.put_line
2181: ( 'start date is not null'
2182: || TO_CHAR

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

2199: END IF;
2200:
2201: l_cal_count := l_contig_period_tbl.COUNT;
2202:
2203: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2204: IF l_cal_count > 1 THEN
2205: RAISE error_non_contiguious;
2206: END IF;
2207: END IF;

Line 2228: IF l_use_workday_cal = fnd_api.g_true THEN

2224: (p_gme_batch_header_rec.plan_cmplt_date
2225: ,'DD-MON-YYYY HH24:MI:SS') );
2226: END IF;
2227:
2228: IF l_use_workday_cal = fnd_api.g_true THEN
2229: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2230: gme_debug.put_line ('end date null ' || l_use_workday_cal);
2231: gme_debug.put_line
2232: ( 'batch completion date is '

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

2250: END IF;
2251:
2252: l_cal_count := l_contig_period_tbl.COUNT;
2253:
2254: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2255: IF l_cal_count > 1 THEN
2256: RAISE error_non_contiguious;
2257: END IF;
2258: END IF;

Line 2280: IF l_use_workday_cal = fnd_api.g_true THEN

2276: ,l_step_duration_tab
2277: ,x_batch_duration
2278: ,l_return_status);
2279:
2280: IF l_use_workday_cal = fnd_api.g_true THEN
2281: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2282: gme_debug.put_line ( ' both dates null '
2283: || p_contiguity_override);
2284: gme_debug.put_line

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

2303: END IF;
2304:
2305: l_cal_count := l_contig_period_tbl.COUNT;
2306:
2307: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2308: IF l_cal_count > 1 THEN
2309: RAISE error_non_contiguious;
2310: END IF;
2311: END IF;

Line 2371: IF l_use_workday_cal = fnd_api.g_true THEN

2367: RAISE no_activities;
2368: END IF;
2369:
2370: FOR j IN x_act_tab.FIRST .. x_act_tab.LAST LOOP
2371: IF l_use_workday_cal = fnd_api.g_true THEN
2372: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2373: gme_debug.put_line ( ' step start date '
2374: || TO_CHAR (x_step_row.plan_start_date
2375: ,'DD-MON-YYYY HH24:MI:SS') );

Line 2431: IF l_use_workday_cal = fnd_api.g_true THEN

2427: END IF;
2428: /* IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN */
2429:
2430: FOR k IN x_rsrc_tab.FIRST .. x_rsrc_tab.LAST LOOP
2431: IF l_use_workday_cal = fnd_api.g_true THEN
2432: x_rsrc_tab (k).plan_start_date :=
2433: get_working_start_time
2434: (p_start_date => x_act_tab (j).plan_start_date
2435: ,p_offset => x_rsrc_tab (k).offset_interval

Line 2461: IF l_use_workday_cal = fnd_api.g_true

2457: ,l_usage_hrs
2458: ,l_return_status);
2459: l_duration := l_usage_hrs / x_rsrc_tab (k).plan_rsrc_count;
2460:
2461: IF l_use_workday_cal = fnd_api.g_true
2462: AND l_calendar_code IS NOT NULL THEN
2463: gmp_calendar_api.get_contiguous_periods
2464: (p_api_version => 1
2465: ,p_init_msg_list => TRUE

Line 2620: p_return_status := fnd_api.g_ret_sts_error;

2616: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2617: gme_debug.put_line ('calc_dates... load_steps_failed');
2618: END IF;
2619:
2620: p_return_status := fnd_api.g_ret_sts_error;
2621: WHEN error_cont_period THEN
2622: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2623: gme_debug.put_line ('Contiguity period ... _failed');
2624: END IF;

Line 2635: p_return_status := fnd_api.g_ret_sts_error;

2631:
2632: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
2633: p_return_status := 'C';
2634: WHEN no_activities THEN
2635: p_return_status := fnd_api.g_ret_sts_error;
2636:
2637: OPEN cur_get_step (l_batchstep_id);
2638:
2639: FETCH cur_get_step

Line 2647: p_return_status := fnd_api.g_ret_sts_error;

2643:
2644: gme_common_pvt.log_message ('GME_NO_ACTIVITIES', 'STEPNO'
2645: ,x_step_no);
2646: WHEN no_resources THEN
2647: p_return_status := fnd_api.g_ret_sts_error;
2648:
2649: OPEN cur_get_activity (l_batchstep_activity_id);
2650:
2651: FETCH cur_get_activity

Line 2670: p_return_status := fnd_api.g_ret_sts_unexp_error;

2666: || SQLERRM);
2667: END IF;
2668:
2669: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2670: p_return_status := fnd_api.g_ret_sts_unexp_error;
2671: END calc_dates;
2672:
2673: /*======================================================================
2674: -- PROCEDURE :

Line 2738: x_return_status := fnd_api.g_ret_sts_success;

2734: BEGIN
2735: IF g_debug <= gme_debug.g_log_procedure THEN
2736: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2737: END IF;
2738: x_return_status := fnd_api.g_ret_sts_success;
2739: x_batch_duration := 0;
2740: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2741: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' calculate duration');
2742: END IF;

Line 2815: x_return_status := fnd_api.g_ret_sts_unexp_error;

2811: IF g_debug <= gme_debug.g_log_unexpected THEN
2812: gme_debug.put_line('When others exception in '|| g_pkg_name|| '.'|| l_api_name|| ' Error is '|| SQLERRM);
2813: END IF;
2814: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2815: x_return_status := fnd_api.g_ret_sts_unexp_error;
2816: END calc_longest_time;
2817:
2818: /*======================================================================
2819: -- PROCEDURE :

Line 2877: p_return_status := fnd_api.g_ret_sts_success;

2873: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2874: || l_api_name);
2875: END IF;
2876:
2877: p_return_status := fnd_api.g_ret_sts_success;
2878: /* Load the steps based into the PL/SQL table P_step_tbl based on the dependencies */
2879: gmd_auto_step_calc.load_steps (p_parent_id
2880: ,p_called_from_batch
2881: ,NULL

Line 2948: p_return_status := fnd_api.g_ret_sts_error;

2944: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2945: gme_debug.put_line ('GME auto step calc -- load steps failed');
2946: END IF;
2947:
2948: p_return_status := fnd_api.g_ret_sts_error;
2949: WHEN error_calculating_scale_factor THEN
2950: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2951: gme_debug.put_line
2952: ('GME_auto step calc -- error calc scale factor');

Line 2955: p_return_status := fnd_api.g_ret_sts_error;

2951: gme_debug.put_line
2952: ('GME_auto step calc -- error calc scale factor');
2953: END IF;
2954:
2955: p_return_status := fnd_api.g_ret_sts_error;
2956: WHEN OTHERS THEN
2957: IF g_debug <= gme_debug.g_log_unexpected THEN
2958: gme_debug.put_line ( 'When others exception in '
2959: || g_pkg_name

Line 2967: x_return_status := fnd_api.g_ret_sts_unexp_error;

2963: || SQLERRM);
2964: END IF;
2965:
2966: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2967: x_return_status := fnd_api.g_ret_sts_unexp_error;
2968: END calc_step_qty;
2969:
2970: PROCEDURE copy_and_create_text (
2971: p_gmd_text_code IN NUMBER

Line 3000: x_return_status := fnd_api.g_ret_sts_success;

2996: gme_debug.put_line ('BEGIN copy and create text for '
2997: || p_text_string);
2998: END IF;
2999:
3000: x_return_status := fnd_api.g_ret_sts_success;
3001: l_text_table.DELETE;
3002: l_number_of_text_lines := 0;
3003: l_return :=
3004: gme_text_dbl.insert_header_row (l_text_header, l_text_header);

Line 3075: x_return_status := fnd_api.g_ret_sts_unexp_error;

3071: gme_debug.put_line
3072: ('ERROR - unexpected error in copy and create text while inserting header or dtl');
3073: END IF;
3074:
3075: x_return_status := fnd_api.g_ret_sts_unexp_error;
3076: WHEN OTHERS THEN
3077: IF g_debug <= gme_debug.g_log_unexpected THEN
3078: gme_debug.put_line ( 'When others exception in '
3079: || g_pkg_name

Line 3087: x_return_status := fnd_api.g_ret_sts_unexp_error;

3083: || SQLERRM);
3084: END IF;
3085:
3086: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3087: x_return_status := fnd_api.g_ret_sts_unexp_error;
3088: END copy_and_create_text;
3089:
3090: PROCEDURE get_usage_in_hours (
3091: p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE

Line 3117: x_return_status := fnd_api.g_ret_sts_success;

3113: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3114: || l_api_name);
3115: END IF;
3116:
3117: x_return_status := fnd_api.g_ret_sts_success;
3118: x_usage_hrs := 0;
3119: l_hour_um := gme_common_pvt.g_hour_uom_code;
3120:
3121: IF l_hour_um = p_usage_um THEN

Line 3130: x_return_status := fnd_api.g_ret_sts_error;

3126: FETCH get_um_type_and_factor
3127: INTO l_hour_uom_class, l_hour_std_factor;
3128:
3129: IF get_um_type_and_factor%NOTFOUND THEN
3130: x_return_status := fnd_api.g_ret_sts_error;
3131: END IF;
3132:
3133: CLOSE get_um_type_and_factor;
3134:

Line 3135: IF x_return_status = fnd_api.g_ret_sts_success THEN

3131: END IF;
3132:
3133: CLOSE get_um_type_and_factor;
3134:
3135: IF x_return_status = fnd_api.g_ret_sts_success THEN
3136: OPEN get_um_type_and_factor (p_usage_um);
3137:
3138: FETCH get_um_type_and_factor
3139: INTO l_usage_uom_class, l_usage_std_factor;

Line 3142: x_return_status := fnd_api.g_ret_sts_error;

3138: FETCH get_um_type_and_factor
3139: INTO l_usage_uom_class, l_usage_std_factor;
3140:
3141: IF get_um_type_and_factor%NOTFOUND THEN
3142: x_return_status := fnd_api.g_ret_sts_error;
3143: END IF;
3144:
3145: CLOSE get_um_type_and_factor;
3146:

Line 3147: IF x_return_status = fnd_api.g_ret_sts_success THEN

3143: END IF;
3144:
3145: CLOSE get_um_type_and_factor;
3146:
3147: IF x_return_status = fnd_api.g_ret_sts_success THEN
3148: IF l_usage_uom_class <> l_hour_uom_class THEN
3149: x_return_status := fnd_api.g_ret_sts_error;
3150: END IF;
3151: END IF;

Line 3149: x_return_status := fnd_api.g_ret_sts_error;

3145: CLOSE get_um_type_and_factor;
3146:
3147: IF x_return_status = fnd_api.g_ret_sts_success THEN
3148: IF l_usage_uom_class <> l_hour_uom_class THEN
3149: x_return_status := fnd_api.g_ret_sts_error;
3150: END IF;
3151: END IF;
3152: END IF;
3153:

Line 3154: IF x_return_status = fnd_api.g_ret_sts_success THEN

3150: END IF;
3151: END IF;
3152: END IF;
3153:
3154: IF x_return_status = fnd_api.g_ret_sts_success THEN
3155: x_usage_hrs :=
3156: p_plan_rsrc_usage * l_usage_std_factor / l_hour_std_factor;
3157: END IF;
3158: END IF;

Line 3175: x_return_status := fnd_api.g_ret_sts_unexp_error;

3171: || SQLERRM);
3172: END IF;
3173:
3174: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3175: x_return_status := fnd_api.g_ret_sts_unexp_error;
3176: END get_usage_in_hours;
3177:
3178: FUNCTION get_max_duration (v_step_id IN NUMBER, v_batch_id IN NUMBER)
3179: RETURN NUMBER

Line 3233: IF l_return_status = fnd_api.g_ret_sts_success THEN

3229: ,step_resource.usage_um
3230: ,l_usage_hrs
3231: ,l_return_status);
3232:
3233: IF l_return_status = fnd_api.g_ret_sts_success THEN
3234: x_usage_hour := l_usage_hrs;
3235: ELSE
3236: x_usage_hour := 0;
3237: END IF;

Line 3371: RAISE FND_API.g_exc_error;

3367:
3368: /* once api is known will add this GMF_PeriodClose_PUB.Verify_PeriodClose
3369: IF NOT gme_api_grp.close_period_check_flexible(p_tran_rec => p_tran_rec,
3370: x_tran_rec => l_tran_rec_out) THEN
3371: RAISE FND_API.g_exc_error;
3372: END IF;
3373:
3374: l_gme_resource_txns.trans_date := l_tran_rec_out.trans_date;
3375: */

Line 3385: IF l_return_status <> FND_API.g_ret_sts_success THEN

3381: gme_validate_flex_fld_pvt.create_flex_resource_txns (
3382: l_gme_resource_txns,
3383: l_gme_resource_txns,
3384: l_return_status);
3385: IF l_return_status <> FND_API.g_ret_sts_success THEN
3386: RAISE create_flex_failure;
3387: END IF;
3388: --FPBug#4395561 End
3389:

Line 3409: x_return_status := fnd_api.g_ret_sts_error;

3405: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3406: gme_debug.put_line ('insert resource txns error');
3407: END IF;
3408:
3409: x_return_status := fnd_api.g_ret_sts_error;
3410: WHEN missing_profile_option THEN
3411: x_return_status := fnd_api.g_ret_sts_error;
3412: WHEN fnd_api.g_exc_error THEN
3413: x_return_status := fnd_api.g_ret_sts_error;

Line 3411: x_return_status := fnd_api.g_ret_sts_error;

3407: END IF;
3408:
3409: x_return_status := fnd_api.g_ret_sts_error;
3410: WHEN missing_profile_option THEN
3411: x_return_status := fnd_api.g_ret_sts_error;
3412: WHEN fnd_api.g_exc_error THEN
3413: x_return_status := fnd_api.g_ret_sts_error;
3414: --FPBug#4395561
3415: WHEN create_flex_failure THEN

Line 3412: WHEN fnd_api.g_exc_error THEN

3408:
3409: x_return_status := fnd_api.g_ret_sts_error;
3410: WHEN missing_profile_option THEN
3411: x_return_status := fnd_api.g_ret_sts_error;
3412: WHEN fnd_api.g_exc_error THEN
3413: x_return_status := fnd_api.g_ret_sts_error;
3414: --FPBug#4395561
3415: WHEN create_flex_failure THEN
3416: x_return_status := l_return_status;

Line 3413: x_return_status := fnd_api.g_ret_sts_error;

3409: x_return_status := fnd_api.g_ret_sts_error;
3410: WHEN missing_profile_option THEN
3411: x_return_status := fnd_api.g_ret_sts_error;
3412: WHEN fnd_api.g_exc_error THEN
3413: x_return_status := fnd_api.g_ret_sts_error;
3414: --FPBug#4395561
3415: WHEN create_flex_failure THEN
3416: x_return_status := l_return_status;
3417: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN