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 1147: FND_MSG_PUB.Count_And_Get

1143: EXCEPTION
1144: WHEN fnd_api.g_exc_error THEN
1145: x_return_status := fnd_api.g_ret_sts_error;
1146: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1147: FND_MSG_PUB.Count_And_Get
1148: (p_count => x_msg_count ,
1149: p_data => x_msg_data );
1150: rollback to unlock_current_node;
1151: debug(l_return_message);

Line 1155: fnd_msg_pub.add;

1151: debug(l_return_message);
1152: WHEN others THEN
1153: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1154: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1155: fnd_msg_pub.add;
1156: FND_MSG_PUB.Count_And_Get
1157: (p_count => x_msg_count ,
1158: p_data => x_msg_data );
1159: x_return_status := fnd_api.g_ret_sts_error;

Line 1156: FND_MSG_PUB.Count_And_Get

1152: WHEN others THEN
1153: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1154: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1155: fnd_msg_pub.add;
1156: FND_MSG_PUB.Count_And_Get
1157: (p_count => x_msg_count ,
1158: p_data => x_msg_data );
1159: x_return_status := fnd_api.g_ret_sts_error;
1160: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 1248: fnd_msg_pub.add;

1244: fnd_message.set_name('CSI','CSI_CZ_LOCK_ID_MISS');
1245: fnd_message.set_token('CONFIG_INST_HDR_ID',p_config_tbl(l_key).config_inst_hdr_id);
1246: fnd_message.set_token('CONFIG_INST_REV_NUM',p_config_tbl(l_key).config_inst_rev_num);
1247: fnd_message.set_token('CONFIG_INST_ITEM_ID',p_config_tbl(l_key).config_inst_item_id);
1248: fnd_msg_pub.add;
1249: RAISE fnd_api.g_exc_error;
1250: EXIT;
1251: END IF;
1252: END LOOP;

Line 1382: FND_MSG_PUB.Add;

1378: END IF;
1379: ELSE
1380: debug('Config keys are already in unlocked status');
1381: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LOCKS');
1382: FND_MSG_PUB.Add;
1383: END IF;
1384: END LOOP;
1385: END IF;
1386: END IF;

Line 1389: FND_MSG_PUB.Count_And_Get

1385: END IF;
1386: END IF;
1387:
1388: -- Standard call to get message count and if count is get message info.
1389: FND_MSG_PUB.Count_And_Get
1390: (p_count => x_msg_count ,
1391: p_data => x_msg_data );
1392:
1393: EXCEPTION

Line 1397: FND_MSG_PUB.Count_And_Get

1393: EXCEPTION
1394: WHEN fnd_api.g_exc_error THEN
1395: x_return_status := fnd_api.g_ret_sts_error;
1396: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1397: FND_MSG_PUB.Count_And_Get
1398: (p_count => x_msg_count ,
1399: p_data => x_msg_data );
1400: rollback to csi_cz_unlock_item;
1401: debug(l_return_message);

Line 1405: fnd_msg_pub.add;

1401: debug(l_return_message);
1402: WHEN others THEN
1403: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1404: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1405: fnd_msg_pub.add;
1406: FND_MSG_PUB.Count_And_Get
1407: (p_count => x_msg_count ,
1408: p_data => x_msg_data );
1409: x_return_status := fnd_api.g_ret_sts_error;

Line 1406: FND_MSG_PUB.Count_And_Get

1402: WHEN others THEN
1403: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1404: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1405: fnd_msg_pub.add;
1406: FND_MSG_PUB.Count_And_Get
1407: (p_count => x_msg_count ,
1408: p_data => x_msg_data );
1409: x_return_status := fnd_api.g_ret_sts_error;
1410: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 1493: fnd_msg_pub.add;

1489: td_cur%ROWCOUNT > 0
1490: THEN
1491: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1492: fnd_message.set_token('MESSAGE', l_error_message);
1493: fnd_msg_pub.add;
1494: raise fnd_api.g_exc_error;
1495: END IF;
1496: CLOSE td_cur;
1497: END IF;

Line 1550: fnd_msg_pub.add;

1546: x_msg_count := 1;
1547:
1548: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1549: fnd_message.set_token('MESSAGE', x_error_message);
1550: fnd_msg_pub.add;
1551:
1552: END configure_from_html_ui;
1553:
1554: Procedure CSI_CONFIG_LAUNCH_PRMS

Line 1591: FND_MSG_PUB.initialize;

1587: END IF;*/
1588:
1589: -- Initialize message list if p_init_msg_list is set to TRUE.
1590: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1591: FND_MSG_PUB.initialize;
1592: END IF;
1593:
1594: -- Initialize API rturn status to success
1595: x_return_status := FND_API.g_ret_sts_success;

Line 1617: FND_MSG_PUB.Count_And_Get

1613:
1614: IF FND_API.To_Boolean( p_commit ) THEN
1615: COMMIT WORK;
1616: END IF;
1617: FND_MSG_PUB.Count_And_Get
1618: ( p_encoded => FND_API.G_FALSE,
1619: p_count => x_msg_count,
1620: p_data => x_msg_data
1621: );

Line 1626: FND_MSG_PUB.Count_And_Get

1622: EXCEPTION
1623: WHEN FND_API.G_EXC_ERROR THEN
1624: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1625: x_return_status := FND_API.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get
1627: ( p_encoded => FND_API.G_FALSE,
1628: p_count => x_msg_count,
1629: p_data => x_msg_data
1630: );

Line 1635: FND_MSG_PUB.Count_And_Get

1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1632: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1633: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1635: FND_MSG_PUB.Count_And_Get
1636: ( p_encoded => FND_API.G_FALSE,
1637: p_count => x_msg_count,
1638: p_data => x_msg_data
1639: );

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

1640: WHEN OTHERS THEN
1641: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: OTHER EXCEPTION ');
1642: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1644: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1645: THEN
1646: FND_MSG_PUB.Add_Exc_Msg
1647: ( G_PKG_NAME,
1648: l_api_name

Line 1646: FND_MSG_PUB.Add_Exc_Msg

1642: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1644: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1645: THEN
1646: FND_MSG_PUB.Add_Exc_Msg
1647: ( G_PKG_NAME,
1648: l_api_name
1649: );
1650: END IF;*/

Line 1651: FND_MSG_PUB.Count_And_Get

1647: ( G_PKG_NAME,
1648: l_api_name
1649: );
1650: END IF;*/
1651: FND_MSG_PUB.Count_And_Get
1652: ( p_encoded => FND_API.G_FALSE,
1653: p_count => x_msg_count,
1654: p_data => x_msg_data
1655: );