DBA Data[Home] [Help]

APPS.ZX_TRX_DETAIL dependencies on FND_MSG_PUB

Line 1725: FND_MSG_PUB.Add;

1721: WHEN OTHERS THEN
1722: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1723:
1724: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1725: FND_MSG_PUB.Add;
1726:
1727: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1728: FND_LOG.STRING(g_level_unexpected,
1729: 'ZX.PLSQL.ZX_TRX_DETAIL.Lock_Row',

Line 2744: FND_MSG_PUB.Add;

2740: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2742:
2743: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2744: FND_MSG_PUB.Add;
2745:
2746: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2747: FND_LOG.STRING(g_level_unexpected,
2748: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Temporary_Table',

Line 2908: FND_MSG_PUB.Add;

2904: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2905: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2906:
2907: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2908: FND_MSG_PUB.Add;
2909:
2910: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2911: FND_LOG.STRING(g_level_unexpected,
2912: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',

Line 2984: FND_MSG_PUB.Add;

2980: WHEN OTHERS THEN
2981: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2982: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2983: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
2984: FND_MSG_PUB.Add;
2985:
2986: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2987: FND_LOG.STRING(g_level_unexpected,
2988: 'ZX.PLSQL.ZX_TRX_DETAIL.mark_reporting_only_flag',

Line 3125: FND_MSG_PUB.Add;

3121: WHEN OTHERS THEN
3122: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3123: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3124: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3125: FND_MSG_PUB.Add;
3126:
3127: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3128: FND_LOG.STRING(g_level_unexpected,
3129: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge',

Line 3225: FND_MSG_PUB.Add;

3221: WHEN OTHERS THEN
3222: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3224: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3225: FND_MSG_PUB.Add;
3226:
3227: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3228: FND_LOG.STRING(g_level_unexpected,
3229: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',

Line 3343: FND_MSG_PUB.Add;

3339: WHEN OTHERS THEN
3340: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3341: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3342: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3343: FND_MSG_PUB.Add;
3344:
3345: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3346: FND_LOG.STRING(g_level_unexpected,
3347: 'ZX.PLSQL.ZX_TRX_DETAIL.process_purge',

Line 3454: FND_MSG_PUB.Add;

3450: WHEN OTHERS THEN
3451: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3452: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3453: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
3454: FND_MSG_PUB.Add;
3455:
3456: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3457: FND_LOG.STRING(g_level_unexpected,
3458: 'ZX.PLSQL.ZX_TRX_DETAIL.process_import_doc_with_tax',

Line 3518: l_error_msg := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,

3514: x_msg_data := NULL;
3515:
3516: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3517: LOOP
3518: l_error_msg := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,
3519: FND_API.G_FALSE);
3520:
3521: IF l_error_msg IS NULL THEN
3522: EXIT;