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 FND_MSG_PUB

Line 130: FND_MSG_PUB.initialize;

126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list )
129: THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: -- Debug Message
134: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

Line 134: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

130: FND_MSG_PUB.initialize;
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

Line 140: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

136: END IF;
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:

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

143:
144:
145: --check for required items like attribute_id, entity, entity_id,versioin
146: IF p_attribute_id IS NULL THEN
147: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
148: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
149: FND_MESSAGE.set_token('COLUMN','attribute_id');
150: FND_MSG_PUB.add;
151: END IF;

Line 150: FND_MSG_PUB.add;

146: IF p_attribute_id IS NULL THEN
147: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
148: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
149: FND_MESSAGE.set_token('COLUMN','attribute_id');
150: FND_MSG_PUB.add;
151: END IF;
152: x_return_status := FND_API.g_ret_sts_error;
153: RETURN;
154: END IF;

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

152: x_return_status := FND_API.g_ret_sts_error;
153: RETURN;
154: END IF;
155: IF p_entity IS NULL THEN
156: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
157: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
158: FND_MESSAGE.set_token('COLUMN','entity type');
159: FND_MSG_PUB.add;
160: END IF;

Line 159: FND_MSG_PUB.add;

155: IF p_entity IS NULL THEN
156: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
157: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
158: FND_MESSAGE.set_token('COLUMN','entity type');
159: FND_MSG_PUB.add;
160: END IF;
161: x_return_status := FND_API.g_ret_sts_error;
162: RETURN;
163: END IF;

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

161: x_return_status := FND_API.g_ret_sts_error;
162: RETURN;
163: END IF;
164: IF p_entity_id IS NULL THEN
165: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
166: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
167: FND_MESSAGE.set_token('COLUMN','entity_id');
168: FND_MSG_PUB.add;
169: END IF;

Line 168: FND_MSG_PUB.add;

164: IF p_entity_id IS NULL THEN
165: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
166: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
167: FND_MESSAGE.set_token('COLUMN','entity_id');
168: FND_MSG_PUB.add;
169: END IF;
170: x_return_status := FND_API.g_ret_sts_error;
171: RETURN;
172: END IF;

Line 187: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

183: l_attribute_name:= x.name;
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);

Line 207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

203: l_require_validation_flag := x.require_validation_flag;
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);

Line 221: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

217: -- In this case we just simply insert and update
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,

Line 264: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

260: )
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,

Line 299: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

295:
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,

Line 369: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

365: END LOOP; --FOR l_curr_row IN 1..l_attr_val_tbl.count LOOP
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

Line 391: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

387: l_lead_enty_attr_val_rec.enabled_flag := 'Y';
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:

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

429:
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

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

470: END IF;
471:
472: EXCEPTION
473: WHEN OTHERS THEN
474: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
475: FND_MESSAGE.set_name('PV', 'PV_API_EXECUTION_ERROR');
476: FND_MESSAGE.set_token('TEXT', l_external_update_text);
477: FND_MESSAGE.set_token('ID', TO_CHAR(p_attribute_id));
478: FND_MESSAGE.set_token('NAME', l_attribute_name);

Line 480: FND_MSG_PUB.add;

476: FND_MESSAGE.set_token('TEXT', l_external_update_text);
477: FND_MESSAGE.set_token('ID', TO_CHAR(p_attribute_id));
478: FND_MESSAGE.set_token('NAME', l_attribute_name);
479: FND_MESSAGE.set_token('ENTITY',p_entity);
480: FND_MSG_PUB.add;
481: END IF;
482: RAISE FND_API.G_EXC_ERROR;
483: END;
484:

Line 495: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

491: -- this else block will end at last line
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

Line 522: -- IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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
524:
525: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
526: FND_MESSAGE.set_token('VALUE','Attribute Entity Value');

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

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
524:
525: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
526: FND_MESSAGE.set_token('VALUE','Attribute Entity Value');
527: FND_MSG_PUB.add;

Line 527: FND_MSG_PUB.add;

523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
524:
525: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
526: FND_MESSAGE.set_token('VALUE','Attribute Entity Value');
527: FND_MSG_PUB.add;
528: END IF;
529: RAISE FND_API.G_EXC_ERROR;
530: End if;
531:

Line 536: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

532:
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:

Line 560: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

556: cv_entity_id => p_entity_id,
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:

Line 581: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

577: l_enty_attr_val_rec.latest_flag := 'N';
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:

Line 620: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

616: */
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

Line 627: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

623:
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

Line 643: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

639: l_lov_data_tbl(l_index) := l_lov_data_rec;
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

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

645: END IF;
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
650: FND_MESSAGE.set_name('PV', 'PV_LOV_EXECUTION_ERROR');
651: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
652: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
653: FND_MESSAGE.set_token('ENTITY',p_entity);

Line 654: FND_MSG_PUB.add;

650: FND_MESSAGE.set_name('PV', 'PV_LOV_EXECUTION_ERROR');
651: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
652: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
653: FND_MESSAGE.set_token('ENTITY',p_entity);
654: FND_MSG_PUB.add;
655: END IF;
656: RAISE FND_API.G_EXC_ERROR;
657:
658: end;

Line 671: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

667:
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

Line 675: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) 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');
677: END IF;
678:
679: IF (l_attr_val_tbl(l_curr_row).attr_value <> null and

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

679: IF (l_attr_val_tbl(l_curr_row).attr_value <> null and
680: l_attr_val_tbl(l_curr_row).attr_value <> '' and
681: MATCH_CODE_TO_VALUE(l_attr_val_tbl(l_curr_row).attr_value,l_lov_data_tbl) = '$$INVALID*$VALUE$$' )
682: THEN
683: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
684: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_LOV_ERROR');
685: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
686: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
687: FND_MSG_PUB.add;

Line 687: FND_MSG_PUB.add;

683: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
684: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_LOV_ERROR');
685: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
686: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
687: FND_MSG_PUB.add;
688: END IF;
689:
690: RAISE FND_API.G_EXC_ERROR;
691: else

Line 692: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

688: END IF;
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;

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

697:
698: IF( l_display_style= 'SINGLE' OR l_display_style= 'RADIO') THEN
699: IF(l_curr_row > 1) THEN
700:
701: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
702: FND_MESSAGE.set_name('PV', 'PV_ATTR_ONLY_ONE_VALUE');
703: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
704: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
705: FND_MSG_PUB.add;

Line 705: FND_MSG_PUB.add;

701: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
702: FND_MESSAGE.set_name('PV', 'PV_ATTR_ONLY_ONE_VALUE');
703: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
704: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
705: FND_MSG_PUB.add;
706: END IF;
707:
708: RAISE FND_API.G_EXC_ERROR;
709:

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

711:
712: ELSIF( l_display_style= 'PERCENTAGE') THEN
713:
714: IF( NOT is_number (l_attr_val_rec.attr_value_extn) ) THEN
715: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
716: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_MUMERIC');
717: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
718: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
719: FND_MSG_PUB.add;

Line 719: FND_MSG_PUB.add;

715: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
716: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_MUMERIC');
717: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
718: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
719: FND_MSG_PUB.add;
720: END IF;
721:
722: RAISE FND_API.G_EXC_ERROR;
723:

Line 743: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

739: l_percentage_total := l_percentage_total + to_number(l_attr_val_tbl(l_curr_row).attr_value_extn);
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:

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

754:
755: IF (l_display_style= 'NUMBER') THEN
756:
757: IF( NOT is_number (l_attr_val_rec.attr_value) ) THEN
758: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
759: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');
760: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
761: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
762: FND_MSG_PUB.add;

Line 762: FND_MSG_PUB.add;

758: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
759: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');
760: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
761: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
762: FND_MSG_PUB.add;
763: END IF;
764:
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;

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

768: l_attr_val_tbl(l_curr_row).attr_value := ROUND(l_attr_val_tbl(l_curr_row).attr_value,l_decimal_pts);
769: ELSIF (l_display_style= 'PERCENTAGE') THEN
770:
771: IF( NOT is_number (l_attr_val_rec.attr_value) ) THEN
772: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
773: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');
774: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
775: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
776: FND_MSG_PUB.add;

Line 776: FND_MSG_PUB.add;

772: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
773: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');
774: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
775: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
776: FND_MSG_PUB.add;
777: END IF;
778:
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;

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

780: END IF;
781: ELSIF (l_display_style= 'STRING') THEN
782:
783: IF( length(l_attr_val_rec.attr_value) > l_character_width) THEN
784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
785: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_TEXT_LIMIT');
786: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
787: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
788: FND_MSG_PUB.add;

Line 788: FND_MSG_PUB.add;

784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
785: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_TEXT_LIMIT');
786: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
787: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
788: FND_MSG_PUB.add;
789: END IF;
790:
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;

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

797: l_date := to_date(l_attr_val_tbl(l_curr_row).attr_value,'yyyymmddhh24miss');
798: exception
799: when others then
800:
801: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
802: FND_MESSAGE.set_name('PV', 'PV_ATTR_DATE_FORMAT_ERROR');
803: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
804: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
805: FND_MSG_PUB.add;

Line 805: FND_MSG_PUB.add;

801: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
802: FND_MESSAGE.set_name('PV', 'PV_ATTR_DATE_FORMAT_ERROR');
803: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
804: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
805: FND_MSG_PUB.add;
806: END IF;
807:
808: RAISE FND_API.G_EXC_ERROR;
809: end;

Line 814: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

810:
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

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

820: NOT is_number (sub_string(l_attr_val_rec.attr_value,':'))
821: )
822: ) THEN
823:
824: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
825: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');
826: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
827: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
828: FND_MSG_PUB.add;

Line 828: FND_MSG_PUB.add;

824: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
825: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');
826: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
827: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
828: FND_MSG_PUB.add;
829: END IF;
830: RAISE FND_API.G_EXC_ERROR;
831:
832:

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

832:
833: END IF;
834:
835: IF(CHECK_CURRECY_FORMAT(l_attr_val_tbl(l_curr_row).attr_value) = 0) THEN
836: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
837: FND_MESSAGE.set_name('PV', 'PV_ATTR_CURR_FORMAT_ERROR');
838: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
839: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
840: FND_MSG_PUB.add;

Line 840: FND_MSG_PUB.add;

836: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
837: FND_MESSAGE.set_name('PV', 'PV_ATTR_CURR_FORMAT_ERROR');
838: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
839: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
840: FND_MSG_PUB.add;
841: END IF;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844:

Line 864: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

860: INSTR(l_attr_val_tbl(l_curr_row).attr_value, ':', 1, 1)
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:

Line 880: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

876:
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;

Line 886: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

882: END IF;
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);

Line 889: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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;
892:
893: IF(l_percentage_total < 0 or l_percentage_total > l_perc_sum_profile_value) THEN

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

891: END IF;
892:
893: IF(l_percentage_total < 0 or l_percentage_total > l_perc_sum_profile_value) THEN
894:
895: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
896: FND_MESSAGE.set_name('PV', 'PV_ATTR_PERCENT_SUM_ERROR');
897: FND_MESSAGE.set_token('TOTAL','' || l_perc_sum_profile_value);
898: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
899: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

Line 900: FND_MSG_PUB.add;

896: FND_MESSAGE.set_name('PV', 'PV_ATTR_PERCENT_SUM_ERROR');
897: FND_MESSAGE.set_token('TOTAL','' || l_perc_sum_profile_value);
898: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);
899: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);
900: FND_MSG_PUB.add;
901: END IF;
902: RAISE FND_API.G_EXC_ERROR;
903:
904: END IF;

Line 912: /*IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

908: EXCEPTION
909: WHEN OTHERS THEN
910: ROLLBACK TO Upsert_Attr_Value_PUB;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: /*IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
913: THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: */

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

910: ROLLBACK TO Upsert_Attr_Value_PUB;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: /*IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
913: THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: */
917: -- Standard call to get message count and if count=1, get the message
918: FND_MSG_PUB.Count_And_Get (

Line 918: FND_MSG_PUB.Count_And_Get (

914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: */
917: -- Standard call to get message count and if count=1, get the message
918: FND_MSG_PUB.Count_And_Get (
919: p_encoded => FND_API.G_FALSE
920: ,p_count => x_msg_count
921: ,p_data => x_msg_data
922: );

Line 926: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

922: );
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

Line 965: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

961: --end calling notification 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

Line 977: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

973: --p_attr_val_tbl = g_miss_attr_value_tbl OR
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:

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

1039: )
1040: and not (l_attribute_type = 'FUNCTION')
1041:
1042: ) then
1043: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1044: Fnd_Message.set_name('PV', 'PV_ENTY_ATTR_VAL_MULTI_ERROR');
1045:
1046:
1047: FOR x IN (select meaning from pv_lookups

Line 1064: Fnd_Msg_Pub.ADD;

1060: END LOOP;
1061: Fnd_Message.set_token('ATTR_STYLE',l_meaning);
1062:
1063:
1064: Fnd_Msg_Pub.ADD;
1065: END IF;
1066: RAISE Fnd_Api.G_EXC_ERROR;
1067:
1068:

Line 1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1074: WHILE l_curr_row1 <= l_attr_val_tbl.last LOOP
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;

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

1146: END IF;
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.

Line 1155: FND_MSG_PUB.Count_And_Get (

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 (
1156: p_count => x_msg_count
1157: ,p_data => x_msg_data
1158: );
1159:

Line 1170: FND_MSG_PUB.Count_And_Get (

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;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE
1172: ,p_count => x_msg_count
1173: ,p_data => x_msg_data
1174: );

Line 1180: FND_MSG_PUB.Count_And_Get (

1176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1177: ROLLBACK TO Upsert_Attr_Value_PUB;
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: -- Standard call to get message count and if count=1, get the message
1180: FND_MSG_PUB.Count_And_Get (
1181: p_encoded => FND_API.G_FALSE
1182: ,p_count => x_msg_count
1183: ,p_data => x_msg_data
1184: );

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

1185:
1186: WHEN OTHERS THEN
1187: ROLLBACK TO Upsert_Attr_Value_PUB;
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message

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

1187: ROLLBACK TO Upsert_Attr_Value_PUB;
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE

Line 1194: FND_MSG_PUB.Count_And_Get (

1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE
1196: ,p_count => x_msg_count
1197: ,p_data => x_msg_data
1198: );

Line 1224: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1220: l_currency_date DATE;
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) -

Line 1232: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1228: l_num_of_tokens := (LENGTH(p_entity_attr_value) -
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

Line 1249: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1245: ),
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 (

Line 1259: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1255: p_attr_value_string => p_entity_attr_value,
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;

Line 1273: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1269: p_input_type => 'IN TOKEN',
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;

Line 1284: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1280: return 1;
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;

Line 1423: FND_MSG_PUB.initialize;

1419:
1420: -- Initialize message list if p_init_msg_list is set to TRUE.
1421: IF FND_API.to_Boolean( p_init_msg_list )
1422: THEN
1423: FND_MSG_PUB.initialize;
1424: END IF;
1425:
1426: -- Debug Message
1427: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

Line 1427: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1423: FND_MSG_PUB.initialize;
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:

Line 1434: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1430:
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

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

1437:
1438: --check for required columns
1439:
1440: IF p_attr_id_tbl IS NULL THEN
1441: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1442: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1443: FND_MESSAGE.set_token('COLUMN','p_attr_id_tbl');
1444: FND_MSG_PUB.add;
1445: END IF;

Line 1444: FND_MSG_PUB.add;

1440: IF p_attr_id_tbl IS NULL THEN
1441: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1442: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1443: FND_MESSAGE.set_token('COLUMN','p_attr_id_tbl');
1444: FND_MSG_PUB.add;
1445: END IF;
1446: x_return_status := FND_API.g_ret_sts_error;
1447: RETURN;
1448: END IF;

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

1446: x_return_status := FND_API.g_ret_sts_error;
1447: RETURN;
1448: END IF;
1449: IF p_entity_id IS NULL THEN
1450: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1451: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1452: FND_MESSAGE.set_token('COLUMN','p_entity_id');
1453: FND_MSG_PUB.add;
1454: END IF;

Line 1453: FND_MSG_PUB.add;

1449: IF p_entity_id IS NULL THEN
1450: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1451: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1452: FND_MESSAGE.set_token('COLUMN','p_entity_id');
1453: FND_MSG_PUB.add;
1454: END IF;
1455: x_return_status := FND_API.g_ret_sts_error;
1456: RETURN;
1457: END IF;

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

1455: x_return_status := FND_API.g_ret_sts_error;
1456: RETURN;
1457: END IF;
1458: IF p_entity IS NULL THEN
1459: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1460: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1461: FND_MESSAGE.set_token('COLUMN','p_entity');
1462: FND_MSG_PUB.add;
1463: END IF;

Line 1462: FND_MSG_PUB.add;

1458: IF p_entity IS NULL THEN
1459: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1460: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1461: FND_MESSAGE.set_token('COLUMN','p_entity');
1462: FND_MSG_PUB.add;
1463: END IF;
1464: x_return_status := FND_API.g_ret_sts_error;
1465: RETURN;
1466: END IF;

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

1464: x_return_status := FND_API.g_ret_sts_error;
1465: RETURN;
1466: END IF;
1467: IF p_partner_id IS NULL THEN
1468: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1469: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1470: FND_MESSAGE.set_token('COLUMN','p_partner_id');
1471: FND_MSG_PUB.add;
1472: END IF;

Line 1471: FND_MSG_PUB.add;

1467: IF p_partner_id IS NULL THEN
1468: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1469: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1470: FND_MESSAGE.set_token('COLUMN','p_partner_id');
1471: FND_MSG_PUB.add;
1472: END IF;
1473: x_return_status := FND_API.g_ret_sts_error;
1474: RETURN;
1475: END IF;

Line 1481: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1477:
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

Line 1496: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1492: END IF;
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

Line 1509: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1505: l_attr_count := 1;
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),

Line 1534: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1530: l_sql_text := x.sql_text;
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:

Line 1541: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1537: END IF;
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

Line 1545: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) 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');
1547: END IF;
1548: l_index :=1;
1549: l_attr_val_tbl := g_miss_attr_value_tbl;

Line 1564: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1560: l_index := l_index +1;
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

Line 1589: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1585: RAISE FND_API.G_EXC_ERROR;
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;

Line 1610: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1606: CLOSE lc_ext_cursor;
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

Line 1631: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1627: ,p_attr_val_tbl => l_attr_val_tbl
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;

Line 1657: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1653: END IF;
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.

Line 1662: FND_MSG_PUB.Count_And_Get (

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 (
1663: p_count => x_msg_count
1664: ,p_data => x_msg_data
1665: );
1666:

Line 1673: FND_MSG_PUB.Count_And_Get (

1669: WHEN FND_API.G_EXC_ERROR THEN
1670: ROLLBACK TO Copy_Partner_Attr_Values_PUB;
1671: x_return_status := FND_API.G_RET_STS_ERROR;
1672: -- Standard call to get message count and if count=1, get the message
1673: FND_MSG_PUB.Count_And_Get (
1674: p_encoded => FND_API.G_FALSE
1675: ,p_count => x_msg_count
1676: ,p_data => x_msg_data
1677: );

Line 1683: FND_MSG_PUB.Count_And_Get (

1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: ROLLBACK TO Copy_Partner_Attr_Values_PUB;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: -- Standard call to get message count and if count=1, get the message
1683: FND_MSG_PUB.Count_And_Get (
1684: p_encoded => FND_API.G_FALSE
1685: ,p_count => x_msg_count
1686: ,p_data => x_msg_data
1687: );

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

1688:
1689: WHEN OTHERS THEN
1690: ROLLBACK TO Copy_Partner_Attr_Values_PUB;
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1693: THEN
1694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1695: END IF;
1696: -- Standard call to get message count and if count=1, get the message

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

1690: ROLLBACK TO Copy_Partner_Attr_Values_PUB;
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1693: THEN
1694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1695: END IF;
1696: -- Standard call to get message count and if count=1, get the message
1697: FND_MSG_PUB.Count_And_Get (
1698: p_encoded => FND_API.G_FALSE

Line 1697: FND_MSG_PUB.Count_And_Get (

1693: THEN
1694: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1695: END IF;
1696: -- Standard call to get message count and if count=1, get the message
1697: FND_MSG_PUB.Count_And_Get (
1698: p_encoded => FND_API.G_FALSE
1699: ,p_count => x_msg_count
1700: ,p_data => x_msg_data
1701: );

Line 1757: FND_MSG_PUB.initialize;

1753:
1754: -- Initialize message list if p_init_msg_list is set to TRUE.
1755: IF FND_API.to_Boolean( p_init_msg_list )
1756: THEN
1757: FND_MSG_PUB.initialize;
1758: END IF;
1759:
1760: -- Debug Message
1761: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

Line 1761: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1757: FND_MSG_PUB.initialize;
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:

Line 1768: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1764:
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

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

1771:
1772: --check for required columns
1773:
1774: IF p_entity_id IS NULL THEN
1775: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1776: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1777: FND_MESSAGE.set_token('COLUMN','p_entity_id');
1778: FND_MSG_PUB.add;
1779: END IF;

Line 1778: FND_MSG_PUB.add;

1774: IF p_entity_id IS NULL THEN
1775: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1776: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1777: FND_MESSAGE.set_token('COLUMN','p_entity_id');
1778: FND_MSG_PUB.add;
1779: END IF;
1780: x_return_status := FND_API.g_ret_sts_error;
1781: RETURN;
1782: END IF;

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

1780: x_return_status := FND_API.g_ret_sts_error;
1781: RETURN;
1782: END IF;
1783: IF p_version IS NULL THEN
1784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1785: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1786: FND_MESSAGE.set_token('COLUMN','p_version');
1787: FND_MSG_PUB.add;
1788: END IF;

Line 1787: FND_MSG_PUB.add;

1783: IF p_version IS NULL THEN
1784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1785: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1786: FND_MESSAGE.set_token('COLUMN','p_version');
1787: FND_MSG_PUB.add;
1788: END IF;
1789: x_return_status := FND_API.g_ret_sts_error;
1790: RETURN;
1791: END IF;

Line 1796: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1792:
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,

Line 1812: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1808: END IF;
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

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

1819: IF ( l_attr_val_tbl IS NULL OR
1820: (l_attr_val_tbl IS NOT NULL AND l_attr_val_tbl.count = 0)
1821: )
1822: THEN
1823: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1824: FND_MESSAGE.set_name('PV', 'PV_ATLEASTONE_PRTNR_TYPE');
1825: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');
1826: FND_MSG_PUB.add;
1827: END IF;

Line 1826: FND_MSG_PUB.add;

1822: THEN
1823: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1824: FND_MESSAGE.set_name('PV', 'PV_ATLEASTONE_PRTNR_TYPE');
1825: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');
1826: FND_MSG_PUB.add;
1827: END IF;
1828: x_return_status := FND_API.g_ret_sts_error;
1829: RETURN;
1830: END IF;

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

1834: IF ( l_attr_val_tbl IS NULL OR
1835: (l_attr_val_tbl IS NOT NULL AND l_attr_val_tbl.count >1 )
1836: )
1837: THEN
1838: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1839: FND_MESSAGE.set_name('PV', 'PV_ONLYONE_PRTNR_TYPE');
1840: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');
1841: FND_MSG_PUB.add;
1842: END IF;

Line 1841: FND_MSG_PUB.add;

1837: THEN
1838: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1839: FND_MESSAGE.set_name('PV', 'PV_ONLYONE_PRTNR_TYPE');
1840: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');
1841: FND_MSG_PUB.add;
1842: END IF;
1843: x_return_status := FND_API.g_ret_sts_error;
1844: RETURN;
1845: END IF;

Line 1854: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1850: l_attr_val_rec := l_attr_val_tbl(l_curr_row);
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

Line 1861: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1857:
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:

Line 1871: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1867: l_is_primary_partner_type := 'N';
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

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

1876: IF( l_is_primary_partner_type is null or
1877: (l_is_primary_partner_type is not null and l_is_primary_partner_type <> 'Y')
1878: ) then
1879: --Throw error no primary partner types is there
1880: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1881: FND_MESSAGE.set_name('PV', 'PV_ONLYONE_PRTNR_TYPE');
1882: FND_MSG_PUB.add;
1883: END IF;
1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1882: FND_MSG_PUB.add;

1878: ) then
1879: --Throw error no primary partner types is there
1880: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1881: FND_MESSAGE.set_name('PV', 'PV_ONLYONE_PRTNR_TYPE');
1882: FND_MSG_PUB.add;
1883: END IF;
1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886:

Line 1896: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1892: l_attr_val_rec := l_attr_val_tbl(l_curr_row);
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

Line 1903: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1899:
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

Line 1911: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1907: if(l_is_primary_partner_type is null) then
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

Line 1915: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) 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');
1917: FND_MSG_PUB.add;
1918: END IF;
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1917: FND_MSG_PUB.add;

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');
1917: FND_MSG_PUB.add;
1918: END IF;
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1920: end if;
1921: else --if (l_attr_value_extn is null) then

Line 1922: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1918: END IF;
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;

Line 1933: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1929:
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

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

1938: IF( l_is_primary_partner_type is null or
1939: (l_is_primary_partner_type is not null and l_is_primary_partner_type <> 'Y')
1940: ) then
1941: --Throw error no primary partner types is there
1942: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1943: FND_MESSAGE.set_name('PV', 'PV_NO_PRIM_PRTNR_TYPES');
1944: FND_MSG_PUB.add;
1945: END IF;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1944: FND_MSG_PUB.add;

1940: ) then
1941: --Throw error no primary partner types is there
1942: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1943: FND_MESSAGE.set_name('PV', 'PV_NO_PRIM_PRTNR_TYPES');
1944: FND_MSG_PUB.add;
1945: END IF;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: END IF;
1948:

Line 1951: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1947: END IF;
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:

Line 1957: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1953: END IF;
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 ::

Line 1964: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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.
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

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

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');
1970: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');
1971: FND_MSG_PUB.add;
1972: END IF;

Line 1971: FND_MSG_PUB.add;

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');
1970: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');
1971: FND_MSG_PUB.add;
1972: END IF;
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: end if;
1975:

Line 2014: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

2010: COMMIT WORK;
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.

Line 2019: FND_MSG_PUB.Count_And_Get (

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 (
2020: p_count => x_msg_count
2021: ,p_data => x_msg_data
2022: );
2023:

Line 2030: FND_MSG_PUB.Count_And_Get (

2026: WHEN FND_API.G_EXC_ERROR THEN
2027: ROLLBACK TO Upsert_Partner_Types_pub;
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: -- Standard call to get message count and if count=1, get the message
2030: FND_MSG_PUB.Count_And_Get (
2031: p_encoded => FND_API.G_FALSE
2032: ,p_count => x_msg_count
2033: ,p_data => x_msg_data
2034: );

Line 2040: FND_MSG_PUB.Count_And_Get (

2036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2037: ROLLBACK TO Upsert_Partner_Types_pub;
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2039: -- Standard call to get message count and if count=1, get the message
2040: FND_MSG_PUB.Count_And_Get (
2041: p_encoded => FND_API.G_FALSE
2042: ,p_count => x_msg_count
2043: ,p_data => x_msg_data
2044: );

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

2045:
2046: WHEN OTHERS THEN
2047: ROLLBACK TO Upsert_Partner_Types_pub;
2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2050: THEN
2051: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2052: END IF;
2053: -- Standard call to get message count and if count=1, get the message

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

2047: ROLLBACK TO Upsert_Partner_Types_pub;
2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2050: THEN
2051: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2052: END IF;
2053: -- Standard call to get message count and if count=1, get the message
2054: FND_MSG_PUB.Count_And_Get (
2055: p_encoded => FND_API.G_FALSE

Line 2054: FND_MSG_PUB.Count_And_Get (

2050: THEN
2051: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2052: END IF;
2053: -- Standard call to get message count and if count=1, get the message
2054: FND_MSG_PUB.Count_And_Get (
2055: p_encoded => FND_API.G_FALSE
2056: ,p_count => x_msg_count
2057: ,p_data => x_msg_data
2058: );