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

Line 34: RETURN FND_API.G_FALSE;

30: END IF;
31: OPEN check_item_exists;
32: FETCH check_item_exists INTO l_item_id;
33: IF ( check_item_exists%NOTFOUND) THEN
34: RETURN FND_API.G_FALSE;
35: ELSE
36: RETURN FND_API.G_TRUE;
37: END IF;
38: CLOSE check_item_exists;

Line 36: RETURN FND_API.G_TRUE;

32: FETCH check_item_exists INTO l_item_id;
33: IF ( check_item_exists%NOTFOUND) THEN
34: RETURN FND_API.G_FALSE;
35: ELSE
36: RETURN FND_API.G_TRUE;
37: END IF;
38: CLOSE check_item_exists;
39: EXCEPTION
40: WHEN OTHERS THEN

Line 44: RETURN FND_API.G_FALSE;

40: WHEN OTHERS THEN
41: IF (check_item_exists%ISOPEN) THEN
42: CLOSE check_item_exists;
43: END IF;
44: RETURN FND_API.G_FALSE;
45: END;
46:
47: /* ======================================================================== */
48:

Line 76: p_formula_obj.formula_details(j).owner_organization_id) <> FND_API.g_true) THEN

72: BEGIN
73: IF p_formula_obj IS NOT NULL THEN
74: FOR j in 1..p_formula_obj.formula_details.COUNT LOOP
75: IF( inv_ebi_UTIL.is_master_org (
76: p_formula_obj.formula_details(j).owner_organization_id) <> FND_API.g_true) THEN
77: IF(item_exists_in_org( p_formula_obj.formula_details(j).inventory_item_id,p_formula_obj.formula_details(j).owner_organization_id) = FND_API.g_false) THEN
78: l_org_id_obj := inv_ebi_org_obj(p_formula_obj.formula_details(j).owner_organization_id,
79: p_formula_obj.formula_details(j).owner_organization_code);
80: l_org_id_tbl := inv_ebi_org_tbl();

Line 77: IF(item_exists_in_org( p_formula_obj.formula_details(j).inventory_item_id,p_formula_obj.formula_details(j).owner_organization_id) = FND_API.g_false) THEN

73: IF p_formula_obj IS NOT NULL THEN
74: FOR j in 1..p_formula_obj.formula_details.COUNT LOOP
75: IF( inv_ebi_UTIL.is_master_org (
76: p_formula_obj.formula_details(j).owner_organization_id) <> FND_API.g_true) THEN
77: IF(item_exists_in_org( p_formula_obj.formula_details(j).inventory_item_id,p_formula_obj.formula_details(j).owner_organization_id) = FND_API.g_false) THEN
78: l_org_id_obj := inv_ebi_org_obj(p_formula_obj.formula_details(j).owner_organization_id,
79: p_formula_obj.formula_details(j).owner_organization_code);
80: l_org_id_tbl := inv_ebi_org_tbl();
81: l_org_id_tbl.extend();

Line 84: p_init_msg_list => FND_API.G_FALSE

80: l_org_id_tbl := inv_ebi_org_tbl();
81: l_org_id_tbl.extend();
82: l_org_id_tbl(1) := l_org_id_obj;
83: inv_ebi_ITEM_HELPER.process_org_id_assignments(
84: p_init_msg_list => FND_API.G_FALSE
85: ,p_commit => FND_API.G_FALSE
86: ,p_inventory_item_id => p_formula_obj.formula_details(j).inventory_item_id
87: ,p_item_number => p_formula_obj.formula_details(j).item_no
88: ,p_org_id_tbl=>l_org_id_tbl

Line 85: ,p_commit => FND_API.G_FALSE

81: l_org_id_tbl.extend();
82: l_org_id_tbl(1) := l_org_id_obj;
83: inv_ebi_ITEM_HELPER.process_org_id_assignments(
84: p_init_msg_list => FND_API.G_FALSE
85: ,p_commit => FND_API.G_FALSE
86: ,p_inventory_item_id => p_formula_obj.formula_details(j).inventory_item_id
87: ,p_item_number => p_formula_obj.formula_details(j).item_no
88: ,p_org_id_tbl=>l_org_id_tbl
89: ,x_out=>l_out

Line 94: IF (l_out.output_status.return_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN

90: );
91: SELECT recipe_enabled_flag INTO l_temp FROM mtl_system_items_b WHERE inventory_item_id=p_formula_obj.formula_details(j).inventory_item_id
92: AND organization_id=p_formula_obj.formula_details(j).owner_organization_id;
93:
94: IF (l_out.output_status.return_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
95: x_msg_data := l_out.output_status.msg_data || ' FOR FORMULA' || p_formula_obj.formula_header.FORMULA_NO || p_formula_obj.formula_details(j).LINE_NO || p_formula_obj.formula_details(j).LINE_TYPE;
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: END IF;
98: END IF;

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

92: AND organization_id=p_formula_obj.formula_details(j).owner_organization_id;
93:
94: IF (l_out.output_status.return_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
95: x_msg_data := l_out.output_status.msg_data || ' FOR FORMULA' || p_formula_obj.formula_header.FORMULA_NO || p_formula_obj.formula_details(j).LINE_NO || p_formula_obj.formula_details(j).LINE_TYPE;
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: END IF;
98: END IF;
99: END IF;
100: END LOOP;

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: END IF;
99: END IF;
100: END LOOP;
101: END IF;
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: EXCEPTION
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: END;

Line 105: x_return_status := FND_API.G_RET_STS_ERROR;

101: END IF;
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: EXCEPTION
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: END;
107:
108: /* ======================================================================== */
109:

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

129: IS
130: l_org_id NUMBER;
131: l_formula_obj gmd_ebi_formula_obj;
132: BEGIN
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: l_formula_obj := p_formula_obj;
135: IF l_formula_obj IS NOT NULL THEN
136: SELECT organization_id INTO l_org_id FROM mtl_parameters
137: WHERE organization_code = l_formula_obj.formula_header.OWNER_ORGANIZATION_CODE;

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

142: END IF;
143: x_formula_obj := l_formula_obj;
144: EXCEPTION
145: WHEN OTHERS THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
148: FND_MESSAGE.set_token('COL_VALUE', p_formula_obj.formula_header.OWNER_ORGANIZATION_CODE);
149: FND_MSG_PUB.add;
150: FND_MSG_PUB.count_and_get(

Line 151: p_encoded => FND_API.g_false

147: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
148: FND_MESSAGE.set_token('COL_VALUE', p_formula_obj.formula_header.OWNER_ORGANIZATION_CODE);
149: FND_MSG_PUB.add;
150: FND_MSG_PUB.count_and_get(
151: p_encoded => FND_API.g_false
152: ,p_count => x_msg_count
153: ,p_data => x_msg_data
154: );
155: END;

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: l_item_id NUMBER;
165: l_formula_obj gmd_ebi_formula_obj;
166:
167: BEGIN
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: l_formula_obj := p_formula_obj;
170: IF l_formula_obj IS NOT NULL THEN
171: FOR j in 1..l_formula_obj.formula_details.COUNT LOOP
172: IF (l_formula_obj.formula_details(j).inventory_item_id IS NULL) THEN

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: END IF;
180: x_formula_obj := l_formula_obj;
181: EXCEPTION
182: WHEN OTHERS THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: x_msg_data := SQLERRM || 'AT GET ORG IDS FROM ORG CODE';
185: END;
186:
187:

Line 221: IF ( status_flag IN ( FND_API.G_RET_STS_SUCCESS,'Q')) THEN

217: l_form_id NUMBER;
218: l_form_line_id NUMBER;
219: line_ctr NUMBER := 1;
220: BEGIN
221: IF ( status_flag IN ( FND_API.G_RET_STS_SUCCESS,'Q')) THEN
222: IF ( p_input.formula_header.FORMULA_ID IS NULL ) THEN
223: SELECT Max(formula_id) INTO l_form_id FROM fm_form_mst_b WHERE formula_no = p_input.formula_header.formula_no;
224: ELSE
225: l_form_id := p_input.formula_header.FORMULA_ID;

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: line_ctr := line_ctr + 1;
234: END LOOP;
235: l_out_obj := gmd_ebi_formula_output_obj(p_input.formula_header.business_component_id,l_form_id,l_out_line_sync_tbl,p_line_delete_tbl);
236: x_output := l_out_obj;
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: x_msg_data := NULL;
239: ELSE
240: FOR j IN 1..p_input.formula_details.Count LOOP
241: l_out_line_sync_obj := gmd_ebi_formula_line_sync_obj(NULL,p_input.formula_details(j).business_component_id);

Line 248: x_return_status := FND_API.G_RET_STS_SUCCESS;

244: line_ctr := line_ctr + 1;
245: END LOOP;
246: l_out_obj := gmd_ebi_formula_output_obj(p_input.formula_header.business_component_id,NULL,l_out_line_sync_tbl,NULL);
247: x_output := l_out_obj;
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249: x_msg_data := NULL;
250: END IF;
251: EXCEPTION
252: WHEN OTHERS THEN

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: x_msg_data := NULL;
250: END IF;
251: EXCEPTION
252: WHEN OTHERS THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: x_msg_data := SQLERRM;
255: END;
256:
257: FUNCTION get_org_id(p_org_code IN VARCHAR2)

Line 451: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

447: , x_message_count => l_msg_count
448: , x_message_list => l_msg
449: , x_return_status => l_ret_status
450: );
451: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: ELSE

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448: , x_message_list => l_msg
449: , x_return_status => l_ret_status
450: );
451: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: ELSE
456: l_rout_rec.p_col_to_update := 'routing_status';

Line 646: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

642: , x_message_count => l_msg_count
643: , x_message_list => l_msg
644: , x_return_status => l_ret_status
645: );
646: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649:
650: FOR j IN 1..p_routing_obj.gmd_ebi_routing_steps.Count LOOP

Line 647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

643: , x_message_list => l_msg
644: , x_return_status => l_ret_status
645: );
646: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649:
650: FOR j IN 1..p_routing_obj.gmd_ebi_routing_steps.Count LOOP
651: IF ( GMDRTVAL_PUB.check_routingstep_no(proutingstep_no => p_routing_obj.gmd_ebi_routing_steps(j).ROUTINGSTEP_NO

Line 743: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

739: , x_message_count => l_msg_count
740: , x_message_list => l_msg
741: , x_return_status => l_ret_status
742: );
743: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745: END IF;
746: ELSE
747: IF l_rout_tbl.Count > 1 THEN

Line 744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

740: , x_message_list => l_msg
741: , x_return_status => l_ret_status
742: );
743: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745: END IF;
746: ELSE
747: IF l_rout_tbl.Count > 1 THEN
748: l_rout_tbl.DELETE;

Line 902: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

898: , x_message_count => l_msg_count
899: , x_message_list => l_msg
900: , x_return_status => l_ret_status
901: );
902: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END IF;
905: IF l_routings_step_dep_tbl_insert.Count > 1 THEN
906: l_routings_step_dep_tbl_insert.DELETE;

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

899: , x_message_list => l_msg
900: , x_return_status => l_ret_status
901: );
902: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END IF;
905: IF l_routings_step_dep_tbl_insert.Count > 1 THEN
906: l_routings_step_dep_tbl_insert.DELETE;
907: END IF;

Line 917: l_ret_status = FND_API.G_RET_STS_SUCCESS ) THEN

913: ,x_return_status => l_ret_status
914: );
915:
916: IF ( p_routing_obj.gmd_ebi_rtg_step_dependency(i).ROUTINGSTEP_NO = p_routing_obj.gmd_ebi_routing_steps(j).routingstep_no AND
917: l_ret_status = FND_API.G_RET_STS_SUCCESS ) THEN
918: l_routings_step_dep_rec.ROUTINGSTEP_NO_UOM := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ROUTINGSTEP_NO_UOM;
919: l_routings_step_dep_rec.CHARGEABLE_IND := p_routing_obj.gmd_ebi_rtg_step_dependency(i).CHARGEABLE_IND;
920: l_routings_step_dep_rec.ROUTINGSTEP_NO := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ROUTINGSTEP_NO;
921: l_routings_step_dep_rec.DEP_ROUTINGSTEP_NO := p_routing_obj.gmd_ebi_rtg_step_dependency(i).DEP_ROUTINGSTEP_NO;

Line 1016: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

1012: , x_message_count =>l_msg_count
1013: , x_message_list => l_msg
1014: , x_return_status => l_ret_status
1015: );
1016: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;
1019: END IF;
1020: END LOOP;

Line 1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1013: , x_message_list => l_msg
1014: , x_return_status => l_ret_status
1015: );
1016: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;
1019: END IF;
1020: END LOOP;
1021: IF l_routings_step_dep_tbl_insert.Count > 1 THEN

Line 1036: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

1032: , x_message_count => l_msg_count
1033: , x_message_list => l_msg
1034: , x_return_status => l_ret_status
1035: );
1036: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: END IF;
1040: END IF;

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: , x_message_list => l_msg
1034: , x_return_status => l_ret_status
1035: );
1036: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: END IF;
1040: END IF;
1041: END LOOP;

Line 1043: x_return_status := FND_API.G_RET_STS_SUCCESS;

1039: END IF;
1040: END IF;
1041: END LOOP;
1042: END IF;
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: x_return_status := l_ret_status;
1047: IF l_msg IS NOT NULL THEN

Line 1108: x_return_status := FND_API.G_RET_STS_SUCCESS;

1104: l_item_desc VARCHAR2(1000);
1105: l_org_id NUMBER;
1106:
1107: BEGIN
1108: x_return_status := FND_API.G_RET_STS_SUCCESS;
1109: x_msg_data := NULL;
1110: SELECT category_id INTO l_category_id FROM FND_DOCUMENT_CATEGORIES_tl WHERE user_name='Formula Header Info';
1111: l_text := FND_MESSAGE.GET_STRING('GMD','GMD_FORMULA') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_NO;
1112: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_DESCRIPTION') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_DESC1;

Line 1343: x_return_status := FND_API.G_RET_STS_ERROR;

1339: END IF;
1340: EXCEPTION
1341:
1342: WHEN OTHERS THEN
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344: x_msg_data := SQLERRM;
1345: END;
1346:
1347: FUNCTION get_config_value (p_config_tbl inv_ebi_name_value_tbl,p_config_prop_name VARCHAR2 )

Line 1420: ,p_init_msg_list => FND_API.G_FALSE

