128: FROM csi_item_instances
129: WHERE instance_id = px_inst_asset_rec.instance_id;
130:
131: IF l_acct_class_code = 'CUST_PROD' THEN
132: fnd_message.set_name('CSI', 'CSI_INST_ASSET_AC_INVALID');
133: fnd_message.set_token('INST_NUM', l_inst_num);
134: fnd_message.set_token('AC_CODE', l_acct_class_code);
135: fnd_msg_pub.add;
136: RAISE fnd_api.g_exc_error;
129: WHERE instance_id = px_inst_asset_rec.instance_id;
130:
131: IF l_acct_class_code = 'CUST_PROD' THEN
132: fnd_message.set_name('CSI', 'CSI_INST_ASSET_AC_INVALID');
133: fnd_message.set_token('INST_NUM', l_inst_num);
134: fnd_message.set_token('AC_CODE', l_acct_class_code);
135: fnd_msg_pub.add;
136: RAISE fnd_api.g_exc_error;
137: END IF;
130:
131: IF l_acct_class_code = 'CUST_PROD' THEN
132: fnd_message.set_name('CSI', 'CSI_INST_ASSET_AC_INVALID');
133: fnd_message.set_token('INST_NUM', l_inst_num);
134: fnd_message.set_token('AC_CODE', l_acct_class_code);
135: fnd_msg_pub.add;
136: RAISE fnd_api.g_exc_error;
137: END IF;
138:
136: RAISE fnd_api.g_exc_error;
137: END IF;
138:
139: IF l_location_type_code in ('WIP', 'PROJECT', 'IN_TRANSIT') THEN
140: fnd_message.set_name('CSI', 'CSI_INST_ASSET_LOC_INVALID');
141: fnd_message.set_token('INST_NUM', l_inst_num);
142: fnd_message.set_token('LOC_CODE', l_location_type_code);
143: fnd_msg_pub.add;
144: RAISE fnd_api.g_exc_error;
137: END IF;
138:
139: IF l_location_type_code in ('WIP', 'PROJECT', 'IN_TRANSIT') THEN
140: fnd_message.set_name('CSI', 'CSI_INST_ASSET_LOC_INVALID');
141: fnd_message.set_token('INST_NUM', l_inst_num);
142: fnd_message.set_token('LOC_CODE', l_location_type_code);
143: fnd_msg_pub.add;
144: RAISE fnd_api.g_exc_error;
145: END IF;
138:
139: IF l_location_type_code in ('WIP', 'PROJECT', 'IN_TRANSIT') THEN
140: fnd_message.set_name('CSI', 'CSI_INST_ASSET_LOC_INVALID');
141: fnd_message.set_token('INST_NUM', l_inst_num);
142: fnd_message.set_token('LOC_CODE', l_location_type_code);
143: fnd_msg_pub.add;
144: RAISE fnd_api.g_exc_error;
145: END IF;
146:
164: exit;
165: END LOOP;
166:
167: IF l_pending_txn THEN
168: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_TXN');
169: fnd_message.set_token('TXN_ID', l_pending_txn_id);
170: fnd_msg_pub.add;
171: RAISE fnd_api.g_exc_error;
172: END IF;
165: END LOOP;
166:
167: IF l_pending_txn THEN
168: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_TXN');
169: fnd_message.set_token('TXN_ID', l_pending_txn_id);
170: fnd_msg_pub.add;
171: RAISE fnd_api.g_exc_error;
172: END IF;
173:
179: exit;
180: END LOOP;
181:
182: IF l_pending_mass_add THEN
183: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_MASSADD');
184: fnd_message.set_token('MASS_ADD_ID', l_fa_mass_add_id);
185: fnd_msg_pub.add;
186: RAISE fnd_api.g_exc_error;
187: END IF;
180: END LOOP;
181:
182: IF l_pending_mass_add THEN
183: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_MASSADD');
184: fnd_message.set_token('MASS_ADD_ID', l_fa_mass_add_id);
185: fnd_msg_pub.add;
186: RAISE fnd_api.g_exc_error;
187: END IF;
188:
198: IF nvl(px_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
199: -- create case
200: FOR uniq_fa_rec IN uniq_fa_cur(px_inst_asset_rec.instance_id)
201: LOOP
202: fnd_message.set_name('CSI', 'CSI_SRL_DUP_FA_ERROR');
203: fnd_message.set_token('INST_ID', px_inst_asset_rec.instance_id);
204: fnd_message.set_token('ASSET_ID', uniq_fa_rec.fa_asset_id);
205: fnd_msg_pub.add;
206: raise fnd_api.g_exc_error;
199: -- create case
200: FOR uniq_fa_rec IN uniq_fa_cur(px_inst_asset_rec.instance_id)
201: LOOP
202: fnd_message.set_name('CSI', 'CSI_SRL_DUP_FA_ERROR');
203: fnd_message.set_token('INST_ID', px_inst_asset_rec.instance_id);
204: fnd_message.set_token('ASSET_ID', uniq_fa_rec.fa_asset_id);
205: fnd_msg_pub.add;
206: raise fnd_api.g_exc_error;
207: END LOOP;
200: FOR uniq_fa_rec IN uniq_fa_cur(px_inst_asset_rec.instance_id)
201: LOOP
202: fnd_message.set_name('CSI', 'CSI_SRL_DUP_FA_ERROR');
203: fnd_message.set_token('INST_ID', px_inst_asset_rec.instance_id);
204: fnd_message.set_token('ASSET_ID', uniq_fa_rec.fa_asset_id);
205: fnd_msg_pub.add;
206: raise fnd_api.g_exc_error;
207: END LOOP;
208:
738: END LOOP;
739: END IF;
740:
741: IF l_warning_flag = 'Y' THEN
742: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');
743: fnd_msg_pub.add;
744: x_return_status := 'W';
745: x_error_message := dump_error_stack;
746: END IF;
752: x_error_message := dump_error_stack;
753: WHEN others THEN
754: rollback to fa_grp_create_instance;
755: x_return_status := fnd_api.g_ret_sts_unexp_error;
756: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
757: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
758: fnd_message.set_token('SQL_ERROR',SQLERRM);
759: fnd_msg_pub.add;
760: x_error_message := dump_error_stack;
753: WHEN others THEN
754: rollback to fa_grp_create_instance;
755: x_return_status := fnd_api.g_ret_sts_unexp_error;
756: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
757: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
758: fnd_message.set_token('SQL_ERROR',SQLERRM);
759: fnd_msg_pub.add;
760: x_error_message := dump_error_stack;
761: END create_item_instance;
754: rollback to fa_grp_create_instance;
755: x_return_status := fnd_api.g_ret_sts_unexp_error;
756: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
757: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
758: fnd_message.set_token('SQL_ERROR',SQLERRM);
759: fnd_msg_pub.add;
760: x_error_message := dump_error_stack;
761: END create_item_instance;
762:
1174: x_error_message := dump_error_stack;
1175: WHEN others THEN
1176: rollback to fa_grp_copy_instance;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1179: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1180: fnd_message.set_token('SQL_ERROR',SQLERRM);
1181: fnd_msg_pub.add;
1182: x_error_message := dump_error_stack;
1175: WHEN others THEN
1176: rollback to fa_grp_copy_instance;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1179: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1180: fnd_message.set_token('SQL_ERROR',SQLERRM);
1181: fnd_msg_pub.add;
1182: x_error_message := dump_error_stack;
1183: END copy_item_instance;
1176: rollback to fa_grp_copy_instance;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1179: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1180: fnd_message.set_token('SQL_ERROR',SQLERRM);
1181: fnd_msg_pub.add;
1182: x_error_message := dump_error_stack;
1183: END copy_item_instance;
1184:
1304: x_return_status := fnd_api.g_ret_sts_error;
1305: x_error_message := dump_error_stack;
1306: WHEN others THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;
1308: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1309: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1310: fnd_message.set_token('SQL_ERROR',SQLERRM);
1311: fnd_msg_pub.add;
1312: x_error_message := dump_error_stack;
1305: x_error_message := dump_error_stack;
1306: WHEN others THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;
1308: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1309: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1310: fnd_message.set_token('SQL_ERROR',SQLERRM);
1311: fnd_msg_pub.add;
1312: x_error_message := dump_error_stack;
1313: END associate_item_instance;
1306: WHEN others THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;
1308: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1309: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1310: fnd_message.set_token('SQL_ERROR',SQLERRM);
1311: fnd_msg_pub.add;
1312: x_error_message := dump_error_stack;
1313: END associate_item_instance;
1314:
1382:
1383: END IF;
1384:
1385: IF l_warning_flag = 'Y' THEN
1386: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');
1387: fnd_msg_pub.add;
1388: x_return_status := 'W';
1389: x_error_message := dump_error_stack;
1390: END IF;
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: x_error_message := dump_error_stack;
1396: WHEN others THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1399: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1400: fnd_message.set_token('SQL_ERROR',SQLERRM);
1401: fnd_msg_pub.add;
1402: x_error_message := dump_error_stack;
1395: x_error_message := dump_error_stack;
1396: WHEN others THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1399: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1400: fnd_message.set_token('SQL_ERROR',SQLERRM);
1401: fnd_msg_pub.add;
1402: x_error_message := dump_error_stack;
1403: END update_asset_association;
1396: WHEN others THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1399: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1400: fnd_message.set_token('SQL_ERROR',SQLERRM);
1401: fnd_msg_pub.add;
1402: x_error_message := dump_error_stack;
1403: END update_asset_association;
1404:
1514:
1515: END IF;
1516:
1517: IF l_warning_flag = 'Y' THEN
1518: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');
1519: fnd_msg_pub.add;
1520: x_return_status := 'W';
1521: x_error_message := dump_error_stack;
1522: ELSE