[Home] [Help]
9: PROCEDURE debug(
10: p_message IN varchar2)
11: IS
12: BEGIN
13: csi_t_gen_utility_pvt.add(p_message);
14: END debug;
15:
16:
17: PROCEDURE CREATE_MASS_EDIT_BATCH
127:
128: debug('Sub_type_id= '||l_sub_type_id);
129: debug('px_mass_edit_inst_tbl count: '||px_mass_edit_inst_tbl.count);
130:
131: csi_t_gen_utility_pvt.dump_txn_line_rec(
132: p_txn_line_rec => px_txn_line_rec);
133:
134: l_source_txn_type_id := px_txn_line_rec.source_transaction_type_id;
135: l_source_txn_table := px_txn_line_rec.source_transaction_table;
156: END IF ;
157: END LOOP ;
158: END IF;
159:
160: csi_t_gen_utility_pvt.dump_mass_edit_rec(px_mass_edit_rec);
161:
162: -- Insert row in CSI_MASS_EDIT_ENTRIES table and CSI_T_TRANSACITON_LINES AND CSI_T_TRANSACTION_LINE_DETAILS
163:
164: CSI_MASS_EDIT_ENTRIES_B_PKG.Insert_Row(
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: END IF;
913:
914: csi_t_gen_utility_pvt.dump_mass_edit_rec(px_mass_edit_rec);
915:
916: -- Validate that the status of the batch is NOT Processed or Successful
917: validate_batch_status(p_batch_id => px_mass_edit_rec.entry_id,
918: x_mass_edit_error_tbl => l_mass_edit_error_tbl);
952: pty_idx := nvl(l_txn_party_detail_tbl.last,0) + 1;
953: ptyacc_idx := nvl(l_txn_pty_acct_detail_tbl.last,0) + 1;
954: END IF;
955:
956: csi_t_gen_utility_pvt.dump_txn_tables(
957: p_ids_or_index_based => 'I',
958: p_line_detail_tbl => l_txn_line_detail_tbl,
959: p_party_detail_tbl => l_txn_party_detail_tbl,
960: p_pty_acct_tbl => l_txn_pty_acct_detail_tbl,
1146: END IF; -- mass_edit_inst.count > 0
1147:
1148: -- call the Update API
1149: debug('Calling csi_t_txn_details_grp.update_transaction_dtls API');
1150: csi_t_gen_utility_pvt.dump_txn_line_rec(l_txn_line_rec);
1151: debug('l_txn_line_detail_tbl count: '||l_txn_line_detail_tbl.count);
1152: debug('l_txn_party_detail_tbl count: '||l_txn_party_detail_tbl.count);
1153: debug('l_txn_pty_acct_detail_tbl count: '||l_txn_pty_acct_detail_tbl.count);
1154:
1394: FND_MSG_PUB.Count_And_Get (
1395: p_count => x_msg_count,
1396: p_data => x_msg_data);
1397:
1398: csi_t_gen_utility_pvt.set_debug_off;
1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1401:
1402: ROLLBACK TO Delete_Mass_Edit_Batch_pvt;
1405: FND_MSG_PUB.Count_And_Get(
1406: p_count => x_msg_count,
1407: p_data => x_msg_data);
1408:
1409: csi_t_gen_utility_pvt.set_debug_off;
1410:
1411: WHEN OTHERS THEN
1412:
1413: ROLLBACK TO Delete_Mass_Edit_Batch_pvt;
1425: FND_MSG_PUB.Count_And_Get(
1426: p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:
1429: csi_t_gen_utility_pvt.set_debug_off;
1430:
1431: END Delete_Mass_Edit_Batch;
1432:
1433:
1574: FND_MSG_PUB.Count_And_Get (
1575: p_count => x_msg_count,
1576: p_data => x_msg_data);
1577:
1578: csi_t_gen_utility_pvt.set_debug_off;
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581:
1582: ROLLBACK TO Get_mass_edit_details_pvt;
1585: FND_MSG_PUB.Count_And_Get(
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588:
1589: csi_t_gen_utility_pvt.set_debug_off;
1590:
1591: WHEN OTHERS THEN
1592:
1593: ROLLBACK TO Get_mass_edit_details_pvt;
1605: FND_MSG_PUB.Count_And_Get(
1606: p_count => x_msg_count,
1607: p_data => x_msg_data);
1608:
1609: csi_t_gen_utility_pvt.set_debug_off;
1610:
1611: END Get_mass_edit_details;
1612:
1613: PROCEDURE vld_item_instance_active (p_instance_id_tab IN NumTabType,
2329: AND cil.instance_id = cii.instance_id;
2330:
2331: BEGIN
2332:
2333: csi_t_gen_utility_pvt.add('In VALIDATE_BATCH');
2334:
2335: -- Initialize message list if p_init_msg_list is set to TRUE.
2336: IF FND_API.To_Boolean( l_init_msg_list ) THEN
2337: FND_MSG_PUB.Initialize;