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

Line 37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

33:
34: PROCEDURE RENEW_CONTRACT
35: (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_chr_id IN NUMBER,
40: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,
41: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,

Line 38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

34: PROCEDURE RENEW_CONTRACT
35: (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_chr_id IN NUMBER,
40: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,
41: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,
42: p_new_start_date IN DATE,

Line 67: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

63: END IF;
64:
65: --standard api initilization and checks
66: SAVEPOINT renew_contract_PUB;
67: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: IF FND_API.to_boolean(p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize;

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64:
65: --standard api initilization and checks
66: SAVEPOINT renew_contract_PUB;
67: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: IF FND_API.to_boolean(p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize;
72: END IF;

Line 70: IF FND_API.to_boolean(p_init_msg_list ) THEN

66: SAVEPOINT renew_contract_PUB;
67: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: IF FND_API.to_boolean(p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: END IF;
70: IF FND_API.to_boolean(p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: OKS_RENEW_CONTRACT_PVT.renew_contract(
76: p_api_version => 1,
77: p_init_msg_list => FND_API.G_FALSE,

Line 77: p_init_msg_list => FND_API.G_FALSE,

73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: OKS_RENEW_CONTRACT_PVT.renew_contract(
76: p_api_version => 1,
77: p_init_msg_list => FND_API.G_FALSE,
78: p_commit => FND_API.G_FALSE,
79: p_chr_id => p_chr_id,
80: p_new_contract_number => p_new_contract_number,
81: p_new_contract_modifier => p_new_contract_modifier,

Line 78: p_commit => FND_API.G_FALSE,

74:
75: OKS_RENEW_CONTRACT_PVT.renew_contract(
76: p_api_version => 1,
77: p_init_msg_list => FND_API.G_FALSE,
78: p_commit => FND_API.G_FALSE,
79: p_chr_id => p_chr_id,
80: p_new_contract_number => p_new_contract_number,
81: p_new_contract_modifier => p_new_contract_modifier,
82: p_new_start_date => p_new_start_date,

Line 92: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

88: x_msg_count => x_msg_count,
89: x_msg_data => x_msg_data,
90: x_return_status => x_return_status);
91:
92: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;
94: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: END IF;

Line 93: RAISE FND_API.g_exc_unexpected_error;

89: x_msg_data => x_msg_data,
90: x_return_status => x_return_status);
91:
92: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;
94: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: END IF;
97:

Line 94: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

90: x_return_status => x_return_status);
91:
92: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;
94: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: END IF;
97:
98: --standard check of p_commit

Line 95: RAISE FND_API.g_exc_error;

91:
92: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;
94: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: END IF;
97:
98: --standard check of p_commit
99: IF FND_API.to_boolean( p_commit ) THEN

Line 99: IF FND_API.to_boolean( p_commit ) THEN

95: RAISE FND_API.g_exc_error;
96: END IF;
97:
98: --standard check of p_commit
99: IF FND_API.to_boolean( p_commit ) THEN
100: COMMIT;
101: END IF;
102:
103: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 109: WHEN FND_API.g_exc_error THEN

105: END IF;
106: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
107:
108: EXCEPTION
109: WHEN FND_API.g_exc_error THEN
110: ROLLBACK TO renew_contract_PUB;
111: x_return_status := FND_API.g_ret_sts_error ;
112:
113: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

Line 111: x_return_status := FND_API.g_ret_sts_error ;

107:
108: EXCEPTION
109: WHEN FND_API.g_exc_error THEN
110: ROLLBACK TO renew_contract_PUB;
111: x_return_status := FND_API.g_ret_sts_error ;
112:
113: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
114: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
115: END IF;

Line 118: WHEN FND_API.g_exc_unexpected_error THEN

114: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
115: END IF;
116: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
117:
118: WHEN FND_API.g_exc_unexpected_error THEN
119: ROLLBACK TO renew_contract_PUB;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
121:
122: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

Line 120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

116: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
117:
118: WHEN FND_API.g_exc_unexpected_error THEN
119: ROLLBACK TO renew_contract_PUB;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
121:
122: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
123: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
124: END IF;

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

125: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
126:
127: WHEN OTHERS THEN
128: ROLLBACK TO renew_contract_PUB;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130:
131: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
132: --first log the sqlerrm
133: l_error_text := substr (SQLERRM, 1, 240);

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

151: */
152: PROCEDURE VALIDATE_RENEWAL
153: (
154: p_api_version IN NUMBER DEFAULT 1,
155: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_chr_id IN NUMBER,

Line 179: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

175: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_date='||p_date||' ,p_validation_level='||p_validation_level);
176: END IF;
177:
178: --standard api initilization and checks
179: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182: IF FND_API.to_boolean(p_init_msg_list ) THEN
183: FND_MSG_PUB.initialize;

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176: END IF;
177:
178: --standard api initilization and checks
179: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182: IF FND_API.to_boolean(p_init_msg_list ) THEN
183: FND_MSG_PUB.initialize;
184: END IF;

Line 182: IF FND_API.to_boolean(p_init_msg_list ) THEN

178: --standard api initilization and checks
179: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182: IF FND_API.to_boolean(p_init_msg_list ) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:

Line 185: x_return_status := FND_API.G_RET_STS_SUCCESS;

181: END IF;
182: IF FND_API.to_boolean(p_init_msg_list ) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:
187: OKS_RENEW_CONTRACT_PVT.validate_renewal(
188: p_api_version => 1,
189: p_init_msg_list => FND_API.G_FALSE,

Line 189: p_init_msg_list => FND_API.G_FALSE,

185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:
187: OKS_RENEW_CONTRACT_PVT.validate_renewal(
188: p_api_version => 1,
189: p_init_msg_list => FND_API.G_FALSE,
190: x_return_status => x_return_status,
191: x_msg_count => x_msg_count,
192: x_msg_data => x_msg_data,
193: p_chr_id => p_chr_id,

Line 200: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

196: x_rnrl_rec => x_rnrl_rec,
197: x_validation_status => x_validation_status,
198: x_validation_tbl => x_validation_tbl);
199:
200: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
201: RAISE FND_API.g_exc_unexpected_error;
202: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
203: RAISE FND_API.g_exc_error;
204: END IF;

Line 201: RAISE FND_API.g_exc_unexpected_error;

197: x_validation_status => x_validation_status,
198: x_validation_tbl => x_validation_tbl);
199:
200: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
201: RAISE FND_API.g_exc_unexpected_error;
202: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
203: RAISE FND_API.g_exc_error;
204: END IF;
205:

Line 202: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

198: x_validation_tbl => x_validation_tbl);
199:
200: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
201: RAISE FND_API.g_exc_unexpected_error;
202: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
203: RAISE FND_API.g_exc_error;
204: END IF;
205:
206:

Line 203: RAISE FND_API.g_exc_error;

199:
200: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
201: RAISE FND_API.g_exc_unexpected_error;
202: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
203: RAISE FND_API.g_exc_error;
204: END IF;
205:
206:
207: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 213: WHEN FND_API.g_exc_error THEN

209: END IF;
210: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
211:
212: EXCEPTION
213: WHEN FND_API.g_exc_error THEN
214: x_return_status := FND_API.g_ret_sts_error ;
215:
216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

Line 214: x_return_status := FND_API.g_ret_sts_error ;

210: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
211:
212: EXCEPTION
213: WHEN FND_API.g_exc_error THEN
214: x_return_status := FND_API.g_ret_sts_error ;
215:
216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
218: END IF;

Line 221: WHEN FND_API.g_exc_unexpected_error THEN

217: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
218: END IF;
219: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
220:
221: WHEN FND_API.g_exc_unexpected_error THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:
224: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
225: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

218: END IF;
219: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
220:
221: WHEN FND_API.g_exc_unexpected_error THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:
224: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
225: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
226: END IF;

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

226: END IF;
227: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
228:
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
231:
232: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
233: --first log the sqlerrm
234: l_error_text := substr (SQLERRM, 1, 240);

Line 245: FND_API.G_TRUE = T, if a contract is valid for renewal,

241: END VALIDATE_RENEWAL;
242:
243: /*
244: Utility function that returns
245: FND_API.G_TRUE = T, if a contract is valid for renewal,
246: FND_API.G_FALSE = F, if contract cannot be renewed because of warnings (for e.g., all the
247: lines in the contract have terminated) or errors (for e.g., the contract is in ENTERED status)
248: In case of other errors, logs the error message and returns F.
249:

Line 246: FND_API.G_FALSE = F, if contract cannot be renewed because of warnings (for e.g., all the

242:
243: /*
244: Utility function that returns
245: FND_API.G_TRUE = T, if a contract is valid for renewal,
246: FND_API.G_FALSE = F, if contract cannot be renewed because of warnings (for e.g., all the
247: lines in the contract have terminated) or errors (for e.g., the contract is in ENTERED status)
248: In case of other errors, logs the error message and returns F.
249:
250: This function should be used when setting up independent conditions (events) for contract

Line 280: l_return_status := FND_API.G_RET_STS_SUCCESS;

276: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
277: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);
278: END IF;
279:
280: l_return_status := FND_API.G_RET_STS_SUCCESS;
281: OKS_RENEW_CONTRACT_PVT.validate_renewal(p_api_version => 1,
282: p_init_msg_list => FND_API.G_FALSE,
283: x_return_status => l_return_status,
284: x_msg_count => l_msg_count,

Line 282: p_init_msg_list => FND_API.G_FALSE,

278: END IF;
279:
280: l_return_status := FND_API.G_RET_STS_SUCCESS;
281: OKS_RENEW_CONTRACT_PVT.validate_renewal(p_api_version => 1,
282: p_init_msg_list => FND_API.G_FALSE,
283: x_return_status => l_return_status,
284: x_msg_count => l_msg_count,
285: x_msg_data => l_msg_data,
286: p_chr_id => p_chr_id,

Line 293: IF( (l_return_status = FND_API.g_ret_sts_success) AND

289: x_rnrl_rec => l_rnrl_rec,
290: x_validation_status => l_validation_status,
291: x_validation_tbl => l_validation_tbl);
292:
293: IF( (l_return_status = FND_API.g_ret_sts_success) AND
294: (l_validation_status = G_VALID_STS_SUCCESS) ) THEN
295: l_return_value := FND_API.G_TRUE; --T
296: ELSE
297: --all other conditions return false

Line 295: l_return_value := FND_API.G_TRUE; --T

291: x_validation_tbl => l_validation_tbl);
292:
293: IF( (l_return_status = FND_API.g_ret_sts_success) AND
294: (l_validation_status = G_VALID_STS_SUCCESS) ) THEN
295: l_return_value := FND_API.G_TRUE; --T
296: ELSE
297: --all other conditions return false
298: l_return_value := FND_API.G_FALSE; --F
299: END IF;

Line 298: l_return_value := FND_API.G_FALSE; --F

294: (l_validation_status = G_VALID_STS_SUCCESS) ) THEN
295: l_return_value := FND_API.G_TRUE; --T
296: ELSE
297: --all other conditions return false
298: l_return_value := FND_API.G_FALSE; --F
299: END IF;
300:
301: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
302: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'l_return_status='||l_return_status||' ,l_validation_status='||l_validation_status||' ,l_return_value='||l_return_value);

Line 318: l_return_value := FND_API.G_FALSE; --F

314: --then add it to the message api list
315: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
316: END IF;
317:
318: l_return_value := FND_API.G_FALSE; --F
319: RETURN l_return_value;
320:
321: END VALID_FOR_RENEWAL;
322:

Line 334: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

330: */
331: PROCEDURE UPDATE_INVOICE_TEXT
332: (
333: p_api_version IN NUMBER DEFAULT 1,
334: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
335: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,

Line 335: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

331: PROCEDURE UPDATE_INVOICE_TEXT
332: (
333: p_api_version IN NUMBER DEFAULT 1,
334: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
335: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,
339: p_chr_id IN NUMBER

Line 355: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

351: END IF;
352:
353: --standard api initilization and checks
354: SAVEPOINT update_invoice_text_PUB;
355: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: IF FND_API.to_boolean(p_init_msg_list ) THEN
359: FND_MSG_PUB.initialize;

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352:
353: --standard api initilization and checks
354: SAVEPOINT update_invoice_text_PUB;
355: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: IF FND_API.to_boolean(p_init_msg_list ) THEN
359: FND_MSG_PUB.initialize;
360: END IF;

Line 358: IF FND_API.to_boolean(p_init_msg_list ) THEN

354: SAVEPOINT update_invoice_text_PUB;
355: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: IF FND_API.to_boolean(p_init_msg_list ) THEN
359: FND_MSG_PUB.initialize;
360: END IF;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

357: END IF;
358: IF FND_API.to_boolean(p_init_msg_list ) THEN
359: FND_MSG_PUB.initialize;
360: END IF;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: OKS_RENEW_CONTRACT_PVT.update_invoice_text(
364: p_api_version => 1,
365: p_init_msg_list => FND_API.G_FALSE,

Line 365: p_init_msg_list => FND_API.G_FALSE,

361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: OKS_RENEW_CONTRACT_PVT.update_invoice_text(
364: p_api_version => 1,
365: p_init_msg_list => FND_API.G_FALSE,
366: p_commit => FND_API.G_FALSE,
367: x_return_status => x_return_status,
368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data,

Line 366: p_commit => FND_API.G_FALSE,

362:
363: OKS_RENEW_CONTRACT_PVT.update_invoice_text(
364: p_api_version => 1,
365: p_init_msg_list => FND_API.G_FALSE,
366: p_commit => FND_API.G_FALSE,
367: x_return_status => x_return_status,
368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data,
370: p_chr_id => p_chr_id);

Line 372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data,
370: p_chr_id => p_chr_id);
371:
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;
374: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
375: RAISE FND_API.g_exc_error;
376: END IF;

Line 373: RAISE FND_API.g_exc_unexpected_error;

369: x_msg_data => x_msg_data,
370: p_chr_id => p_chr_id);
371:
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;
374: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
375: RAISE FND_API.g_exc_error;
376: END IF;
377:

Line 374: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

370: p_chr_id => p_chr_id);
371:
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;
374: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
375: RAISE FND_API.g_exc_error;
376: END IF;
377:
378: --standard check of p_commit

Line 375: RAISE FND_API.g_exc_error;

371:
372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;
374: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
375: RAISE FND_API.g_exc_error;
376: END IF;
377:
378: --standard check of p_commit
379: IF FND_API.to_boolean( p_commit ) THEN

Line 379: IF FND_API.to_boolean( p_commit ) THEN

375: RAISE FND_API.g_exc_error;
376: END IF;
377:
378: --standard check of p_commit
379: IF FND_API.to_boolean( p_commit ) THEN
380: COMMIT;
381: END IF;
382:
383: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 389: WHEN FND_API.g_exc_error THEN

385: END IF;
386: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
387:
388: EXCEPTION
389: WHEN FND_API.g_exc_error THEN
390: ROLLBACK TO update_invoice_text_PUB;
391: x_return_status := FND_API.g_ret_sts_error ;
392:
393: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

Line 391: x_return_status := FND_API.g_ret_sts_error ;

387:
388: EXCEPTION
389: WHEN FND_API.g_exc_error THEN
390: ROLLBACK TO update_invoice_text_PUB;
391: x_return_status := FND_API.g_ret_sts_error ;
392:
393: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
394: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
395: END IF;

Line 398: WHEN FND_API.g_exc_unexpected_error THEN

394: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
395: END IF;
396: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
397:
398: WHEN FND_API.g_exc_unexpected_error THEN
399: ROLLBACK TO update_invoice_text_PUB;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

396: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
397:
398: WHEN FND_API.g_exc_unexpected_error THEN
399: ROLLBACK TO update_invoice_text_PUB;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
403: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
404: END IF;

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

405: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
406:
407: WHEN OTHERS THEN
408: ROLLBACK TO update_invoice_text_PUB;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410:
411: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
412: --first log the sqlerrm
413: l_error_text := substr (SQLERRM, 1, 240);

Line 437: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

433: */
434: PROCEDURE GET_USER_NAME
435: (
436: p_api_version IN NUMBER DEFAULT 1,
437: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_chr_id IN NUMBER,

Line 459: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

455: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_hdesk_user_id='||p_hdesk_user_id);
456: END IF;
457:
458: --standard api initilization and checks
459: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: IF FND_API.to_boolean(p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456: END IF;
457:
458: --standard api initilization and checks
459: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: IF FND_API.to_boolean(p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;
464: END IF;

Line 462: IF FND_API.to_boolean(p_init_msg_list ) THEN

458: --standard api initilization and checks
459: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: IF FND_API.to_boolean(p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:

Line 465: x_return_status := FND_API.G_RET_STS_SUCCESS;

461: END IF;
462: IF FND_API.to_boolean(p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: OKS_RENEW_CONTRACT_PVT.get_user_name(
468: p_api_version => 1,
469: p_init_msg_list => FND_API.G_FALSE,

Line 469: p_init_msg_list => FND_API.G_FALSE,

465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: OKS_RENEW_CONTRACT_PVT.get_user_name(
468: p_api_version => 1,
469: p_init_msg_list => FND_API.G_FALSE,
470: x_return_status => x_return_status,
471: x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data,
473: p_chr_id => p_chr_id,

Line 478: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

474: p_hdesk_user_id => p_hdesk_user_id,
475: x_user_id => x_user_id,
476: x_user_name => x_user_name);
477:
478: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
479: RAISE FND_API.g_exc_unexpected_error;
480: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
481: RAISE FND_API.g_exc_error;
482: END IF;

Line 479: RAISE FND_API.g_exc_unexpected_error;

475: x_user_id => x_user_id,
476: x_user_name => x_user_name);
477:
478: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
479: RAISE FND_API.g_exc_unexpected_error;
480: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
481: RAISE FND_API.g_exc_error;
482: END IF;
483:

Line 480: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

476: x_user_name => x_user_name);
477:
478: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
479: RAISE FND_API.g_exc_unexpected_error;
480: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
481: RAISE FND_API.g_exc_error;
482: END IF;
483:
484: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 481: RAISE FND_API.g_exc_error;

477:
478: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
479: RAISE FND_API.g_exc_unexpected_error;
480: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
481: RAISE FND_API.g_exc_error;
482: END IF;
483:
484: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
485: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_user_id='||x_user_id||' ,x_user_name='||x_user_name);

Line 490: WHEN FND_API.g_exc_error THEN

486: END IF;
487: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
488:
489: EXCEPTION
490: WHEN FND_API.g_exc_error THEN
491: x_return_status := FND_API.g_ret_sts_error ;
492:
493: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
494: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

Line 491: x_return_status := FND_API.g_ret_sts_error ;

487: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
488:
489: EXCEPTION
490: WHEN FND_API.g_exc_error THEN
491: x_return_status := FND_API.g_ret_sts_error ;
492:
493: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
494: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
495: END IF;

Line 498: WHEN FND_API.g_exc_unexpected_error THEN

494: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
495: END IF;
496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
497:
498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500:
501: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

495: END IF;
496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
497:
498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500:
501: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
503: END IF;

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

503: END IF;
504: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
505:
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508:
509: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
510: --first log the sqlerrm
511: l_error_text := substr (SQLERRM, 1, 240);