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_UPDATE_PVT dependencies on PO_LOG

Line 8883: IF (PO_LOG.d_proc) THEN

8879: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';
8880: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.validate_delete_action';
8881:
8882: BEGIN
8883: IF (PO_LOG.d_proc) THEN
8884: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_entity', p_entity); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id);
8885: PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id);PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_distribution_id', p_distribution_id);
8886: END IF;
8887:

Line 8884: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_entity', p_entity); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id);

8880: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.validate_delete_action';
8881:
8882: BEGIN
8883: IF (PO_LOG.d_proc) THEN
8884: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_entity', p_entity); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id);
8885: PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id);PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_distribution_id', p_distribution_id);
8886: END IF;
8887:
8888: x_error_message := NULL;

Line 8885: PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id);PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_distribution_id', p_distribution_id);

8881:
8882: BEGIN
8883: IF (PO_LOG.d_proc) THEN
8884: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_entity', p_entity); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id);
8885: PO_LOG.proc_begin(d_module,'p_po_line_id', p_po_line_id);PO_LOG.proc_begin(d_module,'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module,'p_distribution_id', p_distribution_id);
8886: END IF;
8887:
8888: x_error_message := NULL;
8889: d_pos :=10;

Line 8913: IF (PO_LOG.d_stmt) THEN

8909: ,l_consigned_consumption_flag
8910: FROM po_headers_all
8911: WHERE po_header_id = p_doc_header_id;
8912:
8913: IF (PO_LOG.d_stmt) THEN
8914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype', l_doc_subtype); PO_LOG.stmt(d_module,d_pos,'l_closed_code', l_closed_code); PO_LOG.stmt(d_module,d_pos,'l_doc_approved_date', l_doc_approved_date);
8915: PO_LOG.stmt(d_module,d_pos,'l_doc_approved_flag', l_doc_approved_flag); PO_LOG.stmt(d_module,d_pos,'l_auth_status', l_auth_status); PO_LOG.stmt(d_module,d_pos,'l_frozen_flag', l_frozen_flag);
8916: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag', l_conterms_exist_flag); PO_LOG.stmt(d_module,d_pos,'l_consigned_consumption_flag',l_consigned_consumption_flag); PO_LOG.stmt(d_module,d_pos,'l_ga_flag', l_ga_flag);
8917: END IF;

Line 8914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype', l_doc_subtype); PO_LOG.stmt(d_module,d_pos,'l_closed_code', l_closed_code); PO_LOG.stmt(d_module,d_pos,'l_doc_approved_date', l_doc_approved_date);

8910: FROM po_headers_all
8911: WHERE po_header_id = p_doc_header_id;
8912:
8913: IF (PO_LOG.d_stmt) THEN
8914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype', l_doc_subtype); PO_LOG.stmt(d_module,d_pos,'l_closed_code', l_closed_code); PO_LOG.stmt(d_module,d_pos,'l_doc_approved_date', l_doc_approved_date);
8915: PO_LOG.stmt(d_module,d_pos,'l_doc_approved_flag', l_doc_approved_flag); PO_LOG.stmt(d_module,d_pos,'l_auth_status', l_auth_status); PO_LOG.stmt(d_module,d_pos,'l_frozen_flag', l_frozen_flag);
8916: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag', l_conterms_exist_flag); PO_LOG.stmt(d_module,d_pos,'l_consigned_consumption_flag',l_consigned_consumption_flag); PO_LOG.stmt(d_module,d_pos,'l_ga_flag', l_ga_flag);
8917: END IF;
8918:

Line 8915: PO_LOG.stmt(d_module,d_pos,'l_doc_approved_flag', l_doc_approved_flag); PO_LOG.stmt(d_module,d_pos,'l_auth_status', l_auth_status); PO_LOG.stmt(d_module,d_pos,'l_frozen_flag', l_frozen_flag);

8911: WHERE po_header_id = p_doc_header_id;
8912:
8913: IF (PO_LOG.d_stmt) THEN
8914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype', l_doc_subtype); PO_LOG.stmt(d_module,d_pos,'l_closed_code', l_closed_code); PO_LOG.stmt(d_module,d_pos,'l_doc_approved_date', l_doc_approved_date);
8915: PO_LOG.stmt(d_module,d_pos,'l_doc_approved_flag', l_doc_approved_flag); PO_LOG.stmt(d_module,d_pos,'l_auth_status', l_auth_status); PO_LOG.stmt(d_module,d_pos,'l_frozen_flag', l_frozen_flag);
8916: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag', l_conterms_exist_flag); PO_LOG.stmt(d_module,d_pos,'l_consigned_consumption_flag',l_consigned_consumption_flag); PO_LOG.stmt(d_module,d_pos,'l_ga_flag', l_ga_flag);
8917: END IF;
8918:
8919: -- checks for update privileges based on the status

Line 8916: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag', l_conterms_exist_flag); PO_LOG.stmt(d_module,d_pos,'l_consigned_consumption_flag',l_consigned_consumption_flag); PO_LOG.stmt(d_module,d_pos,'l_ga_flag', l_ga_flag);

8912:
8913: IF (PO_LOG.d_stmt) THEN
8914: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype', l_doc_subtype); PO_LOG.stmt(d_module,d_pos,'l_closed_code', l_closed_code); PO_LOG.stmt(d_module,d_pos,'l_doc_approved_date', l_doc_approved_date);
8915: PO_LOG.stmt(d_module,d_pos,'l_doc_approved_flag', l_doc_approved_flag); PO_LOG.stmt(d_module,d_pos,'l_auth_status', l_auth_status); PO_LOG.stmt(d_module,d_pos,'l_frozen_flag', l_frozen_flag);
8916: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag', l_conterms_exist_flag); PO_LOG.stmt(d_module,d_pos,'l_consigned_consumption_flag',l_consigned_consumption_flag); PO_LOG.stmt(d_module,d_pos,'l_ga_flag', l_ga_flag);
8917: END IF;
8918:
8919: -- checks for update privileges based on the status
8920: -- FROZEN, CANCELLED, FINALLY CLOSED

Line 8947: IF (PO_LOG.d_stmt) THEN

8943: PO_SECURITY_CHECK_SV.check_before_lock(l_doc_subtype,
8944: p_doc_header_id,
8945: fnd_global.employee_id,
8946: l_modify_action_allowed);
8947: IF (PO_LOG.d_stmt) THEN
8948: PO_LOG.stmt(d_module,d_pos,'l_modify_action_allowed', l_modify_action_allowed);
8949: END IF;
8950:
8951: IF NOT l_modify_action_allowed

Line 8948: PO_LOG.stmt(d_module,d_pos,'l_modify_action_allowed', l_modify_action_allowed);

8944: p_doc_header_id,
8945: fnd_global.employee_id,
8946: l_modify_action_allowed);
8947: IF (PO_LOG.d_stmt) THEN
8948: PO_LOG.stmt(d_module,d_pos,'l_modify_action_allowed', l_modify_action_allowed);
8949: END IF;
8950:
8951: IF NOT l_modify_action_allowed
8952: THEN

Line 8962: IF (PO_LOG.d_stmt) THEN

8958: l_style_disp_name := PO_DOC_STYLE_PVT.get_style_display_name(
8959: p_doc_id => p_doc_header_id,
8960: p_language => NULL);
8961:
8962: IF (PO_LOG.d_stmt) THEN
8963: PO_LOG.stmt(d_module,d_pos,'l_style_disp_name', l_style_disp_name);
8964: END IF;
8965:
8966: d_pos := 60;

Line 8963: PO_LOG.stmt(d_module,d_pos,'l_style_disp_name', l_style_disp_name);

8959: p_doc_id => p_doc_header_id,
8960: p_language => NULL);
8961:
8962: IF (PO_LOG.d_stmt) THEN
8963: PO_LOG.stmt(d_module,d_pos,'l_style_disp_name', l_style_disp_name);
8964: END IF;
8965:
8966: d_pos := 60;
8967: IF p_entity = PO_CORE_S.g_doc_level_HEADER

Line 9018: IF (PO_LOG.d_proc) THEN

9014: IF x_error_message is NOT NULL THEN
9015: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
9016: END IF;
9017:
9018: IF (PO_LOG.d_proc) THEN
9019: PO_LOG.proc_end(d_module);
9020: END IF;
9021:
9022: EXCEPTION

Line 9019: PO_LOG.proc_end(d_module);

9015: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
9016: END IF;
9017:
9018: IF (PO_LOG.d_proc) THEN
9019: PO_LOG.proc_end(d_module);
9020: END IF;
9021:
9022: EXCEPTION
9023: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

Line 9024: IF (PO_LOG.d_stmt) THEN

9020: END IF;
9021:
9022: EXCEPTION
9023: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
9024: IF (PO_LOG.d_stmt) THEN
9025: PO_LOG.stmt(d_module,d_pos,'x_error_message', x_error_message);
9026: END IF;
9027: WHEN OTHERS THEN
9028: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

Line 9025: PO_LOG.stmt(d_module,d_pos,'x_error_message', x_error_message);

9021:
9022: EXCEPTION
9023: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
9024: IF (PO_LOG.d_stmt) THEN
9025: PO_LOG.stmt(d_module,d_pos,'x_error_message', x_error_message);
9026: END IF;
9027: WHEN OTHERS THEN
9028: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9029: IF PO_LOG.d_exc THEN

Line 9029: IF PO_LOG.d_exc THEN

9025: PO_LOG.stmt(d_module,d_pos,'x_error_message', x_error_message);
9026: END IF;
9027: WHEN OTHERS THEN
9028: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9029: IF PO_LOG.d_exc THEN
9030: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9031: END IF;
9032: RAISE;
9033: END validate_delete_action;

Line 9030: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);

9026: END IF;
9027: WHEN OTHERS THEN
9028: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9029: IF PO_LOG.d_exc THEN
9030: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9031: END IF;
9032: RAISE;
9033: END validate_delete_action;
9034: -----------------------------------------------------------------------------

Line 9109: IF (PO_LOG.d_proc) THEN

9105: l_api_name CONSTANT VARCHAR2(30) := 'process_delete_action';
9106: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';
9107:
9108: BEGIN
9109: IF (PO_LOG.d_proc) THEN
9110: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list); PO_LOG.proc_begin(d_module, 'p_entity', p_entity); PO_LOG.proc_begin(d_module, 'p_entity_row_id', p_entity_row_id);
9111: PO_LOG.proc_begin(d_module, 'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module, 'p_doc_subtype', p_doc_subtype); PO_LOG.proc_begin(d_module, 'p_doc_header_id', p_doc_header_id);
9112: PO_LOG.proc_begin(d_module, 'p_ga_flag', p_ga_flag); PO_LOG.proc_begin(d_module, 'p_conterms_exist_flag', p_conterms_exist_flag); PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
9113: PO_LOG.proc_begin(d_module, 'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module, 'p_distribution_id', p_distribution_id);

Line 9110: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list); PO_LOG.proc_begin(d_module, 'p_entity', p_entity); PO_LOG.proc_begin(d_module, 'p_entity_row_id', p_entity_row_id);

9106: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';
9107:
9108: BEGIN
9109: IF (PO_LOG.d_proc) THEN
9110: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list); PO_LOG.proc_begin(d_module, 'p_entity', p_entity); PO_LOG.proc_begin(d_module, 'p_entity_row_id', p_entity_row_id);
9111: PO_LOG.proc_begin(d_module, 'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module, 'p_doc_subtype', p_doc_subtype); PO_LOG.proc_begin(d_module, 'p_doc_header_id', p_doc_header_id);
9112: PO_LOG.proc_begin(d_module, 'p_ga_flag', p_ga_flag); PO_LOG.proc_begin(d_module, 'p_conterms_exist_flag', p_conterms_exist_flag); PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
9113: PO_LOG.proc_begin(d_module, 'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module, 'p_distribution_id', p_distribution_id);
9114: END IF;

Line 9111: PO_LOG.proc_begin(d_module, 'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module, 'p_doc_subtype', p_doc_subtype); PO_LOG.proc_begin(d_module, 'p_doc_header_id', p_doc_header_id);

9107:
9108: BEGIN
9109: IF (PO_LOG.d_proc) THEN
9110: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list); PO_LOG.proc_begin(d_module, 'p_entity', p_entity); PO_LOG.proc_begin(d_module, 'p_entity_row_id', p_entity_row_id);
9111: PO_LOG.proc_begin(d_module, 'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module, 'p_doc_subtype', p_doc_subtype); PO_LOG.proc_begin(d_module, 'p_doc_header_id', p_doc_header_id);
9112: PO_LOG.proc_begin(d_module, 'p_ga_flag', p_ga_flag); PO_LOG.proc_begin(d_module, 'p_conterms_exist_flag', p_conterms_exist_flag); PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
9113: PO_LOG.proc_begin(d_module, 'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module, 'p_distribution_id', p_distribution_id);
9114: END IF;
9115: -- Standard start of API savepoint

Line 9112: PO_LOG.proc_begin(d_module, 'p_ga_flag', p_ga_flag); PO_LOG.proc_begin(d_module, 'p_conterms_exist_flag', p_conterms_exist_flag); PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);

9108: BEGIN
9109: IF (PO_LOG.d_proc) THEN
9110: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list); PO_LOG.proc_begin(d_module, 'p_entity', p_entity); PO_LOG.proc_begin(d_module, 'p_entity_row_id', p_entity_row_id);
9111: PO_LOG.proc_begin(d_module, 'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module, 'p_doc_subtype', p_doc_subtype); PO_LOG.proc_begin(d_module, 'p_doc_header_id', p_doc_header_id);
9112: PO_LOG.proc_begin(d_module, 'p_ga_flag', p_ga_flag); PO_LOG.proc_begin(d_module, 'p_conterms_exist_flag', p_conterms_exist_flag); PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
9113: PO_LOG.proc_begin(d_module, 'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module, 'p_distribution_id', p_distribution_id);
9114: END IF;
9115: -- Standard start of API savepoint
9116: SAVEPOINT PO_PROCESS_DELETE_ACTION;

Line 9113: PO_LOG.proc_begin(d_module, 'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module, 'p_distribution_id', p_distribution_id);

9109: IF (PO_LOG.d_proc) THEN
9110: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list); PO_LOG.proc_begin(d_module, 'p_entity', p_entity); PO_LOG.proc_begin(d_module, 'p_entity_row_id', p_entity_row_id);
9111: PO_LOG.proc_begin(d_module, 'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module, 'p_doc_subtype', p_doc_subtype); PO_LOG.proc_begin(d_module, 'p_doc_header_id', p_doc_header_id);
9112: PO_LOG.proc_begin(d_module, 'p_ga_flag', p_ga_flag); PO_LOG.proc_begin(d_module, 'p_conterms_exist_flag', p_conterms_exist_flag); PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
9113: PO_LOG.proc_begin(d_module, 'p_line_loc_id', p_line_loc_id); PO_LOG.proc_begin(d_module, 'p_distribution_id', p_distribution_id);
9114: END IF;
9115: -- Standard start of API savepoint
9116: SAVEPOINT PO_PROCESS_DELETE_ACTION;
9117:

Line 9155: IF (PO_LOG.d_stmt) THEN

9151: ,p_distribution_id => p_distribution_id
9152: ,x_error_message => l_error_message);
9153:
9154: d_pos := 20;
9155: IF (PO_LOG.d_stmt) THEN
9156: PO_LOG.stmt(d_module,d_pos,'l_error_message',l_error_message);
9157: END IF;
9158:
9159: IF l_error_message is NOT NULL

Line 9156: PO_LOG.stmt(d_module,d_pos,'l_error_message',l_error_message);

9152: ,x_error_message => l_error_message);
9153:
9154: d_pos := 20;
9155: IF (PO_LOG.d_stmt) THEN
9156: PO_LOG.stmt(d_module,d_pos,'l_error_message',l_error_message);
9157: END IF;
9158:
9159: IF l_error_message is NOT NULL
9160: THEN

Line 9177: IF (PO_LOG.d_stmt) THEN

9173: ,p_doc_header_id => p_doc_header_id
9174: ,p_ga_flag => p_ga_flag
9175: ,p_conterms_exist_flag => p_conterms_exist_flag
9176: ,x_return_status => x_return_status);
9177: IF (PO_LOG.d_stmt) THEN
9178: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
9179: END IF;
9180: ELSIF p_entity = PO_CORE_S.g_doc_level_LINE
9181: THEN

Line 9178: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);

9174: ,p_ga_flag => p_ga_flag
9175: ,p_conterms_exist_flag => p_conterms_exist_flag
9176: ,x_return_status => x_return_status);
9177: IF (PO_LOG.d_stmt) THEN
9178: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
9179: END IF;
9180: ELSIF p_entity = PO_CORE_S.g_doc_level_LINE
9181: THEN
9182:

Line 9225: IF (PO_LOG.d_proc) THEN

9221: RAISE FND_API.g_exc_unexpected_error;
9222: END IF;
9223: --
9224:
9225: IF (PO_LOG.d_proc) THEN
9226: PO_LOG.proc_end(d_module);
9227: END IF;
9228: EXCEPTION
9229: WHEN FND_API.g_exc_error THEN

Line 9226: PO_LOG.proc_end(d_module);

9222: END IF;
9223: --
9224:
9225: IF (PO_LOG.d_proc) THEN
9226: PO_LOG.proc_end(d_module);
9227: END IF;
9228: EXCEPTION
9229: WHEN FND_API.g_exc_error THEN
9230: ROLLBACK TO PO_PROCESS_DELETE_ACTION;

Line 9237: IF (PO_LOG.d_stmt) THEN

9233: --Copy the messages on the list to the out parameter
9234: FOR I IN 1..FND_MSG_PUB.count_msg loop
9235: x_error_msg_tbl.extend;
9236: x_error_msg_tbl(I) := FND_MSG_PUB.get(I, 'F');
9237: IF (PO_LOG.d_stmt) THEN
9238: PO_LOG.stmt(d_module,d_pos,'x_error_msg_tbl(' || I || ')', x_error_msg_tbl(I));
9239: END IF;
9240: END LOOP;
9241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9238: PO_LOG.stmt(d_module,d_pos,'x_error_msg_tbl(' || I || ')', x_error_msg_tbl(I));

9234: FOR I IN 1..FND_MSG_PUB.count_msg loop
9235: x_error_msg_tbl.extend;
9236: x_error_msg_tbl(I) := FND_MSG_PUB.get(I, 'F');
9237: IF (PO_LOG.d_stmt) THEN
9238: PO_LOG.stmt(d_module,d_pos,'x_error_msg_tbl(' || I || ')', x_error_msg_tbl(I));
9239: END IF;
9240: END LOOP;
9241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9242: ROLLBACK TO PO_PROCESS_DELETE_ACTION;

Line 9244: IF PO_LOG.d_exc THEN

9240: END LOOP;
9241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9242: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9244: IF PO_LOG.d_exc THEN
9245: PO_LOG.exc(d_module,d_pos,'Unexpected Error in' || d_module);
9246: END IF;
9247: WHEN OTHERS THEN
9248: ROLLBACK TO PO_PROCESS_DELETE_ACTION;

Line 9245: PO_LOG.exc(d_module,d_pos,'Unexpected Error in' || d_module);

9241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9242: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9244: IF PO_LOG.d_exc THEN
9245: PO_LOG.exc(d_module,d_pos,'Unexpected Error in' || d_module);
9246: END IF;
9247: WHEN OTHERS THEN
9248: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9249: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 9251: IF PO_LOG.d_exc THEN

9247: WHEN OTHERS THEN
9248: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9249: x_return_status := FND_API.g_ret_sts_unexp_error;
9250: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9251: IF PO_LOG.d_exc THEN
9252: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9253: END IF;
9254: END process_delete_action;
9255:

Line 9252: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);

9248: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9249: x_return_status := FND_API.g_ret_sts_unexp_error;
9250: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9251: IF PO_LOG.d_exc THEN
9252: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9253: END IF;
9254: END process_delete_action;
9255:
9256: END PO_DOCUMENT_UPDATE_PVT;