DBA Data[Home] [Help]

APPS.MSC_WS_OTM_BPEL dependencies on FND_PROFILE

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

165: and msc_supplies.order_type in (1, 11);
166:
167:
168: begin
169: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
170: userId := fnd_global.User_id();
171:
172:
173: OPEN lookUpSupplies(lineLocationId, srInstanceId);

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

241: ---- TO BE DONE
242: -- READ PROFILE FOR IF TO GENERATE EXCEPTIONS OR NOT
243:
244:
245: profile_exceptions := fnd_profile.value('MSC_WS_OTM_GEN_EXC_CP');
246: if ( profile_exceptions = 1) then
247: -- GENERATE EXCEPTIONS
248: req_id := fnd_request.submit_request('MSC','MSCXNETG','Exception Manager',NULL, false,
249: 'Y', /*p_early_order*/

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

351: begin
352: AppsInit;
353:
354:
355: --plan_id := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
356: plan_id := GetProfilePlanId();
357:
358: if ( plan_Id = -3 ) then -- planId is NONE
359: status := 'No Plan to Update.';

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

388: end if;
389:
390: AppsInit;
391:
392: --plan_id := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
393: plan_id := GetProfilePlanId();
394:
395: if ( plan_Id = -3 ) then -- planId is NONE
396: status := 'No Plan to Update.';

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

426: planId NUMBER :=0;
427:
428: begin
429:
430: --planId := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
431: planId := GetProfilePlanId();
432:
433: if ( planId <> -2) then -- not ALL, but just single value
434: if (order_type = 1) then

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

1009: v_temp NUMBER :=0;
1010: userId NUMBER :=0;
1011: begin
1012:
1013: --dbms_output.put_line(fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM'));
1014:
1015: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId
1016: from msc_transportation_updates
1017: where TRANS_UPDATE_ID = transId;

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

1180: v_temp NUMBER :=0;
1181: userId NUMBER :=0;
1182: begin
1183:
1184: --dbms_output.put_line(fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM'));
1185:
1186:
1187:
1188: select UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID into newArrivalDate, SrInstanceId

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

1377: --dbms_output.put_line(locationLineId);
1378:
1379: d1 := to_date(pnewArrivalDate, 'YYYY/MM/DD HH24:MI:SS');
1380: --dbms_output.put_line('d1 = ' || d1);
1381: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1382:
1383: select count(1) into nCount
1384: from MSC_TRANSPORTATION_UPDATES
1385: where OTM_RELEASE_LINE_GID = ReleaseLineGid;

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

1451:
1452: --dbms_output.put_line('count = '|| nCount);
1453: --dbms_output.put_line('ReleaseLineGid = '|| '<' || ReleaseLineGid || '>');
1454:
1455: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1456:
1457: if ( nCount =0 ) then
1458: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1459:

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

1512: status := 'NO_NOTIFICATION_TO_BE_SEND';
1513: return;
1514: end if;
1515:
1516: if fnd_profile.value('MSC_GEN_NOTIFICATION_FOR_OTM') = 2 then
1517: status := 'NOTIFICATION_NOT_ALLOWED_BY PROFILE_OPTION';
1518: return;
1519: end if;
1520:

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

1616: userId NUMBER :=0;
1617: respId NUMBER :=0;
1618: appId NUMBER :=0;
1619: begin
1620: userId := fnd_profile.value('MSC_WS_OTM_USERID');
1621: respId := fnd_profile.value('MSC_WS_OTM_RESPID');
1622: if ( respId = 0) then
1623: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1624: end if;

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

1617: respId NUMBER :=0;
1618: appId NUMBER :=0;
1619: begin
1620: userId := fnd_profile.value('MSC_WS_OTM_USERID');
1621: respId := fnd_profile.value('MSC_WS_OTM_RESPID');
1622: if ( respId = 0) then
1623: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1624: end if;
1625: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;

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

1619: begin
1620: userId := fnd_profile.value('MSC_WS_OTM_USERID');
1621: respId := fnd_profile.value('MSC_WS_OTM_RESPID');
1622: if ( respId = 0) then
1623: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1624: end if;
1625: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;
1626: fnd_global.apps_initialize(userId, respId, appId);
1627:

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

1632:
1633: function GetProfilePlanId return NUMBER is
1634: planId NUMBER :=0;
1635: begin
1636: planId := fnd_profile.value('MSC_PROD_PLAN_ID_FOR_OTM_UPDATES');
1637: return planId;
1638:
1639: EXCEPTION when others then
1640: return 0;

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

1657: --server from OTM: Servlet URI
1658: --pk = DOMAIN.OTM_RELEASE_GID
1659: -- where DOMAIN taken from OTM: Domain Name
1660:
1661: strTemp := fnd_profile.value('MSC_OTM_PUNCHOUT_URI');
1662: lg := LENGTH(strTemp);
1663:
1664: t1 := substr(strTemp, lg , lg) ;
1665:

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

1670: end if;
1671:
1672: v_Http := t2
1673: ||'/GC3/OrderReleaseCustManagement' || '?management_action=view'||'&'||'manager_layout_gid=ORDER_RELEASE_VIEW'||'&'||'pk='
1674: || fnd_profile.value('WSH_OTM_DOMAIN_NAME')
1675: || '.'
1676: || otmReleaseGid;
1677:
1678: return v_Http;