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.

[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on FND_API

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: , 'Query_Header'
328: );
329: END IF;
330:
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332:
333: END Query_Header;
334:
335: PROCEDURE Query_Lines

Line 472: IF (QP_UTIL.GET_QP_STATUS = 'I' OR OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE) THEN

468: END IF;
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'G_RECURSION_MODE:'||OE_GLOBALS.G_RECURSION_MODE ) ;
471: END IF;
472: IF (QP_UTIL.GET_QP_STATUS = 'I' OR OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE) THEN
473: OE_LINE_UTIL.query_rows(p_line_id=>p_line_id
474: , p_header_id => p_header_id
475: , x_line_tbl => x_line_tbl
476: );

Line 498: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

494: */
495: RETURN;
496: END IF;
497:
498: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
499:
500: l_entity := 'L';
501:
502: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 502: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

498: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
499:
500: l_entity := 'L';
501:
502: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add( 'SETTING ENTITY TO H' ) ;
505: END IF;
506: l_entity := 'H';

Line 578: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;

574: x_line_tbl(l_count).charge_periodicity_code := l_implicit_rec.charge_periodicity_code; --rc
575: x_line_tbl(l_count).lock_control:= l_implicit_rec.lock_control;
576:
577: -- set values for non-DB fields
578: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
579: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
580: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
581: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
582: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;

Line 579: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;

575: x_line_tbl(l_count).lock_control:= l_implicit_rec.lock_control;
576:
577: -- set values for non-DB fields
578: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
579: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
580: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
581: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
582: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
583: l_count := l_count + 1;

Line 580: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;

576:
577: -- set values for non-DB fields
578: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
579: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
580: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
581: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
582: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
583: l_count := l_count + 1;
584:

Line 581: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;

577: -- set values for non-DB fields
578: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
579: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
580: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
581: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
582: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
583: l_count := l_count + 1;
584:
585: END LOOP;

Line 582: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;

578: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
579: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
580: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
581: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
582: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
583: l_count := l_count + 1;
584:
585: END LOOP;
586:

Line 593: p_line_id <> FND_API.G_MISS_NUM)

589:
590: IF
591: (p_line_id IS NOT NULL
592: AND
593: p_line_id <> FND_API.G_MISS_NUM)
594: AND
595: (x_line_tbl.COUNT = 0)
596: THEN
597: RAISE NO_DATA_FOUND;

Line 612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

608: WHEN NO_DATA_FOUND THEN
609:
610: RAISE NO_DATA_FOUND;
611:
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613:
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615:
616: WHEN OTHERS THEN

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: RAISE NO_DATA_FOUND;
611:
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613:
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615:
616: WHEN OTHERS THEN
617:
618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

622: , 'Query_lines'
623: );
624: END IF;
625:
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627:
628: END Query_Lines;
629:
630: -- Procedure Query_Line

Line 673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN

669:
670: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
671: -- changes for bug 4200055
672: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
674: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
675: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
676: end if ;
677: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then

Line 698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN

694: begin
695: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
696: --changes for bug 4200055
697: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
699: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
700: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
701: end if ;
702: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

Line 744: If g_rounding_factor_rec.rounding_factor = fnd_api.g_miss_num then

740: g_rounding_factor_rec.list_header_id := p_list_header_id;
741: select rounding_factor into g_rounding_factor_rec.rounding_factor from
742: qp_list_headers_b where list_header_id=p_list_header_id;
743:
744: If g_rounding_factor_rec.rounding_factor = fnd_api.g_miss_num then
745: g_rounding_factor_rec.rounding_factor:= Null;
746: End If;
747:
748: IF l_debug_level > 0 THEN

Line 1927: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

1923: ,x_status_code => l_status_code
1924: ,x_status_text => l_status_text
1925: );
1926:
1927: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1931: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);

Line 1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1925: );
1926:
1927: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1931: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;

Line 1930: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN

1926:
1927: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1931: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: ELSE --lower than 110510

Line 1932: RAISE FND_API.G_EXC_ERROR;

1928: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1931: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: ELSE --lower than 110510
1935: INSERT INTO QP_PREQ_RLTD_LINES_TMP
1936: (LINE_INDEX,

Line 1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1957: WHEN OTHERS THEN
1958: IF l_debug_level > 0 THEN
1959: oe_debug_pub.add( 'ERROR INSERTING'||SQLERRM , 3 ) ;
1960: END IF;
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962: END;
1963: IF l_debug_level > 0 THEN
1964: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.GET_THE_PARENT_LINE' , 1 ) ;
1965: END IF;

Line 2225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2221: x_index => l_notify_index,
2222: x_return_status => l_return_status);
2223:
2224:
2225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2226: oe_debug_pub.add(' Update_global_price called from oe_order_price_pvt.populate_line_tbl reports errors');
2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2228: END IF;
2229:

Line 2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2223:
2224:
2225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2226: oe_debug_pub.add(' Update_global_price called from oe_order_price_pvt.populate_line_tbl reports errors');
2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2228: END IF;
2229:
2230: IF l_notify_index IS NOT NULL THEN
2231: IF l_debug_level > 0 THEN

Line 2288: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2284: )
2285: IS
2286: lx_old_line_price_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
2287: l_control_rec OE_GLOBALS.Control_Rec_Type;
2288: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2289: l_call_lines BOOLEAN := FALSE;
2290: l_check_sec BOOLEAN := FALSE;
2291: l_line_index NUMBER;
2292: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

Line 2400: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL

2396: END IF;
2397: l_validate_desc_flex := OE_GLOBALS.g_validate_desc_flex;
2398: OE_GLOBALS.g_validate_desc_flex := 'N';
2399: OE_Order_Pvt.Lines
2400: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
2401: ,p_control_rec => l_control_rec
2402: ,p_x_line_tbl => px_line_tbl
2403: ,p_x_old_line_tbl => lx_old_line_price_tbl
2404: ,x_return_status => l_return_status);

Line 2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2402: ,p_x_line_tbl => px_line_tbl
2403: ,p_x_old_line_tbl => lx_old_line_price_tbl
2404: ,x_return_status => l_return_status);
2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;

Line 2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2403: ,p_x_old_line_tbl => lx_old_line_price_tbl
2404: ,x_return_status => l_return_status);
2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;

Line 2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2404: ,x_return_status => l_return_status);
2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;
2412: IF l_debug_level > 0 THEN

Line 2409: RAISE FND_API.G_EXC_ERROR;

2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;
2412: IF l_debug_level > 0 THEN
2413: oe_debug_pub.add( 'reset validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;

Line 2495: OR l_line_rec.operation= FND_API.G_MISS_CHAR) THEN

2491: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2492: QP_PREQ_GRP.G_STATUS_UPDATED);
2493:
2494: IF (l_line_rec.operation IS NULL
2495: OR l_line_rec.operation= FND_API.G_MISS_CHAR) THEN
2496: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2497: END IF;
2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add( 'LINE PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||L_LINE_REC.OPERATION||' '||L_OLD_LINE_REC.OPERATION , 3 ) ;

Line 2537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2533: -- end bug 3554060
2534: END IF;
2535:
2536: --END IF;
2537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2539: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2540: RAISE FND_API.G_EXC_ERROR;
2541: END IF;

Line 2538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2534: END IF;
2535:
2536: --END IF;
2537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2539: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2540: RAISE FND_API.G_EXC_ERROR;
2541: END IF;
2542:

Line 2539: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2535:
2536: --END IF;
2537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2539: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2540: RAISE FND_API.G_EXC_ERROR;
2541: END IF;
2542:
2543:

Line 2540: RAISE FND_API.G_EXC_ERROR;

2536: --END IF;
2537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2539: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2540: RAISE FND_API.G_EXC_ERROR;
2541: END IF;
2542:
2543:
2544: -- if operation on any attribute is constrained

Line 2546: RAISE FND_API.G_EXC_ERROR;

2542:
2543:
2544: -- if operation on any attribute is constrained
2545: IF l_sec_result = OE_PC_GLOBALS.YES THEN
2546: RAISE FND_API.G_EXC_ERROR;
2547: END IF;
2548:
2549: IF l_debug_level > 0 THEN
2550: oe_debug_pub.add( 'AFTER CHECK_SECURITY'||L_SEC_RESULT ) ;

Line 2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2581: , x_return_status => l_return_status);
2582: IF l_debug_level > 0 THEN
2583: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2584: END IF;
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;

Line 2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2582: IF l_debug_level > 0 THEN
2583: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2584: END IF;
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590: END IF;*/

Line 2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2583: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2584: END IF;
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590: END IF;*/
2591: px_line_tbl(l_line_index) := l_line_rec;

Line 2588: RAISE FND_API.G_EXC_ERROR;

2584: END IF;
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590: END IF;*/
2591: px_line_tbl(l_line_index) := l_line_rec;
2592:

Line 2683: i.line_id = fnd_api.g_miss_num then

2679: -- use the seeded hold_id
2680: l_hold_source_rec.hold_id := G_SEEDED_GSA_HOLD_ID;
2681:
2682: If i.line_id is null or
2683: i.line_id = fnd_api.g_miss_num then
2684: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2685: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
2686: OE_MSG_PUB.Add;
2687: RAISE FND_API.G_EXC_ERROR;

Line 2687: RAISE FND_API.G_EXC_ERROR;

2683: i.line_id = fnd_api.g_miss_num then
2684: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2685: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
2686: OE_MSG_PUB.Add;
2687: RAISE FND_API.G_EXC_ERROR;
2688: End if;
2689:
2690: G_STMT_NO := 'Gsa_Check#20.20';
2691: l_hold_source_rec.hold_entity_id := l_header_id;

Line 2732: If l_x_result_out = FND_API.G_FALSE then

2728: ,x_msg_data => l_x_msg_data
2729: ,x_result_out => l_x_result_out
2730: );
2731:
2732: If l_x_result_out = FND_API.G_FALSE then
2733: IF l_debug_level > 0 THEN
2734: oe_debug_pub.add( 'HOLD LINE WITH HEADER_ID:'||L_HEADER_ID||' LINE_ID: '||I.LINE_ID , 1 ) ;
2735: END IF;
2736: OE_HOLDS_PUB.Apply_Holds(

Line 2744: If l_return_status = FND_API.g_ret_sts_success then

2740: ,x_msg_count => l_x_msg_count
2741: ,x_msg_data => l_x_msg_data
2742: );
2743:
2744: If l_return_status = FND_API.g_ret_sts_success then
2745:
2746: /*FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2747: OE_MSG_PUB.Add;*/
2748: --3021992

Line 2760: RAISE FND_API.G_EXC_ERROR;

2756: Else
2757: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2758: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
2759: OE_MSG_PUB.Add;
2760: RAISE FND_API.G_EXC_ERROR;
2761: End If;
2762: End If; /* check hold */
2763: End if; --for bug 2028480
2764: End if; /* violation action */

Line 2775: l_hold_source_rec.hold_id = fnd_api.g_miss_num then

2771: END IF;
2772: -- release hold if there is one
2773:
2774: If l_hold_source_rec.hold_id is null or
2775: l_hold_source_rec.hold_id = fnd_api.g_miss_num then
2776: G_STMT_NO := 'Gsa_Check#20.25';
2777: -- bug 1381660, duplicate holds with type_code='GSA'
2778: -- use the seeded hold_id
2779: l_hold_source_rec.hold_id := G_SEEDED_GSA_HOLD_ID;

Line 2800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2796: ,x_msg_data => l_x_msg_data
2797: ,x_result_out => l_x_result_out
2798: );
2799:
2800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2802: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;

Line 2801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2797: ,x_result_out => l_x_result_out
2798: );
2799:
2800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2802: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805:

Line 2802: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2798: );
2799:
2800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2802: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805:
2806: If l_x_result_out = FND_API.G_TRUE then

Line 2803: RAISE FND_API.G_EXC_ERROR;

2799:
2800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2802: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805:
2806: If l_x_result_out = FND_API.G_TRUE then
2807: IF l_debug_level > 0 THEN

Line 2806: If l_x_result_out = FND_API.G_TRUE then

2802: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805:
2806: If l_x_result_out = FND_API.G_TRUE then
2807: IF l_debug_level > 0 THEN
2808: oe_debug_pub.add( 'RELEASING GSA_HOLD ON LINE'||I.LINE_ID , 3 ) ;
2809: END IF;
2810: -- Hold is found , Release the hold.

Line 2829: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2825: ,x_msg_count => l_x_msg_count
2826: ,x_msg_data => l_x_msg_data
2827: );
2828:
2829: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2830: IF l_debug_level > 0 THEN
2831: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2832: END IF;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2829: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2830: IF l_debug_level > 0 THEN
2831: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2832: END IF;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2835: IF l_debug_level > 0 THEN
2836: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2837: END IF;

Line 2834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2830: IF l_debug_level > 0 THEN
2831: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2832: END IF;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2835: IF l_debug_level > 0 THEN
2836: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2837: END IF;
2838: RAISE FND_API.G_EXC_ERROR;

Line 2838: RAISE FND_API.G_EXC_ERROR;

2834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2835: IF l_debug_level > 0 THEN
2836: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2837: END IF;
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840: End if; -- Release Hold
2841:
2842: END LOOP;

Line 2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN

2960: BEGIN
2961: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2962:
2963: --changes for bug 4200055
2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

Line 3040: and update_line.commitment_id <> FND_API.G_MISS_NUM then

3036: l_tax_calculation_flag := l_tax_calc_rec.tax_calculation_flag;
3037: --changes for bug 2505961 Begin
3038: --commented the following for bug7306510 as the sql execution is no more required
3039: /*if update_line.commitment_id is not null
3040: and update_line.commitment_id <> FND_API.G_MISS_NUM then
3041: begin
3042: select nvl(tax_calculation_flag,'N') into l_commt_tax_flag
3043: from ra_cust_trx_types_all ract where ract.cust_trx_type_id =
3044: (

Line 3158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3154: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3155: p_requesting_entity_id => update_line.line_id,
3156: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3157: x_return_status => l_return_status);
3158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: END IF;

Line 3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3155: p_requesting_entity_id => update_line.line_id,
3156: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3157: x_return_status => l_return_status);
3158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: END IF;
3163: END IF;

Line 3160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3156: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3157: x_return_status => l_return_status);
3158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: END IF;
3163: END IF;
3164:

Line 3161: RAISE FND_API.G_EXC_ERROR;

3157: x_return_status => l_return_status);
3158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: END IF;
3163: END IF;
3164:
3165: IF l_debug_level > 0 THEN

Line 3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3176: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3177: p_requesting_entity_id => update_line.line_id,
3178: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
3179: x_return_status => l_return_status);
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;

Line 3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3177: p_requesting_entity_id => update_line.line_id,
3178: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
3179: x_return_status => l_return_status);
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;
3185: END IF;

Line 3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3178: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
3179: x_return_status => l_return_status);
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;
3185: END IF;
3186:

Line 3183: RAISE FND_API.G_EXC_ERROR;

3179: x_return_status => l_return_status);
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;
3185: END IF;
3186:
3187: IF l_debug_level > 0 THEN

Line 3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3237: ,p_request_unique_key1 =>
3238: OE_Order_Cache.g_header_rec.transactional_curr_code
3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;

Line 3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3238: OE_Order_Cache.g_header_rec.transactional_curr_code
3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:

Line 3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:
3247: IF update_line.line_set_id IS NOT NULL THEN

Line 3244: RAISE FND_API.G_EXC_ERROR;

3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:
3247: IF update_line.line_set_id IS NOT NULL THEN
3248: OE_Delayed_Requests_Pvt.Log_Request

Line 3260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3256: ,p_param1 =>
3257: OE_Order_Cache.g_header_rec.transactional_curr_code
3258: ,x_return_status => l_return_status
3259: );
3260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;

Line 3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3257: OE_Order_Cache.g_header_rec.transactional_curr_code
3258: ,x_return_status => l_return_status
3259: );
3260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;
3265: END IF;

Line 3262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3258: ,x_return_status => l_return_status
3259: );
3260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;
3265: END IF;
3266: END IF;--End for quote/order check

Line 3263: RAISE FND_API.G_EXC_ERROR;

3259: );
3260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;
3265: END IF;
3266: END IF;--End for quote/order check
3267: END IF; -- End for log blanket request

Line 3347: raise fnd_api.g_exc_error;

3343: WHEN OTHERS THEN
3344: IF l_debug_level > 0 THEN
3345: oe_debug_pub.add( 'WRONG IN LOG_REQUEST'||SQLERRM , 1 ) ;
3346: END IF;
3347: raise fnd_api.g_exc_error;
3348: End LOG_REQUEST;
3349:
3350: PROCEDURE UPDATE_ORDER_LINES(
3351: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

Line 3421: RAISE fnd_api.g_exc_unexpected_error;

3417: END IF;
3418:
3419: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
3420: OE_MSG_PUB.Add;
3421: RAISE fnd_api.g_exc_unexpected_error;
3422: WHEN OTHERS
3423: THEN
3424: IF l_debug_level > 0 THEN
3425: oe_debug_pub.add('Exceptions have occured, Continuing with the update statement.');

Line 3506: raise fnd_api.g_exc_unexpected_error;

3502: oe_debug_pub.add('Lock_type:'||i.lock_type||' MODE_HELD:'||i.MODE_HELD||' MODE_REQUESTED'||i.MODE_REQUESTED);
3503: oe_debug_pub.add('Lock_ID1:'||i.Lock_ID1||' Lock_ID2:'||i.Lock_ID2);
3504: End Loop;
3505: */
3506: raise fnd_api.g_exc_unexpected_error;
3507: WHEN OTHERS THEN
3508: IF l_debug_level > 0 THEN
3509: oe_debug_pub.add( 'WRONG IN UPDATE_ORDER_LINES'||SQLERRM , 1 ) ;
3510: END IF;

Line 3511: raise fnd_api.g_exc_unexpected_error;

3507: WHEN OTHERS THEN
3508: IF l_debug_level > 0 THEN
3509: oe_debug_pub.add( 'WRONG IN UPDATE_ORDER_LINES'||SQLERRM , 1 ) ;
3510: END IF;
3511: raise fnd_api.g_exc_unexpected_error;
3512: End UPDATE_ORDER_LINES;
3513:
3514: --bug 3882620 Changed the Signature for the procedure Delete_dependents
3515: PROCEDURE DELETE_DEPENDENTS(

Line 3579: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3575: IF l_debug_level > 0 THEN
3576: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS IS: ' || L_RETURN_STATUS ) ;
3577: END IF;
3578:
3579: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3580:
3581: IF l_debug_level > 0 THEN
3582: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3583: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;

Line 3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3581: IF l_debug_level > 0 THEN
3582: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3583: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3584: END IF;
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3587: IF l_debug_level > 0 THEN
3588: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' ) ;
3589: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;

Line 3586: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3582: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3583: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3584: END IF;
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3587: IF l_debug_level > 0 THEN
3588: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' ) ;
3589: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3590: END IF;

Line 3591: RAISE FND_API.G_EXC_ERROR;

3587: IF l_debug_level > 0 THEN
3588: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' ) ;
3589: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3590: END IF;
3591: RAISE FND_API.G_EXC_ERROR;
3592: END IF;
3593: ELSE -- Header Level Adjustment
3594: IF l_debug_level > 0 THEN
3595: oe_debug_pub.add('Header Level Adjustment 8415941 ');

Line 3618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3614: x_return_status => l_return_status);
3615: IF l_debug_level > 0 THEN
3616: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM Header Level Adj: ' || L_RETURN_STATUS ) ;
3617: END IF;
3618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.add( 'Delete - UNEXPECTED ERROR' ) ;
3621: END IF;
3622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.add( 'Delete - UNEXPECTED ERROR' ) ;
3621: END IF;
3622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3623: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3624: IF l_debug_level > 0 THEN
3625: oe_debug_pub.add( 'Delete -Error' ) ;
3626: END IF;

Line 3623: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.add( 'Delete - UNEXPECTED ERROR' ) ;
3621: END IF;
3622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3623: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3624: IF l_debug_level > 0 THEN
3625: oe_debug_pub.add( 'Delete -Error' ) ;
3626: END IF;
3627: RAISE FND_API.G_EXC_ERROR;

Line 3627: RAISE FND_API.G_EXC_ERROR;

3623: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3624: IF l_debug_level > 0 THEN
3625: oe_debug_pub.add( 'Delete -Error' ) ;
3626: END IF;
3627: RAISE FND_API.G_EXC_ERROR;
3628: END IF;
3629:
3630: END IF; -- End Line Adjustment
3631: i := p_adj_id_tbl.next(i);

Line 3940: RAISE FND_API.G_EXC_ERROR;

3936: oe_debug_pub.add('in lock record exception, someone else working on the row');
3937: END IF;
3938: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3939: OE_MSG_PUB.Add;
3940: RAISE FND_API.G_EXC_ERROR;
3941:
3942: WHEN NO_DATA_FOUND THEN
3943: IF l_debug_level > 0 THEN
3944: oe_debug_pub.add('no_data_found, record lock exception');

Line 3946: --bug 5709185 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3942: WHEN NO_DATA_FOUND THEN
3943: IF l_debug_level > 0 THEN
3944: oe_debug_pub.add('no_data_found, record lock exception');
3945: END IF;
3946: --bug 5709185 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947:
3948: WHEN OTHERS THEN
3949: IF l_debug_level > 0 THEN
3950: oe_debug_pub.add('record lock exception, others');

Line 3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3948: WHEN OTHERS THEN
3949: IF l_debug_level > 0 THEN
3950: oe_debug_pub.add('record lock exception, others');
3951: END IF;
3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3953:
3954: END;
3955: --bug 5497035
3956:

Line 5145: raise fnd_api.g_exc_error;

5141: WHEN OTHERS THEN
5142: IF l_debug_level > 0 THEN
5143: oe_debug_pub.add( 'WRONG IN REFRESH_ADJ'||SQLERRM||L_STMT , 1 ) ;
5144: END IF;
5145: raise fnd_api.g_exc_error;
5146:
5147: End REFRESH_ADJS;
5148: --end AG change
5149:

Line 5185: p_header_rec.pricing_date = fnd_api.g_miss_date then

5181: l_req_line_rec.LINE_TYPE_CODE := 'ORDER';
5182: -- Hold the header_id in line_id for 'HEADER' Records
5183: l_req_line_rec.line_id := p_Header_rec.header_id;
5184: if p_header_rec.pricing_date is null or
5185: p_header_rec.pricing_date = fnd_api.g_miss_date then
5186: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
5187: Else
5188: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5189: End If;

Line 5336: p_Line_rec.pricing_date = fnd_api.g_miss_date then

5332: --l_req_line_rec.LIST_LINE_LEVEL_CODE :=p_price_level_code;
5333: l_req_line_rec.LINE_INDEX := px_line_index; --p_line_rec.header_id+p_line_rec.line_id;
5334: l_req_line_rec.LINE_TYPE_CODE := 'LINE';
5335: If p_Line_rec.pricing_date is null or
5336: p_Line_rec.pricing_date = fnd_api.g_miss_date then
5337: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
5338: Else
5339: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_Line_rec.pricing_date;
5340: End If;

Line 5374: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then

5370: OE_Order_PUB.g_hdr.transactional_curr_code;
5371: IF l_debug_level > 0 THEN
5372: oe_debug_pub.add( 'UNIT PRICE'||P_LINE_REC.UNIT_LIST_PRICE||L_REQ_LINE_REC.CURRENCY_CODE , 3 ) ;
5373: END IF;
5374: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
5375: l_req_line_rec.UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
5376: Elsif p_line_rec.unit_list_price <> FND_API.G_MISS_NUM THEN
5377: l_req_line_rec.UNIT_PRICE := p_line_rec.unit_list_price;
5378: Else

Line 5376: Elsif p_line_rec.unit_list_price <> FND_API.G_MISS_NUM THEN

5372: oe_debug_pub.add( 'UNIT PRICE'||P_LINE_REC.UNIT_LIST_PRICE||L_REQ_LINE_REC.CURRENCY_CODE , 3 ) ;
5373: END IF;
5374: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
5375: l_req_line_rec.UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
5376: Elsif p_line_rec.unit_list_price <> FND_API.G_MISS_NUM THEN
5377: l_req_line_rec.UNIT_PRICE := p_line_rec.unit_list_price;
5378: Else
5379: l_req_line_rec.UNIT_PRICE := Null;
5380: End If;

Line 5388: if l_req_line_rec.adjusted_unit_price = FND_API.G_MISS_NUM then

5384: --bug 2650505
5385: IF l_debug_level > 0 THEN
5386: oe_debug_pub.add( 'ADJ PRICE 1:'||L_REQ_LINE_REC.ADJUSTED_UNIT_PRICE ) ;
5387: END IF;
5388: if l_req_line_rec.adjusted_unit_price = FND_API.G_MISS_NUM then
5389: l_req_line_rec.adjusted_unit_price := NULL;
5390: end if;
5391: l_req_line_rec.PERCENT_PRICE := p_Line_rec.unit_list_percent;
5392:

Line 5397: IF (nvl(p_line_rec.service_start_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN

5393: -- bug 4642002 begin call OKS API to get the UOM_QUANTITY
5394: -- also changed the logic to pass 0 whenever service duration or period not present
5395: IF (p_line_rec.item_type_code = 'SERVICE'
5396: OR NVL(p_line_rec.subscription_enable_flag,'N')='Y') THEN --sol_ord_er #16014165
5397: IF (nvl(p_line_rec.service_start_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN
5398: l_req_line_rec.contract_start_date := p_line_rec.service_start_date;
5399: END IF;
5400:
5401: IF (nvl(p_line_rec.service_end_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN

Line 5401: IF (nvl(p_line_rec.service_end_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN

5397: IF (nvl(p_line_rec.service_start_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN
5398: l_req_line_rec.contract_start_date := p_line_rec.service_start_date;
5399: END IF;
5400:
5401: IF (nvl(p_line_rec.service_end_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN
5402: l_req_line_rec.contract_end_date := p_line_rec.service_end_date;
5403: END IF;
5404:
5405: IF (nvl(p_line_rec.service_duration,0) = 0

Line 5406: OR p_line_rec.service_duration = FND_API.G_MISS_NUM

5402: l_req_line_rec.contract_end_date := p_line_rec.service_end_date;
5403: END IF;
5404:
5405: IF (nvl(p_line_rec.service_duration,0) = 0
5406: OR p_line_rec.service_duration = FND_API.G_MISS_NUM
5407: OR nvl(p_line_rec.service_period,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
5408: l_req_line_rec.UOM_QUANTITY := 0;
5409: Elsif (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then
5410: l_req_line_rec.UOM_QUANTITY := p_Line_rec.service_duration;

Line 5407: OR nvl(p_line_rec.service_period,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN

5403: END IF;
5404:
5405: IF (nvl(p_line_rec.service_duration,0) = 0
5406: OR p_line_rec.service_duration = FND_API.G_MISS_NUM
5407: OR nvl(p_line_rec.service_period,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
5408: l_req_line_rec.UOM_QUANTITY := 0;
5409: Elsif (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then
5410: l_req_line_rec.UOM_QUANTITY := p_Line_rec.service_duration;
5411: Elsif (p_line_rec.service_period IS NOT NULL) THEN

Line 5469: If p_Line_rec.calculate_Price_flag = fnd_api.g_miss_char then

5465: ELSE
5466: l_req_line_rec.PRICE_FLAG := 'Y';
5467: END IF;
5468: ELSE
5469: If p_Line_rec.calculate_Price_flag = fnd_api.g_miss_char then
5470: l_req_line_rec.PRICE_FLAG := 'Y';
5471: else
5472: l_req_line_rec.PRICE_FLAG := nvl(p_Line_rec.calculate_Price_flag,'Y');
5473: end if;

Line 5506: p_Line_rec.Shipped_quantity = fnd_api.g_miss_num or

5502: End If;
5503: -- Do not execute SHIP event for a line if the line is not ship interfaced.
5504: If l_req_line_rec.PRICE_FLAG = 'Y' and
5505: (p_Line_rec.Shipped_quantity is null or
5506: p_Line_rec.Shipped_quantity = fnd_api.g_miss_num or
5507: p_Line_rec.Shipped_quantity = 0 ) and
5508: p_pricing_events ='SHIP' Then
5509: l_req_line_rec.PRICE_FLAG := 'N';
5510: End If;

Line 5552: or l_req_line_rec.currency_code = FND_API.G_MISS_CHAR

5548: End If;
5549:
5550: -- Copied Logic from populate_temp_Tables
5551: If l_req_line_rec.currency_code is NULL
5552: or l_req_line_rec.currency_code = FND_API.G_MISS_CHAR
5553: THEN
5554: IF l_debug_level > 0 THEN
5555: oe_debug_pub.add( 'CURRENCY CODE IS NULL' , 4 ) ;
5556: END IF;

Line 5557: RAISE FND_API.G_EXC_ERROR;

5553: THEN
5554: IF l_debug_level > 0 THEN
5555: oe_debug_pub.add( 'CURRENCY CODE IS NULL' , 4 ) ;
5556: END IF;
5557: RAISE FND_API.G_EXC_ERROR;
5558: -- Question: Pricing Engine should populate g_currency_code?
5559: End If;
5560:
5561: IF ( l_req_line_rec.PRICING_EFFECTIVE_DATE IS NULL ) THEN

Line 5562: RAISE FND_API.G_EXC_ERROR;

5558: -- Question: Pricing Engine should populate g_currency_code?
5559: End If;
5560:
5561: IF ( l_req_line_rec.PRICING_EFFECTIVE_DATE IS NULL ) THEN
5562: RAISE FND_API.G_EXC_ERROR;
5563: END IF;
5564: -- ?? Pricing Engine should populate G_MIN_PRICING_DATE, G_MAX_PRICING_DATE
5565:
5566: /* IF ( l_req_line_rec.price_flag = 'Y') THEN

Line 5709: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND

5705: oe_debug_pub.add('ship_from_org_id :'|| p_line_rec.ship_from_org_id );
5706: END IF;
5707:
5708: IF (p_line_rec.inventory_item_id IS NOT NULL AND
5709: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
5710: (p_line_rec.ship_from_org_id IS NOT NULL AND
5711: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
5712: x_item_rec := OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5713: ,p_line_rec.ship_from_org_id);

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

5707:
5708: IF (p_line_rec.inventory_item_id IS NOT NULL AND
5709: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
5710: (p_line_rec.ship_from_org_id IS NOT NULL AND
5711: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
5712: x_item_rec := OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5713: ,p_line_rec.ship_from_org_id);
5714: END IF;
5715: IF l_debug_level > 0 THEN

Line 5762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5758: IF l_debug_level > 0 THEN
5759: oe_debug_pub.add('after populating from x_item_rec :');
5760: oe_debug_pub.add('x_secondary_uom_code : '||x_secondary_uom_code);
5761: END IF;
5762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5763: IF l_debug_level > 0 THEN
5764: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5765: END IF;
5766: oe_msg_pub.transfer_msg_stack;

Line 5767: RAISE FND_API.G_EXC_ERROR;

5763: IF l_debug_level > 0 THEN
5764: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5765: END IF;
5766: oe_msg_pub.transfer_msg_stack;
5767: RAISE FND_API.G_EXC_ERROR;
5768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5769: IF l_debug_level > 0 THEN
5770: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5771: END IF;

Line 5768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5764: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5765: END IF;
5766: oe_msg_pub.transfer_msg_stack;
5767: RAISE FND_API.G_EXC_ERROR;
5768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5769: IF l_debug_level > 0 THEN
5770: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5771: END IF;
5772: oe_msg_pub.transfer_msg_stack;

Line 5773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5769: IF l_debug_level > 0 THEN
5770: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5771: END IF;
5772: oe_msg_pub.transfer_msg_stack;
5773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5774: END IF;
5775:
5776: l_req_line_rec.LINE_QUANTITY := x_secondary_quantity;
5777:

Line 5792: p_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN

5788: oe_debug_pub.add('reference_line_id :'|| p_line_rec.reference_line_id);
5789: END IF;
5790:
5791: IF p_line_rec.shipped_quantity IS NOT NULL AND
5792: p_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
5793: IF p_line_rec.shipped_quantity2 IS NOT NULL AND
5794: p_line_rec.shipped_quantity2 <> FND_API.G_MISS_NUM AND
5795: p_line_rec.shipped_quantity2 <> 0 THEN
5796: G_catchweight_qty_tbl(px_line_index) := p_line_rec.shipped_quantity2;

Line 5794: p_line_rec.shipped_quantity2 <> FND_API.G_MISS_NUM AND

5790:
5791: IF p_line_rec.shipped_quantity IS NOT NULL AND
5792: p_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
5793: IF p_line_rec.shipped_quantity2 IS NOT NULL AND
5794: p_line_rec.shipped_quantity2 <> FND_API.G_MISS_NUM AND
5795: p_line_rec.shipped_quantity2 <> 0 THEN
5796: G_catchweight_qty_tbl(px_line_index) := p_line_rec.shipped_quantity2;
5797: ELSE -- shipped_quantity2 is null
5798: IF p_line_rec.source_type_code = 'EXTERNAL' OR

Line 5824: RAISE FND_API.G_EXC_ERROR;

5820: oe_debug_pub.add('Shipped_quantity2 is null and not dropship, return- Raise error');
5821: END IF;
5822: FND_MESSAGE.SET_NAME('ONT','ONT_CATCHWEIGHT_QTY2_REQUIRED');
5823: OE_MSG_PUB.Add;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END IF; -- end checks for source_type_code
5826: END IF; -- end checks for shipped_quantity2
5827: END IF; -- end check for shipped_quantity
5828: END IF; -- end checks for discrete catchweight

Line 5941: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

5937: end copy_Line_to_request;
5938:
5939: procedure Populate_Temp_Table
5940: IS
5941: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5942: l_return_status_Text varchar2(240) ;
5943: --
5944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5945: --

Line 5995: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5991: p_CHARGE_PERIODICITY_CODE => G_CHARGE_PERIODICITY_CODE_TBL, --rc
5992: x_status_code =>l_return_status,
5993: x_status_text =>l_return_status_text);
5994:
5995: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5996: IF l_debug_level > 0 THEN
5997: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
5998: END IF;
5999: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 6002: RAISE FND_API.G_EXC_ERROR;

5998: END IF;
5999: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6000: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6001: OE_MSG_PUB.Add;
6002: RAISE FND_API.G_EXC_ERROR;
6003: END IF;
6004:
6005: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
6006: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 6040: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6036: G_ATTR_PRIMARY_UOM_FLAG_TBL,
6037: l_return_status ,
6038: l_return_status_text );
6039:
6040: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6041: IF l_debug_level > 0 THEN
6042: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
6043: END IF;
6044: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 6047: raise fnd_api.g_exc_unexpected_error;

6043: END IF;
6044: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6045: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6046: OE_MSG_PUB.Add;
6047: raise fnd_api.g_exc_unexpected_error;
6048: END IF;
6049:
6050: END IF;
6051: IF l_debug_level > 0 THEN

Line 6057: RAISE FND_API.G_EXC_ERROR;

6053: END IF;
6054:
6055: EXCEPTION
6056: WHEN OTHERS THEN
6057: RAISE FND_API.G_EXC_ERROR;
6058: END POPULATE_TEMP_TABLE;
6059:
6060: -- This function is to find out whether it's better to query all lines in the order
6061: -- or query changed lines one by one

Line 6157: and l_line_rec.link_to_line_id <> FND_API.G_MISS_NUM

6153: oe_debug_pub.add('link to line id:'|| l_line_rec.link_to_line_id);
6154:
6155: LOOP
6156: IF l_line_rec.link_to_line_id IS NOT null
6157: and l_line_rec.link_to_line_id <> FND_API.G_MISS_NUM
6158: and l_line_rec.link_to_line_id <> l_line_rec.line_id
6159: and NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT))
6160: and NOT G_ADDED_PARENT_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT)) THEN
6161: --child line has changed, need to send in parent lines to be repriced.

Line 6201: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

6197:
6198: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
6199: )
6200: is
6201: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
6202: l_return_status_Text varchar2(240) ;
6203: l_header_rec OE_Order_PUB.Header_Rec_Type;
6204: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
6205:

Line 6263: if (p_line_id is null or p_line_id = FND_API.G_MISS_NUM)

6259:
6260: G_STMT_NO := 'calculate_adjustments#10';
6261:
6262:
6263: if (p_line_id is null or p_line_id = FND_API.G_MISS_NUM)
6264: and ( p_header_id is null or p_header_id = FND_API.G_MISS_NUM)
6265: and px_line_Tbl.count =0
6266: and p_control_rec.p_use_current_header = FALSE
6267: then

Line 6264: and ( p_header_id is null or p_header_id = FND_API.G_MISS_NUM)

6260: G_STMT_NO := 'calculate_adjustments#10';
6261:
6262:
6263: if (p_line_id is null or p_line_id = FND_API.G_MISS_NUM)
6264: and ( p_header_id is null or p_header_id = FND_API.G_MISS_NUM)
6265: and px_line_Tbl.count =0
6266: and p_control_rec.p_use_current_header = FALSE
6267: then
6268: l_return_status := FND_API.G_RET_STS_ERROR;

Line 6268: l_return_status := FND_API.G_RET_STS_ERROR;

6264: and ( p_header_id is null or p_header_id = FND_API.G_MISS_NUM)
6265: and px_line_Tbl.count =0
6266: and p_control_rec.p_use_current_header = FALSE
6267: then
6268: l_return_status := FND_API.G_RET_STS_ERROR;
6269:
6270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6271: THEN
6272:

Line 6277: RAISE FND_API.G_EXC_ERROR;

6273: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
6274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
6275: OE_MSG_PUB.Add;
6276: END IF;
6277: RAISE FND_API.G_EXC_ERROR;
6278: end if;
6279:
6280: G_STMT_NO := 'calculate_adjustments#20';
6281: if p_Line_id is not null and p_Header_id is not null then

Line 6288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6284: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
6285: 'oe_line_adj.calulate_adjustments'
6286: ,'Keys are mutually exclusive');
6287: END IF;
6288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6289: end if;
6290:
6291: -- Query the header Record
6292: if p_header_id is not null and p_Header_id <> FND_API.G_MISS_NUM then

Line 6292: if p_header_id is not null and p_Header_id <> FND_API.G_MISS_NUM then

6288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6289: end if;
6290:
6291: -- Query the header Record
6292: if p_header_id is not null and p_Header_id <> FND_API.G_MISS_NUM then
6293:
6294: G_STMT_NO := 'calculate_adjustments#30';
6295:
6296: Begin

Line 6492: RAISE FND_API.G_EXC_ERROR;

6488: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
6489: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
6490: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
6491: OE_MSG_PUB.Add;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END;
6494: End If;
6495: --End 2740845
6496:

Line 6499: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then

6495: --End 2740845
6496:
6497: -- Populate that Global Structure
6498: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6499: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6500: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6501: End If;
6502:
6503: --RT{

Line 6516: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM and

6512: END IF;
6513: --RT}
6514:
6515:
6516: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM and
6517: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
6518: Then
6519: /* Added the following if condition for fixing the bug 1828553 */
6520: /* If the service reference context is ORDER, then the service_reference*/

Line 6537: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

6533: , p_reference_line_id => l_Line_Tbl(line_Tbl_Index).service_reference_line_id
6534: , p_customer_id => l_Line_Tbl(line_Tbl_Index).sold_to_org_id
6535: , x_cust_product_line_id => l_order_line_id
6536: );
6537: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6538: oe_debug_pub.add('1828553: Success');
6539: oe_debug_pub.add('1828553: Service line id is ' || l_order_line_id);
6540: l_service_reference_line_id := l_order_line_id;
6541: ELSE

Line 6591: End If; --- IF (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM

6587: END;
6588: --bug 3968023
6589: END IF;
6590: --3273289}
6591: End If; --- IF (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM
6592:
6593: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
6594: oe_debug_pub.add('calling get_prg_lines 5647210 added mass change');
6595: IF ((p_line_id IS NOT NULL and p_control_rec.p_write_to_db) OR oe_mass_change_pvt.Lines_Remaining = 'Y')

Line 6644: p_pricing_events <> 'RETROBILL' and nvl(l_line_tbl(line_tbl_index).retrobill_request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM

6640:
6641: --RT{
6642: IF p_pricing_events = 'RETROBILL' and l_line_tbl(line_tbl_index).retrobill_request_id IS NULL
6643: OR
6644: p_pricing_events <> 'RETROBILL' and nvl(l_line_tbl(line_tbl_index).retrobill_request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
6645: THEN
6646: --Do nothing for these invalid combinations
6647: --RETROBILL event must have retrobill_request_id
6648: --Request None retrobill event with retrobill_request_id should be ignored

Line 6922: when FND_API.G_EXC_ERROR then

6918: x_header_Rec := OE_Order_PUB.g_hdr;
6919: px_line_tbl := l_line_tbl;
6920:
6921: EXCEPTION
6922: when FND_API.G_EXC_ERROR then
6923: oe_debug_pub.add('error in calculate adjustments'||G_STMT_NO, 2);
6924: RAISE FND_API.G_EXC_ERROR;
6925: when others then
6926: oe_debug_pub.add('others error in calculate adjustments'||G_STMT_NO,2);

Line 6924: RAISE FND_API.G_EXC_ERROR;

6920:
6921: EXCEPTION
6922: when FND_API.G_EXC_ERROR then
6923: oe_debug_pub.add('error in calculate adjustments'||G_STMT_NO, 2);
6924: RAISE FND_API.G_EXC_ERROR;
6925: when others then
6926: oe_debug_pub.add('others error in calculate adjustments'||G_STMT_NO,2);
6927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6928: End Calculate_Adjustments;

Line 6927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6923: oe_debug_pub.add('error in calculate adjustments'||G_STMT_NO, 2);
6924: RAISE FND_API.G_EXC_ERROR;
6925: when others then
6926: oe_debug_pub.add('others error in calculate adjustments'||G_STMT_NO,2);
6927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6928: End Calculate_Adjustments;
6929:
6930:
6931:

Line 7028: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7024: ,x_return_status =>x_return_status
7025: ,x_return_status_Text =>l_return_status_Text
7026: );
7027:
7028: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7029: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7030: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7031: OE_MSG_PUB.Add;
7032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7028: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7029: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7030: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7031: OE_MSG_PUB.Add;
7032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7033: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7034: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7035: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7036: OE_MSG_PUB.Add;

Line 7033: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7029: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7030: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7031: OE_MSG_PUB.Add;
7032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7033: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7034: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7035: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7036: OE_MSG_PUB.Add;
7037: RAISE FND_API.G_EXC_ERROR;

Line 7037: RAISE FND_API.G_EXC_ERROR;

7033: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7034: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7035: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7036: OE_MSG_PUB.Add;
7037: RAISE FND_API.G_EXC_ERROR;
7038: END IF;
7039:
7040: END Call_Pricing_Engine;
7041:

Line 7083: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

7079: ,x_result_out => l_x_result_out
7080:
7081: );
7082:
7083: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
7084: IF l_debug_level > 0 THEN
7085: oe_debug_pub.add(' OE_HOLD_PUB.Check_Holds returns unexpected error!');
7086: END IF;
7087: RAISE FND_API.G_EXC_ERROR;

Line 7087: RAISE FND_API.G_EXC_ERROR;

7083: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
7084: IF l_debug_level > 0 THEN
7085: oe_debug_pub.add(' OE_HOLD_PUB.Check_Holds returns unexpected error!');
7086: END IF;
7087: RAISE FND_API.G_EXC_ERROR;
7088: null;
7089: END IF;
7090: IF l_x_result_out = FND_API.G_FALSE THEN
7091: OE_HOLDS_PUB.Apply_Holds(

Line 7090: IF l_x_result_out = FND_API.G_FALSE THEN

7086: END IF;
7087: RAISE FND_API.G_EXC_ERROR;
7088: null;
7089: END IF;
7090: IF l_x_result_out = FND_API.G_FALSE THEN
7091: OE_HOLDS_PUB.Apply_Holds(
7092: p_api_version => 1.0
7093: ,p_hold_source_rec => l_hold_source_rec
7094: -- ,p_header_id => l_line_rec.header_id

Line 7102: IF l_return_status = FND_API.g_ret_sts_success then

7098: ,x_msg_data => l_x_msg_data
7099: );
7100: END IF;
7101:
7102: IF l_return_status = FND_API.g_ret_sts_success then
7103: IF l_debug_level > 0 THEN
7104: oe_debug_pub.add('just before showing formula error',1);
7105: END IF;
7106:

Line 7112: WHEN FND_API.G_EXC_ERROR then

7108: FND_MESSAGE.SET_TOKEN('ERR_TEXT',pmsg);
7109: OE_MSG_PUB.Add;
7110: End if;
7111: exception
7112: WHEN FND_API.G_EXC_ERROR then
7113: null;
7114: end;
7115:
7116:

Line 7302: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7298: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7299: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7300: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7301: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7302: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7303: vmsg := FND_MESSAGE.GET;
7304: else
7305: OE_MSG_PUB.Add;
7306: end if;

Line 7319: FND_API.G_RET_STS_UNEXP_ERROR,

7315: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7316: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7317: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 7320: FND_API.G_RET_STS_ERROR,

7316: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7317: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

Line 7356: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7352: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7353: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
7354: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
7355: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7356: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7357: vmsg := FND_MESSAGE.GET;
7358: ELSE
7359: OE_MSG_PUB.Add;
7360: END IF;

Line 7385: RAISE FND_API.G_EXC_ERROR;

7381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
7382: OE_MSG_PUB.ADD;
7383: -- Bug 8236945
7384: IF OE_GLOBALS.G_UI_FLAG THEN
7385: RAISE FND_API.G_EXC_ERROR;
7386: ELSE
7387: l_booking_error := 'Y';
7388: END IF;
7389: End If;

Line 7416: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7412: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7413: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7414: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7415: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7416: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7417: vmsg := FND_MESSAGE.GET;
7418: else
7419: OE_MSG_PUB.Add;
7420: end if;

Line 7431: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7427: END IF;
7428: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7429: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7430: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7431: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7432: vmsg := FND_MESSAGE.GET;
7433: else
7434: OE_MSG_PUB.Add;
7435: end if;

Line 7440: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

7436: else
7437: OE_MSG_PUB.Add;
7438: end if;
7439: Elsif wrong_line.pricing_status_code in
7440: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7441: FND_API.G_RET_STS_ERROR)
7442: then
7443: IF l_debug_level > 0 THEN
7444: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

Line 7441: FND_API.G_RET_STS_ERROR)

7437: OE_MSG_PUB.Add;
7438: end if;
7439: Elsif wrong_line.pricing_status_code in
7440: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7441: FND_API.G_RET_STS_ERROR)
7442: then
7443: IF l_debug_level > 0 THEN
7444: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7445: END IF;

Line 7449: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7445: END IF;
7446: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7447: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7448: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7449: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7450: vmsg := FND_MESSAGE.GET;
7451: else
7452: OE_MSG_PUB.Add;
7453: end if;

Line 7465: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7461: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
7462: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7463: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7464: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7465: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7466: vmsg := FND_MESSAGE.GET;
7467: else
7468: OE_MSG_PUB.Add;
7469: end if;

Line 7513: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7509: instr(wrong_line.status_text,',')+1);
7510: End;
7511: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
7512: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7513: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7514: vmsg := FND_MESSAGE.GET;
7515: else
7516: OE_MSG_PUB.Add;
7517: end if;

Line 7529: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7525: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
7526: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
7527: wrong_line.status_text);
7528: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7529: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7530: vmsg := FND_MESSAGE.GET;
7531: else
7532: OE_MSG_PUB.Add;
7533: end if;

Line 7545: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7541: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
7542: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
7543: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7544: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7545: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7546: vmsg := FND_MESSAGE.GET;
7547: else
7548: OE_MSG_PUB.Add;
7549: end if;

Line 7561: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7557: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
7558: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7559: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7560: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7561: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7562: vmsg := FND_MESSAGE.GET;
7563: else
7564: OE_MSG_PUB.Add;
7565: end if;

Line 7571: --RAISE FND_API.G_EXC_ERROR;

7567: OE_MSG_PUB.Add;
7568: end if;
7569: End if; /* wrong pricing status code */
7570:
7571: --RAISE FND_API.G_EXC_ERROR;
7572: --btea begin if do not write to db, we still need to
7573: --return line and status code to the caller
7574: If Not p_control_rec.p_write_to_db Then
7575: l_line_rec.Header_id := p_header_rec.Header_id;

Line 7642: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN

7638: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;
7639: END IF;
7640:
7641: --place the line on invoicing hold to avoid stuck order it the ship quatity is there.
7642: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
7643: vmsg := FND_MESSAGE.GET;
7644: oe_debug_pub.add('vmsg = '||vmsg,1);
7645: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7646: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

Line 7657: RAISE FND_API.G_EXC_ERROR;

7653: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7654: END IF;
7655:
7656: ELSE
7657: RAISE FND_API.G_EXC_ERROR;
7658: END IF;
7659:
7660: end if;
7661:

Line 7680: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

7676: END IF; --end if for 'ORDER' line_type_code
7677:
7678: If l_invalid_line = 'Y' Then
7679: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7680: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7681: IF l_debug_level > 0 THEN
7682: oe_debug_pub.add('vmsg = '||vmsg,1);
7683: END IF;
7684: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);

Line 7760: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then

7756: IF l_debug_level > 0 THEN
7757: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
7758: END IF;
7759: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7760: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then
7761: vmsg := FND_MESSAGE.GET;
7762: pricing_errors_hold(book_line.header_id,book_line.line_id,vmsg);
7763: else
7764: OE_MSG_PUB.ADD;

Line 7771: RAISE FND_API.G_EXC_ERROR;

7767: l_temp_line_rec.pricing_quantity := book_line.priced_quantity;
7768: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
7769: -- Bug 8236945
7770: IF OE_GLOBALS.G_UI_FLAG THEN
7771: RAISE FND_API.G_EXC_ERROR;
7772: ELSE
7773: l_booking_error := 'Y';
7774: END IF;
7775: end if;

Line 7790: RAISE FND_API.G_EXC_ERROR;

7786: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
7787: END IF;
7788: -- Bug 8236945
7789: IF OE_GLOBALS.G_UI_FLAG THEN
7790: RAISE FND_API.G_EXC_ERROR;
7791: ELSE
7792: l_booking_error := 'Y';
7793: END IF;
7794: END IF;

Line 7803: RAISE FND_API.G_EXC_ERROR;

7799: END IF;
7800:
7801: -- Added for bug 8236945
7802: IF l_booking_error = 'Y' THEN
7803: RAISE FND_API.G_EXC_ERROR;
7804: END IF;
7805: -- End of bug 8236945
7806: End Report_Engine_Errors;
7807:

Line 7848: x_return_status := FND_API.G_RET_STS_SUCCESS;

7844: BEGIN
7845:
7846: SAVEPOINT PROCESS_ADJUSTMENTS;
7847: l_old_line_tbl := px_line_Tbl;
7848: x_return_status := FND_API.G_RET_STS_SUCCESS;
7849: Report_Engine_Errors(x_return_status
7850: , p_control_rec
7851: , px_line_tbl
7852: , p_header_rec);

Line 7853: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7849: Report_Engine_Errors(x_return_status
7850: , p_control_rec
7851: , px_line_tbl
7852: , p_header_rec);
7853: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7855: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7856: RAISE FND_API.G_EXC_ERROR;
7857: END IF;

Line 7854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7850: , p_control_rec
7851: , px_line_tbl
7852: , p_header_rec);
7853: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7855: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7856: RAISE FND_API.G_EXC_ERROR;
7857: END IF;
7858:

Line 7855: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7851: , px_line_tbl
7852: , p_header_rec);
7853: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7855: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7856: RAISE FND_API.G_EXC_ERROR;
7857: END IF;
7858:
7859: IF p_control_rec.p_write_to_db THEN

Line 7856: RAISE FND_API.G_EXC_ERROR;

7852: , p_header_rec);
7853: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7855: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7856: RAISE FND_API.G_EXC_ERROR;
7857: END IF;
7858:
7859: IF p_control_rec.p_write_to_db THEN
7860: IF l_debug_level > 0 THEN

Line 7938: -- IF (OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE

7934: oe_debug_pub.add( 'VOPRB RECURSION MODE'||OE_GLOBALS.G_RECURSION_MODE ) ;
7935: END IF;
7936:
7937: -- 2366123: execute delayed requests only when not called by UI
7938: -- IF (OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE
7939: IF (NOT OE_GLOBALS.G_UI_FLAG AND p_control_rec.p_write_to_db = TRUE AND l_num_changed_lines > 0 ) THEN
7940: l_process_requests := TRUE;
7941: l_old_line_tbl := px_line_tbl;
7942: END IF;

Line 7971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

7967: IF l_debug_level > 0 THEN
7968: oe_debug_pub.add( 'RETRURNED FROM PROCESS_REQUEST AND NOTIFY : '||X_RETURN_STATUS , 3 ) ;
7969: END IF;
7970:
7971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7972: RAISE FND_API.G_EXC_ERROR;
7973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7975: END IF;

Line 7972: RAISE FND_API.G_EXC_ERROR;

7968: oe_debug_pub.add( 'RETRURNED FROM PROCESS_REQUEST AND NOTIFY : '||X_RETURN_STATUS , 3 ) ;
7969: END IF;
7970:
7971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7972: RAISE FND_API.G_EXC_ERROR;
7973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7975: END IF;
7976: END IF;

Line 7973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7969: END IF;
7970:
7971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7972: RAISE FND_API.G_EXC_ERROR;
7973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7975: END IF;
7976: END IF;
7977:

Line 7974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7970:
7971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7972: RAISE FND_API.G_EXC_ERROR;
7973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7975: END IF;
7976: END IF;
7977:
7978: /*AS per Jyothi Narayan, Process_Requests_And_Notify has notify call. No extra call is needed

Line 7990: , p_init_msg_list => FND_API.G_FALSE

7986:
7987: End If;
7988: OE_SERVICE_UTIL.Notify_OC
7989: ( p_api_version_number => 1.0
7990: , p_init_msg_list => FND_API.G_FALSE
7991: , x_return_status => l_return_status
7992: , x_msg_count => l_msg_count
7993: , x_msg_data => l_msg_data
7994: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl

Line 8000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7996:
7997: IF l_debug_level > 0 THEN
7998: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7999: END IF;
8000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8003: RAISE FND_API.G_EXC_ERROR;
8004: END IF;

Line 8001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7997: IF l_debug_level > 0 THEN
7998: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7999: END IF;
8000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8003: RAISE FND_API.G_EXC_ERROR;
8004: END IF;
8005: END IF;

Line 8002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

7998: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7999: END IF;
8000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8003: RAISE FND_API.G_EXC_ERROR;
8004: END IF;
8005: END IF;
8006:

Line 8003: RAISE FND_API.G_EXC_ERROR;

7999: END IF;
8000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8003: RAISE FND_API.G_EXC_ERROR;
8004: END IF;
8005: END IF;
8006:
8007: END IF;

Line 8012: WHEN FND_API.G_EXC_ERROR THEN

8008: END IF; */
8009:
8010:
8011: Exception
8012: WHEN FND_API.G_EXC_ERROR THEN
8013: x_return_status := FND_API.G_RET_STS_ERROR;
8014:
8015: IF l_debug_level > 0 THEN
8016: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback' , 1 ) ;

Line 8013: x_return_status := FND_API.G_RET_STS_ERROR;

8009:
8010:
8011: Exception
8012: WHEN FND_API.G_EXC_ERROR THEN
8013: x_return_status := FND_API.G_RET_STS_ERROR;
8014:
8015: IF l_debug_level > 0 THEN
8016: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback' , 1 ) ;
8017: END IF;

Line 8020: RAISE FND_API.G_EXC_ERROR;

8016: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback' , 1 ) ;
8017: END IF;
8018: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
8019:
8020: RAISE FND_API.G_EXC_ERROR;
8021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8023:
8024: IF l_debug_level > 0 THEN

Line 8021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8017: END IF;
8018: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
8019:
8020: RAISE FND_API.G_EXC_ERROR;
8021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8023:
8024: IF l_debug_level > 0 THEN
8025: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback' , 1 ) ;

Line 8022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8018: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
8019:
8020: RAISE FND_API.G_EXC_ERROR;
8021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8023:
8024: IF l_debug_level > 0 THEN
8025: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback' , 1 ) ;
8026: END IF;

Line 8028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8024: IF l_debug_level > 0 THEN
8025: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback' , 1 ) ;
8026: END IF;
8027: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
8028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8029: WHEN OTHERS THEN
8030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8031: IF l_debug_level > 0 THEN
8032: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS with rollback' , 1 ) ;

Line 8030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8026: END IF;
8027: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
8028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8029: WHEN OTHERS THEN
8030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8031: IF l_debug_level > 0 THEN
8032: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS with rollback' , 1 ) ;
8033: END IF;
8034: IF l_debug_level > 0 THEN

Line 8051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8047: IF l_debug_level > 0 THEN
8048: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS with rollback' , 1 ) ;
8049: END IF;
8050: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
8051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8052: IF l_debug_level > 0 THEN
8053: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS' , 1 ) ;
8054: END IF;
8055: END Process_Adjustments;

Line 8098: If OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE Then

8094:
8095: oe_debug_pub.add('Retrobill Operation:'||g_retrobill_operation);
8096: --RT}
8097:
8098: If OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE Then
8099: G_DEBUG := TRUE;
8100: IF l_debug_level > 0 THEN
8101: oe_debug_pub.add( 'BCT G_DEBUG IS:'||OE_DEBUG_PUB.G_DEBUG ) ;
8102: END IF;

Line 8123: x_return_status := FND_API.G_RET_STS_SUCCESS;

8119:
8120: IF l_debug_level > 0 THEN
8121: oe_debug_pub.add( 'PRICE_LINE:'||P_HEADER_ID||'+'||P_LINE_ID||'OF EVENT '||P_PRICING_EVENTS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
8122: END IF;
8123: x_return_status := FND_API.G_RET_STS_SUCCESS;
8124:
8125: calculate_adjustments
8126: (x_return_status => x_return_status,
8127: p_line_Id => p_line_Id,

Line 8140: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8136:
8137:
8138: --l_Control_Rec.calculate_flag := 'N';
8139: -- Do no proceed , if there are no order lines
8140: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8141: IF l_debug_level > 0 THEN
8142: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
8143: END IF;
8144: raise fnd_api.g_exc_error;

Line 8144: raise fnd_api.g_exc_error;

8140: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8141: IF l_debug_level > 0 THEN
8142: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
8143: END IF;
8144: raise fnd_api.g_exc_error;
8145: END IF;
8146:
8147: If x_return_status = 'NOOP' Then
8148: IF l_debug_level > 0 THEN

Line 8163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8159: Call_Pricing_Engine(p_Control_Rec
8160: ,p_Pricing_Events
8161: ,x_return_status
8162: );
8163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8164: IF l_debug_level > 0 THEN
8165: oe_debug_pub.add( 'PRICING ENGINE ERROR' ) ;
8166: END IF;
8167: raise fnd_api.g_exc_error;

Line 8167: raise fnd_api.g_exc_error;

8163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8164: IF l_debug_level > 0 THEN
8165: oe_debug_pub.add( 'PRICING ENGINE ERROR' ) ;
8166: END IF;
8167: raise fnd_api.g_exc_error;
8168: END IF;
8169:
8170: IF l_debug_level > 0 THEN
8171: oe_debug_pub.add( 'BEFORE OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

Line 8186: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8182: px_line_Tbl => px_Line_Tbl,
8183: p_pricing_events => p_pricing_events
8184: );
8185:
8186: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8187: IF l_debug_level > 0 THEN
8188: oe_debug_pub.add( 'PROCESS ADJUSTMENTS ERROR' ) ;
8189: END IF;
8190: raise fnd_api.g_exc_error;

Line 8190: raise fnd_api.g_exc_error;

8186: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8187: IF l_debug_level > 0 THEN
8188: oe_debug_pub.add( 'PROCESS ADJUSTMENTS ERROR' ) ;
8189: END IF;
8190: raise fnd_api.g_exc_error;
8191: END IF;
8192:
8193: --TaxER start
8194: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN

Line 8212: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM) OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)

8208: BEGIN
8209:
8210: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
8211:
8212: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM) OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
8213: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
8214: THEN
8215: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
8216: END IF ;

Line 8353: WHEN FND_API.G_EXC_ERROR THEN

8349: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
8350: END IF;
8351:
8352: Exception
8353: WHEN FND_API.G_EXC_ERROR THEN
8354:
8355: --reseting global structure after engine call
8356: OE_Order_PUB.G_LINE := NULL;
8357: OE_Order_PUB.G_HDR := NULL;

Line 8358: x_return_status := FND_API.G_RET_STS_ERROR;

8354:
8355: --reseting global structure after engine call
8356: OE_Order_PUB.G_LINE := NULL;
8357: OE_Order_PUB.G_HDR := NULL;
8358: x_return_status := FND_API.G_RET_STS_ERROR;
8359:
8360: IF l_debug_level > 0 THEN
8361: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
8362: END IF;

Line 8363: RAISE FND_API.G_EXC_ERROR;

8359:
8360: IF l_debug_level > 0 THEN
8361: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
8362: END IF;
8363: RAISE FND_API.G_EXC_ERROR;
8364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8365:
8366: --reseting global structure after engine call
8367: OE_Order_PUB.G_LINE := NULL;

Line 8364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8360: IF l_debug_level > 0 THEN
8361: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
8362: END IF;
8363: RAISE FND_API.G_EXC_ERROR;
8364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8365:
8366: --reseting global structure after engine call
8367: OE_Order_PUB.G_LINE := NULL;
8368: OE_Order_PUB.G_HDR := NULL;

Line 8369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8365:
8366: --reseting global structure after engine call
8367: OE_Order_PUB.G_LINE := NULL;
8368: OE_Order_PUB.G_HDR := NULL;
8369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8370: IF l_debug_level > 0 THEN
8371: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
8372: END IF;
8373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8370: IF l_debug_level > 0 THEN
8371: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
8372: END IF;
8373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8374: WHEN OTHERS THEN
8375:
8376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8377: --reseting global structure after engine call

Line 8376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8372: END IF;
8373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8374: WHEN OTHERS THEN
8375:
8376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8377: --reseting global structure after engine call
8378: OE_Order_PUB.G_LINE := NULL;
8379: OE_Order_PUB.G_HDR := NULL;
8380: IF l_debug_level > 0 THEN

Line 8398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8394:
8395: IF l_debug_level > 0 THEN
8396: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
8397: END IF;
8398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8399:
8400: IF l_debug_level > 0 THEN
8401: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
8402: END IF;