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.AS_PIPELINE_MOVE_PUB dependencies on FND_FILE

Line 144: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: From Salesforce/salesgroup do not match.');

140: ERRBUF := 'Error at Pipeline Movement '||SQLERRM||' - (Error in group info)';
141: END;
142: IF from_is_group_correct = 0 OR to_is_group_correct = 0 THEN
143: BEGIN
144: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: From Salesforce/salesgroup do not match.');
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END;
147: END IF;
148: IF from_res = to_res AND from_group_id = to_group_id THEN

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: From Resource And To Resource cannot be identical.');

146: END;
147: END IF;
148: IF from_res = to_res AND from_group_id = to_group_id THEN
149: BEGIN
150: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: From Resource And To Resource cannot be identical.');
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END;
153: END IF;
154: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start pipeline movement');

Line 154: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start pipeline movement');

150: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: From Resource And To Resource cannot be identical.');
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END;
153: END IF;
154: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start pipeline movement');
155:
156: from_win_prob := NVL(p_from_win_prob,0);
157: to_win_prob := NVL(p_to_win_prob,100);
158: from_close_date := NVL(p_from_close_date,to_date('01/01/1900','DD/MM/YYYY'));

Line 182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status : ' || status_str);

178: WHEN OTHERS THEN
179: ERRBUF := 'Error at Pipeline Movement '||SQLERRM||' - (Error in determining input value of STATUS)';
180: END;
181: END IF;
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status : ' || status_str);
183: BEGIN
184: -- ** LOOP THRO ALL LEADS THAT SATISFY INPUT CRITERIA *
185: -- dbms_output.put_line('Status is:'|| status_str);
186: sqlstr := ' SELECT LD.LEAD_ID lead_id ';

Line 351: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finish pipeline movement');

347: END;
348: END IF;
349: END LOOP; -- End Loop for Leads
350: END;
351: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finish pipeline movement');
352: --dbms_output.put_line('Finish pipeline movement');
353: COMMIT;
354: EXCEPTION
355: WHEN OTHERS THEN

Line 419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start pipeline movement');

415: st_count NUMBER := 1;
416: ld_status status_tbl;
417: i_count NUMBER := 1;
418: BEGIN
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start pipeline movement');
420: -- get salesforce_id from user_name --
421: open get_id(p_from_user);
422: fetch get_id into from_person, from_sf_id;
423: close get_id;

Line 440: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: From Salesforce/salesgroup do not match.');

436: open check_grp_id(from_sf_id, from_sg_id);
437: fetch check_grp_id into group_ok;
438: close check_grp_id;
439: if(group_ok = 0) then
440: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: From Salesforce/salesgroup do not match.');
441: error_flag := 'Y';
442: end if;
443: group_ok := 0;
444: open check_grp_id(to_sf_id, to_sg_id);

Line 448: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: To Salesforce/salesgroup do not match.');

444: open check_grp_id(to_sf_id, to_sg_id);
445: fetch check_grp_id into group_ok;
446: close check_grp_id;
447: if(group_ok = 0) then
448: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: To Salesforce/salesgroup do not match.');
449: error_flag := 'Y';
450: end if;
451: group_ok := 0;
452: from_win_prob := nvl(p_from_win_prob,0);

Line 477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status : ALL');

473: st_len := nvl(length(allstatus),0);
474: -- nothing type in for status, default to 'ALL'
475: if(st_len = 0) then
476: ld_status(st_count).status := 'ALL';
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status : ALL');
478: else
479: -- specify only one status, maybe 'ALL', maybe others
480: if(instr(allstatus,',') = 0) then
481: ld_status(st_count).status := allstatus;

Line 482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);

478: else
479: -- specify only one status, maybe 'ALL', maybe others
480: if(instr(allstatus,',') = 0) then
481: ld_status(st_count).status := allstatus;
482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);
483: -- more than 1 status specified
484: else
485: ld_status(st_count).status := ltrim(rtrim(substr(allstatus,1,instr(allstatus,',')-1)));
486: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);

Line 486: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);

482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);
483: -- more than 1 status specified
484: else
485: ld_status(st_count).status := ltrim(rtrim(substr(allstatus,1,instr(allstatus,',')-1)));
486: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);
487: --dbms_output.put_line('Status : '||ld_status(st_count).status);
488: allstatus := ltrim(rtrim(substr(allstatus,instr(allstatus,',')+1,st_len)));
489: st_count := st_count + 1;
490: while (instr(allstatus,',') <> 0) loop

Line 492: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);

488: allstatus := ltrim(rtrim(substr(allstatus,instr(allstatus,',')+1,st_len)));
489: st_count := st_count + 1;
490: while (instr(allstatus,',') <> 0) loop
491: ld_status(st_count).status := ltrim(rtrim(substr(allstatus,1,instr(allstatus,',')-1)));
492: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);
493: --dbms_output.put_line('Status '||st_count||' : '||ld_status(st_count).status);
494: allstatus := ltrim(rtrim(substr(allstatus,instr(allstatus,',')+1,st_len)));
495: st_count := st_count + 1;
496: end loop;

Line 498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);

494: allstatus := ltrim(rtrim(substr(allstatus,instr(allstatus,',')+1,st_len)));
495: st_count := st_count + 1;
496: end loop;
497: ld_status(st_count).status := ltrim(rtrim(allstatus));
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Status '||st_count||' : '||ld_status(st_count).status);
499: --dbms_output.put_line('last Status : '||ld_status(st_count).status);
500: --dbms_output.put_line('Total status : '||st_count);
501: end if;
502: end if;

Line 506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);

502: end if;
503: --DBMS_OUTPUT.PUT_LINE('I AM OUTSIDE');
504: IF(error_flag <> 'Y') THEN
505: IF(rtrim(ltrim(ld_status(1).status)) = 'ALL') THEN
506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
508: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
509: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
510: update AS_SALES_CREDITS sc

Line 507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);

503: --DBMS_OUTPUT.PUT_LINE('I AM OUTSIDE');
504: IF(error_flag <> 'Y') THEN
505: IF(rtrim(ltrim(ld_status(1).status)) = 'ALL') THEN
506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
508: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
509: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
510: update AS_SALES_CREDITS sc
511: set object_version_number = nvl(object_version_number,0) + 1, salesforce_id = to_sf_id,

Line 508: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);

504: IF(error_flag <> 'Y') THEN
505: IF(rtrim(ltrim(ld_status(1).status)) = 'ALL') THEN
506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
508: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
509: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
510: update AS_SALES_CREDITS sc
511: set object_version_number = nvl(object_version_number,0) + 1, salesforce_id = to_sf_id,
512: person_id = to_person,

Line 509: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);

505: IF(rtrim(ltrim(ld_status(1).status)) = 'ALL') THEN
506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
508: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
509: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
510: update AS_SALES_CREDITS sc
511: set object_version_number = nvl(object_version_number,0) + 1, salesforce_id = to_sf_id,
512: person_id = to_person,
513: salesgroup_id = to_sg_id

Line 524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);

520: and sc.salesforce_id = from_sf_id
521: and sc.salesgroup_id = from_sg_id
522: and sc.person_id = from_person;
523: ELSE
524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
525: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
526: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
527: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
528: while (i_count <= st_count) loop

Line 525: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);

521: and sc.salesgroup_id = from_sg_id
522: and sc.person_id = from_person;
523: ELSE
524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
525: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
526: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
527: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
528: while (i_count <= st_count) loop
529: update AS_SALES_CREDITS sc

Line 526: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);

522: and sc.person_id = from_person;
523: ELSE
524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
525: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
526: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
527: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
528: while (i_count <= st_count) loop
529: update AS_SALES_CREDITS sc
530: set object_version_number = nvl(object_version_number,0) + 1, salesforce_id = to_sf_id,

Line 527: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);

523: ELSE
524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
525: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
526: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
527: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
528: while (i_count <= st_count) loop
529: update AS_SALES_CREDITS sc
530: set object_version_number = nvl(object_version_number,0) + 1, salesforce_id = to_sf_id,
531: person_id = to_person,

Line 547: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finish pipeline movement');

543: i_count := i_count + 1;
544: end loop;
545: END IF;
546: END IF;
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finish pipeline movement');
548: EXCEPTION
549: WHEN others THEN
550: ERRBUF := 'Error at Pipeline Movement'||SQLERRM;
551: END Pipeline_SC_Movement;