DBA Data[Home] [Help]

APPS.CSI_FA_INSTANCE_GRP dependencies on FND_MSG_PUB

Line 19: fnd_msg_pub.count_and_get(

15: l_msg_index_out number;
16: x_msg_data varchar2(4000);
17: BEGIN
18: x_msg_data := null;
19: fnd_msg_pub.count_and_get(
20: p_count => l_msg_count,
21: p_data => l_msg_data);
22:
23: FOR l_ind IN 1..l_msg_count

Line 25: fnd_msg_pub.get(

21: p_data => l_msg_data);
22:
23: FOR l_ind IN 1..l_msg_count
24: LOOP
25: fnd_msg_pub.get(
26: p_msg_index => l_ind,
27: p_encoded => fnd_api.g_false,
28: p_data => l_msg_data,
29: p_msg_index_out => l_msg_index_out);

Line 135: fnd_msg_pub.add;

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:
139: IF l_location_type_code in ('WIP', 'PROJECT', 'IN_TRANSIT') THEN

Line 143: fnd_msg_pub.add;

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:
147: SELECT asset_creation_code,

Line 170: fnd_msg_pub.add;

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:
174: l_pending_mass_add := FALSE;

Line 185: fnd_msg_pub.add;

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:
189: END IF;

Line 205: fnd_msg_pub.add;

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:
209: ELSE

Line 743: fnd_msg_pub.add;

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;
747:

Line 759: fnd_msg_pub.add;

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:
763: PROCEDURE copy_item_instance(

Line 1181: fnd_msg_pub.add;

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:
1185: --

Line 1311: fnd_msg_pub.add;

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:
1315: PROCEDURE update_asset_association(

Line 1387: fnd_msg_pub.add;

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;
1391:

Line 1401: fnd_msg_pub.add;

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:
1405: PROCEDURE create_instance_assets(

Line 1519: fnd_msg_pub.add;

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
1523: x_return_status := fnd_api.g_ret_sts_success;