DBA Data[Home] [Help]

APPS.CSI_FA_INSTANCE_GRP dependencies on FND_MESSAGE

Line 132: fnd_message.set_name('CSI', 'CSI_INST_ASSET_AC_INVALID');

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;

Line 133: fnd_message.set_token('INST_NUM', l_inst_num);

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;

Line 134: fnd_message.set_token('AC_CODE', l_acct_class_code);

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:

Line 140: fnd_message.set_name('CSI', 'CSI_INST_ASSET_LOC_INVALID');

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;

Line 141: fnd_message.set_token('INST_NUM', l_inst_num);

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;

Line 142: fnd_message.set_token('LOC_CODE', l_location_type_code);

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:

Line 168: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_TXN');

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;

Line 169: fnd_message.set_token('TXN_ID', l_pending_txn_id);

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:

Line 183: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_MASSADD');

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;

Line 184: fnd_message.set_token('MASS_ADD_ID', l_fa_mass_add_id);

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:

Line 202: fnd_message.set_name('CSI', 'CSI_SRL_DUP_FA_ERROR');

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;

Line 203: fnd_message.set_token('INST_ID', px_inst_asset_rec.instance_id);

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;

Line 204: fnd_message.set_token('ASSET_ID', uniq_fa_rec.fa_asset_id);

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:

Line 742: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');

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;

Line 756: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

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;

Line 757: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');

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;

Line 758: fnd_message.set_token('SQL_ERROR',SQLERRM);

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:

Line 1178: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

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;

Line 1179: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');

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;

Line 1180: fnd_message.set_token('SQL_ERROR',SQLERRM);

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:

Line 1308: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

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;

Line 1309: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');

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;

Line 1310: fnd_message.set_token('SQL_ERROR',SQLERRM);

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:

Line 1386: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');

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;

Line 1398: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

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;

Line 1399: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');

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;

Line 1400: fnd_message.set_token('SQL_ERROR',SQLERRM);

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:

Line 1518: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');

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