APPS.AP_WEB_AUDIT_LIST_PUB dependencies on FND_API

Line 50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

46: | 05-Dec-2002 J Rautiainen Created
47: |
48: *=======================================================================*/
49: PROCEDURE Audit_Employee(p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,

Line 51: p_commit IN VARCHAR2 := FND_API.G_FALSE,

47: |
48: *=======================================================================*/
49: PROCEDURE Audit_Employee(p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,

Line 52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

48: *=======================================================================*/
49: PROCEDURE Audit_Employee(p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_emp_rec IN Employee_Rec_Type,

Line 72: IF NOT FND_API.Compatible_API_Call(l_api_version,

68: -- Standard Start of API savepoint
69: SAVEPOINT Change_Employee_Status_PVT;
70:
71: -- Standard call to check for call compatibility.
72: IF NOT FND_API.Compatible_API_Call(l_api_version,
73: p_api_version,
74: l_api_name,
75: G_PKG_NAME) THEN
76:

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73: p_api_version,
74: l_api_name,
75: G_PKG_NAME) THEN
76:
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 81: IF FND_API.to_Boolean( p_init_msg_list ) THEN

77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
87:
88: l_emp_rec := p_emp_rec;
89: l_audit_rec := p_audit_rec;
90:

Line 97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

93: l_audit_rec,
94: l_return_status);
95:
96: -- If any errors happen abort API.
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;

Line 98: RAISE FND_API.G_EXC_ERROR;

94: l_return_status);
95:
96: -- If any errors happen abort API.
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:

Line 99: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

95:
96: -- If any errors happen abort API.
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Validate employee information

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: -- If any errors happen abort API.
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Validate employee information
104: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Employee_Info(l_emp_rec,

Line 107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

103: -- Validate employee information
104: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Employee_Info(l_emp_rec,
105: l_return_status);
106: -- If any errors happen abort API.
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;

Line 108: RAISE FND_API.G_EXC_ERROR;

104: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Employee_Info(l_emp_rec,
105: l_return_status);
106: -- If any errors happen abort API.
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:

Line 109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

105: l_return_status);
106: -- If any errors happen abort API.
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: -- Validate audit information

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

106: -- If any errors happen abort API.
107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: -- Validate audit information
114: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Audit_Info(l_emp_rec,

Line 118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

114: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Audit_Info(l_emp_rec,
115: l_audit_rec,
116: l_return_status);
117: -- If any errors happen abort API.
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;

Line 119: RAISE FND_API.G_EXC_ERROR;

115: l_audit_rec,
116: l_return_status);
117: -- If any errors happen abort API.
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:

Line 120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

116: l_return_status);
117: -- If any errors happen abort API.
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- If validations succesful, add employee to the audit list

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117: -- If any errors happen abort API.
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- If validations succesful, add employee to the audit list
125: AP_WEB_AUDIT_LIST_PVT.process_entry(l_emp_rec,

Line 134: IF FND_API.To_Boolean( p_commit ) THEN

130: -- Set OUT values
131: x_auto_audit_id := l_auto_audit_id;
132:
133: -- Standard check of p_commit.
134: IF FND_API.To_Boolean( p_commit ) THEN
135: COMMIT WORK;
136: END IF;
137:
138: -- Standard call to get message count and if count is 1, get message info.

Line 142: WHEN FND_API.G_EXC_ERROR THEN

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;
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:

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140:
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;

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 147: WHEN FND_API.G_EXC_UNEXPECTED_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;
150: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
151:

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

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 154: 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 ;
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;

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 196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

192: | 29-Jun-2004 J Rautiainen Created
193: |
194: *=======================================================================*/
195: PROCEDURE Deaudit_Employee(p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,

Line 197: p_commit IN VARCHAR2 := FND_API.G_FALSE,

193: |
194: *=======================================================================*/
195: PROCEDURE Deaudit_Employee(p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,

Line 198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

194: *=======================================================================*/
195: PROCEDURE Deaudit_Employee(p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_emp_rec IN Employee_Rec_Type,

Line 216: IF NOT FND_API.Compatible_API_Call(l_api_version,

212: -- Standard Start of API savepoint
213: SAVEPOINT Remove_Employee_From_Audit_PVT;
214:
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call(l_api_version,
217: p_api_version,
218: l_api_name,
219: G_PKG_NAME) THEN
220:

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: p_api_version,
218: l_api_name,
219: G_PKG_NAME) THEN
220:
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 225: IF FND_API.to_Boolean( p_init_msg_list ) THEN

221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
231:
232: l_emp_rec := p_emp_rec;
233: l_date_range_rec := p_date_range_rec;
234:

Line 241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

237: l_date_range_rec,
238: l_return_status);
239:
240: -- If any errors happen abort API.
241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: RAISE FND_API.G_EXC_ERROR;
243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;

Line 242: RAISE FND_API.G_EXC_ERROR;

238: l_return_status);
239:
240: -- If any errors happen abort API.
241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: RAISE FND_API.G_EXC_ERROR;
243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:

Line 243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

239:
240: -- If any errors happen abort API.
241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: RAISE FND_API.G_EXC_ERROR;
243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: -- Validate employee information

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: -- If any errors happen abort API.
241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: RAISE FND_API.G_EXC_ERROR;
243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: -- Validate employee information
248: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Employee_Info(l_emp_rec,

Line 251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

247: -- Validate employee information
248: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Employee_Info(l_emp_rec,
249: l_return_status);
250: -- If any errors happen abort API.
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;

Line 252: RAISE FND_API.G_EXC_ERROR;

248: AP_WEB_AUDIT_LIST_VAL_PVT.Validate_Employee_Info(l_emp_rec,
249: l_return_status);
250: -- If any errors happen abort API.
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:

Line 253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

249: l_return_status);
250: -- If any errors happen abort API.
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: -- If any errors happen abort API.

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: -- If any errors happen abort API.
251: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: -- If any errors happen abort API.
258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: -- If any errors happen abort API.
258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;

Line 259: RAISE FND_API.G_EXC_ERROR;

255: END IF;
256:
257: -- If any errors happen abort API.
258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:

Line 260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

256:
257: -- If any errors happen abort API.
258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- If validations succesful, add employee to the audit list

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: -- If any errors happen abort API.
258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- If validations succesful, add employee to the audit list
265: AP_WEB_AUDIT_LIST_PVT.remove_entries(l_emp_rec,

Line 270: IF FND_API.To_Boolean( p_commit ) THEN

266: l_date_range_rec,
267: l_return_status);
268:
269: -- Standard check of p_commit.
270: IF FND_API.To_Boolean( p_commit ) THEN
271: COMMIT WORK;
272: END IF;
273:
274: -- Standard call to get message count and if count is 1, get message info.

Line 278: WHEN FND_API.G_EXC_ERROR THEN

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;
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:

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276:
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;

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 283: WHEN FND_API.G_EXC_UNEXPECTED_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;
286: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
287:

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

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 290: 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 ;
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;

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;