DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER_PAYMENT dependencies on OE_GLOBALS

Line 88: l_control_rec OE_GLOBALS.Control_Rec_Type;

84: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
85: )
86: IS
87: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
88: l_control_rec OE_GLOBALS.Control_Rec_Type;
89: l_return_status VARCHAR2(1);
90: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
91: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
92:

Line 103: OE_GLOBALS.G_UI_FLAG := TRUE;

99: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_PAYMENT.DEFAULT_ATTRIBUTES' , 1 ) ;
100: END IF;
101:
102: -- Set the UI flag
103: OE_GLOBALS.G_UI_FLAG := TRUE;
104:
105: -- Set control flags.
106:
107: l_control_rec.controlled_operation := TRUE;

Line 154: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

150: l_x_header_Payment_tbl(1).context := NULL;
151:
152: -- Set Operation to Create
153:
154: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
155:
156: -- Populate Header_Payment table
157:
158:

Line 238: OE_GLOBALS.G_UI_FLAG := FALSE;

234: ( p_Header_Payment_rec => l_x_Header_PAYMENT_tbl(1)
235: );
236:
237: -- Re-set the UI flag to FALSE
238: OE_GLOBALS.G_UI_FLAG := FALSE;
239:
240: -- Set return status.
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 259: OE_GLOBALS.G_UI_FLAG := FALSE;

255: EXCEPTION
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258:
259: OE_GLOBALS.G_UI_FLAG := FALSE;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: -- Get message count and data

Line 272: OE_GLOBALS.G_UI_FLAG := FALSE;

268: );
269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271:
272: OE_GLOBALS.G_UI_FLAG := FALSE;
273:
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275:
276: -- Get message count and data

Line 285: OE_GLOBALS.G_UI_FLAG := FALSE;

281: );
282:
283: WHEN OTHERS THEN
284:
285: OE_GLOBALS.G_UI_FLAG := FALSE;
286:
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288:
289: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 383: l_control_rec OE_GLOBALS.Control_Rec_Type;

379: l_Header_Payment_rec OE_Order_PUB.Header_PAYMENT_Rec_Type;
380: l_Header_Payment_val_rec OE_Order_PUB.Header_PAYMENT_Val_Rec_Type;
381: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
382: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
383: l_control_rec OE_GLOBALS.Control_Rec_Type;
384: l_return_status VARCHAR2(1);
385:
386: --
387: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 399: OE_GLOBALS.G_UI_FLAG := TRUE;

395: oe_debug_pub.add(' p_attr_id is : ' || p_attr_id);
396: END IF;
397:
398: -- Set the UI flag
399: OE_GLOBALS.G_UI_FLAG := TRUE;
400:
401: -- Set control flags.
402:
403: l_control_rec.controlled_operation := TRUE;

Line 489: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

485:
486: -- Set Operation.
487:
488: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN
489: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
490: ELSE
491: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
492: END IF;
493:

Line 491: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

487:
488: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN
489: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
490: ELSE
491: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
492: END IF;
493:
494: -- Populate Header_Payment table
495: l_header_Payment_rec:=l_x_Header_PAYMENT_Tbl(1);

Line 576: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute1,

572: );
573:
574: -- Return changed attributes.
575:
576: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute1,
577: l_Header_Payment_rec.attribute1)
578: THEN
579: x_attribute1 := l_x_header_Payment_tbl(1).attribute1;
580: END IF;

Line 582: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute2,

578: THEN
579: x_attribute1 := l_x_header_Payment_tbl(1).attribute1;
580: END IF;
581:
582: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute2,
583: l_Header_Payment_rec.attribute2)
584: THEN
585: x_attribute2 := l_x_Header_Payment_Tbl(1).attribute2;
586: END IF;

Line 588: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute3,

584: THEN
585: x_attribute2 := l_x_Header_Payment_Tbl(1).attribute2;
586: END IF;
587:
588: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute3,
589: l_Header_Payment_rec.attribute3)
590: THEN
591: x_attribute3 := l_x_Header_Payment_Tbl(1).attribute3;
592: END IF;

Line 594: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute4,

590: THEN
591: x_attribute3 := l_x_Header_Payment_Tbl(1).attribute3;
592: END IF;
593:
594: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute4,
595: l_Header_Payment_rec.attribute4)
596: THEN
597: x_attribute4 := l_x_Header_Payment_Tbl(1).attribute4;
598: END IF;

Line 600: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute5,

596: THEN
597: x_attribute4 := l_x_Header_Payment_Tbl(1).attribute4;
598: END IF;
599:
600: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute5,
601: l_Header_Payment_rec.attribute5)
602: THEN
603: x_attribute5 := l_x_Header_Payment_Tbl(1).attribute5;
604: END IF;

Line 606: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute6,

602: THEN
603: x_attribute5 := l_x_Header_Payment_Tbl(1).attribute5;
604: END IF;
605:
606: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute6,
607: l_Header_Payment_rec.attribute6)
608: THEN
609: x_attribute6 := l_x_Header_Payment_Tbl(1).attribute6;
610: END IF;

Line 612: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute7,

608: THEN
609: x_attribute6 := l_x_Header_Payment_Tbl(1).attribute6;
610: END IF;
611:
612: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute7,
613: l_Header_Payment_rec.attribute7)
614: THEN
615: x_attribute7 := l_x_Header_Payment_Tbl(1).attribute7;
616: END IF;

Line 618: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute8,

614: THEN
615: x_attribute7 := l_x_Header_Payment_Tbl(1).attribute7;
616: END IF;
617:
618: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute8,
619: l_Header_Payment_rec.attribute8)
620: THEN
621: x_attribute8 := l_x_Header_Payment_Tbl(1).attribute8;
622: END IF;

Line 624: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute9,

620: THEN
621: x_attribute8 := l_x_Header_Payment_Tbl(1).attribute8;
622: END IF;
623:
624: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).attribute9,
625: l_Header_Payment_rec.attribute9)
626: THEN
627: x_attribute9 := l_x_Header_Payment_Tbl(1).attribute9;
628: END IF;

Line 630: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute10,

626: THEN
627: x_attribute9 := l_x_Header_Payment_Tbl(1).attribute9;
628: END IF;
629:
630: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute10,
631: l_Header_Payment_rec.attribute10)
632: THEN
633: x_attribute10 := l_x_header_Payment_tbl(1).attribute10;
634: END IF;

Line 636: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute11,

632: THEN
633: x_attribute10 := l_x_header_Payment_tbl(1).attribute10;
634: END IF;
635:
636: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute11,
637: l_Header_Payment_rec.attribute11)
638: THEN
639: x_attribute11 := l_x_header_Payment_tbl(1).attribute11;
640: END IF;

Line 642: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute12,

638: THEN
639: x_attribute11 := l_x_header_Payment_tbl(1).attribute11;
640: END IF;
641:
642: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute12,
643: l_Header_Payment_rec.attribute12)
644: THEN
645: x_attribute12 := l_x_header_Payment_tbl(1).attribute12;
646: END IF;

Line 648: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute13,

644: THEN
645: x_attribute12 := l_x_header_Payment_tbl(1).attribute12;
646: END IF;
647:
648: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute13,
649: l_Header_Payment_rec.attribute13)
650: THEN
651: x_attribute13 := l_x_header_Payment_tbl(1).attribute13;
652: END IF;

Line 654: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute14,

650: THEN
651: x_attribute13 := l_x_header_Payment_tbl(1).attribute13;
652: END IF;
653:
654: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute14,
655: l_Header_Payment_rec.attribute14)
656: THEN
657: x_attribute14 := l_x_header_Payment_tbl(1).attribute14;
658: END IF;

Line 660: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute15,

656: THEN
657: x_attribute14 := l_x_header_Payment_tbl(1).attribute14;
658: END IF;
659:
660: IF NOT OE_GLOBALS.Equal(l_x_header_Payment_tbl(1).attribute15,
661: l_Header_Payment_rec.attribute15)
662: THEN
663: x_attribute15 := l_x_header_Payment_tbl(1).attribute15;
664: END IF;

Line 666: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).context,

662: THEN
663: x_attribute15 := l_x_header_Payment_tbl(1).attribute15;
664: END IF;
665:
666: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).context,
667: l_Header_Payment_rec.context)
668: THEN
669: x_context := l_x_Header_Payment_Tbl(1).context;
670: END IF;

Line 672: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_number,

668: THEN
669: x_context := l_x_Header_Payment_Tbl(1).context;
670: END IF;
671:
672: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_number,
673: l_Header_Payment_rec.payment_number)
674: THEN
675: x_payment_number := l_x_Header_Payment_Tbl(1).payment_number;
676: END IF;

Line 678: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).header_id,

674: THEN
675: x_payment_number := l_x_Header_Payment_Tbl(1).payment_number;
676: END IF;
677:
678: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).header_id,
679: l_Header_Payment_rec.header_id)
680: THEN
681: x_header_id := l_x_Header_Payment_Tbl(1).header_id;
682: END IF;

Line 684: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).line_id,

680: THEN
681: x_header_id := l_x_Header_Payment_Tbl(1).header_id;
682: END IF;
683:
684: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).line_id,
685: l_Header_Payment_rec.line_id)
686: THEN
687: x_line_id := l_x_Header_Payment_Tbl(1).line_id;
688: END IF;

Line 690: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).check_number,

686: THEN
687: x_line_id := l_x_Header_Payment_Tbl(1).line_id;
688: END IF;
689:
690: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).check_number,
691: l_Header_Payment_rec.check_number)
692: THEN
693: x_check_number := l_x_Header_Payment_Tbl(1).check_number;
694: END IF;

Line 696: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_approval_code,

692: THEN
693: x_check_number := l_x_Header_Payment_Tbl(1).check_number;
694: END IF;
695:
696: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_approval_code,
697: l_Header_Payment_rec.credit_card_approval_code)
698: THEN
699: x_credit_card_approval_code := l_x_Header_Payment_Tbl(1).credit_card_approval_code;
700: END IF;

Line 702: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_approval_date,

698: THEN
699: x_credit_card_approval_code := l_x_Header_Payment_Tbl(1).credit_card_approval_code;
700: END IF;
701:
702: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_approval_date,
703: l_Header_Payment_rec.credit_card_approval_date)
704: THEN
705: x_credit_card_approval_date := l_x_Header_Payment_Tbl(1).credit_card_approval_date;
706: END IF;

Line 708: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_code,

704: THEN
705: x_credit_card_approval_date := l_x_Header_Payment_Tbl(1).credit_card_approval_date;
706: END IF;
707:
708: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_code,
709: l_Header_Payment_rec.credit_card_code)
710: THEN
711: x_credit_card_code := l_x_Header_Payment_Tbl(1).credit_card_code;
712: END IF;

Line 714: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_expiration_date,

710: THEN
711: x_credit_card_code := l_x_Header_Payment_Tbl(1).credit_card_code;
712: END IF;
713:
714: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_expiration_date,
715: l_Header_Payment_rec.credit_card_expiration_date)
716: THEN
717: x_credit_card_expiration_date := l_x_Header_Payment_Tbl(1).credit_card_expiration_date;
718: END IF;

Line 720: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_holder_name,

716: THEN
717: x_credit_card_expiration_date := l_x_Header_Payment_Tbl(1).credit_card_expiration_date;
718: END IF;
719:
720: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).credit_card_holder_name,
721: l_Header_Payment_rec.credit_card_holder_name)
722: THEN
723: x_credit_card_holder_name := l_x_Header_Payment_Tbl(1).credit_card_holder_name;
724: END IF;

Line 729: IF NOT OE_GLOBALS.Is_Same_Credit_Card(l_Header_Payment_rec.credit_card_number,

725: --R12 CC Encryption
726: --Since the credit card numbers are encrypted, passing both the credit card
727: --numbers as well as instrument ids to determine if both the old and new
728: --values point to the same credit card number.
729: IF NOT OE_GLOBALS.Is_Same_Credit_Card(l_Header_Payment_rec.credit_card_number,
730: l_x_Header_Payment_Tbl(1).credit_card_number,
731: l_Header_Payment_rec.cc_instrument_id,
732: l_x_Header_Payment_Tbl(1).cc_instrument_id)
733: THEN

Line 737: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_level_code,

733: THEN
734: x_credit_card_number := l_x_Header_Payment_Tbl(1).credit_card_number;
735: END IF;
736:
737: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_level_code,
738: l_Header_Payment_rec.payment_level_code)
739: THEN
740: x_payment_level_code := l_x_Header_Payment_Tbl(1).payment_level_code;
741: END IF;

Line 743: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).commitment_applied_amount,

