131: begin
132:
133: csi_t_gen_utility_pvt.dump_api_info(
134: p_api_name => 'insert_row',
135: p_pkg_name => 'csi_t_org_assignments_pkg');
136:
137: csi_t_org_assignments_pkg.insert_row(
138: px_txn_operating_unit_id => l_txn_operating_unit_id,
139: p_txn_line_detail_id => p_txn_org_assgn_rec.txn_line_detail_id,
133: csi_t_gen_utility_pvt.dump_api_info(
134: p_api_name => 'insert_row',
135: p_pkg_name => 'csi_t_org_assignments_pkg');
136:
137: csi_t_org_assignments_pkg.insert_row(
138: px_txn_operating_unit_id => l_txn_operating_unit_id,
139: p_txn_line_detail_id => p_txn_org_assgn_rec.txn_line_detail_id,
140: p_operating_unit_id => p_txn_org_assgn_rec.operating_unit_id,
141: p_relationship_type_code => p_txn_org_assgn_rec.relationship_type_code,
169: exception
170: when others then
171: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
172: fnd_message.set_token('MESSAGE',
173: 'csi_t_org_assignments_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
174: fnd_msg_pub.add;
175: raise fnd_api.g_exc_error;
176: end;
177:
427: --debug info
428: begin
429:
430: csi_t_gen_utility_pvt.dump_api_info(
431: p_pkg_name => 'csi_t_org_assignments_pkg',
432: p_api_name => 'update_row');
433:
434: csi_t_org_assignments_pkg.update_row(
435: p_txn_operating_unit_id => l_ou_rec.txn_operating_unit_id,
430: csi_t_gen_utility_pvt.dump_api_info(
431: p_pkg_name => 'csi_t_org_assignments_pkg',
432: p_api_name => 'update_row');
433:
434: csi_t_org_assignments_pkg.update_row(
435: p_txn_operating_unit_id => l_ou_rec.txn_operating_unit_id,
436: p_txn_line_detail_id => l_ou_rec.txn_line_detail_id,
437: p_operating_unit_id => l_ou_rec.operating_unit_id,
438: p_relationship_type_code=> l_ou_rec.relationship_type_code,
466: exception
467: when others then
468: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
469: fnd_message.set_token('MESSAGE',
470: 'csi_t_org_assignments_pkg.update_row failed. '||substr(sqlerrm,1,200));
471: fnd_msg_pub.add;
472: raise fnd_api.g_exc_error;
473: end;
474:
614:
615: --debug info
616: csi_t_gen_utility_pvt.dump_api_info(
617: p_api_name => 'delete_row',
618: p_pkg_name => 'csi_t_org_assignments_pkg');
619:
620: csi_t_org_assignments_pkg.delete_row(
621: p_txn_operating_unit_id => l_txn_ou_id);
622:
616: csi_t_gen_utility_pvt.dump_api_info(
617: p_api_name => 'delete_row',
618: p_pkg_name => 'csi_t_org_assignments_pkg');
619:
620: csi_t_org_assignments_pkg.delete_row(
621: p_txn_operating_unit_id => l_txn_ou_id);
622:
623: ELSE
624:
647: LOOP
648:
649: csi_t_gen_utility_pvt.dump_api_info(
650: p_api_name => 'delete_row',
651: p_pkg_name => 'csi_t_org_assignments_pkg');
652:
653: csi_t_org_assignments_pkg.delete_row(
654: p_txn_operating_unit_id => ou_rec.txn_operating_unit_id);
655:
649: csi_t_gen_utility_pvt.dump_api_info(
650: p_api_name => 'delete_row',
651: p_pkg_name => 'csi_t_org_assignments_pkg');
652:
653: csi_t_org_assignments_pkg.delete_row(
654: p_txn_operating_unit_id => ou_rec.txn_operating_unit_id);
655:
656: END LOOP;
657: