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

Line 4000: IF (PO_LOG.d_proc) THEN

3996: d_pos NUMBER;
3997: l_api_name CONSTANT VARCHAR2(30) := 'Val_Cancel_FinalClose_Action';
3998: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.Val_Cancel_FinalClose_Action' ;
3999: BEGIN
4000: IF (PO_LOG.d_proc) THEN
4001: PO_LOG.proc_begin(d_module);
4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

Line 4001: PO_LOG.proc_begin(d_module);

3997: l_api_name CONSTANT VARCHAR2(30) := 'Val_Cancel_FinalClose_Action';
3998: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.Val_Cancel_FinalClose_Action' ;
3999: BEGIN
4000: IF (PO_LOG.d_proc) THEN
4001: PO_LOG.proc_begin(d_module);
4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);

Line 4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);

3998: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.Val_Cancel_FinalClose_Action' ;
3999: BEGIN
4000: IF (PO_LOG.d_proc) THEN
4001: PO_LOG.proc_begin(d_module);
4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);

Line 4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

3999: BEGIN
4000: IF (PO_LOG.d_proc) THEN
4001: PO_LOG.proc_begin(d_module);
4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4007: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

Line 4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

4000: IF (PO_LOG.d_proc) THEN
4001: PO_LOG.proc_begin(d_module);
4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4007: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4008: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

Line 4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);

4001: PO_LOG.proc_begin(d_module);
4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4007: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4008: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4009: END IF;

Line 4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);

4002: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4007: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4008: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4009: END IF;
4010: d_pos := 10;

Line 4007: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

4003: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4007: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4008: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4009: END IF;
4010: d_pos := 10;
4011: --Initialising the variables to default value

Line 4008: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

4004: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4005: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4006: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4007: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4008: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4009: END IF;
4010: d_pos := 10;
4011: --Initialising the variables to default value
4012: x_return_status := FND_API.g_ret_sts_success;

Line 4036: IF PO_LOG.d_exc THEN

4032: d_pos := 40;
4033: if nvl(l_current_entity_changed, 'N') = 'Y' then
4034: FND_MESSAGE.set_name('PO','PO_CHANGED_CANT_CANCEL');
4035: FND_MSG_PUB.add;
4036: IF PO_LOG.d_exc THEN
4037: PO_LOG.exc(d_module,d_pos,'Current record does not match with record in Archive');
4038: END IF;
4039: RAISE FND_API.G_EXC_ERROR;
4040: end if;

Line 4037: PO_LOG.exc(d_module,d_pos,'Current record does not match with record in Archive');

4033: if nvl(l_current_entity_changed, 'N') = 'Y' then
4034: FND_MESSAGE.set_name('PO','PO_CHANGED_CANT_CANCEL');
4035: FND_MSG_PUB.add;
4036: IF PO_LOG.d_exc THEN
4037: PO_LOG.exc(d_module,d_pos,'Current record does not match with record in Archive');
4038: END IF;
4039: RAISE FND_API.G_EXC_ERROR;
4040: end if;
4041: end if; --p_control_action like 'CANCEL%'

Line 4057: IF (PO_LOG.d_stmt) THEN

4053: l_otl_field_name := PO_HXC_INTERFACE_PVT.field_PO_LINE_ID;
4054: l_otl_field_value := p_doc_line_id;
4055: END IF; --p_doc_level = 'HEADER'
4056: d_pos := 60;
4057: IF (PO_LOG.d_stmt) THEN
4058: PO_LOG.stmt(d_module,d_pos,'l_otl_field_name',l_otl_field_name);
4059: PO_LOG.stmt(d_module,d_pos,'l_otl_field_value',l_otl_field_value);
4060: END IF;
4061: PO_HXC_INTERFACE_PVT.check_timecard_exists(p_api_version => 1.0,

Line 4058: PO_LOG.stmt(d_module,d_pos,'l_otl_field_name',l_otl_field_name);

4054: l_otl_field_value := p_doc_line_id;
4055: END IF; --p_doc_level = 'HEADER'
4056: d_pos := 60;
4057: IF (PO_LOG.d_stmt) THEN
4058: PO_LOG.stmt(d_module,d_pos,'l_otl_field_name',l_otl_field_name);
4059: PO_LOG.stmt(d_module,d_pos,'l_otl_field_value',l_otl_field_value);
4060: END IF;
4061: PO_HXC_INTERFACE_PVT.check_timecard_exists(p_api_version => 1.0,
4062: x_return_status => x_return_status,

Line 4059: PO_LOG.stmt(d_module,d_pos,'l_otl_field_value',l_otl_field_value);

4055: END IF; --p_doc_level = 'HEADER'
4056: d_pos := 60;
4057: IF (PO_LOG.d_stmt) THEN
4058: PO_LOG.stmt(d_module,d_pos,'l_otl_field_name',l_otl_field_name);
4059: PO_LOG.stmt(d_module,d_pos,'l_otl_field_value',l_otl_field_value);
4060: END IF;
4061: PO_HXC_INTERFACE_PVT.check_timecard_exists(p_api_version => 1.0,
4062: x_return_status => x_return_status,
4063: p_field_name => l_otl_field_name,

Line 4075: IF PO_LOG.d_exc THEN

4071: d_pos := 80;
4072: IF (l_timecard_exists) THEN
4073: FND_MESSAGE.set_name('PO','PO_CONTROL_OTL_INVALID_ACTION');
4074: FND_MSG_PUB.add;
4075: IF PO_LOG.d_exc THEN
4076: PO_LOG.exc(d_module,d_pos,'Document with timecard cannot be Cancelled or Finally Closed');
4077: END IF;
4078: RAISE FND_API.G_EXC_ERROR;
4079: END IF; -- IF(l_timecard_exists) THEN

Line 4076: PO_LOG.exc(d_module,d_pos,'Document with timecard cannot be Cancelled or Finally Closed');

4072: IF (l_timecard_exists) THEN
4073: FND_MESSAGE.set_name('PO','PO_CONTROL_OTL_INVALID_ACTION');
4074: FND_MSG_PUB.add;
4075: IF PO_LOG.d_exc THEN
4076: PO_LOG.exc(d_module,d_pos,'Document with timecard cannot be Cancelled or Finally Closed');
4077: END IF;
4078: RAISE FND_API.G_EXC_ERROR;
4079: END IF; -- IF(l_timecard_exists) THEN
4080: END IF; --p_doc_subtype = 'STANDARD'

Line 4082: IF (PO_LOG.d_proc) THEN

4078: RAISE FND_API.G_EXC_ERROR;
4079: END IF; -- IF(l_timecard_exists) THEN
4080: END IF; --p_doc_subtype = 'STANDARD'
4081: d_pos := 90;
4082: IF (PO_LOG.d_proc) THEN
4083: PO_LOG.proc_end(d_module);
4084: END IF;
4085: EXCEPTION
4086: WHEN FND_API.g_exc_error THEN

Line 4083: PO_LOG.proc_end(d_module);

4079: END IF; -- IF(l_timecard_exists) THEN
4080: END IF; --p_doc_subtype = 'STANDARD'
4081: d_pos := 90;
4082: IF (PO_LOG.d_proc) THEN
4083: PO_LOG.proc_end(d_module);
4084: END IF;
4085: EXCEPTION
4086: WHEN FND_API.g_exc_error THEN
4087: x_return_status := FND_API.g_ret_sts_error;

Line 4091: IF PO_LOG.d_exc THEN

4087: x_return_status := FND_API.g_ret_sts_error;
4088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4090: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4091: IF PO_LOG.d_exc THEN
4092: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
4093: END IF;
4094: WHEN OTHERS THEN
4095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4090: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4091: IF PO_LOG.d_exc THEN
4092: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
4093: END IF;
4094: WHEN OTHERS THEN
4095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4096: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

Line 4097: IF PO_LOG.d_exc THEN

4093: END IF;
4094: WHEN OTHERS THEN
4095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4096: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4097: IF PO_LOG.d_exc THEN
4098: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4099: END IF;
4100: END Val_Cancel_FinalClose_Action;
4101:

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

4094: WHEN OTHERS THEN
4095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4096: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4097: IF PO_LOG.d_exc THEN
4098: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4099: END IF;
4100: END Val_Cancel_FinalClose_Action;
4101:
4102: ------------------------------------------------------------------------

Line 4207: IF (PO_LOG.d_proc) THEN

4203: d_pos NUMBER;
4204: l_api_name CONSTANT VARCHAR2(30) := 'do_control_action';
4205: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.do_control_action';
4206: BEGIN
4207: IF (PO_LOG.d_proc) THEN
4208: PO_LOG.proc_begin(d_module);
4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

Line 4208: PO_LOG.proc_begin(d_module);

4204: l_api_name CONSTANT VARCHAR2(30) := 'do_control_action';
4205: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.do_control_action';
4206: BEGIN
4207: IF (PO_LOG.d_proc) THEN
4208: PO_LOG.proc_begin(d_module);
4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

Line 4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);

4205: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.do_control_action';
4206: BEGIN
4207: IF (PO_LOG.d_proc) THEN
4208: PO_LOG.proc_begin(d_module);
4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);

Line 4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);

4206: BEGIN
4207: IF (PO_LOG.d_proc) THEN
4208: PO_LOG.proc_begin(d_module);
4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);

Line 4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

4207: IF (PO_LOG.d_proc) THEN
4208: PO_LOG.proc_begin(d_module);
4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

Line 4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

4208: PO_LOG.proc_begin(d_module);
4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

Line 4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);

4209: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);

Line 4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);

4210: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);

Line 4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

4211: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);

Line 4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

4212: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);

Line 4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);

4213: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);

Line 4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);

4214: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4222: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);

Line 4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);

4215: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4222: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4223: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);

Line 4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);

4216: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4222: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4223: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4224: END IF;

Line 4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);

4217: PO_LOG.proc_begin(d_module,'p_action_date',p_action_date);
4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4222: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4223: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4224: END IF;
4225: d_pos := 10;

Line 4222: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);

4218: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4222: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4223: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4224: END IF;
4225: d_pos := 10;
4226: --initialise the out variables to default value

Line 4223: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);

4219: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4220: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4221: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4222: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4223: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4224: END IF;
4225: d_pos := 10;
4226: --initialise the out variables to default value
4227: l_online_report_id := NULL;

Line 4241: IF (PO_LOG.d_stmt) THEN

4237: FROM PO_LOOKUP_CODES
4238: WHERE lookup_type = 'CONTROL ACTIONS'
4239: AND lookup_code = p_control_action;
4240:
4241: IF (PO_LOG.d_stmt) THEN
4242: PO_LOG.stmt(d_module,d_pos,'l_control_action_disp_name', l_control_action_disp_name);
4243: END IF;
4244:
4245: IF p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE THEN

Line 4242: PO_LOG.stmt(d_module,d_pos,'l_control_action_disp_name', l_control_action_disp_name);

4238: WHERE lookup_type = 'CONTROL ACTIONS'
4239: AND lookup_code = p_control_action;
4240:
4241: IF (PO_LOG.d_stmt) THEN
4242: PO_LOG.stmt(d_module,d_pos,'l_control_action_disp_name', l_control_action_disp_name);
4243: END IF;
4244:
4245: IF p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE THEN
4246: d_pos := 20;

Line 4256: IF (PO_LOG.d_stmt) THEN

4252: p_header_id => p_doc_header_id,
4253: p_action => 'CANCEL_PO_SUPPLY',
4254: p_recreate_demand_flag => 'N',
4255: x_return_status => x_return_status);
4256: IF (PO_LOG.d_stmt) THEN
4257: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4258: END IF;
4259:
4260: d_pos := 30;

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

4253: p_action => 'CANCEL_PO_SUPPLY',
4254: p_recreate_demand_flag => 'N',
4255: x_return_status => x_return_status);
4256: IF (PO_LOG.d_stmt) THEN
4257: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4258: END IF;
4259:
4260: d_pos := 30;
4261: --PO_RESERVATION_MAINTAIN_SV.maintain_reservation nullifies the

Line 4288: IF (PO_LOG.d_stmt) THEN

4284: ,p_document_sub_type => p_doc_subtype
4285: ,p_cbc_acct_date => p_action_date);
4286:
4287: d_pos := 60;
4288: IF (PO_LOG.d_stmt) THEN
4289: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4290: END IF;
4291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4285: ,p_cbc_acct_date => p_action_date);
4286:
4287: d_pos := 60;
4288: IF (PO_LOG.d_stmt) THEN
4289: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4290: END IF;
4291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END IF;

Line 4308: IF (PO_LOG.d_stmt) THEN

4304: from po_headers_all
4305: where po_header_id = p_doc_header_id;
4306: d_pos := 70;
4307:
4308: IF (PO_LOG.d_stmt) THEN
4309: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag',l_conterms_exist_flag);
4310: PO_LOG.stmt(d_module,d_pos,'l_document_start_date',l_document_start_date);
4311: PO_LOG.stmt(d_module,d_pos,'l_document_end_date',l_document_end_date);
4312: PO_LOG.stmt(d_module,d_pos,'l_cancel_flag',l_cancel_flag);

Line 4309: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag',l_conterms_exist_flag);

4305: where po_header_id = p_doc_header_id;
4306: d_pos := 70;
4307:
4308: IF (PO_LOG.d_stmt) THEN
4309: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag',l_conterms_exist_flag);
4310: PO_LOG.stmt(d_module,d_pos,'l_document_start_date',l_document_start_date);
4311: PO_LOG.stmt(d_module,d_pos,'l_document_end_date',l_document_end_date);
4312: PO_LOG.stmt(d_module,d_pos,'l_cancel_flag',l_cancel_flag);
4313: END IF;

Line 4310: PO_LOG.stmt(d_module,d_pos,'l_document_start_date',l_document_start_date);

4306: d_pos := 70;
4307:
4308: IF (PO_LOG.d_stmt) THEN
4309: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag',l_conterms_exist_flag);
4310: PO_LOG.stmt(d_module,d_pos,'l_document_start_date',l_document_start_date);
4311: PO_LOG.stmt(d_module,d_pos,'l_document_end_date',l_document_end_date);
4312: PO_LOG.stmt(d_module,d_pos,'l_cancel_flag',l_cancel_flag);
4313: END IF;
4314:

Line 4311: PO_LOG.stmt(d_module,d_pos,'l_document_end_date',l_document_end_date);

4307:
4308: IF (PO_LOG.d_stmt) THEN
4309: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag',l_conterms_exist_flag);
4310: PO_LOG.stmt(d_module,d_pos,'l_document_start_date',l_document_start_date);
4311: PO_LOG.stmt(d_module,d_pos,'l_document_end_date',l_document_end_date);
4312: PO_LOG.stmt(d_module,d_pos,'l_cancel_flag',l_cancel_flag);
4313: END IF;
4314:
4315: IF ((UPPER(NVL(l_conterms_exist_flag, 'N'))='Y') AND

Line 4312: PO_LOG.stmt(d_module,d_pos,'l_cancel_flag',l_cancel_flag);

4308: IF (PO_LOG.d_stmt) THEN
4309: PO_LOG.stmt(d_module,d_pos,'l_conterms_exist_flag',l_conterms_exist_flag);
4310: PO_LOG.stmt(d_module,d_pos,'l_document_start_date',l_document_start_date);
4311: PO_LOG.stmt(d_module,d_pos,'l_document_end_date',l_document_end_date);
4312: PO_LOG.stmt(d_module,d_pos,'l_cancel_flag',l_cancel_flag);
4313: END IF;
4314:
4315: IF ((UPPER(NVL(l_conterms_exist_flag, 'N'))='Y') AND
4316: (UPPER(NVL(l_cancel_flag, 'N'))='N')) THEN

Line 4340: IF (PO_LOG.d_stmt) THEN

4336: ,p_busdocdates_tbl => l_busdocdates_tbl
4337: ,x_return_status => x_return_status);
4338:
4339: d_pos := 100;
4340: IF (PO_LOG.d_stmt) THEN
4341: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4342: END IF;
4343: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4337: ,x_return_status => x_return_status);
4338:
4339: d_pos := 100;
4340: IF (PO_LOG.d_stmt) THEN
4341: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4342: END IF;
4343: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4345: END IF;

Line 4355: IF (PO_LOG.d_stmt) THEN

4351: l_print_flag := CASE p_communication_method
4352: WHEN 'PRINT' THEN 'Y'
4353: ELSE 'N'
4354: END;
4355: IF (PO_LOG.d_stmt) THEN
4356: PO_LOG.stmt(d_module,d_pos,'l_print_flag',l_print_flag);
4357: END IF;
4358: -- Try to launch Approval Workflow in the following scenarios:
4359: -- If the Cancel action was initiated from PO Summary at

Line 4356: PO_LOG.stmt(d_module,d_pos,'l_print_flag',l_print_flag);

4352: WHEN 'PRINT' THEN 'Y'
4353: ELSE 'N'
4354: END;
4355: IF (PO_LOG.d_stmt) THEN
4356: PO_LOG.stmt(d_module,d_pos,'l_print_flag',l_print_flag);
4357: END IF;
4358: -- Try to launch Approval Workflow in the following scenarios:
4359: -- If the Cancel action was initiated from PO Summary at
4360: -- Header/Line/Shipment level

Line 4369: IF (PO_LOG.d_stmt) THEN

4365: ELSE
4366: l_launch_approvals_flag := 'N';
4367: END if;
4368:
4369: IF (PO_LOG.d_stmt) THEN
4370: PO_LOG.stmt(d_module,d_pos,'l_launch_approvals_flag',l_launch_approvals_flag);
4371: END IF;
4372:
4373: PO_DOCUMENT_CONTROL_PVT.control_document(

Line 4370: PO_LOG.stmt(d_module,d_pos,'l_launch_approvals_flag',l_launch_approvals_flag);

4366: l_launch_approvals_flag := 'N';
4367: END if;
4368:
4369: IF (PO_LOG.d_stmt) THEN
4370: PO_LOG.stmt(d_module,d_pos,'l_launch_approvals_flag',l_launch_approvals_flag);
4371: END IF;
4372:
4373: PO_DOCUMENT_CONTROL_PVT.control_document(
4374: p_api_version => 1.0

Line 4396: IF (PO_LOG.d_stmt) THEN

4392: ,p_communication_method_option => p_communication_method
4393: ,p_communication_method_value => p_communication_value);
4394:
4395: d_pos := 130;
4396: IF (PO_LOG.d_stmt) THEN
4397: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4398: END IF;
4399: -- If the procedure does not complete successfully raise the
4400: -- appropriate exception

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

4393: ,p_communication_method_value => p_communication_value);
4394:
4395: d_pos := 130;
4396: IF (PO_LOG.d_stmt) THEN
4397: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4398: END IF;
4399: -- If the procedure does not complete successfully raise the
4400: -- appropriate exception
4401: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 4463: IF (PO_LOG.d_stmt) THEN

4459: ELSE
4460: l_doc_subtype := p_doc_subtype;
4461: END IF;
4462: d_pos := 190;
4463: IF (PO_LOG.d_stmt) THEN
4464: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
4465: END IF;
4466:
4467: PO_DOCUMENT_ACTION_PVT.do_manual_close(

Line 4464: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);

4460: l_doc_subtype := p_doc_subtype;
4461: END IF;
4462: d_pos := 190;
4463: IF (PO_LOG.d_stmt) THEN
4464: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
4465: END IF;
4466:
4467: PO_DOCUMENT_ACTION_PVT.do_manual_close(
4468: p_action => p_control_action

Line 4486: IF (PO_LOG.d_stmt) THEN

4482: ,x_exception_msg => l_exc_msg
4483: ,x_online_report_id => l_online_report_id);
4484: END IF; -- IF p_control_action LIKE 'CANCEL%'
4485: d_pos := 200;
4486: IF (PO_LOG.d_stmt) THEN
4487: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4488: PO_LOG.stmt(d_module,d_pos,'l_return_code',l_return_code);
4489: PO_LOG.stmt(d_module,d_pos,'l_exc_msg',l_exc_msg);
4490: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);

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

4483: ,x_online_report_id => l_online_report_id);
4484: END IF; -- IF p_control_action LIKE 'CANCEL%'
4485: d_pos := 200;
4486: IF (PO_LOG.d_stmt) THEN
4487: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4488: PO_LOG.stmt(d_module,d_pos,'l_return_code',l_return_code);
4489: PO_LOG.stmt(d_module,d_pos,'l_exc_msg',l_exc_msg);
4490: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
4491: END IF;

Line 4488: PO_LOG.stmt(d_module,d_pos,'l_return_code',l_return_code);

4484: END IF; -- IF p_control_action LIKE 'CANCEL%'
4485: d_pos := 200;
4486: IF (PO_LOG.d_stmt) THEN
4487: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4488: PO_LOG.stmt(d_module,d_pos,'l_return_code',l_return_code);
4489: PO_LOG.stmt(d_module,d_pos,'l_exc_msg',l_exc_msg);
4490: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
4491: END IF;
4492:

Line 4489: PO_LOG.stmt(d_module,d_pos,'l_exc_msg',l_exc_msg);

4485: d_pos := 200;
4486: IF (PO_LOG.d_stmt) THEN
4487: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4488: PO_LOG.stmt(d_module,d_pos,'l_return_code',l_return_code);
4489: PO_LOG.stmt(d_module,d_pos,'l_exc_msg',l_exc_msg);
4490: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
4491: END IF;
4492:
4493: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4490: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);

4486: IF (PO_LOG.d_stmt) THEN
4487: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4488: PO_LOG.stmt(d_module,d_pos,'l_return_code',l_return_code);
4489: PO_LOG.stmt(d_module,d_pos,'l_exc_msg',l_exc_msg);
4490: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
4491: END IF;
4492:
4493: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4494: IF (l_return_code = 'STATE_FAILED') THEN

Line 4530: PO_LOG.exc(d_module,d_pos,l_exc_msg);

4526: END IF;--l_return_code = 'STATE_FAILED'
4527: ELSE
4528: d_pos := 240;
4529: IF (l_exc_msg IS NOT NULL) THEN
4530: PO_LOG.exc(d_module,d_pos,l_exc_msg);
4531: END IF;
4532: RAISE FND_API.g_exc_unexpected_error;
4533: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
4534: d_pos := 250;

Line 4547: IF (PO_LOG.d_stmt) THEN

4543: --set to N by the cancel code in control_document procedure
4544: IF g_cancel_flag_reset_flag THEN
4545: x_cancel_req_flag_reset := 'Y';
4546: END IF;
4547: IF (PO_LOG.d_stmt) THEN
4548: PO_LOG.stmt(d_module,d_pos,'x_approval_initiated',x_approval_initiated);
4549: END IF;
4550: d_pos := 260;
4551: EXCEPTION

Line 4548: PO_LOG.stmt(d_module,d_pos,'x_approval_initiated',x_approval_initiated);

4544: IF g_cancel_flag_reset_flag THEN
4545: x_cancel_req_flag_reset := 'Y';
4546: END IF;
4547: IF (PO_LOG.d_stmt) THEN
4548: PO_LOG.stmt(d_module,d_pos,'x_approval_initiated',x_approval_initiated);
4549: END IF;
4550: d_pos := 260;
4551: EXCEPTION
4552: WHEN FND_API.g_exc_error THEN

Line 4556: IF PO_LOG.d_exc THEN

4552: WHEN FND_API.g_exc_error THEN
4553: x_return_status := FND_API.g_ret_sts_error;
4554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4555: x_return_status := FND_API.g_ret_sts_unexp_error;
4556: IF PO_LOG.d_exc THEN
4557: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
4558: IF FND_MSG_PUB.count_msg = 0 THEN
4559: FND_MESSAGE.set_name('PO','PO_DOC_CONTROL_ACTION_FAILED');
4560: FND_MESSAGE.set_token('CONTROL_ACTION_NAME', l_control_action_disp_name);

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

4553: x_return_status := FND_API.g_ret_sts_error;
4554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4555: x_return_status := FND_API.g_ret_sts_unexp_error;
4556: IF PO_LOG.d_exc THEN
4557: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
4558: IF FND_MSG_PUB.count_msg = 0 THEN
4559: FND_MESSAGE.set_name('PO','PO_DOC_CONTROL_ACTION_FAILED');
4560: FND_MESSAGE.set_token('CONTROL_ACTION_NAME', l_control_action_disp_name);
4561: FND_MESSAGE.set_token('ERROR_TEXT',l_exc_msg);

Line 4568: IF PO_LOG.d_exc THEN

4564: END IF;
4565: WHEN OTHERS THEN
4566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4567: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4568: IF PO_LOG.d_exc THEN
4569: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4570: END IF;
4571: END do_control_action;
4572: ------------------------------------------------------------------------

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

4565: WHEN OTHERS THEN
4566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4567: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4568: IF PO_LOG.d_exc THEN
4569: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4570: END IF;
4571: END do_control_action;
4572: ------------------------------------------------------------------------
4573: --Start of Comments

Line 4668: IF (PO_LOG.d_proc) THEN

4664: l_api_name CONSTANT VARCHAR2(30) := 'process_doc_control_action';
4665: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.process_doc_control_action';
4666: l_mode VARCHAR2(30);
4667: BEGIN
4668: IF (PO_LOG.d_proc) THEN
4669: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

Line 4669: PO_LOG.proc_begin(d_module,'p_mode',p_mode);

4665: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.process_doc_control_action';
4666: l_mode VARCHAR2(30);
4667: BEGIN
4668: IF (PO_LOG.d_proc) THEN
4669: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);

Line 4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);

4666: l_mode VARCHAR2(30);
4667: BEGIN
4668: IF (PO_LOG.d_proc) THEN
4669: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);

Line 4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

4667: BEGIN
4668: IF (PO_LOG.d_proc) THEN
4669: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);

Line 4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

4668: IF (PO_LOG.d_proc) THEN
4669: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

Line 4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);

4669: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

Line 4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);

4670: PO_LOG.proc_begin(d_module,'p_control_action',p_control_action);
4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);

Line 4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);

4671: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);

Line 4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

4672: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);

Line 4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

4673: PO_LOG.proc_begin(d_module,'p_doc_org_id',p_doc_org_id);
4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);

Line 4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);

4674: PO_LOG.proc_begin(d_module,'p_doc_line_id',p_doc_line_id);
4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);

Line 4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);

4675: PO_LOG.proc_begin(d_module,'p_doc_line_loc_id',p_doc_line_loc_id);
4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4683: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);

Line 4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);

4676: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4683: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4684: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);

Line 4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);

4677: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4683: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4684: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4685: END IF;

Line 4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);

4678: PO_LOG.proc_begin(d_module,'p_gl_date',p_gl_date);
4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4683: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4684: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4685: END IF;
4686: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4683: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);

4679: PO_LOG.proc_begin(d_module,'p_use_gldate',p_use_gldate);
4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4683: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4684: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4685: END IF;
4686: x_return_status := FND_API.G_RET_STS_SUCCESS;
4687: l_mode := UPPER(p_mode);

Line 4684: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);

4680: PO_LOG.proc_begin(d_module,'p_reason',p_reason);
4681: PO_LOG.proc_begin(d_module,'p_note_to_vendor',p_note_to_vendor);
4682: PO_LOG.proc_begin(d_module,'p_communication_method',p_communication_method);
4683: PO_LOG.proc_begin(d_module,'p_communication_value',p_communication_value);
4684: PO_LOG.proc_begin(d_module,'p_cancel_reqs',p_cancel_reqs);
4685: END IF;
4686: x_return_status := FND_API.G_RET_STS_SUCCESS;
4687: l_mode := UPPER(p_mode);
4688:

Line 4709: IF (PO_LOG.d_stmt) THEN

4705: p_po_encumbrance_flag => p_po_encumbrance_flag,
4706: p_req_encumbrance_flag => p_req_encumbrance_flag,
4707: p_skip_valid_cbc_acct_date => FND_API.G_FALSE); --Bug#4569120
4708: d_pos := 20;
4709: IF (PO_LOG.d_stmt) THEN
4710: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4711: END IF;
4712: IF (x_return_status = FND_API.g_ret_sts_error) THEN
4713: RAISE FND_API.g_exc_error;

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

4706: p_req_encumbrance_flag => p_req_encumbrance_flag,
4707: p_skip_valid_cbc_acct_date => FND_API.G_FALSE); --Bug#4569120
4708: d_pos := 20;
4709: IF (PO_LOG.d_stmt) THEN
4710: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4711: END IF;
4712: IF (x_return_status = FND_API.g_ret_sts_error) THEN
4713: RAISE FND_API.g_exc_error;
4714: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 4728: IF (PO_LOG.d_stmt) THEN

4724: ,p_document_type => p_doc_type
4725: ,p_document_id => p_doc_header_id);
4726: END IF;
4727: d_pos := 40;
4728: IF (PO_LOG.d_stmt) THEN
4729: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4730: END IF;
4731: IF (x_return_status = FND_API.g_ret_sts_error) THEN
4732: RAISE FND_API.g_exc_error;

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

4725: ,p_document_id => p_doc_header_id);
4726: END IF;
4727: d_pos := 40;
4728: IF (PO_LOG.d_stmt) THEN
4729: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4730: END IF;
4731: IF (x_return_status = FND_API.g_ret_sts_error) THEN
4732: RAISE FND_API.g_exc_error;
4733: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 4751: IF (PO_LOG.d_stmt) THEN

4747: ,p_doc_type => p_doc_type
4748: ,p_doc_subtype => p_doc_subtype
4749: ,x_return_status => x_return_status);
4750: d_pos := 60;
4751: IF (PO_LOG.d_stmt) THEN
4752: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4753: END IF;
4754: IF (x_return_status = FND_API.g_ret_sts_error) THEN
4755: RAISE FND_API.g_exc_error;

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

4748: ,p_doc_subtype => p_doc_subtype
4749: ,x_return_status => x_return_status);
4750: d_pos := 60;
4751: IF (PO_LOG.d_stmt) THEN
4752: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4753: END IF;
4754: IF (x_return_status = FND_API.g_ret_sts_error) THEN
4755: RAISE FND_API.g_exc_error;
4756: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 4785: IF (PO_LOG.d_stmt) THEN

4781: ,x_cancel_req_flag_reset =>x_cancel_req_flag_reset
4782: ,x_is_encumbrance_error => x_is_encumbrance_error
4783: ,x_online_report_id => x_online_report_id);--bug#5055417
4784: d_pos := 80;
4785: IF (PO_LOG.d_stmt) THEN
4786: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4787: PO_LOG.stmt(d_module,d_pos,'x_approval_initiated',x_approval_initiated);
4788: END IF;
4789:

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

4782: ,x_is_encumbrance_error => x_is_encumbrance_error
4783: ,x_online_report_id => x_online_report_id);--bug#5055417
4784: d_pos := 80;
4785: IF (PO_LOG.d_stmt) THEN
4786: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4787: PO_LOG.stmt(d_module,d_pos,'x_approval_initiated',x_approval_initiated);
4788: END IF;
4789:
4790: IF (x_return_status = FND_API.g_ret_sts_error) THEN

Line 4787: PO_LOG.stmt(d_module,d_pos,'x_approval_initiated',x_approval_initiated);

4783: ,x_online_report_id => x_online_report_id);--bug#5055417
4784: d_pos := 80;
4785: IF (PO_LOG.d_stmt) THEN
4786: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
4787: PO_LOG.stmt(d_module,d_pos,'x_approval_initiated',x_approval_initiated);
4788: END IF;
4789:
4790: IF (x_return_status = FND_API.g_ret_sts_error) THEN
4791: RAISE FND_API.g_exc_error;

Line 4796: IF (PO_LOG.d_proc) THEN

4792: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
4793: RAISE FND_API.g_exc_unexpected_error;
4794: END IF;
4795:
4796: IF (PO_LOG.d_proc) THEN
4797: PO_LOG.proc_end(d_module);
4798: END IF;
4799: EXCEPTION
4800: WHEN FND_API.g_exc_error THEN

Line 4797: PO_LOG.proc_end(d_module);

4793: RAISE FND_API.g_exc_unexpected_error;
4794: END IF;
4795:
4796: IF (PO_LOG.d_proc) THEN
4797: PO_LOG.proc_end(d_module);
4798: END IF;
4799: EXCEPTION
4800: WHEN FND_API.g_exc_error THEN
4801: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;

Line 4813: IF PO_LOG.d_exc THEN

4809: END LOOP;
4810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4811: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;
4812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4813: IF PO_LOG.d_exc THEN
4814: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
4815: END IF;
4816: WHEN OTHERS THEN
4817: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;

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

4810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4811: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;
4812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4813: IF PO_LOG.d_exc THEN
4814: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
4815: END IF;
4816: WHEN OTHERS THEN
4817: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;
4818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4820: IF PO_LOG.d_exc THEN

4816: WHEN OTHERS THEN
4817: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;
4818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4819: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4820: IF PO_LOG.d_exc THEN
4821: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4822: END IF;
4823: END process_doc_control_action;
4824: -------------------------------------------------------------------------------

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

4817: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;
4818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4819: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4820: IF PO_LOG.d_exc THEN
4821: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4822: END IF;
4823: END process_doc_control_action;
4824: -------------------------------------------------------------------------------
4825: --Start of Comments

Line 4902: IF (PO_LOG.d_proc) THEN

4898: );
4899: l_dummy1 shipment_labor_expense_req_csr%ROWTYPE;
4900: l_dummy2 line_labor_expense_req_csr%ROWTYPE;
4901: BEGIN
4902: IF (PO_LOG.d_proc) THEN
4903: PO_LOG.proc_begin(d_module);
4904: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
4905: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4906: END IF;

Line 4903: PO_LOG.proc_begin(d_module);

4899: l_dummy1 shipment_labor_expense_req_csr%ROWTYPE;
4900: l_dummy2 line_labor_expense_req_csr%ROWTYPE;
4901: BEGIN
4902: IF (PO_LOG.d_proc) THEN
4903: PO_LOG.proc_begin(d_module);
4904: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
4905: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4906: END IF;
4907:

Line 4904: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);

4900: l_dummy2 line_labor_expense_req_csr%ROWTYPE;
4901: BEGIN
4902: IF (PO_LOG.d_proc) THEN
4903: PO_LOG.proc_begin(d_module);
4904: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
4905: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4906: END IF;
4907:
4908: IF(p_doc_level = PO_CORE_S.g_doc_level_LINE) THEN

Line 4905: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

4901: BEGIN
4902: IF (PO_LOG.d_proc) THEN
4903: PO_LOG.proc_begin(d_module);
4904: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
4905: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
4906: END IF;
4907:
4908: IF(p_doc_level = PO_CORE_S.g_doc_level_LINE) THEN
4909: l_po_line_id := p_doc_level_id;

Line 4931: IF (PO_LOG.d_proc) THEN

4927: CLOSE line_labor_expense_req_csr;
4928: d_pos := 50;
4929: END IF;
4930:
4931: IF (PO_LOG.d_proc) THEN
4932: PO_LOG.proc_end(d_module,'l_has_labor_expense_req',l_has_labor_expense_req);
4933: PO_LOG.proc_end(d_module,'l_line_location_id',l_line_location_id);
4934: PO_LOG.proc_end(d_module,'l_po_line_id',l_po_line_id);
4935: PO_LOG.proc_end(d_module);

Line 4932: PO_LOG.proc_end(d_module,'l_has_labor_expense_req',l_has_labor_expense_req);

4928: d_pos := 50;
4929: END IF;
4930:
4931: IF (PO_LOG.d_proc) THEN
4932: PO_LOG.proc_end(d_module,'l_has_labor_expense_req',l_has_labor_expense_req);
4933: PO_LOG.proc_end(d_module,'l_line_location_id',l_line_location_id);
4934: PO_LOG.proc_end(d_module,'l_po_line_id',l_po_line_id);
4935: PO_LOG.proc_end(d_module);
4936: END IF;

Line 4933: PO_LOG.proc_end(d_module,'l_line_location_id',l_line_location_id);

4929: END IF;
4930:
4931: IF (PO_LOG.d_proc) THEN
4932: PO_LOG.proc_end(d_module,'l_has_labor_expense_req',l_has_labor_expense_req);
4933: PO_LOG.proc_end(d_module,'l_line_location_id',l_line_location_id);
4934: PO_LOG.proc_end(d_module,'l_po_line_id',l_po_line_id);
4935: PO_LOG.proc_end(d_module);
4936: END IF;
4937:

Line 4934: PO_LOG.proc_end(d_module,'l_po_line_id',l_po_line_id);

4930:
4931: IF (PO_LOG.d_proc) THEN
4932: PO_LOG.proc_end(d_module,'l_has_labor_expense_req',l_has_labor_expense_req);
4933: PO_LOG.proc_end(d_module,'l_line_location_id',l_line_location_id);
4934: PO_LOG.proc_end(d_module,'l_po_line_id',l_po_line_id);
4935: PO_LOG.proc_end(d_module);
4936: END IF;
4937:
4938: return (l_has_labor_expense_req);

Line 4935: PO_LOG.proc_end(d_module);

4931: IF (PO_LOG.d_proc) THEN
4932: PO_LOG.proc_end(d_module,'l_has_labor_expense_req',l_has_labor_expense_req);
4933: PO_LOG.proc_end(d_module,'l_line_location_id',l_line_location_id);
4934: PO_LOG.proc_end(d_module,'l_po_line_id',l_po_line_id);
4935: PO_LOG.proc_end(d_module);
4936: END IF;
4937:
4938: return (l_has_labor_expense_req);
4939: EXCEPTION

Line 4942: IF PO_LOG.d_exc THEN

4938: return (l_has_labor_expense_req);
4939: EXCEPTION
4940: WHEN OTHERS THEN
4941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4942: IF PO_LOG.d_exc THEN
4943: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4944: END IF;
4945: RAISE;
4946: END is_backing_req_labor_expense;

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

4939: EXCEPTION
4940: WHEN OTHERS THEN
4941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4942: IF PO_LOG.d_exc THEN
4943: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4944: END IF;
4945: RAISE;
4946: END is_backing_req_labor_expense;
4947: -----------------------------------------------------------------------------

Line 5003: IF (PO_LOG.d_proc) THEN

4999: d_pos NUMBER;
5000: l_api_name CONSTANT VARCHAR2(30) := 'get_cancel_req_chkbox_attr';
5001: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_cancel_req_chkbox_attr';
5002: BEGIN
5003: IF (PO_LOG.d_proc) THEN
5004: PO_LOG.proc_begin(d_module);
5005: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5006: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5007: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

Line 5004: PO_LOG.proc_begin(d_module);

5000: l_api_name CONSTANT VARCHAR2(30) := 'get_cancel_req_chkbox_attr';
5001: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_cancel_req_chkbox_attr';
5002: BEGIN
5003: IF (PO_LOG.d_proc) THEN
5004: PO_LOG.proc_begin(d_module);
5005: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5006: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5007: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
5008: PO_LOG.proc_begin(d_module,'p_cancel_req_on_cancel_po',p_cancel_req_on_cancel_po);

Line 5005: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);

5001: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_cancel_req_chkbox_attr';
5002: BEGIN
5003: IF (PO_LOG.d_proc) THEN
5004: PO_LOG.proc_begin(d_module);
5005: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5006: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5007: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
5008: PO_LOG.proc_begin(d_module,'p_cancel_req_on_cancel_po',p_cancel_req_on_cancel_po);
5009: END IF;

Line 5006: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

5002: BEGIN
5003: IF (PO_LOG.d_proc) THEN
5004: PO_LOG.proc_begin(d_module);
5005: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5006: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5007: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
5008: PO_LOG.proc_begin(d_module,'p_cancel_req_on_cancel_po',p_cancel_req_on_cancel_po);
5009: END IF;
5010: d_pos := 10;

Line 5007: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);

5003: IF (PO_LOG.d_proc) THEN
5004: PO_LOG.proc_begin(d_module);
5005: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5006: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5007: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
5008: PO_LOG.proc_begin(d_module,'p_cancel_req_on_cancel_po',p_cancel_req_on_cancel_po);
5009: END IF;
5010: d_pos := 10;
5011: --Initialise Out Variables

Line 5008: PO_LOG.proc_begin(d_module,'p_cancel_req_on_cancel_po',p_cancel_req_on_cancel_po);

5004: PO_LOG.proc_begin(d_module);
5005: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5006: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5007: PO_LOG.proc_begin(d_module,'p_doc_subtype',p_doc_subtype);
5008: PO_LOG.proc_begin(d_module,'p_cancel_req_on_cancel_po',p_cancel_req_on_cancel_po);
5009: END IF;
5010: d_pos := 10;
5011: --Initialise Out Variables
5012: x_drop_ship_flag := 'N';

Line 5064: IF (PO_LOG.d_proc) THEN

5060: END IF; --p_doc_level = 'LINE'
5061: END IF; --p_doc_subtype = 'STANDARD'
5062: END IF; --p_cancel_req_on_cancel_po = 'A'
5063:
5064: IF (PO_LOG.d_proc) THEN
5065: PO_LOG.proc_end(d_module,'x_drop_ship_flag',x_drop_ship_flag);
5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);
5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);
5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);

Line 5065: PO_LOG.proc_end(d_module,'x_drop_ship_flag',x_drop_ship_flag);

5061: END IF; --p_doc_subtype = 'STANDARD'
5062: END IF; --p_cancel_req_on_cancel_po = 'A'
5063:
5064: IF (PO_LOG.d_proc) THEN
5065: PO_LOG.proc_end(d_module,'x_drop_ship_flag',x_drop_ship_flag);
5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);
5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);
5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);
5069: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);

Line 5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);

5062: END IF; --p_cancel_req_on_cancel_po = 'A'
5063:
5064: IF (PO_LOG.d_proc) THEN
5065: PO_LOG.proc_end(d_module,'x_drop_ship_flag',x_drop_ship_flag);
5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);
5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);
5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);
5069: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
5070: PO_LOG.proc_end(d_module);

Line 5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);

5063:
5064: IF (PO_LOG.d_proc) THEN
5065: PO_LOG.proc_end(d_module,'x_drop_ship_flag',x_drop_ship_flag);
5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);
5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);
5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);
5069: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
5070: PO_LOG.proc_end(d_module);
5071: END IF;

Line 5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);

5064: IF (PO_LOG.d_proc) THEN
5065: PO_LOG.proc_end(d_module,'x_drop_ship_flag',x_drop_ship_flag);
5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);
5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);
5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);
5069: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
5070: PO_LOG.proc_end(d_module);
5071: END IF;
5072:

Line 5069: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);

5065: PO_LOG.proc_end(d_module,'x_drop_ship_flag',x_drop_ship_flag);
5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);
5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);
5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);
5069: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
5070: PO_LOG.proc_end(d_module);
5071: END IF;
5072:
5073: EXCEPTION

Line 5070: PO_LOG.proc_end(d_module);

5066: PO_LOG.proc_end(d_module,'x_labor_expense_req_flag',x_labor_expense_req_flag);
5067: PO_LOG.proc_end(d_module,'x_svc_line_with_req_flag',x_svc_line_with_req_flag);
5068: PO_LOG.proc_end(d_module,'x_fps_line_ship_with_req_flag',x_fps_line_ship_with_req_flag);
5069: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
5070: PO_LOG.proc_end(d_module);
5071: END IF;
5072:
5073: EXCEPTION
5074: WHEN PO_CORE_S.g_early_return_exc THEN

Line 5075: IF PO_LOG.d_stmt THEN

5071: END IF;
5072:
5073: EXCEPTION
5074: WHEN PO_CORE_S.g_early_return_exc THEN
5075: IF PO_LOG.d_stmt THEN
5076: PO_LOG.stmt(d_module,d_pos,'Early exit from ' || d_module);
5077: END IF;
5078: WHEN OTHERS THEN
5079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5076: PO_LOG.stmt(d_module,d_pos,'Early exit from ' || d_module);

5072:
5073: EXCEPTION
5074: WHEN PO_CORE_S.g_early_return_exc THEN
5075: IF PO_LOG.d_stmt THEN
5076: PO_LOG.stmt(d_module,d_pos,'Early exit from ' || d_module);
5077: END IF;
5078: WHEN OTHERS THEN
5079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5080: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

Line 5081: IF PO_LOG.d_exc THEN

5077: END IF;
5078: WHEN OTHERS THEN
5079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5080: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
5081: IF PO_LOG.d_exc THEN
5082: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
5083: END IF;
5084: END get_cancel_req_chkbox_attr;
5085: ------------------------------------------------------------------------------

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

5078: WHEN OTHERS THEN
5079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5080: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
5081: IF PO_LOG.d_exc THEN
5082: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
5083: END IF;
5084: END get_cancel_req_chkbox_attr;
5085: ------------------------------------------------------------------------------
5086: --Start of Comments

Line 5146: IF (PO_LOG.d_proc) THEN

5142: d_pos NUMBER;
5143: l_api_name CONSTANT VARCHAR2(30) := 'get_valid_control_actions';
5144: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_valid_control_actions';
5145: BEGIN
5146: IF (PO_LOG.d_proc) THEN
5147: PO_LOG.proc_begin(d_module);
5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

Line 5147: PO_LOG.proc_begin(d_module);

5143: l_api_name CONSTANT VARCHAR2(30) := 'get_valid_control_actions';
5144: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_valid_control_actions';
5145: BEGIN
5146: IF (PO_LOG.d_proc) THEN
5147: PO_LOG.proc_begin(d_module);
5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
5151: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

Line 5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);

5144: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.get_valid_control_actions';
5145: BEGIN
5146: IF (PO_LOG.d_proc) THEN
5147: PO_LOG.proc_begin(d_module);
5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
5151: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
5152: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);

Line 5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);

5145: BEGIN
5146: IF (PO_LOG.d_proc) THEN
5147: PO_LOG.proc_begin(d_module);
5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
5151: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
5152: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5153: END IF;

Line 5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);

5146: IF (PO_LOG.d_proc) THEN
5147: PO_LOG.proc_begin(d_module);
5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
5151: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
5152: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5153: END IF;
5154: --Initialisation of local variables

Line 5151: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

5147: PO_LOG.proc_begin(d_module);
5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
5151: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
5152: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5153: END IF;
5154: --Initialisation of local variables
5155: x_return_status := FND_API.g_ret_sts_success;

Line 5152: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);

5148: PO_LOG.proc_begin(d_module,'p_mode',p_mode);
5149: PO_LOG.proc_begin(d_module,'p_doc_level',p_doc_level);
5150: PO_LOG.proc_begin(d_module,'p_doc_type',p_doc_type);
5151: PO_LOG.proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
5152: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
5153: END IF;
5154: --Initialisation of local variables
5155: x_return_status := FND_API.g_ret_sts_success;
5156: l_cons_trans_exist := 'N';

Line 5171: IF (PO_LOG.d_stmt) THEN

5167: FROM po_headers_all
5168: WHERE po_header_id = p_doc_header_id;
5169: END IF;
5170: d_pos := 20;
5171: IF (PO_LOG.d_stmt) THEN
5172: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);
5173: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
5174: END IF;
5175: IF (p_doc_level = PO_CORE_S.g_doc_level_HEADER) THEN --header level

Line 5172: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);

5168: WHERE po_header_id = p_doc_header_id;
5169: END IF;
5170: d_pos := 20;
5171: IF (PO_LOG.d_stmt) THEN
5172: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);
5173: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
5174: END IF;
5175: IF (p_doc_level = PO_CORE_S.g_doc_level_HEADER) THEN --header level
5176: d_pos := 30;

Line 5173: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);

5169: END IF;
5170: d_pos := 20;
5171: IF (PO_LOG.d_stmt) THEN
5172: PO_LOG.stmt(d_module,d_pos,'l_agent_id',l_agent_id);
5173: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
5174: END IF;
5175: IF (p_doc_level = PO_CORE_S.g_doc_level_HEADER) THEN --header level
5176: d_pos := 30;
5177: PO_DOCUMENT_CONTROL_PVT.get_header_actions

Line 5194: IF (PO_LOG.d_stmt) THEN

5190: INTO l_item_id
5191: FROM po_lines_all
5192: WHERE po_line_id = p_doc_level_id;
5193:
5194: IF (PO_LOG.d_stmt) THEN
5195: PO_LOG.stmt(d_module,d_pos,'l_item_id',l_agent_id);
5196: END IF;
5197:
5198: PO_DOCUMENT_CONTROL_PVT.get_line_actions

Line 5195: PO_LOG.stmt(d_module,d_pos,'l_item_id',l_agent_id);

5191: FROM po_lines_all
5192: WHERE po_line_id = p_doc_level_id;
5193:
5194: IF (PO_LOG.d_stmt) THEN
5195: PO_LOG.stmt(d_module,d_pos,'l_item_id',l_agent_id);
5196: END IF;
5197:
5198: PO_DOCUMENT_CONTROL_PVT.get_line_actions
5199: ( p_doc_subtype => l_doc_subtype

Line 5221: IF (PO_LOG.d_stmt) THEN

5217: , x_return_status => x_return_status
5218: , p_mode => l_mode);
5219:
5220: END IF;
5221: IF (PO_LOG.d_stmt) THEN
5222: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
5223: END IF;
5224: d_pos := 60;
5225:

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

5218: , p_mode => l_mode);
5219:
5220: END IF;
5221: IF (PO_LOG.d_stmt) THEN
5222: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
5223: END IF;
5224: d_pos := 60;
5225:
5226: IF (x_return_status = FND_API.g_ret_sts_success)then

Line 5236: IF (PO_LOG.d_stmt) THEN

5232: p_doc_header_id,
5233: l_item_id);
5234: END IF;
5235: d_pos := 70;
5236: IF (PO_LOG.d_stmt) THEN
5237: PO_LOG.stmt(d_module,d_pos,'l_cons_trans_exist',l_cons_trans_exist);
5238: END IF;
5239: --
5240: --Prevent cancel option for shipment if it is the only shipment on the

Line 5237: PO_LOG.stmt(d_module,d_pos,'l_cons_trans_exist',l_cons_trans_exist);

5233: l_item_id);
5234: END IF;
5235: d_pos := 70;
5236: IF (PO_LOG.d_stmt) THEN
5237: PO_LOG.stmt(d_module,d_pos,'l_cons_trans_exist',l_cons_trans_exist);
5238: END IF;
5239: --
5240: --Prevent cancel option for shipment if it is the only shipment on the
5241: --line that is not cancelled or finally closed.

Line 5264: IF PO_LOG.d_stmt THEN

5260: EXCEPTION
5261: WHEN NO_DATA_FOUND THEN
5262: --Current shipment is the only shipment on the line that is not cancelled or finally closed
5263: --OR there are no open, uncancelled shipments.
5264: IF PO_LOG.d_stmt THEN
5265: PO_LOG.stmt(d_module,d_pos,'Control Action cannot be performed on the shipment');
5266: END IF;
5267: l_ship_invalid_for_ctrl_actn := 'Y';
5268: END;

Line 5265: PO_LOG.stmt(d_module,d_pos,'Control Action cannot be performed on the shipment');

5261: WHEN NO_DATA_FOUND THEN
5262: --Current shipment is the only shipment on the line that is not cancelled or finally closed
5263: --OR there are no open, uncancelled shipments.
5264: IF PO_LOG.d_stmt THEN
5265: PO_LOG.stmt(d_module,d_pos,'Control Action cannot be performed on the shipment');
5266: END IF;
5267: l_ship_invalid_for_ctrl_actn := 'Y';
5268: END;
5269:

Line 5277: IF (PO_LOG.d_stmt) THEN

5273: FOR i IN l_valid_actions_tbl.first..l_valid_actions_tbl.last
5274: LOOP
5275: d_pos := 80;
5276: l_current_action := l_valid_actions_tbl(i);
5277: IF (PO_LOG.d_stmt) THEN
5278: PO_LOG.stmt(d_module,d_pos,'l_current_action',l_current_action);
5279: END IF;
5280: -- If consumption transaction exist we don't allow Cancel and Finally
5281: -- Close actions

Line 5278: PO_LOG.stmt(d_module,d_pos,'l_current_action',l_current_action);

5274: LOOP
5275: d_pos := 80;
5276: l_current_action := l_valid_actions_tbl(i);
5277: IF (PO_LOG.d_stmt) THEN
5278: PO_LOG.stmt(d_module,d_pos,'l_current_action',l_current_action);
5279: END IF;
5280: -- If consumption transaction exist we don't allow Cancel and Finally
5281: -- Close actions
5282: IF (l_cons_trans_exist = 'Y'

Line 5301: IF (PO_LOG.d_stmt) THEN

5297: x_valid_ctrl_ctn_tbl.extend;
5298: IF(l_mode = 'SUMMARY' AND l_current_action LIKE 'CANCEL%' ) THEN
5299: -- For Summary we Show Cancel Action as Cancel at all the Levels
5300: d_pos := 90;
5301: IF (PO_LOG.d_stmt) THEN
5302: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');
5303: END IF;
5304: x_valid_ctrl_ctn_tbl(l_index) := PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL;
5305: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN

Line 5302: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');

5298: IF(l_mode = 'SUMMARY' AND l_current_action LIKE 'CANCEL%' ) THEN
5299: -- For Summary we Show Cancel Action as Cancel at all the Levels
5300: d_pos := 90;
5301: IF (PO_LOG.d_stmt) THEN
5302: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');
5303: END IF;
5304: x_valid_ctrl_ctn_tbl(l_index) := PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL;
5305: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN
5306:

Line 5310: IF (PO_LOG.d_stmt) THEN

5306:
5307: IF(p_doc_type = PO_CORE_S.g_doc_type_PO) THEN
5308: -- For Update mode we Show Cancel Action at Header as Cancel Order
5309: d_pos := 100;
5310: IF (PO_LOG.d_stmt) THEN
5311: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL ORDER for update mode');
5312: END IF;
5313: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL ORDER';
5314: ELSIF(p_doc_type = PO_CORE_S.g_doc_type_PA) THEN

Line 5311: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL ORDER for update mode');

5307: IF(p_doc_type = PO_CORE_S.g_doc_type_PO) THEN
5308: -- For Update mode we Show Cancel Action at Header as Cancel Order
5309: d_pos := 100;
5310: IF (PO_LOG.d_stmt) THEN
5311: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL ORDER for update mode');
5312: END IF;
5313: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL ORDER';
5314: ELSIF(p_doc_type = PO_CORE_S.g_doc_type_PA) THEN
5315: -- For Update mode we Show Cancel Action at Header as Cancel Agreement.

Line 5317: IF (PO_LOG.d_stmt) THEN

5313: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL ORDER';
5314: ELSIF(p_doc_type = PO_CORE_S.g_doc_type_PA) THEN
5315: -- For Update mode we Show Cancel Action at Header as Cancel Agreement.
5316: d_pos := 110;
5317: IF (PO_LOG.d_stmt) THEN
5318: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL AGREEMENT for update mode');
5319: END IF;
5320: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL AGREEMENT';
5321: END IF; -- (p_doc_type = 'PO')

Line 5318: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL AGREEMENT for update mode');

5314: ELSIF(p_doc_type = PO_CORE_S.g_doc_type_PA) THEN
5315: -- For Update mode we Show Cancel Action at Header as Cancel Agreement.
5316: d_pos := 110;
5317: IF (PO_LOG.d_stmt) THEN
5318: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL AGREEMENT for update mode');
5319: END IF;
5320: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL AGREEMENT';
5321: END IF; -- (p_doc_type = 'PO')
5322: ELSE

Line 5324: IF (PO_LOG.d_stmt) THEN

5320: x_valid_ctrl_ctn_tbl(l_index) := 'CANCEL AGREEMENT';
5321: END IF; -- (p_doc_type = 'PO')
5322: ELSE
5323: d_pos := 120;
5324: IF (PO_LOG.d_stmt) THEN
5325: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is directly placed');
5326: END IF;
5327: x_valid_ctrl_ctn_tbl(l_index) := l_valid_actions_tbl(i);
5328: END IF; --mode = 'SUMMARY' AND l_current_action LIKE 'CANCEL%'

Line 5325: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is directly placed');

5321: END IF; -- (p_doc_type = 'PO')
5322: ELSE
5323: d_pos := 120;
5324: IF (PO_LOG.d_stmt) THEN
5325: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is directly placed');
5326: END IF;
5327: x_valid_ctrl_ctn_tbl(l_index) := l_valid_actions_tbl(i);
5328: END IF; --mode = 'SUMMARY' AND l_current_action LIKE 'CANCEL%'
5329: l_index := l_index+1;

Line 5336: IF (PO_LOG.d_stmt) THEN

5332: END LOOP;
5333:
5334: ELSIF (x_return_status = FND_API.g_ret_sts_error)then
5335: d_pos := 130;
5336: IF (PO_LOG.d_stmt) THEN
5337: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');
5338: END IF;
5339: ELSE
5340: d_pos := 140;

Line 5337: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');

5333:
5334: ELSIF (x_return_status = FND_API.g_ret_sts_error)then
5335: d_pos := 130;
5336: IF (PO_LOG.d_stmt) THEN
5337: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');
5338: END IF;
5339: ELSE
5340: d_pos := 140;
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5343: IF (PO_LOG.d_proc) THEN

5339: ELSE
5340: d_pos := 140;
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: END IF; --x_return_status = FND_API.g_ret_sts_success
5343: IF (PO_LOG.d_proc) THEN
5344: PO_LOG.proc_end(d_module);
5345: END IF;
5346: EXCEPTION
5347: WHEN OTHERS THEN

Line 5344: PO_LOG.proc_end(d_module);

5340: d_pos := 140;
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: END IF; --x_return_status = FND_API.g_ret_sts_success
5343: IF (PO_LOG.d_proc) THEN
5344: PO_LOG.proc_end(d_module);
5345: END IF;
5346: EXCEPTION
5347: WHEN OTHERS THEN
5348: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 5350: IF PO_LOG.d_exc THEN

5346: EXCEPTION
5347: WHEN OTHERS THEN
5348: x_return_status := FND_API.g_ret_sts_unexp_error;
5349: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
5350: IF PO_LOG.d_exc THEN
5351: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
5352: END IF;
5353: END get_valid_control_actions;
5354: END PO_Document_Control_PVT;

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

5347: WHEN OTHERS THEN
5348: x_return_status := FND_API.g_ret_sts_unexp_error;
5349: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
5350: IF PO_LOG.d_exc THEN
5351: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
5352: END IF;
5353: END get_valid_control_actions;
5354: END PO_Document_Control_PVT;