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 2096: FND_MSG_PUB.initialize;

2092:
2093: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2094: THEN
2095:
2096: FND_MSG_PUB.initialize;
2097:
2098: END IF;
2099:
2100: -- Set API return status to success

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

2107: -- Product Code
2108: IF (p_pm_product_code IS NULL)
2109: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2110: THEN
2111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2112: THEN
2113: pa_interface_utils_pub.map_new_amg_msg
2114: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
2115: ,p_msg_attribute => 'CHANGE'

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

2129: -- Agreement Reference
2130: IF (p_pm_agreement_reference IS NULL)
2131: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2132: THEN
2133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2134: THEN
2135: pa_interface_utils_pub.map_new_amg_msg
2136: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
2137: ,p_msg_attribute => 'CHANGE'

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

2151: -- Project Reference
2152: IF (p_pm_project_reference IS NULL)
2153: OR (p_pm_project_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2154: THEN
2155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2156: THEN
2157: pa_interface_utils_pub.map_new_amg_msg
2158: ( p_old_message_code => 'PA_PROJ_REF_IS_MISS'
2159: ,p_msg_attribute => 'CHANGE'

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

2176: /* Commented for 2483081 */
2177: /* IF (p_funding_category IS NULL)
2178: OR (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2179: THEN
2180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2181: THEN
2182: pa_interface_utils_pub.map_new_amg_msg
2183: ( p_old_message_code => 'PA_FUND_CAT_IS_MISS'
2184: ,p_msg_attribute => 'CHANGE'

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

2222: -- Funding Reference
2223: IF (p_pm_funding_reference IS NULL)
2224: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2225: THEN
2226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2227: THEN
2228: pa_interface_utils_pub.map_new_amg_msg
2229: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
2230: ,p_msg_attribute => 'CHANGE'

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

2243: -- Project Id
2244: IF (p_pa_project_id IS NULL)
2245: OR (p_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2246: THEN
2247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2248: THEN
2249: pa_interface_utils_pub.map_new_amg_msg
2250: ( p_old_message_code => 'PA_PROJ_ID_IS_MISS'
2251: ,p_msg_attribute => 'CHANGE'

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

2265: /*
2266: IF (p_pa_task_id IS NULL)
2267: OR (p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2268: THEN
2269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2270: THEN
2271: pa_interface_utils_pub.map_new_amg_msg
2272: ( p_old_message_code => 'PA_TASK_ID_IS_MISS'
2273: ,p_msg_attribute => 'CHANGE'

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

2286: -- Date Allocated
2287: IF (p_date_allocated IS NULL)
2288: OR (p_date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2289: THEN
2290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2291: THEN
2292: pa_interface_utils_pub.map_new_amg_msg
2293: ( p_old_message_code => 'PA_DATE_ALLOC_IS_MISS'
2294: ,p_msg_attribute => 'CHANGE'

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

2307: -- Allocated Amount
2308: IF (p_allocated_amount IS NULL)
2309: OR (p_allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2310: THEN
2311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2312: THEN
2313: pa_interface_utils_pub.map_new_amg_msg
2314: ( p_old_message_code => 'PA_ALLOC_AMT_IS_MISS'
2315: ,p_msg_attribute => 'CHANGE'

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

2330: -- Agreement Id
2331: IF (p_agreement_id IS NULL)
2332: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2333: THEN
2334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2335: THEN
2336: pa_interface_utils_pub.map_new_amg_msg
2337: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
2338: ,p_msg_attribute => 'CHANGE'

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

2399: ,p_validate_status => l_validate_status
2400: );
2401: IF l_validate_status = 'N'
2402: THEN
2403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2404: THEN
2405: pa_interface_utils_pub.map_new_amg_msg
2406: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
2407: ,p_msg_attribute => 'CHANGE'

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

2606: END IF;
2607:
2608: /* End - Bug 2902096 */
2609:
2610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2611: THEN
2612: pa_interface_utils_pub.map_new_amg_msg
2613: ( p_old_message_code => l_err_msg
2614: ,p_msg_attribute => 'CHANGE'

Line 2648: FND_MSG_PUB.Count_And_Get

2644: WHEN FND_API.G_EXC_ERROR
2645: THEN
2646: ROLLBACK TO add_funding_pub;
2647: p_return_status := FND_API.G_RET_STS_ERROR;
2648: FND_MSG_PUB.Count_And_Get
2649: ( p_count => p_msg_count ,
2650: p_data => p_msg_data );
2651:
2652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 2656: FND_MSG_PUB.Count_And_Get

2652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2653: THEN
2654: ROLLBACK TO add_funding_pub;
2655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2656: FND_MSG_PUB.Count_And_Get
2657: ( p_count => p_msg_count ,
2658: p_data => p_msg_data );
2659:
2660: WHEN OTHERS

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

2660: WHEN OTHERS
2661: THEN
2662: ROLLBACK TO add_funding_pub;
2663: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2665: THEN
2666: FND_MSG_PUB.add_exc_msg
2667: ( p_pkg_name => G_PKG_NAME
2668: , p_procedure_name => l_api_name );

Line 2666: FND_MSG_PUB.add_exc_msg

2662: ROLLBACK TO add_funding_pub;
2663: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2665: THEN
2666: FND_MSG_PUB.add_exc_msg
2667: ( p_pkg_name => G_PKG_NAME
2668: , p_procedure_name => l_api_name );
2669:
2670: END IF;

Line 2671: FND_MSG_PUB.Count_And_Get

2667: ( p_pkg_name => G_PKG_NAME
2668: , p_procedure_name => l_api_name );
2669:
2670: END IF;
2671: FND_MSG_PUB.Count_And_Get
2672: ( p_count => p_msg_count ,
2673: p_data => p_msg_data );
2674:
2675: END add_funding;

Line 2811: FND_MSG_PUB.initialize;

2807:
2808: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2809: THEN
2810:
2811: FND_MSG_PUB.initialize;
2812:
2813: END IF;
2814:
2815: -- Set API return status to success

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

2821: -- Product Code
2822: IF (p_pm_product_code IS NULL)
2823: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2824: THEN
2825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2826: THEN
2827: pa_interface_utils_pub.map_new_amg_msg
2828: ( p_old_message_code => 'PA_CUST_NUM_IS_MISS'
2829: ,p_msg_attribute => 'CHANGE'

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

2842: -- Funding Reference
2843: IF (p_pm_funding_reference IS NULL)
2844: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2845: THEN
2846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2847: THEN
2848: pa_interface_utils_pub.map_new_amg_msg
2849: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
2850: ,p_msg_attribute => 'CHANGE'

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

2864: -- Funding Id
2865: IF (p_funding_id IS NULL)
2866: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2867: THEN
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2869: THEN
2870: pa_interface_utils_pub.map_new_amg_msg
2871: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
2872: ,p_msg_attribute => 'CHANGE'

Line 2973: FND_MSG_PUB.Count_And_Get

2969: WHEN FND_API.G_EXC_ERROR
2970: THEN
2971: ROLLBACK TO delete_funding_pub;
2972: p_return_status := FND_API.G_RET_STS_ERROR;
2973: FND_MSG_PUB.Count_And_Get
2974: ( p_count => p_msg_count ,
2975: p_data => p_msg_data );
2976:
2977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 2981: FND_MSG_PUB.Count_And_Get

2977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2978: THEN
2979: ROLLBACK TO delete_funding_pub;
2980: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2981: FND_MSG_PUB.Count_And_Get
2982: ( p_count => p_msg_count ,
2983: p_data => p_msg_data );
2984:
2985: WHEN ROW_ALREADY_LOCKED

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

2985: WHEN ROW_ALREADY_LOCKED
2986: THEN
2987: ROLLBACK TO delete_funding_pub;
2988: p_return_status := FND_API.G_RET_STS_ERROR;
2989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2990: THEN
2991: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
2992: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
2993: FND_MSG_PUB.ADD;

Line 2993: FND_MSG_PUB.ADD;

2989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2990: THEN
2991: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
2992: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
2993: FND_MSG_PUB.ADD;
2994: END IF;
2995: FND_MSG_PUB.Count_And_Get
2996: ( p_count => p_msg_count ,
2997: p_data => p_msg_data );

Line 2995: FND_MSG_PUB.Count_And_Get

2991: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
2992: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
2993: FND_MSG_PUB.ADD;
2994: END IF;
2995: FND_MSG_PUB.Count_And_Get
2996: ( p_count => p_msg_count ,
2997: p_data => p_msg_data );
2998:
2999: WHEN OTHERS

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

2999: WHEN OTHERS
3000: THEN
3001: ROLLBACK TO delete_funding_pub;
3002: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3004: THEN
3005: FND_MSG_PUB.add_exc_msg
3006: ( p_pkg_name => G_PKG_NAME
3007: , p_procedure_name => l_api_name );

Line 3005: FND_MSG_PUB.add_exc_msg

3001: ROLLBACK TO delete_funding_pub;
3002: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3004: THEN
3005: FND_MSG_PUB.add_exc_msg
3006: ( p_pkg_name => G_PKG_NAME
3007: , p_procedure_name => l_api_name );
3008: END IF;
3009: FND_MSG_PUB.Count_And_Get

Line 3009: FND_MSG_PUB.Count_And_Get

3005: FND_MSG_PUB.add_exc_msg
3006: ( p_pkg_name => G_PKG_NAME
3007: , p_procedure_name => l_api_name );
3008: END IF;
3009: FND_MSG_PUB.Count_And_Get
3010: ( p_count => p_msg_count ,
3011: p_data => p_msg_data );
3012:
3013: END delete_funding;

Line 3168: FND_MSG_PUB.initialize;

3164:
3165: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3166: THEN
3167:
3168: FND_MSG_PUB.initialize;
3169:
3170: END IF;
3171:
3172: -- Set API return status to success

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

3178: -- Product Code
3179: IF (p_pm_product_code IS NULL)
3180: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3181: THEN
3182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3183: THEN
3184: pa_interface_utils_pub.map_new_amg_msg
3185: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
3186: ,p_msg_attribute => 'CHANGE'

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

3210: THEN
3211: l_funding_category := 'ADDITIONAL';
3212: ELSE
3213: l_funding_category := p_funding_category;
3214: /***** IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3215: THEN
3216: pa_interface_utils_pub.map_new_amg_msg
3217: ( p_old_message_code => 'PA_FUND_CAT_IS_MISS'
3218: ,p_msg_attribute => 'CHANGE'

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

3249: -- Funding Reference
3250: IF (p_pm_funding_reference IS NULL)
3251: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3252: THEN
3253: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3254: THEN
3255: pa_interface_utils_pub.map_new_amg_msg
3256: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
3257: ,p_msg_attribute => 'CHANGE'

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

3270: -- Funding Id
3271: IF (p_funding_id IS NULL)
3272: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3273: THEN
3274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3275: THEN
3276: pa_interface_utils_pub.map_new_amg_msg
3277: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
3278: ,p_msg_attribute => 'CHANGE'

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

3378: ,p_validate_status => l_validate_status
3379: );
3380: IF l_validate_status = 'N'
3381: THEN
3382: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3383: THEN
3384: pa_interface_utils_pub.map_new_amg_msg
3385: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
3386: ,p_msg_attribute => 'CHANGE'

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

3481:
3482:
3483: /* End - Bug 2902096 */
3484:
3485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3486: THEN
3487: pa_interface_utils_pub.map_new_amg_msg
3488: ( p_old_message_code => l_err_msg
3489: ,p_msg_attribute => 'CHANGE'

Line 3527: FND_MSG_PUB.Count_And_Get

3523: WHEN FND_API.G_EXC_ERROR
3524: THEN
3525: p_return_status := FND_API.G_RET_STS_ERROR ;
3526: ROLLBACK TO update_funding_pub;
3527: FND_MSG_PUB.Count_And_Get
3528: ( p_count => p_msg_count ,
3529: p_data => p_msg_data );
3530:
3531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3535: FND_MSG_PUB.Count_And_Get

3531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3532: THEN
3533: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3534: ROLLBACK TO update_funding_pub;
3535: FND_MSG_PUB.Count_And_Get
3536: ( p_count => p_msg_count ,
3537: p_data => p_msg_data );
3538:
3539: WHEN OTHERS

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

3539: WHEN OTHERS
3540: THEN
3541: ROLLBACK TO update_funding_pub;
3542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3544: THEN
3545: FND_MSG_PUB.add_exc_msg
3546: ( p_pkg_name => G_PKG_NAME
3547: , p_procedure_name => l_api_name );

Line 3545: FND_MSG_PUB.add_exc_msg

3541: ROLLBACK TO update_funding_pub;
3542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3544: THEN
3545: FND_MSG_PUB.add_exc_msg
3546: ( p_pkg_name => G_PKG_NAME
3547: , p_procedure_name => l_api_name );
3548: END IF;
3549: FND_MSG_PUB.Count_And_Get

Line 3549: FND_MSG_PUB.Count_And_Get

3545: FND_MSG_PUB.add_exc_msg
3546: ( p_pkg_name => G_PKG_NAME
3547: , p_procedure_name => l_api_name );
3548: END IF;
3549: FND_MSG_PUB.Count_And_Get
3550: ( p_count => p_msg_count ,
3551: p_data => p_msg_data );
3552:
3553: END update_funding;

Line 3736: FND_MSG_PUB.initialize;

3732:
3733: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3734: THEN
3735:
3736: FND_MSG_PUB.initialize;
3737:
3738: END IF;
3739:
3740: -- Set API return status to success

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

3813: THEN
3814: ROLLBACK TO load_agreement_pub;
3815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3816:
3817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3818: THEN
3819: FND_MSG_PUB.add_exc_msg
3820: ( p_pkg_name => G_PKG_NAME
3821: , p_procedure_name => l_api_name );

Line 3819: FND_MSG_PUB.add_exc_msg

3815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3816:
3817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3818: THEN
3819: FND_MSG_PUB.add_exc_msg
3820: ( p_pkg_name => G_PKG_NAME
3821: , p_procedure_name => l_api_name );
3822: END IF;
3823:

Line 3945: FND_MSG_PUB.initialize;

3941:
3942: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3943: THEN
3944:
3945: FND_MSG_PUB.initialize;
3946:
3947: END IF;
3948:
3949: -- Set API return status to success

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

3995: WHEN OTHERS
3996: THEN
3997: ROLLBACK TO load_funding_pub;
3998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4000: THEN
4001: FND_MSG_PUB.add_exc_msg
4002: ( p_pkg_name => G_PKG_NAME
4003: , p_procedure_name => l_api_name );

Line 4001: FND_MSG_PUB.add_exc_msg

3997: ROLLBACK TO load_funding_pub;
3998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4000: THEN
4001: FND_MSG_PUB.add_exc_msg
4002: ( p_pkg_name => G_PKG_NAME
4003: , p_procedure_name => l_api_name );
4004: END IF;
4005:

Line 4107: FND_MSG_PUB.initialize;

4103:
4104: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4105: THEN
4106:
4107: FND_MSG_PUB.initialize;
4108:
4109: END IF;
4110:
4111: -- Set API return status to success

Line 4165: FND_MSG_PUB.Count_And_Get

4161: WHEN FND_API.G_EXC_ERROR
4162: THEN
4163: ROLLBACK TO execute_create_agreement_pub;
4164: p_return_status := FND_API.G_RET_STS_ERROR;
4165: FND_MSG_PUB.Count_And_Get
4166: ( p_count => p_msg_count ,
4167: p_data => p_msg_data );
4168:
4169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 4173: FND_MSG_PUB.Count_And_Get

4169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4170: THEN
4171: ROLLBACK TO execute_create_agreement_pub;
4172: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4173: FND_MSG_PUB.Count_And_Get
4174: ( p_count => p_msg_count ,
4175: p_data => p_msg_data );
4176:
4177: WHEN OTHERS

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

4177: WHEN OTHERS
4178: THEN
4179: ROLLBACK TO execute_create_agreement_pub;
4180: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4182: THEN
4183: FND_MSG_PUB.add_exc_msg
4184: ( p_pkg_name => G_PKG_NAME
4185: , p_procedure_name => l_api_name );

Line 4183: FND_MSG_PUB.add_exc_msg

4179: ROLLBACK TO execute_create_agreement_pub;
4180: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4182: THEN
4183: FND_MSG_PUB.add_exc_msg
4184: ( p_pkg_name => G_PKG_NAME
4185: , p_procedure_name => l_api_name );
4186: END IF;
4187: FND_MSG_PUB.Count_And_Get

Line 4187: FND_MSG_PUB.Count_And_Get

4183: FND_MSG_PUB.add_exc_msg
4184: ( p_pkg_name => G_PKG_NAME
4185: , p_procedure_name => l_api_name );
4186: END IF;
4187: FND_MSG_PUB.Count_And_Get
4188: ( p_count => p_msg_count ,
4189: p_data => p_msg_data );
4190:
4191: END execute_create_agreement;

Line 4290: FND_MSG_PUB.initialize;

4286:
4287: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4288: THEN
4289:
4290: FND_MSG_PUB.initialize;
4291:
4292: END IF;
4293:
4294: -- Set API return status to success

Line 4332: FND_MSG_PUB.Count_And_Get

4328: WHEN FND_API.G_EXC_ERROR
4329: THEN
4330: ROLLBACK TO execute_update_agreement_pub;
4331: p_return_status := FND_API.G_RET_STS_ERROR;
4332: FND_MSG_PUB.Count_And_Get
4333: ( p_count => p_msg_count ,
4334: p_data => p_msg_data );
4335:
4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 4340: FND_MSG_PUB.Count_And_Get

4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4337: THEN
4338: ROLLBACK TO execute_update_agreement_pub;
4339: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4340: FND_MSG_PUB.Count_And_Get
4341: ( p_count => p_msg_count ,
4342: p_data => p_msg_data );
4343:
4344: WHEN OTHERS

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

4344: WHEN OTHERS
4345: THEN
4346: ROLLBACK TO execute_update_agreement_pub;
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4349: THEN
4350: FND_MSG_PUB.add_exc_msg
4351: ( p_pkg_name => G_PKG_NAME
4352: , p_procedure_name => l_api_name

Line 4350: FND_MSG_PUB.add_exc_msg

4346: ROLLBACK TO execute_update_agreement_pub;
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4349: THEN
4350: FND_MSG_PUB.add_exc_msg
4351: ( p_pkg_name => G_PKG_NAME
4352: , p_procedure_name => l_api_name
4353: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
4354: FND_MSG_PUB.add;

Line 4354: FND_MSG_PUB.add;

4350: FND_MSG_PUB.add_exc_msg
4351: ( p_pkg_name => G_PKG_NAME
4352: , p_procedure_name => l_api_name
4353: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
4354: FND_MSG_PUB.add;
4355: END IF;
4356: FND_MSG_PUB.Count_And_Get
4357: ( p_count => p_msg_count ,
4358: p_data => p_msg_data );

Line 4356: FND_MSG_PUB.Count_And_Get

4352: , p_procedure_name => l_api_name
4353: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
4354: FND_MSG_PUB.add;
4355: END IF;
4356: FND_MSG_PUB.Count_And_Get
4357: ( p_count => p_msg_count ,
4358: p_data => p_msg_data );
4359:
4360: END execute_update_agreement;

Line 4458: FND_MSG_PUB.initialize;

4454:
4455: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4456: THEN
4457:
4458: FND_MSG_PUB.initialize;
4459:
4460: END IF;
4461:
4462: -- Set API return status to success

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

4466: -- Check Funding index value, when they don't provide an index we will error out
4467: IF p_funding_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4468: OR p_funding_index IS NULL
4469: THEN
4470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4471: THEN
4472: pa_interface_utils_pub.map_new_amg_msg
4473: ( p_old_message_code => 'PA_FUND_INDEX_NOT_PROV'
4474: ,p_msg_attribute => 'CHANGE'

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

4513: WHEN OTHERS
4514: THEN
4515: ROLLBACK TO fetch_funding_pub;
4516: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4518: THEN
4519: FND_MSG_PUB.add_exc_msg
4520: ( p_pkg_name => G_PKG_NAME
4521: , p_procedure_name => l_api_name );

Line 4519: FND_MSG_PUB.add_exc_msg

4515: ROLLBACK TO fetch_funding_pub;
4516: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4518: THEN
4519: FND_MSG_PUB.add_exc_msg
4520: ( p_pkg_name => G_PKG_NAME
4521: , p_procedure_name => l_api_name );
4522: END IF;
4523:

Line 4660: FND_MSG_PUB.initialize;

4656:
4657: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4658: THEN
4659:
4660: FND_MSG_PUB.initialize;
4661:
4662: END IF;
4663:
4664: -- Set API return status to success

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

4671: -- Agreement Reference
4672: IF (p_pm_agreement_reference IS NULL)
4673: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4674: THEN
4675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4676: THEN
4677: pa_interface_utils_pub.map_new_amg_msg
4678: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
4679: ,p_msg_attribute => 'CHANGE'

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

4692: -- Agreement Id
4693: IF (p_agreement_id IS NULL)
4694: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4695: THEN
4696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4697: THEN
4698: pa_interface_utils_pub.map_new_amg_msg
4699: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
4700: ,p_msg_attribute => 'CHANGE'

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

4715: -- TO BE CORRECTED - NIKHIL
4716: -- Agreement Reference
4717: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
4718: THEN
4719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4720: THEN
4721: pa_interface_utils_pub.map_new_amg_msg
4722: ( p_old_message_code => 'PA_INVD_AGMT_REF'
4723: ,p_msg_attribute => 'CHANGE'

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

4736: /* NOT REQUIRED
4737: -- Agreement Id
4738: IF pa_agreement_utils.check_valid_agreement_id(p_agreement_id => p_agreement_id) = 'N'
4739: THEN
4740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4741: THEN
4742: pa_interface_utils_pub.map_new_amg_msg
4743: ( p_old_message_code => 'PA_INVD_AGMT_ID'
4744: ,p_msg_attribute => 'CHANGE'

Line 4794: FND_MSG_PUB.Count_And_Get

4790: WHEN FND_API.G_EXC_ERROR
4791: THEN
4792: ROLLBACK TO check_delete_agreement_ok_pub;
4793: p_return_status := FND_API.G_RET_STS_ERROR;
4794: FND_MSG_PUB.Count_And_Get
4795: ( p_count => p_msg_count ,
4796: p_data => p_msg_data );
4797:
4798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 4802: FND_MSG_PUB.Count_And_Get

4798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4799: THEN
4800: ROLLBACK TO check_delete_agreement_ok_pub;
4801: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4802: FND_MSG_PUB.Count_And_Get
4803: ( p_count => p_msg_count ,
4804: p_data => p_msg_data );
4805:
4806: WHEN OTHERS

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

4806: WHEN OTHERS
4807: THEN
4808: ROLLBACK TO check_delete_agreement_ok_pub;
4809: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4810: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4811: THEN
4812: FND_MSG_PUB.add_exc_msg
4813: ( p_pkg_name => G_PKG_NAME
4814: , p_procedure_name => l_api_name );

Line 4812: FND_MSG_PUB.add_exc_msg

4808: ROLLBACK TO check_delete_agreement_ok_pub;
4809: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4810: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4811: THEN
4812: FND_MSG_PUB.add_exc_msg
4813: ( p_pkg_name => G_PKG_NAME
4814: , p_procedure_name => l_api_name );
4815:
4816: END IF;

Line 4817: FND_MSG_PUB.Count_And_Get

4813: ( p_pkg_name => G_PKG_NAME
4814: , p_procedure_name => l_api_name );
4815:
4816: END IF;
4817: FND_MSG_PUB.Count_And_Get
4818: ( p_count => p_msg_count ,
4819: p_data => p_msg_data );
4820:
4821:

Line 4940: FND_MSG_PUB.initialize;

4936:
4937: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4938: THEN
4939:
4940: FND_MSG_PUB.initialize;
4941:
4942: END IF;
4943:
4944: -- Set API return status to success

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

4950: -- Agreement Reference
4951: IF (p_pm_agreement_reference IS NULL)
4952: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4953: THEN
4954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4955: THEN
4956: pa_interface_utils_pub.map_new_amg_msg
4957: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
4958: ,p_msg_attribute => 'CHANGE'

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

4971: -- Project Id
4972: IF (p_project_id IS NULL)
4973: OR (p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4974: THEN
4975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4976: THEN
4977: pa_interface_utils_pub.map_new_amg_msg
4978: ( p_old_message_code => 'PA_PROJ_ID_IS_MISS'
4979: ,p_msg_attribute => 'CHANGE'

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

4992: -- Task Id
4993: IF (p_task_id IS NULL)
4994: OR (p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4995: THEN
4996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4997: THEN
4998: pa_interface_utils_pub.map_new_amg_msg
4999: ( p_old_message_code => 'PA_TASK_ID_IS_MISS'
5000: ,p_msg_attribute => 'CHANGE'

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

5013: -- Funding Reference
5014: IF (p_pm_funding_reference IS NULL)
5015: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5016: THEN
5017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5018: THEN
5019: pa_interface_utils_pub.map_new_amg_msg
5020: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5021: ,p_msg_attribute => 'CHANGE'

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

5035: -- Funding Id
5036: IF (p_funding_id IS NULL)
5037: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5038: THEN
5039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5040: THEN
5041: pa_interface_utils_pub.map_new_amg_msg
5042: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5043: ,p_msg_attribute => 'CHANGE'

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

5059: --TO BE CORRECTED - NIKHIL
5060: -- Agreement Reference
5061: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
5062: THEN
5063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5064: THEN
5065: pa_interface_utils_pub.map_new_amg_msg
5066: ( p_old_message_code => 'PA_INVD_AGMT_REF'
5067: ,p_msg_attribute => 'CHANGE'

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

5080: -- Funding Reference
5081: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5082: ,p_agreement_id => p_agreement_id) = 'N'
5083: THEN
5084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5085: THEN
5086: pa_interface_utils_pub.map_new_amg_msg
5087: ( p_old_message_code => 'PA_INVD_FUND_REF'
5088: ,p_msg_attribute => 'CHANGE'

Line 5156: FND_MSG_PUB.Count_And_Get

5152: WHEN FND_API.G_EXC_ERROR
5153: THEN
5154: ROLLBACK TO check_add_funding_ok_pub;
5155: p_return_status := FND_API.G_RET_STS_ERROR;
5156: FND_MSG_PUB.Count_And_Get
5157: ( p_count => p_msg_count ,
5158: p_data => p_msg_data );
5159:
5160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 5164: FND_MSG_PUB.Count_And_Get

5160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
5161: THEN
5162: ROLLBACK TO check_add_funding_ok_pub;
5163: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5164: FND_MSG_PUB.Count_And_Get
5165: ( p_count => p_msg_count ,
5166: p_data => p_msg_data );
5167:
5168: WHEN OTHERS

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

5168: WHEN OTHERS
5169: THEN
5170: ROLLBACK TO check_add_funding_ok_pub;
5171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5172: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5173: THEN
5174: FND_MSG_PUB.add_exc_msg
5175: ( p_pkg_name => G_PKG_NAME
5176: , p_procedure_name => l_api_name );

Line 5174: FND_MSG_PUB.add_exc_msg

5170: ROLLBACK TO check_add_funding_ok_pub;
5171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5172: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5173: THEN
5174: FND_MSG_PUB.add_exc_msg
5175: ( p_pkg_name => G_PKG_NAME
5176: , p_procedure_name => l_api_name );
5177:
5178: END IF;

Line 5179: FND_MSG_PUB.Count_And_Get

5175: ( p_pkg_name => G_PKG_NAME
5176: , p_procedure_name => l_api_name );
5177:
5178: END IF;
5179: FND_MSG_PUB.Count_And_Get
5180: ( p_count => p_msg_count ,
5181: p_data => p_msg_data );
5182:
5183:

Line 5295: FND_MSG_PUB.initialize;

5291:
5292: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5293: THEN
5294:
5295: FND_MSG_PUB.initialize;
5296:
5297: END IF;
5298:
5299: -- Set API return status to success

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

5305: -- Funding Reference
5306: IF (p_pm_funding_reference IS NULL)
5307: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5308: THEN
5309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5310: THEN
5311: pa_interface_utils_pub.map_new_amg_msg
5312: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5313: ,p_msg_attribute => 'CHANGE'

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

5326: -- Funding Id
5327: IF (p_funding_id IS NULL)
5328: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5329: THEN
5330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5331: THEN
5332: pa_interface_utils_pub.map_new_amg_msg
5333: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5334: ,p_msg_attribute => 'CHANGE'

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

5352: (p_funding_reference => p_pm_funding_reference
5353: ,p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5354: ,p_funding_reference => p_pm_funding_reference)) = 'N'
5355: THEN
5356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5357: THEN
5358: pa_interface_utils_pub.map_new_amg_msg
5359: ( p_old_message_code => 'PA_INVD_FUND_REF'
5360: ,p_msg_attribute => 'CHANGE'

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

5374: IF pa_agreement_utils.check_valid_funding_id(p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5375: ,p_funding_reference => p_pm_funding_reference)
5376: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'
5377: THEN
5378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5379: THEN
5380: pa_interface_utils_pub.map_new_amg_msg
5381: ( p_old_message_code => 'PA_INVD_FUND_ID'
5382: ,p_msg_attribute => 'CHANGE'

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

5428: ROLLBACK TO check_delete_funding_ok_pub;
5429:
5430: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5431:
5432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5433: THEN
5434: FND_MSG_PUB.add_exc_msg
5435: ( p_pkg_name => G_PKG_NAME
5436: , p_procedure_name => l_api_name );

Line 5434: FND_MSG_PUB.add_exc_msg

5430: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5431:
5432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5433: THEN
5434: FND_MSG_PUB.add_exc_msg
5435: ( p_pkg_name => G_PKG_NAME
5436: , p_procedure_name => l_api_name );
5437:
5438: END IF;

Line 5577: FND_MSG_PUB.initialize;

5573:
5574: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5575: THEN
5576:
5577: FND_MSG_PUB.initialize;
5578:
5579: END IF;
5580:
5581: -- Set API return status to success

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

5587: -- Funding Reference
5588: IF (p_pm_funding_reference IS NULL)
5589: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5590: THEN
5591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5592: THEN
5593: pa_interface_utils_pub.map_new_amg_msg
5594: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5595: ,p_msg_attribute => 'CHANGE'

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

5608: -- Funding Id
5609: IF (p_funding_id IS NULL)
5610: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5611: THEN
5612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5613: THEN
5614: pa_interface_utils_pub.map_new_amg_msg
5615: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5616: ,p_msg_attribute => 'CHANGE'

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

5631: -- Funding Reference
5632: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5633: ,p_agreement_id => p_agreement_id) = 'N'
5634: THEN
5635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5636: THEN
5637: pa_interface_utils_pub.map_new_amg_msg
5638: ( p_old_message_code => 'PA_INVD_FUND_REF'
5639: ,p_msg_attribute => 'CHANGE'

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

5652: -- Agreement Id
5653: IF pa_agreement_utils.check_valid_agreement_id
5654: (p_agreement_id => p_agreement_id) = 'N'
5655: THEN
5656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5657: THEN
5658: pa_interface_utils_pub.map_new_amg_msg
5659: ( p_old_message_code => 'PA_INVALID_FUNDING_ID'
5660: ,p_msg_attribute => 'CHANGE'

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

5689: ,p_validate_status => l_validate_status
5690: );
5691: IF l_validate_status = 'N'
5692: THEN
5693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5694: THEN
5695: pa_interface_utils_pub.map_new_amg_msg
5696: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
5697: ,p_msg_attribute => 'CHANGE'

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

5754: ROLLBACK TO check_update_funding_ok_pub;
5755:
5756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5757:
5758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5759: THEN
5760: FND_MSG_PUB.add_exc_msg
5761: ( p_pkg_name => G_PKG_NAME
5762: , p_procedure_name => l_api_name );

Line 5760: FND_MSG_PUB.add_exc_msg

5756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5757:
5758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5759: THEN
5760: FND_MSG_PUB.add_exc_msg
5761: ( p_pkg_name => G_PKG_NAME
5762: , p_procedure_name => l_api_name );
5763:
5764: END IF;

Line 5934: FND_MSG_PUB.initialize;

5930: -- Standard call to check for call compatibility.
5931: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5932: THEN
5933:
5934: FND_MSG_PUB.initialize;
5935:
5936: END IF;
5937:
5938:

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

5967:
5968: IF (PA_FUNDING_CORE.CHECK_PROJECT_TYPE(l_project_id)) = 'N' THEN
5969: p_return_status := FND_API.G_RET_STS_ERROR;
5970:
5971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5972: THEN
5973: pa_interface_utils_pub.map_new_amg_msg
5974: ( p_old_message_code => 'PA_INVALID_PROJECT'
5975: ,p_msg_attribute => 'CHANGE'

Line 6220: FND_MSG_PUB.Count_And_Get

6216: WHEN FND_API.G_EXC_ERROR
6217: THEN
6218: ROLLBACK TO Create_Budget_From_funding;
6219: p_return_status := FND_API.G_RET_STS_ERROR;
6220: FND_MSG_PUB.Count_And_Get
6221: ( p_count => p_msg_count ,
6222: p_data => p_msg_data );
6223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
6224: THEN

Line 6227: FND_MSG_PUB.Count_And_Get

6223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
6224: THEN
6225: ROLLBACK TO Create_Budget_From_funding;
6226: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6227: FND_MSG_PUB.Count_And_Get
6228: ( p_count => p_msg_count ,
6229: p_data => p_msg_data );
6230:
6231: WHEN OTHERS

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

6231: WHEN OTHERS
6232: THEN
6233: ROLLBACK TO Create_Budget_From_funding;
6234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6236: THEN
6237: FND_MSG_PUB.add_exc_msg
6238: ( p_pkg_name => G_PKG_NAME
6239: , p_procedure_name => l_api_name );

Line 6237: FND_MSG_PUB.add_exc_msg

6233: ROLLBACK TO Create_Budget_From_funding;
6234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6236: THEN
6237: FND_MSG_PUB.add_exc_msg
6238: ( p_pkg_name => G_PKG_NAME
6239: , p_procedure_name => l_api_name );
6240:
6241: END IF;

Line 6242: FND_MSG_PUB.Count_And_Get

6238: ( p_pkg_name => G_PKG_NAME
6239: , p_procedure_name => l_api_name );
6240:
6241: END IF;
6242: FND_MSG_PUB.Count_And_Get
6243: ( p_count => p_msg_count ,
6244: p_data => p_msg_data );
6245:
6246: