DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on FND_MSG_PUB

Line 134: FND_MSG_PUB.initialize;

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
138: RAISE REQ_FIELDS_MISSING;

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 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 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 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 351: FND_MSG_PUB.initialize;

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
355: p_customer_spec_rec.date_effective IS NULL THEN

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 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 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 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 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 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 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 667: FND_MSG_PUB.initialize;

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
671: RAISE REQ_FIELDS_MISSING;

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 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 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 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 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 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 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 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 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 1057: FND_MSG_PUB.initialize;

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
1061: OR p_supplier_spec_rec.date_effective 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 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 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 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 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 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 1339: FND_MSG_PUB.initialize;

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
1343: RETURN;

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