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.GMD_RECIPE_GENERATE dependencies on FND_API

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: Create_Recipe_Err EXCEPTION;
74:
75:
76: BEGIN
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: OPEN c_get_formula_status;
80: FETCH c_get_formula_status INTO l_formula_status;
81: CLOSE c_get_formula_status;

Line 107: IF X_return_status <> FND_API.g_ret_sts_success THEN

103: p_event_signed => p_event_signed,
104: -- Kapil LCF-GMO ME : Bug#5458666
105: p_routing_id => p_routing_id,
106: p_enhanced_pi_ind => p_enhanced_pi_ind);
107: IF X_return_status <> FND_API.g_ret_sts_success THEN
108: RAISE Create_Recipe_Err;
109: END IF;
110:
111: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',

Line 135: X_return_status := FND_API.G_RET_STS_ERROR;

131: CLOSE c_get_recipe_info;
132:
133: EXCEPTION
134: WHEN CREATE_RECIPE_ERR THEN
135: X_return_status := FND_API.G_RET_STS_ERROR;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: END recipe_generate;

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: EXCEPTION
134: WHEN CREATE_RECIPE_ERR THEN
135: X_return_status := FND_API.G_RET_STS_ERROR;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: END recipe_generate;
140:
141: /*+========================================================================+

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: x_return_status OUT NOCOPY VARCHAR2) IS
180: l_recipe_use NUMBER(5);
181: l_end_status VARCHAR2(40);
182: BEGIN
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184:
185: IF p_recipe_use_prod = 1 THEN
186: l_recipe_use := 0;
187: create_validity_rule(p_recipe_id => p_recipe_id,

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS;

300: x_msg_count NUMBER;
301: x_msg_data VARCHAR2(2000);
302:
303: BEGIN
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: GMD_API_GRP.retrieve_vr(p_formula_id => p_formula_id,
307: l_recipe_vr_tbl => l_recipe_vr_tbl,
308: l_vr_flex => l_vr_flex,

Line 336: IF l_return_status <> FND_API.g_ret_sts_success THEN

332:
333: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => l_recipe_vr_tbl
334: ,p_recipe_vr_flex_rec => l_vr_flex
335: ,x_return_status => l_return_status);
336: IF l_return_status <> FND_API.g_ret_sts_success THEN
337:
338: RAISE FND_API.g_exc_error;
339: ELSE
340: COMMIT WORK;

Line 338: RAISE FND_API.g_exc_error;

334: ,p_recipe_vr_flex_rec => l_vr_flex
335: ,x_return_status => l_return_status);
336: IF l_return_status <> FND_API.g_ret_sts_success THEN
337:
338: RAISE FND_API.g_exc_error;
339: ELSE
340: COMMIT WORK;
341: END IF;
342:

Line 367: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN

363: , p_ignore_flag => FALSE
364: , x_message_count => x_msg_count
365: , x_message_list => x_msg_data
366: , x_return_status => l_return_status);
367: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
368: RAISE fnd_api.g_exc_error;
369: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
370: END IF; -- IF p_event_signed
371: END IF;--l_entity_status.entity_status

Line 368: RAISE fnd_api.g_exc_error;

364: , x_message_count => x_msg_count
365: , x_message_list => x_msg_data
366: , x_return_status => l_return_status);
367: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
368: RAISE fnd_api.g_exc_error;
369: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
370: END IF; -- IF p_event_signed
371: END IF;--l_entity_status.entity_status
372:

Line 369: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')

365: , x_message_list => x_msg_data
366: , x_return_status => l_return_status);
367: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
368: RAISE fnd_api.g_exc_error;
369: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
370: END IF; -- IF p_event_signed
371: END IF;--l_entity_status.entity_status
372:
373: OPEN Cur_get_validity_status (l_vr_id);

Line 378: WHEN FND_API.g_exc_error THEN

374: FETCH Cur_get_validity_status INTO X_end_status;
375: CLOSE Cur_get_validity_status;
376:
377: EXCEPTION
378: WHEN FND_API.g_exc_error THEN
379: X_return_status := l_return_status;
380: WHEN OTHERS THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: END create_validity_rule;

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: EXCEPTION
378: WHEN FND_API.g_exc_error THEN
379: X_return_status := l_return_status;
380: WHEN OTHERS THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: END create_validity_rule;
383:
384:
385: /*+========================================================================+

Line 451: x_return_status := FND_API.G_RET_STS_SUCCESS;

447: create_recipe_err EXCEPTION;
448: default_status_err EXCEPTION;
449: BEGIN
450:
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453: -- Kapil LCF-GMO ME : Bug#5458666
454: -- Pass the routing_id to retrieve the recipe details.
455: GMD_API_GRP.retrieve_recipe(p_formula_id,

Line 460: IF x_return_status <> FND_API.g_ret_sts_success THEN

456: p_routing_id,
457: l_recipe_tbl,
458: l_recipe_flex,
459: x_return_status);
460: IF x_return_status <> FND_API.g_ret_sts_success THEN
461: RAISE create_recipe_err;
462: END IF;
463: x_recipe_no := l_recipe_tbl.recipe_no;
464: x_recipe_version := l_recipe_tbl.recipe_version;

Line 476: IF l_return_status <> FND_API.g_ret_sts_success THEN

472: l_recipe_tbl.enhanced_pi_ind := p_enhanced_pi_ind;
473: GMD_RECIPE_HEADER_PVT.create_recipe_header (p_recipe_header_rec => l_recipe_tbl
474: ,p_recipe_hdr_flex_rec => l_recipe_flex
475: ,x_return_status => l_return_status);
476: IF l_return_status <> FND_API.g_ret_sts_success THEN
477: RAISE create_recipe_err;
478: ELSE
479: COMMIT WORK;
480: END IF;

Line 519: X_return_status := FND_API.G_RET_STS_SUCCESS;

515: FND_MESSAGE.SET_TOKEN('STATUS', l_default_recipe_status.entity_status);
516: FND_MESSAGE.SET_TOKEN('ROUTING_NO', l_routing_no);
517: FND_MESSAGE.SET_TOKEN('ROUTING_VERS', l_routing_vers);
518: FND_MSG_PUB.ADD;
519: X_return_status := FND_API.G_RET_STS_SUCCESS;
520: RETURN;
521: END IF;
522: END IF;
523:

Line 544: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN

540: , x_message_count => x_msg_count
541: , x_message_list => x_msg_data
542: , x_return_status => l_return_status);
543: G_Create_Validity := FALSE;
544: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
545: RAISE default_status_err;
546: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
547: END IF; -- IF p_event_signed
548: END IF;--l_entity_status.entity_status

Line 546: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')

542: , x_return_status => l_return_status);
543: G_Create_Validity := FALSE;
544: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
545: RAISE default_status_err;
546: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
547: END IF; -- IF p_event_signed
548: END IF;--l_entity_status.entity_status
549:
550: OPEN Cur_get_recipe_status (l_recipe_tbl.recipe_no, l_recipe_tbl.recipe_version);