eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_EXTERNAL_BP_PUBLISH dependencies on FND_MESSAGE

Line 128: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_API_BA_REQUIRED');

124: select count(BUSINESS_AREA_ID) into l_count
125: from zPB_BUSINESS_AREAS_VL where name = p_ba_name;
126:
127: IF (P_ba_name IS NULL) or (l_count = 0) then
128: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_API_BA_REQUIRED');
129: X_MSG_data := FND_MESSAGE.GET;
130: X_return_status := FND_API.G_RET_STS_ERROR ;
131: return;
132: end if;

Line 129: X_MSG_data := FND_MESSAGE.GET;

125: from zPB_BUSINESS_AREAS_VL where name = p_ba_name;
126:
127: IF (P_ba_name IS NULL) or (l_count = 0) then
128: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_API_BA_REQUIRED');
129: X_MSG_data := FND_MESSAGE.GET;
130: X_return_status := FND_API.G_RET_STS_ERROR ;
131: return;
132: end if;
133:

Line 140: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_OR_UNPUB_BP');

136: OPEN c_publ_id;
137: FETCH c_publ_id INTO l_published_id, l_busArea, l_owner;
138: CLOSE c_publ_id;
139: IF (l_published_id IS NULL) THEN
140: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_OR_UNPUB_BP');
141: X_MSG_data := FND_MESSAGE.GET;
142: X_return_status := FND_API.G_RET_STS_ERROR ;
143: return;
144: END IF;

Line 141: X_MSG_data := FND_MESSAGE.GET;

137: FETCH c_publ_id INTO l_published_id, l_busArea, l_owner;
138: CLOSE c_publ_id;
139: IF (l_published_id IS NULL) THEN
140: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_OR_UNPUB_BP');
141: X_MSG_data := FND_MESSAGE.GET;
142: X_return_status := FND_API.G_RET_STS_ERROR ;
143: return;
144: END IF;
145:

Line 151: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_OR_UNPUB_BP');

147: OPEN c_bp_external;
148: FETCH c_bp_external INTO l_override_user_check;
149: CLOSE c_bp_external;
150: IF (l_override_user_check IS NULL) THEN
151: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_OR_UNPUB_BP');
152: X_MSG_data := FND_MESSAGE.GET;
153: X_return_status := FND_API.G_RET_STS_ERROR ;
154: return;
155: END IF;

Line 152: X_MSG_data := FND_MESSAGE.GET;

148: FETCH c_bp_external INTO l_override_user_check;
149: CLOSE c_bp_external;
150: IF (l_override_user_check IS NULL) THEN
151: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_OR_UNPUB_BP');
152: X_MSG_data := FND_MESSAGE.GET;
153: X_return_status := FND_API.G_RET_STS_ERROR ;
154: return;
155: END IF;
156:

Line 163: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_EXTERNAL_USER');

159: SELECT COUNT(*) INTO l_user_exists FROM ZPB_BP_EXTERNAL_USERS
160: WHERE analysis_cycle_id = l_published_id
161: AND user_id = l_user;
162: IF (l_user_exists = 0) THEN
163: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_EXTERNAL_USER');
164: X_MSG_data := FND_MESSAGE.GET;
165: X_return_status := FND_API.G_RET_STS_ERROR ;
166: return;
167: END IF;

Line 164: X_MSG_data := FND_MESSAGE.GET;

160: WHERE analysis_cycle_id = l_published_id
161: AND user_id = l_user;
162: IF (l_user_exists = 0) THEN
163: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INV_EXTERNAL_USER');
164: X_MSG_data := FND_MESSAGE.GET;
165: X_return_status := FND_API.G_RET_STS_ERROR ;
166: return;
167: END IF;
168: END IF;

Line 177: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_CANT_OVERIDE_REL_STIME');

173: CLOSE c_horzstart_type;
174: IF (l_hs_type = l_time_relative) THEN
175: --dbms_output.put_line(' l_time_relative');
176: IF ( P_horizon_start IS NOT NULL) THEN
177: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_CANT_OVERIDE_REL_STIME');
178: X_return_status := FND_API.G_RET_STS_ERROR ;
179: X_MSG_data := FND_MESSAGE.GET;
180: return;
181: END IF;

Line 179: X_MSG_data := FND_MESSAGE.GET;

175: --dbms_output.put_line(' l_time_relative');
176: IF ( P_horizon_start IS NOT NULL) THEN
177: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_CANT_OVERIDE_REL_STIME');
178: X_return_status := FND_API.G_RET_STS_ERROR ;
179: X_MSG_data := FND_MESSAGE.GET;
180: return;
181: END IF;
182: ELSE
183: --dbms_output.put_line(' l_time_fixed');

Line 195: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_CANT_OVERIDE_REL_ETIME');

191: FETCH c_horzend_type INTO l_he_type;
192: CLOSE c_horzend_type;
193: IF (l_he_type = l_time_relative) THEN
194: IF (P_horizon_end IS NOT NULL) THEN
195: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_CANT_OVERIDE_REL_ETIME');
196: X_return_status := FND_API.G_RET_STS_ERROR ;
197: X_MSG_data := FND_MESSAGE.GET;
198: return;
199: END IF;

Line 197: X_MSG_data := FND_MESSAGE.GET;

193: IF (l_he_type = l_time_relative) THEN
194: IF (P_horizon_end IS NOT NULL) THEN
195: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_CANT_OVERIDE_REL_ETIME');
196: X_return_status := FND_API.G_RET_STS_ERROR ;
197: X_MSG_data := FND_MESSAGE.GET;
198: return;
199: END IF;
200: ELSE
201: OPEN c_horzend_mem;

Line 216: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_API_BEFORE_START');

212:
213: --if start date is greater than sysdate the start date has not been reached.
214: if to_date(l_bp_start, 'YYYY/MM/DD HH24:MI:SS') - SYSDATE > 0 then
215: -- x_msg_data := 'The Business Process cannot be run yet because the start date has not been reached';
216: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_API_BEFORE_START');
217: X_MSG_data := FND_MESSAGE.GET;
218: X_return_status := FND_API.G_RET_STS_ERROR ;
219: return;
220: end if;

Line 217: X_MSG_data := FND_MESSAGE.GET;

213: --if start date is greater than sysdate the start date has not been reached.
214: if to_date(l_bp_start, 'YYYY/MM/DD HH24:MI:SS') - SYSDATE > 0 then
215: -- x_msg_data := 'The Business Process cannot be run yet because the start date has not been reached';
216: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_API_BEFORE_START');
217: X_MSG_data := FND_MESSAGE.GET;
218: X_return_status := FND_API.G_RET_STS_ERROR ;
219: return;
220: end if;
221: --

Line 307: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INVALID_DATES');

303: --dbms_output.put_line('X_start_member=' || X_start_member);
304: --dbms_output.put_line('X_end_member=' || X_end_member);
305:
306: IF ((p_horizon_start IS NOT NULL AND X_start_member is null) OR (p_horizon_end IS NOT NULL AND X_end_member is null)) then
307: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INVALID_DATES');
308: X_MSG_data := FND_MESSAGE.GET;
309: X_return_status := FND_API.G_RET_STS_ERROR ;
310: CLEANUP(l_codeaw , l_dataaw);
311: return;

Line 308: X_MSG_data := FND_MESSAGE.GET;

304: --dbms_output.put_line('X_end_member=' || X_end_member);
305:
306: IF ((p_horizon_start IS NOT NULL AND X_start_member is null) OR (p_horizon_end IS NOT NULL AND X_end_member is null)) then
307: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INVALID_DATES');
308: X_MSG_data := FND_MESSAGE.GET;
309: X_return_status := FND_API.G_RET_STS_ERROR ;
310: CLEANUP(l_codeaw , l_dataaw);
311: return;
312: END IF;

Line 324: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INVALID_DATES');

320: --dbms_output.put_line(' l_olap_call=' || l_olap_call);
321: l_isvalid := ZPB_AW.INTERPBOOL (l_olap_call );
322:
323: IF NOT(l_isvalid) THEN
324: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INVALID_DATES');
325: X_MSG_data := FND_MESSAGE.GET;
326: X_return_status := FND_API.G_RET_STS_ERROR ;
327: CLEANUP(l_codeaw , l_dataaw);
328: return;

Line 325: X_MSG_data := FND_MESSAGE.GET;

321: l_isvalid := ZPB_AW.INTERPBOOL (l_olap_call );
322:
323: IF NOT(l_isvalid) THEN
324: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INVALID_DATES');
325: X_MSG_data := FND_MESSAGE.GET;
326: X_return_status := FND_API.G_RET_STS_ERROR ;
327: CLEANUP(l_codeaw , l_dataaw);
328: return;
329: END IF;

Line 359: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_HRZSLV_LEVELS_VALID_MSG');

355: x_isvalid => l_valid
356: );
357:
358: IF (l_valid = 'N') THEN
359: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_HRZSLV_LEVELS_VALID_MSG');
360: X_MSG_data := FND_MESSAGE.GET;
361: X_return_status := FND_API.G_RET_STS_ERROR ;
362: CLEANUP(l_codeaw , l_dataaw);
363: return;

Line 360: X_MSG_data := FND_MESSAGE.GET;

356: );
357:
358: IF (l_valid = 'N') THEN
359: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_HRZSLV_LEVELS_VALID_MSG');
360: X_MSG_data := FND_MESSAGE.GET;
361: X_return_status := FND_API.G_RET_STS_ERROR ;
362: CLEANUP(l_codeaw , l_dataaw);
363: return;
364: END IF;

Line 389: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_HRZSLV_LEVELS_VALID_MSG');

385: p_hrz_level => l_end_lvl,
386: x_isvalid => l_valid
387: );
388: IF (l_valid = 'N') THEN
389: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_HRZSLV_LEVELS_VALID_MSG');
390: X_MSG_data := FND_MESSAGE.GET;
391: X_return_status := FND_API.G_RET_STS_ERROR ;
392: CLEANUP(l_codeaw , l_dataaw);
393: return;

Line 390: X_MSG_data := FND_MESSAGE.GET;

386: x_isvalid => l_valid
387: );
388: IF (l_valid = 'N') THEN
389: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_HRZSLV_LEVELS_VALID_MSG');
390: X_MSG_data := FND_MESSAGE.GET;
391: X_return_status := FND_API.G_RET_STS_ERROR ;
392: CLEANUP(l_codeaw , l_dataaw);
393: return;
394: END IF;