DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_GLOBALS

Line 602: l_control_rec OE_GLOBALS.Control_Rec_Type;

598: )
599: IS
600: l_api_version_number CONSTANT NUMBER := 1.0;
601: l_api_name CONSTANT VARCHAR2(30):= 'Process_Acknowledgment';
602: l_control_rec OE_GLOBALS.Control_Rec_Type;
603: l_return_status VARCHAR2(1);
604: l_msg_count NUMBER;
605: l_msg_data VARCHAR2(2000);
606: --

Line 1370: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)

1366: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1367: END IF;
1368:
1369: Begin
1370: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)
1371: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)
1372: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1373: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1374: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then

Line 1952: ELSIF nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) = G_TRANSACTION_POI THEN

1948: IF l_is_delivery_required_cso = 'Y' THEN
1949: IF nvl(FND_PROFILE.VALUE('ONT_XML_ACCEPT_STATE'), 'ENTERED') = 'ENTERED' THEN
1950: l_header_req_cso := 'N'; -- i.e. 3a7 not sent on Booking if accept state is Entered,
1951: -- unless of course there are line_changes (handled later)
1952: ELSIF nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) = G_TRANSACTION_POI THEN
1953: l_header_req_cso := 'N'; -- i.e. don't send 3a7 if order is booked by buyer
1954: ELSE
1955: l_header_req_cso := 'Y';
1956: END IF;

Line 2059: -- if l_line_tbl(i).operation = Oe_Globals.G_OPR_UPDATE then

2055:
2056: -- { Start for the comparision when the operation on the Line table
2057: -- is UPDATE
2058: -- Bug 13008311 : Start
2059: -- if l_line_tbl(i).operation = Oe_Globals.G_OPR_UPDATE then
2060: l_lin_chk := 'N';
2061: IF j <> 0 THEN
2062: is_line_exists(p_line_tbl(j).line_id, l_lin_chk);
2063: END IF;

Line 2067: OR (l_line_tbl(i).operation = Oe_Globals.G_OPR_UPDATE)

2063: END IF;
2064:
2065: IF ( ( (l_line_tbl(i).operation IS NULL OR l_line_tbl(i).operation = FND_API.G_MISS_CHAR)
2066: AND l_lin_chk = 'Y')
2067: OR (l_line_tbl(i).operation = Oe_Globals.G_OPR_UPDATE)
2068: )
2069: THEN
2070: -- Bug 13008311 : End
2071:

Line 2137: if not oe_globals.equal (l_line_tbl(i).order_quantity_uom,

2133: END IF;
2134: -- GENESIS --
2135: end if; -- ordered_quantity
2136:
2137: if not oe_globals.equal (l_line_tbl(i).order_quantity_uom,
2138: p_old_line_tbl(j).order_quantity_uom) then
2139: -- set flag to indicate that uom has changed
2140: IF l_debug_level > 0 THEN
2141: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDER_QUANTITY_UOM' ) ;

Line 2317: ( p_old_line_tbl(j).operation = Oe_Globals.G_OPR_INSERT or

2313: END IF;
2314:
2315:
2316: if j <> 0 AND -- Bug 10407362: Same Check for 'j' as mentioned above.
2317: ( p_old_line_tbl(j).operation = Oe_Globals.G_OPR_INSERT or
2318: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE or
2319: (l_line_exists ='N' and p_line_tbl(j).booked_flag ='Y' -- Added Condition for bug 9685021
2320: and NOT OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id) ) -- bug 11078158
2321: ) then

Line 2318: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE or

2314:
2315:
2316: if j <> 0 AND -- Bug 10407362: Same Check for 'j' as mentioned above.
2317: ( p_old_line_tbl(j).operation = Oe_Globals.G_OPR_INSERT or
2318: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE or
2319: (l_line_exists ='N' and p_line_tbl(j).booked_flag ='Y' -- Added Condition for bug 9685021
2320: and NOT OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id) ) -- bug 11078158
2321: ) then
2322:

Line 2473: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)

2469: -- header and line
2470: -- an exception is made for header-level cancellations
2471: IF l_is_delivery_required_cso = 'Y' THEN
2472: IF (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CHO
2473: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2474: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2475:
2476: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2477: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)

Line 2477: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)

2473: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2474: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2475:
2476: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2477: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2478: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2479:
2480: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2481: AND nvl(l_header_rec.cancelled_flag,'N') = 'Y')

Line 2505: AND nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) <> G_TRANSACTION_POI

2501: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
2502: IF l_is_delivery_required_cso = 'Y'
2503: AND l_cso_response_profile = 'Y'
2504: AND NOT l_3a7_buyer_line
2505: AND nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) <> G_TRANSACTION_POI
2506: AND l_line_tbl(i).order_source_id = G_XML_ORDER_SOURCE_ID
2507: AND l_line_tbl(i).ordered_quantity <> 0
2508: AND nvl(l_line_tbl(i).booked_flag, 'N') = 'Y'
2509: AND nvl(l_line_tbl(i).xml_transaction_type_code, G_TRANSACTION_CSO) = G_TRANSACTION_CSO

Line 3151: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN

3147: x_return_status := FND_API.G_RET_STS_SUCCESS;
3148: return;
3149: END IF;
3150: ELSIF l_integ_profile = 'EDIXML' THEN
3151: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN
3152: IF l_debug_level > 0 THEN
3153: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3154: END IF;
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;