DBA Data[Home] [Help]

APPS.BIS_TARGET_PUB dependencies on BIS_UTILITIES_PVT

Line 68: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 73: 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
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 79: BIS_UTILITIES_PVT.Add_Error_Message

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
82: , p_error_description => SQLERRM
83: , x_error_table => x_error_Tbl

Line 85: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

81: , p_error_msg_id => SQLCODE
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;

Line 134: BIS_UTILITIES_PVT.resequence_dim_level_values

130:
131: IF (x_target_tbl.COUNT > 0) THEN
132: l_target_tbl := x_target_tbl;
133: FOR l_count IN 1..l_target_tbl.COUNT LOOP
134: BIS_UTILITIES_PVT.resequence_dim_level_values
135: (l_target_tbl(l_count)
136: ,'R'
137: ,x_target_tbl(l_count)
138: ,x_Error_tbl

Line 148: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 153: 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
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 159: BIS_UTILITIES_PVT.Add_Error_Message

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
162: , p_error_description => SQLERRM
163: , x_error_table => x_error_Tbl

Line 165: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

161: , p_error_msg_id => SQLCODE
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;

Line 203: BIS_UTILITIES_PVT.resequence_dim_level_values

199: --
200: --Resequence the dimensions. This is for backward compatibility for product teams
201: --still using Org and Time
202: l_Target_Rec_p := l_Target_Rec;
203: BIS_UTILITIES_PVT.resequence_dim_level_values
204: (l_Target_Rec_p
205: ,'N'
206: ,l_target_rec
207: ,x_Error_tbl

Line 222: BIS_UTILITIES_PVT.resequence_dim_level_values

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'
225: ,x_target_rec
226: ,x_Error_tbl

Line 232: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 237: 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
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 243: BIS_UTILITIES_PVT.Add_Error_Message

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
246: , p_error_description => SQLERRM
247: , x_error_table => x_error_Tbl

Line 249: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

245: , p_error_msg_id => SQLCODE
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;

Line 292: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 297: 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
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 303: BIS_UTILITIES_PVT.Add_Error_Message

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
306: , p_error_description => SQLERRM
307: , x_error_table => x_error_Tbl

Line 309: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

305: , p_error_msg_id => SQLCODE
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;

Line 351: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 356: 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
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 362: BIS_UTILITIES_PVT.Add_Error_Message

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
365: , p_error_description => SQLERRM
366: , x_error_table => x_error_Tbl

Line 368: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

364: , p_error_msg_id => SQLCODE
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;

Line 408: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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
412: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 413: 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
417: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 419: BIS_UTILITIES_PVT.Add_Error_Message

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
422: , p_error_description => SQLERRM
423: , x_error_table => x_error_Tbl

Line 425: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

421: , p_error_msg_id => SQLCODE
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: --

Line 459: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 464: 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
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 470: BIS_UTILITIES_PVT.Add_Error_Message

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
473: , p_error_description => SQLERRM
474: , x_error_table => x_error_Tbl