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

Line 44: l_control_rec OE_GLOBALS.Control_Rec_Type;

40: Is
41: l_api_name VARCHAR2(30) := 'UPDATELINE';
42: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
43: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
44: l_control_rec OE_GLOBALS.Control_Rec_Type;
45: l_return_status VARCHAR2(1);
46: l_line_rec OE_Order_PUB.Line_Rec_Type;
47:
48: --

Line 110: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

106: l_line_tbl(1).change_reason := p_change_reason;
107: l_line_tbl(1).change_comments := p_change_comments;
108:
109: -- Set Operation.
110: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
111:
112: -- Populate line table
113:
114: -- Call OE_Order_PVT.Process_order

Line 251: OE_DEBUG_PUB.add('Entering perform_line_change() with reason required flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

247: -- defined at booked orders only, then cancel history record would be inserted
248: -- without reason code.
249:
250: IF l_debug_level > 0 THEN
251: OE_DEBUG_PUB.add('Entering perform_line_change() with reason required flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
252: END IF;
253:
254: l_order_quantity_uom := p_line_rec.order_quantity_uom; --bug 5702849
255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);

Line 257: IF (p_line_rec.operation <> oe_globals.g_opr_create AND

253:
254: l_order_quantity_uom := p_line_rec.order_quantity_uom; --bug 5702849
255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);
256:
257: IF (p_line_rec.operation <> oe_globals.g_opr_create AND
258: -- p_line_rec.split_action_code <> 'SPLIT') THEN -- Bug 8841055
259: Nvl(p_line_rec.split_action_code,Fnd_Api.G_Miss_Char) <> 'SPLIT') THEN
260:
261: IF l_debug_level > 0 THEN

Line 271: IF ((oe_sales_can_util.G_REQUIRE_REASON) and (nvl(oe_globals.g_pricing_recursion, 'N') = 'N')) THEN

267: IF (nvl(p_line_rec.ordered_quantity, 0) < nvl(p_old_line_rec.ordered_quantity, 0)) THEN
268: l_cancelled_qty := nvl(p_old_line_rec.ordered_quantity, 0) - nvl(p_line_rec.ordered_quantity, 0);
269: --13939745 start
270: --IF (oe_sales_can_util.G_REQUIRE_REASON) THEN
271: IF ((oe_sales_can_util.G_REQUIRE_REASON) and (nvl(oe_globals.g_pricing_recursion, 'N') = 'N')) THEN
272: --13939745 end
273: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;
274: ELSE
275: lhisttypecode := 'QUANTITY UPDATE';

Line 273: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;

269: --13939745 start
270: --IF (oe_sales_can_util.G_REQUIRE_REASON) THEN
271: IF ((oe_sales_can_util.G_REQUIRE_REASON) and (nvl(oe_globals.g_pricing_recursion, 'N') = 'N')) THEN
272: --13939745 end
273: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;
274: ELSE
275: lhisttypecode := 'QUANTITY UPDATE';
276: END IF;
277: ELSIF (nvl(p_line_rec.ordered_quantity, 0) > nvl(p_old_line_rec.ordered_quantity, 0)) THEN

Line 285: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;

281: -- INVCONV
282: IF (nvl(p_line_rec.ordered_quantity2, 0) < nvl(p_old_line_rec.ordered_quantity2, 0)) THEN
283: l_cancelled_qty2 := nvl(p_old_line_rec.ordered_quantity2, 0) - nvl(p_line_rec.ordered_quantity2, 0);
284: IF (oe_sales_can_util.G_REQUIRE_REASON) THEN
285: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;
286: ELSE
287: lhisttypecode := 'QUANTITY UPDATE';
288: END IF;
289: ELSIF (nvl(p_line_rec.ordered_quantity2, 0) > nvl(p_old_line_rec.ordered_quantity2, 0)) THEN

Line 339: -- is cancelled, it will log a OE_GLOBALS.G_UPDATE_REQUISITION delayed

335: -- there will not be any descrepancy between the OM and Purchasing for
336: -- partial internal sales order line cancellation, createed as part of
337: -- system split after partial shipping against the original internal sales
338: -- order line. From this project, onwards, if an internal sales order line
339: -- is cancelled, it will log a OE_GLOBALS.G_UPDATE_REQUISITION delayed
340: -- request, whose execution will call the Puchasing API
341: -- PO_RCO_Validation_GRP.Update_ReqCancel_from_SO(). It will be this
342: -- purchasing API responsibility to update the MTL_Supply table for
343: -- quantity change in internal sales order line.

Line 425: OE_DEBUG_PUB.add('Audit Trail Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

421: /* IR ISO Change Management project End */
422:
423:
424: IF l_debug_level > 0 THEN
425: OE_DEBUG_PUB.add('Audit Trail Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
426: oe_debug_pub.add('Line change reason : '||p_line_rec.change_reason,1);
427: END IF;
428:
429: -- #2743789 changes

Line 439: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N' THEN

435:
436: --Commented out hre following block of code for bug #3665150
437: /* IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN -- reinstated for 2653505
438:
439: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N' THEN
440: IF p_line_rec.change_reason IS NULL OR
441: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add('Cancellation Reason is Not Provided',1);

Line 472: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

468: END IF;
469:
470: --11.5.10 Versioning/Audit Trail updates
471: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
472: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
473: p_entity_id => p_line_rec.line_id,
474: p_hist_type_code => lhisttypecode);
475: --log delayed request
476: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 476: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

472: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
473: p_entity_id => p_line_rec.line_id,
474: p_hist_type_code => lhisttypecode);
475: --log delayed request
476: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
477: p_entity_id => p_line_rec.header_id,
478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
479: p_requesting_entity_id => p_line_rec.line_id,
480: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

474: p_hist_type_code => lhisttypecode);
475: --log delayed request
476: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
477: p_entity_id => p_line_rec.header_id,
478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
479: p_requesting_entity_id => p_line_rec.line_id,
480: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
481: x_return_status => l_return_status);
482: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

Line 480: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

476: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
477: p_entity_id => p_line_rec.header_id,
478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
479: p_requesting_entity_id => p_line_rec.line_id,
480: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
481: x_return_status => l_return_status);
482: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
483: ELSE
484: OE_CHG_ORDER_PVT.RecordLineHist

Line 482: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
479: p_requesting_entity_id => p_line_rec.line_id,
480: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
481: x_return_status => l_return_status);
482: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
483: ELSE
484: OE_CHG_ORDER_PVT.RecordLineHist
485: ( p_line_id => p_line_rec.line_id
486: , p_line_rec => p_line_rec

Line 583: OE_STANDARD_WF.Get_LineProcessName(OE_GLOBALS.G_WFI_LIN, p_line_rec.line_id,

579: /*
580: ** Recommented for clarity. WF activity is progressed in OEXULINB.pls
581:
582: Abort Wf activities
583: OE_STANDARD_WF.Get_LineProcessName(OE_GLOBALS.G_WFI_LIN, p_line_rec.line_id,
584: l_line_process_name);
585:
586: If p_line_rec.ordered_quantity = 0 then
587: wf_engine.abortprocess(OE_Globals.G_WFI_LIN

Line 587: wf_engine.abortprocess(OE_Globals.G_WFI_LIN

583: OE_STANDARD_WF.Get_LineProcessName(OE_GLOBALS.G_WFI_LIN, p_line_rec.line_id,
584: l_line_process_name);
585:
586: If p_line_rec.ordered_quantity = 0 then
587: wf_engine.abortprocess(OE_Globals.G_WFI_LIN
588: ,to_char(p_line_rec.line_id)
589: ,l_line_process_name);
590: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');
591: Using Retry option to run close activity

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

588: ,to_char(p_line_rec.line_id)
589: ,l_line_process_name);
590: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');
591: Using Retry option to run close activity
592: OE_GLOBALS.G_RECURSION_MODE := 'Y';
593: wf_engine.handleerror(OE_Globals.G_WFI_LIN
594: ,to_char(p_line_rec.line_id)
595: ,'CLOSE_LINE',
596: 'RETRY','CANCEL');

Line 593: wf_engine.handleerror(OE_Globals.G_WFI_LIN

589: ,l_line_process_name);
590: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');
591: Using Retry option to run close activity
592: OE_GLOBALS.G_RECURSION_MODE := 'Y';
593: wf_engine.handleerror(OE_Globals.G_WFI_LIN
594: ,to_char(p_line_rec.line_id)
595: ,'CLOSE_LINE',
596: 'RETRY','CANCEL');
597: OE_DEBUG_PUB.ADD('After Calling Wf Handle Error ');

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

595: ,'CLOSE_LINE',
596: 'RETRY','CANCEL');
597: OE_DEBUG_PUB.ADD('After Calling Wf Handle Error ');
598: NULL;
599: OE_GLOBALS.G_RECURSION_MODE := 'N';
600: end if;
601: */
602:
603: -- Release Holds

Line 646: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

642:
643: IF p_line_rec.ordered_quantity = 0 THEN
644:
645: oe_delayed_requests_pvt.log_request(
646: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
647: p_entity_id => p_line_rec.header_id,
648: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
649: p_requesting_entity_id => p_line_rec.header_id,
650: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,

Line 648: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

644:
645: oe_delayed_requests_pvt.log_request(
646: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
647: p_entity_id => p_line_rec.header_id,
648: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
649: p_requesting_entity_id => p_line_rec.header_id,
650: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,
651: x_return_status => l_return_status);
652:

Line 650: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,

646: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
647: p_entity_id => p_line_rec.header_id,
648: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
649: p_requesting_entity_id => p_line_rec.header_id,
650: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,
651: x_return_status => l_return_status);
652:
653: End if;
654:

Line 721: IF (p_x_line_rec.operation <> oe_globals.g_opr_create AND

717: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
718: --
719: BEGIN
720: -- x_line_Rec := p_line_Rec;
721: IF (p_x_line_rec.operation <> oe_globals.g_opr_create AND
722: nvl(p_x_line_rec.split_action_code,'X') <> 'SPLIT') THEN
723: -- OE_SALES_CAN_UTIL.G_REQUIRE_REASON := FALSE;
724:
725: IF l_debug_level > 0 THEN

Line 1086: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)

1082: --
1083: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1084: --
1085: begin
1086: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
1087: THEN
1088: --IF (nvl(p_line_rec.line_category_code,' ') <> 'RETURN') THEN
1089:
1090: /* Fix bug # 2136529: Get the old quantities from the database */

Line 1109: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN

1105: oe_debug_pub.add( 'OLD CANCELLED QUANTITY IS: '||L_OLD_CAN_QUANTITY ) ;
1106: END IF;
1107:
1108: IF (l_old_ord_quantity > p_line_rec.ordered_quantity)
1109: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN
1110: G_CANCELLATION_ACTION := 'C'; -- 12695580
1111: l_new_can_quantity := l_old_ord_quantity - p_line_rec.ordered_quantity
1112: + l_old_can_quantity;
1113: ELSE

Line 1121: AND nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN

1117: /* Bug 12695580
1118: ** G_CANCELLATION_ACTION will be set to 'CR' from oe_config_pvt.handle_updates
1119: */
1120: IF G_CANCELLATION_ACTION = 'CR'
1121: AND nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN
1122: l_new_can_quantity := l_old_ord_quantity - p_line_rec.ordered_quantity
1123: + l_old_can_quantity;
1124: END IF;
1125: -- End : 12695580

Line 1194: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN

1190: RETURN p_line_rec.cancelled_quantity;
1191: */
1192:
1193: --Bug# 4009268
1194: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN
1195: oe_debug_pub.add('New ordered_quantity and Old ordered_quantity are equal ');
1196: RETURN nvl(p_line_rec.cancelled_quantity,0);
1197: END IF;
1198:

Line 1296: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

1292:
1293: IF l_debug_level > 0 THEN
1294: OE_DEBUG_PUB.ADD('Entering oe_sales_can_util.perform_cancel_order',5);
1295: OE_DEBUG_PUB.ADD('perform cancel order header id : '||p_header_rec.header_id,5);
1296: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
1297: OE_DEBUG_PUB.add('Reason provided is : '||p_header_rec.change_reason,1);
1298: END IF;
1299:
1300: --g_ord_lvl_can := TRUE; Commented for bug# 2922468

Line 1302: IF (oe_sales_can_util.G_REQUIRE_REASON AND OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N') THEN

1298: END IF;
1299:
1300: --g_ord_lvl_can := TRUE; Commented for bug# 2922468
1301:
1302: IF (oe_sales_can_util.G_REQUIRE_REASON AND OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N') THEN
1303: IF l_debug_level > 0 THEN
1304: oe_debug_pub.add( 'CHANGE REASON IS REQUIRED' ) ;
1305: END IF;
1306: IF p_header_rec.change_reason IS NULL THEN

Line 1337: IF l_line_old_tbl(j).item_type_code = OE_Globals.G_ITEM_SERVICE AND

1333: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( J ) .LINE_ID , 1 ) ;
1334: END IF;
1335:
1336: /* Fix for bug # 2126033 */
1337: IF l_line_old_tbl(j).item_type_code = OE_Globals.G_ITEM_SERVICE AND
1338: l_line_old_tbl(j).service_reference_type_code = 'ORDER' THEN
1339:
1340: begin
1341: select 'Y'

Line 1392: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;

1388: l_x_line_old_tbl(i) := l_line_old_tbl(j);
1389: l_line_tbl(i).db_flag := FND_API.G_TRUE;
1390: --l_line_tbl(i).cancelled_quantity := l_line_tbl(i).ordered_quantity;
1391: l_line_tbl(i).ordered_quantity :=0;
1392: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1393: l_line_tbl(i).change_reason :=p_header_rec.change_reason;
1394: l_line_tbl(i).change_comments :=p_header_Rec.change_comments;
1395: /*l_line_tbl(i).cancelled_flag := 'Y';
1396: l_line_tbl(i).flow_status_code := 'CANCELLED';

Line 1541: --OE_STANDARD_WF.Get_HdrProcessName(OE_GLOBALS.G_WFI_HDR, p_header_rec.header_id,

1537:
1538:
1539:
1540: -- Abort the Wf and close the Header
1541: --OE_STANDARD_WF.Get_HdrProcessName(OE_GLOBALS.G_WFI_HDR, p_header_rec.header_id,
1542: --l_line_process_name);
1543:
1544: -- Moved this post line process
1545: /*IF oe_sales_can_util.g_order_cancel THEN

Line 1546: wf_engine.handleerror(OE_Globals.G_WFI_HDR

1542: --l_line_process_name);
1543:
1544: -- Moved this post line process
1545: /*IF oe_sales_can_util.g_order_cancel THEN
1546: wf_engine.handleerror(OE_Globals.G_WFI_HDR
1547: ,to_char(p_header_rec.header_id)
1548: ,'CLOSE_HEADER',
1549: 'SKIP','CANCEL');
1550: END IF; */

Line 1582: l_control_rec OE_GLOBALS.Control_Rec_Type;

1578: , p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE
1579: , x_return_status OUT NOCOPY VARCHAR2)
1580:
1581: IS
1582: l_control_rec OE_GLOBALS.Control_Rec_Type;
1583: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1584: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1585: l_api_name CONSTANT VARCHAR2(30) := 'PerformLineCancellation';
1586: x_msg_count NUMBER;

Line 1842: p_item_type => OE_GLOBALS.G_WFI_LIN

1838:
1839: ELSE -- fulfillment of all related lines was successful
1840: l_item_key := to_char(l_line_id);
1841: Oe_line_fullfill.Get_Activity_Result(
1842: p_item_type => OE_GLOBALS.G_WFI_LIN
1843: ,p_item_key => l_item_key
1844: ,p_activity_name => 'FULFILL_LINE'
1845: ,x_return_status => l_return_status
1846: ,x_activity_result => l_activity_result

Line 1969: IF l_line_old_tbl(i).item_type_code = OE_Globals.G_ITEM_SERVICE AND

1965: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( I ) .LINE_ID , 1 ) ;
1966: END IF;
1967:
1968: /* Fix for bug # 2126033 */
1969: IF l_line_old_tbl(i).item_type_code = OE_Globals.G_ITEM_SERVICE AND
1970: l_line_old_tbl(i).service_reference_type_code = 'ORDER' THEN
1971:
1972: begin
1973: select 'Y'

Line 2029: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;

2025: l_x_line_old_tbl(J) := l_line_old_tbl(I);
2026: l_line_tbl(J).db_flag := FND_API.G_TRUE;
2027: --l_line_tbl(J).cancelled_quantity := l_line_tbl(J).ordered_quantity;
2028: l_line_tbl(j).ordered_quantity :=0;
2029: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
2030: l_line_tbl(j).change_reason :=p_header_rec.change_reason;
2031: l_line_tbl(j).change_comments :=p_header_Rec.change_comments;
2032: /*
2033: ** Fix bug # 2660104:

Line 2162: IF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_HEADER

2158: OE_DEBUG_PUB.ADD('Entity:' || x_request_rec.param1 );
2159: OE_DEBUG_PUB.ADD('Entity id:' || x_request_rec.entity_id );
2160: end if;
2161:
2162: IF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_HEADER
2163: THEN
2164:
2165: if l_debug_level > 0 then
2166: OE_DEBUG_PUB.ADD('Before select ');

Line 2176: wf_engine.handleerror(OE_Globals.G_WFI_HDR

2172: if l_debug_level > 0 then
2173: OE_DEBUG_PUB.ADD('Before cancelling header flow ');
2174: end if;
2175:
2176: wf_engine.handleerror(OE_Globals.G_WFI_HDR
2177: ,to_char(x_request_rec.entity_id)
2178: ,'CLOSE_HEADER',
2179: 'RETRY','CANCEL');
2180:

Line 2187: ELSIF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_LINE

2183: if l_debug_level > 0 then
2184: OE_DEBUG_PUB.ADD('after cancelling header flow ');
2185: end if;
2186:
2187: ELSIF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_LINE
2188: THEN
2189:
2190: if l_debug_level > 0 then
2191: OE_DEBUG_PUB.ADD('before select Cursoer C1 ');

Line 2204: wf_engine.handleerror(OE_Globals.G_WFI_LIN

2200: Update oe_order_lines_all
2201: set cancelled_flag = 'Y' where
2202: line_id = x_request_rec.entity_id;
2203:
2204: wf_engine.handleerror(OE_Globals.G_WFI_LIN
2205: ,to_char(x_request_rec.entity_id)
2206: ,'CLOSE_LINE',
2207: 'RETRY','CANCEL');
2208: End if; -- Ordered quantity

Line 2259: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2)

2255:
2256: IF l_debug_level > 0 THEN
2257: oe_debug_pub.add( 'entering Cal_Cancelled_Qty2') ;
2258: END IF;
2259: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2)
2260: THEN
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 1 ') ;
2263: END IF;

Line 2286: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN

2282: oe_debug_pub.add( 'OLD CANCELLED QUANTITY2 IS: '||L_OLD_CAN_QUANTITY2 ) ;
2283: END IF;
2284:
2285: IF (l_old_ord_quantity2 > p_line_rec.ordered_quantity2)
2286: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN
2287: l_new_can_quantity2 := l_old_ord_quantity2 - p_line_rec.ordered_quantity2
2288: + l_old_can_quantity2;
2289: ELSE
2290: l_new_can_quantity2 := l_old_can_quantity2;

Line 2368: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN

2364: RETURN p_line_rec.cancelled_quantity;
2365: */
2366:
2367: --Bug# 4009268
2368: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN
2369: oe_debug_pub.add('New ordered_quantity2 and Old ordered_quantity2 are equal ');
2370: RETURN p_line_rec.cancelled_quantity2;
2371: END IF;
2372: