APPS.GMD_RECIPE_DATA_PUB dependencies on FND_API

Line 8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'gmd_recipe_data_pub';
5:
6: PROCEDURE get_recipe_data
7: ( p_api_version IN NUMBER ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9: p_recipe_id IN NUMBER ,
10: p_organization_id IN NUMBER DEFAULT NULL ,
11: p_date IN DATE DEFAULT NULL , --Bug 4479101
12: x_return_status OUT NOCOPY VARCHAR2 ,

Line 30: p_return_status VARCHAR2(100) := FND_API.G_RET_STS_SUCCESS;

26: IS
27:
28:
29: /* local Variable*/
30: p_return_status VARCHAR2(100) := FND_API.G_RET_STS_SUCCESS;
31: lrecord_type gmdfmval_pub.formula_info_in;
32: x_recipe_id gmd_recipes.recipe_id%TYPE ;
33: x_routing_id fm_rout_hdr.routing_id%TYPE ;
34: l_return_status VARCHAR2(1);

Line 130: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

126:
127: END IF;
128:
129:
130: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
131: x_return_code := 0;
132: -- x_return_status := 0;
133: END IF;
134:

Line 136: WHEN FND_API.G_EXC_ERROR THEN

132: -- x_return_status := 0;
133: END IF;
134:
135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137: X_return_code := SQLCODE;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
140:

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134:
135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137: X_return_code := SQLCODE;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
140:
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: X_return_code := SQLCODE;

Line 141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

137: X_return_code := SQLCODE;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
140:
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: X_return_code := SQLCODE;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
145:

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
140:
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: X_return_code := SQLCODE;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
145:
146: WHEN OTHERS THEN
147: X_return_code := SQLCODE;

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
145:
146: WHEN OTHERS THEN
147: X_return_code := SQLCODE;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
150:
151: END ;
152: