DBA Data[Home] [Help]

APPS.CN_RATE_DIMENSIONS_PVT dependencies on CN_API

Line 46: l_prompt := cn_api.get_lkup_meaning('DIMENSION_NAME', 'CN_PROMPTS');

42: --R12 MOAC Changes--End
43: BEGIN
44: IF (p_name IS NULL) THEN
45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: l_prompt := cn_api.get_lkup_meaning('DIMENSION_NAME', 'CN_PROMPTS');
47: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
48: fnd_message.set_token('OBJ_NAME', l_prompt);
49: fnd_msg_pub.ADD;
50: END IF;

Line 593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));

589: END IF;
590:
591: IF (p_dim_unit_code <> l_type_old) THEN
592: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TYPE_UPDATE');
593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));
594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));
595: l_note_msg := fnd_message.get;
596: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
597: /* jtf_notes_pub.create_note

Line 594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));

590:
591: IF (p_dim_unit_code <> l_type_old) THEN
592: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TYPE_UPDATE');
593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));
594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));
595: l_note_msg := fnd_message.get;
596: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
597: /* jtf_notes_pub.create_note
598: (p_api_version => 1.0,

Line 1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,

Line 1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

1054: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,

Line 1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,

1055: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start

Line 1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,

1056: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start
1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed

Line 1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,

1057: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start
1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
1065: -- R12 MOAC Changes --End

Line 1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,

1058: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := cn_api.g_miss_num,
1059: p_min_exp_id IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := cn_api.g_miss_num,
1060: p_max_exp_id IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := cn_api.g_miss_num,
1061: p_string_value IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := cn_api.g_miss_char,
1062: p_tier_sequence IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := cn_api.g_miss_num,
1063: -- R12 MOAC Changes --Start
1064: p_object_version_number IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE, --changed
1065: -- R12 MOAC Changes --End
1066: x_return_status OUT NOCOPY VARCHAR2 ,