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 83: CSI_gen_utility_pvt.put_line( 'get_cyclic_relationships');

79: x_return_status := fnd_api.g_ret_sts_success;
80: l_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
81:
82: IF (l_debug_level > 0) THEN
83: CSI_gen_utility_pvt.put_line( 'get_cyclic_relationships');
84: END IF;
85:
86: IF (l_debug_level > 1) THEN
87: CSI_gen_utility_pvt.put_line(

Line 87: CSI_gen_utility_pvt.put_line(

83: CSI_gen_utility_pvt.put_line( 'get_cyclic_relationships');
84: END IF;
85:
86: IF (l_debug_level > 1) THEN
87: CSI_gen_utility_pvt.put_line(
88: p_api_version ||'-'||
89: p_commit ||'-'||
90: p_init_msg_list ||'-'||
91: p_validation_level ||'-'||

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

2119:
2120:
2121: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2122: IF (l_debug_level > 0) THEN
2123: CSI_gen_utility_pvt.put_line( 'get_relationships');
2124: END IF;
2125:
2126: IF (l_debug_level > 1) THEN
2127: CSI_gen_utility_pvt.put_line(

Line 2127: CSI_gen_utility_pvt.put_line(

2123: CSI_gen_utility_pvt.put_line( 'get_relationships');
2124: END IF;
2125:
2126: IF (l_debug_level > 1) THEN
2127: CSI_gen_utility_pvt.put_line(
2128: p_api_version ||'-'||
2129: p_commit ||'-'||
2130: p_init_msg_list ||'-'||
2131: p_validation_level ||'-'||

Line 2135: csi_gen_utility_pvt.dump_rel_query_rec(p_relationship_query_rec);

2131: p_validation_level ||'-'||
2132: p_depth ||'_'||
2133: p_time_stamp );
2134:
2135: csi_gen_utility_pvt.dump_rel_query_rec(p_relationship_query_rec);
2136: END IF;
2137:
2138:
2139: --

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

2226: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE))
2227: THEN
2228: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2229: THEN
2230: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2231: 'Please provide a valid datetime stamp.');
2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2233: FND_MSG_PUB.ADD;
2234: ELSE

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

2324: WHILE l_msg_count > 0 LOOP
2325: x_msg_data := FND_MSG_PUB.GET
2326: ( l_msg_index,
2327: FND_API.G_FALSE );
2328: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2329: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2330: l_msg_index := l_msg_index + 1;
2331: l_msg_count := l_msg_count - 1;
2332: END LOOP;

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

2325: x_msg_data := FND_MSG_PUB.GET
2326: ( l_msg_index,
2327: FND_API.G_FALSE );
2328: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2329: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2330: l_msg_index := l_msg_index + 1;
2331: l_msg_count := l_msg_count - 1;
2332: END LOOP;
2333: RAISE FND_API.G_EXC_ERROR;

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

2432: LOOP
2433: x_msg_data := FND_MSG_PUB.GET
2434: ( l_msg_index,
2435: FND_API.G_FALSE );
2436: csi_gen_utility_pvt.put_line( ' Error from Get_Chidren.. ');
2437: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2438: l_msg_index := l_msg_index + 1;
2439: l_msg_count := l_msg_count - 1;
2440: END LOOP;

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

2433: x_msg_data := FND_MSG_PUB.GET
2434: ( l_msg_index,
2435: FND_API.G_FALSE );
2436: csi_gen_utility_pvt.put_line( ' Error from Get_Chidren.. ');
2437: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2438: l_msg_index := l_msg_index + 1;
2439: l_msg_count := l_msg_count - 1;
2440: END LOOP;
2441: RAISE FND_API.G_EXC_ERROR;

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

2469: l_returned_rec_count:=l_returned_rec_count+1;
2470:
2471: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
2472: THEN
2473: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
2474: 'Please provide a valid datetime stamp.');
2475: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
2476: FND_MSG_PUB.ADD;
2477: ELSE

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

2515: p_depth IS NULL
2516: THEN
2517: l_relationship_query_rec.object_id:=l_relationship_tbl(l_returned_rec_count).subject_id;
2518: l_relationship_query_rec.subject_id:=fnd_api.g_miss_num;
2519: csi_gen_utility_pvt.put_line('Into recurrsive call for get_relationships. ');
2520: csi_ii_relationships_pvt.get_relationships
2521: ( p_api_version => p_api_version
2522: ,p_commit => p_commit
2523: ,p_init_msg_list => p_init_msg_list

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

2541: LOOP
2542: x_msg_data := FND_MSG_PUB.GET
2543: ( l_msg_index,
2544: FND_API.G_FALSE );
2545: csi_gen_utility_pvt.put_line( ' Error from recursive Get_relationships.. ');
2546: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2547: l_msg_index := l_msg_index + 1;
2548: l_msg_count := l_msg_count - 1;
2549: END LOOP;

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

2542: x_msg_data := FND_MSG_PUB.GET
2543: ( l_msg_index,
2544: FND_API.G_FALSE );
2545: csi_gen_utility_pvt.put_line( ' Error from recursive Get_relationships.. ');
2546: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2547: l_msg_index := l_msg_index + 1;
2548: l_msg_count := l_msg_count - 1;
2549: END LOOP;
2550: RAISE FND_API.G_EXC_ERROR;

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

2673: WHILE l_msg_count > 0 LOOP
2674: x_msg_data := FND_MSG_PUB.GET
2675: ( l_msg_index,
2676: FND_API.G_FALSE );
2677: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2678: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2679: l_msg_index := l_msg_index + 1;
2680: l_msg_count := l_msg_count - 1;
2681: END LOOP;

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

2674: x_msg_data := FND_MSG_PUB.GET
2675: ( l_msg_index,
2676: FND_API.G_FALSE );
2677: csi_gen_utility_pvt.put_line( ' Error from Get_Item_Instance_Details.. ');
2678: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2679: l_msg_index := l_msg_index + 1;
2680: l_msg_count := l_msg_count - 1;
2681: END LOOP;
2682: RAISE FND_API.G_EXC_ERROR;

Line 3441: csi_gen_utility_pvt.populate_install_param_rec;

3437:
3438: x_return_status := fnd_api.g_ret_sts_success;
3439: --
3440: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3441: csi_gen_utility_pvt.populate_install_param_rec;
3442: END IF;
3443: --
3444: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3445: --

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

4707: x_return_status := fnd_api.g_ret_sts_success;
4708:
4709: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4710: IF (l_debug_level > 0) THEN
4711: CSI_gen_utility_pvt.put_line( 'create_relationship');
4712: END IF;
4713:
4714: IF (l_debug_level > 1) THEN
4715:

Line 4717: CSI_gen_utility_pvt.put_line(

4713:
4714: IF (l_debug_level > 1) THEN
4715:
4716:
4717: CSI_gen_utility_pvt.put_line(
4718: p_api_version ||'-'||
4719: p_commit ||'-'||
4720: p_init_msg_list ||'-'||
4721: p_validation_level );

Line 4723: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);

4719: p_commit ||'-'||
4720: p_init_msg_list ||'-'||
4721: p_validation_level );
4722:
4723: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
4724: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4725:
4726: END IF;
4727:

Line 4724: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

4720: p_init_msg_list ||'-'||
4721: p_validation_level );
4722:
4723: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
4724: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4725:
4726: END IF;
4727:
4728: -- invoke validation procedures

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

4887: LOOP
4888: x_msg_data := FND_MSG_PUB.GET
4889: ( l_msg_index,
4890: FND_API.G_FALSE );
4891: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
4892: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
4893: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4894: l_msg_index := l_msg_index + 1;
4895: l_msg_count := l_msg_count - 1;

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

4888: x_msg_data := FND_MSG_PUB.GET
4889: ( l_msg_index,
4890: FND_API.G_FALSE );
4891: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
4892: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
4893: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4894: l_msg_index := l_msg_index + 1;
4895: l_msg_count := l_msg_count - 1;
4896: END LOOP;

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

4889: ( l_msg_index,
4890: FND_API.G_FALSE );
4891: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
4892: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
4893: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4894: l_msg_index := l_msg_index + 1;
4895: l_msg_count := l_msg_count - 1;
4896: END LOOP;
4897: RAISE FND_API.G_EXC_ERROR;

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

5046: -- Get the parent instance owner party and owner account
5047:
5048: IF nvl(p_relationship_tbl(l_count).cascade_ownership_flag,'N')='Y'
5049: THEN
5050: csi_gen_utility_pvt.put_line('Cascade_ownership_flag : '||p_relationship_tbl(l_count).cascade_ownership_flag);
5051: l_instance_rec:=l_cascade_instance_rec;
5052: l_ext_attrib_values_tbl.delete;
5053: l_party_tbl.delete;
5054: l_account_tbl.delete;

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

5072: AND (active_end_date IS NULL OR active_end_date > sysdate);
5073: EXCEPTION
5074: WHEN OTHERS
5075: THEN
5076: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5077: 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. ');
5078: RAISE fnd_api.g_exc_error;
5079: END;
5080:

Line 5077: 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. ');

5073: EXCEPTION
5074: WHEN OTHERS
5075: THEN
5076: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5077: 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. ');
5078: RAISE fnd_api.g_exc_error;
5079: END;
5080:
5081: csi_item_instance_pub.update_item_instance

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

5098: );
5099:
5100: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5101: THEN
5102: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5103: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5104: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5105: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5106: fnd_msg_pub.add;

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

5099:
5100: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5101: THEN
5102: csi_gen_utility_pvt.put_line( 'Error from create relationship API.');
5103: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5104: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5105: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5106: fnd_msg_pub.add;
5107: RAISE fnd_api.g_exc_error;

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

5285:
5286:
5287: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5288: IF (l_debug_level > 0) THEN
5289: CSI_gen_utility_pvt.put_line( 'update_relationship');
5290: END IF;
5291:
5292: IF (l_debug_level > 1) THEN
5293:

Line 5295: CSI_gen_utility_pvt.put_line(

5291:
5292: IF (l_debug_level > 1) THEN
5293:
5294:
5295: CSI_gen_utility_pvt.put_line(
5296: p_api_version ||'-'||
5297: p_commit ||'-'||
5298: p_init_msg_list ||'-'||
5299: p_validation_level );

Line 5301: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);

5297: p_commit ||'-'||
5298: p_init_msg_list ||'-'||
5299: p_validation_level );
5300:
5301: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
5302: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
5303:
5304: END IF;
5305:

Line 5302: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

5298: p_init_msg_list ||'-'||
5299: p_validation_level );
5300:
5301: csi_gen_utility_pvt.dump_rel_tbl(p_relationship_tbl);
5302: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
5303:
5304: END IF;
5305:
5306:

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

5648: (p_relationship_tbl(l_count).subject_id = FND_API.G_MISS_NUM OR
5649: p_relationship_tbl(l_count).subject_id = l_relship_csr.subject_id) )
5650: )
5651: THEN
5652: csi_gen_utility_pvt.put_line('Calling Update_Instance..');
5653: update_instance
5654: ( p_api_version => p_api_version,
5655: p_commit => fnd_api.g_false,--p_commit,
5656: p_init_msg_list => p_init_msg_list,

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

5668: LOOP
5669: x_msg_data := FND_MSG_PUB.GET
5670: ( l_msg_index,
5671: FND_API.G_FALSE );
5672: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5673: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5674: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5675: l_msg_index := l_msg_index + 1;
5676: l_msg_count := l_msg_count - 1;

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

5669: x_msg_data := FND_MSG_PUB.GET
5670: ( l_msg_index,
5671: FND_API.G_FALSE );
5672: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5673: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5674: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5675: l_msg_index := l_msg_index + 1;
5676: l_msg_count := l_msg_count - 1;
5677: END LOOP;

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

5670: ( l_msg_index,
5671: FND_API.G_FALSE );
5672: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5673: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5674: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5675: l_msg_index := l_msg_index + 1;
5676: l_msg_count := l_msg_count - 1;
5677: END LOOP;
5678: RAISE FND_API.G_EXC_ERROR;

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

5801: THEN
5802: IF l_relship_csr.subject_id = l_instance_rec.instance_id AND
5803: nvl(p_replace_flag,fnd_api.g_false)<> fnd_api.g_true
5804: THEN
5805: csi_gen_utility_pvt.put_line('Calling update_item_instance..');
5806: csi_gen_utility_pvt.put_line('Parameter p_called_from_rel set to true..');
5807: csi_item_instance_pvt.update_item_instance
5808: (p_api_version => p_api_version
5809: ,p_commit => p_commit

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

5802: IF l_relship_csr.subject_id = l_instance_rec.instance_id AND
5803: nvl(p_replace_flag,fnd_api.g_false)<> fnd_api.g_true
5804: THEN
5805: csi_gen_utility_pvt.put_line('Calling update_item_instance..');
5806: csi_gen_utility_pvt.put_line('Parameter p_called_from_rel set to true..');
5807: csi_item_instance_pvt.update_item_instance
5808: (p_api_version => p_api_version
5809: ,p_commit => p_commit
5810: ,p_init_msg_list => p_init_msg_list

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

5876: -- Get the parent instance owner party and owner account
5877:
5878: IF nvl(p_relationship_tbl(l_count).cascade_ownership_flag,'N')='Y'
5879: THEN
5880: csi_gen_utility_pvt.put_line('Cascade_ownership_flag : '||p_relationship_tbl(l_count).cascade_ownership_flag);
5881: l_inst_rec:=l_cascade_instance_rec;
5882: l_ext_attrib_values_tbl.delete;
5883: l_party_tbl.delete;
5884: l_account_tbl.delete;

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

5898: WHERE relationship_id=p_relationship_tbl(l_count).relationship_id;
5899: EXCEPTION
5900: WHEN OTHERS
5901: THEN
5902: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5903: csi_gen_utility_pvt.put_line( 'Object_id not found in csi_ii_relationships to cascade ownership');
5904: RAISE fnd_api.g_exc_error;
5905: END;
5906: END IF;

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

5899: EXCEPTION
5900: WHEN OTHERS
5901: THEN
5902: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5903: csi_gen_utility_pvt.put_line( 'Object_id not found in csi_ii_relationships to cascade ownership');
5904: RAISE fnd_api.g_exc_error;
5905: END;
5906: END IF;
5907:

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

5915: AND (active_end_date IS NULL OR active_end_date > sysdate);
5916: EXCEPTION
5917: WHEN OTHERS
5918: THEN
5919: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5920: 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. ');
5921: RAISE fnd_api.g_exc_error;
5922: END;
5923:

Line 5920: 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. ');

5916: EXCEPTION
5917: WHEN OTHERS
5918: THEN
5919: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5920: 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. ');
5921: RAISE fnd_api.g_exc_error;
5922: END;
5923:
5924: csi_item_instance_pub.update_item_instance

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

5941: );
5942:
5943: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5944: THEN
5945: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5946: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5947: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5948: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5949: fnd_msg_pub.add;

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

5942:
5943: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
5944: THEN
5945: csi_gen_utility_pvt.put_line( 'Error from update relationship API.');
5946: csi_gen_utility_pvt.put_line( 'Call to update_item_instance API for cascade ownership has errored');
5947: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
5948: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
5949: fnd_msg_pub.add;
5950: RAISE fnd_api.g_exc_error;

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

6103: x_return_status := fnd_api.g_ret_sts_success;
6104:
6105: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6106: IF (l_debug_level > 0) THEN
6107: CSI_gen_utility_pvt.put_line( 'expire_relationship');
6108: END IF;
6109:
6110: IF (l_debug_level > 1) THEN
6111:

Line 6112: CSI_gen_utility_pvt.put_line(

6108: END IF;
6109:
6110: IF (l_debug_level > 1) THEN
6111:
6112: CSI_gen_utility_pvt.put_line(
6113: p_api_version ||'-'||
6114: p_commit ||'-'||
6115: p_init_msg_list ||'-'||
6116: p_validation_level

Line 6120: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

6116: p_validation_level
6117: );
6118:
6119: -- dump the relationship query records
6120: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
6121: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);
6122:
6123: END IF;
6124:

Line 6121: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);

6117: );
6118:
6119: -- dump the relationship query records
6120: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
6121: csi_gen_utility_pvt.dump_rel_rec(p_relationship_rec);
6122:
6123: END IF;
6124:
6125: --

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

6320: IF l_instance_rec.instance_id IS NOT NULL AND
6321: l_instance_rec.object_version_number IS NOT NULL AND
6322: l_found
6323: THEN
6324: csi_gen_utility_pvt.put_line('Calling Update II from Exp Rel...');
6325: csi_item_instance_pvt.update_item_instance
6326: ( p_api_version => p_api_version
6327: ,p_commit => p_commit
6328: ,p_init_msg_list => p_init_msg_list

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

7280: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7281:
7282: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
7283: IF (l_csi_debug_level > 0) THEN
7284: csi_gen_utility_pvt.put_line( 'get_inst_relationship_hist');
7285: END IF;
7286:
7287: -- If the debug level = 2 then dump all the parameters values.
7288: IF (l_csi_debug_level > 1) THEN

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

7285: END IF;
7286:
7287: -- If the debug level = 2 then dump all the parameters values.
7288: IF (l_csi_debug_level > 1) THEN
7289: csi_gen_utility_pvt.put_line( 'get_inst_relationship_hist' ||
7290: p_api_version ||'-'||
7291: p_commit ||'-'||
7292: p_init_msg_list ||'-'||
7293: p_validation_level ||'-'||

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

7295: END IF;
7296:
7297: /***** srramakr commented for bug # 3304439
7298: -- Check for the profile option and enable trace
7299: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
7300: -- End enable trace
7301: ****/
7302:
7303: -- Start API body

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

7496: l_instance_id := p_instance_id;
7497: --
7498: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7499: IF (l_debug_level > 0) THEN
7500: CSI_gen_utility_pvt.put_line( 'Get_Cyclic_Node');
7501: END IF;
7502: --
7503: csi_ii_relationships_pvt.get_cyclic_relationships(
7504: p_api_version => 1.0,

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

7521: WHILE l_msg_count > 0 LOOP
7522: x_msg_data := FND_MSG_PUB.GET
7523: ( l_msg_index,
7524: FND_API.G_FALSE );
7525: csi_gen_utility_pvt.put_line( ' Error from Get_cyclic_relationships.. ');
7526: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7527: l_msg_index := l_msg_index + 1;
7528: l_msg_count := l_msg_count - 1;
7529: END LOOP;

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

7522: x_msg_data := FND_MSG_PUB.GET
7523: ( l_msg_index,
7524: FND_API.G_FALSE );
7525: csi_gen_utility_pvt.put_line( ' Error from Get_cyclic_relationships.. ');
7526: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7527: l_msg_index := l_msg_index + 1;
7528: l_msg_count := l_msg_count - 1;
7529: END LOOP;
7530: RAISE FND_API.G_EXC_ERROR;

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

7529: END LOOP;
7530: RAISE FND_API.G_EXC_ERROR;
7531: END IF;
7532: --
7533: csi_gen_utility_pvt.put_line('p_rel_tbl count after get_cyclic_relationships is '
7534: ||to_char(p_rel_tbl.count));
7535: l_rel_tbl_final.DELETE;
7536: l_rel_tbl_final := p_rel_tbl;
7537: p_rel_tbl.DELETE;

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

7557: l_rel_tbl_final.count = 0 THEN
7558: exit;
7559: END IF;
7560: --
7561: csi_gen_utility_pvt.put_line('Processing '||to_char(l_temp_id));
7562: --
7563: FOR rel IN l_rel_tbl_final.FIRST .. l_rel_tbl_final.LAST LOOP
7564: l_found := 0;
7565: l_adj_node := -9999;

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

7603: IF l_rel_color_tbl(color_rec).node_id = l_temp_id AND -- adjacent node
7604: l_rel_color_tbl(color_rec).color_code = 'R' THEN
7605: p_cyclic_node := l_temp_id;
7606: IF nvl(p_stop_at_cyclic,fnd_api.g_true) = fnd_api.g_true THEN
7607: csi_gen_utility_pvt.put_line('Cycle exists at '||to_char(p_cyclic_node));
7608: Raise COMP_ERROR;
7609: END IF;
7610: END IF;
7611: END LOOP;

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

7624: FOR mark in l_rel_color_tbl.FIRST .. l_rel_color_tbl.LAST LOOP
7625: IF l_rel_color_tbl(mark).node_id = l_temp_id THEN
7626: l_rel_color_tbl(mark).color_code := 'B';
7627: l_node_found := 1;
7628: csi_gen_utility_pvt.put_line('Marked '||l_temp_id);
7629: exit;
7630: END IF;
7631: END LOOP;
7632: END IF;

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

7634: IF l_node_found = 0 THEN
7635: l_rel_color_ctr := l_rel_color_ctr + 1;
7636: l_rel_color_tbl(l_rel_color_ctr).node_id := l_temp_id;
7637: l_rel_color_tbl(l_rel_color_ctr).color_code := 'B'; -- since l_found = 0
7638: csi_gen_utility_pvt.put_line('Marked '||l_temp_id);
7639: END IF;
7640: --
7641: -- Get the unmarked node from l_rel_color_tbl in Reverse direction
7642: -- The idea is to go back in the same path once a node is marked as 'B'.

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

7646: exit;
7647: END IF;
7648: END LOOP;
7649: --
7650: csi_gen_utility_pvt.put_line('Adjacent Node is '||l_temp_id);
7651: IF l_temp_id = -9999 THEN
7652: csi_gen_utility_pvt.put_line('Unable to get the Adjacent Node.. Exiting...');
7653: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
7654: END IF;

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

7648: END LOOP;
7649: --
7650: csi_gen_utility_pvt.put_line('Adjacent Node is '||l_temp_id);
7651: IF l_temp_id = -9999 THEN
7652: csi_gen_utility_pvt.put_line('Unable to get the Adjacent Node.. Exiting...');
7653: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
7654: END IF;
7655: END IF; -- l_found = 0 check
7656: END LOOP;

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

7654: END IF;
7655: END IF; -- l_found = 0 check
7656: END LOOP;
7657: END IF;
7658: csi_gen_utility_pvt.put_line('End of Get_Cyclic_Node...');
7659: EXCEPTION
7660: WHEN COMP_ERROR THEN
7661: null;
7662: WHEN FND_API.G_EXC_ERROR THEN