DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on PO_LOG

Line 2949: IF (PO_LOG.d_proc) THEN

2945: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.UPDATE_PO_DETAILS';
2946: d_pos NUMBER := 0;
2947:
2948: BEGIN
2949: IF (PO_LOG.d_proc) THEN
2950: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2951: PO_LOG.proc_begin(d_module,'p_action_code',p_action_code);
2952: END IF;
2953:

Line 2950: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);

2946: d_pos NUMBER := 0;
2947:
2948: BEGIN
2949: IF (PO_LOG.d_proc) THEN
2950: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2951: PO_LOG.proc_begin(d_module,'p_action_code',p_action_code);
2952: END IF;
2953:
2954: IF (p_status = 'REJECTED') THEN

Line 2951: PO_LOG.proc_begin(d_module,'p_action_code',p_action_code);

2947:
2948: BEGIN
2949: IF (PO_LOG.d_proc) THEN
2950: PO_LOG.proc_begin(d_module,'p_po_header_id',p_po_header_id);
2951: PO_LOG.proc_begin(d_module,'p_action_code',p_action_code);
2952: END IF;
2953:
2954: IF (p_status = 'REJECTED') THEN
2955: l_approved_flag := 'F';

Line 3028: IF (PO_LOG.d_stmt) THEN

3024: -- If we are setting the standard PO's status to Approved, call the FTE API
3025: -- to update the Inbound Logistics delivery records.
3026:
3027: d_pos := 10;
3028: IF (PO_LOG.d_stmt) THEN
3029: PO_LOG.stmt(d_module,d_pos,'p_object_type_code',p_object_type_code);
3030: PO_LOG.stmt(d_module,d_pos,'p_object_subtype_code',p_object_subtype_code);
3031: END IF;
3032:

Line 3029: PO_LOG.stmt(d_module,d_pos,'p_object_type_code',p_object_type_code);

3025: -- to update the Inbound Logistics delivery records.
3026:
3027: d_pos := 10;
3028: IF (PO_LOG.d_stmt) THEN
3029: PO_LOG.stmt(d_module,d_pos,'p_object_type_code',p_object_type_code);
3030: PO_LOG.stmt(d_module,d_pos,'p_object_subtype_code',p_object_subtype_code);
3031: END IF;
3032:
3033: IF (p_status = 'APPROVED')

Line 3030: PO_LOG.stmt(d_module,d_pos,'p_object_subtype_code',p_object_subtype_code);

