236: END IF;
237:
238: EXCEPTION
239: WHEN REQ_FIELDS_MISSING THEN
240: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');
241: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243: RETURN FALSE;
244: WHEN INVALID_LOT THEN
241: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243: RETURN FALSE;
244: WHEN INVALID_LOT THEN
245: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_inventory_spec_rec.lot_id));
246: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: RETURN FALSE;
249: WHEN INVALID_ITEM THEN
246: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: RETURN FALSE;
249: WHEN INVALID_ITEM THEN
250: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_inventory_spec_rec.item_id));
251: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
252: x_return_status := FND_API.G_RET_STS_ERROR ;
253: RETURN FALSE;
254: WHEN OTHERS THEN
251: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
252: x_return_status := FND_API.G_RET_STS_ERROR ;
253: RETURN FALSE;
254: WHEN OTHERS THEN
255: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
256: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: RETURN FALSE;
259: END FIND_INVENTORY_SPEC;
463:
464:
465: EXCEPTION
466: WHEN REQ_FIELDS_MISSING THEN
467: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC');
468: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470: RETURN FALSE;
471: WHEN NO_ORGN_WHSE THEN
468: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470: RETURN FALSE;
471: WHEN NO_ORGN_WHSE THEN
472: gmd_api_pub.log_message('GMD_NO_ORGN_WHSE');
473: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
474: x_return_status := FND_API.G_RET_STS_ERROR ;
475: RETURN FALSE;
476: WHEN INVALID_WHSE THEN
473: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
474: x_return_status := FND_API.G_RET_STS_ERROR ;
475: RETURN FALSE;
476: WHEN INVALID_WHSE THEN
477: gmd_api_pub.log_message('GMD_INVALID_WHSE','WHSE',p_customer_spec_rec.whse_code);
478: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: RETURN FALSE;
481: WHEN INVALID_ORDER_LINE THEN
478: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: RETURN FALSE;
481: WHEN INVALID_ORDER_LINE THEN
482: gmd_api_pub.log_message('GMD_INVALID_ORDER_LINE','LINE',to_char(p_customer_spec_rec.order_line_id));
483: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: RETURN FALSE;
486: WHEN INVALID_ITEM THEN
483: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: RETURN FALSE;
486: WHEN INVALID_ITEM THEN
487: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_customer_spec_rec.item_id));
488: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
489: x_return_status := FND_API.G_RET_STS_ERROR ;
490: RETURN FALSE;
491:
489: x_return_status := FND_API.G_RET_STS_ERROR ;
490: RETURN FALSE;
491:
492: WHEN OTHERS THEN
493: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
494: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496: RETURN FALSE;
497: END FIND_CUSTOMER_SPEC;
550: RETURN FALSE;
551: END IF;
552:
553: EXCEPTION WHEN OTHERS THEN
554: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUST_OR_INV_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
555: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: RETURN FALSE;
558: END FIND_CUST_OR_INV_SPEC ;
879: END IF;
880:
881: EXCEPTION
882: WHEN REQ_FIELDS_MISSING THEN
883: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC');
884: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
885: x_return_status := FND_API.G_RET_STS_ERROR ;
886: RETURN FALSE;
887: WHEN INVALID_ITEM THEN
884: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
885: x_return_status := FND_API.G_RET_STS_ERROR ;
886: RETURN FALSE;
887: WHEN INVALID_ITEM THEN
888: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_wip_spec_rec.item_id));
889: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
890: x_return_status := FND_API.G_RET_STS_ERROR ;
891: RETURN FALSE;
892: WHEN INVALID_FORMULA THEN
889: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
890: x_return_status := FND_API.G_RET_STS_ERROR ;
891: RETURN FALSE;
892: WHEN INVALID_FORMULA THEN
893: gmd_api_pub.log_message('GMD_INVALID_FORMULA','FORMULA',to_char(p_wip_spec_rec.formula_id));
894: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
895: x_return_status := FND_API.G_RET_STS_ERROR ;
896: RETURN FALSE;
897: WHEN INVALID_ROUTING THEN
894: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
895: x_return_status := FND_API.G_RET_STS_ERROR ;
896: RETURN FALSE;
897: WHEN INVALID_ROUTING THEN
898: gmd_api_pub.log_message('GMD_INVALID_ROUTING','ROUTING',to_char(p_wip_spec_rec.routing_id));
899: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
900: x_return_status := FND_API.G_RET_STS_ERROR ;
901: RETURN FALSE;
902: WHEN INVALID_OPRN THEN
899: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
900: x_return_status := FND_API.G_RET_STS_ERROR ;
901: RETURN FALSE;
902: WHEN INVALID_OPRN THEN
903: gmd_api_pub.log_message('GMD_INVALID_OPRN','OPRN',to_char(p_wip_spec_rec.oprn_id));
904: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
905: x_return_status := FND_API.G_RET_STS_ERROR ;
906: RETURN FALSE;
907: WHEN INVALID_STEP THEN
904: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
905: x_return_status := FND_API.G_RET_STS_ERROR ;
906: RETURN FALSE;
907: WHEN INVALID_STEP THEN
908: gmd_api_pub.log_message('GMD_INVALID_STEP','STEP',to_char(p_wip_spec_rec.step_id));
909: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: RETURN FALSE;
912: WHEN INVALID_RECIPE THEN
909: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: RETURN FALSE;
912: WHEN INVALID_RECIPE THEN
913: gmd_api_pub.log_message('GMD_INVALID_RECIPE','RECIPE',to_char(p_wip_spec_rec.recipe_id));
914: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: RETURN FALSE;
917: WHEN OTHERS THEN
914: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: RETURN FALSE;
917: WHEN OTHERS THEN
918: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
919: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
921: RETURN FALSE;
922: END FIND_WIP_SPEC;
973: RETURN FALSE;
974: END IF;
975:
976: EXCEPTION WHEN OTHERS THEN
977: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_OR_INV_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
978: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
980: RETURN FALSE;
981: END FIND_WIP_OR_INV_SPEC ;
1147:
1148:
1149: EXCEPTION
1150: WHEN REQ_FIELDS_MISSING THEN
1151: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_SPEC');
1152: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: RETURN FALSE;
1155: WHEN NO_ORGN_WHSE THEN
1152: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: RETURN FALSE;
1155: WHEN NO_ORGN_WHSE THEN
1156: gmd_api_pub.log_message('GMD_NO_ORGN_WHSE');
1157: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1158: x_return_status := FND_API.G_RET_STS_ERROR ;
1159: RETURN FALSE;
1160: WHEN INVALID_WHSE THEN
1157: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1158: x_return_status := FND_API.G_RET_STS_ERROR ;
1159: RETURN FALSE;
1160: WHEN INVALID_WHSE THEN
1161: gmd_api_pub.log_message('GMD_INVALID_WHSE','WHSE',p_supplier_spec_rec.whse_code);
1162: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1163: x_return_status := FND_API.G_RET_STS_ERROR ;
1164: RETURN FALSE;
1165: WHEN INVALID_ITEM THEN
1162: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1163: x_return_status := FND_API.G_RET_STS_ERROR ;
1164: RETURN FALSE;
1165: WHEN INVALID_ITEM THEN
1166: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_supplier_spec_rec.item_id));
1167: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1168: x_return_status := FND_API.G_RET_STS_ERROR ;
1169: RETURN FALSE;
1170: WHEN OTHERS THEN
1167: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1168: x_return_status := FND_API.G_RET_STS_ERROR ;
1169: RETURN FALSE;
1170: WHEN OTHERS THEN
1171: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1172: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1174: RETURN FALSE;
1175: END FIND_SUPPLIER_SPEC;
1232: RETURN FALSE;
1233: END IF;
1234:
1235: EXCEPTION WHEN OTHERS THEN
1236: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1237: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1239: RETURN FALSE;
1240: END FIND_SUPPLIER_OR_INV_SPEC ;
1449:
1450:
1451: EXCEPTION
1452: WHEN REQ_FIELDS_MISSING THEN
1453: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1454: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1455: x_return_status := FND_API.G_RET_STS_ERROR ;
1456: WHEN INVALID_LOT THEN
1457: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_id));
1453: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1454: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1455: x_return_status := FND_API.G_RET_STS_ERROR ;
1456: WHEN INVALID_LOT THEN
1457: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_id));
1458: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1459: x_return_status := FND_API.G_RET_STS_ERROR ;
1460: WHEN OTHERS THEN
1461: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1457: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_id));
1458: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1459: x_return_status := FND_API.G_RET_STS_ERROR ;
1460: WHEN OTHERS THEN
1461: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1462: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1464: END get_result_match_for_spec ;
1465: