eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_APPR_HIST_PVT dependencies on FND_API

Line 52: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

48: -- Parameters
49: --
50: -- IN
51: -- p_api_version_number IN NUMBER Required
52: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
53: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
54: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
55: -- p_appr_hist_rec IN appr_hist_rec_type Required
56: --

Line 53: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

49: --
50: -- IN
51: -- p_api_version_number IN NUMBER Required
52: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
53: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
54: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
55: -- p_appr_hist_rec IN appr_hist_rec_type Required
56: --
57: -- OUT

Line 54: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

50: -- IN
51: -- p_api_version_number IN NUMBER Required
52: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
53: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
54: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
55: -- p_appr_hist_rec IN appr_hist_rec_type Required
56: --
57: -- OUT
58: -- x_return_status OUT VARCHAR2

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

70: -- ==============================================================================
71:
72: PROCEDURE Create_Appr_Hist(
73: p_api_version_number IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77:
78: x_return_status OUT NOCOPY VARCHAR2,

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

71:
72: PROCEDURE Create_Appr_Hist(
73: p_api_version_number IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77:
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,

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

72: PROCEDURE Create_Appr_Hist(
73: p_api_version_number IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77:
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,

Line 90: -- l_org_id NUMBER := FND_API.G_MISS_NUM;

86: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Appr_Hist';
87: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
88: l_return_status_full VARCHAR2(1);
89: l_object_version_number NUMBER := 1;
90: -- l_org_id NUMBER := FND_API.G_MISS_NUM;
91: l_object_id NUMBER;
92: l_dummy NUMBER;
93:
94: BEGIN

Line 99: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

95: -- Standard Start of API savepoint
96: SAVEPOINT create_appr_hist_pvt;
97:
98: -- Standard call to check for call compatibility.
99: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
100: p_api_version_number,
101: l_api_name,
102: G_PKG_NAME)
103: THEN

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: p_api_version_number,
101: l_api_name,
102: G_PKG_NAME)
103: THEN
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106:
107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 109: IF FND_API.to_Boolean( p_init_msg_list )

105: END IF;
106:
107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: IF FND_API.to_Boolean( p_init_msg_list )
110: THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113:

Line 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

112: END IF;
113:
114:
115: -- Initialize API return status to SUCCESS
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: -- =========================================================================
119: -- Validate Environment
120: -- =========================================================================

Line 124: RAISE FND_API.G_EXC_ERROR;

120: -- =========================================================================
121:
122: IF FND_GLOBAL.USER_ID IS NULL
123: THEN
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127:
128:

Line 129: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

125: END IF;
126:
127:
128:
129: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
130: THEN
131:
132: -- Invoke validation procedures
133: Validate_appr_hist(

Line 135: p_init_msg_list => FND_API.G_FALSE,

131:
132: -- Invoke validation procedures
133: Validate_appr_hist(
134: p_api_version_number => 1.0,
135: p_init_msg_list => FND_API.G_FALSE,
136: p_validation_level => p_validation_level,
137: p_validation_mode => JTF_PLSQL_API.g_create,
138: p_appr_hist_rec => p_appr_hist_rec,
139: x_return_status => x_return_status,

Line 144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

140: x_msg_count => x_msg_count,
141: x_msg_data => x_msg_data);
142: END IF;
143:
144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148: l_object_id := p_appr_hist_rec.object_id;

Line 145: RAISE FND_API.G_EXC_ERROR;

141: x_msg_data => x_msg_data);
142: END IF;
143:
144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148: l_object_id := p_appr_hist_rec.object_id;
149:

Line 172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

168: p_custom_setup_id => p_appr_hist_rec.custom_setup_id,
169: p_log_message => p_appr_hist_rec.log_message
170: );
171:
172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175: --
176: -- End of API body

Line 173: RAISE FND_API.G_EXC_ERROR;

169: p_log_message => p_appr_hist_rec.log_message
170: );
171:
172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175: --
176: -- End of API body
177: --

Line 180: IF FND_API.to_Boolean( p_commit )

176: -- End of API body
177: --
178:
179: -- Standard check for p_commit
180: IF FND_API.to_Boolean( p_commit )
181: THEN
182: COMMIT WORK;
183: END IF;
184:

Line 193: x_return_status := FND_API.g_ret_sts_error;

189: );
190: EXCEPTION
191:
192: WHEN AMS_Utility_PVT.resource_locked THEN
193: x_return_status := FND_API.g_ret_sts_error;
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO CREATE_Appr_Hist_PVT;
197: x_return_status := FND_API.G_RET_STS_ERROR;

Line 195: WHEN FND_API.G_EXC_ERROR THEN

191:
192: WHEN AMS_Utility_PVT.resource_locked THEN
193: x_return_status := FND_API.g_ret_sts_error;
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO CREATE_Appr_Hist_PVT;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: -- Standard call to get message count and if count=1, get the message
199: FND_MSG_PUB.Count_And_Get (

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: x_return_status := FND_API.g_ret_sts_error;
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO CREATE_Appr_Hist_PVT;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: -- Standard call to get message count and if count=1, get the message
199: FND_MSG_PUB.Count_And_Get (
200: p_encoded => FND_API.G_FALSE,
201: p_count => x_msg_count,

Line 200: p_encoded => FND_API.G_FALSE,

196: ROLLBACK TO CREATE_Appr_Hist_PVT;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: -- Standard call to get message count and if count=1, get the message
199: FND_MSG_PUB.Count_And_Get (
200: p_encoded => FND_API.G_FALSE,
201: p_count => x_msg_count,
202: p_data => x_msg_data
203: );
204:

Line 205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

201: p_count => x_msg_count,
202: p_data => x_msg_data
203: );
204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO CREATE_Appr_Hist_PVT;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: -- Standard call to get message count and if count=1, get the message
209: FND_MSG_PUB.Count_And_Get (

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203: );
204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO CREATE_Appr_Hist_PVT;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: -- Standard call to get message count and if count=1, get the message
209: FND_MSG_PUB.Count_And_Get (
210: p_encoded => FND_API.G_FALSE,
211: p_count => x_msg_count,

Line 210: p_encoded => FND_API.G_FALSE,

206: ROLLBACK TO CREATE_Appr_Hist_PVT;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: -- Standard call to get message count and if count=1, get the message
209: FND_MSG_PUB.Count_And_Get (
210: p_encoded => FND_API.G_FALSE,
211: p_count => x_msg_count,
212: p_data => x_msg_data
213: );
214:

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

213: );
214:
215: WHEN OTHERS THEN
216: ROLLBACK TO CREATE_Appr_Hist_PVT;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;

Line 224: p_encoded => FND_API.G_FALSE,

220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
227: );
228: End Create_Appr_Hist;

Line 244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

240: -- Parameters
241: --
242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_appr_hist_rec IN appr_hist_rec_type Required
248: --

Line 245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

241: --
242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_appr_hist_rec IN appr_hist_rec_type Required
248: --
249: -- OUT

Line 246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_appr_hist_rec IN appr_hist_rec_type Required
248: --
249: -- OUT
250: -- x_return_status OUT VARCHAR2

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

262: -- ==============================================================================
263:
264: PROCEDURE Update_Appr_Hist(
265: p_api_version_number IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,

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

263:
264: PROCEDURE Update_Appr_Hist(
265: p_api_version_number IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,

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

264: PROCEDURE Update_Appr_Hist(
265: p_api_version_number IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272:

Line 305: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

301: SAVEPOINT update_appr_hist_pvt;
302:
303:
304: -- Standard call to check for call compatibility.
305: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
306: p_api_version_number,
307: l_api_name,
308: G_PKG_NAME)
309: THEN

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306: p_api_version_number,
307: l_api_name,
308: G_PKG_NAME)
309: THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312:
313:
314: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 315: IF FND_API.to_Boolean( p_init_msg_list )

311: END IF;
312:
313:
314: -- Initialize message list if p_init_msg_list is set to TRUE.
315: IF FND_API.to_Boolean( p_init_msg_list )
316: THEN
317: FND_MSG_PUB.initialize;
318: END IF;
319:

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317: FND_MSG_PUB.initialize;
318: END IF;
319:
320: -- Initialize API return status to SUCCESS
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: OPEN c_get_Appr_Hist;
324:
325: FETCH c_get_Appr_Hist INTO l_ref_appr_hist_rec ;

Line 331: RAISE FND_API.G_EXC_ERROR;

327: IF ( c_get_Appr_Hist%NOTFOUND) THEN
328: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
329: p_token_name => 'INFO',
330: p_token_value => 'Appr_Hist') ;
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: CLOSE c_get_Appr_Hist;
334:
335: -- This code is commented because we are note creating or updating objects

Line 341: l_tar_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM ) Then

337: -- that was submitted for approval
338: -- API gen thought it is the object_version_number used for pseudo locking
339: /*
340: If (l_tar_appr_hist_rec.object_version_num is NULL or
341: l_tar_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM ) Then
342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
343: p_token_name => 'COLUMN',
344: p_token_value => 'Last_Update_Date') ;
345: raise FND_API.G_EXC_ERROR;

Line 345: raise FND_API.G_EXC_ERROR;

341: l_tar_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM ) Then
342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
343: p_token_name => 'COLUMN',
344: p_token_value => 'Last_Update_Date') ;
345: raise FND_API.G_EXC_ERROR;
346: End if;
347: -- Check Whether record has been changed by someone else
348: If (l_tar_appr_hist_rec.object_version_num <> l_ref_appr_hist_rec.object_version_num) Then
349: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 352: raise FND_API.G_EXC_ERROR;

348: If (l_tar_appr_hist_rec.object_version_num <> l_ref_appr_hist_rec.object_version_num) Then
349: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
350: p_token_name => 'INFO',
351: p_token_value => 'Appr_Hist') ;
352: raise FND_API.G_EXC_ERROR;
353: End if;
354:
355: */
356: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 356: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

352: raise FND_API.G_EXC_ERROR;
353: End if;
354:
355: */
356: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
357: THEN
358:
359: -- Invoke validation procedures
360: Validate_appr_hist(

Line 362: p_init_msg_list => FND_API.G_FALSE,

358:
359: -- Invoke validation procedures
360: Validate_appr_hist(
361: p_api_version_number => 1.0,
362: p_init_msg_list => FND_API.G_FALSE,
363: p_validation_level => p_validation_level,
364: p_validation_mode => JTF_PLSQL_API.g_update,
365: p_appr_hist_rec => p_appr_hist_rec,
366: x_return_status => x_return_status,

Line 371: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

367: x_msg_count => x_msg_count,
368: x_msg_data => x_msg_data);
369: END IF;
370:
371: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: -- Invoke table handler(Ams_Appr_Hist_Pkg.Update_Row)

Line 372: RAISE FND_API.G_EXC_ERROR;

368: x_msg_data => x_msg_data);
369: END IF;
370:
371: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: -- Invoke table handler(Ams_Appr_Hist_Pkg.Update_Row)
376: Ams_Appr_Hist_Pkg.Update_Row(

Line 399: IF FND_API.to_Boolean( p_commit )

395: -- End of API body.
396: --
397:
398: -- Standard check for p_commit
399: IF FND_API.to_Boolean( p_commit )
400: THEN
401: COMMIT WORK;
402: END IF;
403:

Line 416: x_return_status := FND_API.g_ret_sts_error;

412: );
413: EXCEPTION
414:
415: WHEN AMS_Utility_PVT.resource_locked THEN
416: x_return_status := FND_API.g_ret_sts_error;
417: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
418:
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO UPDATE_Appr_Hist_PVT;

Line 419: WHEN FND_API.G_EXC_ERROR THEN

415: WHEN AMS_Utility_PVT.resource_locked THEN
416: x_return_status := FND_API.g_ret_sts_error;
417: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
418:
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO UPDATE_Appr_Hist_PVT;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (

Line 421: x_return_status := FND_API.G_RET_STS_ERROR;

417: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
418:
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO UPDATE_Appr_Hist_PVT;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,

Line 424: p_encoded => FND_API.G_FALSE,

420: ROLLBACK TO UPDATE_Appr_Hist_PVT;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,
426: p_data => x_msg_data
427: );
428:

Line 429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

425: p_count => x_msg_count,
426: p_data => x_msg_data
427: );
428:
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ROLLBACK TO UPDATE_Appr_Hist_PVT;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: -- Standard call to get message count and if count=1, get the message
433: FND_MSG_PUB.Count_And_Get (

Line 431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

427: );
428:
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ROLLBACK TO UPDATE_Appr_Hist_PVT;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: -- Standard call to get message count and if count=1, get the message
433: FND_MSG_PUB.Count_And_Get (
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,

Line 434: p_encoded => FND_API.G_FALSE,

430: ROLLBACK TO UPDATE_Appr_Hist_PVT;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: -- Standard call to get message count and if count=1, get the message
433: FND_MSG_PUB.Count_And_Get (
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,
436: p_data => x_msg_data
437: );
438:

Line 441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

437: );
438:
439: WHEN OTHERS THEN
440: ROLLBACK TO UPDATE_Appr_Hist_PVT;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
445: END IF;

Line 448: p_encoded => FND_API.G_FALSE,

444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
445: END IF;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (
448: p_encoded => FND_API.G_FALSE,
449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );
452: End Update_Appr_Hist;

Line 468: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

464: -- Parameters
465: --
466: -- IN
467: -- p_api_version_number IN NUMBER Required
468: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
469: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
470: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
471: -- p_object_id IN NUMBER
472: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 469: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

465: --
466: -- IN
467: -- p_api_version_number IN NUMBER Required
468: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
469: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
470: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
471: -- p_object_id IN NUMBER
472: -- p_object_version_number IN NUMBER Optional Default = NULL
473: --

Line 470: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

466: -- IN
467: -- p_api_version_number IN NUMBER Required
468: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
469: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
470: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
471: -- p_object_id IN NUMBER
472: -- p_object_version_number IN NUMBER Optional Default = NULL
473: --
474: -- OUT

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

487: -- ==============================================================================
488:
489: PROCEDURE Delete_Appr_Hist(
490: p_api_version_number IN NUMBER,
491: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
492: p_commit IN VARCHAR2 := FND_API.G_FALSE,
493: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,

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

488:
489: PROCEDURE Delete_Appr_Hist(
490: p_api_version_number IN NUMBER,
491: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
492: p_commit IN VARCHAR2 := FND_API.G_FALSE,
493: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,

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

489: PROCEDURE Delete_Appr_Hist(
490: p_api_version_number IN NUMBER,
491: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
492: p_commit IN VARCHAR2 := FND_API.G_FALSE,
493: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: p_object_id IN NUMBER,

Line 515: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

511: -- Standard Start of API savepoint
512: SAVEPOINT delete_appr_hist_pvt;
513:
514: -- Standard call to check for call compatibility.
515: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
516: p_api_version_number,
517: l_api_name,
518: G_PKG_NAME)
519: THEN

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: p_api_version_number,
517: l_api_name,
518: G_PKG_NAME)
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523:
524: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 525: IF FND_API.to_Boolean( p_init_msg_list )

521: END IF;
522:
523:
524: -- Initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_Boolean( p_init_msg_list )
526: THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529:

Line 531: x_return_status := FND_API.G_RET_STS_SUCCESS;

527: FND_MSG_PUB.initialize;
528: END IF;
529:
530: -- Initialize API return status to SUCCESS
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532:
533: -- Invoke table handler(Ams_Appr_Hist_Pkg.Delete_Row)
534: Ams_Appr_Hist_Pkg.Delete_Row(
535: p_object_id => p_object_id,

Line 546: IF FND_API.to_Boolean( p_commit )

542: -- End of API body
543: --
544:
545: -- Standard check for p_commit
546: IF FND_API.to_Boolean( p_commit )
547: THEN
548: COMMIT WORK;
549: END IF;
550:

Line 559: x_return_status := FND_API.g_ret_sts_error;

555: );
556: EXCEPTION
557:
558: WHEN AMS_Utility_PVT.resource_locked THEN
559: x_return_status := FND_API.g_ret_sts_error;
560:
561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO DELETE_Appr_Hist_PVT;
563: x_return_status := FND_API.G_RET_STS_ERROR;

Line 561: WHEN FND_API.G_EXC_ERROR THEN

557:
558: WHEN AMS_Utility_PVT.resource_locked THEN
559: x_return_status := FND_API.g_ret_sts_error;
560:
561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO DELETE_Appr_Hist_PVT;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: x_return_status := FND_API.g_ret_sts_error;
560:
561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO DELETE_Appr_Hist_PVT;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,

Line 566: p_encoded => FND_API.G_FALSE,

562: ROLLBACK TO DELETE_Appr_Hist_PVT;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,
568: p_data => x_msg_data
569: );
570:

Line 571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

567: p_count => x_msg_count,
568: p_data => x_msg_data
569: );
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO DELETE_Appr_Hist_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: );
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO DELETE_Appr_Hist_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,

Line 576: p_encoded => FND_API.G_FALSE,

572: ROLLBACK TO DELETE_Appr_Hist_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );
580:

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

579: );
580:
581: WHEN OTHERS THEN
582: ROLLBACK TO DELETE_Appr_Hist_PVT;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
587: END IF;

Line 590: p_encoded => FND_API.G_FALSE,

586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
587: END IF;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data
593: );
594: End Delete_Appr_Hist;

Line 604: x_return_status := FND_API.g_ret_sts_success;

600: IS
601: l_valid_flag VARCHAR2(1);
602:
603: BEGIN
604: x_return_status := FND_API.g_ret_sts_success;
605: /*
606: IF p_validation_mode = JTF_PLSQL_API.g_create
607: AND p_appr_hist_rec.object_id IS NOT NULL
608: THEN

Line 615: IF l_valid_flag = FND_API.g_false THEN

611: 'object_id = ''' || p_appr_hist_rec.object_id ||''''
612: );
613: END IF;
614:
615: IF l_valid_flag = FND_API.g_false THEN
616: x_return_status := FND_API.g_ret_sts_error;
617: END IF;
618: */
619: END check_Appr_Hist_Uk_Items;

Line 616: x_return_status := FND_API.g_ret_sts_error;

612: );
613: END IF;
614:
615: IF l_valid_flag = FND_API.g_false THEN
616: x_return_status := FND_API.g_ret_sts_error;
617: END IF;
618: */
619: END check_Appr_Hist_Uk_Items;
620:

Line 630: x_return_status := FND_API.g_ret_sts_success;

626: x_return_status OUT NOCOPY VARCHAR2
627: )
628: IS
629: BEGIN
630: x_return_status := FND_API.g_ret_sts_success;
631:
632: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
633:
634:

Line 635: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_id IS NULL THEN

631:
632: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
633:
634:
635: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_id IS NULL THEN
636: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );
637: x_return_status := FND_API.g_ret_sts_error;
638: END IF;
639:

Line 637: x_return_status := FND_API.g_ret_sts_error;

633:
634:
635: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_id IS NULL THEN
636: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );
637: x_return_status := FND_API.g_ret_sts_error;
638: END IF;
639:
640:
641: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char OR p_appr_hist_rec.object_type_code IS NULL THEN

Line 641: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char OR p_appr_hist_rec.object_type_code IS NULL THEN

637: x_return_status := FND_API.g_ret_sts_error;
638: END IF;
639:
640:
641: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char OR p_appr_hist_rec.object_type_code IS NULL THEN
642: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
643: x_return_status := FND_API.g_ret_sts_error;
644: END IF;
645:

Line 643: x_return_status := FND_API.g_ret_sts_error;

639:
640:
641: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char OR p_appr_hist_rec.object_type_code IS NULL THEN
642: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
643: x_return_status := FND_API.g_ret_sts_error;
644: END IF;
645:
646:
647: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.sequence_num IS NULL THEN

Line 647: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.sequence_num IS NULL THEN

643: x_return_status := FND_API.g_ret_sts_error;
644: END IF;
645:
646:
647: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.sequence_num IS NULL THEN
648: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
649: x_return_status := FND_API.g_ret_sts_error;
650: END IF;
651:

Line 649: x_return_status := FND_API.g_ret_sts_error;

645:
646:
647: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.sequence_num IS NULL THEN
648: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
649: x_return_status := FND_API.g_ret_sts_error;
650: END IF;
651:
652:
653: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_version_num IS NULL THEN

Line 653: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_version_num IS NULL THEN

649: x_return_status := FND_API.g_ret_sts_error;
650: END IF;
651:
652:
653: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_version_num IS NULL THEN
654: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );
655: x_return_status := FND_API.g_ret_sts_error;
656: END IF;
657:

Line 655: x_return_status := FND_API.g_ret_sts_error;

651:
652:
653: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_version_num IS NULL THEN
654: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );
655: x_return_status := FND_API.g_ret_sts_error;
656: END IF;
657:
658:
659: ELSE

Line 662: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM THEN

658:
659: ELSE
660:
661:
662: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM THEN
663: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );
664: x_return_status := FND_API.g_ret_sts_error;
665: END IF;
666:

Line 664: x_return_status := FND_API.g_ret_sts_error;

660:
661:
662: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM THEN
663: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );
664: x_return_status := FND_API.g_ret_sts_error;
665: END IF;
666:
667:
668: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char THEN

Line 668: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char THEN

664: x_return_status := FND_API.g_ret_sts_error;
665: END IF;
666:
667:
668: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char THEN
669: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
670: x_return_status := FND_API.g_ret_sts_error;
671: END IF;
672:

Line 670: x_return_status := FND_API.g_ret_sts_error;

666:
667:
668: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char THEN
669: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
670: x_return_status := FND_API.g_ret_sts_error;
671: END IF;
672:
673:
674: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM THEN

Line 674: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM THEN

670: x_return_status := FND_API.g_ret_sts_error;
671: END IF;
672:
673:
674: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM THEN
675: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
676: x_return_status := FND_API.g_ret_sts_error;
677: END IF;
678:

Line 676: x_return_status := FND_API.g_ret_sts_error;

672:
673:
674: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM THEN
675: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
676: x_return_status := FND_API.g_ret_sts_error;
677: END IF;
678:
679:
680: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM THEN

Line 680: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM THEN

676: x_return_status := FND_API.g_ret_sts_error;
677: END IF;
678:
679:
680: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM THEN
681: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );
682: x_return_status := FND_API.g_ret_sts_error;
683: END IF;
684: END IF;

Line 682: x_return_status := FND_API.g_ret_sts_error;

678:
679:
680: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM THEN
681: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );
682: x_return_status := FND_API.g_ret_sts_error;
683: END IF;
684: END IF;
685:
686: END check_Appr_Hist_Req_Items;

Line 696: x_return_status := FND_API.g_ret_sts_success;

692: x_return_status OUT NOCOPY VARCHAR2
693: )
694: IS
695: BEGIN
696: x_return_status := FND_API.g_ret_sts_success;
697:
698: -- Enter custom code here
699:
700: END check_Appr_Hist_Fk_Items;

Line 710: x_return_status := FND_API.g_ret_sts_success;

706: x_return_status OUT NOCOPY VARCHAR2
707: )
708: IS
709: BEGIN
710: x_return_status := FND_API.g_ret_sts_success;
711:
712: -- Enter custom code here
713:
714: END check_Appr_Hist_Lookup_Items;

Line 727: l_return_status := FND_API.g_ret_sts_success;

723: IS
724: l_return_status VARCHAR2(1);
725: BEGIN
726:
727: l_return_status := FND_API.g_ret_sts_success;
728: -- Check Items Uniqueness API calls
729:
730: check_Appr_hist_Uk_Items(
731: p_appr_hist_rec => p_appr_hist_rec,

Line 734: IF x_return_status <> FND_API.g_ret_sts_success THEN

730: check_Appr_hist_Uk_Items(
731: p_appr_hist_rec => p_appr_hist_rec,
732: p_validation_mode => p_validation_mode,
733: x_return_status => x_return_status);
734: IF x_return_status <> FND_API.g_ret_sts_success THEN
735: l_return_status := FND_API.g_ret_sts_error;
736: END IF;
737:
738: -- Check Items Required/NOT NULL API calls

Line 735: l_return_status := FND_API.g_ret_sts_error;

731: p_appr_hist_rec => p_appr_hist_rec,
732: p_validation_mode => p_validation_mode,
733: x_return_status => x_return_status);
734: IF x_return_status <> FND_API.g_ret_sts_success THEN
735: l_return_status := FND_API.g_ret_sts_error;
736: END IF;
737:
738: -- Check Items Required/NOT NULL API calls
739:

Line 744: IF x_return_status <> FND_API.g_ret_sts_success THEN

740: check_appr_hist_req_items(
741: p_appr_hist_rec => p_appr_hist_rec,
742: p_validation_mode => p_validation_mode,
743: x_return_status => x_return_status);
744: IF x_return_status <> FND_API.g_ret_sts_success THEN
745: l_return_status := FND_API.g_ret_sts_error;
746: END IF;
747: -- Check Items Foreign Keys API calls
748:

Line 745: l_return_status := FND_API.g_ret_sts_error;

741: p_appr_hist_rec => p_appr_hist_rec,
742: p_validation_mode => p_validation_mode,
743: x_return_status => x_return_status);
744: IF x_return_status <> FND_API.g_ret_sts_success THEN
745: l_return_status := FND_API.g_ret_sts_error;
746: END IF;
747: -- Check Items Foreign Keys API calls
748:
749: check_appr_hist_FK_items(

Line 752: IF x_return_status <> FND_API.g_ret_sts_success THEN

748:
749: check_appr_hist_FK_items(
750: p_appr_hist_rec => p_appr_hist_rec,
751: x_return_status => x_return_status);
752: IF x_return_status <> FND_API.g_ret_sts_success THEN
753: l_return_status := FND_API.g_ret_sts_error;
754: END IF;
755: -- Check Items Lookups
756:

Line 753: l_return_status := FND_API.g_ret_sts_error;

749: check_appr_hist_FK_items(
750: p_appr_hist_rec => p_appr_hist_rec,
751: x_return_status => x_return_status);
752: IF x_return_status <> FND_API.g_ret_sts_success THEN
753: l_return_status := FND_API.g_ret_sts_error;
754: END IF;
755: -- Check Items Lookups
756:
757: check_appr_hist_Lookup_items(

Line 760: IF x_return_status <> FND_API.g_ret_sts_success THEN

756:
757: check_appr_hist_Lookup_items(
758: p_appr_hist_rec => p_appr_hist_rec,
759: x_return_status => x_return_status);
760: IF x_return_status <> FND_API.g_ret_sts_success THEN
761: l_return_status := FND_API.g_ret_sts_error;
762: END IF;
763:
764: x_return_status := l_return_status;

Line 761: l_return_status := FND_API.g_ret_sts_error;

757: check_appr_hist_Lookup_items(
758: p_appr_hist_rec => p_appr_hist_rec,
759: x_return_status => x_return_status);
760: IF x_return_status <> FND_API.g_ret_sts_success THEN
761: l_return_status := FND_API.g_ret_sts_error;
762: END IF;
763:
764: x_return_status := l_return_status;
765:

Line 894: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN

890: l_appr_hist_rec appr_hist_rec_type := p_appr_hist_rec;
891: BEGIN
892: -- Developers should put their code to default the record type
893: -- e.g. IF p_campaign_rec.status_code IS NULL
894: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
895: -- l_campaign_rec.status_code := 'NEW' ;
896: -- END IF ;
897: --
898: NULL ;

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

902:
903:
904: PROCEDURE Validate_Appr_Hist(
905: p_api_version_number IN NUMBER,
906: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
907: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
908: p_appr_hist_rec IN appr_hist_rec_type,
909: p_validation_mode IN VARCHAR2,
910: x_return_status OUT NOCOPY VARCHAR2,

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

903:
904: PROCEDURE Validate_Appr_Hist(
905: p_api_version_number IN NUMBER,
906: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
907: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
908: p_appr_hist_rec IN appr_hist_rec_type,
909: p_validation_mode IN VARCHAR2,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_msg_count OUT NOCOPY NUMBER,

Line 925: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

921: -- Standard Start of API savepoint
922: SAVEPOINT validate_appr_hist_;
923:
924: -- Standard call to check for call compatibility.
925: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
926: p_api_version_number,
927: l_api_name,
928: G_PKG_NAME)
929: THEN

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926: p_api_version_number,
927: l_api_name,
928: G_PKG_NAME)
929: THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933:
934: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 935: IF FND_API.to_Boolean( p_init_msg_list )

931: END IF;
932:
933:
934: -- Initialize message list if p_init_msg_list is set to TRUE.
935: IF FND_API.to_Boolean( p_init_msg_list )
936: THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:

Line 949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

945: p_validation_mode => p_validation_mode,
946: x_return_status => x_return_status
947: );
948:
949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
950: RAISE FND_API.G_EXC_ERROR;
951: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;

Line 950: RAISE FND_API.G_EXC_ERROR;

946: x_return_status => x_return_status
947: );
948:
949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
950: RAISE FND_API.G_EXC_ERROR;
951: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;
954: END IF;

Line 951: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

947: );
948:
949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
950: RAISE FND_API.G_EXC_ERROR;
951: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;
954: END IF;
955:

Line 952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

948:
949: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
950: RAISE FND_API.G_EXC_ERROR;
951: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;
954: END IF;
955:
956: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 970: p_init_msg_list => FND_API.G_FALSE,

966:
967: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
968: Validate_appr_hist_Rec(
969: p_api_version_number => 1.0,
970: p_init_msg_list => FND_API.G_FALSE,
971: x_return_status => x_return_status,
972: x_msg_count => x_msg_count,
973: x_msg_data => x_msg_data,
974: p_appr_hist_rec => l_appr_hist_rec);

Line 976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

972: x_msg_count => x_msg_count,
973: x_msg_data => x_msg_data,
974: p_appr_hist_rec => l_appr_hist_rec);
975:
976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
977: RAISE FND_API.G_EXC_ERROR;
978: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;

Line 977: RAISE FND_API.G_EXC_ERROR;

973: x_msg_data => x_msg_data,
974: p_appr_hist_rec => l_appr_hist_rec);
975:
976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
977: RAISE FND_API.G_EXC_ERROR;
978: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: END IF;

Line 978: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

974: p_appr_hist_rec => l_appr_hist_rec);
975:
976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
977: RAISE FND_API.G_EXC_ERROR;
978: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: END IF;
982:

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975:
976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
977: RAISE FND_API.G_EXC_ERROR;
978: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: END IF;
982:
983: -- Initialize API return status to SUCCESS

Line 984: x_return_status := FND_API.G_RET_STS_SUCCESS;

980: END IF;
981: END IF;
982:
983: -- Initialize API return status to SUCCESS
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985:
986: -- Standard call to get message count and if count is 1, get message info.
987: FND_MSG_PUB.Count_And_Get
988: (p_count => x_msg_count,

Line 994: x_return_status := FND_API.g_ret_sts_error;

990: );
991: EXCEPTION
992:
993: WHEN AMS_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
996:
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO VALIDATE_Appr_Hist_;

Line 997: WHEN FND_API.G_EXC_ERROR THEN

993: WHEN AMS_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
996:
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO VALIDATE_Appr_Hist_;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (

Line 999: x_return_status := FND_API.G_RET_STS_ERROR;

995: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
996:
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO VALIDATE_Appr_Hist_;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,

Line 1002: p_encoded => FND_API.G_FALSE,

998: ROLLBACK TO VALIDATE_Appr_Hist_;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );
1006:

Line 1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );
1006:
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO VALIDATE_Appr_Hist_;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (

Line 1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1005: );
1006:
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO VALIDATE_Appr_Hist_;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,

Line 1012: p_encoded => FND_API.G_FALSE,

1008: ROLLBACK TO VALIDATE_Appr_Hist_;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );
1016:

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1015: );
1016:
1017: WHEN OTHERS THEN
1018: ROLLBACK TO VALIDATE_Appr_Hist_;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;

Line 1026: p_encoded => FND_API.G_FALSE,

1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );
1030: End Validate_Appr_Hist;

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

1031:
1032:
1033: PROCEDURE Validate_Appr_Hist_Rec (
1034: p_api_version_number IN NUMBER,
1035: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1036: x_return_status OUT NOCOPY VARCHAR2,
1037: x_msg_count OUT NOCOPY NUMBER,
1038: x_msg_data OUT NOCOPY VARCHAR2,
1039: p_appr_hist_rec IN appr_hist_rec_type

Line 1044: IF FND_API.to_Boolean( p_init_msg_list )

1040: )
1041: IS
1042: BEGIN
1043: -- Initialize message list if p_init_msg_list is set to TRUE.
1044: IF FND_API.to_Boolean( p_init_msg_list )
1045: THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:

Line 1052: x_return_status := FND_API.G_RET_STS_SUCCESS;

1048:
1049:
1050:
1051: -- Initialize API return status to SUCCESS
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054: -- Hint: Validate data
1055: -- If data not valid
1056: -- THEN

Line 1057: -- x_return_status := FND_API.G_RET_STS_ERROR;

1053:
1054: -- Hint: Validate data
1055: -- If data not valid
1056: -- THEN
1057: -- x_return_status := FND_API.G_RET_STS_ERROR;
1058:
1059: -- Standard call to get message count and if count is 1, get message info.
1060: FND_MSG_PUB.Count_And_Get
1061: (p_count => x_msg_count,