1: PACKAGE BODY CCT_LKUP_PUB as
2: /* $Header: cctplovb.pls 120.0 2005/06/02 09:06:04 appldev noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CCT_LKUP_PUB';
5:
1: PACKAGE BODY CCT_LKUP_PUB as
2: /* $Header: cctplovb.pls 120.0 2005/06/02 09:06:04 appldev noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CCT_LKUP_PUB';
5:
6:
7:
8: PROCEDURE GET_TRUE_FALSE_LOV
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 '
83: || ' ErrorCode = ' || x_err_num
84: || ' ErrorMsg = ' || x_err_msg;
85: --dbms_output.put_line(x_msg_data);
86:
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 '
142: || ' ErrorCode = ' || x_err_num
143: || ' ErrorMsg = ' || x_err_msg;
144: --dbms_output.put_line(x_msg_data);
145:
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 '
222: || ' ErrorCode = ' || x_err_num
223: || ' ErrorMsg = ' || x_err_msg;
224: --dbms_output.put_line(x_msg_data);
225:
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 '
301: || ' ErrorCode = ' || x_err_num
302: || ' ErrorMsg = ' || x_err_msg;
303: --dbms_output.put_line(x_msg_data);
304:
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 '
354: || ' ErrorCode = ' || x_err_num
355: || ' ErrorMsg = ' || x_err_msg;
356: --dbms_output.put_line(x_msg_data);
357:
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 '
419: || ' ErrorCode = ' || x_err_num
420: || ' ErrorMsg = ' || x_err_msg;
421: --dbms_output.put_line(x_msg_data);
422:
422:
423: END GET_ROUTE_POINT_LOV;
424:
425:
426: END CCT_LKUP_PUB;
427: