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

Line 1354: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1350: x_warning_flag OUT NOCOPY VARCHAR2 ) IS
1351:
1352: -- CONSTANTS --
1353: -- API constants
1354: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1355: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 1355: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1351:
1352: -- CONSTANTS --
1353: -- API constants
1354: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1355: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1359: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

1352: -- CONSTANTS --
1353: -- API constants
1354: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1355: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1359: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1360: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

1353: -- API constants
1354: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1355: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1359: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1360: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1361: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_charge_line_util.convert_to_charge_lines';

Line 1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

1354: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1355: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1359: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1360: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1361: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_charge_line_util.convert_to_charge_lines';
1362: lc_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_CHARGE_LINES';

Line 1359: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

1355: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1359: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1360: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1361: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_charge_line_util.convert_to_charge_lines';
1362: lc_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_CHARGE_LINES';
1363: lc_api_version CONSTANT NUMBER := 1.0;

Line 1360: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1356: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1357: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1358: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1359: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1360: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1361: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_charge_line_util.convert_to_charge_lines';
1362: lc_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_CHARGE_LINES';
1363: lc_api_version CONSTANT NUMBER := 1.0;
1364:

Line 1460: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

1456: END IF;
1457:
1458: -- logging
1459: if (lc_proc_level >= lc_debug_level) then
1460: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
1461: 'Entering CSD_CHARGE_LINE_UTIL.convert_to_charge_lines');
1462: end if;
1463:
1464: -- log parameters

Line 1466: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1462: end if;
1463:
1464: -- log parameters
1465: if (lc_stat_level >= lc_debug_level) then
1466: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1467: 'p_api_version: ' || p_api_version);
1468: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1469: 'p_commit: ' || p_commit);
1470: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1468: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1464: -- log parameters
1465: if (lc_stat_level >= lc_debug_level) then
1466: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1467: 'p_api_version: ' || p_api_version);
1468: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1469: 'p_commit: ' || p_commit);
1470: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1471: 'p_init_msg_list: ' || p_init_msg_list);
1472: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1470: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1466: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1467: 'p_api_version: ' || p_api_version);
1468: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1469: 'p_commit: ' || p_commit);
1470: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1471: 'p_init_msg_list: ' || p_init_msg_list);
1472: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1473: 'p_validation_level: ' || p_validation_level);
1474: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1472: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1468: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1469: 'p_commit: ' || p_commit);
1470: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1471: 'p_init_msg_list: ' || p_init_msg_list);
1472: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1473: 'p_validation_level: ' || p_validation_level);
1474: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1475: 'p_est_act_module_code: ' || p_est_act_module_code);
1476: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1474: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1470: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1471: 'p_init_msg_list: ' || p_init_msg_list);
1472: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1473: 'p_validation_level: ' || p_validation_level);
1474: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1475: 'p_est_act_module_code: ' || p_est_act_module_code);
1476: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1477: 'p_est_act_msg_entity: ' || p_est_act_msg_entity);
1478: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1476: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1472: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1473: 'p_validation_level: ' || p_validation_level);
1474: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1475: 'p_est_act_module_code: ' || p_est_act_module_code);
1476: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1477: 'p_est_act_msg_entity: ' || p_est_act_msg_entity);
1478: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1479: 'p_charge_line_type: ' || p_charge_line_type);
1480: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1478: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1474: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1475: 'p_est_act_module_code: ' || p_est_act_module_code);
1476: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1477: 'p_est_act_msg_entity: ' || p_est_act_msg_entity);
1478: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1479: 'p_charge_line_type: ' || p_charge_line_type);
1480: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1481: 'p_repair_line_id: ' || p_repair_line_id);
1482: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1480: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1476: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1477: 'p_est_act_msg_entity: ' || p_est_act_msg_entity);
1478: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1479: 'p_charge_line_type: ' || p_charge_line_type);
1480: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1481: 'p_repair_line_id: ' || p_repair_line_id);
1482: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1483: 'p_repair_actual_id: ' || p_repair_actual_id);
1484: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1482: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1478: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1479: 'p_charge_line_type: ' || p_charge_line_type);
1480: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1481: 'p_repair_line_id: ' || p_repair_line_id);
1482: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1483: 'p_repair_actual_id: ' || p_repair_actual_id);
1484: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1485: 'p_repair_type_id: ' || p_repair_type_id);
1486: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1484: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1480: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1481: 'p_repair_line_id: ' || p_repair_line_id);
1482: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1483: 'p_repair_actual_id: ' || p_repair_actual_id);
1484: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1485: 'p_repair_type_id: ' || p_repair_type_id);
1486: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1487: 'p_business_process_id: ' || p_business_process_id);
1488: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1486: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1482: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1483: 'p_repair_actual_id: ' || p_repair_actual_id);
1484: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1485: 'p_repair_type_id: ' || p_repair_type_id);
1486: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1487: 'p_business_process_id: ' || p_business_process_id);
1488: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1489: 'p_currency_code: ' || p_currency_code);
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1488: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1484: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1485: 'p_repair_type_id: ' || p_repair_type_id);
1486: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1487: 'p_business_process_id: ' || p_business_process_id);
1488: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1489: 'p_currency_code: ' || p_currency_code);
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1491: 'p_incident_id: ' || p_incident_id);
1492: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1490: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1486: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1487: 'p_business_process_id: ' || p_business_process_id);
1488: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1489: 'p_currency_code: ' || p_currency_code);
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1491: 'p_incident_id: ' || p_incident_id);
1492: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1493: 'p_organization_id: ' || p_organization_id);
1494: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1492: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1488: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1489: 'p_currency_code: ' || p_currency_code);
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1491: 'p_incident_id: ' || p_incident_id);
1492: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1493: 'p_organization_id: ' || p_organization_id);
1494: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1495: 'p_price_list_id: ' || p_price_list_id);
1496: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 1494: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1490: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1491: 'p_incident_id: ' || p_incident_id);
1492: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1493: 'p_organization_id: ' || p_organization_id);
1494: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1495: 'p_price_list_id: ' || p_price_list_id);
1496: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1497: 'p_contract_line_id: ' || p_contract_line_id);
1498: end if;

Line 1496: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

1492: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1493: 'p_organization_id: ' || p_organization_id);
1494: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1495: 'p_price_list_id: ' || p_price_list_id);
1496: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
1497: 'p_contract_line_id: ' || p_contract_line_id);
1498: end if;
1499:
1500: -- Initialize API return status to success

Line 1512: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1508:
1509: -- Get the org id. It will be used later to derive
1510: -- line type id.
1511: if (lc_proc_level >= lc_debug_level) then
1512: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1513: 'Calling CSD_PROCESS_UTIL.get_org_id with p_incident_id = ' || p_incident_id);
1514: end if;
1515:
1516: l_org_id := CSD_PROCESS_UTIL.get_org_id( p_incident_id );

Line 1522: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1518: /* bug#3875036 */
1519: l_account_id := Get_SR_AccountId(p_repair_line_id);
1520:
1521: if (lc_proc_level >= lc_debug_level) then
1522: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1523: 'Returned from CSD_PROCESS_UTIL.get_org_id.'
1524: || ' l_org_id = ' || l_org_id);
1525: end if;
1526:

Line 1532: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1528: -- || l_org_id );
1529:
1530: IF ( l_org_id IS NULL ) THEN
1531: if (lc_proc_level >= lc_debug_level) then
1532: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1533: 'Could not determine the operating unit for'
1534: || ' p_incident_id = ' || p_incident_id);
1535: end if;
1536: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NO_OPER_UNIT');

Line 1549: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1545: -- is applicable to all lines.
1546: IF ( p_contract_line_id IS NOT NULL
1547: AND p_business_process_id IS NOT NULL ) THEN
1548: if (lc_proc_level >= lc_debug_level) then
1549: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1550: 'Calling CSD_CHARGE_LINE_UTIL.Get_CoverageInfo with '
1551: || 'p_contract_line_id = ' || p_contract_line_id
1552: || ' and p_business_process_id = ' || p_business_process_id);
1553: end if;

Line 1566: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1562: x_coverage_id => l_coverage_id,
1563: x_coverage_txn_group_id => l_coverage_txn_group_id );
1564:
1565: if (lc_proc_level >= lc_debug_level) then
1566: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1567: 'Returned from CSD_CHARGE_LINE_UTIL.Get_CoverageInfo with '
1568: || 'l_coverage_txn_group_id = ' || l_coverage_txn_group_id);
1569: end if;
1570:

Line 1578: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1574: -- IF ( l_coverage_txn_group_id IS NULL
1575: -- OR x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1576: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1577: if (lc_proc_level >= lc_debug_level) then
1578: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1579: 'Coverage information could not be determined for the contract and business process.');
1580: end if;
1581: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_UTIL_NO_COVG');
1582: -- Coverage information could not be determined for the contract and business process.

Line 1591: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1587:
1588: l_numRows := p_MLE_lines_tbl.COUNT;
1589:
1590: if (lc_stat_level >= lc_debug_level) then
1591: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1592: 'Begin LOOP through p_MLE_lines_tbl table');
1593: end if;
1594:
1595: FOR i IN 1..l_numRows LOOP

Line 1603: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1599: l_skip_curr_rec := FALSE;
1600: l_curr_inv_item := p_MLE_lines_tbl( i ).inventory_item_id;
1601:
1602: if (lc_stat_level >= lc_debug_level) then
1603: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1604: 'Processing item - id = ' || l_curr_inv_item
1605: || ' name = ' || p_MLE_lines_tbl( i ).item_name
1606: || ', for count = ' || i);
1607: end if;

Line 1616: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1612: IF ( p_MLE_lines_tbl( i ).quantity IS NULL
1613: OR p_MLE_lines_tbl( i ).quantity <= 0 ) THEN
1614: l_skip_curr_rec := TRUE;
1615: if (lc_stat_level >= lc_debug_level) then
1616: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1617: 'The transaction quantity value is either NULL or 0. '
1618: || 'p_MLE_lines_tbl( i ).quantity = ' || p_MLE_lines_tbl( i ).quantity);
1619: end if;
1620: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NEG_QTY');

Line 1635: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1631: IF ((l_last_inv_item IS NULL
1632: OR ( l_last_inv_item <> l_curr_inv_item )) AND NOT l_skip_curr_rec) THEN
1633:
1634: if (lc_stat_level >= lc_debug_level) then
1635: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1636: 'Current item being processed - id = ' || l_curr_inv_item
1637: || ' name = ' || p_MLE_lines_tbl( i ).item_name
1638: || ', for count = ' || i);
1639: end if;

Line 1650: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1646: -- The reason we put the following code in a plsql block
1647: -- is because the API throws an excetion when there is no success.
1648: BEGIN
1649: if (lc_proc_level >= lc_debug_level) then
1650: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1651: 'Calling CSD_PROCESS_UTIL.GET_CHARGE_SELLING_PRICE with'
1652: || ' p_inventory_item_id = ' || p_MLE_lines_tbl( i ).inventory_item_id
1653: || ' p_price_list_header_id = ' || p_price_list_id
1654: || ' p_unit_of_measure_code = ' || p_MLE_lines_tbl( i ).uom

Line 1675: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1671: x_msg_count => l_msg_count,
1672: x_msg_data => l_msg_data );
1673:
1674: if (lc_proc_level >= lc_debug_level) then
1675: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1676: 'Returned form CSD_PROCESS_UTIL.GET_CHARGE_SELLING_PRICE with'
1677: || ' l_unit_selling_price = ' || l_unit_selling_price);
1678: end if;
1679:

Line 1698: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1694: --DBMS_OUTPUT.put_line( 'NEW: The status is '
1695: -- || l_return_status );
1696:
1697: if (lc_proc_level >= lc_debug_level) then
1698: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1699: 'Inside EXC ERROR for the block calling CSD_PROCESS_UTIL.GET_CHARGE_SELLING_PRICE.');
1700: end if;
1701:
1702: l_skip_curr_rec := TRUE;

Line 1715: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1711: WHERE list_header_id = p_price_list_id;
1712: EXCEPTION
1713: WHEN NO_DATA_FOUND THEN
1714: if (lc_stat_level >= lc_debug_level) then
1715: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1716: 'Could not determine the price list name for p_price_list_id = ' || p_price_list_id);
1717: end if;
1718: --DBMS_OUTPUT.put_line( 'NEW: no data found' );
1719: l_price_list_name := p_price_list_id;

Line 1736: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1732:
1733: --DBMS_OUTPUT.put_line( 'NEW: after getting the selling price' );
1734:
1735: if (lc_stat_level >= lc_debug_level) then
1736: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1737: 'Checking if the Transaction Billing Type is null. '
1738: || 'p_MLE_lines_tbl(' || i || ').txn_billing_type_id = ' || p_MLE_lines_tbl( i ).txn_billing_type_id);
1739: end if;
1740:

Line 1747: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1743: IF ( p_MLE_lines_tbl( i ).txn_billing_type_id IS NULL ) THEN
1744: --DBMS_OUTPUT.put_line( 'NEW: txn bill type null' );
1745:
1746: if (lc_stat_level >= lc_debug_level) then
1747: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1748: 'Transaction billing type found to be NULL');
1749: end if;
1750:
1751: l_skip_curr_rec := TRUE;

Line 1760: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1756: ELSE
1757: --DBMS_OUTPUT.put_line( 'NEW: txn bill type is NOT NULL' );
1758:
1759: if (lc_stat_level >= lc_debug_level) then
1760: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1761: 'Transaction billing type is NOT NULL');
1762: end if;
1763:
1764: if (lc_proc_level >= lc_debug_level) then

Line 1765: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1761: 'Transaction billing type is NOT NULL');
1762: end if;
1763:
1764: if (lc_proc_level >= lc_debug_level) then
1765: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1766: 'Calling procedure CSD_PROCESS_UTIL.Get_No_Chg_Flag with '
1767: || 'p_MLE_lines_tbl( i ).txn_billing_type_id = ' || p_MLE_lines_tbl( i ).txn_billing_type_id);
1768: end if;
1769:

Line 1774: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1770: -- Check if the 'No Charge Flag' is checked for the txn billing type.
1771: l_no_charge_flag := CSD_PROCESS_UTIL.Get_No_Chg_Flag( p_MLE_lines_tbl( i ).txn_billing_type_id );
1772:
1773: if (lc_proc_level >= lc_debug_level) then
1774: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1775: 'Returned from procedure CSD_PROCESS_UTIL.Get_No_Chg_Flag with '
1776: || 'l_no_charge_flag = ' || l_no_charge_flag);
1777: end if;
1778:

Line 1794: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1790: l_line_type_id := NULL;
1791: l_line_category_code := NULL;
1792:
1793: if (lc_proc_level >= lc_debug_level) then
1794: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1795: 'Calling procedure CSD_PROCESS_UTIL.get_line_type with '
1796: || 'p_txn_billing_type_id = ' || p_MLE_lines_tbl( i ).txn_billing_type_id
1797: || ' and p_org_id = ' || l_org_id);
1798: end if;

Line 1808: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1804: x_line_category_code => l_line_category_code,
1805: x_return_status => l_return_status );
1806:
1807: if (lc_proc_level >= lc_debug_level) then
1808: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1809: 'Returned from procedure CSD_PROCESS_UTIL.get_line_type with '
1810: || 'x_line_type_id = ' || l_line_type_id
1811: || ', x_line_category_code = ' || l_line_category_code
1812: || ', x_return_status = ' || l_return_status);

Line 1868: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1864: --DBMS_OUTPUT.put_line( 'NEW: Inside the IB check' );
1865: l_num_subtypes := 0;
1866:
1867: if (lc_stat_level >= lc_debug_level) then
1868: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1869: 'Opening cursor count_csi_txn_subtypes using '
1870: || 'txn_billing_type_id = ' || p_MLE_lines_tbl( i ).txn_billing_type_id);
1871: end if;
1872:

Line 1879: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1875: FETCH count_csi_txn_subtypes INTO l_num_subtypes;
1876: CLOSE count_csi_txn_subtypes;
1877:
1878: if (lc_stat_level >= lc_debug_level) then
1879: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1880: 'Closed cursor count_csi_txn_subtypes. Value returned '
1881: || 'l_num_subtypes = ' || l_num_subtypes);
1882: end if;
1883:

Line 1920: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1916: THEN
1917: --DBMS_OUTPUT.put_line( 'NEW: To get the discouted price.' );
1918:
1919: if (lc_proc_level >= lc_debug_level) then
1920: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1921: 'Calling procedure CSD_CHARGE_LINE_UTIL.GET_DISCOUNTEDPRICE with values - '
1922: || 'p_contract_line_id = ' || p_contract_line_id
1923: || ', p_repair_type_id = ' || p_repair_type_id
1924: || ', p_txn_billing_type_id = ' || p_MLE_lines_tbl( i ).txn_billing_type_id

Line 1945: FND_LOG.STRING(lc_proc_level, lc_mod_name,

1941: x_msg_count => l_msg_count,
1942: x_msg_data => l_msg_data );
1943:
1944: if (lc_proc_level >= lc_debug_level) then
1945: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1946: 'Returned from procedure CSD_CHARGE_LINE_UTIL.GET_DISCOUNTEDPRICE with values - '
1947: || 'x_discounted_price = ' || l_discounted_price
1948: || ', x_return_status = ' || l_return_status);
1949: end if;

Line 2000: FND_LOG.STRING(lc_stat_level, lc_mod_name,

1996: -- This ensures that we always add a record for a new index.
1997: l_curRow := px_valid_MLE_lines_tbl.COUNT + 1;
1998:
1999: if (lc_stat_level >= lc_debug_level) then
2000: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2001: 'Current record# ' || l_curRow || ' is not skipped');
2002: end if;
2003:
2004: --DBMS_OUTPUT.put_line( 'NEW: Inside the valid loop '

Line 2097: FND_LOG.STRING(lc_stat_level, lc_mod_name,

2093:
2094: END LOOP;
2095:
2096: if (lc_stat_level >= lc_debug_level) then
2097: FND_LOG.STRING(lc_stat_level, lc_mod_name,
2098: 'End LOOP through p_MLE_lines_tbl table');
2099: end if;
2100:
2101: --

Line 2117: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

2113: END IF;-- Standard call to get message count and IF count is get message info.
2114:
2115: -- logging
2116: if (lc_proc_level >= lc_debug_level) then
2117: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
2118: 'Leaving CSD_CHARGE_LINE_UTIL.convert_to_charge_lines');
2119: end if;
2120:
2121: /*

Line 2136: FND_LOG.STRING(lc_excep_level, lc_mod_name,

2132: p_data => x_msg_data );
2133:
2134: -- save message in debug log
2135: IF (lc_excep_level >= lc_debug_level) THEN
2136: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2137: 'EXC_ERROR['||x_msg_data||']');
2138: END IF;
2139:
2140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2149: FND_LOG.STRING(lc_excep_level, lc_mod_name,

2145: p_data => x_msg_data );
2146:
2147: -- save message in debug log
2148: IF (lc_excep_level >= lc_debug_level) THEN
2149: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2150: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
2151: END IF;
2152:
2153: WHEN OTHERS THEN

Line 2167: FND_LOG.STRING(lc_excep_level, lc_mod_name,

2163: END IF;
2164:
2165: -- save message in debug log
2166: IF (lc_excep_level >= lc_debug_level) THEN
2167: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2168: 'WHEN OTHERS THEN. SQL Message['||SQLERRM||']');
2169: END IF;
2170:
2171: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_MLE_CHRG_FORMAT_ERR');