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 1165: IF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'SERVICE'

1161: fnd_file.put_line (fnd_file.LOG,
1162: 'OC INTERFACE :- party name ' || l_party_name
1163: );
1164:
1165: IF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'SERVICE'
1166: THEN
1167: l_line_rec.warranty_flag := 'S';
1168: l_covd_rec.warranty_flag := 'S';
1169: l_hdr_rec.scs_code := 'SERVICE';

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

1168: l_covd_rec.warranty_flag := 'S';
1169: l_hdr_rec.scs_code := 'SERVICE';
1170: l_hdr_rec.short_description :=
1171: 'CUSTOMER: ' || l_party_name || ' Contract';
1172: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'SUBSCRIPTION'
1173: THEN
1174: l_line_rec.warranty_flag := 'SU';
1175: l_hdr_rec.scs_code := 'SUBSCRIPTION';
1176: l_covd_rec.warranty_flag := 'SU';

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

1175: l_hdr_rec.scs_code := 'SUBSCRIPTION';
1176: l_covd_rec.warranty_flag := 'SU';
1177: l_hdr_rec.short_description :=
1178: 'CUSTOMER: ' || l_party_name || ' Contract';
1179: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'WARRANTY'
1180: OR fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') IS NULL
1181: THEN
1182: l_line_rec.warranty_flag := 'E';
1183: l_hdr_rec.scs_code := 'WARRANTY';

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

1176: l_covd_rec.warranty_flag := 'SU';
1177: l_hdr_rec.short_description :=
1178: 'CUSTOMER: ' || l_party_name || ' Contract';
1179: ELSIF fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') = 'WARRANTY'
1180: OR fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY') IS NULL
1181: THEN
1182: l_line_rec.warranty_flag := 'E';
1183: l_hdr_rec.scs_code := 'WARRANTY';
1184: l_covd_rec.warranty_flag := 'E';

Line 1201: IF l_hdr_scs_code <> fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY')

1197: INTO l_hdr_scs_code;
1198:
1199: CLOSE l_hdr_scs_csr;
1200:
1201: IF l_hdr_scs_code <> fnd_profile.VALUE ('OKS_CONTRACT_CATEGORY')
1202: THEN
1203: l_return_status := okc_api.g_ret_sts_error;
1204: --OKC_API.set_message(G_APP_NAME,'OKS_CONTRACT_CATEGORY','Cat',l_hdr_scs_code);
1205: fnd_message.set_name ('OKS', 'OKS_CONTRACT_CATEGORY');

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

1692:
1693: RAISE g_exception_halt_validation;
1694: END IF;
1695:
1696: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') =
1697: 'DISPLAY_NAME'
1698: THEN
1699: l_covd_rec.product_segment1 := l_cp_desc;
1700: l_covd_rec.product_desc := l_cp_name;

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

3078: fnd_file.put_line (fnd_file.LOG,
3079: 'Service line Id '
3080: || l_serv_ref_rec.service_reference_line_id
3081: );
3082: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile option value ' || Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') );
3083:
3084: /*
3085: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3086: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then

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

3081: );
3082: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile option value ' || Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') );
3083:
3084: /*
3085: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3086: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3087:
3088: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3089:

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

3082: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Profile option value ' || Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') );
3083:
3084: /*
3085: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') IN ('IB', 'MO') OR
3086: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3087:
3088: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3089:
3090: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then

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

3086: Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
3087:
3088: Okc_context.set_okc_org_context (l_order_rec.org_id, NULL );
3089:
3090: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
3091:
3092: l_organization_id := Null;
3093: If l_order_rec.sold_from_org_id Is Not Null Then
3094: Open l_organization_csr(l_order_rec.sold_from_org_id);

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

3099: End If;
3100:
3101: Okc_context.set_okc_org_context (l_order_rec.org_id, l_organization_id);
3102:
3103: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
3104:
3105: Okc_context.set_okc_org_context (l_order_rec.org_id, l_order_rec.ship_from_org_id);
3106:
3107: End If;

Line 3989: || fnd_profile.VALUE

3985: );
3986: fnd_file.put_line
3987: (fnd_file.LOG,
3988: 'Profile option value '
3989: || fnd_profile.VALUE
3990: ('OKS_CONTRACTS_VALIDATION_SOURCE')
3991: );
3992:
3993: OPEN check_ordline_exists (l_line_tbl (l_count).line_id);