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

Line 337: p_item_type => OE_GLOBALS.G_WFI_LIN

333: END IF;
334:
335: Get_Activity_Result
336: (
337: p_item_type => OE_GLOBALS.G_WFI_LIN
338: , p_item_key => l_item_key
339: , p_activity_name => l_fulfill_activity
340: , x_return_status => l_return_status
341: , x_activity_result => l_activity_result

Line 508: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

504: l_fulfill_tbl(l_fulfill_index).header_id := l_service_tbl(l_service_index).header_id;
505: l_fulfill_tbl(l_fulfill_index).inventory_item_id := l_service_tbl(l_service_index).inventory_item_id;
506: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_service_tbl(l_service_index).order_firmed_date;
507: l_fulfill_tbl(l_fulfill_index).actual_shipment_date := l_service_tbl(l_service_index).actual_shipment_date;
508: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'FULFILL INDEX : '||TO_CHAR ( L_FULFILL_INDEX ) , 3 ) ;
511: oe_debug_pub.add( 'FULFILLED FLAG : '||L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_FLAG , 3 ) ;
512: oe_debug_pub.add( 'FULFILLED QUANTITY : '||TO_CHAR ( L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_QUANTITY ) , 3 ) ;

Line 772: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

768:
769: l_line_rec.service_start_date := NULL; -- initialization for 2292133
770: l_line_rec.service_end_date := NULL;
771:
772: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
773: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
774: END IF;
775:
776: /* Commented for performance changes.

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

769: l_line_rec.service_start_date := NULL; -- initialization for 2292133
770: l_line_rec.service_end_date := NULL;
771:
772: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
773: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
774: END IF;
775:
776: /* Commented for performance changes.
777: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

Line 777: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

773: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
774: END IF;
775:
776: /* Commented for performance changes.
777: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
778: l_control_rec.validate_entity := FALSE;
779: l_control_rec.check_security := FALSE;
780: */
781: IF p_mode = 'RECORD' THEN

Line 796: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

792:
793: /* Commented for performance changes
794: l_update_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
795: l_update_line_tbl(1).line_id := p_line_rec.line_id;
796: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
797: */
798: /* Start Audit Trail */
799: -- l_update_line_tbl(1).change_reason := 'SYSTEM';
800: -- l_update_line_tbl(1).change_comments := 'Process fulfillment set';

Line 842: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */

838:
839: END IF;
840: --webroot bug 6826344 end
841:
842: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */
843: OR (l_accounting_rule_type = 'PP_DR_PP' OR l_accounting_rule_type = 'PP_DR_ALL') THEN -- added for webroot bug 6826344
844: l_line_rec := p_line_rec;
845: l_line_rec.fulfillment_date := SYSDATE;
846:

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

849: END IF;
850: IF l_debug_level > 0 THEN
851: oe_debug_pub.add('After calling update_service_lines() ',5) ;
852: END IF;
853: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
854: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
855: IF l_debug_level > 0 THEN
856: oe_debug_pub.add('mode is record',3) ;
857: END IF;

Line 977: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN

973: ACTUAL_FULFILLMENT_DATE = l_actual_fulfillment_date,
974: LOCK_CONTROL = LOCK_CONTROL+1
975: WHERE LINE_ID = p_line_rec.line_id;
976:
977: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
978: /* Start Improved OM,IB,OKS changes */
979: select order_number
980: into l_order_number
981: from oe_order_headers_all

Line 1022: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE THEN

1018: Update_Blanket_Qty(p_line_rec,l_fulfilled_quantity);
1019: END IF;
1020: END IF;
1021:
1022: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE THEN
1023: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1024: csi_ont_txn_pub.posttransaction
1025: (
1026: p_order_line_id => p_line_rec.line_id,

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

1071: -- Changes for AFD
1072: l_actual_fulfillment_date := nvl(p_line_tbl(l_index).actual_shipment_date,nvl(p_line_tbl(l_index).order_firmed_date,l_ordered_date));
1073: -- END CHANGES for AFD
1074:
1075: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1076: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )THEN
1077:
1078: OE_Line_Util.Lock_Rows
1079: (p_line_id => p_line_tbl(l_index).line_id

Line 1118: IF l_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */ THEN

1114: -- Changes for AFD
1115: l_line_tbl(l_index).actual_fulfillment_date := l_actual_fulfillment_date;
1116: -- END CHANGES for AFD
1117:
1118: IF l_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2048753 */ THEN
1119: l_line_rec := l_line_tbl(l_index);
1120: Update_Service_Dates(l_line_rec);
1121: l_line_tbl(l_index).service_start_date := l_line_rec.service_start_date;
1122: l_line_tbl(l_index).service_end_date := l_line_rec.service_end_date;

Line 1177: ELSIF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2292133 */

1173: END IF;
1174: END IF;
1175: END IF; --code_release_level
1176: -- notification framework end
1177: ELSIF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2292133 */
1178: OR p_line_tbl(l_index).item_type_code IS NULL -- 2417601
1179: OR p_line_tbl(l_index).item_type_code = FND_API.G_MISS_CHAR THEN -- 2417601
1180: l_line_rec := p_line_tbl(l_index);
1181: open srv_lines;

Line 1190: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN -- 2417601

1186: l_line_rec.service_duration,
1187: l_line_rec.service_coterminate_flag,
1188: l_line_rec.item_type_code;
1189: close srv_lines;
1190: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN -- 2417601
1191: Update_Service_Dates(l_line_rec);
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add('After calling update_service_dates - aso not installed',5) ;
1194: END IF;

Line 1196: END IF; /* IF OE_GLOBALS.G_ASO_INSTALLED */

1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add('After calling update_service_dates - aso not installed',5) ;
1194: END IF;
1195: END IF;
1196: END IF; /* IF OE_GLOBALS.G_ASO_INSTALLED */
1197:
1198: IF l_debug_level > 0 THEN
1199: oe_debug_pub.add('Updating line : '||p_line_tbl(l_index).line_id,3) ;
1200: END IF;

Line 1202: -- IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423

1198: IF l_debug_level > 0 THEN
1199: oe_debug_pub.add('Updating line : '||p_line_tbl(l_index).line_id,3) ;
1200: END IF;
1201:
1202: -- IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1203: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1204: /* 2417601 uses a different update statements for service line */
1205:
1206:

Line 1203: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423

1199: oe_debug_pub.add('Updating line : '||p_line_tbl(l_index).line_id,3) ;
1200: END IF;
1201:
1202: -- IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1203: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1204: /* 2417601 uses a different update statements for service line */
1205:
1206:
1207: UPDATE OE_ORDER_LINES_ALL

Line 1288: IF p_line_tbl(l_index).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE THEN

1284: ,p_line_tbl(l_index).fulfilled_quantity);
1285: END IF;
1286: END IF;
1287:
1288: IF p_line_tbl(l_index).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE THEN
1289: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1290: csi_ont_txn_pub.posttransaction(
1291: p_order_line_id => p_line_tbl(l_index).line_id,
1292: x_return_status => x_return_status,

Line 1318: OE_GLOBALS.G_RECURSION_MODE := 'Y';

1314:
1315: /* Commented for performance changes.
1316: oe_debug_pub.ADD('Calling OE_Order_PVT.Process_Order to update the fulfilled quantity and fulfilled flag',2);
1317:
1318: OE_GLOBALS.G_RECURSION_MODE := 'Y';
1319: OE_Shipping_Integration_PVT.Call_Process_Order
1320: (
1321: p_line_tbl => l_update_line_tbl,
1322: p_control_rec => l_control_rec,

Line 1326: OE_GLOBALS.G_RECURSION_MODE := 'N';

1322: p_control_rec => l_control_rec,
1323: x_return_status => l_return_status
1324: );
1325:
1326: OE_GLOBALS.G_RECURSION_MODE := 'N';
1327:
1328: oe_debug_pub.add('Return Status from Process Order : '||l_return_status,2);
1329:
1330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1337: IF (OE_GLOBALS.G_ASO_INSTALLED = 'Y') THEN

1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335: */
1336: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN
1337: IF (OE_GLOBALS.G_ASO_INSTALLED = 'Y') THEN
1338:
1339: -- #2769599
1340: IF (nvl(oe_order_cache.g_header_rec.header_id,-999)<>p_line_rec.header_id) THEN
1341: IF l_debug_level > 0 THEN

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

1367:
1368:
1369: ELSE
1370: /* Pack H or higher */
1371: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1372: ( NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1373:
1374:
1375: OE_ORDER_PVT.Process_Requests_and_Notify

Line 1797: l_item_type VARCHAR2(8) := OE_GLOBALS.G_WFI_LIN;

1793: IS
1794: l_fulfill_attr_name VARCHAR2(30) := 'FULFILLMENT_ACTIVITY';
1795: l_in_fulfill_attr_name VARCHAR2(30) := 'INBOUND_FULFILLMENT_ACTIVITY';
1796: l_fulfill_activity_name VARCHAR2(30);
1797: l_item_type VARCHAR2(8) := OE_GLOBALS.G_WFI_LIN;
1798: l_result_attr_name VARCHAR2(30) := 'COMPLETION_RESULT';
1799: l_in_result_attr_name VARCHAR2(30) := 'INBOUND_COMPLETION_RESULT';
1800: l_completion_result VARCHAR2(30);
1801: l_activity_result VARCHAR2(30) := 'NO_RESULT';

Line 1911: l_activity_status := OE_GLOBALS.G_WFR_COMPLETE;

1907: WHERE line_id = to_number(p_item_key);
1908: IF l_upgraded_flag = 'N' THEN
1909: RAISE FND_API.G_EXC_ERROR;
1910: ELSE
1911: l_activity_status := OE_GLOBALS.G_WFR_COMPLETE;
1912: END IF; -- bug 3589692 ends
1913: END IF;
1914:
1915: IF l_activity_status <> OE_GLOBALS.G_WFR_COMPLETE THEN

Line 1915: IF l_activity_status <> OE_GLOBALS.G_WFR_COMPLETE THEN

1911: l_activity_status := OE_GLOBALS.G_WFR_COMPLETE;
1912: END IF; -- bug 3589692 ends
1913: END IF;
1914:
1915: IF l_activity_status <> OE_GLOBALS.G_WFR_COMPLETE THEN
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF;
1918:
1919: END IF;

Line 2017: p_item_type => OE_GLOBALS.G_WFI_LIN

2013: END IF;
2014:
2015: Get_Activity_Result
2016: (
2017: p_item_type => OE_GLOBALS.G_WFI_LIN
2018: , p_item_key => l_item_key
2019: , p_activity_name => l_fulfill_activity
2020: , x_return_status => l_return_status
2021: , x_activity_result => l_activity_result

Line 2478: p_item_type => OE_GLOBALS.G_WFI_LIN

2474: END IF;
2475:
2476: Get_Activity_Result
2477: (
2478: p_item_type => OE_GLOBALS.G_WFI_LIN
2479: , p_item_key => l_item_key
2480: , p_activity_name => l_fulfill_activity
2481: , x_return_status => l_return_status
2482: , x_activity_result => l_activity_result

Line 2619: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

2615: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_line_tbl(l_line_index).order_firmed_date;
2616: -- end of changes for AFD
2617:
2618:
2619: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
2620: IF l_debug_level > 0 THEN
2621: oe_debug_pub.add('index - '||l_fulfill_index,5);
2622: oe_debug_pub.add('fulfilled flag - '||l_fulfill_tbl(l_fulfill_index).fulfilled_flag,5);
2623: oe_debug_pub.add('quantity - '||l_fulfill_tbl(l_fulfill_index).fulfilled_quantity,5);

Line 2670: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

2666: l_fulfill_tbl(l_fulfill_index).actual_shipment_date := l_service_tbl(l_service_index).actual_shipment_date;
2667: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_service_tbl(l_service_index).order_firmed_date;
2668: -- end changes for AFD
2669:
2670: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add('index - '||l_fulfill_index,5);
2673: oe_debug_pub.add('fulfilled flag - '||l_fulfill_tbl(l_fulfill_index).fulfilled_flag,5);
2674: oe_debug_pub.add('fulfilled quantity - '||l_fulfill_tbl(l_fulfill_index).fulfilled_quantity,5);

Line 3068: p_item_type => OE_GLOBALS.G_WFI_LIN

3064: END IF;
3065:
3066: Get_Activity_Result
3067: (
3068: p_item_type => OE_GLOBALS.G_WFI_LIN
3069: , p_item_key => l_item_key
3070: , p_activity_name => l_fulfill_activity
3071: , x_return_status => l_return_status
3072: , x_activity_result => l_activity_result

Line 3166: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

3162: l_fulfill_tbl(l_fulfill_index).actual_shipment_date := l_service_tbl(l_service_index).actual_shipment_date;
3163: l_fulfill_tbl(l_fulfill_index).order_firmed_date := l_service_tbl(l_service_index).order_firmed_date;
3164: -- end changes for AFD
3165:
3166: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
3167: IF l_debug_level > 0 THEN
3168: oe_debug_pub.add( 'FULFILL INDEX : '||TO_CHAR ( L_FULFILL_INDEX ) , 3 ) ;
3169: oe_debug_pub.add( 'FULFILLED FLAG : '||L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_FLAG , 3 ) ;
3170: oe_debug_pub.add( 'FULFILLED QUANTITY : '||TO_CHAR ( L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_QUANTITY ) , 3 ) ;

Line 3233: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

3229: -- end Changes for AFD
3230:
3231: CLOSE c_line;
3232: -- End bug 3061559
3233: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
3234: IF l_debug_level > 0 THEN
3235: oe_debug_pub.add( 'FULFILL INDEX : '||TO_CHAR ( L_FULFILL_INDEX ) , 3 ) ;
3236: oe_debug_pub.add( 'FULFILLED FLAG : '||L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_FLAG , 3 ) ;
3237: oe_debug_pub.add( 'FULFILLED QUANTITY : '||TO_CHAR ( L_FULFILL_TBL ( L_FULFILL_INDEX ) .FULFILLED_QUANTITY ) , 3 ) ;

Line 3851: p_item_type => OE_GLOBALS.G_WFI_LIN

3847: l_item_key := to_char(l_line_tbl(l_line_index).line_id);
3848:
3849: Get_Activity_Result
3850: (
3851: p_item_type => OE_GLOBALS.G_WFI_LIN
3852: , p_item_key => l_item_key
3853: , p_activity_name => 'FULFILL_LINE'
3854: , x_return_status => l_return_status
3855: , x_activity_result => l_activity_result

Line 3974: l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

3970: x_line_tbl => l_line_tbl);
3971: FOR l_line_index IN l_line_tbl.FIRST .. l_line_tbl.LAST
3972: LOOP
3973: IF l_line_tbl(l_line_index).ato_line_id = l_line_rec.ato_line_id AND
3974: l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
3975: l_config_index := l_line_index;
3976: GOTO CONFIG_FOUND;
3977: END IF;
3978:

Line 3995: p_item_type => OE_GLOBALS.G_WFI_LIN

3991: END IF;
3992:
3993: Get_Activity_Result
3994: (
3995: p_item_type => OE_GLOBALS.G_WFI_LIN
3996: , p_item_key => l_item_key
3997: , p_activity_name => 'FULFILL_LINE'
3998: , x_return_status => l_return_status
3999: , x_activity_result => l_activity_result

Line 4095: p_item_type => OE_GLOBALS.G_WFI_LIN

4091: END IF;
4092:
4093: Get_Activity_Result
4094: (
4095: p_item_type => OE_GLOBALS.G_WFI_LIN
4096: , p_item_key => l_item_key
4097: , p_activity_name => 'FULFILL_LINE'
4098: , x_return_status => l_return_status
4099: , x_activity_result => l_activity_result

Line 4893: p_item_type => OE_GLOBALS.G_WFI_LIN

4889: ELSE
4890:
4891: Get_Activity_Result
4892: (
4893: p_item_type => OE_GLOBALS.G_WFI_LIN
4894: , p_item_key => to_char(l_ful_set_tbl(l_ful_set_index).line_id)
4895: , p_activity_name => 'FULFILL_LINE'
4896: , x_return_status => l_return_status
4897: , x_activity_result => l_activity_result

Line 5089: ( p_item_type => OE_GLOBALS.G_WFI_LIN

5085: --bug3292817 start
5086: l_activity_status := 'NOTIFIED';
5087: IF OE_OE_FORM_CANCEL_LINE.g_num_of_records > 1 THEN
5088: Get_Activity_Result
5089: ( p_item_type => OE_GLOBALS.G_WFI_LIN
5090: ,p_item_key =>
5091: to_char(l_ful_set_tbl(l_ful_set_index).line_id)
5092: ,p_activity_name => 'FULFILL_LINE'
5093: ,x_return_status => l_return_status

Line 5258: p_item_type => OE_GLOBALS.G_WFI_LIN

5254: ELSE
5255:
5256: Get_Activity_Result
5257: (
5258: p_item_type => OE_GLOBALS.G_WFI_LIN
5259: , p_item_key => to_char(p_line_id)
5260: , p_activity_name => 'FULFILL_LINE'
5261: , x_return_status => l_return_status
5262: , x_activity_result => l_activity_result