4: PROCEDURE debug(
5: p_message IN varchar2)
6: IS
7: BEGIN
8: csi_t_gen_utility_pvt.add(p_message);
9: END debug;
10:
11: procedure api_log(
12: p_api_name IN varchar2)
11: procedure api_log(
12: p_api_name IN varchar2)
13: IS
14: BEGIN
15: csi_t_gen_utility_pvt.dump_api_info(
16: p_pkg_name => 'csi_cz_int',
17: p_api_name => p_api_name);
18: END api_log;
19:
178:
179: EXCEPTION
180: WHEN fnd_api.g_exc_error THEN
181: x_return_status := fnd_api.g_ret_sts_error;
182: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
183: END get_configuration_revision;
184:
185: --
186: --
596:
597: -- Initialize API return status to success
598: x_return_status := fnd_api.g_ret_sts_success;
599:
600: csi_t_gen_utility_pvt.build_file_name(
601: p_file_segment1 => 'csilock',
602: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
603:
604: api_log('lock_item_instance');
737:
738: debug('Before call to csi_item_instance_pvt.lock_item_instances');
739: debug('Records count to be locked '||nvl(l_config_tbl.count,0));
740:
741: csi_t_gen_utility_pvt.dump_api_info(
742: p_pkg_name => 'csi_item_instance_pvt',
743: p_api_name => 'lock_item_instance');
744:
745: csi_t_gen_utility_pvt.dump_csi_config_tbl(
741: csi_t_gen_utility_pvt.dump_api_info(
742: p_pkg_name => 'csi_item_instance_pvt',
743: p_api_name => 'lock_item_instance');
744:
745: csi_t_gen_utility_pvt.dump_csi_config_tbl(
746: p_config_tbl => l_config_tbl);
747:
748: -- Call to core API for Locking
749: csi_item_instance_pvt.lock_item_instances(
795:
796: EXCEPTION
797: WHEN fnd_api.g_exc_error THEN
798: x_return_status := fnd_api.g_ret_sts_error;
799: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
800: FND_MSG_PUB.Count_And_Get
801: (p_count => x_msg_count ,
802: p_data => x_msg_data );
803: rollback to csi_cz_lock_item;
809: FND_MSG_PUB.Count_And_Get
810: (p_count => x_msg_count ,
811: p_data => x_msg_data );
812: x_return_status := fnd_api.g_ret_sts_error;
813: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
814: rollback to csi_cz_lock_item;
815: debug(l_return_message);
816: END lock_item_instances;
817:
1117: l_config_tbl(l_child_ind) := p_config_rec;
1118: l_config_tbl(l_child_ind).lock_status := 0;
1119: END IF;
1120: --
1121: csi_t_gen_utility_pvt.dump_api_info(
1122: p_pkg_name => 'csi_item_instance_pvt',
1123: p_api_name => 'unlock_item_instance');
1124:
1125: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1121: csi_t_gen_utility_pvt.dump_api_info(
1122: p_pkg_name => 'csi_item_instance_pvt',
1123: p_api_name => 'unlock_item_instance');
1124:
1125: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1126: p_config_tbl => l_config_tbl);
1127:
1128: csi_item_instance_pvt.unlock_item_instances(
1129: p_api_version => 1.0,
1142: END IF;
1143: EXCEPTION
1144: WHEN fnd_api.g_exc_error THEN
1145: x_return_status := fnd_api.g_ret_sts_error;
1146: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1147: FND_MSG_PUB.Count_And_Get
1148: (p_count => x_msg_count ,
1149: p_data => x_msg_data );
1150: rollback to unlock_current_node;
1156: FND_MSG_PUB.Count_And_Get
1157: (p_count => x_msg_count ,
1158: p_data => x_msg_data );
1159: x_return_status := fnd_api.g_ret_sts_error;
1160: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1161: rollback to unlock_current_node;
1162: debug(l_return_message);
1163: END Unlock_Current_Node;
1164:
1281: debug('Before call to csi_item_instance_pvt.unlock_item_instances');
1282: debug('Record count passed to api '||nvl(l_all_config_tbl.count,0));
1283:
1284:
1285: csi_t_gen_utility_pvt.dump_api_info(
1286: p_pkg_name => 'csi_item_instance_pvt',
1287: p_api_name => 'unlock_item_instance');
1288:
1289: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1285: csi_t_gen_utility_pvt.dump_api_info(
1286: p_pkg_name => 'csi_item_instance_pvt',
1287: p_api_name => 'unlock_item_instance');
1288:
1289: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1290: p_config_tbl => l_all_config_tbl);
1291:
1292: csi_item_instance_pvt.unlock_item_instances(
1293: p_api_version => 1.0,
1392:
1393: EXCEPTION
1394: WHEN fnd_api.g_exc_error THEN
1395: x_return_status := fnd_api.g_ret_sts_error;
1396: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1397: FND_MSG_PUB.Count_And_Get
1398: (p_count => x_msg_count ,
1399: p_data => x_msg_data );
1400: rollback to csi_cz_unlock_item;
1406: FND_MSG_PUB.Count_And_Get
1407: (p_count => x_msg_count ,
1408: p_data => x_msg_data );
1409: x_return_status := fnd_api.g_ret_sts_error;
1410: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1411: rollback to csi_cz_unlock_item;
1412: debug(l_return_message);
1413:
1414:
1452: BEGIN
1453:
1454: x_return_status := fnd_api.g_ret_sts_success;
1455:
1456: csi_t_gen_utility_pvt.build_file_name(
1457: p_file_segment1 => 'csiczuii',
1458: p_file_segment2 => p_session_hdr_id);
1459:
1460: debug('Re-Configure from Install Base HTML User Interface');
1532:
1533: rollback to configure_from_html_ui;
1534:
1535: x_return_status := fnd_api.g_ret_sts_error;
1536: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1537: x_msg_data := x_error_message;
1538: x_msg_count := 1;
1539: WHEN others THEN
1540: