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 1091: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

Line 1105: OE_GLOBALS.G_UI_FLAG := TRUE;

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

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

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

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

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

Line 1186: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1207: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1220: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1233: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1265: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

Line 1280: OE_GLOBALS.G_UI_FLAG := TRUE;

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

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

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

Line 1339: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1360: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1373: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1386: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1418: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

Line 1453: OE_GLOBALS.G_UI_FLAG := TRUE;

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

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

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

Line 1516: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1537: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1550: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 1563: OE_GLOBALS.G_UI_FLAG := FALSE;

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

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

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