DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on FND_API

Line 150: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

146: BEGIN
147:
148: --SAVEPOINT get_workstation_enabled;
149:
150: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
151: THEN
152: FND_MSG_PUB.initialize;
153: END IF;
154:

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

151: THEN
152: FND_MSG_PUB.initialize;
153: END IF;
154:
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: x_workstation_enabled := 'Y';
157:
158: l_org_id := p_organization_id;
159: l_line_id := p_line_id;

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

194: END IF;
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: x_workstation_enabled := 'N';
200: ROLLBACK TO get_workstation_enabled;
201:
202: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481: END IF;
482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486:
487: END get_custom_attributes;
488:
489:

Line 502: IF NOT FND_API.Compatible_API_Call

498: l_api_version_number CONSTANT NUMBER := 1.0;
499: l_api_name CONSTANT VARCHAR2(30) := 'Get_Attributes';
500:
501: BEGIN
502: IF NOT FND_API.Compatible_API_Call
503: ( l_api_version_number,
504: p_api_version_number,
505: l_api_name,
506: G_PKG_NAME)

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504: p_api_version_number,
505: l_api_name,
506: G_PKG_NAME)
507: THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510:
511: --Add custom code here
512: --Example

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: p_cust_attrib_tab(i).ATTRIBUTE_VALUE := 'Property'||to_char(i)||' Value';
516: END LOOP;
517: --End of custom code
518:
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521: -- Get message count and data
522: FND_MSG_PUB.Count_And_Get
523: ( p_count => x_msg_count,

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

524: p_data => x_msg_data
525: );
526:
527: EXCEPTION
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530:
531: -- Get message count and data
532: FND_MSG_PUB.Count_And_Get

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

525: );
526:
527: EXCEPTION
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530:
531: -- Get message count and data
532: FND_MSG_PUB.Count_And_Get
533: ( p_count => x_msg_count

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

534: , p_data => x_msg_data
535: );
536:
537: WHEN OTHERS THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME
542: , 'Get_Attribute'

Line 705: elsif(l_return_status = fnd_api.g_ret_sts_success) then

701: if(l_return_status = 'P') then
702: x_return_status := 'F';
703: elsif(l_return_status = 'N') then
704: x_return_status := 'F';
705: elsif(l_return_status = fnd_api.g_ret_sts_success) then
706: x_return_status := 'S';
707: else
708: x_return_status := 'S';
709: end if;

Line 880: p_commit => fnd_api.g_true,

876: l_lot_number := inv_lot_api_pub.auto_gen_lot(
877: p_org_id => p_org_id,
878: p_inventory_item_id => p_primary_item_id,
879: p_api_version => 1.0,
880: p_commit => fnd_api.g_true,
881: x_return_status => x_return_status,
882: x_msg_count => x_msg_count,
883: x_msg_data => x_msg_data);
884: if(x_return_status = 'S') then

Line 889: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

885: INV_LOT_API_PUB.InsertLot (
886: p_api_version => 1.0,
887: p_init_msg_list => 'F',
888: p_commit => 'T',
889: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
890: p_inventory_item_id => p_primary_item_id,
891: p_organization_id => p_org_id,
892: p_lot_number => l_lot_number,
893: p_expiration_date => l_exp_date,