DBA Data[Home] [Help]

APPS.INV_ITEM_GRP dependencies on MTL_INTERFACE_ERRORS

Line 1526: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';

1522: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1523: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1524: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1525: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1526: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';
1527: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);
1528: ELSE
1529: --
1530: -- If Interface Process return_code <> 0 and there are no additional

Line 1567: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';

1563: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1564: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1565: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1566: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1567: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';
1568: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);
1569: ELSE
1570:
1571: --

Line 1671: FROM MTL_INTERFACE_ERRORS

1667: -- , error_message || column_name
1668: , TABLE_NAME
1669: , substr(COLUMN_NAME,1,30) COLUMN_NAME
1670: , ORGANIZATION_ID
1671: FROM MTL_INTERFACE_ERRORS
1672: WHERE TRANSACTION_ID = p_tnx_id
1673: ORDER BY TRANSACTION_ID, UNIQUE_ID;
1674:
1675: BEGIN

Line 1714: x_return_err := 'IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table';

1710: END LOOP;
1711:
1712: IF ( l_idx = l_init_errno ) THEN
1713: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1714: x_return_err := 'IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table';
1715: END IF;
1716:
1717: EXCEPTION
1718: