DBA Data[Home] [Help]

APPS.OKC_ARTICLES_IMPORT_GRP dependencies on FND_FLEX_VAL_API

Line 7342: IF Fnd_Flex_Val_Api.Valueset_Exists(vsinf_flex_value_set_name_tbl(i)) THEN

7338: -- this validation is not included in validate api
7339: -----------------------------------------------------------
7340: -- Check if value set already exists in the System
7341:
7342: IF Fnd_Flex_Val_Api.Valueset_Exists(vsinf_flex_value_set_name_tbl(i)) THEN
7343: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7344: p_msg_name => 'OKC_IMP_VALSET_EXIST',
7345: p_token1 => 'VALUESET',
7346: p_token1_value => vsinf_flex_value_set_name_tbl(i)

Line 7689: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');

7685: IF vsinf_action_tbl(i) = 'N' AND vsinf_process_status_tbl(i) in ('S','W') THEN
7686: IF vsinf_validation_type_tbl(i) = 'N' THEN
7687:
7688: -- Set the Session Mode
7689: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7690:
7691: -- Call the API to create value set
7692: FND_FLEX_VAL_API.CREATE_VALUESET_NONE(
7693: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),

Line 7692: FND_FLEX_VAL_API.CREATE_VALUESET_NONE(

7688: -- Set the Session Mode
7689: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7690:
7691: -- Call the API to create value set
7692: FND_FLEX_VAL_API.CREATE_VALUESET_NONE(
7693: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),
7694: DESCRIPTION => vsinf_description_tbl(i),
7695: SECURITY_AVAILABLE => 'N',
7696: ENABLE_LONGLIST => 'N',

Line 7709: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');

7705:
7706: ELSIF vsinf_validation_type_tbl(i) = 'I' THEN
7707:
7708: -- Set the Session Mode
7709: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7710:
7711: -- Call the API to create value set
7712: FND_FLEX_VAL_API.CREATE_VALUESET_INDEPENDENT(
7713: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),

Line 7712: FND_FLEX_VAL_API.CREATE_VALUESET_INDEPENDENT(

7708: -- Set the Session Mode
7709: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7710:
7711: -- Call the API to create value set
7712: FND_FLEX_VAL_API.CREATE_VALUESET_INDEPENDENT(
7713: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),
7714: DESCRIPTION => vsinf_description_tbl(i),
7715: SECURITY_AVAILABLE => 'N',
7716: ENABLE_LONGLIST => 'N',

Line 8414: IF NOT Fnd_Flex_Val_Api.Valueset_Exists(vinf_flex_value_set_name_tbl(i)) THEN

8410:
8411:
8412: IF vinf_action_tbl(i) = 'N' THEN
8413: -- Check if value set already exists in the System
8414: IF NOT Fnd_Flex_Val_Api.Valueset_Exists(vinf_flex_value_set_name_tbl(i)) THEN
8415: IF p_validate_only = 'N' THEN
8416: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8417: p_msg_name => 'OKC_VALSET_NOT_EXISTS',
8418: p_token1 => 'VALUE',

Line 8517: IF NOT Fnd_Flex_Val_Api.Valueset_Exists(vinf_flex_value_set_name_tbl(i)) THEN

8513: -----------------------------------------------------------
8514: IF vinf_action_tbl(i) = 'N' THEN
8515: /*
8516: -- Check if value set already exists in the System
8517: IF NOT Fnd_Flex_Val_Api.Valueset_Exists(vinf_flex_value_set_name_tbl(i)) THEN
8518: IF p_validate_only = 'N' THEN
8519: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8520: p_msg_name => 'OKC_VALSET_NOT_EXISTS',
8521: p_token1 => 'VALUE',

Line 8812: FND_FLEX_VAL_API.CREATE_INDEPENDENT_VSET_VALUE(

8808:
8809: IF vinf_action_tbl(i) = 'N' AND vinf_process_status_tbl(i) in ('S','W') THEN
8810:
8811:
8812: FND_FLEX_VAL_API.CREATE_INDEPENDENT_VSET_VALUE(
8813: P_FLEX_VALUE_SET_NAME => vinf_flex_value_set_name_tbl(i),
8814: P_FLEX_VALUE => vinf_flex_value_tbl(i),
8815: P_DESCRIPTION => vinf_description_tbl(i),
8816: P_ENABLED_FLAG => vinf_enabled_flag_tbl(i),

Line 8849: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE(

8845:
8846: IF vinf_action_tbl(i) = 'D' AND vinf_process_status_tbl(i) in ('S','W') THEN
8847:
8848:
8849: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE(
8850: P_FLEX_VALUE_SET_NAME => vinf_flex_value_set_name_tbl(i),
8851: P_FLEX_VALUE => vinf_flex_value_tbl(i),
8852: --P_DESCRIPTION => vinf_description_tbl(i),
8853: --P_ENABLED_FLAG => vinf_enabled_flag_tbl(i),