30: err number:=0;
31: BEGIN
32: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
33: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
34: FND_MESSAGE.SET_NAME('PSB'
35: ,'PSB_NO_DATA_FOUND');
36: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
37: FND_MESSAGE.SET_NAME('PSB'
38: ,'PSB_END_OF_REPORT');
32: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
33: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
34: FND_MESSAGE.SET_NAME('PSB'
35: ,'PSB_NO_DATA_FOUND');
36: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
37: FND_MESSAGE.SET_NAME('PSB'
38: ,'PSB_END_OF_REPORT');
39: CP_END_OF_REPORT := FND_MESSAGE.GET;
40:
33: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
34: FND_MESSAGE.SET_NAME('PSB'
35: ,'PSB_NO_DATA_FOUND');
36: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
37: FND_MESSAGE.SET_NAME('PSB'
38: ,'PSB_END_OF_REPORT');
39: CP_END_OF_REPORT := FND_MESSAGE.GET;
40:
41: FOR y1_rec IN Y1 LOOP
35: ,'PSB_NO_DATA_FOUND');
36: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
37: FND_MESSAGE.SET_NAME('PSB'
38: ,'PSB_END_OF_REPORT');
39: CP_END_OF_REPORT := FND_MESSAGE.GET;
40:
41: FOR y1_rec IN Y1 LOOP
42: CP_YEAR_NAME1 := Y1_REC.NAME;
43: END LOOP;
54: CP_YEAR_NAME4 := Y4_REC.NAME;
55: END LOOP;
56:
57: IF P_SERVICE_PACKAGE_ID IS NULL THEN
58: FND_MESSAGE.SET_NAME('PSB'
59: ,'PSB_ALL');
60: CP_PARAM_SP_NAME := FND_MESSAGE.GET;
61: ELSE
62: SELECT
56:
57: IF P_SERVICE_PACKAGE_ID IS NULL THEN
58: FND_MESSAGE.SET_NAME('PSB'
59: ,'PSB_ALL');
60: CP_PARAM_SP_NAME := FND_MESSAGE.GET;
61: ELSE
62: SELECT
63: NAME
64: INTO CP_PARAM_SP_NAME
88: AND ST.SEQUENCE_NUMBER = WS.CURRENT_STAGE_SEQ;
89: END IF;
90:
91: IF P_GLOBAL_WORKSHEET_ID IS NULL THEN
92: FND_MESSAGE.SET_NAME('PSB'
93: ,'PSB_ALL');
94: CP_PARAM_WS_NAME := FND_MESSAGE.GET;
95: ELSE
96: SELECT
90:
91: IF P_GLOBAL_WORKSHEET_ID IS NULL THEN
92: FND_MESSAGE.SET_NAME('PSB'
93: ,'PSB_ALL');
94: CP_PARAM_WS_NAME := FND_MESSAGE.GET;
95: ELSE
96: SELECT
97: NAME,
98: BUDGET_CALENDAR_ID