APPS.GMD_SPEC_VRS_PUB dependencies on GMD_SUPPLIER_SPEC_VRS

Line 579: | into gmd_supplier_spec_vrs |

575: | |
576: | DESCRIPTION |
577: | Accepts a table of supplier_spec_vrs definitions. Validates |
578: | each table entry and where valid, inserts a corresponding row |
579: | into gmd_supplier_spec_vrs |
580: | In the case of any failure a rollback is instigated. |
581: | |
582: | HISTORY |
583: | 03-AUG-2002 K.Y.Hunt |

Line 609: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

605: l_api_version CONSTANT NUMBER := 1.0;
606: l_msg_count NUMBER :=0;
607: l_msg_data VARCHAR2(2000);
608: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
609: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
610: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
611: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;
612: l_user_id NUMBER(15);
613:

Line 610: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

606: l_msg_count NUMBER :=0;
607: l_msg_data VARCHAR2(2000);
608: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
609: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
610: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
611: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;
612: l_user_id NUMBER(15);
613:
614: BEGIN

Line 687: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Insert_Row(l_supplier_spec_vrs, l_supplier_spec_vrs_out)

683: -- Diagnostic message is already on the stack
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686:
687: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Insert_Row(l_supplier_spec_vrs, l_supplier_spec_vrs_out)
688: THEN
689: -- Diagnostic message is already on the stack
690: RAISE FND_API.G_EXC_ERROR;
691: END IF;

Line 753: | into gmd_supplier_spec_vrs |

749: | |
750: | DESCRIPTION |
751: | Accepts a table of monitoring_spec_vrs definitions. Validates |
752: | each table entry and where valid, inserts a corresponding row |
753: | into gmd_supplier_spec_vrs |
754: | In the case of any failure a rollback is instigated. |
755: | |
756: | HISTORY |
757: | 26-Jan-2004 Manish Gupta |

Line 1616: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

1612: l_msg_count NUMBER :=0;
1613: l_msg_data VARCHAR2(2000);
1614: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1615: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1616: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
1617: l_deleted_rows NUMBER :=0;
1618:
1619: BEGIN
1620:

Line 1718: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Lock_Row( l_supplier_spec_vrs.spec_vr_id)

1714:
1715:
1716: -- Lock the validity rule ahead of deleting
1717: -- ========================================
1718: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Lock_Row( l_supplier_spec_vrs.spec_vr_id)
1719: THEN
1720: -- Report Failure to obtain locks
1721: -- ==============================
1722: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 1723: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

1719: THEN
1720: -- Report Failure to obtain locks
1721: -- ==============================
1722: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1723: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1724: 'l_column_name', 'SPEC_VR_ID',
1725: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;

Line 1729: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Delete_Row

1725: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728:
1729: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Delete_Row
1730: ( p_spec_vr_id => l_supplier_spec_vrs.spec_vr_id
1731: , p_last_update_date => sysdate
1732: , p_last_updated_by => l_spec.last_updated_by
1733: )

Line 1736: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

1732: , p_last_updated_by => l_spec.last_updated_by
1733: )
1734: THEN
1735: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1736: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1737: 'l_column_name', 'SPEC_VR_ID',
1738: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1739: RAISE FND_API.G_EXC_ERROR;
1740: ELSE