eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_TARGET_PUB dependencies on FND_API

Line 36: , p_commit IN VARCHAR2 := FND_API.G_FALSE

32: -- Defines one target for a specific set of dimension values for
33: -- one target level
34: PROCEDURE Create_Target
35: ( p_api_version IN NUMBER
36: , p_commit IN VARCHAR2 := FND_API.G_FALSE
37: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
38: , x_return_status OUT NOCOPY VARCHAR2
39: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
40: )

Line 66: WHEN FND_API.G_EXC_ERROR THEN

62: , x_error_Tbl => x_error_Tbl
63: );
64: --
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;

Line 67: x_return_status := FND_API.G_RET_STS_ERROR;

63: );
64: --
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

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_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
74: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
75: END IF;

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_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
74: htp.p('BIS_TARGET_PUB.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
75: END IF;
76: WHEN OTHERS THEN

Line 77: 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;
79: BIS_UTILITIES_PVT.Add_Error_Message
80: ( p_error_table => l_error_tbl
81: , p_error_msg_id => SQLCODE

Line 98: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

94: -- to FALSE.
95: PROCEDURE Retrieve_Targets
96: ( p_api_version IN NUMBER
97: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
98: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
99: , x_Target_Tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type
100: , x_return_status OUT NOCOPY VARCHAR2
101: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
102: )

Line 146: WHEN FND_API.G_EXC_ERROR THEN

142:
143:
144: --
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;

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

143:
144: --
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

Line 151: WHEN FND_API.G_EXC_UNEXPECTED_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
154: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR'); htp.para;
155: END IF;

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_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
154: htp.p('BIS_TARGET_PUB.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR'); htp.para;
155: END IF;
156: WHEN OTHERS THEN

Line 157: 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;
159: BIS_UTILITIES_PVT.Add_Error_Message
160: ( p_error_table => l_error_tbl
161: , p_error_msg_id => SQLCODE

Line 178: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

174: -- to FALSE.
175: PROCEDURE Retrieve_Target
176: ( p_api_version IN NUMBER
177: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
178: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
179: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
180: , x_return_status OUT NOCOPY VARCHAR2
181: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
182: )

Line 220: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then

216: );
217: --
218: --Put the values back in Org and Time for the product teams still using them
219: --added this check
220: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then
221: l_Target_Rec_p := x_Target_Rec;
222: BIS_UTILITIES_PVT.resequence_dim_level_values
223: (l_Target_Rec_p
224: ,'R'

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: ,x_Error_tbl
227: );
228: end if;
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;

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: );
228: end if;
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

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_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
238: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
239: END IF;

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_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
238: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
239: END IF;
240: WHEN OTHERS THEN

Line 241: 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;
243: BIS_UTILITIES_PVT.Add_Error_Message
244: ( p_error_table => l_error_tbl
245: , p_error_msg_id => SQLCODE

Line 259: , p_commit IN VARCHAR2 := FND_API.G_FALSE

255: -- Modifies one target for a specific set of dimension values for
256: -- one target level
257: PROCEDURE Update_Target
258: ( p_api_version IN NUMBER
259: , p_commit IN VARCHAR2 := FND_API.G_FALSE
260: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
261: , x_return_status OUT NOCOPY VARCHAR2
262: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
263: )

Line 290: WHEN FND_API.G_EXC_ERROR THEN

286: , x_error_Tbl => x_error_Tbl
287: );
288: --
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;

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: );
288: --
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

Line 295: WHEN FND_API.G_EXC_UNEXPECTED_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
298: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
299: END IF;

Line 296: x_return_status := FND_API.G_RET_STS_UNEXP_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
298: htp.p('BIS_TARGET_PUB.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
299: END IF;
300: WHEN OTHERS THEN

Line 301: 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;
303: BIS_UTILITIES_PVT.Add_Error_Message
304: ( p_error_table => l_error_tbl
305: , p_error_msg_id => SQLCODE

Line 319: , p_commit IN VARCHAR2 := FND_API.G_FALSE

315: -- Deletes one target for a specific set of dimension values for
316: -- one target level
317: PROCEDURE Delete_Target
318: ( p_api_version IN NUMBER
319: , p_commit IN VARCHAR2 := FND_API.G_FALSE
320: , p_Target_Rec IN BIS_TARGET_PUB.Target_Rec_Type
321: , x_return_status OUT NOCOPY VARCHAR2
322: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
323: )

Line 349: WHEN FND_API.G_EXC_ERROR THEN

345: , x_error_Tbl => x_error_Tbl
346: );
347: --
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;

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

346: );
347: --
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

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_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
357: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
358: END IF;

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_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
357: htp.p('BIS_TARGET_PUB.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
358: END IF;
359: WHEN OTHERS THEN

Line 360: 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;
362: BIS_UTILITIES_PVT.Add_Error_Message
363: ( p_error_table => l_error_tbl
364: , p_error_msg_id => SQLCODE

Line 406: WHEN FND_API.G_EXC_ERROR THEN

402: , x_error_Tbl => x_error_Tbl
403: );
404: --
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;

Line 407: x_return_status:= FND_API.G_RET_STS_ERROR;

403: );
404: --
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

Line 411: WHEN FND_API.G_EXC_UNEXPECTED_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
414: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
415: END IF;

Line 412: x_return_status:= FND_API.G_RET_STS_UNEXP_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
414: htp.p('BIS_TARGET_PUB.Validate_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
415: END IF;
416: WHEN OTHERS THEN

Line 417: 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;
419: BIS_UTILITIES_PVT.Add_Error_Message
420: ( p_error_table => l_error_tbl
421: , p_error_msg_id => SQLCODE

Line 457: WHEN FND_API.G_EXC_ERROR THEN

453: , x_error_Tbl => x_error_Tbl
454: );
455:
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;

Line 458: x_return_status := FND_API.G_RET_STS_ERROR;

454: );
455:
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

Line 462: WHEN FND_API.G_EXC_UNEXPECTED_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
465: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
466: END IF;

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_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
465: htp.p('BIS_TARGET_PUB.Retrieve_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
466: END IF;
467: WHEN OTHERS THEN

Line 468: 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;
470: BIS_UTILITIES_PVT.Add_Error_Message
471: ( p_error_table => l_error_tbl
472: , p_error_msg_id => SQLCODE