DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_UTIL_PVT dependencies on PO_LOG

Line 339: IF (PO_LOG.d_proc) THEN

335:
336:
337: BEGIN
338: d_position := 0;
339: IF (PO_LOG.d_proc) THEN
340: PO_LOG.proc_begin(d_module);
341: END IF;
342:
343: SELECT FND_API.G_TRUE

Line 340: PO_LOG.proc_begin(d_module);

336:
337: BEGIN
338: d_position := 0;
339: IF (PO_LOG.d_proc) THEN
340: PO_LOG.proc_begin(d_module);
341: END IF;
342:
343: SELECT FND_API.G_TRUE
344: INTO l_crosslinked_option_exist

Line 356: IF (PO_LOG.d_proc) THEN

352: AND child_line.group_line_id =p_req_line_id
353: );
354:
355:
356: IF (PO_LOG.d_proc) THEN
357: PO_LOG.proc_end(d_module, 'l_crosslinked_option_exist', l_crosslinked_option_exist);
358: END IF;
359:
360: RETURN l_crosslinked_option_exist;

Line 357: PO_LOG.proc_end(d_module, 'l_crosslinked_option_exist', l_crosslinked_option_exist);

353: );
354:
355:
356: IF (PO_LOG.d_proc) THEN
357: PO_LOG.proc_end(d_module, 'l_crosslinked_option_exist', l_crosslinked_option_exist);
358: END IF;
359:
360: RETURN l_crosslinked_option_exist;
361:

Line 365: IF (PO_LOG.d_proc) THEN

361:
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: l_crosslinked_option_exist:= FND_API.G_FALSE;
365: IF (PO_LOG.d_proc) THEN
366: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_option_exist', l_crosslinked_option_exist);
367: END IF;
368: RETURN l_crosslinked_option_exist;
369:

Line 366: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_option_exist', l_crosslinked_option_exist);

362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: l_crosslinked_option_exist:= FND_API.G_FALSE;
365: IF (PO_LOG.d_proc) THEN
366: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_option_exist', l_crosslinked_option_exist);
367: END IF;
368: RETURN l_crosslinked_option_exist;
369:
370: END crosslinked_option_exist;

Line 397: IF (PO_LOG.d_proc) THEN

393:
394:
395: BEGIN
396: d_position := 0;
397: IF (PO_LOG.d_proc) THEN
398: PO_LOG.proc_begin(d_module);
399: END IF;
400:
401: Select FND_API.G_TRUE

Line 398: PO_LOG.proc_begin(d_module);

394:
395: BEGIN
396: d_position := 0;
397: IF (PO_LOG.d_proc) THEN
398: PO_LOG.proc_begin(d_module);
399: END IF;
400:
401: Select FND_API.G_TRUE
402: INTO l_is_par_option_line_editable

Line 414: IF (PO_LOG.d_proc) THEN

410: EXISTS (select 1 from po_lines_draft_all plda where po_line_id = prla.clm_base_line_num and plda.draft_id = prla.par_draft_id
411: and plda.change_status = 'UPDATE'))));
412:
413:
414: IF (PO_LOG.d_proc) THEN
415: PO_LOG.proc_end(d_module, 'l_is_par_option_line_editable', l_is_par_option_line_editable);
416: END IF;
417:
418: RETURN l_is_par_option_line_editable;

Line 415: PO_LOG.proc_end(d_module, 'l_is_par_option_line_editable', l_is_par_option_line_editable);

411: and plda.change_status = 'UPDATE'))));
412:
413:
414: IF (PO_LOG.d_proc) THEN
415: PO_LOG.proc_end(d_module, 'l_is_par_option_line_editable', l_is_par_option_line_editable);
416: END IF;
417:
418: RETURN l_is_par_option_line_editable;
419:

Line 423: IF (PO_LOG.d_proc) THEN

419:
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: l_is_par_option_line_editable:= FND_API.G_FALSE;
423: IF (PO_LOG.d_proc) THEN
424: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_is_par_option_line_editable', l_is_par_option_line_editable);
425: END IF;
426: RETURN l_is_par_option_line_editable;
427:

Line 424: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_is_par_option_line_editable', l_is_par_option_line_editable);

420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: l_is_par_option_line_editable:= FND_API.G_FALSE;
423: IF (PO_LOG.d_proc) THEN
424: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_is_par_option_line_editable', l_is_par_option_line_editable);
425: END IF;
426: RETURN l_is_par_option_line_editable;
427:
428: END is_par_option_line_editable;

Line 503: IF (PO_LOG.d_proc) THEN

499: IF(to_NUMBER(c_req_line_id) = To_Number(p_req_line_id)) THEN
500: RETURN l_crosslinked_child;
501: END IF;
502:
503: IF (PO_LOG.d_proc) THEN
504: PO_LOG.proc_begin(d_module);
505: END IF;
506:
507: FOR cur_req_lines IN C_lines(c_req_line_id) LOOP

Line 504: PO_LOG.proc_begin(d_module);

500: RETURN l_crosslinked_child;
501: END IF;
502:
503: IF (PO_LOG.d_proc) THEN
504: PO_LOG.proc_begin(d_module);
505: END IF;
506:
507: FOR cur_req_lines IN C_lines(c_req_line_id) LOOP
508: EXIT WHEN C_lines%NOTFOUND;

Line 525: IF (PO_LOG.d_proc) THEN

521:
522: END LOOP;
523:
524:
525: IF (PO_LOG.d_proc) THEN
526: PO_LOG.proc_end(d_module, 'l_crosslinked_child', l_crosslinked_child);
527: END IF;
528:
529: RETURN l_crosslinked_child;

Line 526: PO_LOG.proc_end(d_module, 'l_crosslinked_child', l_crosslinked_child);

522: END LOOP;
523:
524:
525: IF (PO_LOG.d_proc) THEN
526: PO_LOG.proc_end(d_module, 'l_crosslinked_child', l_crosslinked_child);
527: END IF;
528:
529: RETURN l_crosslinked_child;
530:

Line 535: IF (PO_LOG.d_proc) THEN

531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
533: l_crosslinked_child:= FND_API.G_FALSE;
534:
535: IF (PO_LOG.d_proc) THEN
536: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_child', l_crosslinked_child);
537: END IF;
538:
539: RETURN l_crosslinked_child;

Line 536: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_child', l_crosslinked_child);

532: WHEN NO_DATA_FOUND THEN
533: l_crosslinked_child:= FND_API.G_FALSE;
534:
535: IF (PO_LOG.d_proc) THEN
536: PO_LOG.proc_end(d_module, 'NO_DATA_FOUND: l_crosslinked_child', l_crosslinked_child);
537: END IF;
538:
539: RETURN l_crosslinked_child;
540: