DBA Data[Home] [Help]

APPS.AMS_APPR_HIST_PVT dependencies on FND_MSG_PUB

Line 111: FND_MSG_PUB.initialize;

107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: IF FND_API.to_Boolean( p_init_msg_list )
110: THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113:
114:
115: -- Initialize API return status to SUCCESS

Line 186: FND_MSG_PUB.Count_And_Get

182: COMMIT WORK;
183: END IF;
184:
185: -- Standard call to get message count and if count is 1, get message info.
186: FND_MSG_PUB.Count_And_Get
187: (p_count => x_msg_count,
188: p_data => x_msg_data
189: );
190: EXCEPTION

Line 199: FND_MSG_PUB.Count_And_Get (

195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO CREATE_Appr_Hist_PVT;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: -- Standard call to get message count and if count=1, get the message
199: FND_MSG_PUB.Count_And_Get (
200: p_encoded => FND_API.G_FALSE,
201: p_count => x_msg_count,
202: p_data => x_msg_data
203: );

Line 209: FND_MSG_PUB.Count_And_Get (

205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO CREATE_Appr_Hist_PVT;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: -- Standard call to get message count and if count=1, get the message
209: FND_MSG_PUB.Count_And_Get (
210: p_encoded => FND_API.G_FALSE,
211: p_count => x_msg_count,
212: p_data => x_msg_data
213: );

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

214:
215: WHEN OTHERS THEN
216: ROLLBACK TO CREATE_Appr_Hist_PVT;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;
222: -- Standard call to get message count and if count=1, get the message

Line 220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

216: ROLLBACK TO CREATE_Appr_Hist_PVT;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,

Line 223: FND_MSG_PUB.Count_And_Get (

219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
227: );

Line 317: FND_MSG_PUB.initialize;

313:
314: -- Initialize message list if p_init_msg_list is set to TRUE.
315: IF FND_API.to_Boolean( p_init_msg_list )
316: THEN
317: FND_MSG_PUB.initialize;
318: END IF;
319:
320: -- Initialize API return status to SUCCESS
321: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 409: FND_MSG_PUB.Count_And_Get

405:
406:
407:
408: -- Standard call to get message count and if count is 1, get message info.
409: FND_MSG_PUB.Count_And_Get
410: (p_count => x_msg_count,
411: p_data => x_msg_data
412: );
413: EXCEPTION

Line 423: FND_MSG_PUB.Count_And_Get (

419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO UPDATE_Appr_Hist_PVT;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,
426: p_data => x_msg_data
427: );

Line 433: FND_MSG_PUB.Count_And_Get (

429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ROLLBACK TO UPDATE_Appr_Hist_PVT;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: -- Standard call to get message count and if count=1, get the message
433: FND_MSG_PUB.Count_And_Get (
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,
436: p_data => x_msg_data
437: );

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

438:
439: WHEN OTHERS THEN
440: ROLLBACK TO UPDATE_Appr_Hist_PVT;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
445: END IF;
446: -- Standard call to get message count and if count=1, get the message

Line 444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

440: ROLLBACK TO UPDATE_Appr_Hist_PVT;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
445: END IF;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (
448: p_encoded => FND_API.G_FALSE,

Line 447: FND_MSG_PUB.Count_And_Get (

443: THEN
444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
445: END IF;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (
448: p_encoded => FND_API.G_FALSE,
449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );

Line 527: FND_MSG_PUB.initialize;

523:
524: -- Initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_Boolean( p_init_msg_list )
526: THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529:
530: -- Initialize API return status to SUCCESS
531: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 552: FND_MSG_PUB.Count_And_Get

548: COMMIT WORK;
549: END IF;
550:
551: -- Standard call to get message count and if count is 1, get message info.
552: FND_MSG_PUB.Count_And_Get
553: (p_count => x_msg_count,
554: p_data => x_msg_data
555: );
556: EXCEPTION

Line 565: FND_MSG_PUB.Count_And_Get (

561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO DELETE_Appr_Hist_PVT;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,
568: p_data => x_msg_data
569: );

Line 575: FND_MSG_PUB.Count_And_Get (

571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO DELETE_Appr_Hist_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );

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

580:
581: WHEN OTHERS THEN
582: ROLLBACK TO DELETE_Appr_Hist_PVT;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
587: END IF;
588: -- Standard call to get message count and if count=1, get the message

Line 586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

582: ROLLBACK TO DELETE_Appr_Hist_PVT;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
587: END IF;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,

Line 589: FND_MSG_PUB.Count_And_Get (

585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
587: END IF;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data
593: );

Line 937: FND_MSG_PUB.initialize;

933:
934: -- Initialize message list if p_init_msg_list is set to TRUE.
935: IF FND_API.to_Boolean( p_init_msg_list )
936: THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940:
941: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 987: FND_MSG_PUB.Count_And_Get

983: -- Initialize API return status to SUCCESS
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985:
986: -- Standard call to get message count and if count is 1, get message info.
987: FND_MSG_PUB.Count_And_Get
988: (p_count => x_msg_count,
989: p_data => x_msg_data
990: );
991: EXCEPTION

Line 1001: FND_MSG_PUB.Count_And_Get (

997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO VALIDATE_Appr_Hist_;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );

Line 1011: FND_MSG_PUB.Count_And_Get (

1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO VALIDATE_Appr_Hist_;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );

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

1016:
1017: WHEN OTHERS THEN
1018: ROLLBACK TO VALIDATE_Appr_Hist_;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message

Line 1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1018: ROLLBACK TO VALIDATE_Appr_Hist_;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,

Line 1025: FND_MSG_PUB.Count_And_Get (

1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );

Line 1046: FND_MSG_PUB.initialize;

1042: BEGIN
1043: -- Initialize message list if p_init_msg_list is set to TRUE.
1044: IF FND_API.to_Boolean( p_init_msg_list )
1045: THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:
1049:
1050:

Line 1060: FND_MSG_PUB.Count_And_Get

1056: -- THEN
1057: -- x_return_status := FND_API.G_RET_STS_ERROR;
1058:
1059: -- Standard call to get message count and if count is 1, get message info.
1060: FND_MSG_PUB.Count_And_Get
1061: (p_count => x_msg_count,
1062: p_data => x_msg_data
1063: );
1064: END Validate_appr_hist_Rec;