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 1321: x_result := FND_API.g_ret_sts_success;

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

Line 1429: x_result := FND_API.g_ret_sts_unexp_error;

1425: message => 'Deletion of req reference done, x_error_code = ' || x_error_code);
1426: END IF;
1427:
1428: IF (x_error_code <> 'SUCCESS') THEN
1429: x_result := FND_API.g_ret_sts_unexp_error;
1430: RETURN;
1431: END IF;
1432: END LOOP;
1433: END IF;

Line 1781: x_result := FND_API.g_ret_sts_unexp_error;

1777: END IF;
1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781: x_result := FND_API.g_ret_sts_unexp_error;
1782: x_error_code := SQLCODE;
1783: x_error_message := SUBSTR(SQLERRM, 1, 100);
1784:
1785: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 1898: x_result := FND_API.g_ret_sts_success;

1894:
1895: BEGIN
1896:
1897: l_module_name := 'delete_single_line';
1898: x_result := FND_API.g_ret_sts_success;
1899:
1900: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1901: FND_LOG.string (log_level => FND_LOG.level_procedure,
1902: module => g_module_prefix || l_module_name,

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

2219: ', x_error_code = ' || x_error_code ||
2220: ', x_error_message = ' || x_error_message);
2221: END IF;
2222:
2223: IF (x_result <> FND_API.g_ret_sts_success) THEN
2224: RETURN;
2225: END IF;
2226:
2227: END IF;

Line 2265: x_result := FND_API.g_ret_sts_unexp_error;

2261: x_org_id => p_org_id,
2262: x_error_code => x_error_code);
2263:
2264: IF (x_error_code <> 'SUCCESS') THEN
2265: x_result := FND_API.g_ret_sts_unexp_error;
2266: RETURN;
2267: END IF;
2268: END IF;
2269:

Line 2665: x_result := FND_API.g_ret_sts_unexp_error;

2661: message => 'Done deleting reference. x_error_code = ' || x_error_code);
2662: END IF;
2663:
2664: IF (x_error_code <> 'SUCCESS') THEN
2665: x_result := FND_API.g_ret_sts_unexp_error;
2666: RETURN;
2667: END IF;
2668:
2669: END LOOP;

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

2717: ', x_error_code = ' || x_error_code ||
2718: ', x_error_message = ' || x_error_message);
2719: END IF;
2720:
2721: IF (x_result <> FND_API.g_ret_sts_success) THEN
2722: RETURN;
2723: END IF;
2724: END IF;
2725:

Line 2751: x_result := FND_API.g_ret_sts_unexp_error;

2747: END IF;
2748:
2749: EXCEPTION
2750: WHEN OTHERS THEN
2751: x_result := FND_API.g_ret_sts_unexp_error;
2752: x_error_code := SQLCODE;
2753: x_error_message := SUBSTR(SQLERRM, 1, 100);
2754:
2755: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 2816: x_result := FND_API.g_ret_sts_success;

2812: l_temp_char VARCHAR2(100);
2813: BEGIN
2814:
2815: l_module_name := 'renumber_lines';
2816: x_result := FND_API.g_ret_sts_success;
2817: x_last_line_number := -1;
2818:
2819: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2820:

Line 3232: x_result := FND_API.g_ret_sts_unexp_error;

3228: END IF;
3229:
3230: EXCEPTION
3231: WHEN OTHERS THEN
3232: x_result := FND_API.g_ret_sts_unexp_error;
3233: x_error_code := SQLCODE;
3234: x_error_message := SUBSTR(SQLERRM, 1, 100);
3235:
3236: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 3462: x_result := FND_API.g_ret_sts_success;

3458:
3459: BEGIN
3460:
3461: l_module_name := 'DELETE_DISCUSSIONS';
3462: x_result := FND_API.g_ret_sts_success;
3463:
3464: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3465: FND_LOG.string (log_level => FND_LOG.level_procedure,
3466: module => g_module_prefix || l_module_name,

Line 3550: x_result := FND_API.g_ret_sts_unexp_error;

3546: END IF;
3547:
3548: EXCEPTION
3549: WHEN OTHERS THEN
3550: x_result := FND_API.g_ret_sts_unexp_error;
3551: x_error_code := SQLCODE;
3552: x_error_message := SUBSTR(SQLERRM, 1, 100);
3553:
3554: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

Line 3608: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

3604: || ', p_start_disp_line_number = ' || p_start_disp_line_number
3605: );
3606: END IF;
3607:
3608: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
3609:
3610: SELECT max(disp_line_number)
3611: INTO l_max_line_number
3612: FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id;

Line 3773: x_result := FND_API.G_RET_STS_SUCCESS;

3769:
3770: ELSE
3771: x_last_line_close_date := p_first_line_close_date;
3772: END IF; --}
3773: x_result := FND_API.G_RET_STS_SUCCESS;
3774:
3775: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3776: FND_LOG.string(log_level => FND_LOG.level_statement,
3777: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',

Line 3922: x_result := FND_API.g_ret_sts_success;

3918:
3919: BEGIN
3920:
3921: l_module_name := 'has_price_tiers';
3922: x_result := FND_API.g_ret_sts_success;
3923: x_has_price_tiers := 'Y';
3924:
3925: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3926: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 3973: x_result := FND_API.g_ret_sts_unexp_error;

3969: WHEN OTHERS THEN
3970: --
3971: --If there are any other exceptions in the code, report them to the caller
3972: --
3973: x_result := FND_API.g_ret_sts_unexp_error;
3974: x_error_code := SQLCODE;
3975: x_error_message := SUBSTR(SQLERRM, 1, 100);
3976:
3977: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 4032: x_result := FND_API.g_ret_sts_success;

4028:
4029: BEGIN
4030:
4031: l_module_name := 'handle_change_price_tiers';
4032: x_result := FND_API.g_ret_sts_success;
4033:
4034: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4035: FND_LOG.string(log_level => FND_LOG.level_statement,
4036: module => g_module_prefix || l_module_name,

Line 4281: x_result := FND_API.g_ret_sts_unexp_error;

4277: END IF; --}
4278:
4279: EXCEPTION
4280: WHEN OTHERS THEN
4281: x_result := FND_API.g_ret_sts_unexp_error;
4282: x_error_code := SQLCODE;
4283: x_error_message := SUBSTR(SQLERRM, 1, 100);
4284:
4285: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN