DBA Data[Home] [Help]

APPS.ENG_LIFECYCLE_USER_PUB dependencies on FND_API

Line 28: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

24: PROCEDURE Check_Delete_Project_OK
25: (
26: p_api_version IN NUMBER
27: , p_project_id IN PA_PROJECTS.PROJECT_ID%TYPE
28: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
29: , x_delete_ok OUT NOCOPY VARCHAR2
30: , x_return_status OUT NOCOPY VARCHAR2
31: , x_errorcode OUT NOCOPY NUMBER
32: , x_msg_count OUT NOCOPY NUMBER

Line 54: IF NOT FND_API.Compatible_API_Call (l_api_version

50:
51: BEGIN
52:
53: --Standard checks
54: IF NOT FND_API.Compatible_API_Call (l_api_version
55: ,p_api_version
56: ,l_api_name
57: ,g_pkg_name)
58: THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: ,p_api_version
56: ,l_api_name
57: ,g_pkg_name)
58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 63: IF FND_API.To_Boolean(p_init_msg_list) THEN

59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.To_Boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.Initialize;
65: END IF;
66:
67: --Check if there are any projects referred by changes

Line 72: x_delete_ok := FND_API.G_FALSE;

68: open check_project_used(p_project_id);
69: fetch check_project_used into l_exist;
70: IF check_project_used%found
71: THEN
72: x_delete_ok := FND_API.G_FALSE;
73: l_message := 'ENG_CHNAGE_ASSOCIATED_PROJ';
74: END IF;
75:
76: IF (l_message IS NOT NULL)

Line 81: p_encoded => FND_API.G_FALSE,

77: THEN
78: FND_MESSAGE.Set_Name(g_app_name, l_message);
79: FND_MSG_PUB.Add;
80: FND_MSG_PUB.Count_And_Get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
84: );
85: x_return_status := FND_API.G_RET_STS_ERROR;

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
84: );
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: ELSE
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: END IF;
89:

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: p_data => x_msg_data
84: );
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: ELSE
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: END IF;
89:
90: EXCEPTION
91: WHEN OTHERS THEN

Line 92: x_delete_ok := FND_API.G_FALSE;

88: END IF;
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: x_delete_ok := FND_API.G_FALSE;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
95: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
96: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: x_delete_ok := FND_API.G_FALSE;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
95: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
96: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
97: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 100: p_encoded => FND_API.G_FALSE,

96: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
97: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
98: FND_MSG_PUB.Add;
99: FND_MSG_PUB.Count_And_Get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data
103: );
104:

Line 113: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

109: PROCEDURE Check_Delete_Task_OK
110: (
111: p_api_version IN NUMBER
112: , p_task_id IN PA_TASKS.TASK_ID%TYPE
113: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
114: , x_delete_ok OUT NOCOPY VARCHAR2
115: , x_return_status OUT NOCOPY VARCHAR2
116: , x_errorcode OUT NOCOPY NUMBER
117: , x_msg_count OUT NOCOPY NUMBER

Line 140: IF NOT FND_API.Compatible_API_Call (l_api_version

136:
137: BEGIN
138:
139: --Standard checks
140: IF NOT FND_API.Compatible_API_Call (l_api_version
141: ,p_api_version
142: ,l_api_name
143: ,g_pkg_name)
144: THEN

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141: ,p_api_version
142: ,l_api_name
143: ,g_pkg_name)
144: THEN
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147:
148: -- Initialize message list if p_init_msg_list is set to TRUE
149: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 149: IF FND_API.To_Boolean(p_init_msg_list) THEN

145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147:
148: -- Initialize message list if p_init_msg_list is set to TRUE
149: IF FND_API.To_Boolean(p_init_msg_list) THEN
150: FND_MSG_PUB.Initialize;
151: END IF;
152:
153: --Check if there are any projects referred by changes

Line 158: x_delete_ok := FND_API.G_FALSE;

154: open check_task_used(p_task_id);
155: fetch check_task_used into l_exist;
156: IF check_task_used%found
157: THEN
158: x_delete_ok := FND_API.G_FALSE;
159: l_message := 'ENG_CHNAGE_ASSOCIATED_TASK';
160: END IF;
161:
162: IF (l_message IS NOT NULL)

Line 167: p_encoded => FND_API.G_FALSE,

163: THEN
164: FND_MESSAGE.Set_Name(g_app_name, l_message);
165: FND_MSG_PUB.Add;
166: FND_MSG_PUB.Count_And_Get(
167: p_encoded => FND_API.G_FALSE,
168: p_count => x_msg_count,
169: p_data => x_msg_data
170: );
171: x_return_status := FND_API.G_RET_STS_ERROR;

Line 171: x_return_status := FND_API.G_RET_STS_ERROR;

167: p_encoded => FND_API.G_FALSE,
168: p_count => x_msg_count,
169: p_data => x_msg_data
170: );
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: ELSE
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174: END IF;
175:

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: p_data => x_msg_data
170: );
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: ELSE
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174: END IF;
175:
176: EXCEPTION
177: WHEN OTHERS THEN

Line 178: x_delete_ok := FND_API.G_FALSE;

174: END IF;
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: x_delete_ok := FND_API.G_FALSE;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
181: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
182: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: x_delete_ok := FND_API.G_FALSE;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
181: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
182: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
183: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 186: p_encoded => FND_API.G_FALSE,

182: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
183: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
184: FND_MSG_PUB.Add;
185: FND_MSG_PUB.Count_And_Get(
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,
188: p_data => x_msg_data
189: );
190: