APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_MESSAGE_PKG

Line 297: cn_message_pkg.debug('Start updating payment subledgers ... ');

293: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.begin',
294: 'Beginning of update_srp_subledger ...');
295: end if;
296:
297: cn_message_pkg.debug('Start updating payment subledgers ... ');
298:
299: -- Code starts here
300: select org_id into g_org_id
301: from cn_process_batches_all

Line 316: cn_message_pkg.debug('Updating balances for rep (ID='||l_salesrep_id||')');

312: l_start_date := l_salesrep.start_date;
313: l_end_date := l_salesrep.end_date;
314: sync_needed := false;
315:
316: cn_message_pkg.debug('Updating balances for rep (ID='||l_salesrep_id||')');
317: FOR l_subledger IN subledger_cr(l_salesrep.period_id, l_salesrep.end_period_id) LOOP
318: l_period_id := l_subledger.period_id;
319: l_role_id := l_subledger.role_id;
320: l_quota_id := l_subledger.quota_id;

Line 361: cn_message_pkg.debug('Exception occurs in cn_srp_periods_pvt.update_delta_srp_periods:');

357: p_del_srp_prd_rec => l_delta_subledger,
358: x_loading_status => l_loading_status
359: );
360: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
361: cn_message_pkg.debug('Exception occurs in cn_srp_periods_pvt.update_delta_srp_periods:');
362: cn_message_pkg.debug(l_msg_data);
363: raise FND_API.g_exc_error;
364: end if;
365:

Line 362: cn_message_pkg.debug(l_msg_data);

358: x_loading_status => l_loading_status
359: );
360: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
361: cn_message_pkg.debug('Exception occurs in cn_srp_periods_pvt.update_delta_srp_periods:');
362: cn_message_pkg.debug(l_msg_data);
363: raise FND_API.g_exc_error;
364: end if;
365:
366: if sync_needed = false then

Line 380: cn_message_pkg.debug('Synchonizing balances for salesrep (salesrep_id='||l_salesrep_id ||

376: if sync_needed then
377: -- loop through all roles and credit types to be updated
378: for r in get_distinct_roles loop
379: if r.role_id <> G_PAYEE_ROLE then
380: cn_message_pkg.debug('Synchonizing balances for salesrep (salesrep_id='||l_salesrep_id ||
381: ' role_id=' || r.role_id || ' start_period_id=' || l_start_period_id||')');
382:
383: CN_SRP_PERIODS_PVT.Sync_Accum_Balances_Start_Pd
384: (p_salesrep_id => l_salesrep_id,

Line 432: cn_message_pkg.debug('Finish updating payment subledgers ');

428: IF FND_API.To_Boolean( p_commit ) THEN
429: COMMIT WORK;
430: END IF;
431:
432: cn_message_pkg.debug('Finish updating payment subledgers ');
433:
434: -- Standard call to get message count and if count is 1, get message info.
435: FND_MSG_PUB.Count_And_Get
436: ( p_count => x_msg_count ,

Line 481: cn_message_pkg.debug('Exception occurs in cn_calc_subledger_pvt.update_srp_subledger: ');

477: sqlerrm);
478: end if;
479:
480: fnd_file.put_line(fnd_file.log, 'EXCEPTION in update_srp_subledger: '||sqlerrm);
481: cn_message_pkg.debug('Exception occurs in cn_calc_subledger_pvt.update_srp_subledger: ');
482: cn_message_pkg.debug(sqlerrm);
483: END update_srp_subledger;
484:
485: -- API name : update_srp_pe_subledger

Line 482: cn_message_pkg.debug(sqlerrm);

478: end if;
479:
480: fnd_file.put_line(fnd_file.log, 'EXCEPTION in update_srp_subledger: '||sqlerrm);
481: cn_message_pkg.debug('Exception occurs in cn_calc_subledger_pvt.update_srp_subledger: ');
482: cn_message_pkg.debug(sqlerrm);
483: END update_srp_subledger;
484:
485: -- API name : update_srp_pe_subledger
486: -- Type : Private.

Line 647: cn_message_pkg.debug('Start updating calculation subledgers ... ');

643:
644: l_sql_stmt VARCHAR2(2000);
645: BEGIN
646:
647: cn_message_pkg.debug('Start updating calculation subledgers ... ');
648:
649: -- Standard Start of API savepoint
650: SAVEPOINT update_srp_pe_subledger;
651:

Line 689: cn_message_pkg.debug('Last period in the interval is ' || l_max_period_id);

685: p_srp_plan_assign_id => p_srp_pe_subledger.srp_plan_assign_id);
686:
687: l_start_period_id := cn_formula_common_pkg.get_start_period_id(p_srp_pe_subledger.quota_id, p_srp_pe_subledger.accu_period_id);
688:
689: cn_message_pkg.debug('Last period in the interval is ' || l_max_period_id);
690:
691: -- update cn_srp_period_quotas for the current period.
692:
693: OPEN comm_bonus_cr;

Line 698: cn_message_pkg.debug('No commission lines');

694: FETCH comm_bonus_cr INTO comm_bonus;
695:
696: IF (comm_bonus_cr%notfound) THEN
697:
698: cn_message_pkg.debug('No commission lines');
699:
700: END IF;
701:
702: IF p_mode = 'A' THEN

Line 987: cn_message_pkg.debug('Finish updating calculation subledgers ');

983: ( p_count => x_msg_count ,
984: p_data => x_msg_data ,
985: p_encoded => FND_API.G_FALSE
986: );
987: cn_message_pkg.debug('Finish updating calculation subledgers ');
988: EXCEPTION
989:
990: WHEN FND_API.G_EXC_ERROR THEN
991: ROLLBACK TO update_srp_pe_subledger;

Line 1029: cn_message_pkg.debug('Exception occurs in update_srp_pe_subledger: ');

1025: end if;
1026:
1027: fnd_file.put_line(fnd_file.log, 'EXCEPTION in update_srp_pe_subledger: '||sqlerrm);
1028:
1029: cn_message_pkg.debug('Exception occurs in update_srp_pe_subledger: ');
1030: cn_message_pkg.debug(sqlerrm);
1031:
1032: END update_srp_pe_subledger;
1033:

Line 1030: cn_message_pkg.debug(sqlerrm);

1026:
1027: fnd_file.put_line(fnd_file.log, 'EXCEPTION in update_srp_pe_subledger: '||sqlerrm);
1028:
1029: cn_message_pkg.debug('Exception occurs in update_srp_pe_subledger: ');
1030: cn_message_pkg.debug(sqlerrm);
1031:
1032: END update_srp_pe_subledger;
1033:
1034: