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.PV_ENTY_ATTR_VALUE_PUB dependencies on PVX_UTILITY_PVT

Line 135: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');

131: END IF;
132:
133: -- Debug Message
134: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
135: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');
136: END IF;
137:
138: -- Initialize API return status to SUCCESS
139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 141: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

137:
138: -- Initialize API return status to SUCCESS
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
141: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
142: END IF;
143:
144:
145: --check for required items like attribute_id, entity, entity_id,versioin

Line 188: PVX_Utility_PVT.debug_message('Attribute ID:' || p_attribute_id);

184: l_character_width := x.character_width;
185: end loop;
186:
187: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
188: PVX_Utility_PVT.debug_message('Attribute ID:' || p_attribute_id);
189: PVX_Utility_PVT.debug_message('Attribute Type:' || l_attribute_type);
190: PVX_Utility_PVT.debug_message('Display style:' || l_display_style);
191: PVX_Utility_PVT.debug_message('Attribute Name:' || l_attribute_name);
192: PVX_Utility_PVT.debug_message('Attribute character width:' || l_character_width);

Line 189: PVX_Utility_PVT.debug_message('Attribute Type:' || l_attribute_type);

185: end loop;
186:
187: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
188: PVX_Utility_PVT.debug_message('Attribute ID:' || p_attribute_id);
189: PVX_Utility_PVT.debug_message('Attribute Type:' || l_attribute_type);
190: PVX_Utility_PVT.debug_message('Display style:' || l_display_style);
191: PVX_Utility_PVT.debug_message('Attribute Name:' || l_attribute_name);
192: PVX_Utility_PVT.debug_message('Attribute character width:' || l_character_width);
193:

Line 190: PVX_Utility_PVT.debug_message('Display style:' || l_display_style);

186:
187: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
188: PVX_Utility_PVT.debug_message('Attribute ID:' || p_attribute_id);
189: PVX_Utility_PVT.debug_message('Attribute Type:' || l_attribute_type);
190: PVX_Utility_PVT.debug_message('Display style:' || l_display_style);
191: PVX_Utility_PVT.debug_message('Attribute Name:' || l_attribute_name);
192: PVX_Utility_PVT.debug_message('Attribute character width:' || l_character_width);
193:
194: END IF;

Line 191: PVX_Utility_PVT.debug_message('Attribute Name:' || l_attribute_name);

187: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
188: PVX_Utility_PVT.debug_message('Attribute ID:' || p_attribute_id);
189: PVX_Utility_PVT.debug_message('Attribute Type:' || l_attribute_type);
190: PVX_Utility_PVT.debug_message('Display style:' || l_display_style);
191: PVX_Utility_PVT.debug_message('Attribute Name:' || l_attribute_name);
192: PVX_Utility_PVT.debug_message('Attribute character width:' || l_character_width);
193:
194: END IF;
195:

Line 192: PVX_Utility_PVT.debug_message('Attribute character width:' || l_character_width);

188: PVX_Utility_PVT.debug_message('Attribute ID:' || p_attribute_id);
189: PVX_Utility_PVT.debug_message('Attribute Type:' || l_attribute_type);
190: PVX_Utility_PVT.debug_message('Display style:' || l_display_style);
191: PVX_Utility_PVT.debug_message('Attribute Name:' || l_attribute_name);
192: PVX_Utility_PVT.debug_message('Attribute character width:' || l_character_width);
193:
194: END IF;
195:
196: --getting attribute entity details

Line 208: PVX_Utility_PVT.debug_message('entity:' || p_entity);

204: l_lov_string := x.lov_string;
205: end loop;
206:
207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
208: PVX_Utility_PVT.debug_message('entity:' || p_entity);
209: PVX_Utility_PVT.debug_message('external update text:' || l_external_update_text);
210: PVX_Utility_PVT.debug_message('attr data type:' || l_attr_data_type);
211: PVX_Utility_PVT.debug_message('validation flag:' || l_require_validation_flag);
212: PVX_Utility_PVT.debug_message('Lov String:' || l_lov_string);

Line 209: PVX_Utility_PVT.debug_message('external update text:' || l_external_update_text);

205: end loop;
206:
207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
208: PVX_Utility_PVT.debug_message('entity:' || p_entity);
209: PVX_Utility_PVT.debug_message('external update text:' || l_external_update_text);
210: PVX_Utility_PVT.debug_message('attr data type:' || l_attr_data_type);
211: PVX_Utility_PVT.debug_message('validation flag:' || l_require_validation_flag);
212: PVX_Utility_PVT.debug_message('Lov String:' || l_lov_string);
213:

Line 210: PVX_Utility_PVT.debug_message('attr data type:' || l_attr_data_type);

206:
207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
208: PVX_Utility_PVT.debug_message('entity:' || p_entity);
209: PVX_Utility_PVT.debug_message('external update text:' || l_external_update_text);
210: PVX_Utility_PVT.debug_message('attr data type:' || l_attr_data_type);
211: PVX_Utility_PVT.debug_message('validation flag:' || l_require_validation_flag);
212: PVX_Utility_PVT.debug_message('Lov String:' || l_lov_string);
213:
214: END IF;

Line 211: PVX_Utility_PVT.debug_message('validation flag:' || l_require_validation_flag);

207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
208: PVX_Utility_PVT.debug_message('entity:' || p_entity);
209: PVX_Utility_PVT.debug_message('external update text:' || l_external_update_text);
210: PVX_Utility_PVT.debug_message('attr data type:' || l_attr_data_type);
211: PVX_Utility_PVT.debug_message('validation flag:' || l_require_validation_flag);
212: PVX_Utility_PVT.debug_message('Lov String:' || l_lov_string);
213:
214: END IF;
215:

Line 212: PVX_Utility_PVT.debug_message('Lov String:' || l_lov_string);

208: PVX_Utility_PVT.debug_message('entity:' || p_entity);
209: PVX_Utility_PVT.debug_message('external update text:' || l_external_update_text);
210: PVX_Utility_PVT.debug_message('attr data type:' || l_attr_data_type);
211: PVX_Utility_PVT.debug_message('validation flag:' || l_require_validation_flag);
212: PVX_Utility_PVT.debug_message('Lov String:' || l_lov_string);
213:
214: END IF;
215:
216: --if entity is LEAD (Opportunity), We are not dealing with all versioning and all.

Line 222: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - entity is opportunity');

218:
219: if(p_entity='LEAD') then
220:
221: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
222: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - entity is opportunity');
223: END IF;
224:
225: for x in c_get_enty_attr_value( cv_attribute_id => p_attribute_id,
226: cv_entity_id => p_entity_id,

Line 265: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -deleting act');

261: THEN
262:
263: if(l_lead_record_exists = 'Y') then
264: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
265: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -deleting act');
266: END IF;
267:
268: for x in c_get_enty_attr_value( cv_attribute_id => p_attribute_id,
269: cv_entity_id => p_entity_id,

Line 300: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -update act');

296: ELSE --else of IF (l_attr_val_tbl IS NULL OR
297:
298: if(l_lead_record_exists = 'Y') then
299: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
300: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -update act');
301: END IF;
302: --if you find any rows, firsdt delete and add the new ones
303: for x in c_get_enty_attr_value( cv_attribute_id => p_attribute_id,
304: cv_entity_id => p_entity_id,

Line 370: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -creat act');

366:
367:
368: else
369: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
370: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -creat act');
371: END IF;
372:
373: FOR l_curr_row IN l_attr_val_tbl.first..l_attr_val_tbl.last LOOP
374:

Line 392: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -creat act');

388: l_lead_enty_attr_val_rec.entity_id := p_entity_id;
389:
390:
391: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
392: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' -creat act');
393: END IF;
394:
395:
396:

Line 434: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - attr_data_type is :'|| l_attr_data_type);

430: IF(l_attr_data_type in ('EXTERNAL','EXT_INT') AND
431: l_external_update_text is not null
432: ) THEN
433: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
434: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - attr_data_type is :'|| l_attr_data_type);
435: END IF;
436:
437: --if update text is not null , then call update API for each attribute
438: --IF (l_external_update_text is not null) THEN

Line 496: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - attr_data_type is :'|| l_attr_data_type);

492:
493:
494:
495: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
496: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - attr_data_type is :'|| l_attr_data_type);
497: END IF;
498: --check for version number
499: --Here we are treating version as object_version_number. So we check this version with previous versions
500:

Line 519: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - l_version :' || l_version);

515: l_version := 0;
516: END IF;
517:
518: -- Check Whether record has been changed by someone else
519: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - l_version :' || l_version);
520:
521: If (l_version <> p_version) Then
522: -- IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 537: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Validate_attr_value');

533: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
534: THEN
535: -- Debug message
536: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
537: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Validate_attr_value');
538: END IF;
539:
540:
541: --since validation procedures will be done in record level in private API, No need to do any thing here

Line 561: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Updating loop');

557: cv_entity => p_entity
558: )
559: loop
560: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
561: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Updating loop');
562: END IF;
563: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
564:
565: --get all values from table and assign it to record and call update_attr_value of pv_enty_attr_value_pvt

Line 582: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - before calling pvt update method');

578: l_enty_attr_val_rec.attr_value_extn := x.attr_value_extn;
579: l_enty_attr_val_rec.validation_id := x.validation_id;
580:
581: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
582: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - before calling pvt update method');
583: END IF;
584: PV_Enty_Attr_Value_PVT.Update_Attr_Value(
585:
586: p_api_version_number => p_api_version_number

Line 621: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' cursor c_get_attr_details closed');

617: if(l_decimal_pts is null ) then
618: l_decimal_pts :=2; -- hardcodeing decimal pts to 2
619: end if;
620: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
621: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' cursor c_get_attr_details closed');
622: END IF;
623:
624: -- getting lov values table for dropdown attributes
625:

Line 628: PVX_Utility_PVT.debug_message('Getting lov values table for LOV String: '||l_lov_string);

624: -- getting lov values table for dropdown attributes
625:
626: IF(l_attribute_type = 'DROPDOWN') then
627: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
628: PVX_Utility_PVT.debug_message('Getting lov values table for LOV String: '||l_lov_string);
629: END IF;
630:
631: IF (l_lov_string IS NOT NULL OR LENGTH(l_lov_string) <> 0) THEN
632: --replacing java bindings with pl/sql bindings.

Line 644: PVX_Utility_PVT.debug_message('l_index:'||l_index||':');

640: END LOOP;
641: CLOSE lc_lov_cursor;
642:
643: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
644: PVX_Utility_PVT.debug_message('l_index:'||l_index||':');
645: END IF;
646:
647: EXCEPTION
648: WHEN OTHERS THEN

Line 672: PVX_Utility_PVT.debug_message('Performing all validatiosn for Dropdown attributes');

668: l_attr_val_rec := l_attr_val_tbl(l_curr_row);
669:
670: IF(l_attribute_type = 'DROPDOWN') then
671: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
672: PVX_Utility_PVT.debug_message('Performing all validatiosn for Dropdown attributes');
673: END IF;
674: --Checkign if Specified value(s) are in the look-up list of values
675: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
676: PVX_Utility_PVT.debug_message('Checkign if Specified value(s) are in the look-up list of values');

Line 676: PVX_Utility_PVT.debug_message('Checkign if Specified value(s) are in the look-up list of values');

672: PVX_Utility_PVT.debug_message('Performing all validatiosn for Dropdown attributes');
673: END IF;
674: --Checkign if Specified value(s) are in the look-up list of values
675: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
676: PVX_Utility_PVT.debug_message('Checkign if Specified value(s) are in the look-up list of values');
677: END IF;
678:
679: IF (l_attr_val_tbl(l_curr_row).attr_value <> null and
680: l_attr_val_tbl(l_curr_row).attr_value <> '' and

Line 693: PVX_Utility_PVT.debug_message('Match Found');

689:
690: RAISE FND_API.G_EXC_ERROR;
691: else
692: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
693: PVX_Utility_PVT.debug_message('Match Found');
694: END IF;
695:
696: END IF;
697:

Line 744: PVX_Utility_PVT.debug_message('Error in calculating percentage sum');

740: EXCEPTION
741: WHEN OTHERS THEN
742: l_percentage_total := 0;
743: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
744: PVX_Utility_PVT.debug_message('Error in calculating percentage sum');
745: END IF;
746: END;
747:
748: end if;

Line 815: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' CURRENCY' || sub_string(l_attr_val_rec.attr_value,':'));

811:
812: ELSIF (l_display_style= 'CURRENCY') THEN
813:
814: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
815: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' CURRENCY' || sub_string(l_attr_val_rec.attr_value,':'));
816: END IF;
817:
818: IF (--sub_string(l_attr_val_rec.attr_value,':') IS NULL OR
819: ( sub_string(l_attr_val_rec.attr_value,':') IS NOT NULL AND

Line 865: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' Val '|| l_attr_val_tbl(l_curr_row).attr_value);

861:
862: )
863: ;
864: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
865: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' Val '|| l_attr_val_tbl(l_curr_row).attr_value);
866: END IF;
867: END IF;
868:
869: END IF; -- end of ELSIF (l_attribute_type = 'TEXT') THEN

Line 881: PVX_Utility_PVT.debug_message('Error in getting profile option value PV_ATTR_PERCENTAGE_TOTAL');

877: l_perc_sum_profile_value:= to_number(nvl(fnd_profile.value('PV_ATTR_PERCENTAGE_TOTAL'), '100'));
878: EXCEPTION
879: WHEN OTHERS THEN
880: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
881: PVX_Utility_PVT.debug_message('Error in getting profile option value PV_ATTR_PERCENTAGE_TOTAL');
882: END IF;
883: l_perc_sum_profile_value:=100;
884: END;
885:

Line 887: PVX_Utility_PVT.debug_message('profile option PV_ATTR_PERCENTAGE_TOTAL value:'|| l_perc_sum_profile_value);

883: l_perc_sum_profile_value:=100;
884: END;
885:
886: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
887: PVX_Utility_PVT.debug_message('profile option PV_ATTR_PERCENTAGE_TOTAL value:'|| l_perc_sum_profile_value);
888: END IF;
889: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
890: PVX_Utility_PVT.debug_message('Sum of all Percentage attr values:'|| l_percentage_total);
891: END IF;

Line 890: PVX_Utility_PVT.debug_message('Sum of all Percentage attr values:'|| l_percentage_total);

886: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
887: PVX_Utility_PVT.debug_message('profile option PV_ATTR_PERCENTAGE_TOTAL value:'|| l_perc_sum_profile_value);
888: END IF;
889: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
890: PVX_Utility_PVT.debug_message('Sum of all Percentage attr values:'|| l_percentage_total);
891: END IF;
892:
893: IF(l_percentage_total < 0 or l_percentage_total > l_perc_sum_profile_value) THEN
894:

Line 927: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' User Id:--' || fnd_global.user_id);

923: RAISE FND_API.G_EXC_ERROR;
924: End;
925:
926: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
927: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' User Id:--' || fnd_global.user_id);
928: END IF;
929: -- calling notification API if validation rerquired for this attribute id
930: -- We are calling validation API only for attributes of type TEXT and DROPDOWN
931: -- We are skipping this call, if attribute is of type FUNCTION and not set validation flag

Line 966: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Calling Create Private API');

962:
963:
964: -- Debug Message
965: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
966: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Calling Create Private API');
967: END IF;
968: --if there are no records in p_attr_val_tbl, that means we have to create adummy row
969: -- with higher version and latest_flag as 'Y' and attribute_value as null
970: --just for the sake of tracking history

Line 978: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Value Table Null or Zero length');

974: (l_attr_val_tbl IS NOT NULL AND l_attr_val_tbl.count = 0)
975: ) THEN
976:
977: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
978: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Value Table Null or Zero length');
979: END IF;
980: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
981:
982: --initialising standard columns in the record

Line 1079: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' VAlue Table Not Null ');

1075:
1076: l_attr_val_rec := l_attr_val_tbl(l_curr_row1);
1077:
1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1079: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' VAlue Table Not Null ');
1080: END IF;
1081: --initialise it to null
1082: l_enty_attr_val_rec := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
1083:

Line 1109: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - after ');

1105: l_enty_attr_val_rec.version := p_version+1;
1106: l_enty_attr_val_rec.latest_flag := 'Y';
1107: l_enty_attr_val_rec.attr_value_extn :=l_attr_val_rec.attr_value_extn;
1108:
1109: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - after ');
1110:
1111: -- Invoke Private API(PV_ENTY_ATTR_VALUES_PVT.Create_Attr_Value
1112: PV_Enty_Attr_Value_PVT.Create_Attr_Value(
1113: p_api_version_number => p_api_version_number

Line 1151: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');

1147:
1148:
1149: -- Debug Message
1150: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1151: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');
1152: END IF;
1153:
1154: -- Standard call to get message count and if count is 1, get message info.
1155: FND_MSG_PUB.Count_And_Get (

Line 1162: WHEN PVX_Utility_PVT.resource_locked THEN

1158: );
1159:
1160: EXCEPTION
1161: /*
1162: WHEN PVX_Utility_PVT.resource_locked THEN
1163: x_return_status := FND_API.g_ret_sts_error;
1164: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1165: */
1166: WHEN FND_API.G_EXC_ERROR THEN

Line 1164: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1160: EXCEPTION
1161: /*
1162: WHEN PVX_Utility_PVT.resource_locked THEN
1163: x_return_status := FND_API.g_ret_sts_error;
1164: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1165: */
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: ROLLBACK TO Upsert_Attr_Value_PUB;
1168: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1225: PVX_Utility_PVT.debug_message('Private API: '||l_api_name );

1221: l_num_of_tokens NUMBER;
1222:
1223: BEGIN
1224: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1225: PVX_Utility_PVT.debug_message('Private API: '||l_api_name );
1226: END IF;
1227:
1228: l_num_of_tokens := (LENGTH(p_entity_attr_value) -
1229: LENGTH(REPLACE(p_entity_attr_value, ':::', '')))

Line 1233: PVX_Utility_PVT.debug_message('l_num_of_tokens: '||l_num_of_tokens);

1229: LENGTH(REPLACE(p_entity_attr_value, ':::', '')))
1230: /LENGTH(':::')
1231: + 1;
1232: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1233: PVX_Utility_PVT.debug_message('l_num_of_tokens: '||l_num_of_tokens);
1234: END IF;
1235:
1236: IF (l_num_of_tokens <> 3) THEN
1237: return 0;

Line 1250: PVX_Utility_PVT.debug_message('l_entity_attr_value: '||l_entity_attr_value);

1246: '999999999999.99999999999999999999'
1247: );
1248:
1249: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1250: PVX_Utility_PVT.debug_message('l_entity_attr_value: '||l_entity_attr_value);
1251: END IF;
1252:
1253: l_entity_currency_code := PV_CHECK_MATCH_PUB.Retrieve_Token (
1254: p_delimiter => ':::',

Line 1260: PVX_Utility_PVT.debug_message('l_entity_currency_code: '||l_entity_currency_code);

1256: p_input_type => 'IN TOKEN',
1257: p_index => 2
1258: );
1259: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1260: PVX_Utility_PVT.debug_message('l_entity_currency_code: '||l_entity_currency_code);
1261: END IF;
1262: IF (l_entity_currency_code IS NULL) THEN
1263: return 0;
1264: END IF;

Line 1274: PVX_Utility_PVT.debug_message('l_currency_date: '||l_currency_date);

1270: p_index => 3
1271: ),
1272: 'yyyymmddhh24miss');
1273: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1274: PVX_Utility_PVT.debug_message('l_currency_date: '||l_currency_date);
1275: END IF;
1276: IF (l_currency_date IS NULL) THEN
1277: return 0;
1278: END IF;

Line 1285: PVX_Utility_PVT.debug_message('Exception in checking the currency format ');

1281:
1282: EXCEPTION
1283: WHEN OTHERS THEN
1284: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1285: PVX_Utility_PVT.debug_message('Exception in checking the currency format ');
1286: END IF;
1287: return 0;
1288: END CHECK_CURRECY_FORMAT;
1289:

Line 1428: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');

1424: END IF;
1425:
1426: -- Debug Message
1427: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1428: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');
1429: END IF;
1430:
1431:
1432: -- Initialize API return status to SUCCESS

Line 1435: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

1431:
1432: -- Initialize API return status to SUCCESS
1433: x_return_status := FND_API.G_RET_STS_SUCCESS;
1434: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1435: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1436: END IF;
1437:
1438: --check for required columns
1439:

Line 1482: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Validate_attr_value');

1478: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
1479: THEN
1480: -- Debug message
1481: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1482: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Validate_attr_value');
1483: END IF;
1484:
1485: --since validation procedures will be done in record level in private API, No need to do any thing here
1486: --all validations would be done in inner API calls

Line 1497: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Before copying......');

1493:
1494:
1495: -- Debug Message
1496: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1497: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Before copying......');
1498: END IF;
1499: --if there are no records in p_attr_val_tbl, that means we have to create adummy row
1500: -- with higher version and latest_flag as 'Y' and attribute_value as null
1501: --just for the sake of tracking history

Line 1510: PVX_Utility_PVT.debug_message('Public API:'||l_full_name||' attr id: ' || p_attr_id_tbl(l_attr_count) );

1506: LOOP
1507:
1508: EXIT WHEN l_attr_count = p_attr_id_tbl.count+1;
1509: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1510: PVX_Utility_PVT.debug_message('Public API:'||l_full_name||' attr id: ' || p_attr_id_tbl(l_attr_count) );
1511: END IF;
1512:
1513: for x in c_get_previous_version(cv_attribute_id => p_attr_id_tbl(l_attr_count),
1514: cv_entity_id => p_entity_id,

Line 1535: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||'l_version: '||l_version ||

1531: end loop;
1532:
1533:
1534: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1535: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||'l_version: '||l_version ||
1536: 'l_attr_data_type: ' || l_attr_data_type);
1537: END IF;
1538:
1539:

Line 1542: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - No Attribute Type entities');

1538:
1539:
1540: if(l_attr_data_type is null) then
1541: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1542: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - No Attribute Type entities');
1543: END IF;
1544: elsif(l_attr_data_type = 'INTERNAL' or l_attr_data_type = 'INT_EXT') then
1545: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1546: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Internal sql_text entities');

Line 1546: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Internal sql_text entities');

1542: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - No Attribute Type entities');
1543: END IF;
1544: elsif(l_attr_data_type = 'INTERNAL' or l_attr_data_type = 'INT_EXT') then
1545: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1546: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Internal sql_text entities');
1547: END IF;
1548: l_index :=1;
1549: l_attr_val_tbl := g_miss_attr_value_tbl;
1550:

Line 1565: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - inserting Internal ...');

1561: end loop;
1562:
1563: if(l_attr_val_tbl is not null) then
1564: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1565: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - inserting Internal ...');
1566: END IF;
1567: Upsert_Attr_Value(
1568: p_api_version_number => p_api_version_number
1569: ,p_init_msg_list => p_init_msg_list

Line 1590: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - External sql_text entities');

1586: END IF;
1587:
1588: elsif(l_attr_data_type = 'EXTERNAL' or l_attr_data_type = 'EXT_INT') then
1589: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1590: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - External sql_text entities');
1591: END IF;
1592: l_index :=1;
1593: l_attr_val_tbl := g_miss_attr_value_tbl;
1594:

Line 1611: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - inserting External ...');

1607: END IF;
1608:
1609: if(l_attr_val_tbl is not null) then
1610: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1611: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - inserting External ...');
1612: END IF;
1613: Upsert_Attr_Value(
1614: p_api_version_number => p_api_version_number
1615: ,p_init_msg_list => p_init_msg_list

Line 1632: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - In Else Block');

1628: );
1629: end if;
1630: else
1631: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1632: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - In Else Block');
1633: END IF;
1634:
1635: END IF;
1636:

Line 1658: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');

1654:
1655:
1656: -- Debug Message
1657: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1658: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');
1659: END IF;
1660:
1661: -- Standard call to get message count and if count is 1, get message info.
1662: FND_MSG_PUB.Count_And_Get (

Line 1762: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');

1758: END IF;
1759:
1760: -- Debug Message
1761: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1762: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');
1763: END IF;
1764:
1765:
1766: -- Initialize API return status to SUCCESS

Line 1769: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

1765:
1766: -- Initialize API return status to SUCCESS
1767: x_return_status := FND_API.G_RET_STS_SUCCESS;
1768: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1769: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1770: END IF;
1771:
1772: --check for required columns
1773:

Line 1797: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Validate_attr_value');

1793: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
1794: THEN
1795: -- Debug message
1796: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1797: PVX_Utility_PVT.debug_message('public API: '||l_full_name||' - Validate_attr_value');
1798: END IF;
1799:
1800: --since validation procedures will be done in record level in private API,
1801: --No need to do any thing here

Line 1813: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Before Checking validations......');

1809:
1810:
1811: -- Debug Message
1812: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1813: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - Before Checking validations......');
1814: END IF;
1815:
1816: -- At least one partner type should be there as partner type is mandatory
1817: -- If table is null, error should be thrown.

Line 1855: PVX_Utility_PVT.debug_message('Attr Value Rec: attr_value:' || l_attr_value || '::::attr _value_extn:' || l_attr_value_extn );

1851: l_attr_value := l_attr_val_rec.attr_value ;
1852: l_attr_value_extn := l_attr_val_rec.attr_value_extn;
1853:
1854: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1855: PVX_Utility_PVT.debug_message('Attr Value Rec: attr_value:' || l_attr_value || '::::attr _value_extn:' || l_attr_value_extn );
1856: END IF;
1857:
1858: IF(l_attr_value_extn is not null and
1859: l_attr_value_extn = 'Y' )

Line 1862: PVX_Utility_PVT.debug_message('Primary Partner Type found');

1858: IF(l_attr_value_extn is not null and
1859: l_attr_value_extn = 'Y' )
1860: THEN
1861: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1862: PVX_Utility_PVT.debug_message('Primary Partner Type found');
1863: END IF;
1864: l_is_primary_partner_type := 'Y';
1865:
1866: else --if (l_attr_value_extn is null) then

Line 1872: PVX_Utility_PVT.debug_message('l_is_primary_partner_type:' || l_is_primary_partner_type);

1868: END IF;
1869: END LOOP; --FOR l_curr_row IN 1..l_attr_val_tbl.count LOOP
1870:
1871: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1872: PVX_Utility_PVT.debug_message('l_is_primary_partner_type:' || l_is_primary_partner_type);
1873: END IF;
1874:
1875: --Checkif primary partner type exists
1876: IF( l_is_primary_partner_type is null or

Line 1897: PVX_Utility_PVT.debug_message('Attr Value Rec: attr_value:' || l_attr_value || '::::attr _value_extn:' || l_attr_value_extn );

1893: l_attr_value := l_attr_val_rec.attr_value ;
1894: l_attr_value_extn := l_attr_val_rec.attr_value_extn;
1895:
1896: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1897: PVX_Utility_PVT.debug_message('Attr Value Rec: attr_value:' || l_attr_value || '::::attr _value_extn:' || l_attr_value_extn );
1898: END IF;
1899:
1900: IF(l_attr_value_extn is not null and
1901: l_attr_value_extn = 'Y' )

Line 1904: PVX_Utility_PVT.debug_message('Primary Partner Type found');

1900: IF(l_attr_value_extn is not null and
1901: l_attr_value_extn = 'Y' )
1902: THEN
1903: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1904: PVX_Utility_PVT.debug_message('Primary Partner Type found');
1905: END IF;
1906:
1907: if(l_is_primary_partner_type is null) then
1908: l_is_primary_partner_type := 'Y';

Line 1912: PVX_Utility_PVT.debug_message('duplicate primary partner type found');

1908: l_is_primary_partner_type := 'Y';
1909: l_primary_partner_type := l_attr_value;
1910: elsif(l_is_primary_partner_type = 'Y' ) then
1911: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1912: PVX_Utility_PVT.debug_message('duplicate primary partner type found');
1913: END IF;
1914: --Throw error multiple primary partner types can not be there
1915: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1916: FND_MESSAGE.set_name('PV', 'PV_NO_MULTI_PRIM_PRTNR_TYPES');

Line 1923: PVX_Utility_PVT.debug_message('inserting it as additional partner type:'|| l_attr_value);

1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1920: end if;
1921: else --if (l_attr_value_extn is null) then
1922: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1923: PVX_Utility_PVT.debug_message('inserting it as additional partner type:'|| l_attr_value);
1924: END IF;
1925: l_attr_values_table.extend;
1926: l_attr_values_table(l_index) := l_attr_value;
1927: l_index := l_index + 1;

Line 1934: PVX_Utility_PVT.debug_message('l_is_primary_partner_type:' || l_is_primary_partner_type);

1930:
1931: END LOOP; --FOR l_curr_row IN 1..l_attr_val_tbl.count LOOP
1932:
1933: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1934: PVX_Utility_PVT.debug_message('l_is_primary_partner_type:' || l_is_primary_partner_type);
1935: END IF;
1936:
1937: --Checkif primary partner type exists
1938: IF( l_is_primary_partner_type is null or

Line 1952: PVX_Utility_PVT.debug_message('Checking if any of the additional partner types is primary partner type');

1948:
1949:
1950: --Checking if any of the additional partner types is primary partner type
1951: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1952: PVX_Utility_PVT.debug_message('Checking if any of the additional partner types is primary partner type');
1953: END IF;
1954:
1955:
1956: FOR i in 1 .. l_attr_values_table.count LOOP

Line 1958: PVX_Utility_PVT.debug_message('l_attr_values_table('|| i ||'):' || l_attr_values_table(i) );

1954:
1955:
1956: FOR i in 1 .. l_attr_values_table.count LOOP
1957: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1958: PVX_Utility_PVT.debug_message('l_attr_values_table('|| i ||'):' || l_attr_values_table(i) );
1959: END IF;
1960: if (l_primary_partner_type = l_attr_values_table(i) ) then
1961: --Throw error ::
1962: --The Additional Partner Type selected has already been selected as Primary Partner Type.

Line 1965: PVX_Utility_PVT.debug_message('One of the the additional partner types is primary partner type');

1961: --Throw error ::
1962: --The Additional Partner Type selected has already been selected as Primary Partner Type.
1963: --Please select different partner type
1964: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1965: PVX_Utility_PVT.debug_message('One of the the additional partner types is primary partner type');
1966: END IF;
1967:
1968: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1969: FND_MESSAGE.set_name('PV', 'PV_INVALID_ADDTNL_PRTNR_TYPES');

Line 2015: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');

2011: END IF;
2012:
2013: -- Debug Message
2014: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2015: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - end');
2016: END IF;
2017:
2018: -- Standard call to get message count and if count is 1, get message info.
2019: FND_MSG_PUB.Count_And_Get (