DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_GLOBALS

Line 568: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND

564: p_shipped_quantity => l_shipped_quantity,
565: x_result_out => l_x_result_out
566: );
567:
568: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
569: l_planned_quantity_passed = FND_API.G_TRUE THEN
570:
571: IF l_debug_level > 0 THEN
572: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 2 ) ;

Line 689: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN

685: ELSE
686: x_config_broken := FND_API.G_TRUE;
687: END IF;
688:
689: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
692: END IF;
693: x_ship_beyond_tolerance := FND_API.G_TRUE;

Line 694: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR

690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
692: END IF;
693: x_ship_beyond_tolerance := FND_API.G_TRUE;
694: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
695: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
698: END IF;

Line 695: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

691: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
692: END IF;
693: x_ship_beyond_tolerance := FND_API.G_TRUE;
694: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
695: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
698: END IF;
699: x_shipped_within_tolerance := FND_API.G_TRUE;

Line 788: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND

784: p_shipped_quantity => l_shipped_quantity,
785: x_result_out => l_x_result_out
786: );
787:
788: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
789: l_planned_quantity_passed = FND_API.G_TRUE THEN
790:
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 3 ) ;

Line 874: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN

870: END IF;
871: x_update_tolerance_flag := FND_API.G_TRUE;
872: x_ship_tolerance := l_ship_tolerance;
873:
874: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
875: x_ship_beyond_tolerance := FND_API.G_TRUE;
876: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
877: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

Line 876: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR

872: x_ship_tolerance := l_ship_tolerance;
873:
874: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
875: x_ship_beyond_tolerance := FND_API.G_TRUE;
876: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
877: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;

Line 877: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR

873:
874: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
875: x_ship_beyond_tolerance := FND_API.G_TRUE;
876: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
877: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
881: END IF;

Line 878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

874: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
875: x_ship_beyond_tolerance := FND_API.G_TRUE;
876: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
877: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
881: END IF;
882: x_shipped_within_tolerance := FND_API.G_TRUE;

Line 1085: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1083: END IF;
1084:
1085: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1086: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1087: END IF;
1088:
1089: IF p_line_id IS NULL OR

Line 1086: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

1082: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1083: END IF;
1084:
1085: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1086: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1087: END IF;
1088:
1089: IF p_line_id IS NULL OR
1090: p_line_id = FND_API.G_MISS_NUM THEN

Line 1141: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y' ) OR

1137: -- we are not calling the notification framework
1138:
1139: -- Check if ISO is installed, then only lock the rows and call Process_Requests_And_Notify
1140:
1141: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y' ) OR
1142: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1143:
1144: OE_Line_Util.Lock_Rows
1145: (p_line_id => p_line_id

Line 1186: (OE_GLOBALS.G_ITEM_STANDARD,

1182:
1183: ELSIF (l_line_tbl(1).ato_line_id is not null
1184: AND NOT (l_line_tbl(1).ato_line_id = p_line_id AND
1185: l_line_tbl(1).item_type_code IN
1186: (OE_GLOBALS.G_ITEM_STANDARD,
1187: OE_GLOBALS.G_ITEM_OPTION)))
1188: THEN
1189:
1190: Update oe_order_lines_all

Line 1187: OE_GLOBALS.G_ITEM_OPTION)))

1183: ELSIF (l_line_tbl(1).ato_line_id is not null
1184: AND NOT (l_line_tbl(1).ato_line_id = p_line_id AND
1185: l_line_tbl(1).item_type_code IN
1186: (OE_GLOBALS.G_ITEM_STANDARD,
1187: OE_GLOBALS.G_ITEM_OPTION)))
1188: THEN
1189:
1190: Update oe_order_lines_all
1191: Set firm_demand_flag = 'Y'

Line 1232: IF OE_ORDER_UTIL.g_old_line_tbl(l_index).OPERATION = oe_globals.g_opr_create THEN

1228:
1229: -- bug 3454703
1230:
1231: IF OE_ORDER_UTIL.g_old_line_tbl.EXISTS(l_index) THEN
1232: IF OE_ORDER_UTIL.g_old_line_tbl(l_index).OPERATION = oe_globals.g_opr_create THEN
1233: l_is_op_create := 'Y';
1234: END IF;
1235: END IF;
1236: -- end bug 3454703

Line 1242: OE_ORDER_UTIL.g_old_line_tbl(l_index).OPERATION := oe_globals.g_opr_create;

1238: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
1239: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1240: -- bug 3454703
1241: IF l_is_op_create = 'Y' THEN
1242: OE_ORDER_UTIL.g_old_line_tbl(l_index).OPERATION := oe_globals.g_opr_create;
1243: END IF;
1244: -- end bug 3454703
1245: OE_ORDER_UTIL.g_line_tbl(l_index).line_id := l_line_tbl(1).line_id;
1246: OE_ORDER_UTIL.g_line_tbl(l_index).header_id := l_line_tbl(1).header_id;

Line 1297: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

1293: Set firm_demand_flag = 'Y'
1294: Where top_model_line_id = l_top_model_line_id;
1295: ELSIF (l_ato_line_id is not null
1296: AND NOT (l_ato_line_id = p_line_id AND
1297: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1298: OE_GLOBALS.G_ITEM_OPTION)))
1299: THEN
1300:
1301: Update oe_order_lines_all

Line 1298: OE_GLOBALS.G_ITEM_OPTION)))

1294: Where top_model_line_id = l_top_model_line_id;
1295: ELSIF (l_ato_line_id is not null
1296: AND NOT (l_ato_line_id = p_line_id AND
1297: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1298: OE_GLOBALS.G_ITEM_OPTION)))
1299: THEN
1300:
1301: Update oe_order_lines_all
1302: Set firm_demand_flag = 'Y'

Line 1311: END IF; -- IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' or DBI installed.

1307: END; -- For begin
1308:
1309:
1310: END IF; -- Firm flag
1311: END IF; -- IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' or DBI installed.
1312:
1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1315: END IF;