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.PA_AGREEMENT_PUB dependencies on FND_MSG_PUB

Line 141: FND_MSG_PUB.initialize;

137:
138: IF FND_API.TO_BOOLEAN( p_init_msg_list )
139: THEN
140:
141: FND_MSG_PUB.initialize;
142:
143: END IF;
144:
145: -- Set API return status to success

Line 156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

152: -- Product Code
153: IF (p_pm_product_code IS NULL)
154: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
155: THEN
156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
157: THEN
158: pa_interface_utils_pub.map_new_amg_msg
159: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
160: ,p_msg_attribute => 'CHANGE'

Line 178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

174: -- Agreement Reference
175: IF (p_agreement_in_rec.pm_agreement_reference IS NULL)
176: OR (p_agreement_in_rec.pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
177: THEN
178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
179: THEN
180: pa_interface_utils_pub.map_new_amg_msg
181: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
182: ,p_msg_attribute => 'CHANGE'

Line 200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

196: -- Agreement Number
197: IF (p_agreement_in_rec.agreement_num IS NULL)
198: OR (p_agreement_in_rec.agreement_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
199: THEN
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: pa_interface_utils_pub.map_new_amg_msg
203: ( p_old_message_code => 'PA_AGMT_NUM_IS_MISS'
204: ,p_msg_attribute => 'CHANGE'

Line 223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

219:
220: IF (p_agreement_in_rec.customer_id IS NULL)
221: OR (p_agreement_in_rec.customer_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
222: THEN
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
224: THEN
225: pa_interface_utils_pub.map_new_amg_msg
226: ( p_old_message_code => 'PA_CUST_ID_IS_MISS'
227: ,p_msg_attribute => 'CHANGE'

Line 245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

241: -- Customer Number
242: IF (p_agreement_in_rec.customer_num IS NULL)
243: OR (p_agreement_in_rec.customer_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
244: THEN
245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
246: THEN
247: pa_interface_utils_pub.map_new_amg_msg
248: ( p_old_message_code => 'PA_CUST_NUM_IS_MISS'
249: ,p_msg_attribute => 'CHANGE'

Line 267: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

263: -- Agreement Type
264: IF (p_agreement_in_rec.agreement_type IS NULL)
265: OR (p_agreement_in_rec.agreement_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
266: THEN
267: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
268: THEN
269: pa_interface_utils_pub.map_new_amg_msg
270: ( p_old_message_code => 'PA_AGMT_TYPE_IS_MISS'
271: ,p_msg_attribute => 'CHANGE'

Line 289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

285: -- Term Id
286: IF (p_agreement_in_rec.term_id IS NULL)
287: OR (p_agreement_in_rec.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
288: THEN
289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
290: THEN
291: pa_interface_utils_pub.map_new_amg_msg
292: ( p_old_message_code => 'PA_TERM_ID_IS_MISS'
293: ,p_msg_attribute => 'CHANGE'

Line 311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

307: -- Template Flag
308: IF (p_agreement_in_rec.template_flag IS NULL)
309: OR (p_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: THEN
311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
312: THEN
313: pa_interface_utils_pub.map_new_amg_msg
314: ( p_old_message_code => 'PA_TEMP_FLG_IS_MISS'
315: ,p_msg_attribute => 'CHANGE'

Line 333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

329: -- Revenue Limit Flag
330: IF (p_agreement_in_rec.revenue_limit_flag IS NULL)
331: OR (p_agreement_in_rec.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
332: THEN
333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
334: THEN
335: pa_interface_utils_pub.map_new_amg_msg
336: ( p_old_message_code => 'PA_REV_LT_FLG_IS_MISS'
337: ,p_msg_attribute => 'CHANGE'

Line 355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

351: -- Owned By Person Id
352: IF (p_agreement_in_rec.owned_by_person_id IS NULL)
353: OR (p_agreement_in_rec.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
354: THEN
355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
356: THEN
357: pa_interface_utils_pub.map_new_amg_msg
358: ( p_old_message_code => 'PA_OWND_BY_PRSN_ID_MISS'
359: ,p_msg_attribute => 'CHANGE'

Line 377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

373: -- Amount
374: IF (p_agreement_in_rec.amount IS NULL)
375: OR (p_agreement_in_rec.amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
376: THEN
377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: pa_interface_utils_pub.map_new_amg_msg
380: ( p_old_message_code => 'PA_ALLOC_AMT_IS_MISS_AMG'
381: ,p_msg_attribute => 'CHANGE'

Line 461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

457: ,p_validate_status => l_validate_status);
458:
459: IF l_validate_status = 'N'
460: THEN
461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
462: THEN
463: pa_interface_utils_pub.map_new_amg_msg
464: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
465: ,p_msg_attribute => 'CHANGE'

Line 600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

596: ELSE
597: l_advance_flag := 'N';
598: END IF;
599: ELSE
600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
601: THEN
602: pa_interface_utils_pub.map_new_amg_msg
603: ( p_old_message_code => 'PA_CLNT_ADV_CHECK'
604: ,p_msg_attribute => 'CHANGE'

Line 821: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END;
819:
820: IF l_valid_currency='N' THEN
821: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: pa_interface_utils_pub.map_new_amg_msg
824: ( p_old_message_code => 'PA_CURR_NOT_VALID'
825: ,p_msg_attribute => 'CHANGE'

Line 911: FND_MSG_PUB.Count_And_Get

907: WHEN FND_API.G_EXC_ERROR
908: THEN
909: ROLLBACK TO create_agreement_pub;
910: p_return_status := FND_API.G_RET_STS_ERROR;
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => p_msg_count ,
913: p_data => p_msg_data );
914:
915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 919: FND_MSG_PUB.Count_And_Get

915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
916: THEN
917: ROLLBACK TO create_agreement_pub;
918: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: FND_MSG_PUB.Count_And_Get
920: ( p_count => p_msg_count ,
921: p_data => p_msg_data );
922:
923: WHEN OTHERS

Line 927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

923: WHEN OTHERS
924: THEN
925: ROLLBACK TO create_agreement_pub;
926: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
928: THEN
929: FND_MSG_PUB.add_exc_msg
930: ( p_pkg_name => G_PKG_NAME
931: , p_procedure_name => l_api_name );

Line 929: FND_MSG_PUB.add_exc_msg

925: ROLLBACK TO create_agreement_pub;
926: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
928: THEN
929: FND_MSG_PUB.add_exc_msg
930: ( p_pkg_name => G_PKG_NAME
931: , p_procedure_name => l_api_name );
932:
933: END IF;

Line 934: FND_MSG_PUB.Count_And_Get

930: ( p_pkg_name => G_PKG_NAME
931: , p_procedure_name => l_api_name );
932:
933: END IF;
934: FND_MSG_PUB.Count_And_Get
935: ( p_count => p_msg_count ,
936: p_data => p_msg_data );
937:
938:

Line 1054: FND_MSG_PUB.initialize;

1050:
1051: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1052: THEN
1053:
1054: FND_MSG_PUB.initialize;
1055:
1056: END IF;
1057:
1058: -- Set API return status to success

Line 1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1065: -- Product Code
1066: IF (p_pm_product_code IS NULL)
1067: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1068: THEN
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1070: THEN
1071: pa_interface_utils_pub.map_new_amg_msg
1072: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
1073: ,p_msg_attribute => 'CHANGE'

Line 1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1086: -- Agreement Reference
1087: IF (p_pm_agreement_reference IS NULL)
1088: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1089: THEN
1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1091: THEN
1092: pa_interface_utils_pub.map_new_amg_msg
1093: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
1094: ,p_msg_attribute => 'CHANGE'

Line 1111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1107: -- Agreement Id
1108: IF (p_agreement_id IS NULL)
1109: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1110: THEN
1111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1112: THEN
1113: pa_interface_utils_pub.map_new_amg_msg
1114: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
1115: ,p_msg_attribute => 'CHANGE'

Line 1207: FND_MSG_PUB.Count_And_Get

1203: WHEN FND_API.G_EXC_ERROR
1204: THEN
1205: ROLLBACK TO delete_agreement_pub;
1206: p_return_status := FND_API.G_RET_STS_ERROR;
1207: FND_MSG_PUB.Count_And_Get
1208: ( p_count => p_msg_count ,
1209: p_data => p_msg_data );
1210:
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1215: FND_MSG_PUB.Count_And_Get

1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1212: THEN
1213: ROLLBACK TO delete_agreement_pub;
1214: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: FND_MSG_PUB.Count_And_Get
1216: ( p_count => p_msg_count ,
1217: p_data => p_msg_data );
1218:
1219: WHEN ROW_ALREADY_LOCKED

Line 1223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1219: WHEN ROW_ALREADY_LOCKED
1220: THEN
1221: ROLLBACK TO delete_agreement_pub;
1222: p_return_status := FND_API.G_RET_STS_ERROR;
1223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1224: THEN
1225: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1226: FND_MESSAGE.SET_TOKEN('AGREEMENT',p_pm_agreement_reference);
1227: FND_MSG_PUB.ADD;

Line 1227: FND_MSG_PUB.ADD;

1223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1224: THEN
1225: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1226: FND_MESSAGE.SET_TOKEN('AGREEMENT',p_pm_agreement_reference);
1227: FND_MSG_PUB.ADD;
1228: END IF;
1229: FND_MSG_PUB.Count_And_Get
1230: ( p_count => p_msg_count ,
1231: p_data => p_msg_data );

Line 1229: FND_MSG_PUB.Count_And_Get

1225: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1226: FND_MESSAGE.SET_TOKEN('AGREEMENT',p_pm_agreement_reference);
1227: FND_MSG_PUB.ADD;
1228: END IF;
1229: FND_MSG_PUB.Count_And_Get
1230: ( p_count => p_msg_count ,
1231: p_data => p_msg_data );
1232:
1233: WHEN OTHERS

Line 1237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1233: WHEN OTHERS
1234: THEN
1235: ROLLBACK TO delete_agreement_pub;
1236: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: FND_MSG_PUB.add_exc_msg
1240: ( p_pkg_name => G_PKG_NAME
1241: , p_procedure_name => l_api_name );

Line 1239: FND_MSG_PUB.add_exc_msg

1235: ROLLBACK TO delete_agreement_pub;
1236: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: FND_MSG_PUB.add_exc_msg
1240: ( p_pkg_name => G_PKG_NAME
1241: , p_procedure_name => l_api_name );
1242:
1243: END IF;

Line 1244: FND_MSG_PUB.Count_And_Get

1240: ( p_pkg_name => G_PKG_NAME
1241: , p_procedure_name => l_api_name );
1242:
1243: END IF;
1244: FND_MSG_PUB.Count_And_Get
1245: ( p_count => p_msg_count ,
1246: p_data => p_msg_data );
1247:
1248:

Line 1369: FND_MSG_PUB.initialize;

1365:
1366: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1367: THEN
1368:
1369: FND_MSG_PUB.initialize;
1370:
1371: END IF;
1372:
1373: -- Set API return status to success

Line 1385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1381: -- Product Code
1382: IF (p_pm_product_code IS NULL)
1383: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1384: THEN
1385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1386: THEN
1387: pa_interface_utils_pub.map_new_amg_msg
1388: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
1389: ,p_msg_attribute => 'CHANGE'

Line 1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1404: -- Agreement Reference
1405: IF (l_agreement_in_rec.pm_agreement_reference IS NULL)
1406: OR (l_agreement_in_rec.pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1407: THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1409: THEN
1410: pa_interface_utils_pub.map_new_amg_msg
1411: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
1412: ,p_msg_attribute => 'CHANGE'

Line 1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1428: -- Customer Id
1429: IF (l_agreement_in_rec.customer_ID IS NULL)
1430: OR (l_agreement_in_rec.customer_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1431: THEN
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1433: THEN
1434: pa_interface_utils_pub.map_new_amg_msg
1435: ( p_old_message_code => 'PA_CUST_ID_IS_MISS'
1436: ,p_msg_attribute => 'CHANGE'

Line 1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1450: -- Customer Number
1451: IF (l_agreement_in_rec.customer_num IS NULL)
1452: OR (l_agreement_in_rec.customer_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1453: THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456: pa_interface_utils_pub.map_new_amg_msg
1457: ( p_old_message_code => 'PA_CUST_NUM_IS_MISS'
1458: ,p_msg_attribute => 'CHANGE'

Line 1476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1472: -- Agreement Type
1473: IF (l_agreement_in_rec.agreement_type IS NULL)
1474: OR (l_agreement_in_rec.agreement_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1475: THEN
1476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1477: THEN
1478: pa_interface_utils_pub.map_new_amg_msg
1479: ( p_old_message_code => 'PA_AGMT_TYPE_IS_MISS'
1480: ,p_msg_attribute => 'CHANGE'

Line 1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1494: -- Agreement Number
1495: IF (l_agreement_in_rec.agreement_num IS NULL)
1496: OR (l_agreement_in_rec.agreement_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1499: THEN
1500: pa_interface_utils_pub.map_new_amg_msg
1501: ( p_old_message_code => 'PA_AGMT_NUM_IS_MISS'
1502: ,p_msg_attribute => 'CHANGE'

Line 1644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1640: ,p_validate_status => l_validate_status
1641: );
1642: IF l_validate_status = 'N'
1643: THEN
1644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1645: THEN
1646: pa_interface_utils_pub.map_new_amg_msg
1647: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
1648: ,p_msg_attribute => 'CHANGE'

Line 1871: FND_MSG_PUB.Count_And_Get

1867: WHEN FND_API.G_EXC_ERROR
1868: THEN
1869: p_return_status := FND_API.G_RET_STS_ERROR ;
1870: ROLLBACK TO update_agreement_pub;
1871: FND_MSG_PUB.Count_And_Get
1872: ( p_count => p_msg_count ,
1873: p_data => p_msg_data );
1874:
1875:

Line 1880: FND_MSG_PUB.Count_And_Get

1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1877: THEN
1878: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1879: ROLLBACK TO update_agreement_pub;
1880: FND_MSG_PUB.Count_And_Get
1881: ( p_count => p_msg_count ,
1882: p_data => p_msg_data );
1883:
1884: WHEN NO_DATA_FOUND

Line 1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1896:
1897: WHEN ROW_ALREADY_LOCKED THEN
1898: ROLLBACK TO update_project_pub;
1899: p_return_status := FND_API.G_RET_STS_ERROR;
1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN
1902: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1903: FND_MESSAGE.SET_TOKEN('AGREEMENT',l_agreement_in_rec.pm_agreement_reference);
1904: FND_MESSAGE.SET_TOKEN('FUNDING',l_funding_in_rec.pm_funding_reference);

Line 1905: FND_MSG_PUB.ADD;

1901: THEN
1902: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1903: FND_MESSAGE.SET_TOKEN('AGREEMENT',l_agreement_in_rec.pm_agreement_reference);
1904: FND_MESSAGE.SET_TOKEN('FUNDING',l_funding_in_rec.pm_funding_reference);
1905: FND_MSG_PUB.ADD;
1906: END IF;
1907:
1908: FND_MSG_PUB.Count_And_Get
1909: ( p_count => p_msg_count ,

Line 1908: FND_MSG_PUB.Count_And_Get

1904: FND_MESSAGE.SET_TOKEN('FUNDING',l_funding_in_rec.pm_funding_reference);
1905: FND_MSG_PUB.ADD;
1906: END IF;
1907:
1908: FND_MSG_PUB.Count_And_Get
1909: ( p_count => p_msg_count ,
1910: p_data => p_msg_data );
1911:
1912: WHEN OTHERS

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

1912: WHEN OTHERS
1913: THEN
1914: ROLLBACK TO update_agreement_pub;
1915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1916: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1917: THEN
1918: FND_MSG_PUB.add_exc_msg
1919: ( p_pkg_name => G_PKG_NAME
1920: , p_procedure_name => l_api_name );

Line 1918: FND_MSG_PUB.add_exc_msg

1914: ROLLBACK TO update_agreement_pub;
1915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1916: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1917: THEN
1918: FND_MSG_PUB.add_exc_msg
1919: ( p_pkg_name => G_PKG_NAME
1920: , p_procedure_name => l_api_name );
1921: END IF;
1922: FND_MSG_PUB.Count_And_Get

Line 1922: FND_MSG_PUB.Count_And_Get

1918: FND_MSG_PUB.add_exc_msg
1919: ( p_pkg_name => G_PKG_NAME
1920: , p_procedure_name => l_api_name );
1921: END IF;
1922: FND_MSG_PUB.Count_And_Get
1923: ( p_count => p_msg_count ,
1924: p_data => p_msg_data );
1925:
1926:

Line 2128: FND_MSG_PUB.initialize;

2124:
2125: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2126: THEN
2127:
2128: FND_MSG_PUB.initialize;
2129:
2130: END IF;
2131:
2132: -- Set API return status to success

Line 2143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2139: -- Product Code
2140: IF (p_pm_product_code IS NULL)
2141: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2142: THEN
2143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2144: THEN
2145: pa_interface_utils_pub.map_new_amg_msg
2146: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
2147: ,p_msg_attribute => 'CHANGE'

Line 2165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2161: -- Agreement Reference
2162: IF (p_pm_agreement_reference IS NULL)
2163: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2164: THEN
2165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2166: THEN
2167: pa_interface_utils_pub.map_new_amg_msg
2168: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
2169: ,p_msg_attribute => 'CHANGE'

Line 2187: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2183: -- Project Reference
2184: IF (p_pm_project_reference IS NULL)
2185: OR (p_pm_project_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2186: THEN
2187: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2188: THEN
2189: pa_interface_utils_pub.map_new_amg_msg
2190: ( p_old_message_code => 'PA_PROJ_REF_IS_MISS'
2191: ,p_msg_attribute => 'CHANGE'

Line 2212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2208: /* Commented for 2483081 */
2209: /* IF (p_funding_category IS NULL)
2210: OR (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2211: THEN
2212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2213: THEN
2214: pa_interface_utils_pub.map_new_amg_msg
2215: ( p_old_message_code => 'PA_FUND_CAT_IS_MISS'
2216: ,p_msg_attribute => 'CHANGE'

Line 2258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2254: -- Funding Reference
2255: IF (p_pm_funding_reference IS NULL)
2256: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2257: THEN
2258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2259: THEN
2260: pa_interface_utils_pub.map_new_amg_msg
2261: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
2262: ,p_msg_attribute => 'CHANGE'

Line 2279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2275: -- Project Id
2276: IF (p_pa_project_id IS NULL)
2277: OR (p_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2278: THEN
2279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2280: THEN
2281: pa_interface_utils_pub.map_new_amg_msg
2282: ( p_old_message_code => 'PA_PROJ_ID_IS_MISS'
2283: ,p_msg_attribute => 'CHANGE'

Line 2301: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2297: /*
2298: IF (p_pa_task_id IS NULL)
2299: OR (p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2300: THEN
2301: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2302: THEN
2303: pa_interface_utils_pub.map_new_amg_msg
2304: ( p_old_message_code => 'PA_TASK_ID_IS_MISS'
2305: ,p_msg_attribute => 'CHANGE'

Line 2322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2318: -- Date Allocated
2319: IF (p_date_allocated IS NULL)
2320: OR (p_date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2321: THEN
2322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2323: THEN
2324: pa_interface_utils_pub.map_new_amg_msg
2325: ( p_old_message_code => 'PA_DATE_ALLOC_IS_MISS'
2326: ,p_msg_attribute => 'CHANGE'

Line 2343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2339: -- Allocated Amount
2340: IF (p_allocated_amount IS NULL)
2341: OR (p_allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2342: THEN
2343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2344: THEN
2345: pa_interface_utils_pub.map_new_amg_msg
2346: ( p_old_message_code => 'PA_ALLOC_AMT_IS_MISS'
2347: ,p_msg_attribute => 'CHANGE'

Line 2366: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2362: -- Agreement Id
2363: IF (p_agreement_id IS NULL)
2364: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2365: THEN
2366: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2367: THEN
2368: pa_interface_utils_pub.map_new_amg_msg
2369: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
2370: ,p_msg_attribute => 'CHANGE'

Line 2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2392: IF (( (l_total_funding+p_allocated_amount) < l_accrued_amt and l_rev_limit_flag = 'Y') or
2393: ((l_total_funding+p_allocated_amount) < l_billed_amt and l_inv_limit_flag = 'Y'))
2394: THEN
2395:
2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2397: THEN
2398: pa_interface_utils_pub.map_new_amg_msg
2399: ( p_old_message_code => 'PA_BU_AMT_ALLOC_LT_AMT_ACCRUED'
2400: ,p_msg_attribute => 'CHANGE'

Line 2466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2462: ,p_validate_status => l_validate_status
2463: );
2464: IF l_validate_status = 'N'
2465: THEN
2466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2467: THEN
2468: pa_interface_utils_pub.map_new_amg_msg
2469: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
2470: ,p_msg_attribute => 'CHANGE'

Line 2673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2669: END IF;
2670:
2671: /* End - Bug 2902096 */
2672:
2673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2674: THEN
2675: pa_interface_utils_pub.map_new_amg_msg
2676: ( p_old_message_code => l_err_msg
2677: ,p_msg_attribute => 'CHANGE'

Line 2711: FND_MSG_PUB.Count_And_Get

2707: WHEN FND_API.G_EXC_ERROR
2708: THEN
2709: ROLLBACK TO add_funding_pub;
2710: p_return_status := FND_API.G_RET_STS_ERROR;
2711: FND_MSG_PUB.Count_And_Get
2712: ( p_count => p_msg_count ,
2713: p_data => p_msg_data );
2714:
2715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 2719: FND_MSG_PUB.Count_And_Get

2715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2716: THEN
2717: ROLLBACK TO add_funding_pub;
2718: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2719: FND_MSG_PUB.Count_And_Get
2720: ( p_count => p_msg_count ,
2721: p_data => p_msg_data );
2722:
2723: WHEN OTHERS

Line 2727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2723: WHEN OTHERS
2724: THEN
2725: ROLLBACK TO add_funding_pub;
2726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2728: THEN
2729: FND_MSG_PUB.add_exc_msg
2730: ( p_pkg_name => G_PKG_NAME
2731: , p_procedure_name => l_api_name );

Line 2729: FND_MSG_PUB.add_exc_msg

2725: ROLLBACK TO add_funding_pub;
2726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2728: THEN
2729: FND_MSG_PUB.add_exc_msg
2730: ( p_pkg_name => G_PKG_NAME
2731: , p_procedure_name => l_api_name );
2732:
2733: END IF;

Line 2734: FND_MSG_PUB.Count_And_Get

2730: ( p_pkg_name => G_PKG_NAME
2731: , p_procedure_name => l_api_name );
2732:
2733: END IF;
2734: FND_MSG_PUB.Count_And_Get
2735: ( p_count => p_msg_count ,
2736: p_data => p_msg_data );
2737:
2738: END add_funding;

Line 2874: FND_MSG_PUB.initialize;

2870:
2871: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2872: THEN
2873:
2874: FND_MSG_PUB.initialize;
2875:
2876: END IF;
2877:
2878: -- Set API return status to success

Line 2888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2884: -- Product Code
2885: IF (p_pm_product_code IS NULL)
2886: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2887: THEN
2888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2889: THEN
2890: pa_interface_utils_pub.map_new_amg_msg
2891: ( p_old_message_code => 'PA_CUST_NUM_IS_MISS'
2892: ,p_msg_attribute => 'CHANGE'

Line 2909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2905: -- Funding Reference
2906: IF (p_pm_funding_reference IS NULL)
2907: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2908: THEN
2909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2910: THEN
2911: pa_interface_utils_pub.map_new_amg_msg
2912: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
2913: ,p_msg_attribute => 'CHANGE'

Line 2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2927: -- Funding Id
2928: IF (p_funding_id IS NULL)
2929: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2930: THEN
2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2932: THEN
2933: pa_interface_utils_pub.map_new_amg_msg
2934: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
2935: ,p_msg_attribute => 'CHANGE'

Line 3036: FND_MSG_PUB.Count_And_Get

3032: WHEN FND_API.G_EXC_ERROR
3033: THEN
3034: ROLLBACK TO delete_funding_pub;
3035: p_return_status := FND_API.G_RET_STS_ERROR;
3036: FND_MSG_PUB.Count_And_Get
3037: ( p_count => p_msg_count ,
3038: p_data => p_msg_data );
3039:
3040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3044: FND_MSG_PUB.Count_And_Get

3040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3041: THEN
3042: ROLLBACK TO delete_funding_pub;
3043: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3044: FND_MSG_PUB.Count_And_Get
3045: ( p_count => p_msg_count ,
3046: p_data => p_msg_data );
3047:
3048: WHEN ROW_ALREADY_LOCKED

Line 3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3048: WHEN ROW_ALREADY_LOCKED
3049: THEN
3050: ROLLBACK TO delete_funding_pub;
3051: p_return_status := FND_API.G_RET_STS_ERROR;
3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3053: THEN
3054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
3055: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
3056: FND_MSG_PUB.ADD;

Line 3056: FND_MSG_PUB.ADD;

3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3053: THEN
3054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
3055: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
3056: FND_MSG_PUB.ADD;
3057: END IF;
3058: FND_MSG_PUB.Count_And_Get
3059: ( p_count => p_msg_count ,
3060: p_data => p_msg_data );

Line 3058: FND_MSG_PUB.Count_And_Get

3054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
3055: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
3056: FND_MSG_PUB.ADD;
3057: END IF;
3058: FND_MSG_PUB.Count_And_Get
3059: ( p_count => p_msg_count ,
3060: p_data => p_msg_data );
3061:
3062: WHEN OTHERS

Line 3066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3062: WHEN OTHERS
3063: THEN
3064: ROLLBACK TO delete_funding_pub;
3065: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3067: THEN
3068: FND_MSG_PUB.add_exc_msg
3069: ( p_pkg_name => G_PKG_NAME
3070: , p_procedure_name => l_api_name );

Line 3068: FND_MSG_PUB.add_exc_msg

3064: ROLLBACK TO delete_funding_pub;
3065: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3067: THEN
3068: FND_MSG_PUB.add_exc_msg
3069: ( p_pkg_name => G_PKG_NAME
3070: , p_procedure_name => l_api_name );
3071: END IF;
3072: FND_MSG_PUB.Count_And_Get

Line 3072: FND_MSG_PUB.Count_And_Get

3068: FND_MSG_PUB.add_exc_msg
3069: ( p_pkg_name => G_PKG_NAME
3070: , p_procedure_name => l_api_name );
3071: END IF;
3072: FND_MSG_PUB.Count_And_Get
3073: ( p_count => p_msg_count ,
3074: p_data => p_msg_data );
3075:
3076: END delete_funding;

Line 3269: FND_MSG_PUB.initialize;

3265:
3266: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3267: THEN
3268:
3269: FND_MSG_PUB.initialize;
3270:
3271: END IF;
3272:
3273: -- Set API return status to success

Line 3283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3279: -- Product Code
3280: IF (p_pm_product_code IS NULL)
3281: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3282: THEN
3283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3284: THEN
3285: pa_interface_utils_pub.map_new_amg_msg
3286: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
3287: ,p_msg_attribute => 'CHANGE'

Line 3315: /***** IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3311: THEN
3312: l_funding_category := 'ADDITIONAL';
3313: ELSE
3314: l_funding_category := p_funding_category;
3315: /***** IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3316: THEN
3317: pa_interface_utils_pub.map_new_amg_msg
3318: ( p_old_message_code => 'PA_FUND_CAT_IS_MISS'
3319: ,p_msg_attribute => 'CHANGE'

Line 3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3350: -- Funding Reference
3351: IF (p_pm_funding_reference IS NULL)
3352: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3353: THEN
3354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3355: THEN
3356: pa_interface_utils_pub.map_new_amg_msg
3357: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
3358: ,p_msg_attribute => 'CHANGE'

Line 3375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3371: -- Funding Id
3372: IF (p_funding_id IS NULL)
3373: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3374: THEN
3375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3376: THEN
3377: pa_interface_utils_pub.map_new_amg_msg
3378: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
3379: ,p_msg_attribute => 'CHANGE'

Line 3409: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3405:
3406: IF (( (l_total_funding+p_allocated_amount-l_projfunc_allocated_amount) < l_accrued_amt and l_rev_limit_flag = 'Y') or
3407: ((l_total_funding+p_allocated_amount - l_projfunc_allocated_amount) < l_billed_amt and l_inv_limit_flag = 'Y')) THEN
3408:
3409: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3410: THEN
3411: pa_interface_utils_pub.map_new_amg_msg
3412: (p_old_message_code => 'PA_BU_AMT_ALLOC_LT_AMT_ACCRUED'
3413: ,p_msg_attribute => 'CHANGE'

Line 3516: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3512: ,p_validate_status => l_validate_status
3513: );
3514: IF l_validate_status = 'N'
3515: THEN
3516: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3517: THEN
3518: pa_interface_utils_pub.map_new_amg_msg
3519: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
3520: ,p_msg_attribute => 'CHANGE'

Line 3619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3615:
3616:
3617: /* End - Bug 2902096 */
3618:
3619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3620: THEN
3621: pa_interface_utils_pub.map_new_amg_msg
3622: ( p_old_message_code => l_err_msg
3623: ,p_msg_attribute => 'CHANGE'

Line 3661: FND_MSG_PUB.Count_And_Get

3657: WHEN FND_API.G_EXC_ERROR
3658: THEN
3659: p_return_status := FND_API.G_RET_STS_ERROR ;
3660: ROLLBACK TO update_funding_pub;
3661: FND_MSG_PUB.Count_And_Get
3662: ( p_count => p_msg_count ,
3663: p_data => p_msg_data );
3664:
3665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3669: FND_MSG_PUB.Count_And_Get

3665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3666: THEN
3667: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3668: ROLLBACK TO update_funding_pub;
3669: FND_MSG_PUB.Count_And_Get
3670: ( p_count => p_msg_count ,
3671: p_data => p_msg_data );
3672:
3673: WHEN OTHERS

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

3673: WHEN OTHERS
3674: THEN
3675: ROLLBACK TO update_funding_pub;
3676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3678: THEN
3679: FND_MSG_PUB.add_exc_msg
3680: ( p_pkg_name => G_PKG_NAME
3681: , p_procedure_name => l_api_name );

Line 3679: FND_MSG_PUB.add_exc_msg

3675: ROLLBACK TO update_funding_pub;
3676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3678: THEN
3679: FND_MSG_PUB.add_exc_msg
3680: ( p_pkg_name => G_PKG_NAME
3681: , p_procedure_name => l_api_name );
3682: END IF;
3683: FND_MSG_PUB.Count_And_Get

Line 3683: FND_MSG_PUB.Count_And_Get

3679: FND_MSG_PUB.add_exc_msg
3680: ( p_pkg_name => G_PKG_NAME
3681: , p_procedure_name => l_api_name );
3682: END IF;
3683: FND_MSG_PUB.Count_And_Get
3684: ( p_count => p_msg_count ,
3685: p_data => p_msg_data );
3686:
3687: END update_funding;

Line 3870: FND_MSG_PUB.initialize;

3866:
3867: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3868: THEN
3869:
3870: FND_MSG_PUB.initialize;
3871:
3872: END IF;
3873:
3874: -- Set API return status to success

Line 3951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3947: THEN
3948: ROLLBACK TO load_agreement_pub;
3949: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3950:
3951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3952: THEN
3953: FND_MSG_PUB.add_exc_msg
3954: ( p_pkg_name => G_PKG_NAME
3955: , p_procedure_name => l_api_name );

Line 3953: FND_MSG_PUB.add_exc_msg

3949: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3950:
3951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3952: THEN
3953: FND_MSG_PUB.add_exc_msg
3954: ( p_pkg_name => G_PKG_NAME
3955: , p_procedure_name => l_api_name );
3956: END IF;
3957:

Line 4079: FND_MSG_PUB.initialize;

4075:
4076: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4077: THEN
4078:
4079: FND_MSG_PUB.initialize;
4080:
4081: END IF;
4082:
4083: -- Set API return status to success

Line 4133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4129: WHEN OTHERS
4130: THEN
4131: ROLLBACK TO load_funding_pub;
4132: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4134: THEN
4135: FND_MSG_PUB.add_exc_msg
4136: ( p_pkg_name => G_PKG_NAME
4137: , p_procedure_name => l_api_name );

Line 4135: FND_MSG_PUB.add_exc_msg

4131: ROLLBACK TO load_funding_pub;
4132: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4134: THEN
4135: FND_MSG_PUB.add_exc_msg
4136: ( p_pkg_name => G_PKG_NAME
4137: , p_procedure_name => l_api_name );
4138: END IF;
4139:

Line 4241: FND_MSG_PUB.initialize;

4237:
4238: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4239: THEN
4240:
4241: FND_MSG_PUB.initialize;
4242:
4243: END IF;
4244:
4245: -- Set API return status to success

Line 4299: FND_MSG_PUB.Count_And_Get

4295: WHEN FND_API.G_EXC_ERROR
4296: THEN
4297: ROLLBACK TO execute_create_agreement_pub;
4298: p_return_status := FND_API.G_RET_STS_ERROR;
4299: FND_MSG_PUB.Count_And_Get
4300: ( p_count => p_msg_count ,
4301: p_data => p_msg_data );
4302:
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 4307: FND_MSG_PUB.Count_And_Get

4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4304: THEN
4305: ROLLBACK TO execute_create_agreement_pub;
4306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4307: FND_MSG_PUB.Count_And_Get
4308: ( p_count => p_msg_count ,
4309: p_data => p_msg_data );
4310:
4311: WHEN OTHERS

Line 4315: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4311: WHEN OTHERS
4312: THEN
4313: ROLLBACK TO execute_create_agreement_pub;
4314: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4315: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4316: THEN
4317: FND_MSG_PUB.add_exc_msg
4318: ( p_pkg_name => G_PKG_NAME
4319: , p_procedure_name => l_api_name );

Line 4317: FND_MSG_PUB.add_exc_msg

4313: ROLLBACK TO execute_create_agreement_pub;
4314: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4315: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4316: THEN
4317: FND_MSG_PUB.add_exc_msg
4318: ( p_pkg_name => G_PKG_NAME
4319: , p_procedure_name => l_api_name );
4320: END IF;
4321: FND_MSG_PUB.Count_And_Get

Line 4321: FND_MSG_PUB.Count_And_Get

4317: FND_MSG_PUB.add_exc_msg
4318: ( p_pkg_name => G_PKG_NAME
4319: , p_procedure_name => l_api_name );
4320: END IF;
4321: FND_MSG_PUB.Count_And_Get
4322: ( p_count => p_msg_count ,
4323: p_data => p_msg_data );
4324:
4325: END execute_create_agreement;

Line 4424: FND_MSG_PUB.initialize;

4420:
4421: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4422: THEN
4423:
4424: FND_MSG_PUB.initialize;
4425:
4426: END IF;
4427:
4428: -- Set API return status to success

Line 4466: FND_MSG_PUB.Count_And_Get

4462: WHEN FND_API.G_EXC_ERROR
4463: THEN
4464: ROLLBACK TO execute_update_agreement_pub;
4465: p_return_status := FND_API.G_RET_STS_ERROR;
4466: FND_MSG_PUB.Count_And_Get
4467: ( p_count => p_msg_count ,
4468: p_data => p_msg_data );
4469:
4470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 4474: FND_MSG_PUB.Count_And_Get

4470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4471: THEN
4472: ROLLBACK TO execute_update_agreement_pub;
4473: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4474: FND_MSG_PUB.Count_And_Get
4475: ( p_count => p_msg_count ,
4476: p_data => p_msg_data );
4477:
4478: WHEN OTHERS

Line 4482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4478: WHEN OTHERS
4479: THEN
4480: ROLLBACK TO execute_update_agreement_pub;
4481: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: FND_MSG_PUB.add_exc_msg
4485: ( p_pkg_name => G_PKG_NAME
4486: , p_procedure_name => l_api_name

Line 4484: FND_MSG_PUB.add_exc_msg

4480: ROLLBACK TO execute_update_agreement_pub;
4481: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: FND_MSG_PUB.add_exc_msg
4485: ( p_pkg_name => G_PKG_NAME
4486: , p_procedure_name => l_api_name
4487: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
4488: FND_MSG_PUB.add;

Line 4488: FND_MSG_PUB.add;

4484: FND_MSG_PUB.add_exc_msg
4485: ( p_pkg_name => G_PKG_NAME
4486: , p_procedure_name => l_api_name
4487: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
4488: FND_MSG_PUB.add;
4489: END IF;
4490: FND_MSG_PUB.Count_And_Get
4491: ( p_count => p_msg_count ,
4492: p_data => p_msg_data );

Line 4490: FND_MSG_PUB.Count_And_Get

4486: , p_procedure_name => l_api_name
4487: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
4488: FND_MSG_PUB.add;
4489: END IF;
4490: FND_MSG_PUB.Count_And_Get
4491: ( p_count => p_msg_count ,
4492: p_data => p_msg_data );
4493:
4494: END execute_update_agreement;

Line 4592: FND_MSG_PUB.initialize;

4588:
4589: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4590: THEN
4591:
4592: FND_MSG_PUB.initialize;
4593:
4594: END IF;
4595:
4596: -- Set API return status to success

Line 4604: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4600: -- Check Funding index value, when they don't provide an index we will error out
4601: IF p_funding_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4602: OR p_funding_index IS NULL
4603: THEN
4604: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4605: THEN
4606: pa_interface_utils_pub.map_new_amg_msg
4607: ( p_old_message_code => 'PA_FUND_INDEX_NOT_PROV'
4608: ,p_msg_attribute => 'CHANGE'

Line 4651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4647: WHEN OTHERS
4648: THEN
4649: ROLLBACK TO fetch_funding_pub;
4650: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4652: THEN
4653: FND_MSG_PUB.add_exc_msg
4654: ( p_pkg_name => G_PKG_NAME
4655: , p_procedure_name => l_api_name );

Line 4653: FND_MSG_PUB.add_exc_msg

4649: ROLLBACK TO fetch_funding_pub;
4650: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4652: THEN
4653: FND_MSG_PUB.add_exc_msg
4654: ( p_pkg_name => G_PKG_NAME
4655: , p_procedure_name => l_api_name );
4656: END IF;
4657:

Line 4794: FND_MSG_PUB.initialize;

4790:
4791: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4792: THEN
4793:
4794: FND_MSG_PUB.initialize;
4795:
4796: END IF;
4797:
4798: -- Set API return status to success

Line 4809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4805: -- Agreement Reference
4806: IF (p_pm_agreement_reference IS NULL)
4807: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4808: THEN
4809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4810: THEN
4811: pa_interface_utils_pub.map_new_amg_msg
4812: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
4813: ,p_msg_attribute => 'CHANGE'

Line 4830: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4826: -- Agreement Id
4827: IF (p_agreement_id IS NULL)
4828: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4829: THEN
4830: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4831: THEN
4832: pa_interface_utils_pub.map_new_amg_msg
4833: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
4834: ,p_msg_attribute => 'CHANGE'

Line 4853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4849: -- TO BE CORRECTED - NIKHIL
4850: -- Agreement Reference
4851: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
4852: THEN
4853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4854: THEN
4855: pa_interface_utils_pub.map_new_amg_msg
4856: ( p_old_message_code => 'PA_INVD_AGMT_REF'
4857: ,p_msg_attribute => 'CHANGE'

Line 4874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4870: /* NOT REQUIRED
4871: -- Agreement Id
4872: IF pa_agreement_utils.check_valid_agreement_id(p_agreement_id => p_agreement_id) = 'N'
4873: THEN
4874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4875: THEN
4876: pa_interface_utils_pub.map_new_amg_msg
4877: ( p_old_message_code => 'PA_INVD_AGMT_ID'
4878: ,p_msg_attribute => 'CHANGE'

Line 4928: FND_MSG_PUB.Count_And_Get

4924: WHEN FND_API.G_EXC_ERROR
4925: THEN
4926: ROLLBACK TO check_delete_agreement_ok_pub;
4927: p_return_status := FND_API.G_RET_STS_ERROR;
4928: FND_MSG_PUB.Count_And_Get
4929: ( p_count => p_msg_count ,
4930: p_data => p_msg_data );
4931:
4932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 4936: FND_MSG_PUB.Count_And_Get

4932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4933: THEN
4934: ROLLBACK TO check_delete_agreement_ok_pub;
4935: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4936: FND_MSG_PUB.Count_And_Get
4937: ( p_count => p_msg_count ,
4938: p_data => p_msg_data );
4939:
4940: WHEN OTHERS

Line 4944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4940: WHEN OTHERS
4941: THEN
4942: ROLLBACK TO check_delete_agreement_ok_pub;
4943: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4945: THEN
4946: FND_MSG_PUB.add_exc_msg
4947: ( p_pkg_name => G_PKG_NAME
4948: , p_procedure_name => l_api_name );

Line 4946: FND_MSG_PUB.add_exc_msg

4942: ROLLBACK TO check_delete_agreement_ok_pub;
4943: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4945: THEN
4946: FND_MSG_PUB.add_exc_msg
4947: ( p_pkg_name => G_PKG_NAME
4948: , p_procedure_name => l_api_name );
4949:
4950: END IF;

Line 4951: FND_MSG_PUB.Count_And_Get

4947: ( p_pkg_name => G_PKG_NAME
4948: , p_procedure_name => l_api_name );
4949:
4950: END IF;
4951: FND_MSG_PUB.Count_And_Get
4952: ( p_count => p_msg_count ,
4953: p_data => p_msg_data );
4954:
4955:

Line 5074: FND_MSG_PUB.initialize;

5070:
5071: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5072: THEN
5073:
5074: FND_MSG_PUB.initialize;
5075:
5076: END IF;
5077:
5078: -- Set API return status to success

Line 5088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5084: -- Agreement Reference
5085: IF (p_pm_agreement_reference IS NULL)
5086: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5087: THEN
5088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5089: THEN
5090: pa_interface_utils_pub.map_new_amg_msg
5091: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
5092: ,p_msg_attribute => 'CHANGE'

Line 5109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5105: -- Project Id
5106: IF (p_project_id IS NULL)
5107: OR (p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5108: THEN
5109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5110: THEN
5111: pa_interface_utils_pub.map_new_amg_msg
5112: ( p_old_message_code => 'PA_PROJ_ID_IS_MISS'
5113: ,p_msg_attribute => 'CHANGE'

Line 5130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5126: -- Task Id
5127: IF (p_task_id IS NULL)
5128: OR (p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5129: THEN
5130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5131: THEN
5132: pa_interface_utils_pub.map_new_amg_msg
5133: ( p_old_message_code => 'PA_TASK_ID_IS_MISS'
5134: ,p_msg_attribute => 'CHANGE'

Line 5151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5147: -- Funding Reference
5148: IF (p_pm_funding_reference IS NULL)
5149: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5150: THEN
5151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5152: THEN
5153: pa_interface_utils_pub.map_new_amg_msg
5154: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5155: ,p_msg_attribute => 'CHANGE'

Line 5173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5169: -- Funding Id
5170: IF (p_funding_id IS NULL)
5171: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5172: THEN
5173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5174: THEN
5175: pa_interface_utils_pub.map_new_amg_msg
5176: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5177: ,p_msg_attribute => 'CHANGE'

Line 5197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5193: --TO BE CORRECTED - NIKHIL
5194: -- Agreement Reference
5195: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
5196: THEN
5197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5198: THEN
5199: pa_interface_utils_pub.map_new_amg_msg
5200: ( p_old_message_code => 'PA_INVD_AGMT_REF'
5201: ,p_msg_attribute => 'CHANGE'

Line 5218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5214: -- Funding Reference
5215: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5216: ,p_agreement_id => p_agreement_id) = 'N'
5217: THEN
5218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5219: THEN
5220: pa_interface_utils_pub.map_new_amg_msg
5221: ( p_old_message_code => 'PA_INVD_FUND_REF'
5222: ,p_msg_attribute => 'CHANGE'

Line 5290: FND_MSG_PUB.Count_And_Get

5286: WHEN FND_API.G_EXC_ERROR
5287: THEN
5288: ROLLBACK TO check_add_funding_ok_pub;
5289: p_return_status := FND_API.G_RET_STS_ERROR;
5290: FND_MSG_PUB.Count_And_Get
5291: ( p_count => p_msg_count ,
5292: p_data => p_msg_data );
5293:
5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 5298: FND_MSG_PUB.Count_And_Get

5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
5295: THEN
5296: ROLLBACK TO check_add_funding_ok_pub;
5297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5298: FND_MSG_PUB.Count_And_Get
5299: ( p_count => p_msg_count ,
5300: p_data => p_msg_data );
5301:
5302: WHEN OTHERS

Line 5306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5302: WHEN OTHERS
5303: THEN
5304: ROLLBACK TO check_add_funding_ok_pub;
5305: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5307: THEN
5308: FND_MSG_PUB.add_exc_msg
5309: ( p_pkg_name => G_PKG_NAME
5310: , p_procedure_name => l_api_name );

Line 5308: FND_MSG_PUB.add_exc_msg

5304: ROLLBACK TO check_add_funding_ok_pub;
5305: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5307: THEN
5308: FND_MSG_PUB.add_exc_msg
5309: ( p_pkg_name => G_PKG_NAME
5310: , p_procedure_name => l_api_name );
5311:
5312: END IF;

Line 5313: FND_MSG_PUB.Count_And_Get

5309: ( p_pkg_name => G_PKG_NAME
5310: , p_procedure_name => l_api_name );
5311:
5312: END IF;
5313: FND_MSG_PUB.Count_And_Get
5314: ( p_count => p_msg_count ,
5315: p_data => p_msg_data );
5316:
5317:

Line 5429: FND_MSG_PUB.initialize;

5425:
5426: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5427: THEN
5428:
5429: FND_MSG_PUB.initialize;
5430:
5431: END IF;
5432:
5433: -- Set API return status to success

Line 5443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5439: -- Funding Reference
5440: IF (p_pm_funding_reference IS NULL)
5441: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5442: THEN
5443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5444: THEN
5445: pa_interface_utils_pub.map_new_amg_msg
5446: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5447: ,p_msg_attribute => 'CHANGE'

Line 5464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5460: -- Funding Id
5461: IF (p_funding_id IS NULL)
5462: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5463: THEN
5464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5465: THEN
5466: pa_interface_utils_pub.map_new_amg_msg
5467: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5468: ,p_msg_attribute => 'CHANGE'

Line 5490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5486: (p_funding_reference => p_pm_funding_reference
5487: ,p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5488: ,p_funding_reference => p_pm_funding_reference)) = 'N'
5489: THEN
5490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5491: THEN
5492: pa_interface_utils_pub.map_new_amg_msg
5493: ( p_old_message_code => 'PA_INVD_FUND_REF'
5494: ,p_msg_attribute => 'CHANGE'

Line 5512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5508: IF pa_agreement_utils.check_valid_funding_id(p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5509: ,p_funding_reference => p_pm_funding_reference)
5510: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'
5511: THEN
5512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5513: THEN
5514: pa_interface_utils_pub.map_new_amg_msg
5515: ( p_old_message_code => 'PA_INVD_FUND_ID'
5516: ,p_msg_attribute => 'CHANGE'

Line 5566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5562: ROLLBACK TO check_delete_funding_ok_pub;
5563:
5564: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5565:
5566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5567: THEN
5568: FND_MSG_PUB.add_exc_msg
5569: ( p_pkg_name => G_PKG_NAME
5570: , p_procedure_name => l_api_name );

Line 5568: FND_MSG_PUB.add_exc_msg

5564: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5565:
5566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5567: THEN
5568: FND_MSG_PUB.add_exc_msg
5569: ( p_pkg_name => G_PKG_NAME
5570: , p_procedure_name => l_api_name );
5571:
5572: END IF;

Line 5711: FND_MSG_PUB.initialize;

5707:
5708: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5709: THEN
5710:
5711: FND_MSG_PUB.initialize;
5712:
5713: END IF;
5714:
5715: -- Set API return status to success

Line 5725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5721: -- Funding Reference
5722: IF (p_pm_funding_reference IS NULL)
5723: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5724: THEN
5725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5726: THEN
5727: pa_interface_utils_pub.map_new_amg_msg
5728: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5729: ,p_msg_attribute => 'CHANGE'

Line 5746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5742: -- Funding Id
5743: IF (p_funding_id IS NULL)
5744: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5745: THEN
5746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5747: THEN
5748: pa_interface_utils_pub.map_new_amg_msg
5749: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5750: ,p_msg_attribute => 'CHANGE'

Line 5769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5765: -- Funding Reference
5766: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5767: ,p_agreement_id => p_agreement_id) = 'N'
5768: THEN
5769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5770: THEN
5771: pa_interface_utils_pub.map_new_amg_msg
5772: ( p_old_message_code => 'PA_INVD_FUND_REF'
5773: ,p_msg_attribute => 'CHANGE'

Line 5790: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5786: -- Agreement Id
5787: IF pa_agreement_utils.check_valid_agreement_id
5788: (p_agreement_id => p_agreement_id) = 'N'
5789: THEN
5790: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5791: THEN
5792: pa_interface_utils_pub.map_new_amg_msg
5793: ( p_old_message_code => 'PA_INVALID_FUNDING_ID'
5794: ,p_msg_attribute => 'CHANGE'

Line 5827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5823: ,p_validate_status => l_validate_status
5824: );
5825: IF l_validate_status = 'N'
5826: THEN
5827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5828: THEN
5829: pa_interface_utils_pub.map_new_amg_msg
5830: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
5831: ,p_msg_attribute => 'CHANGE'

Line 5892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5888: ROLLBACK TO check_update_funding_ok_pub;
5889:
5890: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5891:
5892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5893: THEN
5894: FND_MSG_PUB.add_exc_msg
5895: ( p_pkg_name => G_PKG_NAME
5896: , p_procedure_name => l_api_name );

Line 5894: FND_MSG_PUB.add_exc_msg

5890: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5891:
5892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5893: THEN
5894: FND_MSG_PUB.add_exc_msg
5895: ( p_pkg_name => G_PKG_NAME
5896: , p_procedure_name => l_api_name );
5897:
5898: END IF;

Line 6072: FND_MSG_PUB.initialize;

6068: -- Standard call to check for call compatibility.
6069: IF FND_API.TO_BOOLEAN( p_init_msg_list )
6070: THEN
6071:
6072: FND_MSG_PUB.initialize;
6073:
6074: END IF;
6075:
6076:

Line 6109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6105:
6106: IF (PA_FUNDING_CORE.CHECK_PROJECT_TYPE(l_project_id)) = 'N' THEN
6107: p_return_status := FND_API.G_RET_STS_ERROR;
6108:
6109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6110: THEN
6111: pa_interface_utils_pub.map_new_amg_msg
6112: ( p_old_message_code => 'PA_INVALID_PROJECT'
6113: ,p_msg_attribute => 'CHANGE'

Line 6360: FND_MSG_PUB.Count_And_Get

6356: WHEN FND_API.G_EXC_ERROR
6357: THEN
6358: ROLLBACK TO Create_Budget_From_funding;
6359: p_return_status := FND_API.G_RET_STS_ERROR;
6360: FND_MSG_PUB.Count_And_Get
6361: ( p_count => p_msg_count ,
6362: p_data => p_msg_data );
6363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
6364: THEN

Line 6367: FND_MSG_PUB.Count_And_Get

6363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
6364: THEN
6365: ROLLBACK TO Create_Budget_From_funding;
6366: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6367: FND_MSG_PUB.Count_And_Get
6368: ( p_count => p_msg_count ,
6369: p_data => p_msg_data );
6370:
6371: WHEN OTHERS

Line 6375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6371: WHEN OTHERS
6372: THEN
6373: ROLLBACK TO Create_Budget_From_funding;
6374: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6376: THEN
6377: FND_MSG_PUB.add_exc_msg
6378: ( p_pkg_name => G_PKG_NAME
6379: , p_procedure_name => l_api_name );

Line 6377: FND_MSG_PUB.add_exc_msg

6373: ROLLBACK TO Create_Budget_From_funding;
6374: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6375: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6376: THEN
6377: FND_MSG_PUB.add_exc_msg
6378: ( p_pkg_name => G_PKG_NAME
6379: , p_procedure_name => l_api_name );
6380:
6381: END IF;

Line 6382: FND_MSG_PUB.Count_And_Get

6378: ( p_pkg_name => G_PKG_NAME
6379: , p_procedure_name => l_api_name );
6380:
6381: END IF;
6382: FND_MSG_PUB.Count_And_Get
6383: ( p_count => p_msg_count ,
6384: p_data => p_msg_data );
6385:
6386: