DBA Data[Home] [Help]

APPS.JTF_CAL_ITEMS_PVT dependencies on FND_MSG_PUB

Line 52: fnd_msg_pub.add;

48: IF (c_lock%NOTFOUND)
49: THEN
50: CLOSE c_lock;
51: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_DELETED');
52: fnd_msg_pub.add;
53: RAISE fnd_api.g_exc_unexpected_error;
54: END IF;
55:
56: /***************************************************************************

Line 64: fnd_msg_pub.add;

60: CLOSE c_lock;
61: IF (l_object_version_number <> p_object_version_number)
62: THEN
63: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_CHANGED');
64: fnd_msg_pub.add;
65: RAISE fnd_api.g_exc_unexpected_error;
66: END IF;
67: END Lock_Row;
68:

Line 112: FND_MSG_PUB.Initialize;

108: ***************************************************************************/
109:
110: IF FND_API.To_Boolean(p_init_msg_list)
111: THEN
112: FND_MSG_PUB.Initialize;
113: END IF;
114: /***************************************************************************
115: ** Initialize API return status to success
116: ***************************************************************************/

Line 228: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

224: END IF;
225: /***************************************************************************
226: ** Standard call to get message count and if count is 1, get message info
227: ***************************************************************************/
228: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
229: , p_data => x_msg_data
230: );
231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN

Line 238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

234: CLOSE c_record_exists;
235: END IF;
236: ROLLBACK TO create_calitems_pvt;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
239: , p_data => x_msg_data
240: );
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

244: CLOSE c_record_exists;
245: END IF;
246: ROLLBACK TO create_calitems_pvt;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
249: , p_data => x_msg_data
250: );
251: WHEN OTHERS THEN
252: IF (c_record_exists%ISOPEN) THEN

Line 257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

253: CLOSE c_record_exists;
254: END IF;
255: ROLLBACK TO create_calitems_pvt;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
258: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
259: , l_api_name
260: );
261: END IF;

Line 258: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME

254: END IF;
255: ROLLBACK TO create_calitems_pvt;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
258: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
259: , l_api_name
260: );
261: END IF;
262: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 262: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

258: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
259: , l_api_name
260: );
261: END IF;
262: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
263: , p_data => x_msg_data
264: );
265:
266: END Insert_Row;

Line 387: FND_MSG_PUB.initialize;

383: ** Initialize message list if p_init_msg_list is set to TRUE
384: ***************************************************************************/
385: IF FND_API.To_Boolean(p_init_msg_list)
386: THEN
387: FND_MSG_PUB.initialize;
388: END IF;
389: /***************************************************************************
390: ** Initialize API return status to success
391: ***************************************************************************/

Line 404: fnd_msg_pub.add;

400: CLOSE c_item;
401: END IF;
402: fnd_message.set_name ('JTF', 'JTF_CAL_INV_CAL_ITEM');
403: fnd_message.set_token ('CAL_ITEM_ID', p_itm_rec.cal_item_id);
404: fnd_msg_pub.add;
405: RAISE no_data_found;
406: END IF;
407:
408: IF (c_item%ISOPEN)THEN

Line 419: FND_MSG_pub.ADD;

415: IF (l_item_rec.START_DATE > l_item_rec.END_DATE) THEN
416: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_DATE');
417: FND_MESSAGE.set_token('P_START_DATE', to_char(l_item_rec.START_DATE, 'YYYYMMDDHH24MISS'));
418: FND_MESSAGE.set_token('P_END_DATE', to_char(l_item_rec.END_DATE, 'YYYYMMDDHH24MISS'));
419: FND_MSG_pub.ADD;
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;
422: /***************************************************************************
423: ** Try to lock the row before updating it

Line 478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

474: END IF;
475: /***************************************************************************
476: ** Standard call to get message count and if count is 1, get message info
477: ***************************************************************************/
478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
479: , p_data => x_msg_data
480: );
481:
482: EXCEPTION

Line 489: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

485: CLOSE c_item;
486: END IF;
487: ROLLBACK TO update_calitems_pvt;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
490: , p_data => x_msg_data
491: );
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

495: CLOSE c_item;
496: END IF;
497: ROLLBACK TO update_calitems_pvt;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
500: , p_data => x_msg_data
501: );
502: WHEN OTHERS THEN
503: IF (c_item%ISOPEN) THEN

Line 508: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

504: CLOSE c_item;
505: END IF;
506: ROLLBACK TO update_calitems_pvt;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
509: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
510: , l_api_name
511: );
512: END IF;

Line 509: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME

505: END IF;
506: ROLLBACK TO update_calitems_pvt;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
509: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
510: , l_api_name
511: );
512: END IF;
513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

509: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
510: , l_api_name
511: );
512: END IF;
513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
514: , p_data => x_msg_data
515: );
516: END Update_Row;
517:

Line 554: FND_MSG_PUB.initialize;

550: ** Initialize message list if requested
551: ***************************************************************************/
552: IF FND_API.to_Boolean( p_init_msg_list )
553: THEN
554: FND_MSG_PUB.initialize;
555: END IF;
556: /***************************************************************************
557: ** Initialize return status to SUCCESS
558: ***************************************************************************/

Line 590: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

586: IF FND_API.To_Boolean(p_commit) THEN
587: COMMIT WORK;
588: END IF;
589:
590: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
591: , p_data => X_MSG_DATA
592: );
593: EXCEPTION
594: WHEN FND_API.G_EXC_ERROR

Line 598: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

594: WHEN FND_API.G_EXC_ERROR
595: THEN
596: ROLLBACK TO delete_calitems_pvt;
597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
599: , p_data => X_MSG_DATA
600: );
601:
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 606: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
603: THEN
604: ROLLBACK TO delete_calitems_pvt;
605: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
607: , p_data => X_MSG_DATA
608: );
609: WHEN OTHERS THEN
610: ROLLBACK TO delete_calitems_pvt;

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

608: );
609: WHEN OTHERS THEN
610: ROLLBACK TO delete_calitems_pvt;
611: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
612: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
615: , l_api_name
616: );

Line 614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

610: ROLLBACK TO delete_calitems_pvt;
611: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
612: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
615: , l_api_name
616: );
617: END IF;
618: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 618: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
615: , l_api_name
616: );
617: END IF;
618: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
619: , p_data => X_MSG_DATA
620: );
621: END Delete_Row;
622:

Line 662: FND_MSG_PUB.Initialize;

658: ** Initialize message list if p_init_msg_list is set to TRUE
659: ***************************************************************************/
660: IF FND_API.To_Boolean(p_init_msg_list)
661: THEN
662: FND_MSG_PUB.Initialize;
663: END IF;
664: /***************************************************************************
665: ** Initialize API return status to success
666: ***************************************************************************/

Line 695: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

691:
692: /***************************************************************************
693: ** Standard call to get message count and if count is 1, get message info
694: ***************************************************************************/
695: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
696: , p_data => x_msg_data
697: );
698:
699: END Get_Object_Version;