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. ********