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

134: FROM wip_entities
135: WHERE organization_id = p_organization_id
136: AND wip_entity_name = p_batch_no);
137: BEGIN
138: x_return_status := fnd_api.g_ret_sts_success;
139: OPEN Cur_wip_entity;
140: FETCH Cur_wip_entity INTO l_temp;
141: IF (Cur_wip_entity%FOUND) THEN
142: CLOSE Cur_wip_entity;

Line 148: x_return_status := fnd_api.g_ret_sts_error;

144: END IF;
145: CLOSE Cur_wip_entity;
146: EXCEPTION
147: WHEN duplicate_wip_entity THEN
148: x_return_status := fnd_api.g_ret_sts_error;
149: gme_common_pvt.log_message('GME_WIP_ENTITY_EXISTS');
150: WHEN OTHERS THEN
151: IF g_debug <= gme_debug.g_log_unexpected THEN
152: gme_debug.put_line ( 'When others exception in '

Line 160: x_return_status := fnd_api.g_ret_sts_unexp_error;

156: || ' Error is '
157: || SQLERRM);
158: END IF;
159: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
160: x_return_status := fnd_api.g_ret_sts_unexp_error;
161: END validate_wip_entity;
162:
163: PROCEDURE create_batch (
164: p_validation_level IN NUMBER

Line 171: DEFAULT fnd_api.g_true

167: ,p_batch_size IN NUMBER
168: ,p_batch_size_uom IN VARCHAR2
169: ,p_creation_mode IN VARCHAR2
170: ,p_ignore_qty_below_cap IN VARCHAR2
171: DEFAULT fnd_api.g_true
172: ,p_use_workday_cal IN VARCHAR2
173: ,p_contiguity_override IN VARCHAR2
174: ,p_is_phantom IN VARCHAR2 DEFAULT 'N'
175: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

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

171: DEFAULT fnd_api.g_true
172: ,p_use_workday_cal IN VARCHAR2
173: ,p_contiguity_override IN VARCHAR2
174: ,p_is_phantom IN VARCHAR2 DEFAULT 'N'
175: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
176: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
177: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
178: ,x_return_status OUT NOCOPY VARCHAR2)
179: IS

Line 421: x_return_status := fnd_api.g_ret_sts_success;

417: IF g_debug <= gme_debug.g_log_procedure THEN
418: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
419: || l_api_name);
420: END IF;
421: x_return_status := fnd_api.g_ret_sts_success;
422: -- Initialize output batch header
423: x_batch_header_rec := p_batch_header_rec;
424:
425: IF ( p_creation_mode <> 'RECIPE'

Line 548: ,p_init_msg_list => fnd_api.g_false

544: END IF;
545:
546: gmd_recipe_data_pub.get_recipe_data
547: (p_api_version => 1
548: ,p_init_msg_list => fnd_api.g_false
549: ,p_recipe_id => l_recipe.recipe_id
550: ,p_organization_id => x_batch_header_rec.organization_id
551: ,x_return_status => l_return_status
552: ,x_msg_count => l_message_count

Line 575: l_return_status := fnd_api.g_ret_sts_success;

571: END IF;
572:
573: ELSE /* p_creation_mode = 'LCF' */
574: /* Setup following variables so that rest of the program goes through */
575: l_return_status := fnd_api.g_ret_sts_success;
576: l_recipe_validity_rule.inventory_item_id :=
577: gme_common_pvt.materials (1).inventory_item_id;
578: l_formula_master.text_code := NULL;
579: l_formula_master.scale_type := 0;

Line 612: IF l_return_status <> fnd_api.g_ret_sts_success THEN

608: gme_debug.put_line ( '# of Lines = '
609: || TO_CHAR (gme_common_pvt.materials.COUNT) );
610: END IF;
611:
612: IF l_return_status <> fnd_api.g_ret_sts_success THEN
613: IF l_return_code = 4 THEN
614: -- Recipe does not have a routing, not an error
615: NULL;
616: ELSIF l_return_code = 8 THEN

Line 701: IF l_return_status = fnd_api.g_ret_sts_success THEN

697: ,p_batch_header_rec => x_batch_header_rec
698: ,x_material_detail_rec => l_gme_material_detail
699: ,x_return_status => l_return_status);
700:
701: IF l_return_status = fnd_api.g_ret_sts_success THEN
702:
703: l_material_details (l_number_of_formula_lines) :=
704: l_gme_material_detail;
705: l_material_details (l_number_of_formula_lines).original_qty :=

Line 732: p_init_msg_list => fnd_api.g_false ,

728: gme_common_pvt.g_line_type_ing )
729: AND (l_material_details (l_number_of_formula_lines).phantom_type = 0 ) THEN
730:
731: GMO_DISPENSE_GRP.IS_DISPENSE_ITEM (p_api_version => 1.0,
732: p_init_msg_list => fnd_api.g_false ,
733: x_return_status => l_return_status ,
734: x_msg_count => l_message_count ,
735: x_msg_data => l_message_list ,
736: p_inventory_item_id => l_formula_material.inventory_item_id,

Line 742: IF l_return_status = fnd_api.g_ret_sts_success THEN

738: p_recipe_id => l_recipe.recipe_id,
739: x_dispense_required => l_dispense_required,
740: x_dispense_config_id => l_config_id);
741:
742: IF l_return_status = fnd_api.g_ret_sts_success THEN
743: l_material_details (l_number_of_formula_lines).dispense_ind := l_dispense_required ;
744: END IF;
745:
746: END IF;

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

789: ,x_msg_data => l_message_list);
790:
791: /* If the above procedure is not able to calculate one of the 2 total qty's it returns status of Q. We need to
792: check if the total_output_qty is calculated correctly and not worry about if the total_input is notcalculated. */
793: IF (l_return_status <> fnd_api.g_ret_sts_success)
794: AND (l_return_status <> 'Q') THEN
795: RAISE expected_error;
796: END IF;
797:

Line 813: IF l_return_status <> fnd_api.g_ret_sts_success THEN

809: ,p_yield_um => l_uom
810: ,x_return_status => l_return_status
811: ,x_output_ratio => gme_common_pvt.g_batch_scale_factor);
812:
813: IF l_return_status <> fnd_api.g_ret_sts_success THEN
814: RAISE expected_error;
815: END IF;
816:
817: l_primaries := 'OUTPUTS';

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

972: ,x_return_status => l_return_status
973: ,x_msg_count => l_message_count
974: ,x_msg_data => l_message_list);
975:
976: IF (l_return_status <> fnd_api.g_ret_sts_success)
977: AND (l_return_status <> 'Q') THEN
978: RAISE expected_error;
979: END IF;
980:

Line 996: IF l_return_status <> fnd_api.g_ret_sts_success THEN

992: ,p_yield_um => l_uom
993: ,x_return_status => l_return_status
994: ,x_batchformula_ratio => gme_common_pvt.g_batch_scale_factor);
995:
996: IF l_return_status <> fnd_api.g_ret_sts_success THEN
997: RAISE expected_error;
998: END IF;
999:
1000: l_primaries := 'INPUTS';

Line 1083: ,p_enforce_vldt_check => fnd_api.g_true

1079: ,p_scale_factor => gme_common_pvt.g_batch_scale_factor
1080: ,p_primaries => l_primaries
1081: ,p_qty_type => 1
1082: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1083: ,p_enforce_vldt_check => fnd_api.g_true
1084: ,p_recalc_dates => fnd_api.g_false
1085: ,p_use_workday_cal => fnd_api.g_false
1086: ,p_contiguity_override => fnd_api.g_true
1087: ,x_material_tbl => l_material_details

Line 1084: ,p_recalc_dates => fnd_api.g_false

1080: ,p_primaries => l_primaries
1081: ,p_qty_type => 1
1082: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1083: ,p_enforce_vldt_check => fnd_api.g_true
1084: ,p_recalc_dates => fnd_api.g_false
1085: ,p_use_workday_cal => fnd_api.g_false
1086: ,p_contiguity_override => fnd_api.g_true
1087: ,x_material_tbl => l_material_details
1088: ,x_exception_material_tbl => l_exception_material_tbl

Line 1085: ,p_use_workday_cal => fnd_api.g_false

1081: ,p_qty_type => 1
1082: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1083: ,p_enforce_vldt_check => fnd_api.g_true
1084: ,p_recalc_dates => fnd_api.g_false
1085: ,p_use_workday_cal => fnd_api.g_false
1086: ,p_contiguity_override => fnd_api.g_true
1087: ,x_material_tbl => l_material_details
1088: ,x_exception_material_tbl => l_exception_material_tbl
1089: ,x_batch_header_rec => l_in_batch_header

Line 1086: ,p_contiguity_override => fnd_api.g_true

1082: ,p_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1083: ,p_enforce_vldt_check => fnd_api.g_true
1084: ,p_recalc_dates => fnd_api.g_false
1085: ,p_use_workday_cal => fnd_api.g_false
1086: ,p_contiguity_override => fnd_api.g_true
1087: ,x_material_tbl => l_material_details
1088: ,x_exception_material_tbl => l_exception_material_tbl
1089: ,x_batch_header_rec => l_in_batch_header
1090: ,

Line 1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1096: gme_debug.put_line ( 'return from scale_batch is: '
1097: || x_return_status);
1098: END IF;
1099:
1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1101: RAISE scaling_failure;
1102: ELSE
1103: FOR loop_count IN 1 .. l_number_of_formula_lines LOOP
1104: l_material_details (loop_count).plan_qty :=

Line 1312: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1308: IF (g_debug = gme_debug.g_log_statement) THEN
1309: gme_debug.put_line ('Return status after apply Fixed Proccess Loss '
1310: || x_return_status);
1311: END IF;
1312: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1313: RAISE Fixed_process_loss_failure;
1314: ELSE
1315: IF (g_debug = gme_debug.g_log_statement) THEN
1316: gme_debug.put_line ('Return from Apply Fixed Proccess Loss is ' || x_return_status);

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

1320:
1321: -- Fixed Process Loss ME
1322: IF (g_debug = gme_debug.g_log_statement) THEN
1323: gme_debug.put_line ('After calling Apply Fixed Proccess Loss return is' || x_return_status);
1324: gme_debug.put_line ('fnd return is ' || fnd_api.g_ret_sts_success);
1325: END IF;
1326:
1327: -- If we've found any errors, don't start the updates.
1328: -- IF gme_common_pvt.g_error_count > 0 THEN

Line 1379: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1375: IF l_doc_numbering <> gme_common_pvt.g_auto_doc_numbering THEN
1376: validate_wip_entity(p_organization_id => x_batch_header_rec.organization_id,
1377: p_batch_no => l_prefix||x_batch_header_rec.batch_no,
1378: x_return_status => l_return_status);
1379: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1380: RAISE wip_entity_err;
1381: END IF;
1382: END IF;
1383: END IF;

Line 1427: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1423: p_recipe_id => l_recipe.recipe_id
1424: ,p_recipe_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1425: ,x_enhanced_pi_ind => l_enhanced_pi_ind
1426: ,x_return_status => l_return_status);
1427: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1428: RAISE expected_error;
1429: END IF;
1430: x_batch_header_rec.ENHANCED_PI_IND := l_enhanced_pi_ind ;
1431: ELSE

Line 1442: IF l_return_status <> FND_API.g_ret_sts_success THEN

1438: DFF's segments if they are enabled */
1439: gme_validate_flex_fld_pvt.create_flex_batch_header(x_batch_header_rec,
1440: x_batch_header_rec,
1441: l_return_status);
1442: IF l_return_status <> FND_API.g_ret_sts_success THEN
1443: RAISE create_flex_failure;
1444: END IF;
1445: --FPBug#4395561 End
1446:

Line 1567: IF l_return_status <> FND_API.g_ret_sts_success THEN

1563: gme_validate_flex_fld_pvt.create_flex_material_details(
1564: l_material_details (l_row_count),
1565: l_material_details (l_row_count),
1566: l_return_status);
1567: IF l_return_status <> FND_API.g_ret_sts_success THEN
1568: RAISE create_flex_failure;
1569: END IF;
1570: --FPBug#4395561 End
1571: --Pawan changes for GMO

Line 1581: p_init_msg_list => fnd_api.g_false ,

1577: -- AND (p_creation_mode <> 'LCF')
1578: THEN
1579:
1580: GMO_DISPENSE_GRP.IS_DISPENSE_ITEM (p_api_version => 1.0,
1581: p_init_msg_list => fnd_api.g_false ,
1582: x_return_status => l_return_status ,
1583: x_msg_count => l_message_count ,
1584: x_msg_data => l_message_list ,
1585: p_inventory_item_id => l_material_details (l_row_count).inventory_item_id,

Line 1626: ,p_init_msg_list => FND_API.G_FALSE

1622: (p_api_version => 1.0
1623: ,p_dispense_config_id => l_config_id
1624: ,p_entity_name => GMO_DISPENSE_GRP.G_MATERIAL_LINE_ENTITY
1625: ,p_entity_key => l_material_details(l_row_count).material_detail_id
1626: ,p_init_msg_list => FND_API.G_FALSE
1627: ,x_return_status => l_return_status
1628: ,x_msg_count => l_message_count
1629: ,x_msg_data => l_message_list);
1630: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1630: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1626: ,p_init_msg_list => FND_API.G_FALSE
1627: ,x_return_status => l_return_status
1628: ,x_msg_count => l_message_count
1629: ,x_msg_data => l_message_list);
1630: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1631:
1632: RAISE unexpected_error;
1633: END IF;
1634: END IF;

Line 1701: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1697: ,p_contiguity_override => p_contiguity_override
1698: ,p_ignore_qty_below_cap => p_ignore_qty_below_cap
1699: ,x_return_status => x_return_status);
1700:
1701: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1702: RAISE steps_creation_failure;
1703: END IF;
1704:
1705: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec

Line 1776: IF p_use_workday_cal = fnd_api.g_true THEN

1772: (x_batch_header_rec.plan_cmplt_date
1773: ,'DD-MON-YYYY HH24:MI:SS') );
1774: END IF;
1775: ELSE
1776: IF p_use_workday_cal = fnd_api.g_true THEN
1777: gmd_recipe_fetch_pub.fetch_contiguous_ind
1778: (p_recipe_id => l_recipe_validity_rule.recipe_id
1779: ,p_orgn_id => p_batch_header_rec.organization_id
1780: ,p_recipe_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id

Line 1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1780: ,p_recipe_validity_rule_id => l_recipe_validity_rule.recipe_validity_rule_id
1781: ,x_contiguous_ind => l_cont_ind
1782: ,x_return_status => l_return_status);
1783:
1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1785: IF (g_debug = gme_debug.g_log_statement) THEN
1786: gme_debug.put_line
1787: ( 'GMD_RECIPE_FETCH_PUB.FETCH_CONTIGUOUS_IND returned error '
1788: || l_return_status);

Line 1837: AND p_contiguity_override = fnd_api.g_false THEN

1833: || p_contiguity_override);
1834: END IF;
1835:
1836: IF l_cont_ind = 1
1837: AND p_contiguity_override = fnd_api.g_false THEN
1838: IF l_cal_count > 1 THEN
1839: RAISE error_non_contiguious;
1840: END IF;
1841: END IF;

Line 1870: AND p_contiguity_override = fnd_api.g_false THEN

1866: || p_contiguity_override);
1867: END IF;
1868:
1869: IF l_cont_ind = 1
1870: AND p_contiguity_override = fnd_api.g_false THEN
1871: IF l_cal_count > 1 THEN
1872: RAISE error_non_contiguious;
1873: END IF;
1874: END IF;

Line 1902: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1898: validate_wip_entity(p_organization_id => x_batch_header_rec.organization_id,
1899: p_batch_no => l_prefix||x_batch_header_rec.batch_no,
1900: x_return_status => l_return_status);
1901:
1902: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1903: RAISE wip_entity_err;
1904: END IF;
1905:
1906: /* update the batch_no with the actual value */

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

1991: ,p_mtl_dtl_rec => l_material_details (l_row_count)
1992: ,x_mtl_req_date => l_material_details (l_row_count).material_requirement_date
1993: ,x_return_status => l_return_status);
1994:
1995: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1996: RAISE calc_mtl_req_date_err;
1997: ELSE
1998: --FPBug#4351032 Start
1999: /*Material requirement date is in our hands we need to find out whether particular ingredient

Line 2131: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2127: );
2128: IF (g_debug <= gme_debug.g_log_statement) THEN
2129: gme_debug.put_line ('After update step qty, return status is:' || x_return_status);
2130: END IF;
2131: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2132: -- We could not update the step qty
2133: RAISE unexpected_error;
2134: END IF;
2135: END IF;

Line 2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2165: gme_debug.put_line('Batch Planned Start Date '||TO_CHAR(x_batch_header_rec.plan_start_date,'MON-DD-YYYY HH24:MI:SS'));
2166: gme_debug.put_line('Batch Planned Completion Date '||TO_CHAR(x_batch_header_rec.plan_cmplt_date,'MON-DD-YYYY HH24:MI:SS'));
2167: END IF;
2168:
2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2170: RAISE unexpected_error;
2171: END IF; /* Reschedule of the batch to the user passed dates */
2172:
2173: /* nsinghi bug#5674398 Added the FETCH condition. Reschedule_batch will update the

Line 2262: x_return_status := fnd_api.g_ret_sts_error;

2258: IF (NOT gme_common_pvt.check_validity_rule_dates
2259: (l_recipe_validity_rule.recipe_validity_rule_id
2260: ,x_batch_header_rec.plan_start_date
2261: ,x_batch_header_rec.plan_cmplt_date) ) THEN
2262: x_return_status := fnd_api.g_ret_sts_error;
2263: RAISE date_exceed_validity_rule;
2264: END IF;
2265: END IF; /* IF p_creation_mode <> 'LCF' THEN */
2266:

Line 2365: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2361: ,p_invoke_mode => 'O'
2362: ,p_tree_mode => gme_common_pvt.g_tree_reservation_mode
2363: ,x_return_status => l_return_status
2364: ,x_exception_tbl => x_exception_material_tbl);
2365: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2366: RAISE inventory_shortage;
2367: END IF;
2368: -- nsinghi Add the material exceptions from phantom batch to Parent Batch
2369: /*

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

2394: IF g_debug <= gme_debug.g_log_statement THEN
2395: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order is Created');
2396: END IF;
2397:
2398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2399: RAISE create_mo_hdr_err;
2400: ELSE
2401: IF g_debug <= gme_debug.g_log_statement THEN
2402: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order Lines');

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

2410: ,x_material_details_tbl => l_material_details
2411: ,x_trolin_tbl => l_trolin_tbl
2412: ,x_return_status => l_return_status);
2413:
2414: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2415: RAISE create_mo_line_err;
2416: END IF;
2417:
2418: IF g_debug <= gme_debug.g_log_statement THEN

Line 2481: P_INIT_MSG_LIST => FND_API.G_FALSE,

2477: -- Pawan added code for populating the GMO
2478: IF x_batch_header_rec.enhanced_pi_ind = 'Y' THEN
2479: gmo_vbatch_grp.instantiate_advanced_pi
2480: (P_API_VERSION => 1.0,
2481: P_INIT_MSG_LIST => FND_API.G_FALSE,
2482: P_COMMIT => FND_API.G_FALSE,
2483: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2484: X_RETURN_STATUS => l_return_status,
2485: X_MSG_COUNT => l_message_count,

Line 2482: P_COMMIT => FND_API.G_FALSE,

2478: IF x_batch_header_rec.enhanced_pi_ind = 'Y' THEN
2479: gmo_vbatch_grp.instantiate_advanced_pi
2480: (P_API_VERSION => 1.0,
2481: P_INIT_MSG_LIST => FND_API.G_FALSE,
2482: P_COMMIT => FND_API.G_FALSE,
2483: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2484: X_RETURN_STATUS => l_return_status,
2485: X_MSG_COUNT => l_message_count,
2486: X_MSG_DATA => l_msg_data,

Line 2483: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

2479: gmo_vbatch_grp.instantiate_advanced_pi
2480: (P_API_VERSION => 1.0,
2481: P_INIT_MSG_LIST => FND_API.G_FALSE,
2482: P_COMMIT => FND_API.G_FALSE,
2483: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2484: X_RETURN_STATUS => l_return_status,
2485: X_MSG_COUNT => l_message_count,
2486: X_MSG_DATA => l_msg_data,
2487: P_ENTITY_NAME => 'BATCH',

Line 2495: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2491: || '.'
2492: || l_api_name
2493: || ' Calling instantiate_advanced_pi ');
2494: END IF;
2495: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2496: RAISE gmo_instantiate_err;
2497: END IF;
2498: END IF ;
2499: /*Bug#7493614 moved the workflow event call to the end of the batch

Line 2508: x_return_status := fnd_api.g_ret_sts_error;

2504: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2505: END IF;
2506: EXCEPTION
2507: WHEN doc_num_is_not_passed THEN
2508: x_return_status := fnd_api.g_ret_sts_error;
2509: gme_common_pvt.log_message ('GME_DOC_NUM_NOT_PASSED');
2510: WHEN gme_duplicate_batch THEN
2511: x_return_status := fnd_api.g_ret_sts_error;
2512: --FPBug#4898641

Line 2511: x_return_status := fnd_api.g_ret_sts_error;

2507: WHEN doc_num_is_not_passed THEN
2508: x_return_status := fnd_api.g_ret_sts_error;
2509: gme_common_pvt.log_message ('GME_DOC_NUM_NOT_PASSED');
2510: WHEN gme_duplicate_batch THEN
2511: x_return_status := fnd_api.g_ret_sts_error;
2512: --FPBug#4898641
2513: IF x_batch_header_rec.batch_type = 0 THEN
2514: gme_common_pvt.log_message ('GME_DUP_BATCH');
2515: ELSE

Line 2524: x_return_status := fnd_api.g_ret_sts_error;

2520: WHEN error_create_phantom OR invalid_header_values OR invalid_recipe THEN
2521: x_return_status := l_return_status;
2522: --FPBug#4351032
2523: 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
2524: x_return_status := fnd_api.g_ret_sts_error;
2525: WHEN error_cont_period THEN
2526: IF (g_debug = gme_debug.g_log_statement) THEN
2527: gme_debug.put_line ('Contiguity period ... _failed');
2528: END IF;

Line 2548: x_return_status := fnd_api.g_ret_sts_error;

2544:
2545: CLOSE cur_item_no;
2546: END IF;
2547:
2548: x_return_status := fnd_api.g_ret_sts_error;
2549: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
2550: fnd_message.set_token ('ITEM_NO', l_item_no);
2551: fnd_message.set_token ('FROM_UOM', l_from_uom);
2552: fnd_message.set_token ('TO_UOM', l_to_uom);

Line 2560: x_return_status := fnd_api.g_ret_sts_error;

2556: gme_debug.put_line ('Failed to apply FPL');
2557: END IF;
2558: WHEN create_by_product_failure THEN
2559: gme_common_pvt.log_message ('GME_API_CREATE_BY_PROD_FAIL');
2560: x_return_status := fnd_api.g_ret_sts_error;
2561:
2562: IF (g_debug = gme_debug.g_log_statement) THEN
2563: gme_debug.put_line ('GME_API_CREATE_BY_PROD_FAIL');
2564: END IF;

Line 2573: x_return_status := fnd_api.g_ret_sts_error;

2569: IF (g_debug = gme_debug.g_log_statement) THEN
2570: gme_debug.put_line ('truncate date procedure error');
2571: END IF;
2572:
2573: x_return_status := fnd_api.g_ret_sts_error;
2574: --FPBug#4395561
2575: WHEN create_flex_failure THEN
2576: x_return_status := l_return_status;
2577: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

Line 2582: x_return_status := fnd_api.g_ret_sts_error;

2578: gme_debug.put_line ('Creating the default values of the DFF failure');
2579: END IF;
2580: -- Rajesh Patangya Bug # 6752637
2581: WHEN update_step_mtq_failure THEN
2582: x_return_status := fnd_api.g_ret_sts_error;
2583: IF (g_debug = gme_debug.g_log_statement) THEN
2584: gme_debug.put_line ('MTQ Calculation failure');
2585: END IF;
2586: WHEN OTHERS THEN

Line 2601: x_return_status := fnd_api.g_ret_sts_unexp_error;

2597:
2598: IF (g_debug = gme_debug.g_log_statement) THEN
2599: gme_debug.put_line (SQLERRM);
2600: END IF;
2601: x_return_status := fnd_api.g_ret_sts_unexp_error;
2602: END create_batch;
2603:
2604: /************************************************************
2605: * 10-JAN-2008 Rajesh Patangya Bug # 6752637 *