APPS.CSI_SYSTEMS_PVT dependencies on FND_PROFILE

Line 967: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

963:
964: -- initialize api return status to success
965: x_return_status := fnd_api.g_ret_sts_success;
966:
967: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
968: IF (l_debug_level > 0) THEN
969: csi_gen_utility_pvt.put_line( 'get_system');
970: END IF;
971:

Line 2553: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

2549:
2550: -- initialize api return status to success
2551: x_return_status := fnd_api.g_ret_sts_success;
2552:
2553: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2554: IF (l_debug_level > 0) THEN
2555: csi_gen_utility_pvt.put_line( 'create_system');
2556: END IF;
2557:

Line 2626: IF (fnd_profile.value('CSI_AUTO_GEN_SYS_NAME') = 'Y')

2622: END IF;
2623: --
2624: IF ( (p_system_rec.name IS NULL) OR (p_system_rec.name=fnd_api.g_miss_char) )
2625: THEN
2626: IF (fnd_profile.value('CSI_AUTO_GEN_SYS_NAME') = 'Y')
2627: THEN
2628: SELECT csi_systems_s.NEXTVAL
2629: INTO x_system_id
2630: FROM sys.dual;

Line 3108: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

3104: x_return_status := fnd_api.g_ret_sts_success;
3105:
3106:
3107:
3108: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3109: IF (l_debug_level > 0) THEN
3110: csi_gen_utility_pvt.put_line( 'update_system');
3111: END IF;
3112:

Line 4086: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

4082:
4083: -- initialize api return status to success
4084: x_return_status := fnd_api.g_ret_sts_success;
4085:
4086: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4087: IF (l_debug_level > 0) THEN
4088: csi_gen_utility_pvt.put_line( 'expire_system');
4089: END IF;
4090:

Line 4174: IF NVL(fnd_profile.value('CSI_CASCADE_SYS_TERMINATE'),'N')='Y' THEN

4170: -- <= sysdate. Changed this to call Update_Item_Instance which takes care of changing the
4171: -- status to EXPIRED when the active_end_Date is <= sysdate. For active_end_date > sysdate,
4172: -- only the date component should change for the instances and status should remain as it is.
4173: --
4174: IF NVL(fnd_profile.value('CSI_CASCADE_SYS_TERMINATE'),'N')='Y' THEN
4175:
4176: FOR expire_csr IN expire_instance_csr(p_system_rec.system_id)
4177: LOOP
4178: Begin

Line 5314: IF (fnd_profile.value('CSI_AUTO_GEN_SYS_NAME') = 'Y')

5310:
5311: -- validate not null column
5312: IF p_validation_mode='CREATE' THEN
5313: IF ( (p_name IS NULL) OR (p_name=fnd_api.g_miss_char) ) THEN
5314: IF (fnd_profile.value('CSI_AUTO_GEN_SYS_NAME') = 'Y')
5315: THEN
5316: NULL;
5317: ELSE
5318: fnd_message.set_name('CSI', 'CSI_SYS_NAME_NOT_PASSED');

Line 5599: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

5595:
5596: -- initialize api return status to success
5597: x_return_status := fnd_api.g_ret_sts_success;
5598:
5599: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5600: IF (l_debug_level > 0) THEN
5601: csi_gen_utility_pvt.put_line( 'get_system_details');
5602: END IF;
5603:

Line 6147: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

6143: x_return_status := FND_API.G_RET_STS_SUCCESS;
6144:
6145: /***** srramakr commented for bug # 3304439
6146: -- Check for the profile option and enable trace
6147: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
6148: dbms_session.set_sql_trace(TRUE);
6149: END IF;
6150:
6151: -- End enable trace

Line 6669: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

6665: END IF;
6666:
6667: /***** srramakr commented for bug # 3304439
6668: -- Check for the profile option and disable the trace
6669: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
6670: dbms_session.set_sql_trace(false);
6671: END IF;
6672: -- End disable trace
6673: ****/