DBA Data[Home] [Help]

APPS.CN_PLANCOPY_UTIL_PVT dependencies on FND_MESSAGE

Line 48: select fnd_message.get_string('CN','CN_COPY_MSG') into l_msg_copy from dual;

44: -- Formula Name : 30 characters
45: -- Scenario Name : 80 characters
46:
47: select substr(to_char(abs(dbms_random.random)),1,RAND_NUM_LENGTH) into l_unique_identifier from dual;
48: select fnd_message.get_string('CN','CN_COPY_MSG') into l_msg_copy from dual;
49:
50: -- Magic number 2 is for an underscore and 1 extra character
51:
52: l_length := RAND_NUM_LENGTH + 2 + LENGTHB(l_msg_copy);

Line 54: l_length_expscn := RAND_NUM_LENGTH + 2 + LENGTHB(fnd_message.get_string('CN','CN_PLANS'));

50: -- Magic number 2 is for an underscore and 1 extra character
51:
52: l_length := RAND_NUM_LENGTH + 2 + LENGTHB(l_msg_copy);
53:
54: l_length_expscn := RAND_NUM_LENGTH + 2 + LENGTHB(fnd_message.get_string('CN','CN_PLANS'));
55:
56: -- Whereever the length of column is 30 is present substr of 23 is used to accomadate to add an hyphen and 5 characters of unique string.
57:
58: if (p_type = 'PLAN') THEN

Line 77: x_name := l_obj_name || fnd_message.get_string('CN','CN_PLANS') || l_unique_identifier;

73: SELECT SUBSTRB(NAME,1,(80-l_length_expscn)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_scenarios_all where org_id = p_org_id and scenario_id = p_id;
74: END IF;
75:
76: if (p_type = 'EXPSCENARIO') THEN
77: x_name := l_obj_name || fnd_message.get_string('CN','CN_PLANS') || l_unique_identifier;
78: else
79: x_name := l_obj_name || '_'|| l_msg_copy || l_unique_identifier;
80: end if;
81: -- ******* End of API body. ********

Line 625: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

621: -- API body
622: IF (p_name IS NULL) THEN
623: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
624: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
625: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
626: fnd_message.set_token('OBJ_NAME', l_prompt);
627: fnd_msg_pub.ADD;
628: END IF;
629:

Line 626: fnd_message.set_token('OBJ_NAME', l_prompt);

622: IF (p_name IS NULL) THEN
623: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
624: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
625: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
626: fnd_message.set_token('OBJ_NAME', l_prompt);
627: fnd_msg_pub.ADD;
628: END IF;
629:
630: RAISE fnd_api.g_exc_error;

Line 639: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');

635: CLOSE exp_exists;
636:
637: IF (l_dummy = 1) THEN
638: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
639: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
640: fnd_msg_pub.ADD;
641: END IF;
642:
643: RAISE fnd_api.g_exc_error;