APPS.GMD_SPEC_VRS_PUB dependencies on GMD_SUPPLIER_SPEC_VRS

Line 587: | into gmd_supplier_spec_vrs |

583: | |
584: | DESCRIPTION |
585: | Accepts a table of supplier_spec_vrs definitions. Validates |
586: | each table entry and where valid, inserts a corresponding row |
587: | into gmd_supplier_spec_vrs |
588: | In the case of any failure a rollback is instigated. |
589: | |
590: | HISTORY |
591: | 03-AUG-2002 K.Y.Hunt |

Line 617: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

613: l_api_version CONSTANT NUMBER := 1.0;
614: l_msg_count NUMBER :=0;
615: l_msg_data VARCHAR2(2000);
616: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
617: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
618: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
619: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;
620: l_user_id NUMBER(15);
621:

Line 618: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

614: l_msg_count NUMBER :=0;
615: l_msg_data VARCHAR2(2000);
616: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
617: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
618: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
619: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;
620: l_user_id NUMBER(15);
621:
622: BEGIN

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

693: -- Diagnostic message is already on the stack
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696:
697: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Insert_Row(l_supplier_spec_vrs, l_supplier_spec_vrs_out)
698: THEN
699: -- Diagnostic message is already on the stack
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;

Line 763: | into gmd_supplier_spec_vrs |

759: | |
760: | DESCRIPTION |
761: | Accepts a table of monitoring_spec_vrs definitions. Validates |
762: | each table entry and where valid, inserts a corresponding row |
763: | into gmd_supplier_spec_vrs |
764: | In the case of any failure a rollback is instigated. |
765: | |
766: | HISTORY |
767: | 26-Jan-2004 Manish Gupta |

Line 1628: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;

1624: l_msg_count NUMBER :=0;
1625: l_msg_data VARCHAR2(2000);
1626: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1627: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1628: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
1629: l_deleted_rows NUMBER :=0;
1630:
1631: BEGIN
1632:

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

1726:
1727:
1728: -- Lock the validity rule ahead of deleting
1729: -- ========================================
1730: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Lock_Row( l_supplier_spec_vrs.spec_vr_id)
1731: THEN
1732: -- Report Failure to obtain locks
1733: -- ==============================
1734: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 1735: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

1731: THEN
1732: -- Report Failure to obtain locks
1733: -- ==============================
1734: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1735: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1736: 'l_column_name', 'SPEC_VR_ID',
1737: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;

Line 1741: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Delete_Row

1737: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;
1740:
1741: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Delete_Row
1742: ( p_spec_vr_id => l_supplier_spec_vrs.spec_vr_id
1743: , p_last_update_date => sysdate
1744: , p_last_updated_by => l_spec.last_updated_by
1745: )

Line 1748: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',

1744: , p_last_updated_by => l_spec.last_updated_by
1745: )
1746: THEN
1747: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1748: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1749: 'l_column_name', 'SPEC_VR_ID',
1750: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1751: RAISE FND_API.G_EXC_ERROR;
1752: ELSE