2093: END LOOP;
2094: END IF;
2095:
2096: api_log(
2097: p_pkg_name => 'csi_ii_relationships_pub',
2098: p_api_name => 'create_relationship');
2099:
2100: csi_ii_relationships_pub.create_relationship(
2101: p_api_version => 1.0,
2096: api_log(
2097: p_pkg_name => 'csi_ii_relationships_pub',
2098: p_api_name => 'create_relationship');
2099:
2100: csi_ii_relationships_pub.create_relationship(
2101: p_api_version => 1.0,
2102: p_commit => fnd_api.g_false,
2103: p_init_msg_list => fnd_api.g_true,
2104: p_validation_level => fnd_api.g_valid_level_full,
2108: x_msg_count => l_msg_count,
2109: x_msg_data => l_msg_data);
2110:
2111: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2112: debug('Error in csi_ii_relationships_pub.create_relationship.');
2113: RAISE fnd_api.g_exc_error;
2114: END IF;
2115:
2116:
6641: debug('create_relationship.COUNT :'||l_c_iir_tbl.COUNT);
6642:
6643: IF l_c_iir_tbl.COUNT > 0 THEN
6644: api_log(
6645: p_pkg_name => 'csi_ii_relationships_pub',
6646: p_api_name => 'create_relationship');
6647:
6648: csi_ii_relationships_pub.create_relationship(
6649: p_api_version => 1.0,
6644: api_log(
6645: p_pkg_name => 'csi_ii_relationships_pub',
6646: p_api_name => 'create_relationship');
6647:
6648: csi_ii_relationships_pub.create_relationship(
6649: p_api_version => 1.0,
6650: p_commit => fnd_api.g_false,
6651: p_init_msg_list => fnd_api.g_true,
6652: p_validation_level => fnd_api.g_valid_level_full,
6664: debug('update_relationship.COUNT :'||l_u_iir_tbl.COUNT);
6665:
6666: IF l_u_iir_tbl.COUNT > 0 THEN
6667: api_log(
6668: p_pkg_name => 'csi_ii_relationships_pub',
6669: p_api_name => 'update_relationship');
6670:
6671: debug('No code here yet for update relationship...');
6672:
6860: debug('total components : '||l_ii_rltns_tbl.COUNT);
6861:
6862: IF l_ii_rltns_tbl.COUNT > 0 THEN
6863:
6864: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');
6865:
6866: csi_ii_relationships_pub.create_relationship(
6867: p_api_version => 1.0,
6868: p_commit => fnd_api.g_false,
6862: IF l_ii_rltns_tbl.COUNT > 0 THEN
6863:
6864: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');
6865:
6866: csi_ii_relationships_pub.create_relationship(
6867: p_api_version => 1.0,
6868: p_commit => fnd_api.g_false,
6869: p_init_msg_list => fnd_api.g_true,
6870: p_validation_level => fnd_api.g_valid_level_full,