APPS.PV_ENTY_ATTR_VALUE_PUB dependencies on FND_MESSAGE

Line 148: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
152: x_return_status := FND_API.g_ret_sts_error;

Line 149: FND_MESSAGE.set_token('COLUMN','attribute_id');

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;
152: x_return_status := FND_API.g_ret_sts_error;
153: RETURN;

Line 157: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
161: x_return_status := FND_API.g_ret_sts_error;

Line 158: FND_MESSAGE.set_token('COLUMN','entity type');

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;
161: x_return_status := FND_API.g_ret_sts_error;
162: RETURN;

Line 166: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
170: x_return_status := FND_API.g_ret_sts_error;

Line 167: FND_MESSAGE.set_token('COLUMN','entity_id');

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;
170: x_return_status := FND_API.g_ret_sts_error;
171: RETURN;

Line 475: FND_MESSAGE.set_name('PV', 'PV_API_EXECUTION_ERROR');

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);
479: FND_MESSAGE.set_token('ENTITY',p_entity);

Line 476: FND_MESSAGE.set_token('TEXT', l_external_update_text);

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);
479: FND_MESSAGE.set_token('ENTITY',p_entity);
480: FND_MSG_PUB.add;

Line 477: FND_MESSAGE.set_token('ID', TO_CHAR(p_attribute_id));

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);
479: FND_MESSAGE.set_token('ENTITY',p_entity);
480: FND_MSG_PUB.add;
481: END IF;

Line 478: FND_MESSAGE.set_token('NAME', l_attribute_name);

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);
479: FND_MESSAGE.set_token('ENTITY',p_entity);
480: FND_MSG_PUB.add;
481: END IF;
482: RAISE FND_API.G_EXC_ERROR;

Line 479: FND_MESSAGE.set_token('ENTITY',p_entity);

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

Line 525: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');

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;
528: END IF;
529: RAISE FND_API.G_EXC_ERROR;

Line 526: FND_MESSAGE.set_token('VALUE','Attribute Entity Value');

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;
528: END IF;
529: RAISE FND_API.G_EXC_ERROR;
530: End if;

Line 650: FND_MESSAGE.set_name('PV', 'PV_LOV_EXECUTION_ERROR');

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);
654: FND_MSG_PUB.add;

Line 651: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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);
654: FND_MSG_PUB.add;
655: END IF;

Line 652: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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);
654: FND_MSG_PUB.add;
655: END IF;
656: RAISE FND_API.G_EXC_ERROR;

Line 653: FND_MESSAGE.set_token('ENTITY',p_entity);

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);
654: FND_MSG_PUB.add;
655: END IF;
656: RAISE FND_API.G_EXC_ERROR;
657:

Line 684: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_LOV_ERROR');

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

Line 685: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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

Line 686: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
688: END IF;
689:
690: RAISE FND_API.G_EXC_ERROR;

Line 702: FND_MESSAGE.set_name('PV', 'PV_ATTR_ONLY_ONE_VALUE');

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

Line 703: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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

Line 704: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
706: END IF;
707:
708: RAISE FND_API.G_EXC_ERROR;

Line 716: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_MUMERIC');

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

Line 717: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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

Line 718: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
720: END IF;
721:
722: RAISE FND_API.G_EXC_ERROR;

Line 759: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');

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

Line 760: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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

Line 761: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
763: END IF;
764:
765: RAISE FND_API.G_EXC_ERROR;

Line 773: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');

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

Line 774: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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

Line 775: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
777: END IF;
778:
779: RAISE FND_API.G_EXC_ERROR;

Line 785: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_TEXT_LIMIT');

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

Line 786: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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

Line 787: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
789: END IF;
790:
791: RAISE FND_API.G_EXC_ERROR;

Line 802: FND_MESSAGE.set_name('PV', 'PV_ATTR_DATE_FORMAT_ERROR');

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

Line 803: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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

Line 804: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
806: END IF;
807:
808: RAISE FND_API.G_EXC_ERROR;

Line 825: FND_MESSAGE.set_name('PV', 'PV_ATTR_VALUE_NON_NUMERIC');

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

Line 826: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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;
829: END IF;
830: RAISE FND_API.G_EXC_ERROR;

Line 827: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
829: END IF;
830: RAISE FND_API.G_EXC_ERROR;
831:

Line 837: FND_MESSAGE.set_name('PV', 'PV_ATTR_CURR_FORMAT_ERROR');

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

Line 838: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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;
841: END IF;
842: RAISE FND_API.G_EXC_ERROR;

Line 839: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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;
841: END IF;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;

Line 896: FND_MESSAGE.set_name('PV', 'PV_ATTR_PERCENT_SUM_ERROR');

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);
900: FND_MSG_PUB.add;

Line 897: FND_MESSAGE.set_token('TOTAL','' || l_perc_sum_profile_value);

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);
900: FND_MSG_PUB.add;
901: END IF;

Line 898: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_attribute_id);

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);
900: FND_MSG_PUB.add;
901: END IF;
902: RAISE FND_API.G_EXC_ERROR;

Line 899: FND_MESSAGE.set_token('ATTRIBUTE_NAME',l_attribute_name);

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);
900: FND_MSG_PUB.add;
901: END IF;
902: RAISE FND_API.G_EXC_ERROR;
903:

Line 1044: Fnd_Message.set_name('PV', 'PV_ENTY_ATTR_VAL_MULTI_ERROR');

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
1048: where lookup_type = 'PV_ATTRIBUTE_TYPE'

Line 1053: Fnd_Message.set_token('ATTR_TYPE',l_meaning);

1049: and lookup_code = l_attribute_type
1050: ) LOOP
1051: l_meaning := x.meaning;
1052: END LOOP;
1053: Fnd_Message.set_token('ATTR_TYPE',l_meaning);
1054:
1055: FOR x IN (select meaning from pv_lookups
1056: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
1057: and lookup_code = l_display_style

Line 1061: Fnd_Message.set_token('ATTR_STYLE',l_meaning);

1057: and lookup_code = l_display_style
1058: ) LOOP
1059: l_meaning := x.meaning;
1060: END LOOP;
1061: Fnd_Message.set_token('ATTR_STYLE',l_meaning);
1062:
1063:
1064: Fnd_Msg_Pub.ADD;
1065: END IF;

Line 1442: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
1446: x_return_status := FND_API.g_ret_sts_error;

Line 1443: FND_MESSAGE.set_token('COLUMN','p_attr_id_tbl');

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;
1446: x_return_status := FND_API.g_ret_sts_error;
1447: RETURN;

Line 1451: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
1455: x_return_status := FND_API.g_ret_sts_error;

Line 1452: FND_MESSAGE.set_token('COLUMN','p_entity_id');

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;
1455: x_return_status := FND_API.g_ret_sts_error;
1456: RETURN;

Line 1460: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
1464: x_return_status := FND_API.g_ret_sts_error;

Line 1461: FND_MESSAGE.set_token('COLUMN','p_entity');

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;
1464: x_return_status := FND_API.g_ret_sts_error;
1465: RETURN;

Line 1469: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
1473: x_return_status := FND_API.g_ret_sts_error;

Line 1470: FND_MESSAGE.set_token('COLUMN','p_partner_id');

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;
1473: x_return_status := FND_API.g_ret_sts_error;
1474: RETURN;

Line 1776: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
1780: x_return_status := FND_API.g_ret_sts_error;

Line 1777: FND_MESSAGE.set_token('COLUMN','p_entity_id');

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;
1780: x_return_status := FND_API.g_ret_sts_error;
1781: RETURN;

Line 1785: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;
1789: x_return_status := FND_API.g_ret_sts_error;

Line 1786: FND_MESSAGE.set_token('COLUMN','p_version');

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;
1789: x_return_status := FND_API.g_ret_sts_error;
1790: RETURN;

Line 1824: FND_MESSAGE.set_name('PV', 'PV_ATLEASTONE_PRTNR_TYPE');

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;
1828: x_return_status := FND_API.g_ret_sts_error;

Line 1825: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');

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;
1828: x_return_status := FND_API.g_ret_sts_error;
1829: RETURN;

Line 1839: FND_MESSAGE.set_name('PV', 'PV_ONLYONE_PRTNR_TYPE');

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;
1843: x_return_status := FND_API.g_ret_sts_error;

Line 1840: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');

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;
1843: x_return_status := FND_API.g_ret_sts_error;
1844: RETURN;

Line 1881: FND_MESSAGE.set_name('PV', 'PV_ONLYONE_PRTNR_TYPE');

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

Line 1916: FND_MESSAGE.set_name('PV', 'PV_NO_MULTI_PRIM_PRTNR_TYPES');

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;
1920: end if;

Line 1943: FND_MESSAGE.set_name('PV', 'PV_NO_PRIM_PRTNR_TYPES');

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

Line 1969: FND_MESSAGE.set_name('PV', 'PV_INVALID_ADDTNL_PRTNR_TYPES');

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;
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1970: --FND_MESSAGE.set_token('COLUMN','p_attr_val_tbl');

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;
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: end if;