DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on FND_PROFILE

Line 212: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then

208: where batch_id = p_batch_id
209: and nvl(error_flag,'N') = 'N');
210:
211: --ER 9060917
212: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
213:
214: DELETE FROM oe_price_adjs_interface
215: WHERE(order_source_id, orig_sys_document_ref) IN
216: (SELECT order_source_id,

Line 700: FND_PROFILE.PUT('ONT_DEBUG_LEVEL',p_debug_level);

696:
697: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug Level: '||nvl(p_debug_level,0));
698:
699: IF nvl(p_debug_level, 0) > 0 THEN
700: FND_PROFILE.PUT('ONT_DEBUG_LEVEL',p_debug_level);
701: --moved this stmt in if loop for bug 3747791
702: l_filename := oe_debug_pub.set_debug_mode ('CONC');
703: END IF;
704:

Line 711: --Bug# 12333065 FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);

707: -----------------------------------------------------------
708: -- Get Concurrent Request Id
709: -----------------------------------------------------------
710:
711: --Bug# 12333065 FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
712: l_request_id := FND_GLOBAL.CONC_REQUEST_ID; --Bug# 12333065
713:
714: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
715:

Line 1471: IF NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then

1467: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Failed: ' ||
1468: to_char(G_ERROR_ORDERS));
1469:
1470: -- ER 9060917
1471: IF NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
1472: fnd_file.put_line(FND_FILE.OUTPUT,'');
1473: fnd_file.put_line(FND_FILE.OUTPUT,'Following orders are processed partially as profile OM: Allow HVOP to drop invalid lines is set');
1474:
1475: OPEN l_partial_orders;