APPS.PO_PRICE_DIFFERENTIALS_PKG dependencies on PO_LOG

Line 284: IF (PO_LOG.d_proc) THEN

280: d_module_name CONSTANT VARCHAR2(100) := 'DEL_LEVEL_SPECIFIC_PRICE_DIFF';
281: d_module_base CONSTANT VARCHAR2(70) := 'po.plsql.PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff';
282: d_pos NUMBER := 0;
283: BEGIN
284: IF (PO_LOG.d_proc) THEN
285: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level); PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);
286: END IF;
287:
288: --Get Price differentials entity type for the given Line

Line 285: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level); PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);

281: d_module_base CONSTANT VARCHAR2(70) := 'po.plsql.PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff';
282: d_pos NUMBER := 0;
283: BEGIN
284: IF (PO_LOG.d_proc) THEN
285: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level); PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);
286: END IF;
287:
288: --Get Price differentials entity type for the given Line
289: l_entity_type := PO_PRICE_DIFFERENTIALS_PVT.get_entity_type(

Line 293: IF(PO_LOG.d_stmt) THEN

289: l_entity_type := PO_PRICE_DIFFERENTIALS_PVT.get_entity_type(
290: p_doc_level => p_doc_level
291: ,p_doc_level_id => p_doc_level_id);
292:
293: IF(PO_LOG.d_stmt) THEN
294: PO_LOG.stmt(d_module_base, d_pos, 'l_entity_type', l_entity_type);
295: END IF;
296:
297: d_pos :=10;

Line 294: PO_LOG.stmt(d_module_base, d_pos, 'l_entity_type', l_entity_type);

290: p_doc_level => p_doc_level
291: ,p_doc_level_id => p_doc_level_id);
292:
293: IF(PO_LOG.d_stmt) THEN
294: PO_LOG.stmt(d_module_base, d_pos, 'l_entity_type', l_entity_type);
295: END IF;
296:
297: d_pos :=10;
298: IF l_entity_type IS NULL THEN

Line 309: IF (PO_LOG.d_proc) THEN

305: ,p_entity_id => p_doc_level_id);
306:
307: d_pos :=30;
308:
309: IF (PO_LOG.d_proc) THEN
310: PO_LOG.proc_end(d_module_base,'No of rows deleted',SQL%ROWCOUNT);
311: PO_LOG.proc_end(d_module_base);
312: END IF;
313:

Line 310: PO_LOG.proc_end(d_module_base,'No of rows deleted',SQL%ROWCOUNT);

306:
307: d_pos :=30;
308:
309: IF (PO_LOG.d_proc) THEN
310: PO_LOG.proc_end(d_module_base,'No of rows deleted',SQL%ROWCOUNT);
311: PO_LOG.proc_end(d_module_base);
312: END IF;
313:
314: EXCEPTION

Line 311: PO_LOG.proc_end(d_module_base);

307: d_pos :=30;
308:
309: IF (PO_LOG.d_proc) THEN
310: PO_LOG.proc_end(d_module_base,'No of rows deleted',SQL%ROWCOUNT);
311: PO_LOG.proc_end(d_module_base);
312: END IF;
313:
314: EXCEPTION
315: WHEN PO_CORE_S.g_early_return_exc THEN

Line 316: IF PO_LOG.d_stmt THEN

312: END IF;
313:
314: EXCEPTION
315: WHEN PO_CORE_S.g_early_return_exc THEN
316: IF PO_LOG.d_stmt THEN
317: PO_LOG.stmt(d_module_name,d_pos,'Early exit from ' || d_module_name);
318: END IF;
319: WHEN OTHERS THEN
320: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_module_name|| ':'|| d_pos);

Line 317: PO_LOG.stmt(d_module_name,d_pos,'Early exit from ' || d_module_name);

313:
314: EXCEPTION
315: WHEN PO_CORE_S.g_early_return_exc THEN
316: IF PO_LOG.d_stmt THEN
317: PO_LOG.stmt(d_module_name,d_pos,'Early exit from ' || d_module_name);
318: END IF;
319: WHEN OTHERS THEN
320: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_module_name|| ':'|| d_pos);
321: IF (PO_LOG.d_exc) THEN

Line 321: IF (PO_LOG.d_exc) THEN

317: PO_LOG.stmt(d_module_name,d_pos,'Early exit from ' || d_module_name);
318: END IF;
319: WHEN OTHERS THEN
320: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_module_name|| ':'|| d_pos);
321: IF (PO_LOG.d_exc) THEN
322: PO_LOG.exc(d_module_base, d_pos, SQLCODE || SQLERRM);
323: END IF;
324: RAISE;
325: END del_level_specific_price_diff;

Line 322: PO_LOG.exc(d_module_base, d_pos, SQLCODE || SQLERRM);

318: END IF;
319: WHEN OTHERS THEN
320: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_module_name|| ':'|| d_pos);
321: IF (PO_LOG.d_exc) THEN
322: PO_LOG.exc(d_module_base, d_pos, SQLCODE || SQLERRM);
323: END IF;
324: RAISE;
325: END del_level_specific_price_diff;
326: --