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_HOLDS_PUB dependencies on OE_GLOBALS

Line 2033: NOT (l_ato_line_id = p_line_id AND l_item_type_code = OE_GLOBALS.G_ITEM_OPTION) THEN

2029: END IF;
2030:
2031: /* If Line is part of ATO Model */
2032: IF l_ato_line_id is NOT NULL AND x_result_out = FND_API.G_FALSE AND
2033: NOT (l_ato_line_id = p_line_id AND l_item_type_code = OE_GLOBALS.G_ITEM_OPTION) THEN
2034:
2035: IF l_debug_level > 0 THEN
2036: oe_debug_pub.add( 'CHECK_HOLDS:ATO MODEL LINE: ' || L_ATO_LINE_ID ) ;
2037: END IF;

Line 2219: IF l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND x_result_out = FND_API.G_FALSE THEN

2215:
2216: END IF;--NON SMC Config Validation Hold
2217: --5737464
2218:
2219: IF l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND x_result_out = FND_API.G_FALSE THEN
2220:
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add( 'CHECK_HOLDS: CHECKING HOLD ON LINK TO LINE ID: ' || L_LINK_TO_LINE_ID ) ;
2223: END IF;

Line 3113: If p_hold_entity_code = 'BTH' AND p_entity_code = OE_Globals.G_ENTITY_HEADER then

3109: -- When a delayed request is logged for update of Bill To Customer Of Order header level
3110: -- the code is passed as 'BTH' instead of 'C'. This is done because both Custom hold for Sold to Customer
3111: -- and Credit Hold for Bill To Customer are created with hold_entity_code as 'C'.
3112: -- For update of Bill To Customer we only need to re-evaluate Credit Hold and not Custom Holds.
3113: If p_hold_entity_code = 'BTH' AND p_entity_code = OE_Globals.G_ENTITY_HEADER then
3114: l_bth_entity_code := 'C';
3115: l_bth_hold_id := 1;
3116: ElsIf p_hold_entity_code = 'BTL' AND p_entity_code = OE_Globals.G_ENTITY_LINE then
3117: l_bth_entity_code := 'C';

Line 3116: ElsIf p_hold_entity_code = 'BTL' AND p_entity_code = OE_Globals.G_ENTITY_LINE then

3112: -- For update of Bill To Customer we only need to re-evaluate Credit Hold and not Custom Holds.
3113: If p_hold_entity_code = 'BTH' AND p_entity_code = OE_Globals.G_ENTITY_HEADER then
3114: l_bth_entity_code := 'C';
3115: l_bth_hold_id := 1;
3116: ElsIf p_hold_entity_code = 'BTL' AND p_entity_code = OE_Globals.G_ENTITY_LINE then
3117: l_bth_entity_code := 'C';
3118: l_bth_hold_id := 1;
3119: Else
3120: l_bth_entity_code := '';

Line 3126: --ER#7479609 IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

3122: END If;
3123: -- ER#3667551 end
3124:
3125:
3126: --ER#7479609 IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3127: IF (p_entity_code = OE_Globals.G_ENTITY_HEADER OR
3128: p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT) THEN --ER#7479609
3129: -- Indicates Header Level action
3130: l_header_id := p_entity_id;

Line 3127: IF (p_entity_code = OE_Globals.G_ENTITY_HEADER OR

3123: -- ER#3667551 end
3124:
3125:
3126: --ER#7479609 IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3127: IF (p_entity_code = OE_Globals.G_ENTITY_HEADER OR
3128: p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT) THEN --ER#7479609
3129: -- Indicates Header Level action
3130: l_header_id := p_entity_id;
3131: --ER#7479609 start

Line 3128: p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT) THEN --ER#7479609

3124:
3125:
3126: --ER#7479609 IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3127: IF (p_entity_code = OE_Globals.G_ENTITY_HEADER OR
3128: p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT) THEN --ER#7479609
3129: -- Indicates Header Level action
3130: l_header_id := p_entity_id;
3131: --ER#7479609 start
3132: BEGIN

Line 3149: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

3145: --ER#7479609 end
3146: IF l_debug_level > 0 THEN
3147: oe_debug_pub.add( 'HEADER ID: '|| L_HEADER_ID ) ;
3148: END IF;
3149: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3150: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3151: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3152: l_line_id := p_entity_id;
3153: IF l_debug_level > 0 THEN

Line 3150: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR

3146: IF l_debug_level > 0 THEN
3147: oe_debug_pub.add( 'HEADER ID: '|| L_HEADER_ID ) ;
3148: END IF;
3149: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3150: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3151: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3152: l_line_id := p_entity_id;
3153: IF l_debug_level > 0 THEN
3154: oe_debug_pub.add( 'LINE ID: '|| L_LINE_ID ) ;

Line 3151: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609

3147: oe_debug_pub.add( 'HEADER ID: '|| L_HEADER_ID ) ;
3148: END IF;
3149: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3150: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3151: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3152: l_line_id := p_entity_id;
3153: IF l_debug_level > 0 THEN
3154: oe_debug_pub.add( 'LINE ID: '|| L_LINE_ID ) ;
3155: END IF;

Line 3225: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN

3221: END IF;
3222: END IF;
3223:
3224: --ER#7479609 start
3225: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN
3226: G_PAYMENT_HOLD_APPLIED := 'N';
3227: BEGIN
3228: l_payment_type_tab.delete;
3229:

Line 3243: (p_entity_code => OE_Globals.G_ENTITY_HEADER

3239: END;
3240:
3241: FOR i in 1 .. l_payment_type_tab.count LOOP
3242: evaluate_holds
3243: (p_entity_code => OE_Globals.G_ENTITY_HEADER
3244: , p_entity_id => l_header_rec.header_id
3245: , p_hold_entity_code => 'P'
3246: , p_hold_entity_id => l_payment_type_tab(i)
3247: , x_return_status =>l_return_status

Line 3297: IF (l_hold_entity_code='P' and G_PAYMENT_HOLD_APPLIED = 'Y' and p_entity_code = OE_GLOBALS.G_ENTITY_HEADER) THEN

3293: exit;
3294: END IF;
3295:
3296: --ER#7479609 start
3297: IF (l_hold_entity_code='P' and G_PAYMENT_HOLD_APPLIED = 'Y' and p_entity_code = OE_GLOBALS.G_ENTITY_HEADER) THEN
3298: IF l_debug_level > 0 THEN
3299: oe_debug_pub.add( 'NOT DELETING HOLD' , 1 ) ;
3300: END IF;
3301: ELSE

Line 3370: IF (l_hold_entity_code = 'P' and G_PAYMENT_HOLD_APPLIED = 'Y' and p_entity_code = OE_GLOBALS.G_ENTITY_HEADER) THEN

3366: EXIT;
3367: END IF;
3368:
3369: --ER#7479609 start
3370: IF (l_hold_entity_code = 'P' and G_PAYMENT_HOLD_APPLIED = 'Y' and p_entity_code = OE_GLOBALS.G_ENTITY_HEADER) THEN
3371: IF l_debug_level > 0 THEN
3372: oe_debug_pub.add( 'NOT DELETING HOLD' , 1 ) ;
3373: END IF;
3374: ELSE

Line 3451: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

3447: END IF;
3448: ER#7479609 end*/
3449:
3450: --ER#7479609 start
3451: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3452:
3453: BEGIN
3454: l_payment_type_tab.delete;
3455:

Line 3501: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

3497: END IF;
3498: END LOOP;
3499: END IF;
3500:
3501: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3502: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3503: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3504:
3505: BEGIN

Line 3502: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR

3498: END LOOP;
3499: END IF;
3500:
3501: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3502: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3503: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3504:
3505: BEGIN
3506: l_payment_type_tab.delete;

Line 3503: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609

3499: END IF;
3500:
3501: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3502: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3503: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3504:
3505: BEGIN
3506: l_payment_type_tab.delete;
3507:

Line 3605: ELSIF l_hold_entity_code2 = 'P' and p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN --ER#7479609

3601: ELSIF l_hold_entity_code2 = 'CB' THEN
3602: IF l_line_rec.created_by = l_hold_entity_id2 THEN
3603: l_create_order_hold_flag := 'Y';
3604: END IF;
3605: ELSIF l_hold_entity_code2 = 'P' and p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN --ER#7479609
3606: FOR pay_idx in 1 .. l_payment_type_tab.count LOOP
3607: IF (l_payment_type_tab(pay_idx) = l_hold_entity_id2) THEN
3608: l_create_order_hold_flag := 'Y';
3609: EXIT;

Line 3622: IF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

3618: oe_debug_pub.add( 'L_CREATE_ORDER_HOLD_FLAG:' || L_CREATE_ORDER_HOLD_FLAG , 1 ) ;
3619: END IF;
3620:
3621: --ER#7479609 start
3622: IF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3623: -- IF l_hold_entity_code = 'C' and --ER# 11824468
3624: IF l_hold_entity_code IN('C','CN') and --ER# 11824468 added 'CN',
3625: (l_hold_entity_code2 IS NULL OR
3626: l_hold_entity_code2 = 'OT' OR

Line 3806: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

3802: --ER#7479609 end
3803: END IF;
3804: end if;
3805:
3806: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3807: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3809: OE_MSG_PUB.ADD;
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

Line 3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

3806: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3807: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3809: OE_MSG_PUB.ADD;
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3812: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3813: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);

Line 3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR

3807: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3809: OE_MSG_PUB.ADD;
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3812: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3813: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3815: -- Get the line number from the line record

Line 3812: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN

3808: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3809: OE_MSG_PUB.ADD;
3810: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3811: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3812: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3813: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
3814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3815: -- Get the line number from the line record
3816: --SELECT line_number

Line 3874: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

3870: END IF;
3871: ER#7479609 end*/
3872:
3873: --ER#7479609 start
3874: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3875: IF l_hold_entity_code = 'C' THEN
3876: IF l_header_rec.sold_to_org_id = l_hold_entity_id THEN
3877: l_create_order_hold_flag := 'Y';
3878: END IF;

Line 3895: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR

3891: l_create_order_hold_flag := 'Y';
3892: END IF;
3893: END IF;
3894:
3895: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3896: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3897: --ER#7479609 end
3898: IF l_hold_entity_code = 'B' THEN
3899: IF l_line_rec.invoice_to_org_id = l_hold_entity_id THEN

Line 3896: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN

3892: END IF;
3893: END IF;
3894:
3895: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3896: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3897: --ER#7479609 end
3898: IF l_hold_entity_code = 'B' THEN
3899: IF l_line_rec.invoice_to_org_id = l_hold_entity_id THEN
3900: l_create_order_hold_flag := 'Y';

Line 4138: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

4134: --ER#7479609 end
4135: END IF;
4136: end if;
4137:
4138: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4139: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4141: OE_MSG_PUB.ADD;
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

Line 4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

4138: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4139: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4141: OE_MSG_PUB.ADD;
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
4144: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
4145: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);

Line 4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR

4139: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4141: OE_MSG_PUB.ADD;
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
4144: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
4145: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4147: -- Get the line number from the line record

Line 4144: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609

4140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4141: OE_MSG_PUB.ADD;
4142: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4143: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
4144: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
4145: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4147: -- Get the line number from the line record
4148: --SELECT line_number

Line 4597: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

4593: oe_debug_pub.add( 'ENTITY: '|| P_ENTITY_CODE ||'/' || P_ENTITY_ID ) ;
4594: END IF;
4595:
4596:
4597: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4598: -- Indicates Header Level action
4599: l_header_id := p_entity_id;
4600:
4601: --ER#7479609 start

Line 4620: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

4616: oe_debug_pub.add( 'HEADER ID: '|| L_HEADER_ID ) ;
4617: END IF;
4618:
4619:
4620: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4621: l_line_id := p_entity_id;
4622: IF l_debug_level > 0 THEN
4623: oe_debug_pub.add( 'LINE ID: '|| L_LINE_ID ) ;
4624: END IF;

Line 4688: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

4684: END IF;
4685:
4686: -- FOR m_hold_entity_code IN ('B', 'S', 'W', 'I','H') LOOP
4687: --ER#7479609 start
4688: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4689:
4690: BEGIN
4691: l_payment_type_tab.delete;
4692:

Line 4752: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

4748: l_entity_tab(m_counter).entity_code := 'P';
4749: l_entity_tab(m_counter).entity_id := l_payment_type_tab(pay_idx);
4750: END LOOP;
4751:
4752: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4753: --ER#7479609 end
4754:
4755: BEGIN
4756: l_payment_type_tab.delete;

Line 4943: If(l_hold_entity_code2 is null and p_entity_code = OE_Globals.G_ENTITY_HEADER

4939: -- If System parameter "Apply Credit Hold Based On" is set to 'Bill To Customer Line'
4940: -- and if this flow is for Credit Hold (hold id 1) with Entity Code 'C' (Account Level Credit Hold)
4941: -- then Line Level hold has to be applied for the Bill To Customer
4942: l_ch_level := '';
4943: If(l_hold_entity_code2 is null and p_entity_code = OE_Globals.G_ENTITY_HEADER
4944: and l_hold_entity_code = 'C' and l_hold_id=1 ) then
4945: oe_debug_pub.add( 'l_bill_to_orgid='||l_bill_to_orgid||'l_hold_entity_id'||l_hold_entity_id
4946: ||'STO-'||l_header_rec.sold_to_org_id);
4947: If (l_credithold_cust='BTL') then

Line 4966: ElsIf(l_hold_entity_code2 is null and p_entity_code = OE_Globals.G_ENTITY_HEADER

4962: end if;
4963: -- If there is a Customer level hold active for the BTC of the order,
4964: -- then due to m_counter =6 in l_entity_tab the hold message will be displayed,
4965: -- even though the hold would not be applied. But to stop the message this is required
4966: ElsIf(l_hold_entity_code2 is null and p_entity_code = OE_Globals.G_ENTITY_HEADER
4967: and l_hold_entity_code = 'C' and l_hold_id<>1 and l_hold_entity_id <> l_header_rec.sold_to_org_id) then
4968: l_create_order_hold_flag := 'N';
4969: end if;
4970: -- ER#3667551 end

Line 4975: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

4971:
4972: IF l_hold_entity_code2 is not null THEN
4973: l_create_order_hold_flag := 'N';
4974: --ER#7479609 start
4975: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4976:
4977: IF l_hold_entity_code2 = 'OT' THEN
4978: IF l_header_rec.order_type_id = l_hold_entity_id2 THEN
4979: l_create_order_hold_flag := 'Y';

Line 5004: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

5000: END IF;
5001: END LOOP;
5002: END IF;
5003:
5004: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5005: --ER#7479609 end
5006: IF l_hold_entity_code2 = 'C' THEN
5007: IF l_line_rec.sold_to_org_id = l_hold_entity_id2 THEN
5008: l_create_order_hold_flag := 'Y';

Line 5124: IF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

5120: oe_debug_pub.add( 'L_CREATE_ORDER_HOLD_FLAG:' || L_CREATE_ORDER_HOLD_FLAG , 1 ) ;
5121: END IF;
5122:
5123: --ER#7479609 start
5124: IF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5125: -- IF l_hold_entity_code = 'C' and --ER# 11824468
5126: IF l_hold_entity_code IN('C','CN') and --ER# 11824468
5127: (l_hold_entity_code2 IS NULL OR
5128: l_hold_entity_code2 = 'OT' OR

Line 5308: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

5304: END IF;
5305: end if;
5306:
5307:
5308: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5309: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5311: OE_MSG_PUB.ADD;
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

Line 5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

5308: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5309: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5311: OE_MSG_PUB.ADD;
5312: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5313: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5315: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
5316: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609

Line 5442: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN

5438: l_attribute := l_attribute || '/' || 'Warehouse';
5439: END IF;
5440: end if;
5441:
5442: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5443: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5445: OE_MSG_PUB.ADD;
5446: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

Line 5446: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN

5442: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
5443: fnd_message.set_name('ONT','OE_HLD_APPLIED');
5444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5445: OE_MSG_PUB.ADD;
5446: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
5447: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
5448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
5449: -- Get the line number from the line record
5450: --SELECT line_number