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

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

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

227:
228: EXCEPTION
229: WHEN REQ_FIELDS_MISSING THEN
230: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');
231: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: RETURN FALSE;
234: WHEN INVALID_LOT THEN
235: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_inventory_spec_rec.lot_number));

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

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

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

237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: RETURN FALSE;
239: WHEN INVALID_ITEM THEN
240: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_inventory_spec_rec.inventory_item_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 OTHERS THEN
245: 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 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 OTHERS THEN
245: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
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_UNEXP_ERROR ;
248: RETURN FALSE;
249: END FIND_INVENTORY_SPEC;
250:

Line 337: FND_MSG_PUB.initialize;

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

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

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

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

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

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

428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RETURN FALSE;
430: WHEN INVALID_ITEM THEN
431: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_customer_spec_rec.inventory_item_id));
432: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
433: x_return_status := FND_API.G_RET_STS_ERROR ;
434: RETURN FALSE;
435: WHEN OTHERS THEN
436: 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 437: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

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

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

Line 649: FND_MSG_PUB.initialize;

645:
646: BEGIN
647:
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649: FND_MSG_PUB.initialize;
650: l_position := '010';
651:
652: 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
653: RAISE REQ_FIELDS_MISSING;

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

870:
871: EXCEPTION
872: WHEN REQ_FIELDS_MISSING THEN
873: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC');
874: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
875: x_return_status := FND_API.G_RET_STS_ERROR ;
876: RETURN FALSE;
877: WHEN INVALID_ITEM THEN
878: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_wip_spec_rec.inventory_item_id));

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

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

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

880: x_return_status := FND_API.G_RET_STS_ERROR ;
881: RETURN FALSE;
882: WHEN INVALID_FORMULA THEN
883: gmd_api_pub.log_message('GMD_INVALID_FORMULA','FORMULA',to_char(p_wip_spec_rec.formula_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_ROUTING THEN
888: gmd_api_pub.log_message('GMD_INVALID_ROUTING','ROUTING',to_char(p_wip_spec_rec.routing_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_ROUTING THEN
888: gmd_api_pub.log_message('GMD_INVALID_ROUTING','ROUTING',to_char(p_wip_spec_rec.routing_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_OPRN THEN
893: gmd_api_pub.log_message('GMD_INVALID_OPRN','OPRN',to_char(p_wip_spec_rec.oprn_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_OPRN THEN
893: gmd_api_pub.log_message('GMD_INVALID_OPRN','OPRN',to_char(p_wip_spec_rec.oprn_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_STEP THEN
898: gmd_api_pub.log_message('GMD_INVALID_STEP','STEP',to_char(p_wip_spec_rec.step_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_STEP THEN
898: gmd_api_pub.log_message('GMD_INVALID_STEP','STEP',to_char(p_wip_spec_rec.step_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_RECIPE THEN
903: gmd_api_pub.log_message('GMD_INVALID_RECIPE','RECIPE',to_char(p_wip_spec_rec.recipe_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_RECIPE THEN
903: gmd_api_pub.log_message('GMD_INVALID_RECIPE','RECIPE',to_char(p_wip_spec_rec.recipe_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 OTHERS THEN
908: 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 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 OTHERS THEN
908: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
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_UNEXP_ERROR ;
911: RETURN FALSE;
912: END FIND_WIP_SPEC;
913:

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

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

Line 1044: FND_MSG_PUB.initialize;

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

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

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

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

1108: x_return_status := FND_API.G_RET_STS_ERROR ;
1109: RETURN FALSE;
1110: WHEN INVALID_ITEM THEN
1111: gmd_api_pub.log_message('GMD_INVALID_ITEM','ITEM',to_char(p_supplier_spec_rec.inventory_item_id));
1112: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1113: x_return_status := FND_API.G_RET_STS_ERROR ;
1114: RETURN FALSE;
1115: WHEN OTHERS THEN
1116: 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 1117: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

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

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

Line 1283: FND_MSG_PUB.initialize;

1279: l_in_spec VARCHAR2(1); -- returned by the results API
1280: BEGIN
1281:
1282: x_return_status := FND_API.G_RET_STS_SUCCESS;
1283: FND_MSG_PUB.initialize;
1284: l_position := '010';
1285:
1286: IF p_spec_id IS NULL THEN
1287: RETURN;

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

1398:
1399: EXCEPTION
1400: WHEN REQ_FIELDS_MISSING THEN
1401: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1402: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1403: x_return_status := FND_API.G_RET_STS_ERROR ;
1404: WHEN INVALID_LOT THEN
1405: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1406: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1402: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1403: x_return_status := FND_API.G_RET_STS_ERROR ;
1404: WHEN INVALID_LOT THEN
1405: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1406: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1407: x_return_status := FND_API.G_RET_STS_ERROR ;
1408: WHEN OTHERS THEN
1409: 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);
1410: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1406: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1407: x_return_status := FND_API.G_RET_STS_ERROR ;
1408: WHEN OTHERS THEN
1409: 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);
1410: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412: END get_result_match_for_spec ;
1413:
1414:

Line 1486: FND_MSG_PUB.initialize;

1482:
1483: BEGIN
1484:
1485: x_return_status := FND_API.G_RET_STS_SUCCESS;
1486: FND_MSG_PUB.initialize;
1487: l_position := '010';
1488:
1489: IF (p_location_spec_rec.locator_organization_id IS NULL AND
1490: p_location_spec_rec.subinventory IS NULL AND

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

1511:
1512: EXCEPTION
1513: WHEN REQ_FIELDS_MISSING THEN
1514: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC');
1515: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1516: x_return_status := FND_API.G_RET_STS_ERROR ;
1517: RETURN FALSE;
1518: WHEN OTHERS THEN
1519: 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 1520: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1516: x_return_status := FND_API.G_RET_STS_ERROR ;
1517: RETURN FALSE;
1518: WHEN OTHERS THEN
1519: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_LOCATION_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1520: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: RETURN FALSE;
1523: END find_location_spec;
1524:

Line 1598: FND_MSG_PUB.initialize;

1594:
1595: BEGIN
1596:
1597: x_return_status := FND_API.G_RET_STS_SUCCESS;
1598: FND_MSG_PUB.initialize;
1599: l_position := '010';
1600:
1601: IF (p_resource_spec_rec.resource_organization_id IS NULL AND
1602: p_resource_spec_rec.resources IS NULL AND

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

1623:
1624: EXCEPTION
1625: WHEN REQ_FIELDS_MISSING THEN
1626: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC');
1627: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1628: x_return_status := FND_API.G_RET_STS_ERROR ;
1629: RETURN FALSE;
1630: WHEN OTHERS THEN
1631: 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 1632: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1628: x_return_status := FND_API.G_RET_STS_ERROR ;
1629: RETURN FALSE;
1630: WHEN OTHERS THEN
1631: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_RESOURCE_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1632: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1634: RETURN FALSE;
1635: END find_resource_spec;
1636: