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 9018: IF (PO_LOG.d_proc) THEN

9014: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';
9015: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.validate_delete_action';
9016:
9017: BEGIN
9018: IF (PO_LOG.d_proc) THEN
9019: 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);
9020: 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);
9021: END IF;
9022:

Line 9019: 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);

9015: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.validate_delete_action';
9016:
9017: BEGIN
9018: IF (PO_LOG.d_proc) THEN
9019: 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);
9020: 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);
9021: END IF;
9022:
9023: x_error_message := NULL;

Line 9020: 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);

9016:
9017: BEGIN
9018: IF (PO_LOG.d_proc) THEN
9019: 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);
9020: 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);
9021: END IF;
9022:
9023: x_error_message := NULL;
9024: d_pos :=10;

Line 9048: IF (PO_LOG.d_stmt) THEN

9044: ,l_consigned_consumption_flag
9045: FROM po_headers_all
9046: WHERE po_header_id = p_doc_header_id;
9047:
9048: IF (PO_LOG.d_stmt) THEN
9049: 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);
9050: 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);
9051: 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);
9052: END IF;

Line 9049: 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);

9045: FROM po_headers_all
9046: WHERE po_header_id = p_doc_header_id;
9047:
9048: IF (PO_LOG.d_stmt) THEN
9049: 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);
9050: 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);
9051: 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);
9052: END IF;
9053:

Line 9050: 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);

9046: WHERE po_header_id = p_doc_header_id;
9047:
9048: IF (PO_LOG.d_stmt) THEN
9049: 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);
9050: 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);
9051: 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);
9052: END IF;
9053:
9054: -- checks for update privileges based on the status

Line 9051: 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);

9047:
9048: IF (PO_LOG.d_stmt) THEN
9049: 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);
9050: 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);
9051: 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);
9052: END IF;
9053:
9054: -- checks for update privileges based on the status
9055: -- FROZEN, CANCELLED, FINALLY CLOSED

Line 9082: IF (PO_LOG.d_stmt) THEN

9078: PO_SECURITY_CHECK_SV.check_before_lock(l_doc_subtype,
9079: p_doc_header_id,
9080: fnd_global.employee_id,
9081: l_modify_action_allowed);
9082: IF (PO_LOG.d_stmt) THEN
9083: PO_LOG.stmt(d_module,d_pos,'l_modify_action_allowed', l_modify_action_allowed);
9084: END IF;
9085:
9086: IF NOT l_modify_action_allowed

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

9079: p_doc_header_id,
9080: fnd_global.employee_id,
9081: l_modify_action_allowed);
9082: IF (PO_LOG.d_stmt) THEN
9083: PO_LOG.stmt(d_module,d_pos,'l_modify_action_allowed', l_modify_action_allowed);
9084: END IF;
9085:
9086: IF NOT l_modify_action_allowed
9087: THEN

Line 9097: IF (PO_LOG.d_stmt) THEN

9093: l_style_disp_name := PO_DOC_STYLE_PVT.get_style_display_name(
9094: p_doc_id => p_doc_header_id,
9095: p_language => NULL);
9096:
9097: IF (PO_LOG.d_stmt) THEN
9098: PO_LOG.stmt(d_module,d_pos,'l_style_disp_name', l_style_disp_name);
9099: END IF;
9100:
9101: d_pos := 60;

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

9094: p_doc_id => p_doc_header_id,
9095: p_language => NULL);
9096:
9097: IF (PO_LOG.d_stmt) THEN
9098: PO_LOG.stmt(d_module,d_pos,'l_style_disp_name', l_style_disp_name);
9099: END IF;
9100:
9101: d_pos := 60;
9102: IF p_entity = PO_CORE_S.g_doc_level_HEADER

Line 9153: IF (PO_LOG.d_proc) THEN

9149: IF x_error_message is NOT NULL THEN
9150: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
9151: END IF;
9152:
9153: IF (PO_LOG.d_proc) THEN
9154: PO_LOG.proc_end(d_module);
9155: END IF;
9156:
9157: EXCEPTION

Line 9154: PO_LOG.proc_end(d_module);

9150: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
9151: END IF;
9152:
9153: IF (PO_LOG.d_proc) THEN
9154: PO_LOG.proc_end(d_module);
9155: END IF;
9156:
9157: EXCEPTION
9158: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

Line 9159: IF (PO_LOG.d_stmt) THEN

9155: END IF;
9156:
9157: EXCEPTION
9158: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
9159: IF (PO_LOG.d_stmt) THEN
9160: PO_LOG.stmt(d_module,d_pos,'x_error_message', x_error_message);
9161: END IF;
9162: WHEN OTHERS THEN
9163: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

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

9156:
9157: EXCEPTION
9158: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
9159: IF (PO_LOG.d_stmt) THEN
9160: PO_LOG.stmt(d_module,d_pos,'x_error_message', x_error_message);
9161: END IF;
9162: WHEN OTHERS THEN
9163: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9164: IF PO_LOG.d_exc THEN

Line 9164: IF PO_LOG.d_exc THEN

9160: PO_LOG.stmt(d_module,d_pos,'x_error_message', x_error_message);
9161: END IF;
9162: WHEN OTHERS THEN
9163: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9164: IF PO_LOG.d_exc THEN
9165: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9166: END IF;
9167: RAISE;
9168: END validate_delete_action;

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

9161: END IF;
9162: WHEN OTHERS THEN
9163: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9164: IF PO_LOG.d_exc THEN
9165: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9166: END IF;
9167: RAISE;
9168: END validate_delete_action;
9169: -----------------------------------------------------------------------------

Line 9244: IF (PO_LOG.d_proc) THEN

9240: l_api_name CONSTANT VARCHAR2(30) := 'process_delete_action';
9241: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';
9242:
9243: BEGIN
9244: IF (PO_LOG.d_proc) THEN
9245: 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);
9246: 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);
9247: 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);
9248: 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 9245: 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);

9241: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';
9242:
9243: BEGIN
9244: IF (PO_LOG.d_proc) THEN
9245: 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);
9246: 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);
9247: 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);
9248: 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);
9249: END IF;

Line 9246: 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);

9242:
9243: BEGIN
9244: IF (PO_LOG.d_proc) THEN
9245: 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);
9246: 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);
9247: 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);
9248: 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);
9249: END IF;
9250: -- Standard start of API savepoint

Line 9247: 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);

9243: BEGIN
9244: IF (PO_LOG.d_proc) THEN
9245: 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);
9246: 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);
9247: 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);
9248: 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);
9249: END IF;
9250: -- Standard start of API savepoint
9251: SAVEPOINT PO_PROCESS_DELETE_ACTION;

Line 9248: 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);

9244: IF (PO_LOG.d_proc) THEN
9245: 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);
9246: 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);
9247: 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);
9248: 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);
9249: END IF;
9250: -- Standard start of API savepoint
9251: SAVEPOINT PO_PROCESS_DELETE_ACTION;
9252:

Line 9290: IF (PO_LOG.d_stmt) THEN

9286: ,p_distribution_id => p_distribution_id
9287: ,x_error_message => l_error_message);
9288:
9289: d_pos := 20;
9290: IF (PO_LOG.d_stmt) THEN
9291: PO_LOG.stmt(d_module,d_pos,'l_error_message',l_error_message);
9292: END IF;
9293:
9294: IF l_error_message is NOT NULL

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

9287: ,x_error_message => l_error_message);
9288:
9289: d_pos := 20;
9290: IF (PO_LOG.d_stmt) THEN
9291: PO_LOG.stmt(d_module,d_pos,'l_error_message',l_error_message);
9292: END IF;
9293:
9294: IF l_error_message is NOT NULL
9295: THEN

Line 9312: IF (PO_LOG.d_stmt) THEN

9308: ,p_doc_header_id => p_doc_header_id
9309: ,p_ga_flag => p_ga_flag
9310: ,p_conterms_exist_flag => p_conterms_exist_flag
9311: ,x_return_status => x_return_status);
9312: IF (PO_LOG.d_stmt) THEN
9313: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
9314: END IF;
9315: ELSIF p_entity = PO_CORE_S.g_doc_level_LINE
9316: THEN

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

9309: ,p_ga_flag => p_ga_flag
9310: ,p_conterms_exist_flag => p_conterms_exist_flag
9311: ,x_return_status => x_return_status);
9312: IF (PO_LOG.d_stmt) THEN
9313: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
9314: END IF;
9315: ELSIF p_entity = PO_CORE_S.g_doc_level_LINE
9316: THEN
9317:

Line 9360: IF (PO_LOG.d_proc) THEN

9356: RAISE FND_API.g_exc_unexpected_error;
9357: END IF;
9358: --
9359:
9360: IF (PO_LOG.d_proc) THEN
9361: PO_LOG.proc_end(d_module);
9362: END IF;
9363: EXCEPTION
9364: WHEN FND_API.g_exc_error THEN

Line 9361: PO_LOG.proc_end(d_module);

9357: END IF;
9358: --
9359:
9360: IF (PO_LOG.d_proc) THEN
9361: PO_LOG.proc_end(d_module);
9362: END IF;
9363: EXCEPTION
9364: WHEN FND_API.g_exc_error THEN
9365: ROLLBACK TO PO_PROCESS_DELETE_ACTION;

Line 9372: IF (PO_LOG.d_stmt) THEN

9368: --Copy the messages on the list to the out parameter
9369: FOR I IN 1..FND_MSG_PUB.count_msg loop
9370: x_error_msg_tbl.extend;
9371: x_error_msg_tbl(I) := FND_MSG_PUB.get(I, 'F');
9372: IF (PO_LOG.d_stmt) THEN
9373: PO_LOG.stmt(d_module,d_pos,'x_error_msg_tbl(' || I || ')', x_error_msg_tbl(I));
9374: END IF;
9375: END LOOP;
9376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

9369: FOR I IN 1..FND_MSG_PUB.count_msg loop
9370: x_error_msg_tbl.extend;
9371: x_error_msg_tbl(I) := FND_MSG_PUB.get(I, 'F');
9372: IF (PO_LOG.d_stmt) THEN
9373: PO_LOG.stmt(d_module,d_pos,'x_error_msg_tbl(' || I || ')', x_error_msg_tbl(I));
9374: END IF;
9375: END LOOP;
9376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9377: ROLLBACK TO PO_PROCESS_DELETE_ACTION;

Line 9379: IF PO_LOG.d_exc THEN

9375: END LOOP;
9376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9377: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9379: IF PO_LOG.d_exc THEN
9380: PO_LOG.exc(d_module,d_pos,'Unexpected Error in' || d_module);
9381: END IF;
9382: WHEN OTHERS THEN
9383: ROLLBACK TO PO_PROCESS_DELETE_ACTION;

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

9376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9377: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9379: IF PO_LOG.d_exc THEN
9380: PO_LOG.exc(d_module,d_pos,'Unexpected Error in' || d_module);
9381: END IF;
9382: WHEN OTHERS THEN
9383: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9384: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 9386: IF PO_LOG.d_exc THEN

9382: WHEN OTHERS THEN
9383: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9384: x_return_status := FND_API.g_ret_sts_unexp_error;
9385: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9386: IF PO_LOG.d_exc THEN
9387: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9388: END IF;
9389: END process_delete_action;
9390:

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

9383: ROLLBACK TO PO_PROCESS_DELETE_ACTION;
9384: x_return_status := FND_API.g_ret_sts_unexp_error;
9385: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
9386: IF PO_LOG.d_exc THEN
9387: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9388: END IF;
9389: END process_delete_action;
9390:
9391: END PO_DOCUMENT_UPDATE_PVT;