DBA Data[Home] [Help]

APPS.JTF_HOOK_DATA_PUB dependencies on STANDARD

Line 22: --******** local variable for standards **********

18: x_msg_count OUT NUMBER,
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;

Line 34: -- ******* Standard Begins ********

30: l_exe_order NUMBER :=NULL;
31: CURSOR C IS SELECT JTF_USER_HOOKS_S.NEXTVAL FROM sys.dual;
32:
33: BEGIN
34: -- ******* Standard Begins ********
35:
36: -- Standard Start of API savepoint
37: SAVEPOINT JTF_HOOK_DATA_PUB_INSERT;
38:

Line 36: -- Standard Start of API savepoint

32:
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)

Line 39: -- -- Standard call to check for call compatibility.

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
42: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: -- END IF;

Line 110: -- ******** Standard Ends ***********

106:
107:
108: --*********************
109:
110: -- ******** Standard Ends ***********
111: --
112: -- End of main API body.
113:
114: -- Standard check of p_commit.

Line 114: -- Standard check of p_commit.

110: -- ******** Standard Ends ***********
111: --
112: -- End of main API body.
113:
114: -- Standard check of p_commit.
115: IF (FND_API.To_Boolean(p_commit)) THEN
116: COMMIT WORK;
117: END IF;
118:

Line 119: -- Standard call to get message count and if count is 1, get message info.

115: IF (FND_API.To_Boolean(p_commit)) THEN
116: COMMIT WORK;
117: END IF;
118:
119: -- Standard call to get message count and if count is 1, get message info.
120: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
121: p_data => x_msg_data );
122:
123: EXCEPTION