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_MSG_PUB

Line 74: FND_MSG_PUB.Initialize;

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: /***************************************************************************
77: ** Initialize API return status to success
78: ***************************************************************************/

Line 89: FND_MSG_pub.ADD;

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;
91: END IF;
92:
93: /***************************************************************************

Line 100: FND_MSG_pub.ADD;

96:
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

Line 107: FND_MSG_pub.ADD;

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;
110:
111: IF (p_itm_rec.START_DATE IS NULL

Line 114: FND_MSG_pub.ADD;

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;
117:
118: IF (p_itm_rec.END_DATE IS NULL

Line 121: FND_MSG_pub.ADD;

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;
124: /***************************************************************************
125: ** End date cannot be before start date

Line 132: FND_MSG_pub.ADD;

128: IF p_itm_rec.START_DATE > p_itm_rec.END_DATE THEN
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

Line 142: FND_MSG_pub.ADD;

138:
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

Line 148: FND_MSG_pub.ADD;

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;
151:
152: IF (p_itm_rec.CREATION_DATE IS NULL OR p_itm_rec.CREATION_DATE = FND_API.G_MISS_DATE) THEN

Line 223: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

219: END IF;
220: /***************************************************************************
221: ** Standard call to get message count and if count is 1, get message info
222: ***************************************************************************/
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

Line 231: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
235: THEN

Line 238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
242: THEN

Line 245: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME

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
249: );
250: END IF;
251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
248: , l_api_name
249: );
250: END IF;
251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
252: , p_data => x_msg_data
253: );
254: END CreateItem;
255:

Line 324: FND_MSG_PUB.Initialize;

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: /***************************************************************************
327: ** Initialize API return status to success
328: ***************************************************************************/

Line 334: FND_MSG_pub.ADD;

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;
337:
338: IF (p_itm_rec.OBJECT_VERSION_NUMBER IS NULL

Line 341: FND_MSG_pub.ADD;

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;
344:
345: IF (p_itm_rec.LAST_UPDATED_BY IS NULL

Line 348: FND_MSG_pub.ADD;

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;
351: /***************************************************************************
352: ** Validate timezone_id against hz_timezones

Line 359: FND_MSG_pub.ADD;

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;
360: RAISE FND_API.g_exc_unexpected_error;
361: END IF;
362: END IF;
363: /***************************************************************************

Line 371: FND_MSG_pub.ADD;

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;
372: RAISE FND_API.g_exc_unexpected_error;
373: END IF;
374: END IF;
375:

Line 430: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

426: END IF;
427: /***************************************************************************
428: ** Standard call to get message count and if count is 1, get message info
429: ***************************************************************************/
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

Line 438: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
442: THEN

Line 445: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
449: THEN

Line 452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 454: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME

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
456: );
457: END IF;
458: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 458: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

454: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
455: , l_api_name
456: );
457: END IF;
458: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
459: , p_data => x_msg_data
460: );
461:
462: END UpdateItem;

Line 530: FND_MSG_PUB.Initialize;

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: /***************************************************************************
533: ** Initialize API return status to success
534: ***************************************************************************/

Line 561: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

557: END IF;
558: /***************************************************************************
559: ** Standard call to get message count and if count is 1, get message info
560: ***************************************************************************/
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

Line 569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
573: THEN

Line 576: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
580: THEN

Line 583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 585: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME

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
587: );
588: END IF;
589: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 589: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

585: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
586: , l_api_name
587: );
588: END IF;
589: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
590: , p_data => x_msg_data
591: );
592:
593: END DeleteItem;

Line 656: FND_MSG_PUB.Initialize;

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: /***************************************************************************
659: ** Initialize API return status to success
660: ***************************************************************************/

Line 679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

675: x_object_version_number := l_object_version_number;
676: /***************************************************************************
677: ** Standard call to get message count and if count is 1, get message info
678: ***************************************************************************/
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

Line 686: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
690: THEN

Line 692: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
696: THEN

Line 698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 700: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME

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
702: );
703: END IF;
704: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 704: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

700: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
701: , l_api_name
702: );
703: END IF;
704: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
705: , p_data => x_msg_data
706: );
707:
708: END GetObjectVersion;