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_AUTOCREATE_POSTPROC_PVT dependencies on PO_DEBUG

Line 6: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;

2: /* $Header: PO_AUTOCREATE_POSTPROC_PVT.plb 120.33.12020000.13 2013/05/08 08:24:14 akyanama ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (1000) := 'po_autocreate_mainproc_pvt';
4: g_log_head CONSTANT VARCHAR2 (1000)
5: := 'po.plsql.PO_AUTOCREATE_POSTPROC_PVT.';
6: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;
8:
9:
10: PROCEDURE set_clm_structure;

Line 7: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;

3: g_pkg_name CONSTANT VARCHAR2 (1000) := 'po_autocreate_mainproc_pvt';
4: g_log_head CONSTANT VARCHAR2 (1000)
5: := 'po.plsql.PO_AUTOCREATE_POSTPROC_PVT.';
6: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;
8:
9:
10: PROCEDURE set_clm_structure;
11:

Line 79: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

75:
76: BEGIN
77: IF g_debug_stmt
78: THEN
79: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
80: END IF;
81:
82: l_progress := '001';
83:

Line 257: po_debug.debug_stmt

253: x_return_status => x_return_status,
254: x_err_msg => x_err_msg);
255:
256: IF g_debug_stmt THEN
257: po_debug.debug_stmt
258: (p_log_head => g_log_head || l_api_name,
259: p_token => l_progress,
260: p_message => 'After getting the UDA template id: ' ||x_template_id
261: );

Line 283: po_debug.debug_stmt

279: RAISE l_default_doc_number_exception;
280: END IF;
281:
282: IF g_debug_stmt THEN
283: po_debug.debug_stmt
284: (p_log_head => g_log_head || l_api_name,
285: p_token => l_progress,
286: p_message => 'After getting the Document Number: ' ||x_doc_number
287: );

Line 351: po_debug.debug_stmt

347: x_return_status => x_return_status,
348: x_err_msg => x_err_msg);
349:
350: IF g_debug_stmt THEN
351: po_debug.debug_stmt
352: (p_log_head => g_log_head || l_api_name,
353: p_token => l_progress,
354: p_message => 'After getting the UDA template id: ' ||x_template_id
355: );

Line 525: po_debug.debug_stmt

521: FROM dual;
522:
523: IF g_debug_stmt
524: THEN
525: po_debug.debug_stmt
526: (p_log_head => g_log_head || l_api_name,
527: p_token => l_progress,
528: p_message => ' ame_approval_id: '||l_ame_approval_id
529: );

Line 576: po_debug.debug_stmt

572: po_autocreate_params.x_interface_header_id;
573:
574: IF g_debug_stmt
575: THEN --< Bug 3210331: use proper debugging >
576: po_debug.debug_stmt
577: (p_log_head => g_log_head || l_api_name,
578: p_token => l_progress,
579: p_message => 'Contracts template attached'
580: );

Line 581: po_debug.debug_var (p_log_head => g_log_head

577: (p_log_head => g_log_head || l_api_name,
578: p_token => l_progress,
579: p_message => 'Contracts template attached'
580: );
581: po_debug.debug_var (p_log_head => g_log_head
582: || l_api_name,
583: p_progress => l_progress,
584: p_name => 'x_document_id',
585: p_value => l_doc_row.po_header_id

Line 587: po_debug.debug_var (p_log_head => g_log_head

583: p_progress => l_progress,
584: p_name => 'x_document_id',
585: p_value => l_doc_row.po_header_id
586: );
587: po_debug.debug_var (p_log_head => g_log_head
588: || l_api_name,
589: p_progress => l_progress,
590: p_name => 'x_draft_id',
591: p_value => l_doc_row.draft_id

Line 593: po_debug.debug_var (p_log_head => g_log_head

589: p_progress => l_progress,
590: p_name => 'x_draft_id',
591: p_value => l_doc_row.draft_id
592: );
593: po_debug.debug_var (p_log_head => g_log_head
594: || l_api_name,
595: p_progress => l_progress,
596: p_name => 'x_document_num',
597: p_value => x_document_num

Line 599: po_debug.debug_var (p_log_head => g_log_head

595: p_progress => l_progress,
596: p_name => 'x_document_num',
597: p_value => x_document_num
598: );
599: po_debug.debug_var (p_log_head => g_log_head
600: || l_api_name,
601: p_progress => l_progress,
602: p_name => 'l_contract_doc_type',
603: p_value => l_contract_doc_type

Line 605: po_debug.debug_var (p_log_head => g_log_head

601: p_progress => l_progress,
602: p_name => 'l_contract_doc_type',
603: p_value => l_contract_doc_type
604: );
605: po_debug.debug_var (p_log_head => g_log_head
606: || l_api_name,
607: p_progress => l_progress,
608: p_name => 'x_bid_number',
609: p_value => x_bid_number

Line 611: po_debug.debug_var

607: p_progress => l_progress,
608: p_name => 'x_bid_number',
609: p_value => x_bid_number
610: );
611: po_debug.debug_var
612: (p_log_head => g_log_head || l_api_name,
613: p_progress => l_progress,
614: p_name => 'p_sourcing_k_doc_type',
615: p_value => po_autocreate_params.x_sourcing_k_doc_type

Line 617: po_debug.debug_stmt

613: p_progress => l_progress,
614: p_name => 'p_sourcing_k_doc_type',
615: p_value => po_autocreate_params.x_sourcing_k_doc_type
616: );
617: po_debug.debug_stmt
618: (p_log_head => g_log_head || l_api_name,
619: p_token => l_progress,
620: p_message => 'before call okc_terms_copy_grp.copy_doc'
621: );

Line 647: po_debug.debug_stmt

643: l_progress := '060';
644:
645: IF g_debug_stmt
646: THEN
647: po_debug.debug_stmt
648: (p_log_head => g_log_head || l_api_name,
649: p_token => l_progress,
650: p_message => 'after call okc_terms_copy_grp.copy_doc.Return status:'
651: || l_return_status

Line 749: po_debug.debug_stmt

745: po_autocreate_params.x_interface_header_id;
746:
747: IF g_debug_stmt
748: THEN --< Bug 3210331: use proper debugging >
749: po_debug.debug_stmt
750: (p_log_head => g_log_head || l_api_name,
751: p_token => l_progress,
752: p_message => 'Contracts template attached'
753: );

Line 754: po_debug.debug_var (p_log_head => g_log_head

750: (p_log_head => g_log_head || l_api_name,
751: p_token => l_progress,
752: p_message => 'Contracts template attached'
753: );
754: po_debug.debug_var (p_log_head => g_log_head
755: || l_api_name,
756: p_progress => l_progress,
757: p_name => 'x_document_id',
758: p_value => l_doc_row.po_header_id

Line 760: po_debug.debug_var (p_log_head => g_log_head

756: p_progress => l_progress,
757: p_name => 'x_document_id',
758: p_value => l_doc_row.po_header_id
759: );
760: po_debug.debug_var (p_log_head => g_log_head
761: || l_api_name,
762: p_progress => l_progress,
763: p_name => 'x_document_num',
764: p_value => x_document_num

Line 766: po_debug.debug_var (p_log_head => g_log_head

762: p_progress => l_progress,
763: p_name => 'x_document_num',
764: p_value => x_document_num
765: );
766: po_debug.debug_var (p_log_head => g_log_head
767: || l_api_name,
768: p_progress => l_progress,
769: p_name => 'l_contract_doc_type',
770: p_value => l_contract_doc_type

Line 772: po_debug.debug_var (p_log_head => g_log_head

768: p_progress => l_progress,
769: p_name => 'l_contract_doc_type',
770: p_value => l_contract_doc_type
771: );
772: po_debug.debug_var (p_log_head => g_log_head
773: || l_api_name,
774: p_progress => l_progress,
775: p_name => 'x_bid_number',
776: p_value => x_bid_number

Line 778: po_debug.debug_var

774: p_progress => l_progress,
775: p_name => 'x_bid_number',
776: p_value => x_bid_number
777: );
778: po_debug.debug_var
779: (p_log_head => g_log_head || l_api_name,
780: p_progress => l_progress,
781: p_name => 'p_sourcing_k_doc_type',
782: p_value => po_autocreate_params.x_sourcing_k_doc_type

Line 784: po_debug.debug_stmt

780: p_progress => l_progress,
781: p_name => 'p_sourcing_k_doc_type',
782: p_value => po_autocreate_params.x_sourcing_k_doc_type
783: );
784: po_debug.debug_stmt
785: (p_log_head => g_log_head || l_api_name,
786: p_token => l_progress,
787: p_message => 'before call okc_terms_copy_grp.copy_doc'
788: );

Line 814: po_debug.debug_stmt

810: l_progress := '130';
811:
812: IF g_debug_stmt
813: THEN --< Bug 3210331: use proper debugging >
814: po_debug.debug_stmt
815: (p_log_head => g_log_head || l_api_name,
816: p_token => l_progress,
817: p_message => 'after call okc_terms_copy_grp.copy_doc.Return status:'
818: || l_return_status

Line 890: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

886:
887:
888: IF g_debug_stmt
889: THEN
890: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
891: END IF;
892: EXCEPTION
893: WHEN l_uda_template_exception THEN
894:

Line 896: po_debug.debug_stmt

892: EXCEPTION
893: WHEN l_uda_template_exception THEN
894:
895: IF g_debug_stmt THEN
896: po_debug.debug_stmt
897: (p_log_head => g_log_head || l_api_name,
898: p_token => l_progress,
899: p_message => 'PO_AUTOCREATE_POSTPROC_PVT.process: Inside l_uda_template_exception'
900: );

Line 919: po_debug.debug_stmt

915: WHEN l_contracts_call_exception
916: THEN
917: IF g_debug_stmt
918: THEN
919: po_debug.debug_stmt
920: (p_log_head => g_log_head || l_api_name,
921: p_token => l_progress,
922: p_message => 'PO_AUTOCREATE_POSTPROC_PVT.process: Inside l_contracts_call_exception'
923: );

Line 941: po_debug.debug_stmt

937: l_msg_count := fnd_msg_pub.count_msg;
938:
939: FOR i IN 1 .. l_msg_count
940: LOOP
941: po_debug.debug_stmt
942: (p_log_head => g_log_head || l_api_name,
943: p_token => l_progress
944: || '_EXCEPTION_'
945: || i,

Line 964: po_debug.debug_stmt

960: RAISE;
961: WHEN l_default_doc_number_exception THEN
962:
963: IF g_debug_stmt THEN
964: po_debug.debug_stmt
965: (p_log_head => g_log_head || l_api_name,
966: p_token => l_progress,
967: p_message => 'PO_AUTOCREATE_POSTPROC_PVT.process: Inside l_default_doc_number_exception'
968: );

Line 986: po_debug.debug_stmt

982: l_msg_count := fnd_msg_pub.count_msg;
983:
984: FOR i IN 1 .. l_msg_count
985: LOOP
986: po_debug.debug_stmt
987: (p_log_head => g_log_head || l_api_name,
988: p_token => l_progress
989: || '_EXCEPTION_'
990: || i,

Line 1013: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

1009: WHEN OTHERS
1010: THEN
1011: IF g_debug_unexp
1012: THEN
1013: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
1014: p_progress => l_progress
1015: );
1016: END IF;
1017:

Line 1052: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

1048: l_progress VARCHAR2 (3) := '000';
1049: BEGIN
1050: IF g_debug_stmt
1051: THEN
1052: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1053: END IF;
1054:
1055: -- calculate Tax
1056: calculate_tax (p_doc_rec);

Line 1065: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

1061: l_progress := '020';
1062:
1063: IF g_debug_stmt
1064: THEN
1065: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
1066: END IF;
1067: EXCEPTION
1068: WHEN OTHERS
1069: THEN

Line 1072: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

1068: WHEN OTHERS
1069: THEN
1070: IF g_debug_unexp
1071: THEN
1072: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
1073: p_progress => l_progress
1074: );
1075: END IF;
1076:

Line 1103: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

1099: l_progress VARCHAR2 (3) := '000';
1100: BEGIN
1101: IF g_debug_stmt
1102: THEN
1103: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1104: END IF;
1105:
1106: NULL;
1107:

Line 1118: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

1114: l_progress := '010';
1115:
1116: IF g_debug_stmt
1117: THEN
1118: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
1119: END IF;
1120: EXCEPTION
1121: WHEN OTHERS
1122: THEN

Line 1125: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

1121: WHEN OTHERS
1122: THEN
1123: IF g_debug_unexp
1124: THEN
1125: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
1126: p_progress => l_progress
1127: );
1128: END IF;
1129:

Line 1154: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

1150: x_return_status VARCHAR2 (1);
1151: BEGIN
1152: IF g_debug_stmt
1153: THEN
1154: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1155: END IF;
1156:
1157: po_tax_interface_pvt.calculate_tax
1158: (p_po_header_id => p_doc_rec.po_header_id,

Line 1167: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

1163: l_progress := '010';
1164:
1165: IF g_debug_stmt
1166: THEN
1167: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
1168: END IF;
1169: EXCEPTION
1170: WHEN OTHERS
1171: THEN

Line 1174: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

1170: WHEN OTHERS
1171: THEN
1172: IF g_debug_unexp
1173: THEN
1174: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
1175: p_progress => l_progress
1176: );
1177: END IF;
1178:

Line 1284: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

1280: x_auction_header_id po_lines_interface.auction_header_id%TYPE;
1281: BEGIN
1282: IF g_debug_stmt
1283: THEN
1284: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1285: END IF;
1286:
1287: SELECT MAX (pli.auction_header_id)
1288: INTO x_auction_header_id

Line 1367: po_debug.debug_stmt

1363: l_progress := '008';
1364:
1365: IF g_debug_stmt
1366: THEN
1367: po_debug.debug_stmt
1368: (p_log_head => g_log_head || l_api_name,
1369: p_token => l_progress,
1370: p_message => 'After copying attachments from Sourcing'
1371: );

Line 1494: po_debug.debug_stmt

1490: l_progress := '080';
1491:
1492: IF g_debug_stmt
1493: THEN
1494: po_debug.debug_stmt
1495: (p_log_head => g_log_head || l_api_name,
1496: p_token => l_progress,
1497: p_message => 'Start: copy attachments/notes from negotiation/bid to po/blanket line'
1498: );

Line 1549: po_debug.debug_stmt

1545: l_progress := '110';
1546:
1547: IF g_debug_stmt
1548: THEN --< Bug 3210331: use proper debugging >
1549: po_debug.debug_stmt
1550: (p_log_head => g_log_head || l_api_name,
1551: p_token => l_progress,
1552: p_message => 'End: copy attachments/notes from negotiation/bid to po/blanket line'
1553: );

Line 1570: po_debug.debug_stmt

1566: l_progress := '120';
1567:
1568: IF g_debug_stmt
1569: THEN
1570: po_debug.debug_stmt
1571: (p_log_head => g_log_head || l_api_name,
1572: p_token => l_progress,
1573: p_message => 'Before selecting one-time attachment'
1574: );

Line 1617: po_debug.debug_stmt

1613: -- If cannot locate one-time loc attchmnt, do nothing. This
1614: -- supports original FPH behavior.
1615: IF g_debug_stmt
1616: THEN
1617: po_debug.debug_stmt
1618: (p_log_head => g_log_head || l_api_name,
1619: p_token => l_progress,
1620: p_message => 'One-time loc attachment missing iP prefix, so do not try to move'
1621: );

Line 1673: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

1669: l_progress := '200';
1670:
1671: IF g_debug_stmt
1672: THEN
1673: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS
1677: THEN

Line 1680: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

1676: WHEN OTHERS
1677: THEN
1678: IF g_debug_unexp
1679: THEN
1680: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
1681: p_progress => l_progress
1682: );
1683: END IF;
1684:

Line 1709: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

1705: x_create_doc_flag VARCHAR2 (1) := 'Y';
1706: BEGIN
1707: IF g_debug_stmt
1708: THEN
1709: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1710: END IF;
1711:
1712: SELECT 'N'
1713: INTO x_create_doc_flag

Line 1724: po_debug.debug_stmt

1720: l_progress := '020';
1721:
1722: IF g_debug_stmt
1723: THEN
1724: po_debug.debug_stmt
1725: (p_log_head => g_log_head || l_api_name,
1726: p_token => l_progress,
1727: p_message => 'End: create_doc_from_draft_check: x_create_doc_flag : '
1728: || x_create_doc_flag

Line 1736: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

1732: l_progress := '020';
1733:
1734: IF g_debug_stmt
1735: THEN
1736: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
1737: END IF;
1738:
1739: RETURN x_create_doc_flag;
1740: EXCEPTION

Line 1821: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

1817:
1818: BEGIN
1819: IF g_debug_stmt
1820: THEN
1821: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1822: END IF;
1823:
1824: l_progress := 010;
1825:

Line 1845: po_debug.debug_stmt

1841: END LOOP;
1842:
1843: IF g_debug_stmt
1844: THEN
1845: po_debug.debug_stmt
1846: (p_log_head => g_log_head || l_api_name,
1847: p_token => l_progress,
1848: p_message => 'After setting the CLIN/SLIN structure'
1849: );

Line 1878: po_debug.debug_stmt

1874: FOR l_rec IN c_old_option_line
1875: LOOP
1876: IF g_debug_stmt
1877: THEN
1878: po_debug.debug_stmt
1879: (p_log_head => g_log_head || l_api_name,
1880: p_token => l_progress,
1881: p_message => 'po_autocreate_params.g_mode: '||po_autocreate_params.g_mode
1882: );

Line 1924: po_debug.debug_stmt

1920: END IF;
1921:
1922: IF g_debug_stmt
1923: THEN
1924: po_debug.debug_stmt
1925: (p_log_head => g_log_head || l_api_name,
1926: p_token => l_progress,
1927: p_message => 'l_draft_id: '||l_draft_id
1928: );

Line 1947: po_debug.debug_stmt

1943: END IF;
1944:
1945: IF g_debug_stmt
1946: THEN
1947: po_debug.debug_stmt
1948: (p_log_head => g_log_head || l_api_name,
1949: p_token => l_progress,
1950: p_message => 'l_next_option_num: '||l_next_option_num||'clm_base_line_num: '||l_rec.clm_base_line_num||'po_line_id: '||l_rec.po_line_id||'l_rec.rownum: '||l_rec.rownum
1951: );

Line 1961: po_debug.debug_stmt

1957: /*CLM Phas-2 changes end*/
1958:
1959: IF g_debug_stmt
1960: THEN
1961: po_debug.debug_stmt
1962: (p_log_head => g_log_head || l_api_name,
1963: p_token => l_progress,
1964: p_message => 'After setting the Option/Base structure'
1965: );

Line 1983: po_debug.debug_stmt

1979: AND pda.draft_id = po_autocreate_params.g_draft_id;
1980:
1981: IF g_debug_stmt
1982: THEN
1983: po_debug.debug_stmt
1984: (p_log_head => g_log_head || l_api_name,
1985: p_token => l_progress,
1986: p_message => 'Number of distributions drafts updated '|| SQL%ROWCOUNT
1987: );

Line 2016: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

2012:
2013:
2014: IF g_debug_stmt
2015: THEN
2016: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
2017: END IF;
2018: EXCEPTION
2019: WHEN OTHERS
2020: THEN

Line 2023: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

2019: WHEN OTHERS
2020: THEN
2021: IF g_debug_unexp
2022: THEN
2023: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
2024: p_progress => l_progress
2025: );
2026: END IF;
2027:

Line 2104: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

2100: x_mode VARCHAR2 (25);
2101: BEGIN
2102: IF g_debug_stmt
2103: THEN
2104: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
2105: END IF;
2106:
2107: -- Fetch the Docuemnt Type Code, Doc Sub type, group_cod,action
2108: SELECT phi.document_num, phi.document_type_code, phi.document_subtype,

Line 2207: po_debug.debug_stmt

2203: l_progress := '120';
2204:
2205: IF g_debug_stmt
2206: THEN
2207: po_debug.debug_stmt
2208: (p_log_head => g_log_head || l_api_name,
2209: p_token => l_progress,
2210: p_message => 'set_line_num_display mode is :'
2211: || po_autocreate_params.g_mode

Line 2268: po_debug.debug_stmt (p_log_head => g_log_head

2264: l_progress := '230';
2265:
2266: IF g_debug_stmt
2267: THEN
2268: po_debug.debug_stmt (p_log_head => g_log_head
2269: || l_api_name,
2270: p_token => l_progress,
2271: p_message => 'Grouping is default'
2272: );

Line 2332: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

2328: END LOOP;
2329:
2330: IF g_debug_stmt
2331: THEN
2332: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
2333: END IF;
2334: EXCEPTION
2335: WHEN OTHERS
2336: THEN

Line 2339: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

2335: WHEN OTHERS
2336: THEN
2337: IF g_debug_unexp
2338: THEN
2339: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
2340: p_progress => l_progress
2341: );
2342: END IF;
2343:

Line 2404: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

2400:
2401: BEGIN
2402: IF g_debug_stmt
2403: THEN
2404: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
2405: END IF;
2406:
2407: l_progress := '020';
2408: SELECT style_id

Line 2415: po_debug.debug_stmt

2411: WHERE interface_header_id = po_autocreate_params.g_interface_header_id;
2412:
2413: IF g_debug_stmt
2414: THEN
2415: po_debug.debug_stmt
2416: (p_log_head => g_log_head || l_api_name,
2417: p_token => l_progress,
2418: p_message => 'Style Id is : '|| l_style_id
2419: );

Line 2433: po_debug.debug_var

2429: AND document_style_id = l_style_id;
2430:
2431: IF g_debug_stmt
2432: THEN
2433: po_debug.debug_var
2434: (p_log_head => g_log_head || l_api_name,
2435: p_progress => l_progress,
2436: p_name => 'x_doc_level_tbl',
2437: p_value => x_doc_level_tbl

Line 2454: po_debug.debug_stmt

2450: x_return_status => l_return_status,
2451: x_err_msg => l_err_msg
2452: );
2453: IF g_debug_stmt THEN
2454: po_debug.debug_stmt
2455: (p_log_head => g_log_head || l_api_name,
2456: p_token => l_progress,
2457: p_message => 'After getting the UDA template id: ' ||l_template_id
2458: );

Line 2519: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

2515: END LOOP;
2516:
2517: IF g_debug_stmt
2518: THEN
2519: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
2520: END IF;
2521:
2522: EXCEPTION
2523: WHEN OTHERS

Line 2527: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

2523: WHEN OTHERS
2524: THEN
2525: IF g_debug_unexp
2526: THEN
2527: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
2528: p_progress => l_progress
2529: );
2530: END IF;
2531:

Line 2566: po_debug.debug_var(g_log_head || l_api_name,l_progress,'x_slin_line_id',x_slin_line_id);

2562: l_progress := '010';
2563: x_slin_line_id := po_lines_s.nextval;
2564:
2565: IF g_debug_stmt THEN
2566: po_debug.debug_var(g_log_head || l_api_name,l_progress,'x_slin_line_id',x_slin_line_id);
2567: END IF;
2568: /*create a info SLIN line. The group_line_id will be the po_line_id of the parent clin line. clm_info_flag will be 'Y' and the item description = 'Funding for '||item_description of the parent line*/
2569:
2570: l_progress := '020';

Line 2587: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_max_line_num',l_max_line_num);

2583:
2584: l_slin_line_num := l_max_line_num +1;
2585:
2586: IF g_debug_stmt THEN
2587: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_max_line_num',l_max_line_num);
2588: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_slin_line_num',l_slin_line_num);
2589: END IF;
2590:
2591: l_progress := '020';

Line 2588: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_slin_line_num',l_slin_line_num);

2584: l_slin_line_num := l_max_line_num +1;
2585:
2586: IF g_debug_stmt THEN
2587: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_max_line_num',l_max_line_num);
2588: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_slin_line_num',l_slin_line_num);
2589: END IF;
2590:
2591: l_progress := '020';
2592: BEGIN

Line 2611: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_clin_line_num_display',l_clin_line_num_display);

2607: 'Y', --clmInfoFlag
2608: -9999);--Invalid Draft Id
2609:
2610: IF g_debug_stmt THEN
2611: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_clin_line_num_display',l_clin_line_num_display);
2612: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_slin_line_num_display',l_slin_line_num_display);
2613: END IF;
2614:
2615:

Line 2612: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_slin_line_num_display',l_slin_line_num_display);

2608: -9999);--Invalid Draft Id
2609:
2610: IF g_debug_stmt THEN
2611: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_clin_line_num_display',l_clin_line_num_display);
2612: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_slin_line_num_display',l_slin_line_num_display);
2613: END IF;
2614:
2615:
2616: IF p_draft_id <> -1 THEN

Line 2700: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

2696:
2697: EXCEPTION
2698: WHEN others THEN
2699: IF g_debug_unexp THEN
2700: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
2701: p_progress => l_progress
2702: );
2703: END IF;
2704: po_message_s.sql_error ('CREATE_INFO_SLIN', l_progress, SQLCODE);

Line 2737: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_header_id',p_po_header_id_tbl);

2733: BEGIN
2734:
2735: l_progress := '010';
2736: IF g_debug_stmt THEN
2737: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_header_id',p_po_header_id_tbl);
2738: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_line_id',p_po_line_id_tbl);
2739: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_draft_id',p_draft_id_tbl);
2740: END IF;
2741:

Line 2738: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_line_id',p_po_line_id_tbl);

2734:
2735: l_progress := '010';
2736: IF g_debug_stmt THEN
2737: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_header_id',p_po_header_id_tbl);
2738: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_line_id',p_po_line_id_tbl);
2739: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_draft_id',p_draft_id_tbl);
2740: END IF;
2741:
2742: l_progress := '020';

Line 2739: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_draft_id',p_draft_id_tbl);

2735: l_progress := '010';
2736: IF g_debug_stmt THEN
2737: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_header_id',p_po_header_id_tbl);
2738: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_po_line_id',p_po_line_id_tbl);
2739: po_debug.debug_var(g_log_head || l_api_name,l_progress,'p_draft_id',p_draft_id_tbl);
2740: END IF;
2741:
2742: l_progress := '020';
2743:

Line 2768: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_is_convert_valid',l_is_convert_valid);

2764: l_is_convert_valid := 'N';
2765: END;
2766:
2767: IF g_debug_stmt THEN
2768: po_debug.debug_var(g_log_head || l_api_name,l_progress,'l_is_convert_valid',l_is_convert_valid);
2769: END IF;
2770:
2771: l_progress := '050';
2772:

Line 2783: po_debug.debug_var(g_log_head || l_api_name,l_progress,'x_slin_line_id',x_slin_line_id);

2779: , p_draft_id_tbl(i)
2780: , x_slin_line_id);
2781:
2782: IF g_debug_stmt THEN
2783: po_debug.debug_var(g_log_head || l_api_name,l_progress,'x_slin_line_id',x_slin_line_id);
2784: END IF;
2785:
2786: --move distributions
2787: IF p_draft_id_tbl(i) <> -1 THEN

Line 2807: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

2803:
2804: EXCEPTION
2805: WHEN others THEN
2806: IF g_debug_unexp THEN
2807: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
2808: p_progress => l_progress
2809: );
2810: END IF;
2811: po_message_s.sql_error ('CONVERT_FUND_TO_INFO_SLIN', l_progress, SQLCODE);

Line 2843: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);

2839: l_progress := '010';
2840:
2841: IF g_debug_stmt
2842: THEN
2843: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
2844: END IF;
2845:
2846: l_cdrls_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2847: p_option_column => PO_CORE_S.g_CONT_DATA_REQS_COL);

Line 2894: po_debug.debug_stmt

2890:
2891: l_progress := '020';
2892:
2893: IF g_debug_stmt THEN
2894: po_debug.debug_stmt
2895: (p_log_head => g_log_head || l_api_name,
2896: p_token => l_progress,
2897: p_message => 'No. of records copied : ' || SQL%ROWCOUNT
2898: );

Line 2930: po_debug.debug_stmt

2926:
2927: l_progress := '020';
2928:
2929: IF g_debug_stmt THEN
2930: po_debug.debug_stmt
2931: (p_log_head => g_log_head || l_api_name,
2932: p_token => l_progress,
2933: p_message => 'l_return_status : ' || l_return_status ||' l_msg_data:'||l_msg_data
2934: );

Line 2943: po_debug.debug_end (p_log_head => g_log_head || l_api_name);

2939: l_progress := '030';
2940:
2941: IF g_debug_stmt
2942: THEN
2943: po_debug.debug_end (p_log_head => g_log_head || l_api_name);
2944: END IF;
2945:
2946: EXCEPTION
2947: WHEN others THEN

Line 2949: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,

2945:
2946: EXCEPTION
2947: WHEN others THEN
2948: IF g_debug_unexp THEN
2949: po_debug.debug_exc (p_log_head => g_log_head || l_api_name,
2950: p_progress => l_progress
2951: );
2952: END IF;
2953: po_message_s.sql_error ('COPY_EXHIBIT_FROM_SOL', l_progress, SQLCODE);