DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_EVENTS_PUB_PKG

Line 49: l_event_source_info xla_events_pub_pkg.t_event_source_info;

45: p_bordero_id IN NUMBER,
46: p_payment_schedule_id IN NUMBER)
47: RETURN NUMBER IS
48:
49: l_event_source_info xla_events_pub_pkg.t_event_source_info;
50: l_event_id NUMBER;
51: l_org_id NUMBER;
52: l_security_context xla_events_pub_pkg.t_security;
53: l_reference_info xla_events_pub_pkg.t_event_reference_info;

Line 52: l_security_context xla_events_pub_pkg.t_security;

48:
49: l_event_source_info xla_events_pub_pkg.t_event_source_info;
50: l_event_id NUMBER;
51: l_org_id NUMBER;
52: l_security_context xla_events_pub_pkg.t_security;
53: l_reference_info xla_events_pub_pkg.t_event_reference_info;
54: l_category VARCHAR2(30) := NULL;
55: l_occurrence_id NUMBER;
56: l_event_number NUMBER;

Line 53: l_reference_info xla_events_pub_pkg.t_event_reference_info;

49: l_event_source_info xla_events_pub_pkg.t_event_source_info;
50: l_event_id NUMBER;
51: l_org_id NUMBER;
52: l_security_context xla_events_pub_pkg.t_security;
53: l_reference_info xla_events_pub_pkg.t_event_reference_info;
54: l_category VARCHAR2(30) := NULL;
55: l_occurrence_id NUMBER;
56: l_event_number NUMBER;
57:

Line 157: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );

153: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.entity_type_code = '||l_event_source_info.entity_type_code);
154: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_1 = '||l_event_source_info.source_id_int_1);
155: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_2 = '||l_event_source_info.source_id_int_2);
156: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
157: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
158: END IF;
159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
160: p_event_source_info => l_event_source_info ,
161: p_event_type_code => p_sla_event_type ,

Line 159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

155: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_2 = '||l_event_source_info.source_id_int_2);
156: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
157: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
158: END IF;
159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
160: p_event_source_info => l_event_source_info ,
161: p_event_type_code => p_sla_event_type ,
162: p_event_date => p_event_date ,
163: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 163: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

159: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
160: p_event_source_info => l_event_source_info ,
161: p_event_type_code => p_sla_event_type ,
162: p_event_date => p_event_date ,
163: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
164: p_event_number => 2 ,
165: p_reference_info => l_reference_info ,
166: p_valuation_method => '' ,
167: p_security_context => l_security_context );

Line 170: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );

166: p_valuation_method => '' ,
167: p_security_context => l_security_context );
168:
169: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
170: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );
171: END IF;
172: ELSE
173:
174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 203: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );

199: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.entity_type_code = '||l_event_source_info.entity_type_code);
200: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_1 = '||l_event_source_info.source_id_int_1);
201: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_event_source_info.source_id_int_2 = '||l_event_source_info.source_id_int_2);
202: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
203: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
204: END IF;
205:
206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
207: p_event_source_info => l_event_source_info ,

Line 206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

202: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','l_security_context.security_id_int_1 = '||l_security_context.security_id_int_1);
203: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Calling procedure XLA_EVENTS_PUB_PKG.create_event ' );
204: END IF;
205:
206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
207: p_event_source_info => l_event_source_info ,
208: p_event_type_code => p_sla_event_type ,
209: p_event_date => p_event_date ,
210: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 210: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

206: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
207: p_event_source_info => l_event_source_info ,
208: p_event_type_code => p_sla_event_type ,
209: p_event_date => p_event_date ,
210: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
211: p_event_number => 1 ,
212: p_reference_info => l_reference_info ,
213: p_valuation_method => '' ,
214: p_security_context => l_security_context );

Line 218: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );

214: p_security_context => l_security_context );
215: END IF;
216: --
217: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
218: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Create_SLA_Event','Return l_event_id from XLA_EVENTS_PUB_PKG.create_event '||l_event_id );
219: END IF;
220: return (l_event_id);
221: EXCEPTION
222: WHEN OTHERS THEN