DBA Data[Home] [Help]

APPS.CSI_CZ_INT dependencies on FND_MSG_PUB

Line 163: fnd_msg_pub.add;

159: ELSE
160:
161: fnd_message.set_name('CSI', 'CSI_UNSUPPORTED_INST_LEVEL');
162: fnd_message.set_token('INST_LVL', px_instance_level);
163: fnd_msg_pub.add;
164: RAISE fnd_api.g_exc_error;
165:
166: END IF;
167:

Line 174: fnd_msg_pub.add;

170: /*
171: fnd_message.set_name('CSI','CSI_CONFIG_REV_NOT_FOUND');
172: fnd_message.set_token('LEVEL', l_instance_level);
173: fnd_message.set_token('INST_HDR_ID', p_config_header_id);
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_error;
176: */
177: END IF;
178:

Line 419: fnd_msg_pub.add;

415: Exception when others then
416: fnd_message.set_name('CSI','CSI_CONFIG_REV_NOT_FOUND');
417: fnd_message.set_token('LEVEL', 'INSTALLED');
418: fnd_message.set_token('INST_HDR_ID', l_conn_hdr_id);
419: fnd_msg_pub.add;
420: RAISE fnd_api.g_exc_error;
421: End;
422:
423: l_found := FALSE;

Line 641: fnd_msg_pub.add;

637: THEN
638: fnd_message.set_name('CSI','CSI_CZ_LOCK_DTLS_MISS');
639: fnd_message.set_token('APPLN_ID',px_config_tbl(l_key).source_application_id);
640: fnd_message.set_token('HEADER_REF',px_config_tbl(l_key).source_txn_header_ref);
641: fnd_msg_pub.add;
642: RAISE fnd_api.g_exc_error;
643: END IF;
644:
645: FOR sess_rec IN sess_cur(px_config_tbl(l_key).config_inst_hdr_id,

Line 681: fnd_msg_pub.add;

677: fnd_message.set_name('CSI','CSI_CONFIG_KEYS_LOCKED');
678: fnd_message.set_token('CONFIG_INST_HDR_ID',l_config_rec.config_inst_hdr_id);
679: fnd_message.set_token('CONFIG_INST_ITEM_ID',l_config_rec.config_inst_item_id);
680: fnd_message.set_token('CONFIG_INST_REV_NUM',l_config_rec.config_inst_rev_num);
681: fnd_msg_pub.add;
682: RAISE fnd_api.g_exc_error;
683: Exit;
684: ELSE
685: /*

Line 705: fnd_msg_pub.add;

701:
702: EXCEPTION
703: WHEN NO_DATA_FOUND Then
704: fnd_message.set_name('CSI','CSI_CZ_KEY_INVAL_OREDER');
705: fnd_msg_pub.add;
706: RAISE fnd_api.g_exc_error;
707: Exit;
708: END;
709: */

Line 792: FND_MSG_PUB.Count_And_Get

788: END LOOP;
789: END IF;
790:
791: -- Standard call to get message count and if count is get message info.
792: FND_MSG_PUB.Count_And_Get
793: (p_count => x_msg_count ,
794: p_data => x_msg_data );
795:
796: EXCEPTION

Line 800: FND_MSG_PUB.Count_And_Get

796: EXCEPTION
797: WHEN fnd_api.g_exc_error THEN
798: x_return_status := fnd_api.g_ret_sts_error;
799: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
800: FND_MSG_PUB.Count_And_Get
801: (p_count => x_msg_count ,
802: p_data => x_msg_data );
803: rollback to csi_cz_lock_item;
804: debug(l_return_message);

Line 808: fnd_msg_pub.add;

804: debug(l_return_message);
805: WHEN others THEN
806: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
807: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
808: fnd_msg_pub.add;
809: FND_MSG_PUB.Count_And_Get
810: (p_count => x_msg_count ,
811: p_data => x_msg_data );
812: x_return_status := fnd_api.g_ret_sts_error;

Line 809: FND_MSG_PUB.Count_And_Get

805: WHEN others THEN
806: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
807: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
808: fnd_msg_pub.add;
809: FND_MSG_PUB.Count_And_Get
810: (p_count => x_msg_count ,
811: p_data => x_msg_data );
812: x_return_status := fnd_api.g_ret_sts_error;
813: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 1188: FND_MSG_PUB.Count_And_Get

1184: EXCEPTION
1185: WHEN fnd_api.g_exc_error THEN
1186: x_return_status := fnd_api.g_ret_sts_error;
1187: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1188: FND_MSG_PUB.Count_And_Get
1189: (p_count => x_msg_count ,
1190: p_data => x_msg_data );
1191: rollback to unlock_current_node;
1192: debug(l_return_message);

Line 1196: fnd_msg_pub.add;

1192: debug(l_return_message);
1193: WHEN others THEN
1194: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1195: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1196: fnd_msg_pub.add;
1197: FND_MSG_PUB.Count_And_Get
1198: (p_count => x_msg_count ,
1199: p_data => x_msg_data );
1200: x_return_status := fnd_api.g_ret_sts_error;

Line 1197: FND_MSG_PUB.Count_And_Get

1193: WHEN others THEN
1194: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1195: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1196: fnd_msg_pub.add;
1197: FND_MSG_PUB.Count_And_Get
1198: (p_count => x_msg_count ,
1199: p_data => x_msg_data );
1200: x_return_status := fnd_api.g_ret_sts_error;
1201: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 1289: fnd_msg_pub.add;

1285: fnd_message.set_name('CSI','CSI_CZ_LOCK_ID_MISS');
1286: fnd_message.set_token('CONFIG_INST_HDR_ID',p_config_tbl(l_key).config_inst_hdr_id);
1287: fnd_message.set_token('CONFIG_INST_REV_NUM',p_config_tbl(l_key).config_inst_rev_num);
1288: fnd_message.set_token('CONFIG_INST_ITEM_ID',p_config_tbl(l_key).config_inst_item_id);
1289: fnd_msg_pub.add;
1290: RAISE fnd_api.g_exc_error;
1291: EXIT;
1292: END IF;
1293: END LOOP;

Line 1423: FND_MSG_PUB.Add;

1419: END IF;
1420: ELSE
1421: debug('Config keys are already in unlocked status');
1422: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LOCKS');
1423: FND_MSG_PUB.Add;
1424: END IF;
1425: END LOOP;
1426: END IF;
1427: END IF;

Line 1430: FND_MSG_PUB.Count_And_Get

1426: END IF;
1427: END IF;
1428:
1429: -- Standard call to get message count and if count is get message info.
1430: FND_MSG_PUB.Count_And_Get
1431: (p_count => x_msg_count ,
1432: p_data => x_msg_data );
1433:
1434: EXCEPTION

Line 1438: FND_MSG_PUB.Count_And_Get

1434: EXCEPTION
1435: WHEN fnd_api.g_exc_error THEN
1436: x_return_status := fnd_api.g_ret_sts_error;
1437: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1438: FND_MSG_PUB.Count_And_Get
1439: (p_count => x_msg_count ,
1440: p_data => x_msg_data );
1441: rollback to csi_cz_unlock_item;
1442: debug(l_return_message);

Line 1446: fnd_msg_pub.add;

1442: debug(l_return_message);
1443: WHEN others THEN
1444: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1445: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1446: fnd_msg_pub.add;
1447: FND_MSG_PUB.Count_And_Get
1448: (p_count => x_msg_count ,
1449: p_data => x_msg_data );
1450: x_return_status := fnd_api.g_ret_sts_error;

Line 1447: FND_MSG_PUB.Count_And_Get

1443: WHEN others THEN
1444: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1445: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1446: fnd_msg_pub.add;
1447: FND_MSG_PUB.Count_And_Get
1448: (p_count => x_msg_count ,
1449: p_data => x_msg_data );
1450: x_return_status := fnd_api.g_ret_sts_error;
1451: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 1534: fnd_msg_pub.add;

1530: td_cur%ROWCOUNT > 0
1531: THEN
1532: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1533: fnd_message.set_token('MESSAGE', l_error_message);
1534: fnd_msg_pub.add;
1535: raise fnd_api.g_exc_error;
1536: END IF;
1537: CLOSE td_cur;
1538: END IF;

Line 1591: fnd_msg_pub.add;

1587: x_msg_count := 1;
1588:
1589: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1590: fnd_message.set_token('MESSAGE', x_error_message);
1591: fnd_msg_pub.add;
1592:
1593: END configure_from_html_ui;
1594:
1595: Procedure CSI_CONFIG_LAUNCH_PRMS

Line 1632: FND_MSG_PUB.initialize;

1628: END IF;*/
1629:
1630: -- Initialize message list if p_init_msg_list is set to TRUE.
1631: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1632: FND_MSG_PUB.initialize;
1633: END IF;
1634:
1635: -- Initialize API rturn status to success
1636: x_return_status := FND_API.g_ret_sts_success;

Line 1658: FND_MSG_PUB.Count_And_Get

1654:
1655: IF FND_API.To_Boolean( p_commit ) THEN
1656: COMMIT WORK;
1657: END IF;
1658: FND_MSG_PUB.Count_And_Get
1659: ( p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => x_msg_data
1662: );

Line 1667: FND_MSG_PUB.Count_And_Get

1663: EXCEPTION
1664: WHEN FND_API.G_EXC_ERROR THEN
1665: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1666: x_return_status := FND_API.G_RET_STS_ERROR ;
1667: FND_MSG_PUB.Count_And_Get
1668: ( p_encoded => FND_API.G_FALSE,
1669: p_count => x_msg_count,
1670: p_data => x_msg_data
1671: );

Line 1676: FND_MSG_PUB.Count_And_Get

1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1674: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: FND_MSG_PUB.Count_And_Get
1677: ( p_encoded => FND_API.G_FALSE,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data
1680: );

Line 1685: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1681: WHEN OTHERS THEN
1682: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: OTHER EXCEPTION ');
1683: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1685: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1686: THEN
1687: FND_MSG_PUB.Add_Exc_Msg
1688: ( G_PKG_NAME,
1689: l_api_name

Line 1687: FND_MSG_PUB.Add_Exc_Msg

1683: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1685: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1686: THEN
1687: FND_MSG_PUB.Add_Exc_Msg
1688: ( G_PKG_NAME,
1689: l_api_name
1690: );
1691: END IF;*/

Line 1692: FND_MSG_PUB.Count_And_Get

1688: ( G_PKG_NAME,
1689: l_api_name
1690: );
1691: END IF;*/
1692: FND_MSG_PUB.Count_And_Get
1693: ( p_encoded => FND_API.G_FALSE,
1694: p_count => x_msg_count,
1695: p_data => x_msg_data
1696: );