DBA Data[Home] [Help]

APPS.CSD_REPAIR_HISTORY_PVT dependencies on CSD_GEN_UTILITY_PVT

Line 17: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;

13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrehb.pls';
14:
15: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
16: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
17: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
18:
19: -- Hint: Primary key needs to be returned.
20: PROCEDURE Create_repair_history(
21: P_Api_Version_Number IN NUMBER,

Line 122: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before Validate_repair_history');

118: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
119:
120: -- Invoke validation procedures
121: IF (g_debug > 0 ) THEN
122: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before Validate_repair_history');
123: END IF;
124:
125:
126: Validate_repair_history(

Line 136: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after Validate_repair_history x_return_status'||x_return_status);

132: x_msg_count => x_msg_count,
133: x_msg_data => x_msg_data);
134:
135: IF (g_debug > 0 ) THEN
136: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after Validate_repair_history x_return_status'||x_return_status);
137: END IF;
138:
139:
140: END IF;

Line 153: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');

149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');
150:
151: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Insert_Row)
152: IF (g_debug > 0 ) THEN
153: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');
154: END IF;
155:
156:
157: CSD_REPAIR_HISTORY_PKG.Insert_Row(

Line 222: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after CSD_REPAIR_HISTORY_PKG.Insert_Row x_return_status'||x_return_status);

218: p_LAST_UPDATE_LOGIN => p_REPH_rec.LAST_UPDATE_LOGIN);
219: -- Hint: Primary key should be returned.
220: -- x_REPAIR_HISTORY_ID := px_REPAIR_HISTORY_ID;
221: IF (g_debug > 0 ) THEN
222: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after CSD_REPAIR_HISTORY_PKG.Insert_Row x_return_status'||x_return_status);
223: END IF;
224:
225:
226:

Line 3362: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in create we get null ovn');

3358:
3359: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3360: THEN
3361: IF (g_debug > 0 ) THEN
3362: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in create we get null ovn');
3363: END IF;
3364:
3365: IF (g_debug > 0 ) THEN
3366: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

Line 3366: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

3362: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in create we get null ovn');
3363: END IF;
3364:
3365: IF (g_debug > 0 ) THEN
3366: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));
3367: END IF;
3368:
3369:
3370: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

Line 3374: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in update');

3370: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3371: THEN
3372:
3373: IF (g_debug > 0 ) THEN
3374: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in update');
3375: END IF;
3376:
3377: IF (g_debug > 0 ) THEN
3378: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));

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

3374: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in update');
3375: END IF;
3376:
3377: IF (g_debug > 0 ) THEN
3378: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));
3379: END IF;
3380:
3381:
3382: -- verify if data is valid

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

3385: FROM CSD_REPAIR_HISTORY
3386: WHERE REPAIR_HISTORY_ID = P_REPAIR_HISTORY_ID;
3387:
3388: IF (g_debug > 0 ) THEN
3389: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn from db '||to_char(l_OBJECT_VERSION_NUMBER));
3390: END IF;
3391:
3392:
3393: if (l_OBJECT_VERSION_NUMBER <> p_OBJECT_VERSION_NUMBER) then

Line 3398: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');

3394: -- data is not valid
3395: x_return_status := FND_API.G_RET_STS_ERROR;
3396:
3397: IF (g_debug > 0 ) THEN
3398: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');
3399: END IF;
3400:
3401:
3402: end if;