DBA Data[Home] [Help]

APPS.JTF_CAL_ADDR_PVT dependencies on FND_MSG_PUB

Line 53: fnd_msg_pub.add;

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

Line 66: fnd_msg_pub.add;

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

Line 147: FND_MSG_PUB.Initialize;

143: -- Initialize message list if p_init_msg_list is set to TRUE
144: --
145: IF FND_API.To_Boolean(p_init_msg_list)
146: THEN
147: FND_MSG_PUB.Initialize;
148: END IF;
149:
150: --
151: -- Initialize API return status to success

Line 273: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

269:
270: --
271: -- Standard call to get message count and if count is 1, get message info
272: --
273: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
274: , p_data => x_msg_data
275: );
276:
277: EXCEPTION

Line 282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

278: WHEN FND_API.G_EXC_ERROR
279: THEN
280: ROLLBACK TO Create_Address_PVT;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
283: , p_data => x_msg_data
284: );
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
287: THEN
288: ROLLBACK TO Create_Address_PVT;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
291: , p_data => x_msg_data
292: );
293: WHEN OTHERS
294: THEN

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

293: WHEN OTHERS
294: THEN
295: ROLLBACK TO Create_Address_PVT;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
300: , l_api_name
301: );

Line 299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

295: ROLLBACK TO Create_Address_PVT;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
300: , l_api_name
301: );
302: END IF;
303: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 303: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
300: , l_api_name
301: );
302: END IF;
303: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
304: , p_data => x_msg_data
305: );
306:
307: END Insert_Row;

Line 374: FND_MSG_PUB.Initialize;

370:
371: -- Initialize message list if p_init_msg_list is set to TRUE
372: IF FND_API.To_Boolean(p_init_msg_list)
373: THEN
374: FND_MSG_PUB.Initialize;
375: END IF;
376:
377: -- Initialize API return status to success
378: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 452: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

448:
449: --
450: -- Standard call to get message count and if count is 1, get message info
451: --
452: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
453: , p_data => x_msg_data
454: );
455:
456: EXCEPTION

Line 461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

457: WHEN FND_API.G_EXC_ERROR
458: THEN
459: ROLLBACK TO Update_Address_PVT;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
462: , p_data => x_msg_data
463: );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
466: THEN
467: ROLLBACK TO Update_Address_PVT;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
470: , p_data => x_msg_data
471: );
472:
473: WHEN OTHERS

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

473: WHEN OTHERS
474: THEN
475: ROLLBACK TO Update_Address_PVT;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
478: THEN
479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
480: , l_api_name
481: );

Line 479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

475: ROLLBACK TO Update_Address_PVT;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
478: THEN
479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
480: , l_api_name
481: );
482: END IF;
483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
480: , l_api_name
481: );
482: END IF;
483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
484: , p_data => x_msg_data
485: );
486:
487: END Update_Row;

Line 559: FND_MSG_PUB.initialize;

555: -- Initialize message list if requested
556: --
557: IF FND_API.to_Boolean( p_init_msg_list )
558: THEN
559: FND_MSG_PUB.initialize;
560: END IF;
561:
562: -- Try to lock the row before updating it
563: Lock_Row( p_address_id

Line 591: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

587: --
588: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
589:
590:
591: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
592: , p_data => X_MSG_DATA
593: );
594:
595: EXCEPTION

Line 600: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

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

Line 608: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

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

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

612: WHEN OTHERS
613: THEN
614: ROLLBACK TO Delete_ExpressionLine_PVT;
615: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
619: , l_api_name
620: );

Line 618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

614: ROLLBACK TO Delete_ExpressionLine_PVT;
615: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
619: , l_api_name
620: );
621: END IF;
622: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 622: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
619: , l_api_name
620: );
621: END IF;
622: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
623: , p_data => X_MSG_DATA
624: );
625:
626: END Delete_Row;