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 8018: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

8014:
8015: BEGIN
8016:
8017: --log key input parameters
8018: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8019: 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);
8020: END IF;
8021:
8022: --standard api initilization and checks

Line 8019: 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);

8015: BEGIN
8016:
8017: --log key input parameters
8018: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8019: 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);
8020: END IF;
8021:
8022: --standard api initilization and checks
8023: SAVEPOINT check_update_amounts_PVT;

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

8032: --get all toplines that are out of sync with sublines
8033: OPEN c_k_toplines(p_chr_id);
8034: LOOP
8035: 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;
8036: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8037: 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);
8038: END IF;
8039:
8040: EXIT WHEN (l_tl_id_tbl.count = 0);

Line 8037: 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);

8033: OPEN c_k_toplines(p_chr_id);
8034: LOOP
8035: 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;
8036: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8037: 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);
8038: END IF;
8039:
8040: EXIT WHEN (l_tl_id_tbl.count = 0);
8041:

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

8045: --if the lock fails, another user is holding the lock, exit with appropriate
8046: --error message. If the lock succeeds, update the top line amount
8047: BEGIN
8048:
8049: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8050: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8051: END IF;
8052:
8053: 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 8050: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));

8046: --error message. If the lock succeeds, update the top line amount
8047: BEGIN
8048:
8049: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8050: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8051: END IF;
8052:
8053: 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
8054: OPEN c_lock_tl(l_tl_id_tbl(i));

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

8067: --set the error message on the error stack to inform the user
8068: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8069: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8070:
8071: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8072: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8073: END IF;
8074: FND_MSG_PUB.ADD;
8075:

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

8068: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8069: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8070:
8071: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8072: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8073: END IF;
8074: FND_MSG_PUB.ADD;
8075:
8076: l_tl_id_tbl.delete;

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

8084: END; --of anonymous block checking topline locks
8085:
8086: END LOOP;
8087:
8088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8089: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');
8090: END IF;
8091:
8092: --if we come till here, we where able to obtain locks on all the toplines fectched previously

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

8085:
8086: END LOOP;
8087:
8088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8089: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating amount');
8090: END IF;
8091:
8092: --if we come till here, we where able to obtain locks on all the toplines fectched previously
8093: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last

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

8099: UPDATE oks_k_lines_b
8100: SET tax_amount = l_sl_amt_tax_tbl(j)
8101: WHERE cle_id = l_tl_id_tbl(j);
8102:
8103: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8104: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');
8105: END IF;
8106:
8107: END LOOP; --of bulk fetch loop

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

8100: SET tax_amount = l_sl_amt_tax_tbl(j)
8101: WHERE cle_id = l_tl_id_tbl(j);
8102:
8103: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8104: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'amounts updated');
8105: END IF;
8106:
8107: END LOOP; --of bulk fetch loop
8108: CLOSE c_k_toplines;

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

8115: OPEN c_k_hdr(p_chr_id);
8116: FETCH c_k_hdr INTO l_k_num, l_hdr_amt, l_tl_amt,l_hdr_amt_tax,l_tl_amt_tax;
8117: CLOSE c_k_hdr;
8118:
8119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8120: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);
8121: END IF;
8122:
8123: --update the header only if required

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

8116: FETCH c_k_hdr INTO l_k_num, l_hdr_amt, l_tl_amt,l_hdr_amt_tax,l_tl_amt_tax;
8117: CLOSE c_k_hdr;
8118:
8119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8120: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_hdr', 'db hdr amt='||l_hdr_amt||' , sum of toplines='||l_tl_amt);
8121: END IF;
8122:
8123: --update the header only if required
8124: IF (l_hdr_amt <> l_tl_amt) OR(l_hdr_amt_tax <> l_tl_amt_tax) THEN

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

8127: --if the lock fails, another user is holding the lock, exit with appropriate
8128: --error message. If the lock succeeds, update the header amount
8129: BEGIN
8130:
8131: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8132: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8133: END IF;
8134:
8135: OPEN c_lock_hdr(p_chr_id);

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

8128: --error message. If the lock succeeds, update the header amount
8129: BEGIN
8130:
8131: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8132: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8133: END IF;
8134:
8135: OPEN c_lock_hdr(p_chr_id);
8136: FETCH c_lock_hdr INTO l_dummy;

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

8156: --set the error message on the error stack to inform the user
8157: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8158: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8159:
8160: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8161: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8162: END IF;
8163: FND_MSG_PUB.ADD;
8164:

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

8157: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8158: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8159:
8160: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8161: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8162: END IF;
8163: FND_MSG_PUB.ADD;
8164:
8165: RAISE FND_API.g_exc_error;

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

8171: -- to update cancelled amount of toplines.First get all toplines that are out of sync with sublines
8172: OPEN c_k_toplines_cancelled(p_chr_id);
8173: LOOP
8174: 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;
8175: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8176: 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);
8177: END IF;
8178:
8179: EXIT WHEN (l_tl_id_tbl.count = 0);

Line 8176: 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);

8172: OPEN c_k_toplines_cancelled(p_chr_id);
8173: LOOP
8174: 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;
8175: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8176: 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);
8177: END IF;
8178:
8179: EXIT WHEN (l_tl_id_tbl.count = 0);
8180:

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

8184: --if the lock fails, another user is holding the lock, exit with appropriate
8185: --error message. If the lock succeeds, update the top line cancelled amount
8186: BEGIN
8187:
8188: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8189: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8190: END IF;
8191:
8192: OPEN c_lock_tl(l_tl_id_tbl(i));

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

8185: --error message. If the lock succeeds, update the top line cancelled amount
8186: BEGIN
8187:
8188: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8189: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_line', 'checking lock for line id='||l_tl_id_tbl(i));
8190: END IF;
8191:
8192: OPEN c_lock_tl(l_tl_id_tbl(i));
8193: FETCH c_lock_tl INTO l_dummy;

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

8205: --set the error message on the error stack to inform the user
8206: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8207: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8208:
8209: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8210: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8211: END IF;
8212: FND_MSG_PUB.ADD;
8213:

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

8206: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_LINE_LOCKED');
8207: FND_MESSAGE.set_token('LINE_NAME', l_line_name);
8208:
8209: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8210: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_line_fail', FALSE);
8211: END IF;
8212: FND_MSG_PUB.ADD;
8213:
8214: l_tl_id_tbl.delete;

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

8220: END; --of anonymous block checking topline locks
8221:
8222: END LOOP;
8223:
8224: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8225: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating canceled amount');
8226: END IF;
8227:
8228: --if we come till here, we where able to obtain locks on all the toplines fectched previously

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

8221:
8222: END LOOP;
8223:
8224: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8225: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'able to lock all fetched toplines - updating canceled amount');
8226: END IF;
8227:
8228: --if we come till here, we where able to obtain locks on all the toplines fectched previously
8229: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last

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

8230: update okc_k_lines_b
8231: set cancelled_amount =l_sl_amt_tbl(j)
8232: where id=l_tl_id_tbl(j);
8233:
8234: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8235: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'cancelled amounts updated');
8236: END IF;
8237:
8238: END LOOP; --of bulk fetch loop

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

8231: set cancelled_amount =l_sl_amt_tbl(j)
8232: where id=l_tl_id_tbl(j);
8233:
8234: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8235: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_line', 'cancelled amounts updated');
8236: END IF;
8237:
8238: END LOOP; --of bulk fetch loop
8239: CLOSE c_k_toplines_cancelled;

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

8241: l_tl_amt_tbl.delete;
8242: l_sl_amt_tbl.delete;
8243:
8244: -- update cancelled amount in header
8245: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8246: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_header', 'to update header cancelled amount not equal to sum of toplines.');
8247: END IF;
8248:
8249: OPEN c_k_hdr_cancelled(p_chr_id);

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

8242: l_sl_amt_tbl.delete;
8243:
8244: -- update cancelled amount in header
8245: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8246: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_header', 'to update header cancelled amount not equal to sum of toplines.');
8247: END IF;
8248:
8249: OPEN c_k_hdr_cancelled(p_chr_id);
8250: FETCH c_k_hdr_cancelled INTO l_header_cancelled,l_topline_cancelled;

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

8257: --if the lock fails, another user is holding the lock, exit with appropriate
8258: --error message. If the lock succeeds, update the header amount
8259: BEGIN
8260:
8261: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8262: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8263: END IF;
8264:
8265: OPEN c_lock_hdr(p_chr_id);

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

8258: --error message. If the lock succeeds, update the header amount
8259: BEGIN
8260:
8261: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8262: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.lock_hdr', 'checking lock for header id='||p_chr_id);
8263: END IF;
8264:
8265: OPEN c_lock_hdr(p_chr_id);
8266: FETCH c_lock_hdr INTO l_dummy;

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

8278: --set the error message on the error stack to inform the user
8279: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8280: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8281:
8282: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8283: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8284: END IF;
8285: FND_MSG_PUB.ADD;
8286:

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

8279: FND_MESSAGE.set_name(G_APP_NAME_OKS, 'OKS_HEADER_LOCKED');
8280: FND_MESSAGE.set_token('CONTRACT_NUMBER', l_k_num);
8281:
8282: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8283: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.lock_header_fail', FALSE);
8284: END IF;
8285: FND_MSG_PUB.ADD;
8286:
8287: RAISE FND_API.g_exc_error;

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

8294: COMMIT;
8295: END IF;
8296:
8297: --exit
8298: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8299: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
8300: END IF;
8301: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8302:

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

8295: END IF;
8296:
8297: --exit
8298: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8299: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
8300: END IF;
8301: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8302:
8303: EXCEPTION

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

8304: WHEN FND_API.g_exc_error THEN
8305: ROLLBACK TO check_update_amounts_PVT;
8306: x_return_status := FND_API.g_ret_sts_error ;
8307:
8308: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8309: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
8310: END IF;
8311: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8312: IF (c_k_toplines%isopen) THEN

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

8305: ROLLBACK TO check_update_amounts_PVT;
8306: x_return_status := FND_API.g_ret_sts_error ;
8307:
8308: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
8309: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
8310: END IF;
8311: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8312: IF (c_k_toplines%isopen) THEN
8313: CLOSE c_k_toplines;

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

8329: WHEN FND_API.g_exc_unexpected_error THEN
8330: ROLLBACK TO check_update_amounts_PVT;
8331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8332:
8333: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8334: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
8335: END IF;
8336: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8337: IF (c_k_toplines%isopen) THEN

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

8330: ROLLBACK TO check_update_amounts_PVT;
8331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8332:
8333: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8334: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
8335: END IF;
8336: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
8337: IF (c_k_toplines%isopen) THEN
8338: CLOSE c_k_toplines;

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

8353: WHEN OTHERS THEN
8354: ROLLBACK TO check_update_amounts_PVT;
8355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8356:
8357: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8358: --first log the sqlerrm
8359: l_error_text := substr (SQLERRM, 1, 240);
8360: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
8361: --then add it to the message api list

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

8356:
8357: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
8358: --first log the sqlerrm
8359: l_error_text := substr (SQLERRM, 1, 240);
8360: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
8361: --then add it to the message api list
8362: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
8363: END IF;
8364: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );