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 GMD_SPEC_MATCH_GRP

Line 1: PACKAGE BODY GMD_SPEC_MATCH_GRP AS

1: PACKAGE BODY GMD_SPEC_MATCH_GRP AS
2: /* $Header: GMDGSPMB.pls 120.5.12020000.2 2012/07/17 10:28:16 mtou ship $ */
3:
4: -- Start of comments
5: --+==========================================================================+

Line 11: --| Package Name : GMD_SPEC_MATCH_GRP |

7: --| Redwood Shores, CA, USA |
8: --| All rights reserved. |
9: --+==========================================================================+
10: --| File Name : GMDGSPMS.pls |
11: --| Package Name : GMD_SPEC_MATCH_GRP |
12: --| Type : Group |
13: --| |
14: --| Notes |
15: --| This package contains group layer APIs for Specification Match |

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

Line 1669: --| GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC raises any error. |

1665: --| |
1666: --| Notes Returns spec_id or spec_vr_id depending on parameter |
1667: --| p_spec_or_vr_ind passed. Returns 0 if not able to get |
1668: --| the matching spec or p_spec_or_vr_ind is invalid or if |
1669: --| GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC raises any error. |
1670: --| Pass 'SPECID' to p_spec_or_vr_ind to get spec_id. |
1671: --| Pass 'SPECVRID' to get spec_vr_id. |
1672: --| |
1673: --| HISTORY |

Line 1693: l_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;

1689: ,p_test_id IN NUMBER
1690: ,p_spec_or_vr_ind IN VARCHAR2 )
1691: RETURN NUMBER IS
1692:
1693: l_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
1694: l_inv_spec_vr_id NUMBER := 0;
1695: l_return_flag BOOLEAN;
1696: x_spec_id NUMBER;
1697: x_spec_vr_id NUMBER;

Line 1722: l_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC( l_inventory_spec_rec

1718: l_inv_spec_vr_id := 0; --consider spec_vr_id not found
1719: RETURN l_inv_spec_vr_id;
1720: END IF;
1721:
1722: l_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC( l_inventory_spec_rec
1723: ,x_spec_id
1724: ,x_spec_vr_id
1725: ,x_return_status
1726: ,x_message_data );

Line 1748: END gmd_spec_match_grp;

1744:
1745: END GET_INV_SPEC_OR_VR_ID;
1746:
1747:
1748: END gmd_spec_match_grp;