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.OZF_NA_DDN_RULE_PVT dependencies on FND_API

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

57: -- Parameters
58: --
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
65: --

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

58: --
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
65: --
66: -- OUT

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

59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
65: --
66: -- OUT
67: -- x_return_status OUT VARCHAR2

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

79: -- ==============================================================================
80:
81: PROCEDURE Create_Na_Ddn_Rule(
82: p_api_version_number IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86:
87: x_return_status OUT NOCOPY VARCHAR2,

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

80:
81: PROCEDURE Create_Na_Ddn_Rule(
82: p_api_version_number IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86:
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,

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

81: PROCEDURE Create_Na_Ddn_Rule(
82: p_api_version_number IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86:
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,

Line 100: l_org_id NUMBER := FND_API.G_MISS_NUM;

96: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Na_Ddn_Rule';
97: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
98: l_return_status_full VARCHAR2(1);
99: l_object_version_number NUMBER := 1;
100: l_org_id NUMBER := FND_API.G_MISS_NUM;
101: l_na_deduction_rule_id NUMBER;
102: l_dummy NUMBER;
103: CURSOR c_id IS
104: SELECT ozf_na_deduction_rules_b_s.NEXTVAL

Line 118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

114: -- Standard Start of API savepoint
115: SAVEPOINT create_na_ddn_rule_pvt;
116:
117: -- Standard call to check for call compatibility.
118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
119: p_api_version_number,
120: l_api_name,
121: G_PKG_NAME)
122: THEN

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: p_api_version_number,
120: l_api_name,
121: G_PKG_NAME)
122: THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:
126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 128: IF FND_API.to_Boolean( p_init_msg_list )

124: END IF;
125:
126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list )
129: THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

137:
138:
139:
140: -- Initialize API return status to SUCCESS
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:
143: -- =========================================================================
144: -- Validate Environment
145: -- =========================================================================

Line 150: RAISE FND_API.G_EXC_ERROR;

146:
147: IF FND_GLOBAL.USER_ID IS NULL
148: THEN
149: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153:
154: IF p_na_ddn_rule_rec.na_deduction_rule_id IS NULL OR p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.g_miss_num THEN

Line 154: IF p_na_ddn_rule_rec.na_deduction_rule_id IS NULL OR p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.g_miss_num THEN

150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153:
154: IF p_na_ddn_rule_rec.na_deduction_rule_id IS NULL OR p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.g_miss_num THEN
155: LOOP
156: l_dummy := NULL;
157: OPEN c_id;
158: FETCH c_id INTO l_na_deduction_rule_id;

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

169:
170:
171: l_na_ddn_rule_rec := p_na_ddn_rule_rec;
172: l_na_ddn_rule_rec.na_deduction_rule_id := l_na_deduction_rule_id;
173: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
174: THEN
175: -- Debug message
176: debug_message('Private API: Validate_Na_Ddn_Rule');
177:

Line 181: p_init_msg_list => FND_API.G_FALSE,

177:
178: -- Invoke validation procedures
179: Validate_na_ddn_rule(
180: p_api_version_number => 1.0,
181: p_init_msg_list => FND_API.G_FALSE,
182: p_validation_level => p_validation_level,
183: p_validation_mode => JTF_PLSQL_API.g_create,
184: p_na_ddn_rule_rec => l_na_ddn_rule_rec,
185: x_return_status => x_return_status,

Line 190: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

186: x_msg_count => x_msg_count,
187: x_msg_data => x_msg_data);
188: END IF;
189:
190: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193:
194: -- Local variable initialization

Line 191: RAISE FND_API.G_EXC_ERROR;

187: x_msg_data => x_msg_data);
188: END IF;
189:
190: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193:
194: -- Local variable initialization
195:

Line 217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

213: p_description => l_na_ddn_rule_rec.description
214: );
215:
216: x_na_deduction_rule_id := l_na_deduction_rule_id;
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: --
221: -- End of API body

Line 218: RAISE FND_API.G_EXC_ERROR;

214: );
215:
216: x_na_deduction_rule_id := l_na_deduction_rule_id;
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: --
221: -- End of API body
222: --

Line 225: IF FND_API.to_Boolean( p_commit )

221: -- End of API body
222: --
223:
224: -- Standard check for p_commit
225: IF FND_API.to_Boolean( p_commit )
226: THEN
227: COMMIT WORK;
228: END IF;
229:

Line 243: x_return_status := FND_API.g_ret_sts_error;

239: );
240: EXCEPTION
241:
242: WHEN OZF_Utility_PVT.resource_locked THEN
243: x_return_status := FND_API.g_ret_sts_error;
244: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
245:
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;

Line 246: WHEN FND_API.G_EXC_ERROR THEN

242: WHEN OZF_Utility_PVT.resource_locked THEN
243: x_return_status := FND_API.g_ret_sts_error;
244: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
245:
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
245:
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,

Line 251: p_encoded => FND_API.G_FALSE,

247: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255:

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252: p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

254: );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,

Line 261: p_encoded => FND_API.G_FALSE,

257: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265:

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

264: );
265:
266: WHEN OTHERS THEN
267: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
270: THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
272: END IF;

Line 275: p_encoded => FND_API.G_FALSE,

271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
272: END IF;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279: End Create_Na_Ddn_Rule;

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

291: -- Parameters
292: --
293: -- IN
294: -- p_api_version_number IN NUMBER Required
295: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
296: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
297: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
298: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
299: --

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

292: --
293: -- IN
294: -- p_api_version_number IN NUMBER Required
295: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
296: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
297: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
298: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
299: --
300: -- OUT

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

293: -- IN
294: -- p_api_version_number IN NUMBER Required
295: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
296: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
297: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
298: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
299: --
300: -- OUT
301: -- x_return_status OUT VARCHAR2

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

313: -- ==============================================================================
314:
315: PROCEDURE Update_Na_Ddn_Rule(
316: p_api_version_number IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320:
321: x_return_status OUT NOCOPY VARCHAR2,

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

314:
315: PROCEDURE Update_Na_Ddn_Rule(
316: p_api_version_number IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320:
321: x_return_status OUT NOCOPY VARCHAR2,
322: x_msg_count OUT NOCOPY NUMBER,

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

315: PROCEDURE Update_Na_Ddn_Rule(
316: p_api_version_number IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320:
321: x_return_status OUT NOCOPY VARCHAR2,
322: x_msg_count OUT NOCOPY NUMBER,
323: x_msg_data OUT NOCOPY VARCHAR2,

Line 352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

348: -- Standard Start of API savepoint
349: SAVEPOINT update_na_ddn_rule_pvt;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
353: p_api_version_number,
354: l_api_name,
355: G_PKG_NAME)
356: THEN

Line 357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

353: p_api_version_number,
354: l_api_name,
355: G_PKG_NAME)
356: THEN
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359:
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 362: IF FND_API.to_Boolean( p_init_msg_list )

358: END IF;
359:
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.
362: IF FND_API.to_Boolean( p_init_msg_list )
363: THEN
364: FND_MSG_PUB.initialize;
365: END IF;
366:

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS;

371:
372:
373:
374: -- Initialize API return status to SUCCESS
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376:
377: -- Debug Message
378: debug_message('Private API: - Open Cursor to Select');
379:

Line 388: RAISE FND_API.G_EXC_ERROR;

384: If ( c_get_Na_Ddn_Rule%NOTFOUND) THEN
385: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
386: p_token_name => 'INFO',
387: p_token_value => 'Na_Ddn_Rule') ;
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390: -- Debug Message
391: debug_message('Private API: - Close Cursor');
392: CLOSE c_get_Na_Ddn_Rule;

Line 396: l_tar_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM ) Then

392: CLOSE c_get_Na_Ddn_Rule;
393:
394:
395: If (l_tar_na_ddn_rule_rec.object_version_number is NULL or
396: l_tar_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM ) Then
397: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
398: p_token_name => 'COLUMN',
399: p_token_value => 'Last_Update_Date') ;
400: raise FND_API.G_EXC_ERROR;

Line 400: raise FND_API.G_EXC_ERROR;

396: l_tar_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM ) Then
397: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
398: p_token_name => 'COLUMN',
399: p_token_value => 'Last_Update_Date') ;
400: raise FND_API.G_EXC_ERROR;
401: End if;
402: -- Check Whether record has been changed by someone else
403: If (l_tar_na_ddn_rule_rec.object_version_number <> l_ref_na_ddn_rule_rec.object_version_number) Then
404: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 407: raise FND_API.G_EXC_ERROR;

403: If (l_tar_na_ddn_rule_rec.object_version_number <> l_ref_na_ddn_rule_rec.object_version_number) Then
404: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
405: p_token_name => 'INFO',
406: p_token_value => 'Na_Ddn_Rule') ;
407: raise FND_API.G_EXC_ERROR;
408: End if;
409:
410:
411: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

407: raise FND_API.G_EXC_ERROR;
408: End if;
409:
410:
411: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
412: THEN
413: -- Debug message
414: debug_message('Private API: Validate_Na_Ddn_Rule');
415:

Line 419: p_init_msg_list => FND_API.G_FALSE,

415:
416: -- Invoke validation procedures
417: Validate_na_ddn_rule(
418: p_api_version_number => 1.0,
419: p_init_msg_list => FND_API.G_FALSE,
420: p_validation_level => p_validation_level,
421: p_validation_mode => JTF_PLSQL_API.g_update,
422: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
423: x_return_status => x_return_status,

Line 428: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

424: x_msg_count => x_msg_count,
425: x_msg_data => x_msg_data);
426: END IF;
427:
428: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432:

Line 429: RAISE FND_API.G_EXC_ERROR;

425: x_msg_data => x_msg_data);
426: END IF;
427:
428: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432:
433: -- Debug Message

Line 455: IF FND_API.to_Boolean( p_commit )

451: -- End of API body.
452: --
453:
454: -- Standard check for p_commit
455: IF FND_API.to_Boolean( p_commit )
456: THEN
457: COMMIT WORK;
458: END IF;
459:

Line 473: x_return_status := FND_API.g_ret_sts_error;

469: );
470: EXCEPTION
471:
472: WHEN OZF_Utility_PVT.resource_locked THEN
473: x_return_status := FND_API.g_ret_sts_error;
474: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;

Line 476: WHEN FND_API.G_EXC_ERROR THEN

472: WHEN OZF_Utility_PVT.resource_locked THEN
473: x_return_status := FND_API.g_ret_sts_error;
474: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (

Line 478: x_return_status := FND_API.G_RET_STS_ERROR;

474: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,

Line 481: p_encoded => FND_API.G_FALSE,

477: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );
485:

Line 486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (

Line 488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

484: );
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,

Line 491: p_encoded => FND_API.G_FALSE,

487: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );
495:

Line 498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

494: );
495:
496: WHEN OTHERS THEN
497: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;

Line 505: p_encoded => FND_API.G_FALSE,

501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data
508: );
509: End Update_Na_Ddn_Rule;

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

521: -- Parameters
522: --
523: -- IN
524: -- p_api_version_number IN NUMBER Required
525: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
526: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
527: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
528: -- p_na_deduction_rule_id IN NUMBER
529: -- p_object_version_number IN NUMBER Optional Default = NULL

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

522: --
523: -- IN
524: -- p_api_version_number IN NUMBER Required
525: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
526: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
527: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
528: -- p_na_deduction_rule_id IN NUMBER
529: -- p_object_version_number IN NUMBER Optional Default = NULL
530: --

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

523: -- IN
524: -- p_api_version_number IN NUMBER Required
525: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
526: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
527: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
528: -- p_na_deduction_rule_id IN NUMBER
529: -- p_object_version_number IN NUMBER Optional Default = NULL
530: --
531: -- OUT

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

544: -- ==============================================================================
545:
546: PROCEDURE Delete_Na_Ddn_Rule(
547: p_api_version_number IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
549: p_commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,

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

545:
546: PROCEDURE Delete_Na_Ddn_Rule(
547: p_api_version_number IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
549: p_commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2,

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

546: PROCEDURE Delete_Na_Ddn_Rule(
547: p_api_version_number IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
549: p_commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2,
554: p_na_deduction_rule_id IN NUMBER,

Line 568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

564: -- Standard Start of API savepoint
565: SAVEPOINT delete_na_ddn_rule_pvt;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575:
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 578: IF FND_API.to_Boolean( p_init_msg_list )

574: END IF;
575:
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )
579: THEN
580: FND_MSG_PUB.initialize;
581: END IF;
582:

Line 591: x_return_status := FND_API.G_RET_STS_SUCCESS;

587:
588:
589:
590: -- Initialize API return status to SUCCESS
591: x_return_status := FND_API.G_RET_STS_SUCCESS;
592:
593: --
594: -- Api body
595: --

Line 608: IF FND_API.to_Boolean( p_commit )

604: -- End of API body
605: --
606:
607: -- Standard check for p_commit
608: IF FND_API.to_Boolean( p_commit )
609: THEN
610: COMMIT WORK;
611: END IF;
612:

Line 626: x_return_status := FND_API.g_ret_sts_error;

622: );
623: EXCEPTION
624:
625: WHEN OZF_Utility_PVT.resource_locked THEN
626: x_return_status := FND_API.g_ret_sts_error;
627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
628:
629: WHEN FND_API.G_EXC_ERROR THEN
630: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;

Line 629: WHEN FND_API.G_EXC_ERROR THEN

625: WHEN OZF_Utility_PVT.resource_locked THEN
626: x_return_status := FND_API.g_ret_sts_error;
627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
628:
629: WHEN FND_API.G_EXC_ERROR THEN
630: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: -- Standard call to get message count and if count=1, get the message
633: FND_MSG_PUB.Count_And_Get (

Line 631: x_return_status := FND_API.G_RET_STS_ERROR;

627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
628:
629: WHEN FND_API.G_EXC_ERROR THEN
630: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: -- Standard call to get message count and if count=1, get the message
633: FND_MSG_PUB.Count_And_Get (
634: p_encoded => FND_API.G_FALSE,
635: p_count => x_msg_count,

Line 634: p_encoded => FND_API.G_FALSE,

630: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: -- Standard call to get message count and if count=1, get the message
633: FND_MSG_PUB.Count_And_Get (
634: p_encoded => FND_API.G_FALSE,
635: p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638:

Line 639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

635: p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

637: );
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,

Line 644: p_encoded => FND_API.G_FALSE,

640: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data
647: );
648:

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

647: );
648:
649: WHEN OTHERS THEN
650: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
653: THEN
654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
655: END IF;

Line 658: p_encoded => FND_API.G_FALSE,

654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
655: END IF;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (
658: p_encoded => FND_API.G_FALSE,
659: p_count => x_msg_count,
660: p_data => x_msg_data
661: );
662: End Delete_Na_Ddn_Rule;

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

676: -- Parameters
677: --
678: -- IN
679: -- p_api_version_number IN NUMBER Required
680: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
681: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
682: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
683: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
684: --

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

677: --
678: -- IN
679: -- p_api_version_number IN NUMBER Required
680: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
681: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
682: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
683: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
684: --
685: -- OUT

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

678: -- IN
679: -- p_api_version_number IN NUMBER Required
680: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
681: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
682: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
683: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
684: --
685: -- OUT
686: -- x_return_status OUT VARCHAR2

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

698: -- ==============================================================================
699:
700: PROCEDURE Lock_Na_Ddn_Rule(
701: p_api_version_number IN NUMBER,
702: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
703:
704: x_return_status OUT NOCOPY VARCHAR2,
705: x_msg_count OUT NOCOPY NUMBER,
706: x_msg_data OUT NOCOPY VARCHAR2,

Line 725: IF FND_API.to_Boolean( p_init_msg_list )

721: debug_message('Private API: ' || l_api_name || 'start');
722:
723:
724: -- Initialize message list if p_init_msg_list is set to TRUE.
725: IF FND_API.to_Boolean( p_init_msg_list )
726: THEN
727: FND_MSG_PUB.initialize;
728: END IF;
729:

Line 733: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

729:
730:
731:
732: -- Standard call to check for call compatibility.
733: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
734: p_api_version_number,
735: l_api_name,
736: G_PKG_NAME)
737: THEN

Line 738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

734: p_api_version_number,
735: l_api_name,
736: G_PKG_NAME)
737: THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740:
741:
742:

Line 744: x_return_status := FND_API.G_RET_STS_SUCCESS;

740:
741:
742:
743: -- Initialize API return status to SUCCESS
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745:
746:
747: ------------------------ lock -------------------------
748: Ozf_Na_Ddn_Rule_Pkg.Lock_Row(l_na_deduction_rule_id,p_object_version);

Line 753: p_encoded => FND_API.g_false,

749:
750:
751: -------------------- finish --------------------------
752: FND_MSG_PUB.count_and_get(
753: p_encoded => FND_API.g_false,
754: p_count => x_msg_count,
755: p_data => x_msg_data);
756: debug_message(l_full_name ||': end');
757: EXCEPTION

Line 760: x_return_status := FND_API.g_ret_sts_error;

756: debug_message(l_full_name ||': end');
757: EXCEPTION
758:
759: WHEN OZF_Utility_PVT.resource_locked THEN
760: x_return_status := FND_API.g_ret_sts_error;
761: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
762:
763: WHEN FND_API.G_EXC_ERROR THEN
764: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;

Line 763: WHEN FND_API.G_EXC_ERROR THEN

759: WHEN OZF_Utility_PVT.resource_locked THEN
760: x_return_status := FND_API.g_ret_sts_error;
761: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
762:
763: WHEN FND_API.G_EXC_ERROR THEN
764: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
765: x_return_status := FND_API.G_RET_STS_ERROR;
766: -- Standard call to get message count and if count=1, get the message
767: FND_MSG_PUB.Count_And_Get (

Line 765: x_return_status := FND_API.G_RET_STS_ERROR;

761: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
762:
763: WHEN FND_API.G_EXC_ERROR THEN
764: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
765: x_return_status := FND_API.G_RET_STS_ERROR;
766: -- Standard call to get message count and if count=1, get the message
767: FND_MSG_PUB.Count_And_Get (
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,

Line 768: p_encoded => FND_API.G_FALSE,

764: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
765: x_return_status := FND_API.G_RET_STS_ERROR;
766: -- Standard call to get message count and if count=1, get the message
767: FND_MSG_PUB.Count_And_Get (
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data
771: );
772:

Line 773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

769: p_count => x_msg_count,
770: p_data => x_msg_data
771: );
772:
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: -- Standard call to get message count and if count=1, get the message
777: FND_MSG_PUB.Count_And_Get (

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

771: );
772:
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: -- Standard call to get message count and if count=1, get the message
777: FND_MSG_PUB.Count_And_Get (
778: p_encoded => FND_API.G_FALSE,
779: p_count => x_msg_count,

Line 778: p_encoded => FND_API.G_FALSE,

774: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: -- Standard call to get message count and if count=1, get the message
777: FND_MSG_PUB.Count_And_Get (
778: p_encoded => FND_API.G_FALSE,
779: p_count => x_msg_count,
780: p_data => x_msg_data
781: );
782:

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

781: );
782:
783: WHEN OTHERS THEN
784: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;

Line 792: p_encoded => FND_API.G_FALSE,

788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data
795: );
796: End Lock_Na_Ddn_Rule;

Line 809: x_return_status := FND_API.g_ret_sts_success;

805: IS
806: l_valid_flag VARCHAR2(1);
807:
808: BEGIN
809: x_return_status := FND_API.g_ret_sts_success;
810: IF p_validation_mode = JTF_PLSQL_API.g_create
811: AND p_na_ddn_rule_rec.na_deduction_rule_id IS NOT NULL
812: THEN
813: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 819: IF l_valid_flag = FND_API.g_false THEN

815: 'na_deduction_rule_id = ''' || p_na_ddn_rule_rec.na_deduction_rule_id ||''''
816: );
817: END IF;
818:
819: IF l_valid_flag = FND_API.g_false THEN
820: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_na_deduction_rule_id_DUPLICATE');
821: x_return_status := FND_API.g_ret_sts_error;
822: END IF;
823:

Line 821: x_return_status := FND_API.g_ret_sts_error;

817: END IF;
818:
819: IF l_valid_flag = FND_API.g_false THEN
820: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_na_deduction_rule_id_DUPLICATE');
821: x_return_status := FND_API.g_ret_sts_error;
822: END IF;
823:
824: END check_Na_Ddn_Rule_Uk_Items;
825:

Line 835: x_return_status := FND_API.g_ret_sts_success;

831: x_return_status OUT NOCOPY VARCHAR2
832: )
833: IS
834: BEGIN
835: x_return_status := FND_API.g_ret_sts_success;
836:
837: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
838:
839:

Line 840: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.na_deduction_rule_id IS NULL THEN

836:
837: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
838:
839:
840: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.na_deduction_rule_id IS NULL THEN
841: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );
842: x_return_status := FND_API.g_ret_sts_error;
843: END IF;
844:

Line 842: x_return_status := FND_API.g_ret_sts_error;

838:
839:
840: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.na_deduction_rule_id IS NULL THEN
841: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );
842: x_return_status := FND_API.g_ret_sts_error;
843: END IF;
844:
845:
846: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_source_code IS NULL THEN

Line 846: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_source_code IS NULL THEN

842: x_return_status := FND_API.g_ret_sts_error;
843: END IF;
844:
845:
846: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_source_code IS NULL THEN
847: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );
848: x_return_status := FND_API.g_ret_sts_error;
849: END IF;
850:

Line 848: x_return_status := FND_API.g_ret_sts_error;

844:
845:
846: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_source_code IS NULL THEN
847: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );
848: x_return_status := FND_API.g_ret_sts_error;
849: END IF;
850:
851:
852: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_type_code IS NULL THEN

Line 852: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_type_code IS NULL THEN

848: x_return_status := FND_API.g_ret_sts_error;
849: END IF;
850:
851:
852: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_type_code IS NULL THEN
853: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856:

Line 854: x_return_status := FND_API.g_ret_sts_error;

850:
851:
852: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_type_code IS NULL THEN
853: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856:
857:
858: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR OR p_na_ddn_rule_rec.deduction_identifier_id IS NULL THEN

Line 858: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR OR p_na_ddn_rule_rec.deduction_identifier_id IS NULL THEN

854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856:
857:
858: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR OR p_na_ddn_rule_rec.deduction_identifier_id IS NULL THEN
859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:

Line 860: x_return_status := FND_API.g_ret_sts_error;

856:
857:
858: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR OR p_na_ddn_rule_rec.deduction_identifier_id IS NULL THEN
859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:
863: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.deduction_identifier_org_id IS NULL THEN
864: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );

Line 863: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.deduction_identifier_org_id IS NULL THEN

859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:
863: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.deduction_identifier_org_id IS NULL THEN
864: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:

Line 865: x_return_status := FND_API.g_ret_sts_error;

861: END IF;
862:
863: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.deduction_identifier_org_id IS NULL THEN
864: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:
868: /* IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.object_version_number IS NULL THEN
869: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

Line 868: /* IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.object_version_number IS NULL THEN

864: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:
868: /* IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.object_version_number IS NULL THEN
869: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
870: x_return_status := FND_API.g_ret_sts_error;
871: END IF;
872:

Line 870: x_return_status := FND_API.g_ret_sts_error;

866: END IF;
867:
868: /* IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.object_version_number IS NULL THEN
869: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
870: x_return_status := FND_API.g_ret_sts_error;
871: END IF;
872:
873:
874: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.last_update_login IS NULL THEN

Line 874: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.last_update_login IS NULL THEN

870: x_return_status := FND_API.g_ret_sts_error;
871: END IF;
872:
873:
874: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.last_update_login IS NULL THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: */

Line 876: x_return_status := FND_API.g_ret_sts_error;

872:
873:
874: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.last_update_login IS NULL THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: */
879:
880: ELSE

Line 881: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM THEN

877: END IF;
878: */
879:
880: ELSE
881: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM THEN
882: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885:

Line 883: x_return_status := FND_API.g_ret_sts_error;

879:
880: ELSE
881: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM THEN
882: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885:
886:
887: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char THEN

Line 887: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char THEN

883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885:
886:
887: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char THEN
888: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );
889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891:

Line 889: x_return_status := FND_API.g_ret_sts_error;

885:
886:
887: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char THEN
888: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );
889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891:
892:
893: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char THEN

Line 893: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char THEN

889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891:
892:
893: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char THEN
894: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );
895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:

Line 895: x_return_status := FND_API.g_ret_sts_error;

891:
892:
893: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char THEN
894: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );
895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:
898:
899: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR THEN

Line 899: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR THEN

895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:
898:
899: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR THEN
900: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:

Line 901: x_return_status := FND_API.g_ret_sts_error;

897:
898:
899: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR THEN
900: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:
904: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM THEN
905: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );

Line 904: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM THEN

900: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:
904: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM THEN
905: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
906: x_return_status := FND_API.g_ret_sts_error;
907: END IF;
908:

Line 906: x_return_status := FND_API.g_ret_sts_error;

902: END IF;
903:
904: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM THEN
905: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
906: x_return_status := FND_API.g_ret_sts_error;
907: END IF;
908:
909: IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM THEN
910: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

Line 909: IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM THEN

905: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
906: x_return_status := FND_API.g_ret_sts_error;
907: END IF;
908:
909: IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM THEN
910: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:

Line 911: x_return_status := FND_API.g_ret_sts_error;

907: END IF;
908:
909: IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM THEN
910: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:
914: /*
915: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 915: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM THEN

911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:
914: /*
915: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM THEN
916: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
917: x_return_status := FND_API.g_ret_sts_error;
918: END IF;
919: END IF;

Line 917: x_return_status := FND_API.g_ret_sts_error;

913:
914: /*
915: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM THEN
916: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
917: x_return_status := FND_API.g_ret_sts_error;
918: END IF;
919: END IF;
920: */
921: END IF;

Line 932: x_return_status := FND_API.g_ret_sts_success;

928: x_return_status OUT NOCOPY VARCHAR2
929: )
930: IS
931: BEGIN
932: x_return_status := FND_API.g_ret_sts_success;
933:
934: -- Enter custom code here
935:
936: END check_Na_Ddn_Rule_Fk_Items;

Line 946: x_return_status := FND_API.g_ret_sts_success;

942: x_return_status OUT NOCOPY VARCHAR2
943: )
944: IS
945: BEGIN
946: x_return_status := FND_API.g_ret_sts_success;
947:
948: -- Enter custom code here
949:
950: END check_Na_Ddn_Rule_Lookup_Items;

Line 963: l_return_status := FND_API.g_ret_sts_success;

959: IS
960: l_return_status VARCHAR2(1);
961: BEGIN
962:
963: l_return_status := FND_API.g_ret_sts_success;
964: -- Check Items Uniqueness API calls
965:
966: check_Na_ddn_rule_Uk_Items(
967: p_na_ddn_rule_rec => p_na_ddn_rule_rec,

Line 970: IF x_return_status <> FND_API.g_ret_sts_success THEN

966: check_Na_ddn_rule_Uk_Items(
967: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
968: p_validation_mode => p_validation_mode,
969: x_return_status => x_return_status);
970: IF x_return_status <> FND_API.g_ret_sts_success THEN
971: l_return_status := FND_API.g_ret_sts_error;
972: END IF;
973:
974: -- Check Items Required/NOT NULL API calls

Line 971: l_return_status := FND_API.g_ret_sts_error;

967: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
968: p_validation_mode => p_validation_mode,
969: x_return_status => x_return_status);
970: IF x_return_status <> FND_API.g_ret_sts_success THEN
971: l_return_status := FND_API.g_ret_sts_error;
972: END IF;
973:
974: -- Check Items Required/NOT NULL API calls
975:

Line 980: IF x_return_status <> FND_API.g_ret_sts_success THEN

976: check_na_ddn_rule_req_items(
977: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
978: p_validation_mode => p_validation_mode,
979: x_return_status => x_return_status);
980: IF x_return_status <> FND_API.g_ret_sts_success THEN
981: l_return_status := FND_API.g_ret_sts_error;
982: END IF;
983: -- Check Items Foreign Keys API calls
984:

Line 981: l_return_status := FND_API.g_ret_sts_error;

977: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
978: p_validation_mode => p_validation_mode,
979: x_return_status => x_return_status);
980: IF x_return_status <> FND_API.g_ret_sts_success THEN
981: l_return_status := FND_API.g_ret_sts_error;
982: END IF;
983: -- Check Items Foreign Keys API calls
984:
985: check_na_ddn_rule_FK_items(

Line 988: IF x_return_status <> FND_API.g_ret_sts_success THEN

984:
985: check_na_ddn_rule_FK_items(
986: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
987: x_return_status => x_return_status);
988: IF x_return_status <> FND_API.g_ret_sts_success THEN
989: l_return_status := FND_API.g_ret_sts_error;
990: END IF;
991: -- Check Items Lookups
992:

Line 989: l_return_status := FND_API.g_ret_sts_error;

985: check_na_ddn_rule_FK_items(
986: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
987: x_return_status => x_return_status);
988: IF x_return_status <> FND_API.g_ret_sts_success THEN
989: l_return_status := FND_API.g_ret_sts_error;
990: END IF;
991: -- Check Items Lookups
992:
993: check_na_ddn_rule_Lookup_items(

Line 996: IF x_return_status <> FND_API.g_ret_sts_success THEN

992:
993: check_na_ddn_rule_Lookup_items(
994: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
995: x_return_status => x_return_status);
996: IF x_return_status <> FND_API.g_ret_sts_success THEN
997: l_return_status := FND_API.g_ret_sts_error;
998: END IF;
999:
1000: x_return_status := l_return_status;

Line 997: l_return_status := FND_API.g_ret_sts_error;

993: check_na_ddn_rule_Lookup_items(
994: p_na_ddn_rule_rec => p_na_ddn_rule_rec,
995: x_return_status => x_return_status);
996: IF x_return_status <> FND_API.g_ret_sts_success THEN
997: l_return_status := FND_API.g_ret_sts_error;
998: END IF;
999:
1000: x_return_status := l_return_status;
1001:

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

1091: l_na_ddn_rule_rec na_ddn_rule_rec_type := p_na_ddn_rule_rec;
1092: BEGIN
1093: -- Developers should put their code to default the record type
1094: -- e.g. IF p_campaign_rec.status_code IS NULL
1095: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1096: -- l_campaign_rec.status_code := 'NEW' ;
1097: -- END IF ;
1098: --
1099: NULL ;

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

1103:
1104:
1105: PROCEDURE Validate_Na_Ddn_Rule(
1106: p_api_version_number IN NUMBER,
1107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1109: p_na_ddn_rule_rec IN na_ddn_rule_rec_type,
1110: p_validation_mode IN VARCHAR2,
1111: x_return_status OUT NOCOPY VARCHAR2,

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

1104:
1105: PROCEDURE Validate_Na_Ddn_Rule(
1106: p_api_version_number IN NUMBER,
1107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1109: p_na_ddn_rule_rec IN na_ddn_rule_rec_type,
1110: p_validation_mode IN VARCHAR2,
1111: x_return_status OUT NOCOPY VARCHAR2,
1112: x_msg_count OUT NOCOPY NUMBER,

Line 1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1122: -- Standard Start of API savepoint
1123: SAVEPOINT validate_na_ddn_rule_;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1127: p_api_version_number,
1128: l_api_name,
1129: G_PKG_NAME)
1130: THEN

Line 1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1127: p_api_version_number,
1128: l_api_name,
1129: G_PKG_NAME)
1130: THEN
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133:
1134:
1135: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1136: IF FND_API.to_Boolean( p_init_msg_list )

1132: END IF;
1133:
1134:
1135: -- Initialize message list if p_init_msg_list is set to TRUE.
1136: IF FND_API.to_Boolean( p_init_msg_list )
1137: THEN
1138: FND_MSG_PUB.initialize;
1139: END IF;
1140:

Line 1149: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1145: p_validation_mode => p_validation_mode,
1146: x_return_status => x_return_status
1147: );
1148:
1149: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146: x_return_status => x_return_status
1147: );
1148:
1149: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: END IF;

Line 1151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1147: );
1148:
1149: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: END IF;
1155:

Line 1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1148:
1149: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: END IF;
1155:
1156:

Line 1172: p_init_msg_list => FND_API.G_FALSE,

1168:
1169: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1170: Validate_na_ddn_rule_Rec(
1171: p_api_version_number => 1.0,
1172: p_init_msg_list => FND_API.G_FALSE,
1173: x_return_status => x_return_status,
1174: x_msg_count => x_msg_count,
1175: x_msg_data => x_msg_data,
1176: p_na_ddn_rule_rec => l_na_ddn_rule_rec);

Line 1178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1174: x_msg_count => x_msg_count,
1175: x_msg_data => x_msg_data,
1176: p_na_ddn_rule_rec => l_na_ddn_rule_rec);
1177:
1178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;

Line 1179: RAISE FND_API.G_EXC_ERROR;

1175: x_msg_data => x_msg_data,
1176: p_na_ddn_rule_rec => l_na_ddn_rule_rec);
1177:
1178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: END IF;

Line 1180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1176: p_na_ddn_rule_rec => l_na_ddn_rule_rec);
1177:
1178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: END IF;
1184:

Line 1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1177:
1178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: END IF;
1184:
1185:

Line 1192: x_return_status := FND_API.G_RET_STS_SUCCESS;

1188:
1189:
1190:
1191: -- Initialize API return status to SUCCESS
1192: x_return_status := FND_API.G_RET_STS_SUCCESS;
1193:
1194:
1195: -- Debug Message
1196: debug_message('Private API: ' || l_api_name || 'end');

Line 1207: x_return_status := FND_API.g_ret_sts_error;

1203: );
1204: EXCEPTION
1205:
1206: WHEN OZF_Utility_PVT.resource_locked THEN
1207: x_return_status := FND_API.g_ret_sts_error;
1208: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;

Line 1210: WHEN FND_API.G_EXC_ERROR THEN

1206: WHEN OZF_Utility_PVT.resource_locked THEN
1207: x_return_status := FND_API.g_ret_sts_error;
1208: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (

Line 1212: x_return_status := FND_API.G_RET_STS_ERROR;

1208: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,

Line 1215: p_encoded => FND_API.G_FALSE,

1211: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219:

Line 1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223: -- Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (

Line 1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1218: );
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223: -- Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,

Line 1225: p_encoded => FND_API.G_FALSE,

1221: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223: -- Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );
1229:

Line 1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1228: );
1229:
1230: WHEN OTHERS THEN
1231: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1234: THEN
1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;

Line 1239: p_encoded => FND_API.G_FALSE,

1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );
1243: End Validate_Na_Ddn_Rule;

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

1244:
1245:
1246: PROCEDURE Validate_Na_Ddn_Rule_Rec (
1247: p_api_version_number IN NUMBER,
1248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1249: x_return_status OUT NOCOPY VARCHAR2,
1250: x_msg_count OUT NOCOPY NUMBER,
1251: x_msg_data OUT NOCOPY VARCHAR2,
1252: p_na_ddn_rule_rec IN na_ddn_rule_rec_type

Line 1257: IF FND_API.to_Boolean( p_init_msg_list )

1253: )
1254: IS
1255: BEGIN
1256: -- Initialize message list if p_init_msg_list is set to TRUE.
1257: IF FND_API.to_Boolean( p_init_msg_list )
1258: THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261:

Line 1265: x_return_status := FND_API.G_RET_STS_SUCCESS;

1261:
1262:
1263:
1264: -- Initialize API return status to SUCCESS
1265: x_return_status := FND_API.G_RET_STS_SUCCESS;
1266:
1267: -- Hint: Validate data
1268: -- If data not valid
1269: -- THEN

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

1266:
1267: -- Hint: Validate data
1268: -- If data not valid
1269: -- THEN
1270: -- x_return_status := FND_API.G_RET_STS_ERROR;
1271:
1272: -- Debug Message
1273: debug_message('Private API: Validate_dm_model_rec');
1274: -- Standard call to get message count and if count is 1, get message info.