1416: END IF;
1417: END LOOP;
1418: IF l_formula_delete_detail_tbl.Count > 0 THEN
1419: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail(p_api_version => 1.1
1420: ,p_init_msg_list => FND_API.G_FALSE
1421: ,p_commit => FND_API.G_FALSE
1422: ,p_called_from_forms => 'NO'
1423: ,x_return_status => l_ret_status
1424: ,x_msg_count => l_msg_count

Line 1421: ,p_commit => FND_API.G_FALSE

1417: END LOOP;
1418: IF l_formula_delete_detail_tbl.Count > 0 THEN
1419: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail(p_api_version => 1.1
1420: ,p_init_msg_list => FND_API.G_FALSE
1421: ,p_commit => FND_API.G_FALSE
1422: ,p_called_from_forms => 'NO'
1423: ,x_return_status => l_ret_status
1424: ,x_msg_count => l_msg_count
1425: ,x_msg_data => l_msg_data

Line 1428: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN

1424: ,x_msg_count => l_msg_count
1425: ,x_msg_data => l_msg_data
1426: ,p_formula_detail_tbl => l_formula_delete_detail_tbl);
1427:
1428: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431: END IF;
1432: x_line_delete_tbl := l_line_delete_tbl;

Line 1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1425: ,x_msg_data => l_msg_data
1426: ,p_formula_detail_tbl => l_formula_delete_detail_tbl);
1427:
1428: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431: END IF;
1432: x_line_delete_tbl := l_line_delete_tbl;
1433: x_return_status := l_ret_status;

Line 1436: x_return_status := FND_API.G_RET_STS_ERROR;

1432: x_line_delete_tbl := l_line_delete_tbl;
1433: x_return_status := l_ret_status;
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: IF l_msg_data IS NOT NULL THEN
1438: x_msg_data := l_msg_data;
1439: ELSE
1440: x_msg_data := SQLERRM||' AT DELETE FORMULA LINES';

Line 1471: RETURN FND_API.G_FALSE;

1467: P_parm_name => 'GMD_FORMULA_VERSION_CONTROL',
1468: P_parm_value => l_vers_cntrl,
1469: x_return_status => l_return_stat);
1470: IF(l_vers_cntrl = 'Y') THEN
1471: RETURN FND_API.G_FALSE;
1472: ELSE
1473: RETURN FND_API.G_TRUE;
1474: END IF;
1475: END;

Line 1473: RETURN FND_API.G_TRUE;

1469: x_return_status => l_return_stat);
1470: IF(l_vers_cntrl = 'Y') THEN
1471: RETURN FND_API.G_FALSE;
1472: ELSE
1473: RETURN FND_API.G_TRUE;
1474: END IF;
1475: END;
1476:
1477: /* ======================================================================== */

Line 1523: x_return_status := FND_API.G_RET_STS_SUCCESS;

1519: l_line_delete_tbl gmd_ebi_formula_line_del_tbl;
1520: l_form_type NUMBER;
1521:
1522: BEGIN
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: l_config_tbl := p_formula_obj.p_config_tbl;
1525: IF l_config_tbl IS NOT NULL AND l_config_tbl.Count>0 THEN
1526: l_zero_ing_qty := get_config_value(l_config_tbl,'ZERO_ING_ALLOWED');
1527: l_formula_owner_name := get_config_value(l_config_tbl,'FORMULA_OWNER_NAME');

Line 1655: IF(is_updateable( p_formula_obj.formula_header.owner_organization_id)=FND_API.G_FALSE)THEN

1651: l_formula_insert_header_tbl(l_insert_headerctr) := l_formula_insert_header_rec;
1652: l_insert_headerctr := l_insert_headerctr + 1;
1653: ELSE
1654: IF l_formula_update_header_tbl.Count = 0 THEN
1655: IF(is_updateable( p_formula_obj.formula_header.owner_organization_id)=FND_API.G_FALSE)THEN
1656: FND_MESSAGE.set_name('GMD','GMD_EBI_VERSION_ERROR');
1657: FND_MESSAGE.set_token('FORM', p_formula_obj.formula_header.formula_no);
1658: FND_MSG_PUB.add;
1659: RAISE FND_API.g_exc_error;

Line 1659: RAISE FND_API.g_exc_error;

1655: IF(is_updateable( p_formula_obj.formula_header.owner_organization_id)=FND_API.G_FALSE)THEN
1656: FND_MESSAGE.set_name('GMD','GMD_EBI_VERSION_ERROR');
1657: FND_MESSAGE.set_token('FORM', p_formula_obj.formula_header.formula_no);
1658: FND_MSG_PUB.add;
1659: RAISE FND_API.g_exc_error;
1660: END IF;
1661: l_formula_update_header_rec.formula_id := p_formula_obj.formula_header.formula_id;
1662: l_formula_update_header_rec.formula_no := p_formula_obj.formula_header.formula_no;
1663: l_formula_update_header_rec.formula_type := l_form_type;

Line 1851: ,p_init_msg_list => FND_API.G_FALSE

1847: END LOOP;
1848: IF ( l_formula_insert_header_tbl.COUNT > 0) THEN
1849: GMD_FORMULA_PUB.Insert_Formula
1850: ( p_api_version => 1.0
1851: ,p_init_msg_list => FND_API.G_FALSE
1852: ,p_commit => FND_API.G_FALSE
1853: ,p_called_from_forms => 'NO'
1854: ,x_return_status => l_ret_status
1855: ,x_msg_count => l_msg_count

Line 1852: ,p_commit => FND_API.G_FALSE

1848: IF ( l_formula_insert_header_tbl.COUNT > 0) THEN
1849: GMD_FORMULA_PUB.Insert_Formula
1850: ( p_api_version => 1.0
1851: ,p_init_msg_list => FND_API.G_FALSE
1852: ,p_commit => FND_API.G_FALSE
1853: ,p_called_from_forms => 'NO'
1854: ,x_return_status => l_ret_status
1855: ,x_msg_count => l_msg_count
1856: ,x_msg_data => l_msg_data

Line 1860: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN

1856: ,x_msg_data => l_msg_data
1857: ,p_formula_header_tbl => l_formula_insert_header_tbl
1858: ,p_allow_zero_ing_qty => l_zero_ing_qty
1859: );
1860: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1861: x_msg_data := l_msg_data;
1862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1863: END If;
1864:

Line 1862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1858: ,p_allow_zero_ing_qty => l_zero_ing_qty
1859: );
1860: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1861: x_msg_data := l_msg_data;
1862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1863: END If;
1864:
1865: END IF;
1866:

Line 1870: ,p_init_msg_list => FND_API.G_FALSE

1866:
1867: IF ( l_formula_update_header_tbl.COUNT > 0) THEN
1868: GMD_FORMULA_PUB.Update_FormulaHeader
1869: ( p_api_version => 2.0
1870: ,p_init_msg_list => FND_API.G_FALSE
1871: ,p_commit => FND_API.G_FALSE
1872: ,p_called_from_forms => 'NO'
1873: ,x_return_status => l_ret_status
1874: ,x_msg_count => l_msg_count

Line 1871: ,p_commit => FND_API.G_FALSE

1867: IF ( l_formula_update_header_tbl.COUNT > 0) THEN
1868: GMD_FORMULA_PUB.Update_FormulaHeader
1869: ( p_api_version => 2.0
1870: ,p_init_msg_list => FND_API.G_FALSE
1871: ,p_commit => FND_API.G_FALSE
1872: ,p_called_from_forms => 'NO'
1873: ,x_return_status => l_ret_status
1874: ,x_msg_count => l_msg_count
1875: ,x_msg_data => l_msg_data

Line 1879: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN

1875: ,x_msg_data => l_msg_data
1876: ,p_formula_header_tbl => l_formula_update_header_tbl
1877: );
1878:
1879: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1880: x_msg_data := l_msg_data;
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1882: END If;
1883: END IF;

Line 1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1877: );
1878:
1879: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1880: x_msg_data := l_msg_data;
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1882: END If;
1883: END IF;
1884:
1885:

Line 1894: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN

1890: ,x_return_status => l_ret_status
1891: ,x_msg_count => l_msg_count
1892: ,x_msg_data => l_msg_data
1893: );
1894: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1895: x_msg_data := l_msg_data;
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: END If;
1898: x_line_delete_tbl := l_line_delete_tbl;

Line 1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1892: ,x_msg_data => l_msg_data
1893: );
1894: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1895: x_msg_data := l_msg_data;
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: END If;
1898: x_line_delete_tbl := l_line_delete_tbl;
1899: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
1900: ( p_api_version => 2.0

Line 1901: ,p_init_msg_list => FND_API.G_FALSE

1897: END If;
1898: x_line_delete_tbl := l_line_delete_tbl;
1899: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
1900: ( p_api_version => 2.0
1901: ,p_init_msg_list => FND_API.G_FALSE
1902: ,p_commit => FND_API.G_FALSE
1903: ,p_called_from_forms => 'NO'
1904: ,x_return_status => l_ret_status
1905: ,x_msg_count => l_msg_count

Line 1902: ,p_commit => FND_API.G_FALSE

1898: x_line_delete_tbl := l_line_delete_tbl;
1899: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
1900: ( p_api_version => 2.0
1901: ,p_init_msg_list => FND_API.G_FALSE
1902: ,p_commit => FND_API.G_FALSE
1903: ,p_called_from_forms => 'NO'
1904: ,x_return_status => l_ret_status
1905: ,x_msg_count => l_msg_count
1906: ,x_msg_data => l_msg_data

Line 1909: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN

1905: ,x_msg_count => l_msg_count
1906: ,x_msg_data => l_msg_data
1907: ,p_formula_detail_tbl => l_formula_update_detail_tbl
1908: );
1909: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1910: x_msg_data := l_msg_data;
1911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1912: END If;
1913:

Line 1911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1907: ,p_formula_detail_tbl => l_formula_update_detail_tbl
1908: );
1909: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1910: x_msg_data := l_msg_data;
1911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1912: END If;
1913:
1914: END IF;
1915: IF ( l_formula_insert_detail_tbl.COUNT > 0) THEN

Line 1919: ,p_init_msg_list => FND_API.G_FALSE

1915: IF ( l_formula_insert_detail_tbl.COUNT > 0) THEN
1916:
1917: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail
1918: ( p_api_version => 1.0
1919: ,p_init_msg_list => FND_API.G_FALSE
1920: ,p_commit => FND_API.G_FALSE
1921: ,p_called_from_forms => 'NO'
1922: ,x_return_status => l_ret_status
1923: ,x_msg_count => l_msg_count

Line 1920: ,p_commit => FND_API.G_FALSE

1916:
1917: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail
1918: ( p_api_version => 1.0
1919: ,p_init_msg_list => FND_API.G_FALSE
1920: ,p_commit => FND_API.G_FALSE
1921: ,p_called_from_forms => 'NO'
1922: ,x_return_status => l_ret_status
1923: ,x_msg_count => l_msg_count
1924: ,x_msg_data => l_msg_data

Line 1928: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN

1924: ,x_msg_data => l_msg_data
1925: ,p_formula_detail_tbl =>l_formula_insert_detail_tbl
1926: );
1927: SELECT Count(*) INTO l_msg_count FROM fm_matl_dtl WHERE formula_id=470;
1928: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1929: x_msg_data := l_msg_data;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END If;
1932: END IF;

Line 1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1926: );
1927: SELECT Count(*) INTO l_msg_count FROM fm_matl_dtl WHERE formula_id=470;
1928: IF (l_ret_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
1929: x_msg_data := l_msg_data;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END If;
1932: END IF;
1933:
1934: EXCEPTION

Line 1935: WHEN FND_API.g_exc_error THEN

1931: END If;
1932: END IF;
1933:
1934: EXCEPTION
1935: WHEN FND_API.g_exc_error THEN
1936: x_return_status := FND_API.G_RET_STS_ERROR;
1937: fnd_msg_pub.count_and_get(
1938: p_encoded => fnd_api.g_false
1939: ,p_count => x_msg_count

Line 1936: x_return_status := FND_API.G_RET_STS_ERROR;

1932: END IF;
1933:
1934: EXCEPTION
1935: WHEN FND_API.g_exc_error THEN
1936: x_return_status := FND_API.G_RET_STS_ERROR;
1937: fnd_msg_pub.count_and_get(
1938: p_encoded => fnd_api.g_false
1939: ,p_count => x_msg_count
1940: ,p_data => x_msg_data

Line 1938: p_encoded => fnd_api.g_false

1934: EXCEPTION
1935: WHEN FND_API.g_exc_error THEN
1936: x_return_status := FND_API.G_RET_STS_ERROR;
1937: fnd_msg_pub.count_and_get(
1938: p_encoded => fnd_api.g_false
1939: ,p_count => x_msg_count
1940: ,p_data => x_msg_data
1941: );
1942: WHEN OTHERS THEN

Line 1943: x_return_status := FND_API.G_RET_STS_ERROR;

1939: ,p_count => x_msg_count
1940: ,p_data => x_msg_data
1941: );
1942: WHEN OTHERS THEN
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: IF x_msg_data IS NULL THEN
1945: x_msg_data := SQLERRM;
1946: END IF;
1947: END;

Line 1993: x_return_status := FND_API.G_RET_STS_SUCCESS;

1989: l_create_attachment VARCHAR2(1);
1990: l_line_delete_tbl gmd_ebi_formula_line_del_tbl;
1991:
1992: BEGIN
1993: x_return_status := FND_API.G_RET_STS_SUCCESS;
1994: FND_MSG_PUB.initialize();
1995: IF (p_recipe_tbl IS NOT NULL AND p_recipe_tbl.count>0) THEN
1996: FOR i IN 1..p_recipe_tbl.COUNT LOOP
1997: l_formula_obj_inp := p_recipe_tbl(i).formula_obj;

Line 2006: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN

2002: ,x_msg_count => l_msg_count
2003: ,x_return_status => l_ret_status
2004: ,x_msg_data => l_ret_msg
2005: );
2006: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN
2007: update_item_ids(
2008: p_formula_obj => l_formula_obj
2009: ,x_formula_obj => l_formula_obj_updated
2010: ,x_return_status => l_ret_status

Line 2014: RAISE FND_API.g_exc_error;

2010: ,x_return_status => l_ret_status
2011: ,x_msg_data => l_ret_msg
2012: );
2013: ELSE
2014: RAISE FND_API.g_exc_error;
2015: END IF;
2016: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN
2017: assign_items_to_org(
2018: p_formula_obj => l_formula_obj_updated

Line 2016: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN

2012: );
2013: ELSE
2014: RAISE FND_API.g_exc_error;
2015: END IF;
2016: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN
2017: assign_items_to_org(
2018: p_formula_obj => l_formula_obj_updated
2019: ,x_return_status => l_ret_status
2020: ,x_msg_data => l_ret_msg

Line 2023: RAISE FND_API.g_exc_error;

2019: ,x_return_status => l_ret_status
2020: ,x_msg_data => l_ret_msg
2021: );
2022: ELSE
2023: RAISE FND_API.g_exc_error;
2024: END IF;
2025: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS ) THEN
2026: IF l_formula_obj_updated.formula_details.Count < 2 THEN
2027: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');

Line 2025: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS ) THEN

