104:
105:
106:
107: EXCEPTION
108: when FND_API.G_EXC_ERROR then
109: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_catch_all_bin_information '||SQLERRM);
110: RETURN;
111: when FND_API.G_EXC_UNEXPECTED_ERROR then
112: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
107: EXCEPTION
108: when FND_API.G_EXC_ERROR then
109: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_catch_all_bin_information '||SQLERRM);
110: RETURN;
111: when FND_API.G_EXC_UNEXPECTED_ERROR then
112: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
113: RETURN;
114: when others then
115: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
172: and jtabs.terr_group_id = tot.terr_group_id );
173:
174:
175: EXCEPTION
176: when FND_API.G_EXC_ERROR then
177: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_kpi_bin_information '||SQLERRM);
178: RETURN;
179: when FND_API.G_EXC_UNEXPECTED_ERROR then
180: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
175: EXCEPTION
176: when FND_API.G_EXC_ERROR then
177: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_kpi_bin_information '||SQLERRM);
178: RETURN;
179: when FND_API.G_EXC_UNEXPECTED_ERROR then
180: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
181: RETURN;
182: when others then
183: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
257:
258: COMMIT;
259:
260: EXCEPTION
261: when FND_API.G_EXC_ERROR then
262: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
263: RETURN;
264: when FND_API.G_EXC_UNEXPECTED_ERROR then
265: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
260: EXCEPTION
261: when FND_API.G_EXC_ERROR then
262: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
263: RETURN;
264: when FND_API.G_EXC_UNEXPECTED_ERROR then
265: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
266: RETURN;
267: when others then
268: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );