[Home] [Help]
1813: IF l_debug_level > 0 THEN
1814: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO, itemkeys are ' || l_itemkey_sso || ' and ' || l_itemkey_cso ) ;
1815: END IF;
1816:
1817: IF NOT(OE_GENESIS_UTIL.source_aia_enabled(p_header_rec.order_source_id)) THEN -- GENESIS
1818: -- { Start step 1.
1819: -- Call the is_delivery_required api
1820: Is_Delivery_Required( p_customer_id => l_header_rec.sold_to_org_id,
1821: p_transaction_type => 'ONT',
1851: End If;
1852:
1853: If l_is_delivery_required = 'N' And
1854: l_is_delivery_required_cso = 'N' AND
1855: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1856: -- No delivery is required so return, no further processing is required
1857: IF l_debug_level > 0 THEN
1858: oe_debug_pub.add( 'OEXPACKB: NO DELIVERY IS REQUIRED SO RETURN' ) ;
1859: END IF;
1910:
1911: l_header_req := 'N';
1912: l_header_req_cso := 'N';
1913: if l_header_rec.flow_status_code = 'BOOKED' AND
1914: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1915: IF l_debug_level > 0 THEN
1916: oe_debug_pub.add( 'OEXPACKB: L_HEADER_REC.FLOW_STATUS_CODE = BOOKED' ) ;
1917: END IF;
1918: if nvl(p_old_header_rec.flow_status_code, 'BOOKED') <> 'BOOKED' And
1952: l_header_status_cso := 'BOOKED';
1953: end if;
1954:
1955: -- GENESIS --
1956: ELSIF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND
1957: l_header_rec.flow_status_code <> 'BOOKED' AND
1958: l_header_rec.flow_status_code = 'CLOSED' AND
1959: p_old_header_rec.flow_status_code <> l_header_rec.flow_status_code THEN
1960:
2147: -- GENESIS --
2148: end if; -- schedule_ship_date
2149:
2150: -- GENESIS --
2151: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND
2152: l_line_tbl(i).flow_status_code <> 'BOOKED' AND
2153: l_line_tbl(i).flow_status_code in ('FULFILLED','AWAITING_SHIPPING','SHIPPED','CLOSED','SUPPLY_ELIGIBLE') AND
2154: l_line_tbl(i).flow_status_code <> p_old_line_tbl(j).flow_status_code THEN
2155:
2170: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2171: END IF;
2172:
2173: IF l_insert_sync_line = 'Y' and
2174: (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2175: OE_SYNC_ORDER_PVT.INSERT_SYNC_lINE(P_LINE_rec => l_line_tbl(i),
2176: p_change_type => l_change_type,
2177: p_req_id => l_itemkey_sso,
2178: X_RETURN_STATUS => L_RETURN_STATUS);
2224: END IF;
2225: ------------------------------
2226: -- GENESIS --
2227: -- Added this code to handle split case
2228: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2229: IF l_debug_level > 0 THEN
2230: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).item_type_code'||p_line_tbl(i).item_type_code) ;
2231: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).split_from_line_id'||p_line_tbl(i).split_from_line_id) ;
2232: END IF;
2427: l_header_status := 'CLOSED';
2428: End If;
2429:
2430: -- GENESIS --
2431: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2432: l_ack_type := G_TRANSACTION_SEBL;
2433: ELSE
2434: l_ack_type := G_TRANSACTION_SSO;
2435: END IF;
2465: END IF;
2466:
2467: -- GENESIS --
2468: oe_debug_pub.add( 'Genesis: 6.1');
2469: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2470: l_ack_type := G_TRANSACTION_SEBL;
2471: ELSE
2472: l_ack_type := G_TRANSACTION_SSO;
2473: END IF;
2589: l_header_status := 'CLOSED';
2590: End If;
2591:
2592: -- GENESIS --
2593: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2594: l_ack_type := G_TRANSACTION_SEBL;
2595: ELSE
2596: l_ack_type := G_TRANSACTION_SSO;
2597: END IF;
2689: || l_sync_line || ', l_change_type:'
2690: || l_change_type);
2691: END IF;
2692:
2693: IF ( (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND l_sync_header = 'Y') THEN
2694:
2695: IF l_debug_level > 0 THEN
2696: oe_debug_pub.add('TESTING GENESIS 15...'||l_header_rec.order_source_id);
2697: END IF;