1999: IS
2000: l_plm_profile_value NUMBER;
2001: l_returnValue VARCHAR2(1);
2002: BEGIN
2003: l_plm_profile_value := fnd_profile.value('EGO_ENABLE_PLM');
2004: IF (l_plm_profile_value = 1)
2005: THEN
2006: l_returnValue := 'Y';
2007: ELSE
2014: IS
2015: l_pim_profile_value NUMBER;
2016: l_returnValue VARCHAR2(1);
2017: BEGIN
2018: l_pim_profile_value := fnd_profile.value('EGO_ENABLE_PIMDL');
2019: IF (l_pim_profile_value = 1)
2020: THEN
2021: l_returnValue := 'Y';
2022: ELSE
2029: IS
2030: l_gdsn_profile_value NUMBER;
2031: l_returnValue VARCHAR2(1);
2032: BEGIN
2033: l_gdsn_profile_value := fnd_profile.value('EGO_UCCNET_ENABLED');
2034: IF (l_gdsn_profile_value = 1)
2035: THEN
2036: l_returnValue := 'Y';
2037: ELSE
2046: l_pim_profile_value NUMBER;
2047: l_gdsn_profile_value NUMBER;
2048: l_returnValue VARCHAR2(1);
2049: BEGIN
2050: l_pim_profile_value := fnd_profile.value('EGO_ENABLE_PIMDL');
2051: l_gdsn_profile_value := fnd_profile.value('EGO_UCCNET_ENABLED') ;
2052:
2053: --dbms_output.put_line(''||l_pim_profile_value);
2054: --dbms_output.put_line(''||l_gdsn_profile_value);
2047: l_gdsn_profile_value NUMBER;
2048: l_returnValue VARCHAR2(1);
2049: BEGIN
2050: l_pim_profile_value := fnd_profile.value('EGO_ENABLE_PIMDL');
2051: l_gdsn_profile_value := fnd_profile.value('EGO_UCCNET_ENABLED') ;
2052:
2053: --dbms_output.put_line(''||l_pim_profile_value);
2054: --dbms_output.put_line(''||l_gdsn_profile_value);
2055:
3181: */
3182: PROCEDURE Start_Logging(flow_name VARCHAR2,flow_id NUMBER)
3183: IS
3184: BEGIN
3185: IF ((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) AND ( G_PROFILE_ENABLED = FND_PROFILE.VALUE('BOM:LOG_EXECUTION_TIME'))) THEN
3186: G_FLOW_ID := flow_id;
3187: FND_FILE.put_line(FND_FILE.LOG,'BOM Performance Log:
3188: END IF;
3189: END Start_Logging;
3211: IS
3212: temp1 NUMBER;
3213: temp2 NUMBER;
3214: BEGIN
3215: IF ((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) AND ( G_PROFILE_ENABLED = FND_PROFILE.VALUE('BOM:LOG_EXECUTION_TIME'))) THEN
3216: IF G_TOP > 0 THEN
3217: temp1 := G_TIME_LOGGED(G_TOP);
3218: SELECT dbms_utility.get_time INTO temp2 FROM dual;
3219: FND_FILE.put_line(FND_FILE.LOG,'BOM Performance Log:
3230:
3231: PROCEDURE Stop_Logging
3232: IS
3233: BEGIN
3234: IF ((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) AND ( G_PROFILE_ENABLED = FND_PROFILE.VALUE('BOM:LOG_EXECUTION_TIME'))) THEN
3235: FND_FILE.put_line(FND_FILE.LOG,'BOM Performance Log: ');
3236: END IF;
3237: END Stop_Logging;
3238:
3365: ( p_org_id IN NUMBER)
3366: IS
3367: BEGIN
3368:
3369: fnd_profile.put('MFG_ORGANIZATION_ID', p_org_id);
3370:
3371: END Set_Profile_Org_id;
3372: END BOM_Globals;