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_SPEC_MATCH_MIG_GRP dependencies on FND_API

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

129: l_match_spec_rec cr_match_spec%ROWTYPE;
130:
131: BEGIN
132:
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: FND_MSG_PUB.initialize;
135: l_position := '010';
136:
137: IF p_inventory_spec_rec.item_id IS NULL OR p_inventory_spec_rec.date_effective IS NULL THEN

Line 241: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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
245: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_inventory_spec_rec.lot_id));

Line 242: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

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

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

Line 256: 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;
260:

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_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;
260:
261:

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: l_match_spec_rec cr_match_spec%ROWTYPE;
347:
348: BEGIN
349:
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351: FND_MSG_PUB.initialize;
352: l_position := '010';
353:
354: IF p_customer_spec_rec.item_id IS NULL OR p_customer_spec_rec.cust_id IS NULL OR

Line 468: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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
472: gmd_api_pub.log_message('GMD_NO_ORGN_WHSE');

Line 469: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 473: 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
477: gmd_api_pub.log_message('GMD_INVALID_WHSE','WHSE',p_customer_spec_rec.whse_code);

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

Line 478: 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
482: gmd_api_pub.log_message('GMD_INVALID_ORDER_LINE','LINE',to_char(p_customer_spec_rec.order_line_id));

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

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

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

Line 488: 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:
492: WHEN OTHERS THEN

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

Line 494: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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;
498:

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
498:
499: FUNCTION FIND_CUST_OR_INV_SPEC(

Line 555: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_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 ;
559:

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
559:
560:

Line 666: x_return_status := FND_API.G_RET_STS_SUCCESS;

662:
663: BEGIN
664:
665:
666: x_return_status := FND_API.G_RET_STS_SUCCESS;
667: FND_MSG_PUB.initialize;
668: l_position := '010';
669:
670: IF p_wip_spec_rec.item_id IS NULL OR p_wip_spec_rec.orgn_code IS NULL OR p_wip_spec_rec.date_effective IS NULL THEN

Line 884: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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
888: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_wip_spec_rec.item_id));

Line 885: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 919: 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;
923:

Line 920: x_return_status := FND_API.G_RET_STS_UNEXP_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;
923:
924: FUNCTION FIND_WIP_OR_INV_SPEC(

Line 978: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_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 ;
982:

Line 979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
982:
983:

Line 1056: x_return_status := FND_API.G_RET_STS_SUCCESS;

1052: l_match_spec_rec cr_match_spec%ROWTYPE;
1053:
1054: BEGIN
1055:
1056: x_return_status := FND_API.G_RET_STS_SUCCESS;
1057: FND_MSG_PUB.initialize;
1058: l_position := '010';
1059:
1060: IF p_supplier_spec_rec.item_id IS NULL

Line 1152: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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
1156: gmd_api_pub.log_message('GMD_NO_ORGN_WHSE');

Line 1153: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1157: 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
1161: gmd_api_pub.log_message('GMD_INVALID_WHSE','WHSE',p_supplier_spec_rec.whse_code);

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

Line 1162: 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
1166: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_supplier_spec_rec.item_id));

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

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

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

Line 1172: 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;
1176:

Line 1173: x_return_status := FND_API.G_RET_STS_UNEXP_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;
1176:
1177:

Line 1237: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_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 ;
1241:

Line 1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
1241:
1242:

Line 1338: x_return_status := FND_API.G_RET_STS_SUCCESS;

1334: l_result_in_spec BOOLEAN := TRUE;
1335: l_in_spec VARCHAR2(1); -- returned by the results API
1336: BEGIN
1337:
1338: x_return_status := FND_API.G_RET_STS_SUCCESS;
1339: FND_MSG_PUB.initialize;
1340: l_position := '010';
1341:
1342: IF p_spec_id IS NULL THEN

Line 1454: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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));
1458: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1455: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1458: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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);
1462: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1459: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1462: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

Line 1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:
1466:
1467: END gmd_spec_match_mig_grp;