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

APPS.OE_OE_FORM_HEADER_ADJ dependencies on FND_API

Line 325: ( p_init_msg_list => FND_API.G_TRUE

321: l_x_old_Header_Adj_tbl(1) := l_x_old_Header_Adj_rec;
322:
323: -- Call Oe_Order_Adj_Pvt.Header_Adj
324: oe_order_adj_pvt.Header_Adjs
325: ( p_init_msg_list => FND_API.G_TRUE
326: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
327: , p_control_rec => l_control_rec
328: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
329: , p_x_old_header_adj_tbl => l_x_old_Header_Adj_tbl

Line 326: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

322:
323: -- Call Oe_Order_Adj_Pvt.Header_Adj
324: oe_order_adj_pvt.Header_Adjs
325: ( p_init_msg_list => FND_API.G_TRUE
326: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
327: , p_control_rec => l_control_rec
328: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
329: , p_x_old_header_adj_tbl => l_x_old_Header_Adj_tbl
330: );

Line 339: , p_init_msg_list => FND_API.G_TRUE

335:
336: -- Call OE_Order_PVT.Process_order
337: OE_Order_PVT.Process_order
338: ( p_api_version_number => 1.0
339: , p_init_msg_list => FND_API.G_TRUE
340: , x_return_status => l_return_status
341: , x_msg_count => x_msg_count
342: , x_msg_data => x_msg_data
343: , p_control_rec => l_control_rec

Line 366: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

362: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
363: , x_action_request_tbl => l_action_request_tbl
364: );
365:
366: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363: , x_action_request_tbl => l_action_request_tbl
364: );
365:
366: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371: ******************************************************************/

Line 368: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

364: );
365:
366: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371: ******************************************************************/
372:

Line 369: RAISE FND_API.G_EXC_ERROR;

365:
366: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371: ******************************************************************/
372:
373: -- Unload out tbl

Line 376: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

372:
373: -- Unload out tbl
374: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
375:
376: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373: -- Unload out tbl
374: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
375:
376: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381:

Line 378: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN

374: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
375:
376: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381:
382: -- Load OUT parameters.

Line 379: RAISE FND_API.G_EXC_ERROR;

375:
376: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381:
382: -- Load OUT parameters.
383: x_price_adjustment_id := l_x_Header_Adj_rec.price_adjustment_id;

Line 469: l_x_Header_Adj_rec.db_flag := FND_API.G_FALSE;

465: x_discount := l_Header_Adj_val_rec.discount;
466:
467: -- Write to cache.
468: -- Set db_flag to False before writing to cache
469: l_x_Header_Adj_rec.db_flag := FND_API.G_FALSE;
470:
471: Write_Header_Adj
472: ( p_Header_Adj_rec => l_x_Header_Adj_rec
473: );

Line 480: x_return_status := FND_API.G_RET_STS_SUCCESS;

476: -- Re-set the UI flag to FALSE
477: OE_GLOBALS.G_UI_FLAG := FALSE;
478:
479: -- Set return status.
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481:
482:
483: -- Get message count and data
484: OE_MSG_PUB.Count_And_Get

Line 492: WHEN FND_API.G_EXC_ERROR THEN

488:
489:
490: EXCEPTION
491:
492: WHEN FND_API.G_EXC_ERROR THEN
493:
494: OE_GLOBALS.G_UI_FLAG := FALSE;
495:
496: x_return_status := FND_API.G_RET_STS_ERROR;

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: WHEN FND_API.G_EXC_ERROR THEN
493:
494: OE_GLOBALS.G_UI_FLAG := FALSE;
495:
496: x_return_status := FND_API.G_RET_STS_ERROR;
497:
498: -- Get message count and data
499:
500: OE_MSG_PUB.Count_And_Get

Line 505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

501: ( p_count => x_msg_count
502: , p_data => x_msg_data
503: );
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506:
507: OE_GLOBALS.G_UI_FLAG := FALSE;
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506:
507: OE_GLOBALS.G_UI_FLAG := FALSE;
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
510:
511: -- Get message count and data
512:
513: OE_MSG_PUB.Count_And_Get

Line 522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

518: WHEN OTHERS THEN
519:
520: OE_GLOBALS.G_UI_FLAG := FALSE;
521:
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
523:
524: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
525: THEN
526: OE_MSG_PUB.Add_Exc_Msg

Line 554: , p_attr_value2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

550:
551: , p_price_adjustment_id IN NUMBER
552: , p_attr_id IN NUMBER
553: , p_attr_value1 IN VARCHAR2
554: , p_attr_value2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
555: , p_context IN VARCHAR2
556: , p_attribute1 IN VARCHAR2
557: , p_attribute2 IN VARCHAR2
558: , p_attribute3 IN VARCHAR2

Line 1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1025: , 'Unrecognized attribute:'||p_attr_id
1026: );
1027: END IF;
1028:
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030:
1031: END IF;
1032: stmt:=10;
1033:

Line 1035: IF FND_API.To_Boolean(l_x_Header_Adj_rec.db_flag) THEN

1031: END IF;
1032: stmt:=10;
1033:
1034: -- Set Operation.
1035: IF FND_API.To_Boolean(l_x_Header_Adj_rec.db_flag) THEN
1036: l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1037: ELSE
1038: l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1039: END IF;

Line 1068: ( p_init_msg_list => FND_API.G_TRUE

1064: -- Call Oe_Order_Adj_Pvt.Header_Adj
1065: l_Header_Adj_rec := l_x_Header_Adj_rec;
1066: stmt:=15;
1067: oe_order_adj_pvt.Header_Adjs
1068: ( p_init_msg_list => FND_API.G_TRUE
1069: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1070: , p_control_rec => l_control_rec
1071: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
1072: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl

Line 1069: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1065: l_Header_Adj_rec := l_x_Header_Adj_rec;
1066: stmt:=15;
1067: oe_order_adj_pvt.Header_Adjs
1068: ( p_init_msg_list => FND_API.G_TRUE
1069: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1070: , p_control_rec => l_control_rec
1071: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
1072: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl
1073: );

Line 1079: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1075: -- Unload out tbl
1076: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
1077:
1078: stmt:=20;
1079: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;

Line 1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1076: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
1077:
1078: stmt:=20;
1079: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084: stmt:=25;

Line 1081: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1077:
1078: stmt:=20;
1079: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084: stmt:=25;
1085: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: stmt:=20;
1079: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084: stmt:=25;
1085: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1086: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE

Line 1087: ,p_delete => FND_API.G_TRUE

1083: END IF;
1084: stmt:=25;
1085: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1086: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1087: ,p_delete => FND_API.G_TRUE
1088: ,x_return_status => l_return_status
1089: );
1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1086: (p_request_type => OE_GLOBALS.G_CHECK_DUPLICATE
1087: ,p_delete => FND_API.G_TRUE
1088: ,x_return_status => l_return_status
1089: );
1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1087: ,p_delete => FND_API.G_TRUE
1088: ,x_return_status => l_return_status
1089: );
1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:

Line 1092: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1088: ,x_return_status => l_return_status
1089: );
1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:
1096: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 1093: RAISE FND_API.G_EXC_ERROR;

1089: );
1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:
1096: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1097: (p_request_type => OE_GLOBALS.G_CHECK_FIXED_PRICE

Line 1098: ,p_delete => FND_API.G_TRUE

1094: END IF;
1095:
1096: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1097: (p_request_type => OE_GLOBALS.G_CHECK_FIXED_PRICE
1098: ,p_delete => FND_API.G_TRUE
1099: ,x_return_status => l_return_status
1100: );
1101: IF p_enforce_fixed_price = 'YES' THEN
1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1098: ,p_delete => FND_API.G_TRUE
1099: ,x_return_status => l_return_status
1100: );
1101: IF p_enforce_fixed_price = 'YES' THEN
1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1099: ,x_return_status => l_return_status
1100: );
1101: IF p_enforce_fixed_price = 'YES' THEN
1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: ELSE

Line 1104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1100: );
1101: IF p_enforce_fixed_price = 'YES' THEN
1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: ELSE
1108: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1105: RAISE FND_API.G_EXC_ERROR;

1101: IF p_enforce_fixed_price = 'YES' THEN
1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: ELSE
1108: l_return_status := FND_API.G_RET_STS_SUCCESS;
1109: END IF;

Line 1108: l_return_status := FND_API.G_RET_STS_SUCCESS;

1104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: ELSE
1108: l_return_status := FND_API.G_RET_STS_SUCCESS;
1109: END IF;
1110:
1111:
1112: stmt:=30;

Line 1115: x_price_adjustment_id := FND_API.G_MISS_NUM;

1111:
1112: stmt:=30;
1113: -- Init OUT parameters to missing.
1114:
1115: x_price_adjustment_id := FND_API.G_MISS_NUM;
1116: x_header_id := FND_API.G_MISS_NUM;
1117: x_discount_id := FND_API.G_MISS_NUM;
1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;

Line 1116: x_header_id := FND_API.G_MISS_NUM;

1112: stmt:=30;
1113: -- Init OUT parameters to missing.
1114:
1115: x_price_adjustment_id := FND_API.G_MISS_NUM;
1116: x_header_id := FND_API.G_MISS_NUM;
1117: x_discount_id := FND_API.G_MISS_NUM;
1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;

Line 1117: x_discount_id := FND_API.G_MISS_NUM;

1113: -- Init OUT parameters to missing.
1114:
1115: x_price_adjustment_id := FND_API.G_MISS_NUM;
1116: x_header_id := FND_API.G_MISS_NUM;
1117: x_discount_id := FND_API.G_MISS_NUM;
1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;

Line 1118: x_discount := FND_API.G_MISS_CHAR;

1114:
1115: x_price_adjustment_id := FND_API.G_MISS_NUM;
1116: x_header_id := FND_API.G_MISS_NUM;
1117: x_discount_id := FND_API.G_MISS_NUM;
1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;

Line 1119: x_discount_line_id := FND_API.G_MISS_NUM;

1115: x_price_adjustment_id := FND_API.G_MISS_NUM;
1116: x_header_id := FND_API.G_MISS_NUM;
1117: x_discount_id := FND_API.G_MISS_NUM;
1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;

Line 1120: x_automatic_flag := FND_API.G_MISS_CHAR;

1116: x_header_id := FND_API.G_MISS_NUM;
1117: x_discount_id := FND_API.G_MISS_NUM;
1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;

Line 1121: x_percent := FND_API.G_MISS_NUM;

1117: x_discount_id := FND_API.G_MISS_NUM;
1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;

Line 1122: x_line_id := FND_API.G_MISS_NUM;

1118: x_discount := FND_API.G_MISS_CHAR;
1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;

Line 1123: x_context := FND_API.G_MISS_CHAR;

1119: x_discount_line_id := FND_API.G_MISS_NUM;
1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;

Line 1124: x_attribute1 := FND_API.G_MISS_CHAR;

1120: x_automatic_flag := FND_API.G_MISS_CHAR;
1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;

Line 1125: x_attribute2 := FND_API.G_MISS_CHAR;

1121: x_percent := FND_API.G_MISS_NUM;
1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;

Line 1126: x_attribute3 := FND_API.G_MISS_CHAR;

1122: x_line_id := FND_API.G_MISS_NUM;
1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;

Line 1127: x_attribute4 := FND_API.G_MISS_CHAR;

1123: x_context := FND_API.G_MISS_CHAR;
1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;

Line 1128: x_attribute5 := FND_API.G_MISS_CHAR;

1124: x_attribute1 := FND_API.G_MISS_CHAR;
1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;

Line 1129: x_attribute6 := FND_API.G_MISS_CHAR;

1125: x_attribute2 := FND_API.G_MISS_CHAR;
1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;

Line 1130: x_attribute7 := FND_API.G_MISS_CHAR;

1126: x_attribute3 := FND_API.G_MISS_CHAR;
1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;

Line 1131: x_attribute8 := FND_API.G_MISS_CHAR;

1127: x_attribute4 := FND_API.G_MISS_CHAR;
1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;

Line 1132: x_attribute9 := FND_API.G_MISS_CHAR;

1128: x_attribute5 := FND_API.G_MISS_CHAR;
1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;

Line 1133: x_attribute10 := FND_API.G_MISS_CHAR;

1129: x_attribute6 := FND_API.G_MISS_CHAR;
1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;

Line 1134: x_attribute11 := FND_API.G_MISS_CHAR;

1130: x_attribute7 := FND_API.G_MISS_CHAR;
1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;

Line 1135: x_attribute12 := FND_API.G_MISS_CHAR;

1131: x_attribute8 := FND_API.G_MISS_CHAR;
1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;

Line 1136: x_attribute13 := FND_API.G_MISS_CHAR;

1132: x_attribute9 := FND_API.G_MISS_CHAR;
1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;

Line 1137: x_attribute14 := FND_API.G_MISS_CHAR;

1133: x_attribute10 := FND_API.G_MISS_CHAR;
1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;

Line 1138: x_attribute15 := FND_API.G_MISS_CHAR;

1134: x_attribute11 := FND_API.G_MISS_CHAR;
1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;

Line 1139: x_ac_context := FND_API.G_MISS_CHAR;

1135: x_attribute12 := FND_API.G_MISS_CHAR;
1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;

Line 1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;

1136: x_attribute13 := FND_API.G_MISS_CHAR;
1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;

Line 1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;

1137: x_attribute14 := FND_API.G_MISS_CHAR;
1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;

Line 1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;

1138: x_attribute15 := FND_API.G_MISS_CHAR;
1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;

Line 1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;

1139: x_ac_context := FND_API.G_MISS_CHAR;
1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;

Line 1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;

1140: x_ac_attribute1 := FND_API.G_MISS_CHAR;
1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;

Line 1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;

1141: x_ac_attribute2 := FND_API.G_MISS_CHAR;
1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;

Line 1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;

1142: x_ac_attribute3 := FND_API.G_MISS_CHAR;
1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;

Line 1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;

1143: x_ac_attribute4 := FND_API.G_MISS_CHAR;
1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;

Line 1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;

1144: x_ac_attribute5 := FND_API.G_MISS_CHAR;
1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;

Line 1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;

1145: x_ac_attribute6 := FND_API.G_MISS_CHAR;
1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1153: x_ac_attribute14 := FND_API.G_MISS_CHAR;

Line 1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;

1146: x_ac_attribute7 := FND_API.G_MISS_CHAR;
1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1153: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1154: x_ac_attribute15 := FND_API.G_MISS_CHAR;

Line 1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;

1147: x_ac_attribute8 := FND_API.G_MISS_CHAR;
1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1153: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1154: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1155:

Line 1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;

1148: x_ac_attribute9 := FND_API.G_MISS_CHAR;
1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1153: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1154: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1155:
1156: stmt:=35;

Line 1153: x_ac_attribute14 := FND_API.G_MISS_CHAR;

1149: x_ac_attribute10 := FND_API.G_MISS_CHAR;
1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1153: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1154: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1155:
1156: stmt:=35;
1157: -- New columns names added

Line 1154: x_ac_attribute15 := FND_API.G_MISS_CHAR;

1150: x_ac_attribute11 := FND_API.G_MISS_CHAR;
1151: x_ac_attribute12 := FND_API.G_MISS_CHAR;
1152: x_ac_attribute13 := FND_API.G_MISS_CHAR;
1153: x_ac_attribute14 := FND_API.G_MISS_CHAR;
1154: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1155:
1156: stmt:=35;
1157: -- New columns names added
1158: x_list_header_id := FND_API.G_MISS_NUM;

Line 1158: x_list_header_id := FND_API.G_MISS_NUM;

1154: x_ac_attribute15 := FND_API.G_MISS_CHAR;
1155:
1156: stmt:=35;
1157: -- New columns names added
1158: x_list_header_id := FND_API.G_MISS_NUM;
1159: x_list_line_id := FND_API.G_MISS_NUM;
1160: x_list_line_type_code := FND_API.G_MISS_CHAR;
1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;

Line 1159: x_list_line_id := FND_API.G_MISS_NUM;

1155:
1156: stmt:=35;
1157: -- New columns names added
1158: x_list_header_id := FND_API.G_MISS_NUM;
1159: x_list_line_id := FND_API.G_MISS_NUM;
1160: x_list_line_type_code := FND_API.G_MISS_CHAR;
1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;

Line 1160: x_list_line_type_code := FND_API.G_MISS_CHAR;

1156: stmt:=35;
1157: -- New columns names added
1158: x_list_header_id := FND_API.G_MISS_NUM;
1159: x_list_line_id := FND_API.G_MISS_NUM;
1160: x_list_line_type_code := FND_API.G_MISS_CHAR;
1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;

Line 1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;

1157: -- New columns names added
1158: x_list_header_id := FND_API.G_MISS_NUM;
1159: x_list_line_id := FND_API.G_MISS_NUM;
1160: x_list_line_type_code := FND_API.G_MISS_CHAR;
1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;

Line 1162: x_modified_from := FND_API.G_MISS_CHAR;

1158: x_list_header_id := FND_API.G_MISS_NUM;
1159: x_list_line_id := FND_API.G_MISS_NUM;
1160: x_list_line_type_code := FND_API.G_MISS_CHAR;
1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;

Line 1163: x_modified_to := FND_API.G_MISS_CHAR;

1159: x_list_line_id := FND_API.G_MISS_NUM;
1160: x_list_line_type_code := FND_API.G_MISS_CHAR;
1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;

Line 1164: x_update_allowed := FND_API.G_MISS_CHAR;

1160: x_list_line_type_code := FND_API.G_MISS_CHAR;
1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;
1168: x_change_reason_text := FND_API.G_MISS_CHAR;

Line 1165: x_updated_flag := FND_API.G_MISS_CHAR;

1161: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;
1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;
1168: x_change_reason_text := FND_API.G_MISS_CHAR;
1169: x_operand := FND_API.G_MISS_NUM;

Line 1166: x_applied_flag := FND_API.G_MISS_CHAR;

1162: x_modified_from := FND_API.G_MISS_CHAR;
1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;
1168: x_change_reason_text := FND_API.G_MISS_CHAR;
1169: x_operand := FND_API.G_MISS_NUM;
1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;

Line 1167: x_change_reason_code := FND_API.G_MISS_CHAR;

1163: x_modified_to := FND_API.G_MISS_CHAR;
1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;
1168: x_change_reason_text := FND_API.G_MISS_CHAR;
1169: x_operand := FND_API.G_MISS_NUM;
1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1171:

Line 1168: x_change_reason_text := FND_API.G_MISS_CHAR;

1164: x_update_allowed := FND_API.G_MISS_CHAR;
1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;
1168: x_change_reason_text := FND_API.G_MISS_CHAR;
1169: x_operand := FND_API.G_MISS_NUM;
1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1171:
1172: x_adjusted_amount := FND_API.G_MISS_NUM;

Line 1169: x_operand := FND_API.G_MISS_NUM;

1165: x_updated_flag := FND_API.G_MISS_CHAR;
1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;
1168: x_change_reason_text := FND_API.G_MISS_CHAR;
1169: x_operand := FND_API.G_MISS_NUM;
1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1171:
1172: x_adjusted_amount := FND_API.G_MISS_NUM;
1173: x_pricing_phase_id := FND_API.G_MISS_NUM;

Line 1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;

1166: x_applied_flag := FND_API.G_MISS_CHAR;
1167: x_change_reason_code := FND_API.G_MISS_CHAR;
1168: x_change_reason_text := FND_API.G_MISS_CHAR;
1169: x_operand := FND_API.G_MISS_NUM;
1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1171:
1172: x_adjusted_amount := FND_API.G_MISS_NUM;
1173: x_pricing_phase_id := FND_API.G_MISS_NUM;
1174: x_list_line_no := FND_API.G_MISS_CHAR;

Line 1172: x_adjusted_amount := FND_API.G_MISS_NUM;

1168: x_change_reason_text := FND_API.G_MISS_CHAR;
1169: x_operand := FND_API.G_MISS_NUM;
1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1171:
1172: x_adjusted_amount := FND_API.G_MISS_NUM;
1173: x_pricing_phase_id := FND_API.G_MISS_NUM;
1174: x_list_line_no := FND_API.G_MISS_CHAR;
1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;

Line 1173: x_pricing_phase_id := FND_API.G_MISS_NUM;

1169: x_operand := FND_API.G_MISS_NUM;
1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1171:
1172: x_adjusted_amount := FND_API.G_MISS_NUM;
1173: x_pricing_phase_id := FND_API.G_MISS_NUM;
1174: x_list_line_no := FND_API.G_MISS_CHAR;
1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;

Line 1174: x_list_line_no := FND_API.G_MISS_CHAR;

1170: x_arithmetic_operator := FND_API.G_MISS_CHAR;
1171:
1172: x_adjusted_amount := FND_API.G_MISS_NUM;
1173: x_pricing_phase_id := FND_API.G_MISS_NUM;
1174: x_list_line_no := FND_API.G_MISS_CHAR;
1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;

Line 1175: x_source_system_code := FND_API.G_MISS_CHAR;

1171:
1172: x_adjusted_amount := FND_API.G_MISS_NUM;
1173: x_pricing_phase_id := FND_API.G_MISS_NUM;
1174: x_list_line_no := FND_API.G_MISS_CHAR;
1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;

Line 1176: x_benefit_qty := FND_API.G_MISS_NUM;

1172: x_adjusted_amount := FND_API.G_MISS_NUM;
1173: x_pricing_phase_id := FND_API.G_MISS_NUM;
1174: x_list_line_no := FND_API.G_MISS_CHAR;
1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;

Line 1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;

1173: x_pricing_phase_id := FND_API.G_MISS_NUM;
1174: x_list_line_no := FND_API.G_MISS_CHAR;
1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;

Line 1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;

1174: x_list_line_no := FND_API.G_MISS_CHAR;
1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;

Line 1179: x_expiration_date := FND_API.G_MISS_DATE;

1175: x_source_system_code := FND_API.G_MISS_CHAR;
1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;

Line 1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;

1176: x_benefit_qty := FND_API.G_MISS_NUM;
1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;

Line 1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;

1177: x_benefit_uom_code := FND_API.G_MISS_CHAR;
1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;

Line 1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;

1178: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;

Line 1183: x_redeemed_date := FND_API.G_MISS_DATE;

1179: x_expiration_date := FND_API.G_MISS_DATE;
1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;

Line 1184: x_redeemed_flag := FND_API.G_MISS_CHAR;

1180: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;
1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;

Line 1185: x_accrual_flag := FND_API.G_MISS_CHAR;

1181: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;
1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;

Line 1186: x_invoiced_flag := FND_API.G_MISS_CHAR;

1182: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;
1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1190: x_charge_type_code := FND_API.G_MISS_CHAR;

Line 1187: x_estimated_flag := FND_API.G_MISS_CHAR;

1183: x_redeemed_date := FND_API.G_MISS_DATE;
1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1190: x_charge_type_code := FND_API.G_MISS_CHAR;
1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;

Line 1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;

1184: x_redeemed_flag := FND_API.G_MISS_CHAR;
1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1190: x_charge_type_code := FND_API.G_MISS_CHAR;
1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1192:

Line 1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;

1185: x_accrual_flag := FND_API.G_MISS_CHAR;
1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1190: x_charge_type_code := FND_API.G_MISS_CHAR;
1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1192:
1193: --uom begin

Line 1190: x_charge_type_code := FND_API.G_MISS_CHAR;

1186: x_invoiced_flag := FND_API.G_MISS_CHAR;
1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1190: x_charge_type_code := FND_API.G_MISS_CHAR;
1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1192:
1193: --uom begin
1194: x_operand_per_pqty := FND_API.G_MISS_NUM;

Line 1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;

1187: x_estimated_flag := FND_API.G_MISS_CHAR;
1188: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;
1189: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
1190: x_charge_type_code := FND_API.G_MISS_CHAR;
1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1192:
1193: --uom begin
1194: x_operand_per_pqty := FND_API.G_MISS_NUM;
1195: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;

Line 1194: x_operand_per_pqty := FND_API.G_MISS_NUM;

1190: x_charge_type_code := FND_API.G_MISS_CHAR;
1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1192:
1193: --uom begin
1194: x_operand_per_pqty := FND_API.G_MISS_NUM;
1195: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1196: --uom end
1197:
1198: -- Load display out parameters if any

Line 1195: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;

1191: x_charge_subtype_code := FND_API.G_MISS_CHAR;
1192:
1193: --uom begin
1194: x_operand_per_pqty := FND_API.G_MISS_NUM;
1195: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;
1196: --uom end
1197:
1198: -- Load display out parameters if any
1199: stmt:=40;

Line 1660: x_return_status := FND_API.G_RET_STS_SUCCESS;

1656: -- Re-set the UI flag to FALSE
1657: OE_GLOBALS.G_UI_FLAG := FALSE;
1658:
1659: -- Set return status.
1660: x_return_status := FND_API.G_RET_STS_SUCCESS;
1661:
1662:
1663: -- Get message count and data
1664: OE_MSG_PUB.Count_And_Get

Line 1675: WHEN FND_API.G_EXC_ERROR THEN

1671: END IF;
1672:
1673: EXCEPTION
1674:
1675: WHEN FND_API.G_EXC_ERROR THEN
1676:
1677: OE_GLOBALS.G_UI_FLAG := FALSE;
1678:
1679: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1679: x_return_status := FND_API.G_RET_STS_ERROR;

1675: WHEN FND_API.G_EXC_ERROR THEN
1676:
1677: OE_GLOBALS.G_UI_FLAG := FALSE;
1678:
1679: x_return_status := FND_API.G_RET_STS_ERROR;
1680:
1681: -- Get message count and data
1682:
1683: /* Msg is commented out nocopy for the bug #2485694 */

Line 1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1700: oe_debug_pub.add( 'STMT:'||STMT ) ;
1701: END IF;
1702: ROLLBACK TO SAVEPOINT change_attributes;
1703:
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705: IF l_debug_level > 0 THEN
1706: oe_debug_pub.add( 'STMT:'||STMT ) ;
1707: END IF;
1708: OE_GLOBALS.G_UI_FLAG := FALSE;

Line 1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1706: oe_debug_pub.add( 'STMT:'||STMT ) ;
1707: END IF;
1708: OE_GLOBALS.G_UI_FLAG := FALSE;
1709:
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1711:
1712: -- Get message count and data
1713: IF l_debug_level > 0 THEN
1714: oe_debug_pub.add( 'STMT:'||STMT ) ;

Line 1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1727: WHEN OTHERS THEN
1728:
1729: OE_GLOBALS.G_UI_FLAG := FALSE;
1730:
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1732:
1733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: OE_MSG_PUB.Add_Exc_Msg

Line 1827: x_return_status := FND_API.G_RET_STS_SUCCESS;

1823: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1824: --
1825: BEGIN
1826: --3340264{
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;
1828: --3340264}
1829: IF l_debug_level > 0 THEN
1830: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_ADJ.VALIDATE_AND_WRITE' , 1 ) ;
1831: END IF;

Line 1874: IF(l_x_Header_Adj_rec.db_flag= FND_API.G_MISS_CHAR) THEN

1870: );
1871:
1872: -- Set Operation.
1873: --3340264{
1874: IF(l_x_Header_Adj_rec.db_flag= FND_API.G_MISS_CHAR) THEN
1875: return;
1876: ELSE
1877: IF FND_API.To_Boolean(l_x_Header_Adj_rec.db_flag) THEN
1878: l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line 1877: IF FND_API.To_Boolean(l_x_Header_Adj_rec.db_flag) THEN

1873: --3340264{
1874: IF(l_x_Header_Adj_rec.db_flag= FND_API.G_MISS_CHAR) THEN
1875: return;
1876: ELSE
1877: IF FND_API.To_Boolean(l_x_Header_Adj_rec.db_flag) THEN
1878: l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1879: ELSE
1880: l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1881: END IF;

Line 1891: ( p_init_msg_list => FND_API.G_TRUE

1887: l_x_old_Header_Adj_tbl(1) := l_x_old_Header_Adj_rec;
1888:
1889: -- Call Oe_Order_Adj_Pvt.Header_Adj
1890: oe_order_adj_pvt.Header_Adjs
1891: ( p_init_msg_list => FND_API.G_TRUE
1892: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1893: , p_control_rec => l_control_rec
1894: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
1895: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl

Line 1892: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1888:
1889: -- Call Oe_Order_Adj_Pvt.Header_Adj
1890: oe_order_adj_pvt.Header_Adjs
1891: ( p_init_msg_list => FND_API.G_TRUE
1892: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1893: , p_control_rec => l_control_rec
1894: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
1895: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl
1896: );

Line 1904: , p_init_msg_list => FND_API.G_TRUE

1900:
1901: -- Call OE_Order_PVT.Process_order
1902: OE_Order_PVT.Process_order
1903: ( p_api_version_number => 1.0
1904: , p_init_msg_list => FND_API.G_TRUE
1905: , x_return_status => l_return_status
1906: , x_msg_count => x_msg_count
1907: , x_msg_data => x_msg_data
1908: , p_control_rec => l_control_rec

Line 1933: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1929: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
1930: , x_action_request_tbl => l_action_request_tbl
1931: );
1932:
1933: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;

Line 1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1930: , x_action_request_tbl => l_action_request_tbl
1931: );
1932:
1933: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938: **********************************************************/

Line 1935: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1931: );
1932:
1933: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938: **********************************************************/
1939:

Line 1936: RAISE FND_API.G_EXC_ERROR;

1932:
1933: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938: **********************************************************/
1939:
1940: -- Load OUT parameters.

Line 1943: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1939:
1940: -- Load OUT parameters.
1941: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
1942:
1943: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;

Line 1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1940: -- Load OUT parameters.
1941: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
1942:
1943: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:

Line 1945: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1941: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
1942:
1943: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: /*******

Line 1946: RAISE FND_API.G_EXC_ERROR;

1942:
1943: IF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: ELSIF l_x_header_adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: /*******
1950: Oe_Order_Pvt.Process_Requests_And_Notify

Line 1958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1954: , p_old_header_adj_tbl => l_x_old_header_adj_tbl
1955: , x_return_status => l_return_status
1956: );
1957:
1958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;

Line 1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1955: , x_return_status => l_return_status
1956: );
1957:
1958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963: *******/

Line 1960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1956: );
1957:
1958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963: *******/
1964:

Line 1961: RAISE FND_API.G_EXC_ERROR;

1957:
1958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963: *******/
1964:
1965: x_lock_control := l_x_Header_Adj_rec.lock_control;

Line 1969: ,p_delete => FND_API.G_TRUE

1965: x_lock_control := l_x_Header_Adj_rec.lock_control;
1966:
1967: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1968: (p_request_type => OE_GLOBALS.G_CHECK_PERCENTAGE
1969: ,p_delete => FND_API.G_TRUE
1970: ,x_return_status => l_return_status
1971: );
1972: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1972: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1968: (p_request_type => OE_GLOBALS.G_CHECK_PERCENTAGE
1969: ,p_delete => FND_API.G_TRUE
1970: ,x_return_status => l_return_status
1971: );
1972: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;

Line 1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1969: ,p_delete => FND_API.G_TRUE
1970: ,x_return_status => l_return_status
1971: );
1972: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:

Line 1974: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1970: ,x_return_status => l_return_status
1971: );
1972: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978: --TaxER start

Line 1975: RAISE FND_API.G_EXC_ERROR;

1971: );
1972: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978: --TaxER start
1979: IF nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN

Line 1982: ,p_delete => FND_API.G_TRUE

1978: --TaxER start
1979: IF nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN
1980: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1981: (p_request_type => OE_GLOBALS.G_TAX_LINE
1982: ,p_delete => FND_API.G_TRUE
1983: ,x_return_status => l_return_status
1984: );
1985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1981: (p_request_type => OE_GLOBALS.G_TAX_LINE
1982: ,p_delete => FND_API.G_TRUE
1983: ,x_return_status => l_return_status
1984: );
1985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;

Line 1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1982: ,p_delete => FND_API.G_TRUE
1983: ,x_return_status => l_return_status
1984: );
1985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;
1990: END IF;

Line 1987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1983: ,x_return_status => l_return_status
1984: );
1985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;
1990: END IF;
1991: --TaxER end

Line 1988: RAISE FND_API.G_EXC_ERROR;

1984: );
1985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1988: RAISE FND_API.G_EXC_ERROR;
1989: END IF;
1990: END IF;
1991: --TaxER end
1992:

Line 1996: ,p_delete => FND_API.G_TRUE

1992:
1993: -- fixed bug 3271297
1994: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1995: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
1996: ,p_delete => FND_API.G_TRUE
1997: ,x_return_status => l_return_status
1998: );
1999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1995: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
1996: ,p_delete => FND_API.G_TRUE
1997: ,x_return_status => l_return_status
1998: );
1999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;

Line 2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1996: ,p_delete => FND_API.G_TRUE
1997: ,x_return_status => l_return_status
1998: );
1999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:

Line 2001: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1997: ,x_return_status => l_return_status
1998: );
1999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005: /*****

Line 2002: RAISE FND_API.G_EXC_ERROR;

1998: );
1999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005: /*****
2006: IF p_ok_flag = 'Y' THEN

Line 2009: ,p_delete => FND_API.G_TRUE

2005: /*****
2006: IF p_ok_flag = 'Y' THEN
2007: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2008: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2009: ,p_delete => FND_API.G_TRUE
2010: ,x_return_status => l_return_status
2011: );
2012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2008: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2009: ,p_delete => FND_API.G_TRUE
2010: ,x_return_status => l_return_status
2011: );
2012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;

Line 2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2009: ,p_delete => FND_API.G_TRUE
2010: ,x_return_status => l_return_status
2011: );
2012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017: END IF;

Line 2014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2010: ,x_return_status => l_return_status
2011: );
2012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017: END IF;
2018: ******/

Line 2015: RAISE FND_API.G_EXC_ERROR;

2011: );
2012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017: END IF;
2018: ******/
2019:

Line 2039: x_return_status := FND_API.G_RET_STS_SUCCESS;

2035: -- Re-set the UI flag to FALSE
2036: OE_GLOBALS.G_UI_FLAG := FALSE;
2037:
2038: -- Set return status.
2039: x_return_status := FND_API.G_RET_STS_SUCCESS;
2040:
2041:
2042: -- Get message count and data
2043: OE_MSG_PUB.Count_And_Get

Line 2054: WHEN FND_API.G_EXC_ERROR THEN

2050: END IF;
2051:
2052: EXCEPTION
2053:
2054: WHEN FND_API.G_EXC_ERROR THEN
2055:
2056: OE_GLOBALS.G_UI_FLAG := FALSE;
2057:
2058: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2058: x_return_status := FND_API.G_RET_STS_ERROR;

2054: WHEN FND_API.G_EXC_ERROR THEN
2055:
2056: OE_GLOBALS.G_UI_FLAG := FALSE;
2057:
2058: x_return_status := FND_API.G_RET_STS_ERROR;
2059:
2060: -- Get message count and data
2061:
2062: OE_MSG_PUB.Count_And_Get

Line 2069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2065: );
2066:
2067: ROLLBACK TO SAVEPOINT validate_and_write;
2068:
2069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2070:
2071: OE_GLOBALS.G_UI_FLAG := FALSE;
2072:
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2070:
2071: OE_GLOBALS.G_UI_FLAG := FALSE;
2072:
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2074:
2075: -- Get message count and data
2076:
2077: OE_MSG_PUB.Count_And_Get

Line 2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2084: WHEN OTHERS THEN
2085:
2086: OE_GLOBALS.G_UI_FLAG := FALSE;
2087:
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2089:
2090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2091: THEN
2092: OE_MSG_PUB.Add_Exc_Msg

Line 2205: ( p_init_msg_list => FND_API.G_TRUE

2201: l_x_Header_Adj_tbl(1).change_reason_text := p_change_comments;
2202:
2203: -- Call Oe_Order_Adj_Pvt.Header_Adj
2204: oe_order_adj_pvt.Header_Adjs
2205: ( p_init_msg_list => FND_API.G_TRUE
2206: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2207: , p_control_rec => l_control_rec
2208: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
2209: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl

Line 2206: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2202:
2203: -- Call Oe_Order_Adj_Pvt.Header_Adj
2204: oe_order_adj_pvt.Header_Adjs
2205: ( p_init_msg_list => FND_API.G_TRUE
2206: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2207: , p_control_rec => l_control_rec
2208: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
2209: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl
2210: );

Line 2216: , p_init_msg_list => FND_API.G_TRUE

2212: /*****************************************************************
2213: -- Call OE_Order_PVT.Process_order
2214: OE_Order_PVT.Process_order
2215: ( p_api_version_number => 1.0
2216: , p_init_msg_list => FND_API.G_TRUE
2217: , x_return_status => l_return_status
2218: , x_msg_count => x_msg_count
2219: , x_msg_data => x_msg_data
2220: , p_control_rec => l_control_rec

Line 2247: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2243:
2244: -- Load OUT parameters.
2245: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
2246:
2247: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2250: RAISE FND_API.G_EXC_ERROR;
2251: END IF;

Line 2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2244: -- Load OUT parameters.
2245: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
2246:
2247: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2250: RAISE FND_API.G_EXC_ERROR;
2251: END IF;
2252:

Line 2249: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN

2245: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
2246:
2247: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2250: RAISE FND_API.G_EXC_ERROR;
2251: END IF;
2252:
2253:

Line 2250: RAISE FND_API.G_EXC_ERROR;

2246:
2247: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2250: RAISE FND_API.G_EXC_ERROR;
2251: END IF;
2252:
2253:
2254: -- Clear Header_Adj record cache

Line 2262: x_return_status := FND_API.G_RET_STS_SUCCESS;

2258: -- Re-set the UI flag to FALSE
2259: OE_GLOBALS.G_UI_FLAG := FALSE;
2260:
2261: -- Set return status.
2262: x_return_status := FND_API.G_RET_STS_SUCCESS;
2263:
2264:
2265: -- Get message count and data
2266: OE_MSG_PUB.Count_And_Get

Line 2277: WHEN FND_API.G_EXC_ERROR THEN

2273: END IF;
2274:
2275: EXCEPTION
2276:
2277: WHEN FND_API.G_EXC_ERROR THEN
2278:
2279: OE_GLOBALS.G_UI_FLAG := FALSE;
2280:
2281: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2281: x_return_status := FND_API.G_RET_STS_ERROR;

2277: WHEN FND_API.G_EXC_ERROR THEN
2278:
2279: OE_GLOBALS.G_UI_FLAG := FALSE;
2280:
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282:
2283: -- Get message count and data
2284: OE_MSG_PUB.Count_And_Get
2285: ( p_count => x_msg_count

Line 2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2285: ( p_count => x_msg_count
2286: , p_data => x_msg_data
2287: );
2288:
2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2290:
2291: OE_GLOBALS.G_UI_FLAG := FALSE;
2292:
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2290:
2291: OE_GLOBALS.G_UI_FLAG := FALSE;
2292:
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2294:
2295: -- Get message count and data
2296: OE_MSG_PUB.Count_And_Get
2297: ( p_count => x_msg_count

Line 2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2301: WHEN OTHERS THEN
2302:
2303: OE_GLOBALS.G_UI_FLAG := FALSE;
2304:
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2306:
2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2308: THEN
2309: OE_MSG_PUB.Add_Exc_Msg

Line 2379: ,p_delete => FND_API.G_TRUE

2375:
2376: /*
2377: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2378: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2379: ,p_delete => FND_API.G_TRUE
2380: ,x_return_status => l_return_status
2381: );
2382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2378: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2379: ,p_delete => FND_API.G_TRUE
2380: ,x_return_status => l_return_status
2381: );
2382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: END IF;

Line 2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2379: ,p_delete => FND_API.G_TRUE
2380: ,x_return_status => l_return_status
2381: );
2382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: END IF;
2387:

Line 2384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2380: ,x_return_status => l_return_status
2381: );
2382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: END IF;
2387:
2388: -- process delayed requests for tax calculation.

Line 2385: RAISE FND_API.G_EXC_ERROR;

2381: );
2382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: END IF;
2387:
2388: -- process delayed requests for tax calculation.
2389: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2391: ,p_delete => FND_API.G_TRUE

2387:
2388: -- process delayed requests for tax calculation.
2389: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2390: (p_request_type => OE_GLOBALS.G_TAX_LINE
2391: ,p_delete => FND_API.G_TRUE
2392: ,x_return_status => l_return_status
2393: );
2394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2390: (p_request_type => OE_GLOBALS.G_TAX_LINE
2391: ,p_delete => FND_API.G_TRUE
2392: ,x_return_status => l_return_status
2393: );
2394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398: END IF;

Line 2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2391: ,p_delete => FND_API.G_TRUE
2392: ,x_return_status => l_return_status
2393: );
2394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398: END IF;
2399:

Line 2396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2392: ,x_return_status => l_return_status
2393: );
2394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398: END IF;
2399:
2400: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);

Line 2397: RAISE FND_API.G_EXC_ERROR;

2393: );
2394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398: END IF;
2399:
2400: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2401: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2403: ,p_delete => FND_API.G_TRUE

2399:
2400: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2401: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2402: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2403: ,p_delete => FND_API.G_TRUE
2404: ,x_return_status => l_return_status
2405: );
2406: */
2407: Oe_Order_Pvt.Process_Requests_And_Notify

Line 2414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2410: , p_process_ack => TRUE
2411: , x_return_status => l_return_status
2412: );
2413:
2414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;

Line 2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2411: , x_return_status => l_return_status
2412: );
2413:
2414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419:

Line 2416: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2412: );
2413:
2414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419:
2420: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2417: RAISE FND_API.G_EXC_ERROR;

2413:
2414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419:
2420: x_return_status := FND_API.G_RET_STS_SUCCESS;
2421: -- 16581325 start Get message count and data

Line 2420: x_return_status := FND_API.G_RET_STS_SUCCESS;

2416: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419:
2420: x_return_status := FND_API.G_RET_STS_SUCCESS;
2421: -- 16581325 start Get message count and data
2422: OE_MSG_PUB.Count_And_Get
2423: ( p_count => x_msg_count
2424: , p_data => x_msg_data

Line 2477: , p_init_msg_list => FND_API.G_TRUE

2473: -- Call OE_Order_PVT.Process_order
2474:
2475: OE_Order_PVT.Process_order
2476: ( p_api_version_number => 1.0
2477: , p_init_msg_list => FND_API.G_TRUE
2478: , x_return_status => l_return_status
2479: , x_msg_count => x_msg_count
2480: , x_msg_data => x_msg_data
2481: , p_control_rec => l_control_rec

Line 2505: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2501: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
2502: , x_action_request_tbl => l_action_request_tbl
2503: );
2504:
2505: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2508: RAISE FND_API.G_EXC_ERROR;
2509: END IF;

Line 2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2502: , x_action_request_tbl => l_action_request_tbl
2503: );
2504:
2505: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2508: RAISE FND_API.G_EXC_ERROR;
2509: END IF;
2510:

Line 2507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2503: );
2504:
2505: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2508: RAISE FND_API.G_EXC_ERROR;
2509: END IF;
2510:
2511:

Line 2508: RAISE FND_API.G_EXC_ERROR;

2504:
2505: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2508: RAISE FND_API.G_EXC_ERROR;
2509: END IF;
2510:
2511:
2512: -- Re-set the UI flag to FALSE

Line 2517: x_return_status := FND_API.G_RET_STS_SUCCESS;

2513: OE_GLOBALS.G_UI_FLAG := FALSE;
2514:
2515: -- Set return status.
2516:
2517: x_return_status := FND_API.G_RET_STS_SUCCESS;
2518:
2519: -- Get message count and data
2520:
2521: OE_MSG_PUB.Count_And_Get

Line 2532: WHEN FND_API.G_EXC_ERROR THEN

2528: */
2529:
2530: EXCEPTION
2531:
2532: WHEN FND_API.G_EXC_ERROR THEN
2533:
2534: OE_GLOBALS.G_UI_FLAG := FALSE;
2535:
2536: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2536: x_return_status := FND_API.G_RET_STS_ERROR;

2532: WHEN FND_API.G_EXC_ERROR THEN
2533:
2534: OE_GLOBALS.G_UI_FLAG := FALSE;
2535:
2536: x_return_status := FND_API.G_RET_STS_ERROR;
2537:
2538: -- Get message count and data
2539:
2540: OE_MSG_PUB.Count_And_Get

Line 2545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2541: ( p_count => x_msg_count
2542: , p_data => x_msg_data
2543: );
2544:
2545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2546:
2547: OE_GLOBALS.G_UI_FLAG := FALSE;
2548:
2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2546:
2547: OE_GLOBALS.G_UI_FLAG := FALSE;
2548:
2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2550:
2551: -- Get message count and data
2552:
2553: OE_MSG_PUB.Count_And_Get

Line 2562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2558: WHEN OTHERS THEN
2559:
2560: OE_GLOBALS.G_UI_FLAG := FALSE;
2561:
2562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2563:
2564: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2565: THEN
2566: OE_MSG_PUB.Add_Exc_Msg

Line 2624: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2620: ( x_return_status => l_return_status
2621: , p_x_header_adj_rec => l_x_header_adj_rec
2622: );
2623:
2624: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2625:
2626: -- Set DB flag and write record to cache.
2627: l_x_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2628:

Line 2627: l_x_Header_Adj_rec.db_flag := FND_API.G_TRUE;

2623:
2624: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2625:
2626: -- Set DB flag and write record to cache.
2627: l_x_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2628:
2629: Write_Header_Adj
2630: ( p_Header_Adj_rec => l_x_Header_Adj_rec
2631: , p_db_record => TRUE

Line 2663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2659: , 'Lock_Row'
2660: );
2661: END IF;
2662:
2663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2664:
2665: -- Get message count and data
2666:
2667: OE_MSG_PUB.Count_And_Get

Line 2732: g_Header_Adj_rec.db_flag := FND_API.G_TRUE;

2728: ( p_price_adjustment_id => p_price_adjustment_id
2729: , x_Header_Adj_rec => g_Header_Adj_rec
2730: );
2731:
2732: g_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2733:
2734: -- Load DB record
2735:
2736: g_db_Header_Adj_rec := g_Header_Adj_rec;