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

Line 139: IF NOT OE_GLOBALS.Equal(p_line_rec.ship_set_id,

135: NULL;
136: END;
137:
138:
139: IF NOT OE_GLOBALS.Equal(p_line_rec.ship_set_id,
140: p_old_line_rec.ship_set_id) THEN
141:
142: -- Select statement to check whether the set is pick released.
143: /*

Line 409: p_item_type => OE_GLOBALS.G_WFI_LIN

405: IF l_debug_level > 0 THEN
406: oe_debug_pub.add( 'ENTER OE_SET_UTIL.FULFILL_STS' , 5 ) ;
407: END IF;
408: OE_LINE_FULLFILL.Get_Activity_Result (
409: p_item_type => OE_GLOBALS.G_WFI_LIN
410: , p_item_key => to_char(p_line_id)
411: , p_activity_name => 'FULFILL_LINE'
412: , x_return_status => l_return_status
413: , x_activity_result => l_activity_result

Line 549: l_control_rec OE_GLOBALS.control_rec_type;

545: Procedure Process_Options IS
546: l_line_id NUMBER;
547: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
548: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
549: l_control_rec OE_GLOBALS.control_rec_type;
550: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
551: x_msg_count number;
552: x_msg_data varchar2(2000);
553:

Line 593: l_line_tbl(l_count).operation := oe_globals.g_opr_update;

589: x_line_rec => l_line_tbl(l_count));
590: g_old_line_tbl(l_count) :=
591: l_line_tbl(l_count);
592: l_old_line_tbl(l_count) := l_line_tbl(l_count);
593: l_line_tbl(l_count).operation := oe_globals.g_opr_update;
594: IF g_set_opt_tbl(I).set_id IS NOT NULL THEN
595: l_set_rec := get_set_rec(g_set_opt_tbl(I).set_id);
596: l_perform_sch := TRUE;
597: END IF;

Line 843: p_x_line_tbl(l_count).operation := oe_globals.g_opr_update;

839: := l_line_rec.schedule_arrival_date;
840: p_x_line_tbl(l_count).arrival_set
841: := l_line_rec.arrival_set;
842: END IF;
843: p_x_line_tbl(l_count).operation := oe_globals.g_opr_update;
844: p_x_line_tbl(l_count).schedule_action_code
845: := OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
846: l_count := l_count + 1;
847: END IF; -- if not exists

Line 900: l_control_rec OE_GLOBALS.control_rec_type;

896: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
897: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
898: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
899: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
900: l_control_rec OE_GLOBALS.control_rec_type;
901: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
902: l_return_status VARCHAR2(30);
903: l_query_clause VARCHAR2(2000);
904: l_exist BOOLEAN := FALSE;

Line 1049: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL

1045: END IF;
1046: IF l_debug_level > 0 THEN
1047: oe_debug_pub.add( 'SHIP FROM : '||L_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
1048: END IF;
1049: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL
1050: OR l_line_rec.item_type_code = 'KIT' THEN
1051: l_model_exists := TRUE;
1052: Get_Options(p_x_line_tbl => l_temp_line_tbl,
1053: p_set_type => l_set_type,

Line 1055: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

1051: l_model_exists := TRUE;
1052: Get_Options(p_x_line_tbl => l_temp_line_tbl,
1053: p_set_type => l_set_type,
1054: p_index => 1);
1055: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1056: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1057: l_line_rec.item_type_code = 'INCLUDED' OR
1058: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1059: l_top_model_line_id := l_line_rec.top_model_line_id;

Line 1056: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1052: Get_Options(p_x_line_tbl => l_temp_line_tbl,
1053: p_set_type => l_set_type,
1054: p_index => 1);
1055: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1056: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1057: l_line_rec.item_type_code = 'INCLUDED' OR
1058: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1059: l_top_model_line_id := l_line_rec.top_model_line_id;
1060: l_line_tbl_model_exists := 'N';

Line 1058: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

1054: p_index => 1);
1055: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1056: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1057: l_line_rec.item_type_code = 'INCLUDED' OR
1058: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1059: l_top_model_line_id := l_line_rec.top_model_line_id;
1060: l_line_tbl_model_exists := 'N';
1061: FOR T in 1..l_line_tbl.count loop
1062: IF l_top_model_line_id = l_line_tbl(T).line_id THEN

Line 1356: l_temp_line_tbl(K).operation := oe_globals.g_opr_update;

1352: l_temp_line_tbl(K).ship_Set_id := l_set_id;
1353: ELSIF l_set_type = 'ARRIVAL_SET' THEN
1354: l_temp_line_tbl(K).arrival_Set_id := l_set_id;
1355: END IF;
1356: l_temp_line_tbl(K).operation := oe_globals.g_opr_update;
1357: END LOOP;
1358:
1359: FOR L in 1..l_temp_line_tbl.count
1360: LOOP

Line 1571: ( p_selected_line_tbl IN OE_GLOBALS.Selected_Record_Tbl, --(R12.MOAC)

1567: End Insert_Into_arrival_Set;
1568:
1569:
1570: Procedure New_Process_Sets
1571: ( p_selected_line_tbl IN OE_GLOBALS.Selected_Record_Tbl, --(R12.MOAC)
1572: p_record_count IN NUMBER,
1573: p_set_name IN VARCHAR2,
1574: p_set_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1575: p_operation IN VARCHAR2,

Line 1590: l_control_rec OE_GLOBALS.Control_Rec_Type;

1586:
1587: l_num_of_records NUMBER := p_record_count;
1588: l_line_rec OE_ORDER_PUB.line_rec_type;
1589: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1590: l_control_rec OE_GLOBALS.Control_Rec_Type;
1591: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1592: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1593: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1594: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 1828: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;

1824: l_line_tbl(I).ship_set_id := NULL ;
1825: END IF;
1826: END IF;
1827:
1828: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
1829:
1830: END LOOP;
1831:
1832:

Line 2232: l_control_rec OE_GLOBALS.control_rec_type;

2228: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2229: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2230: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2231: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2232: l_control_rec OE_GLOBALS.control_rec_type;
2233: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
2234: l_return_status VARCHAR2(30);
2235: l_query_clause VARCHAR2(2000);
2236: l_exist BOOLEAN := FALSE;

Line 2456: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL

2452: END IF;
2453: IF l_debug_level > 0 THEN
2454: oe_debug_pub.add( 'SHIP FROM : '||L_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
2455: END IF;
2456: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL
2457: OR l_line_rec.item_type_code = 'KIT' THEN
2458: l_model_exists := TRUE;
2459: Get_Options(p_x_line_tbl => l_temp_line_tbl,
2460: p_set_type => l_set_type,

Line 2462: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

2458: l_model_exists := TRUE;
2459: Get_Options(p_x_line_tbl => l_temp_line_tbl,
2460: p_set_type => l_set_type,
2461: p_index => l_temp_line_tbl.count);
2462: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2463: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
2464: l_line_rec.item_type_code = 'INCLUDED' OR
2465: l_line_rec.item_type_code = 'CONFIG' THEN
2466: l_top_model_line_id := l_line_rec.top_model_line_id;

Line 2463: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

2459: Get_Options(p_x_line_tbl => l_temp_line_tbl,
2460: p_set_type => l_set_type,
2461: p_index => l_temp_line_tbl.count);
2462: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2463: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
2464: l_line_rec.item_type_code = 'INCLUDED' OR
2465: l_line_rec.item_type_code = 'CONFIG' THEN
2466: l_top_model_line_id := l_line_rec.top_model_line_id;
2467: /*OPEN C2;

Line 2654: l_temp_line_tbl(K).operation := oe_globals.g_opr_update;

2650: l_temp_line_tbl(K).ship_Set_id := l_set_id;
2651: ELSIF l_set_type = 'ARRIVAL_SET' THEN
2652: l_temp_line_tbl(K).arrival_Set_id := l_set_id;
2653: END IF;
2654: l_temp_line_tbl(K).operation := oe_globals.g_opr_update;
2655: END LOOP;
2656:
2657: FOR L in 1..l_temp_line_tbl.count
2658: LOOP

Line 3087: ( p_selected_line_tbl IN OE_GLOBALS.Selected_Record_Tbl, -- R12.MOAC

3083:
3084:
3085:
3086: Procedure Process_Sets
3087: ( p_selected_line_tbl IN OE_GLOBALS.Selected_Record_Tbl, -- R12.MOAC
3088: p_record_count IN NUMBER,
3089: p_set_name IN VARCHAR2,
3090: p_set_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3091: p_operation IN VARCHAR2,

Line 3105: l_control_rec OE_GLOBALS.Control_Rec_Type;

3101: ) IS
3102: l_num_of_records NUMBER := p_record_count;
3103: l_line_rec OE_ORDER_PUB.line_rec_type;
3104: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3105: l_control_rec OE_GLOBALS.Control_Rec_Type;
3106: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3107: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3108: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3109: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3551: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL

3547: -- Get Options
3548: l_line_tbl(I).schedule_action_code :=
3549: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
3550:
3551: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL
3552: OR l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
3553: l_in_line_rec := l_line_tbl(I);
3554: Get_Options(p_x_line_tbl => l_line_opt_temp_tbl,
3555: p_set_type => l_set_type,

Line 3552: OR l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT THEN

3548: l_line_tbl(I).schedule_action_code :=
3549: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
3550:
3551: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL
3552: OR l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
3553: l_in_line_rec := l_line_tbl(I);
3554: Get_Options(p_x_line_tbl => l_line_opt_temp_tbl,
3555: p_set_type => l_set_type,
3556: p_index => I,

Line 3563: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;

3559: END IF;
3560:
3561: END IF;
3562:
3563: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
3564: FOR t in 1..l_line_tbl.count
3565: LOOP
3566: IF l_debug_level > 0 THEN
3567: oe_debug_pub.add( 'IN LOOP' ) ;

Line 3816: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN

3812: END IF;
3813:
3814: /* FOR I IN 1 .. L_line_Tbl.Count
3815: LOOP
3816: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN
3817: Get_Options(p_x_line_tbl => l_line_tbl,
3818: p_set_type => l_set_type,
3819: p_index => I);
3820: END IF;

Line 4026: l_control_rec OE_GLOBALS.control_rec_type;

4022:
4023: l_line_rec OE_ORDER_PUB.line_rec_type;
4024: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4025: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4026: l_control_rec OE_GLOBALS.control_rec_type;
4027: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
4028: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4029:
4030: l_return_status VARCHAR2(30);

Line 4184: p_x_line_rec.operation = oe_globals.g_opr_create THEN

4180: oe_debug_pub.add( 'ENTER GET SET ID' ) ;
4181: END IF;
4182: IF (p_x_line_rec.item_type_code IS NULL OR
4183: p_x_line_rec.item_type_code = FND_API.G_MISS_CHAR) AND
4184: p_x_line_rec.operation = oe_globals.g_opr_create THEN
4185: IF l_debug_level > 0 THEN
4186: oe_debug_pub.add( 'ENTER ITEM TYPE CODE NULL' ) ;
4187: END IF;
4188:

Line 4282: IF (p_x_line_rec.operation = oe_globals.g_opr_create AND

4278: -- to gather informations as and when requested and process the global table.
4279: IF l_debug_level > 0 THEN
4280: oe_debug_pub.add( 'BEFORE SETTING THE LINE '||P_X_LINE_REC.LINE_ID , 1 ) ;
4281: END IF;
4282: IF (p_x_line_rec.operation = oe_globals.g_opr_create AND
4283: (p_x_line_rec.line_id = FND_API.G_MISS_NUM OR
4284: p_x_line_rec.line_id IS NULL)) THEN
4285: IF l_debug_level > 0 THEN
4286: oe_debug_pub.add( 'BEFORE SETTING THE LINE -1' , 1 ) ;

Line 4491: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN

4487: IF NOT l_exist THEN
4488:
4489: -- This logic will add an entry into global table if already not exists one
4490:
4491: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4492: IF (p_x_line_rec.line_id IS NOT NULL AND
4493: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4494: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4495: ELSE

Line 4499: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN

4495: ELSE
4496: g_set_tbl(I).line_id := p_index;
4497: g_set_tbl(I).operation := 'C';
4498: END IF;
4499: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4500: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4501: END IF;
4502:
4503: g_set_tbl(I).set_name := p_x_line_rec.arrival_set;

Line 4525: IF NOT OE_GLOBALS.Equal

4521: IF l_debug_level > 0 THEN
4522: oe_debug_pub.add( 'IN ARRIVAL SET ID' , 1 ) ;
4523: END IF;
4524:
4525: IF NOT OE_GLOBALS.Equal
4526: (p_x_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
4527: THEN
4528:
4529: -- Check if set exists and if not set it null

Line 4749: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN

4745: IF Not L_Exist THEN
4746: IF l_debug_level > 0 THEN
4747: oe_debug_pub.add( 'NOT EXISTS' ) ;
4748: END IF;
4749: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4750: IF (p_x_line_rec.line_id IS NOT NULL AND
4751: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4752: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4753: ELSE

Line 4757: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN

4753: ELSE
4754: g_set_tbl(I).line_id := p_index;
4755: g_set_tbl(I).operation := 'C';
4756: END IF;
4757: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4758: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4759: END IF;
4760: IF l_debug_level > 0 THEN
4761: oe_debug_pub.add( 'POPULATING SHIP SET S' ) ;

Line 4772: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)

4768: p_x_line_rec.ship_set_id := NULL;
4769: END IF;
4770: ELSIF (p_x_line_rec.ship_set_id IS NOT NULL AND
4771: p_x_line_rec.ship_set_id <> FND_API.G_MISS_NUM)THEN
4772: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4773: THEN
4774: IF l_debug_level > 0 THEN
4775: oe_debug_pub.add( 'ITEM TYPE CODE' || P_X_LINE_REC.SHIP_SET_ID ) ;
4776: END IF;

Line 4905: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN

4901: IF Not L_Exist THEN
4902: IF l_debug_level > 0 THEN
4903: oe_debug_pub.add( 'NOT EXISTS' ) ;
4904: END IF;
4905: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4906: IF (p_x_line_rec.line_id IS NOT NULL AND
4907: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4908: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4909: ELSE

Line 4913: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN

4909: ELSE
4910: g_set_tbl(I).line_id := p_index;
4911: g_set_tbl(I).operation := 'C';
4912: END IF;
4913: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4914: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4915: END IF;
4916: g_set_tbl(I).set_name := p_x_line_rec.fulfillment_set;
4917: g_set_tbl(I).set_type := 'FULFILLMENT_SET';

Line 4927: IF NOT OE_GLOBALS.Equal(p_x_line_rec.fulfillment_set_id,p_old_line_rec.fulfillment_set_id)

4923: oe_debug_pub.add( 'EXIT FULLFILLMENT SET ' ) ;
4924: END IF;
4925: ELSIF (p_x_line_rec.fulfillment_set_id IS NOT NULL AND
4926: p_x_line_rec.fulfillment_set_id <> FND_API.G_MISS_NUM)THEN
4927: IF NOT OE_GLOBALS.Equal(p_x_line_rec.fulfillment_set_id,p_old_line_rec.fulfillment_set_id)
4928: THEN
4929:
4930: IF NOT Set_Exist(p_set_id => p_x_line_rec.fulfillment_set_id) THEN
4931: p_x_line_rec.fulfillment_set_id := NULL;

Line 4971: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN

4967: IF Not L_Exist THEN
4968: IF l_debug_level > 0 THEN
4969: oe_debug_pub.add( 'NOT EXISTS' ) ;
4970: END IF;
4971: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4972: IF (p_x_line_rec.line_id IS NOT NULL AND
4973: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4974: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4975: ELSE

Line 4979: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN

4975: ELSE
4976: g_set_tbl(I).line_id := p_index;
4977: g_set_tbl(I).operation := 'C';
4978: END IF;
4979: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4980: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4981: END IF;
4982: g_set_tbl(I).set_name := l_set_rec.set_name;
4983: g_set_tbl(I).set_type := 'FULFILLMENT_SET';

Line 5040: IF NOT OE_GLOBALS.Equal(p_x_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)

5036: -- End fulfillment sets
5037:
5038: ELSE
5039: /*
5040: IF NOT OE_GLOBALS.Equal(p_x_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
5041: OR
5042: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
5043: OR
5044: (p_x_line_rec.arrival_set IS NOT NULL AND

Line 5042: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)

5038: ELSE
5039: /*
5040: IF NOT OE_GLOBALS.Equal(p_x_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
5041: OR
5042: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
5043: OR
5044: (p_x_line_rec.arrival_set IS NOT NULL AND
5045: p_x_line_rec.arrival_set <> FND_API.G_MISS_CHAR)
5046: OR

Line 5325: l_control_rec OE_GLOBALS.control_rec_type;

5321: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5322: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5323: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5324: OE_ORDER_PUB.G_MISS_LINE_TBL;
5325: l_control_rec OE_GLOBALS.control_rec_type;
5326: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
5327:
5328: l_return_status VARCHAR2(30);
5329: l_set_id NUMBER ;

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

5358: IF l_debug_level > 0 THEN
5359: oe_debug_pub.add( 'ENTER PROCESS SETS' ) ;
5360: END IF;
5361: IF l_debug_level > 0 THEN
5362: oe_debug_pub.add( 'RECURSION MODE' || OE_GLOBALS.G_RECURSION_MODE ) ;
5363: END IF;
5364:
5365: -- To avoid this in a recursive procedure
5366:

Line 5493: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

5489: IF l_debug_level > 0 THEN
5490: oe_debug_pub.add( 'LINE IS NOT VALID TO PROCESS: ' || L_LINE_REC.LINE_ID , 1 ) ;
5491: END IF;
5492: g_set_tbl(I).process_flag := 'Y' ;
5493: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
5494:
5495: END IF;
5496:
5497: IF (l_line_rec.item_type_code <> 'MODEL' AND

Line 5936: l_line_tbl(K).operation := oe_globals.g_opr_update;

5932: l_line_tbl(K).fulfillment_set_id := l_Set_id;
5933: END IF;
5934: IF l_Set_type <> 'FULFILLMENT_SET' THEN
5935:
5936: l_line_tbl(K).operation := oe_globals.g_opr_update;
5937:
5938: /* Validate_set_attributes(p_set_id => l_set_id,
5939: p_Ship_From_Org_Id => l_line_tbl(K).ship_from_org_id,
5940: p_Ship_To_Org_Id => l_line_tbl(K).Ship_To_Org_Id,

Line 6023: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

6019: END IF;
6020: g_set_recursive_flag := FALSE;
6021:
6022: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6023: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
6024: END IF;
6025:
6026:
6027: FOR M in 1..l_line_tbl.count

Line 6308: p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) or

6304: -- not shipped
6305:
6306: IF NOT g_old_arrival_set_path THEN
6307: IF NOT ((p_x_line_rec.split_action_code = 'SPLIT' and
6308: p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) or
6309: (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE and
6310: p_x_line_rec.split_from_line_id is NOT NULL)) then
6311:
6312: IF ((p_x_line_rec.arrival_set is not null AND

Line 6309: (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE and

6305:
6306: IF NOT g_old_arrival_set_path THEN
6307: IF NOT ((p_x_line_rec.split_action_code = 'SPLIT' and
6308: p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) or
6309: (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE and
6310: p_x_line_rec.split_from_line_id is NOT NULL)) then
6311:
6312: IF ((p_x_line_rec.arrival_set is not null AND
6313: p_x_line_rec.arrival_set <> FND_API.G_MISS_CHAR) OR

Line 6353: IF p_x_line_rec.operation = oe_globals.g_opr_create

6349: -- Check if the header preference is set to keep the line in a set
6350: -- by default
6351: -- QUOTING changes - add lines to sets based on header preference
6352: -- during complete negotiation step
6353: IF p_x_line_rec.operation = oe_globals.g_opr_create
6354: OR (p_x_line_rec.operation = oe_globals.g_opr_update --2843738
6355: AND NOT OE_Globals.Equal(p_x_line_rec.ship_from_org_id, p_old_line_rec.ship_from_org_id)) -- 13706641 and 13788287
6356: /*OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
6357: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.transaction_phase_code

Line 6354: OR (p_x_line_rec.operation = oe_globals.g_opr_update --2843738

6350: -- by default
6351: -- QUOTING changes - add lines to sets based on header preference
6352: -- during complete negotiation step
6353: IF p_x_line_rec.operation = oe_globals.g_opr_create
6354: OR (p_x_line_rec.operation = oe_globals.g_opr_update --2843738
6355: AND NOT OE_Globals.Equal(p_x_line_rec.ship_from_org_id, p_old_line_rec.ship_from_org_id)) -- 13706641 and 13788287
6356: /*OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
6357: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.transaction_phase_code
6358: ,p_old_line_rec.transaction_phase_code)

Line 6355: AND NOT OE_Globals.Equal(p_x_line_rec.ship_from_org_id, p_old_line_rec.ship_from_org_id)) -- 13706641 and 13788287

6351: -- QUOTING changes - add lines to sets based on header preference
6352: -- during complete negotiation step
6353: IF p_x_line_rec.operation = oe_globals.g_opr_create
6354: OR (p_x_line_rec.operation = oe_globals.g_opr_update --2843738
6355: AND NOT OE_Globals.Equal(p_x_line_rec.ship_from_org_id, p_old_line_rec.ship_from_org_id)) -- 13706641 and 13788287
6356: /*OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
6357: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.transaction_phase_code
6358: ,p_old_line_rec.transaction_phase_code)
6359: )-- Comented for 2843738 */

Line 6357: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.transaction_phase_code

6353: IF p_x_line_rec.operation = oe_globals.g_opr_create
6354: OR (p_x_line_rec.operation = oe_globals.g_opr_update --2843738
6355: AND NOT OE_Globals.Equal(p_x_line_rec.ship_from_org_id, p_old_line_rec.ship_from_org_id)) -- 13706641 and 13788287
6356: /*OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
6357: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.transaction_phase_code
6358: ,p_old_line_rec.transaction_phase_code)
6359: )-- Comented for 2843738 */
6360: THEN
6361:

Line 6644: ELSIF NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_set_id,

6640: END IF;
6641:
6642: -- Now check if the arrival set id is populated in a case when the line
6643: -- moving into existing arrival set OR removed from existing arrival set
6644: ELSIF NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_set_id,
6645: p_old_line_rec.arrival_set_id )
6646: THEN
6647: IF l_debug_level > 0 THEN
6648: oe_debug_pub.add( 'ARRIVAL SET-3'|| P_X_LINE_REC.ARRIVAL_SET_ID , 1 ) ;

Line 6741: ELSIF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,

6737: END IF;
6738:
6739: -- Now check if the arrival set id is populated in a case when the line
6740: -- moving into existing arrival set OR removed from existing arrival set
6741: ELSIF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,
6742: p_old_line_rec.ship_set_id )
6743: THEN
6744: IF l_debug_level > 0 THEN
6745: oe_debug_pub.add( 'INTO SHIP SETS '|| P_X_LINE_REC.SHIP_SET_ID , 1 ) ;

Line 6999: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

6995: x_msg_data => x_msg_data
6996: );
6997:
6998: --bug 15871999
6999: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
7000: --bug 15871999
7001:
7002: /* we will come to the elsif block in the case where there are 3 lines in the
7003: order. First two lines with warehouse V1 and third with warehouse W1. All the

Line 7085: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

7081: x_msg_data => x_msg_data
7082: );
7083:
7084: -- bug 15871999
7085: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
7086: -- bug 15871999
7087:
7088: /* we will come to the elsif block in the case where there are 3 lines in the
7089: order. First two lines with warehouse V1 and third with warehouse W1. All the

Line 7220: l_operation:=OE_GLOBALS.G_OPR_CREATE;

7216: END IF;
7217:
7218: IF OE_QUOTE_UTIL.G_COMPLETE_NEG='Y'
7219: THEN
7220: l_operation:=OE_GLOBALS.G_OPR_CREATE;
7221: ELSE
7222: l_operation:= l_child_line_rec.operation;
7223: END IF;
7224:

Line 7235: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL

7231: oe_debug_pub.add( 'new arrival set id id'||i.arrival_set_id);
7232: END IF;
7233:
7234: IF OE_Delayed_Requests_PVT.Check_for_Request
7235: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
7236: , p_entity_id =>i.line_id
7237: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
7238: THEN
7239:

Line 7237: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)

7233:
7234: IF OE_Delayed_Requests_PVT.Check_for_Request
7235: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
7236: , p_entity_id =>i.line_id
7237: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
7238: THEN
7239:
7240:
7241: OE_delayed_requests_Pvt.log_request

Line 7242: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,

7238: THEN
7239:
7240:
7241: OE_delayed_requests_Pvt.log_request
7242: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
7243: p_entity_id => l_child_line_rec.line_id,
7244: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7245: p_requesting_entity_id => l_child_line_rec.line_id,
7246: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

Line 7244: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7240:
7241: OE_delayed_requests_Pvt.log_request
7242: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
7243: p_entity_id => l_child_line_rec.line_id,
7244: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7245: p_requesting_entity_id => l_child_line_rec.line_id,
7246: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
7247: p_param1 => l_child_line_rec.arrival_set_id,
7248: p_param2 => l_child_line_rec.header_id,

Line 7246: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

7242: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
7243: p_entity_id => l_child_line_rec.line_id,
7244: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7245: p_requesting_entity_id => l_child_line_rec.line_id,
7246: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
7247: p_param1 => l_child_line_rec.arrival_set_id,
7248: p_param2 => l_child_line_rec.header_id,
7249: p_param3 => l_action,
7250: p_param4 => l_child_line_rec.ship_from_org_id,

Line 7278: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL

7274: oe_debug_pub.add( 'new ship set id id'||i.ship_set_id);
7275: END IF;
7276:
7277: IF OE_Delayed_Requests_PVT.Check_for_Request
7278: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
7279: , p_entity_id =>i.line_id
7280: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
7281: THEN
7282: OE_delayed_requests_Pvt.log_request

Line 7280: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)

7276:
7277: IF OE_Delayed_Requests_PVT.Check_for_Request
7278: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
7279: , p_entity_id =>i.line_id
7280: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
7281: THEN
7282: OE_delayed_requests_Pvt.log_request
7283: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
7284: p_entity_id => l_child_line_rec.line_id,

Line 7283: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,

7279: , p_entity_id =>i.line_id
7280: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
7281: THEN
7282: OE_delayed_requests_Pvt.log_request
7283: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
7284: p_entity_id => l_child_line_rec.line_id,
7285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7286: p_requesting_entity_id => l_child_line_rec.line_id,
7287: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

Line 7285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7281: THEN
7282: OE_delayed_requests_Pvt.log_request
7283: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
7284: p_entity_id => l_child_line_rec.line_id,
7285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7286: p_requesting_entity_id => l_child_line_rec.line_id,
7287: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
7288: p_param1 => l_child_line_rec.ship_set_id,
7289: p_param2 => l_child_line_rec.header_id,

Line 7287: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

7283: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
7284: p_entity_id => l_child_line_rec.line_id,
7285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7286: p_requesting_entity_id => l_child_line_rec.line_id,
7287: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
7288: p_param1 => l_child_line_rec.ship_set_id,
7289: p_param2 => l_child_line_rec.header_id,
7290: p_param3 => l_action,
7291: p_param4 => l_child_line_rec.ship_from_org_id,

Line 7327: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7323: oe_debug_pub.add( 'UPDATE SHIPPING : CHILDREN OF MODEL FOR SETS ' || TO_CHAR ( OPTIONREC.LINE_ID ) , 1 ) ;
7324: END IF;
7325:
7326: OE_Delayed_Requests_Pvt.Log_Request(
7327: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7328: p_entity_id => optionrec.line_id,
7329: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7330: p_requesting_entity_id => optionrec.line_id,
7331: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,

Line 7329: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

7325:
7326: OE_Delayed_Requests_Pvt.Log_Request(
7327: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7328: p_entity_id => optionrec.line_id,
7329: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7330: p_requesting_entity_id => optionrec.line_id,
7331: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
7332: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,
7333: p_param1 => FND_API.G_TRUE,

Line 7331: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,

7327: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7328: p_entity_id => optionrec.line_id,
7329: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7330: p_requesting_entity_id => optionrec.line_id,
7331: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
7332: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,
7333: p_param1 => FND_API.G_TRUE,
7334: x_return_status => l_return_status);
7335:

Line 7332: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,

7328: p_entity_id => optionrec.line_id,
7329: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
7330: p_requesting_entity_id => optionrec.line_id,
7331: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
7332: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,
7333: p_param1 => FND_API.G_TRUE,
7334: x_return_status => l_return_status);
7335:
7336: END IF;

Line 7341: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

7337: End loop;
7338:
7339:
7340: -- Setting G_CASCADING_REQUEST_LOGGED to requery the lines in the form
7341: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
7342:
7343: exception
7344: when others then
7345: null;

Line 7350: IF NOT(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE

7346: end;-- Begin of the update
7347:
7348: END IF; -- Cascade Flag
7349: ELSE -- IF not external
7350: IF NOT(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
7351: AND p_x_line_rec.top_model_line_id <> p_x_line_rec.line_id)
7352: AND p_x_line_rec.top_model_line_id IS NOT NULL THEN
7353:
7354: IF p_x_line_rec.ship_set IS NOT NULL AND

Line 7373: IF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,

7369: END IF;
7370: END IF;
7371:
7372:
7373: IF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,
7374: p_old_line_rec.ship_set_id) OR
7375: NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_Set_id,
7376: p_old_line_rec.arrival_Set_id) THEN
7377:

Line 7375: NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_Set_id,

7371:
7372:
7373: IF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,
7374: p_old_line_rec.ship_set_id) OR
7375: NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_Set_id,
7376: p_old_line_rec.arrival_Set_id) THEN
7377:
7378:
7379: IF l_debug_level > 0 THEN

Line 7421: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

7417:
7418:
7419: OE_DEBUG_PUB.Add('Automatic Fulfillment Set:'||p_x_line_rec.fulfillment_set);
7420:
7421: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7422:
7423: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
7424:
7425: IF OE_ORDER_CACHE.g_header_rec.default_fulfillment_set = 'Y' THEN

Line 7623: ELSIF NOT OE_GLOBALS.EQUAL(p_x_line_rec.fulfillment_set_id,

7619: END IF;
7620:
7621: l_ful_exists := 'Y';
7622:
7623: ELSIF NOT OE_GLOBALS.EQUAL(p_x_line_rec.fulfillment_set_id,
7624: p_old_line_rec.fulfillment_set_id) THEN
7625: IF NOT Set_Exist(p_set_id => p_x_line_rec.fulfillment_set_id) THEN
7626:
7627: p_x_line_rec.fulfillment_set_id := NULL;