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;
19:
20: --rc
21: G_CHARGE_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;

Line 24: G_ADDED_PARENT_TBL OE_GLOBALS.Number_Tbl_Type;

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

Line 245: l_org_id := OE_GLOBALS.G_ORG_ID;

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

Line 247: OE_GLOBALS.Set_Context;

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

Line 248: l_org_id := OE_GLOBALS.G_ORG_ID;

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

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

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

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

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

Line 511: OE_GLOBALS.Set_Context;

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

Line 512: l_org_id := OE_GLOBALS.G_ORG_ID;

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

Line 2286: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

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

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

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

2378: l_control_rec.change_attributes := TRUE;
2379: l_control_rec.check_security := l_check_sec;
2380: l_control_rec.validate_entity := FALSE;
2381: l_control_rec.write_to_DB := FALSE;
2382: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
2383: l_control_rec.process := FALSE;
2384:
2385: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
2386:

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

2381: l_control_rec.write_to_DB := FALSE;
2382: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
2383: l_control_rec.process := FALSE;
2384:
2385: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
2386:
2387: IF l_debug_level > 0 THEN
2388: oe_debug_pub.add( 'validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;
2389: END IF;

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

2384:
2385: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
2386:
2387: IF l_debug_level > 0 THEN
2388: oe_debug_pub.add( 'validate desc flex:'||OE_GLOBALS.g_validate_desc_flex) ;
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

Line 2390: l_validate_desc_flex := OE_GLOBALS.g_validate_desc_flex;

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

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

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

Line 2404: OE_GLOBALS.g_validate_desc_flex := l_validate_desc_flex;

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

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

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) ;
2407: END IF;
2408: OE_GLOBALS.G_PRICING_RECURSION := 'N';
2409: END IF;
2410: --bug 3702538

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

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) ;
2407: END IF;
2408: OE_GLOBALS.G_PRICING_RECURSION := 'N';
2409: END IF;
2410: --bug 3702538
2411: END POPULATE_LINE_TBL;
2412:

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

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

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

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 ) ;
2493: END IF;
2494:
2495: --IF (NOT OE_GLOBALS.G_HEADER_CREATED ) THEN
2496: IF l_debug_level > 0 THEN
2497: oe_debug_pub.add(' Checking Security');
2498: END IF;
2499:

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

2500: --bug 2823794, the security api doesn't like delete operation.
2501: --it will raise error if a delete operation is passed.
2502: --therefore we check, if delete or create operation, do not call the security api.
2503:
2504: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2505:
2506: -- bug 3554060
2507: l_old_change_reason := l_line_rec.change_reason;
2508: l_old_change_comments := l_line_rec.change_comments;

Line 3070: IF (OE_GLOBALS.G_UI_FLAG) THEN

3066: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR TAXING' ) ;
3067: END IF;
3068: l_commt_tax_flag := 'N' ; --bug 2505961
3069: -- lkxu, make changes for bug 1581188
3070: IF (OE_GLOBALS.G_UI_FLAG) THEN
3071: OE_delayed_requests_Pvt.log_request(
3072: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3073: p_entity_id => update_line.line_id,
3074: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 3072: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3068: l_commt_tax_flag := 'N' ; --bug 2505961
3069: -- lkxu, make changes for bug 1581188
3070: IF (OE_GLOBALS.G_UI_FLAG) THEN
3071: OE_delayed_requests_Pvt.log_request(
3072: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3073: p_entity_id => update_line.line_id,
3074: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3075: p_requesting_entity_id => update_line.line_id,
3076: p_request_type => OE_GLOBALS.g_tax_line,

Line 3074: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3070: IF (OE_GLOBALS.G_UI_FLAG) THEN
3071: OE_delayed_requests_Pvt.log_request(
3072: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3073: p_entity_id => update_line.line_id,
3074: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3075: p_requesting_entity_id => update_line.line_id,
3076: p_request_type => OE_GLOBALS.g_tax_line,
3077: x_return_status => l_return_status);
3078: ELSE

Line 3076: p_request_type => OE_GLOBALS.g_tax_line,

3072: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3073: p_entity_id => update_line.line_id,
3074: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3075: p_requesting_entity_id => update_line.line_id,
3076: p_request_type => OE_GLOBALS.g_tax_line,
3077: x_return_status => l_return_status);
3078: ELSE
3079: -- added p_param1 for bug 1786533.
3080: OE_delayed_requests_Pvt.log_request(

Line 3081: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3077: x_return_status => l_return_status);
3078: ELSE
3079: -- added p_param1 for bug 1786533.
3080: OE_delayed_requests_Pvt.log_request(
3081: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3082: p_entity_id => update_line.line_id,
3083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3084: p_requesting_entity_id => update_line.line_id,
3085: p_request_type => OE_GLOBALS.g_tax_line,

Line 3083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3079: -- added p_param1 for bug 1786533.
3080: OE_delayed_requests_Pvt.log_request(
3081: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3082: p_entity_id => update_line.line_id,
3083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3084: p_requesting_entity_id => update_line.line_id,
3085: p_request_type => OE_GLOBALS.g_tax_line,
3086: --p_param1 => l_param1,
3087: x_return_status => l_return_status);

Line 3085: p_request_type => OE_GLOBALS.g_tax_line,

3081: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3082: p_entity_id => update_line.line_id,
3083: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3084: p_requesting_entity_id => update_line.line_id,
3085: p_request_type => OE_GLOBALS.g_tax_line,
3086: --p_param1 => l_param1,
3087: x_return_status => l_return_status);
3088: END IF;
3089: oe_globals.g_tax_flag := 'N';

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

3085: p_request_type => OE_GLOBALS.g_tax_line,
3086: --p_param1 => l_param1,
3087: x_return_status => l_return_status);
3088: END IF;
3089: oe_globals.g_tax_flag := 'N';
3090: END IF;
3091:
3092: l_verify_payment := 'N';
3093: IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN

Line 3130: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3126: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR VERIFY PAYMENT' ) ;
3127: END IF;
3128: --
3129: OE_delayed_requests_Pvt.log_request
3130: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3131: p_entity_id => oe_order_pub.g_hdr.header_id,
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,

Line 3132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3128: --
3129: OE_delayed_requests_Pvt.log_request
3130: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3131: p_entity_id => oe_order_pub.g_hdr.header_id,
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

Line 3134: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

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

Line 3152: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3148: IF l_debug_level > 0 THEN
3149: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR COMMITMENT.' , 2 ) ;
3150: END IF;
3151: OE_Delayed_Requests_Pvt.Log_Request(
3152: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3153: p_entity_id => update_line.line_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_CALCULATE_COMMITMENT,

Line 3154: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3150: END IF;
3151: OE_Delayed_Requests_Pvt.Log_Request(
3152: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3153: p_entity_id => update_line.line_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_CALCULATE_COMMITMENT,
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_CALCULATE_COMMITMENT,

3152: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3153: p_entity_id => update_line.line_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_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

Line 3193: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL

3189: --request should be logged only for Sales order and not for quotes
3190: IF nvl(update_line.transaction_phase_code,'F') = 'F' THEN
3191:
3192: OE_Delayed_Requests_Pvt.Log_Request
3193: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3194: ,p_entity_id => update_line.line_id
3195: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3196: ,p_requesting_entity_id => update_line.line_id
3197: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE

Line 3195: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE

3191:
3192: OE_Delayed_Requests_Pvt.Log_Request
3193: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3194: ,p_entity_id => update_line.line_id
3195: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3196: ,p_requesting_entity_id => update_line.line_id
3197: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
3198: -- Old values
3199: ,p_param1 => update_line.blanket_number

Line 3197: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE

3193: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3194: ,p_entity_id => update_line.line_id
3195: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3196: ,p_requesting_entity_id => update_line.line_id
3197: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
3198: -- Old values
3199: ,p_param1 => update_line.blanket_number
3200: ,p_param2 => update_line.blanket_line_number
3201: ,p_param3 => update_line.ordered_quantity

Line 3227: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL

3223: END IF;
3224:
3225: IF update_line.line_set_id IS NOT NULL THEN
3226: OE_Delayed_Requests_Pvt.Log_Request
3227: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3228: ,p_entity_id => update_line.line_set_id
3229: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3230: ,p_requesting_entity_id => update_line.line_id
3231: ,p_request_type => 'VALIDATE_RELEASE_SHIPMENTS'

Line 3229: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE

3225: IF update_line.line_set_id IS NOT NULL THEN
3226: OE_Delayed_Requests_Pvt.Log_Request
3227: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3228: ,p_entity_id => update_line.line_set_id
3229: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
3230: ,p_requesting_entity_id => update_line.line_id
3231: ,p_request_type => 'VALIDATE_RELEASE_SHIPMENTS'
3232: ,p_request_unique_key1 => update_line.blanket_number
3233: ,p_request_unique_key2 => update_line.blanket_line_number

Line 3266: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED HEADER_ID:'||l_header_id ) ;
3264: END IF;
3265: oe_delayed_requests_pvt.log_request(
3266: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3267: p_entity_id => l_header_id,
3268:
3269: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3270: p_requesting_entity_id => l_header_id,

Line 3269: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3265: oe_delayed_requests_pvt.log_request(
3266: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3267: p_entity_id => l_header_id,
3268:
3269: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3270: p_requesting_entity_id => l_header_id,
3271:
3272: p_request_type => 'MARGIN_HOLD',
3273: x_return_status => l_return_status);

Line 3295: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3291: IF l_debug_level > 0 THEN
3292: oe_debug_pub.add( 'LOGGING REQUEST TO UPDATE ALL LINES FOR HEADER LEVEL ADJUSTMENT.' , 1 ) ;
3293: END IF;
3294: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3295: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3296: p_entity_id => oe_order_pub.g_hdr.header_id,
3297: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3298: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3299: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

Line 3297: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

3293: END IF;
3294: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3295: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3296: p_entity_id => oe_order_pub.g_hdr.header_id,
3297: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3298: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3299: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3300: x_return_status => l_return_status);
3301:

Line 3299: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

3295: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3296: p_entity_id => oe_order_pub.g_hdr.header_id,
3297: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3298: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3299: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3300: x_return_status => l_return_status);
3301:
3302: END IF;
3303: EXCEPTION

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

3473: oe_debug_pub.add('Delete adjustments notify to OC');
3474: END IF;
3475: i := p_adj_id_tbl.first;
3476: while i is not null loop
3477: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3478: l_Line_Adj_rec.price_adjustment_id := p_adj_id_tbl(i);
3479: --bug 3882620
3480: l_Line_Adj_rec.header_id := p_header_id_tbl(i);
3481: l_Line_Adj_rec.line_id := p_line_id_tbl(i);

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

6042:
6043: G_PASS_ALL_LINES := 'N';
6044: If G_INT_CHANGED_LINE_ON = 'Y'
6045: AND p_pricing_Events IS NOT NULL
6046: AND NOT (OE_GLOBALS.G_RECURSION_MODE <> 'Y' and p_pricing_events = 'BOOK')
6047: AND (p_pricing_events = 'SHIP' OR (NOT Oe_Line_Adj_Util.has_service_lines(p_header_id)))
6048: AND (p_action_code IS NULL or p_action_code <> 'PRICE_ORDER')
6049: --RT{
6050: AND p_pricing_events <> 'RETROBILL'

Line 7362: IF (OE_GLOBALS.G_UI_FLAG ) THEN

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;
7360: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7361: -- 4919922
7362: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7363: IF (G_REQUEST_ID IS NULL) THEN
7364: select oe_msg_request_id_s.nextval into g_request_id from dual;
7365: END IF;
7366: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7402: IF (OE_GLOBALS.G_UI_FLAG ) THEN

7398: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7399:
7400: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7401: -- 4919922
7402: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7403: IF (G_REQUEST_ID IS NULL) THEN
7404: select oe_msg_request_id_s.nextval into g_request_id from dual;
7405: END IF;
7406: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7421: IF (OE_GLOBALS.G_UI_FLAG ) THEN

7417: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7418:
7419: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7420: -- 4919922
7421: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7422: IF (G_REQUEST_ID IS NULL) THEN
7423: select oe_msg_request_id_s.nextval into g_request_id from dual;
7424: END IF;
7425: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7439: IF (OE_GLOBALS.G_UI_FLAG ) THEN

7435: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7436:
7437: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7438: -- 4919922
7439: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7440: IF (G_REQUEST_ID IS NULL) THEN
7441: select oe_msg_request_id_s.nextval into g_request_id from dual;
7442: END IF;
7443: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

Line 7602: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

7598: IF (l_num_changed_lines > 0) THEN
7599: IF l_debug_level > 0 THEN
7600: oe_debug_pub.add( 'SETTING CASCADING FLAG TO REFRESH ORDER' ) ;
7601: END IF;
7602: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
7603: END IF;
7604: End if;
7605:
7606: -- calculate may change adjustments: adjusted_amount

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

7627:
7628: END IF;
7629:
7630: IF l_debug_level > 0 THEN
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

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

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

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

7676: If l_debug_level > 0 THEN
7677: oe_debug_pub.add('l_booked_flag in process_adjustments = '||l_booked_flag); End If;
7678: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7679: IF l_booked_flag = 'Y' AND p_control_rec.p_write_to_db = TRUE THEN
7680: IF NOT OE_GLOBALS.G_UI_FLAG AND OE_GLOBALS.G_RECURSION_MODE = 'N' THEN
7681: If l_debug_level > 0 THEN
7682: oe_debug_pub.add('Before calling OE_SERVICE_UTIL.Notify_OC in process adj');
7683:
7684: End If;