DBA Data[Home] [Help]

APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on FND_MSG_PUB

Line 783: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

779: -- AND trx_id = p_event_class_rec.trx_id;
780:
781: l_row_count := SQL%ROWCOUNT;
782:
783: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
784: -- FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_INSERTED');
785: -- FND_MESSAGE.SET_TOKEN('ROWS_INSERTED',l_row_count);
786: -- FND_MSG_PUB.Add;
787: -- END IF;

Line 786: -- FND_MSG_PUB.Add;

782:
783: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
784: -- FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_INSERTED');
785: -- FND_MESSAGE.SET_TOKEN('ROWS_INSERTED',l_row_count);
786: -- FND_MSG_PUB.Add;
787: -- END IF;
788:
789: IF (g_level_procedure >= g_current_runtime_level ) THEN
790: FND_LOG.STRING(g_level_procedure,

Line 1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

1164:
1165: l_row_count := SQL%ROWCOUNT;
1166:
1167: /* bug#4374237
1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1169: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1170: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1171: FND_MSG_PUB.Add;
1172: END IF;

Line 1171: FND_MSG_PUB.Add;

1167: /* bug#4374237
1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1169: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1170: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1171: FND_MSG_PUB.Add;
1172: END IF;
1173: */
1174:
1175: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

1262: l_row_count := SQL%ROWCOUNT;
1263:
1264:
1265: /* bug#4374237
1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1267: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1268: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1269: FND_MSG_PUB.Add;
1270: END IF;

Line 1269: FND_MSG_PUB.Add;

1265: /* bug#4374237
1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1267: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1268: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1269: FND_MSG_PUB.Add;
1270: END IF;
1271: */
1272:
1273: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

1345:
1346: l_row_count := SQL%ROWCOUNT;
1347:
1348: /* bug#4374237
1349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1350: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1351: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1352: FND_MSG_PUB.Add;
1353: END IF;

Line 1352: FND_MSG_PUB.Add;

1348: /* bug#4374237
1349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1350: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_DELETED');
1351: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
1352: FND_MSG_PUB.Add;
1353: END IF;
1354: */
1355:
1356: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1514: 'Return Status = '||x_return_status);
1515: END IF;
1516:
1517: /* bug#4374237
1518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1519: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
1520: FND_MSG_PUB.Add;
1521: END IF;
1522: */

Line 1520: FND_MSG_PUB.Add;

1516:
1517: /* bug#4374237
1518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1519: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
1520: FND_MSG_PUB.Add;
1521: END IF;
1522: */
1523:
1524: WHEN FND_API.G_EXC_ERROR THEN

Line 2262: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2258: 'Return Status = '||x_return_status);
2259: END IF;
2260:
2261: /* bug#4374237
2262: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2263: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
2264: FND_MSG_PUB.Add;
2265: END IF;
2266: */

Line 2264: FND_MSG_PUB.Add;

2260:
2261: /* bug#4374237
2262: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2263: FND_MESSAGE.SET_NAME('FND','ZX_TRL_ROWS_NOT_FOUND');
2264: FND_MSG_PUB.Add;
2265: END IF;
2266: */
2267:
2268: WHEN FND_API.G_EXC_ERROR THEN

Line 3301: FND_MSG_PUB.Add;

3297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3299:
3300: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3301: FND_MSG_PUB.Add;
3302:
3303: IF (g_level_procedure >= g_current_runtime_level ) THEN
3304: FND_LOG.STRING(g_level_procedure,
3305: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Update_Freeze_Flag',