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

Line 208: x_return_status := fnd_api.g_ret_sts_success;

204: FROM wip_entities
205: WHERE organization_id = p_organization_id
206: AND wip_entity_name = p_batch_no);
207: BEGIN
208: x_return_status := fnd_api.g_ret_sts_success;
209: OPEN Cur_wip_entity;
210: FETCH Cur_wip_entity INTO l_temp;
211: IF (Cur_wip_entity%FOUND) THEN
212: CLOSE Cur_wip_entity;

Line 218: x_return_status := fnd_api.g_ret_sts_error;

214: END IF;
215: CLOSE Cur_wip_entity;
216: EXCEPTION
217: WHEN duplicate_wip_entity THEN
218: x_return_status := fnd_api.g_ret_sts_error;
219: gme_common_pvt.log_message('GME_WIP_ENTITY_EXISTS');
220: WHEN OTHERS THEN
221: IF g_debug <= gme_debug.g_log_unexpected THEN
222: gme_debug.put_line ( 'When others exception in '

Line 230: x_return_status := fnd_api.g_ret_sts_unexp_error;

226: || ' Error is '
227: || SQLERRM);
228: END IF;
229: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: END validate_wip_entity;
232:
233: PROCEDURE create_batch (
234: p_validation_level IN NUMBER

Line 241: DEFAULT fnd_api.g_true

237: ,p_batch_size IN NUMBER
238: ,p_batch_size_uom IN VARCHAR2
239: ,p_creation_mode IN VARCHAR2
240: ,p_ignore_qty_below_cap IN VARCHAR2
241: DEFAULT fnd_api.g_true
242: ,p_use_workday_cal IN VARCHAR2
243: ,p_contiguity_override IN VARCHAR2
244: ,p_is_phantom IN VARCHAR2 DEFAULT 'N'
245: ,p_sum_all_prod_lines IN VARCHAR2 DEFAULT 'A'

Line 246: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

242: ,p_use_workday_cal IN VARCHAR2
243: ,p_contiguity_override IN VARCHAR2
244: ,p_is_phantom IN VARCHAR2 DEFAULT 'N'
245: ,p_sum_all_prod_lines IN VARCHAR2 DEFAULT 'A'
246: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
247: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
248: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
249: ,x_return_status OUT NOCOPY VARCHAR2)
250: IS

Line 549: x_return_status := fnd_api.g_ret_sts_success;

545: IF g_debug <= gme_debug.g_log_procedure THEN
546: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
547: || l_api_name);
548: END IF;
549: x_return_status := fnd_api.g_ret_sts_success;
550: -- Initialize output batch header
551: x_batch_header_rec := p_batch_header_rec;
552:
553: IF ( p_creation_mode <> 'RECIPE'

Line 679: ,p_init_msg_list => fnd_api.g_false

675: END IF;
676:
677: gmd_recipe_data_pub.get_recipe_data
678: (p_api_version => 1
679: ,p_init_msg_list => fnd_api.g_false
680: ,p_recipe_id => l_recipe.recipe_id
681: ,p_organization_id => x_batch_header_rec.organization_id
682: ,x_return_status => l_return_status
683: ,x_msg_count => l_message_count

Line 706: l_return_status := fnd_api.g_ret_sts_success;

702: END IF;
703:
704: ELSE /* p_creation_mode = 'LCF' */
705: /* Setup following variables so that rest of the program goes through */
706: l_return_status := fnd_api.g_ret_sts_success;
707: l_recipe_validity_rule.inventory_item_id :=
708: gme_common_pvt.materials (1).inventory_item_id;
709: l_formula_master.text_code := NULL;
710: l_formula_master.scale_type := 0;

Line 743: IF l_return_status <> fnd_api.g_ret_sts_success THEN

739: gme_debug.put_line ( '# of Lines = '
740: || TO_CHAR (gme_common_pvt.materials.COUNT) );
741: END IF;
742:
743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
744: IF l_return_code = 4 THEN
745: -- Recipe does not have a routing, not an error
746: NULL;
747: ELSIF l_return_code = 8 THEN

Line 867: IF l_return_status = fnd_api.g_ret_sts_success THEN

863: ,p_batch_header_rec => x_batch_header_rec
864: ,x_material_detail_rec => l_gme_material_detail
865: ,x_return_status => l_return_status);
866:
867: IF l_return_status = fnd_api.g_ret_sts_success THEN
868:
869: l_material_details (l_number_of_formula_lines) :=
870: l_gme_material_detail;
871:

Line 905: p_init_msg_list => fnd_api.g_false ,

901: gme_common_pvt.g_line_type_ing )
902: AND (l_material_details (l_number_of_formula_lines).phantom_type = 0 ) THEN
903:
904: GMO_DISPENSE_GRP.IS_DISPENSE_ITEM (p_api_version => 1.0,
905: p_init_msg_list => fnd_api.g_false ,
906: x_return_status => l_return_status ,
907: x_msg_count => l_message_count ,
908: x_msg_data => l_message_list ,
909: p_inventory_item_id => l_formula_material.inventory_item_id,

Line 915: IF l_return_status = fnd_api.g_ret_sts_success THEN

911: p_recipe_id => l_recipe.recipe_id,
912: x_dispense_required => l_dispense_required,
913: x_dispense_config_id => l_config_id);
914:
915: IF l_return_status = fnd_api.g_ret_sts_success THEN
916: l_material_details (l_number_of_formula_lines).dispense_ind := l_dispense_required ;
917: END IF;
918:
919: END IF;

Line 966: IF (l_return_status <> fnd_api.g_ret_sts_success)

962: ,x_msg_data => l_message_list);
963:
964: /* If the above procedure is not able to calculate one of the 2 total qty's it returns status of Q. We need to
965: check if the total_output_qty is calculated correctly and not worry about if the total_input is notcalculated. */
966: IF (l_return_status <> fnd_api.g_ret_sts_success)
967: AND (l_return_status <> 'Q') THEN
968: RAISE expected_error;
969: END IF;
970:

Line 986: IF l_return_status <> fnd_api.g_ret_sts_success THEN

982: ,p_yield_um => l_uom
983: ,x_return_status => l_return_status
984: ,x_output_ratio => gme_common_pvt.g_batch_scale_factor);
985:
986: IF l_return_status <> fnd_api.g_ret_sts_success THEN
987: RAISE expected_error;
988: END IF;
989:
990: l_primaries := 'OUTPUTS';

Line 1141: IF (l_return_status <> fnd_api.g_ret_sts_success)

1137: ,x_return_status => l_return_status
1138: ,x_msg_count => l_message_count
1139: ,x_msg_data => l_message_list);
1140:
1141: IF (l_return_status <> fnd_api.g_ret_sts_success)
1142: AND (l_return_status <> 'Q') THEN
1143: RAISE expected_error;
1144: END IF;
1145:

Line 1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1157: ,p_yield_um => l_uom
1158: ,x_return_status => l_return_status
1159: ,x_batchformula_ratio => gme_common_pvt.g_batch_scale_factor);
1160:
1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1162: RAISE expected_error;
1163: END IF;
1164:
1165: l_primaries := 'INPUTS';

Line 1252: ,p_enforce_vldt_check => fnd_api.g_true

1248: ,p_scale_factor => gme_common_pvt.g_batch_scale_factor
1249: ,p_primaries => l_primaries
1250: ,p_qty_type => 1
1251: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1252: ,p_enforce_vldt_check => fnd_api.g_true
1253: ,p_recalc_dates => fnd_api.g_false
1254: ,p_use_workday_cal => fnd_api.g_false
1255: ,p_contiguity_override => fnd_api.g_true
1256: ,x_material_tbl => l_material_details

Line 1253: ,p_recalc_dates => fnd_api.g_false

1249: ,p_primaries => l_primaries
1250: ,p_qty_type => 1
1251: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1252: ,p_enforce_vldt_check => fnd_api.g_true
1253: ,p_recalc_dates => fnd_api.g_false
1254: ,p_use_workday_cal => fnd_api.g_false
1255: ,p_contiguity_override => fnd_api.g_true
1256: ,x_material_tbl => l_material_details
1257: ,x_exception_material_tbl => l_exception_material_tbl

Line 1254: ,p_use_workday_cal => fnd_api.g_false

1250: ,p_qty_type => 1
1251: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1252: ,p_enforce_vldt_check => fnd_api.g_true
1253: ,p_recalc_dates => fnd_api.g_false
1254: ,p_use_workday_cal => fnd_api.g_false
1255: ,p_contiguity_override => fnd_api.g_true
1256: ,x_material_tbl => l_material_details
1257: ,x_exception_material_tbl => l_exception_material_tbl
1258: ,x_batch_header_rec => l_in_batch_header

Line 1255: ,p_contiguity_override => fnd_api.g_true

1251: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1252: ,p_enforce_vldt_check => fnd_api.g_true
1253: ,p_recalc_dates => fnd_api.g_false
1254: ,p_use_workday_cal => fnd_api.g_false
1255: ,p_contiguity_override => fnd_api.g_true
1256: ,x_material_tbl => l_material_details
1257: ,x_exception_material_tbl => l_exception_material_tbl
1258: ,x_batch_header_rec => l_in_batch_header
1259: ,

Line 1270: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1266: gme_debug.put_line ( 'return from scale_batch is: '
1267: || x_return_status);
1268: END IF;
1269:
1270: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1271: RAISE scaling_failure;
1272: ELSE
1273: FOR loop_count IN 1 .. l_number_of_formula_lines LOOP
1274: l_material_details (loop_count).plan_qty :=

Line 1321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1317: ,x_scale_rec => l_scale_rec_out
1318: ,x_return_status => l_return_status
1319: );
1320:
1321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1322: RAISE error_in_integer_scale;
1323: END IF;
1324:
1325: l_material_details (loop_count).plan_qty := l_scale_rec_out.qty;

Line 1541: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1537: IF (g_debug = gme_debug.g_log_statement) THEN
1538: gme_debug.put_line ('Return status after apply Fixed Proccess Loss '
1539: || x_return_status);
1540: END IF;
1541: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1542: RAISE Fixed_process_loss_failure;
1543: ELSE
1544: IF (g_debug = gme_debug.g_log_statement) THEN
1545: gme_debug.put_line ('Return from Apply Fixed Proccess Loss is ' || x_return_status);

Line 1553: gme_debug.put_line ('fnd return is ' || fnd_api.g_ret_sts_success);

1549:
1550: -- Fixed Process Loss ME
1551: IF (g_debug = gme_debug.g_log_statement) THEN
1552: gme_debug.put_line ('After calling Apply Fixed Proccess Loss return is' || x_return_status);
1553: gme_debug.put_line ('fnd return is ' || fnd_api.g_ret_sts_success);
1554: END IF;
1555:
1556: -- If we've found any errors, don't start the updates.
1557: -- IF gme_common_pvt.g_error_count > 0 THEN

Line 1608: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1604: IF l_doc_numbering <> gme_common_pvt.g_auto_doc_numbering THEN
1605: validate_wip_entity(p_organization_id => x_batch_header_rec.organization_id,
1606: p_batch_no => l_prefix||x_batch_header_rec.batch_no,
1607: x_return_status => l_return_status);
1608: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1609: RAISE wip_entity_err;
1610: END IF;
1611: END IF;
1612: END IF;

Line 1656: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1652: p_recipe_id => l_recipe.recipe_id
1653: ,p_recipe_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1654: ,x_enhanced_pi_ind => l_enhanced_pi_ind
1655: ,x_return_status => l_return_status);
1656: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1657: RAISE expected_error;
1658: END IF;
1659: x_batch_header_rec.ENHANCED_PI_IND := l_enhanced_pi_ind ;
1660: ELSE

Line 1671: IF l_return_status <> FND_API.g_ret_sts_success THEN

1667: DFF's segments if they are enabled */
1668: gme_validate_flex_fld_pvt.create_flex_batch_header(x_batch_header_rec,
1669: x_batch_header_rec,
1670: l_return_status);
1671: IF l_return_status <> FND_API.g_ret_sts_success THEN
1672: RAISE create_flex_failure;
1673: END IF;
1674: --FPBug#4395561 End
1675:

Line 1796: IF l_return_status <> FND_API.g_ret_sts_success THEN

1792: gme_validate_flex_fld_pvt.create_flex_material_details(
1793: l_material_details (l_row_count),
1794: l_material_details (l_row_count),
1795: l_return_status);
1796: IF l_return_status <> FND_API.g_ret_sts_success THEN
1797: RAISE create_flex_failure;
1798: END IF;
1799: --FPBug#4395561 End
1800: --Pawan changes for GMO

Line 1810: p_init_msg_list => fnd_api.g_false ,

1806: -- AND (p_creation_mode <> 'LCF')
1807: THEN
1808:
1809: GMO_DISPENSE_GRP.IS_DISPENSE_ITEM (p_api_version => 1.0,
1810: p_init_msg_list => fnd_api.g_false ,
1811: x_return_status => l_return_status ,
1812: x_msg_count => l_message_count ,
1813: x_msg_data => l_message_list ,
1814: p_inventory_item_id => l_material_details (l_row_count).inventory_item_id,

Line 1855: ,p_init_msg_list => FND_API.G_FALSE

1851: (p_api_version => 1.0
1852: ,p_dispense_config_id => l_config_id
1853: ,p_entity_name => GMO_DISPENSE_GRP.G_MATERIAL_LINE_ENTITY
1854: ,p_entity_key => l_material_details(l_row_count).material_detail_id
1855: ,p_init_msg_list => FND_API.G_FALSE
1856: ,x_return_status => l_return_status
1857: ,x_msg_count => l_message_count
1858: ,x_msg_data => l_message_list);
1859: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1859: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1855: ,p_init_msg_list => FND_API.G_FALSE
1856: ,x_return_status => l_return_status
1857: ,x_msg_count => l_message_count
1858: ,x_msg_data => l_message_list);
1859: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1860:
1861: RAISE unexpected_error;
1862: END IF;
1863: END IF;

Line 1930: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1926: ,p_contiguity_override => p_contiguity_override
1927: ,p_ignore_qty_below_cap => p_ignore_qty_below_cap
1928: ,x_return_status => x_return_status);
1929:
1930: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1931: RAISE steps_creation_failure;
1932: END IF;
1933:
1934: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec

Line 2005: IF p_use_workday_cal = fnd_api.g_true THEN

2001: (x_batch_header_rec.plan_cmplt_date
2002: ,'DD-MON-YYYY HH24:MI:SS') );
2003: END IF;
2004: ELSE
2005: IF p_use_workday_cal = fnd_api.g_true THEN
2006: gmd_recipe_fetch_pub.fetch_contiguous_ind
2007: (p_recipe_id => l_recipe_validity_rule.recipe_id
2008: ,p_orgn_id => p_batch_header_rec.organization_id
2009: ,p_recipe_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id

Line 2013: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2009: ,p_recipe_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
2010: ,x_contiguous_ind => l_cont_ind
2011: ,x_return_status => l_return_status);
2012:
2013: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2014: IF (g_debug = gme_debug.g_log_statement) THEN
2015: gme_debug.put_line
2016: ( 'GMD_RECIPE_FETCH_PUB.FETCH_CONTIGUOUS_IND returned error '
2017: || l_return_status);

Line 2066: AND p_contiguity_override = fnd_api.g_false THEN

2062: || p_contiguity_override);
2063: END IF;
2064:
2065: IF l_cont_ind = 1
2066: AND p_contiguity_override = fnd_api.g_false THEN
2067: IF l_cal_count > 1 THEN
2068: RAISE error_non_contiguious;
2069: END IF;
2070: END IF;

Line 2099: AND p_contiguity_override = fnd_api.g_false THEN

2095: || p_contiguity_override);
2096: END IF;
2097:
2098: IF l_cont_ind = 1
2099: AND p_contiguity_override = fnd_api.g_false THEN
2100: IF l_cal_count > 1 THEN
2101: RAISE error_non_contiguious;
2102: END IF;
2103: END IF;

Line 2141: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2137: validate_wip_entity(p_organization_id => x_batch_header_rec.organization_id,
2138: p_batch_no => l_prefix||x_batch_header_rec.batch_no,
2139: x_return_status => l_return_status);
2140:
2141: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2142: IF l_doc_count > 18 THEN
2143: RAISE wip_entity_err;
2144: ELSE
2145: l_doc_count := l_doc_count + 1;

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

2244: ,p_mtl_dtl_rec => l_material_details (l_row_count)
2245: ,x_mtl_req_date => l_material_details (l_row_count).material_requirement_date
2246: ,x_return_status => l_return_status);
2247:
2248: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2249: RAISE calc_mtl_req_date_err;
2250: ELSE
2251: --FPBug#4351032 Start
2252: /*Material requirement date is in our hands we need to find out whether particular ingredient

Line 2391: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2387: );
2388: IF (g_debug <= gme_debug.g_log_statement) THEN
2389: gme_debug.put_line ('After update step qty, return status is:' || x_return_status);
2390: END IF;
2391: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2392: -- We could not update the step qty
2393: RAISE unexpected_error;
2394: END IF;
2395: END IF;

Line 2429: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2425: gme_debug.put_line('Batch Planned Start Date '||TO_CHAR(x_batch_header_rec.plan_start_date,'MON-DD-YYYY HH24:MI:SS'));
2426: gme_debug.put_line('Batch Planned Completion Date '||TO_CHAR(x_batch_header_rec.plan_cmplt_date,'MON-DD-YYYY HH24:MI:SS'));
2427: END IF;
2428:
2429: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2430: RAISE unexpected_error;
2431: END IF; /* Reschedule of the batch to the user passed dates */
2432:
2433: /* nsinghi bug#5674398 Added the FETCH condition. Reschedule_batch will update the

Line 2534: x_return_status := fnd_api.g_ret_sts_error;

2530: IF (NOT gme_common_pvt.check_validity_rule_dates
2531: (l_recipe_validity_rule.recipe_validity_rule_id
2532: ,x_batch_header_rec.plan_start_date
2533: ,x_batch_header_rec.plan_cmplt_date) ) THEN
2534: x_return_status := fnd_api.g_ret_sts_error;
2535: RAISE date_exceed_validity_rule;
2536: END IF;
2537: END IF; /* IF p_creation_mode <> 'LCF' THEN */
2538:

Line 2641: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2637: ,p_invoke_mode => 'O'
2638: ,p_tree_mode => gme_common_pvt.g_tree_reservation_mode
2639: ,x_return_status => l_return_status
2640: ,x_exception_tbl => x_exception_material_tbl);
2641: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2642: RAISE inventory_shortage;
2643: END IF;
2644: -- nsinghi Add the material exceptions from phantom batch to Parent Batch
2645: /*

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

2670: IF g_debug <= gme_debug.g_log_statement THEN
2671: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order is Created');
2672: END IF;
2673:
2674: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2675: RAISE create_mo_hdr_err;
2676: ELSE
2677: IF g_debug <= gme_debug.g_log_statement THEN
2678: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order Lines');

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

2686: ,x_material_details_tbl => l_material_details
2687: ,x_trolin_tbl => l_trolin_tbl
2688: ,x_return_status => l_return_status);
2689:
2690: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2691: RAISE create_mo_line_err;
2692: END IF;
2693:
2694: IF g_debug <= gme_debug.g_log_statement THEN

Line 2769: P_INIT_MSG_LIST => FND_API.G_FALSE,

2765: -- Pawan added code for populating the GMO
2766: IF x_batch_header_rec.enhanced_pi_ind = 'Y' THEN
2767: gmo_vbatch_grp.instantiate_advanced_pi
2768: (P_API_VERSION => 1.0,
2769: P_INIT_MSG_LIST => FND_API.G_FALSE,
2770: P_COMMIT => FND_API.G_FALSE,
2771: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2772: X_RETURN_STATUS => l_return_status,
2773: X_MSG_COUNT => l_message_count,

Line 2770: P_COMMIT => FND_API.G_FALSE,

2766: IF x_batch_header_rec.enhanced_pi_ind = 'Y' THEN
2767: gmo_vbatch_grp.instantiate_advanced_pi
2768: (P_API_VERSION => 1.0,
2769: P_INIT_MSG_LIST => FND_API.G_FALSE,
2770: P_COMMIT => FND_API.G_FALSE,
2771: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2772: X_RETURN_STATUS => l_return_status,
2773: X_MSG_COUNT => l_message_count,
2774: X_MSG_DATA => l_msg_data,

Line 2771: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

2767: gmo_vbatch_grp.instantiate_advanced_pi
2768: (P_API_VERSION => 1.0,
2769: P_INIT_MSG_LIST => FND_API.G_FALSE,
2770: P_COMMIT => FND_API.G_FALSE,
2771: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2772: X_RETURN_STATUS => l_return_status,
2773: X_MSG_COUNT => l_message_count,
2774: X_MSG_DATA => l_msg_data,
2775: P_ENTITY_NAME => 'BATCH',

Line 2783: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2779: || '.'
2780: || l_api_name
2781: || ' Calling instantiate_advanced_pi ');
2782: END IF;
2783: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2784: RAISE gmo_instantiate_err;
2785: END IF;
2786: END IF ;
2787: /*Bug#7493614 moved the workflow event call to the end of the batch

Line 2796: x_return_status := fnd_api.g_ret_sts_error;

2792: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2793: END IF;
2794: EXCEPTION
2795: WHEN doc_num_is_not_passed THEN
2796: x_return_status := fnd_api.g_ret_sts_error;
2797: gme_common_pvt.log_message ('GME_DOC_NUM_NOT_PASSED');
2798: WHEN gme_duplicate_batch THEN
2799: x_return_status := fnd_api.g_ret_sts_error;
2800: --FPBug#4898641

Line 2799: x_return_status := fnd_api.g_ret_sts_error;

2795: WHEN doc_num_is_not_passed THEN
2796: x_return_status := fnd_api.g_ret_sts_error;
2797: gme_common_pvt.log_message ('GME_DOC_NUM_NOT_PASSED');
2798: WHEN gme_duplicate_batch THEN
2799: x_return_status := fnd_api.g_ret_sts_error;
2800: --FPBug#4898641
2801: IF x_batch_header_rec.batch_type = 0 THEN
2802: gme_common_pvt.log_message ('GME_DUP_BATCH');
2803: ELSE

Line 2812: x_return_status := fnd_api.g_ret_sts_error;

2808: WHEN error_create_phantom OR invalid_header_values OR invalid_recipe THEN
2809: x_return_status := l_return_status;
2810: --FPBug#4351032
2811: WHEN validation_failure OR expected_error OR scaling_failure OR date_exceed_validity_rule OR batch_header_fetch_failure OR error_count_exceeded OR expected_error OR unexpected_error OR invalid_item_substitute OR material_dtl_fetch_failure THEN
2812: x_return_status := fnd_api.g_ret_sts_error;
2813: WHEN error_cont_period THEN
2814: IF (g_debug = gme_debug.g_log_statement) THEN
2815: gme_debug.put_line ('Contiguity period ... _failed');
2816: END IF;

Line 2836: x_return_status := fnd_api.g_ret_sts_error;

2832:
2833: CLOSE cur_item_no;
2834: END IF;
2835:
2836: x_return_status := fnd_api.g_ret_sts_error;
2837: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
2838: fnd_message.set_token ('ITEM_NO', l_item_no);
2839: fnd_message.set_token ('FROM_UOM', l_from_uom);
2840: fnd_message.set_token ('TO_UOM', l_to_uom);

Line 2848: x_return_status := fnd_api.g_ret_sts_error;

2844: gme_debug.put_line ('Failed to apply FPL');
2845: END IF;
2846: WHEN create_by_product_failure THEN
2847: gme_common_pvt.log_message ('GME_API_CREATE_BY_PROD_FAIL');
2848: x_return_status := fnd_api.g_ret_sts_error;
2849:
2850: IF (g_debug = gme_debug.g_log_statement) THEN
2851: gme_debug.put_line ('GME_API_CREATE_BY_PROD_FAIL');
2852: END IF;

Line 2855: x_return_status := FND_API.g_ret_sts_error;

2851: gme_debug.put_line ('GME_API_CREATE_BY_PROD_FAIL');
2852: END IF;
2853: WHEN error_in_integer_scale THEN -- 10624995
2854: gme_common_pvt.log_message ('GME_INTEGER_MULTIPLE_SCALE_ERR');
2855: x_return_status := FND_API.g_ret_sts_error;
2856:
2857: IF (g_debug = gme_debug.g_log_statement) THEN
2858: gme_debug.put_line ('Integer scaling failed for non scaled batch.. should not happen !!');
2859: END IF;

Line 2868: x_return_status := fnd_api.g_ret_sts_error;

2864: IF (g_debug = gme_debug.g_log_statement) THEN
2865: gme_debug.put_line ('truncate date procedure error');
2866: END IF;
2867:
2868: x_return_status := fnd_api.g_ret_sts_error;
2869: --FPBug#4395561
2870: WHEN create_flex_failure THEN
2871: x_return_status := l_return_status;
2872: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

Line 2877: x_return_status := fnd_api.g_ret_sts_error;

2873: gme_debug.put_line ('Creating the default values of the DFF failure');
2874: END IF;
2875: -- Rajesh Patangya Bug # 6752637
2876: WHEN update_step_mtq_failure THEN
2877: x_return_status := fnd_api.g_ret_sts_error;
2878: IF (g_debug = gme_debug.g_log_statement) THEN
2879: gme_debug.put_line ('MTQ Calculation failure');
2880: END IF;
2881: WHEN OTHERS THEN

Line 2896: x_return_status := fnd_api.g_ret_sts_unexp_error;

2892:
2893: IF (g_debug = gme_debug.g_log_statement) THEN
2894: gme_debug.put_line (SQLERRM);
2895: END IF;
2896: x_return_status := fnd_api.g_ret_sts_unexp_error;
2897: END create_batch;
2898:
2899: /************************************************************
2900: * 10-JAN-2008 Rajesh Patangya Bug # 6752637 *