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 OZF_UTILITY_PVT

Line 82: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

78: END IF;
79:
80: -- Debug Message
81: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
82: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
83: END IF;
84:
85: -- Initialize API return status to SUCCESS
86: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 89: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_code_conversion_tbl.count);

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

Line 95: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);

91:
92: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
93: -- Debug message
94: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
95: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
96: END IF;
97:
98: -- Invoke validation procedures
99: Validate_Code_Conversion(

Line 117: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

113: END IF;
114:
115: -- Debug Message
116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
117: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
118: END IF;
119:
120: l_code_conversion_id := NULL;
121: l_object_version_number := NULL;

Line 126: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_code_conversion_tbl.count);

122:
123: x_code_conversion_id_tbl := JTF_NUMBER_TABLE();
124:
125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
126: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_code_conversion_tbl.count);
127: END IF;
128:
129: FOR i IN 1 .. p_code_conversion_tbl.count
130: LOOP

Line 149: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);

145:
146: SELECT ozf_code_conversions_all_s.nextval INTO l_code_conversion_id FROM DUAL;
147:
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
149: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
150: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);
151: END IF;
152:
153: BEGIN

Line 150: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);

146: SELECT ozf_code_conversions_all_s.nextval INTO l_code_conversion_id FROM DUAL;
147:
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
149: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
150: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);
151: END IF;
152:
153: BEGIN
154:

Line 192: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating code conversion map');

188: p_attribute15 => l_code_conversion_rec.attribute15);
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating code conversion map');
193: RAISE FND_API.G_EXC_ERROR;
194: END;
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
196: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - code conversion id' || l_code_conversion_id);

Line 196: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - code conversion id' || l_code_conversion_id);

192: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating code conversion map');
193: RAISE FND_API.G_EXC_ERROR;
194: END;
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
196: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - code conversion id' || l_code_conversion_id);
197: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_code_conversion_rec.Object_Version_Number);
198: END IF;
199:
200: x_code_conversion_id_tbl.extend;

Line 197: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_code_conversion_rec.Object_Version_Number);

193: RAISE FND_API.G_EXC_ERROR;
194: END;
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
196: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - code conversion id' || l_code_conversion_id);
197: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_code_conversion_rec.Object_Version_Number);
198: END IF;
199:
200: x_code_conversion_id_tbl.extend;
201: x_code_conversion_id_tbl(x_code_conversion_id_tbl.count) := l_code_conversion_id;

Line 213: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

209: END IF;
210:
211: -- Debug Message
212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
213: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
214: END IF;
215:
216: -- Standard call to get message count and if count is 1, get message info.
217: FND_MSG_PUB.Count_And_Get

Line 225: WHEN OZF_UTILITY_PVT.resource_locked THEN

221:
222:
223:
224: EXCEPTION
225: WHEN OZF_UTILITY_PVT.resource_locked THEN
226: x_return_status := FND_API.g_ret_sts_error;
227: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
228: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
229: FND_MSG_PUB.add;

Line 367: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

363: END IF;
364:
365: -- Debug Message
366: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
367: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
368: END IF;
369:
370: -- Initialize API return status to SUCCESS
371: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 375: OZF_UTILITY_PVT.debug_message('p_code_conversion_tbl(1).description: ' || p_code_conversion_tbl(1).description );

371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372: x_object_version_number := JTF_NUMBER_TABLE();
373:
374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
375: OZF_UTILITY_PVT.debug_message('p_code_conversion_tbl(1).description: ' || p_code_conversion_tbl(1).description );
376: END IF;
377:
378: FOR i in 1 .. p_code_conversion_tbl.count
379: LOOP

Line 384: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID' || l_code_conversion_id);

380: p_code_conversion_rec := p_code_conversion_tbl(i);
381: l_code_conversion_id := p_code_conversion_rec.code_conversion_id;
382:
383: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
384: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID' || l_code_conversion_id);
385: END IF;
386:
387: -- Check for the existance of the record
388: OPEN csr_code_conversion(l_code_conversion_id);

Line 425: OZF_UTILITY_PVT.debug_message('Existing description '|| l_code_conversion_rec.description);

421: ,l_code_conversion_rec.attribute15
422: ,l_code_conversion_rec.security_group_id;
423:
424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
425: OZF_UTILITY_PVT.debug_message('Existing description '|| l_code_conversion_rec.description);
426: END IF;
427:
428: IF ( csr_code_conversion%NOTFOUND) THEN
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 430: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');

426: END IF;
427:
428: IF ( csr_code_conversion%NOTFOUND) THEN
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
430: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
431: END IF;
432:
433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
434: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

Line 443: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_code_conversion_rec.object_version_number);

439: CLOSE csr_code_conversion;
440:
441:
442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
443: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_code_conversion_rec.object_version_number);
444: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_code_conversion_rec.object_version_number);
445: END IF;
446:
447: --- Check the Version Number for Locking

Line 444: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_code_conversion_rec.object_version_number);

440:
441:
442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
443: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_code_conversion_rec.object_version_number);
444: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_code_conversion_rec.object_version_number);
445: END IF;
446:
447: --- Check the Version Number for Locking
448: IF l_code_conversion_rec.object_version_number <> P_code_conversion_rec.Object_Version_number

Line 451: OZF_UTILITY_PVT.debug_message( 'dbver' || l_code_conversion_rec.object_version_number);

447: --- Check the Version Number for Locking
448: IF l_code_conversion_rec.object_version_number <> P_code_conversion_rec.Object_Version_number
449: THEN
450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
451: OZF_UTILITY_PVT.debug_message( 'dbver' || l_code_conversion_rec.object_version_number);
452: OZF_UTILITY_PVT.debug_message( 'reqver' || P_code_conversion_rec.object_version_number);
453: END IF;
454:
455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 452: OZF_UTILITY_PVT.debug_message( 'reqver' || P_code_conversion_rec.object_version_number);

448: IF l_code_conversion_rec.object_version_number <> P_code_conversion_rec.Object_Version_number
449: THEN
450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
451: OZF_UTILITY_PVT.debug_message( 'dbver' || l_code_conversion_rec.object_version_number);
452: OZF_UTILITY_PVT.debug_message( 'reqver' || P_code_conversion_rec.object_version_number);
453: END IF;
454:
455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
456: THEN

Line 476: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_code_conversion_rec.End_Date_Active);

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
476: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_code_conversion_rec.End_Date_Active);
477: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_code_conversion_rec.End_Date_Active);
478: END IF;
479:
480: -- Update End date only when it is NUll or a future date

Line 477: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_code_conversion_rec.End_Date_Active);

473: END IF;
474:
475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
476: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_code_conversion_rec.End_Date_Active);
477: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_code_conversion_rec.End_Date_Active);
478: END IF;
479:
480: -- Update End date only when it is NUll or a future date
481: IF trunc(nvl(l_code_conversion_Rec.End_Date_Active,sysdate+1)) <= TRUNC(SYSDATE)

Line 494: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_code_conversion_rec.Start_Date_Active);

490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
494: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_code_conversion_rec.Start_Date_Active);
495: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_code_conversion_rec.Start_Date_Active);
496: END IF;
497:
498: ---Update not allowed for Start Date when start date is earlier than current date

Line 495: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_code_conversion_rec.Start_Date_Active);

491: END IF;
492:
493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
494: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_code_conversion_rec.Start_Date_Active);
495: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_code_conversion_rec.Start_Date_Active);
496: END IF;
497:
498: ---Update not allowed for Start Date when start date is earlier than current date
499: IF trunc(l_code_conversion_Rec.Start_Date_Active)

Line 515: OZF_UTILITY_PVT.debug_message ('Cannot update an end dated code conversion map');

511:
512: IF l_code_conversion_Rec.end_date_active < p_code_conversion_Rec.Start_Date_Active THEN
513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
514: THEN
515: OZF_UTILITY_PVT.debug_message ('Cannot update an end dated code conversion map');
516: END IF;
517: raise FND_API.G_EXC_ERROR;
518: END IF;
519:

Line 536: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);

532:
533: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
534: -- Debug message
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
536: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
537: END IF;
538: -- Invoke validation procedures
539: Validate_Code_Conversion(
540: p_api_version_number => 1.0,

Line 564: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');

560:
561: -- Call Update Table Handler
562: -- Debug Message
563: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
564: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');
565: END IF;
566: BEGIN
567: OZF_CODE_CONVERSION_PKG.Update_Row(
568: p_code_conversion_id => l_code_conversion_id,

Line 603: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in updating code conversion map');

599:
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in updating code conversion map');
604: RAISE FND_API.G_EXC_ERROR;
605: END;
606:
607: x_object_version_number.EXTEND;

Line 622: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

618:
619:
620: -- Debug Message
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
622: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
623: END IF;
624: -- Standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get
626: (p_count => x_msg_count,

Line 699: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');

695: -- Standard Start of API savepoint
696: SAVEPOINT update_code_conversion_tbl_pvt;
697:
698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
699: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
700: END IF;
701:
702: -- Standard call to check for call compatibility.
703: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 732: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

728: END IF;
729:
730: -- Debug Message
731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
732: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
733: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_code_conversion_Tbl.count);
734: END IF;
735: -- Initialize API return status to SUCCESS
736: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 733: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_code_conversion_Tbl.count);

729:
730: -- Debug Message
731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
732: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
733: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_code_conversion_Tbl.count);
734: END IF;
735: -- Initialize API return status to SUCCESS
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737:

Line 769: OZF_UTILITY_PVT.debug_message('End Date '||P_code_conversion_Rec.end_date_active);

765: l_update_code_conv_tbl(l_up_cnt) := P_code_conversion_Rec;
766: END IF;
767:
768: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
769: OZF_UTILITY_PVT.debug_message('End Date '||P_code_conversion_Rec.end_date_active);
770: END IF;
771:
772: END LOOP;
773:

Line 775: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);

771:
772: END LOOP;
773:
774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
775: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);
776: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);
777: END IF;
778:
779: IF l_cc_cnt > 0 THEN

Line 776: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);

772: END LOOP;
773:
774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
775: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);
776: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);
777: END IF;
778:
779: IF l_cc_cnt > 0 THEN
780: --- Call to Create Procedure

Line 826: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

822: END IF;
823:
824: -- Debug Message
825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
826: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
827: END IF;
828: -- Standard call to get message count and if count is 1, get message info.
829: FND_MSG_PUB.Count_And_Get
830: (p_count => x_msg_count,

Line 896: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');

892: -- Standard Start of API savepoint
893: SAVEPOINT delete_code_conversion_tbl_pvt;
894:
895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
896: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
897: END IF;
898:
899: -- Standard call to check for call compatibility.
900: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 929: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

925: END IF;
926:
927: -- Debug Message
928: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
929: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
930: END IF;
931:
932:
933: -- Initialize API return status to SUCCESS

Line 943: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id);

939: l_code_conversion_id := P_code_conversion_Tbl(i).code_conversion_id;
940: l_object_version_number := P_code_conversion_Tbl(i).object_version_number;
941:
942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
943: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id);
944: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);
945: END IF;
946:
947: IF l_object_version_number IS NULL

Line 944: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);

940: l_object_version_number := P_code_conversion_Tbl(i).object_version_number;
941:
942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
943: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id);
944: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);
945: END IF;
946:
947: IF l_object_version_number IS NULL
948: OR l_code_conversion_id IS NULL THEN

Line 951: OZF_UTILITY_PVT.debug_message('In If block');

947: IF l_object_version_number IS NULL
948: OR l_code_conversion_id IS NULL THEN
949:
950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
951: OZF_UTILITY_PVT.debug_message('In If block');
952: END IF;
953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
954: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');
955: FND_MSG_PUB.add;

Line 1004: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1000: END IF;
1001:
1002: -- Debug Message
1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1004: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1005: END IF;
1006: -- Standard call to get message count and if count is 1, get message info.
1007: FND_MSG_PUB.Count_And_Get
1008: (p_count => x_msg_count,

Line 1179: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1175: END IF;
1176:
1177: -- Debug Message
1178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1179: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1180: END IF;
1181:
1182:
1183: -- Initialize API return status to SUCCESS

Line 1190: OZF_UTILITY_PVT.debug_message('Party ID in delete code conersion: ' || l_party_id);

1186: -- Validate the Delete Condition
1187: --
1188:
1189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1190: OZF_UTILITY_PVT.debug_message('Party ID in delete code conersion: ' || l_party_id);
1191: END IF;
1192: IF p_external_code IS NOT NULL THEN
1193:
1194: IF p_code_conversion_type = 'OZF_REASON_CODES' THEN

Line 1256: OZF_UTILITY_PVT.debug_message(substr(l_sql, (i-1)*100+1, 100));

1252: END IF;
1253:
1254: for i in 1..ceil((length(l_sql)/100)) loop
1255: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1256: OZF_UTILITY_PVT.debug_message(substr(l_sql, (i-1)*100+1, 100));
1257: END IF;
1258: end loop;
1259: IF g_party_id IS NULL THEN
1260: OPEN csr_code_conv_uom FOR l_sql USING p_external_code

Line 1361: OZF_UTILITY_PVT.debug_message('l_dummy in delete code conersion: ' || l_dummy);

1357: FETCH csr_code_conv_agreement_pt INTO l_dummy;
1358: CLOSE csr_code_conv_agreement_pt;
1359:
1360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1361: OZF_UTILITY_PVT.debug_message('l_dummy in delete code conersion: ' || l_dummy);
1362: END IF;
1363: END IF;
1364: IF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN
1365: OPEN csr_code_conv_agreement (p_external_code);

Line 1387: OZF_UTILITY_PVT.debug_message('l_dummy in delete code conersion: ' || l_dummy);

1383: ,g_account_id);
1384: FETCH csr_code_conv_product_pt INTO l_dummy;
1385: CLOSE csr_code_conv_product_pt;
1386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1387: OZF_UTILITY_PVT.debug_message('l_dummy in delete code conersion: ' || l_dummy);
1388: END IF;
1389: END IF;
1390: -- Delete from site Profile
1391: IF G_PARTY_ID IS NULL AND G_ACCOUNT_ID IS NULL THEN

Line 1438: OZF_UTILITY_PVT.debug_message(substr(l_sql, (i-1)*100+1, 100));

1434: l_interface_sql := l_interface_sql || l_where;
1435: END IF;
1436: for i in 1..ceil((length(l_sql)/100)) loop
1437: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1438: OZF_UTILITY_PVT.debug_message(substr(l_sql, (i-1)*100+1, 100));
1439: END IF;
1440: end loop;
1441: IF g_party_id IS NULL THEN
1442: OPEN csr_code_conv_party FOR l_sql USING p_external_code

Line 1592: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

1588: -- Api body
1589: --
1590: -- Debug Message
1591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1592: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1593: END IF;
1594:
1595: BEGIN
1596: OZF_CODE_CONVERSION_PKG.Delete_Row( p_code_conversion_id => p_code_conversion_id,

Line 1611: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1607: END IF;
1608:
1609: -- Debug Message
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1611: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1612: END IF;
1613:
1614: -- Standard call to get message count and if count is 1, get message info.
1615: FND_MSG_PUB.Count_And_Get

Line 1727: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

1723: BEGIN
1724:
1725: x_return_status := FND_API.g_ret_sts_success;
1726: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1727: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1728: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_org_dummy);
1729: END IF;
1730: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1731:

Line 1728: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_org_dummy);

1724:
1725: x_return_status := FND_API.g_ret_sts_success;
1726: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1727: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1728: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_org_dummy);
1729: END IF;
1730: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1731:
1732: IF p_code_conversion_rec.cust_account_id = FND_API.g_miss_num OR

Line 1741: OZF_UTILITY_PVT.debug_message('External code ' ||p_code_conversion_rec.external_code );

1737: THEN
1738: l_org_dummy := 0;
1739:
1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1741: OZF_UTILITY_PVT.debug_message('External code ' ||p_code_conversion_rec.external_code );
1742: OZF_UTILITY_PVT.debug_message('Start date active '|| p_code_conversion_rec.start_date_active );
1743: OZF_UTILITY_PVT.debug_message('End date active ' || p_code_conversion_rec.end_date_active );
1744: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1745: END IF;

Line 1742: OZF_UTILITY_PVT.debug_message('Start date active '|| p_code_conversion_rec.start_date_active );

1738: l_org_dummy := 0;
1739:
1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1741: OZF_UTILITY_PVT.debug_message('External code ' ||p_code_conversion_rec.external_code );
1742: OZF_UTILITY_PVT.debug_message('Start date active '|| p_code_conversion_rec.start_date_active );
1743: OZF_UTILITY_PVT.debug_message('End date active ' || p_code_conversion_rec.end_date_active );
1744: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1745: END IF;
1746:

Line 1743: OZF_UTILITY_PVT.debug_message('End date active ' || p_code_conversion_rec.end_date_active );

1739:
1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1741: OZF_UTILITY_PVT.debug_message('External code ' ||p_code_conversion_rec.external_code );
1742: OZF_UTILITY_PVT.debug_message('Start date active '|| p_code_conversion_rec.start_date_active );
1743: OZF_UTILITY_PVT.debug_message('End date active ' || p_code_conversion_rec.end_date_active );
1744: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1745: END IF;
1746:
1747: OPEN csr_code_conv_4org(p_code_conversion_rec.external_code,

Line 1744: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1741: OZF_UTILITY_PVT.debug_message('External code ' ||p_code_conversion_rec.external_code );
1742: OZF_UTILITY_PVT.debug_message('Start date active '|| p_code_conversion_rec.start_date_active );
1743: OZF_UTILITY_PVT.debug_message('End date active ' || p_code_conversion_rec.end_date_active );
1744: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1745: END IF;
1746:
1747: OPEN csr_code_conv_4org(p_code_conversion_rec.external_code,
1748: p_code_conversion_rec.start_date_active,

Line 1758: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for org ' || p_code_conversion_rec.org_id );

1754: CLOSE csr_code_conv_4org;
1755:
1756:
1757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1758: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for org ' || p_code_conversion_rec.org_id );
1759: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1760: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1761: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1762: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);

Line 1759: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );

1755:
1756:
1757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1758: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for org ' || p_code_conversion_rec.org_id );
1759: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1760: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1761: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1762: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
1763: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

Line 1760: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );

1756:
1757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1758: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for org ' || p_code_conversion_rec.org_id );
1759: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1760: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1761: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1762: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
1763: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1764: END IF;

Line 1761: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );

1757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1758: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for org ' || p_code_conversion_rec.org_id );
1759: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1760: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1761: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1762: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
1763: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1764: END IF;
1765: IF l_org_dummy > 0 THEN

Line 1762: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);

1758: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for org ' || p_code_conversion_rec.org_id );
1759: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1760: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1761: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1762: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
1763: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1764: END IF;
1765: IF l_org_dummy > 0 THEN
1766: l_valid_flag := FND_API.g_false;

Line 1763: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

1759: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1760: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1761: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1762: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
1763: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1764: END IF;
1765: IF l_org_dummy > 0 THEN
1766: l_valid_flag := FND_API.g_false;
1767: END IF;

Line 1781: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for party ' || p_code_conversion_rec.party_id );

1777: INTO l_party_dummy;
1778: CLOSE csr_code_conv_4party;
1779:
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1781: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for party ' || p_code_conversion_rec.party_id );
1782: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1783: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1784: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1785: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

Line 1782: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );

1778: CLOSE csr_code_conv_4party;
1779:
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1781: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for party ' || p_code_conversion_rec.party_id );
1782: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1783: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1784: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1785: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1786: END IF;

Line 1783: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );

1779:
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1781: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for party ' || p_code_conversion_rec.party_id );
1782: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1783: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1784: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1785: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1786: END IF;
1787:

Line 1784: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );

1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1781: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for party ' || p_code_conversion_rec.party_id );
1782: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1783: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1784: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1785: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1786: END IF;
1787:
1788: IF l_party_dummy > 0 THEN

Line 1785: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

1781: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for party ' || p_code_conversion_rec.party_id );
1782: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1783: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1784: OZF_UTILITY_PVT.debug_message('and end date active ' || p_code_conversion_rec.end_date_active );
1785: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1786: END IF;
1787:
1788: IF l_party_dummy > 0 THEN
1789: l_valid_flag := FND_API.g_false;

Line 1793: OZF_UTILITY_PVT.debug_message('Count of code map for party ' || l_party_dummy);

1789: l_valid_flag := FND_API.g_false;
1790: END IF;
1791:
1792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1793: OZF_UTILITY_PVT.debug_message('Count of code map for party ' || l_party_dummy);
1794: END IF;
1795: END IF;
1796: ELSE
1797: l_acct_dummy := NULL;