3026:
3027: d_pos := 10;
3028: IF (PO_LOG.d_stmt) THEN
3029: PO_LOG.stmt(d_module,d_pos,'p_object_type_code',p_object_type_code);
3030: PO_LOG.stmt(d_module,d_pos,'p_object_subtype_code',p_object_subtype_code);
3031: END IF;
3032:
3033: IF (p_status = 'APPROVED')
3034: AND ((p_object_type_code = 'PO')

Line 3055: IF (PO_LOG.d_stmt) THEN

3051: RAISE PO_CORE_S.g_early_return_exc;
3052: END IF;
3053:
3054: d_pos := 30;
3055: IF (PO_LOG.d_stmt) THEN
3056: PO_LOG.stmt(d_module,d_pos,'l_supply_action',l_supply_action);
3057: END IF;
3058:
3059: l_bool_ret_sts :=

Line 3056: PO_LOG.stmt(d_module,d_pos,'l_supply_action',l_supply_action);

3052: END IF;
3053:
3054: d_pos := 30;
3055: IF (PO_LOG.d_stmt) THEN
3056: PO_LOG.stmt(d_module,d_pos,'l_supply_action',l_supply_action);
3057: END IF;
3058:
3059: l_bool_ret_sts :=
3060: PO_SUPPLY.po_req_supply(

Line 3079: IF (PO_LOG.d_exc) THEN

3075: END IF;
3076:
3077: EXCEPTION
3078: WHEN PO_CORE_S.g_early_return_exc THEN
3079: IF (PO_LOG.d_exc) THEN
3080: PO_LOG.exc(d_module, d_pos, l_err_msg);
3081: END IF;
3082: END;
3083: --End of code changes for the bug 13507482

Line 3080: PO_LOG.exc(d_module, d_pos, l_err_msg);

3076:
3077: EXCEPTION
3078: WHEN PO_CORE_S.g_early_return_exc THEN
3079: IF (PO_LOG.d_exc) THEN
3080: PO_LOG.exc(d_module, d_pos, l_err_msg);
3081: END IF;
3082: END;
3083: --End of code changes for the bug 13507482
3084:

Line 3104: IF (PO_LOG.d_proc) THEN

3100:
3101: END IF;
3102: -- Bug 3602512 END
3103:
3104: IF (PO_LOG.d_proc) THEN
3105: PO_LOG.proc_end(d_module);
3106: END IF;
3107:
3108: EXCEPTION

Line 3105: PO_LOG.proc_end(d_module);

3101: END IF;
3102: -- Bug 3602512 END
3103:
3104: IF (PO_LOG.d_proc) THEN
3105: PO_LOG.proc_end(d_module);
3106: END IF;
3107:
3108: EXCEPTION
3109: -- Bug 3602512 START

Line 4142: IF (PO_LOG.d_proc) THEN

4138: l_was_sign_reqd boolean := FALSE;
4139: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_was_sign_reqd_set_acc_flag';
4140: d_pos NUMBER := 0;
4141: BEGIN
4142: IF (PO_LOG.d_proc) THEN
4143: PO_LOG.proc_begin(d_module,'p_document_id',p_document_id);
4144: END IF;
4145: x_if_acc_flag_updated := 'N';
4146: l_was_sign_reqd := was_signature_required(p_document_id);

Line 4143: PO_LOG.proc_begin(d_module,'p_document_id',p_document_id);

4139: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_was_sign_reqd_set_acc_flag';
4140: d_pos NUMBER := 0;
4141: BEGIN
4142: IF (PO_LOG.d_proc) THEN
4143: PO_LOG.proc_begin(d_module,'p_document_id',p_document_id);
4144: END IF;
4145: x_if_acc_flag_updated := 'N';
4146: l_was_sign_reqd := was_signature_required(p_document_id);
4147: d_pos := 10;

Line 4148: IF (PO_LOG.d_stmt) THEN

4144: END IF;
4145: x_if_acc_flag_updated := 'N';
4146: l_was_sign_reqd := was_signature_required(p_document_id);
4147: d_pos := 10;
4148: IF (PO_LOG.d_stmt) THEN
4149: PO_LOG.stmt(d_module,d_pos,'l_was_sign_reqd',l_was_sign_reqd);
4150: END IF;
4151:
4152: IF l_was_sign_reqd THEN

Line 4149: PO_LOG.stmt(d_module,d_pos,'l_was_sign_reqd',l_was_sign_reqd);

4145: x_if_acc_flag_updated := 'N';
4146: l_was_sign_reqd := was_signature_required(p_document_id);
4147: d_pos := 10;
4148: IF (PO_LOG.d_stmt) THEN
4149: PO_LOG.stmt(d_module,d_pos,'l_was_sign_reqd',l_was_sign_reqd);
4150: END IF;
4151:
4152: IF l_was_sign_reqd THEN
4153: UPDATE PO_HEADERS_ALL POH

Line 4159: IF (PO_LOG.d_proc) THEN

4155: WHERE POH.po_header_id = p_document_id;
4156: x_if_acc_flag_updated := 'Y';
4157: END IF;
4158:
4159: IF (PO_LOG.d_proc) THEN
4160: PO_LOG.proc_end(d_module);
4161: PO_LOG.proc_end(d_module, 'x_if_acc_flag_updated', x_if_acc_flag_updated);
4162: END IF;
4163: EXCEPTION

Line 4160: PO_LOG.proc_end(d_module);

4156: x_if_acc_flag_updated := 'Y';
4157: END IF;
4158:
4159: IF (PO_LOG.d_proc) THEN
4160: PO_LOG.proc_end(d_module);
4161: PO_LOG.proc_end(d_module, 'x_if_acc_flag_updated', x_if_acc_flag_updated);
4162: END IF;
4163: EXCEPTION
4164: WHEN OTHERS THEN

Line 4161: PO_LOG.proc_end(d_module, 'x_if_acc_flag_updated', x_if_acc_flag_updated);

4157: END IF;
4158:
4159: IF (PO_LOG.d_proc) THEN
4160: PO_LOG.proc_end(d_module);
4161: PO_LOG.proc_end(d_module, 'x_if_acc_flag_updated', x_if_acc_flag_updated);
4162: END IF;
4163: EXCEPTION
4164: WHEN OTHERS THEN
4165: IF PO_LOG.d_exc THEN

Line 4165: IF PO_LOG.d_exc THEN

4161: PO_LOG.proc_end(d_module, 'x_if_acc_flag_updated', x_if_acc_flag_updated);
4162: END IF;
4163: EXCEPTION
4164: WHEN OTHERS THEN
4165: IF PO_LOG.d_exc THEN
4166: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4167: END IF;
4168: RAISE;
4169: END if_was_sign_reqd_set_acc_flag;

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

4162: END IF;
4163: EXCEPTION
4164: WHEN OTHERS THEN
4165: IF PO_LOG.d_exc THEN
4166: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4167: END IF;
4168: RAISE;
4169: END if_was_sign_reqd_set_acc_flag;
4170: --

Line 4225: IF PO_LOG.d_exc THEN

4221: END IF;
4222:
4223: EXCEPTION
4224: WHEN OTHERS THEN
4225: IF PO_LOG.d_exc THEN
4226: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4227: END IF;
4228: RAISE;
4229: END if_rev_and_signed_set_acc_flag;

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

4222:
4223: EXCEPTION
4224: WHEN OTHERS THEN
4225: IF PO_LOG.d_exc THEN
4226: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4227: END IF;
4228: RAISE;
4229: END if_rev_and_signed_set_acc_flag;
4230: