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 146: IF (p_event_in_tbl(tot_in_rec).P_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

142: P_event_in_rec.P_agreement_number :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_agreement_number));
143: P_event_in_rec.P_agreement_type :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_agreement_type));
144: P_event_in_rec.P_customer_number :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_customer_number));
145: -- Bug 8410898 skkoppul
146: IF (p_event_in_tbl(tot_in_rec).P_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
147: P_event_in_rec.P_description :=NULL;
148: ELSE
149: P_event_in_rec.P_description :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_description));
150: END IF;

Line 186: IF (p_event_in_tbl(tot_in_rec).P_project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

182: P_event_in_rec.P_bill_trans_currency_code :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_bill_trans_currency_code));
183: P_event_in_rec.P_bill_trans_bill_amount :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_bill_trans_bill_amount));
184: P_event_in_rec.P_bill_trans_rev_amount :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_bill_trans_rev_amount));
185: -- Bug 8410898 skkoppul
186: IF (p_event_in_tbl(tot_in_rec).P_project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
187: P_event_in_rec.P_project_rate_type :=NULL;
188: ELSE
189: P_event_in_rec.P_project_rate_type :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_project_rate_type));
190: END IF;

Line 194: IF (p_event_in_tbl(tot_in_rec).P_projfunc_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

190: END IF;
191: P_event_in_rec.P_project_rate_date :=trunc(p_event_in_tbl(tot_in_rec).P_project_rate_date);
192: P_event_in_rec.P_project_exchange_rate :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_project_exchange_rate));
193: -- Bug 8410898 skkoppul
194: IF (p_event_in_tbl(tot_in_rec).P_projfunc_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
195: P_event_in_rec.P_projfunc_rate_type := NULL;
196: ELSE
197: P_event_in_rec.P_projfunc_rate_type :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_projfunc_rate_type));
198: END IF;

Line 202: IF (p_event_in_tbl(tot_in_rec).P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

198: END IF;
199: P_event_in_rec.P_projfunc_rate_date :=trunc(p_event_in_tbl(tot_in_rec).P_projfunc_rate_date);
200: P_event_in_rec.P_projfunc_exchange_rate :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_projfunc_exchange_rate));
201: -- Bug 8410898 skkoppul
202: IF (p_event_in_tbl(tot_in_rec).P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
203: P_event_in_rec.P_funding_rate_type := NULL;
204: ELSE
205: P_event_in_rec.P_funding_rate_type :=ltrim(rtrim(p_event_in_tbl(tot_in_rec).P_funding_rate_type));
206: END IF;

Line 264: pa_interface_utils_pub.map_new_amg_msg

260: ,P_project_num =>P_event_in_rec.P_project_number) = 'N'
261: Then
262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
263: THEN
264: pa_interface_utils_pub.map_new_amg_msg
265: ( p_old_message_code => 'PA_INVALID_PROJECT'
266: ,p_msg_attribute => 'CHANGE'
267: ,p_resize_flag => 'N'
268: ,p_msg_context => 'EVENT'

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

370:
371:
372: --Validating Flexfields
373: IF (p_event_in_rec.p_desc_flex_name IS NOT NULL)
374: AND (p_event_in_rec.p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
375: THEN
376: PA_EVENT_PVT.VALIDATE_FLEXFIELD
377: ( p_desc_flex_name => p_event_in_rec.p_desc_flex_name
378: ,p_attribute_category => p_event_in_rec.p_attribute_category

Line 395: pa_interface_utils_pub.map_new_amg_msg

391: IF p_validate_status = 'N'
392: THEN
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
394: THEN
395: pa_interface_utils_pub.map_new_amg_msg
396: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
397: ,p_msg_attribute => 'CHANGE'
398: ,p_resize_flag => 'N'
399: ,p_msg_context => 'EVENT'

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

430:
431: -- Validating the event num.If found NULL it is populated before
432: -- inserting the record into pa_events.
433: If (p_event_in_rec.P_event_number Is NULL
434: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
435: Then
436: --generating event number for project level events
437: If (P_task_id Is NULL)
438: Then

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

487: p_event_in_rec.P_description:=p_event_in_rec.P_event_type;
488: End If;
489:
490: --Defaulting adjusting revenue flag
491: If(p_event_in_rec.P_adjusting_revenue_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
492: Then
493: p_event_in_rec.P_adjusting_revenue_flag :=NULL;
494: End If;
495:

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

493: p_event_in_rec.P_adjusting_revenue_flag :=NULL;
494: End If;
495:
496: --Defaulting bill hold flag
497: If(p_event_in_rec.P_bill_hold_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
498: Then
499: p_event_in_rec.P_bill_hold_flag :=NULL;
500: End If;
501:

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

548:
549:
550: --validating and defaulting bill transaction currency code
551: If (p_event_in_rec.P_bill_trans_currency_code Is NULL
552: OR p_event_in_rec.P_bill_trans_currency_code=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
553: Then
554: p_event_in_rec.P_bill_trans_currency_code:=l_projfunc_currency_code;
555: End If;
556:

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

555: End If;
556:
557: --funding rate,date and type validations
558: If(p_event_in_rec.P_funding_rate_type Is NULL
559: OR p_event_in_rec.P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
560: Then
561: p_event_in_rec.P_funding_rate_type:=l_funding_rate_type;
562: End If;
563: If (l_funding_rate_date_code = 'FIXED_DATE')

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

562: End If;
563: If (l_funding_rate_date_code = 'FIXED_DATE')
564: Then
565: If(p_event_in_rec.P_funding_rate_date Is NULL
566: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
567: Then
568: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
569: End If;
570: Else

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

571: --Commented for Bug3009239
572: -- p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
573: --Added for Bug3009239
574: If(p_event_in_rec.P_funding_rate_date Is NULL
575: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
576: Then
577: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
578: End If;
579: --till here for Bug3009239

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

587: Then
588: p_event_in_rec.P_funding_exchange_rate :=NULL;
589: Else
590: If(p_event_in_rec.P_funding_exchange_rate Is NULL
591: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
592: Then
593: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
594: End If;
595: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3013256

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

597:
598: Else
599: If(p_event_in_rec.P_funding_rate_type = 'User'
600: AND (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: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3010927
605: --Added for Bug3013256

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

617: Then
618: p_event_in_rec.P_funding_exchange_rate :=NULL;
619: Else
620: If(p_event_in_rec.P_funding_exchange_rate Is NULL
621: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
622: Then
623: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
624: End If;
625: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3013256

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

637:
638: --start of validtions when project functional currency and bill trans currency are different.
639: Else
640: If(p_event_in_rec.P_projfunc_rate_type Is NULL
641: OR p_event_in_rec.P_projfunc_rate_type=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
642: Then
643: p_event_in_rec.P_projfunc_rate_type:=l_projfunc_bil_rate_type;
644: End If;
645:

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

645:
646: If (l_projfunc_bil_rate_date_code= 'FIXED_DATE')
647: Then
648: If(p_event_in_rec.P_projfunc_rate_date Is NULL
649: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
650: Then
651: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
652: End If;
653: Else

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

654: --Commented for Bug3009239
655: -- p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
656: --Added for Bug3009239
657: If(p_event_in_rec.P_projfunc_rate_date Is NULL
658: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
659: Then
660: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
661: End If;
662: --till here for Bug3009239

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

669: Then
670: p_event_in_rec.P_projfunc_exchange_rate:=NULL;
671: ELSE
672: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
673: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
674: Then
675: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
676: End If;
677: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

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

679: Else
680: If(p_event_in_rec.P_projfunc_rate_type = 'User')
681: Then
682: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
683: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
684: Then
685: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
686: End If;
687: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

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

710: p_event_in_rec.P_project_rate_date := p_event_in_rec.P_projfunc_rate_date;
711: p_event_in_rec.P_project_exchange_rate := p_event_in_rec.P_projfunc_exchange_rate;
712: Else
713: If(p_event_in_rec.P_project_rate_type Is NULL
714: OR p_event_in_rec.P_project_rate_type =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
715: Then
716: p_event_in_rec.P_project_rate_type:=l_project_bil_rate_type;
717: End If;
718:

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

718:
719: If (l_project_bil_rate_date_code = 'FIXED_DATE')
720: Then
721: If(p_event_in_rec.P_project_rate_date Is NULL
722: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
723: Then
724: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
725: End If;
726: Else

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

727: --Commented for Bug3009239
728: -- p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
729: --Added for Bug3009239
730: If(p_event_in_rec.P_project_rate_date Is NULL
731: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
732: Then
733: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
734: End If;
735: --till here for Bug3009239

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

741: Then
742: p_event_in_rec.P_project_exchange_rate:=NULL;
743: ELSE
744: If(p_event_in_rec.P_project_exchange_rate Is NULL
745: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
746: Then
747: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
748: End If;
749: p_event_in_rec.P_project_rate_date := null; --Added for Bug3045302

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

751: Else
752: If(p_event_in_rec.P_project_rate_type= 'User')
753: Then
754: If(p_event_in_rec.P_project_exchange_rate Is NULL
755: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
756: Then
757: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
758: End If;
759: p_event_in_rec.P_project_rate_date := null; --Added for Bug3010927

Line 1390: pa_interface_utils_pub.map_new_amg_msg

1386: If (P_project_id <> nvl(l_project_id,P_project_id))
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_EV_REF_PROJ_MISS'
1392: ,p_msg_attribute => 'CHANGE'
1393: ,p_resize_flag => 'N'
1394: ,p_msg_context => 'EVENT'

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

1538: END IF;
1539:
1540: --Validating Flexfields
1541: IF (p_event_in_rec.p_desc_flex_name IS NOT NULL)
1542: AND (p_event_in_rec.p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1543: THEN
1544: PA_EVENT_PVT.VALIDATE_FLEXFIELD
1545: ( p_desc_flex_name => p_event_in_rec.p_desc_flex_name
1546: ,p_attribute_category => p_event_in_rec.p_attribute_category

Line 1563: pa_interface_utils_pub.map_new_amg_msg

1559: IF p_validate_status = 'N'
1560: THEN
1561: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1562: THEN
1563: pa_interface_utils_pub.map_new_amg_msg
1564: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
1565: ,p_msg_attribute => 'CHANGE'
1566: ,p_resize_flag => 'N'
1567: ,p_msg_context => 'EVENT'

Line 1580: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1576: END IF;
1577: --Defaulting attribute categories.
1578: Select decode(p_event_in_rec.P_attribute_category
1579: ,NULL,attribute_category
1580: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1581: ,p_event_in_rec.P_attribute_category)
1582: ,decode(p_event_in_rec.P_attribute1
1583: ,NULL,attribute1
1584: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1584: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1580: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1581: ,p_event_in_rec.P_attribute_category)
1582: ,decode(p_event_in_rec.P_attribute1
1583: ,NULL,attribute1
1584: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1585: ,p_event_in_rec.P_attribute1)
1586: ,decode(p_event_in_rec.P_attribute2
1587: ,NULL,attribute2
1588: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1588: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1584: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1585: ,p_event_in_rec.P_attribute1)
1586: ,decode(p_event_in_rec.P_attribute2
1587: ,NULL,attribute2
1588: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1589: ,p_event_in_rec.P_attribute2)
1590: ,decode(p_event_in_rec.P_attribute3
1591: ,NULL,attribute3
1592: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1592: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1588: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1589: ,p_event_in_rec.P_attribute2)
1590: ,decode(p_event_in_rec.P_attribute3
1591: ,NULL,attribute3
1592: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1593: ,p_event_in_rec.P_attribute3)
1594: ,decode(p_event_in_rec.P_attribute4
1595: ,NULL,attribute4
1596: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1596: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1592: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1593: ,p_event_in_rec.P_attribute3)
1594: ,decode(p_event_in_rec.P_attribute4
1595: ,NULL,attribute4
1596: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1597: ,p_event_in_rec.P_attribute4 )
1598: ,decode(p_event_in_rec.P_attribute5
1599: ,NULL,attribute5
1600: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1600: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1596: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1597: ,p_event_in_rec.P_attribute4 )
1598: ,decode(p_event_in_rec.P_attribute5
1599: ,NULL,attribute5
1600: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1601: ,p_event_in_rec.P_attribute5 )
1602: ,decode(p_event_in_rec.P_attribute6
1603: ,NULL,attribute6
1604: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1604: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1600: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1601: ,p_event_in_rec.P_attribute5 )
1602: ,decode(p_event_in_rec.P_attribute6
1603: ,NULL,attribute6
1604: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1605: ,p_event_in_rec.P_attribute6 )
1606: ,decode(p_event_in_rec.P_attribute7
1607: ,NULL,attribute7
1608: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1608: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1604: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1605: ,p_event_in_rec.P_attribute6 )
1606: ,decode(p_event_in_rec.P_attribute7
1607: ,NULL,attribute7
1608: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1609: ,p_event_in_rec.P_attribute7 )
1610: ,decode(p_event_in_rec.P_attribute8
1611: ,NULL,attribute8
1612: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1612: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1608: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1609: ,p_event_in_rec.P_attribute7 )
1610: ,decode(p_event_in_rec.P_attribute8
1611: ,NULL,attribute8
1612: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1613: ,p_event_in_rec.P_attribute8 )
1614: ,decode(p_event_in_rec.P_attribute9
1615: ,NULL,attribute9
1616: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1616: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1612: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1613: ,p_event_in_rec.P_attribute8 )
1614: ,decode(p_event_in_rec.P_attribute9
1615: ,NULL,attribute9
1616: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1617: ,p_event_in_rec.P_attribute9 )
1618: ,decode(p_event_in_rec.P_attribute10
1619: ,NULL,attribute10
1620: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1620: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1616: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1617: ,p_event_in_rec.P_attribute9 )
1618: ,decode(p_event_in_rec.P_attribute10
1619: ,NULL,attribute10
1620: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1621: ,p_event_in_rec.P_attribute10 )
1622: Into p_event_in_rec.P_attribute_category
1623: ,p_event_in_rec.P_attribute1
1624: ,p_event_in_rec.P_attribute2

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

1661: If (l_multi_currency_billing_flag = 'Y')
1662: Then
1663: --validating and defaulting bill transaction currency code
1664: If (p_event_in_rec.P_bill_trans_currency_code Is NULL
1665: OR p_event_in_rec.P_bill_trans_currency_code=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1666: Then
1667: p_event_in_rec.P_bill_trans_currency_code:=l_bill_trans_curr_code; /* 3013117 */
1668: End If;
1669:

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

1668: End If;
1669:
1670: --funding rate,date and type validations
1671: If(p_event_in_rec.P_funding_rate_type Is NULL
1672: OR p_event_in_rec.P_funding_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1673: Then
1674: p_event_in_rec.P_funding_rate_type:=l_funding_rate_type;
1675: End If;
1676:

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

1676:
1677: If (l_funding_rate_date_code = 'FIXED_DATE')
1678: Then
1679: If(p_event_in_rec.P_funding_rate_date Is NULL
1680: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1681: Then
1682: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
1683: End If;
1684: Else

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

1685: --Commented for bug3013236
1686: --p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
1687: --Added for bug3013236
1688: If(p_event_in_rec.P_funding_rate_date Is NULL
1689: OR p_event_in_rec.P_funding_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1690: Then
1691: p_event_in_rec.P_funding_rate_date:=l_funding_rate_date;
1692: End If;
1693: --till here for Bug3013236

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

1703: Then
1704: p_event_in_rec.P_funding_exchange_rate :=NULL;
1705: Else
1706: If(p_event_in_rec.P_funding_exchange_rate Is NULL
1707: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1708: Then
1709: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
1710: End If;
1711: p_event_in_rec.P_funding_rate_date := null; --Added for Bug3010927

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

1712: End If;
1713: Else
1714: If(p_event_in_rec.P_funding_rate_type = 'User'
1715: AND (p_event_in_rec.P_funding_exchange_rate Is NULL
1716: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1717: Then
1718: p_event_in_rec.P_funding_exchange_rate :=l_funding_exchange_rate;
1719: --Added for Bug3013256
1720: Else

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

1732: Then
1733: p_event_in_rec.P_funding_exchange_rate :=NULL;
1734: Else
1735: If (p_event_in_rec.P_funding_exchange_rate Is NULL
1736: OR p_event_in_rec.P_funding_exchange_rate =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1737: Then
1738: p_event_in_rec.P_funding_exchange_rate:=l_funding_exchange_rate;
1739: End If;
1740: p_event_in_rec.P_funding_rate_date := null;

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

1751: p_event_in_rec.P_projfunc_rate_date :=NULL;
1752: p_event_in_rec.P_projfunc_exchange_rate :=NULL;
1753: Else ---validtions if project functional currency and bill trans currency are different.
1754: If(p_event_in_rec.P_projfunc_rate_type Is NULL
1755: OR p_event_in_rec.P_projfunc_rate_type=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1756: Then
1757: p_event_in_rec.P_projfunc_rate_type:=l_projfunc_bil_rate_type;
1758: End If;
1759:

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

1759:
1760: If (l_projfunc_bil_rate_date_code= 'FIXED_DATE')
1761: Then
1762: If(p_event_in_rec.P_projfunc_rate_date Is NULL
1763: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1764: Then
1765: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
1766: End If;
1767: Else

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

1768: --Commented for Bug3013236
1769: -- p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
1770: --Added for Bug3013236
1771: If(p_event_in_rec.P_projfunc_rate_date Is NULL
1772: OR p_event_in_rec.P_projfunc_rate_date=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1773: Then
1774: p_event_in_rec.P_projfunc_rate_date:=l_projfunc_bil_rate_date;
1775: End If;
1776: --till here for Bug3013236

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

1782: Then
1783: p_event_in_rec.P_projfunc_exchange_rate:=NULL;
1784: Else
1785: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
1786: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1787: Then
1788: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
1789: End If;
1790: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

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

1792: Else
1793: If(p_event_in_rec.P_projfunc_rate_type = 'User')
1794: Then
1795: If (p_event_in_rec.P_projfunc_exchange_rate Is NULL
1796: OR p_event_in_rec.P_projfunc_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1797: Then
1798: p_event_in_rec.P_projfunc_exchange_rate:=l_projfunc_bil_exchange_rate;
1799: End If;
1800: p_event_in_rec.P_projfunc_rate_date := null; --Added for Bug3010927

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

1822:
1823: Else
1824: ---validations if project currency and bill trans currency are different.
1825: If(p_event_in_rec.P_project_rate_type Is NULL
1826: OR p_event_in_rec.P_project_rate_type =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1827: Then
1828: p_event_in_rec.P_project_rate_type:=l_project_bil_rate_type;
1829: End If;
1830:

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

1830:
1831: If (l_project_bil_rate_date_code = 'FIXED_DATE')
1832: Then
1833: If(p_event_in_rec.P_project_rate_date Is NULL
1834: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1835: Then
1836: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
1837: End If;
1838: Else

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

1839: --Commented for Bug3013236
1840: --p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
1841: --Added for Bug3013236
1842: If(p_event_in_rec.P_project_rate_date Is NULL
1843: OR p_event_in_rec.P_project_rate_date =PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1844: Then
1845: p_event_in_rec.P_project_rate_date:=l_project_bil_rate_date;
1846: End If;
1847: --till here for Bug3013236

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

1853: Then
1854: p_event_in_rec.P_project_exchange_rate:=NULL;
1855: Else
1856: If(p_event_in_rec.P_project_exchange_rate Is NULL
1857: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1858: Then
1859: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
1860: End If;
1861: p_event_in_rec.P_project_rate_date := null; --Added for Bug3010927

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

1863: Else
1864: If(p_event_in_rec.P_project_rate_type= 'User')
1865: Then
1866: If(p_event_in_rec.P_project_exchange_rate Is NULL
1867: OR p_event_in_rec.P_project_exchange_rate=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1868: Then
1869: p_event_in_rec.P_project_exchange_rate:=l_project_bil_exchange_rate;
1870: End If;
1871: p_event_in_rec.P_project_rate_date := null; --Added for Bug3010927

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

1906: -- Validating the event num.
1907: --If task number has been changed then generate new event_num
1908: --before inserting the record into pa_events.
1909: If (p_event_in_rec.P_event_number Is NULL
1910: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1911: Then
1912: SELECT task_id
1913: INTO l_task_id
1914: FROM pa_events e

Line 1963: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1959:
1960: --Defaulting bill_hold_flag,adjusting_revenue_flag.
1961: Select decode(p_event_in_rec.P_bill_hold_flag
1962: ,NULL,BILL_HOLD_FLAG
1963: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1964: ,p_event_in_rec.P_bill_hold_flag)
1965: ,decode(p_event_in_rec.P_adjusting_revenue_flag
1966: ,NULL,ADJUSTING_REVENUE_FLAG
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_bill_hold_flag)
1965: ,decode(p_event_in_rec.P_adjusting_revenue_flag
1966: ,NULL,ADJUSTING_REVENUE_FLAG
1967: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1968: ,p_event_in_rec.P_adjusting_revenue_flag)
1969: --Defaulting inventory org id and item ids
1970: ,decode(p_event_in_rec.P_inventory_org_name
1971: ,NULL,inventory_org_id

Line 1972: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1968: ,p_event_in_rec.P_adjusting_revenue_flag)
1969: --Defaulting inventory org id and item ids
1970: ,decode(p_event_in_rec.P_inventory_org_name
1971: ,NULL,inventory_org_id
1972: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1973: ,p_inv_org_id)
1974: ,decode(p_event_in_rec.P_inventory_item_id
1975: ,NULL,inventory_item_id
1976: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL

Line 1976: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL

1972: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1973: ,p_inv_org_id)
1974: ,decode(p_event_in_rec.P_inventory_item_id
1975: ,NULL,inventory_item_id
1976: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL
1977: ,p_event_in_rec.P_inventory_item_id)
1978: --Defaulting organization id.
1979: ,decode(p_event_in_rec.P_organization_name
1980: ,NULL,organization_id

Line 1981: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,organization_id

1977: ,p_event_in_rec.P_inventory_item_id)
1978: --Defaulting organization id.
1979: ,decode(p_event_in_rec.P_organization_name
1980: ,NULL,organization_id
1981: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,organization_id
1982: ,p_organization_id)
1983: --Defaulting OKE related fields.
1984: ,decode(p_event_in_rec.P_quantity_billed
1985: ,NULL,quantity_billed

Line 1986: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL

1982: ,p_organization_id)
1983: --Defaulting OKE related fields.
1984: ,decode(p_event_in_rec.P_quantity_billed
1985: ,NULL,quantity_billed
1986: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL
1987: ,p_event_in_rec.P_quantity_billed)
1988: ,decode(p_event_in_rec.P_uom_code
1989: ,NULL,uom_code
1990: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1990: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1986: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,NULL
1987: ,p_event_in_rec.P_quantity_billed)
1988: ,decode(p_event_in_rec.P_uom_code
1989: ,NULL,uom_code
1990: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1991: ,p_event_in_rec.P_uom_code)
1992: ,decode(p_event_in_rec.P_unit_price
1993: ,NULL,unit_price
1994: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 1994: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1990: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1991: ,p_event_in_rec.P_uom_code)
1992: ,decode(p_event_in_rec.P_unit_price
1993: ,NULL,unit_price
1994: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
1995: ,p_event_in_rec.P_unit_price)
1996: --Defaulting references.
1997: ,decode(p_event_in_rec.P_reference1
1998: ,NULL,reference1

Line 1999: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1995: ,p_event_in_rec.P_unit_price)
1996: --Defaulting references.
1997: ,decode(p_event_in_rec.P_reference1
1998: ,NULL,reference1
1999: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2000: ,p_event_in_rec.P_reference1)
2001: ,decode(p_event_in_rec.P_reference2
2002: ,NULL,reference2
2003: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2003: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

1999: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2000: ,p_event_in_rec.P_reference1)
2001: ,decode(p_event_in_rec.P_reference2
2002: ,NULL,reference2
2003: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2004: ,p_event_in_rec.P_reference2)
2005: ,decode(p_event_in_rec.P_reference3
2006: ,NULL,reference3
2007: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2007: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2003: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2004: ,p_event_in_rec.P_reference2)
2005: ,decode(p_event_in_rec.P_reference3
2006: ,NULL,reference3
2007: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2008: ,p_event_in_rec.P_reference3)
2009: ,decode(p_event_in_rec.P_reference4
2010: ,NULL,reference4
2011: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2011: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2007: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2008: ,p_event_in_rec.P_reference3)
2009: ,decode(p_event_in_rec.P_reference4
2010: ,NULL,reference4
2011: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2012: ,p_event_in_rec.P_reference4 )
2013: ,decode(p_event_in_rec.P_reference5
2014: ,NULL,reference5
2015: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2015: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2011: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2012: ,p_event_in_rec.P_reference4 )
2013: ,decode(p_event_in_rec.P_reference5
2014: ,NULL,reference5
2015: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2016: ,p_event_in_rec.P_reference5 )
2017: ,decode(p_event_in_rec.P_reference6
2018: ,NULL,reference6
2019: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2019: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2015: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2016: ,p_event_in_rec.P_reference5 )
2017: ,decode(p_event_in_rec.P_reference6
2018: ,NULL,reference6
2019: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2020: ,p_event_in_rec.P_reference6 )
2021: ,decode(p_event_in_rec.P_reference7
2022: ,NULL,reference7
2023: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2023: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2019: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2020: ,p_event_in_rec.P_reference6 )
2021: ,decode(p_event_in_rec.P_reference7
2022: ,NULL,reference7
2023: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2024: ,p_event_in_rec.P_reference7 )
2025: ,decode(p_event_in_rec.P_reference8
2026: ,NULL,reference8
2027: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2027: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2023: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2024: ,p_event_in_rec.P_reference7 )
2025: ,decode(p_event_in_rec.P_reference8
2026: ,NULL,reference8
2027: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2028: ,p_event_in_rec.P_reference8 )
2029: ,decode(p_event_in_rec.P_reference9
2030: ,NULL,reference9
2031: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2031: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2027: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2028: ,p_event_in_rec.P_reference8 )
2029: ,decode(p_event_in_rec.P_reference9
2030: ,NULL,reference9
2031: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2032: ,p_event_in_rec.P_reference9 )
2033: ,decode(p_event_in_rec.P_reference10
2034: ,NULL,reference10
2035: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

Line 2035: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2031: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2032: ,p_event_in_rec.P_reference9 )
2033: ,decode(p_event_in_rec.P_reference10
2034: ,NULL,reference10
2035: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2036: ,p_event_in_rec.P_reference10 )
2037: --defaulting completion date
2038: ,decode(p_event_in_rec.P_completion_date
2039: ,NULL,completion_date

Line 2040: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,SYSDATE

2036: ,p_event_in_rec.P_reference10 )
2037: --defaulting completion date
2038: ,decode(p_event_in_rec.P_completion_date
2039: ,NULL,completion_date
2040: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,SYSDATE
2041: ,p_event_in_rec.P_completion_date)
2042: --Defaulting event type.
2043: ,decode(p_event_in_rec.P_event_type
2044: ,NULL,event_type

Line 2045: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,event_type

2041: ,p_event_in_rec.P_completion_date)
2042: --Defaulting event type.
2043: ,decode(p_event_in_rec.P_event_type
2044: ,NULL,event_type
2045: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,event_type
2046: ,p_event_in_rec.P_event_type)
2047: --Defaulting bill trans revenue and bill trans bill amounts
2048: ,decode(p_event_in_rec.P_bill_trans_rev_amount
2049: ,NULL,bill_trans_rev_amount

Line 2057: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL

2053: ,p_event_in_rec.P_bill_trans_bill_amount)
2054: --Defaulting task_id.
2055: ,decode(p_event_in_rec.p_task_number
2056: ,NULL,task_id
2057: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2058: ,P_task_id)
2059: ,decode(p_event_in_rec.p_description, null, description,
2060: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description, p_event_in_rec.p_description)
2061: ,record_version_number

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

2056: ,NULL,task_id
2057: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,NULL
2058: ,P_task_id)
2059: ,decode(p_event_in_rec.p_description, null, description,
2060: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description, p_event_in_rec.p_description)
2061: ,record_version_number
2062: ,decode(ADJUSTING_REVENUE_FLAG,'N', /* Added for bug 6863270 */
2063: decode(p_event_in_rec.p_bill_trans_bill_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_bill_amount,
2064: null, bill_trans_bill_amount, p_event_in_rec.p_bill_trans_bill_amount),0)

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

2059: ,decode(p_event_in_rec.p_description, null, description,
2060: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, description, p_event_in_rec.p_description)
2061: ,record_version_number
2062: ,decode(ADJUSTING_REVENUE_FLAG,'N', /* Added for bug 6863270 */
2063: decode(p_event_in_rec.p_bill_trans_bill_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_bill_amount,
2064: null, bill_trans_bill_amount, p_event_in_rec.p_bill_trans_bill_amount),0)
2065: ,decode(p_event_in_rec.p_bill_trans_rev_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_rev_amount,
2066: null, bill_trans_rev_amount, p_event_in_rec.p_bill_trans_rev_amount)
2067: Into p_event_in_rec.P_bill_hold_flag

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

2061: ,record_version_number
2062: ,decode(ADJUSTING_REVENUE_FLAG,'N', /* Added for bug 6863270 */
2063: decode(p_event_in_rec.p_bill_trans_bill_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_bill_amount,
2064: null, bill_trans_bill_amount, p_event_in_rec.p_bill_trans_bill_amount),0)
2065: ,decode(p_event_in_rec.p_bill_trans_rev_amount, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, bill_trans_rev_amount,
2066: null, bill_trans_rev_amount, p_event_in_rec.p_bill_trans_rev_amount)
2067: Into p_event_in_rec.P_bill_hold_flag
2068: ,p_event_in_rec.P_adjusting_revenue_flag
2069: ,p_inv_org_id

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

2097:
2098: --Unless the user updates with a valid description the
2099: --description gets defaulted with the event type.
2100: If (p_event_in_rec.P_description Is NULL
2101: OR p_event_in_rec.P_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2102: Then
2103: p_event_in_rec.P_description := p_event_in_rec.P_event_type;
2104: End If;
2105:

Line 2197: pa_interface_utils_pub.map_new_amg_msg

2193: IF nvl(l_record_version_number, 0) <> nvl(p_event_in_rec.P_record_version_number, 0)
2194: Then
2195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2196: THEN
2197: pa_interface_utils_pub.map_new_amg_msg
2198: ( p_old_message_code => 'PA_RECORD_CHANGED'
2199: ,p_msg_attribute => 'CHANGE'
2200: ,p_resize_flag => 'N'
2201: ,p_msg_context => 'EVENT'

Line 3093: pa_interface_utils_pub.map_new_amg_msg

3089: ,P_event_id =>l_event_id_out) ='N'
3090: Then
3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3092: THEN
3093: pa_interface_utils_pub.map_new_amg_msg
3094: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
3095: ,p_msg_attribute => 'CHANGE'
3096: ,p_resize_flag => 'N'
3097: ,p_msg_context => 'EVENT'

Line 3839: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3835: END IF;
3836: -- CHECK WHETHER MANDATORY INCOMING PARAMETER PRODUCT CODE EXIST
3837:
3838: IF (p_pm_product_code IS NULL)
3839: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3840: THEN
3841: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3842: THEN
3843: pa_interface_utils_pub.map_new_amg_msg

Line 3843: pa_interface_utils_pub.map_new_amg_msg

3839: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3840: THEN
3841: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3842: THEN
3843: pa_interface_utils_pub.map_new_amg_msg
3844: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
3845: ,p_msg_attribute => 'CHANGE'
3846: ,p_resize_flag => 'N'
3847: ,p_msg_context => 'EVENT'

Line 3868: And p_pm_event_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3864:
3865:
3866: --Deriving event_id from p_pm_event_reference.
3867: If(p_pm_event_reference Is NOT NULL
3868: And p_pm_event_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3869: Then
3870: While tot_recs <= G_event_tbl_count
3871: loop
3872: If (G_event_out_tbl(tot_recs).pm_event_reference = p_pm_event_reference )

Line 4064: pa_interface_utils_pub.map_new_amg_msg

4060:
4061: If PA_EVENT_UTILS.CHECK_EVENT_PROCESSED
4062: (P_event_id =>l_event_id) IN ('N','I','R')/*For Bug 7305416*/
4063: Then
4064: pa_interface_utils_pub.map_new_amg_msg
4065: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
4066: ,p_msg_attribute => 'CHANGE'
4067: ,p_resize_flag => 'N'
4068: ,p_msg_context => 'EVENT'