DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_UTIL

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

1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;

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

1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;

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

1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;

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

1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;

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

1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;

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

1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;
1905:

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

1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;
1905:
1906: -- End step 1. }

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

1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;
1905:
1906: -- End step 1. }
1907:

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

1916:
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1919: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1920: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1921: END IF;
1922:
1923: l_header_req := 'N';
1924: l_header_req_cso := 'N';

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

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

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

2360: l_line_status := 'OPEN';
2361:
2362: -- trigger 3A7 for new line added to booked order
2363: -- and apply hold, unless line was added by buyer
2364: if nvl(OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code, G_TRANSACTION_CSO)
2365: = G_TRANSACTION_CSO THEN
2366: l_apply_3a7_hold := TRUE;
2367: l_line_req_cso := 'Y';
2368: end if;

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

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

Line 2476: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO

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

Line 2480: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO

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