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_EVENT_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 244: pa_interface_utils_pub.map_new_amg_msg

240: ,P_project_num =>P_event_in_rec.P_project_number) = 'N'
241: Then
242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
243: THEN
244: pa_interface_utils_pub.map_new_amg_msg
245: ( p_old_message_code => 'PA_INVALID_PROJECT'
246: ,p_msg_attribute => 'CHANGE'
247: ,p_resize_flag => 'N'
248: ,p_msg_context => 'EVENT'

Line 354: AND (p_event_in_rec.p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

350:
351:
352: --Validating Flexfields
353: IF (p_event_in_rec.p_desc_flex_name IS NOT NULL)
354: AND (p_event_in_rec.p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
355: THEN
356: PA_EVENT_PVT.VALIDATE_FLEXFIELD
357: ( p_desc_flex_name => p_event_in_rec.p_desc_flex_name
358: ,p_attribute_category => p_event_in_rec.p_attribute_category

Line 375: pa_interface_utils_pub.map_new_amg_msg

371: IF p_validate_status = 'N'
372: THEN
373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
374: THEN
375: pa_interface_utils_pub.map_new_amg_msg
376: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
377: ,p_msg_attribute => 'CHANGE'
378: ,p_resize_flag => 'N'
379: ,p_msg_context => 'EVENT'

Line 414: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

410:
411: -- Validating the event num.If found NULL it is populated before
412: -- inserting the record into pa_events.
413: If (p_event_in_rec.P_event_number Is NULL
414: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
415: Then
416: --generating event number for project level events
417: If (P_task_id Is NULL)
418: Then

Line 471: If(p_event_in_rec.P_adjusting_revenue_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

467: p_event_in_rec.P_description:=p_event_in_rec.P_event_type;
468: End If;
469:
470: --Defaulting adjusting revenue flag
471: If(p_event_in_rec.P_adjusting_revenue_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
472: Then
473: p_event_in_rec.P_adjusting_revenue_flag :=NULL;
474: End If;
475:

Line 477: If(p_event_in_rec.P_bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

473: p_event_in_rec.P_adjusting_revenue_flag :=NULL;
474: End If;
475:
476: --Defaulting bill hold flag
477: If(p_event_in_rec.P_bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
478: Then
479: p_event_in_rec.P_bill_hold_flag :=NULL;
480: End If;
481:

Line 532: OR p_event_in_rec.P_bill_trans_currency_code=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

528:
529:
530: --validating and defaulting bill transaction currency code
531: If (p_event_in_rec.P_bill_trans_currency_code Is NULL
532: OR p_event_in_rec.P_bill_trans_currency_code=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
533: Then
534: p_event_in_rec.P_bill_trans_currency_code:=l_projfunc_currency_code;
535: End If;
536:

Line 539: OR p_event_in_rec.P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

535: End If;
536:
537: --funding rate,date and type validations
538: If(p_event_in_rec.P_funding_rate_type Is NULL
539: OR p_event_in_rec.P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
540: Then
541: p_event_in_rec.P_funding_rate_type:=l_funding_rate_type;
542: End If;
543: If (l_funding_rate_date_code = 'FIXED_DATE')

Line 546: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

542: End If;
543: If (l_funding_rate_date_code = 'FIXED_DATE')
544: Then
545: If(p_event_in_rec.P_funding_rate_date Is NULL
546: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
547: Then
548: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
549: End If;
550: Else

Line 555: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

551: --Commented for Bug3009239
552: -- p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
553: --Added for Bug3009239
554: If(p_event_in_rec.P_funding_rate_date Is NULL
555: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
556: Then
557: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
558: End If;
559: --till here for Bug3009239

Line 571: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

567: Then
568: p_event_in_rec.P_funding_exchange_rate :=NULL;
569: Else
570: If(p_event_in_rec.P_funding_exchange_rate Is NULL
571: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
572: Then
573: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
574: End If;
575: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3013256

Line 581: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

577:
578: Else
579: If(p_event_in_rec.P_funding_rate_type = 'User'
580: AND (p_event_in_rec.P_funding_exchange_rate Is NULL
581: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
582: Then
583: p_event_in_rec.P_funding_exchange_rate :=l_funding_exchange_rate;
584: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3010927
585: --Added for Bug3013256

Line 601: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

597: Then
598: p_event_in_rec.P_funding_exchange_rate :=NULL;
599: Else
600: If(p_event_in_rec.P_funding_exchange_rate Is NULL
601: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: Then
603: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
604: End If;
605: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3013256

Line 621: OR p_event_in_rec.P_projfunc_rate_type=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

617:
618: --start of validtions when project functional currency and bill trans currency are different.
619: Else
620: If(p_event_in_rec.P_projfunc_rate_type Is NULL
621: OR p_event_in_rec.P_projfunc_rate_type=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
622: Then
623: p_event_in_rec.P_projfunc_rate_type:=l_projfunc_bil_rate_type;
624: End If;
625:

Line 629: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

625:
626: If (l_projfunc_bil_rate_date_code= 'FIXED_DATE')
627: Then
628: If(p_event_in_rec.P_projfunc_rate_date Is NULL
629: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
630: Then
631: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
632: End If;
633: Else

Line 638: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

634: --Commented for Bug3009239
635: -- p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
636: --Added for Bug3009239
637: If(p_event_in_rec.P_projfunc_rate_date Is NULL
638: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
639: Then
640: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
641: End If;
642: --till here for Bug3009239

Line 653: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

649: Then
650: p_event_in_rec.P_projfunc_exchange_rate:=NULL;
651: ELSE
652: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
653: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
654: Then
655: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
656: End If;
657: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

Line 663: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

659: Else
660: If(p_event_in_rec.P_projfunc_rate_type = 'User')
661: Then
662: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
663: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
664: Then
665: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
666: End If;
667: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

Line 694: OR p_event_in_rec.P_project_rate_type =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

690: p_event_in_rec.P_project_rate_date := p_event_in_rec.P_projfunc_rate_date;
691: p_event_in_rec.P_project_exchange_rate := p_event_in_rec.P_projfunc_exchange_rate;
692: Else
693: If(p_event_in_rec.P_project_rate_type Is NULL
694: OR p_event_in_rec.P_project_rate_type =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
695: Then
696: p_event_in_rec.P_project_rate_type:=l_project_bil_rate_type;
697: End If;
698:

Line 702: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

698:
699: If (l_project_bil_rate_date_code = 'FIXED_DATE')
700: Then
701: If(p_event_in_rec.P_project_rate_date Is NULL
702: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
703: Then
704: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
705: End If;
706: Else

Line 711: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

707: --Commented for Bug3009239
708: -- p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
709: --Added for Bug3009239
710: If(p_event_in_rec.P_project_rate_date Is NULL
711: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
712: Then
713: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
714: End If;
715: --till here for Bug3009239

Line 725: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

721: Then
722: p_event_in_rec.P_project_exchange_rate:=NULL;
723: ELSE
724: If(p_event_in_rec.P_project_exchange_rate Is NULL
725: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
726: Then
727: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
728: End If;
729: p_event_in_rec.P_project_rate_date := null; --Added for Bug3045302

Line 735: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

731: Else
732: If(p_event_in_rec.P_project_rate_type= 'User')
733: Then
734: If(p_event_in_rec.P_project_exchange_rate Is NULL
735: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
736: Then
737: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
738: End If;
739: p_event_in_rec.P_project_rate_date := null; --Added for Bug3010927

Line 1363: pa_interface_utils_pub.map_new_amg_msg

1359: If (P_project_id <> nvl(l_project_id,P_project_id))
1360: Then
1361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: pa_interface_utils_pub.map_new_amg_msg
1364: ( p_old_message_code => 'PA_EV_REF_PROJ_MISS'
1365: ,p_msg_attribute => 'CHANGE'
1366: ,p_resize_flag => 'N'
1367: ,p_msg_context => 'EVENT'

Line 1515: AND (p_event_in_rec.p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1511: END IF;
1512:
1513: --Validating Flexfields
1514: IF (p_event_in_rec.p_desc_flex_name IS NOT NULL)
1515: AND (p_event_in_rec.p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1516: THEN
1517: PA_EVENT_PVT.VALIDATE_FLEXFIELD
1518: ( p_desc_flex_name => p_event_in_rec.p_desc_flex_name
1519: ,p_attribute_category => p_event_in_rec.p_attribute_category

Line 1536: pa_interface_utils_pub.map_new_amg_msg

1532: IF p_validate_status = 'N'
1533: THEN
1534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1536: pa_interface_utils_pub.map_new_amg_msg
1537: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
1538: ,p_msg_attribute => 'CHANGE'
1539: ,p_resize_flag => 'N'
1540: ,p_msg_context => 'EVENT'

Line 1553: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1549: END IF;
1550: --Defaulting attribute categories.
1551: Select decode(p_event_in_rec.P_attribute_category
1552: ,NULL,attribute_category
1553: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1554: ,p_event_in_rec.P_attribute_category)
1555: ,decode(p_event_in_rec.P_attribute1
1556: ,NULL,attribute1
1557: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1557: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1553: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1554: ,p_event_in_rec.P_attribute_category)
1555: ,decode(p_event_in_rec.P_attribute1
1556: ,NULL,attribute1
1557: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1558: ,p_event_in_rec.P_attribute1)
1559: ,decode(p_event_in_rec.P_attribute2
1560: ,NULL,attribute2
1561: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1561: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1557: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1558: ,p_event_in_rec.P_attribute1)
1559: ,decode(p_event_in_rec.P_attribute2
1560: ,NULL,attribute2
1561: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1562: ,p_event_in_rec.P_attribute2)
1563: ,decode(p_event_in_rec.P_attribute3
1564: ,NULL,attribute3
1565: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1565: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1561: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1562: ,p_event_in_rec.P_attribute2)
1563: ,decode(p_event_in_rec.P_attribute3
1564: ,NULL,attribute3
1565: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1566: ,p_event_in_rec.P_attribute3)
1567: ,decode(p_event_in_rec.P_attribute4
1568: ,NULL,attribute4
1569: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1569: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1565: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1566: ,p_event_in_rec.P_attribute3)
1567: ,decode(p_event_in_rec.P_attribute4
1568: ,NULL,attribute4
1569: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1570: ,p_event_in_rec.P_attribute4 )
1571: ,decode(p_event_in_rec.P_attribute5
1572: ,NULL,attribute5
1573: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1573: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1569: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1570: ,p_event_in_rec.P_attribute4 )
1571: ,decode(p_event_in_rec.P_attribute5
1572: ,NULL,attribute5
1573: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1574: ,p_event_in_rec.P_attribute5 )
1575: ,decode(p_event_in_rec.P_attribute6
1576: ,NULL,attribute6
1577: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1577: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1573: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1574: ,p_event_in_rec.P_attribute5 )
1575: ,decode(p_event_in_rec.P_attribute6
1576: ,NULL,attribute6
1577: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1578: ,p_event_in_rec.P_attribute6 )
1579: ,decode(p_event_in_rec.P_attribute7
1580: ,NULL,attribute7
1581: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1581: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1577: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1578: ,p_event_in_rec.P_attribute6 )
1579: ,decode(p_event_in_rec.P_attribute7
1580: ,NULL,attribute7
1581: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1582: ,p_event_in_rec.P_attribute7 )
1583: ,decode(p_event_in_rec.P_attribute8
1584: ,NULL,attribute8
1585: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1585: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1581: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1582: ,p_event_in_rec.P_attribute7 )
1583: ,decode(p_event_in_rec.P_attribute8
1584: ,NULL,attribute8
1585: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1586: ,p_event_in_rec.P_attribute8 )
1587: ,decode(p_event_in_rec.P_attribute9
1588: ,NULL,attribute9
1589: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1589: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1585: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1586: ,p_event_in_rec.P_attribute8 )
1587: ,decode(p_event_in_rec.P_attribute9
1588: ,NULL,attribute9
1589: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1590: ,p_event_in_rec.P_attribute9 )
1591: ,decode(p_event_in_rec.P_attribute10
1592: ,NULL,attribute10
1593: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1593: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1589: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1590: ,p_event_in_rec.P_attribute9 )
1591: ,decode(p_event_in_rec.P_attribute10
1592: ,NULL,attribute10
1593: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1594: ,p_event_in_rec.P_attribute10 )
1595: Into p_event_in_rec.P_attribute_category
1596: ,p_event_in_rec.P_attribute1
1597: ,p_event_in_rec.P_attribute2

Line 1638: OR p_event_in_rec.P_bill_trans_currency_code=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1634: If (l_multi_currency_billing_flag = 'Y')
1635: Then
1636: --validating and defaulting bill transaction currency code
1637: If (p_event_in_rec.P_bill_trans_currency_code Is NULL
1638: OR p_event_in_rec.P_bill_trans_currency_code=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1639: Then
1640: p_event_in_rec.P_bill_trans_currency_code:=l_bill_trans_curr_code; /* 3013117 */
1641: End If;
1642:

Line 1645: OR p_event_in_rec.P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1641: End If;
1642:
1643: --funding rate,date and type validations
1644: If(p_event_in_rec.P_funding_rate_type Is NULL
1645: OR p_event_in_rec.P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1646: Then
1647: p_event_in_rec.P_funding_rate_type:=l_funding_rate_type;
1648: End If;
1649:

Line 1653: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1649:
1650: If (l_funding_rate_date_code = 'FIXED_DATE')
1651: Then
1652: If(p_event_in_rec.P_funding_rate_date Is NULL
1653: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1654: Then
1655: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
1656: End If;
1657: Else

Line 1662: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1658: --Commented for bug3013236
1659: --p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
1660: --Added for bug3013236
1661: If(p_event_in_rec.P_funding_rate_date Is NULL
1662: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1663: Then
1664: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
1665: End If;
1666: --till here for Bug3013236

Line 1680: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1676: Then
1677: p_event_in_rec.P_funding_exchange_rate :=NULL;
1678: Else
1679: If(p_event_in_rec.P_funding_exchange_rate Is NULL
1680: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1681: Then
1682: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
1683: End If;
1684: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3010927

Line 1689: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

1685: End If;
1686: Else
1687: If(p_event_in_rec.P_funding_rate_type = 'User'
1688: AND (p_event_in_rec.P_funding_exchange_rate Is NULL
1689: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1690: Then
1691: p_event_in_rec.P_funding_exchange_rate :=l_funding_exchange_rate;
1692: --Added for Bug3013256
1693: Else

Line 1709: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1705: Then
1706: p_event_in_rec.P_funding_exchange_rate :=NULL;
1707: Else
1708: If (p_event_in_rec.P_funding_exchange_rate Is NULL
1709: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1710: Then
1711: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
1712: End If;
1713: p_event_in_rec.P_funding_rate_date := null;

Line 1728: OR p_event_in_rec.P_projfunc_rate_type=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1724: p_event_in_rec.P_projfunc_rate_date :=NULL;
1725: p_event_in_rec.P_projfunc_exchange_rate :=NULL;
1726: Else ---validtions if project functional currency and bill trans currency are different.
1727: If(p_event_in_rec.P_projfunc_rate_type Is NULL
1728: OR p_event_in_rec.P_projfunc_rate_type=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1729: Then
1730: p_event_in_rec.P_projfunc_rate_type:=l_projfunc_bil_rate_type;
1731: End If;
1732:

Line 1736: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1732:
1733: If (l_projfunc_bil_rate_date_code= 'FIXED_DATE')
1734: Then
1735: If(p_event_in_rec.P_projfunc_rate_date Is NULL
1736: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1737: Then
1738: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
1739: End If;
1740: Else

Line 1745: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1741: --Commented for Bug3013236
1742: -- p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
1743: --Added for Bug3013236
1744: If(p_event_in_rec.P_projfunc_rate_date Is NULL
1745: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1746: Then
1747: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
1748: End If;
1749: --till here for Bug3013236

Line 1759: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1755: Then
1756: p_event_in_rec.P_projfunc_exchange_rate:=NULL;
1757: Else
1758: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
1759: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1760: Then
1761: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
1762: End If;
1763: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

Line 1769: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1765: Else
1766: If(p_event_in_rec.P_projfunc_rate_type = 'User')
1767: Then
1768: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
1769: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1770: Then
1771: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
1772: End If;
1773: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

Line 1799: OR p_event_in_rec.P_project_rate_type =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1795:
1796: Else
1797: ---validations if project currency and bill trans currency are different.
1798: If(p_event_in_rec.P_project_rate_type Is NULL
1799: OR p_event_in_rec.P_project_rate_type =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1800: Then
1801: p_event_in_rec.P_project_rate_type:=l_project_bil_rate_type;
1802: End If;
1803:

Line 1807: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1803:
1804: If (l_project_bil_rate_date_code = 'FIXED_DATE')
1805: Then
1806: If(p_event_in_rec.P_project_rate_date Is NULL
1807: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1808: Then
1809: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
1810: End If;
1811: Else

Line 1816: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1812: --Commented for Bug3013236
1813: --p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
1814: --Added for Bug3013236
1815: If(p_event_in_rec.P_project_rate_date Is NULL
1816: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1817: Then
1818: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
1819: End If;
1820: --till here for Bug3013236

Line 1830: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1826: Then
1827: p_event_in_rec.P_project_exchange_rate:=NULL;
1828: Else
1829: If(p_event_in_rec.P_project_exchange_rate Is NULL
1830: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1831: Then
1832: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
1833: End If;
1834: p_event_in_rec.P_project_rate_date := null; --Added for Bug3010927

Line 1840: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1836: Else
1837: If(p_event_in_rec.P_project_rate_type= 'User')
1838: Then
1839: If(p_event_in_rec.P_project_exchange_rate Is NULL
1840: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1841: Then
1842: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
1843: End If;
1844: p_event_in_rec.P_project_rate_date := null; --Added for Bug3010927

Line 1883: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1879: -- Validating the event num.
1880: --If task number has been changed then generate new event_num
1881: --before inserting the record into pa_events.
1882: If (p_event_in_rec.P_event_number Is NULL
1883: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1884: Then
1885: SELECT task_id
1886: INTO l_task_id
1887: FROM pa_events e

Line 1936: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1932:
1933: --Defaulting bill_hold_flag,adjusting_revenue_flag.
1934: Select decode(p_event_in_rec.P_bill_hold_flag
1935: ,NULL,BILL_HOLD_FLAG
1936: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1937: ,p_event_in_rec.P_bill_hold_flag)
1938: ,decode(p_event_in_rec.P_adjusting_revenue_flag
1939: ,NULL,ADJUSTING_REVENUE_FLAG
1940: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1940: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1936: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1937: ,p_event_in_rec.P_bill_hold_flag)
1938: ,decode(p_event_in_rec.P_adjusting_revenue_flag
1939: ,NULL,ADJUSTING_REVENUE_FLAG
1940: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1941: ,p_event_in_rec.P_adjusting_revenue_flag)
1942: --Defaulting inventory org id and item ids
1943: ,decode(p_event_in_rec.P_inventory_org_name
1944: ,NULL,inventory_org_id

Line 1945: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1941: ,p_event_in_rec.P_adjusting_revenue_flag)
1942: --Defaulting inventory org id and item ids
1943: ,decode(p_event_in_rec.P_inventory_org_name
1944: ,NULL,inventory_org_id
1945: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1946: ,p_inv_org_id)
1947: ,decode(p_event_in_rec.P_inventory_item_id
1948: ,NULL,inventory_item_id
1949: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL

Line 1949: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL

1945: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1946: ,p_inv_org_id)
1947: ,decode(p_event_in_rec.P_inventory_item_id
1948: ,NULL,inventory_item_id
1949: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL
1950: ,p_event_in_rec.P_inventory_item_id)
1951: --Defaulting organization id.
1952: ,decode(p_event_in_rec.P_organization_name
1953: ,NULL,organization_id

Line 1954: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,organization_id

1950: ,p_event_in_rec.P_inventory_item_id)
1951: --Defaulting organization id.
1952: ,decode(p_event_in_rec.P_organization_name
1953: ,NULL,organization_id
1954: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,organization_id
1955: ,p_organization_id)
1956: --Defaulting OKE related fields.
1957: ,decode(p_event_in_rec.P_quantity_billed
1958: ,NULL,quantity_billed

Line 1959: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL

1955: ,p_organization_id)
1956: --Defaulting OKE related fields.
1957: ,decode(p_event_in_rec.P_quantity_billed
1958: ,NULL,quantity_billed
1959: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL
1960: ,p_event_in_rec.P_quantity_billed)
1961: ,decode(p_event_in_rec.P_uom_code
1962: ,NULL,uom_code
1963: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1963: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1959: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL
1960: ,p_event_in_rec.P_quantity_billed)
1961: ,decode(p_event_in_rec.P_uom_code
1962: ,NULL,uom_code
1963: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1964: ,p_event_in_rec.P_uom_code)
1965: ,decode(p_event_in_rec.P_unit_price
1966: ,NULL,unit_price
1967: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1967: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1963: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1964: ,p_event_in_rec.P_uom_code)
1965: ,decode(p_event_in_rec.P_unit_price
1966: ,NULL,unit_price
1967: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1968: ,p_event_in_rec.P_unit_price)
1969: --Defaulting references.
1970: ,decode(p_event_in_rec.P_reference1
1971: ,NULL,reference1

Line 1972: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1968: ,p_event_in_rec.P_unit_price)
1969: --Defaulting references.
1970: ,decode(p_event_in_rec.P_reference1
1971: ,NULL,reference1
1972: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1973: ,p_event_in_rec.P_reference1)
1974: ,decode(p_event_in_rec.P_reference2
1975: ,NULL,reference2
1976: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1976: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1972: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1973: ,p_event_in_rec.P_reference1)
1974: ,decode(p_event_in_rec.P_reference2
1975: ,NULL,reference2
1976: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1977: ,p_event_in_rec.P_reference2)
1978: ,decode(p_event_in_rec.P_reference3
1979: ,NULL,reference3
1980: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1980: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1976: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1977: ,p_event_in_rec.P_reference2)
1978: ,decode(p_event_in_rec.P_reference3
1979: ,NULL,reference3
1980: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1981: ,p_event_in_rec.P_reference3)
1982: ,decode(p_event_in_rec.P_reference4
1983: ,NULL,reference4
1984: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1984: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1980: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1981: ,p_event_in_rec.P_reference3)
1982: ,decode(p_event_in_rec.P_reference4
1983: ,NULL,reference4
1984: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1985: ,p_event_in_rec.P_reference4 )
1986: ,decode(p_event_in_rec.P_reference5
1987: ,NULL,reference5
1988: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1988: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1984: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1985: ,p_event_in_rec.P_reference4 )
1986: ,decode(p_event_in_rec.P_reference5
1987: ,NULL,reference5
1988: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1989: ,p_event_in_rec.P_reference5 )
1990: ,decode(p_event_in_rec.P_reference6
1991: ,NULL,reference6
1992: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1992: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1988: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1989: ,p_event_in_rec.P_reference5 )
1990: ,decode(p_event_in_rec.P_reference6
1991: ,NULL,reference6
1992: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1993: ,p_event_in_rec.P_reference6 )
1994: ,decode(p_event_in_rec.P_reference7
1995: ,NULL,reference7
1996: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1996: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1992: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1993: ,p_event_in_rec.P_reference6 )
1994: ,decode(p_event_in_rec.P_reference7
1995: ,NULL,reference7
1996: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1997: ,p_event_in_rec.P_reference7 )
1998: ,decode(p_event_in_rec.P_reference8
1999: ,NULL,reference8
2000: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2000: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1996: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1997: ,p_event_in_rec.P_reference7 )
1998: ,decode(p_event_in_rec.P_reference8
1999: ,NULL,reference8
2000: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2001: ,p_event_in_rec.P_reference8 )
2002: ,decode(p_event_in_rec.P_reference9
2003: ,NULL,reference9
2004: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2004: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2000: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2001: ,p_event_in_rec.P_reference8 )
2002: ,decode(p_event_in_rec.P_reference9
2003: ,NULL,reference9
2004: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2005: ,p_event_in_rec.P_reference9 )
2006: ,decode(p_event_in_rec.P_reference10
2007: ,NULL,reference10
2008: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2008: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2004: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2005: ,p_event_in_rec.P_reference9 )
2006: ,decode(p_event_in_rec.P_reference10
2007: ,NULL,reference10
2008: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2009: ,p_event_in_rec.P_reference10 )
2010: --defaulting completion date
2011: ,decode(p_event_in_rec.P_completion_date
2012: ,NULL,completion_date

Line 2013: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,SYSDATE

2009: ,p_event_in_rec.P_reference10 )
2010: --defaulting completion date
2011: ,decode(p_event_in_rec.P_completion_date
2012: ,NULL,completion_date
2013: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,SYSDATE
2014: ,p_event_in_rec.P_completion_date)
2015: --Defaulting event type.
2016: ,decode(p_event_in_rec.P_event_type
2017: ,NULL,event_type

Line 2018: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,event_type

2014: ,p_event_in_rec.P_completion_date)
2015: --Defaulting event type.
2016: ,decode(p_event_in_rec.P_event_type
2017: ,NULL,event_type
2018: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,event_type
2019: ,p_event_in_rec.P_event_type)
2020: --Defaulting bill trans revenue and bill trans bill amounts
2021: ,decode(p_event_in_rec.P_bill_trans_rev_amount
2022: ,NULL,bill_trans_rev_amount

Line 2030: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2026: ,p_event_in_rec.P_bill_trans_bill_amount)
2027: --Defaulting task_id.
2028: ,decode(p_event_in_rec.p_task_number
2029: ,NULL,task_id
2030: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2031: ,P_task_id)
2032: ,decode(p_event_in_rec.p_description, null, description,
2033: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description, p_event_in_rec.p_description)
2034: ,record_version_number

Line 2033: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description, p_event_in_rec.p_description)

2029: ,NULL,task_id
2030: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2031: ,P_task_id)
2032: ,decode(p_event_in_rec.p_description, null, description,
2033: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description, p_event_in_rec.p_description)
2034: ,record_version_number
2035: ,decode(ADJUSTING_REVENUE_FLAG,'N', /* Added for bug 6863270 */
2036: decode(p_event_in_rec.p_bill_trans_bill_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_bill_amount,
2037: null, bill_trans_bill_amount, p_event_in_rec.p_bill_trans_bill_amount),0)

Line 2036: decode(p_event_in_rec.p_bill_trans_bill_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_bill_amount,

2032: ,decode(p_event_in_rec.p_description, null, description,
2033: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description, p_event_in_rec.p_description)
2034: ,record_version_number
2035: ,decode(ADJUSTING_REVENUE_FLAG,'N', /* Added for bug 6863270 */
2036: decode(p_event_in_rec.p_bill_trans_bill_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_bill_amount,
2037: null, bill_trans_bill_amount, p_event_in_rec.p_bill_trans_bill_amount),0)
2038: ,decode(p_event_in_rec.p_bill_trans_rev_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_rev_amount,
2039: null, bill_trans_rev_amount, p_event_in_rec.p_bill_trans_rev_amount)
2040: Into p_event_in_rec.P_bill_hold_flag

Line 2038: ,decode(p_event_in_rec.p_bill_trans_rev_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_rev_amount,

2034: ,record_version_number
2035: ,decode(ADJUSTING_REVENUE_FLAG,'N', /* Added for bug 6863270 */
2036: decode(p_event_in_rec.p_bill_trans_bill_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_bill_amount,
2037: null, bill_trans_bill_amount, p_event_in_rec.p_bill_trans_bill_amount),0)
2038: ,decode(p_event_in_rec.p_bill_trans_rev_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_rev_amount,
2039: null, bill_trans_rev_amount, p_event_in_rec.p_bill_trans_rev_amount)
2040: Into p_event_in_rec.P_bill_hold_flag
2041: ,p_event_in_rec.P_adjusting_revenue_flag
2042: ,p_inv_org_id

Line 2074: OR p_event_in_rec.P_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

2070:
2071: --Unless the user updates with a valid description the
2072: --description gets defaulted with the event type.
2073: If (p_event_in_rec.P_description Is NULL
2074: OR p_event_in_rec.P_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2075: Then
2076: p_event_in_rec.P_description := p_event_in_rec.P_event_type;
2077: End If;
2078:

Line 2170: pa_interface_utils_pub.map_new_amg_msg

2166: IF nvl(l_record_version_number, 0) <> nvl(p_event_in_rec.P_record_version_number, 0)
2167: Then
2168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2169: THEN
2170: pa_interface_utils_pub.map_new_amg_msg
2171: ( p_old_message_code => 'PA_RECORD_CHANGED'
2172: ,p_msg_attribute => 'CHANGE'
2173: ,p_resize_flag => 'N'
2174: ,p_msg_context => 'EVENT'

Line 3051: pa_interface_utils_pub.map_new_amg_msg

3047: ,P_event_id =>l_event_id_out) ='N'
3048: Then
3049: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3050: THEN
3051: pa_interface_utils_pub.map_new_amg_msg
3052: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
3053: ,p_msg_attribute => 'CHANGE'
3054: ,p_resize_flag => 'N'
3055: ,p_msg_context => 'EVENT'

Line 3797: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3793: END IF;
3794: -- CHECK WHETHER MANDATORY INCOMING PARAMETER PRODUCT CODE EXIST
3795:
3796: IF (p_pm_product_code IS NULL)
3797: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3798: THEN
3799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3800: THEN
3801: pa_interface_utils_pub.map_new_amg_msg

Line 3801: pa_interface_utils_pub.map_new_amg_msg

3797: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3798: THEN
3799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3800: THEN
3801: pa_interface_utils_pub.map_new_amg_msg
3802: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
3803: ,p_msg_attribute => 'CHANGE'
3804: ,p_resize_flag => 'N'
3805: ,p_msg_context => 'EVENT'

Line 3826: And p_pm_event_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3822:
3823:
3824: --Deriving event_id from p_pm_event_reference.
3825: If(p_pm_event_reference Is NOT NULL
3826: And p_pm_event_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3827: Then
3828: While tot_recs <= G_event_tbl_count
3829: loop
3830: If (G_event_out_tbl(tot_recs).pm_event_reference = p_pm_event_reference )

Line 4022: pa_interface_utils_pub.map_new_amg_msg

4018:
4019: If PA_EVENT_UTILS.CHECK_EVENT_PROCESSED
4020: (P_event_id =>l_event_id) IN ('N','I','R')/*For Bug 7305416*/
4021: Then
4022: pa_interface_utils_pub.map_new_amg_msg
4023: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
4024: ,p_msg_attribute => 'CHANGE'
4025: ,p_resize_flag => 'N'
4026: ,p_msg_context => 'EVENT'