APPS.CSI_II_RELATIONSHIPS_PVT dependencies on FND_PROFILE

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

81: END IF;
82:
83: -- initialize api return status to success
84: x_return_status := fnd_api.g_ret_sts_success;
85: l_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
86:
87: IF (l_debug_level > 0) THEN
88: CSI_gen_utility_pvt.put_line( 'get_cyclic_relationships');
89: END IF;

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

2242: -- initialize api return status to success
2243: x_return_status := fnd_api.g_ret_sts_success;
2244:
2245:
2246: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2247: IF (l_debug_level > 0) THEN
2248: CSI_gen_utility_pvt.put_line( 'get_relationships');
2249: END IF;
2250:

Line 4524: IF(p_txn_rec.TRANSACTION_TYPE_ID = 73 OR nvl(FND_PROFILE.VALUE('CSI_CASCADE_STATUS'), 'Y') <> 'N') THEN

4520: FROM csi_item_instances
4521: WHERE instance_id=l_ii_relationship_rec.object_id;
4522:
4523: --Added for Bug 13831400 -- modified for bug 14004522
4524: IF(p_txn_rec.TRANSACTION_TYPE_ID = 73 OR nvl(FND_PROFILE.VALUE('CSI_CASCADE_STATUS'), 'Y') <> 'N') THEN
4525: SELECT instance_status_id
4526: INTO l_instance_rec.instance_status_id
4527: FROM csi_item_instances
4528: WHERE instance_id=l_ii_relationship_rec.object_id;

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

4865:
4866: -- initialize api return status to success
4867: x_return_status := fnd_api.g_ret_sts_success;
4868:
4869: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4870: IF (l_debug_level > 0) THEN
4871: CSI_gen_utility_pvt.put_line( 'create_relationship');
4872: END IF;
4873:

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

5457: -- initialize api return status to success
5458: x_return_status := fnd_api.g_ret_sts_success;
5459:
5460:
5461: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5462: IF (l_debug_level > 0) THEN
5463: CSI_gen_utility_pvt.put_line( 'update_relationship');
5464: END IF;
5465:

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

6310:
6311: -- initialize api return status to success
6312: x_return_status := fnd_api.g_ret_sts_success;
6313:
6314: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6315: IF (l_debug_level > 0) THEN
6316: CSI_gen_utility_pvt.put_line( 'expire_relationship');
6317: END IF;
6318:

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

7543: -- Initialize API return status to success
7544: x_return_status := FND_API.G_RET_STS_SUCCESS;
7545:
7546: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
7547: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7548:
7549: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
7550: IF (l_csi_debug_level > 0) THEN
7551: csi_gen_utility_pvt.put_line( 'get_inst_relationship_hist');

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

7765: x_return_status := fnd_api.g_ret_sts_success;
7766: p_cyclic_node := NULL;
7767: l_instance_id := p_instance_id;
7768: --
7769: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7770: IF (l_debug_level > 0) THEN
7771: CSI_gen_utility_pvt.put_line( 'Get_Cyclic_Node');
7772: END IF;
7773: --