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,
1070: , 'Unrecognized attribute'
1071: );
1072: END IF;
1073:
1074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1075:
1076: END IF;
1077:
1078: IF l_debug_level > 0 THEN
1083: END IF;
1084:
1085: -- Set Operation.
1086:
1087: IF FND_API.To_Boolean(l_x_Line_Adj_rec.db_flag) THEN
1088: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1089: ELSE
1090: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1091: END IF;
1144: --Cascading adjustments for service lines
1145: IF l_debug_level > 0 THEN
1146: oe_debug_pub.add( ' CS QUERIED LINE_ID:'||L_LINE_REC.LINE_ID ) ;
1147: END IF;
1148: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
1149: l_line_rec.service_reference_line_id Is Not Null --make sure is adjustment for a service line
1150: Then
1151: --To determine if this is an adjustment for service line of a top model line
1152: Begin
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( ' TOP MODEL LINE ID:'||L_LINE_REC.TOP_MODEL_LINE_ID ) ;
1191: END IF;
1192: --Cascading adjustments from top model to option lines
1193: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
1194: l_line_rec.line_id = l_line_rec.top_model_line_id --to make sure this is a top model line
1195: Then
1196: get_option_service_lines(p_top_model_line_id=>l_line_rec.top_model_line_id,
1197: p_mode => 'OPTION',
1213: --we will need to cascade change reason code too, if it got changed
1214: If p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE Then
1215:
1216: --If no line queried, requery again else just use this to
1217: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
1218: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
1219: x_line_rec=>l_line_rec);
1220: End If;
1221:
1247: -- Call Oe_Order_Adj_Pvt.Line_Adj
1248: l_Line_Adj_rec := l_x_Line_Adj_rec;
1249:
1250: oe_order_adj_pvt.Line_Adjs
1251: ( p_init_msg_list => FND_API.G_TRUE
1252: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1253: , p_control_rec => l_control_rec
1254: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
1255: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
1248: l_Line_Adj_rec := l_x_Line_Adj_rec;
1249:
1250: oe_order_adj_pvt.Line_Adjs
1251: ( p_init_msg_list => FND_API.G_TRUE
1252: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1253: , p_control_rec => l_control_rec
1254: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
1255: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
1256: );
1258: /************************************************************************
1259: -- Call OE_Order_PVT.Process_order
1260: OE_Order_PVT.Process_order
1261: ( p_api_version_number => 1.0
1262: , p_init_msg_list => FND_API.G_TRUE
1263: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1264: , x_return_status => l_return_status
1265: , x_msg_count => x_msg_count
1266: , x_msg_data => x_msg_data
1259: -- Call OE_Order_PVT.Process_order
1260: OE_Order_PVT.Process_order
1261: ( p_api_version_number => 1.0
1262: , p_init_msg_list => FND_API.G_TRUE
1263: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1264: , x_return_status => l_return_status
1265: , x_msg_count => x_msg_count
1266: , x_msg_data => x_msg_data
1267: , p_control_rec => l_control_rec
1291: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
1292: , x_action_request_tbl => l_action_request_tbl
1293: );
1294:
1295: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1298: RAISE FND_API.G_EXC_ERROR;
1299: END IF;
1292: , x_action_request_tbl => l_action_request_tbl
1293: );
1294:
1295: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1298: RAISE FND_API.G_EXC_ERROR;
1299: END IF;
1300: ******************************************************************/
1293: );
1294:
1295: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1298: RAISE FND_API.G_EXC_ERROR;
1299: END IF;
1300: ******************************************************************/
1301:
1294:
1295: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1298: RAISE FND_API.G_EXC_ERROR;
1299: END IF;
1300: ******************************************************************/
1301:
1302: -- Unload out tbl
1301:
1302: -- Unload out tbl
1303: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
1304:
1305: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;
1302: -- Unload out tbl
1303: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
1304:
1305: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;
1310:
1303: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
1304:
1305: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;
1310:
1311: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1304:
1305: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;
1310:
1311: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1312: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1309: END IF;
1310:
1311: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1312: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1313: ,p_delete => FND_API.G_TRUE
1314: ,x_return_status => l_return_status
1315: );
1316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1312: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1313: ,p_delete => FND_API.G_TRUE
1314: ,x_return_status => l_return_status
1315: );
1316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1313: ,p_delete => FND_API.G_TRUE
1314: ,x_return_status => l_return_status
1315: );
1316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1314: ,x_return_status => l_return_status
1315: );
1316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1322: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1315: );
1316: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1322: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1323: (p_request_type => OE_GLOBALS.G_CHECK_FIXED_PRICE
1320: END IF;
1321:
1322: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1323: (p_request_type => OE_GLOBALS.G_CHECK_FIXED_PRICE
1324: ,p_delete => FND_API.G_TRUE
1325: ,x_return_status => l_return_status
1326: );
1327: IF p_enforce_fixed_price = 'YES' THEN
1328: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1324: ,p_delete => FND_API.G_TRUE
1325: ,x_return_status => l_return_status
1326: );
1327: IF p_enforce_fixed_price = 'YES' THEN
1328: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: END IF;
1325: ,x_return_status => l_return_status
1326: );
1327: IF p_enforce_fixed_price = 'YES' THEN
1328: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: END IF;
1333: ELSE
1326: );
1327: IF p_enforce_fixed_price = 'YES' THEN
1328: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: END IF;
1333: ELSE
1334: l_return_status := FND_API.G_RET_STS_SUCCESS;
1327: IF p_enforce_fixed_price = 'YES' THEN
1328: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: END IF;
1333: ELSE
1334: l_return_status := FND_API.G_RET_STS_SUCCESS;
1335: END IF;
1330: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: END IF;
1333: ELSE
1334: l_return_status := FND_API.G_RET_STS_SUCCESS;
1335: END IF;
1336:
1337:
1338: -- Init OUT parameters to missing.
1336:
1337:
1338: -- Init OUT parameters to missing.
1339:
1340: x_price_adjustment_id := FND_API.G_MISS_NUM;
1341: x_header_id := FND_API.G_MISS_NUM;
1342: x_discount_id := FND_API.G_MISS_NUM;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1337:
1338: -- Init OUT parameters to missing.
1339:
1340: x_price_adjustment_id := FND_API.G_MISS_NUM;
1341: x_header_id := FND_API.G_MISS_NUM;
1342: x_discount_id := FND_API.G_MISS_NUM;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1338: -- Init OUT parameters to missing.
1339:
1340: x_price_adjustment_id := FND_API.G_MISS_NUM;
1341: x_header_id := FND_API.G_MISS_NUM;
1342: x_discount_id := FND_API.G_MISS_NUM;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1339:
1340: x_price_adjustment_id := FND_API.G_MISS_NUM;
1341: x_header_id := FND_API.G_MISS_NUM;
1342: x_discount_id := FND_API.G_MISS_NUM;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1340: x_price_adjustment_id := FND_API.G_MISS_NUM;
1341: x_header_id := FND_API.G_MISS_NUM;
1342: x_discount_id := FND_API.G_MISS_NUM;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1341: x_header_id := FND_API.G_MISS_NUM;
1342: x_discount_id := FND_API.G_MISS_NUM;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1342: x_discount_id := FND_API.G_MISS_NUM;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1343: x_discount := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1344: x_discount_line_id := FND_API.G_MISS_NUM;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1345: x_automatic_flag := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1346: x_percent := FND_API.G_MISS_NUM;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1347: x_line_id := FND_API.G_MISS_NUM;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1348: x_context := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1349: x_attribute1 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1350: x_attribute2 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1351: x_attribute3 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1352: x_attribute4 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1353: x_attribute5 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1354: x_attribute6 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1355: x_attribute7 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1356: x_attribute8 := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1357: x_attribute9 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1358: x_attribute10 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1359: x_attribute11 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1360: x_attribute12 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1361: x_attribute13 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1362: x_attribute14 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1363: x_attribute15 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1364: x_ac_context := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1365: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1366: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1367: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1368: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1369: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1370: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1378: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1371: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1378: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1379: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1372: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1378: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1379: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1380:
1373: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1378: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1379: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1380:
1381: -- New columns names added
1374: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1378: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1379: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1380:
1381: -- New columns names added
1382: x_list_header_id := FND_API.G_MISS_NUM;
1375: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1376: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1377: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1378: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1379: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1380:
1381: -- New columns names added
1382: x_list_header_id := FND_API.G_MISS_NUM;
1383: x_list_line_id := FND_API.G_MISS_NUM;
1378: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1379: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1380:
1381: -- New columns names added
1382: x_list_header_id := FND_API.G_MISS_NUM;
1383: x_list_line_id := FND_API.G_MISS_NUM;
1384: x_list_line_type_code := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1379: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1380:
1381: -- New columns names added
1382: x_list_header_id := FND_API.G_MISS_NUM;
1383: x_list_line_id := FND_API.G_MISS_NUM;
1384: x_list_line_type_code := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1380:
1381: -- New columns names added
1382: x_list_header_id := FND_API.G_MISS_NUM;
1383: x_list_line_id := FND_API.G_MISS_NUM;
1384: x_list_line_type_code := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1381: -- New columns names added
1382: x_list_header_id := FND_API.G_MISS_NUM;
1383: x_list_line_id := FND_API.G_MISS_NUM;
1384: x_list_line_type_code := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1382: x_list_header_id := FND_API.G_MISS_NUM;
1383: x_list_line_id := FND_API.G_MISS_NUM;
1384: x_list_line_type_code := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1383: x_list_line_id := FND_API.G_MISS_NUM;
1384: x_list_line_type_code := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1384: x_list_line_type_code := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1385: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1393: x_operand := FND_API.G_MISS_NUM;
1386: x_modified_from := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1393: x_operand := FND_API.G_MISS_NUM;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1387: x_modified_to := FND_API.G_MISS_CHAR;
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1393: x_operand := FND_API.G_MISS_NUM;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1395:
1388: x_update_allowed := FND_API.G_MISS_CHAR;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1393: x_operand := FND_API.G_MISS_NUM;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1395:
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1389: x_updated_flag := FND_API.G_MISS_CHAR;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1393: x_operand := FND_API.G_MISS_NUM;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1395:
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1390: x_applied_flag := FND_API.G_MISS_CHAR;
1391: x_change_reason_code := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1393: x_operand := FND_API.G_MISS_NUM;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1395:
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1392: x_change_reason_text := FND_API.G_MISS_CHAR;
1393: x_operand := FND_API.G_MISS_NUM;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1395:
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1393: x_operand := FND_API.G_MISS_NUM;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1395:
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1394: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1395:
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1395:
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1396: x_adjusted_amount := FND_API.G_MISS_NUM;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1397: x_pricing_phase_id := FND_API.G_MISS_NUM;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1398: x_list_line_no := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1399: x_source_system_code := FND_API.G_MISS_CHAR;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1400: x_benefit_qty := FND_API.G_MISS_NUM;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1401: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1402: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1403: x_expiration_date := FND_API.G_MISS_DATE;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1404: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1405: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1406: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1407: x_redeemed_date := FND_API.G_MISS_DATE;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1415: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1408: x_redeemed_flag := FND_API.G_MISS_CHAR;
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1415: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1416: --uom begin
1409: x_accrual_flag := FND_API.G_MISS_CHAR;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1415: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1416: --uom begin
1417: x_operand_per_pqty := FND_API.G_MISS_NUM;
1410: x_estimated_flag := FND_API.G_MISS_CHAR;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1415: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1416: --uom begin
1417: x_operand_per_pqty := FND_API.G_MISS_NUM;
1418: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1411: x_invoiced_flag := FND_API.G_MISS_CHAR;
1412: x_charge_type_code := FND_API.G_MISS_CHAR;
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1415: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1416: --uom begin
1417: x_operand_per_pqty := FND_API.G_MISS_NUM;
1418: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1419: --uom end
1413: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1415: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1416: --uom begin
1417: x_operand_per_pqty := FND_API.G_MISS_NUM;
1418: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1419: --uom end
1420:
1421: -- Load display out parameters if any
1414: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1415: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1416: --uom begin
1417: x_operand_per_pqty := FND_API.G_MISS_NUM;
1418: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1419: --uom end
1420:
1421: -- Load display out parameters if any
1422:
1863: OE_GLOBALS.G_UI_FLAG := FALSE;
1864:
1865: -- Set return status.
1866:
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;
1868:
1869: -- Get message count and data
1870:
1871: OE_MSG_PUB.Count_And_Get
1878: END IF;
1879:
1880: EXCEPTION
1881:
1882: WHEN FND_API.G_EXC_ERROR THEN
1883:
1884: OE_GLOBALS.G_UI_FLAG := FALSE;
1885:
1886: x_return_status := FND_API.G_RET_STS_ERROR;
1882: WHEN FND_API.G_EXC_ERROR THEN
1883:
1884: OE_GLOBALS.G_UI_FLAG := FALSE;
1885:
1886: x_return_status := FND_API.G_RET_STS_ERROR;
1887:
1888: -- Get message count and data
1889:
1890: OE_MSG_PUB.Count_And_Get
1893: );
1894:
1895: ROLLBACK TO SAVEPOINT change_attributes;
1896:
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898:
1899: OE_GLOBALS.G_UI_FLAG := FALSE;
1900:
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898:
1899: OE_GLOBALS.G_UI_FLAG := FALSE;
1900:
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1902:
1903: -- Get message count and data
1904:
1905: OE_MSG_PUB.Count_And_Get
1912: WHEN OTHERS THEN
1913:
1914: OE_GLOBALS.G_UI_FLAG := FALSE;
1915:
1916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1917:
1918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1919: THEN
1920: OE_MSG_PUB.Add_Exc_Msg
2054: );
2055:
2056:
2057: -- Set Operation.
2058: -- IF FND_API.To_Boolean(l_Line_Adj_rec.db_flag) THEN
2059: IF FND_API.To_Boolean(l_x_Line_Adj_rec.db_flag) THEN
2060: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2061: ELSE
2062: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2055:
2056:
2057: -- Set Operation.
2058: -- IF FND_API.To_Boolean(l_Line_Adj_rec.db_flag) THEN
2059: IF FND_API.To_Boolean(l_x_Line_Adj_rec.db_flag) THEN
2060: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2061: ELSE
2062: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2063: END IF;
2078:
2079:
2080: -- Call Oe_Order_Adj_Pvt.Line_Adj
2081: oe_order_adj_pvt.Line_Adjs
2082: ( p_init_msg_list => FND_API.G_TRUE
2083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2084: , p_control_rec => l_control_rec
2085: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2086: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2079:
2080: -- Call Oe_Order_Adj_Pvt.Line_Adj
2081: oe_order_adj_pvt.Line_Adjs
2082: ( p_init_msg_list => FND_API.G_TRUE
2083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2084: , p_control_rec => l_control_rec
2085: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2086: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2087: );
2089: /*********************************************************************
2090: -- Call OE_Order_PVT.Process_order
2091: OE_Order_PVT.Process_order
2092: ( p_api_version_number => 1.0
2093: , p_init_msg_list => FND_API.G_TRUE
2094: , x_return_status => l_return_status
2095: , x_msg_count => x_msg_count
2096: , x_msg_data => x_msg_data
2097: , p_control_rec => l_control_rec
2117: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
2118: , x_action_request_tbl => l_action_request_tbl
2119: );
2120:
2121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2124: RAISE FND_API.G_EXC_ERROR;
2125: END IF;
2118: , x_action_request_tbl => l_action_request_tbl
2119: );
2120:
2121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2124: RAISE FND_API.G_EXC_ERROR;
2125: END IF;
2126: *************************************************************************/
2119: );
2120:
2121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2124: RAISE FND_API.G_EXC_ERROR;
2125: END IF;
2126: *************************************************************************/
2127:
2120:
2121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2124: RAISE FND_API.G_EXC_ERROR;
2125: END IF;
2126: *************************************************************************/
2127:
2128: -- Load OUT parameters.
2127:
2128: -- Load OUT parameters.
2129: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2130:
2131: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2128: -- Load OUT parameters.
2129: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2130:
2131: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2129: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2130:
2131: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137: /*****
2130:
2131: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137: /*****
2138: Oe_Order_Pvt.Process_Requests_And_Notify
2149: -- commented out by linda
2150: /****
2151: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2152: (p_request_type => OE_GLOBALS.G_CHECK_PERCENTAGE
2153: ,p_delete => FND_API.G_TRUE
2154: ,x_return_status => l_return_status
2155: );
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: (p_request_type => OE_GLOBALS.G_CHECK_PERCENTAGE
2153: ,p_delete => FND_API.G_TRUE
2154: ,x_return_status => l_return_status
2155: );
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2153: ,p_delete => FND_API.G_TRUE
2154: ,x_return_status => l_return_status
2155: );
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161: ***/
2154: ,x_return_status => l_return_status
2155: );
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161: ***/
2162:
2155: );
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161: ***/
2162:
2163: /***
2163: /***
2164: IF p_ok_flag = 'Y' THEN
2165: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2166: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2167: ,p_delete => FND_API.G_TRUE
2168: ,x_return_status => l_return_status
2169: );
2170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2166: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2167: ,p_delete => FND_API.G_TRUE
2168: ,x_return_status => l_return_status
2169: );
2170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2167: ,p_delete => FND_API.G_TRUE
2168: ,x_return_status => l_return_status
2169: );
2170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2175: END IF;
2168: ,x_return_status => l_return_status
2169: );
2170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2175: END IF;
2176: ***/
2169: );
2170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2175: END IF;
2176: ***/
2177:
2178: --TaxER start
2179: IF nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN
2180: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2181: (p_request_type => OE_GLOBALS.G_TAX_LINE
2182: ,p_delete => FND_API.G_TRUE
2183: ,x_return_status => l_return_status
2184: );
2185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2181: (p_request_type => OE_GLOBALS.G_TAX_LINE
2182: ,p_delete => FND_API.G_TRUE
2183: ,x_return_status => l_return_status
2184: );
2185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;
2182: ,p_delete => FND_API.G_TRUE
2183: ,x_return_status => l_return_status
2184: );
2185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;
2190: END IF;
2183: ,x_return_status => l_return_status
2184: );
2185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;
2190: END IF;
2191: --TaxER end
2184: );
2185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;
2190: END IF;
2191: --TaxER end
2192: -- fixed bug 3271297
2191: --TaxER end
2192: -- fixed bug 3271297
2193: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2194: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2195: ,p_delete => FND_API.G_TRUE
2196: ,x_return_status => l_return_status
2197: );
2198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2194: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2195: ,p_delete => FND_API.G_TRUE
2196: ,x_return_status => l_return_status
2197: );
2198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2195: ,p_delete => FND_API.G_TRUE
2196: ,x_return_status => l_return_status
2197: );
2198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2203:
2196: ,x_return_status => l_return_status
2197: );
2198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2203:
2204:
2197: );
2198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2203:
2204:
2205: x_creation_date := l_x_Line_Adj_rec.creation_date;
2220: OE_GLOBALS.G_UI_FLAG := FALSE;
2221:
2222: -- Set return status.
2223:
2224: x_return_status := FND_API.G_RET_STS_SUCCESS;
2225:
2226: -- Get message count and data
2227:
2228: OE_MSG_PUB.Count_And_Get
2235: END IF;
2236:
2237: EXCEPTION
2238:
2239: WHEN FND_API.G_EXC_ERROR THEN
2240:
2241: OE_GLOBALS.G_UI_FLAG := FALSE;
2242:
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2239: WHEN FND_API.G_EXC_ERROR THEN
2240:
2241: OE_GLOBALS.G_UI_FLAG := FALSE;
2242:
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244:
2245: -- Get message count and data
2246:
2247: OE_MSG_PUB.Count_And_Get
2250: );
2251:
2252: ROLLBACK TO SAVEPOINT validate_and_write;
2253:
2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255:
2256: OE_GLOBALS.G_UI_FLAG := FALSE;
2257:
2258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255:
2256: OE_GLOBALS.G_UI_FLAG := FALSE;
2257:
2258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2259:
2260: -- Get message count and data
2261:
2262: OE_MSG_PUB.Count_And_Get
2269: WHEN OTHERS THEN
2270:
2271: OE_GLOBALS.G_UI_FLAG := FALSE;
2272:
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274:
2275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2276: THEN
2277: OE_MSG_PUB.Add_Exc_Msg
2398: END IF;
2399: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
2400: x_line_rec=>l_line_rec);
2401:
2402: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
2403: l_line_rec.service_reference_line_id Is Not Null --make sure is adjustment for a service line
2404: Then
2405: --To determine if this is an adjustment for service line of a top model line
2406: Begin
2434: End;
2435:
2436: If l_profile_cascade_adjustments = 'Y' Then
2437: --handling delete for adjustment for options of a top model
2438: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
2439: l_line_rec.top_model_line_id = l_line_rec.line_id
2440: Then
2441: get_option_service_lines(p_top_model_line_id =>l_line_rec.top_model_line_id,
2442: p_mode =>'OPTION',
2463: End If;
2464:
2465: -- Call Oe_Order_Adj_Pvt.Line_Adj
2466: oe_order_adj_pvt.Line_Adjs
2467: ( p_init_msg_list => FND_API.G_TRUE
2468: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2469: , p_control_rec => l_control_rec
2470: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2471: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2464:
2465: -- Call Oe_Order_Adj_Pvt.Line_Adj
2466: oe_order_adj_pvt.Line_Adjs
2467: ( p_init_msg_list => FND_API.G_TRUE
2468: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2469: , p_control_rec => l_control_rec
2470: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
2471: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2472: );
2474:
2475: -- Load OUT parameters.
2476: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2477:
2478: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2475: -- Load OUT parameters.
2476: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2477:
2478: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2483:
2476: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
2477:
2478: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2483:
2484:
2477:
2478: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2483:
2484:
2485: -- Clear Line_Adj record cache
2489: OE_GLOBALS.G_UI_FLAG := FALSE;
2490:
2491: -- Set return status.
2492:
2493: x_return_status := FND_API.G_RET_STS_SUCCESS;
2494:
2495: -- Get message count and data
2496:
2497: OE_MSG_PUB.Count_And_Get
2504: END IF;
2505:
2506: EXCEPTION
2507:
2508: WHEN FND_API.G_EXC_ERROR THEN
2509:
2510: OE_GLOBALS.G_UI_FLAG := FALSE;
2511:
2512: x_return_status := FND_API.G_RET_STS_ERROR;
2508: WHEN FND_API.G_EXC_ERROR THEN
2509:
2510: OE_GLOBALS.G_UI_FLAG := FALSE;
2511:
2512: x_return_status := FND_API.G_RET_STS_ERROR;
2513:
2514: -- Get message count and data
2515:
2516: OE_MSG_PUB.Count_And_Get
2517: ( p_count => x_msg_count
2518: , p_data => x_msg_data
2519: );
2520:
2521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2522:
2523: OE_GLOBALS.G_UI_FLAG := FALSE;
2524:
2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2522:
2523: OE_GLOBALS.G_UI_FLAG := FALSE;
2524:
2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2526:
2527: -- Get message count and data
2528:
2529: OE_MSG_PUB.Count_And_Get
2534: WHEN OTHERS THEN
2535:
2536: OE_GLOBALS.G_UI_FLAG := FALSE;
2537:
2538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2539:
2540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2541: THEN
2542: OE_MSG_PUB.Add_Exc_Msg
2609:
2610: /*
2611: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2612: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2613: ,p_delete => FND_API.G_TRUE
2614: ,x_return_status => l_return_status
2615: );
2616: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2613: ,p_delete => FND_API.G_TRUE
2614: ,x_return_status => l_return_status
2615: );
2616: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2618: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2619: RAISE FND_API.G_EXC_ERROR;
2620: END IF;
2613: ,p_delete => FND_API.G_TRUE
2614: ,x_return_status => l_return_status
2615: );
2616: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2618: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2619: RAISE FND_API.G_EXC_ERROR;
2620: END IF;
2621:
2614: ,x_return_status => l_return_status
2615: );
2616: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2618: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2619: RAISE FND_API.G_EXC_ERROR;
2620: END IF;
2621:
2622: -- process delayed requests for tax calculation.
2615: );
2616: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2618: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2619: RAISE FND_API.G_EXC_ERROR;
2620: END IF;
2621:
2622: -- process delayed requests for tax calculation.
2623: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2621:
2622: -- process delayed requests for tax calculation.
2623: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2624: (p_request_type => OE_GLOBALS.G_TAX_LINE
2625: ,p_delete => FND_API.G_TRUE
2626: ,x_return_status => l_return_status
2627: );
2628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2624: (p_request_type => OE_GLOBALS.G_TAX_LINE
2625: ,p_delete => FND_API.G_TRUE
2626: ,x_return_status => l_return_status
2627: );
2628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2631: RAISE FND_API.G_EXC_ERROR;
2632: END IF;
2625: ,p_delete => FND_API.G_TRUE
2626: ,x_return_status => l_return_status
2627: );
2628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2631: RAISE FND_API.G_EXC_ERROR;
2632: END IF;
2633:
2626: ,x_return_status => l_return_status
2627: );
2628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2631: RAISE FND_API.G_EXC_ERROR;
2632: END IF;
2633:
2634: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
2627: );
2628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2631: RAISE FND_API.G_EXC_ERROR;
2632: END IF;
2633:
2634: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
2635: -- process delayed requests for commitment calculation.
2634: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
2635: -- process delayed requests for commitment calculation.
2636: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2637: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
2638: ,p_delete => FND_API.G_TRUE
2639: ,x_return_status => l_return_status
2640: );
2641: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2637: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
2638: ,p_delete => FND_API.G_TRUE
2639: ,x_return_status => l_return_status
2640: );
2641: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2643: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2644: RAISE FND_API.G_EXC_ERROR;
2645: END IF;
2638: ,p_delete => FND_API.G_TRUE
2639: ,x_return_status => l_return_status
2640: );
2641: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2643: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2644: RAISE FND_API.G_EXC_ERROR;
2645: END IF;
2646: END IF;
2639: ,x_return_status => l_return_status
2640: );
2641: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2643: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2644: RAISE FND_API.G_EXC_ERROR;
2645: END IF;
2646: END IF;
2647:
2640: );
2641: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2643: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2644: RAISE FND_API.G_EXC_ERROR;
2645: END IF;
2646: END IF;
2647:
2648: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2647:
2648: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2649: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2650: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2651: ,p_delete => FND_API.G_TRUE
2652: ,x_return_status => l_return_status
2653: );
2654:
2655: */
2659: , p_notify => TRUE
2660: , p_process_ack => TRUE
2661: , x_return_status => l_return_status
2662: );
2663: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2665: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2660: , p_process_ack => TRUE
2661: , x_return_status => l_return_status
2662: );
2663: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2665: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668:
2661: , x_return_status => l_return_status
2662: );
2663: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2665: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668:
2669: --btea begin fix bug 1398294
2662: );
2663: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2665: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668:
2669: --btea begin fix bug 1398294
2670: OE_MSG_PUB.Count_And_Get
2672: , p_data => x_msg_data
2673: );
2674: --btea end fix bug 1398294
2675:
2676: x_return_status := FND_API.G_RET_STS_SUCCESS;
2677:
2678: Return;
2679:
2680: /********************************************************************
2716: -- Call OE_Order_PVT.Process_order
2717:
2718: OE_Order_PVT.Process_order
2719: ( p_api_version_number => 1.0
2720: , p_init_msg_list => FND_API.G_TRUE
2721: , x_return_status => l_return_status
2722: , x_msg_count => x_msg_count
2723: , x_msg_data => x_msg_data
2724: , p_control_rec => l_control_rec
2743: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
2744: , p_x_action_request_tbl => l_action_request_tbl
2745: );
2746:
2747: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2749: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2744: , p_x_action_request_tbl => l_action_request_tbl
2745: );
2746:
2747: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2749: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752:
2745: );
2746:
2747: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2749: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752:
2753:
2746:
2747: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2749: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752:
2753:
2754: -- Re-set the UI flag to FALSE
2755: OE_GLOBALS.G_UI_FLAG := FALSE;
2756:
2757: -- Set return status.
2758:
2759: x_return_status := FND_API.G_RET_STS_SUCCESS;
2760:
2761: -- Get message count and data
2762:
2763: OE_MSG_PUB.Count_And_Get
2770: ****************************************************************/
2771:
2772: EXCEPTION
2773:
2774: WHEN FND_API.G_EXC_ERROR THEN
2775:
2776: OE_GLOBALS.G_UI_FLAG := FALSE;
2777:
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2774: WHEN FND_API.G_EXC_ERROR THEN
2775:
2776: OE_GLOBALS.G_UI_FLAG := FALSE;
2777:
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779:
2780: -- Get message count and data
2781:
2782: OE_MSG_PUB.Count_And_Get
2783: ( p_count => x_msg_count
2784: , p_data => x_msg_data
2785: );
2786:
2787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2788:
2789: OE_GLOBALS.G_UI_FLAG := FALSE;
2790:
2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2788:
2789: OE_GLOBALS.G_UI_FLAG := FALSE;
2790:
2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2792:
2793: -- Get message count and data
2794:
2795: OE_MSG_PUB.Count_And_Get
2800: WHEN OTHERS THEN
2801:
2802: OE_GLOBALS.G_UI_FLAG := FALSE;
2803:
2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2805:
2806: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2807: THEN
2808: OE_MSG_PUB.Add_Exc_Msg
2993: END IF;
2994:
2995: -- Call Oe_Order_Adj_Pvt.Line_Adj
2996: oe_order_adj_pvt.Line_Adjs
2997: ( p_init_msg_list => FND_API.G_TRUE
2998: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2999: , p_control_rec => l_control_rec
3000: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
3001: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
2994:
2995: -- Call Oe_Order_Adj_Pvt.Line_Adj
2996: oe_order_adj_pvt.Line_Adjs
2997: ( p_init_msg_list => FND_API.G_TRUE
2998: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2999: , p_control_rec => l_control_rec
3000: , p_x_line_adj_tbl => l_x_Line_Adj_tbl
3001: , p_x_old_line_adj_tbl => l_x_old_Line_Adj_tbl
3002: );
3005:
3006: -- Load OUT parameters.
3007: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
3008:
3009: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
3012: RAISE FND_API.G_EXC_ERROR;
3013: END IF;
3006: -- Load OUT parameters.
3007: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
3008:
3009: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
3012: RAISE FND_API.G_EXC_ERROR;
3013: END IF;
3014:
3007: l_x_Line_Adj_rec := l_x_Line_Adj_tbl(1);
3008:
3009: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
3012: RAISE FND_API.G_EXC_ERROR;
3013: END IF;
3014:
3015: IF l_debug_level > 0 THEN
3008:
3009: IF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: ELSIF l_x_Line_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
3012: RAISE FND_API.G_EXC_ERROR;
3013: END IF;
3014:
3015: IF l_debug_level > 0 THEN
3016: oe_debug_pub.add( 'AFTER EXECUTING PROCESS_ORDER...' , 1 ) ;
3026: OE_GLOBALS.G_UI_FLAG := FALSE;
3027:
3028: -- Set return status.
3029:
3030: x_return_status := FND_API.G_RET_STS_SUCCESS;
3031:
3032: -- Get message count and data
3033:
3034: OE_MSG_PUB.Count_And_Get
3041: END IF;
3042:
3043: EXCEPTION
3044:
3045: WHEN FND_API.G_EXC_ERROR THEN
3046:
3047: OE_GLOBALS.G_UI_FLAG := FALSE;
3048:
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3045: WHEN FND_API.G_EXC_ERROR THEN
3046:
3047: OE_GLOBALS.G_UI_FLAG := FALSE;
3048:
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3050:
3051: -- Get message count and data
3052:
3053: OE_MSG_PUB.Count_And_Get
3056: );
3057:
3058: ROLLBACK TO SAVEPOINT replace_attributes;
3059:
3060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3061:
3062: OE_GLOBALS.G_UI_FLAG := FALSE;
3063:
3064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3061:
3062: OE_GLOBALS.G_UI_FLAG := FALSE;
3063:
3064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3065:
3066: -- Get message count and data
3067:
3068: OE_MSG_PUB.Count_And_Get
3075: WHEN OTHERS THEN
3076:
3077: OE_GLOBALS.G_UI_FLAG := FALSE;
3078:
3079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3080:
3081: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3082: THEN
3083: OE_MSG_PUB.Add_Exc_Msg
3138: ( x_return_status => l_return_status
3139: , p_x_line_adj_rec => l_x_line_adj_rec
3140: );
3141:
3142: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3143:
3144: -- Set DB flag and write record to cache.
3145: l_x_Line_Adj_rec.db_flag := FND_API.G_TRUE;
3146:
3141:
3142: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3143:
3144: -- Set DB flag and write record to cache.
3145: l_x_Line_Adj_rec.db_flag := FND_API.G_TRUE;
3146:
3147: Write_Line_Adj
3148: ( p_Line_Adj_rec => l_x_Line_Adj_rec
3149: , p_db_record => TRUE
3177: , 'Lock_Row'
3178: );
3179: END IF;
3180:
3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182:
3183: -- Get message count and data
3184:
3185: OE_MSG_PUB.Count_And_Get
3248: ( p_price_adjustment_id => p_price_adjustment_id
3249: , x_Line_Adj_rec => g_Line_Adj_rec
3250: );
3251:
3252: g_Line_Adj_rec.db_flag := FND_API.G_TRUE;
3253:
3254: -- Load DB record
3255:
3256: g_db_Line_Adj_rec := g_Line_Adj_rec;
3367:
3368:
3369: IF l_line_adj_tbl(1).range_break_quantity IS NULL
3370: AND l_line_adj_tbl(1).list_line_type_code = 'PBH'
3371: AND nvl(l_Line_Adj_Tbl(1).list_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
3372: THEN
3373:
3374: IF l_line_adj_tbl(1).UPDATED_FLAG IS NULL THEN
3375: l_line_adj_tbl(1).UPDATED_FLAG := 'Y';
3410: INTO l_line_adj_tbl(1).price_adjustment_id
3411: FROM Dual;
3412:
3413:
3414: Oe_Order_Adj_Pvt.Line_Adjs(p_validation_level => FND_API.G_VALID_LEVEL_NONE,
3415: p_control_rec => l_control_rec,
3416: p_x_line_adj_tbl => l_line_adj_tbl,
3417: p_x_old_line_adj_tbl => l_dummy_tbl);
3418: x_price_adjustment_id := l_line_adj_tbl(1).price_adjustment_id;
3420: -- lagrawal bug 3673050
3421: OE_GLOBALS.G_UI_FLAG := FALSE;
3422: Exception
3423: --Start for bug 12907745
3424: WHEN FND_API.G_EXC_ERROR THEN
3425:
3426: OE_GLOBALS.G_UI_FLAG := FALSE;
3427: oe_debug_pub.add( 'IN FND_API.G_EXC_ERROR');
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3423: --Start for bug 12907745
3424: WHEN FND_API.G_EXC_ERROR THEN
3425:
3426: OE_GLOBALS.G_UI_FLAG := FALSE;
3427: oe_debug_pub.add( 'IN FND_API.G_EXC_ERROR');
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429: -- Get message count and data
3430: OE_MSG_PUB.Count_And_Get
3431: ( p_count => x_msg_count
3424: WHEN FND_API.G_EXC_ERROR THEN
3425:
3426: OE_GLOBALS.G_UI_FLAG := FALSE;
3427: oe_debug_pub.add( 'IN FND_API.G_EXC_ERROR');
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429: -- Get message count and data
3430: OE_MSG_PUB.Count_And_Get
3431: ( p_count => x_msg_count
3432: , p_data => x_msg_data
3436: WHEN OTHERS THEN
3437:
3438: OE_GLOBALS.G_UI_FLAG := FALSE;
3439:
3440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3441:
3442: OE_MSG_PUB.Add_Exc_Msg
3443: ( G_PKG_NAME
3444: , 'Oe_Oe_Form_Line_Adj.Insert_Row:'||SQLERRM
3558: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3559: --
3560: Begin
3561:
3562: If nvl(p_parent_adj_rec.operand,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
3563: IF l_debug_level > 0 THEN
3564: oe_debug_pub.add( ' CS PARENT OPERAND IS NULL' ) ;
3565: END IF;
3566: Return;