DBA Data[Home] [Help]

APPS.EAM_WO_SCHEDULE_PVT dependencies on FND_API

Line 151: x_return_status := fnd_api.g_ret_sts_error;

147: l_calendar_index := shift_date_tbl.NEXT(l_calendar_index);
148: END LOOP;
149:
150: EXCEPTION WHEN OUT_OF_CAL_EXC THEN
151: x_return_status := fnd_api.g_ret_sts_error;
152: x_error_message := 'DATE OUT OF CALENDAR';
153: IF EAM_PROCESS_WO_PVT. Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exception raised.No entry found for this date, calendar and exception_set_id combination'||p_shift_num||'in'||p_curr_date) ; END IF ;
154:
155: END;

Line 779: x_return_status := fnd_api.g_ret_sts_error;

775:
776: begin
777: -- bug no 3444091
778: if l_res_start_date > l_res_completion_date then
779: x_return_status := fnd_api.g_ret_sts_error;
780: fnd_message.set_name('EAM','EAM_WO_RES_DT_ERR');
781: fnd_message.set_token('RESNO', op_res_info_tbl(i).res_seq_num);
782: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative resource duration') ; END IF ;
783: return;

Line 857: x_return_status := fnd_api.g_ret_sts_error;

853:
854:
855: EXCEPTION
856: WHEN NO_SFT_EXC THEN
857: x_return_status := fnd_api.g_ret_sts_error;
858: x_error_message := 'NO SHIFT ASSOCIATED TO A RESOURCE';
859: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('No shift found for the resource') ; END IF ;
860:
861: END; /*SCHEDULE_RESOURCES */

Line 1452: x_return_status := fnd_api.g_ret_sts_error;

1448: l_op_seq_num := op_scd_seq_tbl(l_op_index).op_seq_num;
1449:
1450: -- bug no 3444091
1451: if l_op_start_date > l_op_completion_date then
1452: x_return_status := fnd_api.g_ret_sts_error;
1453: fnd_message.set_name('EAM','EAM_WO_OP_DT_TK_ERR');
1454: fnd_message.set_token('OPNO', l_op_seq_num);
1455: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative operation duration') ; END IF ;
1456: return;

Line 1487: x_return_status := fnd_api.g_ret_sts_error;

1483: p_start_date := NVL(l_min_start_date,NVL(p_start_date,p_completion_date)); --will be Null when there are no operations
1484: p_completion_date := NVL(l_max_completion_date, p_start_date);
1485:
1486: if p_start_date > p_completion_date then
1487: x_return_status := fnd_api.g_ret_sts_error;
1488: fnd_message.set_name('EAM','EAM_WO_DT_TK_ERR');
1489: fnd_message.set_token('WONO', p_wip_entity_id);
1490: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative workorder duration') ; END IF ;
1491: return;

Line 1516: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1512: p_wip_entity_id IN NUMBER,
1513: p_start_date IN OUT NOCOPY DATE,
1514: p_completion_date IN OUT NOCOPY DATE,
1515: p_validation_level IN NUMBER,
1516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1517: x_error_message OUT NOCOPY VARCHAR2,
1518: x_return_status OUT NOCOPY VARCHAR2
1519: )
1520: IS

Line 1588: x_return_status := FND_API.G_RET_STS_SUCCESS;

1584: BEGIN
1585:
1586: SAVEPOINT SCHEDULE_WO;
1587:
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589:
1590: l_stmt_num := 10;
1591:
1592: /* For identifying Hour UOM for resource scheduling */

Line 1597: x_return_status := FND_API.G_RET_STS_ERROR;

1593: l_hour_uom := fnd_profile.value('BOM:HOUR_UOM_CODE');
1594:
1595: IF l_hour_uom IS NULL THEN
1596: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Value of Profile BOM: Hour UOM is null') ; END IF ;
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: l_token_tbl.DELETE;
1599: l_token_tbl(1).token_name := 'PROFILE';
1600: l_token_tbl(1).token_value := 'BOM: Hour UOM';
1601: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 1880: x_return_status := fnd_api.g_ret_sts_error;

1876: where wip_entity_id = p_wip_entity_id
1877: and organization_id = p_organization_id;
1878:
1879: if l_wo_start_date > l_wo_end_date then
1880: x_return_status := fnd_api.g_ret_sts_error;
1881: fnd_message.set_name('EAM','EAM_WO_DT_ERR');
1882: fnd_message.set_token('RESNO', p_wip_entity_id);
1883: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative workorder duration') ; END IF ;
1884: return;

Line 1892: x_return_status := FND_API.G_RET_STS_SUCCESS;

1888:
1889: --########## Commented out
1890:
1891:
1892: x_return_status := FND_API.G_RET_STS_SUCCESS;
1893:
1894: EXCEPTION
1895: WHEN INVALID_PARAM_EXC THEN
1896: ROLLBACK TO SCHEDULE_WO;

Line 1897: x_return_status := fnd_api.g_ret_sts_error;

1893:
1894: EXCEPTION
1895: WHEN INVALID_PARAM_EXC THEN
1896: ROLLBACK TO SCHEDULE_WO;
1897: x_return_status := fnd_api.g_ret_sts_error;
1898: x_error_message := ' EAM_RTG_GET_INFO : Statement - '||l_stmt_num||' Invalid parameter - '||l_error_msg;
1899: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Invalid parameter exception') ; END IF ;
1900: WHEN NO_DATA_FOUND THEN
1901: ROLLBACK TO SCHEDULE_WO;

Line 1902: x_return_status := fnd_api.g_ret_sts_error;

1898: x_error_message := ' EAM_RTG_GET_INFO : Statement - '||l_stmt_num||' Invalid parameter - '||l_error_msg;
1899: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Invalid parameter exception') ; END IF ;
1900: WHEN NO_DATA_FOUND THEN
1901: ROLLBACK TO SCHEDULE_WO;
1902: x_return_status := fnd_api.g_ret_sts_error;
1903: x_error_message := ' EAM_RTG_GET_INFO : Statement - '||l_stmt_num||'No Calendar associated in Org parameters';
1904: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('No calendar associated in Org parameters') ; END IF ;
1905: WHEN OTHERS THEN
1906: ROLLBACK TO SCHEDULE_WO;

Line 1907: x_return_status := fnd_api.g_ret_sts_unexp_error;

1903: x_error_message := ' EAM_RTG_GET_INFO : Statement - '||l_stmt_num||'No Calendar associated in Org parameters';
1904: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('No calendar associated in Org parameters') ; END IF ;
1905: WHEN OTHERS THEN
1906: ROLLBACK TO SCHEDULE_WO;
1907: x_return_status := fnd_api.g_ret_sts_unexp_error;
1908: x_error_message := ' EAM_RTG_GET_INFO : Statement - '||l_stmt_num||' Error Message - '||SQLERRM;
1909: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Enters when others exception') ; END IF ;
1910: END;
1911: