DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PVT dependencies on FND_MSG_PUB

Line 85: FND_MSG_PUB.Initialize;

81: SAVEPOINT CREATE_MASS_EDIT_BATCH_PVT;
82:
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: IF FND_API.To_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.Initialize;
86: END IF;
87:
88: -- Initialize API return status to succcess
89: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 422: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

418:
419: -- Set Error Table Index
420: err_indx := nvl(l_mass_edit_error_tbl.last,0) + 1;
421:
422: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
423: l_mass_edit_error_tbl(err_indx).instance_id := NULL;
424: l_mass_edit_error_tbl(err_indx).entry_id := g_entry_id;
425: l_mass_edit_error_tbl(err_indx).name := g_batch_name;
426: l_mass_edit_error_tbl(err_indx).txn_line_detail_id := NULL;

Line 444: FND_MSG_PUB.Count_And_Get

440: END IF; -- px_mass_edit_inst_tbl count > 0
441:
442: Debug('CREATE_MASS_EDIT_BATCH API Successfully completed');
443: -- Standard call to get message count and IF count is get message info.
444: FND_MSG_PUB.Count_And_Get
445: (p_count => x_msg_count,
446: p_data => x_msg_data
447: );
448:

Line 454: FND_MSG_PUB.Count_And_Get

450: WHEN FND_API.G_EXC_ERROR THEN
451: ROLLBACK TO CREATE_MASS_EDIT_BATCH_PVT;
452: x_return_status := FND_API.G_RET_STS_ERROR ;
453: x_mass_edit_error_tbl := l_mass_edit_error_tbl;
454: FND_MSG_PUB.Count_And_Get
455: (p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 462: FND_MSG_PUB.Count_And_Get

458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
460: x_mass_edit_error_tbl := l_mass_edit_error_tbl;
461: ROLLBACK TO CREATE_MASS_EDIT_BATCH_PVT;
462: FND_MSG_PUB.Count_And_Get
463: ( p_count => x_msg_count,
464: p_data => x_msg_data
465: );
466: WHEN OTHERS THEN

Line 470: IF FND_MSG_PUB.Check_Msg_Level

466: WHEN OTHERS THEN
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
468: x_mass_edit_error_tbl := l_mass_edit_error_tbl;
469: ROLLBACK TO CREATE_MASS_EDIT_BATCH_PVT;
470: IF FND_MSG_PUB.Check_Msg_Level
471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: FND_MSG_PUB.Add_Exc_Msg
474: (G_PKG_NAME ,

Line 471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
468: x_mass_edit_error_tbl := l_mass_edit_error_tbl;
469: ROLLBACK TO CREATE_MASS_EDIT_BATCH_PVT;
470: IF FND_MSG_PUB.Check_Msg_Level
471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: FND_MSG_PUB.Add_Exc_Msg
474: (G_PKG_NAME ,
475: l_api_name

Line 473: FND_MSG_PUB.Add_Exc_Msg

469: ROLLBACK TO CREATE_MASS_EDIT_BATCH_PVT;
470: IF FND_MSG_PUB.Check_Msg_Level
471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: FND_MSG_PUB.Add_Exc_Msg
474: (G_PKG_NAME ,
475: l_api_name
476: );
477: END IF;

Line 478: FND_MSG_PUB.Count_And_Get

474: (G_PKG_NAME ,
475: l_api_name
476: );
477: END IF;
478: FND_MSG_PUB.Count_And_Get
479: (p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482:

Line 828: FND_MSG_PUB.Initialize;

824: SAVEPOINT UPDATE_MASS_EDIT_PVT;
825:
826: -- Initialize message list if p_init_msg_list is set to TRUE.
827: IF FND_API.To_Boolean( p_init_msg_list ) THEN
828: FND_MSG_PUB.Initialize;
829: END IF;
830:
831: -- Initialize API return status to succcess
832: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1178: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1174:
1175: -- Set Error Table Index
1176: err_indx := nvl(l_mass_edit_error_tbl.last,0) + 1;
1177:
1178: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1179: l_mass_edit_error_tbl(err_indx).instance_id := NULL;
1180: l_mass_edit_error_tbl(err_indx).entry_id := g_entry_id;
1181: l_mass_edit_error_tbl(err_indx).txn_line_detail_id := NULL;
1182: l_mass_edit_error_tbl(err_indx).error_text := l_error_message;

Line 1238: FND_MSG_PUB.Count_And_Get

1234: WHEN FND_API.G_EXC_ERROR THEN
1235: ROLLBACK TO update_mass_edit_pvt;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237: x_mass_edit_error_tbl := l_mass_edit_error_tbl;
1238: FND_MSG_PUB.Count_And_Get
1239: (p_count => x_msg_count,
1240: p_data => x_msg_data
1241: );
1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1246: FND_MSG_PUB.Count_And_Get

1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1244: ROLLBACK TO update_mass_edit_pvt;
1245:
1246: FND_MSG_PUB.Count_And_Get
1247: ( p_count => x_msg_count,
1248: p_data => x_msg_data
1249: );
1250: WHEN OTHERS THEN

Line 1255: IF FND_MSG_PUB.Check_Msg_Level

1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1252: x_mass_edit_error_tbl := l_mass_edit_error_tbl;
1253: debug( to_char(SQLCODE)||substr(SQLERRM, 1, 255));
1254: ROLLBACK TO update_mass_edit_pvt;
1255: IF FND_MSG_PUB.Check_Msg_Level
1256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: FND_MSG_PUB.Add_Exc_Msg
1259: (G_PKG_NAME ,

Line 1256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1252: x_mass_edit_error_tbl := l_mass_edit_error_tbl;
1253: debug( to_char(SQLCODE)||substr(SQLERRM, 1, 255));
1254: ROLLBACK TO update_mass_edit_pvt;
1255: IF FND_MSG_PUB.Check_Msg_Level
1256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: FND_MSG_PUB.Add_Exc_Msg
1259: (G_PKG_NAME ,
1260: l_api_name

Line 1258: FND_MSG_PUB.Add_Exc_Msg

1254: ROLLBACK TO update_mass_edit_pvt;
1255: IF FND_MSG_PUB.Check_Msg_Level
1256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: FND_MSG_PUB.Add_Exc_Msg
1259: (G_PKG_NAME ,
1260: l_api_name
1261: );
1262: END IF;

Line 1263: FND_MSG_PUB.Count_And_Get

1259: (G_PKG_NAME ,
1260: l_api_name
1261: );
1262: END IF;
1263: FND_MSG_PUB.Count_And_Get
1264: (p_count => x_msg_count,
1265: p_data => x_msg_data
1266: );
1267:

Line 1297: FND_MSG_PUB.Initialize;

1293: SAVEPOINT delete_mass_edit_batch_pvt;
1294:
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1297: FND_MSG_PUB.Initialize;
1298: END IF;
1299:
1300: -- Initialize API return status to success
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1331: FND_MSG_PUB.add;

1327: ELSE
1328: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1329: FND_MESSAGE.set_token('BATCH_ID',p_mass_edit_rec.entry_id);
1330: END IF;
1331: FND_MSG_PUB.add;
1332: Raise fnd_api.g_exc_error;
1333: END IF;
1334: IF nvl(l_mass_edit_rec.status_code, 'CREATED') = 'PROCESSING' THEN
1335: debug('Cannot Delete a Batch that is being Processed: '||l_mass_edit_rec.status_code);

Line 1339: FND_MSG_PUB.add;

1335: debug('Cannot Delete a Batch that is being Processed: '||l_mass_edit_rec.status_code);
1336: FND_MESSAGE.set_name('CSI','CSI_MU_BATCH_UPD_DISALLOWED');
1337: FND_MESSAGE.set_token('BATCH_NAME',l_mass_edit_rec.name);
1338: FND_MESSAGE.set_token('BATCH_STATUS',l_mass_edit_rec.status_code) ;
1339: FND_MSG_PUB.add;
1340: Raise fnd_api.g_exc_error;
1341: END IF;
1342: END IF;
1343:

Line 1384: FND_MSG_PUB.Count_And_Get

1380: COMMIT WORK;
1381: END IF;
1382:
1383: -- Standard call to get message count and IF count is get message info.
1384: FND_MSG_PUB.Count_And_Get
1385: (p_count => x_msg_count,
1386: p_data => x_msg_data
1387: );
1388:

Line 1394: FND_MSG_PUB.Count_And_Get (

1390: WHEN FND_API.G_EXC_ERROR THEN
1391:
1392: ROLLBACK TO Delete_Mass_Edit_Batch_pvt;
1393: x_return_status := FND_API.G_RET_STS_ERROR ;
1394: FND_MSG_PUB.Count_And_Get (
1395: p_count => x_msg_count,
1396: p_data => x_msg_data);
1397:
1398: csi_t_gen_utility_pvt.set_debug_off;

Line 1405: FND_MSG_PUB.Count_And_Get(

1401:
1402: ROLLBACK TO Delete_Mass_Edit_Batch_pvt;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1404:
1405: FND_MSG_PUB.Count_And_Get(
1406: p_count => x_msg_count,
1407: p_data => x_msg_data);
1408:
1409: csi_t_gen_utility_pvt.set_debug_off;

Line 1416: IF FND_MSG_PUB.Check_Msg_Level(

1412:
1413: ROLLBACK TO Delete_Mass_Edit_Batch_pvt;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415:
1416: IF FND_MSG_PUB.Check_Msg_Level(
1417: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1418:
1419: FND_MSG_PUB.Add_Exc_Msg(
1420: p_pkg_name => G_PKG_NAME,

Line 1417: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1413: ROLLBACK TO Delete_Mass_Edit_Batch_pvt;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415:
1416: IF FND_MSG_PUB.Check_Msg_Level(
1417: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1418:
1419: FND_MSG_PUB.Add_Exc_Msg(
1420: p_pkg_name => G_PKG_NAME,
1421: p_procedure_name => l_api_name);

Line 1419: FND_MSG_PUB.Add_Exc_Msg(

1415:
1416: IF FND_MSG_PUB.Check_Msg_Level(
1417: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1418:
1419: FND_MSG_PUB.Add_Exc_Msg(
1420: p_pkg_name => G_PKG_NAME,
1421: p_procedure_name => l_api_name);
1422:
1423: END IF;

Line 1425: FND_MSG_PUB.Count_And_Get(

1421: p_procedure_name => l_api_name);
1422:
1423: END IF;
1424:
1425: FND_MSG_PUB.Count_And_Get(
1426: p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:
1429: csi_t_gen_utility_pvt.set_debug_off;

Line 1469: FND_MSG_PUB.Initialize;

1465: SAVEPOINT get_mass_edit_details_pvt;
1466:
1467: -- Initialize message list if p_init_msg_list is set to TRUE.
1468: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1469: FND_MSG_PUB.Initialize;
1470: END IF;
1471:
1472: -- Initialize API return status to success
1473: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1521: FND_MSG_PUB.add;

1517: FND_MESSAGE.set_name('CSI','CSI_MU_INVALID_BATCH_ID');
1518: FND_MESSAGE.set_token('BATCH_ID',px_mass_edit_rec.entry_id);
1519: END IF;
1520:
1521: FND_MSG_PUB.add;
1522: Raise fnd_api.g_exc_error;
1523: END IF;
1524: END IF;
1525:

Line 1564: FND_MSG_PUB.Count_And_Get

1560: COMMIT WORK;
1561: END IF;
1562:
1563: -- Standard call to get message count and IF count is get message info.
1564: FND_MSG_PUB.Count_And_Get
1565: (p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );
1568:

Line 1574: FND_MSG_PUB.Count_And_Get (

1570: WHEN FND_API.G_EXC_ERROR THEN
1571:
1572: ROLLBACK TO Get_mass_edit_details_pvt;
1573: x_return_status := FND_API.G_RET_STS_ERROR ;
1574: FND_MSG_PUB.Count_And_Get (
1575: p_count => x_msg_count,
1576: p_data => x_msg_data);
1577:
1578: csi_t_gen_utility_pvt.set_debug_off;

Line 1585: FND_MSG_PUB.Count_And_Get(

1581:
1582: ROLLBACK TO Get_mass_edit_details_pvt;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1584:
1585: FND_MSG_PUB.Count_And_Get(
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588:
1589: csi_t_gen_utility_pvt.set_debug_off;

Line 1596: IF FND_MSG_PUB.Check_Msg_Level(

1592:
1593: ROLLBACK TO Get_mass_edit_details_pvt;
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1595:
1596: IF FND_MSG_PUB.Check_Msg_Level(
1597: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598:
1599: FND_MSG_PUB.Add_Exc_Msg(
1600: p_pkg_name => G_PKG_NAME,

Line 1597: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1593: ROLLBACK TO Get_mass_edit_details_pvt;
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1595:
1596: IF FND_MSG_PUB.Check_Msg_Level(
1597: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598:
1599: FND_MSG_PUB.Add_Exc_Msg(
1600: p_pkg_name => G_PKG_NAME,
1601: p_procedure_name => l_api_name);

Line 1599: FND_MSG_PUB.Add_Exc_Msg(

1595:
1596: IF FND_MSG_PUB.Check_Msg_Level(
1597: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598:
1599: FND_MSG_PUB.Add_Exc_Msg(
1600: p_pkg_name => G_PKG_NAME,
1601: p_procedure_name => l_api_name);
1602:
1603: END IF;

Line 1605: FND_MSG_PUB.Count_And_Get(

1601: p_procedure_name => l_api_name);
1602:
1603: END IF;
1604:
1605: FND_MSG_PUB.Count_And_Get(
1606: p_count => x_msg_count,
1607: p_data => x_msg_data);
1608:
1609: csi_t_gen_utility_pvt.set_debug_off;

Line 2337: FND_MSG_PUB.Initialize;

2333: csi_t_gen_utility_pvt.add('In VALIDATE_BATCH');
2334:
2335: -- Initialize message list if p_init_msg_list is set to TRUE.
2336: IF FND_API.To_Boolean( l_init_msg_list ) THEN
2337: FND_MSG_PUB.Initialize;
2338: END IF;
2339:
2340: -- Initialize API return status to succcess
2341: x_return_status := FND_API.G_RET_STS_SUCCESS;