DBA Data[Home] [Help]

APPS.IEX_WRITEOFF_OBJECTS_PUB dependencies on IEX_WRITEOFF_OBJECTS

Line 1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PUB as

1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PUB as
2: /* $Header: iexpwobb.pls 120.1 2007/10/31 14:58:12 ehuh ship $ */
3:
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 29: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;

25:
26: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_WRITEOFF_OBJECTS';
27: l_api_name_full CONSTANT VARCHAR2(150) := g_pkg_name || '.' || l_api_name;
28: l_api_version_number CONSTANT NUMBER := 2.0;
29: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
30: l_return_status VARCHAR2(1);
31: l_msg_count NUMBER ;
32: l_msg_data VARCHAR2(32627);
33:

Line 37: 'IEX_writeoff_objects_PUB.create_writeoff_objects *** ');

33:
34: BEGIN
35: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
36: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
37: 'IEX_writeoff_objects_PUB.create_writeoff_objects *** ');
38: END IF;
39: SAVEPOINT CREATE_WRITEOFF_OBJECTS_PUB;
40:
41: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number,

Line 69: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pvt.create_writeoff_objects');

65: IEX_DEBUG_PUB.LogMessage('After Global user Check');
66: END IF;
67:
68: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
69: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pvt.create_writeoff_objects');
70: END IF;
71: --Call PVT
72: IEX_WRITEOFF_OBJECTS_PVT.create_writeoff_objects(
73: P_Api_Version_Number =>p_Api_Version_Number

Line 72: IEX_WRITEOFF_OBJECTS_PVT.create_writeoff_objects(

68: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
69: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pvt.create_writeoff_objects');
70: END IF;
71: --Call PVT
72: IEX_WRITEOFF_OBJECTS_PVT.create_writeoff_objects(
73: P_Api_Version_Number =>p_Api_Version_Number
74: ,P_Init_Msg_List =>P_Init_Msg_List
75: ,P_Commit =>p_commit
76: ,P_writeoff_obj_rec =>P_writeoff_obj_rec

Line 85: IEX_DEBUG_PUB.LogMessage('After Calling iex_writeoff_objects_pvt.create_writeoff_objects'||

81:
82: -- Hint: Primary key should be returned.
83: x_writeoff_object_id := l_writeoff_object_id;
84: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
85: IEX_DEBUG_PUB.LogMessage('After Calling iex_writeoff_objects_pvt.create_writeoff_objects'||
86: 'and writeoff_object_id => '||x_writeoff_object_id);
87: END IF;
88:
89: IF x_return_status = FND_API.G_RET_STS_ERROR then

Line 108: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_writeoff_objects_PUB.'||

104: ( p_count => x_msg_count,
105: p_data => x_msg_data);
106:
107: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
108: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_writeoff_objects_PUB.'||
109: 'create_writeoff_objects ******** ');
110: END IF;
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN

Line 151: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE

147: ,XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER) IS
148:
149: l_api_name CONSTANT VARCHAR2(60) := 'UPDATE_WRITEOFF_OBJECTS';
150: l_api_version_number CONSTANT NUMBER := 2.0;
151: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE
152: :=p_writeoff_obj_rec.object_version_number;
153: l_return_status VARCHAR2(1);
154: l_msg_count NUMBER ;
155: l_msg_data VARCHAR2(32627);

Line 160: 'IEX_writeoff_objects_PUB.update_writeoff_objects *** ');

156:
157: BEGIN
158: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
159: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
160: 'IEX_writeoff_objects_PUB.update_writeoff_objects *** ');
161: END IF;
162:
163: SAVEPOINT UPDATE_WRITEOFF_OBJECTS_PUB;
164: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number,

Line 176: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pvt.'||

172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
176: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pvt.'||
177: 'update_writeoff_objects');
178: END IF;
179: -- Invoke pvt(IEX_writeoff_objects_PVT.update_writeoff_objects)
180:

Line 179: -- Invoke pvt(IEX_writeoff_objects_PVT.update_writeoff_objects)

175: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
176: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pvt.'||
177: 'update_writeoff_objects');
178: END IF;
179: -- Invoke pvt(IEX_writeoff_objects_PVT.update_writeoff_objects)
180:
181: IEX_WRITEOFF_OBJECTS_PVT.update_writeoff_objects(
182: P_Api_Version_Number =>p_Api_Version_Number
183: ,P_Init_Msg_List =>P_Init_Msg_List

Line 181: IEX_WRITEOFF_OBJECTS_PVT.update_writeoff_objects(

177: 'update_writeoff_objects');
178: END IF;
179: -- Invoke pvt(IEX_writeoff_objects_PVT.update_writeoff_objects)
180:
181: IEX_WRITEOFF_OBJECTS_PVT.update_writeoff_objects(
182: P_Api_Version_Number =>p_Api_Version_Number
183: ,P_Init_Msg_List =>P_Init_Msg_List
184: ,P_Commit =>p_commit
185: ,P_writeoff_obj_rec =>P_writeoff_obj_rec

Line 207: 'IEX_writeoff_objects_PUB.update_writeoff_objects ** ');

203:
204: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
205: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
206: IEX_DEBUG_PUB.LogMessage ('**** End of Procedure =>'||
207: 'IEX_writeoff_objects_PUB.update_writeoff_objects ** ');
208: END IF;
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PUB;

Line 277: IEX_WRITEOFF_OBJECTS_PVT.delete_writeoff_objects(

273: -- API body
274: --
275:
276: -- call pvt
277: IEX_WRITEOFF_OBJECTS_PVT.delete_writeoff_objects(
278: P_Api_Version_Number =>p_Api_Version_Number
279: ,P_Init_Msg_List =>P_Init_Msg_List
280: ,P_Commit =>p_commit
281: ,P_writeoff_object_id =>p_writeoff_object_id

Line 338: End IEX_WRITEOFF_OBJECTS_PUB;

334:
335: End delete_writeoff_objects;
336:
337:
338: End IEX_WRITEOFF_OBJECTS_PUB;
339: