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_FILE

Line 170: FND_FILE.PUT_LINE(FND_FILE.LOG, '' );

166: ,p_version => l_version
167: ,p_attr_val_tbl => l_attr_val_tbl
168: );
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

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

167: ,p_attr_val_tbl => l_attr_val_tbl
168: );
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

Line 177: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || substr(apps.fnd_message.get,1,254) );

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

Line 186: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || l_msg_data );

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 );
187: END IF;
188: END IF;
189:
190: END Update_Primary_Partner;

Line 484: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

480: FND_MESSAGE.SET_TOKEN('PARAM2','Overwrite');
481: FND_MESSAGE.SET_TOKEN('PARAMVALUE1',p_running_mode);
482: FND_MESSAGE.SET_TOKEN('PARAMVALUE2',p_Overwrite);
483:
484: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
485:
486: SAVEPOINT migrate_partner_type;
487:
488: --Validating the PV_PARTNER_TYPE_RNKING lookup setup.

Line 499: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

495: and enabled_flag = 'Y';
496:
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:

Line 527: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

523: enabled_flag = 'Y'
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:

Line 546: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

542: TAG IS NULL;
543:
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:

Line 566: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

562: TAG IS NOT NULL;
563: exception
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:

Line 597: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

593:
594:
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:

Line 604: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

600: end if;
601:
602:
603: -- Writing the header information of the Log report.
604: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
605: FND_MESSAGE.set_name('PV','PV_MIGR_RANKING');
606: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
607: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
608:

Line 606: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

602:
603: -- Writing the header information of the Log report.
604: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
605: FND_MESSAGE.set_name('PV','PV_MIGR_RANKING');
606: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
607: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
608:
609: for x in Get_Ranked_Partner_types
610: loop

Line 607: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

603: -- Writing the header information of the Log report.
604: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
605: FND_MESSAGE.set_name('PV','PV_MIGR_RANKING');
606: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
607: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
608:
609: for x in Get_Ranked_Partner_types
610: loop
611: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || RPAD(x.lookup_code,50) || ' ' || x.tag);

Line 611: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || RPAD(x.lookup_code,50) || ' ' || x.tag);

607: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
608:
609: for x in Get_Ranked_Partner_types
610: loop
611: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || RPAD(x.lookup_code,50) || ' ' || x.tag);
612: end loop;
613:
614: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
615:

Line 614: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

610: loop
611: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || RPAD(x.lookup_code,50) || ' ' || x.tag);
612: end loop;
613:
614: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
615:
616:
617: -- Writing the 'Active' and 'Inactive' partner type count in the Log report.
618: for x in Get_Partner_Status_Count

Line 623: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

619: loop
620: FND_MESSAGE.set_name('PV','PV_MIGR_DETAILS');
621: FND_MESSAGE.SET_TOKEN('ACTIVEPARTNERS',x.Active);
622: FND_MESSAGE.SET_TOKEN('INACTIVEPARTNERS',x.InActive);
623: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
624: end loop;
625:
626: if p_OverWrite = 'N' then
627: for x in Get_Unprocessed_Record_Count

Line 883: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' Partner Type Number of Primary Partners');

879:
880: CLOSE Get_Prtnr_Typ_Migrn;
881:
882: END IF;
883: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' Partner Type Number of Primary Partners');
884:
885: FND_MESSAGE.set_name('PV','PV_MIGR_PTNRTYP_COUNT');
886: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
887:

Line 886: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

882: END IF;
883: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' Partner Type Number of Primary Partners');
884:
885: FND_MESSAGE.set_name('PV','PV_MIGR_PTNRTYP_COUNT');
886: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
887:
888: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
889:
890: for x in Get_Primary_Partner_Type_count

Line 888: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

884:
885: FND_MESSAGE.set_name('PV','PV_MIGR_PTNRTYP_COUNT');
886: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
887:
888: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
889:
890: for x in Get_Primary_Partner_Type_count
891: loop
892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || rpad(x.attr_value,62) || ' ' || x.partner_count );

Line 892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || rpad(x.attr_value,62) || ' ' || x.partner_count );

888: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
889:
890: for x in Get_Primary_Partner_Type_count
891: loop
892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || rpad(x.attr_value,62) || ' ' || x.partner_count );
893: end loop;
894:
895: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
896:

Line 895: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

891: loop
892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || rpad(x.attr_value,62) || ' ' || x.partner_count );
893: end loop;
894:
895: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
896:
897: FND_MESSAGE.set_name('PV','PV_MIGR_FOOTER');
898: FND_MESSAGE.SET_TOKEN('PROCESSED',lpad(l_processed_count,5));
899: FND_MESSAGE.SET_TOKEN('UNPROCESSED',lpad(l_unprocessed_count,5));

Line 902: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

898: FND_MESSAGE.SET_TOKEN('PROCESSED',lpad(l_processed_count,5));
899: FND_MESSAGE.SET_TOKEN('UNPROCESSED',lpad(l_unprocessed_count,5));
900: FND_MESSAGE.SET_TOKEN('ENDDATE',TO_char(SYSDATE,'MM/DD/YYYY hh:mm:ss'));
901:
902: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
903:
904: if p_Running_Mode = 'EVALUATION' then
905: ROLLBACK TO migrate_partner_type;
906: else

Line 917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLERRM: ' || SQLERRM);

913: FND_MESSAGE.SET_NAME('PV', 'PV_MIGR_ERROR');
914: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
915: errbuf := FND_MESSAGE.get;
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;

Line 919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');

915: errbuf := FND_MESSAGE.get;
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:

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: