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 751: fnd_msg_pub.add;

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

Line 782: fnd_msg_pub.add;

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

Line 1206: fnd_msg_pub.add;

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

Line 1336: fnd_msg_pub.add;

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

Line 1412: fnd_msg_pub.add;

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

Line 1426: fnd_msg_pub.add;

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

Line 1544: fnd_msg_pub.add;

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