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.FND_PROFILE dependencies on FND_CORE_LOG

Line 110: CORELOG_IS_ENABLED boolean := FND_CORE_LOG.IS_ENABLED;

106: ** Global variable used to identify core logging is enabled or not.
107: ** Added for Bug 5599946: APPSPERF:FND:LOGGING CALLS IN FND_PROFILE CAUSING
108: ** PERFORMANCE REGRESSION
109: */
110: CORELOG_IS_ENABLED boolean := FND_CORE_LOG.IS_ENABLED;
111:
112: /*
113: ** Global variable that stores Applications Release Version
114: */

Line 131: FND_CORE_LOG.WRITE_PROFILE(

127: LOG_ORG_ID in number default PROFILES_ORG_ID,
128: LOG_SERVER_ID in number default PROFILES_SERVER_ID)
129: is
130: begin
131: FND_CORE_LOG.WRITE_PROFILE(
132: LOG_PROFNAME,
133: LOG_PROFVAL,
134: CURRENT_API,
135: LOG_USER_ID,

Line 845: FND_CORE_LOG.PUT_LINE(name_z,PROFILE_OPTION_ID||':'||

841: ||':'||name_z||':'||PROFILE_OPTION_NAME,
842: user_id_z,responsibility_id_z,application_id_z,org_id_z,
843: server_id_z);
844: -- Log profile definition
845: FND_CORE_LOG.PUT_LINE(name_z,PROFILE_OPTION_ID||':'||
846: PROFILE_AID||':'||SITE_ENABLED||':'||APP_ENABLED||':'||
847: RESP_ENABLED||':'||USER_ENABLED||':'||ORG_ENABLED||':'||
848: SERVER_ENABLED||':'||SERVRESP_ENABLED||':'||HIERARCHY||':'||USER_CHANGEABLE);
849: end if;

Line 882: FND_CORE_LOG.PUT_LINE(name_z,'UL Sec in FP.GSD');

878: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
879: (level_id_z = 10004)) then
880:
881: if CORELOG_IS_ENABLED then
882: FND_CORE_LOG.PUT_LINE(name_z,'UL Sec in FP.GSD');
883: end if;
884: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10004,
885: user_id_z,NULL,val_z,defined_z);
886:

Line 906: FND_CORE_LOG.PUT_LINE(name_z,'RL Sec in FP.GSD');

902: (HIERARCHY = 'SECURITY' and RESP_ENABLED = 'Y') and
903: (level_id_z = 10003)) then
904:
905: if CORELOG_IS_ENABLED then
906: FND_CORE_LOG.PUT_LINE(name_z,'RL Sec in FP.GSD');
907: end if;
908: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10003,
909: nvl(responsibility_id_z,PROFILES_RESP_ID),
910: nvl(application_id_z,PROFILES_APPL_ID),val_z,defined_z);

Line 931: FND_CORE_LOG.PUT_LINE(name_z,'AL Sec in FP.GSD');

927: (HIERARCHY = 'SECURITY' and APP_ENABLED = 'Y') and
928: (level_id_z = 10002)) then
929:
930: if CORELOG_IS_ENABLED then
931: FND_CORE_LOG.PUT_LINE(name_z,'AL Sec in FP.GSD');
932: end if;
933: get_specific_level_db (PROFILE_OPTION_ID,PROFILE_AID,10002,
934: application_id_z,NULL,val_z,defined_z);
935:

Line 961: FND_CORE_LOG.PUT_LINE(name_z,'SL Sec in FP.GSD');

957: (SITE_ENABLED = 'Y') and
958: (level_id_z = 10001)) then
959:
960: if CORELOG_IS_ENABLED then
961: FND_CORE_LOG.PUT_LINE(name_z,'SL Sec in FP.GSD');
962: end if;
963: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10001,0,NULL,
964: val_z,defined_z);
965:

Line 985: FND_CORE_LOG.PUT_LINE(name_z,'UL Org in FP.GSD');

981: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
982: (level_id_z = 10004)) then
983:
984: if CORELOG_IS_ENABLED then
985: FND_CORE_LOG.PUT_LINE(name_z,'UL Org in FP.GSD');
986: end if;
987: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10004,
988: user_id_z,NULL,val_z,defined_z);
989:

Line 1009: FND_CORE_LOG.PUT_LINE(name_z,'OL Org in FP.GSD');

1005: (HIERARCHY = 'ORG' and ORG_ENABLED ='Y') and
1006: (level_id_z = 10006)) then
1007:
1008: if CORELOG_IS_ENABLED then
1009: FND_CORE_LOG.PUT_LINE(name_z,'OL Org in FP.GSD');
1010: end if;
1011: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10006,org_id_z,
1012: NULL,val_z,defined_z);
1013:

Line 1032: FND_CORE_LOG.PUT_LINE(name_z,'SL Org in FP.GSD');

1028: if (HIERARCHY = 'ORG' and SITE_ENABLED = 'Y' and
1029: level_id_z = 10001) then
1030:
1031: if CORELOG_IS_ENABLED then
1032: FND_CORE_LOG.PUT_LINE(name_z,'SL Org in FP.GSD');
1033: end if;
1034: get_specific_level_db (PROFILE_OPTION_ID,PROFILE_AID,10001,0,NULL,
1035: val_z,defined_z);
1036:

Line 1056: FND_CORE_LOG.PUT_LINE(name_z,'UL Server in FP.GSD');

1052: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
1053: (level_id_z = 10004)) then
1054:
1055: if CORELOG_IS_ENABLED then
1056: FND_CORE_LOG.PUT_LINE(name_z,'UL Server in FP.GSD');
1057: end if;
1058: get_specific_level_db (PROFILE_OPTION_ID,PROFILE_AID,10004,
1059: user_id_z,NULL,val_z,defined_z);
1060:

Line 1081: FND_CORE_LOG.PUT_LINE(name_z,'SRVL Server in FP.GSD');

1077: (HIERARCHY = 'SERVER' and SERVER_ENABLED ='Y') and
1078: (level_id_z = 10005))then
1079:
1080: if CORELOG_IS_ENABLED then
1081: FND_CORE_LOG.PUT_LINE(name_z,'SRVL Server in FP.GSD');
1082: end if;
1083: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10005,
1084: server_id_z,NULL,val_z,defined_z);
1085:

Line 1104: FND_CORE_LOG.PUT_LINE(name_z,'SL Server in FP.GSD');

1100: if (HIERARCHY = 'SERVER' and SITE_ENABLED ='Y' and
1101: level_id_z = 10001) then
1102:
1103: if CORELOG_IS_ENABLED then
1104: FND_CORE_LOG.PUT_LINE(name_z,'SL Server in FP.GSD');
1105: end if;
1106: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10001,0,NULL,
1107: val_z,defined_z);
1108:

Line 1128: FND_CORE_LOG.PUT_LINE(name_z,'UL ServResp in FP.GSD');

1124: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
1125: (level_id_z = 10004)) then
1126:
1127: if CORELOG_IS_ENABLED then
1128: FND_CORE_LOG.PUT_LINE(name_z,'UL ServResp in FP.GSD');
1129: end if;
1130: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10004,
1131: user_id_z,NULL,val_z,defined_z);
1132:

Line 1168: FND_CORE_LOG.PUT_LINE(name_z,'ServRespL ServResp in FP.GSD');

1164: -- deliberately coded depending on precedence.
1165: --
1166:
1167: if CORELOG_IS_ENABLED then
1168: FND_CORE_LOG.PUT_LINE(name_z,'ServRespL ServResp in FP.GSD');
1169: end if;
1170:
1171: -- Responsibility ID and Server ID
1172: if (responsibility_id_z <> -1 and server_id_z <> -1) then

Line 1291: FND_CORE_LOG.PUT_LINE(name_z,'SL ServResp in FP.GSD');

1287: if (HIERARCHY = 'SERVRESP' and SITE_ENABLED ='Y' and
1288: level_id_z = 10001) then
1289:
1290: if CORELOG_IS_ENABLED then
1291: FND_CORE_LOG.PUT_LINE(name_z,'SL ServResp in FP.GSD');
1292: end if;
1293: get_specific_level_db(PROFILE_OPTION_ID,PROFILE_AID,10001,0,NULL,
1294: val_z,defined_z);
1295:

Line 1478: FND_CORE_LOG.PUT_LINE(name_z,PROFILE_OPTION_ID||':'||

1474: application_id_z,
1475: org_id_z,
1476: server_id_z);
1477: -- Log profile definition
1478: FND_CORE_LOG.PUT_LINE(name_z,PROFILE_OPTION_ID||':'||
1479: PROFILE_AID||':'||SITE_ENABLED||':'||APP_ENABLED||':'||
1480: RESP_ENABLED||':'||USER_ENABLED||':'||ORG_ENABLED||':'||
1481: SERVER_ENABLED||':'||SERVRESP_ENABLED||':'||HIERARCHY||':'||
1482: USER_CHANGEABLE);

Line 1520: FND_CORE_LOG.PUT_LINE(name_z,'UL Sec in FP.GSDW');

1516: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
1517: (level_id_z = 10004)) then
1518:
1519: if CORELOG_IS_ENABLED then
1520: FND_CORE_LOG.PUT_LINE(name_z,'UL Sec in FP.GSDW');
1521: end if;
1522: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10004,nvl(user_id_z,
1523: PROFILES_USER_ID));
1524: fetch value_uas into val_z;

Line 1553: FND_CORE_LOG.PUT_LINE(name_z,'RL Sec in FP.GSDW');

1549: if ((responsibility_id_z <> -1) and (HIERARCHY = 'SECURITY'
1550: and RESP_ENABLED = 'Y') and (level_id_z = 10003)) then
1551:
1552: if CORELOG_IS_ENABLED then
1553: FND_CORE_LOG.PUT_LINE(name_z,'RL Sec in FP.GSDW');
1554: end if;
1555: open value_resp(PROFILE_OPTION_ID,PROFILE_AID,
1556: nvl(responsibility_id_z,PROFILES_RESP_ID),
1557: nvl(application_id_z,PROFILES_APPL_ID));

Line 1587: FND_CORE_LOG.PUT_LINE(name_z,'AL Sec in FP.GSDW');

1583: if ((application_id_z <> -1) and (HIERARCHY = 'SECURITY'
1584: and APP_ENABLED = 'Y') and (level_id_z = 10002)) then
1585:
1586: if CORELOG_IS_ENABLED then
1587: FND_CORE_LOG.PUT_LINE(name_z,'AL Sec in FP.GSDW');
1588: end if;
1589: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10002,
1590: nvl(application_id_z,PROFILES_APPL_ID));
1591: fetch value_uas into val_z;

Line 1626: FND_CORE_LOG.PUT_LINE(name_z,'SL Sec in FP.GSDW');

1622: if (HIERARCHY = 'SECURITY' and SITE_ENABLED = 'Y' and
1623: level_id_z = 10001) then
1624:
1625: if CORELOG_IS_ENABLED then
1626: FND_CORE_LOG.PUT_LINE(name_z,'SL Sec in FP.GSDW');
1627: end if;
1628: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10001,0);
1629: fetch value_uas into val_z;
1630: if (value_uas%NOTFOUND) then

Line 1658: FND_CORE_LOG.PUT_LINE(name_z,'UL Org in FP.GSDW');

1654: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
1655: (level_id_z = 10004)) then
1656:
1657: if CORELOG_IS_ENABLED then
1658: FND_CORE_LOG.PUT_LINE(name_z,'UL Org in FP.GSDW');
1659: end if;
1660: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10004,nvl(user_id_z,
1661: PROFILES_USER_ID));
1662: fetch value_uas into val_z;

Line 1691: FND_CORE_LOG.PUT_LINE(name_z,'OL Org in FP.GSDW');

1687: if ((org_id_z <> -1) and (HIERARCHY = 'ORG' and ORG_ENABLED ='Y')
1688: and (level_id_z = 10006)) then
1689:
1690: if CORELOG_IS_ENABLED then
1691: FND_CORE_LOG.PUT_LINE(name_z,'OL Org in FP.GSDW');
1692: end if;
1693: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10006,
1694: nvl(org_id_z,PROFILES_ORG_ID));
1695: fetch value_uas into val_z;

Line 1724: FND_CORE_LOG.PUT_LINE(name_z,'SL Org in FP.GSDW');

1720: if (HIERARCHY = 'ORG' and SITE_ENABLED = 'Y' and
1721: level_id_z = 10001) then
1722:
1723: if CORELOG_IS_ENABLED then
1724: FND_CORE_LOG.PUT_LINE(name_z,'SL Org in FP.GSDW');
1725: end if;
1726: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10001,0);
1727: fetch value_uas into val_z;
1728: if (value_uas%NOTFOUND) then

Line 1757: FND_CORE_LOG.PUT_LINE(name_z,'UL Server in FP.GSDW');

1753: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
1754: (level_id_z = 10004)) then
1755:
1756: if CORELOG_IS_ENABLED then
1757: FND_CORE_LOG.PUT_LINE(name_z,'UL Server in FP.GSDW');
1758: end if;
1759: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10004,nvl(user_id_z,
1760: PROFILES_USER_ID));
1761: fetch value_uas into val_z;

Line 1791: FND_CORE_LOG.PUT_LINE(name_z,'SRVL Server in FP.GSDW');

1787: (HIERARCHY = 'SERVER' and SERVER_ENABLED ='Y') and
1788: (level_id_z = 10005)) then
1789:
1790: if CORELOG_IS_ENABLED then
1791: FND_CORE_LOG.PUT_LINE(name_z,'SRVL Server in FP.GSDW');
1792: end if;
1793: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10005,nvl(server_id_z,
1794: PROFILES_SERVER_ID));
1795: fetch value_uas into val_z;

Line 1824: FND_CORE_LOG.PUT_LINE(name_z,'SL Server in FP.GSDW');

1820: if (HIERARCHY = 'SERVER' and SITE_ENABLED ='Y' and
1821: level_id_z = 10001) then
1822:
1823: if CORELOG_IS_ENABLED then
1824: FND_CORE_LOG.PUT_LINE(name_z,'SL Server in FP.GSDW');
1825: end if;
1826: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10001,0);
1827: fetch value_uas into val_z;
1828: if (value_uas%NOTFOUND) then

Line 1857: FND_CORE_LOG.PUT_LINE(name_z,'UL ServResp in FP.GSDW');

1853: ((USER_ENABLED ='Y') or (USER_CHANGEABLE='Y')) and -- Bug 4257739
1854: (level_id_z = 10004)) then
1855:
1856: if CORELOG_IS_ENABLED then
1857: FND_CORE_LOG.PUT_LINE(name_z,'UL ServResp in FP.GSDW');
1858: end if;
1859: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10004,nvl(user_id_z,
1860: PROFILES_USER_ID));
1861: fetch value_uas into val_z;

Line 1890: FND_CORE_LOG.PUT_LINE(name_z,'ServRespL ServResp in FP.GSDW');

1886: if (HIERARCHY = 'SERVRESP' and SERVRESP_ENABLED = 'Y' and
1887: level_id_z = 10007) then
1888: -- Responsibility and Server
1889: if CORELOG_IS_ENABLED then
1890: FND_CORE_LOG.PUT_LINE(name_z,'ServRespL ServResp in FP.GSDW');
1891: end if;
1892: if (responsibility_id_z <> -1 and server_id_z <> -1) then
1893: if CORELOG_IS_ENABLED then
1894: FND_CORE_LOG.PUT_LINE('ServRespL:R <> -1 and S <> -1');

Line 1894: FND_CORE_LOG.PUT_LINE('ServRespL:R <> -1 and S <> -1');

1890: FND_CORE_LOG.PUT_LINE(name_z,'ServRespL ServResp in FP.GSDW');
1891: end if;
1892: if (responsibility_id_z <> -1 and server_id_z <> -1) then
1893: if CORELOG_IS_ENABLED then
1894: FND_CORE_LOG.PUT_LINE('ServRespL:R <> -1 and S <> -1');
1895: end if;
1896: open value_servresp(PROFILE_OPTION_ID,PROFILE_AID,
1897: nvl(responsibility_id_z,PROFILES_RESP_ID),
1898: nvl(application_id_z,PROFILES_APPL_ID),

Line 1925: FND_CORE_LOG.PUT_LINE('ServRespL:R <> -1 and S = -1');

1921: end if; -- value_servresp%NOTFOUND
1922: -- Responsibility and -1 for Server
1923: elsif (responsibility_id_z <> -1 and server_id_z = -1) then
1924: if CORELOG_IS_ENABLED then
1925: FND_CORE_LOG.PUT_LINE('ServRespL:R <> -1 and S = -1');
1926: end if;
1927: open value_servresp(PROFILE_OPTION_ID,PROFILE_AID,
1928: nvl(responsibility_id_z,PROFILES_RESP_ID),
1929: nvl(application_id_z,PROFILES_APPL_ID),

Line 1956: FND_CORE_LOG.PUT_LINE('ServRespL:R = -1 and S <> -1');

1952: end if; -- value_servresp%NOTFOUND
1953: -- Server and -1 for Responsibility
1954: elsif (server_id_z <> -1 and responsibility_id_z = -1) then
1955: if CORELOG_IS_ENABLED then
1956: FND_CORE_LOG.PUT_LINE('ServRespL:R = -1 and S <> -1');
1957: end if;
1958: open value_servresp(PROFILE_OPTION_ID,PROFILE_AID,
1959: -1,
1960: -1,

Line 1995: FND_CORE_LOG.PUT_LINE(name_z,'SL ServResp in FP.GSDW');

1991: -- SITE level with Server hierarchy
1992: if (HIERARCHY = 'SERVRESP' and SITE_ENABLED ='Y' and
1993: level_id_z = 10001) then
1994: if CORELOG_IS_ENABLED then
1995: FND_CORE_LOG.PUT_LINE(name_z,'SL ServResp in FP.GSDW');
1996: end if;
1997: open value_uas(PROFILE_OPTION_ID,PROFILE_AID,10001,0);
1998: fetch value_uas into val_z;
1999: if (value_uas%NOTFOUND) then

Line 3164: FND_CORE_LOG.WRITE_PROFILE_SAVE(

3160:
3161: begin
3162:
3163: if CORELOG_IS_ENABLED then
3164: FND_CORE_LOG.WRITE_PROFILE_SAVE(
3165: X_NAME_UPPER,
3166: nvl(X_VALUE,'NOVAL')||':ENTER',
3167: X_LEVEL_NAME,
3168: X_LEVEL_VALUE,

Line 3235: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, SL');

3231: return FALSE; -- the only site-level allowed is zero.
3232: end if;
3233:
3234: if CORELOG_IS_ENABLED then
3235: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, SL');
3236: end if;
3237:
3238: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3239: ** IF NO CHANGE IS MADE

Line 3253: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, AL');

3249:
3250: x_level_id := 10002;
3251:
3252: if CORELOG_IS_ENABLED then
3253: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, AL');
3254: end if;
3255:
3256: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3257: ** IF NO CHANGE IS MADE

Line 3272: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, RL');

3268:
3269: x_level_id := 10003;
3270:
3271: if CORELOG_IS_ENABLED then
3272: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, RL');
3273: end if;
3274:
3275: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3276: ** IF NO CHANGE IS MADE

Line 3292: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, UL');

3288:
3289: x_level_id := 10004;
3290:
3291: if CORELOG_IS_ENABLED then
3292: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, UL');
3293: end if;
3294:
3295: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3296: ** IF NO CHANGE IS MADE

Line 3311: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, SRVL');

3307:
3308: x_level_id := 10005;
3309:
3310: if CORELOG_IS_ENABLED then
3311: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, SRVL');
3312: end if;
3313:
3314: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3315: ** IF NO CHANGE IS MADE

Line 3330: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, OL');

3326:
3327: x_level_id := 10006;
3328:
3329: if CORELOG_IS_ENABLED then
3330: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, OL');
3331: end if;
3332:
3333: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3334: ** IF NO CHANGE IS MADE

Line 3349: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSDW call FP.S, ServRespL');

3345:
3346: x_level_id := 10007;
3347:
3348: if CORELOG_IS_ENABLED then
3349: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSDW call FP.S, ServRespL');
3350: end if;
3351:
3352: /*
3353: ** Bug 4025399 :3958546:SERVRESP:FND_PROFILE.SAVE RETURNS TRUE BUT

Line 3395: FND_CORE_LOG.WRITE_PROFILE_SAVE(

3391: -- Just return TRUE;
3392: if ((l_profile_option_value = X_VALUE) or
3393: (l_profile_option_value is null) and (X_VALUE is null)) then
3394: if CORELOG_IS_ENABLED then
3395: FND_CORE_LOG.WRITE_PROFILE_SAVE(
3396: X_NAME,
3397: nvl(X_VALUE,'NOVAL')||':EXIT',
3398: X_LEVEL_NAME,
3399: X_LEVEL_VALUE,

Line 3472: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'UL Val cached in USER_TABS');

3468: -- Cache the value in user-level table.
3469: if (x_level_id = 10004 and
3470: profiles_user_id = nvl(x_level_value,profiles_user_id)) then
3471: if CORELOG_IS_ENABLED then
3472: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'UL Val cached in USER_TABS');
3473: end if;
3474: PUT(X_NAME_UPPER,nvl(x_value,FND_UNDEFINED_VALUE),USER_NAME_TAB,
3475: USER_VAL_TAB,hashValue);
3476: end if;

Line 3483: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'RL Val cached in RESP_TABS');

3479: if (x_level_id = 10003 and
3480: profiles_resp_id = nvl(x_level_value,profiles_resp_id) and
3481: profiles_appl_id = nvl(x_level_value_app_id,profiles_appl_id)) then
3482: if CORELOG_IS_ENABLED then
3483: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'RL Val cached in RESP_TABS');
3484: end if;
3485: PUT(X_NAME_UPPER,nvl(x_value,FND_UNDEFINED_VALUE),RESP_NAME_TAB,
3486: RESP_VAL_TAB,hashValue);
3487: end if;

Line 3493: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'AL Val cached in APPL_TABS');

3489: -- Cache the value in appl-level table.
3490: if (x_level_id = 10002 and
3491: profiles_appl_id = nvl(x_level_value,profiles_appl_id)) then
3492: if CORELOG_IS_ENABLED then
3493: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'AL Val cached in APPL_TABS');
3494: end if;
3495: PUT(X_NAME_UPPER,nvl(x_value,FND_UNDEFINED_VALUE),APPL_NAME_TAB,
3496: APPL_VAL_TAB,hashValue);
3497: end if;

Line 3503: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,

3499: -- Cache the value in server-level table.
3500: if (x_level_id = 10005 and
3501: profiles_server_id = nvl(x_level_value,profiles_server_id)) then
3502: if CORELOG_IS_ENABLED then
3503: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,
3504: 'SRVL Val cached in SERVER_TABS');
3505: end if;
3506: PUT(X_NAME_UPPER,nvl(x_value,FND_UNDEFINED_VALUE),SERVER_NAME_TAB,
3507: SERVER_VAL_TAB,hashValue);

Line 3514: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'OL Val cached in ORG_TABS');

3510: -- Cache the value in org-level table.
3511: if (x_level_id = 10006) then
3512: if (profiles_org_id = nvl(x_level_value,profiles_org_id)) then
3513: if CORELOG_IS_ENABLED then
3514: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'OL Val cached in ORG_TABS');
3515: end if;
3516: PUT(X_NAME_UPPER,nvl(x_value,FND_UNDEFINED_VALUE),ORG_NAME_TAB,
3517: ORG_VAL_TAB,hashValue);
3518: end if;

Line 3526: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,

3522: if (x_level_id = 10007 and
3523: profiles_resp_id = nvl(x_level_value,profiles_resp_id) and
3524: profiles_server_id = nvl(x_level_value2,profiles_server_id)) then
3525: if CORELOG_IS_ENABLED then
3526: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,
3527: 'ServRespL Val cached in SERVRESP_TABS');
3528: end if;
3529: PUT(X_NAME_UPPER,nvl(x_value,FND_UNDEFINED_VALUE),SERVRESP_NAME_TAB,
3530: SERVRESP_VAL_TAB,hashValue);

Line 3536: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'SL Val cached in SITE_TABS');

3532:
3533: -- Cache the value in site-level table.
3534: if (x_level_id = 10001) then
3535: if CORELOG_IS_ENABLED then
3536: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'SL Val cached in SITE_TABS');
3537: end if;
3538: PUT(X_NAME_UPPER,nvl(x_value,FND_UNDEFINED_VALUE),SITE_NAME_TAB,
3539: SITE_VAL_TAB,hashValue);
3540: end if;

Line 3560: FND_CORE_LOG.WRITE_PROFILE_SAVE(

3556: end if;
3557:
3558: -- Log API exit
3559: if CORELOG_IS_ENABLED then
3560: FND_CORE_LOG.WRITE_PROFILE_SAVE(
3561: X_NAME,
3562: X_VALUE ||':EXIT',
3563: X_LEVEL_NAME,
3564: X_LEVEL_VALUE,

Line 3940: fnd_core_log.put_line('Generic PUT Cache purged');

3936: NAME_TAB.DELETE();
3937: VAL_TAB.DELETE();
3938: PROFILE_OPTION_EXISTS := TRUE;
3939: if CORELOG_IS_ENABLED then
3940: fnd_core_log.put_line('Generic PUT Cache purged');
3941: end if;
3942: end if;
3943:
3944: --