45: l_msg_count NUMBER;
46: l_dummy NUMBER;
47: BEGIN
48:
49: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
50: fnd_log.string
51: (
52: fnd_log.level_procedure,
53: 'ahl.plsql.AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results.begin',
46: l_dummy NUMBER;
47: BEGIN
48:
49: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
50: fnd_log.string
51: (
52: fnd_log.level_procedure,
53: 'ahl.plsql.AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results.begin',
54: 'At the start of PLSQL procedure'
48:
49: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
50: fnd_log.string
51: (
52: fnd_log.level_procedure,
53: 'ahl.plsql.AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results.begin',
54: 'At the start of PLSQL procedure'
55: );
56: END IF;
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
75: fnd_log.string
76: (
77: fnd_log.level_statement,
78: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
75: fnd_log.string
76: (
77: fnd_log.level_statement,
78: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
79: 'Request for Update Scheduled Sales Orders Number of Records : ' || p_sched_Orders_tbl.COUNT
73:
74: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
75: fnd_log.string
76: (
77: fnd_log.level_statement,
78: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
79: 'Request for Update Scheduled Sales Orders Number of Records : ' || p_sched_Orders_tbl.COUNT
80: );
81:
111: IF FND_API.TO_BOOLEAN(p_commit) THEN
112: COMMIT WORK;
113: END IF;
114:
115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string
117: (
118: fnd_log.level_procedure,
119: 'ahl.plsql.AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results.end',
112: COMMIT WORK;
113: END IF;
114:
115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string
117: (
118: fnd_log.level_procedure,
119: 'ahl.plsql.AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results.end',
120: 'At the end of PLSQL procedure'
114:
115: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string
117: (
118: fnd_log.level_procedure,
119: 'ahl.plsql.AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results.end',
120: 'At the end of PLSQL procedure'
121: );
122: END IF;