DBA Data[Home] [Help]

APPS.PO_GA_PVT dependencies on PO_DEBUG

Line 9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

5: G_PKG_NAME CONSTANT varchar2(30) := 'PO_GA_PVT';
6:
7: --< Shared Proc FPJ Start >
8: -- Debugging booleans used to bypass logging when turned off
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
13: --< Shared Proc FPJ End >

Line 10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

6:
7: --< Shared Proc FPJ Start >
8: -- Debugging booleans used to bypass logging when turned off
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
13: --< Shared Proc FPJ End >
14:

Line 685: PO_DEBUG.debug_stmt

681: l_progress := '000';
682: x_return_status := FND_API.g_ret_sts_success;
683:
684: IF g_debug_stmt THEN
685: PO_DEBUG.debug_stmt
686: (p_log_head => g_module_prefix||'validate_item',
687: p_token => 'invoked',
688: p_message => 'item ID: '||p_item_id||' org ID: '||p_org_id||
689: ' valid org ID: '||p_valid_org_id);

Line 738: PO_DEBUG.debug_var

734:
735: END IF;
736:
737: IF g_debug_stmt THEN
738: PO_DEBUG.debug_var
739: (p_log_head => g_module_prefix||'validate_item',
740: p_progress => l_progress,
741: p_name => 'x_is_purchasable',
742: p_value => x_is_purchasable);

Line 743: PO_DEBUG.debug_var

739: (p_log_head => g_module_prefix||'validate_item',
740: p_progress => l_progress,
741: p_name => 'x_is_purchasable',
742: p_value => x_is_purchasable);
743: PO_DEBUG.debug_var
744: (p_log_head => g_module_prefix||'validate_item',
745: p_progress => l_progress,
746: p_name => 'x_is_same_uom_class',
747: p_value => x_is_same_uom_class);

Line 748: PO_DEBUG.debug_var

744: (p_log_head => g_module_prefix||'validate_item',
745: p_progress => l_progress,
746: p_name => 'x_is_same_uom_class',
747: p_value => x_is_same_uom_class);
748: PO_DEBUG.debug_var
749: (p_log_head => g_module_prefix||'validate_item',
750: p_progress => l_progress,
751: p_name => 'x_is_not_osp_item',
752: p_value => x_is_not_osp_item);

Line 767: PO_DEBUG.debug_exc

763: p_procedure_name => 'validate_item',
764: p_error_text => 'Progress: '||l_progress||
765: ' Error: '||SUBSTRB(SQLERRM,1,215));
766: IF g_debug_unexp THEN
767: PO_DEBUG.debug_exc
768: (p_log_head => g_module_prefix||'validate_item',
769: p_progress => l_progress);
770: END IF;
771: END validate_item;

Line 1472: PO_DEBUG.debug_stmt

1468: l_progress := '000';
1469: x_return_status := FND_API.g_ret_sts_success;
1470:
1471: IF g_debug_stmt THEN
1472: PO_DEBUG.debug_stmt
1473: (p_log_head => g_module_prefix||'validate_item_revision',
1474: p_token => 'invoked',
1475: p_message => 'item ID: '||p_item_id||' org ID: '||p_org_id||
1476: ' ga item rev: '||p_ga_item_revision||' ownorg ID: '||

Line 1567: PO_DEBUG.debug_exc

1563: p_procedure_name => 'validate_item_revision',
1564: p_error_text => 'Progress: '||l_progress||
1565: ' Error: '||SUBSTRB(SQLERRM,1,215));
1566: IF g_debug_unexp THEN
1567: PO_DEBUG.debug_exc
1568: (p_log_head => g_module_prefix || 'validate_item_revision',
1569: p_progress => l_progress);
1570: END IF;
1571: END validate_item_revision;

Line 1649: PO_DEBUG.debug_stmt

1645: l_progress := '000';
1646: x_return_status := FND_API.g_ret_sts_success;
1647:
1648: IF g_debug_stmt THEN
1649: PO_DEBUG.debug_stmt
1650: (p_log_head => g_module_prefix||'validate_item_in_org',
1651: p_token => 'invoked',
1652: p_message => 'item ID: '||p_item_id||' org ID: '||p_org_id||
1653: ' orgtype: '||p_ga_org_type||' ga item rev: '||

Line 1725: PO_DEBUG.debug_stmt

1721: WHEN APP_EXCEPTION.application_exception THEN
1722: x_return_status := FND_API.g_ret_sts_error;
1723: FND_MSG_PUB.add;
1724: IF g_debug_stmt THEN
1725: PO_DEBUG.debug_stmt
1726: (p_log_head => g_module_prefix||'validate_item_in_org',
1727: p_token => l_progress,
1728: p_message => 'APPLICATION_EXCEPTION caught.');
1729: END IF;

Line 1741: PO_DEBUG.debug_exc

1737: p_procedure_name => 'validate_item_in_org',
1738: p_error_text => 'Progress: '||l_progress||
1739: ' Error: '||SUBSTRB(SQLERRM,1,215));
1740: IF g_debug_unexp THEN
1741: PO_DEBUG.debug_exc
1742: (p_log_head => g_module_prefix || 'validate_item_in_org',
1743: p_progress => l_progress);
1744: END IF;
1745: END validate_item_in_org;

Line 1795: PO_DEBUG.debug_stmt

1791: l_progress := '000';
1792: x_return_status := FND_API.g_ret_sts_success;
1793:
1794: IF g_debug_stmt THEN
1795: PO_DEBUG.debug_stmt
1796: (p_log_head => g_module_prefix||'val_enabled_purchasing_org',
1797: p_token => 'invoked',
1798: p_message => 'po_header_id: '||p_po_header_id||
1799: ' purchorg ID: '||x_purchasing_org_id);

Line 1833: PO_DEBUG.debug_var

1829: -- Successful select means that it is a valid enabled purchasing org
1830: x_is_valid := TRUE;
1831:
1832: IF g_debug_stmt THEN
1833: PO_DEBUG.debug_var
1834: (p_log_head => g_module_prefix||'val_enabled_purchasing_org',
1835: p_progress => l_progress,
1836: p_name => 'x_is_valid',
1837: p_value => x_is_valid);

Line 1844: PO_DEBUG.debug_var

1840: EXCEPTION
1841: WHEN NO_DATA_FOUND THEN
1842: x_is_valid := FALSE;
1843: IF g_debug_stmt THEN
1844: PO_DEBUG.debug_var
1845: (p_log_head => g_module_prefix||'val_enabled_purchasing_org',
1846: p_progress => l_progress,
1847: p_name => 'x_is_valid',
1848: p_value => x_is_valid);

Line 1857: PO_DEBUG.debug_exc

1853: p_procedure_name => 'val_enabled_purchasing_org',
1854: p_error_text => 'Progress: '||l_progress||
1855: ' Error: '||SUBSTRB(SQLERRM,1,215));
1856: IF g_debug_unexp THEN
1857: PO_DEBUG.debug_exc
1858: (p_log_head => g_module_prefix||'val_enabled_purchasing_org',
1859: p_progress => l_progress);
1860: END IF;
1861: END val_enabled_purchasing_org;

Line 1915: PO_DEBUG.debug_stmt

1911: l_progress := '000';
1912: x_return_status := FND_API.g_ret_sts_success;
1913:
1914: IF g_debug_stmt THEN
1915: PO_DEBUG.debug_stmt
1916: (p_log_head => g_module_prefix||'val_enabled_requesting_org',
1917: p_token => 'invoked',
1918: p_message => 'po_header_id: '||p_po_header_id||
1919: ' reqorg ID: '||x_requesting_org_id);

Line 1953: PO_DEBUG.debug_var

1949: -- Successful select means that it is a valid enabled requesting org
1950: x_is_valid := TRUE;
1951:
1952: IF g_debug_stmt THEN
1953: PO_DEBUG.debug_var
1954: (p_log_head => g_module_prefix||'val_enabled_requesting_org',
1955: p_progress => l_progress,
1956: p_name => 'x_is_valid',
1957: p_value => x_is_valid);

Line 1965: PO_DEBUG.debug_var

1961: WHEN NO_DATA_FOUND THEN
1962: x_purchasing_org_id := NULL;
1963: x_is_valid := FALSE;
1964: IF g_debug_stmt THEN
1965: PO_DEBUG.debug_var
1966: (p_log_head => g_module_prefix||'val_enabled_requesting_org',
1967: p_progress => l_progress,
1968: p_name => 'x_is_valid',
1969: p_value => x_is_valid);

Line 1978: PO_DEBUG.debug_exc

1974: p_procedure_name => 'val_enabled_requesting_org',
1975: p_error_text => 'Progress: '||l_progress||
1976: ' Error: '||SUBSTRB(SQLERRM,1,215));
1977: IF g_debug_unexp THEN
1978: PO_DEBUG.debug_exc
1979: (p_log_head => g_module_prefix||'val_enabled_requesting_org',
1980: p_progress => l_progress);
1981: END IF;
1982: END val_enabled_requesting_org;

Line 2051: PO_DEBUG.debug_stmt

2047: l_progress := '000';
2048: x_return_status := FND_API.g_ret_sts_success;
2049:
2050: IF g_debug_stmt THEN
2051: PO_DEBUG.debug_stmt
2052: (p_log_head => g_module_prefix||'validate_in_purchasing_org',
2053: p_token => 'invoked',
2054: p_message => 'po_header_id: '||p_po_header_id||' item ID: '||
2055: p_item_id||' purchorg ID: '||p_purchasing_org_id||

Line 2099: PO_DEBUG.debug_var

2095: RAISE FND_API.g_exc_unexpected_error;
2096: END IF;
2097:
2098: IF g_debug_stmt THEN
2099: PO_DEBUG.debug_var
2100: (p_log_head => g_module_prefix||'validate_in_purchasing_org',
2101: p_progress => l_progress,
2102: p_name => 'x_is_item_valid',
2103: p_value => x_is_item_valid);

Line 2118: PO_DEBUG.debug_exc

2114: p_procedure_name => 'validate_in_purchasing_org',
2115: p_error_text => 'Progress: '||l_progress||
2116: ' Error: '||SUBSTRB(SQLERRM,1,215));
2117: IF g_debug_unexp THEN
2118: PO_DEBUG.debug_exc
2119: (p_log_head => g_module_prefix||'validate_in_purchasing_org',
2120: p_progress => l_progress);
2121: END IF;
2122: END validate_in_purchasing_org;

Line 2194: PO_DEBUG.debug_stmt

2190: l_progress := '000';
2191: x_return_status := FND_API.g_ret_sts_success;
2192:
2193: IF g_debug_stmt THEN
2194: PO_DEBUG.debug_stmt
2195: (p_log_head => g_module_prefix||'validate_in_requesting_org',
2196: p_token => 'invoked',
2197: p_message => 'po_header_id: '||p_po_header_id||' item ID: '||
2198: p_item_id||' reqorg ID: '||p_requesting_org_id||

Line 2266: PO_DEBUG.debug_var

2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;
2264:
2265: IF g_debug_stmt THEN
2266: PO_DEBUG.debug_var
2267: (p_log_head => g_module_prefix||'validate_in_requesting_org',
2268: p_progress => l_progress,
2269: p_name => 'x_is_item_valid',
2270: p_value => x_is_item_valid);

Line 2285: PO_DEBUG.debug_exc

2281: p_procedure_name => 'validate_in_requesting_org',
2282: p_error_text => 'Progress: '||l_progress||
2283: ' Error: '||SUBSTRB(SQLERRM,1,215));
2284: IF g_debug_unexp THEN
2285: PO_DEBUG.debug_exc
2286: (p_log_head => g_module_prefix||'validate_in_requesting_org',
2287: p_progress => l_progress);
2288: END IF;
2289: END validate_in_requesting_org;