eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_AUDIT_PROCEDURES_PVT dependencies on FND_MSG_PUB

Line 218: FND_MSG_PUB.Count_And_Get(

214:
215: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
216:
217: -- Standard call to get message count and if count is 1, get message info.
218: FND_MSG_PUB.Count_And_Get(
219: p_count => x_msg_count,
220: p_data => x_msg_data);
221:
222: EXCEPTION

Line 228: FND_MSG_PUB.Count_And_Get (

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

Line 237: FND_MSG_PUB.Count_And_Get (

233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234:
235: x_return_status := G_RET_STS_UNEXP_ERROR;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data);
241:

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

241:
242: WHEN OTHERS THEN
243:
244: x_return_status := G_RET_STS_UNEXP_ERROR;
245: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: -- Standard call to get message count and if count=1, get the message

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

243:
244: x_return_status := G_RET_STS_UNEXP_ERROR;
245: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => G_FALSE,

Line 250: FND_MSG_PUB.Count_And_Get (

246: THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data);
254:

Line 302: FND_MSG_PUB.initialize;

298: BEGIN
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean( p_init_msg_list )
301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
306:

Line 480: FND_MSG_PUB.Count_And_Get

476:
477: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get
481: (p_count => x_msg_count,
482: p_data => x_msg_data);
483:
484: EXCEPTION

Line 489: FND_MSG_PUB.Count_And_Get (

485:
486: WHEN FND_API.G_EXC_ERROR THEN
487: x_return_status := G_RET_STS_ERROR;
488: -- Standard call to get message count and if count=1, get the message
489: FND_MSG_PUB.Count_And_Get (
490: p_encoded => G_FALSE,
491: p_count => x_msg_count,
492: p_data => x_msg_data
493: );

Line 498: FND_MSG_PUB.Count_And_Get (

494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: x_return_status := G_RET_STS_UNEXP_ERROR;
497: -- Standard call to get message count and if count=1, get the message
498: FND_MSG_PUB.Count_And_Get (
499: p_encoded => G_FALSE,
500: p_count => x_msg_count,
501: p_data => x_msg_data);
502:

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

502:
503: WHEN OTHERS THEN
504:
505: x_return_status := G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
509: END IF;
510: -- Standard call to get message count and if count=1, get the message

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

504:
505: x_return_status := G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
509: END IF;
510: -- Standard call to get message count and if count=1, get the message
511: FND_MSG_PUB.Count_And_Get (
512: p_encoded => G_FALSE,

Line 511: FND_MSG_PUB.Count_And_Get (

507: THEN
508: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
509: END IF;
510: -- Standard call to get message count and if count=1, get the message
511: FND_MSG_PUB.Count_And_Get (
512: p_encoded => G_FALSE,
513: p_count => x_msg_count,
514: p_data => x_msg_data);
515:

Line 590: FND_MSG_PUB.initialize;

586:
587: -- Initialize message list if p_init_msg_list is set to TRUE.
588: IF FND_API.to_Boolean( p_init_msg_list )
589: THEN
590: FND_MSG_PUB.initialize;
591: END IF;
592:
593: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
594:

Line 729: FND_MSG_PUB.Count_And_Get

725:
726: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
727:
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count,
731: p_data => x_msg_data);
732:
733: EXCEPTION

Line 742: FND_MSG_PUB.Count_And_Get (

738: WHEN FND_API.G_EXC_ERROR THEN
739: ROLLBACK TO CREATE_AP_PVT;
740: x_return_status := G_RET_STS_ERROR;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (
743: p_encoded => G_FALSE,
744: p_count => x_msg_count,
745: p_data => x_msg_data);
746:

Line 751: FND_MSG_PUB.Count_And_Get (

747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: ROLLBACK TO CREATE_AP_PVT;
749: x_return_status := G_RET_STS_UNEXP_ERROR;
750: -- Standard call to get message count and if count=1, get the message
751: FND_MSG_PUB.Count_And_Get (
752: p_encoded => G_FALSE,
753: p_count => x_msg_count,
754: p_data => x_msg_data);
755:

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

755:
756: WHEN OTHERS THEN
757: ROLLBACK TO CREATE_AP_PVT;
758: x_return_status := G_RET_STS_UNEXP_ERROR;
759: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
760: THEN
761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
762: END IF;
763: -- Standard call to get message count and if count=1, get the message

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

757: ROLLBACK TO CREATE_AP_PVT;
758: x_return_status := G_RET_STS_UNEXP_ERROR;
759: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
760: THEN
761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
762: END IF;
763: -- Standard call to get message count and if count=1, get the message
764: FND_MSG_PUB.Count_And_Get (
765: p_encoded => G_FALSE,

Line 764: FND_MSG_PUB.Count_And_Get (

760: THEN
761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
762: END IF;
763: -- Standard call to get message count and if count=1, get the message
764: FND_MSG_PUB.Count_And_Get (
765: p_encoded => G_FALSE,
766: p_count => x_msg_count,
767: p_data => x_msg_data);
768:

Line 830: FND_MSG_PUB.initialize;

826:
827: -- Initialize message list if p_init_msg_list is set to TRUE.
828: IF FND_API.to_Boolean( p_init_msg_list )
829: THEN
830: FND_MSG_PUB.initialize;
831: END IF;
832:
833: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
834:

Line 975: FND_MSG_PUB.Count_And_Get

971:
972: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
973:
974: -- Standard call to get message count and if count is 1, get message info.
975: FND_MSG_PUB.Count_And_Get
976: (p_count => x_msg_count,
977: p_data => x_msg_data);
978:
979:

Line 990: FND_MSG_PUB.Count_And_Get (

986: WHEN FND_API.G_EXC_ERROR THEN
987: ROLLBACK TO UPDATE_AP_PVT;
988: x_return_status := G_RET_STS_ERROR;
989: -- Standard call to get message count and if count=1, get the message
990: FND_MSG_PUB.Count_And_Get (
991: p_encoded => G_FALSE,
992: p_count => x_msg_count,
993: p_data => x_msg_data);
994:

Line 999: FND_MSG_PUB.Count_And_Get (

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

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

1003:
1004: WHEN OTHERS THEN
1005: ROLLBACK TO UPDATE_AP_PVT;
1006: x_return_status := G_RET_STS_UNEXP_ERROR;
1007: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1008: THEN
1009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1010: END IF;
1011: -- Standard call to get message count and if count=1, get the message

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

1005: ROLLBACK TO UPDATE_AP_PVT;
1006: x_return_status := G_RET_STS_UNEXP_ERROR;
1007: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1008: THEN
1009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1010: END IF;
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => G_FALSE,

Line 1012: FND_MSG_PUB.Count_And_Get (

1008: THEN
1009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1010: END IF;
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data);
1016:

Line 1060: FND_MSG_PUB.initialize;

1056:
1057: -- Initialize message list if p_init_msg_list is set to TRUE.
1058: IF FND_API.to_Boolean( p_init_msg_list )
1059: THEN
1060: FND_MSG_PUB.initialize;
1061: END IF;
1062:
1063: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1064:

Line 1086: FND_MSG_PUB.Count_And_Get

1082:
1083: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1084:
1085: -- Standard call to get message count and if count is 1, get message info.
1086: FND_MSG_PUB.Count_And_Get
1087: (p_count => x_msg_count,
1088: p_data => x_msg_data);
1089:
1090: EXCEPTION

Line 1100: FND_MSG_PUB.Count_And_Get (

1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO DELETE_AP_PVT;
1098: x_return_status := G_RET_STS_ERROR;
1099: -- Standard call to get message count and if count=1, get the message
1100: FND_MSG_PUB.Count_And_Get (
1101: p_encoded => G_FALSE,
1102: p_count => x_msg_count,
1103: p_data => x_msg_data);
1104:

Line 1109: FND_MSG_PUB.Count_And_Get (

1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: ROLLBACK TO DELETE_AP_PVT;
1107: x_return_status := G_RET_STS_UNEXP_ERROR;
1108: -- Standard call to get message count and if count=1, get the message
1109: FND_MSG_PUB.Count_And_Get (
1110: p_encoded => G_FALSE,
1111: p_count => x_msg_count,
1112: p_data => x_msg_data);
1113:

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

1113:
1114: WHEN OTHERS THEN
1115: ROLLBACK TO DELETE_AP_PVT;
1116: x_return_status := G_RET_STS_UNEXP_ERROR;
1117: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1118: THEN
1119: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1120: END IF;
1121: -- Standard call to get message count and if count=1, get the message

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

1115: ROLLBACK TO DELETE_AP_PVT;
1116: x_return_status := G_RET_STS_UNEXP_ERROR;
1117: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1118: THEN
1119: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1120: END IF;
1121: -- Standard call to get message count and if count=1, get the message
1122: FND_MSG_PUB.Count_And_Get (
1123: p_encoded => G_FALSE,

Line 1122: FND_MSG_PUB.Count_And_Get (

1118: THEN
1119: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1120: END IF;
1121: -- Standard call to get message count and if count=1, get the message
1122: FND_MSG_PUB.Count_And_Get (
1123: p_encoded => G_FALSE,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data);
1126:

Line 1187: FND_MSG_PUB.initialize;

1183:
1184: -- Initialize message list if p_init_msg_list is set to TRUE.
1185: IF FND_API.to_Boolean( p_init_msg_list )
1186: THEN
1187: FND_MSG_PUB.initialize;
1188: END IF;
1189:
1190: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1191:

Line 1324: FND_MSG_PUB.Count_And_Get

1320:
1321: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1322:
1323: -- Standard call to get message count and if count is 1, get message info.
1324: FND_MSG_PUB.Count_And_Get
1325: (p_count => x_msg_count,
1326: p_data => x_msg_data);
1327:
1328: EXCEPTION

Line 1338: FND_MSG_PUB.Count_And_Get (

1334: WHEN FND_API.G_EXC_ERROR THEN
1335: ROLLBACK TO REVISE_AP_PVT;
1336: x_return_status := G_RET_STS_ERROR;
1337: -- Standard call to get message count and if count=1, get the message
1338: FND_MSG_PUB.Count_And_Get (
1339: p_encoded => G_FALSE,
1340: p_count => x_msg_count,
1341: p_data => x_msg_data);
1342:

Line 1347: FND_MSG_PUB.Count_And_Get (

1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: ROLLBACK TO REVISE_AP_PVT;
1345: x_return_status := G_RET_STS_UNEXP_ERROR;
1346: -- Standard call to get message count and if count=1, get the message
1347: FND_MSG_PUB.Count_And_Get (
1348: p_encoded => G_FALSE,
1349: p_count => x_msg_count,
1350: p_data => x_msg_data);
1351:

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

1351:
1352: WHEN OTHERS THEN
1353: ROLLBACK TO REVISE_AP_PVT;
1354: x_return_status := G_RET_STS_UNEXP_ERROR;
1355: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1356: THEN
1357: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1358: END IF;
1359: -- Standard call to get message count and if count=1, get the message

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

1353: ROLLBACK TO REVISE_AP_PVT;
1354: x_return_status := G_RET_STS_UNEXP_ERROR;
1355: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1356: THEN
1357: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1358: END IF;
1359: -- Standard call to get message count and if count=1, get the message
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => G_FALSE,

Line 1360: FND_MSG_PUB.Count_And_Get (

1356: THEN
1357: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1358: END IF;
1359: -- Standard call to get message count and if count=1, get the message
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => G_FALSE,
1362: p_count => x_msg_count,
1363: p_data => x_msg_data);
1364:

Line 1887: FND_MSG_PUB.initialize;

1883:
1884: -- Initialize message list if p_init_msg_list is set to TRUE.
1885: IF FND_API.to_Boolean( p_init_msg_list )
1886: THEN
1887: FND_MSG_PUB.initialize;
1888: END IF;
1889:
1890: l_audit_procedure_rec := p_audit_procedure_rec;
1891: -- 07.21.2003 tsho, only update and revise need complete_AP_rec

Line 1935: FND_MSG_PUB.Count_And_Get

1931:
1932: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1933:
1934: -- Standard call to get message count and if count is 1, get message info.
1935: FND_MSG_PUB.Count_And_Get
1936: (p_count => x_msg_count,
1937: p_data => x_msg_data);
1938:
1939: EXCEPTION

Line 1949: FND_MSG_PUB.Count_And_Get (

1945: WHEN FND_API.G_EXC_ERROR THEN
1946: ROLLBACK TO VALIDATE_AP_;
1947: x_return_status := G_RET_STS_ERROR;
1948: -- Standard call to get message count and if count=1, get the message
1949: FND_MSG_PUB.Count_And_Get (
1950: p_encoded => G_FALSE,
1951: p_count => x_msg_count,
1952: p_data => x_msg_data);
1953:

Line 1958: FND_MSG_PUB.Count_And_Get (

1954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1955: ROLLBACK TO VALIDATE_AP_;
1956: x_return_status := G_RET_STS_UNEXP_ERROR;
1957: -- Standard call to get message count and if count=1, get the message
1958: FND_MSG_PUB.Count_And_Get (
1959: p_encoded => G_FALSE,
1960: p_count => x_msg_count,
1961: p_data => x_msg_data);
1962:

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

1962:
1963: WHEN OTHERS THEN
1964: ROLLBACK TO VALIDATE_AP_;
1965: x_return_status := G_RET_STS_UNEXP_ERROR;
1966: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1967: THEN
1968: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1969: END IF;
1970: -- Standard call to get message count and if count=1, get the message

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

1964: ROLLBACK TO VALIDATE_AP_;
1965: x_return_status := G_RET_STS_UNEXP_ERROR;
1966: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1967: THEN
1968: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1969: END IF;
1970: -- Standard call to get message count and if count=1, get the message
1971: FND_MSG_PUB.Count_And_Get (
1972: p_encoded => G_FALSE,

Line 1971: FND_MSG_PUB.Count_And_Get (

1967: THEN
1968: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1969: END IF;
1970: -- Standard call to get message count and if count=1, get the message
1971: FND_MSG_PUB.Count_And_Get (
1972: p_encoded => G_FALSE,
1973: p_count => x_msg_count,
1974: p_data => x_msg_data);
1975:

Line 2007: FND_MSG_PUB.initialize;

2003: BEGIN
2004: -- Initialize message list if p_init_msg_list is set to TRUE.
2005: IF FND_API.to_Boolean( p_init_msg_list )
2006: THEN
2007: FND_MSG_PUB.initialize;
2008: END IF;
2009:
2010: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2011:

Line 2078: FND_MSG_PUB.Count_And_Get

2074:
2075: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2076:
2077: -- Standard call to get message count and if count is 1, get message info.
2078: FND_MSG_PUB.Count_And_Get
2079: (p_count => x_msg_count,
2080: p_data => x_msg_data);
2081:
2082: END Validate_AP_rec;

Line 2131: FND_MSG_PUB.Count_And_Get

2127:
2128: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2129:
2130: -- Standard call to get message count and if count is 1, get message info.
2131: FND_MSG_PUB.Count_And_Get
2132: (p_count => x_msg_count,
2133: p_data => x_msg_data);
2134:
2135: EXCEPTION

Line 2140: FND_MSG_PUB.Count_And_Get (

2136: WHEN FND_API.G_EXC_ERROR THEN
2137:
2138: x_return_status := G_RET_STS_ERROR;
2139: -- Standard call to get message count and if count=1, get the message
2140: FND_MSG_PUB.Count_And_Get (
2141: p_encoded => G_FALSE,
2142: p_count => x_msg_count,
2143: p_data => x_msg_data);
2144:

Line 2149: FND_MSG_PUB.Count_And_Get (

2145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2146:
2147: x_return_status := G_RET_STS_UNEXP_ERROR;
2148: -- Standard call to get message count and if count=1, get the message
2149: FND_MSG_PUB.Count_And_Get (
2150: p_encoded => G_FALSE,
2151: p_count => x_msg_count,
2152: p_data => x_msg_data);
2153:

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

2153:
2154: WHEN OTHERS THEN
2155:
2156: x_return_status := G_RET_STS_UNEXP_ERROR;
2157: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2158: THEN
2159: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2160: END IF;
2161: -- Standard call to get message count and if count=1, get the message

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

2155:
2156: x_return_status := G_RET_STS_UNEXP_ERROR;
2157: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2158: THEN
2159: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2160: END IF;
2161: -- Standard call to get message count and if count=1, get the message
2162: FND_MSG_PUB.Count_And_Get (
2163: p_encoded => G_FALSE,

Line 2162: FND_MSG_PUB.Count_And_Get (

2158: THEN
2159: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2160: END IF;
2161: -- Standard call to get message count and if count=1, get the message
2162: FND_MSG_PUB.Count_And_Get (
2163: p_encoded => G_FALSE,
2164: p_count => x_msg_count,
2165: p_data => x_msg_data);
2166:

Line 2233: FND_MSG_PUB.Count_And_Get

2229:
2230: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2231:
2232: -- Standard call to get message count and if count is 1, get message info.
2233: FND_MSG_PUB.Count_And_Get
2234: (p_count => x_msg_count,
2235: p_data => x_msg_data);
2236:
2237: EXCEPTION

Line 2243: FND_MSG_PUB.Count_And_Get (

2239: WHEN FND_API.G_EXC_ERROR THEN
2240:
2241: x_return_status := G_RET_STS_ERROR;
2242: -- Standard call to get message count and if count=1, get the message
2243: FND_MSG_PUB.Count_And_Get (
2244: p_encoded => G_FALSE,
2245: p_count => x_msg_count,
2246: p_data => x_msg_data);
2247:

Line 2252: FND_MSG_PUB.Count_And_Get (

2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249:
2250: x_return_status := G_RET_STS_UNEXP_ERROR;
2251: -- Standard call to get message count and if count=1, get the message
2252: FND_MSG_PUB.Count_And_Get (
2253: p_encoded => G_FALSE,
2254: p_count => x_msg_count,
2255: p_data => x_msg_data);
2256:

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

2256:
2257: WHEN OTHERS THEN
2258:
2259: x_return_status := G_RET_STS_UNEXP_ERROR;
2260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2261: THEN
2262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2263: END IF;
2264: -- Standard call to get message count and if count=1, get the message

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

2258:
2259: x_return_status := G_RET_STS_UNEXP_ERROR;
2260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2261: THEN
2262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2263: END IF;
2264: -- Standard call to get message count and if count=1, get the message
2265: FND_MSG_PUB.Count_And_Get (
2266: p_encoded => G_FALSE,

Line 2265: FND_MSG_PUB.Count_And_Get (

2261: THEN
2262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2263: END IF;
2264: -- Standard call to get message count and if count=1, get the message
2265: FND_MSG_PUB.Count_And_Get (
2266: p_encoded => G_FALSE,
2267: p_count => x_msg_count,
2268: p_data => x_msg_data);
2269:

Line 2325: FND_MSG_PUB.Count_And_Get

2321:
2322: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2323:
2324: -- Standard call to get message count and if count is 1, get message info.
2325: FND_MSG_PUB.Count_And_Get
2326: (p_count => x_msg_count,
2327: p_data => x_msg_data);
2328:
2329: EXCEPTION

Line 2335: FND_MSG_PUB.Count_And_Get (

2331: WHEN FND_API.G_EXC_ERROR THEN
2332:
2333: x_return_status := G_RET_STS_ERROR;
2334: -- Standard call to get message count and if count=1, get the message
2335: FND_MSG_PUB.Count_And_Get (
2336: p_encoded => G_FALSE,
2337: p_count => x_msg_count,
2338: p_data => x_msg_data);
2339:

Line 2344: FND_MSG_PUB.Count_And_Get (

2340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2341:
2342: x_return_status := G_RET_STS_UNEXP_ERROR;
2343: -- Standard call to get message count and if count=1, get the message
2344: FND_MSG_PUB.Count_And_Get (
2345: p_encoded => G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data);
2348:

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

2348:
2349: WHEN OTHERS THEN
2350:
2351: x_return_status := G_RET_STS_UNEXP_ERROR;
2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2353: THEN
2354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2355: END IF;
2356: -- Standard call to get message count and if count=1, get the message

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

2350:
2351: x_return_status := G_RET_STS_UNEXP_ERROR;
2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2353: THEN
2354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2355: END IF;
2356: -- Standard call to get message count and if count=1, get the message
2357: FND_MSG_PUB.Count_And_Get (
2358: p_encoded => G_FALSE,

Line 2357: FND_MSG_PUB.Count_And_Get (

2353: THEN
2354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2355: END IF;
2356: -- Standard call to get message count and if count=1, get the message
2357: FND_MSG_PUB.Count_And_Get (
2358: p_encoded => G_FALSE,
2359: p_count => x_msg_count,
2360: p_data => x_msg_data);
2361:

Line 2411: FND_MSG_PUB.Count_And_Get

2407:
2408: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2409:
2410: -- Standard call to get message count and if count is 1, get message info.
2411: FND_MSG_PUB.Count_And_Get
2412: (p_count => x_msg_count,
2413: p_data => x_msg_data);
2414:
2415: EXCEPTION

Line 2421: FND_MSG_PUB.Count_And_Get (

2417: WHEN FND_API.G_EXC_ERROR THEN
2418:
2419: x_return_status := G_RET_STS_ERROR;
2420: -- Standard call to get message count and if count=1, get the message
2421: FND_MSG_PUB.Count_And_Get (
2422: p_encoded => G_FALSE,
2423: p_count => x_msg_count,
2424: p_data => x_msg_data);
2425:

Line 2430: FND_MSG_PUB.Count_And_Get (

2426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2427:
2428: x_return_status := G_RET_STS_UNEXP_ERROR;
2429: -- Standard call to get message count and if count=1, get the message
2430: FND_MSG_PUB.Count_And_Get (
2431: p_encoded => G_FALSE,
2432: p_count => x_msg_count,
2433: p_data => x_msg_data);
2434:

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

2434:
2435: WHEN OTHERS THEN
2436:
2437: x_return_status := G_RET_STS_UNEXP_ERROR;
2438: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2439: THEN
2440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2441: END IF;
2442: -- Standard call to get message count and if count=1, get the message

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

2436:
2437: x_return_status := G_RET_STS_UNEXP_ERROR;
2438: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2439: THEN
2440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2441: END IF;
2442: -- Standard call to get message count and if count=1, get the message
2443: FND_MSG_PUB.Count_And_Get (
2444: p_encoded => G_FALSE,

Line 2443: FND_MSG_PUB.Count_And_Get (

2439: THEN
2440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2441: END IF;
2442: -- Standard call to get message count and if count=1, get the message
2443: FND_MSG_PUB.Count_And_Get (
2444: p_encoded => G_FALSE,
2445: p_count => x_msg_count,
2446: p_data => x_msg_data);
2447:

Line 2533: FND_MSG_PUB.initialize;

2529: END IF;
2530:
2531: -- Initialize message list if p_init_msg_list is set to TRUE.
2532: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2533: FND_MSG_PUB.initialize;
2534: END IF;
2535: -- Initialize API return status to success
2536: x_return_status := FND_API.G_RET_STS_SUCCESS;
2537:

Line 2546: FND_MSG_PUB.Add;

2542: -- 2. Write a message to the message list.
2543: -- 3. Return to the caller.
2544: x_return_status := FND_API.G_RET_STS_ERROR ;
2545: FND_MESSAGE.SET_NAME ('AMW', 'AMW_MISS_TO_AP_ID');
2546: FND_MSG_PUB.Add;
2547: RETURN;
2548: END IF;
2549: FOR steprec IN steps_b
2550: LOOP

Line 2593: FND_MSG_PUB.Count_And_Get

2589: IF FND_API.To_Boolean( p_commit ) THEN
2590: COMMIT WORK;
2591: END IF;
2592: -- Standard call to get message count and if count is 1, get message info.
2593: FND_MSG_PUB.Count_And_Get
2594: ( p_count => x_msg_count ,
2595: p_data => x_msg_data
2596: );
2597: EXCEPTION

Line 2601: FND_MSG_PUB.Count_And_Get

2597: EXCEPTION
2598: WHEN FND_API.G_EXC_ERROR THEN
2599: ROLLBACK TO COPY_AUDIT_STEPS_SAVEPT;
2600: x_return_status := FND_API.G_RET_STS_ERROR ;
2601: FND_MSG_PUB.Count_And_Get
2602: ( p_count => x_msg_count ,
2603: p_data => x_msg_data
2604: );
2605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2608: FND_MSG_PUB.Count_And_Get

2604: );
2605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2606: ROLLBACK TO COPY_AUDIT_STEPS_SAVEPT;
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2608: FND_MSG_PUB.Count_And_Get
2609: ( p_count => x_msg_count ,
2610: p_data => x_msg_data
2611: );
2612: WHEN OTHERS THEN

Line 2615: IF FND_MSG_PUB.Check_Msg_Level

2611: );
2612: WHEN OTHERS THEN
2613: ROLLBACK TO COPY_AUDIT_STEPS_SAVEPT;
2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2615: IF FND_MSG_PUB.Check_Msg_Level
2616: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2617: THEN
2618: FND_MSG_PUB.Add_Exc_Msg
2619: ( G_PKG_NAME ,

Line 2616: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2612: WHEN OTHERS THEN
2613: ROLLBACK TO COPY_AUDIT_STEPS_SAVEPT;
2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2615: IF FND_MSG_PUB.Check_Msg_Level
2616: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2617: THEN
2618: FND_MSG_PUB.Add_Exc_Msg
2619: ( G_PKG_NAME ,
2620: l_api_name

Line 2618: FND_MSG_PUB.Add_Exc_Msg

2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2615: IF FND_MSG_PUB.Check_Msg_Level
2616: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2617: THEN
2618: FND_MSG_PUB.Add_Exc_Msg
2619: ( G_PKG_NAME ,
2620: l_api_name
2621: );
2622: END IF;

Line 2623: FND_MSG_PUB.Count_And_Get

2619: ( G_PKG_NAME ,
2620: l_api_name
2621: );
2622: END IF;
2623: FND_MSG_PUB.Count_And_Get
2624: ( p_count => x_msg_count ,
2625: p_data => x_msg_data
2626: );
2627: END copy_audit_steps;

Line 2668: FND_MSG_PUB.initialize;

2664: END IF;
2665:
2666: -- Initialize message list if p_init_msg_list is set to TRUE.
2667: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2668: FND_MSG_PUB.initialize;
2669: END IF;
2670: -- Initialize API return status to success
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672:

Line 2681: FND_MSG_PUB.Add;

2677: -- 2. Write a message to the message list.
2678: -- 3. Return to the caller.
2679: x_return_status := FND_API.G_RET_STS_ERROR ;
2680: FND_MESSAGE.SET_NAME ('AMW', 'AMW_MISS_TO_AP_ID');
2681: FND_MSG_PUB.Add;
2682: RETURN;
2683: END IF;
2684:
2685: --FOR taskrec IN tasks

Line 2753: FND_MSG_PUB.Count_And_Get

2749: IF FND_API.To_Boolean( p_commit ) THEN
2750: COMMIT WORK;
2751: END IF;
2752: -- Standard call to get message count and if count is 1, get message info.
2753: FND_MSG_PUB.Count_And_Get
2754: ( p_count => x_msg_count ,
2755: p_data => x_msg_data
2756: );
2757: EXCEPTION

Line 2761: FND_MSG_PUB.Count_And_Get

2757: EXCEPTION
2758: WHEN FND_API.G_EXC_ERROR THEN
2759: ROLLBACK TO COPY_TASKS_SAVEPT;
2760: x_return_status := FND_API.G_RET_STS_ERROR ;
2761: FND_MSG_PUB.Count_And_Get
2762: ( p_count => x_msg_count ,
2763: p_data => x_msg_data
2764: );
2765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2768: FND_MSG_PUB.Count_And_Get

2764: );
2765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2766: ROLLBACK TO COPY_TASKS_SAVEPT;
2767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2768: FND_MSG_PUB.Count_And_Get
2769: ( p_count => x_msg_count ,
2770: p_data => x_msg_data
2771: );
2772: WHEN OTHERS THEN

Line 2775: IF FND_MSG_PUB.Check_Msg_Level

2771: );
2772: WHEN OTHERS THEN
2773: ROLLBACK TO COPY_TASKS_SAVEPT;
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2775: IF FND_MSG_PUB.Check_Msg_Level
2776: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2777: THEN
2778: FND_MSG_PUB.Add_Exc_Msg
2779: ( G_PKG_NAME ,

Line 2776: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2772: WHEN OTHERS THEN
2773: ROLLBACK TO COPY_TASKS_SAVEPT;
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2775: IF FND_MSG_PUB.Check_Msg_Level
2776: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2777: THEN
2778: FND_MSG_PUB.Add_Exc_Msg
2779: ( G_PKG_NAME ,
2780: l_api_name

Line 2778: FND_MSG_PUB.Add_Exc_Msg

2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2775: IF FND_MSG_PUB.Check_Msg_Level
2776: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2777: THEN
2778: FND_MSG_PUB.Add_Exc_Msg
2779: ( G_PKG_NAME ,
2780: l_api_name
2781: );
2782: END IF;

Line 2783: FND_MSG_PUB.Count_And_Get

2779: ( G_PKG_NAME ,
2780: l_api_name
2781: );
2782: END IF;
2783: FND_MSG_PUB.Count_And_Get
2784: ( p_count => x_msg_count ,
2785: p_data => x_msg_data
2786: );
2787: END copy_tasks;

Line 2828: FND_MSG_PUB.initialize;

2824: END IF;
2825:
2826: -- Initialize message list if p_init_msg_list is set to TRUE.
2827: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2828: FND_MSG_PUB.initialize;
2829: END IF;
2830: -- Initialize API return status to success
2831: x_return_status := FND_API.G_RET_STS_SUCCESS;
2832:

Line 2841: FND_MSG_PUB.Add;

2837: -- 2. Write a message to the message list.
2838: -- 3. Return to the caller.
2839: x_return_status := FND_API.G_RET_STS_ERROR ;
2840: FND_MESSAGE.SET_NAME ('AMW', 'AMW_MISS_TO_AP_ID');
2841: FND_MSG_PUB.Add;
2842: RETURN;
2843: END IF;
2844:
2845: --FOR ctrlrec IN controls_assoc

Line 2921: FND_MSG_PUB.Count_And_Get

2917: IF FND_API.To_Boolean( p_commit ) THEN
2918: COMMIT WORK;
2919: END IF;
2920: -- Standard call to get message count and if count is 1, get message info.
2921: FND_MSG_PUB.Count_And_Get
2922: ( p_count => x_msg_count ,
2923: p_data => x_msg_data
2924: );
2925: EXCEPTION

Line 2929: FND_MSG_PUB.Count_And_Get

2925: EXCEPTION
2926: WHEN FND_API.G_EXC_ERROR THEN
2927: ROLLBACK TO COPY_CONTROLS_SAVEPT;
2928: x_return_status := FND_API.G_RET_STS_ERROR ;
2929: FND_MSG_PUB.Count_And_Get
2930: ( p_count => x_msg_count ,
2931: p_data => x_msg_data
2932: );
2933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2936: FND_MSG_PUB.Count_And_Get

2932: );
2933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2934: ROLLBACK TO COPY_CONTROLS_SAVEPT;
2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2936: FND_MSG_PUB.Count_And_Get
2937: ( p_count => x_msg_count ,
2938: p_data => x_msg_data
2939: );
2940: WHEN OTHERS THEN

Line 2943: IF FND_MSG_PUB.Check_Msg_Level

2939: );
2940: WHEN OTHERS THEN
2941: ROLLBACK TO COPY_CONTROLS_SAVEPT;
2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2943: IF FND_MSG_PUB.Check_Msg_Level
2944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2945: THEN
2946: FND_MSG_PUB.Add_Exc_Msg
2947: ( G_PKG_NAME ,

Line 2944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2940: WHEN OTHERS THEN
2941: ROLLBACK TO COPY_CONTROLS_SAVEPT;
2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2943: IF FND_MSG_PUB.Check_Msg_Level
2944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2945: THEN
2946: FND_MSG_PUB.Add_Exc_Msg
2947: ( G_PKG_NAME ,
2948: l_api_name

Line 2946: FND_MSG_PUB.Add_Exc_Msg

2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2943: IF FND_MSG_PUB.Check_Msg_Level
2944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2945: THEN
2946: FND_MSG_PUB.Add_Exc_Msg
2947: ( G_PKG_NAME ,
2948: l_api_name
2949: );
2950: END IF;

Line 2951: FND_MSG_PUB.Count_And_Get

2947: ( G_PKG_NAME ,
2948: l_api_name
2949: );
2950: END IF;
2951: FND_MSG_PUB.Count_And_Get
2952: ( p_count => x_msg_count ,
2953: p_data => x_msg_data
2954: );
2955:

Line 3037: FND_MSG_PUB.initialize;

3033:
3034: -- Initialize message list if p_init_msg_list is set to TRUE.
3035: IF FND_API.to_Boolean( p_init_msg_list )
3036: THEN
3037: FND_MSG_PUB.initialize;
3038: END IF;
3039:
3040: -- added npanandi 11/08/2004
3041: x_return_status := fnd_api.g_ret_sts_success;

Line 3231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3227: exception
3228: WHEN OTHERS THEN
3229: ROLLBACK TO INSERT_AP_STEP_PVT;
3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3232: p_count => x_msg_count,
3233: p_data => x_msg_data);
3234:
3235: end insert_ap_step;

Line 3305: FND_MSG_PUB.initialize;

3301:
3302: -- Initialize message list if p_init_msg_list is set to TRUE.
3303: IF FND_API.to_Boolean( p_init_msg_list )
3304: THEN
3305: FND_MSG_PUB.initialize;
3306: END IF;
3307: x_return_status := fnd_api.g_ret_sts_success;
3308:
3309: fnd_file.put_line(fnd_file.LOG,'Inside insert_ap_control_assoc --> x_return_status: '||x_return_status);

Line 3445: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3441: exception
3442: WHEN OTHERS THEN
3443: ROLLBACK TO INSERT_AP_CONTROL_ASSOC_PVT;
3444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3445: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3446: p_count => x_msg_count,
3447: p_data => x_msg_data);
3448:
3449: end insert_ap_control_assoc;

Line 3494: FND_MSG_PUB.initialize;

3490:
3491: -- Initialize message list if p_init_msg_list is set to TRUE.
3492: IF FND_API.to_Boolean( p_init_msg_list )
3493: THEN
3494: FND_MSG_PUB.initialize;
3495: END IF;
3496: x_return_status := fnd_api.g_ret_sts_success;
3497:
3498: fnd_file.put_line(fnd_file.LOG,'Inside copy_ext_attr --> x_return_status: '||x_return_status);

Line 3549: FND_MSG_PUB.Count_And_Get (

3545:
3546: ROLLBACK TO COPY_EXT_ATTR;
3547: x_return_status := G_RET_STS_ERROR;
3548: -- Standard call to get message count and if count=1, get the message
3549: FND_MSG_PUB.Count_And_Get (
3550: p_encoded => G_FALSE,
3551: p_count => x_msg_count,
3552: p_data => x_msg_data);
3553:

Line 3559: FND_MSG_PUB.Count_And_Get (

3555:
3556: ROLLBACK TO COPY_EXT_ATTR;
3557: x_return_status := G_RET_STS_UNEXP_ERROR;
3558: -- Standard call to get message count and if count=1, get the message
3559: FND_MSG_PUB.Count_And_Get (
3560: p_encoded => G_FALSE,
3561: p_count => x_msg_count,
3562: p_data => x_msg_data);
3563:

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

3564: WHEN OTHERS THEN
3565:
3566: ROLLBACK TO COPY_EXT_ATTR;
3567: x_return_status := G_RET_STS_UNEXP_ERROR;
3568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3569: THEN
3570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3571: END IF;
3572: -- Standard call to get message count and if count=1, get the message

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

3566: ROLLBACK TO COPY_EXT_ATTR;
3567: x_return_status := G_RET_STS_UNEXP_ERROR;
3568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3569: THEN
3570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3571: END IF;
3572: -- Standard call to get message count and if count=1, get the message
3573: FND_MSG_PUB.Count_And_Get (
3574: p_encoded => G_FALSE,

Line 3573: FND_MSG_PUB.Count_And_Get (

3569: THEN
3570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3571: END IF;
3572: -- Standard call to get message count and if count=1, get the message
3573: FND_MSG_PUB.Count_And_Get (
3574: p_encoded => G_FALSE,
3575: p_count => x_msg_count,
3576: p_data => x_msg_data);
3577:

Line 3627: FND_MSG_PUB.initialize;

3623:
3624: -- Initialize message list if p_init_msg_list is set to TRUE.
3625: IF FND_API.to_Boolean( p_init_msg_list )
3626: THEN
3627: FND_MSG_PUB.initialize;
3628: END IF;
3629: x_return_status := fnd_api.g_ret_sts_success;
3630:
3631: OPEN c_revision_exists(p_audit_procedure_id);

Line 3780: FND_MSG_PUB.Count_And_Get (

3776:
3777: ROLLBACK TO REVISE_AP_IF_NECESSARY;
3778: x_return_status := G_RET_STS_ERROR;
3779: -- Standard call to get message count and if count=1, get the message
3780: FND_MSG_PUB.Count_And_Get (
3781: p_encoded => G_FALSE,
3782: p_count => x_msg_count,
3783: p_data => x_msg_data);
3784:

Line 3790: FND_MSG_PUB.Count_And_Get (

3786:
3787: ROLLBACK TO REVISE_AP_IF_NECESSARY;
3788: x_return_status := G_RET_STS_UNEXP_ERROR;
3789: -- Standard call to get message count and if count=1, get the message
3790: FND_MSG_PUB.Count_And_Get (
3791: p_encoded => G_FALSE,
3792: p_count => x_msg_count,
3793: p_data => x_msg_data);
3794:

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

3795: WHEN OTHERS THEN
3796:
3797: ROLLBACK TO REVISE_AP_IF_NECESSARY;
3798: x_return_status := G_RET_STS_UNEXP_ERROR;
3799: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3800: THEN
3801: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3802: END IF;
3803: -- Standard call to get message count and if count=1, get the message

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

3797: ROLLBACK TO REVISE_AP_IF_NECESSARY;
3798: x_return_status := G_RET_STS_UNEXP_ERROR;
3799: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3800: THEN
3801: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3802: END IF;
3803: -- Standard call to get message count and if count=1, get the message
3804: FND_MSG_PUB.Count_And_Get (
3805: p_encoded => G_FALSE,

Line 3804: FND_MSG_PUB.Count_And_Get (

3800: THEN
3801: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3802: END IF;
3803: -- Standard call to get message count and if count=1, get the message
3804: FND_MSG_PUB.Count_And_Get (
3805: p_encoded => G_FALSE,
3806: p_count => x_msg_count,
3807: p_data => x_msg_data);
3808: