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

Line 489: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);

485: exception
486: when others then
487: l_real_name := null;
488: end;
489: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);
490: --dbms_output.put_line('start 1');
491: wfStart(wf_type,
492: wf_key,
493: wf_process,

Line 601: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql----------------inside else part l_oem_site_id'|| l_oem_site_id);

597: select decode(t_supplier_id(j),1,t_supplier_site_id(j),t_customer_site_id(j))
598: into l_oem_site_id
599: from dual;
600:
601: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql----------------inside else part l_oem_site_id'|| l_oem_site_id);
602:
603: open partner_con_by_site_c(t_company_id(j), t_company_site_id(j),l_oem_site_id,t_item_id(j));
604: ELSE
605: open partner_con_by_site_c1(t_company_id(j), t_company_site_id(j));

Line 644: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);

640: when others then
641: l_real_name := null;
642: end;
643:
644: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);
645: --dbms_output.put_line('start 2');
646:
647: wfStart(wf_type,
648: wf_key,

Line 762: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql*************inside else part supplier id'||t_supplier_id(j) ||' customer_id'|| t_customer_id(j)||' company id'|| t_company_id(j) ||' item id '|| t_item_id(j));

758: l_exist :=0;
759: END;
760: END;
761:
762: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql*************inside else part supplier id'||t_supplier_id(j) ||' customer_id'|| t_customer_id(j)||' company id'|| t_company_id(j) ||' item id '|| t_item_id(j));
763:
764:
765: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql***************inside else part l_independent'|| l_independent);
766:

Line 765: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql***************inside else part l_independent'|| l_independent);

761:
762: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql*************inside else part supplier id'||t_supplier_id(j) ||' customer_id'|| t_customer_id(j)||' company id'|| t_company_id(j) ||' item id '|| t_item_id(j));
763:
764:
765: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql***************inside else part l_independent'|| l_independent);
766:
767:
768: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql***************inside else part l_exist'|| l_exist);
769:

Line 768: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql***************inside else part l_exist'|| l_exist);

764:
765: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql***************inside else part l_independent'|| l_independent);
766:
767:
768: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After the sql***************inside else part l_exist'|| l_exist);
769:
770: IF l_exist = 1 THEN
771: IF l_independent = 0 THEN
772: select decode(t_supplier_id(j),1,t_supplier_site_id(j),t_customer_site_id(j))

Line 815: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);

811: exception
812: when others then
813: l_real_name := null;
814: end;
815: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);
816: --dbms_output.put_line('start 3');
817:
818: wfStart(wf_type,
819: wf_key,

Line 882: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total WF notifications inserted: ' || l_inserted_record);

878:
879: end loop;
880:
881:
882: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total WF notifications inserted: ' || l_inserted_record);
883:
884:
885:
886: --Reset the records for which the workflows have been

Line 1684: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch order forecast notification');

1680:
1681:
1682: select msc_cl_refresh_s.nextval into l_next_number from dual;
1683: IF (p_publish_program_type = G_ORDER_FORECAST) THEN
1684: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch order forecast notification');
1685: FND_FILE.PUT_LINE(FND_FILE.LOG,'Designator ' || p_designator || ' version ' || p_version);
1686:
1687: open wf_publish_of_notify_c( p_designator,
1688: p_version,

Line 1685: FND_FILE.PUT_LINE(FND_FILE.LOG,'Designator ' || p_designator || ' version ' || p_version);

1681:
1682: select msc_cl_refresh_s.nextval into l_next_number from dual;
1683: IF (p_publish_program_type = G_ORDER_FORECAST) THEN
1684: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch order forecast notification');
1685: FND_FILE.PUT_LINE(FND_FILE.LOG,'Designator ' || p_designator || ' version ' || p_version);
1686:
1687: open wf_publish_of_notify_c( p_designator,
1688: p_version,
1689: p_horizon_start,

Line 1720: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF OF record fetched:= ' || t_company_id.COUNT);

1716: t_customer_site_name;
1717:
1718: CLOSE wf_publish_of_notify_c;
1719:
1720: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF OF record fetched:= ' || t_company_id.COUNT);
1721: --dbms_output.put_line('wf count ' || t_company_id.COUNT);
1722: IF (t_company_id is not null and t_company_id.COUNT > 0) THEN
1723:
1724: FOR j in 1 .. t_company_id.COUNT

Line 1726: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: Loop supp ' || t_supplier_id(j) || ' sup site ' || t_supplier_site_id(j));

1722: IF (t_company_id is not null and t_company_id.COUNT > 0) THEN
1723:
1724: FOR j in 1 .. t_company_id.COUNT
1725: LOOP
1726: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: Loop supp ' || t_supplier_id(j) || ' sup site ' || t_supplier_site_id(j));
1727: --dbms_output.put_line('Loop sup company ' || t_supplier_id(j) || ' sup site ' || t_supplier_site_id(j));
1728: /*--------------------------------------------------------------------
1729: append item
1730: --------------------------------------------------------------------*/

Line 1794: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);

1790: exception
1791: when others then
1792: l_real_name := null;
1793: end;
1794: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);
1795: /**
1796: dbms_output.put_line('start workflow process');
1797: dbms_output.put_line('user ' || l_real_name);
1798: dbms_output.put_line('company ' || t_company_name(j));

Line 1805: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending notification ');

1801: dbms_output.put_line('designator ' || p_designator);
1802: -- dbms_output.put_line('item ' || l_item_name);
1803: **/
1804:
1805: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending notification ');
1806:
1807:
1808: -- create a Workflow process for the (item/org/supplier)
1809: wf_engine.CreateProcess

Line 1917: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF SC record fetched:= ' || t_company_id.COUNT);

1913: t_customer_site_name;
1914:
1915: CLOSE wf_publish_sc_notify_c;
1916:
1917: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF SC record fetched:= ' || t_company_id.COUNT);
1918: --dbms_output.put_line('wf count ' || t_company_id.COUNT);
1919: IF (t_company_id is not null and t_company_id.COUNT > 0) THEN
1920:
1921: FOR j in 1 .. t_company_id.COUNT

Line 1923: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WF: Loop cust ' || t_customer_id(j) || ' cust site ' || t_customer_site_id(j));

1919: IF (t_company_id is not null and t_company_id.COUNT > 0) THEN
1920:
1921: FOR j in 1 .. t_company_id.COUNT
1922: LOOP
1923: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WF: Loop cust ' || t_customer_id(j) || ' cust site ' || t_customer_site_id(j));
1924: --dbms_output.put_line('Loop cust company ' || t_customer_id(j) || ' cust site ' || t_customer_site_id(j));
1925: /*--------------------------------------------------------------------
1926: append item
1927: --------------------------------------------------------------------*/

Line 1991: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);

1987: when others then
1988: l_real_name := null;
1989: end;
1990:
1991: FND_FILE.PUT_LINE(FND_FILE.LOG,'WF: user ' || l_real_name);
1992: /*
1993: dbms_output.put_line('start workflow process');
1994: dbms_output.put_line('user ' || l_real_name);
1995: dbms_output.put_line('company ' || t_company_name(j));

Line 2001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending notification ');

1997: dbms_output.put_line('version' || p_version);
1998: dbms_output.put_line('designator ' || p_designator);
1999: -- dbms_output.put_line('item ' || l_item_name);
2000: */
2001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending notification ');
2002:
2003:
2004: -- create a Workflow process for the (item/org/supplier)
2005: wf_engine.CreateProcess

Line 2083: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in msc_x_wfnotify_pkg.Launch_Publish_WF ' || sqlerrm);

2079: when others then
2080: wf_core.context('msc_wfnotify_pub', 'wfStart',
2081: l_wf_type, l_wf_key);
2082:
2083: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in msc_x_wfnotify_pkg.Launch_Publish_WF ' || sqlerrm);
2084: raise;
2085:
2086: END Launch_Publish_WF;
2087: