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.CSTPPWAS dependencies on FND_LOG

Line 6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2: /* $Header: CSTPWASB.pls 120.45.12020000.3 2012/12/19 12:04:06 penpan ship $ */
3:
4: G_MAX_RECORDS CONSTANT NUMBER := 1000;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAS';
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7:
8: /*---------------------------------------------------------------------------*
9: | PRIVATE PROCEDURE |
10: | insert_wip_costs |

Line 52: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

48: l_api_name CONSTANT VARCHAR2(30) := 'insert_wip_costs';
49: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
50: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

49: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
50: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

50: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:

Line 55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:
59: BEGIN

Line 56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

52: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:
59: BEGIN
60:

Line 57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:
59: BEGIN
60:
61: IF (l_pLog) THEN

Line 63: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

59: BEGIN
60:
61: IF (l_pLog) THEN
62:
63: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
64: l_module || '.begin',
65: l_api_name || ' <<< Parameters:
66: p_pac_period_id = ' || p_pac_period_id || '
67: p_prior_period_id = ' || p_prior_period_id || '

Line 130: -- Statement level log message for FND logging

126: WHERE wppb.WIP_ENTITY_ID = p_entity_id
127: AND wppb.PAC_PERIOD_ID = p_prior_period_id
128: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));
129:
130: -- Statement level log message for FND logging
131: IF (l_sLog) THEN
132: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
133: l_module || '.'||l_stmt_num,
134: 'l_transaction_action_id :' || l_transaction_action_id || ','||

Line 132: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

128: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));
129:
130: -- Statement level log message for FND logging
131: IF (l_sLog) THEN
132: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
133: l_module || '.'||l_stmt_num,
134: 'l_transaction_action_id :' || l_transaction_action_id || ','||
135: 'l_transaction_source_type_id :' || l_transaction_source_type_id || ','||
136: 'l_net_qty :' || l_net_qty || ','||

Line 1355: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1351: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));
1352: END IF;
1353:
1354: IF (l_pLog) THEN
1355: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1356: l_module || '.end',
1357: l_api_name || ' >>>');
1358: END IF;
1359:

Line 1363: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1359:
1360: EXCEPTION
1361: WHEN OTHERS THEN
1362: IF (l_uLog) THEN
1363: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1364: l_module || '.' || l_stmt_num,
1365: SQLERRM);
1366: END IF;
1367: ROLLBACK;

Line 1501: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

1497: l_api_name CONSTANT VARCHAR2(30) := 'Relief_BOM_Quantity';
1498: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1499: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1500:
1501: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1502: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1505: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 1502: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

1498: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1499: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1500:
1501: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1502: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1505: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1506: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 1503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1499: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1500:
1501: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1502: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1505: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1506: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1507:

Line 1504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1500:
1501: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1502: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1505: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1506: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1507:
1508: BEGIN

Line 1505: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1501: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1502: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1505: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1506: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1507:
1508: BEGIN
1509:

Line 1506: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1502: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1505: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1506: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1507:
1508: BEGIN
1509:
1510: IF (l_pLog) THEN

Line 1512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1508: BEGIN
1509:
1510: IF (l_pLog) THEN
1511:
1512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1513: l_module || '.begin',
1514: l_api_name || ' <<< Parameters:
1515: p_pac_period_id = ' || p_pac_period_id || '
1516: p_prior_period_id = ' || p_prior_period_id || '

Line 1657: -- Statement level log message for FND logging

1653: l_op_relieved_comp_cost(i) := l_op_relieved_comp_cost(i) + Nvl(l_current_period_cost * l_avl_relieve_qty, 0);
1654: -- This is used to find out balance to be relieved from this job in this period
1655: l_job_balance(i) := l_job_balance(i) + Nvl(l_current_period_cost * l_avl_relieve_qty,0);
1656:
1657: -- Statement level log message for FND logging
1658: IF (l_sLog) THEN
1659: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1660: l_module || '.'||l_stmt_num,
1661: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||

Line 1659: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1655: l_job_balance(i) := l_job_balance(i) + Nvl(l_current_period_cost * l_avl_relieve_qty,0);
1656:
1657: -- Statement level log message for FND logging
1658: IF (l_sLog) THEN
1659: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1660: l_module || '.'||l_stmt_num,
1661: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||
1662: 'Component :' || comp_rec.component || ','||
1663: 'Cost Element :' || i || ','||

Line 1746: -- Statement level log message for FND logging

1742: -------------------------------------------------------------
1743: l_stmt_num := 70;
1744: l_required_qty := p_net_qty * comp_rec.quantity_per_assembly;
1745:
1746: -- Statement level log message for FND logging
1747: IF (l_sLog) THEN
1748: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1749: l_module || '.'||l_stmt_num,
1750: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||

Line 1748: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1744: l_required_qty := p_net_qty * comp_rec.quantity_per_assembly;
1745:
1746: -- Statement level log message for FND logging
1747: IF (l_sLog) THEN
1748: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1749: l_module || '.'||l_stmt_num,
1750: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||
1751: 'Component :' || comp_rec.component || ','||
1752: 'Cost Element :' || cstelement_rec.cst_ele_id || ','||

Line 1804: -- Statement level log message for FND logging

1800: -- For more Assembly returns than Assembly completions then sign of p_net_qty is negative.
1801: -- So making sign to opposite sign.
1802: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + Nvl(l_avl_relieve_value,0) * (-1);
1803:
1804: -- Statement level log message for FND logging
1805: IF (l_sLog) THEN
1806: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1807: l_module || '.'||l_stmt_num,
1808: 'l_avl_relieve_value :' || l_avl_relieve_value || ','||

Line 1806: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1802: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + Nvl(l_avl_relieve_value,0) * (-1);
1803:
1804: -- Statement level log message for FND logging
1805: IF (l_sLog) THEN
1806: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1807: l_module || '.'||l_stmt_num,
1808: 'l_avl_relieve_value :' || l_avl_relieve_value || ','||
1809: 'l_avl_relieve_qty :' || l_avl_relieve_qty || ','||
1810: 'l_op_relieved_comp_cost :' || l_op_relieved_comp_cost(cstelement_rec.cst_ele_id) || ','||

Line 1894: -- Statement level log message for FND logging

1890: (-1) * Nvl(l_prior_relieved_value,0);
1891: -- This is used to find out balance to be relieved from this job in this period
1892: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + (-1) * Nvl(l_prior_relieved_value,0);
1893:
1894: -- Statement level log message for FND logging
1895: IF (l_sLog) THEN
1896: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1897: l_module || '.'||l_stmt_num,
1898: 'l_assembly_return_cnt :' || l_assembly_return_cnt || ','||

Line 1896: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1892: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + (-1) * Nvl(l_prior_relieved_value,0);
1893:
1894: -- Statement level log message for FND logging
1895: IF (l_sLog) THEN
1896: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1897: l_module || '.'||l_stmt_num,
1898: 'l_assembly_return_cnt :' || l_assembly_return_cnt || ','||
1899: 'l_prior_relieved_value :' || l_prior_relieved_value || ','||
1900: 'l_prior_relieved_comp_cost :' || l_prior_relieved_comp_cost(cstelement_rec.cst_ele_id) || ','||

Line 1951: -- Statement level log message for FND logging

1947: Nvl(l_avl_relieve_value,0);
1948: -- This is used to find out balance to be relieved from this job in this period
1949: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + Nvl(l_avl_relieve_value,0);
1950:
1951: -- Statement level log message for FND logging
1952: IF (l_sLog) THEN
1953: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1954: l_module || '.'||l_stmt_num,
1955: 'l_skip_below_process :' || l_skip_below_process || ','||

Line 1953: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1949: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + Nvl(l_avl_relieve_value,0);
1950:
1951: -- Statement level log message for FND logging
1952: IF (l_sLog) THEN
1953: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1954: l_module || '.'||l_stmt_num,
1955: 'l_skip_below_process :' || l_skip_below_process || ','||
1956: 'l_avl_relieve_value :' || l_avl_relieve_value || ','||
1957: 'l_op_relieved_comp_cost :' || l_op_relieved_comp_cost(cstelement_rec.cst_ele_id) || ','||

Line 1992: -- Statement level log message for FND logging

1988: AND cprocd.operation_seq_num = op_seq_rec.operation_seq_num
1989: AND cprocd.inventory_item_id = comp_rec.component
1990: AND cprocd.cost_element_id = cstelement_rec.cst_ele_id;
1991:
1992: -- Statement level log message for FND logging
1993: IF (l_sLog) THEN
1994: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1995: l_module || '.'||l_stmt_num,
1996: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1994: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1990: AND cprocd.cost_element_id = cstelement_rec.cst_ele_id;
1991:
1992: -- Statement level log message for FND logging
1993: IF (l_sLog) THEN
1994: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1995: l_module || '.'||l_stmt_num,
1996: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1997: 'l_applied_qty :' || l_applied_qty || ','||
1998: 'l_avl_relieve_qty :' || l_avl_relieve_qty || ','||

Line 2025: -- Statement level log message for FND logging

2021: IF ( (l_required_qty > 0 AND l_applied_qty > l_required_qty) OR
2022: (l_required_qty < 0 AND l_applied_qty < l_required_qty)) THEN
2023:
2024: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
2025: -- Statement level log message for FND logging
2026: IF (l_sLog) THEN
2027: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2028: l_module || '.'||l_stmt_num,
2029: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2027: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2023:
2024: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
2025: -- Statement level log message for FND logging
2026: IF (l_sLog) THEN
2027: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2028: l_module || '.'||l_stmt_num,
2029: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2030: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2031: END IF;

Line 2047: -- Statement level log message for FND logging

2043: AND cpicd.cost_element_id = cstelement_rec.cst_ele_id;
2044:
2045: l_avl_relieve_value := l_current_period_cost * l_required_qty;
2046: l_avl_relieve_qty := l_required_qty;
2047: -- Statement level log message for FND logging
2048: IF (l_sLog) THEN
2049: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2050: l_module || '.'||l_stmt_num,
2051: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2049: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2045: l_avl_relieve_value := l_current_period_cost * l_required_qty;
2046: l_avl_relieve_qty := l_required_qty;
2047: -- Statement level log message for FND logging
2048: IF (l_sLog) THEN
2049: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2050: l_module || '.'||l_stmt_num,
2051: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2052: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2053: END IF;

Line 2078: -- Statement level log message for FND logging

2074: IF ( (l_required_qty > 0 AND l_applied_qty > l_required_qty) OR
2075: (l_required_qty < 0 AND l_applied_qty < l_required_qty)) THEN
2076:
2077: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
2078: -- Statement level log message for FND logging
2079: IF (l_sLog) THEN
2080: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2081: l_module || '.'||l_stmt_num,
2082: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2080: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2076:
2077: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
2078: -- Statement level log message for FND logging
2079: IF (l_sLog) THEN
2080: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2081: l_module || '.'||l_stmt_num,
2082: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2083: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2084: END IF;

Line 2100: -- Statement level log message for FND logging

2096:
2097: l_avl_relieve_value := (l_avl_relieve_value/l_avl_relieve_qty) * l_required_qty;
2098: l_avl_relieve_qty := l_required_qty;
2099:
2100: -- Statement level log message for FND logging
2101: IF (l_sLog) THEN
2102: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2103: l_module || '.'||l_stmt_num,
2104: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2102: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2098: l_avl_relieve_qty := l_required_qty;
2099:
2100: -- Statement level log message for FND logging
2101: IF (l_sLog) THEN
2102: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2103: l_module || '.'||l_stmt_num,
2104: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2105: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2106: END IF;

Line 2130: -- Statement level log message for FND logging

2126: l_avl_relieve_value := l_avl_relieve_value + (l_required_qty - l_avl_relieve_qty) *
2127: l_current_period_cost;
2128: l_avl_relieve_qty := l_required_qty;
2129:
2130: -- Statement level log message for FND logging
2131: IF (l_sLog) THEN
2132: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2133: l_module || '.'||l_stmt_num,
2134: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2132: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2128: l_avl_relieve_qty := l_required_qty;
2129:
2130: -- Statement level log message for FND logging
2131: IF (l_sLog) THEN
2132: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2133: l_module || '.'||l_stmt_num,
2134: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2135: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2136: END IF;

Line 2161: -- Statement level log message for FND logging

2157: IF ( (l_required_qty > 0 AND l_applied_qty > l_required_qty) OR
2158: (l_required_qty < 0 AND l_applied_qty < l_required_qty)) THEN
2159:
2160: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
2161: -- Statement level log message for FND logging
2162: IF (l_sLog) THEN
2163: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2164: l_module || '.'||l_stmt_num,
2165: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2163: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2159:
2160: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
2161: -- Statement level log message for FND logging
2162: IF (l_sLog) THEN
2163: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2164: l_module || '.'||l_stmt_num,
2165: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2166: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2167: END IF;

Line 2187: -- Statement level log message for FND logging

2183:
2184: l_avl_relieve_value := l_current_period_cost * l_required_qty;
2185: l_avl_relieve_qty := l_required_qty;
2186:
2187: -- Statement level log message for FND logging
2188: IF (l_sLog) THEN
2189: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2190: l_module || '.'||l_stmt_num,
2191: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2189: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2185: l_avl_relieve_qty := l_required_qty;
2186:
2187: -- Statement level log message for FND logging
2188: IF (l_sLog) THEN
2189: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2190: l_module || '.'||l_stmt_num,
2191: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2192: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2193: END IF;

Line 2212: -- Statement level log message for FND logging

2208: ELSE
2209: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + Nvl(l_avl_relieve_value,0);
2210: END IF;
2211:
2212: -- Statement level log message for FND logging
2213: IF (l_sLog) THEN
2214: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2215: l_module || '.'||l_stmt_num,
2216: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2214: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2210: END IF;
2211:
2212: -- Statement level log message for FND logging
2213: IF (l_sLog) THEN
2214: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2215: l_module || '.'||l_stmt_num,
2216: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2217: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
2218: END IF;

Line 2255: -- Statement level log message for FND logging

2251: AND cprocd.cost_element_id = cstelement_rec.cst_ele_id
2252: AND cprocd.cost_group_id = p_cost_group_id
2253: AND cprocd.pac_period_id = p_pac_period_id;
2254:
2255: -- Statement level log message for FND logging
2256: IF (l_sLog) THEN
2257: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2258: l_module || '.'||l_stmt_num,
2259: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 2257: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2253: AND cprocd.pac_period_id = p_pac_period_id;
2254:
2255: -- Statement level log message for FND logging
2256: IF (l_sLog) THEN
2257: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2258: l_module || '.'||l_stmt_num,
2259: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
2260: 'l_prior_relieved_value :' ||l_prior_relieved_value || ','||
2261: 'l_avl_relieve_qty :' || l_avl_relieve_qty);

Line 2408: -- Statement level log message for FND logging

2404: AND wppb.cost_type_id = p_cost_type_id
2405: AND wppb.wip_entity_id = p_entity_id
2406: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2407:
2408: -- Statement level log message for FND logging
2409: IF (l_sLog) THEN
2410: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2411: l_module || '.'||l_stmt_num,
2412: ' Negative Value in Job of Cost element = 1');

Line 2410: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2406: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2407:
2408: -- Statement level log message for FND logging
2409: IF (l_sLog) THEN
2410: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2411: l_module || '.'||l_stmt_num,
2412: ' Negative Value in Job of Cost element = 1');
2413: END IF;
2414: END IF;

Line 2458: -- Statement level log message for FND logging

2454: AND wppb.cost_type_id = p_cost_type_id
2455: AND wppb.wip_entity_id = p_entity_id
2456: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2457:
2458: -- Statement level log message for FND logging
2459: IF (l_sLog) THEN
2460: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2461: l_module || '.'||l_stmt_num,
2462: ' Negative Value in Job for Cost element = 2');

Line 2460: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2456: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2457:
2458: -- Statement level log message for FND logging
2459: IF (l_sLog) THEN
2460: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2461: l_module || '.'||l_stmt_num,
2462: ' Negative Value in Job for Cost element = 2');
2463: END IF;
2464: END IF;

Line 2508: -- Statement level log message for FND logging

2504: AND wppb.cost_type_id = p_cost_type_id
2505: AND wppb.wip_entity_id = p_entity_id
2506: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2507:
2508: -- Statement level log message for FND logging
2509: IF (l_sLog) THEN
2510: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2511: l_module || '.'||l_stmt_num,
2512: ' Negative Value in Job for Cost element = 3');

Line 2510: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2506: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2507:
2508: -- Statement level log message for FND logging
2509: IF (l_sLog) THEN
2510: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2511: l_module || '.'||l_stmt_num,
2512: ' Negative Value in Job for Cost element = 3');
2513: END IF;
2514: END IF;

Line 2558: -- Statement level log message for FND logging

2554: AND wppb.cost_type_id = p_cost_type_id
2555: AND wppb.wip_entity_id = p_entity_id
2556: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2557:
2558: -- Statement level log message for FND logging
2559: IF (l_sLog) THEN
2560: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2561: l_module || '.'||l_stmt_num,
2562: ' Negative Value in Job for Cost element = 4');

Line 2560: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2556: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2557:
2558: -- Statement level log message for FND logging
2559: IF (l_sLog) THEN
2560: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2561: l_module || '.'||l_stmt_num,
2562: ' Negative Value in Job for Cost element = 4');
2563: END IF;
2564: END IF;

Line 2608: -- Statement level log message for FND logging

2604: AND wppb.cost_type_id = p_cost_type_id
2605: AND wppb.wip_entity_id = p_entity_id
2606: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2607:
2608: -- Statement level log message for FND logging
2609: IF (l_sLog) THEN
2610: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2611: l_module || '.'||l_stmt_num,
2612: ' Negative Value in Job for Cost element = 5');

Line 2610: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2606: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2607:
2608: -- Statement level log message for FND logging
2609: IF (l_sLog) THEN
2610: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2611: l_module || '.'||l_stmt_num,
2612: ' Negative Value in Job for Cost element = 5');
2613: END IF;
2614: END IF;

Line 2617: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2613: END IF;
2614: END IF;
2615:
2616: IF (l_pLog) THEN
2617: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2618: l_module || '.end',
2619: l_api_name || ' >>>');
2620: END IF;
2621:

Line 2626: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

2622: EXCEPTION
2623: WHEN OTHERS THEN
2624: fnd_file.put_line(fnd_file.log,' Exception '||to_char(l_stmt_num));
2625: IF (l_uLog) THEN
2626: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2627: l_module || '.' || l_stmt_num,
2628: SQLERRM);
2629: END IF;
2630: ROLLBACK;

Line 2745: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

2741: l_api_name CONSTANT VARCHAR2(30) := 'process_net_relief';
2742: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2743: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2744:
2745: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2746: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2747: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2748: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2749: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 2746: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2742: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2743: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2744:
2745: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2746: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2747: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2748: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2749: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2750: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2747: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

2743: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2744:
2745: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2746: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2747: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2748: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2749: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2750: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2751:

Line 2748: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2744:
2745: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2746: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2747: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2748: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2749: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2750: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2751:
2752: BEGIN

Line 2749: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2745: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2746: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2747: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2748: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2749: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2750: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2751:
2752: BEGIN
2753:

Line 2750: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2746: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2747: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2748: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2749: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2750: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2751:
2752: BEGIN
2753:
2754: IF (l_pLog) THEN

Line 2755: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2751:
2752: BEGIN
2753:
2754: IF (l_pLog) THEN
2755: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2756: l_module || '.begin',
2757: l_api_name || ' <<<');
2758:
2759: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 2759: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2755: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2756: l_module || '.begin',
2757: l_api_name || ' <<<');
2758:
2759: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2760: l_module || '.begin',
2761: l_api_name || ' <<< Parameters:
2762: p_cost_layer_id = ' || p_cost_layer_id || '
2763: p_qty_layer_id = ' || p_qty_layer_id || '

Line 5328: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

5324: END LOOP; --assy_txn_loop
5325: END IF; -- check for p_scrap
5326:
5327: IF (l_pLog) THEN
5328: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
5329: l_module || '.end',
5330: l_api_name || ' >>>');
5331: END IF;
5332:

Line 5337: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

5333: EXCEPTION
5334:
5335: WHEN CST_PROCESS_ERROR THEN
5336: IF (l_exceptionLog) THEN
5337: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
5338: l_module || '.' || l_stmt_num,
5339: l_err_msg);
5340: END IF;
5341: x_err_num := l_err_num;

Line 5347: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

5343: x_err_msg := l_err_msg;
5344:
5345: WHEN OTHERS THEN
5346: IF (l_uLog) THEN
5347: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
5348: l_module || '.' || l_stmt_num,
5349: SQLERRM);
5350: END IF;
5351: ROLLBACK;

Line 5410: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

5406: l_api_name CONSTANT VARCHAR2(30) := 'process_nonreworkassembly_txns';
5407: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
5408: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5409:
5410: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5411: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5412: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5413: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5414: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 5411: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

5407: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
5408: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5409:
5410: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5411: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5412: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5413: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5414: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5415: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 5412: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

5408: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5409:
5410: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5411: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5412: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5413: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5414: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5415: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5416:

Line 5413: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

5409:
5410: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5411: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5412: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5413: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5414: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5415: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5416:
5417: ------------------------------------------------------------------------------

Line 5414: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

5410: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5411: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5412: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5413: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5414: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5415: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5416:
5417: ------------------------------------------------------------------------------
5418: -- All relieves are based on the concept of net relieves. i.e.

Line 5415: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

5411: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5412: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5413: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5414: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5415: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5416:
5417: ------------------------------------------------------------------------------
5418: -- All relieves are based on the concept of net relieves. i.e.
5419: -- Net Relief = Completion - Return

Line 5531: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

5527:
5528: BEGIN
5529:
5530: IF (l_pLog) THEN
5531: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
5532: l_module || '.begin',
5533: l_api_name || ' <<< Parameters:
5534: p_pac_period_id = ' || p_pac_period_id || '
5535: p_prior_period_id = ' || p_prior_period_id || '

Line 5846: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

5842: END IF;
5843: END IF;
5844:
5845: IF (l_pLog) THEN
5846: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
5847: l_module || '.end',
5848: l_api_name || ' >>>');
5849: END IF;
5850:

Line 5855: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

5851: EXCEPTION
5852:
5853: WHEN CST_PROCESS_ERROR THEN
5854: IF (l_exceptionLog) THEN
5855: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
5856: l_module || '.' || l_stmt_num,
5857: l_err_msg);
5858: END IF;
5859: x_err_num := l_err_num;

Line 5865: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

5861: x_err_msg := SUBSTR(l_err_msg,1,240);
5862:
5863: WHEN OTHERS THEN
5864: IF (l_uLog) THEN
5865: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
5866: l_module || '.' || l_stmt_num,
5867: SQLERRM);
5868: END IF;
5869: ROLLBACK;

Line 5928: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

5924: l_api_name CONSTANT VARCHAR2(30) := 'process_reworkassembly_txns';
5925: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
5926: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5927:
5928: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5929: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5930: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5931: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5932: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 5929: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

5925: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
5926: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5927:
5928: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5929: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5930: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5931: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5932: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5933: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 5930: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

5926: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5927:
5928: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5929: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5930: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5931: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5932: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5933: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5934:

Line 5931: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

5927:
5928: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5929: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5930: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5931: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5932: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5933: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5934:
5935: ------------------------------------------------------------------------------

Line 5932: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

5928: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5929: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5930: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5931: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5932: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5933: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5934:
5935: ------------------------------------------------------------------------------
5936: -- This cursor will get all the WIP Component txns where this item

Line 5933: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

5929: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5930: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5931: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5932: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5933: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5934:
5935: ------------------------------------------------------------------------------
5936: -- This cursor will get all the WIP Component txns where this item
5937: -- is issued to a WIP entity building itself.(Non Standard Job-Rework)

Line 6060: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

6056: BEGIN
6057:
6058: IF (l_pLog) THEN
6059:
6060: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
6061: l_module || '.begin',
6062: l_api_name || ' <<< Parameters:
6063: p_pac_period_id = ' || p_pac_period_id || '
6064: p_prior_period_id = ' || p_prior_period_id || '

Line 6513: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

6509: END IF;
6510: END IF;
6511:
6512: IF (l_pLog) THEN
6513: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
6514: l_module || '.end',
6515: l_api_name || ' >>>');
6516: END IF;
6517:

Line 6522: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

6518: EXCEPTION
6519:
6520: WHEN CST_PROCESS_ERROR THEN
6521: IF (l_exceptionLog) THEN
6522: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
6523: l_module || '.' || l_stmt_num,
6524: l_err_msg);
6525: END IF;
6526: x_err_num := l_err_num;

Line 6532: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

6528: x_err_msg := SUBSTR(l_err_msg,1,240);
6529:
6530: WHEN OTHERS THEN
6531: IF (l_uLog) THEN
6532: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
6533: l_module || '.' || l_stmt_num,
6534: SQLERRM);
6535: END IF;
6536: ROLLBACK;

Line 6574: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

6570: l_api_name CONSTANT VARCHAR2(30) := 'check_expense_flags';
6571: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
6572: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
6573:
6574: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
6575: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
6576: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
6577: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
6578: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 6575: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

6571: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
6572: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
6573:
6574: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
6575: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
6576: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
6577: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
6578: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
6579: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 6576: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

6572: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
6573:
6574: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
6575: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
6576: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
6577: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
6578: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
6579: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
6580:

Line 6577: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

6573:
6574: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
6575: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
6576: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
6577: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
6578: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
6579: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
6580:
6581: BEGIN

Line 6578: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

6574: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
6575: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
6576: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
6577: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
6578: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
6579: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
6580:
6581: BEGIN
6582:

Line 6579: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

6575: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
6576: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
6577: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
6578: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
6579: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
6580:
6581: BEGIN
6582:
6583: IF (l_pLog) THEN

Line 6584: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

6580:
6581: BEGIN
6582:
6583: IF (l_pLog) THEN
6584: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
6585: l_module || '.begin',
6586: l_api_name || ' <<< Parameters:
6587: p_item_id = ' || p_item_id );
6588:

Line 6634: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

6630: x_exp_item := l_exp_item;
6631: x_exp_flag := l_exp_flag;
6632:
6633: IF (l_pLog) THEN
6634: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
6635: l_module || '.end',
6636: l_api_name || ' >>>');
6637: END IF;
6638:

Line 6643: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

6639: EXCEPTION
6640:
6641: WHEN OTHERS THEN
6642: IF (l_uLog) THEN
6643: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
6644: l_module || '.' || l_stmt_num,
6645: SQLERRM);
6646: END IF;
6647: ROLLBACK;