eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_PVT dependencies on OE_ORDER_CACHE

Line 2558: OR oe_order_cache.g_header_rec.source_document_type_id = 10 THEN

2554: --Added for bug 4937633 source type for Internal orders will be Internal
2555: IF p_x_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
2556:
2557: IF p_x_line_tbl(I).source_document_type_id = 10
2558: OR oe_order_cache.g_header_rec.source_document_type_id = 10 THEN
2559: p_x_line_tbl(I).source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
2560: END IF;
2561: END IF;
2562: --Added for bug 4937633 end

Line 5738: AND oe_order_cache.g_header_rec.booked_flag = 'Y' THEN

5734: OE_ORDER_WF_UTIL.START_ALL_FLOWS;
5735: END IF;
5736:
5737: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508'
5738: AND oe_order_cache.g_header_rec.booked_flag = 'Y' THEN
5739: -- If notify, then call service and acknowledgments notify APIs
5740:
5741: IF p_notify THEN
5742: IF l_debug_level > 0 THEN

Line 5857: oe_debug_pub.add( 'JPN: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;

5853:
5854: ELSE /*post pack H*/
5855: IF l_debug_level > 0 THEN
5856: oe_debug_pub.add( 'JPN: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
5857: oe_debug_pub.add( 'JPN: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;

Line 6008: Oe_Order_Cache.Load_Order_Header(l_header_id);

6004: IF l_debug_level > 0 THEN
6005: oe_debug_pub.add('Just before calling Load_Order_Header');
6006: END IF;
6007:
6008: Oe_Order_Cache.Load_Order_Header(l_header_id);
6009: END IF;
6010:
6011: IF l_debug_level > 0 THEN
6012: oe_debug_pub.add('Out of Load_Order_Header in PRN');

Line 6017: OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y') THEN

6013: END IF;
6014: /* end of bug 2781468*/
6015:
6016: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND
6017: OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y') THEN
6018:
6019: IF l_debug_level > 0 THEN
6020: oe_debug_pub.add( 'POST PACK H. CALLING NOTIFY_OC API' , 1 ) ;
6021: END IF;

Line 6064: oe_debug_pub.add( 'PACKS' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG , 1 ) ;

6060:
6061: IF l_debug_level > 0 THEN
6062: oe_debug_pub.add( 'PROCESSING ACKS' , 1 ) ;
6063: oe_debug_pub.add( 'PACKS ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION , 1 ) ;
6064: oe_debug_pub.add( 'PACKS' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
6065: END IF;
6066:
6067: --SUN OIP ER
6068: If NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' THEN

Line 6108: OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y' AND p_process_ack) THEN

6104: end loop;
6105: end if;
6106: --End of SUN OIP ER
6107: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND
6108: OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y' AND p_process_ack) THEN
6109:
6110: IF l_debug_level > 0 THEN
6111: oe_debug_pub.add( 'POST PACK H.CALLING ACKS API' , 1 ) ;
6112: END IF;

Line 6124: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID , 1 ) ;

6120:
6121: -- { Start of If order_source_id = 20
6122: -- The below condition will only executed for the the XML Xactions
6123: IF l_debug_level > 0 THEN
6124: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID , 1 ) ;
6125: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.SOLD_TO_ORG_ID , 1 ) ;
6126: END IF;
6127:
6128: If OE_ORDER_CACHE.g_header_rec.order_source_id in (20) OR

Line 6125: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.SOLD_TO_ORG_ID , 1 ) ;

6121: -- { Start of If order_source_id = 20
6122: -- The below condition will only executed for the the XML Xactions
6123: IF l_debug_level > 0 THEN
6124: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID , 1 ) ;
6125: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.SOLD_TO_ORG_ID , 1 ) ;
6126: END IF;
6127:
6128: If OE_ORDER_CACHE.g_header_rec.order_source_id in (20) OR
6129: NVL(Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' OR

Line 6128: If OE_ORDER_CACHE.g_header_rec.order_source_id in (20) OR

6124: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.ORDER_SOURCE_ID , 1 ) ;
6125: oe_debug_pub.add( 'PACKS ' || OE_ORDER_CACHE.G_HEADER_REC.SOLD_TO_ORG_ID , 1 ) ;
6126: END IF;
6127:
6128: If OE_ORDER_CACHE.g_header_rec.order_source_id in (20) OR
6129: NVL(Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' OR
6130: (OE_GENESIS_UTIL.source_aia_enabled(OE_ORDER_CACHE.g_header_rec.order_source_id)) THEN -- GENESIS
6131:
6132:

Line 6130: (OE_GENESIS_UTIL.source_aia_enabled(OE_ORDER_CACHE.g_header_rec.order_source_id)) THEN -- GENESIS

6126: END IF;
6127:
6128: If OE_ORDER_CACHE.g_header_rec.order_source_id in (20) OR
6129: NVL(Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' OR
6130: (OE_GENESIS_UTIL.source_aia_enabled(OE_ORDER_CACHE.g_header_rec.order_source_id)) THEN -- GENESIS
6131:
6132:
6133: OE_Acknowledgment_Pub.Process_SSO
6134: (p_api_version_number => 1

Line 6136: ,p_header_rec => OE_ORDER_CACHE.g_header_rec

6132:
6133: OE_Acknowledgment_Pub.Process_SSO
6134: (p_api_version_number => 1
6135: ,p_init_msg_list => FND_API.G_FALSE
6136: ,p_header_rec => OE_ORDER_CACHE.g_header_rec
6137: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6138: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6139: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6140:

Line 6146: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) And

6142: );
6143:
6144: -- The below condition to leave the existing flow to work as it is
6145: Elsif Oe_Code_Control.Code_Release_Level >= '110510' And
6146: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) And
6147: l_edi_ack_pfile = 'YES' Then
6148: OE_Acknowledgment_Pvt.Process_Acknowledgment
6149: (p_header_rec => OE_ORDER_UTIL.g_header_rec,
6150: p_line_tbl => OE_ORDER_UTIL.g_line_tbl,

Line 6155: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) Then

6151: p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec,
6152: p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl,
6153: x_return_status => l_return_status);
6154: Elsif l_edi_ack_pfile = 'NO' And
6155: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) Then
6156: OE_Acknowledgment_Pvt.Process_Acknowledgment
6157: (p_api_version_number => 1
6158: ,p_init_msg_list => FND_API.G_FALSE
6159: ,p_header_rec => OE_ORDER_UTIL.g_header_rec

Line 6196: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;

6192:
6193: -- DBI project changes start
6194: IF l_debug_level > 0 THEN
6195: oe_debug_pub.add( 'CALLING OE_DBI_UTIL' , 1 ) ;
6196: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
6197: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
6198: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
6199: END IF;
6200:

Line 6202: oe_order_cache.g_header_rec.booked_flag = 'Y' AND

6198: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
6199: END IF;
6200:
6201: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
6202: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
6203: OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N'
6204: -- AND p_header_rec.header_id IS NOT NULL AND
6205: --p_header_rec.header_id <> FND_API.G_MISS_NUM
6206: THEN

Line 6223: (OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y' OR

6219:
6220: /* Now clear the global pl/sql tables */
6221: /* Also clear for >= 11i10 for versioning */
6222: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND
6223: (OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y' OR
6224: OE_CODE_CONTROL.Code_Release_Level >= '110510' )) THEN
6225: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
6226: END IF;
6227:

Line 8105: AND oe_order_cache.g_header_rec.booked_flag = 'Y'

8101: oe_debug_pub.add( 'CS BEFORE CALLING NOTIFY_OC API' , 1 ) ;
8102: END IF;
8103: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
8104: p_control_rec.write_to_db = TRUE
8105: AND oe_order_cache.g_header_rec.booked_flag = 'Y'
8106: THEN
8107: IF l_debug_level > 0 THEN
8108: oe_debug_pub.add( 'CS CALLING NOTIFY_OC API' , 1 ) ;
8109: END IF;

Line 10352: AND oe_order_cache.g_header_rec.booked_flag = 'Y'

10348: END IF;
10349:
10350: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
10351: p_control_rec.write_to_db = TRUE
10352: AND oe_order_cache.g_header_rec.booked_flag = 'Y'
10353: THEN
10354: IF l_debug_level > 0 THEN
10355: oe_debug_pub.add( 'CS CALLING NOTIFY_OC API' , 1 ) ;
10356: END IF;