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 1874: p_init_msg_list => FND_API.G_FALSE,

1870:
1871: -- Raise Business Event
1872: PON_BIZ_EVENTS_PVT.RAISE_NEG_PUB_EVENT (
1873: p_api_version => 1.0 ,
1874: p_init_msg_list => FND_API.G_FALSE,
1875: p_commit => FND_API.G_FALSE,
1876: p_auction_header_id => p_auction_header_id,
1877: x_return_status => x_return_status,
1878: x_msg_count => x_msg_count,

Line 1875: p_commit => FND_API.G_FALSE,

1871: -- Raise Business Event
1872: PON_BIZ_EVENTS_PVT.RAISE_NEG_PUB_EVENT (
1873: p_api_version => 1.0 ,
1874: p_init_msg_list => FND_API.G_FALSE,
1875: p_commit => FND_API.G_FALSE,
1876: p_auction_header_id => p_auction_header_id,
1877: x_return_status => x_return_status,
1878: x_msg_count => x_msg_count,
1879: x_msg_data => x_msg_data);

Line 2472: p_init_msg_list => FND_API.G_FALSE,

2468:
2469: -- Raise Business Event
2470: PON_BIZ_EVENTS_PVT.RAISE_RESPNSE_DISQ_EVENT (
2471: p_api_version => 1.0 ,
2472: p_init_msg_list => FND_API.G_FALSE,
2473: p_commit => FND_API.G_FALSE,
2474: p_bid_number => p_bid_id,
2475: x_return_status => x_return_status,
2476: x_msg_count => x_msg_count,

Line 2473: p_commit => FND_API.G_FALSE,

2469: -- Raise Business Event
2470: PON_BIZ_EVENTS_PVT.RAISE_RESPNSE_DISQ_EVENT (
2471: p_api_version => 1.0 ,
2472: p_init_msg_list => FND_API.G_FALSE,
2473: p_commit => FND_API.G_FALSE,
2474: p_bid_number => p_bid_id,
2475: x_return_status => x_return_status,
2476: x_msg_count => x_msg_count,
2477: x_msg_data => x_msg_data);

Line 9742: x_error_code := FND_API.G_RET_STS_SUCCESS;

9738: -----------------------------------------------------------------------------------------------------------------------------------------------
9739: -- the above routine does't use FND constants,
9740: -- while UPDATE_NEGOTIATION_LINE_REF does, so convert it.
9741: IF (x_error_code = 'SUCCESS') THEN
9742: x_error_code := FND_API.G_RET_STS_SUCCESS;
9743: END IF;
9744:
9745: -- changes for FPI. For items that are carried over from previous round
9746: -- update the corresponding backing requisition references (no change

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

9757: OPEN deletedItems;
9758: LOOP
9759: FETCH deletedItems INTO
9760: l_line_number;
9761: EXIT WHEN deletedItems%NOTFOUND OR (x_error_code <> FND_API.G_RET_STS_SUCCESS);
9762:
9763: -- PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(x_new_negotiation_id, l_line_number, x_error_code);
9764:
9765: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_LINE_REF(

Line 9777: /* IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN

9773: X_ERROR_MESSAGE => x_error_message);
9774: END LOOP;
9775: CLOSE deletedItems;
9776: -- FPI: bug 2811671 still need to return the req back to pool
9777: /* IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9778: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(
9779: X_NEGOTIATION_ID => x_old_negotiation_id,
9780: X_NEGOTIATION_LINE_NUM => null,
9781: X_FLAG_VALUE => 'Y',

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

9783: END IF; */
9784:
9785:
9786: -- convert fnd constant to our own internal code
9787: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9788: x_error_code := 'SUCCESS';
9789: END IF;
9790:
9791:

Line 9840: x_error_code:=FND_API.G_RET_STS_SUCCESS;

9836: WHEN OTHERS THEN
9837: l_requisition_line_id:=NULL;
9838:
9839: END;
9840: x_error_code:=FND_API.G_RET_STS_SUCCESS;
9841:
9842: END LOOP;
9843:
9844: ELSE

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

9851:
9852:
9853:
9854: /* bug#10295849: Added the code to delete the negotiation references in po_requisition_lines_all table, if the requisition lines are deleted in the solicitation */
9855: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9856: update po_requisition_lines_all
9857: set auction_header_id = null,
9858: auction_display_number = null,
9859: auction_line_number = null

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

9861: END IF;
9862: END IF;
9863: END IF;
9864: -- convert fnd constant to our own internal code
9865: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9866: x_error_code := 'SUCCESS';
9867: END IF;
9868:
9869:

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

10371: x_pref_meaning => l_pref_unused_1,
10372: x_status => l_pref_unused_2,
10373: x_exception_msg => l_pref_unused_3);
10374:
10375: IF (l_pref_unused_2 <> FND_API.G_RET_STS_SUCCESS) THEN
10376: x_price_break_response := 'NONE';
10377: END IF;
10378:
10379: EXCEPTION

Line 10636: -- FND_API.G_RET_STS_SUCCESS (Success)

10632: -- x_return_status OUT NOCOPY VARCHAR2,
10633: -- flag to indicate if the copy procedure
10634: -- was successful or not; It can have
10635: -- following values -
10636: -- FND_API.G_RET_STS_SUCCESS (Success)
10637: -- FND_API.G_RET_STS_ERROR (Success with warning)
10638: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10639: --
10640: +=========================================================================*/

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

10633: -- flag to indicate if the copy procedure
10634: -- was successful or not; It can have
10635: -- following values -
10636: -- FND_API.G_RET_STS_SUCCESS (Success)
10637: -- FND_API.G_RET_STS_ERROR (Success with warning)
10638: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10639: --
10640: +=========================================================================*/
10641:

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

10634: -- was successful or not; It can have
10635: -- following values -
10636: -- FND_API.G_RET_STS_SUCCESS (Success)
10637: -- FND_API.G_RET_STS_ERROR (Success with warning)
10638: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10639: --
10640: +=========================================================================*/
10641:
10642:

Line 10676: x_return_status := FND_API.G_RET_STS_SUCCESS;

10672: BEGIN
10673: BEGIN
10674:
10675: l_progress := '000';
10676: x_return_status := FND_API.G_RET_STS_SUCCESS;
10677: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
10678: FND_LOG.string (log_level => FND_LOG.level_procedure,
10679: module => g_module || l_module_name,
10680: message => 'Entering to Procedure ' || g_module || l_module_name

Line 10947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10943: || ', p_auction_header_id = ' || p_auction_header_id
10944: || ', p_user_id = ' || p_user_id);
10945: END IF;
10946: UNSET_SESSION_LANGUAGE;
10947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10948: END;
10949:
10950: END SEND_TASK_ASSIGN_NOTIF;
10951:

Line 10968: -- FND_API.G_RET_STS_SUCCESS (Success)

10964: -- x_return_status OUT NOCOPY VARCHAR2,
10965: -- flag to indicate if the copy procedure
10966: -- was successful or not; It can have
10967: -- following values -
10968: -- FND_API.G_RET_STS_SUCCESS (Success)
10969: -- FND_API.G_RET_STS_ERROR (Success with warning)
10970: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10971: --
10972: +===========================================================================================*/

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

10965: -- flag to indicate if the copy procedure
10966: -- was successful or not; It can have
10967: -- following values -
10968: -- FND_API.G_RET_STS_SUCCESS (Success)
10969: -- FND_API.G_RET_STS_ERROR (Success with warning)
10970: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10971: --
10972: +===========================================================================================*/
10973:

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

10966: -- was successful or not; It can have
10967: -- following values -
10968: -- FND_API.G_RET_STS_SUCCESS (Success)
10969: -- FND_API.G_RET_STS_ERROR (Success with warning)
10970: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
10971: --
10972: +===========================================================================================*/
10973:
10974: PROCEDURE SEND_TASK_COMPL_NOTIF ( p_auction_header_id IN NUMBER,

Line 11011: x_return_status := FND_API.G_RET_STS_SUCCESS;

11007: BEGIN
11008: BEGIN
11009:
11010: l_progress := '000';
11011: x_return_status := FND_API.G_RET_STS_SUCCESS;
11012:
11013: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
11014: FND_LOG.string (log_level => FND_LOG.level_procedure,
11015: module => g_module || l_module_name,

Line 11343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11339: || ', p_auction_header_id = ' || p_auction_header_id
11340: || ', p_user_id = ' || p_user_id);
11341: END IF;
11342: UNSET_SESSION_LANGUAGE;
11343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11344: END;
11345:
11346: END SEND_TASK_COMPL_NOTIF;
11347:

Line 11400: x_return_status := FND_API.G_RET_STS_SUCCESS;

11396: BEGIN
11397: BEGIN
11398:
11399: l_progress := '000';
11400: x_return_status := FND_API.G_RET_STS_SUCCESS;
11401: l_null_date := null;
11402:
11403: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
11404: FND_LOG.string (log_level => FND_LOG.level_procedure,

Line 11776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11772: || ', l_progress = ' || l_progress
11773: || ', l_auction_header_id = ' || l_auction_header_id);
11774: END IF;
11775: UNSET_SESSION_LANGUAGE;
11776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11777: END;
11778:
11779: END SEND_RESP_NOTIF;
11780:

Line 11997: x_return_status := FND_API.G_RET_STS_ERROR;

11993:
11994: --}
11995:
11996: BEGIN --{
11997: x_return_status := FND_API.G_RET_STS_ERROR;
11998:
11999: l_progress := '000';
12000: l_null_date := null;
12001:

Line 12400: x_return_status := FND_API.G_RET_STS_SUCCESS;

12396: --}
12397:
12398: l_progress := '090';
12399:
12400: x_return_status := FND_API.G_RET_STS_SUCCESS;
12401:
12402: EXCEPTION
12403: WHEN OTHERS THEN
12404: WF_CORE.CONTEXT ('PONAUCT','SEND_MSG_SENT_NOTIF','Process:'||l_progress||'SQL error:' || sqlcode|| ', error message:' ||substr(sqlerrm,1,512));

Line 13531: x_result := FND_API.G_RET_STS_SUCCESS;

13527: module => g_module_prefix || '.show_countdown',
13528: message => 'Entered show_countdown with p_auction_header_id = ' || p_auction_header_id);
13529: END IF;
13530:
13531: x_result := FND_API.G_RET_STS_SUCCESS;
13532:
13533: -- adsahay: bug 6319438 - replace sysdate with last_pause_date for paused auctions,
13534: -- since close_bidding_date can be in the past (lesser than sysdate).
13535: SELECT (close_bidding_date - decode(is_paused, 'Y', last_pause_date, sysdate)), auction_status

Line 13584: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

13580: END IF;
13581: Return l_show_countdown;
13582:
13583: WHEN OTHERS THEN
13584: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
13585: x_error_code := SQLCODE;
13586: x_error_message := SUBSTR(SQLERRM, 1, 100);
13587:
13588: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 13636: x_result := FND_API.G_RET_STS_SUCCESS;

13632: module => g_module_prefix || '.has_distinct_closing_dates',
13633: message => 'Entered has_distinct_closing_dates with p_auction_header_id = ' || p_auction_header_id);
13634: END IF;
13635:
13636: x_result := FND_API.G_RET_STS_SUCCESS;
13637:
13638: -- adsahay: bug 6319438 - replace sysdate with last_pause_date for paused auctions,
13639: -- since close_bidding_date can be in the past (lesser than sysdate).
13640: SELECT (close_bidding_date-decode(is_paused, 'Y', last_pause_date, sysdate)), nvl2(staggered_closing_interval, 'Y', 'N'),

Line 13676: x_result := FND_API.G_RET_STS_UNEXP_ERROR;

13672: RETURN l_flag;
13673:
13674: EXCEPTION
13675: WHEN OTHERS THEN
13676: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
13677: x_error_code := SQLCODE;
13678: x_error_message := SUBSTR(SQLERRM, 1, 100);
13679:
13680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 13795: -- FND_API.G_RET_STS_SUCCESS (Success)

13791: -- OUT: x_return_status OUT NOCOPY VARCHAR2 - Return status
13792: -- This is a flag to indicate if the procedure
13793: -- was successful or not; It can have
13794: -- following values -
13795: -- FND_API.G_RET_STS_SUCCESS (Success)
13796: -- FND_API.G_RET_STS_ERROR (Success with warning)
13797: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
13798: --
13799: -- x_error_code OUT NOCOPY VARCHAR2 - Error code

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

13792: -- This is a flag to indicate if the procedure
13793: -- was successful or not; It can have
13794: -- following values -
13795: -- FND_API.G_RET_STS_SUCCESS (Success)
13796: -- FND_API.G_RET_STS_ERROR (Success with warning)
13797: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
13798: --
13799: -- x_error_code OUT NOCOPY VARCHAR2 - Error code
13800: -- x_error_message OUT NOCOPY VARCHAR2 - Error message

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

13793: -- was successful or not; It can have
13794: -- following values -
13795: -- FND_API.G_RET_STS_SUCCESS (Success)
13796: -- FND_API.G_RET_STS_ERROR (Success with warning)
13797: -- FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
13798: --
13799: -- x_error_code OUT NOCOPY VARCHAR2 - Error code
13800: -- x_error_message OUT NOCOPY VARCHAR2 - Error message
13801: --

Line 13832: x_return_status := FND_API.G_RET_STS_SUCCESS;

13828: module => g_module_prefix || '.notify_bidders_tech_complete',
13829: message => 'Entered notify_bidders_tech_complete with p_auction_header_id = ' || p_auction_header_id);
13830: END IF;
13831:
13832: x_return_status := FND_API.G_RET_STS_SUCCESS;
13833:
13834: BEGIN
13835: -- get auction information
13836: SELECT auction_title, document_number, trading_partner_name

Line 13842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13838: FROM pon_auction_headers_all
13839: WHERE auction_header_id = p_auction_header_id;
13840: EXCEPTION
13841: WHEN NO_DATA_FOUND THEN
13842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13843: x_error_code := SQLCODE;
13844: x_error_message := SUBSTR(SQLERRM, 1, 100);
13845:
13846: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 13854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13850: || p_auction_header_id || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
13851: END IF;
13852:
13853: WHEN TOO_MANY_ROWS THEN
13854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13855: x_error_code := SQLCODE;
13856: x_error_message := SUBSTR(SQLERRM, 1, 100);
13857:
13858: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 13866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13862: || p_auction_header_id || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
13863: END IF;
13864:
13865: WHEN OTHERS THEN
13866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13867: x_error_code := SQLCODE;
13868: x_error_message := SUBSTR(SQLERRM, 1, 100);
13869:
13870: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 13986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13982: END LOOP;
13983:
13984: EXCEPTION
13985: WHEN OTHERS THEN
13986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13987: x_error_code := SQLCODE;
13988: x_error_message := SUBSTR(SQLERRM, 1, 100);
13989:
13990: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

Line 17790: x_return_status := FND_API.G_RET_STS_SUCCESS;

17786: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||'Begin proc:POPULATE_PON_PR_REFS');
17787: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||'auction_header_id:' || p_auction_header_id );
17788: END IF;
17789:
17790: x_return_status := FND_API.G_RET_STS_SUCCESS;
17791: x_no_of_rows_inserted := 0;
17792: l_no_of_rows_inserted := 0;
17793:
17794: --insert req reference in pon_backing_requisitions table

Line 17838: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

17834:
17835: --to remove the selected requisitions from the requisition pool
17836: po_negotiations_sv1.REMOVE_FROM_REQ_POOL('SOLICITATION', p_auction_header_id, p_requisition_line_id, l_return_status, l_error_msg);
17837:
17838: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
17839: x_return_status := l_return_status;
17840: x_error_msg := l_error_msg;
17841: l_progress := '0040';
17842: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 17861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

17857:
17858:
17859: EXCEPTION
17860: WHEN OTHERS THEN
17861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17862: x_error_msg := 'Unexpectional error occured. sqlerrm: '||sqlerrm;
17863:
17864: l_progress := '0070';
17865: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN