eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_GEN_UTILITY_PVT

Line 88: CSI_gen_utility_pvt.put_line( 'get_cyclic_relationships');

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;
90:
91: IF (l_debug_level > 1) THEN
92: CSI_gen_utility_pvt.put_line(

Line 92: CSI_gen_utility_pvt.put_line(

88: CSI_gen_utility_pvt.put_line( 'get_cyclic_relationships');
89: END IF;
90:
91: IF (l_debug_level > 1) THEN
92: CSI_gen_utility_pvt.put_line(
93: p_api_version ||'-'||
94: p_commit ||'-'||
95: p_init_msg_list ||'-'||
96: p_validation_level ||'-'||

Line 2248: CSI_gen_utility_pvt.put_line( 'get_relationships');

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:
2251: IF (l_debug_level > 1) THEN
2252: CSI_gen_utility_pvt.put_line(

Line 2252: CSI_gen_utility_pvt.put_line(

2248: CSI_gen_utility_pvt.put_line( 'get_relationships');
2249: END IF;
2250:
2251: IF (l_debug_level > 1) THEN
2252: CSI_gen_utility_pvt.put_line(
2253: p_api_version ||'-'||
2254: p_commit ||'-'||
2255: p_init_msg_list ||'-'||
2256: p_validation_level ||'-'||

Line 2260: csi_gen_utility_pvt.dump_rel_query_rec(p_relationship_query_rec);

2256: p_validation_level ||'-'||
2257: p_depth ||'_'||
2258: p_time_stamp );
2259:
2260: csi_gen_utility_pvt.dump_rel_query_rec(p_relationship_query_rec);
2261: END IF;
2262:
2263:
2264: --

Line 2355: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||

2351: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE))
2352: THEN
2353: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2354: THEN
2355: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2356: 'Please provide a valid datetime stamp.');
2357: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2358: FND_MSG_PUB.ADD;
2359: ELSE

Line 2453: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');

2449: WHILE l_msg_count > 0 LOOP
2450: x_msg_data := FND_MSG_PUB.GET
2451: ( l_msg_index,
2452: FND_API.G_FALSE );
2453: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2454: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2455: l_msg_index := l_msg_index + 1;
2456: l_msg_count := l_msg_count - 1;
2457: END LOOP;

Line 2454: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2450: x_msg_data := FND_MSG_PUB.GET
2451: ( l_msg_index,
2452: FND_API.G_FALSE );
2453: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2454: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2455: l_msg_index := l_msg_index + 1;
2456: l_msg_count := l_msg_count - 1;
2457: END LOOP;
2458: RAISE FND_API.G_EXC_ERROR;

Line 2563: csi_gen_utility_pvt.put_line( ' Error from Get_Chidren.. ');

2559: LOOP
2560: x_msg_data := FND_MSG_PUB.GET
2561: ( l_msg_index,
2562: FND_API.G_FALSE );
2563: csi_gen_utility_pvt.put_line( ' Error from Get_Chidren.. ');
2564: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2565: l_msg_index := l_msg_index + 1;
2566: l_msg_count := l_msg_count - 1;
2567: END LOOP;

Line 2564: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2560: x_msg_data := FND_MSG_PUB.GET
2561: ( l_msg_index,
2562: FND_API.G_FALSE );
2563: csi_gen_utility_pvt.put_line( ' Error from Get_Chidren.. ');
2564: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2565: l_msg_index := l_msg_index + 1;
2566: l_msg_count := l_msg_count - 1;
2567: END LOOP;
2568: RAISE FND_API.G_EXC_ERROR;

Line 2600: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||

2596: l_returned_rec_count:=l_returned_rec_count+1;
2597:
2598: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2599: THEN
2600: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2601: 'Please provide a valid datetime stamp.');
2602: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2603: FND_MSG_PUB.ADD;
2604: ELSE

Line 2646: csi_gen_utility_pvt.put_line('Into recurrsive call for get_relationships. ');

2642: p_depth IS NULL
2643: THEN
2644: l_relationship_query_rec.object_id:=l_relationship_tbl(l_returned_rec_count).subject_id;
2645: l_relationship_query_rec.subject_id:=fnd_api.g_miss_num;
2646: csi_gen_utility_pvt.put_line('Into recurrsive call for get_relationships. ');
2647: csi_ii_relationships_pvt.get_relationships
2648: ( p_api_version => p_api_version
2649: ,p_commit => p_commit
2650: ,p_init_msg_list => p_init_msg_list

Line 2672: csi_gen_utility_pvt.put_line( ' Error from recursive Get_relationships.. ');

2668: LOOP
2669: x_msg_data := FND_MSG_PUB.GET
2670: ( l_msg_index,
2671: FND_API.G_FALSE );
2672: csi_gen_utility_pvt.put_line( ' Error from recursive Get_relationships.. ');
2673: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2674: l_msg_index := l_msg_index + 1;
2675: l_msg_count := l_msg_count - 1;
2676: END LOOP;

Line 2673: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2669: x_msg_data := FND_MSG_PUB.GET
2670: ( l_msg_index,
2671: FND_API.G_FALSE );
2672: csi_gen_utility_pvt.put_line( ' Error from recursive Get_relationships.. ');
2673: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2674: l_msg_index := l_msg_index + 1;
2675: l_msg_count := l_msg_count - 1;
2676: END LOOP;
2677: RAISE FND_API.G_EXC_ERROR;

Line 2804: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');

2800: WHILE l_msg_count > 0 LOOP
2801: x_msg_data := FND_MSG_PUB.GET
2802: ( l_msg_index,
2803: FND_API.G_FALSE );
2804: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2805: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2806: l_msg_index := l_msg_index + 1;
2807: l_msg_count := l_msg_count - 1;
2808: END LOOP;

Line 2805: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2801: x_msg_data := FND_MSG_PUB.GET
2802: ( l_msg_index,
2803: FND_API.G_FALSE );
2804: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2805: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2806: l_msg_index := l_msg_index + 1;
2807: l_msg_count := l_msg_count - 1;
2808: END LOOP;
2809: RAISE FND_API.G_EXC_ERROR;

Line 3589: csi_gen_utility_pvt.populate_install_param_rec;

3585:
3586: x_return_status := fnd_api.g_ret_sts_success;
3587: --
3588: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3589: csi_gen_utility_pvt.populate_install_param_rec;
3590: END IF;
3591: --
3592: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3593: --

Line 4871: CSI_gen_utility_pvt.put_line( 'create_relationship');

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:
4874: IF (l_debug_level > 1) THEN
4875:

Line 4877: CSI_gen_utility_pvt.put_line(

4873:
4874: IF (l_debug_level > 1) THEN
4875:
4876:
4877: CSI_gen_utility_pvt.put_line(
4878: p_api_version ||'-'||
4879: p_commit ||'-'||
4880: p_init_msg_list ||'-'||
4881: p_validation_level );

Line 4883: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);

4879: p_commit ||'-'||
4880: p_init_msg_list ||'-'||
4881: p_validation_level );
4882:
4883: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
4884: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4885:
4886: END IF;
4887:

Line 4884: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

4880: p_init_msg_list ||'-'||
4881: p_validation_level );
4882:
4883: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
4884: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4885:
4886: END IF;
4887:
4888: -- invoke validation procedures

Line 5059: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');

5055: LOOP
5056: x_msg_data := FND_MSG_PUB.GET
5057: ( l_msg_index,
5058: FND_API.G_FALSE );
5059: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
5060: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5061: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5062: l_msg_index := l_msg_index + 1;
5063: l_msg_count := l_msg_count - 1;

Line 5060: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');

5056: x_msg_data := FND_MSG_PUB.GET
5057: ( l_msg_index,
5058: FND_API.G_FALSE );
5059: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
5060: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5061: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5062: l_msg_index := l_msg_index + 1;
5063: l_msg_count := l_msg_count - 1;
5064: END LOOP;

Line 5061: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5057: ( l_msg_index,
5058: FND_API.G_FALSE );
5059: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
5060: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5061: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5062: l_msg_index := l_msg_index + 1;
5063: l_msg_count := l_msg_count - 1;
5064: END LOOP;
5065: RAISE FND_API.G_EXC_ERROR;

Line 5218: csi_gen_utility_pvt.put_line('Cascade_ownership_flag : '||p_relationship_tbl(l_count).cascade_ownership_flag);

5214: -- Get the parent instance owner party and owner account
5215:
5216: IF nvl(p_relationship_tbl(l_count).cascade_ownership_flag,'N')='Y'
5217: THEN
5218: csi_gen_utility_pvt.put_line('Cascade_ownership_flag : '||p_relationship_tbl(l_count).cascade_ownership_flag);
5219: l_instance_rec:=l_cascade_instance_rec;
5220: l_ext_attrib_values_tbl.delete;
5221: l_party_tbl.delete;
5222: l_account_tbl.delete;

Line 5244: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');

5240: AND (active_end_date IS NULL OR active_end_date > sysdate);
5241: EXCEPTION
5242: WHEN OTHERS
5243: THEN
5244: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5245: csi_gen_utility_pvt.put_line( 'The object_id, which you are trying to cascade its ownership, is not found or expired in csi_item_instances table. ');
5246: RAISE fnd_api.g_exc_error;
5247: END;
5248:

Line 5245: csi_gen_utility_pvt.put_line( 'The object_id, which you are trying to cascade its ownership, is not found or expired in csi_item_instances table. ');

5241: EXCEPTION
5242: WHEN OTHERS
5243: THEN
5244: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5245: csi_gen_utility_pvt.put_line( 'The object_id, which you are trying to cascade its ownership, is not found or expired in csi_item_instances table. ');
5246: RAISE fnd_api.g_exc_error;
5247: END;
5248:
5249: csi_item_instance_pub.update_item_instance

Line 5270: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');

5266: );
5267:
5268: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5269: THEN
5270: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5271: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5272: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5273: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5274: fnd_msg_pub.add;

Line 5271: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');

5267:
5268: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5269: THEN
5270: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5271: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5272: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5273: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5274: fnd_msg_pub.add;
5275: RAISE fnd_api.g_exc_error;

Line 5463: CSI_gen_utility_pvt.put_line( 'update_relationship');

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:
5466: IF (l_debug_level > 1) THEN
5467:

Line 5469: CSI_gen_utility_pvt.put_line(

5465:
5466: IF (l_debug_level > 1) THEN
5467:
5468:
5469: CSI_gen_utility_pvt.put_line(
5470: p_api_version ||'-'||
5471: p_commit ||'-'||
5472: p_init_msg_list ||'-'||
5473: p_validation_level );

Line 5475: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);

5471: p_commit ||'-'||
5472: p_init_msg_list ||'-'||
5473: p_validation_level );
5474:
5475: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
5476: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
5477:
5478: END IF;
5479:

Line 5476: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

5472: p_init_msg_list ||'-'||
5473: p_validation_level );
5474:
5475: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
5476: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
5477:
5478: END IF;
5479:
5480:

Line 5829: csi_gen_utility_pvt.put_line('Calling Update_Instance..');

5825: (p_relationship_tbl(l_count).subject_id = FND_API.G_MISS_NUM OR
5826: p_relationship_tbl(l_count).subject_id = l_relship_csr.subject_id) )
5827: )
5828: THEN
5829: csi_gen_utility_pvt.put_line('Calling Update_Instance..');
5830: update_instance
5831: ( p_api_version => p_api_version,
5832: p_commit => fnd_api.g_false,--p_commit,
5833: p_init_msg_list => p_init_msg_list,

Line 5849: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');

5845: LOOP
5846: x_msg_data := FND_MSG_PUB.GET
5847: ( l_msg_index,
5848: FND_API.G_FALSE );
5849: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5850: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5851: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5852: l_msg_index := l_msg_index + 1;
5853: l_msg_count := l_msg_count - 1;

Line 5850: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');

5846: x_msg_data := FND_MSG_PUB.GET
5847: ( l_msg_index,
5848: FND_API.G_FALSE );
5849: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5850: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5851: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5852: l_msg_index := l_msg_index + 1;
5853: l_msg_count := l_msg_count - 1;
5854: END LOOP;

Line 5851: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5847: ( l_msg_index,
5848: FND_API.G_FALSE );
5849: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5850: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5851: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5852: l_msg_index := l_msg_index + 1;
5853: l_msg_count := l_msg_count - 1;
5854: END LOOP;
5855: RAISE FND_API.G_EXC_ERROR;

Line 6006: csi_gen_utility_pvt.put_line('Calling update_item_instance..');

6002: THEN
6003: IF l_relship_csr.subject_id = l_instance_rec.instance_id AND
6004: nvl(p_replace_flag,fnd_api.g_false)<> fnd_api.g_true
6005: THEN
6006: csi_gen_utility_pvt.put_line('Calling update_item_instance..');
6007: csi_gen_utility_pvt.put_line('Parameter p_called_from_rel set to true..');
6008: csi_item_instance_pvt.update_item_instance
6009: (p_api_version => p_api_version
6010: ,p_commit => p_commit

Line 6007: csi_gen_utility_pvt.put_line('Parameter p_called_from_rel set to true..');

6003: IF l_relship_csr.subject_id = l_instance_rec.instance_id AND
6004: nvl(p_replace_flag,fnd_api.g_false)<> fnd_api.g_true
6005: THEN
6006: csi_gen_utility_pvt.put_line('Calling update_item_instance..');
6007: csi_gen_utility_pvt.put_line('Parameter p_called_from_rel set to true..');
6008: csi_item_instance_pvt.update_item_instance
6009: (p_api_version => p_api_version
6010: ,p_commit => p_commit
6011: ,p_init_msg_list => p_init_msg_list

Line 6081: csi_gen_utility_pvt.put_line('Cascade_ownership_flag : '||p_relationship_tbl(l_count).cascade_ownership_flag);

6077: -- Get the parent instance owner party and owner account
6078:
6079: IF nvl(p_relationship_tbl(l_count).cascade_ownership_flag,'N')='Y'
6080: THEN
6081: csi_gen_utility_pvt.put_line('Cascade_ownership_flag : '||p_relationship_tbl(l_count).cascade_ownership_flag);
6082: l_inst_rec:=l_cascade_instance_rec;
6083: l_ext_attrib_values_tbl.delete;
6084: l_party_tbl.delete;
6085: l_account_tbl.delete;

Line 6103: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');

6099: WHERE relationship_id=p_relationship_tbl(l_count).relationship_id;
6100: EXCEPTION
6101: WHEN OTHERS
6102: THEN
6103: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6104: csi_gen_utility_pvt.put_line( 'Object_id not found in csi_ii_relationships to cascade ownership');
6105: RAISE fnd_api.g_exc_error;
6106: END;
6107: END IF;

Line 6104: csi_gen_utility_pvt.put_line( 'Object_id not found in csi_ii_relationships to cascade ownership');

6100: EXCEPTION
6101: WHEN OTHERS
6102: THEN
6103: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6104: csi_gen_utility_pvt.put_line( 'Object_id not found in csi_ii_relationships to cascade ownership');
6105: RAISE fnd_api.g_exc_error;
6106: END;
6107: END IF;
6108:

Line 6120: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');

6116: AND (active_end_date IS NULL OR active_end_date > sysdate);
6117: EXCEPTION
6118: WHEN OTHERS
6119: THEN
6120: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6121: csi_gen_utility_pvt.put_line( 'The object_id, which you are trying to cascade its ownership, is not found or expired in csi_item_instances table. ');
6122: RAISE fnd_api.g_exc_error;
6123: END;
6124:

Line 6121: csi_gen_utility_pvt.put_line( 'The object_id, which you are trying to cascade its ownership, is not found or expired in csi_item_instances table. ');

6117: EXCEPTION
6118: WHEN OTHERS
6119: THEN
6120: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6121: csi_gen_utility_pvt.put_line( 'The object_id, which you are trying to cascade its ownership, is not found or expired in csi_item_instances table. ');
6122: RAISE fnd_api.g_exc_error;
6123: END;
6124:
6125: csi_item_instance_pub.update_item_instance

Line 6146: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');

6142: );
6143:
6144: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
6145: THEN
6146: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6147: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
6148: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6149: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6150: fnd_msg_pub.add;

Line 6147: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');

6143:
6144: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
6145: THEN
6146: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
6147: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
6148: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
6149: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
6150: fnd_msg_pub.add;
6151: RAISE fnd_api.g_exc_error;

Line 6316: CSI_gen_utility_pvt.put_line( 'expire_relationship');

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:
6319: IF (l_debug_level > 1) THEN
6320:

Line 6321: CSI_gen_utility_pvt.put_line(

6317: END IF;
6318:
6319: IF (l_debug_level > 1) THEN
6320:
6321: CSI_gen_utility_pvt.put_line(
6322: p_api_version ||'-'||
6323: p_commit ||'-'||
6324: p_init_msg_list ||'-'||
6325: p_validation_level

Line 6329: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

6325: p_validation_level
6326: );
6327:
6328: -- dump the relationship query records
6329: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
6330: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);
6331:
6332: END IF;
6333:

Line 6330: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);

6326: );
6327:
6328: -- dump the relationship query records
6329: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
6330: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);
6331:
6332: END IF;
6333:
6334: --

Line 6581: csi_gen_utility_pvt.put_line('Calling Update II from Exp Rel...');

6577: IF l_instance_rec.instance_id IS NOT NULL AND
6578: l_instance_rec.object_version_number IS NOT NULL AND
6579: l_found
6580: THEN
6581: csi_gen_utility_pvt.put_line('Calling Update II from Exp Rel...');
6582: csi_item_instance_pvt.update_item_instance
6583: ( p_api_version => p_api_version
6584: ,p_commit => p_commit
6585: ,p_init_msg_list => p_init_msg_list

Line 7551: csi_gen_utility_pvt.put_line( 'get_inst_relationship_hist');

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');
7552: END IF;
7553:
7554: -- If the debug level = 2 then dump all the parameters values.
7555: IF (l_csi_debug_level > 1) THEN

Line 7556: csi_gen_utility_pvt.put_line( 'get_inst_relationship_hist' ||

7552: END IF;
7553:
7554: -- If the debug level = 2 then dump all the parameters values.
7555: IF (l_csi_debug_level > 1) THEN
7556: csi_gen_utility_pvt.put_line( 'get_inst_relationship_hist' ||
7557: p_api_version ||'-'||
7558: p_commit ||'-'||
7559: p_init_msg_list ||'-'||
7560: p_validation_level ||'-'||

Line 7566: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

7562: END IF;
7563:
7564: /***** srramakr commented for bug # 3304439
7565: -- Check for the profile option and enable trace
7566: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
7567: -- End enable trace
7568: ****/
7569:
7570: -- Start API body

Line 7771: CSI_gen_utility_pvt.put_line( 'Get_Cyclic_Node');

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: --
7774: csi_ii_relationships_pvt.get_cyclic_relationships(
7775: p_api_version => 1.0,

Line 7796: csi_gen_utility_pvt.put_line( ' Error from Get_cyclic_relationships.. ');

7792: WHILE l_msg_count > 0 LOOP
7793: x_msg_data := FND_MSG_PUB.GET
7794: ( l_msg_index,
7795: FND_API.G_FALSE );
7796: csi_gen_utility_pvt.put_line( ' Error from Get_cyclic_relationships.. ');
7797: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7798: l_msg_index := l_msg_index + 1;
7799: l_msg_count := l_msg_count - 1;
7800: END LOOP;

Line 7797: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

7793: x_msg_data := FND_MSG_PUB.GET
7794: ( l_msg_index,
7795: FND_API.G_FALSE );
7796: csi_gen_utility_pvt.put_line( ' Error from Get_cyclic_relationships.. ');
7797: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7798: l_msg_index := l_msg_index + 1;
7799: l_msg_count := l_msg_count - 1;
7800: END LOOP;
7801: RAISE FND_API.G_EXC_ERROR;

Line 7804: csi_gen_utility_pvt.put_line('p_rel_tbl count after get_cyclic_relationships is '

7800: END LOOP;
7801: RAISE FND_API.G_EXC_ERROR;
7802: END IF;
7803: --
7804: csi_gen_utility_pvt.put_line('p_rel_tbl count after get_cyclic_relationships is '
7805: ||to_char(p_rel_tbl.count));
7806: l_rel_tbl_final.DELETE;
7807: l_rel_tbl_final := p_rel_tbl;
7808: p_rel_tbl.DELETE;

Line 7832: csi_gen_utility_pvt.put_line('Processing '||to_char(l_temp_id));

7828: l_rel_tbl_final.count = 0 THEN
7829: exit;
7830: END IF;
7831: --
7832: csi_gen_utility_pvt.put_line('Processing '||to_char(l_temp_id));
7833: --
7834: FOR rel IN l_rel_tbl_final.FIRST .. l_rel_tbl_final.LAST LOOP
7835: l_found := 0;
7836: l_adj_node := -9999;

Line 7878: csi_gen_utility_pvt.put_line('Cycle exists at '||to_char(p_cyclic_node));

7874: IF l_rel_color_tbl(color_rec).node_id = l_temp_id AND -- adjacent node
7875: l_rel_color_tbl(color_rec).color_code = 'R' THEN
7876: p_cyclic_node := l_temp_id;
7877: IF nvl(p_stop_at_cyclic,fnd_api.g_true) = fnd_api.g_true THEN
7878: csi_gen_utility_pvt.put_line('Cycle exists at '||to_char(p_cyclic_node));
7879: Raise COMP_ERROR;
7880: END IF;
7881: END IF;
7882: END LOOP;

Line 7899: csi_gen_utility_pvt.put_line('Marked '||l_temp_id);

7895: FOR mark in l_rel_color_tbl.FIRST .. l_rel_color_tbl.LAST LOOP
7896: IF l_rel_color_tbl(mark).node_id = l_temp_id THEN
7897: l_rel_color_tbl(mark).color_code := 'B';
7898: l_node_found := 1;
7899: csi_gen_utility_pvt.put_line('Marked '||l_temp_id);
7900: exit;
7901: END IF;
7902: END LOOP;
7903: END IF;

Line 7909: csi_gen_utility_pvt.put_line('Marked '||l_temp_id);

7905: IF l_node_found = 0 THEN
7906: l_rel_color_ctr := l_rel_color_ctr + 1;
7907: l_rel_color_tbl(l_rel_color_ctr).node_id := l_temp_id;
7908: l_rel_color_tbl(l_rel_color_ctr).color_code := 'B'; -- since l_found = 0
7909: csi_gen_utility_pvt.put_line('Marked '||l_temp_id);
7910: END IF;
7911: --
7912: -- Get the unmarked node from l_rel_color_tbl in Reverse direction
7913: -- The idea is to go back in the same path once a node is marked as 'B'.

Line 7921: csi_gen_utility_pvt.put_line('Adjacent Node is '||l_temp_id);

7917: exit;
7918: END IF;
7919: END LOOP;
7920: --
7921: csi_gen_utility_pvt.put_line('Adjacent Node is '||l_temp_id);
7922: IF l_temp_id = -9999 THEN
7923: csi_gen_utility_pvt.put_line('Unable to get the Adjacent Node.. Exiting...');
7924: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
7925: END IF;

Line 7923: csi_gen_utility_pvt.put_line('Unable to get the Adjacent Node.. Exiting...');

7919: END LOOP;
7920: --
7921: csi_gen_utility_pvt.put_line('Adjacent Node is '||l_temp_id);
7922: IF l_temp_id = -9999 THEN
7923: csi_gen_utility_pvt.put_line('Unable to get the Adjacent Node.. Exiting...');
7924: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
7925: END IF;
7926: END IF; -- l_found = 0 check
7927: END LOOP;

Line 7929: csi_gen_utility_pvt.put_line('End of Get_Cyclic_Node...');

7925: END IF;
7926: END IF; -- l_found = 0 check
7927: END LOOP;
7928: END IF;
7929: csi_gen_utility_pvt.put_line('End of Get_Cyclic_Node...');
7930: EXCEPTION
7931: WHEN COMP_ERROR THEN
7932: null;
7933: WHEN FND_API.G_EXC_ERROR THEN