DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_API_PUB

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

229: END IF;
230:
231: EXCEPTION
232: WHEN REQ_FIELDS_MISSING THEN
233: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');
234: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: RETURN FALSE;
237: WHEN INVALID_LOT THEN

Line 238: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_inventory_spec_rec.lot_number));

234: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: RETURN FALSE;
237: WHEN INVALID_LOT THEN
238: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_inventory_spec_rec.lot_number));
239: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
240: x_return_status := FND_API.G_RET_STS_ERROR ;
241: RETURN FALSE;
242: WHEN INVALID_ITEM THEN

Line 243: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_inventory_spec_rec.inventory_item_id));

239: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
240: x_return_status := FND_API.G_RET_STS_ERROR ;
241: RETURN FALSE;
242: WHEN INVALID_ITEM THEN
243: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_inventory_spec_rec.inventory_item_id));
244: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246: RETURN FALSE;
247: WHEN OTHERS THEN

Line 248: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

244: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246: RETURN FALSE;
247: WHEN OTHERS THEN
248: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
249: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: RETURN FALSE;
252: END FIND_INVENTORY_SPEC;

Line 424: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC');

420:
421:
422: EXCEPTION
423: WHEN REQ_FIELDS_MISSING THEN
424: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC');
425: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
426: x_return_status := FND_API.G_RET_STS_ERROR ;
427: RETURN FALSE;
428: WHEN INVALID_ORDER_LINE THEN

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

425: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
426: x_return_status := FND_API.G_RET_STS_ERROR ;
427: RETURN FALSE;
428: WHEN INVALID_ORDER_LINE THEN
429: gmd_api_pub.log_message('GMD_INVALID_ORDER_LINE','LINE',to_char(p_customer_spec_rec.order_line_id));
430: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: RETURN FALSE;
433: WHEN INVALID_ITEM THEN

Line 434: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_customer_spec_rec.inventory_item_id));

430: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: RETURN FALSE;
433: WHEN INVALID_ITEM THEN
434: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_customer_spec_rec.inventory_item_id));
435: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: RETURN FALSE;
438: WHEN OTHERS THEN

Line 439: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

435: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: RETURN FALSE;
438: WHEN OTHERS THEN
439: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
440: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: RETURN FALSE;
443: END FIND_CUSTOMER_SPEC;

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

496: RETURN FALSE;
497: END IF;
498:
499: EXCEPTION WHEN OTHERS THEN
500: 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);
501: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
503: RETURN FALSE;
504: END FIND_CUST_OR_INV_SPEC ;

Line 876: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC');

872: END IF;
873:
874: EXCEPTION
875: WHEN REQ_FIELDS_MISSING THEN
876: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC');
877: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: RETURN FALSE;
880: WHEN INVALID_ITEM THEN

Line 881: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_wip_spec_rec.inventory_item_id));

877: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: RETURN FALSE;
880: WHEN INVALID_ITEM THEN
881: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_wip_spec_rec.inventory_item_id));
882: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
883: x_return_status := FND_API.G_RET_STS_ERROR ;
884: RETURN FALSE;
885: WHEN INVALID_FORMULA THEN

Line 886: gmd_api_pub.log_message('GMD_INVALID_FORMULA','FORMULA',to_char(p_wip_spec_rec.formula_id));

882: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
883: x_return_status := FND_API.G_RET_STS_ERROR ;
884: RETURN FALSE;
885: WHEN INVALID_FORMULA THEN
886: gmd_api_pub.log_message('GMD_INVALID_FORMULA','FORMULA',to_char(p_wip_spec_rec.formula_id));
887: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
888: x_return_status := FND_API.G_RET_STS_ERROR ;
889: RETURN FALSE;
890: WHEN INVALID_ROUTING THEN

Line 891: gmd_api_pub.log_message('GMD_INVALID_ROUTING','ROUTING',to_char(p_wip_spec_rec.routing_id));

887: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
888: x_return_status := FND_API.G_RET_STS_ERROR ;
889: RETURN FALSE;
890: WHEN INVALID_ROUTING THEN
891: gmd_api_pub.log_message('GMD_INVALID_ROUTING','ROUTING',to_char(p_wip_spec_rec.routing_id));
892: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
893: x_return_status := FND_API.G_RET_STS_ERROR ;
894: RETURN FALSE;
895: WHEN INVALID_OPRN THEN

Line 896: gmd_api_pub.log_message('GMD_INVALID_OPRN','OPRN',to_char(p_wip_spec_rec.oprn_id));

892: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
893: x_return_status := FND_API.G_RET_STS_ERROR ;
894: RETURN FALSE;
895: WHEN INVALID_OPRN THEN
896: gmd_api_pub.log_message('GMD_INVALID_OPRN','OPRN',to_char(p_wip_spec_rec.oprn_id));
897: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: RETURN FALSE;
900: WHEN INVALID_STEP THEN

Line 901: gmd_api_pub.log_message('GMD_INVALID_STEP','STEP',to_char(p_wip_spec_rec.step_id));

897: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: RETURN FALSE;
900: WHEN INVALID_STEP THEN
901: gmd_api_pub.log_message('GMD_INVALID_STEP','STEP',to_char(p_wip_spec_rec.step_id));
902: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
903: x_return_status := FND_API.G_RET_STS_ERROR ;
904: RETURN FALSE;
905: WHEN INVALID_RECIPE THEN

Line 906: gmd_api_pub.log_message('GMD_INVALID_RECIPE','RECIPE',to_char(p_wip_spec_rec.recipe_id));

902: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
903: x_return_status := FND_API.G_RET_STS_ERROR ;
904: RETURN FALSE;
905: WHEN INVALID_RECIPE THEN
906: gmd_api_pub.log_message('GMD_INVALID_RECIPE','RECIPE',to_char(p_wip_spec_rec.recipe_id));
907: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
908: x_return_status := FND_API.G_RET_STS_ERROR ;
909: RETURN FALSE;
910: WHEN OTHERS THEN

Line 911: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

907: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
908: x_return_status := FND_API.G_RET_STS_ERROR ;
909: RETURN FALSE;
910: WHEN OTHERS THEN
911: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
912: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
914: RETURN FALSE;
915: END FIND_WIP_SPEC;

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

966: RETURN FALSE;
967: END IF;
968:
969: EXCEPTION WHEN OTHERS THEN
970: 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);
971: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
973: RETURN FALSE;
974: END FIND_WIP_OR_INV_SPEC ;

Line 1109: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_SPEC');

1105:
1106:
1107: EXCEPTION
1108: WHEN REQ_FIELDS_MISSING THEN
1109: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_SPEC');
1110: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1111: x_return_status := FND_API.G_RET_STS_ERROR ;
1112: RETURN FALSE;
1113: WHEN INVALID_ITEM THEN

Line 1114: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_supplier_spec_rec.inventory_item_id));

1110: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1111: x_return_status := FND_API.G_RET_STS_ERROR ;
1112: RETURN FALSE;
1113: WHEN INVALID_ITEM THEN
1114: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_supplier_spec_rec.inventory_item_id));
1115: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1116: x_return_status := FND_API.G_RET_STS_ERROR ;
1117: RETURN FALSE;
1118: WHEN OTHERS THEN

Line 1119: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1115: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1116: x_return_status := FND_API.G_RET_STS_ERROR ;
1117: RETURN FALSE;
1118: WHEN OTHERS THEN
1119: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1120: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122: RETURN FALSE;
1123: END FIND_SUPPLIER_SPEC;

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

1177: RETURN FALSE;
1178: END IF;
1179:
1180: EXCEPTION WHEN OTHERS THEN
1181: 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);
1182: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1184: RETURN FALSE;
1185: END FIND_SUPPLIER_OR_INV_SPEC ;

Line 1426: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');

1422:
1423:
1424: EXCEPTION
1425: WHEN REQ_FIELDS_MISSING THEN
1426: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1427: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: WHEN INVALID_LOT THEN
1430: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));

Line 1430: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));

1426: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1427: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: WHEN INVALID_LOT THEN
1430: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1431: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1432: x_return_status := FND_API.G_RET_STS_ERROR ;
1433: WHEN OTHERS THEN
1434: 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 1434: 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);

1430: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1431: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1432: x_return_status := FND_API.G_RET_STS_ERROR ;
1433: WHEN OTHERS THEN
1434: 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);
1435: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: END get_result_match_for_spec ;
1438:

Line 1539: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC');

1535: RETURN TRUE;
1536:
1537: EXCEPTION
1538: WHEN REQ_FIELDS_MISSING THEN
1539: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC');
1540: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542: RETURN FALSE;
1543: WHEN OTHERS THEN

Line 1544: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1540: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542: RETURN FALSE;
1543: WHEN OTHERS THEN
1544: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1545: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1547: RETURN FALSE;
1548: END find_location_spec;

Line 1651: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC');

1647: RETURN TRUE;
1648:
1649: EXCEPTION
1650: WHEN REQ_FIELDS_MISSING THEN
1651: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC');
1652: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1653: x_return_status := FND_API.G_RET_STS_ERROR ;
1654: RETURN FALSE;
1655: WHEN OTHERS THEN

Line 1656: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1652: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1653: x_return_status := FND_API.G_RET_STS_ERROR ;
1654: RETURN FALSE;
1655: WHEN OTHERS THEN
1656: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1657: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1659: RETURN FALSE;
1660: END find_resource_spec;