Line 1808: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for account ' || p_code_conversion_rec.cust_account_id );

1804: FETCH csr_code_conv_4acct INTO l_acct_dummy;
1805: CLOSE csr_code_conv_4acct;
1806:
1807: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1808: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for account ' || p_code_conversion_rec.cust_account_id );
1809: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1810: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1811: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );
1812: OZF_UTILITY_PVT.debug_message('Count of code map for account ' || l_acct_dummy);

Line 1809: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );

1805: CLOSE csr_code_conv_4acct;
1806:
1807: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1808: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for account ' || p_code_conversion_rec.cust_account_id );
1809: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1810: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1811: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );
1812: OZF_UTILITY_PVT.debug_message('Count of code map for account ' || l_acct_dummy);
1813: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

Line 1810: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );

1806:
1807: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1808: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for account ' || p_code_conversion_rec.cust_account_id );
1809: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1810: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1811: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );
1812: OZF_UTILITY_PVT.debug_message('Count of code map for account ' || l_acct_dummy);
1813: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1814: END IF;

Line 1811: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );

1807: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1808: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for account ' || p_code_conversion_rec.cust_account_id );
1809: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1810: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1811: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );
1812: OZF_UTILITY_PVT.debug_message('Count of code map for account ' || l_acct_dummy);
1813: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1814: END IF;
1815: IF l_acct_dummy > 0 THEN

Line 1812: OZF_UTILITY_PVT.debug_message('Count of code map for account ' || l_acct_dummy);

1808: OZF_UTILITY_PVT.debug_message('Duplicate code map value ' || p_code_conversion_rec.external_code || ' for account ' || p_code_conversion_rec.cust_account_id );
1809: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1810: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1811: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );
1812: OZF_UTILITY_PVT.debug_message('Count of code map for account ' || l_acct_dummy);
1813: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1814: END IF;
1815: IF l_acct_dummy > 0 THEN
1816: l_valid_flag := FND_API.g_false;

Line 1813: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );

1809: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_code_conversion_rec.internal_code );
1810: OZF_UTILITY_PVT.debug_message('with start date active '|| p_code_conversion_rec.start_date_active );
1811: OZF_UTILITY_PVT.debug_message('and end date active ' ||nvl(p_code_conversion_rec.end_date_active,sysdate) );
1812: OZF_UTILITY_PVT.debug_message('Count of code map for account ' || l_acct_dummy);
1813: OZF_UTILITY_PVT.debug_message('Org ID ' || p_code_conversion_rec.org_id );
1814: END IF;
1815: IF l_acct_dummy > 0 THEN
1816: l_valid_flag := FND_API.g_false;
1817: END IF;

Line 1838: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package

1834: -- Start of Comments
1835: --
1836: -- Required Items Check procedure
1837: --
1838: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
1839: -- For create: G_CREATE, for update: G_UPDATE
1840: -- End of Comments
1841:
1842: PROCEDURE Check_Code_Conv_Req_Items

Line 1857: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

1853:
1854: x_return_status := FND_API.g_ret_sts_success;
1855:
1856: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1857: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1858: END IF;
1859:
1860: IF p_code_conversion_rec.external_code = FND_API.g_miss_char OR
1861: p_code_conversion_rec.external_code IS NULL

Line 1872: OZF_UTILITY_PVT.debug_message('external code '||p_code_conversion_rec.external_code);

1868: RETURN;
1869: END IF;
1870:
1871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1872: OZF_UTILITY_PVT.debug_message('external code '||p_code_conversion_rec.external_code);
1873: OZF_UTILITY_PVT.debug_message('end of check_code_conv_req_items');
1874: END IF;
1875:
1876: END check_code_conv_req_items;

Line 1873: OZF_UTILITY_PVT.debug_message('end of check_code_conv_req_items');

1869: END IF;
1870:
1871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1872: OZF_UTILITY_PVT.debug_message('external code '||p_code_conversion_rec.external_code);
1873: OZF_UTILITY_PVT.debug_message('end of check_code_conv_req_items');
1874: END IF;
1875:
1876: END check_code_conv_req_items;
1877:

Line 1899: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

1895:
1896: x_return_status := FND_API.g_ret_sts_success;
1897:
1898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1899: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1900: END IF;
1901:
1902: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1903:

Line 1958: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