739: THEN
740: x_payment_level_code := l_x_Header_Payment_Tbl(1).payment_level_code;
741: END IF;
742:
743: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).commitment_applied_amount,
744: l_Header_Payment_rec.commitment_applied_amount)
745: THEN
746: x_commitment_applied_amount := l_x_Header_Payment_Tbl(1).commitment_applied_amount;
747: END IF;

Line 749: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).commitment_interfaced_amount,

745: THEN
746: x_commitment_applied_amount := l_x_Header_Payment_Tbl(1).commitment_applied_amount;
747: END IF;
748:
749: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).commitment_interfaced_amount,
750: l_Header_Payment_rec.commitment_interfaced_amount)
751: THEN
752: x_commitment_interfaced_amount := l_x_Header_Payment_Tbl(1).commitment_interfaced_amount;
753: END IF;

Line 755: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_amount,

751: THEN
752: x_commitment_interfaced_amount := l_x_Header_Payment_Tbl(1).commitment_interfaced_amount;
753: END IF;
754:
755: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_amount,
756: l_Header_Payment_rec.payment_amount)
757: THEN
758: x_payment_amount := l_x_Header_Payment_Tbl(1).payment_amount;
759: END IF;

Line 761: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_collection_event,

757: THEN
758: x_payment_amount := l_x_Header_Payment_Tbl(1).payment_amount;
759: END IF;
760:
761: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_collection_event,
762: l_Header_Payment_rec.payment_collection_event)
763: THEN
764: x_payment_collection_event := l_x_Header_Payment_Tbl(1).payment_collection_event;
765: x_pmt_collection_event_name := l_Header_Payment_Val_Rec.payment_collection_event_name;

Line 768: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).defer_payment_processing_flag,

764: x_payment_collection_event := l_x_Header_Payment_Tbl(1).payment_collection_event;
765: x_pmt_collection_event_name := l_Header_Payment_Val_Rec.payment_collection_event_name;
766: END IF;
767:
768: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).defer_payment_processing_flag,
769: l_Header_Payment_rec.defer_payment_processing_flag)
770: THEN
771: x_defer_processing_flag := l_x_Header_Payment_Tbl(1).defer_payment_processing_flag;
772: END IF;

Line 774: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_trx_id,

770: THEN
771: x_defer_processing_flag := l_x_Header_Payment_Tbl(1).defer_payment_processing_flag;
772: END IF;
773:
774: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_trx_id,
775: l_Header_Payment_rec.payment_trx_id)
776: THEN
777: x_payment_trx_id := l_x_Header_Payment_Tbl(1).payment_trx_id;
778: END IF;

Line 780: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_type_code,

776: THEN
777: x_payment_trx_id := l_x_Header_Payment_Tbl(1).payment_trx_id;
778: END IF;
779:
780: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_type_code,
781: l_Header_Payment_rec.payment_type_code)
782: THEN
783: x_payment_type_code := l_x_Header_Payment_Tbl(1).payment_type_code;
784: x_payment_type := l_Header_Payment_Val_rec.payment_type;

Line 787: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_set_id,

783: x_payment_type_code := l_x_Header_Payment_Tbl(1).payment_type_code;
784: x_payment_type := l_Header_Payment_Val_rec.payment_type;
785: END IF;
786:
787: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).payment_set_id,
788: l_Header_Payment_rec.payment_set_id)
789: THEN
790: x_payment_set_id := l_x_Header_Payment_Tbl(1).payment_set_id;
791: END IF;

Line 793: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).prepaid_amount,

789: THEN
790: x_payment_set_id := l_x_Header_Payment_Tbl(1).payment_set_id;
791: END IF;
792:
793: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).prepaid_amount,
794: l_Header_Payment_rec.prepaid_amount)
795: THEN
796: x_prepaid_amount := l_x_Header_Payment_Tbl(1).prepaid_amount;
797: END IF;

Line 799: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).receipt_method_id,

795: THEN
796: x_prepaid_amount := l_x_Header_Payment_Tbl(1).prepaid_amount;
797: END IF;
798:
799: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).receipt_method_id,
800: l_Header_Payment_rec.receipt_method_id)
801: THEN
802: x_receipt_method_id := l_x_Header_Payment_Tbl(1).receipt_method_id;
803: x_receipt_method := l_Header_Payment_Val_rec.receipt_method;

Line 807: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).instrument_security_code,

803: x_receipt_method := l_Header_Payment_Val_rec.receipt_method;
804: END IF;
805:
806: --R12 CC Encryption
807: IF NOT OE_GLOBALS.Equal(l_x_Header_Payment_Tbl(1).instrument_security_code,
808: l_Header_Payment_rec.instrument_security_code) THEN
809: x_instrument_security_code := l_x_Header_Payment_Tbl(1).instrument_security_code;
810: END IF;
811: --R12 CC Encryption

Line 845: OE_GLOBALS.G_UI_FLAG := FALSE;

841: ( p_Header_Payment_rec => l_x_Header_PAYMENT_tbl(1)
842: );
843:
844: -- Re-set the UI flag to FALSE
845: OE_GLOBALS.G_UI_FLAG := FALSE;
846:
847: -- Set return status.
848:
849: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 866: OE_GLOBALS.G_UI_FLAG := FALSE;

862: EXCEPTION
863:
864: WHEN FND_API.G_EXC_ERROR THEN
865:
866: OE_GLOBALS.G_UI_FLAG := FALSE;
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: -- Get message count and data

Line 879: OE_GLOBALS.G_UI_FLAG := FALSE;

875: );
876:
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878:
879: OE_GLOBALS.G_UI_FLAG := FALSE;
880:
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
882:
883: -- Get message count and data

Line 892: OE_GLOBALS.G_UI_FLAG := FALSE;

888: );
889:
890: WHEN OTHERS THEN
891:
892: OE_GLOBALS.G_UI_FLAG := FALSE;
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
895:
896: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1093: l_control_rec OE_GLOBALS.Control_Rec_Type;

1089: , x_lock_control OUT NOCOPY NUMBER
1090: )
1091: IS
1092: l_x_old_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1093: l_control_rec OE_GLOBALS.Control_Rec_Type;
1094: l_return_status VARCHAR2(1);
1095: l_x_Header_Payment_tbl OE_Order_PUB.Header_PAYMENT_Tbl_Type;
1096:
1097: --

Line 1107: OE_GLOBALS.G_UI_FLAG := TRUE;

1103: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_Payment.VALIDATE_AND_WRITE' , 1 ) ;
1104: END IF;
1105:
1106: -- Set the UI flag
1107: OE_GLOBALS.G_UI_FLAG := TRUE;
1108:
1109: -- Set control flags.
1110:
1111: l_control_rec.controlled_operation := TRUE;

Line 1144: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

1140:
1141: -- Set Operation.
1142:
1143: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN
1144: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1145: ELSE
1146: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1147: END IF;
1148:

Line 1146: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

1142:
1143: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN
1144: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1145: ELSE
1146: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1147: END IF;
1148:
1149: -- Populate Header_Payment table
1150:

Line 1188: OE_GLOBALS.G_UI_FLAG := FALSE;

1184: -- l_old_Header_Payment_rec.operation := l_Header_PAYMENT_rec.operation;
1185:
1186:
1187: -- Re-set the UI flag to FALSE
1188: OE_GLOBALS.G_UI_FLAG := FALSE;
1189:
1190: -- Set return status.
1191:
1192: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1209: OE_GLOBALS.G_UI_FLAG := FALSE;

1205: EXCEPTION
1206:
1207: WHEN FND_API.G_EXC_ERROR THEN
1208:
1209: OE_GLOBALS.G_UI_FLAG := FALSE;
1210:
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212:
1213: -- Get message count and data

Line 1222: OE_GLOBALS.G_UI_FLAG := FALSE;

1218: );
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221:
1222: OE_GLOBALS.G_UI_FLAG := FALSE;
1223:
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1225:
1226: -- Get message count and data

Line 1235: OE_GLOBALS.G_UI_FLAG := FALSE;

1231: );
1232:
1233: WHEN OTHERS THEN
1234:
1235: OE_GLOBALS.G_UI_FLAG := FALSE;
1236:
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1238:
1239: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1267: l_control_rec OE_GLOBALS.Control_Rec_Type;

1263: , p_payment_number IN NUMBER
1264: , p_header_id IN NUMBER
1265: )
1266: IS
1267: l_control_rec OE_GLOBALS.Control_Rec_Type;
1268: l_return_status VARCHAR2(1);
1269: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1270: l_x_Old_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1271:

Line 1282: OE_GLOBALS.G_UI_FLAG := TRUE;

1278: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_Payment.DELETE_ROW' , 1 ) ;
1279: END IF;
1280:
1281: -- Set the UI flag
1282: OE_GLOBALS.G_UI_FLAG := TRUE;
1283:
1284: -- Set control flags.
1285:
1286: l_control_rec.controlled_operation := TRUE;

Line 1312: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;

1308: );
1309:
1310: -- Set Operation.
1311:
1312: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;
1313:
1314: -- Populate Header_Payment table
1315:
1316:

Line 1341: OE_GLOBALS.G_UI_FLAG := FALSE;

1337:
1338: Clear_Header_Payment;
1339:
1340: -- Re-set the UI flag to FALSE
1341: OE_GLOBALS.G_UI_FLAG := FALSE;
1342:
1343: -- Set return status.
1344:
1345: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1362: OE_GLOBALS.G_UI_FLAG := FALSE;

1358: EXCEPTION
1359:
1360: WHEN FND_API.G_EXC_ERROR THEN
1361:
1362: OE_GLOBALS.G_UI_FLAG := FALSE;
1363:
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365:
1366: -- Get message count and data

Line 1375: OE_GLOBALS.G_UI_FLAG := FALSE;

1371: );
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374:
1375: OE_GLOBALS.G_UI_FLAG := FALSE;
1376:
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378:
1379: -- Get message count and data

Line 1388: OE_GLOBALS.G_UI_FLAG := FALSE;

1384: );
1385:
1386: WHEN OTHERS THEN
1387:
1388: OE_GLOBALS.G_UI_FLAG := FALSE;
1389:
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1391:
1392: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1420: l_control_rec OE_GLOBALS.Control_Rec_Type;

1416: )
1417: IS
1418: l_return_status VARCHAR2(1);
1419: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1420: l_control_rec OE_GLOBALS.Control_Rec_Type;
1421: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1422: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1423: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1424: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1455: OE_GLOBALS.G_UI_FLAG := TRUE;

1451: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_PAYMENT.PROCESS_ENTITY' , 1 ) ;
1452: END IF;
1453:
1454: -- Set the UI flag
1455: OE_GLOBALS.G_UI_FLAG := TRUE;
1456:
1457: -- Set control flags.
1458:
1459: l_control_rec.controlled_operation := TRUE;

Line 1461: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_HEADER_Payment;

1457: -- Set control flags.
1458:
1459: l_control_rec.controlled_operation := TRUE;
1460: l_control_rec.process := TRUE;
1461: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_HEADER_Payment;
1462:
1463: l_control_rec.check_security := FALSE;
1464: l_control_rec.clear_dependents := FALSE;
1465: l_control_rec.default_attributes := FALSE;

Line 1518: OE_GLOBALS.G_UI_FLAG := FALSE;

1514: END IF;
1515:
1516:
1517: -- Re-set the UI flag to FALSE
1518: OE_GLOBALS.G_UI_FLAG := FALSE;
1519:
1520: -- Set return status.
1521:
1522: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1539: OE_GLOBALS.G_UI_FLAG := FALSE;

1535: EXCEPTION
1536:
1537: WHEN FND_API.G_EXC_ERROR THEN
1538:
1539: OE_GLOBALS.G_UI_FLAG := FALSE;
1540:
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542:
1543: -- Get message count and data

Line 1552: OE_GLOBALS.G_UI_FLAG := FALSE;

1548: );
1549:
1550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1551:
1552: OE_GLOBALS.G_UI_FLAG := FALSE;
1553:
1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1555:
1556: -- Get message count and data

Line 1565: OE_GLOBALS.G_UI_FLAG := FALSE;

1561: );
1562:
1563: WHEN OTHERS THEN
1564:
1565: OE_GLOBALS.G_UI_FLAG := FALSE;
1566:
1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1568:
1569: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1612: l_x_Header_Payment_rec.operation := OE_GLOBALS.G_OPR_LOCK;

1608: END IF;
1609:
1610: -- Load Header_Payment record
1611:
1612: l_x_Header_Payment_rec.operation := OE_GLOBALS.G_OPR_LOCK;
1613: l_x_Header_Payment_rec.payment_number := p_payment_number ;
1614: l_x_Header_Payment_rec.header_id := p_header_id ;
1615: l_x_Header_Payment_rec.lock_control := p_lock_control;
1616: