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_API

Line 31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

27: -- Hint: Primary key needs to be returned.
28:
29: PROCEDURE Upsert_Attr_Value(
30: p_api_version_number IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
34:
35: ,x_return_status OUT NOCOPY VARCHAR2

Line 32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

28:
29: PROCEDURE Upsert_Attr_Value(
30: p_api_version_number IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
34:
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER

Line 33: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

29: PROCEDURE Upsert_Attr_Value(
30: p_api_version_number IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
34:
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER
37: ,x_msg_data OUT NOCOPY VARCHAR2

Line 59: l_version NUMBER := FND_API.G_MISS_NUM;

55: x_object_version_number NUMBER;
56: l_attr_val_tbl attr_value_tbl_type := p_attr_val_tbl;
57: l_attr_val_rec attr_val_rec_type := g_miss_attr_val_rec;
58: l_enty_attr_val_rec PV_Enty_Attr_Value_PVT.enty_attr_val_rec_type := PV_Enty_Attr_Value_PVT.g_miss_enty_attr_val_rec;
59: l_version NUMBER := FND_API.G_MISS_NUM;
60:
61: l_decimal_pts NUMBER;
62: l_attribute_type VARCHAR2(30);
63: l_display_style VARCHAR2(30);

Line 119: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

115: -- Standard Start of API savepoint
116: SAVEPOINT Upsert_Attr_Value_PUB;
117:
118: -- Standard call to check for call compatibility.
119: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
120: p_api_version_number,
121: l_api_name,
122: G_PKG_NAME)
123: THEN

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: p_api_version_number,
121: l_api_name,
122: G_PKG_NAME)
123: THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list )

Line 128: IF FND_API.to_Boolean( p_init_msg_list )

124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
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:

Line 139: x_return_status := FND_API.G_RET_STS_SUCCESS;

135: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - start');
136: END IF;
137:
138: -- Initialize API return status to SUCCESS
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 152: x_return_status := FND_API.g_ret_sts_error;

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;
155: IF p_entity IS NULL THEN
156: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 161: x_return_status := FND_API.g_ret_sts_error;

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;
164: IF p_entity_id IS NULL THEN
165: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 170: x_return_status := FND_API.g_ret_sts_error;

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;
173:
174:

Line 290: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

286:
287: );
288:
289:
290: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293: end loop;
294: end if;

Line 291: RAISE FND_API.G_EXC_ERROR;

287: );
288:
289:
290: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293: end loop;
294: end if;
295:

Line 323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

319: ,p_enty_attr_val_id => x.enty_attr_val_id
320: ,p_object_version_number => x.object_version_number
321:
322: );
323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326: end loop;
327:

Line 324: RAISE FND_API.G_EXC_ERROR;

320: ,p_object_version_number => x.object_version_number
321:
322: );
323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326: end loop;
327:
328: FOR l_curr_row IN l_attr_val_tbl.first..l_attr_val_tbl.last LOOP

Line 361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

357:
358: ,p_enty_attr_val_rec => l_lead_enty_attr_val_rec
359: ,x_enty_attr_val_id => x_enty_attr_val_id
360: );
361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: END LOOP; --FOR l_curr_row IN 1..l_attr_val_tbl.count LOOP

Line 362: RAISE FND_API.G_EXC_ERROR;

358: ,p_enty_attr_val_rec => l_lead_enty_attr_val_rec
359: ,x_enty_attr_val_id => x_enty_attr_val_id
360: );
361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: END LOOP; --FOR l_curr_row IN 1..l_attr_val_tbl.count LOOP
366:

Line 413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

409:
410: ,p_enty_attr_val_rec => l_lead_enty_attr_val_rec
411: ,x_enty_attr_val_id => x_enty_attr_val_id
412: );
413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: END LOOP; --FOR l_curr_row IN 1..l_attr_val_tbl.count LOOP

Line 414: RAISE FND_API.G_EXC_ERROR;

410: ,p_enty_attr_val_rec => l_lead_enty_attr_val_rec
411: ,x_enty_attr_val_id => x_enty_attr_val_id
412: );
413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: END LOOP; --FOR l_curr_row IN 1..l_attr_val_tbl.count LOOP
418: end if; -- end of if(l_lead_record_exists = 'Y') then

Line 467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

463: ,p_entity_id
464: ,l_value;
465:
466:
467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
468:
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471:

Line 469: RAISE FND_API.G_EXC_ERROR;

465:
466:
467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
468:
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471:
472: EXCEPTION
473: WHEN OTHERS THEN

Line 482: RAISE FND_API.G_EXC_ERROR;

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

Line 514: IF l_version IS NULL OR l_version = FND_API.G_MISS_NUM THEN

510:
511: --if no row for this attribute id, entity, the you will get version as null,
512: --so you need to initialise version to 1
513:
514: IF l_version IS NULL OR l_version = FND_API.G_MISS_NUM THEN
515: l_version := 0;
516: END IF;
517:
518: -- Check Whether record has been changed by someone else

Line 529: RAISE FND_API.G_EXC_ERROR;

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:
532:
533: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 533: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

529: RAISE FND_API.G_EXC_ERROR;
530: End if;
531:
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');

Line 546: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

542: --We have done all validations that are to be done above.
543:
544: END IF;
545:
546: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
547: RAISE FND_API.G_EXC_ERROR;
548: END IF;
549:
550:

Line 547: RAISE FND_API.G_EXC_ERROR;

543:
544: END IF;
545:
546: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
547: RAISE FND_API.G_EXC_ERROR;
548: END IF;
549:
550:
551:

Line 600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

596: ,x_object_version_number => x_object_version_number
597:
598: );
599:
600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: END LOOP; --for x in c_get_enty_attr_value

Line 601: RAISE FND_API.G_EXC_ERROR;

597:
598: );
599:
600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: END LOOP; --for x in c_get_enty_attr_value
605:

Line 656: RAISE FND_API.G_EXC_ERROR;

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

Line 690: RAISE FND_API.G_EXC_ERROR;

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

Line 708: RAISE FND_API.G_EXC_ERROR;

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:
710: END IF;
711:
712: ELSIF( l_display_style= 'PERCENTAGE') THEN

Line 722: RAISE FND_API.G_EXC_ERROR;

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:
724: END IF;
725:
726: if(to_number(trim(l_attr_val_rec.attr_value_extn))<0) then

Line 728: x_return_status := FND_API.g_ret_sts_error;

724: END IF;
725:
726: if(to_number(trim(l_attr_val_rec.attr_value_extn))<0) then
727:
728: x_return_status := FND_API.g_ret_sts_error;
729: RAISE FND_API.G_EXC_ERROR;
730:
731: elsif(to_number(trim(l_attr_val_rec.attr_value_extn))=0) then
732:

Line 729: RAISE FND_API.G_EXC_ERROR;

725:
726: if(to_number(trim(l_attr_val_rec.attr_value_extn))<0) then
727:
728: x_return_status := FND_API.g_ret_sts_error;
729: RAISE FND_API.G_EXC_ERROR;
730:
731: elsif(to_number(trim(l_attr_val_rec.attr_value_extn))=0) then
732:
733: l_attr_val_tbl.delete(l_curr_row);

Line 765: RAISE FND_API.G_EXC_ERROR;

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

Line 779: RAISE FND_API.G_EXC_ERROR;

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;
781: ELSIF (l_display_style= 'STRING') THEN
782:
783: IF( length(l_attr_val_rec.attr_value) > l_character_width) THEN

Line 791: RAISE FND_API.G_EXC_ERROR;

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;
793:
794: ELSIF (l_display_style= 'DATE') THEN
795:

Line 808: RAISE FND_API.G_EXC_ERROR;

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;
810:
811:
812: ELSIF (l_display_style= 'CURRENCY') THEN

Line 830: RAISE FND_API.G_EXC_ERROR;

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

Line 842: RAISE FND_API.G_EXC_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:
845:
846:

Line 902: RAISE FND_API.G_EXC_ERROR;

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;
905:
906: END IF; -- end of IF (l_attribute_type='DROPDOWN' and l_display_style= 'CURRENCY') THEN

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 919: p_encoded => FND_API.G_FALSE

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

Line 923: RAISE FND_API.G_EXC_ERROR;

919: p_encoded => FND_API.G_FALSE
920: ,p_count => x_msg_count
921: ,p_data => x_msg_data
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);

Line 954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

950: ,x_msg_data => x_msg_data
951: );
952:
953:
954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
955: RAISE FND_API.G_EXC_ERROR;
956: END IF;
957:
958: end if;

Line 955: RAISE FND_API.G_EXC_ERROR;

951: );
952:
953:
954: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
955: RAISE FND_API.G_EXC_ERROR;
956: END IF;
957:
958: end if;
959:

Line 1026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1022: );
1023:
1024:
1025:
1026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029:
1030: ELSE -- there are records in l_attr_val_tbl

Line 1027: RAISE FND_API.G_EXC_ERROR;

1023:
1024:
1025:
1026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029:
1030: ELSE -- there are records in l_attr_val_tbl
1031:

Line 1066: RAISE Fnd_Api.G_EXC_ERROR;

1062:
1063:
1064: Fnd_Msg_Pub.ADD;
1065: END IF;
1066: RAISE Fnd_Api.G_EXC_ERROR;
1067:
1068:
1069: end if;
1070:

Line 1128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1124: );
1125:
1126:
1127:
1128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131:
1132: l_curr_row1:=l_attr_val_tbl.next(l_curr_row1);

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125:
1126:
1127:
1128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131:
1132: l_curr_row1:=l_attr_val_tbl.next(l_curr_row1);
1133:

Line 1143: IF FND_API.to_Boolean( p_commit )

1139: -- End of API body
1140: --
1141:
1142: -- Standard check for p_commit
1143: IF FND_API.to_Boolean( p_commit )
1144: THEN
1145: COMMIT WORK;
1146: END IF;
1147:

Line 1163: x_return_status := FND_API.g_ret_sts_error;

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

Line 1166: WHEN FND_API.G_EXC_ERROR THEN

1162: WHEN PVX_Utility_PVT.resource_locked THEN
1163: x_return_status := FND_API.g_ret_sts_error;
1164: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1165: */
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: ROLLBACK TO Upsert_Attr_Value_PUB;
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (

Line 1168: x_return_status := FND_API.G_RET_STS_ERROR;

1164: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1165: */
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: ROLLBACK TO Upsert_Attr_Value_PUB;
1168: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 1171: p_encoded => FND_API.G_FALSE

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

Line 1176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1172: ,p_count => x_msg_count
1173: ,p_data => x_msg_data
1174: );
1175:
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 (

Line 1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1174: );
1175:
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

Line 1181: p_encoded => FND_API.G_FALSE

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

Line 1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1195: p_encoded => FND_API.G_FALSE

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: );
1199: End Upsert_Attr_Value;

Line 1344: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1340:
1341:
1342: PROCEDURE Copy_Partner_Attr_Values(
1343: p_api_version_number IN NUMBER
1344: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1345: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1346: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1347:
1348: ,x_return_status OUT NOCOPY VARCHAR2

Line 1345: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1341:
1342: PROCEDURE Copy_Partner_Attr_Values(
1343: p_api_version_number IN NUMBER
1344: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1345: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1346: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1347:
1348: ,x_return_status OUT NOCOPY VARCHAR2
1349: ,x_msg_count OUT NOCOPY NUMBER

Line 1346: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1342: PROCEDURE Copy_Partner_Attr_Values(
1343: p_api_version_number IN NUMBER
1344: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1345: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1346: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1347:
1348: ,x_return_status OUT NOCOPY VARCHAR2
1349: ,x_msg_count OUT NOCOPY NUMBER
1350: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1412: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1408: -- Standard Start of API savepoint
1409: SAVEPOINT Copy_Partner_Attr_Values_PUB;
1410:
1411: -- Standard call to check for call compatibility.
1412: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1413: p_api_version_number,
1414: l_api_name,
1415: G_PKG_NAME)
1416: THEN

Line 1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1413: p_api_version_number,
1414: l_api_name,
1415: G_PKG_NAME)
1416: THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1418: END IF;
1419:
1420: -- Initialize message list if p_init_msg_list is set to TRUE.
1421: IF FND_API.to_Boolean( p_init_msg_list )

Line 1421: IF FND_API.to_Boolean( p_init_msg_list )

1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1418: END IF;
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:

Line 1433: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1446: x_return_status := FND_API.g_ret_sts_error;

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;
1449: IF p_entity_id IS NULL THEN
1450: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 1455: x_return_status := FND_API.g_ret_sts_error;

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;
1458: IF p_entity IS NULL THEN
1459: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 1464: x_return_status := FND_API.g_ret_sts_error;

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;
1467: IF p_partner_id IS NULL THEN
1468: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 1473: x_return_status := FND_API.g_ret_sts_error;

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

Line 1478: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

1474: RETURN;
1475: END IF;
1476:
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');

Line 1490: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1486: --all validations would be done in inner API calls
1487:
1488: END IF;
1489:
1490: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494:

Line 1491: RAISE FND_API.G_EXC_ERROR;

1487:
1488: END IF;
1489:
1490: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494:
1495: -- Debug Message

Line 1584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1580: ,p_version => l_version
1581: ,p_attr_val_tbl => l_attr_val_tbl
1582: );
1583: end if;
1584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS 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

Line 1585: RAISE FND_API.G_EXC_ERROR;

1581: ,p_attr_val_tbl => l_attr_val_tbl
1582: );
1583: end if;
1584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS 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

Line 1650: IF FND_API.to_Boolean( p_commit )

1646: -- End of API body
1647: --
1648:
1649: -- Standard check for p_commit
1650: IF FND_API.to_Boolean( p_commit )
1651: THEN
1652: COMMIT WORK;
1653: END IF;
1654:

Line 1669: WHEN FND_API.G_EXC_ERROR THEN

1665: );
1666:
1667: EXCEPTION
1668:
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 (

Line 1671: x_return_status := FND_API.G_RET_STS_ERROR;

1667: EXCEPTION
1668:
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

Line 1674: p_encoded => FND_API.G_FALSE

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

Line 1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1675: ,p_count => x_msg_count
1676: ,p_data => x_msg_data
1677: );
1678:
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 (

Line 1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1677: );
1678:
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

Line 1684: p_encoded => FND_API.G_FALSE

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

Line 1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1698: p_encoded => FND_API.G_FALSE

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: );
1702: End Copy_Partner_Attr_Values;

Line 1706: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1702: End Copy_Partner_Attr_Values;
1703:
1704: PROCEDURE Upsert_Partner_Types (
1705: p_api_version_number IN NUMBER
1706: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1707: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1708: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1709: ,x_return_status OUT NOCOPY VARCHAR2
1710: ,x_msg_count OUT NOCOPY NUMBER

Line 1707: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1703:
1704: PROCEDURE Upsert_Partner_Types (
1705: p_api_version_number IN NUMBER
1706: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1707: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1708: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1709: ,x_return_status OUT NOCOPY VARCHAR2
1710: ,x_msg_count OUT NOCOPY NUMBER
1711: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1708: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1704: PROCEDURE Upsert_Partner_Types (
1705: p_api_version_number IN NUMBER
1706: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1707: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1708: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1709: ,x_return_status OUT NOCOPY VARCHAR2
1710: ,x_msg_count OUT NOCOPY NUMBER
1711: ,x_msg_data OUT NOCOPY VARCHAR2
1712: ,p_entity_id IN NUMBER

Line 1746: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1742: -- Standard Start of API savepoint
1743: SAVEPOINT Upsert_Partner_Types_pub;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1747: p_api_version_number,
1748: l_api_name,
1749: G_PKG_NAME)
1750: THEN

Line 1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1747: p_api_version_number,
1748: l_api_name,
1749: G_PKG_NAME)
1750: THEN
1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1752: END IF;
1753:
1754: -- Initialize message list if p_init_msg_list is set to TRUE.
1755: IF FND_API.to_Boolean( p_init_msg_list )

Line 1755: IF FND_API.to_Boolean( p_init_msg_list )

1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1752: END IF;
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:

Line 1767: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1780: x_return_status := FND_API.g_ret_sts_error;

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;
1783: IF p_version IS NULL THEN
1784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 1789: x_return_status := FND_API.g_ret_sts_error;

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;
1792:
1793: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 1793: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

1789: x_return_status := FND_API.g_ret_sts_error;
1790: RETURN;
1791: END IF;
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');

Line 1806: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1802: --all validations would be done in inner API calls
1803:
1804: END IF;
1805:
1806: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809:
1810:

Line 1807: RAISE FND_API.G_EXC_ERROR;

1803:
1804: END IF;
1805:
1806: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809:
1810:
1811: -- Debug Message

Line 1828: x_return_status := FND_API.g_ret_sts_error;

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;
1831:
1832: --Only one partner type should be there

Line 1843: x_return_status := FND_API.g_ret_sts_error;

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;
1846:
1847: --Checking if the partner type attribute value extension is Y or not.

Line 1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1887:
1888: /*

Line 1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1949:
1950: --Checking if any of the additional partner types is primary partner type

Line 1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1976: END LOOP;
1977: */

Line 2000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1996: ,p_attr_val_tbl => l_attr_val_tbl
1997: );
1998:
1999:
2000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2001: RAISE FND_API.G_EXC_ERROR;
2002: END IF;
2003:
2004:

Line 2001: RAISE FND_API.G_EXC_ERROR;

1997: );
1998:
1999:
2000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2001: RAISE FND_API.G_EXC_ERROR;
2002: END IF;
2003:
2004:
2005: -- End of API body

Line 2008: IF FND_API.to_Boolean( p_commit )

2004:
2005: -- End of API body
2006: -- Standard check for p_commit
2007:
2008: IF FND_API.to_Boolean( p_commit )
2009: THEN
2010: COMMIT WORK;
2011: END IF;
2012:

Line 2026: WHEN FND_API.G_EXC_ERROR THEN

2022: );
2023:
2024: EXCEPTION
2025:
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 (

Line 2028: x_return_status := FND_API.G_RET_STS_ERROR;

2024: EXCEPTION
2025:
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

Line 2031: p_encoded => FND_API.G_FALSE

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

Line 2036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2032: ,p_count => x_msg_count
2033: ,p_data => x_msg_data
2034: );
2035:
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 (

Line 2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2034: );
2035:
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

Line 2041: p_encoded => FND_API.G_FALSE

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

Line 2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2055: p_encoded => FND_API.G_FALSE

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: );
2059: End Upsert_Partner_Types;