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

220: p_LAST_UPDATE_LOGIN => p_REPH_rec.LAST_UPDATE_LOGIN);
221: -- Hint: Primary key should be returned.
222: -- x_REPAIR_HISTORY_ID := px_REPAIR_HISTORY_ID;
223: IF (g_debug > 0 ) THEN
224: 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);
225: END IF;
226:
227:
228:

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

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

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

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

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

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

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

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

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

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

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

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