DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PUB dependencies on PON_AUCTION_HEADERS_INTERFACE

Line 26: FROM pon_auction_headers_Interface WHERE interface_group_id = p_group_batch_id

22:
23: BEGIN
24: SELECT 1
25: INTO dummy1
26: FROM pon_auction_headers_Interface WHERE interface_group_id = p_group_batch_id
27: AND PROCESSING_STATUS_CODE = 'PENDING'
28: AND ROWNUM < 2;
29: EXCEPTION
30: WHEN No_Data_Found THEN

Line 31: print_Log('No row found in pon_auction_headers_Interface table for the given group_batch_id' );

27: AND PROCESSING_STATUS_CODE = 'PENDING'
28: AND ROWNUM < 2;
29: EXCEPTION
30: WHEN No_Data_Found THEN
31: print_Log('No row found in pon_auction_headers_Interface table for the given group_batch_id' );
32: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_INV_GRPBATCHID');
33: FND_MSG_PUB.ADD;
34: RETCODE := '2';
35: RETURN;