APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on FND_API

Line 485: and NVL(synch_schedule_num,FND_API.G_MISS_CHAR) = arg_schedule_number

481: select count(*)
482: into var_count
483: from wip_flow_schedules
484: where primary_item_id = var_comp_id
485: and NVL(synch_schedule_num,FND_API.G_MISS_CHAR) = arg_schedule_number
486: and NVL(synch_operation_seq_num,FND_API.G_MISS_NUM) = var_operation_seq_num;
487:
488: -- Include only components that :
489: -- 1. hasn't been synchronized.

Line 486: and NVL(synch_operation_seq_num,FND_API.G_MISS_NUM) = var_operation_seq_num;

482: into var_count
483: from wip_flow_schedules
484: where primary_item_id = var_comp_id
485: and NVL(synch_schedule_num,FND_API.G_MISS_CHAR) = arg_schedule_number
486: and NVL(synch_operation_seq_num,FND_API.G_MISS_NUM) = var_operation_seq_num;
487:
488: -- Include only components that :
489: -- 1. hasn't been synchronized.
490: -- 2. feeder line goes into the primary path

Line 773: p_init_msg_list => FND_API.G_TRUE,

769:
770: /* Added p_explode_bom for bug number 2079836 */
771: MRP_Flow_Schedule_PVT.Process_Flow_Schedule(
772: p_api_version_number => 1.0,
773: p_init_msg_list => FND_API.G_TRUE,
774: x_return_status => l_return_status,
775: x_msg_count => l_msg_count,
776: x_msg_data => l_msg_data,
777: p_control_rec => l_control_rec,

Line 783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

779: x_flow_schedule_rec => l_x_flow_schedule_rec,
780: p_old_flow_schedule_rec => l_old_flow_schedule_rec,
781: p_explode_bom => 'Y');
782:
783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;

Line 784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

780: p_old_flow_schedule_rec => l_old_flow_schedule_rec,
781: p_explode_bom => 'Y');
782:
783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:

Line 785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

781: p_explode_bom => 'Y');
782:
783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:
789: var_current_row := var_current_row + 1;

Line 786: RAISE FND_API.G_EXC_ERROR;

782:
783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:
789: var_current_row := var_current_row + 1;
790: