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

Line 25: -- If FND_API.G_TRUE, the API will initialize the standard API message list.

21: --IN:
22: --p_api_version
23: -- API version number expected by the caller
24: --p_init_msg_list
25: -- If FND_API.G_TRUE, the API will initialize the standard API message list.
26: --p_document_type
27: -- type of document to lock: 'PO', 'PA', or 'RELEASE'
28: --p_document_id
29: -- ID of the document to lock - po_header_id for POs and PAs;

Line 33: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.

29: -- ID of the document to lock - po_header_id for POs and PAs;
30: -- po_release_id for releases
31: --OUT:
32: --x_return_status
33: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.
34: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because
35: -- the lock is being held by another session.
36: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as
37: -- invalid document type or document ID.

Line 34: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because

30: -- po_release_id for releases
31: --OUT:
32: --x_return_status
33: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.
34: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because
35: -- the lock is being held by another session.
36: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as
37: -- invalid document type or document ID.
38: --End of Comments

Line 36: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as

32: --x_return_status
33: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.
34: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because
35: -- the lock is being held by another session.
36: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as
37: -- invalid document type or document ID.
38: --End of Comments
39: -------------------------------------------------------------------------------
40: PROCEDURE lock_document (

Line 114: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,

110: END IF;
111: END IF;
112:
113: -- Standard API initialization:
114: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,
115: l_api_name, G_PKG_NAME ) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;
118:

Line 116: RAISE FND_API.g_exc_unexpected_error;

112:
113: -- Standard API initialization:
114: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,
115: l_api_name, G_PKG_NAME ) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;
118:
119: IF (FND_API.to_boolean(p_init_msg_list)) THEN
120: FND_MSG_PUB.initialize;

Line 119: IF (FND_API.to_boolean(p_init_msg_list)) THEN

115: l_api_name, G_PKG_NAME ) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;
118:
119: IF (FND_API.to_boolean(p_init_msg_list)) THEN
120: FND_MSG_PUB.initialize;
121: END IF;
122:
123: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 123: x_return_status := FND_API.G_RET_STS_SUCCESS;

119: IF (FND_API.to_boolean(p_init_msg_list)) THEN
120: FND_MSG_PUB.initialize;
121: END IF;
122:
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: -- For each document type, verify that the requested document exists,
126: -- then try to lock it.
127: IF (p_document_type = 'PO') THEN

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136: EXCEPTION
137: WHEN no_data_found THEN
138: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_IDS');
139: FND_MSG_PUB.add;
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END;
142:
143: -- Try to lock the PO.
144: OPEN lock_po_csr;

Line 147: RAISE FND_API.G_EXC_ERROR;

143: -- Try to lock the PO.
144: OPEN lock_po_csr;
145: FETCH lock_po_csr INTO l_dummy;
146: IF (lock_po_csr%NOTFOUND) THEN -- Cannot acquire the lock
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149: CLOSE lock_po_csr;
150:
151: ELSIF (p_document_type = 'PA') THEN

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160: EXCEPTION
161: WHEN no_data_found THEN
162: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_IDS');
163: FND_MSG_PUB.add;
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END;
166:
167: -- Try to lock the PA.
168: OPEN lock_pa_csr;

Line 171: RAISE FND_API.G_EXC_ERROR;

167: -- Try to lock the PA.
168: OPEN lock_pa_csr;
169: FETCH lock_pa_csr INTO l_dummy;
170: IF (lock_pa_csr%NOTFOUND) THEN -- Cannot acquire the lock
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173: CLOSE lock_pa_csr;
174:
175: ELSIF (p_document_type = 'RELEASE') THEN

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183: EXCEPTION
184: WHEN no_data_found THEN
185: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_IDS');
186: FND_MSG_PUB.add;
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END;
189:
190: -- Try to lock the release.
191: OPEN lock_release_csr;

Line 194: RAISE FND_API.G_EXC_ERROR;

190: -- Try to lock the release.
191: OPEN lock_release_csr;
192: FETCH lock_release_csr INTO l_dummy;
193: IF (lock_release_csr%NOTFOUND) THEN -- Cannot acquire the lock
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196: CLOSE lock_release_csr;
197:
198: --

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: EXCEPTION
208: WHEN no_data_found THEN
209: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_IDS');
210: FND_MSG_PUB.add;
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END;
213:
214: -- Try to lock the requisition.
215: OPEN lock_req_csr;

Line 218: RAISE FND_API.G_EXC_ERROR;

214: -- Try to lock the requisition.
215: OPEN lock_req_csr;
216: FETCH lock_req_csr INTO l_dummy;
217: IF (lock_req_csr%NOTFOUND) THEN -- Cannot acquire the lock
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: CLOSE lock_req_csr;
221:
222: --

Line 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224:
225: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_TYPE');
226: FND_MESSAGE.set_token('TYPE', p_document_type);
227: FND_MSG_PUB.add;
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229:
230: END IF; -- p_document_type
231:
232: IF (g_fnd_debug = 'Y') THEN

Line 239: WHEN FND_API.G_EXC_ERROR OR resource_busy_exc THEN -- Cannot acquire the lock

235: 'Exiting ' || l_api_name );
236: END IF;
237: END IF;
238: EXCEPTION
239: WHEN FND_API.G_EXC_ERROR OR resource_busy_exc THEN -- Cannot acquire the lock
240: FND_MESSAGE.set_name('PO', 'PO_DOC_CANNOT_LOCK');
241: FND_MSG_PUB.add;
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: IF (g_fnd_debug = 'Y') THEN

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: EXCEPTION
239: WHEN FND_API.G_EXC_ERROR OR resource_busy_exc THEN -- Cannot acquire the lock
240: FND_MESSAGE.set_name('PO', 'PO_DOC_CANNOT_LOCK');
241: FND_MSG_PUB.add;
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: IF (g_fnd_debug = 'Y') THEN
244: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
245: FND_LOG.string( FND_LOG.LEVEL_ERROR, g_module_prefix || l_api_name,
246: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,

Line 247: p_encoded => FND_API.G_FALSE) );

243: IF (g_fnd_debug = 'Y') THEN
244: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
245: FND_LOG.string( FND_LOG.LEVEL_ERROR, g_module_prefix || l_api_name,
246: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
247: p_encoded => FND_API.G_FALSE) );
248: END IF;
249: END IF;
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

246: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
247: p_encoded => FND_API.G_FALSE) );
248: END IF;
249: END IF;
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: IF (g_fnd_debug = 'Y') THEN
253: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
254: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: p_encoded => FND_API.G_FALSE) );
248: END IF;
249: END IF;
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: IF (g_fnd_debug = 'Y') THEN
253: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
254: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
255: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,

Line 256: p_encoded => FND_API.G_FALSE) );

252: IF (g_fnd_debug = 'Y') THEN
253: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
254: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
255: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
256: p_encoded => FND_API.G_FALSE) );
257: END IF;
258: END IF;
259: WHEN OTHERS THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

256: p_encoded => FND_API.G_FALSE) );
257: END IF;
258: END IF;
259: WHEN OTHERS THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.add_exc_msg ( G_PKG_NAME, l_api_name );
262: IF (g_fnd_debug = 'Y') THEN
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
264: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,

Line 266: p_encoded => FND_API.G_FALSE) );

262: IF (g_fnd_debug = 'Y') THEN
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
264: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
265: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
266: p_encoded => FND_API.G_FALSE) );
267: END IF;
268: END IF;
269: END lock_document;
270:

Line 291: -- If FND_API.G_TRUE, the API will initialize the standard API message list.

287: --IN:
288: -- p_api_version :
289: -- API version number expected by the caller
290: -- p_init_msg_list:
291: -- If FND_API.G_TRUE, the API will initialize the standard API message list.
292: -- po_sesiongt_key:
293: -- Docuements to be locked are manitined in po_session_gt
294: -- po_sesiongt_key is the key in po_session_gt to identify
295: -- the intended records in the table

Line 307: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.

303: -- Current User login ID
304:
305: --OUT:
306: --x_return_status
307: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.
308: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because
309: -- the lock is being held by another session.
310: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as
311: -- invalid document type or document ID.

Line 308: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because

304:
305: --OUT:
306: --x_return_status
307: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.
308: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because
309: -- the lock is being held by another session.
310: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as
311: -- invalid document type or document ID.
312: --End of Comments

Line 310: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as

306: --x_return_status
307: -- FND_API.G_RET_STS_SUCCESS if the API successfully locked the document.
308: -- FND_API.G_RET_STS_ERROR if the API could not lock the document, because
309: -- the lock is being held by another session.
310: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurred, such as
311: -- invalid document type or document ID.
312: --End of Comments
313: -------------------------------------------------------------------------------
314:

Line 419: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,

415: END IF;
416:
417:
418: -- Standard API initialization:
419: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,
420: d_api_name, G_PKG_NAME ) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423:

Line 421: RAISE FND_API.g_exc_unexpected_error;

417:
418: -- Standard API initialization:
419: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,
420: d_api_name, G_PKG_NAME ) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423:
424: IF (FND_API.to_boolean(p_init_msg_list)) THEN
425: FND_MSG_PUB.initialize;

Line 424: IF (FND_API.to_boolean(p_init_msg_list)) THEN

420: d_api_name, G_PKG_NAME ) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423:
424: IF (FND_API.to_boolean(p_init_msg_list)) THEN
425: FND_MSG_PUB.initialize;
426: END IF;
427:
428:

Line 465: x_return_status := FND_API.G_RET_STS_SUCCESS;

461: FETCH lock_release_csr BULK COLLECT INTO l_dummy;
462: CLOSE lock_release_csr;
463:
464:
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467:
468: IF (g_fnd_debug = 'Y') THEN
469: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 507: x_return_status := FND_API.G_RET_STS_ERROR;

503: ('PO_DOC_CANNOT_LOCK'),
504: 0,
505: 0);
506:
507: x_return_status := FND_API.G_RET_STS_ERROR;
508:
509: IF (g_fnd_debug = 'Y') THEN
510: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
511: FND_LOG.string( FND_LOG.LEVEL_ERROR, g_module_prefix || d_api_name,

Line 513: p_encoded => FND_API.G_FALSE) );

509: IF (g_fnd_debug = 'Y') THEN
510: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
511: FND_LOG.string( FND_LOG.LEVEL_ERROR, g_module_prefix || d_api_name,
512: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
513: p_encoded => FND_API.G_FALSE) );
514: END IF;
515: END IF;
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

513: p_encoded => FND_API.G_FALSE) );
514: END IF;
515: END IF;
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518:
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: IF (g_fnd_debug = 'Y') THEN
521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: END IF;
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518:
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: IF (g_fnd_debug = 'Y') THEN
521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
522: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || d_api_name,
523: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,

Line 524: p_encoded => FND_API.G_FALSE) );

520: IF (g_fnd_debug = 'Y') THEN
521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
522: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || d_api_name,
523: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
524: p_encoded => FND_API.G_FALSE) );
525: END IF;
526: END IF;
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: p_encoded => FND_API.G_FALSE) );
525: END IF;
526: END IF;
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MSG_PUB.add_exc_msg ( G_PKG_NAME, d_api_name );
530: IF (g_fnd_debug = 'Y') THEN
531: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
532: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || d_api_name,

Line 534: p_encoded => FND_API.G_FALSE) );

530: IF (g_fnd_debug = 'Y') THEN
531: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
532: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || d_api_name,
533: FND_MSG_PUB.get(p_msg_index => FND_MSG_PUB.G_LAST,
534: p_encoded => FND_API.G_FALSE) );
535: END IF;
536: END IF;
537: END lock_document;
538: