APPS.ZX_SIM_CONDITIONS_PKG dependencies on FND_API

Line 54: p_return_status := FND_API.G_RET_STS_SUCCESS;

50: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
51: 'Simulate Rules');
52: END IF;
53:
54: p_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: INSERT INTO zx_sim_rules_b (
57: sim_tax_rule_id,
58: content_owner_id,

Line 233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

229:
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
235:
236: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
237: FND_MSG_PUB.Add;

Line 308: p_return_status := FND_API.G_RET_STS_SUCCESS;

304: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions.BEGIN',
305: 'ZX_SIM_CONDITIONS_PKG: create_sim_conditions(+)');
306: END IF;
307:
308: p_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: FOR l_trxhdr_rec IN c_trxhdr
311: Loop
312: FOR l_trxlines_rec IN c_trxlines(l_trxhdr_rec.trx_id)

Line 466: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

462: commit;
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
468:
469: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
470: FND_MSG_PUB.Add;

Line 507: p_return_status := FND_API.G_RET_STS_SUCCESS;

503: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules.BEGIN',
504: 'ZX_SIM_CONDITIONS_PKG: create_sim_rules(+)');
505: END IF;
506:
507: p_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: IF (g_level_statement >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_statement,
511: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

Line 531: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

527: p_application_id,
528: p_return_status,
529: p_error_buffer);
530:
531: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
532: IF (g_level_statement >= g_current_runtime_level ) THEN
533: FND_LOG.STRING(g_level_statement,
534: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
535: 'Unable to Create Simulated Rules from Existing Setup');

Line 536: p_return_status := FND_API.G_RET_STS_ERROR;

532: IF (g_level_statement >= g_current_runtime_level ) THEN
533: FND_LOG.STRING(g_level_statement,
534: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
535: 'Unable to Create Simulated Rules from Existing Setup');
536: p_return_status := FND_API.G_RET_STS_ERROR;
537: p_error_buffer := 'Unable to Create Simulated Rules from Existing Setup';
538: END IF;
539:
540: return;

Line 952: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

948: commit;
949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
954:
955: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
956: FND_MSG_PUB.Add;

Line 1005: p_return_status := FND_API.G_RET_STS_SUCCESS;

1001: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules.BEGIN',
1002: 'ZX_SIM_CONDITIONS_PKG: create_rules(+)');
1003: END IF;
1004:
1005: p_return_status := FND_API.G_RET_STS_SUCCESS;
1006:
1007: IF (g_level_statement >= g_current_runtime_level ) THEN
1008: FND_LOG.STRING(g_level_statement,
1009: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

Line 1563: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1559:
1560:
1561: EXCEPTION
1562: WHEN OTHERS THEN
1563: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1565:
1566: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1567: FND_MSG_PUB.Add;