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 7330: x_result := FND_API.G_RET_STS_SUCCESS;

7326: BEGIN
7327:
7328: l_module_name := 'validate_lines';
7329:
7330: x_result := FND_API.G_RET_STS_SUCCESS;
7331:
7332: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
7333: FND_LOG.string(log_level => FND_LOG.level_procedure,
7334: module => g_module_prefix || l_module_name,

Line 7601: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

7597: END IF;
7598:
7599: EXCEPTION
7600: WHEN OTHERS THEN
7601: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
7602: x_error_code := SQLCODE;
7603: x_error_message := SUBSTR(SQLERRM, 1, 100);
7604:
7605: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 7922: x_result := FND_API.g_ret_sts_success;

7918: l_module_name VARCHAR2 (30);
7919: BEGIN
7920:
7921: l_module_name := 'update_line_flag_seq_closedate';
7922: x_result := FND_API.g_ret_sts_success;
7923:
7924: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7925: FND_LOG.string (log_level => FND_LOG.level_procedure,
7926: module => g_module_prefix || l_module_name,

Line 8052: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

8048: END IF;
8049:
8050: EXCEPTION
8051: WHEN OTHERS THEN
8052: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8053: x_error_code := SQLCODE;
8054: x_error_message := SUBSTR(SQLERRM, 1, 100);
8055:
8056: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8254: x_result := FND_API.g_ret_sts_success;

8250:
8251: BEGIN
8252:
8253: l_module_name := 'process_payments_batch';
8254: x_result := FND_API.g_ret_sts_success;
8255:
8256: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8257: FND_LOG.string (log_level => FND_LOG.level_procedure,
8258: module => g_module_prefix || l_module_name,

Line 8314: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

8310: END IF;
8311:
8312: EXCEPTION
8313: WHEN OTHERS THEN
8314: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8315: x_error_code := SQLCODE;
8316: x_error_message := SUBSTR(SQLERRM, 1, 100);
8317:
8318: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8345: x_result := FND_API.g_ret_sts_success;

8341:
8342: BEGIN
8343:
8344: l_module_name := 'process_payments_auto';
8345: x_result := FND_API.g_ret_sts_success;
8346:
8347: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8348: FND_LOG.string (log_level => FND_LOG.level_procedure,
8349: module => g_module_prefix || l_module_name,

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

8359: p_login_id => p_login_id ,
8360: p_curr_from_line_number => p_curr_from_line_number ,
8361: p_curr_to_line_number => p_curr_to_line_number);
8362:
8363: IF (x_result <> FND_API.g_ret_sts_success) THEN
8364: ROLLBACK;
8365: return;
8366: END IF;
8367:

Line 8384: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

8380: END IF;
8381:
8382: EXCEPTION
8383: WHEN OTHERS THEN
8384: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8385: x_error_code := SQLCODE;
8386: x_error_message := SUBSTR(SQLERRM, 1, 100);
8387: Rollback;
8388:

Line 8420: x_result := FND_API.g_ret_sts_success;

8416:
8417: BEGIN
8418:
8419: l_module_name := 'process_payments';
8420: x_result := FND_API.g_ret_sts_success;
8421:
8422: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8423: FND_LOG.string (log_level => FND_LOG.level_procedure,
8424: module => g_module_prefix || l_module_name,

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

8506: module => g_module_prefix || l_module_name,
8507: message => 'After Call Process_Payments_auto = ' || l_module_name);
8508: END IF;
8509:
8510: IF (x_result <> FND_API.g_ret_sts_success) THEN
8511: return;
8512: END IF;
8513:
8514: -- Find the new batch range

Line 8539: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

8535: END IF;
8536:
8537: EXCEPTION
8538: WHEN OTHERS THEN
8539: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8540: x_error_code := SQLCODE;
8541: x_error_message := SUBSTR(SQLERRM, 1, 100);
8542:
8543: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8566: x_result := FND_API.G_RET_STS_SUCCESS;

8562: l_module_name VARCHAR2(30);
8563:
8564: BEGIN
8565: l_module_name := 'update_header_before_publish';
8566: x_result := FND_API.G_RET_STS_SUCCESS;
8567:
8568: --MAX_DOCUMENT_LINE_NUMBER and MAX_INTERNAL_LINE_NUMBER on the header
8569: --HAS_ATTRIBUTES_FLAG, HAS_PRICE_ELEMENTS_FLAG, HAS_PE_FOR_ALL_ITEMS
8570: BEGIN

Line 8671: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

8667: PAHA.AUCTION_HEADER_ID = p_auction_header_id;
8668:
8669: EXCEPTION
8670: WHEN OTHERS THEN
8671: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
8672: x_error_code := SQLCODE;
8673: x_error_message := SUBSTR(SQLERRM, 1, 100);
8674:
8675: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8709: x_result := FND_API.g_ret_sts_success;

8705: BEGIN
8706:
8707: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
8708: l_module_name := 'update_lines_before_publish';
8709: x_result := FND_API.g_ret_sts_success;
8710:
8711: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8712: FND_LOG.string(log_level => FND_LOG.level_statement,
8713: module => g_module_prefix || l_module_name,

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

8804: p_stag_closing_enabled_flag => l_stag_closing_enabled_flag,
8805: p_curr_from_line_number => l_batch_start,
8806: p_curr_to_line_number => l_batch_end);
8807:
8808: IF (x_result <> FND_API.g_ret_sts_success) THEN
8809: return;
8810: END IF;
8811:
8812: -- in case of a large auction call this procedure

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

8828: p_login_id => p_login_id,
8829: p_from_line_number => l_batch_start,
8830: p_to_line_number => l_batch_end);
8831:
8832: IF (x_result <> FND_API.g_ret_sts_success) THEN
8833: return;
8834: END IF;
8835:
8836: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

Line 8862: x_result := FND_API.g_ret_sts_unexp_error;

8858: END LOOP; --}
8859:
8860: EXCEPTION
8861: WHEN OTHERS THEN
8862: x_result := FND_API.g_ret_sts_unexp_error;
8863: x_error_code := SQLCODE;
8864: x_error_message := SUBSTR(SQLERRM, 1, 100);
8865:
8866: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8887: x_result := FND_API.g_ret_sts_success;

8883: l_module_name VARCHAR2 (30);
8884: BEGIN
8885:
8886: l_module_name := 'update_before_publish';
8887: x_result := FND_API.g_ret_sts_success;
8888:
8889: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8890: FND_LOG.string (log_level => FND_LOG.level_procedure,
8891: module => g_module_prefix || l_module_name,

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

8912: p_close_bidding_date,
8913: p_user_id,
8914: p_login_id);
8915:
8916: IF (x_result <> FND_API.g_ret_sts_success) THEN
8917: return;
8918: END IF;
8919:
8920: -- update the header

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

8923: x_error_code,
8924: x_error_message,
8925: p_auction_header_id);
8926:
8927: IF (x_result <> FND_API.g_ret_sts_success) THEN
8928: return;
8929: END IF;
8930:
8931: -- set the auction_status to active and the complete flag to Y

Line 8950: x_result := FND_API.g_ret_sts_unexp_error;

8946: END IF;
8947:
8948: EXCEPTION
8949: WHEN OTHERS THEN
8950: x_result := FND_API.g_ret_sts_unexp_error;
8951: x_error_code := SQLCODE;
8952: x_error_message := SUBSTR(SQLERRM, 1, 100);
8953:
8954: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 8975: x_result := FND_API.g_ret_sts_success;

8971: l_module_name VARCHAR2 (30);
8972: BEGIN
8973:
8974: l_module_name := 'report_concurrent_failure';
8975: x_result := FND_API.g_ret_sts_success;
8976:
8977: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
8978: FND_LOG.string (log_level => FND_LOG.level_procedure,
8979: module => g_module_prefix || l_module_name,

Line 9015: x_result := FND_API.g_ret_sts_unexp_error;

9011: END IF;
9012:
9013: EXCEPTION
9014: WHEN OTHERS THEN
9015: x_result := FND_API.g_ret_sts_unexp_error;
9016: x_error_code := SQLCODE;
9017: x_error_message := SUBSTR(SQLERRM, 1, 100);
9018:
9019: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 9043: x_result := FND_API.g_ret_sts_success;

9039: l_destination_page_code VARCHAR2(30);
9040: BEGIN
9041:
9042: l_module_name := 'report_concurrent_success';
9043: x_result := FND_API.g_ret_sts_success;
9044:
9045: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9046: FND_LOG.string (log_level => FND_LOG.level_procedure,
9047: module => g_module_prefix || l_module_name,

Line 9091: x_result := FND_API.g_ret_sts_unexp_error;

9087: END IF;
9088:
9089: EXCEPTION
9090: WHEN OTHERS THEN
9091: x_result := FND_API.g_ret_sts_unexp_error;
9092: x_error_code := SQLCODE;
9093: x_error_message := SUBSTR(SQLERRM, 1, 100);
9094:
9095: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 9122: x_result := FND_API.g_ret_sts_success;

9118: l_error_message_name VARCHAR2(30);
9119: BEGIN
9120:
9121: l_module_name := 'handle_fatal_exception';
9122: x_result := FND_API.g_ret_sts_success;
9123:
9124: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9125: FND_LOG.string (log_level => FND_LOG.level_procedure,
9126: module => g_module_prefix || l_module_name,

Line 9181: x_result := FND_API.g_ret_sts_unexp_error;

9177: END IF;
9178:
9179: EXCEPTION
9180: WHEN OTHERS THEN
9181: x_result := FND_API.g_ret_sts_unexp_error;
9182: x_error_code := SQLCODE;
9183: x_error_message := SUBSTR(SQLERRM, 1, 100);
9184:
9185: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

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

9670: l_price_tiers_indicator, --26
9671: l_batch_id --27
9672: );
9673:
9674: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {
9675:
9676: handle_fatal_exception (
9677: x_result => l_result,
9678: x_error_code => l_error_code,

Line 9835: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN

9831: x_msg_count => l_msg_count,
9832: x_msg_data => l_error_msg,
9833: x_revision => l_conf_doc_revision);
9834:
9835: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN
9836:
9837: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9838: FND_LOG.string(log_level => FND_LOG.level_statement,
9839: module => g_module_prefix || l_module_name,

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

9909: p_close_bidding_date => l_close_bidding_date,
9910: p_user_id => p_user_id,
9911: p_login_id => l_login_id);
9912:
9913: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {
9914:
9915: handle_fatal_exception (
9916: x_result => l_result,
9917: x_error_code => l_error_code,

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

9940: x_error_code => l_error_code,
9941: x_error_message => l_error_msg,
9942: p_auction_header_id => p_auction_header_id);
9943:
9944: IF (l_result <> FND_API.G_RET_STS_SUCCESS) THEN -- {
9945:
9946: handle_fatal_exception (
9947: x_result => l_result,
9948: x_error_code => l_error_code,