DBA Data[Home] [Help]

APPS.AMW_RISK_PVT dependencies on FND_MSG_PUB

Line 210: FND_MSG_PUB.Count_And_Get(

206:
207: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
208:
209: -- Standard call to get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get(
211: p_count => x_msg_count,
212: p_data => x_msg_data);
213:
214: EXCEPTION

Line 220: FND_MSG_PUB.Count_And_Get (

216: WHEN FND_API.G_EXC_ERROR THEN
217:
218: x_return_status := G_RET_STS_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: FND_MSG_PUB.Count_And_Get (
221: p_encoded => G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data);
224:

Line 229: FND_MSG_PUB.Count_And_Get (

225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226:
227: x_return_status := G_RET_STS_UNEXP_ERROR;
228: -- Standard call to get message count and if count=1, get the message
229: FND_MSG_PUB.Count_And_Get (
230: p_encoded => G_FALSE,
231: p_count => x_msg_count,
232: p_data => x_msg_data);
233:

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

233:
234: WHEN OTHERS THEN
235:
236: x_return_status := G_RET_STS_UNEXP_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: THEN
239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
240: END IF;
241: -- Standard call to get message count and if count=1, get the message

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

235:
236: x_return_status := G_RET_STS_UNEXP_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: THEN
239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
240: END IF;
241: -- Standard call to get message count and if count=1, get the message
242: FND_MSG_PUB.Count_And_Get (
243: p_encoded => G_FALSE,

Line 242: FND_MSG_PUB.Count_And_Get (

238: THEN
239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
240: END IF;
241: -- Standard call to get message count and if count=1, get the message
242: FND_MSG_PUB.Count_And_Get (
243: p_encoded => G_FALSE,
244: p_count => x_msg_count,
245: p_data => x_msg_data);
246:

Line 293: FND_MSG_PUB.initialize;

289: BEGIN
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( p_init_msg_list )
292: THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:
296: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
297:

Line 464: FND_MSG_PUB.Count_And_Get

460:
461: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
462:
463: -- Standard call to get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get
465: (p_count => x_msg_count,
466: p_data => x_msg_data);
467:
468: EXCEPTION

Line 473: FND_MSG_PUB.Count_And_Get (

469:
470: WHEN FND_API.G_EXC_ERROR THEN
471: x_return_status := G_RET_STS_ERROR;
472: -- Standard call to get message count and if count=1, get the message
473: FND_MSG_PUB.Count_And_Get (
474: p_encoded => G_FALSE,
475: p_count => x_msg_count,
476: p_data => x_msg_data
477: );

Line 482: FND_MSG_PUB.Count_And_Get (

478:
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: x_return_status := G_RET_STS_UNEXP_ERROR;
481: -- Standard call to get message count and if count=1, get the message
482: FND_MSG_PUB.Count_And_Get (
483: p_encoded => G_FALSE,
484: p_count => x_msg_count,
485: p_data => x_msg_data);
486:

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

485: p_data => x_msg_data);
486:
487: WHEN OTHERS THEN
488: x_return_status := G_RET_STS_UNEXP_ERROR;
489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
490: THEN
491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
492: END IF;
493: -- Standard call to get message count and if count=1, get the message

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

487: WHEN OTHERS THEN
488: x_return_status := G_RET_STS_UNEXP_ERROR;
489: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
490: THEN
491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
492: END IF;
493: -- Standard call to get message count and if count=1, get the message
494: FND_MSG_PUB.Count_And_Get (
495: p_encoded => G_FALSE,

Line 494: FND_MSG_PUB.Count_And_Get (

490: THEN
491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
492: END IF;
493: -- Standard call to get message count and if count=1, get the message
494: FND_MSG_PUB.Count_And_Get (
495: p_encoded => G_FALSE,
496: p_count => x_msg_count,
497: p_data => x_msg_data);
498:

Line 573: FND_MSG_PUB.initialize;

569:
570: -- Initialize message list if p_init_msg_list is set to TRUE.
571: IF FND_API.to_Boolean( p_init_msg_list )
572: THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
577:

Line 715: FND_MSG_PUB.Count_And_Get

711:
712: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
713:
714: -- Standard call to get message count and if count is 1, get message info.
715: FND_MSG_PUB.Count_And_Get
716: (p_count => x_msg_count,
717: p_data => x_msg_data);
718:
719: EXCEPTION

Line 728: FND_MSG_PUB.Count_And_Get (

724: WHEN FND_API.G_EXC_ERROR THEN
725: ROLLBACK TO CREATE_Risk_PVT;
726: x_return_status := G_RET_STS_ERROR;
727: -- Standard call to get message count and if count=1, get the message
728: FND_MSG_PUB.Count_And_Get (
729: p_encoded => G_FALSE,
730: p_count => x_msg_count,
731: p_data => x_msg_data);
732:

Line 737: FND_MSG_PUB.Count_And_Get (

733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO CREATE_Risk_PVT;
735: x_return_status := G_RET_STS_UNEXP_ERROR;
736: -- Standard call to get message count and if count=1, get the message
737: FND_MSG_PUB.Count_And_Get (
738: p_encoded => G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data);
741:

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

741:
742: WHEN OTHERS THEN
743: ROLLBACK TO CREATE_Risk_PVT;
744: x_return_status := G_RET_STS_UNEXP_ERROR;
745: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
746: THEN
747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
748: END IF;
749: -- Standard call to get message count and if count=1, get the message

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

743: ROLLBACK TO CREATE_Risk_PVT;
744: x_return_status := G_RET_STS_UNEXP_ERROR;
745: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
746: THEN
747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
748: END IF;
749: -- Standard call to get message count and if count=1, get the message
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => G_FALSE,

Line 750: FND_MSG_PUB.Count_And_Get (

746: THEN
747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
748: END IF;
749: -- Standard call to get message count and if count=1, get the message
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => G_FALSE,
752: p_count => x_msg_count,
753: p_data => x_msg_data);
754:

Line 814: FND_MSG_PUB.initialize;

810:
811: -- Initialize message list if p_init_msg_list is set to TRUE.
812: IF FND_API.to_Boolean( p_init_msg_list )
813: THEN
814: FND_MSG_PUB.initialize;
815: END IF;
816:
817: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
818:

Line 923: FND_MSG_PUB.Count_And_Get

919:
920: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
921:
922: -- Standard call to get message count and if count is 1, get message info.
923: FND_MSG_PUB.Count_And_Get
924: (p_count => x_msg_count,
925: p_data => x_msg_data);
926:
927: EXCEPTION

Line 937: FND_MSG_PUB.Count_And_Get (

933: WHEN FND_API.G_EXC_ERROR THEN
934: ROLLBACK TO UPDATE_Risk_PVT;
935: x_return_status := G_RET_STS_ERROR;
936: -- Standard call to get message count and if count=1, get the message
937: FND_MSG_PUB.Count_And_Get (
938: p_encoded => G_FALSE,
939: p_count => x_msg_count,
940: p_data => x_msg_data);
941:

Line 946: FND_MSG_PUB.Count_And_Get (

942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943: ROLLBACK TO UPDATE_Risk_PVT;
944: x_return_status := G_RET_STS_UNEXP_ERROR;
945: -- Standard call to get message count and if count=1, get the message
946: FND_MSG_PUB.Count_And_Get (
947: p_encoded => G_FALSE,
948: p_count => x_msg_count,
949: p_data => x_msg_data);
950:

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

950:
951: WHEN OTHERS THEN
952: ROLLBACK TO UPDATE_Risk_PVT;
953: x_return_status := G_RET_STS_UNEXP_ERROR;
954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: -- Standard call to get message count and if count=1, get the message

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

952: ROLLBACK TO UPDATE_Risk_PVT;
953: x_return_status := G_RET_STS_UNEXP_ERROR;
954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: -- Standard call to get message count and if count=1, get the message
959: FND_MSG_PUB.Count_And_Get (
960: p_encoded => G_FALSE,

Line 959: FND_MSG_PUB.Count_And_Get (

955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
957: END IF;
958: -- Standard call to get message count and if count=1, get the message
959: FND_MSG_PUB.Count_And_Get (
960: p_encoded => G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data);
963:

Line 1007: FND_MSG_PUB.initialize;

1003:
1004: -- Initialize message list if p_init_msg_list is set to TRUE.
1005: IF FND_API.to_Boolean( p_init_msg_list )
1006: THEN
1007: FND_MSG_PUB.initialize;
1008: END IF;
1009:
1010: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1011:

Line 1033: FND_MSG_PUB.Count_And_Get

1029:
1030: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1031:
1032: -- Standard call to get message count and if count is 1, get message info.
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,
1035: p_data => x_msg_data);
1036:
1037: EXCEPTION

Line 1047: FND_MSG_PUB.Count_And_Get (

1043: WHEN FND_API.G_EXC_ERROR THEN
1044: ROLLBACK TO DELETE_Risk_PVT;
1045: x_return_status := G_RET_STS_ERROR;
1046: -- Standard call to get message count and if count=1, get the message
1047: FND_MSG_PUB.Count_And_Get (
1048: p_encoded => G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => x_msg_data);
1051:

Line 1056: FND_MSG_PUB.Count_And_Get (

1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1053: ROLLBACK TO DELETE_Risk_PVT;
1054: x_return_status := G_RET_STS_UNEXP_ERROR;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => G_FALSE,
1058: p_count => x_msg_count,
1059: p_data => x_msg_data);
1060:

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

1060:
1061: WHEN OTHERS THEN
1062: ROLLBACK TO DELETE_Risk_PVT;
1063: x_return_status := G_RET_STS_UNEXP_ERROR;
1064: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1067: END IF;
1068: -- Standard call to get message count and if count=1, get the message

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

1062: ROLLBACK TO DELETE_Risk_PVT;
1063: x_return_status := G_RET_STS_UNEXP_ERROR;
1064: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1067: END IF;
1068: -- Standard call to get message count and if count=1, get the message
1069: FND_MSG_PUB.Count_And_Get (
1070: p_encoded => G_FALSE,

Line 1069: FND_MSG_PUB.Count_And_Get (

1065: THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1067: END IF;
1068: -- Standard call to get message count and if count=1, get the message
1069: FND_MSG_PUB.Count_And_Get (
1070: p_encoded => G_FALSE,
1071: p_count => x_msg_count,
1072: p_data => x_msg_data);
1073:

Line 1131: FND_MSG_PUB.initialize;

1127:
1128: -- Initialize message list if p_init_msg_list is set to TRUE.
1129: IF FND_API.to_Boolean( p_init_msg_list )
1130: THEN
1131: FND_MSG_PUB.initialize;
1132: END IF;
1133:
1134: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1135:

Line 1237: FND_MSG_PUB.Count_And_Get

1233:
1234: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1235:
1236: -- Standard call to get message count and if count is 1, get message info.
1237: FND_MSG_PUB.Count_And_Get
1238: (p_count => x_msg_count,
1239: p_data => x_msg_data);
1240:
1241: EXCEPTION

Line 1251: FND_MSG_PUB.Count_And_Get (

1247: WHEN FND_API.G_EXC_ERROR THEN
1248: ROLLBACK TO REVISE_Risk_PVT;
1249: x_return_status := G_RET_STS_ERROR;
1250: -- Standard call to get message count and if count=1, get the message
1251: FND_MSG_PUB.Count_And_Get (
1252: p_encoded => G_FALSE,
1253: p_count => x_msg_count,
1254: p_data => x_msg_data);
1255:

Line 1260: FND_MSG_PUB.Count_And_Get (

1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257: ROLLBACK TO REVISE_Risk_PVT;
1258: x_return_status := G_RET_STS_UNEXP_ERROR;
1259: -- Standard call to get message count and if count=1, get the message
1260: FND_MSG_PUB.Count_And_Get (
1261: p_encoded => G_FALSE,
1262: p_count => x_msg_count,
1263: p_data => x_msg_data);
1264:

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

1264:
1265: WHEN OTHERS THEN
1266: ROLLBACK TO REVISE_Risk_PVT;
1267: x_return_status := G_RET_STS_UNEXP_ERROR;
1268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message

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

1266: ROLLBACK TO REVISE_Risk_PVT;
1267: x_return_status := G_RET_STS_UNEXP_ERROR;
1268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => G_FALSE,

Line 1273: FND_MSG_PUB.Count_And_Get (

1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => G_FALSE,
1275: p_count => x_msg_count,
1276: p_data => x_msg_data);
1277:

Line 1856: FND_MSG_PUB.initialize;

1852:
1853: -- Initialize message list if p_init_msg_list is set to TRUE.
1854: IF FND_API.to_Boolean( p_init_msg_list )
1855: THEN
1856: FND_MSG_PUB.initialize;
1857: END IF;
1858:
1859: l_risk_rec := p_risk_rec;
1860: -- 07.21.2003 tsho, only update and revise need complete_risk_rec

Line 1904: FND_MSG_PUB.Count_And_Get

1900:
1901: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1902:
1903: -- Standard call to get message count and if count is 1, get message info.
1904: FND_MSG_PUB.Count_And_Get
1905: (p_count => x_msg_count,
1906: p_data => x_msg_data);
1907:
1908: EXCEPTION

Line 1918: FND_MSG_PUB.Count_And_Get (

1914: WHEN FND_API.G_EXC_ERROR THEN
1915: ROLLBACK TO VALIDATE_Risk_;
1916: x_return_status := G_RET_STS_ERROR;
1917: -- Standard call to get message count and if count=1, get the message
1918: FND_MSG_PUB.Count_And_Get (
1919: p_encoded => G_FALSE,
1920: p_count => x_msg_count,
1921: p_data => x_msg_data);
1922:

Line 1927: FND_MSG_PUB.Count_And_Get (

1923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1924: ROLLBACK TO VALIDATE_Risk_;
1925: x_return_status := G_RET_STS_UNEXP_ERROR;
1926: -- Standard call to get message count and if count=1, get the message
1927: FND_MSG_PUB.Count_And_Get (
1928: p_encoded => G_FALSE,
1929: p_count => x_msg_count,
1930: p_data => x_msg_data);
1931:

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

1931:
1932: WHEN OTHERS THEN
1933: ROLLBACK TO VALIDATE_Risk_;
1934: x_return_status := G_RET_STS_UNEXP_ERROR;
1935: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1936: THEN
1937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1938: END IF;
1939: -- Standard call to get message count and if count=1, get the message

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

1933: ROLLBACK TO VALIDATE_Risk_;
1934: x_return_status := G_RET_STS_UNEXP_ERROR;
1935: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1936: THEN
1937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1938: END IF;
1939: -- Standard call to get message count and if count=1, get the message
1940: FND_MSG_PUB.Count_And_Get (
1941: p_encoded => G_FALSE,

Line 1940: FND_MSG_PUB.Count_And_Get (

1936: THEN
1937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1938: END IF;
1939: -- Standard call to get message count and if count=1, get the message
1940: FND_MSG_PUB.Count_And_Get (
1941: p_encoded => G_FALSE,
1942: p_count => x_msg_count,
1943: p_data => x_msg_data);
1944:

Line 1976: FND_MSG_PUB.initialize;

1972: BEGIN
1973: -- Initialize message list if p_init_msg_list is set to TRUE.
1974: IF FND_API.to_Boolean( p_init_msg_list )
1975: THEN
1976: FND_MSG_PUB.initialize;
1977: END IF;
1978:
1979: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1980:

Line 2047: FND_MSG_PUB.Count_And_Get

2043:
2044: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2045:
2046: -- Standard call to get message count and if count is 1, get message info.
2047: FND_MSG_PUB.Count_And_Get
2048: (p_count => x_msg_count,
2049: p_data => x_msg_data);
2050:
2051: END Validate_risk_Rec;

Line 2100: FND_MSG_PUB.Count_And_Get

2096:
2097: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2098:
2099: -- Standard call to get message count and if count is 1, get message info.
2100: FND_MSG_PUB.Count_And_Get
2101: (p_count => x_msg_count,
2102: p_data => x_msg_data);
2103:
2104: EXCEPTION

Line 2109: FND_MSG_PUB.Count_And_Get (

2105: WHEN FND_API.G_EXC_ERROR THEN
2106:
2107: x_return_status := G_RET_STS_ERROR;
2108: -- Standard call to get message count and if count=1, get the message
2109: FND_MSG_PUB.Count_And_Get (
2110: p_encoded => G_FALSE,
2111: p_count => x_msg_count,
2112: p_data => x_msg_data);
2113:

Line 2118: FND_MSG_PUB.Count_And_Get (

2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115:
2116: x_return_status := G_RET_STS_UNEXP_ERROR;
2117: -- Standard call to get message count and if count=1, get the message
2118: FND_MSG_PUB.Count_And_Get (
2119: p_encoded => G_FALSE,
2120: p_count => x_msg_count,
2121: p_data => x_msg_data);
2122:

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

2122:
2123: WHEN OTHERS THEN
2124:
2125: x_return_status := G_RET_STS_UNEXP_ERROR;
2126: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2127: THEN
2128: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2129: END IF;
2130: -- Standard call to get message count and if count=1, get the message

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

2124:
2125: x_return_status := G_RET_STS_UNEXP_ERROR;
2126: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2127: THEN
2128: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2129: END IF;
2130: -- Standard call to get message count and if count=1, get the message
2131: FND_MSG_PUB.Count_And_Get (
2132: p_encoded => G_FALSE,

Line 2131: FND_MSG_PUB.Count_And_Get (

2127: THEN
2128: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2129: END IF;
2130: -- Standard call to get message count and if count=1, get the message
2131: FND_MSG_PUB.Count_And_Get (
2132: p_encoded => G_FALSE,
2133: p_count => x_msg_count,
2134: p_data => x_msg_data);
2135:

Line 2202: FND_MSG_PUB.Count_And_Get

2198:
2199: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2200:
2201: -- Standard call to get message count and if count is 1, get message info.
2202: FND_MSG_PUB.Count_And_Get
2203: (p_count => x_msg_count,
2204: p_data => x_msg_data);
2205:
2206: EXCEPTION

Line 2212: FND_MSG_PUB.Count_And_Get (

2208: WHEN FND_API.G_EXC_ERROR THEN
2209:
2210: x_return_status := G_RET_STS_ERROR;
2211: -- Standard call to get message count and if count=1, get the message
2212: FND_MSG_PUB.Count_And_Get (
2213: p_encoded => G_FALSE,
2214: p_count => x_msg_count,
2215: p_data => x_msg_data);
2216:

Line 2221: FND_MSG_PUB.Count_And_Get (

2217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2218:
2219: x_return_status := G_RET_STS_UNEXP_ERROR;
2220: -- Standard call to get message count and if count=1, get the message
2221: FND_MSG_PUB.Count_And_Get (
2222: p_encoded => G_FALSE,
2223: p_count => x_msg_count,
2224: p_data => x_msg_data);
2225:

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

2225:
2226: WHEN OTHERS THEN
2227:
2228: x_return_status := G_RET_STS_UNEXP_ERROR;
2229: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2230: THEN
2231: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2232: END IF;
2233: -- Standard call to get message count and if count=1, get the message

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

2227:
2228: x_return_status := G_RET_STS_UNEXP_ERROR;
2229: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2230: THEN
2231: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2232: END IF;
2233: -- Standard call to get message count and if count=1, get the message
2234: FND_MSG_PUB.Count_And_Get (
2235: p_encoded => G_FALSE,

Line 2234: FND_MSG_PUB.Count_And_Get (

2230: THEN
2231: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2232: END IF;
2233: -- Standard call to get message count and if count=1, get the message
2234: FND_MSG_PUB.Count_And_Get (
2235: p_encoded => G_FALSE,
2236: p_count => x_msg_count,
2237: p_data => x_msg_data);
2238:

Line 2294: FND_MSG_PUB.Count_And_Get

2290:
2291: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2292:
2293: -- Standard call to get message count and if count is 1, get message info.
2294: FND_MSG_PUB.Count_And_Get
2295: (p_count => x_msg_count,
2296: p_data => x_msg_data);
2297:
2298: EXCEPTION

Line 2304: FND_MSG_PUB.Count_And_Get (

2300: WHEN FND_API.G_EXC_ERROR THEN
2301:
2302: x_return_status := G_RET_STS_ERROR;
2303: -- Standard call to get message count and if count=1, get the message
2304: FND_MSG_PUB.Count_And_Get (
2305: p_encoded => G_FALSE,
2306: p_count => x_msg_count,
2307: p_data => x_msg_data);
2308:

Line 2313: FND_MSG_PUB.Count_And_Get (

2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2310:
2311: x_return_status := G_RET_STS_UNEXP_ERROR;
2312: -- Standard call to get message count and if count=1, get the message
2313: FND_MSG_PUB.Count_And_Get (
2314: p_encoded => G_FALSE,
2315: p_count => x_msg_count,
2316: p_data => x_msg_data);
2317:

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

2317:
2318: WHEN OTHERS THEN
2319:
2320: x_return_status := G_RET_STS_UNEXP_ERROR;
2321: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2322: THEN
2323: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2324: END IF;
2325: -- Standard call to get message count and if count=1, get the message

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

2319:
2320: x_return_status := G_RET_STS_UNEXP_ERROR;
2321: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2322: THEN
2323: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2324: END IF;
2325: -- Standard call to get message count and if count=1, get the message
2326: FND_MSG_PUB.Count_And_Get (
2327: p_encoded => G_FALSE,

Line 2326: FND_MSG_PUB.Count_And_Get (

2322: THEN
2323: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2324: END IF;
2325: -- Standard call to get message count and if count=1, get the message
2326: FND_MSG_PUB.Count_And_Get (
2327: p_encoded => G_FALSE,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data);
2330:

Line 2380: FND_MSG_PUB.Count_And_Get

2376:
2377: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2378:
2379: -- Standard call to get message count and if count is 1, get message info.
2380: FND_MSG_PUB.Count_And_Get
2381: (p_count => x_msg_count,
2382: p_data => x_msg_data);
2383:
2384: EXCEPTION

Line 2390: FND_MSG_PUB.Count_And_Get (

2386: WHEN FND_API.G_EXC_ERROR THEN
2387:
2388: x_return_status := G_RET_STS_ERROR;
2389: -- Standard call to get message count and if count=1, get the message
2390: FND_MSG_PUB.Count_And_Get (
2391: p_encoded => G_FALSE,
2392: p_count => x_msg_count,
2393: p_data => x_msg_data);
2394:

Line 2399: FND_MSG_PUB.Count_And_Get (

2395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2396:
2397: x_return_status := G_RET_STS_UNEXP_ERROR;
2398: -- Standard call to get message count and if count=1, get the message
2399: FND_MSG_PUB.Count_And_Get (
2400: p_encoded => G_FALSE,
2401: p_count => x_msg_count,
2402: p_data => x_msg_data);
2403:

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

2403:
2404: WHEN OTHERS THEN
2405:
2406: x_return_status := G_RET_STS_UNEXP_ERROR;
2407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2408: THEN
2409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2410: END IF;
2411: -- Standard call to get message count and if count=1, get the message

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

2405:
2406: x_return_status := G_RET_STS_UNEXP_ERROR;
2407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2408: THEN
2409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2410: END IF;
2411: -- Standard call to get message count and if count=1, get the message
2412: FND_MSG_PUB.Count_And_Get (
2413: p_encoded => G_FALSE,

Line 2412: FND_MSG_PUB.Count_And_Get (

2408: THEN
2409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2410: END IF;
2411: -- Standard call to get message count and if count=1, get the message
2412: FND_MSG_PUB.Count_And_Get (
2413: p_encoded => G_FALSE,
2414: p_count => x_msg_count,
2415: p_data => x_msg_data);
2416:

Line 2456: FND_MSG_PUB.initialize;

2452: BEGIN
2453: x_return_status := FND_API.G_RET_STS_SUCCESS;
2454:
2455: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2456: FND_MSG_PUB.initialize;
2457: END IF;
2458:
2459: IF G_USER_ID IS NULL THEN
2460: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: ROLLBACK;
2498: x_return_status := FND_API.G_RET_STS_ERROR;
2499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: ROLLBACK;
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: ROLLBACK;
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2505:
2506: WHEN OTHERS THEN
2507: ROLLBACK;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2505:
2506: WHEN OTHERS THEN
2507: ROLLBACK;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2510: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2513: END Approve_Risk;

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

2506: WHEN OTHERS THEN
2507: ROLLBACK;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2510: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2513: END Approve_Risk;
2514:

Line 2512: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2510: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2513: END Approve_Risk;
2514:
2515:
2516: -- ----------------------------------------------------------------------