APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_GLOBALS

Line 597: l_control_rec OE_GLOBALS.Control_Rec_Type;

593: )
594: IS
595: l_api_version_number CONSTANT NUMBER := 1.0;
596: l_api_name CONSTANT VARCHAR2(30):= 'Process_Acknowledgment';
597: l_control_rec OE_GLOBALS.Control_Rec_Type;
598: l_return_status VARCHAR2(1);
599: l_msg_count NUMBER;
600: l_msg_data VARCHAR2(2000);
601: --

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

1361: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1362: END IF;
1363:
1364: Begin
1365: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)
1366: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)
1367: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1368: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1369: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then

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

1936: IF l_is_delivery_required_cso = 'Y' THEN
1937: IF nvl(FND_PROFILE.VALUE('ONT_XML_ACCEPT_STATE'), 'ENTERED') = 'ENTERED' THEN
1938: l_header_req_cso := 'N'; -- i.e. 3a7 not sent on Booking if accept state is Entered,
1939: -- unless of course there are line_changes (handled later)
1940: ELSIF nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) = G_TRANSACTION_POI THEN
1941: l_header_req_cso := 'N'; -- i.e. don't send 3a7 if order is booked by buyer
1942: ELSE
1943: l_header_req_cso := 'Y';
1944: END IF;

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

2028: end if;
2029:
2030: -- { Start for the comparision when the operation on the Line table
2031: -- is UPDATE
2032: if l_line_tbl(i).operation = Oe_Globals.G_OPR_UPDATE then
2033: IF l_debug_level > 0 THEN
2034: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS UPDATE' ) ;
2035: END IF;
2036:

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

2094: END IF;
2095: -- GENESIS --
2096: end if; -- ordered_quantity
2097:
2098: if not oe_globals.equal (l_line_tbl(i).order_quantity_uom,
2099: p_old_line_tbl(j).order_quantity_uom) then
2100: -- set flag to indicate that uom has changed
2101: IF l_debug_level > 0 THEN
2102: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDER_QUANTITY_UOM' ) ;

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

2213:
2214: -- { Start of a., b., c. and d.
2215:
2216: -- changed for bug 3424468 to check operation code on old line instead of new line
2217: if p_old_line_tbl(j).operation = Oe_Globals.G_OPR_INSERT or
2218: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE then
2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2221: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;

Line 2218: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE then

2214: -- { Start of a., b., c. and d.
2215:
2216: -- changed for bug 3424468 to check operation code on old line instead of new line
2217: if p_old_line_tbl(j).operation = Oe_Globals.G_OPR_INSERT or
2218: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE then
2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2221: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2222: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;

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

2353: -- header and line
2354: -- an exception is made for header-level cancellations
2355: IF l_is_delivery_required_cso = 'Y' THEN
2356: IF (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CHO
2357: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2358: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2359:
2360: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2361: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)

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

2357: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2358: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2359:
2360: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2361: AND OE_GLOBALS.Equal (l_header_rec.request_id, l_line_tbl(i).request_id)
2362: AND nvl(l_header_rec.request_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) OR
2363:
2364: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2365: AND nvl(l_header_rec.cancelled_flag,'N') = 'Y')

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

2385: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
2386: IF l_is_delivery_required_cso = 'Y'
2387: AND l_cso_response_profile = 'Y'
2388: AND NOT l_3a7_buyer_line
2389: AND nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) <> G_TRANSACTION_POI
2390: AND l_line_tbl(i).order_source_id = G_XML_ORDER_SOURCE_ID
2391: AND l_line_tbl(i).ordered_quantity <> 0
2392: AND nvl(l_line_tbl(i).booked_flag, 'N') = 'Y'
2393: AND nvl(l_line_tbl(i).xml_transaction_type_code, G_TRANSACTION_CSO) = G_TRANSACTION_CSO

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

3031: x_return_status := FND_API.G_RET_STS_SUCCESS;
3032: return;
3033: END IF;
3034: ELSIF l_integ_profile = 'EDIXML' THEN
3035: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN
3036: IF l_debug_level > 0 THEN
3037: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3038: END IF;
3039: x_return_status := FND_API.G_RET_STS_SUCCESS;