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_GRP dependencies on FND_MSG_PUB

Line 141: FND_MSG_PUB.initialize;

137:
138: BEGIN
139:
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141: FND_MSG_PUB.initialize;
142: l_position := '010';
143:
144: IF p_inventory_spec_rec.inventory_item_id IS NULL OR p_inventory_spec_rec.organization_id IS NULL
145: OR p_inventory_spec_rec.date_effective IS NULL THEN

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

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

Line 239: 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
243: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_inventory_spec_rec.inventory_item_id));

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

Line 249: 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;
253:

Line 340: FND_MSG_PUB.initialize;

336:
337: BEGIN
338:
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340: FND_MSG_PUB.initialize;
341: l_position := '010';
342:
343: IF p_customer_spec_rec.inventory_item_id IS NULL OR p_customer_spec_rec.organization_id IS NULL
344: OR p_customer_spec_rec.cust_id IS NULL OR p_customer_spec_rec.date_effective IS NULL THEN

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

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

Line 430: 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
434: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_customer_spec_rec.inventory_item_id));

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

Line 440: 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;
444:

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

Line 652: FND_MSG_PUB.initialize;

648:
649: BEGIN
650:
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652: FND_MSG_PUB.initialize;
653: l_position := '010';
654:
655: IF p_wip_spec_rec.inventory_item_id IS NULL OR p_wip_spec_rec.organization_id IS NULL OR p_wip_spec_rec.date_effective IS NULL THEN
656: RAISE REQ_FIELDS_MISSING;

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

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

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

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

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

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

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

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

Line 912: 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;
916:

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

Line 1047: FND_MSG_PUB.initialize;

1043:
1044: BEGIN
1045:
1046: x_return_status := FND_API.G_RET_STS_SUCCESS;
1047: FND_MSG_PUB.initialize;
1048: l_position := '010';
1049:
1050: IF p_supplier_spec_rec.inventory_item_id IS NULL OR p_supplier_spec_rec.organization_id IS NULL OR
1051: p_supplier_spec_rec.date_effective IS NULL OR p_supplier_spec_rec.supplier_id IS NULL THEN

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

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
1114: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_supplier_spec_rec.inventory_item_id));

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

Line 1120: 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;
1124:

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

Line 1300: FND_MSG_PUB.initialize;

1296: l_in_spec VARCHAR2(1); -- returned by the results API
1297: BEGIN
1298:
1299: x_return_status := FND_API.G_RET_STS_SUCCESS;
1300: FND_MSG_PUB.initialize;
1301: l_position := '010';
1302:
1303: IF p_spec_id IS NULL THEN
1304: RETURN;

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

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

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

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

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

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

Line 1511: FND_MSG_PUB.initialize;

1507:
1508: BEGIN
1509:
1510: x_return_status := FND_API.G_RET_STS_SUCCESS;
1511: FND_MSG_PUB.initialize;
1512: l_position := '010';
1513:
1514: IF (p_location_spec_rec.locator_organization_id IS NULL AND
1515: p_location_spec_rec.subinventory IS NULL AND

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

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

Line 1545: 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;
1549:

Line 1623: FND_MSG_PUB.initialize;

1619:
1620: BEGIN
1621:
1622: x_return_status := FND_API.G_RET_STS_SUCCESS;
1623: FND_MSG_PUB.initialize;
1624: l_position := '010';
1625:
1626: IF (p_resource_spec_rec.resource_organization_id IS NULL AND
1627: p_resource_spec_rec.resources IS NULL AND

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

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

Line 1657: 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;
1661: