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_WS_OTM_BPEL dependencies on FND_PROFILE

Line 160: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');

156: userId NUMBER :=0;
157:
158:
159: begin
160: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
161: userId := fnd_global.User_id();
162:
163:
164: SELECT distinct order_number, purch_line_num, order_type

Line 235: profile_exceptions := fnd_profile.value('MSC_WS_OTM_GEN_EXC_CP');

231: ---- TO BE DONE
232: -- READ PROFILE FOR IF TO GENERATE EXCEPTIONS OR NOT
233:
234:
235: profile_exceptions := fnd_profile.value('MSC_WS_OTM_GEN_EXC_CP');
236: if ( profile_exceptions = 1) then
237: -- GENERATE EXCEPTIONS
238: req_id := fnd_request.submit_request('MSC','MSCXNETG','Exception Manager',NULL, false,
239: 'Y', /*p_early_order*/

Line 330: --plan_id := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');

326: begin
327: AppsInit;
328:
329:
330: --plan_id := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
331: plan_id := GetProfilePlanId();
332:
333: if ( plan_Id = -3 ) then -- planId is NONE
334: status := 'No Plan to Update.';

Line 367: --plan_id := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');

363: end if;
364:
365: AppsInit;
366:
367: --plan_id := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
368: plan_id := GetProfilePlanId();
369:
370: if ( plan_Id = -3 ) then -- planId is NONE
371: status := 'No Plan to Update.';

Line 405: --planId := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');

401: planId NUMBER :=0;
402:
403: begin
404:
405: --planId := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
406: planId := GetProfilePlanId();
407:
408: if ( planId <> -2) then -- not ALL, but just single value
409: if (order_type = 1) then

Line 988: --dbms_output.put_line(fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM'));

984: v_temp NUMBER :=0;
985: userId NUMBER :=0;
986: begin
987:
988: --dbms_output.put_line(fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM'));
989:
990: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId
991: from msc_transportation_updates
992: where TRANS_UPDATE_ID = transId;

Line 1159: --dbms_output.put_line(fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM'));

1155: v_temp NUMBER :=0;
1156: userId NUMBER :=0;
1157: begin
1158:
1159: --dbms_output.put_line(fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM'));
1160:
1161:
1162:
1163: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId

Line 1356: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');

1352: --dbms_output.put_line(locationLineId);
1353:
1354: d1 := to_date(pnewArrivalDate, 'YYYY/MM/DD HH24:MI:SS');
1355: --dbms_output.put_line('d1 = ' || d1);
1356: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1357:
1358: select count(1) into nCount
1359: from MSC_TRANSPORTATION_UPDATES
1360: where OTM_RELEASE_LINE_GID = ReleaseLineGid;

Line 1430: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');

1426:
1427: --dbms_output.put_line('count = '|| nCount);
1428: --dbms_output.put_line('ReleaseLineGid = '|| '<' || ReleaseLineGid || '>');
1429:
1430: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1431:
1432: if ( nCount =0 ) then
1433: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1434:

Line 1491: if fnd_profile.value('MSC_GEN_NOTIFICATION_FOR_OTM') = 2 then

1487: status := 'NO_NOTIFICATION_TO_BE_SEND';
1488: return;
1489: end if;
1490:
1491: if fnd_profile.value('MSC_GEN_NOTIFICATION_FOR_OTM') = 2 then
1492: status := 'NOTIFICATION_NOT_ALLOWED_BY PROFILE_OPTION';
1493: return;
1494: end if;
1495:

Line 1595: userId := fnd_profile.value('MSC_WS_OTM_USERID');

1591: userId NUMBER :=0;
1592: respId NUMBER :=0;
1593: appId NUMBER :=0;
1594: begin
1595: userId := fnd_profile.value('MSC_WS_OTM_USERID');
1596: respId := fnd_profile.value('MSC_WS_OTM_RESPID');
1597: if ( respId = 0) then
1598: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1599: end if;

Line 1596: respId := fnd_profile.value('MSC_WS_OTM_RESPID');

1592: respId NUMBER :=0;
1593: appId NUMBER :=0;
1594: begin
1595: userId := fnd_profile.value('MSC_WS_OTM_USERID');
1596: respId := fnd_profile.value('MSC_WS_OTM_RESPID');
1597: if ( respId = 0) then
1598: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1599: end if;
1600: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;

Line 1598: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');

1594: begin
1595: userId := fnd_profile.value('MSC_WS_OTM_USERID');
1596: respId := fnd_profile.value('MSC_WS_OTM_RESPID');
1597: if ( respId = 0) then
1598: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1599: end if;
1600: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;
1601: fnd_global.apps_initialize(userId, respId, appId);
1602:

Line 1611: planId := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');

1607:
1608: function GetProfilePlanId return NUMBER is
1609: planId NUMBER :=0;
1610: begin
1611: planId := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
1612: return planId;
1613:
1614: EXCEPTION when others then
1615: return 0;

Line 1636: strTemp := fnd_profile.value('MSC_OTM_PUNCHOUT_URI');

1632: --server from OTM: Servlet URI
1633: --pk = DOMAIN.OTM_RELEASE_GID
1634: -- where DOMAIN taken from OTM: Domain Name
1635:
1636: strTemp := fnd_profile.value('MSC_OTM_PUNCHOUT_URI');
1637: lg := LENGTH(strTemp);
1638:
1639: t1 := substr(strTemp, lg , lg) ;
1640:

Line 1649: || fnd_profile.value('WSH_OTM_DOMAIN_NAME')

1645: end if;
1646:
1647: v_Http := t2
1648: ||'/GC3/OrderReleaseCustManagement' || '?management_action=view=ORDER_RELEASE_VIEW='
1649: || fnd_profile.value('WSH_OTM_DOMAIN_NAME')
1650: || '.'
1651: || otmReleaseGid;
1652:
1653: return v_Http;