DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_PAYMENT dependencies on OE_GLOBALS

Line 89: l_control_rec OE_GLOBALS.Control_Rec_Type;

85: , x_instrument_security_code OUT NOCOPY VARCHAR2 --R12 CC Encryption
86: )
87: IS
88: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
89: l_control_rec OE_GLOBALS.Control_Rec_Type;
90: l_return_status VARCHAR2(1);
91: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
92: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
93:

Line 118: OE_GLOBALS.G_UI_FLAG := TRUE;

114:
115: END;
116:
117: -- Set the UI flag
118: OE_GLOBALS.G_UI_FLAG := TRUE;
119:
120: -- Set control flags.
121:
122: l_control_rec.controlled_operation := TRUE;

Line 170: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

166: l_x_line_Payment_tbl(1).context := NULL;
167:
168: -- Set Operation to Create
169:
170: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
171:
172: -- Populate Line_Payment table
173:
174:

Line 255: OE_GLOBALS.G_UI_FLAG := FALSE;

251: ( p_Line_Payment_rec => l_x_Line_PAYMENT_tbl(1)
252: );
253:
254: -- Re-set the UI flag to FALSE
255: OE_GLOBALS.G_UI_FLAG := FALSE;
256:
257: -- Set return status.
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 276: OE_GLOBALS.G_UI_FLAG := FALSE;

272: EXCEPTION
273:
274: WHEN FND_API.G_EXC_ERROR THEN
275:
276: OE_GLOBALS.G_UI_FLAG := FALSE;
277:
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: -- Get message count and data

Line 289: OE_GLOBALS.G_UI_FLAG := FALSE;

285: );
286:
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288:
289: OE_GLOBALS.G_UI_FLAG := FALSE;
290:
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292:
293: -- Get message count and data

Line 302: OE_GLOBALS.G_UI_FLAG := FALSE;

298: );
299:
300: WHEN OTHERS THEN
301:
302: OE_GLOBALS.G_UI_FLAG := FALSE;
303:
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305:
306: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 401: l_control_rec OE_GLOBALS.Control_Rec_Type;

397: l_Line_Payment_rec OE_Order_PUB.Line_PAYMENT_Rec_Type;
398: l_Line_Payment_val_rec OE_Order_PUB.Line_PAYMENT_Val_Rec_Type;
399: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
400: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
401: l_control_rec OE_GLOBALS.Control_Rec_Type;
402: l_return_status VARCHAR2(1);
403:
404: --
405: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 416: OE_GLOBALS.G_UI_FLAG := TRUE;

412: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_PAYMENT.CHANGE_ATTRIBUTE' , 1 ) ;
413: END IF;
414:
415: -- Set the UI flag
416: OE_GLOBALS.G_UI_FLAG := TRUE;
417:
418: -- Set control flags.
419:
420: l_control_rec.controlled_operation := TRUE;

Line 509: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

505:
506: -- Set Operation.
507:
508: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN
509: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
510: ELSE
511: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
512: END IF;
513:

Line 511: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

507:
508: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN
509: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
510: ELSE
511: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
512: END IF;
513:
514: -- Populate Line_Payment table
515: l_line_Payment_rec:=l_x_Line_PAYMENT_Tbl(1);

Line 593: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute1,

589: );
590:
591: -- Return changed attributes.
592:
593: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute1,
594: l_Line_Payment_rec.attribute1)
595: THEN
596: x_attribute1 := l_x_line_Payment_tbl(1).attribute1;
597: END IF;

Line 599: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute2,

595: THEN
596: x_attribute1 := l_x_line_Payment_tbl(1).attribute1;
597: END IF;
598:
599: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute2,
600: l_Line_Payment_rec.attribute2)
601: THEN
602: x_attribute2 := l_x_Line_Payment_Tbl(1).attribute2;
603: END IF;

Line 605: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute3,

601: THEN
602: x_attribute2 := l_x_Line_Payment_Tbl(1).attribute2;
603: END IF;
604:
605: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute3,
606: l_Line_Payment_rec.attribute3)
607: THEN
608: x_attribute3 := l_x_Line_Payment_Tbl(1).attribute3;
609: END IF;

Line 611: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute4,

607: THEN
608: x_attribute3 := l_x_Line_Payment_Tbl(1).attribute3;
609: END IF;
610:
611: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute4,
612: l_Line_Payment_rec.attribute4)
613: THEN
614: x_attribute4 := l_x_Line_Payment_Tbl(1).attribute4;
615: END IF;

Line 617: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute5,

613: THEN
614: x_attribute4 := l_x_Line_Payment_Tbl(1).attribute4;
615: END IF;
616:
617: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute5,
618: l_Line_Payment_rec.attribute5)
619: THEN
620: x_attribute5 := l_x_Line_Payment_Tbl(1).attribute5;
621: END IF;

Line 623: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute6,

619: THEN
620: x_attribute5 := l_x_Line_Payment_Tbl(1).attribute5;
621: END IF;
622:
623: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute6,
624: l_Line_Payment_rec.attribute6)
625: THEN
626: x_attribute6 := l_x_Line_Payment_Tbl(1).attribute6;
627: END IF;

Line 629: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute7,

625: THEN
626: x_attribute6 := l_x_Line_Payment_Tbl(1).attribute6;
627: END IF;
628:
629: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute7,
630: l_Line_Payment_rec.attribute7)
631: THEN
632: x_attribute7 := l_x_Line_Payment_Tbl(1).attribute7;
633: END IF;

Line 635: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute8,

631: THEN
632: x_attribute7 := l_x_Line_Payment_Tbl(1).attribute7;
633: END IF;
634:
635: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute8,
636: l_Line_Payment_rec.attribute8)
637: THEN
638: x_attribute8 := l_x_Line_Payment_Tbl(1).attribute8;
639: END IF;

Line 641: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute9,

637: THEN
638: x_attribute8 := l_x_Line_Payment_Tbl(1).attribute8;
639: END IF;
640:
641: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).attribute9,
642: l_Line_Payment_rec.attribute9)
643: THEN
644: x_attribute9 := l_x_Line_Payment_Tbl(1).attribute9;
645: END IF;

Line 647: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute10,

643: THEN
644: x_attribute9 := l_x_Line_Payment_Tbl(1).attribute9;
645: END IF;
646:
647: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute10,
648: l_Line_Payment_rec.attribute10)
649: THEN
650: x_attribute10 := l_x_line_Payment_tbl(1).attribute10;
651: END IF;

Line 653: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute11,

649: THEN
650: x_attribute10 := l_x_line_Payment_tbl(1).attribute10;
651: END IF;
652:
653: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute11,
654: l_Line_Payment_rec.attribute11)
655: THEN
656: x_attribute11 := l_x_line_Payment_tbl(1).attribute11;
657: END IF;

Line 659: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute12,

655: THEN
656: x_attribute11 := l_x_line_Payment_tbl(1).attribute11;
657: END IF;
658:
659: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute12,
660: l_Line_Payment_rec.attribute12)
661: THEN
662: x_attribute12 := l_x_line_Payment_tbl(1).attribute12;
663: END IF;

Line 665: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute13,

661: THEN
662: x_attribute12 := l_x_line_Payment_tbl(1).attribute12;
663: END IF;
664:
665: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute13,
666: l_Line_Payment_rec.attribute13)
667: THEN
668: x_attribute13 := l_x_line_Payment_tbl(1).attribute13;
669: END IF;

Line 671: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute14,

667: THEN
668: x_attribute13 := l_x_line_Payment_tbl(1).attribute13;
669: END IF;
670:
671: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute14,
672: l_Line_Payment_rec.attribute14)
673: THEN
674: x_attribute14 := l_x_line_Payment_tbl(1).attribute14;
675: END IF;

Line 677: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute15,

673: THEN
674: x_attribute14 := l_x_line_Payment_tbl(1).attribute14;
675: END IF;
676:
677: IF NOT OE_GLOBALS.Equal(l_x_line_Payment_tbl(1).attribute15,
678: l_Line_Payment_rec.attribute15)
679: THEN
680: x_attribute15 := l_x_line_Payment_tbl(1).attribute15;
681: END IF;

Line 683: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).context,

679: THEN
680: x_attribute15 := l_x_line_Payment_tbl(1).attribute15;
681: END IF;
682:
683: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).context,
684: l_Line_Payment_rec.context)
685: THEN
686: x_context := l_x_Line_Payment_Tbl(1).context;
687: END IF;

Line 689: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_number,

685: THEN
686: x_context := l_x_Line_Payment_Tbl(1).context;
687: END IF;
688:
689: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_number,
690: l_Line_Payment_rec.payment_number)
691: THEN
692: x_payment_number := l_x_Line_Payment_Tbl(1).payment_number;
693: END IF;

Line 695: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).header_id,

691: THEN
692: x_payment_number := l_x_Line_Payment_Tbl(1).payment_number;
693: END IF;
694:
695: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).header_id,
696: l_Line_Payment_rec.header_id)
697: THEN
698: x_header_id := l_x_Line_Payment_Tbl(1).header_id;
699: END IF;

Line 701: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).line_id,

697: THEN
698: x_header_id := l_x_Line_Payment_Tbl(1).header_id;
699: END IF;
700:
701: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).line_id,
702: l_Line_Payment_rec.line_id)
703: THEN
704: x_line_id := l_x_Line_Payment_Tbl(1).line_id;
705: END IF;

Line 707: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).check_number,

703: THEN
704: x_line_id := l_x_Line_Payment_Tbl(1).line_id;
705: END IF;
706:
707: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).check_number,
708: l_Line_Payment_rec.check_number)
709: THEN
710: x_check_number := l_x_Line_Payment_Tbl(1).check_number;
711: END IF;

Line 713: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_approval_code,

709: THEN
710: x_check_number := l_x_Line_Payment_Tbl(1).check_number;
711: END IF;
712:
713: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_approval_code,
714: l_Line_Payment_rec.credit_card_approval_code)
715: THEN
716: x_credit_card_approval_code := l_x_Line_Payment_Tbl(1).credit_card_approval_code;
717: END IF;

Line 719: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_approval_date,

715: THEN
716: x_credit_card_approval_code := l_x_Line_Payment_Tbl(1).credit_card_approval_code;
717: END IF;
718:
719: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_approval_date,
720: l_Line_Payment_rec.credit_card_approval_date)
721: THEN
722: x_credit_card_approval_date := l_x_Line_Payment_Tbl(1).credit_card_approval_date;
723: END IF;

Line 725: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_code,

721: THEN
722: x_credit_card_approval_date := l_x_Line_Payment_Tbl(1).credit_card_approval_date;
723: END IF;
724:
725: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_code,
726: l_Line_Payment_rec.credit_card_code)
727: THEN
728: x_credit_card_code := l_x_Line_Payment_Tbl(1).credit_card_code;
729: END IF;

Line 731: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_expiration_date,

727: THEN
728: x_credit_card_code := l_x_Line_Payment_Tbl(1).credit_card_code;
729: END IF;
730:
731: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_expiration_date,
732: l_Line_Payment_rec.credit_card_expiration_date)
733: THEN
734: x_credit_card_expiration_date := l_x_Line_Payment_Tbl(1).credit_card_expiration_date;
735: END IF;

Line 737: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_holder_name,

733: THEN
734: x_credit_card_expiration_date := l_x_Line_Payment_Tbl(1).credit_card_expiration_date;
735: END IF;
736:
737: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).credit_card_holder_name,
738: l_Line_Payment_rec.credit_card_holder_name)
739: THEN
740: x_credit_card_holder_name := l_x_Line_Payment_Tbl(1).credit_card_holder_name;
741: END IF;

Line 743: IF NOT OE_GLOBALS.Is_Same_Credit_Card(l_Line_Payment_rec.credit_card_number,

739: THEN
740: x_credit_card_holder_name := l_x_Line_Payment_Tbl(1).credit_card_holder_name;
741: END IF;
742:
743: IF NOT OE_GLOBALS.Is_Same_Credit_Card(l_Line_Payment_rec.credit_card_number,
744: l_x_Line_Payment_Tbl(1).credit_card_number,
745: l_Line_Payment_rec.cc_instrument_id,
746: l_x_Line_Payment_Tbl(1).cc_instrument_id)
747: THEN

Line 751: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_level_code,

747: THEN
748: x_credit_card_number := l_x_Line_Payment_Tbl(1).credit_card_number;
749: END IF;
750:
751: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_level_code,
752: l_Line_Payment_rec.payment_level_code)
753: THEN
754: x_payment_level_code := l_x_Line_Payment_Tbl(1).payment_level_code;
755: END IF;

Line 757: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).commitment_applied_amount,

753: THEN
754: x_payment_level_code := l_x_Line_Payment_Tbl(1).payment_level_code;
755: END IF;
756:
757: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).commitment_applied_amount,
758: l_Line_Payment_rec.commitment_applied_amount)
759: THEN
760: x_commitment_applied_amount := l_x_Line_Payment_Tbl(1).commitment_applied_amount;
761: END IF;

Line 763: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).commitment_interfaced_amount,

759: THEN
760: x_commitment_applied_amount := l_x_Line_Payment_Tbl(1).commitment_applied_amount;
761: END IF;
762:
763: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).commitment_interfaced_amount,
764: l_Line_Payment_rec.commitment_interfaced_amount)
765: THEN
766: x_commitment_interfaced_amount := l_x_Line_Payment_Tbl(1).commitment_interfaced_amount;
767: END IF;

Line 769: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_amount,

765: THEN
766: x_commitment_interfaced_amount := l_x_Line_Payment_Tbl(1).commitment_interfaced_amount;
767: END IF;
768:
769: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_amount,
770: l_Line_Payment_rec.payment_amount)
771: THEN
772: x_payment_amount := l_x_Line_Payment_Tbl(1).payment_amount;
773: END IF;

Line 775: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_collection_event,

771: THEN
772: x_payment_amount := l_x_Line_Payment_Tbl(1).payment_amount;
773: END IF;
774:
775: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_collection_event,
776: l_Line_Payment_rec.payment_collection_event)
777: THEN
778: x_payment_collection_event := l_x_Line_Payment_Tbl(1).payment_collection_event;
779: x_pmt_collection_event_name := l_Line_Payment_Val_Rec.payment_collection_event_name;

Line 782: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).defer_payment_processing_flag,

778: x_payment_collection_event := l_x_Line_Payment_Tbl(1).payment_collection_event;
779: x_pmt_collection_event_name := l_Line_Payment_Val_Rec.payment_collection_event_name;
780: END IF;
781:
782: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).defer_payment_processing_flag,
783: l_Line_Payment_rec.defer_payment_processing_flag)
784: THEN
785: x_defer_processing_flag := l_x_Line_Payment_Tbl(1).defer_payment_processing_flag;
786: END IF;

Line 788: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_trx_id,

784: THEN
785: x_defer_processing_flag := l_x_Line_Payment_Tbl(1).defer_payment_processing_flag;
786: END IF;
787:
788: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_trx_id,
789: l_Line_Payment_rec.payment_trx_id)
790: THEN
791: x_payment_trx_id := l_x_Line_Payment_Tbl(1).payment_trx_id;
792: END IF;

Line 794: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_type_code,

790: THEN
791: x_payment_trx_id := l_x_Line_Payment_Tbl(1).payment_trx_id;
792: END IF;
793:
794: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_type_code,
795: l_Line_Payment_rec.payment_type_code)
796: THEN
797: x_payment_type_code := l_x_Line_Payment_Tbl(1).payment_type_code;
798: x_payment_type := l_Line_Payment_Val_rec.payment_type;

Line 801: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_set_id,

797: x_payment_type_code := l_x_Line_Payment_Tbl(1).payment_type_code;
798: x_payment_type := l_Line_Payment_Val_rec.payment_type;
799: END IF;
800:
801: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).payment_set_id,
802: l_Line_Payment_rec.payment_set_id)
803: THEN
804: x_payment_set_id := l_x_Line_Payment_Tbl(1).payment_set_id;
805: END IF;

Line 807: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).prepaid_amount,

803: THEN
804: x_payment_set_id := l_x_Line_Payment_Tbl(1).payment_set_id;
805: END IF;
806:
807: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).prepaid_amount,
808: l_Line_Payment_rec.prepaid_amount)
809: THEN
810: x_prepaid_amount := l_x_Line_Payment_Tbl(1).prepaid_amount;
811: END IF;

Line 813: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).receipt_method_id,

809: THEN
810: x_prepaid_amount := l_x_Line_Payment_Tbl(1).prepaid_amount;
811: END IF;
812:
813: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).receipt_method_id,
814: l_Line_Payment_rec.receipt_method_id)
815: THEN
816: x_receipt_method_id := l_x_Line_Payment_Tbl(1).receipt_method_id;
817: x_receipt_method := l_Line_Payment_Val_rec.receipt_method;

Line 821: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).instrument_security_code,

817: x_receipt_method := l_Line_Payment_Val_rec.receipt_method;
818: END IF;
819:
820: --R12 CC Encryption
821: IF NOT OE_GLOBALS.Equal(l_x_Line_Payment_Tbl(1).instrument_security_code,
822: l_Line_Payment_rec.instrument_security_code) THEN
823: x_instrument_security_code := l_x_Line_Payment_Tbl(1).instrument_security_code;
824: END IF;
825:

Line 858: OE_GLOBALS.G_UI_FLAG := FALSE;

854: ( p_Line_Payment_rec => l_x_Line_PAYMENT_tbl(1)
855: );
856:
857: -- Re-set the UI flag to FALSE
858: OE_GLOBALS.G_UI_FLAG := FALSE;
859:
860: -- Set return status.
861:
862: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 879: OE_GLOBALS.G_UI_FLAG := FALSE;

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

Line 892: OE_GLOBALS.G_UI_FLAG := FALSE;

888: );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891:
892: OE_GLOBALS.G_UI_FLAG := FALSE;
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
895:
896: -- Get message count and data

Line 905: OE_GLOBALS.G_UI_FLAG := FALSE;

901: );
902:
903: WHEN OTHERS THEN
904:
905: OE_GLOBALS.G_UI_FLAG := FALSE;
906:
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908:
909: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1105: l_control_rec OE_GLOBALS.Control_Rec_Type;

1101: , x_lock_control OUT NOCOPY NUMBER
1102: )
1103: IS
1104: l_x_old_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1105: l_control_rec OE_GLOBALS.Control_Rec_Type;
1106: l_return_status VARCHAR2(1);
1107: l_x_Line_Payment_tbl OE_Order_PUB.Line_PAYMENT_Tbl_Type;
1108:
1109: --

Line 1119: OE_GLOBALS.G_UI_FLAG := TRUE;

1115: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_Payment.VALIDATE_AND_WRITE' , 1 ) ;
1116: END IF;
1117:
1118: -- Set the UI flag
1119: OE_GLOBALS.G_UI_FLAG := TRUE;
1120:
1121: -- Set control flags.
1122:
1123: l_control_rec.controlled_operation := TRUE;

Line 1158: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

1154:
1155: -- Set Operation.
1156:
1157: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN
1158: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1159: ELSE
1160: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1161: END IF;
1162:

Line 1160: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

1156:
1157: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN
1158: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1159: ELSE
1160: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1161: END IF;
1162:
1163: -- Populate Line_Payment table
1164:

Line 1202: OE_GLOBALS.G_UI_FLAG := FALSE;

1198: -- l_old_Line_Payment_rec.operation := l_Line_PAYMENT_rec.operation;
1199:
1200:
1201: -- Re-set the UI flag to FALSE
1202: OE_GLOBALS.G_UI_FLAG := FALSE;
1203:
1204: -- Set return status.
1205:
1206: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1223: OE_GLOBALS.G_UI_FLAG := FALSE;

1219: EXCEPTION
1220:
1221: WHEN FND_API.G_EXC_ERROR THEN
1222:
1223: OE_GLOBALS.G_UI_FLAG := FALSE;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226:
1227: -- Get message count and data

Line 1236: OE_GLOBALS.G_UI_FLAG := FALSE;

1232: );
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235:
1236: OE_GLOBALS.G_UI_FLAG := FALSE;
1237:
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1239:
1240: -- Get message count and data

Line 1249: OE_GLOBALS.G_UI_FLAG := FALSE;

1245: );
1246:
1247: WHEN OTHERS THEN
1248:
1249: OE_GLOBALS.G_UI_FLAG := FALSE;
1250:
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1252:
1253: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1282: l_control_rec OE_GLOBALS.Control_Rec_Type;

1278: , p_line_id IN NUMBER
1279: , p_header_id IN NUMBER
1280: )
1281: IS
1282: l_control_rec OE_GLOBALS.Control_Rec_Type;
1283: l_return_status VARCHAR2(1);
1284: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1285: l_x_Old_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1286:

Line 1297: OE_GLOBALS.G_UI_FLAG := TRUE;

1293: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_Payment.DELETE_ROW' , 1 ) ;
1294: END IF;
1295:
1296: -- Set the UI flag
1297: OE_GLOBALS.G_UI_FLAG := TRUE;
1298:
1299: -- Set control flags.
1300:
1301: l_control_rec.controlled_operation := TRUE;

Line 1328: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;

1324: );
1325:
1326: -- Set Operation.
1327:
1328: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;
1329:
1330: -- Populate Line_Payment table
1331:
1332:

Line 1357: OE_GLOBALS.G_UI_FLAG := FALSE;

1353:
1354: Clear_Line_Payment;
1355:
1356: -- Re-set the UI flag to FALSE
1357: OE_GLOBALS.G_UI_FLAG := FALSE;
1358:
1359: -- Set return status.
1360:
1361: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1378: OE_GLOBALS.G_UI_FLAG := FALSE;

1374: EXCEPTION
1375:
1376: WHEN FND_API.G_EXC_ERROR THEN
1377:
1378: OE_GLOBALS.G_UI_FLAG := FALSE;
1379:
1380: x_return_status := FND_API.G_RET_STS_ERROR;
1381:
1382: -- Get message count and data

Line 1391: OE_GLOBALS.G_UI_FLAG := FALSE;

1387: );
1388:
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390:
1391: OE_GLOBALS.G_UI_FLAG := FALSE;
1392:
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394:
1395: -- Get message count and data

Line 1404: OE_GLOBALS.G_UI_FLAG := FALSE;

1400: );
1401:
1402: WHEN OTHERS THEN
1403:
1404: OE_GLOBALS.G_UI_FLAG := FALSE;
1405:
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1407:
1408: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1436: l_control_rec OE_GLOBALS.Control_Rec_Type;

1432: )
1433: IS
1434: l_return_status VARCHAR2(1);
1435: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1436: l_control_rec OE_GLOBALS.Control_Rec_Type;
1437: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1438: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1439: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1440: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1471: OE_GLOBALS.G_UI_FLAG := TRUE;

1467: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_PAYMENT.PROCESS_ENTITY' , 1 ) ;
1468: END IF;
1469:
1470: -- Set the UI flag
1471: OE_GLOBALS.G_UI_FLAG := TRUE;
1472:
1473: -- Set control flags.
1474:
1475: l_control_rec.controlled_operation := TRUE;

Line 1477: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE_Payment;

1473: -- Set control flags.
1474:
1475: l_control_rec.controlled_operation := TRUE;
1476: l_control_rec.process := TRUE;
1477: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE_Payment;
1478:
1479: l_control_rec.check_security := FALSE;
1480: l_control_rec.clear_dependents := FALSE;
1481: l_control_rec.default_attributes := FALSE;

Line 1534: OE_GLOBALS.G_UI_FLAG := FALSE;

1530: END IF;
1531:
1532:
1533: -- Re-set the UI flag to FALSE
1534: OE_GLOBALS.G_UI_FLAG := FALSE;
1535:
1536: -- Set return status.
1537:
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1555: OE_GLOBALS.G_UI_FLAG := FALSE;

1551: EXCEPTION
1552:
1553: WHEN FND_API.G_EXC_ERROR THEN
1554:
1555: OE_GLOBALS.G_UI_FLAG := FALSE;
1556:
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558:
1559: -- Get message count and data

Line 1568: OE_GLOBALS.G_UI_FLAG := FALSE;

1564: );
1565:
1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1567:
1568: OE_GLOBALS.G_UI_FLAG := FALSE;
1569:
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: -- Get message count and data

Line 1581: OE_GLOBALS.G_UI_FLAG := FALSE;

1577: );
1578:
1579: WHEN OTHERS THEN
1580:
1581: OE_GLOBALS.G_UI_FLAG := FALSE;
1582:
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1584:
1585: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1629: l_x_Line_Payment_rec.operation := OE_GLOBALS.G_OPR_LOCK;

1625: END IF;
1626:
1627: -- Load Line_Payment record
1628:
1629: l_x_Line_Payment_rec.operation := OE_GLOBALS.G_OPR_LOCK;
1630: l_x_Line_Payment_rec.payment_number := p_payment_number;
1631: l_x_Line_Payment_rec.line_id := p_line_id;
1632: l_x_Line_Payment_rec.header_id := p_header_id;
1633: l_x_Line_Payment_rec.lock_control := p_lock_control;