DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_LIST_PUB dependencies on FND_MSG_PUB

Line 10: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_WEB_AUDIT_LIST_PUB';
9:
10: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
13: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
14: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

Line 11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;

7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_WEB_AUDIT_LIST_PUB';
9:
10: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
13: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
14: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
15: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

Line 12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_WEB_AUDIT_LIST_PUB';
9:
10: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
13: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
14: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
15: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
16:

Line 13: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

9:
10: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
13: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
14: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
15: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
16:
17: /*========================================================================

Line 14: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

10: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
13: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
14: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
15: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
16:
17: /*========================================================================
18: | PUBLIC PROCEDUDE Audit_Employee

Line 15: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
13: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
14: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
15: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
16:
17: /*========================================================================
18: | PUBLIC PROCEDUDE Audit_Employee
19: |

Line 82: FND_MSG_PUB.initialize;

78: END IF;
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list ) THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

135: COMMIT WORK;
136: END IF;
137:
138: -- Standard call to get message count and if count is 1, get message info.
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140:
141: EXCEPTION
142: WHEN FND_API.G_EXC_ERROR THEN
143: ROLLBACK TO Change_Employee_Status_PVT;

Line 145: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

141: EXCEPTION
142: WHEN FND_API.G_EXC_ERROR THEN
143: ROLLBACK TO Change_Employee_Status_PVT;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
146:
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO Change_Employee_Status_PVT;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 150: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

146:
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO Change_Employee_Status_PVT;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
151:
152: WHEN OTHERS THEN
153: ROLLBACK TO Change_Employee_Status_PVT;
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 156: IF FND_MSG_PUB.Check_Msg_Level THEN

152: WHEN OTHERS THEN
153: ROLLBACK TO Change_Employee_Status_PVT;
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155:
156: IF FND_MSG_PUB.Check_Msg_Level THEN
157: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
158: END IF;
159:
160: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

Line 157: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

153: ROLLBACK TO Change_Employee_Status_PVT;
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155:
156: IF FND_MSG_PUB.Check_Msg_Level THEN
157: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
158: END IF;
159:
160: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
161:

Line 160: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

156: IF FND_MSG_PUB.Check_Msg_Level THEN
157: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
158: END IF;
159:
160: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
161:
162: END Audit_Employee;
163:
164: /*========================================================================

Line 226: FND_MSG_PUB.initialize;

222: END IF;
223:
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list ) THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228:
229: -- Initialize API return status to success
230: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

271: COMMIT WORK;
272: END IF;
273:
274: -- Standard call to get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: ROLLBACK TO Remove_Employee_From_Audit_PVT;

Line 281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: ROLLBACK TO Remove_Employee_From_Audit_PVT;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO Remove_Employee_From_Audit_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 286: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO Remove_Employee_From_Audit_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
287:
288: WHEN OTHERS THEN
289: ROLLBACK TO Remove_Employee_From_Audit_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 292: IF FND_MSG_PUB.Check_Msg_Level THEN

288: WHEN OTHERS THEN
289: ROLLBACK TO Remove_Employee_From_Audit_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291:
292: IF FND_MSG_PUB.Check_Msg_Level THEN
293: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
294: END IF;
295:
296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

Line 293: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

289: ROLLBACK TO Remove_Employee_From_Audit_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291:
292: IF FND_MSG_PUB.Check_Msg_Level THEN
293: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
294: END IF;
295:
296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
297:

Line 296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

292: IF FND_MSG_PUB.Check_Msg_Level THEN
293: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
294: END IF;
295:
296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
297:
298: END Deaudit_Employee;
299:
300: END AP_WEB_AUDIT_LIST_PUB;