DBA Data[Home] [Help]

APPS.ARP_XLA_EVENTS dependencies on ARP_XLA_EVENTS

Line 1: PACKAGE BODY ARP_XLA_EVENTS AS

1: PACKAGE BODY ARP_XLA_EVENTS AS
2: /* $Header: ARXLAEVB.pls 120.56.12010000.8 2008/12/30 08:52:41 nproddut ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 314: log('ARP_XLA_EVENTS.Create_Events()+');

310: l_security xla_events_pub_pkg.t_security;
311:
312: BEGIN
313:
314: log('ARP_XLA_EVENTS.Create_Events()+');
315:
316: log('xla_from_doc_id :'
317: || p_xla_ev_rec.xla_from_doc_id);
318:

Line 366: log('ARP_XLA_EVENTS.Create_Events()-');

362: Upd_Dist(p_xla_ev_rec => p_xla_ev_rec);
363: END IF;
364:
365:
366: log('ARP_XLA_EVENTS.Create_Events()-');
367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: log('NO_DATA_FOUND EXCEPTION: ARP_XLA_EVENTS.Create_Events');

Line 370: log('NO_DATA_FOUND EXCEPTION: ARP_XLA_EVENTS.Create_Events');

366: log('ARP_XLA_EVENTS.Create_Events()-');
367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: log('NO_DATA_FOUND EXCEPTION: ARP_XLA_EVENTS.Create_Events');
371: RAISE;
372:
373: WHEN OTHERS THEN
374: log('OTHERS EXCEPTION: ARP_XLA_EVENTS.Create_Events');

Line 374: log('OTHERS EXCEPTION: ARP_XLA_EVENTS.Create_Events');

370: log('NO_DATA_FOUND EXCEPTION: ARP_XLA_EVENTS.Create_Events');
371: RAISE;
372:
373: WHEN OTHERS THEN
374: log('OTHERS EXCEPTION: ARP_XLA_EVENTS.Create_Events');
375: RAISE;
376:
377: END Create_Events;
378:

Line 426: l_xla_ev_rec arp_xla_events.xla_events_type;

422: p_doc_table IN VARCHAR2,
423: p_mode IN VARCHAR2,
424: p_call IN VARCHAR2)
425: IS
426: l_xla_ev_rec arp_xla_events.xla_events_type;
427: BEGIN
428: log('arp_xla_events.create_events_doc ()+');
429: l_xla_ev_rec.xla_doc_table := p_doc_table;
430: l_xla_ev_rec.xla_from_doc_id := p_document_id;

Line 428: log('arp_xla_events.create_events_doc ()+');

424: p_call IN VARCHAR2)
425: IS
426: l_xla_ev_rec arp_xla_events.xla_events_type;
427: BEGIN
428: log('arp_xla_events.create_events_doc ()+');
429: l_xla_ev_rec.xla_doc_table := p_doc_table;
430: l_xla_ev_rec.xla_from_doc_id := p_document_id;
431: l_xla_ev_rec.xla_to_doc_id := p_document_id;
432: l_xla_ev_rec.xla_mode := p_mode;

Line 434: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);

430: l_xla_ev_rec.xla_from_doc_id := p_document_id;
431: l_xla_ev_rec.xla_to_doc_id := p_document_id;
432: l_xla_ev_rec.xla_mode := p_mode;
433: l_xla_ev_rec.xla_call := p_call;
434: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
435: log('arp_xla_events.create_events_doc ()-');
436: EXCEPTION
437: WHEN OTHERS THEN
438: log('EXCEPTION: arp_xla_events.create_events_doc');

Line 435: log('arp_xla_events.create_events_doc ()-');

431: l_xla_ev_rec.xla_to_doc_id := p_document_id;
432: l_xla_ev_rec.xla_mode := p_mode;
433: l_xla_ev_rec.xla_call := p_call;
434: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
435: log('arp_xla_events.create_events_doc ()-');
436: EXCEPTION
437: WHEN OTHERS THEN
438: log('EXCEPTION: arp_xla_events.create_events_doc');
439: RAISE;

Line 438: log('EXCEPTION: arp_xla_events.create_events_doc');

434: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
435: log('arp_xla_events.create_events_doc ()-');
436: EXCEPTION
437: WHEN OTHERS THEN
438: log('EXCEPTION: arp_xla_events.create_events_doc');
439: RAISE;
440: END;
441:
442:

Line 490: l_xla_ev_rec arp_xla_events.xla_events_type;

486: p_doc_table IN VARCHAR2,
487: p_mode IN VARCHAR2,
488: p_call IN VARCHAR2)
489: IS
490: l_xla_ev_rec arp_xla_events.xla_events_type;
491: BEGIN
492: log('arp_xla_events.create_events_req ()+');
493: l_xla_ev_rec.xla_doc_table := p_doc_table;
494: l_xla_ev_rec.xla_req_id := p_request_id;

Line 492: log('arp_xla_events.create_events_req ()+');

488: p_call IN VARCHAR2)
489: IS
490: l_xla_ev_rec arp_xla_events.xla_events_type;
491: BEGIN
492: log('arp_xla_events.create_events_req ()+');
493: l_xla_ev_rec.xla_doc_table := p_doc_table;
494: l_xla_ev_rec.xla_req_id := p_request_id;
495: l_xla_ev_rec.xla_mode := p_mode;
496: l_xla_ev_rec.xla_call := p_call;

Line 497: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);

493: l_xla_ev_rec.xla_doc_table := p_doc_table;
494: l_xla_ev_rec.xla_req_id := p_request_id;
495: l_xla_ev_rec.xla_mode := p_mode;
496: l_xla_ev_rec.xla_call := p_call;
497: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
498: log('arp_xla_events.create_events_req ()-');
499: EXCEPTION
500: WHEN OTHERS THEN
501: log('EXCEPTION: arp_xla_events.create_events_req');

Line 498: log('arp_xla_events.create_events_req ()-');

494: l_xla_ev_rec.xla_req_id := p_request_id;
495: l_xla_ev_rec.xla_mode := p_mode;
496: l_xla_ev_rec.xla_call := p_call;
497: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
498: log('arp_xla_events.create_events_req ()-');
499: EXCEPTION
500: WHEN OTHERS THEN
501: log('EXCEPTION: arp_xla_events.create_events_req');
502: RAISE;

Line 501: log('EXCEPTION: arp_xla_events.create_events_req');

497: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
498: log('arp_xla_events.create_events_req ()-');
499: EXCEPTION
500: WHEN OTHERS THEN
501: log('EXCEPTION: arp_xla_events.create_events_req');
502: RAISE;
503: END;
504:
505: /*========================================================================

Line 565: log('ARP_XLA_EVENTS.Build_Stmt ()+');

561: l_union VARCHAR2(10) ;
562: CRLF CONSTANT VARCHAR2(1) := arp_global.CRLF;
563:
564: BEGIN
565: log('ARP_XLA_EVENTS.Build_Stmt ()+');
566:
567:
568: IF p_xla_ev_rec.xla_doc_table IN ('CRHMCD','CRHAPP','CTCMAPP') THEN
569: l_union := ' UNION ';

Line 1712: | package which call ARP_XLA_EVENTS to create events |

1708: | The document id for BR is a transaction history id |
1709: | instead of customer_trx_id. The customer_trx_id is |
1710: | only used for storing the header info BR, all the |
1711: | accounting is driven by TRH. So the ARP_ACCT_MAIN |
1712: | package which call ARP_XLA_EVENTS to create events |
1713: | along with the accounting entries required a TRH_ID |
1714: | instead of a customer_trx_id. |
1715: | This change will not impact the upgrade mode neither|
1716: | the batch mode for they do not use document id |

Line 1935: log('ARP_XLA_EVENTS.Build_Stmt ()-');

1931: l_order_by_clause ;
1932:
1933: log('p_stmt ' || SUBSTRB(p_stmt,1,3980));
1934:
1935: log('ARP_XLA_EVENTS.Build_Stmt ()-');
1936: EXCEPTION
1937: WHEN OTHERS THEN
1938: log('EXCEPTION: ARP_XLA_EVENTS.Build_Stmt');
1939: RAISE;

Line 1938: log('EXCEPTION: ARP_XLA_EVENTS.Build_Stmt');

1934:
1935: log('ARP_XLA_EVENTS.Build_Stmt ()-');
1936: EXCEPTION
1937: WHEN OTHERS THEN
1938: log('EXCEPTION: ARP_XLA_EVENTS.Build_Stmt');
1939: RAISE;
1940:
1941: END Build_Stmt;
1942:

Line 1970: log( 'ARP_XLA_EVENTS.define_arrays()+' );

1966: p_xla_ev_rec IN xla_events_type,
1967: p_ev_rec IN ev_rec_type,
1968: p_call_point IN NUMBER) IS
1969: BEGIN
1970: log( 'ARP_XLA_EVENTS.define_arrays()+' );
1971:
1972: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
1973:
1974: dbms_sql.define_array(p_select_c, 1 , p_ev_rec.posttogl

Line 2016: log( 'ARP_XLA_EVENTS.define_arrays()-' );

2012: dbms_sql.define_array(p_select_c, 2 , p_ev_rec.dist_event_id
2013: , MAX_ARRAY_SIZE, STARTING_INDEX );
2014: END IF;
2015:
2016: log( 'ARP_XLA_EVENTS.define_arrays()-' );
2017:
2018: EXCEPTION
2019: WHEN OTHERS THEN
2020: log('EXCEPTION: ARP_XLA_EVENTS.define_arrays');

Line 2020: log('EXCEPTION: ARP_XLA_EVENTS.define_arrays');

2016: log( 'ARP_XLA_EVENTS.define_arrays()-' );
2017:
2018: EXCEPTION
2019: WHEN OTHERS THEN
2020: log('EXCEPTION: ARP_XLA_EVENTS.define_arrays');
2021: RAISE;
2022:
2023: END define_arrays;
2024:

Line 2054: log('ARP_XLA_EVENTS.get_column_values (+)');

2050: p_xla_ev_rec IN xla_events_type,
2051: p_call_point IN NUMBER,
2052: p_ev_rec OUT NOCOPY ev_rec_type) IS
2053: BEGIN
2054: log('ARP_XLA_EVENTS.get_column_values (+)');
2055:
2056: IF p_xla_ev_rec.xla_call IN ('C','B') AND p_call_point = 1 THEN
2057: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.posttogl);
2058: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.trx_type);

Line 2080: log('ARP_XLA_EVENTS.get_column_values (-)');

2076: dbms_sql.column_value(p_select_c, 1 , p_ev_rec.dist_row_id);
2077: dbms_sql.column_value(p_select_c, 2 , p_ev_rec.dist_event_id);
2078: END IF;
2079:
2080: log('ARP_XLA_EVENTS.get_column_values (-)');
2081:
2082: END get_column_values;
2083:
2084: /*========================================================================

Line 2115: log('ARP_XLA_EVENTS.Get_Select_Cursor ()+');

2111: l_ev_rec ev_rec_type;
2112:
2113: BEGIN
2114:
2115: log('ARP_XLA_EVENTS.Get_Select_Cursor ()+');
2116:
2117: Build_Stmt(p_xla_ev_rec => p_xla_ev_rec,
2118: p_stmt => l_stmt,
2119: p_call_point => p_call_point);

Line 2166: log('ARP_XLA_EVENTS.Get_Select_Cursor (-)');

2162: log('p_xla_ev_rec.xla_dist_id ' || p_xla_ev_rec.xla_dist_id);
2163: dbms_sql.bind_variable(l_select_c, ':b_xla_dist_id', p_xla_ev_rec.xla_dist_id);
2164: END IF;
2165:
2166: log('ARP_XLA_EVENTS.Get_Select_Cursor (-)');
2167:
2168: return(l_select_c);
2169:
2170: EXCEPTION

Line 2172: log('EXCEPTION: ARP_XLA_EVENTS.Get_Select_Cursor:'||SQLERRM);

2168: return(l_select_c);
2169:
2170: EXCEPTION
2171: WHEN OTHERS THEN
2172: log('EXCEPTION: ARP_XLA_EVENTS.Get_Select_Cursor:'||SQLERRM);
2173: RAISE;
2174:
2175: END Get_Select_Cursor;
2176:

Line 2283: log('ARP_XLA_EVENTS.Create_All_Events ()+');

2279: l_test VARCHAR2(1);
2280:
2281:
2282: BEGIN
2283: log('ARP_XLA_EVENTS.Create_All_Events ()+');
2284:
2285: --Bug#3135769
2286: --{
2287: IF arp_standard.sysparm.set_of_books_id IS NULL THEN

Line 2739: log('arp_xla_events.is_one_acct_asg_on_ctlgd()+');

2735: +---------------------------------------------------------*/
2736: l_revrun := 'X';
2737:
2738: IF ev_rec.trx_type(i) = 'INV' AND p_xla_ev_rec.xla_mode = 'O' THEN
2739: log('arp_xla_events.is_one_acct_asg_on_ctlgd()+');
2740: log('The customer_trx_id :'||ev_rec.trx_id(i));
2741:
2742: l_revrun := is_one_acct_asg_on_ctlgd(ev_rec.trx_id(i));
2743:

Line 2745: log('arp_xla_events.is_one_acct_asg_on_ctlgd()-');

2741:
2742: l_revrun := is_one_acct_asg_on_ctlgd(ev_rec.trx_id(i));
2743:
2744: log('l_revrun : '||l_revrun);
2745: log('arp_xla_events.is_one_acct_asg_on_ctlgd()-');
2746: END IF;
2747:
2748: /*---------------------------------------------------------+
2749: |Update existing Event |

Line 3331: log('ARP_XLA_EVENTS.Create_All_Events ()-');

3327: |the event. |
3328: +--------------------------------------------------------------*/
3329:
3330: <>
3331: log('ARP_XLA_EVENTS.Create_All_Events ()-');
3332:
3333: EXCEPTION
3334: WHEN OTHERS THEN
3335: log('EXCEPTION: ARP_XLA_EVENTS.Create_All_Events ');

Line 3335: log('EXCEPTION: ARP_XLA_EVENTS.Create_All_Events ');

3331: log('ARP_XLA_EVENTS.Create_All_Events ()-');
3332:
3333: EXCEPTION
3334: WHEN OTHERS THEN
3335: log('EXCEPTION: ARP_XLA_EVENTS.Create_All_Events ');
3336: log('SQLERRM ' || SQLERRM);
3337: log('EXCEPTION: ARP_XLA_EVENTS.Create_All_Events ');
3338: log('SQLERRM ' || SQLERRM);
3339: RAISE;

Line 3337: log('EXCEPTION: ARP_XLA_EVENTS.Create_All_Events ');

3333: EXCEPTION
3334: WHEN OTHERS THEN
3335: log('EXCEPTION: ARP_XLA_EVENTS.Create_All_Events ');
3336: log('SQLERRM ' || SQLERRM);
3337: log('EXCEPTION: ARP_XLA_EVENTS.Create_All_Events ');
3338: log('SQLERRM ' || SQLERRM);
3339: RAISE;
3340: END Create_All_Events;
3341:

Line 3372: log('arp_xla_events.un_denormalize_posting_entity()+');

3368: ( p_xla_doc IN VARCHAR2,
3369: p_event_id IN NUMBER ) IS
3370:
3371: BEGIN
3372: log('arp_xla_events.un_denormalize_posting_entity()+');
3373:
3374: IF test_flag = 'Y' THEN
3375: GOTO endlabel;
3376: END IF;

Line 3418: log('arp_xla_events.un_denormalize_posting_entity()-');

3414: END IF;
3415:
3416: <>
3417:
3418: log('arp_xla_events.un_denormalize_posting_entity()-');
3419:
3420: EXCEPTION
3421: WHEN OTHERS THEN
3422: log('EXCEPTION: arp_xla_events.un_denormalize_posting_entity');

Line 3422: log('EXCEPTION: arp_xla_events.un_denormalize_posting_entity');

3418: log('arp_xla_events.un_denormalize_posting_entity()-');
3419:
3420: EXCEPTION
3421: WHEN OTHERS THEN
3422: log('EXCEPTION: arp_xla_events.un_denormalize_posting_entity');
3423: log('SQLERRM '||sqlerrm);
3424: RAISE;
3425:
3426: END un_denormalize_posting_entity;

Line 3547: log('ARP_XLA_EVENTS.Upd_Dist()+');

3543: l_last_updated_by NUMBER := arp_standard.profile.user_id;
3544: l_last_update_login NUMBER := arp_standard.profile.last_update_login;
3545: BEGIN
3546:
3547: log('ARP_XLA_EVENTS.Upd_Dist()+');
3548:
3549: IF p_xla_ev_rec.xla_call IN ('D','B') THEN
3550: null;
3551: ELSE goto endlabel;

Line 3696: log('ARP_XLA_EVENTS.Upd_Dist()-');

3692:
3693: END LOOP; --Array (Bulk) Fetch
3694:
3695: <>
3696: log('ARP_XLA_EVENTS.Upd_Dist()-');
3697:
3698: EXCEPTION
3699: WHEN OTHERS THEN
3700: log('EXCEPTION: ARP_XLA_EVENTS.Upd_Dist');

Line 3700: log('EXCEPTION: ARP_XLA_EVENTS.Upd_Dist');

3696: log('ARP_XLA_EVENTS.Upd_Dist()-');
3697:
3698: EXCEPTION
3699: WHEN OTHERS THEN
3700: log('EXCEPTION: ARP_XLA_EVENTS.Upd_Dist');
3701: RAISE;
3702:
3703: END Upd_Dist;
3704:

Line 3733: log('ARP_XLA_EVENTS.dump_ev_rec()+');

3729:
3730: BEGIN
3731:
3732: log(' ');
3733: log('ARP_XLA_EVENTS.dump_ev_rec()+');
3734:
3735: IF p_ev_rec.trx_status.EXISTS(p_i) THEN
3736:
3737: log('p_ev_rec.trx_status(' || p_i || ') = '

Line 3759: log('ARP_XLA_EVENTS.dump_ev_rec()-');

3755: log('p_ev_rec.ev_match_type(' || p_i || ') = '
3756: || p_ev_rec.ev_match_type(p_i));
3757: END IF;
3758:
3759: log('ARP_XLA_EVENTS.dump_ev_rec()-');
3760: log(' ');
3761:
3762: EXCEPTION
3763: WHEN OTHERS THEN

Line 3764: log('EXCEPTION: ARP_XLA_EVENTS.dump_ev_rec');

3760: log(' ');
3761:
3762: EXCEPTION
3763: WHEN OTHERS THEN
3764: log('EXCEPTION: ARP_XLA_EVENTS.dump_ev_rec');
3765: RAISE;
3766: END dump_ev_rec;
3767:
3768:

Line 3776: log('ARP_XLA_EVENTS.dump_event_source_info()+');

3772: IS
3773: BEGIN
3774:
3775: log(' ');
3776: log('ARP_XLA_EVENTS.dump_event_source_info()+');
3777:
3778: log('x_ev_source_info.application_id = '
3779: || x_ev_source_info.application_id);
3780: log('x_ev_source_info.legal_entity_id = '

Line 3806: log('ARP_XLA_EVENTS.dump_event_source_info()-');

3802: log('x_ev_source_info.source_id_char_4 = '
3803: || x_ev_source_info.source_id_char_4);
3804: log('x_ev_source_info.legal_entity_id = '
3805: || x_ev_source_info.legal_entity_id);
3806: log('ARP_XLA_EVENTS.dump_event_source_info()-');
3807: log(' ');
3808:
3809: EXCEPTION
3810: WHEN OTHERS THEN

Line 3811: log('EXCEPTION: ARP_XLA_EVENTS.dump_event_source_info');

3807: log(' ');
3808:
3809: EXCEPTION
3810: WHEN OTHERS THEN
3811: log('EXCEPTION: ARP_XLA_EVENTS.dump_event_source_info');
3812: RAISE;
3813: END dump_event_source_info;
3814:
3815: /*========================================================================

Line 3852: log('ARP_XLA_EVENTS.Change_Matrix()+');

3848: l_change_matrix VARCHAR2(30);
3849:
3850: BEGIN
3851:
3852: log('ARP_XLA_EVENTS.Change_Matrix()+');
3853: log('trx_status :'||trx_status);
3854: log('dist_gl_date :'||dist_gl_date);
3855: log('ev_match_gl_date :'||ev_match_gl_date);
3856: log('ev_match_status :'||ev_match_status);

Line 4134: log('ARP_XLA_EVENTS.Change_Matrix()-');

4130: END IF; --distributions cannot be posted
4131:
4132: RETURN(l_change_matrix);
4133:
4134: log('ARP_XLA_EVENTS.Change_Matrix()-');
4135:
4136: EXCEPTION
4137: WHEN OTHERS THEN
4138: log('EXCEPTION: ARP_XLA_EVENTS.dump_bld_rec');

Line 4138: log('EXCEPTION: ARP_XLA_EVENTS.dump_bld_rec');

4134: log('ARP_XLA_EVENTS.Change_Matrix()-');
4135:
4136: EXCEPTION
4137: WHEN OTHERS THEN
4138: log('EXCEPTION: ARP_XLA_EVENTS.dump_bld_rec');
4139: RAISE;
4140: END Change_Matrix;
4141:
4142: /*========================================================================

Line 4169: log('ARP_XLA_EVENTS.dump_bld_rec()+');

4165: p_i IN BINARY_INTEGER ,
4166: p_tag IN VARCHAR2 ) IS
4167: BEGIN
4168:
4169: log('ARP_XLA_EVENTS.dump_bld_rec()+');
4170:
4171: IF p_bld_rec.bld_dml_flag.EXISTS(p_i) THEN
4172:
4173: log(p_tag ||'.bld_dml_flag('||p_i||') = '

Line 4177: log('ARP_XLA_EVENTS.dump_bld_rec()-');

4173: log(p_tag ||'.bld_dml_flag('||p_i||') = '
4174: || p_bld_rec.bld_dml_flag(p_i));
4175: END IF;
4176:
4177: log('ARP_XLA_EVENTS.dump_bld_rec()-');
4178: log(' ');
4179:
4180: EXCEPTION
4181: WHEN OTHERS THEN

Line 4182: log('EXCEPTION: ARP_XLA_EVENTS.dump_bld_rec');

4178: log(' ');
4179:
4180: EXCEPTION
4181: WHEN OTHERS THEN
4182: log('EXCEPTION: ARP_XLA_EVENTS.dump_bld_rec');
4183: RAISE;
4184:
4185: END dump_bld_rec;
4186:

Line 4215: log('ARP_XLA_EVENTS.dump_event_info()+');

4211: p_i IN BINARY_INTEGER ,
4212: p_tag IN VARCHAR2 ) IS
4213: BEGIN
4214:
4215: log('ARP_XLA_EVENTS.dump_event_info()+');
4216:
4217: IF p_ev_info_tab.EXISTS(p_i) THEN
4218:
4219: log(p_tag ||'.p_ev_info_tab('||p_i||').event_id = '||

Line 4239: log('ARP_XLA_EVENTS.dump_event_info()-');

4235: p_ev_info_tab(p_i).transaction_number );
4236:
4237: END IF;
4238:
4239: log('ARP_XLA_EVENTS.dump_event_info()-');
4240: log(' ');
4241:
4242: EXCEPTION
4243: WHEN OTHERS THEN

Line 4244: log('EXCEPTION: ARP_XLA_EVENTS.dump_event_info');

4240: log(' ');
4241:
4242: EXCEPTION
4243: WHEN OTHERS THEN
4244: log('EXCEPTION: ARP_XLA_EVENTS.dump_event_info');
4245: RAISE;
4246:
4247: END dump_event_info;
4248:

Line 4322: log('arp_xla_events.delete_event ()+');

4318: FROM ar_transaction_history
4319: WHERE transaction_history_id = p_document_id;
4320:
4321: BEGIN
4322: log('arp_xla_events.delete_event ()+');
4323:
4324: IF p_doc_table = 'CT' THEN
4325: OPEN c_ct;
4326: FETCH c_ct INTO l_event_id;

Line 4371: log('arp_xla_events.delete_event ()-');

4367: p_valuation_method => NULL,
4368: p_security_context => l_security);
4369: END IF;
4370:
4371: log('arp_xla_events.delete_event ()-');
4372: EXCEPTION
4373: WHEN OTHERS THEN
4374: log('EXCEPTION: arp_xla_events.delete_event'||SQLERRM);
4375: RAISE;

Line 4374: log('EXCEPTION: arp_xla_events.delete_event'||SQLERRM);

4370:
4371: log('arp_xla_events.delete_event ()-');
4372: EXCEPTION
4373: WHEN OTHERS THEN
4374: log('EXCEPTION: arp_xla_events.delete_event'||SQLERRM);
4375: RAISE;
4376: END delete_event;
4377:
4378:

Line 4430: log('arp_xla_events.delete_reverse_revrec_event ()+');

4426: );
4427:
4428:
4429: BEGIN
4430: log('arp_xla_events.delete_reverse_revrec_event ()+');
4431:
4432: FOR c IN c_ct loop
4433:
4434: l_event_id := c.event_id;

Line 4450: log('arp_xla_events.delete_reverse_revrec_event ()-');

4446: p_security_context => l_security);
4447:
4448: END loop;
4449:
4450: log('arp_xla_events.delete_reverse_revrec_event ()-');
4451: EXCEPTION
4452: WHEN OTHERS THEN
4453: log('EXCEPTION: arp_xla_events.delete_reverse_revrec_event'||SQLERRM);
4454: RAISE;

Line 4453: log('EXCEPTION: arp_xla_events.delete_reverse_revrec_event'||SQLERRM);

4449:
4450: log('arp_xla_events.delete_reverse_revrec_event ()-');
4451: EXCEPTION
4452: WHEN OTHERS THEN
4453: log('EXCEPTION: arp_xla_events.delete_reverse_revrec_event'||SQLERRM);
4454: RAISE;
4455: END delete_reverse_revrec_event;
4456:
4457:

Line 4485: -- arp_xla_events.create_events(p_request_id, 'CT');

4481: p_code IN VARCHAR2)
4482: IS
4483: BEGIN
4484: IF p_code = 'CTADJ' THEN
4485: -- arp_xla_events.create_events(p_request_id, 'CT');
4486: -- arp_xla_events.create_events(p_request_id, 'ADJ');
4487: ELSE
4488: -- arp_xla_events.create_events(p_request_id, 'CTCMAPP');
4489: END IF;

Line 4486: -- arp_xla_events.create_events(p_request_id, 'ADJ');

4482: IS
4483: BEGIN
4484: IF p_code = 'CTADJ' THEN
4485: -- arp_xla_events.create_events(p_request_id, 'CT');
4486: -- arp_xla_events.create_events(p_request_id, 'ADJ');
4487: ELSE
4488: -- arp_xla_events.create_events(p_request_id, 'CTCMAPP');
4489: END IF;
4490:

Line 4488: -- arp_xla_events.create_events(p_request_id, 'CTCMAPP');

4484: IF p_code = 'CTADJ' THEN
4485: -- arp_xla_events.create_events(p_request_id, 'CT');
4486: -- arp_xla_events.create_events(p_request_id, 'ADJ');
4487: ELSE
4488: -- arp_xla_events.create_events(p_request_id, 'CTCMAPP');
4489: END IF;
4490:
4491: IF p_code = 'CTADJ' THEN
4492: INSERT INTO RA_INTERFACE_ERRORS

Line 4524: END ARP_XLA_EVENTS;

4520: END IF;
4521: END;
4522: */
4523:
4524: END ARP_XLA_EVENTS;