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_HELPER_PVT dependencies on FND_API

Line 213: x_result := FND_API.G_RET_STS_SUCCESS;

209: module => g_module_prefix || 'HAS_FIXED_AMT_OR_PER_UNIT_PE',
210: message => 'Entered procedure with p_auction_header_id = ' || p_auction_header_id);
211: END IF;
212:
213: x_result := FND_API.G_RET_STS_SUCCESS;
214:
215: SELECT
216: LINE_NUMBER
217: INTO

Line 245: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

241: message => 'Returning x_has_fixed_amt_or_per_unit_pe = ' || x_has_fixed_amt_or_per_unit_pe);
242: END IF;
243:
244: WHEN OTHERS THEN
245: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
246: x_error_code := SQLCODE;
247: x_error_message := SUBSTR(SQLERRM, 1, 100);
248:
249: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 287: x_result := FND_API.G_RET_STS_SUCCESS;

283: module => g_module_prefix || 'HAS_GOODS_LINE_FIXED_AMOUNT_PE',
284: message => 'Entered procedure with p_auction_header_id = ' || p_auction_header_id);
285: END IF;
286:
287: x_result := FND_API.G_RET_STS_SUCCESS;
288:
289: SELECT
290: PAIP.LINE_NUMBER
291: INTO

Line 322: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

318: message => 'Returning x_has_goods_line_fixed_amt_pe = ' || x_has_goods_line_fixed_amt_pe);
319: END IF;
320:
321: WHEN OTHERS THEN
322: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
323: x_error_code := SQLCODE;
324: x_error_message := SUBSTR(SQLERRM, 1, 100);
325:
326: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 369: x_result := FND_API.G_RET_STS_SUCCESS;

365: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
366: message => 'Entered procedure with p_auction_header_id = ' || p_auction_header_id);
367: END IF;
368:
369: x_result := FND_API.G_RET_STS_SUCCESS;
370:
371:
372: --We are not performing an outer join between header and lines here as it might
373: --be costly in case of a super large negotiation

Line 428: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

424: ', x_max_document_line_num = ' || x_max_document_line_num ||
425: ', x_max_disp_line_num = ' || x_max_disp_line_num);
426: END IF;
427: WHEN OTHERS THEN
428: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
429: x_error_code := SQLCODE;
430: x_error_message := SUBSTR(SQLERRM, 1, 100);
431:
432: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 467: x_result := FND_API.G_RET_STS_SUCCESS;

463: module => g_module_prefix || 'GET_NUMBER_OF_LINES',
464: message => 'Entered procedure with p_auction_header_id = ' || p_auction_header_id);
465: END IF;
466:
467: x_result := FND_API.G_RET_STS_SUCCESS;
468:
469: SELECT
470: COUNT(LINE_NUMBER)
471: INTO

Line 485: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

481: message => 'Returning x_number_of_lines = ' || x_number_of_lines);
482: END IF;
483:
484: EXCEPTION WHEN OTHERS THEN
485: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
486: x_error_code := SQLCODE;
487: x_error_message := SUBSTR(SQLERRM, 1, 100);
488:
489: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 527: x_result := FND_API.G_RET_STS_SUCCESS;

523: module => g_module_prefix || 'HAS_ITEMS',
524: message => 'Entered procedure with p_auction_header_id = ' || p_auction_header_id);
525: END IF;
526:
527: x_result := FND_API.G_RET_STS_SUCCESS;
528:
529: SELECT
530: LINE_NUMBER
531: INTO

Line 558: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

554: message => 'Returning x_has_items = ' || x_has_items);
555: END IF;
556:
557: WHEN OTHERS THEN
558: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
559: x_error_code := SQLCODE;
560: x_error_message := SUBSTR(SQLERRM, 1, 100);
561:
562: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 598: x_result := FND_API.g_ret_sts_success;

594:
595: BEGIN
596:
597: l_module_name := 'remove_score';
598: x_result := FND_API.g_ret_sts_success;
599:
600: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
601: FND_LOG.string (log_level => FND_LOG.level_procedure,
602: module => g_module_prefix || l_module_name,

Line 682: x_result := FND_API.g_ret_sts_unexp_error;

678: END IF;
679:
680: EXCEPTION
681: WHEN OTHERS THEN
682: x_result := FND_API.g_ret_sts_unexp_error;
683: x_error_code := SQLCODE;
684: x_error_message := SUBSTR(SQLERRM, 1, 100);
685:
686: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 717: x_result := FND_API.g_ret_sts_success;

713: l_module_name VARCHAR2 (30);
714: BEGIN
715:
716: l_module_name := 'has_price_elements';
717: x_result := FND_API.g_ret_sts_success;
718:
719: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
720: FND_LOG.string (log_level => FND_LOG.level_procedure,
721: module => g_module_prefix || l_module_name,

Line 752: x_result := FND_API.g_ret_sts_unexp_error;

748: END IF;
749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: x_result := FND_API.g_ret_sts_unexp_error;
753: x_error_code := SQLCODE;
754: x_error_message := SUBSTR(SQLERRM, 1, 100);
755:
756: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 787: x_result := FND_API.g_ret_sts_success;

783: l_module_name VARCHAR2 (30);
784: BEGIN
785:
786: l_module_name := 'has_supplier_price_elements';
787: x_result := FND_API.g_ret_sts_success;
788:
789: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
790: FND_LOG.string (log_level => FND_LOG.level_procedure,
791: module => g_module_prefix || l_module_name,

Line 823: x_result := FND_API.g_ret_sts_unexp_error;

819: END IF;
820:
821: EXCEPTION
822: WHEN OTHERS THEN
823: x_result := FND_API.g_ret_sts_unexp_error;
824: x_error_code := SQLCODE;
825: x_error_message := SUBSTR(SQLERRM, 1, 100);
826:
827: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 858: x_result := FND_API.g_ret_sts_success;

854: l_module_name VARCHAR2 (30);
855: BEGIN
856:
857: l_module_name := 'has_buyer_price_elements';
858: x_result := FND_API.g_ret_sts_success;
859:
860: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
861: FND_LOG.string (log_level => FND_LOG.level_procedure,
862: module => g_module_prefix || l_module_name,

Line 894: x_result := FND_API.g_ret_sts_unexp_error;

890: END IF;
891:
892: EXCEPTION
893: WHEN OTHERS THEN
894: x_result := FND_API.g_ret_sts_unexp_error;
895: x_error_code := SQLCODE;
896: x_error_message := SUBSTR(SQLERRM, 1, 100);
897:
898: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 943: x_result := FND_API.G_RET_STS_SUCCESS;

939: is
940: l_module_name VARCHAR2 (30);
941: BEGIN
942: l_module_name := 'SYNC_PF_VALUES_ITEM_PRICES';
943: x_result := FND_API.G_RET_STS_SUCCESS;
944: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
945: FND_LOG.string (log_level => FND_LOG.level_statement,
946: module => g_module_prefix || l_module_name,
947: message => 'Entered the procedure; p_auction_header_id : '||p_auction_header_id ||

Line 1016: x_result := FND_API.g_ret_sts_unexp_error;

1012: END IF;
1013:
1014: EXCEPTION
1015: WHEN OTHERS THEN
1016: x_result := FND_API.g_ret_sts_unexp_error;
1017: x_error_code := SQLCODE;
1018: x_error_message := SUBSTR(SQLERRM, 1, 100);
1019:
1020: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 1060: x_result := FND_API.G_RET_STS_SUCCESS;

1056: l_module_name VARCHAR2 (30);
1057: l_supplier_exists VARCHAR2(1);
1058: BEGIN
1059: l_module_name := 'SYNC_PF_VALUES_BIDDING_PARTIES';
1060: x_result := FND_API.G_RET_STS_SUCCESS;
1061: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1062: FND_LOG.string (log_level => FND_LOG.level_statement,
1063: module => g_module_prefix || l_module_name,
1064: message => 'Entered the procedure ; p_auction_header_id : '||p_auction_header_id ||

Line 1180: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

1176: EXCEPTION
1177: when OTHERS then
1178: x_error_code := SQLCODE;
1179: x_error_message := substr(SQLERRM,1,200);
1180: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
1181: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
1182: FND_LOG.string (log_level => FND_LOG.level_exception,
1183: module => g_module_prefix || l_module_name,
1184: message => 'Exception in processing auction ' || p_auction_header_id

Line 1318: x_result := FND_API.g_ret_sts_success;

1314:
1315: BEGIN
1316:
1317: l_module_name := 'delete_all_lines';
1318: x_result := FND_API.g_ret_sts_success;
1319:
1320: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1321: FND_LOG.string (log_level => FND_LOG.level_procedure,
1322: module => g_module_prefix || l_module_name,

Line 1409: x_result := FND_API.g_ret_sts_unexp_error;

1405: message => 'Deletion of req reference done, x_error_code = ' || x_error_code);
1406: END IF;
1407:
1408: IF (x_error_code <> 'SUCCESS') THEN
1409: x_result := FND_API.g_ret_sts_unexp_error;
1410: RETURN;
1411: END IF;
1412: END LOOP;
1413: END IF;

Line 1720: x_result := FND_API.g_ret_sts_unexp_error;

1716: END IF;
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: x_result := FND_API.g_ret_sts_unexp_error;
1721: x_error_code := SQLCODE;
1722: x_error_message := SUBSTR(SQLERRM, 1, 100);
1723:
1724: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 1833: x_result := FND_API.g_ret_sts_success;

1829:
1830: BEGIN
1831:
1832: l_module_name := 'delete_single_line';
1833: x_result := FND_API.g_ret_sts_success;
1834:
1835: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1836: FND_LOG.string (log_level => FND_LOG.level_procedure,
1837: module => g_module_prefix || l_module_name,

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

2104: ', x_error_code = ' || x_error_code ||
2105: ', x_error_message = ' || x_error_message);
2106: END IF;
2107:
2108: IF (x_result <> FND_API.g_ret_sts_success) THEN
2109: RETURN;
2110: END IF;
2111:
2112: END IF;

Line 2133: x_result := FND_API.g_ret_sts_unexp_error;

2129: x_org_id => p_org_id,
2130: x_error_code => x_error_code);
2131:
2132: IF (x_error_code <> 'SUCCESS') THEN
2133: x_result := FND_API.g_ret_sts_unexp_error;
2134: RETURN;
2135: END IF;
2136: END IF;
2137:

Line 2533: x_result := FND_API.g_ret_sts_unexp_error;

2529: message => 'Done deleting reference. x_error_code = ' || x_error_code);
2530: END IF;
2531:
2532: IF (x_error_code <> 'SUCCESS') THEN
2533: x_result := FND_API.g_ret_sts_unexp_error;
2534: RETURN;
2535: END IF;
2536:
2537: END LOOP;

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

2573: ', x_error_code = ' || x_error_code ||
2574: ', x_error_message = ' || x_error_message);
2575: END IF;
2576:
2577: IF (x_result <> FND_API.g_ret_sts_success) THEN
2578: RETURN;
2579: END IF;
2580: END IF;
2581:

Line 2607: x_result := FND_API.g_ret_sts_unexp_error;

2603: END IF;
2604:
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: x_result := FND_API.g_ret_sts_unexp_error;
2608: x_error_code := SQLCODE;
2609: x_error_message := SUBSTR(SQLERRM, 1, 100);
2610:
2611: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 2672: x_result := FND_API.g_ret_sts_success;

2668: l_temp_char VARCHAR2(100);
2669: BEGIN
2670:
2671: l_module_name := 'renumber_lines';
2672: x_result := FND_API.g_ret_sts_success;
2673: x_last_line_number := -1;
2674:
2675: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2676:

Line 3088: x_result := FND_API.g_ret_sts_unexp_error;

3084: END IF;
3085:
3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: x_result := FND_API.g_ret_sts_unexp_error;
3089: x_error_code := SQLCODE;
3090: x_error_message := SUBSTR(SQLERRM, 1, 100);
3091:
3092: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 3318: x_result := FND_API.g_ret_sts_success;

3314:
3315: BEGIN
3316:
3317: l_module_name := 'DELETE_DISCUSSIONS';
3318: x_result := FND_API.g_ret_sts_success;
3319:
3320: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3321: FND_LOG.string (log_level => FND_LOG.level_procedure,
3322: module => g_module_prefix || l_module_name,

Line 3406: x_result := FND_API.g_ret_sts_unexp_error;

3402: END IF;
3403:
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: x_result := FND_API.g_ret_sts_unexp_error;
3407: x_error_code := SQLCODE;
3408: x_error_message := SUBSTR(SQLERRM, 1, 100);
3409:
3410: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 3464: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

3460: || ', p_start_disp_line_number = ' || p_start_disp_line_number
3461: );
3462: END IF;
3463:
3464: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
3465:
3466: SELECT max(disp_line_number)
3467: INTO l_max_line_number
3468: FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id;

Line 3629: x_result := FND_API.G_RET_STS_SUCCESS;

3625:
3626: ELSE
3627: x_last_line_close_date := p_first_line_close_date;
3628: END IF; --}
3629: x_result := FND_API.G_RET_STS_SUCCESS;
3630:
3631: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3632: FND_LOG.string(log_level => FND_LOG.level_statement,
3633: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',

Line 3778: x_result := FND_API.g_ret_sts_success;

3774:
3775: BEGIN
3776:
3777: l_module_name := 'has_price_tiers';
3778: x_result := FND_API.g_ret_sts_success;
3779: x_has_price_tiers := 'Y';
3780:
3781: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3782: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 3829: x_result := FND_API.g_ret_sts_unexp_error;

3825: WHEN OTHERS THEN
3826: --
3827: --If there are any other exceptions in the code, report them to the caller
3828: --
3829: x_result := FND_API.g_ret_sts_unexp_error;
3830: x_error_code := SQLCODE;
3831: x_error_message := SUBSTR(SQLERRM, 1, 100);
3832:
3833: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 3888: x_result := FND_API.g_ret_sts_success;

3884:
3885: BEGIN
3886:
3887: l_module_name := 'handle_change_price_tiers';
3888: x_result := FND_API.g_ret_sts_success;
3889:
3890: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3891: FND_LOG.string(log_level => FND_LOG.level_statement,
3892: module => g_module_prefix || l_module_name,

Line 4137: x_result := FND_API.g_ret_sts_unexp_error;

4133: END IF; --}
4134:
4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: x_result := FND_API.g_ret_sts_unexp_error;
4138: x_error_code := SQLCODE;
4139: x_error_message := SUBSTR(SQLERRM, 1, 100);
4140:
4141: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN