APPS.JTF_HOOK_DATA_PUB dependencies on JTF_HOOK_DATA_PUB

Line 1: Package Body JTF_HOOK_DATA_PUB AS

1: Package Body JTF_HOOK_DATA_PUB AS
2: /* $Header: jtfpihdb.pls 115.6 2000/11/21 09:31:49 pkm ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_HOOK_DATA_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpihdb.pls';

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

1: Package Body JTF_HOOK_DATA_PUB AS
2: /* $Header: jtfpihdb.pls 115.6 2000/11/21 09:31:49 pkm ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_HOOK_DATA_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpihdb.pls';
6:
7: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 10: PROCEDURE JTF_HOOK_DATA_PUB_INSERT (

6:
7: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9:
10: PROCEDURE JTF_HOOK_DATA_PUB_INSERT (
11: p_api_version_number IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR := FND_API.G_FALSE,
14:

Line 23: l_api_name CONSTANT VARCHAR2(30) := 'JTF_HOOK_DATA_PUB_INSERT';

19: x_msg_data OUT VARCHAR2
20: )
21: AS
22: --******** local variable for standards **********
23: l_api_name CONSTANT VARCHAR2(30) := 'JTF_HOOK_DATA_PUB_INSERT';
24: l_api_version_number NUMBER := p_api_version_number;
25: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
26: l_commit VARCHAR2(1) := FND_API.G_FALSE;
27: l_object_version_number NUMBER :=NULL;

Line 37: SAVEPOINT JTF_HOOK_DATA_PUB_INSERT;

33: BEGIN
34: -- ******* Standard Begins ********
35:
36: -- Standard Start of API savepoint
37: SAVEPOINT JTF_HOOK_DATA_PUB_INSERT;
38:
39: -- -- Standard call to check for call compatibility.
40: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
41: -- THEN

Line 127: ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;

123: EXCEPTION
124:
125: WHEN FND_API.G_EXC_ERROR THEN
126:
127: ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;
128: x_return_status := FND_API.G_RET_STS_ERROR ;
129:
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,

Line 136: ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;

132: p_data => x_msg_data );
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135:
136: ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data );

Line 145: ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;

141:
142:
143: WHEN OTHERS THEN
144:
145: ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147:
148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
149: THEN

Line 157: END JTF_HOOK_DATA_PUB_INSERT;

153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data );
156:
157: END JTF_HOOK_DATA_PUB_INSERT;
158:
159: END JTF_HOOK_DATA_PUB;

Line 159: END JTF_HOOK_DATA_PUB;

155: p_data => x_msg_data );
156:
157: END JTF_HOOK_DATA_PUB_INSERT;
158:
159: END JTF_HOOK_DATA_PUB;