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

Line 1412: p_init_msg_list => FND_API.G_FALSE,

1408:
1409: -- Raise Business Event
1410: PON_BIZ_EVENTS_PVT.RAISE_NEG_PUB_EVENT (
1411: p_api_version => 1.0 ,
1412: p_init_msg_list => FND_API.G_FALSE,
1413: p_commit => FND_API.G_FALSE,
1414: p_auction_header_id => p_auction_header_id,
1415: x_return_status => x_return_status,
1416: x_msg_count => x_msg_count,

Line 1413: p_commit => FND_API.G_FALSE,

1409: -- Raise Business Event
1410: PON_BIZ_EVENTS_PVT.RAISE_NEG_PUB_EVENT (
1411: p_api_version => 1.0 ,
1412: p_init_msg_list => FND_API.G_FALSE,
1413: p_commit => FND_API.G_FALSE,
1414: p_auction_header_id => p_auction_header_id,
1415: x_return_status => x_return_status,
1416: x_msg_count => x_msg_count,
1417: x_msg_data => x_msg_data);

Line 2003: p_init_msg_list => FND_API.G_FALSE,

1999:
2000: -- Raise Business Event
2001: PON_BIZ_EVENTS_PVT.RAISE_RESPNSE_DISQ_EVENT (
2002: p_api_version => 1.0 ,
2003: p_init_msg_list => FND_API.G_FALSE,
2004: p_commit => FND_API.G_FALSE,
2005: p_bid_number => p_bid_id,
2006: x_return_status => x_return_status,
2007: x_msg_count => x_msg_count,

Line 2004: p_commit => FND_API.G_FALSE,

2000: -- Raise Business Event
2001: PON_BIZ_EVENTS_PVT.RAISE_RESPNSE_DISQ_EVENT (
2002: p_api_version => 1.0 ,
2003: p_init_msg_list => FND_API.G_FALSE,
2004: p_commit => FND_API.G_FALSE,
2005: p_bid_number => p_bid_id,
2006: x_return_status => x_return_status,
2007: x_msg_count => x_msg_count,
2008: x_msg_data => x_msg_data);

Line 8990: x_error_code := FND_API.G_RET_STS_SUCCESS;

8986:
8987: -- the above routine does't use FND constants,
8988: -- while UPDATE_NEGOTIATION_LINE_REF does, so convert it.
8989: IF (x_error_code = 'SUCCESS') THEN
8990: x_error_code := FND_API.G_RET_STS_SUCCESS;
8991: END IF;
8992:
8993: -- changes for FPI. For items that are carried over from previous round
8994: -- update the corresponding backing requisition references (no change

Line 9009: EXIT WHEN deletedItems%NOTFOUND OR (x_error_code <> FND_API.G_RET_STS_SUCCESS);

9005: OPEN deletedItems;
9006: LOOP
9007: FETCH deletedItems INTO
9008: l_line_number;
9009: EXIT WHEN deletedItems%NOTFOUND OR (x_error_code <> FND_API.G_RET_STS_SUCCESS);
9010:
9011: -- PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(x_new_negotiation_id, l_line_number, x_error_code);
9012:
9013: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_LINE_REF(

Line 9025: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN

9021: X_ERROR_MESSAGE => x_error_message);
9022: END LOOP;
9023:
9024: -- FPI: bug 2811671 still need to return the req back to pool
9025: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9026: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(
9027: X_NEGOTIATION_ID => x_old_negotiation_id,
9028: X_NEGOTIATION_LINE_NUM => null,
9029: X_FLAG_VALUE => 'Y',

Line 9034: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN

9030: X_ERROR_CODE => x_error_code);
9031: END IF;
9032:
9033: -- convert fnd constant to our own internal code
9034: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9035: x_error_code := 'SUCCESS';
9036: END IF;
9037:
9038: END UPDATE_NEGOTIATION_REF;

Line 9539: IF (l_pref_unused_2 <> FND_API.G_RET_STS_SUCCESS) THEN

9535: x_pref_meaning => l_pref_unused_1,
9536: x_status => l_pref_unused_2,
9537: x_exception_msg => l_pref_unused_3);
9538:
9539: IF (l_pref_unused_2 <> FND_API.G_RET_STS_SUCCESS) THEN
9540: x_price_break_response := 'NONE';
9541: END IF;
9542:
9543: EXCEPTION

Line 9800: -- FND_API.G_RET_STS_SUCCESS (Success)

9796: -- x_return_status OUT NOCOPY VARCHAR2,
9797: -- flag to indicate if the copy procedure
9798: -- was successful or not; It can have
9799: -- following values -
9800: -- FND_API.G_RET_STS_SUCCESS (Success)
9801: -- FND_API.G_RET_STS_ERROR (Success with warning)
9802: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
9803: --
9804: +=========================================================================*/

Line 9801: -- FND_API.G_RET_STS_ERROR (Success with warning)

9797: -- flag to indicate if the copy procedure
9798: -- was successful or not; It can have
9799: -- following values -
9800: -- FND_API.G_RET_STS_SUCCESS (Success)
9801: -- FND_API.G_RET_STS_ERROR (Success with warning)
9802: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
9803: --
9804: +=========================================================================*/
9805:

Line 9802: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)

9798: -- was successful or not; It can have
9799: -- following values -
9800: -- FND_API.G_RET_STS_SUCCESS (Success)
9801: -- FND_API.G_RET_STS_ERROR (Success with warning)
9802: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
9803: --
9804: +=========================================================================*/
9805:
9806:

Line 9840: x_return_status := FND_API.G_RET_STS_SUCCESS;

9836: BEGIN
9837: BEGIN
9838:
9839: l_progress := '000';
9840: x_return_status := FND_API.G_RET_STS_SUCCESS;
9841: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
9842: FND_LOG.string (log_level => FND_LOG.level_procedure,
9843: module => g_module || l_module_name,
9844: message => 'Entering to Procedure ' || g_module || l_module_name

Line 10111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10107: || ', p_auction_header_id = ' || p_auction_header_id
10108: || ', p_user_id = ' || p_user_id);
10109: END IF;
10110: UNSET_SESSION_LANGUAGE;
10111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10112: END;
10113:
10114: END SEND_TASK_ASSIGN_NOTIF;
10115:

Line 10132: -- FND_API.G_RET_STS_SUCCESS (Success)

10128: -- x_return_status OUT NOCOPY VARCHAR2,
10129: -- flag to indicate if the copy procedure
10130: -- was successful or not; It can have
10131: -- following values -
10132: -- FND_API.G_RET_STS_SUCCESS (Success)
10133: -- FND_API.G_RET_STS_ERROR (Success with warning)
10134: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10135: --
10136: +===========================================================================================*/

Line 10133: -- FND_API.G_RET_STS_ERROR (Success with warning)

10129: -- flag to indicate if the copy procedure
10130: -- was successful or not; It can have
10131: -- following values -
10132: -- FND_API.G_RET_STS_SUCCESS (Success)
10133: -- FND_API.G_RET_STS_ERROR (Success with warning)
10134: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10135: --
10136: +===========================================================================================*/
10137:

Line 10134: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)

10130: -- was successful or not; It can have
10131: -- following values -
10132: -- FND_API.G_RET_STS_SUCCESS (Success)
10133: -- FND_API.G_RET_STS_ERROR (Success with warning)
10134: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10135: --
10136: +===========================================================================================*/
10137:
10138: PROCEDURE SEND_TASK_COMPL_NOTIF ( p_auction_header_id IN NUMBER,

Line 10175: x_return_status := FND_API.G_RET_STS_SUCCESS;

10171: BEGIN
10172: BEGIN
10173:
10174: l_progress := '000';
10175: x_return_status := FND_API.G_RET_STS_SUCCESS;
10176:
10177: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
10178: FND_LOG.string (log_level => FND_LOG.level_procedure,
10179: module => g_module || l_module_name,

Line 10507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10503: || ', p_auction_header_id = ' || p_auction_header_id
10504: || ', p_user_id = ' || p_user_id);
10505: END IF;
10506: UNSET_SESSION_LANGUAGE;
10507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10508: END;
10509:
10510: END SEND_TASK_COMPL_NOTIF;
10511:

Line 10564: x_return_status := FND_API.G_RET_STS_SUCCESS;

10560: BEGIN
10561: BEGIN
10562:
10563: l_progress := '000';
10564: x_return_status := FND_API.G_RET_STS_SUCCESS;
10565: l_null_date := null;
10566:
10567: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
10568: FND_LOG.string (log_level => FND_LOG.level_procedure,

Line 10940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10936: || ', l_progress = ' || l_progress
10937: || ', l_auction_header_id = ' || l_auction_header_id);
10938: END IF;
10939: UNSET_SESSION_LANGUAGE;
10940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10941: END;
10942:
10943: END SEND_RESP_NOTIF;
10944:

Line 11161: x_return_status := FND_API.G_RET_STS_ERROR;

11157:
11158: --}
11159:
11160: BEGIN --{
11161: x_return_status := FND_API.G_RET_STS_ERROR;
11162:
11163: l_progress := '000';
11164: l_null_date := null;
11165:

Line 11564: x_return_status := FND_API.G_RET_STS_SUCCESS;

11560: --}
11561:
11562: l_progress := '090';
11563:
11564: x_return_status := FND_API.G_RET_STS_SUCCESS;
11565:
11566: EXCEPTION
11567: WHEN OTHERS THEN
11568: WF_CORE.CONTEXT ('PONAUCT','SEND_MSG_SENT_NOTIF','Process:'||l_progress||'SQL error:' || sqlcode|| ', error message:' ||substr(sqlerrm,1,512));

Line 12674: x_result := FND_API.G_RET_STS_SUCCESS;

12670: module => g_module_prefix || '.show_countdown',
12671: message => 'Entered show_countdown with p_auction_header_id = ' || p_auction_header_id);
12672: END IF;
12673:
12674: x_result := FND_API.G_RET_STS_SUCCESS;
12675:
12676: -- adsahay: bug 6319438 - replace sysdate with last_pause_date for paused auctions,
12677: -- since close_bidding_date can be in the past (lesser than sysdate).
12678: SELECT (close_bidding_date - decode(is_paused, 'Y', last_pause_date, sysdate)), auction_status

Line 12726: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

12722: END IF;
12723: Return l_show_countdown;
12724:
12725: WHEN OTHERS THEN
12726: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
12727: x_error_code := SQLCODE;
12728: x_error_message := SUBSTR(SQLERRM, 1, 100);
12729:
12730: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 12778: x_result := FND_API.G_RET_STS_SUCCESS;

12774: module => g_module_prefix || '.has_distinct_closing_dates',
12775: message => 'Entered has_distinct_closing_dates with p_auction_header_id = ' || p_auction_header_id);
12776: END IF;
12777:
12778: x_result := FND_API.G_RET_STS_SUCCESS;
12779:
12780: -- adsahay: bug 6319438 - replace sysdate with last_pause_date for paused auctions,
12781: -- since close_bidding_date can be in the past (lesser than sysdate).
12782: SELECT (close_bidding_date-decode(is_paused, 'Y', last_pause_date, sysdate)), nvl2(staggered_closing_interval, 'Y', 'N'),

Line 12818: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

12814: RETURN l_flag;
12815:
12816: EXCEPTION
12817: WHEN OTHERS THEN
12818: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
12819: x_error_code := SQLCODE;
12820: x_error_message := SUBSTR(SQLERRM, 1, 100);
12821:
12822: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 12937: -- FND_API.G_RET_STS_SUCCESS (Success)

12933: -- OUT: x_return_status OUT NOCOPY VARCHAR2 - Return status
12934: -- This is a flag to indicate if the procedure
12935: -- was successful or not; It can have
12936: -- following values -
12937: -- FND_API.G_RET_STS_SUCCESS (Success)
12938: -- FND_API.G_RET_STS_ERROR (Success with warning)
12939: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
12940: --
12941: -- x_error_code OUT NOCOPY VARCHAR2 - Error code

Line 12938: -- FND_API.G_RET_STS_ERROR (Success with warning)

12934: -- This is a flag to indicate if the procedure
12935: -- was successful or not; It can have
12936: -- following values -
12937: -- FND_API.G_RET_STS_SUCCESS (Success)
12938: -- FND_API.G_RET_STS_ERROR (Success with warning)
12939: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
12940: --
12941: -- x_error_code OUT NOCOPY VARCHAR2 - Error code
12942: -- x_error_message OUT NOCOPY VARCHAR2 - Error message

Line 12939: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)

12935: -- was successful or not; It can have
12936: -- following values -
12937: -- FND_API.G_RET_STS_SUCCESS (Success)
12938: -- FND_API.G_RET_STS_ERROR (Success with warning)
12939: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
12940: --
12941: -- x_error_code OUT NOCOPY VARCHAR2 - Error code
12942: -- x_error_message OUT NOCOPY VARCHAR2 - Error message
12943: --

Line 12973: x_return_status := FND_API.G_RET_STS_SUCCESS;

12969: module => g_module_prefix || '.notify_bidders_tech_complete',
12970: message => 'Entered notify_bidders_tech_complete with p_auction_header_id = ' || p_auction_header_id);
12971: END IF;
12972:
12973: x_return_status := FND_API.G_RET_STS_SUCCESS;
12974:
12975: BEGIN
12976: -- get auction information
12977: SELECT auction_title, document_number, trading_partner_name

Line 12983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12979: FROM pon_auction_headers_all
12980: WHERE auction_header_id = p_auction_header_id;
12981: EXCEPTION
12982: WHEN NO_DATA_FOUND THEN
12983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12984: x_error_code := SQLCODE;
12985: x_error_message := SUBSTR(SQLERRM, 1, 100);
12986:
12987: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 12995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12991: || p_auction_header_id || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
12992: END IF;
12993:
12994: WHEN TOO_MANY_ROWS THEN
12995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12996: x_error_code := SQLCODE;
12997: x_error_message := SUBSTR(SQLERRM, 1, 100);
12998:
12999: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 13007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13003: || p_auction_header_id || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
13004: END IF;
13005:
13006: WHEN OTHERS THEN
13007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13008: x_error_code := SQLCODE;
13009: x_error_message := SUBSTR(SQLERRM, 1, 100);
13010:
13011: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 13127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13123: END LOOP;
13124:
13125: EXCEPTION
13126: WHEN OTHERS THEN
13127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13128: x_error_code := SQLCODE;
13129: x_error_message := SUBSTR(SQLERRM, 1, 100);
13130:
13131: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN