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_MESSAGE

Line 147: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

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(
151: p_encoded => FND_API.g_false

Line 148: FND_MESSAGE.set_token('COL_VALUE', p_formula_obj.formula_header.OWNER_ORGANIZATION_CODE);

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(
151: p_encoded => FND_API.g_false
152: ,p_count => x_msg_count

Line 1111: l_text := FND_MESSAGE.GET_STRING('GMD','GMD_FORMULA') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_NO;

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;
1113: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STATUS') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_STATUS;
1114: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_FACILITY')|| ':';
1115: /*Code modification for Bug No.9750340 started here */

Line 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;

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;
1113: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STATUS') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_STATUS;
1114: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_FACILITY')|| ':';
1115: /*Code modification for Bug No.9750340 started here */
1116: /*Code modification for Bug No.9852048 started here */

Line 1113: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STATUS') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_STATUS;

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;
1113: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STATUS') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_STATUS;
1114: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_FACILITY')|| ':';
1115: /*Code modification for Bug No.9750340 started here */
1116: /*Code modification for Bug No.9852048 started here */
1117: IF p_recipe_obj.manufacturing_plant IS NOT NULL THEN

Line 1114: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_FACILITY')|| ':';

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;
1113: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STATUS') ||':'|| p_recipe_obj.formula_obj.formula_header.FORMULA_STATUS;
1114: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_FACILITY')|| ':';
1115: /*Code modification for Bug No.9750340 started here */
1116: /*Code modification for Bug No.9852048 started here */
1117: IF p_recipe_obj.manufacturing_plant IS NOT NULL THEN
1118: FOR i IN 1..p_recipe_obj.manufacturing_plant.Count LOOP

Line 1131: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STEPNO') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).ROUTINGSTEP_NO;

1127: /*Code modification for Bug No.9750340 ends here*/
1128: l_text := l_text || l_new_line;
1129: IF p_recipe_obj.routing_obj IS NOT NULL THEN
1130: FOR i IN 1..p_recipe_obj.routing_obj.gmd_ebi_routing_steps.Count LOOP
1131: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STEPNO') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).ROUTINGSTEP_NO;
1132: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_INSTRUCTION') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).instructions;
1133: IF p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref IS NOT NULL THEN
1134: l_text_ing := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_INGREDIENTS'),17,l_space);
1135: l_text_ing := l_text_ing || l_new_line ||LPad('-------------------',25,l_space);

Line 1132: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_INSTRUCTION') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).instructions;

1128: l_text := l_text || l_new_line;
1129: IF p_recipe_obj.routing_obj IS NOT NULL THEN
1130: FOR i IN 1..p_recipe_obj.routing_obj.gmd_ebi_routing_steps.Count LOOP
1131: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STEPNO') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).ROUTINGSTEP_NO;
1132: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_INSTRUCTION') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).instructions;
1133: IF p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref IS NOT NULL THEN
1134: l_text_ing := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_INGREDIENTS'),17,l_space);
1135: l_text_ing := l_text_ing || l_new_line ||LPad('-------------------',25,l_space);
1136: l_text_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_COPRODUCTS'),17,l_space);

Line 1134: l_text_ing := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_INGREDIENTS'),17,l_space);

1130: FOR i IN 1..p_recipe_obj.routing_obj.gmd_ebi_routing_steps.Count LOOP
1131: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_STEPNO') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).ROUTINGSTEP_NO;
1132: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_INSTRUCTION') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).instructions;
1133: IF p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref IS NOT NULL THEN
1134: l_text_ing := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_INGREDIENTS'),17,l_space);
1135: l_text_ing := l_text_ing || l_new_line ||LPad('-------------------',25,l_space);
1136: l_text_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_COPRODUCTS'),17,l_space);
1137: l_text_products := l_text_products || l_new_line ||LPad('-------------------',25,l_space);
1138: l_text_by_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_BYPRODUCTS'),17,l_space);

Line 1136: l_text_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_COPRODUCTS'),17,l_space);

1132: l_text := l_text || l_new_line || FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_INSTRUCTION') ||':'||p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).instructions;
1133: IF p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref IS NOT NULL THEN
1134: l_text_ing := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_INGREDIENTS'),17,l_space);
1135: l_text_ing := l_text_ing || l_new_line ||LPad('-------------------',25,l_space);
1136: l_text_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_COPRODUCTS'),17,l_space);
1137: l_text_products := l_text_products || l_new_line ||LPad('-------------------',25,l_space);
1138: l_text_by_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_BYPRODUCTS'),17,l_space);
1139: l_text_by_products := l_text_by_products || l_new_line ||LPad('-------------------',25,l_space);
1140: FOR j IN 1..p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref.Count LOOP

Line 1138: l_text_by_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_BYPRODUCTS'),17,l_space);

1134: l_text_ing := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_INGREDIENTS'),17,l_space);
1135: l_text_ing := l_text_ing || l_new_line ||LPad('-------------------',25,l_space);
1136: l_text_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_COPRODUCTS'),17,l_space);
1137: l_text_products := l_text_products || l_new_line ||LPad('-------------------',25,l_space);
1138: l_text_by_products := l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_BYPRODUCTS'),17,l_space);
1139: l_text_by_products := l_text_by_products || l_new_line ||LPad('-------------------',25,l_space);
1140: FOR j IN 1..p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref.Count LOOP
1141: l_bus_comp_id := p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref(j).business_component_id;
1142: l_line_id := p_recipe_obj.routing_obj.gmd_ebi_routing_steps(i).gmd_ebi_formula_line_ref(j).formula_line_id;

Line 1148: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;

1144: IF ( l_bus_comp_id = p_recipe_obj.formula_obj.formula_details(k).BUSINESS_COMPONENT_ID
1145: OR l_line_id = p_recipe_obj.formula_obj.formula_details(k).FORMULALINE_ID) THEN
1146: l_org_id := get_org_id(p_recipe_obj.formula_obj.formula_header.OWNER_ORGANIZATION_CODE);
1147: IF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = -1) THEN
1148: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1149: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1150: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1151: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space) ||':'||l_item_desc;
1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;

