166: x_count := -1;
167: x_err_num := SQLCODE;
168: x_err_code := NULL;
169: x_err_msg := 'CST_Accrual_Rec_PVT.get_accounts() ' || SQLERRM;
170: fnd_message.set_name('BOM','CST_UNEXPECTED');
171: fnd_message.set_token('TOKEN',SQLERRM);
172: if(l_unLog) then
173: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
174: || '(' || to_char(l_stmt_num) || ')', FALSE);
167: x_err_num := SQLCODE;
168: x_err_code := NULL;
169: x_err_msg := 'CST_Accrual_Rec_PVT.get_accounts() ' || SQLERRM;
170: fnd_message.set_name('BOM','CST_UNEXPECTED');
171: fnd_message.set_token('TOKEN',SQLERRM);
172: if(l_unLog) then
173: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
174: || '(' || to_char(l_stmt_num) || ')', FALSE);
175: end if;
305: x_count := fnd_api.g_false;
306: x_err_num := SQLCODE;
307: x_err_code := NULL;
308: x_err_msg := 'CST_Accrual_Rec_PVT.flip_flag() ' || SQLERRM;
309: fnd_message.set_name('BOM','CST_UNEXPECTED');
310: fnd_message.set_token('TOKEN',SQLERRM);
311: if(l_unLog) then
312: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
313: || '(' || to_char(l_stmt_num) || ')', FALSE);
306: x_err_num := SQLCODE;
307: x_err_code := NULL;
308: x_err_msg := 'CST_Accrual_Rec_PVT.flip_flag() ' || SQLERRM;
309: fnd_message.set_name('BOM','CST_UNEXPECTED');
310: fnd_message.set_token('TOKEN',SQLERRM);
311: if(l_unLog) then
312: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
313: || '(' || to_char(l_stmt_num) || ')', FALSE);
314: end if;
436: x_count := -1;
437: x_err_num := SQLCODE;
438: x_err_code := NULL;
439: x_err_msg := 'CST_Accrual_Rec_PVT.calc_age_in_days() ' || SQLERRM;
440: fnd_message.set_name('BOM','CST_UNEXPECTED');
441: fnd_message.set_token('TOKEN',SQLERRM);
442: if(l_unLog) then
443: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
444: || '(' || to_char(l_stmt_num) || ')', FALSE);
437: x_err_num := SQLCODE;
438: x_err_code := NULL;
439: x_err_msg := 'CST_Accrual_Rec_PVT.calc_age_in_days() ' || SQLERRM;
440: fnd_message.set_name('BOM','CST_UNEXPECTED');
441: fnd_message.set_token('TOKEN',SQLERRM);
442: if(l_unLog) then
443: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
444: || '(' || to_char(l_stmt_num) || ')', FALSE);
445: end if;
549: exception
550: when others then
551: --{
552: rollback;
553: fnd_message.set_name('BOM','CST_UNEXPECTED');
554: fnd_message.set_token('TOKEN',SQLERRM);
555: if(l_unLog) then
556: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
557: || '(' || to_char(l_stmt_num) || ')', FALSE);
550: when others then
551: --{
552: rollback;
553: fnd_message.set_name('BOM','CST_UNEXPECTED');
554: fnd_message.set_token('TOKEN',SQLERRM);
555: if(l_unLog) then
556: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
557: || '(' || to_char(l_stmt_num) || ')', FALSE);
558: end if;
664: x_out := -1;
665: x_err_num := SQLCODE;
666: x_err_code := NULL;
667: x_err_msg := 'CST_Accrual_Rec_PVT.update_all() ' || SQLERRM;
668: fnd_message.set_name('BOM','CST_UNEXPECTED');
669: fnd_message.set_token('TOKEN',SQLERRM);
670: if(l_unLog) then
671: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
672: || '(' || to_char(l_stmt_num) || ')', FALSE);
665: x_err_num := SQLCODE;
666: x_err_code := NULL;
667: x_err_msg := 'CST_Accrual_Rec_PVT.update_all() ' || SQLERRM;
668: fnd_message.set_name('BOM','CST_UNEXPECTED');
669: fnd_message.set_token('TOKEN',SQLERRM);
670: if(l_unLog) then
671: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
672: || '(' || to_char(l_stmt_num) || ')', FALSE);
673: end if;
1067: x_count := -1;
1068: x_err_num := SQLCODE;
1069: x_err_code := NULL;
1070: x_err_msg := 'CST_Accrual_Rec_PVT.insert_misc_data_all() ' || SQLERRM;
1071: fnd_message.set_name('BOM','CST_UNEXPECTED');
1072: fnd_message.set_token('TOKEN',SQLERRM);
1073: if(l_unLog) then
1074: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
1075: || '(' || to_char(l_stmt_num) || ')', FALSE);
1068: x_err_num := SQLCODE;
1069: x_err_code := NULL;
1070: x_err_msg := 'CST_Accrual_Rec_PVT.insert_misc_data_all() ' || SQLERRM;
1071: fnd_message.set_name('BOM','CST_UNEXPECTED');
1072: fnd_message.set_token('TOKEN',SQLERRM);
1073: if(l_unLog) then
1074: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
1075: || '(' || to_char(l_stmt_num) || ')', FALSE);
1076: end if;
1530: x_count := -1;
1531: x_err_num := SQLCODE;
1532: x_err_code := NULL;
1533: x_err_msg := 'CST_Accrual_Rec_PVT.insert_appo_data_all() ' || SQLERRM;
1534: fnd_message.set_name('BOM','CST_UNEXPECTED');
1535: fnd_message.set_token('TOKEN',SQLERRM);
1536: if(l_unLog) then
1537: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
1538: || '(' || to_char(l_stmt_num) || ')', FALSE);
1531: x_err_num := SQLCODE;
1532: x_err_code := NULL;
1533: x_err_msg := 'CST_Accrual_Rec_PVT.insert_appo_data_all() ' || SQLERRM;
1534: fnd_message.set_name('BOM','CST_UNEXPECTED');
1535: fnd_message.set_token('TOKEN',SQLERRM);
1536: if(l_unLog) then
1537: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
1538: || '(' || to_char(l_stmt_num) || ')', FALSE);
1539: end if;
1677: x_count := fnd_api.g_false;
1678: x_err_num := SQLCODE;
1679: x_err_code := NULL;
1680: x_err_msg := 'CST_Accrual_Rec_PVT.is_reversible() ' || SQLERRM;
1681: fnd_message.set_name('BOM','CST_UNEXPECTED');
1682: fnd_message.set_token('TOKEN',SQLERRM);
1683: if(l_unLog) then
1684: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
1685: || '(' || to_char(l_stmt_num) || ')', FALSE);
1678: x_err_num := SQLCODE;
1679: x_err_code := NULL;
1680: x_err_msg := 'CST_Accrual_Rec_PVT.is_reversible() ' || SQLERRM;
1681: fnd_message.set_name('BOM','CST_UNEXPECTED');
1682: fnd_message.set_token('TOKEN',SQLERRM);
1683: if(l_unLog) then
1684: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
1685: || '(' || to_char(l_stmt_num) || ')', FALSE);
1686: end if;
2443: x_count := -1;
2444: x_err_num := SQLCODE;
2445: x_err_code := NULL;
2446: x_err_msg := 'CST_Accrual_Rec_PVT.reverse_write_offs() ' || SQLERRM;
2447: fnd_message.set_name('BOM','CST_UNEXPECTED');
2448: fnd_message.set_token('TOKEN',SQLERRM);
2449: if(l_unLog) then
2450: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
2451: || '(' || to_char(l_stmt_num) || ')', FALSE);
2444: x_err_num := SQLCODE;
2445: x_err_code := NULL;
2446: x_err_msg := 'CST_Accrual_Rec_PVT.reverse_write_offs() ' || SQLERRM;
2447: fnd_message.set_name('BOM','CST_UNEXPECTED');
2448: fnd_message.set_token('TOKEN',SQLERRM);
2449: if(l_unLog) then
2450: fnd_log.message(fnd_log.level_unexpected, g_log_header || '.' || l_api_name
2451: || '(' || to_char(l_stmt_num) || ')', FALSE);
2452: end if;