APPS.OKC_ARTICLES_IMPORT_GRP dependencies on FND_FLEX_VAL_API

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

7270: -- this validation is not included in validate api
7271: -----------------------------------------------------------
7272: -- Check if value set already exists in the System
7273:
7274: IF Fnd_Flex_Val_Api.Valueset_Exists(vsinf_flex_value_set_name_tbl(i)) THEN
7275: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7276: p_msg_name => 'OKC_IMP_VALSET_EXIST',
7277: p_token1 => 'VALUESET',
7278: p_token1_value => vsinf_flex_value_set_name_tbl(i)

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

7617: IF vsinf_action_tbl(i) = 'N' AND vsinf_process_status_tbl(i) in ('S','W') THEN
7618: IF vsinf_validation_type_tbl(i) = 'N' THEN
7619:
7620: -- Set the Session Mode
7621: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7622:
7623: -- Call the API to create value set
7624: FND_FLEX_VAL_API.CREATE_VALUESET_NONE(
7625: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),

Line 7624: FND_FLEX_VAL_API.CREATE_VALUESET_NONE(

7620: -- Set the Session Mode
7621: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7622:
7623: -- Call the API to create value set
7624: FND_FLEX_VAL_API.CREATE_VALUESET_NONE(
7625: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),
7626: DESCRIPTION => vsinf_description_tbl(i),
7627: SECURITY_AVAILABLE => 'N',
7628: ENABLE_LONGLIST => 'N',

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

7637:
7638: ELSIF vsinf_validation_type_tbl(i) = 'I' THEN
7639:
7640: -- Set the Session Mode
7641: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7642:
7643: -- Call the API to create value set
7644: FND_FLEX_VAL_API.CREATE_VALUESET_INDEPENDENT(
7645: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),

Line 7644: FND_FLEX_VAL_API.CREATE_VALUESET_INDEPENDENT(

7640: -- Set the Session Mode
7641: FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');
7642:
7643: -- Call the API to create value set
7644: FND_FLEX_VAL_API.CREATE_VALUESET_INDEPENDENT(
7645: VALUE_SET_NAME => vsinf_flex_value_set_name_tbl(i),
7646: DESCRIPTION => vsinf_description_tbl(i),
7647: SECURITY_AVAILABLE => 'N',
7648: ENABLE_LONGLIST => 'N',

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

8342:
8343:
8344: IF vinf_action_tbl(i) = 'N' THEN
8345: -- Check if value set already exists in the System
8346: IF NOT Fnd_Flex_Val_Api.Valueset_Exists(vinf_flex_value_set_name_tbl(i)) THEN
8347: IF p_validate_only = 'N' THEN
8348: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8349: p_msg_name => 'OKC_VALSET_NOT_EXISTS',
8350: p_token1 => 'VALUE',

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

8445: -----------------------------------------------------------
8446: IF vinf_action_tbl(i) = 'N' THEN
8447: /*
8448: -- Check if value set already exists in the System
8449: IF NOT Fnd_Flex_Val_Api.Valueset_Exists(vinf_flex_value_set_name_tbl(i)) THEN
8450: IF p_validate_only = 'N' THEN
8451: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8452: p_msg_name => 'OKC_VALSET_NOT_EXISTS',
8453: p_token1 => 'VALUE',

Line 8744: FND_FLEX_VAL_API.CREATE_INDEPENDENT_VSET_VALUE(

8740:
8741: IF vinf_action_tbl(i) = 'N' AND vinf_process_status_tbl(i) in ('S','W') THEN
8742:
8743:
8744: FND_FLEX_VAL_API.CREATE_INDEPENDENT_VSET_VALUE(
8745: P_FLEX_VALUE_SET_NAME => vinf_flex_value_set_name_tbl(i),
8746: P_FLEX_VALUE => vinf_flex_value_tbl(i),
8747: P_DESCRIPTION => vinf_description_tbl(i),
8748: P_ENABLED_FLAG => vinf_enabled_flag_tbl(i),

Line 8781: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE(

8777:
8778: IF vinf_action_tbl(i) = 'D' AND vinf_process_status_tbl(i) in ('S','W') THEN
8779:
8780:
8781: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE(
8782: P_FLEX_VALUE_SET_NAME => vinf_flex_value_set_name_tbl(i),
8783: P_FLEX_VALUE => vinf_flex_value_tbl(i),
8784: --P_DESCRIPTION => vinf_description_tbl(i),
8785: --P_ENABLED_FLAG => vinf_enabled_flag_tbl(i),