466: l_validate_gl_period VARCHAR2(1) := nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),
467: 'Y');
468: Begin
469:
470: IF PO_LOG.d_proc THEN
471: PO_LOG.proc_begin(d_mod, 'l_sob_id', l_sob_id);
472: PO_LOG.proc_begin(d_mod, 'x_gl_date', x_gl_date);
473: PO_LOG.proc_begin(d_mod, 'x_gl_period', x_gl_period);
474: END IF;
467: 'Y');
468: Begin
469:
470: IF PO_LOG.d_proc THEN
471: PO_LOG.proc_begin(d_mod, 'l_sob_id', l_sob_id);
472: PO_LOG.proc_begin(d_mod, 'x_gl_date', x_gl_date);
473: PO_LOG.proc_begin(d_mod, 'x_gl_period', x_gl_period);
474: END IF;
475:
468: Begin
469:
470: IF PO_LOG.d_proc THEN
471: PO_LOG.proc_begin(d_mod, 'l_sob_id', l_sob_id);
472: PO_LOG.proc_begin(d_mod, 'x_gl_date', x_gl_date);
473: PO_LOG.proc_begin(d_mod, 'x_gl_period', x_gl_period);
474: END IF;
475:
476: begin
469:
470: IF PO_LOG.d_proc THEN
471: PO_LOG.proc_begin(d_mod, 'l_sob_id', l_sob_id);
472: PO_LOG.proc_begin(d_mod, 'x_gl_date', x_gl_date);
473: PO_LOG.proc_begin(d_mod, 'x_gl_period', x_gl_period);
474: END IF;
475:
476: begin
477: -- 1st Check: Find out whether passed GL date (distribution level) belongs
524: and rownum = 1;
525:
526: x_gl_date := sysdate;
527:
528: IF po_log.d_proc THEN
529: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
530: PO_LOG.proc_begin(l_log_head, 'x_gl_period', x_gl_period);
531: END IF;
532:
525:
526: x_gl_date := sysdate;
527:
528: IF po_log.d_proc THEN
529: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
530: PO_LOG.proc_begin(l_log_head, 'x_gl_period', x_gl_period);
531: END IF;
532:
533: exception
526: x_gl_date := sysdate;
527:
528: IF po_log.d_proc THEN
529: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
530: PO_LOG.proc_begin(l_log_head, 'x_gl_period', x_gl_period);
531: END IF;
532:
533: exception
534: when no_data_found then
567: where ROWNUM = 1;
568: -- Call custom hook to get the Ct's preferred GL Date.
569: PO_CUSTOM_FUNDS_PKG.gl_date(x_gl_date, x_gl_period);
570:
571: IF po_log.d_proc THEN
572: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
573: PO_LOG.proc_begin(l_log_head, 'x_gl_period', x_gl_period);
574: END IF;
575:
568: -- Call custom hook to get the Ct's preferred GL Date.
569: PO_CUSTOM_FUNDS_PKG.gl_date(x_gl_date, x_gl_period);
570:
571: IF po_log.d_proc THEN
572: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
573: PO_LOG.proc_begin(l_log_head, 'x_gl_period', x_gl_period);
574: END IF;
575:
576: -- Call custom hook to get the Ct's preferred GL Date.
569: PO_CUSTOM_FUNDS_PKG.gl_date(x_gl_date, x_gl_period);
570:
571: IF po_log.d_proc THEN
572: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
573: PO_LOG.proc_begin(l_log_head, 'x_gl_period', x_gl_period);
574: END IF;
575:
576: -- Call custom hook to get the Ct's preferred GL Date.
577: PO_CUSTOM_FUNDS_PKG.gl_date(x_gl_date, x_gl_period);
615: where ROWNUM = 1;
616: -- Call custom hook to get the Ct's preferred GL Date.
617: PO_CUSTOM_FUNDS_PKG.gl_date(x_gl_date, x_gl_period);
618:
619: IF po_log.d_proc THEN
620: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
621: PO_LOG.proc_begin(l_log_head,
622: 'x_gl_period',
623: x_gl_period);
616: -- Call custom hook to get the Ct's preferred GL Date.
617: PO_CUSTOM_FUNDS_PKG.gl_date(x_gl_date, x_gl_period);
618:
619: IF po_log.d_proc THEN
620: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
621: PO_LOG.proc_begin(l_log_head,
622: 'x_gl_period',
623: x_gl_period);
624: END IF;
617: PO_CUSTOM_FUNDS_PKG.gl_date(x_gl_date, x_gl_period);
618:
619: IF po_log.d_proc THEN
620: PO_LOG.proc_begin(l_log_head, 'x_gl_date', x_gl_date);
621: PO_LOG.proc_begin(l_log_head,
622: 'x_gl_period',
623: x_gl_period);
624: END IF;
625: exception