DBA Data[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 3956: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)

3952: BEGIN
3953:
3954: SAVEPOINT CANCEL_PRODTXN_PVT;
3955:
3956: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
3957: THEN
3958: Fnd_Log.STRING(Fnd_Log.level_procedure,
3959: 'csd.plsql.csd_logistics_util.cancel_prodtxn.begin',
3960: 'Entering cancel_prodtxn');

Line 3958: Fnd_Log.STRING(Fnd_Log.level_procedure,

3954: SAVEPOINT CANCEL_PRODTXN_PVT;
3955:
3956: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
3957: THEN
3958: Fnd_Log.STRING(Fnd_Log.level_procedure,
3959: 'csd.plsql.csd_logistics_util.cancel_prodtxn.begin',
3960: 'Entering cancel_prodtxn');
3961: --dbms_output.put_line('Entering');
3962: END IF;

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

4056: THEN
4057: COMMIT WORK;
4058: END IF;
4059:
4060: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
4061: THEN
4062: Fnd_Log.STRING(Fnd_Log.level_procedure,
4063: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4064: 'cancel_prodtxn completed');

Line 4062: Fnd_Log.STRING(Fnd_Log.level_procedure,

4058: END IF;
4059:
4060: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
4061: THEN
4062: Fnd_Log.STRING(Fnd_Log.level_procedure,
4063: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4064: 'cancel_prodtxn completed');
4065: END IF;
4066:

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

4082: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4083: p_data => x_msg_data);
4084: end if;
4085:
4086: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4087: THEN
4088: Fnd_Log.STRING(Fnd_Log.level_error,
4089: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4090: 'EXC_ERROR[' || x_msg_data || ']');

Line 4088: Fnd_Log.STRING(Fnd_Log.level_error,

4084: end if;
4085:
4086: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4087: THEN
4088: Fnd_Log.STRING(Fnd_Log.level_error,
4089: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4090: 'EXC_ERROR[' || x_msg_data || ']');
4091: END IF;
4092: --dbms_output.put_line('exec error raised');

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

4099: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4100: p_data => x_msg_data);
4101: end if;
4102:
4103: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4104: THEN
4105: Fnd_Log.STRING(Fnd_Log.level_exception,
4106: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4107: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 4105: Fnd_Log.STRING(Fnd_Log.level_exception,

4101: end if;
4102:
4103: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4104: THEN
4105: Fnd_Log.STRING(Fnd_Log.level_exception,
4106: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4107: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
4108: END IF;
4109: --dbms_output.put_line('unexpected error raised');

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

4122: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4123: p_data => x_msg_data);
4124: end if;
4125:
4126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4127: THEN
4128: Fnd_Log.STRING(Fnd_Log.level_exception,
4129: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4130: 'SQL MEssage[' || SQLERRM || ']');

Line 4128: Fnd_Log.STRING(Fnd_Log.level_exception,

4124: end if;
4125:
4126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4127: THEN
4128: Fnd_Log.STRING(Fnd_Log.level_exception,
4129: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4130: 'SQL MEssage[' || SQLERRM || ']');
4131: END IF;
4132: --dbms_output.put_line('other exception raised');

Line 4184: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

4180: -- Declare local variables
4181: l_api_name CONSTANT VARCHAR2(30) := 'set_rsv_rec';
4182: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4183: -- Variables to check the log level according to the coding standards
4184: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4185:
4186: -- Declare cursors
4187:
4188: BEGIN

Line 4192: fnd_log.string

4188: BEGIN
4189:
4190: -- Log API entry point
4191: IF (l_proc_level >= g_debug_level)THEN
4192: fnd_log.string
4193: (
4194: fnd_log.level_procedure,
4195: l_debug_module||'.start',
4196: 'At the start of PLSQL procedure'

Line 4194: fnd_log.level_procedure,

4190: -- Log API entry point
4191: IF (l_proc_level >= g_debug_level)THEN
4192: fnd_log.string
4193: (
4194: fnd_log.level_procedure,
4195: l_debug_module||'.start',
4196: 'At the start of PLSQL procedure'
4197: );
4198: END IF;

Line 4258: fnd_log.string

4254:
4255:
4256: -- Log API exit point
4257: IF (l_proc_level >= g_debug_level)THEN
4258: fnd_log.string
4259: (
4260: fnd_log.level_procedure,
4261: l_debug_module||'.end',
4262: 'At the end of PLSQL procedure'

Line 4260: fnd_log.level_procedure,

4256: -- Log API exit point
4257: IF (l_proc_level >= g_debug_level)THEN
4258: fnd_log.string
4259: (
4260: fnd_log.level_procedure,
4261: l_debug_module||'.end',
4262: 'At the end of PLSQL procedure'
4263: );
4264: END IF;

Line 4285: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

4281: -- Declare local variables
4282: l_api_name CONSTANT VARCHAR2(30) := 'reserve_serial_number';
4283: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4284: -- Variables to check the log level according to the coding standards
4285: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4286: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4287: l_msg_Count NUMBER;
4288: l_msg_data VARCHAR2(4000);
4289: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 4318: fnd_log.string

4314:
4315:
4316: -- Log API entry point
4317: IF (l_proc_level >= g_debug_level)THEN
4318: fnd_log.string
4319: (
4320: fnd_log.level_procedure,
4321: l_debug_module||'.start',
4322: 'At the start of PLSQL procedure'

Line 4320: fnd_log.level_procedure,

4316: -- Log API entry point
4317: IF (l_proc_level >= g_debug_level)THEN
4318: fnd_log.string
4319: (
4320: fnd_log.level_procedure,
4321: l_debug_module||'.start',
4322: 'At the start of PLSQL procedure'
4323: );
4324: END IF;

Line 4336: fnd_log.string

4332: l_rsv_qry_Inp.demand_source_line_id := p_serial_reserve_Rec.Order_Line_Id;
4333:
4334:
4335: IF (l_proc_level >= g_debug_level)THEN
4336: fnd_log.string
4337: (
4338: fnd_log.level_procedure,
4339: l_debug_module,
4340: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE, hdr id['

Line 4338: fnd_log.level_procedure,

4334:
4335: IF (l_proc_level >= g_debug_level)THEN
4336: fnd_log.string
4337: (
4338: fnd_log.level_procedure,
4339: l_debug_module,
4340: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE, hdr id['
4341: ||to_char(p_serial_reserve_Rec.Order_Header_Id) ||']line id['
4342: ||to_char(p_serial_reserve_Rec.Order_Line_Id)||']'

Line 4364: fnd_log.string

4360:
4361: IF(l_mtl_reservation_tbl_count > 0) THEN
4362:
4363: IF (l_proc_level >= g_debug_level)THEN
4364: fnd_log.string
4365: (
4366: fnd_log.level_procedure,
4367: l_debug_module,
4368: 'Reservations exist for the order header/line'

Line 4366: fnd_log.level_procedure,

4362:
4363: IF (l_proc_level >= g_debug_level)THEN
4364: fnd_log.string
4365: (
4366: fnd_log.level_procedure,
4367: l_debug_module,
4368: 'Reservations exist for the order header/line'
4369: );
4370: END IF;

Line 4439: fnd_log.string

4435: l_serial_rsv_tbl(1).serial_number := p_serial_reserve_Rec.serial_number;
4436:
4437:
4438: IF (l_proc_level >= g_debug_level)THEN
4439: fnd_log.string
4440: (
4441: fnd_log.level_procedure,
4442: l_debug_module,
4443: 'Calling update reservation api'

Line 4441: fnd_log.level_procedure,

4437:
4438: IF (l_proc_level >= g_debug_level)THEN
4439: fnd_log.string
4440: (
4441: fnd_log.level_procedure,
4442: l_debug_module,
4443: 'Calling update reservation api'
4444: );
4445: END IF;

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

4489: EXCEPTION
4490: WHEN Fnd_Api.g_exc_error THEN
4491: x_return_status := Fnd_Api.g_ret_sts_error;
4492:
4493: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4494: THEN
4495: Fnd_Log.STRING(Fnd_Log.level_error,
4496: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4497: 'EXC_ERROR[' || l_msg_data || ']');

Line 4495: Fnd_Log.STRING(Fnd_Log.level_error,

4491: x_return_status := Fnd_Api.g_ret_sts_error;
4492:
4493: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4494: THEN
4495: Fnd_Log.STRING(Fnd_Log.level_error,
4496: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4497: 'EXC_ERROR[' || l_msg_data || ']');
4498: END IF;
4499: --dbms_output.put_line('exec error raised');

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

4498: END IF;
4499: --dbms_output.put_line('exec error raised');
4500: WHEN Fnd_Api.g_exc_unexpected_error THEN
4501: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4503: THEN
4504: Fnd_Log.STRING(Fnd_Log.level_exception,
4505: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4506: 'EXC_UNEXP_ERROR[' || l_msg_data || ']');

Line 4504: Fnd_Log.STRING(Fnd_Log.level_exception,

4500: WHEN Fnd_Api.g_exc_unexpected_error THEN
4501: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4503: THEN
4504: Fnd_Log.STRING(Fnd_Log.level_exception,
4505: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4506: 'EXC_UNEXP_ERROR[' || l_msg_data || ']');
4507: END IF;
4508: --dbms_output.put_line('unexpected error raised');

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

4507: END IF;
4508: --dbms_output.put_line('unexpected error raised');
4509: WHEN OTHERS THEN
4510: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4511: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4512: THEN
4513: Fnd_Log.STRING(Fnd_Log.level_exception,
4514: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4515: 'SQL MEssage[' || SQLERRM || ']');

Line 4513: Fnd_Log.STRING(Fnd_Log.level_exception,

4509: WHEN OTHERS THEN
4510: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4511: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4512: THEN
4513: Fnd_Log.STRING(Fnd_Log.level_exception,
4514: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4515: 'SQL MEssage[' || SQLERRM || ']');
4516: END IF;
4517:

Line 4537: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

4533: -- Declare local variables
4534: l_api_name CONSTANT VARCHAR2(30) := 'unreserve_serial_number';
4535: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4536: -- Variables to check the log level according to the coding standards
4537: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4538: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4539: l_msg_Count NUMBER;
4540: l_msg_data VARCHAR2(4000);
4541: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 4559: fnd_log.string

4555:
4556: BEGIN
4557: -- Log API entry point
4558: IF (l_proc_level >= g_debug_level)THEN
4559: fnd_log.string
4560: (
4561: fnd_log.level_procedure,
4562: l_debug_module||'.start',
4563: 'At the start of PLSQL procedure'

Line 4561: fnd_log.level_procedure,

4557: -- Log API entry point
4558: IF (l_proc_level >= g_debug_level)THEN
4559: fnd_log.string
4560: (
4561: fnd_log.level_procedure,
4562: l_debug_module||'.start',
4563: 'At the start of PLSQL procedure'
4564: );
4565: END IF;

Line 4577: fnd_log.string

4573: l_rsv_qry_Inp.demand_source_line_id := p_serial_reserve_Rec.Order_Line_Id;
4574:
4575:
4576: IF (l_proc_level >= g_debug_level)THEN
4577: fnd_log.string
4578: (
4579: fnd_log.level_procedure,
4580: l_debug_module,
4581: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE'

Line 4579: fnd_log.level_procedure,

4575:
4576: IF (l_proc_level >= g_debug_level)THEN
4577: fnd_log.string
4578: (
4579: fnd_log.level_procedure,
4580: l_debug_module,
4581: 'Calling reservation api, QUERY_RESERVATION_OM_HDR_LINE'
4582: );
4583: END IF;

Line 4606: fnd_log.string

4602:
4603:
4604:
4605: IF (l_proc_level >= g_debug_level)THEN
4606: fnd_log.string
4607: (
4608: fnd_log.level_procedure,
4609: l_debug_module,
4610: 'Reservations exist for the order header/line'

Line 4608: fnd_log.level_procedure,

4604:
4605: IF (l_proc_level >= g_debug_level)THEN
4606: fnd_log.string
4607: (
4608: fnd_log.level_procedure,
4609: l_debug_module,
4610: 'Reservations exist for the order header/line'
4611: );
4612: END IF;