285:
286: -- Initialize API return status to success
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
290: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
291: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.begin',
292: 'Beginning of update_srp_subledger ...');
293: end if;
286: -- Initialize API return status to success
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
290: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
291: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.begin',
292: 'Beginning of update_srp_subledger ...');
293: end if;
294:
415: end loop;
416:
417: end if;
418:
419: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
420: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
421: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.end',
422: 'End of update_srp_subledger ...');
423: end if;
416:
417: end if;
418:
419: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
420: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
421: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.end',
422: 'End of update_srp_subledger ...');
423: end if;
424:
468: p_data => x_msg_data ,
469: p_encoded => FND_API.G_FALSE
470: );
471:
472: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
473: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
474: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.exception',
475: sqlerrm);
476: end if;
469: p_encoded => FND_API.G_FALSE
470: );
471:
472: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
473: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
474: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.exception',
475: sqlerrm);
476: end if;
477:
664: -- Initialize API return status to success
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666:
667: -- Codes start here
668: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
670: 'cn.plsql.cn_calc_subledger_pvt.update_srp_pe_subledger.begin',
671: 'Beginning of update_srp_pe_subledger (srp_plan_assign_id='
672: ||p_srp_pe_subledger.srp_plan_assign_id|| ' and quota_id='||p_srp_pe_subledger.quota_id);
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666:
667: -- Codes start here
668: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
670: 'cn.plsql.cn_calc_subledger_pvt.update_srp_pe_subledger.begin',
671: 'Beginning of update_srp_pe_subledger (srp_plan_assign_id='
672: ||p_srp_pe_subledger.srp_plan_assign_id|| ' and quota_id='||p_srp_pe_subledger.quota_id);
673: end if;
963: END LOOP;
964: END IF;
965: END LOOP;
966:
967: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
968: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
969: 'cn.plsql.cn_calc_subledger_pvt.update_srp_pe_subledger.end',
970: 'End of update_srp_pe_subledger ...');
971: end if;
964: END IF;
965: END LOOP;
966:
967: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
968: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
969: 'cn.plsql.cn_calc_subledger_pvt.update_srp_pe_subledger.end',
970: 'End of update_srp_pe_subledger ...');
971: end if;
972:
1015: p_data => x_msg_data ,
1016: p_encoded => FND_API.G_FALSE
1017: );
1018:
1019: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1020: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1021: 'cn.plsql.cn_calc_subledger_pvt.update_srp_pe_subledger.exception',
1022: sqlerrm);
1023: end if;
1016: p_encoded => FND_API.G_FALSE
1017: );
1018:
1019: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1020: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1021: 'cn.plsql.cn_calc_subledger_pvt.update_srp_pe_subledger.exception',
1022: sqlerrm);
1023: end if;
1024: