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 167: 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 ' );

163: 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);
164: 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);
165: 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);
166: 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);
167: 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 ' );
168: END IF;
169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
170: p_event_source_info => l_event_source_info ,
171: p_event_type_code => p_sla_event_type ,

Line 169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

165: 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);
166: 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);
167: 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 ' );
168: END IF;
169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
170: p_event_source_info => l_event_source_info ,
171: p_event_type_code => p_sla_event_type ,
172: p_event_date => p_event_date ,
173: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 173: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

169: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
170: p_event_source_info => l_event_source_info ,
171: p_event_type_code => p_sla_event_type ,
172: p_event_date => p_event_date ,
173: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
174: p_event_number => 2 ,
175: p_reference_info => l_reference_info ,
176: p_valuation_method => '' ,
177: p_security_context => l_security_context );

Line 180: 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 );

176: p_valuation_method => '' ,
177: p_security_context => l_security_context );
178:
179: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
180: 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 );
181: END IF;
182: /* ############### ELSE PART ############################# */
183: ELSE
184:

Line 214: 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 ' );

210: 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);
211: 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);
212: 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);
213: 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);
214: 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 ' );
215: END IF;
216:
217:
218:

Line 219: l_event_id := XLA_EVENTS_PUB_PKG.create_event(

215: END IF;
216:
217:
218:
219: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
220: p_event_source_info => l_event_source_info ,
221: p_event_type_code => p_sla_event_type ,
222: p_event_date => p_event_date ,
223: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

Line 223: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,

219: l_event_id := XLA_EVENTS_PUB_PKG.create_event(
220: p_event_source_info => l_event_source_info ,
221: p_event_type_code => p_sla_event_type ,
222: p_event_date => p_event_date ,
223: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED ,
224: p_event_number => 1 ,
225: p_reference_info => l_reference_info ,
226: p_valuation_method => '' ,
227: p_security_context => l_security_context );

Line 233: 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 );

229:
230: /* ############### END IF ############################# */
231: --
232: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
233: 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 );
234: END IF;
235: return (l_event_id);
236: EXCEPTION
237: WHEN OTHERS THEN