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 38: IF (FND_API.To_Boolean(p_commit)) THEN

34: X_msg_data VARCHAR2(2000);
35: RCP_GENERATE_ERROR EXCEPTION;
36: BEGIN
37: SAVEPOINT RECIPE_GENERATE_PUB;
38: IF (FND_API.To_Boolean(p_commit)) THEN
39: G_COMMIT := 'TRUE';
40: ELSE
41: G_COMMIT := 'FALSE';
42: END IF;

Line 44: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

40: ELSE
41: G_COMMIT := 'FALSE';
42: END IF;
43: GMD_RECIPE_GENERATE.recipe_generate(p_orgn_id,p_formula_id,l_return_status, x_recipe_no, x_recipe_version);
44: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
45: RAISE RCP_GENERATE_ERROR;
46: END IF;
47: EXCEPTION
48: WHEN RCP_GENERATE_ERROR THEN

Line 50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

46: END IF;
47: EXCEPTION
48: WHEN RCP_GENERATE_ERROR THEN
49: ROLLBACK to RECIPE_GENERATE_PUB;
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
51: FND_MSG_PUB.Count_And_Get (
52: p_count => x_msg_count,
53: p_data => x_msg_data);
54:

Line 57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

53: p_data => x_msg_data);
54:
55: WHEN OTHERS THEN
56: ROLLBACK to RECIPE_GENERATE_PUB;
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58: FND_MSG_PUB.Count_And_Get (
59: p_count => x_msg_count,
60: p_data => x_msg_data );
61: END recipe_generate;

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: Create_Recipe_Err EXCEPTION;
132:
133:
134: BEGIN
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: OPEN c_get_formula_status;
138: FETCH c_get_formula_status INTO l_formula_status;
139: CLOSE c_get_formula_status;

Line 165: IF X_return_status <> FND_API.g_ret_sts_success THEN

161: p_event_signed => p_event_signed,
162: -- Kapil LCF-GMO ME : Bug#5458666
163: p_routing_id => p_routing_id,
164: p_enhanced_pi_ind => p_enhanced_pi_ind);
165: IF X_return_status <> FND_API.g_ret_sts_success THEN
166: RAISE Create_Recipe_Err;
167: END IF;
168:
169: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',

Line 193: X_return_status := FND_API.G_RET_STS_ERROR;

189: CLOSE c_get_recipe_info;
190:
191: EXCEPTION
192: WHEN CREATE_RECIPE_ERR THEN
193: X_return_status := FND_API.G_RET_STS_ERROR;
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: END recipe_generate;

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: EXCEPTION
192: WHEN CREATE_RECIPE_ERR THEN
193: X_return_status := FND_API.G_RET_STS_ERROR;
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: END recipe_generate;
198:
199: /*+========================================================================+

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: x_return_status OUT NOCOPY VARCHAR2) IS
238: l_recipe_use NUMBER(5);
239: l_end_status VARCHAR2(40);
240: BEGIN
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: IF p_recipe_use_prod = 1 THEN
244: l_recipe_use := 0;
245: create_validity_rule(p_recipe_id => p_recipe_id,

Line 362: x_return_status := FND_API.G_RET_STS_SUCCESS;

358: x_msg_count NUMBER;
359: x_msg_data VARCHAR2(2000);
360:
361: BEGIN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: GMD_API_GRP.retrieve_vr(p_formula_id => p_formula_id,
365: l_recipe_vr_tbl => l_recipe_vr_tbl,
366: l_vr_flex => l_vr_flex,

Line 395: IF l_return_status <> FND_API.g_ret_sts_success THEN

391:
392: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => l_recipe_vr_tbl
393: ,p_recipe_vr_flex_rec => l_vr_flex
394: ,x_return_status => l_return_status);
395: IF l_return_status <> FND_API.g_ret_sts_success THEN
396:
397: RAISE FND_API.g_exc_error;
398: ELSE
399: --PLM4P

Line 397: RAISE FND_API.g_exc_error;

393: ,p_recipe_vr_flex_rec => l_vr_flex
394: ,x_return_status => l_return_status);
395: IF l_return_status <> FND_API.g_ret_sts_success THEN
396:
397: RAISE FND_API.g_exc_error;
398: ELSE
399: --PLM4P
400: IF G_COMMIT = 'TRUE' THEN
401: COMMIT WORK;

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

425: , p_ignore_flag => FALSE
426: , x_message_count => x_msg_count
427: , x_message_list => x_msg_data
428: , x_return_status => l_return_status);
429: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
430: RAISE fnd_api.g_exc_error;
431: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
432: END IF; -- IF p_event_signed
433: END IF;--l_entity_status.entity_status

Line 430: RAISE fnd_api.g_exc_error;

426: , x_message_count => x_msg_count
427: , x_message_list => x_msg_data
428: , x_return_status => l_return_status);
429: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
430: RAISE fnd_api.g_exc_error;
431: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
432: END IF; -- IF p_event_signed
433: END IF;--l_entity_status.entity_status
434:

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

427: , x_message_list => x_msg_data
428: , x_return_status => l_return_status);
429: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
430: RAISE fnd_api.g_exc_error;
431: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
432: END IF; -- IF p_event_signed
433: END IF;--l_entity_status.entity_status
434:
435: OPEN Cur_get_validity_status (l_vr_id);

Line 440: WHEN FND_API.g_exc_error THEN

436: FETCH Cur_get_validity_status INTO X_end_status;
437: CLOSE Cur_get_validity_status;
438:
439: EXCEPTION
440: WHEN FND_API.g_exc_error THEN
441: X_return_status := l_return_status;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: END create_validity_rule;

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: EXCEPTION
440: WHEN FND_API.g_exc_error THEN
441: X_return_status := l_return_status;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: END create_validity_rule;
445:
446:
447: /*+========================================================================+

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS;

509: create_recipe_err EXCEPTION;
510: default_status_err EXCEPTION;
511: BEGIN
512:
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:
515: -- Kapil LCF-GMO ME : Bug#5458666
516: -- Pass the routing_id to retrieve the recipe details.
517: GMD_API_GRP.retrieve_recipe(p_formula_id,

Line 522: IF x_return_status <> FND_API.g_ret_sts_success THEN

518: p_routing_id,
519: l_recipe_tbl,
520: l_recipe_flex,
521: x_return_status);
522: IF x_return_status <> FND_API.g_ret_sts_success THEN
523: RAISE create_recipe_err;
524: END IF;
525: x_recipe_no := l_recipe_tbl.recipe_no;
526: x_recipe_version := l_recipe_tbl.recipe_version;

Line 538: IF l_return_status <> FND_API.g_ret_sts_success THEN

534: l_recipe_tbl.enhanced_pi_ind := p_enhanced_pi_ind;
535: GMD_RECIPE_HEADER_PVT.create_recipe_header (p_recipe_header_rec => l_recipe_tbl
536: ,p_recipe_hdr_flex_rec => l_recipe_flex
537: ,x_return_status => l_return_status);
538: IF l_return_status <> FND_API.g_ret_sts_success THEN
539: RAISE create_recipe_err;
540: ELSE
541: --PLM4P
542: IF G_COMMIT = 'TRUE' THEN

Line 583: X_return_status := FND_API.G_RET_STS_SUCCESS;

579: FND_MESSAGE.SET_TOKEN('STATUS', l_default_recipe_status.entity_status);
580: FND_MESSAGE.SET_TOKEN('ROUTING_NO', l_routing_no);
581: FND_MESSAGE.SET_TOKEN('ROUTING_VERS', l_routing_vers);
582: FND_MSG_PUB.ADD;
583: X_return_status := FND_API.G_RET_STS_SUCCESS;
584: RETURN;
585: END IF;
586: END IF;
587:

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

604: , x_message_count => x_msg_count
605: , x_message_list => x_msg_data
606: , x_return_status => l_return_status);
607: G_Create_Validity := FALSE;
608: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
609: RAISE default_status_err;
610: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
611: END IF; -- IF p_event_signed
612: END IF;--l_entity_status.entity_status

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

606: , x_return_status => l_return_status);
607: G_Create_Validity := FALSE;
608: IF l_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
609: RAISE default_status_err;
610: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
611: END IF; -- IF p_event_signed
612: END IF;--l_entity_status.entity_status
613:
614: OPEN Cur_get_recipe_status (l_recipe_tbl.recipe_no, l_recipe_tbl.recipe_version);