DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on FND_PROFILE

Line 2746: AND NVL(FND_PROFILE.VALUE('ONT_3A7_RESPONSE_REQUIRED'), 'N') = 'Y'

2742: ,p_source_document_id => l_line_rec.source_document_id
2743: ,p_source_document_line_id => l_line_rec.source_document_line_id );
2744:
2745: IF OE_Code_Control.code_release_level >= '110510'
2746: AND NVL(FND_PROFILE.VALUE('ONT_3A7_RESPONSE_REQUIRED'), 'N') = 'Y'
2747: -- Added this check because, holds will be applied only when this profile is set to 'YES'.
2748: AND l_line_rec.order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
2749: AND nvl(l_line_rec.xml_transaction_type_code, FND_API.G_MISS_CHAR)
2750: IN (OE_Acknowledgment_Pub.G_TRANSACTION_CHO,OE_Acknowledgment_Pub.G_TRANSACTION_CPO) THEN -- 3A8/3A9

Line 5529: fnd_profile.get('ONT_NEW_EDI_ACK_FWK', l_edi_ack_pfile);

5525: END IF;
5526: set_recursion_mode(p_Entity_Code => 8,
5527: p_In_out => 1);
5528:
5529: fnd_profile.get('ONT_NEW_EDI_ACK_FWK', l_edi_ack_pfile);
5530: l_edi_ack_pfile := nvl(l_edi_ack_pfile, 'NO');
5531:
5532: -- Initialize message list.
5533:

Line 6068: If NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' THEN

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
6069: i := OE_ORDER_UTIL.g_line_tbl.first;
6070: while i is not null LOOP
6071: if OE_ORDER_UTIL.g_line_tbl(i).line_id = OE_ORDER_UTIL.g_old_line_tbl(i).line_id then
6072: j := i;

Line 6129: NVL(Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' OR

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:
6133: OE_Acknowledgment_Pub.Process_SSO

Line 6198: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;

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:
6201: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
6202: oe_order_cache.g_header_rec.booked_flag = 'Y' AND

Line 6201: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND

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

Line 6406: fnd_profile.get('ONT_NEW_EDI_ACK_FWK', l_edi_ack_pfile);

6402: END IF;
6403:
6404: -- Initialize x_return_status
6405: x_return_status := FND_API.G_RET_STS_SUCCESS;
6406: fnd_profile.get('ONT_NEW_EDI_ACK_FWK', l_edi_ack_pfile);
6407: l_edi_ack_pfile := nvl(l_edi_ack_pfile, 'NO');
6408:
6409: -- Init local table variables for old tables as these are only
6410: -- IN params.

Line 8511: fnd_profile.get('ONT_NEW_EDI_ACK_FWK', l_edi_ack_pfile);

8507: set_recursion_mode(p_Entity_Code => 1,
8508: p_In_out => 1);
8509:
8510: x_return_status := FND_API.G_RET_STS_SUCCESS;
8511: fnd_profile.get('ONT_NEW_EDI_ACK_FWK', l_edi_ack_pfile);
8512: l_edi_ack_pfile := nvl(l_edi_ack_pfile, 'NO');
8513:
8514: IF OE_GLOBALS.G_RECURSION_MODE <> 'Y' THEN
8515: