APPS.BIS_TARGET_LEVEL_VALIDATE_PVT dependencies on BIS_UTILITIES_PUB

Line 29: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

25: ( p_api_version IN NUMBER
26: , p_level_id IN NUMBER
27: , p_level_short_name IN VARCHAR2
28: , x_return_status OUT NOCOPY VARCHAR2
29: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
30: )
31: IS
32: l_dummy number;
33: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 33: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

29: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
30: )
31: IS
32: l_dummy number;
33: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
34:
35: CURSOR chk_dimension is
36: select 1
37: from bis_Levels

Line 42: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_level_id)=FND_API.G_TRUE

38: where level_id = p_level_id;
39:
40: begin
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_level_id)=FND_API.G_TRUE
43: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_level_id)=FND_API.G_TRUE ) then
44: open chk_dimension;
45: fetch chk_dimension into l_dummy;
46: if (chk_dimension%NOTFOUND) then

Line 43: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_level_id)=FND_API.G_TRUE ) then

39:
40: begin
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_level_id)=FND_API.G_TRUE
43: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_level_id)=FND_API.G_TRUE ) then
44: open chk_dimension;
45: fetch chk_dimension into l_dummy;
46: if (chk_dimension%NOTFOUND) then
47: close chk_dimension;

Line 55: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

51: BIS_UTILITIES_PVT.Add_Error_Message
52: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_LEVEL_ID'
53: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
54: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension_Level_ID'
55: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
56: , p_error_table => l_error_tbl
57: , x_error_table => x_error_tbl
58: );
59: RAISE FND_API.G_EXC_ERROR;

Line 92: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

88: ( p_api_version IN NUMBER
89: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
90: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
91: , x_return_status OUT NOCOPY VARCHAR2
92: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
93: )
94: IS
95: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
96: BEGIN

Line 95: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

91: , x_return_status OUT NOCOPY VARCHAR2
92: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
93: )
94: IS
95: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
96: BEGIN
97:
98: Validate_Dimension_Level_ID( p_api_version
99: , p_TARGET_LEVEL_Rec.org_Level_ID

Line 133: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

129: ( p_api_version IN NUMBER
130: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
131: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
132: , x_return_status OUT NOCOPY VARCHAR2
133: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
134: )
135: IS
136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
137: BEGIN

Line 136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

132: , x_return_status OUT NOCOPY VARCHAR2
133: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
134: )
135: IS
136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
137: BEGIN
138:
139: Validate_Dimension_Level_ID( p_api_version
140: , p_TARGET_LEVEL_Rec.time_Level_ID

Line 175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

171: ( p_api_version IN NUMBER
172: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
173: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
174: , x_return_status OUT NOCOPY VARCHAR2
175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
176: )
177: IS
178: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
179: BEGIN

Line 178: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

174: , x_return_status OUT NOCOPY VARCHAR2
175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
176: )
177: IS
178: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
179: BEGIN
180:
181: Validate_Dimension_Level_ID( p_api_version
182: , p_TARGET_LEVEL_Rec.Dimension1_Level_ID

Line 216: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

212: ( p_api_version IN NUMBER
213: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
214: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
215: , x_return_status OUT NOCOPY VARCHAR2
216: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
217: )
218: IS
219: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
220: BEGIN

Line 219: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

215: , x_return_status OUT NOCOPY VARCHAR2
216: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
217: )
218: IS
219: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
220: BEGIN
221:
222: Validate_Dimension_Level_ID( p_api_version
223: , p_TARGET_LEVEL_Rec.Dimension2_Level_ID

Line 258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

254: ( p_api_version IN NUMBER
255: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
256: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )
260: IS
261: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
262: BEGIN

Line 261: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )
260: IS
261: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
262: BEGIN
263:
264: Validate_Dimension_Level_ID( p_api_version
265: , p_TARGET_LEVEL_Rec.Dimension3_Level_ID

Line 299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

295: ( p_api_version IN NUMBER
296: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
297: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )
301: IS
302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
303: BEGIN

Line 302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )
301: IS
302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
303: BEGIN
304:
305: Validate_Dimension_Level_ID( p_api_version
306: , p_TARGET_LEVEL_Rec.Dimension4_Level_ID

Line 340: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

336: ( p_api_version IN NUMBER
337: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
338: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
339: , x_return_status OUT NOCOPY VARCHAR2
340: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
341: )
342: IS
343: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
344: BEGIN

Line 343: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

339: , x_return_status OUT NOCOPY VARCHAR2
340: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
341: )
342: IS
343: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
344: BEGIN
345:
346: Validate_Dimension_Level_ID( p_api_version
347: , p_TARGET_LEVEL_Rec.Dimension5_Level_ID

Line 382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

378: ( p_api_version IN NUMBER
379: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
380: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS
385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
386: BEGIN

Line 385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS
385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
386: BEGIN
387:
388: Validate_Dimension_Level_ID( p_api_version
389: , p_TARGET_LEVEL_Rec.Dimension6_Level_ID

Line 424: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

420: ( p_api_version IN NUMBER
421: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
422: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
423: , x_return_status OUT NOCOPY VARCHAR2
424: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
425: )
426: IS
427: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
428: BEGIN

Line 427: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

423: , x_return_status OUT NOCOPY VARCHAR2
424: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
425: )
426: IS
427: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
428: BEGIN
429:
430: Validate_Dimension_Level_ID( p_api_version
431: , p_TARGET_LEVEL_Rec.Dimension7_Level_ID

Line 466: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

462: ( p_api_version IN NUMBER
463: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
464: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
465: , x_return_status OUT NOCOPY VARCHAR2
466: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
467: )
468: is
469: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
470: begin

Line 469: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

465: , x_return_status OUT NOCOPY VARCHAR2
466: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
467: )
468: is
469: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
470: begin
471:
472: BIS_WORKFLOW_PROCESS_PVT.Validate_WF_Process_Short_Name
473: ( p_api_version

Line 508: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

504: ( p_api_version IN NUMBER
505: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
506: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
507: , x_return_status OUT NOCOPY VARCHAR2
508: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
509: )
510: IS
511: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
512: BEGIN

Line 511: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

507: , x_return_status OUT NOCOPY VARCHAR2
508: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
509: )
510: IS
511: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
512: BEGIN
513:
514: BIS_RESPONSIBILITY_PVT.Validate_Notify_Resp_ID
515: ( p_api_version

Line 551: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

547: ( p_api_version IN NUMBER
548: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
549: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
550: , x_return_status OUT NOCOPY VARCHAR2
551: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
552: )
553: IS
554: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
555: BEGIN

Line 554: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

550: , x_return_status OUT NOCOPY VARCHAR2
551: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
552: )
553: IS
554: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
555: BEGIN
556:
557: BIS_COMPUTED_TARGET_PVT.Validate_Computed_Target_Id
558: ( p_api_version