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_LINE dependencies on FND_API

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

68: ( G_PKG_NAME,
69: 'Get_Sold_To'
70: );
71: END IF;
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END Get_Sold_To;
74:
75: FUNCTION Get_Order_Source_Id
76: RETURN NUMBER

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98: ( G_PKG_NAME,
99: 'Get_Order_Source_Id'
100: );
101: END IF;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103:
104: END Get_Order_Source_Id;
105:
106: FUNCTION GET_FREIGHT_CARRIER(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

Line 121: p_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND

117: END IF;
118:
119:
120: IF (p_line_rec.shipping_method_code IS NOT NULL AND
121: p_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
122: (p_line_rec.ship_from_org_id IS NOT NULL AND
123: p_line_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
124:
125: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null

Line 123: p_line_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN

119:
120: IF (p_line_rec.shipping_method_code IS NOT NULL AND
121: p_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
122: (p_line_rec.ship_from_org_id IS NOT NULL AND
123: p_line_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
124:
125: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
126: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code
127: ,p_old_line_rec.shipping_method_code) OR

Line 172: p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR) THEN

168: RETURN NULL;
169: END IF;
170:
171: IF (p_line_rec.shipping_method_code IS NULL OR
172: p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR) THEN
173: RETURN NULL;
174: END IF;
175:
176:

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: END IF;
196: IF l_debug_level > 0 THEN
197: oe_debug_pub.add( 'OTHERS IN GET_FREIGHT_CARRIER' , 1 ) ;
198: END IF;
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200:
201:
202: END GET_FREIGHT_CARRIER;
203:

Line 216: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM

212:
213: IF NOT oe_globals.G_HTML_FLAG THEN
214:
215: -- use order_header cache instead of sql : bug 4200055
216: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
217: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
218: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
219: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
220: else

Line 328: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM)

324: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE : PROCEDURE GET_TOP_MODEL_LINE' ) ;
325: END IF;
326:
327: IF ( g_line_rec.inventory_item_id is NULL OR
328: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
329: THEN
330: RETURN NULL;
331: END IF;
332:

Line 337: IF g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN

333: IF g_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
334: RETURN NULL;
335: ELSE
336: -- class/option, avoid setting value to null by the last return.
337: IF g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
338: RETURN g_line_rec.top_model_line_id;
339: END IF;
340:
341: END IF;

Line 354: g_line_rec.line_id <> FND_API.G_MISS_NUM)

350: l_pick_components_flag = 'Y') OR -- KIT
351: l_item_type = 1 -- MODEL
352: THEN
353: IF (g_line_rec.line_id is NOT NULL AND
354: g_line_rec.line_id <> FND_API.G_MISS_NUM)
355: THEN
356: l_top_model_line_id := g_line_rec.line_id;
357: RETURN (l_top_model_line_id);
358: ELSE

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: THEN
356: l_top_model_line_id := g_line_rec.line_id;
357: RETURN (l_top_model_line_id);
358: ELSE
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;
361: ELSE
362: RETURN NULL;
363: END IF;

Line 369: g_line_rec.ordered_item = FND_API.G_MISS_CHAR) THEN

365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN
367: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_ITEM_NOT_FOUND');
368: IF ( g_line_rec.ordered_item is NULL OR -- This IF added for 1722670
369: g_line_rec.ordered_item = FND_API.G_MISS_CHAR) THEN
370: FND_MESSAGE.Set_TOKEN('ITEM',
371: 'Item with inventory_item_id='||to_char(g_line_rec.inventory_item_id));
372: ELSE
373: FND_MESSAGE.Set_TOKEN('ITEM', nvl(g_line_rec.ordered_item,g_line_rec.inventory_item_id));

Line 387: RAISE FND_API.G_EXC_ERROR;

383: IF l_debug_level > 0 THEN
384: oe_debug_pub.add( 'NO DATA FOUND IN GET_TOP_MODEL IN DEFAULTING' , 1 ) ;
385: END IF;
386:
387: RAISE FND_API.G_EXC_ERROR;
388:
389: WHEN OTHERS THEN
390:
391: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

397: END IF;
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add( 'OTHERS IN GET_TOP_MODEL IN DEFAULTING' , 1 ) ;
400: END IF;
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402:
403: END Get_Top_Model_Line;
404:
405: -- forward declaration

Line 473: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

469: p_x_line_rec.agreement_id := l_agreement_id;
470: l_line_tbl(1) := p_x_line_rec;
471:
472: Oe_Order_Pvt.Lines
473: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
474: , p_control_rec => l_control_rec
475: , p_x_line_tbl => l_line_tbl
476: , p_x_old_line_tbl => l_old_line_tbl
477: , x_return_status => l_return_status

Line 480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

476: , p_x_old_line_tbl => l_old_line_tbl
477: , x_return_status => l_return_status
478: );
479:
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;

Line 481: RAISE FND_API.G_EXC_ERROR;

477: , x_return_status => l_return_status
478: );
479:
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:

Line 482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

478: );
479:
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: p_x_line_rec := l_line_tbl(1);

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479:
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: p_x_line_rec := l_line_tbl(1);
487:

Line 497: WHEN FND_API.G_EXC_ERROR THEN

493: oe_debug_pub.add( 'NO ACTIVE REVISION EXISTS FOR THE AGREEMENT ID :'||P_X_LINE_REC.AGREEMENT_ID , 2 ) ;
494: oe_debug_pub.add( 'ERROR WILL BE RAISED IN ENTITY LEVEL VALIDATION' , 3 ) ;
495: END IF;
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: RAISE FND_API.G_EXC_ERROR;
499:
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 498: RAISE FND_API.G_EXC_ERROR;

494: oe_debug_pub.add( 'ERROR WILL BE RAISED IN ENTITY LEVEL VALIDATION' , 3 ) ;
495: END IF;
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: RAISE FND_API.G_EXC_ERROR;
499:
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502:

Line 500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: RAISE FND_API.G_EXC_ERROR;
499:
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502:
503: WHEN OTHERS THEN
504: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

497: WHEN FND_API.G_EXC_ERROR THEN
498: RAISE FND_API.G_EXC_ERROR;
499:
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502:
503: WHEN OTHERS THEN
504: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

508: 'Default_Active_Agr_Revision'
509: );
510: END IF;
511:
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513:
514: End Default_Active_Agr_Revision;
515: /* End of Bug-2154960 */
516:

Line 643: p_request_date <> FND_API.G_MISS_DATE THEN

639: OE_Sys_Parameters.Value('MASTER_ORGANIZATION_ID');
640: BEGIN
641:
642: IF p_request_date IS NOT NULL AND
643: p_request_date <> FND_API.G_MISS_DATE THEN
644: x_blanket_request_date := p_request_date;
645: ELSE
646: x_blanket_request_date := sysdate;
647: END IF;

Line 649: IF p_blanket_number = FND_API.G_MISS_NUM THEN

645: ELSE
646: x_blanket_request_date := sysdate;
647: END IF;
648:
649: IF p_blanket_number = FND_API.G_MISS_NUM THEN
650: l_blanket_number := NULL;
651: ELSE
652: l_blanket_number := p_blanket_number;
653: END IF;

Line 666: (p_cust_po_number = FND_API.G_MISS_CHAR OR

662: --to select most specific of effective blanket lines
663:
664: -- added for bug 4246913
665: if l_blanket_number is null AND
666: (p_cust_po_number = FND_API.G_MISS_CHAR OR
667: p_cust_po_number IS NULL) then
668:
669: if l_debug_level > 0 then
670: oe_debug_pub.add('No blanket or customer po number on line, returning');

Line 962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

958: END IF;
959: IF l_debug_level > 0 THEN
960: oe_debug_pub.add('others in default_blanket_values', 1);
961: END IF;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963:
964: End Default_Blanket_Values;
965:
966:

Line 984: AND p_x_line_rec.blanket_number <> FND_API.G_MISS_NUM)

980: --
981: BEGIN
982:
983: IF (p_x_line_rec.blanket_number IS NOT NULL
984: AND p_x_line_rec.blanket_number <> FND_API.G_MISS_NUM)
985: OR ( p_x_line_rec.cust_po_number IS NOT NULL
986: AND p_x_line_rec.cust_po_number <> FND_API.G_MISS_CHAR
987: -- Bug 2818494
988: -- Default blanket from customer PO only if either

Line 986: AND p_x_line_rec.cust_po_number <> FND_API.G_MISS_CHAR

982:
983: IF (p_x_line_rec.blanket_number IS NOT NULL
984: AND p_x_line_rec.blanket_number <> FND_API.G_MISS_NUM)
985: OR ( p_x_line_rec.cust_po_number IS NOT NULL
986: AND p_x_line_rec.cust_po_number <> FND_API.G_MISS_CHAR
987: -- Bug 2818494
988: -- Default blanket from customer PO only if either
989: -- customer PO or item is updated on order line.
990: AND (NOT OE_GLOBALS.EQUAL(p_x_line_rec.cust_po_number

Line 1022: AND p_x_line_rec.blanket_line_number <> FND_API.G_MISS_NUM

1018: -- executed for all release lines even if there was a blanket
1019: -- line number which could result in over-riding an existing
1020: -- blanket line number value.
1021: IF p_x_line_rec.blanket_line_number IS NOT NULL
1022: AND p_x_line_rec.blanket_line_number <> FND_API.G_MISS_NUM
1023: THEN
1024:
1025: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
1026: OR p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM)

Line 1026: OR p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM)

1022: AND p_x_line_rec.blanket_line_number <> FND_API.G_MISS_NUM
1023: THEN
1024:
1025: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
1026: OR p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM)
1027: THEN
1028:
1029: if l_debug_level > 0 then
1030: oe_debug_pub.add('Default Blanket Version Number');

Line 1064: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM

1060:
1061: -- Bug 2737082 => Only if blanket line number is null or missing,
1062: -- then default if required fields are available.
1063: ELSIF (p_x_line_rec.sold_to_org_id IS NOT NULL
1064: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1065: AND p_x_line_rec.inventory_item_id IS NOT NULL
1066: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1067: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1068: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT

Line 1066: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM

1062: -- then default if required fields are available.
1063: ELSIF (p_x_line_rec.sold_to_org_id IS NOT NULL
1064: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1065: AND p_x_line_rec.inventory_item_id IS NOT NULL
1066: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1067: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1068: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1069: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id)
1070: )

Line 1075: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM

1071: -- Bug 2769562 => If blanket line number is being cleared by user
1072: -- (value for blanket line number existed in old rec), blanket
1073: -- fields should NOT be re-defaulted.
1074: AND (p_old_line_rec.blanket_line_number IS NULL
1075: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM
1076: )) OR (p_x_line_rec.sold_to_org_id IS NOT NULL
1077: --Bug 3228828
1078: --Defaulting of the Blanket Line Number for Config and Service Items.
1079: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM

Line 1079: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM

1075: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM
1076: )) OR (p_x_line_rec.sold_to_org_id IS NOT NULL
1077: --Bug 3228828
1078: --Defaulting of the Blanket Line Number for Config and Service Items.
1079: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1080: AND p_x_line_rec.inventory_item_id IS NOT NULL
1081: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1082: AND oe_code_control.get_code_release_level >= '110510'
1083: -- Bug 2769562 => If blanket line number is being cleared by user

Line 1081: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM

1077: --Bug 3228828
1078: --Defaulting of the Blanket Line Number for Config and Service Items.
1079: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1080: AND p_x_line_rec.inventory_item_id IS NOT NULL
1081: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1082: AND oe_code_control.get_code_release_level >= '110510'
1083: -- Bug 2769562 => If blanket line number is being cleared by user
1084: -- (value for blanket line number existed in old rec), blanket
1085: -- fields should NOT be re-defaulted.

Line 1087: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM

1083: -- Bug 2769562 => If blanket line number is being cleared by user
1084: -- (value for blanket line number existed in old rec), blanket
1085: -- fields should NOT be re-defaulted.
1086: AND (p_old_line_rec.blanket_line_number IS NULL
1087: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM
1088: ) OR p_x_line_rec.blanket_line_number <> p_old_line_rec.blanket_line_number
1089: OR (p_x_line_rec.blanket_line_number IS NOT NULL --6368131
1090: AND trunc(p_x_line_rec.request_date) <>
1091: trunc(p_old_line_rec.request_date))

Line 1143: WHEN FND_API.G_EXC_ERROR THEN

1139:
1140: END IF; -- if blanket number or cust po exists
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: RAISE FND_API.G_EXC_ERROR;
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: WHEN OTHERS THEN

Line 1144: RAISE FND_API.G_EXC_ERROR;

1140: END IF; -- if blanket number or cust po exists
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: RAISE FND_API.G_EXC_ERROR;
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: WHEN OTHERS THEN
1148: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: RAISE FND_API.G_EXC_ERROR;
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: WHEN OTHERS THEN
1148: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1149: THEN

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: RAISE FND_API.G_EXC_ERROR;
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: WHEN OTHERS THEN
1148: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1149: THEN
1150: OE_MSG_PUB.Add_Exc_Msg

Line 1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1151: ( G_PKG_NAME ,
1152: 'Perform_Blanket_Functions'
1153: );
1154: END IF;
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: END Perform_Blanket_Functions;
1157:
1158: --- Added for 11510 pack J to get the BSA Line Number and Version Number
1159: --- For given CONFIG and SERVICE items. srini

Line 1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1309: (p_line_id => g_line_rec.top_model_line_id,
1310: p_child_line_id => g_line_rec.line_id,
1311: x_return_status => l_return_status);
1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;

Line 1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1310: p_child_line_id => g_line_rec.line_id,
1311: x_return_status => l_return_status);
1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318: END IF;

Line 1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1311: x_return_status => l_return_status);
1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318: END IF;
1319:

Line 1316: RAISE FND_API.G_EXC_ERROR;

1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318: END IF;
1319:
1320:

Line 1339: IF g_line_rec.ato_line_id = FND_API.G_MISS_NUM THEN

1335: RETURN;
1336: END IF;
1337:
1338:
1339: IF g_line_rec.ato_line_id = FND_API.G_MISS_NUM THEN
1340: g_line_rec.ato_line_id := Get_ATO_Line;
1341: IF l_debug_level > 0 THEN
1342: oe_debug_pub.add( 'GET_ATO_LINE SUCCESSFUL' , 1 ) ;
1343: END IF;

Line 1418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1414: IF l_debug_level > 0 THEN
1415: oe_debug_pub.add( 'RETURN STATUS || ' || L_RETURN_STATUS , 3 ) ;
1416: END IF;
1417:
1418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;

Line 1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1415: oe_debug_pub.add( 'RETURN STATUS || ' || L_RETURN_STATUS , 3 ) ;
1416: END IF;
1417:
1418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:

Line 1420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1416: END IF;
1417:
1418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:
1424: IF l_debug_level > 0 THEN

Line 1421: RAISE FND_API.G_EXC_ERROR;

1417:
1418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'EXITING MODEL_OPTION_DEFAULTING' , 1 ) ;

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430: WHEN NO_DATA_FOUND THEN
1431: IF l_debug_level > 0 THEN
1432: oe_debug_pub.add( 'NO DATA FOUND IN MODEL_OPTION_DEFAULTING' , 1 ) ;
1433: END IF;
1434: RAISE FND_API.G_EXC_ERROR;
1435:
1436: WHEN OTHERS THEN
1437: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1438: THEN

Line 1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1443: END IF;
1444: IF l_debug_level > 0 THEN
1445: oe_debug_pub.add( 'OTHERS IN MODEL_OPTION_DEFAULTING' , 1 ) ;
1446: END IF;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448:
1449: END Model_Option_Defaulting;
1450:
1451:

Line 1517: RAISE FND_API.G_EXC_ERROR;

1513: IF l_debug_level > 0 THEN
1514: oe_debug_pub.add( 'NO DATA FOUND IN MODEL_OPTION_UPDATE' , 1 ) ;
1515: END IF;
1516:
1517: RAISE FND_API.G_EXC_ERROR;
1518:
1519: WHEN OTHERS THEN
1520:
1521: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1527: END IF;
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add( 'OTHERS IN MODEL_OPTION_UPDATE' , 1 ) ;
1530: END IF;
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532:
1533: END Model_Option_Update;
1534:
1535: /*-------------------------------------------------------------

Line 1577: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM)

1573: RETURN g_line_rec.ato_line_id;
1574: END IF;
1575:
1576: IF ( g_line_rec.inventory_item_id is NULL OR
1577: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
1578: THEN
1579: RETURN NULL;
1580: END IF;
1581:

Line 1651: g_line_rec.config_header_id <> FND_API.G_MISS_NUM AND

1647: BEGIN
1648:
1649: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' AND
1650: g_line_rec.config_header_id is not NULL AND
1651: g_line_rec.config_header_id <> FND_API.G_MISS_NUM AND
1652: g_line_rec.configuration_id is not NULL AND
1653: g_line_rec.configuration_id <> FND_API.G_MISS_NUM
1654: THEN
1655: IF l_debug_level > 0 THEN

Line 1653: g_line_rec.configuration_id <> FND_API.G_MISS_NUM

1649: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' AND
1650: g_line_rec.config_header_id is not NULL AND
1651: g_line_rec.config_header_id <> FND_API.G_MISS_NUM AND
1652: g_line_rec.configuration_id is not NULL AND
1653: g_line_rec.configuration_id <> FND_API.G_MISS_NUM
1654: THEN
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add( 'GET_ATO: PACK H NEW LOGIC MI ' || G_LINE_REC.CONFIG_HEADER_ID , 1 ) ;
1657: oe_debug_pub.add( 'CONFIGN ID ' || G_LINE_REC.CONFIGURATION_ID , 1 ) ;

Line 1804: RAISE FND_API.G_EXC_ERROR;

1800:
1801: EXCEPTION
1802:
1803: WHEN TOO_MANY_ROWS THEN
1804: RAISE FND_API.G_EXC_ERROR;
1805:
1806: WHEN OTHERS THEN
1807:
1808: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1812: 'Get_ATO_Line'
1813: );
1814: END IF;
1815:
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817:
1818:
1819: END Get_ATO_line;
1820:

Line 1865: x_return_status := FND_API.G_RET_STS_SUCCESS;

1861:
1862:
1863: END LOOP;
1864:
1865: x_return_status := FND_API.G_RET_STS_SUCCESS;
1866: IF l_debug_level > 0 THEN
1867: oe_debug_pub.add( 'EXITING FROM INSERT_INTO_SET' , 1 ) ;
1868: END IF;
1869:

Line 1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1869:
1870: EXCEPTION
1871:
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874:
1875: END Insert_Into_set;
1876:
1877:

Line 1904: IF (p_old_line_rec.item_type_code <> FND_API.G_MISS_CHAR AND

1900: oe_debug_pub.add( 'ENTERING CHECK ITEM TYPE' ) ;
1901: oe_debug_pub.add( 'ITEM TYPE '|| P_ITEM_TYPE_CODE ) ;
1902: END IF;
1903: IF p_line_rec.operation = oe_globals.g_opr_update THEN
1904: IF (p_old_line_rec.item_type_code <> FND_API.G_MISS_CHAR AND
1905: p_old_line_rec.item_type_code IS NOT NULL) THEN
1906:
1907: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.item_type_code,
1908: p_item_type_code) THEN

Line 1915: RAISE FND_API.G_EXC_ERROR;

1911: OE_MSG_PUB.ADD;
1912: IF l_debug_level > 0 THEN
1913: oe_debug_pub.add( 'ITEM_TYPE_CODE CONSTRAINED' ) ;
1914: END IF;
1915: RAISE FND_API.G_EXC_ERROR;
1916:
1917: END IF;
1918: END IF;
1919: END IF;

Line 1951: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )

1947: --6933507
1948: END IF;
1949:
1950: IF ( g_line_rec.inventory_item_id is NULL OR
1951: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )
1952: THEN
1953: -- Bug 4721305 condition added to ignore when inventory item is nulled
1954: IF p_line_rec.ITEM_TYPE_CODE IS NOT NULL AND
1955: p_line_rec.ITEM_TYPE_CODE <> FND_API.G_MISS_CHAR THEN

Line 1955: p_line_rec.ITEM_TYPE_CODE <> FND_API.G_MISS_CHAR THEN

1951: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )
1952: THEN
1953: -- Bug 4721305 condition added to ignore when inventory item is nulled
1954: IF p_line_rec.ITEM_TYPE_CODE IS NOT NULL AND
1955: p_line_rec.ITEM_TYPE_CODE <> FND_API.G_MISS_CHAR THEN
1956: Check_Item_Type(p_line_rec,
1957: p_old_line_rec,
1958: NULL);
1959: END IF;

Line 1969: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN

1965: RETURN OE_GLOBALS.G_ITEM_STANDARD;
1966: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
1967: ELSIF p_line_rec.line_category_code = 'ORDER'
1968: and p_line_rec.retrobill_request_id is NOT NULL
1969: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
1970:
1971: RETURN OE_GLOBALS.G_ITEM_STANDARD;
1972: --- BUG#6933507
1973: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

Line 2048: g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM)

2044:
2045: IF l_pick_components_flag = 'Y' THEN
2046: l_item_type_code := OE_GLOBALS.G_ITEM_KIT;
2047: ELSIF (g_line_rec.top_model_line_id is not null AND
2048: g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM)
2049: THEN
2050: IF l_debug_level > 0 THEN
2051: oe_debug_pub.add( 'GET_ITEM_TYPE NO DATA FOUND , BOM_ITEM_TYPE : 4' , 1 ) ;
2052: END IF;

Line 2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2109: );
2110: END IF;
2111: */
2112:
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114:
2115: END Get_Item_Type;
2116:
2117:

Line 2182: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN

2178:
2179: /* replaced with the following IF for 2421909
2180: IF (p_line_rec.operation = oe_globals.g_opr_create) and
2181: (p_line_rec.line_type_id IS NULL OR
2182: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2183: */
2184:
2185: IF (p_line_rec.line_type_id IS NULL OR -- 2421909
2186: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN

Line 2186: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN

2182: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2183: */
2184:
2185: IF (p_line_rec.line_type_id IS NULL OR -- 2421909
2186: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2187:
2188: IF l_debug_level > 0 THEN
2189: oe_debug_pub.add( 'AK IN DEFAULTING: WHEN LINE_TYPE_ID IS NULL' , 1 ) ;
2190: oe_debug_pub.add( 'AK IN DEFAULTING:' || P_LINE_REC.HEADER_ID , 1 ) ;

Line 2244: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND

2240: END IF;
2241:
2242: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2243:
2244: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2245: p_old_line_rec.line_category_code IS NOT NULL) THEN
2246:
2247: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2248: l_category) THEN

Line 2265: RAISE FND_API.G_EXC_ERROR;

2261: OE_MSG_PUB.ADD;
2262: IF l_debug_level > 0 THEN
2263: oe_debug_pub.add( 'LINE CATEGORY CONSTRINED' ) ;
2264: END IF;
2265: RAISE FND_API.G_EXC_ERROR;
2266: END IF;
2267: END IF;
2268:
2269: END IF;

Line 2288: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND

2284: END IF;
2285: l_category := 'ORDER';
2286: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2287:
2288: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2289: p_old_line_rec.line_category_code IS NOT NULL) THEN
2290:
2291: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2292: l_category) THEN

Line 2298: RAISE FND_API.G_EXC_ERROR;

2294: OE_MSG_PUB.ADD;
2295: IF l_debug_level > 0 THEN
2296: oe_debug_pub.add( 'LINE CATEGORY CONSTRINED' ) ;
2297: END IF;
2298: RAISE FND_API.G_EXC_ERROR;
2299: END IF;
2300:
2301: END IF;
2302: END IF;

Line 2315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2311: 'Line_Category'
2312: );
2313: END IF;
2314:
2315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2316:
2317:
2318: END Get_Line_Category;
2319:

Line 2336: OR g_line_rec.top_model_line_id = FND_API.G_MISS_NUM

2332: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE: FUNCTION GET_LINE_NUMBER' ) ;
2333: END IF;
2334:
2335: IF g_line_rec.top_model_line_id IS NULL
2336: OR g_line_rec.top_model_line_id = FND_API.G_MISS_NUM
2337: OR g_line_rec.line_id = g_line_rec.top_model_line_id
2338: THEN
2339:
2340: SELECT NVL(MAX(LINE_NUMBER)+1,1)

Line 2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2372: 'Get_Line_Number'
2373: );
2374: END IF;
2375:
2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2377:
2378: END Get_Line_Number;
2379:
2380: FUNCTION Get_Latest_Acceptable_Date(p_request_date IN DATE)

Line 2410: IF g_line_rec.ordered_quantity = FND_API.G_MISS_NUM then

2406: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2407: --
2408: BEGIN
2409:
2410: IF g_line_rec.ordered_quantity = FND_API.G_MISS_NUM then
2411: RETURN NULL;
2412: ELSE
2413: IF g_line_rec.pricing_quantity_uom is not null
2414: AND g_line_rec.pricing_quantity_uom <> FND_API.G_MISS_CHAR

Line 2414: AND g_line_rec.pricing_quantity_uom <> FND_API.G_MISS_CHAR

2410: IF g_line_rec.ordered_quantity = FND_API.G_MISS_NUM then
2411: RETURN NULL;
2412: ELSE
2413: IF g_line_rec.pricing_quantity_uom is not null
2414: AND g_line_rec.pricing_quantity_uom <> FND_API.G_MISS_CHAR
2415: THEN
2416: RETURN (OE_Order_Misc_Util.convert_uom(g_line_rec.inventory_item_id,
2417: g_line_rec.order_quantity_uom,
2418: g_line_rec.pricing_quantity_uom,

Line 2437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2433: 'Get_Pricing_Quantity'
2434: );
2435: END IF;
2436:
2437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2438:
2439: END Get_Pricing_Quantity;
2440:
2441: FUNCTION Get_Shipment_Number

Line 2455: OR g_line_rec.top_model_line_id = FND_API.G_MISS_NUM

2451: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE: FUNCTION GET_SHIPMENT_NUMBER' ) ;
2452: END IF;
2453:
2454: IF g_line_rec.top_model_line_id IS NULL
2455: OR g_line_rec.top_model_line_id = FND_API.G_MISS_NUM
2456: OR g_line_rec.line_id = g_line_rec.top_model_line_id
2457: THEN
2458:
2459: -- Bug 1929163: shipment number is 1 for non-split lines

Line 2461: OR g_line_rec.split_from_line_id = FND_API.G_MISS_NUM THEN

2457: THEN
2458:
2459: -- Bug 1929163: shipment number is 1 for non-split lines
2460: IF g_line_rec.split_from_line_id IS NULL
2461: OR g_line_rec.split_from_line_id = FND_API.G_MISS_NUM THEN
2462:
2463: l_ship_number := 1;
2464:
2465: ELSE

Line 2497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2493: 'Get_Shipment_Number'
2494: );
2495: END IF;
2496:
2497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2498:
2499: END Get_Shipment_Number;
2500:
2501: FUNCTION Get_Shipping_Interfaced

Line 2528: p_line_type_id <> FND_API.G_MISS_NUM THEN

2524: oe_debug_pub.add( 'DEFAULTING SOURCE TYPE' ) ;
2525: END IF;
2526:
2527: IF p_line_type_id is not null AND
2528: p_line_type_id <> FND_API.G_MISS_NUM THEN
2529:
2530: BEGIN
2531:
2532: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);

Line 2578: p_inventory_item_id = FND_API.G_MISS_NUM )

2574: --
2575: BEGIN
2576:
2577: IF ( p_inventory_item_id is NULL OR
2578: p_inventory_item_id = FND_API.G_MISS_NUM )
2579: THEN
2580: RETURN NULL;
2581: END IF;
2582:

Line 2593: (p_ato_line_id <> FND_API.G_MISS_NUM)

2589: END IF;
2590:
2591:
2592: IF (p_ato_line_id is not null) AND
2593: (p_ato_line_id <> FND_API.G_MISS_NUM)
2594: THEN
2595:
2596: -- ##1820608, ato_item can be under a pto model.
2597: IF NOT OE_GLOBALS.Equal(p_item_type_code,

Line 2639: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )

2635: oe_debug_pub.add( 'DEFAULTING SMC FLAG ' , 1 ) ;
2636: END IF;
2637:
2638: IF ( g_line_rec.inventory_item_id is NULL OR
2639: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )
2640: THEN
2641: RETURN NULL;
2642: IF l_debug_level > 0 THEN
2643: oe_debug_pub.add( 'SMC1 FLAG VALUE IS NULL' , 1 ) ;

Line 2665: g_line_rec.ship_model_complete_flag <> FND_API.G_MISS_CHAR AND

2661: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;
2662:
2663: ELSIF
2664: g_line_rec.ship_model_complete_flag is not null AND
2665: g_line_rec.ship_model_complete_flag <> FND_API.G_MISS_CHAR AND
2666: g_line_rec.top_model_line_id is not NULL
2667: THEN
2668: IF l_debug_level > 0 THEN
2669: oe_debug_pub.add( 'SMC4 FLAG ' || G_LINE_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;

Line 2942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2938: 'Get_Def_Invoice_Line_Int'
2939: );
2940: END IF;
2941:
2942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2943:
2944: END;
2945:
2946: RETURN to_number(p_return_attribute2);

Line 2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2954:
2955: OPEN control_codes;
2956: FETCH control_codes INTO l_lot_control_flag;
2957: IF control_codes%notfound THEN
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;
2960: CLOSE control_codes;
2961:
2962: BEGIN

Line 3051: RAISE FND_API.G_EXC_ERROR;

3047: END IF;
3048: IF l_line_tbl.count = 0 THEN
3049: FND_Message.Set_Name('ONT', 'OE_NO_LINES_FOR_SERIAL_NUMBER');
3050: oe_msg_pub.add;
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
3053:
3054: -- For all outbound lines which are referring to this serial number,
3055: -- one or more referenced RMA exists.

Line 3106: RAISE FND_API.G_EXC_ERROR;

3102: oe_debug_pub.add( 'IN SERIAL71 ' ) ;
3103: END IF;
3104: FND_Message.Set_Name('ONT', 'OE_DUPLICATE_LINES_FOR_SAME_SN');
3105: oe_msg_pub.add;
3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;
3108:
3109: IF l_debug_level > 0 THEN
3110: oe_debug_pub.add( 'IN SERIAL8 ' ) ;

Line 3163: RAISE FND_API.G_EXC_ERROR;

3159: oe_debug_pub.add( 'NO LINES AVAILABLE FOR RETURN' ) ;
3160: END IF;
3161: FND_Message.Set_Name('ONT', 'OE_NO_LINES_FOR_SERIAL_NUMBER');
3162: oe_msg_pub.add;
3163: RAISE FND_API.G_EXC_ERROR;
3164: ELSE
3165: IF l_debug_level > 0 THEN
3166: oe_debug_pub.add('LINE ' || TO_CHAR(L_ORDER_LINE_ID),1);
3167: END IF;

Line 3216: WHEN FND_API.G_EXC_ERROR THEN

3212: oe_debug_pub.add( 'IN SERIAL10' ) ;
3213: END IF;
3214:
3215: EXCEPTION
3216: WHEN FND_API.G_EXC_ERROR THEN
3217: RAISE FND_API.G_EXC_ERROR;
3218: WHEN OTHERS THEN
3219: IF l_debug_level > 0 THEN
3220: oe_debug_pub.add( 'IN OTHERS EXCEPTION FOR SERIAL' , 2 ) ;

Line 3217: RAISE FND_API.G_EXC_ERROR;

3213: END IF;
3214:
3215: EXCEPTION
3216: WHEN FND_API.G_EXC_ERROR THEN
3217: RAISE FND_API.G_EXC_ERROR;
3218: WHEN OTHERS THEN
3219: IF l_debug_level > 0 THEN
3220: oe_debug_pub.add( 'IN OTHERS EXCEPTION FOR SERIAL' , 2 ) ;
3221: END IF;

Line 3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3225: ( G_PKG_NAME ,
3226: 'OE_Default_Line.Get_Def_Invoice_Line_Int'
3227: );
3228: END IF;
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230:
3231: END;
3232:
3233: ELSIF p_return_context in ('PO','ORDER') THEN

Line 3244: RAISE FND_API.G_EXC_ERROR;

3240: IF l_order_number IS NULL THEN
3241: oe_debug_pub.add('Invalid Return Reference',1);
3242: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
3243: OE_MSG_PUB.Add;
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:
3247: BEGIN
3248:

Line 3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3341: 'Get_Defaulting_Order_Line'
3342: );
3343: END IF;
3344:
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346:
3347: END;
3348:
3349: ELSE

Line 3372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3368: 'Get_Defaulting_Order_Line'
3369: );
3370: END IF;
3371:
3372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3373:
3374: END;
3375:
3376: END IF;-- return context

Line 3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3419: 'Attributes_From_Invoice_Line'
3420: );
3421: END IF;
3422:
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: END;
3425:
3426: -- use this attributes as default if not overriden
3427: /* We can not copy the invoiced_quantity to ordered_quantity */

Line 3430: p_x_line_rec.ordered_quantity = FND_API.G_MISS_NUM) THEN

3426: -- use this attributes as default if not overriden
3427: /* We can not copy the invoiced_quantity to ordered_quantity */
3428: /*
3429: IF (p_x_line_rec.ordered_quantity IS NULL OR
3430: p_x_line_rec.ordered_quantity = FND_API.G_MISS_NUM) THEN
3431: p_x_line_rec.ordered_quantity := l_quantity;
3432: p_x_line_rec.order_quantity_uom := l_uom_code;
3433: ELSE
3434: NULL;

Line 3440: p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR) THEN

3436: */
3437:
3438:
3439: IF (p_x_line_rec.tax_exempt_flag IS NULL OR
3440: p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR) THEN
3441: p_x_line_rec.tax_exempt_flag := l_tax_exempt_flag;
3442: END IF;
3443:
3444: IF (p_x_line_rec.tax_exempt_reason_code IS NULL OR

Line 3445: p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR) THEN

3441: p_x_line_rec.tax_exempt_flag := l_tax_exempt_flag;
3442: END IF;
3443:
3444: IF (p_x_line_rec.tax_exempt_reason_code IS NULL OR
3445: p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR) THEN
3446: p_x_line_rec.tax_exempt_reason_code := l_tax_exempt_reason_code;
3447: END IF;
3448:
3449: IF (p_x_line_rec.tax_exempt_number IS NULL OR

Line 3450: p_x_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR) THEN

3446: p_x_line_rec.tax_exempt_reason_code := l_tax_exempt_reason_code;
3447: END IF;
3448:
3449: IF (p_x_line_rec.tax_exempt_number IS NULL OR
3450: p_x_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR) THEN
3451: p_x_line_rec.tax_exempt_number := l_tax_exempt_number;
3452: END IF;
3453:
3454: IF (p_x_line_rec.reference_customer_trx_line_id IS NULL OR

Line 3455: p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) THEN

3451: p_x_line_rec.tax_exempt_number := l_tax_exempt_number;
3452: END IF;
3453:
3454: IF (p_x_line_rec.reference_customer_trx_line_id IS NULL OR
3455: p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) THEN
3456: p_x_line_rec.reference_customer_trx_line_id := p_invoice_line_id;
3457: END IF;
3458:
3459: IF (p_x_line_rec.credit_invoice_line_id IS NULL OR

Line 3460: p_x_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM) THEN

3456: p_x_line_rec.reference_customer_trx_line_id := p_invoice_line_id;
3457: END IF;
3458:
3459: IF (p_x_line_rec.credit_invoice_line_id IS NULL OR
3460: p_x_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM) THEN
3461: p_x_line_rec.credit_invoice_line_id := p_invoice_line_id;
3462: END IF;
3463:
3464: END IF; -- exists invoice line

Line 3492: p_order_line_id<>FND_API.G_MISS_NUM) THEN

3488: oe_debug_pub.add( 'ENTERING ATTRIBUTES_FROM_ORDER_LINE with p_order_line_id = ' ||p_order_line_id , 1 ) ;
3489: END IF;
3490:
3491: IF (p_order_line_id IS NOT NULL AND
3492: p_order_line_id<>FND_API.G_MISS_NUM) THEN
3493:
3494: oe_line_util.query_row
3495: (p_line_id => p_order_line_id
3496: ,x_line_rec => l_ref_line_rec

Line 3501: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR)

3497: );
3498:
3499: /* assign the referenced fields */
3500: IF ((p_x_line_rec.ordered_item IS NULL OR
3501: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR)
3502: AND (p_x_line_rec.inventory_item_id IS NULL OR
3503: p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
3504: AND (p_x_line_rec.ordered_item_id IS NULL OR
3505: p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM)) THEN

Line 3503: p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM)

3499: /* assign the referenced fields */
3500: IF ((p_x_line_rec.ordered_item IS NULL OR
3501: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR)
3502: AND (p_x_line_rec.inventory_item_id IS NULL OR
3503: p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
3504: AND (p_x_line_rec.ordered_item_id IS NULL OR
3505: p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM)) THEN
3506: p_x_line_rec.ordered_item := l_ref_line_rec.ordered_item ;
3507: p_x_line_rec.inventory_item_id := l_ref_line_rec.inventory_item_id;

Line 3505: p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM)) THEN

3501: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR)
3502: AND (p_x_line_rec.inventory_item_id IS NULL OR
3503: p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
3504: AND (p_x_line_rec.ordered_item_id IS NULL OR
3505: p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM)) THEN
3506: p_x_line_rec.ordered_item := l_ref_line_rec.ordered_item ;
3507: p_x_line_rec.inventory_item_id := l_ref_line_rec.inventory_item_id;
3508: p_x_line_rec.item_identifier_type := l_ref_line_rec.item_identifier_type;
3509: p_x_line_rec.ordered_item_id := l_ref_line_rec.ordered_item_id;

Line 3521: p_x_line_rec.ordered_quantity = fnd_api.g_miss_num) THEN

3517: p_x_line_rec.order_quantity_uom := l_ref_line_rec.order_quantity_uom;
3518: END IF;
3519:
3520: IF (p_x_line_rec.ordered_quantity IS NULL OR
3521: p_x_line_rec.ordered_quantity = fnd_api.g_miss_num) THEN
3522:
3523: -- p_x_line_rec.ordered_quantity := l_ref_line_rec.ordered_quantity; -- bug# 6617423
3524: -- bug# 6617423 : Start ---------
3525: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);

Line 3526: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN

3522:
3523: -- p_x_line_rec.ordered_quantity := l_ref_line_rec.ordered_quantity; -- bug# 6617423
3524: -- bug# 6617423 : Start ---------
3525: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);
3526: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
3527: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
3528: ELSE
3529: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
3530: END IF;

Line 3551: p_x_line_rec.unit_cost = fnd_api.g_miss_num) THEN

3547: END IF;
3548:
3549:
3550: IF (p_x_line_rec.unit_cost IS NULL OR
3551: p_x_line_rec.unit_cost = fnd_api.g_miss_num) THEN
3552: p_x_line_rec.unit_cost := l_ref_line_rec.unit_cost;
3553: END IF;
3554:
3555: IF (p_x_line_rec.order_quantity_uom IS NULL OR

Line 3556: p_x_line_rec.order_quantity_uom = fnd_api.g_miss_char) THEN

3552: p_x_line_rec.unit_cost := l_ref_line_rec.unit_cost;
3553: END IF;
3554:
3555: IF (p_x_line_rec.order_quantity_uom IS NULL OR
3556: p_x_line_rec.order_quantity_uom = fnd_api.g_miss_char) THEN
3557: p_x_line_rec.order_quantity_uom := l_ref_line_rec.order_quantity_uom;
3558: END IF;
3559:
3560: -- 09/07/2001 OPM BEGIN - Default process attributes as appropriate from an order line ref

Line 3562: IF (p_x_line_rec.ordered_quantity_uom2 = FND_API.G_MISS_CHAR)

3558: END IF;
3559:
3560: -- 09/07/2001 OPM BEGIN - Default process attributes as appropriate from an order line ref
3561: -- ===============================================================
3562: IF (p_x_line_rec.ordered_quantity_uom2 = FND_API.G_MISS_CHAR)
3563: OR (p_x_line_rec.ordered_quantity_uom2 IS NULL) THEN
3564: p_x_line_rec.ordered_quantity_uom2 :=
3565: l_ref_line_rec.ordered_quantity_uom2 ;
3566: END IF;

Line 3568: IF (p_x_line_rec.preferred_grade = FND_API.G_MISS_CHAR)

3564: p_x_line_rec.ordered_quantity_uom2 :=
3565: l_ref_line_rec.ordered_quantity_uom2 ;
3566: END IF;
3567:
3568: IF (p_x_line_rec.preferred_grade = FND_API.G_MISS_CHAR)
3569: OR (p_x_line_rec.preferred_grade IS NULL) THEN
3570: p_x_line_rec.preferred_grade :=
3571: l_ref_line_rec.preferred_grade ;
3572: END IF;

Line 3574: IF (p_x_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM) THEN

3570: p_x_line_rec.preferred_grade :=
3571: l_ref_line_rec.preferred_grade ;
3572: END IF;
3573:
3574: IF (p_x_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM) THEN
3575: p_x_line_rec.ordered_quantity2 := l_ref_line_rec.ordered_quantity2;
3576: END IF;
3577:
3578: -- 09/07/2001 OPM END

Line 3582: p_x_line_rec.reference_line_id = FND_API.G_MISS_NUM) THEN

3578: -- 09/07/2001 OPM END
3579: -- =====================
3580:
3581: IF (p_x_line_rec.reference_line_id IS NULL OR
3582: p_x_line_rec.reference_line_id = FND_API.G_MISS_NUM) THEN
3583: p_x_line_rec.reference_header_id := l_ref_line_rec.header_id;
3584: p_x_line_rec.reference_line_id := l_ref_line_rec.line_id;
3585: END IF;
3586:

Line 3589: p_x_line_rec.tax_code = FND_API.G_MISS_CHAR)

3585: END IF;
3586:
3587: /* Start : Tax Reference Info */
3588: IF (p_x_line_rec.tax_code IS NULL OR
3589: p_x_line_rec.tax_code = FND_API.G_MISS_CHAR)
3590: THEN
3591: p_x_line_rec.tax_code := l_ref_line_rec.tax_code;
3592: p_x_line_rec.tax_date := l_ref_line_rec.tax_date;
3593: END IF;

Line 3596: p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR)

3592: p_x_line_rec.tax_date := l_ref_line_rec.tax_date;
3593: END IF;
3594:
3595: IF (p_x_line_rec.tax_exempt_flag IS NULL OR
3596: p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR)
3597: THEN
3598: p_x_line_rec.tax_exempt_flag := l_ref_line_rec.tax_exempt_flag;
3599: END IF;
3600:

Line 3602: p_x_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR)

3598: p_x_line_rec.tax_exempt_flag := l_ref_line_rec.tax_exempt_flag;
3599: END IF;
3600:
3601: IF (p_x_line_rec.tax_exempt_number IS NULL OR
3602: p_x_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR)
3603: THEN
3604: p_x_line_rec.tax_exempt_number := l_ref_line_rec.tax_exempt_number;
3605: END IF;
3606:

Line 3608: p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR)

3604: p_x_line_rec.tax_exempt_number := l_ref_line_rec.tax_exempt_number;
3605: END IF;
3606:
3607: IF (p_x_line_rec.tax_exempt_reason_code IS NULL OR
3608: p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR)
3609: THEN
3610: p_x_line_rec.tax_exempt_reason_code :=
3611: l_ref_line_rec.tax_exempt_reason_code;
3612: END IF;

Line 3617: p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM) THEN

3613:
3614: /* End: Tax Reference Info */
3615:
3616: IF (p_x_line_rec.pricing_quantity IS NULL OR
3617: p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM) THEN
3618: IF p_x_line_rec.return_context = 'SERIAL' OR
3619: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN
3620: p_x_line_rec.pricing_quantity_uom :=
3621: l_ref_line_rec.pricing_quantity_uom;

Line 3638: p_x_line_rec.pricing_date = fnd_api.g_miss_date) THEN

3634: NULL;
3635: END IF;
3636:
3637: IF (p_x_line_rec.pricing_date IS NULL OR
3638: p_x_line_rec.pricing_date = fnd_api.g_miss_date) THEN
3639: p_x_line_rec.pricing_date := l_ref_line_rec.pricing_date ;
3640: ELSE
3641: NULL;
3642: END IF;

Line 3645: p_x_line_rec.unit_selling_price = FND_API.G_MISS_NUM) THEN

3641: NULL;
3642: END IF;
3643:
3644: IF (p_x_line_rec.unit_selling_price IS NULL OR
3645: p_x_line_rec.unit_selling_price = FND_API.G_MISS_NUM) THEN
3646: p_x_line_rec.unit_selling_price := l_ref_line_rec.unit_selling_price ;
3647: IF (l_ref_line_rec.pricing_context IS NOT NULL) THEN
3648: p_x_line_rec.pricing_context := l_ref_line_rec.pricing_context;
3649: p_x_line_rec.pricing_attribute1 := l_ref_line_rec.pricing_attribute1;

Line 3665: p_x_line_rec.unit_percent_base_price = FND_API.G_MISS_NUM) THEN

3661: NULL;
3662: END IF;
3663:
3664: IF (p_x_line_rec.unit_percent_base_price IS NULL OR
3665: p_x_line_rec.unit_percent_base_price = FND_API.G_MISS_NUM) THEN
3666: p_x_line_rec.unit_percent_base_price := l_ref_line_rec.unit_percent_base_price ;
3667: ELSE
3668: NULL;
3669: END IF;

Line 3672: p_x_line_rec.unit_list_price = FND_API.G_MISS_NUM) THEN

3668: NULL;
3669: END IF;
3670:
3671: IF (p_x_line_rec.unit_list_price IS NULL OR
3672: p_x_line_rec.unit_list_price = FND_API.G_MISS_NUM) THEN
3673: p_x_line_rec.unit_list_price := l_ref_line_rec.unit_list_price ;
3674: END IF;
3675:
3676: --RT{

Line 3695: p_x_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM) THEN

3691: --RT}
3692:
3693: -- Start: bug 1769612
3694: IF (p_x_line_rec.unit_list_price_per_pqty IS NULL OR
3695: p_x_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM) THEN
3696: p_x_line_rec.unit_list_price_per_pqty := l_ref_line_rec.unit_list_price_per_pqty ;
3697: END IF;
3698:
3699: IF (p_x_line_rec.unit_selling_price_per_pqty IS NULL OR

Line 3700: p_x_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM) THEN

3696: p_x_line_rec.unit_list_price_per_pqty := l_ref_line_rec.unit_list_price_per_pqty ;
3697: END IF;
3698:
3699: IF (p_x_line_rec.unit_selling_price_per_pqty IS NULL OR
3700: p_x_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM) THEN
3701:
3702: p_x_line_rec.unit_selling_price_per_pqty := l_ref_line_rec.unit_selling_price_per_pqty;
3703: END IF;
3704: -- end of bug 1769612

Line 3707: p_x_line_rec.price_list_id = FND_API.G_MISS_NUM) THEN

3703: END IF;
3704: -- end of bug 1769612
3705:
3706: IF (p_x_line_rec.price_list_id IS NULL OR
3707: p_x_line_rec.price_list_id = FND_API.G_MISS_NUM) THEN
3708: p_x_line_rec.price_list_id := l_ref_line_rec.price_list_id ;
3709: ELSE
3710: NULL;
3711: END IF;

Line 3714: p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM) THEN

3710: NULL;
3711: END IF;
3712:
3713: IF (p_x_line_rec.invoice_to_org_id IS NULL OR
3714: p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM) THEN
3715: p_x_line_rec.invoice_to_org_id := l_ref_line_rec.invoice_to_org_id ;
3716: END IF;
3717:
3718: IF (p_x_line_rec.ship_to_contact_id IS NULL OR

Line 3719: p_x_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM) THEN

3715: p_x_line_rec.invoice_to_org_id := l_ref_line_rec.invoice_to_org_id ;
3716: END IF;
3717:
3718: IF (p_x_line_rec.ship_to_contact_id IS NULL OR
3719: p_x_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM) THEN
3720: p_x_line_rec.ship_to_contact_id := l_ref_line_rec.ship_to_contact_id ;
3721: END IF;
3722:
3723: IF (p_x_line_rec.intermed_ship_to_org_id IS NULL OR

Line 3724: p_x_line_rec.intermed_ship_to_org_id = FND_API.G_MISS_NUM) THEN

3720: p_x_line_rec.ship_to_contact_id := l_ref_line_rec.ship_to_contact_id ;
3721: END IF;
3722:
3723: IF (p_x_line_rec.intermed_ship_to_org_id IS NULL OR
3724: p_x_line_rec.intermed_ship_to_org_id = FND_API.G_MISS_NUM) THEN
3725: p_x_line_rec.intermed_ship_to_org_id := l_ref_line_rec.intermed_ship_to_org_id ;
3726: END IF;
3727:
3728: IF (p_x_line_rec.intermed_ship_to_contact_id IS NULL OR

Line 3729: p_x_line_rec.intermed_ship_to_contact_id = FND_API.G_MISS_NUM) THEN

3725: p_x_line_rec.intermed_ship_to_org_id := l_ref_line_rec.intermed_ship_to_org_id ;
3726: END IF;
3727:
3728: IF (p_x_line_rec.intermed_ship_to_contact_id IS NULL OR
3729: p_x_line_rec.intermed_ship_to_contact_id = FND_API.G_MISS_NUM) THEN
3730: p_x_line_rec.intermed_ship_to_contact_id
3731: := l_ref_line_rec.intermed_ship_to_contact_id ;
3732: END IF;
3733:

Line 3735: p_x_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM) THEN

3731: := l_ref_line_rec.intermed_ship_to_contact_id ;
3732: END IF;
3733:
3734: IF (p_x_line_rec.deliver_to_contact_id IS NULL OR
3735: p_x_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM) THEN
3736: p_x_line_rec.deliver_to_contact_id
3737: := l_ref_line_rec.deliver_to_contact_id ;
3738: END IF;
3739:

Line 3741: p_x_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM) THEN

3737: := l_ref_line_rec.deliver_to_contact_id ;
3738: END IF;
3739:
3740: IF (p_x_line_rec.invoice_to_contact_id IS NULL OR
3741: p_x_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM) THEN
3742: p_x_line_rec.invoice_to_contact_id := l_ref_line_rec.invoice_to_contact_id ;
3743: END IF;
3744:
3745: IF (p_x_line_rec.sold_to_org_id IS NULL OR

Line 3746: p_x_line_rec.sold_to_org_id = FND_API.G_MISS_NUM) THEN

3742: p_x_line_rec.invoice_to_contact_id := l_ref_line_rec.invoice_to_contact_id ;
3743: END IF;
3744:
3745: IF (p_x_line_rec.sold_to_org_id IS NULL OR
3746: p_x_line_rec.sold_to_org_id = FND_API.G_MISS_NUM) THEN
3747: p_x_line_rec.sold_to_org_id := l_ref_line_rec.sold_to_org_id ;
3748: ELSE
3749: NULL;
3750: END IF;

Line 3753: p_x_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN

3749: NULL;
3750: END IF;
3751:
3752: IF (p_x_line_rec.ship_from_org_id IS NULL OR
3753: p_x_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
3754: p_x_line_rec.ship_from_org_id := l_ref_line_rec.ship_from_org_id ;
3755: ELSE
3756: NULL;
3757: END IF;

Line 3764: p_x_line_rec. ordered_quantity2 = FND_API.G_MISS_NUM) AND

3760: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' AND
3761: --bug3420941
3762: (l_ref_line_rec.source_type_code <> 'EXTERNAL') AND
3763: (p_x_line_rec. ordered_quantity2 IS NULL OR
3764: p_x_line_rec. ordered_quantity2 = FND_API.G_MISS_NUM) AND
3765: (p_x_line_rec. ordered_quantity_uom2 IS NULL OR
3766: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3767: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3768:

Line 3766: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073

3762: (l_ref_line_rec.source_type_code <> 'EXTERNAL') AND
3763: (p_x_line_rec. ordered_quantity2 IS NULL OR
3764: p_x_line_rec. ordered_quantity2 = FND_API.G_MISS_NUM) AND
3765: (p_x_line_rec. ordered_quantity_uom2 IS NULL OR
3766: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3767: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3768:
3769: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3770: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND

Line 3767: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073

3763: (p_x_line_rec. ordered_quantity2 IS NULL OR
3764: p_x_line_rec. ordered_quantity2 = FND_API.G_MISS_NUM) AND
3765: (p_x_line_rec. ordered_quantity_uom2 IS NULL OR
3766: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3767: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3768:
3769: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3770: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3771: (p_x_line_rec.ship_from_org_id IS NOT NULL AND

Line 3770: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND

3766: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3767: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3768:
3769: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3770: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3771: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
3772: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3773: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
3774: ,p_x_line_rec.ship_from_org_id);

Line 3772: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN

3768:
3769: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3770: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3771: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
3772: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3773: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
3774: ,p_x_line_rec.ship_from_org_id);
3775: -- IF x_item_rec.ont_pricing_qty_source = 1 THEN INVCONV
3776: IF x_item_rec.ont_pricing_qty_source = 'S' THEN -- INVCONV

Line 3804: p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM) THEN

3800: END IF; -- end checks for qty2/uom2 existence
3801: -- Pack J catchweight
3802:
3803: IF (p_x_line_rec.ship_to_org_id IS NULL OR
3804: p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM) THEN
3805: p_x_line_rec.ship_to_org_id := l_ref_line_rec.ship_to_org_id ;
3806: ELSE
3807: NULL;
3808: END IF;

Line 3811: p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM) THEN

3807: NULL;
3808: END IF;
3809:
3810: IF (p_x_line_rec.deliver_to_org_id IS NULL OR
3811: p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM) THEN
3812: p_x_line_rec.deliver_to_org_id := l_ref_line_rec.deliver_to_org_id;
3813: ELSE
3814: NULL;
3815: END IF;

Line 3819: p_x_line_rec.project_id = FND_API.G_MISS_NUM) THEN

3815: END IF;
3816:
3817:
3818: IF (p_x_line_rec.project_id IS NULL OR
3819: p_x_line_rec.project_id = FND_API.G_MISS_NUM) THEN
3820: p_x_line_rec.project_id := l_ref_line_rec.project_id;
3821: END IF;
3822:
3823: IF (p_x_line_rec.task_id IS NULL OR

Line 3824: p_x_line_rec.task_id = FND_API.G_MISS_NUM) THEN

3820: p_x_line_rec.project_id := l_ref_line_rec.project_id;
3821: END IF;
3822:
3823: IF (p_x_line_rec.task_id IS NULL OR
3824: p_x_line_rec.task_id = FND_API.G_MISS_NUM) THEN
3825: p_x_line_rec.task_id := l_ref_line_rec.task_id;
3826: END IF;
3827:
3828: IF (p_x_line_rec.end_item_unit_number IS NULL OR

Line 3829: p_x_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR) THEN

3825: p_x_line_rec.task_id := l_ref_line_rec.task_id;
3826: END IF;
3827:
3828: IF (p_x_line_rec.end_item_unit_number IS NULL OR
3829: p_x_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR) THEN
3830: p_x_line_rec.end_item_unit_number := l_ref_line_rec.end_item_unit_number;
3831: END IF;
3832:
3833: /* Added for the bug fix 1720066 */

Line 3835: p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR)

3831: END IF;
3832:
3833: /* Added for the bug fix 1720066 */
3834: IF (p_x_line_rec.shippable_flag IS NULL OR
3835: p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR)
3836: THEN
3837: p_x_line_rec.shippable_flag := l_ref_line_rec.shippable_flag;
3838: END IF;
3839:

Line 3842: p_x_line_rec.user_item_description = FND_API.G_MISS_CHAR)

3838: END IF;
3839:
3840: -- bug 2509121
3841: IF (p_x_line_rec.user_item_description IS NULL OR
3842: p_x_line_rec.user_item_description = FND_API.G_MISS_CHAR)
3843: THEN
3844: p_x_line_rec.user_item_description := l_ref_line_rec.user_item_description;
3845: END IF;
3846:

Line 3851: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN

3847:
3848: /* Fix Bug 2429989: Returning Revision Controlled Items */
3849:
3850: IF p_x_line_rec.inventory_item_id IS NOT NULL AND
3851: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3852:
3853: Begin
3854: select decode(revision_qty_control_code, 2, 'Y', 'N')
3855: into l_revision_controlled

Line 3900: p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) THEN

3896: -- Bug 2849656 => Copy blanket fields from referenced order line
3897: -- to RMA line.
3898:
3899: IF (p_x_line_rec.blanket_number IS NULL OR
3900: p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) THEN
3901: p_x_line_rec.blanket_number := l_ref_line_rec.blanket_number;
3902: END IF;
3903:
3904: IF (p_x_line_rec.blanket_line_number IS NULL OR

Line 3905: p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) THEN

3901: p_x_line_rec.blanket_number := l_ref_line_rec.blanket_number;
3902: END IF;
3903:
3904: IF (p_x_line_rec.blanket_line_number IS NULL OR
3905: p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) THEN
3906: p_x_line_rec.blanket_line_number := l_ref_line_rec.blanket_line_number;
3907: END IF;
3908:
3909: -- End fix for Bug 2849656

Line 3917: p_x_line_rec.original_list_price = FND_API.G_MISS_NUM) THEN

3913: IF OE_ORDER_COPY_UTIL.G_LINE_PRICE_MODE = OE_ORDER_COPY_UTIL.G_CPY_REPRICE THEN
3914: p_x_line_rec.original_list_price := NULL;
3915: ELSE
3916: IF (p_x_line_rec.original_list_price IS NULL OR
3917: p_x_line_rec.original_list_price = FND_API.G_MISS_NUM) THEN
3918: p_x_line_rec.original_list_price := l_ref_line_rec.original_list_price;
3919: END IF;
3920: END IF;
3921:

Line 4054: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN

4050: --p_x_line_rec.ordered_quantity := l_line_rec.ordered_quantity; -- bug# 6617423
4051:
4052: -- bug# 6617423 : start
4053: oe_debug_pub.add( ' p_x_line_rec.org_id = '|| p_x_line_rec.org_id , 5 ) ;
4054: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
4055: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
4056: ELSE
4057: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
4058: END IF;

Line 4225: p_x_line_rec.return_attribute2 <> FND_API.G_MISS_CHAR

4221:
4222: END IF;
4223:
4224: IF p_x_line_rec.return_attribute2 is NOT NULL AND
4225: p_x_line_rec.return_attribute2 <> FND_API.G_MISS_CHAR
4226: THEN
4227:
4228: IF l_debug_level > 0 THEN
4229: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES' , 1 ) ;

Line 4235: p_x_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR)

4231:
4232: -- reprice when pricing attributes change
4233: -- also if the flag is passed in, keep the original flag
4234: IF (p_x_line_rec.calculate_price_flag IS NULL OR
4235: p_x_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR)
4236: THEN
4237: IF l_debug_level > 0 THEN
4238: oe_debug_pub.add( 'SETTING CALCULATE PRICE FLAG' , 1 ) ;
4239: END IF;

Line 4385: p_x_line_rec.return_context <> FND_API.G_MISS_CHAR THEN

4381: g_multiple_shipments := nvl(g_multiple_shipments, 'NO');
4382:
4383: /* IF (p_x_line_rec.operation = oe_globals.g_opr_create and */
4384: IF p_x_line_rec.return_context is NOT NULL AND
4385: p_x_line_rec.return_context <> FND_API.G_MISS_CHAR THEN
4386: Return_Attributes
4387: ( p_x_line_rec => p_x_line_rec
4388: , p_old_line_rec => p_old_line_rec
4389: );

Line 4395: g_line_rec.header_id <> FND_API.G_MISS_NUM) THEN

4391: g_line_rec := p_x_line_rec;
4392:
4393: -- bug 4668200
4394: IF (g_line_rec.header_id IS NOT NULL AND
4395: g_line_rec.header_id <> FND_API.G_MISS_NUM) THEN
4396: Set_Header_Def_Hdlr_Rec (g_line_rec.header_id);
4397: END IF ;
4398: -- end
4399:

Line 4400: IF p_x_line_rec.unit_cost = FND_API.G_MISS_NUM THEN

4396: Set_Header_Def_Hdlr_Rec (g_line_rec.header_id);
4397: END IF ;
4398: -- end
4399:
4400: IF p_x_line_rec.unit_cost = FND_API.G_MISS_NUM THEN
4401: p_x_line_rec.unit_cost := p_old_line_rec.unit_cost;
4402: END IF;
4403:
4404: -- For some fields, get hardcoded defaults

Line 4428: IF g_line_rec.created_by = FND_API.G_MISS_NUM THEN

4424: END IF;
4425:
4426: END IF;
4427:
4428: IF g_line_rec.created_by = FND_API.G_MISS_NUM THEN
4429: g_line_rec.created_by := FND_GLOBAL.USER_ID;
4430: END IF;
4431:
4432: --key Transaction Dates

Line 4433: IF g_line_rec.creation_date = FND_API.G_MISS_DATE THEN

4429: g_line_rec.created_by := FND_GLOBAL.USER_ID;
4430: END IF;
4431:
4432: --key Transaction Dates
4433: IF g_line_rec.creation_date = FND_API.G_MISS_DATE THEN
4434: g_line_rec.creation_date := sysdate;
4435: END IF;
4436: --end
4437:

Line 4438: IF g_line_rec.line_id = FND_API.G_MISS_NUM THEN

4434: g_line_rec.creation_date := sysdate;
4435: END IF;
4436: --end
4437:
4438: IF g_line_rec.line_id = FND_API.G_MISS_NUM THEN
4439: g_line_rec.line_id := Get_Line;
4440: END IF;
4441: -- Fix for 2362210
4442: IF l_debug_level > 0 THEN

Line 4447: IF ((g_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR

4443: oe_debug_pub.add( 'LINE ID = '||G_LINE_REC.LINE_ID ) ;
4444: oe_debug_pub.add( 'LINE SYS = '||G_LINE_REC.ORIG_SYS_LINE_REF ) ;
4445: oe_debug_pub.add( 'SOURCE_DOCUMENT_ID = '|| G_LINE_REC.SOURCE_DOCUMENT_ID ) ;
4446: END IF;
4447: IF ((g_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR
4448: OR g_line_rec.orig_sys_line_ref IS NULL)
4449: AND
4450: nvl(g_line_rec.source_document_id,-999) <> 10) THEN
4451: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;

Line 4455: IF (g_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR

4451: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;
4452: END IF;
4453:
4454: --{ bug3664313 FP start: added NULL check
4455: IF (g_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR
4456: g_line_rec.orig_sys_document_ref IS NULL) THEN
4457: g_line_rec.orig_sys_document_ref := Get_Orig_Sys_Doc_Ref;
4458: END IF;
4459:

Line 4460: IF g_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN

4456: g_line_rec.orig_sys_document_ref IS NULL) THEN
4457: g_line_rec.orig_sys_document_ref := Get_Orig_Sys_Doc_Ref;
4458: END IF;
4459:
4460: IF g_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN
4461: g_line_rec.line_category_code :=
4462: Get_line_category(g_line_rec,p_old_line_rec);
4463: IF l_debug_level > 0 THEN
4464: oe_debug_pub.add( 'AFTER CALLING LINE CATEGORY1' || G_LINE_REC.LINE_CATEGORY_CODE ) ;

Line 4487: RAISE FND_API.G_EXC_ERROR;

4483: OE_MSG_PUB.ADD;
4484: IF l_debug_level > 0 THEN
4485: oe_debug_pub.add( 'LINE CATEGORY CONSTRINED' ) ;
4486: END IF;
4487: RAISE FND_API.G_EXC_ERROR;
4488: END IF;
4489: END IF;
4490:
4491: -- BUG 3646340: Return_reason is a defaultable field and it needs to be

Line 4503: g_line_rec.return_reason_code := FND_API.G_MISS_CHAR;

4499: THEN
4500: IF l_debug_level > 0 THEN
4501: oe_debug_pub.add('LINE CATEGORY CHANGED - REASON set to miss') ;
4502: END IF;
4503: g_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
4504: END IF;
4505:
4506: IF g_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
4507: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,

Line 4506: IF g_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR

4502: END IF;
4503: g_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
4504: END IF;
4505:
4506: IF g_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
4507: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4508: p_old_line_rec.line_category_code)
4509: THEN
4510: g_line_rec.top_model_line_id := Get_Top_Model_Line;

Line 4520: IF g_line_rec.item_type_code = FND_API.G_MISS_CHAR

4516:
4517: IF l_debug_level > 0 THEN
4518: oe_debug_pub.add( 'BEFORE ITEM_TYPE' ) ;
4519: END IF;
4520: IF g_line_rec.item_type_code = FND_API.G_MISS_CHAR
4521: or NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4522: p_old_line_rec.line_category_code)
4523: THEN
4524: g_line_rec.item_type_code :=

Line 4545: IF g_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN

4541: END IF;
4542: g_line_rec.ato_line_id := Get_Ato_Line;
4543: END IF;
4544:
4545: IF g_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN
4546: g_line_rec.ship_model_complete_flag := Get_SMC_Flag;
4547: END IF;
4548:
4549: -- model_option_defaulting is dependent on get_top_model_line

Line 4552: IF (g_line_rec.item_type_code <> FND_API.G_MISS_CHAR OR

4548:
4549: -- model_option_defaulting is dependent on get_top_model_line
4550: -- get_item_type and get_smc_flag
4551:
4552: IF (g_line_rec.item_type_code <> FND_API.G_MISS_CHAR OR
4553: g_line_rec.item_type_code is not null) AND
4554: g_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
4555: THEN
4556: model_option_defaulting;

Line 4559: IF (g_line_rec.line_id = FND_API.G_MISS_NUM) OR

4555: THEN
4556: model_option_defaulting;
4557: END IF;
4558:
4559: IF (g_line_rec.line_id = FND_API.G_MISS_NUM) OR
4560: (g_line_rec.line_id IS NULL) THEN
4561: g_line_rec.org_id := OE_GLOBALS.G_ORG_ID;
4562: END IF;
4563:

Line 4564: IF g_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN

4560: (g_line_rec.line_id IS NULL) THEN
4561: g_line_rec.org_id := OE_GLOBALS.G_ORG_ID;
4562: END IF;
4563:
4564: IF g_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN
4565: g_line_rec.booked_flag := Get_Booked;
4566: END IF;
4567:
4568: IF g_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN

Line 4568: IF g_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN

4564: IF g_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN
4565: g_line_rec.booked_flag := Get_Booked;
4566: END IF;
4567:
4568: IF g_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN
4569: g_line_rec.model_remnant_flag := NULL;
4570: END IF;
4571:
4572: IF g_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN

Line 4572: IF g_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN

4568: IF g_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN
4569: g_line_rec.model_remnant_flag := NULL;
4570: END IF;
4571:
4572: IF g_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
4573: g_line_rec.cancelled_flag := Get_Cancelled;
4574: END IF;
4575:
4576: IF g_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN

Line 4576: IF g_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN

4572: IF g_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
4573: g_line_rec.cancelled_flag := Get_Cancelled;
4574: END IF;
4575:
4576: IF g_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN
4577: g_line_rec.cancelled_quantity := Get_Cancelled_Quantity;
4578: END IF;
4579:
4580: IF g_line_rec.component_code = FND_API.G_MISS_CHAR THEN

Line 4580: IF g_line_rec.component_code = FND_API.G_MISS_CHAR THEN

4576: IF g_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN
4577: g_line_rec.cancelled_quantity := Get_Cancelled_Quantity;
4578: END IF;
4579:
4580: IF g_line_rec.component_code = FND_API.G_MISS_CHAR THEN
4581: g_line_rec.component_code := Get_Component;
4582: END IF;
4583:
4584: IF g_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN

Line 4584: IF g_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN

4580: IF g_line_rec.component_code = FND_API.G_MISS_CHAR THEN
4581: g_line_rec.component_code := Get_Component;
4582: END IF;
4583:
4584: IF g_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN
4585: g_line_rec.fulfilled_quantity := Get_Fulfilled_Quantity;
4586: END IF;
4587:
4588: IF g_line_rec.line_number = FND_API.G_MISS_NUM THEN

Line 4588: IF g_line_rec.line_number = FND_API.G_MISS_NUM THEN

4584: IF g_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN
4585: g_line_rec.fulfilled_quantity := Get_Fulfilled_Quantity;
4586: END IF;
4587:
4588: IF g_line_rec.line_number = FND_API.G_MISS_NUM THEN
4589: g_line_rec.line_number := Get_Line_Number;
4590: END IF;
4591:
4592: IF g_line_rec.open_flag = FND_API.G_MISS_CHAR THEN

Line 4592: IF g_line_rec.open_flag = FND_API.G_MISS_CHAR THEN

4588: IF g_line_rec.line_number = FND_API.G_MISS_NUM THEN
4589: g_line_rec.line_number := Get_Line_Number;
4590: END IF;
4591:
4592: IF g_line_rec.open_flag = FND_API.G_MISS_CHAR THEN
4593: g_line_rec.open_flag := Get_Open;
4594: END IF;
4595:
4596: /* Added the following lines to fix the bug 2823553 */

Line 4598: IF g_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM THEN

4594: END IF;
4595:
4596: /* Added the following lines to fix the bug 2823553 */
4597:
4598: IF g_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM THEN
4599: g_line_rec.unit_list_price_per_pqty := NULL;
4600: END IF;
4601:
4602: IF g_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM THEN

Line 4602: IF g_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM THEN

4598: IF g_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM THEN
4599: g_line_rec.unit_list_price_per_pqty := NULL;
4600: END IF;
4601:
4602: IF g_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM THEN
4603: g_line_rec.unit_selling_price_per_pqty := NULL;
4604: END IF;
4605:
4606: -- Bug 3737773

Line 4610: --IF g_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN

4606: -- Bug 3737773
4607: -- Moved the below code after call to defaulting FrameWork.
4608: -- Start of Code change for Bug 3671715
4609:
4610: --IF g_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN
4611: -- g_line_rec.pricing_quantity := Get_Pricing_Quantity;
4612: --END IF;
4613:
4614: IF g_line_rec.shipment_number = FND_API.G_MISS_NUM THEN

Line 4614: IF g_line_rec.shipment_number = FND_API.G_MISS_NUM THEN

4610: --IF g_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN
4611: -- g_line_rec.pricing_quantity := Get_Pricing_Quantity;
4612: --END IF;
4613:
4614: IF g_line_rec.shipment_number = FND_API.G_MISS_NUM THEN
4615: g_line_rec.shipment_number := Get_Shipment_Number;
4616: END IF;
4617:
4618: IF g_line_rec.shipping_interfaced_flag = FND_API.G_MISS_CHAR THEN

Line 4618: IF g_line_rec.shipping_interfaced_flag = FND_API.G_MISS_CHAR THEN

4614: IF g_line_rec.shipment_number = FND_API.G_MISS_NUM THEN
4615: g_line_rec.shipment_number := Get_Shipment_Number;
4616: END IF;
4617:
4618: IF g_line_rec.shipping_interfaced_flag = FND_API.G_MISS_CHAR THEN
4619: g_line_rec.shipping_interfaced_flag := Get_Shipping_Interfaced;
4620: END IF;
4621:
4622: IF l_debug_level > 0 THEN

Line 4626: /* IF g_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN

4622: IF l_debug_level > 0 THEN
4623: oe_debug_pub.add( 'AK BEFORE LINE CATEGORY1' ) ;
4624: END IF;
4625:
4626: /* IF g_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN
4627: g_line_rec.line_category_code :=
4628: Get_line_category(g_line_rec,p_old_line_rec);
4629: END IF;*/
4630:

Line 4636: IF g_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN

4632: set before
4633: calling defaulting frame work. This value will be set after the defaulting f
4634: ramework
4635:
4636: IF g_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN
4637: g_line_rec.calculate_price_flag := 'Y';
4638: END IF;
4639: btea end
4640: */

Line 4667: g_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM OR

4663: /* Change for bug 2276993 */
4664: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4665:
4666: IF g_line_rec.ship_tolerance_below IS NULL OR
4667: g_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM OR
4668: g_line_rec.ship_tolerance_below = p_old_Line_rec.ship_tolerance_below THEN
4669: g_line_rec.ship_tolerance_below := 0;
4670: l_set_tolerance_below := 'Y';
4671: IF l_debug_level > 0 THEN

Line 4678: g_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM OR

4674:
4675: END IF;
4676:
4677: IF g_line_rec.ship_tolerance_above IS NULL OR
4678: g_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM OR
4679: g_line_rec.ship_tolerance_above = p_old_Line_rec.ship_tolerance_above THEN
4680: g_line_rec.ship_tolerance_above := 0;
4681: l_set_tolerance_above := 'Y';
4682: IF l_debug_level > 0 THEN

Line 4700: RAISE FND_API.G_EXC_ERROR;

4696: oe_debug_pub.add( 'SHIP TOLERANCES CAN NOT BE SPECIFIED ON PTOS' , 3 ) ;
4697: END IF;
4698: fnd_message.set_name('ONT','OE_NO_TOL_FOR_PTO');
4699: OE_MSG_PUB.Add;
4700: RAISE FND_API.G_EXC_ERROR;
4701:
4702: END IF;
4703:
4704: /* END Fix for 2420456*/

Line 4722: l_in_rec.blanket_line_number := FND_API.G_MISS_NUM;

4718:
4719: IF ( l_in_rec.operation = OE_GLOBALS.G_OPR_CREATE -- 7152122
4720: AND trunc( l_in_rec.request_date ) <> trunc(l_in_old_rec.request_date)
4721: AND l_in_rec.blanket_line_number IS NOT NULL )THEN
4722: l_in_rec.blanket_line_number := FND_API.G_MISS_NUM;
4723: END IF;
4724:
4725: Perform_Blanket_Functions
4726: (p_x_line_rec => l_in_rec

Line 4748: AND l_in_rec.sold_to_org_id <> FND_API.G_MISS_NUM

4744: -- the check here is to avoid performace overhead, so that party_type
4745: -- information is only loaded when needed.
4746: IF OE_Prepayment_Util.Get_Installment_Options = 'ENABLE_PAY_NOW'
4747: AND l_in_rec.sold_to_org_id IS NOT NULL
4748: AND l_in_rec.sold_to_org_id <> FND_API.G_MISS_NUM
4749: THEN
4750: BEGIN
4751: SELECT 'Y'
4752: INTO l_exists

Line 4819: IF g_line_rec.override_atp_date_code <> FND_API.G_MISS_CHAR THEN

4815: (p_record => l_rec
4816: ,x_api_rec => p_x_line_rec);
4817:
4818: -- 2707939 --
4819: IF g_line_rec.override_atp_date_code <> FND_API.G_MISS_CHAR THEN
4820: p_x_line_rec.override_atp_date_code := g_line_rec.override_atp_date_code;
4821: END IF;
4822: IF g_line_rec.firm_demand_flag <> FND_API.G_MISS_CHAR THEN
4823: p_x_line_rec.firm_demand_flag := g_line_rec.firm_demand_flag;

Line 4822: IF g_line_rec.firm_demand_flag <> FND_API.G_MISS_CHAR THEN

4818: -- 2707939 --
4819: IF g_line_rec.override_atp_date_code <> FND_API.G_MISS_CHAR THEN
4820: p_x_line_rec.override_atp_date_code := g_line_rec.override_atp_date_code;
4821: END IF;
4822: IF g_line_rec.firm_demand_flag <> FND_API.G_MISS_CHAR THEN
4823: p_x_line_rec.firm_demand_flag := g_line_rec.firm_demand_flag;
4824: END IF;
4825:
4826: /* Bug 2154960 Added call to default_active_agr_revision() to default

Line 4831: p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN

4827: active Agreement Revision. This API will call process order for Line entity
4828: again after defaulting Active Agreement Revision to default dependent attributes. */
4829:
4830: IF p_x_line_rec.agreement_id IS NOT NULL AND
4831: p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
4832:
4833: IF NOT oe_globals.equal(p_x_line_rec.pricing_date,
4834: p_old_line_rec.pricing_date)
4835: OR

Line 4853: IF p_x_line_rec.line_category_code = FND_API.G_MISS_CHAR OR -- added for 2421909

4849: IF l_debug_level > 0 THEN
4850: oe_debug_pub.add( 'AFTER DEFAULTING LINE CATEGORY1' || P_X_LINE_REC.LINE_CATEGORY_CODE ) ;
4851: END IF;
4852:
4853: IF p_x_line_rec.line_category_code = FND_API.G_MISS_CHAR OR -- added for 2421909
4854: p_x_line_rec.line_category_code IS NULL THEN
4855: p_x_line_rec.line_category_code := Get_line_category(p_x_line_rec,p_old_line_rec);
4856: IF l_debug_level > 0 THEN
4857: oe_debug_pub.add( 'AFTER CALLING LINE CATEGORY2' || P_X_LINE_REC.LINE_CATEGORY_CODE , 1 ) ;

Line 4864: if (p_x_line_rec.marketing_source_code_id = FND_API.G_MISS_NUM) then

4860:
4861: -- Copy the value back to the out record for marketing source code.
4862: -- These columns are not enabled in the AK tables
4863:
4864: if (p_x_line_rec.marketing_source_code_id = FND_API.G_MISS_NUM) then
4865: p_x_line_rec.marketing_source_code_id := NULL;
4866: else
4867: p_x_line_rec.marketing_source_code_id := p_x_line_rec.marketing_source_code_id;
4868: end if;

Line 4880: IF (p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM

4876: oe_debug_pub.add(' Ordered Qty: '|| p_x_line_rec.ordered_quantity ,1);
4877: oe_debug_pub.add(' Ordered UOM: '|| p_x_line_rec.order_quantity_uom,1);
4878: END IF;
4879:
4880: IF (p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM
4881: OR p_x_line_rec.pricing_quantity is NULL
4882: OR p_x_line_rec.pricing_quantity = -99999) THEN
4883: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR
4884: OR p_x_line_rec.pricing_quantity_uom is NULL) THEN

Line 4883: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR

4879:
4880: IF (p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM
4881: OR p_x_line_rec.pricing_quantity is NULL
4882: OR p_x_line_rec.pricing_quantity = -99999) THEN
4883: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR
4884: OR p_x_line_rec.pricing_quantity_uom is NULL) THEN
4885: p_x_line_rec.pricing_quantity := p_x_line_rec.ordered_quantity;
4886: p_x_line_rec.pricing_quantity_uom := p_x_line_rec.order_quantity_uom;
4887: ELSE --Pricing UOM has value but P_QTY is not populated

Line 4902: RAISE FND_API.G_EXC_ERROR;

4898:
4899: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRC_INVALID_UOM_CONVERSION');
4900: fnd_message.set_token('UOM_TEXT',p_x_line_rec.pricing_quantity_uom);
4901: OE_MSG_PUB.Add;
4902: RAISE FND_API.G_EXC_ERROR;
4903: END IF;
4904: -- End of code addition after review.
4905: END IF; -- End of Pricing UOM check
4906: ELSE -- Pricing Quantity has a valid Value

Line 4907: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR

4903: END IF;
4904: -- End of code addition after review.
4905: END IF; -- End of Pricing UOM check
4906: ELSE -- Pricing Quantity has a valid Value
4907: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR
4908: OR p_x_line_rec.pricing_quantity_uom is NULL) THEN
4909: IF (p_x_line_rec.pricing_quantity = p_x_line_rec.ordered_quantity) THEN
4910: p_x_line_rec.pricing_quantity_uom := p_x_line_rec.order_quantity_uom;
4911: ELSE --P_QTY is not equal to O_QTY and P_UOM is Not Populated

Line 4925: RAISE FND_API.G_EXC_ERROR;

4921: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4922: --Added the message after review.
4923: FND_MESSAGE.SET_NAME('ONT', 'ONT_INVALID_ORD_QTY_PRC_QTY');
4924: OE_MSG_PUB.Add;
4925: RAISE FND_API.G_EXC_ERROR;
4926: ELSE --BUG 4135361
4927: p_x_line_rec.pricing_quantity := p_x_line_rec.ordered_quantity;
4928: p_x_line_rec.pricing_quantity_uom := p_x_line_rec.order_quantity_uom;
4929: END IF;

Line 4938: if (p_x_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR or

4934: END IF;
4935: -- end bug fix 3737773
4936:
4937: --Btea begin fix bug 1821024,
4938: if (p_x_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR or
4939: p_x_line_rec.calculate_price_flag is Null) Then
4940: p_x_line_rec.calculate_price_flag := 'Y';
4941: End If;
4942: --Btea end

Line 4945: if (p_x_line_rec.order_source_id = FND_API.G_MISS_NUM) then

4941: End If;
4942: --Btea end
4943:
4944: -- Copy the value back to the out record for order source id.
4945: if (p_x_line_rec.order_source_id = FND_API.G_MISS_NUM) then
4946: IF l_debug_level > 0 THEN
4947: oe_debug_pub.add( 'OEXDLINB - AKSINGH - CHECK FOR G_MISS_NUM' ) ;
4948: END IF;
4949: p_x_line_rec.order_source_id := Get_Order_Source_Id;

Line 4958: if (p_x_line_rec.commitment_id = FND_API.G_MISS_NUM) then

4954: p_x_line_rec.order_source_id := p_x_line_rec.order_source_id;
4955: end if;
4956:
4957: -- Copy the value back to the out record for Commitment_Id.
4958: if (p_x_line_rec.commitment_id = FND_API.G_MISS_NUM) then
4959: IF l_debug_level > 0 THEN
4960: oe_debug_pub.add( 'OEXDLINB - COMMITMENT_ID - CHECK FOR G_MISS_NUM' ) ;
4961: END IF;
4962: p_x_line_rec.commitment_id := NULL;

Line 4972: IF (p_x_line_rec.tp_context = FND_API.G_MISS_CHAR) THEN

4968: end if;
4969:
4970: /* 1581620 start */
4971:
4972: IF (p_x_line_rec.tp_context = FND_API.G_MISS_CHAR) THEN
4973: p_x_line_rec.tp_context := NULL;
4974: END IF;
4975: IF (p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
4976: p_x_line_rec.tp_attribute1 := NULL;

Line 4975: IF (p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN

4971:
4972: IF (p_x_line_rec.tp_context = FND_API.G_MISS_CHAR) THEN
4973: p_x_line_rec.tp_context := NULL;
4974: END IF;
4975: IF (p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
4976: p_x_line_rec.tp_attribute1 := NULL;
4977: END IF;
4978:
4979: IF (p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN

Line 4979: IF (p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN

4975: IF (p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
4976: p_x_line_rec.tp_attribute1 := NULL;
4977: END IF;
4978:
4979: IF (p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN
4980: p_x_line_rec.tp_attribute2 := NULL;
4981: END IF;
4982:
4983: IF (p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN

Line 4983: IF (p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN

4979: IF (p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN
4980: p_x_line_rec.tp_attribute2 := NULL;
4981: END IF;
4982:
4983: IF (p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN
4984: p_x_line_rec.tp_attribute3 := NULL;
4985: END IF;
4986:
4987: IF (p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN

Line 4987: IF (p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN

4983: IF (p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN
4984: p_x_line_rec.tp_attribute3 := NULL;
4985: END IF;
4986:
4987: IF (p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN
4988: p_x_line_rec.tp_attribute4 := NULL;
4989: END IF;
4990:
4991: IF (p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN

Line 4991: IF (p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN

4987: IF (p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN
4988: p_x_line_rec.tp_attribute4 := NULL;
4989: END IF;
4990:
4991: IF (p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN
4992: p_x_line_rec.tp_attribute5 := NULL;
4993: END IF;
4994:
4995: IF (p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN

Line 4995: IF (p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN

4991: IF (p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN
4992: p_x_line_rec.tp_attribute5 := NULL;
4993: END IF;
4994:
4995: IF (p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN
4996: p_x_line_rec.tp_attribute6 := NULL;
4997: END IF;
4998:
4999: IF (p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN

Line 4999: IF (p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN

4995: IF (p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN
4996: p_x_line_rec.tp_attribute6 := NULL;
4997: END IF;
4998:
4999: IF (p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN
5000: p_x_line_rec.tp_attribute7 := NULL;
5001: END IF;
5002:
5003: IF (p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN

Line 5003: IF (p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN

4999: IF (p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN
5000: p_x_line_rec.tp_attribute7 := NULL;
5001: END IF;
5002:
5003: IF (p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN
5004: p_x_line_rec.tp_attribute8 := NULL;
5005: END IF;
5006:
5007: IF (p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN

Line 5007: IF (p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN

5003: IF (p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN
5004: p_x_line_rec.tp_attribute8 := NULL;
5005: END IF;
5006:
5007: IF (p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN
5008: p_x_line_rec.tp_attribute9 := NULL;
5009: END IF;
5010:
5011: IF (p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN

Line 5011: IF (p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN

5007: IF (p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN
5008: p_x_line_rec.tp_attribute9 := NULL;
5009: END IF;
5010:
5011: IF (p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN
5012: p_x_line_rec.tp_attribute10 := NULL;
5013: END IF;
5014:
5015: IF (p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN

Line 5015: IF (p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN

5011: IF (p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN
5012: p_x_line_rec.tp_attribute10 := NULL;
5013: END IF;
5014:
5015: IF (p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN
5016: p_x_line_rec.tp_attribute11 := NULL;
5017: END IF;
5018:
5019: IF (p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN

Line 5019: IF (p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN

5015: IF (p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN
5016: p_x_line_rec.tp_attribute11 := NULL;
5017: END IF;
5018:
5019: IF (p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN
5020: p_x_line_rec.tp_attribute12 := NULL;
5021: END IF;
5022:
5023: IF (p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN

Line 5023: IF (p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN

5019: IF (p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN
5020: p_x_line_rec.tp_attribute12 := NULL;
5021: END IF;
5022:
5023: IF (p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN
5024: p_x_line_rec.tp_attribute13 := NULL;
5025: END IF;
5026:
5027: IF (p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN

Line 5027: IF (p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN

5023: IF (p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN
5024: p_x_line_rec.tp_attribute13 := NULL;
5025: END IF;
5026:
5027: IF (p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN
5028: p_x_line_rec.tp_attribute14 := NULL;
5029: END IF;
5030:
5031: IF (p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN

Line 5031: IF (p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN

5027: IF (p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN
5028: p_x_line_rec.tp_attribute14 := NULL;
5029: END IF;
5030:
5031: IF (p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN
5032: p_x_line_rec.tp_attribute15 := NULL;
5033: END IF;
5034:
5035: IF (p_x_line_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN

Line 5035: IF (p_x_line_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN

5031: IF (p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN
5032: p_x_line_rec.tp_attribute15 := NULL;
5033: END IF;
5034:
5035: IF (p_x_line_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN
5036: p_x_line_rec.flow_status_code := NULL;
5037: END IF;
5038:
5039: IF (p_x_line_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN

Line 5039: IF (p_x_line_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN

5035: IF (p_x_line_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN
5036: p_x_line_rec.flow_status_code := NULL;
5037: END IF;
5038:
5039: IF (p_x_line_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN
5040: p_x_line_rec.drop_ship_flag := NULL;
5041: END IF;
5042:
5043: -- OR condition added for 3200019 so orig_sys_shipment_ref

Line 5046: IF (p_x_line_rec.orig_sys_shipment_ref = FND_API.G_MISS_CHAR

5042:
5043: -- OR condition added for 3200019 so orig_sys_shipment_ref
5044: -- would not get defaulted incorrectly when entering multiple
5045: -- lines due to caching in SO UI like bug 2362210
5046: IF (p_x_line_rec.orig_sys_shipment_ref = FND_API.G_MISS_CHAR
5047: OR p_x_line_rec.orig_sys_shipment_ref IS NULL) AND
5048: (nvl(p_x_line_rec.source_document_id,0) <> 10) THEN
5049: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110508') AND
5050: (g_multiple_shipments = 'YES') THEN

Line 5060: if (p_x_line_rec.change_sequence = FND_API.G_MISS_CHAR) then

5056: p_x_line_rec.orig_sys_shipment_ref := NULL;
5057: END IF;
5058: END IF;
5059:
5060: if (p_x_line_rec.change_sequence = FND_API.G_MISS_CHAR) then
5061: p_x_line_rec.change_sequence := NULL;
5062: end if;
5063:
5064: if (p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR) then

Line 5064: if (p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR) then

5060: if (p_x_line_rec.change_sequence = FND_API.G_MISS_CHAR) then
5061: p_x_line_rec.change_sequence := NULL;
5062: end if;
5063:
5064: if (p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR) then
5065: p_x_line_rec.customer_line_number := NULL;
5066: end if;
5067:
5068: if (p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR) then

Line 5068: if (p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR) then

5064: if (p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR) then
5065: p_x_line_rec.customer_line_number := NULL;
5066: end if;
5067:
5068: if (p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR) then
5069: p_x_line_rec.customer_shipment_number := NULL;
5070: end if;
5071:
5072: if (p_x_line_rec.customer_item_net_price = FND_API.G_MISS_NUM) then

Line 5072: if (p_x_line_rec.customer_item_net_price = FND_API.G_MISS_NUM) then

5068: if (p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR) then
5069: p_x_line_rec.customer_shipment_number := NULL;
5070: end if;
5071:
5072: if (p_x_line_rec.customer_item_net_price = FND_API.G_MISS_NUM) then
5073: p_x_line_rec.customer_item_net_price := NULL;
5074: end if;
5075:
5076: if (p_x_line_rec.customer_payment_term_id = FND_API.G_MISS_NUM) then

Line 5076: if (p_x_line_rec.customer_payment_term_id = FND_API.G_MISS_NUM) then

5072: if (p_x_line_rec.customer_item_net_price = FND_API.G_MISS_NUM) then
5073: p_x_line_rec.customer_item_net_price := NULL;
5074: end if;
5075:
5076: if (p_x_line_rec.customer_payment_term_id = FND_API.G_MISS_NUM) then
5077: p_x_line_rec.customer_payment_term_id := NULL;
5078: end if;
5079:
5080: if (p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) then

Line 5080: if (p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) then

5076: if (p_x_line_rec.customer_payment_term_id = FND_API.G_MISS_NUM) then
5077: p_x_line_rec.customer_payment_term_id := NULL;
5078: end if;
5079:
5080: if (p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) then
5081: p_x_line_rec.reference_customer_trx_line_id := NULL;
5082: end if;
5083:
5084: if (p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM) then

Line 5084: if (p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM) then

5080: if (p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) then
5081: p_x_line_rec.reference_customer_trx_line_id := NULL;
5082: end if;
5083:
5084: if (p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM) then
5085: p_x_line_rec.sold_from_org_id := NULL;
5086: end if;
5087:
5088: if (p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM) then

Line 5088: if (p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM) then

5084: if (p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM) then
5085: p_x_line_rec.sold_from_org_id := NULL;
5086: end if;
5087:
5088: if (p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM) then
5089: p_x_line_rec.mfg_lead_time := NULL;
5090: end if;
5091:
5092: if (p_x_line_rec.lock_control = FND_API.G_MISS_NUM) then

Line 5092: if (p_x_line_rec.lock_control = FND_API.G_MISS_NUM) then

5088: if (p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM) then
5089: p_x_line_rec.mfg_lead_time := NULL;
5090: end if;
5091:
5092: if (p_x_line_rec.lock_control = FND_API.G_MISS_NUM) then
5093: p_x_line_rec.lock_control := NULL;
5094: end if;
5095:
5096: if (p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR) then

Line 5096: if (p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR) then

5092: if (p_x_line_rec.lock_control = FND_API.G_MISS_NUM) then
5093: p_x_line_rec.lock_control := NULL;
5094: end if;
5095:
5096: if (p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR) then
5097: p_x_line_rec.re_source_flag := NULL;
5098: end if;
5099:
5100: if (p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR) then

Line 5100: if (p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR) then

5096: if (p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR) then
5097: p_x_line_rec.re_source_flag := NULL;
5098: end if;
5099:
5100: if (p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR) then
5101: p_x_line_rec.model_remnant_flag := NULL;
5102: end if;
5103:
5104: if (p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR) then

Line 5104: if (p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR) then

5100: if (p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR) then
5101: p_x_line_rec.model_remnant_flag := NULL;
5102: end if;
5103:
5104: if (p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR) then
5105: p_x_line_rec.shippable_flag := NULL;
5106: end if;
5107:
5108: /* 1581620 end */

Line 5112: if (p_x_line_rec.minisite_id = FND_API.G_MISS_NUM) then

5108: /* 1581620 end */
5109:
5110: -- Bug # 5490345
5111:
5112: if (p_x_line_rec.minisite_id = FND_API.G_MISS_NUM) then
5113: p_x_line_rec.minisite_id := NULL;
5114: end if;
5115:
5116:

Line 5118: if (p_x_line_rec.End_Customer_ID = FND_API.G_MISS_NUM) then

5114: end if;
5115:
5116:
5117: --Distributor Orders
5118: if (p_x_line_rec.End_Customer_ID = FND_API.G_MISS_NUM) then
5119: p_x_line_rec.End_Customer_id := NULL;
5120: end if;
5121: if (p_x_line_rec.End_Customer_Contact_ID = FND_API.G_MISS_NUM) then
5122: p_x_line_rec.End_Customer_Contact_id := NULL;

Line 5121: if (p_x_line_rec.End_Customer_Contact_ID = FND_API.G_MISS_NUM) then

5117: --Distributor Orders
5118: if (p_x_line_rec.End_Customer_ID = FND_API.G_MISS_NUM) then
5119: p_x_line_rec.End_Customer_id := NULL;
5120: end if;
5121: if (p_x_line_rec.End_Customer_Contact_ID = FND_API.G_MISS_NUM) then
5122: p_x_line_rec.End_Customer_Contact_id := NULL;
5123: end if;
5124: if (p_x_line_rec.End_Customer_Site_Use_ID = FND_API.G_MISS_NUM) then
5125: p_x_line_rec.End_Customer_site_use_id := NULL;

Line 5124: if (p_x_line_rec.End_Customer_Site_Use_ID = FND_API.G_MISS_NUM) then

5120: end if;
5121: if (p_x_line_rec.End_Customer_Contact_ID = FND_API.G_MISS_NUM) then
5122: p_x_line_rec.End_Customer_Contact_id := NULL;
5123: end if;
5124: if (p_x_line_rec.End_Customer_Site_Use_ID = FND_API.G_MISS_NUM) then
5125: p_x_line_rec.End_Customer_site_use_id := NULL;
5126: end if;
5127: if (p_x_line_rec.IB_OWNER = FND_API.G_MISS_CHAR) then
5128: p_x_line_rec.IB_OWNER := NULL;

Line 5127: if (p_x_line_rec.IB_OWNER = FND_API.G_MISS_CHAR) then

5123: end if;
5124: if (p_x_line_rec.End_Customer_Site_Use_ID = FND_API.G_MISS_NUM) then
5125: p_x_line_rec.End_Customer_site_use_id := NULL;
5126: end if;
5127: if (p_x_line_rec.IB_OWNER = FND_API.G_MISS_CHAR) then
5128: p_x_line_rec.IB_OWNER := NULL;
5129: end if;
5130: if (p_x_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) then
5131: p_x_line_rec.IB_CURRENT_LOCATION := NULL;

Line 5130: if (p_x_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) then

5126: end if;
5127: if (p_x_line_rec.IB_OWNER = FND_API.G_MISS_CHAR) then
5128: p_x_line_rec.IB_OWNER := NULL;
5129: end if;
5130: if (p_x_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) then
5131: p_x_line_rec.IB_CURRENT_LOCATION := NULL;
5132: end if;
5133: if (p_x_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) then
5134: p_x_line_rec.IB_INSTALLED_AT_LOCATION := NULL;

Line 5133: if (p_x_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) then

5129: end if;
5130: if (p_x_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) then
5131: p_x_line_rec.IB_CURRENT_LOCATION := NULL;
5132: end if;
5133: if (p_x_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) then
5134: p_x_line_rec.IB_INSTALLED_AT_LOCATION := NULL;
5135: end if;
5136: --
5137: if (p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) then

Line 5137: if (p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) then

5133: if (p_x_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) then
5134: p_x_line_rec.IB_INSTALLED_AT_LOCATION := NULL;
5135: end if;
5136: --
5137: if (p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) then
5138: p_x_line_rec.blanket_number := NULL;
5139: end if;
5140:
5141: if (p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) then

Line 5141: if (p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) then

5137: if (p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) then
5138: p_x_line_rec.blanket_number := NULL;
5139: end if;
5140:
5141: if (p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) then
5142: p_x_line_rec.blanket_line_number := NULL;
5143: end if;
5144:
5145: if (p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM) then

Line 5145: if (p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM) then

5141: if (p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) then
5142: p_x_line_rec.blanket_line_number := NULL;
5143: end if;
5144:
5145: if (p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM) then
5146: p_x_line_rec.blanket_version_number := NULL;
5147: end if;
5148:
5149: /* 1783766 start */

Line 5151: if (p_x_line_rec.fulfillment_set = FND_API.G_MISS_CHAR) then

5147: end if;
5148:
5149: /* 1783766 start */
5150:
5151: if (p_x_line_rec.fulfillment_set = FND_API.G_MISS_CHAR) then
5152: p_x_line_rec.fulfillment_set := NULL;
5153: end if;
5154:
5155: if (p_x_line_rec.fulfillment_set_id = FND_API.G_MISS_NUM) then

Line 5155: if (p_x_line_rec.fulfillment_set_id = FND_API.G_MISS_NUM) then

5151: if (p_x_line_rec.fulfillment_set = FND_API.G_MISS_CHAR) then
5152: p_x_line_rec.fulfillment_set := NULL;
5153: end if;
5154:
5155: if (p_x_line_rec.fulfillment_set_id = FND_API.G_MISS_NUM) then
5156: p_x_line_rec.fulfillment_set_id := NULL;
5157: end if;
5158:
5159: /* 1783766 end */

Line 5163: IF (p_x_line_rec.ordered_quantity_uom2 = FND_API.G_MISS_CHAR)

5159: /* 1783766 end */
5160:
5161: -- OPM 02/JUN/00 BEGIN - Default process attributes as appropriate
5162: -- ===============================================================
5163: IF (p_x_line_rec.ordered_quantity_uom2 = FND_API.G_MISS_CHAR)
5164: OR (p_x_line_rec.ordered_quantity_uom2 IS NULL) THEN
5165: p_x_line_rec.ordered_quantity_uom2 :=
5166: Get_Dual_Uom(p_line_rec => p_x_line_rec); -- INVCONV
5167: END IF;

Line 5170: IF ( (p_x_line_rec.preferred_grade = FND_API.G_MISS_CHAR)

5166: Get_Dual_Uom(p_line_rec => p_x_line_rec); -- INVCONV
5167: END IF;
5168: -- INVCONV -- NORMAL DEFAULTING IS USED NOW SO TAKE OUT
5169: /* -- OPM bug 2553805 do not re-default the preferred_grade if this is a copied order
5170: IF ( (p_x_line_rec.preferred_grade = FND_API.G_MISS_CHAR)
5171: OR (p_x_line_rec.preferred_grade IS NULL) )
5172: and
5173: (nvl( p_x_line_rec.source_document_type_id, 0 ) <> 2 ) -- added line for 2553805
5174: THEN

Line 5180: IF (p_x_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM) THEN

5176: OE_Line_Util.Get_Preferred_Grade(p_line_rec => p_x_line_rec,
5177: p_old_line_rec => p_old_line_rec);
5178: END IF; */
5179:
5180: IF (p_x_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM) THEN
5181: p_x_line_rec.ordered_quantity2 := NULL;
5182: END IF;
5183:
5184: -- OPM 03/MAY/00 END

Line 5196: IF ((p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR

5192: p_old_line_rec => p_old_line_rec);
5193:
5194: -- when order import do not pass item_identifier_type, default to INT
5195:
5196: IF ((p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR
5197: OR p_x_line_rec.item_identifier_type is null) AND
5198: p_x_line_rec.inventory_item_id is not null AND
5199: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM)
5200: THEN

Line 5199: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM)

5195:
5196: IF ((p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR
5197: OR p_x_line_rec.item_identifier_type is null) AND
5198: p_x_line_rec.inventory_item_id is not null AND
5199: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM)
5200: THEN
5201: -- Re-default to INT only if item_identifier_type was previously null
5202: -- otherwise retain the old value. For example: If item identifier was
5203: -- CUST and now became null due to dependency on sold_to we should keep the

Line 5220: p_x_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN

5216: END IF;
5217: END IF;
5218:
5219: IF p_x_line_rec.source_type_code is null OR
5220: p_x_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN
5221: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5222: END IF;
5223:
5224: -- Bug 5708174

Line 5246: IF p_x_line_rec.request_date <> FND_API.G_MISS_DATE THEN

5242: THEN
5243: IF l_debug_level > 0 THEN
5244: oe_debug_pub.add( 'OEXDLINB -1- CHECK FOR G_MISS_DATE FOR REQUEST ' ) ;
5245: END IF;
5246: IF p_x_line_rec.request_date <> FND_API.G_MISS_DATE THEN
5247: -- aksingh added this if for the bug 1745501
5248: IF l_debug_level > 0 THEN
5249: oe_debug_pub.add( 'OEXDLINB -2- CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5250: END IF;

Line 5253: OR p_x_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE

5249: oe_debug_pub.add( 'OEXDLINB -2- CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5250: END IF;
5251: IF OE_GLOBALS.Equal(p_x_line_rec.latest_acceptable_date,
5252: p_old_line_rec.latest_acceptable_date)
5253: OR p_x_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE
5254: THEN
5255: IF l_debug_level > 0 THEN
5256: oe_debug_pub.add( 'OEXDLINB -3- AFTER CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5257: END IF;

Line 5265: IF p_x_line_rec.Original_Inventory_Item_Id = FND_API.G_MISS_NUM THEN

5261: END IF;
5262: END IF;
5263:
5264: -- Item Substitution
5265: IF p_x_line_rec.Original_Inventory_Item_Id = FND_API.G_MISS_NUM THEN
5266: p_x_line_rec.Original_Inventory_Item_Id := Null;
5267: END IF;
5268:
5269: IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN

Line 5269: IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN

5265: IF p_x_line_rec.Original_Inventory_Item_Id = FND_API.G_MISS_NUM THEN
5266: p_x_line_rec.Original_Inventory_Item_Id := Null;
5267: END IF;
5268:
5269: IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN
5270: p_x_line_rec.Original_item_identifier_Type := Null;
5271: END IF;
5272:
5273: IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN

Line 5273: IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN

5269: IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN
5270: p_x_line_rec.Original_item_identifier_Type := Null;
5271: END IF;
5272:
5273: IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN
5274: p_x_line_rec.Original_ordered_item_id := Null;
5275: END IF;
5276:
5277: IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN

Line 5277: IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN

5273: IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN
5274: p_x_line_rec.Original_ordered_item_id := Null;
5275: END IF;
5276:
5277: IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN
5278: p_x_line_rec.Original_ordered_item := Null;
5279: END IF;
5280:
5281: IF p_x_line_rec.Item_relationship_type = FND_API.G_MISS_NUM THEN

Line 5281: IF p_x_line_rec.Item_relationship_type = FND_API.G_MISS_NUM THEN

5277: IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN
5278: p_x_line_rec.Original_ordered_item := Null;
5279: END IF;
5280:
5281: IF p_x_line_rec.Item_relationship_type = FND_API.G_MISS_NUM THEN
5282: p_x_line_rec.Item_relationship_type := Null;
5283: END IF;
5284:
5285: IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN

Line 5285: IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN

5281: IF p_x_line_rec.Item_relationship_type = FND_API.G_MISS_NUM THEN
5282: p_x_line_rec.Item_relationship_type := Null;
5283: END IF;
5284:
5285: IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN
5286: p_x_line_rec.Item_substitution_type_code := Null;
5287: END IF;
5288:
5289: IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN

Line 5289: IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN

5285: IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN
5286: p_x_line_rec.Item_substitution_type_code := Null;
5287: END IF;
5288:
5289: IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN
5290: p_x_line_rec.Late_Demand_Penalty_Factor := Null;
5291: END IF;
5292:
5293: IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN

Line 5293: IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN

5289: IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN
5290: p_x_line_rec.Late_Demand_Penalty_Factor := Null;
5291: END IF;
5292:
5293: IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN
5294: p_x_line_rec.Override_atp_date_code := Null;
5295: END IF;
5296:
5297: IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN

Line 5297: IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN

5293: IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN
5294: p_x_line_rec.Override_atp_date_code := Null;
5295: END IF;
5296:
5297: IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN
5298: p_x_line_rec.firm_demand_flag := Null;
5299: END IF;
5300: --retro{
5301: IF (p_x_line_rec.retrobill_request_id = FND_API.G_MISS_NUM) THEN

Line 5301: IF (p_x_line_rec.retrobill_request_id = FND_API.G_MISS_NUM) THEN

5297: IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN
5298: p_x_line_rec.firm_demand_flag := Null;
5299: END IF;
5300: --retro{
5301: IF (p_x_line_rec.retrobill_request_id = FND_API.G_MISS_NUM) THEN
5302: p_x_line_rec.retrobill_request_id := NULL;
5303: END IF;
5304: --retro}
5305:

Line 5307: IF p_x_line_rec.CONTINGENCY_ID = FND_API.G_MISS_NUM THEN

5303: END IF;
5304: --retro}
5305:
5306: --Customer Acceptance
5307: IF p_x_line_rec.CONTINGENCY_ID = FND_API.G_MISS_NUM THEN
5308: p_x_line_rec.CONTINGENCY_ID := NULL ;
5309: END IF;
5310: IF p_x_line_rec.REVREC_EVENT_CODE = FND_API.G_MISS_CHAR THEN
5311: p_x_line_rec.REVREC_EVENT_CODE:= NULL ;

Line 5310: IF p_x_line_rec.REVREC_EVENT_CODE = FND_API.G_MISS_CHAR THEN

5306: --Customer Acceptance
5307: IF p_x_line_rec.CONTINGENCY_ID = FND_API.G_MISS_NUM THEN
5308: p_x_line_rec.CONTINGENCY_ID := NULL ;
5309: END IF;
5310: IF p_x_line_rec.REVREC_EVENT_CODE = FND_API.G_MISS_CHAR THEN
5311: p_x_line_rec.REVREC_EVENT_CODE:= NULL ;
5312: END IF;
5313: IF p_x_line_rec.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM THEN
5314: p_x_line_rec.REVREC_EXPIRATION_DAYS:= NULL ;

Line 5313: IF p_x_line_rec.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM THEN

5309: END IF;
5310: IF p_x_line_rec.REVREC_EVENT_CODE = FND_API.G_MISS_CHAR THEN
5311: p_x_line_rec.REVREC_EVENT_CODE:= NULL ;
5312: END IF;
5313: IF p_x_line_rec.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM THEN
5314: p_x_line_rec.REVREC_EXPIRATION_DAYS:= NULL ;
5315: END IF;
5316: IF p_x_line_rec.ACCEPTED_QUANTITY = FND_API.G_MISS_NUM THEN
5317: p_x_line_rec.ACCEPTED_QUANTITY:= NULL ;

Line 5316: IF p_x_line_rec.ACCEPTED_QUANTITY = FND_API.G_MISS_NUM THEN

5312: END IF;
5313: IF p_x_line_rec.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM THEN
5314: p_x_line_rec.REVREC_EXPIRATION_DAYS:= NULL ;
5315: END IF;
5316: IF p_x_line_rec.ACCEPTED_QUANTITY = FND_API.G_MISS_NUM THEN
5317: p_x_line_rec.ACCEPTED_QUANTITY:= NULL ;
5318: END IF;
5319: IF p_x_line_rec.REVREC_COMMENTS = FND_API.G_MISS_CHAR THEN
5320: p_x_line_rec.REVREC_COMMENTS:= NULL ;

Line 5319: IF p_x_line_rec.REVREC_COMMENTS = FND_API.G_MISS_CHAR THEN

5315: END IF;
5316: IF p_x_line_rec.ACCEPTED_QUANTITY = FND_API.G_MISS_NUM THEN
5317: p_x_line_rec.ACCEPTED_QUANTITY:= NULL ;
5318: END IF;
5319: IF p_x_line_rec.REVREC_COMMENTS = FND_API.G_MISS_CHAR THEN
5320: p_x_line_rec.REVREC_COMMENTS:= NULL ;
5321: END IF;
5322: IF p_x_line_rec.REVREC_SIGNATURE = FND_API.G_MISS_CHAR THEN
5323: p_x_line_rec.REVREC_SIGNATURE:= NULL ;

Line 5322: IF p_x_line_rec.REVREC_SIGNATURE = FND_API.G_MISS_CHAR THEN

5318: END IF;
5319: IF p_x_line_rec.REVREC_COMMENTS = FND_API.G_MISS_CHAR THEN
5320: p_x_line_rec.REVREC_COMMENTS:= NULL ;
5321: END IF;
5322: IF p_x_line_rec.REVREC_SIGNATURE = FND_API.G_MISS_CHAR THEN
5323: p_x_line_rec.REVREC_SIGNATURE:= NULL ;
5324: END IF;
5325: IF p_x_line_rec.REVREC_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN
5326: p_x_line_rec.REVREC_SIGNATURE_DATE:= NULL ;

Line 5325: IF p_x_line_rec.REVREC_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN

5321: END IF;
5322: IF p_x_line_rec.REVREC_SIGNATURE = FND_API.G_MISS_CHAR THEN
5323: p_x_line_rec.REVREC_SIGNATURE:= NULL ;
5324: END IF;
5325: IF p_x_line_rec.REVREC_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN
5326: p_x_line_rec.REVREC_SIGNATURE_DATE:= NULL ;
5327: END IF;
5328: IF p_x_line_rec.ACCEPTED_BY = FND_API.G_MISS_NUM THEN
5329: p_x_line_rec.ACCEPTED_BY:= NULL ;

Line 5328: IF p_x_line_rec.ACCEPTED_BY = FND_API.G_MISS_NUM THEN

5324: END IF;
5325: IF p_x_line_rec.REVREC_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN
5326: p_x_line_rec.REVREC_SIGNATURE_DATE:= NULL ;
5327: END IF;
5328: IF p_x_line_rec.ACCEPTED_BY = FND_API.G_MISS_NUM THEN
5329: p_x_line_rec.ACCEPTED_BY:= NULL ;
5330: END IF;
5331: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT = FND_API.G_MISS_CHAR THEN
5332: p_x_line_rec.REVREC_REFERENCE_DOCUMENT:= NULL ;

Line 5331: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT = FND_API.G_MISS_CHAR THEN

5327: END IF;
5328: IF p_x_line_rec.ACCEPTED_BY = FND_API.G_MISS_NUM THEN
5329: p_x_line_rec.ACCEPTED_BY:= NULL ;
5330: END IF;
5331: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT = FND_API.G_MISS_CHAR THEN
5332: p_x_line_rec.REVREC_REFERENCE_DOCUMENT:= NULL ;
5333: END IF;
5334: IF p_x_line_rec.REVREC_IMPLICIT_FLAG = FND_API.G_MISS_CHAR THEN
5335: p_x_line_rec.REVREC_IMPLICIT_FLAG := NULL ;

Line 5334: IF p_x_line_rec.REVREC_IMPLICIT_FLAG = FND_API.G_MISS_CHAR THEN

5330: END IF;
5331: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT = FND_API.G_MISS_CHAR THEN
5332: p_x_line_rec.REVREC_REFERENCE_DOCUMENT:= NULL ;
5333: END IF;
5334: IF p_x_line_rec.REVREC_IMPLICIT_FLAG = FND_API.G_MISS_CHAR THEN
5335: p_x_line_rec.REVREC_IMPLICIT_FLAG := NULL ;
5336: END IF;
5337: --Customer Acceptance
5338: -- bug 4203691 recurring charges

Line 5339: IF p_x_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR THEN

5335: p_x_line_rec.REVREC_IMPLICIT_FLAG := NULL ;
5336: END IF;
5337: --Customer Acceptance
5338: -- bug 4203691 recurring charges
5339: IF p_x_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR THEN
5340: p_x_line_rec.charge_periodicity_code := NULL ;
5341: END IF;
5342:
5343: /* The following lines are commented to fix the bug 1409036 */

Line 5358: p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR THEN

5354: -- get shippable is dependent on model_option_defaulting.
5355: -- ## bug fix: 1609895, shippable flag from warehouse
5356:
5357: IF p_x_line_rec.shippable_flag is NULL OR
5358: p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR THEN
5359: IF l_debug_level > 0 THEN
5360: oe_debug_pub.add( 'CALLING GET SHIPPABLE_FLAG ' , 1 ) ;
5361: END IF;
5362:

Line 5455: IF p_x_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN

5451: END IF;
5452:
5453: END IF;
5454:
5455: IF p_x_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN
5456: p_x_line_rec.user_item_description := Null;
5457: END IF;
5458:
5459: -- to clear out user_item_description if item changes

Line 5477: IF p_x_line_rec.original_list_price = FND_API.G_MISS_NUM THEN

5473: END IF;
5474:
5475: -- Override List Price
5476: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110510') THEN
5477: IF p_x_line_rec.original_list_price = FND_API.G_MISS_NUM THEN
5478: p_x_line_rec.original_list_price := NULL;
5479: END IF;
5480: END IF;
5481: -- Override List Price

Line 5488: WHEN FND_API.G_EXC_ERROR THEN

5484: oe_debug_pub.add( 'EXIT OE_DEFAULT_LINE.ATTRIBUTES' , 1 ) ;
5485: END IF;
5486: EXCEPTION
5487:
5488: WHEN FND_API.G_EXC_ERROR THEN
5489:
5490: RAISE FND_API.G_EXC_ERROR;
5491:
5492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5490: RAISE FND_API.G_EXC_ERROR;

5486: EXCEPTION
5487:
5488: WHEN FND_API.G_EXC_ERROR THEN
5489:
5490: RAISE FND_API.G_EXC_ERROR;
5491:
5492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5493:
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5488: WHEN FND_API.G_EXC_ERROR THEN
5489:
5490: RAISE FND_API.G_EXC_ERROR;
5491:
5492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5493:
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495:
5496: WHEN OTHERS THEN

Line 5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5490: RAISE FND_API.G_EXC_ERROR;
5491:
5492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5493:
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495:
5496: WHEN OTHERS THEN
5497:
5498: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5502: 'Attributes'
5503: );
5504: END IF;
5505:
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5507:
5508: END Attributes;
5509:
5510: /*----------------------------------------------------------

Line 5585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5581: END IF;
5582: if l_debug_level > 0 then
5583: oe_debug_pub.add('others in get_dual uom', 1);
5584: end if;
5585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5586:
5587:
5588: END Get_Dual_Uom;
5589: