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.OKS_AUTH_UTIL_PVT dependencies on FND_LOG

Line 8717: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8713:
8714: BEGIN
8715:
8716: --log key input parameters
8717: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8718: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_chr_id='|| p_chr_id);
8719: END IF;
8720:
8721: --standard api initilization and checks

Line 8718: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_chr_id='|| p_chr_id);

8714: BEGIN
8715:
8716: --log key input parameters
8717: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8718: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_chr_id='|| p_chr_id);
8719: END IF;
8720:
8721: --standard api initilization and checks
8722: SAVEPOINT check_update_amounts_PVT;

Line 8735: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8731: --get all toplines that are out of sync with sublines
8732: OPEN c_k_toplines(p_chr_id);
8733: LOOP
8734: FETCH c_k_toplines BULK COLLECT INTO l_tl_id_tbl, l_tl_amt_tbl, l_sl_amt_tbl,l_tl_amt_tax_tbl,l_sl_amt_tax_tbl LIMIT G_BULK_FETCH_LIMIT;
8735: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8736: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_toplines.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);
8737: END IF;
8738:
8739: EXIT WHEN (l_tl_id_tbl.count = 0);

Line 8736: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_toplines.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);

8732: OPEN c_k_toplines(p_chr_id);
8733: LOOP
8734: FETCH c_k_toplines BULK COLLECT INTO l_tl_id_tbl, l_tl_amt_tbl, l_sl_amt_tbl,l_tl_amt_tax_tbl,l_sl_amt_tax_tbl LIMIT G_BULK_FETCH_LIMIT;
8735: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8736: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_toplines.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);
8737: END IF;
8738:
8739: EXIT WHEN (l_tl_id_tbl.count = 0);
8740:

Line 8748: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8744: --if the lock fails, another user is holding the lock, exit with appropriate
8745: --error message. If the lock succeeds, update the top line amount
8746: BEGIN
8747:
8748: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8749: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8750: END IF;
8751:
8752: IF (l_tl_amt_tbl(i) <> l_sl_amt_tbl(i))OR ( l_tl_amt_tax_tbl(i) <> l_sl_amt_tax_tbl(i)) THEN

Line 8749: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));

8745: --error message. If the lock succeeds, update the top line amount
8746: BEGIN
8747:
8748: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8749: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8750: END IF;
8751:
8752: IF (l_tl_amt_tbl(i) <> l_sl_amt_tbl(i))OR ( l_tl_amt_tax_tbl(i) <> l_sl_amt_tax_tbl(i)) THEN
8753: OPEN c_lock_tl(l_tl_id_tbl(i));

Line 8770: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

8766: --set the error message on the error stack to inform the user
8767: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8768: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8769:
8770: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8771: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8772: END IF;
8773: FND_MSG_PUB.ADD;
8774:

Line 8771: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);

8767: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8768: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8769:
8770: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8771: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8772: END IF;
8773: FND_MSG_PUB.ADD;
8774:
8775: l_tl_id_tbl.delete;

Line 8787: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8783: END; --of anonymous block checking topline locks
8784:
8785: END LOOP;
8786:
8787: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8788: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');
8789: END IF;
8790:
8791: --if we come till here, we where able to obtain locks on all the toplines fectched previously

Line 8788: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');

8784:
8785: END LOOP;
8786:
8787: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8788: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');
8789: END IF;
8790:
8791: --if we come till here, we where able to obtain locks on all the toplines fectched previously
8792: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last

Line 8802: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8798: UPDATE oks_k_lines_b
8799: SET tax_amount = l_sl_amt_tax_tbl(j)
8800: WHERE cle_id = l_tl_id_tbl(j);
8801:
8802: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8803: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');
8804: END IF;
8805:
8806: END LOOP; --of bulk fetch loop

Line 8803: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');

8799: SET tax_amount = l_sl_amt_tax_tbl(j)
8800: WHERE cle_id = l_tl_id_tbl(j);
8801:
8802: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8803: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');
8804: END IF;
8805:
8806: END LOOP; --of bulk fetch loop
8807: CLOSE c_k_toplines;

Line 8818: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8814: --cgopinee bugfix for 7717417
8815: OPEN c_k_tl_zero_sl(p_chr_id);
8816: LOOP
8817: FETCH c_k_tl_zero_sl BULK COLLECT INTO l_tl_id_tbl, l_tl_amt_tbl, l_sl_amt_tbl,l_tl_amt_tax_tbl,l_sl_amt_tax_tbl LIMIT G_BULK_FETCH_LIMIT;
8818: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8819: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_tl_zero_sl.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);
8820: END IF;
8821:
8822: EXIT WHEN (l_tl_id_tbl.count = 0);

Line 8819: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_tl_zero_sl.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);

8815: OPEN c_k_tl_zero_sl(p_chr_id);
8816: LOOP
8817: FETCH c_k_tl_zero_sl BULK COLLECT INTO l_tl_id_tbl, l_tl_amt_tbl, l_sl_amt_tbl,l_tl_amt_tax_tbl,l_sl_amt_tax_tbl LIMIT G_BULK_FETCH_LIMIT;
8818: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8819: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_tl_zero_sl.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);
8820: END IF;
8821:
8822: EXIT WHEN (l_tl_id_tbl.count = 0);
8823:

Line 8831: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8827: --if the lock fails, another user is holding the lock, exit with appropriate
8828: --error message. If the lock succeeds, update the top line amount
8829: BEGIN
8830:
8831: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8832: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8833: END IF;
8834:
8835: IF (l_tl_amt_tbl(i) <> l_sl_amt_tbl(i))OR ( l_tl_amt_tax_tbl(i) <> l_sl_amt_tax_tbl(i)) THEN

Line 8832: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));

8828: --error message. If the lock succeeds, update the top line amount
8829: BEGIN
8830:
8831: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8832: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8833: END IF;
8834:
8835: IF (l_tl_amt_tbl(i) <> l_sl_amt_tbl(i))OR ( l_tl_amt_tax_tbl(i) <> l_sl_amt_tax_tbl(i)) THEN
8836: OPEN c_lock_tl(l_tl_id_tbl(i));

Line 8853: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

8849: --set the error message on the error stack to inform the user
8850: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8851: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8852:
8853: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8854: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8855: END IF;
8856: FND_MSG_PUB.ADD;
8857:

Line 8854: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);

8850: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8851: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8852:
8853: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8854: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8855: END IF;
8856: FND_MSG_PUB.ADD;
8857:
8858: l_tl_id_tbl.delete;

Line 8869: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8865:
8866: END; --of anonymous block checking topline locks
8867: END LOOP;
8868:
8869: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8870: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');
8871: END IF;
8872:
8873: --if we come till here, we where able to obtain locks on all the toplines fectched previously

Line 8870: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');

8866: END; --of anonymous block checking topline locks
8867: END LOOP;
8868:
8869: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8870: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');
8871: END IF;
8872:
8873: --if we come till here, we where able to obtain locks on all the toplines fectched previously
8874: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last

Line 8884: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8880: UPDATE oks_k_lines_b
8881: SET tax_amount = l_sl_amt_tax_tbl(j)
8882: WHERE cle_id = l_tl_id_tbl(j);
8883:
8884: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8885: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');
8886: END IF;
8887: END LOOP; --of bulk fetch loop
8888:

Line 8885: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');

8881: SET tax_amount = l_sl_amt_tax_tbl(j)
8882: WHERE cle_id = l_tl_id_tbl(j);
8883:
8884: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8885: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');
8886: END IF;
8887: END LOOP; --of bulk fetch loop
8888:
8889: CLOSE c_k_tl_zero_sl;

Line 8901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8897: OPEN c_k_hdr(p_chr_id);
8898: FETCH c_k_hdr INTO l_k_num, l_hdr_amt, l_tl_amt,l_hdr_amt_tax,l_tl_amt_tax;
8899: CLOSE c_k_hdr;
8900:
8901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);
8903: END IF;
8904:
8905: --update the header only if required

Line 8902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);

8898: FETCH c_k_hdr INTO l_k_num, l_hdr_amt, l_tl_amt,l_hdr_amt_tax,l_tl_amt_tax;
8899: CLOSE c_k_hdr;
8900:
8901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);
8903: END IF;
8904:
8905: --update the header only if required
8906: IF (l_hdr_amt <> l_tl_amt) OR(l_hdr_amt_tax <> l_tl_amt_tax) THEN

Line 8913: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8909: --if the lock fails, another user is holding the lock, exit with appropriate
8910: --error message. If the lock succeeds, update the header amount
8911: BEGIN
8912:
8913: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8914: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8915: END IF;
8916:
8917: OPEN c_lock_hdr(p_chr_id);

Line 8914: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);

8910: --error message. If the lock succeeds, update the header amount
8911: BEGIN
8912:
8913: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8914: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8915: END IF;
8916:
8917: OPEN c_lock_hdr(p_chr_id);
8918: FETCH c_lock_hdr INTO l_dummy;

Line 8942: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

8938: --set the error message on the error stack to inform the user
8939: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8940: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8941:
8942: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8943: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8944: END IF;
8945: FND_MSG_PUB.ADD;
8946:

Line 8943: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);

8939: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8940: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8941:
8942: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8943: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8944: END IF;
8945: FND_MSG_PUB.ADD;
8946:
8947: RAISE FND_API.g_exc_error;

Line 8958: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8954: OPEN c_k_hdr_zero_tl(p_chr_id);
8955: FETCH c_k_hdr_zero_tl INTO l_k_num, l_hdr_amt, l_tl_amt,l_hdr_amt_tax,l_tl_amt_tax;
8956: CLOSE c_k_hdr_zero_tl;
8957:
8958: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8959: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);
8960: END IF;
8961:
8962: --update the header only if required

Line 8959: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);

8955: FETCH c_k_hdr_zero_tl INTO l_k_num, l_hdr_amt, l_tl_amt,l_hdr_amt_tax,l_tl_amt_tax;
8956: CLOSE c_k_hdr_zero_tl;
8957:
8958: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8959: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);
8960: END IF;
8961:
8962: --update the header only if required
8963: IF (l_hdr_amt <> l_tl_amt) OR(l_hdr_amt_tax <> l_tl_amt_tax) THEN

Line 8970: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

8966: --if the lock fails, another user is holding the lock, exit with appropriate
8967: --error message. If the lock succeeds, update the header amount
8968: BEGIN
8969:
8970: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8971: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8972: END IF;
8973:
8974: OPEN c_lock_hdr(p_chr_id);

Line 8971: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);

8967: --error message. If the lock succeeds, update the header amount
8968: BEGIN
8969:
8970: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8971: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8972: END IF;
8973:
8974: OPEN c_lock_hdr(p_chr_id);
8975: FETCH c_lock_hdr INTO l_dummy;

Line 8999: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

8995: --set the error message on the error stack to inform the user
8996: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8997: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8998:
8999: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9000: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9001: END IF;
9002: FND_MSG_PUB.ADD;
9003:

Line 9000: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);

8996: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8997: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8998:
8999: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9000: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9001: END IF;
9002: FND_MSG_PUB.ADD;
9003:
9004: RAISE FND_API.g_exc_error;

Line 9015: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

9011: -- to update cancelled amount of toplines.First get all toplines that are out of sync with sublines
9012: OPEN c_k_toplines_cancelled(p_chr_id);
9013: LOOP
9014: FETCH c_k_toplines_cancelled BULK COLLECT INTO l_tl_id_tbl, l_tl_amt_tbl, l_sl_amt_tbl LIMIT G_BULK_FETCH_LIMIT;
9015: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9016: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_toplines_cancelled.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);
9017: END IF;
9018:
9019: EXIT WHEN (l_tl_id_tbl.count = 0);

Line 9016: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_toplines_cancelled.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);

9012: OPEN c_k_toplines_cancelled(p_chr_id);
9013: LOOP
9014: FETCH c_k_toplines_cancelled BULK COLLECT INTO l_tl_id_tbl, l_tl_amt_tbl, l_sl_amt_tbl LIMIT G_BULK_FETCH_LIMIT;
9015: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9016: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.c_k_toplines_cancelled.bulk_fetch', 'l_tl_id_tbl.count='||l_tl_id_tbl.count);
9017: END IF;
9018:
9019: EXIT WHEN (l_tl_id_tbl.count = 0);
9020:

Line 9028: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

9024: --if the lock fails, another user is holding the lock, exit with appropriate
9025: --error message. If the lock succeeds, update the top line cancelled amount
9026: BEGIN
9027:
9028: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9029: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
9030: END IF;
9031:
9032: OPEN c_lock_tl(l_tl_id_tbl(i));

Line 9029: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));

9025: --error message. If the lock succeeds, update the top line cancelled amount
9026: BEGIN
9027:
9028: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9029: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
9030: END IF;
9031:
9032: OPEN c_lock_tl(l_tl_id_tbl(i));
9033: FETCH c_lock_tl INTO l_dummy;

Line 9049: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

9045: --set the error message on the error stack to inform the user
9046: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
9047: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
9048:
9049: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9050: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
9051: END IF;
9052: FND_MSG_PUB.ADD;
9053:

Line 9050: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);

9046: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
9047: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
9048:
9049: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9050: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
9051: END IF;
9052: FND_MSG_PUB.ADD;
9053:
9054: l_tl_id_tbl.delete;

Line 9064: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

9060: END; --of anonymous block checking topline locks
9061:
9062: END LOOP;
9063:
9064: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9065: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating canceled amount');
9066: END IF;
9067:
9068: --if we come till here, we where able to obtain locks on all the toplines fectched previously

Line 9065: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating canceled amount');

9061:
9062: END LOOP;
9063:
9064: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9065: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating canceled amount');
9066: END IF;
9067:
9068: --if we come till here, we where able to obtain locks on all the toplines fectched previously
9069: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last

Line 9074: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

9070: update okc_k_lines_b
9071: set cancelled_amount =l_sl_amt_tbl(j)
9072: where id=l_tl_id_tbl(j);
9073:
9074: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9075: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'cancelled amounts updated');
9076: END IF;
9077:
9078: END LOOP; --of bulk fetch loop

Line 9075: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'cancelled amounts updated');

9071: set cancelled_amount =l_sl_amt_tbl(j)
9072: where id=l_tl_id_tbl(j);
9073:
9074: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9075: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'cancelled amounts updated');
9076: END IF;
9077:
9078: END LOOP; --of bulk fetch loop
9079: CLOSE c_k_toplines_cancelled;

Line 9085: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

9081: l_tl_amt_tbl.delete;
9082: l_sl_amt_tbl.delete;
9083:
9084: -- update cancelled amount in header
9085: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9086: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_header', 'to update header cancelled amount not equal to sum of toplines.');
9087: END IF;
9088:
9089: OPEN c_k_hdr_cancelled(p_chr_id);

Line 9086: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_header', 'to update header cancelled amount not equal to sum of toplines.');

9082: l_sl_amt_tbl.delete;
9083:
9084: -- update cancelled amount in header
9085: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9086: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_header', 'to update header cancelled amount not equal to sum of toplines.');
9087: END IF;
9088:
9089: OPEN c_k_hdr_cancelled(p_chr_id);
9090: FETCH c_k_hdr_cancelled INTO l_header_cancelled,l_topline_cancelled;

Line 9101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

9097: --if the lock fails, another user is holding the lock, exit with appropriate
9098: --error message. If the lock succeeds, update the header amount
9099: BEGIN
9100:
9101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9102: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
9103: END IF;
9104:
9105: OPEN c_lock_hdr(p_chr_id);

Line 9102: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);

9098: --error message. If the lock succeeds, update the header amount
9099: BEGIN
9100:
9101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9102: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
9103: END IF;
9104:
9105: OPEN c_lock_hdr(p_chr_id);
9106: FETCH c_lock_hdr INTO l_dummy;

Line 9122: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

9118: --set the error message on the error stack to inform the user
9119: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
9120: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
9121:
9122: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9123: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9124: END IF;
9125: FND_MSG_PUB.ADD;
9126:

Line 9123: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);

9119: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
9120: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
9121:
9122: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9123: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
9124: END IF;
9125: FND_MSG_PUB.ADD;
9126:
9127: RAISE FND_API.g_exc_error;

Line 9138: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9134: COMMIT;
9135: END IF;
9136:
9137: --exit
9138: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9139: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9140: END IF;
9141: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9142:

Line 9139: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

9135: END IF;
9136:
9137: --exit
9138: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9139: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9140: END IF;
9141: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9142:
9143: EXCEPTION

Line 9148: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

9144: WHEN FND_API.g_exc_error THEN
9145: ROLLBACK TO check_update_amounts_PVT;
9146: x_return_status := FND_API.g_ret_sts_error ;
9147:
9148: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9149: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
9150: END IF;
9151: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9152: IF (c_k_toplines%isopen) THEN

Line 9149: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

9145: ROLLBACK TO check_update_amounts_PVT;
9146: x_return_status := FND_API.g_ret_sts_error ;
9147:
9148: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
9149: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
9150: END IF;
9151: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9152: IF (c_k_toplines%isopen) THEN
9153: CLOSE c_k_toplines;

Line 9173: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

9169: WHEN FND_API.g_exc_unexpected_error THEN
9170: ROLLBACK TO check_update_amounts_PVT;
9171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9172:
9173: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9174: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
9175: END IF;
9176: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9177: IF (c_k_toplines%isopen) THEN

Line 9174: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

9170: ROLLBACK TO check_update_amounts_PVT;
9171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9172:
9173: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9174: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
9175: END IF;
9176: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
9177: IF (c_k_toplines%isopen) THEN
9178: CLOSE c_k_toplines;

Line 9197: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

9193: WHEN OTHERS THEN
9194: ROLLBACK TO check_update_amounts_PVT;
9195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9196:
9197: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9198: --first log the sqlerrm
9199: l_error_text := substr (SQLERRM, 1, 240);
9200: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
9201: --then add it to the message api list

Line 9200: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

9196:
9197: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
9198: --first log the sqlerrm
9199: l_error_text := substr (SQLERRM, 1, 240);
9200: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
9201: --then add it to the message api list
9202: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
9203: END IF;
9204: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

Line 9286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9282: AND phase_code NOT IN ('C'); --- IN ('P','R'); SKUCHIMA
9283:
9284:
9285: BEGIN
9286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9287: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9288: END IF;
9289:
9290: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9287: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);

9283:
9284:
9285: BEGIN
9286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9287: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9288: END IF;
9289:
9290: x_return_status := FND_API.G_RET_STS_SUCCESS;
9291:

Line 9312: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9308: ELSE
9309: x_return_status := FND_API.G_RET_STS_SUCCESS;
9310: END IF;
9311:
9312: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9313: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9314: END IF;
9315:
9316: EXCEPTION

Line 9313: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

9309: x_return_status := FND_API.G_RET_STS_SUCCESS;
9310: END IF;
9311:
9312: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9313: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9314: END IF;
9315:
9316: EXCEPTION
9317: WHEN OTHERS THEN

Line 9319: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9315:
9316: EXCEPTION
9317: WHEN OTHERS THEN
9318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9319: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9320: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9321: END IF;
9322:
9323: END CHECK_REPRICE_REQUEST;

Line 9320: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

9316: EXCEPTION
9317: WHEN OTHERS THEN
9318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9319: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9320: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9321: END IF;
9322:
9323: END CHECK_REPRICE_REQUEST;
9324:

Line 9364: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9360: AND phase_code NOT IN ('C');
9361:
9362:
9363: BEGIN
9364: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9365: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9366: END IF;
9367:
9368: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9365: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);

9361:
9362:
9363: BEGIN
9364: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9365: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9366: END IF;
9367:
9368: x_return_status := FND_API.G_RET_STS_SUCCESS;
9369:

Line 9390: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9386: ELSE
9387: x_return_status := FND_API.G_RET_STS_SUCCESS;
9388: END IF;
9389:
9390: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9391: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9392: END IF;
9393:
9394: EXCEPTION

Line 9391: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

9387: x_return_status := FND_API.G_RET_STS_SUCCESS;
9388: END IF;
9389:
9390: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9391: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9392: END IF;
9393:
9394: EXCEPTION
9395: WHEN OTHERS THEN

Line 9397: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9393:
9394: EXCEPTION
9395: WHEN OTHERS THEN
9396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9397: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9398: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9399: END IF;
9400:
9401: END CHECK_CASCADE_REQUEST;

Line 9398: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

9394: EXCEPTION
9395: WHEN OTHERS THEN
9396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9397: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9398: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9399: END IF;
9400:
9401: END CHECK_CASCADE_REQUEST;
9402: /*11687112 -Cascade ER*/

Line 9592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9588:
9589: BEGIN
9590:
9591: -- start debug log
9592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9593:
9594: FND_LOG.string(FND_LOG.level_procedure,
9595: l_mod_name,
9596: '100: Entered INTO revalue contract ');

Line 9594: FND_LOG.string(FND_LOG.level_procedure,

9590:
9591: -- start debug log
9592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9593:
9594: FND_LOG.string(FND_LOG.level_procedure,
9595: l_mod_name,
9596: '100: Entered INTO revalue contract ');
9597: FND_LOG.string(FND_LOG.level_procedure,
9598: l_mod_name,

Line 9597: FND_LOG.string(FND_LOG.level_procedure,

9593:
9594: FND_LOG.string(FND_LOG.level_procedure,
9595: l_mod_name,
9596: '100: Entered INTO revalue contract ');
9597: FND_LOG.string(FND_LOG.level_procedure,
9598: l_mod_name,
9599: 'p_chr_id ' || p_chr_id);
9600: FND_LOG.string(FND_LOG.level_procedure,
9601: l_mod_name,

Line 9600: FND_LOG.string(FND_LOG.level_procedure,

9596: '100: Entered INTO revalue contract ');
9597: FND_LOG.string(FND_LOG.level_procedure,
9598: l_mod_name,
9599: 'p_chr_id ' || p_chr_id);
9600: FND_LOG.string(FND_LOG.level_procedure,
9601: l_mod_name,
9602: 'p_new_conversion_rate ' || p_new_conversion_rate);
9603:
9604: END IF;

Line 9618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9614: WHERE id = p_chr_id;*/
9615:
9616: l_old_conversion_rate:= Nvl(p_old_conversion_rate,1);
9617:
9618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9619:
9620: FND_LOG.string(FND_LOG.level_procedure,
9621: l_mod_name,
9622: 'l_old_conversion_rate ' || l_old_conversion_rate);

Line 9620: FND_LOG.string(FND_LOG.level_procedure,

9616: l_old_conversion_rate:= Nvl(p_old_conversion_rate,1);
9617:
9618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9619:
9620: FND_LOG.string(FND_LOG.level_procedure,
9621: l_mod_name,
9622: 'l_old_conversion_rate ' || l_old_conversion_rate);
9623:
9624: END IF;

Line 9652: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9648: x_msg_data => l_msg_data);
9649:
9650: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9651:
9652: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9653:
9654: FND_LOG.string(FND_LOG.level_procedure,
9655: l_mod_name,
9656: ' error updating subscription line in revalue contract ' ||

Line 9654: FND_LOG.string(FND_LOG.level_procedure,

9650: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9651:
9652: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9653:
9654: FND_LOG.string(FND_LOG.level_procedure,
9655: l_mod_name,
9656: ' error updating subscription line in revalue contract ' ||
9657: l_topline_rec.id);
9658:

Line 9689: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9685:
9686:
9687: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9688:
9689: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9690:
9691: FND_LOG.string(FND_LOG.level_procedure,
9692: l_mod_name,
9693: ' error updating amounts for a line ' ||

Line 9691: FND_LOG.string(FND_LOG.level_procedure,

9687: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9688:
9689: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9690:
9691: FND_LOG.string(FND_LOG.level_procedure,
9692: l_mod_name,
9693: ' error updating amounts for a line ' ||
9694: l_subline_rec.id);
9695:

Line 9726: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9722: X_MSG_DATA => L_MSG_DATA);
9723:
9724: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9725:
9726: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9727:
9728: FND_LOG.string(FND_LOG.level_procedure,
9729: l_mod_name,
9730: ' error updating sub line in revalue contract ' ||

Line 9728: FND_LOG.string(FND_LOG.level_procedure,

9724: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9725:
9726: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9727:
9728: FND_LOG.string(FND_LOG.level_procedure,
9729: l_mod_name,
9730: ' error updating sub line in revalue contract ' ||
9731: l_subline_rec.id);
9732:

Line 9759: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9755: x_clev_rec => l_clev_rec_out);
9756:
9757: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9758:
9759: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9760:
9761: FND_LOG.string(FND_LOG.level_procedure,
9762: l_mod_name,
9763: ' error updating amounts for a line ' ||

Line 9761: FND_LOG.string(FND_LOG.level_procedure,

9757: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9758:
9759: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9760:
9761: FND_LOG.string(FND_LOG.level_procedure,
9762: l_mod_name,
9763: ' error updating amounts for a line ' ||
9764: l_topline_rec.id);
9765:

Line 9795: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9791: x_chrv_rec => l_chrv_rec_out);
9792:
9793: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9794:
9795: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9796:
9797: FND_LOG.string(FND_LOG.level_procedure,
9798: l_mod_name,
9799: ' error updating amounts for a contract header ' ||

Line 9797: FND_LOG.string(FND_LOG.level_procedure,

9793: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS then
9794:
9795: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9796:
9797: FND_LOG.string(FND_LOG.level_procedure,
9798: l_mod_name,
9799: ' error updating amounts for a contract header ' ||
9800: p_chr_id);
9801:

Line 9810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

9806:
9807: EXCEPTION
9808: WHEN g_exc_error THEN
9809: -- end debug log
9810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9811: FND_LOG.string(FND_LOG.level_procedure,
9812: l_mod_name,
9813: 'exception raised in revalue contract ');
9814: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 100 ');

Line 9811: FND_LOG.string(FND_LOG.level_procedure,

9807: EXCEPTION
9808: WHEN g_exc_error THEN
9809: -- end debug log
9810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9811: FND_LOG.string(FND_LOG.level_procedure,
9812: l_mod_name,
9813: 'exception raised in revalue contract ');
9814: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 100 ');
9815: END IF;

Line 9814: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 100 ');

9810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
9811: FND_LOG.string(FND_LOG.level_procedure,
9812: l_mod_name,
9813: 'exception raised in revalue contract ');
9814: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 100 ');
9815: END IF;
9816:
9817: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');
9818:

Line 9821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9817: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');
9818:
9819: WHEN OTHERS THEN
9820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9822: FND_LOG.string(FND_LOG.level_procedure,
9823: l_mod_name || '.end',
9824: 'error at revalue contract l_return_status=' ||
9825: x_return_status);

Line 9822: FND_LOG.string(FND_LOG.level_procedure,

9818:
9819: WHEN OTHERS THEN
9820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9822: FND_LOG.string(FND_LOG.level_procedure,
9823: l_mod_name || '.end',
9824: 'error at revalue contract l_return_status=' ||
9825: x_return_status);
9826: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 200 ');

Line 9826: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 200 ');

9822: FND_LOG.string(FND_LOG.level_procedure,
9823: l_mod_name || '.end',
9824: 'error at revalue contract l_return_status=' ||
9825: x_return_status);
9826: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 200 ');
9827: END IF;
9828: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');
9829:
9830: END REVALUE_CONTRACT;

Line 9870: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9866: AND phase_code NOT IN ('C');
9867:
9868:
9869: BEGIN
9870: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9871: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9872: END IF;
9873:
9874: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9871: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);

9867:
9868:
9869: BEGIN
9870: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9871: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', ' p_chr_id='|| p_chr_id);
9872: END IF;
9873:
9874: x_return_status := FND_API.G_RET_STS_SUCCESS;
9875:

Line 9896: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9892: ELSE
9893: x_return_status := FND_API.G_RET_STS_SUCCESS;
9894: END IF;
9895:
9896: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9897: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9898: END IF;
9899:
9900: EXCEPTION

Line 9897: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

9893: x_return_status := FND_API.G_RET_STS_SUCCESS;
9894: END IF;
9895:
9896: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9897: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9898: END IF;
9899:
9900: EXCEPTION
9901: WHEN OTHERS THEN

Line 9903: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

9899:
9900: EXCEPTION
9901: WHEN OTHERS THEN
9902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9903: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9904: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9905: END IF;
9906:
9907: END CHECK_MASSUPD_REQUEST;

Line 9904: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

9900: EXCEPTION
9901: WHEN OTHERS THEN
9902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9903: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9904: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
9905: END IF;
9906:
9907: END CHECK_MASSUPD_REQUEST;
9908: