[Home] [Help]
164: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
165: THEN
166: IF (p_pm_product_code IS NOT NULL AND p_function_name <> 'PA_EV_UPDATE_EVENT') /* Added for bug 5056969 */
167: THEN
168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
169: THEN
170: pa_interface_utils_pub.map_new_amg_msg
171: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
172: ,p_msg_attribute => 'CHANGE'
187: Close ProductCode_cur;
188:
189: If l_product_code Is NULL
190: Then
191: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
192: THEN
193: pa_interface_utils_pub.map_new_amg_msg
194: ( p_old_message_code => 'PA_INVALID_PRODUCT_CODE'
195: ,p_msg_attribute => 'CHANGE'
287:
288: IF (p_pm_event_reference IS NULL
289: OR p_pm_event_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
290: THEN
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
292: THEN
293: pa_interface_utils_pub.map_new_amg_msg
294: ( p_old_message_code =>'PA_EVENT_REF_IS_MISS'
295: ,p_msg_attribute => 'CHANGE'
327: If PA_EVENT_PVT.CHECK_EVENT_REF_UNQ
328: (P_pm_product_code =>P_pm_product_code
329: ,P_pm_event_reference =>P_pm_event_reference)='N'
330: Then
331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
332: THEN
333: pa_interface_utils_pub.map_new_amg_msg
334: ( p_old_message_code => 'PA_EVENT_REF_IS_NOT_UNQ'
335: ,p_msg_attribute => 'CHANGE'
354:
355: IF (p_project_number IS NULL
356: OR p_project_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
357: THEN
358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
359: THEN
360: pa_interface_utils_pub.map_new_amg_msg
361: ( p_old_message_code => 'PA_PROJ_NUM_IS_MISS'
362: ,p_msg_attribute => 'CHANGE'
380:
381: IF (p_event_type IS NULL
382: OR p_event_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
383: THEN
384: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
385: THEN
386: pa_interface_utils_pub.map_new_amg_msg
387: ( p_old_message_code => 'PA_EVNT_TYPE_IS_MISS'
388: ,p_msg_attribute => 'CHANGE'
406:
407: IF (p_organization_name IS NULL
408: OR p_organization_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
409: THEN
410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
411: THEN
412: pa_interface_utils_pub.map_new_amg_msg
413: ( p_old_message_code => 'PA_EVNT_ORG_IS_MISS'
414: ,p_msg_attribute => 'CHANGE'
539: (P_project_id =>P_project_id
540: ,P_task_id =>x_task_id
541: ,P_task_num =>P_event_in_rec.P_task_number)='N'
542: Then
543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
544: THEN
545: pa_interface_utils_pub.map_new_amg_msg
546: ( p_old_message_code => 'PA_INVALID_TOP_TASK'
547: ,p_msg_attribute => 'CHANGE'
570: If PA_EVENT_UTILS.check_funding
571: (P_project_id =>P_project_id
572: ,P_task_id =>x_task_id)='N'
573: Then
574: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
575: THEN
576: pa_interface_utils_pub.map_new_amg_msg
577: ( p_old_message_code => 'PA_TASK_FUND_NO_PROJ_EVENT'
578: ,p_msg_attribute => 'CHANGE'
608: ,P_agreement_type => P_event_in_rec.P_agreement_type
609: ,P_customer_number => P_event_in_rec.P_customer_number
610: ,P_agreement_id => x_agreement_id ) ='N'
611: Then
612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
613: THEN
614: pa_interface_utils_pub.map_new_amg_msg
615: ( p_old_message_code => 'PA_INVALID_AGMT_NUM'
616: ,p_msg_attribute => 'CHANGE'
641: If PA_EVENT_UTILS.CHECK_VALID_EVENT_DATE (
642: P_event_date => P_event_in_rec.P_completion_date
643: ,P_agreement_id => x_agreement_id ) ='N'
644: Then
645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
646: THEN
647: pa_interface_utils_pub.map_new_amg_msg
648: ( p_old_message_code => 'PA_INVALID_EVENT_DATE'
649: ,p_msg_attribute => 'CHANGE'
672: Then
673: IF (P_event_in_rec.P_deliverable_id IS NULL OR
674: P_event_in_rec.P_deliverable_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
675: Then
676: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
677: THEN
678: pa_interface_utils_pub.map_new_amg_msg
679: ( p_old_message_code => 'PA_EV_DLV_ID_MISS'
680: ,p_msg_attribute => 'CHANGE'
691:
692: IF (P_event_in_rec.P_action_id IS NULL OR
693: P_event_in_rec.P_action_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
694: Then
695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
696: THEN
697: pa_interface_utils_pub.map_new_amg_msg
698: ( p_old_message_code => 'PA_EV_ACT_ID_MISS'
699: ,p_msg_attribute => 'CHANGE'
714: (P_event_type =>P_event_in_rec.P_event_type
715: ,P_context =>P_event_in_rec.P_context
716: ,X_event_type_classification =>p_event_type_classification)='N'
717: Then
718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
719: THEN
720: pa_interface_utils_pub.map_new_amg_msg
721: ( p_old_message_code => 'PA_INVALID_EVNT_TYPE'
722: ,p_msg_attribute => 'CHANGE'
828: If PA_EVENT_UTILS.check_valid_event_org
829: (P_event_org_name =>p_event_in_rec.P_organization_name
830: ,P_event_org_id =>x_Organization_Id)='N'
831: Then
832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
833: THEN
834: pa_interface_utils_pub.map_new_amg_msg
835: ( p_old_message_code => 'PA_INVALID_EVNT_ORG'
836: ,p_msg_attribute => 'CHANGE'
871: l_proj_func_currency_code:=P_proj_func_currency_code;
872: ElsIf PA_EVENT_UTILS.check_valid_curr
873: (P_bill_trans_curr =>p_event_in_rec.P_bill_trans_currency_code)='N'
874: Then
875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
876: THEN
877: pa_interface_utils_pub.map_new_amg_msg
878: (p_old_message_code => 'PA_INVALID_BIL_TRX_CUR'
879: ,p_msg_attribute => 'CHANGE'
905: If PA_EVENT_UTILS.check_valid_fund_rate_type
906: (P_fund_rate_type =>P_event_in_rec.P_funding_rate_type,
907: x_fund_rate_type =>l_funding_rate_type)='N'
908: Then
909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
910: THEN
911: pa_interface_utils_pub.map_new_amg_msg
912: ( p_old_message_code => 'PA_FUND_RATE_TYPE_INV'
913: ,p_msg_attribute => 'CHANGE'
936: AND ( p_event_in_rec.P_funding_exchange_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
937: OR p_event_in_rec.P_funding_exchange_rate Is NULL ))
938: OR p_event_in_rec.P_funding_exchange_rate <= 0)
939: Then
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
941: THEN
942: pa_interface_utils_pub.map_new_amg_msg
943: ( p_old_message_code => 'PA_FUND_EXCG_RATE_INV'
944: ,p_msg_attribute => 'CHANGE'
959: AND NVL(UPPER(P_event_in_rec.P_funding_rate_type),'USER') <>'USER'
960: AND (P_event_in_rec.P_funding_rate_date IS NULL
961: OR P_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
962: THEN
963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
964: THEN
965: pa_interface_utils_pub.map_new_amg_msg
966: ( p_old_message_code => 'PA_INVALID_FUND_DATE'
967: ,p_msg_attribute => 'CHANGE'
1007: ,P_event_date =>NVL(P_event_in_rec.p_completion_date,SYSDATE)
1008: ,x_proj_rate_type =>l_project_rate_type
1009: ) ='N'
1010: Then
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1012: THEN
1013: pa_interface_utils_pub.map_new_amg_msg
1014: ( p_old_message_code => 'PA_PROJ_RATE_TYPE_INV'
1015: ,p_msg_attribute => 'CHANGE'
1042: AND ( p_event_in_rec.P_project_exchange_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1043: OR p_event_in_rec.P_project_exchange_rate Is NULL))
1044: OR p_event_in_rec.P_project_exchange_rate <= 0)
1045: Then
1046: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1047: THEN
1048: pa_interface_utils_pub.map_new_amg_msg
1049: ( p_old_message_code => 'PA_PROJ_EXCG_RATE_INV'
1050: ,p_msg_attribute => 'CHANGE'
1065: AND NVL(UPPER(P_event_in_rec.P_project_rate_type),'USER') <>'USER'
1066: AND (P_event_in_rec.P_project_rate_date IS NULL
1067: OR P_event_in_rec.P_project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
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_INVALID_PROJ_DATE'
1073: ,p_msg_attribute => 'CHANGE'
1112: ,x_pfc_rate_type =>l_projfunc_rate_type
1113: )
1114: ='N'
1115: Then
1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1117: THEN
1118: pa_interface_utils_pub.map_new_amg_msg
1119: ( p_old_message_code =>'PA_PFC_RATE_TYPE_INV'
1120: ,p_msg_attribute => 'CHANGE'
1147: AND (p_event_in_rec.P_projfunc_exchange_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1148: OR p_event_in_rec.P_projfunc_exchange_rate Is NULL ))
1149: OR p_event_in_rec.P_projfunc_exchange_rate <= 0)
1150: Then
1151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1152: THEN
1153: pa_interface_utils_pub.map_new_amg_msg
1154: ( p_old_message_code => 'PA_PFC_EXCG_RATE_INV'
1155: ,p_msg_attribute => 'CHANGE'
1170: AND NVL(UPPER(P_event_in_rec.P_projfunc_rate_type),'USER') <>'USER'
1171: AND (P_event_in_rec.P_projfunc_rate_date IS NULL
1172: OR P_event_in_rec.P_projfunc_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1173: THEN
1174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1175: THEN
1176: pa_interface_utils_pub.map_new_amg_msg
1177: ( p_old_message_code => 'PA_INVALID_PROJFUNC_DATE'
1178: ,p_msg_attribute => 'CHANGE'
1193: l_proj_func_currency_code:=P_proj_func_currency_code;
1194:
1195: ElsIf (p_event_in_rec.P_bill_trans_currency_code <> P_proj_func_currency_code)
1196: Then
1197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1198: THEN
1199: pa_interface_utils_pub.map_new_amg_msg
1200: -- (p_old_message_code => 'PA_INVALID_BIL_TRX_CUR' -- Commented for Bug#3013172
1201: (p_old_message_code => 'PA_EVENT_NON_MCB_OPTION' -- Modified the message code for Bug#3013172
1227: AND p_event_in_rec.P_adjusting_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1228: AND PA_EVENT_PVT.CHECK_YES_NO
1229: (P_flag =>P_event_in_rec.P_adjusting_revenue_flag)='N')
1230: Then
1231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1232: THEN
1233: pa_interface_utils_pub.map_new_amg_msg
1234: ( p_old_message_code =>'PA_INVALID_ADJ_REV_FLG'
1235: ,p_msg_attribute => 'CHANGE'
1246: Then
1247: If (p_event_type_classification Is NULL
1248: OR p_event_type_classification <> 'MANUAL')
1249: Then
1250: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1251: THEN
1252: pa_interface_utils_pub.map_new_amg_msg
1253: ( p_old_message_code =>'PA_INV_EV_TYP_ADJ_REV'
1254: ,p_msg_attribute => 'CHANGE'
1279: If PA_EVENT_UTILS.CHECK_VALID_REV_AMT
1280: (P_event_type_classification =>P_event_type_classification
1281: ,P_rev_amt =>p_event_in_rec.P_bill_trans_rev_amount)='N'
1282: Then
1283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1284: THEN
1285: pa_interface_utils_pub.map_new_amg_msg
1286: ( p_old_message_code => 'PA_PR_EPR_REV_GT_ZERO'
1287: ,p_msg_attribute => 'CHANGE'
1320: If l_ret_status <> 'Y'
1321: Then
1322: If l_ret_status = 'N'
1323: Then
1324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326: pa_interface_utils_pub.map_new_amg_msg
1327: ( p_old_message_code =>'PA_TK_EXCESS_REV'
1328: ,p_msg_attribute => 'CHANGE'
1335: ,p_attribute5 => '');
1336: END IF;
1337: l_return_status:='N';
1338: Else
1339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1340: THEN
1341: pa_interface_utils_pub.map_new_amg_msg
1342: ( p_old_message_code =>l_ret_status
1343: ,p_msg_attribute => 'CHANGE'
1356: ElsIf (p_event_type_classification In('MANUAL','WRITE ON','WRITE OFF')
1357: AND (p_event_in_rec.P_bill_trans_rev_amount Is NULL
1358: OR p_event_in_rec.P_bill_trans_rev_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1359: Then
1360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1361: THEN
1362: pa_interface_utils_pub.map_new_amg_msg
1363: ( p_old_message_code => 'PA_INVALID_REV_AMT'
1364: ,p_msg_attribute => 'CHANGE'
1384: If PA_EVENT_UTILS.CHECK_VALID_BILL_AMT
1385: (P_event_type_classification =>P_event_type_classification
1386: ,P_bill_amt =>p_event_in_rec.P_bill_trans_bill_amount)='N'
1387: Then
1388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1389: THEN
1390: pa_interface_utils_pub.map_new_amg_msg
1391: ( p_old_message_code => 'PA_PR_EPR_BILL_GT_ZERO'
1392: ,p_msg_attribute => 'CHANGE'
1402: ElsIf (p_event_type_classification In('MANUAL','DEFERRED REVENUE','INVOICE REDUCTION','SCHEDULED PAYMENTS')
1403: AND (p_event_in_rec.P_bill_trans_bill_amount Is NULL
1404: OR p_event_in_rec.P_bill_trans_bill_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1405: Then
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1407: THEN
1408: pa_interface_utils_pub.map_new_amg_msg
1409: ( p_old_message_code => 'PA_INVALID_BILL_AMT'
1410: ,p_msg_attribute => 'CHANGE'
1432: AND p_event_in_rec.P_bill_hold_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1433: Then
1434: If (upper(p_event_in_rec.P_bill_hold_flag) NOT In('Y','N','O'))
1435: Then
1436: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1437: THEN
1438: pa_interface_utils_pub.map_new_amg_msg
1439: ( p_old_message_code => 'PA_INVALID_BIL_HLD_FLG'
1440: ,p_msg_attribute => 'CHANGE'
1464: (P_project_id =>P_project_id
1465: ,P_task_id =>x_task_id
1466: ,P_event_num =>p_event_in_rec.P_event_number)='N')
1467: Then
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1469: THEN
1470: pa_interface_utils_pub.map_new_amg_msg
1471: ( p_old_message_code => 'PA_INV_EVNT_NUM'
1472: ,p_msg_attribute => 'CHANGE'
1495: AND PA_EVENT_UTILS.CHECK_VALID_INV_ORG
1496: (P_inv_org_name =>p_event_in_rec.P_inventory_org_name
1497: ,P_inv_org_id =>x_inv_org_id)='N')
1498: Then
1499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1500: THEN
1501: pa_interface_utils_pub.map_new_amg_msg
1502: ( p_old_message_code => 'PA_INV_INVT_ORG_NAME'
1503: ,p_msg_attribute => 'CHANGE'
1524: AND p_event_in_rec.P_inventory_item_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1525: AND PA_EVENT_UTILS.CHECK_VALID_INV_ITEM
1526: (P_inv_item_id =>p_event_in_rec.P_inventory_item_id)='N')
1527: Then
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1529: THEN
1530: pa_interface_utils_pub.map_new_amg_msg
1531: ( p_old_message_code => 'PA_INV_INVT_ITEM'
1532: ,p_msg_attribute => 'CHANGE'
1687: EXCEPTION
1688:
1689: WHEN NO_DATA_FOUND THEN
1690:
1691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1692: THEN
1693: pa_interface_utils_pub.map_new_amg_msg
1694: ( p_old_message_code => 'PA_EVENT_IN_DELV_UPD'
1695: ,p_msg_attribute => 'CHANGE'
1705: Return(l_return_status);
1706: END;
1707: ElsIf l_event_processed = 'N'
1708: Then
1709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1710: THEN
1711: pa_interface_utils_pub.map_new_amg_msg
1712: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
1713: ,p_msg_attribute => 'CHANGE'
1736:
1737: /*The following code is added for bug 3205120 */
1738: ELSIF l_event_processed = 'P'
1739: THEN
1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1741: THEN
1742: pa_interface_utils_pub.map_new_amg_msg
1743: ( p_old_message_code => 'PA_EVENT_PARTIAL_BILL'
1744: ,p_msg_attribute => 'CHANGE'
1791: P_event_in_rec.P_funding_rate_date IS NOT NULL OR
1792: P_event_in_rec.P_funding_exchange_rate IS NOT NULL OR
1793: P_event_in_rec.P_adjusting_revenue_flag IS NOT NULL ) THEN
1794:
1795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1796: THEN
1797: pa_interface_utils_pub.map_new_amg_msg
1798: ( p_old_message_code => 'PA_EVENT_CANCEL_UPD'
1799: ,p_msg_attribute => 'CHANGE'
1827: (P_project_id =>P_project_id
1828: ,P_task_id =>x_task_id
1829: ,P_task_num =>P_event_in_rec.P_task_number)='N'
1830: Then
1831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1832: THEN
1833: pa_interface_utils_pub.map_new_amg_msg
1834: ( p_old_message_code => 'PA_INVALID_TOP_TASK'
1835: ,p_msg_attribute => 'CHANGE'
1863: If PA_EVENT_UTILS.CHECK_FUNDING
1864: (P_project_id =>P_project_id
1865: ,P_task_id =>x_task_id)='N'
1866: Then
1867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1868: THEN
1869: pa_interface_utils_pub.map_new_amg_msg
1870: ( p_old_message_code => 'PA_TASK_FUND_NO_PROJ_EVENT'
1871: ,p_msg_attribute => 'CHANGE'
1914: ,P_agreement_type => P_event_in_rec.P_agreement_type
1915: ,P_customer_number => P_event_in_rec.P_customer_number
1916: ,P_agreement_id => x_agreement_id ) ='N'
1917: Then
1918: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1919: THEN
1920: pa_interface_utils_pub.map_new_amg_msg
1921: ( p_old_message_code => 'PA_INVALID_AGMT_NUM'
1922: ,p_msg_attribute => 'CHANGE'
1958: If PA_EVENT_UTILS.CHECK_VALID_EVENT_DATE (
1959: P_event_date => l_event_date
1960: ,P_agreement_id => x_agreement_id ) ='N'
1961: Then
1962: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1963: THEN
1964: pa_interface_utils_pub.map_new_amg_msg
1965: ( p_old_message_code => 'PA_INVALID_EVENT_DATE'
1966: ,p_msg_attribute => 'CHANGE'
1994: (P_event_type =>P_event_in_rec.P_event_type
1995: ,P_context =>P_event_in_rec.P_context
1996: ,X_event_type_classification =>p_event_type_classification)='N'
1997: Then
1998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1999: THEN
2000: pa_interface_utils_pub.map_new_amg_msg
2001: (p_old_message_code => 'PA_INVALID_EVNT_TYPE'
2002: ,p_msg_attribute => 'CHANGE'
2124: AND PA_EVENT_UTILS.CHECK_VALID_EVENT_ORG
2125: (P_event_org_name =>p_event_in_rec.P_organization_name
2126: ,P_event_org_id =>x_Organization_Id)='N')
2127: Then
2128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2129: THEN
2130: pa_interface_utils_pub.map_new_amg_msg
2131: ( p_old_message_code => 'PA_INVALID_EVNT_ORG'
2132: ,p_msg_attribute => 'CHANGE'
2203:
2204: ElsIf PA_EVENT_UTILS.CHECK_VALID_CURR
2205: (P_bill_trans_curr =>p_event_in_rec.P_bill_trans_currency_code)='N'
2206: Then
2207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2208: THEN
2209: pa_interface_utils_pub.map_new_amg_msg
2210: (p_old_message_code => 'PA_INVALID_BIL_TRX_CUR'
2211: ,p_msg_attribute => 'CHANGE'
2239: (P_fund_rate_type =>P_event_in_rec.P_funding_rate_type
2240: ,x_fund_rate_type =>l_funding_rate_type)='N'
2241:
2242: Then
2243: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2244: THEN
2245: pa_interface_utils_pub.map_new_amg_msg
2246: ( p_old_message_code => 'PA_FUND_RATE_TYPE_INV'
2247: ,p_msg_attribute => 'CHANGE'
2266: AND ( p_event_in_rec.P_funding_exchange_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2267: OR p_event_in_rec.P_funding_exchange_rate Is NULL ))
2268: OR p_event_in_rec.P_funding_exchange_rate <=0 )
2269: Then
2270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2271: THEN
2272: pa_interface_utils_pub.map_new_amg_msg
2273: ( p_old_message_code => 'PA_FUND_EXCG_RATE_INV'
2274: ,p_msg_attribute => 'CHANGE'
2289: AND UPPER(P_funding_rate_type) ='USER'
2290: AND NVL(UPPER(P_event_in_rec.P_funding_rate_type),'USER') <>'USER'
2291: AND l_check_funding_rate_date IS NULL )
2292: THEN
2293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2294: THEN
2295: pa_interface_utils_pub.map_new_amg_msg
2296: ( p_old_message_code => 'PA_INVALID_FUND_DATE'
2297: ,p_msg_attribute => 'CHANGE'
2340: ,x_proj_rate_type =>l_project_rate_type
2341: ) ='N'
2342:
2343: Then
2344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2345: THEN
2346: pa_interface_utils_pub.map_new_amg_msg
2347: ( p_old_message_code => 'PA_PROJ_RATE_TYPE_INV'
2348: ,p_msg_attribute => 'CHANGE'
2375: AND ( p_event_in_rec.P_project_exchange_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2376: OR p_event_in_rec.P_project_exchange_rate Is NULL))
2377: OR p_event_in_rec.P_project_exchange_rate <= 0)
2378: Then
2379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2380: THEN
2381: pa_interface_utils_pub.map_new_amg_msg
2382: ( p_old_message_code => 'PA_PROJ_EXCG_RATE_INV'
2383: ,p_msg_attribute => 'CHANGE'
2397: AND UPPER(P_project_rate_type) ='USER'
2398: AND NVL(UPPER(P_event_in_rec.P_project_rate_type),'USER') <>'USER'
2399: AND l_check_project_rate_date IS NULL)
2400: THEN
2401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2402: THEN
2403: pa_interface_utils_pub.map_new_amg_msg
2404: ( p_old_message_code => 'PA_INVALID_PROJ_DATE'
2405: ,p_msg_attribute => 'CHANGE'
2447: )
2448: ='N'
2449:
2450: Then
2451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2452: THEN
2453: pa_interface_utils_pub.map_new_amg_msg
2454: ( p_old_message_code =>'PA_PFC_RATE_TYPE_INV'
2455: ,p_msg_attribute => 'CHANGE'
2482: AND (p_event_in_rec.P_projfunc_exchange_rate = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2483: OR p_event_in_rec.P_projfunc_exchange_rate Is NULL ))
2484: OR p_event_in_rec.P_projfunc_exchange_rate <= 0)
2485: Then
2486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2487: THEN
2488: pa_interface_utils_pub.map_new_amg_msg
2489: ( p_old_message_code => 'PA_PFC_EXCG_RATE_INV'
2490: ,p_msg_attribute => 'CHANGE'
2504: AND UPPER(P_projfunc_rate_type) ='USER'
2505: AND NVL(UPPER(P_event_in_rec.P_projfunc_rate_type),'USER') <>'USER'
2506: AND l_check_projfunc_rate_date IS NULL )
2507: THEN
2508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2509: THEN
2510: pa_interface_utils_pub.map_new_amg_msg
2511: ( p_old_message_code => 'PA_INVALID_PROJFUNC_DATE'
2512: ,p_msg_attribute => 'CHANGE'
2530: l_proj_func_currency_code:=P_proj_func_currency_code;
2531:
2532: ElsIf (p_event_in_rec.P_bill_trans_currency_code <> P_proj_func_currency_code)
2533: Then
2534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2535: THEN
2536: pa_interface_utils_pub.map_new_amg_msg
2537: -- (p_old_message_code => 'PA_INVALID_BIL_TRX_CUR' --Commented for Bug#3013172
2538: (p_old_message_code => 'PA_EVENT_NON_MCB_OPTION' --Modified for Bug#3013172
2579: AND l_adjusting_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2580: AND PA_EVENT_PVT.CHECK_YES_NO
2581: (P_flag =>l_adjusting_revenue_flag)='N')
2582: Then
2583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2584: THEN
2585: pa_interface_utils_pub.map_new_amg_msg
2586: ( p_old_message_code =>'PA_INVALID_ADJ_REV_FLG'
2587: ,p_msg_attribute => 'CHANGE'
2597: ElsIf (l_adjusting_revenue_flag in ('Y','y'))
2598: Then
2599: If (p_event_type_classification <> 'MANUAL')
2600: Then
2601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2602: THEN
2603: pa_interface_utils_pub.map_new_amg_msg
2604: ( p_old_message_code =>'PA_INV_EV_TYP_ADJ_REV'
2605: ,p_msg_attribute => 'CHANGE'
2634: If PA_EVENT_UTILS.check_valid_rev_amt
2635: (P_event_type_classification =>P_event_type_classification
2636: ,P_rev_amt =>l_revenue_amount)='N'
2637: Then
2638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2639: THEN
2640: pa_interface_utils_pub.map_new_amg_msg
2641: ( p_old_message_code => 'PA_PR_EPR_REV_GT_ZERO'
2642: ,p_msg_attribute => 'CHANGE'
2674: If l_ret_status <> 'Y'
2675: Then
2676: If l_ret_status = 'N'
2677: Then
2678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2679: THEN
2680: pa_interface_utils_pub.map_new_amg_msg
2681: ( p_old_message_code =>'PA_TK_EXCESS_REV'
2682: ,p_msg_attribute => 'CHANGE'
2689: ,p_attribute5 => '');
2690: END IF;
2691: l_return_status:='N';
2692: Else
2693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2694: THEN
2695: pa_interface_utils_pub.map_new_amg_msg
2696: ( p_old_message_code =>l_ret_status
2697: ,p_msg_attribute => 'CHANGE'
2711: End If;
2712: ElsIf (p_event_type_classification In('MANUAL','WRITE ON','WRITE OFF')
2713: /* AND l_bill_amount= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) 4027500 */ AND l_revenue_amount is null )
2714: Then
2715: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2716: THEN
2717: pa_interface_utils_pub.map_new_amg_msg
2718: ( p_old_message_code => 'PA_INVALID_REV_AMT'
2719: ,p_msg_attribute => 'CHANGE'
2742: AND PA_EVENT_UTILS.CHECK_VALID_BILL_AMT
2743: (P_event_type_classification =>P_event_type_classification
2744: ,P_bill_amt =>l_bill_amount)='N')
2745: Then
2746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2747: THEN
2748: pa_interface_utils_pub.map_new_amg_msg
2749: ( p_old_message_code => 'PA_PR_EPR_BILL_GT_ZERO'
2750: ,p_msg_attribute => 'CHANGE'
2759: l_return_status:='N';
2760: ElsIf (p_event_type_classification In('MANUAL','DEFERRED REVENUE','INVOICE REDUCTION','SCHEDULED PAYMENTS')
2761: /* AND l_bill_amount= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) 4027500 */ AND l_bill_amount is null )
2762: Then
2763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2764: THEN
2765: pa_interface_utils_pub.map_new_amg_msg
2766: ( p_old_message_code => 'PA_INVALID_BILL_AMT'
2767: ,p_msg_attribute => 'CHANGE'
2788: AND p_event_in_rec.P_bill_hold_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2789: Then
2790: If (upper(p_event_in_rec.P_bill_hold_flag) NOT In('Y','N','O'))
2791: Then
2792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2793: THEN
2794: pa_interface_utils_pub.map_new_amg_msg
2795: ( p_old_message_code => 'PA_INVALID_BIL_HLD_FLG'
2796: ,p_msg_attribute => 'CHANGE'
2821: ,P_task_id =>x_task_id
2822: ,P_event_num =>p_event_in_rec.P_event_number)='Y')
2823: OR p_event_in_rec.P_event_number <=0 ) -- Added the OR condition for bug 5697448
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_INV_EVNT_NUM'
2829: ,p_msg_attribute => 'CHANGE'
2851: AND PA_EVENT_UTILS.CHECK_VALID_INV_ORG
2852: (P_inv_org_name =>p_event_in_rec.P_inventory_org_name
2853: ,P_inv_org_id =>x_inv_org_id)='N')
2854: Then
2855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2856: THEN
2857: pa_interface_utils_pub.map_new_amg_msg
2858: ( p_old_message_code => 'PA_INV_INVT_ORG_NAME'
2859: ,p_msg_attribute => 'CHANGE'
2880: AND p_event_in_rec.P_inventory_item_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2881: AND PA_EVENT_UTILS.CHECK_VALID_INV_ITEM
2882: (P_inv_item_id =>p_event_in_rec.P_inventory_item_id)='N')
2883: Then
2884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2885: THEN
2886: pa_interface_utils_pub.map_new_amg_msg
2887: ( p_old_message_code => 'PA_INV_INVT_ITEM'
2888: ,p_msg_attribute => 'CHANGE'
3041: OR P_event_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3042: )
3043:
3044: Then
3045: If FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3046: Then
3047: pa_interface_utils_pub.map_new_amg_msg
3048: ( p_old_message_code => 'PA_INV_EVNT_ID_REF'
3049: ,p_msg_attribute => 'CHANGE'
3066: Fetch check_event_id into event_id_found;
3067:
3068: If check_event_id%NOTFOUND
3069: Then
3070: If FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3071: Then
3072: pa_interface_utils_pub.map_new_amg_msg
3073: ( p_old_message_code => 'PA_INV_EVNT_ID'
3074: ,p_msg_attribute => 'CHANGE'
3099:
3100: --If event_id is null then return false.
3101: If (l_event_id Is NULL)
3102: Then
3103: If FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3104: Then
3105: pa_interface_utils_pub.map_new_amg_msg
3106: (p_old_message_code => 'PA_INVALID_EVENT_REF'
3107: ,p_msg_attribute => 'CHANGE'
3127: Then
3128:
3129: If (l_event_id <> p_event_id )
3130: Then
3131: If FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3132: Then
3133: pa_interface_utils_pub.map_new_amg_msg
3134: (p_old_message_code => 'PA_INV_EVENT_REF_ID'
3135: ,p_msg_attribute => 'CHANGE'
3250: EXCEPTION
3251:
3252: WHEN NO_DATA_FOUND THEN
3253:
3254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3255: THEN
3256: pa_interface_utils_pub.map_new_amg_msg
3257: ( p_old_message_code => 'PA_EVENT_IN_DELV_DEL'
3258: ,p_msg_attribute => 'CHANGE'
3268: Return(p_return_status);
3269: END;
3270: ElsIf l_event_processed IN ('N','I','R')/*For Bug 7305416*/
3271: Then
3272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3273: THEN
3274: pa_interface_utils_pub.map_new_amg_msg
3275: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
3276: ,p_msg_attribute => 'CHANGE'
3286: Return(p_return_status);
3287: /* The following code has been added for bug 3205120 */
3288: Elsif l_event_processed ='P'
3289: Then
3290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3291: THEN
3292: pa_interface_utils_pub.map_new_amg_msg
3293: ( p_old_message_code => 'PA_EVENT_PARTIAL_BILL'
3294: ,p_msg_attribute => 'CHANGE'
3303: p_return_status:='N';
3304: Return(p_return_status);
3305: Elsif l_event_processed = 'C'
3306: Then
3307: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3308: THEN
3309: pa_interface_utils_pub.map_new_amg_msg
3310: ( p_old_message_code => 'PA_EVENT_CANCEL_DEL'
3311: ,p_msg_attribute => 'CHANGE'