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

APPS.OE_ORDER_PRICE_PVT dependencies on OE_GLOBALS

Line 17: G_IPL_ERRORS_TBL OE_GLOBALS.Number_Tbl_Type;

13: --G_LIST_PRICE_OVERRIDE Varchar2(30)
14: -- := nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE');
15:
16: g_request_id number := null;
17: G_IPL_ERRORS_TBL OE_GLOBALS.Number_Tbl_Type;
18: -- G_BINARY_LIMIT CONSTANT NUMBER:=2147483647; -- Bug 8631297
19: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8631297
20:
21: --rc

Line 19: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8631297

15:
16: g_request_id number := null;
17: G_IPL_ERRORS_TBL OE_GLOBALS.Number_Tbl_Type;
18: -- G_BINARY_LIMIT CONSTANT NUMBER:=2147483647; -- Bug 8631297
19: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8631297
20:
21: --rc
22: G_CHARGE_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
23:

Line 25: G_ADDED_PARENT_TBL OE_GLOBALS.Number_Tbl_Type;

21: --rc
22: G_CHARGE_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
23:
24: --
25: G_ADDED_PARENT_TBL OE_GLOBALS.Number_Tbl_Type;
26:
27: -- AG Changes
28: TYPE PLS_INTEGER_TYPE IS TABLE OF PLS_INTEGER INDEX BY BINARY_INTEGER;
29: TYPE NUMBER_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 246: l_org_id := OE_GLOBALS.G_ORG_ID;

242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245:
246: l_org_id := OE_GLOBALS.G_ORG_ID;
247: IF l_org_id IS NULL THEN
248: OE_GLOBALS.Set_Context;
249: l_org_id := OE_GLOBALS.G_ORG_ID;
250: END IF;

Line 248: OE_GLOBALS.Set_Context;

244: BEGIN
245:
246: l_org_id := OE_GLOBALS.G_ORG_ID;
247: IF l_org_id IS NULL THEN
248: OE_GLOBALS.Set_Context;
249: l_org_id := OE_GLOBALS.G_ORG_ID;
250: END IF;
251:
252: -- aksingh use global record if exists for header_id

Line 249: l_org_id := OE_GLOBALS.G_ORG_ID;

245:
246: l_org_id := OE_GLOBALS.G_ORG_ID;
247: IF l_org_id IS NULL THEN
248: OE_GLOBALS.Set_Context;
249: l_org_id := OE_GLOBALS.G_ORG_ID;
250: END IF;
251:
252: -- aksingh use global record if exists for header_id
253: IF oe_order_cache.g_header_rec.header_id = p_header_id THEN

Line 470: oe_debug_pub.add( 'G_RECURSION_MODE:'||OE_GLOBALS.G_RECURSION_MODE ) ;

466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'IN QUERY LINES. GET_QP_STATUS:'||QP_UTIL.GET_QP_STATUS ) ;
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

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 510: l_org_id := OE_GLOBALS.G_ORG_ID;

506: l_entity := 'H';
507:
508: END IF;
509:
510: l_org_id := OE_GLOBALS.G_ORG_ID;
511: if l_org_id IS NULL THEN
512: OE_GLOBALS.Set_Context;
513: l_org_id := OE_GLOBALS.G_ORG_ID;
514: end if;

Line 512: OE_GLOBALS.Set_Context;

508: END IF;
509:
510: l_org_id := OE_GLOBALS.G_ORG_ID;
511: if l_org_id IS NULL THEN
512: OE_GLOBALS.Set_Context;
513: l_org_id := OE_GLOBALS.G_ORG_ID;
514: end if;
515:
516: IF l_debug_level > 0 THEN

Line 513: l_org_id := OE_GLOBALS.G_ORG_ID;

509:
510: l_org_id := OE_GLOBALS.G_ORG_ID;
511: if l_org_id IS NULL THEN
512: OE_GLOBALS.Set_Context;
513: l_org_id := OE_GLOBALS.G_ORG_ID;
514: end if;
515:
516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.QUERY_LINES '||TO_CHAR ( L_ORG_ID ) , 1 ) ;

Line 2287: l_control_rec OE_GLOBALS.Control_Rec_Type;

2283: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
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;

Line 2352: IF l_line_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE, OE_GLOBALS.G_OPR_INSERT) THEN

2348:
2349: --bug 3702538
2350: If nvl(l_line_rec.price_list_id,-9999) <> nvl(px_line_tbl(l_line_index).price_list_id,-9999) THEN
2351: l_call_lines := TRUE;
2352: IF l_line_rec.operation NOT IN (OE_GLOBALS.G_OPR_CREATE, OE_GLOBALS.G_OPR_INSERT) THEN
2353: l_check_sec := TRUE;
2354: END IF;
2355: End If;
2356: --bug 3702538

Line 2389: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;

2385: l_control_rec.change_attributes := TRUE;
2386: l_control_rec.check_security := l_check_sec;
2387: l_control_rec.validate_entity := FALSE;
2388: l_control_rec.write_to_DB := FALSE;
2389: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
2390: l_control_rec.process := FALSE;
2391:
2392: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
2393:

Line 2392: OE_GLOBALS.G_PRICING_RECURSION := 'Y';

2388: l_control_rec.write_to_DB := FALSE;
2389: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
2390: l_control_rec.process := FALSE;
2391:
2392: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
2393:
2394: IF l_debug_level > 0 THEN
2395: oe_debug_pub.add( 'validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;
2396: END IF;

Line 2395: oe_debug_pub.add( 'validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;

2391:
2392: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
2393:
2394: IF l_debug_level > 0 THEN
2395: oe_debug_pub.add( 'validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;
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

Line 2397: l_validate_desc_flex := OE_GLOBALS.g_validate_desc_flex;

2393:
2394: IF l_debug_level > 0 THEN
2395: oe_debug_pub.add( 'validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;
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

Line 2398: OE_GLOBALS.g_validate_desc_flex := 'N';

2394: IF l_debug_level > 0 THEN
2395: oe_debug_pub.add( 'validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;
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

Line 2411: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;

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) ;
2414: END IF;
2415: OE_GLOBALS.G_PRICING_RECURSION := 'N';

Line 2413: oe_debug_pub.add( 'reset validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;

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) ;
2414: END IF;
2415: OE_GLOBALS.G_PRICING_RECURSION := 'N';
2416: END IF;
2417: --bug 3702538

Line 2415: OE_GLOBALS.G_PRICING_RECURSION := 'N';

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) ;
2414: END IF;
2415: OE_GLOBALS.G_PRICING_RECURSION := 'N';
2416: END IF;
2417: --bug 3702538
2418: END POPULATE_LINE_TBL;
2419:

Line 2496: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

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 ) ;
2500: END IF;

Line 2502: --IF (NOT OE_GLOBALS.G_HEADER_CREATED ) THEN

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 ) ;
2500: END IF;
2501:
2502: --IF (NOT OE_GLOBALS.G_HEADER_CREATED ) THEN
2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add(' Checking Security');
2505: END IF;
2506:

Line 2511: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2507: --bug 2823794, the security api doesn't like delete operation.
2508: --it will raise error if a delete operation is passed.
2509: --therefore we check, if delete or create operation, do not call the security api.
2510:
2511: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2512:
2513: -- bug 3554060
2514: l_old_change_reason := l_line_rec.change_reason;
2515: l_old_change_comments := l_line_rec.change_comments;

Line 3091: IF (OE_GLOBALS.G_UI_FLAG)

3087: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR TAXING' ) ;
3088: END IF;
3089: l_commt_tax_flag := 'N' ; --bug 2505961
3090: -- lkxu, make changes for bug 1581188
3091: IF (OE_GLOBALS.G_UI_FLAG)
3092: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
3093: OE_delayed_requests_Pvt.log_request(
3094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3095: p_entity_id => update_line.line_id,

Line 3094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3090: -- lkxu, make changes for bug 1581188
3091: IF (OE_GLOBALS.G_UI_FLAG)
3092: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
3093: OE_delayed_requests_Pvt.log_request(
3094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3095: p_entity_id => update_line.line_id,
3096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3097: p_requesting_entity_id => update_line.line_id,
3098: p_request_type => OE_GLOBALS.g_tax_line,

Line 3096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3092: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
3093: OE_delayed_requests_Pvt.log_request(
3094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3095: p_entity_id => update_line.line_id,
3096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3097: p_requesting_entity_id => update_line.line_id,
3098: p_request_type => OE_GLOBALS.g_tax_line,
3099: x_return_status => l_return_status);
3100: ELSE

Line 3098: p_request_type => OE_GLOBALS.g_tax_line,

3094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3095: p_entity_id => update_line.line_id,
3096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3097: p_requesting_entity_id => update_line.line_id,
3098: p_request_type => OE_GLOBALS.g_tax_line,
3099: x_return_status => l_return_status);
3100: ELSE
3101: -- added p_param1 for bug 1786533.
3102: OE_delayed_requests_Pvt.log_request(

Line 3103: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3099: x_return_status => l_return_status);
3100: ELSE
3101: -- added p_param1 for bug 1786533.
3102: OE_delayed_requests_Pvt.log_request(
3103: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3104: p_entity_id => update_line.line_id,
3105: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3106: p_requesting_entity_id => update_line.line_id,
3107: p_request_type => OE_GLOBALS.g_tax_line,

Line 3105: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3101: -- added p_param1 for bug 1786533.
3102: OE_delayed_requests_Pvt.log_request(
3103: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3104: p_entity_id => update_line.line_id,
3105: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3106: p_requesting_entity_id => update_line.line_id,
3107: p_request_type => OE_GLOBALS.g_tax_line,
3108: --p_param1 => l_param1,
3109: x_return_status => l_return_status);

Line 3107: p_request_type => OE_GLOBALS.g_tax_line,

3103: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3104: p_entity_id => update_line.line_id,
3105: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3106: p_requesting_entity_id => update_line.line_id,
3107: p_request_type => OE_GLOBALS.g_tax_line,
3108: --p_param1 => l_param1,
3109: x_return_status => l_return_status);
3110: END IF;
3111: oe_globals.g_tax_flag := 'N';

Line 3111: oe_globals.g_tax_flag := 'N';

3107: p_request_type => OE_GLOBALS.g_tax_line,
3108: --p_param1 => l_param1,
3109: x_return_status => l_return_status);
3110: END IF;
3111: oe_globals.g_tax_flag := 'N';
3112: END IF;
3113:
3114: l_verify_payment := 'N';
3115: --IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN --CC Reversal ER#16014135 Commented

Line 3152: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3148: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR VERIFY PAYMENT' ) ;
3149: END IF;
3150: --
3151: OE_delayed_requests_Pvt.log_request
3152: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3153: p_entity_id => oe_order_pub.g_hdr.header_id,
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,

Line 3154: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3150: --
3151: OE_delayed_requests_Pvt.log_request
3152: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3153: p_entity_id => oe_order_pub.g_hdr.header_id,
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

Line 3156: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

3152: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3153: p_entity_id => oe_order_pub.g_hdr.header_id,
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

Line 3174: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3170: IF l_debug_level > 0 THEN
3171: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR COMMITMENT.' , 2 ) ;
3172: END IF;
3173: OE_Delayed_Requests_Pvt.Log_Request(
3174: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3175: p_entity_id => update_line.line_id,
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,

Line 3176: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3172: END IF;
3173: OE_Delayed_Requests_Pvt.Log_Request(
3174: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3175: p_entity_id => update_line.line_id,
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

Line 3178: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

3174: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3175: p_entity_id => update_line.line_id,
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

Line 3215: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL

3211: --request should be logged only for Sales order and not for quotes
3212: IF nvl(update_line.transaction_phase_code,'F') = 'F' THEN
3213:
3214: OE_Delayed_Requests_Pvt.Log_Request
3215: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3216: ,p_entity_id => update_line.line_id
3217: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3218: ,p_requesting_entity_id => update_line.line_id
3219: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE

Line 3217: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE

3213:
3214: OE_Delayed_Requests_Pvt.Log_Request
3215: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3216: ,p_entity_id => update_line.line_id
3217: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3218: ,p_requesting_entity_id => update_line.line_id
3219: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
3220: -- Old values
3221: ,p_param1 => update_line.blanket_number

Line 3219: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE

3215: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3216: ,p_entity_id => update_line.line_id
3217: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3218: ,p_requesting_entity_id => update_line.line_id
3219: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
3220: -- Old values
3221: ,p_param1 => update_line.blanket_number
3222: ,p_param2 => update_line.blanket_line_number
3223: ,p_param3 => update_line.ordered_quantity

Line 3249: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL

3245: END IF;
3246:
3247: IF update_line.line_set_id IS NOT NULL THEN
3248: OE_Delayed_Requests_Pvt.Log_Request
3249: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3250: ,p_entity_id => update_line.line_set_id
3251: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3252: ,p_requesting_entity_id => update_line.line_id
3253: ,p_request_type => 'VALIDATE_RELEASE_SHIPMENTS'

Line 3251: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE

3247: IF update_line.line_set_id IS NOT NULL THEN
3248: OE_Delayed_Requests_Pvt.Log_Request
3249: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3250: ,p_entity_id => update_line.line_set_id
3251: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3252: ,p_requesting_entity_id => update_line.line_id
3253: ,p_request_type => 'VALIDATE_RELEASE_SHIPMENTS'
3254: ,p_request_unique_key1 => update_line.blanket_number
3255: ,p_request_unique_key2 => update_line.blanket_line_number

Line 3288: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3284: IF l_debug_level > 0 THEN
3285: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED HEADER_ID:'||l_header_id ) ;
3286: END IF;
3287: oe_delayed_requests_pvt.log_request(
3288: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3289: p_entity_id => l_header_id,
3290:
3291: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3292: p_requesting_entity_id => l_header_id,

Line 3291: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3287: oe_delayed_requests_pvt.log_request(
3288: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3289: p_entity_id => l_header_id,
3290:
3291: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3292: p_requesting_entity_id => l_header_id,
3293:
3294: p_request_type => 'MARGIN_HOLD',
3295: x_return_status => l_return_status);

Line 3317: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3313: IF l_debug_level > 0 THEN
3314: oe_debug_pub.add( 'LOGGING REQUEST TO UPDATE ALL LINES FOR HEADER LEVEL ADJUSTMENT.' , 1 ) ;
3315: END IF;
3316: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3317: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3318: p_entity_id => oe_order_pub.g_hdr.header_id,
3319: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3320: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3321: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

Line 3319: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

3315: END IF;
3316: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3317: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3318: p_entity_id => oe_order_pub.g_hdr.header_id,
3319: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3320: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3321: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3322: x_return_status => l_return_status);
3323:

Line 3321: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

3317: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3318: p_entity_id => oe_order_pub.g_hdr.header_id,
3319: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3320: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3321: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3322: x_return_status => l_return_status);
3323:
3324: END IF;
3325: EXCEPTION

Line 3552: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;

3548: IF (p_line_id_tbl(i) is NOT NULL) THEN -- Line Level Adjustment 8415941
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add('Line Level Adjustment 8415941 ');
3551: END IF;
3552: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3553: l_Line_Adj_rec.price_adjustment_id := p_adj_id_tbl(i);
3554: --bug 3882620
3555: l_Line_Adj_rec.header_id := p_header_id_tbl(i);
3556: l_Line_Adj_rec.line_id := p_line_id_tbl(i);

Line 3598: l_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;

3594: IF l_debug_level > 0 THEN
3595: oe_debug_pub.add('Header Level Adjustment 8415941 ');
3596: END IF;
3597:
3598: l_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3599: l_Header_Adj_rec.price_adjustment_id := p_adj_id_tbl(i);
3600: l_Header_Adj_rec.header_id := p_header_id_tbl(i);
3601: l_Header_Adj_rec.list_line_id := p_list_line_id_tbl(i);
3602: l_Header_Adj_rec.list_header_id := p_list_header_id_tbl(i);

Line 6325: AND NOT (OE_GLOBALS.G_RECURSION_MODE <> 'Y' and p_pricing_events = 'BOOK')

6321:
6322: G_PASS_ALL_LINES := 'N';
6323: If G_INT_CHANGED_LINE_ON = 'Y'
6324: AND p_pricing_Events IS NOT NULL
6325: AND NOT (OE_GLOBALS.G_RECURSION_MODE <> 'Y' and p_pricing_events = 'BOOK')
6326: AND (p_pricing_events = 'SHIP' OR (NOT Oe_Line_Adj_Util.has_service_lines(p_header_id)))
6327: AND (p_action_code IS NULL or p_action_code <> 'PRICE_ORDER')
6328: --RT{
6329: AND p_pricing_events <> 'RETROBILL'

Line 7384: IF OE_GLOBALS.G_UI_FLAG THEN

7380: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
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;

Line 7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN

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;
7647: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7648: -- 4919922
7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7650: IF (G_REQUEST_ID IS NULL) THEN
7651: select oe_msg_request_id_s.nextval into g_request_id from dual;
7652: END IF;
7653: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN

7685: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7686:
7687: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7688: -- 4919922
7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7690: IF (G_REQUEST_ID IS NULL) THEN
7691: select oe_msg_request_id_s.nextval into g_request_id from dual;
7692: END IF;
7693: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN

7704: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7705:
7706: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7707: -- 4919922
7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7709: IF (G_REQUEST_ID IS NULL) THEN
7710: select oe_msg_request_id_s.nextval into g_request_id from dual;
7711: END IF;
7712: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN

7722: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7723:
7724: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7725: -- 4919922
7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7727: IF (G_REQUEST_ID IS NULL) THEN
7728: select oe_msg_request_id_s.nextval into g_request_id from dual;
7729: END IF;
7730: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7770: IF OE_GLOBALS.G_UI_FLAG THEN

7766: l_temp_line_rec.ordered_quantity := book_line.line_quantity;
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;

Line 7789: IF OE_GLOBALS.G_UI_FLAG THEN

7785: IF l_debug_level > 0 THEN
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;

Line 7905: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

7901: IF (l_num_changed_lines > 0) THEN
7902: IF l_debug_level > 0 THEN
7903: oe_debug_pub.add( 'SETTING CASCADING FLAG TO REFRESH ORDER' ) ;
7904: END IF;
7905: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
7906: END IF;
7907: End if;
7908:
7909: -- calculate may change adjustments: adjusted_amount

Line 7934: oe_debug_pub.add( 'VOPRB RECURSION MODE'||OE_GLOBALS.G_RECURSION_MODE ) ;

7930:
7931: END IF;
7932:
7933: IF l_debug_level > 0 THEN
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

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 7939: IF (NOT OE_GLOBALS.G_UI_FLAG AND p_control_rec.p_write_to_db = TRUE AND l_num_changed_lines > 0 ) THEN

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;
7943:

Line 7983: IF NOT OE_GLOBALS.G_UI_FLAG AND OE_GLOBALS.G_RECURSION_MODE = 'N' THEN

7979: If l_debug_level > 0 THEN
7980: oe_debug_pub.add('l_booked_flag in process_adjustments = '||l_booked_flag); End If;
7981: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7982: IF l_booked_flag = 'Y' AND p_control_rec.p_write_to_db = TRUE THEN
7983: IF NOT OE_GLOBALS.G_UI_FLAG AND OE_GLOBALS.G_RECURSION_MODE = 'N' THEN
7984: If l_debug_level > 0 THEN
7985: oe_debug_pub.add('Before calling OE_SERVICE_UTIL.Notify_OC in process adj');
7986:
7987: End If;

Line 8264: IF (OE_GLOBALS.G_UI_FLAG)

8260:
8261:
8262: IF l_current_event >= l_tax_calculation_event_code THEN
8263:
8264: IF (OE_GLOBALS.G_UI_FLAG)
8265: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
8266: THEN
8267: OE_delayed_requests_Pvt.log_request(
8268: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

Line 8268: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

8264: IF (OE_GLOBALS.G_UI_FLAG)
8265: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
8266: THEN
8267: OE_delayed_requests_Pvt.log_request(
8268: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8269: p_entity_id => px_Line_Tbl(1).header_id,
8270: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8271: p_requesting_entity_id => px_Line_Tbl(1).header_id,
8272: p_request_type => OE_GLOBALS.g_tax_line,

Line 8270: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

8266: THEN
8267: OE_delayed_requests_Pvt.log_request(
8268: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8269: p_entity_id => px_Line_Tbl(1).header_id,
8270: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8271: p_requesting_entity_id => px_Line_Tbl(1).header_id,
8272: p_request_type => OE_GLOBALS.g_tax_line,
8273: x_return_status => x_return_status);
8274: ELSE

Line 8272: p_request_type => OE_GLOBALS.g_tax_line,

8268: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8269: p_entity_id => px_Line_Tbl(1).header_id,
8270: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8271: p_requesting_entity_id => px_Line_Tbl(1).header_id,
8272: p_request_type => OE_GLOBALS.g_tax_line,
8273: x_return_status => x_return_status);
8274: ELSE
8275: OE_delayed_requests_Pvt.log_request(
8276: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 8276: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8272: p_request_type => OE_GLOBALS.g_tax_line,
8273: x_return_status => x_return_status);
8274: ELSE
8275: OE_delayed_requests_Pvt.log_request(
8276: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8277: p_entity_id => px_Line_Tbl(1).header_id,
8278: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8279: p_requesting_entity_id => px_Line_Tbl(1).header_id,
8280: p_request_type => OE_GLOBALS.g_tax_line,

Line 8278: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

8274: ELSE
8275: OE_delayed_requests_Pvt.log_request(
8276: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8277: p_entity_id => px_Line_Tbl(1).header_id,
8278: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8279: p_requesting_entity_id => px_Line_Tbl(1).header_id,
8280: p_request_type => OE_GLOBALS.g_tax_line,
8281: p_param1 => NULL,
8282: x_return_status => x_return_status);

Line 8280: p_request_type => OE_GLOBALS.g_tax_line,

8276: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8277: p_entity_id => px_Line_Tbl(1).header_id,
8278: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8279: p_requesting_entity_id => px_Line_Tbl(1).header_id,
8280: p_request_type => OE_GLOBALS.g_tax_line,
8281: p_param1 => NULL,
8282: x_return_status => x_return_status);
8283: END IF;
8284: END IF;

Line 8319: IF (OE_GLOBALS.G_UI_FLAG)

8315: END IF;
8316:
8317: IF l_current_event >= l_tax_calculation_event_code THEN
8318:
8319: IF (OE_GLOBALS.G_UI_FLAG)
8320: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
8321: THEN
8322: OE_delayed_requests_Pvt.log_request(
8323: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 8323: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8319: IF (OE_GLOBALS.G_UI_FLAG)
8320: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
8321: THEN
8322: OE_delayed_requests_Pvt.log_request(
8323: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8324: p_entity_id => l_line_rec.line_id,
8325: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8326: p_requesting_entity_id => l_line_rec.line_id,
8327: p_request_type => OE_GLOBALS.g_tax_line,

Line 8325: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8321: THEN
8322: OE_delayed_requests_Pvt.log_request(
8323: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8324: p_entity_id => l_line_rec.line_id,
8325: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8326: p_requesting_entity_id => l_line_rec.line_id,
8327: p_request_type => OE_GLOBALS.g_tax_line,
8328: x_return_status => x_return_status);
8329: ELSE

Line 8327: p_request_type => OE_GLOBALS.g_tax_line,

8323: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8324: p_entity_id => l_line_rec.line_id,
8325: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8326: p_requesting_entity_id => l_line_rec.line_id,
8327: p_request_type => OE_GLOBALS.g_tax_line,
8328: x_return_status => x_return_status);
8329: ELSE
8330: OE_delayed_requests_Pvt.log_request(
8331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 8331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8327: p_request_type => OE_GLOBALS.g_tax_line,
8328: x_return_status => x_return_status);
8329: ELSE
8330: OE_delayed_requests_Pvt.log_request(
8331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8332: p_entity_id => l_line_rec.line_id,
8333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8334: p_requesting_entity_id => l_line_rec.line_id,
8335: p_request_type => OE_GLOBALS.g_tax_line,

Line 8333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

8329: ELSE
8330: OE_delayed_requests_Pvt.log_request(
8331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8332: p_entity_id => l_line_rec.line_id,
8333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8334: p_requesting_entity_id => l_line_rec.line_id,
8335: p_request_type => OE_GLOBALS.g_tax_line,
8336: p_param1 => NULL,
8337: x_return_status => x_return_status);

Line 8335: p_request_type => OE_GLOBALS.g_tax_line,

8331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8332: p_entity_id => l_line_rec.line_id,
8333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8334: p_requesting_entity_id => l_line_rec.line_id,
8335: p_request_type => OE_GLOBALS.g_tax_line,
8336: p_param1 => NULL,
8337: x_return_status => x_return_status);
8338: END IF;
8339: END IF;