DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on FND_PROFILE

Line 160: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then

156: End if;
157: End loop;
158:
159: If nvl(l_cust_acct_site_use,'N') = 'N' then
160: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
161: Open get_address;
162: Fetch get_address into l_bill_ship_addr;
163: Close get_address;
164:

Line 259: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then

255: fetch acct_site_csr into l_cust_acct_site_id;
256: IF acct_site_csr%NOTFOUND THEN
257: close acct_site_csr;
258: --srini
259: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
260: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
261: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
262: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
263: FND_MSG_PUB.Add;

Line 295: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then

291: fetch acct_site_use_csr into l_site_use_id;
292: IF acct_site_use_csr%NOTFOUND THEN
293: close acct_site_use_csr;
294: --srini
295: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
296: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
297: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
298: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
299: FND_MSG_PUB.Add;

Line 934: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then

930: RAISE FND_API.G_EXC_ERROR;
931: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: --srini
933: ELSIF l_acct_no = 0 then
934: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
935: Open Get_party_number;
936: Fetch Get_party_number into l_party_number;
937: Close Get_party_number;
938:

Line 948: l_modifier_line_id := fnd_profile.value_specific('CS_CHARGE_DEFAULT_MODIFIER');

944: END IF;
945:
946: -- Get modifier for OM adjustment lines
947: BEGIN
948: l_modifier_line_id := fnd_profile.value_specific('CS_CHARGE_DEFAULT_MODIFIER');
949: -- dbms_output.put_line('Default_Modifier' || l_modifier_line_id);
950: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
951: THEN
952: FND_LOG.String

Line 977: l_book_order_profile := fnd_profile.value('CS_CHG_CREATE_BOOKED_ORDERS');

973: -- Check the value of book_order_flag.Changes for 11.5.10
974: --
975: BEGIN
976:
977: l_book_order_profile := fnd_profile.value('CS_CHG_CREATE_BOOKED_ORDERS');
978: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
979: THEN
980: FND_LOG.String
981: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1521: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_LABOR_ITEM');

1517: WHERE ctbt.txn_billing_type_id = EstDtlTab(i).txn_billing_type_id
1518: AND ctbt.billing_type = cbtc.billing_type;
1519:
1520: IF l_billing_flag = 'L' THEN
1521: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_LABOR_ITEM');
1522: l_profile_option := 'CS_REPAIR_DEFAULT_LABOR_ITEM';
1523: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1524: THEN
1525: FND_LOG.String

Line 1531: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_MATERIAL_ITEM');

1527: , 'The Value of profile CS_REPAIR_DEFAULT_LABOR_ITEM :' || l_inv_item_id
1528: );
1529: END IF;
1530: ELSIF l_billing_flag = 'M' THEN
1531: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_MATERIAL_ITEM');
1532: l_profile_option := 'CS_REPAIR_DEFAULT_MATERIAL_ITEM';
1533: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1534: THEN
1535: FND_LOG.String

Line 1541: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_EXPENSE_ITEM');

1537: , 'The Value of profile CS_REPAIR_DEFAULT_MATERIAL_ITEM :' || l_inv_item_id
1538: );
1539: END IF;
1540: ELSIF l_billing_flag = 'E' THEN
1541: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_EXPENSE_ITEM');
1542: l_profile_option := 'CS_REPAIR_DEFAULT_EXPENSE_ITEM';
1543: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1544: THEN
1545: FND_LOG.String