DBA Data[Home] [Help]

APPS.WMS_LMS_UTILS dependencies on FND_API

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376: debug( 'The number of bucketed records inserted are '|| l_records_inserted
377: ,'BUCKET_ACTUAL_TIMINGS');
378: END IF;
379:
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: EXCEPTION
383: WHEN OTHERS THEN
384: IF g_debug=1 THEN

Line 389: x_return_status := FND_API.G_RET_STS_ERROR;

385: debug( 'The process of bucketing the transaction records is a failure'
386: ,'BUCKET_ACTUAL_TIMINGS');
387: END IF;
388:
389: x_return_status := FND_API.G_RET_STS_ERROR;
390:
391: END BUCKET_ACTUAL_TIMINGS;
392:
393:

Line 440: IF(l_return_status = FND_API.g_ret_sts_success )THEN

436: , p_purge_date => TO_DATE(p_purge_date,'YYYY/MM/DD HH24:MI:SS')
437: );
438:
439:
440: IF(l_return_status = FND_API.g_ret_sts_success )THEN
441: -- If success then only proceed with the purging
442:
443: IF g_debug=1 THEN
444: debug( 'Call to Bucket_actual_timings is a success now deleting '

Line 1525: x_return_status := fnd_api.g_ret_sts_success;

1521:
1522: BEGIN
1523:
1524: -- set the status to success initially
1525: x_return_status := fnd_api.g_ret_sts_success;
1526:
1527:
1528: SAVEPOINT standardize_lines;
1529:

Line 1542: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1538: IF P_COPY_ID IS NULL THEN
1539: -- FND_MESSAGE.SET_NAME('WMS','WMS_NO_LINES_TO_COPY');
1540: -- FND_MSG_PUB.ADD;
1541: X_MSG_NAME := 'WMS_NO_LINES_SELECTED';
1542: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1543: RETURN ;
1544: END IF;
1545:
1546: IF P_COPY_ANALYSIS IS NULL THEN

Line 1550: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1546: IF P_COPY_ANALYSIS IS NULL THEN
1547: -- FND_MESSAGE.SET_NAME('WMS','WMS_NO_LINES_TO_COPY');
1548: -- FND_MSG_PUB.ADD;
1549: X_MSG_NAME := 'WMS_NO_LINES_SELECTED';
1550: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1551: RETURN ;
1552: END IF;
1553:
1554: -- Proceed if all required parameters are passed.

Line 1584: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1580:
1581: -- FND_MESSAGE.SET_NAME('WMS','WMS_LMS_NO_ORG');
1582: -- FND_MSG_PUB.ADD;
1583: X_MSG_NAME := 'WMS_LMS_NO_ORG';
1584: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1585: RETURN ;
1586:
1587: END IF;
1588:

Line 1772: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1768: when others then
1769: l_ind_or_man_tasks_inserted := l_ind_or_man_tasks_inserted;
1770: ROLLBACK TO standardize_lines;
1771:
1772: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1773: X_MSG_NAME := 'WMS_LMS_LINES_UPDATE_ERROR';
1774: X_NUM_LINES_INSERTED_TASKS := 0;
1775: X_NUM_LINES_INSERTED_GROUP := 0;
1776:

Line 1975: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1971: END IF;
1972: ROLLBACK TO standardize_lines;
1973:
1974: -- return the appropriate status
1975: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1976: X_MSG_NAME := 'WMS_LMS_LINES_UPDATE_ERROR';
1977: X_NUM_LINES_INSERTED_TASKS := 0;
1978: X_NUM_LINES_INSERTED_GROUP := 0;
1979:

Line 2765: x_return_status := FND_API.G_RET_STS_SUCCESS;

2761: PRAGMA AUTONOMOUS_TRANSACTION;
2762:
2763: BEGIN
2764:
2765: x_return_status := FND_API.G_RET_STS_SUCCESS;
2766:
2767: IF(IS_USER_NON_TRACKED (
2768: P_USER_ID=>P_USER_ID,
2769: P_ORG_ID =>P_ORGANIZATION_ID

Line 2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2848: END IF;
2849:
2850: EXCEPTION
2851: WHEN OTHERS THEN
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2853:
2854: IF g_debug=1 THEN
2855: debug('Insertion in WMS_ELS_TRX_SRC failed'||SQLERRM);
2856: END IF;