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_UTILITIES_PUB dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24: )
25: IS
26: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_id) = FND_API.G_TRUE THEN
31: select user_id , user_name
32: into x_user_id, x_user_name

Line 30: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_id) = FND_API.G_TRUE THEN

26: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_id) = FND_API.G_TRUE THEN
31: select user_id , user_name
32: into x_user_id, x_user_name
33: from fnd_user
34: where user_id = p_user_id;

Line 35: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_name) = FND_API.G_TRUE THEN

31: select user_id , user_name
32: into x_user_id, x_user_name
33: from fnd_user
34: where user_id = p_user_id;
35: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_name) = FND_API.G_TRUE THEN
36: select user_id , user_name
37: into x_user_id, x_user_name
38: from fnd_user
39: where user_name = p_user_name;

Line 46: x_return_status := FND_API.G_RET_STS_ERROR ;

42: END IF;
43:
44: EXCEPTION
45: WHEN NO_DATA_FOUND THEN
46: x_return_status := FND_API.G_RET_STS_ERROR ;
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 47: when FND_API.G_EXC_ERROR then

43:
44: EXCEPTION
45: WHEN NO_DATA_FOUND THEN
46: x_return_status := FND_API.G_RET_STS_ERROR ;
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then

Line 48: x_return_status := FND_API.G_RET_STS_ERROR ;

44: EXCEPTION
45: WHEN NO_DATA_FOUND THEN
46: x_return_status := FND_API.G_RET_STS_ERROR ;
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 49: when FND_API.G_EXC_UNEXPECTED_ERROR then

45: WHEN NO_DATA_FOUND THEN
46: x_return_status := FND_API.G_RET_STS_ERROR ;
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: l_error_tbl := x_error_Tbl;

Line 50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

46: x_return_status := FND_API.G_RET_STS_ERROR ;
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: l_error_tbl := x_error_Tbl;
54: BIS_UTILITIES_PVT.Add_Error_Message

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: l_error_tbl := x_error_Tbl;
54: BIS_UTILITIES_PVT.Add_Error_Message
55: ( p_error_msg_id => SQLCODE
56: , p_error_description => SQLERRM

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: IS
74: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
75:
76: BEGIN
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_id) = FND_API.G_TRUE)
80: THEN
81: select organization_id , name

Line 79: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_id) = FND_API.G_TRUE)

75:
76: BEGIN
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_id) = FND_API.G_TRUE)
80: THEN
81: select organization_id , name
82: into x_organization_id, x_organization_name
83: from hr_all_organization_units

Line 85: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_name) = FND_API.G_TRUE THEN

81: select organization_id , name
82: into x_organization_id, x_organization_name
83: from hr_all_organization_units
84: where organization_id = p_organization_id;
85: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_name) = FND_API.G_TRUE THEN
86: select organization_id , name
87: into x_organization_id, x_organization_name
88: from hr_all_organization_units
89: where name = p_organization_name;

Line 96: x_return_status := FND_API.G_RET_STS_ERROR ;

92: END IF;
93:
94: EXCEPTION
95: WHEN NO_DATA_FOUND THEN
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_ERROR then
98: x_return_status := FND_API.G_RET_STS_ERROR ;
99: when FND_API.G_EXC_UNEXPECTED_ERROR then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 97: when FND_API.G_EXC_ERROR then

93:
94: EXCEPTION
95: WHEN NO_DATA_FOUND THEN
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_ERROR then
98: x_return_status := FND_API.G_RET_STS_ERROR ;
99: when FND_API.G_EXC_UNEXPECTED_ERROR then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: when others then

Line 98: x_return_status := FND_API.G_RET_STS_ERROR ;

94: EXCEPTION
95: WHEN NO_DATA_FOUND THEN
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_ERROR then
98: x_return_status := FND_API.G_RET_STS_ERROR ;
99: when FND_API.G_EXC_UNEXPECTED_ERROR then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: when others then
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 99: when FND_API.G_EXC_UNEXPECTED_ERROR then

95: WHEN NO_DATA_FOUND THEN
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_ERROR then
98: x_return_status := FND_API.G_RET_STS_ERROR ;
99: when FND_API.G_EXC_UNEXPECTED_ERROR then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: when others then
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: l_error_tbl := x_error_Tbl;

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_ERROR then
98: x_return_status := FND_API.G_RET_STS_ERROR ;
99: when FND_API.G_EXC_UNEXPECTED_ERROR then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: when others then
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: l_error_tbl := x_error_Tbl;
104: BIS_UTILITIES_PVT.Add_Error_Message

Line 102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

98: x_return_status := FND_API.G_RET_STS_ERROR ;
99: when FND_API.G_EXC_UNEXPECTED_ERROR then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: when others then
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: l_error_tbl := x_error_Tbl;
104: BIS_UTILITIES_PVT.Add_Error_Message
105: ( p_error_msg_id => SQLCODE
106: , p_error_description => SQLERRM

Line 196: IF BIS_UTILITIES_PUB.Value_Missing(p_user_id) = FND_API.G_TRUE

192: WHERE UPPER(level_values_view_name) = UPPER(l_database_object) and dimension_short_name = p_dimension_short_name;
193: END IF;
194:
195:
196: IF BIS_UTILITIES_PUB.Value_Missing(p_user_id) = FND_API.G_TRUE
197: THEN
198: SELECT user_id
199: INTO l_user_id
200: FROM fnd_user

Line 219: IF ( BIS_UTILITIES_PUB.Value_Missing(p_organization_id) = FND_API.G_TRUE ) THEN -- 2694965

215: );
216:
217: ELSIF p_dimension_short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
218: ,p_DimLevelName => l_dim_level_short_name) THEN
219: IF ( BIS_UTILITIES_PUB.Value_Missing(p_organization_id) = FND_API.G_TRUE ) THEN -- 2694965
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222: Retrieve_Time_Where_Clause
223: ( p_database_object => l_database_object

Line 220: RAISE FND_API.G_EXC_ERROR;

216:
217: ELSIF p_dimension_short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
218: ,p_DimLevelName => l_dim_level_short_name) THEN
219: IF ( BIS_UTILITIES_PUB.Value_Missing(p_organization_id) = FND_API.G_TRUE ) THEN -- 2694965
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222: Retrieve_Time_Where_Clause
223: ( p_database_object => l_database_object
224: , p_dim_level_short_name => l_dim_level_short_name

Line 247: x_return_status := FND_API.G_RET_STS_ERROR ;

243:
244:
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: when FND_API.G_EXC_ERROR then
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 248: when FND_API.G_EXC_ERROR then

244:
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: when FND_API.G_EXC_ERROR then
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: when others then

Line 249: x_return_status := FND_API.G_RET_STS_ERROR ;

245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: when FND_API.G_EXC_ERROR then
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: when others then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 250: when FND_API.G_EXC_UNEXPECTED_ERROR then

246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: when FND_API.G_EXC_ERROR then
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: when others then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: l_error_tbl := x_error_Tbl;

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: when FND_API.G_EXC_ERROR then
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: when others then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: l_error_tbl := x_error_Tbl;
255: BIS_UTILITIES_PVT.Add_Error_Message

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: when others then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: l_error_tbl := x_error_Tbl;
255: BIS_UTILITIES_PVT.Add_Error_Message
256: ( p_error_msg_id => SQLCODE
257: , p_error_description => SQLERRM

Line 378: x_return_status := FND_API.G_RET_STS_ERROR ;

374: x_where_clause := l_where_clause;
375:
376: EXCEPTION
377: WHEN NO_DATA_FOUND THEN
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: when FND_API.G_EXC_ERROR then
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: when FND_API.G_EXC_UNEXPECTED_ERROR then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 379: when FND_API.G_EXC_ERROR then

375:
376: EXCEPTION
377: WHEN NO_DATA_FOUND THEN
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: when FND_API.G_EXC_ERROR then
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: when FND_API.G_EXC_UNEXPECTED_ERROR then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: when others then

Line 380: x_return_status := FND_API.G_RET_STS_ERROR ;

376: EXCEPTION
377: WHEN NO_DATA_FOUND THEN
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: when FND_API.G_EXC_ERROR then
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: when FND_API.G_EXC_UNEXPECTED_ERROR then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: when others then
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 381: when FND_API.G_EXC_UNEXPECTED_ERROR then

377: WHEN NO_DATA_FOUND THEN
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: when FND_API.G_EXC_ERROR then
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: when FND_API.G_EXC_UNEXPECTED_ERROR then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: when others then
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: l_error_tbl := x_error_Tbl;

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: when FND_API.G_EXC_ERROR then
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: when FND_API.G_EXC_UNEXPECTED_ERROR then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: when others then
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: l_error_tbl := x_error_Tbl;
386: BIS_UTILITIES_PVT.Add_Error_Message

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: when FND_API.G_EXC_UNEXPECTED_ERROR then
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: when others then
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: l_error_tbl := x_error_Tbl;
386: BIS_UTILITIES_PVT.Add_Error_Message
387: ( p_error_msg_id => SQLCODE
388: , p_error_description => SQLERRM

Line 506: x_return_status := FND_API.G_RET_STS_ERROR ;

502: x_where_clause := l_where_clause;
503:
504: EXCEPTION
505: WHEN NO_DATA_FOUND THEN
506: x_return_status := FND_API.G_RET_STS_ERROR ;
507: when FND_API.G_EXC_ERROR then
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: when FND_API.G_EXC_UNEXPECTED_ERROR then
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 507: when FND_API.G_EXC_ERROR then

503:
504: EXCEPTION
505: WHEN NO_DATA_FOUND THEN
506: x_return_status := FND_API.G_RET_STS_ERROR ;
507: when FND_API.G_EXC_ERROR then
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: when FND_API.G_EXC_UNEXPECTED_ERROR then
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: when others then

Line 508: x_return_status := FND_API.G_RET_STS_ERROR ;

504: EXCEPTION
505: WHEN NO_DATA_FOUND THEN
506: x_return_status := FND_API.G_RET_STS_ERROR ;
507: when FND_API.G_EXC_ERROR then
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: when FND_API.G_EXC_UNEXPECTED_ERROR then
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: when others then
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 509: when FND_API.G_EXC_UNEXPECTED_ERROR then

505: WHEN NO_DATA_FOUND THEN
506: x_return_status := FND_API.G_RET_STS_ERROR ;
507: when FND_API.G_EXC_ERROR then
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: when FND_API.G_EXC_UNEXPECTED_ERROR then
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: when others then
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: l_error_tbl := x_error_Tbl;

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

506: x_return_status := FND_API.G_RET_STS_ERROR ;
507: when FND_API.G_EXC_ERROR then
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: when FND_API.G_EXC_UNEXPECTED_ERROR then
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: when others then
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: l_error_tbl := x_error_Tbl;
514: BIS_UTILITIES_PVT.Add_Error_Message

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: when FND_API.G_EXC_UNEXPECTED_ERROR then
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: when others then
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: l_error_tbl := x_error_Tbl;
514: BIS_UTILITIES_PVT.Add_Error_Message
515: ( p_error_msg_id => SQLCODE
516: , p_error_description => SQLERRM

Line 553: x_return_status := FND_API.G_RET_STS_ERROR ;

549: x_where_clause := l_where_clause;
550:
551: EXCEPTION
552: WHEN NO_DATA_FOUND THEN
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: when FND_API.G_EXC_ERROR then
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: when FND_API.G_EXC_UNEXPECTED_ERROR then
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 554: when FND_API.G_EXC_ERROR then

550:
551: EXCEPTION
552: WHEN NO_DATA_FOUND THEN
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: when FND_API.G_EXC_ERROR then
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: when FND_API.G_EXC_UNEXPECTED_ERROR then
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: when others then

Line 555: x_return_status := FND_API.G_RET_STS_ERROR ;

551: EXCEPTION
552: WHEN NO_DATA_FOUND THEN
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: when FND_API.G_EXC_ERROR then
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: when FND_API.G_EXC_UNEXPECTED_ERROR then
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: when others then
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 556: when FND_API.G_EXC_UNEXPECTED_ERROR then

552: WHEN NO_DATA_FOUND THEN
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: when FND_API.G_EXC_ERROR then
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: when FND_API.G_EXC_UNEXPECTED_ERROR then
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: when others then
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: l_error_tbl := x_error_Tbl;

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: when FND_API.G_EXC_ERROR then
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: when FND_API.G_EXC_UNEXPECTED_ERROR then
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: when others then
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: l_error_tbl := x_error_Tbl;
561: BIS_UTILITIES_PVT.Add_Error_Message

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: when FND_API.G_EXC_UNEXPECTED_ERROR then
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: when others then
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: l_error_tbl := x_error_Tbl;
561: BIS_UTILITIES_PVT.Add_Error_Message
562: ( p_error_msg_id => SQLCODE
563: , p_error_description => SQLERRM

Line 610: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_value) = FND_API.G_TRUE THEN

606: IS
607: l_name varchar2(100);
608: BEGIN
609:
610: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_value) = FND_API.G_TRUE THEN
611: l_name := WF_DIRECTORY.GetRoleDisplayName(p_value);
612: ELSE
613: l_name := NULL;
614: END IF;

Line 629: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_value) = FND_API.G_TRUE THEN

625: IS
626: l_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
627: BEGIN
628:
629: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_value) = FND_API.G_TRUE THEN
630: select FUNCTION_NAME
631: into l_name
632: from fnd_form_functions
633: where function_id = p_value;

Line 650: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_value) = FND_API.G_TRUE THEN

646: IS
647: l_name varchar2(100);
648: BEGIN
649:
650: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_value) = FND_API.G_TRUE THEN
651: select USER_FUNCTION_NAME
652: into l_name
653: from fnd_form_functions_tl
654: where function_id = p_value

Line 680: IF BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE

676: l_version number;
677: l_name varchar2(100);
678: BEGIN
679:
680: IF BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
681: OR BIS_UTILITIES_PUB.Value_Missing(p_type) = FND_API.G_TRUE
682: THEN
683: l_name := NULL;
684: ELSE

Line 681: OR BIS_UTILITIES_PUB.Value_Missing(p_type) = FND_API.G_TRUE

677: l_name varchar2(100);
678: BEGIN
679:
680: IF BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
681: OR BIS_UTILITIES_PUB.Value_Missing(p_type) = FND_API.G_TRUE
682: THEN
683: l_name := NULL;
684: ELSE
685: select version

Line 848: when FND_API.G_EXC_ERROR then

844:
845:
846: EXCEPTION
847:
848: when FND_API.G_EXC_ERROR then
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: when FND_API.G_EXC_UNEXPECTED_ERROR then
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: when others then

Line 849: x_return_status := FND_API.G_RET_STS_ERROR ;

845:
846: EXCEPTION
847:
848: when FND_API.G_EXC_ERROR then
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: when FND_API.G_EXC_UNEXPECTED_ERROR then
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: when others then
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 850: when FND_API.G_EXC_UNEXPECTED_ERROR then

846: EXCEPTION
847:
848: when FND_API.G_EXC_ERROR then
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: when FND_API.G_EXC_UNEXPECTED_ERROR then
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: when others then
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: l_error_tbl := x_error_Tbl;

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

847:
848: when FND_API.G_EXC_ERROR then
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: when FND_API.G_EXC_UNEXPECTED_ERROR then
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: when others then
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: l_error_tbl := x_error_Tbl;
855: BIS_UTILITIES_PVT.Add_Error_Message

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: when FND_API.G_EXC_UNEXPECTED_ERROR then
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: when others then
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: l_error_tbl := x_error_Tbl;
855: BIS_UTILITIES_PVT.Add_Error_Message
856: ( p_error_msg_id => SQLCODE
857: , p_error_description => SQLERRM

Line 887: when FND_API.G_EXC_ERROR then

883:
884:
885: EXCEPTION
886:
887: when FND_API.G_EXC_ERROR then
888: x_return_status := FND_API.G_RET_STS_ERROR ;
889: when FND_API.G_EXC_UNEXPECTED_ERROR then
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: when others then

Line 888: x_return_status := FND_API.G_RET_STS_ERROR ;

884:
885: EXCEPTION
886:
887: when FND_API.G_EXC_ERROR then
888: x_return_status := FND_API.G_RET_STS_ERROR ;
889: when FND_API.G_EXC_UNEXPECTED_ERROR then
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: when others then
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 889: when FND_API.G_EXC_UNEXPECTED_ERROR then

885: EXCEPTION
886:
887: when FND_API.G_EXC_ERROR then
888: x_return_status := FND_API.G_RET_STS_ERROR ;
889: when FND_API.G_EXC_UNEXPECTED_ERROR then
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: when others then
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: l_error_tbl := x_error_Tbl;

Line 890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

886:
887: when FND_API.G_EXC_ERROR then
888: x_return_status := FND_API.G_RET_STS_ERROR ;
889: when FND_API.G_EXC_UNEXPECTED_ERROR then
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: when others then
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: l_error_tbl := x_error_Tbl;
894: BIS_UTILITIES_PVT.Add_Error_Message

Line 892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

888: x_return_status := FND_API.G_RET_STS_ERROR ;
889: when FND_API.G_EXC_UNEXPECTED_ERROR then
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: when others then
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: l_error_tbl := x_error_Tbl;
894: BIS_UTILITIES_PVT.Add_Error_Message
895: ( p_error_msg_id => SQLCODE
896: , p_error_description => SQLERRM

Line 1273: WHEN FND_API.G_EXC_ERROR THEN

1269: x_where_clause := l_where_clause;
1270:
1271: x_return_status := 'S';
1272: EXCEPTION
1273: WHEN FND_API.G_EXC_ERROR THEN
1274: x_return_status := FND_API.G_RET_STS_ERROR;
1275: l_error_tbl := x_error_tbl;
1276: BIS_UTILITIES_PVT.Add_Error_Message
1277: ( p_error_table => l_error_Tbl

Line 1274: x_return_status := FND_API.G_RET_STS_ERROR;

1270:
1271: x_return_status := 'S';
1272: EXCEPTION
1273: WHEN FND_API.G_EXC_ERROR THEN
1274: x_return_status := FND_API.G_RET_STS_ERROR;
1275: l_error_tbl := x_error_tbl;
1276: BIS_UTILITIES_PVT.Add_Error_Message
1277: ( p_error_table => l_error_Tbl
1278: , p_error_msg_id => SQLCODE

Line 1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1282: FND_MSG_PUB.Count_And_Get
1283: ( p_count => x_msg_count,
1284: p_data => x_msg_data
1285: );
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: l_error_tbl := x_error_tbl;
1289: BIS_UTILITIES_PVT.Add_Error_Message
1290: ( p_error_table => l_error_Tbl

Line 1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1283: ( p_count => x_msg_count,
1284: p_data => x_msg_data
1285: );
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: l_error_tbl := x_error_tbl;
1289: BIS_UTILITIES_PVT.Add_Error_Message
1290: ( p_error_table => l_error_Tbl
1291: , p_error_msg_id => SQLCODE

Line 1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1296: ( p_count => x_msg_count,
1297: p_data => x_msg_data
1298: );
1299: WHEN OTHERS THEN
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: l_error_tbl := x_error_tbl;
1302: BIS_UTILITIES_PVT.Add_Error_Message
1303: ( p_error_table => l_error_Tbl
1304: , p_error_msg_id => SQLCODE

Line 1347: WHEN FND_API.G_EXC_ERROR THEN

1343:
1344: x_where_clause := l_where_clause;
1345: x_return_status := 'S';
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: l_error_tbl := x_error_tbl;
1350: BIS_UTILITIES_PVT.Add_Error_Message
1351: ( p_error_table => l_error_Tbl

Line 1348: x_return_status := FND_API.G_RET_STS_ERROR;

1344: x_where_clause := l_where_clause;
1345: x_return_status := 'S';
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: l_error_tbl := x_error_tbl;
1350: BIS_UTILITIES_PVT.Add_Error_Message
1351: ( p_error_table => l_error_Tbl
1352: , p_error_msg_id => SQLCODE

Line 1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1356: FND_MSG_PUB.Count_And_Get
1357: ( p_count => x_msg_count,
1358: p_data => x_msg_data
1359: );
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: l_error_tbl := x_error_tbl;
1363: BIS_UTILITIES_PVT.Add_Error_Message
1364: ( p_error_table => l_error_Tbl

Line 1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1357: ( p_count => x_msg_count,
1358: p_data => x_msg_data
1359: );
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: l_error_tbl := x_error_tbl;
1363: BIS_UTILITIES_PVT.Add_Error_Message
1364: ( p_error_table => l_error_Tbl
1365: , p_error_msg_id => SQLCODE

Line 1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1370: ( p_count => x_msg_count,
1371: p_data => x_msg_data
1372: );
1373: WHEN OTHERS THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: l_error_tbl := x_error_tbl;
1376: BIS_UTILITIES_PVT.Add_Error_Message
1377: ( p_error_table => l_error_Tbl
1378: , p_error_msg_id => SQLCODE

Line 1560: x_return_status := FND_API.G_RET_STS_SUCCESS;

1556: , x_return_msg OUT NOCOPY VARCHAR2
1557: ) IS
1558: BEGIN
1559:
1560: x_return_status := FND_API.G_RET_STS_SUCCESS;
1561: x_return_msg := NULL;
1562: bis_utilities_pvt.get_debug_mode_profile(
1563: x_is_debug_mode => x_is_debug_mode
1564: , x_return_status => x_return_status

Line 1570: x_return_status := FND_API.G_RET_STS_ERROR;

1566: );
1567:
1568: EXCEPTION
1569: WHEN OTHERS THEN
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PUB.get_debug_mode_profile: '|| SQLERRM;
1572: x_is_debug_mode := FALSE;
1573: END get_debug_mode_profile ;
1574:

Line 1586: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;

1582: , x_return_status OUT NOCOPY VARCHAR2
1583: , x_return_msg OUT NOCOPY VARCHAR2
1584: )
1585: IS
1586: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;
1587: l_return_msg VARCHAR2(10000) := NULL;
1588: BEGIN
1589:
1590: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1590: x_return_status := FND_API.G_RET_STS_SUCCESS;

1586: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;
1587: l_return_msg VARCHAR2(10000) := NULL;
1588: BEGIN
1589:
1590: x_return_status := FND_API.G_RET_STS_SUCCESS;
1591: x_return_msg := NULL;
1592:
1593: bis_utilities_pvt.set_debug_log_flag(
1594: p_is_true => p_is_true

Line 1601: x_return_status := FND_API.G_RET_STS_ERROR;

1597:
1598:
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PUB.set_debug_log_flag: '|| SQLERRM;
1603: END set_debug_log_flag;
1604:
1605:

Line 1628: x_return_status := FND_API.G_RET_STS_SUCCESS;

1624: x_return_status OUT NOCOPY VARCHAR2,
1625: x_return_msg OUT NOCOPY VARCHAR2)
1626: IS
1627: BEGIN
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: x_return_msg := NULL;
1630:
1631: bis_utilities_pvt.open_debug_log ( -- 2694978
1632: p_file_name => p_file_name ,

Line 1639: x_return_status := FND_API.G_RET_STS_ERROR;

1635: x_return_msg => x_return_msg);
1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PUB.open_debug_log: '|| SQLERRM;
1641: END open_debug_log;
1642:
1643:

Line 1652: x_return_status := FND_API.G_RET_STS_SUCCESS;

1648: x_return_status OUT NOCOPY VARCHAR2,
1649: x_return_msg OUT NOCOPY VARCHAR2)
1650: IS
1651: BEGIN
1652: x_return_status := FND_API.G_RET_STS_SUCCESS;
1653: x_return_msg := NULL;
1654:
1655: bis_utilities_pvt.close_debug_log(
1656: p_file_name => p_file_name

Line 1663: x_return_status := FND_API.G_RET_STS_ERROR;

1659: , x_return_msg => x_return_msg);
1660:
1661: EXCEPTION
1662: WHEN OTHERS THEN
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PUB.close_debug_log: '|| SQLERRM;
1665: END close_debug_log;
1666:
1667: