DBA Data[Home] [Help]

APPS.CN_SCA_UTL_PVT dependencies on FND_API

Line 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: AND aidx.index_name LIKE 'CN_SCA_HEADERS_INTERFACE_A%';
105:
106: BEGIN
107:
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: SELECT application_short_name
111: INTO l_cn_schema
112: FROM fnd_application

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138: END LOOP;
139:
140: EXCEPTION
141: WHEN OTHERS THEN
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: debugmsg('Error while dropping the existing indexes');
144: debugmsg('Oracle Error: '||SQLERRM);
145: RAISE;
146: END;

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

188: debugmsg('Created new indexes ... ');
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: debugmsg('Error while creating new indexes on Attribute columns');
194: debugmsg('Oracle Error :'||SQLERRM);
195: RAISE;
196: END;