APPS.CCT_IH_PUB dependencies on CCT_IH_PUB

Line 1: PACKAGE BODY CCT_IH_PUB AS

1: PACKAGE BODY CCT_IH_PUB AS
2: /* $Header: cctpihb.pls 115.1 2003/02/19 02:29:40 svinamda noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CCT_IH_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CCT_IH_PUB';

1: PACKAGE BODY CCT_IH_PUB AS
2: /* $Header: cctpihb.pls 115.1 2003/02/19 02:29:40 svinamda noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CCT_IH_PUB';
5:
6:
7: PROCEDURE OPEN_MEDIA_ITEM
8: ( p_api_version IN NUMBER,

Line 82: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '

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_IH_PUB: CCT_ERROR '
83: || ' ErrorCode = ' || x_err_num
84: || ' ErrorMsg = ' || x_err_msg;
85: --dbms_output.put_line(x_msg_data);
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 92: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '

88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
89: x_msg_count := 1;
90: x_err_num := SQLCODE;
91: x_err_msg := SUBSTR(SQLERRM, 1, 100);
92: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '
93: || ' ErrorCode = ' || x_err_num
94: || ' ErrorMsg = ' || x_err_msg;
95: --dbms_output.put_line(x_msg_data);
96: WHEN OTHERS THEN

Line 102: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '

98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: x_msg_count := 1;
100: x_err_num := SQLCODE;
101: x_err_msg := SUBSTR(SQLERRM, 1, 100);
102: x_msg_data := 'CCT_IH_PUB: CCT_ERROR '
103: || ' ErrorCode = ' || x_err_num
104: || ' ErrorMsg = ' || x_err_msg;
105: --dbms_output.put_line(x_msg_data);
106: END OPEN_MEDIA_ITEM;

Line 108: END CCT_IH_PUB;

104: || ' ErrorMsg = ' || x_err_msg;
105: --dbms_output.put_line(x_msg_data);
106: END OPEN_MEDIA_ITEM;
107:
108: END CCT_IH_PUB;