DBA Data[Home] [Help]

APPS.PO_SIGNATURE_GRP dependencies on FND_API

Line 42: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

38: -- Message count
39: --x_msg_data
40: -- message data
41: --x_return_status
42: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
43:
44: --Testing:
45: -- Testing to be done based on the test cases in Document Binding DLD
46: --End of Comments

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

46: --End of Comments
47: -------------------------------------------------------------------------------
48:
49: PROCEDURE Update_Po_Details(p_api_version IN NUMBER, -- bug3488839
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_po_header_id IN NUMBER,
52: p_status IN VARCHAR2,
53: p_action_code IN VARCHAR2,
54: p_object_type_code IN VARCHAR2,

Line 67: IF NOT (FND_API.compatible_api_call(l_api_version

63: l_api_version CONSTANT NUMBER := 1.0; -- bug3488839
64:
65: BEGIN
66:
67: IF NOT (FND_API.compatible_api_call(l_api_version
68: ,p_api_version
69: ,l_api_name
70: ,g_pkg_name)) THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: IF NOT (FND_API.compatible_api_call(l_api_version
68: ,p_api_version
69: ,l_api_name
70: ,g_pkg_name)) THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- initialize API return status to success
75: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 75: x_return_status:= FND_API.G_RET_STS_SUCCESS;

71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- initialize API return status to success
75: x_return_status:= FND_API.G_RET_STS_SUCCESS;
76:
77: -- initialize meesage list
78: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
79: FND_MSG_PUB.initialize;

Line 78: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

74: -- initialize API return status to success
75: x_return_status:= FND_API.G_RET_STS_SUCCESS;
76:
77: -- initialize meesage list
78: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
79: FND_MSG_PUB.initialize;
80: END IF;
81:
82: PO_SIGNATURE_PVT.update_po_details(

Line 92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

88: p_employee_id => p_employee_id,
89: p_revision_num => p_revision_num);
90:
91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
95: ,p_data => x_msg_data);
96: WHEN OTHERS THEN

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

89: p_revision_num => p_revision_num);
90:
91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
95: ,p_data => x_msg_data);
96: WHEN OTHERS THEN
97: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 97: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
95: ,p_data => x_msg_data);
96: WHEN OTHERS THEN
97: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
99: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
100: IF (g_fnd_debug='Y') THEN
101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 141: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

137: -- Message count
138: --x_msg_data
139: -- message data
140: --x_return_status
141: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
142: --x_itemkey
143: -- Item key of the Document Signature Process
144: --Testing:
145: -- Testing to be done based on the test cases in Document Binding DLD

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

146: --End of Comments
147: -------------------------------------------------------------------------------
148:
149: PROCEDURE Get_Item_Key(p_api_version IN NUMBER, -- bug3488839
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_po_header_id IN NUMBER,
152: p_revision_num IN NUMBER,
153: p_document_type IN VARCHAR2,
154: x_itemkey OUT NOCOPY VARCHAR2,

Line 167: IF NOT (FND_API.compatible_api_call(l_api_version

163: l_api_version CONSTANT NUMBER := 1.0; -- bug3488839
164:
165: BEGIN
166:
167: IF NOT (FND_API.compatible_api_call(l_api_version
168: ,p_api_version
169: ,l_api_name
170: ,g_pkg_name)) THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: IF NOT (FND_API.compatible_api_call(l_api_version
168: ,p_api_version
169: ,l_api_name
170: ,g_pkg_name)) THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: -- initialize API return status to success
175: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 175: x_return_status:= FND_API.G_RET_STS_SUCCESS;

171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: -- initialize API return status to success
175: x_return_status:= FND_API.G_RET_STS_SUCCESS;
176:
177: -- initialize meesage list
178: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
179: FND_MSG_PUB.initialize;

Line 178: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

174: -- initialize API return status to success
175: x_return_status:= FND_API.G_RET_STS_SUCCESS;
176:
177: -- initialize meesage list
178: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
179: FND_MSG_PUB.initialize;
180: END IF;
181:
182: PO_SIGNATURE_PVT.get_item_key(

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: x_itemkey => x_itemkey,
187: x_result => x_result);
188:
189: EXCEPTION
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN OTHERS THEN

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: x_result => x_result);
188:
189: EXCEPTION
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN OTHERS THEN
195: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 195: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN OTHERS THEN
195: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
197: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
198: IF (g_fnd_debug='Y') THEN
199: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 239: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

235: -- Message count
236: --x_msg_data
237: -- message data
238: --x_return_status
239: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
240: --x_itemkey
241: -- Item key of the active Document Signature Process
242: --x_result
243: -- Returns 'S' for success and 'E' for Error

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

246: --End of Comments
247: -------------------------------------------------------------------------------
248:
249: PROCEDURE find_item_key(p_api_version IN NUMBER, -- bug3488839
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_po_header_id IN NUMBER,
252: p_revision_num IN NUMBER,
253: p_document_type IN VARCHAR2,
254: x_itemkey OUT NOCOPY VARCHAR2,

Line 267: IF NOT (FND_API.compatible_api_call(l_api_version

263: l_api_version CONSTANT NUMBER := 1.0; -- bug3488839
264:
265: BEGIN
266:
267: IF NOT (FND_API.compatible_api_call(l_api_version
268: ,p_api_version
269: ,l_api_name
270: ,g_pkg_name)) THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

267: IF NOT (FND_API.compatible_api_call(l_api_version
268: ,p_api_version
269: ,l_api_name
270: ,g_pkg_name)) THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273:
274: -- initialize API return status to success
275: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 275: x_return_status:= FND_API.G_RET_STS_SUCCESS;

271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273:
274: -- initialize API return status to success
275: x_return_status:= FND_API.G_RET_STS_SUCCESS;
276:
277: -- initialize meesage list
278: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
279: FND_MSG_PUB.initialize;

Line 278: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

274: -- initialize API return status to success
275: x_return_status:= FND_API.G_RET_STS_SUCCESS;
276:
277: -- initialize meesage list
278: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
279: FND_MSG_PUB.initialize;
280: END IF;
281:
282: PO_SIGNATURE_PVT.find_item_key(

Line 290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

286: x_itemkey => x_itemkey,
287: x_result => x_result);
288:
289: EXCEPTION
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN OTHERS THEN

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: x_result => x_result);
288:
289: EXCEPTION
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN OTHERS THEN
295: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 295: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN OTHERS THEN
295: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
297: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
298: IF (g_fnd_debug='Y') THEN
299: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 335: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

331: -- Message count
332: --x_msg_data
333: -- message data
334: --x_return_status
335: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
336: --x_result
337: -- Returns 'S' for success and 'E' for Error
338: --Testing:
339: -- Testing to be done based on the test cases in Document Binding DLD

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

340: --End of Comments
341: -------------------------------------------------------------------------------
342:
343: PROCEDURE abort_doc_sign_process(p_api_version IN NUMBER, -- bug3488839
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_itemkey IN VARCHAR2,
346: x_result OUT NOCOPY VARCHAR2,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,

Line 358: IF NOT (FND_API.compatible_api_call(l_api_version

354:
355:
356: BEGIN
357:
358: IF NOT (FND_API.compatible_api_call(l_api_version
359: ,p_api_version
360: ,l_api_name
361: ,g_pkg_name)) THEN
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

358: IF NOT (FND_API.compatible_api_call(l_api_version
359: ,p_api_version
360: ,l_api_name
361: ,g_pkg_name)) THEN
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: END IF;
364:
365: -- initialize API return status to success
366: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 366: x_return_status:= FND_API.G_RET_STS_SUCCESS;

362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: END IF;
364:
365: -- initialize API return status to success
366: x_return_status:= FND_API.G_RET_STS_SUCCESS;
367:
368: -- initialize meesage list
369: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
370: FND_MSG_PUB.initialize;

Line 369: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

365: -- initialize API return status to success
366: x_return_status:= FND_API.G_RET_STS_SUCCESS;
367:
368: -- initialize meesage list
369: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: PO_SIGNATURE_PVT.Abort_Doc_Sign_Process(

Line 378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

374: p_itemkey => p_itemkey,
375: x_result => x_result);
376:
377: EXCEPTION
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
381: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
382: IF (g_fnd_debug='Y') THEN

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375: x_result => x_result);
376:
377: EXCEPTION
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
381: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
382: IF (g_fnd_debug='Y') THEN
383: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 393: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: END IF;
390: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
391: ,p_data => x_msg_data);
392: WHEN OTHERS THEN
393: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: IF (g_fnd_debug='Y') THEN
397: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 432: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

428: -- Message count
429: --x_msg_data
430: -- message data
431: --x_return_status
432: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
433: --x_erecords_enabled
434: -- Returns 'Y' if eRecords patch is applied and eRecords is enabled.
435: -- Otherwise returns 'N'.
436: --Testing:

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

438: --End of Comments
439: -------------------------------------------------------------------------------
440:
441: PROCEDURE erecords_enabled(p_api_version IN NUMBER, -- bug3488839
442: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
443: x_erecords_enabled OUT NOCOPY VARCHAR2,
444: x_return_status OUT NOCOPY VARCHAR2,
445: x_msg_count OUT NOCOPY NUMBER,
446: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 455: IF NOT (FND_API.compatible_api_call(l_api_version

451:
452:
453: BEGIN
454:
455: IF NOT (FND_API.compatible_api_call(l_api_version
456: ,p_api_version
457: ,l_api_name
458: ,g_pkg_name)) THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

455: IF NOT (FND_API.compatible_api_call(l_api_version
456: ,p_api_version
457: ,l_api_name
458: ,g_pkg_name)) THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462: -- initialize API return status to success
463: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 463: x_return_status:= FND_API.G_RET_STS_SUCCESS;

459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462: -- initialize API return status to success
463: x_return_status:= FND_API.G_RET_STS_SUCCESS;
464:
465: -- initialize meesage list
466: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
467: FND_MSG_PUB.initialize;

Line 466: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

462: -- initialize API return status to success
463: x_return_status:= FND_API.G_RET_STS_SUCCESS;
464:
465: -- initialize meesage list
466: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469:
470: PO_ERECORDS_PVT.erecords_enabled(

Line 474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

470: PO_ERECORDS_PVT.erecords_enabled(
471: x_erecords_enabled => x_erecords_enabled);
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
477: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
478: IF (g_fnd_debug='Y') THEN

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: x_erecords_enabled => x_erecords_enabled);
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
477: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
478: IF (g_fnd_debug='Y') THEN
479: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 489: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: END IF;
486: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN OTHERS THEN
489: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
492: IF (g_fnd_debug='Y') THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN