APPS.OE_ORDER_PRICE_PVT dependencies on FND_API

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 592: p_line_id <> FND_API.G_MISS_NUM)

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

Line 611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

Line 1926: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1929: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN

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

Line 1931: RAISE FND_API.G_EXC_ERROR;

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

Line 1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 2393: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL

2389: END IF;
2390: l_validate_desc_flex := OE_GLOBALS.g_validate_desc_flex;
2391: OE_GLOBALS.g_validate_desc_flex := 'N';
2392: OE_Order_Pvt.Lines
2393: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
2394: ,p_control_rec => l_control_rec
2395: ,p_x_line_tbl => px_line_tbl
2396: ,p_x_old_line_tbl => lx_old_line_price_tbl
2397: ,x_return_status => l_return_status);

Line 2399: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2396: ,p_x_old_line_tbl => lx_old_line_price_tbl
2397: ,x_return_status => l_return_status);
2398:
2399: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2402: RAISE FND_API.G_EXC_ERROR;
2403: END IF;
2404: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;

Line 2401: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2397: ,x_return_status => l_return_status);
2398:
2399: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2402: RAISE FND_API.G_EXC_ERROR;
2403: END IF;
2404: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;
2405: IF l_debug_level > 0 THEN

Line 2402: RAISE FND_API.G_EXC_ERROR;

2398:
2399: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2402: RAISE FND_API.G_EXC_ERROR;
2403: END IF;
2404: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;
2405: IF l_debug_level > 0 THEN
2406: oe_debug_pub.add( 'reset validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;

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

2484: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2485: QP_PREQ_GRP.G_STATUS_UPDATED);
2486:
2487: IF (l_line_rec.operation IS NULL
2488: OR l_line_rec.operation= FND_API.G_MISS_CHAR) THEN
2489: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2490: END IF;
2491: IF l_debug_level > 0 THEN
2492: oe_debug_pub.add( 'LINE PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||L_LINE_REC.OPERATION||' '||L_OLD_LINE_REC.OPERATION , 3 ) ;

Line 2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2526: -- end bug 3554060
2527: END IF;
2528:
2529: --END IF;
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2533: RAISE FND_API.G_EXC_ERROR;
2534: END IF;

Line 2531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2527: END IF;
2528:
2529: --END IF;
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2533: RAISE FND_API.G_EXC_ERROR;
2534: END IF;
2535:

Line 2532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2528:
2529: --END IF;
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2533: RAISE FND_API.G_EXC_ERROR;
2534: END IF;
2535:
2536:

Line 2533: RAISE FND_API.G_EXC_ERROR;

2529: --END IF;
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2533: RAISE FND_API.G_EXC_ERROR;
2534: END IF;
2535:
2536:
2537: -- if operation on any attribute is constrained

Line 2539: RAISE FND_API.G_EXC_ERROR;

2535:
2536:
2537: -- if operation on any attribute is constrained
2538: IF l_sec_result = OE_PC_GLOBALS.YES THEN
2539: RAISE FND_API.G_EXC_ERROR;
2540: END IF;
2541:
2542: IF l_debug_level > 0 THEN
2543: oe_debug_pub.add( 'AFTER CHECK_SECURITY'||L_SEC_RESULT ) ;

Line 2578: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2574: , x_return_status => l_return_status);
2575: IF l_debug_level > 0 THEN
2576: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2577: END IF;
2578: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: RAISE FND_API.G_EXC_ERROR;
2582: END IF;

Line 2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2575: IF l_debug_level > 0 THEN
2576: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2577: END IF;
2578: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: RAISE FND_API.G_EXC_ERROR;
2582: END IF;
2583: END IF;*/

Line 2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2576: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2577: END IF;
2578: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: RAISE FND_API.G_EXC_ERROR;
2582: END IF;
2583: END IF;*/
2584: px_line_tbl(l_line_index) := l_line_rec;

Line 2581: RAISE FND_API.G_EXC_ERROR;

2577: END IF;
2578: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: RAISE FND_API.G_EXC_ERROR;
2582: END IF;
2583: END IF;*/
2584: px_line_tbl(l_line_index) := l_line_rec;
2585:

Line 2676: i.line_id = fnd_api.g_miss_num then

2672: -- use the seeded hold_id
2673: l_hold_source_rec.hold_id := G_SEEDED_GSA_HOLD_ID;
2674:
2675: If i.line_id is null or
2676: i.line_id = fnd_api.g_miss_num then
2677: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2678: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
2679: OE_MSG_PUB.Add;
2680: RAISE FND_API.G_EXC_ERROR;

Line 2680: RAISE FND_API.G_EXC_ERROR;

2676: i.line_id = fnd_api.g_miss_num then
2677: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2678: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
2679: OE_MSG_PUB.Add;
2680: RAISE FND_API.G_EXC_ERROR;
2681: End if;
2682:
2683: G_STMT_NO := 'Gsa_Check#20.20';
2684: l_hold_source_rec.hold_entity_id := l_header_id;

Line 2725: If l_x_result_out = FND_API.G_FALSE then

2721: ,x_msg_data => l_x_msg_data
2722: ,x_result_out => l_x_result_out
2723: );
2724:
2725: If l_x_result_out = FND_API.G_FALSE then
2726: IF l_debug_level > 0 THEN
2727: oe_debug_pub.add( 'HOLD LINE WITH HEADER_ID:'||L_HEADER_ID||' LINE_ID: '||I.LINE_ID , 1 ) ;
2728: END IF;
2729: OE_HOLDS_PUB.Apply_Holds(

Line 2737: If l_return_status = FND_API.g_ret_sts_success then

2733: ,x_msg_count => l_x_msg_count
2734: ,x_msg_data => l_x_msg_data
2735: );
2736:
2737: If l_return_status = FND_API.g_ret_sts_success then
2738:
2739: /*FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2740: OE_MSG_PUB.Add;*/
2741: --3021992

Line 2753: RAISE FND_API.G_EXC_ERROR;

2749: Else
2750: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2751: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
2752: OE_MSG_PUB.Add;
2753: RAISE FND_API.G_EXC_ERROR;
2754: End If;
2755: End If; /* check hold */
2756: End if; --for bug 2028480
2757: End if; /* violation action */

Line 2768: l_hold_source_rec.hold_id = fnd_api.g_miss_num then

2764: END IF;
2765: -- release hold if there is one
2766:
2767: If l_hold_source_rec.hold_id is null or
2768: l_hold_source_rec.hold_id = fnd_api.g_miss_num then
2769: G_STMT_NO := 'Gsa_Check#20.25';
2770: -- bug 1381660, duplicate holds with type_code='GSA'
2771: -- use the seeded hold_id
2772: l_hold_source_rec.hold_id := G_SEEDED_GSA_HOLD_ID;

Line 2793: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2789: ,x_msg_data => l_x_msg_data
2790: ,x_result_out => l_x_result_out
2791: );
2792:
2793: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2795: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;

Line 2794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2790: ,x_result_out => l_x_result_out
2791: );
2792:
2793: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2795: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:

Line 2795: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2791: );
2792:
2793: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2795: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:
2799: If l_x_result_out = FND_API.G_TRUE then

Line 2796: RAISE FND_API.G_EXC_ERROR;

2792:
2793: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2795: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:
2799: If l_x_result_out = FND_API.G_TRUE then
2800: IF l_debug_level > 0 THEN

Line 2799: If l_x_result_out = FND_API.G_TRUE then

2795: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798:
2799: If l_x_result_out = FND_API.G_TRUE then
2800: IF l_debug_level > 0 THEN
2801: oe_debug_pub.add( 'RELEASING GSA_HOLD ON LINE'||I.LINE_ID , 3 ) ;
2802: END IF;
2803: -- Hold is found , Release the hold.

Line 2822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2818: ,x_msg_count => l_x_msg_count
2819: ,x_msg_data => l_x_msg_data
2820: );
2821:
2822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2823: IF l_debug_level > 0 THEN
2824: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2825: END IF;
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2823: IF l_debug_level > 0 THEN
2824: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2825: END IF;
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2828: IF l_debug_level > 0 THEN
2829: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2830: END IF;

Line 2827: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2823: IF l_debug_level > 0 THEN
2824: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2825: END IF;
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2828: IF l_debug_level > 0 THEN
2829: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2830: END IF;
2831: RAISE FND_API.G_EXC_ERROR;

Line 2831: RAISE FND_API.G_EXC_ERROR;

2827: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2828: IF l_debug_level > 0 THEN
2829: oe_debug_pub.add( 'ERROR WHILE RELEASING GSA HOLD' ) ;
2830: END IF;
2831: RAISE FND_API.G_EXC_ERROR;
2832: END IF;
2833: End if; -- Release Hold
2834:
2835: END LOOP;

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

2939: BEGIN
2940: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2941:
2942: --changes for bug 4200055
2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

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

3015: l_tax_calculation_flag := l_tax_calc_rec.tax_calculation_flag;
3016: --changes for bug 2505961 Begin
3017: --commented the following for bug7306510 as the sql execution is no more required
3018: /*if update_line.commitment_id is not null
3019: and update_line.commitment_id <> FND_API.G_MISS_NUM then
3020: begin
3021: select nvl(tax_calculation_flag,'N') into l_commt_tax_flag
3022: from ra_cust_trx_types_all ract where ract.cust_trx_type_id =
3023: (

Line 3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3133: p_requesting_entity_id => update_line.line_id,
3134: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3135: x_return_status => l_return_status);
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;

Line 3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3133: p_requesting_entity_id => update_line.line_id,
3134: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3135: x_return_status => l_return_status);
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;
3141: END IF;

Line 3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3134: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3135: x_return_status => l_return_status);
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;
3141: END IF;
3142:

Line 3139: RAISE FND_API.G_EXC_ERROR;

3135: x_return_status => l_return_status);
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;
3141: END IF;
3142:
3143: IF l_debug_level > 0 THEN

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_CALCULATE_COMMITMENT,
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_CALCULATE_COMMITMENT,
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_CALCULATE_COMMITMENT,
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 3219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3215: ,p_request_unique_key1 =>
3216: OE_Order_Cache.g_header_rec.transactional_curr_code
3217: ,x_return_status => l_return_status
3218: );
3219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: END IF;

Line 3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3216: OE_Order_Cache.g_header_rec.transactional_curr_code
3217: ,x_return_status => l_return_status
3218: );
3219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: END IF;
3224:

Line 3221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3217: ,x_return_status => l_return_status
3218: );
3219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: END IF;
3224:
3225: IF update_line.line_set_id IS NOT NULL THEN

Line 3222: RAISE FND_API.G_EXC_ERROR;

3218: );
3219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: END IF;
3224:
3225: IF update_line.line_set_id IS NOT NULL THEN
3226: OE_Delayed_Requests_Pvt.Log_Request

Line 3238: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3234: ,p_param1 =>
3235: OE_Order_Cache.g_header_rec.transactional_curr_code
3236: ,x_return_status => l_return_status
3237: );
3238: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3240: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;

Line 3239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3240: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3236: ,x_return_status => l_return_status
3237: );
3238: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3240: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243: END IF;
3244: END IF;--End for quote/order check

Line 3241: RAISE FND_API.G_EXC_ERROR;

3237: );
3238: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3240: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243: END IF;
3244: END IF;--End for quote/order check
3245: END IF; -- End for log blanket request

Line 3325: raise fnd_api.g_exc_error;

3321: WHEN OTHERS THEN
3322: IF l_debug_level > 0 THEN
3323: oe_debug_pub.add( 'WRONG IN LOG_REQUEST'||SQLERRM , 1 ) ;
3324: END IF;
3325: raise fnd_api.g_exc_error;
3326: End LOG_REQUEST;
3327:
3328: PROCEDURE UPDATE_ORDER_LINES(
3329: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

Line 3436: raise fnd_api.g_exc_unexpected_error;

3432: oe_debug_pub.add('Lock_type:'||i.lock_type||' MODE_HELD:'||i.MODE_HELD||' MODE_REQUESTED'||i.MODE_REQUESTED);
3433: oe_debug_pub.add('Lock_ID1:'||i.Lock_ID1||' Lock_ID2:'||i.Lock_ID2);
3434: End Loop;
3435: */
3436: raise fnd_api.g_exc_unexpected_error;
3437: WHEN OTHERS THEN
3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add( 'WRONG IN UPDATE_ORDER_LINES'||SQLERRM , 1 ) ;
3440: END IF;

Line 3441: raise fnd_api.g_exc_unexpected_error;

3437: WHEN OTHERS THEN
3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add( 'WRONG IN UPDATE_ORDER_LINES'||SQLERRM , 1 ) ;
3440: END IF;
3441: raise fnd_api.g_exc_unexpected_error;
3442: End UPDATE_ORDER_LINES;
3443:
3444: --bug 3882620 Changed the Signature for the procedure Delete_dependents
3445: PROCEDURE DELETE_DEPENDENTS(

Line 3504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3500: IF l_debug_level > 0 THEN
3501: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS IS: ' || L_RETURN_STATUS ) ;
3502: END IF;
3503:
3504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3505:
3506: IF l_debug_level > 0 THEN
3507: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3508: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;

Line 3510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3506: IF l_debug_level > 0 THEN
3507: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3508: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3509: END IF;
3510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3511: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3512: IF l_debug_level > 0 THEN
3513: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' ) ;
3514: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;

Line 3511: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3507: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3508: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3509: END IF;
3510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3511: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3512: IF l_debug_level > 0 THEN
3513: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' ) ;
3514: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3515: END IF;

Line 3516: RAISE FND_API.G_EXC_ERROR;

3512: IF l_debug_level > 0 THEN
3513: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' ) ;
3514: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS', 1 ) ;
3515: END IF;
3516: RAISE FND_API.G_EXC_ERROR;
3517: END IF;
3518: i := p_adj_id_tbl.next(i);
3519: end loop;
3520: --END IF;

Line 3824: RAISE FND_API.G_EXC_ERROR;

3820: oe_debug_pub.add('in lock record exception, someone else working on the row');
3821: END IF;
3822: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3823: OE_MSG_PUB.Add;
3824: RAISE FND_API.G_EXC_ERROR;
3825:
3826: WHEN NO_DATA_FOUND THEN
3827: IF l_debug_level > 0 THEN
3828: oe_debug_pub.add('no_data_found, record lock exception');

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

3826: WHEN NO_DATA_FOUND THEN
3827: IF l_debug_level > 0 THEN
3828: oe_debug_pub.add('no_data_found, record lock exception');
3829: END IF;
3830: --bug 5709185 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3831:
3832: WHEN OTHERS THEN
3833: IF l_debug_level > 0 THEN
3834: oe_debug_pub.add('record lock exception, others');

Line 3836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3832: WHEN OTHERS THEN
3833: IF l_debug_level > 0 THEN
3834: oe_debug_pub.add('record lock exception, others');
3835: END IF;
3836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3837:
3838: END;
3839: --bug 5497035
3840:

Line 4967: raise fnd_api.g_exc_error;

4963: WHEN OTHERS THEN
4964: IF l_debug_level > 0 THEN
4965: oe_debug_pub.add( 'WRONG IN REFRESH_ADJ'||SQLERRM||L_STMT , 1 ) ;
4966: END IF;
4967: raise fnd_api.g_exc_error;
4968:
4969: End REFRESH_ADJS;
4970: --end AG change
4971:

Line 5007: p_header_rec.pricing_date = fnd_api.g_miss_date then

5003: l_req_line_rec.LINE_TYPE_CODE := 'ORDER';
5004: -- Hold the header_id in line_id for 'HEADER' Records
5005: l_req_line_rec.line_id := p_Header_rec.header_id;
5006: if p_header_rec.pricing_date is null or
5007: p_header_rec.pricing_date = fnd_api.g_miss_date then
5008: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
5009: Else
5010: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5011: End If;

Line 5153: p_Line_rec.pricing_date = fnd_api.g_miss_date then

5149: --l_req_line_rec.LIST_LINE_LEVEL_CODE :=p_price_level_code;
5150: l_req_line_rec.LINE_INDEX := px_line_index; --p_line_rec.header_id+p_line_rec.line_id;
5151: l_req_line_rec.LINE_TYPE_CODE := 'LINE';
5152: If p_Line_rec.pricing_date is null or
5153: p_Line_rec.pricing_date = fnd_api.g_miss_date then
5154: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
5155: Else
5156: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_Line_rec.pricing_date;
5157: End If;

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

5187: OE_Order_PUB.g_hdr.transactional_curr_code;
5188: IF l_debug_level > 0 THEN
5189: oe_debug_pub.add( 'UNIT PRICE'||P_LINE_REC.UNIT_LIST_PRICE||L_REQ_LINE_REC.CURRENCY_CODE , 3 ) ;
5190: END IF;
5191: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
5192: l_req_line_rec.UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
5193: Elsif p_line_rec.unit_list_price <> FND_API.G_MISS_NUM THEN
5194: l_req_line_rec.UNIT_PRICE := p_line_rec.unit_list_price;
5195: Else

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

5189: oe_debug_pub.add( 'UNIT PRICE'||P_LINE_REC.UNIT_LIST_PRICE||L_REQ_LINE_REC.CURRENCY_CODE , 3 ) ;
5190: END IF;
5191: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
5192: l_req_line_rec.UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
5193: Elsif p_line_rec.unit_list_price <> FND_API.G_MISS_NUM THEN
5194: l_req_line_rec.UNIT_PRICE := p_line_rec.unit_list_price;
5195: Else
5196: l_req_line_rec.UNIT_PRICE := Null;
5197: End If;

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

5201: --bug 2650505
5202: IF l_debug_level > 0 THEN
5203: oe_debug_pub.add( 'ADJ PRICE 1:'||L_REQ_LINE_REC.ADJUSTED_UNIT_PRICE ) ;
5204: END IF;
5205: if l_req_line_rec.adjusted_unit_price = FND_API.G_MISS_NUM then
5206: l_req_line_rec.adjusted_unit_price := NULL;
5207: end if;
5208: l_req_line_rec.PERCENT_PRICE := p_Line_rec.unit_list_percent;
5209:

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

5209:
5210: -- bug 4642002 begin call OKS API to get the UOM_QUANTITY
5211: -- also changed the logic to pass 0 whenever service duration or period not present
5212: IF (p_line_rec.item_type_code = 'SERVICE') THEN
5213: IF (nvl(p_line_rec.service_start_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN
5214: l_req_line_rec.contract_start_date := p_line_rec.service_start_date;
5215: END IF;
5216:
5217: IF (nvl(p_line_rec.service_end_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN

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

5213: IF (nvl(p_line_rec.service_start_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN
5214: l_req_line_rec.contract_start_date := p_line_rec.service_start_date;
5215: END IF;
5216:
5217: IF (nvl(p_line_rec.service_end_date, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE) THEN
5218: l_req_line_rec.contract_end_date := p_line_rec.service_end_date;
5219: END IF;
5220:
5221: IF (nvl(p_line_rec.service_duration,0) = 0

Line 5222: OR p_line_rec.service_duration = FND_API.G_MISS_NUM

5218: l_req_line_rec.contract_end_date := p_line_rec.service_end_date;
5219: END IF;
5220:
5221: IF (nvl(p_line_rec.service_duration,0) = 0
5222: OR p_line_rec.service_duration = FND_API.G_MISS_NUM
5223: OR nvl(p_line_rec.service_period,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
5224: l_req_line_rec.UOM_QUANTITY := 0;
5225: Elsif (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then
5226: l_req_line_rec.UOM_QUANTITY := p_Line_rec.service_duration;

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

5219: END IF;
5220:
5221: IF (nvl(p_line_rec.service_duration,0) = 0
5222: OR p_line_rec.service_duration = FND_API.G_MISS_NUM
5223: OR nvl(p_line_rec.service_period,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
5224: l_req_line_rec.UOM_QUANTITY := 0;
5225: Elsif (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then
5226: l_req_line_rec.UOM_QUANTITY := p_Line_rec.service_duration;
5227: Elsif (p_line_rec.service_period IS NOT NULL) THEN

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

5266: ELSE
5267: l_req_line_rec.PRICE_FLAG := 'Y';
5268: END IF;
5269: ELSE
5270: If p_Line_rec.calculate_Price_flag = fnd_api.g_miss_char then
5271: l_req_line_rec.PRICE_FLAG := 'Y';
5272: else
5273: l_req_line_rec.PRICE_FLAG := nvl(p_Line_rec.calculate_Price_flag,'Y');
5274: end if;

Line 5307: p_Line_rec.Shipped_quantity = fnd_api.g_miss_num or

5303: End If;
5304: -- Do not execute SHIP event for a line if the line is not ship interfaced.
5305: If l_req_line_rec.PRICE_FLAG = 'Y' and
5306: (p_Line_rec.Shipped_quantity is null or
5307: p_Line_rec.Shipped_quantity = fnd_api.g_miss_num or
5308: p_Line_rec.Shipped_quantity = 0 ) and
5309: p_pricing_events ='SHIP' Then
5310: l_req_line_rec.PRICE_FLAG := 'N';
5311: End If;

Line 5353: or l_req_line_rec.currency_code = FND_API.G_MISS_CHAR

5349: End If;
5350:
5351: -- Copied Logic from populate_temp_Tables
5352: If l_req_line_rec.currency_code is NULL
5353: or l_req_line_rec.currency_code = FND_API.G_MISS_CHAR
5354: THEN
5355: IF l_debug_level > 0 THEN
5356: oe_debug_pub.add( 'CURRENCY CODE IS NULL' , 4 ) ;
5357: END IF;

Line 5358: RAISE FND_API.G_EXC_ERROR;

5354: THEN
5355: IF l_debug_level > 0 THEN
5356: oe_debug_pub.add( 'CURRENCY CODE IS NULL' , 4 ) ;
5357: END IF;
5358: RAISE FND_API.G_EXC_ERROR;
5359: -- Question: Pricing Engine should populate g_currency_code?
5360: End If;
5361:
5362: IF ( l_req_line_rec.PRICING_EFFECTIVE_DATE IS NULL ) THEN

Line 5363: RAISE FND_API.G_EXC_ERROR;

5359: -- Question: Pricing Engine should populate g_currency_code?
5360: End If;
5361:
5362: IF ( l_req_line_rec.PRICING_EFFECTIVE_DATE IS NULL ) THEN
5363: RAISE FND_API.G_EXC_ERROR;
5364: END IF;
5365: -- ?? Pricing Engine should populate G_MIN_PRICING_DATE, G_MAX_PRICING_DATE
5366:
5367: /* IF ( l_req_line_rec.price_flag = 'Y') THEN

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

5426: oe_debug_pub.add('ship_from_org_id :'|| p_line_rec.ship_from_org_id );
5427: END IF;
5428:
5429: IF (p_line_rec.inventory_item_id IS NOT NULL AND
5430: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
5431: (p_line_rec.ship_from_org_id IS NOT NULL AND
5432: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
5433: x_item_rec := OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5434: ,p_line_rec.ship_from_org_id);

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

5428:
5429: IF (p_line_rec.inventory_item_id IS NOT NULL AND
5430: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
5431: (p_line_rec.ship_from_org_id IS NOT NULL AND
5432: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
5433: x_item_rec := OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5434: ,p_line_rec.ship_from_org_id);
5435: END IF;
5436: IF l_debug_level > 0 THEN

Line 5483: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5479: IF l_debug_level > 0 THEN
5480: oe_debug_pub.add('after populating from x_item_rec :');
5481: oe_debug_pub.add('x_secondary_uom_code : '||x_secondary_uom_code);
5482: END IF;
5483: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5484: IF l_debug_level > 0 THEN
5485: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5486: END IF;
5487: oe_msg_pub.transfer_msg_stack;

Line 5488: RAISE FND_API.G_EXC_ERROR;

5484: IF l_debug_level > 0 THEN
5485: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5486: END IF;
5487: oe_msg_pub.transfer_msg_stack;
5488: RAISE FND_API.G_EXC_ERROR;
5489: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5490: IF l_debug_level > 0 THEN
5491: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5492: END IF;

Line 5489: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5485: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5486: END IF;
5487: oe_msg_pub.transfer_msg_stack;
5488: RAISE FND_API.G_EXC_ERROR;
5489: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5490: IF l_debug_level > 0 THEN
5491: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5492: END IF;
5493: oe_msg_pub.transfer_msg_stack;

Line 5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5490: IF l_debug_level > 0 THEN
5491: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5492: END IF;
5493: oe_msg_pub.transfer_msg_stack;
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: END IF;
5496:
5497: l_req_line_rec.LINE_QUANTITY := x_secondary_quantity;
5498:

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

5509: oe_debug_pub.add('reference_line_id :'|| p_line_rec.reference_line_id);
5510: END IF;
5511:
5512: IF p_line_rec.shipped_quantity IS NOT NULL AND
5513: p_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
5514: IF p_line_rec.shipped_quantity2 IS NOT NULL AND
5515: p_line_rec.shipped_quantity2 <> FND_API.G_MISS_NUM AND
5516: p_line_rec.shipped_quantity2 <> 0 THEN
5517: G_catchweight_qty_tbl(px_line_index) := p_line_rec.shipped_quantity2;

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

5511:
5512: IF p_line_rec.shipped_quantity IS NOT NULL AND
5513: p_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
5514: IF p_line_rec.shipped_quantity2 IS NOT NULL AND
5515: p_line_rec.shipped_quantity2 <> FND_API.G_MISS_NUM AND
5516: p_line_rec.shipped_quantity2 <> 0 THEN
5517: G_catchweight_qty_tbl(px_line_index) := p_line_rec.shipped_quantity2;
5518: ELSE -- shipped_quantity2 is null
5519: IF p_line_rec.source_type_code = 'EXTERNAL' OR

Line 5545: RAISE FND_API.G_EXC_ERROR;

5541: oe_debug_pub.add('Shipped_quantity2 is null and not dropship, return- Raise error');
5542: END IF;
5543: FND_MESSAGE.SET_NAME('ONT','ONT_CATCHWEIGHT_QTY2_REQUIRED');
5544: OE_MSG_PUB.Add;
5545: RAISE FND_API.G_EXC_ERROR;
5546: END IF; -- end checks for source_type_code
5547: END IF; -- end checks for shipped_quantity2
5548: END IF; -- end check for shipped_quantity
5549: END IF; -- end checks for discrete catchweight

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

5658: end copy_Line_to_request;
5659:
5660: procedure Populate_Temp_Table
5661: IS
5662: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5663: l_return_status_Text varchar2(240) ;
5664: --
5665: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5666: --

Line 5716: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5712: p_CHARGE_PERIODICITY_CODE => G_CHARGE_PERIODICITY_CODE_TBL, --rc
5713: x_status_code =>l_return_status,
5714: x_status_text =>l_return_status_text);
5715:
5716: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5717: IF l_debug_level > 0 THEN
5718: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
5719: END IF;
5720: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 5723: RAISE FND_API.G_EXC_ERROR;

5719: END IF;
5720: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5721: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
5722: OE_MSG_PUB.Add;
5723: RAISE FND_API.G_EXC_ERROR;
5724: END IF;
5725:
5726: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
5727: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 5761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5757: G_ATTR_PRIMARY_UOM_FLAG_TBL,
5758: l_return_status ,
5759: l_return_status_text );
5760:
5761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5762: IF l_debug_level > 0 THEN
5763: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
5764: END IF;
5765: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 5768: raise fnd_api.g_exc_unexpected_error;

5764: END IF;
5765: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5766: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
5767: OE_MSG_PUB.Add;
5768: raise fnd_api.g_exc_unexpected_error;
5769: END IF;
5770:
5771: END IF;
5772: IF l_debug_level > 0 THEN

Line 5778: RAISE FND_API.G_EXC_ERROR;

5774: END IF;
5775:
5776: EXCEPTION
5777: WHEN OTHERS THEN
5778: RAISE FND_API.G_EXC_ERROR;
5779: END POPULATE_TEMP_TABLE;
5780:
5781: -- This function is to find out whether it's better to query all lines in the order
5782: -- or query changed lines one by one

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

5874: oe_debug_pub.add('link to line id:'|| l_line_rec.link_to_line_id);
5875:
5876: LOOP
5877: IF l_line_rec.link_to_line_id IS NOT null
5878: and l_line_rec.link_to_line_id <> FND_API.G_MISS_NUM
5879: and l_line_rec.link_to_line_id <> l_line_rec.line_id
5880: and NOT OE_LINE_ADJ_UTIL.G_CHANGED_LINE_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT))
5881: and NOT G_ADDED_PARENT_TBL.exists(mod(l_line_rec.link_to_line_id,G_BINARY_LIMIT)) THEN
5882: --child line has changed, need to send in parent lines to be repriced.

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

5918:
5919: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
5920: )
5921: is
5922: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5923: l_return_status_Text varchar2(240) ;
5924: l_header_rec OE_Order_PUB.Header_Rec_Type;
5925: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5926:

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

5976:
5977: G_STMT_NO := 'calculate_adjustments#10';
5978:
5979:
5980: if (p_line_id is null or p_line_id = FND_API.G_MISS_NUM)
5981: and ( p_header_id is null or p_header_id = FND_API.G_MISS_NUM)
5982: and px_line_Tbl.count =0
5983: and p_control_rec.p_use_current_header = FALSE
5984: then

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

5977: G_STMT_NO := 'calculate_adjustments#10';
5978:
5979:
5980: if (p_line_id is null or p_line_id = FND_API.G_MISS_NUM)
5981: and ( p_header_id is null or p_header_id = FND_API.G_MISS_NUM)
5982: and px_line_Tbl.count =0
5983: and p_control_rec.p_use_current_header = FALSE
5984: then
5985: l_return_status := FND_API.G_RET_STS_ERROR;

Line 5985: l_return_status := FND_API.G_RET_STS_ERROR;

5981: and ( p_header_id is null or p_header_id = FND_API.G_MISS_NUM)
5982: and px_line_Tbl.count =0
5983: and p_control_rec.p_use_current_header = FALSE
5984: then
5985: l_return_status := FND_API.G_RET_STS_ERROR;
5986:
5987: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5988: THEN
5989:

Line 5994: RAISE FND_API.G_EXC_ERROR;

5990: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
5991: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
5992: OE_MSG_PUB.Add;
5993: END IF;
5994: RAISE FND_API.G_EXC_ERROR;
5995: end if;
5996:
5997: G_STMT_NO := 'calculate_adjustments#20';
5998: if p_Line_id is not null and p_Header_id is not null then

Line 6005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6001: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
6002: 'oe_line_adj.calulate_adjustments'
6003: ,'Keys are mutually exclusive');
6004: END IF;
6005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6006: end if;
6007:
6008: -- Query the header Record
6009: if p_header_id is not null and p_Header_id <> FND_API.G_MISS_NUM then

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

6005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6006: end if;
6007:
6008: -- Query the header Record
6009: if p_header_id is not null and p_Header_id <> FND_API.G_MISS_NUM then
6010:
6011: G_STMT_NO := 'calculate_adjustments#30';
6012:
6013: Begin

Line 6208: RAISE FND_API.G_EXC_ERROR;

6204: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
6205: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
6206: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
6207: OE_MSG_PUB.Add;
6208: RAISE FND_API.G_EXC_ERROR;
6209: END;
6210: End If;
6211: --End 2740845
6212:

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

6211: --End 2740845
6212:
6213: -- Populate that Global Structure
6214: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6215: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6216: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6217: End If;
6218:
6219:

Line 6234: FND_API.G_MISS_NUM and

6230: --RT}
6231:
6232:
6233: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>
6234: FND_API.G_MISS_NUM and
6235: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
6236: Then
6237: /* Added the following if condition for fixing the bug 1828553 */
6238: /* If the service reference context is ORDER, then the service_reference*/

Line 6254: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

6250: , p_reference_line_id => l_Line_Tbl(line_Tbl_Index).service_reference_line_id
6251: , p_customer_id => l_Line_Tbl(line_Tbl_Index).sold_to_org_id
6252: , x_cust_product_line_id => l_order_line_id
6253: );
6254: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6255: oe_debug_pub.add('1828553: Success');
6256: oe_debug_pub.add('1828553: Service line id is ' || l_order_line_id)
6257: ;
6258: l_service_reference_line_id := l_order_line_id;

Line 6356: 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 THEN

6352:
6353: --RT{
6354: IF p_pricing_events = 'RETROBILL' and l_line_tbl(line_tbl_index).retrobill_request_id IS NULL
6355: OR
6356: 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 THEN
6357: --Do nothing for these invalid combinations
6358: --RETROBILL event must have retrobill_request_id
6359: --Request None retrobill event with retrobill_request_id should be ignored
6360: oe_debug_pub.add('VOPRB:event'||p_pricing_events||'retrobill id:'||l_line_tbl(line_tbl_index).retrobill_request_id);

Line 6647: when FND_API.G_EXC_ERROR then

6643: x_header_Rec := OE_Order_PUB.g_hdr;
6644: px_line_tbl := l_line_tbl;
6645:
6646: exception
6647: when FND_API.G_EXC_ERROR then
6648: oe_debug_pub.add('error in calculate adjustments'||G_STMT_NO, 2);
6649: RAISE FND_API.G_EXC_ERROR;
6650: when others then
6651: oe_debug_pub.add('others error in calculate adjustments'||G_STMT_NO,2);

Line 6649: RAISE FND_API.G_EXC_ERROR;

6645:
6646: exception
6647: when FND_API.G_EXC_ERROR then
6648: oe_debug_pub.add('error in calculate adjustments'||G_STMT_NO, 2);
6649: RAISE FND_API.G_EXC_ERROR;
6650: when others then
6651: oe_debug_pub.add('others error in calculate adjustments'||G_STMT_NO,2);
6652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6653: End Calculate_Adjustments;

Line 6652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6648: oe_debug_pub.add('error in calculate adjustments'||G_STMT_NO, 2);
6649: RAISE FND_API.G_EXC_ERROR;
6650: when others then
6651: oe_debug_pub.add('others error in calculate adjustments'||G_STMT_NO,2);
6652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6653: End Calculate_Adjustments;
6654:
6655:
6656: Procedure Call_Pricing_Engine(

Line 6749: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6745: ,x_return_status =>x_return_status
6746: ,x_return_status_Text =>l_return_status_Text
6747: );
6748:
6749: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6750: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6751: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6752: OE_MSG_PUB.Add;
6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6749: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6750: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6751: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6752: OE_MSG_PUB.Add;
6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6755: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6756: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6757: OE_MSG_PUB.Add;

Line 6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6750: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6751: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6752: OE_MSG_PUB.Add;
6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6755: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6756: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6757: OE_MSG_PUB.Add;
6758: RAISE FND_API.G_EXC_ERROR;

Line 6758: RAISE FND_API.G_EXC_ERROR;

6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6755: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6756: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6757: OE_MSG_PUB.Add;
6758: RAISE FND_API.G_EXC_ERROR;
6759: END IF;
6760:
6761: END Call_Pricing_Engine;
6762:

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

6800: ,x_result_out => l_x_result_out
6801:
6802: );
6803:
6804: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
6805: IF l_debug_level > 0 THEN
6806: oe_debug_pub.add(' OE_HOLD_PUB.Check_Holds returns unexpected error!');
6807: END IF;
6808: RAISE FND_API.G_EXC_ERROR;

Line 6808: RAISE FND_API.G_EXC_ERROR;

6804: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
6805: IF l_debug_level > 0 THEN
6806: oe_debug_pub.add(' OE_HOLD_PUB.Check_Holds returns unexpected error!');
6807: END IF;
6808: RAISE FND_API.G_EXC_ERROR;
6809: null;
6810: END IF;
6811: IF l_x_result_out = FND_API.G_FALSE THEN
6812: OE_HOLDS_PUB.Apply_Holds(

Line 6811: IF l_x_result_out = FND_API.G_FALSE THEN

6807: END IF;
6808: RAISE FND_API.G_EXC_ERROR;
6809: null;
6810: END IF;
6811: IF l_x_result_out = FND_API.G_FALSE THEN
6812: OE_HOLDS_PUB.Apply_Holds(
6813: p_api_version => 1.0
6814: ,p_hold_source_rec => l_hold_source_rec
6815: -- ,p_header_id => l_line_rec.header_id

Line 6823: IF l_return_status = FND_API.g_ret_sts_success then

6819: ,x_msg_data => l_x_msg_data
6820: );
6821: END IF;
6822:
6823: IF l_return_status = FND_API.g_ret_sts_success then
6824: IF l_debug_level > 0 THEN
6825: oe_debug_pub.add('just before showing formula error',1);
6826: END IF;
6827:

Line 6833: WHEN FND_API.G_EXC_ERROR then

6829: FND_MESSAGE.SET_TOKEN('ERR_TEXT',pmsg);
6830: OE_MSG_PUB.Add;
6831: End if;
6832: exception
6833: WHEN FND_API.G_EXC_ERROR then
6834: null;
6835: end;
6836:
6837:

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

7016: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7017: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7018: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7019: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7020: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7021: vmsg := FND_MESSAGE.GET;
7022: else
7023: OE_MSG_PUB.Add;
7024: end if;

Line 7037: FND_API.G_RET_STS_UNEXP_ERROR,

7033: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7034: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7035: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 7038: FND_API.G_RET_STS_ERROR,

7034: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7035: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

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

7070: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7071: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
7072: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
7073: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7074: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7075: vmsg := FND_MESSAGE.GET;
7076: ELSE
7077: OE_MSG_PUB.Add;
7078: END IF;

Line 7101: RAISE FND_API.G_EXC_ERROR;

7097: END IF;
7098: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
7100: OE_MSG_PUB.ADD;
7101: RAISE FND_API.G_EXC_ERROR;
7102: End If;
7103: IF l_debug_level > 0 THEN
7104: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||':'||L_LINE_REC.UNIT_LIST_PRICE ) ;
7105: END IF;

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

7125: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7126: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7127: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7128: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7129: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7130: vmsg := FND_MESSAGE.GET;
7131: else
7132: OE_MSG_PUB.Add;
7133: end if;

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

7140: END IF;
7141: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7142: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7143: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7144: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7145: vmsg := FND_MESSAGE.GET;
7146: else
7147: OE_MSG_PUB.Add;
7148: end if;

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

7149: else
7150: OE_MSG_PUB.Add;
7151: end if;
7152: Elsif wrong_line.pricing_status_code in
7153: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7154: FND_API.G_RET_STS_ERROR)
7155: then
7156: IF l_debug_level > 0 THEN
7157: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

Line 7154: FND_API.G_RET_STS_ERROR)

7150: OE_MSG_PUB.Add;
7151: end if;
7152: Elsif wrong_line.pricing_status_code in
7153: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7154: FND_API.G_RET_STS_ERROR)
7155: then
7156: IF l_debug_level > 0 THEN
7157: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7158: END IF;

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

7158: END IF;
7159: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7160: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7161: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7162: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7163: vmsg := FND_MESSAGE.GET;
7164: else
7165: OE_MSG_PUB.Add;
7166: end if;

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

7174: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
7175: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7176: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7177: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7178: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7179: vmsg := FND_MESSAGE.GET;
7180: else
7181: OE_MSG_PUB.Add;
7182: end if;

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

7222: instr(wrong_line.status_text,',')+1);
7223: End;
7224: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
7225: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7226: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7227: vmsg := FND_MESSAGE.GET;
7228: else
7229: OE_MSG_PUB.Add;
7230: end if;

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

7238: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
7239: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
7240: wrong_line.status_text);
7241: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7242: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7243: vmsg := FND_MESSAGE.GET;
7244: else
7245: OE_MSG_PUB.Add;
7246: end if;

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

7254: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
7255: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
7256: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7257: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7258: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7259: vmsg := FND_MESSAGE.GET;
7260: else
7261: OE_MSG_PUB.Add;
7262: end if;

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

7270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
7271: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7272: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7273: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7274: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7275: vmsg := FND_MESSAGE.GET;
7276: else
7277: OE_MSG_PUB.Add;
7278: end if;

Line 7284: --RAISE FND_API.G_EXC_ERROR;

7280: OE_MSG_PUB.Add;
7281: end if;
7282: End if; /* wrong pricing status code */
7283:
7284: --RAISE FND_API.G_EXC_ERROR;
7285: --btea begin if do not write to db, we still need to
7286: --return line and status code to the caller
7287: If Not p_control_rec.p_write_to_db Then
7288: l_line_rec.Header_id := p_header_rec.Header_id;

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

7351: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;
7352: END IF;
7353:
7354: --place the line on invoicing hold to avoid stuck order it the ship quatity is there.
7355: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
7356: vmsg := FND_MESSAGE.GET;
7357: oe_debug_pub.add('vmsg = '||vmsg,1);
7358: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7359: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

Line 7370: RAISE FND_API.G_EXC_ERROR;

7366: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7367: END IF;
7368:
7369: ELSE
7370: RAISE FND_API.G_EXC_ERROR;
7371: END IF;
7372:
7373: end if;
7374:

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

7389: END IF; --end if for 'ORDER' line_type_code
7390:
7391: If l_invalid_line = 'Y' Then
7392: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7393: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7394: IF l_debug_level > 0 THEN
7395: oe_debug_pub.add('vmsg = '||vmsg,1);
7396: END IF;
7397: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);

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

7469: IF l_debug_level > 0 THEN
7470: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
7471: END IF;
7472: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7473: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then
7474: vmsg := FND_MESSAGE.GET;
7475: pricing_errors_hold(book_line.header_id,book_line.line_id,vmsg);
7476: else
7477: OE_MSG_PUB.ADD;

Line 7482: RAISE FND_API.G_EXC_ERROR;

7478: l_temp_line_rec.line_id := book_line.line_id;
7479: l_temp_line_rec.ordered_quantity := book_line.line_quantity;
7480: l_temp_line_rec.pricing_quantity := book_line.priced_quantity;
7481: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
7482: RAISE FND_API.G_EXC_ERROR;
7483: end if;
7484: else
7485: OE_MSG_PUB.ADD;
7486: end if;

Line 7496: RAISE FND_API.G_EXC_ERROR;

7492: OE_MSG_PUB.ADD;
7493: IF l_debug_level > 0 THEN
7494: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
7495: END IF;
7496: RAISE FND_API.G_EXC_ERROR;
7497: END IF;
7498:
7499: End loop; /* wrong booked lines */
7500: IF l_debug_level > 0 THEN

Line 7545: x_return_status := FND_API.G_RET_STS_SUCCESS;

7541: BEGIN
7542:
7543: SAVEPOINT PROCESS_ADJUSTMENTS;
7544: l_old_line_tbl := px_line_Tbl;
7545: x_return_status := FND_API.G_RET_STS_SUCCESS;
7546: Report_Engine_Errors(x_return_status
7547: , p_control_rec
7548: , px_line_tbl
7549: , p_header_rec);

Line 7550: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7546: Report_Engine_Errors(x_return_status
7547: , p_control_rec
7548: , px_line_tbl
7549: , p_header_rec);
7550: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7552: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7553: RAISE FND_API.G_EXC_ERROR;
7554: END IF;

Line 7551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7547: , p_control_rec
7548: , px_line_tbl
7549: , p_header_rec);
7550: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7552: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7553: RAISE FND_API.G_EXC_ERROR;
7554: END IF;
7555:

Line 7552: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7548: , px_line_tbl
7549: , p_header_rec);
7550: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7552: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7553: RAISE FND_API.G_EXC_ERROR;
7554: END IF;
7555:
7556: IF p_control_rec.p_write_to_db THEN

Line 7553: RAISE FND_API.G_EXC_ERROR;

7549: , p_header_rec);
7550: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7552: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7553: RAISE FND_API.G_EXC_ERROR;
7554: END IF;
7555:
7556: IF p_control_rec.p_write_to_db THEN
7557: IF l_debug_level > 0 THEN

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

7631: oe_debug_pub.add( 'VOPRB RECURSION MODE'||OE_GLOBALS.G_RECURSION_MODE ) ;
7632: END IF;
7633:
7634: -- 2366123: execute delayed requests only when not called by UI
7635: -- IF (OE_GLOBALS.G_RECURSION_MODE <> FND_API.G_TRUE
7636: IF (NOT OE_GLOBALS.G_UI_FLAG AND p_control_rec.p_write_to_db = TRUE AND l_num_changed_lines > 0 ) THEN
7637: l_process_requests := TRUE;
7638: l_old_line_tbl := px_line_tbl;
7639: END IF;

Line 7668: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

7664: IF l_debug_level > 0 THEN
7665: oe_debug_pub.add( 'RETRURNED FROM PROCESS_REQUEST AND NOTIFY : '||X_RETURN_STATUS , 3 ) ;
7666: END IF;
7667:
7668: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7669: RAISE FND_API.G_EXC_ERROR;
7670: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7672: END IF;

Line 7669: RAISE FND_API.G_EXC_ERROR;

7665: oe_debug_pub.add( 'RETRURNED FROM PROCESS_REQUEST AND NOTIFY : '||X_RETURN_STATUS , 3 ) ;
7666: END IF;
7667:
7668: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7669: RAISE FND_API.G_EXC_ERROR;
7670: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7672: END IF;
7673: END IF;

Line 7670: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7666: END IF;
7667:
7668: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7669: RAISE FND_API.G_EXC_ERROR;
7670: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7672: END IF;
7673: END IF;
7674:

Line 7671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7667:
7668: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7669: RAISE FND_API.G_EXC_ERROR;
7670: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7672: END IF;
7673: END IF;
7674:
7675: /*AS per Jyothi Narayan, Process_Requests_And_Notify has notify call. No extra call is needed

Line 7687: , p_init_msg_list => FND_API.G_FALSE

7683:
7684: End If;
7685: OE_SERVICE_UTIL.Notify_OC
7686: ( p_api_version_number => 1.0
7687: , p_init_msg_list => FND_API.G_FALSE
7688: , x_return_status => l_return_status
7689: , x_msg_count => l_msg_count
7690: , x_msg_data => l_msg_data
7691: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl

Line 7697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7693:
7694: IF l_debug_level > 0 THEN
7695: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7696: END IF;
7697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
7700: RAISE FND_API.G_EXC_ERROR;
7701: END IF;

Line 7698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7694: IF l_debug_level > 0 THEN
7695: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7696: END IF;
7697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
7700: RAISE FND_API.G_EXC_ERROR;
7701: END IF;
7702: END IF;

Line 7699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

7695: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7696: END IF;
7697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
7700: RAISE FND_API.G_EXC_ERROR;
7701: END IF;
7702: END IF;
7703:

Line 7700: RAISE FND_API.G_EXC_ERROR;

7696: END IF;
7697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
7700: RAISE FND_API.G_EXC_ERROR;
7701: END IF;
7702: END IF;
7703:
7704: END IF;

Line 7709: WHEN FND_API.G_EXC_ERROR THEN

7705: END IF; */
7706:
7707:
7708: Exception
7709: WHEN FND_API.G_EXC_ERROR THEN
7710: x_return_status := FND_API.G_RET_STS_ERROR;
7711:
7712: IF l_debug_level > 0 THEN
7713: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback' , 1 ) ;

Line 7710: x_return_status := FND_API.G_RET_STS_ERROR;

7706:
7707:
7708: Exception
7709: WHEN FND_API.G_EXC_ERROR THEN
7710: x_return_status := FND_API.G_RET_STS_ERROR;
7711:
7712: IF l_debug_level > 0 THEN
7713: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback' , 1 ) ;
7714: END IF;

Line 7717: RAISE FND_API.G_EXC_ERROR;

7713: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback' , 1 ) ;
7714: END IF;
7715: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
7716:
7717: RAISE FND_API.G_EXC_ERROR;
7718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7720:
7721: IF l_debug_level > 0 THEN

Line 7718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7714: END IF;
7715: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
7716:
7717: RAISE FND_API.G_EXC_ERROR;
7718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7720:
7721: IF l_debug_level > 0 THEN
7722: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback' , 1 ) ;

Line 7719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7715: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
7716:
7717: RAISE FND_API.G_EXC_ERROR;
7718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7720:
7721: IF l_debug_level > 0 THEN
7722: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback' , 1 ) ;
7723: END IF;

Line 7725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7721: IF l_debug_level > 0 THEN
7722: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback' , 1 ) ;
7723: END IF;
7724: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
7725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7726: WHEN OTHERS THEN
7727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7728: IF l_debug_level > 0 THEN
7729: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS with rollback' , 1 ) ;

Line 7727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7723: END IF;
7724: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
7725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7726: WHEN OTHERS THEN
7727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7728: IF l_debug_level > 0 THEN
7729: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS with rollback' , 1 ) ;
7730: END IF;
7731: IF l_debug_level > 0 THEN

Line 7748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7744: IF l_debug_level > 0 THEN
7745: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS with rollback' , 1 ) ;
7746: END IF;
7747: ROLLBACK TO SAVEPOINT PROCESS_ADJUSTMENTS;
7748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7749: IF l_debug_level > 0 THEN
7750: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS' , 1 ) ;
7751: END IF;
7752: END Process_Adjustments;

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

7784:
7785: oe_debug_pub.add('Retrobill Operation:'||g_retrobill_operation);
7786: --RT}
7787:
7788: If OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE Then
7789: G_DEBUG := TRUE;
7790: IF l_debug_level > 0 THEN
7791: oe_debug_pub.add( 'BCT G_DEBUG IS:'||OE_DEBUG_PUB.G_DEBUG ) ;
7792: END IF;

Line 7813: x_return_status := FND_API.G_RET_STS_SUCCESS;

7809:
7810: IF l_debug_level > 0 THEN
7811: oe_debug_pub.add( 'PRICE_LINE:'||P_HEADER_ID||'+'||P_LINE_ID||'OF EVENT '||P_PRICING_EVENTS , 1 ) ;
7812: END IF;
7813: x_return_status := FND_API.G_RET_STS_SUCCESS;
7814:
7815: calculate_adjustments
7816: (x_return_status => x_return_status,
7817: p_line_Id => p_line_Id,

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

7826:
7827:
7828: --l_Control_Rec.calculate_flag := 'N';
7829: -- Do no proceed , if there are no order lines
7830: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7831: IF l_debug_level > 0 THEN
7832: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
7833: END IF;
7834: raise fnd_api.g_exc_error;

Line 7834: raise fnd_api.g_exc_error;

7830: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7831: IF l_debug_level > 0 THEN
7832: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
7833: END IF;
7834: raise fnd_api.g_exc_error;
7835: END IF;
7836:
7837: If x_return_status = 'NOOP' Then
7838: IF l_debug_level > 0 THEN

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

7849: Call_Pricing_Engine(p_Control_Rec
7850: ,p_Pricing_Events
7851: ,x_return_status
7852: );
7853: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7854: IF l_debug_level > 0 THEN
7855: oe_debug_pub.add( 'PRICING ENGINE ERROR' ) ;
7856: END IF;
7857: raise fnd_api.g_exc_error;

Line 7857: raise fnd_api.g_exc_error;

7853: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7854: IF l_debug_level > 0 THEN
7855: oe_debug_pub.add( 'PRICING ENGINE ERROR' ) ;
7856: END IF;
7857: raise fnd_api.g_exc_error;
7858: END IF;
7859:
7860: IF l_debug_level > 0 THEN
7861: oe_debug_pub.add( 'BEFORE OE_ORDER_PRICE_PVT.PROCESS_ADJUSTMENTS' , 1 ) ;

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

7872: px_line_Tbl => px_Line_Tbl,
7873: p_pricing_events => p_pricing_events
7874: );
7875:
7876: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7877: IF l_debug_level > 0 THEN
7878: oe_debug_pub.add( 'PROCESS ADJUSTMENTS ERROR' ) ;
7879: END IF;
7880: raise fnd_api.g_exc_error;

Line 7880: raise fnd_api.g_exc_error;

7876: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7877: IF l_debug_level > 0 THEN
7878: oe_debug_pub.add( 'PROCESS ADJUSTMENTS ERROR' ) ;
7879: END IF;
7880: raise fnd_api.g_exc_error;
7881: END IF;
7882: --reseting global structure after engine call
7883: OE_Order_PUB.G_LINE := NULL;
7884: OE_Order_PUB.G_HDR := NULL;

Line 7891: WHEN FND_API.G_EXC_ERROR THEN

7887: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
7888: END IF;
7889:
7890: Exception
7891: WHEN FND_API.G_EXC_ERROR THEN
7892:
7893: --reseting global structure after engine call
7894: OE_Order_PUB.G_LINE := NULL;
7895: OE_Order_PUB.G_HDR := NULL;

Line 7896: x_return_status := FND_API.G_RET_STS_ERROR;

7892:
7893: --reseting global structure after engine call
7894: OE_Order_PUB.G_LINE := NULL;
7895: OE_Order_PUB.G_HDR := NULL;
7896: x_return_status := FND_API.G_RET_STS_ERROR;
7897:
7898: IF l_debug_level > 0 THEN
7899: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
7900: END IF;

Line 7901: RAISE FND_API.G_EXC_ERROR;

7897:
7898: IF l_debug_level > 0 THEN
7899: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
7900: END IF;
7901: RAISE FND_API.G_EXC_ERROR;
7902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7903:
7904: --reseting global structure after engine call
7905: OE_Order_PUB.G_LINE := NULL;

Line 7902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7898: IF l_debug_level > 0 THEN
7899: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
7900: END IF;
7901: RAISE FND_API.G_EXC_ERROR;
7902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7903:
7904: --reseting global structure after engine call
7905: OE_Order_PUB.G_LINE := NULL;
7906: OE_Order_PUB.G_HDR := NULL;

Line 7907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7903:
7904: --reseting global structure after engine call
7905: OE_Order_PUB.G_LINE := NULL;
7906: OE_Order_PUB.G_HDR := NULL;
7907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7908: IF l_debug_level > 0 THEN
7909: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
7910: END IF;
7911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7908: IF l_debug_level > 0 THEN
7909: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
7910: END IF;
7911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7912: WHEN OTHERS THEN
7913:
7914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7915: --reseting global structure after engine call

Line 7914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7910: END IF;
7911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7912: WHEN OTHERS THEN
7913:
7914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7915: --reseting global structure after engine call
7916: OE_Order_PUB.G_LINE := NULL;
7917: OE_Order_PUB.G_HDR := NULL;
7918: IF l_debug_level > 0 THEN

Line 7936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7932:
7933: IF l_debug_level > 0 THEN
7934: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
7935: END IF;
7936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7937:
7938: IF l_debug_level > 0 THEN
7939: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
7940: END IF;