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(
83: p_po_header_id => p_po_header_id,
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;
98: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
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
102: FND_LOG.string(log_level => FND_LOG.level_unexpected
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
102: FND_LOG.string(log_level => FND_LOG.level_unexpected
103: ,module => g_module_prefix ||l_api_name
104: ,message => SQLERRM);
105: END IF;
106: END IF;
107: END IF;
108: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
109: ,p_data => x_msg_data);
110: END update_po_details;
111:
112: -------------------------------------------------------------------------------
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(
183: p_po_header_id => p_po_header_id,
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;
196: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
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
200: FND_LOG.string(log_level => FND_LOG.level_unexpected
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
200: FND_LOG.string(log_level => FND_LOG.level_unexpected
201: ,module => g_module_prefix ||l_api_name
202: ,message => SQLERRM);
203: END IF;
204: END IF;
205: END IF;
206: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
207: ,p_data => x_msg_data);
208: END get_item_key;
209:
210: -------------------------------------------------------------------------------
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(
283: p_po_header_id => p_po_header_id,
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;
296: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
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
300: FND_LOG.string(log_level => FND_LOG.level_unexpected
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
300: FND_LOG.string(log_level => FND_LOG.level_unexpected
301: ,module => g_module_prefix ||l_api_name
302: ,message => SQLERRM);
303: END IF;
304: END IF;
305: END IF;
306: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
307: ,p_data => x_msg_data);
308: END find_item_key;
309:
310: -------------------------------------------------------------------------------
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(
374: p_itemkey => p_itemkey,
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
384: FND_LOG.string(log_level => FND_LOG.level_unexpected
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
384: FND_LOG.string(log_level => FND_LOG.level_unexpected
385: ,module => g_module_prefix ||l_api_name
386: ,message => SQLERRM);
387: END IF;
388: END IF;
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
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
398: FND_LOG.string(log_level => FND_LOG.level_unexpected
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
398: FND_LOG.string(log_level => FND_LOG.level_unexpected
399: ,module => g_module_prefix ||l_api_name
400: ,message => SQLERRM);
401: END IF;
402: END IF;
403: END IF;
404: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
405: ,p_data => x_msg_data);
406:
407: END abort_doc_sign_process;
408: -------------------------------------------------------------------------------
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(
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
480: FND_LOG.string(log_level => FND_LOG.level_unexpected
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
480: FND_LOG.string(log_level => FND_LOG.level_unexpected
481: ,module => g_module_prefix ||l_api_name
482: ,message => SQLERRM);
483: END IF;
484: END IF;
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
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
494: FND_LOG.string(log_level => FND_LOG.level_unexpected
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
494: FND_LOG.string(log_level => FND_LOG.level_unexpected
495: ,module => g_module_prefix ||l_api_name
496: ,message => SQLERRM);
497: END IF;
498: END IF;
499: END IF;
500: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
501: ,p_data => x_msg_data);
502:
503: END erecords_enabled;
504: