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