271: WHEN OTHERS THEN
272: x_header_processable_flag := 'N';
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --
274: --dbms_output.put_line('...1');
275: po_message_s.sql_error('create_update_sourcing_rule', x_progress, sqlcode);
276: END create_update_sourcing_rule;
277:
278: /*
279: Assignment Type => Assignment Type ID Mapping
671:
672: --dbms_output.put_line('...2');
673: x_running_status := 'N';
674: X_header_processable_flag := 'N';
675: po_message_s.sql_error('create_sourcing_rule', x_progress, sqlcode);
676: END create_sourcing_rule;
677:
678:
679: /*
1473: PO_DEBUG.put_line(v_error_code);
1474: END IF;
1475: x_running_status := 'N';
1476: x_header_processable_flag := 'N';
1477: po_message_s.sql_error('update_sourcing_rule', x_progress, sqlcode);
1478: END update_sourcing_rule;
1479:
1480: PROCEDURE validate_sourcing_rule (
1481: X_interface_header_id IN NUMBER,
1628: WHEN OTHERS THEN
1629: x_running_status := 'N';
1630: --dbms_output.put_line('...4');
1631: X_header_processable_flag := 'N';
1632: po_message_s.sql_error('validate_sourcing_rule', x_progress, sqlcode);
1633: END validate_sourcing_rule;
1634:
1635:
1636: -- procedure to put future validations related to update_sourcing_rule