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.CS_CHARGE_DETAILS_PVT dependencies on FND_PROFILE

Line 1307: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'

1303: where cip.party_id = p_party_id
1304: and cip.instance_id = cp.instance_id
1305: and cip.party_source_table = 'HZ_PARTIES')AND
1306: (
1307: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1308: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1309: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));
1310:
1311: lv_exists_flag VARCHAR2(1) := 'N';

Line 1309: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));

1305: and cip.party_source_table = 'HZ_PARTIES')AND
1306: (
1307: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1308: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1309: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));
1310:
1311: lv_exists_flag VARCHAR2(1) := 'N';
1312:
1313: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_instance_valid';

Line 5302: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');

5298: ELSE
5299: -- Business Process Id is null
5300: -- Get the Business Process Id from Service Request
5301: -- Check if the profile to get Business Process From SR = 'Y'
5302: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');
5303:
5304: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5305: THEN
5306: FND_LOG.String

Line 9393: l_profile_value := fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION');

9389: IF (p_charges_detail_rec.currency_code <> FND_API.G_MISS_CHAR AND
9390: p_charges_detail_rec.currency_code IS NOT NULL) AND
9391: (l_currency_code IS NOT NULL) AND
9392: (p_charges_detail_rec.currency_code <> l_currency_code) THEN
9393: l_profile_value := fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION');
9394: IF l_profile_value = 'Y' THEN
9395:
9396: CURR_IN_CONVERSION_LIST(
9397: p_api_name => l_api_name,

Line 9678: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9674: ELSIF p_charges_detail_rec.price_list_id IS NULL AND
9675: l_price_list_id IS NULL THEN
9676:
9677: --use the default from the price list
9678: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9679:
9680: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9681: THEN
9682: FND_LOG.String

Line 9864: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9860: ELSIF p_charges_detail_rec.price_list_id IS NULL AND
9861: l_price_list_id IS NULL THEN
9862:
9863: --use the default from the price list
9864: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9865:
9866: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9867: THEN
9868: FND_LOG.String

Line 9906: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9902:
9903: ELSE
9904: -- consider this as no contract exists
9905: IF p_charges_detail_rec.price_list_id IS NULL THEN
9906: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9907:
9908: -- get currency_code for the price_list_id
9909: GET_CURRENCY_CODE(
9910: p_api_name => l_api_name,

Line 9974: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

9970:
9971: ELSE
9972: --no contract exists
9973: IF p_charges_detail_rec.price_list_id IS NULL THEN
9974: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9975:
9976: -- get currency_code for the price_list_id
9977: GET_CURRENCY_CODE(
9978: p_api_name => l_api_name,

Line 10281: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

10277: p_charges_detail_rec.price_list_id = FND_API.G_MISS_NUM AND
10278: l_price_list_id IS NULL THEN
10279:
10280: --use the default from the price list
10281: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
10282:
10283: -- get currency_code for the price_list_id
10284: GET_CURRENCY_CODE(
10285: p_api_name => l_api_name,

Line 10387: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

10383: ELSE
10384:
10385: --get the default on the profile
10386: --use the default from the price list
10387: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
10388:
10389: -- get currency_code for the price_list_id
10390: GET_CURRENCY_CODE(
10391: p_api_name => l_api_name,

Line 10580: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

10576: ELSIF p_charges_detail_rec.price_list_id IS NULL AND
10577: l_price_list_id IS NULL THEN
10578:
10579: --use the default from the price list
10580: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
10581:
10582: -- get currency_code for the price_list_id
10583: GET_CURRENCY_CODE(
10584: p_api_name => l_api_name,

Line 10706: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

10702: END IF;
10703:
10704: ELSE
10705: --use the default from the price list
10706: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
10707:
10708: -- get currency_code for the price_list_id
10709: GET_CURRENCY_CODE(
10710: p_api_name => l_api_name,

Line 10800: x_charges_detail_rec.conversion_type_code := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');

10796: END IF;
10797: --assign values to out record for conversion_rate, conversion_type_code
10798: --conversion_rate_date
10799: x_charges_detail_rec.conversion_rate := l_rate;
10800: x_charges_detail_rec.conversion_type_code := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
10801: x_charges_detail_rec.conversion_rate_date := SYSDATE;
10802:
10803: ELSE
10804:

Line 12051: IF l_curr_in_conversion_list = 'Y' THEN --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' THEN --12.1.3 Multi Currency, vpremach

12047: --x_charges_detail_rec.billing_flag <> 'M' OR
12048: x_charges_detail_rec.billing_flag IN ('E','M', 'L') AND
12049: p_charges_detail_rec.after_warranty_cost IS NULL AND
12050: p_charges_detail_rec.list_price IS NULL THEN
12051: IF l_curr_in_conversion_list = 'Y' THEN --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' THEN --12.1.3 Multi Currency, vpremach
12052: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_NOT_BASE_CURRENCY');
12053: FND_MESSAGE.Set_Token('CURRENCY_CODE', p_charges_detail_rec.currency_code);
12054: FND_MSG_PUB.Add;
12055: RAISE FND_API.G_EXC_ERROR;

Line 12081: l_profile_value := fnd_profile.value('CS_SR_CHG_PRIC_DATE');

12077: l_absolute_quantity_required := x_charges_detail_rec.quantity_required;
12078: END IF;
12079: */
12080: -- Bug 7117553
12081: l_profile_value := fnd_profile.value('CS_SR_CHG_PRIC_DATE');
12082: If l_profile_value = 'CHG_INC_DATE' Then
12083: l_pricing_date := l_incident_date;
12084: Else
12085: l_pricing_date := sysdate;

Line 12362: IF l_curr_in_conversion_list = 'Y' THEN --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' THEN

12358: x_charges_detail_rec.source_code = 'SD' AND
12359: p_charges_detail_rec.after_warranty_cost IS NOT NULL THEN
12360:
12361: IF p_charges_detail_rec.list_price IS NULL THEN --12.1.3 Multi Currency, vpremach
12362: IF l_curr_in_conversion_list = 'Y' THEN --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' THEN
12363: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_NOT_BASE_CURRENCY');
12364: FND_MESSAGE.Set_Token('CURRENCY_CODE', p_charges_detail_rec.currency_code);
12365: FND_MSG_PUB.Add;
12366: RAISE FND_API.G_EXC_ERROR;

Line 12488: IF l_curr_in_conversion_list = 'Y' THEN --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' THEN

12484: x_charges_detail_rec.billing_flag IN ('E', 'M', 'L') AND
12485: p_charges_detail_rec.after_warranty_cost IS NOT NULL THEN
12486:
12487: IF p_charges_detail_rec.list_price IS NULL THEN --12.1.3 Multi Currency, vpremach
12488: IF l_curr_in_conversion_list = 'Y' THEN --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' THEN
12489: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_NOT_BASE_CURRENCY');
12490: FND_MESSAGE.Set_Token('CURRENCY_CODE', p_charges_detail_rec.currency_code);
12491: FND_MSG_PUB.Add;
12492: RAISE FND_API.G_EXC_ERROR;

Line 12650: IF l_curr_in_conversion_list = 'Y' --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' --12.1.3 Multi Currency, vpremach

12646: IF l_conversion_needed_flag = 'Y' THEN
12647:
12648: --assign coverted amt to after_warranty_cost
12649: x_charges_detail_rec.after_warranty_cost := x_charges_detail_rec.after_warranty_cost * x_charges_detail_rec.conversion_rate;
12650: IF l_curr_in_conversion_list = 'Y' --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' --12.1.3 Multi Currency, vpremach
12651: AND p_charges_detail_rec.list_price IS NOT NULL THEN
12652: x_charges_detail_rec.list_price := p_charges_detail_rec.list_price;
12653: ELSE
12654: x_charges_detail_rec.list_price := l_list_price;

Line 12668: IF l_curr_in_conversion_list = 'Y' --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' --12.1.3 Multi Currency, vpremach

12664:
12665: ELSE
12666:
12667: x_charges_detail_rec.after_warranty_cost := p_charges_detail_rec.after_warranty_cost;
12668: IF l_curr_in_conversion_list = 'Y' --AND fnd_profile.value('CS_ENABLE_CURRENCY_CONVERSION') = 'Y' --12.1.3 Multi Currency, vpremach
12669: AND p_charges_detail_rec.list_price IS NOT NULL THEN
12670: x_charges_detail_rec.list_price := p_charges_detail_rec.list_price;
12671: ELSE
12672: x_charges_detail_rec.list_price := l_list_price;

Line 13844: IF x_charges_detail_rec.line_category_code = 'ORDER' AND fnd_profile.value('CS_SR_EN_SHIP_SOUR_RULE') = 'Y' Then

13840: x_charges_detail_rec.shipping_method := null;
13841: x_charges_detail_rec.distance := null;
13842: x_charges_detail_rec.need_by_date := null;
13843:
13844: IF x_charges_detail_rec.line_category_code = 'ORDER' AND fnd_profile.value('CS_SR_EN_SHIP_SOUR_RULE') = 'Y' Then
13845:
13846: If x_charges_detail_rec.transaction_inventory_org is not Null AND x_charges_detail_rec.transaction_inventory_org <> FND_API.G_MISS_NUM THEN
13847:
13848: IF p_charges_detail_rec.transaction_sub_inventory IS NOT NULL AND p_charges_detail_rec.transaction_sub_inventory <> FND_API.G_MISS_CHAR Then

Line 14037: IF x_charges_detail_rec.line_category_code = 'ORDER' AND fnd_profile.value('CS_SR_EN_SHIP_SOUR_RULE') = 'Y' Then

14033: -- End If;
14034:
14035: ELSIF p_validation_mode = 'U' THEN
14036: -- bug 10404123
14037: IF x_charges_detail_rec.line_category_code = 'ORDER' AND fnd_profile.value('CS_SR_EN_SHIP_SOUR_RULE') = 'Y' Then
14038: If (x_charges_detail_rec.transaction_inventory_org is not Null AND x_charges_detail_rec.transaction_inventory_org <> FND_API.G_MISS_NUM) THEN
14039:
14040: IF (p_charges_detail_rec.transaction_sub_inventory IS NOT NULL AND p_charges_detail_rec.transaction_sub_inventory <> FND_API.G_MISS_CHAR) Then
14041:

Line 15951: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');

15947:
15948: l_api_name VARCHAR2(80) := 'CS_Charge_Details_PVT.Get_Conversion_Rate';
15949: l_api_name_full CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name ;
15950: l_log_module CONSTANT VARCHAR2(255) := 'cs.plsql.' || l_api_name_full || '.';
15951: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
15952: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
15953: lx_numerator NUMBER;
15954: lx_denominator NUMBER;
15955: lx_rate NUMBER;

Line 15952: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));

15948: l_api_name VARCHAR2(80) := 'CS_Charge_Details_PVT.Get_Conversion_Rate';
15949: l_api_name_full CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name ;
15950: l_log_module CONSTANT VARCHAR2(255) := 'cs.plsql.' || l_api_name_full || '.';
15951: l_conversion_type VARCHAR2(30) := FND_PROFILE.VALUE('CS_CHG_DEFAULT_CONVERSION_TYPE');
15952: l_max_roll_days NUMBER := to_number(FND_PROFILE.VALUE('CS_CHG_MAX_ROLL_DAYS'));
15953: lx_numerator NUMBER;
15954: lx_denominator NUMBER;
15955: lx_rate NUMBER;
15956:

Line 16314: If Nvl(fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT'),'N') = 'N' then

16310: lv_exists_flag VARCHAR2(1) := 'N';
16311:
16312: BEGIN
16313:
16314: If Nvl(fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT'),'N') = 'N' then
16315: FOR v_org_id IN c_org_id
16316: LOOP
16317: lv_exists_flag := 'Y';
16318: END LOOP;