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 373: p_item_type => OE_GLOBALS.G_WFI_LIN

369: IF l_debug_level > 0 THEN
370: oe_debug_pub.add( 'ENTER OE_SET_UTIL.FULFILL_STS' , 5 ) ;
371: END IF;
372: OE_LINE_FULLFILL.Get_Activity_Result (
373: p_item_type => OE_GLOBALS.G_WFI_LIN
374: , p_item_key => to_char(p_line_id)
375: , p_activity_name => 'FULFILL_LINE'
376: , x_return_status => l_return_status
377: , x_activity_result => l_activity_result

Line 513: l_control_rec OE_GLOBALS.control_rec_type;

509: Procedure Process_Options IS
510: l_line_id NUMBER;
511: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
512: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
513: l_control_rec OE_GLOBALS.control_rec_type;
514: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
515: x_msg_count number;
516: x_msg_data varchar2(2000);
517:

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

553: x_line_rec => l_line_tbl(l_count));
554: g_old_line_tbl(l_count) :=
555: l_line_tbl(l_count);
556: l_old_line_tbl(l_count) := l_line_tbl(l_count);
557: l_line_tbl(l_count).operation := oe_globals.g_opr_update;
558: IF g_set_opt_tbl(I).set_id IS NOT NULL THEN
559: l_set_rec := get_set_rec(g_set_opt_tbl(I).set_id);
560: l_perform_sch := TRUE;
561: END IF;

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

803: := l_line_rec.schedule_arrival_date;
804: p_x_line_tbl(l_count).arrival_set
805: := l_line_rec.arrival_set;
806: END IF;
807: p_x_line_tbl(l_count).operation := oe_globals.g_opr_update;
808: p_x_line_tbl(l_count).schedule_action_code
809: := OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
810: l_count := l_count + 1;
811: END IF; -- if not exists

Line 864: l_control_rec OE_GLOBALS.control_rec_type;

860: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
861: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
862: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
863: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
864: l_control_rec OE_GLOBALS.control_rec_type;
865: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
866: l_return_status VARCHAR2(30);
867: l_query_clause VARCHAR2(2000);
868: l_exist BOOLEAN := FALSE;

Line 1013: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL

1009: END IF;
1010: IF l_debug_level > 0 THEN
1011: oe_debug_pub.add( 'SHIP FROM : '||L_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
1012: END IF;
1013: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL
1014: OR l_line_rec.item_type_code = 'KIT' THEN
1015: l_model_exists := TRUE;
1016: Get_Options(p_x_line_tbl => l_temp_line_tbl,
1017: p_set_type => l_set_type,

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

1015: l_model_exists := TRUE;
1016: Get_Options(p_x_line_tbl => l_temp_line_tbl,
1017: p_set_type => l_set_type,
1018: p_index => 1);
1019: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1020: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1021: l_line_rec.item_type_code = 'INCLUDED' OR
1022: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1023: l_top_model_line_id := l_line_rec.top_model_line_id;

Line 1020: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1016: Get_Options(p_x_line_tbl => l_temp_line_tbl,
1017: p_set_type => l_set_type,
1018: p_index => 1);
1019: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1020: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1021: l_line_rec.item_type_code = 'INCLUDED' OR
1022: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1023: l_top_model_line_id := l_line_rec.top_model_line_id;
1024: l_line_tbl_model_exists := 'N';

Line 1022: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

1018: p_index => 1);
1019: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1020: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1021: l_line_rec.item_type_code = 'INCLUDED' OR
1022: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1023: l_top_model_line_id := l_line_rec.top_model_line_id;
1024: l_line_tbl_model_exists := 'N';
1025: FOR T in 1..l_line_tbl.count loop
1026: IF l_top_model_line_id = l_line_tbl(T).line_id THEN

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

1316: l_temp_line_tbl(K).ship_Set_id := l_set_id;
1317: ELSIF l_set_type = 'ARRIVAL_SET' THEN
1318: l_temp_line_tbl(K).arrival_Set_id := l_set_id;
1319: END IF;
1320: l_temp_line_tbl(K).operation := oe_globals.g_opr_update;
1321: END LOOP;
1322:
1323: FOR L in 1..l_temp_line_tbl.count
1324: LOOP

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

1531: End Insert_Into_arrival_Set;
1532:
1533:
1534: Procedure New_Process_Sets
1535: ( p_selected_line_tbl IN OE_GLOBALS.Selected_Record_Tbl, --(R12.MOAC)
1536: p_record_count IN NUMBER,
1537: p_set_name IN VARCHAR2,
1538: p_set_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1539: p_operation IN VARCHAR2,

Line 1554: l_control_rec OE_GLOBALS.Control_Rec_Type;

1550:
1551: l_num_of_records NUMBER := p_record_count;
1552: l_line_rec OE_ORDER_PUB.line_rec_type;
1553: l_in_line_rec OE_ORDER_PUB.line_rec_type;
1554: l_control_rec OE_GLOBALS.Control_Rec_Type;
1555: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1556: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
1557: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
1558: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

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

1786: l_line_tbl(I).ship_set_id := NULL ;
1787: END IF;
1788: END IF;
1789:
1790: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
1791:
1792: END LOOP;
1793:
1794:

Line 2179: l_control_rec OE_GLOBALS.control_rec_type;

2175: set_request_tbl oe_order_pub.Request_Tbl_Type := p_Set_request_tbl ;
2176: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
2177: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type ;
2178: l_line_query_tbl OE_ORDER_PUB.Line_Tbl_Type;
2179: l_control_rec OE_GLOBALS.control_rec_type;
2180: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
2181: l_return_status VARCHAR2(30);
2182: l_query_clause VARCHAR2(2000);
2183: l_exist BOOLEAN := FALSE;

Line 2403: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL

2399: END IF;
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add( 'SHIP FROM : '||L_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
2402: END IF;
2403: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL
2404: OR l_line_rec.item_type_code = 'KIT' THEN
2405: l_model_exists := TRUE;
2406: Get_Options(p_x_line_tbl => l_temp_line_tbl,
2407: p_set_type => l_set_type,

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

2405: l_model_exists := TRUE;
2406: Get_Options(p_x_line_tbl => l_temp_line_tbl,
2407: p_set_type => l_set_type,
2408: p_index => l_temp_line_tbl.count);
2409: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2410: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
2411: l_line_rec.item_type_code = 'INCLUDED' OR
2412: l_line_rec.item_type_code = 'CONFIG' THEN
2413: l_top_model_line_id := l_line_rec.top_model_line_id;

Line 2410: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

2406: Get_Options(p_x_line_tbl => l_temp_line_tbl,
2407: p_set_type => l_set_type,
2408: p_index => l_temp_line_tbl.count);
2409: ELSIF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2410: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
2411: l_line_rec.item_type_code = 'INCLUDED' OR
2412: l_line_rec.item_type_code = 'CONFIG' THEN
2413: l_top_model_line_id := l_line_rec.top_model_line_id;
2414: /*OPEN C2;

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

2597: l_temp_line_tbl(K).ship_Set_id := l_set_id;
2598: ELSIF l_set_type = 'ARRIVAL_SET' THEN
2599: l_temp_line_tbl(K).arrival_Set_id := l_set_id;
2600: END IF;
2601: l_temp_line_tbl(K).operation := oe_globals.g_opr_update;
2602: END LOOP;
2603:
2604: FOR L in 1..l_temp_line_tbl.count
2605: LOOP

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

3030:
3031:
3032:
3033: Procedure Process_Sets
3034: ( p_selected_line_tbl IN OE_GLOBALS.Selected_Record_Tbl, -- R12.MOAC
3035: p_record_count IN NUMBER,
3036: p_set_name IN VARCHAR2,
3037: p_set_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
3038: p_operation IN VARCHAR2,

Line 3052: l_control_rec OE_GLOBALS.Control_Rec_Type;

3048: ) IS
3049: l_num_of_records NUMBER := p_record_count;
3050: l_line_rec OE_ORDER_PUB.line_rec_type;
3051: l_in_line_rec OE_ORDER_PUB.line_rec_type;
3052: l_control_rec OE_GLOBALS.Control_Rec_Type;
3053: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3054: l_line_opt_tbl OE_ORDER_PUB.Line_Tbl_Type;
3055: l_line_opt_temp_tbl OE_ORDER_PUB.Line_Tbl_Type;
3056: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

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

3490: -- Get Options
3491: l_line_tbl(I).schedule_action_code :=
3492: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
3493:
3494: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL
3495: OR l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
3496: l_in_line_rec := l_line_tbl(I);
3497: Get_Options(p_x_line_tbl => l_line_opt_temp_tbl,
3498: p_set_type => l_set_type,

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

3491: l_line_tbl(I).schedule_action_code :=
3492: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
3493:
3494: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL
3495: OR l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
3496: l_in_line_rec := l_line_tbl(I);
3497: Get_Options(p_x_line_tbl => l_line_opt_temp_tbl,
3498: p_set_type => l_set_type,
3499: p_index => I,

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

3502: END IF;
3503:
3504: END IF;
3505:
3506: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
3507: FOR t in 1..l_line_tbl.count
3508: LOOP
3509: IF l_debug_level > 0 THEN
3510: oe_debug_pub.add( 'IN LOOP' ) ;

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

3755: END IF;
3756:
3757: /* FOR I IN 1 .. L_line_Tbl.Count
3758: LOOP
3759: IF l_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN
3760: Get_Options(p_x_line_tbl => l_line_tbl,
3761: p_set_type => l_set_type,
3762: p_index => I);
3763: END IF;

Line 3969: l_control_rec OE_GLOBALS.control_rec_type;

3965:
3966: l_line_rec OE_ORDER_PUB.line_rec_type;
3967: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3968: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3969: l_control_rec OE_GLOBALS.control_rec_type;
3970: l_api_name CONSTANT VARCHAR2(30) := 'Split_set';
3971: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3972:
3973: l_return_status VARCHAR2(30);

Line 4127: p_x_line_rec.operation = oe_globals.g_opr_create THEN

4123: oe_debug_pub.add( 'ENTER GET SET ID' ) ;
4124: END IF;
4125: IF (p_x_line_rec.item_type_code IS NULL OR
4126: p_x_line_rec.item_type_code = FND_API.G_MISS_CHAR) AND
4127: p_x_line_rec.operation = oe_globals.g_opr_create THEN
4128: IF l_debug_level > 0 THEN
4129: oe_debug_pub.add( 'ENTER ITEM TYPE CODE NULL' ) ;
4130: END IF;
4131:

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

4221: -- to gather informations as and when requested and process the global table.
4222: IF l_debug_level > 0 THEN
4223: oe_debug_pub.add( 'BEFORE SETTING THE LINE '||P_X_LINE_REC.LINE_ID , 1 ) ;
4224: END IF;
4225: IF (p_x_line_rec.operation = oe_globals.g_opr_create AND
4226: (p_x_line_rec.line_id = FND_API.G_MISS_NUM OR
4227: p_x_line_rec.line_id IS NULL)) THEN
4228: IF l_debug_level > 0 THEN
4229: oe_debug_pub.add( 'BEFORE SETTING THE LINE -1' , 1 ) ;

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

4430: IF NOT l_exist THEN
4431:
4432: -- This logic will add an entry into global table if already not exists one
4433:
4434: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4435: IF (p_x_line_rec.line_id IS NOT NULL AND
4436: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4437: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4438: ELSE

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

4438: ELSE
4439: g_set_tbl(I).line_id := p_index;
4440: g_set_tbl(I).operation := 'C';
4441: END IF;
4442: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4443: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4444: END IF;
4445:
4446: g_set_tbl(I).set_name := p_x_line_rec.arrival_set;

Line 4468: IF NOT OE_GLOBALS.Equal

4464: IF l_debug_level > 0 THEN
4465: oe_debug_pub.add( 'IN ARRIVAL SET ID' , 1 ) ;
4466: END IF;
4467:
4468: IF NOT OE_GLOBALS.Equal
4469: (p_x_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
4470: THEN
4471:
4472: -- Check if set exists and if not set it null

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

4688: IF Not L_Exist THEN
4689: IF l_debug_level > 0 THEN
4690: oe_debug_pub.add( 'NOT EXISTS' ) ;
4691: END IF;
4692: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4693: IF (p_x_line_rec.line_id IS NOT NULL AND
4694: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4695: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4696: ELSE

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

4696: ELSE
4697: g_set_tbl(I).line_id := p_index;
4698: g_set_tbl(I).operation := 'C';
4699: END IF;
4700: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4701: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4702: END IF;
4703: IF l_debug_level > 0 THEN
4704: oe_debug_pub.add( 'POPULATING SHIP SET S' ) ;

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

4711: p_x_line_rec.ship_set_id := NULL;
4712: END IF;
4713: ELSIF (p_x_line_rec.ship_set_id IS NOT NULL AND
4714: p_x_line_rec.ship_set_id <> FND_API.G_MISS_NUM)THEN
4715: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4716: THEN
4717: IF l_debug_level > 0 THEN
4718: oe_debug_pub.add( 'ITEM TYPE CODE' || P_X_LINE_REC.SHIP_SET_ID ) ;
4719: END IF;

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

4844: IF Not L_Exist THEN
4845: IF l_debug_level > 0 THEN
4846: oe_debug_pub.add( 'NOT EXISTS' ) ;
4847: END IF;
4848: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4849: IF (p_x_line_rec.line_id IS NOT NULL AND
4850: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4851: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4852: ELSE

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

4852: ELSE
4853: g_set_tbl(I).line_id := p_index;
4854: g_set_tbl(I).operation := 'C';
4855: END IF;
4856: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4857: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4858: END IF;
4859: g_set_tbl(I).set_name := p_x_line_rec.fulfillment_set;
4860: g_set_tbl(I).set_type := 'FULFILLMENT_SET';

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

4866: oe_debug_pub.add( 'EXIT FULLFILLMENT SET ' ) ;
4867: END IF;
4868: ELSIF (p_x_line_rec.fulfillment_set_id IS NOT NULL AND
4869: p_x_line_rec.fulfillment_set_id <> FND_API.G_MISS_NUM)THEN
4870: IF NOT OE_GLOBALS.Equal(p_x_line_rec.fulfillment_set_id,p_old_line_rec.fulfillment_set_id)
4871: THEN
4872:
4873: IF NOT Set_Exist(p_set_id => p_x_line_rec.fulfillment_set_id) THEN
4874: p_x_line_rec.fulfillment_set_id := NULL;

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

4910: IF Not L_Exist THEN
4911: IF l_debug_level > 0 THEN
4912: oe_debug_pub.add( 'NOT EXISTS' ) ;
4913: END IF;
4914: IF p_x_line_rec.operation = oe_globals.g_opr_create THEN
4915: IF (p_x_line_rec.line_id IS NOT NULL AND
4916: p_x_line_rec.line_id <> FND_API.G_MISS_NUM ) THEN
4917: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4918: ELSE

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

4918: ELSE
4919: g_set_tbl(I).line_id := p_index;
4920: g_set_tbl(I).operation := 'C';
4921: END IF;
4922: ELSIF p_x_line_rec.operation = oe_globals.g_opr_update THEN
4923: g_set_tbl(I).line_id := p_x_line_rec.line_id;
4924: END IF;
4925: g_set_tbl(I).set_name := l_set_rec.set_name;
4926: g_set_tbl(I).set_type := 'FULFILLMENT_SET';

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

4979: -- End fulfillment sets
4980:
4981: ELSE
4982: /*
4983: IF NOT OE_GLOBALS.Equal(p_x_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
4984: OR
4985: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4986: OR
4987: (p_x_line_rec.arrival_set IS NOT NULL AND

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

4981: ELSE
4982: /*
4983: IF NOT OE_GLOBALS.Equal(p_x_line_rec.arrival_set_id,p_old_line_rec.arrival_set_id)
4984: OR
4985: NOT OE_GLOBALS.Equal(p_x_line_rec.ship_set_id,p_old_line_rec.ship_set_id)
4986: OR
4987: (p_x_line_rec.arrival_set IS NOT NULL AND
4988: p_x_line_rec.arrival_set <> FND_API.G_MISS_CHAR)
4989: OR

Line 5268: l_control_rec OE_GLOBALS.control_rec_type;

5264: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5265: l_line_rec OE_ORDER_PUB.Line_rec_Type;
5266: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type :=
5267: OE_ORDER_PUB.G_MISS_LINE_TBL;
5268: l_control_rec OE_GLOBALS.control_rec_type;
5269: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Into_Set';
5270:
5271: l_return_status VARCHAR2(30);
5272: l_set_id NUMBER ;

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

5301: IF l_debug_level > 0 THEN
5302: oe_debug_pub.add( 'ENTER PROCESS SETS' ) ;
5303: END IF;
5304: IF l_debug_level > 0 THEN
5305: oe_debug_pub.add( 'RECURSION MODE' || OE_GLOBALS.G_RECURSION_MODE ) ;
5306: END IF;
5307:
5308: -- To avoid this in a recursive procedure
5309:

Line 5436: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

5432: IF l_debug_level > 0 THEN
5433: oe_debug_pub.add( 'LINE IS NOT VALID TO PROCESS: ' || L_LINE_REC.LINE_ID , 1 ) ;
5434: END IF;
5435: g_set_tbl(I).process_flag := 'Y' ;
5436: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
5437:
5438: END IF;
5439:
5440: IF (l_line_rec.item_type_code <> 'MODEL' AND

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

5875: l_line_tbl(K).fulfillment_set_id := l_Set_id;
5876: END IF;
5877: IF l_Set_type <> 'FULFILLMENT_SET' THEN
5878:
5879: l_line_tbl(K).operation := oe_globals.g_opr_update;
5880:
5881: /* Validate_set_attributes(p_set_id => l_set_id,
5882: p_Ship_From_Org_Id => l_line_tbl(K).ship_from_org_id,
5883: p_Ship_To_Org_Id => l_line_tbl(K).Ship_To_Org_Id,

Line 5966: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

5962: END IF;
5963: g_set_recursive_flag := FALSE;
5964:
5965: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5966: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
5967: END IF;
5968:
5969:
5970: FOR M in 1..l_line_tbl.count

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

6198: -- not shipped
6199:
6200: IF NOT g_old_arrival_set_path THEN
6201: IF NOT ((p_x_line_rec.split_action_code = 'SPLIT' and
6202: p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) or
6203: (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE and
6204: p_x_line_rec.split_from_line_id is NOT NULL)) then
6205:
6206: IF ((p_x_line_rec.arrival_set is not null AND

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

6199:
6200: IF NOT g_old_arrival_set_path THEN
6201: IF NOT ((p_x_line_rec.split_action_code = 'SPLIT' and
6202: p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) or
6203: (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE and
6204: p_x_line_rec.split_from_line_id is NOT NULL)) then
6205:
6206: IF ((p_x_line_rec.arrival_set is not null AND
6207: p_x_line_rec.arrival_set <> FND_API.G_MISS_CHAR) OR

Line 6246: IF p_x_line_rec.operation = oe_globals.g_opr_create

6242: -- Check if the header preference is set to keep the line in a set
6243: -- by default
6244: -- QUOTING changes - add lines to sets based on header preference
6245: -- during complete negotiation step
6246: IF p_x_line_rec.operation = oe_globals.g_opr_create
6247: OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
6248: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.transaction_phase_code
6249: ,p_old_line_rec.transaction_phase_code)
6250: )

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

6244: -- QUOTING changes - add lines to sets based on header preference
6245: -- during complete negotiation step
6246: IF p_x_line_rec.operation = oe_globals.g_opr_create
6247: OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
6248: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.transaction_phase_code
6249: ,p_old_line_rec.transaction_phase_code)
6250: )
6251: THEN
6252:

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

6466: END IF;
6467:
6468: -- Now check if the arrival set id is populated in a case when the line
6469: -- moving into existing arrival set OR removed from existing arrival set
6470: ELSIF NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_set_id,
6471: p_old_line_rec.arrival_set_id )
6472: THEN
6473: IF l_debug_level > 0 THEN
6474: oe_debug_pub.add( 'ARRIVAL SET-3'|| P_X_LINE_REC.ARRIVAL_SET_ID , 1 ) ;

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

6563: END IF;
6564:
6565: -- Now check if the arrival set id is populated in a case when the line
6566: -- moving into existing arrival set OR removed from existing arrival set
6567: ELSIF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,
6568: p_old_line_rec.ship_set_id )
6569: THEN
6570: IF l_debug_level > 0 THEN
6571: oe_debug_pub.add( 'INTO SHIP SETS '|| P_X_LINE_REC.SHIP_SET_ID , 1 ) ;

Line 6740: l_operation:=OE_GLOBALS.G_OPR_CREATE;

6736: END IF;
6737:
6738: IF OE_QUOTE_UTIL.G_COMPLETE_NEG='Y'
6739: THEN
6740: l_operation:=OE_GLOBALS.G_OPR_CREATE;
6741: ELSE
6742: l_operation:= l_child_line_rec.operation;
6743: END IF;
6744:

Line 6755: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL

6751: oe_debug_pub.add( 'new arrival set id id'||i.arrival_set_id);
6752: END IF;
6753:
6754: IF OE_Delayed_Requests_PVT.Check_for_Request
6755: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
6756: , p_entity_id =>i.line_id
6757: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
6758: THEN
6759:

Line 6757: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)

6753:
6754: IF OE_Delayed_Requests_PVT.Check_for_Request
6755: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
6756: , p_entity_id =>i.line_id
6757: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
6758: THEN
6759:
6760:
6761: OE_delayed_requests_Pvt.log_request

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

6758: THEN
6759:
6760:
6761: OE_delayed_requests_Pvt.log_request
6762: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
6763: p_entity_id => l_child_line_rec.line_id,
6764: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6765: p_requesting_entity_id => l_child_line_rec.line_id,
6766: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

Line 6764: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

6760:
6761: OE_delayed_requests_Pvt.log_request
6762: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
6763: p_entity_id => l_child_line_rec.line_id,
6764: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6765: p_requesting_entity_id => l_child_line_rec.line_id,
6766: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
6767: p_param1 => l_child_line_rec.arrival_set_id,
6768: p_param2 => l_child_line_rec.header_id,

Line 6766: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

6762: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
6763: p_entity_id => l_child_line_rec.line_id,
6764: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6765: p_requesting_entity_id => l_child_line_rec.line_id,
6766: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
6767: p_param1 => l_child_line_rec.arrival_set_id,
6768: p_param2 => l_child_line_rec.header_id,
6769: p_param3 => l_action,
6770: p_param4 => l_child_line_rec.ship_from_org_id,

Line 6798: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL

6794: oe_debug_pub.add( 'new ship set id id'||i.ship_set_id);
6795: END IF;
6796:
6797: IF OE_Delayed_Requests_PVT.Check_for_Request
6798: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
6799: , p_entity_id =>i.line_id
6800: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
6801: THEN
6802: OE_delayed_requests_Pvt.log_request

Line 6800: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)

6796:
6797: IF OE_Delayed_Requests_PVT.Check_for_Request
6798: ( p_entity_code =>OE_GLOBALS.G_ENTITY_ALL
6799: , p_entity_id =>i.line_id
6800: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
6801: THEN
6802: OE_delayed_requests_Pvt.log_request
6803: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
6804: p_entity_id => l_child_line_rec.line_id,

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

6799: , p_entity_id =>i.line_id
6800: , p_request_type =>OE_GLOBALS.G_GROUP_SCHEDULE)
6801: THEN
6802: OE_delayed_requests_Pvt.log_request
6803: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
6804: p_entity_id => l_child_line_rec.line_id,
6805: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6806: p_requesting_entity_id => l_child_line_rec.line_id,
6807: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

Line 6805: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

6801: THEN
6802: OE_delayed_requests_Pvt.log_request
6803: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
6804: p_entity_id => l_child_line_rec.line_id,
6805: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6806: p_requesting_entity_id => l_child_line_rec.line_id,
6807: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
6808: p_param1 => l_child_line_rec.ship_set_id,
6809: p_param2 => l_child_line_rec.header_id,

Line 6807: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,

6803: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL, --OE_GLOBALS.G_ENTITY_LINE,
6804: p_entity_id => l_child_line_rec.line_id,
6805: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6806: p_requesting_entity_id => l_child_line_rec.line_id,
6807: p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE,
6808: p_param1 => l_child_line_rec.ship_set_id,
6809: p_param2 => l_child_line_rec.header_id,
6810: p_param3 => l_action,
6811: p_param4 => l_child_line_rec.ship_from_org_id,

Line 6847: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

6843: oe_debug_pub.add( 'UPDATE SHIPPING : CHILDREN OF MODEL FOR SETS ' || TO_CHAR ( OPTIONREC.LINE_ID ) , 1 ) ;
6844: END IF;
6845:
6846: OE_Delayed_Requests_Pvt.Log_Request(
6847: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6848: p_entity_id => optionrec.line_id,
6849: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6850: p_requesting_entity_id => optionrec.line_id,
6851: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,

Line 6849: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

6845:
6846: OE_Delayed_Requests_Pvt.Log_Request(
6847: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6848: p_entity_id => optionrec.line_id,
6849: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6850: p_requesting_entity_id => optionrec.line_id,
6851: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
6852: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,
6853: p_param1 => FND_API.G_TRUE,

Line 6851: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,

6847: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6848: p_entity_id => optionrec.line_id,
6849: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6850: p_requesting_entity_id => optionrec.line_id,
6851: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
6852: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,
6853: p_param1 => FND_API.G_TRUE,
6854: x_return_status => l_return_status);
6855:

Line 6852: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,

6848: p_entity_id => optionrec.line_id,
6849: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6850: p_requesting_entity_id => optionrec.line_id,
6851: p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
6852: p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,
6853: p_param1 => FND_API.G_TRUE,
6854: x_return_status => l_return_status);
6855:
6856: END IF;

Line 6861: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

6857: End loop;
6858:
6859:
6860: -- Setting G_CASCADING_REQUEST_LOGGED to requery the lines in the form
6861: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
6862:
6863: exception
6864: when others then
6865: null;

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

6866: end;-- Begin of the update
6867:
6868: END IF; -- Cascade Flag
6869: ELSE -- IF not external
6870: IF NOT(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
6871: AND p_x_line_rec.top_model_line_id <> p_x_line_rec.line_id)
6872: AND p_x_line_rec.top_model_line_id IS NOT NULL THEN
6873:
6874: IF p_x_line_rec.ship_set IS NOT NULL AND

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

6889: END IF;
6890: END IF;
6891:
6892:
6893: IF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,
6894: p_old_line_rec.ship_set_id) OR
6895: NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_Set_id,
6896: p_old_line_rec.arrival_Set_id) THEN
6897:

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

6891:
6892:
6893: IF NOT OE_GLOBALS.EQUAL (p_x_line_rec.ship_set_id,
6894: p_old_line_rec.ship_set_id) OR
6895: NOT OE_GLOBALS.EQUAL (p_x_line_rec.arrival_Set_id,
6896: p_old_line_rec.arrival_Set_id) THEN
6897:
6898:
6899: IF l_debug_level > 0 THEN

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

6937:
6938:
6939: OE_DEBUG_PUB.Add('Automatic Fulfillment Set:'||p_x_line_rec.fulfillment_set);
6940:
6941: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
6942:
6943: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6944:
6945: IF OE_ORDER_CACHE.g_header_rec.default_fulfillment_set = 'Y' THEN

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

7137: END IF;
7138:
7139: l_ful_exists := 'Y';
7140:
7141: ELSIF NOT OE_GLOBALS.EQUAL(p_x_line_rec.fulfillment_set_id,
7142: p_old_line_rec.fulfillment_set_id) THEN
7143: IF NOT Set_Exist(p_set_id => p_x_line_rec.fulfillment_set_id) THEN
7144:
7145: p_x_line_rec.fulfillment_set_id := NULL;