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 1163: p_pkg_name => 'csi_item_instance_pvt',

1159: l_config_tbl(l_child_ind).lock_status := 0;
1160: END IF;
1161: --
1162: csi_t_gen_utility_pvt.dump_api_info(
1163: p_pkg_name => 'csi_item_instance_pvt',
1164: p_api_name => 'unlock_item_instance');
1165:
1166: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1167: p_config_tbl => l_config_tbl);

Line 1169: csi_item_instance_pvt.unlock_item_instances(

1165:
1166: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1167: p_config_tbl => l_config_tbl);
1168:
1169: csi_item_instance_pvt.unlock_item_instances(
1170: p_api_version => 1.0,
1171: p_commit => fnd_api.g_false,
1172: p_init_msg_list => fnd_api.g_true,
1173: p_validation_level => fnd_api.g_valid_level_full,

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

1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data);
1179:
1180: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1181: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184: EXCEPTION
1185: WHEN fnd_api.g_exc_error THEN

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

1318: l_all_config_tbl(i).lock_id := l_lock_config_rec.lock_id;
1319: l_all_config_tbl(i).lock_status := 0;
1320: END LOOP;
1321:
1322: debug('Before call to csi_item_instance_pvt.unlock_item_instances');
1323: debug('Record count passed to api '||nvl(l_all_config_tbl.count,0));
1324:
1325:
1326: csi_t_gen_utility_pvt.dump_api_info(

Line 1327: p_pkg_name => 'csi_item_instance_pvt',

1323: debug('Record count passed to api '||nvl(l_all_config_tbl.count,0));
1324:
1325:
1326: csi_t_gen_utility_pvt.dump_api_info(
1327: p_pkg_name => 'csi_item_instance_pvt',
1328: p_api_name => 'unlock_item_instance');
1329:
1330: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1331: p_config_tbl => l_all_config_tbl);

Line 1333: csi_item_instance_pvt.unlock_item_instances(

1329:
1330: csi_t_gen_utility_pvt.dump_csi_config_tbl(
1331: p_config_tbl => l_all_config_tbl);
1332:
1333: csi_item_instance_pvt.unlock_item_instances(
1334: p_api_version => 1.0,
1335: p_commit => fnd_api.g_false,
1336: p_init_msg_list => fnd_api.g_true,
1337: p_validation_level => fnd_api.g_valid_level_full,

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

1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data);
1343:
1344: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1345: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1346: RAISE fnd_api.g_exc_error;
1347: END IF;
1348: END IF;
1349: ******** END OF COMMENT *******/