eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_CAL_ITEMS_PUB dependencies on FND_API

Line 61: IF NOT FND_API.Compatible_API_Call( l_api_version

57: SAVEPOINT create_item_pub;
58: /***************************************************************************
59: ** Standard call to check for call compatibility
60: ***************************************************************************/
61: IF NOT FND_API.Compatible_API_Call( l_api_version
62: , p_api_version
63: , l_api_name
64: , G_PKG_NAME
65: )

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: , l_api_name
64: , G_PKG_NAME
65: )
66: THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69: /***************************************************************************
70: ** Initialize message list if p_init_msg_list is set to TRUE
71: ***************************************************************************/

Line 72: IF FND_API.To_Boolean(p_init_msg_list)

68: END IF;
69: /***************************************************************************
70: ** Initialize message list if p_init_msg_list is set to TRUE
71: ***************************************************************************/
72: IF FND_API.To_Boolean(p_init_msg_list)
73: THEN
74: FND_MSG_PUB.Initialize;
75: END IF;
76: /***************************************************************************

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: END IF;
76: /***************************************************************************
77: ** Initialize API return status to success
78: ***************************************************************************/
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: /***************************************************************************
82: ** Validate Data
83: ***************************************************************************/

Line 85: FND_API.G_MISS_NUM) OR (p_itm_rec.CAL_RESOURCE_TYPE IS NULL OR

81: /***************************************************************************
82: ** Validate Data
83: ***************************************************************************/
84: IF (p_itm_rec.CAL_RESOURCE_ID IS NULL OR p_itm_rec.CAL_RESOURCE_ID =
85: FND_API.G_MISS_NUM) OR (p_itm_rec.CAL_RESOURCE_TYPE IS NULL OR
86: p_itm_rec.CAL_RESOURCE_TYPE = FND_API.G_MISS_CHAR) THEN
87: --reuse existing calendar message
88: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_RESOURCE_STAT');
89: FND_MSG_pub.ADD;

Line 86: p_itm_rec.CAL_RESOURCE_TYPE = FND_API.G_MISS_CHAR) THEN

82: ** Validate Data
83: ***************************************************************************/
84: IF (p_itm_rec.CAL_RESOURCE_ID IS NULL OR p_itm_rec.CAL_RESOURCE_ID =
85: FND_API.G_MISS_NUM) OR (p_itm_rec.CAL_RESOURCE_TYPE IS NULL OR
86: p_itm_rec.CAL_RESOURCE_TYPE = FND_API.G_MISS_CHAR) THEN
87: --reuse existing calendar message
88: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_RESOURCE_STAT');
89: FND_MSG_pub.ADD;
90: RAISE FND_API.g_exc_unexpected_error;

Line 90: RAISE FND_API.g_exc_unexpected_error;

86: p_itm_rec.CAL_RESOURCE_TYPE = FND_API.G_MISS_CHAR) THEN
87: --reuse existing calendar message
88: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_RESOURCE_STAT');
89: FND_MSG_pub.ADD;
90: RAISE FND_API.g_exc_unexpected_error;
91: END IF;
92:
93: /***************************************************************************
94: ** Validate source_code against jtf_objects metadata

Line 101: RAISE FND_API.g_exc_unexpected_error;

97: IF NOT JTF_CAL_UTILITY_PVT.isValidObjectCode (p_itm_rec.SOURCE_CODE) THEN
98: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_SOURCE_CODE');
99: FND_MESSAGE.set_token('CODE', p_itm_rec.SOURCE_CODE);
100: FND_MSG_pub.ADD;
101: RAISE FND_API.g_exc_unexpected_error;
102: END IF;
103:
104: IF (p_itm_rec.SOURCE_ID IS NULL
105: OR p_itm_rec.SOURCE_ID = FND_API.G_MISS_NUM) THEN

Line 105: OR p_itm_rec.SOURCE_ID = FND_API.G_MISS_NUM) THEN

101: RAISE FND_API.g_exc_unexpected_error;
102: END IF;
103:
104: IF (p_itm_rec.SOURCE_ID IS NULL
105: OR p_itm_rec.SOURCE_ID = FND_API.G_MISS_NUM) THEN
106: FND_MESSAGE.set_name('JTF', 'JTF_CAL_SOURCE_ID_REQUIRED');
107: FND_MSG_pub.ADD;
108: RAISE FND_API.g_exc_unexpected_error;
109: END IF;

Line 108: RAISE FND_API.g_exc_unexpected_error;

104: IF (p_itm_rec.SOURCE_ID IS NULL
105: OR p_itm_rec.SOURCE_ID = FND_API.G_MISS_NUM) THEN
106: FND_MESSAGE.set_name('JTF', 'JTF_CAL_SOURCE_ID_REQUIRED');
107: FND_MSG_pub.ADD;
108: RAISE FND_API.g_exc_unexpected_error;
109: END IF;
110:
111: IF (p_itm_rec.START_DATE IS NULL
112: OR p_itm_rec.START_DATE = FND_API.G_MISS_DATE) THEN

Line 112: OR p_itm_rec.START_DATE = FND_API.G_MISS_DATE) THEN

108: RAISE FND_API.g_exc_unexpected_error;
109: END IF;
110:
111: IF (p_itm_rec.START_DATE IS NULL
112: OR p_itm_rec.START_DATE = FND_API.G_MISS_DATE) THEN
113: FND_MESSAGE.set_name('JTF', 'JTF_CAL_START_DATE');
114: FND_MSG_pub.ADD;
115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;

Line 115: RAISE FND_API.g_exc_unexpected_error;

111: IF (p_itm_rec.START_DATE IS NULL
112: OR p_itm_rec.START_DATE = FND_API.G_MISS_DATE) THEN
113: FND_MESSAGE.set_name('JTF', 'JTF_CAL_START_DATE');
114: FND_MSG_pub.ADD;
115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;
117:
118: IF (p_itm_rec.END_DATE IS NULL
119: OR p_itm_rec.END_DATE = FND_API.G_MISS_DATE) THEN

Line 119: OR p_itm_rec.END_DATE = FND_API.G_MISS_DATE) THEN

115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;
117:
118: IF (p_itm_rec.END_DATE IS NULL
119: OR p_itm_rec.END_DATE = FND_API.G_MISS_DATE) THEN
120: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_TIME');
121: FND_MSG_pub.ADD;
122: RAISE FND_API.g_exc_unexpected_error;
123: END IF;

Line 122: RAISE FND_API.g_exc_unexpected_error;

118: IF (p_itm_rec.END_DATE IS NULL
119: OR p_itm_rec.END_DATE = FND_API.G_MISS_DATE) THEN
120: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_TIME');
121: FND_MSG_pub.ADD;
122: RAISE FND_API.g_exc_unexpected_error;
123: END IF;
124: /***************************************************************************
125: ** End date cannot be before start date
126: ***************************************************************************/

Line 133: RAISE FND_API.g_exc_unexpected_error;

129: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_DATE');
130: FND_MESSAGE.set_token('P_START_DATE', to_char(p_itm_rec.START_DATE, 'YYYYMMDDHH24MISS'));
131: FND_MESSAGE.set_token('P_END_DATE', to_char(p_itm_rec.END_DATE, 'YYYYMMDDHH24MISS'));
132: FND_MSG_pub.ADD;
133: RAISE FND_API.g_exc_unexpected_error;
134: END IF;
135: /***************************************************************************
136: ** Validate timezone_id against hz_timezones
137: ***************************************************************************/

Line 143: RAISE FND_API.g_exc_unexpected_error;

139: IF NOT JTF_CAL_UTILITY_PVT.isValidTimezone (p_itm_rec.TIMEZONE_ID) THEN
140: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_TIMEZONE');
141: FND_MESSAGE.set_token('TIMEZONE', p_itm_rec.TIMEZONE_ID);
142: FND_MSG_pub.ADD;
143: RAISE FND_API.g_exc_unexpected_error;
144: END IF;
145:
146: IF (p_itm_rec.CREATED_BY IS NULL OR p_itm_rec.CREATED_BY = FND_API.G_MISS_NUM) THEN
147: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_CREATED');

Line 146: IF (p_itm_rec.CREATED_BY IS NULL OR p_itm_rec.CREATED_BY = FND_API.G_MISS_NUM) THEN

142: FND_MSG_pub.ADD;
143: RAISE FND_API.g_exc_unexpected_error;
144: END IF;
145:
146: IF (p_itm_rec.CREATED_BY IS NULL OR p_itm_rec.CREATED_BY = FND_API.G_MISS_NUM) THEN
147: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_CREATED');
148: FND_MSG_pub.ADD;
149: RAISE FND_API.g_exc_unexpected_error;
150: END IF;

Line 149: RAISE FND_API.g_exc_unexpected_error;

145:
146: IF (p_itm_rec.CREATED_BY IS NULL OR p_itm_rec.CREATED_BY = FND_API.G_MISS_NUM) THEN
147: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_CREATED');
148: FND_MSG_pub.ADD;
149: RAISE FND_API.g_exc_unexpected_error;
150: END IF;
151:
152: IF (p_itm_rec.CREATION_DATE IS NULL OR p_itm_rec.CREATION_DATE = FND_API.G_MISS_DATE) THEN
153: l_creation_date := sysdate;

Line 152: IF (p_itm_rec.CREATION_DATE IS NULL OR p_itm_rec.CREATION_DATE = FND_API.G_MISS_DATE) THEN

148: FND_MSG_pub.ADD;
149: RAISE FND_API.g_exc_unexpected_error;
150: END IF;
151:
152: IF (p_itm_rec.CREATION_DATE IS NULL OR p_itm_rec.CREATION_DATE = FND_API.G_MISS_DATE) THEN
153: l_creation_date := sysdate;
154: ELSE
155: l_creation_date := p_itm_rec.CREATION_DATE;
156: END IF;

Line 159: OR p_itm_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN

155: l_creation_date := p_itm_rec.CREATION_DATE;
156: END IF;
157:
158: IF (p_itm_rec.LAST_UPDATED_BY IS NULL
159: OR p_itm_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN
160: l_updated_by := p_itm_rec.CREATED_BY;
161: ELSE l_updated_by := p_itm_rec.LAST_UPDATED_BY;
162: END IF;
163:

Line 164: IF (p_itm_rec.LAST_UPDATE_DATE IS NULL OR p_itm_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE) THEN

160: l_updated_by := p_itm_rec.CREATED_BY;
161: ELSE l_updated_by := p_itm_rec.LAST_UPDATED_BY;
162: END IF;
163:
164: IF (p_itm_rec.LAST_UPDATE_DATE IS NULL OR p_itm_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE) THEN
165: l_update_date := l_creation_date;
166: ELSE
167: l_update_date := p_itm_rec.LAST_UPDATE_DATE;
168: END IF;

Line 170: IF p_itm_rec.APPLICATION_ID = FND_API.G_MISS_NUM THEN

166: ELSE
167: l_update_date := p_itm_rec.LAST_UPDATE_DATE;
168: END IF;
169:
170: IF p_itm_rec.APPLICATION_ID = FND_API.G_MISS_NUM THEN
171: l_application_id := NULL;
172: END IF;
173:
174: /***************************************************************************

Line 205: , p_commit => FND_API.g_false

201:
202: JTF_CAL_ITEMS_PVT.insert_row
203: ( p_api_version => 1.0
204: , p_init_msg_list => p_init_msg_list
205: , p_commit => FND_API.g_false
206: , p_validation_level => FND_API.g_valid_level_full
207: , x_return_status => x_return_status
208: , x_msg_count => x_msg_count
209: , x_msg_data => x_msg_data

Line 206: , p_validation_level => FND_API.g_valid_level_full

202: JTF_CAL_ITEMS_PVT.insert_row
203: ( p_api_version => 1.0
204: , p_init_msg_list => p_init_msg_list
205: , p_commit => FND_API.g_false
206: , p_validation_level => FND_API.g_valid_level_full
207: , x_return_status => x_return_status
208: , x_msg_count => x_msg_count
209: , x_msg_data => x_msg_data
210: , p_itm_rec => l_pvt

Line 216: IF FND_API.To_Boolean(p_commit)

212: );
213: /***************************************************************************
214: ** Standard check of p_commit
215: ***************************************************************************/
216: IF FND_API.To_Boolean(p_commit)
217: THEN
218: COMMIT WORK;
219: END IF;
220: /***************************************************************************

Line 227: WHEN FND_API.G_EXC_ERROR

223: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
224: , p_data => x_msg_data
225: );
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR
228: THEN
229: ROLLBACK TO create_item_pub;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR
228: THEN
229: ROLLBACK TO create_item_pub;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
232: , p_data => x_msg_data
233: );
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
232: , p_data => x_msg_data
233: );
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
235: THEN
236: ROLLBACK TO create_item_pub;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: );
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
235: THEN
236: ROLLBACK TO create_item_pub;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
239: , p_data => x_msg_data
240: );
241: WHEN OTHERS

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: );
241: WHEN OTHERS
242: THEN
243: ROLLBACK TO create_item_pub;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
248: , l_api_name

Line 311: IF NOT FND_API.Compatible_API_Call( l_api_version

307: SAVEPOINT update_item_pub;
308: /***************************************************************************
309: ** Standard call to check for call compatibility
310: ***************************************************************************/
311: IF NOT FND_API.Compatible_API_Call( l_api_version
312: , p_api_version
313: , l_api_name
314: , G_PKG_NAME
315: )

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: , l_api_name
314: , G_PKG_NAME
315: )
316: THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: /***************************************************************************
320: ** Initialize message list if p_init_msg_list is set to TRUE
321: ***************************************************************************/

Line 322: IF FND_API.To_Boolean(p_init_msg_list)

318: END IF;
319: /***************************************************************************
320: ** Initialize message list if p_init_msg_list is set to TRUE
321: ***************************************************************************/
322: IF FND_API.To_Boolean(p_init_msg_list)
323: THEN
324: FND_MSG_PUB.Initialize;
325: END IF;
326: /***************************************************************************

Line 329: x_return_status := FND_API.G_RET_STS_SUCCESS;

325: END IF;
326: /***************************************************************************
327: ** Initialize API return status to success
328: ***************************************************************************/
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: IF (p_itm_rec.CAL_ITEM_ID IS NULL
332: OR p_itm_rec.CAL_ITEM_ID = FND_API.G_MISS_NUM) THEN
333: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INV_CAL_ITEM');

Line 332: OR p_itm_rec.CAL_ITEM_ID = FND_API.G_MISS_NUM) THEN

328: ***************************************************************************/
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: IF (p_itm_rec.CAL_ITEM_ID IS NULL
332: OR p_itm_rec.CAL_ITEM_ID = FND_API.G_MISS_NUM) THEN
333: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INV_CAL_ITEM');
334: FND_MSG_pub.ADD;
335: RAISE FND_API.g_exc_unexpected_error;
336: END IF;

Line 335: RAISE FND_API.g_exc_unexpected_error;

331: IF (p_itm_rec.CAL_ITEM_ID IS NULL
332: OR p_itm_rec.CAL_ITEM_ID = FND_API.G_MISS_NUM) THEN
333: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INV_CAL_ITEM');
334: FND_MSG_pub.ADD;
335: RAISE FND_API.g_exc_unexpected_error;
336: END IF;
337:
338: IF (p_itm_rec.OBJECT_VERSION_NUMBER IS NULL
339: OR p_itm_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN

Line 339: OR p_itm_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN

335: RAISE FND_API.g_exc_unexpected_error;
336: END IF;
337:
338: IF (p_itm_rec.OBJECT_VERSION_NUMBER IS NULL
339: OR p_itm_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN
340: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INV_OVN');
341: FND_MSG_pub.ADD;
342: RAISE FND_API.g_exc_unexpected_error;
343: END IF;

Line 342: RAISE FND_API.g_exc_unexpected_error;

338: IF (p_itm_rec.OBJECT_VERSION_NUMBER IS NULL
339: OR p_itm_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN
340: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INV_OVN');
341: FND_MSG_pub.ADD;
342: RAISE FND_API.g_exc_unexpected_error;
343: END IF;
344:
345: IF (p_itm_rec.LAST_UPDATED_BY IS NULL
346: OR p_itm_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN

Line 346: OR p_itm_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN

342: RAISE FND_API.g_exc_unexpected_error;
343: END IF;
344:
345: IF (p_itm_rec.LAST_UPDATED_BY IS NULL
346: OR p_itm_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN
347: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_LAST_UPDATE');
348: FND_MSG_pub.ADD;
349: RAISE FND_API.g_exc_unexpected_error;
350: END IF;

Line 349: RAISE FND_API.g_exc_unexpected_error;

345: IF (p_itm_rec.LAST_UPDATED_BY IS NULL
346: OR p_itm_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN
347: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_LAST_UPDATE');
348: FND_MSG_pub.ADD;
349: RAISE FND_API.g_exc_unexpected_error;
350: END IF;
351: /***************************************************************************
352: ** Validate timezone_id against hz_timezones
353: ***************************************************************************/

Line 355: AND p_itm_rec.TIMEZONE_ID <> FND_API.G_MISS_NUM) THEN

351: /***************************************************************************
352: ** Validate timezone_id against hz_timezones
353: ***************************************************************************/
354: IF (p_itm_rec.TIMEZONE_ID IS NOT NULL
355: AND p_itm_rec.TIMEZONE_ID <> FND_API.G_MISS_NUM) THEN
356: IF NOT JTF_CAL_UTILITY_PVT.isValidTimezone (p_itm_rec.TIMEZONE_ID) THEN
357: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_TIMEZONE');
358: FND_MESSAGE.set_token('TIMEZONE', p_itm_rec.TIMEZONE_ID);
359: FND_MSG_pub.ADD;

Line 360: RAISE FND_API.g_exc_unexpected_error;

356: IF NOT JTF_CAL_UTILITY_PVT.isValidTimezone (p_itm_rec.TIMEZONE_ID) THEN
357: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_TIMEZONE');
358: FND_MESSAGE.set_token('TIMEZONE', p_itm_rec.TIMEZONE_ID);
359: FND_MSG_pub.ADD;
360: RAISE FND_API.g_exc_unexpected_error;
361: END IF;
362: END IF;
363: /***************************************************************************
364: ** Validate source_code against jtf_objects metadata

Line 367: AND p_itm_rec.SOURCE_CODE <> FND_API.G_MISS_CHAR) THEN

363: /***************************************************************************
364: ** Validate source_code against jtf_objects metadata
365: ***************************************************************************/
366: IF (p_itm_rec.SOURCE_CODE IS NOT NULL
367: AND p_itm_rec.SOURCE_CODE <> FND_API.G_MISS_CHAR) THEN
368: IF NOT JTF_CAL_UTILITY_PVT.isValidObjectCode (p_itm_rec.SOURCE_CODE) THEN
369: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_SOURCE_CODE');
370: FND_MESSAGE.set_token('CODE', p_itm_rec.SOURCE_CODE);
371: FND_MSG_pub.ADD;

Line 372: RAISE FND_API.g_exc_unexpected_error;

368: IF NOT JTF_CAL_UTILITY_PVT.isValidObjectCode (p_itm_rec.SOURCE_CODE) THEN
369: FND_MESSAGE.set_name('JTF', 'JTF_CAL_INVALID_SOURCE_CODE');
370: FND_MESSAGE.set_token('CODE', p_itm_rec.SOURCE_CODE);
371: FND_MSG_pub.ADD;
372: RAISE FND_API.g_exc_unexpected_error;
373: END IF;
374: END IF;
375:
376: IF (p_itm_rec.LAST_UPDATE_DATE IS NULL

Line 377: OR p_itm_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE) THEN

373: END IF;
374: END IF;
375:
376: IF (p_itm_rec.LAST_UPDATE_DATE IS NULL
377: OR p_itm_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE) THEN
378: l_last_update_date := sysdate;
379: ELSE
380: l_last_update_date := p_itm_rec.LAST_UPDATE_DATE;
381: END IF;

Line 412: , p_commit => FND_API.g_false

408:
409: JTF_CAL_ITEMS_PVT.Update_Row
410: ( p_api_version => 1.0
411: , p_init_msg_list => p_init_msg_list
412: , p_commit => FND_API.g_false
413: , p_validation_level => FND_API.g_valid_level_full
414: , x_return_status => x_return_status
415: , x_msg_count => x_msg_count
416: , x_msg_data => x_msg_data

Line 413: , p_validation_level => FND_API.g_valid_level_full

409: JTF_CAL_ITEMS_PVT.Update_Row
410: ( p_api_version => 1.0
411: , p_init_msg_list => p_init_msg_list
412: , p_commit => FND_API.g_false
413: , p_validation_level => FND_API.g_valid_level_full
414: , x_return_status => x_return_status
415: , x_msg_count => x_msg_count
416: , x_msg_data => x_msg_data
417: , p_itm_rec => l_pvt

Line 423: IF FND_API.To_Boolean(p_commit)

419: );
420: /***************************************************************************
421: ** Standard check of p_commit
422: ***************************************************************************/
423: IF FND_API.To_Boolean(p_commit)
424: THEN
425: COMMIT WORK;
426: END IF;
427: /***************************************************************************

Line 434: WHEN FND_API.G_EXC_ERROR

430: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
431: , p_data => x_msg_data
432: );
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR
435: THEN
436: ROLLBACK TO update_item_pub;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 437: x_return_status := FND_API.G_RET_STS_ERROR;

433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR
435: THEN
436: ROLLBACK TO update_item_pub;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
439: , p_data => x_msg_data
440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

437: x_return_status := FND_API.G_RET_STS_ERROR;
438: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
439: , p_data => x_msg_data
440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
442: THEN
443: ROLLBACK TO update_item_pub;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
442: THEN
443: ROLLBACK TO update_item_pub;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
446: , p_data => x_msg_data
447: );
448: WHEN OTHERS

Line 451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

447: );
448: WHEN OTHERS
449: THEN
450: ROLLBACK TO update_item_pub;
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
455: , l_api_name

Line 517: IF NOT FND_API.Compatible_API_Call( l_api_version

513: SAVEPOINT delete_item_pub;
514: /***************************************************************************
515: ** Standard call to check for call compatibility
516: ***************************************************************************/
517: IF NOT FND_API.Compatible_API_Call( l_api_version
518: , p_api_version
519: , l_api_name
520: , G_PKG_NAME
521: )

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: , l_api_name
520: , G_PKG_NAME
521: )
522: THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: /***************************************************************************
526: ** Initialize message list if p_init_msg_list is set to TRUE
527: ***************************************************************************/

Line 528: IF FND_API.To_Boolean(p_init_msg_list)

524: END IF;
525: /***************************************************************************
526: ** Initialize message list if p_init_msg_list is set to TRUE
527: ***************************************************************************/
528: IF FND_API.To_Boolean(p_init_msg_list)
529: THEN
530: FND_MSG_PUB.Initialize;
531: END IF;
532: /***************************************************************************

Line 535: x_return_status := FND_API.G_RET_STS_SUCCESS;

531: END IF;
532: /***************************************************************************
533: ** Initialize API return status to success
534: ***************************************************************************/
535: x_return_status := FND_API.G_RET_STS_SUCCESS;
536: /***************************************************************************
537: ** Call private API to do update
538: ***************************************************************************/
539:

Line 543: , p_commit => FND_API.g_false

539:
540: JTF_CAL_ITEMS_PVT.Delete_Row
541: ( p_api_version => 1.0
542: , p_init_msg_list => p_init_msg_list
543: , p_commit => FND_API.g_false
544: , p_validation_level => FND_API.g_valid_level_full
545: , x_return_status => x_return_status
546: , x_msg_count => x_msg_count
547: , x_msg_data => x_msg_data

Line 544: , p_validation_level => FND_API.g_valid_level_full

540: JTF_CAL_ITEMS_PVT.Delete_Row
541: ( p_api_version => 1.0
542: , p_init_msg_list => p_init_msg_list
543: , p_commit => FND_API.g_false
544: , p_validation_level => FND_API.g_valid_level_full
545: , x_return_status => x_return_status
546: , x_msg_count => x_msg_count
547: , x_msg_data => x_msg_data
548: , p_cal_item_id => p_cal_item_id

Line 554: IF FND_API.To_Boolean(p_commit)

550: );
551: /***************************************************************************
552: ** Standard check of p_commit
553: ***************************************************************************/
554: IF FND_API.To_Boolean(p_commit)
555: THEN
556: COMMIT WORK;
557: END IF;
558: /***************************************************************************

Line 565: WHEN FND_API.G_EXC_ERROR

561: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
562: , p_data => x_msg_data
563: );
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR
566: THEN
567: ROLLBACK TO delete_item_pub;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR
566: THEN
567: ROLLBACK TO delete_item_pub;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
570: , p_data => x_msg_data
571: );
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

568: x_return_status := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
570: , p_data => x_msg_data
571: );
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
573: THEN
574: ROLLBACK TO delete_item_pub;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

571: );
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
573: THEN
574: ROLLBACK TO delete_item_pub;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
577: , p_data => x_msg_data
578: );
579: WHEN OTHERS

Line 582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

578: );
579: WHEN OTHERS
580: THEN
581: ROLLBACK TO delete_item_pub;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
586: , l_api_name

Line 643: IF NOT FND_API.Compatible_API_Call( l_api_version

639: BEGIN
640: /***************************************************************************
641: ** Standard call to check for call compatibility
642: ***************************************************************************/
643: IF NOT FND_API.Compatible_API_Call( l_api_version
644: , p_api_version
645: , l_api_name
646: , G_PKG_NAME
647: )

Line 649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

645: , l_api_name
646: , G_PKG_NAME
647: )
648: THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651: /***************************************************************************
652: ** Initialize message list if p_init_msg_list is set to TRUE
653: ***************************************************************************/

Line 654: IF FND_API.To_Boolean(p_init_msg_list)

650: END IF;
651: /***************************************************************************
652: ** Initialize message list if p_init_msg_list is set to TRUE
653: ***************************************************************************/
654: IF FND_API.To_Boolean(p_init_msg_list)
655: THEN
656: FND_MSG_PUB.Initialize;
657: END IF;
658: /***************************************************************************

Line 661: x_return_status := FND_API.G_RET_STS_SUCCESS;

657: END IF;
658: /***************************************************************************
659: ** Initialize API return status to success
660: ***************************************************************************/
661: x_return_status := FND_API.G_RET_STS_SUCCESS;
662: /***************************************************************************
663: ** Call private API
664: ***************************************************************************/
665: JTF_CAL_ITEMS_PVT.get_object_version

Line 668: , p_validation_level => FND_API.g_valid_level_full

664: ***************************************************************************/
665: JTF_CAL_ITEMS_PVT.get_object_version
666: ( p_api_version => 1.0
667: , p_init_msg_list => p_init_msg_list
668: , p_validation_level => FND_API.g_valid_level_full
669: , x_return_status => x_return_status
670: , x_msg_count => x_msg_count
671: , x_msg_data => x_msg_data
672: , p_cal_item_id => p_cal_item_id

Line 683: WHEN FND_API.G_EXC_ERROR

679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
680: , p_data => x_msg_data
681: );
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR
684: THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
687: , p_data => x_msg_data

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: );
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR
684: THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
687: , p_data => x_msg_data
688: );
689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
687: , p_data => x_msg_data
688: );
689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
690: THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
693: , p_data => x_msg_data

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

687: , p_data => x_msg_data
688: );
689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
690: THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
693: , p_data => x_msg_data
694: );
695: WHEN OTHERS

Line 697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

693: , p_data => x_msg_data
694: );
695: WHEN OTHERS
696: THEN
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
699: THEN
700: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
701: , l_api_name