DBA Data[Home] [Help]

APPS.CSD_CHARGE_LINE_UTIL dependencies on FND_MESSAGE

Line 46: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');

42: END IF;
43:
44: EXCEPTION
45: WHEN no_data_found THEN
46: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');
47: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
48: FND_MSG_PUB.Add;
49: -- saupadhy 2826127
50: RETURN NULL ; -- RETURN -1

Line 47: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);

43:
44: EXCEPTION
45: WHEN no_data_found THEN
46: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');
47: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
48: FND_MSG_PUB.Add;
49: -- saupadhy 2826127
50: RETURN NULL ; -- RETURN -1
51:

Line 53: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');

49: -- saupadhy 2826127
50: RETURN NULL ; -- RETURN -1
51:
52: WHEN others THEN
53: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');
54: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
55: FND_MSG_PUB.Add;
56: -- saupadhy 2826127
57: RETURN NULL ; -- RETURN -1

Line 54: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);

50: RETURN NULL ; -- RETURN -1
51:
52: WHEN others THEN
53: FND_MESSAGE.SET_NAME('CSD','CSD_API_PL_CURR_CODE');
54: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
55: FND_MSG_PUB.Add;
56: -- saupadhy 2826127
57: RETURN NULL ; -- RETURN -1
58:

Line 441: FND_MESSAGE.SET_NAME('CSD','CSD_API_DEFAULT_CONTRACT');

437:
438: EXCEPTION
439:
440: WHEN others THEN
441: FND_MESSAGE.SET_NAME('CSD','CSD_API_DEFAULT_CONTRACT');
442: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
443: FND_MSG_PUB.Add;
444: RETURN -1;
445:

Line 442: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

438: EXCEPTION
439:
440: WHEN others THEN
441: FND_MESSAGE.SET_NAME('CSD','CSD_API_DEFAULT_CONTRACT');
442: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
443: FND_MSG_PUB.Add;
444: RETURN -1;
445:
446: END Get_DefaultContract;

Line 565: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_PL');

561:
562: EXCEPTION
563:
564: WHEN others THEN
565: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_PL');
566: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569:

Line 566: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);

562: EXCEPTION
563:
564: WHEN others THEN
565: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_PL');
566: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569:
570: END;

Line 948: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');

944:
945: EXCEPTION
946:
947: WHEN reqd_param_failed THEN
948: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');
949: FND_MESSAGE.SET_TOKEN('MISSING PARAM: PRICE_LIST_ID', p_price_list_id);
950: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_currency_code);
951: FND_MSG_PUB.Add;
952: RETURN NULL;

Line 949: FND_MESSAGE.SET_TOKEN('MISSING PARAM: PRICE_LIST_ID', p_price_list_id);

945: EXCEPTION
946:
947: WHEN reqd_param_failed THEN
948: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');
949: FND_MESSAGE.SET_TOKEN('MISSING PARAM: PRICE_LIST_ID', p_price_list_id);
950: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_currency_code);
951: FND_MSG_PUB.Add;
952: RETURN NULL;
953:

Line 950: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_currency_code);

946:
947: WHEN reqd_param_failed THEN
948: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');
949: FND_MESSAGE.SET_TOKEN('MISSING PARAM: PRICE_LIST_ID', p_price_list_id);
950: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_currency_code);
951: FND_MSG_PUB.Add;
952: RETURN NULL;
953:
954: WHEN others THEN

Line 955: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');

951: FND_MSG_PUB.Add;
952: RETURN NULL;
953:
954: WHEN others THEN
955: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');
956: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
957: FND_MSG_PUB.Add;
958: RETURN NULL;
959:

Line 956: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);

952: RETURN NULL;
953:
954: WHEN others THEN
955: FND_MESSAGE.SET_NAME('CSD','CSD_API_VALIDATE_PL');
956: FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
957: FND_MSG_PUB.Add;
958: RETURN NULL;
959:
960: END Validate_PriceList;

Line 1086: FND_MESSAGE.SET_NAME('CSD','CSD_API_DISCOUNTED_PRICE');

1082:
1083: EXCEPTION
1084:
1085: WHEN others THEN
1086: FND_MESSAGE.SET_NAME('CSD','CSD_API_DISCOUNTED_PRICE');
1087: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
1088: FND_MSG_PUB.Add;
1089: RAISE FND_API.G_EXC_ERROR;
1090:

Line 1087: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);

1083: EXCEPTION
1084:
1085: WHEN others THEN
1086: FND_MESSAGE.SET_NAME('CSD','CSD_API_DISCOUNTED_PRICE');
1087: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
1088: FND_MSG_PUB.Add;
1089: RAISE FND_API.G_EXC_ERROR;
1090:
1091: END;

Line 1294: FND_MESSAGE.SET_NAME('CSD', 'CSD_CHRG_UTIL_NO_COVG');

1290: csd_gen_utility_pvt.ADD ('Get_CoverageInfo: No coverage information found.');
1291: END IF;
1292:
1293: -- Log an error message.
1294: FND_MESSAGE.SET_NAME('CSD', 'CSD_CHRG_UTIL_NO_COVG');
1295: -- No coverage information found for contract and business process.
1296: FND_MSG_PUB.ADD;
1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1298: END IF;

Line 1536: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NO_OPER_UNIT');

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');
1537: -- Could not determine the operating unit. Operating unit is required to derive line types.
1538: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: END IF;

Line 1581: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_UTIL_NO_COVG');

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.
1583: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;

Line 1620: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NEG_QTY');

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');
1621: -- The net transactable quantity for the item $ITEM was found to be negative.
1622: -- The lines for the item will be ignored.
1623: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1624: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

Line 1623: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );

1619: end if;
1620: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NEG_QTY');
1621: -- The net transactable quantity for the item $ITEM was found to be negative.
1622: -- The lines for the item will be ignored.
1623: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1624: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1625: END IF;
1626:
1627: -- We derive/validate lots of values that depend just on the item.

Line 1727: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NOPRICE_ITEM_UOM' );

1723: --DBMS_OUTPUT.put_line( 'NEW: no data found' );
1724: l_price_list_name := p_price_list_id;
1725: END;
1726: END IF;
1727: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NOPRICE_ITEM_UOM' );
1728: -- Unable to determine selling price for the item $ITEM and unit of measure $UOM for the price list $PRICE_LIST.
1729: FND_MESSAGE.SET_TOKEN( 'ITEM',
1730: p_MLE_lines_tbl( i ).item_name );
1731: FND_MESSAGE.SET_TOKEN( 'PRICE_LIST', l_price_list_name );

Line 1729: FND_MESSAGE.SET_TOKEN( 'ITEM',

1725: END;
1726: END IF;
1727: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NOPRICE_ITEM_UOM' );
1728: -- Unable to determine selling price for the item $ITEM and unit of measure $UOM for the price list $PRICE_LIST.
1729: FND_MESSAGE.SET_TOKEN( 'ITEM',
1730: p_MLE_lines_tbl( i ).item_name );
1731: FND_MESSAGE.SET_TOKEN( 'PRICE_LIST', l_price_list_name );
1732: FND_MESSAGE.SET_TOKEN( 'UOM', p_MLE_lines_tbl( i ).uom );
1733: --DBMS_OUTPUT.put_line( 'NEW: before the message was added' );

Line 1731: FND_MESSAGE.SET_TOKEN( 'PRICE_LIST', l_price_list_name );

1727: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NOPRICE_ITEM_UOM' );
1728: -- Unable to determine selling price for the item $ITEM and unit of measure $UOM for the price list $PRICE_LIST.
1729: FND_MESSAGE.SET_TOKEN( 'ITEM',
1730: p_MLE_lines_tbl( i ).item_name );
1731: FND_MESSAGE.SET_TOKEN( 'PRICE_LIST', l_price_list_name );
1732: FND_MESSAGE.SET_TOKEN( 'UOM', p_MLE_lines_tbl( i ).uom );
1733: --DBMS_OUTPUT.put_line( 'NEW: before the message was added' );
1734: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1735: --DBMS_OUTPUT.put_line( 'NEW: after the message was added' );

Line 1732: FND_MESSAGE.SET_TOKEN( 'UOM', p_MLE_lines_tbl( i ).uom );

1728: -- Unable to determine selling price for the item $ITEM and unit of measure $UOM for the price list $PRICE_LIST.
1729: FND_MESSAGE.SET_TOKEN( 'ITEM',
1730: p_MLE_lines_tbl( i ).item_name );
1731: FND_MESSAGE.SET_TOKEN( 'PRICE_LIST', l_price_list_name );
1732: FND_MESSAGE.SET_TOKEN( 'UOM', p_MLE_lines_tbl( i ).uom );
1733: --DBMS_OUTPUT.put_line( 'NEW: before the message was added' );
1734: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1735: --DBMS_OUTPUT.put_line( 'NEW: after the message was added' );
1736: END;

Line 1757: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NO_ITEM_SAR' );

1753: 'Transaction billing type found to be NULL');
1754: end if;
1755:
1756: l_skip_curr_rec := TRUE;
1757: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NO_ITEM_SAR' );
1758: -- Unable to determine service activity billing type for the item $ITEM.
1759: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1760: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1761: ELSE

Line 1759: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );

1755:
1756: l_skip_curr_rec := TRUE;
1757: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_NO_ITEM_SAR' );
1758: -- Unable to determine service activity billing type for the item $ITEM.
1759: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1760: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1761: ELSE
1762: --DBMS_OUTPUT.put_line( 'NEW: txn bill type is NOT NULL' );
1763:

Line 1828: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_TYPE_MISS');

1824: IF ( l_line_type_id IS NULL
1825: OR l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1826: --DBMS_OUTPUT.put_line( 'NEW: inside the line_typeId NULL check.' );
1827: l_skip_curr_rec := TRUE;
1828: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_TYPE_MISS');
1829: -- Line type, for the current organization, has not been set for the item $ITEM. Check the service activity billing types set up.
1830: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1831: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1832: END IF;

Line 1830: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );

1826: --DBMS_OUTPUT.put_line( 'NEW: inside the line_typeId NULL check.' );
1827: l_skip_curr_rec := TRUE;
1828: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_TYPE_MISS');
1829: -- Line type, for the current organization, has not been set for the item $ITEM. Check the service activity billing types set up.
1830: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1831: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1832: END IF;
1833:
1834: --DBMS_OUTPUT.put_line( 'NEW: after line type id null check' );

Line 1840: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_CAT_MISS');

1836: IF ( l_line_category_code IS NULL
1837: OR l_line_category_code <> G_LINE_CATEGORY_CODE_ORDER ) THEN
1838: --DBMS_OUTPUT.put_line( 'NEW: inside line cat code null check' );
1839: l_skip_curr_rec := TRUE;
1840: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_CAT_MISS');
1841: -- Line category code, for the current organization, is either incorrect or not set for the item $ITEM. Check the service activity billing types set up.
1842: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1843: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1844: END IF;

Line 1842: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );

1838: --DBMS_OUTPUT.put_line( 'NEW: inside line cat code null check' );
1839: l_skip_curr_rec := TRUE;
1840: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_LINE_CAT_MISS');
1841: -- Line category code, for the current organization, is either incorrect or not set for the item $ITEM. Check the service activity billing types set up.
1842: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name );
1843: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1844: END IF;
1845: END IF;
1846:

Line 1893: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_IB_REQ' );

1889: --DBMS_OUTPUT.put_line( 'NEW: l_num_subtypes is ' || l_num_subtypes );
1890: --DBMS_OUTPUT.put_line( 'NEW: item is ' || p_MLE_lines_tbl( i ).inventory_item_id );
1891: IF ( l_num_subtypes > 0 ) THEN
1892: l_skip_curr_rec := TRUE;
1893: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_IB_REQ' );
1894: -- Instance number for the item $ITEM is required, based on it's service activity billing type set up.
1895: FND_MESSAGE.SET_TOKEN( 'ITEM',
1896: p_MLE_lines_tbl( i ).item_name );
1897: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

Line 1895: FND_MESSAGE.SET_TOKEN( 'ITEM',

1891: IF ( l_num_subtypes > 0 ) THEN
1892: l_skip_curr_rec := TRUE;
1893: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_IB_REQ' );
1894: -- Instance number for the item $ITEM is required, based on it's service activity billing type set up.
1895: FND_MESSAGE.SET_TOKEN( 'ITEM',
1896: p_MLE_lines_tbl( i ).item_name );
1897: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1898: END IF;
1899: END IF;

Line 1959: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_DISCOUNT_PRICE');

1955:
1956: IF (( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1957: OR ( l_discounted_price IS NULL )) THEN
1958: l_skip_curr_rec := TRUE;
1959: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_DISCOUNT_PRICE');
1960: -- There was an error while trying to get discount price for the item $ITEM using the contract $CONTRACT_NUMBER.
1961: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name);
1962: FND_MESSAGE.SET_TOKEN( 'CONTRACT_NUMBER', l_contract_number );
1963: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );

Line 1961: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name);

1957: OR ( l_discounted_price IS NULL )) THEN
1958: l_skip_curr_rec := TRUE;
1959: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_DISCOUNT_PRICE');
1960: -- There was an error while trying to get discount price for the item $ITEM using the contract $CONTRACT_NUMBER.
1961: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name);
1962: FND_MESSAGE.SET_TOKEN( 'CONTRACT_NUMBER', l_contract_number );
1963: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
1964: END IF;
1965: END IF;

Line 1962: FND_MESSAGE.SET_TOKEN( 'CONTRACT_NUMBER', l_contract_number );

1958: l_skip_curr_rec := TRUE;
1959: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_DISCOUNT_PRICE');
1960: -- There was an error while trying to get discount price for the item $ITEM using the contract $CONTRACT_NUMBER.
1961: FND_MESSAGE.SET_TOKEN( 'ITEM', p_MLE_lines_tbl( i ).item_name);
1962: FND_MESSAGE.SET_TOKEN( 'CONTRACT_NUMBER', l_contract_number );
1963: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
1964: END IF;
1965: END IF;
1966:

Line 1990: --FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');

1986: --
1987: -- give warning message that cost could not be determined?
1988: -- x_warning_flag := FND_API.G_TRUE;
1989: -- x_return_status := FND_API.G_RET_STS_ERROR;
1990: --FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
1991: --FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',px_charge_lines_tbl(l_curRow).contract_number);
1992: --FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1993: -- l_skip_curr_rec := TRUE;
1994: end if;

Line 1991: --FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',px_charge_lines_tbl(l_curRow).contract_number);

1987: -- give warning message that cost could not be determined?
1988: -- x_warning_flag := FND_API.G_TRUE;
1989: -- x_return_status := FND_API.G_RET_STS_ERROR;
1990: --FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
1991: --FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',px_charge_lines_tbl(l_curRow).contract_number);
1992: --FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
1993: -- l_skip_curr_rec := TRUE;
1994: end if;
1995: */

Line 2176: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_MLE_CHRG_FORMAT_ERR');

2172: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2173: 'WHEN OTHERS THEN. SQL Message['||SQLERRM||']');
2174: END IF;
2175:
2176: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_MLE_CHRG_FORMAT_ERR');
2177: -- Encountered an error while converting MLE lines into charge line format. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2178: FND_MESSAGE.set_token('SQLCODE' , SQLCODE);
2179: FND_MESSAGE.set_token('SQLERRM' , SQLERRM);
2180: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );

Line 2178: FND_MESSAGE.set_token('SQLCODE' , SQLCODE);

2174: END IF;
2175:
2176: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_MLE_CHRG_FORMAT_ERR');
2177: -- Encountered an error while converting MLE lines into charge line format. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2178: FND_MESSAGE.set_token('SQLCODE' , SQLCODE);
2179: FND_MESSAGE.set_token('SQLERRM' , SQLERRM);
2180: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
2181: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2182: p_data => x_msg_data );

Line 2179: FND_MESSAGE.set_token('SQLERRM' , SQLERRM);

2175:
2176: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_CHRG_MLE_CHRG_FORMAT_ERR');
2177: -- Encountered an error while converting MLE lines into charge line format. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2178: FND_MESSAGE.set_token('SQLCODE' , SQLCODE);
2179: FND_MESSAGE.set_token('SQLERRM' , SQLERRM);
2180: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_ERROR_MSG );
2181: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2182: p_data => x_msg_data );
2183: END Convert_To_Charge_Lines;