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 1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1066: ( p_init_msg_list => FND_API.G_TRUE

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

Line 1067: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

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

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

Line 1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1080: RAISE FND_API.G_EXC_ERROR;

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

Line 1085: ,p_delete => FND_API.G_TRUE

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

Line 1088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1091: RAISE FND_API.G_EXC_ERROR;

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

Line 1096: ,p_delete => FND_API.G_TRUE

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

Line 1100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1103: RAISE FND_API.G_EXC_ERROR;

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

Line 1106: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1113: x_price_adjustment_id := FND_API.G_MISS_NUM;

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

Line 1114: x_header_id := FND_API.G_MISS_NUM;

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

Line 1115: x_discount_id := FND_API.G_MISS_NUM;

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

Line 1116: x_discount := FND_API.G_MISS_CHAR;

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

Line 1117: x_discount_line_id := FND_API.G_MISS_NUM;

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

Line 1118: x_automatic_flag := FND_API.G_MISS_CHAR;

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

Line 1119: x_percent := FND_API.G_MISS_NUM;

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

Line 1120: x_line_id := FND_API.G_MISS_NUM;

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

Line 1121: x_context := FND_API.G_MISS_CHAR;

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

Line 1122: x_attribute1 := FND_API.G_MISS_CHAR;

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

Line 1123: x_attribute2 := FND_API.G_MISS_CHAR;

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

Line 1124: x_attribute3 := FND_API.G_MISS_CHAR;

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

Line 1125: x_attribute4 := FND_API.G_MISS_CHAR;

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

Line 1126: x_attribute5 := FND_API.G_MISS_CHAR;

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

Line 1127: x_attribute6 := FND_API.G_MISS_CHAR;

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

Line 1128: x_attribute7 := FND_API.G_MISS_CHAR;

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

Line 1129: x_attribute8 := FND_API.G_MISS_CHAR;

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

Line 1130: x_attribute9 := FND_API.G_MISS_CHAR;

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

Line 1131: x_attribute10 := FND_API.G_MISS_CHAR;

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

Line 1132: x_attribute11 := FND_API.G_MISS_CHAR;

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

Line 1133: x_attribute12 := FND_API.G_MISS_CHAR;

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

Line 1134: x_attribute13 := FND_API.G_MISS_CHAR;

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

Line 1135: x_attribute14 := FND_API.G_MISS_CHAR;

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

Line 1136: x_attribute15 := FND_API.G_MISS_CHAR;

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

Line 1137: x_ac_context := FND_API.G_MISS_CHAR;

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

Line 1138: x_ac_attribute1 := FND_API.G_MISS_CHAR;

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

Line 1139: x_ac_attribute2 := FND_API.G_MISS_CHAR;

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

Line 1140: x_ac_attribute3 := FND_API.G_MISS_CHAR;

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

Line 1141: x_ac_attribute4 := FND_API.G_MISS_CHAR;

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

Line 1142: x_ac_attribute5 := FND_API.G_MISS_CHAR;

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

Line 1143: x_ac_attribute6 := FND_API.G_MISS_CHAR;

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

Line 1144: x_ac_attribute7 := FND_API.G_MISS_CHAR;

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

Line 1145: x_ac_attribute8 := FND_API.G_MISS_CHAR;

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

Line 1146: x_ac_attribute9 := FND_API.G_MISS_CHAR;

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

Line 1147: x_ac_attribute10 := FND_API.G_MISS_CHAR;

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

Line 1148: x_ac_attribute11 := FND_API.G_MISS_CHAR;

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

Line 1149: x_ac_attribute12 := FND_API.G_MISS_CHAR;

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

Line 1150: x_ac_attribute13 := FND_API.G_MISS_CHAR;

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

Line 1151: x_ac_attribute14 := FND_API.G_MISS_CHAR;

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

Line 1152: x_ac_attribute15 := FND_API.G_MISS_CHAR;

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

Line 1156: x_list_header_id := FND_API.G_MISS_NUM;

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

Line 1157: x_list_line_id := FND_API.G_MISS_NUM;

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

Line 1158: x_list_line_type_code := FND_API.G_MISS_CHAR;

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

Line 1159: x_modifier_mechanism_type_code := FND_API.G_MISS_CHAR;

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

Line 1160: x_modified_from := FND_API.G_MISS_CHAR;

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

Line 1161: x_modified_to := FND_API.G_MISS_CHAR;

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

Line 1162: x_update_allowed := FND_API.G_MISS_CHAR;

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

Line 1163: x_updated_flag := FND_API.G_MISS_CHAR;

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

Line 1164: x_applied_flag := FND_API.G_MISS_CHAR;

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

Line 1165: x_change_reason_code := FND_API.G_MISS_CHAR;

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

Line 1166: x_change_reason_text := FND_API.G_MISS_CHAR;

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

Line 1167: x_operand := FND_API.G_MISS_NUM;

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

Line 1168: x_arithmetic_operator := FND_API.G_MISS_CHAR;

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

Line 1170: x_adjusted_amount := FND_API.G_MISS_NUM;

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

Line 1171: x_pricing_phase_id := FND_API.G_MISS_NUM;

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

Line 1172: x_list_line_no := FND_API.G_MISS_CHAR;

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

Line 1173: x_source_system_code := FND_API.G_MISS_CHAR;

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

Line 1174: x_benefit_qty := FND_API.G_MISS_NUM;

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

Line 1175: x_benefit_uom_code := FND_API.G_MISS_CHAR;

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

Line 1176: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;

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

Line 1177: x_expiration_date := FND_API.G_MISS_DATE;

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

Line 1178: x_rebate_transaction_type_code := FND_API.G_MISS_CHAR;

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

Line 1179: x_rebate_transaction_reference := FND_API.G_MISS_CHAR;

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

Line 1180: x_rebate_payment_system_code := FND_API.G_MISS_CHAR;

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

Line 1181: x_redeemed_date := FND_API.G_MISS_DATE;

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

Line 1182: x_redeemed_flag := FND_API.G_MISS_CHAR;

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

Line 1183: x_accrual_flag := FND_API.G_MISS_CHAR;

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

Line 1184: x_invoiced_flag := FND_API.G_MISS_CHAR;

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

Line 1185: x_estimated_flag := FND_API.G_MISS_CHAR;

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

Line 1186: x_credit_or_charge_flag := FND_API.G_MISS_CHAR;

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

Line 1187: x_include_on_returns_flag := FND_API.G_MISS_CHAR;

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

Line 1188: x_charge_type_code := FND_API.G_MISS_CHAR;

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

Line 1189: x_charge_subtype_code := FND_API.G_MISS_CHAR;

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

Line 1192: x_operand_per_pqty := FND_API.G_MISS_NUM;

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

Line 1193: x_adjusted_amount_per_pqty := FND_API.G_MISS_NUM;

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

Line 1658: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1673: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1677: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1825: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 1889: ( p_init_msg_list => FND_API.G_TRUE

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

Line 1890: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

Line 1902: , p_init_msg_list => FND_API.G_TRUE

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

Line 1931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1934: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1944: RAISE FND_API.G_EXC_ERROR;

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

Line 1956: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1959: RAISE FND_API.G_EXC_ERROR;

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

Line 1967: ,p_delete => FND_API.G_TRUE

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

Line 1970: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1972: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1968: ,x_return_status => l_return_status
1969: );
1970: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1973: RAISE FND_API.G_EXC_ERROR;
1974: END IF;
1975:
1976: -- fixed bug 3271297

Line 1973: RAISE FND_API.G_EXC_ERROR;

1969: );
1970: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1973: RAISE FND_API.G_EXC_ERROR;
1974: END IF;
1975:
1976: -- fixed bug 3271297
1977: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 1979: ,p_delete => FND_API.G_TRUE

1975:
1976: -- fixed bug 3271297
1977: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1978: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
1979: ,p_delete => FND_API.G_TRUE
1980: ,x_return_status => l_return_status
1981: );
1982: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1982: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1978: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
1979: ,p_delete => FND_API.G_TRUE
1980: ,x_return_status => l_return_status
1981: );
1982: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;
1986: END IF;

Line 1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1980: ,x_return_status => l_return_status
1981: );
1982: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;
1986: END IF;
1987:
1988: /*****

Line 1985: RAISE FND_API.G_EXC_ERROR;

1981: );
1982: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1984: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;
1986: END IF;
1987:
1988: /*****
1989: IF p_ok_flag = 'Y' THEN

Line 1992: ,p_delete => FND_API.G_TRUE

1988: /*****
1989: IF p_ok_flag = 'Y' THEN
1990: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
1991: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
1992: ,p_delete => FND_API.G_TRUE
1993: ,x_return_status => l_return_status
1994: );
1995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1991: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
1992: ,p_delete => FND_API.G_TRUE
1993: ,x_return_status => l_return_status
1994: );
1995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;

Line 1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1992: ,p_delete => FND_API.G_TRUE
1993: ,x_return_status => l_return_status
1994: );
1995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: END IF;

Line 1997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1993: ,x_return_status => l_return_status
1994: );
1995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: END IF;
2001: ******/

Line 1998: RAISE FND_API.G_EXC_ERROR;

1994: );
1995: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: END IF;
2001: ******/
2002:

Line 2022: x_return_status := FND_API.G_RET_STS_SUCCESS;

2018: -- Re-set the UI flag to FALSE
2019: OE_GLOBALS.G_UI_FLAG := FALSE;
2020:
2021: -- Set return status.
2022: x_return_status := FND_API.G_RET_STS_SUCCESS;
2023:
2024:
2025: -- Get message count and data
2026: OE_MSG_PUB.Count_And_Get

Line 2037: WHEN FND_API.G_EXC_ERROR THEN

2033: END IF;
2034:
2035: EXCEPTION
2036:
2037: WHEN FND_API.G_EXC_ERROR THEN
2038:
2039: OE_GLOBALS.G_UI_FLAG := FALSE;
2040:
2041: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2041: x_return_status := FND_API.G_RET_STS_ERROR;

2037: WHEN FND_API.G_EXC_ERROR THEN
2038:
2039: OE_GLOBALS.G_UI_FLAG := FALSE;
2040:
2041: x_return_status := FND_API.G_RET_STS_ERROR;
2042:
2043: -- Get message count and data
2044:
2045: OE_MSG_PUB.Count_And_Get

Line 2052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2048: );
2049:
2050: ROLLBACK TO SAVEPOINT validate_and_write;
2051:
2052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2053:
2054: OE_GLOBALS.G_UI_FLAG := FALSE;
2055:
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2053:
2054: OE_GLOBALS.G_UI_FLAG := FALSE;
2055:
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2057:
2058: -- Get message count and data
2059:
2060: OE_MSG_PUB.Count_And_Get

Line 2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2067: WHEN OTHERS THEN
2068:
2069: OE_GLOBALS.G_UI_FLAG := FALSE;
2070:
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2072:
2073: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2074: THEN
2075: OE_MSG_PUB.Add_Exc_Msg

Line 2188: ( p_init_msg_list => FND_API.G_TRUE

2184: l_x_Header_Adj_tbl(1).change_reason_text := p_change_comments;
2185:
2186: -- Call Oe_Order_Adj_Pvt.Header_Adj
2187: oe_order_adj_pvt.Header_Adjs
2188: ( p_init_msg_list => FND_API.G_TRUE
2189: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2190: , p_control_rec => l_control_rec
2191: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
2192: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl

Line 2189: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2185:
2186: -- Call Oe_Order_Adj_Pvt.Header_Adj
2187: oe_order_adj_pvt.Header_Adjs
2188: ( p_init_msg_list => FND_API.G_TRUE
2189: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2190: , p_control_rec => l_control_rec
2191: , p_x_header_adj_tbl => l_x_Header_Adj_tbl
2192: , p_x_old_header_adj_tbl => l_x_old_header_adj_tbl
2193: );

Line 2199: , p_init_msg_list => FND_API.G_TRUE

2195: /*****************************************************************
2196: -- Call OE_Order_PVT.Process_order
2197: OE_Order_PVT.Process_order
2198: ( p_api_version_number => 1.0
2199: , p_init_msg_list => FND_API.G_TRUE
2200: , x_return_status => l_return_status
2201: , x_msg_count => x_msg_count
2202: , x_msg_data => x_msg_data
2203: , p_control_rec => l_control_rec

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

2226:
2227: -- Load OUT parameters.
2228: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
2229:
2230: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2233: RAISE FND_API.G_EXC_ERROR;
2234: END IF;

Line 2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2227: -- Load OUT parameters.
2228: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
2229:
2230: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2233: RAISE FND_API.G_EXC_ERROR;
2234: END IF;
2235:

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

2228: l_x_Header_Adj_rec := l_x_Header_Adj_tbl(1);
2229:
2230: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2233: RAISE FND_API.G_EXC_ERROR;
2234: END IF;
2235:
2236:

Line 2233: RAISE FND_API.G_EXC_ERROR;

2229:
2230: IF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: ELSIF l_x_Header_Adj_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2233: RAISE FND_API.G_EXC_ERROR;
2234: END IF;
2235:
2236:
2237: -- Clear Header_Adj record cache

Line 2245: x_return_status := FND_API.G_RET_STS_SUCCESS;

2241: -- Re-set the UI flag to FALSE
2242: OE_GLOBALS.G_UI_FLAG := FALSE;
2243:
2244: -- Set return status.
2245: x_return_status := FND_API.G_RET_STS_SUCCESS;
2246:
2247:
2248: -- Get message count and data
2249: OE_MSG_PUB.Count_And_Get

Line 2260: WHEN FND_API.G_EXC_ERROR THEN

2256: END IF;
2257:
2258: EXCEPTION
2259:
2260: WHEN FND_API.G_EXC_ERROR THEN
2261:
2262: OE_GLOBALS.G_UI_FLAG := FALSE;
2263:
2264: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2264: x_return_status := FND_API.G_RET_STS_ERROR;

2260: WHEN FND_API.G_EXC_ERROR THEN
2261:
2262: OE_GLOBALS.G_UI_FLAG := FALSE;
2263:
2264: x_return_status := FND_API.G_RET_STS_ERROR;
2265:
2266: -- Get message count and data
2267: OE_MSG_PUB.Count_And_Get
2268: ( p_count => x_msg_count

Line 2272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2268: ( p_count => x_msg_count
2269: , p_data => x_msg_data
2270: );
2271:
2272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2273:
2274: OE_GLOBALS.G_UI_FLAG := FALSE;
2275:
2276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2273:
2274: OE_GLOBALS.G_UI_FLAG := FALSE;
2275:
2276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2277:
2278: -- Get message count and data
2279: OE_MSG_PUB.Count_And_Get
2280: ( p_count => x_msg_count

Line 2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2284: WHEN OTHERS THEN
2285:
2286: OE_GLOBALS.G_UI_FLAG := FALSE;
2287:
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289:
2290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2291: THEN
2292: OE_MSG_PUB.Add_Exc_Msg

Line 2362: ,p_delete => FND_API.G_TRUE

2358:
2359: /*
2360: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2361: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2362: ,p_delete => FND_API.G_TRUE
2363: ,x_return_status => l_return_status
2364: );
2365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2361: (p_request_type => OE_GLOBALS.G_PRICE_ADJ
2362: ,p_delete => FND_API.G_TRUE
2363: ,x_return_status => l_return_status
2364: );
2365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;

Line 2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2362: ,p_delete => FND_API.G_TRUE
2363: ,x_return_status => l_return_status
2364: );
2365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2370:

Line 2367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2363: ,x_return_status => l_return_status
2364: );
2365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2370:
2371: -- process delayed requests for tax calculation.

Line 2368: RAISE FND_API.G_EXC_ERROR;

2364: );
2365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2370:
2371: -- process delayed requests for tax calculation.
2372: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2374: ,p_delete => FND_API.G_TRUE

2370:
2371: -- process delayed requests for tax calculation.
2372: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2373: (p_request_type => OE_GLOBALS.G_TAX_LINE
2374: ,p_delete => FND_API.G_TRUE
2375: ,x_return_status => l_return_status
2376: );
2377: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2377: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2373: (p_request_type => OE_GLOBALS.G_TAX_LINE
2374: ,p_delete => FND_API.G_TRUE
2375: ,x_return_status => l_return_status
2376: );
2377: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2379: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: END IF;

Line 2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2374: ,p_delete => FND_API.G_TRUE
2375: ,x_return_status => l_return_status
2376: );
2377: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2379: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: END IF;
2382:

Line 2379: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2375: ,x_return_status => l_return_status
2376: );
2377: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2379: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: END IF;
2382:
2383: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);

Line 2380: RAISE FND_API.G_EXC_ERROR;

2376: );
2377: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2379: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2380: RAISE FND_API.G_EXC_ERROR;
2381: END IF;
2382:
2383: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2384: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2386: ,p_delete => FND_API.G_TRUE

2382:
2383: oe_debug_pub.ADD('Processing delayed request for Verify Payment for price adjustments changes.', 3);
2384: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2385: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
2386: ,p_delete => FND_API.G_TRUE
2387: ,x_return_status => l_return_status
2388: );
2389: */
2390: Oe_Order_Pvt.Process_Requests_And_Notify

Line 2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2393: , p_process_ack => TRUE
2394: , x_return_status => l_return_status
2395: );
2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;

Line 2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2394: , x_return_status => l_return_status
2395: );
2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;
2402:

Line 2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2395: );
2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;
2402:
2403: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2400: RAISE FND_API.G_EXC_ERROR;

2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;
2402:
2403: x_return_status := FND_API.G_RET_STS_SUCCESS;
2404:

Line 2403: x_return_status := FND_API.G_RET_STS_SUCCESS;

2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;
2402:
2403: x_return_status := FND_API.G_RET_STS_SUCCESS;
2404:
2405: IF l_debug_level > 0 THEN
2406: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_ADJ.PROCESS_DELAYED_REQUESTS' , 1 ) ;
2407: END IF;

Line 2454: , p_init_msg_list => FND_API.G_TRUE

2450: -- Call OE_Order_PVT.Process_order
2451:
2452: OE_Order_PVT.Process_order
2453: ( p_api_version_number => 1.0
2454: , p_init_msg_list => FND_API.G_TRUE
2455: , x_return_status => l_return_status
2456: , x_msg_count => x_msg_count
2457: , x_msg_data => x_msg_data
2458: , p_control_rec => l_control_rec

Line 2482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2478: , x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
2479: , x_action_request_tbl => l_action_request_tbl
2480: );
2481:
2482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: END IF;

Line 2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2479: , x_action_request_tbl => l_action_request_tbl
2480: );
2481:
2482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: END IF;
2487:

Line 2484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2480: );
2481:
2482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: END IF;
2487:
2488:

Line 2485: RAISE FND_API.G_EXC_ERROR;

2481:
2482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: END IF;
2487:
2488:
2489: -- Re-set the UI flag to FALSE

Line 2494: x_return_status := FND_API.G_RET_STS_SUCCESS;

2490: OE_GLOBALS.G_UI_FLAG := FALSE;
2491:
2492: -- Set return status.
2493:
2494: x_return_status := FND_API.G_RET_STS_SUCCESS;
2495:
2496: -- Get message count and data
2497:
2498: OE_MSG_PUB.Count_And_Get

Line 2509: WHEN FND_API.G_EXC_ERROR THEN

2505: */
2506:
2507: EXCEPTION
2508:
2509: WHEN FND_API.G_EXC_ERROR THEN
2510:
2511: OE_GLOBALS.G_UI_FLAG := FALSE;
2512:
2513: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2513: x_return_status := FND_API.G_RET_STS_ERROR;

2509: WHEN FND_API.G_EXC_ERROR THEN
2510:
2511: OE_GLOBALS.G_UI_FLAG := FALSE;
2512:
2513: x_return_status := FND_API.G_RET_STS_ERROR;
2514:
2515: -- Get message count and data
2516:
2517: OE_MSG_PUB.Count_And_Get

Line 2522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2518: ( p_count => x_msg_count
2519: , p_data => x_msg_data
2520: );
2521:
2522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2523:
2524: OE_GLOBALS.G_UI_FLAG := FALSE;
2525:
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2523:
2524: OE_GLOBALS.G_UI_FLAG := FALSE;
2525:
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2527:
2528: -- Get message count and data
2529:
2530: OE_MSG_PUB.Count_And_Get

Line 2539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2535: WHEN OTHERS THEN
2536:
2537: OE_GLOBALS.G_UI_FLAG := FALSE;
2538:
2539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2540:
2541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2542: THEN
2543: OE_MSG_PUB.Add_Exc_Msg

Line 2601: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2597: ( x_return_status => l_return_status
2598: , p_x_header_adj_rec => l_x_header_adj_rec
2599: );
2600:
2601: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2602:
2603: -- Set DB flag and write record to cache.
2604: l_x_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2605:

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

2600:
2601: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2602:
2603: -- Set DB flag and write record to cache.
2604: l_x_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2605:
2606: Write_Header_Adj
2607: ( p_Header_Adj_rec => l_x_Header_Adj_rec
2608: , p_db_record => TRUE

Line 2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2636: , 'Lock_Row'
2637: );
2638: END IF;
2639:
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641:
2642: -- Get message count and data
2643:
2644: OE_MSG_PUB.Count_And_Get

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

2705: ( p_price_adjustment_id => p_price_adjustment_id
2706: , x_Header_Adj_rec => g_Header_Adj_rec
2707: );
2708:
2709: g_Header_Adj_rec.db_flag := FND_API.G_TRUE;
2710:
2711: -- Load DB record
2712:
2713: g_db_Header_Adj_rec := g_Header_Adj_rec;