eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HEADERS_DRAFT_PKG dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_HEADERS_DRAFT_PKG');

1: PACKAGE BODY po_headers_draft_pkg AS
2: /* $Header: PO_HEADERS_DRAFT_PKG.plb 120.21.12020000.3 2013/02/10 22:23:01 vegajula ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_HEADERS_DRAFT_PKG');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: delete_rows

Line 44: IF (PO_LOG.d_proc) THEN

40: l_header_id NUMBER;
41:
42: BEGIN
43: d_position := 0;
44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: --Bug 13938456 - Cond Mod Attachments

Line 45: PO_LOG.proc_begin(d_module);

41:
42: BEGIN
43: d_position := 0;
44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: --Bug 13938456 - Cond Mod Attachments
49: --Fetch header id if it is null

Line 132: IF (PO_LOG.d_proc) THEN

128: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
129:
130: BEGIN
131: d_position := 0;
132: IF (PO_LOG.d_proc) THEN
133: PO_LOG.proc_begin(d_module);
134: END IF;
135:
136: x_record_already_exist_tbl :=

Line 133: PO_LOG.proc_begin(d_module);

129:
130: BEGIN
131: d_position := 0;
132: IF (PO_LOG.d_proc) THEN
133: PO_LOG.proc_begin(d_module);
134: END IF;
135:
136: x_record_already_exist_tbl :=
137: PO_HEADERS_DRAFT_PVT.draft_changes_exist

Line 168: IF (PO_LOG.d_stmt) THEN

164: END IF;
165: END LOOP;
166:
167: d_position := 10;
168: IF (PO_LOG.d_stmt) THEN
169: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
170: END IF;
171:
172: FORALL i IN 1..p_po_header_id_tbl.COUNT

Line 169: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');

165: END LOOP;
166:
167: d_position := 10;
168: IF (PO_LOG.d_stmt) THEN
169: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
170: END IF;
171:
172: FORALL i IN 1..p_po_header_id_tbl.COUNT
173: INSERT INTO po_headers_draft_all

Line 574: IF (PO_LOG.d_stmt) THEN

570: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
571: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
572:
573: d_position := 20;
574: IF (PO_LOG.d_stmt) THEN
575: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
576: END IF;
577:
578: FORALL i IN 1..p_po_header_id_tbl.COUNT

Line 575: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

571: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
572:
573: d_position := 20;
574: IF (PO_LOG.d_stmt) THEN
575: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
576: END IF;
577:
578: FORALL i IN 1..p_po_header_id_tbl.COUNT
579: UPDATE po_headers_draft_all

Line 588: IF (PO_LOG.d_stmt) THEN

584: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
585:
586: d_position := 30;
587:
588: IF (PO_LOG.d_stmt) THEN
589: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
590: ' in draft table. Count = ' || SQL%ROWCOUNT);
591: END IF;
592:

Line 589: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||

585:
586: d_position := 30;
587:
588: IF (PO_LOG.d_stmt) THEN
589: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
590: ' in draft table. Count = ' || SQL%ROWCOUNT);
591: END IF;
592:
593: d_position := 40;

Line 595: IF (PO_LOG.d_proc) THEN

591: END IF;
592:
593: d_position := 40;
594:
595: IF (PO_LOG.d_proc) THEN
596: PO_LOG.proc_end(d_module);
597: END IF;
598:
599: EXCEPTION

Line 596: PO_LOG.proc_end(d_module);

592:
593: d_position := 40;
594:
595: IF (PO_LOG.d_proc) THEN
596: PO_LOG.proc_end(d_module);
597: END IF;
598:
599: EXCEPTION
600: WHEN OTHERS THEN

Line 650: IF (PO_LOG.d_proc) THEN

646: l_record_already_exist_tbl PO_TBL_VARCHAR1;
647:
648: BEGIN
649: d_position := 0;
650: IF (PO_LOG.d_proc) THEN
651: PO_LOG.proc_begin(d_module);
652: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
653: END IF;
654:

Line 651: PO_LOG.proc_begin(d_module);

647:
648: BEGIN
649: d_position := 0;
650: IF (PO_LOG.d_proc) THEN
651: PO_LOG.proc_begin(d_module);
652: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
653: END IF;
654:
655: sync_draft_from_txn

Line 652: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

648: BEGIN
649: d_position := 0;
650: IF (PO_LOG.d_proc) THEN
651: PO_LOG.proc_begin(d_module);
652: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
653: END IF;
654:
655: sync_draft_from_txn
656: ( p_po_header_id_tbl => PO_TBL_NUMBER(p_po_header_id),

Line 665: IF (PO_LOG.d_proc) THEN

661:
662: x_record_already_exist := l_record_already_exist_tbl(1);
663:
664: d_position := 10;
665: IF (PO_LOG.d_proc) THEN
666: PO_LOG.proc_end(d_module);
667: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
668: END IF;
669:

Line 666: PO_LOG.proc_end(d_module);

662: x_record_already_exist := l_record_already_exist_tbl(1);
663:
664: d_position := 10;
665: IF (PO_LOG.d_proc) THEN
666: PO_LOG.proc_end(d_module);
667: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
668: END IF;
669:
670: EXCEPTION

Line 667: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);

663:
664: d_position := 10;
665: IF (PO_LOG.d_proc) THEN
666: PO_LOG.proc_end(d_module);
667: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
668: END IF;
669:
670: EXCEPTION
671: WHEN OTHERS THEN

Line 714: IF (PO_LOG.d_proc) THEN

710: d_position NUMBER;
711:
712: BEGIN
713: d_position := 0;
714: IF (PO_LOG.d_proc) THEN
715: PO_LOG.proc_begin(d_module);
716: END IF;
717:
718: -- Since putting DELETE within MERGE statement is causing database

Line 715: PO_LOG.proc_begin(d_module);

711:
712: BEGIN
713: d_position := 0;
714: IF (PO_LOG.d_proc) THEN
715: PO_LOG.proc_begin(d_module);
716: END IF;
717:
718: -- Since putting DELETE within MERGE statement is causing database
719: -- to thrown internal error, for now we just separate the DELETE statement.

Line 1590: IF (PO_LOG.d_proc) THEN

1586: l_dummy NUMBER;
1587:
1588: BEGIN
1589: d_position := 0;
1590: IF (PO_LOG.d_proc) THEN
1591: PO_LOG.proc_begin(d_module);
1592: END IF;
1593:
1594: SELECT 1

Line 1591: PO_LOG.proc_begin(d_module);

1587:
1588: BEGIN
1589: d_position := 0;
1590: IF (PO_LOG.d_proc) THEN
1591: PO_LOG.proc_begin(d_module);
1592: END IF;
1593:
1594: SELECT 1
1595: INTO l_dummy

Line 1601: IF (PO_LOG.d_proc) THEN

1597: WHERE po_header_id = p_po_header_id
1598: AND draft_id = p_draft_id
1599: FOR UPDATE NOWAIT;
1600:
1601: IF (PO_LOG.d_proc) THEN
1602: PO_LOG.proc_end(d_module);
1603: END IF;
1604:
1605: EXCEPTION

Line 1602: PO_LOG.proc_end(d_module);

1598: AND draft_id = p_draft_id
1599: FOR UPDATE NOWAIT;
1600:
1601: IF (PO_LOG.d_proc) THEN
1602: PO_LOG.proc_end(d_module);
1603: END IF;
1604:
1605: EXCEPTION
1606: WHEN NO_DATA_FOUND THEN

Line 1634: IF (PO_LOG.d_proc) THEN

1630: l_dummy NUMBER;
1631:
1632: BEGIN
1633: d_position := 0;
1634: IF (PO_LOG.d_proc) THEN
1635: PO_LOG.proc_begin(d_module);
1636: END IF;
1637:
1638: SELECT 1

Line 1635: PO_LOG.proc_begin(d_module);

1631:
1632: BEGIN
1633: d_position := 0;
1634: IF (PO_LOG.d_proc) THEN
1635: PO_LOG.proc_begin(d_module);
1636: END IF;
1637:
1638: SELECT 1
1639: INTO l_dummy

Line 1644: IF (PO_LOG.d_proc) THEN

1640: FROM po_headers_all
1641: WHERE po_header_id = p_po_header_id
1642: FOR UPDATE NOWAIT;
1643:
1644: IF (PO_LOG.d_proc) THEN
1645: PO_LOG.proc_end(d_module);
1646: END IF;
1647:
1648: EXCEPTION

Line 1645: PO_LOG.proc_end(d_module);

1641: WHERE po_header_id = p_po_header_id
1642: FOR UPDATE NOWAIT;
1643:
1644: IF (PO_LOG.d_proc) THEN
1645: PO_LOG.proc_end(d_module);
1646: END IF;
1647:
1648: EXCEPTION
1649: WHEN NO_DATA_FOUND THEN