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.

[Home] [Help]

APPS.CSTPPWAS dependencies on FND_LOG

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

2: /* $Header: CSTPWASB.pls 120.33 2007/11/13 19:09:25 vjavli 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 51: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

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

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

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

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

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

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

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

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

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

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

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

Line 62: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 130: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

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

Line 955: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

951: AND NVL(wppb.line_id,-99) = decode(wppb.wip_entity_type, 4, -99, NVL(p_line_id,-99));
952: END IF;
953:
954: IF (l_pLog) THEN
955: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
956: l_module || '.end',
957: l_api_name || ' >>>');
958: END IF;
959:

Line 963: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

959:
960: EXCEPTION
961: WHEN OTHERS THEN
962: IF (l_uLog) THEN
963: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
964: l_module || '.' || l_stmt_num,
965: SQLERRM);
966: END IF;
967: ROLLBACK;

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

1096: l_api_name CONSTANT VARCHAR2(30) := 'Relief_BOM_Quantity';
1097: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1098: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1099:
1100: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1101: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1102: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1103: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1104: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

1097: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1098: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1099:
1100: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1101: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1102: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1103: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1104: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1105: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

1098: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1099:
1100: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1101: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1102: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1103: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1104: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1105: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1106:

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

1099:
1100: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1101: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1102: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1103: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1104: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1105: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1106:
1107: BEGIN

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

1100: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1101: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1102: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1103: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1104: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1105: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1106:
1107: BEGIN
1108:

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

1101: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1102: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1103: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1104: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1105: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1106:
1107: BEGIN
1108:
1109: IF (l_pLog) THEN

Line 1111: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1107: BEGIN
1108:
1109: IF (l_pLog) THEN
1110:
1111: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1112: l_module || '.begin',
1113: l_api_name || ' <<< Parameters:
1114: p_pac_period_id = ' || p_pac_period_id || '
1115: p_prior_period_id = ' || p_prior_period_id || '

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

1243: l_op_relieved_comp_cost(i) := l_op_relieved_comp_cost(i) + l_current_period_cost * l_avl_relieve_qty;
1244: -- This is used to find out balance to be relieved from this job in this period
1245: l_job_balance(i) := l_job_balance(i) + l_current_period_cost * l_avl_relieve_qty;
1246:
1247: -- Statement level log message for FND logging
1248: IF (l_sLog) THEN
1249: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1250: l_module || '.'||l_stmt_num,
1251: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||

Line 1249: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1245: l_job_balance(i) := l_job_balance(i) + l_current_period_cost * l_avl_relieve_qty;
1246:
1247: -- Statement level log message for FND logging
1248: IF (l_sLog) THEN
1249: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1250: l_module || '.'||l_stmt_num,
1251: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||
1252: 'Component :' || comp_rec.component || ','||
1253: 'Cost Element :' || i || ','||

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

1330: -------------------------------------------------------------
1331: l_stmt_num := 70;
1332: l_required_qty := p_net_qty * comp_rec.quantity_per_assembly;
1333:
1334: -- Statement level log message for FND logging
1335: IF (l_sLog) THEN
1336: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1337: l_module || '.'||l_stmt_num,
1338: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||

Line 1336: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1332: l_required_qty := p_net_qty * comp_rec.quantity_per_assembly;
1333:
1334: -- Statement level log message for FND logging
1335: IF (l_sLog) THEN
1336: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1337: l_module || '.'||l_stmt_num,
1338: 'Operation Seq :' || op_seq_rec.operation_seq_num || ','||
1339: 'Component :' || comp_rec.component || ','||
1340: 'Cost Element :' || cstelement_rec.cst_ele_id || ','||

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

1387: -- For more Assembly returns than Assembly completions then sign of p_net_qty is negative.
1388: -- So making sign to opposite sign.
1389: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + l_avl_relieve_value * (-1);
1390:
1391: -- Statement level log message for FND logging
1392: IF (l_sLog) THEN
1393: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1394: l_module || '.'||l_stmt_num,
1395: 'l_avl_relieve_value :' || l_avl_relieve_value || ','||

Line 1393: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1389: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + l_avl_relieve_value * (-1);
1390:
1391: -- Statement level log message for FND logging
1392: IF (l_sLog) THEN
1393: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1394: l_module || '.'||l_stmt_num,
1395: 'l_avl_relieve_value :' || l_avl_relieve_value || ','||
1396: 'l_avl_relieve_qty :' || l_avl_relieve_qty || ','||
1397: 'l_op_relieved_comp_cost :' || l_op_relieved_comp_cost(cstelement_rec.cst_ele_id) || ','||

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

1461: (-1) * l_prior_relieved_value;
1462: -- This is used to find out balance to be relieved from this job in this period
1463: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + (-1) * l_prior_relieved_value;
1464:
1465: -- Statement level log message for FND logging
1466: IF (l_sLog) THEN
1467: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1468: l_module || '.'||l_stmt_num,
1469: 'l_assembly_return_cnt :' || l_assembly_return_cnt || ','||

Line 1467: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1463: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + (-1) * l_prior_relieved_value;
1464:
1465: -- Statement level log message for FND logging
1466: IF (l_sLog) THEN
1467: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1468: l_module || '.'||l_stmt_num,
1469: 'l_assembly_return_cnt :' || l_assembly_return_cnt || ','||
1470: 'l_prior_relieved_value :' || l_prior_relieved_value || ','||
1471: 'l_prior_relieved_comp_cost :' || l_prior_relieved_comp_cost(cstelement_rec.cst_ele_id) || ','||

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

1517: l_avl_relieve_value;
1518: -- This is used to find out balance to be relieved from this job in this period
1519: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + l_avl_relieve_value;
1520:
1521: -- Statement level log message for FND logging
1522: IF (l_sLog) THEN
1523: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1524: l_module || '.'||l_stmt_num,
1525: 'l_skip_below_process :' || l_skip_below_process || ','||

Line 1523: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1519: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + l_avl_relieve_value;
1520:
1521: -- Statement level log message for FND logging
1522: IF (l_sLog) THEN
1523: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1524: l_module || '.'||l_stmt_num,
1525: 'l_skip_below_process :' || l_skip_below_process || ','||
1526: 'l_avl_relieve_value :' || l_avl_relieve_value || ','||
1527: 'l_op_relieved_comp_cost :' || l_op_relieved_comp_cost(cstelement_rec.cst_ele_id) || ','||

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

1558: AND cprocd.operation_seq_num = op_seq_rec.operation_seq_num
1559: AND cprocd.inventory_item_id = comp_rec.component
1560: AND cprocd.cost_element_id = cstelement_rec.cst_ele_id;
1561:
1562: -- Statement level log message for FND logging
1563: IF (l_sLog) THEN
1564: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1565: l_module || '.'||l_stmt_num,
1566: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1564: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1560: AND cprocd.cost_element_id = cstelement_rec.cst_ele_id;
1561:
1562: -- Statement level log message for FND logging
1563: IF (l_sLog) THEN
1564: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1565: l_module || '.'||l_stmt_num,
1566: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1567: 'l_applied_qty :' || l_applied_qty || ','||
1568: 'l_avl_relieve_qty :' || l_avl_relieve_qty || ','||

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

1591: IF ( (l_required_qty > 0 AND l_applied_qty > l_required_qty) OR
1592: (l_required_qty < 0 AND l_applied_qty < l_required_qty)) THEN
1593:
1594: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
1595: -- Statement level log message for FND logging
1596: IF (l_sLog) THEN
1597: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1598: l_module || '.'||l_stmt_num,
1599: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1597: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1593:
1594: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
1595: -- Statement level log message for FND logging
1596: IF (l_sLog) THEN
1597: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1598: l_module || '.'||l_stmt_num,
1599: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1600: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1601: END IF;

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

1613: AND cpicd.cost_element_id = cstelement_rec.cst_ele_id;
1614:
1615: l_avl_relieve_value := l_current_period_cost * l_required_qty;
1616: l_avl_relieve_qty := l_required_qty;
1617: -- Statement level log message for FND logging
1618: IF (l_sLog) THEN
1619: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1620: l_module || '.'||l_stmt_num,
1621: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1619: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1615: l_avl_relieve_value := l_current_period_cost * l_required_qty;
1616: l_avl_relieve_qty := l_required_qty;
1617: -- Statement level log message for FND logging
1618: IF (l_sLog) THEN
1619: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1620: l_module || '.'||l_stmt_num,
1621: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1622: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1623: END IF;

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

1644: IF ( (l_required_qty > 0 AND l_applied_qty > l_required_qty) OR
1645: (l_required_qty < 0 AND l_applied_qty < l_required_qty)) THEN
1646:
1647: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
1648: -- Statement level log message for FND logging
1649: IF (l_sLog) THEN
1650: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1651: l_module || '.'||l_stmt_num,
1652: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1650: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1646:
1647: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
1648: -- Statement level log message for FND logging
1649: IF (l_sLog) THEN
1650: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1651: l_module || '.'||l_stmt_num,
1652: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1653: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1654: END IF;

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

1666:
1667: l_avl_relieve_value := (l_avl_relieve_value/l_avl_relieve_qty) * l_required_qty;
1668: l_avl_relieve_qty := l_required_qty;
1669:
1670: -- Statement level log message for FND logging
1671: IF (l_sLog) THEN
1672: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1673: l_module || '.'||l_stmt_num,
1674: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1672: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1668: l_avl_relieve_qty := l_required_qty;
1669:
1670: -- Statement level log message for FND logging
1671: IF (l_sLog) THEN
1672: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1673: l_module || '.'||l_stmt_num,
1674: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1675: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1676: END IF;

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

1696: l_avl_relieve_value := l_avl_relieve_value + (l_required_qty - l_avl_relieve_qty) *
1697: l_current_period_cost;
1698: l_avl_relieve_qty := l_required_qty;
1699:
1700: -- Statement level log message for FND logging
1701: IF (l_sLog) THEN
1702: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1703: l_module || '.'||l_stmt_num,
1704: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1702: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1698: l_avl_relieve_qty := l_required_qty;
1699:
1700: -- Statement level log message for FND logging
1701: IF (l_sLog) THEN
1702: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1703: l_module || '.'||l_stmt_num,
1704: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1705: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1706: END IF;

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

1727: IF ( (l_required_qty > 0 AND l_applied_qty > l_required_qty) OR
1728: (l_required_qty < 0 AND l_applied_qty < l_required_qty)) THEN
1729:
1730: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
1731: -- Statement level log message for FND logging
1732: IF (l_sLog) THEN
1733: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1734: l_module || '.'||l_stmt_num,
1735: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1733: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1729:
1730: l_avl_relieve_qty := l_applied_qty - l_relieved_qty;
1731: -- Statement level log message for FND logging
1732: IF (l_sLog) THEN
1733: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1734: l_module || '.'||l_stmt_num,
1735: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1736: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1737: END IF;

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

1753:
1754: l_avl_relieve_value := l_current_period_cost * l_required_qty;
1755: l_avl_relieve_qty := l_required_qty;
1756:
1757: -- Statement level log message for FND logging
1758: IF (l_sLog) THEN
1759: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1760: l_module || '.'||l_stmt_num,
1761: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1759: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1755: l_avl_relieve_qty := l_required_qty;
1756:
1757: -- Statement level log message for FND logging
1758: IF (l_sLog) THEN
1759: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1760: l_module || '.'||l_stmt_num,
1761: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1762: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1763: END IF;

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

1773: l_avl_relieve_value;
1774: -- This is used to find out balance to be relieved from this job in this period
1775: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + l_avl_relieve_value;
1776:
1777: -- Statement level log message for FND logging
1778: IF (l_sLog) THEN
1779: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1780: l_module || '.'||l_stmt_num,
1781: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1779: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1775: l_job_balance(cstelement_rec.cst_ele_id) := l_job_balance(cstelement_rec.cst_ele_id) + l_avl_relieve_value;
1776:
1777: -- Statement level log message for FND logging
1778: IF (l_sLog) THEN
1779: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1780: l_module || '.'||l_stmt_num,
1781: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1782: 'l_avl_relieve_qty :' || l_avl_relieve_qty);
1783: END IF;

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

1815: AND cprocd.cost_element_id = cstelement_rec.cst_ele_id
1816: AND cprocd.cost_group_id = p_cost_group_id
1817: AND cprocd.pac_period_id = p_pac_period_id;
1818:
1819: -- Statement level log message for FND logging
1820: IF (l_sLog) THEN
1821: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1822: l_module || '.'||l_stmt_num,
1823: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||

Line 1821: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1817: AND cprocd.pac_period_id = p_pac_period_id;
1818:
1819: -- Statement level log message for FND logging
1820: IF (l_sLog) THEN
1821: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1822: l_module || '.'||l_stmt_num,
1823: 'l_avl_relieve_value :' ||l_avl_relieve_value || ','||
1824: 'l_prior_relieved_value :' ||l_prior_relieved_value || ','||
1825: 'l_avl_relieve_qty :' || l_avl_relieve_qty);

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

1963: AND wppb.cost_type_id = p_cost_type_id
1964: AND wppb.wip_entity_id = p_entity_id
1965: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
1966:
1967: -- Statement level log message for FND logging
1968: IF (l_sLog) THEN
1969: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1970: l_module || '.'||l_stmt_num,
1971: ' Negative Value in Job of Cost element = 1');

Line 1969: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1965: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
1966:
1967: -- Statement level log message for FND logging
1968: IF (l_sLog) THEN
1969: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1970: l_module || '.'||l_stmt_num,
1971: ' Negative Value in Job of Cost element = 1');
1972: END IF;
1973: END IF;

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

2013: AND wppb.cost_type_id = p_cost_type_id
2014: AND wppb.wip_entity_id = p_entity_id
2015: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2016:
2017: -- Statement level log message for FND logging
2018: IF (l_sLog) THEN
2019: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2020: l_module || '.'||l_stmt_num,
2021: ' Negative Value in Job for Cost element = 2');

Line 2019: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2015: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2016:
2017: -- Statement level log message for FND logging
2018: IF (l_sLog) THEN
2019: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2020: l_module || '.'||l_stmt_num,
2021: ' Negative Value in Job for Cost element = 2');
2022: END IF;
2023: END IF;

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

2063: AND wppb.cost_type_id = p_cost_type_id
2064: AND wppb.wip_entity_id = p_entity_id
2065: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2066:
2067: -- Statement level log message for FND logging
2068: IF (l_sLog) THEN
2069: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2070: l_module || '.'||l_stmt_num,
2071: ' Negative Value in Job for Cost element = 3');

Line 2069: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2065: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2066:
2067: -- Statement level log message for FND logging
2068: IF (l_sLog) THEN
2069: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2070: l_module || '.'||l_stmt_num,
2071: ' Negative Value in Job for Cost element = 3');
2072: END IF;
2073: END IF;

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

2113: AND wppb.cost_type_id = p_cost_type_id
2114: AND wppb.wip_entity_id = p_entity_id
2115: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2116:
2117: -- Statement level log message for FND logging
2118: IF (l_sLog) THEN
2119: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2120: l_module || '.'||l_stmt_num,
2121: ' Negative Value in Job for Cost element = 4');

Line 2119: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2115: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2116:
2117: -- Statement level log message for FND logging
2118: IF (l_sLog) THEN
2119: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2120: l_module || '.'||l_stmt_num,
2121: ' Negative Value in Job for Cost element = 4');
2122: END IF;
2123: END IF;

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

2163: AND wppb.cost_type_id = p_cost_type_id
2164: AND wppb.wip_entity_id = p_entity_id
2165: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2166:
2167: -- Statement level log message for FND logging
2168: IF (l_sLog) THEN
2169: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2170: l_module || '.'||l_stmt_num,
2171: ' Negative Value in Job for Cost element = 5');

Line 2169: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

2165: AND nvl(wppb.line_id, -99) = nvl(p_line_id,-99);
2166:
2167: -- Statement level log message for FND logging
2168: IF (l_sLog) THEN
2169: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
2170: l_module || '.'||l_stmt_num,
2171: ' Negative Value in Job for Cost element = 5');
2172: END IF;
2173: END IF;

Line 2176: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2172: END IF;
2173: END IF;
2174:
2175: IF (l_pLog) THEN
2176: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2177: l_module || '.end',
2178: l_api_name || ' >>>');
2179: END IF;
2180:

Line 2185: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

2181: EXCEPTION
2182: WHEN OTHERS THEN
2183: fnd_file.put_line(fnd_file.log,' Exception '||to_char(l_stmt_num));
2184: IF (l_uLog) THEN
2185: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2186: l_module || '.' || l_stmt_num,
2187: SQLERRM);
2188: END IF;
2189: ROLLBACK;

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

2288: l_api_name CONSTANT VARCHAR2(30) := 'process_net_relief';
2289: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2290: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2291:
2292: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2293: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2294: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2295: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2296: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

2289: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2290: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2291:
2292: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2293: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2294: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2295: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2296: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2297: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

2290: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2291:
2292: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2293: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2294: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2295: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2296: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2297: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2298:

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

2291:
2292: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2293: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2294: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2295: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2296: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2297: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2298:
2299: BEGIN

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

2292: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2293: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2294: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2295: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2296: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2297: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2298:
2299: BEGIN
2300:

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

2293: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2294: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2295: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2296: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2297: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2298:
2299: BEGIN
2300:
2301: IF (l_pLog) THEN

Line 2302: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2298:
2299: BEGIN
2300:
2301: IF (l_pLog) THEN
2302: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2303: l_module || '.begin',
2304: l_api_name || ' <<<');
2305:
2306: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 2306: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2302: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2303: l_module || '.begin',
2304: l_api_name || ' <<<');
2305:
2306: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2307: l_module || '.begin',
2308: l_api_name || ' <<< Parameters:
2309: p_cost_layer_id = ' || p_cost_layer_id || '
2310: p_qty_layer_id = ' || p_qty_layer_id || '

Line 4244: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

4240: END LOOP; --assy_txn_loop
4241: END IF; -- check for p_scrap
4242:
4243: IF (l_pLog) THEN
4244: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
4245: l_module || '.end',
4246: l_api_name || ' >>>');
4247: END IF;
4248:

Line 4253: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

4249: EXCEPTION
4250:
4251: WHEN CST_PROCESS_ERROR THEN
4252: IF (l_exceptionLog) THEN
4253: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
4254: l_module || '.' || l_stmt_num,
4255: l_err_msg);
4256: END IF;
4257: x_err_num := l_err_num;

Line 4263: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

4259: x_err_msg := l_err_msg;
4260:
4261: WHEN OTHERS THEN
4262: IF (l_uLog) THEN
4263: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
4264: l_module || '.' || l_stmt_num,
4265: SQLERRM);
4266: END IF;
4267: ROLLBACK;

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

4322: l_api_name CONSTANT VARCHAR2(30) := 'process_nonreworkassembly_txns';
4323: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
4324: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
4325:
4326: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4327: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4328: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4329: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4330: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

4323: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
4324: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
4325:
4326: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4327: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4328: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4329: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4330: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4331: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

4324: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
4325:
4326: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4327: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4328: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4329: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4330: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4331: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4332:

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

4325:
4326: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4327: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4328: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4329: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4330: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4331: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4332:
4333: ------------------------------------------------------------------------------

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

4326: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4327: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4328: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4329: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4330: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4331: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4332:
4333: ------------------------------------------------------------------------------
4334: -- All relieves are based on the concept of net relieves. i.e.

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

4327: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4328: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4329: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4330: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4331: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4332:
4333: ------------------------------------------------------------------------------
4334: -- All relieves are based on the concept of net relieves. i.e.
4335: -- Net Relief = Completion - Return

Line 4471: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

4467:
4468: BEGIN
4469:
4470: IF (l_pLog) THEN
4471: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
4472: l_module || '.begin',
4473: l_api_name || ' <<< Parameters:
4474: p_pac_period_id = ' || p_pac_period_id || '
4475: p_prior_period_id = ' || p_prior_period_id || '

Line 4835: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

4831: END IF;
4832: END IF;
4833:
4834: IF (l_pLog) THEN
4835: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
4836: l_module || '.end',
4837: l_api_name || ' >>>');
4838: END IF;
4839:

Line 4844: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

4840: EXCEPTION
4841:
4842: WHEN CST_PROCESS_ERROR THEN
4843: IF (l_exceptionLog) THEN
4844: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
4845: l_module || '.' || l_stmt_num,
4846: l_err_msg);
4847: END IF;
4848: x_err_num := l_err_num;

Line 4854: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

4850: x_err_msg := SUBSTR(l_err_msg,1,240);
4851:
4852: WHEN OTHERS THEN
4853: IF (l_uLog) THEN
4854: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
4855: l_module || '.' || l_stmt_num,
4856: SQLERRM);
4857: END IF;
4858: ROLLBACK;

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

4913: l_api_name CONSTANT VARCHAR2(30) := 'process_reworkassembly_txns';
4914: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
4915: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
4916:
4917: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4918: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4919: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4920: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4921: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

4914: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
4915: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
4916:
4917: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4918: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4919: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4920: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4921: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4922: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

4915: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
4916:
4917: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4918: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4919: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4920: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4921: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4922: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4923:

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

4916:
4917: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4918: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4919: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4920: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4921: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4922: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4923:
4924: ------------------------------------------------------------------------------

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

4917: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
4918: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4919: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4920: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4921: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4922: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4923:
4924: ------------------------------------------------------------------------------
4925: -- This cursor will get all the WIP Component txns where this item

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

4918: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4919: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4920: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4921: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4922: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4923:
4924: ------------------------------------------------------------------------------
4925: -- This cursor will get all the WIP Component txns where this item
4926: -- is issued to a WIP entity building itself.(Non Standard Job-Rework)

Line 5049: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

5045: BEGIN
5046:
5047: IF (l_pLog) THEN
5048:
5049: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
5050: l_module || '.begin',
5051: l_api_name || ' <<< Parameters:
5052: p_pac_period_id = ' || p_pac_period_id || '
5053: p_prior_period_id = ' || p_prior_period_id || '

Line 5470: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

5466: END IF;
5467: END IF;
5468:
5469: IF (l_pLog) THEN
5470: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
5471: l_module || '.end',
5472: l_api_name || ' >>>');
5473: END IF;
5474:

Line 5479: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

5475: EXCEPTION
5476:
5477: WHEN CST_PROCESS_ERROR THEN
5478: IF (l_exceptionLog) THEN
5479: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
5480: l_module || '.' || l_stmt_num,
5481: l_err_msg);
5482: END IF;
5483: x_err_num := l_err_num;

Line 5489: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

5485: x_err_msg := SUBSTR(l_err_msg,1,240);
5486:
5487: WHEN OTHERS THEN
5488: IF (l_uLog) THEN
5489: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
5490: l_module || '.' || l_stmt_num,
5491: SQLERRM);
5492: END IF;
5493: ROLLBACK;

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

5527: l_api_name CONSTANT VARCHAR2(30) := 'check_expense_flags';
5528: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
5529: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5530:
5531: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5532: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5533: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5534: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5535: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

5528: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
5529: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5530:
5531: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5532: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5533: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5534: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5535: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5536: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

5529: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
5530:
5531: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5532: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5533: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5534: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5535: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5536: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5537:

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

5530:
5531: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5532: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5533: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5534: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5535: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5536: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5537:
5538: BEGIN

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

5531: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
5532: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5533: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5534: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5535: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5536: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5537:
5538: BEGIN
5539:

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

5532: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
5533: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
5534: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
5535: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
5536: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
5537:
5538: BEGIN
5539:
5540: IF (l_pLog) THEN

Line 5541: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

5537:
5538: BEGIN
5539:
5540: IF (l_pLog) THEN
5541: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
5542: l_module || '.begin',
5543: l_api_name || ' <<< Parameters:
5544: p_item_id = ' || p_item_id );
5545:

Line 5591: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

5587: x_exp_item := l_exp_item;
5588: x_exp_flag := l_exp_flag;
5589:
5590: IF (l_pLog) THEN
5591: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
5592: l_module || '.end',
5593: l_api_name || ' >>>');
5594: END IF;
5595:

Line 5600: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

5596: EXCEPTION
5597:
5598: WHEN OTHERS THEN
5599: IF (l_uLog) THEN
5600: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
5601: l_module || '.' || l_stmt_num,
5602: SQLERRM);
5603: END IF;
5604: ROLLBACK;