APPS.CCT_LKUP_PUB dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32:
33: SAVEPOINT GET_TRUE_FALSE_LOV_PUB;
34:
35: -- Initialize API return status to success
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: x_msg_count := 0;
38: x_msg_data := null;
39:
40: x_lov_count := 0;

Line 78: x_return_status := FND_API.G_RET_STS_ERROR ;

74: EXCEPTION
75:
76: WHEN OTHERS THEN
77: ROLLBACK TO GET_TRUE_FALSE_LOV_PUB;
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: x_msg_count := 1;
80: x_err_num := SQLCODE;
81: x_err_msg := SUBSTR(SQLERRM, 1, 100);
82: x_msg_data := 'CCT_LKUP_PUB: CCT_ERROR '

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111:
112: SAVEPOINT GET_JDBC_CONN_LOV_PUB;
113:
114: -- Initialize API return status to success
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116: x_msg_count := 0;
117: x_msg_data := null;
118: -- API body
119: x_lov_count := 0;

Line 137: x_return_status := FND_API.G_RET_STS_ERROR ;

133: EXCEPTION
134:
135: WHEN OTHERS THEN
136: ROLLBACK TO GET_JDBC_CONN_LOV_PUB;
137: x_return_status := FND_API.G_RET_STS_ERROR ;
138: x_msg_count := 1;
139: x_err_num := SQLCODE;
140: x_err_msg := SUBSTR(SQLERRM, 1, 100);
141: x_msg_data := 'CCT_LKUP_PUB: CCT_ERROR '

Line 178: x_return_status := FND_API.G_RET_STS_SUCCESS;

174:
175: SAVEPOINT GET_TRACE_LOV_PUB;
176:
177: -- Initialize API return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179: x_msg_count := 0;
180: x_msg_data := null;
181:
182: x_lov_count := 0;

Line 217: x_return_status := FND_API.G_RET_STS_ERROR ;

213: EXCEPTION
214:
215: WHEN OTHERS THEN
216: ROLLBACK TO GET_TRACE_LOV_PUB;
217: x_return_status := FND_API.G_RET_STS_ERROR ;
218: x_msg_count := 1;
219: x_err_num := SQLCODE;
220: x_err_msg := SUBSTR(SQLERRM, 1, 100);
221: x_msg_data := 'CCT_LKUP_PUB: CCT_ERROR '

Line 257: x_return_status := FND_API.G_RET_STS_SUCCESS;

253:
254: SAVEPOINT GET_TEST_TYPE_LOV_PUB;
255:
256: -- Initialize API return status to success
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: x_msg_count := 0;
259: x_msg_data := null;
260:
261: x_lov_count := 0;

Line 296: x_return_status := FND_API.G_RET_STS_ERROR ;

292: EXCEPTION
293:
294: WHEN OTHERS THEN
295: ROLLBACK TO GET_TRACE_LOV_PUB;
296: x_return_status := FND_API.G_RET_STS_ERROR ;
297: x_msg_count := 1;
298: x_err_num := SQLCODE;
299: x_err_msg := SUBSTR(SQLERRM, 1, 100);
300: x_msg_data := 'CCT_LKUP_PUB: CCT_ERROR '

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330:
331: SAVEPOINT GET_MW_LOV_PUB;
332:
333: -- Initialize API return status to success
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335: x_msg_count := 0;
336: x_msg_data := null;
337: -- API body
338: select config_name bulk collect into x_lov_data

Line 349: x_return_status := FND_API.G_RET_STS_ERROR ;

345: EXCEPTION
346:
347: WHEN OTHERS THEN
348: ROLLBACK TO GET_MW_LOV_PUB;
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: x_msg_count := 1;
351: x_err_num := SQLCODE;
352: x_err_msg := SUBSTR(SQLERRM, 1, 100);
353: x_msg_data := 'CCT_LKUP_PUB: CCT_ERROR '

Line 391: x_return_status := FND_API.G_RET_STS_SUCCESS;

387:
388: SAVEPOINT GET_ROUTE_POINT_LOV_PUB;
389:
390: -- Initialize API return status to success
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392: x_msg_count := 0;
393: x_msg_data := null;
394: -- API body
395: select config_name || ': ' || route_point_number bulk collect into x_lov_data

Line 414: x_return_status := FND_API.G_RET_STS_ERROR ;

410: EXCEPTION
411:
412: WHEN OTHERS THEN
413: ROLLBACK TO GET_ROUTE_POINT_LOV_PUB;
414: x_return_status := FND_API.G_RET_STS_ERROR ;
415: x_msg_count := 1;
416: x_err_num := SQLCODE;
417: x_err_msg := SUBSTR(SQLERRM, 1, 100);
418: x_msg_data := 'CCT_LKUP_PUB: CCT_ERROR '