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_CODE_CONVERSION_PVT dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

57:
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: IF FND_API.to_Boolean( p_init_msg_list )
60: THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64:
65: -- ******************************************************************

Line 70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

66: -- Validate Environment
67: -- ******************************************************************
68: IF FND_GLOBAL.User_Id IS NULL
69: THEN
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
73: FND_MSG_PUB.ADD;
74: END IF;

Line 73: FND_MSG_PUB.ADD;

69: THEN
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
73: FND_MSG_PUB.ADD;
74: END IF;
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77:

Line 79: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77:
78: -- Debug Message
79: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
80: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
81: END IF;
82:
83: -- Initialize API return status to SUCCESS

Line 86: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

82:
83: -- Initialize API return status to SUCCESS
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
87: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_code_conversion_tbl.count);
88: END IF;
89:
90: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: -- Debug Message
110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
111: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
112: END IF;
113:
114: l_code_conversion_id := NULL;

Line 119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

115: l_object_version_number := NULL;
116:
117: x_code_conversion_id_tbl := JTF_NUMBER_TABLE();
118:
119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
120: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_code_conversion_tbl.count);
121: END IF;
122:
123: FOR i IN 1 .. p_code_conversion_tbl.count

Line 135: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

131: l_org_id := l_code_conversion_rec.org_id;
132: END IF;
133: SELECT ozf_code_conversions_all_s.nextval INTO l_code_conversion_id FROM DUAL;
134:
135: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
136: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
137: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);
138: END IF;
139:

Line 182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

178: WHEN OTHERS THEN
179: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating code conversion map');
180: RAISE FND_API.G_EXC_ERROR;
181: END;
182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
183: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - code conversion id' || l_code_conversion_id);
184: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_code_conversion_rec.Object_Version_Number);
185: END IF;
186:

Line 199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

195: COMMIT WORK;
196: END IF;
197:
198: -- Debug Message
199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
200: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
201: END IF;
202:
203: -- Standard call to get message count and if count is 1, get message info.

Line 204: FND_MSG_PUB.Count_And_Get

200: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
201: END IF;
202:
203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get
205: (p_count => x_msg_count,
206: p_data => x_msg_data
207: );
208:

Line 214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

210:
211: EXCEPTION
212: WHEN OZF_UTILITY_PVT.resource_locked THEN
213: x_return_status := FND_API.g_ret_sts_error;
214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
215: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
216: FND_MSG_PUB.add;
217: END IF;
218: WHEN FND_API.G_EXC_ERROR THEN

Line 216: FND_MSG_PUB.add;

212: WHEN OZF_UTILITY_PVT.resource_locked THEN
213: x_return_status := FND_API.g_ret_sts_error;
214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
215: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
216: FND_MSG_PUB.add;
217: END IF;
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO create_code_conversion_pvt;
220: x_return_status := FND_API.G_RET_STS_ERROR;

Line 222: FND_MSG_PUB.Count_And_Get (

218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO create_code_conversion_pvt;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: -- Standard call to get message count and if count=1, get the message
222: FND_MSG_PUB.Count_And_Get (
223: p_encoded => FND_API.G_FALSE,
224: p_count => x_msg_count,
225: p_data => x_msg_data
226: );

Line 231: FND_MSG_PUB.Count_And_Get (

227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO create_code_conversion_pvt;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: -- Standard call to get message count and if count=1, get the message
231: FND_MSG_PUB.Count_And_Get (
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,
234: p_data => x_msg_data
235: );

Line 239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

235: );
236: WHEN OTHERS THEN
237: ROLLBACK TO create_code_conversion_pvt;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
242: END IF;
243: -- Standard call to get message count and if count=1, get the message

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

237: ROLLBACK TO create_code_conversion_pvt;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
242: END IF;
243: -- Standard call to get message count and if count=1, get the message
244: FND_MSG_PUB.Count_And_Get (
245: p_encoded => FND_API.G_FALSE,

Line 244: FND_MSG_PUB.Count_And_Get (

240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
242: END IF;
243: -- Standard call to get message count and if count=1, get the message
244: FND_MSG_PUB.Count_And_Get (
245: p_encoded => FND_API.G_FALSE,
246: p_count => x_msg_count,
247: p_data => x_msg_data
248: );

Line 336: FND_MSG_PUB.initialize;

332:
333: -- Initialize message list if p_init_msg_list is set to TRUE.
334: IF FND_API.to_Boolean( p_init_msg_list )
335: THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338:
339: -- ******************************************************************
340: -- Validate Environment

Line 344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

340: -- Validate Environment
341: -- ******************************************************************
342: IF FND_GLOBAL.User_Id IS NULL
343: THEN
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
345: THEN
346: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
347: FND_MSG_PUB.ADD;
348: END IF;

Line 347: FND_MSG_PUB.ADD;

343: THEN
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
345: THEN
346: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
347: FND_MSG_PUB.ADD;
348: END IF;
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:

Line 353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:
352: -- Debug Message
353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
354: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
355: END IF;
356:
357: -- Initialize API return status to SUCCESS

Line 361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

357: -- Initialize API return status to SUCCESS
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359: x_object_version_number := JTF_NUMBER_TABLE();
360:
361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
362: OZF_UTILITY_PVT.debug_message('p_code_conversion_tbl(1).description: ' || p_code_conversion_tbl(1).description );
363: END IF;
364:
365: FOR i in 1 .. p_code_conversion_tbl.count

Line 370: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

366: LOOP
367: p_code_conversion_rec := p_code_conversion_tbl(i);
368: l_code_conversion_id := p_code_conversion_rec.code_conversion_id;
369:
370: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
371: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID' || l_code_conversion_id);
372: END IF;
373:
374: -- Check for the existance of the record

Line 411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

407: ,l_code_conversion_rec.attribute14
408: ,l_code_conversion_rec.attribute15
409: ,l_code_conversion_rec.security_group_id;
410:
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
412: OZF_UTILITY_PVT.debug_message('Existing description '|| l_code_conversion_rec.description);
413: END IF;
414:
415: IF ( csr_code_conversion%NOTFOUND) THEN

Line 416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

412: OZF_UTILITY_PVT.debug_message('Existing description '|| l_code_conversion_rec.description);
413: END IF;
414:
415: IF ( csr_code_conversion%NOTFOUND) THEN
416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
417: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
418: END IF;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
417: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
418: END IF;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
421: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
422: FND_MSG_PUB.add;
423: END IF;
424: RAISE FND_API.G_EXC_ERROR;

Line 422: FND_MSG_PUB.add;

418: END IF;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
421: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
422: FND_MSG_PUB.add;
423: END IF;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: CLOSE csr_code_conversion;

Line 429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

425: END IF;
426: CLOSE csr_code_conversion;
427:
428:
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
430: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_code_conversion_rec.object_version_number);
431: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_code_conversion_rec.object_version_number);
432: END IF;
433:

Line 437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

433:
434: --- Check the Version Number for Locking
435: IF l_code_conversion_rec.object_version_number <> P_code_conversion_rec.Object_Version_number
436: THEN
437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
438: OZF_UTILITY_PVT.debug_message( 'dbver' || l_code_conversion_rec.object_version_number);
439: OZF_UTILITY_PVT.debug_message( 'reqver' || P_code_conversion_rec.object_version_number);
440: END IF;
441:

Line 442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

438: OZF_UTILITY_PVT.debug_message( 'dbver' || l_code_conversion_rec.object_version_number);
439: OZF_UTILITY_PVT.debug_message( 'reqver' || P_code_conversion_rec.object_version_number);
440: END IF;
441:
442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
443: THEN
444: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
445: FND_MSG_PUB.ADD;
446: END IF;

Line 445: FND_MSG_PUB.ADD;

441:
442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
443: THEN
444: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
445: FND_MSG_PUB.ADD;
446: END IF;
447: RAISE FND_API.G_EXC_ERROR;
448: END IF;
449:

Line 454: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

450: -- Update internal code only when it is NUll
451: IF l_code_conversion_rec.internal_code IS NOT NULL AND
452: l_code_conversion_rec.internal_code <> P_code_conversion_rec.internal_code
453: THEN
454: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
455: THEN
456: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_INTLCODE');
457: FND_MSG_PUB.ADD;
458: END IF;

Line 457: FND_MSG_PUB.ADD;

453: THEN
454: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
455: THEN
456: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_INTLCODE');
457: FND_MSG_PUB.ADD;
458: END IF;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461:

Line 462: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

458: END IF;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461:
462: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
463: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_code_conversion_rec.End_Date_Active);
464: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_code_conversion_rec.End_Date_Active);
465: END IF;
466:

Line 472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

468: IF trunc(nvl(l_code_conversion_Rec.End_Date_Active,sysdate+1)) <= TRUNC(SYSDATE)
469: AND
470: Trunc(l_code_conversion_Rec.End_Date_Active) <> Trunc(P_code_conversion_Rec.End_Date_Active)
471: THEN
472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
473: THEN
474: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_ENDDATE');
475: FND_MSG_PUB.ADD;
476: END IF;

Line 475: FND_MSG_PUB.ADD;

471: THEN
472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
473: THEN
474: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_ENDDATE');
475: FND_MSG_PUB.ADD;
476: END IF;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:

Line 480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

476: END IF;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
481: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_code_conversion_rec.Start_Date_Active);
482: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_code_conversion_rec.Start_Date_Active);
483: END IF;
484:

Line 491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

487: <> trunc(P_code_conversion_Rec.Start_Date_Active)
488: THEN
489: IF p_code_conversion_Rec.Start_Date_Active < TRUNC(SYSDATE)
490: THEN
491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
492: THEN
493: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_STARTDATE');
494: FND_MSG_PUB.ADD;
495: END IF;

Line 494: FND_MSG_PUB.ADD;

490: THEN
491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
492: THEN
493: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_STARTDATE');
494: FND_MSG_PUB.ADD;
495: END IF;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:

Line 500: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: IF l_code_conversion_Rec.end_date_active < p_code_conversion_Rec.Start_Date_Active THEN
500: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
501: THEN
502: OZF_UTILITY_PVT.debug_message ('Cannot update an end dated code conversion map');
503: END IF;
504: raise FND_API.G_EXC_ERROR;

Line 512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

508:
509: -- Update not allowed for External Code
510: IF l_code_conversion_Rec.external_Code <> P_code_conversion_Rec.external_Code
511: THEN
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
513: THEN
514: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_EXTCD');
515: FND_MSG_PUB.ADD;
516: END IF;

Line 515: FND_MSG_PUB.ADD;

511: THEN
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
513: THEN
514: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_EXTCD');
515: FND_MSG_PUB.ADD;
516: END IF;
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:

Line 522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

518: END IF;
519:
520: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
521: -- Debug message
522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
523: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
524: END IF;
525: -- Invoke validation procedures
526: Validate_Code_Conversion(

Line 550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

546:
547:
548: -- Call Update Table Handler
549: -- Debug Message
550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
551: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');
552: END IF;
553: BEGIN
554: OZF_CODE_CONVERSION_PKG.Update_Row(

Line 608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

604: END IF;
605:
606:
607: -- Debug Message
608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
609: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
610: END IF;
611: -- Standard call to get message count and if count is 1, get message info.
612: FND_MSG_PUB.Count_And_Get

Line 612: FND_MSG_PUB.Count_And_Get

608: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
609: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
610: END IF;
611: -- Standard call to get message count and if count is 1, get message info.
612: FND_MSG_PUB.Count_And_Get
613: (p_count => x_msg_count,
614: p_data => x_msg_data
615: );
616: EXCEPTION

Line 621: FND_MSG_PUB.Count_And_Get (

617: WHEN FND_API.G_EXC_ERROR THEN
618: ROLLBACK TO update_code_conversion_pvt;
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: -- Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get (
622: p_encoded => FND_API.G_FALSE,
623: p_count => x_msg_count,
624: p_data => x_msg_data
625: );

Line 630: FND_MSG_PUB.Count_And_Get (

626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO update_code_conversion_pvt;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: -- Standard call to get message count and if count=1, get the message
630: FND_MSG_PUB.Count_And_Get (
631: p_encoded => FND_API.G_FALSE,
632: p_count => x_msg_count,
633: p_data => x_msg_data
634: );

Line 638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

634: );
635: WHEN OTHERS THEN
636: ROLLBACK TO update_code_conversion_pvt;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message

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

636: ROLLBACK TO update_code_conversion_pvt;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
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,

Line 643: FND_MSG_PUB.Count_And_Get (

639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
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: );

Line 685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

681: BEGIN
682: -- Standard Start of API savepoint
683: SAVEPOINT update_code_conversion_tbl_pvt;
684:
685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
686: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
687: END IF;
688:
689: -- Standard call to check for call compatibility.

Line 701: FND_MSG_PUB.initialize;

697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699: IF FND_API.to_Boolean( p_init_msg_list )
700: THEN
701: FND_MSG_PUB.initialize;
702: END IF;
703:
704: -- ******************************************************************
705: -- Validate Environment

Line 709: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

705: -- Validate Environment
706: -- ******************************************************************
707: IF FND_GLOBAL.User_Id IS NULL
708: THEN
709: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
712: FND_MSG_PUB.ADD;
713: END IF;

Line 712: FND_MSG_PUB.ADD;

708: THEN
709: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
712: FND_MSG_PUB.ADD;
713: END IF;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:

Line 718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: -- Debug Message
718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
719: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
720: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_code_conversion_Tbl.count);
721: END IF;
722: -- Initialize API return status to SUCCESS

Line 755: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

751: l_update_code_conv_tbl.extend;
752: l_update_code_conv_tbl(l_up_cnt) := P_code_conversion_Rec;
753: END IF;
754:
755: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
756: OZF_UTILITY_PVT.debug_message('End Date '||P_code_conversion_Rec.end_date_active);
757: END IF;
758:
759: END LOOP;

Line 761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

757: END IF;
758:
759: END LOOP;
760:
761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
762: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);
763: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);
764: END IF;
765:

Line 812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

808: COMMIT WORK;
809: END IF;
810:
811: -- Debug Message
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
813: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
814: END IF;
815: -- Standard call to get message count and if count is 1, get message info.
816: FND_MSG_PUB.Count_And_Get

Line 816: FND_MSG_PUB.Count_And_Get

812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
813: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
814: END IF;
815: -- Standard call to get message count and if count is 1, get message info.
816: FND_MSG_PUB.Count_And_Get
817: (p_count => x_msg_count,
818: p_data => x_msg_data
819: );
820: EXCEPTION

Line 825: FND_MSG_PUB.Count_And_Get (

821: WHEN FND_API.G_EXC_ERROR THEN
822: ROLLBACK TO update_code_conversion_tbl_pvt;
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );

Line 834: FND_MSG_PUB.Count_And_Get (

830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: ROLLBACK TO update_code_conversion_tbl_pvt;
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: -- Standard call to get message count and if count=1, get the message
834: FND_MSG_PUB.Count_And_Get (
835: p_encoded => FND_API.G_FALSE,
836: p_count => x_msg_count,
837: p_data => x_msg_data
838: );

Line 842: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

838: );
839: WHEN OTHERS THEN
840: ROLLBACK TO update_code_conversion_tbl_pvt;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
845: END IF;
846: -- Standard call to get message count and if count=1, get the message

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

840: ROLLBACK TO update_code_conversion_tbl_pvt;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
845: END IF;
846: -- Standard call to get message count and if count=1, get the message
847: FND_MSG_PUB.Count_And_Get (
848: p_encoded => FND_API.G_FALSE,

Line 847: FND_MSG_PUB.Count_And_Get (

843: THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
845: END IF;
846: -- Standard call to get message count and if count=1, get the message
847: FND_MSG_PUB.Count_And_Get (
848: p_encoded => FND_API.G_FALSE,
849: p_count => x_msg_count,
850: p_data => x_msg_data
851: );

Line 882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

878: BEGIN
879: -- Standard Start of API savepoint
880: SAVEPOINT delete_code_conversion_tbl_pvt;
881:
882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
883: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
884: END IF;
885:
886: -- Standard call to check for call compatibility.

Line 898: FND_MSG_PUB.initialize;

894:
895: -- Initialize message list if p_init_msg_list is set to TRUE.
896: IF FND_API.to_Boolean( p_init_msg_list )
897: THEN
898: FND_MSG_PUB.initialize;
899: END IF;
900:
901: -- ******************************************************************
902: -- Validate Environment

Line 906: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

902: -- Validate Environment
903: -- ******************************************************************
904: IF FND_GLOBAL.User_Id IS NULL
905: THEN
906: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
907: THEN
908: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
909: FND_MSG_PUB.ADD;
910: END IF;

Line 909: FND_MSG_PUB.ADD;

905: THEN
906: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
907: THEN
908: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
909: FND_MSG_PUB.ADD;
910: END IF;
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913:

Line 915: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913:
914: -- Debug Message
915: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
916: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
917: END IF;
918:
919:

Line 929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

925:
926: l_code_conversion_id := P_code_conversion_Tbl(i).code_conversion_id;
927: l_object_version_number := P_code_conversion_Tbl(i).object_version_number;
928:
929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
930: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id);
931: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);
932: END IF;
933:

Line 937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

933:
934: IF l_object_version_number IS NULL
935: OR l_code_conversion_id IS NULL THEN
936:
937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
938: OZF_UTILITY_PVT.debug_message('In If block');
939: END IF;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
941: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');

Line 940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

936:
937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
938: OZF_UTILITY_PVT.debug_message('In If block');
939: END IF;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
941: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');
942: FND_MSG_PUB.add;
943: END IF;
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 942: FND_MSG_PUB.add;

938: OZF_UTILITY_PVT.debug_message('In If block');
939: END IF;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
941: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');
942: FND_MSG_PUB.add;
943: END IF;
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945:
946:

Line 990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

986: COMMIT WORK;
987: END IF;
988:
989: -- Debug Message
990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
991: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
992: END IF;
993: -- Standard call to get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get

Line 994: FND_MSG_PUB.Count_And_Get

990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
991: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
992: END IF;
993: -- Standard call to get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get
995: (p_count => x_msg_count,
996: p_data => x_msg_data
997: );
998: EXCEPTION

Line 1003: FND_MSG_PUB.Count_And_Get (

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

Line 1012: FND_MSG_PUB.Count_And_Get (

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

Line 1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1016: );
1017: WHEN OTHERS THEN
1018: ROLLBACK TO delete_code_conversion_tbl_pvt;
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;
1024: -- Standard call to get message count and if count=1, get the message

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

1018: ROLLBACK TO delete_code_conversion_tbl_pvt;
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;
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,

Line 1025: FND_MSG_PUB.Count_And_Get (

1021: THEN
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: );

Line 1161: FND_MSG_PUB.initialize;

1157:
1158: -- Initialize message list if p_init_msg_list is set to TRUE.
1159: IF FND_API.to_Boolean( p_init_msg_list )
1160: THEN
1161: FND_MSG_PUB.initialize;
1162: END IF;
1163:
1164: -- Debug Message
1165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 1165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1161: FND_MSG_PUB.initialize;
1162: END IF;
1163:
1164: -- Debug Message
1165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1166: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1167: END IF;
1168:
1169:

Line 1176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1172:
1173: -- Validate the Delete Condition
1174: --
1175:
1176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1177: OZF_UTILITY_PVT.debug_message('Party ID in delete code conersion: ' || l_party_id);
1178: END IF;
1179: IF p_external_code IS NOT NULL THEN
1180:

Line 1190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1186: FETCH csr_code_conv_reason INTO l_dummy;
1187: CLOSE csr_code_conv_reason;
1188:
1189: IF l_dummy <> 0 Then
1190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1191: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_RSNMAP_DELETE');
1192: FND_MSG_PUB.ADD;
1193: END IF;
1194: RAISE FND_API.G_EXC_ERROR;

Line 1192: FND_MSG_PUB.ADD;

1188:
1189: IF l_dummy <> 0 Then
1190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1191: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_RSNMAP_DELETE');
1192: FND_MSG_PUB.ADD;
1193: END IF;
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:

Line 1242: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1238:
1239: END IF;
1240:
1241: for i in 1..ceil((length(l_sql)/100)) loop
1242: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1243: OZF_UTILITY_PVT.debug_message(substr(l_sql, (i-1)*100+1, 100));
1244: END IF;
1245: end loop;
1246: IF g_party_id IS NULL THEN

Line 1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1296: FETCH csr_code_conv_uom INTO l_dummy;
1297: CLOSE csr_code_conv_uom;
1298: END IF;
1299: IF l_dummy <> 0 THEN
1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1301: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_UOM_DELETE');
1302: FND_MSG_PUB.ADD;
1303: END IF;
1304: RAISE FND_API.G_EXC_ERROR;

Line 1302: FND_MSG_PUB.ADD;

1298: END IF;
1299: IF l_dummy <> 0 THEN
1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1301: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_UOM_DELETE');
1302: FND_MSG_PUB.ADD;
1303: END IF;
1304: RAISE FND_API.G_EXC_ERROR;
1305: ELSE
1306: IF g_party_id IS NOT NULL THEN

Line 1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1310: FETCH csr_code_conv_agrmt_uom INTO l_dummy;
1311: CLOSE csr_code_conv_agrmt_uom;
1312:
1313: IF l_dummy <> 0 THEN
1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1315: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_UOM_DELETE');
1316: FND_MSG_PUB.ADD;
1317: END IF;
1318: RAISE FND_API.G_EXC_ERROR;

Line 1316: FND_MSG_PUB.ADD;

1312:
1313: IF l_dummy <> 0 THEN
1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1315: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_UOM_DELETE');
1316: FND_MSG_PUB.ADD;
1317: END IF;
1318: RAISE FND_API.G_EXC_ERROR;
1319: END IF;
1320: ELSE

Line 1326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1322: FETCH csr_code_conv_agmt_uom INTO l_dummy;
1323: CLOSE csr_code_conv_agmt_uom;
1324:
1325: IF l_dummy <> 0 THEN
1326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1327: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_UOM_DELETE');
1328: FND_MSG_PUB.ADD;
1329: END IF;
1330: RAISE FND_API.G_EXC_ERROR;

Line 1328: FND_MSG_PUB.ADD;

1324:
1325: IF l_dummy <> 0 THEN
1326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1327: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_UOM_DELETE');
1328: FND_MSG_PUB.ADD;
1329: END IF;
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;
1332: END IF;

Line 1347: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1343: , g_account_id);
1344: FETCH csr_code_conv_agreement_pt INTO l_dummy;
1345: CLOSE csr_code_conv_agreement_pt;
1346:
1347: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1348: OZF_UTILITY_PVT.debug_message('l_dummy in delete code conersion: ' || l_dummy);
1349: END IF;
1350: END IF;
1351: IF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN

Line 1357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1353: FETCH csr_code_conv_agreement INTO l_dummy;
1354: CLOSE csr_code_conv_agreement;
1355: END IF;
1356: IF l_dummy <> 0 THEN
1357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1358: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_AGREEMENT_DELETE');
1359: FND_MSG_PUB.ADD;
1360: END IF;
1361: raise FND_API.G_EXC_ERROR;

Line 1359: FND_MSG_PUB.ADD;

1355: END IF;
1356: IF l_dummy <> 0 THEN
1357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1358: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_AGREEMENT_DELETE');
1359: FND_MSG_PUB.ADD;
1360: END IF;
1361: raise FND_API.G_EXC_ERROR;
1362: END IF;
1363: ELSIF p_code_conversion_type = 'OZF_PRODUCT_CODES' THEN

Line 1373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1369: ,g_party_id
1370: ,g_account_id);
1371: FETCH csr_code_conv_product_pt INTO l_dummy;
1372: CLOSE csr_code_conv_product_pt;
1373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1374: OZF_UTILITY_PVT.debug_message('l_dummy in delete code conersion: ' || l_dummy);
1375: END IF;
1376: END IF;
1377: -- Delete from site Profile

Line 1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1380: FETCH csr_code_conv_product INTO l_dummy;
1381: CLOSE csr_code_conv_product;
1382: END IF;
1383: IF l_dummy <> 0 THEN
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1385: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_PRODUCT_DELETE');
1386: FND_MSG_PUB.ADD;
1387: END IF;
1388: raise FND_API.G_EXC_ERROR;

Line 1386: FND_MSG_PUB.ADD;

1382: END IF;
1383: IF l_dummy <> 0 THEN
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1385: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_PRODUCT_DELETE');
1386: FND_MSG_PUB.ADD;
1387: END IF;
1388: raise FND_API.G_EXC_ERROR;
1389: END IF;
1390: ELSIF p_code_conversion_type = 'OZF_PARTY_CODES' THEN

Line 1424: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1420: l_sql := l_sql || l_where;
1421: l_interface_sql := l_interface_sql || l_where;
1422: END IF;
1423: for i in 1..ceil((length(l_sql)/100)) loop
1424: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1425: OZF_UTILITY_PVT.debug_message(substr(l_sql, (i-1)*100+1, 100));
1426: END IF;
1427: end loop;
1428: IF g_party_id IS NULL THEN

Line 1475: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1471: FETCH csr_code_conv_party INTO l_dummy;
1472: CLOSE csr_code_conv_party;
1473: END IF;
1474: IF l_dummy <> 0 THEN
1475: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1476: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_PARTY_DELETE');
1477: FND_MSG_PUB.ADD;
1478: END IF;
1479: RAISE FND_API.G_EXC_ERROR;

Line 1477: FND_MSG_PUB.ADD;

1473: END IF;
1474: IF l_dummy <> 0 THEN
1475: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1476: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_PARTY_DELETE');
1477: FND_MSG_PUB.ADD;
1478: END IF;
1479: RAISE FND_API.G_EXC_ERROR;
1480: END IF;
1481:

Line 1565: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1561: FETCH csr_code_conv_party INTO l_dummy;
1562: CLOSE csr_code_conv_party;
1563: END IF;
1564: IF l_dummy <> 0 THEN
1565: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1566: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_PARTY_SITE_DELETE');
1567: FND_MSG_PUB.ADD;
1568: END IF;
1569: RAISE FND_API.G_EXC_ERROR;

Line 1567: FND_MSG_PUB.ADD;

1563: END IF;
1564: IF l_dummy <> 0 THEN
1565: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1566: FND_MESSAGE.Set_Name('OZF', 'OZF_RESALE_PARTY_SITE_DELETE');
1567: FND_MSG_PUB.ADD;
1568: END IF;
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571: END IF; -- p_code_conversion_type

Line 1578: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1574:
1575: -- Api body
1576: --
1577: -- Debug Message
1578: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1579: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1580: END IF;
1581:
1582: BEGIN

Line 1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1593: COMMIT WORK;
1594: END IF;
1595:
1596: -- Debug Message
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1598: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1599: END IF;
1600:
1601: -- Standard call to get message count and if count is 1, get message info.

Line 1602: FND_MSG_PUB.Count_And_Get

1598: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1599: END IF;
1600:
1601: -- Standard call to get message count and if count is 1, get message info.
1602: FND_MSG_PUB.Count_And_Get
1603: (p_count => x_msg_count,
1604: p_data => x_msg_data
1605: );
1606: EXCEPTION

Line 1611: FND_MSG_PUB.Count_And_Get (

1607: WHEN FND_API.G_EXC_ERROR THEN
1608: ROLLBACK TO delete_code_conversion_pvt;
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: -- Standard call to get message count and if count=1, get the message
1611: FND_MSG_PUB.Count_And_Get (
1612: p_encoded => FND_API.G_FALSE,
1613: p_count => x_msg_count,
1614: p_data => x_msg_data
1615: );

Line 1620: FND_MSG_PUB.Count_And_Get (

1616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1617: ROLLBACK TO delete_code_conversion_pvt;
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1619: -- Standard call to get message count and if count=1, get the message
1620: FND_MSG_PUB.Count_And_Get (
1621: p_encoded => FND_API.G_FALSE,
1622: p_count => x_msg_count,
1623: p_data => x_msg_data
1624: );

Line 1628: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1624: );
1625: WHEN OTHERS THEN
1626: ROLLBACK TO delete_code_conversion_pvt;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message

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

1626: ROLLBACK TO delete_code_conversion_pvt;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,

Line 1633: FND_MSG_PUB.Count_And_Get (

1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1637: );

Line 1702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1698:
1699: BEGIN
1700:
1701: x_return_status := FND_API.g_ret_sts_success;
1702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1703: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1704: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_org_dummy);
1705: END IF;
1706: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1716: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1712: p_code_conversion_rec.party_id IS NULL
1713: THEN
1714: l_org_dummy := 0;
1715:
1716: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1717: OZF_UTILITY_PVT.debug_message('External code ' ||p_code_conversion_rec.external_code );
1718: OZF_UTILITY_PVT.debug_message('Start date active '|| p_code_conversion_rec.start_date_active );
1719: OZF_UTILITY_PVT.debug_message('End date active ' || p_code_conversion_rec.end_date_active );
1720: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

Line 1732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1728: INTO l_org_dummy;
1729: CLOSE csr_code_conv_4org;
1730:
1731:
1732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1733: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for org ' || p_code_conversion_rec.org_id );
1734: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1735: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1736: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );

Line 1752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1748: FETCH csr_code_conv_4party
1749: INTO l_party_dummy;
1750: CLOSE csr_code_conv_4party;
1751:
1752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1753: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for party ' || p_code_conversion_rec.party_id );
1754: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1755: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1756: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );

Line 1763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1759: IF l_party_dummy > 0 THEN
1760: l_valid_flag := FND_API.g_false;
1761: END IF;
1762:
1763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1764: OZF_UTILITY_PVT.debug_message('Count of code map for party ' || l_party_dummy);
1765: END IF;
1766: END IF;
1767: ELSE

Line 1777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1773: );
1774: FETCH csr_code_conv_4acct INTO l_acct_dummy;
1775: CLOSE csr_code_conv_4acct;
1776:
1777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1778: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for account ' || p_code_conversion_rec.cust_account_id );
1779: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1780: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1781: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );

Line 1793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1789: l_valid_flag := FND_API.g_true;
1790: END IF;
1791:
1792: IF l_valid_flag = FND_API.g_false THEN
1793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1794: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONVERSION_DUPLICATE');
1795: FND_MSG_PUB.add;
1796: END IF;
1797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1795: FND_MSG_PUB.add;

1791:
1792: IF l_valid_flag = FND_API.g_false THEN
1793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1794: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONVERSION_DUPLICATE');
1795: FND_MSG_PUB.add;
1796: END IF;
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: END IF;
1799:

Line 1825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1821: BEGIN
1822:
1823: x_return_status := FND_API.g_ret_sts_success;
1824:
1825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1826: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1827: END IF;
1828:
1829: IF p_code_conversion_rec.external_code = FND_API.g_miss_char OR

Line 1832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1828:
1829: IF p_code_conversion_rec.external_code = FND_API.g_miss_char OR
1830: p_code_conversion_rec.external_code IS NULL
1831: THEN
1832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1833: FND_MESSAGE.set_name('OZF', 'OZF_EXTERNAL_CODE_MISSING'||NVL(p_code_conversion_rec.external_code,'NULL'));
1834: FND_MSG_PUB.add;
1835: END IF;
1836: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1834: FND_MSG_PUB.add;

1830: p_code_conversion_rec.external_code IS NULL
1831: THEN
1832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1833: FND_MESSAGE.set_name('OZF', 'OZF_EXTERNAL_CODE_MISSING'||NVL(p_code_conversion_rec.external_code,'NULL'));
1834: FND_MSG_PUB.add;
1835: END IF;
1836: x_return_status := FND_API.G_RET_STS_ERROR;
1837: RETURN;
1838: END IF;

Line 1840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1836: x_return_status := FND_API.G_RET_STS_ERROR;
1837: RETURN;
1838: END IF;
1839:
1840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1841: OZF_UTILITY_PVT.debug_message('external code '||p_code_conversion_rec.external_code);
1842: OZF_UTILITY_PVT.debug_message('end of check_code_conv_req_items');
1843: END IF;
1844:

Line 1867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1863: BEGIN
1864:
1865: x_return_status := FND_API.g_ret_sts_success;
1866:
1867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1868: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1869: END IF;
1870:
1871: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1871: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1872:
1873: IF NVL(p_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
1874: THEN
1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1876: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_BKDATED');
1877: FND_MSG_PUB.add;
1878: END IF;
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1877: FND_MSG_PUB.add;

1873: IF NVL(p_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
1874: THEN
1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1876: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_BKDATED');
1877: FND_MSG_PUB.add;
1878: END IF;
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;
1881: END IF;

Line 1888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1884:
1885: -- IF NVL(p_code_conversion_rec.end_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
1886: IF (TO_DATE(TO_CHAR(NVL(p_code_conversion_rec.end_date_active,TRUNC(SYSDATE)), 'DD/MM/YYYY'),'DD/MM/YYYY') < TRUNC(SYSDATE))
1887: THEN
1888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1889: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_ENDDATE_BKDATED');
1890: FND_MSG_PUB.add;
1891: END IF;
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1890: FND_MSG_PUB.add;

1886: IF (TO_DATE(TO_CHAR(NVL(p_code_conversion_rec.end_date_active,TRUNC(SYSDATE)), 'DD/MM/YYYY'),'DD/MM/YYYY') < TRUNC(SYSDATE))
1887: THEN
1888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1889: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_ENDDATE_BKDATED');
1890: FND_MSG_PUB.add;
1891: END IF;
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1893: END IF;
1894:

Line 1902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1898: -- NVL(p_code_conversion_rec.end_date_active,NVL(p_code_conversion_rec.Start_Date_Active,TRUNC(SYSDATE)) + 1)
1899: IF (TO_DATE(TO_CHAR(NVL(p_code_conversion_rec.Start_Date_Active,TRUNC(SYSDATE)),'DD/MM/YYYY'),'DD/MM/YYYY') >
1900: TO_DATE(TO_CHAR(NVL(p_code_conversion_rec.end_date_active, NVL(p_code_conversion_rec.Start_Date_Active,TRUNC(SYSDATE)) +1 ), 'DD/MM/YYYY'),'DD/MM/YYYY'))
1901: THEN
1902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1903: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_GREATE');
1904: FND_MSG_PUB.add;
1905: END IF;
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1904: FND_MSG_PUB.add;

1900: TO_DATE(TO_CHAR(NVL(p_code_conversion_rec.end_date_active, NVL(p_code_conversion_rec.Start_Date_Active,TRUNC(SYSDATE)) +1 ), 'DD/MM/YYYY'),'DD/MM/YYYY'))
1901: THEN
1902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1903: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_GREATE');
1904: FND_MSG_PUB.add;
1905: END IF;
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: END IF;
1908:

Line 1926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1922: BEGIN
1923:
1924: x_return_status := FND_API.g_ret_sts_success;
1925:
1926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1927: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1928: END IF;
1929:
1930: check_code_conv_req_items( p_code_conversion_rec,

Line 1938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1934: IF x_return_status <> FND_API.g_ret_sts_success THEN
1935: RETURN;
1936: END IF;
1937:
1938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1939: OZF_UTILITY_PVT.debug_message('after check_code_conv_req_items ' );
1940: END IF;
1941:
1942:

Line 1951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1947: IF x_return_status <> FND_API.g_ret_sts_success THEN
1948: RETURN;
1949: END IF;
1950:
1951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1952: OZF_UTILITY_PVT.debug_message('after check_uniq_code_conversion ' );
1953: END IF;
1954:
1955: check_code_conversion_dt (p_code_conversion_rec,

Line 1963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1959: IF x_return_status <> FND_API.g_ret_sts_success Then
1960: RETURN;
1961: END IF;
1962:
1963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1964: OZF_UTILITY_PVT.debug_message('after check_code_conversion_dt ' );
1965: END IF;
1966:
1967: END check_code_conversion_items;

Line 2011: FND_MSG_PUB.initialize;

2007:
2008: -- Initialize message list if p_init_msg_list is set to TRUE.
2009: IF FND_API.to_Boolean( p_init_msg_list )
2010: THEN
2011: FND_MSG_PUB.initialize;
2012: END IF;
2013: -- Call the Validate Item procedure for the item(field level validations )
2014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2015: OZF_UTILITY_PVT.debug_message('in '||l_api_name );

Line 2014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2010: THEN
2011: FND_MSG_PUB.initialize;
2012: END IF;
2013: -- Call the Validate Item procedure for the item(field level validations )
2014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2015: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2016: END IF;
2017: x_return_status := FND_API.g_ret_sts_success;
2018:

Line 2023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2019: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2020:
2021: FOR i in 1 .. p_code_conversion_tbl.count
2022: LOOP
2023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2024: OZF_UTILITY_PVT.debug_message('inside the loop p_code_conversion_tbl ' );
2025: END IF;
2026: l_code_conversion_rec := p_code_conversion_tbl(i);
2027:

Line 2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2024: OZF_UTILITY_PVT.debug_message('inside the loop p_code_conversion_tbl ' );
2025: END IF;
2026: l_code_conversion_rec := p_code_conversion_tbl(i);
2027:
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2029: OZF_UTILITY_PVT.debug_message('External code ' || l_code_conversion_rec.external_code );
2030: OZF_UTILITY_PVT.debug_message('Start date active '|| l_code_conversion_rec.start_date_active );
2031: OZF_UTILITY_PVT.debug_message('End date active ' || l_code_conversion_rec.end_date_active );
2032: END IF;

Line 2051: FND_MSG_PUB.Count_And_Get

2047: END IF;
2048: -- Initialize API return status to SUCCESS
2049: x_return_status := FND_API.G_RET_STS_SUCCESS;
2050: -- Standard call to get message count and if count is 1, get message info.
2051: FND_MSG_PUB.Count_And_Get
2052: (p_count => x_msg_count,
2053: p_data => x_msg_data
2054: );
2055: EXCEPTION

Line 2058: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2054: );
2055: EXCEPTION
2056: WHEN OZF_Utility_PVT.resource_locked THEN
2057: x_return_status := FND_API.g_ret_sts_error;
2058: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2059: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
2060: FND_MSG_PUB.add;
2061: END IF;
2062: WHEN FND_API.G_EXC_ERROR THEN

Line 2060: FND_MSG_PUB.add;

2056: WHEN OZF_Utility_PVT.resource_locked THEN
2057: x_return_status := FND_API.g_ret_sts_error;
2058: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2059: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
2060: FND_MSG_PUB.add;
2061: END IF;
2062: WHEN FND_API.G_EXC_ERROR THEN
2063: ROLLBACK TO validate_code_conversion_pvt;
2064: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2066: FND_MSG_PUB.Count_And_Get (

2062: WHEN FND_API.G_EXC_ERROR THEN
2063: ROLLBACK TO validate_code_conversion_pvt;
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: -- Standard call to get message count and if count=1, get the message
2066: FND_MSG_PUB.Count_And_Get (
2067: p_encoded => FND_API.G_FALSE,
2068: p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );

Line 2075: FND_MSG_PUB.Count_And_Get (

2071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2072: ROLLBACK TO validate_code_conversion_pvt;
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: -- Standard call to get message count and if count=1, get the message
2075: FND_MSG_PUB.Count_And_Get (
2076: p_encoded => FND_API.G_FALSE,
2077: p_count => x_msg_count,
2078: p_data => x_msg_data
2079: );

Line 2083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2079: );
2080: WHEN OTHERS THEN
2081: ROLLBACK TO validate_code_conversion_pvt;
2082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2084: THEN
2085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2086: END IF;
2087: -- Standard call to get message count and if count=1, get the message

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

2081: ROLLBACK TO validate_code_conversion_pvt;
2082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2084: THEN
2085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2086: END IF;
2087: -- Standard call to get message count and if count=1, get the message
2088: FND_MSG_PUB.Count_And_Get (
2089: p_encoded => FND_API.G_FALSE,

Line 2088: FND_MSG_PUB.Count_And_Get (

2084: THEN
2085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2086: END IF;
2087: -- Standard call to get message count and if count=1, get the message
2088: FND_MSG_PUB.Count_And_Get (
2089: p_encoded => FND_API.G_FALSE,
2090: p_count => x_msg_count,
2091: p_data => x_msg_data
2092: );

Line 2201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2197:
2198: CLOSE csr_get_internal_code_party;
2199: END IF;
2200:
2201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2202: OZF_UTILITY_PVT.debug_message(' Internal Code ' || l_internal_code);
2203: END IF;
2204: x_internal_code := l_internal_code;
2205:

Line 2222: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2218:
2219: IF csr_get_internal_code%ISOPEN THEN
2220: CLOSE csr_get_internal_code;
2221: END IF;
2222: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2223: THEN
2224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2225: END IF;
2226: -- Standard call to get message count and if count=1, get the message

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

2220: CLOSE csr_get_internal_code;
2221: END IF;
2222: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2223: THEN
2224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2225: END IF;
2226: -- Standard call to get message count and if count=1, get the message
2227: FND_MSG_PUB.Count_And_Get (
2228: p_encoded => FND_API.G_FALSE,

Line 2227: FND_MSG_PUB.Count_And_Get (

2223: THEN
2224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2225: END IF;
2226: -- Standard call to get message count and if count=1, get the message
2227: FND_MSG_PUB.Count_And_Get (
2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data
2231: );

Line 2278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2274: /* 3/25/2008 -gdeepika- Bug 6832508 */
2275: /* For the code conversions at a supplier site , only one valid internal code
2276: should exist for a particular external code on a particular date.*/
2277: x_return_status := FND_API.g_ret_sts_success;
2278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2279: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2280: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_dummy);
2281: END IF;
2282:

Line 2305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2301: FETCH csr_code_conv
2302: INTO l_dummy;
2303: CLOSE csr_code_conv;
2304:
2305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2306: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_supp_code_conversion_rec.external_code || ' for org ' || p_supp_code_conversion_rec.org_id );
2307: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_supp_code_conversion_rec.internal_code );
2308: OZF_UTILITY_PVT.debug_message('with start date active '|| p_supp_code_conversion_rec.start_date_active );
2309: OZF_UTILITY_PVT.debug_message('and end date active ' || p_supp_code_conversion_rec.end_date_active );

Line 2321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2317:
2318: END IF;
2319:
2320: IF l_valid_flag = FND_API.g_false THEN
2321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2322: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONVERSION_DUPLICATE');
2323: FND_MSG_PUB.add;
2324: END IF;
2325: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2323: FND_MSG_PUB.add;

2319:
2320: IF l_valid_flag = FND_API.g_false THEN
2321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2322: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONVERSION_DUPLICATE');
2323: FND_MSG_PUB.add;
2324: END IF;
2325: x_return_status := FND_API.G_RET_STS_ERROR;
2326: RETURN;
2327: END IF;

Line 2354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2350: BEGIN
2351:
2352: x_return_status := FND_API.g_ret_sts_success;
2353:
2354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2355: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2356: END IF;
2357:
2358: IF p_supp_code_conversion_rec.external_code = FND_API.g_miss_char OR

Line 2361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2357:
2358: IF p_supp_code_conversion_rec.external_code = FND_API.g_miss_char OR
2359: p_supp_code_conversion_rec.external_code IS NULL
2360: THEN
2361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2362: FND_MESSAGE.set_name('OZF', 'OZF_EXTERNAL_CODE_MISSING'||NVL(p_supp_code_conversion_rec.external_code,'NULL'));
2363: FND_MSG_PUB.add;
2364: END IF;
2365: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2363: FND_MSG_PUB.add;

2359: p_supp_code_conversion_rec.external_code IS NULL
2360: THEN
2361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2362: FND_MESSAGE.set_name('OZF', 'OZF_EXTERNAL_CODE_MISSING'||NVL(p_supp_code_conversion_rec.external_code,'NULL'));
2363: FND_MSG_PUB.add;
2364: END IF;
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: RETURN;
2367: END IF;

Line 2369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: RETURN;
2367: END IF;
2368:
2369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2370: OZF_UTILITY_PVT.debug_message('external code '||p_supp_code_conversion_rec.external_code);
2371: OZF_UTILITY_PVT.debug_message('end of check_supp_code_conv_req_items');
2372: END IF;
2373:

Line 2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2392: BEGIN
2393:
2394: x_return_status := FND_API.g_ret_sts_success;
2395:
2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2397: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2398: END IF;
2399:
2400: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 2404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2400: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2401:
2402: IF NVL(p_supp_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
2403: THEN
2404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2405: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_BKDATED');
2406: FND_MSG_PUB.add;
2407: END IF;
2408: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2406: FND_MSG_PUB.add;

2402: IF NVL(p_supp_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
2403: THEN
2404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2405: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_BKDATED');
2406: FND_MSG_PUB.add;
2407: END IF;
2408: x_return_status := FND_API.G_RET_STS_ERROR;
2409: RETURN;
2410: END IF;

Line 2418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2414:
2415: -- IF NVL(p_supp_code_conversion_rec.end_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
2416: IF (TO_DATE(TO_CHAR(NVL(p_supp_code_conversion_rec.end_date_active,TRUNC(SYSDATE)), 'DD/MM/YYYY'),'DD/MM/YYYY') < TRUNC(SYSDATE))
2417: THEN
2418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2419: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_ENDDATE_BKDATED');
2420: FND_MSG_PUB.add;
2421: END IF;
2422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2420: FND_MSG_PUB.add;

2416: IF (TO_DATE(TO_CHAR(NVL(p_supp_code_conversion_rec.end_date_active,TRUNC(SYSDATE)), 'DD/MM/YYYY'),'DD/MM/YYYY') < TRUNC(SYSDATE))
2417: THEN
2418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2419: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_ENDDATE_BKDATED');
2420: FND_MSG_PUB.add;
2421: END IF;
2422: x_return_status := FND_API.G_RET_STS_ERROR;
2423: RETURN;
2424: END IF;

Line 2430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2426:
2427: IF (TO_DATE(TO_CHAR(NVL(p_supp_code_conversion_rec.Start_Date_Active,TRUNC(SYSDATE)),'DD/MM/YYYY'),'DD/MM/YYYY') >
2428: TO_DATE(TO_CHAR(NVL(p_supp_code_conversion_rec.end_date_active, NVL(p_supp_code_conversion_rec.Start_Date_Active,TRUNC(SYSDATE)) +1 ), 'DD/MM/YYYY'),'DD/MM/YYYY'))
2429: THEN
2430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2431: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_GREATE');
2432: FND_MSG_PUB.add;
2433: END IF;
2434: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2432: FND_MSG_PUB.add;

2428: TO_DATE(TO_CHAR(NVL(p_supp_code_conversion_rec.end_date_active, NVL(p_supp_code_conversion_rec.Start_Date_Active,TRUNC(SYSDATE)) +1 ), 'DD/MM/YYYY'),'DD/MM/YYYY'))
2429: THEN
2430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2431: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_GREATE');
2432: FND_MSG_PUB.add;
2433: END IF;
2434: x_return_status := FND_API.G_RET_STS_ERROR;
2435: RETURN;
2436: END IF;

Line 2515: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2511:
2512: IF csr_get_internal_code%ISOPEN THEN
2513: CLOSE csr_get_internal_code;
2514: END IF;
2515: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2516: THEN
2517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2518: END IF;
2519: -- Standard call to get message count and if count=1, get the message

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

2513: CLOSE csr_get_internal_code;
2514: END IF;
2515: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2516: THEN
2517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2518: END IF;
2519: -- Standard call to get message count and if count=1, get the message
2520: FND_MSG_PUB.Count_And_Get (
2521: p_encoded => FND_API.G_FALSE,

Line 2520: FND_MSG_PUB.Count_And_Get (

2516: THEN
2517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2518: END IF;
2519: -- Standard call to get message count and if count=1, get the message
2520: FND_MSG_PUB.Count_And_Get (
2521: p_encoded => FND_API.G_FALSE,
2522: p_count => x_msg_count,
2523: p_data => x_msg_data
2524: );

Line 2544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2540: BEGIN
2541:
2542: x_return_status := FND_API.g_ret_sts_success;
2543:
2544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2545: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2546: END IF;
2547:
2548: check_supp_code_conv_req_items( p_supp_code_conversion_rec,

Line 2556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2552: IF x_return_status <> FND_API.g_ret_sts_success THEN
2553: RETURN;
2554: END IF;
2555:
2556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2557: OZF_UTILITY_PVT.debug_message('after check_supp_code_conv_req_items ' );
2558: END IF;
2559:
2560:

Line 2569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2565: IF x_return_status <> FND_API.g_ret_sts_success THEN
2566: RETURN;
2567: END IF;
2568:
2569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2570: OZF_UTILITY_PVT.debug_message('after check_uniq_supp_code_conversion ' );
2571: END IF;
2572:
2573: check_supp_code_conversion_dt (p_supp_code_conversion_rec,

Line 2581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2577: IF x_return_status <> FND_API.g_ret_sts_success Then
2578: RETURN;
2579: END IF;
2580:
2581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2582: OZF_UTILITY_PVT.debug_message('after check_supp_code_conversion_dt ' );
2583: END IF;
2584:
2585: END check_supp_code_conv_items;

Line 2621: FND_MSG_PUB.initialize;

2617:
2618: -- Initialize message list if p_init_msg_list is set to TRUE.
2619: IF FND_API.to_Boolean( p_init_msg_list )
2620: THEN
2621: FND_MSG_PUB.initialize;
2622: END IF;
2623: -- Call the Validate Item procedure for the item(field level validations )
2624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2625: OZF_UTILITY_PVT.debug_message('in '||l_api_name );

Line 2624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2620: THEN
2621: FND_MSG_PUB.initialize;
2622: END IF;
2623: -- Call the Validate Item procedure for the item(field level validations )
2624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2625: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2626: END IF;
2627: x_return_status := FND_API.g_ret_sts_success;
2628:

Line 2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2629: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2630:
2631: FOR i in 1 .. p_supp_code_conversion_tbl.count
2632: LOOP
2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2634: OZF_UTILITY_PVT.debug_message('inside the loop p_supp_code_conversion_tbl ' );
2635: END IF;
2636: l_supp_code_conversion_rec := p_supp_code_conversion_tbl(i);
2637:

Line 2638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2634: OZF_UTILITY_PVT.debug_message('inside the loop p_supp_code_conversion_tbl ' );
2635: END IF;
2636: l_supp_code_conversion_rec := p_supp_code_conversion_tbl(i);
2637:
2638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2639: OZF_UTILITY_PVT.debug_message('External code ' || l_supp_code_conversion_rec.external_code );
2640: OZF_UTILITY_PVT.debug_message('Start date active '|| l_supp_code_conversion_rec.start_date_active );
2641: OZF_UTILITY_PVT.debug_message('End date active ' || l_supp_code_conversion_rec.end_date_active );
2642: END IF;

Line 2660: FND_MSG_PUB.Count_And_Get

2656: END IF;
2657: -- Initialize API return status to SUCCESS
2658: x_return_status := FND_API.G_RET_STS_SUCCESS;
2659: -- Standard call to get message count and if count is 1, get message info.
2660: FND_MSG_PUB.Count_And_Get
2661: (p_count => x_msg_count,
2662: p_data => x_msg_data
2663: );
2664: EXCEPTION

Line 2667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2663: );
2664: EXCEPTION
2665: WHEN OZF_Utility_PVT.resource_locked THEN
2666: x_return_status := FND_API.g_ret_sts_error;
2667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2668: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
2669: FND_MSG_PUB.add;
2670: END IF;
2671: WHEN FND_API.G_EXC_ERROR THEN

Line 2669: FND_MSG_PUB.add;

2665: WHEN OZF_Utility_PVT.resource_locked THEN
2666: x_return_status := FND_API.g_ret_sts_error;
2667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2668: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
2669: FND_MSG_PUB.add;
2670: END IF;
2671: WHEN FND_API.G_EXC_ERROR THEN
2672: ROLLBACK TO validate_supp_code_conv_pvt;
2673: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2675: FND_MSG_PUB.Count_And_Get (

2671: WHEN FND_API.G_EXC_ERROR THEN
2672: ROLLBACK TO validate_supp_code_conv_pvt;
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674: -- Standard call to get message count and if count=1, get the message
2675: FND_MSG_PUB.Count_And_Get (
2676: p_encoded => FND_API.G_FALSE,
2677: p_count => x_msg_count,
2678: p_data => x_msg_data
2679: );

Line 2684: FND_MSG_PUB.Count_And_Get (

2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: ROLLBACK TO validate_supp_code_conv_pvt;
2682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2683: -- Standard call to get message count and if count=1, get the message
2684: FND_MSG_PUB.Count_And_Get (
2685: p_encoded => FND_API.G_FALSE,
2686: p_count => x_msg_count,
2687: p_data => x_msg_data
2688: );

Line 2692: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2688: );
2689: WHEN OTHERS THEN
2690: ROLLBACK TO validate_supp_code_conv_pvt;
2691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2692: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2693: THEN
2694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2695: END IF;
2696: -- Standard call to get message count and if count=1, get the message

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

2690: ROLLBACK TO validate_supp_code_conv_pvt;
2691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2692: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2693: THEN
2694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2695: END IF;
2696: -- Standard call to get message count and if count=1, get the message
2697: FND_MSG_PUB.Count_And_Get (
2698: p_encoded => FND_API.G_FALSE,

Line 2697: FND_MSG_PUB.Count_And_Get (

2693: THEN
2694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2695: END IF;
2696: -- Standard call to get message count and if count=1, get the message
2697: FND_MSG_PUB.Count_And_Get (
2698: p_encoded => FND_API.G_FALSE,
2699: p_count => x_msg_count,
2700: p_data => x_msg_data
2701: );

Line 2744: FND_MSG_PUB.initialize;

2740:
2741: -- Initialize message list if p_init_msg_list is set to TRUE.
2742: IF FND_API.to_Boolean( p_init_msg_list )
2743: THEN
2744: FND_MSG_PUB.initialize;
2745: END IF;
2746:
2747:
2748: -- ******************************************************************

Line 2753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2749: -- Validate Environment
2750: -- ******************************************************************
2751: IF FND_GLOBAL.User_Id IS NULL
2752: THEN
2753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2754: THEN
2755: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
2756: FND_MSG_PUB.ADD;
2757: END IF;

Line 2756: FND_MSG_PUB.ADD;

2752: THEN
2753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2754: THEN
2755: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
2756: FND_MSG_PUB.ADD;
2757: END IF;
2758: RAISE FND_API.G_EXC_ERROR;
2759: END IF;
2760:

Line 2762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2758: RAISE FND_API.G_EXC_ERROR;
2759: END IF;
2760:
2761: -- Debug Message
2762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2763: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2764: END IF;
2765:
2766: -- Initialize API return status to SUCCESS

Line 2769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2765:
2766: -- Initialize API return status to SUCCESS
2767: x_return_status := FND_API.G_RET_STS_SUCCESS;
2768:
2769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2770: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_supp_code_conversion_tbl.count);
2771: END IF;
2772:
2773: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 2793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2789: RAISE FND_API.G_EXC_ERROR;
2790: END IF;
2791:
2792: -- Debug Message
2793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2794: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
2795: END IF;
2796:
2797: l_code_conversion_id := NULL;

Line 2802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2798: l_object_version_number := NULL;
2799:
2800: x_supp_code_conversion_id_tbl := JTF_NUMBER_TABLE();
2801:
2802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2803: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_supp_code_conversion_tbl.count);
2804: END IF;
2805:
2806: FOR i IN 1 .. p_supp_code_conversion_tbl.count

Line 2818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2814: l_org_id := l_supp_code_conversion_rec.org_id;
2815: END IF;
2816: SELECT ozf_supp_code_conv_all_s.nextval INTO l_code_conversion_id FROM DUAL;
2817:
2818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2819: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
2820: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);
2821: END IF;
2822:

Line 2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2860: WHEN OTHERS THEN
2861: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating supp_code conversion map');
2862: RAISE FND_API.G_EXC_ERROR;
2863: END;
2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2865: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - supp_code conversion id' || l_code_conversion_id);
2866: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_supp_code_conversion_rec.Object_Version_Number);
2867: END IF;
2868:

Line 2881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

2877: COMMIT WORK;
2878: END IF;
2879:
2880: -- Debug Message
2881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2882: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2883: END IF;
2884:
2885: -- Standard call to get message count and if count is 1, get message info.

Line 2886: FND_MSG_PUB.Count_And_Get

2882: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2883: END IF;
2884:
2885: -- Standard call to get message count and if count is 1, get message info.
2886: FND_MSG_PUB.Count_And_Get
2887: (p_count => x_msg_count,
2888: p_data => x_msg_data
2889: );
2890:

Line 2896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2892:
2893: EXCEPTION
2894: WHEN OZF_UTILITY_PVT.resource_locked THEN
2895: x_return_status := FND_API.g_ret_sts_error;
2896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2897: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
2898: FND_MSG_PUB.add;
2899: END IF;
2900: WHEN FND_API.G_EXC_ERROR THEN

Line 2898: FND_MSG_PUB.add;

2894: WHEN OZF_UTILITY_PVT.resource_locked THEN
2895: x_return_status := FND_API.g_ret_sts_error;
2896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2897: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
2898: FND_MSG_PUB.add;
2899: END IF;
2900: WHEN FND_API.G_EXC_ERROR THEN
2901: ROLLBACK TO create_supp_code_conv_pvt;
2902: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2904: FND_MSG_PUB.Count_And_Get (

2900: WHEN FND_API.G_EXC_ERROR THEN
2901: ROLLBACK TO create_supp_code_conv_pvt;
2902: x_return_status := FND_API.G_RET_STS_ERROR;
2903: -- Standard call to get message count and if count=1, get the message
2904: FND_MSG_PUB.Count_And_Get (
2905: p_encoded => FND_API.G_FALSE,
2906: p_count => x_msg_count,
2907: p_data => x_msg_data
2908: );

Line 2913: FND_MSG_PUB.Count_And_Get (

2909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2910: ROLLBACK TO create_code_conversion_pvt;
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912: -- Standard call to get message count and if count=1, get the message
2913: FND_MSG_PUB.Count_And_Get (
2914: p_encoded => FND_API.G_FALSE,
2915: p_count => x_msg_count,
2916: p_data => x_msg_data
2917: );

Line 2921: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2917: );
2918: WHEN OTHERS THEN
2919: ROLLBACK TO create_supp_code_conv_pvt;
2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2921: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2922: THEN
2923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2924: END IF;
2925: -- Standard call to get message count and if count=1, get the message

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

2919: ROLLBACK TO create_supp_code_conv_pvt;
2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2921: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2922: THEN
2923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2924: END IF;
2925: -- Standard call to get message count and if count=1, get the message
2926: FND_MSG_PUB.Count_And_Get (
2927: p_encoded => FND_API.G_FALSE,

Line 2926: FND_MSG_PUB.Count_And_Get (

2922: THEN
2923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2924: END IF;
2925: -- Standard call to get message count and if count=1, get the message
2926: FND_MSG_PUB.Count_And_Get (
2927: p_encoded => FND_API.G_FALSE,
2928: p_count => x_msg_count,
2929: p_data => x_msg_data
2930: );

Line 3017: FND_MSG_PUB.initialize;

3013:
3014: -- Initialize message list if p_init_msg_list is set to TRUE.
3015: IF FND_API.to_Boolean( p_init_msg_list )
3016: THEN
3017: FND_MSG_PUB.initialize;
3018: END IF;
3019:
3020: -- ******************************************************************
3021: -- Validate Environment

Line 3025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3021: -- Validate Environment
3022: -- ******************************************************************
3023: IF FND_GLOBAL.User_Id IS NULL
3024: THEN
3025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3026: THEN
3027: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3028: FND_MSG_PUB.ADD;
3029: END IF;

Line 3028: FND_MSG_PUB.ADD;

3024: THEN
3025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3026: THEN
3027: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3028: FND_MSG_PUB.ADD;
3029: END IF;
3030: RAISE FND_API.G_EXC_ERROR;
3031: END IF;
3032:

Line 3034: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3030: RAISE FND_API.G_EXC_ERROR;
3031: END IF;
3032:
3033: -- Debug Message
3034: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3035: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3036: END IF;
3037:
3038: -- Initialize API return status to SUCCESS

Line 3042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3038: -- Initialize API return status to SUCCESS
3039: x_return_status := FND_API.G_RET_STS_SUCCESS;
3040: x_object_version_number := JTF_NUMBER_TABLE();
3041:
3042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3043: OZF_UTILITY_PVT.debug_message('p_supp_code_conversion_tbl(1).description: ' || p_supp_code_conversion_tbl(1).description );
3044: END IF;
3045:
3046: FOR i in 1 .. p_supp_code_conversion_tbl.count

Line 3051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3047: LOOP
3048: p_supp_code_conversion_rec := p_supp_code_conversion_tbl(i);
3049: l_code_conversion_id := p_supp_code_conversion_rec.code_conversion_id;
3050:
3051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3052: OZF_UTILITY_PVT.debug_message( 'supp_code Conversion ID' || l_code_conversion_id);
3053: END IF;
3054:
3055: -- Check for the existance of the record

Line 3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3087: ,l_supp_code_conversion_rec.attribute14
3088: ,l_supp_code_conversion_rec.attribute15
3089: ,l_supp_code_conversion_rec.security_group_id;
3090:
3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3092: OZF_UTILITY_PVT.debug_message('Existing description '|| l_supp_code_conversion_rec.description);
3093: END IF;
3094:
3095: IF ( csr_supp_code_conversion%NOTFOUND) THEN

Line 3096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3092: OZF_UTILITY_PVT.debug_message('Existing description '|| l_supp_code_conversion_rec.description);
3093: END IF;
3094:
3095: IF ( csr_supp_code_conversion%NOTFOUND) THEN
3096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3097: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
3098: END IF;
3099:
3100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3097: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
3098: END IF;
3099:
3100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3101: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3102: FND_MSG_PUB.add;
3103: END IF;
3104: RAISE FND_API.G_EXC_ERROR;

Line 3102: FND_MSG_PUB.add;

3098: END IF;
3099:
3100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3101: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3102: FND_MSG_PUB.add;
3103: END IF;
3104: RAISE FND_API.G_EXC_ERROR;
3105: END IF;
3106: CLOSE csr_supp_code_conversion;

Line 3109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3105: END IF;
3106: CLOSE csr_supp_code_conversion;
3107:
3108:
3109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3110: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_supp_code_conversion_rec.object_version_number);
3111: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_supp_code_conversion_rec.object_version_number);
3112: END IF;
3113:

Line 3117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3113:
3114: --- Check the Version Number for Locking
3115: IF l_supp_code_conversion_rec.object_version_number <> P_supp_code_conversion_rec.Object_Version_number
3116: THEN
3117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3118: OZF_UTILITY_PVT.debug_message( 'dbver' || l_supp_code_conversion_rec.object_version_number);
3119: OZF_UTILITY_PVT.debug_message( 'reqver' || P_supp_code_conversion_rec.object_version_number);
3120: END IF;
3121:

Line 3122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3118: OZF_UTILITY_PVT.debug_message( 'dbver' || l_supp_code_conversion_rec.object_version_number);
3119: OZF_UTILITY_PVT.debug_message( 'reqver' || P_supp_code_conversion_rec.object_version_number);
3120: END IF;
3121:
3122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3123: THEN
3124: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
3125: FND_MSG_PUB.ADD;
3126: END IF;

Line 3125: FND_MSG_PUB.ADD;

3121:
3122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3123: THEN
3124: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
3125: FND_MSG_PUB.ADD;
3126: END IF;
3127: RAISE FND_API.G_EXC_ERROR;
3128: END IF;
3129:

Line 3135: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3131: -- Update internal code only when it is NUll
3132: IF l_supp_code_conversion_rec.internal_code IS NOT NULL AND
3133: l_supp_code_conversion_rec.internal_code <> P_supp_code_conversion_rec.internal_code
3134: THEN
3135: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3136: THEN
3137: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_INTLCODE');
3138: FND_MSG_PUB.ADD;
3139: END IF;

Line 3138: FND_MSG_PUB.ADD;

3134: THEN
3135: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3136: THEN
3137: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_INTLCODE');
3138: FND_MSG_PUB.ADD;
3139: END IF;
3140: RAISE FND_API.G_EXC_ERROR;
3141: END IF;
3142:

Line 3143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3139: END IF;
3140: RAISE FND_API.G_EXC_ERROR;
3141: END IF;
3142:
3143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3144: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_supp_code_conversion_rec.End_Date_Active);
3145: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_supp_code_conversion_rec.End_Date_Active);
3146: END IF;
3147:

Line 3153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3149: IF trunc(nvl(l_supp_code_conversion_Rec.End_Date_Active,sysdate+1)) <= TRUNC(SYSDATE)
3150: AND
3151: Trunc(l_supp_code_conversion_Rec.End_Date_Active) <> Trunc(P_supp_code_conversion_Rec.End_Date_Active)
3152: THEN
3153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3154: THEN
3155: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_ENDDATE');
3156: FND_MSG_PUB.ADD;
3157: END IF;

Line 3156: FND_MSG_PUB.ADD;

3152: THEN
3153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3154: THEN
3155: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_ENDDATE');
3156: FND_MSG_PUB.ADD;
3157: END IF;
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160:

Line 3161: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3157: END IF;
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160:
3161: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3162: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_supp_code_conversion_rec.Start_Date_Active);
3163: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_supp_code_conversion_rec.Start_Date_Active);
3164: END IF;
3165:

Line 3172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3168: <> trunc(P_supp_code_conversion_Rec.Start_Date_Active)
3169: THEN
3170: IF p_supp_code_conversion_Rec.Start_Date_Active < TRUNC(SYSDATE)
3171: THEN
3172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3173: THEN
3174: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_STARTDATE');
3175: FND_MSG_PUB.ADD;
3176: END IF;

Line 3175: FND_MSG_PUB.ADD;

3171: THEN
3172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3173: THEN
3174: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_STARTDATE');
3175: FND_MSG_PUB.ADD;
3176: END IF;
3177: RAISE FND_API.G_EXC_ERROR;
3178: END IF;
3179:

Line 3181: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3177: RAISE FND_API.G_EXC_ERROR;
3178: END IF;
3179:
3180: IF l_supp_code_conversion_Rec.end_date_active < p_supp_code_conversion_Rec.Start_Date_Active THEN
3181: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3182: THEN
3183: OZF_UTILITY_PVT.debug_message ('Cannot update an end dated code conversion map');
3184: END IF;
3185: raise FND_API.G_EXC_ERROR;

Line 3193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3189:
3190: -- Update not allowed for External Code
3191: IF l_supp_code_conversion_Rec.external_Code <> P_supp_code_conversion_Rec.external_Code
3192: THEN
3193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3194: THEN
3195: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_EXTCD');
3196: FND_MSG_PUB.ADD;
3197: END IF;

Line 3196: FND_MSG_PUB.ADD;

3192: THEN
3193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3194: THEN
3195: FND_MESSAGE.Set_Name('OZF', 'OZF_CODE_CONV_UPD_EXTCD');
3196: FND_MSG_PUB.ADD;
3197: END IF;
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200:

Line 3203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3199: END IF;
3200:
3201: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
3202: -- Debug message
3203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3204: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
3205: END IF;
3206: -- Invoke validation procedures
3207: Validate_supp_code_Conv(

Line 3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3227:
3228:
3229: -- Call Update Table Handler
3230: -- Debug Message
3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3232: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');
3233: END IF;
3234: BEGIN
3235: OZF_CODE_CONVERSION_PKG.Update_Supp_Code_Conv_Row(

Line 3288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3284: END IF;
3285:
3286:
3287: -- Debug Message
3288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3289: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3290: END IF;
3291: -- Standard call to get message count and if count is 1, get message info.
3292: FND_MSG_PUB.Count_And_Get

Line 3292: FND_MSG_PUB.Count_And_Get

3288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3289: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3290: END IF;
3291: -- Standard call to get message count and if count is 1, get message info.
3292: FND_MSG_PUB.Count_And_Get
3293: (p_count => x_msg_count,
3294: p_data => x_msg_data
3295: );
3296: EXCEPTION

Line 3301: FND_MSG_PUB.Count_And_Get (

3297: WHEN FND_API.G_EXC_ERROR THEN
3298: ROLLBACK TO update_supp_code_conv_pvt;
3299: x_return_status := FND_API.G_RET_STS_ERROR;
3300: -- Standard call to get message count and if count=1, get the message
3301: FND_MSG_PUB.Count_And_Get (
3302: p_encoded => FND_API.G_FALSE,
3303: p_count => x_msg_count,
3304: p_data => x_msg_data
3305: );

Line 3310: FND_MSG_PUB.Count_And_Get (

3306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3307: ROLLBACK TO update_supp_code_conv_pvt;
3308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3309: -- Standard call to get message count and if count=1, get the message
3310: FND_MSG_PUB.Count_And_Get (
3311: p_encoded => FND_API.G_FALSE,
3312: p_count => x_msg_count,
3313: p_data => x_msg_data
3314: );

Line 3318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3314: );
3315: WHEN OTHERS THEN
3316: ROLLBACK TO update_supp_code_conv_pvt;
3317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3319: THEN
3320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3321: END IF;
3322: -- Standard call to get message count and if count=1, get the message

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

3316: ROLLBACK TO update_supp_code_conv_pvt;
3317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3319: THEN
3320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3321: END IF;
3322: -- Standard call to get message count and if count=1, get the message
3323: FND_MSG_PUB.Count_And_Get (
3324: p_encoded => FND_API.G_FALSE,

Line 3323: FND_MSG_PUB.Count_And_Get (

3319: THEN
3320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3321: END IF;
3322: -- Standard call to get message count and if count=1, get the message
3323: FND_MSG_PUB.Count_And_Get (
3324: p_encoded => FND_API.G_FALSE,
3325: p_count => x_msg_count,
3326: p_data => x_msg_data
3327: );

Line 3365: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3361: BEGIN
3362: -- Standard Start of API savepoint
3363: SAVEPOINT update_supp_code_conv_tbl_pvt;
3364:
3365: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3366: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3367: END IF;
3368:
3369: -- Standard call to check for call compatibility.

Line 3381: FND_MSG_PUB.initialize;

3377:
3378: -- Initialize message list if p_init_msg_list is set to TRUE.
3379: IF FND_API.to_Boolean( p_init_msg_list )
3380: THEN
3381: FND_MSG_PUB.initialize;
3382: END IF;
3383:
3384: -- ******************************************************************
3385: -- Validate Environment

Line 3389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3385: -- Validate Environment
3386: -- ******************************************************************
3387: IF FND_GLOBAL.User_Id IS NULL
3388: THEN
3389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3390: THEN
3391: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3392: FND_MSG_PUB.ADD;
3393: END IF;

Line 3392: FND_MSG_PUB.ADD;

3388: THEN
3389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3390: THEN
3391: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3392: FND_MSG_PUB.ADD;
3393: END IF;
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396:

Line 3398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396:
3397: -- Debug Message
3398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3399: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3400: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_supp_code_conversion_Tbl.count);
3401: END IF;
3402: -- Initialize API return status to SUCCESS

Line 3435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3431: l_update_supp_code_conv_tbl.extend;
3432: l_update_supp_code_conv_tbl(l_up_cnt) := P_supp_code_conversion_Rec;
3433: END IF;
3434:
3435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3436: OZF_UTILITY_PVT.debug_message('End Date '||P_supp_code_conversion_Rec.end_date_active);
3437: END IF;
3438:
3439: END LOOP;

Line 3441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3437: END IF;
3438:
3439: END LOOP;
3440:
3441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3442: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);
3443: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);
3444: END IF;
3445:

Line 3492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3488: COMMIT WORK;
3489: END IF;
3490:
3491: -- Debug Message
3492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3493: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3494: END IF;
3495: -- Standard call to get message count and if count is 1, get message info.
3496: FND_MSG_PUB.Count_And_Get

Line 3496: FND_MSG_PUB.Count_And_Get

3492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3493: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3494: END IF;
3495: -- Standard call to get message count and if count is 1, get message info.
3496: FND_MSG_PUB.Count_And_Get
3497: (p_count => x_msg_count,
3498: p_data => x_msg_data
3499: );
3500: EXCEPTION

Line 3505: FND_MSG_PUB.Count_And_Get (

3501: WHEN FND_API.G_EXC_ERROR THEN
3502: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3503: x_return_status := FND_API.G_RET_STS_ERROR;
3504: -- Standard call to get message count and if count=1, get the message
3505: FND_MSG_PUB.Count_And_Get (
3506: p_encoded => FND_API.G_FALSE,
3507: p_count => x_msg_count,
3508: p_data => x_msg_data
3509: );

Line 3514: FND_MSG_PUB.Count_And_Get (

3510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3511: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3513: -- Standard call to get message count and if count=1, get the message
3514: FND_MSG_PUB.Count_And_Get (
3515: p_encoded => FND_API.G_FALSE,
3516: p_count => x_msg_count,
3517: p_data => x_msg_data
3518: );

Line 3522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3518: );
3519: WHEN OTHERS THEN
3520: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3523: THEN
3524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3525: END IF;
3526: -- Standard call to get message count and if count=1, get the message

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

3520: ROLLBACK TO update_supp_code_conv_tbl_pvt;
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3523: THEN
3524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3525: END IF;
3526: -- Standard call to get message count and if count=1, get the message
3527: FND_MSG_PUB.Count_And_Get (
3528: p_encoded => FND_API.G_FALSE,

Line 3527: FND_MSG_PUB.Count_And_Get (

3523: THEN
3524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3525: END IF;
3526: -- Standard call to get message count and if count=1, get the message
3527: FND_MSG_PUB.Count_And_Get (
3528: p_encoded => FND_API.G_FALSE,
3529: p_count => x_msg_count,
3530: p_data => x_msg_data
3531: );

Line 3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3558: BEGIN
3559: -- Standard Start of API savepoint
3560: SAVEPOINT delete_supp_code_conv_tbl_pvt;
3561:
3562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3563: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3564: END IF;
3565:
3566: -- Standard call to check for call compatibility.

Line 3578: FND_MSG_PUB.initialize;

3574:
3575: -- Initialize message list if p_init_msg_list is set to TRUE.
3576: IF FND_API.to_Boolean( p_init_msg_list )
3577: THEN
3578: FND_MSG_PUB.initialize;
3579: END IF;
3580:
3581: -- ******************************************************************
3582: -- Validate Environment

Line 3586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3582: -- Validate Environment
3583: -- ******************************************************************
3584: IF FND_GLOBAL.User_Id IS NULL
3585: THEN
3586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3587: THEN
3588: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3589: FND_MSG_PUB.ADD;
3590: END IF;

Line 3589: FND_MSG_PUB.ADD;

3585: THEN
3586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3587: THEN
3588: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3589: FND_MSG_PUB.ADD;
3590: END IF;
3591: RAISE FND_API.G_EXC_ERROR;
3592: END IF;
3593:

Line 3595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3591: RAISE FND_API.G_EXC_ERROR;
3592: END IF;
3593:
3594: -- Debug Message
3595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3596: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3597: END IF;
3598:
3599:

Line 3609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3605:
3606: l_code_conversion_id := P_supp_code_conversion_Tbl(i).code_conversion_id;
3607: l_object_version_number := P_supp_code_conversion_Tbl(i).object_version_number;
3608:
3609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3610: OZF_UTILITY_PVT.debug_message('supp_code Conversion ID ' || l_code_conversion_id);
3611: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);
3612: END IF;
3613:

Line 3617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3613:
3614: IF l_object_version_number IS NULL
3615: OR l_code_conversion_id IS NULL THEN
3616:
3617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3618: OZF_UTILITY_PVT.debug_message('In If block');
3619: END IF;
3620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3621: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');

Line 3620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3616:
3617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3618: OZF_UTILITY_PVT.debug_message('In If block');
3619: END IF;
3620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3621: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');
3622: FND_MSG_PUB.add;
3623: END IF;
3624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3622: FND_MSG_PUB.add;

3618: OZF_UTILITY_PVT.debug_message('In If block');
3619: END IF;
3620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3621: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');
3622: FND_MSG_PUB.add;
3623: END IF;
3624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3625: ELSE
3626: Delete_supp_code_Conversion(

Line 3655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3651: COMMIT WORK;
3652: END IF;
3653:
3654: -- Debug Message
3655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3656: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3657: END IF;
3658: -- Standard call to get message count and if count is 1, get message info.
3659: FND_MSG_PUB.Count_And_Get

Line 3659: FND_MSG_PUB.Count_And_Get

3655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3656: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3657: END IF;
3658: -- Standard call to get message count and if count is 1, get message info.
3659: FND_MSG_PUB.Count_And_Get
3660: (p_count => x_msg_count,
3661: p_data => x_msg_data
3662: );
3663: EXCEPTION

Line 3668: FND_MSG_PUB.Count_And_Get (

3664: WHEN FND_API.G_EXC_ERROR THEN
3665: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3666: x_return_status := FND_API.G_RET_STS_ERROR;
3667: -- Standard call to get message count and if count=1, get the message
3668: FND_MSG_PUB.Count_And_Get (
3669: p_encoded => FND_API.G_FALSE,
3670: p_count => x_msg_count,
3671: p_data => x_msg_data
3672: );

Line 3677: FND_MSG_PUB.Count_And_Get (

3673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3674: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3676: -- Standard call to get message count and if count=1, get the message
3677: FND_MSG_PUB.Count_And_Get (
3678: p_encoded => FND_API.G_FALSE,
3679: p_count => x_msg_count,
3680: p_data => x_msg_data
3681: );

Line 3685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3681: );
3682: WHEN OTHERS THEN
3683: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3686: THEN
3687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3688: END IF;
3689: -- Standard call to get message count and if count=1, get the message

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

3683: ROLLBACK TO delete_supp_code_conv_tbl_pvt;
3684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3686: THEN
3687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3688: END IF;
3689: -- Standard call to get message count and if count=1, get the message
3690: FND_MSG_PUB.Count_And_Get (
3691: p_encoded => FND_API.G_FALSE,

Line 3690: FND_MSG_PUB.Count_And_Get (

3686: THEN
3687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3688: END IF;
3689: -- Standard call to get message count and if count=1, get the message
3690: FND_MSG_PUB.Count_And_Get (
3691: p_encoded => FND_API.G_FALSE,
3692: p_count => x_msg_count,
3693: p_data => x_msg_data
3694: );

Line 3737: FND_MSG_PUB.initialize;

3733:
3734: -- Initialize message list if p_init_msg_list is set to TRUE.
3735: IF FND_API.to_Boolean( p_init_msg_list )
3736: THEN
3737: FND_MSG_PUB.initialize;
3738: END IF;
3739:
3740: -- Debug Message
3741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 3741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3737: FND_MSG_PUB.initialize;
3738: END IF;
3739:
3740: -- Debug Message
3741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3742: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3743: END IF;
3744:
3745:

Line 3755: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3751:
3752: -- Api body
3753: --
3754: -- Debug Message
3755: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3756: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
3757: END IF;
3758:
3759: BEGIN

Line 3774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

3770: COMMIT WORK;
3771: END IF;
3772:
3773: -- Debug Message
3774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3775: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3776: END IF;
3777:
3778: -- Standard call to get message count and if count is 1, get message info.

Line 3779: FND_MSG_PUB.Count_And_Get

3775: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3776: END IF;
3777:
3778: -- Standard call to get message count and if count is 1, get message info.
3779: FND_MSG_PUB.Count_And_Get
3780: (p_count => x_msg_count,
3781: p_data => x_msg_data
3782: );
3783: EXCEPTION

Line 3788: FND_MSG_PUB.Count_And_Get (

3784: WHEN FND_API.G_EXC_ERROR THEN
3785: ROLLBACK TO delete_supp_code_conv_pvt;
3786: x_return_status := FND_API.G_RET_STS_ERROR;
3787: -- Standard call to get message count and if count=1, get the message
3788: FND_MSG_PUB.Count_And_Get (
3789: p_encoded => FND_API.G_FALSE,
3790: p_count => x_msg_count,
3791: p_data => x_msg_data
3792: );

Line 3797: FND_MSG_PUB.Count_And_Get (

3793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3794: ROLLBACK TO delete_supp_code_conv_pvt;
3795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3796: -- Standard call to get message count and if count=1, get the message
3797: FND_MSG_PUB.Count_And_Get (
3798: p_encoded => FND_API.G_FALSE,
3799: p_count => x_msg_count,
3800: p_data => x_msg_data
3801: );

Line 3805: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3801: );
3802: WHEN OTHERS THEN
3803: ROLLBACK TO delete_supp_code_conv_pvt;
3804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3805: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3806: THEN
3807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3808: END IF;
3809: -- Standard call to get message count and if count=1, get the message

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

3803: ROLLBACK TO delete_supp_code_conv_pvt;
3804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3805: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3806: THEN
3807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3808: END IF;
3809: -- Standard call to get message count and if count=1, get the message
3810: FND_MSG_PUB.Count_And_Get (
3811: p_encoded => FND_API.G_FALSE,

Line 3810: FND_MSG_PUB.Count_And_Get (

3806: THEN
3807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3808: END IF;
3809: -- Standard call to get message count and if count=1, get the message
3810: FND_MSG_PUB.Count_And_Get (
3811: p_encoded => FND_API.G_FALSE,
3812: p_count => x_msg_count,
3813: p_data => x_msg_data
3814: );