DBA Data[Home] [Help]

APPS.OKS_OCINT_PUB dependencies on FND_PROFILE

Line 298: || fnd_profile.VALUE

294: );
295: fnd_file.put_line
296: (fnd_file.LOG,
297: 'Profile option value '
298: || fnd_profile.VALUE
299: ('OKS_CONTRACTS_VALIDATION_SOURCE')
300: );
301:
302: OPEN check_ordline_exists (l_line_tbl (l_count).line_id);

Line 1240: IF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'SERVICE'

1236: 'OC INTERFACE :- party name ' || l_party_name
1237: );
1238: /*Modified for ER 16039680 */
1239: IF l_k_line_rec.coverage_schd_id IS NOT NULL THEN
1240: IF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'SERVICE'
1241: THEN
1242: l_line_rec.warranty_flag := 'S';
1243: l_covd_rec.warranty_flag := 'S';
1244: l_hdr_rec.scs_code := 'SERVICE';

Line 1247: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'SUBSCRIPTION'

1243: l_covd_rec.warranty_flag := 'S';
1244: l_hdr_rec.scs_code := 'SERVICE';
1245: l_hdr_rec.short_description :=
1246: 'CUSTOMER: ' || l_party_name || ' Contract';
1247: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'SUBSCRIPTION'
1248: THEN
1249: l_line_rec.warranty_flag := 'SU';
1250: l_hdr_rec.scs_code := 'SUBSCRIPTION';
1251: l_covd_rec.warranty_flag := 'SU';

Line 1254: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'WARRANTY'

1250: l_hdr_rec.scs_code := 'SUBSCRIPTION';
1251: l_covd_rec.warranty_flag := 'SU';
1252: l_hdr_rec.short_description :=
1253: 'CUSTOMER: ' || l_party_name || ' Contract';
1254: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'WARRANTY'
1255: OR fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') IS NULL
1256: THEN
1257: l_line_rec.warranty_flag := 'E';
1258: l_hdr_rec.scs_code := 'WARRANTY';

Line 1255: OR fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') IS NULL

1251: l_covd_rec.warranty_flag := 'SU';
1252: l_hdr_rec.short_description :=
1253: 'CUSTOMER: ' || l_party_name || ' Contract';
1254: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'WARRANTY'
1255: OR fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') IS NULL
1256: THEN
1257: l_line_rec.warranty_flag := 'E';
1258: l_hdr_rec.scs_code := 'WARRANTY';
1259: l_covd_rec.warranty_flag := 'E';

Line 1345: IF l_hdr_scs_code <> l_hdr_rec.scs_code /* Commented for CLOUD ER fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') */

1341:
1342: CLOSE l_hdr_scs_csr;
1343:
1344: IF l_contract_item_type_code <> 'SUBSCRIPTION' THEN
1345: IF l_hdr_scs_code <> l_hdr_rec.scs_code /* Commented for CLOUD ER fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') */
1346: THEN
1347: l_return_status := okc_api.g_ret_sts_error;
1348: --OKC_API.set_message(G_APP_NAME,'OKS_CONTRACT_CATEGORY','Cat',l_hdr_scs_code);
1349: fnd_message.set_name ('OKS', 'OKS_CONTRACT_CATEGORY');

Line 1883: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') =

1879:
1880: RAISE g_exception_halt_validation;
1881: END IF;
1882:
1883: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') =
1884: 'DISPLAY_NAME'
1885: THEN
1886: l_covd_rec.product_segment1 := l_cp_desc;
1887: l_covd_rec.product_desc := l_cp_name;

Line 3726: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile option value ' || Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') );

3722: fnd_file.put_line (fnd_file.LOG,
3723: 'Service line Id '
3724: || l_serv_ref_rec.service_reference_line_id
3725: );
3726: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile option value ' || Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') );
3727:
3728: /*
3729: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3730: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then

Line 3729: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR

3725: );
3726: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile option value ' || Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') );
3727:
3728: /*
3729: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3730: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3731:
3732: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3733:

Line 3730: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then

3726: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile option value ' || Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') );
3727:
3728: /*
3729: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3730: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3731:
3732: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3733:
3734: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then

Line 3734: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then

3730: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3731:
3732: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3733:
3734: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
3735:
3736: l_organization_id := Null;
3737: If l_order_rec.sold_from_org_id Is Not Null Then
3738: Open l_organization_csr(l_order_rec.sold_from_org_id);

Line 3747: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then

3743: End If;
3744:
3745: Okc_context.set_okc_org_context (l_order_rec.org_id, l_organization_id);
3746:
3747: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
3748:
3749: Okc_context.set_okc_org_context (l_order_rec.org_id, l_order_rec.ship_from_org_id);
3750:
3751: End If;

Line 4633: || fnd_profile.VALUE

4629: );
4630: fnd_file.put_line
4631: (fnd_file.LOG,
4632: 'Profile option value '
4633: || fnd_profile.VALUE
4634: ('OKS_CONTRACTS_VALIDATION_SOURCE')
4635: );
4636:
4637: OPEN check_ordline_exists (l_line_tbl (l_count).line_id);