[Home] [Help]
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
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;