63: g_trc_idx NUMBER :=1;
64:
65: g_qname varchar2(80) := 'GAT_REQ_Q';
66: g_qtable varchar2(80) := 'GAT_REQ_QTBL';
67: g_payload GAT_message_type;
68:
69: g_submit_sub boolean;
70: g_req_data VARCHAR2(10);
71:
125: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then
126: l_parent_request := fnd_global.conc_request_id;
127: log(l_calling_fn, 'l_parent_request: '|| l_parent_request);
128: l_qstarted := FA_ASSET_TRACE_PUB.start_queue (p_qtable => g_qtable,
129: p_qpayload_type => 'GAT_message_type',
130: p_qname => g_qname);
131:
132: log(l_calling_fn, 'l_qstarted: '|| l_qstarted);
133:
1610: p_subscriber => 'S'||to_char(l_xla_reqID),
1611: p_sub_rule => l_sub_rule)) THEN
1612: log(l_calling_fn,'Failed to add subscriber.');
1613: END IF;
1614: g_payload := GAT_message_type(l_xla_reqID, 'S', g_book, g_asset_id, l_desc);
1615: IF (NOT enqueue_request) THEN
1616: log(l_calling_fn,'Failed to save message to the queue.');
1617: END IF;
1618: log(l_calling_fn, 'Successfully submitted xla request '||l_xla_reqID);