Line 1150: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;

1146: l_org_id := get_org_id(p_recipe_obj.formula_obj.formula_header.OWNER_ORGANIZATION_CODE);
1147: IF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = -1) THEN
1148: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1149: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1150: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1151: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space) ||':'||l_item_desc;
1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1154: l_text_ing := l_text_ing || l_new_line;

Line 1151: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space) ||':'||l_item_desc;

1147: IF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = -1) THEN
1148: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1149: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1150: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1151: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space) ||':'||l_item_desc;
1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1154: l_text_ing := l_text_ing || l_new_line;
1155: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 1) THEN

Line 1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;

1148: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1149: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1150: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1151: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space) ||':'||l_item_desc;
1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1154: l_text_ing := l_text_ing || l_new_line;
1155: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 1) THEN
1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;

Line 1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;

1149: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1150: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1151: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space) ||':'||l_item_desc;
1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1154: l_text_ing := l_text_ing || l_new_line;
1155: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 1) THEN
1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;

Line 1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;

1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1154: l_text_ing := l_text_ing || l_new_line;
1155: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 1) THEN
1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1158: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1159: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;

Line 1158: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;

1154: l_text_ing := l_text_ing || l_new_line;
1155: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 1) THEN
1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1158: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1159: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1162: l_text_products := l_text_products || l_new_line;

Line 1159: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;

1155: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 1) THEN
1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1158: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1159: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1162: l_text_products := l_text_products || l_new_line;
1163: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 2) THEN

Line 1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;

1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1158: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1159: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1162: l_text_products := l_text_products || l_new_line;
1163: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 2) THEN
1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;

Line 1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;

1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1158: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1159: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1162: l_text_products := l_text_products || l_new_line;
1163: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 2) THEN
1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;

Line 1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;

1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1162: l_text_products := l_text_products || l_new_line;
1163: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 2) THEN
1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1166: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1167: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1168: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;

Line 1166: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;

1162: l_text_products := l_text_products || l_new_line;
1163: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 2) THEN
1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1166: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1167: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1168: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1169: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1170: l_text_by_products := l_text_by_products || l_new_line;

Line 1167: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;

1163: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 2) THEN
1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1166: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1167: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1168: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1169: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1170: l_text_by_products := l_text_by_products || l_new_line;
1171: END IF;

Line 1168: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;

1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1166: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1167: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1168: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1169: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1170: l_text_by_products := l_text_by_products || l_new_line;
1171: END IF;
1172: END IF;

Line 1169: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;

1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1166: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1167: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1168: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1169: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1170: l_text_by_products := l_text_by_products || l_new_line;
1171: END IF;
1172: END IF;
1173: END LOOP;

Line 1656: FND_MESSAGE.set_name('GMD','GMD_EBI_VERSION_ERROR');

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;
1660: END IF;

Line 1657: FND_MESSAGE.set_token('FORM', p_formula_obj.formula_header.formula_no);

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;
1660: END IF;
1661: l_formula_update_header_rec.formula_id := p_formula_obj.formula_header.formula_id;

Line 2027: FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');

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);
2030: FND_MSG_PUB.Add;
2031: RAISE FND_API.G_EXC_ERROR;

Line 2028: FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_obj_updated.formula_header.formula_no);

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);
2030: FND_MSG_PUB.Add;
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;

Line 2029: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_obj_updated.formula_header.formula_vers);

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);
2030: FND_MSG_PUB.Add;
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;
2033: sync_formula(

Line 2099: x_msg_data := FND_MESSAGE.GET_STRING('GMD','GMD_EBI_NO_RECORD');

2095: COMMIT;
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