2021: );
2022: ELSE
2023: RAISE FND_API.g_exc_error;
2024: END IF;
2025: IF ( l_ret_status = FND_API.G_RET_STS_SUCCESS ) THEN
2026: IF l_formula_obj_updated.formula_details.Count < 2 THEN
2027: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
2028: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_obj_updated.formula_header.formula_no);
2029: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_obj_updated.formula_header.formula_vers);

Line 2031: RAISE FND_API.G_EXC_ERROR;

2027: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
2028: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_obj_updated.formula_header.formula_no);
2029: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_obj_updated.formula_header.formula_vers);
2030: FND_MSG_PUB.Add;
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;
2033: sync_formula(
2034: p_formula_obj => l_formula_obj_updated
2035: ,x_line_delete_tbl => l_line_delete_tbl

Line 2041: RAISE FND_API.g_exc_error;

2037: ,x_msg_count => l_msg_count
2038: ,x_msg_data => l_ret_msg
2039: );
2040: ELSE
2041: RAISE FND_API.g_exc_error;
2042: END IF;
2043: IF (l_ret_status IN(FND_API.G_RET_STS_SUCCESS,'Q') ) THEN
2044: IF(p_recipe_tbl(i).routing_obj IS NOT NULL AND ( p_recipe_tbl(i).routing_obj.gmd_ebi_routing_steps.Count > 0 )) THEN
2045: IF (l_create_attachment = 'Y') THEN

Line 2043: IF (l_ret_status IN(FND_API.G_RET_STS_SUCCESS,'Q') ) THEN

2039: );
2040: ELSE
2041: RAISE FND_API.g_exc_error;
2042: END IF;
2043: IF (l_ret_status IN(FND_API.G_RET_STS_SUCCESS,'Q') ) THEN
2044: IF(p_recipe_tbl(i).routing_obj IS NOT NULL AND ( p_recipe_tbl(i).routing_obj.gmd_ebi_routing_steps.Count > 0 )) THEN
2045: IF (l_create_attachment = 'Y') THEN
2046: add_attachment(
2047: p_recipe_obj => p_recipe_tbl(i)

Line 2055: ,p_commit => FND_API.G_FALSE

2051: );
2052: ELSE
2053: sync_routings(
2054: p_routing_obj => p_recipe_tbl(i).routing_obj
2055: ,p_commit => FND_API.G_FALSE
2056: ,x_return_status => l_ret_status
2057: ,x_msg_count => l_msg_count
2058: ,x_msg_data => l_ret_msg
2059: );

Line 2074: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS AND (l_status IN(FND_API.G_RET_STS_SUCCESS,'Q'))) THEN

2070: ,x_return_status => l_ret_status
2071: ,x_msg_count => l_msg_count
2072: ,x_msg_data => l_ret_msg
2073: );
2074: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS AND (l_status IN(FND_API.G_RET_STS_SUCCESS,'Q'))) THEN
2075: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_SUCCESS,NULL,l_output,NULL);
2076: l_recipe_out_tbl.extend(1);
2077: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2078: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;

Line 2075: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_SUCCESS,NULL,l_output,NULL);

2071: ,x_msg_count => l_msg_count
2072: ,x_msg_data => l_ret_msg
2073: );
2074: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS AND (l_status IN(FND_API.G_RET_STS_SUCCESS,'Q'))) THEN
2075: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_SUCCESS,NULL,l_output,NULL);
2076: l_recipe_out_tbl.extend(1);
2077: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2078: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2079: ELSIF (l_ret_status = FND_API.G_RET_STS_SUCCESS AND (l_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q'))) THEN

Line 2079: ELSIF (l_ret_status = FND_API.G_RET_STS_SUCCESS AND (l_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q'))) THEN

2075: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_SUCCESS,NULL,l_output,NULL);
2076: l_recipe_out_tbl.extend(1);
2077: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2078: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2079: ELSIF (l_ret_status = FND_API.G_RET_STS_SUCCESS AND (l_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q'))) THEN
2080: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_ERROR,l_error,l_output,NULL);
2081: l_recipe_out_tbl.extend(1);
2082: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2083: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;

Line 2080: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_ERROR,l_error,l_output,NULL);

2076: l_recipe_out_tbl.extend(1);
2077: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2078: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2079: ELSIF (l_ret_status = FND_API.G_RET_STS_SUCCESS AND (l_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q'))) THEN
2080: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_ERROR,l_error,l_output,NULL);
2081: l_recipe_out_tbl.extend(1);
2082: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2083: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2084: ELSE

Line 2085: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_ERROR,l_ret_msg,l_output,NULL);

2081: l_recipe_out_tbl.extend(1);
2082: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2083: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2084: ELSE
2085: l_recipe_out_obj := gmd_ebi_recipe_output_obj(NULL,NULL,FND_API.G_RET_STS_ERROR,l_ret_msg,l_output,NULL);
2086: l_recipe_out_tbl.extend(1);
2087: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2088: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2089: END IF;

Line 2090: IF l_status NOT IN (FND_API.G_RET_STS_SUCCESS,'Q') THEN

2086: l_recipe_out_tbl.extend(1);
2087: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2088: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2089: END IF;
2090: IF l_status NOT IN (FND_API.G_RET_STS_SUCCESS,'Q') THEN
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: x_msg_data := x_msg_data || l_recipe_out_obj.error_msg || fnd_global.newline;
2093: END IF;
2094: IF p_commit = FND_API.G_TRUE THEN

Line 2091: x_return_status := FND_API.G_RET_STS_ERROR;

2087: l_recipe_out_tbl(l_recipe_out_Ctr):= l_recipe_out_obj;
2088: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2089: END IF;
2090: IF l_status NOT IN (FND_API.G_RET_STS_SUCCESS,'Q') THEN
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: x_msg_data := x_msg_data || l_recipe_out_obj.error_msg || fnd_global.newline;
2093: END IF;
2094: IF p_commit = FND_API.G_TRUE THEN
2095: COMMIT;

Line 2094: IF p_commit = FND_API.G_TRUE THEN

2090: IF l_status NOT IN (FND_API.G_RET_STS_SUCCESS,'Q') THEN
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: x_msg_data := x_msg_data || l_recipe_out_obj.error_msg || fnd_global.newline;
2093: END IF;
2094: IF p_commit = FND_API.G_TRUE THEN
2095: COMMIT;
2096: END IF;
2097: END LOOP;
2098: ELSE

Line 2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2096: END IF;
2097: END LOOP;
2098: ELSE
2099: x_msg_data := FND_MESSAGE.GET_STRING('GMD','GMD_EBI_NO_RECORD');
2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2101: END IF;
2102: x_recipe_tbl := l_recipe_out_tbl;
2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN

Line 2104: WHEN FND_API.G_EXC_ERROR THEN

2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2101: END IF;
2102: x_recipe_tbl := l_recipe_out_tbl;
2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: IF l_ret_msg IS NULL THEN
2106: x_return_status := FND_API.G_RET_STS_ERROR;
2107: FND_MSG_PUB.count_and_get(
2108: p_encoded => FND_API.g_false

Line 2106: x_return_status := FND_API.G_RET_STS_ERROR;

2102: x_recipe_tbl := l_recipe_out_tbl;
2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: IF l_ret_msg IS NULL THEN
2106: x_return_status := FND_API.G_RET_STS_ERROR;
2107: FND_MSG_PUB.count_and_get(
2108: p_encoded => FND_API.g_false
2109: ,p_count => x_msg_count
2110: ,p_data => x_msg_data

Line 2108: p_encoded => FND_API.g_false

2104: WHEN FND_API.G_EXC_ERROR THEN
2105: IF l_ret_msg IS NULL THEN
2106: x_return_status := FND_API.G_RET_STS_ERROR;
2107: FND_MSG_PUB.count_and_get(
2108: p_encoded => FND_API.g_false
2109: ,p_count => x_msg_count
2110: ,p_data => x_msg_data
2111: );
2112: ELSE

Line 2113: x_return_status := FND_API.G_RET_STS_ERROR;

2109: ,p_count => x_msg_count
2110: ,p_data => x_msg_data
2111: );
2112: ELSE
2113: x_return_status := FND_API.G_RET_STS_ERROR;
2114: x_msg_data := l_ret_msg;
2115: END IF;
2116: WHEN OTHERS THEN
2117: IF x_msg_data IS NULL THEN

Line 2118: x_return_status := FND_API.G_RET_STS_ERROR;

2114: x_msg_data := l_ret_msg;
2115: END IF;
2116: WHEN OTHERS THEN
2117: IF x_msg_data IS NULL THEN
2118: x_return_status := FND_API.G_RET_STS_ERROR;
2119: x_msg_data := SQLERRM || 'AT SYNC RECIPE API';
2120: END IF;
2121: END;
2122: