eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DEFAULT_HEADER dependencies on FND_API

Line 23: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND

19: oe_debug_pub.add('Enter get_freight_carrier()',1);
20: oe_debug_pub.add('Performance Issue 2830725 fixed',5);
21: END IF;
22: IF (p_header_rec.shipping_method_code IS NOT NULL AND
23: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
24: (p_header_rec.ship_from_org_id IS NOT NULL AND
25: p_header_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
26:
27: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null

Line 25: p_header_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN

21: END IF;
22: IF (p_header_rec.shipping_method_code IS NOT NULL AND
23: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
24: (p_header_rec.ship_from_org_id IS NOT NULL AND
25: p_header_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
26:
27: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
28: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code
29: ,p_old_header_rec.shipping_method_code) OR

Line 70: p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR) THEN

66: RETURN NULL;
67: END IF;
68:
69: IF (p_header_rec.shipping_method_code IS NULL OR
70: p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR) THEN
71: RETURN NULL;
72: END IF;
73: RETURN p_header_rec.freight_carrier_code;
74:

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: ( G_PKG_NAME ,
90: 'Get_freight_carrier'
91: );
92: END IF;
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END GET_FREIGHT_CARRIER;
95:
96:
97: FUNCTION Get_Order_Category(p_header_rec OE_ORDER_PUB.Header_rec_Type,

Line 124: IF (p_old_header_rec.order_category_code <> FND_API.G_MISS_CHAR AND

120: where
121: order_type_id = p_header_rec.order_type_id;
122:
123: IF p_header_rec.operation = oe_globals.g_opr_update THEN
124: IF (p_old_header_rec.order_category_code <> FND_API.G_MISS_CHAR AND
125: p_old_header_rec.order_category_code IS NOT NULL ) THEN
126: IF NOT OE_GLOBALS.EQUAL(p_old_header_rec.order_category_code,
127: l_category_code) THEN
128: FND_MESSAGE.SET_NAME('ONT','OE_ORD_CAT_CONST');

Line 133: RAISE FND_API.G_EXC_ERROR;

129: OE_MSG_PUB.ADD;
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'ORDER CATEGORY CONSTRAINED' ) ;
132: END IF;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: END IF;
136: END IF;
137:

Line 147: WHEN FND_API.G_EXC_ERROR THEN

143: WHEN NO_DATA_FOUND THEN
144: Return 'ORDER';
145:
146: --For Bug 3436556
147: WHEN FND_API.G_EXC_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: --End Of Fix
150:
151: WHEN OTHERS THEN

Line 148: RAISE FND_API.G_EXC_ERROR;

144: Return 'ORDER';
145:
146: --For Bug 3436556
147: WHEN FND_API.G_EXC_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: --End Of Fix
150:
151: WHEN OTHERS THEN
152: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

156: 'Get_order_category'
157: );
158: END IF;
159:
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161:
162: END Get_Order_Category;
163:
164: FUNCTION Get_Customer_Preference_set(p_header_rec OE_ORDER_PUB.Header_rec_Type,

Line 298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

294: 'Get_customer_preference_set'
295: );
296: END IF;
297:
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299:
300: END Get_customer_preference_set;
301:
302:

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: 'Get_Header'
356: );
357: END IF;
358:
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360:
361: END Get_Header;
362:
363: FUNCTION Get_Open

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: 'Get_Ordered_Date'
415: );
416: END IF;
417:
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419:
420: END Get_Ordered_Date;
421:
422: FUNCTION Get_Version_Number

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449: 'Get_Version_Number'
450: );
451: END IF;
452:
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454:
455: END Get_Version_Number;
456:
457: FUNCTION Get_Order_Source_Id

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: 'Get_Order_Source'
482: );
483: END IF;
484:
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486:
487: END Get_Order_Source_Id;
488:
489: FUNCTION Get_EM_Message_Id

Line 545: p_init_msg_list => FND_API.G_FALSE,

541: -- and set value of l_contract_template_id to NULL
542:
543: l_result := OE_CONTRACTS_UTIL.Is_Terms_Template_Valid
544: (p_api_version => 1.0,
545: p_init_msg_list => FND_API.G_FALSE,
546: x_return_status => l_return_status,
547: x_msg_count => l_msg_count,
548: x_msg_data => l_msg_data,
549: p_doc_type => 'O',

Line 585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

581: 'Get_contract_template_id'
582: );
583: END IF;
584:
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586:
587: END Get_Contract_Template_ID;
588:
589:

Line 664: if p_request_date = fnd_api.g_miss_date then

660: oe_debug_pub.add('Enter Default_Blanket_Number');
661: oe_debug_pub.add('Request Date :'||p_request_date);
662: end if;
663:
664: if p_request_date = fnd_api.g_miss_date then
665: l_request_date := null;
666: else
667: l_request_date := p_request_date;
668: end if;

Line 748: IF g_header_rec.created_by = FND_API.G_MISS_NUM THEN

744: IF l_operation = OE_GLOBALS.G_OPR_CREATE THEN
745:
746: g_header_rec.org_id := Get_Org;
747:
748: IF g_header_rec.created_by = FND_API.G_MISS_NUM THEN
749: g_header_rec.created_by := FND_GLOBAL.USER_ID;
750: END IF;
751:
752: --key Transaction Dates

Line 753: IF g_header_rec.creation_date = FND_API.G_MISS_DATE THEN

749: g_header_rec.created_by := FND_GLOBAL.USER_ID;
750: END IF;
751:
752: --key Transaction Dates
753: IF g_header_rec.creation_date = FND_API.G_MISS_DATE THEN
754: g_header_rec.creation_date := sysdate ;
755: END IF ;
756: --end
757:

Line 758: IF g_header_rec.header_id = FND_API.G_MISS_NUM THEN

754: g_header_rec.creation_date := sysdate ;
755: END IF ;
756: --end
757:
758: IF g_header_rec.header_id = FND_API.G_MISS_NUM THEN
759: g_header_rec.header_id := Get_Header;
760: END IF;
761:
762: IF g_header_rec.booked_flag = FND_API.G_MISS_CHAR THEN

Line 762: IF g_header_rec.booked_flag = FND_API.G_MISS_CHAR THEN

758: IF g_header_rec.header_id = FND_API.G_MISS_NUM THEN
759: g_header_rec.header_id := Get_Header;
760: END IF;
761:
762: IF g_header_rec.booked_flag = FND_API.G_MISS_CHAR THEN
763: g_header_rec.booked_flag := Get_Booked;
764: END IF;
765:
766: IF g_header_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN

Line 766: IF g_header_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN

762: IF g_header_rec.booked_flag = FND_API.G_MISS_CHAR THEN
763: g_header_rec.booked_flag := Get_Booked;
764: END IF;
765:
766: IF g_header_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
767: g_header_rec.cancelled_flag := Get_Cancelled;
768: END IF;
769:
770: IF g_header_rec.open_flag = FND_API.G_MISS_CHAR THEN

Line 770: IF g_header_rec.open_flag = FND_API.G_MISS_CHAR THEN

766: IF g_header_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
767: g_header_rec.cancelled_flag := Get_Cancelled;
768: END IF;
769:
770: IF g_header_rec.open_flag = FND_API.G_MISS_CHAR THEN
771: g_header_rec.open_flag := Get_Open;
772: END IF;
773:
774: IF g_header_rec.version_number = FND_API.G_MISS_NUM THEN

Line 774: IF g_header_rec.version_number = FND_API.G_MISS_NUM THEN

770: IF g_header_rec.open_flag = FND_API.G_MISS_CHAR THEN
771: g_header_rec.open_flag := Get_Open;
772: END IF;
773:
774: IF g_header_rec.version_number = FND_API.G_MISS_NUM THEN
775: g_header_rec.version_number := Get_Version_Number;
776: END IF;
777: --bug3664313 FP start: added NULL check
778: IF ((g_header_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR

Line 778: IF ((g_header_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR

774: IF g_header_rec.version_number = FND_API.G_MISS_NUM THEN
775: g_header_rec.version_number := Get_Version_Number;
776: END IF;
777: --bug3664313 FP start: added NULL check
778: IF ((g_header_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR
779: g_header_rec.orig_sys_document_ref IS NULL) AND
780: g_header_rec.source_document_id <> 10) THEN
781: g_header_rec.orig_sys_document_ref := 'OE_ORDER_HEADERS_ALL'||g_header_rec.header_id;
782: END IF;

Line 784: IF g_header_rec.order_source_id = FND_API.G_MISS_NUM THEN

780: g_header_rec.source_document_id <> 10) THEN
781: g_header_rec.orig_sys_document_ref := 'OE_ORDER_HEADERS_ALL'||g_header_rec.header_id;
782: END IF;
783:
784: IF g_header_rec.order_source_id = FND_API.G_MISS_NUM THEN
785: IF g_header_rec.source_document_type_id = FND_API.G_MISS_NUM THEN --2991163
786: g_header_rec.order_source_id := Get_Order_Source_Id;
787: ELSE
788: g_header_rec.order_source_id := g_header_rec.source_document_type_id ; --2991163

Line 785: IF g_header_rec.source_document_type_id = FND_API.G_MISS_NUM THEN --2991163

781: g_header_rec.orig_sys_document_ref := 'OE_ORDER_HEADERS_ALL'||g_header_rec.header_id;
782: END IF;
783:
784: IF g_header_rec.order_source_id = FND_API.G_MISS_NUM THEN
785: IF g_header_rec.source_document_type_id = FND_API.G_MISS_NUM THEN --2991163
786: g_header_rec.order_source_id := Get_Order_Source_Id;
787: ELSE
788: g_header_rec.order_source_id := g_header_rec.source_document_type_id ; --2991163
789: END IF; --2991163

Line 808: g_header_rec.blanket_number = FND_API.G_MISS_NUM) AND

804: oe_debug_pub.add('Old Cust PO :'||l_old_header_rec.cust_po_number);
805: END IF;
806:
807: IF (g_header_rec.blanket_number IS NULL OR
808: g_header_rec.blanket_number = FND_API.G_MISS_NUM) AND
809: -- Re-default only if old record does not have a blanket
810: -- value either, as defaulting should not over-ride
811: -- existing blanket value.
812: (l_old_header_rec.blanket_number IS NULL OR

Line 813: l_old_header_rec.blanket_number = FND_API.G_MISS_NUM ) AND

809: -- Re-default only if old record does not have a blanket
810: -- value either, as defaulting should not over-ride
811: -- existing blanket value.
812: (l_old_header_rec.blanket_number IS NULL OR
813: l_old_header_rec.blanket_number = FND_API.G_MISS_NUM ) AND
814: g_header_rec.sold_to_org_id IS NOT NULL AND
815: g_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM AND
816: (g_header_rec.cust_po_number IS NOT NULL AND
817: g_header_rec.cust_po_number <> FND_API.G_MISS_CHAR

Line 815: g_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM AND

811: -- existing blanket value.
812: (l_old_header_rec.blanket_number IS NULL OR
813: l_old_header_rec.blanket_number = FND_API.G_MISS_NUM ) AND
814: g_header_rec.sold_to_org_id IS NOT NULL AND
815: g_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM AND
816: (g_header_rec.cust_po_number IS NOT NULL AND
817: g_header_rec.cust_po_number <> FND_API.G_MISS_CHAR
818: -- Re-default blanket number only if cust PO
819: -- OR customer is updated

Line 817: g_header_rec.cust_po_number <> FND_API.G_MISS_CHAR

813: l_old_header_rec.blanket_number = FND_API.G_MISS_NUM ) AND
814: g_header_rec.sold_to_org_id IS NOT NULL AND
815: g_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM AND
816: (g_header_rec.cust_po_number IS NOT NULL AND
817: g_header_rec.cust_po_number <> FND_API.G_MISS_CHAR
818: -- Re-default blanket number only if cust PO
819: -- OR customer is updated
820: AND (NOT OE_GLOBALS.EQUAL(g_header_rec.cust_po_number
821: ,l_old_header_rec.cust_po_number)

Line 858: AND g_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM

854: -- the check here is to avoid performace overhead, so that party_type
855: -- information is only loaded when needed.
856: IF OE_Prepayment_Util.Get_Installment_Options = 'ENABLE_PAY_NOW'
857: AND g_header_rec.sold_to_org_id IS NOT NULL
858: AND g_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM
859: THEN
860: BEGIN
861: SELECT 'Y'
862: INTO l_exists

Line 914: l_old_header_rec.blanket_number = FND_API.G_MISS_NUM )

910: -- Re-default only if old record does not have a blanket
911: -- value either, as defaulting should not over-ride
912: -- existing blanket value.
913: AND (l_old_header_rec.blanket_number IS NULL OR
914: l_old_header_rec.blanket_number = FND_API.G_MISS_NUM )
915: AND l_record.sold_to_org_id IS NOT NULL
916: AND NOT OE_GLOBALS.EQUAL(l_record.cust_po_number
917: ,g_header_rec.cust_po_number)
918: THEN

Line 948: IF p_x_header_rec.blanket_number = FND_API.G_MISS_NUM THEN

944: OE_Header_UTIL.RowType_Rec_to_API_Rec
945: (p_record => l_record
946: ,x_api_rec => p_x_header_rec);
947:
948: IF p_x_header_rec.blanket_number = FND_API.G_MISS_NUM THEN
949: p_x_header_rec.blanket_number := NULL;
950: END IF;
951: --End Blankets Code Merge
952:

Line 959: IF (p_x_header_rec.order_category_code = FND_API.G_MISS_CHAR OR

955: END IF;
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'ENTER DEFAULT CATEGORY'|| P_X_HEADER_REC.ORDER_CATEGORY_CODE ) ;
958: END IF;
959: IF (p_x_header_rec.order_category_code = FND_API.G_MISS_CHAR OR
960: p_x_header_rec.order_category_code IS NULL) THEN
961:
962: IF (p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM AND
963: p_x_header_rec.order_type_id IS NOT NULL )THEN

Line 962: IF (p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM AND

958: END IF;
959: IF (p_x_header_rec.order_category_code = FND_API.G_MISS_CHAR OR
960: p_x_header_rec.order_category_code IS NULL) THEN
961:
962: IF (p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM AND
963: p_x_header_rec.order_type_id IS NOT NULL )THEN
964: p_x_header_rec.order_category_code :=
965: Get_order_category(p_x_header_rec,
966: p_old_header_rec);

Line 974: AND p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM

970:
971: /* Get Contract template */
972: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
973: AND p_x_header_rec.order_type_id IS NOT NULL
974: AND p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM
975: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
976: AND OE_Contracts_util.check_license = 'Y'
977: THEN
978: p_x_header_rec.contract_template_id :=

Line 984: IF (l_cust_pref_set_code <> FND_API.G_MISS_CHAR AND

980: p_old_header_rec);
981: END IF;
982:
983: -- Get customer preferece
984: IF (l_cust_pref_set_code <> FND_API.G_MISS_CHAR AND
985: l_cust_pref_set_code IS NOT NULL) THEN
986: p_x_header_rec.customer_preference_set_code := l_cust_pref_set_code;
987: END IF;
988: IF l_debug_level > 0 THEN

Line 1005: if p_x_header_rec.marketing_source_code_id = FND_API.G_MISS_NUM then

1001:
1002: -- Assign the marketing_source_code_id value back to the out record. This
1003: -- done because the column in not enabled in the AK tables for defaulting.
1004:
1005: if p_x_header_rec.marketing_source_code_id = FND_API.G_MISS_NUM then
1006: p_x_header_rec.marketing_source_code_id := NULL;
1007: else
1008: p_x_header_rec.marketing_source_code_id := p_x_header_rec.marketing_source_code_id;
1009: end if;

Line 1051: IF (p_x_header_rec.tp_context = FND_API.G_MISS_CHAR) THEN

1047: END IF;
1048:
1049: /* 1581620 start */
1050:
1051: IF (p_x_header_rec.tp_context = FND_API.G_MISS_CHAR) THEN
1052: p_x_header_rec.tp_context := NULL;
1053: END IF;
1054: IF (p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
1055: p_x_header_rec.tp_attribute1 := NULL;

Line 1054: IF (p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN

1050:
1051: IF (p_x_header_rec.tp_context = FND_API.G_MISS_CHAR) THEN
1052: p_x_header_rec.tp_context := NULL;
1053: END IF;
1054: IF (p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
1055: p_x_header_rec.tp_attribute1 := NULL;
1056: END IF;
1057:
1058: IF (p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN

Line 1058: IF (p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN

1054: IF (p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
1055: p_x_header_rec.tp_attribute1 := NULL;
1056: END IF;
1057:
1058: IF (p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN
1059: p_x_header_rec.tp_attribute2 := NULL;
1060: END IF;
1061:
1062: IF (p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN

Line 1062: IF (p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN

1058: IF (p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN
1059: p_x_header_rec.tp_attribute2 := NULL;
1060: END IF;
1061:
1062: IF (p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN
1063: p_x_header_rec.tp_attribute3 := NULL;
1064: END IF;
1065:
1066: IF (p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN

Line 1066: IF (p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN

1062: IF (p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN
1063: p_x_header_rec.tp_attribute3 := NULL;
1064: END IF;
1065:
1066: IF (p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN
1067: p_x_header_rec.tp_attribute4 := NULL;
1068: END IF;
1069:
1070: IF (p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN

Line 1070: IF (p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN

1066: IF (p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN
1067: p_x_header_rec.tp_attribute4 := NULL;
1068: END IF;
1069:
1070: IF (p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN
1071: p_x_header_rec.tp_attribute5 := NULL;
1072: END IF;
1073:
1074: IF (p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN

Line 1074: IF (p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN

1070: IF (p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN
1071: p_x_header_rec.tp_attribute5 := NULL;
1072: END IF;
1073:
1074: IF (p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN
1075: p_x_header_rec.tp_attribute6 := NULL;
1076: END IF;
1077:
1078: IF (p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN

Line 1078: IF (p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN

1074: IF (p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN
1075: p_x_header_rec.tp_attribute6 := NULL;
1076: END IF;
1077:
1078: IF (p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN
1079: p_x_header_rec.tp_attribute7 := NULL;
1080: END IF;
1081:
1082: IF (p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN

Line 1082: IF (p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN

1078: IF (p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN
1079: p_x_header_rec.tp_attribute7 := NULL;
1080: END IF;
1081:
1082: IF (p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN
1083: p_x_header_rec.tp_attribute8 := NULL;
1084: END IF;
1085:
1086: IF (p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN

Line 1086: IF (p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN

1082: IF (p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN
1083: p_x_header_rec.tp_attribute8 := NULL;
1084: END IF;
1085:
1086: IF (p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN
1087: p_x_header_rec.tp_attribute9 := NULL;
1088: END IF;
1089:
1090: IF (p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN

Line 1090: IF (p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN

1086: IF (p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN
1087: p_x_header_rec.tp_attribute9 := NULL;
1088: END IF;
1089:
1090: IF (p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN
1091: p_x_header_rec.tp_attribute10 := NULL;
1092: END IF;
1093:
1094: IF (p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN

Line 1094: IF (p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN

1090: IF (p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN
1091: p_x_header_rec.tp_attribute10 := NULL;
1092: END IF;
1093:
1094: IF (p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN
1095: p_x_header_rec.tp_attribute11 := NULL;
1096: END IF;
1097:
1098: IF (p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN

Line 1098: IF (p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN

1094: IF (p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN
1095: p_x_header_rec.tp_attribute11 := NULL;
1096: END IF;
1097:
1098: IF (p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN
1099: p_x_header_rec.tp_attribute12 := NULL;
1100: END IF;
1101:
1102: IF (p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN

Line 1102: IF (p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN

1098: IF (p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN
1099: p_x_header_rec.tp_attribute12 := NULL;
1100: END IF;
1101:
1102: IF (p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN
1103: p_x_header_rec.tp_attribute13 := NULL;
1104: END IF;
1105:
1106: IF (p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN

Line 1106: IF (p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN

1102: IF (p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN
1103: p_x_header_rec.tp_attribute13 := NULL;
1104: END IF;
1105:
1106: IF (p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN
1107: p_x_header_rec.tp_attribute14 := NULL;
1108: END IF;
1109:
1110: IF (p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN

Line 1110: IF (p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN

1106: IF (p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN
1107: p_x_header_rec.tp_attribute14 := NULL;
1108: END IF;
1109:
1110: IF (p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN
1111: p_x_header_rec.tp_attribute15 := NULL;
1112: END IF;
1113: --Distributor Orders
1114: IF (p_x_header_rec.IB_OWNER = FND_API.G_MISS_CHAR) THEN

Line 1114: IF (p_x_header_rec.IB_OWNER = FND_API.G_MISS_CHAR) THEN

1110: IF (p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN
1111: p_x_header_rec.tp_attribute15 := NULL;
1112: END IF;
1113: --Distributor Orders
1114: IF (p_x_header_rec.IB_OWNER = FND_API.G_MISS_CHAR) THEN
1115: p_x_header_rec.IB_OWNER := NULL;
1116: END IF;
1117: IF (p_x_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) THEN
1118: p_x_header_rec.IB_INSTALLED_AT_LOCATION := NULL;

Line 1117: IF (p_x_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) THEN

1113: --Distributor Orders
1114: IF (p_x_header_rec.IB_OWNER = FND_API.G_MISS_CHAR) THEN
1115: p_x_header_rec.IB_OWNER := NULL;
1116: END IF;
1117: IF (p_x_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) THEN
1118: p_x_header_rec.IB_INSTALLED_AT_LOCATION := NULL;
1119: END IF;
1120: IF (p_x_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) THEN
1121: p_x_header_rec.IB_CURRENT_LOCATION := NULL;

Line 1120: IF (p_x_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) THEN

1116: END IF;
1117: IF (p_x_header_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) THEN
1118: p_x_header_rec.IB_INSTALLED_AT_LOCATION := NULL;
1119: END IF;
1120: IF (p_x_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) THEN
1121: p_x_header_rec.IB_CURRENT_LOCATION := NULL;
1122: END IF;
1123: IF (p_x_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM) THEN
1124: p_x_header_rec.END_CUSTOMER_ID := NULL;

Line 1123: IF (p_x_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM) THEN

1119: END IF;
1120: IF (p_x_header_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) THEN
1121: p_x_header_rec.IB_CURRENT_LOCATION := NULL;
1122: END IF;
1123: IF (p_x_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM) THEN
1124: p_x_header_rec.END_CUSTOMER_ID := NULL;
1125: END IF;
1126: IF (p_x_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM) THEN
1127: p_x_header_rec.END_CUSTOMER_SITE_USE_ID := NULL;

Line 1126: IF (p_x_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM) THEN

1122: END IF;
1123: IF (p_x_header_rec.END_CUSTOMER_ID = FND_API.G_MISS_NUM) THEN
1124: p_x_header_rec.END_CUSTOMER_ID := NULL;
1125: END IF;
1126: IF (p_x_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM) THEN
1127: p_x_header_rec.END_CUSTOMER_SITE_USE_ID := NULL;
1128: END IF;
1129: IF (p_x_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM) THEN
1130: p_x_header_rec.END_CUSTOMER_CONTACT_ID := NULL;

Line 1129: IF (p_x_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM) THEN

1125: END IF;
1126: IF (p_x_header_rec.END_CUSTOMER_SITE_USE_ID = FND_API.G_MISS_NUM) THEN
1127: p_x_header_rec.END_CUSTOMER_SITE_USE_ID := NULL;
1128: END IF;
1129: IF (p_x_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM) THEN
1130: p_x_header_rec.END_CUSTOMER_CONTACT_ID := NULL;
1131: END IF;
1132: --
1133: IF (p_x_header_rec.Contract_template_id = FND_API.G_MISS_NUM) THEN

Line 1133: IF (p_x_header_rec.Contract_template_id = FND_API.G_MISS_NUM) THEN

1129: IF (p_x_header_rec.END_CUSTOMER_CONTACT_ID = FND_API.G_MISS_NUM) THEN
1130: p_x_header_rec.END_CUSTOMER_CONTACT_ID := NULL;
1131: END IF;
1132: --
1133: IF (p_x_header_rec.Contract_template_id = FND_API.G_MISS_NUM) THEN
1134: p_x_header_rec.contract_template_id := NULL;
1135: END IF;
1136:
1137: IF (p_x_header_rec.customer_preference_set_code = FND_API.G_MISS_CHAR) THEN

Line 1137: IF (p_x_header_rec.customer_preference_set_code = FND_API.G_MISS_CHAR) THEN

1133: IF (p_x_header_rec.Contract_template_id = FND_API.G_MISS_NUM) THEN
1134: p_x_header_rec.contract_template_id := NULL;
1135: END IF;
1136:
1137: IF (p_x_header_rec.customer_preference_set_code = FND_API.G_MISS_CHAR) THEN
1138: p_x_header_rec.customer_preference_set_code := NULL;
1139: END IF;
1140:
1141: IF (p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE) THEN

Line 1141: IF (p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE) THEN

1137: IF (p_x_header_rec.customer_preference_set_code = FND_API.G_MISS_CHAR) THEN
1138: p_x_header_rec.customer_preference_set_code := NULL;
1139: END IF;
1140:
1141: IF (p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE) THEN
1142: p_x_header_rec.credit_card_approval_date := NULL;
1143: END IF;
1144:
1145: IF (p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN

Line 1145: IF (p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN

1141: IF (p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE) THEN
1142: p_x_header_rec.credit_card_approval_date := NULL;
1143: END IF;
1144:
1145: IF (p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN
1146: p_x_header_rec.flow_status_code := NULL;
1147: END IF;
1148:
1149: IF (p_x_header_rec.customer_payment_term_id = FND_API.G_MISS_NUM) THEN

Line 1149: IF (p_x_header_rec.customer_payment_term_id = FND_API.G_MISS_NUM) THEN

1145: IF (p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN
1146: p_x_header_rec.flow_status_code := NULL;
1147: END IF;
1148:
1149: IF (p_x_header_rec.customer_payment_term_id = FND_API.G_MISS_NUM) THEN
1150: p_x_header_rec.customer_payment_term_id := NULL;
1151: END IF;
1152:
1153: IF (p_x_header_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN

Line 1153: IF (p_x_header_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN

1149: IF (p_x_header_rec.customer_payment_term_id = FND_API.G_MISS_NUM) THEN
1150: p_x_header_rec.customer_payment_term_id := NULL;
1151: END IF;
1152:
1153: IF (p_x_header_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN
1154: p_x_header_rec.drop_ship_flag := NULL;
1155: END IF;
1156:
1157: IF (p_x_header_rec.change_sequence = FND_API.G_MISS_CHAR) THEN

Line 1157: IF (p_x_header_rec.change_sequence = FND_API.G_MISS_CHAR) THEN

1153: IF (p_x_header_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN
1154: p_x_header_rec.drop_ship_flag := NULL;
1155: END IF;
1156:
1157: IF (p_x_header_rec.change_sequence = FND_API.G_MISS_CHAR) THEN
1158: p_x_header_rec.change_sequence := NULL;
1159: END IF;
1160:
1161: IF (p_x_header_rec.lock_control = FND_API.G_MISS_NUM) THEN

Line 1161: IF (p_x_header_rec.lock_control = FND_API.G_MISS_NUM) THEN

1157: IF (p_x_header_rec.change_sequence = FND_API.G_MISS_CHAR) THEN
1158: p_x_header_rec.change_sequence := NULL;
1159: END IF;
1160:
1161: IF (p_x_header_rec.lock_control = FND_API.G_MISS_NUM) THEN
1162: p_x_header_rec.lock_control := NULL;
1163: END IF;
1164:
1165: IF (p_x_header_rec.sold_to_phone_id = FND_API.G_MISS_NUM) THEN

Line 1165: IF (p_x_header_rec.sold_to_phone_id = FND_API.G_MISS_NUM) THEN

1161: IF (p_x_header_rec.lock_control = FND_API.G_MISS_NUM) THEN
1162: p_x_header_rec.lock_control := NULL;
1163: END IF;
1164:
1165: IF (p_x_header_rec.sold_to_phone_id = FND_API.G_MISS_NUM) THEN
1166: p_x_header_rec.sold_to_phone_id := NULL;
1167: END IF;
1168:
1169: IF (p_x_header_rec.contract_source_doc_type_code = FND_API.G_MISS_CHAR) THEN

Line 1169: IF (p_x_header_rec.contract_source_doc_type_code = FND_API.G_MISS_CHAR) THEN

1165: IF (p_x_header_rec.sold_to_phone_id = FND_API.G_MISS_NUM) THEN
1166: p_x_header_rec.sold_to_phone_id := NULL;
1167: END IF;
1168:
1169: IF (p_x_header_rec.contract_source_doc_type_code = FND_API.G_MISS_CHAR) THEN
1170: p_x_header_rec.contract_source_doc_type_code := NULL;
1171: END IF;
1172:
1173: IF (p_x_header_rec.contract_source_document_id = FND_API.G_MISS_NUM) THEN

Line 1173: IF (p_x_header_rec.contract_source_document_id = FND_API.G_MISS_NUM) THEN

1169: IF (p_x_header_rec.contract_source_doc_type_code = FND_API.G_MISS_CHAR) THEN
1170: p_x_header_rec.contract_source_doc_type_code := NULL;
1171: END IF;
1172:
1173: IF (p_x_header_rec.contract_source_document_id = FND_API.G_MISS_NUM) THEN
1174: p_x_header_rec.contract_source_document_id := NULL;
1175: END IF;
1176:
1177: -- Bug 9367257 starts

Line 1178: IF (p_x_header_rec.cc_instrument_id = FND_API.G_MISS_NUM) THEN

1174: p_x_header_rec.contract_source_document_id := NULL;
1175: END IF;
1176:
1177: -- Bug 9367257 starts
1178: IF (p_x_header_rec.cc_instrument_id = FND_API.G_MISS_NUM) THEN
1179: p_x_header_rec.cc_instrument_id := NULL;
1180: END IF;
1181: -- Bug 9367257 ends
1182:

Line 1188: IF (p_x_header_rec.minisite_id = FND_API.G_MISS_NUM) THEN

1184:
1185:
1186: -- Bug # 5490345
1187:
1188: IF (p_x_header_rec.minisite_id = FND_API.G_MISS_NUM) THEN
1189: p_x_header_rec.minisite_id := NULL;
1190: END IF;
1191:
1192: -- QUOTING changes

Line 1209: p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR

1205: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
1206: p_x_header_rec.ordered_date := null;
1207: -- Default initial flow status to 'Draft' for negotiation orders
1208: IF p_x_header_rec.flow_status_code = 'ENTERED' OR
1209: p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR
1210: THEN
1211: p_x_header_rec.flow_status_code := 'DRAFT';
1212: END IF;
1213: -- bug 3854887

Line 1218: p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR

1214: ELSIF p_x_header_rec.transaction_phase_code = 'F' THEN
1215: p_x_header_rec.quote_date := null;
1216: -- Default initial flow status to 'Entered' for fulfillment orders
1217: IF p_x_header_rec.flow_status_code = 'DRAFT' OR
1218: p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR
1219: THEN
1220: p_x_header_rec.flow_status_code := 'ENTERED';
1221: END IF;
1222: END IF;

Line 1246: IF (nvl(p_x_header_rec.xml_message_id, FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM AND

1242:
1243: -- QUOTING changes END
1244: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
1245: -- bug 3417786
1246: IF (nvl(p_x_header_rec.xml_message_id, FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM AND
1247: p_x_header_rec.order_source_id = 0) THEN
1248: p_x_header_rec.xml_message_id := Get_EM_Message_Id;
1249: END IF;
1250: END IF;

Line 1258: WHEN FND_API.G_EXC_ERROR THEN

1254: END IF;
1255:
1256: EXCEPTION
1257:
1258: WHEN FND_API.G_EXC_ERROR THEN
1259:
1260: RAISE FND_API.G_EXC_ERROR;
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1260: RAISE FND_API.G_EXC_ERROR;

1256: EXCEPTION
1257:
1258: WHEN FND_API.G_EXC_ERROR THEN
1259:
1260: RAISE FND_API.G_EXC_ERROR;
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263:
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1258: WHEN FND_API.G_EXC_ERROR THEN
1259:
1260: RAISE FND_API.G_EXC_ERROR;
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263:
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265:
1266: WHEN OTHERS THEN

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: RAISE FND_API.G_EXC_ERROR;
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263:
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265:
1266: WHEN OTHERS THEN
1267:
1268: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1272: 'Attributes'
1273: );
1274: END IF;
1275:
1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277:
1278: END Attributes;
1279:
1280: END OE_Default_Header ;