DBA Data[Home] [Help]

APPS.WIP_DISCRETEJOB_UTIL dependencies on FND_MSG_PUB

Line 1261: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1257: EXCEPTION
1258:
1259: WHEN OTHERS THEN
1260:
1261: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1262: THEN
1263: FND_MSG_PUB.Add_Exc_Msg
1264: ( G_PKG_NAME
1265: , 'Update_Row'

Line 1263: FND_MSG_PUB.Add_Exc_Msg

1259: WHEN OTHERS THEN
1260:
1261: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1262: THEN
1263: FND_MSG_PUB.Add_Exc_Msg
1264: ( G_PKG_NAME
1265: , 'Update_Row'
1266: );
1267: END IF;

Line 1450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1446: EXCEPTION
1447:
1448: WHEN OTHERS THEN
1449:
1450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1451: THEN
1452: FND_MSG_PUB.Add_Exc_Msg
1453: ( G_PKG_NAME
1454: , 'Insert_Row'

Line 1452: FND_MSG_PUB.Add_Exc_Msg

1448: WHEN OTHERS THEN
1449:
1450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1451: THEN
1452: FND_MSG_PUB.Add_Exc_Msg
1453: ( G_PKG_NAME
1454: , 'Insert_Row'
1455: );
1456: END IF;

Line 1478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1474: EXCEPTION
1475:
1476: WHEN OTHERS THEN
1477:
1478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1479: THEN
1480: FND_MSG_PUB.Add_Exc_Msg
1481: ( G_PKG_NAME
1482: , 'Delete_Row'

Line 1480: FND_MSG_PUB.Add_Exc_Msg

1476: WHEN OTHERS THEN
1477:
1478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1479: THEN
1480: FND_MSG_PUB.Add_Exc_Msg
1481: ( G_PKG_NAME
1482: , 'Delete_Row'
1483: );
1484: END IF;

Line 1718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715:
1716: WHEN OTHERS THEN
1717:
1718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: FND_MSG_PUB.Add_Exc_Msg
1721: ( G_PKG_NAME
1722: , 'Query_Rows'

Line 1720: FND_MSG_PUB.Add_Exc_Msg

1716: WHEN OTHERS THEN
1717:
1718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1719: THEN
1720: FND_MSG_PUB.Add_Exc_Msg
1721: ( G_PKG_NAME
1722: , 'Query_Rows'
1723: );
1724: END IF;

Line 2086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2082:
2083: x_return_status := FND_API.G_RET_STS_ERROR;
2084: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2085:
2086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2087: THEN
2088:
2089: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
2090: FND_MSG_PUB.Add;

Line 2090: FND_MSG_PUB.Add;

2086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2087: THEN
2088:
2089: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
2090: FND_MSG_PUB.Add;
2091:
2092: END IF;
2093:
2094: END IF;

Line 2103: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2099:
2100: x_return_status := FND_API.G_RET_STS_ERROR;
2101: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2102:
2103: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2104: THEN
2105:
2106: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
2107: FND_MSG_PUB.Add;

Line 2107: FND_MSG_PUB.Add;

2103: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2104: THEN
2105:
2106: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
2107: FND_MSG_PUB.Add;
2108:
2109: END IF;
2110: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2111:

Line 2115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2111:
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2114:
2115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2116: THEN
2117:
2118: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
2119: FND_MSG_PUB.Add;

Line 2119: FND_MSG_PUB.Add;

2115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2116: THEN
2117:
2118: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
2119: FND_MSG_PUB.Add;
2120:
2121: END IF;
2122: WHEN OTHERS THEN
2123:

Line 2127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2123:
2124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2125: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126:
2127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2128: THEN
2129: FND_MSG_PUB.Add_Exc_Msg
2130: ( G_PKG_NAME
2131: , 'Lock_Row'

Line 2129: FND_MSG_PUB.Add_Exc_Msg

2125: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126:
2127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2128: THEN
2129: FND_MSG_PUB.Add_Exc_Msg
2130: ( G_PKG_NAME
2131: , 'Lock_Row'
2132: );
2133: END IF;

Line 2377: fnd_msg_pub.initialize;

2373:
2374: x_return_status := FND_API.G_RET_STS_ERROR;
2375:
2376: if (p_initialize = 'Y') then
2377: fnd_msg_pub.initialize;
2378: end if;
2379:
2380: open c_jobname;
2381: fetch c_jobname into x_wip_entity_name;

Line 2387: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',

2383:
2384: -- if build sequence with no schedule group then error out
2385: if (p_build_sequence is not null and p_schedule_group_id is null) then
2386: x_err_msg := x_wip_entity_name || ' ' || fnd_message.get_string('WIP','WIP_SCHEDULE_GROUP_NULL');
2387: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',
2388: p_procedure_name => 'update_job_details',
2389: p_error_text => x_err_msg);
2390:
2391: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2403: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',

2399: fetch c_build_seq into x_dummy;
2400:
2401: if c_build_seq%found then
2402: x_err_msg := x_wip_entity_name || ' ' || fnd_message.get_string('WIP','WIP_BUILD_SEQUENCE');
2403: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',
2404: p_procedure_name => 'update_job_details',
2405: p_error_text => x_err_msg);
2406:
2407: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2433: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',

2429: x_return_status := fnd_api.g_ret_sts_unexp_error;
2430:
2431: when others then
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',
2434: p_procedure_name => 'update_job_details',
2435: p_error_text => SQLERRM);
2436:
2437: END update_job_details;