332: l_x_old_Line_Adj_tbl(1) := l_x_old_Line_Adj_rec;
333:
334: -- Call Oe_Order_Adj_Pvt.Line_Adj
335: oe_order_adj_pvt.Line_Adjs
336: ( p_init_msg_list => FND_API.G_TRUE
337: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
338: , p_control_rec => l_control_rec
339: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
340: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
333:
334: -- Call Oe_Order_Adj_Pvt.Line_Adj
335: oe_order_adj_pvt.Line_Adjs
336: ( p_init_msg_list => FND_API.G_TRUE
337: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
338: , p_control_rec => l_control_rec
339: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
340: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
341: );
345:
346: -- Call OE_Order_PVT.Process_order
347: OE_Order_PVT.Process_order
348: ( p_api_version_number => 1.0
349: , p_init_msg_list => FND_API.G_TRUE
350: , x_return_status => l_return_status
351: , x_msg_count => x_msg_count
352: , x_msg_data => x_msg_data
353: , p_control_rec => l_control_rec
372: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
373: , x_action_request_tbl => l_action_request_tbl
374: );
375:
376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
373: , x_action_request_tbl => l_action_request_tbl
374: );
375:
376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381: ***********************************************************************/
374: );
375:
376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381: ***********************************************************************/
382:
375:
376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381: ***********************************************************************/
382:
383: -- Unload out tbl
382:
383: -- Unload out tbl
384: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
385:
386: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
383: -- Unload out tbl
384: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
385:
386: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:
384: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
385:
386: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:
392: -- Load OUT parameters.
385:
386: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:
392: -- Load OUT parameters.
393: x_price_adjustment_id := l_x_Line_Adj_rec.price_adjustment_id;
478:
479: -- Write to cache.
480: -- Set db_flag to False before writing to cache
481:
482: l_x_Line_Adj_rec.db_flag := FND_API.G_FALSE;
483:
484: Write_Line_Adj
485: ( p_Line_Adj_rec => l_x_Line_Adj_rec
486: );
489: OE_GLOBALS.G_UI_FLAG := FALSE;
490:
491: -- Set return status.
492:
493: x_return_status := FND_API.G_RET_STS_SUCCESS;
494:
495: -- Get message count and data
496:
497: OE_MSG_PUB.Count_And_Get
504: END IF;
505:
506: EXCEPTION
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509:
510: OE_GLOBALS.G_UI_FLAG := FALSE;
511:
512: x_return_status := FND_API.G_RET_STS_ERROR;
508: WHEN FND_API.G_EXC_ERROR THEN
509:
510: OE_GLOBALS.G_UI_FLAG := FALSE;
511:
512: x_return_status := FND_API.G_RET_STS_ERROR;
513:
514: -- Get message count and data
515:
516: OE_MSG_PUB.Count_And_Get
517: ( p_count => x_msg_count
518: , p_data => x_msg_data
519: );
520:
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522:
523: OE_GLOBALS.G_UI_FLAG := FALSE;
524:
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522:
523: OE_GLOBALS.G_UI_FLAG := FALSE;
524:
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526:
527: -- Get message count and data
528:
529: OE_MSG_PUB.Count_And_Get
534: WHEN OTHERS THEN
535:
536: OE_GLOBALS.G_UI_FLAG := FALSE;
537:
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
539:
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: OE_MSG_PUB.Add_Exc_Msg
566:
567: , p_price_adjustment_id IN NUMBER
568: , p_attr_id IN NUMBER
569: , p_attr_value1 IN VARCHAR2
570: , p_attr_value2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
571: , p_context IN VARCHAR2
572: , p_attribute1 IN VARCHAR2
573: , p_attribute2 IN VARCHAR2
574: , p_attribute3 IN VARCHAR2
880: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_TYPE_CODE then
881: l_x_Line_Adj_rec.list_line_type_code := p_attr_value1 ;
882:
883: IF l_x_Line_Adj_rec.list_line_type_code = 'PBH'
884: AND nvl(l_x_Line_Adj_rec.list_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
885: BEGIN
886: SELECT ldets.line_quantity
887: INTO l_x_Line_Adj_rec.range_break_quantity
888: FROM qp_preq_ldets_tmp ldets,
1068: , 'Unrecognized attribute'
1069: );
1070: END IF;
1071:
1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1073:
1074: END IF;
1075:
1076: IF l_debug_level > 0 THEN
1081: END IF;
1082:
1083: -- Set Operation.
1084:
1085: IF FND_API.To_Boolean(l_x_Line_Adj_rec.db_flag) THEN
1086: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1087: ELSE
1088: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1089: END IF;
1142: --Cascading adjustments for service lines
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add( ' CS QUERIED LINE_ID:'||L_LINE_REC.LINE_ID ) ;
1145: END IF;
1146: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
1147: l_line_rec.service_reference_line_id Is Not Null --make sure is adjustment for a service line
1148: Then
1149: --To determine if this is an adjustment for service line of a top model line
1150: Begin
1187: IF l_debug_level > 0 THEN
1188: oe_debug_pub.add( ' TOP MODEL LINE ID:'||L_LINE_REC.TOP_MODEL_LINE_ID ) ;
1189: END IF;
1190: --Cascading adjustments from top model to option lines
1191: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
1192: l_line_rec.line_id = l_line_rec.top_model_line_id --to make sure this is a top model line
1193: Then
1194: get_option_service_lines(p_top_model_line_id=>l_line_rec.top_model_line_id,
1195: p_mode => 'OPTION',
1211: --we will need to cascade change reason code too, if it got changed
1212: If p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE Then
1213:
1214: --If no line queried, requery again else just use this to
1215: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
1216: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
1217: x_line_rec=>l_line_rec);
1218: End If;
1219:
1245: -- Call Oe_Order_Adj_Pvt.Line_Adj
1246: l_Line_Adj_rec := l_x_Line_Adj_rec;
1247:
1248: oe_order_adj_pvt.Line_Adjs
1249: ( p_init_msg_list => FND_API.G_TRUE
1250: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1251: , p_control_rec => l_control_rec
1252: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
1253: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
1246: l_Line_Adj_rec := l_x_Line_Adj_rec;
1247:
1248: oe_order_adj_pvt.Line_Adjs
1249: ( p_init_msg_list => FND_API.G_TRUE
1250: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1251: , p_control_rec => l_control_rec
1252: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
1253: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
1254: );
1256: /************************************************************************
1257: -- Call OE_Order_PVT.Process_order
1258: OE_Order_PVT.Process_order
1259: ( p_api_version_number => 1.0
1260: , p_init_msg_list => FND_API.G_TRUE
1261: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1262: , x_return_status => l_return_status
1263: , x_msg_count => x_msg_count
1264: , x_msg_data => x_msg_data
1257: -- Call OE_Order_PVT.Process_order
1258: OE_Order_PVT.Process_order
1259: ( p_api_version_number => 1.0
1260: , p_init_msg_list => FND_API.G_TRUE
1261: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1262: , x_return_status => l_return_status
1263: , x_msg_count => x_msg_count
1264: , x_msg_data => x_msg_data
1265: , p_control_rec => l_control_rec
1289: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
1290: , x_action_request_tbl => l_action_request_tbl
1291: );
1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1290: , x_action_request_tbl => l_action_request_tbl
1291: );
1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298: ******************************************************************/
1291: );
1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298: ******************************************************************/
1299:
1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298: ******************************************************************/
1299:
1300: -- Unload out tbl
1299:
1300: -- Unload out tbl
1301: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
1302:
1303: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1300: -- Unload out tbl
1301: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
1302:
1303: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308:
1301: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
1302:
1303: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308:
1309: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1302:
1303: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308:
1309: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1310: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1307: END IF;
1308:
1309: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1310: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1311: ,p_delete => FND_API.G_TRUE
1312: ,x_return_status => l_return_status
1313: );
1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1311: ,p_delete => FND_API.G_TRUE
1312: ,x_return_status => l_return_status
1313: );
1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1311: ,p_delete => FND_API.G_TRUE
1312: ,x_return_status => l_return_status
1313: );
1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1312: ,x_return_status => l_return_status
1313: );
1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1320: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1313: );
1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1320: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1321: (p_request_type => OE_GLOBALS.G_CHECK_FIXED_PRICE
1318: END IF;
1319:
1320: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1321: (p_request_type => OE_GLOBALS.G_CHECK_FIXED_PRICE
1322: ,p_delete => FND_API.G_TRUE
1323: ,x_return_status => l_return_status
1324: );
1325: IF p_enforce_fixed_price = 'YES' THEN
1326: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: ,p_delete => FND_API.G_TRUE
1323: ,x_return_status => l_return_status
1324: );
1325: IF p_enforce_fixed_price = 'YES' THEN
1326: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1323: ,x_return_status => l_return_status
1324: );
1325: IF p_enforce_fixed_price = 'YES' THEN
1326: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1331: ELSE
1324: );
1325: IF p_enforce_fixed_price = 'YES' THEN
1326: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1331: ELSE
1332: l_return_status := FND_API.G_RET_STS_SUCCESS;
1325: IF p_enforce_fixed_price = 'YES' THEN
1326: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1331: ELSE
1332: l_return_status := FND_API.G_RET_STS_SUCCESS;
1333: END IF;
1328: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1331: ELSE
1332: l_return_status := FND_API.G_RET_STS_SUCCESS;
1333: END IF;
1334:
1335:
1336: -- Init OUT parameters to missing.
1334:
1335:
1336: -- Init OUT parameters to missing.
1337:
1338: x_price_adjustment_id := FND_API.G_MISS_NUM;
1339: x_header_id := FND_API.G_MISS_NUM;
1340: x_discount_id := FND_API.G_MISS_NUM;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1335:
1336: -- Init OUT parameters to missing.
1337:
1338: x_price_adjustment_id := FND_API.G_MISS_NUM;
1339: x_header_id := FND_API.G_MISS_NUM;
1340: x_discount_id := FND_API.G_MISS_NUM;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1336: -- Init OUT parameters to missing.
1337:
1338: x_price_adjustment_id := FND_API.G_MISS_NUM;
1339: x_header_id := FND_API.G_MISS_NUM;
1340: x_discount_id := FND_API.G_MISS_NUM;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1337:
1338: x_price_adjustment_id := FND_API.G_MISS_NUM;
1339: x_header_id := FND_API.G_MISS_NUM;
1340: x_discount_id := FND_API.G_MISS_NUM;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1338: x_price_adjustment_id := FND_API.G_MISS_NUM;
1339: x_header_id := FND_API.G_MISS_NUM;
1340: x_discount_id := FND_API.G_MISS_NUM;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1339: x_header_id := FND_API.G_MISS_NUM;
1340: x_discount_id := FND_API.G_MISS_NUM;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1340: x_discount_id := FND_API.G_MISS_NUM;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1341: x_discount := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1342: x_discount_line_id := FND_API.G_MISS_NUM;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1343: x_automatic_flag := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1344: x_percent := FND_API.G_MISS_NUM;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1345: x_line_id := FND_API.G_MISS_NUM;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1346: x_context := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1347: x_attribute1 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1348: x_attribute2 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1349: x_attribute3 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1350: x_attribute4 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1351: x_attribute5 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1352: x_attribute6 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1353: x_attribute7 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1354: x_attribute8 := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1355: x_attribute9 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1356: x_attribute10 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1357: x_attribute11 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1358: x_attribute12 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1359: x_attribute13 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1360: x_attribute14 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1361: x_attribute15 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1362: x_ac_context := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1363: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1364: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1378:
1371: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1378:
1379: -- New columns names added
1372: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1378:
1379: -- New columns names added
1380: x_list_header_id := FND_API.G_MISS_NUM;
1373: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1378:
1379: -- New columns names added
1380: x_list_header_id := FND_API.G_MISS_NUM;
1381: x_list_line_id := FND_API.G_MISS_NUM;
1376: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1378:
1379: -- New columns names added
1380: x_list_header_id := FND_API.G_MISS_NUM;
1381: x_list_line_id := FND_API.G_MISS_NUM;
1382: x_list_line_type_code := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1377: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1378:
1379: -- New columns names added
1380: x_list_header_id := FND_API.G_MISS_NUM;
1381: x_list_line_id := FND_API.G_MISS_NUM;
1382: x_list_line_type_code := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1378:
1379: -- New columns names added
1380: x_list_header_id := FND_API.G_MISS_NUM;
1381: x_list_line_id := FND_API.G_MISS_NUM;
1382: x_list_line_type_code := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1379: -- New columns names added
1380: x_list_header_id := FND_API.G_MISS_NUM;
1381: x_list_line_id := FND_API.G_MISS_NUM;
1382: x_list_line_type_code := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1380: x_list_header_id := FND_API.G_MISS_NUM;
1381: x_list_line_id := FND_API.G_MISS_NUM;
1382: x_list_line_type_code := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1381: x_list_line_id := FND_API.G_MISS_NUM;
1382: x_list_line_type_code := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1382: x_list_line_type_code := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1383: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1391: x_operand := FND_API.G_MISS_NUM;
1384: x_modified_from := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1391: x_operand := FND_API.G_MISS_NUM;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1385: x_modified_to := FND_API.G_MISS_CHAR;
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1391: x_operand := FND_API.G_MISS_NUM;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1393:
1386: x_update_allowed := FND_API.G_MISS_CHAR;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1391: x_operand := FND_API.G_MISS_NUM;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1393:
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1387: x_updated_flag := FND_API.G_MISS_CHAR;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1391: x_operand := FND_API.G_MISS_NUM;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1393:
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1388: x_applied_flag := FND_API.G_MISS_CHAR;
1389: x_change_reason_code := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1391: x_operand := FND_API.G_MISS_NUM;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1393:
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1390: x_change_reason_text := FND_API.G_MISS_CHAR;
1391: x_operand := FND_API.G_MISS_NUM;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1393:
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1391: x_operand := FND_API.G_MISS_NUM;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1393:
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1392: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1393:
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1393:
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1394: x_adjusted_amount := FND_API.G_MISS_NUM;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1395: x_pricing_phase_id := FND_API.G_MISS_NUM;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1396: x_list_line_no := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1397: x_source_system_code := FND_API.G_MISS_CHAR;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1398: x_benefit_qty := FND_API.G_MISS_NUM;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1399: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1400: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1401: x_expiration_date := FND_API.G_MISS_DATE;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1402: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1403: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1404: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1405: x_redeemed_date := FND_API.G_MISS_DATE;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1413: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1406: x_redeemed_flag := FND_API.G_MISS_CHAR;
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1413: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1414: --uom begin
1407: x_accrual_flag := FND_API.G_MISS_CHAR;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1413: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1414: --uom begin
1415: x_operand_per_pqty := FND_API.G_MISS_NUM;
1408: x_estimated_flag := FND_API.G_MISS_CHAR;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1413: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1414: --uom begin
1415: x_operand_per_pqty := FND_API.G_MISS_NUM;
1416: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1409: x_invoiced_flag := FND_API.G_MISS_CHAR;
1410: x_charge_type_code := FND_API.G_MISS_CHAR;
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1413: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1414: --uom begin
1415: x_operand_per_pqty := FND_API.G_MISS_NUM;
1416: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1417: --uom end
1411: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1413: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1414: --uom begin
1415: x_operand_per_pqty := FND_API.G_MISS_NUM;
1416: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1417: --uom end
1418:
1419: -- Load display out parameters if any
1412: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1413: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1414: --uom begin
1415: x_operand_per_pqty := FND_API.G_MISS_NUM;
1416: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1417: --uom end
1418:
1419: -- Load display out parameters if any
1420:
1861: OE_GLOBALS.G_UI_FLAG := FALSE;
1862:
1863: -- Set return status.
1864:
1865: x_return_status := FND_API.G_RET_STS_SUCCESS;
1866:
1867: -- Get message count and data
1868:
1869: OE_MSG_PUB.Count_And_Get
1876: END IF;
1877:
1878: EXCEPTION
1879:
1880: WHEN FND_API.G_EXC_ERROR THEN
1881:
1882: OE_GLOBALS.G_UI_FLAG := FALSE;
1883:
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1880: WHEN FND_API.G_EXC_ERROR THEN
1881:
1882: OE_GLOBALS.G_UI_FLAG := FALSE;
1883:
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885:
1886: -- Get message count and data
1887:
1888: OE_MSG_PUB.Count_And_Get
1891: );
1892:
1893: ROLLBACK TO SAVEPOINT change_attributes;
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896:
1897: OE_GLOBALS.G_UI_FLAG := FALSE;
1898:
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896:
1897: OE_GLOBALS.G_UI_FLAG := FALSE;
1898:
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1900:
1901: -- Get message count and data
1902:
1903: OE_MSG_PUB.Count_And_Get
1910: WHEN OTHERS THEN
1911:
1912: OE_GLOBALS.G_UI_FLAG := FALSE;
1913:
1914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1915:
1916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1917: THEN
1918: OE_MSG_PUB.Add_Exc_Msg
2052: );
2053:
2054:
2055: -- Set Operation.
2056: -- IF FND_API.To_Boolean(l_Line_Adj_rec.db_flag) THEN
2057: IF FND_API.To_Boolean(l_x_Line_Adj_rec.db_flag) THEN
2058: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2059: ELSE
2060: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2053:
2054:
2055: -- Set Operation.
2056: -- IF FND_API.To_Boolean(l_Line_Adj_rec.db_flag) THEN
2057: IF FND_API.To_Boolean(l_x_Line_Adj_rec.db_flag) THEN
2058: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2059: ELSE
2060: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2061: END IF;
2076:
2077:
2078: -- Call Oe_Order_Adj_Pvt.Line_Adj
2079: oe_order_adj_pvt.Line_Adjs
2080: ( p_init_msg_list => FND_API.G_TRUE
2081: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2082: , p_control_rec => l_control_rec
2083: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2084: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2077:
2078: -- Call Oe_Order_Adj_Pvt.Line_Adj
2079: oe_order_adj_pvt.Line_Adjs
2080: ( p_init_msg_list => FND_API.G_TRUE
2081: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2082: , p_control_rec => l_control_rec
2083: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2084: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2085: );
2087: /*********************************************************************
2088: -- Call OE_Order_PVT.Process_order
2089: OE_Order_PVT.Process_order
2090: ( p_api_version_number => 1.0
2091: , p_init_msg_list => FND_API.G_TRUE
2092: , x_return_status => l_return_status
2093: , x_msg_count => x_msg_count
2094: , x_msg_data => x_msg_data
2095: , p_control_rec => l_control_rec
2115: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
2116: , x_action_request_tbl => l_action_request_tbl
2117: );
2118:
2119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2121: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2116: , x_action_request_tbl => l_action_request_tbl
2117: );
2118:
2119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2121: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: *************************************************************************/
2117: );
2118:
2119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2121: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: *************************************************************************/
2125:
2118:
2119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2121: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: *************************************************************************/
2125:
2126: -- Load OUT parameters.
2125:
2126: -- Load OUT parameters.
2127: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2128:
2129: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2126: -- Load OUT parameters.
2127: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2128:
2129: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134:
2127: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2128:
2129: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134:
2135: /*****
2128:
2129: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134:
2135: /*****
2136: Oe_Order_Pvt.Process_Requests_And_Notify
2147: -- commented out by linda
2148: /****
2149: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2150: (p_request_type => OE_GLOBALS.G_CHECK_PERCENTAGE
2151: ,p_delete => FND_API.G_TRUE
2152: ,x_return_status => l_return_status
2153: );
2154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2150: (p_request_type => OE_GLOBALS.G_CHECK_PERCENTAGE
2151: ,p_delete => FND_API.G_TRUE
2152: ,x_return_status => l_return_status
2153: );
2154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2157: RAISE FND_API.G_EXC_ERROR;
2158: END IF;
2151: ,p_delete => FND_API.G_TRUE
2152: ,x_return_status => l_return_status
2153: );
2154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2157: RAISE FND_API.G_EXC_ERROR;
2158: END IF;
2159: ***/
2152: ,x_return_status => l_return_status
2153: );
2154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2157: RAISE FND_API.G_EXC_ERROR;
2158: END IF;
2159: ***/
2160:
2153: );
2154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2157: RAISE FND_API.G_EXC_ERROR;
2158: END IF;
2159: ***/
2160:
2161: /***
2161: /***
2162: IF p_ok_flag = 'Y' THEN
2163: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2164: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2165: ,p_delete => FND_API.G_TRUE
2166: ,x_return_status => l_return_status
2167: );
2168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2165: ,p_delete => FND_API.G_TRUE
2166: ,x_return_status => l_return_status
2167: );
2168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2171: RAISE FND_API.G_EXC_ERROR;
2172: END IF;
2165: ,p_delete => FND_API.G_TRUE
2166: ,x_return_status => l_return_status
2167: );
2168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2171: RAISE FND_API.G_EXC_ERROR;
2172: END IF;
2173: END IF;
2166: ,x_return_status => l_return_status
2167: );
2168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2171: RAISE FND_API.G_EXC_ERROR;
2172: END IF;
2173: END IF;
2174: ***/
2167: );
2168: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2171: RAISE FND_API.G_EXC_ERROR;
2172: END IF;
2173: END IF;
2174: ***/
2175:
2175:
2176: -- fixed bug 3271297
2177: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2178: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2179: ,p_delete => FND_API.G_TRUE
2180: ,x_return_status => l_return_status
2181: );
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2179: ,p_delete => FND_API.G_TRUE
2180: ,x_return_status => l_return_status
2181: );
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2179: ,p_delete => FND_API.G_TRUE
2180: ,x_return_status => l_return_status
2181: );
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2180: ,x_return_status => l_return_status
2181: );
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2188: x_creation_date := l_x_Line_Adj_rec.creation_date;
2181: );
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2188: x_creation_date := l_x_Line_Adj_rec.creation_date;
2189: x_created_by := l_x_Line_Adj_rec.created_by;
2203: OE_GLOBALS.G_UI_FLAG := FALSE;
2204:
2205: -- Set return status.
2206:
2207: x_return_status := FND_API.G_RET_STS_SUCCESS;
2208:
2209: -- Get message count and data
2210:
2211: OE_MSG_PUB.Count_And_Get
2218: END IF;
2219:
2220: EXCEPTION
2221:
2222: WHEN FND_API.G_EXC_ERROR THEN
2223:
2224: OE_GLOBALS.G_UI_FLAG := FALSE;
2225:
2226: x_return_status := FND_API.G_RET_STS_ERROR;
2222: WHEN FND_API.G_EXC_ERROR THEN
2223:
2224: OE_GLOBALS.G_UI_FLAG := FALSE;
2225:
2226: x_return_status := FND_API.G_RET_STS_ERROR;
2227:
2228: -- Get message count and data
2229:
2230: OE_MSG_PUB.Count_And_Get
2233: );
2234:
2235: ROLLBACK TO SAVEPOINT validate_and_write;
2236:
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238:
2239: OE_GLOBALS.G_UI_FLAG := FALSE;
2240:
2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238:
2239: OE_GLOBALS.G_UI_FLAG := FALSE;
2240:
2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2242:
2243: -- Get message count and data
2244:
2245: OE_MSG_PUB.Count_And_Get
2252: WHEN OTHERS THEN
2253:
2254: OE_GLOBALS.G_UI_FLAG := FALSE;
2255:
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2257:
2258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2259: THEN
2260: OE_MSG_PUB.Add_Exc_Msg
2381: END IF;
2382: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
2383: x_line_rec=>l_line_rec);
2384:
2385: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
2386: l_line_rec.service_reference_line_id Is Not Null --make sure is adjustment for a service line
2387: Then
2388: --To determine if this is an adjustment for service line of a top model line
2389: Begin
2417: End;
2418:
2419: If l_profile_cascade_adjustments = 'Y' Then
2420: --handling delete for adjustment for options of a top model
2421: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
2422: l_line_rec.top_model_line_id = l_line_rec.line_id
2423: Then
2424: get_option_service_lines(p_top_model_line_id =>l_line_rec.top_model_line_id,
2425: p_mode =>'OPTION',
2446: End If;
2447:
2448: -- Call Oe_Order_Adj_Pvt.Line_Adj
2449: oe_order_adj_pvt.Line_Adjs
2450: ( p_init_msg_list => FND_API.G_TRUE
2451: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2452: , p_control_rec => l_control_rec
2453: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2454: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2447:
2448: -- Call Oe_Order_Adj_Pvt.Line_Adj
2449: oe_order_adj_pvt.Line_Adjs
2450: ( p_init_msg_list => FND_API.G_TRUE
2451: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2452: , p_control_rec => l_control_rec
2453: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2454: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2455: );
2457:
2458: -- Load OUT parameters.
2459: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2460:
2461: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2464: RAISE FND_API.G_EXC_ERROR;
2465: END IF;
2458: -- Load OUT parameters.
2459: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2460:
2461: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2464: RAISE FND_API.G_EXC_ERROR;
2465: END IF;
2466:
2459: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2460:
2461: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2464: RAISE FND_API.G_EXC_ERROR;
2465: END IF;
2466:
2467:
2460:
2461: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2464: RAISE FND_API.G_EXC_ERROR;
2465: END IF;
2466:
2467:
2468: -- Clear Line_Adj record cache
2472: OE_GLOBALS.G_UI_FLAG := FALSE;
2473:
2474: -- Set return status.
2475:
2476: x_return_status := FND_API.G_RET_STS_SUCCESS;
2477:
2478: -- Get message count and data
2479:
2480: OE_MSG_PUB.Count_And_Get
2487: END IF;
2488:
2489: EXCEPTION
2490:
2491: WHEN FND_API.G_EXC_ERROR THEN
2492:
2493: OE_GLOBALS.G_UI_FLAG := FALSE;
2494:
2495: x_return_status := FND_API.G_RET_STS_ERROR;
2491: WHEN FND_API.G_EXC_ERROR THEN
2492:
2493: OE_GLOBALS.G_UI_FLAG := FALSE;
2494:
2495: x_return_status := FND_API.G_RET_STS_ERROR;
2496:
2497: -- Get message count and data
2498:
2499: OE_MSG_PUB.Count_And_Get
2500: ( p_count => x_msg_count
2501: , p_data => x_msg_data
2502: );
2503:
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505:
2506: OE_GLOBALS.G_UI_FLAG := FALSE;
2507:
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505:
2506: OE_GLOBALS.G_UI_FLAG := FALSE;
2507:
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2509:
2510: -- Get message count and data
2511:
2512: OE_MSG_PUB.Count_And_Get
2517: WHEN OTHERS THEN
2518:
2519: OE_GLOBALS.G_UI_FLAG := FALSE;
2520:
2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2522:
2523: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2524: THEN
2525: OE_MSG_PUB.Add_Exc_Msg
2592:
2593: /*
2594: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2595: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2596: ,p_delete => FND_API.G_TRUE
2597: ,x_return_status => l_return_status
2598: );
2599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2596: ,p_delete => FND_API.G_TRUE
2597: ,x_return_status => l_return_status
2598: );
2599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2602: RAISE FND_API.G_EXC_ERROR;
2603: END IF;
2596: ,p_delete => FND_API.G_TRUE
2597: ,x_return_status => l_return_status
2598: );
2599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2602: RAISE FND_API.G_EXC_ERROR;
2603: END IF;
2604:
2597: ,x_return_status => l_return_status
2598: );
2599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2602: RAISE FND_API.G_EXC_ERROR;
2603: END IF;
2604:
2605: -- process delayed requests for tax calculation.
2598: );
2599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2602: RAISE FND_API.G_EXC_ERROR;
2603: END IF;
2604:
2605: -- process delayed requests for tax calculation.
2606: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2604:
2605: -- process delayed requests for tax calculation.
2606: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2607: (p_request_type => OE_GLOBALS.G_TAX_LINE
2608: ,p_delete => FND_API.G_TRUE
2609: ,x_return_status => l_return_status
2610: );
2611: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2607: (p_request_type => OE_GLOBALS.G_TAX_LINE
2608: ,p_delete => FND_API.G_TRUE
2609: ,x_return_status => l_return_status
2610: );
2611: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2613: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2608: ,p_delete => FND_API.G_TRUE
2609: ,x_return_status => l_return_status
2610: );
2611: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2613: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616:
2609: ,x_return_status => l_return_status
2610: );
2611: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2613: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616:
2617: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
2610: );
2611: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2613: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616:
2617: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
2618: -- process delayed requests for commitment calculation.
2617: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
2618: -- process delayed requests for commitment calculation.
2619: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2620: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
2621: ,p_delete => FND_API.G_TRUE
2622: ,x_return_status => l_return_status
2623: );
2624: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2620: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
2621: ,p_delete => FND_API.G_TRUE
2622: ,x_return_status => l_return_status
2623: );
2624: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: END IF;
2621: ,p_delete => FND_API.G_TRUE
2622: ,x_return_status => l_return_status
2623: );
2624: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: END IF;
2629: END IF;
2622: ,x_return_status => l_return_status
2623: );
2624: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: END IF;
2629: END IF;
2630:
2623: );
2624: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2627: RAISE FND_API.G_EXC_ERROR;
2628: END IF;
2629: END IF;
2630:
2631: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2630:
2631: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2632: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2633: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2634: ,p_delete => FND_API.G_TRUE
2635: ,x_return_status => l_return_status
2636: );
2637:
2638: */
2642: , p_notify => TRUE
2643: , p_process_ack => TRUE
2644: , x_return_status => l_return_status
2645: );
2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF;
2643: , p_process_ack => TRUE
2644: , x_return_status => l_return_status
2645: );
2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF;
2651:
2644: , x_return_status => l_return_status
2645: );
2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF;
2651:
2652: --btea begin fix bug 1398294
2645: );
2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF;
2651:
2652: --btea begin fix bug 1398294
2653: OE_MSG_PUB.Count_And_Get
2655: , p_data => x_msg_data
2656: );
2657: --btea end fix bug 1398294
2658:
2659: x_return_status := FND_API.G_RET_STS_SUCCESS;
2660:
2661: Return;
2662:
2663: /********************************************************************
2699: -- Call OE_Order_PVT.Process_order
2700:
2701: OE_Order_PVT.Process_order
2702: ( p_api_version_number => 1.0
2703: , p_init_msg_list => FND_API.G_TRUE
2704: , x_return_status => l_return_status
2705: , x_msg_count => x_msg_count
2706: , x_msg_data => x_msg_data
2707: , p_control_rec => l_control_rec
2726: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
2727: , p_x_action_request_tbl => l_action_request_tbl
2728: );
2729:
2730: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2727: , p_x_action_request_tbl => l_action_request_tbl
2728: );
2729:
2730: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735:
2728: );
2729:
2730: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735:
2736:
2729:
2730: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735:
2736:
2737: -- Re-set the UI flag to FALSE
2738: OE_GLOBALS.G_UI_FLAG := FALSE;
2739:
2740: -- Set return status.
2741:
2742: x_return_status := FND_API.G_RET_STS_SUCCESS;
2743:
2744: -- Get message count and data
2745:
2746: OE_MSG_PUB.Count_And_Get
2753: ****************************************************************/
2754:
2755: EXCEPTION
2756:
2757: WHEN FND_API.G_EXC_ERROR THEN
2758:
2759: OE_GLOBALS.G_UI_FLAG := FALSE;
2760:
2761: x_return_status := FND_API.G_RET_STS_ERROR;
2757: WHEN FND_API.G_EXC_ERROR THEN
2758:
2759: OE_GLOBALS.G_UI_FLAG := FALSE;
2760:
2761: x_return_status := FND_API.G_RET_STS_ERROR;
2762:
2763: -- Get message count and data
2764:
2765: OE_MSG_PUB.Count_And_Get
2766: ( p_count => x_msg_count
2767: , p_data => x_msg_data
2768: );
2769:
2770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2771:
2772: OE_GLOBALS.G_UI_FLAG := FALSE;
2773:
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2771:
2772: OE_GLOBALS.G_UI_FLAG := FALSE;
2773:
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2775:
2776: -- Get message count and data
2777:
2778: OE_MSG_PUB.Count_And_Get
2783: WHEN OTHERS THEN
2784:
2785: OE_GLOBALS.G_UI_FLAG := FALSE;
2786:
2787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2788:
2789: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2790: THEN
2791: OE_MSG_PUB.Add_Exc_Msg
2976: END IF;
2977:
2978: -- Call Oe_Order_Adj_Pvt.Line_Adj
2979: oe_order_adj_pvt.Line_Adjs
2980: ( p_init_msg_list => FND_API.G_TRUE
2981: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2982: , p_control_rec => l_control_rec
2983: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2984: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2977:
2978: -- Call Oe_Order_Adj_Pvt.Line_Adj
2979: oe_order_adj_pvt.Line_Adjs
2980: ( p_init_msg_list => FND_API.G_TRUE
2981: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2982: , p_control_rec => l_control_rec
2983: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2984: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2985: );
2988:
2989: -- Load OUT parameters.
2990: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2991:
2992: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2994: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2989: -- Load OUT parameters.
2990: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2991:
2992: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2994: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:
2990: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2991:
2992: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2994: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:
2998: IF l_debug_level > 0 THEN
2991:
2992: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2994: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:
2998: IF l_debug_level > 0 THEN
2999: oe_debug_pub.add( 'AFTER EXECUTING PROCESS_ORDER...' , 1 ) ;
3009: OE_GLOBALS.G_UI_FLAG := FALSE;
3010:
3011: -- Set return status.
3012:
3013: x_return_status := FND_API.G_RET_STS_SUCCESS;
3014:
3015: -- Get message count and data
3016:
3017: OE_MSG_PUB.Count_And_Get
3024: END IF;
3025:
3026: EXCEPTION
3027:
3028: WHEN FND_API.G_EXC_ERROR THEN
3029:
3030: OE_GLOBALS.G_UI_FLAG := FALSE;
3031:
3032: x_return_status := FND_API.G_RET_STS_ERROR;
3028: WHEN FND_API.G_EXC_ERROR THEN
3029:
3030: OE_GLOBALS.G_UI_FLAG := FALSE;
3031:
3032: x_return_status := FND_API.G_RET_STS_ERROR;
3033:
3034: -- Get message count and data
3035:
3036: OE_MSG_PUB.Count_And_Get
3039: );
3040:
3041: ROLLBACK TO SAVEPOINT replace_attributes;
3042:
3043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3044:
3045: OE_GLOBALS.G_UI_FLAG := FALSE;
3046:
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3044:
3045: OE_GLOBALS.G_UI_FLAG := FALSE;
3046:
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3048:
3049: -- Get message count and data
3050:
3051: OE_MSG_PUB.Count_And_Get
3058: WHEN OTHERS THEN
3059:
3060: OE_GLOBALS.G_UI_FLAG := FALSE;
3061:
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3063:
3064: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3065: THEN
3066: OE_MSG_PUB.Add_Exc_Msg
3121: ( x_return_status => l_return_status
3122: , p_x_line_adj_rec => l_x_line_adj_rec
3123: );
3124:
3125: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3126:
3127: -- Set DB flag and write record to cache.
3128: l_x_Line_Adj_rec.db_flag := FND_API.G_TRUE;
3129:
3124:
3125: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3126:
3127: -- Set DB flag and write record to cache.
3128: l_x_Line_Adj_rec.db_flag := FND_API.G_TRUE;
3129:
3130: Write_Line_Adj
3131: ( p_Line_Adj_rec => l_x_Line_Adj_rec
3132: , p_db_record => TRUE
3160: , 'Lock_Row'
3161: );
3162: END IF;
3163:
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3165:
3166: -- Get message count and data
3167:
3168: OE_MSG_PUB.Count_And_Get
3231: ( p_price_adjustment_id => p_price_adjustment_id
3232: , x_Line_Adj_rec => g_Line_Adj_rec
3233: );
3234:
3235: g_Line_Adj_rec.db_flag := FND_API.G_TRUE;
3236:
3237: -- Load DB record
3238:
3239: g_db_Line_Adj_rec := g_Line_Adj_rec;
3350:
3351:
3352: IF l_line_adj_tbl(1).range_break_quantity IS NULL
3353: AND l_line_adj_tbl(1).list_line_type_code = 'PBH'
3354: AND nvl(l_Line_Adj_Tbl(1).list_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
3355: THEN
3356:
3357: IF l_line_adj_tbl(1).UPDATED_FLAG IS NULL THEN
3358: l_line_adj_tbl(1).UPDATED_FLAG := 'Y';
3393: INTO l_line_adj_tbl(1).price_adjustment_id
3394: FROM Dual;
3395:
3396:
3397: Oe_Order_Adj_Pvt.Line_Adjs(p_validation_level => FND_API.G_VALID_LEVEL_NONE,
3398: p_control_rec => l_control_rec,
3399: p_x_line_adj_tbl => l_line_adj_tbl,
3400: p_x_old_line_adj_tbl => l_dummy_tbl);
3401: x_price_adjustment_id := l_line_adj_tbl(1).price_adjustment_id;
3406: WHEN OTHERS THEN
3407:
3408: OE_GLOBALS.G_UI_FLAG := FALSE;
3409:
3410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3411:
3412: OE_MSG_PUB.Add_Exc_Msg
3413: ( G_PKG_NAME
3414: , 'Oe_Oe_Form_Line_Adj.Insert_Row:'||SQLERRM
3528: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3529: --
3530: Begin
3531:
3532: If nvl(p_parent_adj_rec.operand,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
3533: IF l_debug_level > 0 THEN
3534: oe_debug_pub.add( ' CS PARENT OPERAND IS NULL' ) ;
3535: END IF;
3536: Return;