eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACC_CALL_PVT dependencies on OKL_API

Line 56: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

52: x_acc_gen_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key,
53: x_return_status OUT NOCOPY VARCHAR2) IS
54:
55: l_acc_gen_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
56: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
57: l_ind NUMBER := 0;
58: l_value VARCHAR2(100) := NULL;
59:
60:

Line 277: Okl_Api.SET_MESSAGE (

273: CLOSE l_fa_asset_line_csr;
274: END IF;
275:
276: -- store SQL error message on message stack for caller
277: Okl_Api.SET_MESSAGE (
278: p_app_name => G_APP_NAME
279: ,p_msg_name => G_UNEXPECTED_ERROR
280: ,p_token1 => G_SQLCODE_TOKEN
281: ,p_token1_value => SQLCODE

Line 286: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

282: ,p_token2 => G_SQLERRM_TOKEN
283: ,p_token2_value => SQLERRM);
284:
285: -- notify caller of an UNEXPECTED error
286: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
287:
288: END Okl_Populate_Acc_Gen;
289:
290:

Line 942: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

938: p_contract_line_id => l_acct_call_rec.kle_id,
939: x_acc_gen_tbl => l_acc_gen_primary_key_tbl,
940: x_return_status => x_return_status);
941:
942: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;

Line 943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

939: x_acc_gen_tbl => l_acc_gen_primary_key_tbl,
940: x_return_status => x_return_status);
941:
942: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;
947:

Line 944: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

940: x_return_status => x_return_status);
941:
942: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;
947:
948: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

Line 945: RAISE OKL_API.G_EXCEPTION_ERROR;

941:
942: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
944: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946: END IF;
947:
948: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
949: IF(L_DEBUG_ENABLED='Y') THEN

Line 971: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

967: ,p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl
968: ,x_template_tbl => l_template_tbl
969: ,x_amount_tbl => l_amount_tbl);
970:
971: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
974: RAISE OKL_API.G_EXCEPTION_ERROR;
975: END IF;

Line 972: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

968: ,x_template_tbl => l_template_tbl
969: ,x_amount_tbl => l_amount_tbl);
970:
971: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
974: RAISE OKL_API.G_EXCEPTION_ERROR;
975: END IF;
976:

Line 973: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

969: ,x_amount_tbl => l_amount_tbl);
970:
971: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
974: RAISE OKL_API.G_EXCEPTION_ERROR;
975: END IF;
976:
977: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 974: RAISE OKL_API.G_EXCEPTION_ERROR;

970:
971: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
974: RAISE OKL_API.G_EXCEPTION_ERROR;
975: END IF;
976:
977: IF(IS_DEBUG_PROCEDURE_ON) THEN
978: BEGIN

Line 993: x_return_status := Okl_Api.G_RET_STS_ERROR;

989: -- stmathew bug#4547180 / 4573599 end
990: FETCH l_dstrs_count_csr INTO l_count;
991: CLOSE l_dstrs_count_csr;
992: IF (l_count < 4) THEN
993: x_return_status := Okl_Api.G_RET_STS_ERROR;
994: END IF;
995: END IF;
996: --End code changes for rev rec by fmiao on 10/05/2004
997:

Line 998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

994: END IF;
995: END IF;
996: --End code changes for rev rec by fmiao on 10/05/2004
997:
998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1001: RAISE OKL_API.G_EXCEPTION_ERROR;
1002: END IF;

Line 999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

995: END IF;
996: --End code changes for rev rec by fmiao on 10/05/2004
997:
998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1001: RAISE OKL_API.G_EXCEPTION_ERROR;
1002: END IF;
1003:

Line 1000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

996: --End code changes for rev rec by fmiao on 10/05/2004
997:
998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1001: RAISE OKL_API.G_EXCEPTION_ERROR;
1002: END IF;
1003:
1004: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

Line 1001: RAISE OKL_API.G_EXCEPTION_ERROR;

997:
998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1001: RAISE OKL_API.G_EXCEPTION_ERROR;
1002: END IF;
1003:
1004: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1005: NULL;

Line 1004: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1001: RAISE OKL_API.G_EXCEPTION_ERROR;
1002: END IF;
1003:
1004: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1005: NULL;
1006: --RAISE G_EXCEPTION_HALT_VALIDATION;
1007: ELSE
1008: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

Line 1008: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1004: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1005: NULL;
1006: --RAISE G_EXCEPTION_HALT_VALIDATION;
1007: ELSE
1008: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1009: l_return_status := x_return_status;
1010: END IF;
1011: END IF;
1012:

Line 1013: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1009: l_return_status := x_return_status;
1010: END IF;
1011: END IF;
1012:
1013: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1014: p_taiv_rec.trx_status_code := 'ERROR';
1015: ELSE
1016: p_taiv_rec.trx_status_code := 'SUBMITTED';
1017: END IF;*/

Line 1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1121: x_msg_data => x_msg_data,
1122: p_txsv_rec => lp_txsv_rec,
1123: x_txsv_rec => lx_txsv_rec);
1124:
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;

Line 1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1122: p_txsv_rec => lp_txsv_rec,
1123: x_txsv_rec => lx_txsv_rec);
1124:
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130:

Line 1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1123: x_txsv_rec => lx_txsv_rec);
1124:
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130:
1131: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1128: RAISE OKL_API.G_EXCEPTION_ERROR;

1124:
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130:
1131: IF(IS_DEBUG_PROCEDURE_ON) THEN
1132: BEGIN

Line 1206: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1202: x_msg_data => x_msg_data,
1203: p_ttdv_tbl => lp_ttdv_tbl,
1204: x_ttdv_tbl => lx_ttdv_tbl);
1205:
1206: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;

Line 1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1203: p_ttdv_tbl => lp_ttdv_tbl,
1204: x_ttdv_tbl => lx_ttdv_tbl);
1205:
1206: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211:

Line 1208: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1204: x_ttdv_tbl => lx_ttdv_tbl);
1205:
1206: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211:
1212: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1209: RAISE OKL_API.G_EXCEPTION_ERROR;

1205:
1206: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211:
1212: IF(IS_DEBUG_PROCEDURE_ON) THEN
1213: BEGIN

Line 1243: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1239: p_source_trx_id => p_bpd_acc_rec.id,
1240: p_source_trx_name => l_trx_name,
1241: p_source_table => p_bpd_acc_rec.source_table);
1242:
1243: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;

Line 1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1240: p_source_trx_name => l_trx_name,
1241: p_source_table => p_bpd_acc_rec.source_table);
1242:
1243: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248:

Line 1245: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1241: p_source_table => p_bpd_acc_rec.source_table);
1242:
1243: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248:
1249: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1246: RAISE OKL_API.G_EXCEPTION_ERROR;

1242:
1243: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248:
1249: IF(IS_DEBUG_PROCEDURE_ON) THEN
1250: BEGIN

Line 1339: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1335: x_msg_data => x_msg_data,
1336: p_txsv_rec => lp_txsv_rec,
1337: x_txsv_rec => lx_txsv_rec);
1338:
1339: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1342: RAISE OKL_API.G_EXCEPTION_ERROR;
1343: END IF;

Line 1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1336: p_txsv_rec => lp_txsv_rec,
1337: x_txsv_rec => lx_txsv_rec);
1338:
1339: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1342: RAISE OKL_API.G_EXCEPTION_ERROR;
1343: END IF;
1344:

Line 1341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1337: x_txsv_rec => lx_txsv_rec);
1338:
1339: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1342: RAISE OKL_API.G_EXCEPTION_ERROR;
1343: END IF;
1344:
1345: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1342: RAISE OKL_API.G_EXCEPTION_ERROR;

1338:
1339: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1342: RAISE OKL_API.G_EXCEPTION_ERROR;
1343: END IF;
1344:
1345: IF(IS_DEBUG_PROCEDURE_ON) THEN
1346: BEGIN

Line 1431: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1427: x_msg_data => x_msg_data,
1428: p_ttdv_tbl => lp_ttdv_tbl,
1429: x_ttdv_tbl => lx_ttdv_tbl);
1430:
1431: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1433: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1434: RAISE OKL_API.G_EXCEPTION_ERROR;
1435: END IF;

Line 1432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1428: p_ttdv_tbl => lp_ttdv_tbl,
1429: x_ttdv_tbl => lx_ttdv_tbl);
1430:
1431: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1433: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1434: RAISE OKL_API.G_EXCEPTION_ERROR;
1435: END IF;
1436:

Line 1433: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1429: x_ttdv_tbl => lx_ttdv_tbl);
1430:
1431: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1433: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1434: RAISE OKL_API.G_EXCEPTION_ERROR;
1435: END IF;
1436:
1437: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1434: RAISE OKL_API.G_EXCEPTION_ERROR;

1430:
1431: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1433: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1434: RAISE OKL_API.G_EXCEPTION_ERROR;
1435: END IF;
1436:
1437: IF(IS_DEBUG_PROCEDURE_ON) THEN
1438: BEGIN

Line 1452: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1448: */
1449: --ebtax impact on billing akrangan commented code ends here
1450: --Bug# 4488818: Changes for Rollover, Release Billing: End
1451:
1452: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1453: NULL;
1454: --RAISE G_EXCEPTION_HALT_VALIDATION;
1455: ELSE
1456: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

Line 1456: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1452: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1453: NULL;
1454: --RAISE G_EXCEPTION_HALT_VALIDATION;
1455: ELSE
1456: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1457: l_return_status := x_return_status;
1458: END IF;
1459: END IF;*/
1460:

Line 1571: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1567: x_msg_data => x_msg_data,
1568: p_txsv_rec => lp_txsv_rec,
1569: x_txsv_rec => lx_txsv_rec);
1570:
1571: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;

Line 1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1568: p_txsv_rec => lp_txsv_rec,
1569: x_txsv_rec => lx_txsv_rec);
1570:
1571: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;
1576:

Line 1573: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1569: x_txsv_rec => lx_txsv_rec);
1570:
1571: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;
1576:
1577: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1574: RAISE OKL_API.G_EXCEPTION_ERROR;

1570:
1571: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_ERROR;
1575: END IF;
1576:
1577: IF(IS_DEBUG_PROCEDURE_ON) THEN
1578: BEGIN

Line 1605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1601: x_msg_data => x_msg_data,
1602: p_ttdv_tbl => lp_ttdv_tbl,
1603: x_ttdv_tbl => lx_ttdv_tbl);
1604:
1605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1608: RAISE OKL_API.G_EXCEPTION_ERROR;
1609: END IF;

Line 1606: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1602: p_ttdv_tbl => lp_ttdv_tbl,
1603: x_ttdv_tbl => lx_ttdv_tbl);
1604:
1605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1608: RAISE OKL_API.G_EXCEPTION_ERROR;
1609: END IF;
1610:

Line 1607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1603: x_ttdv_tbl => lx_ttdv_tbl);
1604:
1605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1608: RAISE OKL_API.G_EXCEPTION_ERROR;
1609: END IF;
1610:
1611: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 1608: RAISE OKL_API.G_EXCEPTION_ERROR;

1604:
1605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1608: RAISE OKL_API.G_EXCEPTION_ERROR;
1609: END IF;
1610:
1611: IF(IS_DEBUG_PROCEDURE_ON) THEN
1612: BEGIN

Line 1622: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1618: --akrangan ebtax billing impacts end
1619: END IF;
1620: --Bug# 4488818: Changes for Upfront Sales Tax: End
1621:
1622: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1623:
1624: EXCEPTION
1625: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1626: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 1625: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1621:
1622: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1623:
1624: EXCEPTION
1625: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1626: x_return_status := Okl_Api.G_RET_STS_ERROR;
1627:
1628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 1626: x_return_status := Okl_Api.G_RET_STS_ERROR;

1622: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1623:
1624: EXCEPTION
1625: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1626: x_return_status := Okl_Api.G_RET_STS_ERROR;
1627:
1628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1630:

Line 1628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1624: EXCEPTION
1625: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1626: x_return_status := Okl_Api.G_RET_STS_ERROR;
1627:
1628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1630:
1631: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1632: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1625: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1626: x_return_status := Okl_Api.G_RET_STS_ERROR;
1627:
1628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1630:
1631: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1632: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1633: ,p_msg_name => g_unexpected_error

Line 1632: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

1628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1629: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1630:
1631: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1632: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1633: ,p_msg_name => g_unexpected_error
1634: ,p_token1 => g_sqlcode_token
1635: ,p_token1_value => SQLCODE
1636: ,p_token2 => g_sqlerrm_token

Line 1638: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1634: ,p_token1 => g_sqlcode_token
1635: ,p_token1_value => SQLCODE
1636: ,p_token2 => g_sqlerrm_token
1637: ,p_token2_value => SQLERRM);
1638: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1639: WHEN OTHERS THEN
1640: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1641: ,p_msg_name => g_unexpected_error
1642: ,p_token1 => g_sqlcode_token

Line 1640: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

1636: ,p_token2 => g_sqlerrm_token
1637: ,p_token2_value => SQLERRM);
1638: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1639: WHEN OTHERS THEN
1640: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
1641: ,p_msg_name => g_unexpected_error
1642: ,p_token1 => g_sqlcode_token
1643: ,p_token1_value => SQLCODE
1644: ,p_token2 => g_sqlerrm_token

Line 1646: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1642: ,p_token1 => g_sqlcode_token
1643: ,p_token1_value => SQLCODE
1644: ,p_token2 => g_sqlerrm_token
1645: ,p_token2_value => SQLERRM);
1646: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1647: END create_acc_trans;
1648:
1649: PROCEDURE create_acc_trans(
1650: p_api_version IN NUMBER

Line 2365: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2361: p_contract_line_id => l_acct_call_rec.kle_id,
2362: x_acc_gen_tbl => l_acc_gen_primary_key_tbl,
2363: x_return_status => x_return_status);
2364:
2365: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;

Line 2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2362: x_acc_gen_tbl => l_acc_gen_primary_key_tbl,
2363: x_return_status => x_return_status);
2364:
2365: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:

Line 2367: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2363: x_return_status => x_return_status);
2364:
2365: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:
2371: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

Line 2368: RAISE OKL_API.G_EXCEPTION_ERROR;

2364:
2365: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2367: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:
2371: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
2372: IF(L_DEBUG_ENABLED='Y') THEN

Line 2402: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2398: ,p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl
2399: ,x_template_tbl => l_template_tbl
2400: ,x_amount_tbl => l_amount_tbl);
2401:
2402: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_ERROR;
2406: END IF;

Line 2403: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2399: ,x_template_tbl => l_template_tbl
2400: ,x_amount_tbl => l_amount_tbl);
2401:
2402: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_ERROR;
2406: END IF;
2407: */

Line 2404: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2400: ,x_amount_tbl => l_amount_tbl);
2401:
2402: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_ERROR;
2406: END IF;
2407: */
2408: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2405: RAISE OKL_API.G_EXCEPTION_ERROR;

2401:
2402: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_ERROR;
2406: END IF;
2407: */
2408: IF(IS_DEBUG_PROCEDURE_ON) THEN
2409: BEGIN

Line 2425: x_return_status := Okl_Api.G_RET_STS_ERROR;

2421: -- stmathew bug#4547180 / 4573599 end
2422: FETCH l_dstrs_count_csr INTO l_count;
2423: CLOSE l_dstrs_count_csr;
2424: IF (l_count < 4) THEN
2425: x_return_status := Okl_Api.G_RET_STS_ERROR;
2426: END IF;
2427: END IF;
2428: --End code changes for rev rec by fmiao on 10/05/2004
2429:

Line 2430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2426: END IF;
2427: END IF;
2428: --End code changes for rev rec by fmiao on 10/05/2004
2429:
2430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF; */

Line 2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2427: END IF;
2428: --End code changes for rev rec by fmiao on 10/05/2004
2429:
2430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF; */
2435:

Line 2432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2428: --End code changes for rev rec by fmiao on 10/05/2004
2429:
2430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF; */
2435:
2436: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

Line 2433: RAISE OKL_API.G_EXCEPTION_ERROR;

2429:
2430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF; */
2435:
2436: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2437: NULL;

Line 2436: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2433: RAISE OKL_API.G_EXCEPTION_ERROR;
2434: END IF; */
2435:
2436: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2437: NULL;
2438: --RAISE G_EXCEPTION_HALT_VALIDATION;
2439: ELSE
2440: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

Line 2440: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2436: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2437: NULL;
2438: --RAISE G_EXCEPTION_HALT_VALIDATION;
2439: ELSE
2440: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2441: l_return_status := x_return_status;
2442: END IF;
2443: END IF;
2444:

Line 2445: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2441: l_return_status := x_return_status;
2442: END IF;
2443: END IF;
2444:
2445: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2446: p_taiv_rec.trx_status_code := 'ERROR';
2447: ELSE
2448: p_taiv_rec.trx_status_code := 'SUBMITTED';
2449: END IF;*/

Line 2557: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2553: x_msg_data => x_msg_data,
2554: p_txsv_rec => lp_txsv_rec,
2555: x_txsv_rec => lx_txsv_rec);
2556:
2557: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2558: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2559: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2560: RAISE OKL_API.G_EXCEPTION_ERROR;
2561: END IF;

Line 2558: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2554: p_txsv_rec => lp_txsv_rec,
2555: x_txsv_rec => lx_txsv_rec);
2556:
2557: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2558: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2559: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2560: RAISE OKL_API.G_EXCEPTION_ERROR;
2561: END IF;
2562:

Line 2559: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2555: x_txsv_rec => lx_txsv_rec);
2556:
2557: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2558: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2559: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2560: RAISE OKL_API.G_EXCEPTION_ERROR;
2561: END IF;
2562:
2563: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2560: RAISE OKL_API.G_EXCEPTION_ERROR;

2556:
2557: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2558: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2559: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2560: RAISE OKL_API.G_EXCEPTION_ERROR;
2561: END IF;
2562:
2563: IF(IS_DEBUG_PROCEDURE_ON) THEN
2564: BEGIN

Line 2638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2634: x_msg_data => x_msg_data,
2635: p_ttdv_tbl => lp_ttdv_tbl,
2636: x_ttdv_tbl => lx_ttdv_tbl);
2637:
2638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_ERROR;
2642: END IF;

Line 2639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2635: p_ttdv_tbl => lp_ttdv_tbl,
2636: x_ttdv_tbl => lx_ttdv_tbl);
2637:
2638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_ERROR;
2642: END IF;
2643:

Line 2640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2636: x_ttdv_tbl => lx_ttdv_tbl);
2637:
2638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_ERROR;
2642: END IF;
2643:
2644: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2641: RAISE OKL_API.G_EXCEPTION_ERROR;

2637:
2638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_ERROR;
2642: END IF;
2643:
2644: IF(IS_DEBUG_PROCEDURE_ON) THEN
2645: BEGIN

Line 2675: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2671: p_source_trx_id => p_bpd_acc_rec.id,
2672: p_source_trx_name => l_trx_name,
2673: p_source_table => p_bpd_acc_rec.source_table);
2674:
2675: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2677: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2678: RAISE OKL_API.G_EXCEPTION_ERROR;
2679: END IF;

Line 2676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2672: p_source_trx_name => l_trx_name,
2673: p_source_table => p_bpd_acc_rec.source_table);
2674:
2675: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2677: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2678: RAISE OKL_API.G_EXCEPTION_ERROR;
2679: END IF;
2680:

Line 2677: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2673: p_source_table => p_bpd_acc_rec.source_table);
2674:
2675: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2677: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2678: RAISE OKL_API.G_EXCEPTION_ERROR;
2679: END IF;
2680:
2681: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2678: RAISE OKL_API.G_EXCEPTION_ERROR;

2674:
2675: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2677: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2678: RAISE OKL_API.G_EXCEPTION_ERROR;
2679: END IF;
2680:
2681: IF(IS_DEBUG_PROCEDURE_ON) THEN
2682: BEGIN

Line 2771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2767: x_msg_data => x_msg_data,
2768: p_txsv_rec => lp_txsv_rec,
2769: x_txsv_rec => lx_txsv_rec);
2770:
2771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;

Line 2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2768: p_txsv_rec => lp_txsv_rec,
2769: x_txsv_rec => lx_txsv_rec);
2770:
2771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;
2776:

Line 2773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2769: x_txsv_rec => lx_txsv_rec);
2770:
2771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;
2776:
2777: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2774: RAISE OKL_API.G_EXCEPTION_ERROR;

2770:
2771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;
2776:
2777: IF(IS_DEBUG_PROCEDURE_ON) THEN
2778: BEGIN

Line 2863: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2859: x_msg_data => x_msg_data,
2860: p_ttdv_tbl => lp_ttdv_tbl,
2861: x_ttdv_tbl => lx_ttdv_tbl);
2862:
2863: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2865: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2866: RAISE OKL_API.G_EXCEPTION_ERROR;
2867: END IF;

Line 2864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2860: p_ttdv_tbl => lp_ttdv_tbl,
2861: x_ttdv_tbl => lx_ttdv_tbl);
2862:
2863: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2865: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2866: RAISE OKL_API.G_EXCEPTION_ERROR;
2867: END IF;
2868:

Line 2865: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2861: x_ttdv_tbl => lx_ttdv_tbl);
2862:
2863: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2865: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2866: RAISE OKL_API.G_EXCEPTION_ERROR;
2867: END IF;
2868:
2869: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2866: RAISE OKL_API.G_EXCEPTION_ERROR;

2862:
2863: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2865: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2866: RAISE OKL_API.G_EXCEPTION_ERROR;
2867: END IF;
2868:
2869: IF(IS_DEBUG_PROCEDURE_ON) THEN
2870: BEGIN

Line 2884: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2880: */
2881: --ebtax impact on billing akrangan commented code ends here
2882: --Bug# 4488818: Changes for Rollover, Release Billing: End
2883:
2884: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2885: NULL;
2886: --RAISE G_EXCEPTION_HALT_VALIDATION;
2887: ELSE
2888: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

Line 2888: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2884: /*IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2885: NULL;
2886: --RAISE G_EXCEPTION_HALT_VALIDATION;
2887: ELSE
2888: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2889: l_return_status := x_return_status;
2890: END IF;
2891: END IF;*/
2892:

Line 3003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2999: x_msg_data => x_msg_data,
3000: p_txsv_rec => lp_txsv_rec,
3001: x_txsv_rec => lx_txsv_rec);
3002:
3003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3005: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3006: RAISE OKL_API.G_EXCEPTION_ERROR;
3007: END IF;

Line 3004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3000: p_txsv_rec => lp_txsv_rec,
3001: x_txsv_rec => lx_txsv_rec);
3002:
3003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3005: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3006: RAISE OKL_API.G_EXCEPTION_ERROR;
3007: END IF;
3008:

Line 3005: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3001: x_txsv_rec => lx_txsv_rec);
3002:
3003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3005: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3006: RAISE OKL_API.G_EXCEPTION_ERROR;
3007: END IF;
3008:
3009: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3006: RAISE OKL_API.G_EXCEPTION_ERROR;

3002:
3003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3005: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3006: RAISE OKL_API.G_EXCEPTION_ERROR;
3007: END IF;
3008:
3009: IF(IS_DEBUG_PROCEDURE_ON) THEN
3010: BEGIN

Line 3037: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3033: x_msg_data => x_msg_data,
3034: p_ttdv_tbl => lp_ttdv_tbl,
3035: x_ttdv_tbl => lx_ttdv_tbl);
3036:
3037: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3039: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3040: RAISE OKL_API.G_EXCEPTION_ERROR;
3041: END IF;

Line 3038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3034: p_ttdv_tbl => lp_ttdv_tbl,
3035: x_ttdv_tbl => lx_ttdv_tbl);
3036:
3037: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3039: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3040: RAISE OKL_API.G_EXCEPTION_ERROR;
3041: END IF;
3042:

Line 3039: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

3035: x_ttdv_tbl => lx_ttdv_tbl);
3036:
3037: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3039: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3040: RAISE OKL_API.G_EXCEPTION_ERROR;
3041: END IF;
3042:
3043: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3040: RAISE OKL_API.G_EXCEPTION_ERROR;

3036:
3037: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3039: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3040: RAISE OKL_API.G_EXCEPTION_ERROR;
3041: END IF;
3042:
3043: IF(IS_DEBUG_PROCEDURE_ON) THEN
3044: BEGIN

Line 3054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

3050: --akrangan ebtax billing impacts end
3051: END IF;
3052: --Bug# 4488818: Changes for Upfront Sales Tax: End
3053:
3054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
3055:
3056: EXCEPTION
3057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3058: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 3057: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3053:
3054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
3055:
3056: EXCEPTION
3057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3058: x_return_status := Okl_Api.G_RET_STS_ERROR;
3059:
3060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3061: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 3058: x_return_status := Okl_Api.G_RET_STS_ERROR;

3054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
3055:
3056: EXCEPTION
3057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3058: x_return_status := Okl_Api.G_RET_STS_ERROR;
3059:
3060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3061: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3062:

Line 3060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3056: EXCEPTION
3057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3058: x_return_status := Okl_Api.G_RET_STS_ERROR;
3059:
3060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3061: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3062:
3063: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3064: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

Line 3061: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

3057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3058: x_return_status := Okl_Api.G_RET_STS_ERROR;
3059:
3060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3061: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3062:
3063: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3064: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
3065: ,p_msg_name => g_unexpected_error

Line 3064: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

3060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3061: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3062:
3063: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3064: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
3065: ,p_msg_name => g_unexpected_error
3066: ,p_token1 => g_sqlcode_token
3067: ,p_token1_value => SQLCODE
3068: ,p_token2 => g_sqlerrm_token

Line 3070: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

3066: ,p_token1 => g_sqlcode_token
3067: ,p_token1_value => SQLCODE
3068: ,p_token2 => g_sqlerrm_token
3069: ,p_token2_value => SQLERRM);
3070: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3071: WHEN OTHERS THEN
3072: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
3073: ,p_msg_name => g_unexpected_error
3074: ,p_token1 => g_sqlcode_token

Line 3072: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

3068: ,p_token2 => g_sqlerrm_token
3069: ,p_token2_value => SQLERRM);
3070: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3071: WHEN OTHERS THEN
3072: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
3073: ,p_msg_name => g_unexpected_error
3074: ,p_token1 => g_sqlcode_token
3075: ,p_token1_value => SQLCODE
3076: ,p_token2 => g_sqlerrm_token

Line 3078: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

3074: ,p_token1 => g_sqlcode_token
3075: ,p_token1_value => SQLCODE
3076: ,p_token2 => g_sqlerrm_token
3077: ,p_token2_value => SQLERRM);
3078: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3079: END create_acc_trans_new;
3080:
3081:
3082: