16: END IF;
17: x_return_status := FND_API.G_RET_STS_SUCCESS;
18:
19: BEGIN
20: arp_util.debug ( 'insert header ' || p_trx_header_id );
21:
22: select payment_trxn_extension_id
23: into l_pmt_trxn_id
24: FROM ar_trx_header_gt
23: into l_pmt_trxn_id
24: FROM ar_trx_header_gt
25: WHERE trx_header_id = nvl(p_trx_header_id, trx_header_id);
26:
27: arp_util.debug ( 'insert header ' || p_trx_header_id );
28: arp_util.debug ( 'insert header trxn _id ' || l_pmt_trxn_id );
29: EXCEPTION WHEN OTHERS THEN
30: l_pmt_trxn_id := null;
31: END;
24: FROM ar_trx_header_gt
25: WHERE trx_header_id = nvl(p_trx_header_id, trx_header_id);
26:
27: arp_util.debug ( 'insert header ' || p_trx_header_id );
28: arp_util.debug ( 'insert header trxn _id ' || l_pmt_trxn_id );
29: EXCEPTION WHEN OTHERS THEN
30: l_pmt_trxn_id := null;
31: END;
32: