DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_UTIL

Line 1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;

1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;

Line 1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;

1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;

Line 1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;

1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;

Line 1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;

1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;

Line 1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;

1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;

Line 1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;

1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;
1893:

Line 1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;

1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;
1893:
1894: -- End step 1. }

Line 1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;

1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;
1893:
1894: -- End step 1. }
1895:

Line 1908: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;

1904:
1905: IF l_debug_level > 0 THEN
1906: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1907: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1908: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1909: END IF;
1910:
1911: l_header_req := 'N';
1912: l_header_req_cso := 'N';

Line 1919: nvl(OE_ORDER_UTIL.g_header_rec.flow_status_code, 'N') = 'BOOKED' Then

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
1919: nvl(OE_ORDER_UTIL.g_header_rec.flow_status_code, 'N') = 'BOOKED' Then
1920: IF l_debug_level > 0 THEN
1921: oe_debug_pub.add( 'OEXPACKB: P_OLD_HEADER_REC.FLOW_STATUS_CODE <> BOOKED' ) ;
1922: END IF;
1923: -- This means that order is Booked right now, and this is the condidate

Line 2248: if nvl(OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code, G_TRANSACTION_CSO)

2244: l_line_status := 'OPEN';
2245:
2246: -- trigger 3A7 for new line added to booked order
2247: -- and apply hold, unless line was added by buyer
2248: if nvl(OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code, G_TRANSACTION_CSO)
2249: = G_TRANSACTION_CSO THEN
2250: l_apply_3a7_hold := TRUE;
2251: l_line_req_cso := 'Y';
2252: end if;

Line 2356: IF (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CHO

2352: -- Order Import will always populate these with the same value for
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

Line 2360: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO

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)
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

Line 2364: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO

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')
2366: THEN
2367: IF l_debug_level > 0 THEN
2368: oe_debug_pub.add('3A7 Buyer change detected, line will not be sent or put on hold');