DBA Data[Home] [Help]

APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on AHL_DEBUG_PUB

Line 8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_SERN_CHANGE_PVT';
8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
9:
10: -------------------------------------------------
11: -- Declare Local Procedures --
12: -------------------------------------------------

Line 572: AHL_DEBUG_PUB.enable_debug;

568: -------------------------------------------------------------
569: -- Check if API is called in debug mode. If yes, enable debug
570: -------------------------------------------------------------.
571: IF G_DEBUG='Y' THEN
572: AHL_DEBUG_PUB.enable_debug;
573: END IF;
574:
575: --------------
576: -- Debug info.

Line 579: AHL_DEBUG_PUB.debug( 'enter ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

575: --------------
576: -- Debug info.
577: --------------
578: IF G_DEBUG='Y' THEN
579: AHL_DEBUG_PUB.debug( 'enter ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
580: END IF;
581:
582: ------------------------------------------------
583: -- Standard call to check for call compatibility.

Line 1163: AHL_DEBUG_PUB.debug('Delete_Reservation failed for Reservation ID: '

1159: p_reservation_id => GET_SRC_RES_ID_REC.RESERVATION_ID);
1160: -- Check return status.
1161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1162: IF ( G_DEBUG = 'Y' ) THEN
1163: AHL_DEBUG_PUB.debug('Delete_Reservation failed for Reservation ID: '
1164: || GET_SRC_RES_ID_REC.RESERVATION_ID);
1165: END IF; -- G_DEBUG.
1166:
1167: EXIT;

Line 1196: Ahl_Debug_Pub.debug( 'End of private api Process Serialnum Change','+PRDSRN+');

1192: END IF;
1193:
1194: -- Debug info
1195: IF G_DEBUG='Y' THEN
1196: Ahl_Debug_Pub.debug( 'End of private api Process Serialnum Change','+PRDSRN+');
1197: -- Check if API is called in debug mode. If yes, disable debug.
1198: Ahl_Debug_Pub.disable_debug;
1199: END IF;
1200:

Line 1198: Ahl_Debug_Pub.disable_debug;

1194: -- Debug info
1195: IF G_DEBUG='Y' THEN
1196: Ahl_Debug_Pub.debug( 'End of private api Process Serialnum Change','+PRDSRN+');
1197: -- Check if API is called in debug mode. If yes, disable debug.
1198: Ahl_Debug_Pub.disable_debug;
1199: END IF;
1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1209: AHL_DEBUG_PUB.log_app_messages (

1205: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208: IF G_DEBUG='Y' THEN
1209: AHL_DEBUG_PUB.log_app_messages (
1210: x_msg_count, x_msg_data, 'ERROR' );
1211: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1212: -- Check if API is called in debug mode. If yes, disable debug.
1213: AHL_DEBUG_PUB.disable_debug;

Line 1211: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

1207: p_data => x_msg_data);
1208: IF G_DEBUG='Y' THEN
1209: AHL_DEBUG_PUB.log_app_messages (
1210: x_msg_count, x_msg_data, 'ERROR' );
1211: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1212: -- Check if API is called in debug mode. If yes, disable debug.
1213: AHL_DEBUG_PUB.disable_debug;
1214: END IF;
1215:

Line 1213: AHL_DEBUG_PUB.disable_debug;

1209: AHL_DEBUG_PUB.log_app_messages (
1210: x_msg_count, x_msg_data, 'ERROR' );
1211: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1212: -- Check if API is called in debug mode. If yes, disable debug.
1213: AHL_DEBUG_PUB.disable_debug;
1214: END IF;
1215:
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: ROLLBACK TO Process_Serialnum_Change;

Line 1224: AHL_DEBUG_PUB.log_app_messages (

1220: p_count => x_msg_count,
1221: p_data => X_msg_data);
1222: IF G_DEBUG='Y' THEN
1223: -- Debug info.
1224: AHL_DEBUG_PUB.log_app_messages (
1225: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1226: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1227: -- Check if API is called in debug mode. If yes, disable debug.
1228: AHL_DEBUG_PUB.disable_debug;

Line 1226: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

1222: IF G_DEBUG='Y' THEN
1223: -- Debug info.
1224: AHL_DEBUG_PUB.log_app_messages (
1225: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1226: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1227: -- Check if API is called in debug mode. If yes, disable debug.
1228: AHL_DEBUG_PUB.disable_debug;
1229: END IF;
1230: WHEN OTHERS THEN

Line 1228: AHL_DEBUG_PUB.disable_debug;

1224: AHL_DEBUG_PUB.log_app_messages (
1225: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1226: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1227: -- Check if API is called in debug mode. If yes, disable debug.
1228: AHL_DEBUG_PUB.disable_debug;
1229: END IF;
1230: WHEN OTHERS THEN
1231: ROLLBACK TO Process_Serialnum_Change;
1232: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1244: AHL_DEBUG_PUB.log_app_messages (

1240: p_count => x_msg_count,
1241: p_data => X_msg_data);
1242: IF G_DEBUG='Y' THEN
1243: -- Debug info.
1244: AHL_DEBUG_PUB.log_app_messages (
1245: x_msg_count, x_msg_data, 'SQL ERROR' );
1246: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1247: -- Check if API is called in debug mode. If yes, disable debug.
1248: AHL_DEBUG_PUB.disable_debug;

Line 1246: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');

1242: IF G_DEBUG='Y' THEN
1243: -- Debug info.
1244: AHL_DEBUG_PUB.log_app_messages (
1245: x_msg_count, x_msg_data, 'SQL ERROR' );
1246: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1247: -- Check if API is called in debug mode. If yes, disable debug.
1248: AHL_DEBUG_PUB.disable_debug;
1249: END IF;
1250:

Line 1248: AHL_DEBUG_PUB.disable_debug;

1244: AHL_DEBUG_PUB.log_app_messages (
1245: x_msg_count, x_msg_data, 'SQL ERROR' );
1246: AHL_DEBUG_PUB.debug( 'ahl_prd_sern_change_pvt. Process Serialnum Change','+PRDSRN+');
1247: -- Check if API is called in debug mode. If yes, disable debug.
1248: AHL_DEBUG_PUB.disable_debug;
1249: END IF;
1250:
1251: END Process_Serialnum_Change;
1252: