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.PON_NEGOTIATION_PUBLISH_PVT dependencies on FND_API

Line 6441: x_result := FND_API.G_RET_STS_SUCCESS;

6437: BEGIN
6438:
6439: l_module_name := 'validate_lines';
6440:
6441: x_result := FND_API.G_RET_STS_SUCCESS;
6442:
6443: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
6444: FND_LOG.string(log_level => FND_LOG.level_procedure,
6445: module => g_module_prefix || l_module_name,

Line 6710: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

6706: END IF;
6707:
6708: EXCEPTION
6709: WHEN OTHERS THEN
6710: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6711: x_error_code := SQLCODE;
6712: x_error_message := SUBSTR(SQLERRM, 1, 100);
6713:
6714: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 7031: x_result := FND_API.g_ret_sts_success;

7027: l_module_name VARCHAR2 (30);
7028: BEGIN
7029:
7030: l_module_name := 'update_line_flag_seq_closedate';
7031: x_result := FND_API.g_ret_sts_success;
7032:
7033: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7034: FND_LOG.string (log_level => FND_LOG.level_procedure,
7035: module => g_module_prefix || l_module_name,

Line 7161: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

7157: END IF;
7158:
7159: EXCEPTION
7160: WHEN OTHERS THEN
7161: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
7162: x_error_code := SQLCODE;
7163: x_error_message := SUBSTR(SQLERRM, 1, 100);
7164:
7165: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 7363: x_result := FND_API.g_ret_sts_success;

7359:
7360: BEGIN
7361:
7362: l_module_name := 'process_payments_batch';
7363: x_result := FND_API.g_ret_sts_success;
7364:
7365: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7366: FND_LOG.string (log_level => FND_LOG.level_procedure,
7367: module => g_module_prefix || l_module_name,

Line 7423: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

7419: END IF;
7420:
7421: EXCEPTION
7422: WHEN OTHERS THEN
7423: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
7424: x_error_code := SQLCODE;
7425: x_error_message := SUBSTR(SQLERRM, 1, 100);
7426:
7427: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 7454: x_result := FND_API.g_ret_sts_success;

7450:
7451: BEGIN
7452:
7453: l_module_name := 'process_payments_auto';
7454: x_result := FND_API.g_ret_sts_success;
7455:
7456: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7457: FND_LOG.string (log_level => FND_LOG.level_procedure,
7458: module => g_module_prefix || l_module_name,

Line 7472: IF (x_result <> FND_API.g_ret_sts_success) THEN

7468: p_login_id => p_login_id ,
7469: p_curr_from_line_number => p_curr_from_line_number ,
7470: p_curr_to_line_number => p_curr_to_line_number);
7471:
7472: IF (x_result <> FND_API.g_ret_sts_success) THEN
7473: ROLLBACK;
7474: return;
7475: END IF;
7476:

Line 7493: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

7489: END IF;
7490:
7491: EXCEPTION
7492: WHEN OTHERS THEN
7493: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
7494: x_error_code := SQLCODE;
7495: x_error_message := SUBSTR(SQLERRM, 1, 100);
7496: Rollback;
7497:

Line 7529: x_result := FND_API.g_ret_sts_success;

7525:
7526: BEGIN
7527:
7528: l_module_name := 'process_payments';
7529: x_result := FND_API.g_ret_sts_success;
7530:
7531: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7532: FND_LOG.string (log_level => FND_LOG.level_procedure,
7533: module => g_module_prefix || l_module_name,

Line 7619: IF (x_result <> FND_API.g_ret_sts_success) THEN

7615: module => g_module_prefix || l_module_name,
7616: message => 'After Call Process_Payments_auto = ' || l_module_name);
7617: END IF;
7618:
7619: IF (x_result <> FND_API.g_ret_sts_success) THEN
7620: return;
7621: END IF;
7622:
7623: -- Find the new batch range

Line 7648: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

7644: END IF;
7645:
7646: EXCEPTION
7647: WHEN OTHERS THEN
7648: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
7649: x_error_code := SQLCODE;
7650: x_error_message := SUBSTR(SQLERRM, 1, 100);
7651:
7652: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 7675: x_result := FND_API.G_RET_STS_SUCCESS;

7671: l_module_name VARCHAR2(30);
7672:
7673: BEGIN
7674: l_module_name := 'update_header_before_publish';
7675: x_result := FND_API.G_RET_STS_SUCCESS;
7676:
7677: --MAX_DOCUMENT_LINE_NUMBER and MAX_INTERNAL_LINE_NUMBER on the header
7678: --HAS_ATTRIBUTES_FLAG, HAS_PRICE_ELEMENTS_FLAG, HAS_PE_FOR_ALL_ITEMS
7679: BEGIN

Line 7780: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

7776: PAHA.AUCTION_HEADER_ID = p_auction_header_id;
7777:
7778: EXCEPTION
7779: WHEN OTHERS THEN
7780: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
7781: x_error_code := SQLCODE;
7782: x_error_message := SUBSTR(SQLERRM, 1, 100);
7783:
7784: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 7818: x_result := FND_API.g_ret_sts_success;

7814: BEGIN
7815:
7816: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
7817: l_module_name := 'update_lines_before_publish';
7818: x_result := FND_API.g_ret_sts_success;
7819:
7820: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7821: FND_LOG.string(log_level => FND_LOG.level_statement,
7822: module => g_module_prefix || l_module_name,

Line 7917: IF (x_result <> FND_API.g_ret_sts_success) THEN

7913: p_stag_closing_enabled_flag => l_stag_closing_enabled_flag,
7914: p_curr_from_line_number => l_batch_start,
7915: p_curr_to_line_number => l_batch_end);
7916:
7917: IF (x_result <> FND_API.g_ret_sts_success) THEN
7918: return;
7919: END IF;
7920:
7921: -- in case of a large auction call this procedure

Line 7941: IF (x_result <> FND_API.g_ret_sts_success) THEN

7937: p_login_id => p_login_id,
7938: p_from_line_number => l_batch_start,
7939: p_to_line_number => l_batch_end);
7940:
7941: IF (x_result <> FND_API.g_ret_sts_success) THEN
7942: return;
7943: END IF;
7944:
7945: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

Line 7971: x_result := FND_API.g_ret_sts_unexp_error;

7967: END LOOP; --}
7968:
7969: EXCEPTION
7970: WHEN OTHERS THEN
7971: x_result := FND_API.g_ret_sts_unexp_error;
7972: x_error_code := SQLCODE;
7973: x_error_message := SUBSTR(SQLERRM, 1, 100);
7974:
7975: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 7996: x_result := FND_API.g_ret_sts_success;

7992: l_module_name VARCHAR2 (30);
7993: BEGIN
7994:
7995: l_module_name := 'update_before_publish';
7996: x_result := FND_API.g_ret_sts_success;
7997:
7998: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7999: FND_LOG.string (log_level => FND_LOG.level_procedure,
8000: module => g_module_prefix || l_module_name,

Line 8025: IF (x_result <> FND_API.g_ret_sts_success) THEN

8021: p_close_bidding_date,
8022: p_user_id,
8023: p_login_id);
8024:
8025: IF (x_result <> FND_API.g_ret_sts_success) THEN
8026: return;
8027: END IF;
8028:
8029: -- update the header

Line 8036: IF (x_result <> FND_API.g_ret_sts_success) THEN

8032: x_error_code,
8033: x_error_message,
8034: p_auction_header_id);
8035:
8036: IF (x_result <> FND_API.g_ret_sts_success) THEN
8037: return;
8038: END IF;
8039:
8040: -- set the auction_status to active and the complete flag to Y

Line 8059: x_result := FND_API.g_ret_sts_unexp_error;

8055: END IF;
8056:
8057: EXCEPTION
8058: WHEN OTHERS THEN
8059: x_result := FND_API.g_ret_sts_unexp_error;
8060: x_error_code := SQLCODE;
8061: x_error_message := SUBSTR(SQLERRM, 1, 100);
8062:
8063: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8084: x_result := FND_API.g_ret_sts_success;

8080: l_module_name VARCHAR2 (30);
8081: BEGIN
8082:
8083: l_module_name := 'report_concurrent_failure';
8084: x_result := FND_API.g_ret_sts_success;
8085:
8086: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8087: FND_LOG.string (log_level => FND_LOG.level_procedure,
8088: module => g_module_prefix || l_module_name,

Line 8124: x_result := FND_API.g_ret_sts_unexp_error;

8120: END IF;
8121:
8122: EXCEPTION
8123: WHEN OTHERS THEN
8124: x_result := FND_API.g_ret_sts_unexp_error;
8125: x_error_code := SQLCODE;
8126: x_error_message := SUBSTR(SQLERRM, 1, 100);
8127:
8128: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8152: x_result := FND_API.g_ret_sts_success;

8148: l_destination_page_code VARCHAR2(30);
8149: BEGIN
8150:
8151: l_module_name := 'report_concurrent_success';
8152: x_result := FND_API.g_ret_sts_success;
8153:
8154: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8155: FND_LOG.string (log_level => FND_LOG.level_procedure,
8156: module => g_module_prefix || l_module_name,

Line 8200: x_result := FND_API.g_ret_sts_unexp_error;

8196: END IF;
8197:
8198: EXCEPTION
8199: WHEN OTHERS THEN
8200: x_result := FND_API.g_ret_sts_unexp_error;
8201: x_error_code := SQLCODE;
8202: x_error_message := SUBSTR(SQLERRM, 1, 100);
8203:
8204: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8231: x_result := FND_API.g_ret_sts_success;

8227: l_error_message_name VARCHAR2(30);
8228: BEGIN
8229:
8230: l_module_name := 'handle_fatal_exception';
8231: x_result := FND_API.g_ret_sts_success;
8232:
8233: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8234: FND_LOG.string (log_level => FND_LOG.level_procedure,
8235: module => g_module_prefix || l_module_name,

Line 8290: x_result := FND_API.g_ret_sts_unexp_error;

8286: END IF;
8287:
8288: EXCEPTION
8289: WHEN OTHERS THEN
8290: x_result := FND_API.g_ret_sts_unexp_error;
8291: x_error_code := SQLCODE;
8292: x_error_message := SUBSTR(SQLERRM, 1, 100);
8293:
8294: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8769: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {

8765: l_price_tiers_indicator, --26
8766: l_batch_id --27
8767: );
8768:
8769: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {
8770:
8771: handle_fatal_exception (
8772: x_result => l_result,
8773: x_error_code => l_error_code,

Line 8934: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {

8930: p_close_bidding_date => l_close_bidding_date,
8931: p_user_id => p_user_id,
8932: p_login_id => l_login_id);
8933:
8934: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {
8935:
8936: handle_fatal_exception (
8937: x_result => l_result,
8938: x_error_code => l_error_code,

Line 8965: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {

8961: x_error_code => l_error_code,
8962: x_error_message => l_error_msg,
8963: p_auction_header_id => p_auction_header_id);
8964:
8965: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {
8966:
8967: handle_fatal_exception (
8968: x_result => l_result,
8969: x_error_code => l_error_code,