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.OKE_VERSION_PUB dependencies on FND_API

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

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKE_VERSION_PUB';
5:
6: PROCEDURE version_contract
7: ( p_api_version IN NUMBER
8: , p_commit IN VARCHAR2 := FND_API.G_FALSE
9: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
10: , x_msg_count OUT NOCOPY NUMBER
11: , x_msg_data OUT NOCOPY VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2

Line 9: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5:
6: PROCEDURE version_contract
7: ( p_api_version IN NUMBER
8: , p_commit IN VARCHAR2 := FND_API.G_FALSE
9: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
10: , x_msg_count OUT NOCOPY NUMBER
11: , x_msg_data OUT NOCOPY VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2
13: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 13: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR

9: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
10: , x_msg_count OUT NOCOPY NUMBER
11: , x_msg_data OUT NOCOPY VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2
13: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR
14: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR
15: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM
16: , p_chg_request_id IN NUMBER
17: , p_version_reason_code IN VARCHAR2

Line 14: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR

10: , x_msg_count OUT NOCOPY NUMBER
11: , x_msg_data OUT NOCOPY VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2
13: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR
14: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR
15: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM
16: , p_chg_request_id IN NUMBER
17: , p_version_reason_code IN VARCHAR2
18: , x_Prev_Version OUT NOCOPY NUMBER

Line 15: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM

11: , x_msg_data OUT NOCOPY VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2
13: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR
14: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR
15: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM
16: , p_chg_request_id IN NUMBER
17: , p_version_reason_code IN VARCHAR2
18: , x_Prev_Version OUT NOCOPY NUMBER
19: , x_New_Version OUT NOCOPY NUMBER

Line 31: or p_Contract_Num_Modifier = FND_API.G_MISS_CHAR )

27: select id
28: from okc_k_headers_b
29: where contract_number = p_Contract_Number
30: and ( ( ( p_Contract_Num_Modifier IS NULL
31: or p_Contract_Num_Modifier = FND_API.G_MISS_CHAR )
32: and contract_number_modifier IS NULL )
33: or ( contract_number_modifier = p_Contract_Num_Modifier )
34: );
35: */

Line 48: IF NOT FND_API.Compatible_API_Call( l_api_version

44:
45: --
46: -- Check API incompatibility
47: --
48: IF NOT FND_API.Compatible_API_Call( l_api_version
49: , p_api_version
50: , l_api_name
51: , G_PKG_NAME )
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: , p_api_version
50: , l_api_name
51: , G_PKG_NAME )
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56: --
57: -- Initialize the message table if requested.

Line 59: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

55:
56: --
57: -- Initialize the message table if requested.
58: --
59: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: --

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62:
63: --
64: -- Set API return status to success
65: --
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68:
69: l_chr_id := p_Contract_Header_ID;
70:

Line 76: IF ( p_Contract_Header_ID <> FND_API.G_MISS_NUM ) THEN

72: /*
73: --
74: -- Value to ID conversions
75: --
76: IF ( p_Contract_Header_ID <> FND_API.G_MISS_NUM ) THEN
77: l_chr_id := p_Contract_Header_ID;
78: ELSE
79: OPEN k;
80: FETCH k INTO l_chr_id;

Line 102: IF FND_API.To_Boolean( p_commit ) THEN

98:
99: --
100: -- Standard commit check
101: --
102: IF FND_API.To_Boolean( p_commit ) THEN
103: COMMIT WORK;
104: END IF;
105:
106: --

Line 114: WHEN FND_API.G_EXC_ERROR THEN

110: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
111: , p_data => x_msg_data );
112:
113: EXCEPTION
114: WHEN FND_API.G_EXC_ERROR THEN
115: ROLLBACK TO version_contract_pub;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
118: , p_data => x_msg_data );

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

112:
113: EXCEPTION
114: WHEN FND_API.G_EXC_ERROR THEN
115: ROLLBACK TO version_contract_pub;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
118: , p_data => x_msg_data );
119:
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
118: , p_data => x_msg_data );
119:
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: ROLLBACK TO version_contract_pub;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
124: , p_data => x_msg_data );

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

118: , p_data => x_msg_data );
119:
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: ROLLBACK TO version_contract_pub;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
124: , p_data => x_msg_data );
125:
126: WHEN OTHERS THEN

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

124: , p_data => x_msg_data );
125:
126: WHEN OTHERS THEN
127: ROLLBACK TO version_contract_pub;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
130: FND_MSG_PUB.add_exc_msg
131: ( p_pkg_name => G_PKG_NAME
132: , p_procedure_name => l_api_name );

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

139:
140:
141: PROCEDURE restore_contract_version
142: ( p_api_version IN NUMBER
143: , p_commit IN VARCHAR2 := FND_API.G_FALSE
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , x_msg_count OUT NOCOPY NUMBER
146: , x_msg_data OUT NOCOPY VARCHAR2
147: , x_return_status OUT NOCOPY VARCHAR2

Line 144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

140:
141: PROCEDURE restore_contract_version
142: ( p_api_version IN NUMBER
143: , p_commit IN VARCHAR2 := FND_API.G_FALSE
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , x_msg_count OUT NOCOPY NUMBER
146: , x_msg_data OUT NOCOPY VARCHAR2
147: , x_return_status OUT NOCOPY VARCHAR2
148: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 148: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR

144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , x_msg_count OUT NOCOPY NUMBER
146: , x_msg_data OUT NOCOPY VARCHAR2
147: , x_return_status OUT NOCOPY VARCHAR2
148: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR
149: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR
150: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM
151: , p_Restore_From_Version IN NUMBER --:= FND_API.G_MISS_NUM
152: , p_chg_request_id IN NUMBER

Line 149: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR

145: , x_msg_count OUT NOCOPY NUMBER
146: , x_msg_data OUT NOCOPY VARCHAR2
147: , x_return_status OUT NOCOPY VARCHAR2
148: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR
149: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR
150: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM
151: , p_Restore_From_Version IN NUMBER --:= FND_API.G_MISS_NUM
152: , p_chg_request_id IN NUMBER
153: , p_version_reason_code IN VARCHAR2

Line 150: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM

146: , x_msg_data OUT NOCOPY VARCHAR2
147: , x_return_status OUT NOCOPY VARCHAR2
148: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR
149: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR
150: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM
151: , p_Restore_From_Version IN NUMBER --:= FND_API.G_MISS_NUM
152: , p_chg_request_id IN NUMBER
153: , p_version_reason_code IN VARCHAR2
154: , x_New_Version OUT NOCOPY NUMBER

Line 151: , p_Restore_From_Version IN NUMBER --:= FND_API.G_MISS_NUM

147: , x_return_status OUT NOCOPY VARCHAR2
148: --, p_Contract_Number IN VARCHAR2 := FND_API.G_MISS_CHAR
149: --, p_Contract_Num_Modifier IN VARCHAR2 := FND_API.G_MISS_CHAR
150: , p_Contract_Header_ID IN NUMBER --:= FND_API.G_MISS_NUM
151: , p_Restore_From_Version IN NUMBER --:= FND_API.G_MISS_NUM
152: , p_chg_request_id IN NUMBER
153: , p_version_reason_code IN VARCHAR2
154: , x_New_Version OUT NOCOPY NUMBER
155: ) IS

Line 166: or p_Contract_Num_Modifier = FND_API.G_MISS_CHAR )

162: select id
163: from okc_k_headers_b
164: where contract_number = p_Contract_Number
165: and ( ( ( p_Contract_Num_Modifier IS NULL
166: or p_Contract_Num_Modifier = FND_API.G_MISS_CHAR )
167: and contract_number_modifier IS NULL )
168: or ( contract_number_modifier = p_Contract_Num_Modifier )
169: );
170: */

Line 184: IF NOT FND_API.Compatible_API_Call( l_api_version

180:
181: --
182: -- Check API incompatibility
183: --
184: IF NOT FND_API.Compatible_API_Call( l_api_version
185: , p_api_version
186: , l_api_name
187: , G_PKG_NAME )
188: THEN

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: , p_api_version
186: , l_api_name
187: , G_PKG_NAME )
188: THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: --
193: -- Initialize the message table if requested.

Line 195: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

191:
192: --
193: -- Initialize the message table if requested.
194: --
195: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198:
199: --

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198:
199: --
200: -- Set API return status to success
201: --
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: l_chr_id := p_Contract_Header_ID;
205:
206: /*

Line 233: IF FND_API.To_Boolean( p_commit ) THEN

229:
230: --
231: -- Standard commit check
232: --
233: IF FND_API.To_Boolean( p_commit ) THEN
234: COMMIT WORK;
235: END IF;
236:
237: --

Line 245: WHEN FND_API.G_EXC_ERROR THEN

241: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
242: , p_data => x_msg_data );
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO rstr_contract_version_pub;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
249: , p_data => x_msg_data );

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO rstr_contract_version_pub;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
249: , p_data => x_msg_data );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

247: x_return_status := FND_API.G_RET_STS_ERROR;
248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
249: , p_data => x_msg_data );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO rstr_contract_version_pub;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
255: , p_data => x_msg_data );

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249: , p_data => x_msg_data );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO rstr_contract_version_pub;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
255: , p_data => x_msg_data );
256:
257: WHEN OTHERS THEN

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

255: , p_data => x_msg_data );
256:
257: WHEN OTHERS THEN
258: ROLLBACK TO rstr_contract_version_pub;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
261: FND_MSG_PUB.add_exc_msg
262: ( p_pkg_name => G_PKG_NAME
263: , p_procedure_name => l_api_name );