3: FUNCTION C_PRT_MESSAGE_NAMEFORMULA(MESSAGE_NAME IN VARCHAR2) RETURN CHAR IS
4: BEGIN
5: BEGIN
6: DECLARE
7: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8: BEGIN
9: IF LENGTH(MESSAGE_NAME) > 30 THEN
10: L_MESSAGE := MESSAGE_NAME;
11: ELSE
27: BEGIN
28: LP_STAT_DATE_FROM := TO_CHAR(P_STAT_DATE_FROM, 'DD-MON-YY');
29: LP_STAT_DATE_TO := TO_CHAR(P_STAT_DATE_TO, 'DD-MON-YY');
30: DECLARE
31: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
32: BEGIN
33: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
34: INIT_SECURITY;
35: BEGIN
125:
126: FUNCTION CF_LINE_COUNTFORMULA(BREAK_GROUP IN VARCHAR2) RETURN CHAR IS
127: BEGIN
128: DECLARE
129: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
130: L_MSG_NAME FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
131: BEGIN
132: IF C_PROFILE = 'XTR' THEN
133: IF BREAK_GROUP = 'B' THEN
126: FUNCTION CF_LINE_COUNTFORMULA(BREAK_GROUP IN VARCHAR2) RETURN CHAR IS
127: BEGIN
128: DECLARE
129: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
130: L_MSG_NAME FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
131: BEGIN
132: IF C_PROFILE = 'XTR' THEN
133: IF BREAK_GROUP = 'B' THEN
134: L_MSG_NAME := 'CE_ZBA_SUCCESS_COUNT';
156:
157: FUNCTION CF_1FORMULA(BREAK_GROUP IN VARCHAR2) RETURN CHAR IS
158: BEGIN
159: DECLARE
160: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
161: L_MSG_NAME FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
162: BEGIN
163: IF C_PROFILE = 'XTR' THEN
164: IF BREAK_GROUP = 'B' THEN
157: FUNCTION CF_1FORMULA(BREAK_GROUP IN VARCHAR2) RETURN CHAR IS
158: BEGIN
159: DECLARE
160: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
161: L_MSG_NAME FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
162: BEGIN
163: IF C_PROFILE = 'XTR' THEN
164: IF BREAK_GROUP = 'B' THEN
165: L_MSG_NAME := 'CE_ZBA_SUCCESS_MSG';