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_PARTNER_MIGRATIONS_PUB dependencies on FND_API

Line 157: ,p_init_msg_list => FND_API.g_false

153: end if;
154:
155: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
156: p_api_version_number=> 1.0
157: ,p_init_msg_list => FND_API.g_false
158: ,p_commit => FND_API.g_false
159: ,p_validation_level => FND_API.g_valid_level_full
160: ,x_return_status => l_return_status
161: ,x_msg_count => l_msg_count

Line 158: ,p_commit => FND_API.g_false

154:
155: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
156: p_api_version_number=> 1.0
157: ,p_init_msg_list => FND_API.g_false
158: ,p_commit => FND_API.g_false
159: ,p_validation_level => FND_API.g_valid_level_full
160: ,x_return_status => l_return_status
161: ,x_msg_count => l_msg_count
162: ,x_msg_data => l_msg_data

Line 159: ,p_validation_level => FND_API.g_valid_level_full

155: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
156: p_api_version_number=> 1.0
157: ,p_init_msg_list => FND_API.g_false
158: ,p_commit => FND_API.g_false
159: ,p_validation_level => FND_API.g_valid_level_full
160: ,x_return_status => l_return_status
161: ,x_msg_count => l_msg_count
162: ,x_msg_data => l_msg_data
163: ,p_attribute_id => 3

Line 173: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

169:
170: FND_FILE.PUT_LINE(FND_FILE.LOG, '' );
171: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || RPAD(l_partner_name||'('||l_entity_id||')',45) || RPAD(p_primary_partner_type,42) || l_addtl_partner_type );
172:
173: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
174: IF ( l_msg_count > 1 ) THEN
175: FOR l_msg_index IN 1..l_msg_count LOOP
176: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_index));
177: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || substr(apps.fnd_message.get,1,254) );

Line 182: p_encoded => FND_API.G_FALSE

178: END LOOP;
179: ELSE
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE
183: ,p_count => l_msg_count
184: ,p_data => l_msg_data
185: );
186: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || l_msg_data );

Line 501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

497: if not l_count > 0 then
498: FND_MESSAGE.set_name('PV','PV_MIGR_LKUP_SETUP');
499: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
500:
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
502: end if;
503:
504: -- Validate that all different partner types code are included
505: -- in PV_PARTNER_TYPE_RNKING lookup setup.

Line 528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

524: );
525: IF l_count > 0 THEN
526: FND_MESSAGE.set_name('PV','PV_MIGR_LKUP_INCOMPL');
527: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
529: end if;
530:
531:
532: --Validate that all partner types have been ranked, if yes check if they are numbers

Line 548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

544: if l_count > 0 then
545: FND_MESSAGE.set_name('PV','PV_MIGR_RANK_INCOMPL');
546: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
547:
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
549: end if;
550:
551: --Check for the integer
552: begin

Line 568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

564: when INVALID_NUMBER then
565: FND_MESSAGE.set_name('PV','PV_MIGR_RANK_NUMBER');
566: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
567:
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
569: end;
570:
571:
572: --Make sure that the same ranking is not used by more than one partner_type

Line 599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

595: if l_count <> l_distinct_count then
596: FND_MESSAGE.set_name('PV','PV_MIGR_RANK_UNIQUE');
597: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
598:
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
600: end if;
601:
602:
603: -- Writing the header information of the Log report.

Line 656: l_return_status := FND_API.G_RET_STS_SUCCESS;

652: -- Standard Start of savepoint
653: SAVEPOINT VAD_Partner_OWRTY;
654:
655: -- Initialize return variables before the procedure call.
656: l_return_status := FND_API.G_RET_STS_SUCCESS;
657: l_msg_count := 0;
658: l_msg_data := NULL;
659:
660: Update_Primary_Partner

Line 669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

665: x_msg_count => l_msg_count,
666: x_msg_data => l_msg_data
667: );
668:
669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673: EXCEPTION

Line 670: RAISE FND_API.G_EXC_ERROR;

666: x_msg_data => l_msg_data
667: );
668:
669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO VAD_Partner_OWRTY;
676: WHEN OTHERS THEN
677: ROLLBACK TO VAD_Partner_OWRTY;
678: END;

Line 724: l_return_status := FND_API.G_RET_STS_SUCCESS;

720: -- Standard Start of savepoint
721: SAVEPOINT OTHER_Partner_OWRTY;
722:
723: -- Initialize return variables before the procedure call.
724: l_return_status := FND_API.G_RET_STS_SUCCESS;
725: l_msg_count := 0;
726: l_msg_data := NULL;
727:
728: Update_Primary_Partner

Line 737: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

733: x_msg_count => l_msg_count,
734: x_msg_data => l_msg_data
735: );
736:
737: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740:
741: EXCEPTION

Line 738: RAISE FND_API.G_EXC_ERROR;

734: x_msg_data => l_msg_data
735: );
736:
737: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN

Line 742: WHEN FND_API.G_EXC_ERROR THEN

738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: ROLLBACK TO OTHER_Partner_OWRTY;
744: WHEN OTHERS THEN
745: ROLLBACK TO OTHER_Partner_OWRTY;
746: END;

Line 787: l_return_status := FND_API.G_RET_STS_SUCCESS;

783: -- Standard Start of savepoint
784: SAVEPOINT VAD_Partner_OWRTN;
785:
786: -- Initialize return variables before the procedure call.
787: l_return_status := FND_API.G_RET_STS_SUCCESS;
788: l_msg_count := 0;
789: l_msg_data := NULL;
790:
791: Update_Primary_Partner(

Line 799: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

795: x_msg_count => l_msg_count,
796: x_msg_data => l_msg_data
797: );
798:
799: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802:
803: EXCEPTION

Line 800: RAISE FND_API.G_EXC_ERROR;

796: x_msg_data => l_msg_data
797: );
798:
799: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802:
803: EXCEPTION
804: WHEN FND_API.G_EXC_ERROR THEN

Line 804: WHEN FND_API.G_EXC_ERROR THEN

800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802:
803: EXCEPTION
804: WHEN FND_API.G_EXC_ERROR THEN
805: ROLLBACK TO VAD_Partner_OWRTN;
806: WHEN OTHERS THEN
807: ROLLBACK TO VAD_Partner_OWRTN;
808: END;

Line 843: l_return_status := FND_API.G_RET_STS_SUCCESS;

839: -- Standard Start of savepoint
840: SAVEPOINT OTHER_Partner_OWRTN;
841:
842: -- Initialize return variables before the procedure call.
843: l_return_status := FND_API.G_RET_STS_SUCCESS;
844: l_msg_count := 0;
845: l_msg_data := NULL;
846:
847: Update_Primary_Partner(

Line 855: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

851: x_msg_count => l_msg_count,
852: x_msg_data => l_msg_data
853: );
854:
855: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:
859: EXCEPTION

Line 856: RAISE FND_API.G_EXC_ERROR;

852: x_msg_data => l_msg_data
853: );
854:
855: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:
859: EXCEPTION
860: WHEN FND_API.G_EXC_ERROR THEN

Line 860: WHEN FND_API.G_EXC_ERROR THEN

856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:
859: EXCEPTION
860: WHEN FND_API.G_EXC_ERROR THEN
861: ROLLBACK TO OTHER_Partner_OWRTN;
862: WHEN OTHERS THEN
863: ROLLBACK TO OTHER_Partner_OWRTN;
864: END;

Line 920: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

916: retcode := 2;
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLERRM: ' || SQLERRM);
918: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
920: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
921: END LOOP;
922: END;
923:
924: