DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_GENESIS_UTIL

Line 1829: IF NOT(OE_GENESIS_UTIL.source_aia_enabled(p_header_rec.order_source_id)) THEN -- GENESIS

1825: IF l_debug_level > 0 THEN
1826: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO, itemkeys are ' || l_itemkey_sso || ' and ' || l_itemkey_cso ) ;
1827: END IF;
1828:
1829: IF NOT(OE_GENESIS_UTIL.source_aia_enabled(p_header_rec.order_source_id)) THEN -- GENESIS
1830: -- { Start step 1.
1831: -- Call the is_delivery_required api
1832: Is_Delivery_Required( p_customer_id => l_header_rec.sold_to_org_id,
1833: p_transaction_type => 'ONT',

Line 1867: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS

1863: End If;
1864:
1865: If l_is_delivery_required = 'N' And
1866: l_is_delivery_required_cso = 'N' AND
1867: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1868: -- No delivery is required so return, no further processing is required
1869: IF l_debug_level > 0 THEN
1870: oe_debug_pub.add( 'OEXPACKB: NO DELIVERY IS REQUIRED SO RETURN' ) ;
1871: END IF;

Line 1926: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS

1922:
1923: l_header_req := 'N';
1924: l_header_req_cso := 'N';
1925: if l_header_rec.flow_status_code = 'BOOKED' AND
1926: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1927: IF l_debug_level > 0 THEN
1928: oe_debug_pub.add( 'OEXPACKB: L_HEADER_REC.FLOW_STATUS_CODE = BOOKED' ) ;
1929: END IF;
1930: if nvl(p_old_header_rec.flow_status_code, 'BOOKED') <> 'BOOKED' And

Line 1971: ELSIF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND

1967: -- GENESIS --
1968: -- Commented out as a part of O2C 2.5 (8516700:R12.ONT.B).
1969: -- Replacement code made available immediately below.
1970: /*
1971: ELSIF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND
1972: l_header_rec.flow_status_code <> 'BOOKED' AND
1973: l_header_rec.flow_status_code = 'CLOSED' AND
1974: p_old_header_rec.flow_status_code <> l_header_rec.flow_status_code THEN
1975: */

Line 1978: (Oe_Genesis_Util.Source_Aia_Enabled(l_header_rec.order_source_id))

1974: p_old_header_rec.flow_status_code <> l_header_rec.flow_status_code THEN
1975: */
1976: ELSIF
1977: (
1978: (Oe_Genesis_Util.Source_Aia_Enabled(l_header_rec.order_source_id))
1979: AND
1980: (p_old_header_rec.flow_status_code <> l_header_rec.flow_status_code)
1981: AND
1982: (Oe_Genesis_Util.Status_Needs_Sync(l_header_rec.flow_status_code))

Line 1982: (Oe_Genesis_Util.Status_Needs_Sync(l_header_rec.flow_status_code))

1978: (Oe_Genesis_Util.Source_Aia_Enabled(l_header_rec.order_source_id))
1979: AND
1980: (p_old_header_rec.flow_status_code <> l_header_rec.flow_status_code)
1981: AND
1982: (Oe_Genesis_Util.Status_Needs_Sync(l_header_rec.flow_status_code))
1983: )
1984: THEN
1985:
1986: l_header_req := 'Y';

Line 2217: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND

2213: -- O2C 25:shipping_method_code (End changes for Bug 8936919 gabhatia)
2214:
2215:
2216: -- GENESIS --
2217: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND
2218: -- O2C25: 8516700: Start: Commented special processing for BOOKED,
2219: -- and remove hardcoding on flow status codes.
2220: -- l_line_tbl(i).flow_status_code <> 'BOOKED' AND
2221: -- l_line_tbl(i).flow_status_code in ('FULFILLED','AWAITING_SHIPPING','SHIPPED','CLOSED','SUPPLY_ELIGIBLE') AND

Line 2222: Oe_Genesis_Util.Status_Needs_Sync(l_line_tbl(i).flow_status_code) AND

2218: -- O2C25: 8516700: Start: Commented special processing for BOOKED,
2219: -- and remove hardcoding on flow status codes.
2220: -- l_line_tbl(i).flow_status_code <> 'BOOKED' AND
2221: -- l_line_tbl(i).flow_status_code in ('FULFILLED','AWAITING_SHIPPING','SHIPPED','CLOSED','SUPPLY_ELIGIBLE') AND
2222: Oe_Genesis_Util.Status_Needs_Sync(l_line_tbl(i).flow_status_code) AND
2223: -- O2C25: 8516700: End
2224: l_line_tbl(i).flow_status_code <> p_old_line_tbl(j).flow_status_code THEN
2225:
2226: l_change_fsc := 'Y';

Line 2244: (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN

2240: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2241: END IF;
2242:
2243: IF l_insert_sync_line = 'Y' and
2244: (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2245: -- Bug# 12879272
2246: -- Checking if the Acknowledgement is already inserted
2247: -- When a line is created through Process Order API, and Booking and Scheduling of line
2248: -- happens in the same call, then Acknowledgement is inserted TWICE, to avoid that

Line 2320: and NOT OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id) ) -- bug 11078158

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:
2323: IF l_debug_level > 0 THEN
2324: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;

Line 2332: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN

2328: END IF;
2329: ------------------------------
2330: -- GENESIS --
2331: -- Added this code to handle split case
2332: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2333: IF l_debug_level > 0 THEN
2334: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).item_type_code'||p_line_tbl(i).item_type_code) ;
2335: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).split_from_line_id'||p_line_tbl(i).split_from_line_id) ;
2336: END IF;

Line 2547: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN

2543: l_header_status := 'CLOSED';
2544: End If;
2545:
2546: -- GENESIS --
2547: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2548: l_ack_type := G_TRANSACTION_SEBL;
2549: ELSE
2550: l_ack_type := G_TRANSACTION_SSO;
2551: END IF;

Line 2585: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN

2581: END IF;
2582:
2583: -- GENESIS --
2584: oe_debug_pub.add( 'Genesis: 6.1');
2585: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2586: l_ack_type := G_TRANSACTION_SEBL;
2587: ELSE
2588: l_ack_type := G_TRANSACTION_SSO;
2589: END IF;

Line 2709: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN

2705: l_header_status := 'CLOSED';
2706: End If;
2707:
2708: -- GENESIS --
2709: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2710: l_ack_type := G_TRANSACTION_SEBL;
2711: ELSE
2712: l_ack_type := G_TRANSACTION_SSO;
2713: END IF;

Line 2809: IF ( (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND l_sync_header = 'Y') THEN

2805: || l_sync_line || ', l_change_type:'
2806: || l_change_type);
2807: END IF;
2808:
2809: IF ( (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND l_sync_header = 'Y') THEN
2810:
2811: IF l_debug_level > 0 THEN
2812: oe_debug_pub.add('TESTING GENESIS 15...'||l_header_rec.order_source_id);
2813: END IF;