DBA Data[Home] [Help]

APPS.CSI_ASSET_PVT dependencies on FND_PROFILE

Line 836: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');

832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833:
834:
835: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
836: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
837:
838: IF (l_CSI_DEBUG_LEVEL > 0) THEN
839: debug( 'get_instance_asset');
840: END IF;

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

921: */
922:
923: /***** srramakr commented for bug # 3304439
924: -- Check for the profile option and disable the trace
925: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
926: dbms_session.set_sql_trace(false);
927: END IF;
928: -- End disable trace
929: ****/

Line 1044: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');

1040: -- Initialize API return status to success
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;
1042:
1043: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
1044: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
1045:
1046: IF (l_CSI_DEBUG_LEVEL >= 1) THEN
1047: debug('create_instance_asset:'||
1048: p_api_version||'-'|| p_commit||'-'|| p_init_msg_list);

Line 1617: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');

1613: -- Initialize API return status to success
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
1617: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
1618:
1619: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
1620: IF (l_CSI_DEBUG_LEVEL > 0) THEN
1621: debug( 'update_instance_asset');

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

2521: x_return_status := FND_API.G_RET_STS_SUCCESS;
2522:
2523: /***** srramakr commented for bug # 3304439
2524: -- Check for the profile option and enable trace
2525: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
2526: dbms_session.set_sql_trace(TRUE);
2527: END IF;
2528:
2529: -- End enable trace

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

2780: */
2781:
2782: /***** srramakr commented for bug # 3304439
2783: -- Check for the profile option and disable the trace
2784: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
2785: dbms_session.set_sql_trace(false);
2786: END IF;
2787: -- End disable trace
2788: ****/

Line 3020: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

3016: END IF;
3017: -- Initialize API return status to success
3018: x_return_status := FND_API.G_RET_STS_SUCCESS;
3019: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3020: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3021: -- If csi_debug_level = 1 then dump the procedure name
3022: IF (l_csi_debug_level > 0) THEN
3023: debug( 'get_attached_item_instances');
3024: END IF;

Line 3194: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

3190: END IF;
3191: -- Initialize API return status to success
3192: x_return_status := FND_API.G_RET_STS_SUCCESS;
3193: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3194: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3195: -- If csi_debug_level = 1 then dump the procedure name
3196: IF (l_csi_debug_level > 0) THEN
3197: debug( 'get_attached_asset_links');
3198: END IF;

Line 3321: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

3317: END IF;
3318: -- Initialize API return status to success
3319: x_return_status := FND_API.G_RET_STS_SUCCESS;
3320: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3321: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3322: -- If csi_debug_level = 1 then dump the procedure name
3323: IF (l_csi_debug_level > 0) THEN
3324: debug( 'get_fa_asset_details');
3325: END IF;

Line 3415: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

3411: l_process_loop BOOLEAN := TRUE;
3412:
3413: BEGIN
3414: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3415: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3416: IF (l_csi_debug_level > 0) THEN
3417: debug( 'Get_syncup_tree');
3418: END IF;
3419: