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 2005/11/25 05:27:09 svankada 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 230: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');

226: END IF;
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

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

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

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

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

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

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

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

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

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

869: END IF;
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412: END get_result_match_for_spec ;
1413:

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

1510: RETURN TRUE;
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

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

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

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

1622: RETURN TRUE;
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

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

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

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

1640: --| |
1641: --| Notes Returns spec_id or spec_vr_id depending on parameter |
1642: --| p_spec_or_vr_ind passed. Returns 0 if not able to get |
1643: --| the matching spec or p_spec_or_vr_ind is invalid or if |
1644: --| GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC raises any error. |
1645: --| Pass 'SPECID' to p_spec_or_vr_ind to get spec_id. |
1646: --| Pass 'SPECVRID' to get spec_vr_id. |
1647: --| |
1648: --| HISTORY |

Line 1668: l_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;

1664: ,p_test_id IN NUMBER
1665: ,p_spec_or_vr_ind IN VARCHAR2 )
1666: RETURN NUMBER IS
1667:
1668: l_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
1669: l_inv_spec_vr_id NUMBER := 0;
1670: l_return_flag BOOLEAN;
1671: x_spec_id NUMBER;
1672: x_spec_vr_id NUMBER;

Line 1697: l_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC( l_inventory_spec_rec

1693: l_inv_spec_vr_id := 0; --consider spec_vr_id not found
1694: RETURN l_inv_spec_vr_id;
1695: END IF;
1696:
1697: l_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC( l_inventory_spec_rec
1698: ,x_spec_id
1699: ,x_spec_vr_id
1700: ,x_return_status
1701: ,x_message_data );

Line 1723: END gmd_spec_match_grp;

1719:
1720: END GET_INV_SPEC_OR_VR_ID;
1721:
1722:
1723: END gmd_spec_match_grp;