1954:
1955: x_return_status := FND_API.g_ret_sts_success;
1956:
1957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1958: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1959: END IF;
1960:
1961: check_code_conv_req_items( p_code_conversion_rec,
1962: p_validation_mode,

Line 1970: OZF_UTILITY_PVT.debug_message('after check_code_conv_req_items ' );

1966: RETURN;
1967: END IF;
1968:
1969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1970: OZF_UTILITY_PVT.debug_message('after check_code_conv_req_items ' );
1971: END IF;
1972:
1973:
1974: check_uniq_code_conversion( p_code_conversion_rec,

Line 1983: OZF_UTILITY_PVT.debug_message('after check_uniq_code_conversion ' );

1979: RETURN;
1980: END IF;
1981:
1982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1983: OZF_UTILITY_PVT.debug_message('after check_uniq_code_conversion ' );
1984: END IF;
1985:
1986: check_code_conversion_dt (p_code_conversion_rec,
1987: p_validation_mode,

Line 1995: OZF_UTILITY_PVT.debug_message('after check_code_conversion_dt ' );

1991: RETURN;
1992: END IF;
1993:
1994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1995: OZF_UTILITY_PVT.debug_message('after check_code_conversion_dt ' );
1996: END IF;
1997:
1998: END check_code_conversion_items;
1999: -- Start of Comments

Line 2003: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package

1999: -- Start of Comments
2000: --
2001: -- validation procedures
2002: --
2003: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
2004: -- For create: G_CREATE, for update: G_UPDATE
2005: -- End of Comments
2006:
2007: PROCEDURE Validate_Code_Conversion(

Line 2046: OZF_UTILITY_PVT.debug_message('in '||l_api_name );

2042: FND_MSG_PUB.initialize;
2043: END IF;
2044: -- Call the Validate Item procedure for the item(field level validations )
2045: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2046: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2047: END IF;
2048: x_return_status := FND_API.g_ret_sts_success;
2049:
2050: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 2055: OZF_UTILITY_PVT.debug_message('inside the loop p_code_conversion_tbl ' );

2051:
2052: FOR i in 1 .. p_code_conversion_tbl.count
2053: LOOP
2054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2055: OZF_UTILITY_PVT.debug_message('inside the loop p_code_conversion_tbl ' );
2056: END IF;
2057: l_code_conversion_rec := p_code_conversion_tbl(i);
2058:
2059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 2060: OZF_UTILITY_PVT.debug_message('External code ' || l_code_conversion_rec.external_code );

2056: END IF;
2057: l_code_conversion_rec := p_code_conversion_tbl(i);
2058:
2059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2060: OZF_UTILITY_PVT.debug_message('External code ' || l_code_conversion_rec.external_code );
2061: OZF_UTILITY_PVT.debug_message('Start date active '|| l_code_conversion_rec.start_date_active );
2062: OZF_UTILITY_PVT.debug_message('End date active ' || l_code_conversion_rec.end_date_active );
2063: END IF;
2064:

Line 2061: OZF_UTILITY_PVT.debug_message('Start date active '|| l_code_conversion_rec.start_date_active );

2057: l_code_conversion_rec := p_code_conversion_tbl(i);
2058:
2059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2060: OZF_UTILITY_PVT.debug_message('External code ' || l_code_conversion_rec.external_code );
2061: OZF_UTILITY_PVT.debug_message('Start date active '|| l_code_conversion_rec.start_date_active );
2062: OZF_UTILITY_PVT.debug_message('End date active ' || l_code_conversion_rec.end_date_active );
2063: END IF;
2064:
2065: check_code_conversion_items(

Line 2062: OZF_UTILITY_PVT.debug_message('End date active ' || l_code_conversion_rec.end_date_active );

2058:
2059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2060: OZF_UTILITY_PVT.debug_message('External code ' || l_code_conversion_rec.external_code );
2061: OZF_UTILITY_PVT.debug_message('Start date active '|| l_code_conversion_rec.start_date_active );
2062: OZF_UTILITY_PVT.debug_message('End date active ' || l_code_conversion_rec.end_date_active );
2063: END IF;
2064:
2065: check_code_conversion_items(
2066: p_code_conversion_rec => l_code_conversion_rec,

Line 2087: WHEN OZF_Utility_PVT.resource_locked THEN

2083: (p_count => x_msg_count,
2084: p_data => x_msg_data
2085: );
2086: EXCEPTION
2087: WHEN OZF_Utility_PVT.resource_locked THEN
2088: x_return_status := FND_API.g_ret_sts_error;
2089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2090: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
2091: FND_MSG_PUB.add;

Line 2233: OZF_UTILITY_PVT.debug_message(' Internal Code ' || l_internal_code);

2229: CLOSE csr_get_internal_code_party;
2230: END IF;
2231:
2232: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2233: OZF_UTILITY_PVT.debug_message(' Internal Code ' || l_internal_code);
2234: END IF;
2235: x_internal_code := l_internal_code;
2236:
2237: EXCEPTION

Line 2310: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

2306: /* For the code conversions at a supplier site , only one valid internal code
2307: should exist for a particular external code on a particular date.*/
2308: x_return_status := FND_API.g_ret_sts_success;
2309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2310: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2311: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_dummy);
2312: END IF;
2313:
2314: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 2311: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_dummy);

2307: should exist for a particular external code on a particular date.*/
2308: x_return_status := FND_API.g_ret_sts_success;
2309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2310: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2311: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_dummy);
2312: END IF;
2313:
2314: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2315:

Line 2337: 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 );

2333: INTO l_dummy;
2334: CLOSE csr_code_conv;
2335:
2336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2337: 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 );
2338: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_supp_code_conversion_rec.internal_code );
2339: OZF_UTILITY_PVT.debug_message('with start date active '|| p_supp_code_conversion_rec.start_date_active );
2340: OZF_UTILITY_PVT.debug_message('and end date active ' || p_supp_code_conversion_rec.end_date_active );
2341: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);

Line 2338: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_supp_code_conversion_rec.internal_code );

2334: CLOSE csr_code_conv;
2335:
2336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2337: 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 );
2338: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_supp_code_conversion_rec.internal_code );
2339: OZF_UTILITY_PVT.debug_message('with start date active '|| p_supp_code_conversion_rec.start_date_active );
2340: OZF_UTILITY_PVT.debug_message('and end date active ' || p_supp_code_conversion_rec.end_date_active );
2341: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
2342: END IF;

Line 2339: OZF_UTILITY_PVT.debug_message('with start date active '|| p_supp_code_conversion_rec.start_date_active );

2335:
2336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2337: 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 );
2338: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_supp_code_conversion_rec.internal_code );
2339: OZF_UTILITY_PVT.debug_message('with start date active '|| p_supp_code_conversion_rec.start_date_active );
2340: OZF_UTILITY_PVT.debug_message('and end date active ' || p_supp_code_conversion_rec.end_date_active );
2341: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
2342: END IF;
2343: IF l_dummy > 0 THEN

Line 2340: OZF_UTILITY_PVT.debug_message('and end date active ' || p_supp_code_conversion_rec.end_date_active );

2336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2337: 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 );
2338: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_supp_code_conversion_rec.internal_code );
2339: OZF_UTILITY_PVT.debug_message('with start date active '|| p_supp_code_conversion_rec.start_date_active );
2340: OZF_UTILITY_PVT.debug_message('and end date active ' || p_supp_code_conversion_rec.end_date_active );
2341: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
2342: END IF;
2343: IF l_dummy > 0 THEN
2344: l_valid_flag := FND_API.g_false;

Line 2341: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);

2337: 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 );
2338: OZF_UTILITY_PVT.debug_message('and internal code ' ||p_supp_code_conversion_rec.internal_code );
2339: OZF_UTILITY_PVT.debug_message('with start date active '|| p_supp_code_conversion_rec.start_date_active );
2340: OZF_UTILITY_PVT.debug_message('and end date active ' || p_supp_code_conversion_rec.end_date_active );
2341: OZF_UTILITY_PVT.debug_message('External Code ' || l_external_code);
2342: END IF;
2343: IF l_dummy > 0 THEN
2344: l_valid_flag := FND_API.g_false;
2345:

Line 2367: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package

2363: -- Start of Comments
2364: --
2365: -- Required Items Check procedure
2366: --
2367: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
2368: -- For create: G_CREATE, for update: G_UPDATE
2369: -- End of Comments
2370:
2371: PROCEDURE Check_supp_code_Conv_Req_Items

Line 2386: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

2382:
2383: x_return_status := FND_API.g_ret_sts_success;
2384:
2385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2386: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2387: END IF;
2388:
2389: IF p_supp_code_conversion_rec.external_code = FND_API.g_miss_char OR
2390: p_supp_code_conversion_rec.external_code IS NULL

Line 2401: OZF_UTILITY_PVT.debug_message('external code '||p_supp_code_conversion_rec.external_code);

2397: RETURN;
2398: END IF;
2399:
2400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2401: OZF_UTILITY_PVT.debug_message('external code '||p_supp_code_conversion_rec.external_code);
2402: OZF_UTILITY_PVT.debug_message('end of check_supp_code_conv_req_items');
2403: END IF;
2404:
2405: END check_supp_code_conv_req_items;

Line 2402: OZF_UTILITY_PVT.debug_message('end of check_supp_code_conv_req_items');

2398: END IF;
2399:
2400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2401: OZF_UTILITY_PVT.debug_message('external code '||p_supp_code_conversion_rec.external_code);
2402: OZF_UTILITY_PVT.debug_message('end of check_supp_code_conv_req_items');
2403: END IF;
2404:
2405: END check_supp_code_conv_req_items;
2406:

Line 2428: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

2424:
2425: x_return_status := FND_API.g_ret_sts_success;
2426:
2427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2428: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2429: END IF;
2430:
2431: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2432:

Line 2476: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package

2472: -- Start of Comments
2473: --
2474: -- validation procedures
2475: --
2476: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
2477: -- For create: G_CREATE, for update: G_UPDATE
2478: -- End of Comments
2479:
2480:

Line 2576: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

2572:
2573: x_return_status := FND_API.g_ret_sts_success;
2574:
2575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2576: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2577: END IF;
2578:
2579: check_supp_code_conv_req_items( p_supp_code_conversion_rec,
2580: p_validation_mode,

Line 2588: OZF_UTILITY_PVT.debug_message('after check_supp_code_conv_req_items ' );

2584: RETURN;
2585: END IF;
2586:
2587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2588: OZF_UTILITY_PVT.debug_message('after check_supp_code_conv_req_items ' );
2589: END IF;
2590:
2591:
2592: check_uniq_supp_code_conv( p_supp_code_conversion_rec,

Line 2601: OZF_UTILITY_PVT.debug_message('after check_uniq_supp_code_conversion ' );

2597: RETURN;
2598: END IF;
2599:
2600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2601: OZF_UTILITY_PVT.debug_message('after check_uniq_supp_code_conversion ' );
2602: END IF;
2603:
2604: check_supp_code_conversion_dt (p_supp_code_conversion_rec,
2605: p_validation_mode,

Line 2613: OZF_UTILITY_PVT.debug_message('after check_supp_code_conversion_dt ' );

2609: RETURN;
2610: END IF;
2611:
2612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2613: OZF_UTILITY_PVT.debug_message('after check_supp_code_conversion_dt ' );
2614: END IF;
2615:
2616: END check_supp_code_conv_items;
2617: PROCEDURE Validate_supp_code_Conv(

Line 2656: OZF_UTILITY_PVT.debug_message('in '||l_api_name );

2652: FND_MSG_PUB.initialize;
2653: END IF;
2654: -- Call the Validate Item procedure for the item(field level validations )
2655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2656: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2657: END IF;
2658: x_return_status := FND_API.g_ret_sts_success;
2659:
2660: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 2665: OZF_UTILITY_PVT.debug_message('inside the loop p_supp_code_conversion_tbl ' );

2661:
2662: FOR i in 1 .. p_supp_code_conversion_tbl.count
2663: LOOP
2664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2665: OZF_UTILITY_PVT.debug_message('inside the loop p_supp_code_conversion_tbl ' );
2666: END IF;
2667: l_supp_code_conversion_rec := p_supp_code_conversion_tbl(i);
2668:
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 2670: OZF_UTILITY_PVT.debug_message('External code ' || l_supp_code_conversion_rec.external_code );

2666: END IF;
2667: l_supp_code_conversion_rec := p_supp_code_conversion_tbl(i);
2668:
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2670: OZF_UTILITY_PVT.debug_message('External code ' || l_supp_code_conversion_rec.external_code );
2671: OZF_UTILITY_PVT.debug_message('Start date active '|| l_supp_code_conversion_rec.start_date_active );
2672: OZF_UTILITY_PVT.debug_message('End date active ' || l_supp_code_conversion_rec.end_date_active );
2673: END IF;
2674:

Line 2671: OZF_UTILITY_PVT.debug_message('Start date active '|| l_supp_code_conversion_rec.start_date_active );

2667: l_supp_code_conversion_rec := p_supp_code_conversion_tbl(i);
2668:
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2670: OZF_UTILITY_PVT.debug_message('External code ' || l_supp_code_conversion_rec.external_code );
2671: OZF_UTILITY_PVT.debug_message('Start date active '|| l_supp_code_conversion_rec.start_date_active );
2672: OZF_UTILITY_PVT.debug_message('End date active ' || l_supp_code_conversion_rec.end_date_active );
2673: END IF;
2674:
2675: check_supp_code_conv_items(

Line 2672: OZF_UTILITY_PVT.debug_message('End date active ' || l_supp_code_conversion_rec.end_date_active );

2668:
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2670: OZF_UTILITY_PVT.debug_message('External code ' || l_supp_code_conversion_rec.external_code );
2671: OZF_UTILITY_PVT.debug_message('Start date active '|| l_supp_code_conversion_rec.start_date_active );
2672: OZF_UTILITY_PVT.debug_message('End date active ' || l_supp_code_conversion_rec.end_date_active );
2673: END IF;
2674:
2675: check_supp_code_conv_items(
2676: p_supp_code_conversion_rec => l_supp_code_conversion_rec,

Line 2696: WHEN OZF_Utility_PVT.resource_locked THEN

2692: (p_count => x_msg_count,
2693: p_data => x_msg_data
2694: );
2695: EXCEPTION
2696: WHEN OZF_Utility_PVT.resource_locked THEN
2697: x_return_status := FND_API.g_ret_sts_error;
2698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2699: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
2700: FND_MSG_PUB.add;

Line 2794: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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: ' || l_api_name || 'start');
2795: END IF;
2796:
2797: -- Initialize API return status to SUCCESS
2798: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2801: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_supp_code_conversion_tbl.count);

2797: -- Initialize API return status to SUCCESS
2798: x_return_status := FND_API.G_RET_STS_SUCCESS;
2799:
2800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2801: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_supp_code_conversion_tbl.count);
2802: END IF;
2803:
2804: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2805: -- Debug message

Line 2806: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);

2802: END IF;
2803:
2804: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2805: -- Debug message
2806: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
2807: -- Invoke validation procedures
2808: Validate_supp_code_Conv(
2809: p_api_version_number => 1.0,
2810: p_init_msg_list => FND_API.G_FALSE,

Line 2825: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

2821: END IF;
2822:
2823: -- Debug Message
2824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2825: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
2826: END IF;
2827:
2828: l_code_conversion_id := NULL;
2829: l_object_version_number := NULL;

Line 2834: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_supp_code_conversion_tbl.count);

2830:
2831: x_supp_code_conversion_id_tbl := JTF_NUMBER_TABLE();
2832:
2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2834: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_supp_code_conversion_tbl.count);
2835: END IF;
2836:
2837: FOR i IN 1 .. p_supp_code_conversion_tbl.count
2838: LOOP

Line 2850: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);

2846: END IF;
2847: SELECT ozf_supp_code_conv_all_s.nextval INTO l_code_conversion_id FROM DUAL;
2848:
2849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2850: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
2851: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);
2852: END IF;
2853:
2854: BEGIN

Line 2851: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);

2847: SELECT ozf_supp_code_conv_all_s.nextval INTO l_code_conversion_id FROM DUAL;
2848:
2849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2850: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
2851: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);
2852: END IF;
2853:
2854: BEGIN
2855:

Line 2892: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating supp_code conversion map');

2888: p_attribute15 => l_supp_code_conversion_rec.attribute15);
2889:
2890: EXCEPTION
2891: WHEN OTHERS THEN
2892: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating supp_code conversion map');
2893: RAISE FND_API.G_EXC_ERROR;
2894: END;
2895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2896: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - supp_code conversion id' || l_code_conversion_id);

Line 2896: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - supp_code conversion id' || l_code_conversion_id);

2892: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating supp_code conversion map');
2893: RAISE FND_API.G_EXC_ERROR;
2894: END;
2895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2896: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - supp_code conversion id' || l_code_conversion_id);
2897: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_supp_code_conversion_rec.Object_Version_Number);
2898: END IF;
2899:
2900: x_supp_code_conversion_id_tbl.extend;

Line 2897: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_supp_code_conversion_rec.Object_Version_Number);

2893: RAISE FND_API.G_EXC_ERROR;
2894: END;
2895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2896: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - supp_code conversion id' || l_code_conversion_id);
2897: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_supp_code_conversion_rec.Object_Version_Number);
2898: END IF;
2899:
2900: x_supp_code_conversion_id_tbl.extend;
2901: x_supp_code_conversion_id_tbl(x_supp_code_conversion_id_tbl.count) := l_code_conversion_id;

Line 2913: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

2909: END IF;
2910:
2911: -- Debug Message
2912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2913: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2914: END IF;
2915:
2916: -- Standard call to get message count and if count is 1, get message info.
2917: FND_MSG_PUB.Count_And_Get

Line 2925: WHEN OZF_UTILITY_PVT.resource_locked THEN

2921:
2922:
2923:
2924: EXCEPTION
2925: WHEN OZF_UTILITY_PVT.resource_locked THEN
2926: x_return_status := FND_API.g_ret_sts_error;
2927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2928: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
2929: FND_MSG_PUB.add;

Line 3066: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3062: END IF;
3063:
3064: -- Debug Message
3065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3066: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3067: END IF;
3068:
3069: -- Initialize API return status to SUCCESS
3070: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3074: OZF_UTILITY_PVT.debug_message('p_supp_code_conversion_tbl(1).description: ' || p_supp_code_conversion_tbl(1).description );

3070: x_return_status := FND_API.G_RET_STS_SUCCESS;
3071: x_object_version_number := JTF_NUMBER_TABLE();
3072:
3073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3074: OZF_UTILITY_PVT.debug_message('p_supp_code_conversion_tbl(1).description: ' || p_supp_code_conversion_tbl(1).description );
3075: END IF;
3076:
3077: FOR i in 1 .. p_supp_code_conversion_tbl.count
3078: LOOP

Line 3083: OZF_UTILITY_PVT.debug_message( 'supp_code Conversion ID' || l_code_conversion_id);

3079: p_supp_code_conversion_rec := p_supp_code_conversion_tbl(i);
3080: l_code_conversion_id := p_supp_code_conversion_rec.code_conversion_id;
3081:
3082: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3083: OZF_UTILITY_PVT.debug_message( 'supp_code Conversion ID' || l_code_conversion_id);
3084: END IF;
3085:
3086: -- Check for the existance of the record
3087: OPEN csr_supp_code_conversion(l_code_conversion_id);

Line 3123: OZF_UTILITY_PVT.debug_message('Existing description '|| l_supp_code_conversion_rec.description);

3119: ,l_supp_code_conversion_rec.attribute15
3120: ,l_supp_code_conversion_rec.security_group_id;
3121:
3122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3123: OZF_UTILITY_PVT.debug_message('Existing description '|| l_supp_code_conversion_rec.description);
3124: END IF;
3125:
3126: IF ( csr_supp_code_conversion%NOTFOUND) THEN
3127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 3128: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');

3124: END IF;
3125:
3126: IF ( csr_supp_code_conversion%NOTFOUND) THEN
3127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3128: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
3129: END IF;
3130:
3131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3132: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

Line 3141: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_supp_code_conversion_rec.object_version_number);

3137: CLOSE csr_supp_code_conversion;
3138:
3139:
3140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3141: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_supp_code_conversion_rec.object_version_number);
3142: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_supp_code_conversion_rec.object_version_number);
3143: END IF;
3144:
3145: --- Check the Version Number for Locking

Line 3142: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_supp_code_conversion_rec.object_version_number);

3138:
3139:
3140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3141: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_supp_code_conversion_rec.object_version_number);
3142: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_supp_code_conversion_rec.object_version_number);
3143: END IF;
3144:
3145: --- Check the Version Number for Locking
3146: IF l_supp_code_conversion_rec.object_version_number <> P_supp_code_conversion_rec.Object_Version_number

Line 3149: OZF_UTILITY_PVT.debug_message( 'dbver' || l_supp_code_conversion_rec.object_version_number);

3145: --- Check the Version Number for Locking
3146: IF l_supp_code_conversion_rec.object_version_number <> P_supp_code_conversion_rec.Object_Version_number
3147: THEN
3148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3149: OZF_UTILITY_PVT.debug_message( 'dbver' || l_supp_code_conversion_rec.object_version_number);
3150: OZF_UTILITY_PVT.debug_message( 'reqver' || P_supp_code_conversion_rec.object_version_number);
3151: END IF;
3152:
3153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 3150: OZF_UTILITY_PVT.debug_message( 'reqver' || P_supp_code_conversion_rec.object_version_number);

3146: IF l_supp_code_conversion_rec.object_version_number <> P_supp_code_conversion_rec.Object_Version_number
3147: THEN
3148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3149: OZF_UTILITY_PVT.debug_message( 'dbver' || l_supp_code_conversion_rec.object_version_number);
3150: OZF_UTILITY_PVT.debug_message( 'reqver' || P_supp_code_conversion_rec.object_version_number);
3151: END IF;
3152:
3153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3154: THEN

Line 3175: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_supp_code_conversion_rec.End_Date_Active);

3171: RAISE FND_API.G_EXC_ERROR;
3172: END IF;
3173:
3174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3175: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_supp_code_conversion_rec.End_Date_Active);
3176: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_supp_code_conversion_rec.End_Date_Active);
3177: END IF;
3178:
3179: -- Update End date only when it is NUll or a future date

Line 3176: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_supp_code_conversion_rec.End_Date_Active);

3172: END IF;
3173:
3174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3175: OZF_UTILITY_PVT.debug_message( 'Existing End Date' || l_supp_code_conversion_rec.End_Date_Active);
3176: OZF_UTILITY_PVT.debug_message( 'Updated End Date' || p_supp_code_conversion_rec.End_Date_Active);
3177: END IF;
3178:
3179: -- Update End date only when it is NUll or a future date
3180: IF trunc(nvl(l_supp_code_conversion_Rec.End_Date_Active,sysdate+1)) <= TRUNC(SYSDATE)

Line 3193: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_supp_code_conversion_rec.Start_Date_Active);

3189: RAISE FND_API.G_EXC_ERROR;
3190: END IF;
3191:
3192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3193: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_supp_code_conversion_rec.Start_Date_Active);
3194: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_supp_code_conversion_rec.Start_Date_Active);
3195: END IF;
3196:
3197: ---Update not allowed for Start Date when start date is earlier than current date

Line 3194: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_supp_code_conversion_rec.Start_Date_Active);

3190: END IF;
3191:
3192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3193: OZF_UTILITY_PVT.debug_message( 'Existing Start Date' || l_supp_code_conversion_rec.Start_Date_Active);
3194: OZF_UTILITY_PVT.debug_message( 'Updated Start Date' || p_supp_code_conversion_rec.Start_Date_Active);
3195: END IF;
3196:
3197: ---Update not allowed for Start Date when start date is earlier than current date
3198: IF trunc(l_supp_code_conversion_Rec.Start_Date_Active)

Line 3214: OZF_UTILITY_PVT.debug_message ('Cannot update an end dated code conversion map');

3210:
3211: IF l_supp_code_conversion_Rec.end_date_active < p_supp_code_conversion_Rec.Start_Date_Active THEN
3212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3213: THEN
3214: OZF_UTILITY_PVT.debug_message ('Cannot update an end dated code conversion map');
3215: END IF;
3216: raise FND_API.G_EXC_ERROR;
3217: END IF;
3218:

Line 3235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);

3231:
3232: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
3233: -- Debug message
3234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
3236: END IF;
3237: -- Invoke validation procedures
3238: Validate_supp_code_Conv(
3239: p_api_version_number => 1.0,

Line 3263: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');

3259:
3260: -- Call Update Table Handler
3261: -- Debug Message
3262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3263: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');
3264: END IF;
3265: BEGIN
3266: OZF_CODE_CONVERSION_PKG.Update_Supp_Code_Conv_Row(
3267: p_code_conversion_id => l_code_conversion_id,

Line 3301: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in updating code conversion map');

3297:
3298:
3299: EXCEPTION
3300: WHEN OTHERS THEN
3301: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in updating code conversion map');
3302: RAISE FND_API.G_EXC_ERROR;
3303: END;
3304:
3305: x_object_version_number.EXTEND;

Line 3320: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

3316:
3317:
3318: -- Debug Message
3319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3320: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3321: END IF;
3322: -- Standard call to get message count and if count is 1, get message info.
3323: FND_MSG_PUB.Count_And_Get
3324: (p_count => x_msg_count,

Line 3397: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');

3393: -- Standard Start of API savepoint
3394: SAVEPOINT update_supp_code_conv_tbl_pvt;
3395:
3396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3397: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3398: END IF;
3399:
3400: -- Standard call to check for call compatibility.
3401: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3430: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3426: END IF;
3427:
3428: -- Debug Message
3429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3430: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3431: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_supp_code_conversion_Tbl.count);
3432: END IF;
3433: -- Initialize API return status to SUCCESS
3434: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3431: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_supp_code_conversion_Tbl.count);

3427:
3428: -- Debug Message
3429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3430: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3431: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_supp_code_conversion_Tbl.count);
3432: END IF;
3433: -- Initialize API return status to SUCCESS
3434: x_return_status := FND_API.G_RET_STS_SUCCESS;
3435:

Line 3467: OZF_UTILITY_PVT.debug_message('End Date '||P_supp_code_conversion_Rec.end_date_active);

3463: l_update_supp_code_conv_tbl(l_up_cnt) := P_supp_code_conversion_Rec;
3464: END IF;
3465:
3466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3467: OZF_UTILITY_PVT.debug_message('End Date '||P_supp_code_conversion_Rec.end_date_active);
3468: END IF;
3469:
3470: END LOOP;
3471:

Line 3473: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);

3469:
3470: END LOOP;
3471:
3472: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3473: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);
3474: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);
3475: END IF;
3476:
3477: IF l_cc_cnt > 0 THEN

Line 3474: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);

3470: END LOOP;
3471:
3472: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3473: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);
3474: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);
3475: END IF;
3476:
3477: IF l_cc_cnt > 0 THEN
3478: --- Call to Create Procedure

Line 3524: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

3520: END IF;
3521:
3522: -- Debug Message
3523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3524: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3525: END IF;
3526: -- Standard call to get message count and if count is 1, get message info.
3527: FND_MSG_PUB.Count_And_Get
3528: (p_count => x_msg_count,

Line 3594: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');

3590: -- Standard Start of API savepoint
3591: SAVEPOINT delete_supp_code_conv_tbl_pvt;
3592:
3593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3594: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
3595: END IF;
3596:
3597: -- Standard call to check for call compatibility.
3598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3627: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3623: END IF;
3624:
3625: -- Debug Message
3626: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3627: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3628: END IF;
3629:
3630:
3631: -- Initialize API return status to SUCCESS

Line 3641: OZF_UTILITY_PVT.debug_message('supp_code Conversion ID ' || l_code_conversion_id);

3637: l_code_conversion_id := P_supp_code_conversion_Tbl(i).code_conversion_id;
3638: l_object_version_number := P_supp_code_conversion_Tbl(i).object_version_number;
3639:
3640: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3641: OZF_UTILITY_PVT.debug_message('supp_code Conversion ID ' || l_code_conversion_id);
3642: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);
3643: END IF;
3644:
3645: IF l_object_version_number IS NULL

Line 3642: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);

3638: l_object_version_number := P_supp_code_conversion_Tbl(i).object_version_number;
3639:
3640: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3641: OZF_UTILITY_PVT.debug_message('supp_code Conversion ID ' || l_code_conversion_id);
3642: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_number);
3643: END IF;
3644:
3645: IF l_object_version_number IS NULL
3646: OR l_code_conversion_id IS NULL THEN

Line 3649: OZF_UTILITY_PVT.debug_message('In If block');

3645: IF l_object_version_number IS NULL
3646: OR l_code_conversion_id IS NULL THEN
3647:
3648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3649: OZF_UTILITY_PVT.debug_message('In If block');
3650: END IF;
3651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3652: FND_MESSAGE.set_name('OZF', 'OZF_REQ_PARAMETERS_MISSING');
3653: FND_MSG_PUB.add;

Line 3687: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

3683: END IF;
3684:
3685: -- Debug Message
3686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3687: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3688: END IF;
3689: -- Standard call to get message count and if count is 1, get message info.
3690: FND_MSG_PUB.Count_And_Get
3691: (p_count => x_msg_count,

Line 3773: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

3769: END IF;
3770:
3771: -- Debug Message
3772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3773: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3774: END IF;
3775:
3776:
3777: -- Initialize API return status to SUCCESS

Line 3787: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

3783: -- Api body
3784: --
3785: -- Debug Message
3786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3787: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
3788: END IF;
3789:
3790: BEGIN
3791: OZF_CODE_CONVERSION_PKG.Delete_Supp_Code_Conv_Row( p_code_conversion_id => p_code_conversion_id,

Line 3806: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

3802: END IF;
3803:
3804: -- Debug Message
3805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
3806: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3807: END IF;
3808:
3809: -- Standard call to get message count and if count is 1, get message info.
3810: FND_MSG_PUB.Count_And_Get