DBA Data[Home] [Help]

APPS.IEX_STRY_CUWF_PUB dependencies on FND_API

Line 286: l_init_msg_list := FND_API.G_FALSE;

282:
283: l_api_name := 'START_CUSTOMWF';
284: l_init_msg_list := p_init_msg_list;
285: if (p_init_msg_list is null ) then
286: l_init_msg_list := FND_API.G_FALSE;
287: end if;
288: l_commit := p_commit;
289: if (p_commit is null ) then
290: l_commit := FND_API.G_FALSE;

Line 290: l_commit := FND_API.G_FALSE;

286: l_init_msg_list := FND_API.G_FALSE;
287: end if;
288: l_commit := p_commit;
289: if (p_commit is null ) then
290: l_commit := FND_API.G_FALSE;
291: end if;
292: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
293:
294: SAVEPOINT START_CUSTOMWF_PUB;

Line 297: IF NOT FND_API.Compatible_API_Call (l_api_version,

293:
294: SAVEPOINT START_CUSTOMWF_PUB;
295:
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call (l_api_version,
298: p_api_version,
299: l_api_name,
300: G_PKG_NAME) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: IF NOT FND_API.Compatible_API_Call (l_api_version,
298: p_api_version,
299: l_api_name,
300: G_PKG_NAME) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: -- Check p_init_msg_list
305: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 305: IF FND_API.to_Boolean( l_init_msg_list ) THEN

301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: -- Check p_init_msg_list
305: IF FND_API.to_Boolean( l_init_msg_list ) THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308: -- IF PG_DEBUG < 10 THEN
309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
310: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'after init');
311: END IF;
312:
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: -- Check for required parameter p_strategy_id
316: IF (p_Custom_WF_rec.strategy_id IS NULL) OR
317: (p_Custom_WF_rec.strategy_id = FND_API.G_MISS_NUM) THEN

Line 317: (p_Custom_WF_rec.strategy_id = FND_API.G_MISS_NUM) THEN

313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: -- Check for required parameter p_strategy_id
316: IF (p_Custom_WF_rec.strategy_id IS NULL) OR
317: (p_Custom_WF_rec.strategy_id = FND_API.G_MISS_NUM) THEN
318: -- IF PG_DEBUG < 10 THEN
319: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
320: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'Required Parameter p_Custom_WF_rec.strategy_id is invalid');
321: END IF;

Line 325: RAISE FND_API.G_EXC_ERROR;

321: END IF;
322: AddMissingArgMsg(
323: p_api_name => l_api_name_full,
324: p_param_name => 'p_Custom_WF_rec.strategy_id' );
325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327: -- IF PG_DEBUG < 10 THEN
328: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
329: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'after p_Custom_WF_rec.strategy_id check');

Line 334: (p_Custom_WF_rec.workitem_id = FND_API.G_MISS_NUM) THEN

330: END IF;
331:
332: -- Check for required parameter p_workitem_id
333: IF (p_Custom_WF_rec.workitem_id IS NULL) OR
334: (p_Custom_WF_rec.workitem_id = FND_API.G_MISS_NUM) THEN
335: -- IF PG_DEBUG < 10 THEN
336: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
337: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'Required Parameter p_Custom_WF_rec.workitem_id is invalid');
338: END IF;

Line 342: RAISE FND_API.G_EXC_ERROR;

338: END IF;
339: AddMissingArgMsg(
340: p_api_name => l_api_name_full,
341: p_param_name => 'p_Custom_WF_rec.workitem_id' );
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344: -- IF PG_DEBUG < 10 THEN
345: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
346: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'after p_Custom_WF_rec.workitem_id check');

Line 352: (p_Custom_WF_rec.custom_itemtype = FND_API.G_MISS_CHAR) THEN

348:
349: -- Check for required parameter p_custom_itemtype
350: -- this is the work flow to be launched
351: IF (p_Custom_WF_rec.custom_itemtype IS NULL) OR
352: (p_Custom_WF_rec.custom_itemtype = FND_API.G_MISS_CHAR) THEN
353: -- IF PG_DEBUG < 10 THEN
354: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
355: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'Required Parameter p_Custom_WF_rec.custom_itemtype is invalid');
356: END IF;

Line 360: RAISE FND_API.G_EXC_ERROR;

356: END IF;
357: AddMissingArgMsg(
358: p_api_name => l_api_name_full,
359: p_param_name => 'p_Custom_WF_rec.custom_itemtype' );
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362: -- IF PG_DEBUG < 10 THEN
363: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
364: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'after p_Custom_WF_rec.custom_itemtype check');

Line 368: x_return_status := FND_API.G_RET_STS_SUCCESS;

364: IEX_DEBUG_PUB.LogMessage('populate_attributes: ' || 'after p_Custom_WF_rec.custom_itemtype check');
365: END IF;
366:
367:
368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369:
370: l_itemtype := p_Custom_WF_rec.custom_itemtype;
371: l_itemkey := p_Custom_WF_rec.workitem_id;
372:

Line 489: x_return_status := FND_API.G_RET_STS_SUCCESS;

485: status => l_ret_status,
486: result => l_result);
487:
488: if (l_ret_status in (wf_engine.eng_completed, wf_engine.eng_active )) THEN
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490: else
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: end if;
493: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 491: x_return_status := FND_API.G_RET_STS_ERROR;

487:
488: if (l_ret_status in (wf_engine.eng_completed, wf_engine.eng_active )) THEN
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490: else
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: end if;
493: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
494: iex_debug_pub.logmessage (' workflow return status = ' || l_return_status);
495: END IF;

Line 500: IF FND_API.To_Boolean(l_commit) THEN

496:
497:
498:
499: -- Standard check of p_commit
500: IF FND_API.To_Boolean(l_commit) THEN
501: COMMIT WORK;
502: END IF;
503:
504: -- Standard call to get message count and if count is 1, get message info

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
506:
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO START_CUSTOMWF_PUB;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513:

Line 511: x_return_status := FND_API.G_RET_STS_ERROR;

507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO START_CUSTOMWF_PUB;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: ROLLBACK TO START_CUSTOMWF_PUB;

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

510: ROLLBACK TO START_CUSTOMWF_PUB;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: ROLLBACK TO START_CUSTOMWF_PUB;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
518:

Line 516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: ROLLBACK TO START_CUSTOMWF_PUB;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
518:
519: WHEN OTHERS THEN
520: ROLLBACK TO START_CUSTOMWF_PUB;

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
518:
519: WHEN OTHERS THEN
520: ROLLBACK TO START_CUSTOMWF_PUB;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
523: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
524: END IF;
525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 601: p_commit => FND_API.G_TRUE,

597: if (l_work_item_id is not null) then
598:
599: iex_stry_utl_pub.update_work_item(
600: p_api_version => 1.0,
601: p_commit => FND_API.G_TRUE,
602: p_init_msg_list => FND_API.G_TRUE,
603: p_work_item_id => l_work_item_id,
604: p_status => 'COMPLETE',
605: x_return_status => l_return_status,

Line 602: p_init_msg_list => FND_API.G_TRUE,

598:
599: iex_stry_utl_pub.update_work_item(
600: p_api_version => 1.0,
601: p_commit => FND_API.G_TRUE,
602: p_init_msg_list => FND_API.G_TRUE,
603: p_work_item_id => l_work_item_id,
604: p_status => 'COMPLETE',
605: x_return_status => l_return_status,
606: x_msg_count => l_msg_count,

Line 610: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

606: x_msg_count => l_msg_count,
607: x_msg_data => l_msg_data
608: );
609:
610: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
611: iex_strategy_wf.send_signal(
612: process => 'IEXSTRY' ,
613: strategy_id => l_strategy_id,
614: status => 'COMPLETE',