DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_API_PUB

Line 240: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');

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

Line 245: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_inventory_spec_rec.lot_id));

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

Line 250: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_inventory_spec_rec.item_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
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

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

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;

Line 467: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_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

Line 472: gmd_api_pub.log_message('GMD_NO_ORGN_WHSE');

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

Line 477: gmd_api_pub.log_message('GMD_INVALID_WHSE','WHSE',p_customer_spec_rec.whse_code);

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

Line 482: gmd_api_pub.log_message('GMD_INVALID_ORDER_LINE','LINE',to_char(p_customer_spec_rec.order_line_id));

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

Line 487: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_customer_spec_rec.item_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
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:

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

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;

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

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 ;

Line 883: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_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

Line 888: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_wip_spec_rec.item_id));

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

Line 893: gmd_api_pub.log_message('GMD_INVALID_FORMULA','FORMULA',to_char(p_wip_spec_rec.formula_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
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

Line 898: gmd_api_pub.log_message('GMD_INVALID_ROUTING','ROUTING',to_char(p_wip_spec_rec.routing_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
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

Line 903: gmd_api_pub.log_message('GMD_INVALID_OPRN','OPRN',to_char(p_wip_spec_rec.oprn_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
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

Line 908: gmd_api_pub.log_message('GMD_INVALID_STEP','STEP',to_char(p_wip_spec_rec.step_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
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

Line 913: gmd_api_pub.log_message('GMD_INVALID_RECIPE','RECIPE',to_char(p_wip_spec_rec.recipe_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
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

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

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;

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

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 ;

Line 1151: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_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

Line 1156: gmd_api_pub.log_message('GMD_NO_ORGN_WHSE');

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

Line 1161: gmd_api_pub.log_message('GMD_INVALID_WHSE','WHSE',p_supplier_spec_rec.whse_code);

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

Line 1166: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_supplier_spec_rec.item_id));

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

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

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;

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

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 ;

Line 1453: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_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));

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

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