DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER_SCREDIT dependencies on OE_GLOBALS

Line 102: l_control_rec OE_GLOBALS.Control_Rec_Type;

98:
99: )
100: IS
101: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
105: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
106:

Line 117: OE_GLOBALS.G_UI_FLAG := TRUE;

113: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_SCREDIT.DEFAULT_ATTRIBUTES' , 1 ) ;
114: END IF;
115:
116: -- Set the UI flag
117: OE_GLOBALS.G_UI_FLAG := TRUE;
118:
119: -- Set control flags.
120:
121: l_control_rec.controlled_operation := TRUE;

Line 164: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

160: l_x_header_scredit_tbl(1).context := NULL;
161:
162: -- Set Operation to Create
163:
164: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
165:
166: -- Populate Header_Scredit table
167:
168:

Line 234: OE_GLOBALS.G_UI_FLAG := FALSE;

230: ( p_Header_Scredit_rec => l_x_Header_Scredit_tbl(1)
231: );
232:
233: -- Re-set the UI flag to FALSE
234: OE_GLOBALS.G_UI_FLAG := FALSE;
235:
236: -- Set return status.
237:
238: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 255: OE_GLOBALS.G_UI_FLAG := FALSE;

251: EXCEPTION
252:
253: WHEN FND_API.G_EXC_ERROR THEN
254:
255: OE_GLOBALS.G_UI_FLAG := FALSE;
256:
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: -- Get message count and data

Line 268: OE_GLOBALS.G_UI_FLAG := FALSE;

264: );
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267:
268: OE_GLOBALS.G_UI_FLAG := FALSE;
269:
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
271:
272: -- Get message count and data

Line 281: OE_GLOBALS.G_UI_FLAG := FALSE;

277: );
278:
279: WHEN OTHERS THEN
280:
281: OE_GLOBALS.G_UI_FLAG := FALSE;
282:
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284:
285: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 398: l_control_rec OE_GLOBALS.Control_Rec_Type;

394: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
395: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
396: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
397: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
398: l_control_rec OE_GLOBALS.Control_Rec_Type;
399: l_return_status VARCHAR2(1);
400:
401: --
402: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 411: OE_GLOBALS.G_UI_FLAG := TRUE;

407: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_SCREDIT.CHANGE_ATTRIBUTE' , 1 ) ;
408: END IF;
409:
410: -- Set the UI flag
411: OE_GLOBALS.G_UI_FLAG := TRUE;
412:
413: -- Set control flags.
414:
415: l_control_rec.controlled_operation := TRUE;

Line 522: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

518:
519: -- Set Operation.
520:
521: IF FND_API.To_Boolean(l_x_Header_Scredit_tbl(1).db_flag) THEN
522: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
523: ELSE
524: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
525: END IF;
526:

Line 524: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

520:
521: IF FND_API.To_Boolean(l_x_Header_Scredit_tbl(1).db_flag) THEN
522: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
523: ELSE
524: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
525: END IF;
526:
527: -- Populate Header_Scredit table
528: l_header_scredit_rec:=l_x_Header_Scredit_Tbl(1);

Line 591: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute1,

587: );
588:
589: -- Return changed attributes.
590:
591: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute1,
592: l_Header_Scredit_rec.attribute1)
593: THEN
594: x_attribute1 := l_x_header_scredit_tbl(1).attribute1;
595: END IF;

Line 597: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute10,

593: THEN
594: x_attribute1 := l_x_header_scredit_tbl(1).attribute1;
595: END IF;
596:
597: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute10,
598: l_Header_Scredit_rec.attribute10)
599: THEN
600: x_attribute10 := l_x_header_scredit_tbl(1).attribute10;
601: END IF;

Line 603: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute11,

599: THEN
600: x_attribute10 := l_x_header_scredit_tbl(1).attribute10;
601: END IF;
602:
603: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute11,
604: l_Header_Scredit_rec.attribute11)
605: THEN
606: x_attribute11 := l_x_header_scredit_tbl(1).attribute11;
607: END IF;

Line 609: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute12,

605: THEN
606: x_attribute11 := l_x_header_scredit_tbl(1).attribute11;
607: END IF;
608:
609: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute12,
610: l_Header_Scredit_rec.attribute12)
611: THEN
612: x_attribute12 := l_x_header_scredit_tbl(1).attribute12;
613: END IF;

Line 615: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute13,

611: THEN
612: x_attribute12 := l_x_header_scredit_tbl(1).attribute12;
613: END IF;
614:
615: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute13,
616: l_Header_Scredit_rec.attribute13)
617: THEN
618: x_attribute13 := l_x_header_scredit_tbl(1).attribute13;
619: END IF;

Line 621: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute14,

617: THEN
618: x_attribute13 := l_x_header_scredit_tbl(1).attribute13;
619: END IF;
620:
621: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute14,
622: l_Header_Scredit_rec.attribute14)
623: THEN
624: x_attribute14 := l_x_header_scredit_tbl(1).attribute14;
625: END IF;

Line 627: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute15,

623: THEN
624: x_attribute14 := l_x_header_scredit_tbl(1).attribute14;
625: END IF;
626:
627: IF NOT OE_GLOBALS.Equal(l_x_header_scredit_tbl(1).attribute15,
628: l_Header_Scredit_rec.attribute15)
629: THEN
630: x_attribute15 := l_x_header_scredit_tbl(1).attribute15;
631: END IF;

Line 633: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute2,

629: THEN
630: x_attribute15 := l_x_header_scredit_tbl(1).attribute15;
631: END IF;
632:
633: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute2,
634: l_Header_Scredit_rec.attribute2)
635: THEN
636: x_attribute2 := l_x_Header_Scredit_Tbl(1).attribute2;
637: END IF;

Line 639: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute3,

635: THEN
636: x_attribute2 := l_x_Header_Scredit_Tbl(1).attribute2;
637: END IF;
638:
639: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute3,
640: l_Header_Scredit_rec.attribute3)
641: THEN
642: x_attribute3 := l_x_Header_Scredit_Tbl(1).attribute3;
643: END IF;

Line 645: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute4,

641: THEN
642: x_attribute3 := l_x_Header_Scredit_Tbl(1).attribute3;
643: END IF;
644:
645: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute4,
646: l_Header_Scredit_rec.attribute4)
647: THEN
648: x_attribute4 := l_x_Header_Scredit_Tbl(1).attribute4;
649: END IF;

Line 651: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute5,

647: THEN
648: x_attribute4 := l_x_Header_Scredit_Tbl(1).attribute4;
649: END IF;
650:
651: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute5,
652: l_Header_Scredit_rec.attribute5)
653: THEN
654: x_attribute5 := l_x_Header_Scredit_Tbl(1).attribute5;
655: END IF;

Line 657: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute6,

653: THEN
654: x_attribute5 := l_x_Header_Scredit_Tbl(1).attribute5;
655: END IF;
656:
657: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute6,
658: l_Header_Scredit_rec.attribute6)
659: THEN
660: x_attribute6 := l_x_Header_Scredit_Tbl(1).attribute6;
661: END IF;

Line 663: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute7,

659: THEN
660: x_attribute6 := l_x_Header_Scredit_Tbl(1).attribute6;
661: END IF;
662:
663: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute7,
664: l_Header_Scredit_rec.attribute7)
665: THEN
666: x_attribute7 := l_x_Header_Scredit_Tbl(1).attribute7;
667: END IF;

Line 669: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute8,

665: THEN
666: x_attribute7 := l_x_Header_Scredit_Tbl(1).attribute7;
667: END IF;
668:
669: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute8,
670: l_Header_Scredit_rec.attribute8)
671: THEN
672: x_attribute8 := l_x_Header_Scredit_Tbl(1).attribute8;
673: END IF;

Line 675: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute9,

671: THEN
672: x_attribute8 := l_x_Header_Scredit_Tbl(1).attribute8;
673: END IF;
674:
675: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).attribute9,
676: l_Header_Scredit_rec.attribute9)
677: THEN
678: x_attribute9 := l_x_Header_Scredit_Tbl(1).attribute9;
679: END IF;

Line 681: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).context,

677: THEN
678: x_attribute9 := l_x_Header_Scredit_Tbl(1).attribute9;
679: END IF;
680:
681: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).context,
682: l_Header_Scredit_rec.context)
683: THEN
684: x_context := l_x_Header_Scredit_Tbl(1).context;
685: END IF;

Line 687: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).dw_update_advice_flag,

683: THEN
684: x_context := l_x_Header_Scredit_Tbl(1).context;
685: END IF;
686:
687: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).dw_update_advice_flag,
688: l_Header_Scredit_rec.dw_update_advice_flag)
689: THEN
690: x_dw_update_advice_flag := l_x_Header_Scredit_Tbl(1).dw_update_advice_flag;
691: END IF;

Line 693: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).header_id,

689: THEN
690: x_dw_update_advice_flag := l_x_Header_Scredit_Tbl(1).dw_update_advice_flag;
691: END IF;
692:
693: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).header_id,
694: l_Header_Scredit_rec.header_id)
695: THEN
696: x_header_id := l_x_Header_Scredit_Tbl(1).header_id;
697: END IF;

Line 699: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).line_id,

695: THEN
696: x_header_id := l_x_Header_Scredit_Tbl(1).header_id;
697: END IF;
698:
699: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).line_id,
700: l_Header_Scredit_rec.line_id)
701: THEN
702: x_line_id := l_x_Header_Scredit_Tbl(1).line_id;
703: END IF;

Line 705: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).percent,

701: THEN
702: x_line_id := l_x_Header_Scredit_Tbl(1).line_id;
703: END IF;
704:
705: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).percent,
706: l_Header_Scredit_rec.percent)
707: THEN
708: x_percent := l_x_Header_Scredit_Tbl(1).percent;
709: END IF;

Line 712: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).salesrep_id,

708: x_percent := l_x_Header_Scredit_Tbl(1).percent;
709: END IF;
710:
711:
712: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).salesrep_id,
713: l_Header_Scredit_rec.salesrep_id)
714: THEN
715: x_salesrep_id := l_x_Header_Scredit_Tbl(1).salesrep_id;
716: x_salesrep := l_Header_Scredit_val_rec.salesrep;

Line 718: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_credit_type_id,

714: THEN
715: x_salesrep_id := l_x_Header_Scredit_Tbl(1).salesrep_id;
716: x_salesrep := l_Header_Scredit_val_rec.salesrep;
717: END IF;
718: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_credit_type_id,
719: l_Header_Scredit_rec.sales_credit_type_id)
720: THEN
721: x_sales_credit_type_id := l_x_Header_Scredit_Tbl(1).sales_credit_type_id;
722: x_sales_credit_type := l_Header_Scredit_val_rec.sales_credit_type;

Line 725: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_credit_id,

721: x_sales_credit_type_id := l_x_Header_Scredit_Tbl(1).sales_credit_type_id;
722: x_sales_credit_type := l_Header_Scredit_val_rec.sales_credit_type;
723: END IF;
724:
725: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_credit_id,
726: l_Header_Scredit_rec.sales_credit_id)
727: THEN
728: x_sales_credit_id := l_x_Header_Scredit_Tbl(1).sales_credit_id;
729: END IF;

Line 731: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).wh_update_date,

727: THEN
728: x_sales_credit_id := l_x_Header_Scredit_Tbl(1).sales_credit_id;
729: END IF;
730:
731: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).wh_update_date,
732: l_Header_Scredit_rec.wh_update_date)
733: THEN
734: x_wh_update_date := l_x_Header_Scredit_Tbl(1).wh_update_date;
735: END IF;

Line 739: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_group_id,

735: END IF;
736:
737: --SG{
738:
739: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_group_id,
740: l_Header_Scredit_rec.sales_group_id)
741: THEN
742: x_sales_group_id := l_x_Header_Scredit_Tbl(1).sales_group_id;
743: x_sales_group := l_Header_Scredit_val_rec.sales_group;

Line 747: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_group_updated_flag,

743: x_sales_group := l_Header_Scredit_val_rec.sales_group;
744: oe_debug_pub.add('OEXFHSCB2--x_sales_group:'||x_sales_group);
745: END IF;
746:
747: IF NOT OE_GLOBALS.Equal(l_x_Header_Scredit_Tbl(1).sales_group_updated_flag,
748: l_Header_Scredit_rec.sales_group_updated_flag)
749: THEN
750: x_sales_group_updated_flag := l_Header_Scredit_rec.sales_group_updated_flag;
751: END IF;

Line 761: OE_GLOBALS.G_UI_FLAG := FALSE;

757: ( p_Header_Scredit_rec => l_x_Header_Scredit_tbl(1)
758: );
759:
760: -- Re-set the UI flag to FALSE
761: OE_GLOBALS.G_UI_FLAG := FALSE;
762:
763: -- Set return status.
764:
765: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 782: OE_GLOBALS.G_UI_FLAG := FALSE;

778: EXCEPTION
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781:
782: OE_GLOBALS.G_UI_FLAG := FALSE;
783:
784: x_return_status := FND_API.G_RET_STS_ERROR;
785:
786: -- Get message count and data

Line 795: OE_GLOBALS.G_UI_FLAG := FALSE;

791: );
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794:
795: OE_GLOBALS.G_UI_FLAG := FALSE;
796:
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
798:
799: -- Get message count and data

Line 808: OE_GLOBALS.G_UI_FLAG := FALSE;

804: );
805:
806: WHEN OTHERS THEN
807:
808: OE_GLOBALS.G_UI_FLAG := FALSE;
809:
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
811:
812: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 857: l_control_rec OE_GLOBALS.Control_Rec_Type;

853:
854: )
855: IS
856: l_x_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
857: l_control_rec OE_GLOBALS.Control_Rec_Type;
858: l_return_status VARCHAR2(1);
859: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
860:
861: --

Line 871: OE_GLOBALS.G_UI_FLAG := TRUE;

867: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_SCREDIT.VALIDATE_AND_WRITE' , 1 ) ;
868: END IF;
869:
870: -- Set the UI flag
871: OE_GLOBALS.G_UI_FLAG := TRUE;
872:
873: -- Set control flags.
874:
875: l_control_rec.controlled_operation := TRUE;

Line 906: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

902:
903: -- Set Operation.
904:
905: IF FND_API.To_Boolean(l_x_Header_Scredit_tbl(1).db_flag) THEN
906: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
907: ELSE
908: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
909: END IF;
910:

Line 908: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

904:
905: IF FND_API.To_Boolean(l_x_Header_Scredit_tbl(1).db_flag) THEN
906: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
907: ELSE
908: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
909: END IF;
910:
911: /* Start Audit Trail -- Pass change reason, comments */
912: l_x_Header_Scredit_tbl(1).change_reason := p_change_reason_code;

Line 974: OE_GLOBALS.G_UI_FLAG := FALSE;

970: -- l_old_Header_Scredit_rec.operation := l_Header_Scredit_rec.operation;
971:
972:
973: -- Re-set the UI flag to FALSE
974: OE_GLOBALS.G_UI_FLAG := FALSE;
975:
976: -- Set return status.
977:
978: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 995: OE_GLOBALS.G_UI_FLAG := FALSE;

991: EXCEPTION
992:
993: WHEN FND_API.G_EXC_ERROR THEN
994:
995: OE_GLOBALS.G_UI_FLAG := FALSE;
996:
997: x_return_status := FND_API.G_RET_STS_ERROR;
998:
999: -- Get message count and data

Line 1008: OE_GLOBALS.G_UI_FLAG := FALSE;

1004: );
1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007:
1008: OE_GLOBALS.G_UI_FLAG := FALSE;
1009:
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1011:
1012: -- Get message count and data

Line 1021: OE_GLOBALS.G_UI_FLAG := FALSE;

1017: );
1018:
1019: WHEN OTHERS THEN
1020:
1021: OE_GLOBALS.G_UI_FLAG := FALSE;
1022:
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1057: l_control_rec OE_GLOBALS.Control_Rec_Type;

1053: , p_change_reason_code IN VARCHAR2 Default Null
1054: , p_change_comments IN VARCHAR2 Default Null
1055: )
1056: IS
1057: l_control_rec OE_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1060: l_x_Old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1061:

Line 1072: OE_GLOBALS.G_UI_FLAG := TRUE;

1068: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_SCREDIT.DELETE_ROW' , 1 ) ;
1069: END IF;
1070:
1071: -- Set the UI flag
1072: OE_GLOBALS.G_UI_FLAG := TRUE;
1073:
1074: -- Set control flags.
1075:
1076: l_control_rec.controlled_operation := TRUE;

Line 1101: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;

1097: );
1098:
1099: -- Set Operation.
1100:
1101: l_x_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;
1102: l_x_Header_Scredit_tbl(1).change_reason := p_change_reason_code;
1103: l_x_Header_Scredit_tbl(1).change_comments := p_change_comments;
1104:
1105: -- Populate Header_Scredit table

Line 1131: OE_GLOBALS.G_UI_FLAG := FALSE;

1127:
1128: Clear_Header_Scredit;
1129:
1130: -- Re-set the UI flag to FALSE
1131: OE_GLOBALS.G_UI_FLAG := FALSE;
1132:
1133: -- Set return status.
1134:
1135: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1152: OE_GLOBALS.G_UI_FLAG := FALSE;

1148: EXCEPTION
1149:
1150: WHEN FND_API.G_EXC_ERROR THEN
1151:
1152: OE_GLOBALS.G_UI_FLAG := FALSE;
1153:
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: -- Get message count and data

Line 1165: OE_GLOBALS.G_UI_FLAG := FALSE;

1161: );
1162:
1163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1164:
1165: OE_GLOBALS.G_UI_FLAG := FALSE;
1166:
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168:
1169: -- Get message count and data

Line 1178: OE_GLOBALS.G_UI_FLAG := FALSE;

1174: );
1175:
1176: WHEN OTHERS THEN
1177:
1178: OE_GLOBALS.G_UI_FLAG := FALSE;
1179:
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1181:
1182: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1213: l_control_rec OE_GLOBALS.Control_Rec_Type;

1209: )
1210: IS
1211: l_return_status VARCHAR2(1);
1212: /*l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1213: l_control_rec OE_GLOBALS.Control_Rec_Type;
1214: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1215: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1216: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1217: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1244: OE_GLOBALS.G_UI_FLAG := TRUE;

1240: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_SCREDIT.PROCESS_ENTITY' , 1 ) ;
1241: END IF;
1242:
1243: -- Set the UI flag
1244: OE_GLOBALS.G_UI_FLAG := TRUE;
1245:
1246: -- Set control flags.
1247:
1248: /* l_control_rec.controlled_operation := TRUE;

Line 1250: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_HEADER_SCREDIT;

1246: -- Set control flags.
1247:
1248: /* l_control_rec.controlled_operation := TRUE;
1249: l_control_rec.process := TRUE;
1250: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_HEADER_SCREDIT;
1251:
1252: l_control_rec.check_security := FALSE;
1253: l_control_rec.clear_dependents := FALSE;
1254: l_control_rec.default_attributes := FALSE;

Line 1305: OE_GLOBALS.G_UI_FLAG := FALSE;

1301: END IF;
1302:
1303:
1304: -- Re-set the UI flag to FALSE
1305: OE_GLOBALS.G_UI_FLAG := FALSE;
1306:
1307: -- Set return status.
1308:
1309: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1326: OE_GLOBALS.G_UI_FLAG := FALSE;

1322: EXCEPTION
1323:
1324: WHEN FND_API.G_EXC_ERROR THEN
1325:
1326: OE_GLOBALS.G_UI_FLAG := FALSE;
1327:
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329:
1330: -- Get message count and data

Line 1339: OE_GLOBALS.G_UI_FLAG := FALSE;

1335: );
1336:
1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1338:
1339: OE_GLOBALS.G_UI_FLAG := FALSE;
1340:
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1342:
1343: -- Get message count and data

Line 1352: OE_GLOBALS.G_UI_FLAG := FALSE;

1348: );
1349:
1350: WHEN OTHERS THEN
1351:
1352: OE_GLOBALS.G_UI_FLAG := FALSE;
1353:
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1355:
1356: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1401: l_x_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_LOCK;

1397: END IF;
1398:
1399: -- Load Header_Scredit record
1400:
1401: l_x_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_LOCK;
1402: l_x_Header_Scredit_rec.sales_credit_id := p_sales_credit_id ;
1403: l_x_Header_Scredit_rec.lock_control := p_lock_control;
1404:
1405: -- Call oe_headers_scredits_util.lock_row instead of OE_Order_PVT.Lock_order