DBA Data[Home] [Help]

APPS.ZPB_EXTERNAL_BP_PUBLISH dependencies on FND_API

Line 130: X_return_status := FND_API.G_RET_STS_ERROR ;

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:
134:

Line 142: X_return_status := FND_API.G_RET_STS_ERROR ;

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:
146: -- 3. is the requestor authorised

Line 153: X_return_status := FND_API.G_RET_STS_ERROR ;

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:
157: --l_override_user_check := 'Y';

Line 165: X_return_status := FND_API.G_RET_STS_ERROR ;

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;
169:

Line 178: X_return_status := FND_API.G_RET_STS_ERROR ;

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;
182: ELSE

Line 196: X_return_status := FND_API.G_RET_STS_ERROR ;

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;
200: ELSE

Line 218: X_return_status := FND_API.G_RET_STS_ERROR ;

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: --
222: --

Line 244: P_INIT_MSG_LIST => FND_API.G_TRUE,

240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');
241: -- ZPB_AW.EXECUTE('aw aliaslist ' || l_dataaw || ' alias SHARED');
242:
243: ZPB_AW.INITIALIZE (P_API_VERSION => 1.0,
244: P_INIT_MSG_LIST => FND_API.G_TRUE,
245: X_RETURN_STATUS => x_return_status,
246: X_MSG_COUNT => x_msg_count,
247: X_MSG_DATA => errbuf,
248: P_BUSINESS_AREA_ID => l_busArea,

Line 249: P_SHARED_RW => FND_API.G_FALSE);

245: X_RETURN_STATUS => x_return_status,
246: X_MSG_COUNT => x_msg_count,
247: X_MSG_DATA => errbuf,
248: P_BUSINESS_AREA_ID => l_busArea,
249: P_SHARED_RW => FND_API.G_FALSE);
250:
251: is_attached := 'Y';
252:
253:

Line 309: X_return_status := FND_API.G_RET_STS_ERROR ;

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;
313:

Line 326: X_return_status := FND_API.G_RET_STS_ERROR ;

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;
330: -- end b5015702

Line 347: p_init_msg_list => FND_API.G_TRUE,

343:
344: --dbms_output.put_line('l_start_lvl=' || l_start_lvl);
345: zpb_acval_pvt.val_solve_hrzselections(
346: p_api_version => 1.0,
347: p_init_msg_list => FND_API.G_TRUE,
348: p_commit => FND_API.G_FALSE,
349: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
350: x_return_status => x_return_status,
351: x_msg_count => x_msg_count ,

Line 348: p_commit => FND_API.G_FALSE,

344: --dbms_output.put_line('l_start_lvl=' || l_start_lvl);
345: zpb_acval_pvt.val_solve_hrzselections(
346: p_api_version => 1.0,
347: p_init_msg_list => FND_API.G_TRUE,
348: p_commit => FND_API.G_FALSE,
349: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
350: x_return_status => x_return_status,
351: x_msg_count => x_msg_count ,
352: x_msg_data => x_msg_data ,

Line 349: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

345: zpb_acval_pvt.val_solve_hrzselections(
346: p_api_version => 1.0,
347: p_init_msg_list => FND_API.G_TRUE,
348: p_commit => FND_API.G_FALSE,
349: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
350: x_return_status => x_return_status,
351: x_msg_count => x_msg_count ,
352: x_msg_data => x_msg_data ,
353: p_analysis_cycle_id => l_published_id,

Line 361: X_return_status := FND_API.G_RET_STS_ERROR ;

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;
365:

Line 378: p_init_msg_list => FND_API.G_TRUE,

374:
375: --dbms_output.put_line('l_end_lvl=' || l_end_lvl);
376: zpb_acval_pvt.val_solve_hrzselections(
377: p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_TRUE,
379: p_commit => FND_API.G_FALSE,
380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
381: x_return_status => x_return_status,
382: x_msg_count => x_msg_count ,

Line 379: p_commit => FND_API.G_FALSE,

375: --dbms_output.put_line('l_end_lvl=' || l_end_lvl);
376: zpb_acval_pvt.val_solve_hrzselections(
377: p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_TRUE,
379: p_commit => FND_API.G_FALSE,
380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
381: x_return_status => x_return_status,
382: x_msg_count => x_msg_count ,
383: x_msg_data => x_msg_data ,

Line 380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

376: zpb_acval_pvt.val_solve_hrzselections(
377: p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_TRUE,
379: p_commit => FND_API.G_FALSE,
380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
381: x_return_status => x_return_status,
382: x_msg_count => x_msg_count ,
383: x_msg_data => x_msg_data ,
384: p_analysis_cycle_id => l_published_id,

Line 391: X_return_status := FND_API.G_RET_STS_ERROR ;

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;
395:

Line 430: x_return_status := FND_API.G_RET_STS_SUCCESS;

426:
427: -- b4594118 23Sep05 reset caller credentials
428: fnd_global.apps_initialize(l_user, l_respID, l_respAppID);
429:
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431: commit;
432: exception
433: WHEN OTHERS THEN
434: CLEANUP(l_codeaw , l_dataaw);

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

431: commit;
432: exception
433: WHEN OTHERS THEN
434: CLEANUP(l_codeaw , l_dataaw);
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: X_MSG_data := SUBSTR(sqlerrm, 1, 255);
437:
438: end START_BUSINESS_PROCESS;
439: