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

Line 414: l_line_id_mod := mod(p_cal_tolerance_tbl(l_tbl_index).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918

410: -- Convert the passed table
411:
412: FOR l_tbl_index IN p_cal_tolerance_tbl.FIRST .. p_cal_tolerance_tbl.LAST
413: LOOP
414: l_line_id_mod := mod(p_cal_tolerance_tbl(l_tbl_index).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add( 'ENTERING THE CONVERT LOOP : ' || TO_CHAR ( L_TBL_INDEX ) , 3 ) ;
417: END IF;
418: /* Modified for bug 7833591

Line 512: l_line_id_mod := mod(l_line_tbl(l_line_index).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918

508: -- Assign the quantity to be shipped for shippable lines.
509: FOR l_line_index IN l_line_tbl.FIRST .. l_line_tbl.LAST
510: LOOP
511:
512: l_line_id_mod := mod(l_line_tbl(l_line_index).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918
513:
514: IF l_debug_level > 0 THEN
515: oe_debug_pub.add( 'INSIDE THE MODEL LOOP '||TO_CHAR ( L_LINE_INDEX ) , 3 ) ;
516: END IF;

Line 587: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND

583: p_shipped_quantity => l_shipped_quantity,
584: x_result_out => l_x_result_out
585: );
586:
587: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
588: l_planned_quantity_passed = FND_API.G_TRUE THEN
589:
590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 2 ) ;

Line 712: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN

708: ELSE
709: x_config_broken := FND_API.G_TRUE;
710: END IF;
711:
712: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
715: END IF;
716: x_ship_beyond_tolerance := FND_API.G_TRUE;

Line 717: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR

713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
715: END IF;
716: x_ship_beyond_tolerance := FND_API.G_TRUE;
717: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
718: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
721: END IF;

Line 718: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

714: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
715: END IF;
716: x_ship_beyond_tolerance := FND_API.G_TRUE;
717: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
718: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
721: END IF;
722: x_shipped_within_tolerance := FND_API.G_TRUE;

Line 811: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND

807: p_shipped_quantity => l_shipped_quantity,
808: x_result_out => l_x_result_out
809: );
810:
811: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
812: l_planned_quantity_passed = FND_API.G_TRUE THEN
813:
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 3 ) ;

Line 897: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN

893: END IF;
894: x_update_tolerance_flag := FND_API.G_TRUE;
895: x_ship_tolerance := l_ship_tolerance;
896:
897: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
898: x_ship_beyond_tolerance := FND_API.G_TRUE;
899: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
900: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

Line 899: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR

895: x_ship_tolerance := l_ship_tolerance;
896:
897: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
898: x_ship_beyond_tolerance := FND_API.G_TRUE;
899: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
900: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
902: IF l_debug_level > 0 THEN
903: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;

Line 900: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR

896:
897: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
898: x_ship_beyond_tolerance := FND_API.G_TRUE;
899: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
900: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
902: IF l_debug_level > 0 THEN
903: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
904: END IF;

Line 901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN

897: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
898: x_ship_beyond_tolerance := FND_API.G_TRUE;
899: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
900: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
902: IF l_debug_level > 0 THEN
903: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
904: END IF;
905: x_shipped_within_tolerance := FND_API.G_TRUE;

Line 1108: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1106: END IF;
1107:
1108: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1109: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1110: END IF;
1111:
1112: IF p_line_id IS NULL OR

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

1105: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1106: END IF;
1107:
1108: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1109: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1110: END IF;
1111:
1112: IF p_line_id IS NULL OR
1113: p_line_id = FND_API.G_MISS_NUM THEN

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

1160: -- we are not calling the notification framework
1161:
1162: -- Check if ISO is installed, then only lock the rows and call Process_Requests_And_Notify
1163:
1164: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y' ) OR
1165: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1166:
1167: OE_Line_Util.Lock_Rows
1168: (p_line_id => p_line_id

Line 1209: (OE_GLOBALS.G_ITEM_STANDARD,

1205:
1206: ELSIF (l_line_tbl(1).ato_line_id is not null
1207: AND NOT (l_line_tbl(1).ato_line_id = p_line_id AND
1208: l_line_tbl(1).item_type_code IN
1209: (OE_GLOBALS.G_ITEM_STANDARD,
1210: OE_GLOBALS.G_ITEM_OPTION,
1211: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1212: THEN
1213:

Line 1210: OE_GLOBALS.G_ITEM_OPTION,

1206: ELSIF (l_line_tbl(1).ato_line_id is not null
1207: AND NOT (l_line_tbl(1).ato_line_id = p_line_id AND
1208: l_line_tbl(1).item_type_code IN
1209: (OE_GLOBALS.G_ITEM_STANDARD,
1210: OE_GLOBALS.G_ITEM_OPTION,
1211: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1212: THEN
1213:
1214: Update oe_order_lines_all

Line 1211: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352

1207: AND NOT (l_line_tbl(1).ato_line_id = p_line_id AND
1208: l_line_tbl(1).item_type_code IN
1209: (OE_GLOBALS.G_ITEM_STANDARD,
1210: OE_GLOBALS.G_ITEM_OPTION,
1211: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1212: THEN
1213:
1214: Update oe_order_lines_all
1215: Set firm_demand_flag = 'Y'

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

1252:
1253: -- bug 3454703
1254:
1255: IF OE_ORDER_UTIL.g_old_line_tbl.EXISTS(l_index) THEN
1256: IF OE_ORDER_UTIL.g_old_line_tbl(l_index).OPERATION = oe_globals.g_opr_create THEN
1257: l_is_op_create := 'Y';
1258: END IF;
1259: END IF;
1260: -- end bug 3454703

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

1262: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
1263: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1264: -- bug 3454703
1265: IF l_is_op_create = 'Y' THEN
1266: OE_ORDER_UTIL.g_old_line_tbl(l_index).OPERATION := oe_globals.g_opr_create;
1267: END IF;
1268: -- end bug 3454703
1269: OE_ORDER_UTIL.g_line_tbl(l_index).line_id := l_line_tbl(1).line_id;
1270: OE_ORDER_UTIL.g_line_tbl(l_index).header_id := l_line_tbl(1).header_id;

Line 1321: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

1317: Set firm_demand_flag = 'Y'
1318: Where top_model_line_id = l_top_model_line_id;
1319: ELSIF (l_ato_line_id is not null
1320: AND NOT (l_ato_line_id = p_line_id AND
1321: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1322: OE_GLOBALS.G_ITEM_OPTION,
1323: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1324: THEN
1325:

Line 1322: OE_GLOBALS.G_ITEM_OPTION,

1318: Where top_model_line_id = l_top_model_line_id;
1319: ELSIF (l_ato_line_id is not null
1320: AND NOT (l_ato_line_id = p_line_id AND
1321: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1322: OE_GLOBALS.G_ITEM_OPTION,
1323: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1324: THEN
1325:
1326: Update oe_order_lines_all

Line 1323: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352

1319: ELSIF (l_ato_line_id is not null
1320: AND NOT (l_ato_line_id = p_line_id AND
1321: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1322: OE_GLOBALS.G_ITEM_OPTION,
1323: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1324: THEN
1325:
1326: Update oe_order_lines_all
1327: Set firm_demand_flag = 'Y'

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

1332: END; -- For begin
1333:
1334:
1335: END IF; -- Firm flag
1336: END IF; -- IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' or DBI installed.
1337:
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1340: END IF;