65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
69: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_ERROR'); htp.para;
70: END IF;
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
70: END IF;
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
74: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
75: END IF;
76: WHEN OTHERS THEN
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: l_error_tbl := x_error_Tbl;
82: , p_error_description => SQLERRM
83: , x_error_table => x_error_Tbl
84: );
85: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
86: htp.p('BIS_TARGET_PUB.Create_Target:OTHERS'); htp.para;
87: END IF;
88: --
89: END Create_Target;
90: --
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
149: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_ERROR'); htp.para;
150: END IF;
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
150: END IF;
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
154: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR'); htp.para;
155: END IF;
156: WHEN OTHERS THEN
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: l_error_tbl := x_error_Tbl;
162: , p_error_description => SQLERRM
163: , x_error_table => x_error_Tbl
164: );
165: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
166: htp.p('BIS_TARGET_PUB.Retrieve_Targets:OTHERS'); htp.para;
167: END IF;
168: --
169: END Retrieve_Targets;
170: --
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
233: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_ERROR'); htp.para;
234: END IF;
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
234: END IF;
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
238: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
239: END IF;
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: l_error_tbl := x_error_Tbl;
246: , p_error_description => SQLERRM
247: , x_error_table => x_error_Tbl
248: );
249: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
250: htp.p('BIS_TARGET_PUB.Retrieve_Target:OTHERS'); htp.para;
251: END IF;
252: --
253: END Retrieve_Target;
254: --
289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
293: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_ERROR'); htp.para;
294: END IF;
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
294: END IF;
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
298: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
299: END IF;
300: WHEN OTHERS THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: l_error_tbl := x_error_Tbl;
306: , p_error_description => SQLERRM
307: , x_error_table => x_error_Tbl
308: );
309: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
310: htp.p('BIS_TARGET_PUB.Update_Target:OTHERS'); htp.para;
311: END IF;
312: --
313: END Update_Target;
314: --
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
352: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_ERROR'); htp.para;
353: END IF;
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
353: END IF;
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
357: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
358: END IF;
359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: l_error_tbl := x_error_Tbl;
365: , p_error_description => SQLERRM
366: , x_error_table => x_error_Tbl
367: );
368: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
369: htp.p('BIS_TARGET_PUB.Delete_Target:OTHERS'); htp.para;
370: END IF;
371: --
372: END Delete_Target;
373: --
405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: x_return_status:= FND_API.G_RET_STS_ERROR;
408: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
409: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_ERROR'); htp.para;
410: END IF;
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
413: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
410: END IF;
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
413: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
414: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
415: END IF;
416: WHEN OTHERS THEN
417: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
418: l_error_tbl := x_error_Tbl;
422: , p_error_description => SQLERRM
423: , x_error_table => x_error_Tbl
424: );
425: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
426: htp.p('BIS_TARGET_PUB.Validate_Target:OTHERS'); htp.para;
427: END IF;
428: END Validate_Target;
429: --
430:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
460: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_ERROR'); htp.para;
461: END IF;
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
461: END IF;
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
465: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
466: END IF;
467: WHEN OTHERS THEN
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: l_error_tbl := x_error_Tbl;