DBA Data[Home] [Help]

APPS.BIS_TARGET_LEVEL_PUB dependencies on BIS_UTILITIES_PVT

Line 73: BIS_UTILITIES_PVT.Add_Error_Message

69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: when others then
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
72: l_error_tbl := x_error_Tbl;
73: BIS_UTILITIES_PVT.Add_Error_Message
74: ( p_error_msg_id => SQLCODE
75: , p_error_description => SQLERRM
76: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
77: , p_error_table => l_error_tbl

Line 129: BIS_UTILITIES_PVT.resequence_dim_levels(l_target_level_tbl(l_count),

125: -- Put the values in Org and Time Levels for the product teams still using this
126: IF (x_target_level_tbl.COUNT > 0) THEN
127: l_target_level_tbl := x_target_level_tbl;
128: FOR l_count IN 1..l_target_level_tbl.COUNT LOOP
129: BIS_UTILITIES_PVT.resequence_dim_levels(l_target_level_tbl(l_count),
130: 'R',
131: x_target_level_tbl(l_count),
132: x_Error_tbl);
133: END LOOP;

Line 146: BIS_UTILITIES_PVT.Add_Error_Message

142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
143: when others then
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145: l_error_tbl := x_error_Tbl;
146: BIS_UTILITIES_PVT.Add_Error_Message
147: ( p_error_msg_id => SQLCODE
148: , p_error_description => SQLERRM
149: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Levels'
150: , p_error_table => l_error_tbl

Line 188: BIS_UTILITIES_PVT.resequence_dim_levels(l_target_level_rec_p,

184: IF (l_target_level_rec.org_level_id IS NOT NULL) AND
185: (l_target_level_rec.time_level_id IS NOT NULL) THEN
186: --resequence the dimensions
187: l_target_level_rec_p := l_target_level_rec;
188: BIS_UTILITIES_PVT.resequence_dim_levels(l_target_level_rec_p,
189: 'N',
190: l_target_level_Rec,
191: x_Error_tbl);
192: END IF;

Line 210: BIS_UTILITIES_PVT.resequence_dim_levels(l_target_level_rec_p,

206: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then
207:
208: --Put the values back in Org/Time level stuff for product teams using this API
209: l_target_level_rec_p := x_target_level_rec;
210: BIS_UTILITIES_PVT.resequence_dim_levels(l_target_level_rec_p,
211: 'R',
212: x_target_level_Rec,
213: x_error_tbl);
214: end if;

Line 227: BIS_UTILITIES_PVT.Add_Error_Message

223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: when others then
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226: l_error_tbl := x_error_Tbl;
227: BIS_UTILITIES_PVT.Add_Error_Message
228: ( p_error_msg_id => SQLCODE
229: , p_error_description => SQLERRM
230: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level'
231: , p_error_table => l_error_tbl

Line 278: BIS_UTILITIES_PVT.Add_Error_Message

274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: when others then
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: l_error_tbl := x_error_Tbl;
278: BIS_UTILITIES_PVT.Add_Error_Message
279: ( p_error_msg_id => SQLCODE
280: , p_error_description => SQLERRM
281: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
282: , p_error_table => l_error_tbl

Line 339: BIS_UTILITIES_PVT.Add_Error_Message

335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: when others then
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
338: l_error_tbl := x_error_Tbl;
339: BIS_UTILITIES_PVT.Add_Error_Message
340: ( p_error_msg_id => SQLCODE
341: , p_error_description => SQLERRM
342: , p_error_proc_name => G_PKG_NAME||'.Delete_Target_Level'
343: , p_error_table => l_error_tbl

Line 387: BIS_UTILITIES_PVT.Add_Error_Message

383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
384: when others then
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
386: l_error_tbl := x_error_Tbl;
387: BIS_UTILITIES_PVT.Add_Error_Message
388: ( p_error_msg_id => SQLCODE
389: , p_error_description => SQLERRM
390: , p_error_proc_name => G_PKG_NAME||'.Validate_Target_Level'
391: , p_error_table => l_error_tbl

Line 425: BIS_UTILITIES_PVT.Add_Error_Message

421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: when others then
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: l_error_tbl := x_error_Tbl;
425: BIS_UTILITIES_PVT.Add_Error_Message
426: ( p_error_msg_id => SQLCODE
427: , p_error_description => SQLERRM
428: , p_error_proc_name => G_PKG_NAME||'.Get_User_Id'
429: , p_error_table => l_error_tbl

Line 488: BIS_UTILITIES_PVT.Add_Error_Message

484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
485: when others then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: l_error_tbl := x_error_Tbl;
488: BIS_UTILITIES_PVT.Add_Error_Message
489: ( p_error_msg_id => SQLCODE
490: , p_error_description => SQLERRM
491: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Target_Levels'
492: , p_error_table => l_error_tbl

Line 524: BIS_UTILITIES_PVT.Add_Error_Message

520:
521: --added last two parameters
522: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
523: l_error_tbl := x_error_Tbl;
524: BIS_UTILITIES_PVT.Add_Error_Message
525: ( p_error_msg_name => 'BIS_INVALID_TAR_LEVEL_ID'
526: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
527: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
528: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 555: BIS_UTILITIES_PVT.Add_Error_Message

551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: when others then
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
554: l_error_tbl := x_error_Tbl;
555: BIS_UTILITIES_PVT.Add_Error_Message
556: ( p_error_msg_id => SQLCODE
557: , p_error_description => SQLERRM
558: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
559: , p_error_table => l_error_tbl

Line 638: BIS_UTILITIES_PVT.Add_Error_Message

634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
635: when others then
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
637: l_error_tbl := x_error_Tbl;
638: BIS_UTILITIES_PVT.Add_Error_Message
639: ( p_error_msg_id => SQLCODE
640: , p_error_description => SQLERRM
641: , p_error_proc_name => G_PKG_NAME||'.Load_Target_Level'
642: , p_error_table => l_error_tbl

Line 693: BIS_UTILITIES_PVT.Add_Error_Message

689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: when others then
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: l_error_tbl := x_error_Tbl;
693: BIS_UTILITIES_PVT.Add_Error_Message
694: ( p_error_msg_id => SQLCODE
695: , p_error_description => SQLERRM
696: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level'
697: , p_error_table => l_error_tbl