APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_MESSAGE_PKG

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

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

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

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

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

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

Line 360: cn_message_pkg.debug(l_msg_data);

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

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

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

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

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

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

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

Line 480: cn_message_pkg.debug(sqlerrm);

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

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

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

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

683: p_srp_plan_assign_id => p_srp_pe_subledger.srp_plan_assign_id);
684:
685: 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);
686:
687: cn_message_pkg.debug('Last period in the interval is ' || l_max_period_id);
688:
689: -- update cn_srp_period_quotas for the current period.
690:
691: OPEN comm_bonus_cr;

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

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

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

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

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

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

Line 1028: cn_message_pkg.debug(sqlerrm);

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