DBA Data[Home] [Help]

APPS.CSD_REPAIR_JOB_XREF_PVT dependencies on CSD_GEN_UTILITY_PVT

Line 21: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;

17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrjxb.pls';
18:
19: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
20: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
21: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
22: -- Hint: Primary key needs to be returned.
23: PROCEDURE CREATE_REPJOBXREF(
24: P_Api_Version_Number IN NUMBER,
25: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1681: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in procedure');

1677:
1678: BEGIN
1679:
1680: IF (g_debug > 0 ) THEN
1681: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in procedure');
1682: END IF;
1683:
1684:
1685: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1699: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in create');

1695: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1696: THEN
1697:
1698: IF (g_debug > 0 ) THEN
1699: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in create');
1700: END IF;
1701:
1702: IF (g_debug > 0 ) THEN
1703: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

Line 1703: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

1699: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in create');
1700: END IF;
1701:
1702: IF (g_debug > 0 ) THEN
1703: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));
1704: END IF;
1705:
1706:
1707: -- verify if data is valid

Line 1717: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');

1713: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1714: THEN
1715:
1716: IF (g_debug > 0 ) THEN
1717: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');
1718: END IF;
1719:
1720: IF (g_debug > 0 ) THEN
1721: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));

Line 1721: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));

1717: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');
1718: END IF;
1719:
1720: IF (g_debug > 0 ) THEN
1721: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));
1722: END IF;
1723:
1724:
1725: -- verify if data is valid

Line 1732: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from db '||to_char(l_OBJECT_VERSION_NUMBER));

1728: FROM CSD_REPAIR_JOB_XREF
1729: WHERE REPAIR_JOB_XREF_ID = P_REPAIR_JOB_XREF_ID;
1730:
1731: IF (g_debug > 0 ) THEN
1732: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from db '||to_char(l_OBJECT_VERSION_NUMBER));
1733: END IF;
1734:
1735:
1736: if (l_OBJECT_VERSION_NUMBER <> p_OBJECT_VERSION_NUMBER) then

Line 1741: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');

1737: -- data is not valid
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739:
1740: IF (g_debug > 0 ) THEN
1741: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');
1742: END IF;
1743:
1744:
1745: end if;