DBA Data[Home] [Help]

APPS.CSI_CZ_INT dependencies on CSI_ITEM_INSTANCE_PVT

Line 530: l_locked := csi_item_instance_pvt.check_item_instance_lock(

526: l_locked BOOLEAN := FALSE;
527: Begin
528: x_return_status := fnd_api.g_ret_sts_success;
529:
530: l_locked := csi_item_instance_pvt.check_item_instance_lock(
531: p_config_inst_hdr_id => p_config_rec.config_inst_hdr_id,
532: p_config_inst_item_id => p_config_rec.config_inst_item_id,
533: p_config_inst_rev_num => p_config_rec.config_inst_rev_num,
534: p_instance_id => p_config_rec.instance_id);

Line 738: debug('Before call to csi_item_instance_pvt.lock_item_instances');

734: END LOOP; -- End Loop for the cild keys
735: END LOOP; -- End Loop for Root Keys
736: END IF;
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',

Line 742: p_pkg_name => 'csi_item_instance_pvt',

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(
746: p_config_tbl => l_config_tbl);

Line 749: csi_item_instance_pvt.lock_item_instances(

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(
750: p_api_version => 1.0,
751: p_commit => fnd_api.g_false,
752: p_init_msg_list => fnd_api.g_true,
753: p_validation_level => fnd_api.g_valid_level_full,

Line 760: debug('Failed csi_item_instance_pvt.lock_item_instance');

756: x_msg_count => x_msg_count,
757: x_msg_data => x_msg_data);
758:
759: IF x_return_status <> fnd_api.g_ret_sts_success THEN
760: debug('Failed csi_item_instance_pvt.lock_item_instance');
761: RAISE fnd_api.g_exc_error;
762: END IF;
763:
764: -- Assigningrequired values to px_config keys

Line 1122: p_pkg_name => 'csi_item_instance_pvt',

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(
1126: p_config_tbl => l_config_tbl);

Line 1128: csi_item_instance_pvt.unlock_item_instances(

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,
1130: p_commit => fnd_api.g_false,
1131: p_init_msg_list => fnd_api.g_true,
1132: p_validation_level => fnd_api.g_valid_level_full,

Line 1140: debug('Failed csi_item_instance_pvt.unlock_item_instance');

1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138:
1139: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1140: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1141: RAISE fnd_api.g_exc_error;
1142: END IF;
1143: EXCEPTION
1144: WHEN fnd_api.g_exc_error THEN

Line 1281: debug('Before call to csi_item_instance_pvt.unlock_item_instances');

1277: l_all_config_tbl(i).lock_id := l_lock_config_rec.lock_id;
1278: l_all_config_tbl(i).lock_status := 0;
1279: END LOOP;
1280:
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(

Line 1286: p_pkg_name => 'csi_item_instance_pvt',

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(
1290: p_config_tbl => l_all_config_tbl);

Line 1292: csi_item_instance_pvt.unlock_item_instances(

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,
1294: p_commit => fnd_api.g_false,
1295: p_init_msg_list => fnd_api.g_true,
1296: p_validation_level => fnd_api.g_valid_level_full,

Line 1304: debug('Failed csi_item_instance_pvt.unlock_item_instance');

1300: x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data);
1302:
1303: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1304: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1305: RAISE fnd_api.g_exc_error;
1306: END IF;
1307: END IF;
1308: ******** END OF COMMENT *******/