APPS.ARP_ACCT_EVENT_PKG dependencies on STANDARD

Line 19: ARP_STANDARD.DEBUG(message);

15: ELSE
16: FND_FILE.put(fnd_file.log,message);
17: END IF;
18: IF PG_DEBUG = 'Y' THEN
19: ARP_STANDARD.DEBUG(message);
20: END IF;
21: END log;
22:
23: PROCEDURE out(

Line 75: arp_standard.debug(' end date should be greater than the start date');

71: END IF;
72:
73: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
74: IF p_start_date < p_end_date THEN
75: arp_standard.debug(' end date should be greater than the start date');
76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
77: fnd_message.set_token('DATE2', p_end_date);
78: fnd_message.set_token('DATE1', p_start_date);
79: fnd_msg_pub.add;

Line 205: arp_standard.debug('do_on_existing_events+');

201: no_event_found EXCEPTION;
202: ent_ev_no_exist EXCEPTION;
203:
204: BEGIN
205: arp_standard.debug('do_on_existing_events+');
206: arp_standard.debug(' p_trx_number :'||p_trx_number);
207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);
208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);

Line 206: arp_standard.debug(' p_trx_number :'||p_trx_number);

202: ent_ev_no_exist EXCEPTION;
203:
204: BEGIN
205: arp_standard.debug('do_on_existing_events+');
206: arp_standard.debug(' p_trx_number :'||p_trx_number);
207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);
208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);

Line 207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);

203:
204: BEGIN
205: arp_standard.debug('do_on_existing_events+');
206: arp_standard.debug(' p_trx_number :'||p_trx_number);
207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);
208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);

Line 208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);

204: BEGIN
205: arp_standard.debug('do_on_existing_events+');
206: arp_standard.debug(' p_trx_number :'||p_trx_number);
207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);
208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);

Line 209: arp_standard.debug(' p_org_id :'||p_org_id);

205: arp_standard.debug('do_on_existing_events+');
206: arp_standard.debug(' p_trx_number :'||p_trx_number);
207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);
208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);

Line 210: arp_standard.debug(' p_event_id :'||p_event_id);

206: arp_standard.debug(' p_trx_number :'||p_trx_number);
207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);
208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);

Line 211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);

207: arp_standard.debug(' p_legal_entity_id :'||p_legal_entity_id);
208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);

Line 212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);

208: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);
216: arp_standard.debug(' p_event_date :'||p_event_date);

Line 213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);

209: arp_standard.debug(' p_org_id :'||p_org_id);
210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);
216: arp_standard.debug(' p_event_date :'||p_event_date);
217: arp_standard.debug(' p_curr_event_date :'||p_curr_event_date);

Line 214: arp_standard.debug(' p_status :'||p_status);

210: arp_standard.debug(' p_event_id :'||p_event_id);
211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);
216: arp_standard.debug(' p_event_date :'||p_event_date);
217: arp_standard.debug(' p_curr_event_date :'||p_curr_event_date);
218: arp_standard.debug(' p_curr_trx_date :'||p_curr_trx_date);

Line 215: arp_standard.debug(' p_action :'||p_action);

211: arp_standard.debug(' p_valuation_method :'||p_valuation_method);
212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);
216: arp_standard.debug(' p_event_date :'||p_event_date);
217: arp_standard.debug(' p_curr_event_date :'||p_curr_event_date);
218: arp_standard.debug(' p_curr_trx_date :'||p_curr_trx_date);
219:

Line 216: arp_standard.debug(' p_event_date :'||p_event_date);

212: arp_standard.debug(' p_entity_type_code :'||p_entity_type_code);
213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);
216: arp_standard.debug(' p_event_date :'||p_event_date);
217: arp_standard.debug(' p_curr_event_date :'||p_curr_event_date);
218: arp_standard.debug(' p_curr_trx_date :'||p_curr_trx_date);
219:
220: -- get the eve

Line 217: arp_standard.debug(' p_curr_event_date :'||p_curr_event_date);

213: arp_standard.debug(' p_event_type_code :'||p_event_type_code);
214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);
216: arp_standard.debug(' p_event_date :'||p_event_date);
217: arp_standard.debug(' p_curr_event_date :'||p_curr_event_date);
218: arp_standard.debug(' p_curr_trx_date :'||p_curr_trx_date);
219:
220: -- get the eve
221: IF p_ledger_id IS NULL OR p_org_id IS NULL THEN

Line 218: arp_standard.debug(' p_curr_trx_date :'||p_curr_trx_date);

214: arp_standard.debug(' p_status :'||p_status);
215: arp_standard.debug(' p_action :'||p_action);
216: arp_standard.debug(' p_event_date :'||p_event_date);
217: arp_standard.debug(' p_curr_event_date :'||p_curr_event_date);
218: arp_standard.debug(' p_curr_trx_date :'||p_curr_trx_date);
219:
220: -- get the eve
221: IF p_ledger_id IS NULL OR p_org_id IS NULL THEN
222: RAISE not_suffisant_info;

Line 243: arp_standard.debug(' dist_ctlgd_id :'|| l_rec.dist_ctlgd_id );

239:
240: l_security.security_id_int_1 := p_org_id;
241:
242:
243: arp_standard.debug(' dist_ctlgd_id :'|| l_rec.dist_ctlgd_id );
244: arp_standard.debug(' dist_gl_date :'|| l_rec.dist_gl_date );
245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );
246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );

Line 244: arp_standard.debug(' dist_gl_date :'|| l_rec.dist_gl_date );

240: l_security.security_id_int_1 := p_org_id;
241:
242:
243: arp_standard.debug(' dist_ctlgd_id :'|| l_rec.dist_ctlgd_id );
244: arp_standard.debug(' dist_gl_date :'|| l_rec.dist_gl_date );
245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );
246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );

Line 245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );

241:
242:
243: arp_standard.debug(' dist_ctlgd_id :'|| l_rec.dist_ctlgd_id );
244: arp_standard.debug(' dist_gl_date :'|| l_rec.dist_gl_date );
245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );
246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );

Line 246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );

242:
243: arp_standard.debug(' dist_ctlgd_id :'|| l_rec.dist_ctlgd_id );
244: arp_standard.debug(' dist_gl_date :'|| l_rec.dist_gl_date );
245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );
246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );

Line 247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );

243: arp_standard.debug(' dist_ctlgd_id :'|| l_rec.dist_ctlgd_id );
244: arp_standard.debug(' dist_gl_date :'|| l_rec.dist_gl_date );
245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );
246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );

Line 248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );

244: arp_standard.debug(' dist_gl_date :'|| l_rec.dist_gl_date );
245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );
246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );

Line 249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );

245: arp_standard.debug(' dist_account_set_flag :'|| l_rec.dist_account_set_flag );
246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );

Line 250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );

246: arp_standard.debug(' trx_trx_id :'|| l_rec.trx_trx_id );
247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );

Line 251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );

247: arp_standard.debug(' trx_complete_flag :'|| l_rec.trx_complete_flag );
248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );

Line 252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );

248: arp_standard.debug(' trx_trx_date :'|| l_rec.trx_trx_date );
249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );

Line 253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );

249: arp_standard.debug(' trx_invoicing_rule_id :'|| l_rec.trx_invoicing_rule_id );
250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );
257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );

Line 254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );

250: arp_standard.debug(' trx_post_to_gl :'|| l_rec.trx_post_to_gl );
251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );
257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );
258: arp_standard.debug(' dist_event_date :'|| l_rec.dist_event_date );

Line 255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );

251: arp_standard.debug(' ent_entity_id :'|| l_rec.ent_entity_id );
252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );
257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );
258: arp_standard.debug(' dist_event_date :'|| l_rec.dist_event_date );
259: arp_standard.debug(' dist_ev_trx_date :'|| l_rec.dist_ev_trx_date );

Line 256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );

252: arp_standard.debug(' trx_event_id :'|| l_rec.trx_event_id );
253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );
257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );
258: arp_standard.debug(' dist_event_date :'|| l_rec.dist_event_date );
259: arp_standard.debug(' dist_ev_trx_date :'|| l_rec.dist_ev_trx_date );
260:

Line 257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );

253: arp_standard.debug(' trx_event_date :'|| l_rec.trx_event_date );
254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );
257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );
258: arp_standard.debug(' dist_event_date :'|| l_rec.dist_event_date );
259: arp_standard.debug(' dist_ev_trx_date :'|| l_rec.dist_ev_trx_date );
260:
261:

Line 258: arp_standard.debug(' dist_event_date :'|| l_rec.dist_event_date );

254: arp_standard.debug(' trx_event_status :'|| l_rec.trx_event_status );
255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );
257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );
258: arp_standard.debug(' dist_event_date :'|| l_rec.dist_event_date );
259: arp_standard.debug(' dist_ev_trx_date :'|| l_rec.dist_ev_trx_date );
260:
261:
262: IF l_rec.dist_account_set_flag = 'Y' THEN

Line 259: arp_standard.debug(' dist_ev_trx_date :'|| l_rec.dist_ev_trx_date );

255: arp_standard.debug(' trx_ev_trx_date :'|| l_rec.trx_ev_trx_date );
256: arp_standard.debug(' dist_event_id :'|| l_rec.dist_event_id );
257: arp_standard.debug(' dist_event_status :'|| l_rec.dist_event_status );
258: arp_standard.debug(' dist_event_date :'|| l_rec.dist_event_date );
259: arp_standard.debug(' dist_ev_trx_date :'|| l_rec.dist_ev_trx_date );
260:
261:
262: IF l_rec.dist_account_set_flag = 'Y' THEN
263: --

Line 313: arp_standard.debug(' call update event with at transaction level');

309:
310:
311:
312: IF l_upg_trx_date <> FND_API.G_MISS_DATE OR l_upg_gl_date <> FND_API.G_MISS_DATE THEN
313: arp_standard.debug(' call update event with at transaction level');
314: xla_events_pub_pkg.update_event
315: (p_event_source_info => l_event_source_info,
316: p_event_id => l_event_id,
317: p_event_date => p_event_date,

Line 323: arp_standard.debug('do_on_existing_events-');

319: p_transaction_date => p_transaction_date,
320: p_security_context => l_security);
321: END IF;
322:
323: arp_standard.debug('do_on_existing_events-');
324:
325: EXCEPTION
326: WHEN ent_ev_no_exist THEN
327: arp_standard.debug(' EXCEPTION ent_ev_no_exist - no event update required');

Line 327: arp_standard.debug(' EXCEPTION ent_ev_no_exist - no event update required');

323: arp_standard.debug('do_on_existing_events-');
324:
325: EXCEPTION
326: WHEN ent_ev_no_exist THEN
327: arp_standard.debug(' EXCEPTION ent_ev_no_exist - no event update required');
328: WHEN no_event_found THEN
329: arp_standard.debug(' EXCEPTION no_event_found - no event update required');
330: WHEN more_than_one_event THEN
331: arp_standard.debug(' EXCEPTION more_than_one_event can not update');

Line 329: arp_standard.debug(' EXCEPTION no_event_found - no event update required');

325: EXCEPTION
326: WHEN ent_ev_no_exist THEN
327: arp_standard.debug(' EXCEPTION ent_ev_no_exist - no event update required');
328: WHEN no_event_found THEN
329: arp_standard.debug(' EXCEPTION no_event_found - no event update required');
330: WHEN more_than_one_event THEN
331: arp_standard.debug(' EXCEPTION more_than_one_event can not update');
332: WHEN not_suffisant_info THEN
333: arp_standard.debug(' EXCEPTION not_suffisant_info do_on_existing_events has done nothing');

Line 331: arp_standard.debug(' EXCEPTION more_than_one_event can not update');

327: arp_standard.debug(' EXCEPTION ent_ev_no_exist - no event update required');
328: WHEN no_event_found THEN
329: arp_standard.debug(' EXCEPTION no_event_found - no event update required');
330: WHEN more_than_one_event THEN
331: arp_standard.debug(' EXCEPTION more_than_one_event can not update');
332: WHEN not_suffisant_info THEN
333: arp_standard.debug(' EXCEPTION not_suffisant_info do_on_existing_events has done nothing');
334: WHEN done THEN
335: arp_standard.debug(' do_on_existing_events has done '||p_action);

Line 333: arp_standard.debug(' EXCEPTION not_suffisant_info do_on_existing_events has done nothing');

329: arp_standard.debug(' EXCEPTION no_event_found - no event update required');
330: WHEN more_than_one_event THEN
331: arp_standard.debug(' EXCEPTION more_than_one_event can not update');
332: WHEN not_suffisant_info THEN
333: arp_standard.debug(' EXCEPTION not_suffisant_info do_on_existing_events has done nothing');
334: WHEN done THEN
335: arp_standard.debug(' do_on_existing_events has done '||p_action);
336: arp_standard.debug('do_on_existing_events has done -');
337: WHEN not_supported_action THEN

Line 335: arp_standard.debug(' do_on_existing_events has done '||p_action);

331: arp_standard.debug(' EXCEPTION more_than_one_event can not update');
332: WHEN not_suffisant_info THEN
333: arp_standard.debug(' EXCEPTION not_suffisant_info do_on_existing_events has done nothing');
334: WHEN done THEN
335: arp_standard.debug(' do_on_existing_events has done '||p_action);
336: arp_standard.debug('do_on_existing_events has done -');
337: WHEN not_supported_action THEN
338: arp_standard.debug(' EXCEPTION not_supported_action do_on_existing_events '||p_action);
339: END;

Line 336: arp_standard.debug('do_on_existing_events has done -');

332: WHEN not_suffisant_info THEN
333: arp_standard.debug(' EXCEPTION not_suffisant_info do_on_existing_events has done nothing');
334: WHEN done THEN
335: arp_standard.debug(' do_on_existing_events has done '||p_action);
336: arp_standard.debug('do_on_existing_events has done -');
337: WHEN not_supported_action THEN
338: arp_standard.debug(' EXCEPTION not_supported_action do_on_existing_events '||p_action);
339: END;
340:

Line 338: arp_standard.debug(' EXCEPTION not_supported_action do_on_existing_events '||p_action);

334: WHEN done THEN
335: arp_standard.debug(' do_on_existing_events has done '||p_action);
336: arp_standard.debug('do_on_existing_events has done -');
337: WHEN not_supported_action THEN
338: arp_standard.debug(' EXCEPTION not_supported_action do_on_existing_events '||p_action);
339: END;
340:
341:
342:

Line 348: arp_standard.debug('get_ar_trx_event_info +');

344: (p_entity_code IN VARCHAR2,
345: p_source_int_id IN NUMBER)
346: IS
347: BEGIN
348: arp_standard.debug('get_ar_trx_event_info +');
349: IF p_entity_code = 'TRANSACTIONS' THEN
350: --
351: -- If the transaction is rule based then no records will be inserted by
352: -- by this statement if REVREC has not run.

Line 450: arp_standard.debug('get_ar_trx_event_info -');

446: WHERE customer_trx_id = p_source_int_id;
447:
448:
449: END IF;
450: arp_standard.debug('get_ar_trx_event_info -');
451: END;
452:
453:
454:

Line 461: arp_standard.debug('get_xla_event_info +');

457: (p_entity_code IN VARCHAR2,
458: p_source_int_id IN NUMBER)
459: IS
460: BEGIN
461: arp_standard.debug('get_xla_event_info +');
462: arp_standard.debug(' p_entity_code :'||p_entity_code);
463: arp_standard.debug(' p_source_int_id :'||p_source_int_id);
464:
465: INSERT INTO ar_detect_gt(gl_date ,

Line 462: arp_standard.debug(' p_entity_code :'||p_entity_code);

458: p_source_int_id IN NUMBER)
459: IS
460: BEGIN
461: arp_standard.debug('get_xla_event_info +');
462: arp_standard.debug(' p_entity_code :'||p_entity_code);
463: arp_standard.debug(' p_source_int_id :'||p_source_int_id);
464:
465: INSERT INTO ar_detect_gt(gl_date ,
466: source_int_id ,

Line 463: arp_standard.debug(' p_source_int_id :'||p_source_int_id);

459: IS
460: BEGIN
461: arp_standard.debug('get_xla_event_info +');
462: arp_standard.debug(' p_entity_code :'||p_entity_code);
463: arp_standard.debug(' p_source_int_id :'||p_source_int_id);
464:
465: INSERT INTO ar_detect_gt(gl_date ,
466: source_int_id ,
467: entity_code ,

Line 484: arp_standard.debug('get_xla_event_info -');

480: AND nvl(t.source_id_int_1,-99) = p_source_int_id
481: AND t.entity_id = e.entity_id
482: AND e.application_id = 222;
483:
484: arp_standard.debug('get_xla_event_info -');
485: END;
486:
487:
488: PROCEDURE ar_event_existence

Line 503: arp_standard.debug('ar_event_existence +');

499: AND event_id IS NULL;
500:
501: l_date DATE;
502: BEGIN
503: arp_standard.debug('ar_event_existence +');
504: arp_standard.debug(' p_entity_code :'||p_entity_code);
505: arp_standard.debug(' p_source_int_id :'||p_source_int_id);
506: OPEN c;
507: FETCH c INTO l_date;

Line 504: arp_standard.debug(' p_entity_code :'||p_entity_code);

500:
501: l_date DATE;
502: BEGIN
503: arp_standard.debug('ar_event_existence +');
504: arp_standard.debug(' p_entity_code :'||p_entity_code);
505: arp_standard.debug(' p_source_int_id :'||p_source_int_id);
506: OPEN c;
507: FETCH c INTO l_date;
508: IF c%NOTFOUND THEN

Line 505: arp_standard.debug(' p_source_int_id :'||p_source_int_id);

501: l_date DATE;
502: BEGIN
503: arp_standard.debug('ar_event_existence +');
504: arp_standard.debug(' p_entity_code :'||p_entity_code);
505: arp_standard.debug(' p_source_int_id :'||p_source_int_id);
506: OPEN c;
507: FETCH c INTO l_date;
508: IF c%NOTFOUND THEN
509: x_result := 'Y';

Line 514: arp_standard.debug(' x_result :'||x_result);

510: ELSE
511: x_result := 'N';
512: END IF;
513: CLOSE c;
514: arp_standard.debug(' x_result :'||x_result);
515: arp_standard.debug('ar_event_existence -');
516: END;
517:
518:

Line 515: arp_standard.debug('ar_event_existence -');

511: x_result := 'N';
512: END IF;
513: CLOSE c;
514: arp_standard.debug(' x_result :'||x_result);
515: arp_standard.debug('ar_event_existence -');
516: END;
517:
518:
519:

Line 540: arp_standard.debug('ar_xla_all_match_exist +');

536: AND a2.from_application = 'XLA'
537: AND a2.gl_date = a1.gl_date);
538: l_date DATE;
539: BEGIN
540: arp_standard.debug('ar_xla_all_match_exist +');
541: OPEN c;
542: FETCH c INTO l_date;
543: IF c%NOTFOUND THEN
544: x_result := 'Y';

Line 549: arp_standard.debug(' l_date :'||l_date);

545: ELSE
546: x_result := 'N';
547: END IF;
548: CLOSE c;
549: arp_standard.debug(' l_date :'||l_date);
550: arp_standard.debug(' x_result :'||x_result);
551: arp_standard.debug('ar_xla_all_match_exist -');
552: END;
553:

Line 550: arp_standard.debug(' x_result :'||x_result);

546: x_result := 'N';
547: END IF;
548: CLOSE c;
549: arp_standard.debug(' l_date :'||l_date);
550: arp_standard.debug(' x_result :'||x_result);
551: arp_standard.debug('ar_xla_all_match_exist -');
552: END;
553:
554:

Line 551: arp_standard.debug('ar_xla_all_match_exist -');

547: END IF;
548: CLOSE c;
549: arp_standard.debug(' l_date :'||l_date);
550: arp_standard.debug(' x_result :'||x_result);
551: arp_standard.debug('ar_xla_all_match_exist -');
552: END;
553:
554:
555:

Line 569: arp_standard.debug('upgrade_status_per_doc +');

565: IS
566: x_result VARCHAR2(30);
567: end_execution EXCEPTION;
568: BEGIN
569: arp_standard.debug('upgrade_status_per_doc +');
570: arp_standard.debug(' p_entity_code :'||p_entity_code);
571: arp_standard.debug(' p_source_int_id:'||p_source_int_id);
572: x_return_status := fnd_api.g_ret_sts_success;
573:

Line 570: arp_standard.debug(' p_entity_code :'||p_entity_code);

566: x_result VARCHAR2(30);
567: end_execution EXCEPTION;
568: BEGIN
569: arp_standard.debug('upgrade_status_per_doc +');
570: arp_standard.debug(' p_entity_code :'||p_entity_code);
571: arp_standard.debug(' p_source_int_id:'||p_source_int_id);
572: x_return_status := fnd_api.g_ret_sts_success;
573:
574: -- initialize message list if p_init_msg_list is set to TRUE.

Line 571: arp_standard.debug(' p_source_int_id:'||p_source_int_id);

567: end_execution EXCEPTION;
568: BEGIN
569: arp_standard.debug('upgrade_status_per_doc +');
570: arp_standard.debug(' p_entity_code :'||p_entity_code);
571: arp_standard.debug(' p_source_int_id:'||p_source_int_id);
572: x_return_status := fnd_api.g_ret_sts_success;
573:
574: -- initialize message list if p_init_msg_list is set to TRUE.
575: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 583: arp_standard.debug('Value for entity code should be TRANSACTIONS RECEIPTS ADJUSTMENTS BILLS_RECEIVABLE');

579: IF p_entity_code NOT IN
580: ('TRANSACTIONS','RECEIPTS',
581: 'ADJUSTMENTS', 'BILLS_RECEIVABLE')
582: THEN
583: arp_standard.debug('Value for entity code should be TRANSACTIONS RECEIPTS ADJUSTMENTS BILLS_RECEIVABLE');
584: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
585: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'ENTITY_CODE' );
586: FND_MESSAGE.SET_TOKEN( 'VALUES', 'TRANSACTIONS,RECEIPTS,ADJUSTMENTS,BILLS_RECEIVABLE');
587: FND_MSG_PUB.ADD;

Line 629: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);

625: ELSE
626: x_upgrade_status := 'N';
627: END IF;
628:
629: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);
630: arp_standard.debug('upgrade_status_per_doc -');
631: EXCEPTION
632: WHEN end_execution THEN
633: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);

Line 630: arp_standard.debug('upgrade_status_per_doc -');

626: x_upgrade_status := 'N';
627: END IF;
628:
629: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);
630: arp_standard.debug('upgrade_status_per_doc -');
631: EXCEPTION
632: WHEN end_execution THEN
633: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);
634: WHEN fnd_api.G_EXC_ERROR THEN

Line 633: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);

629: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);
630: arp_standard.debug('upgrade_status_per_doc -');
631: EXCEPTION
632: WHEN end_execution THEN
633: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);
634: WHEN fnd_api.G_EXC_ERROR THEN
635: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
636: p_count => x_msg_count,
637: p_data => x_msg_data);

Line 639: arp_standard.debug('EXCEPTION OTHERS in upgrade_status_per_doc:'||SQLERRM);

635: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
636: p_count => x_msg_count,
637: p_data => x_msg_data);
638: WHEN OTHERS THEN
639: arp_standard.debug('EXCEPTION OTHERS in upgrade_status_per_doc:'||SQLERRM);
640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
642: fnd_message.set_token('ERROR' ,SQLERRM);
643: fnd_msg_pub.add;

Line 1408: arp_standard.debug('update_cr_dist +');

1404: creation_mode EXCEPTION;
1405: no_existing_account EXCEPTION;
1406: nullify_customer EXCEPTION;
1407: BEGIN
1408: arp_standard.debug('update_cr_dist +');
1409: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);
1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);

Line 1409: arp_standard.debug(' p_ledger_id :'||p_ledger_id);

1405: no_existing_account EXCEPTION;
1406: nullify_customer EXCEPTION;
1407: BEGIN
1408: arp_standard.debug('update_cr_dist +');
1409: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);
1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);

Line 1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);

1406: nullify_customer EXCEPTION;
1407: BEGIN
1408: arp_standard.debug('update_cr_dist +');
1409: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);
1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);

Line 1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);

1407: BEGIN
1408: arp_standard.debug('update_cr_dist +');
1409: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);
1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);

Line 1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);

1408: arp_standard.debug('update_cr_dist +');
1409: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);
1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);

Line 1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);

1409: arp_standard.debug(' p_ledger_id :'||p_ledger_id);
1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);
1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);

Line 1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);

1410: arp_standard.debug(' p_source_id_int_1 :'||p_source_id_int_1);
1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);

Line 1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);

1411: arp_standard.debug(' p_original_third_party_id:'||p_original_third_party_id);
1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);

Line 1416: arp_standard.debug(' p_create_update :'||p_create_update);

1412: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);

Line 1417: arp_standard.debug(' p_entity_code :'||p_entity_code);

1413: arp_standard.debug(' p_new_third_party_id :'||p_new_third_party_id);
1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);

Line 1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);

1414: arp_standard.debug(' p_original_site_id :'||p_original_site_id);
1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);
1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);

Line 1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);

1415: arp_standard.debug(' p_third_party_merge_date :'||p_third_party_merge_date);
1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);
1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);
1423: arp_standard.debug(' p_post_in_gl_flag :'||p_post_in_gl_flag);

Line 1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);

1416: arp_standard.debug(' p_create_update :'||p_create_update);
1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);
1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);
1423: arp_standard.debug(' p_post_in_gl_flag :'||p_post_in_gl_flag);
1424: arp_standard.debug(' p_third_party_type :'||p_third_party_type);

Line 1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);

1417: arp_standard.debug(' p_entity_code :'||p_entity_code);
1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);
1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);
1423: arp_standard.debug(' p_post_in_gl_flag :'||p_post_in_gl_flag);
1424: arp_standard.debug(' p_third_party_type :'||p_third_party_type);
1425:

Line 1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);

1418: arp_standard.debug(' p_type_of_third_party_merge:'||p_type_of_third_party_merge);
1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);
1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);
1423: arp_standard.debug(' p_post_in_gl_flag :'||p_post_in_gl_flag);
1424: arp_standard.debug(' p_third_party_type :'||p_third_party_type);
1425:
1426: -- No need to create a merge event in creation mode

Line 1423: arp_standard.debug(' p_post_in_gl_flag :'||p_post_in_gl_flag);

1419: arp_standard.debug(' p_mapping_flag :'||p_mapping_flag);
1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);
1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);
1423: arp_standard.debug(' p_post_in_gl_flag :'||p_post_in_gl_flag);
1424: arp_standard.debug(' p_third_party_type :'||p_third_party_type);
1425:
1426: -- No need to create a merge event in creation mode
1427: IF p_create_update = 'C' THEN

Line 1424: arp_standard.debug(' p_third_party_type :'||p_third_party_type);

1420: arp_standard.debug(' p_execution_mode :'||p_execution_mode);
1421: arp_standard.debug(' p_accounting_mode :'||p_accounting_mode);
1422: arp_standard.debug(' p_transfer_to_gl_flag :'||p_transfer_to_gl_flag);
1423: arp_standard.debug(' p_post_in_gl_flag :'||p_post_in_gl_flag);
1424: arp_standard.debug(' p_third_party_type :'||p_third_party_type);
1425:
1426: -- No need to create a merge event in creation mode
1427: IF p_create_update = 'C' THEN
1428: arp_standard.debug('Creation mode');

Line 1428: arp_standard.debug('Creation mode');

1424: arp_standard.debug(' p_third_party_type :'||p_third_party_type);
1425:
1426: -- No need to create a merge event in creation mode
1427: IF p_create_update = 'C' THEN
1428: arp_standard.debug('Creation mode');
1429: RAISE creation_mode;
1430: END IF;
1431:
1432: -- This is when the receipt has been created a unidentified

Line 1434: arp_standard.debug('No original account');

1430: END IF;
1431:
1432: -- This is when the receipt has been created a unidentified
1433: IF p_original_third_party_id IS NULL THEN
1434: arp_standard.debug('No original account');
1435: RAISE no_existing_account;
1436: END IF;
1437:
1438: -- This is when user null out the customer on the receipt

Line 1502: arp_standard.debug('update_cr_dist -');

1498: END IF;
1499:
1500: END IF;
1501:
1502: arp_standard.debug('update_cr_dist -');
1503:
1504: EXCEPTION
1505:
1506: WHEN creation_mode THEN

Line 1507: arp_standard.debug('EXCEPTION creation_mode : CREATION MODE');

1503:
1504: EXCEPTION
1505:
1506: WHEN creation_mode THEN
1507: arp_standard.debug('EXCEPTION creation_mode : CREATION MODE');
1508: x_errbuf := 'CREATION MODE';
1509: x_retcode := 'S';
1510: arp_standard.debug('update_cr_dist -');
1511:

Line 1510: arp_standard.debug('update_cr_dist -');

1506: WHEN creation_mode THEN
1507: arp_standard.debug('EXCEPTION creation_mode : CREATION MODE');
1508: x_errbuf := 'CREATION MODE';
1509: x_retcode := 'S';
1510: arp_standard.debug('update_cr_dist -');
1511:
1512: WHEN no_existing_account THEN
1513: arp_standard.debug('EXCEPTION no_existing_account : NO ORIGINAL CUSTOMER');
1514: x_errbuf := 'NO ORIGINAL CUSTOMER';

Line 1513: arp_standard.debug('EXCEPTION no_existing_account : NO ORIGINAL CUSTOMER');

1509: x_retcode := 'S';
1510: arp_standard.debug('update_cr_dist -');
1511:
1512: WHEN no_existing_account THEN
1513: arp_standard.debug('EXCEPTION no_existing_account : NO ORIGINAL CUSTOMER');
1514: x_errbuf := 'NO ORIGINAL CUSTOMER';
1515: x_retcode := 'S';
1516: arp_standard.debug('update_cr_dist -');
1517:

Line 1516: arp_standard.debug('update_cr_dist -');

1512: WHEN no_existing_account THEN
1513: arp_standard.debug('EXCEPTION no_existing_account : NO ORIGINAL CUSTOMER');
1514: x_errbuf := 'NO ORIGINAL CUSTOMER';
1515: x_retcode := 'S';
1516: arp_standard.debug('update_cr_dist -');
1517:
1518: WHEN OTHERS THEN
1519: arp_standard.debug('EXCEPTION OTHERS :'||SQLERRM);
1520: x_errbuf := 'SQLERRM';

Line 1519: arp_standard.debug('EXCEPTION OTHERS :'||SQLERRM);

1515: x_retcode := 'S';
1516: arp_standard.debug('update_cr_dist -');
1517:
1518: WHEN OTHERS THEN
1519: arp_standard.debug('EXCEPTION OTHERS :'||SQLERRM);
1520: x_errbuf := 'SQLERRM';
1521: x_retcode := 'U';
1522:
1523: END;

Line 1553: arp_standard.debug('check_period_open +');

1549: AND glp.closing_status IN ('O','F'));
1550:
1551: l_date DATE;
1552: BEGIN
1553: arp_standard.debug('check_period_open +');
1554: x_return_status := FND_API.g_ret_sts_success;
1555:
1556: OPEN c_verif_date(p_entity_id);
1557: FETCH c_verif_date INTO l_date;

Line 1560: arp_standard.debug(' event_date :' || l_date);

1556: OPEN c_verif_date(p_entity_id);
1557: FETCH c_verif_date INTO l_date;
1558: IF c_verif_date%FOUND THEN
1559: x_return_status := FND_API.g_ret_sts_error;
1560: arp_standard.debug(' event_date :' || l_date);
1561: FND_MESSAGE.SET_NAME('AR','AR_NOT_OPEN_PERIOD_EXISTS');
1562: FND_MSG_PUB.ADD; --BUG#5386043
1563: END IF;
1564: CLOSE c_verif_date;

Line 1569: arp_standard.debug('check_period_open -');

1565:
1566: IF x_return_status <> FND_API.g_ret_sts_success THEN
1567: RAISE fnd_api.G_EXC_ERROR;
1568: END IF;
1569: arp_standard.debug('check_period_open -');
1570: EXCEPTION
1571: WHEN fnd_api.G_EXC_ERROR THEN
1572: arp_standard.debug('EXCEPTION G_EXC_ERROR');
1573: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1572: arp_standard.debug('EXCEPTION G_EXC_ERROR');

1568: END IF;
1569: arp_standard.debug('check_period_open -');
1570: EXCEPTION
1571: WHEN fnd_api.G_EXC_ERROR THEN
1572: arp_standard.debug('EXCEPTION G_EXC_ERROR');
1573: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data);
1576: WHEN OTHERS THEN

Line 1577: arp_standard.debug('EXCEPTION OTHERS:'|| SQLERRM);

1573: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data);
1576: WHEN OTHERS THEN
1577: arp_standard.debug('EXCEPTION OTHERS:'|| SQLERRM);
1578: x_return_status := FND_API.g_ret_sts_error;
1579: x_msg_data := SQLERRM;
1580: x_msg_count := 1;
1581: END;