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.

[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on FND_LOG

Line 37: G_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

33: C_SERIAL_CONTROL_PREDEFINED CONSTANT NUMBER := 2;
34: /* R12 Srl reservation changes, end */
35:
36: -- Global variable for storing the debug level
37: G_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
38:
39: /*---------------------------------------------------------------------------*/
40: /* procedure name: Validate_PriceListID */
41: /* description : Validate Price List for a given Price List Id */

Line 93: -- Variables used in FND Log

89: PROCEDURE DEBUG(p_message IN VARCHAR2,
90: p_mod_name IN VARCHAR2,
91: p_severity_level IN NUMBER) IS
92:
93: -- Variables used in FND Log
94: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;

Line 94: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

90: p_mod_name IN VARCHAR2,
91: p_severity_level IN NUMBER) IS
92:
93: -- Variables used in FND Log
94: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
98: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

Line 95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

91: p_severity_level IN NUMBER) IS
92:
93: -- Variables used in FND Log
94: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
98: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
99: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

Line 96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;

92:
93: -- Variables used in FND Log
94: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
98: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
99: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
100:

Line 97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;

93: -- Variables used in FND Log
94: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
98: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
99: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
100:
101: BEGIN

Line 98: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

94: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
98: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
99: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
100:
101: BEGIN
102:

Line 99: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

95: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
96: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
97: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
98: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
99: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
100:
101: BEGIN
102:
103: IF p_severity_level = 1

Line 107: Fnd_Log.STRING(l_stat_level, p_mod_name, p_message);

103: IF p_severity_level = 1
104: THEN
105: IF (l_stat_level >= G_debug_level)
106: THEN
107: Fnd_Log.STRING(l_stat_level, p_mod_name, p_message);
108: END IF;
109: ELSIF p_severity_level = 2
110: THEN
111: IF (l_proc_level >= G_debug_level)

Line 113: Fnd_Log.STRING(l_proc_level, p_mod_name, p_message);

109: ELSIF p_severity_level = 2
110: THEN
111: IF (l_proc_level >= G_debug_level)
112: THEN
113: Fnd_Log.STRING(l_proc_level, p_mod_name, p_message);
114: END IF;
115: ELSIF p_severity_level = 3
116: THEN
117: IF (l_event_level >= G_debug_level)

Line 119: Fnd_Log.STRING(l_event_level, p_mod_name, p_message);

115: ELSIF p_severity_level = 3
116: THEN
117: IF (l_event_level >= G_debug_level)
118: THEN
119: Fnd_Log.STRING(l_event_level, p_mod_name, p_message);
120: END IF;
121: ELSIF p_severity_level = 4
122: THEN
123: IF (l_excep_level >= G_debug_level)

Line 125: Fnd_Log.STRING(l_excep_level, p_mod_name, p_message);

121: ELSIF p_severity_level = 4
122: THEN
123: IF (l_excep_level >= G_debug_level)
124: THEN
125: Fnd_Log.STRING(l_excep_level, p_mod_name, p_message);
126: END IF;
127: ELSIF p_severity_level = 5
128: THEN
129: IF (l_error_level >= G_debug_level)

Line 131: Fnd_Log.STRING(l_error_level, p_mod_name, p_message);

127: ELSIF p_severity_level = 5
128: THEN
129: IF (l_error_level >= G_debug_level)
130: THEN
131: Fnd_Log.STRING(l_error_level, p_mod_name, p_message);
132: END IF;
133: ELSIF p_severity_level = 6
134: THEN
135: IF (l_unexp_level >= G_debug_level)

Line 137: Fnd_Log.STRING(l_unexp_level, p_mod_name, p_message);

133: ELSIF p_severity_level = 6
134: THEN
135: IF (l_unexp_level >= G_debug_level)
136: THEN
137: Fnd_Log.STRING(l_unexp_level, p_mod_name, p_message);
138: END IF;
139: END IF;
140:
141: END DEBUG;

Line 3970: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)

3966: BEGIN
3967:
3968: SAVEPOINT CANCEL_PRODTXN_PVT;
3969:
3970: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
3971: THEN
3972: Fnd_Log.STRING(Fnd_Log.level_procedure,
3973: 'csd.plsql.csd_logistics_util.cancel_prodtxn.begin',
3974: 'Entering cancel_prodtxn');

Line 3972: Fnd_Log.STRING(Fnd_Log.level_procedure,

3968: SAVEPOINT CANCEL_PRODTXN_PVT;
3969:
3970: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
3971: THEN
3972: Fnd_Log.STRING(Fnd_Log.level_procedure,
3973: 'csd.plsql.csd_logistics_util.cancel_prodtxn.begin',
3974: 'Entering cancel_prodtxn');
3975: --dbms_output.put_line('Entering');
3976: END IF;

Line 4074: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)

4070: THEN
4071: COMMIT WORK;
4072: END IF;
4073:
4074: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
4075: THEN
4076: Fnd_Log.STRING(Fnd_Log.level_procedure,
4077: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4078: 'cancel_prodtxn completed');

Line 4076: Fnd_Log.STRING(Fnd_Log.level_procedure,

4072: END IF;
4073:
4074: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
4075: THEN
4076: Fnd_Log.STRING(Fnd_Log.level_procedure,
4077: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4078: 'cancel_prodtxn completed');
4079: END IF;
4080:

Line 4100: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

4096: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4097: p_data => x_msg_data);
4098: end if;
4099:
4100: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4101: THEN
4102: Fnd_Log.STRING(Fnd_Log.level_error,
4103: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4104: 'EXC_ERROR[' || x_msg_data || ']');

Line 4102: Fnd_Log.STRING(Fnd_Log.level_error,

4098: end if;
4099:
4100: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4101: THEN
4102: Fnd_Log.STRING(Fnd_Log.level_error,
4103: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4104: 'EXC_ERROR[' || x_msg_data || ']');
4105: END IF;
4106: --dbms_output.put_line('exec error raised');

Line 4117: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

4113: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4114: p_data => x_msg_data);
4115: end if;
4116:
4117: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4118: THEN
4119: Fnd_Log.STRING(Fnd_Log.level_exception,
4120: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4121: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 4119: Fnd_Log.STRING(Fnd_Log.level_exception,

4115: end if;
4116:
4117: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4118: THEN
4119: Fnd_Log.STRING(Fnd_Log.level_exception,
4120: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4121: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
4122: END IF;
4123: --dbms_output.put_line('unexpected error raised');

Line 4140: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

4136: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4137: p_data => x_msg_data);
4138: end if;
4139:
4140: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4141: THEN
4142: Fnd_Log.STRING(Fnd_Log.level_exception,
4143: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4144: 'SQL MEssage[' || SQLERRM || ']');

Line 4142: Fnd_Log.STRING(Fnd_Log.level_exception,

4138: end if;
4139:
4140: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4141: THEN
4142: Fnd_Log.STRING(Fnd_Log.level_exception,
4143: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4144: 'SQL MEssage[' || SQLERRM || ']');
4145: END IF;
4146: --dbms_output.put_line('other exception raised');

Line 4198: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

4194: -- Declare local variables
4195: l_api_name CONSTANT VARCHAR2(30) := 'set_rsv_rec';
4196: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4197: -- Variables to check the log level according to the coding standards
4198: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4199:
4200: -- Declare cursors
4201:
4202: BEGIN

Line 4206: fnd_log.string

4202: BEGIN
4203:
4204: -- Log API entry point
4205: IF (l_proc_level >= g_debug_level)THEN
4206: fnd_log.string
4207: (
4208: fnd_log.level_procedure,
4209: l_debug_module||'.start',
4210: 'At the start of PLSQL procedure'

Line 4208: fnd_log.level_procedure,

4204: -- Log API entry point
4205: IF (l_proc_level >= g_debug_level)THEN
4206: fnd_log.string
4207: (
4208: fnd_log.level_procedure,
4209: l_debug_module||'.start',
4210: 'At the start of PLSQL procedure'
4211: );
4212: END IF;

Line 4272: fnd_log.string

4268:
4269:
4270: -- Log API exit point
4271: IF (l_proc_level >= g_debug_level)THEN
4272: fnd_log.string
4273: (
4274: fnd_log.level_procedure,
4275: l_debug_module||'.end',
4276: 'At the end of PLSQL procedure'

Line 4274: fnd_log.level_procedure,

4270: -- Log API exit point
4271: IF (l_proc_level >= g_debug_level)THEN
4272: fnd_log.string
4273: (
4274: fnd_log.level_procedure,
4275: l_debug_module||'.end',
4276: 'At the end of PLSQL procedure'
4277: );
4278: END IF;

Line 4299: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

4295: -- Declare local variables
4296: l_api_name CONSTANT VARCHAR2(30) := 'reserve_serial_number';
4297: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4298: -- Variables to check the log level according to the coding standards
4299: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4300: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4301: l_msg_Count NUMBER;
4302: l_msg_data VARCHAR2(4000);
4303: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 4332: fnd_log.string

4328:
4329:
4330: -- Log API entry point
4331: IF (l_proc_level >= g_debug_level)THEN
4332: fnd_log.string
4333: (
4334: fnd_log.level_procedure,
4335: l_debug_module||'.start',
4336: 'At the start of PLSQL procedure'

Line 4334: fnd_log.level_procedure,

4330: -- Log API entry point
4331: IF (l_proc_level >= g_debug_level)THEN
4332: fnd_log.string
4333: (
4334: fnd_log.level_procedure,
4335: l_debug_module||'.start',
4336: 'At the start of PLSQL procedure'
4337: );
4338: END IF;

Line 4350: fnd_log.string

4346: l_rsv_qry_Inp.demand_source_line_id := p_serial_reserve_Rec.Order_Line_Id;
4347:
4348:
4349: IF (l_proc_level >= g_debug_level)THEN
4350: fnd_log.string
4351: (
4352: fnd_log.level_procedure,
4353: l_debug_module,
4354: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE, hdr id['

Line 4352: fnd_log.level_procedure,

4348:
4349: IF (l_proc_level >= g_debug_level)THEN
4350: fnd_log.string
4351: (
4352: fnd_log.level_procedure,
4353: l_debug_module,
4354: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE, hdr id['
4355: ||to_char(p_serial_reserve_Rec.Order_Header_Id) ||']line id['
4356: ||to_char(p_serial_reserve_Rec.Order_Line_Id)||']'

Line 4378: fnd_log.string

4374:
4375: IF(l_mtl_reservation_tbl_count > 0) THEN
4376:
4377: IF (l_proc_level >= g_debug_level)THEN
4378: fnd_log.string
4379: (
4380: fnd_log.level_procedure,
4381: l_debug_module,
4382: 'Reservations exist for the order header/line'

Line 4380: fnd_log.level_procedure,

4376:
4377: IF (l_proc_level >= g_debug_level)THEN
4378: fnd_log.string
4379: (
4380: fnd_log.level_procedure,
4381: l_debug_module,
4382: 'Reservations exist for the order header/line'
4383: );
4384: END IF;

Line 4453: fnd_log.string

4449: l_serial_rsv_tbl(1).serial_number := p_serial_reserve_Rec.serial_number;
4450:
4451:
4452: IF (l_proc_level >= g_debug_level)THEN
4453: fnd_log.string
4454: (
4455: fnd_log.level_procedure,
4456: l_debug_module,
4457: 'Calling update reservation api'

Line 4455: fnd_log.level_procedure,

4451:
4452: IF (l_proc_level >= g_debug_level)THEN
4453: fnd_log.string
4454: (
4455: fnd_log.level_procedure,
4456: l_debug_module,
4457: 'Calling update reservation api'
4458: );
4459: END IF;

Line 4507: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

4503: EXCEPTION
4504: WHEN Fnd_Api.g_exc_error THEN
4505: x_return_status := Fnd_Api.g_ret_sts_error;
4506:
4507: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4508: THEN
4509: Fnd_Log.STRING(Fnd_Log.level_error,
4510: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4511: 'EXC_ERROR[' || l_msg_data || ']');

Line 4509: Fnd_Log.STRING(Fnd_Log.level_error,

4505: x_return_status := Fnd_Api.g_ret_sts_error;
4506:
4507: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4508: THEN
4509: Fnd_Log.STRING(Fnd_Log.level_error,
4510: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4511: 'EXC_ERROR[' || l_msg_data || ']');
4512: END IF;
4513: --dbms_output.put_line('exec error raised');

Line 4516: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

4512: END IF;
4513: --dbms_output.put_line('exec error raised');
4514: WHEN Fnd_Api.g_exc_unexpected_error THEN
4515: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4516: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4517: THEN
4518: Fnd_Log.STRING(Fnd_Log.level_exception,
4519: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4520: 'EXC_UNEXP_ERROR[' || l_msg_data || ']');

Line 4518: Fnd_Log.STRING(Fnd_Log.level_exception,

4514: WHEN Fnd_Api.g_exc_unexpected_error THEN
4515: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4516: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4517: THEN
4518: Fnd_Log.STRING(Fnd_Log.level_exception,
4519: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4520: 'EXC_UNEXP_ERROR[' || l_msg_data || ']');
4521: END IF;
4522: --dbms_output.put_line('unexpected error raised');

Line 4525: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

4521: END IF;
4522: --dbms_output.put_line('unexpected error raised');
4523: WHEN OTHERS THEN
4524: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4525: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4526: THEN
4527: Fnd_Log.STRING(Fnd_Log.level_exception,
4528: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4529: 'SQL MEssage[' || SQLERRM || ']');

Line 4527: Fnd_Log.STRING(Fnd_Log.level_exception,

4523: WHEN OTHERS THEN
4524: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4525: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4526: THEN
4527: Fnd_Log.STRING(Fnd_Log.level_exception,
4528: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4529: 'SQL MEssage[' || SQLERRM || ']');
4530: END IF;
4531:

Line 4551: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

4547: -- Declare local variables
4548: l_api_name CONSTANT VARCHAR2(30) := 'unreserve_serial_number';
4549: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4550: -- Variables to check the log level according to the coding standards
4551: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4552: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4553: l_msg_Count NUMBER;
4554: l_msg_data VARCHAR2(4000);
4555: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 4573: fnd_log.string

4569:
4570: BEGIN
4571: -- Log API entry point
4572: IF (l_proc_level >= g_debug_level)THEN
4573: fnd_log.string
4574: (
4575: fnd_log.level_procedure,
4576: l_debug_module||'.start',
4577: 'At the start of PLSQL procedure'

Line 4575: fnd_log.level_procedure,

4571: -- Log API entry point
4572: IF (l_proc_level >= g_debug_level)THEN
4573: fnd_log.string
4574: (
4575: fnd_log.level_procedure,
4576: l_debug_module||'.start',
4577: 'At the start of PLSQL procedure'
4578: );
4579: END IF;

Line 4591: fnd_log.string

4587: l_rsv_qry_Inp.demand_source_line_id := p_serial_reserve_Rec.Order_Line_Id;
4588:
4589:
4590: IF (l_proc_level >= g_debug_level)THEN
4591: fnd_log.string
4592: (
4593: fnd_log.level_procedure,
4594: l_debug_module,
4595: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE'

Line 4593: fnd_log.level_procedure,

4589:
4590: IF (l_proc_level >= g_debug_level)THEN
4591: fnd_log.string
4592: (
4593: fnd_log.level_procedure,
4594: l_debug_module,
4595: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE'
4596: );
4597: END IF;

Line 4620: fnd_log.string

4616:
4617:
4618:
4619: IF (l_proc_level >= g_debug_level)THEN
4620: fnd_log.string
4621: (
4622: fnd_log.level_procedure,
4623: l_debug_module,
4624: 'Reservations exist for the order header/line'

Line 4622: fnd_log.level_procedure,

4618:
4619: IF (l_proc_level >= g_debug_level)THEN
4620: fnd_log.string
4621: (
4622: fnd_log.level_procedure,
4623: l_debug_module,
4624: 'Reservations exist for the order header/line'
4625: );
4626: END IF;