DBA Data[Home] [Help]

APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FND_API

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

870: p_ignore_vol_conv => TRUE,
871: p_process_loss => l_planned_process_loss,
872: p_organization_id => l_organization_id);
873:
874: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
875: RAISE STEP_QTY_ERROR;
876: END IF;
877:
878:

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

1351: P_msg_count => l_msg_count,
1352: P_msg_stack => l_msg_stack,
1353: P_return_status => l_return_status);
1354:
1355: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1356: RAISE STEP_QTY_ERROR;
1357: END IF;
1358:
1359: FOR i IN 1.. l_step_tbl.COUNT LOOP

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

1916: ,p_flex_header_rec => l_recipe_update_flex
1917: ,x_return_status => l_return_status);
1918:
1919:
1920: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1921: RAISE UPDATE_RECIPE_EXCEPTION;
1922: END IF;
1923:
1924: --- If recipe number and/or version have changed, we need to update them. This

Line 2051: x_return_code := FND_API.G_RET_STS_SUCCESS;

2047: l_formula_security_id NUMBER;
2048:
2049: BEGIN
2050:
2051: x_return_code := FND_API.G_RET_STS_SUCCESS;
2052: x_error_msg := FND_MESSAGE.GET;
2053:
2054: OPEN Cur_recipe_id;
2055: FETCH Cur_recipe_id INTO x_recipe_id;

Line 3390: x_return_code := FND_API.G_RET_STS_SUCCESS;

3386:
3387: BEGIN
3388:
3389: x_error_msg := '';
3390: x_return_code := FND_API.G_RET_STS_SUCCESS;
3391:
3392: x_recipe_id := -1;
3393: x_routing_id := -1;
3394: x_formula_id := -1;

Line 3806: ,p_init_msg_list => FND_API.G_TRUE

3802: l_frm_hdr_rec.formula_status := 100;
3803:
3804: GMD_FORMULA_HEADER_PVT.Insert_FormulaHeader
3805: ( p_api_version => 1.0
3806: ,p_init_msg_list => FND_API.G_TRUE
3807: ,p_commit => FND_API.G_FALSE
3808: ,x_return_status => l_return_code
3809: ,x_msg_count => l_message_count
3810: ,x_msg_data => l_message_list

Line 3807: ,p_commit => FND_API.G_FALSE

3803:
3804: GMD_FORMULA_HEADER_PVT.Insert_FormulaHeader
3805: ( p_api_version => 1.0
3806: ,p_init_msg_list => FND_API.G_TRUE
3807: ,p_commit => FND_API.G_FALSE
3808: ,x_return_status => l_return_code
3809: ,x_msg_count => l_message_count
3810: ,x_msg_data => l_message_list
3811: ,p_formula_header_rec => l_frm_hdr_rec

Line 3818: ,p_init_msg_list => FND_API.G_TRUE

3814: ELSE
3815:
3816: GMD_FORMULA_HEADER_PVT.Update_FormulaHeader
3817: ( p_api_version => 1.0
3818: ,p_init_msg_list => FND_API.G_TRUE
3819: ,p_commit => FND_API.G_FALSE
3820: ,x_return_status => l_return_code
3821: ,x_msg_count => l_message_count
3822: ,x_msg_data => l_message_list

Line 3819: ,p_commit => FND_API.G_FALSE

3815:
3816: GMD_FORMULA_HEADER_PVT.Update_FormulaHeader
3817: ( p_api_version => 1.0
3818: ,p_init_msg_list => FND_API.G_TRUE
3819: ,p_commit => FND_API.G_FALSE
3820: ,x_return_status => l_return_code
3821: ,x_msg_count => l_message_count
3822: ,x_msg_data => l_message_list
3823: ,p_formula_header_rec => l_frm_hdr_rec

Line 3918: ,p_init_msg_list => FND_API.G_TRUE

3914: l_frm_dtl_tbl(i).formulaline_id := l_formulaline_id;
3915: l_frm_dtl_tbl(i).text_code := l_text_code;
3916: GMD_FORMULA_DETAIL_PVT.Insert_FormulaDetail
3917: ( p_api_version => 1.0
3918: ,p_init_msg_list => FND_API.G_TRUE
3919: ,p_commit => FND_API.G_FALSE
3920: ,x_return_status => l_return_code
3921: ,x_msg_count => l_message_count
3922: ,x_msg_data => l_message_list

Line 3919: ,p_commit => FND_API.G_FALSE

3915: l_frm_dtl_tbl(i).text_code := l_text_code;
3916: GMD_FORMULA_DETAIL_PVT.Insert_FormulaDetail
3917: ( p_api_version => 1.0
3918: ,p_init_msg_list => FND_API.G_TRUE
3919: ,p_commit => FND_API.G_FALSE
3920: ,x_return_status => l_return_code
3921: ,x_msg_count => l_message_count
3922: ,x_msg_data => l_message_list
3923: ,p_formula_detail_rec => l_frm_dtl_tbl(i)

Line 5472: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;

5468: x_return_code := 'S';
5469: END IF;
5470: EXCEPTION
5471: WHEN OTHERS THEN
5472: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
5473:
5474: END CHECK_RECP_ORGN_ACCESS;
5475:
5476:

Line 5557: x_return_status := FND_API.g_ret_sts_success;

5553:
5554: BEGIN
5555: SAVEPOINT default_status_sp;
5556:
5557: x_return_status := FND_API.g_ret_sts_success;
5558:
5559: IF (pEntity_name = 'FORMULA') THEN
5560: OPEN get_formula_details(pentity_id);
5561: FETCH get_formula_details INTO l_owner_organization_id;

Line 5585: RAISE FND_API.G_EXC_ERROR;

5581: IF (l_entity_status.status_type = 700) THEN
5582: IF (gmdfmval_pub.check_expr_items(pEntity_id)) THEN
5583: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
5584: FND_MSG_PUB.ADD;
5585: RAISE FND_API.G_EXC_ERROR;
5586: END IF;
5587: END IF; -- IF (X_status_type = 700) THEN
5588:
5589: --Check any inactive items in formula before changing the status

Line 5594: RAISE FND_API.G_EXC_ERROR;

5590: IF (l_entity_status.status_type IN (400,700)) THEN
5591: IF (gmdfmval_pub.inactive_items(pEntity_id)) THEN
5592: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
5593: FND_MSG_PUB.ADD;
5594: RAISE FND_API.G_EXC_ERROR;
5595: END IF;
5596: END IF; --l_entity_status.status_type IN (400,700)
5597: END IF;
5598:

Line 5612: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN

5608: , x_message_count => x_msg_count
5609: , x_message_list => x_msg_data
5610: , x_return_status => x_return_status);
5611:
5612: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
5613: RAISE default_status_err;
5614: END IF; --x_return_status
5615: END IF; --l_entity_status.entity_status <> 100
5616:

Line 5625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5621: p_count => x_msg_count,
5622: p_data => x_msg_data );
5623: WHEN OTHERS THEN
5624: ROLLBACK TO default_status_sp;
5625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5626: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
5627: p_count => x_msg_count,
5628: p_data => x_msg_data );
5629: END set_default_status;