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 750: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');

746: END LOOP;
747: END IF;
748:
749: IF l_warning_flag = 'Y' THEN
750: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');
751: fnd_msg_pub.add;
752: x_return_status := 'W';
753: x_error_message := dump_error_stack;
754: END IF;

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

775: x_error_message := dump_error_stack;
776: WHEN others THEN
777: rollback to fa_grp_create_instance;
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
780: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
781: fnd_message.set_token('SQL_ERROR',SQLERRM);
782: fnd_msg_pub.add;
783: x_error_message := dump_error_stack;

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

776: WHEN others THEN
777: rollback to fa_grp_create_instance;
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
780: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
781: fnd_message.set_token('SQL_ERROR',SQLERRM);
782: fnd_msg_pub.add;
783: x_error_message := dump_error_stack;
784: END create_item_instance;

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

777: rollback to fa_grp_create_instance;
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
780: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
781: fnd_message.set_token('SQL_ERROR',SQLERRM);
782: fnd_msg_pub.add;
783: x_error_message := dump_error_stack;
784: END create_item_instance;
785:

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

1199: x_error_message := dump_error_stack;
1200: WHEN others THEN
1201: rollback to fa_grp_copy_instance;
1202: x_return_status := fnd_api.g_ret_sts_unexp_error;
1203: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1204: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1205: fnd_message.set_token('SQL_ERROR',SQLERRM);
1206: fnd_msg_pub.add;
1207: x_error_message := dump_error_stack;

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

1200: WHEN others THEN
1201: rollback to fa_grp_copy_instance;
1202: x_return_status := fnd_api.g_ret_sts_unexp_error;
1203: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1204: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1205: fnd_message.set_token('SQL_ERROR',SQLERRM);
1206: fnd_msg_pub.add;
1207: x_error_message := dump_error_stack;
1208: END copy_item_instance;

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

1201: rollback to fa_grp_copy_instance;
1202: x_return_status := fnd_api.g_ret_sts_unexp_error;
1203: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1204: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1205: fnd_message.set_token('SQL_ERROR',SQLERRM);
1206: fnd_msg_pub.add;
1207: x_error_message := dump_error_stack;
1208: END copy_item_instance;
1209:

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

1329: x_return_status := fnd_api.g_ret_sts_error;
1330: x_error_message := dump_error_stack;
1331: WHEN others THEN
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1334: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1335: fnd_message.set_token('SQL_ERROR',SQLERRM);
1336: fnd_msg_pub.add;
1337: x_error_message := dump_error_stack;

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

1330: x_error_message := dump_error_stack;
1331: WHEN others THEN
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1334: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1335: fnd_message.set_token('SQL_ERROR',SQLERRM);
1336: fnd_msg_pub.add;
1337: x_error_message := dump_error_stack;
1338: END associate_item_instance;

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

1331: WHEN others THEN
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1334: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1335: fnd_message.set_token('SQL_ERROR',SQLERRM);
1336: fnd_msg_pub.add;
1337: x_error_message := dump_error_stack;
1338: END associate_item_instance;
1339:

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

1407:
1408: END IF;
1409:
1410: IF l_warning_flag = 'Y' THEN
1411: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');
1412: fnd_msg_pub.add;
1413: x_return_status := 'W';
1414: x_error_message := dump_error_stack;
1415: END IF;

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

1419: x_return_status := fnd_api.g_ret_sts_error;
1420: x_error_message := dump_error_stack;
1421: WHEN others THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;
1423: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1424: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1425: fnd_message.set_token('SQL_ERROR',SQLERRM);
1426: fnd_msg_pub.add;
1427: x_error_message := dump_error_stack;

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

1420: x_error_message := dump_error_stack;
1421: WHEN others THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;
1423: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1424: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1425: fnd_message.set_token('SQL_ERROR',SQLERRM);
1426: fnd_msg_pub.add;
1427: x_error_message := dump_error_stack;
1428: END update_asset_association;

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

1421: WHEN others THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;
1423: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1424: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1425: fnd_message.set_token('SQL_ERROR',SQLERRM);
1426: fnd_msg_pub.add;
1427: x_error_message := dump_error_stack;
1428: END update_asset_association;
1429:

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

1539:
1540: END IF;
1541:
1542: IF l_warning_flag = 'Y' THEN
1543: fnd_message.set_name('CSI', 'CSI_INST_ASSET_SYNC_WARNING');
1544: fnd_msg_pub.add;
1545: x_return_status := 'W';
1546: x_error_message := dump_error_stack;
1547: ELSE