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 2836: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');

2832:
2833: BEGIN
2834: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2835: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2836: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
2837: IF px_instance_sync_tbl.count = 0 OR px_instance_asset_sync_tbl.count = 0 OR
2838: px_fa_asset_sync_tbl.count = 0 THEN
2839: x_error_msg := 'Invalid Parameters';
2840: RAISE fnd_api.g_exc_error;

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

3040: END IF;
3041: -- Initialize API return status to success
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;
3043: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3044: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3045: -- If csi_debug_level = 1 then dump the procedure name
3046: IF (l_csi_debug_level > 0) THEN
3047: debug( 'get_attached_item_instances');
3048: END IF;

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

3214: END IF;
3215: -- Initialize API return status to success
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3218: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3219: -- If csi_debug_level = 1 then dump the procedure name
3220: IF (l_csi_debug_level > 0) THEN
3221: debug( 'get_attached_asset_links');
3222: END IF;

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

3341: END IF;
3342: -- Initialize API return status to success
3343: x_return_status := FND_API.G_RET_STS_SUCCESS;
3344: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3345: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3346: -- If csi_debug_level = 1 then dump the procedure name
3347: IF (l_csi_debug_level > 0) THEN
3348: debug( 'get_fa_asset_details');
3349: END IF;

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

3435: l_process_loop BOOLEAN := TRUE;
3436:
3437: BEGIN
3438: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3439: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3440: IF (l_csi_debug_level > 0) THEN
3441: debug( 'Get_syncup_tree');
3442: END IF;
3443: